INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-23 ','08:09:56');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-23 ','08:11:16');
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-01520';
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 ('PSPRT-YLBC-1-0','00040662','DP-01520BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','121000','2025-12-23','121000','2.010','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-23 08:43:11','2.010','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01520BIP','1','RS 12','','DP-01520');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLBC-1-0','00040662');
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-12-23','PSPRT-YLBC-1-0','PSPRT','TOKO','PSNB','100.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01520BIP ');
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-01489';
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 ('PSPRT-YLBC-2-0','00040663','DP-01489BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','77500','2025-12-23','77500','1.290','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-23 08:45:05','1.290','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01489BIP','1','RS 12','','DP-01489');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLBC-2-0','00040663');
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-12-23','PSPRT-YLBC-2-0','PSPRT','TOKO','PSNB','100.00','1.290','1.290','1','1.290','1.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01489BIP ');
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-01483';
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 ('PSPRT-YLBC-3-0','00040664','DP-01483BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','108000','2025-12-23','108000','1.800','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-23 08:46:37','1.800','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01483BIP','1','RS 14','','DP-01483');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLBC-3-0','00040664');
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-12-23','PSPRT-YLBC-3-0','PSPRT','TOKO','PSNB','100.00','1.800','1.800','1','1.800','1.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01483BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251223-0001','1','PSPRT-YLBC-1-0','1','2.010','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBC-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YLBC-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBC-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YLBC-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YLBC-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='PSPRT-YLBC-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251223-0001','2','PSPRT-YLBC-2-0','1','1.290','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBC-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YLBC-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBC-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YLBC-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YLBC-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.290',berat_out_asli='1.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.290',berat_akhir_asli =berat_akhir_asli-'1.290' WHERE kode_barang='PSPRT-YLBC-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251223-0001','3','PSPRT-YLBC-3-0','1','1.800','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBC-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YLBC-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBC-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YLBC-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YLBC-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.800',berat_out_asli='1.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.800',berat_akhir_asli =berat_akhir_asli-'1.800' WHERE kode_barang='PSPRT-YLBC-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251223-0001','2025-12-23','2025-12-23','08:49','1.800','input','2025-12-23 08:49:07','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-23 ','08:53:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-23 ','09:10:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-23 ','09:19:07');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-23 ','10:05:24');
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2432500',harga_beli ='2432500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4927500',harga_beli ='4927500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='192000',harga_beli ='192000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2787500',harga_beli ='2787500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6171500',harga_beli ='6171500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2312000',harga_beli ='2312000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2211500',harga_beli ='2211500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2252000',harga_beli ='2252000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5367500',harga_beli ='5367500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='19821500',harga_beli ='19821500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2758000',harga_beli ='2758000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2733000',harga_beli ='2733000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2582500',harga_beli ='2582500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2682500',harga_beli ='2682500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2657500',harga_beli ='2657500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7459500',harga_beli ='7459500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2856000',harga_beli ='2856000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='10231500',harga_beli ='10231500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3690500',harga_beli ='3690500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4338500',harga_beli ='4338500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4456000',harga_beli ='4456000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5241500',harga_beli ='5241500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4240000',harga_beli ='4240000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6066000',harga_beli ='6066000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7243500',harga_beli ='7243500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='8735500',harga_beli ='8735500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7067000',harga_beli ='7067000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='1472500',harga_beli ='1472500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2729000',harga_beli ='2729000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4161500',harga_beli ='4161500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3769000',harga_beli ='3769000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2159500',harga_beli ='2159500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2081000',harga_beli ='2081000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6380000',harga_beli ='6380000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7656000',harga_beli ='7656000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3416000',harga_beli ='3416000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6772500',harga_beli ='6772500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5379000',harga_beli ='5379000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2611000',harga_beli ='2611000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='2218500',harga_beli ='2218500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5045000',harga_beli ='5045000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3533500',harga_beli ='3533500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5237500',harga_beli ='5237500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6753000',harga_beli ='6753000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='10227000',harga_beli ='10227000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='9226000',harga_beli ='9226000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3376500',harga_beli ='3376500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5261000',harga_beli ='5261000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7341500',harga_beli ='7341500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6694000',harga_beli ='6694000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6890000',harga_beli ='6890000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7911000',harga_beli ='7911000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='15782500',harga_beli ='15782500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='1610000',harga_beli ='1610000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='1610000',harga_beli ='1610000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='1531500',harga_beli ='1531500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='1472500',harga_beli ='1472500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4868500',harga_beli ='4868500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='8362500',harga_beli ='8362500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='9560000',harga_beli ='9560000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='8127000',harga_beli ='8127000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7616500',harga_beli ='7616500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='8343000',harga_beli ='8343000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7440000',harga_beli ='7440000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4436500',harga_beli ='4436500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='53255000',harga_beli ='53255000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='8284000',harga_beli ='8284000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7656000',harga_beli ='7656000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5673000',harga_beli ='5673000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='10894500',harga_beli ='10894500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='12643000',harga_beli ='12643000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='7263000',harga_beli ='7263000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5869500',harga_beli ='5869500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6439000',harga_beli ='6439000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5045000',harga_beli ='5045000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2365000','input','2025-12-23 11:33:35');
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='16585000',harga_beli ='16585000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='9730000',harga_beli ='9730000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5126500',harga_beli ='5126500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5166500',harga_beli ='5166500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='5995500',harga_beli ='5995500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='4551000',harga_beli ='4551000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='11302500',harga_beli ='11302500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3469500',harga_beli ='3469500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='13007500',harga_beli ='13007500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='6183500',harga_beli ='6183500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2365000','input','2025-12-23 11:33:41');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2365000','input','2025-12-23 11:33:44');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2365000','input','2025-12-23 11:33:48');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2365000','input','2025-12-23 11:33:51');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2365000','input','2025-12-23 11:33:55');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2365000','input','2025-12-23 11:33:58');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2365000','input','2025-12-23 11:34:03');
UPDATE tm_barang SET harga_skrg ='2365000',harga_jual='3573000',harga_beli ='3573000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2365000','input','2025-12-23 11:34:07');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2365000','input','2025-12-23 11:34:12');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2365000','input','2025-12-23 11:34:16');
UPDATE tm_group SET harga='2365000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2365000','input','2025-12-23 11:34:21');