INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-23 ','08:13:32');
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-20260723-0001','1','LMT1-ZGBB-21-0','1','1.000','1.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT1-ZGBB-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT1-ZGBB-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT1-ZGBB-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2026-07-23 08:13:54' WHERE kode_barang='LMT1-ZGBB-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT1-ZGBB-21-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-23 08:13:54','TOKO','TFLM','LMT1','LMT1-ZGBB-21-0','1','1.000','1.000','1','1.000','1.000','115.00');
DELETE FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT1-ZGBB-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0001','1','LMT1-ZGBB-22-0','1','1.000','1.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT1-ZGBB-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT1-ZGBB-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT1-ZGBB-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2026-07-23 08:13:54' WHERE kode_barang='LMT1-ZGBB-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT1-ZGBB-22-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-23 08:13:54','TOKO','TFLM','LMT1','LMT1-ZGBB-22-0','1','1.000','1.000','1','1.000','1.000','115.00');
DELETE FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT1-ZGBB-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0001','1','LMT1-ZGBB-23-0','1','1.000','1.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT1-ZGBB-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT1-ZGBB-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT1-ZGBB-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2026-07-23 08:13:54' WHERE kode_barang='LMT1-ZGBB-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT1-ZGBB-23-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-23 08:13:54','TOKO','TFLM','LMT1','LMT1-ZGBB-23-0','1','1.000','1.000','1','1.000','1.000','115.00');
DELETE FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT1-ZGBB-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0001','1','LMT1-ZGBB-24-0','1','1.000','1.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT1-ZGBB-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT1-ZGBB-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT1-ZGBB-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2026-07-23 08:13:54' WHERE kode_barang='LMT1-ZGBB-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT1-ZGBB-24-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-23 08:13:54','TOKO','TFLM','LMT1','LMT1-ZGBB-24-0','1','1.000','1.000','1','1.000','1.000','115.00');
DELETE FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT1-ZGBB-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0001','1','LMT1-ZGBB-25-0','1','1.000','1.000','TOKO','LMT','TOKO','TFLM');
DELETE FROM tm_barang WHERE kode_barang='LMT1-ZGBB-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LMT1-ZGBB-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LMT1-ZGBB-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='TFLM',tgl_last_beli='2026-07-23 08:13:54' WHERE kode_barang='LMT1-ZGBB-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LMT1-ZGBB-25-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-23 08:13:54','TOKO','TFLM','LMT1','LMT1-ZGBB-25-0','1','1.000','1.000','1','1.000','1.000','115.00');
DELETE FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LMT1-ZGBB-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZGBB-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260723-0001','2026-07-23','08:13','5.000','kasir','2026-07-23 08:13:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-23 ','08:34:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-23 ','08:56:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-23 ','10:26:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-23 ','10:26:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-23 ','10:29:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-23 ','11:01:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-23 ','11:10:50');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260723-0002','1','PSPRT-ZGBB-6-0','1','6.320','6.320','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-23 11:11:42' WHERE kode_barang='PSPRT-ZGBB-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-6-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-23 11:11:42','TOKO','DUPSN','PSPRT','PSPRT-ZGBB-6-0','1','6.320','6.320','1','6.320','6.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0002','1','PSPRT-ZGBB-47-0','1','3.550','3.550','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-23 11:11:42' WHERE kode_barang='PSPRT-ZGBB-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-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-23 11:11:42','TOKO','DUPSN','PSPRT','PSPRT-ZGBB-47-0','1','3.550','3.550','1','3.550','3.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-47-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0002','1','PSGT-ZGBB-55-0','1','1.930','1.930','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBB-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBB-55-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBB-55-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-23 11:11:42' WHERE kode_barang='PSGT-ZGBB-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBB-55-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-23 11:11:42','TOKO','DUPSN','PSGT','PSGT-ZGBB-55-0','1','1.930','1.930','1','1.930','1.930','57.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGBB-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-55-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0002','1','PSPRT-ZGBB-56-0','1','3.780','3.780','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-56-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-56-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-56-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-23 11:11:42' WHERE kode_barang='PSPRT-ZGBB-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-56-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-23 11:11:42','TOKO','DUPSN','PSPRT','PSPRT-ZGBB-56-0','1','3.780','3.780','1','3.780','3.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-56-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260723-0002','2026-07-23','11:11','15.580','kasirbip','2026-07-23 11:11:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-23 ','11:11:48');
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-20260723-0003','1','PSGT-ZGBB-46-0','1','1.070','1.070','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBB-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBB-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBB-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSGT-ZGBB-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBB-46-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-23 11:19:48','TOKO','BIPPSN','PSGT','PSGT-ZGBB-46-0','1','1.070','1.070','1','1.070','1.070','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGBB-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-46-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0003','1','PSGT-ZGBB-49-0','1','2.660','2.660','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBB-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBB-49-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBB-49-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSGT-ZGBB-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBB-49-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-23 11:19:48','TOKO','BIPPSN','PSGT','PSGT-ZGBB-49-0','1','2.660','2.660','1','2.660','2.660','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGBB-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-49-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0003','1','PSPRT-ZGBB-50-0','1','2.130','2.130','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSPRT-ZGBB-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-50-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-23 11:19:48','TOKO','BIPPSN','PSPRT','PSPRT-ZGBB-50-0','1','2.130','2.130','1','2.130','2.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-50-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0003','1','PSPRT-ZGBB-51-0','1','3.560','3.560','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSPRT-ZGBB-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-51-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-23 11:19:48','TOKO','BIPPSN','PSPRT','PSPRT-ZGBB-51-0','1','3.560','3.560','1','3.560','3.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-51-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0003','1','PSGT-ZGBB-52-0','1','2.320','2.320','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBB-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBB-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBB-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSGT-ZGBB-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBB-52-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-23 11:19:48','TOKO','BIPPSN','PSGT','PSGT-ZGBB-52-0','1','2.320','2.320','1','2.320','2.320','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGBB-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-52-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0003','1','PSPRT-ZGBB-53-0','1','1.970','1.970','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSPRT-ZGBB-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-53-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-23 11:19:48','TOKO','BIPPSN','PSPRT','PSPRT-ZGBB-53-0','1','1.970','1.970','1','1.970','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0003','1','PSGT-ZGBB-54-0','1','1.660','1.660','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBB-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBB-54-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBB-54-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-23 11:19:48' WHERE kode_barang='PSGT-ZGBB-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBB-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-23 11:19:48','TOKO','BIPPSN','PSGT','PSGT-ZGBB-54-0','1','1.660','1.660','1','1.660','1.660','45.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZGBB-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBB-54-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260723-0003','2026-07-23','11:18','15.370','kasirbip','2026-07-23 11:19:47');
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,potong_rp,keterangan) VALUES ('FJ-260723-0001','kasirbip','1',' DP-02821DU','TOKO','DUPSN','PSPRT-ZGBB-6-0','1PS CINCIN PERAK ','','6.320','1','100.00','645000','0','0','17800','1500000','0','0','0','1500000','PUT','00045497','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBB-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.320',berat_jual_asli=berat_jual_asli+'6.320',stock_jual='1',berat_akhir=berat_akhir-'6.320',berat_akhir_asli=berat_akhir_asli-'6.320',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='PSPRT-ZGBB-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0001','2026-07-23','6.320','2026-07-23','11:44:22','PLG0013504','1500000','1500000','0','1500000','0','kasirbip','2026-07-23 11:44:22','FJ-260723-0001','DP-02821','1500000');
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-23','FJ-260723-0001','2026-07-23','11:44:22','PUT','1500000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260723-0001' 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,potong_rp,keterangan) VALUES ('FJ-260723-0002','kasirbip','1',' DP-02984DU','TOKO','DUPSN','PSPRT-ZGBB-56-0','1PS CINCIN PERAK ','','3.780','1','100.00','386000','0','0','17800','1400000','0','0','0','1400000','PUT','00045547','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBB-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.780',berat_jual_asli=berat_jual_asli+'3.780',stock_jual='1',berat_akhir=berat_akhir-'3.780',berat_akhir_asli=berat_akhir_asli-'3.780',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='PSPRT-ZGBB-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0002','2026-07-23','3.780','2026-07-23','11:45:04','PLG0013505','1400000','1400000','0','1400000','0','kasirbip','2026-07-23 11:45:03','FJ-260723-0002','DP-02984','1400000');
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-23','FJ-260723-0002','2026-07-23','11:45:04','PUT','1400000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260723-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0002';
UPDATE tt_service_head SET tgl_selesai='2026-07-23',  status ='DONE' WHERE no_service='SV-02168';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02168';
UPDATE tt_service_head SET tgl_selesai='2026-07-23',  status ='DONE' WHERE no_service='SV-02169';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02169';
UPDATE tt_service_head SET tgl_selesai='2026-07-23',  status ='DONE' WHERE no_service='SV-02170';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02170';
UPDATE tt_service_head SET tgl_selesai='2026-07-23',  status ='DONE' WHERE no_service='SV-02173';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02173';
UPDATE tt_service_head SET tgl_selesai='2026-07-23',  status ='DONE' WHERE no_service='SV-02176';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02176';
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,potong_rp,keterangan) VALUES ('FJ-260723-0003','kasirbip','1',' DP-02649DU','TOKO','DUPSN','PSPRT-ZGBB-47-0','CINCIN PERAK ','','3.550','1','100.00','363000','0','0','17800','950000','0','0','0','950000','PUT','00045538','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBB-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='PSPRT-ZGBB-47-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0003','2026-07-23','3.550','2026-07-23','12:08:35','PLG0013506','950000','950000','0','950000','0','kasirbip','2026-07-23 12:08:35','FJ-260723-0003','DP-02649','950000');
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-23','FJ-260723-0003','2026-07-23','12:08:35','PUT','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260723-0003' 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,potong_rp,keterangan) VALUES ('FJ-260723-0004','kasirbip',' 1',' DP-02650DU','TOKO','DUPSN','PSPLT-ZGAG-22-0','CINCIN PALADIUM ','','1.390','1','17.00','313000','0','0','17800','1576500','0','0','0','1576500','PUT','00045289','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='PSPLT-ZGAG-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0004','2026-07-23','1.390','2026-07-23','12:08:35','PLG0013507','1576500','1576500','0','1576500','0','kasirbip','2026-07-23 12:08:35','FJ-260723-0003','DP-02650','1432000');
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-23','FJ-260723-0004','2026-07-23','12:08:35','PUT','1576500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260723-0001','2026-07-23','2026-07-23 12:08:35','PENJUALAN : FJ-260723-0004','.','TBC','144500','144500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260723-0002','D','2026-07-23','12:08:35','TBC','PENJUALAN','FJ-260723-0004','25248172564','144500','25248317064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='144500' WHERE no_faktur_jual='FJ-260723-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','13:09:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-23 ','13:22:46');
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,potong_rp,keterangan) VALUES ('FJ-260723-0005','kasir','1',' TFCMP75-85','TOKO','TFCINMAS','TFCMP-ZBBF-49-0','THIFA CINCIN MAS PUTIH ','','1.180','1','85.00','2333000','0','0','17800','2350000','0','0','0','2350000','RISIANA','00041948','TFCMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMP-ZBBF-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='TFCMP-ZBBF-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0005','2026-07-23','1.180','2026-07-23','13:29:14','PLG0013508','2350000','2350000','0','2350000','0','kasir','2026-07-23 13:29:14','FJ-260723-0005','','POTONG');
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-23','FJ-260723-0005','2026-07-23','13:29:14','RISIANA','2350000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260723-0002','2026-07-23','2026-07-23 13:29:14','PENJUALAN : FJ-260723-0005','.','TBC','2350000','2350000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260723-0003','D','2026-07-23','13:29:14','TBC','PENJUALAN','FJ-260723-0005','25248317064','2350000','25250667064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2350000' WHERE no_faktur_jual='FJ-260723-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0005';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03068','ADEL','1','GOLD','COUPLE CWO','','','5.000','','75.00','1','2280000','2250000','','850000','12100000','GRAF : Ayu Raharja : Brush Script','SIZE CWOK : 21 SIZE CWEK : 15','','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03068','1','','SAMPLE DETAI DI WA','','2026-07-23 13:49:44','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260723-0003','2026-07-23','2026-07-23 13:49:44','PESANAN : DP-03068','0','TBC','12100000','12100000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260723-0004','D','2026-07-23','13:49:44','TBC','PESANAN','DP-03068','25250667064','12100000','25262767064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03068','2026-07-23','2026-07-23','13:49:44','PLG0013509','ADEL','2026-08-12','jogja','2026-07-23 13:49:44','5.000','0','0','0','12100000','0','850000','12100000','12100000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03069','ADEL','1','GOLD','COUPLE RING','','','5.000','','75.00','1','2280000','2250000','','850000','12100000','GRAF : Ayu Raharja : Brush Script','SIZE CWOK21 DETAI DI WA','','0','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03069','1','','DI WA','','2026-07-23 13:54:57','OPEN');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03069','2026-07-23','2026-07-23','13:54:57','PLG0013510','ADEL','2026-08-12','jogja','2026-07-23 13:54:57','5.000','9680000','0','0','0','0','850000','12100000','12100000','2420000');
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-260723-0002','D','2026-07-23','13:54:57','jogja','PESANAN','DP-03069','45252300','9680000','54932300');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03070','ADEL','1','GOLD','COUPLE RING','','','2.500','','75.00','1','2280000','2250000','','800000','6425000','GRAF : Ayu Raharja : Brush Script','SIZE CWEK 15 DETAI DI WA','','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03070','1','','SAMPLE SILVER DETAIL DI WA','','2026-07-23 13:59:35','OPEN');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03070','2026-07-23','2026-07-23','13:59:35','PLG0013511','ADEL','2026-09-12','jogja','2026-07-23 13:59:35','2.500','5140000','0','0','0','0','800000','6425000','6425000','1285000');
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-260723-0003','D','2026-07-23','13:59:35','jogja','PESANAN','DP-03070','54932300','5140000','60072300');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03071','ADEL','1','PER','WEDDING PROMO','','','4.000','','925.00','1','100000','1600000','0','0','1600000','CWEK SIZE : 14.5 : GRAF : Alan','CWOK SIZE : 17 : GRAF : Syarifah','FONT : BERKSHIRE SWASH','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03071','1','CP11','PROMO 1.6','','2026-07-23 15:39:56','OPEN');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03071','2026-07-23','2026-07-23','15:39:56','PLG0013512','ADEL','2026-08-23','jogja','2026-07-23 15:39:56','4.000','1600000','0','0','0','0','0','1600000','1600000','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-260723-0004','D','2026-07-23','15:39:56','jogja','PESANAN','DP-03071','60072300','1600000','61672300');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','16:30:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','16:38:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','16:42:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','16:43:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','16:47:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-23 ','16:54:19');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03068';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03068';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03068';
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-260723-0005','K','2026-07-23','17:02:17','jogja','PESANAN BATAL','DP-03068','61672300','0','61672300');
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,potong_rp,keterangan) VALUES ('FJ-260723-0006','kasirbip','1',' DP-02721DU','TOKO','DUPSN','PSGT-ZGBB-55-0','CINCIN EMAS ','','1.930','1','57.00','2559000','0','0','17800','4224000','0','0','0','4224000','PUT','00045546','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBB-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='PSGT-ZGBB-55-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0006','2026-07-23','1.930','2026-07-23','17:57:39','PLG0013513','4224000','4224000','0','4224000','0','kasirbip','2026-07-23 17:57:38','FJ-260723-0006','DP-02721','4200000');
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-23','FJ-260723-0006','2026-07-23','17:57:39','PUT','4224000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260723-0004','2026-07-23','2026-07-23 17:57:38','PENJUALAN : FJ-260723-0006','.','TBC','24000','24000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260723-0005','D','2026-07-23','17:57:39','TBC','PENJUALAN','FJ-260723-0006','25262767064','24000','25262791064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='24000' WHERE no_faktur_jual='FJ-260723-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-23 ','18:50:03');
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-20260723-0004','1','PSPLT-ZGBB-7-0','1','2.630','2.630','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBB-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBB-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBB-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBB-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-23 18:51:22' WHERE kode_barang='PSPLT-ZGBB-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBB-7-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-23 18:51:22','TOKO','SBYPSN','PSPLT','PSPLT-ZGBB-7-0','1','2.630','2.630','1','2.630','2.630','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGBB-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBB-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0004','1','PSPLT-ZGBB-8-0','1','3.510','3.510','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBB-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBB-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBB-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBB-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-23 18:51:22' WHERE kode_barang='PSPLT-ZGBB-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBB-8-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-23 18:51:22','TOKO','SBYPSN','PSPLT','PSPLT-ZGBB-8-0','1','3.510','3.510','1','3.510','3.510','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGBB-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBB-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0004','1','PSPRT-ZGBB-9-0','1','3.730','3.730','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-23 18:51:22' WHERE kode_barang='PSPRT-ZGBB-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-9-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-23 18:51:22','TOKO','SBYPSN','PSPRT','PSPRT-ZGBB-9-0','1','3.730','3.730','1','3.730','3.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0004','1','PSPLT-ZGBB-10-0','1','2.610','2.610','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBB-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBB-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBB-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBB-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-23 18:51:22' WHERE kode_barang='PSPLT-ZGBB-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBB-10-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-23 18:51:22','TOKO','SBYPSN','PSPLT','PSPLT-ZGBB-10-0','1','2.610','2.610','1','2.610','2.610','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZGBB-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBB-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0004','1','PSPRT-ZGBB-48-0','1','2.740','2.740','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBB-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBB-48-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBB-48-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-23 18:51:22' WHERE kode_barang='PSPRT-ZGBB-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBB-48-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-23 18:51:22','TOKO','SBYPSN','PSPRT','PSPRT-ZGBB-48-0','1','2.740','2.740','1','2.740','2.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZGBB-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBB-48-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260723-0004','2026-07-23','18:51','15.220','sby','2026-07-23 18:51:21');
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-20260723-0005','1','PSBY-ZGBB-26-0','1','1.530','1.530','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-26-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-26-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-27-0','1','1.680','1.680','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-27-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-27-0','1','1.680','1.680','1','1.680','1.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-28-0','1','1.670','1.670','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-28-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-28-0','1','1.670','1.670','1','1.670','1.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-29-0','1','2.200','2.200','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-29-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-29-0','1','2.200','2.200','1','2.200','2.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-30-0','1','1.820','1.820','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-30-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-30-0','1','1.820','1.820','1','1.820','1.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-31-0','1','1.680','1.680','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-31-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-31-0','1','1.680','1.680','1','1.680','1.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-32-0','1','2.830','2.830','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-32-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-32-0','1','2.830','2.830','1','2.830','2.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-33-0','1','2.250','2.250','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-33-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-33-0','1','2.250','2.250','1','2.250','2.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-34-0','1','3.280','3.280','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-34-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-34-0','1','3.280','3.280','1','3.280','3.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-35-0','1','2.240','2.240','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-35-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-35-0','1','2.240','2.240','1','2.240','2.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-36-0','1','2.130','2.130','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-36-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-36-0','1','2.130','2.130','1','2.130','2.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-37-0','1','2.740','2.740','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-37-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-37-0','1','2.740','2.740','1','2.740','2.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-38-0','1','1.760','1.760','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-38-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-38-0','1','1.760','1.760','1','1.760','1.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-39-0','1','1.800','1.800','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-39-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-39-0','1','1.800','1.800','1','1.800','1.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-40-0','1','1.780','1.780','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-40-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-40-0','1','1.780','1.780','1','1.780','1.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-40-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-41-0','1','1.900','1.900','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-41-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-41-0','1','1.900','1.900','1','1.900','1.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-42-0','1','1.840','1.840','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-42-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-42-0','1','1.840','1.840','1','1.840','1.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-43-0','1','2.020','2.020','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-43-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-43-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-44-0','1','2.080','2.080','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-44-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-44-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
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-20260723-0005','1','PSBY-ZGBB-45-0','1','4.040','4.040','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZGBB-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZGBB-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZGBB-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-07-23 18:52:35' WHERE kode_barang='PSBY-ZGBB-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZGBB-45-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-23 18:52:35','TOKO','SBYPER','PSBY','PSBY-ZGBB-45-0','1','4.040','4.040','1','4.040','4.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZGBB-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZGBB-45-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-23' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260723-0005','2026-07-23','18:51','43.270','sby','2026-07-23 18:52:35');
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-260723-0006','K','2026-07-23','19:34:16','kasir','KAS BESAR','DI BAWA KE KANTOR','61672300','45000000','16672300');
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,potong_rp,keterangan) VALUES ('FJ-260723-0007','kasirbip','1',' DP-02828BI','TOKO','BIPPSN','PSGT-ZGBB-54-0','CINCIN EMAS ','','1.660','1','45.00','1738000','0','0','17800','3444000','0','0','0','3444000','KUR','00045545','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBB-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-07-23' AND kode_barang='PSGT-ZGBB-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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,no_persekot,dp_pesanan) VALUES ('FJ-260723-0007','2026-07-23','1.660','2026-07-23','19:37:33','PLG0013514','3444000','3444000','0','3444000','0','kasirbip','2026-07-23 19:37:33','FJ-260723-0007','DP-02828','3135000');
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-23','FJ-260723-0007','2026-07-23','19:37:33','KUR','3444000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260723-0005','2026-07-23','2026-07-23 19:37:33','PENJUALAN : FJ-260723-0007','.','TBC','309000','309000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260723-0006','D','2026-07-23','19:37:33','TBC','PENJUALAN','FJ-260723-0007','25262791064','309000','25263100064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='309000' WHERE no_faktur_jual='FJ-260723-0007' 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-260723-0007','K','2026-07-23','19:41:22','kasir','KAS BESAR','AMBIL UANG','16672300','16420000','252300');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260723-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260723-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-23 ','20:43:00');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-23';
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-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-23';
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-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-23' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260724-0001','D','2026-07-24','21:04:04','TBC','SALDO AWAL','SALDO AWAL','0','25263100064','25263100064');
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-260724-0001','D','2026-07-24','21:04:04','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
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-260724-0001','D','2026-07-24','21:04:04','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
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-260724-0001','D','2026-07-24','21:04:04','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
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-260724-0001','D','2026-07-24','21:04:04','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
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-260724-0001','D','2026-07-24','21:04:04','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
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-260724-0001','D','2026-07-24','21:04:04','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-260724-0001','D','2026-07-24','21:04:04','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
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-260724-0001','D','2026-07-24','21:04:04','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-260724-0001','D','2026-07-24','21:04:04','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
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-260724-0001','D','2026-07-24','21:04:04','','SALDO AWAL','SALDO AWAL','0','250000','250000');
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-260724-0001','D','2026-07-24','21:04:04','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
UPDATE tp_system SET tgl_system='2026-07-24';