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
noshmim123
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
noshmim123
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
noshmim123
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
noshmim123
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
noshmim123
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
noshmim123
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
Magic2021!
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
noshmim123
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
noshmim123
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
noshmim123
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
Kavu2901
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
z2g8ND2egeEijnv
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
noshmim123
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
noshmim123
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
z2g8ND2egeEijnv
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
z2g8ND2egeEijnv
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
z2g8ND2egeEijnv
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
z2g8ND2egeEijnv