INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','08:09:53');
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-20260729-0001','1','PSGT-ZGBH-4-0','1','2.680','2.680','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:11' WHERE kode_barang='PSGT-ZGBH-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-4-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-29 08:10:11','TOKO','MMPSN','PSGT','PSGT-ZGBH-4-0','1','2.680','2.680','1','2.680','2.680','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-ZGBH-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSGT-ZGBH-5-0','1','2.880','2.880','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:11' WHERE kode_barang='PSGT-ZGBH-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-5-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-29 08:10:11','TOKO','MMPSN','PSGT','PSGT-ZGBH-5-0','1','2.880','2.880','1','2.880','2.880','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-ZGBH-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSGT-ZGBH-6-0','1','1.790','1.790','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSGT-ZGBH-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 08:10:12','TOKO','MMPSN','PSGT','PSGT-ZGBH-6-0','1','1.790','1.790','1','1.790','1.790','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-ZGBH-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSPRT-ZGBH-7-0','1','3.230','3.230','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSPRT-ZGBH-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 08:10:12','TOKO','MMPSN','PSPRT','PSPRT-ZGBH-7-0','1','3.230','3.230','1','3.230','3.230','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-ZGBH-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSGT-ZGBH-8-0','1','2.940','2.940','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSGT-ZGBH-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 08:10:12','TOKO','MMPSN','PSGT','PSGT-ZGBH-8-0','1','2.940','2.940','1','2.940','2.940','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-ZGBH-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSGT-ZGBH-9-0','1','2.110','2.110','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSGT-ZGBH-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 08:10:12','TOKO','MMPSN','PSGT','PSGT-ZGBH-9-0','1','2.110','2.110','1','2.110','2.110','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-ZGBH-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSGT-ZGBH-10-0','1','2.510','2.510','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSGT-ZGBH-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 08:10:12','TOKO','MMPSN','PSGT','PSGT-ZGBH-10-0','1','2.510','2.510','1','2.510','2.510','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-ZGBH-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSGT-ZGBH-11-0','1','1.800','1.800','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSGT-ZGBH-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-11-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-29 08:10:12','TOKO','MMPSN','PSGT','PSGT-ZGBH-11-0','1','1.800','1.800','1','1.800','1.800','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-ZGBH-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSPRT-ZGBH-12-0','1','4.570','4.570','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSPRT-ZGBH-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-12-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-29 08:10:12','TOKO','MMPSN','PSPRT','PSPRT-ZGBH-12-0','1','4.570','4.570','1','4.570','4.570','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-ZGBH-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSPRT-ZGBH-13-0','1','2.990','2.990','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSPRT-ZGBH-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-13-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-29 08:10:12','TOKO','MMPSN','PSPRT','PSPRT-ZGBH-13-0','1','2.990','2.990','1','2.990','2.990','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-ZGBH-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0001','1','PSPRT-ZGBH-47-0','1','3.800','3.800','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2026-07-29 08:10:12' WHERE kode_barang='PSPRT-ZGBH-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 08:10:12','TOKO','MMPSN','PSPRT','PSPRT-ZGBH-47-0','1','3.800','3.800','1','3.800','3.800','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-ZGBH-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-47-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260729-0001','2026-07-29','08:10','31.300','kasir','2026-07-29 08:10:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:07:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:14:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:15:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:17:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:23:12');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:24:50');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','09:50:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','10:46:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','10:50:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-29 ','12:03:15');
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-260729-0001','kasirbip','1',' DP-02833BI','TOKO','BIPPSN','PSPRT-ZGBD-22-0','CINCIN PERAK ','','1.490','1','100.00','152000','0','0','17800','850000','0','0','0','850000','KUR','00045598','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBD-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.490',berat_jual_asli=berat_jual_asli+'1.490',stock_jual='1',berat_akhir=berat_akhir-'1.490',berat_akhir_asli=berat_akhir_asli-'1.490',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBD-22-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-260729-0001','2026-07-29','1.490','2026-07-29','12:05:01','PLG0013730','850000','850000','0','850000','0','kasirbip','2026-07-29 12:05:00','FJ-260729-0001','DP-02833','850000');
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-29','FJ-260729-0001','2026-07-29','12:05:01','KUR','850000','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-260729-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-260729-0002','kasirbip',' 1',' DP-02832BI','TOKO','BIPPSN','PSPRT-ZGAF-28-0','CINCIN PERAK YL-01 ','','1.660','1','100.00','170000','0','0','17800','700000','0','0','0','700000','KUR','00045246','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAF-28-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-29' AND kode_barang='PSPRT-ZGAF-28-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-260729-0002','2026-07-29','1.660','2026-07-29','12:05:01','PLG0013731','700000','700000','0','700000','0','kasirbip','2026-07-29 12:05:00','FJ-260729-0001','DP-02832','700000');
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-29','FJ-260729-0002','2026-07-29','12:05:01','KUR','700000','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-260729-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-29 ','12:09:23');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000363','X-00000363','TFC-21250 GIA 6471252864','GR','---','TFC','BELI','BELI001','13040000','2026-07-29','4.920','1','kasir','2026-07-29 12:12:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-TFC';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000363','X-00000363');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260729-0001','FJ-231211-0001','BARY','1','BELI','BELI001','TFC', 'X-00000363', 'TFC-21250 GIA 6471252864','4.690','4.920','75.00','16300000','13040000','2650407','1','13040000','13040000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.920',berat_beli_asli=berat_beli_asli+'4.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.920',berat_akhir_asli=berat_akhir_asli+'4.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFC' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260729-0001','2026-07-29','2026-07-29','12:12:32','BARY','---','4.920','13040000','13040000','13040000','13040000','13040000','kasir','2026-07-29 12:12:33','FB-260729-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260729-0001','HERLINA','-','','JKT','-','kasir','2026-07-29 12:12:33');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260729-0001','2026-07-29','2026-07-29 12:12:33','PEMBELIAN UMUM : FB-260729-0001','.','TBC','13040000','13040000');
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 ('KK-260729-0002','K','2026-07-29','12:12:32','TBC','PEMBELIAN UMUM','FB-260729-0001','25512919564','13040000','25499879564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260729-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260729-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-29 ','12:44:28');
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-260729-0003','sby','1',' 750K-165-0','TOKO','SBYPER','PSBY-ZGBB-38-0','CINCIN SILVER 925 ','','1.760','1','100.00','180000','0','0','17800','850000','0','0','0','850000','VAN','00045529','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSBY-ZGBB-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260729-0003','2026-07-29','1.760','2026-07-29','12:46:25','PLG0013732','850000','850000','0','850000','0','sby','2026-07-29 12:46:24','FJ-260729-0003','','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-29','FJ-260729-0003','2026-07-29','12:46:25','VAN','850000','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-260729-0002','2026-07-29','2026-07-29 12:46:24','PENJUALAN : FJ-260729-0003','','TBC','850000','850000','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-260729-0003','D','2026-07-29','12:46:25','TBC','PENJUALAN','FJ-260729-0003','25499879564','850000','25500729564','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='850000' WHERE no_faktur_jual='FJ-260729-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-07-29 ','13:29:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-29 ','13:33:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-29 ','13:42:28');
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-03150','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','700000','2900000','SIZE 24 GRF: Gefin & Sisy (YASEVA)','CROM PUTIH DOFF MIX GLOSSY','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260729-0003','2026-07-29','2026-07-29 13:45:02','PESANAN : DP-03150','-','TBC','2000000','2000000');
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-260729-0004','D','2026-07-29','13:45:02','TBC','PESANAN','DP-03150','25500729564','2000000','25502729564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','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-03150','2026-07-29','2026-07-29','13:45:02','PLG0013733','DIL','2026-08-25','sby','2026-07-29 13:45:02','4.000','0','0','0','2000000','0','700000','2900000','2900000','900000');
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-260729-0004','sby','1',' DP-02753SB','TOKO','SBYPSN','PSPRT-ZGBD-12-0','CINCIN PERAK YL-10 ','','1.850','1','100.00','463000','0','0','17800','700000','0','0','0','700000','DIL','00045588','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBD-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0004','2026-07-29','1.850','2026-07-29','13:50:20','PLG0013734','700000','700000','0','700000','0','sby','2026-07-29 13:50:20','FJ-260729-0004','DP-02753','700000');
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-29','FJ-260729-0004','2026-07-29','13:50:20','DIL','700000','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-260729-0004' 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-260729-0005','sby','1',' DP-02499SB','TOKO','SBYPSN','PSPLT-ZGXA-16-0','CINCIN PALADIUM ','','3.220','1','17.00','591000','0','0','17800','1137000','0','750000','0','1887000','VAN','00044876','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXA-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPLT-ZGXA-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0005','2026-07-29','3.220','2026-07-29','13:59:52','PLG0013735','1137000','1137000','750000','1887000','0','sby','2026-07-29 13:59:52','FJ-260729-0005','DP-02499','1300000');
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-29','FJ-260729-0005','2026-07-29','13:59:52','VAN','1887000','750000');
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-260729-0004','2026-07-29','2026-07-29 13:59:52','PENJUALAN : FJ-260729-0005','','TBC','587000','587000','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-260729-0005','D','2026-07-29','13:59:52','TBC','PENJUALAN','FJ-260729-0005','25502729564','587000','25503316564','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='587000' WHERE no_faktur_jual='FJ-260729-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0005';
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-260729-0006','kasirbip','1',' DP-02810DU','TOKO','DUPSN','PSPRT-ZGBX-6-0','CINCIN PERAK SR-03 YL-01 ','','3.610','1','100.00','369000','0','0','17800','1150000','0','0','0','1150000','PUT','00045326','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.610',berat_jual_asli=berat_jual_asli+'3.610',stock_jual='1',berat_akhir=berat_akhir-'3.610',berat_akhir_asli=berat_akhir_asli-'3.610',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBX-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-260729-0006','2026-07-29','3.610','2026-07-29','14:26:06','PLG0013736','1150000','1150000','0','1150000','0','kasirbip','2026-07-29 14:26:05','FJ-260729-0006','DP-02810','1150000');
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-29','FJ-260729-0006','2026-07-29','14:26:06','PUT','1150000','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-260729-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0006';
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-20260729-0002','1','PSPRT-ZGBG-1-0','1','3.020','3.020','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBG-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBG-1-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBG-1-0','1','3.020','3.020','1','3.020','3.020','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-ZGBG-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBG-2-0','1','1.830','1.830','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBG-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBG-2-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBG-2-0','1','1.830','1.830','1','1.830','1.830','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-ZGBG-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSGT-ZGBG-3-0','1','2.680','2.680','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBG-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBG-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBG-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBG-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSGT-ZGBG-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBG-3-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-29 14:43:28','TOKO','BIPPSN','PSGT','PSGT-ZGBG-3-0','1','2.680','2.680','1','2.680','2.680','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-ZGBG-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBG-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBG-4-0','1','3.180','3.180','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBG-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBG-4-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBG-4-0','1','3.180','3.180','1','3.180','3.180','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-ZGBG-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBG-5-0','1','2.080','2.080','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBG-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBG-5-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBG-5-0','1','2.080','2.080','1','2.080','2.080','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-ZGBG-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBG-6-0','1','1.970','1.970','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBG-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBG-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBG-6-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-ZGBG-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBG-7-0','1','2.630','2.630','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBG-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBG-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBG-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBG-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBG-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBG-7-0','1','2.630','2.630','1','2.630','2.630','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-ZGBG-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBG-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSGT-ZGBH-14-0','1','1.600','1.600','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSGT-ZGBH-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-14-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-29 14:43:28','TOKO','BIPPSN','PSGT','PSGT-ZGBH-14-0','1','1.600','1.600','1','1.600','1.600','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-ZGBH-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBH-15-0','1','5.330','5.330','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBH-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-15-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBH-15-0','1','5.330','5.330','1','5.330','5.330','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-ZGBH-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSGT-ZGBH-16-0','1','1.870','1.870','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSGT-ZGBH-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-16-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-29 14:43:28','TOKO','BIPPSN','PSGT','PSGT-ZGBH-16-0','1','1.870','1.870','1','1.870','1.870','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-ZGBH-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBH-17-0','1','2.050','2.050','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBH-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-17-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBH-17-0','1','2.050','2.050','1','2.050','2.050','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-ZGBH-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0002','1','PSPRT-ZGBH-18-0','1','3.470','3.470','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-07-29 14:43:28' WHERE kode_barang='PSPRT-ZGBH-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-18-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-29 14:43:28','TOKO','BIPPSN','PSPRT','PSPRT-ZGBH-18-0','1','3.470','3.470','1','3.470','3.470','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-ZGBH-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260729-0002','2026-07-29','14:43','31.710','kasirbip','2026-07-29 14:43:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-29 ','15:11:18');
UPDATE tm_sales SET deleted_by = 'jogja',deleted_date = '2026-07-29 15:11:51' WHERE sales_id = 'PUTRIJG';
INSERT INTO tm_sales_deleted SELECT * FROM tm_sales WHERE sales_id = 'PUTRIJG';
DELETE FROM tm_sales WHERE sales_id= 'PUTRIJG';
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-20260729-0003','1','PSPLT-ZGBH-19-0','1','2.080','2.080','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPLT-ZGBH-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-19-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-29 15:45:59','TOKO','DUPSN','PSPLT','PSPLT-ZGBH-19-0','1','2.080','2.080','1','2.080','2.080','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-ZGBH-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSPRT-ZGBH-20-0','1','3.590','3.590','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPRT-ZGBH-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-20-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-29 15:45:59','TOKO','DUPSN','PSPRT','PSPRT-ZGBH-20-0','1','3.590','3.590','1','3.590','3.590','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-ZGBH-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSPLT-ZGBH-21-0','1','3.420','3.420','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPLT-ZGBH-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 15:45:59','TOKO','DUPSN','PSPLT','PSPLT-ZGBH-21-0','1','3.420','3.420','1','3.420','3.420','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-ZGBH-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSPRT-ZGBH-22-0','1','3.640','3.640','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPRT-ZGBH-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 15:45:59','TOKO','DUPSN','PSPRT','PSPRT-ZGBH-22-0','1','3.640','3.640','1','3.640','3.640','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-ZGBH-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSPRT-ZGBH-23-0','1','4.470','4.470','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPRT-ZGBH-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 15:45:59','TOKO','DUPSN','PSPRT','PSPRT-ZGBH-23-0','1','4.470','4.470','1','4.470','4.470','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-ZGBH-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSPRT-ZGBH-24-0','1','3.980','3.980','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPRT-ZGBH-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 15:45:59','TOKO','DUPSN','PSPRT','PSPRT-ZGBH-24-0','1','3.980','3.980','1','3.980','3.980','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-ZGBH-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSGT-ZGBH-25-0','1','2.890','2.890','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSGT-ZGBH-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 15:45:59','TOKO','DUPSN','PSGT','PSGT-ZGBH-25-0','1','2.890','2.890','1','2.890','2.890','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-ZGBH-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0003','1','PSPLT-ZGBH-48-0','1','3.510','3.510','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-48-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-48-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-07-29 15:45:59' WHERE kode_barang='PSPLT-ZGBH-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 15:45:59','TOKO','DUPSN','PSPLT','PSPLT-ZGBH-48-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-ZGBH-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-48-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260729-0003','2026-07-29','15:45','27.580','kasirbip','2026-07-29 15:45:58');
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-260729-0007','kasir','1',' TFGRR75-87','TOKO','TFGLR','TFGRR-XHBA-48-0','THIFA GELANG RANTAI RG ','','6.840','1','87.00','13704000','0','0','17800','14000000','0','0','0','14000000','IQB','00030744','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-XHBA-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.840',berat_jual_asli=berat_jual_asli+'6.840',stock_jual='1',berat_akhir=berat_akhir-'6.840',berat_akhir_asli=berat_akhir_asli-'6.840',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='TFGRR-XHBA-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-260729-0007','2026-07-29','6.840','2026-07-29','16:00:02','PLG0013737','14000000','14000000','0','14000000','8400000','kasir','2026-07-29 16:00:02','FJ-260729-0007','','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-29','FJ-260729-0007','2026-07-29','16:00:02','IQB','14000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260729-0002','D','2026-07-29','16:00:02','kasir','PENJUALAN','FJ-260729-0007','652300','8400000','9052300','OPEN');
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-260729-0005','2026-07-29','2026-07-29 16:00:02','PENJUALAN : FJ-260729-0007','.','TBC','5600000','5600000','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-260729-0006','D','2026-07-29','16:00:02','TBC','PENJUALAN','FJ-260729-0007','25503316564','5600000','25508916564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='8400000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5600000' WHERE no_faktur_jual='FJ-260729-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0007';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000364','X-00000364','CINCIN MAS PUTIH','GR','---','CMP','BELI','BELI001','8400000','2026-07-29','5.390','1','kasir','2026-07-29 16:01:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-CMP';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMP','X-00000364','X-00000364');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260729-0002','-','IQB','1','BELI','BELI001','CMP', 'X-00000364', 'CINCIN MAS PUTIH','5.410','5.390','75.00','6141000','8400000','1558442','1','8400000','8400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.390',berat_beli_asli=berat_beli_asli+'5.390',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.390',berat_akhir_asli=berat_akhir_asli+'5.390',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMP' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260729-0002','2026-07-29','2026-07-29','16:01:29','IQB','---','5.390','8400000','8400000','8400000','8400000','8400000','kasir','2026-07-29 16:01:30','FB-260729-0002','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260729-0002','DETYA','JKT','','JKT','','kasir','2026-07-29 16:01:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-29' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260729-0003','K','2026-07-29','16:01:29','kasir','PEMBELIAN UMUM','FB-260729-0002','9052300','8400000','652300','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260729-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260729-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02193','SAL','1','CCN SILVER','PASANG MATA 1 ZIRKON KROM PUTIH DOFF SEMPROT FONT BERKSHIRE SWASH GRF','2.000','1','50000','50000');
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-260729-0006','2026-07-29','2026-07-29 16:17:41','SERVICE : SV-02193','.','TBC','50000','50000','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-260729-0007','D','2026-07-29','16:17:41','TBC','SERVICE','SV-02193','25508916564','50000','25508966564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02193','2026-07-29','2026-07-29','16:17:41','PLG0013738','kasirbip','2026-08-13','kasirbip','2026-07-29 16:17:41','2.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260729-0004','1','PSGT-ZGBH-26-0','1','3.150','3.150','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSGT-ZGBH-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSGT','PSGT-ZGBH-26-0','1','3.150','3.150','1','3.150','3.150','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-ZGBH-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-27-0','1','5.150','5.150','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-27-0','1','5.150','5.150','1','5.150','5.150','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-ZGBH-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-28-0','1','3.190','3.190','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-28-0','1','3.190','3.190','1','3.190','3.190','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-ZGBH-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-29-0','1','1.750','1.750','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-29-0','1','1.750','1.750','1','1.750','1.750','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-ZGBH-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-30-0','1','3.610','3.610','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-30-0','1','3.610','3.610','1','3.610','3.610','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-ZGBH-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-31-0','1','3.110','3.110','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-31-0','1','3.110','3.110','1','3.110','3.110','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-ZGBH-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-32-0','1','2.940','2.940','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-32-0','1','2.940','2.940','1','2.940','2.940','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-ZGBH-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-33-0','1','2.180','2.180','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-33-0','1','2.180','2.180','1','2.180','2.180','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-ZGBH-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-34-0','1','4.570','4.570','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-34-0','1','4.570','4.570','1','4.570','4.570','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-ZGBH-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-35-0','1','3.890','3.890','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-35-0','1','3.890','3.890','1','3.890','3.890','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-ZGBH-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-36-0','1','2.990','2.990','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-36-0','1','2.990','2.990','1','2.990','2.990','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-ZGBH-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-37-0','1','6.440','6.440','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-37-0','1','6.440','6.440','1','6.440','6.440','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-ZGBH-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-38-0','1','3.330','3.330','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-38-0','1','3.330','3.330','1','3.330','3.330','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-ZGBH-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-39-0','1','4.110','4.110','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-39-0','1','4.110','4.110','1','4.110','4.110','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-ZGBH-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-40-0','1','3.160','3.160','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-40-0','1','3.160','3.160','1','3.160','3.160','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-ZGBH-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-40-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSGT-ZGBH-41-0','1','2.060','2.060','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSGT-ZGBH-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSGT','PSGT-ZGBH-41-0','1','2.060','2.060','1','2.060','2.060','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-ZGBH-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-42-0','1','2.390','2.390','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-42-0','1','2.390','2.390','1','2.390','2.390','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-ZGBH-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-43-0','1','4.110','4.110','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-43-0','1','4.110','4.110','1','4.110','4.110','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-ZGBH-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSGT-ZGBH-44-0','1','2.120','2.120','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSGT-ZGBH-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSGT','PSGT-ZGBH-44-0','1','2.120','2.120','1','2.120','2.120','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-ZGBH-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSGT-ZGBH-45-0','1','1.960','1.960','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSGT-ZGBH-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSGT','PSGT-ZGBH-45-0','1','1.960','1.960','1','1.960','1.960','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-ZGBH-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-45-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-46-0','1','3.120','3.120','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-46-0','1','3.120','3.120','1','3.120','3.120','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-ZGBH-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-46-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPLT-ZGBH-49-0','1','2.340','2.340','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZGBH-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGBH-49-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGBH-49-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPLT-ZGBH-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPLT','PSPLT-ZGBH-49-0','1','2.340','2.340','1','2.340','2.340','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-ZGBH-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGBH-49-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-50-0','1','1.570','1.570','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-50-0','1','1.570','1.570','1','1.570','1.570','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-ZGBH-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-50-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-51-0','1','2.930','2.930','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-51-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-51-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-51-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-51-0','1','2.930','2.930','1','2.930','2.930','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-ZGBH-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-51-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSPRT-ZGBH-52-0','1','2.890','2.890','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZGBH-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-52-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZGBH-52-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGBH-52-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSPRT-ZGBH-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSPRT','PSPRT-ZGBH-52-0','1','2.890','2.890','1','2.890','2.890','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-ZGBH-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGBH-52-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' 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-20260729-0004','1','PSGT-ZGBH-53-0','1','3.850','3.850','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZGBH-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-53-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZGBH-53-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZGBH-53-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-07-29 16:19:35' WHERE kode_barang='PSGT-ZGBH-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZGBH-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-29 16:19:35','TOKO','SBYPSN','PSGT','PSGT-ZGBH-53-0','1','3.850','3.850','1','3.850','3.850','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-ZGBH-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGBH-53-0';
UPDATE tt_beli_detail SET tgl_terima='2026-07-29' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260729-0004','2026-07-29','16:17','82.910','sby','2026-07-29 16:19:34');
UPDATE tt_service_head SET tgl_selesai='2026-07-29',  status ='DONE' WHERE no_service='SV-02163';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02163';
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-260729-0008','kasirbip','1',' DP-02811BI','TOKO','BIPPSN','PSGT-ZGBH-16-0','CINCIN EMAS ','','1.870','1','45.00','1958000','0','0','17800','3468000','0','0','0','3468000','SULIS','00045664','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBH-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSGT-ZGBH-16-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-260729-0008','2026-07-29','1.870','2026-07-29','16:35:27','PLG0013739','3468000','3468000','0','3468000','0','kasirbip','2026-07-29 16:35:26','FJ-260729-0008','DP-02811','2910000');
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-29','FJ-260729-0008','2026-07-29','16:35:27','SULIS','3468000','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-260729-0007','2026-07-29','2026-07-29 16:35:26','PENJUALAN : FJ-260729-0008','.','TBC','558000','558000','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-260729-0008','D','2026-07-29','16:35:27','TBC','PENJUALAN','FJ-260729-0008','25508966564','558000','25509524564','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='558000' WHERE no_faktur_jual='FJ-260729-0008' 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-260729-0009','kasirbip',' 1',' DP-02812BI','TOKO','BIPPSN','PSPRT-ZGBG-2-0','CINCIN PERAK ','','1.830','1','100.00','187000','0','0','17800','850000','0','0','0','850000','SULIS','00045613','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBG-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBG-2-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-260729-0009','2026-07-29','1.830','2026-07-29','16:35:27','PLG0013740','850000','850000','0','850000','0','kasirbip','2026-07-29 16:35:26','FJ-260729-0008','DP-02812','850000');
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-29','FJ-260729-0009','2026-07-29','16:35:27','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='558000' WHERE no_faktur_jual='FJ-260729-0009' 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-260729-0010','kasir','1',' 800K-12-94','TOKO','MMPER','PMM-ZDBI-18-0','CINCIN SILVER 925 ','','2.180','1','100.00','223000','0','0','17800','900000','0','0','0','900000','ASRI','00042916','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDBI-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PMM-ZDBI-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-260729-0010','2026-07-29','2.180','2026-07-29','16:36:50','PLG0013741','900000','900000','0','900000','0','kasir','2026-07-29 16:36:50','FJ-260729-0010','','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-29','FJ-260729-0010','2026-07-29','16:36:50','ASRI','900000','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-260729-0008','2026-07-29','2026-07-29 16:36:50','PENJUALAN : FJ-260729-0010','.','TBC','900000','900000','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-260729-0009','D','2026-07-29','16:36:50','TBC','PENJUALAN','FJ-260729-0010','25509524564','900000','25510424564','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='900000' WHERE no_faktur_jual='FJ-260729-0010' 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-260729-0011','kasir',' 1',' 700K-135-0','TOKO','MMPER','LXPER-ZBAH-28-0','CINCIN SILVER 925 ','','2.430','1','100.00','249000','0','0','17800','800000','0','0','0','800000','ASRI','00041646','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='LXPER-ZBAH-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-260729-0011','2026-07-29','2.430','2026-07-29','16:36:50','PLG0013742','800000','800000','0','800000','0','kasir','2026-07-29 16:36:50','FJ-260729-0010','','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-29','FJ-260729-0011','2026-07-29','16:36:50','ASRI','800000','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-260729-0009','2026-07-29','2026-07-29 16:36:50','PENJUALAN : FJ-260729-0011','.','TBC','800000','800000','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-260729-0010','D','2026-07-29','16:36:50','TBC','PENJUALAN','FJ-260729-0011','25510424564','800000','25511224564','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='1700000' WHERE no_faktur_jual='FJ-260729-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0011';
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-260729-0012','kasirbip','1',' DP-03002BI','TOKO','BIPPSN','PSPLT-ZGBD-16-0','CINCIN PALADIUM ','','3.030','1','17.00','681000','0','0','17800','1810500','0','0','0','1810500','SAL','00045592','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPLT-ZGBD-16-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-260729-0012','2026-07-29','3.030','2026-07-29','16:42:14','PLG0013743','1810500','1810500','0','1810500','0','kasirbip','2026-07-29 16:42:14','FJ-260729-0012','DP-03002','1524000');
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-29','FJ-260729-0012','2026-07-29','16:42:14','SAL','1810500','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-260729-0010','2026-07-29','2026-07-29 16:42:14','PENJUALAN : FJ-260729-0012','.','TBC','286500','286500','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-260729-0011','D','2026-07-29','16:42:14','TBC','PENJUALAN','FJ-260729-0012','25511224564','286500','25511511064','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='286500' WHERE no_faktur_jual='FJ-260729-0012' 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-260729-0013','kasirbip',' 1',' DP-03001BI','TOKO','BIPPSN','PSGT-ZGBD-25-0','CINCIN EMAS ','','1.880','1','57.00','2493000','0','0','17800','4474000','0','0','0','4474000','SAL','00045601','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBD-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSGT-ZGBD-25-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-260729-0013','2026-07-29','1.880','2026-07-29','16:42:14','PLG0013744','4474000','4474000','0','4474000','0','kasirbip','2026-07-29 16:42:14','FJ-260729-0012','DP-03001','3752000');
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-29','FJ-260729-0013','2026-07-29','16:42:14','SAL','4474000','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-260729-0011','2026-07-29','2026-07-29 16:42:14','PENJUALAN : FJ-260729-0013','.','TBC','722000','722000','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-260729-0012','D','2026-07-29','16:42:14','TBC','PENJUALAN','FJ-260729-0013','25511511064','722000','25512233064','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='1008500' WHERE no_faktur_jual='FJ-260729-0013' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02194','SAL','1','CINCIN SILVER','CROM PUTIH GLOSSY FONT TIMES NEW ROMAN GRF','2.000','1','50000','50000');
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-260729-0012','2026-07-29','2026-07-29 17:27:58','SERVICE : SV-02194','.','TBC','50000','50000','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-260729-0013','D','2026-07-29','17:27:58','TBC','SERVICE','SV-02194','25512233064','50000','25512283064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02194','2026-07-29','2026-07-29','17:27:58','PLG0013745','kasirbip','2026-08-13','kasirbip','2026-07-29 17:27:58','2.000','0','0','0','50000','0','50000','50000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0013';
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-03151','VAN','1','GOLD','WEDDRING WANITA','','','2.000','','37.50','1','2280000','1400000','0','700000','3500000','PERMATA 3','GRF: Brama?? FONT:VINTAGE','EMAS PUTIH','30000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260729-0013','2026-07-29','2026-07-29 17:38:02','PESANAN : DP-03151','-','TBC','2400000','2400000');
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-260729-0014','D','2026-07-29','17:38:02','TBC','PESANAN','DP-03151','25512283064','2400000','25514683064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','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-03151','2026-07-29','2026-07-29','17:38:02','PLG0013746','VAN','2026-08-24','sby','2026-07-29 17:38:02','2.000','0','0','0','2400000','0','700000','3530000','3530000','1130000');
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-03152','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE: 18.5','GRF: Devina?? FONT: VINTAGE','PUTIH GLOSSY','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260729-0014','2026-07-29','2026-07-29 17:41:09','PESANAN : DP-03152','-','TBC','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,jenis_trx) VALUES ('KM-260729-0015','D','2026-07-29','17:41:09','TBC','PESANAN','DP-03152','25514683064','850000','25515533064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','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-03152','2026-07-29','2026-07-29','17:41:09','PLG0013747','VAN','2026-08-24','sby','2026-07-29 17:41:09','3.000','0','0','0','850000','0','0','850000','850000','0');
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-260729-0014','kasirbip','1',' DP-02831DU','TOKO','DUPSN','PSPLT-ZGBH-48-0','CINCIN PALADIUM YL-10 ','','3.510','1','17.00','789000','0','0','17800','2028500','0','0','0','2028500','PUT','00045696','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBH-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPLT-ZGBH-48-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-260729-0014','2026-07-29','3.510','2026-07-29','17:49:04','PLG0013748','2028500','2028500','0','2028500','0','kasirbip','2026-07-29 17:49:04','FJ-260729-0014','DP-02831','1620000');
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-29','FJ-260729-0014','2026-07-29','17:49:04','PUT','2028500','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-260729-0015','2026-07-29','2026-07-29 17:49:04','PENJUALAN : FJ-260729-0014','.','TBC','408500','408500','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-260729-0016','D','2026-07-29','17:49:04','TBC','PENJUALAN','FJ-260729-0014','25515533064','408500','25515941564','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='408500' WHERE no_faktur_jual='FJ-260729-0014' 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-260729-0015','kasirbip',' 1',' DP-02830DU','TOKO','DUPSN','PSGT-ZGBH-25-0','CINCIN EMAS ','','2.890','1','45.00','3025000','0','0','17800','4796000','0','0','0','4796000','PUT','00045673','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBH-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSGT-ZGBH-25-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-260729-0015','2026-07-29','2.890','2026-07-29','17:49:04','PLG0013749','4796000','4796000','0','4796000','0','kasirbip','2026-07-29 17:49:04','FJ-260729-0014','DP-02830','3960000');
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-29','FJ-260729-0015','2026-07-29','17:49:04','PUT','4796000','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-260729-0016','2026-07-29','2026-07-29 17:49:04','PENJUALAN : FJ-260729-0015','.','TBC','836000','836000','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-260729-0017','D','2026-07-29','17:49:04','TBC','PENJUALAN','FJ-260729-0015','25515941564','836000','25516777564','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='1244500' WHERE no_faktur_jual='FJ-260729-0015' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0015';
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-260729-0016','kasir','1',' DP-02868MM','TOKO','MMPSN','PSPLT-ZGBD-33-0','CINCIN PALADIUM ','','4.390','1','17.00','986000','0','0','17800','2337000','0','0','0','2337000','ALIKA','00045609','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBD-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.390',berat_jual_asli=berat_jual_asli+'4.390',stock_jual='1',berat_akhir=berat_akhir-'4.390',berat_akhir_asli=berat_akhir_asli-'4.390',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPLT-ZGBD-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260729-0016','2026-07-29','4.390','2026-07-29','18:05:06','PLG0013750','2337000','2337000','0','2337000','0','kasir','2026-07-29 18:05:06','FJ-260729-0016','DP-02868','2180000');
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-29','FJ-260729-0016','2026-07-29','18:05:06','ALIKA','2337000','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-260729-0017','2026-07-29','2026-07-29 18:05:06','PENJUALAN : FJ-260729-0016','.','TBC','157000','157000','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-260729-0018','D','2026-07-29','18:05:06','TBC','PENJUALAN','FJ-260729-0016','25516777564','157000','25516934564','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='157000' WHERE no_faktur_jual='FJ-260729-0016' 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-260729-0017','kasirbip','1',' DP-02856BI','TOKO','BIPPSN','PSPRT-ZGBH-15-0','1PS CINCIN PERAK ','','5.330','1','100.00','544000','0','0','17800','1400000','0','0','0','1400000','SAL','00045663','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.330',berat_jual_asli=berat_jual_asli+'5.330',stock_jual='1',berat_akhir=berat_akhir-'5.330',berat_akhir_asli=berat_akhir_asli-'5.330',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-15-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-260729-0017','2026-07-29','5.330','2026-07-29','18:08:20','PLG0013751','1400000','1400000','0','1400000','0','kasirbip','2026-07-29 18:08:19','FJ-260729-0017','DP-02856','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-29','FJ-260729-0017','2026-07-29','18:08:20','SAL','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-260729-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0017';
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-260729-0018','kasirbip','1',' 750K-15-00','TOKO','DUPERBDG','LXPER-ZFAB-73-0','CINCIN SILVER 925 ','','3.500','1','100.00','357000','0','0','17800','850000','0','0','0','850000','PUT','00044397','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAB-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='LXPER-ZFAB-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260729-0018','2026-07-29','3.500','2026-07-29','18:19:36','PLG0013752','850000','850000','0','850000','0','kasirbip','2026-07-29 18:19:35','FJ-260729-0018','','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-29','FJ-260729-0018','2026-07-29','18:19:36','PUT','850000','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-260729-0018','2026-07-29','2026-07-29 18:19:35','PENJUALAN : FJ-260729-0018','.','TBC','850000','850000','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-260729-0019','D','2026-07-29','18:19:36','TBC','PENJUALAN','FJ-260729-0018','25516934564','850000','25517784564','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='850000' WHERE no_faktur_jual='FJ-260729-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0018';
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-260729-0019','kasirbip','1',' DP-02958DU','TOKO','DUPSN','PSPRT-ZGBH-20-0','CINCIN PERAK SR-02 YL-01 ','','3.590','1','100.00','367000','0','0','17800','1050000','0','0','0','1050000','KUR','00045668','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.590',berat_jual_asli=berat_jual_asli+'3.590',stock_jual='1',berat_akhir=berat_akhir-'3.590',berat_akhir_asli=berat_akhir_asli-'3.590',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-20-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-260729-0019','2026-07-29','3.590','2026-07-29','19:05:39','PLG0013753','1050000','1050000','0','1050000','0','kasirbip','2026-07-29 19:05:38','FJ-260729-0019','DP-02958','1050000');
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-29','FJ-260729-0019','2026-07-29','19:05:39','KUR','1050000','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-260729-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0019';
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-260729-0020','kasirbip','1',' DP-02863BI','TOKO','BIPPSN','PSPRT-ZGBG-7-0','CINCIN PERAK ','','2.630','1','100.00','269000','0','0','17800','900000','0','0','0','900000','KUR','00045618','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBG-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBG-7-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-260729-0020','2026-07-29','2.630','2026-07-29','19:09:06','PLG0013754','900000','900000','0','900000','0','kasirbip','2026-07-29 19:09:05','FJ-260729-0020','DP-02863','900000');
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-29','FJ-260729-0020','2026-07-29','19:09:06','KUR','900000','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-260729-0020' 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-260729-0021','kasirbip',' 1',' DP-02862BI','TOKO','BIPPSN','PSGT-ZGBX-3-0','CINCIN EMAS ','','1.810','1','45.00','1895000','0','0','17800','3524000','0','0','0','3524000','KUR','00045323','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGBX-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSGT-ZGBX-3-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-260729-0021','2026-07-29','1.810','2026-07-29','19:09:06','PLG0013755','3524000','3524000','0','3524000','0','kasirbip','2026-07-29 19:09:05','FJ-260729-0020','DP-02862','3030000');
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-29','FJ-260729-0021','2026-07-29','19:09:06','KUR','3524000','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-260729-0019','2026-07-29','2026-07-29 19:09:05','PENJUALAN : FJ-260729-0021','.','TBC','494000','494000','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-260729-0020','D','2026-07-29','19:09:06','TBC','PENJUALAN','FJ-260729-0021','25517784564','494000','25518278564','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='494000' WHERE no_faktur_jual='FJ-260729-0021' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0021';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-29 ','19:25:40');
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-260729-0022','kasir','1',' TFCMR75-85','TOKO','TFCINMAS','TFCMR-ZGBX-42-0','THIFA CINCIN MAS RG ','','0.800','1','85.00','1582000','0','0','17800','1600000','0','0','0','1600000','IQB','00045362','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZGBX-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='TFCMR-ZGBX-42-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-260729-0022','2026-07-29','0.800','2026-07-29','19:40:12','PLG0013756','1600000','1600000','0','1600000','0','kasir','2026-07-29 19:40:11','FJ-260729-0022','','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-29','FJ-260729-0022','2026-07-29','19:40:12','IQB','1600000','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-260729-0020','2026-07-29','2026-07-29 19:40:11','PENJUALAN : FJ-260729-0022','.','TBC','1600000','1600000','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-260729-0021','D','2026-07-29','19:40:12','TBC','PENJUALAN','FJ-260729-0022','25518278564','1600000','25519878564','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='1600000' WHERE no_faktur_jual='FJ-260729-0022' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0022';
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-03153','ALIKA','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2280000','2250000','0','1200000','5700000','SIZE 9.5 GRF S ?? R CROM PUTIH','ZIRKON OVAL 1 BUTIR','ZIRKON KECIL 14 BUTIR','0','200000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260729-0021','2026-07-29','2026-07-29 19:54:57','PESANAN : DP-03153','.','TBC','4832000','4832000');
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-260729-0022','D','2026-07-29','19:54:57','TBC','PESANAN','DP-03153','25519878564','4832000','25524710564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','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-03153','2026-07-29','2026-07-29','19:54:57','PLG0013757','ALIKA','2026-08-27','kasir','2026-07-29 19:54:57','2.000','0','0','0','4832000','0','1200000','5900000','5900000','1068000');
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-260729-0023','sby','1',' DP-02864SB','TOKO','SBYPSN','PSPRT-ZGBH-34-0','CINCIN PERAK YL-10 ','','4.570','1','100.00','467000','0','0','17800','800000','0','0','0','800000','DIL','00045682','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.570',berat_jual_asli=berat_jual_asli+'4.570',stock_jual='1',berat_akhir=berat_akhir-'4.570',berat_akhir_asli=berat_akhir_asli-'4.570',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0023','2026-07-29','4.570','2026-07-29','20:06:25','PLG0013758','800000','800000','0','800000','0','sby','2026-07-29 20:06:24','FJ-260729-0023','DP-02864','800000');
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-29','FJ-260729-0023','2026-07-29','20:06:25','DIL','800000','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-260729-0023' 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-260729-0024','sby',' 1',' DP-02865SB','TOKO','SBYPSN','PSPRT-ZGBH-50-0','CINCIN PERAK ','','1.570','1','100.00','161000','0','0','17800','1000000','0','0','0','1000000','DIL','00045698','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0024','2026-07-29','1.570','2026-07-29','20:06:25','PLG0013759','1000000','1000000','0','1000000','0','sby','2026-07-29 20:06:24','FJ-260729-0023','DP-02865','1000000');
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-29','FJ-260729-0024','2026-07-29','20:06:25','DIL','1000000','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-260729-0024' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-29 ','20:27:18');
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-260729-0025','sby','1',' DP-02890SB','TOKO','SBYPSN','PSPRT-ZGBH-38-0','CINCIN PERAK ','','3.330','1','100.00','340000','0','0','17800','900000','0','0','0','900000','VAN','00045686','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.330',berat_jual_asli=berat_jual_asli+'3.330',stock_jual='1',berat_akhir=berat_akhir-'3.330',berat_akhir_asli=berat_akhir_asli-'3.330',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0025','2026-07-29','3.330','2026-07-29','20:30:02','PLG0013760','900000','900000','0','900000','0','sby','2026-07-29 20:30:02','FJ-260729-0025','DP-02890','900000');
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-29','FJ-260729-0025','2026-07-29','20:30:02','VAN','900000','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-260729-0025' 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-260729-0026','sby',' 1',' DP-02891SB','TOKO','SBYPSN','PSPRT-ZGBH-52-0','CINCIN PERAK ','','2.890','1','100.00','295000','0','0','17800','850000','0','0','0','850000','VAN','00045700','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-52-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-52-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0026','2026-07-29','2.890','2026-07-29','20:30:02','PLG0013761','850000','850000','0','850000','0','sby','2026-07-29 20:30:02','FJ-260729-0025','DP-02891','850000');
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-29','FJ-260729-0026','2026-07-29','20:30:02','VAN','850000','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-260729-0026' LIMIT 1;
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-03154','DIL','1','PER','WEDD RING PRIA','','','4.000','','925.00','1','100000','0','800000','0','800000','SIZE 28.5','CROM PUTIH DOFF MIX ROSE GOLD GLOSSY','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260729-0022','2026-07-29','2026-07-29 20:47:37','PESANAN : DP-03154','-','TBC','800000','800000');
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-260729-0023','D','2026-07-29','20:47:37','TBC','PESANAN','DP-03154','25524710564','800000','25525510564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','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-03154','2026-07-29','2026-07-29','20:47:37','PLG0013762','DIL','2026-08-08','sby','2026-07-29 20:47:37','4.000','0','0','0','800000','0','0','800000','800000','0');
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-260729-0027','kasirbip','1',' DP-03032BI','TOKO','BIPPSN','PSPRT-ZGBH-18-0','CINCIN PERAK SR-03 YL-01 ','','3.470','1','100.00','354000','0','0','17800','950000','0','0','0','950000','SULIS','00045666','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGBH-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPRT-ZGBH-18-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-260729-0027','2026-07-29','3.470','2026-07-29','21:03:17','PLG0013763','950000','950000','0','950000','0','kasirbip','2026-07-29 21:03:16','FJ-260729-0027','DP-03032','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-29','FJ-260729-0027','2026-07-29','21:03:17','SULIS','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-260729-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260729-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260729-0027';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-29 ','21:18:02');
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-260729-0028','sby','1',' DP-03054SB','TOKO','SBYPSN','PSPLT-ZGBH-35-0','CINCIN PALADIUM ','','3.890','1','32.00','1644000','0','0','17800','2900000','0','0','0','2900000','VAN','00045683','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGBH-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.890',berat_jual_asli=berat_jual_asli+'3.890',stock_jual='1',berat_akhir=berat_akhir-'3.890',berat_akhir_asli=berat_akhir_asli-'3.890',stock_akhir='0' WHERE tanggal='2026-07-29' AND kode_barang='PSPLT-ZGBH-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260729-0028','2026-07-29','3.890','2026-07-29','21:27:58','PLG0013764','2900000','2900000','0','2900000','0','sby','2026-07-29 21:27:58','FJ-260729-0028','DP-03054','2000000');
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-29','FJ-260729-0028','2026-07-29','21:27:58','VAN','2900000','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-260729-0023','2026-07-29','2026-07-29 21:27:58','PENJUALAN : FJ-260729-0028','','TBC','900000','900000','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-260729-0024','D','2026-07-29','21:27:58','TBC','PENJUALAN','FJ-260729-0028','25525510564','900000','25526410564','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='900000' WHERE no_faktur_jual='FJ-260729-0028' LIMIT 1;