SELECT * FROM `invoice` WHERE status='pendingsettlement'
Array
(
    [id] => 1231
    [m_invoice_id] => 6203524863
    [q_rid] => 1
    [q_invoice_id] => 18224
    [q_payment_id] => 18225
    [status] => pendingsettlement
    [created_at] => 2021-04-27 01:02:06
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1392
    [m_invoice_id] => 6275348537
    [q_rid] => 1
    [q_invoice_id] => 19235
    [q_payment_id] => 19241
    [status] => pendingsettlement
    [created_at] => 2021-05-23 01:12:09
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1507
    [m_invoice_id] => 6317400319
    [q_rid] => 1
    [q_invoice_id] => 19308
    [q_payment_id] => 19309
    [status] => pendingsettlement
    [created_at] => 2021-06-07 08:07:09
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1575
    [m_invoice_id] => 6336354110
    [q_rid] => 1
    [q_invoice_id] => 19323
    [q_payment_id] => 19330
    [status] => pendingsettlement
    [created_at] => 2021-06-14 10:15:09
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1790
    [m_invoice_id] => 6381594699
    [q_rid] => 1
    [q_invoice_id] => 19728
    [q_payment_id] => 19729
    [status] => pendingsettlement
    [created_at] => 2021-07-01 12:14:53
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1799
    [m_invoice_id] => 6381595815
    [q_rid] => 1
    [q_invoice_id] => 19746
    [q_payment_id] => 19747
    [status] => pendingsettlement
    [created_at] => 2021-07-01 12:15:39
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 3106
    [m_invoice_id] => 6604997056
    [q_rid] => 1408
    [q_invoice_id] => 1628
    [q_payment_id] => 1629
    [status] => pendingsettlement
    [created_at] => 2021-09-23 06:26:08
    [modified_at] => 0000-00-00 00:00:00
)
dedicatedcpaapi
Magic2021!
Array
(
    [id] => 4279
    [m_invoice_id] => 6944391225
    [q_rid] => 1
    [q_invoice_id] => 22794
    [q_payment_id] => 22795
    [status] => pendingsettlement
    [created_at] => 2022-02-01 12:21:20
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 7948
    [m_invoice_id] => 8108433562
    [q_rid] => 1
    [q_invoice_id] => 29741
    [q_payment_id] => 29742
    [status] => pendingsettlement
    [created_at] => 2023-03-01 11:10:39
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123