2020-12-16 17:39:13.29346816.0MbinfoCronjob execution started. PID: 25741
2020-12-16 17:39:13.29941616.0MbinfoFound 3 BSP records
2020-12-16 17:39:13.30089816.0MbinfoResume from bsp record 3
2020-12-16 17:39:13.31196016.0MbsuccessScanned all BSP records. It took 0.0s
2020-12-16 17:39:13.31260616.0MbinfoFound 2 ImportedOrders services
2020-12-16 17:39:13.31412616.0Mbinfo > scan systems: amadeus, galileo, sabre, worldspan, manual
2020-12-16 17:39:13.31422716.0Mbinfo > scan services:
2020-12-16 17:39:13.31665816.0MbinfoResume from imported service 1
2020-12-16 17:39:13.31678716.0Mbinfo > ignoring 0 suppliers
2020-12-16 17:39:13.36245618.0MbinfoScanned 4 imported services, and ignored 0 services
2020-12-16 17:39:13.41946618.0MbsuccessScanned all imported services. It took 0.1s
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $totalSettlementRecords [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1mstring[0m (1) [32m"1"[0m
[36m════════════════════════════════════════════════════════════════════════════════[0m
[36mCalled from +844 /srv/www/devel/lucian.sirbu/TINA3/TINA3 - trunk/tina/_classes/App/Cron/Job/PopulateBspSettlementRecords.php[0m
2020-12-16 17:39:13.43724720.0MbinfoFound 1 BSP settlement records unmatched. Compare them now
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $bspSettlementRecord [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1marray[0m (5) [
'key'=> [35;1mstring[0m (19) [32m"201907/1845251550/-"[0m
'bspRecordId'=> [35;1mstring[0m (1) [32m"3"[0m
'importedServiceId'=> [35;1mstring[0m (1) [32m"2"[0m
'importedServiceIsRefund'=> [35;1mstring[0m (1) [32m"1"[0m
'ticketNumber'=> [35;1mstring[0m (10) [32m"1845251550"[0m
]
[36m════════════════════════════════════════════════════════════════════════════════[0m
[36mCalled from +851 /srv/www/devel/lucian.sirbu/TINA3/TINA3 - trunk/tina/_classes/App/Cron/Job/PopulateBspSettlementRecords.php[0m
array (
0 =>
array (
0 => 'matched',
),
1 => 'refunded',
2 =>
Entity\BspRecord::__set_state(array(
'saveInsideTransaction' => true,
'dataTableName' => 'bspRecordsData',
'messages' => NULL,
'configPath' => 'entities',
'CFG' =>
array (
),
'cleanCaches' =>
array (
),
'addAndUpdateDateTimeFormat' => 'datetime',
'convertNullsToBlanks' => false,
'skipUserAccessOnOperations' => false,
'id' => '3',
'tablePrimaryKey' => 'id',
'primaryKeyType' => 'numeric',
'selectForUpdate' => false,
'fields' =>
array (
'id' => '3',
'idPeriod' => '1',
'supplierCode3' => '235',
'ticketNumber' => '1845251550',
'ticketDate' => '2019-07-31',
'locationType' => 'I',
'priceBalancePayableAmount' => '-2884.00',
'priceBalancePayableCurrency' => 'SAR',
'idOffice' => '1',
'addTime' => '2020-12-16 17:37:02',
'idAddUser' => '6',
'data' =>
App\Bsp\BspRow::__set_state(array(
'group' => 0,
'supplierCode3' => '235',
'supplierCode2' => NULL,
'ticketNumber' => '1845251550',
'ticketDate' => '2019-07-31',
'locationType' => 'I',
'priceSupplierCash' =>
App\Bsp\BspRowPrice::__set_state(array(
'amount' => -2309.0,
'currency' => 'SAR',
)),
'priceSupplierCc' =>
App\Bsp\BspRowPrice::__set_state(array(
'amount' => NULL,
'currency' => NULL,
)),
'priceTaxCash' =>
App\Bsp\BspRowPriceTax::__set_state(array(
'taxes' =>
array (
0 =>
array (
'code' => 'custom',
'amount' => -575,
'currency' => 'SAR',
),
),
)),
'priceTaxCc' =>
App\Bsp\BspRowPriceTax::__set_state(array(
'taxes' =>
array (
),
)),
'priceCommissionPercent' => 0,
'priceCommission' =>
App\Bsp\BspRowPrice::__set_state(array(
'amount' => 0,
'currency' => 'SAR',
)),
'priceCommissionVat' =>
App\Bsp\BspRowPrice::__set_state(array(
'amount' => 0,
'currency' => 'SAR',
)),
'priceBalancePayable' =>
App\Bsp\BspRowPrice::__set_state(array(
'amount' => -2884,
'currency' => 'SAR',
)),
'formOfPayments' =>
array (
),
'conjunctions' =>
array (
),
'description' => NULL,
'extraData' =>
App\Bsp\BspRowExtraData::__set_state(array(
'CPUI' => '',
'rowType' => 'RFND',
'isIssue' => false,
'isReissue' => false,
'isRefund' => true,
'isVoid' => false,
'isAdm' => false,
)),
'relations' =>
App\Bsp\BspRowRelations::__set_state(array(
'relations' =>
array (
0 =>
App\Bsp\BspRowRelation::__set_state(array(
'relationType' => 'refund',
'ticketNumber' => '1845251550',
'supplierCode3' => '235',
)),
),
)),
'rawData' =>
array (
'DET' =>
array (
'DET' => 'DET',
'Ticketing Airline Code' => '235',
'Agent Code' => '71232825',
'System Provider' => 'AGTD',
'Billing Category' => 'BSP',
'Billing Class' => 'REFUNDS',
'Transaction Code' => 'RFND',
'Document Number' => '1845251550',
'Check Digit' => '4',
'Date of Issue' => '2019-07-31',
'Coupon Usage Indicator' => '',
'Currency Code' => 'SAR',
'Currency Code2' => '2',
'Commissionable Amount' => -2309,
'Standard Commission Rate' => 0,
'Standard Commission Amount' => 0,
'Supplementary Commission Rate' => 0,
'Supplementary Commission Amount' => 0,
'Effective Commission Rate' => 0,
'Effective Commission Amount' => 0,
'Remittance Amount' => -2884,
'Tax on Commission' => 0,
'TAX' => -269,
'Fees' => -616,
'Penalties' => 310,
'Net Remit Indicator' => '',
'Net Remit' => '',
'Stat Code' => 'I',
'Tour Code' => 'CCC63615',
'Waiver Code' => '',
'Cash Amount' => -2884,
'Credit Amount' => 0,
'Related Ticket1 Document Type' => 'RF',
'Related Ticket1 Document Number' => '2351845251550',
'Related Ticket1 Document COUPONS' => '1234',
'Related Ticket2 Document Type' => '',
'Related Ticket2 Document Number' => '',
'Related Ticket2 Document COUPONS' => '',
'In Connection with Ticket' => '',
'Electronic Settlement Authorisation Code' => ' 235188280E501',
'Tax on Commission Calculation Method' => 'F',
'Payment Card Information' => '',
'Payment Card Information - ccCompany' => '',
'Payment Card Information - ccNumber' => '',
'Payment Card Transaction ID' => '',
'Payment Card CCVR' => '',
'extra' => '
',
),
'TAXLines' =>
array (
),
'PNRLines' =>
array (
),
'CCDLines' =>
array (
),
'RTDLines' =>
array (
),
),
)),
),
'recordExists' => true,
'tableName' => 'bspRecords',
'operation' => 'select',
)),
3 =>
Entity\ImportedService::__set_state(array(
'saveInsideTransaction' => true,
'convertNullsToBlanks' => true,
'messages' => NULL,
'configPath' => 'entities',
'CFG' =>
array (
),
'cleanCaches' =>
array (
),
'addAndUpdateDateTimeFormat' => 'datetime',
'skipUserAccessOnOperations' => false,
'id' => '2',
'tablePrimaryKey' => 'id',
'primaryKeyType' => 'numeric',
'selectForUpdate' => false,
'fields' =>
array (
'id' => '2',
'idServiceExtSys' => 'QR32FV-1845251550',
'idSystem' => '1',
'idImportedOrder' => '1',
'auxReference' => '2',
'idServiceTina' => '0',
'idOfferTina' => '0',
'processStatus' => 'new',
'idServiceTinaInitial' => '0',
'systemStatus' => 'refunded',
'systemOriginalStatus' => '',
'cancelDate' => '2019-07-31',
'idImportedServicePackage' => '0',
'isPackage' => '0',
'idImportedServiceReissued' => '1',
'serviceCode' => 'k',
'pax' => '1',
'startDate' => '2019-08-09',
'endDate' => '2019-08-31',
'passengerLastName' => 'COPUR',
'passengerFirstName' => 'FAHRETTIN',
'destinationCountryCode' => 'TR',
'destinationCityId' => '7701',
'offerTotalValue' => '0.00',
'offerTotalCurrency' => 'SAR',
'idOfferSupplier' => '546',
'offerExternalSystemReservationId' => 'QR32FV',
'offerExternalSystemReservationDate' => '2019-07-01',
'offerConfirmationNumber' => '1845251550',
'offerFormOfPayment' => NULL,
'offerOptionDate' => NULL,
'offerCriterion' => 'extNonEU',
'idOffice' => '0',
'idUser' => '0',
'idBookOfficeSystem' => 'RUHLW28A1',
'idBookOffice' => '0',
'idBookUserSystem' => '1147ITAS',
'idBookUser' => '0',
'idIssueOfficeSystem' => 'RUHLW28A1',
'idIssueOffice' => '0',
'idIssueUserSystem' => '1147ITAS',
'idIssueUser' => '0',
'idAddUser' => '6',
'addTime' => '2020-12-16 17:37:02',
'idUpdateUser' => '6',
'lastUpdateTime' => '2020-12-16 17:37:02',
'updatesCount' => '1',
'idProcessUser' => '0',
'processTime' => NULL,
'idBlockUser' => '0',
'blockTime' => NULL,
'blockedComments' => '',
),
'recordExists' => true,
'tableName' => 'importedOrders_services',
'operation' => 'select',
)),
4 =>
array (
'isRefund' => true,
'isRefundForReissue' => true,
'ticketNumber' => '1845251550',
),
5 =>
array (
'isRefund' => true,
'isRefundForReissue' => true,
'ticketNumber' => '1845251550',
),
)
2020-12-16 17:39:13.45763820.0MbsuccessScanned all ImportedOrder services. It took 0.0s
2020-12-16 17:39:13.45775620.0MbinfoAll done
2020-12-16 17:39:13.45784520.0MbinfoInserted 0 rows
2020-12-16 17:39:13.45792620.0MbinfoUpdated 2 rows
2020-12-16 17:39:13.45800520.0MbinfoRe-checked 3 rows
2020-12-16 17:39:13.45808620.0MbinfoDone 4 queue flushes, processed 30.1 rps (estimated)
2020-12-16 17:39:13.46028420.0MbinfoCronjob execution ended.