INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-10 ','08:03:07');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-09';
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-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-09';
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-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-09' 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-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-10 ','08:04:24');
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-01182';
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-YJAX-1-0','00039147','DP-01182MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','318000','2025-10-10','318000','2.520','6.00','10','300000','2100000.00','1','0.14', 'input','2025-10-10 08:17:44','2.520','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01182MM','1','RS 12','','DP-01182');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJAX-1-0','00039147');
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-10','PSPLT-YJAX-1-0','PSPLT','TOKO','MMPSN','6.00','2.520','2.520','1','2.520','2.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01182MM ');
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-01186';
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-YJAX-2-0','00039148','DP-01186MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','593500','2025-10-10','593500','4.710','6.00','10','300000','2100000.00','1','0.14', 'input','2025-10-10 08:19:01','4.710','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01186MM','1','RS 19','','DP-01186');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJAX-2-0','00039148');
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-10','PSPLT-YJAX-2-0','PSPLT','TOKO','MMPSN','6.00','4.710','4.710','1','4.710','4.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01186MM ');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251010-0001','1','PSBRE-YJXH-47-0','1','4.920','4.920','TOKO','SEM-PSN','TOKO','PSN');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSN' WHERE kode_barang='PSBRE-YJXH-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-10-10','TOKO','PSN','PSBRE','PSBRE-YJXH-47-0','83.00','1','4.920','4.920','1','4.920','4.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.920',berat_out_asli=berat_out_asli+'4.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-10' AND kode_barang='PSBRE-YJXH-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251010-0001','2025-10-10','2025-10-10','08:21','4.92','input','2025-10-10 08:21:59');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0001','1','PSBRE-YJXH-47-0','1','4.920','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSBRE-YJXH-47-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBRE-YJXH-47-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSBRE-YJXH-47-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBRE-YJXH-47-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBRE-YJXH-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.920',berat_out_asli='4.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.920',berat_akhir_asli =berat_akhir_asli-'4.920' WHERE kode_barang='PSBRE-YJXH-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0001','2','PSPLE-YJXI-7-0','1','4.620','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-YJXI-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLE-YJXI-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLE-YJXI-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLE-YJXI-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLE-YJXI-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.620',berat_out_asli='4.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.620',berat_akhir_asli =berat_akhir_asli-'4.620' WHERE kode_barang='PSPLE-YJXI-7-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-251010-0001','2025-10-10','2025-10-10','08:22','4.620','input','2025-10-10 08:22:19','ELCO');
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2170500',harga_beli ='2170500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4396000',harga_beli ='4396000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='171000',harga_beli ='171000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2487000',harga_beli ='2487000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5506500',harga_beli ='5506500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2063000',harga_beli ='2063000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1973000',harga_beli ='1973000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2009000',harga_beli ='2009000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4789000',harga_beli ='4789000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='17684000',harga_beli ='17684000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2460500',harga_beli ='2460500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2438000',harga_beli ='2438000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2304000',harga_beli ='2304000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2393500',harga_beli ='2393500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2371000',harga_beli ='2371000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6655000',harga_beli ='6655000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2548000',harga_beli ='2548000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='9128000',harga_beli ='9128000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3292500',harga_beli ='3292500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3870500',harga_beli ='3870500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3975500',harga_beli ='3975500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4676000',harga_beli ='4676000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5412000',harga_beli ='5412000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6462500',harga_beli ='6462500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='7793500',harga_beli ='7793500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6305000',harga_beli ='6305000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1314000',harga_beli ='1314000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2434500',harga_beli ='2434500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3363000',harga_beli ='3363000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1926500',harga_beli ='1926500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1856500',harga_beli ='1856500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5692000',harga_beli ='5692000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6830500',harga_beli ='6830500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3047500',harga_beli ='3047500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6042500',harga_beli ='6042500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4799000',harga_beli ='4799000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='2329500',harga_beli ='2329500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1979000',harga_beli ='1979000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4501000',harga_beli ='4501000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3152500',harga_beli ='3152500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4673000',harga_beli ='4673000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6024500',harga_beli ='6024500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='9124500',harga_beli ='9124500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8231500',harga_beli ='8231500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3012500',harga_beli ='3012500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4694000',harga_beli ='4694000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6550000',harga_beli ='6550000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5972000',harga_beli ='5972000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6147500',harga_beli ='6147500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='7058000',harga_beli ='7058000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='14080500',harga_beli ='14080500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1436500',harga_beli ='1436500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1436500',harga_beli ='1436500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1366500',harga_beli ='1366500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='1314000',harga_beli ='1314000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4343500',harga_beli ='4343500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='7461000',harga_beli ='7461000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8529000',harga_beli ='8529000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='7250500',harga_beli ='7250500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6795500',harga_beli ='6795500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='7443500',harga_beli ='7443500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6637500',harga_beli ='6637500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3958000',harga_beli ='3958000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='47513000',harga_beli ='47513000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='7391000',harga_beli ='7391000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6830500',harga_beli ='6830500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5061500',harga_beli ='5061500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='9720000',harga_beli ='9720000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='11279500',harga_beli ='11279500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='6480000',harga_beli ='6480000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5236500',harga_beli ='5236500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5744500',harga_beli ='5744500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4501000',harga_beli ='4501000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2110000','input','2025-10-10 08:37:30');
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='14796500',harga_beli ='14796500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='8681000',harga_beli ='8681000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4573500',harga_beli ='4573500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4609500',harga_beli ='4609500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='4060000',harga_beli ='4060000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='10084000',harga_beli ='10084000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3095000',harga_beli ='3095000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='11605000',harga_beli ='11605000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='5517000',harga_beli ='5517000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2110000','input','2025-10-10 08:37:37');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2110000','input','2025-10-10 08:37:49');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2110000','input','2025-10-10 08:37:53');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2110000','input','2025-10-10 08:37:57');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2110000','input','2025-10-10 08:38:00');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2110000','input','2025-10-10 08:38:04');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2110000','input','2025-10-10 08:38:07');
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='3187500',harga_beli ='3187500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2110000','input','2025-10-10 08:38:11');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2110000','input','2025-10-10 08:38:15');
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2110000','input','2025-10-10 08:38:19');
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='256000',harga_beli ='256000' WHERE kode_barcode='00039141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='485000',harga_beli ='485000' WHERE kode_barcode='00039143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='871500',harga_beli ='871500' WHERE kode_barcode='00039145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='319500',harga_beli ='319500' WHERE kode_barcode='00039147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2110000',harga_jual='596500',harga_beli ='596500' WHERE kode_barcode='00039148' LIMIT 1;
UPDATE tm_group SET harga='2110000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2110000','input','2025-10-10 08:38:23');
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 ('LGM10-YJAX-3-0','00039149','LGM10-105% ','LM ANTAM 10 GR G75394409 ','','GR','---','GOLD','LGM10','TOKO','LM','22155000','2025-10-10','22155000','10.000','105.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:39:46','10.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM10','LGM10-YJAX-3-0','00039149');
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-10','LGM10-YJAX-3-0','LGM10','TOKO','LM','105.00','10.000','10.000','1','10.000','10.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM10';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM10','LGM10-105% ');
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 ('LGM10-YJAX-4-0','00039150','LGM10-105% ','LM ANTAM 10 GR G75394465 ','','GR','---','GOLD','LGM10','TOKO','LM','22155000','2025-10-10','22155000','10.000','105.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:40:21','10.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM10','LGM10-YJAX-4-0','00039150');
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-10','LGM10-YJAX-4-0','LGM10','TOKO','LM','105.00','10.000','10.000','1','10.000','10.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM10';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM10','LGM10-105% ');
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 ('LGM10-YJAX-5-0','00039151','LGM10-105% ','LM ANTAM 10 GR G75394410 ','','GR','---','GOLD','LGM10','TOKO','LM','22155000','2025-10-10','22155000','10.000','105.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:40:47','10.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM10','LGM10-YJAX-5-0','00039151');
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-10','LGM10-YJAX-5-0','LGM10','TOKO','LM','105.00','10.000','10.000','1','10.000','10.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM10';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM10','LGM10-105% ');
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-YJAX-6-0','00039152','LMT10-105% ','LM ANTAM 10 GR G75394438 ','','GR','---','GOLD','LMT10','TOKO','LMT','22155000','2025-10-10','22155000','10.000','105.00','9999','0','2110000.00','1','0.14', 'input','2025-10-10 08:41:40','10.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT10','LMT10-YJAX-6-0','00039152');
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-10','LMT10-YJAX-6-0','LMT10','TOKO','LMT','105.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-105% ');
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-YJAX-7-0','00039153','LMT10-105% ','LM ANTAM 10 GR G75394437 ','','GR','---','GOLD','LMT10','TOKO','LMT','22155000','2025-10-10','22155000','10.000','105.00','9999','0','2110000.00','1','0.14', 'input','2025-10-10 08:42:21','10.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT10' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT10','LMT10-YJAX-7-0','00039153');
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-10','LMT10-YJAX-7-0','LMT10','TOKO','LMT','105.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-105% ');
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 ('LGM5-YJAX-8-0','00039154','LGM5-110% ','LM ANTAM 5 GR H75353606 ','','GR','---','GOLD','LGM5','TOKO','LM','11605000','2025-10-10','11605000','5.000','110.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:43:42','5.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-YJAX-8-0','00039154');
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-10','LGM5-YJAX-8-0','LGM5','TOKO','LM','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-110% ');
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 ('LGM5-YJAX-9-0','00039155','LGM5-110% ','LM ANTAM 5 GR H75353580 ','','GR','---','GOLD','LGM5','TOKO','LM','11605000','2025-10-10','11605000','5.000','110.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:44:09','5.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-YJAX-9-0','00039155');
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-10','LGM5-YJAX-9-0','LGM5','TOKO','LM','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-110% ');
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 ('LGM5-YJAX-10-0','00039156','LGM5-110% ','LM ANTAM 5 GR H75353579 ','','GR','---','GOLD','LGM5','TOKO','LM','11605000','2025-10-10','11605000','5.000','110.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:44:37','5.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-YJAX-10-0','00039156');
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-10','LGM5-YJAX-10-0','LGM5','TOKO','LM','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-110% ');
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 ('LGM5-YJAX-11-0','00039157','LGM5-110% ','LM ANTAM 5 GR H75353578 ','','GR','---','GOLD','LGM5','TOKO','LM','11605000','2025-10-10','11605000','5.000','110.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:45:05','5.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-YJAX-11-0','00039157');
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-10','LGM5-YJAX-11-0','LGM5','TOKO','LM','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-110% ');
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 ('LGM5-YJAX-12-0','00039158','LGM5-110% ','LM ANTAM 5 GR H75353607 ','','GR','---','GOLD','LGM5','TOKO','LM','11605000','2025-10-10','11605000','5.000','110.00','9999','0','2110000.00','1','0.04', 'input','2025-10-10 08:45:28','5.000','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM5','LGM5-YJAX-12-0','00039158');
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-10','LGM5-YJAX-12-0','LGM5','TOKO','LM','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM5','LGM5-110% ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0002','1','LGM10-YJAX-3-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-YJAX-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-YJAX-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-YJAX-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-YJAX-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-YJAX-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-YJAX-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-251010-0002','2','LGM10-YJAX-4-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-YJAX-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-YJAX-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-YJAX-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-YJAX-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-YJAX-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-YJAX-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-251010-0002','3','LGM10-YJAX-5-0','1','10.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM10-YJAX-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM10-YJAX-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM10-YJAX-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM10-YJAX-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='LGM10' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM10' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM10-YJAX-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LGM10-YJAX-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0002','4','LGM5-YJAX-8-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-YJAX-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-YJAX-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-YJAX-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-YJAX-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-YJAX-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-YJAX-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0002','5','LGM5-YJAX-9-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-YJAX-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-YJAX-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-YJAX-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-YJAX-9-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-YJAX-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-YJAX-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0002','6','LGM5-YJAX-10-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-YJAX-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-YJAX-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-YJAX-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-YJAX-10-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-YJAX-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-YJAX-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0002','7','LGM5-YJAX-11-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-YJAX-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-YJAX-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-YJAX-11-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-YJAX-11-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-YJAX-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-YJAX-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0002','8','LGM5-YJAX-12-0','1','5.000','TOKO','LM');
DELETE FROM tm_barang_export WHERE kode_barang='LGM5-YJAX-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LGM5-YJAX-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LGM5-YJAX-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LGM5-YJAX-12-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='LGM5' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LGM5' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='LM';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LM';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LGM5-YJAX-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LGM5-YJAX-12-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-251010-0002','2025-10-10','2025-10-10','08:54','5.000','input','2025-10-10 08:54:01','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0003','1','LMT10-YJAX-6-0','1','10.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT10-YJAX-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT10-YJAX-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT10-YJAX-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT10-YJAX-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT10' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT10' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT10-YJAX-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LMT10-YJAX-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0003','2','LMT10-YJAX-7-0','1','10.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT10-YJAX-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT10-YJAX-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT10-YJAX-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT10-YJAX-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT10' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT10' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT10-YJAX-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.000',berat_out_asli='10.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.000',berat_akhir_asli =berat_akhir_asli-'10.000' WHERE kode_barang='LMT10-YJAX-7-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-251010-0003','2025-10-10','2025-10-10','08:54','10.000','input','2025-10-10 08:54:14','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-10 ','09:16:15');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-10 ','10:22:24');
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-01155';
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-YJAX-13-0','00039159','DP-01155BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','51000','2025-10-10','51000','2.030','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-10 11:28:43','2.030','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01155BIP','1','RS 24','','DP-01155');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-13-0','00039159');
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-10','PSPRT-YJAX-13-0','PSPRT','TOKO','PSNB','100.00','2.030','2.030','1','2.030','2.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01155BIP ');
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-01162';
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-YJAX-14-0','00039160','DP-01162BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','123000','2025-10-10','123000','4.910','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-10 11:30:19','4.910','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01162BIP','1','RS 20','','DP-01162');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-14-0','00039160');
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-10','PSPRT-YJAX-14-0','PSPRT','TOKO','PSNB','100.00','4.910','4.910','1','4.910','4.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01162BIP ');
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-01191';
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-YJAX-15-0','00039161','DP-01191BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','638500','2025-10-10','638500','5.040','6.00','10','300000','2110000.00','1','0.14', 'input','2025-10-10 11:31:49','5.040','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01191BIP','1','RS 24 5','','DP-01191');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJAX-15-0','00039161');
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-10','PSPLT-YJAX-15-0','PSPLT','TOKO','PSNB','6.00','5.040','5.040','1','5.040','5.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01191BIP ');
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-01214';
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-YJAX-16-0','00039162','DP-01214BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','652500','2025-10-10','652500','5.150','6.00','10','300000','2110000.00','1','0.14', 'input','2025-10-10 11:33:19','5.150','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01214BIP','1','RS 24 5','','DP-01214');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJAX-16-0','00039162');
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-10','PSPLT-YJAX-16-0','PSPLT','TOKO','PSNB','6.00','5.150','5.150','1','5.150','5.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01214BIP ');
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 ('BDCM-YJAX-17-0','00039163','700K-125 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','4116000','2025-10-10','4116000','2.350','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:03:12','2.350','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-17-0','00039163');
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-10','BDCM-YJAX-17-0','BDCM','TOKO','CMBD','83.00','2.350','2.350','1','2.350','2.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','700K-125 ');
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 ('BDCM-YJAX-18-0','00039164','700K-12 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','3485500','2025-10-10','3485500','1.990','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:04:03','1.990','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-18-0','00039164');
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-10','BDCM-YJAX-18-0','BDCM','TOKO','CMBD','83.00','1.990','1.990','1','1.990','1.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','700K-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 ('BDCM-YJAX-19-0','00039165','700K-115 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','2697500','2025-10-10','2697500','1.540','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:04:39','1.540','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-19-0','00039165');
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-10','BDCM-YJAX-19-0','BDCM','TOKO','CMBD','83.00','1.540','1.540','1','1.540','1.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','700K-115 ');
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 ('BDCM-YJAX-20-0','00039166','800K-11 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','3608000','2025-10-10','3608000','2.060','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:15:44','2.060','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-20-0','00039166');
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-10','BDCM-YJAX-20-0','BDCM','TOKO','CMBD','83.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','800K-11 ');
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 ('BDCM-YJAX-21-0','00039167','850K-13 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','3310000','2025-10-10','3310000','1.890','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:16:26','1.890','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-21-0','00039167');
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-10','BDCM-YJAX-21-0','BDCM','TOKO','CMBD','83.00','1.890','1.890','1','1.890','1.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','850K-13 ');
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 ('BDCM-YJAX-22-0','00039168','950K-115 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','3152500','2025-10-10','3152500','1.800','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:17:05','1.800','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-22-0','00039168');
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-10','BDCM-YJAX-22-0','BDCM','TOKO','CMBD','83.00','1.800','1.800','1','1.800','1.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','950K-115 ');
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 ('BDCM-YJAX-23-0','00039169','850K-115 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','2942500','2025-10-10','2942500','1.680','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:17:41','1.680','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-23-0','00039169');
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-10','BDCM-YJAX-23-0','BDCM','TOKO','CMBD','83.00','1.680','1.680','1','1.680','1.680','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','850K-115 ');
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 ('BDCM-YJAX-24-0','00039170','850K-13 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','2715000','2025-10-10','2715000','1.550','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:18:30','1.550','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-24-0','00039170');
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-10','BDCM-YJAX-24-0','BDCM','TOKO','CMBD','83.00','1.550','1.550','1','1.550','1.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','850K-13 ');
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 ('BDCM-YJAX-25-0','00039171','850K-125 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','2662500','2025-10-10','2662500','1.520','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:19:05','1.520','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-25-0','00039171');
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-10','BDCM-YJAX-25-0','BDCM','TOKO','CMBD','83.00','1.520','1.520','1','1.520','1.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','850K-125 ');
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 ('BDCM-YJAX-26-0','00039172','1.0K-95 ','BANDUNG CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','1629000','2025-10-10','1629000','0.930','83.00','75','100000','2110000.00','1','0.14', 'input','2025-10-10 14:19:45','0.930','0','','16600.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-YJAX-26-0','00039172');
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-10','BDCM-YJAX-26-0','BDCM','TOKO','CMBD','83.00','0.930','0.930','1','0.930','0.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','1.0K-95 ');
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-01158';
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-YJAX-27-0','00039173','DP-01158BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','82000','2025-10-10','82000','3.280','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-10 14:32:24','3.280','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01158BIP','1','RS 20 5','','DP-01158');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-27-0','00039173');
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-10','PSPRT-YJAX-27-0','PSPRT','TOKO','PSNB','100.00','3.280','3.280','1','3.280','3.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01158BIP ');
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-01188';
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-YJAX-28-0','00039174','DP-01188BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','46000','2025-10-10','46000','1.830','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-10 14:33:52','1.830','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01188BIP','1','RS 16','','DP-01188');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-28-0','00039174');
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-10','PSPRT-YJAX-28-0','PSPRT','TOKO','PSNB','100.00','1.830','1.830','1','1.830','1.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01188BIP ');
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-01136';
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-YJAX-29-0','00039175','DP-01136BIP ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','116500','2025-10-10','116500','4.640','100.00','925','400000','25000.00','1','0.14', 'input','2025-10-10 14:36:12','4.640','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01136BIP','1','RS 9 RS 23','','DP-01136');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-29-0','00039175');
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-10','PSPRT-YJAX-29-0','PSPRT','TOKO','PSNB','100.00','4.640','4.640','1','4.640','4.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01136BIP ');
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-01198';
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-YJAX-30-0','00039176','DP-01198BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','97000','2025-10-10','97000','3.870','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-10 14:37:34','3.870','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01198BIP','1','RS 22','','DP-01198');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-30-0','00039176');
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-10','PSPRT-YJAX-30-0','PSPRT','TOKO','PSNB','100.00','3.870','3.870','1','3.870','3.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01198BIP ');
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-01212';
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-YJAX-31-0','00039177','DP-01212BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','60500','2025-10-10','60500','2.410','100.00','925','350000','25000.00','1','0.14', 'input','2025-10-10 14:58:33','2.410','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01212BIP','1','RS 18','','DP-01212');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJAX-31-0','00039177');
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-10','PSPRT-YJAX-31-0','PSPRT','TOKO','PSNB','100.00','2.410','2.410','1','2.410','2.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01212BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-10 ','15:13:59');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','1','BDCM-YJAX-17-0','1','2.350','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.350',berat_out_asli='2.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.350',berat_akhir_asli =berat_akhir_asli-'2.350' WHERE kode_barang='BDCM-YJAX-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','2','BDCM-YJAX-18-0','1','1.990','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-18-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.990',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.990',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='BDCM-YJAX-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','3','BDCM-YJAX-19-0','1','1.540','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='BDCM-YJAX-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','4','BDCM-YJAX-20-0','1','2.060','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='BDCM-YJAX-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','5','BDCM-YJAX-21-0','1','1.890','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.890',berat_out_asli='1.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.890',berat_akhir_asli =berat_akhir_asli-'1.890' WHERE kode_barang='BDCM-YJAX-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','6','BDCM-YJAX-22-0','1','1.800','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-22-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='BDCM-YJAX-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','7','BDCM-YJAX-23-0','1','1.680','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='BDCM-YJAX-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','8','BDCM-YJAX-24-0','1','1.550','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.550',berat_out_asli='1.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.550',berat_akhir_asli =berat_akhir_asli-'1.550' WHERE kode_barang='BDCM-YJAX-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','9','BDCM-YJAX-25-0','1','1.520','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.520',berat_out_asli='1.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.520',berat_akhir_asli =berat_akhir_asli-'1.520' WHERE kode_barang='BDCM-YJAX-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0004','10','BDCM-YJAX-26-0','1','0.930','TOKO','CMBD');
DELETE FROM tm_barang_export WHERE kode_barang='BDCM-YJAX-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-YJAX-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-YJAX-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-YJAX-26-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-YJAX-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.930',berat_out_asli='0.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.930',berat_akhir_asli =berat_akhir_asli-'0.930' WHERE kode_barang='BDCM-YJAX-26-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-251010-0004','2025-10-10','2025-10-10','15:17','0.930','input','2025-10-10 15:17:50','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','1','PSPLT-YJXI-2-0','1','2.020','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJXI-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YJXI-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YJXI-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YJXI-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' 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='PSPLT-YJXI-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='PSPLT-YJXI-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-251010-0005','2','PSPRT-YJXI-3-0','1','3.360','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJXI-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJXI-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJXI-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJXI-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-YJXI-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.360',berat_out_asli='3.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.360',berat_akhir_asli =berat_akhir_asli-'3.360' WHERE kode_barang='PSPRT-YJXI-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-251010-0005','3','PSPLT-YJXI-4-0','1','3.830','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJXI-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YJXI-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YJXI-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YJXI-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' 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='PSPLT-YJXI-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.830',berat_out_asli='3.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.830',berat_akhir_asli =berat_akhir_asli-'3.830' WHERE kode_barang='PSPLT-YJXI-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-251010-0005','4','PSPRT-YJXI-5-0','1','3.060','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJXI-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJXI-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJXI-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJXI-5-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-YJXI-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.060',berat_out_asli='3.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.060',berat_akhir_asli =berat_akhir_asli-'3.060' WHERE kode_barang='PSPRT-YJXI-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','5','PSPLT-YJXI-6-0','1','2.950','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJXI-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YJXI-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YJXI-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YJXI-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' 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='PSPLT-YJXI-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='PSPLT-YJXI-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','6','PSPRT-YJAX-13-0','1','2.030','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-13-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-YJAX-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='PSPRT-YJAX-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','7','PSPRT-YJAX-14-0','1','4.910','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-14-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-YJAX-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.910',berat_out_asli='4.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.910',berat_akhir_asli =berat_akhir_asli-'4.910' WHERE kode_barang='PSPRT-YJAX-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','8','PSPLT-YJAX-15-0','1','5.040','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJAX-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YJAX-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YJAX-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YJAX-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' 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='PSPLT-YJAX-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.040',berat_out_asli='5.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.040',berat_akhir_asli =berat_akhir_asli-'5.040' WHERE kode_barang='PSPLT-YJAX-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','9','PSPLT-YJAX-16-0','1','5.150','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJAX-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YJAX-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YJAX-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YJAX-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' 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='PSPLT-YJAX-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.150',berat_out_asli='5.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.150',berat_akhir_asli =berat_akhir_asli-'5.150' WHERE kode_barang='PSPLT-YJAX-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','10','PSPRT-YJAX-27-0','1','3.280','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-27-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-YJAX-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.280',berat_out_asli='3.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.280',berat_akhir_asli =berat_akhir_asli-'3.280' WHERE kode_barang='PSPRT-YJAX-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','11','PSPRT-YJAX-28-0','1','1.830','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-28-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-YJAX-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.830',berat_out_asli='1.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.830',berat_akhir_asli =berat_akhir_asli-'1.830' WHERE kode_barang='PSPRT-YJAX-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','12','PSPRT-YJAX-29-0','1','4.640','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-29-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-29-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-YJAX-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.640',berat_out_asli='4.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.640',berat_akhir_asli =berat_akhir_asli-'4.640' WHERE kode_barang='PSPRT-YJAX-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','13','PSPRT-YJAX-30-0','1','3.870','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-30-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-YJAX-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.870',berat_out_asli='3.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.870',berat_akhir_asli =berat_akhir_asli-'3.870' WHERE kode_barang='PSPRT-YJAX-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251010-0005','14','PSPRT-YJAX-31-0','1','2.410','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJAX-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YJAX-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YJAX-31-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YJAX-31-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-YJAX-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.410',berat_out_asli='2.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.410',berat_akhir_asli =berat_akhir_asli-'2.410' WHERE kode_barang='PSPRT-YJAX-31-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-251010-0005','2025-10-10','2025-10-10','15:18','2.410','input','2025-10-10 15:18:04','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-10 ','15:47:58');