/* Origin (request): GET https://testtra.puntlandgov.org
   Query 11 - 2025-02-26 09:37:22 [286.13ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 1 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2025-02-26' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): GET https://testtra.puntlandgov.org
   Query 12 - 2025-02-26 09:37:23 [876.73ms] */
select sum(`outstanding_balance`) as aggregate from `invoice` inner join `transaction` on `invoice`.`transaction_id` = `transaction`.`id` where `transaction`.`service_id` = 2 and `invoice`.`invoice_amount` <> 0.00 and `due_date` < '2025-02-26' and `invoice`.`deleted_at` is null;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/api/make_payments
   Query 7 - 2025-02-26 11:59:18 [114.71ms] */
select count(*) as aggregate from `payment` where `external_payment_reference_no` = 'PR233F1AA3';
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/api/make_payments
   Query 21 - 2025-02-26 11:59:19 [425.69ms] */
select * from `transaction` where `invoice_id` = 485894 and `transaction`.`deleted_at` is null limit 1;
/*==================================================*/
/* Origin (request): POST https://testtra.puntlandgov.org/api/make_payments
   Query 21 - 2025-02-26 12:05:42 [492.42ms] */
select * from `transaction` where `invoice_id` = 485893 and `transaction`.`deleted_at` is null limit 1;
/*==================================================*/
