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-20260721-0001','1','B1F-ZFCX-146-0','1','0.400','0.400','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1F-ZFCX-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-ZFCX-146-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-07-21 07:57:43' WHERE kode_barang='B1F-ZFCX-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-ZFCX-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-07-21 07:57:43','TOKO','PM-B','B1F','B1F-ZFCX-146-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' 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='B1F-ZFCX-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1F-ZFCX-146-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260721-0001','2026-07-21','07:57','0.400','admpindah','2026-07-21 07:57:43');
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-20260721-0001','1','D1F-ZFXA-47-0','1','0.410','0.410','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZFXA-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZFXA-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-07-21 07:58:01' WHERE kode_barang='D1F-ZFXA-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZFXA-47-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-07-21 07:58:01','TOKO','PM-D','D1F','D1F-ZFXA-47-0','1','0.410','0.410','1','0.410','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' 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='D1F-ZFXA-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZFXA-47-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260721-0001','2026-07-21','07:57','0.410','admpindah','2026-07-21 07:58:00');
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-20260721-0001','1','E1D-ZFBB-133-0','1','1.050','1.050','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFBB-133-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFBB-133-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1D-ZFBB-133-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFBB-133-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-07-21 07:58:18','TOKO','PM-E','E1D','E1D-ZFBB-133-0','1','1.050','1.050','1','1.050','1.050','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-133-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFBB-133-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-20260721-0001','1','E1E-ZGAG-104-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGAG-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGAG-104-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1E-ZGAG-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGAG-104-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-07-21 07:58:18','TOKO','PM-E','E1E','E1E-ZGAG-104-0','1','0.460','0.460','1','0.460','0.460','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-ZGAG-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGAG-104-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-20260721-0001','1','E1F-ZGBX-179-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBX-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1F-ZGBX-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBX-179-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-07-21 07:58:18','TOKO','PM-E','E1F','E1F-ZGBX-179-0','1','0.370','0.370','1','0.370','0.370','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-ZGBX-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-179-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-20260721-0001','1','E1F-ZGBX-180-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBX-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1F-ZGBX-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBX-180-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-07-21 07:58:18','TOKO','PM-E','E1F','E1F-ZGBX-180-0','1','0.360','0.360','1','0.360','0.360','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-ZGBX-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-180-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-20260721-0001','1','E1F-ZGBX-181-0','1','0.310','0.310','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBX-181-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-181-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1F-ZGBX-181-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBX-181-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-07-21 07:58:18','TOKO','PM-E','E1F','E1F-ZGBX-181-0','1','0.310','0.310','1','0.310','0.310','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-ZGBX-181-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-181-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-20260721-0001','1','E1F-ZGBX-182-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBX-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1F-ZGBX-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBX-182-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-07-21 07:58:18','TOKO','PM-E','E1F','E1F-ZGBX-182-0','1','0.350','0.350','1','0.350','0.350','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-ZGBX-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-182-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-20260721-0001','1','E1F-ZGBX-183-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBX-183-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-183-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E1F-ZGBX-183-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBX-183-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-07-21 07:58:18','TOKO','PM-E','E1F','E1F-ZGBX-183-0','1','0.350','0.350','1','0.350','0.350','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-ZGBX-183-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBX-183-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-20260721-0001','1','E2F-ZGBX-184-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZGBX-184-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-184-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:18' WHERE kode_barang='E2F-ZGBX-184-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZGBX-184-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-07-21 07:58:18','TOKO','PM-E','E2F','E2F-ZGBX-184-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' 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='E2F-ZGBX-184-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-184-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-20260721-0001','1','E2F-ZGBX-185-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZGBX-185-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-185-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:19' WHERE kode_barang='E2F-ZGBX-185-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZGBX-185-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-07-21 07:58:19','TOKO','PM-E','E2F','E2F-ZGBX-185-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' 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='E2F-ZGBX-185-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-185-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-20260721-0001','1','E2F-ZGBX-186-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZGBX-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:19' WHERE kode_barang='E2F-ZGBX-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZGBX-186-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-07-21 07:58:19','TOKO','PM-E','E2F','E2F-ZGBX-186-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' 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='E2F-ZGBX-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-186-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-20260721-0001','1','E2F-ZGBX-187-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZGBX-187-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-187-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-21 07:58:19' WHERE kode_barang='E2F-ZGBX-187-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZGBX-187-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-07-21 07:58:19','TOKO','PM-E','E2F','E2F-ZGBX-187-0','1','0.410','0.410','1','0.410','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' 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='E2F-ZGBX-187-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZGBX-187-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260721-0001','2026-07-21','07:58','4.860','admpindah','2026-07-21 07:58:19');
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-20260721-0001','1','F3E-ZGBX-188-0','1','1.750','1.750','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBX-188-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-188-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-21 07:58:49' WHERE kode_barang='F3E-ZGBX-188-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBX-188-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-07-21 07:58:49','TOKO','PM-F','F3E','F3E-ZGBX-188-0','1','1.750','1.750','1','1.750','1.750','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-ZGBX-188-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-188-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-20260721-0001','1','F3E-ZGBX-189-0','1','0.930','0.930','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBX-189-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-189-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-21 07:58:49' WHERE kode_barang='F3E-ZGBX-189-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBX-189-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-07-21 07:58:49','TOKO','PM-F','F3E','F3E-ZGBX-189-0','1','0.930','0.930','1','0.930','0.930','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-ZGBX-189-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-189-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-20260721-0001','1','F3E-ZGBX-190-0','1','0.930','0.930','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBX-190-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-190-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-21 07:58:49' WHERE kode_barang='F3E-ZGBX-190-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBX-190-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-07-21 07:58:49','TOKO','PM-F','F3E','F3E-ZGBX-190-0','1','0.930','0.930','1','0.930','0.930','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-ZGBX-190-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-190-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-20260721-0001','1','F3E-ZGBX-191-0','1','1.390','1.390','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBX-191-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-191-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-21 07:58:49' WHERE kode_barang='F3E-ZGBX-191-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBX-191-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-07-21 07:58:49','TOKO','PM-F','F3E','F3E-ZGBX-191-0','1','1.390','1.390','1','1.390','1.390','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-ZGBX-191-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBX-191-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-20260721-0001','1','F2E-ZGBX-192-0','1','2.320','2.320','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZGBX-192-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZGBX-192-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-21 07:58:49' WHERE kode_barang='F2E-ZGBX-192-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZGBX-192-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-07-21 07:58:49','TOKO','PM-F','F2E','F2E-ZGBX-192-0','1','2.320','2.320','1','2.320','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZGBX-192-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZGBX-192-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-20260721-0001','1','F2E-ZGBX-193-0','1','2.090','2.090','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZGBX-193-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZGBX-193-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-21 07:58:49' WHERE kode_barang='F2E-ZGBX-193-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZGBX-193-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-07-21 07:58:49','TOKO','PM-F','F2E','F2E-ZGBX-193-0','1','2.090','2.090','1','2.090','2.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZGBX-193-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZGBX-193-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260721-0001','2026-07-21','07:58','9.410','admpindah','2026-07-21 07:58:49');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260721-0001','1','H2I-ZGXC-61-0','1','4.980','4.980','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2I-ZGXC-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-ZGXC-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-21 07:59:11' WHERE kode_barang='H2I-ZGXC-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-ZGXC-61-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-07-21 07:59:11','TOKO','PM-H','H2I','H2I-ZGXC-61-0','1','4.980','4.980','1','4.980','4.980','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-ZGXC-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2I-ZGXC-61-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-20260721-0001','1','H1E-ZGXI-134-0','1','5.050','5.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGXI-134-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGXI-134-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-21 07:59:11' WHERE kode_barang='H1E-ZGXI-134-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGXI-134-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-07-21 07:59:11','TOKO','PM-H','H1E','H1E-ZGXI-134-0','1','5.050','5.050','1','5.050','5.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZGXI-134-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGXI-134-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-20260721-0001','1','H1E-ZGAC-54-0','1','2.060','2.060','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGAC-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGAC-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-21 07:59:11' WHERE kode_barang='H1E-ZGAC-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGAC-54-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-07-21 07:59:11','TOKO','PM-H','H1E','H1E-ZGAC-54-0','1','2.060','2.060','1','2.060','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZGAC-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAC-54-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-20260721-0001','1','H1E-ZGAG-189-0','1','2.170','2.170','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGAG-189-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGAG-189-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-21 07:59:11' WHERE kode_barang='H1E-ZGAG-189-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGAG-189-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-07-21 07:59:11','TOKO','PM-H','H1E','H1E-ZGAG-189-0','1','2.170','2.170','1','2.170','2.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZGAG-189-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAG-189-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-20260721-0001','1','H1E-ZGAG-198-0','1','1.050','1.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGAG-198-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGAG-198-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-21 07:59:11' WHERE kode_barang='H1E-ZGAG-198-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGAG-198-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-07-21 07:59:11','TOKO','PM-H','H1E','H1E-ZGAG-198-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZGAG-198-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAG-198-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260721-0001','2026-07-21','07:59','15.310','admpindah','2026-07-21 07:59:10');
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 ('F326210955301','input','1',' MGD1G LG ','TOKO','PM-D','D1G-ZEAH-110-0','LT SLOBOK KUPU SLEP LG 8K ','','0.290','1','100.00','312000','0','0','15000','313000','0','0','0','313000','SIN','00404016','D1G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEAH-110-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.290',berat_jual_asli=berat_jual_asli+'0.290',stock_jual='1',berat_akhir=berat_akhir-'0.290',berat_akhir_asli=berat_akhir_asli-'0.290',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='D1G-ZEAH-110-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210955301','2026-07-21','0.290','2026-07-21','09:55:31','PLG0030416','313000','313000','0','313000','313000','input','2026-07-21 09:55:30','F32621095530');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326210955301','2026-07-21','09:55:31','SIN','313000','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-260721-0002','D','2026-07-21','09:55:31','input','PENJUALAN','F326210955301','6417013000','313000','6417326000');
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 ('F326211059081','input','1',' MFE2 KH 10','TOKO','PM-E','E2F-ZGBX-184-0','CC MODEL PAKU MATA KH 10 8K ','OLW','0.400','1','100.00','426000','0','0','15000','428000','0','5000','0','433000','SIN','00414385','E2F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZGBX-184-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='E2F-ZGBX-184-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 ('F326211059081','2026-07-21','0.400','2026-07-21','10:59:09','PLG0030417','428000','428000','5000','433000','433000','input','2026-07-21 10:59:08','F32621105908');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211059081','2026-07-21','10:59:09','SIN','433000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260721-0003','D','2026-07-21','10:59:09','input','PENJUALAN','F326211059081','6417326000','433000','6417759000');
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 ('F326211114261','kasir','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFBC-53-0','CC MODEL ISYANA SLEP LG 16 8K ','','0.410','1','100.00','424000','0','0','15000','425000','0','0','0','425000','FIT','00409927','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBC-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='E1E-ZFBC-53-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 ('F326211114261','2026-07-21','0.410','2026-07-21','11:14:26','PLG0030418','425000','425000','0','425000','425000','kasir','2026-07-21 11:14:26','F32621111426');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211114261','2026-07-21','11:14:26','FIT','425000','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-260721-0004','D','2026-07-21','11:14:26','kasir','PENJUALAN','F326211114261','6417759000','425000','6418184000');
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-00019693','X-00019693','CC COR M 8K','GR','---','E2D','BELI','BELI001','848000','2026-07-21','0.900','1','kasir','2026-07-21 11:15:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019693','X-00019693');
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-260721-0001','00388021','FIT','1','BELI','BELI001','E2D', 'X-00019693', 'CC COR M 8K','0.900','0.900','100.00','1111000','848000','942222','1025000','1','848000','848000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' 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-260721-0001','2026-07-21','2026-07-21','11:15:41','FIT','---','0.900','848000','848000','848000','848000','848000','kasir','2026-07-21 11:15:41','FB-260721-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0001','NOVI','JATIPURWO WONOGIRI','','','','kasir','2026-07-21 11:15:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0005','K','2026-07-21','11:15:41','kasir','PEMBELIAN UMUM','FB-260721-0001','6418184000','848000','6417336000');
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-00019694','X-00019694','GL X TIFF BONEKA ANAK CAT UB 8K','GR','---','F3E','BELI','BELI001','1700000','2026-07-21','1.950','1','kasir','2026-07-21 11:16:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019694','X-00019694');
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-260721-0002','F326121217331','FIT','1','BELI','BELI001','F3E', 'X-00019694', 'GL X TIFF BONEKA ANAK CAT UB 8K','1.950','1.950','100.00','2155000','1700000','871795','1045000','1','1700000','1700000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260721-0002','2026-07-21','2026-07-21','11:16:46','FIT','---','1.950','1700000','1700000','1700000','1700000','1700000','kasir','2026-07-21 11:16:47','FB-260721-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0002','AULIA','SIDOWAYAH','','','','kasir','2026-07-21 11:16:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0006','K','2026-07-21','11:16:46','kasir','PEMBELIAN UMUM','FB-260721-0002','6417336000','1700000','6415636000');
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-00019695','X-00019695','GL XXX FLIK ARESO VAR HW 8K','GR','---','F3E','BELI','BELI001','2380000','2026-07-21','2.420','1','kasir','2026-07-21 11:23:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019695','X-00019695');
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-260721-0003','F326121018271','FIT','1','BELI','BELI001','F3E', 'X-00019695', 'GL XXX FLIK ARESO VAR HW 8K','2.420','2.420','100.00','2868000','2380000','983471','1045000','1','2380000','2380000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.420',berat_beli_asli=berat_beli_asli+'2.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.420',berat_akhir_asli=berat_akhir_asli+'2.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260721-0003','2026-07-21','2026-07-21','11:23:05','FIT','---','2.420','2380000','2380000','2380000','2380000','2380000','kasir','2026-07-21 11:23:06','FB-260721-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0003','FATMA','TEMON SAMPUNG','','','','kasir','2026-07-21 11:23:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0007','K','2026-07-21','11:23:05','kasir','PEMBELIAN UMUM','FB-260721-0003','6415636000','2380000','6413256000');
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-00019696','X-00019696','KL X NORI UB 44 8K','GR','---','H1E','BELI','BELI001','1390000','2026-07-21','1.430','1','kasir','2026-07-21 11:23:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019696','X-00019696');
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-260721-0004','F326081101411','FIT','1','BELI','BELI001','H1E', 'X-00019696', 'KL X NORI UB 44 8K','1.430','1.430','100.00','1745000','1390000','972028','1045000','1','1390000','1390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.430',berat_beli_asli=berat_beli_asli+'1.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.430',berat_akhir_asli=berat_akhir_asli+'1.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' 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-260721-0004','2026-07-21','2026-07-21','11:23:30','FIT','---','1.430','1390000','1390000','1390000','1390000','1390000','kasir','2026-07-21 11:23:30','FB-260721-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0004','ALSYA','LEMAHBANG KISMANTORO','','','','kasir','2026-07-21 11:23:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0008','K','2026-07-21','11:23:30','kasir','PEMBELIAN UMUM','FB-260721-0004','6413256000','1390000','6411866000');
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-00019697','X-00019697','KL X SANTA KH 44 9K','GR','---','H2I','BELI','BELI001','4845000','2026-07-21','5.920','1','kasir','2026-07-21 11:24:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00019697','X-00019697');
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-260721-0005','F324041043551','SIN','1','BELI','BELI001','H2I', 'X-00019697', 'KL X SANTA KH 44 9K','5.980','5.920','100.00','3815000','4845000','818412','1125000','1','4845000','4845000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.920',berat_beli_asli=berat_beli_asli+'5.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.920',berat_akhir_asli=berat_akhir_asli+'5.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-260721-0005','2026-07-21','2026-07-21','11:24:29','SIN','---','5.920','4845000','4845000','4845000','4845000','4845000','kasir','2026-07-21 11:24:30','FB-260721-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0005','LIA','CONTO','','','081511132838','kasir','2026-07-21 11:24:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0009','K','2026-07-21','11:24:29','kasir','PEMBELIAN UMUM','FB-260721-0005','6411866000','4845000','6407021000');
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-00019698','X-00019698','LT Q10 MODEL MATA CAT VAR UB','GR','---','D2E','BELI','BELI001','680000','2026-07-21','1.060','1','kasir','2026-07-21 11:24:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00019698','X-00019698');
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-260721-0006','F324041043553','SIN','2','BELI','BELI001','D2E', 'X-00019698', 'LT Q10 MODEL MATA CAT VAR UB','1.060','1.060','100.00','635000','680000','641509','1045000','1','680000','680000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260721-0006','2026-07-21','2026-07-21','11:24:29','SIN','---','1.060','680000','680000','680000','680000','680000','kasir','2026-07-21 11:24:30','FB-260721-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0006','LIA','CONTO','','','081511132838','kasir','2026-07-21 11:24:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0010','K','2026-07-21','11:24:29','kasir','PEMBELIAN UMUM','FB-260721-0006','6407021000','680000','6406341000');
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-00019699','X-00019699','GL COR T 8K','GR','---','F1F','BELI','BELI001','2452000','2026-07-21','3.400','1','kasir','2026-07-21 11:25:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1F','X-00019699','X-00019699');
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-260721-0007','F323050758161','AAT','1','BELI','BELI001','F1F', 'X-00019699', 'GL COR T 8K','3.400','3.400','100.00','1548000','2452000','721176','1065000','1','2452000','2452000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.400',berat_beli_asli=berat_beli_asli+'3.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.400',berat_akhir_asli=berat_akhir_asli+'3.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1F' 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-260721-0007','2026-07-21','2026-07-21','11:25:24','AAT','---','3.400','2452000','2452000','2452000','2452000','2452000','kasir','2026-07-21 11:25:25','FB-260721-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0007','LINDYA','NAWANGAN PACITAN','','','','kasir','2026-07-21 11:25:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0011','K','2026-07-21','11:25:24','kasir','PEMBELIAN UMUM','FB-260721-0007','6406341000','2452000','6403889000');
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-00019700','X-00019700','CC X MODEL MATA LG 16 8K','GR','---','E2D','BELI','BELI001','910000','2026-07-21','1.010','1','kasir','2026-07-21 11:26:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019700','X-00019700');
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-260721-0008','F325021005061','SIN','1','BELI','BELI001','E2D', 'X-00019700', 'CC X MODEL MATA LG 16 8K','1.010','1.010','100.00','980000','910000','900990','1025000','1','910000','910000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' 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-260721-0008','2026-07-21','2026-07-21','11:26:03','SIN','---','1.010','910000','910000','910000','910000','910000','kasir','2026-07-21 11:26:03','FB-260721-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0008','BOIMEN','BITING','','','','kasir','2026-07-21 11:26:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0012','K','2026-07-21','11:26:03','kasir','PEMBELIAN UMUM','FB-260721-0008','6403889000','910000','6402979000');
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-00019701','X-00019701','CC WEDDING MATA CM 22 8K','GR','---','E2D','BELI','BELI001','858000','2026-07-21','0.910','1','kasir','2026-07-21 11:26:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019701','X-00019701');
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-260721-0009','F326151034061','SIN','1','BELI','BELI001','E2D', 'X-00019701', 'CC WEDDING MATA CM 22 8K','0.910','0.910','100.00','1000000','858000','942857','1025000','1','858000','858000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.910',berat_beli_asli=berat_beli_asli+'0.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.910',berat_akhir_asli=berat_akhir_asli+'0.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' 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-260721-0009','2026-07-21','2026-07-21','11:26:39','SIN','---','0.910','858000','858000','858000','858000','858000','kasir','2026-07-21 11:26:40','FB-260721-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0009','DWI','SAYUTAN PARANG MAGETAN','','','082220580790','kasir','2026-07-21 11:26:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0013','K','2026-07-21','11:26:39','kasir','PEMBELIAN UMUM','FB-260721-0009','6402979000','858000','6402121000');
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-00019702','X-00019702','GW X DAISY MATA LG PE 8K','GR','---','B1D','BELI','BELI001','972000','2026-07-21','1.020','1','kasir','2026-07-21 11:29:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1D','X-00019702','X-00019702');
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-260721-0010','F326011246181','AAT','1','BELI','BELI001','B1D', 'X-00019702', 'GW X DAISY MATA LG PE 8K','1.020','1.020','100.00','1158000','972000','952941','1025000','1','972000','972000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1D' 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-260721-0010','2026-07-21','2026-07-21','11:29:25','AAT','---','1.020','972000','972000','972000','972000','972000','kasir','2026-07-21 11:29:26','FB-260721-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0010','AYU','PURWANTORO','','','','kasir','2026-07-21 11:29:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0014','K','2026-07-21','11:29:25','kasir','PEMBELIAN UMUM','FB-260721-0010','6402121000','972000','6401149000');
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-00019703','X-00019703','CC X MODEL UNTIR SLEP AY 11','GR','---','E1TF','BELI','BELI001','1165000','2026-07-21','0.650','1','kasir','2026-07-21 11:49:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TF','X-00019703','X-00019703');
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-260721-0011','F326221231331','SIN','1','BELI','BELI001','E1TF', 'X-00019703', 'CC X MODEL UNTIR SLEP AY 11','0.650','0.650','100.00','1370000','1165000','1792308','1920000','1','1165000','1165000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TF' 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-260721-0011','2026-07-21','2026-07-21','11:49:48','SIN','---','0.650','1165000','1165000','1165000','1165000','1165000','kasir','2026-07-21 11:49:49','FB-260721-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0011','SITI','SUMBER PWO','','','','kasir','2026-07-21 11:49:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0015','K','2026-07-21','11:49:48','kasir','PEMBELIAN UMUM','FB-260721-0011','6401149000','1165000','6399984000');
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-00019704','X-00019704','KL X SIEM COBRA KH 44 9K','GR','---','H2J','BELI','BELI001','1255000','2026-07-21','1.260','1','kasir','2026-07-21 12:06:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00019704','X-00019704');
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-260721-0012','F325010113422','AAT','1','BELI','BELI001','H2J', 'X-00019704', 'KL X SIEM COBRA KH 44 9K','1.260','1.260','100.00','1350000','1255000','996032','1135000','1','1255000','1255000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-260721-0012','2026-07-21','2026-07-21','12:06:08','AAT','---','1.260','1255000','1255000','1255000','1255000','1255000','kasir','2026-07-21 12:06:09','FB-260721-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0012','LIDA','TEGALREJO PURWANTORO','','','','kasir','2026-07-21 12:06:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0016','K','2026-07-21','12:06:08','kasir','PEMBELIAN UMUM','FB-260721-0012','6399984000','1255000','6398729000');
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 ('F326211235101','kasir','1',' MEF1E UB 5','TOKO','PM-F','F1E-ZGAA-70-0','GL OVAL C SLEP UB 54 8K ','','2.230','1','100.00','2308000','0','0','15000','2310000','0','0','0','2310000','FIT','00413249','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAA-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='F1E-ZGAA-70-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 ('F326211235101','2026-07-21','2.230','2026-07-21','12:35:10','PLG0030419','2310000','2310000','0','2310000','2310000','kasir','2026-07-21 12:35:10','F32621123510');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211235101','2026-07-21','12:35:10','FIT','2310000','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-260721-0017','D','2026-07-21','12:35:10','kasir','PENJUALAN','F326211235101','6398729000','2310000','6401039000');
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 ('F326211236321','kasir','1',' MEF1E UB 5','TOKO','PM-F','F1E-ZGAA-71-0','GL OVAL C SLEP UB 56 8K ','','2.240','1','100.00','2318000','0','0','15000','2320000','0','0','0','2320000','FIT','00413250','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAA-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='F1E-ZGAA-71-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 ('F326211236321','2026-07-21','2.240','2026-07-21','12:36:33','PLG0030420','2320000','2320000','0','2320000','2320000','kasir','2026-07-21 12:36:32','F32621123632');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211236321','2026-07-21','12:36:33','FIT','2320000','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-260721-0018','D','2026-07-21','12:36:33','kasir','PENJUALAN','F326211236321','6401039000','2320000','6403359000');
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 ('F326211242581','kasir','1',' MFE1 KH 18','TOKO','PM-E','E1F-ZGBX-179-0','CC MODEL SPECTRA SLEP KH 18 8K ','OLW','0.370','1','100.00','394000','0','0','15000','395000','0','5000','0','400000','SIN','00414380','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBX-179-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='E1F-ZGBX-179-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 ('F326211242581','2026-07-21','0.370','2026-07-21','12:42:58','PLG0030421','395000','395000','5000','400000','400000','kasir','2026-07-21 12:42:58','F32621124258');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211242581','2026-07-21','12:42:58','SIN','400000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260721-0019','D','2026-07-21','12:42:58','kasir','PENJUALAN','F326211242581','6403359000','400000','6403759000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211242581' 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 ('F326211242582','kasir',' 1',' MEE2 X 5K ','TOKO','PM-E','E2E-ZCBD-130-0','CC X BONEKA NAK CAT MATA LG 8K ','OLW','0.470','1','100.00','486000','0','0','15000','493000','0','5000','0','498000','SIN','00396610','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCBD-130-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-07-21' AND kode_barang='E2E-ZCBD-130-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 ('F326211242582','2026-07-21','0.470','2026-07-21','12:42:58','PLG0030422','493000','493000','5000','498000','498000','kasir','2026-07-21 12:42:58','F32621124258');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211242582','2026-07-21','12:42:58','SIN','498000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260721-0020','D','2026-07-21','12:42:58','kasir','PENJUALAN','F326211242582','6403759000','498000','6404257000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='498000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211242582' 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 ('F326211259141','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZCCX-294-0','GL X HARLEY DOBEL SLEP HW 8K ','','5.070','1','100.00','5247000','0','0','15000','5248000','0','0','0','5248000','FIT','00396948','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCCX-294-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.070',berat_jual_asli=berat_jual_asli+'5.070',stock_jual='1',berat_akhir=berat_akhir-'5.070',berat_akhir_asli=berat_akhir_asli-'5.070',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='F3E-ZCCX-294-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 ('F326211259141','2026-07-21','5.070','2026-07-21','12:59:15','PLG0030423','5248000','5248000','0','5248000','5248000','kasir','2026-07-21 12:59:14','F32621125914');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326211259141','2026-07-21','12:59:15','FIT','5248000','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-260721-0021','D','2026-07-21','12:59:15','kasir','PENJUALAN','F326211259141','6404257000','5248000','6409505000');
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 ('F326210107161','kasir','1',' MFE2 KH 12','TOKO','PM-E','E2F-ZGBX-185-0','CC MODEL PAKU MATA KH 12 8K ','','0.400','1','100.00','426000','0','0','15000','423000','0','0','0','423000','SIN','00414386','E2F','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZGBX-185-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='E2F-ZGBX-185-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 ('F326210107161','2026-07-21','0.400','2026-07-21','13:07:16','PLG0030424','423000','423000','0','423000','423000','kasir','2026-07-21 13:07:16','F32621010716');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326210107161','2026-07-21','13:07:16','SIN','423000','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-260721-0022','D','2026-07-21','13:07:16','kasir','PENJUALAN','F326210107161','6409505000','423000','6409928000');
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 ('F326210147261','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZDAX-152-0','GL X TIFF ANAK CAT VAR YT 8K ','','2.220','1','100.00','2298000','0','0','15000','2298000','0','0','0','2298000','SIN','00398922','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAX-152-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='F3E-ZDAX-152-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 ('F326210147261','2026-07-21','2.220','2026-07-21','13:47:26','PLG0030425','2298000','2298000','0','2298000','2298000','kasir','2026-07-21 13:47:26','F32621014726');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326210147261','2026-07-21','13:47:26','SIN','2298000','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-260721-0023','D','2026-07-21','13:47:26','kasir','PENJUALAN','F326210147261','6409928000','2298000','6412226000');
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-00019705','X-00019705','KL KADAR 8K','GR','---','H1E','BELI','BELI001','1087000','2026-07-21','1.540','1','kasir','2026-07-21 14:24:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019705','X-00019705');
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-260721-0013','F323291010082','AAT','1','BELI','BELI001','H1E', 'X-00019705', 'KL KADAR 8K','1.540','1.540','100.00','713000','1087000','705844','1045000','1','1087000','1087000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.540',berat_beli_asli=berat_beli_asli+'1.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.540',berat_akhir_asli=berat_akhir_asli+'1.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' 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-260721-0013','2026-07-21','2026-07-21','14:24:29','AAT','---','1.540','1087000','1087000','1087000','1087000','1087000','kasir','2026-07-21 14:24:29','FB-260721-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0013','ENITA','BULUKERTO','','','','kasir','2026-07-21 14:24:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0024','K','2026-07-21','14:24:29','kasir','PEMBELIAN UMUM','FB-260721-0013','6412226000','1087000','6411139000');
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-00019706','X-00019706','LT COR T 8K','GR','---','D1F','BELI','BELI001','340000','2026-07-21','0.510','1','kasir','2026-07-21 14:24:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00019706','X-00019706');
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-260721-0014','F323291010083','AAT','2','BELI','BELI001','D1F', 'X-00019706', 'LT COR T 8K','0.510','0.510','100.00','242000','340000','666667','1065000','1','340000','340000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260721-0014','2026-07-21','2026-07-21','14:24:29','AAT','---','0.510','340000','340000','340000','340000','340000','kasir','2026-07-21 14:24:29','FB-260721-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260721-0014','ENITA','BULUKERTO','','','','kasir','2026-07-21 14:24:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-21' 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-260721-0025','K','2026-07-21','14:24:29','kasir','PEMBELIAN UMUM','FB-260721-0014','6411139000','340000','6410799000');
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 ('F326210237271','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZFCX-233-0','KL X NORY KH 44 8K ','','3.060','1','100.00','3167000','0','0','15000','3167000','0','0','0','3167000','FIT','00411440','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFCX-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='H1E-ZFCX-233-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 ('F326210237271','2026-07-21','3.060','2026-07-21','14:37:27','PLG0030426','3167000','3167000','0','3167000','3167000','input','2026-07-21 14:37:27','F32621023727');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326210237271','2026-07-21','14:37:27','FIT','3167000','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-260721-0026','D','2026-07-21','14:37:27','input','PENJUALAN','F326210237271','6410799000','3167000','6413966000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3167000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326210237271' 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 ('F326210237272','input',' 1',' MED2E X CM','TOKO','PM-D','D2E-ZBAD-130-0','LT X MODEL MATA CM 8K ','','0.540','1','100.00','559000','0','0','15000','561000','0','0','0','561000','FIT','00389736','D2E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBAD-130-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2026-07-21' AND kode_barang='D2E-ZBAD-130-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210237272','2026-07-21','0.540','2026-07-21','14:37:27','PLG0030427','561000','561000','0','561000','561000','input','2026-07-21 14:37:27','F32621023727');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-21','F326210237272','2026-07-21','14:37:27','FIT','561000','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-260721-0027','D','2026-07-21','14:37:27','input','PENJUALAN','F326210237272','6413966000','561000','6414527000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='561000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326210237272' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260721-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260721-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210107161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210107161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210107161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210147261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210147261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210147261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210237271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210237271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210237271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210237272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210237272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210237272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210955301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210955301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210955301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211059081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211059081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211059081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211114261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211114261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211114261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211235101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211235101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211235101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211236321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211236321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211236321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211242581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211242581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211242581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211242582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211242582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211242582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211259141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211259141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211259141';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-21';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-21' 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-260722-0001','D','2026-07-22','15:15:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','6414527000','6414527000');
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-260722-0001','D','2026-07-22','15:15:25','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260722-0001','D','2026-07-22','15:15:25','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-260722-0001','D','2026-07-22','15:15:25','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
UPDATE tp_system SET tgl_system='2026-07-22';