mirror of
https://gitlab.com/CIEFWorldwideSdnBhd/exchange-2.0.git
synced 2026-08-19 12:33:56 +00:00
edmondlang
299 lines
12 KiB
PHP
299 lines
12 KiB
PHP
<?php
|
|
|
|
use Illuminate\Database\Seeder;
|
|
use App\Classes\ValueObjects\Constants as Constants;
|
|
use App\Models as Models;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class FakeBookingTransactions extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function run()
|
|
{
|
|
if(App()->environment('local')) {
|
|
//Add user to map company, and auth user for bookings
|
|
$email = 'bookmaster@cief.com';
|
|
$password = 'bo@k!ng$123';
|
|
$booking_user = [
|
|
'name' => 'Book Master',
|
|
'email' => $email,
|
|
'password' => bcrypt($password),
|
|
'type' => Constants\RoleTypes::USER,
|
|
'status' => Constants\ApprovalStatus::APPROVED,
|
|
];
|
|
$user = Models\User::updateOrCreate(['email' => $email], $booking_user);
|
|
$user_id = $user->id;
|
|
|
|
//Add 3 Entity: 2 company + 1 individual
|
|
$companies = [
|
|
[
|
|
'name' => 'Maersk Line SDN BHD',
|
|
'reference' => 'MAERSK-123',
|
|
'type' => Constants\CompanyType::COMPANY_BUSINESS,
|
|
'business_type' => Constants\BusinessType::FREIGHT_FORWARDER,
|
|
'status' => Constants\ApprovalStatus::APPROVED,
|
|
],
|
|
[
|
|
'name' => 'Sunrise Importer SDN BHD',
|
|
'reference' => 'SSMID-E',
|
|
'type' => Constants\CompanyType::COMPANY_BUSINESS,
|
|
'business_type' => Constants\BusinessType::IMPORTER,
|
|
'status' => Constants\ApprovalStatus::APPROVED,
|
|
],
|
|
[
|
|
'name' => 'Han Solo',
|
|
'reference' => '880101-14-6541',
|
|
'type' => Constants\CompanyType::PERSONAL_BUSINESS,
|
|
'business_type' => Constants\BusinessType::IMPORTER,
|
|
'status' => Constants\ApprovalStatus::APPROVED,
|
|
]
|
|
];
|
|
|
|
$addresses = [
|
|
[
|
|
'company_id' => null, //fill-up later
|
|
'country_id' => 1,
|
|
'state_id' => 15,
|
|
'district_id' => 402,
|
|
'postcode' => '63000',
|
|
'street_one' => 'Vertex Tower, Cybersquare,',
|
|
'street_two' => 'Jalan Teknorat 6, Cyber 5',
|
|
'billing' => 1
|
|
]
|
|
];
|
|
|
|
$contacts = [
|
|
[
|
|
'company_id' => null, //fill-up later
|
|
'country_id' => 1,
|
|
'reference' => 'main',
|
|
'phone' => '0123456789',
|
|
'email' => 'email@edomain.com'
|
|
]
|
|
];
|
|
|
|
$banks = [
|
|
[
|
|
'company_id' => null, //fill-up later
|
|
'reference' => 'CBB',
|
|
'bank_name' => 'Citibank Berhad',
|
|
'holder_name' => '', //fill-up later, use company name
|
|
'account_no' => '0123456789',
|
|
'bank_branch' => 'Menara Citibank Kuala Lumpur',
|
|
'swift' => null,
|
|
'snap' => null,
|
|
'type' => Constants\BankAccountType::EXTERNAL,
|
|
'default' => 0,
|
|
'status' => 2,
|
|
'country_id' => 2,
|
|
]
|
|
];
|
|
|
|
$company_ids = [];
|
|
$address_ids = [];
|
|
$contact_ids = [];
|
|
$bank_ids = [];
|
|
|
|
foreach ($companies as $company) {
|
|
$check = ['name' => $company['name']];
|
|
$added = Models\Company::updateOrCreate($check, $company);
|
|
$company_ids[] = $added->id;
|
|
|
|
//Add address
|
|
foreach ($addresses as $address) {
|
|
$address['company_id'] = $added->id;
|
|
$address['street_one'] = $company['name'] . ", " . $address['street_one'];
|
|
$check_address = ['street_one' => $address['street_one']];
|
|
$added_address = Models\Address::updateOrCreate($check_address, $address);
|
|
$address_ids[$added->id][] = $added_address->id;
|
|
}
|
|
|
|
//Add contact
|
|
foreach ($contacts as $contact) {
|
|
$contact['company_id'] = $added->id;
|
|
$contact['reference'] = $company['name'] . ", " . $contact['reference'];
|
|
$check_contact = ['reference' => $contact['reference']];
|
|
$added_contact = Models\Contact::updateOrCreate($check_contact, $contact);
|
|
$contact_ids[$added->id][] = $added_contact->id;
|
|
}
|
|
|
|
//Add bank
|
|
foreach ($banks as $bank) {
|
|
$bank['company_id'] = $added->id;
|
|
$bank['reference'] = $company['name'] . ", " . $bank['reference'];
|
|
$check_bank = ['reference' => $bank['reference']];
|
|
$added_bank = Models\Bank::updateOrCreate($check_bank, $bank);
|
|
$bank_ids[$added->id][] = $added_bank->id;
|
|
}
|
|
|
|
//Model employee have issue: Unknown column 'updated_at' in 'field list'
|
|
DB::table('employees')->updateOrInsert(
|
|
['company_id' => $added->id, 'user_id' => $user_id, 'status' => 2],
|
|
['company_id' => $added->id, 'user_id' => $user_id, 'status' => 2]
|
|
);
|
|
|
|
Models\Document::updateOrCreate(
|
|
['owner_id' => $added->id, 'status' => 2],
|
|
[
|
|
'owner_type' => 'App\Models\Company',
|
|
'owner_id' => $added->id,
|
|
'status' => 2,
|
|
'document_type' => ($company['type'] == Constants\CompanyType::COMPANY_BUSINESS) ? Constants\DocumentType::SSM_REGISTRATION : Constants\DocumentType::IDENTITY_CARD,
|
|
'reference' => $company['reference'],
|
|
]
|
|
);
|
|
|
|
Models\SegmentCompany::updateOrCreate(
|
|
['company_id' => $added->id, 'segment_id' => 1],
|
|
['company_id' => $added->id, 'segment_id' => 1]
|
|
);
|
|
}
|
|
|
|
|
|
//Booking, Transactions require auth user
|
|
$user = new Models\User;
|
|
$user->email = $email;
|
|
$user->password = $password;
|
|
auth()->login($user);
|
|
|
|
$bookings = [
|
|
[
|
|
'company_id' => null, //fill-up later
|
|
'marking' => null, //fill-up later
|
|
'service_id' => 1,
|
|
'bank_id' => null, //fill-up later
|
|
'fix_amount' => null, //fill-up later
|
|
'fix_currency_id' => 2,
|
|
'convertible_currency_id' => 2,
|
|
'conversion_currency_id' => 1,
|
|
'status' => Constants\ApprovalStatus::APPROVED,
|
|
],
|
|
];
|
|
|
|
$transactions = [
|
|
[
|
|
'booking_id' => null, //fill-up later
|
|
'type' => null, //fill-up later
|
|
'issuer' => null, //fill-up later
|
|
'receiver' => 1,
|
|
'recipient_bank_account_id' => 1,
|
|
'payment_method' => 2,
|
|
'payment_reference' => 2,
|
|
'bill_no' => null, //fill-up later
|
|
'amount' => null, //fill-up later
|
|
'original_amount' => null, //fill-up later
|
|
'currency_id' => 2,
|
|
'original_currency_id' => 2,
|
|
'currency_rate' => 1.0,
|
|
'tax' => 1.0,
|
|
'service_charge' => 0.0,
|
|
'expires_on' => null,
|
|
'status' => 0,
|
|
],
|
|
];
|
|
|
|
$transaction_details = [
|
|
[
|
|
'transaction_id' => null, //fill-up later
|
|
'product_code' => 'MBP15',
|
|
'product_name' => 'Macbook Pro 15"',
|
|
'quantity' => 2,
|
|
'price' => 1000,
|
|
'amount' => 2000,
|
|
],
|
|
[
|
|
'transaction_id' => null, //fill-up later
|
|
'product_code' => 'IP12',
|
|
'product_name' => 'iPad Pro 12"',
|
|
'quantity' => 2,
|
|
'price' => 1000,
|
|
'amount' => 2000,
|
|
],
|
|
[
|
|
'transaction_id' => null, //fill-up later
|
|
'product_code' => 'IMC24',
|
|
'product_name' => 'iMac',
|
|
'quantity' => 2,
|
|
'price' => 1000,
|
|
'amount' => 2000,
|
|
],
|
|
];
|
|
|
|
$booking_ids = [];
|
|
$transaction_ids = [];
|
|
$transaction_types = [
|
|
Constants\TransactionType::PAYMENT_ATTEMPT,
|
|
Constants\TransactionType::PAYMENT,
|
|
Constants\TransactionType::INVOICE,
|
|
Constants\TransactionType::BILL,
|
|
Constants\TransactionType::PROFORMA,
|
|
Constants\TransactionType::TOP_UP,
|
|
Constants\TransactionType::REFUND,
|
|
Constants\TransactionType::PURCHASE_ORDER,
|
|
Constants\TransactionType::SUPPLIER_DELIVER,
|
|
];
|
|
|
|
foreach ($company_ids as $company_id) {
|
|
foreach ($transaction_types as $transaction_type) {
|
|
foreach ($bookings as $booking) {
|
|
|
|
$marking = mt_rand(20000, 20100); //Limit marking within 100 for easier to remember
|
|
|
|
$booking['company_id'] = $company_id;
|
|
$booking['bank_id'] = $bank_ids[$company_id][0];
|
|
$booking['marking'] = $marking;
|
|
$fix_amount = [4000,8000];
|
|
$booking['fix_amount'] = $fix_amount[array_rand($fix_amount)];;
|
|
$booking['created_at'] = date('Y-m-d H:i:s');
|
|
$booking['updated_at'] = date('Y-m-d H:i:s');
|
|
|
|
$check_booking = ['marking' => $booking['marking']];
|
|
$added_booking = Models\Booking::updateOrCreate($check_booking, $booking);
|
|
$booking_ids[] = $added_booking->id;
|
|
$booking_id = $added_booking->id;
|
|
|
|
foreach ($transactions as $transaction) {
|
|
|
|
$bill_no = $code = mt_rand(100000001, 999999999);
|
|
|
|
$transaction['booking_id'] = $booking_id;
|
|
$transaction['type'] = $transaction_type;
|
|
$transaction['issuer'] = $company_id;
|
|
|
|
$transaction['bill_no'] = $bill_no;
|
|
$transaction['amount'] = 6000;
|
|
$transaction['original_amount'] = 6000;
|
|
|
|
$transaction['created_at'] = date('Y-m-d H:i:s');
|
|
$transaction['updated_at'] = date('Y-m-d H:i:s');
|
|
|
|
$check_transaction = ['bill_no' => $transaction['bill_no']];
|
|
$added_transaction = Models\Transaction::updateOrCreate($check_transaction, $transaction);
|
|
$transaction_ids[] = $added_transaction->id;
|
|
$transaction_id = $added_transaction->id;
|
|
|
|
foreach ($transaction_details as $transaction_detail) {
|
|
$transaction_detail['transaction_id'] = $transaction_id;
|
|
|
|
$transaction_detail['created_at'] = date('Y-m-d H:i:s');
|
|
$transaction_detail['updated_at'] = date('Y-m-d H:i:s');
|
|
|
|
$check_transaction_details = [
|
|
'transaction_id' => $transaction_detail['transaction_id'],
|
|
'product_code' => $transaction_detail['product_code']
|
|
];
|
|
Models\TransactionDetail::updateOrCreate($check_transaction_details,
|
|
$transaction_detail);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|