INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-19 ','08:39:40');
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-20251219-0001','1','PSGE-YLAH-7-0','1','3.060','3.060','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSGE-YLAH-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGE-YLAH-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGE-YLAH-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGE-YLAH-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-12-19 08:39:52' WHERE kode_barang='PSGE-YLAH-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGE-YLAH-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 ('2025-12-19 08:39:52','TOKO','PSN','PSGE','PSGE-YLAH-7-0','1','3.060','3.060','1','3.060','3.060','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGE-YLAH-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-YLAH-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251219-0001','2025-12-19','08:39','3.060','kasir','2025-12-19 08:39:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-12-19 ','10:35:07');
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YGAA-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YGAA-20-0','ABRE-YGAA-20-0','00037151','RD','2','0.250','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGAA-20-0','00037151','RD','2','0.250','620','155')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YGAA-20-0','ABRE-YGAA-20-0','00037151','RD','12','0.270','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGAA-20-0','00037151','RD','12','0.270','420','113.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YGAA-20-0','ABRE-YGAA-20-0','00037151','RD','12','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGAA-20-0','00037151','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 ('ABRE-YGAA-20-0','00037151','00037151','GIWANG ABR0187 ','GIWANG ABR0187','','','4632000','4632000',' 0','0','spv','2025-12-19 10:49:57');
UPDATE tm_barang SET nama_barang='GIWANG ABR0187' ,nama_atribut='' ,kode_intern='ABR0187 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 36 500 000',total_usd='295.4' WHERE kode_barang='ABRE-YGAA-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAE-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 ('ABRE-YHAE-13-0','ABRE-YHAE-13-0','00038055','RD','2','0.050','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-13-0','00038055','RD','2','0.050','360','18')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-13-0','ABRE-YHAE-13-0','00038055','RD','12','0.130','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-13-0','00038055','RD','12','0.130','360','46.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 ('ABRE-YHAE-13-0','00038055','00038055','GIWANG ABRE-02074 ','GIWANG ABRE-02074','','','4134500','4134500',' 0','0','spv','2025-12-19 10:55:36');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02074' ,nama_atribut='' ,kode_intern='ABRE-02074 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 21 000 000',total_usd='64.8' WHERE kode_barang='ABRE-YHAE-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAD-25-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAD-25-0','ABRE-YHAD-25-0','00038017','RD','2','0.100','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-25-0','00038017','RD','2','0.100','450','45')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAD-25-0','ABRE-YHAD-25-0','00038017','RD','16','0.120','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-25-0','00038017','RD','16','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 ('ABRE-YHAD-25-0','00038017','00038017','GIWANG ABRE-02050 ','GIWANG ABRE-02050','','','2775500','2775500',' 0','0','spv','2025-12-19 10:57:10');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02050' ,nama_atribut='' ,kode_intern='ABRE-02050 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 19 000 000',total_usd='93' WHERE kode_barang='ABRE-YHAD-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YGXB-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 ('ABRE-YGXB-26-0','ABRE-YGXB-26-0','00036897','RD','2','0.320','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGXB-26-0','00036897','RD','2','0.320','750','240')
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 ('ABRE-YGXB-26-0','00036897','00036897','GIWANG ABRE-02026 ','GIWANG ABRE-02026','','','3637000','3637000',' 0','0','spv','2025-12-19 10:58:49');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02026' ,nama_atribut='' ,kode_intern='ABRE-02026 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 29 000 000',total_usd='240' WHERE kode_barang='ABRE-YGXB-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-XGXD-8-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XGXD-8-0','ABRE-XGXD-8-0','00029534','RD','16','0.210','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XGXD-8-0','00029534','RD','16','0.210','360','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XGXD-8-0','ABRE-XGXD-8-0','00029534','RD','2','0.120','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XGXD-8-0','00029534','RD','2','0.120','450','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 ('ABRE-XGXD-8-0','00029534','00029534','ANTING ABRE-01947','ANTING ABRE-01947','','','5972000','5972000',' 0','0','spv','2025-12-19 11:06:38');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01947' ,nama_atribut='' ,kode_intern='ABRE-01947 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT53 1225',total_usd_ext='IDR 33 000 000',total_usd='129.6' WHERE kode_barang='ABRE-XGXD-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAD-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 ('ABRE-YHAD-11-0','ABRE-YHAD-11-0','00038003','RD','18','0.240','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-11-0','00038003','RD','18','0.240','400','96')
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 ('ABRE-YHAD-11-0','00038003','00038003','ANTING ABRE-02036 ','ANTING ABRE-02036','','','3445500','3445500',' 0','0','spv','2025-12-19 11:08:07');
UPDATE tm_barang SET nama_barang='ANTING ABRE-02036' ,nama_atribut='' ,kode_intern='ABRE-02036 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT24 1225',total_usd_ext='IDR 21 000 000',total_usd='96' WHERE kode_barang='ABRE-YHAD-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAE-152-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-152-0','ABRE-YHAE-152-0','00038194','RD','2','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-152-0','00038194','RD','2','0.040','420','16.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-152-0','ABRE-YHAE-152-0','00038194','RD','12','0.155','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-152-0','00038194','RD','12','0.155','420','65.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-152-0','ABRE-YHAE-152-0','00038194','RD','14','0.100','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-152-0','00038194','RD','14','0.100','450','45')
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 ('ABRE-YHAE-152-0','00038194','00038194','ANTING ABRE-02081 ','ANTING ABRE-02081','','','6622500','6622500',' 0','0','spv','2025-12-19 11:09:56');
UPDATE tm_barang SET nama_barang='ANTING ABRE-02081' ,nama_atribut='' ,kode_intern='ABRE-02081 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT117 1225',total_usd_ext='IDR 36 000 000',total_usd='126.9' WHERE kode_barang='ABRE-YHAE-152-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-WFXA-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 ('ABRE-WFXA-36-0','ABRE-WFXA-36-0','00022110','RD','16','0.040','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WFXA-36-0','00022110','RD','16','0.040','450','18')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WFXA-36-0','ABRE-WFXA-36-0','00022110','RD','2','0.170','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WFXA-36-0','00022110','RD','2','0.170','600','102')
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 ('ABRE-WFXA-36-0','00022110','00022110','GIWANG ABRE-01751','GIWANG ABRE-01751','','','6513500','6513500',' 0','0','spv','2025-12-19 11:11:39');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01751' ,nama_atribut='' ,kode_intern='ABRE-01751 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 33 000 000',total_usd='120' WHERE kode_barang='ABRE-WFXA-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-WEBB-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 ('ABRE-WEBB-11-0','ABRE-WEBB-11-0','00021836','RD','2','0.145','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WEBB-11-0','00021836','RD','2','0.145','450','65.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WEBB-11-0','ABRE-WEBB-11-0','00021836','RD','2','0.185','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WEBB-11-0','00021836','RD','2','0.185','600','111')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WEBB-11-0','ABRE-WEBB-11-0','00021836','RD','16','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WEBB-11-0','00021836','RD','16','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 ('ABRE-WEBB-11-0','00021836','00021836','ANTING ABRE-01726','ANTING ABRE-01726','','','7458000','7458000',' 0','0','spv','2025-12-19 11:13:53');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01726' ,nama_atribut='' ,kode_intern='ABRE-01726 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 39 500 000',total_usd='193.05' WHERE kode_barang='ABRE-WEBB-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHXD-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 ('ABRE-YHXD-9-0','ABRE-YHXD-9-0','00037850','RD','2','0.065','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHXD-9-0','00037850','RD','2','0.065','320','20.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHXD-9-0','ABRE-YHXD-9-0','00037850','RD','10','0.280','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHXD-9-0','00037850','RD','10','0.280','320','89.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHXD-9-0','ABRE-YHXD-9-0','00037850','RD','24','0.080','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHXD-9-0','00037850','RD','24','0.080','320','25.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 ('ABRE-YHXD-9-0','00037850','00037850','ANTING ABRE-00893','ANTING ABRE-00893','','','5085000','5085000',' 0','0','spv','2025-12-19 11:18:02');
UPDATE tm_barang SET nama_barang='ANTING ABRE-00893' ,nama_atribut='' ,kode_intern='ABRE-00893 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 27 500 000',total_usd='136' WHERE kode_barang='ABRE-YHXD-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-PHBX-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 ('ABRE-PHBX-19-0','ABRE-PHBX-19-0','00016727','RD','14','0.190','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-PHBX-19-0','00016727','RD','14','0.190','420','79.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-PHBX-19-0','ABRE-PHBX-19-0','00016727','RD','12','0.295','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-PHBX-19-0','00016727','RD','12','0.295','450','132.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-PHBX-19-0','ABRE-PHBX-19-0','00016727','RD','2','0.125','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-PHBX-19-0','00016727','RD','2','0.125','475','59.38')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-PHBX-19-0','ABRE-PHBX-19-0','00016727','RD','2','0.210','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-PHBX-19-0','00016727','RD','2','0.210','620','130.2')
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 ('ABRE-PHBX-19-0','00016727','00016727','1PS ANTING BERLIAN','ANTING ABRE-01404','','','6565000','6565000',' 0','0','spv','2025-12-19 11:22:06');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01404' ,nama_atribut='' ,kode_intern='ABRE-01404 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='A94LTS6MM 1225',total_usd_ext='IDR 50 500 000',total_usd='402.13' WHERE kode_barang='ABRE-PHBX-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAE-146-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-146-0','ABRE-YHAE-146-0','00038188','RD','2','0.365','720');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-146-0','00038188','RD','2','0.365','720','262.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-146-0','ABRE-YHAE-146-0','00038188','RD','16','0.625','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-146-0','00038188','RD','16','0.625','480','300')
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 ('ABRE-YHAE-146-0','00038188','00038188','GIWANG ABRE-02075 ','GIWANG ABRE-02075','','','5933500','5933500',' 0','0','spv','2025-12-19 11:23:43');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02075' ,nama_atribut='' ,kode_intern='ABRE-02075 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW119 1225',total_usd_ext='IDR 55 500 000',total_usd='562.8' WHERE kode_barang='ABRE-YHAE-146-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-WFBC-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 ('ABRE-WFBC-9-0','ABRE-WFBC-9-0','00022582','RD','16','0.110','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WFBC-9-0','00022582','RD','16','0.110','450','49.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WFBC-9-0','ABRE-WFBC-9-0','00022582','RD','2','0.090','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WFBC-9-0','00022582','RD','2','0.090','480','43.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WFBC-9-0','ABRE-WFBC-9-0','00022582','RD','2','0.060','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WFBC-9-0','00022582','RD','2','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 ('ABRE-WFBC-9-0','00022582','00022582','ANTING ABRE-01759','ANTING ABRE-01759','','','5072500','5072500',' 0','0','spv','2025-12-19 13:08:22');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01759' ,nama_atribut='' ,kode_intern='ABRE-01759 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT83 1225',total_usd_ext='IDR 28 000 000',total_usd='116.7' WHERE kode_barang='ABRE-WFBC-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-XCAI-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 ('ABRE-XCAI-9-0','ABRE-XCAI-9-0','00027507','RD','26','0.095','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAI-9-0','00027507','RD','26','0.095','420','39.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XCAI-9-0','ABRE-XCAI-9-0','00027507','RD','24','0.165','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAI-9-0','00027507','RD','24','0.165','420','69.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XCAI-9-0','ABRE-XCAI-9-0','00027507','RD','4','0.070','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAI-9-0','00027507','RD','4','0.070','420','29.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 ('ABRE-XCAI-9-0','00027507','00027507','ANTING ABRE-01926','ANTING ABRE-01926','','','7814500','7814500',' 0','0','spv','2025-12-19 13:10:24');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01926' ,nama_atribut='' ,kode_intern='ABRE-01926 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 38 000 000',total_usd='138.6' WHERE kode_barang='ABRE-XCAI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-XCAE-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 ('ABRE-XCAE-17-0','ABRE-XCAE-17-0','00027450','RD','2','0.205','650');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAE-17-0','00027450','RD','2','0.205','650','133.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XCAE-17-0','ABRE-XCAE-17-0','00027450','RD','12','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAE-17-0','00027450','RD','12','0.065','420','27.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XCAE-17-0','ABRE-XCAE-17-0','00027450','RD','36','0.735','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAE-17-0','00027450','RD','36','0.735','420','308.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XCAE-17-0','ABRE-XCAE-17-0','00027450','RD','12','0.815','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XCAE-17-0','00027450','RD','12','0.815','450','366.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 ('ABRE-XCAE-17-0','00027450','00027450','GIWANG ABRE-01921','GIWANG ABRE-01921','','','12671000','12671000',' 0','0','spv','2025-12-19 13:12:26');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01921' ,nama_atribut='' ,kode_intern='ABRE-01921 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW93 1225',total_usd_ext='IDB 96 000 000',total_usd='836' WHERE kode_barang='ABRE-XCAE-17-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-19 ','13:13:36');
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YIAE-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 ('ABRE-YIAE-13-0','ABRE-YIAE-13-0','00038722','RD','10','0.400','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YIAE-13-0','00038722','RD','10','0.400','320','128')
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 ('ABRE-YIAE-13-0','00038722','00038722','ANTING ABRE-00356 ','ANTING ABRE-00356','','','4514500','4514500',' 0','0','spv','2025-12-19 13:13:46');
UPDATE tm_barang SET nama_barang='ANTING ABRE-00356' ,nama_atribut='' ,kode_intern='ABRE-00356 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT59 1225',total_usd_ext='IDB 26 000 000',total_usd='128' WHERE kode_barang='ABRE-YIAE-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAD-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 ('ABRE-YHAD-14-0','ABRE-YHAD-14-0','00038006','RD','6','0.300','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-14-0','00038006','RD','6','0.300','450','135')
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 ('ABRE-YHAD-14-0','00038006','00038006','ANTING ABRE-02039 ','ANTING ABRE-02039','','','5072500','5072500',' 0','0','spv','2025-12-19 13:15:09');
UPDATE tm_barang SET nama_barang='ANTING ABRE-02039' ,nama_atribut='' ,kode_intern='ABRE-02039 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT60 1225',total_usd_ext='IDR 29 000 000',total_usd='135' WHERE kode_barang='ABRE-YHAD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAE-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 ('ABRE-YHAE-7-0','ABRE-YHAE-7-0','00038049','RD','36','0.170','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-7-0','00038049','RD','36','0.170','400','68')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-7-0','ABRE-YHAE-7-0','00038049','RD','12','0.215','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-7-0','00038049','RD','12','0.215','420','90.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-7-0','ABRE-YHAE-7-0','00038049','RD','2','0.040','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-7-0','00038049','RD','2','0.040','360','14.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 ('ABRE-YHAE-7-0','00038049','00038049','GIWANG ABRE-02068','GIWANG ABRE-02068','','','4383500','4383500',' 0','0','spv','2025-12-19 13:16:43');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02068' ,nama_atribut='' ,kode_intern='ABRE-02068 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 29 500 000',total_usd='172.7' WHERE kode_barang='ABRE-YHAE-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YGXI-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 ('ABRE-YGXI-31-0','ABRE-YGXI-31-0','00037092','RD','2','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGXI-31-0','00037092','RD','2','0.065','420','27.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YGXI-31-0','ABRE-YGXI-31-0','00037092','RD','12','0.290','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGXI-31-0','00037092','RD','12','0.290','420','121.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YGXI-31-0','ABRE-YGXI-31-0','00037092','RD','14','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YGXI-31-0','00037092','RD','14','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 ('ABRE-YGXI-31-0','00037092','00037092','ANTING ABRE-02030 ','ANTING ABRE-02030','','','4498000','4498000',' 0','0','spv','2025-12-19 13:18:17');
UPDATE tm_barang SET nama_barang='ANTING ABRE-02030' ,nama_atribut='' ,kode_intern='ABRE-02030 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT109 1225',total_usd_ext='IDB 30 500 000',total_usd='182.85' WHERE kode_barang='ABRE-YGXI-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YFBD-34-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YFBD-34-0','ABRE-YFBD-34-0','00036697','RD','2','0.230','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YFBD-34-0','00036697','RD','2','0.230','620','142.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YFBD-34-0','ABRE-YFBD-34-0','00036697','RD','40','0.100','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YFBD-34-0','00036697','RD','40','0.100','450','45')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YFBD-34-0','ABRE-YFBD-34-0','00036697','RD','16','0.040','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YFBD-34-0','00036697','RD','16','0.040','450','18')
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 ('ABRE-YFBD-34-0','00036697','00036697','GIWANG ABRE-01741 ','GIWANG ABRE-01741','','','3658000','3658000',' 0','0','spv','2025-12-19 13:19:57');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01741' ,nama_atribut='' ,kode_intern='ABRE-01741 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 28 500 000',total_usd='205.6' WHERE kode_barang='ABRE-YFBD-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-XHAC-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 ('ABRE-XHAC-30-0','ABRE-XHAC-30-0','00030555','RD','2','0.045','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XHAC-30-0','00030555','RD','2','0.045','420','18.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XHAC-30-0','ABRE-XHAC-30-0','00030555','RD','16','0.275','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XHAC-30-0','00030555','RD','16','0.275','420','115.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 ('ABRE-XHAC-30-0','00030555','00030555','ANTING ABRE-01686','ANTING ABRE-01686','','','6622500','6622500',' 0','0','spv','2025-12-19 13:21:49');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01686' ,nama_atribut='' ,kode_intern='ABRE-01686 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT132 1225',total_usd_ext='IDB 35 500 000',total_usd='134.4' WHERE kode_barang='ABRE-XHAC-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAE-12-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-12-0','ABRE-YHAE-12-0','00038054','RD','2','0.040','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-12-0','00038054','RD','2','0.040','360','14.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-12-0','ABRE-YHAE-12-0','00038054','RD','12','0.125','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-12-0','00038054','RD','12','0.125','360','45')
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 ('ABRE-YHAE-12-0','00038054','00038054','GIWANG ABRE-02073 ','GIWANG ABRE-02073','','','4287500','4287500',' 0','0','spv','2025-12-19 13:23:18');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02073' ,nama_atribut='' ,kode_intern='ABRE-02073 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 21 500 000',total_usd='59.4' WHERE kode_barang='ABRE-YHAE-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YBAH-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 ('ABRE-YBAH-4-0','ABRE-YBAH-4-0','00034182','RD','16','0.035','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YBAH-4-0','00034182','RD','16','0.035','420','14.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YBAH-4-0','ABRE-YBAH-4-0','00034182','RD','2','0.100','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YBAH-4-0','00034182','RD','2','0.100','450','45')
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 ('ABRE-YBAH-4-0','00034182','00034182','GIWANG ABRE-01914','GIWANG ABRE-01914','','','3254500','3254500',' 0','0','spv','2025-12-19 13:24:54');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01914' ,nama_atribut='' ,kode_intern='ABRE-01914 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 17 500 000',total_usd='59.7' WHERE kode_barang='ABRE-YBAH-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YFBD-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 ('ABRE-YFBD-31-0','ABRE-YFBD-31-0','00036694','RD','6','0.340','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YFBD-31-0','00036694','RD','6','0.340','480','163.2')
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 ('ABRE-YFBD-31-0','00036694','00036694','ANTING ABRE-01142 ','ANTING ABRE-01142','','','5206500','5206500',' 0','0','spv','2025-12-19 13:27:07');
UPDATE tm_barang SET nama_barang='ANTING ABRE-01142' ,nama_atribut='' ,kode_intern='ABRE-01142 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT60 1225',total_usd_ext='IDB 31 000 000',total_usd='163.2' WHERE kode_barang='ABRE-YFBD-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-XBAF-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 ('ABRE-XBAF-14-0','ABRE-XBAF-14-0','00026648','RD','16','0.155','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XBAF-14-0','00026648','RD','16','0.155','420','65.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-XBAF-14-0','ABRE-XBAF-14-0','00026648','RD','6','0.290','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XBAF-14-0','00026648','RD','6','0.290','450','130.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 ('ABRE-XBAF-14-0','00026648','00026648','GIWANG ABRE-01140','GIWANG ABRE-01140','','','8598500','8598500',' 0','0','spv','2025-12-19 13:28:50');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01140' ,nama_atribut='' ,kode_intern='ABRE-01140 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 44 000 000',total_usd='195.6' WHERE kode_barang='ABRE-XBAF-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-WKXF-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 ('ABRE-WKXF-4-0','ABRE-WKXF-4-0','00024725','RD','8','0.205','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WKXF-4-0','00024725','RD','8','0.205','420','86.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WKXF-4-0','ABRE-WKXF-4-0','00024725','RD','6','0.085','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WKXF-4-0','00024725','RD','6','0.085','420','35.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WKXF-4-0','ABRE-WKXF-4-0','00024725','RD','28','0.130','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WKXF-4-0','00024725','RD','28','0.130','450','58.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WKXF-4-0','ABRE-WKXF-4-0','00024725','BG','8','0.145','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WKXF-4-0','00024725','BG','8','0.145','400','58')
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 ('ABRE-WKXF-4-0','00024725','00024725','GIWANG ABRE-01832','GIWANG ABRE-01832','','','8004500','8004500',' 0','0','spv','2025-12-19 13:33:40');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01832' ,nama_atribut='' ,kode_intern='ABRE-01832 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 43 000 000',total_usd='238.3' WHERE kode_barang='ABRE-WKXF-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAD-45-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAD-45-0','ABRE-YHAD-45-0','00038037','RD','2','0.030','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-45-0','00038037','RD','2','0.030','370','11.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAD-45-0','ABRE-YHAD-45-0','00038037','RD','12','0.125','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-45-0','00038037','RD','12','0.125','400','50')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAD-45-0','ABRE-YHAD-45-0','00038037','RD','16','0.085','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAD-45-0','00038037','RD','16','0.085','450','38.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 ('ABRE-YHAD-45-0','00038037','00038037','ANTING ABRE-02056 ','ANTING ABRE-02056','','','5015000','5015000',' 0','0','spv','2025-12-19 13:35:28');
UPDATE tm_barang SET nama_barang='ANTING ABRE-02056' ,nama_atribut='' ,kode_intern='ABRE-02056 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT117 1225',total_usd_ext='IDR 27 000 000',total_usd='99.35' WHERE kode_barang='ABRE-YHAD-45-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YHAE-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 ('ABRE-YHAE-4-0','ABRE-YHAE-4-0','00038046','RD','26','0.125','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-4-0','00038046','RD','26','0.125','450','56.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-4-0','ABRE-YHAE-4-0','00038046','RD','2','0.085','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-4-0','00038046','RD','2','0.085','475','40.38')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-YHAE-4-0','ABRE-YHAE-4-0','00038046','RD','8','0.020','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-YHAE-4-0','00038046','RD','8','0.020','450','9')
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 ('ABRE-YHAE-4-0','00038046','00038046','GIWANG ABRE-02065 ','GIWANG ABRE-02065','','','4133000','4133000',' 0','0','spv','2025-12-19 13:37:29');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-02065' ,nama_atribut='' ,kode_intern='ABRE-02065 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDR 23 500 000',total_usd='105.63' WHERE kode_barang='ABRE-YHAE-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-XHXH-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 ('ABRE-XHXH-16-0','ABRE-XHXH-16-0','00030450','RD','32','0.350','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-XHXH-16-0','00030450','RD','32','0.350','420','147')
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 ('ABRE-XHXH-16-0','00030450','00030450','GIWANG ABRE-01628','GIWANG ABRE-01628','','','3771000','3771000',' 0','0','spv','2025-12-19 13:38:47');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-01628' ,nama_atribut='' ,kode_intern='ABRE-01628 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW77 1225',total_usd_ext='IDB 25 500 000',total_usd='147' WHERE kode_barang='ABRE-XHXH-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-WHXC-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 ('ABRE-WHXC-5-0','ABRE-WHXC-5-0','00023295','RD','2','0.170','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WHXC-5-0','00023295','RD','2','0.170','620','105.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRE-WHXC-5-0','ABRE-WHXC-5-0','00023295','RD','16','0.040','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRE-WHXC-5-0','00023295','RD','16','0.040','450','18')
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 ('ABRE-WHXC-5-0','00023295','00023295','GIWANG ABRE-00056','GIWANG ABRE-00056','','','6513500','6513500',' 0','0','spv','2025-12-19 13:40:49');
UPDATE tm_barang SET nama_barang='GIWANG ABRE-00056' ,nama_atribut='' ,kode_intern='ABRE-00056 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1225',total_usd_ext='IDB 33 000 000',total_usd='123.4' WHERE kode_barang='ABRE-WHXC-5-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-12-19 ','13:56:54');
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 ('FE-251219-0001','kasir','1',' CBRE-05188','TOKO','CBR','CBRE-YEXI-17-0','CINCIN CBRE-05188','','3.420','1','83.00','17127000','9023500','539','16750','20000000','0','0','0','20000000','BARY','00035522','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YEXI-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.420',berat_jual_asli=berat_jual_asli+'3.420',stock_jual='1',berat_akhir=berat_akhir-'3.420',berat_akhir_asli=berat_akhir_asli-'3.420',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='CBRE-YEXI-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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 ('FE-251219-0001','2025-12-19','3.420','2025-12-19','13:59:45','PLG0027568','20000000','20000000','0','20000000','0','kasir','2025-12-19 13:59:45','FE-251219-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-19','FE-251219-0001','2025-12-19','13:59:45','BARY','20000000','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-251219-0001','2025-12-19','2025-12-19 13:59:45','PENJUALAN : FE-251219-0001','','TBC','20000000','20000000','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-251219-0002','D','2025-12-19','13:59:45','TBC','PENJUALAN BERLIAN','FE-251219-0001','93682407185','20000000','93702407185','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='20000000' WHERE no_faktur_jual='FE-251219-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0001';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07918','BARY','1','CBRE05188','JD NO 18 5 CROM KOMBINASI','3.420','1','200000','200000');
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-251219-0002','2025-12-19','2025-12-19 14:04:23','SERVICE : SV-07918','-','TBC','200000','200000','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-251219-0003','D','2025-12-19','14:04:23','TBC','SERVICE','SV-07918','93702407185','200000','93702607185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-07918','2025-12-19','2025-12-19','14:04:23','PLG0027569','kasir','2025-12-24','kasir','2025-12-19 14:04:23','3.420','0','0','0','200000','0','200000','200000','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 ('FE-251219-0002','kasir','1',' DP-02909 ','TOKO','PSN','PSPLE-YLAE-1-0','CINCIN PALADIUM ','','3.310','1','6.00','500000','0','0','16750','1693000','0','0','0','1693000','NANA','00040561','PSPLE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLE-YLAE-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.310',berat_jual_asli=berat_jual_asli+'3.310',stock_jual='1',berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='PSPLE-YLAE-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PSN' 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 ('FE-251219-0002','2025-12-19','3.310','2025-12-19','14:14:17','PLG0027570','1693000','1693000','0','1693000','0','kasir','2025-12-19 14:14:16','FE-251219-0002','DP-02909','1520000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-19','FE-251219-0002','2025-12-19','14:14:17','NANA','1693000','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-251219-0003','2025-12-19','2025-12-19 14:14:16','PENJUALAN : FE-251219-0002','.','TBC','173000','173000','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-251219-0004','D','2025-12-19','14:14:17','TBC','PENJUALAN','FE-251219-0002','93702607185','173000','93702780185','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='173000' WHERE no_faktur_jual='FE-251219-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-19 ','14:32:34');
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-20251219-0002','1','PSPLE-YLAI-1-0','1','5.090','5.090','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLE-YLAI-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-YLAI-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLE-YLAI-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-YLAI-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-12-19 14:32:42' WHERE kode_barang='PSPLE-YLAI-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-YLAI-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-19 14:32:42','TOKO','PSN','PSPLE','PSPLE-YLAI-1-0','1','5.090','5.090','1','5.090','5.090','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLE-YLAI-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YLAI-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0002','1','PSBRE-YLAI-4-0','1','5.020','5.020','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSBRE-YLAI-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSBRE-YLAI-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBRE-YLAI-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSBRE-YLAI-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-12-19 14:32:42' WHERE kode_barang='PSBRE-YLAI-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSBRE-YLAI-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 ('2025-12-19 14:32:42','TOKO','PSN','PSBRE','PSBRE-YLAI-4-0','1','5.020','5.020','1','5.020','5.020','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSBRE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSBRE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSBRE-YLAI-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSBRE-YLAI-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251219-0002','2025-12-19','14:32','10.110','kasir','2025-12-19 14:32:42');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07919','BARY','1','GBRE','DILASER YG KUAT YA DIBAGIAN YG PATAH DAN CROM ULANG','8.570','1','200000','200000');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-07919','2025-12-19','2025-12-19','15:13:33','PLG0027571','kasir','2025-12-24','kasir','2025-12-19 15:13:33','8.570','0','0','0','0','0','200000','200000','200000');
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 ('FE-251219-0003','kasir','1',' LBRE-00842','TOKO','LBR','LBRE-YJXG-18-0','LIONTIN LBRE-00842 ','','0.910','1','103.00','4836000','2234000','133','16750','6000000','0','0','0','6000000','ONLILUNG','00039068','LBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LBRE-YJXG-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='LBRE-YJXG-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LBR' 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 ('FE-251219-0003','2025-12-19','0.910','2025-12-19','15:20:47','PLG0027572','6000000','6000000','0','6000000','0','kasir','2025-12-19 15:20:46','FE-251219-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-19','FE-251219-0003','2025-12-19','15:20:47','ONLILUNG','6000000','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-251219-0004','2025-12-19','2025-12-19 15:20:46','PENJUALAN : FE-251219-0003','','TBC','6000000','6000000','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-251219-0005','D','2025-12-19','15:20:47','TBC','PENJUALAN BERLIAN','FE-251219-0003','93702780185','6000000','93708780185','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='6000000' WHERE no_faktur_jual='FE-251219-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-251219-0004','kasir',' 1',' LBRE-00351','TOKO','LBR','LBRE-YJXG-19-0','LIONTIN LBRE-00351 ','','1.630','1','75.00','5490000','2171000','130','16750','6800000','0','0','0','6800000','ONLILUNG','00039069','LBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LBRE-YJXG-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='LBRE-YJXG-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LBR' 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 ('FE-251219-0004','2025-12-19','1.630','2025-12-19','15:20:47','PLG0027573','6800000','6800000','0','6800000','0','kasir','2025-12-19 15:20:46','FE-251219-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-19','FE-251219-0004','2025-12-19','15:20:47','ONLILUNG','6800000','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-251219-0005','2025-12-19','2025-12-19 15:20:46','PENJUALAN : FE-251219-0004','','TBC','6800000','6800000','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-251219-0006','D','2025-12-19','15:20:47','TBC','PENJUALAN BERLIAN','FE-251219-0004','93708780185','6800000','93715580185','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='12800000' WHERE no_faktur_jual='FE-251219-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0004';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-251219-0005','kasir','1',' CKPRE-0068','TOKO','PERAK','CKPRE-XJAF-11-0','CINCIN KAWIN CKPRE-00683','','4.780','1','100.00','283000','150000','0','16750','700000','0','0','0','700000','ONLASRI','00031789','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-XJAF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.780',berat_jual_asli=berat_jual_asli+'4.780',stock_jual='1',berat_akhir=berat_akhir-'4.780',berat_akhir_asli=berat_akhir_asli-'4.780',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='CKPRE-XJAF-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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 ('FE-251219-0005','2025-12-19','4.780','2025-12-19','16:01:39','PLG0027574','700000','700000','0','700000','0','kasir','2025-12-19 16:01:38','FE-251219-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-19','FE-251219-0005','2025-12-19','16:01:39','ONLASRI','700000','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-251219-0006','2025-12-19','2025-12-19 16:01:38','PENJUALAN : FE-251219-0005','.','TBC','700000','700000','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-251219-0007','D','2025-12-19','16:01:39','TBC','PENJUALAN','FE-251219-0005','93715580185','700000','93716280185','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='700000' WHERE no_faktur_jual='FE-251219-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0005';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07920','ASRI','1','CKBE DAN SILVER','CKBE RESIZE KE 16 GRF ?? DEVI HARIYADI CROM PUTIH DOFF SEMPROT SETENGAH SLV GRF ?? RETNO AYU .P CROM PUTIH DOFF AMPLAS','6.650','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-07920','2025-12-19','2025-12-19','16:18:22','PLG0027575','kasir','2025-12-24','kasir','2025-12-19 16:18:22','6.650','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-19 ','16:24:30');
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-20251219-0003','1','LGM50-YLAI-5-0','1','50.000','50.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM50-YLAI-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM50-YLAI-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM50-YLAI-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM50-YLAI-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM50-YLAI-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM50-YLAI-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-19 16:25:02','TOKO','LM','LGM50','LGM50-YLAI-5-0','1','50.000','50.000','1','50.000','50.000','105.00');
DELETE FROM tm_dept WHERE kode_dept='LGM50' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM50' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM50-YLAI-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM50-YLAI-5-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM50-YLAI-6-0','1','50.000','50.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM50-YLAI-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM50-YLAI-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM50-YLAI-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM50-YLAI-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM50-YLAI-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM50-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM50','LGM50-YLAI-6-0','1','50.000','50.000','1','50.000','50.000','105.00');
DELETE FROM tm_dept WHERE kode_dept='LGM50' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM50' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM50-YLAI-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM50-YLAI-6-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM25-YLAI-7-0','1','25.000','25.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM25-YLAI-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM25-YLAI-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM25-YLAI-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM25-YLAI-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM25-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM25','LGM25-YLAI-7-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM25-YLAI-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM25-YLAI-8-0','1','25.000','25.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM25-YLAI-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM25-YLAI-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM25-YLAI-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM25-YLAI-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM25-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM25','LGM25-YLAI-8-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM25-YLAI-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-8-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM25-YLAI-9-0','1','25.000','25.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM25-YLAI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM25-YLAI-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM25-YLAI-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM25-YLAI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM25-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM25','LGM25-YLAI-9-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM25-YLAI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-9-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM25-YLAI-10-0','1','25.000','25.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM25-YLAI-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM25-YLAI-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM25-YLAI-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM25-YLAI-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM25-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM25','LGM25-YLAI-10-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM25-YLAI-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-10-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM25-YLAI-11-0','1','25.000','25.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM25-YLAI-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM25-YLAI-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM25-YLAI-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM25-YLAI-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM25-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM25','LGM25-YLAI-11-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM25-YLAI-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' 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-20251219-0003','1','LGM25-YLAI-12-0','1','25.000','25.000','TOKO','LM','TOKO','LM');
DELETE FROM tm_barang WHERE kode_barang='LGM25-YLAI-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LGM25-YLAI-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LGM25-YLAI-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LM',tgl_last_beli='2025-12-19 16:25:02' WHERE kode_barang='LGM25-YLAI-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LGM25-YLAI-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 ('2025-12-19 16:25:02','TOKO','LM','LGM25','LGM25-YLAI-12-0','1','25.000','25.000','1','25.000','25.000','107.00');
DELETE FROM tm_dept WHERE kode_dept='LGM25' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LGM25' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LGM25-YLAI-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='LGM25-YLAI-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-12-19' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251219-0003','2025-12-19','16:24','250.000','kasir','2025-12-19 16:25:02');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251219-0002','K','2025-12-19','16:32:16','kasir','KIRIM PAKET','JNE MAKASSAR','9686690','85000','9601690');
UPDATE tt_service_head SET tgl_selesai='2025-12-19',  status ='DONE' WHERE no_service='SV-07913';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-07913';
UPDATE tt_service_head SET tgl_selesai='2025-12-19',  status ='DONE' WHERE no_service='SV-07871';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-07871';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2025-12-19',  status ='CLOS' WHERE no_service='SV-07871';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-07871';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2025-12-19',  status ='CLOS' WHERE no_service='SV-07913';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-07913';
UPDATE tt_service_head SET tgl_selesai='2025-12-19',  status ='DONE' WHERE no_service='SV-07916';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-07916';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2025-12-19',  status ='CLOS' WHERE no_service='SV-07916';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-07916';
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 ('FE-251219-0006','kasir','1',' GLRRE75-85','TOKO','GLR','GLRR-XIXF-35-0','GELANG RANTAI ROSE GOLD ','','3.510','1','85.00','6949000','0','0','16750','7100000','0','0','0','7100000','NANA','00031155','GLRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GLRR-XIXF-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='GLRR-XIXF-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GLR' 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 ('FE-251219-0006','2025-12-19','3.510','2025-12-19','19:24:12','PLG0027576','7100000','7100000','0','7100000','0','kasir','2025-12-19 19:24:11','FE-251219-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('2025-12-19','FE-251219-0006','2025-12-19','19:24:12','NANA','7100000','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-251219-0007','2025-12-19','2025-12-19 19:24:11','PENJUALAN : FE-251219-0006','.','TBC','7100000','7100000','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-251219-0008','D','2025-12-19','19:24:12','TBC','PENJUALAN','FE-251219-0006','93716280185','7100000','93723380185','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='7100000' WHERE no_faktur_jual='FE-251219-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0006';
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 ('FE-251219-0007','kasir','1',' CMRE75-85%','TOKO','CMP','CMR-YKAI-43-0','CINCIN MAS ROSE GOLD ','','1.670','1','85.00','3339000','0','0','16750','3400000','0','0','0','3400000','NANA','00039703','CMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMR-YKAI-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2025-12-19' AND kode_barang='CMR-YKAI-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CMP' 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 ('FE-251219-0007','2025-12-19','1.670','2025-12-19','19:29:27','PLG0027577','3400000','3400000','0','3400000','0','kasir','2025-12-19 19:29:27','FE-251219-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-19','FE-251219-0007','2025-12-19','19:29:27','NANA','3400000','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-251219-0008','2025-12-19','2025-12-19 19:29:27','PENJUALAN : FE-251219-0007','.','TBC','3400000','3400000','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-251219-0009','D','2025-12-19','19:29:27','TBC','PENJUALAN','FE-251219-0007','93723380185','3400000','93726780185','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='3400000' WHERE no_faktur_jual='FE-251219-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251219-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251219-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-19';
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='2025-12-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-19' 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-251220-0001','D','2025-12-20','20:07:28','TBC','SALDO AWAL','SALDO AWAL','0','93726780185','93726780185');
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-251220-0001','D','2025-12-20','20:07:28','BCK','SALDO AWAL','SALDO AWAL','0','16193507978.088','16193507978.088');
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-251220-0001','D','2025-12-20','20:07:28','BCD','SALDO AWAL','SALDO AWAL','0','14935321700','14935321700');
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-251220-0001','D','2025-12-20','20:07:28','','SALDO AWAL','SALDO AWAL','0','16885500','16885500');
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-251220-0001','D','2025-12-20','20:07:28','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
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-251220-0001','D','2025-12-20','20:07:28','SHO','SALDO AWAL','SALDO AWAL','0','2741005684','2741005684');
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-251220-0001','D','2025-12-20','20:07:28','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
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-251220-0001','D','2025-12-20','20:07:28','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
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-251220-0001','D','2025-12-20','20:07:28','6000000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251220-0001','D','2025-12-20','20:07:28','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
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-251220-0001','D','2025-12-20','20:07:28','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
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-251220-0001','D','2025-12-20','20:07:28','BCA','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251220-0001','D','2025-12-20','20:07:28','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
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-251220-0001','D','2025-12-20','20:07:28','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
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-251220-0001','D','2025-12-20','20:07:28','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251220-0001','D','2025-12-20','20:07:28','3450000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251220-0001','D','2025-12-20','20:07:28','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
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-251220-0001','D','2025-12-20','20:07:28','4000000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251220-0001','D','2025-12-20','20:07:28','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
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-251220-0001','D','2025-12-20','20:07:28','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
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-251220-0001','D','2025-12-20','20:07:28','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
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-251220-0001','D','2025-12-20','20:07:28','DPE','SALDO AWAL','SALDO AWAL','0','208548800','208548800');
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-251220-0001','D','2025-12-20','20:07:28','TMR','SALDO AWAL','SALDO AWAL','0','8432183779','8432183779');
UPDATE tp_system SET tgl_system='2025-12-20';