INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','09:48:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-10 ','09:51:50');
DELETE FROM tm_berlian WHERE kode_barang='LBRT-WEBD-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBD-7-0','LBRT-WEBD-7-0','00021876','RD','9','0.305','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBD-7-0','00021876','RD','9','0.305','450','137.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBD-7-0','LBRT-WEBD-7-0','00021876','RD','19','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBD-7-0','00021876','RD','19','0.075','450','33.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBD-7-0','LBRT-WEBD-7-0','00021876','RD','44','0.110','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBD-7-0','00021876','RD','44','0.110','450','49.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBD-7-0','LBRT-WEBD-7-0','00021876','RD','1','0.070','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBD-7-0','00021876','RD','1','0.070','600','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 ('LBRT-WEBD-7-0','00021876','00021876','LIONTIN LBRT-00074','LIONTIN LBRT-00074','','','3601000','3601000',' 0','0','spv','2025-11-10 09:54:19');
UPDATE tm_barang SET nama_barang='LIONTIN LBRT-00074' ,nama_atribut='' ,kode_intern='LBRT-00074 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 32 000 000',total_usd='262.5' WHERE kode_barang='LBRT-WEBD-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDL-XJXB-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XJXB-7-0','BDL-XJXB-7-0','00031563','RD','6','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XJXB-7-0','00031563','RD','6','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 ('BDL-XJXB-7-0','BDL-XJXB-7-0','00031563','RD','6','0.080','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XJXB-7-0','00031563','RD','6','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 ('BDL-XJXB-7-0','BDL-XJXB-7-0','00031563','RD','1','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XJXB-7-0','00031563','RD','1','0.060','450','27')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XJXB-7-0','BDL-XJXB-7-0','00031563','RD','1','0.025','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XJXB-7-0','00031563','RD','1','0.025','400','10')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDL-XJXB-7-0','00031563','00031563','LIONTIN BDL-00008','LIONTIN BDL-00008','','','4322500','4322500',' 0','0','spv','2025-11-10 09:56:56');
UPDATE tm_barang SET nama_barang='LIONTIN BDL-00008' ,nama_atribut='' ,kode_intern='BDL-00008 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 27 000 000',total_usd='157.2' WHERE kode_barang='BDL-XJXB-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFL-XBBH-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 ('TFL-XBBH-6-0','TFL-XBBH-6-0','00026927','RD','76','0.480','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFL-XBBH-6-0','00026927','RD','76','0.480','450','216')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFL-XBBH-6-0','TFL-XBBH-6-0','00026927','RD','13','0.195','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFL-XBBH-6-0','00026927','RD','13','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 ('TFL-XBBH-6-0','TFL-XBBH-6-0','00026927','RD','4','0.050','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFL-XBBH-6-0','00026927','RD','4','0.050','420','21')
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 ('TFL-XBBH-6-0','00026927','00026927','LIONTIN TFL-21028','LIONTIN TFL-21028','','','5021000','5021000',' 0','0','spv','2025-11-10 09:58:50');
UPDATE tm_barang SET nama_barang='LIONTIN TFL-21028' ,nama_atribut='' ,kode_intern='TFL-21028 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L213 1125',total_usd_ext='IDR 40 000 000',total_usd='318.9' WHERE kode_barang='TFL-XBBH-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDL-XKXG-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 ('BDL-XKXG-26-0','BDL-XKXG-26-0','00032093','RD','19','0.345','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKXG-26-0','00032093','RD','19','0.345','420','144.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XKXG-26-0','BDL-XKXG-26-0','00032093','RD','3','0.190','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKXG-26-0','00032093','RD','3','0.190','450','85.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XKXG-26-0','BDL-XKXG-26-0','00032093','RD','1','0.180','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKXG-26-0','00032093','RD','1','0.180','620','111.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XKXG-26-0','BDL-XKXG-26-0','00032093','RD','38','0.200','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKXG-26-0','00032093','RD','38','0.200','400','80')
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 ('BDL-XKXG-26-0','00032093','00032093','LIONTIN BDL-00019','LIONTIN BDL-00019','','','4066500','4066500',' 0','0','spv','2025-11-10 10:01:09');
UPDATE tm_barang SET nama_barang='LIONTIN BDL-00019' ,nama_atribut='' ,kode_intern='BDL-00019 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 42 500 000',total_usd='422' WHERE kode_barang='BDL-XKXG-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LBRT-WEBC-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 ('LBRT-WEBC-27-0','LBRT-WEBC-27-0','00021867','RD','9','0.300','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBC-27-0','00021867','RD','9','0.300','450','135')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBC-27-0','LBRT-WEBC-27-0','00021867','RD','19','0.060','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBC-27-0','00021867','RD','19','0.060','450','27')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBC-27-0','LBRT-WEBC-27-0','00021867','RD','44','0.110','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBC-27-0','00021867','RD','44','0.110','450','49.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-WEBC-27-0','LBRT-WEBC-27-0','00021867','RD','1','0.090','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-WEBC-27-0','00021867','RD','1','0.090','600','54')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('LBRT-WEBC-27-0','00021867','00021867','LIONTIN LBRT-00071','LIONTIN LBRT-00071','','','3601000','3601000',' 0','0','spv','2025-11-10 10:03:09');
UPDATE tm_barang SET nama_barang='LIONTIN LBRT-00071' ,nama_atribut='' ,kode_intern='LBRT-00071 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 32 000 000',total_usd='265.5' WHERE kode_barang='LBRT-WEBC-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDL-XKBH-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 ('BDL-XKBH-17-0','BDL-XKBH-17-0','00032358','RD','84','0.330','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKBH-17-0','00032358','RD','84','0.330','400','132')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XKBH-17-0','BDL-XKBH-17-0','00032358','RD','1','0.065','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKBH-17-0','00032358','RD','1','0.065','450','29.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDL-XKBH-17-0','BDL-XKBH-17-0','00032358','RD','1','0.105','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XKBH-17-0','00032358','RD','1','0.105','600','63')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDL-XKBH-17-0','00032358','00032358','LIONTIN BDL-00020','LIONTIN BDL-00020','','','2351500','2351500',' 0','0','spv','2025-11-10 10:04:55');
UPDATE tm_barang SET nama_barang='LIONTIN BDL-00020' ,nama_atribut='' ,kode_intern='BDL-00020 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 26 000 000',total_usd='224.25' WHERE kode_barang='BDL-XKBH-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDL-XJXB-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 ('BDL-XJXB-8-0','BDL-XJXB-8-0','00031564','RD','5','0.040','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDL-XJXB-8-0','00031564','RD','5','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 ('BDL-XJXB-8-0','00031564','00031564','LIONTIN BDL-00009','LIONTIN BDL-00009','','','1536000','1536000',' 0','0','spv','2025-11-10 10:06:24');
UPDATE tm_barang SET nama_barang='LIONTIN BDL-00009' ,nama_atribut='' ,kode_intern='BDL-00009 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 8 000 000',total_usd='16' WHERE kode_barang='BDL-XJXB-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LBRT-PKXG-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 ('LBRT-PKXG-16-0','LBRT-PKXG-16-0','00018337','RD','1','0.325','1150');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-PKXG-16-0','00018337','RD','1','0.325','1150','373.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-PKXG-16-0','LBRT-PKXG-16-0','00018337','RD','16','0.090','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-PKXG-16-0','00018337','RD','16','0.090','450','40.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 ('LBRT-PKXG-16-0','00018337','00018337','LIONTIN LBRT-00032','LIONTIN LBRT-00032','','','2369500','2369500',' 0','0','spv','2025-11-10 10:08:04');
UPDATE tm_barang SET nama_barang='LIONTIN LBRT-00032' ,nama_atribut='' ,kode_intern='LBRT-00032 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L105 1125',total_usd_ext='IDR 36 000 000',total_usd='414.25' WHERE kode_barang='LBRT-PKXG-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFL-WHBB-49-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFL-WHBB-49-0','TFL-WHBB-49-0','00023590','RD','23','0.170','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFL-WHBB-49-0','00023590','RD','23','0.170','450','76.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFL-WHBB-49-0','TFL-WHBB-49-0','00023590','RD','5','0.200','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFL-WHBB-49-0','00023590','RD','5','0.200','480','96')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFL-WHBB-49-0','TFL-WHBB-49-0','00023590','RD','3','0.200','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFL-WHBB-49-0','00023590','RD','3','0.200','480','96')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFL-WHBB-49-0','00023590','00023590','LIONTIN TFL-21008','LIONTIN TFL-21008','','','3447500','3447500',' 0','0','spv','2025-11-10 10:09:53');
UPDATE tm_barang SET nama_barang='LIONTIN TFL-21008' ,nama_atribut='' ,kode_intern='TFL-21008 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L62 1125',total_usd_ext='IDR 31 500 000',total_usd='268.5' WHERE kode_barang='TFL-WHBB-49-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LBRT-PKXD-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 ('LBRT-PKXD-13-0','LBRT-PKXD-13-0','00018312','RD','1','0.305','1150');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-PKXD-13-0','00018312','RD','1','0.305','1150','350.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('LBRT-PKXD-13-0','LBRT-PKXD-13-0','00018312','RD','16','0.095','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('LBRT-PKXD-13-0','00018312','RD','16','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 ('LBRT-PKXD-13-0','00018312','00018312','LIONTIN LBRT-00030','LIONTIN LBRT-00030','','','2404500','2404500',' 0','0','spv','2025-11-10 10:11:56');
UPDATE tm_barang SET nama_barang='LIONTIN LBRT-00030' ,nama_atribut='' ,kode_intern='LBRT-00030 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L105 1125',total_usd_ext='IDR 35 000 000',total_usd='393.5' WHERE kode_barang='LBRT-PKXD-13-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','10:24:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','10:44:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','10:48:00');
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-01377','HELMI','1','PER','WEDDING RING','','','5.000','','925.00','1','60000','0','1450000','0','1450000','cewe size 15 grf JOEY 110795','cowo size 23 grf INDAH 115712','model dan krum spt contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251110-0005','2025-11-10','2025-11-10 12:10:20','PESANAN : DP-01377','.','TBC','1450000','1450000');
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-251110-0006','D','2025-11-10','12:10:20','TBC','PESANAN','DP-01377','17879635314','1450000','17881085314','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01377','2025-11-10','2025-11-10','12:10:20','PLG0007513','HELMI','2025-11-30','kasir','2025-11-10 12:10:20','5.000','0','0','0','1450000','0','0','1450000','1450000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0001','kasir','1',' 800K-11-17','TOKO','BIPPER','PBDG-YKXF-44-0','CINCIN SILVER 925 ','','2.340','1','100.00','144000','0','0','16750','599000','0','0','0','599000','SUL','00039521','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='PBDG-YKXF-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0001','2025-11-10','2.340','2025-11-10','12:11:58','PLG0007514','599000','599000','0','599000','0','kasir','2025-11-10 12:11:57','FJ-251110-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-10','FJ-251110-0001','2025-11-10','12:11:58','SUL','599000','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-251110-0006','2025-11-10','2025-11-10 12:11:57','PENJUALAN : FJ-251110-0001','.','TBC','599000','599000','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-251110-0007','D','2025-11-10','12:11:58','TBC','PENJUALAN','FJ-251110-0001','17881085314','599000','17881684314','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='599000' WHERE no_faktur_jual='FJ-251110-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','13:54:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','15:48:35');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0002','kasir','1',' LMT1-115% ','TOKO','TFLM','LMT1-YJXH-12-0','LM ANTAM 1 GR K74443578 ','','1.000','1','115.00','2499000','0','0','16750','3100000','0','0','0','3100000','BARY','00039101','LMT1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMT1-YJXH-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='LMT1-YJXH-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0002','2025-11-10','1.000','2025-11-10','15:49:28','PLG0007515','3100000','3100000','0','3100000','0','kasir','2025-11-10 15:49:27','FJ-251110-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0002','2025-11-10','15:49:28','BARY','3100000','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-251110-0007','2025-11-10','2025-11-10 15:49:27','PENJUALAN : FJ-251110-0002','','TBC','3100000','3100000','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-251110-0008','D','2025-11-10','15:49:28','TBC','PENJUALAN','FJ-251110-0002','17881684314','3100000','17884784314','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='3100000' WHERE no_faktur_jual='FJ-251110-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0003','kasir',' 1',' LMT1-115% ','TOKO','TFLM','LMT1-YJXH-13-0','LM ANTAM 1 GR K74443576 ','','1.000','1','115.00','2499000','0','0','16750','3100000','0','0','0','3100000','BARY','00039102','LMT1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMT1-YJXH-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='LMT1-YJXH-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0003','2025-11-10','1.000','2025-11-10','15:49:28','PLG0007516','3100000','3100000','0','3100000','0','kasir','2025-11-10 15:49:27','FJ-251110-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0003','2025-11-10','15:49:28','BARY','3100000','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-251110-0008','2025-11-10','2025-11-10 15:49:27','PENJUALAN : FJ-251110-0003','','TBC','3100000','3100000','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-251110-0009','D','2025-11-10','15:49:28','TBC','PENJUALAN','FJ-251110-0003','17884784314','3100000','17887884314','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='6200000' WHERE no_faktur_jual='FJ-251110-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-10 ','15:56:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-10 ','16:17:31');
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-01378','SULIS','1','PER','WED RING','','','2.000','','925.00','1','60000','0','700000','0','700000','sz 14 crom putih doff semprot','1 zircon font berkshier swash','grf Tania','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251110-0009','2025-11-10','2025-11-10 16:20:34','PESANAN : DP-01378','.','TBC','700000','700000');
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-251110-0010','D','2025-11-10','16:20:34','TBC','PESANAN','DP-01378','17887884314','700000','17888584314','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01378','2025-11-10','2025-11-10','16:20:34','PLG0007517','SULIS','2025-11-30','kasir','2025-11-10 16:20:34','2.000','0','0','0','700000','0','0','700000','700000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01379','SULIS','1','PER','WED RING','','','2.000','','925.00','1','60000','0','900000','0','900000','sz 14 putih glosy','font berkshire swash grf Indra','model spt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251110-0010','2025-11-10','2025-11-10 16:24:29','PESANAN : DP-01379','.','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251110-0011','D','2025-11-10','16:24:29','TBC','PESANAN','DP-01379','17888584314','900000','17889484314','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01379','2025-11-10','2025-11-10','16:24:29','PLG0007518','SULIS','2025-11-30','kasir','2025-11-10 16:24:29','2.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','16:51:59');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='BIPPER' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-11-10',jam_taking= '16:52:45',input_by='kasir';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01440','SULIS','1','SEPASANG SILVER','CWE SZ 17 FONT VINTAGE ROTTER CROM PUTIH GLOSY KEDUANYA','4.000','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-01440','2025-11-10','2025-11-10','17:59:47','PLG0007519','kasir','2025-11-20','kasir','2025-11-10 17:59:47','4.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','18:00:06');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0004','kasir','1',' 800K-13-17','TOKO','BIPPER','PBDG-YKXF-45-0','CINCIN SILVER 925 ','','2.390','1','100.00','147000','0','0','16750','599000','0','0','0','599000','SUL','00039522','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='PBDG-YKXF-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0004','2025-11-10','2.390','2025-11-10','19:00:27','PLG0007520','599000','599000','0','599000','0','kasir','2025-11-10 19:00:26','FJ-251110-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-10','FJ-251110-0004','2025-11-10','19:00:27','SUL','599000','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-251110-0011','2025-11-10','2025-11-10 19:00:26','PENJUALAN : FJ-251110-0004','.','TBC','599000','599000','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-251110-0012','D','2025-11-10','19:00:27','TBC','PENJUALAN','FJ-251110-0004','17889484314','599000','17890083314','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='599000' WHERE no_faktur_jual='FJ-251110-0004' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0005','kasir',' 1',' 500K-205-1','TOKO','BIPPER','PBDG-YKXF-12-0','CINCIN SILVER 925 ','','2.090','1','100.00','129000','0','0','16750','400000','0','0','0','400000','SUL','00039489','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='PBDG-YKXF-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0005','2025-11-10','2.090','2025-11-10','19:00:27','PLG0007521','400000','400000','0','400000','0','kasir','2025-11-10 19:00:26','FJ-251110-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-10','FJ-251110-0005','2025-11-10','19:00:27','SUL','400000','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-251110-0012','2025-11-10','2025-11-10 19:00:26','PENJUALAN : FJ-251110-0005','.','TBC','400000','400000','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-251110-0013','D','2025-11-10','19:00:27','TBC','PENJUALAN','FJ-251110-0005','17890083314','400000','17890483314','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='999000' WHERE no_faktur_jual='FJ-251110-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','20:01:56');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0006','kasir','1',' DP-01281BI','TOKO','BIPPSN','PSPLT-YKXD-3-0','CINCIN PALADIUM ','','4.050','1','6.00','573000','0','0','16750','1712500','0','0','0','1712500','SUL','00039450','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YKXD-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.050',berat_jual_asli=berat_jual_asli+'4.050',stock_jual='1',berat_akhir=berat_akhir-'4.050',berat_akhir_asli=berat_akhir_asli-'4.050',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='PSPLT-YKXD-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0006','2025-11-10','4.050','2025-11-10','20:02:46','PLG0007522','1712500','1712500','0','1712500','0','kasir','2025-11-10 20:02:45','FJ-251110-0006','DP-01281','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-10','FJ-251110-0006','2025-11-10','20:02:46','SUL','1712500','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-251110-0013','2025-11-10','2025-11-10 20:02:45','PENJUALAN : FJ-251110-0006','.','TBC','1712500','1712500','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-251110-0014','D','2025-11-10','20:02:46','TBC','PENJUALAN','FJ-251110-0006','17890483314','1712500','17892195814','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='1712500' WHERE no_faktur_jual='FJ-251110-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0007','kasir',' 1',' DP-01280BI','TOKO','BIPPSN','PSGT-YKXG-1-0','CINCIN EMAS ','','2.350','1','83.00','4239000','0','0','16750','5835000','0','0','0','5835000','SUL','00039524','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YKXG-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2025-11-10' AND kode_barang='PSGT-YKXG-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0007','2025-11-10','2.350','2025-11-10','20:02:46','PLG0007523','5835000','5835000','0','5835000','0','kasir','2025-11-10 20:02:45','FJ-251110-0006','DP-01280','4920000');
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-10','FJ-251110-0007','2025-11-10','20:02:46','SUL','5835000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1712500' WHERE no_faktur_jual='FJ-251110-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-10';
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-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-10';
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-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-10' 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-251111-0001','D','2025-11-11','20:04:31','TBC','SALDO AWAL','SALDO AWAL','0','17892195814','17892195814');
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-251111-0001','D','2025-11-11','20:04:31','BCD','SALDO AWAL','SALDO AWAL','0','1334821000','1334821000');
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-251111-0001','D','2025-11-11','20:04:31','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251111-0001','D','2025-11-11','20:04:31','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251111-0001','D','2025-11-11','20:04:31','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251111-0001','D','2025-11-11','20:04:31','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251111-0001','D','2025-11-11','20:04:31','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-251111-0001','D','2025-11-11','20:04:31','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251111-0001','D','2025-11-11','20:04:31','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-251111-0001','D','2025-11-11','20:04:31','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-251111-0001','D','2025-11-11','20:04:31','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-11-11';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','20:30:55');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0008','kasir','1',' 700K-12-00','TOKO','MMPER','PMM-YGXG-6-0','CINCIN SILVER 925 ','','2.480','1','100.00','58000','0','0','16750','700000','0','0','0','700000','GEISYA','00037000','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXG-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.480',berat_jual_asli=berat_jual_asli+'2.480',stock_jual='1',berat_akhir=berat_akhir-'2.480',berat_akhir_asli=berat_akhir_asli-'2.480',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='PMM-YGXG-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0008','2025-11-11','2.480','2025-11-10','20:33:52','PLG0007524','700000','700000','0','700000','0','kasir','2025-11-10 20:33:52','FJ-251110-0008','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','FJ-251110-0008','2025-11-10','20:33:52','GEISYA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251111-0001','2025-11-11','2025-11-10 20:33:52','PENJUALAN : FJ-251110-0008','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251111-0002','D','2025-11-11','20:33:52','TBC','PENJUALAN','FJ-251110-0008','17892195814','700000','17892895814','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-251110-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-251110-0009','kasir','1',' 700K-17-00','TOKO','MMPER','PMM-YFBX-152-0','CINCIN SILVER 925 ','','4.000','1','100.00','92000','0','0','16750','700000','0','0','0','700000','NAD','00036593','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-152-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='PMM-YFBX-152-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-251110-0009','2025-11-11','4.000','2025-11-10','20:35:47','PLG0007525','700000','700000','0','700000','0','kasir','2025-11-10 20:35:46','FJ-251110-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','FJ-251110-0009','2025-11-10','20:35:47','NAD','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251111-0002','2025-11-11','2025-11-10 20:35:46','PENJUALAN : FJ-251110-0009','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251111-0003','D','2025-11-11','20:35:47','TBC','PENJUALAN','FJ-251110-0009','17892895814','700000','17893595814','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-251110-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251110-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251110-0009';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01441','GEISYA','1','2 PCS CINCIN SILVER','CEWE GRAFIR SACA KRUM FULL PUTIH COWO GRAFIR SHABRINA KRUM FULL PUTIH','6.480','1','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01441','GEISYA','2','','','','','','');
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-01441','2025-11-11','2025-11-11','20:41:29','PLG0007526','kasir','2025-11-12','kasir','2025-11-10 20:41:29','6.480','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-10 ','20:44:11');
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-01380','SULIS','1','PER','WEDDING RING','','','1.000','','925.00','1','60000','0','850000','0','850000','sz 9.5 putih glosy','model spt contoh fonht vintage rotter','grf Pian & Mila','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251111-0003','2025-11-11','2025-11-10 20:45:24','PESANAN : DP-01380','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251111-0004','D','2025-11-11','20:45:24','TBC','PESANAN','DP-01380','17893595814','850000','17894445814','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01380','2025-11-11','2025-11-11','20:45:24','PLG0007527','SULIS','2025-11-30','kasir','2025-11-10 20:45:24','1.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01381','SULIS','1','PER','WED RING','','','2.000','','925.00','1','60000','0','700000','0','700000','1 zircon sz 18 putih glosy','font vintage rotter grf Mila & pian','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251111-0004','2025-11-11','2025-11-10 20:46:37','PESANAN : DP-01381','.','TBC','700000','700000');
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-251111-0005','D','2025-11-11','20:46:37','TBC','PESANAN','DP-01381','17894445814','700000','17895145814','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01381','2025-11-11','2025-11-11','20:46:37','PLG0007528','SULIS','2025-11-30','kasir','2025-11-10 20:46:37','2.000','0','0','0','700000','0','0','700000','700000','0');