SELECT * FROM `invoice` WHERE status='pendingsettlement'
Array
(
    [id] => 1231
    [m_invoice_id] => 6203524863
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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
    [dup] => 0
    [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] => 10460
    [m_invoice_id] => 8881423490
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 34707
    [q_payment_id] => 34708
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20231103171948
    [amount] => 1249.97
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2023-11-03 05:25:11
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 10584
    [m_invoice_id] => 8918190418
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 35078
    [q_payment_id] => 35079
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20231115092101
    [amount] => 414
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2023-11-15 09:25:18
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 10744
    [m_invoice_id] => 8960196822
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 35667
    [q_payment_id] => 35668
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20231129001640
    [amount] => 151.75
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2023-11-29 12:20:09
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 11971
    [m_invoice_id] => 9052842794
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 35972
    [q_payment_id] => 35973
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20231227175947
    [amount] => 20
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2023-12-27 06:05:12
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 12156
    [m_invoice_id] => 9067861061
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 36577
    [q_payment_id] => 36578
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20240101110447
    [amount] => 15
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2024-01-05 12:10:45
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 12434
    [m_invoice_id] => 9149978625
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 36843
    [q_payment_id] => 36844
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20240125201637
    [amount] => 1572.9
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2024-01-25 08:20:10
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 12592
    [m_invoice_id] => 9170617233
    [dup] => 0
    [q_rid] => 1
    [q_invoice_id] => 36908
    [q_payment_id] => 36909
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 20240201105821
    [amount] => 500
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2024-02-06 11:11:55
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 12957
    [m_invoice_id] => 9255074153
    [dup] => 0
    [q_rid] => 1411
    [q_invoice_id] => 45340
    [q_payment_id] => 45444
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 
    [amount] => 1650
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2024-02-26 11:30:07
    [modified_at] => 0000-00-00 00:00:00
)
jaredfbaker@ipsvqs.com
z2g8ND2egeEijnv
Array
(
    [id] => 12958
    [m_invoice_id] => 9255077178
    [dup] => 0
    [q_rid] => 1411
    [q_invoice_id] => 45397
    [q_payment_id] => 45445
    [status] => pendingsettlement
    [error_message] => Confirmed
    [m_created_date] => 
    [amount] => 313.14
    [payment_method] => ck
    [transaction_type] => sale
    [created_at] => 2024-02-26 11:30:11
    [modified_at] => 0000-00-00 00:00:00
)
jaredfbaker@ipsvqs.com
z2g8ND2egeEijnv