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] => 1239
    [m_invoice_id] => 6208950904
    [q_rid] => 1
    [q_invoice_id] => 17867
    [q_payment_id] => 18228
    [status] => pendingsettlement
    [created_at] => 2021-04-29 08:33:05
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1242
    [m_invoice_id] => 6210992671
    [q_rid] => 1
    [q_invoice_id] => 18236
    [q_payment_id] => 18237
    [status] => pendingsettlement
    [created_at] => 2021-04-30 01:03:06
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1256
    [m_invoice_id] => 6215682368
    [q_rid] => 1
    [q_invoice_id] => 18255
    [q_payment_id] => 18256
    [status] => pendingsettlement
    [created_at] => 2021-05-01 11:05:44
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1258
    [m_invoice_id] => 6215682518
    [q_rid] => 1
    [q_invoice_id] => 18259
    [q_payment_id] => 18260
    [status] => pendingsettlement
    [created_at] => 2021-05-01 11:05:54
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1260
    [m_invoice_id] => 6215682680
    [q_rid] => 1
    [q_invoice_id] => 18263
    [q_payment_id] => 18264
    [status] => pendingsettlement
    [created_at] => 2021-05-01 11:06:07
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1262
    [m_invoice_id] => 6215682776
    [q_rid] => 1
    [q_invoice_id] => 18267
    [q_payment_id] => 18268
    [status] => pendingsettlement
    [created_at] => 2021-05-01 11:06:19
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1265
    [m_invoice_id] => 6215683093
    [q_rid] => 1
    [q_invoice_id] => 18131
    [q_payment_id] => 18273
    [status] => pendingsettlement
    [created_at] => 2021-05-01 11:06:36
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123
Array
(
    [id] => 1266
    [m_invoice_id] => 6215683329
    [q_rid] => 1
    [q_invoice_id] => 18274
    [q_payment_id] => 18275
    [status] => pendingsettlement
    [created_at] => 2021-05-01 11:06:42
    [modified_at] => 0000-00-00 00:00:00
)
magicpay123
noshmim123