2020-12-16 17:38:36.33806716.0MbinfoCronjob execution started. PID: 25663
2020-12-16 17:38:36.34466616.0MbinfoFound 3 BSP records
2020-12-16 17:38:36.34641916.0MbinfoResume from bsp record 3
2020-12-16 17:38:36.36179416.0MbsuccessScanned all BSP records. It took 0.0s
2020-12-16 17:38:36.36268816.0MbinfoFound 2 ImportedOrders services
2020-12-16 17:38:36.36483916.0Mbinfo > scan systems: amadeus, galileo, sabre, worldspan, manual
2020-12-16 17:38:36.36498316.0Mbinfo > scan services:
2020-12-16 17:38:36.36850916.0MbinfoResume from imported service 1
2020-12-16 17:38:36.36868816.0Mbinfo > ignoring 0 suppliers
2020-12-16 17:38:36.51788218.0MbinfoScanned 4 imported services, and ignored 0 services
2020-12-16 17:38:36.79305218.0MbsuccessScanned all imported services. It took 0.4s
[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:38:36.82943820.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
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $statuses [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1marray[0m (1) [
[35;1mstring[0m (7) [32m"matched"[0m
]
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $ticketStatus [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1mstring[0m (8) [32m"refunded"[0m
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $bspRecord [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1mEntity\BspRecord[0m (17) (
protected saveInsideTransaction-> [35;1mbool[0m [32mTRUE[0m
protected dataTableName-> [35;1mstring[0m (14) [32m"bspRecordsData"[0m
protected messages-> [35;1mNULL[0m
protected configPath-> [35;1mstring[0m (8) [32m"entities"[0m
protected CFG-> [35;1marray[0m (0)
protected cleanCaches-> [35;1marray[0m (0)
protected addAndUpdateDateTimeFormat-> [35;1mstring[0m (8) [32m"datetime"[0m
protected convertNullsToBlanks-> [35;1mbool[0m [32mFALSE[0m
public skipUserAccessOnOperations-> [35;1mbool[0m [32mFALSE[0m
protected id-> [35;1mstring[0m (1) [32m"3"[0m
protected tablePrimaryKey-> [35;1mstring[0m (2) [32m"id"[0m
protected primaryKeyType-> [35;1mstring[0m (7) [32m"numeric"[0m
protected selectForUpdate-> [35;1mbool[0m [32mFALSE[0m
protected fields-> [35;1marray[0m (12) [
'id'=> [35;1mstring[0m (1) [32m"3"[0m
'idPeriod'=> [35;1mstring[0m (1) [32m"1"[0m
'supplierCode3'=> [35;1mstring[0m (3) [32m"235"[0m
'ticketNumber'=> [35;1mstring[0m (10) [32m"1845251550"[0m
'ticketDate'=> [35;1mstring[0m (10) [32m"2019-07-31"[0m
'locationType'=> [35;1mstring[0m (1) [32m"I"[0m
'priceBalancePayableAmount'=> [35;1mstring[0m (8) [32m"-2884.00"[0m
'priceBalancePayableCurrency'=> [35;1mstring[0m (3) [32m"SAR"[0m
'idOffice'=> [35;1mstring[0m (1) [32m"1"[0m
'addTime'=> [35;1mstring[0m (19) [32m"2020-12-16 17:37:02"[0m
'idAddUser'=> [35;1mstring[0m (1) [32m"6"[0m
'data'=> [35;1mApp\Bsp\BspRow[0m (20) (
public group-> [35;1minteger[0m [32m0[0m
public supplierCode3-> [35;1mstring[0m (3) [32m"235"[0m
public supplierCode2-> [35;1mNULL[0m
public ticketNumber-> [35;1mstring[0m (10) [32m"1845251550"[0m
public ticketDate-> [35;1mstring[0m (10) [32m"2019-07-31"[0m
public locationType-> [35;1mstring[0m (1) [32m"I"[0m
public priceSupplierCash-> [35;1mApp\Bsp\BspRowPrice[0m (2) (
public amount-> [35;1mfloat[0m [32m-2309[0m
public currency-> [35;1mstring[0m (3) [32m"SAR"[0m
)
public priceSupplierCc-> [35;1mApp\Bsp\BspRowPrice[0m (2) (
public amount-> [35;1mNULL[0m
public currency-> [35;1mNULL[0m
)
public priceTaxCash-> [35;1mApp\Bsp\BspRowPriceTax[0m (1) (
protected taxes-> [35;1marray[0m (1) [
[35;1marray[0m (3) [
'code'=> [35;1mstring[0m (6) [32m"custom"[0m
'amount'=> [35;1minteger[0m [32m-575[0m
'currency'=> [35;1mstring[0m (3) [32m"SAR"[0m
]
]
)
public priceTaxCc-> [35;1mApp\Bsp\BspRowPriceTax[0m (1) (
protected taxes-> [35;1marray[0m (0)
)
public priceCommissionPercent-> [35;1minteger[0m [32m0[0m
public priceCommission-> [35;1mApp\Bsp\BspRowPrice[0m (2) (
public amount-> [35;1minteger[0m [32m0[0m
public currency-> [35;1mstring[0m (3) [32m"SAR"[0m
)
public priceCommissionVat-> [35;1mApp\Bsp\BspRowPrice[0m (2) (
public amount-> [35;1minteger[0m [32m0[0m
public currency-> [35;1mstring[0m (3) [32m"SAR"[0m
)
public priceBalancePayable-> [35;1mApp\Bsp\BspRowPrice[0m (2) (
public amount-> [35;1minteger[0m [32m-2884[0m
public currency-> [35;1mstring[0m (3) [32m"SAR"[0m
)
public formOfPayments-> [35;1marray[0m (0)
public conjunctions-> [35;1marray[0m (0)
public description-> [35;1mNULL[0m
public extraData-> [35;1mApp\Bsp\BspRowExtraData[0m (7) (
public CPUI-> [35;1mstring[0m (0) [32m""[0m
public rowType-> [35;1mstring[0m (4) [32m"RFND"[0m
public isIssue-> [35;1mbool[0m [32mFALSE[0m
public isReissue-> [35;1mbool[0m [32mFALSE[0m
public isRefund-> [35;1mbool[0m [32mTRUE[0m
public isVoid-> [35;1mbool[0m [32mFALSE[0m
public isAdm-> [35;1mbool[0m [32mFALSE[0m
)
public relations-> [35;1mApp\Bsp\BspRowRelations[0m (1) (
public relations-> [35;1marray[0m (1) [
[35;1mApp\Bsp\BspRowRelation[0m (3) (
public relationType-> [35;1mstring[0m (6) [32m"refund"[0m
public ticketNumber-> [35;1mstring[0m (10) [32m"1845251550"[0m
public supplierCode3-> [35;1mstring[0m (3) [32m"235"[0m
)
]
)
public rawData-> [35;1marray[0m (5) [
'DET'=> [35;1marray[0m (47) [
'DET'=> [35;1mstring[0m (3) [32m"DET"[0m
'Ticketing Airline Code'=> [35;1mstring[0m (3) [32m"235"[0m
'Agent Code'=> [35;1mstring[0m (8) [32m"71232825"[0m
'System Provider'=> [35;1mstring[0m (4) [32m"AGTD"[0m
'Billing Category'=> [35;1mstring[0m (3) [32m"BSP"[0m
'Billing Class'=> [35;1mstring[0m (7) [32m"REFUNDS"[0m
'Transaction Code'=> [35;1mstring[0m (4) [32m"RFND"[0m
'Document Number'=> [35;1mstring[0m (10) [32m"1845251550"[0m
'Check Digit'=> [35;1mstring[0m (1) [32m"4"[0m
'Date of Issue'=> [35;1mstring[0m (10) [32m"2019-07-31"[0m
'Coupon Usage Indicator'=> [35;1mstring[0m (0) [32m""[0m
'Currency Code'=> [35;1mstring[0m (3) [32m"SAR"[0m
'Currency Code2'=> [35;1mstring[0m (1) [32m"2"[0m
'Commissionable Amount'=> [35;1minteger[0m [32m-2309[0m
'Standard Commission Rate'=> [35;1minteger[0m [32m0[0m
'Standard Commission Amount'=> [35;1minteger[0m [32m0[0m
'Supplementary Commission Rate'=> [35;1minteger[0m [32m0[0m
'Supplementary Commission Amount'=> [35;1minteger[0m [32m0[0m
'Effective Commission Rate'=> [35;1minteger[0m [32m0[0m
'Effective Commission Amount'=> [35;1minteger[0m [32m0[0m
'Remittance Amount'=> [35;1minteger[0m [32m-2884[0m
'Tax on Commission'=> [35;1minteger[0m [32m0[0m
'TAX'=> [35;1minteger[0m [32m-269[0m
'Fees'=> [35;1minteger[0m [32m-616[0m
'Penalties'=> [35;1minteger[0m [32m310[0m
'Net Remit Indicator'=> [35;1mstring[0m (0) [32m""[0m
'Net Remit'=> [35;1mstring[0m (0) [32m""[0m
'Stat Code'=> [35;1mstring[0m (1) [32m"I"[0m
'Tour Code'=> [35;1mstring[0m (8) [32m"CCC63615"[0m
'Waiver Code'=> [35;1mstring[0m (0) [32m""[0m
'Cash Amount'=> [35;1minteger[0m [32m-2884[0m
'Credit Amount'=> [35;1minteger[0m [32m0[0m
'Related Ticket1 Document Type'=> [35;1mstring[0m (2) [32m"RF"[0m
'Related Ticket1 Document Number'=> [35;1mstring[0m (13) [32m"2351845251550"[0m
'Related Ticket1 Document COUPONS'=> [35;1mstring[0m (4) [32m"1234"[0m
'Related Ticket2 Document Type'=> [35;1mstring[0m (0) [32m""[0m
'Related Ticket2 Document Number'=> [35;1mstring[0m (0) [32m""[0m
'Related Ticket2 Document COUPONS'=> [35;1mstring[0m (0) [32m""[0m
'In Connection with Ticket'=> [35;1mstring[0m (0) [32m""[0m
'Electronic Settlement Authorisation Code'=> [35;1mstring[0m (14) [32m" 235188280E501"[0m
'Tax on Commission Calculation Method'=> [35;1mstring[0m (1) [32m"F"[0m
'Payment Card Information'=> [35;1mstring[0m (0) [32m""[0m
'Payment Card Information - ccCompany'=> [35;1mstring[0m (0) [32m""[0m
'Payment Card Information - ccNumber'=> [35;1mstring[0m (0) [32m""[0m
'Payment Card Transaction ID'=> [35;1mstring[0m (0) [32m""[0m
'Payment Card CCVR'=> [35;1mstring[0m (0) [32m""[0m
'extra'=> [35;1mstring[0m (5) [32m"
"[0m
]
'TAXLines'=> [35;1marray[0m (0)
'PNRLines'=> [35;1marray[0m (0)
'CCDLines'=> [35;1marray[0m (0)
'RTDLines'=> [35;1marray[0m (0)
]
)
]
protected recordExists-> [35;1mbool[0m [32mTRUE[0m
protected tableName-> [35;1mstring[0m (10) [32m"bspRecords"[0m
protected operation-> [35;1mstring[0m (6) [32m"select"[0m
)
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $importedService [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1mEntity\ImportedService[0m (16) (
protected saveInsideTransaction-> [35;1mbool[0m [32mTRUE[0m
protected convertNullsToBlanks-> [35;1mbool[0m [32mTRUE[0m
protected messages-> [35;1mNULL[0m
protected configPath-> [35;1mstring[0m (8) [32m"entities"[0m
protected CFG-> [35;1marray[0m (0)
protected cleanCaches-> [35;1marray[0m (0)
protected addAndUpdateDateTimeFormat-> [35;1mstring[0m (8) [32m"datetime"[0m
public skipUserAccessOnOperations-> [35;1mbool[0m [32mFALSE[0m
protected id-> [35;1mstring[0m (1) [32m"2"[0m
protected tablePrimaryKey-> [35;1mstring[0m (2) [32m"id"[0m
protected primaryKeyType-> [35;1mstring[0m (7) [32m"numeric"[0m
protected selectForUpdate-> [35;1mbool[0m [32mFALSE[0m
protected fields-> [35;1marray[0m (52) [
'id'=> [35;1mstring[0m (1) [32m"2"[0m
'idServiceExtSys'=> [35;1mstring[0m (17) [32m"QR32FV-1845251550"[0m
'idSystem'=> [35;1mstring[0m (1) [32m"1"[0m
'idImportedOrder'=> [35;1mstring[0m (1) [32m"1"[0m
'auxReference'=> [35;1mstring[0m (1) [32m"2"[0m
'idServiceTina'=> [35;1mstring[0m (1) [32m"0"[0m
'idOfferTina'=> [35;1mstring[0m (1) [32m"0"[0m
'processStatus'=> [35;1mstring[0m (3) [32m"new"[0m
'idServiceTinaInitial'=> [35;1mstring[0m (1) [32m"0"[0m
'systemStatus'=> [35;1mstring[0m (8) [32m"refunded"[0m
'systemOriginalStatus'=> [35;1mstring[0m (0) [32m""[0m
'cancelDate'=> [35;1mstring[0m (10) [32m"2019-07-31"[0m
'idImportedServicePackage'=> [35;1mstring[0m (1) [32m"0"[0m
'isPackage'=> [35;1mstring[0m (1) [32m"0"[0m
'idImportedServiceReissued'=> [35;1mstring[0m (1) [32m"1"[0m
'serviceCode'=> [35;1mstring[0m (1) [32m"k"[0m
'pax'=> [35;1mstring[0m (1) [32m"1"[0m
'startDate'=> [35;1mstring[0m (10) [32m"2019-08-09"[0m
'endDate'=> [35;1mstring[0m (10) [32m"2019-08-31"[0m
'passengerLastName'=> [35;1mstring[0m (5) [32m"COPUR"[0m
'passengerFirstName'=> [35;1mstring[0m (9) [32m"FAHRETTIN"[0m
'destinationCountryCode'=> [35;1mstring[0m (2) [32m"TR"[0m
'destinationCityId'=> [35;1mstring[0m (4) [32m"7701"[0m
'offerTotalValue'=> [35;1mstring[0m (4) [32m"0.00"[0m
'offerTotalCurrency'=> [35;1mstring[0m (3) [32m"SAR"[0m
'idOfferSupplier'=> [35;1mstring[0m (3) [32m"546"[0m
'offerExternalSystemReservationId'=> [35;1mstring[0m (6) [32m"QR32FV"[0m
'offerExternalSystemReservationDate'=> [35;1mstring[0m (10) [32m"2019-07-01"[0m
'offerConfirmationNumber'=> [35;1mstring[0m (10) [32m"1845251550"[0m
'offerFormOfPayment'=> [35;1mNULL[0m
'offerOptionDate'=> [35;1mNULL[0m
'offerCriterion'=> [35;1mstring[0m (8) [32m"extNonEU"[0m
'idOffice'=> [35;1mstring[0m (1) [32m"0"[0m
'idUser'=> [35;1mstring[0m (1) [32m"0"[0m
'idBookOfficeSystem'=> [35;1mstring[0m (9) [32m"RUHLW28A1"[0m
'idBookOffice'=> [35;1mstring[0m (1) [32m"0"[0m
'idBookUserSystem'=> [35;1mstring[0m (8) [32m"1147ITAS"[0m
'idBookUser'=> [35;1mstring[0m (1) [32m"0"[0m
'idIssueOfficeSystem'=> [35;1mstring[0m (9) [32m"RUHLW28A1"[0m
'idIssueOffice'=> [35;1mstring[0m (1) [32m"0"[0m
'idIssueUserSystem'=> [35;1mstring[0m (8) [32m"1147ITAS"[0m
'idIssueUser'=> [35;1mstring[0m (1) [32m"0"[0m
'idAddUser'=> [35;1mstring[0m (1) [32m"6"[0m
'addTime'=> [35;1mstring[0m (19) [32m"2020-12-16 17:37:02"[0m
'idUpdateUser'=> [35;1mstring[0m (1) [32m"6"[0m
'lastUpdateTime'=> [35;1mstring[0m (19) [32m"2020-12-16 17:37:02"[0m
'updatesCount'=> [35;1mstring[0m (1) [32m"1"[0m
'idProcessUser'=> [35;1mstring[0m (1) [32m"0"[0m
'processTime'=> [35;1mNULL[0m
'idBlockUser'=> [35;1mstring[0m (1) [32m"0"[0m
'blockTime'=> [35;1mNULL[0m
'blockedComments'=> [35;1mstring[0m (0) [32m""[0m
]
protected recordExists-> [35;1mbool[0m [32mTRUE[0m
protected tableName-> [35;1mstring[0m (23) [32m"importedOrders_services"[0m
protected operation-> [35;1mstring[0m (6) [32m"select"[0m
)
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $extraData [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1marray[0m (3) [
'isRefund'=> [35;1mbool[0m [32mTRUE[0m
'isRefundForReissue'=> [35;1mbool[0m [32mTRUE[0m
'ticketNumber'=> [35;1mstring[0m (10) [32m"1845251550"[0m
]
[36m┌──────────────────────────────────────────────────────────────────────────────┐
│[0m[36m $extraData [0m[36m│
└──────────────────────────────────────────────────────────────────────────────┘[0m
[35;1marray[0m (3) [
'isRefund'=> [35;1mbool[0m [32mTRUE[0m
'isRefundForReissue'=> [35;1mbool[0m [32mTRUE[0m
'ticketNumber'=> [35;1mstring[0m (10) [32m"1845251550"[0m
]
[36m════════════════════════════════════════════════════════════════════════════════[0m
[36mCalled from +881 /srv/www/devel/lucian.sirbu/TINA3/TINA3 - trunk/tina/_classes/App/Cron/Job/PopulateBspSettlementRecords.php[0m
2020-12-16 17:38:36.89688320.0MbsuccessScanned all ImportedOrder services. It took 0.1s
2020-12-16 17:38:36.89701320.0MbinfoAll done
2020-12-16 17:38:36.89711120.0MbinfoInserted 0 rows
2020-12-16 17:38:36.89719720.0MbinfoUpdated 2 rows
2020-12-16 17:38:36.89728820.0MbinfoRe-checked 3 rows
2020-12-16 17:38:36.89737220.0MbinfoDone 4 queue flushes, processed 8.9 rps (estimated)
2020-12-16 17:38:36.89971320.0MbinfoCronjob execution ended.