INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','08:44:23');
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-20260831-0001','1','PMM-ZHCA-1-0','1','1.720','1.720','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:34' WHERE kode_barang='PMM-ZHCA-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:34','TOKO','MMPER','PMM','PMM-ZHCA-1-0','1','1.720','1.720','1','1.720','1.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-2-0','1','2.120','2.120','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:34' WHERE kode_barang='PMM-ZHCA-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:34','TOKO','MMPER','PMM','PMM-ZHCA-2-0','1','2.120','2.120','1','2.120','2.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-3-0','1','3.860','3.860','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-3-0','1','3.860','3.860','1','3.860','3.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-4-0','1','1.790','1.790','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-4-0','1','1.790','1.790','1','1.790','1.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-5-0','1','2.310','2.310','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-5-0','1','2.310','2.310','1','2.310','2.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-6-0','1','3.150','3.150','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-6-0','1','3.150','3.150','1','3.150','3.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-7-0','1','1.280','1.280','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-7-0','1','1.280','1.280','1','1.280','1.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-8-0','1','2.890','2.890','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-8-0','1','2.890','2.890','1','2.890','2.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-9-0','1','2.900','2.900','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-9-0','1','2.900','2.900','1','2.900','2.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-10-0','1','1.790','1.790','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-10-0','1','1.790','1.790','1','1.790','1.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-11-0','1','1.560','1.560','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-11-0','1','1.560','1.560','1','1.560','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' 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-20260831-0001','1','PMM-ZHCA-12-0','1','2.130','2.130','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZHCA-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZHCA-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZHCA-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-08-31 08:44:35' WHERE kode_barang='PMM-ZHCA-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZHCA-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-08-31 08:44:35','TOKO','MMPER','PMM','PMM-ZHCA-12-0','1','2.130','2.130','1','2.130','2.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-ZHCA-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZHCA-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-31' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260831-0001','2026-08-31','08:44','27.500','kasir','2026-08-31 08:44:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','08:45:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','10:00:57');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','10:14:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','10:15:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','10:45:13');
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-260831-0001','kasir','1',' 850K-115-1','TOKO','MMPER','PMM-ZHAI-31-0','CINCIN SILVER 925 ','','2.300','1','100.00','236000','0','0','17800','950000','0','0','0','950000','ALIKA','00046235','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAI-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PMM-ZHAI-31-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-260831-0001','2026-08-31','2.300','2026-08-31','10:46:43','PLG0015183','950000','950000','0','950000','0','kasir','2026-08-31 10:46:43','FJ-260831-0001','','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-08-31','FJ-260831-0001','2026-08-31','10:46:43','ALIKA','950000','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-260831-0001','2026-08-31','2026-08-31 10:46:43','PENJUALAN : FJ-260831-0001','.','TBC','950000','950000','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-260831-0002','D','2026-08-31','10:46:43','TBC','PENJUALAN','FJ-260831-0001','27100671064','950000','27101621064','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='950000' WHERE no_faktur_jual='FJ-260831-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-31 ','11:00:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-31 ','11:02:50');
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-03754','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 17.5 putih doff semprot sekeliling 1 zirkon','font brush script grf Abby 241026','model spert contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260831-0002','2026-08-31','2026-08-31 11:05:25','PESANAN : DP-03754','.','TBC','900000','900000');
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-260831-0003','D','2026-08-31','11:05:25','TBC','PESANAN','DP-03754','27101621064','900000','27102521064','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-03754','2026-08-31','2026-08-31','11:05:25','PLG0015184','KUR','2026-09-20','kasirbip','2026-08-31 11:05:25','3.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03755','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 13.5 putih doff semprot sekeliling 1zirkon','font brush script grf Ruben 241026','model sprt conth','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260831-0003','2026-08-31','2026-08-31 11:06:38','PESANAN : DP-03755','.','TBC','900000','900000');
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-260831-0004','D','2026-08-31','11:06:38','TBC','PESANAN','DP-03755','27102521064','900000','27103421064','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-03755','2026-08-31','2026-08-31','11:06:38','PLG0015185','KUR','2026-09-20','kasirbip','2026-08-31 11:06:38','2.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-31 ','11:45:59');
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-03756','DIL','1','PER','WEDD RING SR05','','','3.000','','925.00','1','100000','0','950000','0','950000','WANITA: SIZE 19 GRF: Chandra (INFI) FONT: VINTAGE','PRIA: SIZE 22 GRF: Yanti (NITY) FONT: VINTAGE','CROM ROSE GOLD GLOSSY FULL MIX PUTIH DOFF','100000','100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260831-0004','2026-08-31','2026-08-31 11:49:28','PESANAN : DP-03756','-','TBC','1150000','1150000');
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-260831-0005','D','2026-08-31','11:49:28','TBC','PESANAN','DP-03756','27103421064','1150000','27104571064','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-03756','2026-08-31','2026-08-31','11:49:28','PLG0015186','DIL','2026-09-25','sby','2026-08-31 11:49:28','3.000','0','0','0','1150000','0','0','1150000','1150000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','11:55:06');
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-260831-0002','kasirbip','1',' 900K-13-00','TOKO','DUPERBDG','LXPER-ZHBF-32-0','CINCIN SILVER 925 ','','1.320','1','100.00','135000','0','0','17800','1000000','0','0','0','1000000','NAD','00046538','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHBF-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='LXPER-ZHBF-32-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-260831-0002','2026-08-31','1.320','2026-08-31','12:29:54','PLG0015187','1000000','1000000','0','1000000','0','kasirbip','2026-08-31 12:29:54','FJ-260831-0002','','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-08-31','FJ-260831-0002','2026-08-31','12:29:54','NAD','1000000','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-260831-0005','2026-08-31','2026-08-31 12:29:54','PENJUALAN : FJ-260831-0002','.','TBC','1000000','1000000','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-260831-0006','D','2026-08-31','12:29:54','TBC','PENJUALAN','FJ-260831-0002','27104571064','1000000','27105571064','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='1000000' WHERE no_faktur_jual='FJ-260831-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-31 ','12:30:08');
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-260831-0003','sby','1',' DP-03284SB','TOKO','SBYPSN','PSPLT-ZHBH-11-0','CINCIN PALADIUM ','','3.910','1','32.00','1652000','0','0','17800','3011000','0','0','0','3011000','DIL','00046601','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBH-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PSPLT-ZHBH-11-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-260831-0003','2026-08-31','3.910','2026-08-31','12:31:53','PLG0015188','3011000','3011000','0','3011000','0','sby','2026-08-31 12:31:52','FJ-260831-0003','DP-03284','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-08-31','FJ-260831-0003','2026-08-31','12:31:53','DIL','3011000','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-260831-0006','2026-08-31','2026-08-31 12:31:52','PENJUALAN : FJ-260831-0003','','TBC','1011000','1011000','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-260831-0007','D','2026-08-31','12:31:53','TBC','PENJUALAN','FJ-260831-0003','27105571064','1011000','27106582064','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='1011000' WHERE no_faktur_jual='FJ-260831-0003' 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-03757','PUT','1','PLD','WEDDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwo 22.5 tidak pakai mata','grf Farah .... Rizal','font Vladimir','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-260831-0007','2026-08-31','2026-08-31 12:47:05','PESANAN : DP-03757','.','TBC','1440000','1440000');
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-260831-0008','D','2026-08-31','12:47:05','TBC','PESANAN','DP-03757','27106582064','1440000','27108022064','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-03757','2026-08-31','2026-08-31','12:47:05','PLG0015189','PUT','2026-09-24','kasirbip','2026-08-31 12:47:05','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-260831-0004','kasirbip','1',' 750K-18-27','TOKO','BIPPER','PBDG-ZGXF-37-0','CINCIN SILVER 925 ','','2.140','1','100.00','219000','0','0','17800','850000','0','0','0','850000','KUR','00044965','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PBDG-ZGXF-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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-260831-0004','2026-08-31','2.140','2026-08-31','13:02:56','PLG0015190','850000','850000','0','850000','0','kasirbip','2026-08-31 13:02:55','FJ-260831-0004','','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-08-31','FJ-260831-0004','2026-08-31','13:02:56','KUR','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-260831-0008','2026-08-31','2026-08-31 13:02:55','PENJUALAN : FJ-260831-0004','.','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-260831-0009','D','2026-08-31','13:02:56','TBC','PENJUALAN','FJ-260831-0004','27108022064','850000','27108872064','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-260831-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0004';
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-260831-0005','kasirbip','1',' 800K-135-0','TOKO','DUPERBDG','LXPER-ZHAX-10-0','CINCIN SILVER 925 ','','2.100','1','100.00','215000','0','0','17800','900000','0','0','0','900000','NAD','00046013','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAX-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='LXPER-ZHAX-10-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-260831-0005','2026-08-31','2.100','2026-08-31','13:09:29','PLG0015191','900000','900000','0','900000','0','kasirbip','2026-08-31 13:09:29','FJ-260831-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-31','FJ-260831-0005','2026-08-31','13:09:29','NAD','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-260831-0009','2026-08-31','2026-08-31 13:09:29','PENJUALAN : FJ-260831-0005','.','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-260831-0010','D','2026-08-31','13:09:29','TBC','PENJUALAN','FJ-260831-0005','27108872064','900000','27109772064','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-260831-0005' 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-260831-0006','kasirbip',' 1',' 800K-18-00','TOKO','DUPERBDG','LXPER-ZHAX-6-0','CINCIN SILVER 925 ','','3.160','1','100.00','323000','0','0','17800','900000','0','0','0','900000','NAD','00046009','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.160',berat_jual_asli=berat_jual_asli+'3.160',stock_jual='1',berat_akhir=berat_akhir-'3.160',berat_akhir_asli=berat_akhir_asli-'3.160',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='LXPER-ZHAX-6-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-260831-0006','2026-08-31','3.160','2026-08-31','13:09:29','PLG0015192','900000','900000','0','900000','0','kasirbip','2026-08-31 13:09:29','FJ-260831-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-31','FJ-260831-0006','2026-08-31','13:09:29','NAD','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-260831-0010','2026-08-31','2026-08-31 13:09:29','PENJUALAN : FJ-260831-0006','.','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-260831-0011','D','2026-08-31','13:09:29','TBC','PENJUALAN','FJ-260831-0006','27109772064','900000','27110672064','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='1800000' WHERE no_faktur_jual='FJ-260831-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0006';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-08-31 13:11:32');
CREATE TABLE th_20260831_131132 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260831_131132_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BIPCKB' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-08-31',jam_taking= '13:11:39',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BIPCKB' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-08-31',jam_taking= '13:11:44',input_by='kasir';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','13:12:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','13:27:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','13:29:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','13:29:40');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','1','BDCK-XIAF-10-0','1','2.63','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-10-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-10-0' , '1','2.63','2.63', '1','2.63','2.63','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.63',berat_out_asli=berat_out_asli+'2.63',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','2','BDCK-XIAF-12-0','1','2.81','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-12-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-12-0' , '1','2.81','2.81', '1','2.81','2.81','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.81',berat_out_asli=berat_out_asli+'2.81',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','3','BDCK-XIAF-13-0','1','3.43','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-13-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-13-0' , '1','3.43','3.43', '1','3.43','3.43','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.43',berat_out_asli=berat_out_asli+'3.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','4','BDCK-XIAF-14-0','1','2.57','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-14-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-14-0' , '1','2.57','2.57', '1','2.57','2.57','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.57',berat_out_asli=berat_out_asli+'2.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','5','BDCK-XIAF-15-0','1','2.6','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-15-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-15-0' , '1','2.6','2.6', '1','2.6','2.6','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.6',berat_out_asli=berat_out_asli+'2.6',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','6','BDCK-XIAF-16-0','1','2.43','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-16-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-16-0' , '1','2.43','2.43', '1','2.43','2.43','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.43',berat_out_asli=berat_out_asli+'2.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','7','BDCK-XIAF-18-0','1','3.3','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-18-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-18-0' , '1','3.3','3.3', '1','3.3','3.3','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.3',berat_out_asli=berat_out_asli+'3.3',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','8','BDCK-XIAF-19-0','1','3.25','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-19-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-19-0' , '1','3.25','3.25', '1','3.25','3.25','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.25',berat_out_asli=berat_out_asli+'3.25',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','9','BDCK-XIAF-20-0','1','3.44','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-20-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-20-0' , '1','3.44','3.44', '1','3.44','3.44','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.44',berat_out_asli=berat_out_asli+'3.44',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','10','BDCK-XIAF-3-0','1','3.02','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-3-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-3-0' , '1','3.02','3.02', '1','3.02','3.02','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.02',berat_out_asli=berat_out_asli+'3.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','11','BDCK-XIAF-5-0','1','3.93','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-5-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-5-0' , '1','3.93','3.93', '1','3.93','3.93','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.93',berat_out_asli=berat_out_asli+'3.93',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','12','BDCK-XIAF-6-0','1','3.85','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAF-6-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAF-6-0' , '1','3.85','3.85', '1','3.85','3.85','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.85',berat_out_asli=berat_out_asli+'3.85',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','13','BDCK-XIAH-11-0','1','1.98','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAH-11-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAH-11-0' , '1','1.98','1.98', '1','1.98','1.98','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.98',berat_out_asli=berat_out_asli+'1.98',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAH-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','14','BDCK-XIAH-7-0','1','3.31','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAH-7-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAH-7-0' , '1','3.31','3.31', '1','3.31','3.31','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.31',berat_out_asli=berat_out_asli+'3.31',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','15','BDCK-XIAH-9-0','1','3.72','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIAH-9-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIAH-9-0' , '1','3.72','3.72', '1','3.72','3.72','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.72',berat_out_asli=berat_out_asli+'3.72',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIAH-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','16','BDCK-XIBC-10-0','1','3.5','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-10-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-10-0' , '1','3.5','3.5', '1','3.5','3.5','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.5',berat_out_asli=berat_out_asli+'3.5',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','17','BDCK-XIBC-11-0','1','2.54','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-11-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-11-0' , '1','2.54','2.54', '1','2.54','2.54','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.54',berat_out_asli=berat_out_asli+'2.54',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','18','BDCK-XIBC-12-0','1','1.64','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-12-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-12-0' , '1','1.64','1.64', '1','1.64','1.64','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.64',berat_out_asli=berat_out_asli+'1.64',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','19','BDCK-XIBC-14-0','1','2.51','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-14-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-14-0' , '1','2.51','2.51', '1','2.51','2.51','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.51',berat_out_asli=berat_out_asli+'2.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','20','BDCK-XIBC-16-0','1','3.63','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-16-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-16-0' , '1','3.63','3.63', '1','3.63','3.63','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.63',berat_out_asli=berat_out_asli+'3.63',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','21','BDCK-XIBC-17-0','1','3.01','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-17-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-17-0' , '1','3.01','3.01', '1','3.01','3.01','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.01',berat_out_asli=berat_out_asli+'3.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','22','BDCK-XIBC-19-0','1','3.32','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-19-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-19-0' , '1','3.32','3.32', '1','3.32','3.32','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.32',berat_out_asli=berat_out_asli+'3.32',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','23','BDCK-XIBC-2-0','1','2.97','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-2-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-2-0' , '1','2.97','2.97', '1','2.97','2.97','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.97',berat_out_asli=berat_out_asli+'2.97',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','24','BDCK-XIBC-21-0','1','4.26','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-21-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-21-0' , '1','4.26','4.26', '1','4.26','4.26','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.26',berat_out_asli=berat_out_asli+'4.26',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','25','BDCK-XIBC-22-0','1','3.26','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-22-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-22-0' , '1','3.26','3.26', '1','3.26','3.26','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.26',berat_out_asli=berat_out_asli+'3.26',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','26','BDCK-XIBC-24-0','1','2.39','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-24-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-24-0' , '1','2.39','2.39', '1','2.39','2.39','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.39',berat_out_asli=berat_out_asli+'2.39',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','27','BDCK-XIBC-26-0','1','2.63','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-26-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-26-0' , '1','2.63','2.63', '1','2.63','2.63','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.63',berat_out_asli=berat_out_asli+'2.63',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','28','BDCK-XIBC-27-0','1','2.62','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-27-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-27-0' , '1','2.62','2.62', '1','2.62','2.62','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.62',berat_out_asli=berat_out_asli+'2.62',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','29','BDCK-XIBC-29-0','1','3.33','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-29-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-29-0' , '1','3.33','3.33', '1','3.33','3.33','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.33',berat_out_asli=berat_out_asli+'3.33',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','30','BDCK-XIBC-3-0','1','2.74','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-3-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-3-0' , '1','2.74','2.74', '1','2.74','2.74','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.74',berat_out_asli=berat_out_asli+'2.74',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','31','BDCK-XIBC-30-0','1','3.05','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-30-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-30-0' , '1','3.05','3.05', '1','3.05','3.05','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.05',berat_out_asli=berat_out_asli+'3.05',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','32','BDCK-XIBC-31-0','1','3.72','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-31-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-31-0' , '1','3.72','3.72', '1','3.72','3.72','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.72',berat_out_asli=berat_out_asli+'3.72',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','33','BDCK-XIBC-33-0','1','2.71','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-33-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-33-0' , '1','2.71','2.71', '1','2.71','2.71','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.71',berat_out_asli=berat_out_asli+'2.71',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','34','BDCK-XIBC-34-0','1','1.79','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-34-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-34-0' , '1','1.79','1.79', '1','1.79','1.79','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.79',berat_out_asli=berat_out_asli+'1.79',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','35','BDCK-XIBC-36-0','1','2.68','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-36-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-36-0' , '1','2.68','2.68', '1','2.68','2.68','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.68',berat_out_asli=berat_out_asli+'2.68',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','36','BDCK-XIBC-5-0','1','2.12','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-5-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-5-0' , '1','2.12','2.12', '1','2.12','2.12','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.12',berat_out_asli=berat_out_asli+'2.12',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','37','BDCK-XIBC-6-0','1','2.11','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-6-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-6-0' , '1','2.11','2.11', '1','2.11','2.11','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.11',berat_out_asli=berat_out_asli+'2.11',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','38','BDCK-XIBC-7-0','1','1.4','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBC-7-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBC-7-0' , '1','1.4','1.4', '1','1.4','1.4','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.4',berat_out_asli=berat_out_asli+'1.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','39','BDCK-XIBE-17-0','1','3.93','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBE-17-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBE-17-0' , '1','3.93','3.93', '1','3.93','3.93','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.93',berat_out_asli=berat_out_asli+'3.93',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBE-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','40','BDCK-XIBE-24-0','1','3.58','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBE-24-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBE-24-0' , '1','3.58','3.58', '1','3.58','3.58','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.58',berat_out_asli=berat_out_asli+'3.58',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBE-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','41','BDCK-XIBG-10-0','1','2.2','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBG-10-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBG-10-0' , '1','2.2','2.2', '1','2.2','2.2','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.2',berat_out_asli=berat_out_asli+'2.2',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBG-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','42','BDCK-XIBG-11-0','1','2.51','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBG-11-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBG-11-0' , '1','2.51','2.51', '1','2.51','2.51','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.51',berat_out_asli=berat_out_asli+'2.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','43','BDCK-XIBG-13-0','1','3.4','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBG-13-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBG-13-0' , '1','3.4','3.4', '1','3.4','3.4','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.4',berat_out_asli=berat_out_asli+'3.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','44','BDCK-XIBG-17-0','1','3.29','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBG-17-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBG-17-0' , '1','3.29','3.29', '1','3.29','3.29','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.29',berat_out_asli=berat_out_asli+'3.29',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','45','BDCK-XIBG-19-0','1','3.28','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBG-19-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBG-19-0' , '1','3.28','3.28', '1','3.28','3.28','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.28',berat_out_asli=berat_out_asli+'3.28',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBG-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','46','BDCK-XIBG-9-0','1','2.79','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIBG-9-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIBG-9-0' , '1','2.79','2.79', '1','2.79','2.79','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.79',berat_out_asli=berat_out_asli+'2.79',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIBG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','47','BDCK-XICX-7-0','1','2.48','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XICX-7-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XICX-7-0' , '1','2.48','2.48', '1','2.48','2.48','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.48',berat_out_asli=berat_out_asli+'2.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XICX-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','48','BDCK-XIXE-17-0','1','3.01','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIXE-17-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIXE-17-0' , '1','3.01','3.01', '1','3.01','3.01','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.01',berat_out_asli=berat_out_asli+'3.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIXE-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','49','BDCK-XIXE-18-0','1','4.21','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIXE-18-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIXE-18-0' , '1','4.21','4.21', '1','4.21','4.21','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.21',berat_out_asli=berat_out_asli+'4.21',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIXE-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','50','BDCK-XIXE-19-0','1','3.18','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIXE-19-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIXE-19-0' , '1','3.18','3.18', '1','3.18','3.18','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.18',berat_out_asli=berat_out_asli+'3.18',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIXE-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','51','BDCK-XIXE-22-0','1','3.51','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XIXE-22-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XIXE-22-0' , '1','3.51','3.51', '1','3.51','3.51','103.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.51',berat_out_asli=berat_out_asli+'3.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XIXE-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','52','BDCK-XJXB-28-0','1','3.18','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XJXB-28-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XJXB-28-0' , '1','3.18','3.18', '1','3.18','3.18','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.18',berat_out_asli=berat_out_asli+'3.18',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XJXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','53','BDCK-XJXC-4-0','1','3.12','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XJXC-4-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XJXC-4-0' , '1','3.12','3.12', '1','3.12','3.12','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.12',berat_out_asli=berat_out_asli+'3.12',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XJXC-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','54','BDCK-XJXH-26-0','1','2.56','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-XJXH-26-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-XJXH-26-0' , '1','2.56','2.56', '1','2.56','2.56','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.56',berat_out_asli=berat_out_asli+'2.56',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-XJXH-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','55','BDCK-YBAA-14-0','1','1.78','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-14-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-14-0' , '1','1.78','1.78', '1','1.78','1.78','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.78',berat_out_asli=berat_out_asli+'1.78',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','56','BDCK-YBAA-2-0','1','1.97','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-2-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-2-0' , '1','1.97','1.97', '1','1.97','1.97','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.97',berat_out_asli=berat_out_asli+'1.97',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','57','BDCK-YBAA-3-0','1','1.78','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-3-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-3-0' , '1','1.78','1.78', '1','1.78','1.78','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.78',berat_out_asli=berat_out_asli+'1.78',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','58','BDCK-YBAA-4-0','1','2.41','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-4-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-4-0' , '1','2.41','2.41', '1','2.41','2.41','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.41',berat_out_asli=berat_out_asli+'2.41',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','59','BDCK-YBAA-5-0','1','2.3','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-5-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-5-0' , '1','2.3','2.3', '1','2.3','2.3','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.3',berat_out_asli=berat_out_asli+'2.3',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','60','BDCK-YBAA-7-0','1','1.63','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-7-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-7-0' , '1','1.63','1.63', '1','1.63','1.63','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.63',berat_out_asli=berat_out_asli+'1.63',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','61','BDCK-YBAA-9-0','1','1.71','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBAA-9-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBAA-9-0' , '1','1.71','1.71', '1','1.71','1.71','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.71',berat_out_asli=berat_out_asli+'1.71',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBAA-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','62','BDCK-YBBE-1-0','1','4.13','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBBE-1-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBBE-1-0' , '1','4.13','4.13', '1','4.13','4.13','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.13',berat_out_asli=berat_out_asli+'4.13',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBBE-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','63','BDCK-YBBE-2-0','1','1.54','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBBE-2-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBBE-2-0' , '1','1.54','1.54', '1','1.54','1.54','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.54',berat_out_asli=berat_out_asli+'1.54',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBBE-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','64','BDCK-YBBE-3-0','1','2.53','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBBE-3-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBBE-3-0' , '1','2.53','2.53', '1','2.53','2.53','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.53',berat_out_asli=berat_out_asli+'2.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBBE-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','65','BDCK-YBBE-4-0','1','2.24','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YBBE-4-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YBBE-4-0' , '1','2.24','2.24', '1','2.24','2.24','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.24',berat_out_asli=berat_out_asli+'2.24',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YBBE-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','66','BDCK-YGAH-7-0','1','2.09','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YGAH-7-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YGAH-7-0' , '1','2.09','2.09', '1','2.09','2.09','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.09',berat_out_asli=berat_out_asli+'2.09',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YGAH-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','67','BDCK-YIAX-8-0','1','1.4','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YIAX-8-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YIAX-8-0' , '1','1.4','1.4', '1','1.4','1.4','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.4',berat_out_asli=berat_out_asli+'1.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YIAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','68','BDCK-YJAC-15-0','1','3.06','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YJAC-15-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YJAC-15-0' , '1','3.06','3.06', '1','3.06','3.06','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.06',berat_out_asli=berat_out_asli+'3.06',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YJAC-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','69','BDCK-YJAC-16-0','1','2.75','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YJAC-16-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YJAC-16-0' , '1','2.75','2.75', '1','2.75','2.75','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.75',berat_out_asli=berat_out_asli+'2.75',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YJAC-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260831-0001','70','BDCK-YJAC-17-0','1','1.7','0','TOKO','BIPCKB','TOKO','BIPSEM');
UPDATE tm_barang SET berat_bandrol='0.014', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'BIPSEM' WHERE kode_barang = 'BDCK-YJAC-17-0' AND kode_lokasi_toko = 'BIPCKB';
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-08-31','TOKO','BIPSEM','BDCK','BDCK-YJAC-17-0' , '1','1.7','1.7', '1','1.7','1.7','83.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.7',berat_out_asli=berat_out_asli+'1.7',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='BDCK-YJAC-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='BIPCKB' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260831-0001','2026-08-31','2026-08-31','13:31','195.45','kasir','2026-08-31 13:31:36');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-08-31 13:33:56');
CREATE TABLE th_20260831_133356 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260831_133356_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BIPCMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2026-08-31',jam_taking= '13:34:06',input_by='kasir';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-31 ','13:34:18');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2026-08-31 13:35:08');
CREATE TABLE th_20260831_133508 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20260831_133508_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','14:03:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','14:12: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-260831-0007','kasir','1',' 700K-11-00','TOKO','MMPER','PMM-YGXG-5-0','CINCIN SILVER 925 ','','2.370','1','100.00','55000','0','0','17800','850000','0','0','0','850000','ALIKA','00036999','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXG-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.370',berat_jual_asli=berat_jual_asli+'2.370',stock_jual='1',berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PMM-YGXG-5-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-260831-0007','2026-08-31','2.370','2026-08-31','14:14:44','PLG0015193','850000','850000','0','850000','0','kasir','2026-08-31 14:14:43','FJ-260831-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-08-31','FJ-260831-0007','2026-08-31','14:14:44','ALIKA','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-260831-0011','2026-08-31','2026-08-31 14:14:43','PENJUALAN : FJ-260831-0007','0','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-260831-0012','D','2026-08-31','14:14:44','TBC','PENJUALAN','FJ-260831-0007','27110672064','850000','27111522064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
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-260831-0007' 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-260831-0008','kasir','1',' 750K-17-11','TOKO','MMPER','PMM-ZGCX-69-0','CINCIN SILVER 925 ','','2.490','1','100.00','255000','0','0','17800','900000','0','0','0','900000','ALIKA','00045797','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGCX-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PMM-ZGCX-69-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-260831-0008','2026-08-31','2.490','2026-08-31','14:21:33','PLG0015194','900000','900000','0','900000','0','kasir','2026-08-31 14:21:32','FJ-260831-0008','','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-08-31','FJ-260831-0008','2026-08-31','14:21:33','ALIKA','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-260831-0012','2026-08-31','2026-08-31 14:21:32','PENJUALAN : FJ-260831-0008','0','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-260831-0013','D','2026-08-31','14:21:33','TBC','PENJUALAN','FJ-260831-0008','27111522064','900000','27112422064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
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-260831-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-260831-0009','sby','1',' DP-03281SB','TOKO','SBYPSN','PSPRT-ZHBH-97-0','CINCIN PERAK ','','3.200','1','100.00','327000','0','0','17800','800000','0','0','0','800000','DIL','00046687','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBH-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PSPRT-ZHBH-97-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-260831-0009','2026-08-31','3.200','2026-08-31','14:23:17','PLG0015195','800000','800000','0','800000','0','sby','2026-08-31 14:23:17','FJ-260831-0009','DP-03281','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-08-31','FJ-260831-0009','2026-08-31','14:23:17','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-260831-0009' 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-03758','ALIKA','1','PER','WEDING RING','','','4.000','','925.00','1','100000','0','0','0','900000','size 23 grf Messi','crom putih doff semprot','zircone 1 btr','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-260831-0013','2026-08-31','2026-08-31 14:26:58','PESANAN : DP-03758','0','TBC','900000','900000');
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-260831-0014','D','2026-08-31','14:26:58','TBC','PESANAN','DP-03758','27112422064','900000','27113322064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03758','2026-08-31','2026-08-31','14:26:58','PLG0015196','ALIKA','2026-09-26','kasir','2026-08-31 14:26:58','4.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','14:27:45');
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-03759','VAN','1','GOLD','WEDDRING WANITA','','','2.000','','37.50','1','2400000','1400000','0','700000','3500000','PERMATA 3','SIZE:16 GRF:Yadi??','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-260831-0014','2026-08-31','2026-08-31 14:52:21','PESANAN : DP-03759','-','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-260831-0015','D','2026-08-31','14:52:21','TBC','PESANAN','DP-03759','27113322064','2400000','27115722064','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-03759','2026-08-31','2026-08-31','14:52:21','PLG0015197','VAN','2026-09-24','sby','2026-08-31 14:52:21','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-03760','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','SIZE:13.5','GRF: Pipin??','FONT:VINTAGE PUTIH GLOSY','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-260831-0015','2026-08-31','2026-08-31 14:55:20','PESANAN : DP-03760','-','TBC','1500000','1500000');
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-260831-0016','D','2026-08-31','14:55:20','TBC','PESANAN','DP-03760','27115722064','1500000','27117222064','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-03760','2026-08-31','2026-08-31','14:55:20','PLG0015198','VAN','2026-09-24','sby','2026-08-31 14:55:20','4.000','0','0','0','1500000','0','750000','2150000','2150000','650000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-08-31 ','15:10:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-31 ','17:19:21');
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-260831-0010','sby','1',' DP-03323SB','TOKO','SBYPSN','PSPLT-ZHBH-67-0','CINCIN PALADIUM YL01 ','','2.160','1','17.00','486000','0','0','17800','1456000','0','0','0','1456000','DIL','00046657','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBH-67-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PSPLT-ZHBH-67-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-260831-0010','2026-08-31','2.160','2026-08-31','17:25:44','PLG0015199','1456000','1456000','0','1456000','0','sby','2026-08-31 17:25:43','FJ-260831-0010','DP-03323','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-08-31','FJ-260831-0010','2026-08-31','17:25:44','DIL','1456000','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-260831-0016','2026-08-31','2026-08-31 17:25:43','PENJUALAN : FJ-260831-0010','','TBC','1456000','1456000','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-260831-0017','D','2026-08-31','17:25:44','TBC','PENJUALAN','FJ-260831-0010','27117222064','1456000','27118678064','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='1456000' WHERE no_faktur_jual='FJ-260831-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-260831-0011','sby',' 1',' DP-03324SB','TOKO','SBYPSN','PSGT-ZHBH-8-0','CINCIN EMAS ','','2.270','1','57.00','3168000','0','0','17800','5456000','0','0','0','5456000','DIL','00046598','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHBH-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PSGT-ZHBH-8-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-260831-0011','2026-08-31','2.270','2026-08-31','17:25:44','PLG0015200','5456000','5456000','0','5456000','0','sby','2026-08-31 17:25:43','FJ-260831-0010','DP-03324','3200000');
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-08-31','FJ-260831-0011','2026-08-31','17:25:44','DIL','5456000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1456000' WHERE no_faktur_jual='FJ-260831-0011' 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-02229','SAL','1','SEPASANG PLD','CUCI KROM PUTIH GLOSSY KEDUANYA','4.000','1','100000','100000');
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-260831-0017','2026-08-31','2026-08-31 18:13:49','SERVICE : SV-02229','.','TBC','100000','100000','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-260831-0018','D','2026-08-31','18:13:49','TBC','SERVICE','SV-02229','27118678064','100000','27118778064','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-02229','2026-08-31','2026-08-31','18:13:49','PLG0015201','kasirbip','2026-09-12','kasirbip','2026-08-31 18:13:49','4.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-31 ','18:14:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-31 ','18:18:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-31 ','18:34:26');
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-03761','PUT','1','PER','WEDDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwe 10 grf Fiola','sz cwo 23 grf Deris','font','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-260831-0018','2026-08-31','2026-08-31 18:38:41','PESANAN : DP-03761','.','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-260831-0019','D','2026-08-31','18:38:41','TBC','PESANAN','DP-03761','27118778064','850000','27119628064','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-03761','2026-08-31','2026-08-31','18:38:41','PLG0015202','PUT','2026-09-24','kasirbip','2026-08-31 18:38:41','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-31 ','18:43:10');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260831-0012','jogja','1',' 500K-23-00','TOKO','JOGPER','PJOG-ZHBF-45-0','CINCIN SILVER 925 YL01 ','','2.160','1','100.00','221000','0','0','17800','750000','0','0','0','750000','ADL','00046551','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZHBF-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PJOG-ZHBF-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-260831-0012','2026-08-31','2.160','2026-08-31','18:49:26','PLG0015203','750000','750000','0','750000','0','jogja','2026-08-31 18:49:26','FJ-260831-0012','','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-08-31','FJ-260831-0012','2026-08-31','18:49:26','ADL','750000','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-260831-0019','2026-08-31','2026-08-31 18:49:26','PENJUALAN : FJ-260831-0012','','TBC','750000','750000','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-260831-0020','D','2026-08-31','18:49:26','TBC','PENJUALAN','FJ-260831-0012','27119628064','750000','27120378064','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='750000' WHERE no_faktur_jual='FJ-260831-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-260831-0013','jogja',' 1',' 800K-95-00','TOKO','JOGPER','PJOG-ZFAX-89-0','CINCIN SILVER 925 ','','2.260','1','100.00','232000','0','0','17800','850000','0','0','0','850000','ADL','00044194','PJOG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAX-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PJOG-ZFAX-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-260831-0013','2026-08-31','2.260','2026-08-31','18:49:26','PLG0015204','850000','850000','0','850000','0','jogja','2026-08-31 18:49:26','FJ-260831-0012','','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-08-31','FJ-260831-0013','2026-08-31','18:49:26','ADL','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-260831-0020','2026-08-31','2026-08-31 18:49:26','PENJUALAN : FJ-260831-0013','','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-260831-0021','D','2026-08-31','18:49:26','TBC','PENJUALAN','FJ-260831-0013','27120378064','850000','27121228064','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-260831-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0012';
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-260831-0014','kasir','1',' DP-03241MM','TOKO','MMPSN','PSPRT-ZHBH-83-0','CINCIN PERAK SR01 YL01 ','','3.050','1','100.00','312000','0','0','17800','950000','0','0','0','950000','ELLA','00046673','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBH-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PSPRT-ZHBH-83-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-260831-0014','2026-08-31','3.050','2026-08-31','19:21:49','PLG0015205','950000','950000','0','950000','0','kasir','2026-08-31 19:21:49','FJ-260831-0014','DP-03241','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-08-31','FJ-260831-0014','2026-08-31','19:21:49','ELLA','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-260831-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-260831-0015','kasirbip','1',' 800K-17-00','TOKO','DUPERBDG','LXPER-ZEAB-7-0','CINCIN SILVER 925 ','','4.060','1','100.00','415000','0','0','17800','900000','0','0','0','900000','PUT','00043474','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='LXPER-ZEAB-7-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-260831-0015','2026-08-31','4.060','2026-08-31','19:26:50','PLG0015206','900000','900000','0','900000','0','kasirbip','2026-08-31 19:26:50','FJ-260831-0015','','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-08-31','FJ-260831-0015','2026-08-31','19:26:50','PUT','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-260831-0021','2026-08-31','2026-08-31 19:26:50','PENJUALAN : FJ-260831-0015','.','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-260831-0022','D','2026-08-31','19:26:50','TBC','PENJUALAN','FJ-260831-0015','27121228064','900000','27122128064','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-260831-0015' 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-260831-0016','kasirbip','1',' DP-03634DU','TOKO','DUPSN','PSPLT-ZHBH-91-0','CINCIN PALADIUM ','','1.920','1','17.00','432000','0','0','17800','1572000','0','0','0','1572000','PUT','00046681','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBH-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-08-31' AND kode_barang='PSPLT-ZHBH-91-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-260831-0016','2026-08-31','1.920','2026-08-31','19:28:44','PLG0015207','1572000','1572000','0','1572000','0','kasirbip','2026-08-31 19:28:43','FJ-260831-0016','DP-03634','1420000');
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-08-31','FJ-260831-0016','2026-08-31','19:28:44','PUT','1572000','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-260831-0022','2026-08-31','2026-08-31 19:28:43','PENJUALAN : FJ-260831-0016','.','TBC','152000','152000','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-260831-0023','D','2026-08-31','19:28:44','TBC','PENJUALAN','FJ-260831-0016','27122128064','152000','27122280064','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='152000' WHERE no_faktur_jual='FJ-260831-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260831-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260831-0016';
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-03762','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 14 GRF: BY WA','CROM ROSE GLOSSY FULL','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-260831-0023','2026-08-31','2026-08-31 20:26:46','PESANAN : DP-03762','-','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-260831-0024','D','2026-08-31','20:26:46','TBC','PESANAN','DP-03762','27122280064','850000','27123130064','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-03762','2026-08-31','2026-08-31','20:26:46','PLG0015208','DIL','2026-09-24','sby','2026-08-31 20:26:46','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-31';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-08-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-09-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-31' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','TBC','SALDO AWAL','SALDO AWAL','0','27123130064','27123130064');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','BCD','SALDO AWAL','SALDO AWAL','0','1455519500','1455519500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','','SALDO AWAL','SALDO AWAL','0','250000','250000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260901-0001','D','2026-09-01','21:05:18','BCK','SALDO AWAL','SALDO AWAL','0','2017408000','2017408000');
UPDATE tp_system SET tgl_system='2026-09-01';