INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-12-02 ','09:51:07');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XCBB-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XCBB-14-0','CBRE-XCBB-14-0','00027708','SP','21','1.690','20');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XCBB-14-0','00027708','SP','21','1.690','20','33.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-XCBB-14-0','00027708','00027708','CINCIN CBRE-04867','CINCIN CBRE-04867','','','8684500','8684500',' 0','0','spv','2025-12-02 09:52:14');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04867' ,nama_atribut='' ,kode_intern='CBRE-04867 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1261 16 1225',total_usd_ext='IDB 39 500 000',total_usd='33.8' WHERE kode_barang='CBRE-XCBB-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WKXC-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-WKXC-4-0','CBRE-WKXC-4-0','00024714','RD','1','0.345','1050');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WKXC-4-0','00024714','RD','1','0.345','1050','362.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-WKXC-4-0','CBRE-WKXC-4-0','00024714','RD','36','0.235','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WKXC-4-0','00024714','RD','36','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-WKXC-4-0','CBRE-WKXC-4-0','00024714','RD','8','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WKXC-4-0','00024714','RD','8','0.030','420','12.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-WKXC-4-0','00024714','00024714','CINCIN CBRE-05038','CINCIN CBRE-05038','','','5091000','5091000',' 0','0','spv','2025-12-02 10:04:17');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05038' ,nama_atribut='' ,kode_intern='CBRE-05038 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1038 11 5 1225',total_usd_ext='IDB 50 000 000',total_usd='473.55' WHERE kode_barang='CBRE-WKXC-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XIBF-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-XIBF-16-0','CBRE-XIBF-16-0','00031478','RD','1','0.145','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBF-16-0','00031478','RD','1','0.145','750','108.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-XIBF-16-0','CBRE-XIBF-16-0','00031478','RD','14','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBF-16-0','00031478','RD','14','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-XIBF-16-0','CBRE-XIBF-16-0','00031478','RD','16','0.050','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBF-16-0','00031478','RD','16','0.050','420','21')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XIBF-16-0','CBRE-XIBF-16-0','00031478','RD','2','0.100','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBF-16-0','00031478','RD','2','0.100','450','45')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XIBF-16-0','00031478','00031478','CINCIN CBRE-06517','CINCIN CBRE-06517','','','7318500','7318500',' 0','0','spv','2025-12-02 10:05:46');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06517' ,nama_atribut='' ,kode_intern='CBRE-06517 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C926 13 1225',total_usd_ext='IDB 45 000 000',total_usd='262.95' WHERE kode_barang='CBRE-XIBF-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XDBI-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XDBI-20-0','CBRE-XDBI-20-0','00028067','RD','47','0.490','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XDBI-20-0','00028067','RD','47','0.490','420','205.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-XDBI-20-0','00028067','00028067','CINCIN CBRE-04684','CINCIN CBRE-04684','','','6008500','6008500',' 0','0','spv','2025-12-02 10:06:37');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04684' ,nama_atribut='' ,kode_intern='CBRE-04684 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 1225',total_usd_ext='IDB 37 000 000',total_usd='205.8' WHERE kode_barang='CBRE-XDBI-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YKXC-33-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YKXC-33-0','CBRE-YKXC-33-0','00039420','BD','21','0.810','20');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-33-0','00039420','BD','21','0.810','20','16.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-YKXC-33-0','00039420','00039420','CINCIN CBRE-06925 ','CINCIN CBRE-06925','','','6478000','6478000',' 0','0','spv','2025-12-02 10:07:39');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06925' ,nama_atribut='' ,kode_intern='CBRE-06925 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS14 1225 4B9',total_usd_ext='IDB 27 000 000',total_usd='16.2' WHERE kode_barang='CBRE-YKXC-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WLBA-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-WLBA-4-0','CBRE-WLBA-4-0','00025416','RD','114','1.805','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WLBA-4-0','00025416','RD','114','1.805','420','758.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-WLBA-4-0','00025416','00025416','CINCIN CBRE-06061','CINCIN CBRE-06061','','','10294500','10294500',' 0','0','spv','2025-12-02 10:08:34');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06061' ,nama_atribut='' ,kode_intern='CBRE-06061 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1274 14 1225',total_usd_ext='IDB 84 000 000',total_usd='758.1' WHERE kode_barang='CBRE-WLBA-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YJXG-24-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YJXG-24-0','CBRE-YJXG-24-0','00039074','RD','5','0.440','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJXG-24-0','00039074','RD','5','0.440','420','184.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-YJXG-24-0','CBRE-YJXG-24-0','00039074','RD','52','0.340','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJXG-24-0','00039074','RD','52','0.340','420','142.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-YJXG-24-0','00039074','00039074','CINCIN CBRE-04776 ','CINCIN CBRE-04776','','','5683000','5683000',' 0','0','spv','2025-12-02 10:09:39');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04776' ,nama_atribut='' ,kode_intern='CBRE-04776 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='15 1225 10B6',total_usd_ext='IDB 40 000 000',total_usd='327.6' WHERE kode_barang='CBRE-YJXG-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YJCA-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-YJCA-10-0','CBRE-YJCA-10-0','00039372','RD','7','0.410','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJCA-10-0','00039372','RD','7','0.410','320','131.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-YJCA-10-0','CBRE-YJCA-10-0','00039372','RD','42','0.250','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJCA-10-0','00039372','RD','42','0.250','320','80')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YJCA-10-0','CBRE-YJCA-10-0','00039372','RD','1','0.150','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJCA-10-0','00039372','RD','1','0.150','320','48')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YJCA-10-0','00039372','00039372','CINCIN CBRE-02082','CINCIN CBRE-02082','','','7594000','7594000',' 0','0','spv','2025-12-02 10:10:46');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02082' ,nama_atribut='' ,kode_intern='CBRE-02082 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 155 1225 9B7',total_usd_ext='IDB 43 000 000',total_usd='259.2' WHERE kode_barang='CBRE-YJCA-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YCBX-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 ('CBRE-YCBX-21-0','CBRE-YCBX-21-0','00034919','RD','44','0.195','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YCBX-21-0','00034919','RD','44','0.195','420','81.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-YCBX-21-0','CBRE-YCBX-21-0','00034919','RD','6','0.240','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YCBX-21-0','00034919','RD','6','0.240','450','108')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YCBX-21-0','CBRE-YCBX-21-0','00034919','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YCBX-21-0','00034919','RD','1','0.050','450','22.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-YCBX-21-0','00034919','00034919','CINCIN CBRE-02467','CINCIN CBRE-02467','','','6682000','6682000',' 0','0','spv','2025-12-02 10:11:58');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02467' ,nama_atribut='' ,kode_intern='CBRE-02467 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C907 15 1225',total_usd_ext='IDB 39 500 000',total_usd='212.4' WHERE kode_barang='CBRE-YCBX-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WCXD-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-WCXD-13-0','CBRE-WCXD-13-0','00020763','RD','104','0.960','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WCXD-13-0','00020763','RD','104','0.960','420','403.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-WCXD-13-0','CBRE-WCXD-13-0','00020763','RD','4','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WCXD-13-0','00020763','RD','4','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 ('CBRE-WCXD-13-0','00020763','00020763','CINCIN BERLIAN','CINCIN BERLIAN','','','9620500','9620500',' 0','0','spv','2025-12-02 10:13:01');
UPDATE tm_barang SET nama_barang='CINCIN BERLIAN' ,nama_atribut='' ,kode_intern='CBRE-02737 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1065 14 1225',total_usd_ext='IDB 62 500 000',total_usd='430.5' WHERE kode_barang='CBRE-WCXD-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHAC-35-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-YHAC-35-0','CBRE-YHAC-35-0','00037984','RD','6','0.280','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-35-0','00037984','RD','6','0.280','370','103.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-YHAC-35-0','CBRE-YHAC-35-0','00037984','RD','2','0.140','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-35-0','00037984','RD','2','0.140','370','51.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-YHAC-35-0','CBRE-YHAC-35-0','00037984','RD','2','0.060','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-35-0','00037984','RD','2','0.060','370','22.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-YHAC-35-0','CBRE-YHAC-35-0','00037984','RD','1','0.290','950');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-35-0','00037984','RD','1','0.290','950','275.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-YHAC-35-0','00037984','00037984','CINCIN CBRE-06881 ','CINCIN CBRE-06881','','','6719500','6719500',' 0','0','spv','2025-12-02 10:30:17');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06881' ,nama_atribut='' ,kode_intern='CBRE-06881 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1225',total_usd_ext='IDR 53 500 000',total_usd='453.1' WHERE kode_barang='CBRE-YHAC-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YBAA-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-YBAA-30-0','CBRE-YBAA-30-0','00034096','RD','44','0.245','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAA-30-0','00034096','RD','44','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-YBAA-30-0','CBRE-YBAA-30-0','00034096','RD','6','0.130','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAA-30-0','00034096','RD','6','0.130','420','54.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-YBAA-30-0','CBRE-YBAA-30-0','00034096','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBAA-30-0','00034096','RD','1','0.050','450','22.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-YBAA-30-0','00034096','00034096','CINCIN CBRE-06705','CINCIN CBRE-06705','','','5989500','5989500',' 0','0','spv','2025-12-02 10:31:24');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06705' ,nama_atribut='' ,kode_intern='CBRE-06705 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C907 14 1225',total_usd_ext='IDB 36 500 000',total_usd='180' WHERE kode_barang='CBRE-YBAA-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XAAE-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-XAAE-22-0','CBRE-XAAE-22-0','00025841','RD','30','0.150','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XAAE-22-0','00025841','RD','30','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-XAAE-22-0','CBRE-XAAE-22-0','00025841','RD','1','0.150','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XAAE-22-0','00025841','RD','1','0.150','750','112.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-XAAE-22-0','CBRE-XAAE-22-0','00025841','RD','6','0.390','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XAAE-22-0','00025841','RD','6','0.390','450','175.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-XAAE-22-0','00025841','00025841','CINCIN CBRE-06112','CINCIN CBRE-06112','','','6476000','6476000',' 0','0','spv','2025-12-02 10:33:37');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06112' ,nama_atribut='' ,kode_intern='CBRE-06112 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1225',total_usd_ext='IDB 47 000 000',total_usd='351' WHERE kode_barang='CBRE-XAAE-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YDAG-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-YDAG-10-0','CBRE-YDAG-10-0','00035048','RD','19','0.150','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAG-10-0','00035048','RD','19','0.150','450','67.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-YDAG-10-0','CBRE-YDAG-10-0','00035048','RD','20','0.095','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YDAG-10-0','00035048','RD','20','0.095','450','42.75')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YDAG-10-0','00035048','00035048','CINCIN CBRE-06746 ','CINCIN CBRE-06746','','','7456000','7456000',' 0','0','spv','2025-12-02 10:34:37');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06746' ,nama_atribut='' ,kode_intern='CBRE-06746 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1225',total_usd_ext='IDB 36 000 000',total_usd='110.25' WHERE kode_barang='CBRE-YDAG-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WLXF-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WLXF-20-0','CBRE-WLXF-20-0','00025260','RD','1','0.200','900');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WLXF-20-0','00025260','RD','1','0.200','900','180')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WLXF-20-0','CBRE-WLXF-20-0','00025260','RD','16','0.340','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WLXF-20-0','00025260','RD','16','0.340','420','142.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-WLXF-20-0','CBRE-WLXF-20-0','00025260','RD','12','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WLXF-20-0','00025260','RD','12','0.025','420','10.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-WLXF-20-0','00025260','00025260','CINCIN CBRE-03489','CINCIN CBRE-03489','','','6782500','6782500',' 0','0','spv','2025-12-02 10:35:48');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03489' ,nama_atribut='' ,kode_intern='CBRE-03489 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1225',total_usd_ext='IDB 45 500 000',total_usd='333.3' WHERE kode_barang='CBRE-WLXF-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WKBB-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-WKBB-22-0','CBRE-WKBB-22-0','00025036','RD','42','0.215','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WKBB-22-0','00025036','RD','42','0.215','420','90.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WKBB-22-0','CBRE-WKBB-22-0','00025036','RD','8','0.100','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WKBB-22-0','00025036','RD','8','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-WKBB-22-0','CBRE-WKBB-22-0','00025036','RD','1','0.085','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WKBB-22-0','00025036','RD','1','0.085','600','51')
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-WKBB-22-0','00025036','00025036','CINCIN CBRE-06018','CINCIN CBRE-06018','','','5465500','5465500',' 0','0','spv','2025-12-02 10:36:51');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06018' ,nama_atribut='' ,kode_intern='CBRE-06018 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1295 15 1225',total_usd_ext='IDB 35 000 000',total_usd='183.3' WHERE kode_barang='CBRE-WKBB-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YKXC-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-YKXC-30-0','CBRE-YKXC-30-0','00039417','RD','34','0.230','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-30-0','00039417','RD','34','0.230','320','73.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-YKXC-30-0','CBRE-YKXC-30-0','00039417','RD','28','0.100','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-30-0','00039417','RD','28','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-YKXC-30-0','CBRE-YKXC-30-0','00039417','BD','1','1.655','70');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-30-0','00039417','BD','1','1.655','70','115.85')
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-YKXC-30-0','00039417','00039417','CINCIN CBRE-06924 ','CINCIN CBRE-06924','','','6714500','6714500',' 0','0','spv','2025-12-02 10:38:01');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06924' ,nama_atribut='' ,kode_intern='CBRE-06924 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1225 10B5',total_usd_ext='IDB 43 500 000',total_usd='221.45' WHERE kode_barang='CBRE-YKXC-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YKXC-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-YKXC-30-0','CBRE-YKXC-30-0','00039417','RD','34','0.230','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-30-0','00039417','RD','34','0.230','320','73.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-YKXC-30-0','CBRE-YKXC-30-0','00039417','RD','28','0.100','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-30-0','00039417','RD','28','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-YKXC-30-0','CBRE-YKXC-30-0','00039417','BD','1','1.655','70');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-30-0','00039417','BD','1','1.655','70','115.85')
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-YKXC-30-0','00039417','00039417','CINCIN CBRE-06924 ','CINCIN CBRE-06924','','','6714500','6714500',' 0','0','spv','2025-12-02 10:38:03');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06924' ,nama_atribut='' ,kode_intern='CBRE-06924 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1225 10B5',total_usd_ext='IDB 43 500 000',total_usd='221.45' WHERE kode_barang='CBRE-YKXC-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WJAA-37-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-WJAA-37-0','CBRE-WJAA-37-0','00024431','RD','7','0.140','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJAA-37-0','00024431','RD','7','0.140','420','58.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-WJAA-37-0','CBRE-WJAA-37-0','00024431','RD','114','0.650','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJAA-37-0','00024431','RD','114','0.650','420','273')
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-WJAA-37-0','00024431','00024431','CINCIN CBRE-05906','CINCIN CBRE-05906','','','7955000','7955000',' 0','0','spv','2025-12-02 10:39:03');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05906' ,nama_atribut='' ,kode_intern='CBRE-05906 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 1225',total_usd_ext='IDR 53 000 000',total_usd='331.8' WHERE kode_barang='CBRE-WJAA-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XIBD-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-XIBD-6-0','CBRE-XIBD-6-0','00031424','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBD-6-0','00031424','RD','1','0.050','450','22.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-XIBD-6-0','CBRE-XIBD-6-0','00031424','RD','14','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBD-6-0','00031424','RD','14','0.180','420','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-XIBD-6-0','CBRE-XIBD-6-0','00031424','RD','5','0.020','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBD-6-0','00031424','RD','5','0.020','420','8.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-XIBD-6-0','CBRE-XIBD-6-0','00031424','RD','16','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XIBD-6-0','00031424','RD','16','0.040','420','16.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-XIBD-6-0','00031424','00031424','CINCIN CBRE-03301','CINCIN CBRE-03301','','','6008500','6008500',' 0','0','spv','2025-12-02 10:40:19');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-03301' ,nama_atribut='' ,kode_intern='CBRE-03301 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 11 1225',total_usd_ext='IDB 33 000 000',total_usd='123.3' WHERE kode_barang='CBRE-XIBD-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XGCA-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-XGCA-6-0','CBRE-XGCA-6-0','00030223','RD','19','0.130','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XGCA-6-0','00030223','RD','19','0.130','420','54.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-XGCA-6-0','CBRE-XGCA-6-0','00030223','RD','1','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XGCA-6-0','00030223','RD','1','0.030','420','12.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-XGCA-6-0','CBRE-XGCA-6-0','00030223','RD','4','0.015','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XGCA-6-0','00030223','RD','4','0.015','420','6.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-XGCA-6-0','00030223','00030223','CINCIN CBRE-06449','CINCIN CBRE-06449','','','6736000','6736000',' 0','0','spv','2025-12-02 10:41:27');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06449' ,nama_atribut='' ,kode_intern='CBRE-06449 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12 1225',total_usd_ext='IDB 31 000 000',total_usd='73.5' WHERE kode_barang='CBRE-XGCA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHBE-34-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHBE-34-0','CBRE-YHBE-34-0','00038279','RD','5','0.780','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHBE-34-0','00038279','RD','5','0.780','750','585')
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-34-0','00038279','00038279','CINCIN CBRE-06005 ','CINCIN CBRE-06005','','','5372000','5372000',' 0','0','spv','2025-12-02 10:42:33');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06005' ,nama_atribut='' ,kode_intern='CBRE-06005 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 16 1225',total_usd_ext='IDB 54 000 000',total_usd='585' WHERE kode_barang='CBRE-YHBE-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YAXB-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-YAXB-30-0','CBRE-YAXB-30-0','00033180','RD','65','0.400','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YAXB-30-0','00033180','RD','65','0.400','450','180')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YAXB-30-0','CBRE-YAXB-30-0','00033180','RD','8','0.090','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YAXB-30-0','00033180','RD','8','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-YAXB-30-0','00033180','00033180','CINCIN CBRE-01838','CINCIN CBRE-01838','','','10537500','10537500',' 0','0','spv','2025-12-02 10:43:38');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01838' ,nama_atribut='' ,kode_intern='CBRE-01838 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1225',total_usd_ext='IDB 52 500 000',total_usd='217.8' WHERE kode_barang='CBRE-YAXB-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YIBC-24-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YIBC-24-0','CBRE-YIBC-24-0','00038856','RD','6','0.230','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YIBC-24-0','00038856','RD','6','0.230','475','109.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-YIBC-24-0','CBRE-YIBC-24-0','00038856','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-YIBC-24-0','00038856','RD','1','0.050','480','24')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YIBC-24-0','CBRE-YIBC-24-0','00038856','RD','26','0.210','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YIBC-24-0','00038856','RD','26','0.210','450','94.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-YIBC-24-0','00038856','00038856','CINCIN CBRE-01496 ','CINCIN CBRE-01496','','','5514000','5514000',' 0','0','spv','2025-12-02 10:44:46');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01496' ,nama_atribut='' ,kode_intern='CBRE-01496 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C823 13 1225',total_usd_ext='IDB 35 000 000',total_usd='227.75' WHERE kode_barang='CBRE-YIBC-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WIAA-23-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-WIAA-23-0','CBRE-WIAA-23-0','00023930','RD','12','0.185','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WIAA-23-0','00023930','RD','12','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-WIAA-23-0','CBRE-WIAA-23-0','00023930','EMR','1','0.315','1050');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WIAA-23-0','00023930','EMR','1','0.315','1050','330.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-WIAA-23-0','CBRE-WIAA-23-0','00023930','RD','40','0.175','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WIAA-23-0','00023930','RD','40','0.175','450','78.75')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-WIAA-23-0','00023930','00023930','CINCIN CBRE-02718','CINCIN CBRE-02718','','','6626000','6626000',' 0','0','spv','2025-12-02 10:46:11');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02718' ,nama_atribut='' ,kode_intern='CBRE-02718 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C107068 13 1225',total_usd_ext='IDB 54 000 000',total_usd='487.2' WHERE kode_barang='CBRE-WIAA-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WCCX-18-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-WCCX-18-0','CBRE-WCCX-18-0','00021117','RD','48','0.293','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WCCX-18-0','00021117','RD','48','0.293','420','123.06')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WCCX-18-0','CBRE-WCCX-18-0','00021117','RD','1','0.084','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WCCX-18-0','00021117','RD','1','0.084','600','50.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-WCCX-18-0','00021117','00021117','CINCIN BERLIAN','CINCIN CBRE-05306','','','10726000','10726000',' 0','0','spv','2025-12-02 10:47:27');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05306' ,nama_atribut='' ,kode_intern='CBRE-05306 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='HK RS 13 1225',total_usd_ext='IDR 52 500 000',total_usd='173.46' WHERE kode_barang='CBRE-WCCX-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHAC-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-YHAC-38-0','CBRE-YHAC-38-0','00037987','RD','24','0.135','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-38-0','00037987','RD','24','0.135','400','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-YHAC-38-0','CBRE-YHAC-38-0','00037987','RD','6','0.130','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-38-0','00037987','RD','6','0.130','400','52')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YHAC-38-0','CBRE-YHAC-38-0','00037987','RD','1','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-38-0','00037987','RD','1','0.060','450','27')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YHAC-38-0','00037987','00037987','CINCIN CBRE-06884 ','CINCIN CBRE-06884','','','5690000','5690000',' 0','0','spv','2025-12-02 10:48:32');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06884' ,nama_atribut='' ,kode_intern='CBRE-06884 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12 1225',total_usd_ext='IDR 32 000 000',total_usd='133' WHERE kode_barang='CBRE-YHAC-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XHXF-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-XHXF-47-0','CBRE-XHXF-47-0','00030420','RD','8','0.020','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXF-47-0','00030420','RD','8','0.020','450','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-XHXF-47-0','CBRE-XHXF-47-0','00030420','RD','12','0.635','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXF-47-0','00030420','RD','12','0.635','480','304.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-XHXF-47-0','CBRE-XHXF-47-0','00030420','RD','16','0.070','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XHXF-47-0','00030420','RD','16','0.070','450','31.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-XHXF-47-0','CBRE-XHXF-47-0','00030420','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-XHXF-47-0','00030420','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-XHXF-47-0','00030420','00030420','CINCIN CBRE-06074','CINCIN CBRE-06074','','','9302500','9302500',' 0','0','spv','2025-12-02 10:49:50');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06074' ,nama_atribut='' ,kode_intern='CBRE-06074 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1184 11 1225',total_usd_ext='IDB 61 500 000',total_usd='450.3' WHERE kode_barang='CBRE-XHXF-47-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YBXG-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YBXG-20-0','CBRE-YBXG-20-0','00034027','RD','1','0.150','650');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBXG-20-0','00034027','RD','1','0.150','650','97.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-YBXG-20-0','CBRE-YBXG-20-0','00034027','RD','58','0.265','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBXG-20-0','00034027','RD','58','0.265','420','111.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-YBXG-20-0','CBRE-YBXG-20-0','00034027','RD','8','0.015','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YBXG-20-0','00034027','RD','8','0.015','420','6.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-YBXG-20-0','00034027','00034027','CINCIN CBRE-04852','CINCIN CBRE-04852','','','7468000','7468000',' 0','0','spv','2025-12-02 10:51:00');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04852' ,nama_atribut='' ,kode_intern='CBRE-04852 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1225',total_usd_ext='IDB 43 000 000',total_usd='215.1' WHERE kode_barang='CBRE-YBXG-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGBB-42-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-42-0','CBRE-YGBB-42-0','00037443','RD','56','0.310','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-42-0','00037443','RD','56','0.310','400','124')
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-42-0','CBRE-YGBB-42-0','00037443','RD','1','0.250','900');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGBB-42-0','00037443','RD','1','0.250','900','225')
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-42-0','00037443','00037443','CINCIN CBRE-06804 ','CINCIN CBRE-06804','','','8142000','8142000',' 0','0','spv','2025-12-02 10:52:45');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06804' ,nama_atribut='' ,kode_intern='CBRE-06804 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1517 145 1225',total_usd_ext='IDR 53 000 000',total_usd='349' WHERE kode_barang='CBRE-YGBB-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YGAA-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 ('CBRE-YGAA-21-0','CBRE-YGAA-21-0','00037152','RD','8','0.100','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGAA-21-0','00037152','RD','8','0.100','370','37')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YGAA-21-0','CBRE-YGAA-21-0','00037152','RD','13','0.370','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGAA-21-0','00037152','RD','13','0.370','370','136.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-YGAA-21-0','CBRE-YGAA-21-0','00037152','RD','26','0.275','370');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGAA-21-0','00037152','RD','26','0.275','370','101.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-YGAA-21-0','CBRE-YGAA-21-0','00037152','RD','55','0.395','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YGAA-21-0','00037152','RD','55','0.395','400','158')
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-YGAA-21-0','00037152','00037152','CINCIN CBRE-04683 ','CINCIN CBRE-04683','','','8666000','8666000',' 0','0','spv','2025-12-02 10:54:07');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04683' ,nama_atribut='' ,kode_intern='CBRE-04683 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1225',total_usd_ext='IDB 55 000 000',total_usd='433.65' WHERE kode_barang='CBRE-YGAA-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YAXF-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YAXF-5-0','CBRE-YAXF-5-0','00033204','RD','12','0.175','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YAXF-5-0','00033204','RD','12','0.175','420','73.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-YAXF-5-0','CBRE-YAXF-5-0','00033204','RD','1','0.240','1050');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YAXF-5-0','00033204','RD','1','0.240','1050','252')
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-YAXF-5-0','00033204','00033204','CINCIN CBRE-06625','CINCIN CBRE-06625','','','8454500','8454500',' 0','0','spv','2025-12-02 10:55:24');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06625' ,nama_atribut='' ,kode_intern='CBRE-06625 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 1225',total_usd_ext='IDR 51 000 000',total_usd='325.5' WHERE kode_barang='CBRE-YAXF-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WFBH-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-WFBH-19-0','CBRE-WFBH-19-0','00022696','RD','22','0.440','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WFBH-19-0','00022696','RD','22','0.440','420','184.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-WFBH-19-0','CBRE-WFBH-19-0','00022696','RD','20','0.060','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WFBH-19-0','00022696','RD','20','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-WFBH-19-0','CBRE-WFBH-19-0','00022696','RD','26','0.130','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WFBH-19-0','00022696','RD','26','0.130','420','54.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-WFBH-19-0','CBRE-WFBH-19-0','00022696','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WFBH-19-0','00022696','RD','1','0.050','450','22.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-WFBH-19-0','00022696','00022696','CINCIN CBRE-04369','CINCIN CBRE-04369','','','6307500','6307500',' 0','0','spv','2025-12-02 10:56:46');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-04369' ,nama_atribut='' ,kode_intern='CBRE-04369 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1225',total_usd_ext='IDB 43 500 000',total_usd='287.1' WHERE kode_barang='CBRE-WFBH-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YJXG-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-YJXG-32-0','CBRE-YJXG-32-0','00039082','RD','7','0.080','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJXG-32-0','00039082','RD','7','0.080','420','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-YJXG-32-0','CBRE-YJXG-32-0','00039082','RD','48','0.580','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YJXG-32-0','00039082','RD','48','0.580','420','243.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-YJXG-32-0','00039082','00039082','CINCIN CBRE-06038 ','CINCIN CBRE-06038','','','4679000','4679000',' 0','0','spv','2025-12-02 10:57:57');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06038' ,nama_atribut='' ,kode_intern='CBRE-06038 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='15 1225 8B8',total_usd_ext='IDB 35 000 000',total_usd='277.2' WHERE kode_barang='CBRE-YJXG-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YKXC-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-YKXC-13-0','CBRE-YKXC-13-0','00039400','RD','1','0.120','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-13-0','00039400','RD','1','0.120','620','74.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-YKXC-13-0','CBRE-YKXC-13-0','00039400','RD','60','0.390','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-13-0','00039400','RD','60','0.390','400','156')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-YKXC-13-0','CBRE-YKXC-13-0','00039400','RD','12','0.040','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YKXC-13-0','00039400','RD','12','0.040','400','16')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-YKXC-13-0','00039400','00039400','CINCIN CBRE-05381 ','CINCIN CBRE-05381','','','6401500','6401500',' 0','0','spv','2025-12-02 10:59:10');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05381' ,nama_atribut='' ,kode_intern='CBRE-05381 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS15 1225 10B4',total_usd_ext='IDB 39 000 000',total_usd='246.4' WHERE kode_barang='CBRE-YKXC-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WCBH-26-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WCBH-26-0','CBRE-WCBH-26-0','00021078','RD','42','0.350','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WCBH-26-0','00021078','RD','42','0.350','420','147')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-WCBH-26-0','CBRE-WCBH-26-0','00021078','RD','1','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WCBH-26-0','00021078','RD','1','0.060','450','27')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-WCBH-26-0','00021078','00021078','CINCIN BERLIAN','CINCIN CBRE-05304','','','6925500','6925500',' 0','0','spv','2025-12-02 11:00:19');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05304' ,nama_atribut='' ,kode_intern='CBRE-05304 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1225',total_usd_ext='IDB 38 000 000',total_usd='174' WHERE kode_barang='CBRE-WCBH-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WEXC-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-WEXC-2-0','CBRE-WEXC-2-0','00021417','RD','24','0.075','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXC-2-0','00021417','RD','24','0.075','420','31.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-WEXC-2-0','CBRE-WEXC-2-0','00021417','RD','1','0.070','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXC-2-0','00021417','RD','1','0.070','450','31.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-WEXC-2-0','CBRE-WEXC-2-0','00021417','RD','22','0.350','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WEXC-2-0','00021417','RD','22','0.350','420','147')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-WEXC-2-0','00021417','00021417','CINCIN CBRE05362','CINCIN CBRE-05362','','','7655500','7655500',' 0','0','spv','2025-12-02 11:01:36');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05362' ,nama_atribut='' ,kode_intern='CBRE-05362 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C511 RS 11 1225',total_usd_ext='IDB 43 000 000',total_usd='210' WHERE kode_barang='CBRE-WEXC-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XLAB-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-XLAB-9-0','CBRE-XLAB-9-0','00032658','RD','16','0.075','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XLAB-9-0','00032658','RD','16','0.075','420','31.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-XLAB-9-0','CBRE-XLAB-9-0','00032658','RD','4','0.015','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XLAB-9-0','00032658','RD','4','0.015','420','6.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-XLAB-9-0','CBRE-XLAB-9-0','00032658','RD','27','0.170','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XLAB-9-0','00032658','RD','27','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 ('CBRE-XLAB-9-0','CBRE-XLAB-9-0','00032658','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XLAB-9-0','00032658','RD','1','0.050','450','22.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-XLAB-9-0','00032658','00032658','CINCIN CBRE-02935','CINCIN CBRE-02935','','','7711500','7711500',' 0','0','spv','2025-12-02 11:03:00');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-02935' ,nama_atribut='' ,kode_intern='CBRE-02935 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1225',total_usd_ext='IDB 37 000 000',total_usd='131.7' WHERE kode_barang='CBRE-XLAB-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YHAC-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-YHAC-32-0','CBRE-YHAC-32-0','00037981','RD','37','0.250','390');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-32-0','00037981','RD','37','0.250','390','97.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-YHAC-32-0','CBRE-YHAC-32-0','00037981','RD','2','0.035','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-32-0','00037981','RD','2','0.035','360','12.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-YHAC-32-0','CBRE-YHAC-32-0','00037981','RD','22','0.240','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YHAC-32-0','00037981','RD','22','0.240','360','86.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-YHAC-32-0','00037981','00037981','CINCIN CBRE-06878 ','CINCIN CBRE-06878','','','6644500','6644500',' 0','0','spv','2025-12-02 11:04:09');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06878' ,nama_atribut='' ,kode_intern='CBRE-06878 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1375 14 1225',total_usd_ext='IDR 39 000 000',total_usd='196.5' WHERE kode_barang='CBRE-YHAC-32-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-12-02 ','15:21:31');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-YAXB-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-YAXB-30-0','CBRE-YAXB-30-0','00033180','RD','8','0.090','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YAXB-30-0','00033180','RD','8','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-YAXB-30-0','CBRE-YAXB-30-0','00033180','RD','65','0.400','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-YAXB-30-0','00033180','RD','65','0.400','450','180')
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-YAXB-30-0','00033180','00033180','CINCIN CBRE-01838','CINCIN CBRE-01838','','','10537500','10537500',' 0','0','spv','2025-12-02 15:23:16');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-01838' ,nama_atribut='' ,kode_intern='CBRE-01838 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 15 1225',total_usd_ext='IDB 53 000 000',total_usd='217.8' WHERE kode_barang='CBRE-YAXB-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-WJXB-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-WJXB-2-0','CBRE-WJXB-2-0','00024289','RD','1','0.020','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJXB-2-0','00024289','RD','1','0.020','420','8.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-WJXB-2-0','CBRE-WJXB-2-0','00024289','RD','29','0.465','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJXB-2-0','00024289','RD','29','0.465','420','195.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-WJXB-2-0','CBRE-WJXB-2-0','00024289','RD','62','0.470','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJXB-2-0','00024289','RD','62','0.470','450','211.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-WJXB-2-0','CBRE-WJXB-2-0','00024289','RD','2','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-WJXB-2-0','00024289','RD','2','0.030','420','12.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-WJXB-2-0','00024289','00024289','CINCIN CBRE-05855','CINCIN CBRE-05855','','','5578000','5578000',' 0','0','spv','2025-12-02 15:25:46');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05855' ,nama_atribut='' ,kode_intern='CBRE-05855 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12 5 1225',total_usd_ext='IDB 49 500 000',total_usd='427.8' WHERE kode_barang='CBRE-WJXB-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRE-XGXA-80-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-XGXA-80-0','CBRE-XGXA-80-0','00029483','RD','5','0.795','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-XGXA-80-0','00029483','RD','5','0.795','750','596.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-XGXA-80-0','00029483','00029483','CINCIN CBRE-06375','CINCIN CBRE-06375','','','6476000','6476000',' 0','0','spv','2025-12-02 15:27:30');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-06375' ,nama_atribut='' ,kode_intern='CBRE-06375 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 14 1225',total_usd_ext='IDB 59 000 000',total_usd='596.25' WHERE kode_barang='CBRE-XGXA-80-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-02 ','16:51:14');
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-251202-0001','kasir','1',' ABRE-00001','TOKO','ABR','ABRE-YIAE-17-0','ANTING ABRE-00001 ','','2.510','1','75.00','7670000','2727000','163','16750','9400000','0','0','0','9400000','ONLILUNG','00038726','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-12-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-YIAE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2025-12-02' AND kode_barang='ABRE-YIAE-17-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-251202-0001','2025-12-02','2.510','2025-12-02','16:53:04','PLG0027428','9400000','9400000','0','9400000','0','kasir','2025-12-02 16:53:04','FE-251202-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-02','FE-251202-0001','2025-12-02','16:53:04','ONLILUNG','9400000','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-251202-0001','2025-12-02','2025-12-02 16:53:04','PENJUALAN : FE-251202-0001','','TBC','9400000','9400000','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-251202-0002','D','2025-12-02','16:53:04','TBC','PENJUALAN BERLIAN','FE-251202-0001','93364321385','9400000','93373721385','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='9400000' WHERE no_faktur_jual='FE-251202-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251202-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251202-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251202-0001';
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-00008917','X-00008917','CINCIN BERLIAN ELCO','GR','---','CBRE','BELI','BELI001','5792000','2025-12-02','1.740','1','kasir','2025-12-02 18:01:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00008917','X-00008917');
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-251202-0001','-','NANA','1','BELI','BELI001','CBRE', 'X-00008917', 'CINCIN BERLIAN ELCO','1.840','1.740','75.00','7240000','5792000','3328736','1','5792000','5792000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.740',berat_beli_asli=berat_beli_asli+'1.740',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.740',berat_akhir_asli=berat_akhir_asli+'1.740',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-02' 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-251202-0001','2025-12-02','2025-12-02','18:01:42','NANA','---','1.740','5792000','5792000','5792000','5792000','5792000','kasir','2025-12-02 18:01:43','BE-251202-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251202-0001','DIANA','JKT','','JKT','0','kasir','2025-12-02 18:01:43');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251202-0002','2025-12-02','2025-12-02 18:01:43','PEMBELIAN UMUM : BE-251202-0001','.','TBC','5792000','5792000');
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-251202-0003','K','2025-12-02','18:01:42','TBC','PEMBELIAN UMUM','BE-251202-0001','93373721385','5792000','93367929385','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251202-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251202-0001';
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-251202-0002','K','2025-12-02','18:04:39','kasir','KIRIM PAKET','JNE BIAU ','484690','137000','347690');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02914','FAISAL','1','PER','WEDDING RING','','','1.000','','92.50','1','60000','0','0','800000','800000','size 13 grf Endro ?? Yanti','pakai 1 mata zirkon crum full glosy putih','contoh wre001','0','0','');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02914','2025-12-02','2025-12-02','18:51:59','PLG0027429','FAISAL','2025-12-23','kasir','2025-12-02 18:51:59','1.000','800000','0','0','0','0','800000','800000','800000','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 ('KM-251202-0003','D','2025-12-02','18:51:59','kasir','PESANAN','DP-02914','347690','800000','1147690');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02915','FAISAL','1','PER','WEDDING RING','','','1.000','','92.50','1','60000','0','0','750000','750000','size 16 grf Yanti ?? Endro','sesuai contoh pakai 1 mata zirkon','putih ada doff semprot setengah','0','','');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02915','2025-12-02','2025-12-02','18:54:45','PLG0027430','FAISAL','2025-12-23','kasir','2025-12-02 18:54:45','1.000','750000','0','0','0','0','750000','750000','750000','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 ('KM-251202-0004','D','2025-12-02','18:54:45','kasir','PESANAN','DP-02915','1147690','750000','1897690');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-02 ','19:09:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-12-02 ','19:32:31');
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-00008918','X-00008918','CINCIN CBRE-05966','GR','---','CBRE','BELI','BELI001','2775000','2025-12-02','1.560','1','kasir','2025-12-02 19:33:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00008918','X-00008918');
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-251202-0002','FE-241228-0003','BARY','1','BELI','BELI001','CBRE', 'X-00008918', 'CINCIN CBRE-05966','1.560','1.560','83.00','4500000','2775000','1778846','1','2775000','2775000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.560',berat_beli_asli=berat_beli_asli+'1.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.560',berat_akhir_asli=berat_akhir_asli+'1.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-02' 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-251202-0002','2025-12-02','2025-12-02','19:33:21','BARY','---','1.560','2775000','2775000','2775000','2775000','2775000','kasir','2025-12-02 19:33:21','BE-251202-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251202-0002','SAMUEL','-','','','-','kasir','2025-12-02 19:33:21');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251202-0003','2025-12-02','2025-12-02 19:33:21','PEMBELIAN UMUM : BE-251202-0002','.','TBC','2775000','2775000');
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-251202-0004','K','2025-12-02','19:33:21','TBC','PEMBELIAN UMUM','BE-251202-0002','93367929385','2775000','93365154385','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251202-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251202-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-02';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-02' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251203-0001','D','2025-12-03','20:08:37','TBC','SALDO AWAL','SALDO AWAL','0','93365154385','93365154385');
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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','','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-251203-0001','D','2025-12-03','20:08:37','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-251203-0001','D','2025-12-03','20:08:37','TMR','SALDO AWAL','SALDO AWAL','0','8256583779','8256583779');
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-251203-0001','D','2025-12-03','20:08:37','BCD','SALDO AWAL','SALDO AWAL','0','14916371700','14916371700');
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-251203-0001','D','2025-12-03','20:08:37','BCK','SALDO AWAL','SALDO AWAL','0','16145282978.088','16145282978.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-251203-0001','D','2025-12-03','20:08:37','DPE','SALDO AWAL','SALDO AWAL','0','250372800','250372800');
UPDATE tp_system SET tgl_system='2025-12-03';