2025-11-24 12:40:17.61774414.0MbinfoCronjob execution started. PID: 43264

2025-11-24 12:40:17.61893014.0MbinfoDetermined default period: 2020-01-01 - 2026-01-24.

2025-11-24 12:40:17.64734714.0MbinfoStart populating quick reports content for `ClientInvoiceRows` source.

------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_services` AS serv ON (src.idService=serv.id) LEFT JOIN `rd_offers` AS off ON (serv.id=off.idService) SET src.offerStartDate = DATE(off.startDatetime), src.offerStartDateY = YEAR(off.startDatetime), src.offerStartDateM = MONTH(off.startDatetime), src.offerStartDateYM = DATE_FORMAT(off.startDatetime, '%Y%m'), src.offerDestCountryCode = off.destinationCountryCode, src.offerDestCityId = off.destinationCityId, src.idSupplier = off.idSupplier, src.serviceIdUser = serv.idUser, src.serviceIdOffice = serv.idOffice ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'ClientInvoiceRows') (2=>'progress_step') (3=>'3') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_customers` AS cust ON (src.idCustomer=cust.id) SET src.clientType='DC', src.idCustomerSegment = cust.idSegment, src.clientCountryCode = cust.countryCode ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_corporates` AS corp ON (src.idCorporate=corp.id) SET src.clientType = corp.type, src.idCorporateSegment = corp.idSegment ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_clientInvoiceRows` AS src INNER JOIN `rd_corporateOffices` AS corpOff ON (src.idCorporateOffice=corpOff.id) SET src.clientCountryCode = corpOff.countryCode ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'ClientInvoiceRows') (2=>'progress_loopRecords') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'ClientInvoiceRows') (2=>'progress_memoryUsage') (3=>'73404416') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'sss') (1=>'ClientInvoiceRows') (2=>'status') (3=>'ok') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'ClientInvoiceRows') (2=>'finishPopulateTimestamp') (3=>'1763980818') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------

2025-11-24 12:40:18.21433014.0MbsuccessSuccessfully populated quick reports content for `ClientInvoiceRows` source.

