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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [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 [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [created_at] => 2023-03-01 11:10:39 [modified_at] => 0000-00-00 00:00:00 )magicpay123
Array ( [id] => 8273 [m_invoice_id] => 8206979316 [q_rid] => 1 [q_invoice_id] => 30517 [q_payment_id] => 30518 [status] => pendingsettlement [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [created_at] => 2023-04-01 11:00:22 [modified_at] => 0000-00-00 00:00:00 )magicpay123
Array ( [id] => 8554 [m_invoice_id] => 7036844445 [q_rid] => 12 [q_invoice_id] => 31 [q_payment_id] => 32 [status] => pendingsettlement [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [created_at] => 2023-05-03 08:53:00 [modified_at] => 0000-00-00 00:00:00 )mansiadroja1
Array ( [id] => 8707 [m_invoice_id] => 8357255837 [q_rid] => 1411 [q_invoice_id] => 40874 [q_payment_id] => 41192 [status] => pendingsettlement [error_message] => [m_created_date] => 0000-00-00 00:00:00 [amount] => 0 [payment_method] => [transaction_type] => [created_at] => 2023-05-18 04:55:07 [modified_at] => 0000-00-00 00:00:00 )jaredfbaker@ipsvqs.com
Array ( [id] => 9450 [m_invoice_id] => 8606911725 [q_rid] => 1 [q_invoice_id] => 33107 [q_payment_id] => 33108 [status] => pendingsettlement [error_message] => Confirmed [m_created_date] => 20230807230253 [amount] => 2662.92 [payment_method] => ck [transaction_type] => sale [created_at] => 2023-08-07 11:05:10 [modified_at] => 0000-00-00 00:00:00 )magicpay123
Array ( [id] => 9534 [m_invoice_id] => 8628656269 [q_rid] => 1 [q_invoice_id] => 33257 [q_payment_id] => 33258 [status] => pendingsettlement [error_message] => Confirmed [m_created_date] => 20230815092413 [amount] => 414 [payment_method] => ck [transaction_type] => sale [created_at] => 2023-08-15 09:30:16 [modified_at] => 0000-00-00 00:00:00 )magicpay123
Array ( [id] => 9973 [m_invoice_id] => 8759684404 [q_rid] => 1411 [q_invoice_id] => 43010 [q_payment_id] => 43272 [status] => pendingsettlement [error_message] => Confirmed [m_created_date] => [amount] => 1958 [payment_method] => ck [transaction_type] => sale [created_at] => 2023-09-26 04:25:07 [modified_at] => 0000-00-00 00:00:00 )jaredfbaker@ipsvqs.com
Array ( [id] => 9982 [m_invoice_id] => 8763070651 [q_rid] => 1411 [q_invoice_id] => 43006 [q_payment_id] => 43279 [status] => pendingsettlement [error_message] => Confirmed [m_created_date] => [amount] => 1030.85 [payment_method] => ck [transaction_type] => sale [created_at] => 2023-09-27 07:15:07 [modified_at] => 0000-00-00 00:00:00 )jaredfbaker@ipsvqs.com
Array ( [id] => 9983 [m_invoice_id] => 8763080227 [q_rid] => 1411 [q_invoice_id] => 43009 [q_payment_id] => 43280 [status] => pendingsettlement [error_message] => Confirmed [m_created_date] => [amount] => 594.5 [payment_method] => ck [transaction_type] => sale [created_at] => 2023-09-27 07:20:06 [modified_at] => 0000-00-00 00:00:00 )jaredfbaker@ipsvqs.com
Array ( [id] => 9984 [m_invoice_id] => 8763088140 [q_rid] => 1411 [q_invoice_id] => 43008 [q_payment_id] => 43281 [status] => pendingsettlement [error_message] => Confirmed [m_created_date] => [amount] => 331.34 [payment_method] => ck [transaction_type] => sale [created_at] => 2023-09-27 07:20:10 [modified_at] => 0000-00-00 00:00:00 )jaredfbaker@ipsvqs.com