1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
<?php
class WithdrawalWriter implements WithdrawalWriterInterface
{
protected $queryBuilder;
public function __construct(CI_DB_query_builder $queryBuilder)
{
$this->queryBuilder = $queryBuilder;
}
public function store(WithdrawalInterface $withdrawal)
{
$this->queryBuilder->set([
'order_id' => $withdrawal->getWithdrawalOrder()->getOrderId(),
'customer_id' => $withdrawal->getWithdrawalOrder()->getCustomerId(),
'customer_gender' => $withdrawal->getWithdrawalOrder()
->getCustomerGender(),
'customer_firstname' => $withdrawal->getWithdrawalOrder()
->getCustomerFirstName(),
'customer_lastname' => $withdrawal->getWithdrawalOrder()
->getCustomerLastName(),
'customer_street_address' => $withdrawal->getWithdrawalOrder()
->getCustomerStreetAddress(),
'customer_postcode' => $withdrawal->getWithdrawalOrder()
->getCustomerPostCode(),
'customer_city' => $withdrawal->getWithdrawalOrder()->getCustomerCity(),
'customer_country' => $withdrawal->getWithdrawalOrder()
->getCustomerCountry(),
'customer_email' => $withdrawal->getWithdrawalOrder()->getCustomerEmail(),
'order_date' => $withdrawal->getWithdrawalOrder()
->getOrderDate()
->format('Y-m-d H:i:s'),
'delivery_date' => $withdrawal->getWithdrawalOrder()
->getDeliveryDate()
->format('Y-m-d H:i:s'),
'withdrawal_date' => $withdrawal->getWithdrawalDate()
->format('Y-m-d H:i:s'),
'withdrawal_content' => $withdrawal->getWithdrawalContent(),
'created_by_admin' => $withdrawal->getCreatedByAdmin(),
'date_created' => $withdrawal->getDateCreated()->format('Y-m-d H:i:s')
]);
$this->queryBuilder->insert('withdrawals');
$withdrawalId = $this->queryBuilder->insert_id();
$withdrawal->setWithdrawalId(new IdType($withdrawalId));
return $this;
}
public function update(WithdrawalInterface $withdrawal)
{
$this->queryBuilder->update('withdrawals', [
'order_id' => $withdrawal->getWithdrawalOrder()->getOrderId(),
'customer_id' => $withdrawal->getWithdrawalOrder()->getCustomerId(),
'customer_gender' => $withdrawal->getWithdrawalOrder()->getCustomerGender(),
'customer_firstname' => $withdrawal->getWithdrawalOrder()->getCustomerFirstName(),
'customer_lastname' => $withdrawal->getWithdrawalOrder()->getCustomerLastName(),
'customer_street_address' => $withdrawal->getWithdrawalOrder()->getCustomerStreetAddress(),
'customer_postcode' => $withdrawal->getWithdrawalOrder()->getCustomerPostCode(),
'customer_city' => $withdrawal->getWithdrawalOrder()->getCustomerCity(),
'customer_country' => $withdrawal->getWithdrawalOrder()->getCustomerCountry(),
'customer_email' => $withdrawal->getWithdrawalOrder()->getCustomerEmail(),
'order_date' => $withdrawal->getWithdrawalOrder()->getOrderDate()->format('Y-m-d H:i:s'),
'delivery_date' => $withdrawal->getWithdrawalOrder()->getDeliveryDate()->format('Y-m-d H:i:s'),
'withdrawal_date' => $withdrawal->getWithdrawalDate()->format('Y-m-d H:i:s'),
'withdrawal_content' => $withdrawal->getWithdrawalContent(),
'created_by_admin' => $withdrawal->getCreatedByAdmin()
], ['withdrawal_id' => $withdrawal->getWithdrawalId()]);
return $this;
}
}