------------------------------------------------------------------------------ mysqli SELECT `value` FROM `rdParams` WHERE `var`=? [ (0=>'s') (1=>'status') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT `value` FROM `rdParams` WHERE `var`=? [ (0=>'s') (1=>'blockedUntil') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT `value` FROM `rdParams` WHERE `var`=? [ (0=>'s') (1=>'blockedUntil') ] ------------------------------------------------------------------------------

2025-11-24 12:40:18.21556014.0MbinfoStart populating quick reports content for `OrderServices` source.

------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'sss') (1=>'OrderServices') (2=>'status') (3=>'populatingContent') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'OrderServices') (2=>'startPopulateTimestamp') (3=>'1763980818') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'OrderServices') (2=>'keepAliveTimestamp') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'OrderServices') (2=>'finishPopulateTimestamp') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli TRUNCATE TABLE `pivotTablesData_orderServices` ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'OrderServices') (2=>'progress_step') (3=>'1') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli INSERT INTO `pivotTablesData_orderServices` ( id, idOrder, orderDate, orderDateY, orderDateM, orderDateYM, orderType, orderServicesType, idMiceProject, orderStartDate, orderStartDateY, orderStartDateM, orderStartDateYM, orderEndDate, orderEndDateY, orderEndDateM, orderEndDateYM, orderIdUser, orderIdOffice, orderIdDepartment, idExternalSystem, pax, serviceCode, serviceName, serviceCategory, statusOp, statusFin, agencyCostCenter, idUser, idOffice, ticketsDate, ticketsDateY, ticketsDateM, ticketsDateYM, addDate, cancelDate, refundDate, idBalance, balanced, idInvoice, invoicesCashedStatus, offerStartDate, offerStartDateY, offerStartDateM, offerStartDateYM, offerDuration, offerEndDate, offerEndDateY, offerEndDateM, offerEndDateYM, offerIdSupplier, offerIdSupplierProduct, offerDeptCountryCode, offerDeptCityId, offerDestCountryCode, offerDestCityId, offerTotalValueOrg, offerCurrency, offerCurrencyType, offerCurrencyDate, offerTotalValueDef, offerTotalValueWrk, offerProfitValueOrg, offerProfitValueDef, offerProfitValueWrk, invoiceValOrg, invoiceVatOrg, invoiceTtlOrg, invoiceCurrency, invoiceValDef, invoiceVatDef, invoiceTtlDef, invoiceValWrk, invoiceVatWrk, invoiceTtlWrk, balanceProfitDef ) SELECT serv.id, ord.id, ord.date, YEAR(ord.date), MONTH(ord.date), DATE_FORMAT(ord.date, '%Y%m'), ord.orderType, ord.servicesType, ord.idMiceProject, ord.startDate, YEAR(ord.startDate), MONTH(ord.startDate), DATE_FORMAT(ord.startDate, '%Y%m'), ord.endDate, YEAR(ord.endDate), MONTH(ord.endDate), DATE_FORMAT(ord.endDate, '%Y%m'), ord.idUser, ord.idOffice, ord.idDepartment, serv.idExternalSystem, serv.pax, serv.serviceCode, serv.serviceName, serv.serviceCfgCat, serv.statusOp, serv.statusFin, serv.agencyCostCenter, serv.idUser, serv.idOffice, serv.passengersTicketsDate, YEAR(serv.passengersTicketsDate), MONTH(serv.passengersTicketsDate), DATE_FORMAT(serv.passengersTicketsDate, '%Y%m'), CAST(serv.addTime AS DATE), IF(serv.statusOp='XX', CAST(serv.lastUpdateTime AS DATE), NULL), serv.refundDate, serv.idBalance, !(!serv.idBalance), serv.idRelevantInvoice, serv.invoiceCashedStatus, off.startDatetime, YEAR(off.startDatetime), MONTH(off.startDatetime), DATE_FORMAT(off.startDatetime, '%Y%m'), off.duration, off.endDatetime, YEAR(off.endDatetime), MONTH(off.endDatetime), DATE_FORMAT(off.endDatetime, '%Y%m'), off.idSupplier, off.idSupplierProduct, off.departureCountryCode, off.departureCityId, off.destinationCountryCode, off.destinationCityId, off.offerTotal, off.currency, off.currencyType, off.currencyDate, off.offerTotal*off.currencyRate, off.offerTotal*off.currencyRate/off.workCurrencyRate , (off.commissionValue+off.commissionVat+off.serviceFeeValue+off.serviceFeeVat-off.discountValue-off.discountVat), (off.commissionValue+off.commissionVat+off.serviceFeeValue+off.serviceFeeVat-off.discountValue-off.discountVat)*off.currencyRate, (off.commissionValue+off.commissionVat+off.serviceFeeValue+off.serviceFeeVat-off.discountValue-off.discountVat)*off.currencyRate/off.workCurrencyRate, serv.invoiceValue, serv.invoiceVat, serv.invoiceTotal, serv.invoiceCurrency, serv.invoiceValue*serv.invoiceCurrencyRate, serv.invoiceVat*serv.invoiceCurrencyRate, serv.invoiceTotal*serv.invoiceCurrencyRate, serv.invoiceValue*serv.invoiceCurrencyRate/serv.invoiceWorkCurrencyRate, serv.invoiceVat*serv.invoiceCurrencyRate/serv.invoiceWorkCurrencyRate, serv.invoiceTotal*serv.invoiceCurrencyRate/serv.invoiceWorkCurrencyRate, serv.balanceProfitDefCurr FROM `rd_services` AS serv INNER JOIN `rd_orders` AS ord ON (ord.id=serv.idOrder) LEFT JOIN `rd_offers` AS off ON (off.idService=serv.id) WHERE (ord.date BETWEEN ? AND ?) AND serv.idPackageService = 0 [ (0=>'ss') (1=>'2020-01-01') (2=>'2026-01-24') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'OrderServices') (2=>'progress_step') (3=>'2') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_orderServices` AS dest, `rd_clientInvoices` AS inv SET dest.invoiceDate = inv.invoiceDate, dest.invoiceDateY = YEAR(inv.invoiceDate), dest.invoiceDateM = MONTH(inv.invoiceDate), dest.invoiceDateYM = DATE_FORMAT(inv.invoiceDate, '%Y%m'), dest.invoiceIdCorporate = inv.idCorporate, dest.invoiceIdCustomer = inv.idCustomer, dest.invoiceClientType = IF (inv.idCorporate, 'CC', 'DC'), dest.invoiceIdUser = inv.idUser, dest.invoiceIdOffice = inv.idOffice, dest.invoiceDueDate = inv.dueDate, dest.invoiceCashDate = inv.lastCashingDate WHERE dest.idInvoice = inv.id ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'OrderServices') (2=>'progress_step') (3=>'3') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_orderServices` AS dest, `rd_balances` AS bal SET dest.balanceDate = bal.balanceDate, dest.balanceDateY = YEAR(bal.balanceDate), dest.balanceDateM = MONTH(bal.balanceDate), dest.balanceDateYM = DATE_FORMAT(bal.balanceDate, '%Y%m'), dest.balanceVirtualDate = bal.virtualDate, dest.balanceVirtualDateY = YEAR(bal.virtualDate), dest.balanceVirtualDateM = MONTH(bal.virtualDate), dest.balanceVirtualDateYM = DATE_FORMAT(bal.virtualDate, '%Y%m') WHERE dest.idBalance = bal.id ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'OrderServices') (2=>'progress_loopRecords') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'OrderServices') (2=>'progress_memoryUsage') (3=>'73404416') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'sss') (1=>'OrderServices') (2=>'status') (3=>'ok') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'OrderServices') (2=>'finishPopulateTimestamp') (3=>'1763980818') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------

