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-20260626-0001','1','B1E-ZFBE-163-0','1','0.600','0.600','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFBE-163-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFBE-163-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-06-26 07:32:50' WHERE kode_barang='B1E-ZFBE-163-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFBE-163-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-06-26 07:32:50','TOKO','PM-B','B1E','B1E-ZFBE-163-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' 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='B1E-ZFBE-163-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFBE-163-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260626-0001','2026-06-26','07:32','0.600','admpindah','2026-06-26 07:32:50');
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-20260626-0001','1','E1D-ZFBB-244-0','1','1.100','1.100','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFBB-244-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFBB-244-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1D-ZFBB-244-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFBB-244-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-06-26 07:33:11','TOKO','PM-E','E1D','E1D-ZFBB-244-0','1','1.100','1.100','1','1.100','1.100','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-ZFBB-244-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFBB-244-0';
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-20260626-0001','1','E1E-ZFBE-141-0','1','0.610','0.610','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-141-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-141-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-141-0';
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-20260626-0001','1','E1E-ZFBE-142-0','1','0.660','0.660','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-142-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-142-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-142-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-142-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-142-0','1','0.660','0.660','1','0.660','0.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-142-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-142-0';
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-20260626-0001','1','E1E-ZFBE-143-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-143-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-143-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-143-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-143-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-143-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-143-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-143-0';
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-20260626-0001','1','E1E-ZFBE-145-0','1','0.620','0.620','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-145-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-145-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-145-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-145-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-145-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-145-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-145-0';
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-20260626-0001','1','E1E-ZFBE-146-0','1','0.720','0.720','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-146-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-146-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-146-0','1','0.720','0.720','1','0.720','0.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-146-0';
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-20260626-0001','1','E1E-ZFBE-147-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-147-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-147-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-147-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-147-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-147-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-147-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-147-0';
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-20260626-0001','1','E1F-ZFBE-148-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZFBE-148-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZFBE-148-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1F-ZFBE-148-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZFBE-148-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-06-26 07:33:11','TOKO','PM-E','E1F','E1F-ZFBE-148-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZFBE-148-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZFBE-148-0';
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-20260626-0001','1','E1E-ZFBE-149-0','1','0.510','0.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-149-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-149-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-149-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-149-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-149-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-149-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-149-0';
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-20260626-0001','1','E1E-ZFBE-150-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFBE-150-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-150-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1E-ZFBE-150-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFBE-150-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-06-26 07:33:11','TOKO','PM-E','E1E','E1E-ZFBE-150-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFBE-150-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFBE-150-0';
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-20260626-0001','1','E1D-ZFBE-151-0','1','0.820','0.820','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFBE-151-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFBE-151-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-26 07:33:11' WHERE kode_barang='E1D-ZFBE-151-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFBE-151-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-06-26 07:33:11','TOKO','PM-E','E1D','E1D-ZFBE-151-0','1','0.820','0.820','1','0.820','0.820','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-ZFBE-151-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFBE-151-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260626-0001','2026-06-26','07:33','6.820','admpindah','2026-06-26 07:33: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-20260626-0001','1','F3E-ZFXH-152-0','1','2.150','2.150','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFXH-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFXH-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-26 07:33:36' WHERE kode_barang='F3E-ZFXH-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFXH-152-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-06-26 07:33:36','TOKO','PM-F','F3E','F3E-ZFXH-152-0','1','2.150','2.150','1','2.150','2.150','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-ZFXH-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFXH-152-0';
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-20260626-0001','1','F3E-ZFBE-165-0','1','1.610','1.610','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFBE-165-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFBE-165-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-26 07:33:36' WHERE kode_barang='F3E-ZFBE-165-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFBE-165-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-06-26 07:33:36','TOKO','PM-F','F3E','F3E-ZFBE-165-0','1','1.610','1.610','1','1.610','1.610','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-ZFBE-165-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFBE-165-0';
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-20260626-0001','1','F3E-ZFBE-166-0','1','4.430','4.430','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFBE-166-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFBE-166-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-26 07:33:36' WHERE kode_barang='F3E-ZFBE-166-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFBE-166-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-06-26 07:33:36','TOKO','PM-F','F3E','F3E-ZFBE-166-0','1','4.430','4.430','1','4.430','4.430','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-ZFBE-166-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFBE-166-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260626-0001','2026-06-26','07:33','8.190','admpindah','2026-06-26 07:33:36');
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-20260626-0001','1','H2I-ZABH-128-0','1','5.030','5.030','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-ZABH-128-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-ZABH-128-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-26 07:33:59' WHERE kode_barang='H2I-ZABH-128-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-ZABH-128-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-06-26 07:33:59','TOKO','PM-H','H2I','H2I-ZABH-128-0','1','5.030','5.030','1','5.030','5.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-ZABH-128-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-ZABH-128-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260626-0001','2026-06-26','07:33','5.030','admpindah','2026-06-26 07:33:58');
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-20260626-0001','1','D1G-ZFBE-160-0','1','0.470','0.470','TOKO','PMBK-P','TOKO','PM-P');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZFBE-160-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZFBE-160-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-P',tgl_last_beli='2026-06-26 07:34:17' WHERE kode_barang='D1G-ZFBE-160-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZFBE-160-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-06-26 07:34:17','TOKO','PM-P','D1G','D1G-ZFBE-160-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZFBE-160-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZFBE-160-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260626-0001','2026-06-26','07:34','0.470','admpindah','2026-06-26 07:34:16');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326260825031','input','1',' MEE1 X NW ','TOKO','PM-E','E1E-ZCAI-592-0','CC X BANGKOK SLEP NW 10 8K ','','0.510','1','100.00','538000','0','0','15000','538000','0','0','0','538000','LIS','00395990','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAI-592-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-06-26' AND kode_barang='E1E-ZCAI-592-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 ('F326260825031','2026-06-26','0.510','2026-06-26','08:25:03','PLG0029983','538000','538000','0','538000','538000','input','2026-06-26 08:25:03','F32626082503');
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-06-26','F326260825031','2026-06-26','08:25:03','LIS','538000','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-260626-0002','D','2026-06-26','08:25:03','input','PENJUALAN','F326260825031','5926247000','538000','5926785000');
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 ('F326261023281','input','1',' MEE1E HT 1','TOKO','PM-E','E1E-ZFAI-82-0','CC MODEL BANGKOK SLEP HT 14 8K ','','0.470','1','100.00','496000','0','0','15000','496000','0','0','0','496000','SIN','00409387','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E1E-ZFAI-82-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 ('F326261023281','2026-06-26','0.470','2026-06-26','10:23:29','PLG0029984','496000','496000','0','496000','496000','input','2026-06-26 10:23:28','F32626102328');
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-06-26','F326261023281','2026-06-26','10:23:29','SIN','496000','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-260626-0003','D','2026-06-26','10:23:29','input','PENJUALAN','F326261023281','5926785000','496000','5927281000');
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 ('F326261039221','input','1',' MEF1 HW 40','TOKO','PM-F','F1E-ZEBG-155-0','GL ANAK PIPA KACA SLEP DM 40 HW 8K ','','1.850','1','100.00','1952000','0','0','15000','1952000','0','0','0','1952000','FIT','00405153','F1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBG-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F1E-ZEBG-155-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 ('F326261039221','2026-06-26','1.850','2026-06-26','10:39:22','PLG0029985','1952000','1952000','0','1952000','1952000','input','2026-06-26 10:39:22','F32626103922');
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-06-26','F326261039221','2026-06-26','10:39:22','FIT','1952000','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-260626-0004','D','2026-06-26','10:39:22','input','PENJUALAN','F326261039221','5927281000','1952000','5929233000');
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 ('F326261047521','input','1',' MEE2E CM 1','TOKO','PM-E','E2E-ZECX-64-T','CC WEDDING MATA CM 12 8K ','','0.760','1','100.00','802000','0','0','15000','802000','0','0','0','802000','FIT','T0080130','E2E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E2E-ZECX-64-T' 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 ('F326261047521','2026-06-26','0.760','2026-06-26','10:47:52','PLG0029986','802000','802000','0','802000','802000','input','2026-06-26 10:47:52','F32626104752');
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-06-26','F326261047521','2026-06-26','10:47:52','FIT','802000','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-260626-0005','D','2026-06-26','10:47:52','input','PENJUALAN','F326261047521','5929233000','802000','5930035000');
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 ('F326261101411','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZEBE-206-0','KL X SIEM COBRA KH 44 9K ','','1.270','1','100.00','1467000','0','0','15000','1468000','0','0','0','1468000','SIN','00404905','H2J','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZEBE-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='H2J-ZEBE-206-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 ('F326261101411','2026-06-26','1.270','2026-06-26','11:01:42','PLG0029987','1468000','1468000','0','1468000','1468000','input','2026-06-26 11:01:41','F32626110141');
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-06-26','F326261101411','2026-06-26','11:01:42','SIN','1468000','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-260626-0006','D','2026-06-26','11:01:42','input','PENJUALAN','F326261101411','5930035000','1468000','5931503000');
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 ('F326261103141','input','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZCAI-467-0','CC X MODEL MATA CM 10 8K ','','0.680','1','100.00','717000','0','0','15000','717000','0','0','0','717000','FIT','00395865','E2E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAI-467-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E2E-ZCAI-467-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 ('F326261103141','2026-06-26','0.680','2026-06-26','11:03:14','PLG0029988','717000','717000','0','717000','717000','input','2026-06-26 11:03:14','F32626110314');
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-06-26','F326261103141','2026-06-26','11:03:14','FIT','717000','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-260626-0007','D','2026-06-26','11:03:14','input','PENJUALAN','F326261103141','5931503000','717000','5932220000');
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 ('F326261106211','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZDBG-123-0','GL X SANTA HATI VAR HW 8K ','','1.510','1','100.00','1593000','0','0','15000','1593000','0','0','0','1593000','LIS','00401366','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBG-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F3E-ZDBG-123-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 ('F326261106211','2026-06-26','1.510','2026-06-26','11:06:22','PLG0029989','1593000','1593000','0','1593000','1593000','input','2026-06-26 11:06:21','F32626110621');
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-06-26','F326261106211','2026-06-26','11:06:22','LIS','1593000','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-260626-0008','D','2026-06-26','11:06:22','input','PENJUALAN','F326261106211','5932220000','1593000','5933813000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261106211' 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 ('F326261106212','input',' 1',' MEF3E X UB','TOKO','PM-F','F3E-ZCAI-311-0','GL X LONG LING UB 8K ','','0.960','1','100.00','1013000','0','0','15000','1012000','0','0','0','1012000','LIS','00395709','F3E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAI-311-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-06-26' AND kode_barang='F3E-ZCAI-311-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 ('F326261106212','2026-06-26','0.960','2026-06-26','11:06:22','PLG0029990','1012000','1012000','0','1012000','1012000','input','2026-06-26 11:06:21','F32626110621');
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-06-26','F326261106212','2026-06-26','11:06:22','LIS','1012000','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-260626-0009','D','2026-06-26','11:06:22','input','PENJUALAN','F326261106212','5933813000','1012000','5934825000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1012000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261106212' 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 ('F326261115021','input','1',' MEF1 XX TD','TOKO','PM-F','F1E-ZCBX-91-0','GL XX OVAL C SLEP TD 60 8K ','','5.370','1','100.00','5665000','0','0','15000','5505000','0','0','0','5505000','FIT','00396293','F1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBX-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.370',berat_jual_asli=berat_jual_asli+'5.370',stock_jual='1',berat_akhir=berat_akhir-'5.370',berat_akhir_asli=berat_akhir_asli-'5.370',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F1E-ZCBX-91-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 ('F326261115021','2026-06-26','5.370','2026-06-26','11:15:02','PLG0029991','5505000','5505000','0','5505000','5505000','input','2026-06-26 11:15:02','F32626111502');
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-06-26','F326261115021','2026-06-26','11:15:02','FIT','5505000','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-260626-0010','D','2026-06-26','11:15:02','input','PENJUALAN','F326261115021','5934825000','5505000','5940330000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5505000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261115021' 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 ('F326261115022','input',' 1',' MEF1 XX TD','TOKO','PM-F','F1E-ZDAX-2-0','GL XX OVAL C SLEP TD 58 8K ','','5.420','1','100.00','5718000','0','0','15000','5555000','0','0','0','5555000','FIT','00398772','F1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAX-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.420',berat_jual_asli=berat_jual_asli+'5.420',stock_jual='1',berat_akhir=berat_akhir-'5.420',berat_akhir_asli=berat_akhir_asli-'5.420',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F1E-ZDAX-2-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 ('F326261115022','2026-06-26','5.420','2026-06-26','11:15:02','PLG0029992','5555000','5555000','0','5555000','5555000','input','2026-06-26 11:15:02','F32626111502');
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-06-26','F326261115022','2026-06-26','11:15:02','FIT','5555000','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-260626-0011','D','2026-06-26','11:15:02','input','PENJUALAN','F326261115022','5940330000','5555000','5945885000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261115022' 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 ('F326261116581','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZEXI-158-0','GL X TIFF SLEP VAR HW 8K ','','1.330','1','100.00','1403000','0','0','15000','1405000','0','0','0','1405000','AAT','00402979','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXI-158-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F3E-ZEXI-158-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 ('F326261116581','2026-06-26','1.330','2026-06-26','11:16:59','PLG0029993','1405000','1405000','0','1405000','1405000','input','2026-06-26 11:16:58','F32626111658');
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-06-26','F326261116581','2026-06-26','11:16:59','AAT','1405000','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-260626-0012','D','2026-06-26','11:16:59','input','PENJUALAN','F326261116581','5945885000','1405000','5947290000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261115021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261115021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261115021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261115022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261115022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261115022';
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 ('F326261121231','kasir','1',' MEF1 XX TD','TOKO','PM-F','F1E-ZCBX-91-0','GL XX OVAL C SLEP TD 60 8K ','','5.370','1','100.00','5665000','0','0','15000','5505000','0','0','0','5505000','FIT','00396293','F1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBX-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.370',berat_jual_asli=berat_jual_asli+'5.370',stock_jual='1',berat_akhir=berat_akhir-'5.370',berat_akhir_asli=berat_akhir_asli-'5.370',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F1E-ZCBX-91-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 ('F326261121231','2026-06-26','5.370','2026-06-26','11:21:24','PLG0029994','5505000','5505000','0','5505000','5505000','kasir','2026-06-26 11:21:23','F32626112123');
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-06-26','F326261121231','2026-06-26','11:21:24','FIT','5505000','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-260626-0015','D','2026-06-26','11:21:24','kasir','PENJUALAN','F326261121231','5936230000','5505000','5941735000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5505000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261121231' 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 ('F326261121232','kasir',' 1',' MEF1 XX TD','TOKO','PM-F','F1E-ZDAX-2-0','GL XX OVAL C SLEP TD 58 8K ','','5.420','1','100.00','5718000','0','0','15000','5555000','0','0','0','5555000','FIT','00398772','F1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAX-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.420',berat_jual_asli=berat_jual_asli+'5.420',stock_jual='1',berat_akhir=berat_akhir-'5.420',berat_akhir_asli=berat_akhir_asli-'5.420',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F1E-ZDAX-2-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 ('F326261121232','2026-06-26','5.420','2026-06-26','11:21:24','PLG0029995','5555000','5555000','0','5555000','5555000','kasir','2026-06-26 11:21:23','F32626112123');
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-06-26','F326261121232','2026-06-26','11:21:24','FIT','5555000','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-260626-0016','D','2026-06-26','11:21:24','kasir','PENJUALAN','F326261121232','5941735000','5555000','5947290000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261121232' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261121231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261121231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261121231';
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 ('F326261127091','kasir','1',' MEF1 XX TD','TOKO','PM-F','F1E-ZCBX-91-0','GL XX OVAL C SLEP TD 60 8K ','','5.370','1','100.00','5665000','0','0','15000','5505000','0','0','0','5505000','FIT','00396293','F1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBX-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.370',berat_jual_asli=berat_jual_asli+'5.370',stock_jual='1',berat_akhir=berat_akhir-'5.370',berat_akhir_asli=berat_akhir_asli-'5.370',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F1E-ZCBX-91-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 ('F326261127091','2026-06-26','5.370','2026-06-26','11:27:09','PLG0029996','5505000','5505000','0','5505000','5505000','kasir','2026-06-26 11:27:09','F32626112709');
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-06-26','F326261127091','2026-06-26','11:27:09','FIT','5505000','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-260626-0018','D','2026-06-26','11:27:09','kasir','PENJUALAN','F326261127091','5941785000','5505000','5947290000');
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 ('F326261128541','kasir','1',' MDB1D X LG','TOKO','PM-B','B1D-YGAX-18-0','GW X PANJANG MATA LG 8K ','','1.010','1','100.00','1045000','0','0','15000','1045000','0','0','0','1045000','LIS','00360412','B1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YGAX-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='B1D-YGAX-18-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 ('F326261128541','2026-06-26','1.010','2026-06-26','11:28:54','PLG0029997','1045000','1045000','0','1045000','1045000','kasir','2026-06-26 11:28:54','F32626112854');
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-06-26','F326261128541','2026-06-26','11:28:54','LIS','1045000','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-260626-0019','D','2026-06-26','11:28:54','kasir','PENJUALAN','F326261128541','5947290000','1045000','5948335000');
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 ('F326261132451','kasir','1',' MEE1E HT 1','TOKO','PM-E','E1D-ZFBE-151-0','CC MODEL SLEP HT 14 8K ','','0.820','1','100.00','857000','0','0','15000','865000','0','0','0','865000','SIN','00410429','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFBE-151-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E1D-ZFBE-151-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 ('F326261132451','2026-06-26','0.820','2026-06-26','11:32:46','PLG0029998','865000','865000','0','865000','865000','kasir','2026-06-26 11:32:45','F32626113245');
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-06-26','F326261132451','2026-06-26','11:32:46','SIN','865000','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-260626-0020','D','2026-06-26','11:32:46','kasir','PENJUALAN','F326261132451','5948335000','865000','5949200000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='865000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261132451' 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 ('F326261132452','kasir',' 1',' MEE1E HW 1','TOKO','PM-E','E1E-ZFBE-146-0','CC MODEL TINJU SLEP HW 13 8K ','','0.720','1','100.00','767000','0','0','15000','760000','0','0','0','760000','SIN','00410424','E1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-146-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-06-26' AND kode_barang='E1E-ZFBE-146-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 ('F326261132452','2026-06-26','0.720','2026-06-26','11:32:46','PLG0029999','760000','760000','0','760000','760000','kasir','2026-06-26 11:32:45','F32626113245');
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-06-26','F326261132452','2026-06-26','11:32:46','SIN','760000','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-260626-0021','D','2026-06-26','11:32:46','kasir','PENJUALAN','F326261132452','5949200000','760000','5949960000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='760000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261132452' 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 ('F326261141261','kasir','1',' MEE1 LG 14','TOKO','PM-E','E1E-ZFXE-135-0','CC MODEL ISYANA SLEP LG 14 8K ','','0.470','1','100.00','496000','0','0','15000','495000','0','0','0','495000','AAT','00407387','E1E','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXE-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E1E-ZFXE-135-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 ('F326261141261','2026-06-26','0.470','2026-06-26','11:41:27','PLG0030000','495000','495000','0','495000','495000','kasir','2026-06-26 11:41:26','F32626114126');
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-06-26','F326261141261','2026-06-26','11:41:27','AAT','495000','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-260626-0022','D','2026-06-26','11:41:27','kasir','PENJUALAN','F326261141261','5949960000','495000','5950455000');
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 ('F326261151151','kasir','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFBC-46-0','CC MODEL ISYANA SLEP LG 18 8K ','','0.630','1','100.00','665000','0','0','15000','665000','0','0','0','665000','SIN','00409920','E1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBC-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E1E-ZFBC-46-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 ('F326261151151','2026-06-26','0.630','2026-06-26','11:51:16','PLG0030001','665000','665000','0','665000','665000','kasir','2026-06-26 11:51:15','F32626115115');
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-06-26','F326261151151','2026-06-26','11:51:16','SIN','665000','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-260626-0023','D','2026-06-26','11:51:16','kasir','PENJUALAN','F326261151151','5950455000','665000','5951120000');
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 ('F326261153011','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZCXB-338-0','KL X GUCCI UB 44 9K ','','4.900','1','100.00','5659000','0','0','15000','5660000','0','0','0','5660000','LIS','00391761','H2J','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCXB-338-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='H2J-ZCXB-338-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 ('F326261153011','2026-06-26','4.900','2026-06-26','11:53:02','PLG0030002','5660000','5660000','0','5660000','5660000','kasir','2026-06-26 11:53:01','F32626115301');
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-06-26','F326261153011','2026-06-26','11:53:02','LIS','5660000','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-260626-0024','D','2026-06-26','11:53:02','kasir','PENJUALAN','F326261153011','5951120000','5660000','5956780000');
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-00019490','X-00019490','CC MODEL BUNGA MATA VAR CM 22 8K','GR','---','E2D','BELI','BELI001','1240000','2026-06-26','1.290','1','kasir','2026-06-26 12:09:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019490','X-00019490');
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-260626-0001','F326240924311','SIN','1','BELI','BELI001','E2D', 'X-00019490', 'CC MODEL BUNGA MATA VAR CM 22 8K','1.290','1.290','100.00','1388000','1240000','961240','1045000','1','1240000','1240000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.290',berat_beli_asli=berat_beli_asli+'1.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.290',berat_akhir_asli=berat_akhir_asli+'1.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-26' 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-260626-0001','2026-06-26','2026-06-26','12:09:37','SIN','---','1.290','1240000','1240000','1240000','1240000','1240000','kasir','2026-06-26 12:09:37','FB-260626-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260626-0001','DIAS','MIRICINDE PWT','','','','kasir','2026-06-26 12:09:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-26' 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-260626-0025','K','2026-06-26','12:09:37','kasir','PEMBELIAN UMUM','FB-260626-0001','5956780000','1240000','5955540000');
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-00019491','X-00019491','AT TINDIK BABY CM 8K','GR','---','A1G','BELI','BELI001','248000','2026-06-26','0.250','1','kasir','2026-06-26 12:09:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1G','X-00019491','X-00019491');
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-260626-0002','F326120925471','LIS','1','BELI','BELI001','A1G', 'X-00019491', 'AT TINDIK BABY CM 8K','0.250','0.250','100.00','293000','248000','992000','1105000','1','248000','248000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.250',berat_beli_asli=berat_beli_asli+'0.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.250',berat_akhir_asli=berat_akhir_asli+'0.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1G' 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-260626-0002','2026-06-26','2026-06-26','12:09:56','LIS','---','0.250','248000','248000','248000','248000','248000','kasir','2026-06-26 12:09:56','FB-260626-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260626-0002','DARYANTI','KEPUH PLOSO','','','','kasir','2026-06-26 12:09:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-26' 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-260626-0026','K','2026-06-26','12:09:56','kasir','PEMBELIAN UMUM','FB-260626-0002','5955540000','248000','5955292000');
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-00019492','X-00019492','CC PUTIH 8K','GR','---','PEG','BELI','BELI001','900000','2026-06-26','1.360','1','kasir','2026-06-26 12:11:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-PEG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PEG','X-00019492','X-00019492');
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-260626-0003','F323271119491','AAT','1','BELI','BELI001','PEG', 'X-00019492', 'CC PUTIH 8K','1.360','1.360','100.00','640000','900000','661765','1105000','1','900000','900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.360',berat_beli_asli=berat_beli_asli+'1.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.360',berat_akhir_asli=berat_akhir_asli+'1.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PEG' 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-260626-0003','2026-06-26','2026-06-26','12:11:10','AAT','---','1.360','900000','900000','900000','900000','900000','kasir','2026-06-26 12:11:11','FB-260626-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260626-0003','NIA FRANSISKA UTAMI','SLOGOHIMO','','','','kasir','2026-06-26 12:11:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-26' 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-260626-0027','K','2026-06-26','12:11:10','kasir','PEMBELIAN UMUM','FB-260626-0003','5955292000','900000','5954392000');
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-00019493','X-00019493','CC MODEL BUNGA VAR MJ 14 8K','GR','---','E1E','BELI','BELI001','645000','2026-06-26','0.660','1','kasir','2026-06-26 12:11:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019493','X-00019493');
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-260626-0004','F326300253461','AAT','1','BELI','BELI001','E1E', 'X-00019493', 'CC MODEL BUNGA VAR MJ 14 8K','0.660','0.660','100.00','733000','645000','977273','1065000','1','645000','645000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.660',berat_beli_asli=berat_beli_asli+'0.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.660',berat_akhir_asli=berat_akhir_asli+'0.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260626-0004','2026-06-26','2026-06-26','12:11:25','AAT','---','0.660','645000','645000','645000','645000','645000','kasir','2026-06-26 12:11:26','FB-260626-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260626-0004','ANI','GEDAWUNG KISMANTORO','','','','kasir','2026-06-26 12:11:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-26' 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-260626-0028','K','2026-06-26','12:11:25','kasir','PEMBELIAN UMUM','FB-260626-0004','5954392000','645000','5953747000');
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-00019494','X-00019494','KL NORY KH 42 8K','GR','---','H1E','BELI','BELI001','1230000','2026-06-26','1.600','1','kasir','2026-06-26 12:11:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019494','X-00019494');
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-260626-0005','F325300102331','SIN','1','BELI','BELI001','H1E', 'X-00019494', 'KL NORY KH 42 8K','1.600','1.600','100.00','1308000','1230000','768750','1065000','1','1230000','1230000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260626-0005','2026-06-26','2026-06-26','12:11:45','SIN','---','1.600','1230000','1230000','1230000','1230000','1230000','kasir','2026-06-26 12:11:46','FB-260626-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260626-0005','SRI SUSANTI','MIRI KISMANTORO','','','','kasir','2026-06-26 12:11:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-26' 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-260626-0029','K','2026-06-26','12:11:45','kasir','PEMBELIAN UMUM','FB-260626-0005','5953747000','1230000','5952517000');
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 ('F326261242301','kasir','1',' MEH1 KH 44','TOKO','PM-H','H1E-ZFXA-125-0','KL SIEM COBRA KH 44 8K ','','2.020','1','100.00','2131000','0','0','15000','2132000','0','0','0','2132000','FIT','00406293','H1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXA-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='H1E-ZFXA-125-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 ('F326261242301','2026-06-26','2.020','2026-06-26','12:42:31','PLG0030003','2132000','2132000','0','2132000','2132000','kasir','2026-06-26 12:42:30','F32626124230');
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-06-26','F326261242301','2026-06-26','12:42:31','FIT','2132000','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-260626-0030','D','2026-06-26','12:42:31','kasir','PENJUALAN','F326261242301','5952517000','2132000','5954649000');
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 ('F326260122181','kasir','1',' MDE1 X UB ','TOKO','PM-E','E1D-ZEBH-310-0','CC X MODEL SPECTRA UB 16 8K ','','1.060','1','100.00','1097000','0','0','15000','1098000','0','0','0','1098000','AAT','00405528','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-310-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-06-26' AND kode_barang='E1D-ZEBH-310-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 ('F326260122181','2026-06-26','1.060','2026-06-26','13:22:19','PLG0030004','1098000','1098000','0','1098000','1098000','kasir','2026-06-26 13:22:18','F32626012218');
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-06-26','F326260122181','2026-06-26','13:22:19','AAT','1098000','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-260626-0031','D','2026-06-26','13:22:19','kasir','PENJUALAN','F326260122181','5954649000','1098000','5955747000');
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 ('F326260205011','kasir','1',' MDE2 X YT ','TOKO','PM-E','E2D-YIAC-301-0','CC X MODEL MATA YT 11 8K ','','1.610','1','100.00','1666000','0','0','15000','1666000','0','0','0','1666000','SIN','00369385','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-301-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E2D-YIAC-301-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 ('F326260205011','2026-06-26','1.610','2026-06-26','14:05:02','PLG0030005','1666000','1666000','0','1666000','1666000','kasir','2026-06-26 14:05:01','F32626020501');
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-06-26','F326260205011','2026-06-26','14:05:02','SIN','1666000','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-260626-0032','D','2026-06-26','14:05:02','kasir','PENJUALAN','F326260205011','5955747000','1666000','5957413000');
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 ('F326260212241','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-YFXI-206-0','GL X FANCY SLEP VAR HW 8K ','','3.230','1','100.00','3408000','0','0','15000','3408000','0','0','0','3408000','LIS','00356951','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFXI-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='F3E-YFXI-206-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 ('F326260212241','2026-06-26','3.230','2026-06-26','14:12:25','PLG0030006','3408000','3408000','0','3408000','3408000','kasir','2026-06-26 14:12:24','F32626021224');
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-06-26','F326260212241','2026-06-26','14:12:25','LIS','3408000','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-260626-0033','D','2026-06-26','14:12:25','kasir','PENJUALAN','F326260212241','5957413000','3408000','5960821000');
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 ('F326260222571','input','1',' TEH1 X HW ','TOKO','PT-H','H1TE-ZEBA-19-T','KL X SANTA SLEP HW 42 17K ','','2.900','1','100.00','5597000','0','0','15000','5597000','0','0','0','5597000','AAT','T0079726','H1TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZEBA-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='H1TE-ZEBA-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326260222571','2026-06-26','2.900','2026-06-26','14:22:58','PLG0030007','5597000','5597000','0','5597000','5597000','input','2026-06-26 14:22:57','F32626022257');
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-06-26','F326260222571','2026-06-26','14:22:58','AAT','5597000','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-260626-0034','D','2026-06-26','14:22:58','input','PENJUALAN','F326260222571','5960821000','5597000','5966418000');
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 ('F326260223191','input','1',' TED2 X HK ','TOKO','PT-D','D2TE-XDAB-9-T','LT X MODEL MATA VAR HK 17K ','','0.550','1','100.00','1061000','0','0','15000','1063000','0','0','0','1063000','AAT','T0056279','D2TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TE-XDAB-9-T' 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-06-26' AND kode_barang='D2TE-XDAB-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326260223191','2026-06-26','0.550','2026-06-26','14:23:19','PLG0030008','1063000','1063000','0','1063000','1063000','input','2026-06-26 14:23:19','F32626022319');
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-06-26','F326260223191','2026-06-26','14:23:19','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) VALUES ('KM-260626-0035','D','2026-06-26','14:23:19','input','PENJUALAN','F326260223191','5966418000','1063000','5967481000');
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 ('F326260223391','input','1',' TAB0 X DW ','TOKO','PT-B','B0TA-WEXI-92-T','GW X MRICAN POLOS DW ','','0.500','1','100.00','920000','0','0','15000','920000','0','0','0','920000','AAT','T0044193','B0TA','0','0','-','0','1840000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0TA-WEXI-92-T' 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-06-26' AND kode_barang='B0TA-WEXI-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326260223391','2026-06-26','0.500','2026-06-26','14:23:39','PLG0030009','920000','920000','0','920000','920000','input','2026-06-26 14:23:39','F32626022339');
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-06-26','F326260223391','2026-06-26','14:23:39','AAT','920000','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-260626-0036','D','2026-06-26','14:23:39','input','PENJUALAN','F326260223391','5967481000','920000','5968401000');
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-00019495','X-00019495','CC X MODEL MATA LG 9 8K','GR','---','E2E','BELI','BELI001','502000','2026-06-26','0.540','1','kasir','2026-06-26 14:31:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019495','X-00019495');
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-260626-0006','F325080947061','AAT','1','BELI','BELI001','E2E', 'X-00019495', 'CC X MODEL MATA LG 9 8K','0.540','0.540','100.00','535000','502000','929630','1065000','1','502000','502000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.540',berat_beli_asli=berat_beli_asli+'0.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.540',berat_akhir_asli=berat_akhir_asli+'0.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-26' 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-260626-0006','2026-06-26','2026-06-26','14:31:14','AAT','---','0.540','502000','502000','502000','502000','502000','kasir','2026-06-26 14:31:15','FB-260626-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260626-0006','ENIK','JERUK','','','','kasir','2026-06-26 14:31:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-26' 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-260626-0037','K','2026-06-26','14:31:14','kasir','PEMBELIAN UMUM','FB-260626-0006','5968401000','502000','5967899000');
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 ('F326260304341','kasir','1',' MDE1D HW 1','TOKO','PM-E','E1D-ZFXE-206-0','CC MODEL SLEP HW 19 8K ','','1.030','1','100.00','1066000','0','0','15000','1065000','0','0','0','1065000','LIS','00407458','E1D','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-206-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-06-26' AND kode_barang='E1D-ZFXE-206-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 ('F326260304341','2026-06-26','1.030','2026-06-26','15:04:35','PLG0030010','1065000','1065000','0','1065000','1065000','kasir','2026-06-26 15:04:34','F32626030434');
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-06-26','F326260304341','2026-06-26','15:04:35','LIS','1065000','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-260626-0038','D','2026-06-26','15:04:35','kasir','PENJUALAN','F326260304341','5967899000','1065000','5968964000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260304341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260304341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260304341';
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 ('F326260311481','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCAI-447-0','CC X SOLITAIRE MATA AQUA CM 14 8K ','','1.540','1','100.00','1594000','0','0','15000','1595000','0','10000','0','1605000','LIS','00395845','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-06-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-447-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-06-26' AND kode_barang='E2D-ZCAI-447-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 ('F326260311481','2026-06-26','1.540','2026-06-26','15:11:48','PLG0030011','1595000','1595000','10000','1605000','1605000','kasir','2026-06-26 15:11:48','F32626031148');
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-06-26','F326260311481','2026-06-26','15:11:48','LIS','1605000','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-260626-0040','D','2026-06-26','15:11:48','kasir','PENJUALAN','F326260311481','5967899000','1605000','5969504000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260626-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260626-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260626-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260626-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260626-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260626-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260626-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260626-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260626-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260626-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260626-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260626-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260122181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260122181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260122181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260205011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260205011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260205011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260212241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260212241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260212241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260222571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260222571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260222571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260223191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260223191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260223191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260223391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260223391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260223391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260311481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260311481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260311481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260825031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260825031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260825031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261023281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261023281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261023281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261039221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261039221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261039221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261047521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261047521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261047521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261101411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261101411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261101411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261103141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261103141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261103141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261106211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261106211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261106211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261106212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261106212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261106212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261116581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261116581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261116581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261121232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261121232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261121232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261127091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261127091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261127091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261128541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261128541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261128541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261132451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261132452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261132452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261141261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261141261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261141261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261151151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261151151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261151151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261153011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261153011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261153011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261242301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261242301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261242301';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-26';
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-06-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-26' 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-260627-0001','D','2026-06-27','15:32:08','SYSTEM','SALDO AWAL','SALDO AWAL','0','5969504000','5969504000');
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-260627-0001','D','2026-06-27','15:32:08','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
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-260627-0001','D','2026-06-27','15:32:08','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-260627-0001','D','2026-06-27','15:32:08','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-27';