2026-02-23 13:12:48 - POST RECEIVED!
2026-02-23 13:12:48 - DATA: Array
(
    [supplier] => 001
    [item] => 2602231273
    [quantity] => 12
    [price] => 350
)

2026-02-23 13:12:48 - Processing: 001, 2602231273, 12, 350
2026-02-23 13:12:48 - ERROR: Database query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'INSERT INTO'
2026-02-23 13:13:33 - POST RECEIVED!
2026-02-23 13:13:33 - DATA: Array
(
    [supplier] => 001
    [item] => 2602231273
    [quantity] => 12
    [price] => 350
)

2026-02-23 13:13:33 - Processing: 001, 2602231273, 12, 350
2026-02-23 13:13:33 - ERROR: Database query failed: SQLSTATE[HY000]: General error: 1364 Field 'total_weight' doesn't have a default value
2026-02-23 13:14:09 - POST RECEIVED!
2026-02-23 13:14:09 - DATA: Array
(
    [supplier] => 001
    [item] => 2602231273
    [quantity] => 12
    [price] => 350
)

2026-02-23 13:14:09 - Processing: 001, 2602231273, 12, 350
2026-02-23 13:14:09 - ERROR: Database query failed: SQLSTATE[HY000]: General error: 1364 Field 'total_weight' doesn't have a default value
2026-02-23 13:17:09 - POST RECEIVED!
2026-02-23 13:17:09 - DATA: Array
(
    [supplier] => 001
    [item] => 2602231273
    [quantity] => 12
    [price] => 350
)

2026-02-23 13:17:09 - Processing: 001, 2602231273, 12, 350
2026-02-23 13:17:09 - ERROR: Database query failed: SQLSTATE[HY000]: General error: 1364 Field 'total_weight' doesn't have a default value
2026-02-23 13:17:34 - POST RECEIVED!
2026-02-23 13:17:34 - DATA: Array
(
    [supplier] => 001
    [item] => 2602231273
    [quantity] => 12
    [price] => 350
)

2026-02-23 13:17:34 - Processing: 001, 2602231273, 12, 350
2026-02-23 13:17:34 - ERROR: Database query failed: SQLSTATE[HY000]: General error: 1364 Field 'total_weight' doesn't have a default value
2026-02-23 13:18:17 - POST RECEIVED!
2026-02-23 13:18:17 - DATA: Array
(
    [supplier] => 001
    [item] => 2602231273
    [quantity] => 12
    [price] => 350
)

2026-02-23 13:18:17 - Processing: 001, 2602231273, 12, 350
2026-02-23 13:18:17 - Purchase ID: 6
2026-02-23 13:18:17 - SUCCESS! SAVED TO DATABASE
2026-02-23 13:56:54 - POST RECEIVED!
2026-02-23 13:56:54 - DATA: Array
(
    [supplier] => 001
    [item] => 2602235107
    [quantity] => 20
    [weight] => 200
    [price] => 
)

2026-02-23 13:56:54 - Processing: 001, 2602235107, Type: grams, Qty: 20, Wt: 200, Price: 
2026-02-23 14:02:04 - POST RECEIVED!
2026-02-23 14:02:04 - DATA: Array
(
    [supplier] => 001
    [item] => 2602235107
    [quantity] => 20
    [weight] => 200
    [price] => 
)

2026-02-23 14:02:04 - Processing: 001, 2602235107, Type: grams, Qty: 20, Wt: 200, Price: 
2026-02-23 14:02:04 - Grams calculation:  * 200 = 0
2026-02-23 14:02:04 - Purchase ID: 7
2026-02-23 14:02:04 - ERROR: Database query failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect decimal value: '' for column `silver_jewelry_erp`.`purchase_details`.`rate_per_gram` at row 1
2026-02-23 14:02:30 - POST RECEIVED!
2026-02-23 14:02:30 - DATA: Array
(
    [supplier] => 001
    [item] => 2602235107
    [quantity] => 20
    [weight] => 200
    [price] => 
)

2026-02-23 14:02:30 - Processing: 001, 2602235107, Type: grams, Qty: 20, Wt: 200, Price: 
2026-02-23 14:02:30 - Grams calculation:  * 200 = 0
2026-02-23 14:02:30 - Purchase ID: 8
2026-02-23 14:02:30 - ERROR: Database query failed: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect decimal value: '' for column `silver_jewelry_erp`.`purchase_details`.`rate_per_gram` at row 1
2026-02-23 14:03:39 - POST RECEIVED!
2026-02-23 14:03:39 - DATA: Array
(
    [supplier] => 001
    [item] => 2602235107
    [quantity] => 20
    [weight] => 200
    [price] => 
)

2026-02-23 14:03:39 - Processing: 001, 2602235107, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:03:39 - Grams calculation: 0 * 200 = 0
2026-02-23 14:03:39 - Purchase ID: 9
2026-02-23 14:03:40 - SUCCESS! SAVED TO DATABASE
2026-02-23 14:04:39 - POST RECEIVED!
2026-02-23 14:04:39 - DATA: Array
(
    [supplier] => 001
    [item] => 2602237297
    [quantity] => 30
    [weight] => 300
    [price] => 
)

2026-02-23 14:04:39 - Processing: 001, 2602237297, Type: grams, Qty: 30, Wt: 300, Price: 0
2026-02-23 14:04:39 - Grams calculation: 0 * 300 = 0
2026-02-23 14:04:39 - Purchase ID: 10
2026-02-23 14:04:39 - SUCCESS! SAVED TO DATABASE
2026-02-23 14:15:16 - POST RECEIVED!
2026-02-23 14:15:16 - DATA: Array
(
    [supplier] => 001
    [item] => 2602235508
    [quantity] => 30
    [weight] => 300
    [price] => 
)

2026-02-23 14:15:16 - Processing: 001, 2602235508, Type: grams, Qty: 30, Wt: 300, Price: 0
2026-02-23 14:15:16 - Grams calculation: 0 * 300 = 0
2026-02-23 14:15:16 - Purchase ID: 11
2026-02-23 14:15:16 - Inserting into purchase_details: purchase_id=11, item_code=2602235508, quantity=30, weight=300, unit_type=grams, rate_per_gram=0, purchase_price=0, total_amount=0
2026-02-23 14:15:16 - Updating existing stock: adding quantity=30, weight=300
2026-02-23 14:15:16 - SUCCESS! SAVED TO DATABASE
2026-02-23 14:40:01 - POST RECEIVED!
2026-02-23 14:40:01 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 14:37
    [weights] => Array
        (
            [2602237297] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 200
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

    [items] => Array
        (
            [0] => 2602239279
        )

    [quantities] => Array
        (
            [2602239279] => 20
        )

)

2026-02-23 14:40:01 - Purchase ID: 12
2026-02-23 14:40:01 - Processing: 2602239279, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:40:01 - Grams calculation: 0 * 200 = 0
2026-02-23 14:40:01 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 14:40:01 - ERROR: Database query failed: SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters
2026-02-23 14:41:06 - POST RECEIVED!
2026-02-23 14:41:06 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 14:40
    [weights] => Array
        (
            [2602237297] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 200
        )

    [prices] => Array
        (
            [2602231273] => 
        )

    [items] => Array
        (
            [0] => 2602239279
        )

    [quantities] => Array
        (
            [2602239279] => 20
        )

)

2026-02-23 14:41:06 - Purchase ID: 13
2026-02-23 14:41:06 - Processing: 2602239279, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:41:06 - Grams calculation: 0 * 200 = 0
2026-02-23 14:41:06 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 14:41:06 - ERROR: Database query failed: SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters
2026-02-23 14:42:10 - POST RECEIVED!
2026-02-23 14:42:10 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 14:41
    [weights] => Array
        (
            [2602237297] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 200
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

    [items] => Array
        (
            [0] => 2602239279
        )

    [quantities] => Array
        (
            [2602239279] => 20
        )

)

2026-02-23 14:42:10 - Purchase ID: 14
2026-02-23 14:42:10 - Processing: 2602239279, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:42:10 - Grams calculation: 0 * 200 = 0
2026-02-23 14:42:10 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 14:42:10 - ERROR: Database query failed: SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters
2026-02-23 14:47:12 - POST RECEIVED!
2026-02-23 14:47:12 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 14:41
    [weights] => Array
        (
            [2602237297] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 200
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

    [items] => Array
        (
            [0] => 2602239279
        )

    [quantities] => Array
        (
            [2602239279] => 20
        )

)

2026-02-23 14:47:12 - Purchase ID: 15
2026-02-23 14:47:12 - Processing: 2602239279, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:47:12 - Grams calculation: 0 * 200 = 0
2026-02-23 14:47:12 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 14:47:12 - ERROR: Database query failed: SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters
2026-02-23 14:47:44 - POST RECEIVED!
2026-02-23 14:47:44 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 14:47
    [weights] => Array
        (
            [2602237297] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 200
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

    [items] => Array
        (
            [0] => 2602239279
        )

    [quantities] => Array
        (
            [2602239279] => 20
        )

)

2026-02-23 14:47:44 - Purchase ID: 16
2026-02-23 14:47:44 - Processing: 2602239279, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:47:44 - Grams calculation: 0 * 200 = 0
2026-02-23 14:47:44 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 14:47:44 - ERROR: Database query failed: SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters
2026-02-23 14:48:57 - POST RECEIVED!
2026-02-23 14:48:57 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 14:47
    [weights] => Array
        (
            [2602237297] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 200
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

    [items] => Array
        (
            [0] => 2602239279
        )

    [quantities] => Array
        (
            [2602239279] => 20
        )

)

2026-02-23 14:48:57 - Purchase ID: 17
2026-02-23 14:48:57 - Processing: 2602239279, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 14:48:57 - Grams calculation: 0 * 200 = 0
2026-02-23 14:48:57 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 14:48:57 - SUCCESS! SAVED TO DATABASE - Total: 0
2026-02-23 15:47:38 - POST RECEIVED!
2026-02-23 15:47:38 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 15:46
    [weights] => Array
        (
            [2602237297] => 
            [2602239731] => 200
            [2602235107] => 
            [2602235508] => 
        )

    [items] => Array
        (
            [0] => 2602239731
        )

    [quantities] => Array
        (
            [2602239731] => 20
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

)

2026-02-23 15:47:38 - Purchase ID: 18
2026-02-23 15:47:38 - Processing: 2602239731, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-23 15:47:38 - Grams calculation: 0 * 200 = 0
2026-02-23 15:47:38 - Updating existing stock: adding quantity=20, weight=200
2026-02-23 15:47:39 - SUCCESS! SAVED TO DATABASE - Total: 0
2026-02-23 16:24:11 - POST RECEIVED!
2026-02-23 16:24:11 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 16:23
    [weights] => Array
        (
            [2602237297] => 
            [2602239731] => 
            [2602239322] => 300
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 
        )

    [items] => Array
        (
            [0] => 2602239322
        )

    [quantities] => Array
        (
            [2602239322] => 30
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

)

2026-02-23 16:24:11 - Purchase ID: 19
2026-02-23 16:24:11 - Processing: 2602239322, Type: grams, Qty: 30, Wt: 300, Price: 0
2026-02-23 16:24:11 - Grams calculation: 0 * 300 = 0
2026-02-23 16:24:11 - Updating existing stock: adding quantity=30, weight=300
2026-02-23 16:24:11 - SUCCESS! SAVED TO DATABASE - Total: 0
2026-02-23 16:36:38 - POST RECEIVED!
2026-02-23 16:36:38 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-23
    [purchase_time] => 16:36
    [weights] => Array
        (
            [2602237297] => 
            [2602239731] => 
            [2602239322] => 
            [2602234738] => 300
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 
        )

    [items] => Array
        (
            [0] => 2602234738
        )

    [quantities] => Array
        (
            [2602234738] => 30
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

)

2026-02-23 16:36:38 - Purchase ID: 20
2026-02-23 16:36:38 - Processing: 2602234738, Type: grams, Qty: 30, Wt: 300, Price: 0
2026-02-23 16:36:38 - Grams calculation: 0 * 300 = 0
2026-02-23 16:36:38 - Updating existing stock: adding quantity=30, weight=300
2026-02-23 16:36:38 - SUCCESS! SAVED TO DATABASE - Total: 0
2026-02-25 11:16:55 - POST RECEIVED!
2026-02-25 11:16:55 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-25
    [purchase_time] => 11:15
    [weights] => Array
        (
            [2602237297] => 
            [2602239731] => 
            [2602239322] => 
            [2602256655] => 100
            [2602234738] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 
        )

    [items] => Array
        (
            [0] => 2602256655
        )

    [quantities] => Array
        (
            [2602256655] => 10
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

)

2026-02-25 11:16:55 - Purchase ID: 21
2026-02-25 11:16:55 - Processing: 2602256655, Type: grams, Qty: 10, Wt: 100, Price: 0
2026-02-25 11:16:55 - Grams calculation: 0 * 100 = 0
2026-02-25 11:16:55 - Updating existing stock: adding quantity=10, weight=100
2026-02-25 11:16:55 - SUCCESS! SAVED TO DATABASE - Total: 0
2026-02-25 11:26:34 - POST RECEIVED!
2026-02-25 11:26:34 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-02-25
    [purchase_time] => 11:26
    [items] => Array
        (
            [0] => 2602255051
        )

    [quantities] => Array
        (
            [2602255051] => 20
        )

    [weights] => Array
        (
            [2602255051] => 200
            [2602237297] => 
            [2602239731] => 
            [2602239322] => 
            [2602256655] => 
            [2602234738] => 
            [2602235107] => 
            [2602235508] => 
            [2602239279] => 
        )

    [prices] => Array
        (
            [2602238462] => 
            [2602231273] => 
        )

)

2026-02-25 11:26:34 - Purchase ID: 22
2026-02-25 11:26:34 - Processing: 2602255051, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-02-25 11:26:34 - Grams calculation: 0 * 200 = 0
2026-02-25 11:26:34 - Inserting new stock: quantity=20, weight=200
2026-02-25 11:26:34 - SUCCESS! SAVED TO DATABASE - Total: 0
2026-03-18 12:24:08 - POST RECEIVED!
2026-03-18 12:24:08 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-03-18
    [purchase_time] => 12:23
    [items] => Array
        (
            [0] => 2603189810
            [1] => 2603188164
        )

    [quantities] => Array
        (
            [2603189810] => 20
            [2603188164] => 40
        )

    [weights] => Array
        (
            [2603189810] => 200
        )

    [prices] => Array
        (
            [2603188164] => 400
        )

)

2026-03-18 12:24:08 - Purchase ID: 23
2026-03-18 12:24:08 - Processing: 2603189810, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-03-18 12:24:08 - Grams calculation: 0 * 200 = 0
2026-03-18 12:24:08 - Inserting new stock: quantity=20, weight=200
2026-03-18 12:24:08 - Processing: 2603188164, Type: numbers, Qty: 40, Wt: 0, Price: 400
2026-03-18 12:24:08 - Numbers calculation: 400 * 40 = 16000
2026-03-18 12:24:08 - Inserting new stock: quantity=40, weight=0
2026-03-18 12:24:08 - SUCCESS! SAVED TO DATABASE - Total: 16000
2026-04-02 14:20:23 - POST RECEIVED!
2026-04-02 14:20:23 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-04-02
    [purchase_time] => 14:19
    [items] => Array
        (
            [0] => 2602238462
        )

    [quantities] => Array
        (
            [2602238462] => 1200
        )

    [prices] => Array
        (
            [2602238462] => 2500
        )

)

2026-04-02 14:20:23 - Purchase ID: 24
2026-04-02 14:20:23 - Processing: 2602238462, Type: numbers, Qty: 1200, Wt: 0, Price: 2500
2026-04-02 14:20:23 - Numbers calculation: 2500 * 1200 = 3000000
2026-04-02 14:20:23 - Inserting new stock: quantity=1200, weight=0
2026-04-02 14:20:23 - SUCCESS! SAVED TO DATABASE - Total: 3000000
2026-04-03 11:25:44 - POST RECEIVED!
2026-04-03 11:25:44 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-04-03
    [purchase_time] => 11:24
    [items] => Array
        (
            [0] => 2604038215
            [1] => 2604030923
        )

    [quantities] => Array
        (
            [2604038215] => 20
            [2604030923] => 20
        )

    [prices] => Array
        (
            [2604038215] => 200
        )

    [weights] => Array
        (
            [2604030923] => 200
        )

)

2026-04-03 11:25:44 - Purchase ID: 25
2026-04-03 11:25:44 - Processing: 2604038215, Type: numbers, Qty: 20, Wt: 0, Price: 200
2026-04-03 11:25:44 - Numbers calculation: 200 * 20 = 4000
2026-04-03 11:25:44 - Inserting new stock: quantity=20, weight=0
2026-04-03 11:25:44 - Processing: 2604030923, Type: grams, Qty: 20, Wt: 200, Price: 0
2026-04-03 11:25:44 - Grams calculation: 0 * 200 = 0
2026-04-03 11:25:44 - Inserting new stock: quantity=20, weight=200
2026-04-03 11:25:44 - SUCCESS! SAVED TO DATABASE - Total: 4000
2026-04-03 11:32:20 - POST RECEIVED!
2026-04-03 11:32:20 - DATA: Array
(
    [supplier] => 001
    [purchase_date] => 2026-04-03
    [purchase_time] => 11:31
    [items] => Array
        (
            [0] => 2604034183
        )

    [quantities] => Array
        (
            [2604034183] => 30
        )

    [weights] => Array
        (
            [2604034183] => 300
        )

)

2026-04-03 11:32:20 - Purchase ID: 26
2026-04-03 11:32:20 - Processing: 2604034183, Type: grams, Qty: 30, Wt: 300, Price: 0
2026-04-03 11:32:20 - Grams calculation: 0 * 300 = 0
2026-04-03 11:32:20 - Inserting new stock: quantity=30, weight=300
2026-04-03 11:32:20 - SUCCESS! SAVED TO DATABASE - Total: 0