2025-11-24 12:40:18.55703314.0MbsuccessSuccessfully populated quick reports content for `OrderServices` source.

2025-11-24 12:40:18.55871214.0MbinfoStart populating quick reports content for `SupplierInvoiceRows` source.

------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'sss') (1=>'SupplierInvoiceRows') (2=>'status') (3=>'populatingContent') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'SupplierInvoiceRows') (2=>'startPopulateTimestamp') (3=>'1763980818') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'SupplierInvoiceRows') (2=>'keepAliveTimestamp') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'SupplierInvoiceRows') (2=>'finishPopulateTimestamp') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli TRUNCATE TABLE `pivotTablesData_supplierInvoiceRows` ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'SupplierInvoiceRows') (2=>'progress_step') (3=>'1') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli INSERT INTO `pivotTablesData_supplierInvoiceRows` ( id, invoiceDate, invoiceDateY, invoiceDateM, invoiceDateYM, dueDate, dueDays, dueDateY, dueDateM, dueDateYM, statusOp, idSupplier, serviceCode, invoiceIdUser, invoiceIdOffice, rowType, rowValOrg, rowVatOrg, rowTtlOrg, currency, rowVatPercent, rowVatText, payedStatus, payedOrg, payDate, payDays, rowValDef, rowVatDef, rowTtlDef, rowValWrk, rowVatWrk, rowTtlWrk, duePayOrg ) SELECT invRow.id, inv.invoiceDate, YEAR(inv.invoiceDate), MONTH(inv.invoiceDate), DATE_FORMAT(inv.invoiceDate, '%Y%m'), inv.dueDate, IF (inv.dueDate IS NULL, NULL, DATEDIFF(inv.dueDate, inv.invoiceDate)), IF (inv.dueDate IS NULL, NULL, YEAR(inv.dueDate)), IF (inv.dueDate IS NULL, NULL, MONTH(inv.dueDate)), IF (inv.dueDate IS NULL, NULL, DATE_FORMAT(inv.dueDate, '%Y%m')), inv.statusOp, inv.idSupplier, invRow.serviceCode, inv.idUser, inv.idOffice, invRow.rowType, invRow.rowValue, invRow.rowVat, invRow.rowValue+invRow.rowVat, inv.currency, invRow.vatPercent, invRow.vatText, IF (inv.statusFin IN ('t', 'o'), 't', inv.statusFin), IF (inv.statusFin IN ('t', 'o'), (invRow.rowValue+invRow.rowVat), (invRow.rowValue+invRow.rowVat)*inv.payedValue/inv.invoiceTotal), inv.lastPaymentDate, DATEDIFF(inv.lastPaymentDate, inv.invoiceDate), invRow.rowValue*inv.currencyRate, invRow.rowVat*inv.currencyRate, (invRow.rowValue+invRow.rowVat)*inv.currencyRate, invRow.rowValue*inv.currencyRate/inv.workCurrencyRate, invRow.rowVat*inv.currencyRate/inv.workCurrencyRate, (invRow.rowValue+invRow.rowVat)*inv.currencyRate/inv.workCurrencyRate, IF (inv.statusFin IN ('t', 'o'), 0, (invRow.rowValue+invRow.rowVat)-(invRow.rowValue+invRow.rowVat)*inv.payedValue/inv.invoiceTotal) FROM `rd_supplierInvoices` AS inv INNER JOIN `rd_supplierInvoiceRows` AS invRow ON (inv.id=invRow.idInvoice) WHERE inv.deleted=0 AND (inv.invoiceDate BETWEEN ? AND ?) [ (0=>'ss') (1=>'2020-01-01') (2=>'2026-01-24') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_supplierInvoiceRows` AS src INNER JOIN `rd_supplierInvoiceRows` AS invRow ON (src.id=invRow.id) INNER JOIN `rd_supplierInvoices` inv ON (invRow.idInvoice=inv.id) SET src.payedDef = src.payedOrg*inv.currencyRate, src.payedWrk = src.payedOrg*inv.currencyRate/inv.workCurrencyRate, src.duePayDef = src.duePayOrg*inv.currencyRate, src.duePayWrk = src.duePayOrg*inv.currencyRate/inv.workCurrencyRate ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'SupplierInvoiceRows') (2=>'progress_step') (3=>'2') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `pivotTablesData_supplierInvoiceRows` AS src, `rd_suppliers` AS supp SET src.supplierCountryCode = supp.countryCode WHERE src.idSupplier=supp.id ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli DELETE FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'SupplierInvoiceRows') (2=>'progress_loopRecords') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'SupplierInvoiceRows') (2=>'progress_memoryUsage') (3=>'73404416') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli START TRANSACTION ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'sss') (1=>'SupplierInvoiceRows') (2=>'status') (3=>'ok') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli REPLACE INTO `pivotTablesConfigs` SET `pivotSource`=?, `var`=?, `value`=? [ (0=>'ssi') (1=>'SupplierInvoiceRows') (2=>'finishPopulateTimestamp') (3=>'1763980818') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli COMMIT ------------------------------------------------------------------------------

2025-11-24 12:40:18.77999914.0MbsuccessSuccessfully populated quick reports content for `SupplierInvoiceRows` source.

------------------------------------------------------------------------------ mysqli SELECT `value` FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'ClientInvoiceRows') (2=>'status') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY invoiceDateY ORDER BY `invoiceDateY` ASC [ (0=>'is') (1=>'2022') (2=>'2025') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY invoiceDateY [ (0=>'is') (1=>'2022') (2=>'2025') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) [ (0=>'is') (1=>'2022') (2=>'2025') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT `value` FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'SupplierInvoiceRows') (2=>'status') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) GROUP BY invoiceDateY ORDER BY `invoiceDateY` ASC [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'confirmed') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) GROUP BY invoiceDateY [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'confirmed') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'confirmed') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idCorporate, SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`cashedStatus` != ?) AND (`dueDate` < ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY idCorporate ORDER BY `duePayWrk_sum` DESC LIMIT 20 [ (0=>'isiss') (1=>'2020') (2=>'2025') (3=>'0') (4=>'t') (5=>'2025-11-24') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'10485') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15372') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15365') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'18240') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'18236') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15379') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15388') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15366') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'331') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15431') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15084') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15443') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'15380') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idCorporate, SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`cashedStatus` != ?) AND (`dueDate` < ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) AND (`idCorporate` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY idCorporate [ (0=>'isissiiiiiiiiiiiii') (1=>'2020') (2=>'2025') (3=>'0') (4=>'t') (5=>'2025-11-24') (6=>'10485') (7=>'15372') (8=>'15365') (9=>'18240') (10=>'18236') (11=>'15379') (12=>'15388') (13=>'15366') (14=>'331') (15=>'15431') (16=>'15084') (17=>'15443') (18=>'15380') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`cashedStatus` != ?) AND (`dueDate` < ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) AND (`idCorporate` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) [ (0=>'isissiiiiiiiiiiiii') (1=>'2020') (2=>'2025') (3=>'0') (4=>'t') (5=>'2025-11-24') (6=>'10485') (7=>'15372') (8=>'15365') (9=>'18240') (10=>'18236') (11=>'15379') (12=>'15388') (13=>'15366') (14=>'331') (15=>'15431') (16=>'15084') (17=>'15443') (18=>'15380') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`cashedStatus` != ?) AND (`dueDate` < ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) [ (0=>'isiss') (1=>'2020') (2=>'2025') (3=>'0') (4=>'t') (5=>'2025-11-24') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idSupplier, SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`payedStatus` != ?) AND (`dueDate` < ?) AND (`statusOp` = ?) GROUP BY idSupplier ORDER BY `duePayWrk_sum` DESC LIMIT 20 [ (0=>'issss') (1=>'2020') (2=>'2025') (3=>'t') (4=>'2025-11-24') (5=>'confirmed') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'503') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idSupplier, SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`payedStatus` != ?) AND (`dueDate` < ?) AND (`statusOp` = ?) AND (`idSupplier` IN (?)) GROUP BY idSupplier [ (0=>'issssi') (1=>'2020') (2=>'2025') (3=>'t') (4=>'2025-11-24') (5=>'confirmed') (6=>'503') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`payedStatus` != ?) AND (`dueDate` < ?) AND (`statusOp` = ?) AND (`idSupplier` NOT IN (?)) [ (0=>'issssi') (1=>'2020') (2=>'2025') (3=>'t') (4=>'2025-11-24') (5=>'confirmed') (6=>'503') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`duePayWrk`) AS `duePayWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`payedStatus` != ?) AND (`dueDate` < ?) AND (`statusOp` = ?) [ (0=>'issss') (1=>'2020') (2=>'2025') (3=>'t') (4=>'2025-11-24') (5=>'confirmed') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`rowProfitWrk`) AS `rowProfitWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY invoiceDateY [ (0=>'is') (1=>'2022') (2=>'2025') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`rowProfitWrk`) AS `rowProfitWrk_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) [ (0=>'is') (1=>'2022') (2=>'2025') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT `value` FROM `pivotTablesConfigs` WHERE `pivotSource`= ? AND `var`= ? [ (0=>'ss') (1=>'OrderServices') (2=>'status') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT balanceVirtualDateY FROM `pivotTablesData_orderServices` WHERE (`balanceVirtualDateY` BETWEEN ? AND ?) AND (`balanced` = ?) AND (`statusOp` = ?) GROUP BY balanceVirtualDateY ORDER BY `balanceVirtualDateY` ASC [ (0=>'isss') (1=>'2022') (2=>'2025') (3=>'1') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT balanceVirtualDateY, SUM(`balanceProfitDef`) AS `balanceProfitDef_sum` FROM `pivotTablesData_orderServices` WHERE (`balanceVirtualDateY` BETWEEN ? AND ?) AND (`balanced` = ?) AND (`statusOp` = ?) GROUP BY balanceVirtualDateY [ (0=>'isss') (1=>'2022') (2=>'2025') (3=>'1') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`balanceProfitDef`) AS `balanceProfitDef_sum` FROM `pivotTablesData_orderServices` WHERE (`balanceVirtualDateY` BETWEEN ? AND ?) AND (`balanced` = ?) AND (`statusOp` = ?) [ (0=>'isss') (1=>'2022') (2=>'2025') (3=>'1') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerDestCountryCode, SUM(`pax`) AS `pax_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) GROUP BY offerDestCountryCode ORDER BY `pax_sum` DESC LIMIT 10 [ (0=>'iss') (1=>'2021') (2=>'2025') (3=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'RO') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'FR') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'BR') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'SA') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'KW') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'CD') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'MX') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'DE') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'PA') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerStartDateY FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) GROUP BY offerStartDateY ORDER BY `offerStartDateY` ASC [ (0=>'iss') (1=>'2021') (2=>'2025') (3=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerDestCountryCode, offerStartDateY, SUM(`pax`) AS `pax_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY offerDestCountryCode, offerStartDateY [ (0=>'issssssssssss') (1=>'2021') (2=>'2025') (3=>'OK') (4=>'') (5=>'RO') (6=>'FR') (7=>'BR') (8=>'SA') (9=>'KW') (10=>'CD') (11=>'MX') (12=>'DE') (13=>'PA') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerStartDateY, SUM(`pax`) AS `pax_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`offerStartDateY` IN (?, ?, ?)) GROUP BY offerStartDateY [ (0=>'issssssssssssiii') (1=>'2021') (2=>'2025') (3=>'OK') (4=>'') (5=>'RO') (6=>'FR') (7=>'BR') (8=>'SA') (9=>'KW') (10=>'CD') (11=>'MX') (12=>'DE') (13=>'PA') (14=>'2021') (15=>'2022') (16=>'2023') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerDestCountryCode, SUM(`pax`) AS `pax_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY offerDestCountryCode [ (0=>'issssssssssss') (1=>'2021') (2=>'2025') (3=>'OK') (4=>'') (5=>'RO') (6=>'FR') (7=>'BR') (8=>'SA') (9=>'KW') (10=>'CD') (11=>'MX') (12=>'DE') (13=>'PA') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`pax`) AS `pax_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) [ (0=>'issssssssssss') (1=>'2021') (2=>'2025') (3=>'OK') (4=>'') (5=>'RO') (6=>'FR') (7=>'BR') (8=>'SA') (9=>'KW') (10=>'CD') (11=>'MX') (12=>'DE') (13=>'PA') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerStartDateY, SUM(`pax`) AS `pax_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) GROUP BY offerStartDateY [ (0=>'iss') (1=>'2021') (2=>'2025') (3=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerDestCountryCode, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) GROUP BY offerDestCountryCode ORDER BY `invoiceTtlDef_sum` DESC LIMIT 10 [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'PG') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'NL') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `countries` WHERE `code`=? [ (0=>'s') (1=>'CN') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) GROUP BY invoiceDateY ORDER BY `invoiceDateY` ASC [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerDestCountryCode, invoiceDateY, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY offerDestCountryCode, invoiceDateY [ (0=>'isssssssssssss') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') (5=>'') (6=>'FR') (7=>'RO') (8=>'CD') (9=>'SA') (10=>'PA') (11=>'PG') (12=>'NL') (13=>'KW') (14=>'CN') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`invoiceDateY` IN (?, ?, ?)) GROUP BY invoiceDateY [ (0=>'isssssssssssssiii') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') (5=>'') (6=>'FR') (7=>'RO') (8=>'CD') (9=>'SA') (10=>'PA') (11=>'PG') (12=>'NL') (13=>'KW') (14=>'CN') (15=>'2021') (16=>'2022') (17=>'2023') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerDestCountryCode, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY offerDestCountryCode [ (0=>'isssssssssssss') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') (5=>'') (6=>'FR') (7=>'RO') (8=>'CD') (9=>'SA') (10=>'PA') (11=>'PG') (12=>'NL') (13=>'KW') (14=>'CN') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) AND (`offerDestCountryCode` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) [ (0=>'isssssssssssss') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') (5=>'') (6=>'FR') (7=>'RO') (8=>'CD') (9=>'SA') (10=>'PA') (11=>'PG') (12=>'NL') (13=>'KW') (14=>'CN') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusFin` = ?) AND (`statusOp` = ?) GROUP BY invoiceDateY [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'TI') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idCorporate, SUM(`rowTtlDef`) AS `rowTtlDef_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY idCorporate ORDER BY `rowTtlDef_sum` DESC LIMIT 10 [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'0') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'17661') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `corporates` WHERE `id`=? [ (0=>'i') (1=>'14061') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY invoiceDateY ORDER BY `invoiceDateY` ASC [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'0') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idCorporate, invoiceDateY, SUM(`rowTtlDef`) AS `rowTtlDef_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) AND (`idCorporate` IN (?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY idCorporate, invoiceDateY [ (0=>'issiiiiiiii') (1=>'2022') (2=>'2025') (3=>'0') (4=>'18240') (5=>'15372') (6=>'10485') (7=>'17661') (8=>'18236') (9=>'15431') (10=>'15443') (11=>'14061') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`rowTtlDef`) AS `rowTtlDef_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) AND (`idCorporate` NOT IN (?, ?, ?, ?, ?, ?, ?, ?)) AND (`invoiceDateY` IN (?, ?)) GROUP BY invoiceDateY [ (0=>'issiiiiiiiiii') (1=>'2022') (2=>'2025') (3=>'0') (4=>'18240') (5=>'15372') (6=>'10485') (7=>'17661') (8=>'18236') (9=>'15431') (10=>'15443') (11=>'14061') (12=>'2022') (13=>'2023') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idCorporate, SUM(`rowTtlDef`) AS `rowTtlDef_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) AND (`idCorporate` IN (?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY idCorporate [ (0=>'issiiiiiiii') (1=>'2022') (2=>'2025') (3=>'0') (4=>'18240') (5=>'15372') (6=>'10485') (7=>'17661') (8=>'18236') (9=>'15431') (10=>'15443') (11=>'14061') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`rowTtlDef`) AS `rowTtlDef_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) AND (`idCorporate` NOT IN (?, ?, ?, ?, ?, ?, ?, ?)) [ (0=>'issiiiiiiii') (1=>'2022') (2=>'2025') (3=>'0') (4=>'18240') (5=>'15372') (6=>'10485') (7=>'17661') (8=>'18236') (9=>'15431') (10=>'15443') (11=>'14061') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`rowTtlDef`) AS `rowTtlDef_sum` FROM `pivotTablesData_clientInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`idCorporate` > ?) AND (`invoiceVoidDate` IS NULL) AND (`invoiceIssueDate` IS NOT NULL) GROUP BY invoiceDateY [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'0') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idSupplier, SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) GROUP BY idSupplier ORDER BY `rowTtlWrk_sum` DESC LIMIT 10 [ (0=>'iss') (1=>'2022') (2=>'2025') (3=>'confirmed') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'13474') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'16867') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'9875') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'11526') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idSupplier, invoiceDateY, SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`idSupplier` IN (?, ?, ?, ?, ?)) GROUP BY idSupplier, invoiceDateY [ (0=>'issiiiii') (1=>'2022') (2=>'2025') (3=>'confirmed') (4=>'503') (5=>'13474') (6=>'16867') (7=>'9875') (8=>'11526') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT invoiceDateY, SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`idSupplier` NOT IN (?, ?, ?, ?, ?)) AND (`invoiceDateY` IN (?, ?)) GROUP BY invoiceDateY [ (0=>'issiiiiiii') (1=>'2022') (2=>'2025') (3=>'confirmed') (4=>'503') (5=>'13474') (6=>'16867') (7=>'9875') (8=>'11526') (9=>'2022') (10=>'2023') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT idSupplier, SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`idSupplier` IN (?, ?, ?, ?, ?)) GROUP BY idSupplier [ (0=>'issiiiii') (1=>'2022') (2=>'2025') (3=>'confirmed') (4=>'503') (5=>'13474') (6=>'16867') (7=>'9875') (8=>'11526') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`rowTtlWrk`) AS `rowTtlWrk_sum` FROM `pivotTablesData_supplierInvoiceRows` WHERE (`invoiceDateY` BETWEEN ? AND ?) AND (`statusOp` = ?) AND (`idSupplier` NOT IN (?, ?, ?, ?, ?)) [ (0=>'issiiiii') (1=>'2022') (2=>'2025') (3=>'confirmed') (4=>'503') (5=>'13474') (6=>'16867') (7=>'9875') (8=>'11526') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerIdSupplier, COUNT(`id`) AS `id_count` FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) GROUP BY offerIdSupplier ORDER BY `id_count` DESC LIMIT 10 [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'128') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'20372') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'362') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'530') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'681') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'1099') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'263') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliers` WHERE `id`=? [ (0=>'i') (1=>'229') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT ticketsDateY FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) GROUP BY ticketsDateY ORDER BY `ticketsDateY` ASC [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerIdSupplier, ticketsDateY, COUNT(`id`) AS `id_count` FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) AND (`offerIdSupplier` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY offerIdSupplier, ticketsDateY [ (0=>'isssiiiiiiiiii') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') (5=>'503') (6=>'128') (7=>'20372') (8=>'16867') (9=>'362') (10=>'530') (11=>'681') (12=>'1099') (13=>'263') (14=>'229') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT ticketsDateY, COUNT(`id`) AS `id_count` FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) AND (`offerIdSupplier` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`ticketsDateY` IN (?, ?, ?)) GROUP BY ticketsDateY [ (0=>'isssiiiiiiiiiiiii') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') (5=>'503') (6=>'128') (7=>'20372') (8=>'16867') (9=>'362') (10=>'530') (11=>'681') (12=>'1099') (13=>'263') (14=>'229') (15=>'2021') (16=>'2022') (17=>'2023') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerIdSupplier, COUNT(`id`) AS `id_count` FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) AND (`offerIdSupplier` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY offerIdSupplier [ (0=>'isssiiiiiiiiii') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') (5=>'503') (6=>'128') (7=>'20372') (8=>'16867') (9=>'362') (10=>'530') (11=>'681') (12=>'1099') (13=>'263') (14=>'229') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT COUNT(`id`) AS `id_count` FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) AND (`offerIdSupplier` NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) [ (0=>'isssiiiiiiiiii') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') (5=>'503') (6=>'128') (7=>'20372') (8=>'16867') (9=>'362') (10=>'530') (11=>'681') (12=>'1099') (13=>'263') (14=>'229') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT ticketsDateY, COUNT(`id`) AS `id_count` FROM `pivotTablesData_orderServices` WHERE (`ticketsDateY` BETWEEN ? AND ?) AND (`serviceCategory` = ?) AND (`statusOp` = ?) GROUP BY ticketsDateY [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'airTransport') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerIdSupplierProduct, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) GROUP BY offerIdSupplierProduct ORDER BY `invoiceTtlDef_sum` DESC LIMIT 10 [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliersProducts` WHERE `id`=? [ (0=>'i') (1=>'1854') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliersProducts` WHERE `id`=? [ (0=>'i') (1=>'1676') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT * FROM `suppliersProducts` WHERE `id`=? [ (0=>'i') (1=>'1366') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerStartDateY FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) GROUP BY offerStartDateY ORDER BY `offerStartDateY` ASC [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerIdSupplierProduct, offerStartDateY, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) AND (`offerIdSupplierProduct` IN (?, ?, ?)) GROUP BY offerIdSupplierProduct, offerStartDateY [ (0=>'isssiii') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') (5=>'1854') (6=>'1676') (7=>'1366') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerStartDateY, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) AND (`offerIdSupplierProduct` NOT IN (?, ?, ?)) AND (`offerStartDateY` IN (?, ?)) GROUP BY offerStartDateY [ (0=>'isssiiiii') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') (5=>'1854') (6=>'1676') (7=>'1366') (8=>'2021') (9=>'2022') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerIdSupplierProduct, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) AND (`offerIdSupplierProduct` IN (?, ?, ?)) GROUP BY offerIdSupplierProduct [ (0=>'isssiii') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') (5=>'1854') (6=>'1676') (7=>'1366') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) AND (`offerIdSupplierProduct` NOT IN (?, ?, ?)) [ (0=>'isssiii') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') (5=>'1854') (6=>'1676') (7=>'1366') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli SELECT offerStartDateY, SUM(`invoiceTtlDef`) AS `invoiceTtlDef_sum` FROM `pivotTablesData_orderServices` WHERE (`offerStartDateY` BETWEEN ? AND ?) AND (`offerIdSupplierProduct` != ?) AND (`statusOp` = ?) GROUP BY offerStartDateY [ (0=>'isss') (1=>'2021') (2=>'2025') (3=>'0') (4=>'OK') ] ------------------------------------------------------------------------------

2025-11-24 12:40:18.93073816.0Mbinfo13 QR widget(s) had their data cached.

------------------------------------------------------------------------------ mysqli UPDATE `cronJobs` SET `settings`=?, `lastUpdateTime`=?, `idUpdateUser`=?, `updatesCount`=updatesCount+1 WHERE `id`=? [ (0=>'ssis') (1=>'a:1:{s:17:"StopAndRestartJob";a:1:{s:8:"restarts";a:0:{}}}') (2=>'2025-11-24 12:40:17') (3=>'0') (4=>'QuickReportsPopulate') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli UPDATE `cronJobs` SET `status`=?, `lastUpdateTime`=?, `idUpdateUser`=?, `updatesCount`=updatesCount+1 WHERE `id`=? [ (0=>'ssis') (1=>'a:8:{s:8:"progress";d:1;s:12:"progressStep";i:0;s:13:"progressSt...') (2=>'2025-11-24 12:40:17') (3=>'0') (4=>'QuickReportsPopulate') ] ------------------------------------------------------------------------------

2025-11-24 12:40:18.93192116.0MbinfoCronjob execution ended.

------------------------------------------------------------------------------ mysqli UPDATE `cronJobsLogs` SET `status`=?, `errorStatus`=? WHERE `id`=? [ (0=>'sss') (1=>'ended') (2=>'is') (3=>'190488') ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ mysqli INSERT INTO `zzUserTraces_202511` ( `module`, `action`, `entityType`, `entityOperation`, `idEntity`, `extraData`, `timestamp`, `idUser` ) VALUES (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?), (?, ?, ?, ?, ?, ?, ?, ?) [ (0=>'ssssssdissssssdissssssdissssssdissssssdi') (1=>'') (2=>'') (3=>'CronJob') (4=>'update') (5=>'QuickReportsPopulate') (6=>'') (7=>'1763980817.6155') (8=>'0') (9=>'Modules/Admin/CronJobs/Runner') (10=>'actionRun') (11=>'') (12=>'') (13=>'') (14=>'') (15=>'1763980817.6158') (16=>'0') (17=>'Modules/Admin/CronJobs/Runner') (18=>'actionRun') (19=>'CronJob') (20=>'update') (21=>'QuickReportsPopulate') (22=>'') (23=>'1763980817.6177') (24=>'0') (25=>'Modules/Admin/CronJobs/Runner') (26=>'actionRun') (27=>'App\ReportsData\Params') (28=>'save') (29=>'') (30=>'') (31=>'1763980817.6473') (32=>'0') (33=>'Modules/Admin/CronJobs/Runner') (34=>'actionRun') (35=>'CronJob') (36=>'update') (37=>'QuickReportsPopulate') (38=>'') (39=>'1763980818.9314') (40=>'0') ] ------------------------------------------------------------------------------