Файловый менеджер - Редактировать - /home/easybachat/hisabat365.com/4a7891/database.tar
Ðазад
.gitignore 0000644 00000000012 15060170000 0006512 0 ustar 00 *.sqlite* factories/UserFactory.php 0000644 00000001705 15060170000 0011472 0 ustar 00 <?php namespace Database\Factories; use Illuminate\Database\Eloquent\Factories\Factory; use Illuminate\Support\Str; class UserFactory extends Factory { /** * Define the model's default state. * * @return array */ public function definition() { return [ 'name' => $this->faker->name(), 'email' => $this->faker->unique()->safeEmail(), 'email_verified_at' => now(), 'password' => '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', // password 'remember_token' => Str::random(10), ]; } /** * Indicate that the model's email address should be unverified. * * @return \Illuminate\Database\Eloquent\Factories\Factory */ public function unverified() { return $this->state(function (array $attributes) { return [ 'email_verified_at' => null, ]; }); } } migrations/2019_03_19_133922_create_product_units_table.php 0000664 00000001273 15060170000 0017130 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateProductUnitsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('product_units', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('unit_name'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('product_units'); } } migrations/2018_06_01_080940_create_settings_table.php 0000664 00000001217 15060170000 0016056 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSettingsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('settings', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->longText('value'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('settings'); } } migrations/2020_12_16_070412_create_purchase_return_item_taxes_table.php 0000664 00000001624 15060170000 0021640 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePurchaseReturnItemTaxesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('purchase_return_item_taxes', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('purchase_return_id'); $table->bigInteger('purchase_return_item_id'); $table->bigInteger('tax_id'); $table->string('name',100); $table->decimal('amount',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('purchase_return_item_taxes'); } } migrations/2020_08_21_063443_add_related_to_company_email_template.php 0000664 00000001312 15060170000 0021236 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class AddRelatedToCompanyEmailTemplate extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::table('company_email_template', function (Blueprint $table) { $table->string('related_to')->after('body')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('company_email_template', function (Blueprint $table) { $table->dropColumn(['related_to']); }); } } migrations/2020_05_24_153224_create_leads_table.php 0000664 00000002725 15060170000 0015304 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateLeadsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('leads', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',50); $table->string('company_name',50)->nullable(); $table->string('email')->nullable(); $table->integer('converted_lead')->nullable(); $table->bigInteger('lead_status_id'); $table->bigInteger('lead_source_id'); $table->bigInteger('assigned_user_id'); $table->bigInteger('created_user_id'); $table->date('contact_date'); $table->string('phone',20)->nullable(); $table->string('website')->nullable(); $table->string('country',50)->nullable(); $table->string('currency',3); $table->string('vat_id')->nullable(); $table->string('reg_no')->nullable(); $table->string('city',50)->nullable(); $table->string('state',50)->nullable(); $table->string('zip',20)->nullable(); $table->text('address')->nullable(); $table->longText('custom_fields')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('leads'); } } migrations/2020_06_22_095143_create_project_members_table.php 0000664 00000001261 15060170000 0017372 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateProjectMembersTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('project_members', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('project_id'); $table->bigInteger('user_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('project_members'); } } migrations/2020_12_13_150320_create_invoice_item_taxes_table.php 0000664 00000001555 15060170000 0020060 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateInvoiceItemTaxesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('invoice_item_taxes', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('invoice_id'); $table->bigInteger('invoice_item_id'); $table->bigInteger('tax_id'); $table->string('name',100); $table->decimal('amount',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('invoice_item_taxes'); } } migrations/2020_06_03_112519_create_files_table.php 0000664 00000001427 15060170000 0015314 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateFilesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('files', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('related_to',20)->nullable(); $table->bigInteger('related_id')->nullable(); $table->text('file'); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('files'); } } migrations/2019_11_08_143607_create_group_chat_message_status_table.php 0000664 00000001471 15060170000 0021466 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateGroupChatMessageStatusTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('group_chat_message_status', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('message_id'); $table->bigInteger('group_id'); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('group_chat_message_status'); } } migrations/2014_10_12_100000_create_password_resets_table.php 0000664 00000001253 15060170000 0017412 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePasswordResetsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('password_resets', function (Blueprint $table) { $table->string('email')->index(); $table->string('token'); $table->timestamp('created_at')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('password_resets'); } } migrations/2018_10_28_104344_create_contacts_table.php 0000664 00000003045 15060170000 0016034 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateContactsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('contacts', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('profile_type',20); $table->string('company_name',50)->nullable(); $table->string('contact_name',50); $table->string('contact_email',100); $table->string('vat_id')->nullable(); $table->string('reg_no')->nullable(); $table->string('contact_phone',20)->nullable(); $table->string('country',50)->nullable(); $table->string('currency',3); $table->string('city',50)->nullable(); $table->string('state',50)->nullable(); $table->string('zip',20)->nullable(); $table->text('address')->nullable(); $table->string('facebook')->nullable(); $table->string('twitter')->nullable(); $table->string('linkedin')->nullable(); $table->text('remarks')->nullable(); $table->string('contact_image')->nullable(); $table->bigInteger('group_id')->nullable(); $table->bigInteger('user_id')->nullable(); $table->bigInteger('company_id'); $table->longText('custom_fields')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('contacts'); } } migrations/2020_12_17_065847_create_sales_return_item_taxes_table.php 0000664 00000001605 15060170000 0021155 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSalesReturnItemTaxesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('sales_return_item_taxes', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('sales_return_id'); $table->bigInteger('sales_return_item_id'); $table->bigInteger('tax_id'); $table->string('name',100); $table->decimal('amount',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('sales_return_item_taxes'); } } migrations/2020_05_18_104400_create_invoice_templates_table.php 0000664 00000001504 15060170000 0017713 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateInvoiceTemplatesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('invoice_templates', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->longText('body'); $table->longText('editor'); $table->text('custom_css')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('invoice_templates'); } } migrations/2018_10_28_101819_create_contact_groups_table.php 0000664 00000001352 15060170000 0017253 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateContactGroupsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('contact_groups', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',50); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('contact_groups'); } } migrations/2020_03_21_070022_create_packages_table.php 0000664 00000002617 15060170000 0015757 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePackagesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('packages', function (Blueprint $table) { $table->increments('id'); $table->string('package_name',50); $table->decimal('cost_per_month',10,2); $table->decimal('cost_per_year',10,2); $table->string('staff_limit'); $table->string('contacts_limit'); $table->string('invoice_limit'); $table->string('quotation_limit'); $table->string('recurring_transaction'); $table->string('live_chat'); $table->string('file_manager'); $table->string('inventory_module')->nullable(); $table->string('pos_module')->nullable(); $table->string('hrm_module')->nullable(); $table->string('payroll_module')->nullable(); $table->string('project_management_module')->nullable(); $table->string('online_payment'); $table->tinyInteger('is_featured')->default(0); $table->text('others')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('packages'); } } migrations/2018_11_13_063551_create_accounts_table.php 0000664 00000001434 15060170000 0016034 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateAccountsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('accounts', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('account_title'); $table->date('opening_date'); $table->string('account_number', 50)->nullable(); $table->string('account_currency', 3); $table->decimal('opening_balance', 10, 2); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('accounts'); } } migrations/2018_10_29_095644_create_items_table.php 0000664 00000001304 15060170000 0015350 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateItemsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('items', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('item_name'); $table->string('item_type'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('items'); } } migrations/2020_06_23_144512_create_tasks_table.php 0000664 00000002060 15060170000 0015331 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateTasksTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('tasks', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title'); $table->text('description')->nullable(); $table->bigInteger('project_id'); $table->bigInteger('milestone_id')->nullable(); $table->string('priority',15); $table->bigInteger('task_status_id'); $table->bigInteger('assigned_user_id')->nullable(); $table->date('start_date'); $table->date('end_date')->nullable(); $table->longText('custom_fields')->nullable(); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('tasks'); } } migrations/2018_10_29_100449_create_products_table.php 0000664 00000001750 15060170000 0016065 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateProductsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('products', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('item_id'); $table->bigInteger('supplier_id')->nullable(); $table->decimal('product_cost',10,2); $table->decimal('product_price',10,2); $table->string('product_unit',20); $table->string('tax_method',10); $table->bigInteger('tax_id')->nullable(); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('products'); } } migrations/2020_06_27_152210_create_notifications_table.php 0000664 00000001470 15060170000 0017057 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateNotificationsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('notifications', function (Blueprint $table) { $table->uuid('id')->primary(); $table->string('type'); $table->morphs('notifiable'); $table->text('data'); $table->bigInteger('user_id'); $table->timestamp('read_at')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('notifications'); } } migrations/2019_03_19_123527_create_company_settings_table.php 0000664 00000001313 15060170000 0017607 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCompanySettingsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('company_settings', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->longText('value'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('company_settings'); } } migrations/2020_06_03_112538_create_notes_table.php 0000664 00000001416 15060170000 0015341 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateNotesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('notes', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('related_to',20)->nullable(); $table->bigInteger('related_id')->nullable(); $table->text('note'); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('notes'); } } migrations/2019_06_23_055645_create_company_email_template_table.php 0000664 00000001431 15060170000 0020735 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCompanyEmailTemplateTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('company_email_template', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->string('subject'); $table->text('body'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('company_email_template'); } } migrations/2020_03_21_052934_create_companies_table.php 0000664 00000003151 15060170000 0016165 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCompaniesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('companies', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('business_name'); $table->integer('status')->unsigned(); $table->integer('package_id')->nullable(); $table->string('package_type',10)->nullable(); $table->string('membership_type',10)->nullable(); $table->date('valid_to'); $table->date('last_email')->nullable(); $table->string('staff_limit',20)->nullable(); $table->string('contacts_limit',20)->nullable(); $table->string('invoice_limit',20)->nullable(); $table->string('quotation_limit',20)->nullable(); $table->string('recurring_transaction',3)->nullable(); $table->string('live_chat',3)->nullable(); $table->string('file_manager',3)->nullable(); $table->string('inventory_module',3)->nullable(); $table->string('pos_module',3)->nullable(); $table->string('hrm_module',3)->nullable(); $table->string('payroll_module',3)->nullable(); $table->string('project_management_module',3)->nullable(); $table->string('online_payment',3)->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('companies'); } } migrations/2019_05_11_080519_create_purchase_return_table.php 0000664 00000002303 15060170000 0017427 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePurchaseReturnTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('purchase_return', function (Blueprint $table) { $table->bigIncrements('id'); $table->date('return_date'); $table->bigInteger('supplier_id')->nullable(); $table->bigInteger('account_id'); $table->bigInteger('chart_id'); $table->bigInteger('payment_method_id'); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('product_total',10,2); $table->decimal('grand_total',10,2); $table->text('attachemnt')->nullable(); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('purchase_return'); } } migrations/2020_06_22_083001_create_projects_table.php 0000664 00000002177 15060170000 0016040 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateProjectsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('projects', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->bigInteger('client_id'); $table->integer('progress')->nullable(); $table->string('billing_type',20); $table->string('status',20); $table->decimal('fixed_rate',10,2)->nullable(); $table->decimal('hourly_rate',10,2)->nullable(); $table->date('start_date'); $table->date('end_date')->nullable(); $table->text('description')->nullable(); $table->longText('custom_fields')->nullable(); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('projects'); } } migrations/2019_03_19_070903_create_current_stocks_table.php 0000664 00000001325 15060170000 0017273 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCurrentStocksTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('current_stocks', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('product_id'); $table->decimal('quantity',8,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('current_stocks'); } } migrations/2020_05_24_153000_create_lead_sources_table.php 0000664 00000001327 15060170000 0016651 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateLeadSourcesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('lead_sources', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title',50); $table->integer('order')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('lead_sources'); } } migrations/2020_04_02_160249_create_cm_email_subscribers_table.php 0000664 00000001307 15060170000 0020363 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCmEmailSubscribersTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('cm_email_subscribers', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('email'); $table->string('ip_address'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('cm_email_subscribers'); } } migrations/2018_11_13_082512_create_payment_methods_table.php 0000664 00000001266 15060170000 0017416 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePaymentMethodsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('payment_methods', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',50); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('payment_methods'); } } migrations/2018_11_12_152015_create_email_templates_table.php 0000664 00000001331 15060170000 0017347 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateEmailTemplatesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('email_templates', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->text('subject'); $table->longText('body'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('email_templates'); } } migrations/2018_11_13_141249_create_transactions_table.php 0000664 00000002676 15060170000 0016737 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateTransactionsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('transactions', function (Blueprint $table) { $table->bigIncrements('id'); $table->date('trans_date'); $table->bigInteger('account_id'); $table->bigInteger('chart_id'); $table->string('type',10); $table->string('dr_cr',2); $table->decimal('amount',10,2); $table->decimal('base_amount',10,2)->nullable(); $table->bigInteger('payer_payee_id')->nullable(); $table->bigInteger('invoice_id')->nullable(); $table->bigInteger('purchase_id')->nullable(); $table->bigInteger('purchase_return_id')->nullable(); $table->bigInteger('project_id')->nullable(); $table->bigInteger('payment_method_id'); $table->string('reference',50)->nullable(); $table->text('attachment')->nullable(); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('transactions'); } } migrations/2019_06_22_062221_create_sales_return_table.php 0000664 00000002140 15060170000 0016714 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSalesReturnTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('sales_return', function (Blueprint $table) { $table->bigIncrements('id'); $table->date('return_date'); $table->bigInteger('customer_id'); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('product_total',10,2); $table->decimal('grand_total',10,2); $table->decimal('converted_total',10,2)->nullable(); $table->text('attachemnt')->nullable(); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('sales_return'); } } migrations/2019_05_11_080546_create_purchase_return_items_table.php 0000664 00000002146 15060170000 0020635 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePurchaseReturnItemsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('purchase_return_items', function (Blueprint $table) { $table->bigIncrements('id'); $table->integer('purchase_return_id'); $table->bigInteger('product_id'); $table->decimal('quantity',10,2); $table->decimal('unit_cost',10,2); $table->decimal('discount',10,2); $table->string('tax_method',10)->nullable(); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('sub_total',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('purchase_return_items'); } } migrations/2019_03_20_113605_create_invoices_table.php 0000664 00000002344 15060170000 0016031 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateInvoicesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('invoices', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('invoice_number'); $table->date('invoice_date'); $table->date('due_date'); $table->decimal('grand_total',10,2); $table->decimal('tax_total',10,2); $table->decimal('paid',10,2)->nullable(); $table->decimal('converted_total',10,2)->nullable(); $table->string('status',20); $table->string('template',100)->nullable(); $table->text('note')->nullable(); $table->string('related_to',20)->nullable(); $table->bigInteger('related_id')->nullable(); $table->bigInteger('client_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('invoices'); } } migrations/2020_06_23_112159_create_task_statuses_table.php 0000664 00000001424 15060170000 0017106 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateTaskStatusesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('task_statuses', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title',30); $table->string('color',10); $table->integer('order')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('task_statuses'); } } migrations/2018_11_13_082226_create_chart_of_accounts_table.php 0000664 00000001353 15060170000 0017701 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateChartOfAccountsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('chart_of_accounts', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',50); $table->string('type',10); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('chart_of_accounts'); } } migrations/2020_10_19_082621_create_staff_roles_table.php 0000664 00000002435 15060170000 0016523 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateStaffRolesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('staff_roles', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',50); $table->text('description')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); Schema::table('permissions', function (Blueprint $table) { $table->dropColumn('user_id'); $table->bigInteger('role_id')->after('id'); }); Schema::table('users', function (Blueprint $table) { $table->bigInteger('role_id')->after('user_type')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('staff_roles'); Schema::table('permissions', function (Blueprint $table) { $table->dropColumn(['role_id']); $table->bigInteger('user_id')->after('id'); }); Schema::table('users', function (Blueprint $table) { $table->dropColumn(['role_id']); }); } } migrations/2018_11_14_134254_create_repeating_transactions_table.php 0000664 00000002450 15060170000 0020762 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateRepeatingTransactionsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('repeating_transactions', function (Blueprint $table) { $table->bigIncrements('id'); $table->date('trans_date'); $table->bigInteger('account_id'); $table->bigInteger('chart_id'); $table->string('type',10); $table->string('dr_cr',2); $table->decimal('amount',10,2); $table->decimal('base_amount',10,2)->nullable(); $table->bigInteger('payer_payee_id')->nullable(); $table->bigInteger('payment_method_id'); $table->string('reference',50)->nullable(); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->tinyInteger('status')->nullable()->default(0); $table->bigInteger('trans_id')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('repeating_transactions'); } } migrations/2020_04_02_155956_create_cm_features_table.php 0000664 00000001314 15060170000 0016513 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCmFeaturesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('cm_features', function (Blueprint $table) { $table->bigIncrements('id'); $table->text('icon'); $table->text('title'); $table->longText('content'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('cm_features'); } } migrations/2020_12_15_102722_create_purchase_order_item_taxes_table.php 0000664 00000001617 15060170000 0021435 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePurchaseOrderItemTaxesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('purchase_order_item_taxes', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('purchase_order_id'); $table->bigInteger('purchase_order_item_id'); $table->bigInteger('tax_id'); $table->string('name',100); $table->decimal('amount',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('purchase_order_item_taxes'); } } migrations/2020_10_20_080849_add_description_to_invoice_items.php 0000664 00000003511 15060170000 0020272 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class AddDescriptionToInvoiceItems extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::table('invoice_items', function (Blueprint $table) { $table->text('description')->after('item_id')->nullable(); }); Schema::table('quotation_items', function (Blueprint $table) { $table->text('description')->after('item_id')->nullable(); }); Schema::table('purchase_order_items', function (Blueprint $table) { $table->text('description')->after('product_id')->nullable(); }); Schema::table('purchase_return_items', function (Blueprint $table) { $table->text('description')->after('product_id')->nullable(); }); Schema::table('sales_return_items', function (Blueprint $table) { $table->text('description')->after('product_id')->nullable(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('invoice_items', function (Blueprint $table) { $table->dropColumn(['description']); }); Schema::table('quotation_items', function (Blueprint $table) { $table->dropColumn(['description']); }); Schema::table('purchase_order_items', function (Blueprint $table) { $table->dropColumn(['description']); }); Schema::table('purchase_return_items', function (Blueprint $table) { $table->dropColumn(['description']); }); Schema::table('sales_return_items', function (Blueprint $table) { $table->dropColumn(['description']); }); } } migrations/2018_10_28_151911_create_taxs_table.php 0000664 00000001364 15060170000 0015201 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateTaxsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('taxs', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('tax_name',30); $table->decimal('rate',10,2); $table->string('type',10); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('taxs'); } } migrations/2019_11_08_143329_create_group_chat_messages_table.php 0000664 00000001514 15060170000 0020245 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateGroupChatMessagesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('group_chat_messages', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('group_id'); $table->text('message'); $table->text('attachment')->nullable(); $table->bigInteger('sender_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('group_chat_messages'); } } migrations/2020_03_15_154649_create_currency_rates_table.php 0000664 00000001273 15060170000 0017253 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCurrencyRatesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('currency_rates', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('currency',3); $table->decimal('rate',10,6); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('currency_rates'); } } migrations/2018_10_29_101756_create_suppliers_table.php 0000664 00000002171 15060170000 0016250 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSuppliersTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('suppliers', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('supplier_name'); $table->string('company_name')->nullable(); $table->string('vat_number')->nullable(); $table->string('email'); $table->string('phone',20); $table->string('address')->nullable(); $table->string('country',50)->nullable(); $table->string('city',50)->nullable(); $table->string('state',50)->nullable(); $table->string('postal_code',20)->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('suppliers'); } } migrations/2019_12_14_000001_create_personal_access_tokens_table.php 0000644 00000001535 15060170000 0020724 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreatePersonalAccessTokensTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('personal_access_tokens', function (Blueprint $table) { $table->id(); $table->morphs('tokenable'); $table->string('name'); $table->string('token', 64)->unique(); $table->text('abilities')->nullable(); $table->timestamp('last_used_at')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('personal_access_tokens'); } } migrations/2019_03_07_084028_create_purchase_orders_table.php 0000664 00000002441 15060170000 0017413 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePurchaseOrdersTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('purchase_orders', function (Blueprint $table) { $table->bigIncrements('id'); $table->date('order_date'); $table->bigInteger('supplier_id'); $table->tinyInteger('order_status'); $table->bigInteger('order_tax_id')->nullable(); $table->decimal('order_tax',10,2)->nullable(); $table->decimal('order_discount',10,2); $table->decimal('shipping_cost',10,2); $table->decimal('product_total',10,2); $table->decimal('grand_total',10,2); $table->decimal('paid',10,2); $table->tinyInteger('payment_status'); $table->text('attachemnt')->nullable(); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('purchase_orders'); } } migrations/2019_03_20_113618_create_invoice_items_table.php 0000664 00000002076 15060170000 0017055 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateInvoiceItemsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('invoice_items', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('invoice_id'); $table->bigInteger('item_id'); $table->decimal('quantity',10,2); $table->decimal('unit_cost',10,2); $table->decimal('discount',10,2); $table->string('tax_method',10)->nullable(); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('sub_total',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('invoice_items'); } } migrations/2019_05_27_153712_create_quotation_items_table.php 0000664 00000002030 15060170000 0017442 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateQuotationItemsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('quotation_items', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('quotation_id'); $table->bigInteger('item_id'); $table->decimal('quantity',10,2); $table->decimal('unit_cost',10,2); $table->decimal('discount',10,2); $table->string('tax_method',10)->nullable(); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('sub_total',10,2); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('quotation_items'); } } migrations/2019_10_31_172912_create_social_google_accounts_table.php 0000664 00000001346 15060170000 0020726 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSocialGoogleAccountsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('social_google_accounts', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('user_id'); $table->string('provider_user_id'); $table->string('provider'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('social_google_accounts'); } } migrations/2019_11_08_063856_create_chat_group_users.php 0000664 00000001276 15060170000 0016443 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateChatGroupUsers extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('chat_group_users', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('group_id'); $table->bigInteger('user_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('chat_group_users'); } } migrations/2019_11_11_170656_create_file_manager_table.php 0000664 00000001671 15060170000 0016635 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateFileManagerTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('file_manager', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',64); $table->string('mime_type')->nullable(); $table->string('is_dir',3)->default('no'); $table->string('file')->nullable(); $table->bigInteger('parent_id')->nullable(); $table->bigInteger('company_id'); $table->bigInteger('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('file_manager'); } } migrations/2020_06_03_112553_create_activity_logs_table.php 0000664 00000001451 15060170000 0017065 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateActivityLogsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('activity_logs', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('related_to',20)->nullable(); $table->bigInteger('related_id')->nullable(); $table->text('activity'); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('activity_logs'); } } migrations/2020_12_15_055832_create_quotation_item_taxes_table.php 0000664 00000001567 15060170000 0020470 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateQuotationItemTaxesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('quotation_item_taxes', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('quotation_id'); $table->bigInteger('quotation_item_id'); $table->bigInteger('tax_id'); $table->string('name',100); $table->decimal('amount',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('quotation_item_taxes'); } } migrations/2019_03_07_085537_create_purchase_order_items_table.php 0000664 00000002144 15060170000 0020437 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePurchaseOrderItemsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('purchase_order_items', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('purchase_order_id'); $table->bigInteger('product_id'); $table->decimal('quantity',8,2); $table->decimal('unit_cost',10,2); $table->decimal('discount',10,2); $table->string('tax_method',10)->nullable(); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('sub_total',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('purchase_order_items'); } } migrations/2019_06_22_062233_create_sales_return_items_table.php 0000664 00000002134 15060170000 0020123 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateSalesReturnItemsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('sales_return_items', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('sales_return_id'); $table->bigInteger('product_id'); $table->decimal('quantity',8,2); $table->decimal('unit_cost',10,2); $table->decimal('discount',10,2); $table->string('tax_method',10)->nullable(); $table->bigInteger('tax_id')->nullable(); $table->decimal('tax_amount',10,2)->nullable(); $table->decimal('sub_total',10,2); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('sales_return_items'); } } migrations/2019_08_19_000000_create_failed_jobs_table.php 0000644 00000001464 15060170000 0016450 0 ustar 00 <?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateFailedJobsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('failed_jobs', function (Blueprint $table) { $table->id(); $table->string('uuid')->unique(); $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'); } } migrations/2014_10_12_000000_create_users_table.php 0000664 00000002032 15060170000 0015317 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateUsersTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('users', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name'); $table->string('email')->unique(); $table->timestamp('email_verified_at')->nullable(); $table->string('password'); $table->string('user_type'); $table->string('profile_picture')->nullable(); $table->integer('status'); $table->string('language')->nullable(); $table->integer('company_id')->nullable(); $table->rememberToken(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('users'); } } migrations/2020_06_25_065937_create_timesheets_table.php 0000664 00000001567 15060170000 0016410 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateTimesheetsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('timesheets', function (Blueprint $table) { $table->bigIncrements('id'); $table->datetime('start_time'); $table->datetime('end_time'); $table->string('total_hour',20); $table->bigInteger('user_id'); $table->bigInteger('project_id'); $table->bigInteger('task_id'); $table->text('note')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('timesheets'); } } migrations/2018_10_29_101301_create_services_table.php 0000664 00000001461 15060170000 0016030 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateServicesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('services', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('item_id'); $table->decimal('cost',10,2); $table->string('tax_method',10); $table->bigInteger('tax_id')->nullable(); $table->text('description')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('services'); } } migrations/2019_11_07_105822_create_chat_groups_table.php 0000664 00000001426 15060170000 0016536 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateChatGroupsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('chat_groups', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('name',50); $table->text('description')->nullable(); $table->bigInteger('company_id'); $table->bigInteger('created_by'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('chat_groups'); } } migrations/2020_04_02_160209_create_cm_faqs_table.php 0000664 00000001240 15060170000 0015610 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateCmFaqsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('cm_faqs', function (Blueprint $table) { $table->bigIncrements('id'); $table->text('question'); $table->longText('answer'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('cm_faqs'); } } migrations/2019_11_04_133151_create_chat_messages_table.php 0000664 00000001560 15060170000 0017016 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateChatMessagesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('chat_messages', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('from'); $table->bigInteger('to'); $table->text('message'); $table->text('attachment')->nullable(); $table->tinyInteger('status')->default(0); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('chat_messages'); } } migrations/2020_05_24_152947_create_lead_statuses_table.php 0000664 00000001424 15060170000 0017062 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateLeadStatusesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('lead_statuses', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title',30); $table->string('color',10); $table->integer('order')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('lead_statuses'); } } migrations/2020_06_23_083455_create_project_milestones_table.php 0000664 00000001621 15060170000 0020126 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateProjectMilestonesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('project_milestones', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('title'); $table->text('description')->nullable(); $table->date('due_date'); $table->string('status',20); $table->decimal('cost',10,2)->nullable(); $table->bigInteger('project_id'); $table->bigInteger('user_id'); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('project_milestones'); } } migrations/2018_11_17_142037_create_payment_histories_table.php 0000664 00000001735 15060170000 0017770 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePaymentHistoriesTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('payment_histories', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('company_id'); $table->string('title'); $table->string('method',20)->nullable(); $table->string('currency',3)->nullable(); $table->decimal('amount',10,2); $table->integer('package_id'); $table->string('package_type',10); $table->string('status',10); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('payment_histories'); } } migrations/2018_08_29_084110_create_permissions_table.php 0000664 00000001264 15060170000 0016600 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreatePermissionsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('permissions', function (Blueprint $table) { $table->bigIncrements('id'); $table->bigInteger('user_id'); $table->string('permission'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('permissions'); } } migrations/2019_05_27_153656_create_quotations_table.php 0000664 00000002105 15060170000 0016436 0 ustar 00 <?php use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; class CreateQuotationsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('quotations', function (Blueprint $table) { $table->bigIncrements('id'); $table->string('quotation_number'); $table->date('quotation_date'); $table->string('template',100)->nullable(); $table->decimal('grand_total',10,2); $table->decimal('converted_total',10,2)->nullable(); $table->decimal('tax_total',10,2); $table->text('note')->nullable(); $table->string('related_to',20)->nullable(); $table->bigInteger('related_id')->nullable(); $table->bigInteger('company_id'); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('quotations'); } } seeders/DatabaseSeeder.php 0000644 00000000446 15060170000 0011534 0 ustar 00 <?php namespace Database\Seeders; use Illuminate\Database\Seeder; class DatabaseSeeder extends Seeder { /** * Seed the application's database. * * @return void */ public function run() { $this->call([ UtilitySeeder::class, ]); } } seeders/UtilitySeeder.php 0000644 00000054342 15060170000 0011477 0 ustar 00 <?php namespace Database\Seeders; use Illuminate\Database\Seeder; use Illuminate\Support\Facades\DB; class UtilitySeeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { //Default Settings DB::table('settings')->insert([ [ 'name' => 'mail_type', 'value' => 'mail', ], [ 'name' => 'backend_direction', 'value' => 'ltr', ], [ 'name' => 'language', 'value' => 'English', ], [ 'name' => 'membership_system', 'value' => 'enabled', ], [ 'name' => 'trial_period', 'value' => '7', ], [ 'name' => 'allow_singup', 'value' => 'yes', ], [ 'name' => 'email_verification', 'value' => 'disabled', ], [ 'name' => 'hero_title', 'value' => 'Start Your Business With Elit Kit', ], [ 'name' => 'hero_sub_title', 'value' => 'A simple, easy to customize, and powerful business platform for managing and tracking Projects, Tasks, Invoices, Quotations, Leads, Customers, Transactions and many more!', ], [ 'name' => 'meta_keywords', 'value' => 'invoice, projects, tasks, accounting, quotation, crm, business, erp, accounting software, live chat', ], [ 'name' => 'meta_description', 'value' => 'A simple, easy to customize, and powerful business platform for managing and tracking Projects, Tasks, Invoices, Quotations, Leads, Customers, Transactions and many more!', ], ]); //Email Template DB::table('email_templates')->insert([ [ 'name' => 'registration', 'subject' => 'Registration Sucessfully', 'body' => '<div style="padding: 15px 30px;"> <h2 style="color: #555555;">Registration Successful</h2> <p style="color: #555555;">Hi {name},<br /><span style="color: #555555;">Welcome to ElitKit and thank you for joining with us. You can now sign in to your account using your email and password.<br /><br />Regards<br />Tricky Code<br /></span></p> </div>', ], [ 'name' => 'premium_membership', 'subject' => 'Premium Membership', 'body' => '<div style="padding: 15px 30px;"> <h2 style="color: #555555; font-family: "PT Sans", sans-serif;">ElitKit Premium Subscription</h2> <p style="color: #555555; font-family: "PT Sans", sans-serif;">Hi {name},<br> <span style="color: #555555; font-family: "PT Sans", sans-serif;"><strong>Congratulations</strong> your paymnet was made sucessfully. Your current membership is valid <strong>until</strong> <strong>{valid_to}</strong></span><span style="color: #555555; font-family: "PT Sans", sans-serif;"><strong>.</strong> </span></p> <p><br style="color: #555555; font-family: "PT Sans", sans-serif;" /><span style="color: #555555; font-family: "PT Sans", sans-serif;">Thank You</span><br style="color: #555555; font-family: "PT Sans", sans-serif;" /><span style="color: #555555; font-family: "PT Sans", sans-serif;">Tricky Code</span></p> </div>', ], [ 'name' => 'alert_notification', 'subject' => 'ElitKit Renewals', 'body' => '<div style="padding: 15px 30px;"> <h2 style="color: #555555; font-family: "PT Sans", sans-serif;">Account Renew Notification</h2> <p style="color: #555555; font-family: "PT Sans", sans-serif;">Hi {name},<br> <span style="color: #555555; font-family: "PT Sans", sans-serif;">Your package is due to <strong>expire on {valid_to}</strong> s</span><span style="color: #555555; font-family: "PT Sans", sans-serif;">o you will need to renew by then to keep your account active.</span></p> <p><br style="color: #555555; font-family: "PT Sans", sans-serif;" /><span style="color: #555555; font-family: "PT Sans", sans-serif;">Regards</span><br style="color: #555555; font-family: "PT Sans", sans-serif;" /><span style="color: #555555; font-family: "PT Sans", sans-serif;">Tricky Code</span></p> </div>', ], ]); //Store Default Software Features DB::table('cm_features')->insert([ [ 'icon' => "<i class='lni lni-package'></i>", 'title' => "Easy Accounting", 'content' => "Manage Account without any accounting knowledge", ], [ 'icon' => "<i class='lni lni-files'></i>", 'title' => "Invoice", 'content' => "Create professional Invoice and accept online payments", ], [ 'icon' => "<i class='lni lni-user'></i>", 'title' => "CRM", 'content' => "Contacts with Contact Group and Rich Customer Portal", ], [ 'icon' => "<i class='lni lni-phone-set'></i>", 'title' => "Leads", 'content' => "Manage leads from different lead sources with kanban view", ], [ 'icon' => "<i class='lni lni-briefcase'></i>", 'title' => "Projects", 'content' => "Manage different types of projects with milestone", ], [ 'icon' => "<i class='lni lni-alarm'></i>", 'title' => "Tasks", 'content' => "Manage tasks with kanban view and assign task to staff", ], [ 'icon' => "<i class='lni lni-empty-file'></i>", 'title' => "Quotation", 'content' => "Create Professional Quotation for getting customer attention", ], [ 'icon' => "<i class='lni lni-facebook-messenger'></i>", 'title' => "Live Chat", 'content' => "Real time Chat with staffs, customers and private groups", ], [ 'icon' => "<i class='lni lni-credit-cards'></i>", 'title' => "Online Payments", 'content' => "Accept Online Payments from Clients", ], ]); //Store Deafult Package DB::table('packages')->insert([ [ 'package_name' => 'Basic', 'cost_per_month' => '10.00', 'cost_per_year' => '99.00', 'staff_limit' => 'a:2:{s:7:"monthly";s:1:"3";s:6:"yearly";s:2:"10";}', 'contacts_limit' => 'a:2:{s:7:"monthly";s:2:"10";s:6:"yearly";s:2:"30";}', 'invoice_limit' => 'a:2:{s:7:"monthly";s:2:"20";s:6:"yearly";s:3:"300";}', 'quotation_limit' => 'a:2:{s:7:"monthly";s:2:"20";s:6:"yearly";s:3:"300";}', 'project_management_module' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'recurring_transaction' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'live_chat' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'file_manager' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'inventory_module' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'hrm_module' => NULL, 'payroll_module' => NULL, 'online_payment' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'is_featured' => 0, 'others' => NULL, ], [ 'package_name' => 'Standard', 'cost_per_month' => '25.00', 'cost_per_year' => '199.00', 'staff_limit' => 'a:2:{s:7:"monthly";s:2:"10";s:6:"yearly";s:2:"20";}', 'contacts_limit' => 'a:2:{s:7:"monthly";s:2:"30";s:6:"yearly";s:2:"50";}', 'invoice_limit' => 'a:2:{s:7:"monthly";s:3:"300";s:6:"yearly";s:3:"500";}', 'quotation_limit' => 'a:2:{s:7:"monthly";s:3:"300";s:6:"yearly";s:3:"500";}', 'project_management_module' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'recurring_transaction' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'live_chat' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'file_manager' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'inventory_module' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'hrm_module' => NULL, 'payroll_module' => NULL, 'online_payment' => 'a:2:{s:7:"monthly";s:2:"No";s:6:"yearly";s:2:"No";}', 'is_featured' => 1, 'others' => NULL, ], [ 'package_name' => 'Business Plus', 'cost_per_month' => '40.00', 'cost_per_year' => '399.00', 'staff_limit' => 'a:2:{s:7:"monthly";s:2:"30";s:6:"yearly";s:9:"Unlimited";}', 'contacts_limit' => 'a:2:{s:7:"monthly";s:9:"Unlimited";s:6:"yearly";s:9:"Unlimited";}', 'invoice_limit' => 'a:2:{s:7:"monthly";s:3:"300";s:6:"yearly";s:9:"Unlimited";}', 'quotation_limit' => 'a:2:{s:7:"monthly";s:3:"300";s:6:"yearly";s:9:"Unlimited";}', 'project_management_module' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'recurring_transaction' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'live_chat' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'file_manager' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'inventory_module' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'hrm_module' => NULL, 'payroll_module' => NULL, 'online_payment' => 'a:2:{s:7:"monthly";s:3:"Yes";s:6:"yearly";s:3:"Yes";}', 'is_featured' => 0, 'others' => NULL, ], ]); //Store Default Currency Exchange Rate DB::table('currency_rates')->insert([ ['id' => 1, 'currency' => 'AED', 'rate' => 4.101083], ['id' => 2, 'currency' => 'AFN', 'rate' => 85.378309], ['id' => 3, 'currency' => 'ALL', 'rate' => 123.510844], ['id' => 4, 'currency' => 'AMD', 'rate' => 548.849773], ['id' => 5, 'currency' => 'ANG', 'rate' => 2.008050], ['id' => 6, 'currency' => 'AOA', 'rate' => 556.155120], ['id' => 7, 'currency' => 'ARS', 'rate' => 70.205746], ['id' => 8, 'currency' => 'AUD', 'rate' => 1.809050], ['id' => 9, 'currency' => 'AWG', 'rate' => 2.009782], ['id' => 10, 'currency' => 'AZN', 'rate' => 1.833159], ['id' => 11, 'currency' => 'BAM', 'rate' => 1.966840], ['id' => 12, 'currency' => 'BBD', 'rate' => 2.245460], ['id' => 13, 'currency' => 'BDT', 'rate' => 95.162306], ['id' => 14, 'currency' => 'BGN', 'rate' => 1.952383], ['id' => 15, 'currency' => 'BHD', 'rate' => 0.421787], ['id' => 16, 'currency' => 'BIF', 'rate' => 2117.865003], ['id' => 17, 'currency' => 'BMD', 'rate' => 1.116545], ['id' => 18, 'currency' => 'BND', 'rate' => 1.583270], ['id' => 19, 'currency' => 'BOB', 'rate' => 7.718004], ['id' => 20, 'currency' => 'BRL', 'rate' => 5.425949], ['id' => 21, 'currency' => 'BSD', 'rate' => 1.121775], ['id' => 22, 'currency' => 'BTC', 'rate' => 0.000244], ['id' => 23, 'currency' => 'BTN', 'rate' => 82.818317], ['id' => 24, 'currency' => 'BWP', 'rate' => 12.683055], ['id' => 25, 'currency' => 'BYN', 'rate' => 2.621037], ['id' => 26, 'currency' => 'BYR', 'rate' => 9999.999999], ['id' => 27, 'currency' => 'BZD', 'rate' => 2.261248], ['id' => 28, 'currency' => 'CAD', 'rate' => 1.552879], ['id' => 29, 'currency' => 'CDF', 'rate' => 1898.127343], ['id' => 30, 'currency' => 'CHF', 'rate' => 1.056023], ['id' => 31, 'currency' => 'CLF', 'rate' => 0.033950], ['id' => 32, 'currency' => 'CLP', 'rate' => 936.781769], ['id' => 33, 'currency' => 'CNY', 'rate' => 7.827878], ['id' => 34, 'currency' => 'COP', 'rate' => 4491.872864], ['id' => 35, 'currency' => 'CRC', 'rate' => 635.520417], ['id' => 36, 'currency' => 'CUC', 'rate' => 1.116545], ['id' => 37, 'currency' => 'CUP', 'rate' => 29.588450], ['id' => 38, 'currency' => 'CVE', 'rate' => 110.887227], ['id' => 39, 'currency' => 'CZK', 'rate' => 26.906059], ['id' => 40, 'currency' => 'DJF', 'rate' => 198.432393], ['id' => 41, 'currency' => 'DKK', 'rate' => 7.472892], ['id' => 42, 'currency' => 'DOP', 'rate' => 60.196240], ['id' => 43, 'currency' => 'DZD', 'rate' => 134.499489], ['id' => 44, 'currency' => 'EGP', 'rate' => 17.585483], ['id' => 45, 'currency' => 'ERN', 'rate' => 16.748349], ['id' => 46, 'currency' => 'ETB', 'rate' => 36.696587], ['id' => 47, 'currency' => 'EUR', 'rate' => 1.000000], ['id' => 48, 'currency' => 'FJD', 'rate' => 2.549240], ['id' => 49, 'currency' => 'FKP', 'rate' => 0.908257], ['id' => 50, 'currency' => 'GBP', 'rate' => 0.907964], ['id' => 51, 'currency' => 'GEL', 'rate' => 3.115301], ['id' => 52, 'currency' => 'GGP', 'rate' => 0.908257], ['id' => 53, 'currency' => 'GHS', 'rate' => 6.220337], ['id' => 54, 'currency' => 'GIP', 'rate' => 0.908257], ['id' => 55, 'currency' => 'GMD', 'rate' => 56.605069], ['id' => 56, 'currency' => 'GNF', 'rate' => 9999.999999], ['id' => 57, 'currency' => 'GTQ', 'rate' => 8.576324], ['id' => 58, 'currency' => 'GYD', 'rate' => 234.489495], ['id' => 59, 'currency' => 'HKD', 'rate' => 8.674753], ['id' => 60, 'currency' => 'HNL', 'rate' => 27.678062], ['id' => 61, 'currency' => 'HRK', 'rate' => 7.590196], ['id' => 62, 'currency' => 'HTG', 'rate' => 106.356510], ['id' => 63, 'currency' => 'HUF', 'rate' => 341.150311], ['id' => 64, 'currency' => 'IDR', 'rate' => 9999.999999], ['id' => 65, 'currency' => 'ILS', 'rate' => 4.159226], ['id' => 66, 'currency' => 'IMP', 'rate' => 0.908257], ['id' => 67, 'currency' => 'INR', 'rate' => 82.763894], ['id' => 68, 'currency' => 'IQD', 'rate' => 1339.198712], ['id' => 69, 'currency' => 'IRR', 'rate' => 9999.999999], ['id' => 70, 'currency' => 'ISK', 'rate' => 151.202539], ['id' => 71, 'currency' => 'JEP', 'rate' => 0.908257], ['id' => 72, 'currency' => 'JMD', 'rate' => 151.606351], ['id' => 73, 'currency' => 'JOD', 'rate' => 0.791685], ['id' => 74, 'currency' => 'JPY', 'rate' => 118.278988], ['id' => 75, 'currency' => 'KES', 'rate' => 115.283224], ['id' => 76, 'currency' => 'KGS', 'rate' => 81.395812], ['id' => 77, 'currency' => 'KHR', 'rate' => 4603.144194], ['id' => 78, 'currency' => 'KMF', 'rate' => 495.355724], ['id' => 79, 'currency' => 'KPW', 'rate' => 1004.922902], ['id' => 80, 'currency' => 'KRW', 'rate' => 1372.190164], ['id' => 81, 'currency' => 'KWD', 'rate' => 0.344879], ['id' => 82, 'currency' => 'KYD', 'rate' => 0.934921], ['id' => 83, 'currency' => 'KZT', 'rate' => 456.318281], ['id' => 84, 'currency' => 'LAK', 'rate' => 9978.233671], ['id' => 85, 'currency' => 'LBP', 'rate' => 1696.373291], ['id' => 86, 'currency' => 'LKR', 'rate' => 206.967335], ['id' => 87, 'currency' => 'LRD', 'rate' => 221.076044], ['id' => 88, 'currency' => 'LSL', 'rate' => 18.121543], ['id' => 89, 'currency' => 'LTL', 'rate' => 3.296868], ['id' => 90, 'currency' => 'LVL', 'rate' => 0.675387], ['id' => 91, 'currency' => 'LYD', 'rate' => 1.557311], ['id' => 92, 'currency' => 'MAD', 'rate' => 10.730569], ['id' => 93, 'currency' => 'MDL', 'rate' => 19.734707], ['id' => 94, 'currency' => 'MGA', 'rate' => 4165.265277], ['id' => 95, 'currency' => 'MKD', 'rate' => 61.516342], ['id' => 96, 'currency' => 'MMK', 'rate' => 1566.586511], ['id' => 97, 'currency' => 'MNT', 'rate' => 3088.650418], ['id' => 98, 'currency' => 'MOP', 'rate' => 8.975925], ['id' => 99, 'currency' => 'MRO', 'rate' => 398.607011], ['id' => 100, 'currency' => 'MUR', 'rate' => 43.205754], ['id' => 101, 'currency' => 'MVR', 'rate' => 17.250725], ['id' => 102, 'currency' => 'MWK', 'rate' => 825.239292], ['id' => 103, 'currency' => 'MXN', 'rate' => 24.963329], ['id' => 104, 'currency' => 'MYR', 'rate' => 4.810633], ['id' => 105, 'currency' => 'MZN', 'rate' => 73.591410], ['id' => 106, 'currency' => 'NAD', 'rate' => 18.121621], ['id' => 107, 'currency' => 'NGN', 'rate' => 408.099790], ['id' => 108, 'currency' => 'NIO', 'rate' => 37.844015], ['id' => 109, 'currency' => 'NOK', 'rate' => 11.405599], ['id' => 110, 'currency' => 'NPR', 'rate' => 132.508354], ['id' => 111, 'currency' => 'NZD', 'rate' => 1.847363], ['id' => 112, 'currency' => 'OMR', 'rate' => 0.429801], ['id' => 113, 'currency' => 'PAB', 'rate' => 1.121880], ['id' => 114, 'currency' => 'PEN', 'rate' => 3.958258], ['id' => 115, 'currency' => 'PGK', 'rate' => 3.838505], ['id' => 116, 'currency' => 'PHP', 'rate' => 57.698037], ['id' => 117, 'currency' => 'PKR', 'rate' => 176.121721], ['id' => 118, 'currency' => 'PLN', 'rate' => 4.386058], ['id' => 119, 'currency' => 'PYG', 'rate' => 7386.917924], ['id' => 120, 'currency' => 'QAR', 'rate' => 4.065302], ['id' => 121, 'currency' => 'RON', 'rate' => 4.826717], ['id' => 122, 'currency' => 'RSD', 'rate' => 117.627735], ['id' => 123, 'currency' => 'RUB', 'rate' => 83.568390], ['id' => 124, 'currency' => 'RWF', 'rate' => 1067.822267], ['id' => 125, 'currency' => 'SAR', 'rate' => 4.190432], ['id' => 126, 'currency' => 'SBD', 'rate' => 9.235251], ['id' => 127, 'currency' => 'SCR', 'rate' => 14.529548], ['id' => 128, 'currency' => 'SDG', 'rate' => 61.772847], ['id' => 129, 'currency' => 'SEK', 'rate' => 10.785247], ['id' => 130, 'currency' => 'SGD', 'rate' => 1.587844], ['id' => 131, 'currency' => 'SHP', 'rate' => 0.908257], ['id' => 132, 'currency' => 'SLL', 'rate' => 9999.999999], ['id' => 133, 'currency' => 'SOS', 'rate' => 653.732410], ['id' => 134, 'currency' => 'SRD', 'rate' => 8.327212], ['id' => 135, 'currency' => 'STD', 'rate' => 9999.999999], ['id' => 136, 'currency' => 'SVC', 'rate' => 9.816821], ['id' => 137, 'currency' => 'SYP', 'rate' => 575.019506], ['id' => 138, 'currency' => 'SZL', 'rate' => 18.038821], ['id' => 139, 'currency' => 'THB', 'rate' => 35.884679], ['id' => 140, 'currency' => 'TJS', 'rate' => 10.875343], ['id' => 141, 'currency' => 'TMT', 'rate' => 3.907909], ['id' => 142, 'currency' => 'TND', 'rate' => 3.186636], ['id' => 143, 'currency' => 'TOP', 'rate' => 2.635661], ['id' => 144, 'currency' => 'TRY', 'rate' => 7.131927], ['id' => 145, 'currency' => 'TTD', 'rate' => 7.585158], ['id' => 146, 'currency' => 'TWD', 'rate' => 33.739208], ['id' => 147, 'currency' => 'TZS', 'rate' => 2582.397529], ['id' => 148, 'currency' => 'UAH', 'rate' => 29.335146], ['id' => 149, 'currency' => 'UGX', 'rate' => 4169.685347], ['id' => 150, 'currency' => 'USD', 'rate' => 1.116545], ['id' => 151, 'currency' => 'UYU', 'rate' => 48.718630], ['id' => 152, 'currency' => 'UZS', 'rate' => 9999.999999], ['id' => 153, 'currency' => 'VEF', 'rate' => 11.151499], ['id' => 154, 'currency' => 'VND', 'rate' => 9999.999999], ['id' => 155, 'currency' => 'VUV', 'rate' => 133.944917], ['id' => 156, 'currency' => 'WST', 'rate' => 3.074259], ['id' => 157, 'currency' => 'XAF', 'rate' => 659.652615], ['id' => 158, 'currency' => 'XAG', 'rate' => 0.088073], ['id' => 159, 'currency' => 'XAU', 'rate' => 0.000756], ['id' => 160, 'currency' => 'XCD', 'rate' => 3.017519], ['id' => 161, 'currency' => 'XDR', 'rate' => 0.809234], ['id' => 162, 'currency' => 'XOF', 'rate' => 659.646672], ['id' => 163, 'currency' => 'XPF', 'rate' => 119.931356], ['id' => 164, 'currency' => 'YER', 'rate' => 279.475009], ['id' => 165, 'currency' => 'ZAR', 'rate' => 18.603040], ['id' => 166, 'currency' => 'ZMK', 'rate' => 9999.999999], ['id' => 167, 'currency' => 'ZMW', 'rate' => 17.892580], ['id' => 168, 'currency' => 'ZWL', 'rate' => 359.527584], ]); } }
| ver. 1.4 |
Github
|
.
| PHP 8.2.29 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка