-- 木箱信息查询测试数据，按木箱号判重，可重复执行。
INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000001, 'TEST-BOX-001', 'MAT-CU-001', '双面光锂电铜箔5μm', '3',
       '1200', '1000', '850', '2026-08-05 09:10:00', '4', '1', '0', '68.50'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-001');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000002, 'TEST-BOX-002', 'MAT-CU-001', '双面光锂电铜箔5μm', '2',
       '1200', '1000', '900', '2026-08-05 09:20:00', '4', '1', '1', '72.30'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-002');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000003, 'TEST-BOX-003', 'MAT-CU-002', '双面光锂电铜箔6μm', '4',
       '1300', '1050', '880', '2026-08-05 09:30:00', '6', '1', '0', '75.80'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-003');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000004, 'TEST-BOX-004', 'MAT-CU-002', '双面光锂电铜箔6μm', '1',
       '1300', '1050', '920', '2026-08-05 09:40:00', '6', '2', '1', '80.20'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-004');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000005, 'TEST-BOX-005', 'MAT-CU-003', '高抗拉锂电铜箔4.5μm', '5',
       '1100', '950', '800', '2026-08-05 10:00:00', '4', '2', '0', '65.00'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-005');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000006, 'TEST-BOX-006', 'MAT-CU-003', '高抗拉锂电铜箔4.5μm', '2',
       '1100', '950', '820', '2026-08-05 10:10:00', '4', '2', '1', '66.80'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-006');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000007, 'TEST-BOX-007', 'MAT-CU-004', '标准锂电铜箔8μm', '3',
       '1400', '1100', '950', '2026-08-05 10:20:00', '8', '1', '0', '88.60'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-007');

INSERT INTO wmw_boxinfo
    (box_id, box_no, material_code, material_name, num,
     box_length, box_width, box_high, insert_time, lash_num,
     vehicle_type, is_packing, box_weight)
SELECT 2092000000000000008, 'TEST-BOX-008', 'MAT-CU-004', '标准锂电铜箔8μm', '1',
       '1400', '1100', '980', '2026-08-05 10:30:00', '8', '1', '1', '91.40'
WHERE NOT EXISTS (SELECT 1 FROM wmw_boxinfo WHERE box_no = 'TEST-BOX-008');

