INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-08-27 ','08:04:55');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-26';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-27';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-08-27 ','08:22:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-08-27 ','10:00:59');
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3656500',harga_beli ='3656500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='142500',harga_beli ='142500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2068500',harga_beli ='2068500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4580000',harga_beli ='4580000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1716000',harga_beli ='1716000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1641000',harga_beli ='1641000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1671000',harga_beli ='1671000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3983000',harga_beli ='3983000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='14709000',harga_beli ='14709000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2046500',harga_beli ='2046500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2028000',harga_beli ='2028000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1916500',harga_beli ='1916500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1991000',harga_beli ='1991000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1972000',harga_beli ='1972000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5535500',harga_beli ='5535500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2119500',harga_beli ='2119500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='7592500',harga_beli ='7592500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2739000',harga_beli ='2739000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3219500',harga_beli ='3219500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3307000',harga_beli ='3307000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3889500',harga_beli ='3889500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3146500',harga_beli ='3146500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4501500',harga_beli ='4501500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5375500',harga_beli ='5375500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6482500',harga_beli ='6482500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5244000',harga_beli ='5244000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1093000',harga_beli ='1093000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2025000',harga_beli ='2025000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3088500',harga_beli ='3088500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2797000',harga_beli ='2797000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1602500',harga_beli ='1602500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1544500',harga_beli ='1544500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4734500',harga_beli ='4734500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5681000',harga_beli ='5681000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2535000',harga_beli ='2535000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5025500',harga_beli ='5025500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3991500',harga_beli ='3991500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1937500',harga_beli ='1937500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1646500',harga_beli ='1646500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2622000',harga_beli ='2622000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3886500',harga_beli ='3886500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5011000',harga_beli ='5011000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='7589500',harga_beli ='7589500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6846500',harga_beli ='6846500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2505500',harga_beli ='2505500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3904000',harga_beli ='3904000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5448000',harga_beli ='5448000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4967500',harga_beli ='4967500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5113000',harga_beli ='5113000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5870500',harga_beli ='5870500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='11711500',harga_beli ='11711500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1194500',harga_beli ='1194500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1194500',harga_beli ='1194500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1136500',harga_beli ='1136500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='1093000',harga_beli ='1093000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3613000',harga_beli ='3613000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6205500',harga_beli ='6205500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='7094000',harga_beli ='7094000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6031000',harga_beli ='6031000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5652000',harga_beli ='5652000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6191000',harga_beli ='6191000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5521000',harga_beli ='5521000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3292500',harga_beli ='3292500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='39519000',harga_beli ='39519000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6147500',harga_beli ='6147500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5681000',harga_beli ='5681000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4210000',harga_beli ='4210000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='8084500',harga_beli ='8084500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='9382000',harga_beli ='9382000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='5390000',harga_beli ='5390000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4355500',harga_beli ='4355500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4778000',harga_beli ='4778000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','1755000','input','2025-08-27 10:15:53');
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='12307000',harga_beli ='12307000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='7220500',harga_beli ='7220500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3804000',harga_beli ='3804000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3834000',harga_beli ='3834000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4449000',harga_beli ='4449000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3377000',harga_beli ='3377000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='8387500',harga_beli ='8387500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2574500',harga_beli ='2574500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='9653000',harga_beli ='9653000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='4588500',harga_beli ='4588500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='14192000',harga_beli ='14192000' WHERE kode_barcode='00038299' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2668000',harga_beli ='2668000' WHERE kode_barcode='00038300' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='10235500',harga_beli ='10235500' WHERE kode_barcode='00038301' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6399500',harga_beli ='6399500' WHERE kode_barcode='00038302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='3879000',harga_beli ='3879000' WHERE kode_barcode='00038303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='18170000',harga_beli ='18170000' WHERE kode_barcode='00038304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='8256000',harga_beli ='8256000' WHERE kode_barcode='00038305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='6295000',harga_beli ='6295000' WHERE kode_barcode='00038306' LIMIT 1;
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','1755000','input','2025-08-27 10:16:00');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','1755000','input','2025-08-27 10:16:05');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','1755000','input','2025-08-27 10:16:09');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','1755000','input','2025-08-27 10:16:12');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','1755000','input','2025-08-27 10:16:15');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','1755000','input','2025-08-27 10:16:19');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','1755000','input','2025-08-27 10:16:24');
UPDATE tm_barang SET harga_skrg ='1755000',harga_jual='2651500',harga_beli ='2651500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','1755000','input','2025-08-27 10:16:29');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','1755000','input','2025-08-27 10:16:32');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','1755000','input','2025-08-27 10:16:37');
UPDATE tm_group SET harga='1755000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','1755000','input','2025-08-27 10:16:43');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0001','1','AMP-YHBF-3-0','1','7.200','TOKO','AMP');
DELETE FROM tm_barang_export WHERE kode_barang='AMP-YHBF-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='AMP-YHBF-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='AMP-YHBF-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='AMP-YHBF-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='AMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='AMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='AMP';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='AMP';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='AMP-YHBF-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.200',berat_out_asli='7.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.200',berat_akhir_asli =berat_akhir_asli-'7.200' WHERE kode_barang='AMP-YHBF-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0001','2','AMP-YHBF-4-0','1','4.240','TOKO','AMP');
DELETE FROM tm_barang_export WHERE kode_barang='AMP-YHBF-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='AMP-YHBF-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='AMP-YHBF-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='AMP-YHBF-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='AMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='AMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='AMP';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='AMP';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='AMP-YHBF-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.240',berat_out_asli='4.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.240',berat_akhir_asli =berat_akhir_asli-'4.240' WHERE kode_barang='AMP-YHBF-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0001','3','AMR-YHBF-5-0','1','2.600','TOKO','AMP');
DELETE FROM tm_barang_export WHERE kode_barang='AMR-YHBF-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='AMR-YHBF-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='AMR-YHBF-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='AMR-YHBF-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='AMR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='AMR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='AMP';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='AMP';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='AMR-YHBF-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.600',berat_out_asli='2.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.600',berat_akhir_asli =berat_akhir_asli-'2.600' WHERE kode_barang='AMR-YHBF-5-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-250827-0001','2025-08-27','2025-08-27','13:20','2.600','input','2025-08-27 13:20:23','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0002','1','CMR-YHBF-2-0','1','2.000','TOKO','CMP');
DELETE FROM tm_barang_export WHERE kode_barang='CMR-YHBF-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMR-YHBF-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CMR-YHBF-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMR-YHBF-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CMR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMP';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMP';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMR-YHBF-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='CMR-YHBF-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-250827-0002','2','CMP-YHBF-7-0','1','5.470','TOKO','CMP');
DELETE FROM tm_barang_export WHERE kode_barang='CMP-YHBF-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMP-YHBF-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CMP-YHBF-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMP-YHBF-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMP';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMP';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMP-YHBF-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.470',berat_out_asli='5.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.470',berat_akhir_asli =berat_akhir_asli-'5.470' WHERE kode_barang='CMP-YHBF-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0002','3','CMP-YHBF-8-0','1','4.540','TOKO','CMP');
DELETE FROM tm_barang_export WHERE kode_barang='CMP-YHBF-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMP-YHBF-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CMP-YHBF-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMP-YHBF-8-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CMP' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMP' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMP';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMP';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMP-YHBF-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.540',berat_out_asli='4.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.540',berat_akhir_asli =berat_akhir_asli-'4.540' WHERE kode_barang='CMP-YHBF-8-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-250827-0002','2025-08-27','2025-08-27','13:20','4.540','input','2025-08-27 13:20:32','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0003','1','GLKR-YHBF-1-0','1','10.640','TOKO','GLK');
DELETE FROM tm_barang_export WHERE kode_barang='GLKR-YHBF-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='GLKR-YHBF-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='GLKR-YHBF-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='GLKR-YHBF-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='GLKR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='GLKR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='GLKR-YHBF-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.640',berat_out_asli='10.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.640',berat_akhir_asli =berat_akhir_asli-'10.640' WHERE kode_barang='GLKR-YHBF-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-250827-0003','2','GLKR-YHBF-6-0','1','11.900','TOKO','GLK');
DELETE FROM tm_barang_export WHERE kode_barang='GLKR-YHBF-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='GLKR-YHBF-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='GLKR-YHBF-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='GLKR-YHBF-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='GLKR' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='GLKR' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLK';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLK';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='GLKR-YHBF-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='11.900',berat_out_asli='11.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.900',berat_akhir_asli =berat_akhir_asli-'11.900' WHERE kode_barang='GLKR-YHBF-6-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-250827-0003','2025-08-27','2025-08-27','13:20','11.900','input','2025-08-27 13:20:40','ELCO');
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-00974';
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-YHBG-1-0','00038307','DP-00974BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','45500','2025-08-27','45500','1.810','100.00','925','350000','25000.00','1','0.14', 'input','2025-08-27 15:10:46','1.810','0','','16500.00','','TOKO','FREETAG','','2','','','PSN00974BIP','1','RS 11','','DP-00974');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YHBG-1-0','00038307');
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-08-27','PSPRT-YHBG-1-0','PSPRT','TOKO','PSNB','100.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-00974BIP ');
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-00975';
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-YHBG-2-0','00038308','DP-00975BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','77500','2025-08-27','77500','3.100','100.00','925','350000','25000.00','1','0.14', 'input','2025-08-27 15:12:54','3.100','0','','16500.00','','TOKO','FREETAG','','2','','','PSN00975BIP','1','RS 20','','DP-00975');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YHBG-2-0','00038308');
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-08-27','PSPRT-YHBG-2-0','PSPRT','TOKO','PSNB','100.00','3.100','3.100','1','3.100','3.100','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-00975BIP ');
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-00978';
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-YHBG-3-0','00038309','DP-00978BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','252000','2025-08-27','252000','2.050','7.00','10','300000','1755000.00','1','0.14', 'input','2025-08-27 15:14:53','2.050','0','','16500.00','','TOKO','FREETAG','','10','','','PSN00978BIP','1','RS 14','','DP-00978');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YHBG-3-0','00038309');
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-08-27','PSPLT-YHBG-3-0','PSPLT','TOKO','PSNB','7.00','2.050','2.050','1','2.050','2.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-00978BIP ');
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1810500',harga_beli ='1810500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3667000',harga_beli ='3667000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='143000',harga_beli ='143000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2074500',harga_beli ='2074500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4593000',harga_beli ='4593000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1720500',harga_beli ='1720500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1676000',harga_beli ='1676000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3994500',harga_beli ='3994500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='14751000',harga_beli ='14751000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2052500',harga_beli ='2052500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2034000',harga_beli ='2034000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1922000',harga_beli ='1922000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1996500',harga_beli ='1996500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1978000',harga_beli ='1978000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5551500',harga_beli ='5551500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2125500',harga_beli ='2125500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='7614000',harga_beli ='7614000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2746500',harga_beli ='2746500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3228500',harga_beli ='3228500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3316500',harga_beli ='3316500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3900500',harga_beli ='3900500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3155500',harga_beli ='3155500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4514000',harga_beli ='4514000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5390500',harga_beli ='5390500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='6501000',harga_beli ='6501000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5259000',harga_beli ='5259000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1096000',harga_beli ='1096000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2031000',harga_beli ='2031000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3097000',harga_beli ='3097000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2805000',harga_beli ='2805000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1607000',harga_beli ='1607000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1548500',harga_beli ='1548500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4748000',harga_beli ='4748000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5697500',harga_beli ='5697500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2542000',harga_beli ='2542000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5040000',harga_beli ='5040000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4003000',harga_beli ='4003000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1943000',harga_beli ='1943000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1651000',harga_beli ='1651000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3754500',harga_beli ='3754500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2629500',harga_beli ='2629500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3898000',harga_beli ='3898000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5025500',harga_beli ='5025500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='7611000',harga_beli ='7611000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='6866000',harga_beli ='6866000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2513000',harga_beli ='2513000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3915000',harga_beli ='3915000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5463500',harga_beli ='5463500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4981500',harga_beli ='4981500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5127500',harga_beli ='5127500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5887500',harga_beli ='5887500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='11745000',harga_beli ='11745000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1198000',harga_beli ='1198000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1198000',harga_beli ='1198000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1139500',harga_beli ='1139500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='1096000',harga_beli ='1096000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3623000',harga_beli ='3623000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='6223500',harga_beli ='6223500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='7114500',harga_beli ='7114500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='6048000',harga_beli ='6048000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5668000',harga_beli ='5668000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='6208500',harga_beli ='6208500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5536500',harga_beli ='5536500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='39632000',harga_beli ='39632000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='6165000',harga_beli ='6165000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5697500',harga_beli ='5697500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4222000',harga_beli ='4222000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='8107500',harga_beli ='8107500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='9408500',harga_beli ='9408500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='5405000',harga_beli ='5405000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4368000',harga_beli ='4368000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4791500',harga_beli ='4791500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3754500',harga_beli ='3754500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','1760000','input','2025-08-27 15:33:23');
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='12342000',harga_beli ='12342000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='7241000',harga_beli ='7241000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3815000',harga_beli ='3815000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3845000',harga_beli ='3845000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4462000',harga_beli ='4462000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='3386500',harga_beli ='3386500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='8411500',harga_beli ='8411500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2582000',harga_beli ='2582000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='9680500',harga_beli ='9680500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='4602000',harga_beli ='4602000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','1760000','input','2025-08-27 15:33:30');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','1760000','input','2025-08-27 15:33:34');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','1760000','input','2025-08-27 15:33:37');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','1760000','input','2025-08-27 15:33:41');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','1760000','input','2025-08-27 15:33:44');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','1760000','input','2025-08-27 15:33:48');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','1760000','input','2025-08-27 15:33:52');
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','1760000','input','2025-08-27 15:33:55');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','1760000','input','2025-08-27 15:34:00');
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','1760000','input','2025-08-27 15:34:03');
UPDATE tm_barang SET harga_skrg ='1760000',harga_jual='253000',harga_beli ='253000' WHERE kode_barcode='00038309' LIMIT 1;
UPDATE tm_group SET harga='1760000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','1760000','input','2025-08-27 15:34:07');
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 ('LMT10-YHBG-4-0','00038310','LMT10-110% ','LOGAM MULIA THIFA 10 GR ','','GR','---','GOLD','LMT10','TOKO','LMT','19360500','2025-08-27','19360500','10.000','110.00','9999','0','1760000.00','1','0.14', 'input','2025-08-27 15:47:40','10.000','0','','16500.00','','TOKO','FREETAG','','0','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT10','LMT10-YHBG-4-0','00038310');
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-08-27','LMT10-YHBG-4-0','LMT10','TOKO','LMT','110.00','10.000','10.000','1','10.000','10.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT10';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT10','LMT10-110% ');
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 ('LMT10-YHBG-5-0','00038311','LMT10-110% ','LOGAM MULIA THIFA 10 GR ','','GR','---','GOLD','LMT10','TOKO','LMT','19360500','2025-08-27','19360500','10.000','110.00','9999','0','1760000.00','1','0.14', 'input','2025-08-27 15:48:04','10.000','0','','16500.00','','TOKO','FREETAG','','0','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT10','LMT10-YHBG-5-0','00038311');
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-08-27','LMT10-YHBG-5-0','LMT10','TOKO','LMT','110.00','10.000','10.000','1','10.000','10.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT10';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT10','LMT10-110% ');
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 ('LMT10-YHBG-6-0','00038312','LMT10-110% ','LOGAM MULIA THIFA 10 GR ','','GR','---','GOLD','LMT10','TOKO','LMT','19360500','2025-08-27','19360500','10.000','110.00','9999','0','1760000.00','1','0.14', 'input','2025-08-27 15:48:26','10.000','0','','16500.00','','TOKO','FREETAG','','0','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT10','LMT10-YHBG-6-0','00038312');
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-08-27','LMT10-YHBG-6-0','LMT10','TOKO','LMT','110.00','10.000','10.000','1','10.000','10.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT10';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT10','LMT10-110% ');