INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','1','A1TE-ZGBI-33-T','1','0.500','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZGBI-33-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TE-ZGBI-33-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TE-ZGBI-33-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='A1TE-ZGBI-33-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','2','A1TE-ZGBI-34-T','1','0.480','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZGBI-34-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TE-ZGBI-34-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TE-ZGBI-34-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.480',berat_out_asli='0.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.480',berat_akhir_asli =berat_akhir_asli-'0.480' WHERE kode_barang='A1TE-ZGBI-34-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','3','A1TG-ZGBI-35-T','1','0.300','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TG-ZGBI-35-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TG-ZGBI-35-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TG' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TG' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TG' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TG' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TG-ZGBI-35-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.300',berat_out_asli='0.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.300',berat_akhir_asli =berat_akhir_asli-'0.300' WHERE kode_barang='A1TG-ZGBI-35-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','4','A1TE-ZGBI-36-T','1','0.500','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZGBI-36-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TE-ZGBI-36-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TE-ZGBI-36-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='A1TE-ZGBI-36-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','5','A1TE-ZGBI-37-T','1','0.680','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZGBI-37-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TE-ZGBI-37-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TE-ZGBI-37-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.680',berat_out_asli='0.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.680',berat_akhir_asli =berat_akhir_asli-'0.680' WHERE kode_barang='A1TE-ZGBI-37-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','6','A1TE-ZGBI-38-T','1','0.650','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZGBI-38-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TE-ZGBI-38-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TE-ZGBI-38-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.650',berat_out_asli='0.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.650',berat_akhir_asli =berat_akhir_asli-'0.650' WHERE kode_barang='A1TE-ZGBI-38-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0001','7','A1TD-ZGBI-39-T','1','1.020','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZGBI-39-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TD-ZGBI-39-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-A';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1TD-ZGBI-39-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.020' WHERE kode_barang='A1TD-ZGBI-39-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260730-0001','2026-07-30','2026-07-30','08:01','1.020','input','260730');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0002','1','B1TE-ZGBI-40-T','1','0.500','TOKO','PTBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1TE-ZGBI-40-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1TE-ZGBI-40-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='B1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-B';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1TE-ZGBI-40-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.500',berat_out_asli='0.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.500',berat_akhir_asli =berat_akhir_asli-'0.500' WHERE kode_barang='B1TE-ZGBI-40-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0002','2','B1TE-ZGBI-41-T','1','0.540','TOKO','PTBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1TE-ZGBI-41-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1TE-ZGBI-41-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='B1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-B';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1TE-ZGBI-41-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.540',berat_out_asli='0.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.540',berat_akhir_asli =berat_akhir_asli-'0.540' WHERE kode_barang='B1TE-ZGBI-41-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260730-0002','2026-07-30','2026-07-30','08:01','0.540','input','260730');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0003','1','D1TF-ZGBI-42-T','1','0.720','TOKO','PTBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1TF-ZGBI-42-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1TF-ZGBI-42-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TF' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TF' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='D1TF' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1TF' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-D';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1TF-ZGBI-42-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.720',berat_out_asli='0.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.720',berat_akhir_asli =berat_akhir_asli-'0.720' WHERE kode_barang='D1TF-ZGBI-42-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0003','2','D1TD-ZGBI-43-T','1','0.930','TOKO','PTBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D1TD-ZGBI-43-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D1TD-ZGBI-43-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='D1TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D1TD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-D';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-D';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='D1TD-ZGBI-43-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.930',berat_out_asli='0.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.930',berat_akhir_asli =berat_akhir_asli-'0.930' WHERE kode_barang='D1TD-ZGBI-43-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260730-0003','2026-07-30','2026-07-30','08:01','0.930','input','260730');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','1','E0TA-ZGBI-44-T','1','2.930','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-44-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-44-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-44-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.930',berat_out_asli='2.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.930',berat_akhir_asli =berat_akhir_asli-'2.930' WHERE kode_barang='E0TA-ZGBI-44-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','2','E0TA-ZGBI-45-T','1','2.020','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-45-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-45-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-45-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='E0TA-ZGBI-45-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','3','E0TA-ZGBI-46-T','1','3.010','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-46-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-46-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-46-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.010',berat_out_asli='3.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.010',berat_akhir_asli =berat_akhir_asli-'3.010' WHERE kode_barang='E0TA-ZGBI-46-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','4','E0TA-ZGBI-47-T','1','4.970','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-47-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-47-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-47-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.970',berat_out_asli='4.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.970',berat_akhir_asli =berat_akhir_asli-'4.970' WHERE kode_barang='E0TA-ZGBI-47-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','5','E0TA-ZGBI-48-T','1','2.000','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-48-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-48-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-48-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='E0TA-ZGBI-48-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','6','E0TA-ZGBI-49-T','1','1.970','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-49-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-49-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-49-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='E0TA-ZGBI-49-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','7','E0TA-ZGBI-50-T','1','3.000','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-50-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-50-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-50-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='E0TA-ZGBI-50-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0004','8','E0TA-ZGBI-51-T','1','5.970','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E0TA-ZGBI-51-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E0TA-ZGBI-51-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='E0TA' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E0TA' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-E';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-E';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='E0TA-ZGBI-51-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.970',berat_out_asli='5.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.970',berat_akhir_asli =berat_akhir_asli-'5.970' WHERE kode_barang='E0TA-ZGBI-51-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260730-0004','2026-07-30','2026-07-30','08:02','5.970','input','260730');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0005','1','F1TE-ZGBI-52-T','1','5.030','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F1TE-ZGBI-52-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F1TE-ZGBI-52-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F1TE-ZGBI-52-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.030',berat_out_asli='5.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.030',berat_akhir_asli =berat_akhir_asli-'5.030' WHERE kode_barang='F1TE-ZGBI-52-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0005','2','F3TE-ZGBI-53-T','1','3.950','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZGBI-53-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-ZGBI-53-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3TE-ZGBI-53-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.950',berat_out_asli='3.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.950',berat_akhir_asli =berat_akhir_asli-'3.950' WHERE kode_barang='F3TE-ZGBI-53-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0005','3','F3TE-ZGBI-54-T','1','3.950','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZGBI-54-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-ZGBI-54-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3TE-ZGBI-54-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.950',berat_out_asli='3.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.950',berat_akhir_asli =berat_akhir_asli-'3.950' WHERE kode_barang='F3TE-ZGBI-54-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0005','4','F3TE-ZGBI-55-T','1','2.950','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZGBI-55-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-ZGBI-55-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3TE-ZGBI-55-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='F3TE-ZGBI-55-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0005','5','F3TE-ZGBI-56-T','1','2.870','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZGBI-56-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-ZGBI-56-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3TE-ZGBI-56-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.870',berat_out_asli='2.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.870',berat_akhir_asli =berat_akhir_asli-'2.870' WHERE kode_barang='F3TE-ZGBI-56-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0005','6','F3TE-ZGBI-57-T','1','1.970','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZGBI-57-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-ZGBI-57-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3TE-ZGBI-57-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='F3TE-ZGBI-57-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260730-0005','2026-07-30','2026-07-30','08:02','1.970','input','260730');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0006','1','H1TE-ZGBI-58-T','1','7.130','TOKO','PTBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZGBI-58-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1TE-ZGBI-58-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-H';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1TE-ZGBI-58-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.130',berat_out_asli='7.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.130',berat_akhir_asli =berat_akhir_asli-'7.130' WHERE kode_barang='H1TE-ZGBI-58-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260730-0006','2','H1TE-ZGBI-59-T','1','5.060','TOKO','PTBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZGBI-59-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1TE-ZGBI-59-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-H';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1TE-ZGBI-59-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.060',berat_out_asli='5.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.060',berat_akhir_asli =berat_akhir_asli-'5.060' WHERE kode_barang='H1TE-ZGBI-59-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260730-0006','2026-07-30','2026-07-30','08:02','5.060','input','260730');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300845181','kasir','1',' TED1 Q500 ','TOKO','TBK-D','D1TE-ZGBI-60-T','LT CS TIKY VAR SLEP MJ 17K','OL','2.040','1','100.00','3876000','0','0','15000','3903000','0','514000','0','4417000','TIN','T0081719','D1TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-ZGBI-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='D1TE-ZGBI-60-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300845181','2026-07-30','2.040','2026-07-30','08:45:18','PLG0082816','3903000','3903000','514000','4417000','4417000','kasir','2026-07-30 08:45:18','F22630084518');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300845181','2026-07-30','08:45:18','TIN','4417000','514000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260730-0002','D','2026-07-30','08:45:18','kasir','PENJUALAN','F226300845181','12776696000','4417000','12781113000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260730-0001','1','F3E-ZECX-56-T','1','0.530','0.530','TOKO','SMBK-F','TOKO','BK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZECX-56-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-07-30','TOKO','BK-F','F3E','F3E-ZECX-56-T','100.00','1','0.530','0.530','1','0.530','0.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.530',berat_out_asli=berat_out_asli+'0.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-30' AND kode_barang='F3E-ZECX-56-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260730-0001','2026-07-30','2026-07-30','08:59','0.53','admin','2026-07-30 09:00:16');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300925221','kasir','1',' MDA1 X 5K ','TOKO','SMBK-A','A1D-ZGAD-7-T','AT X MODEL APEL CAT SLEP LG 8K ','OLS DW1RF','0.530','1','100.00','541000','0','0','15000','578000','0','109000','0','687000','DIN','T0081084','A1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGAD-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='A1D-ZGAD-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300925221','2026-07-30','0.530','2026-07-30','09:25:22','PLG0082817','578000','578000','109000','687000','687000','kasir','2026-07-30 09:25:22','F22630092522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300925221','2026-07-30','09:25:22','DIN','687000','109000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260730-0003','D','2026-07-30','09:25:22','kasir','PENJUALAN','F226300925221','12781113000','687000','12781800000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301012301','kasir','1',' MEH1 10K H','TOKO','SMBK-H','H1E-ZFAI-88-T','KL FANCY ANAK CAT VAR SLEP HW 34 8K ','OL','1.860','1','100.00','1934000','0','0','15000','1962000','0','10000','0','1972000','DIN','T0080588','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAI-88-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZFAI-88-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301012301','2026-07-30','1.860','2026-07-30','10:12:30','PLG0082818','1962000','1962000','10000','1972000','1972000','kasir','2026-07-30 10:12:30','F22630101230');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301012301','2026-07-30','10:12:30','DIN','1972000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0004','D','2026-07-30','10:12:30','kasir','PENJUALAN','F226301012301','12781800000','1972000','12783772000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1972000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226301012301' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301012302','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZFBI-116-0','CC X BONEKA ANAK CAT MATA LG 8K ','OL','0.450','1','100.00','468000','0','0','15000','477000','0','5000','0','482000','DIN','00411108','E1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBI-116-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E1E-ZFBI-116-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301012302','2026-07-30','0.450','2026-07-30','10:12:30','PLG0082819','477000','477000','5000','482000','482000','kasir','2026-07-30 10:12:30','F22630101230');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301012302','2026-07-30','10:12:30','DIN','482000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0005','D','2026-07-30','10:12:30','kasir','PENJUALAN','F226301012302','12783772000','482000','12784254000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='482000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226301012302' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301104101','kasir','1',' TEH1 HW 40','TOKO','TBK-H','H1TE-ZGAG-40-T','KL SANTA HW 40 17K ','','2.100','1','100.00','3990000','0','0','15000','4011000','0','0','0','4011000','DIN','T0081263','H1TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZGAG-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1TE-ZGAG-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301104101','2026-07-30','2.100','2026-07-30','11:04:10','PLG0082820','4011000','4011000','0','4011000','0','kasir','2026-07-30 11:04:10','F22630110410');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301104101','2026-07-30','11:04:10','DIN','4011000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260730-0001','2026-07-30','2026-07-30 11:04:10','PENJUALAN : F226301104101','0987654321','BCA','4011000','4011000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260730-0002','D','2026-07-30','11:04:10','BCA','PENJUALAN','F226301104101','4645405888','4011000','4649416888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','FITRIA');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301104101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301104101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301104101';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301137421','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGXB-120-T','KL KOREA UB 46 8K ','OL','0.950','1','100.00','988000','0','0','15000','1002000','0','5000','0','1007000','TIN','T0080948','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-120-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGXB-120-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301137421','2026-07-30','0.950','2026-07-30','11:37:43','PLG0082821','1002000','1002000','5000','1007000','1007000','kasir','2026-07-30 11:37:42','F22630113742');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301137421','2026-07-30','11:37:43','TIN','1007000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0006','D','2026-07-30','11:37:43','kasir','PENJUALAN','F226301137421','12784254000','1007000','12785261000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1007000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226301137421' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301137422','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGAX-40-0','KL KOREA UB 46 8K ','OL','0.960','1','100.00','998000','0','0','15000','1013000','0','5000','0','1018000','TIN','00413116','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGAX-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301137422','2026-07-30','0.960','2026-07-30','11:37:43','PLG0082822','1013000','1013000','5000','1018000','1018000','kasir','2026-07-30 11:37:42','F22630113742');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301137422','2026-07-30','11:37:43','TIN','1018000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0007','D','2026-07-30','11:37:43','kasir','PENJUALAN','F226301137422','12785261000','1018000','12786279000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1018000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226301137422' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301154001','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGXB-118-T','KL SANTA KH 42 8K ','OL','1.530','1','100.00','1591000','0','0','15000','1606000','0','8000','0','1614000','DIN','T0080946','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-118-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGXB-118-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301154001','2026-07-30','1.530','2026-07-30','11:54:01','PLG0082823','1606000','1606000','8000','1614000','1614000','kasir','2026-07-30 11:54:00','F22630115400');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301154001','2026-07-30','11:54:01','DIN','1614000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0008','D','2026-07-30','11:54:01','kasir','PENJUALAN','F226301154001','12786279000','1614000','12787893000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1614000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226301154001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301154002','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZGXB-45-T','LT MODEL SOLITAIRE MATA SLEP LG 8K ','OL','0.530','1','100.00','551000','0','0','15000','559000','0','5000','0','564000','DIN','T0080873','D1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZGXB-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='D1E-ZGXB-45-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301154002','2026-07-30','0.530','2026-07-30','11:54:01','PLG0082824','559000','559000','5000','564000','564000','kasir','2026-07-30 11:54:00','F22630115400');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301154002','2026-07-30','11:54:01','DIN','564000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0009','D','2026-07-30','11:54:01','kasir','PENJUALAN','F226301154002','12787893000','564000','12788457000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='564000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226301154002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301154421','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGXB-116-T','KL SANTA KH 42 8K ','OL','1.530','1','100.00','1591000','0','0','15000','1606000','0','8000','0','1614000','DIN','T0080944','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-116-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGXB-116-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301154421','2026-07-30','1.530','2026-07-30','11:54:43','PLG0082825','1606000','1606000','8000','1614000','1614000','kasir','2026-07-30 11:54:42','F22630115442');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301154421','2026-07-30','11:54:43','DIN','1614000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260730-0010','D','2026-07-30','11:54:43','kasir','PENJUALAN','F226301154421','12788457000','1614000','12790071000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301209551','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZCCA-50-T','LT SLOBOK BALOK HURUF BG N 8K ','OLS 3YX4V','0.630','1','100.00','668000','0','0','15000','712000','0','130000','0','842000','DIN','T0078346','D1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZCCA-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='D1F-ZCCA-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301209551','2026-07-30','0.630','2026-07-30','12:09:56','PLG0082826','712000','712000','130000','842000','842000','kasir','2026-07-30 12:09:55','F22630120955');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301209551','2026-07-30','12:09:56','DIN','842000','130000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260730-0011','D','2026-07-30','12:09:56','kasir','PENJUALAN','F226301209551','12790071000','842000','12790913000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226301237341','kasir','1',' MEE2 X HT ','TOKO','SMBK-E','E2E-ZGBA-233-0','CC X PIPA MATA HT 16 8K ','','0.500','1','100.00','520000','0','0','15000','523000','0','0','0','523000','LUS','00414715','E2E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBA-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E2E-ZGBA-233-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226301237341','2026-07-30','0.500','2026-07-30','12:37:35','PLG0082827','523000','523000','0','523000','523000','kasir','2026-07-30 12:37:34','F22630123734');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226301237341','2026-07-30','12:37:35','LUS','523000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260730-0012','D','2026-07-30','12:37:35','kasir','PENJUALAN','F226301237341','12790913000','523000','12791436000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300107511','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-400-0','CC X SOLITAIRE MATA CM 20 8K ','OL','1.110','1','100.00','1132000','0','0','15000','1139000','0','10000','0','1149000','TIN','00405618','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-400-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E2D-ZEBH-400-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300107511','2026-07-30','1.110','2026-07-30','13:07:52','PLG0082828','1139000','1139000','10000','1149000','0','kasir','2026-07-30 13:07:51','F22630010751');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300107511','2026-07-30','13:07:52','TIN','1149000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260730-0002','2026-07-30','2026-07-30 13:07:51','PENJUALAN : F226300107511','7436576756','BCA','1149000','1149000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260730-0003','D','2026-07-30','13:07:52','BCA','PENJUALAN','F226300107511','4649416888','1149000','4650565888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('7436576756','LIDYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1149000' WHERE no_faktur_jual='F226300107511' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300108211','kasir','1',' MDE1D CM 2','TOKO','SMBK-E','E1D-ZFAI-70-T','CC MODEL DAUN SLEP CM 20 8K ','OL','1.130','1','100.00','1153000','0','0','15000','1164000','0','6000','0','1170000','TIN','T0080570','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E1D-ZFAI-70-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300108211','2026-07-30','1.130','2026-07-30','13:08:22','PLG0082829','1164000','1164000','6000','1170000','0','kasir','2026-07-30 13:08:21','F22630010821');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300108211','2026-07-30','13:08:22','TIN','1170000','6000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260730-0003','2026-07-30','2026-07-30 13:08:21','PENJUALAN : F226300108211','76576757679','BCA','1170000','1170000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260730-0004','D','2026-07-30','13:08:22','BCA','PENJUALAN','F226300108211','4650565888','1170000','4651735888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('76576757679','LIDYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1170000' WHERE no_faktur_jual='F226300108211' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300145411','kasir','1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZFAI-6-T','CC MODEL SLEP CM 12 8K ','','0.980','1','100.00','1000000','0','0','15000','1005000','0','0','0','1005000','LUS','T0080506','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E1D-ZFAI-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300145411','2026-07-30','0.980','2026-07-30','13:45:41','PLG0082830','1005000','1005000','0','1005000','1005000','kasir','2026-07-30 13:45:41','F22630014541');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300145411','2026-07-30','13:45:41','LUS','1005000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0013','D','2026-07-30','13:45:41','kasir','PENJUALAN','F226300145411','12791436000','1005000','12792441000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1005000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300145411' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300145412','kasir',' 1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZFBI-215-0','KL X SANTA DAUN VAR UB 8K ','','2.600','1','100.00','2704000','0','0','15000','2717000','0','0','0','2717000','LUS','00411207','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBI-215-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZFBI-215-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300145412','2026-07-30','2.600','2026-07-30','13:45:41','PLG0082831','2717000','2717000','0','2717000','2717000','kasir','2026-07-30 13:45:41','F22630014541');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300145412','2026-07-30','13:45:41','LUS','2717000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0014','D','2026-07-30','13:45:41','kasir','PENJUALAN','F226300145412','12792441000','2717000','12795158000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2717000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300145412' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300219591','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBD-27-T','CC MODEL SPECTRA SLEP KH 18 8K ','OL','0.380','1','100.00','403000','0','0','15000','410000','0','5000','0','415000','DIN','T0081454','E1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBD-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E1F-ZGBD-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300219591','2026-07-30','0.380','2026-07-30','14:20:00','PLG0082832','410000','410000','5000','415000','415000','kasir','2026-07-30 14:19:59','F22630021959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300219591','2026-07-30','14:20:00','DIN','415000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0015','D','2026-07-30','14:20:00','kasir','PENJUALAN','F226300219591','12795158000','415000','12795573000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300219591' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300219592','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E2F-ZGBD-40-T','CC MODEL PAKU MATA SLEP KH 10 8K ','OL','0.400','1','100.00','424000','0','0','15000','432000','0','5000','0','437000','DIN','T0081467','E2F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZGBD-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E2F-ZGBD-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300219592','2026-07-30','0.400','2026-07-30','14:20:00','PLG0082833','432000','432000','5000','437000','437000','kasir','2026-07-30 14:19:59','F22630021959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300219592','2026-07-30','14:20:00','DIN','437000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0016','D','2026-07-30','14:20:00','kasir','PENJUALAN','F226300219592','12795573000','437000','12796010000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300219592' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300219593','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGBD-44-T','CC MODEL PITA SLEP CM 14 8K ','OL','0.750','1','100.00','780000','0','0','15000','795000','0','5000','0','800000','DIN','T0081471','E1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGBD-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='E1E-ZGBD-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300219593','2026-07-30','0.750','2026-07-30','14:20:00','PLG0082834','795000','795000','5000','800000','800000','kasir','2026-07-30 14:19:59','F22630021959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300219593','2026-07-30','14:20:00','DIN','800000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0017','D','2026-07-30','14:20:00','kasir','PENJUALAN','F226300219593','12796010000','800000','12796810000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='800000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300219593' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300219594','kasir',' 1',' MDD1 7K UB','TOKO','SMBK-D','D1D-ZFXB-4-T','LT MODEL BUNGA KARAWANG SLEP UB 8K ','OL','1.270','1','100.00','1295000','0','0','15000','1314000','0','7000','0','1321000','DIN','T0080149','D1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZFXB-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='D1D-ZFXB-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300219594','2026-07-30','1.270','2026-07-30','14:20:00','PLG0082835','1314000','1314000','7000','1321000','1321000','kasir','2026-07-30 14:19:59','F22630021959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300219594','2026-07-30','14:20:00','DIN','1321000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0018','D','2026-07-30','14:20:00','kasir','PENJUALAN','F226300219594','12796810000','1321000','12798131000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1321000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300219594' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300219595','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAA-54-T','LT MODEL BALERINA SLEP BG 8K ','OL','0.400','1','100.00','424000','0','0','15000','432000','0','5000','0','437000','DIN','T0081065','D1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAA-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='D1F-ZGAA-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300219595','2026-07-30','0.400','2026-07-30','14:20:00','PLG0082836','432000','432000','5000','437000','437000','kasir','2026-07-30 14:19:59','F22630021959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300219595','2026-07-30','14:20:00','DIN','437000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0019','D','2026-07-30','14:20:00','kasir','PENJUALAN','F226300219595','12798131000','437000','12798568000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300219595' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300219596','kasir',' 1',' MEF1E UB 6','TOKO','SMBK-F','F1E-ZGBA-46-T','GL OVAL C SLEP UB 60 8K ','OL','2.600','1','100.00','2704000','0','0','15000','2743000','0','13000','0','2756000','DIN','T0081416','F1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGBA-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='F1E-ZGBA-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300219596','2026-07-30','2.600','2026-07-30','14:20:00','PLG0082837','2743000','2743000','13000','2756000','2756000','kasir','2026-07-30 14:19:59','F22630021959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300219596','2026-07-30','14:20:00','DIN','2756000','13000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0020','D','2026-07-30','14:20:00','kasir','PENJUALAN','F226300219596','12798568000','2756000','12801324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2756000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300219596' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300223291','kasir','1',' MEH1 20K U','TOKO','SMBK-H','H1E-ZGBH-2-T','KL TIFF SPECTRA CAT MERAH VAR SLEP UB 50 8K ','OL','2.780','1','100.00','2891000','0','0','15000','2933000','0','14000','0','2947000','DIN','T0081602','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGBH-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300223291','2026-07-30','2.780','2026-07-30','14:23:29','PLG0082838','2933000','2933000','14000','2947000','2947000','kasir','2026-07-30 14:23:29','F22630022329');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300223291','2026-07-30','14:23:29','DIN','2947000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0021','D','2026-07-30','14:23:29','kasir','PENJUALAN','F226300223291','12801324000','2947000','12804271000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2947000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300223291' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300223292','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGBD-156-T','KL RANTAI HOLLOW UB 46 8K ','OL','1.030','1','100.00','1071000','0','0','15000','1087000','0','5000','0','1092000','DIN','T0081583','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBD-156-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGBD-156-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300223292','2026-07-30','1.030','2026-07-30','14:23:29','PLG0082839','1087000','1087000','5000','1092000','1092000','kasir','2026-07-30 14:23:29','F22630022329');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300223292','2026-07-30','14:23:29','DIN','1092000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0022','D','2026-07-30','14:23:29','kasir','PENJUALAN','F226300223292','12804271000','1092000','12805363000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1092000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300223292' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300223293','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGBD-158-T','KL RANTAI HOLLOW UB 46 8K ','OL','1.010','1','100.00','1050000','0','0','15000','1066000','0','5000','0','1071000','DIN','T0081585','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBD-158-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='H1E-ZGBD-158-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300223293','2026-07-30','1.010','2026-07-30','14:23:29','PLG0082840','1066000','1066000','5000','1071000','1071000','kasir','2026-07-30 14:23:29','F22630022329');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300223293','2026-07-30','14:23:29','DIN','1071000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260730-0023','D','2026-07-30','14:23:29','kasir','PENJUALAN','F226300223293','12805363000','1071000','12806434000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1071000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226300223293' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005579','X-00005579','CC X MODEL SOLITAIRE MATA LG 12 8K','GR','---','E2D','BELI','BELI001','990000','2026-07-30','1.050','1','kasir','2026-07-30 14:58:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005579','X-00005579');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260730-0001','F226300216071','NOV','1','BELI','BELI001','E2D', 'X-00005579', 'CC X MODEL SOLITAIRE MATA LG 12 8K','1.050','1.050','100.00','1166000','990000','942857','1020000','1','990000','990000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260730-0001','2026-07-30','2026-07-30','14:58:28','NOV','---','1.050','990000','990000','990000','990000','990000','kasir','2026-07-30 14:58:28','FB-260730-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260730-0001','BELFA','WATES JENANGAN','','','082232148688','kasir','2026-07-30 14:58:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-30' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260730-0024','K','2026-07-30','14:58:28','kasir','PEMBELIAN UMUM','FB-260730-0001','12806434000','990000','12805444000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00005580','X-00005580','LT X MODEL ARESO SLEP UB 8K','GR','---','D1G','BELI','BELI001','355000','2026-07-30','0.360','1','kasir','2026-07-30 14:59:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00005580','X-00005580');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260730-0002','F226241032201','RHM','1','BELI','BELI001','D1G', 'X-00005580', 'LT X MODEL ARESO SLEP UB 8K','0.360','0.360','100.00','421000','355000','986111','1080000','1','355000','355000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.360',berat_beli_asli=berat_beli_asli+'0.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.360',berat_akhir_asli=berat_akhir_asli+'0.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260730-0002','2026-07-30','2026-07-30','14:59:05','RHM','---','0.360','355000','355000','355000','355000','355000','kasir','2026-07-30 14:59:06','FB-260730-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260730-0002','LIYA','JL PILANGSARI 24B PURBOS','','','0895804343299','kasir','2026-07-30 14:59:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-30' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260730-0025','K','2026-07-30','14:59:05','kasir','PEMBELIAN UMUM','FB-260730-0002','12805444000','355000','12805089000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300107511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300107511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300107511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300108211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300108211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300108211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300145411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300145411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300145411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300145412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300145412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300145412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300219591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300219592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300219593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219594' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219594' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300219594';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219595' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219595' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300219595';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219596' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300219596' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300219596';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300223291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300223291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300223291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300223292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300223292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300223292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300223293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300223293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300223293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300845181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300845181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300845181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300925221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300925221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300925221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301012301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301012301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301012301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301012302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301012302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301012302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301137421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301137421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301137421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301137422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301137422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301137422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301154001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301154001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301154001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301154002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301154002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301154002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301154421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301154421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301154421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301209551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301209551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301209551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226301237341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226301237341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226301237341';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260730-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260730-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260730-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260730-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226300343411','kasir','1',' MEF3F HW ','TOKO','SMBK-F','F3E-ZGBD-149-T','GL CASTELI SPECTRA VAR SLEP HW 8K','','2.250','1','100.00','2340000','0','0','15000','2351000','0','0','0','2351000','LUS','T0081576','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-149-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-07-30' AND kode_barang='F3E-ZGBD-149-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226300343411','2026-07-30','2.250','2026-07-30','15:43:42','PLG0082841','2351000','2351000','0','2351000','2351000','kasir','2026-07-30 15:43:41','F22630034341');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-30','F226300343411','2026-07-30','15:43:42','LUS','2351000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260730-0026','D','2026-07-30','15:43:42','kasir','PENJUALAN','F226300343411','12805089000','2351000','12807440000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226300343411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226300343411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226300343411';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-30';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-30' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260731-0001','D','2026-07-31','16:22:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','12807440000','12807440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260731-0001','D','2026-07-31','16:22:56','BCA','SALDO AWAL','SALDO AWAL','0','4651735888','4651735888');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260731-0001','D','2026-07-31','16:22:56','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260731-0001','D','2026-07-31','16:22:56','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260731-0001','D','2026-07-31','16:22:56','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260731-0001','D','2026-07-31','16:22:56','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
UPDATE tp_system SET tgl_system='2026-07-31';