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 <?php
/* --------------------------------------------------------------
GXParcelTrackingCodeWriter.php 2018-01-11
Gambio GmbH
http://www.gambio.de
Copyright (c) 2018 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
--------------------------------------------------------------
*/
/**
* Class GXParcelTrackingCodeWriter
*/
class GXParcelTrackingCodeWriter
{
/**
* @var \CI_DB_query_builder
*/
protected $db;
/**
* @var string
*/
protected $table = 'orders_parcel_tracking_codes';
/**
* TrackingCodesWriter constructor.
*
* @param \CI_DB_query_builder $db
*/
public function __construct(CI_DB_query_builder $db)
{
$this->db = $db;
}
/**
* Saves the given order tracking code information in the order parcel tracking codes table.
* Data for parcel service name, url and comment is fetched from related tables.
*
* @param \ParcelTrackingCodeServiceId $parcelServiceId Id of parcel service.
* @param \ParcelTrackingCodeOrderId $orderId Id of order.
* @param \OrderParcelTrackingCode $trackingCode Tracking code for order.
* @param \ParcelTrackingCodeLanguageId $languageId Id of selected language.
*
* @return \ParcelTrackingCodeId Id of new order parcel tracking code.
*/
public function save(ParcelTrackingCodeServiceId $parcelServiceId,
ParcelTrackingCodeOrderId $orderId,
OrderParcelTrackingCode $trackingCode,
ParcelTrackingCodeLanguageId $languageId)
{
$parcelServiceDescription = $this->db->select('ps.name, psd.url, psd.comment')
->from('parcel_services as ps')
->join('parcel_services_description as psd',
'ps.parcel_service_id = psd.parcel_service_id')
->where('ps.parcel_service_id', $parcelServiceId->is())
->where('psd.language_id', $languageId->is())
->get()
->row_array();
if(!$parcelServiceDescription)
{
throw new InvalidArgumentException('Can not find related parcel service description for given parcel service id "'
. $parcelServiceId->is() . '" and language id "' . $languageId->is()
. '".');
}
$this->db->insert($this->table, [
'order_id' => $orderId->is(),
'tracking_code' => $trackingCode->is(),
'parcel_service_id' => $parcelServiceId->is(),
'language_id' => $languageId->is(),
'parcel_service_name' => $parcelServiceDescription['name'],
'url' => str_replace('{TRACKING_NUMBER}', $trackingCode->is(),
$parcelServiceDescription['url']),
'comment' => $parcelServiceDescription['comment']
]);
return ParcelTrackingCodeId::create($this->db->insert_id());
}
/**
* Saves the given order tracking code information in the order parcel tracking codes table.
* Only the provided data is stored in the database.
*
* @param \ParcelTrackingCodeOrderId $orderId Id of order.
* @param \ParcelTrackingCodeServiceName $name Name of parcel service.
* @param \ParcelTrackingCodeUrl $url Tracking code url for order.
* @param \ParcelTrackingCodeComment|null $comment Comment about tracking code.
*
* @return \ParcelTrackingCodeId Id of new order parcel tracking code.
*/
public function saveLightweight(ParcelTrackingCodeOrderId $orderId,
ParcelTrackingCodeServiceName $name,
ParcelTrackingCodeUrl $url,
ParcelTrackingCodeComment $comment = null)
{
$this->db->insert($this->table, [
'order_id' => $orderId->is(),
'parcel_service_name' => $name->is(),
'url' => $url->is(),
'comment' => $comment ? $comment->is() : ''
]);
return ParcelTrackingCodeId::create($this->db->insert_id());
}
}