INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','08:10:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','08:32:47');
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-20260902-0001','1','PMM-ZIXA-21-0','1','2.730','2.730','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIXA-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIXA-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIXA-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-02 08:33:01' WHERE kode_barang='PMM-ZIXA-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIXA-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 08:33:01','TOKO','MMPER','PMM','PMM-ZIXA-21-0','1','2.730','2.730','1','2.730','2.730','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-ZIXA-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0001','1','PMM-ZIXA-22-0','1','2.300','2.300','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIXA-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIXA-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIXA-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-02 08:33:01' WHERE kode_barang='PMM-ZIXA-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIXA-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 08:33:01','TOKO','MMPER','PMM','PMM-ZIXA-22-0','1','2.300','2.300','1','2.300','2.300','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-ZIXA-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0001','1','PMM-ZIXA-23-0','1','1.480','1.480','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIXA-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIXA-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIXA-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-02 08:33:01' WHERE kode_barang='PMM-ZIXA-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIXA-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 08:33:01','TOKO','MMPER','PMM','PMM-ZIXA-23-0','1','1.480','1.480','1','1.480','1.480','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-ZIXA-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0001','1','PMM-ZIXA-24-0','1','1.460','1.460','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIXA-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIXA-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIXA-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-02 08:33:01' WHERE kode_barang='PMM-ZIXA-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIXA-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 08:33:01','TOKO','MMPER','PMM','PMM-ZIXA-24-0','1','1.460','1.460','1','1.460','1.460','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-ZIXA-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0001','1','PMM-ZIXA-25-0','1','1.790','1.790','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-ZIXA-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-ZIXA-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-ZIXA-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2026-09-02 08:33:01' WHERE kode_barang='PMM-ZIXA-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-ZIXA-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 08:33:01','TOKO','MMPER','PMM','PMM-ZIXA-25-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-ZIXA-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZIXA-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:32','9.760','kasir','2026-09-02 08:33:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-02 ','08:54:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-02 ','09:33:10');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBAA-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBAA-7-0','BDCK-YBAA-7-0','00034073','RD','1','0.035','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBAA-7-0','00034073','RD','1','0.035','400','14')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBAA-7-0','BDCK-YBAA-7-0','00034073','RD','2','0.015','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBAA-7-0','00034073','RD','2','0.015','400','6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBAA-7-0','00034073','00034073','CINCIN KAWIN BDCK-00094','CINCIN KAWIN BDCK-00094','','','3247000','3247000',' 0','0','spv','2026-09-02 09:38:08');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00094' ,nama_atribut='' ,kode_intern='BDCK-00094 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RESIN 125 0226',total_usd_ext='IDR 17 000 000',total_usd='20' WHERE kode_barang='BDCK-YBAA-7-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','09:38:58');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIAH-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAH-7-0','BDCK-XIAH-7-0','00031333','RD','7','0.055','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAH-7-0','00031333','RD','7','0.055','400','22')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIAH-7-0','00031333','00031333','CINCIN KAWIN BDCK-00024','CINCIN KAWIN BDCK-00024','','','6594000','6594000',' 0','0','spv','2026-09-02 09:39:38');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00024' ,nama_atribut='' ,kode_intern='BDCK-00024 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='KCK114 14 0226',total_usd_ext='IDR 31 000 000',total_usd='22' WHERE kode_barang='BDCK-XIAH-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-16-0','BDCK-XIBC-16-0','00031396','RD','2','0.020','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-16-0','00031396','RD','2','0.020','400','8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-16-0','00031396','00031396','CINCIN KAWIN BDCK-00043','CINCIN KAWIN BDCK-00043','','','7231000','7231000',' 0','0','spv','2026-09-02 09:41:12');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00043' ,nama_atribut='' ,kode_intern='BDCK-00043 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='CK263 19 0226',total_usd_ext='IDR 32 000 000',total_usd='8' WHERE kode_barang='BDCK-XIBC-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIXE-17-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-17-0','BDCK-XIXE-17-0','00031112','RD','9','0.060','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-17-0','00031112','RD','9','0.060','400','24')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIXE-17-0','00031112','00031112','CINCIN KAWIN BDCK-00002','CINCIN KAWIN BDCK-00002','','','5996000','5996000',' 0','0','spv','2026-09-02 09:42:47');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00002' ,nama_atribut='' ,kode_intern='BDCK-00002 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='BTM013 13 0226',total_usd_ext='IDR 28 500 000',total_usd='24' WHERE kode_barang='BDCK-XIXE-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XICX-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XICX-7-0','BDCK-XICX-7-0','00031514','RD','17','0.100','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XICX-7-0','00031514','RD','17','0.100','400','40')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XICX-7-0','00031514','00031514','CINCIN KAWIN BDCK-00082','CINCIN KAWIN BDCK-00082','','','4940500','4940500',' 0','0','spv','2026-09-02 09:44:03');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00082' ,nama_atribut='' ,kode_intern='BDCK-00082 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 0226',total_usd_ext='IDR 25 500 000',total_usd='40' WHERE kode_barang='BDCK-XICX-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-14-0','BDCK-XIBC-14-0','00031394','RD','1','0.040','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-14-0','00031394','RD','1','0.040','400','16')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-14-0','00031394','00031394','CINCIN KAWIN BDCK-00041','CINCIN KAWIN BDCK-00041','','','5000000','5000000',' 0','0','spv','2026-09-02 09:45:27');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00041' ,nama_atribut='' ,kode_intern='BDCK-00041 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='KCK156 11 0226',total_usd_ext='IDR 24 000 000',total_usd='16' WHERE kode_barang='BDCK-XIBC-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIAH-9-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAH-9-0','BDCK-XIAH-9-0','00031335','RD','1','0.100','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAH-9-0','00031335','RD','1','0.100','600','60')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIAH-9-0','00031335','00031335','CINCIN KAWIN BDCK-00026','CINCIN KAWIN BDCK-00026','','','7410500','7410500',' 0','0','spv','2026-09-02 09:47:07');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00026' ,nama_atribut='' ,kode_intern='BDCK-00026 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 19 0226',total_usd_ext='IDR 37 000 000',total_usd='60' WHERE kode_barang='BDCK-XIAH-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBAA-2-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBAA-2-0','BDCK-YBAA-2-0','00034068','RD','7','0.365','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBAA-2-0','00034068','RD','7','0.365','475','173.38')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBAA-2-0','00034068','00034068','CINCIN KAWIN BDCK-00089','CINCIN KAWIN BDCK-00089','','','3924500','3924500',' 0','0','spv','2026-09-02 09:48:26');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00089' ,nama_atribut='' ,kode_intern='BDCK-00089 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX071 12 0226',total_usd_ext='IDR 31 000 000',total_usd='173.38' WHERE kode_barang='BDCK-YBAA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XJXB-28-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XJXB-28-0','BDCK-XJXB-28-0','00031584','RD','1','0.080','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XJXB-28-0','00031584','RD','1','0.080','400','32')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XJXB-28-0','BDCK-XJXB-28-0','00031584','RD','22','0.125','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XJXB-28-0','00031584','RD','22','0.125','400','50')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XJXB-28-0','00031584','00031584','CINCIN KAWIN BDCK-00085','CINCIN KAWIN BDCK-00085','','','6335000','6335000',' 0','0','spv','2026-09-02 09:50:37');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00085' ,nama_atribut='' ,kode_intern='BDCK-00085 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 5 0226',total_usd_ext='IDR 36 000 000',total_usd='82' WHERE kode_barang='BDCK-XJXB-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIAF-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-15-0','BDCK-XIAF-15-0','00031279','RD','1','0.100','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-15-0','00031279','RD','1','0.100','600','60')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-15-0','BDCK-XIAF-15-0','00031279','RD','16','0.135','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-15-0','00031279','RD','16','0.135','400','54')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIAF-15-0','00031279','00031279','CINCIN KAWIN BDCK-00016','CINCIN KAWIN BDCK-00016','','','5179500','5179500',' 0','0','spv','2026-09-02 09:51:57');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00016' ,nama_atribut='' ,kode_intern='BDCK-00016 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 0226',total_usd_ext='IDR 32 500 000',total_usd='114' WHERE kode_barang='BDCK-XIAF-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-30-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-30-0','BDCK-XIBC-30-0','00031410','RD','9','0.065','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-30-0','00031410','RD','9','0.065','400','26')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-30-0','00031410','00031410','CINCIN KAWIN BDCK-00057','CINCIN KAWIN BDCK-00057','','','6076000','6076000',' 0','0','spv','2026-09-02 10:24:57');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00057' ,nama_atribut='' ,kode_intern='BDCK-00057 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 0226',total_usd_ext='IDR 29 000 000',total_usd='26' WHERE kode_barang='BDCK-XIBC-30-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-02 ','10:25:24');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YJAC-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YJAC-16-0','BDCK-YJAC-16-0','00039193','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YJAC-16-0','00039193','RD','1','0.025','420','10.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YJAC-16-0','00039193','00039193','CINCIN KAWIN BDCK-00112','CINCIN KAWIN BDCK-00112','','','5478000','5478000',' 0','0','spv','2026-09-02 10:28:32');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00112' ,nama_atribut='' ,kode_intern='BDCK-00112 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 0226',total_usd_ext='IDR 25 000 000',total_usd='10.5' WHERE kode_barang='BDCK-YJAC-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-21-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-21-0','BDCK-XIBC-21-0','00031401','RD','3','0.035','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-21-0','00031401','RD','3','0.035','400','14')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-21-0','00031401','00031401','CINCIN KAWIN BDCK-00048','CINCIN KAWIN BDCK-00048','','','8486000','8486000',' 0','0','spv','2026-09-02 10:29:45');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00048' ,nama_atribut='' ,kode_intern='BDCK-00048 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX048 13 5 0226',total_usd_ext='IDR 38 000 000',total_usd='14' WHERE kode_barang='BDCK-XIBC-21-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-02 ','10:30:55');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBG-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBG-13-0','BDCK-XIBG-13-0','00031498','RD','1','0.100','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBG-13-0','00031498','RD','1','0.100','600','60')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBG-13-0','00031498','00031498','CINCIN KAWIN BDCK-00075','CINCIN KAWIN BDCK-00075','','','6773000','6773000',' 0','0','spv','2026-09-02 10:31:14');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00075' ,nama_atribut='' ,kode_intern='BDCK-00075 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='WRE001 13 0226',total_usd_ext='IDR 34 500 000',total_usd='60' WHERE kode_barang='BDCK-XIBG-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBE-17-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBE-17-0','BDCK-XIBE-17-0','00031454','RD','1','0.105','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBE-17-0','00031454','RD','1','0.105','600','63')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBE-17-0','00031454','00031454','CINCIN KAWIN BDCK-00064','CINCIN KAWIN BDCK-00064','','','7829000','7829000',' 0','0','spv','2026-09-02 10:33:08');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00064' ,nama_atribut='' ,kode_intern='BDCK-00064 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX047 14 0226',total_usd_ext='IDR 39 000 000',total_usd='63' WHERE kode_barang='BDCK-XIBE-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-3-0','BDCK-XIBC-3-0','00031383','RD','1','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-3-0','00031383','RD','1','0.060','450','27')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-3-0','00031383','00031383','CINCIN KAWIN BDCK-00030','CINCIN KAWIN BDCK-00030','','','5458500','5458500',' 0','0','spv','2026-09-02 10:35:22');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00030' ,nama_atribut='' ,kode_intern='BDCK-00030 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C294 13 0226',total_usd_ext='IDR 26 500 000',total_usd='27' WHERE kode_barang='BDCK-XIBC-3-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','10:37:58');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBAA-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBAA-3-0','BDCK-YBAA-3-0','00034069','RD','12','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBAA-3-0','00034069','RD','12','0.060','450','27')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBAA-3-0','00034069','00034069','CINCIN KAWIN BDCK-00090','CINCIN KAWIN BDCK-00090','','','3546000','3546000',' 0','0','spv','2026-09-02 10:38:25');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00090' ,nama_atribut='' ,kode_intern='BDCK-00090 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX086 12 0226',total_usd_ext='IDR 18 500 000',total_usd='27' WHERE kode_barang='BDCK-YBAA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YJAC-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YJAC-15-0','BDCK-YJAC-15-0','00039192','RD','1','0.090','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YJAC-15-0','00039192','RD','1','0.090','600','54')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YJAC-15-0','00039192','00039192','CINCIN KAWIN BDCK-00111','CINCIN KAWIN BDCK-00111','','','6096000','6096000',' 0','0','spv','2026-09-02 10:39:33');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00111' ,nama_atribut='' ,kode_intern='BDCK-00111 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 5 0226',total_usd_ext='IDR 31 000 000',total_usd='54' WHERE kode_barang='BDCK-YJAC-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-31-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-31-0','BDCK-XIBC-31-0','00031411','RD','1','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-31-0','00031411','RD','1','0.075','450','33.75')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-31-0','00031411','00031411','CINCIN KAWIN BDCK-00058','CINCIN KAWIN BDCK-00058','','','7410500','7410500',' 0','0','spv','2026-09-02 10:40:42');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00058' ,nama_atribut='' ,kode_intern='BDCK-00058 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='CK265 13 0226',total_usd_ext='IDR 35 000 000',total_usd='33.75' WHERE kode_barang='BDCK-XIBC-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-22-0','BDCK-XIBC-22-0','00031402','RD','1','0.100','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-22-0','00031402','RD','1','0.100','600','60')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-22-0','BDCK-XIBC-22-0','00031402','RD','8','0.080','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-22-0','00031402','RD','8','0.080','400','32')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-22-0','00031402','00031402','CINCIN KAWIN BDCK-00049','CINCIN KAWIN BDCK-00049','','','6494000','6494000',' 0','0','spv','2026-09-02 10:42:00');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00049' ,nama_atribut='' ,kode_intern='BDCK-00049 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX095 13 0226',total_usd_ext='IDR 36 000 000',total_usd='92' WHERE kode_barang='BDCK-XIBC-22-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','10:49:09');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBBE-2-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBBE-2-0','BDCK-YBBE-2-0','00034355','RD','2','0.015','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBBE-2-0','00034355','RD','2','0.015','400','6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBBE-2-0','BDCK-YBBE-2-0','00034355','RD','1','0.025','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBBE-2-0','00034355','RD','1','0.025','400','10')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBBE-2-0','00034355','00034355','CINCIN KAWIN BDCK-00099','CINCIN KAWIN BDCK-00099','','','3068000','3068000',' 0','0','spv','2026-09-02 11:02:48');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00099' ,nama_atribut='' ,kode_intern='BDCK-00099 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RESIN 12 0226',total_usd_ext='IDR 15 500 000',total_usd='16' WHERE kode_barang='BDCK-YBBE-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XJXC-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XJXC-4-0','BDCK-XJXC-4-0','00031595','RD','1','0.075','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XJXC-4-0','00031595','RD','1','0.075','400','30')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XJXC-4-0','BDCK-XJXC-4-0','00031595','RD','22','0.130','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XJXC-4-0','00031595','RD','22','0.130','400','52')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XJXC-4-0','00031595','00031595','CINCIN KAWIN BDCK-00087','CINCIN KAWIN BDCK-00087','','','6215500','6215500',' 0','0','spv','2026-09-02 11:05:05');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00087' ,nama_atribut='' ,kode_intern='BDCK-00087 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 0226',total_usd_ext='IDR 34 500 000',total_usd='82' WHERE kode_barang='BDCK-XJXC-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XJXH-26-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XJXH-26-0','BDCK-XJXH-26-0','00031658','RD','1','0.110','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XJXH-26-0','00031658','RD','1','0.110','600','66')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XJXH-26-0','BDCK-XJXH-26-0','00031658','RD','14','0.080','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XJXH-26-0','00031658','RD','14','0.080','400','32')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XJXH-26-0','00031658','00031658','CINCIN KAWIN BDCK-00088','CINCIN KAWIN BDCK-00088','','','5100000','5100000',' 0','0','spv','2026-09-02 11:07:44');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00088' ,nama_atribut='' ,kode_intern='BDCK-00088 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='SZC56 13 0226',total_usd_ext='IDR 30 500 000',total_usd='98' WHERE kode_barang='BDCK-XJXH-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIXE-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-22-0','BDCK-XIXE-22-0','00031117','RD','1','0.185','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-22-0','00031117','RD','1','0.185','800','148')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-22-0','BDCK-XIXE-22-0','00031117','RD','32','0.185','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-22-0','00031117','RD','32','0.185','400','74')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIXE-22-0','00031117','00031117','CINCIN KAWIN BDCK-00005','CINCIN KAWIN BDCK-00005','','','8677000','8677000',' 0','0','spv','2026-09-02 11:09:51');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00005' ,nama_atribut='' ,kode_intern='BDCK-00005 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 0226',total_usd_ext='IDR 50 000 000',total_usd='222' WHERE kode_barang='BDCK-XIXE-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIXE-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-22-0','BDCK-XIXE-22-0','00031117','RD','32','0.185','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-22-0','00031117','RD','32','0.185','400','74')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-22-0','BDCK-XIXE-22-0','00031117','RD','1','0.185','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-22-0','00031117','RD','1','0.185','800','148')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIXE-22-0','00031117','00031117','CINCIN KAWIN BDCK-00005','CINCIN KAWIN BDCK-00005','','','8677000','8677000',' 0','0','spv','2026-09-02 11:10:39');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00005' ,nama_atribut='' ,kode_intern='BDCK-00005 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 0226',total_usd_ext='IDR 53 500 000',total_usd='222' WHERE kode_barang='BDCK-XIXE-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-36-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-36-0','BDCK-XIBC-36-0','00031416','RD','15','0.160','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-36-0','00031416','RD','15','0.160','400','64')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-36-0','00031416','00031416','CINCIN KAWIN BDCK-00062','CINCIN KAWIN BDCK-00062','','','5339000','5339000',' 0','0','spv','2026-09-02 11:12:17');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00062' ,nama_atribut='' ,kode_intern='BDCK-00062 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX014 12 0226',total_usd_ext='IDR 29 000 000',total_usd='64' WHERE kode_barang='BDCK-XIBC-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-27-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-27-0','BDCK-XIBC-27-0','00031407','RD','1','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-27-0','00031407','RD','1','0.075','450','33.75')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-27-0','00031407','00031407','CINCIN KAWIN BDCK-00054','CINCIN KAWIN BDCK-00054','','','5219500','5219500',' 0','0','spv','2026-09-02 11:13:21');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00054' ,nama_atribut='' ,kode_intern='BDCK-00054 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 0226',total_usd_ext='IDR 26 000 000',total_usd='33.75' WHERE kode_barang='BDCK-XIBC-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-17-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-17-0','BDCK-XIBC-17-0','00031397','RD','1','0.080','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-17-0','00031397','RD','1','0.080','400','32')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-17-0','00031397','00031397','CINCIN KAWIN BDCK-00044','CINCIN KAWIN BDCK-00044','','','5996000','5996000',' 0','0','spv','2026-09-02 11:14:53');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00044' ,nama_atribut='' ,kode_intern='BDCK-00044 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX090 13 5 0226',total_usd_ext='IDR 30 000 000',total_usd='32' WHERE kode_barang='BDCK-XIBC-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-33-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-33-0','BDCK-XIBC-33-0','00031413','RD','1','0.115','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-33-0','00031413','RD','1','0.115','600','69')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-33-0','BDCK-XIBC-33-0','00031413','RD','18','0.105','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-33-0','00031413','RD','18','0.105','400','42')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-33-0','00031413','00031413','CINCIN KAWIN BDCK-00059','CINCIN KAWIN BDCK-00059','','','5398500','5398500',' 0','0','spv','2026-09-02 11:17:07');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00059' ,nama_atribut='' ,kode_intern='BDCK-00059 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX093 14 0226',total_usd_ext='IDR 33 000 000',total_usd='111' WHERE kode_barang='BDCK-XIBC-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBE-24-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBE-24-0','BDCK-XIBE-24-0','00031461','RD','1','0.100','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBE-24-0','00031461','RD','1','0.100','600','60')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBE-24-0','00031461','00031461','CINCIN KAWIN BDCK-00070','CINCIN KAWIN BDCK-00070','','','7131500','7131500',' 0','0','spv','2026-09-02 11:18:16');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00070' ,nama_atribut='' ,kode_intern='BDCK-00070 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18 0226',total_usd_ext='IDR 36 000 000',total_usd='60' WHERE kode_barang='BDCK-XIBE-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-26-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-26-0','BDCK-XIBC-26-0','00031406','RD','1','0.105','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-26-0','00031406','RD','1','0.105','600','63')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-26-0','00031406','00031406','CINCIN KAWIN BDCK-00053','CINCIN KAWIN BDCK-00053','','','5239000','5239000',' 0','0','spv','2026-09-02 11:19:41');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00053' ,nama_atribut='' ,kode_intern='BDCK-00053 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 0226',total_usd_ext='IDR 28 000 000',total_usd='63' WHERE kode_barang='BDCK-XIBC-26-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-02 ','12:07:13');
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-03780','PUT','1','GOLD','WEDRING','','','2.000','','37.50','1','2400000','1400000','0','750000','3550000','sz cwe 12 crom putih gllosy','grf Aya font Vladimir zircon 10','jangan lebih dari 2gr','0','100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260902-0001','2026-09-02','2026-09-02 13:02:39','PESANAN : DP-03780','.','TBC','2920000','2920000');
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-260902-0002','D','2026-09-02','13:02:39','TBC','PESANAN','DP-03780','27157037564','2920000','27159957564','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-03780','2026-09-02','2026-09-02','13:02:39','PLG0015251','PUT','2026-09-25','kasirbip','2026-09-02 13:02:39','2.000','0','0','0','2920000','0','750000','3650000','3650000','730000');
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-03781','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 17 crom putih doff semprot','grf Ren 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-260902-0002','2026-09-02','2026-09-02 13:04:29','PESANAN : DP-03781','.','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-260902-0003','D','2026-09-02','13:04:29','TBC','PESANAN','DP-03781','27159957564','850000','27160807564','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-03781','2026-09-02','2026-09-02','13:04:29','PLG0015252','PUT','2026-09-25','kasirbip','2026-09-02 13:04:29','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','13:15:15');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0001','kasirbip','1',' DP-03665DU','TOKO','DUPSN','PSPRT-ZHCA-33-0','1PS CINCIN PERAK ','','3.500','1','100.00','357000','0','0','17800','1500000','0','0','0','1500000','PUT','00046725','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHCA-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPRT-ZHCA-33-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-260902-0001','2026-09-02','3.500','2026-09-02','13:24:25','PLG0015253','1500000','1500000','0','1500000','0','kasirbip','2026-09-02 13:24:25','FJ-260902-0001','DP-03665','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-02','FJ-260902-0001','2026-09-02','13:24:25','PUT','1500000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260902-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0001';
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-260902-0002','kasir','1',' ABRT-00244','TOKO','TFABR','ABRT-WGXE-18-0','GIWANG ABRT-00244','','2.270','1','105.00','13355000','5892000','331','17800','13500000','0','0','0','13500000','BARY','00022758','ABRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRT-WGXE-18-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-09-02' AND kode_barang='ABRT-WGXE-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFABR' 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-260902-0002','2026-09-02','2.270','2026-09-02','13:42:26','PLG0015254','13500000','13500000','0','13500000','0','kasir','2026-09-02 13:42:25','FJ-260902-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-09-02','FJ-260902-0002','2026-09-02','13:42:26','BARY','13500000','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-260902-0003','2026-09-02','2026-09-02 13:42:25','PENJUALAN : FJ-260902-0002','.','BCK','13500000','13500000','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-260902-0002','D','2026-09-02','13:42:26','BCK','PENJUALAN BERLIAN','FJ-260902-0002','2017408000','13500000','2030908000','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='13500000' WHERE no_faktur_jual='FJ-260902-0002' 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-260902-0003','kasir',' 1',' BDK-00003 ','TOKO','TFKLB','BDK-XICX-14-0','KALUNG BDK-00003','','2.830','1','103.00','11066000','2626000','148','17800','12500000','0','0','0','12500000','BARY','00031521','BDK','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDK-XICX-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='BDK-XICX-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFKLB' 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-260902-0003','2026-09-02','2.830','2026-09-02','13:42:26','PLG0015255','12500000','12500000','0','12500000','0','kasir','2026-09-02 13:42:25','FJ-260902-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-09-02','FJ-260902-0003','2026-09-02','13:42:26','BARY','12500000','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-260902-0004','2026-09-02','2026-09-02 13:42:25','PENJUALAN : FJ-260902-0003','.','BCK','12500000','12500000','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-260902-0003','D','2026-09-02','13:42:26','BCK','PENJUALAN BERLIAN','FJ-260902-0003','2030908000','12500000','2043408000','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='26000000' WHERE no_faktur_jual='FJ-260902-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','13:45:16');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-09-02 ','13:55:30');
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBG-11-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBG-11-0','BDCK-XIBG-11-0','00031496','RD','1','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBG-11-0','00031496','RD','1','0.040','420','16.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBG-11-0','00031496','00031496','CINCIN KAWIN BDCK-00073','CINCIN KAWIN BDCK-00073','','','5000000','5000000',' 0','0','spv','2026-09-02 13:55:50');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00073' ,nama_atribut='' ,kode_intern='BDCK-00073 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='WRE005 115 0226',total_usd_ext='IDR 24 000 000',total_usd='16.8' WHERE kode_barang='BDCK-XIBG-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBAA-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBAA-4-0','BDCK-YBAA-4-0','00034070','RD','1','0.030','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBAA-4-0','00034070','RD','1','0.030','400','12')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBAA-4-0','00034070','00034070','CINCIN KAWIN BDCK-00091','CINCIN KAWIN BDCK-00091','','','4801000','4801000',' 0','0','spv','2026-09-02 13:57:23');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00091' ,nama_atribut='' ,kode_intern='BDCK-00091 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='WRE003 135 0226',total_usd_ext='IDR 22 500 000',total_usd='12' WHERE kode_barang='BDCK-YBAA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIAF-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-13-0','BDCK-XIAF-13-0','00031277','RD','1','0.105','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-13-0','00031277','RD','1','0.105','600','63')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-13-0','BDCK-XIAF-13-0','00031277','RD','20','0.140','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-13-0','00031277','RD','20','0.140','400','56')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIAF-13-0','00031277','00031277','CINCIN KAWIN BDCK-00014','CINCIN KAWIN BDCK-00014','','','6833000','6833000',' 0','0','spv','2026-09-02 13:59:06');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00014' ,nama_atribut='' ,kode_intern='BDCK-00014 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 0226',total_usd_ext='IDR 39 500 000',total_usd='119' WHERE kode_barang='BDCK-XIAF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-19-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-19-0','BDCK-XIBC-19-0','00031399','RD','3','0.120','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-19-0','00031399','RD','3','0.120','400','48')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-19-0','00031399','00031399','CINCIN KAWIN BDCK-00046','CINCIN KAWIN BDCK-00046','','','6613500','6613500',' 0','0','spv','2026-09-02 14:00:22');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00046' ,nama_atribut='' ,kode_intern='BDCK-00046 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='LX094 13 0226',total_usd_ext='IDR 33 500 000',total_usd='48' WHERE kode_barang='BDCK-XIBC-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-5-0','BDCK-XIBC-5-0','00031385','RD','1','0.020','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-5-0','00031385','RD','1','0.020','400','8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-5-0','00031385','00031385','CINCIN KAWIN BDCK-00032','CINCIN KAWIN BDCK-00032','','','4223500','4223500',' 0','0','spv','2026-09-02 14:01:58');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00032' ,nama_atribut='' ,kode_intern='BDCK-00032 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 0226',total_usd_ext='IDR 20 000 000',total_usd='8' WHERE kode_barang='BDCK-XIBC-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIAF-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-14-0','BDCK-XIAF-14-0','00031278','RD','20','0.115','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-14-0','00031278','RD','20','0.115','400','46')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIAF-14-0','00031278','00031278','CINCIN KAWIN BDCK-00015','CINCIN KAWIN BDCK-00015','','','5119500','5119500',' 0','0','spv','2026-09-02 14:03:22');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00015' ,nama_atribut='' ,kode_intern='BDCK-00015 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='KCK90 12 5 0226',total_usd_ext='IDR 27 000 000',total_usd='46' WHERE kode_barang='BDCK-XIAF-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIAF-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-16-0','BDCK-XIAF-16-0','00031280','RD','1','0.100','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-16-0','00031280','RD','1','0.100','600','60')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIAF-16-0','BDCK-XIAF-16-0','00031280','RD','16','0.135','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIAF-16-0','00031280','RD','16','0.135','400','54')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIAF-16-0','00031280','00031280','CINCIN KAWIN BDCK-00017','CINCIN KAWIN BDCK-00017','','','4841000','4841000',' 0','0','spv','2026-09-02 14:05:38');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00017' ,nama_atribut='' ,kode_intern='BDCK-00017 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 0226',total_usd_ext='IDR 31 000 000',total_usd='114' WHERE kode_barang='BDCK-XIAF-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBC-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBC-7-0','BDCK-XIBC-7-0','00031387','RD','1','0.020','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBC-7-0','00031387','RD','1','0.020','400','8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBC-7-0','00031387','00031387','CINCIN KAWIN BDCK-00034','CINCIN KAWIN BDCK-00034','','','2789000','2789000',' 0','0','spv','2026-09-02 14:06:38');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00034' ,nama_atribut='' ,kode_intern='BDCK-00034 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='KCK129 13 0226',total_usd_ext='IDR 14 000 000',total_usd='8' WHERE kode_barang='BDCK-XIBC-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YJAC-17-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YJAC-17-0','BDCK-YJAC-17-0','00039194','RD','1','0.020','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YJAC-17-0','00039194','RD','1','0.020','420','8.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YJAC-17-0','00039194','00039194','CINCIN KAWIN BDCK-00113','CINCIN KAWIN BDCK-00113','','','3386500','3386500',' 0','0','spv','2026-09-02 14:07:40');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00113' ,nama_atribut='' ,kode_intern='BDCK-00113 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12 5 0226',total_usd_ext='IDR 16 000 000',total_usd='8.4' WHERE kode_barang='BDCK-YJAC-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBBE-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBBE-4-0','BDCK-YBBE-4-0','00034357','RD','1','0.065','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBBE-4-0','00034357','RD','1','0.065','475','30.88')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBBE-4-0','00034357','00034357','CINCIN KAWIN BDCK-00101','CINCIN KAWIN BDCK-00101','','','4462500','4462500',' 0','0','spv','2026-09-02 14:08:46');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00101' ,nama_atribut='' ,kode_intern='BDCK-00101 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12 0226',total_usd_ext='IDR 22 500 000',total_usd='30.88' WHERE kode_barang='BDCK-YBBE-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-YBBE-1-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-YBBE-1-0','BDCK-YBBE-1-0','00034354','RD','1','0.070','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-YBBE-1-0','00034354','RD','1','0.070','475','33.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-YBBE-1-0','00034354','00034354','CINCIN KAWIN BDCK-00098','CINCIN KAWIN BDCK-00098','','','8227000','8227000',' 0','0','spv','2026-09-02 14:09:53');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00098' ,nama_atribut='' ,kode_intern='BDCK-00098 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 0226',total_usd_ext='IDR 38 000 000',total_usd='33.25' WHERE kode_barang='BDCK-YBBE-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIBG-10-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIBG-10-0','BDCK-XIBG-10-0','00031495','RD','1','0.035','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIBG-10-0','00031495','RD','1','0.035','400','14')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIBG-10-0','00031495','00031495','CINCIN KAWIN BDCK-00072','CINCIN KAWIN BDCK-00072','','','4382500','4382500',' 0','0','spv','2026-09-02 14:11:03');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00072' ,nama_atribut='' ,kode_intern='BDCK-00072 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 0226',total_usd_ext='IDR 21 000 000',total_usd='14' WHERE kode_barang='BDCK-XIBG-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDCK-XIXE-19-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-19-0','BDCK-XIXE-19-0','00031114','RD','2','0.030','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-19-0','00031114','RD','2','0.030','400','12')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDCK-XIXE-19-0','BDCK-XIXE-19-0','00031114','RD','1','0.095','580');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDCK-XIXE-19-0','00031114','RD','1','0.095','580','55.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDCK-XIXE-19-0','00031114','00031114','CINCIN KAWIN BDCK-00004','CINCIN KAWIN BDCK-00004','','','6335000','6335000',' 0','0','spv','2026-09-02 14:12:11');
UPDATE tm_barang SET nama_barang='CINCIN KAWIN BDCK-00004' ,nama_atribut='' ,kode_intern='BDCK-00004 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12 0226',total_usd_ext='IDR 33 000 000',total_usd='67.1' WHERE kode_barang='BDCK-XIXE-19-0' LIMIT 1;
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-20260902-0002','1','LXPER-ZIXA-11-0','1','2.480','2.480','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIXA-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIXA-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIXA-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-02 14:36:32' WHERE kode_barang='LXPER-ZIXA-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIXA-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-09-02 14:36:32','TOKO','DUPERBDG','LXPER','LXPER-ZIXA-11-0','1','2.480','2.480','1','2.480','2.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZIXA-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0002','1','LXPER-ZIXA-12-0','1','2.200','2.200','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIXA-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIXA-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIXA-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-02 14:36:32' WHERE kode_barang='LXPER-ZIXA-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIXA-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-09-02 14:36:32','TOKO','DUPERBDG','LXPER','LXPER-ZIXA-12-0','1','2.200','2.200','1','2.200','2.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZIXA-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0002','1','LXPER-ZIXA-13-0','1','1.480','1.480','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIXA-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIXA-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIXA-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-02 14:36:32' WHERE kode_barang='LXPER-ZIXA-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIXA-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:36:32','TOKO','DUPERBDG','LXPER','LXPER-ZIXA-13-0','1','1.480','1.480','1','1.480','1.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZIXA-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0002','1','LXPER-ZIXA-14-0','1','1.400','1.400','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIXA-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIXA-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIXA-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-02 14:36:32' WHERE kode_barang='LXPER-ZIXA-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIXA-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:36:32','TOKO','DUPERBDG','LXPER','LXPER-ZIXA-14-0','1','1.400','1.400','1','1.400','1.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZIXA-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0002','1','LXPER-ZIXA-15-0','1','1.750','1.750','TOKO','DUPER','TOKO','DUPERBDG');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZIXA-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZIXA-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZIXA-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-09-02 14:36:32' WHERE kode_barang='LXPER-ZIXA-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZIXA-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:36:32','TOKO','DUPERBDG','LXPER','LXPER-ZIXA-15-0','1','1.750','1.750','1','1.750','1.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZIXA-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZIXA-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0002','2026-09-02','14:35','9.310','kasirbip','2026-09-02 14:36:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260902-0003','1','PSPRT-ZIXA-37-0','1','3.670','3.670','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPRT-ZIXA-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPRT','PSPRT-ZIXA-37-0','1','3.670','3.670','1','3.670','3.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPRT-ZIXA-38-0','1','2.550','2.550','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPRT-ZIXA-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-38-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPRT','PSPRT-ZIXA-38-0','1','2.550','2.550','1','2.550','2.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPLT-ZIXA-39-0','1','2.950','2.950','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPLT-ZIXA-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-39-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPLT','PSPLT-ZIXA-39-0','1','2.950','2.950','1','2.950','2.950','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPLT-ZIXA-40-0','1','2.630','2.630','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPLT-ZIXA-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-40-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPLT','PSPLT-ZIXA-40-0','1','2.630','2.630','1','2.630','2.630','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-40-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPLT-ZIXA-41-0','1','2.660','2.660','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPLT-ZIXA-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-41-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPLT','PSPLT-ZIXA-41-0','1','2.660','2.660','1','2.660','2.660','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPRT-ZIXA-42-0','1','3.830','3.830','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPRT-ZIXA-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-42-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPRT','PSPRT-ZIXA-42-0','1','3.830','3.830','1','3.830','3.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPRT-ZIXA-43-0','1','4.280','4.280','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPRT-ZIXA-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-43-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPRT','PSPRT-ZIXA-43-0','1','4.280','4.280','1','4.280','4.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0003','1','PSPRT-ZIXA-44-0','1','3.500','3.500','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-44-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-44-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-09-02 14:38:39' WHERE kode_barang='PSPRT-ZIXA-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-44-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 14:38:39','TOKO','DUPSN','PSPRT','PSPRT-ZIXA-44-0','1','3.500','3.500','1','3.500','3.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-44-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0003','2026-09-02','14:36','26.070','kasirbip','2026-09-02 14:38:39');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-02 ','15:36:43');
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-260902-0004','kasirbip','1',' 900K-9-288','TOKO','BIPPER','PBDG-ZHAI-44-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','17800','1000000','0','0','0','1000000','KUR','00046248','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHAI-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PBDG-ZHAI-44-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-260902-0004','2026-09-02','1.940','2026-09-02','15:37:35','PLG0015256','1000000','1000000','0','1000000','0','kasirbip','2026-09-02 15:37:35','FJ-260902-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-09-02','FJ-260902-0004','2026-09-02','15:37:35','KUR','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-260902-0005','2026-09-02','2026-09-02 15:37:35','PENJUALAN : FJ-260902-0004','.','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-260902-0004','D','2026-09-02','15:37:35','TBC','PENJUALAN','FJ-260902-0004','27160807564','1000000','27161807564','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-260902-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0005','kasirbip',' 1',' 800K-21-28','TOKO','BIPPER','PBDG-ZHXD-29-0','CINCIN SILVER 925 YL10 ','','4.430','1','100.00','452000','0','0','17800','900000','0','0','0','900000','KUR','00045868','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.430',berat_jual_asli=berat_jual_asli+'4.430',stock_jual='1',berat_akhir=berat_akhir-'4.430',berat_akhir_asli=berat_akhir_asli-'4.430',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PBDG-ZHXD-29-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-260902-0005','2026-09-02','4.430','2026-09-02','15:37:35','PLG0015257','900000','900000','0','900000','0','kasirbip','2026-09-02 15:37:35','FJ-260902-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-09-02','FJ-260902-0005','2026-09-02','15:37:35','KUR','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-260902-0006','2026-09-02','2026-09-02 15:37:35','PENJUALAN : FJ-260902-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-260902-0005','D','2026-09-02','15:37:35','TBC','PENJUALAN','FJ-260902-0005','27161807564','900000','27162707564','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='1900000' WHERE no_faktur_jual='FJ-260902-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0005';
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-20260902-0004','1','PSPRT-ZIXA-2-0','1','3.070','3.070','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-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-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-2-0','1','3.070','3.070','1','3.070','3.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-3-0','1','2.390','2.390','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-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-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-3-0','1','2.390','2.390','1','2.390','2.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-4-0','1','1.550','1.550','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-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-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-4-0','1','1.550','1.550','1','1.550','1.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPLT-ZIXA-27-0','1','2.830','2.830','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPLT-ZIXA-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPLT','PSPLT-ZIXA-27-0','1','2.830','2.830','1','2.830','2.830','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPLT-ZIXA-28-0','1','1.410','1.410','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPLT-ZIXA-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPLT','PSPLT-ZIXA-28-0','1','1.410','1.410','1','1.410','1.410','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-29-0','1','2.900','2.900','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-29-0','1','2.900','2.900','1','2.900','2.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-30-0','1','3.880','3.880','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-30-0','1','3.880','3.880','1','3.880','3.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-31-0','1','3.010','3.010','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-31-0','1','3.010','3.010','1','3.010','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-32-0','1','2.100','2.100','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-32-0','1','2.100','2.100','1','2.100','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPLT-ZIXA-33-0','1','2.140','2.140','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPLT-ZIXA-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPLT','PSPLT-ZIXA-33-0','1','2.140','2.140','1','2.140','2.140','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSGT-ZIXA-34-0','1','3.000','3.000','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-ZIXA-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZIXA-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZIXA-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZIXA-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSGT-ZIXA-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZIXA-34-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSGT','PSGT-ZIXA-34-0','1','3.000','3.000','1','3.000','3.000','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZIXA-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZIXA-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPRT-ZIXA-35-0','1','2.830','2.830','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPRT-ZIXA-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPRT','PSPRT-ZIXA-35-0','1','2.830','2.830','1','2.830','2.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0004','1','PSPLT-ZIXA-36-0','1','2.080','2.080','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-09-02 16:11:03' WHERE kode_barang='PSPLT-ZIXA-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-36-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 16:11:03','TOKO','BIPPSN','PSPLT','PSPLT-ZIXA-36-0','1','2.080','2.080','1','2.080','2.080','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0004','2026-09-02','16:10','33.190','kasirbip','2026-09-02 16:11:02');
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-20260902-0005','1','PBDG-ZIXA-6-0','1','3.460','3.460','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIXA-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIXA-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIXA-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-02 16:12:15' WHERE kode_barang='PBDG-ZIXA-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIXA-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-09-02 16:12:15','TOKO','BIPPER','PBDG','PBDG-ZIXA-6-0','1','3.460','3.460','1','3.460','3.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIXA-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0005','1','PBDG-ZIXA-7-0','1','2.220','2.220','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIXA-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIXA-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIXA-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-02 16:12:15' WHERE kode_barang='PBDG-ZIXA-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIXA-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-09-02 16:12:15','TOKO','BIPPER','PBDG','PBDG-ZIXA-7-0','1','2.220','2.220','1','2.220','2.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIXA-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0005','1','PBDG-ZIXA-8-0','1','1.500','1.500','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIXA-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIXA-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIXA-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-02 16:12:15' WHERE kode_barang='PBDG-ZIXA-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIXA-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-09-02 16:12:15','TOKO','BIPPER','PBDG','PBDG-ZIXA-8-0','1','1.500','1.500','1','1.500','1.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIXA-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0005','1','PBDG-ZIXA-9-0','1','1.460','1.460','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIXA-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIXA-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIXA-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-02 16:12:15' WHERE kode_barang='PBDG-ZIXA-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIXA-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-09-02 16:12:15','TOKO','BIPPER','PBDG','PBDG-ZIXA-9-0','1','1.460','1.460','1','1.460','1.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIXA-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0005','1','PBDG-ZIXA-10-0','1','1.760','1.760','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZIXA-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZIXA-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZIXA-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-09-02 16:12:15' WHERE kode_barang='PBDG-ZIXA-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZIXA-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-09-02 16:12:15','TOKO','BIPPER','PBDG','PBDG-ZIXA-10-0','1','1.760','1.760','1','1.760','1.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' 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='PBDG-ZIXA-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZIXA-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0005','2026-09-02','16:11','10.400','kasirbip','2026-09-02 16:12:15');
UPDATE tt_service_head SET tgl_selesai='2026-09-02',  status ='DONE' WHERE no_service='SV-02224';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02224';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-09-02 ','16:37:52');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='',alamat1='' ,alamat2='' ,kota= '' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-09-02 16:38:54' WHERE id_card = '-';
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-260902-0006','sby','1',' 850K-9-003','TOKO','SBYPER','PSBY-ZHBH-43-0','CINCIN SILVER 925 ','','1.280','1','100.00','131000','0','0','17800','950000','0','0','0','950000','DIL','00046633','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZHBH-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSBY-ZHBH-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260902-0006','2026-09-02','1.280','2026-09-02','16:38:56','PLG0015258','950000','950000','0','950000','0','sby','2026-09-02 16:38:55','FJ-260902-0006','','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-09-02','FJ-260902-0006','2026-09-02','16:38:56','DIL','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-260902-0007','2026-09-02','2026-09-02 16:38:55','PENJUALAN : FJ-260902-0006','','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-260902-0006','D','2026-09-02','16:38:56','TBC','PENJUALAN','FJ-260902-0006','27162707564','950000','27163657564','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-260902-0006' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-09-02 ','16:51:57');
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-03782','ELLA','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2400000','1400000','0','900000','4400000','size 11.5 grf Rangga & Riani','warna crom rosegold','zircone 14 butir','0','0','140000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260902-0008','2026-09-02','2026-09-02 16:55:44','PESANAN : DP-03782','0','TBC','3632000','3632000');
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-260902-0007','D','2026-09-02','16:55:44','TBC','PESANAN','DP-03782','27163657564','3632000','27167289564','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-03782','2026-09-02','2026-09-02','16:55:44','PLG0015259','ELLA','2026-09-30','kasir','2026-09-02 16:55:44','2.500','0','0','0','3632000','0','900000','4540000','4540000','908000');
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-03783','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','950000','size 14.5 grf Rangga & Riani','warna crom rosegold kombinasi doff semprot putih','tanpa permata','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-260902-0009','2026-09-02','2026-09-02 16:59:11','PESANAN : DP-03783','0','TBC','950000','950000');
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-260902-0008','D','2026-09-02','16:59:11','TBC','PESANAN','DP-03783','27167289564','950000','27168239564','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-03783','2026-09-02','2026-09-02','16:59:11','PLG0015260','ELLA','2026-09-30','kasir','2026-09-02 16:59:11','3.000','0','0','0','950000','0','0','950000','950000','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-03784','ALIKA','1','PER','CINCIN PROMO 850','','','2.000','','925.00','1','100000','0','0','0','850000','cwe size 15 grf Sari zircone 1 butir upsize 100k','cwo size 19.5 grf Adi tanpa permata','warna crom putih sesuai model','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-260902-0010','2026-09-02','2026-09-02 17:03:51','PESANAN : DP-03784','0','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-260902-0009','D','2026-09-02','17:03:51','TBC','PESANAN','DP-03784','27168239564','850000','27169089564','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-03784','2026-09-02','2026-09-02','17:03:51','PLG0015261','ALIKA','2026-09-30','kasir','2026-09-02 17:03:51','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260902-0006','1','PSPLT-ZIXA-45-0','1','4.050','4.050','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-45-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-45-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-02 17:16:03' WHERE kode_barang='PSPLT-ZIXA-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-45-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:16:03','TOKO','SBYPSN','PSPLT','PSPLT-ZIXA-45-0','1','4.050','4.050','1','4.050','4.050','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-45-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0006','1','PSPRT-ZIXA-46-0','1','1.710','1.710','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-46-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-46-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-46-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-02 17:16:03' WHERE kode_barang='PSPRT-ZIXA-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-46-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:16:03','TOKO','SBYPSN','PSPRT','PSPRT-ZIXA-46-0','1','1.710','1.710','1','1.710','1.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-46-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0006','1','PSPLT-ZIXA-47-0','1','2.910','2.910','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZIXA-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZIXA-47-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZIXA-47-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-02 17:16:03' WHERE kode_barang='PSPLT-ZIXA-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZIXA-47-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:16:03','TOKO','SBYPSN','PSPLT','PSPLT-ZIXA-47-0','1','2.910','2.910','1','2.910','2.910','32.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZIXA-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZIXA-47-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0006','1','PSPRT-ZIXA-48-0','1','4.000','4.000','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-48-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-48-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-02 17:16:03' WHERE kode_barang='PSPRT-ZIXA-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:16:03','TOKO','SBYPSN','PSPRT','PSPRT-ZIXA-48-0','1','4.000','4.000','1','4.000','4.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-48-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0006','1','PSPRT-ZIXA-49-0','1','3.370','3.370','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-49-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-49-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-02 17:16:03' WHERE kode_barang='PSPRT-ZIXA-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-49-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:16:03','TOKO','SBYPSN','PSPRT','PSPRT-ZIXA-49-0','1','3.370','3.370','1','3.370','3.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-49-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0006','1','PSPRT-ZIXA-50-0','1','3.010','3.010','TOKO','SBYPSN','TOKO','SBYPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZIXA-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-50-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZIXA-50-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZIXA-50-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-09-02 17:16:03' WHERE kode_barang='PSPRT-ZIXA-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZIXA-50-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:16:03','TOKO','SBYPSN','PSPRT','PSPRT-ZIXA-50-0','1','3.010','3.010','1','3.010','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZIXA-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZIXA-50-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0006','2026-09-02','17:14','19.050','sby','2026-09-02 17:16:02');
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-20260902-0007','1','PSBY-ZIXA-16-0','1','1.550','1.550','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIXA-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIXA-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIXA-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIXA-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-02 17:19:02' WHERE kode_barang='PSBY-ZIXA-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIXA-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:19:02','TOKO','SBYPER','PSBY','PSBY-ZIXA-16-0','1','1.550','1.550','1','1.550','1.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZIXA-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIXA-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0007','1','PSBY-ZIXA-17-0','1','1.420','1.420','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIXA-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIXA-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIXA-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIXA-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-02 17:19:02' WHERE kode_barang='PSBY-ZIXA-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIXA-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:19:02','TOKO','SBYPER','PSBY','PSBY-ZIXA-17-0','1','1.420','1.420','1','1.420','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZIXA-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIXA-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' 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-20260902-0007','1','PSBY-ZIXA-18-0','1','1.730','1.730','TOKO','SBYPER','TOKO','SBYPER');
DELETE FROM tm_barang WHERE kode_barang='PSBY-ZIXA-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBY-ZIXA-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBY-ZIXA-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBY-ZIXA-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPER',tgl_last_beli='2026-09-02 17:19:02' WHERE kode_barang='PSBY-ZIXA-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBY-ZIXA-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-09-02 17:19:02','TOKO','SBYPER','PSBY','PSBY-ZIXA-18-0','1','1.730','1.730','1','1.730','1.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBY' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBY-ZIXA-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZIXA-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-09-02' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0007','2026-09-02','17:16','4.700','sby','2026-09-02 17:19:02');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0007','kasirbip','1',' DP-03188DU','TOKO','DUPSN','PSPLT-ZHBA-24-0','CINCIN PALADIUM YL10 ','','4.650','1','17.00','1044000','0','0','17800','2427500','0','0','0','2427500','KUR','00046310','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.650',berat_jual_asli=berat_jual_asli+'4.650',stock_jual='1',berat_akhir=berat_akhir-'4.650',berat_akhir_asli=berat_akhir_asli-'4.650',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHBA-24-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-260902-0007','2026-09-02','4.650','2026-09-02','17:22:42','PLG0015262','2427500','2427500','0','2427500','0','kasirbip','2026-09-02 17:22:42','FJ-260902-0007','DP-03188','2040000');
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-09-02','FJ-260902-0007','2026-09-02','17:22:42','KUR','2427500','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-260902-0011','2026-09-02','2026-09-02 17:22:42','PENJUALAN : FJ-260902-0007','.','TBC','387500','387500','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-260902-0010','D','2026-09-02','17:22:42','TBC','PENJUALAN','FJ-260902-0007','27169089564','387500','27169477064','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='387500' WHERE no_faktur_jual='FJ-260902-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-260902-0008','kasirbip',' 1',' DP-03187DU','TOKO','DUPSN','PSPLT-ZHBD-11-0','CINCIN PALADIUM ','','2.090','1','17.00','470000','0','0','17800','1481500','0','0','0','1481500','KUR','00046329','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBD-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHBD-11-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-260902-0008','2026-09-02','2.090','2026-09-02','17:22:42','PLG0015263','1481500','1481500','0','1481500','0','kasirbip','2026-09-02 17:22:42','FJ-260902-0007','DP-03187','1160000');
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-09-02','FJ-260902-0008','2026-09-02','17:22:42','KUR','1481500','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-260902-0012','2026-09-02','2026-09-02 17:22:42','PENJUALAN : FJ-260902-0008','.','TBC','321500','321500','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-260902-0011','D','2026-09-02','17:22:42','TBC','PENJUALAN','FJ-260902-0008','27169477064','321500','27169798564','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='709000' WHERE no_faktur_jual='FJ-260902-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-260902-0009','kasirbip','1',' 500K-21-28','TOKO','BIPPER','PBDG-ZGCX-18-0','CINCIN SILVER 925 YL01 ','','1.960','1','100.00','200000','0','0','17800','600000','0','0','0','600000','SULIS','00045746','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGCX-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PBDG-ZGCX-18-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-260902-0009','2026-09-02','1.960','2026-09-02','17:40:10','PLG0015264','600000','600000','0','600000','0','kasirbip','2026-09-02 17:40:09','FJ-260902-0009','','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-09-02','FJ-260902-0009','2026-09-02','17:40:10','SULIS','600000','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-260902-0013','2026-09-02','2026-09-02 17:40:09','PENJUALAN : FJ-260902-0009','.','TBC','600000','600000','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-260902-0012','D','2026-09-02','17:40:10','TBC','PENJUALAN','FJ-260902-0009','27169798564','600000','27170398564','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='600000' WHERE no_faktur_jual='FJ-260902-0009' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0010','kasirbip',' 1',' 850K-12-28','TOKO','BIPPER','PBDG-ZHAC-11-0','CINCIN SILVER 925 ','','1.650','1','100.00','169000','0','0','17800','950000','0','0','0','950000','SULIS','00046125','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHAC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PBDG-ZHAC-11-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-260902-0010','2026-09-02','1.650','2026-09-02','17:40:10','PLG0015265','950000','950000','0','950000','0','kasirbip','2026-09-02 17:40:09','FJ-260902-0009','','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-09-02','FJ-260902-0010','2026-09-02','17:40:10','SULIS','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-260902-0014','2026-09-02','2026-09-02 17:40:09','PENJUALAN : FJ-260902-0010','.','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-260902-0013','D','2026-09-02','17:40:10','TBC','PENJUALAN','FJ-260902-0010','27170398564','950000','27171348564','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='1550000' WHERE no_faktur_jual='FJ-260902-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0010';
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-03785','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','1200000','0','1200000','EXSPRESS 100.000 font vladimir','sz cwe 17 CM.01 grf Muri 27.09.26','sz cwo 23 cm.01 grf nova 23.03.21','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-260902-0015','2026-09-02','2026-09-02 17:52:44','PESANAN : DP-03785','.','TBC','1200000','1200000');
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-260902-0014','D','2026-09-02','17:52:44','TBC','PESANAN','DP-03785','27171348564','1200000','27172548564','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-03785','2026-09-02','2026-09-02','17:52:44','PLG0015266','PUT','2026-09-15','kasirbip','2026-09-02 17:52:44','3.000','0','0','0','1200000','0','0','1200000','1200000','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-03786','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','cwe SR-03 sz 21 OVERSIZE 100.000','cwo YL-01 sz 18 putih doff amplas','font vintage rotter grf cwe Yuda cwo Santi','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260902-0016','2026-09-02','2026-09-02 18:18:41','PESANAN : DP-03786','.','TBC','950000','950000');
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-260902-0015','D','2026-09-02','18:18:41','TBC','PESANAN','DP-03786','27172548564','950000','27173498564','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-03786','2026-09-02','2026-09-02','18:18:41','PLG0015267','KUR','2026-09-22','kasirbip','2026-09-02 18:18:41','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0011','kasirbip','1',' DP-03702DU','TOKO','DUPSN','PSPRT-ZIXA-44-0','CINCIN PERAK YL01 ','','3.500','1','100.00','357000','0','0','17800','1200000','0','0','0','1200000','PUT','00046814','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIXA-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPRT-ZIXA-44-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-260902-0011','2026-09-02','3.500','2026-09-02','18:37:02','PLG0015268','1200000','1200000','0','1200000','0','kasirbip','2026-09-02 18:37:01','FJ-260902-0011','DP-03702','1200000');
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-09-02','FJ-260902-0011','2026-09-02','18:37:02','PUT','1200000','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-260902-0011' 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-03787','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE 17.5 GRF: Ilmiya ?? (VINTAGE)','CROM PUTIH GLOSSY MIX DOFF','','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-260902-0017','2026-09-02','2026-09-02 18:50:40','PESANAN : DP-03787','-','TBC','800000','800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260902-0016','D','2026-09-02','18:50:40','TBC','PESANAN','DP-03787','27173498564','800000','27174298564','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-03787','2026-09-02','2026-09-02','18:50:40','PLG0015269','DIL','2026-09-27','sby','2026-09-02 18:50:40','3.000','0','0','0','800000','0','0','800000','800000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0011';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0012','kasir','1',' DP-03204MM','TOKO','MMPSN','PSPRT-ZHBF-13-0','CINCIN PERAK ','','3.860','1','100.00','394000','0','0','17800','850000','0','0','0','850000','ALIKA','00046519','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBF-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.860',berat_jual_asli=berat_jual_asli+'3.860',stock_jual='1',berat_akhir=berat_akhir-'3.860',berat_akhir_asli=berat_akhir_asli-'3.860',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPRT-ZHBF-13-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-260902-0012','2026-09-02','3.860','2026-09-02','19:13:02','PLG0015270','850000','850000','0','850000','0','kasir','2026-09-02 19:13:02','FJ-260902-0012','DP-03204','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-02','FJ-260902-0012','2026-09-02','19:13:02','ALIKA','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260902-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-260902-0013','kasir',' 1',' DP-03203MM','TOKO','MMPSN','PSPRT-ZHBH-16-0','CINCIN PERAK ','','2.460','1','100.00','251000','0','0','17800','850000','0','0','0','850000','ALIKA','00046606','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBH-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.460',berat_jual_asli=berat_jual_asli+'2.460',stock_jual='1',berat_akhir=berat_akhir-'2.460',berat_akhir_asli=berat_akhir_asli-'2.460',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPRT-ZHBH-16-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-260902-0013','2026-09-02','2.460','2026-09-02','19:13:02','PLG0015271','850000','850000','0','850000','0','kasir','2026-09-02 19:13:02','FJ-260902-0012','DP-03203','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-02','FJ-260902-0013','2026-09-02','19:13:02','ALIKA','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260902-0013' 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-260902-0014','kasirbip','1',' DP-03184BI','TOKO','BIPPSN','PSPLT-ZHBF-59-0','CINCIN PALADIUM ','','3.000','1','17.00','674000','0','0','17800','1900000','0','0','0','1900000','SULIS','00046565','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBF-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHBF-59-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260902-0014','2026-09-02','3.000','2026-09-02','19:18:20','PLG0015272','1900000','1900000','0','1900000','0','kasirbip','2026-09-02 19:18:20','FJ-260902-0014','DP-03184','1380000');
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-09-02','FJ-260902-0014','2026-09-02','19:18:20','SULIS','1900000','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-260902-0018','2026-09-02','2026-09-02 19:18:20','PENJUALAN : FJ-260902-0014','.','TBC','520000','520000','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-260902-0017','D','2026-09-02','19:18:20','TBC','PENJUALAN','FJ-260902-0014','27174298564','520000','27174818564','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='520000' WHERE no_faktur_jual='FJ-260902-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0014';
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-03788','DIL','1','PER','WEDD RING CUSTOM','','','3.000','','925.00','1','100000','0','850000','0','850000','PERMATA 4/5 BUTIR LINGKARAN','SIZE 9 GRF: B.A.P & S.A 7-09-2026','CROM PUTIH GLOSSY MIX DOFF','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-260902-0019','2026-09-02','2026-09-02 19:20:47','PESANAN : DP-03788','-','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-260902-0018','D','2026-09-02','19:20:47','TBC','PESANAN','DP-03788','27174818564','850000','27175668564','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-03788','2026-09-02','2026-09-02','19:20:47','PLG0015273','DIL','2026-09-09','sby','2026-09-02 19:20:47','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0015','sby','1',' DP-03397SB','TOKO','SBYPSN','PSPRT-ZHCA-37-0','1PS CINCIN PERAK ','','3.800','1','100.00','388000','0','0','17800','1400000','0','0','0','1400000','DIL','00046729','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHCA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPRT-ZHCA-37-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-260902-0015','2026-09-02','3.800','2026-09-02','19:41:22','PLG0015274','1400000','1400000','0','1400000','0','sby','2026-09-02 19:41:22','FJ-260902-0015','DP-03397','1400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-02','FJ-260902-0015','2026-09-02','19:41:22','DIL','1400000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260902-0015' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-09-02 ','20:00:57');
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-03789','PUT','1','GOLD','WEDRING','','','2.000','','37.50','1','2400000','1400000','0','800000','3600000','zircon 7 crom putih gllosy','sz 16 grf Ramdhani','font Vladimir','70000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260902-0020','2026-09-02','2026-09-02 20:04:55','PESANAN : DP-03789','.','TBC','2936000','2936000');
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-260902-0019','D','2026-09-02','20:04:55','TBC','PESANAN','DP-03789','27175668564','2936000','27178604564','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-03789','2026-09-02','2026-09-02','20:04:55','PLG0015275','PUT','2026-09-25','kasirbip','2026-09-02 20:04:55','2.000','0','0','0','2936000','0','800000','3670000','3670000','734000');
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-260902-0016','sby','1',' DP-03233SB','TOKO','SBYPSN','PSPLT-ZHBF-7-0','CINCIN PALADIUM ','','5.030','1','17.00','1130000','0','0','17800','2611000','0','0','0','2611000','DIL','00046513','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBF-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.030',berat_jual_asli=berat_jual_asli+'5.030',stock_jual='1',berat_akhir=berat_akhir-'5.030',berat_akhir_asli=berat_akhir_asli-'5.030',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHBF-7-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-260902-0016','2026-09-02','5.030','2026-09-02','20:05:31','PLG0015276','2611000','2611000','0','2611000','0','sby','2026-09-02 20:05:31','FJ-260902-0016','DP-03233','1700000');
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-09-02','FJ-260902-0016','2026-09-02','20:05:31','DIL','2611000','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-260902-0021','2026-09-02','2026-09-02 20:05:31','PENJUALAN : FJ-260902-0016','','TBC','911000','911000','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-260902-0020','D','2026-09-02','20:05:31','TBC','PENJUALAN','FJ-260902-0016','27178604564','911000','27179515564','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='911000' WHERE no_faktur_jual='FJ-260902-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260902-0017','sby',' 1',' DP-03234SB','TOKO','SBYPSN','PSPLT-ZHBF-67-0','CINCIN PALADIUM ','','2.140','1','32.00','905000','0','0','17800','2297000','0','0','0','2297000','DIL','00046573','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBF-67-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-09-02' AND kode_barang='PSPLT-ZHBF-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-260902-0017','2026-09-02','2.140','2026-09-02','20:05:31','PLG0015277','2297000','2297000','0','2297000','0','sby','2026-09-02 20:05:31','FJ-260902-0016','DP-03234','1800000');
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-09-02','FJ-260902-0017','2026-09-02','20:05:31','DIL','2297000','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-260902-0022','2026-09-02','2026-09-02 20:05:31','PENJUALAN : FJ-260902-0017','','TBC','497000','497000','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-260902-0021','D','2026-09-02','20:05:31','TBC','PENJUALAN','FJ-260902-0017','27179515564','497000','27180012564','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='1408000' WHERE no_faktur_jual='FJ-260902-0017' 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-03790','PUT','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','sz 23 crom putih doff semprot','grf Raissa 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-260902-0023','2026-09-02','2026-09-02 20:07:12','PESANAN : DP-03790','.','TBC','1620000','1620000');
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-260902-0022','D','2026-09-02','20:07:12','TBC','PESANAN','DP-03790','27180012564','1620000','27181632564','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-03790','2026-09-02','2026-09-02','20:07:12','PLG0015278','PUT','2026-09-25','kasirbip','2026-09-02 20:07:12','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000');
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-260902-0018','sby','1',' DP-03302SB','TOKO','SBYPSN','PSPLT-ZHBH-98-0','CINCIN PALADIUM ','','1.710','1','17.00','356000','0','0','17800','1938000','0','0','0','1938000','VAN','00046688','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBH-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHBH-98-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-260902-0018','2026-09-02','1.710','2026-09-02','20:14:50','PLG0015279','1938000','1938000','0','1938000','0','sby','2026-09-02 20:14:49','FJ-260902-0018','DP-03302','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-09-02','FJ-260902-0018','2026-09-02','20:14:50','VAN','1938000','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-260902-0024','2026-09-02','2026-09-02 20:14:49','PENJUALAN : FJ-260902-0018','','TBC','438000','438000','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-260902-0023','D','2026-09-02','20:14:50','TBC','PENJUALAN','FJ-260902-0018','27181632564','438000','27182070564','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='438000' WHERE no_faktur_jual='FJ-260902-0018' 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-260902-0019','sby',' 1',' DP-03301SB','TOKO','SBYPSN','PSPLT-ZHBH-66-0','CINCIN PALADIUM ','','3.460','1','17.00','777000','0','0','17800','1911000','0','0','0','1911000','VAN','00046656','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBH-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.460',berat_jual_asli=berat_jual_asli+'3.460',stock_jual='1',berat_akhir=berat_akhir-'3.460',berat_akhir_asli=berat_akhir_asli-'3.460',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHBH-66-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-260902-0019','2026-09-02','3.460','2026-09-02','20:14:50','PLG0015280','1911000','1911000','0','1911000','0','sby','2026-09-02 20:14:49','FJ-260902-0018','DP-03301','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-09-02','FJ-260902-0019','2026-09-02','20:14:50','VAN','1911000','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-260902-0025','2026-09-02','2026-09-02 20:14:49','PENJUALAN : FJ-260902-0019','','TBC','611000','611000','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-260902-0024','D','2026-09-02','20:14:50','TBC','PENJUALAN','FJ-260902-0019','27182070564','611000','27182681564','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='1049000' WHERE no_faktur_jual='FJ-260902-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0019';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-09-02 ','20:17: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-260902-0020','sby','1',' DP-03370SB','TOKO','SBYPSN','PSPLT-ZHCA-71-0','CINCIN PALADIUM ','','3.070','1','32.00','1297000','0','0','17800','2448000','0','0','0','2448000','VAN','00046763','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHCA-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='PSPLT-ZHCA-71-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-260902-0020','2026-09-02','3.070','2026-09-02','21:24:08','PLG0015281','2448000','2448000','0','2448000','0','sby','2026-09-02 21:24:08','FJ-260902-0020','DP-03370','1800000');
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-09-02','FJ-260902-0020','2026-09-02','21:24:08','VAN','2448000','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-260902-0026','2026-09-02','2026-09-02 21:24:08','PENJUALAN : FJ-260902-0020','','TBC','648000','648000','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-260902-0025','D','2026-09-02','21:24:08','TBC','PENJUALAN','FJ-260902-0020','27182681564','648000','27183329564','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='648000' WHERE no_faktur_jual='FJ-260902-0020' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260902-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260902-0020';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-02';
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-09-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-02' 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-260903-0001','D','2026-09-03','21:26:05','TBC','SALDO AWAL','SALDO AWAL','0','27183329564','27183329564');
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-260903-0001','D','2026-09-03','21:26:05','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','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-260903-0001','D','2026-09-03','21:26:05','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
UPDATE tp_system SET tgl_system='2026-09-03';