Connected to STFP Server
Current Dir: /
nlist: 
Array
(
    [0] => .
    [1] => ice_pod_EFS114837.csv
    [2] => ice_pod_EFS114837.pdf
)
rawlist: 
Array
(
    [.] => Array
        (
            [size] => 0
            [mode] => 16877
            [type] => 2
            [atime] => 0
            [mtime] => 0
            [filename] => .
        )

    [ice_pod_EFS114837.csv] => Array
        (
            [size] => 35
            [mode] => 33188
            [type] => 1
            [atime] => 1766031008
            [mtime] => 1766031008
            [filename] => ice_pod_EFS114837.csv
        )

    [ice_pod_EFS114837.pdf] => Array
        (
            [size] => 69294
            [mode] => 33188
            [type] => 1
            [atime] => 1766030822
            [mtime] => 1766030822
            [filename] => ice_pod_EFS114837.pdf
        )

)
No Name Match: rawlist:
File Match
File ext: csv
File Match
File ext: pdf
Array
(
    [0] => Array
        (
            [size] => 35
            [mode] => 33188
            [type] => 1
            [atime] => 1766031008
            [mtime] => 1766031008
            [filename] => ice_pod_EFS114837.csv
        )

    [1] => Array
        (
            [size] => 69294
            [mode] => 33188
            [type] => 1
            [atime] => 1766030822
            [mtime] => 1766030822
            [filename] => ice_pod_EFS114837.pdf
        )

)
================
== Start Loop ==
================
Key: 0
Code: held

SELECT
transport.*,

clients_id,
clients_ref,
clients_name,
clients_import_tags,

importgroups_name,
importgroups_clients_ref
FROM
transport
LEFT JOIN clients on transport_clients_ref = clients_ref
LEFT JOIN importgroups ON clients_importgroups_ref = importgroups_ref
WHERE
transport_import_held_id = '0'
AND
transport_status_id = '2'
AND
transport_sched_datetime > '2025-11-18 00:00:00'
AND
importgroups_name != ''
AND
transport_reference != ''

num rows: 0
==================
Key: 1
Code: transit

SELECT
transport.*,

clients_id,
clients_ref,
clients_name,
clients_import_tags,

importgroups_name,
importgroups_clients_ref
FROM
transport
LEFT JOIN clients on transport_clients_ref = clients_ref
LEFT JOIN importgroups ON clients_importgroups_ref = importgroups_ref
WHERE
transport_import_transit_id = '0'
AND
transport_status_id = '3'
AND
transport_sched_datetime > '2025-11-18 00:00:00'
AND
importgroups_name != ''
AND
transport_reference != ''

num rows: 0
==================
Key: 2
Code: pod

SELECT
transport.*,

clients_id,
clients_ref,
clients_name,
clients_import_tags,

importgroups_name,
importgroups_clients_ref
FROM
transport
LEFT JOIN clients on transport_clients_ref = clients_ref
LEFT JOIN importgroups ON clients_importgroups_ref = importgroups_ref
WHERE
transport_import_pod_id = '0'
AND
transport_status_id = '4'
AND
transport_sched_datetime > '2025-11-18 00:00:00'
AND
importgroups_name != ''
AND
transport_reference != ''

num rows: 0
==================
Done... refetch the list
Array
(
    [.] => Array
        (
            [size] => 0
            [mode] => 16877
            [type] => 2
            [atime] => 0
            [mtime] => 0
            [filename] => .
        )

    [ice_pod_EFS114837.csv] => Array
        (
            [size] => 35
            [mode] => 33188
            [type] => 1
            [atime] => 1766031008
            [mtime] => 1766031008
            [filename] => ice_pod_EFS114837.csv
        )

    [ice_pod_EFS114837.pdf] => Array
        (
            [size] => 69294
            [mode] => 33188
            [type] => 1
            [atime] => 1766030822
            [mtime] => 1766030822
            [filename] => ice_pod_EFS114837.pdf
        )

)
IDStatusCustomerGeneral RefClient Ref