INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0001','1','A1TD-YIXE-2-T','1','1.360','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-YIXE-2-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TD-YIXE-2-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-YIXE-2-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.360',berat_out_asli='1.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.360',berat_akhir_asli =berat_akhir_asli-'1.360' WHERE kode_barang='A1TD-YIXE-2-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0001','2','A1TG-YIXE-1-T','1','0.260','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TG-YIXE-1-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TG-YIXE-1-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-YIXE-1-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.260',berat_out_asli='0.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.260',berat_akhir_asli =berat_akhir_asli-'0.260' WHERE kode_barang='A1TG-YIXE-1-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0001','3','A1TD-YIXE-3-T','1','1.580','TOKO','PTBK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-YIXE-3-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1TD-YIXE-3-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-YIXE-3-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.580',berat_out_asli='1.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.580',berat_akhir_asli =berat_akhir_asli-'1.580' WHERE kode_barang='A1TD-YIXE-3-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-250906-0001','2025-09-06','2025-09-06','07:27','1.580','input','250906');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0002','1','B1TF-YIXE-4-T','1','0.500','TOKO','PTBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1TF-YIXE-4-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1TF-YIXE-4-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='B1TF' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1TF' 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='B1TF-YIXE-4-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='B1TF-YIXE-4-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0002','2','B1TE-YIXE-5-T','1','0.450','TOKO','PTBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1TE-YIXE-5-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1TE-YIXE-5-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-YIXE-5-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.450',berat_out_asli='0.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.450',berat_akhir_asli =berat_akhir_asli-'0.450' WHERE kode_barang='B1TE-YIXE-5-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0002','3','B1TE-YIXE-6-T','1','0.550','TOKO','PTBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1TE-YIXE-6-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1TE-YIXE-6-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-YIXE-6-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.550',berat_out_asli='0.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.550',berat_akhir_asli =berat_akhir_asli-'0.550' WHERE kode_barang='B1TE-YIXE-6-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0002','4','B1TE-YIXE-7-T','1','0.560','TOKO','PTBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1TE-YIXE-7-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1TE-YIXE-7-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-YIXE-7-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.560',berat_out_asli='0.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.560',berat_akhir_asli =berat_akhir_asli-'0.560' WHERE kode_barang='B1TE-YIXE-7-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-250906-0002','2025-09-06','2025-09-06','07:27','0.560','input','250906');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0003','1','D2TD-YIXE-8-T','1','2.300','TOKO','PTBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2TD-YIXE-8-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2TD-YIXE-8-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='D2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2TD' 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='D2TD-YIXE-8-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='D2TD-YIXE-8-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0003','2','D2TD-YIXE-9-T','1','1.260','TOKO','PTBK-D');
DELETE FROM tm_barang_export WHERE kode_barang='D2TD-YIXE-9-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='D2TD-YIXE-9-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='D2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='D2TD' 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='D2TD-YIXE-9-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.260',berat_out_asli='1.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.260',berat_akhir_asli =berat_akhir_asli-'1.260' WHERE kode_barang='D2TD-YIXE-9-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-250906-0003','2025-09-06','2025-09-06','07:27','1.260','input','250906');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','1','E2TD-YIXE-10-T','1','0.920','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-10-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-10-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-10-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.920',berat_out_asli='0.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.920',berat_akhir_asli =berat_akhir_asli-'0.920' WHERE kode_barang='E2TD-YIXE-10-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','2','E2TD-YIXE-11-T','1','1.160','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-11-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-11-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-11-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.160',berat_out_asli='1.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.160',berat_akhir_asli =berat_akhir_asli-'1.160' WHERE kode_barang='E2TD-YIXE-11-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','3','E2TD-YIXE-12-T','1','1.210','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-12-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-12-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-12-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.210',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.210',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='E2TD-YIXE-12-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','4','E2TD-YIXE-13-T','1','1.250','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-13-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-13-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-13-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.250',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.250',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='E2TD-YIXE-13-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','5','E2TD-YIXE-14-T','1','1.470','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-14-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-14-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-14-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.470',berat_out_asli='1.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.470',berat_akhir_asli =berat_akhir_asli-'1.470' WHERE kode_barang='E2TD-YIXE-14-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','6','E2TD-YIXE-15-T','1','1.330','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-15-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-15-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-15-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.330',berat_out_asli='1.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.330',berat_akhir_asli =berat_akhir_asli-'1.330' WHERE kode_barang='E2TD-YIXE-15-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0004','7','E2TD-YIXE-16-T','1','1.000','TOKO','PTBK-E');
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-YIXE-16-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='E2TD-YIXE-16-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='E2TD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='E2TD' 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='E2TD-YIXE-16-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='E2TD-YIXE-16-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-250906-0004','2025-09-06','2025-09-06','07:28','1.000','input','250906');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0005','1','F3TE-YIXE-17-T','1','4.930','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-YIXE-17-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-YIXE-17-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-YIXE-17-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.930',berat_out_asli='4.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.930',berat_akhir_asli =berat_akhir_asli-'4.930' WHERE kode_barang='F3TE-YIXE-17-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0005','2','F3TE-YIXE-18-T','1','4.180','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-YIXE-18-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-YIXE-18-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-YIXE-18-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.180',berat_out_asli='4.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.180',berat_akhir_asli =berat_akhir_asli-'4.180' WHERE kode_barang='F3TE-YIXE-18-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0005','3','F1TE-YIXE-19-T','1','4.200','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F1TE-YIXE-19-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F1TE-YIXE-19-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-YIXE-19-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.200',berat_out_asli='4.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.200',berat_akhir_asli =berat_akhir_asli-'4.200' WHERE kode_barang='F1TE-YIXE-19-T' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0005','4','F2TE-YIXE-20-T','1','8.030','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F2TE-YIXE-20-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F2TE-YIXE-20-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='F2TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F2TE' 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='F2TE-YIXE-20-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.030',berat_out_asli='8.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.030',berat_akhir_asli =berat_akhir_asli-'8.030' WHERE kode_barang='F2TE-YIXE-20-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-250906-0005','2025-09-06','2025-09-06','07:28','8.030','input','250906');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250906-0006','1','H1TF-YIXE-21-T','1','0.940','TOKO','PTBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1TF-YIXE-21-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1TF-YIXE-21-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='H1TF' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1TF' 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='H1TF-YIXE-21-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.940',berat_out_asli='0.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.940',berat_akhir_asli =berat_akhir_asli-'0.940' WHERE kode_barang='H1TF-YIXE-21-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-250906-0006','2025-09-06','2025-09-06','07:28','0.940','input','250906');
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 ('F225060831041','kasir','1',' MFB1 UB ','TOKO','SMBK-B','B1F-YIXD-10-T','GW TRIXIE PANJANG PITA MATA VAR UB 8K ','OL','0.690','1','100.00','620000','0','0','15000','631000','0','5000','0','636000','RHM','T0072862','B1F','0','0','-','0','899000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YIXD-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='B1F-YIXD-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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 ('F225060831041','2025-09-06','0.690','2025-09-06','08:31:05','PLG0072318','631000','631000','5000','636000','636000','kasir','2025-09-06 08:31:04','F22506083104');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225060831041','2025-09-06','08:31:05','RHM','636000','5000');
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-250906-0002','D','2025-09-06','08:31:05','kasir','PENJUALAN','F225060831041','696824000','636000','697460000');
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 ('F225060958571','kasir','1',' MEE1 HW 13','TOKO','SMBK-E','E1E-YHBA-47-T','CC MODEL SLEP VAR HW 13 8K ','OL','0.600','1','100.00','529000','0','0','15000','535000','0','5000','0','540000','RTA','T0072477','E1E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBA-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E1E-YHBA-47-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 ('F225060958571','2025-09-06','0.600','2025-09-06','09:58:57','PLG0072319','535000','535000','5000','540000','0','kasir','2025-09-06 09:58:57','F22506095857');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225060958571','2025-09-06','09:58:57','RTA','540000','5000');
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-250906-0001','2025-09-06','2025-09-06 09:58:57','PENJUALAN : F225060958571','89878778766767','BCA','540000','540000','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-250906-0002','D','2025-09-06','09:58:57','BCA','PENJUALAN','F225060958571','3953102888','540000','3953642888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('89878778766767','WULAN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='540000' WHERE no_faktur_jual='F225060958571' 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 ('F225060959311','kasir','1',' MGPB CM PE','TOKO','SMBK-P','PBG-YGCX-41-T','GW WG TUSUK DEASY MATA CM PE 8K ','OL','0.480','1','100.00','440000','0','0','15000','448000','0','5000','0','453000','RTA','T0071706','PBG','0','0','-','0','916000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBG-YGCX-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='PBG-YGCX-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' 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 ('F225060959311','2025-09-06','0.480','2025-09-06','09:59:32','PLG0072320','448000','448000','5000','453000','0','kasir','2025-09-06 09:59:31','F22506095931');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225060959311','2025-09-06','09:59:32','RTA','453000','5000');
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-250906-0002','2025-09-06','2025-09-06 09:59:31','PENJUALAN : F225060959311','908987877876','BCA','453000','453000','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-250906-0003','D','2025-09-06','09:59:32','BCA','PENJUALAN','F225060959311','3953642888','453000','3954095888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('908987877876','ENES');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='453000' WHERE no_faktur_jual='F225060959311' 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 ('F225061018051','kasir','1',' MHA1H DG ','TOKO','SMBK-A','A1H-YCBF-202-0','AT BABY TINDIK DG 8K ','','0.250','1','100.00','233000','0','0','15000','235000','0','0','0','235000','RHM','00345925','A1H','0','0','-','0','933000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YCBF-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='A1H-YCBF-202-0' 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 ('F225061018051','2025-09-06','0.250','2025-09-06','10:18:06','PLG0072321','235000','235000','0','235000','235000','kasir','2025-09-06 10:18:05','F22506101805');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061018051','2025-09-06','10:18:06','RHM','235000','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-250906-0003','D','2025-09-06','10:18:06','kasir','PENJUALAN','F225061018051','697460000','235000','697695000');
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 ('F225061053391','kasir','1',' MDE2 CM 14','TOKO','SMBK-E','E2D-YIXB-38-T','CC WEDDING MATA CM 14 8K ','OL','1.090','1','100.00','943000','0','0','15000','976000','0','5000','0','981000','RTA','T0072782','E2D','0','0','-','0','865000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E2D-YIXB-38-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 ('F225061053391','2025-09-06','1.090','2025-09-06','10:53:40','PLG0072322','976000','976000','5000','981000','981000','kasir','2025-09-06 10:53:39','F22506105339');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061053391','2025-09-06','10:53:40','RTA','981000','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-250906-0004','D','2025-09-06','10:53:40','kasir','PENJUALAN','F225061053391','697695000','981000','698676000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='981000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061053391' 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 ('F225061053392','kasir',' 1',' MDE2 CM 12','TOKO','SMBK-E','E2D-YIXB-37-T','CC WEDDING MATA CM 12 8K ','OL','1.060','1','100.00','917000','0','0','15000','949000','0','5000','0','954000','RTA','T0072781','E2D','0','0','-','0','865000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E2D-YIXB-37-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 ('F225061053392','2025-09-06','1.060','2025-09-06','10:53:40','PLG0072323','949000','949000','5000','954000','954000','kasir','2025-09-06 10:53:39','F22506105339');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061053392','2025-09-06','10:53:40','RTA','954000','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-250906-0005','D','2025-09-06','10:53:40','kasir','PENJUALAN','F225061053392','698676000','954000','699630000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='954000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061053392' 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 ('F225061053393','kasir',' 1',' MDE2 CM 16','TOKO','SMBK-E','E2D-YIXB-41-T','CC WEDDING MATA CM 16 8K ','OL','1.100','1','100.00','952000','0','0','15000','984000','0','6000','0','990000','RTA','T0072785','E2D','0','0','-','0','865000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E2D-YIXB-41-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 ('F225061053393','2025-09-06','1.100','2025-09-06','10:53:40','PLG0072324','984000','984000','6000','990000','990000','kasir','2025-09-06 10:53:39','F22506105339');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061053393','2025-09-06','10:53:40','RTA','990000','6000');
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-250906-0006','D','2025-09-06','10:53:40','kasir','PENJUALAN','F225061053393','699630000','990000','700620000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061053393' 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 ('F225061053394','kasir',' 1',' MDE2 CM 18','TOKO','SMBK-E','E2D-YIXB-42-T','CC WEDDING MATA CM 18 8K ','OL','1.120','1','100.00','969000','0','0','15000','1002000','0','6000','0','1008000','RTA','T0072786','E2D','0','0','-','0','865000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E2D-YIXB-42-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 ('F225061053394','2025-09-06','1.120','2025-09-06','10:53:40','PLG0072325','1002000','1002000','6000','1008000','1008000','kasir','2025-09-06 10:53:39','F22506105339');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061053394','2025-09-06','10:53:40','RTA','1008000','6000');
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-250906-0007','D','2025-09-06','10:53:40','kasir','PENJUALAN','F225061053394','700620000','1008000','701628000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1008000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061053394' 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 ('F225061125441','kasir','1',' TFH2 X 15K','TOKO','TBK-H','H2TF-YIXD-117-T','KL X TRIXIE BUNGA CLOVER MATA VAR UB 17K ','OL','2.170','1','100.00','3422000','0','0','15000','3472000','0','15000','0','3487000','RTA','T0072969','H2TF','0','0','-','0','1577000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TF-YIXD-117-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='H2TF-YIXD-117-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 ('F225061125441','2025-09-06','2.170','2025-09-06','11:25:45','PLG0072326','3472000','3472000','15000','3487000','3487000','kasir','2025-09-06 11:25:44','F22506112544');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061125441','2025-09-06','11:25:45','RTA','3487000','15000');
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-250906-0008','D','2025-09-06','11:25:45','kasir','PENJUALAN','F225061125441','701628000','3487000','705115000');
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 ('F225061126231','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-YHBB-27-0','LT X SLOBOK BALOK HURUF BG N 8K ','OL','0.520','1','100.00','468000','0','0','15000','480000','0','5000','0','485000','RTA','00366640','D1F','0','0','-','0','899000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YHBB-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='D1F-YHBB-27-0' 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 ('F225061126231','2025-09-06','0.520','2025-09-06','11:26:24','PLG0072327','480000','480000','5000','485000','485000','kasir','2025-09-06 11:26:23','F22506112623');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061126231','2025-09-06','11:26:24','RTA','485000','5000');
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-250906-0009','D','2025-09-06','11:26:24','kasir','PENJUALAN','F225061126231','705115000','485000','705600000');
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 ('F225061138061','kasir','1',' MFF3 KH ','TOKO','SMBK-F','F3F-YFAB-27-T','GL PITON JEDAR 2C VAR KH 8K ','','1.670','1','100.00','1501000','0','0','15000','1515000','0','0','0','1515000','RHM','T0069966','F3F','0','0','-','0','899000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YFAB-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F3F-YFAB-27-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 ('F225061138061','2025-09-06','1.670','2025-09-06','11:38:07','PLG0072328','1515000','1515000','0','1515000','1515000','kasir','2025-09-06 11:38:06','F22506113806');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061138061','2025-09-06','11:38:07','RHM','1515000','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-250906-0010','D','2025-09-06','11:38:07','kasir','PENJUALAN','F225061138061','705600000','1515000','707115000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1515000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061138061' 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 ('F225061138062','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-YIXD-5-T','GL TRIXIE SERUT MODEL DAUN VAR UB 8K ','','1.410','1','100.00','1244000','0','0','15000','1255000','0','0','0','1255000','RHM','T0072857','F3E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIXD-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F3E-YIXD-5-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 ('F225061138062','2025-09-06','1.410','2025-09-06','11:38:07','PLG0072329','1255000','1255000','0','1255000','1255000','kasir','2025-09-06 11:38:06','F22506113806');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061138062','2025-09-06','11:38:07','RHM','1255000','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-250906-0011','D','2025-09-06','11:38:07','kasir','PENJUALAN','F225061138062','707115000','1255000','708370000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1255000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061138062' 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 ('F225061140271','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-WJXI-101-0','CHARM X SLOBOK BALOK HURUF BG O ','OL','0.630','1','100.00','566000','0','0','15000','578000','0','5000','0','583000','TJ','00258309','D1F','0','0','-','0','899000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-WJXI-101-0' 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='2025-09-06' AND kode_barang='D1F-WJXI-101-0' 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 ('F225061140271','2025-09-06','0.630','2025-09-06','11:40:28','PLG0072330','578000','578000','5000','583000','583000','kasir','2025-09-06 11:40:27','F22506114027');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061140271','2025-09-06','11:40:28','TJ','583000','5000');
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-250906-0012','D','2025-09-06','11:40:28','kasir','PENJUALAN','F225061140271','708370000','583000','708953000');
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 ('F225061153451','kasir','1',' MEF1 TD D5','TOKO','SMBK-F','F1E-YHBH-192-T','GL OVAL MODEL C TD D56 8K ','','3.180','1','100.00','2805000','0','0','15000','2830000','0','0','0','2830000','RHM','T0072688','F1E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHBH-192-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F1E-YHBH-192-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 ('F225061153451','2025-09-06','3.180','2025-09-06','11:53:45','PLG0072331','2830000','2830000','0','2830000','0','kasir','2025-09-06 11:53:45','F22506115345');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061153451','2025-09-06','11:53:45','RHM','2830000','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-250906-0003','2025-09-06','2025-09-06 11:53:45','PENJUALAN : F225061153451','436544444444','BCA','2830000','2830000','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-250906-0004','D','2025-09-06','11:53:45','BCA','PENJUALAN','F225061153451','3954095888','2830000','3956925888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('436544444444','FREDDDDD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2830000' WHERE no_faktur_jual='F225061153451' 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 ('F225061205321','kasir','1',' TEF3 X HW ','TOKO','TBK-F','F3TE-YIXD-86-T','GL X HARLEY HW 17K ','','3.000','1','100.00','4680000','0','0','15000','4710000','0','0','0','4710000','RTA','T0072938','F3TE','0','0','-','0','1560000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YIXD-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F3TE-YIXD-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225061205321','2025-09-06','3.000','2025-09-06','12:05:32','PLG0072332','4710000','4710000','0','4710000','4710000','kasir','2025-09-06 12:05:32','F22506120532');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061205321','2025-09-06','12:05:32','RTA','4710000','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-250906-0013','D','2025-09-06','12:05:32','kasir','PENJUALAN','F225061205321','708953000','4710000','713663000');
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 ('F225061217011','kasir','1',' MEE1 AY 11','TOKO','SMBK-E','E1E-YHXG-17-T','CC MODEL PITA VAR AY 11 8K ','','0.600','1','100.00','529000','0','0','15000','534000','0','0','0','534000','TJ','T0072004','E1E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXG-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E1E-YHXG-17-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 ('F225061217011','2025-09-06','0.600','2025-09-06','12:17:01','PLG0072333','534000','534000','0','534000','534000','kasir','2025-09-06 12:17:01','F22506121701');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061217011','2025-09-06','12:17:01','TJ','534000','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-250906-0014','D','2025-09-06','12:17:01','kasir','PENJUALAN','F225061217011','713663000','534000','714197000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='534000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061217011' 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 ('F225061217012','kasir',' 1',' MEF3 10K L','TOKO','SMBK-F','F3E-YGBB-107-T','GL RANTAI HOLLOW P4 SLEP VAR LT 8K ','','1.970','1','100.00','1738000','0','0','15000','1753000','0','10000','0','1763000','TJ','T0071379','F3E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGBB-107-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F3E-YGBB-107-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 ('F225061217012','2025-09-06','1.970','2025-09-06','12:17:01','PLG0072334','1753000','1753000','10000','1763000','1763000','kasir','2025-09-06 12:17:01','F22506121701');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061217012','2025-09-06','12:17:01','TJ','1763000','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-250906-0015','D','2025-09-06','12:17:01','kasir','PENJUALAN','F225061217012','714197000','1763000','715960000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1763000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225061217012' 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 ('F225061247251','kasir','1',' TGH2 X UB ','TOKO','TBK-H','H2TG-YIXD-115-T','KL X SANTA MODEL MATA VAR UB 17K ','OL','5.830','1','100.00','9293000','0','0','15000','9400000','0','40000','0','9440000','RTA','T0072967','H2TG','0','0','-','0','1594000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TG-YIXD-115-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.830',berat_jual_asli=berat_jual_asli+'5.830',stock_jual='1',berat_akhir=berat_akhir-'5.830',berat_akhir_asli=berat_akhir_asli-'5.830',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='H2TG-YIXD-115-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 ('F225061247251','2025-09-06','5.830','2025-09-06','12:47:25','PLG0072335','9400000','9400000','40000','9440000','0','kasir','2025-09-06 12:47:25','F22506124725');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225061247251','2025-09-06','12:47:25','RTA','9440000','40000');
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-250906-0004','2025-09-06','2025-09-06 12:47:25','PENJUALAN : F225061247251','8987877887787878','BCA','9440000','9440000','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-250906-0005','D','2025-09-06','12:47:25','BCA','PENJUALAN','F225061247251','3956925888','9440000','3966365888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8987877887787878','FERDHA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='9440000' WHERE no_faktur_jual='F225061247251' 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 ('F225060117211','kasir','1',' MEE2 UB 18','TOKO','SMBK-E','E2E-YHXE-93-T','CC MODEL MATA VAR UB 18 8K ','OL','0.660','1','100.00','582000','0','0','15000','595000','0','5000','0','600000','RTA','T0071882','E2E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXE-93-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='E2E-YHXE-93-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 ('F225060117211','2025-09-06','0.660','2025-09-06','13:17:22','PLG0072336','595000','595000','5000','600000','600000','kasir','2025-09-06 13:17:21','F22506011721');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225060117211','2025-09-06','13:17:22','RTA','600000','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-250906-0016','D','2025-09-06','13:17:22','kasir','PENJUALAN','F225060117211','715960000','600000','716560000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225060117211' 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 ('F225060117212','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YHAB-53-T','GL MODEL FANCY VAR HW 8K ','OL','1.780','1','100.00','1570000','0','0','15000','1593000','0','9000','0','1602000','RTA','T0072260','F3E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHAB-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F3E-YHAB-53-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 ('F225060117212','2025-09-06','1.780','2025-09-06','13:17:22','PLG0072337','1593000','1593000','9000','1602000','1602000','kasir','2025-09-06 13:17:21','F22506011721');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225060117212','2025-09-06','13:17:22','RTA','1602000','9000');
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-250906-0017','D','2025-09-06','13:17:22','kasir','PENJUALAN','F225060117212','716560000','1602000','718162000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225060117212' 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 ('F225060131081','kasir','1',' MFF3 UB ','TOKO','SMBK-F','F3F-YHCX-12-T','GL KAKI RANTAI HOLLOW UB 8K ','','0.510','1','100.00','459000','0','0','15000','463000','0','0','0','463000','RTA','T0072723','F3F','0','0','-','0','899000');
UPDATE tm_barang SET tgl_last_jual='2025-09-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHCX-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-06' AND kode_barang='F3F-YHCX-12-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 ('F225060131081','2025-09-06','0.510','2025-09-06','13:31:08','PLG0072338','463000','463000','0','463000','0','kasir','2025-09-06 13:31:08','F22506013108');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-06','F225060131081','2025-09-06','13:31:08','RTA','463000','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-250906-0005','2025-09-06','2025-09-06 13:31:08','PENJUALAN : F225060131081','898787878787','BCA','463000','463000','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-250906-0006','D','2025-09-06','13:31:08','BCA','PENJUALAN','F225060131081','3966365888','463000','3966828888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('898787878787','PRIHATIN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060131081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060131081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060131081';
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-00004598','X-00004598','GL FANCY MODEL KUPU SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1390000','2025-09-06','1.860','1','kasir','2025-09-06 14:54:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004598','X-00004598');
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-250906-0001','F225140338513','TJ','1','BELI','BELI001','F3E', 'X-00004598', 'GL FANCY MODEL KUPU SLEP VAR HW 8K','1.860','1.860','100.00','1544000','1390000','747312','882000','1','1390000','1390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.860',berat_beli_asli=berat_beli_asli+'1.860',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.860',berat_akhir_asli=berat_akhir_asli+'1.860',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-250906-0001','2025-09-06','2025-09-06','14:54:56','TJ','---','1.860','1390000','1390000','1390000','1390000','1390000','kasir','2025-09-06 14:54:56','FB-250906-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250906-0001','AN NUR','NGRUKEM MLARAK','','','082331776423','kasir','2025-09-06 14:54:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-06' 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-250906-0018','K','2025-09-06','14:54:56','kasir','PEMBELIAN UMUM','FB-250906-0001','718162000','1390000','716772000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060117211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060117211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060117211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060117212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060117212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060117212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060831041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060831041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060831041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060958571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060958571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060958571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225060959311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225060959311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225060959311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061018051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061018051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061018051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061053391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061053392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053393' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053393' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061053393';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053394' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061053394' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061053394';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061125441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061125441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061125441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061126231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061126231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061126231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061138061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061138061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061138061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061138062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061138062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061138062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061140271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061140271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061140271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061153451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061153451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061153451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061205321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061205321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061205321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061217011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061217011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061217011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061217012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061217012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061217012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225061247251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225061247251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225061247251';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250906-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250906-0001';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-06';
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='2025-09-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-06' 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-250907-0001','D','2025-09-07','16:02:29','SYSTEM','SALDO AWAL','SALDO AWAL','0','716772000','716772000');
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-250907-0001','D','2025-09-07','16:02:29','BCA','SALDO AWAL','SALDO AWAL','0','3966828888','3966828888');
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-250907-0001','D','2025-09-07','16:02:29','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-250907-0001','D','2025-09-07','16:02:29','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-250907-0001','D','2025-09-07','16:02:29','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-250907-0001','D','2025-09-07','16:02:29','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-09-07';
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250907-0001','1','H1F-YIXD-16-T','TOKO','SMBK-H','KL KOREA KH 44CM 8K ','1','2.080','PS BKL');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-06 23:46:10',status_delete='2.080' WHERE kode_barang='H1F-YIXD-16-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H1F-YIXD-16-T';
DELETE FROM tm_barang WHERE kode_barang='H1F-YIXD-16-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.080,berat_hancur_asli=berat_hancur_asli+2.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='SMBK-H' AND kode_barang='H1F-YIXD-16-T' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250907-0001','2','H1E-YCBX-150-0','TOKO','SMBK-H','KL ANAK NORY UB 36CM 8K ','1','0.900','PS BKL');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-06 23:46:10',status_delete='0.900' WHERE kode_barang='H1E-YCBX-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H1E-YCBX-150-0';
DELETE FROM tm_barang WHERE kode_barang='H1E-YCBX-150-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='SMBK-H' AND kode_barang='H1E-YCBX-150-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-250907-0001','2025-09-07','irgosa','2025-09-07','23:46:10','irgosa','2025-09-06 23:46:10');