INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','E1D-ZABC-80-0','1','1.520','1.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZABC-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZABC-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-24 08:07:51' WHERE kode_barang='E1D-ZABC-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZABC-80-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:07:51','TOKO','PM-E','E1D','E1D-ZABC-80-0','1','1.520','1.520','1','1.520','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZABC-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZABC-80-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:07','1.520','admpindah','2026-03-24 08:07:51');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','F3E-ZCAI-268-0','1','1.050','1.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCAI-268-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCAI-268-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-24 08:08:11' WHERE kode_barang='F3E-ZCAI-268-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCAI-268-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:08:11','TOKO','PM-F','F3E','F3E-ZCAI-268-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZCAI-268-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCAI-268-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:07','1.050','admpindah','2026-03-24 08:08:10');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','A1TE-ZCBC-43-T','1','0.570','0.570','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZCBC-43-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZCBC-43-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-03-24 08:08:34' WHERE kode_barang='A1TE-ZCBC-43-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZCBC-43-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:08:34','TOKO','PT-A','A1TE','A1TE-ZCBC-43-T','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZCBC-43-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZCBC-43-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:08','0.570','admpindah','2026-03-24 08:08:33');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','D1TE-ZCBC-44-T','1','0.570','0.570','TOKO','PTBK-D','TOKO','PT-D');
DELETE FROM tm_barang WHERE kode_barang='D1TE-ZCBC-44-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1TE-ZCBC-44-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-D',tgl_last_beli='2026-03-24 08:08:50' WHERE kode_barang='D1TE-ZCBC-44-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1TE-ZCBC-44-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:08:50','TOKO','PT-D','D1TE','D1TE-ZCBC-44-T','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1TE-ZCBC-44-T';
DELETE FROM tm_barang_export WHERE kode_barang='D1TE-ZCBC-44-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:08','0.570','admpindah','2026-03-24 08:08:49');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','E1TD-ZCBC-46-T','1','1.030','1.030','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZCBC-46-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZCBC-46-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-03-24 08:09:09' WHERE kode_barang='E1TD-ZCBC-46-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZCBC-46-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:09:09','TOKO','PT-E','E1TD','E1TD-ZCBC-46-T','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZCBC-46-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZCBC-46-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','E1TD-ZCBC-45-T','1','1.970','1.970','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZCBC-45-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZCBC-45-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-03-24 08:09:09' WHERE kode_barang='E1TD-ZCBC-45-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZCBC-45-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:09:09','TOKO','PT-E','E1TD','E1TD-ZCBC-45-T','1','1.970','1.970','1','1.970','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZCBC-45-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZCBC-45-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:09','3.000','admpindah','2026-03-24 08:09:08');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','F1TE-ZCBC-49-T','1','6.110','6.110','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F1TE-ZCBC-49-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1TE-ZCBC-49-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-03-24 08:09:31' WHERE kode_barang='F1TE-ZCBC-49-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1TE-ZCBC-49-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:09:31','TOKO','PT-F','F1TE','F1TE-ZCBC-49-T','1','6.110','6.110','1','6.110','6.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1TE-ZCBC-49-T';
DELETE FROM tm_barang_export WHERE kode_barang='F1TE-ZCBC-49-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','F3TE-ZCBC-48-T','1','2.580','2.580','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-ZCBC-48-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-ZCBC-48-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-03-24 08:09:31' WHERE kode_barang='F3TE-ZCBC-48-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-ZCBC-48-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:09:31','TOKO','PT-F','F3TE','F3TE-ZCBC-48-T','1','2.580','2.580','1','2.580','2.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-ZCBC-48-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZCBC-48-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','F1TE-ZCBC-50-T','1','10.110','10.110','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F1TE-ZCBC-50-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1TE-ZCBC-50-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-03-24 08:09:31' WHERE kode_barang='F1TE-ZCBC-50-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1TE-ZCBC-50-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:09:31','TOKO','PT-F','F1TE','F1TE-ZCBC-50-T','1','10.110','10.110','1','10.110','10.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1TE-ZCBC-50-T';
DELETE FROM tm_barang_export WHERE kode_barang='F1TE-ZCBC-50-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:09','18.800','admpindah','2026-03-24 08:09:31');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','H1TE-ZCBC-47-T','1','10.010','10.010','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZCBC-47-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZCBC-47-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-03-24 08:09:52' WHERE kode_barang='H1TE-ZCBC-47-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZCBC-47-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:09:52','TOKO','PT-H','H1TE','H1TE-ZCBC-47-T','1','10.010','10.010','1','10.010','10.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZCBC-47-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZCBC-47-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:09','10.010','admpindah','2026-03-24 08:09:52');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','PHTI-ZCBC-40-T','1','2.130','2.130','TOKO','PTBK-P','TOKO','PT-P');
DELETE FROM tm_barang WHERE kode_barang='PHTI-ZCBC-40-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PHTI-ZCBC-40-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-P',tgl_last_beli='2026-03-24 08:10:12' WHERE kode_barang='PHTI-ZCBC-40-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PHTI-ZCBC-40-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:10:12','TOKO','PT-P','PHTI','PHTI-ZCBC-40-T','1','2.130','2.130','1','2.130','2.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='PHTI' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PHTI' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PHTI-ZCBC-40-T';
DELETE FROM tm_barang_export WHERE kode_barang='PHTI-ZCBC-40-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','PDTG-ZCBC-42-T','1','1.040','1.040','TOKO','PTBK-P','TOKO','PT-P');
DELETE FROM tm_barang WHERE kode_barang='PDTG-ZCBC-42-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PDTG-ZCBC-42-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-P',tgl_last_beli='2026-03-24 08:10:12' WHERE kode_barang='PDTG-ZCBC-42-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PDTG-ZCBC-42-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:10:12','TOKO','PT-P','PDTG','PDTG-ZCBC-42-T','1','1.040','1.040','1','1.040','1.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='PDTG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PDTG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PDTG-ZCBC-42-T';
DELETE FROM tm_barang_export WHERE kode_barang='PDTG-ZCBC-42-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260324-0001','1','PFTI-ZCBC-41-T','1','3.000','3.000','TOKO','PTBK-P','TOKO','PT-P');
DELETE FROM tm_barang WHERE kode_barang='PFTI-ZCBC-41-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PFTI-ZCBC-41-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-P',tgl_last_beli='2026-03-24 08:10:12' WHERE kode_barang='PFTI-ZCBC-41-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PFTI-ZCBC-41-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-24 08:10:12','TOKO','PT-P','PFTI','PFTI-ZCBC-41-T','1','3.000','3.000','1','3.000','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='PFTI' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PFTI' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PFTI-ZCBC-41-T';
DELETE FROM tm_barang_export WHERE kode_barang='PFTI-ZCBC-41-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260324-0001','2026-03-24','08:10','6.170','admpindah','2026-03-24 08:10:11');
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 ('F326240843041','input','1',' MEF3 LT ','TOKO','PM-F','F3E-ZCAH-359-0','GL ANAK MODEL FLIK VAR LT 8K ','','1.000','1','100.00','1150000','0','0','15000','1150000','0','0','0','1150000','FIT','00395314','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAH-359-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='F3E-ZCAH-359-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240843041','2026-03-24','1.000','2026-03-24','08:43:05','PLG0027998','1150000','1150000','0','1150000','1150000','input','2026-03-24 08:43:04','F32624084304');
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-03-24','F326240843041','2026-03-24','08:43:05','FIT','1150000','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-260324-0002','D','2026-03-24','08:43:05','input','PENJUALAN','F326240843041','3588975000','1150000','3590125000');
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 ('F326240855171','kasir','1',' MEF2 10K C','TOKO','PM-F','F2E-ZCAH-394-0','GL OSROT ANAK BONEKA CAT MATA CM 8K ','','0.960','1','100.00','1104000','0','0','15000','1105000','0','10000','0','1115000','FIT','00395349','F2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZCAH-394-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-03-24' AND kode_barang='F2E-ZCAH-394-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240855171','2026-03-24','0.960','2026-03-24','08:55:17','PLG0027999','1105000','1105000','10000','1115000','1115000','kasir','2026-03-24 08:55:17','F32624085517');
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-03-24','F326240855171','2026-03-24','08:55:17','FIT','1115000','10000');
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-260324-0003','D','2026-03-24','08:55:17','kasir','PENJUALAN','F326240855171','3590125000','1115000','3591240000');
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 ('F326240856111','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZCXG-143-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.930','1','100.00','1051000','0','0','15000','1050000','0','0','0','1050000','LIS','00392579','E2D','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXG-143-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCXG-143-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240856111','2026-03-24','0.930','2026-03-24','08:56:11','PLG0028000','1050000','1050000','0','1050000','1050000','kasir','2026-03-24 08:56:11','F32624085611');
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-03-24','F326240856111','2026-03-24','08:56:11','LIS','1050000','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-260324-0004','D','2026-03-24','08:56:11','kasir','PENJUALAN','F326240856111','3591240000','1050000','3592290000');
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 ('F326240904371','kasir','1',' MEE1 X CP ','TOKO','PM-E','E1E-YLXH-110-0','CC X MODEL DAUN SLEP CP 12 8K ','','0.720','1','100.00','828000','0','0','15000','830000','0','0','0','830000','AAT','00380232','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLXH-110-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1E-YLXH-110-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240904371','2026-03-24','0.720','2026-03-24','09:04:38','PLG0028001','830000','830000','0','830000','830000','kasir','2026-03-24 09:04:37','F32624090437');
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-03-24','F326240904371','2026-03-24','09:04:38','AAT','830000','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-260324-0005','D','2026-03-24','09:04:38','kasir','PENJUALAN','F326240904371','3592290000','830000','3593120000');
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 ('F326240914381','kasir','1',' MDE2 X YT ','TOKO','PM-E','E2D-ZCXB-95-0','CC X MODEL MATA YT 12 8K ','','1.600','1','100.00','1808000','0','0','15000','1810000','0','0','0','1810000','FIT','00391518','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCXB-95-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240914381','2026-03-24','1.600','2026-03-24','09:14:38','PLG0028002','1810000','1810000','0','1810000','1810000','kasir','2026-03-24 09:14:38','F32624091438');
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-03-24','F326240914381','2026-03-24','09:14:38','FIT','1810000','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-260324-0006','D','2026-03-24','09:14:38','kasir','PENJUALAN','F326240914381','3593120000','1810000','3594930000');
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 ('F326240916591','kasir','1',' MED2 CM ','TOKO','PM-D','D2E-ZBAF-307-0','LT MODEL MATA VAR CM 8K ','','0.610','1','100.00','701000','0','0','15000','700000','0','0','0','700000','LIS','00390280','D2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBAF-307-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='D2E-ZBAF-307-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240916591','2026-03-24','0.610','2026-03-24','09:16:59','PLG0028003','700000','700000','0','700000','700000','kasir','2026-03-24 09:16:59','F32624091659');
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-03-24','F326240916591','2026-03-24','09:16:59','LIS','700000','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-260324-0007','D','2026-03-24','09:16:59','kasir','PENJUALAN','F326240916591','3594930000','700000','3595630000');
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 ('F326240922491','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZCAI-371-0','CC X MODEL MATA LG 6 8K ','','0.930','1','100.00','1051000','0','0','15000','1050000','0','0','0','1050000','FIT','00395769','E2D','0','0','-','1','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-371-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCAI-371-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240922491','2026-03-24','0.930','2026-03-24','09:22:50','PLG0028004','1050000','1050000','0','1050000','1050000','kasir','2026-03-24 09:22:49','F32624092249');
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-03-24','F326240922491','2026-03-24','09:22:50','FIT','1050000','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-260324-0008','D','2026-03-24','09:22:50','kasir','PENJUALAN','F326240922491','3595630000','1050000','3596680000');
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 ('F326240929351','kasir','1',' MDE2 CM 12','TOKO','PM-E','E2D-ZCAF-94-0','CC COR MODEL MATA CM 12 8K ','','1.060','1','100.00','1198000','0','0','15000','1198000','0','0','0','1198000','AAT','00394712','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAF-94-0' 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='2026-03-24' AND kode_barang='E2D-ZCAF-94-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240929351','2026-03-24','1.060','2026-03-24','09:29:36','PLG0028005','1198000','1198000','0','1198000','1198000','kasir','2026-03-24 09:29:35','F32624092935');
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-03-24','F326240929351','2026-03-24','09:29:36','AAT','1198000','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-260324-0009','D','2026-03-24','09:29:36','kasir','PENJUALAN','F326240929351','3596680000','1198000','3597878000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1198000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240929351' 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 ('F326240929352','kasir',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-YIBD-356-0','CC X WEDDING POLOS CM 14 8K ','','1.030','1','100.00','1164000','0','0','15000','1165000','0','0','0','1165000','AAT','00370777','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBD-356-0' 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-03-24' AND kode_barang='E1D-YIBD-356-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240929352','2026-03-24','1.030','2026-03-24','09:29:36','PLG0028006','1165000','1165000','0','1165000','1165000','kasir','2026-03-24 09:29:35','F32624092935');
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-03-24','F326240929352','2026-03-24','09:29:36','AAT','1165000','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-260324-0010','D','2026-03-24','09:29:36','kasir','PENJUALAN','F326240929352','3597878000','1165000','3599043000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1165000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240929352' 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 ('F326240930411','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-YKXC-550-0','CC X MODEL DAUN SLEP UB 14 8K ','','0.900','1','100.00','1017000','0','0','15000','1018000','0','0','0','1018000','AAT','00376481','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKXC-550-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-YKXC-550-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240930411','2026-03-24','0.900','2026-03-24','09:30:42','PLG0028007','1018000','1018000','0','1018000','1018000','kasir','2026-03-24 09:30:41','F32624093041');
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-03-24','F326240930411','2026-03-24','09:30:42','AAT','1018000','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-260324-0011','D','2026-03-24','09:30:42','kasir','PENJUALAN','F326240930411','3599043000','1018000','3600061000');
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 ('F326240936231','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCAD-210-0','CC X SOLITAIRE MATA CM 10 8K ','','1.150','1','100.00','1299000','0','0','15000','1300000','0','10000','0','1310000','FIT','00394341','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAD-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCAD-210-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240936231','2026-03-24','1.150','2026-03-24','09:36:23','PLG0028008','1300000','1300000','10000','1310000','1310000','kasir','2026-03-24 09:36:23','F32624093623');
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-03-24','F326240936231','2026-03-24','09:36:23','FIT','1310000','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-260324-0012','D','2026-03-24','09:36:23','kasir','PENJUALAN','F326240936231','3600061000','1310000','3601371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1310000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240936231' 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 ('F326240936232','kasir',' 1',' MGE1 X HW ','TOKO','PM-E','E1G-ZCAI-211-0','CC X RING GELOMBANG SLEP HW 13 8K ','','0.360','1','100.00','428000','0','0','15000','428000','0','0','0','428000','FIT','00395607','E1G','0','0','-','0','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCAI-211-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1G-ZCAI-211-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240936232','2026-03-24','0.360','2026-03-24','09:36:23','PLG0028009','428000','428000','0','428000','428000','kasir','2026-03-24 09:36:23','F32624093623');
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-03-24','F326240936232','2026-03-24','09:36:23','FIT','428000','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-260324-0013','D','2026-03-24','09:36:23','kasir','PENJUALAN','F326240936232','3601371000','428000','3601799000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='428000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240936232' 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 ('F326240949501','kasir','1',' MDE1 X OR ','TOKO','PM-E','E1D-YIAC-19-0','CC X VELG POLOS OR 16 8K ','','1.500','1','100.00','1695000','0','0','15000','1695000','0','0','0','1695000','FIT','00369103','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIAC-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1D-YIAC-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240949501','2026-03-24','1.500','2026-03-24','09:49:51','PLG0028010','1695000','1695000','0','1695000','1695000','kasir','2026-03-24 09:49:50','F32624094950');
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-03-24','F326240949501','2026-03-24','09:49:51','FIT','1695000','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-260324-0014','D','2026-03-24','09:49:51','kasir','PENJUALAN','F326240949501','3601799000','1695000','3603494000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1695000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240949501' 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 ('F326240949502','kasir',' 1',' MDE1 CM 20','TOKO','PM-E','E1D-YJCX-85-0','CC WEDDING POLOS CM 20 8K ','','1.500','1','100.00','1695000','0','0','15000','1695000','0','0','0','1695000','FIT','00375297','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJCX-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1D-YJCX-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240949502','2026-03-24','1.500','2026-03-24','09:49:51','PLG0028011','1695000','1695000','0','1695000','1695000','kasir','2026-03-24 09:49:50','F32624094950');
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-03-24','F326240949502','2026-03-24','09:49:51','FIT','1695000','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-260324-0015','D','2026-03-24','09:49:51','kasir','PENJUALAN','F326240949502','3603494000','1695000','3605189000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1695000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240949502' 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 ('F326241013341','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-YKXD-139-0','KL X SIEM KH 44 9K ','','3.050','1','100.00','3751000','0','0','15000','3750000','0','0','0','3750000','AAT','00376675','H2I','0','0','-','1','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YKXD-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='H2I-YKXD-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241013341','2026-03-24','3.050','2026-03-24','10:13:35','PLG0028012','3750000','3750000','0','3750000','3750000','kasir','2026-03-24 10:13:34','F32624101334');
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-03-24','F326241013341','2026-03-24','10:13:35','AAT','3750000','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-260324-0016','D','2026-03-24','10:13:35','kasir','PENJUALAN','F326241013341','3605189000','3750000','3608939000');
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 ('F326241016321','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZCAI-345-0','CC X MODEL MATA UB 12 8K ','','0.900','1','100.00','1017000','0','0','15000','1018000','0','0','0','1018000','LIS','00395743','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-345-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCAI-345-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241016321','2026-03-24','0.900','2026-03-24','10:16:33','PLG0028013','1018000','1018000','0','1018000','1018000','kasir','2026-03-24 10:16:32','F32624101632');
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-03-24','F326241016321','2026-03-24','10:16:33','LIS','1018000','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-260324-0017','D','2026-03-24','10:16:33','kasir','PENJUALAN','F326241016321','3608939000','1018000','3609957000');
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 ('F326241023061','kasir','1',' MDE2X 10K ','TOKO','PM-E','E2D-ZCAI-737-0','CC X WEDDING MATA CM 18 8K ','','1.660','1','100.00','1876000','0','0','15000','1876000','0','10000','0','1886000','AAT','00396139','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-737-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCAI-737-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241023061','2026-03-24','1.660','2026-03-24','10:23:07','PLG0028014','1876000','1876000','10000','1886000','1886000','kasir','2026-03-24 10:23:06','F32624102306');
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-03-24','F326241023061','2026-03-24','10:23:07','AAT','1886000','10000');
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-260324-0018','D','2026-03-24','10:23:07','kasir','PENJUALAN','F326241023061','3609957000','1886000','3611843000');
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 ('F326241038191','kasir','1',' MEB1E X LG','TOKO','PM-B','B1E-YLAF-74-0','GW X TIFF MATA VAR LG 8K','','0.570','1','100.00','655000','0','0','15000','655000','0','0','0','655000','FIT','00381258','B1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLAF-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='B1E-YLAF-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241038191','2026-03-24','0.570','2026-03-24','10:38:19','PLG0028015','655000','655000','0','655000','655000','kasir','2026-03-24 10:38:19','F32624103819');
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-03-24','F326241038191','2026-03-24','10:38:19','FIT','655000','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-260324-0019','D','2026-03-24','10:38:19','kasir','PENJUALAN','F326241038191','3611843000','655000','3612498000');
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 ('F326241039211','kasir','1',' MEE2 X 5K ','TOKO','PM-E','E2E-YLBC-237-0','CC X ANAK BONEKA CAT MATA VAR LG 8K ','','0.530','1','100.00','609000','0','0','15000','610000','0','5000','0','615000','AAT','00382680','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLBC-237-0' 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-03-24' AND kode_barang='E2E-YLBC-237-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241039211','2026-03-24','0.530','2026-03-24','10:39:21','PLG0028016','610000','610000','5000','615000','615000','kasir','2026-03-24 10:39:21','F32624103921');
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-03-24','F326241039211','2026-03-24','10:39:21','AAT','615000','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-260324-0020','D','2026-03-24','10:39:21','kasir','PENJUALAN','F326241039211','3612498000','615000','3613113000');
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 ('F326241044561','kasir','1',' MDE2 LG ','TOKO','PM-E','E2D-ZCAX-165-0','CC OSROT ANAK BONEKA CAT MATA LG 8K ','','0.950','1','100.00','1073000','0','0','15000','1073000','0','0','0','1073000','LIS','00393137','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAX-165-0' 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-03-24' AND kode_barang='E2D-ZCAX-165-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241044561','2026-03-24','0.950','2026-03-24','10:44:56','PLG0028017','1073000','1073000','0','1073000','1073000','kasir','2026-03-24 10:44:56','F32624104456');
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-03-24','F326241044561','2026-03-24','10:44:56','LIS','1073000','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-260324-0021','D','2026-03-24','10:44:56','kasir','PENJUALAN','F326241044561','3613113000','1073000','3614186000');
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-00018550','X-00018550','GL X ANAK BANGKOK SLEP HK','GR','---','F1TE','BELI','BELI001','2980000','2026-03-24','2.150','1','kasir','2026-03-24 11:00:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TE','X-00018550','X-00018550');
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-260324-0001','F322250249241','FIT','1','BELI','BELI001','F1TE', 'X-00018550', 'GL X ANAK BANGKOK SLEP HK','2.150','2.150','100.00','1591000','2980000','1386047','2100000','1','2980000','2980000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.150',berat_beli_asli=berat_beli_asli+'2.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.150',berat_akhir_asli=berat_akhir_asli+'2.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TE' 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-260324-0001','2026-03-24','2026-03-24','11:00:33','FIT','---','2.150','2980000','2980000','2980000','2980000','2980000','kasir','2026-03-24 11:00:33','FB-260324-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0001','ENI','PURWANTORO','','','','kasir','2026-03-24 11:00:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0022','K','2026-03-24','11:00:33','kasir','PEMBELIAN UMUM','FB-260324-0001','3614186000','2980000','3611206000');
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-00018551','X-00018551','GL X OVAL MATA UB 56 8K','GR','---','F2E','BELI','BELI001','2177000','2026-03-24','2.630','1','kasir','2026-03-24 11:00:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018551','X-00018551');
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-260324-0002','F325030958141','AAT','1','BELI','BELI001','F2E', 'X-00018551', 'GL X OVAL MATA UB 56 8K','2.630','2.630','100.00','2605000','2177000','827757','1160000','1','2177000','2177000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.630',berat_beli_asli=berat_beli_asli+'2.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.630',berat_akhir_asli=berat_akhir_asli+'2.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260324-0002','2026-03-24','2026-03-24','11:00:54','AAT','---','2.630','2177000','2177000','2177000','2177000','2177000','kasir','2026-03-24 11:00:55','FB-260324-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0002','DEWI','NGLAMBONG BADEGAN','','','','kasir','2026-03-24 11:00:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0023','K','2026-03-24','11:00:54','kasir','PEMBELIAN UMUM','FB-260324-0002','3611206000','2177000','3609029000');
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-00018552','X-00018552','LT XXX MODEL MATA ROSE UB 8K','GR','---','D2E','BELI','BELI001','670000','2026-03-24','0.770','1','kasir','2026-03-24 11:02:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00018552','X-00018552');
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-260324-0003','F326090851041','AAT','1','BELI','BELI001','D2E', 'X-00018552', 'LT XXX MODEL MATA ROSE UB 8K','0.770','0.770','100.00','820000','670000','870130','1160000','1','670000','670000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.770',berat_beli_asli=berat_beli_asli+'0.770',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.770',berat_akhir_asli=berat_akhir_asli+'0.770',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260324-0003','2026-03-24','2026-03-24','11:02:08','AAT','---','0.770','670000','670000','670000','670000','670000','kasir','2026-03-24 11:02:09','FB-260324-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0003','MIYEM','DAWUNG KISMANTORO','','','','kasir','2026-03-24 11:02:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0024','K','2026-03-24','11:02:08','kasir','PEMBELIAN UMUM','FB-260324-0003','3609029000','670000','3608359000');
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-00018553','X-00018553','GL X TIFF SLEP LT 8K','GR','---','F3E','BELI','BELI001','560000','2026-03-24','0.580','1','kasir','2026-03-24 11:02:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018553','X-00018553');
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-260324-0004','F326160156231','FIT','1','BELI','BELI001','F3E', 'X-00018553', 'GL X TIFF SLEP LT 8K','0.580','0.580','100.00','715000','560000','965517','1160000','1','560000','560000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' 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-260324-0004','2026-03-24','2026-03-24','11:02:34','FIT','---','0.580','560000','560000','560000','560000','560000','kasir','2026-03-24 11:02:35','FB-260324-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0004','DWI','GONDANG TAPEL','','','','kasir','2026-03-24 11:02:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0025','K','2026-03-24','11:02:34','kasir','PEMBELIAN UMUM','FB-260324-0004','3608359000','560000','3607799000');
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-00018554','X-00018554','CC X MODEL PIPA MATA HT 14 8K','GR','---','E2E','BELI','BELI001','440000','2026-03-24','0.450','1','kasir','2026-03-24 11:02:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018554','X-00018554');
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-260324-0005','F326030857091','FIT','1','BELI','BELI001','E2E', 'X-00018554', 'CC X MODEL PIPA MATA HT 14 8K','0.450','0.450','100.00','480000','440000','977778','1160000','1','440000','440000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260324-0005','2026-03-24','2026-03-24','11:02:54','FIT','---','0.450','440000','440000','440000','440000','440000','kasir','2026-03-24 11:02:55','FB-260324-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0005','IKAH','CENGKLOK KISMANTORO','','','','kasir','2026-03-24 11:02:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0026','K','2026-03-24','11:02:54','kasir','PEMBELIAN UMUM','FB-260324-0005','3607799000','440000','3607359000');
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-00018555','X-00018555','AT X WG DAISY MATA CM','GR','---','PAG','BELI','BELI001','507000','2026-03-24','0.530','1','kasir','2026-03-24 11:03:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-PAG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PAG','X-00018555','X-00018555');
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-260324-0006','F325031150521','FIT','1','BELI','BELI001','PAG', 'X-00018555', 'AT X WG DAISY MATA CM','0.530','0.530','100.00','565000','507000','956604','1190000','1','507000','507000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PAG' 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-260324-0006','2026-03-24','2026-03-24','11:03:18','FIT','---','0.530','507000','507000','507000','507000','507000','kasir','2026-03-24 11:03:18','FB-260324-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0006','DEWI','LEMAHBANG','','','082322256165','kasir','2026-03-24 11:03:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0027','K','2026-03-24','11:03:18','kasir','PEMBELIAN UMUM','FB-260324-0006','3607359000','507000','3606852000');
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-00018556','X-00018556','CC X MODEL MATA LG 14 8K','GR','---','E2E','BELI','BELI001','650000','2026-03-24','1.100','1','kasir','2026-03-24 11:03:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018556','X-00018556');
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-260324-0007','F324120254281','FIT','1','BELI','BELI001','E2E', 'X-00018556', 'CC X MODEL MATA LG 14 8K','1.100','1.100','100.00','655000','650000','590909','1160000','1','650000','650000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260324-0007','2026-03-24','2026-03-24','11:03:41','FIT','---','1.100','650000','650000','650000','650000','650000','kasir','2026-03-24 11:03:41','FB-260324-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0007','FATIMAH','NGROTO KISMANTORO','','','','kasir','2026-03-24 11:03:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0028','K','2026-03-24','11:03:41','kasir','PEMBELIAN UMUM','FB-260324-0007','3606852000','650000','3606202000');
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 ('F326241114181','kasir','1',' MED2E X LG','TOKO','PM-D','D2E-XJAB-73-0','LT X MODEL MATA LG 8K ','','0.500','1','100.00','575000','0','0','15000','575000','0','0','0','575000','AAT','00320960','D2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-XJAB-73-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-03-24' AND kode_barang='D2E-XJAB-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241114181','2026-03-24','0.500','2026-03-24','11:14:19','PLG0028018','575000','575000','0','575000','575000','kasir','2026-03-24 11:14:18','F32624111418');
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-03-24','F326241114181','2026-03-24','11:14:19','AAT','575000','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-260324-0029','D','2026-03-24','11:14:19','kasir','PENJUALAN','F326241114181','3606202000','575000','3606777000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241114181' 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 ('F326241114182','kasir',' 1',' MED2E X HW','TOKO','PM-D','D2E-ZCXG-311-0','LT X MODEL COIN DOLLAR HW 8K ','','0.500','1','100.00','575000','0','0','15000','575000','0','0','0','575000','AAT','00392747','D2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCXG-311-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-03-24' AND kode_barang='D2E-ZCXG-311-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241114182','2026-03-24','0.500','2026-03-24','11:14:19','PLG0028019','575000','575000','0','575000','575000','kasir','2026-03-24 11:14:18','F32624111418');
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-03-24','F326241114182','2026-03-24','11:14:19','AAT','575000','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-260324-0030','D','2026-03-24','11:14:19','kasir','PENJUALAN','F326241114182','3606777000','575000','3607352000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241114182' 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 ('F326241139141','kasir','1',' MEF2 XX PM','TOKO','PM-F','F2E-ZAAE-24-0','GL XX PIPA MATA PM 56 8K ','','3.050','1','100.00','3507000','0','0','15000','3415000','0','0','0','3415000','AAT','00385273','F2E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZAAE-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='F2E-ZAAE-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241139141','2026-03-24','3.050','2026-03-24','11:39:14','PLG0028020','3415000','3415000','0','3415000','3415000','kasir','2026-03-24 11:39:14','F32624113914');
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-03-24','F326241139141','2026-03-24','11:39:14','AAT','3415000','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-260324-0031','D','2026-03-24','11:39:14','kasir','PENJUALAN','F326241139141','3607352000','3415000','3610767000');
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 ('F326241149091','kasir','1',' MEE1 LG 19','TOKO','PM-E','E1E-ZCAC-221-0','CC MODEL DAUN SLEP VAR LG 19 8K ','','0.530','1','100.00','609000','0','0','15000','610000','0','0','0','610000','FIT','00394122','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAC-221-0' 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-03-24' AND kode_barang='E1E-ZCAC-221-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241149091','2026-03-24','0.530','2026-03-24','11:49:10','PLG0028021','610000','610000','0','610000','610000','kasir','2026-03-24 11:49:09','F32624114909');
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-03-24','F326241149091','2026-03-24','11:49:10','FIT','610000','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-260324-0032','D','2026-03-24','11:49:10','kasir','PENJUALAN','F326241149091','3610767000','610000','3611377000');
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 ('F326241151551','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZCXB-102-0','CC X METRO MATA LG 16 8K ','','0.940','1','100.00','1062000','0','0','15000','1063000','0','0','0','1063000','AAT','00391525','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.940',berat_jual_asli=berat_jual_asli+'0.940',stock_jual='1',berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCXB-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241151551','2026-03-24','0.940','2026-03-24','11:51:56','PLG0028022','1063000','1063000','0','1063000','1063000','kasir','2026-03-24 11:51:55','F32624115155');
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-03-24','F326241151551','2026-03-24','11:51:56','AAT','1063000','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-260324-0033','D','2026-03-24','11:51:56','kasir','PENJUALAN','F326241151551','3611377000','1063000','3612440000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1063000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241151551' 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 ('F326241151552','kasir',' 1',' MDE1 PM 16','TOKO','PM-E','E1D-ZCAG-218-0','CC MODEL DAUN SLEP PM 16 8K ','','1.000','1','100.00','1130000','0','0','15000','1130000','0','0','0','1130000','AAT','00394936','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAG-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1D-ZCAG-218-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241151552','2026-03-24','1.000','2026-03-24','11:51:56','PLG0028023','1130000','1130000','0','1130000','1130000','kasir','2026-03-24 11:51:55','F32624115155');
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-03-24','F326241151552','2026-03-24','11:51:56','AAT','1130000','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-260324-0034','D','2026-03-24','11:51:56','kasir','PENJUALAN','F326241151552','3612440000','1130000','3613570000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1130000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326241151552' 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 ('F326241159391','kasir','1',' MDE2 5K LG','TOKO','PM-E','E2D-ZCAA-155-0','CC OSROT ANAK BONEKA CAT MATA LG 8K ','','0.960','1','100.00','1085000','0','0','15000','1085000','0','5000','0','1090000','LIS','00393657','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAA-155-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-03-24' AND kode_barang='E2D-ZCAA-155-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326241159391','2026-03-24','0.960','2026-03-24','11:59:39','PLG0028024','1085000','1085000','5000','1090000','1090000','kasir','2026-03-24 11:59:39','F32624115939');
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-03-24','F326241159391','2026-03-24','11:59:39','LIS','1090000','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-260324-0035','D','2026-03-24','11:59:39','kasir','PENJUALAN','F326241159391','3613570000','1090000','3614660000');
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 ('F326240105041','input','1',' MEE2 UB 10','TOKO','PM-E','E2E-YIBX-21-0','CC MODEL MATA UB 10 8K ','','0.600','1','100.00','690000','0','0','15000','690000','0','0','0','690000','LIS','00370010','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBX-21-0' 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='2026-03-24' AND kode_barang='E2E-YIBX-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240105041','2026-03-24','0.600','2026-03-24','13:05:04','PLG0028025','690000','690000','0','690000','690000','input','2026-03-24 13:05:04','F32624010504');
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-03-24','F326240105041','2026-03-24','13:05:04','LIS','690000','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-260324-0036','D','2026-03-24','13:05:04','input','PENJUALAN','F326240105041','3614660000','690000','3615350000');
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 ('F326240137451','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCAI-435-0','CC X SOLITAIRE MATA CM 12 8K ','','1.300','1','100.00','1469000','0','0','15000','1470000','0','10000','0','1480000','FIT','00395833','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-435-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-ZCAI-435-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240137451','2026-03-24','1.300','2026-03-24','13:37:46','PLG0028026','1470000','1470000','10000','1480000','1480000','input','2026-03-24 13:37:45','F32624013745');
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-03-24','F326240137451','2026-03-24','13:37:46','FIT','1480000','10000');
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-260324-0037','D','2026-03-24','13:37:46','input','PENJUALAN','F326240137451','3615350000','1480000','3616830000');
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-00018557','X-00018557','GL X PIPA MATA KH 58 8K','GR','---','F2E','BELI','BELI001','5522000','2026-03-24','7.060','1','kasir','2026-03-24 14:00:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018557','X-00018557');
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-260324-0008','F325121228451','AAT','1','BELI','BELI001','F2E', 'X-00018557', 'GL X PIPA MATA KH 58 8K','7.060','7.060','100.00','5875000','5522000','782153','1160000','1','5522000','5522000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.060',berat_beli_asli=berat_beli_asli+'7.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.060',berat_akhir_asli=berat_akhir_asli+'7.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260324-0008','2026-03-24','2026-03-24','14:00:27','AAT','---','7.060','5522000','5522000','5522000','5522000','5522000','kasir','2026-03-24 14:00:28','FB-260324-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0008','NOVITA','SIGERENG TEGALREJO','','','082324608975','kasir','2026-03-24 14:00:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0038','K','2026-03-24','14:00:27','kasir','PEMBELIAN UMUM','FB-260324-0008','3616830000','5522000','3611308000');
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-00018558','X-00018558','CC X WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1632000','2026-03-24','2.270','1','kasir','2026-03-24 14:02:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018558','X-00018558');
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-260324-0009','F325301211131','FIT','1','BELI','BELI001','E2D', 'X-00018558', 'CC X WEDDING MATA CM 16 8K','2.270','2.270','100.00','1737000','1632000','718943','1140000','1','1632000','1632000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.270',berat_beli_asli=berat_beli_asli+'2.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.270',berat_akhir_asli=berat_akhir_asli+'2.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-24' 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-260324-0009','2026-03-24','2026-03-24','14:02:48','FIT','---','2.270','1632000','1632000','1632000','1632000','1632000','kasir','2026-03-24 14:02:48','FB-260324-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260324-0009','WAWAN','PONOROGO','','','','kasir','2026-03-24 14:02:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-24' 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-260324-0039','K','2026-03-24','14:02:48','kasir','PEMBELIAN UMUM','FB-260324-0009','3611308000','1632000','3609676000');
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 ('F326240205221','kasir','1',' MEE2 5K LG','TOKO','PM-E','E2E-ZCAH-340-0','CC OSROT ANAK BONEKA CAT MATA LG 8K','','0.510','1','100.00','586000','0','0','15000','588000','0','5000','0','593000','AAT','00395295','E2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAH-340-0' 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='2026-03-24' AND kode_barang='E2E-ZCAH-340-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240205221','2026-03-24','0.510','2026-03-24','14:05:22','PLG0028027','588000','588000','5000','593000','593000','kasir','2026-03-24 14:05:22','F32624020522');
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-03-24','F326240205221','2026-03-24','14:05:22','AAT','593000','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-260324-0040','D','2026-03-24','14:05:22','kasir','PENJUALAN','F326240205221','3609676000','593000','3610269000');
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 ('F326240219131','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZBXD-254-0','CC X VELG POLOS CM 22 8K ','','1.500','1','100.00','1695000','0','0','15000','1695000','0','0','0','1695000','LIS','00387939','E1D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBXD-254-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1D-ZBXD-254-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240219131','2026-03-24','1.500','2026-03-24','14:19:13','PLG0028028','1695000','1695000','0','1695000','1695000','kasir','2026-03-24 14:19:13','F32624021913');
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-03-24','F326240219131','2026-03-24','14:19:13','LIS','1695000','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-260324-0041','D','2026-03-24','14:19:13','kasir','PENJUALAN','F326240219131','3610269000','1695000','3611964000');
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 ('F326240221081','kasir','1',' MEE1 CM 12','TOKO','PM-E','E1E-ZCAX-520-0','CC MODEL DUAN SLEP CM 12 8K ','','0.780','1','100.00','897000','0','0','15000','897000','0','0','0','897000','AAT','00393497','E1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAX-520-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E1E-ZCAX-520-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240221081','2026-03-24','0.780','2026-03-24','14:21:09','PLG0028029','897000','897000','0','897000','897000','kasir','2026-03-24 14:21:08','F32624022108');
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-03-24','F326240221081','2026-03-24','14:21:09','AAT','897000','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-260324-0042','D','2026-03-24','14:21:09','kasir','PENJUALAN','F326240221081','3611964000','897000','3612861000');
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 ('F326240222251','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZCXG-211-0','KL X GUCCI ANAK UB 34 8K ','','1.070','1','100.00','1230000','0','0','15000','1230000','0','0','0','1230000','AAT','00392647','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXG-211-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='H1E-ZCXG-211-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240222251','2026-03-24','1.070','2026-03-24','14:22:25','PLG0028030','1230000','1230000','0','1230000','1230000','kasir','2026-03-24 14:22:25','F32624022225');
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-03-24','F326240222251','2026-03-24','14:22:25','AAT','1230000','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-260324-0043','D','2026-03-24','14:22:25','kasir','PENJUALAN','F326240222251','3612861000','1230000','3614091000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1230000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240222251' 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 ('F326240222252','kasir',' 1',' MED1 5K LG','TOKO','PM-D','D1E-YLBC-71-0','LT MODEL APEL CAT VAR LG 8K ','','0.550','1','100.00','632000','0','0','15000','633000','0','5000','0','638000','AAT','00382514','D1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YLBC-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='D1E-YLBC-71-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240222252','2026-03-24','0.550','2026-03-24','14:22:25','PLG0028031','633000','633000','5000','638000','638000','kasir','2026-03-24 14:22:25','F32624022225');
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-03-24','F326240222252','2026-03-24','14:22:25','AAT','638000','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-260324-0044','D','2026-03-24','14:22:25','kasir','PENJUALAN','F326240222252','3614091000','638000','3614729000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240222252' 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 ('F326240226321','kasir','1',' MEF3E X LG','TOKO','PM-F','F3E-ZBXF-30-0','GL X TIFF DAUN VAR SERUT LG 8K ','','1.730','1','100.00','1989000','0','0','15000','1990000','0','0','0','1990000','LIS','00388612','F3E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBXF-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='F3E-ZBXF-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240226321','2026-03-24','1.730','2026-03-24','14:26:33','PLG0028032','1990000','1990000','0','1990000','1990000','kasir','2026-03-24 14:26:32','F32624022632');
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-03-24','F326240226321','2026-03-24','14:26:33','LIS','1990000','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-260324-0045','D','2026-03-24','14:26:33','kasir','PENJUALAN','F326240226321','3614729000','1990000','3616719000');
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 ('F326240237341','kasir','1',' MEH1 X UB4','TOKO','PM-H','H1E-ZBXE-310-0','KL X GUCCI UB 42 8K ','','1.100','1','100.00','1265000','0','0','15000','1265000','0','0','0','1265000','LIS','00388578','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBXE-310-0' 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='2026-03-24' AND kode_barang='H1E-ZBXE-310-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240237341','2026-03-24','1.100','2026-03-24','14:37:35','PLG0028033','1265000','1265000','0','1265000','1265000','kasir','2026-03-24 14:37:34','F32624023734');
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-03-24','F326240237341','2026-03-24','14:37:35','LIS','1265000','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-260324-0046','D','2026-03-24','14:37:35','kasir','PENJUALAN','F326240237341','3616719000','1265000','3617984000');
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 ('F326240238151','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZCXG-173-0','GL XX OVAL C SLEP UB 54 8K ','','1.350','1','100.00','1552000','0','0','15000','1515000','0','0','0','1515000','FIT','00392609','F1E','0','0','-','1','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCXG-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='F1E-ZCXG-173-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240238151','2026-03-24','1.350','2026-03-24','14:38:15','PLG0028034','1515000','1515000','0','1515000','1515000','kasir','2026-03-24 14:38:15','F32624023815');
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-03-24','F326240238151','2026-03-24','14:38:15','FIT','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) VALUES ('KM-260324-0047','D','2026-03-24','14:38:15','kasir','PENJUALAN','F326240238151','3617984000','1515000','3619499000');
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 ('F326240241031','kasir','1',' MEF2 X PM ','TOKO','PM-F','F2E-ZCAH-405-0','GL X PIPA MATA PM 56 8K ','','3.070','1','100.00','3530000','0','0','15000','3530000','0','0','0','3530000','AAT','00395360','F2E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZCAH-405-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='F2E-ZCAH-405-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240241031','2026-03-24','3.070','2026-03-24','14:41:04','PLG0028035','3530000','3530000','0','3530000','3530000','kasir','2026-03-24 14:41:03','F32624024103');
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-03-24','F326240241031','2026-03-24','14:41:04','AAT','3530000','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-260324-0048','D','2026-03-24','14:41:04','kasir','PENJUALAN','F326240241031','3619499000','3530000','3623029000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240241031' 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 ('F326240241032','kasir',' 1',' MDE2 X UB ','TOKO','PM-E','E2D-YAXD-133-0','CC X MODEL MATA UB 16 8K ','','1.460','1','100.00','1650000','0','0','15000','1650000','0','0','0','1650000','AAT','00332372','E2D','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YAXD-133-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='E2D-YAXD-133-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240241032','2026-03-24','1.460','2026-03-24','14:41:04','PLG0028036','1650000','1650000','0','1650000','1650000','kasir','2026-03-24 14:41:03','F32624024103');
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-03-24','F326240241032','2026-03-24','14:41:04','AAT','1650000','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-260324-0049','D','2026-03-24','14:41:04','kasir','PENJUALAN','F326240241032','3623029000','1650000','3624679000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240241032' 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 ('F326240241033','kasir',' 1',' MEH1 10K H','TOKO','PM-H','H1E-YJXD-253-0','KL SANTA MODEL HATI CAT MATA VAR HW 8K ','','2.190','1','100.00','2518000','0','0','15000','2520000','0','10000','0','2530000','AAT','00372233','H1E','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXD-253-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='H1E-YJXD-253-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326240241033','2026-03-24','2.190','2026-03-24','14:41:04','PLG0028037','2520000','2520000','10000','2530000','2530000','kasir','2026-03-24 14:41:03','F32624024103');
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-03-24','F326240241033','2026-03-24','14:41:04','AAT','2530000','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-260324-0050','D','2026-03-24','14:41:04','kasir','PENJUALAN','F326240241033','3624679000','2530000','3627209000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326240241033' 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 ('F326240245211','kasir','1',' TEE2 HTM 1','TOKO','PT-E','E2TE-YEBA-80-T','CC PIPA MODEL MATA VAR HTM 14 17K ','','0.510','1','100.00','1066000','0','0','15000','1066000','0','0','0','1066000','AAT','T0069501','E2TE','0','0','-','0','2100000');
UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-YEBA-80-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='2026-03-24' AND kode_barang='E2TE-YEBA-80-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326240245211','2026-03-24','0.510','2026-03-24','14:45:21','PLG0028038','1066000','1066000','0','1066000','1066000','kasir','2026-03-24 14:45:21','F32624024521');
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-03-24','F326240245211','2026-03-24','14:45:21','AAT','1066000','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-260324-0051','D','2026-03-24','14:45:21','kasir','PENJUALAN','F326240245211','3627209000','1066000','3628275000');
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-260324-0001','1','F3E-ZCXE-150-0','1','3.040','3.040','TOKO','PM-F','TOKO','MBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MBK-F' WHERE kode_barang='F3E-ZCXE-150-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-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-03-24','TOKO','MBK-F','F3E','F3E-ZCXE-150-0','100.00','1','3.040','3.040','1','3.040','3.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.040',berat_out_asli=berat_out_asli+'3.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-03-24' AND kode_barang='F3E-ZCXE-150-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-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-260324-0001','2026-03-24','2026-03-24','15:11','3.04','input','2026-03-24 15:11:58');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260324-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260324-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240105041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240105041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240105041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240137451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240137451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240137451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240205221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240205221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240205221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240219131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240219131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240219131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240221081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240221081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240221081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240222251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240222251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240222251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240222252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240222252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240222252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240226321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240226321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240226321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240237341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240237341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240237341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240238151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240238151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240238151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240241031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240241031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240241031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240241032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240241032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240241032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240241033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240241033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240241033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240245211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240245211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240245211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240843041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240843041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240843041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240855171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240855171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240855171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240856111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240856111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240856111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240904371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240904371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240904371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240914381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240914381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240914381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240916591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240916591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240916591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240922491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240922491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240922491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240929351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240929351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240929351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240929352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240929352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240929352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240930411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240930411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240930411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240936231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240936231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240936231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240936232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240936232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240936232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240949501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240949501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240949501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326240949502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326240949502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326240949502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241013341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241013341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241013341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241016321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241016321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241016321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241023061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241023061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241023061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241038191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241038191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241038191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241039211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241039211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241039211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241044561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241044561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241044561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241114181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241114181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241114181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241114182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241114182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241114182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241139141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241139141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241139141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241149091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241149091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241149091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241151551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241151551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241151551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241151552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241151552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241151552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326241159391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326241159391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326241159391';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-24';
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-03-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-24' 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-260325-0001','D','2026-03-25','15:39:43','SYSTEM','SALDO AWAL','SALDO AWAL','0','3628275000','3628275000');
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-260325-0001','D','2026-03-25','15:39:43','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260325-0001','D','2026-03-25','15:39:43','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-260325-0001','D','2026-03-25','15:39:43','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-03-25';