INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-18 ','08:05:01');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-17';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-11-18';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-18 ','08:13:04');
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-01371';
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-YKAH-1-0','00039653','DP-01371MM ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','187000','2025-11-18','187000','3.110','100.00','925','400000','60000.00','1','0.14', 'input','2025-11-18 08:20:55','3.110','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01371MM','1','RS 11 RS 18','','DP-01371');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YKAH-1-0','00039653');
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-11-18','PSPRT-YKAH-1-0','PSPRT','TOKO','MMPSN','100.00','3.110','3.110','1','3.110','3.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01371MM ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02902';
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 ('PSPRE-YKAH-2-0','00039654','DP-02902 ','1PS CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','187500','2025-11-18','187500','3.120','100.00','925','400000','60000.00','1','0.04', 'input','2025-11-18 08:22:55','3.120','0','','16750.00','','TOKO','FREETAG','','2','','','PSN02902','1','RS 10 5 RS 18','','DP-02902');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-YKAH-2-0','00039654');
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-11-18','PSPRE-YKAH-2-0','PSPRE','TOKO','PSN','100.00','3.120','3.120','1','3.120','3.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-02902 ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251118-0001','1','PSPRE-YKAH-2-0','1','3.120','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-YKAH-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-YKAH-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-YKAH-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-YKAH-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' 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='PSPRE-YKAH-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.120',berat_out_asli='3.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.120',berat_akhir_asli =berat_akhir_asli-'3.120' WHERE kode_barang='PSPRE-YKAH-2-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-251118-0001','2025-11-18','2025-11-18','08:52','3.120','input','2025-11-18 08:52:05','ELCO');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-18 ','09:35:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-18 ','10:51:41');
UPDATE tp_curr SET rp= '16800.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '16800.00', 'input','2025-11-18 11:40:22');
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2263000',harga_beli ='2263000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4583500',harga_beli ='4583500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='178500',harga_beli ='178500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2593000',harga_beli ='2593000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5741000',harga_beli ='5741000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2150500',harga_beli ='2150500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2094500',harga_beli ='2094500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4993000',harga_beli ='4993000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='18438500',harga_beli ='18438500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2565500',harga_beli ='2565500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2542000',harga_beli ='2542000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2402000',harga_beli ='2402000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2472000',harga_beli ='2472000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6939000',harga_beli ='6939000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2656500',harga_beli ='2656500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='9517500',harga_beli ='9517500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3433000',harga_beli ='3433000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4035500',harga_beli ='4035500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4145500',harga_beli ='4145500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4875500',harga_beli ='4875500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3944500',harga_beli ='3944500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5642500',harga_beli ='5642500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6738000',harga_beli ='6738000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='8126000',harga_beli ='8126000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6574000',harga_beli ='6574000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='1369500',harga_beli ='1369500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2538500',harga_beli ='2538500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3871500',harga_beli ='3871500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3506000',harga_beli ='3506000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2009000',harga_beli ='2009000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='1936000',harga_beli ='1936000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5934500',harga_beli ='5934500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7121500',harga_beli ='7121500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3177500',harga_beli ='3177500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6300000',harga_beli ='6300000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5003500',harga_beli ='5003500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2429000',harga_beli ='2429000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='2063500',harga_beli ='2063500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4693000',harga_beli ='4693000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3287000',harga_beli ='3287000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4872000',harga_beli ='4872000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6281500',harga_beli ='6281500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='9513500',harga_beli ='9513500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='8582500',harga_beli ='8582500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3141000',harga_beli ='3141000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4894000',harga_beli ='4894000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6829500',harga_beli ='6829500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6227000',harga_beli ='6227000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6409500',harga_beli ='6409500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7359000',harga_beli ='7359000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='14681500',harga_beli ='14681500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='1497500',harga_beli ='1497500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='1497500',harga_beli ='1497500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='1424500',harga_beli ='1424500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='1369500',harga_beli ='1369500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4529000',harga_beli ='4529000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7779000',harga_beli ='7779000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='8893000',harga_beli ='8893000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7560000',harga_beli ='7560000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7085000',harga_beli ='7085000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7760500',harga_beli ='7760500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6921000',harga_beli ='6921000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4127000',harga_beli ='4127000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='49539500',harga_beli ='49539500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7706000',harga_beli ='7706000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='7121500',harga_beli ='7121500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5277500',harga_beli ='5277500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='10134500',harga_beli ='10134500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='11761000',harga_beli ='11761000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='6756500',harga_beli ='6756500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5460000',harga_beli ='5460000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5989500',harga_beli ='5989500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4693000',harga_beli ='4693000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2200000','input','2025-11-18 11:40:34');
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='15427500',harga_beli ='15427500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='9051000',harga_beli ='9051000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4768500',harga_beli ='4768500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4806000',harga_beli ='4806000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5577000',harga_beli ='5577000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='4233500',harga_beli ='4233500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='10514000',harga_beli ='10514000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3227000',harga_beli ='3227000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='12100000',harga_beli ='12100000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2200000','input','2025-11-18 11:40:41');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2200000','input','2025-11-18 11:40:45');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2200000','input','2025-11-18 11:40:48');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2200000','input','2025-11-18 11:40:52');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2200000','input','2025-11-18 11:40:57');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2200000','input','2025-11-18 11:41:01');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2200000','input','2025-11-18 11:41:05');
UPDATE tm_barang SET harga_skrg ='2200000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2200000','input','2025-11-18 11:41:09');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2200000','input','2025-11-18 11:41:13');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2200000','input','2025-11-18 11:41:17');
UPDATE tm_group SET harga='2200000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2200000','input','2025-11-18 11:41:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-18 ','14:10:28');
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-01308';
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-YKAH-3-0','00039655','DP-01308BIP ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','194500','2025-11-18','194500','3.240','100.00','925','400000','60000.00','1','0.14', 'input','2025-11-18 16:13:21','3.240','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01308BIP','1','RS 14 RS 22','','DP-01308');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YKAH-3-0','00039655');
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-11-18','PSPRT-YKAH-3-0','PSPRT','TOKO','PSNB','100.00','3.240','3.240','1','3.240','3.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01308BIP ');
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-01311';
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-YKAH-4-0','00039656','DP-01311BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','290500','2025-11-18','290500','2.640','5.00','10','300000','2200000.00','1','0.14', 'input','2025-11-18 16:14:49','2.640','0','','16800.00','','TOKO','FREETAG','','10','','','PSN01311BIP','1','RS 20','','DP-01311');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YKAH-4-0','00039656');
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-11-18','PSPLT-YKAH-4-0','PSPLT','TOKO','PSNB','5.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01311BIP ');
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-01370';
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-YKAH-5-0','00039657','DP-01370BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','356500','2025-11-18','356500','5.940','100.00','925','350000','60000.00','1','0.14', 'input','2025-11-18 16:16:28','5.940','0','','16800.00','','TOKO','FREETAG','','2','','','','1','RS 28 5','','DP-01370');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YKAH-5-0','00039657');
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-11-18','PSPRT-YKAH-5-0','PSPRT','TOKO','PSNB','100.00','5.940','5.940','1','5.940','5.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01370BIP ');
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-01369';
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 ('PSGT-YKAH-6-0','00039658','DP-01369BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','4821000','2025-11-18','4821000','2.640','83.00','75','300000','2200000.00','1','0.14', 'input','2025-11-18 16:18:18','2.640','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01369BIP','1','RS 11','','DP-01369');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YKAH-6-0','00039658');
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-11-18','PSGT-YKAH-6-0','PSGT','TOKO','PSNB','83.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01369BIP ');
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-01336';
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-YKAH-7-0','00039659','DP-01336MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','188500','2025-11-18','188500','1.710','5.00','10','300000','2200000.00','1','0.14', 'input','2025-11-18 16:23:17','1.710','0','','16800.00','','TOKO','FREETAG','','10','','','PSN01336MM','1','RS 13','','DP-01336');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YKAH-7-0','00039659');
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-11-18','PSPLT-YKAH-7-0','PSPLT','TOKO','MMPSN','5.00','1.710','1.710','1','1.710','1.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01336MM ');
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-01320';
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-YKAH-8-0','00039660','DP-01320BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','324500','2025-11-18','324500','2.950','5.00','10','300000','2200000.00','1','0.14', 'input','2025-11-18 16:37:08','2.950','0','','16800.00','','TOKO','FREETAG','','10','','','PSN01320BIP','1','RS 31','','DP-01320');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YKAH-8-0','00039660');
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-11-18','PSPLT-YKAH-8-0','PSPLT','TOKO','PSNB','5.00','2.950','2.950','1','2.950','2.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01320BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251118-0002','1','PSPRT-YKAG-1-0','1','1.440','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAG-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAG-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAG-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAG-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YKAG-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.440',berat_out_asli='1.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.440',berat_akhir_asli =berat_akhir_asli-'1.440' WHERE kode_barang='PSPRT-YKAG-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251118-0002','2','PSPRT-YKAG-2-0','1','2.300','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAG-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAG-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAG-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAG-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YKAG-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='PSPRT-YKAG-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-251118-0002','3','PSPRT-YKAG-3-0','1','1.450','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAG-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAG-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAG-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAG-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-YKAG-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.450',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.450',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='PSPRT-YKAG-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-251118-0002','4','PSPRT-YKAG-4-0','1','2.270','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAG-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAG-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAG-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAG-4-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-YKAG-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.270' WHERE kode_barang='PSPRT-YKAG-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-251118-0002','5','PSPRT-YKAG-5-0','1','3.160','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAG-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAG-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAG-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAG-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-YKAG-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='PSPRT-YKAG-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-251118-0002','6','PSPRT-YKAG-6-0','1','7.860','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAG-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAG-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAG-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAG-6-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-YKAG-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.860',berat_out_asli='7.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.860',berat_akhir_asli =berat_akhir_asli-'7.860' WHERE kode_barang='PSPRT-YKAG-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-251118-0002','7','PSPRT-YKAH-3-0','1','3.240','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAH-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAH-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAH-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAH-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-YKAH-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.240',berat_out_asli='3.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.240',berat_akhir_asli =berat_akhir_asli-'3.240' WHERE kode_barang='PSPRT-YKAH-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-251118-0002','8','PSPLT-YKAH-4-0','1','2.640','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKAH-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YKAH-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YKAH-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YKAH-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-YKAH-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.640' WHERE kode_barang='PSPLT-YKAH-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-251118-0002','9','PSPRT-YKAH-5-0','1','5.940','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKAH-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YKAH-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YKAH-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YKAH-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-YKAH-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.940',berat_out_asli='5.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.940',berat_akhir_asli =berat_akhir_asli-'5.940' WHERE kode_barang='PSPRT-YKAH-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-251118-0002','10','PSGT-YKAH-6-0','1','2.640','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YKAH-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-YKAH-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-YKAH-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-YKAH-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' 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='PSGT-YKAH-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.640' WHERE kode_barang='PSGT-YKAH-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-251118-0002','11','PSPLT-YKAH-8-0','1','2.950','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKAH-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YKAH-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YKAH-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YKAH-8-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-YKAH-8-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-YKAH-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251118-0002','2025-11-18','2025-11-18','16:38','2.950','input','2025-11-18 16:38:36','THIFA');