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
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
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
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
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
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
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
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
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