INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-26 ','09:28:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','09:38:52');
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-20251126-0001','1','PSPRE-YKBE-162-0','1','2.600','2.600','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRE-YKBE-162-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRE-YKBE-162-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRE-YKBE-162-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRE-YKBE-162-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-11-26 09:39:02' WHERE kode_barang='PSPRE-YKBE-162-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRE-YKBE-162-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-11-26 09:39:02','TOKO','PSN','PSPRE','PSPRE-YKBE-162-0','1','2.600','2.600','1','2.600','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRE-YKBE-162-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-YKBE-162-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PSPLE-YKBF-1-0','1','3.100','3.100','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLE-YKBF-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-YKBF-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLE-YKBF-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-YKBF-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-11-26 09:39:02' WHERE kode_barang='PSPLE-YKBF-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-YKBF-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-11-26 09:39:02','TOKO','PSN','PSPLE','PSPLE-YKBF-1-0','1','3.100','3.100','1','3.100','3.100','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-YKBF-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YKBF-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PSPLE-YKBF-22-0','1','2.990','2.990','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLE-YKBF-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-YKBF-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLE-YKBF-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-YKBF-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-11-26 09:39:02' WHERE kode_barang='PSPLE-YKBF-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-YKBF-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 09:39:02','TOKO','PSN','PSPLE','PSPLE-YKBF-22-0','1','2.990','2.990','1','2.990','2.990','14.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-YKBF-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YKBF-22-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251126-0001','2025-11-26','09:38','8.690','kasir','2025-11-26 09:39:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-26 ','09:40:30');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XFBF-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 ('CBRE-XFBF-8-0','CBRE-XFBF-8-0','00029227','RD','10','0.115','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XFBF-8-0','00029227','RD','10','0.115','450','51.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XFBF-8-0','CBRE-XFBF-8-0','00029227','RD','17','0.185','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XFBF-8-0','00029227','RD','17','0.185','420','77.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XFBF-8-0','CBRE-XFBF-8-0','00029227','RD','8','0.305','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XFBF-8-0','00029227','RD','8','0.305','420','128.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XFBF-8-0','00029227','00029227','CINCIN CBRE-03190','CINCIN CBRE-03190','','','9037000','9037000',' 0','0','spv','2025-11-26 09:41:55');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03190' ,nama_atribut='' ,kode_intern='CBRE-03190 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 5 1125',total_usd_ext='IDB 49 000 000',total_usd='257.55' WHERE kode_barang='CBRE-XFBF-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGBB-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 ('CBRE-YGBB-36-0','CBRE-YGBB-36-0','00037437','RD','12','0.035','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-36-0','00037437','RD','12','0.035','450','15.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-36-0','CBRE-YGBB-36-0','00037437','RD','6','0.055','380');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-36-0','00037437','RD','6','0.055','380','20.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-36-0','CBRE-YGBB-36-0','00037437','RD','2','0.090','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-36-0','00037437','RD','2','0.090','370','33.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-36-0','CBRE-YGBB-36-0','00037437','RD','28','0.560','380');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-36-0','00037437','RD','28','0.560','380','212.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 ('CBRE-YGBB-36-0','00037437','00037437','CINCIN CBRE-06798 ','CINCIN CBRE-06798','','','7814500','7814500',' 0','0','spv','2025-11-26 09:44:56');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06798' ,nama_atribut='' ,kode_intern='CBRE-06798 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDR 48 000 000',total_usd='282.75' WHERE kode_barang='CBRE-YGBB-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XHBH-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 ('CBRE-XHBH-8-0','CBRE-XHBH-8-0','00030922','RD','1','0.065','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBH-8-0','00030922','RD','1','0.065','480','31.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHBH-8-0','CBRE-XHBH-8-0','00030922','RD','45','0.245','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBH-8-0','00030922','RD','45','0.245','450','110.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHBH-8-0','CBRE-XHBH-8-0','00030922','RD','6','0.150','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBH-8-0','00030922','RD','6','0.150','420','63')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XHBH-8-0','00030922','00030922','CINCIN CBRE-05750','CINCIN CBRE-05750','','','9373500','9373500',' 0','0','spv','2025-11-26 09:47:57');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05750' ,nama_atribut='' ,kode_intern='CBRE-05750 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1323 14 5 1125',total_usd_ext='IDB 49 500 000',total_usd='204.45' WHERE kode_barang='CBRE-XHBH-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YEXI-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 ('CBRE-YEXI-19-0','CBRE-YEXI-19-0','00035524','RD','7','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-19-0','00035524','RD','7','0.210','420','88.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YEXI-19-0','CBRE-YEXI-19-0','00035524','RD','14','0.235','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-19-0','00035524','RD','14','0.235','420','98.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YEXI-19-0','CBRE-YEXI-19-0','00035524','RD','52','0.345','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-19-0','00035524','RD','52','0.345','450','155.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 ('CBRE-YEXI-19-0','00035524','00035524','CINCIN CBRE-03738 ','CINCIN CBRE-03738','','','5851500','5851500',' 0','0','spv','2025-11-26 09:54:43');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03738' ,nama_atribut='' ,kode_intern='CBRE-03738 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1105 RS14 1125',total_usd_ext='IDB 45 000 000',total_usd='342.15' WHERE kode_barang='CBRE-YEXI-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-VCAA-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 ('CBRE-VCAA-12-0','CBRE-VCAA-12-0','00013247','RD','96','0.590','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-VCAA-12-0','00013247','RD','96','0.590','420','247.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 ('CBRE-VCAA-12-0','00013247','00013247','CINCIN CBRE-03391','CINCIN CBRE-03391','','','8108000','8108000',' 0','0','spv','2025-11-26 09:56:16');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03391' ,nama_atribut='' ,kode_intern='CBRE-03391 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1149 RS14 1125',total_usd_ext='IDR 47 500 000',total_usd='247.8' WHERE kode_barang='CBRE-VCAA-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDAF-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 ('CBRE-YDAF-19-0','CBRE-YDAF-19-0','00035024','RD','37','0.430','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAF-19-0','00035024','RD','37','0.430','420','180.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 ('CBRE-YDAF-19-0','00035024','00035024','CINCIN CBRE-06745 ','CINCIN CBRE-06745','','','5173000','5173000',' 0','0','spv','2025-11-26 10:02:42');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06745' ,nama_atribut='' ,kode_intern='CBRE-06745 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1271 RS15 1125',total_usd_ext='IDB 33 000 000',total_usd='180.6' WHERE kode_barang='CBRE-YDAF-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WJBF-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WJBF-6-0','CBRE-WJBF-6-0','00024630','RD','36','0.250','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJBF-6-0','00024630','RD','36','0.250','420','105')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WJBF-6-0','CBRE-WJBF-6-0','00024630','RD','12','0.135','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJBF-6-0','00024630','RD','12','0.135','420','56.7')
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 ('CBRE-WJBF-6-0','00024630','00024630','CINCIN CBRE-02396','CINCIN CBRE-02396','','','6053500','6053500',' 0','0','spv','2025-11-26 10:03:46');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02396' ,nama_atribut='' ,kode_intern='CBRE-02396 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1125',total_usd_ext='IDB 36 000 000',total_usd='161.7' WHERE kode_barang='CBRE-WJBF-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDAE-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 ('CBRE-YDAE-31-0','CBRE-YDAE-31-0','00034999','RD','56','0.360','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAE-31-0','00034999','RD','56','0.360','450','162')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAE-31-0','CBRE-YDAE-31-0','00034999','RD','4','0.090','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAE-31-0','00034999','RD','4','0.090','420','37.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 ('CBRE-YDAE-31-0','00034999','00034999','CINCIN CBRE-06739 ','CINCIN CBRE-06739','','','10015500','10015500',' 0','0','spv','2025-11-26 10:04:52');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06739' ,nama_atribut='' ,kode_intern='CBRE-06739 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 5 1125',total_usd_ext='IDB 48 000 000',total_usd='199.8' WHERE kode_barang='CBRE-YDAE-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGBB-38-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-38-0','CBRE-YGBB-38-0','00037439','RD','35','0.230','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-38-0','00037439','RD','35','0.230','400','92')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-38-0','CBRE-YGBB-38-0','00037439','RD','18','0.125','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-38-0','00037439','RD','18','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 ('CBRE-YGBB-38-0','CBRE-YGBB-38-0','00037439','RD','4','0.070','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-38-0','00037439','RD','4','0.070','400','28')
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 ('CBRE-YGBB-38-0','00037439','00037439','CINCIN CBRE-06800 ','CINCIN CBRE-06800','','','6934000','6934000',' 0','0','spv','2025-11-26 10:06:06');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06800' ,nama_atribut='' ,kode_intern='CBRE-06800 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1376 145 1125',total_usd_ext='IDR 38 000 000',total_usd='170' WHERE kode_barang='CBRE-YGBB-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YBAG-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YBAG-22-0','CBRE-YBAG-22-0','00034172','RD','50','0.500','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAG-22-0','00034172','RD','50','0.500','420','210')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YBAG-22-0','CBRE-YBAG-22-0','00034172','RD','4','0.115','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAG-22-0','00034172','RD','4','0.115','420','48.3')
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 ('CBRE-YBAG-22-0','00034172','00034172','CINCIN CBRE-00930','CINCIN CBRE-00930','','','9219500','9219500',' 0','0','spv','2025-11-26 10:07:08');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-00930' ,nama_atribut='' ,kode_intern='CBRE-00930 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1125',total_usd_ext='IDB 50 500 000',total_usd='258.3' WHERE kode_barang='CBRE-YBAG-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHBE-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 ('CBRE-YHBE-36-0','CBRE-YHBE-36-0','00038281','RD','8','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHBE-36-0','00038281','RD','8','0.210','420','88.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHBE-36-0','CBRE-YHBE-36-0','00038281','RD','134','0.780','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHBE-36-0','00038281','RD','134','0.780','420','327.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHBE-36-0','CBRE-YHBE-36-0','00038281','RD','1','0.080','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHBE-36-0','00038281','RD','1','0.080','620','49.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 ('CBRE-YHBE-36-0','00038281','00038281','CINCIN CBRE-03558 ','CINCIN CBRE-03558','','','9227000','9227000',' 0','0','spv','2025-11-26 10:30:09');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03558' ,nama_atribut='' ,kode_intern='CBRE-03558 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1125',total_usd_ext='IDB 59 000 000',total_usd='465.4' WHERE kode_barang='CBRE-YHBE-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XHBX-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 ('CBRE-XHBX-25-0','CBRE-XHBX-25-0','00030682','RD','30','0.080','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBX-25-0','00030682','RD','30','0.080','450','36')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHBX-25-0','CBRE-XHBX-25-0','00030682','RD','1','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBX-25-0','00030682','RD','1','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 ('CBRE-XHBX-25-0','CBRE-XHBX-25-0','00030682','RD','64','0.650','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBX-25-0','00030682','RD','64','0.650','420','273')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHBX-25-0','CBRE-XHBX-25-0','00030682','RD','16','0.370','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBX-25-0','00030682','RD','16','0.370','420','155.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 ('CBRE-XHBX-25-0','00030682','00030682','CINCIN CBRE-00205','CINCIN CBRE-00205','','','8016000','8016000',' 0','0','spv','2025-11-26 10:37:24');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-00205' ,nama_atribut='' ,kode_intern='CBRE-00205 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 1125',total_usd_ext='IDB 59 500 000',total_usd='481.2' WHERE kode_barang='CBRE-XHBX-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHXG-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 ('CBRE-YHXG-13-0','CBRE-YHXG-13-0','00037904','RD','1','0.035','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXG-13-0','00037904','RD','1','0.035','320','11.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXG-13-0','CBRE-YHXG-13-0','00037904','RD','8','0.190','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXG-13-0','00037904','RD','8','0.190','320','60.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXG-13-0','CBRE-YHXG-13-0','00037904','RD','8','0.100','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXG-13-0','00037904','RD','8','0.100','320','32')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXG-13-0','CBRE-YHXG-13-0','00037904','RD','60','0.405','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXG-13-0','00037904','RD','60','0.405','320','129.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 ('CBRE-YHXG-13-0','00037904','00037904','CINCIN CBRE-05166 ','CINCIN CBRE-05166','','','8354000','8354000',' 0','0','spv','2025-11-26 10:42:19');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05166' ,nama_atribut='' ,kode_intern='CBRE-05166 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDB 44 000 000',total_usd='233.6' WHERE kode_barang='CBRE-YHXG-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDAH-32-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAH-32-0','CBRE-YDAH-32-0','00035090','RD','1','0.045','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAH-32-0','00035090','RD','1','0.045','480','21.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAH-32-0','CBRE-YDAH-32-0','00035090','RD','4','0.045','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAH-32-0','00035090','RD','4','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 ('CBRE-YDAH-32-0','CBRE-YDAH-32-0','00035090','RD','4','0.090','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAH-32-0','00035090','RD','4','0.090','420','37.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDAH-32-0','CBRE-YDAH-32-0','00035090','RD','90','0.590','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAH-32-0','00035090','RD','90','0.590','450','265.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 ('CBRE-YDAH-32-0','00035090','00035090','CINCIN CBRE-04536 ','CINCIN CBRE-04536','','','7502500','7502500',' 0','0','spv','2025-11-26 10:43:43');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04536' ,nama_atribut='' ,kode_intern='CBRE-04536 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1186 RS13 1125',total_usd_ext='IDB 47 500 000',total_usd='343.8' WHERE kode_barang='CBRE-YDAH-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WEBI-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 ('CBRE-WEBI-9-0','CBRE-WEBI-9-0','00021902','BD','24','0.200','50');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEBI-9-0','00021902','BD','24','0.200','50','10')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WEBI-9-0','CBRE-WEBI-9-0','00021902','RD','17','0.100','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEBI-9-0','00021902','RD','17','0.100','420','42')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-WEBI-9-0','00021902','00021902','CINCIN CBRE-05465','CINCIN CBRE-05465','','','10309000','10309000',' 0','0','spv','2025-11-26 10:44:43');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05465' ,nama_atribut='' ,kode_intern='CBRE-05465 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDR 48 500 000',total_usd='52' WHERE kode_barang='CBRE-WEBI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGBB-44-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-44-0','CBRE-YGBB-44-0','00037445','RD','40','0.270','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-44-0','00037445','RD','40','0.270','450','121.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-44-0','CBRE-YGBB-44-0','00037445','RD','18','0.465','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-44-0','00037445','RD','18','0.465','400','186')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-44-0','CBRE-YGBB-44-0','00037445','RD','6','0.045','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-44-0','00037445','RD','6','0.045','400','18')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBB-44-0','CBRE-YGBB-44-0','00037445','RD','1','0.070','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-44-0','00037445','RD','1','0.070','400','28')
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 ('CBRE-YGBB-44-0','00037445','00037445','CINCIN CBRE-06806 ','CINCIN CBRE-06806','','','7246000','7246000',' 0','0','spv','2025-11-26 10:46:06');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06806' ,nama_atribut='' ,kode_intern='CBRE-06806 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1125',total_usd_ext='IDR 50 500 000',total_usd='353.5' WHERE kode_barang='CBRE-YGBB-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XFXF-2-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XFXF-2-0','CBRE-XFXF-2-0','00028860','RD','151','1.330','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XFXF-2-0','00028860','RD','151','1.330','420','558.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XFXF-2-0','CBRE-XFXF-2-0','00028860','PD','4','0.100','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XFXF-2-0','00028860','PD','4','0.100','420','42')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XFXF-2-0','00028860','00028860','CINCIN CBRE-06350','CINCIN CBRE-06350','','','12913500','12913500',' 0','0','spv','2025-11-26 10:47:09');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06350' ,nama_atribut='' ,kode_intern='CBRE-06350 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 5 1125',total_usd_ext='IDB 84 500 000',total_usd='600.6' WHERE kode_barang='CBRE-XFXF-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDBE-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 ('CBRE-YDBE-13-0','CBRE-YDBE-13-0','00035273','RD','6','0.090','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBE-13-0','00035273','RD','6','0.090','420','37.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBE-13-0','CBRE-YDBE-13-0','00035273','RD','13','0.430','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBE-13-0','00035273','RD','13','0.430','420','180.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBE-13-0','CBRE-YDBE-13-0','00035273','RD','148','0.600','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBE-13-0','00035273','RD','148','0.600','450','270')
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 ('CBRE-YDBE-13-0','00035273','00035273','CINCIN CBRE-06752 ','CINCIN CBRE-06752','','','10932500','10932500',' 0','0','spv','2025-11-26 10:48:20');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06752' ,nama_atribut='' ,kode_intern='CBRE-06752 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1125',total_usd_ext='IDB 66 000 000',total_usd='488.4' WHERE kode_barang='CBRE-YDBE-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XKAC-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XKAC-22-0','CBRE-XKAC-22-0','00032167','RD','78','0.640','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XKAC-22-0','00032167','RD','78','0.640','450','288')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XKAC-22-0','CBRE-XKAC-22-0','00032167','RD','1','0.050','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XKAC-22-0','00032167','RD','1','0.050','480','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 ('CBRE-XKAC-22-0','00032167','00032167','CINCIN CBRE-02505','CINCIN CBRE-02505','','','8291500','8291500',' 0','0','spv','2025-11-26 10:49:21');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02505' ,nama_atribut='' ,kode_intern='CBRE-02505 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 5 1125',total_usd_ext='IDB 52 500 000',total_usd='312' WHERE kode_barang='CBRE-XKAC-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XBXF-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 ('CBRE-XBXF-4-0','CBRE-XBXF-4-0','00026415','RD','64','0.330','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-4-0','00026415','RD','64','0.330','420','138.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXF-4-0','CBRE-XBXF-4-0','00026415','RD','10','0.150','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-4-0','00026415','RD','10','0.150','420','63')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXF-4-0','CBRE-XBXF-4-0','00026415','RD','8','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-4-0','00026415','RD','8','0.210','420','88.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXF-4-0','CBRE-XBXF-4-0','00026415','RD','1','0.140','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-4-0','00026415','RD','1','0.140','750','105')
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 ('CBRE-XBXF-4-0','00026415','00026415','CINCIN CBRE-06156','CINCIN CBRE-06156','','','6310500','6310500',' 0','0','spv','2025-11-26 10:51:03');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06156' ,nama_atribut='' ,kode_intern='CBRE-06156 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1201 15 1125',total_usd_ext='IDR 50 000 000',total_usd='394.8' WHERE kode_barang='CBRE-XBXF-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGBE-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 ('CBRE-YGBE-19-0','CBRE-YGBE-19-0','00037567','RD','148','0.865','390');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBE-19-0','00037567','RD','148','0.865','390','337.35')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBE-19-0','CBRE-YGBE-19-0','00037567','RD','13','0.370','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBE-19-0','00037567','RD','13','0.370','360','133.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGBE-19-0','CBRE-YGBE-19-0','00037567','RD','6','0.080','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBE-19-0','00037567','RD','6','0.080','360','28.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 ('CBRE-YGBE-19-0','00037567','00037567','CINCIN CBRE-06834 ','CINCIN CBRE-06834','','','11758000','11758000',' 0','0','spv','2025-11-26 10:59:04');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06834' ,nama_atribut='' ,kode_intern='CBRE-06834 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 17 1125',total_usd_ext='IDR 73 000 000',total_usd='499.35' WHERE kode_barang='CBRE-YGBE-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XBXG-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 ('CBRE-XBXG-12-0','CBRE-XBXG-12-0','00026445','RD','1','0.115','650');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXG-12-0','00026445','RD','1','0.115','650','74.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXG-12-0','CBRE-XBXG-12-0','00026445','RD','6','0.245','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXG-12-0','00026445','RD','6','0.245','420','102.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXG-12-0','CBRE-XBXG-12-0','00026445','RD','82','0.500','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXG-12-0','00026445','RD','82','0.500','420','210')
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 ('CBRE-XBXG-12-0','00026445','00026445','CINCIN CBRE-06161','CINCIN CBRE-06161','','','13152000','13152000',' 0','0','spv','2025-11-26 11:00:22');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06161' ,nama_atribut='' ,kode_intern='CBRE-06161 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDR 72 000 000',total_usd='387.65' WHERE kode_barang='CBRE-XBXG-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WEXD-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WEXD-3-0','CBRE-WEXD-3-0','00021447','RD','1','0.105','650');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXD-3-0','00021447','RD','1','0.105','650','68.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WEXD-3-0','CBRE-WEXD-3-0','00021447','RD','8','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXD-3-0','00021447','RD','8','0.210','420','88.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WEXD-3-0','CBRE-WEXD-3-0','00021447','RD','96','0.610','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXD-3-0','00021447','RD','96','0.610','420','256.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WEXD-3-0','CBRE-WEXD-3-0','00021447','RD','8','0.175','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXD-3-0','00021447','RD','8','0.175','420','73.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 ('CBRE-WEXD-3-0','00021447','00021447','CINCIN CBRE-05376','CINCIN CBRE-05376','','','7124000','7124000',' 0','0','spv','2025-11-26 11:01:55');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05376' ,nama_atribut='' ,kode_intern='CBRE-05376 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 5 1125',total_usd_ext='IDR 55 500 000',total_usd='486.15' WHERE kode_barang='CBRE-WEXD-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YBAG-28-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YBAG-28-0','CBRE-YBAG-28-0','00034178','RD','28','0.720','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAG-28-0','00034178','RD','28','0.720','420','302.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YBAG-28-0','CBRE-YBAG-28-0','00034178','RD','6','0.100','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAG-28-0','00034178','RD','6','0.100','420','42')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YBAG-28-0','CBRE-YBAG-28-0','00034178','RD','1','0.090','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAG-28-0','00034178','RD','1','0.090','620','55.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 ('CBRE-YBAG-28-0','00034178','00034178','CINCIN CBRE-01265','CINCIN CBRE-01265','','','10382500','10382500',' 0','0','spv','2025-11-26 11:03:12');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01265' ,nama_atribut='' ,kode_intern='CBRE-01265 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C913 15 5 1125',total_usd_ext='IDB 61 000 000',total_usd='400.2' WHERE kode_barang='CBRE-YBAG-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XHBX-27-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHBX-27-0','CBRE-XHBX-27-0','00030684','RD','23','0.120','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBX-27-0','00030684','RD','23','0.120','450','54')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHBX-27-0','CBRE-XHBX-27-0','00030684','RD','7','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHBX-27-0','00030684','RD','7','0.180','420','75.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 ('CBRE-XHBX-27-0','00030684','00030684','CINCIN CBRE-05458','CINCIN CBRE-05458','','','9356000','9356000',' 0','0','spv','2025-11-26 11:04:22');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05458' ,nama_atribut='' ,kode_intern='CBRE-05458 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDB 43 500 000',total_usd='129.6' WHERE kode_barang='CBRE-XHBX-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-PIXC-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 ('CBRE-PIXC-16-0','CBRE-PIXC-16-0','00017033','RD','36','0.840','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-PIXC-16-0','00017033','RD','36','0.840','420','352.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-PIXC-16-0','CBRE-PIXC-16-0','00017033','RD','78','0.380','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-PIXC-16-0','00017033','RD','78','0.380','420','159.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-PIXC-16-0','CBRE-PIXC-16-0','00017033','RD','1','0.100','650');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-PIXC-16-0','00017033','RD','1','0.100','650','65')
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 ('CBRE-PIXC-16-0','00017033','00017033','CINCIN CBRE04590','CINCIN CBRE-04590','','','11648000','11648000',' 0','0','spv','2025-11-26 11:05:53');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04590' ,nama_atribut='' ,kode_intern='CBRE-04590 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDB 78 000 000',total_usd='577.4' WHERE kode_barang='CBRE-PIXC-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDBA-10-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-10-0','CBRE-YDBA-10-0','00035104','BG','4','0.080','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-10-0','00035104','BG','4','0.080','400','32')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-10-0','CBRE-YDBA-10-0','00035104','BG','8','0.235','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-10-0','00035104','BG','8','0.235','450','105.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-10-0','CBRE-YDBA-10-0','00035104','RD','10','0.630','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-10-0','00035104','RD','10','0.630','480','302.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-10-0','CBRE-YDBA-10-0','00035104','RD','104','0.630','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-10-0','00035104','RD','104','0.630','450','283.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 ('CBRE-YDBA-10-0','00035104','00035104','CINCIN CBRE-05999 ','CINCIN CBRE-05999','','','13647500','13647500',' 0','0','spv','2025-11-26 11:07:28');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05999' ,nama_atribut='' ,kode_intern='CBRE-05999 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1424 RS15 1125',total_usd_ext='IDB 89 000 000',total_usd='723.65' WHERE kode_barang='CBRE-YDBA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YEXI-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 ('CBRE-YEXI-17-0','CBRE-YEXI-17-0','00035522','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-17-0','00035522','RD','1','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YEXI-17-0','CBRE-YEXI-17-0','00035522','RD','126','0.620','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-17-0','00035522','RD','126','0.620','450','279')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YEXI-17-0','CBRE-YEXI-17-0','00035522','RD','12','0.300','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-17-0','00035522','RD','12','0.300','420','126')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YEXI-17-0','CBRE-YEXI-17-0','00035522','RD','6','0.110','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YEXI-17-0','00035522','RD','6','0.110','420','46.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 ('CBRE-YEXI-17-0','00035522','00035522','CINCIN CBRE-05188 ','CINCIN CBRE-05188','','','6273500','6273500',' 0','0','spv','2025-11-26 11:08:51');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05188' ,nama_atribut='' ,kode_intern='CBRE-05188 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1125',total_usd_ext='IDB 53 000 000',total_usd='461.7' WHERE kode_barang='CBRE-YEXI-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XBXF-1-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXF-1-0','CBRE-XBXF-1-0','00026412','RD','137','0.620','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-1-0','00026412','RD','137','0.620','450','279')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXF-1-0','CBRE-XBXF-1-0','00026412','RD','2','0.015','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-1-0','00026412','RD','2','0.015','450','6.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XBXF-1-0','CBRE-XBXF-1-0','00026412','RD','24','0.150','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XBXF-1-0','00026412','RD','24','0.150','450','67.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 ('CBRE-XBXF-1-0','00026412','00026412','CINCIN CBRE-06154','CINCIN CBRE-06154','','','8823500','8823500',' 0','0','spv','2025-11-26 11:10:05');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06154' ,nama_atribut='' ,kode_intern='CBRE-06154 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 1125',total_usd_ext='IDR 56 500 000',total_usd='353.25' WHERE kode_barang='CBRE-XBXF-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YFXC-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 ('CBRE-YFXC-8-0','CBRE-YFXC-8-0','00036076','RD','20','0.480','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YFXC-8-0','00036076','RD','20','0.480','420','201.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YFXC-8-0','CBRE-YFXC-8-0','00036076','RD','16','0.200','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YFXC-8-0','00036076','RD','16','0.200','420','84')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YFXC-8-0','CBRE-YFXC-8-0','00036076','RD','156','0.880','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YFXC-8-0','00036076','RD','156','0.880','450','396')
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 ('CBRE-YFXC-8-0','00036076','00036076','CINCIN CBR1446','CINCIN CBR1446','','','18581500','18581500',' 0','0','spv','2025-11-26 11:11:59');
UPDATE tm_barang SET nama_barang='CINCIN CBR1446' ,nama_atribut='' ,kode_intern='CBR1446', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 17 1125',total_usd_ext='IDB 103 500 000',total_usd='681.6' WHERE kode_barang='CBRE-YFXC-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XGBI-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 ('CBRE-XGBI-8-0','CBRE-XGBI-8-0','00030136','RD','36','0.805','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XGBI-8-0','00030136','RD','36','0.805','420','338.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XGBI-8-0','00030136','00030136','CINCIN CBRE-06438','CINCIN CBRE-06438','','','8988500','8988500',' 0','0','spv','2025-11-26 11:15:50');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06438' ,nama_atribut='' ,kode_intern='CBRE-06438 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1432 13 1125',total_usd_ext='IDR 54 000 000',total_usd='338.1' WHERE kode_barang='CBRE-XGBI-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XLAX-44-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XLAX-44-0','CBRE-XLAX-44-0','00032592','RD','44','0.340','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XLAX-44-0','00032592','RD','44','0.340','450','153')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XLAX-44-0','CBRE-XLAX-44-0','00032592','RD','7','0.640','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XLAX-44-0','00032592','RD','7','0.640','620','396.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 ('CBRE-XLAX-44-0','00032592','00032592','CINCIN CBRE-06495','CINCIN CBRE-06495','','','7576000','7576000',' 0','0','spv','2025-11-26 11:17:05');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06495' ,nama_atribut='' ,kode_intern='CBRE-06495 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 10 1125',total_usd_ext='IDB 61 000 000',total_usd='549.8' WHERE kode_barang='CBRE-XLAX-44-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','11:17:52');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YIXA-86-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YIXA-86-0','CBRE-YIXA-86-0','00038456','RD','7','0.220','350');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YIXA-86-0','00038456','RD','7','0.220','350','77')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YIXA-86-0','CBRE-YIXA-86-0','00038456','RD','64','0.390','350');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YIXA-86-0','00038456','RD','64','0.390','350','136.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 ('CBRE-YIXA-86-0','00038456','00038456','CINCIN CBR0672 ','CINCIN CBR0672','','','5586000','5586000',' 0','0','spv','2025-11-26 11:18:11');
UPDATE tm_barang SET nama_barang='CINCIN CBR0672' ,nama_atribut='' ,kode_intern='CBR0672 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1125',total_usd_ext='IDB 34 000 000',total_usd='213.5' WHERE kode_barang='CBRE-YIXA-86-0' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008897','X-00008897','KALUNG KLBE-00363','GR','---','KLBE','BELI','BELI001','9599000','2025-11-26','5.160','1','kasir','2025-11-26 11:19:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-KLBE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-KLBE','X-00008897','X-00008897');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0001','FE-240806-0006','NANA','1','BELI','BELI001','KLBE', 'X-00008897', 'KALUNG KLBE-00363','5.160','5.160','75.00','11999000','9599000','1860271','1','9599000','9599000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.160',berat_beli_asli=berat_beli_asli+'5.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.160',berat_akhir_asli=berat_akhir_asli+'5.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='KLBE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0001','2025-11-26','2025-11-26','11:19:23','NANA','---','5.160','9599000','9599000','9599000','9599000','9599000','kasir','2025-11-26 11:19:23','BE-251126-0001','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0001','YUNITA','-','','','-','kasir','2025-11-26 11:19:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-251126-0002','K','2025-11-26','11:19:23','kasir','PEMBELIAN UMUM','BE-251126-0001','53185690','9599000','43586690','OPEN');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDBC-47-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBC-47-0','CBRE-YDBC-47-0','00035219','RD','1','0.070','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBC-47-0','00035219','RD','1','0.070','480','33.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBC-47-0','CBRE-YDBC-47-0','00035219','RD','6','0.190','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBC-47-0','00035219','RD','6','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 ('CBRE-YDBC-47-0','CBRE-YDBC-47-0','00035219','RD','75','0.480','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBC-47-0','00035219','RD','75','0.480','450','216')
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 ('CBRE-YDBC-47-0','00035219','00035219','CINCIN CBRE-01108 ','CINCIN CBRE-01108','','','8034500','8034500',' 0','0','spv','2025-11-26 11:19:33');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01108' ,nama_atribut='' ,kode_intern='CBRE-01108 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1125',total_usd_ext='IDB 52 000 000',total_usd='329.4' WHERE kode_barang='CBRE-YDBC-47-0' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008898','X-00008898','CINCIN CBRE-03965','GR','---','CBRE','BELI','BELI001','5599000','2025-11-26','2.280','1','kasir','2025-11-26 11:20:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00008898','X-00008898');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0002','FE-240728-0003','Nagatech','1','BELI','BELI001','CBRE', 'X-00008898', 'CINCIN CBRE-03965','2.300','2.280','75.00','6999000','5599000','2455702','1','5599000','5599000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.280',berat_beli_asli=berat_beli_asli+'2.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.280',berat_akhir_asli=berat_akhir_asli+'2.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0002','2025-11-26','2025-11-26','11:20:10','Nagatech','---','2.280','5599000','5599000','5599000','5599000','5599000','kasir','2025-11-26 11:20:10','BE-251126-0002','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0002','YUNITA AMALIA','-','','','-','kasir','2025-11-26 11:20:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-251126-0003','K','2025-11-26','11:20:10','kasir','PEMBELIAN UMUM','BE-251126-0002','43586690','5599000','37987690','OPEN');
DELETE FROM tm_berlian WHERE kode_barang='SYC-XEAF-21-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('SYC-XEAF-21-0','SYC-XEAF-21-0','00028441','RD','69','0.405','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('SYC-XEAF-21-0','00028441','RD','69','0.405','420','170.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('SYC-XEAF-21-0','SYC-XEAF-21-0','00028441','RD','14','0.170','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('SYC-XEAF-21-0','00028441','RD','14','0.170','420','71.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('SYC-XEAF-21-0','SYC-XEAF-21-0','00028441','RD','2','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('SYC-XEAF-21-0','00028441','RD','2','0.065','420','27.3')
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 ('SYC-XEAF-21-0','00028441','00028441','CINCIN SYC-00044','CINCIN SYC-00044','','','6879000','6879000',' 0','0','spv','2025-11-26 11:20:51');
UPDATE tm_barang SET nama_barang='CINCIN SYC-00044' ,nama_atribut='' ,kode_intern='SYC-00044 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1125',total_usd_ext='IDR 44 500 000',total_usd='268.8' WHERE kode_barang='SYC-XEAF-21-0' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008899','X-00008899','ABRE00620','GR','---','ABR','BELI','BELI001','5016000','2025-11-26','3.100','1','kasir','2025-11-26 11:20:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-ABR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-ABR','X-00008899','X-00008899');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0003','00009486','NANA','1','BELI','BELI001','ABR', 'X-00008899', 'ABRE00620','3.100','3.100','75.00','6270000','5016000','1618065','1','5016000','5016000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.100',berat_beli_asli=berat_beli_asli+'3.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.100',berat_akhir_asli=berat_akhir_asli+'3.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='ABR' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0003','2025-11-26','2025-11-26','11:20:56','NANA','---','3.100','5016000','5016000','5016000','5016000','5016000','kasir','2025-11-26 11:20:57','BE-251126-0003','OPEN','CASH');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0003','-','-','','','','kasir','2025-11-26 11:20:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-26' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-251126-0004','K','2025-11-26','11:20:56','kasir','PEMBELIAN UMUM','BE-251126-0003','37987690','5016000','32971690','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0003';
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDBA-28-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-28-0','CBRE-YDBA-28-0','00035122','RD','2','0.100','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-28-0','00035122','RD','2','0.100','480','48')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-28-0','CBRE-YDBA-28-0','00035122','RD','6','0.060','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-28-0','00035122','RD','6','0.060','420','25.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-28-0','CBRE-YDBA-28-0','00035122','RD','14','0.090','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-28-0','00035122','RD','14','0.090','450','40.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YDBA-28-0','CBRE-YDBA-28-0','00035122','RD','17','0.420','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDBA-28-0','00035122','RD','17','0.420','420','176.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 ('CBRE-YDBA-28-0','00035122','00035122','CINCIN CBRE-02282 ','CINCIN CBRE-02282','','','9227000','9227000',' 0','0','spv','2025-11-26 11:22:13');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02282' ,nama_atribut='' ,kode_intern='CBRE-02282 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C913 RS11 1125',total_usd_ext='IDB 50 500 000',total_usd='290.1' WHERE kode_barang='CBRE-YDBA-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGXA-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 ('CBRE-YGXA-30-0','CBRE-YGXA-30-0','00036862','RD','44','0.610','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGXA-30-0','00036862','RD','44','0.610','420','256.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 ('CBRE-YGXA-30-0','00036862','00036862','CINCIN CBRE-04386 ','CINCIN CBRE-04386','','','13134000','13134000',' 0','0','spv','2025-11-26 11:23:09');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04386' ,nama_atribut='' ,kode_intern='CBRE-04386 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1125',total_usd_ext='IDB 60 000 000',total_usd='256.2' WHERE kode_barang='CBRE-YGXA-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YBXG-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 ('CBRE-YBXG-9-0','CBRE-YBXG-9-0','00034016','BD','78','0.590','150');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBXG-9-0','00034016','BD','78','0.590','150','88.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 ('CBRE-YBXG-9-0','00034016','00034016','CINCIN CBRE-05468','CINCIN CBRE-05468','','','11373000','11373000',' 0','0','spv','2025-11-26 11:24:05');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05468' ,nama_atribut='' ,kode_intern='CBRE-05468 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1151 16 5 1125',total_usd_ext='IDB 51 500 000',total_usd='88.5' WHERE kode_barang='CBRE-YBXG-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XHXH-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHXH-22-0','CBRE-XHXH-22-0','00030456','RD','1','0.105','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXH-22-0','00030456','RD','1','0.105','620','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 ('CBRE-XHXH-22-0','CBRE-XHXH-22-0','00030456','RD','2','0.105','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXH-22-0','00030456','RD','2','0.105','480','50.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHXH-22-0','CBRE-XHXH-22-0','00030456','RD','6','0.225','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXH-22-0','00030456','RD','6','0.225','420','94.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XHXH-22-0','CBRE-XHXH-22-0','00030456','RD','64','0.360','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXH-22-0','00030456','RD','64','0.360','450','162')
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 ('CBRE-XHXH-22-0','00030456','00030456','CINCIN CBRE-05000','CINCIN CBRE-05000','','','6970500','6970500',' 0','0','spv','2025-11-26 11:25:50');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05000' ,nama_atribut='' ,kode_intern='CBRE-05000 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1255 16 1125',total_usd_ext='IDB 50 500 000',total_usd='372' WHERE kode_barang='CBRE-XHXH-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHXG-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 ('CBRE-YHXG-8-0','CBRE-YHXG-8-0','00037899','RD','11','0.220','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXG-8-0','00037899','RD','11','0.220','420','92.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHXG-8-0','CBRE-YHXG-8-0','00037899','RD','22','0.535','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHXG-8-0','00037899','RD','22','0.535','420','224.7')
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 ('CBRE-YHXG-8-0','00037899','00037899','CINCIN CBRE-06374 ','CINCIN CBRE-06374','','','9612000','9612000',' 0','0','spv','2025-11-26 11:26:56');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06374' ,nama_atribut='' ,kode_intern='CBRE-06374 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1101 14 1125',total_usd_ext='IDB 55 000 000',total_usd='317.1' WHERE kode_barang='CBRE-YHXG-8-0' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07868','FAISAL','1','CBR','CROM PUTIH','2.040','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-07868','2025-11-26','2025-11-26','11:34:03','PLG0027384','kasir','2025-11-28','kasir','2025-11-26 11:34:03','2.040','0','0','0','0','0','0','0','0');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008900','X-00008900','CINCIN MAS PUTIH','GR','---','CMP','BELI','BELI001','2506000','2025-11-26','1.790','1','kasir','2025-11-26 12:09:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-CMP';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMP','X-00008900','X-00008900');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0004','-','NANA','1','BELI','BELI001','CMP', 'X-00008900', 'CINCIN MAS PUTIH','1.790','1.790','75.00','0','2506000','1400000','1','2506000','2506000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.790',berat_beli_asli=berat_beli_asli+'1.790',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.790',berat_akhir_asli=berat_akhir_asli+'1.790',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMP' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0004','2025-11-26','2025-11-26','12:09:07','NANA','---','1.790','2506000','2506000','2506000','2506000','2506000','kasir','2025-11-26 12:09:07','BE-251126-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0004','REGULER','JKT','','JKT','0','kasir','2025-11-26 12:09:07');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251126-0001','2025-11-26','2025-11-26 12:09:07','PEMBELIAN UMUM : BE-251126-0004','.','TBC','2506000','2506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251126-0002','K','2025-11-26','12:09:07','TBC','PEMBELIAN UMUM','BE-251126-0004','93215562085','2506000','93213056085','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008901','X-00008901','CINCIN MAS PUTIH','GR','---','CMP','BELI','BELI001','2450000','2025-11-26','1.750','1','kasir','2025-11-26 12:09:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-CMP';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMP','X-00008901','X-00008901');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0005','-','NANA','2','BELI','BELI001','CMP', 'X-00008901', 'CINCIN MAS PUTIH','1.750','1.750','75.00','0','2450000','1400000','1','2450000','2450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMP' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0005','2025-11-26','2025-11-26','12:09:07','NANA','---','1.750','2450000','2450000','2450000','2450000','2450000','kasir','2025-11-26 12:09:07','BE-251126-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0005','REGULER','JKT','','JKT','0','kasir','2025-11-26 12:09:07');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251126-0002','2025-11-26','2025-11-26 12:09:07','PEMBELIAN UMUM : BE-251126-0005','.','TBC','2450000','2450000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251126-0003','K','2025-11-26','12:09:07','TBC','PEMBELIAN UMUM','BE-251126-0005','93213056085','2450000','93210606085','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008902','X-00008902','CINCIN MAS KUNING','GR','---','CMK','BELI','BELI001','1989000','2025-11-26','1.530','1','kasir','2025-11-26 12:09:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-CMK';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMK','X-00008902','X-00008902');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0006','-','NANA','3','BELI','BELI001','CMK', 'X-00008902', 'CINCIN MAS KUNING','1.530','1.530','70.00','0','1989000','1300000','1','1989000','1989000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMK' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0006','2025-11-26','2025-11-26','12:09:07','NANA','---','1.530','1989000','1989000','1989000','1989000','1989000','kasir','2025-11-26 12:09:07','BE-251126-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0006','REGULER','JKT','','JKT','0','kasir','2025-11-26 12:09:07');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251126-0003','2025-11-26','2025-11-26 12:09:07','PEMBELIAN UMUM : BE-251126-0006','.','TBC','1989000','1989000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251126-0004','K','2025-11-26','12:09:07','TBC','PEMBELIAN UMUM','BE-251126-0006','93210606085','1989000','93208617085','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008903','X-00008903','CINCIN MAS KUNING','GR','---','CMK','BELI','BELI001','2327000','2025-11-26','1.790','1','kasir','2025-11-26 12:09:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-CMK';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMK','X-00008903','X-00008903');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251126-0007','-','NANA','4','BELI','BELI001','CMK', 'X-00008903', 'CINCIN MAS KUNING','1.790','1.790','70.00','0','2327000','1300000','1','2327000','2327000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.790',berat_beli_asli=berat_beli_asli+'1.790',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.790',berat_akhir_asli=berat_akhir_asli+'1.790',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMK' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-251126-0007','2025-11-26','2025-11-26','12:09:07','NANA','---','1.790','2327000','2327000','2327000','2327000','2327000','kasir','2025-11-26 12:09:07','BE-251126-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251126-0007','REGULER','JKT','','JKT','0','kasir','2025-11-26 12:09:07');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251126-0004','2025-11-26','2025-11-26 12:09:07','PEMBELIAN UMUM : BE-251126-0007','.','TBC','2327000','2327000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251126-0005','K','2025-11-26','12:09:07','TBC','PEMBELIAN UMUM','BE-251126-0007','93208617085','2327000','93206290085','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
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-251126-0001','kasir','1',' LBRE-00816','TOKO','LBR','LBRE-YJXG-29-0','LIONTIN LBRE-00816 ','','0.620','1','103.00','2752000','1089500','65','16750','3000000','0','0','0','3000000','BARY','00039079','LBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LBRE-YJXG-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='LBRE-YJXG-29-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-251126-0001','2025-11-26','0.620','2025-11-26','15:17:42','PLG0027385','3000000','3000000','0','3000000','0','kasir','2025-11-26 15:17:41','FE-251126-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-11-26','FE-251126-0001','2025-11-26','15:17:42','BARY','3000000','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-251126-0005','2025-11-26','2025-11-26 15:17:41','PENJUALAN : FE-251126-0001','.','TBC','3000000','3000000','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-251126-0006','D','2025-11-26','15:17:42','TBC','PENJUALAN BERLIAN','FE-251126-0001','93206290085','3000000','93209290085','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='3000000' WHERE no_faktur_jual='FE-251126-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-251126-0002','kasir',' 1',' ABRE-01229','TOKO','ABR','ABRE-YFBG-24-0','ANTING ABRE-01229 ','','2.720','1','83.00','9082000','2907500','174','16750','10000000','0','0','0','10000000','BARY','00036799','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-YFBG-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='ABRE-YFBG-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='ABR' 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-251126-0002','2025-11-26','2.720','2025-11-26','15:17:42','PLG0027386','10000000','10000000','0','10000000','0','kasir','2025-11-26 15:17:41','FE-251126-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-11-26','FE-251126-0002','2025-11-26','15:17:42','BARY','10000000','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-251126-0006','2025-11-26','2025-11-26 15:17:41','PENJUALAN : FE-251126-0002','.','TBC','10000000','10000000','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-251126-0007','D','2025-11-26','15:17:42','TBC','PENJUALAN BERLIAN','FE-251126-0002','93209290085','10000000','93219290085','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='13000000' WHERE no_faktur_jual='FE-251126-0002' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251126-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251126-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251126-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251126-0002';
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-251126-0003','kasir','1',' CBRE-06577','TOKO','CBR','CBRE-YKBD-32-0','CINCIN CBRE-06577 ','','1.280','1','83.00','4991000','2188500','131','16750','6300000','0','0','0','6300000','ONLNANA','00039804','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YKBD-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='CBRE-YKBD-32-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-251126-0003','2025-11-26','1.280','2025-11-26','15:26:19','PLG0027387','6300000','6300000','0','6300000','0','kasir','2025-11-26 15:26:19','FE-251126-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-11-26','FE-251126-0003','2025-11-26','15:26:19','ONLNANA','6300000','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-251126-0007','2025-11-26','2025-11-26 15:26:19','PENJUALAN : FE-251126-0003','.','DPE','6300000','6300000','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-251126-0002','D','2025-11-26','15:26:19','DPE','PENJUALAN BERLIAN','FE-251126-0003','230572800','6300000','236872800','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='6300000' WHERE no_faktur_jual='FE-251126-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251126-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','15:51:08');
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-20251126-0002','1','LBRE-YKBF-33-0','1','1.100','1.100','TOKO','LBRE','TOKO','LBR');
DELETE FROM tm_barang WHERE kode_barang='LBRE-YKBF-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LBRE-YKBF-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LBRE-YKBF-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LBRE-YKBF-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='LBR',tgl_last_beli='2025-11-26 15:51:18' WHERE kode_barang='LBRE-YKBF-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LBRE-YKBF-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 15:51:18','TOKO','LBR','LBRE','LBRE-YKBF-33-0','1','1.100','1.100','1','1.100','1.100','83.00');
DELETE FROM tm_dept WHERE kode_dept='LBRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LBRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LBRE-YKBF-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='LBRE-YKBF-33-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251126-0002','2025-11-26','15:51','1.100','kasir','2025-11-26 15:51:17');
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-251126-0004','kasir','1',' CBRE-02942','TOKO','CBR','CBRE-YKXC-6-0','CINCIN CBRE-02942 ','','2.140','1','75.00','5123000','1109000','66','16750','6000000','0','0','0','6000000','ONLILUNG','00039393','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YKXC-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='CBRE-YKXC-6-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-251126-0004','2025-11-26','2.140','2025-11-26','17:21:28','PLG0027388','6000000','6000000','0','6000000','0','kasir','2025-11-26 17:21:27','FE-251126-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FE-251126-0004','2025-11-26','17:21:28','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-251126-0008','2025-11-26','2025-11-26 17:21:27','PENJUALAN : FE-251126-0004','','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-251126-0008','D','2025-11-26','17:21:28','TBC','PENJUALAN BERLIAN','FE-251126-0004','93219290085','6000000','93225290085','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-251126-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251126-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-251126-0005','kasir','1',' CBRE-04375','TOKO','CBR','CBRE-YKXC-23-0','CINCIN CBRE-04375 ','','1.720','1','97.00','6238000','1983000','118','16750','7400000','0','0','0','7400000','ONLNANA','00039410','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YKXC-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='CBRE-YKXC-23-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-251126-0005','2025-11-26','1.720','2025-11-26','17:32:17','PLG0027389','7400000','7400000','0','7400000','0','kasir','2025-11-26 17:32:17','FE-251126-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-11-26','FE-251126-0005','2025-11-26','17:32:17','ONLNANA','7400000','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-251126-0009','2025-11-26','2025-11-26 17:32:17','PENJUALAN : FE-251126-0005','.','TBC','7400000','7400000','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-251126-0009','D','2025-11-26','17:32:17','TBC','PENJUALAN BERLIAN','FE-251126-0005','93225290085','7400000','93232690085','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='7400000' WHERE no_faktur_jual='FE-251126-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251126-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251126-0005';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07869','NANAONL','1','CBR04375','RESIZE KE 17 5 HARGA KONFIRMASI CRUM PUTIH','1.720','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-07869','2025-11-26','2025-11-26','17:35:09','PLG0027390','kasir','2025-11-28','kasir','2025-11-26 17:35:09','1.720','0','0','0','0','0','0','0','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251126-0005','K','2025-11-26','19:02:37','kasir','KIRIM PAKET','JNE BEKASI','32971690','18000','32953690');
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-251126-0006','K','2025-11-26','19:03:03','kasir','KIRIM PAKET','JNE TULUNG SELAPAN','32953690','35000','32918690');
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-251126-0007','K','2025-11-26','19:03:24','kasir','KIRIM PAKET','JNE GUNUNG PUTRI','32918690','18000','32900690');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-26';
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-11-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-26' 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-251127-0001','D','2025-11-27','20:05:18','TBC','SALDO AWAL','SALDO AWAL','0','93232690085','93232690085');
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-251127-0001','D','2025-11-27','20:05:18','DPE','SALDO AWAL','SALDO AWAL','0','236872800','236872800');
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-251127-0001','D','2025-11-27','20:05:18','BCD','SALDO AWAL','SALDO AWAL','0','14912731700','14912731700');
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-251127-0001','D','2025-11-27','20:05:18','BCK','SALDO AWAL','SALDO AWAL','0','16133482978.088','16133482978.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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','','SALDO AWAL','SALDO AWAL','0','13818500','13818500');
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-251127-0001','D','2025-11-27','20:05:18','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-251127-0001','D','2025-11-27','20:05:18','TMR','SALDO AWAL','SALDO AWAL','0','8256583779','8256583779');
UPDATE tp_system SET tgl_system='2025-11-27';