INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','08:05:18');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-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-10-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-10' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-11';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','08:05:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-11';
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-10-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-12';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','08:06:08');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-12';
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-10-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-12' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-13';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','08:06:26');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','08:48:12');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDC-YJAC-1-0','00039178','BDC-00122 ','CINCIN BDC-00043 ','','GR','---','DM','BDC','TOKO','CBBD','2995000','2025-10-13','2995000','1.710','83.00','75','0','2110000.00','1','0.14', 'input','2025-10-13 09:19:45','1.710','400000','33.25','16600.00','','TOKO','FREETAG','','10','','','IDR 14 000 000','1','RS 14 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDC','BDC-YJAC-1-0','00039178');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDC-YJAC-1-0','BDC','TOKO','CBBD','83.00','1.710','1.710','1','1.710','1.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDC','BDC-00122 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDC-YJAC-1-0','00039178','RD','1','0.070 ','475','33.25');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDC-YJAC-2-0','00039179','BDC-00123 ','CINCIN BDC-00123 ','','GR','---','DM','BDC','TOKO','CBBD','2837500','2025-10-13','2837500','1.620','83.00','75','0','2110000.00','1','0.14', 'input','2025-10-13 09:22:42','1.620','470000','20.00','16600.00','','TOKO','FREETAG','','10','','','IDR 14 000 000','1','RS 11 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDC','BDC-YJAC-2-0','00039179');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDC-YJAC-2-0','BDC','TOKO','CBBD','83.00','1.620','1.620','1','1.620','1.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDC','BDC-00123 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDC-YJAC-2-0','00039179','RD','15','0.050 ','400','20');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDC-YJAC-3-0','00039180','BDC-00124 ','CINCIN BDC-00124 ','','GR','---','DM','BDC','TOKO','CBBD','2294500','2025-10-13','2294500','1.310','83.00','75','0','2110000.00','1','0.14', 'input','2025-10-13 09:25:23','1.310','455000','18.00','16600.00','','TOKO','FREETAG','','10','','','IDR 12 000 000','1','RS 12 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDC','BDC-YJAC-3-0','00039180');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDC-YJAC-3-0','BDC','TOKO','CBBD','83.00','1.310','1.310','1','1.310','1.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDC','BDC-00124 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDC-YJAC-3-0','00039180','RD','12','0.045 ','400','18');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDC-YJAC-4-0','00039181','BDC-00125 ','CINCIN BDC-00125 ','','GR','---','DM','BDC','TOKO','CBBD','1821500','2025-10-13','1821500','1.040','83.00','75','0','2110000.00','1','0.14', 'input','2025-10-13 09:28:07','1.040','410000','16.65','16600.00','','TOKO','FREETAG','','10','','','IDR 9 000 000','1','RS 12 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDC','BDC-YJAC-4-0','00039181');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDC-YJAC-4-0','BDC','TOKO','CBBD','83.00','1.040','1.040','1','1.040','1.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDC','BDC-00125 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDC-YJAC-4-0','00039181','RD','3','0.045 ','370','16.65');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDC-YJAC-5-0','00039182','BDC-00126 ','CINCIN BDC-00126 ','','GR','---','DM','BDC','TOKO','CBBD','2014500','2025-10-13','2014500','1.150','83.00','75','0','2110000.00','1','0.14', 'input','2025-10-13 09:30:42','1.150','415000','20.35','16600.00','','TOKO','FREETAG','','10','','','IDR 10 000 000','1','RS 12 5 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDC','BDC-YJAC-5-0','00039182');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDC-YJAC-5-0','BDC','TOKO','CBBD','83.00','1.150','1.150','1','1.150','1.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDC','BDC-00126 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDC-YJAC-5-0','00039182','RD','4','0.055 ','370','20.35');
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2191000',harga_beli ='2191000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4437500',harga_beli ='4437500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='173000',harga_beli ='173000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2510500',harga_beli ='2510500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5558500',harga_beli ='5558500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2082500',harga_beli ='2082500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1992000',harga_beli ='1992000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2028000',harga_beli ='2028000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4834500',harga_beli ='4834500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='17852000',harga_beli ='17852000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2484000',harga_beli ='2484000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2461500',harga_beli ='2461500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2326000',harga_beli ='2326000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2416000',harga_beli ='2416000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2393500',harga_beli ='2393500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6718500',harga_beli ='6718500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2572500',harga_beli ='2572500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='9214500',harga_beli ='9214500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3324000',harga_beli ='3324000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3907500',harga_beli ='3907500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4013500',harga_beli ='4013500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4720500',harga_beli ='4720500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3819000',harga_beli ='3819000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5463000',harga_beli ='5463000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6524000',harga_beli ='6524000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7867500',harga_beli ='7867500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6364500',harga_beli ='6364500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1326000',harga_beli ='1326000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2457500',harga_beli ='2457500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3748000',harga_beli ='3748000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3394500',harga_beli ='3394500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1945000',harga_beli ='1945000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1874000',harga_beli ='1874000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5746000',harga_beli ='5746000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6895000',harga_beli ='6895000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3076500',harga_beli ='3076500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6099500',harga_beli ='6099500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4844500',harga_beli ='4844500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2351500',harga_beli ='2351500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1998000',harga_beli ='1998000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4544000',harga_beli ='4544000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3182500',harga_beli ='3182500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4717000',harga_beli ='4717000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6082000',harga_beli ='6082000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='9211000',harga_beli ='9211000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='8309500',harga_beli ='8309500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3041000',harga_beli ='3041000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4738000',harga_beli ='4738000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6612000',harga_beli ='6612000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6029000',harga_beli ='6029000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6205500',harga_beli ='6205500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7125000',harga_beli ='7125000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='14214000',harga_beli ='14214000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1450000',harga_beli ='1450000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1450000',harga_beli ='1450000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1379000',harga_beli ='1379000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1326000',harga_beli ='1326000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4384500',harga_beli ='4384500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7531500',harga_beli ='7531500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='8610000',harga_beli ='8610000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7319500',harga_beli ='7319500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6859500',harga_beli ='6859500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7514000',harga_beli ='7514000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6700500',harga_beli ='6700500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3995500',harga_beli ='3995500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='47963500',harga_beli ='47963500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='7461000',harga_beli ='7461000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6895000',harga_beli ='6895000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5109500',harga_beli ='5109500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='9812000',harga_beli ='9812000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='11386500',harga_beli ='11386500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='6541500',harga_beli ='6541500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5286500',harga_beli ='5286500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5799000',harga_beli ='5799000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4544000',harga_beli ='4544000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3023500',harga_beli ='3023500' WHERE kode_barcode='00039178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2864500',harga_beli ='2864500' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2316000',harga_beli ='2316000' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='1839000',harga_beli ='1839000' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='2033500',harga_beli ='2033500' WHERE kode_barcode='00039182' LIMIT 1;
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2130000','input','2025-10-13 09:54:01');
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='14937000',harga_beli ='14937000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='8763000',harga_beli ='8763000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4617000',harga_beli ='4617000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4653500',harga_beli ='4653500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5400000',harga_beli ='5400000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='4098500',harga_beli ='4098500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='10179500',harga_beli ='10179500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3124500',harga_beli ='3124500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='11715000',harga_beli ='11715000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='5569000',harga_beli ='5569000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2130000','input','2025-10-13 09:54:09');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2130000','input','2025-10-13 09:54:12');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2130000','input','2025-10-13 09:54:16');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2130000','input','2025-10-13 09:54:19');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2130000','input','2025-10-13 09:54:22');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2130000','input','2025-10-13 09:54:26');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2130000','input','2025-10-13 09:54:31');
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='3218000',harga_beli ='3218000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2130000','input','2025-10-13 09:54:35');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2130000','input','2025-10-13 09:54:40');
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2130000','input','2025-10-13 09:54:45');
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='322500',harga_beli ='322500' WHERE kode_barcode='00039147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2130000',harga_jual='602000',harga_beli ='602000' WHERE kode_barcode='00039148' LIMIT 1;
UPDATE tm_group SET harga='2130000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2130000','input','2025-10-13 09:54:50');
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2206500',harga_beli ='2206500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4469000',harga_beli ='4469000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='174000',harga_beli ='174000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2528500',harga_beli ='2528500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5597500',harga_beli ='5597500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2097000',harga_beli ='2097000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2006000',harga_beli ='2006000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2042500',harga_beli ='2042500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4868500',harga_beli ='4868500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='17977500',harga_beli ='17977500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2501500',harga_beli ='2501500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2478500',harga_beli ='2478500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2342000',harga_beli ='2342000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2433000',harga_beli ='2433000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2410500',harga_beli ='2410500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6765500',harga_beli ='6765500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2590500',harga_beli ='2590500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='9279500',harga_beli ='9279500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3347500',harga_beli ='3347500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3935000',harga_beli ='3935000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4041500',harga_beli ='4041500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4754000',harga_beli ='4754000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3846000',harga_beli ='3846000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5501500',harga_beli ='5501500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6570000',harga_beli ='6570000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='7923000',harga_beli ='7923000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6409500',harga_beli ='6409500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1335500',harga_beli ='1335500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2475000',harga_beli ='2475000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3774500',harga_beli ='3774500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3418500',harga_beli ='3418500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1958500',harga_beli ='1958500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1887500',harga_beli ='1887500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5786500',harga_beli ='5786500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6943500',harga_beli ='6943500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3098000',harga_beli ='3098000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6142500',harga_beli ='6142500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4878500',harga_beli ='4878500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2368000',harga_beli ='2368000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2012000',harga_beli ='2012000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4576000',harga_beli ='4576000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3205000',harga_beli ='3205000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4750500',harga_beli ='4750500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6124500',harga_beli ='6124500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='9276000',harga_beli ='9276000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='8368000',harga_beli ='8368000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3062500',harga_beli ='3062500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4771500',harga_beli ='4771500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6659000',harga_beli ='6659000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6071500',harga_beli ='6071500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6249500',harga_beli ='6249500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='7175000',harga_beli ='7175000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='14314500',harga_beli ='14314500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1460000',harga_beli ='1460000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1460000',harga_beli ='1460000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1389000',harga_beli ='1389000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1335500',harga_beli ='1335500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4415500',harga_beli ='4415500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='7584500',harga_beli ='7584500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='8670500',harga_beli ='8670500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='7371000',harga_beli ='7371000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6908000',harga_beli ='6908000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='7567000',harga_beli ='7567000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6748000',harga_beli ='6748000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4024000',harga_beli ='4024000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='48301000',harga_beli ='48301000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='7513500',harga_beli ='7513500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6943500',harga_beli ='6943500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5145500',harga_beli ='5145500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='9881000',harga_beli ='9881000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='11467000',harga_beli ='11467000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='6587500',harga_beli ='6587500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5323500',harga_beli ='5323500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5840000',harga_beli ='5840000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4576000',harga_beli ='4576000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3044500',harga_beli ='3044500' WHERE kode_barcode='00039178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2884500',harga_beli ='2884500' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2332500',harga_beli ='2332500' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='1852000',harga_beli ='1852000' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='2047500',harga_beli ='2047500' WHERE kode_barcode='00039182' LIMIT 1;
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2145000','input','2025-10-13 11:12:39');
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='15042000',harga_beli ='15042000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='8825000',harga_beli ='8825000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4649500',harga_beli ='4649500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4686000',harga_beli ='4686000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5438000',harga_beli ='5438000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='4127500',harga_beli ='4127500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='10251000',harga_beli ='10251000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3146500',harga_beli ='3146500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='11797500',harga_beli ='11797500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='5608500',harga_beli ='5608500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2145000','input','2025-10-13 11:12:45');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2145000','input','2025-10-13 11:12:49');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2145000','input','2025-10-13 11:12:52');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2145000','input','2025-10-13 11:12:57');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2145000','input','2025-10-13 11:13:00');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2145000','input','2025-10-13 11:13:04');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2145000','input','2025-10-13 11:13:10');
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='3240500',harga_beli ='3240500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2145000','input','2025-10-13 11:13:14');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2145000','input','2025-10-13 11:13:18');
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2145000','input','2025-10-13 11:13:22');
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='324500',harga_beli ='324500' WHERE kode_barcode='00039147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2145000',harga_jual='606500',harga_beli ='606500' WHERE kode_barcode='00039148' LIMIT 1;
UPDATE tm_group SET harga='2145000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2145000','input','2025-10-13 11:13:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','13:14:06');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-13 ','14:51:01');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01183';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YJAC-6-0','00039183','DP-01183MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','311500','2025-10-13','311500','2.900','5.00','10','300000','2145000.00','1','0.14', 'input','2025-10-13 15:42:12','2.900','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01183MM','1','RS 19','','DP-01183');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJAC-6-0','00039183');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','PSPLT-YJAC-6-0','PSPLT','TOKO','MMPSN','5.00','2.900','2.900','1','2.900','2.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01183MM ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01187';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YJAC-7-0','00039184','DP-01187MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','148500','2025-10-13','148500','1.380','5.00','10','300000','2145000.00','1','0.14', 'input','2025-10-13 15:44:17','1.380','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01187MM','1','RS 11','','DP-01187');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJAC-7-0','00039184');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','PSPLT-YJAC-7-0','PSPLT','TOKO','MMPSN','5.00','1.380','1.380','1','1.380','1.380','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01187MM ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02884';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGE-YJAC-8-0','00039185','DP-02884 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','5448000','2025-10-13','5448000','3.060','83.00','75','300000','2145000.00','1','0.04', 'input','2025-10-13 15:46:08','3.060','0','','16600.00','','TOKO','FREETAG','','2','','','PSN02884','1','RS 11 5','','DP-02884');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-YJAC-8-0','00039185');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','PSGE-YJAC-8-0','PSGE','TOKO','PSN','83.00','3.060','3.060','1','3.060','3.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-02884 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YJAC-9-0','00039186','CKBE-01169 ','CINCIN KAWIN CKBE-01169 ','','GR','---','DM','CKBE','TOKO','CKBE','6107000','2025-10-13','6107000','3.430','83.00','75','0','2145000.00','1','0.04', 'input','2025-10-13 16:21:56','3.430','350000','54.00','16600.00','','TOKO','FREETAG','','10','','','IDR 30 500 000','1','RS 13 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YJAC-9-0','00039186');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','CKBE-YJAC-9-0','CKBE','TOKO','CKBE','83.00','3.430','3.430','1','3.430','3.430','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01169 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YJAC-9-0','00039186','RD','1','0.090 ','600','54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YJAC-10-0','00039187','CKBE-01170 ','CINCIN KAWIN CKBE-01170 ','','GR','---','DM','CKBE','TOKO','CKBE','5501500','2025-10-13','5501500','3.090','83.00','75','0','2145000.00','1','0.04', 'input','2025-10-13 16:23:57','3.090','350000','54.00','16600.00','','TOKO','FREETAG','','10','','','IDR 28 000 000','1','RS 13 5 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YJAC-10-0','00039187');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','CKBE-YJAC-10-0','CKBE','TOKO','CKBE','83.00','3.090','3.090','1','3.090','3.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01170 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YJAC-10-0','00039187','RD','1','0.090 ','600','54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YJAC-11-0','00039188','CKBE-01171 ','CINCIN KAWIN CKBE-01171 ','','GR','---','DM','CKBE','TOKO','CKBE','5412500','2025-10-13','5412500','3.040','83.00','75','0','2145000.00','1','0.04', 'input','2025-10-13 16:25:55','3.040','350000','54.00','16600.00','','TOKO','FREETAG','','10','','','IDR 28 000 000','1','RS 14 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YJAC-11-0','00039188');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','CKBE-YJAC-11-0','CKBE','TOKO','CKBE','83.00','3.040','3.040','1','3.040','3.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01171 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YJAC-11-0','00039188','RD','1','0.090 ','600','54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YJAC-12-0','00039189','CKBE-01172 ','CINCIN KAWIN CKBE-01172 ','','GR','---','DM','CKBE','TOKO','CKBE','4878500','2025-10-13','4878500','2.740','83.00','75','0','2145000.00','1','0.04', 'input','2025-10-13 16:27:48','2.740','350000','54.00','16600.00','','TOKO','FREETAG','','10','','','IDR 25 500 000','1','RS 13 5 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YJAC-12-0','00039189');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','CKBE-YJAC-12-0','CKBE','TOKO','CKBE','83.00','2.740','2.740','1','2.740','2.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01172 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YJAC-12-0','00039189','RD','1','0.090 ','600','54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YJAC-13-0','00039190','CKBE-01173 ','CINCIN KAWIN CKBE-01173 ','','GR','---','DM','CKBE','TOKO','CKBE','4825000','2025-10-13','4825000','2.710','83.00','75','0','2145000.00','1','0.04', 'input','2025-10-13 16:29:58','2.710','350000','10.50','16600.00','','TOKO','FREETAG','','10','','','IDR 22 000 000','1','RS 11 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YJAC-13-0','00039190');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','CKBE-YJAC-13-0','CKBE','TOKO','CKBE','83.00','2.710','2.710','1','2.710','2.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01173 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YJAC-13-0','00039190','RD','1','0.025 ','420','10.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKBE-YJAC-14-0','00039191','CKBE-01174 ','CINCIN KAWIN CKBE-01174 ','','GR','---','DM','CKBE','TOKO','CKBE','4611500','2025-10-13','4611500','2.590','83.00','75','0','2145000.00','1','0.04', 'input','2025-10-13 16:31:49','2.590','350000','8.40','16600.00','','TOKO','FREETAG','','10','','','IDR 21 000 000','1','RS 11 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-YJAC-14-0','00039191');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','CKBE-YJAC-14-0','CKBE','TOKO','CKBE','83.00','2.590','2.590','1','2.590','2.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-01174 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-YJAC-14-0','00039191','RD','1','0.020 ','420','8.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDCK-YJAC-15-0','00039192','BDCK-00111 ','CINCIN KAWIN BDCK-00111 ','','GR','---','DM','BDCK','TOKO','CKBBD','5448000','2025-10-13','5448000','3.060','83.00','75','0','2145000.00','1','0.14', 'input','2025-10-13 16:39:20','3.060','350000','54.00','16600.00','','TOKO','FREETAG','','10','','','IDR 28 000 000','1','RS 11 5 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCK','BDCK-YJAC-15-0','00039192');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDCK-YJAC-15-0','BDCK','TOKO','CKBBD','83.00','3.060','3.060','1','3.060','3.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCK','BDCK-00111 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDCK-YJAC-15-0','00039192','RD','1','0.090 ','600','54');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDCK-YJAC-16-0','00039193','BDCK-00112 ','CINCIN KAWIN BDCK-00112 ','','GR','---','DM','BDCK','TOKO','CKBBD','4896000','2025-10-13','4896000','2.750','83.00','75','0','2145000.00','1','0.14', 'input','2025-10-13 16:41:27','2.750','350000','10.50','16600.00','','TOKO','FREETAG','','10','','','IDR 22 500 000','1','RS 11 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCK','BDCK-YJAC-16-0','00039193');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDCK-YJAC-16-0','BDCK','TOKO','CKBBD','83.00','2.750','2.750','1','2.750','2.750','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCK','BDCK-00112 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDCK-YJAC-16-0','00039193','RD','1','0.025 ','420','10.5');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('BDCK-YJAC-17-0','00039194','BDCK-00113 ','CINCIN KAWIN BDCK-00113 ','','GR','---','DM','BDCK','TOKO','CKBBD','3027000','2025-10-13','3027000','1.700','83.00','75','0','2145000.00','1','0.14', 'input','2025-10-13 16:43:28','1.700','350000','8.40','16600.00','','TOKO','FREETAG','','10','','','IDR 14 500 000','1','RS 12 5 1025','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCK','BDCK-YJAC-17-0','00039194');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-13','BDCK-YJAC-17-0','BDCK','TOKO','CKBBD','83.00','1.700','1.700','1','1.700','1.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCK','BDCK-00113 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('BDCK-YJAC-17-0','00039194','RD','1','0.020 ','420','8.4');