mirror of
https://gitlab.com/CIEFWorldwideSdnBhd/shipping-portal.git
synced 2026-08-19 04:24:12 +00:00
edmondlang
115 lines
8.2 KiB
PHP
115 lines
8.2 KiB
PHP
<?php
|
|
namespace Database\Seeders;
|
|
|
|
use App\Classes\ValueObjects\Constants\SegmentConstants;
|
|
use App\Classes\ValueObjects\Constants\WarehouseReferences;
|
|
|
|
use App\Models\SegmentConstant;
|
|
use Illuminate\Database\Seeder;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class SegmentConstantsTableSeeder extends Seeder
|
|
{
|
|
|
|
private function insertData($segment_id=1, $reference, $array_data)
|
|
{
|
|
DB::beginTransaction();
|
|
DB::table('segment_constants')->insert([
|
|
'segment_id' => $segment_id,
|
|
'reference' => $reference,
|
|
'value' => json_encode($array_data)
|
|
]);
|
|
DB::commit();
|
|
}
|
|
|
|
public function run()
|
|
{
|
|
Segmentconstant::create( [
|
|
'segment_id'=>1,
|
|
'reference'=>'BASE_PRICE',
|
|
'value'=>'{"2022-09-21":"330.00","2022-09-22":"330.00","2022-09-23":"330.00","2022-09-24":"330.00","2022-09-25":"330.00","2022-09-26":"330.00","2022-09-27":"315.00","2022-09-28":"315.00","2022-09-29":"315.00","2022-09-30":"315.00","2022-08-22":"330.00","2022-08-23":"330.00","2022-08-24":"330.00","2022-08-25":"330.00","2022-08-26":"330.00","2022-08-27":"330.00","2022-08-28":"330.00","2022-08-29":"330.00","2022-08-30":"330.00","2022-08-31":"330.00","2022-09-01":"330.00","2022-09-02":"330.00","2022-09-03":"330.00","2022-09-04":"330.00","2022-09-05":"330.00","2022-09-06":"330.00","2022-09-07":"330.00","2022-09-08":"330.00","2022-09-09":"330.00","2022-09-10":"330.00","2022-09-11":"330.00","2022-09-12":"330.00","2022-09-13":"330.00","2022-09-14":"330.00","2022-09-15":"330.00","2022-09-16":"330.00","2022-09-17":"330.00","2022-09-18":"330.00","2022-09-19":"330.00","2022-09-20":"330.00","2022-10-01":"315.00","2022-10-02":"315.00","2022-10-03":"315.00","2022-10-04":"315.00","2022-10-05":"315.00","2022-10-06":"315.00","2022-10-07":"315.00","2022-10-08":"315.00","2022-10-09":"315.00","2022-10-10":"315.00","2022-10-11":"315.00","2022-10-12":"315.00","2022-10-13":"315.00","2022-10-14":"315.00","2022-10-15":"315.00","2022-10-16":"315.00","2022-10-17":"315.00","2022-10-18":"315.00","2022-10-19":"315.00","2022-10-20":"315.00","2022-10-21":"315.00","2022-10-22":"315.00","2022-10-23":"315.00","2022-10-24":"315.00","2022-10-25":"315.00","2022-10-26":"315.00","2022-10-27":"315.00","2022-10-28":"315.00","2022-10-29":"315.00","2022-10-30":"315.00","2022-10-31":"315.00","2022-11-01":"315.00","2022-11-02":"315.00","2022-11-03":"315.00","2022-11-04":"315.00","2022-11-05":"315.00","2022-11-06":"315.00","2022-11-07":"315.00","2022-11-08":"315.00","2022-11-09":"315.00","2022-11-10":"315.00","2022-11-11":"315.00","2022-11-12":"315.00","2022-11-13":"315.00","2022-11-14":"315.00","2022-11-15":"315.00","2022-11-16":"315.00","2022-11-17":"315.00","2022-11-18":"315.00","2022-11-19":"315.00","2022-11-20":"315.00","2022-11-21":"315.00","2022-11-22":"315.00","2022-11-23":"315.00","2022-11-24":"315.00","2022-11-25":"315.00","2022-11-26":"315.00","2022-11-27":"315.00","2022-11-28":"315.00","2022-11-29":"315.00","2022-11-30":"315.00","2022-12-01":"315.00","2022-12-02":"315.00","2022-12-03":"315.00","2022-12-04":"315.00","2022-12-05":"315.00","2022-12-06":"315.00","2022-12-07":"315.00","2022-12-08":"315.00","2022-12-09":"315.00","2022-12-10":"315.00","2022-12-11":"315.00","2022-12-12":"315.00","2022-12-13":"315.00","2022-12-14":"315.00","2022-12-15":"315.00","2022-12-16":"315.00","2022-12-17":"315.00","2022-12-18":"315.00","2022-12-19":"315.00","2022-12-20":"315.00","2022-12-21":"315.00","2022-12-22":"315.00","2022-12-23":"315.00","2022-12-24":"315.00","2022-12-25":"315.00","2022-12-26":"315.00","2022-12-27":"315.00","2022-12-28":"315.00","2022-12-29":"315.00","2022-12-30":"315.00","2022-12-31":"315.00"}',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>NULL,
|
|
'updated_at'=>'2022-09-27 01:16:14'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>1,
|
|
'reference'=>'STATE_RATE',
|
|
'value'=>'[{"state_id":1,"center":"10.00","outstation":"2.00"},{"center":"10.00","outstation":"10.00"},{"center":"10.00","outstation":"10.00"},{"center":"50.00","outstation":"50.00"},{"center":"12.00","outstation":"12.00"},{"center":"345.00","outstation":"345.00"},{"center":"10.00","outstation":"10.00"},{"center":"10.00","outstation":"10.00"},{"center":"10.00","outstation":"30.00"},{"center":"10.00","outstation":"20.00"},{"center":"10.00","outstation":"10.00"},{"center":"10.00","outstation":"10.00"},{"center":"15.00","outstation":"15.00"},{"center":"185.00","outstation":"23.00"},{"center":"185.00","outstation":"185.00"},{"center":"30.00","outstation":"30.00"},{"center":"50.00","outstation":"50.00"}]',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>NULL,
|
|
'updated_at'=>'2022-09-27 01:18:15'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>1,
|
|
'reference'=>'WAREHOUSE_RATE',
|
|
'value'=>'{"4":{"amount":"20.00"},"2358":{"amount":"20.00"}}',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>NULL,
|
|
'updated_at'=>'2022-09-23 04:22:52'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>1,
|
|
'reference'=>'CENTER_POSTCODE',
|
|
'value'=>'["5150","5460","8000","9600","10150","10350","11600","12200","12200","12200","14000","14300","18000","27600","28500","28700","31150","31350","31400","31450","36000","40150","40150","40160","40300","40400","40460","41050","41200","42000","42000","42100","42200","43000","43100","43200","43200","43300","43500","43500","43700","43900","46050","46100","46200","46300","47000","47100","47120","47130","47170","47301","47400","47500","47630","47800","48050","50450","51200","52000","52100","52200","54200","55000","55100","56000","56100","57000","58000","60000","62050","63000","68100","70300","70450","71800","75250","75260","76100","76100","79150","81000","81100","81200","81300","81750","83000","86000","88300","88300","88300","88450","91000","98000","98100"]',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>NULL,
|
|
'updated_at'=>'2022-11-07 03:01:11'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>1,
|
|
'reference'=>'OUTSTATION_POSTCODE',
|
|
'value'=>'["93250","93350","94200","94300","94600","78556","78557","94700","94750","94760","93050","93250","94000","94500","93050","93350","93350","79466","93050","94100","94500","93050","93050","93250","93350","93050","94200","94200","93010","93010","94700","94800","94807","94809","93250","94000","93050","93050","93250","86900","82300","86800","86810","81600","86800","71600","71650","72400","71600","72200","72300","71750","71770","69000","26800","26810","26820","39000","39007","39009","39010","33300","33310","33320","33100","42425","42500","42507","42509","42800","45500","43950","47507","47600","47610","47620","47640","47650","47200","40000","40100","40470","40500","40502","40503","40505","40512","40517","40520","40529","40542","40548","40550","40551","40560","40564","40570","40572","40576","40578","40582","40590","40592","40594","40596","40598","40604","40607","40608","40610","40612","40620","40622","40626","40632","40646","40648","40660","40664","40670","40672","40673","40674","40675","40676","40680","40690","40700","40702","40704","40706","40708","40710","40712","40714","40716","40718","40720","40722","40724","40726","40728","40730","40732","40800","40802","40804","40806","40808","40810","40990"]',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>NULL,
|
|
'updated_at'=>'2022-09-21 03:35:19'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>4,
|
|
'reference'=>'CUSTOM_PRICE',
|
|
'value'=>'["-10.00"]',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>'2022-09-21 02:23:22',
|
|
'updated_at'=>'2022-09-21 03:50:38'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>5,
|
|
'reference'=>'CUSTOM_PRICE',
|
|
'value'=>'["-20.00"]',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>'2022-09-21 03:51:23',
|
|
'updated_at'=>'2022-09-21 03:51:59'
|
|
] );
|
|
|
|
|
|
|
|
Segmentconstant::create( [
|
|
'segment_id'=>6,
|
|
'reference'=>'CUSTOM_PRICE',
|
|
'value'=>'["-30.00"]',
|
|
'deleted_at'=>NULL,
|
|
'created_at'=>'2022-09-21 03:51:46',
|
|
'updated_at'=>'2022-09-21 03:52:05'
|
|
] );
|
|
|
|
}
|
|
}
|