INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','08:08:55');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-07';
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-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-07';
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-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-07' 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-08';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','08:12:18');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-08';
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-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-08';
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-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-08' 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-09';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','08:13:54');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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-11-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-09';
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-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-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-11-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','08:14:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','08:27:07');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01289';
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-YKAX-1-0','00039525','DP-01289BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','323500','2025-11-10','323500','2.530','6.00','10','300000','2130000.00','1','0.14', 'input','2025-11-10 09:47:59','2.530','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01289BIP','1','RS 15','','DP-01289');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YKAX-1-0','00039525');
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-10','PSPLT-YKAX-1-0','PSPLT','TOKO','PSNB','6.00','2.530','2.530','1','2.530','2.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01289BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','09:50:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-11-10 ','09:55:02');
UPDATE tp_curr SET rp= '16750.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '16750.00', 'input','2025-11-10 10:52:42');
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2218500',harga_beli ='2218500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4494000',harga_beli ='4494000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='175000',harga_beli ='175000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2542500',harga_beli ='2542500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5629000',harga_beli ='5629000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2108500',harga_beli ='2108500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2017000',harga_beli ='2017000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2053500',harga_beli ='2053500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4895500',harga_beli ='4895500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='18078000',harga_beli ='18078000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2515500',harga_beli ='2515500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2492500',harga_beli ='2492500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2355500',harga_beli ='2355500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2446500',harga_beli ='2446500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2424000',harga_beli ='2424000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6803500',harga_beli ='6803500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2605000',harga_beli ='2605000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='9331500',harga_beli ='9331500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3366000',harga_beli ='3366000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3957000',harga_beli ='3957000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4064500',harga_beli ='4064500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4780500',harga_beli ='4780500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3867500',harga_beli ='3867500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5532500',harga_beli ='5532500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6606500',harga_beli ='6606500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='7967000',harga_beli ='7967000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6445500',harga_beli ='6445500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1343000',harga_beli ='1343000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2489000',harga_beli ='2489000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3795500',harga_beli ='3795500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3437500',harga_beli ='3437500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1969500',harga_beli ='1969500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1898000',harga_beli ='1898000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5819000',harga_beli ='5819000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6982500',harga_beli ='6982500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3115500',harga_beli ='3115500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6177000',harga_beli ='6177000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4905500',harga_beli ='4905500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2381500',harga_beli ='2381500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='2023500',harga_beli ='2023500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4601500',harga_beli ='4601500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3223000',harga_beli ='3223000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4777000',harga_beli ='4777000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6159000',harga_beli ='6159000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='9328000',harga_beli ='9328000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='8414500',harga_beli ='8414500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3079500',harga_beli ='3079500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4798500',harga_beli ='4798500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6696000',harga_beli ='6696000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6105000',harga_beli ='6105000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6284500',harga_beli ='6284500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='7215000',harga_beli ='7215000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='14394500',harga_beli ='14394500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1468500',harga_beli ='1468500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1468500',harga_beli ='1468500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1396500',harga_beli ='1396500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='1343000',harga_beli ='1343000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4440000',harga_beli ='4440000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='7627000',harga_beli ='7627000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='8719000',harga_beli ='8719000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='7412000',harga_beli ='7412000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6946500',harga_beli ='6946500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='7609000',harga_beli ='7609000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6785500',harga_beli ='6785500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4046500',harga_beli ='4046500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='48571500',harga_beli ='48571500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='7555500',harga_beli ='7555500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6982500',harga_beli ='6982500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5174500',harga_beli ='5174500' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='9936500',harga_beli ='9936500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='11531000',harga_beli ='11531000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='6624500',harga_beli ='6624500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5353500',harga_beli ='5353500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5872500',harga_beli ='5872500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4601500',harga_beli ='4601500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2157000','input','2025-11-10 13:10:53');
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='15126000',harga_beli ='15126000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='8874000',harga_beli ='8874000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4675500',harga_beli ='4675500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4712000',harga_beli ='4712000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5468500',harga_beli ='5468500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='4150500',harga_beli ='4150500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='10308500',harga_beli ='10308500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3164000',harga_beli ='3164000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='11863500',harga_beli ='11863500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='5640000',harga_beli ='5640000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2157000','input','2025-11-10 13:11:02');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2157000','input','2025-11-10 13:11:06');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2157000','input','2025-11-10 13:11:10');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2157000','input','2025-11-10 13:11:15');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2157000','input','2025-11-10 13:11:18');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2157000','input','2025-11-10 13:11:23');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2157000','input','2025-11-10 13:11:26');
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='3258500',harga_beli ='3258500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2157000','input','2025-11-10 13:11:31');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2157000','input','2025-11-10 13:11:35');
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2157000','input','2025-11-10 13:11:39');
UPDATE tm_barang SET harga_skrg ='2157000',harga_jual='327500',harga_beli ='327500' WHERE kode_barcode='00039525' LIMIT 1;
UPDATE tm_group SET harga='2157000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2157000','input','2025-11-10 13:11:42');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251023-0006';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251023-0006';
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 ('CBRE-YKAX-2-0','00039526','CBRE-04896 ','CBRE-04896 GIA 2417159912 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4077000','2025-11-10','4077000','2.520','75.00','75.00','0','2157000.00','1','0.04', 'input','2025-11-10 13:58:34','2.520','0','301.80','16750.00','0','TOKO','FREETAG','','10','','0','GIE 34 000 000','3','EIF 1025 8B4','BE-251023-0006','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-2-0','00039526');
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-10','CBRE-YKAX-2-0','CBRE','TOKO','CBRE.BALIK','75.00','2.520','2.520','1','2.520','2.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04896 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-2-0','00039526','RD','44','0.210 ','320','67.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-2-0','00039526','RD','1','0.150 ','1500','225');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-2-0','00039526','RD','8','0.030 ','320','9.6');
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-251110-0001','1','CBRE-YKAX-2-0','1','2.520','2.520','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-2-0','75.00','1','2.520','2.520','1','2.520','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.520',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251110-0001','2025-11-10','2025-11-10','13:58','2.52','input','2025-11-10 13:58:51');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251025-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251025-0001';
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 ('CBRE-YKAX-3-0','00039527','CBRE-03563 ','CINCIN CBRE-03563 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5711000','2025-11-10','5711000','3.530','75.00','75.00','0','2157000.00','1','0.04', 'input','2025-11-10 14:01:15','3.530','0','204.90','16750.00','0','TOKO','FREETAG','','10','','0','IDB 34 000 000','4','RS135 1025 8B8','BE-251025-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-3-0','00039527');
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-10','CBRE-YKAX-3-0','CBRE','TOKO','CBRE.BALIK','75.00','3.530','3.530','1','3.530','3.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03563 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-3-0','00039527','RD','8','0.025 ','320','8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-3-0','00039527','RD','44','0.270 ','320','86.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-3-0','00039527','RD','1','0.170 ','650','110.5');
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-251110-0002','1','CBRE-YKAX-3-0','1','3.530','3.530','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-3-0','75.00','1','3.530','3.530','1','3.530','3.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.530',berat_out_asli=berat_out_asli+'3.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251110-0002','2025-11-10','2025-11-10','14:01','3.53','input','2025-11-10 14:01:33');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251028-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251028-0002';
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 ('CBRE-YKAX-4-0','00039528','CBRE-06928 ','CINCIN CBRE-06928 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3672500','2025-11-10','3672500','2.270','75.00','75','0','2157000.00','1','0.14', 'input','2025-11-10 14:04:35','2.270','0','63.60','16750.00','','TOKO','FREETAG','','10','','','IDB 18 500 000','1','RS 13 1025 3B0','BE-251028-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-4-0','00039528');
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-10','CBRE-YKAX-4-0','CBRE','TOKO','SEM-BALIK','75.00','2.270','2.270','1','2.270','2.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06928 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-4-0','00039528','RD','1','0.090 ','600','54');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-4-0','00039528','RD','8','0.030 ','320','9.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251028-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251028-0001';
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 ('ABRE-YKAX-5-0','00039529','ABRE-02099 ','GIWANG ABRE-02099 ','','GR','---','DM','ABRE','TOKO','SEM-BALIK','10710000','2025-11-10','10710000','6.620','75.00','75','0','2157000.00','1','0.14', 'input','2025-11-10 14:07:03','6.620','0','502.40','16750.00','','TOKO','FREETAG','','10','','','IDB 66 000 000','1','1025 18B4','BE-251028-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YKAX-5-0','00039529');
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-10','ABRE-YKAX-5-0','ABRE','TOKO','SEM-BALIK','75.00','6.620','6.620','1','6.620','6.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02099 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-5-0','00039529','RD','6','0.390 ','320','124.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-5-0','00039529','RD','10','0.135 ','320','43.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-5-0','00039529','RD','12','0.575 ','320','184');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-5-0','00039529','RD','70','0.470 ','320','150.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251030-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251030-0002';
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 ('KLBE-YKAX-6-0','00039530','KLBE-00776 ','KALUNG KLBE-00776 ','','GR','---','DM','KLBE','TOKO','KLBE.BALIK','4691000','2025-11-10','4691000','2.620','83.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:09:23','2.620','0','185.70','16750.00','','TOKO','FREETAG','','10','','0','IDB 29 000 000','3','1025 7B6','BE-251030-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-YKAX-6-0','00039530');
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-10','KLBE-YKAX-6-0','KLBE','TOKO','KLBE.BALIK','83.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00776 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-YKAX-6-0','00039530','RD','1','0.035 ','420','14.7');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-YKAX-6-0','00039530','RD','18','0.240 ','450','108');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-YKAX-6-0','00039530','RD','28','0.100 ','450','45');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-YKAX-6-0','00039530','RD','16','0.040 ','450','18');
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-251110-0003','1','KLBE-YKAX-6-0','1','2.620','2.620','TOKO','KLBE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='KLBE-YKAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.BALIK';
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-11-10','TOKO','SEM-BALIK','KLBE','KLBE-YKAX-6-0','83.00','1','2.620','2.620','1','2.620','2.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.620',berat_out_asli=berat_out_asli+'2.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='KLBE-YKAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.BALIK' 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-251110-0003','2025-11-10','2025-11-10','14:09','2.62','input','2025-11-10 14:09:36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251030-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251030-0001';
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 ('CBRE-YKAX-7-0','00039531','CBRE-06929 ','CINCIN CBRE-06929 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2572500','2025-11-10','2572500','1.590','75.00','75','0','2157000.00','1','0.14', 'input','2025-11-10 14:11:01','1.590','0','92.25','16750.00','','TOKO','FREETAG','','10','','','IDB 16 000 000','1','RS 12 1025 4B0','BE-251030-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-7-0','00039531');
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-10','CBRE-YKAX-7-0','CBRE','TOKO','SEM-BALIK','75.00','1.590','1.590','1','1.590','1.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06929 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-7-0','00039531','RD','27','0.205 ','450','92.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251031-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251031-0001';
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 ('CBRE-YKAX-8-0','00039532','CBRE-00389 ','CINCIN CBRE-00389 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3591500','2025-11-10','3591500','2.220','75.00','75.00','0','2157000.00','1','0.04', 'input','2025-11-10 14:12:57','2.220','0','22.40','16750.00','','TOKO','FREETAG','','10','','0','IDB 15 500 000','3','RS135 1025 2B7','BE-251031-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-8-0','00039532');
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-10','CBRE-YKAX-8-0','CBRE','TOKO','CBRE.BALIK','75.00','2.220','2.220','1','2.220','2.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00389 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-8-0','00039532','RD','13','0.070 ','320','22.4');
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-251110-0004','1','CBRE-YKAX-8-0','1','2.220','2.220','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-8-0','75.00','1','2.220','2.220','1','2.220','2.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251110-0004','2025-11-10','2025-11-10','14:13','2.22','input','2025-11-10 14:13:09');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251101-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251101-0002';
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 ('CBRE-YKAX-9-0','00039533','CBRE-06930 ','CINCIN CBRE-06930 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2793000','2025-11-10','2793000','1.560','83.00','75','0','2157000.00','1','0.14', 'input','2025-11-10 14:16:23','1.560','413000','135.00','16750.00','','TOKO','FREETAG','','10','','','IDB 19 500 000','1','RS115 1125 5B6','BE-251101-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-9-0','00039533');
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-10','CBRE-YKAX-9-0','CBRE','TOKO','SEM-BALIK','83.00','1.560','1.560','1','1.560','1.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06930 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-9-0','00039533','RD','1','0.180 ','750','135');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251101-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251101-0001';
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 ('CBRE-YKAX-10-0','00039534','CBRE-00565 ','CINCIN CBRE-00565 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','8186000','2025-11-10','8186000','5.060','75.00','75.00','0','2157000.00','1','0.04', 'input','2025-11-10 14:18:42','5.060','0','65.60','16750.00','','TOKO','FREETAG','','10','','0','IDB 34 500 000','2','RS 17 1125 7B4','BE-251101-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-10-0','00039534');
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-10','CBRE-YKAX-10-0','CBRE','TOKO','CBRE.BALIK','75.00','5.060','5.060','1','5.060','5.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00565 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-10-0','00039534','RD','30','0.205 ','320','65.6');
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-251110-0005','1','CBRE-YKAX-10-0','1','5.060','5.060','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-10-0','75.00','1','5.060','5.060','1','5.060','5.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.060',berat_out_asli=berat_out_asli+'5.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251110-0005','2025-11-10','2025-11-10','14:18','5.06','input','2025-11-10 14:18:55');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-251102-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-251102-0001';
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 ('TFC-YKAX-11-0','00039535','TFC-21411 ','TFC-21411 GIA 7508375608 ','','GR','---','DM','TFC','TOKO','TFC','7895000','2025-11-10','7895000','4.880','75.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:22:16','4.880','0','842.80','16750.00','','TOKO','FREETAG','','10','','0','IDB 76 000 000','2','FVVS2 1125 20B8','FB-251102-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-YKAX-11-0','00039535');
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-10','TFC-YKAX-11-0','TFC','TOKO','TFC','75.00','4.880','4.880','1','4.880','4.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21411 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-YKAX-11-0','00039535','PEAR','1','0.500 ','1500','750');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-YKAX-11-0','00039535','RD','14','0.185 ','320','59.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-YKAX-11-0','00039535','RD','23','0.105 ','320','33.6');
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-251110-0006','1','TFC-YKAX-11-0','1','4.880','4.880','TOKO','TFC','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFC-YKAX-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC';
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-11-10','TOKO','SEM-BALIK','TFC','TFC-YKAX-11-0','75.00','1','4.880','4.880','1','4.880','4.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.880',berat_out_asli=berat_out_asli+'4.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='TFC-YKAX-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFC' 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-251110-0006','2025-11-10','2025-11-10','14:22','4.88','input','2025-11-10 14:22:29');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251103-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251103-0002';
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 ('ABRE-YKAX-12-0','00039536','ABRE-01810 ','GIWANG ABRE-01810 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','2135500','2025-11-10','2135500','1.320','75.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:24:35','1.320','0','98.00','16750.00','','TOKO','FREETAG','','10','','0','IDB 15 000 000','3','1125 3B8','BE-251103-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YKAX-12-0','00039536');
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-10','ABRE-YKAX-12-0','ABRE','TOKO','ABRE.BALIK','75.00','1.320','1.320','1','1.320','1.320','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01810 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-12-0','00039536','RD','2','0.070 ','350','24.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-12-0','00039536','RD','12','0.210 ','350','73.5');
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-251110-0007','1','ABRE-YKAX-12-0','1','1.320','1.320','TOKO','ABRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-YKAX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
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-11-10','TOKO','SEM-BALIK','ABRE','ABRE-YKAX-12-0','75.00','1','1.320','1.320','1','1.320','1.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.320',berat_out_asli=berat_out_asli+'1.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='ABRE-YKAX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK' 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-251110-0007','2025-11-10','2025-11-10','14:24','1.32','input','2025-11-10 14:24:48');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251104-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251104-0002';
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 ('CBRE-YKAX-13-0','00039537','CBRE-02061 ','CINCIN CBRE-02061 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1217500','2025-11-10','1217500','0.680','83.00','75.00','0','2157000.00','1','0.04', 'input','2025-11-10 14:26:51','0.680','300000','22.50','16750.00','0','TOKO','FREETAG','','10','','0','IDB 7 000 000','6','RS 13 1125 1B9','BE-251104-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-13-0','00039537');
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-10','CBRE-YKAX-13-0','CBRE','TOKO','CBRE.BALIK','83.00','0.680','0.680','1','0.680','0.680','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02061 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-13-0','00039537','RD','10','0.050 ','450','22.5');
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-251110-0008','1','CBRE-YKAX-13-0','1','0.680','0.680','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-13-0','83.00','1','0.680','0.680','1','0.680','0.680');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.680',berat_out_asli=berat_out_asli+'0.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251110-0008','2025-11-10','2025-11-10','14:26','0.68','input','2025-11-10 14:27:04');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251104-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251104-0001';
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 ('ABRE-YKAX-14-0','00039538','ABRE-02044 ','GIWANG ABRE-02044 ','','GR','---','DM','ABRE','TOKO','ABRE','4621500','2025-11-10','4621500','2.080','103.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:29:06','2.080','275000','408.00','16750.00','','TOKO','FREETAG','','10','','0','IDB 42 000 000','2','1125 12B0','BE-251104-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YKAX-14-0','00039538');
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-10','ABRE-YKAX-14-0','ABRE','TOKO','ABRE','103.00','2.080','2.080','1','2.080','2.080','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02044 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YKAX-14-0','00039538','RD','14','0.850 ','480','408');
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-251110-0009','1','ABRE-YKAX-14-0','1','2.080','2.080','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-YKAX-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
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-11-10','TOKO','SEM-BALIK','ABRE','ABRE-YKAX-14-0','103.00','1','2.080','2.080','1','2.080','2.080');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.080',berat_out_asli=berat_out_asli+'2.080',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='ABRE-YKAX-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' 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-251110-0009','2025-11-10','2025-11-10','14:29','2.08','input','2025-11-10 14:29:19');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251105-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251105-0002';
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 ('GBRE-YKAX-15-0','00039539','GBRE-00987 ','GELANG GBRE-00987 ','','GR','---','DM','GBRE','TOKO','GBRE','7442000','2025-11-10','7442000','4.600','75.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:31:42','4.600','0','136.00','16750.00','','TOKO','FREETAG','','10','','0','IDB 36 000 000','2','1125 8B4','BE-251105-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-YKAX-15-0','00039539');
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-10','GBRE-YKAX-15-0','GBRE','TOKO','GBRE','75.00','4.600','4.600','1','4.600','4.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00987 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YKAX-15-0','00039539','RD','1','0.050 ','320','16');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YKAX-15-0','00039539','RD','2','0.145 ','320','46.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YKAX-15-0','00039539','RD','5','0.045 ','320','14.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YKAX-15-0','00039539','RD','36','0.185 ','320','59.2');
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-251110-0010','1','GBRE-YKAX-15-0','1','4.600','4.600','TOKO','GBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-YKAX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE';
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-11-10','TOKO','SEM-BALIK','GBRE','GBRE-YKAX-15-0','75.00','1','4.600','4.600','1','4.600','4.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.600',berat_out_asli=berat_out_asli+'4.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='GBRE-YKAX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE' 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-251110-0010','2025-11-10','2025-11-10','14:31','4.6','input','2025-11-10 14:31:55');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251105-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251105-0001';
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 ('CBRE-YKAX-16-0','00039540','CBRE-06629 ','CINCIN CBRE-06629 ','','GR','---','DM','CBRE','TOKO','CBRE','2417000','2025-11-10','2417000','1.350','83.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:33:21','1.350','200000','62.85','16750.00','','TOKO','FREETAG','','10','','0','IDB 14 500 000','2','RS 15 1125 3B7','BE-251105-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-16-0','00039540');
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-10','CBRE-YKAX-16-0','CBRE','TOKO','CBRE','83.00','1.350','1.350','1','1.350','1.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06629 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-16-0','00039540','RD','1','0.070 ','480','33.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-16-0','00039540','RD','10','0.065 ','450','29.25');
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-251110-0011','1','CBRE-YKAX-16-0','1','1.350','1.350','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-16-0','83.00','1','1.350','1.350','1','1.350','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251110-0011','2025-11-10','2025-11-10','14:33','1.35','input','2025-11-10 14:33:35');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251106-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251106-0003';
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 ('CBRE-YKAX-17-0','00039541','CBR2172 ','CINCIN CBR2172 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','5889000','2025-11-10','5889000','3.640','75.00','75','0','2157000.00','1','0.14', 'input','2025-11-10 14:36:16','3.640','0','89.60','16750.00','','TOKO','FREETAG','','10','','','IDB 27 500 000','1','RS14 1125 5B350','BE-251106-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-17-0','00039541');
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-10','CBRE-YKAX-17-0','CBRE','TOKO','SEM-BALIK','75.00','3.640','3.640','1','3.640','3.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR2172 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-17-0','00039541','RD','10','0.160 ','320','51.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-17-0','00039541','RD','20','0.120 ','320','38.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251106-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251106-0002';
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 ('CBRE-YKAX-18-0','00039542','CBRE-02814 ','CINCIN CBRE-02814 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','7403000','2025-11-10','7403000','4.290','80.00','75','0','2157000.00','1','0.04', 'input','2025-11-10 14:38:13','4.290','0','338.00','16750.00','','TOKO','FREETAG','','10','','0','IDB 47 000 000','3','RS 14 1125 12B8','BE-251106-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YKAX-18-0','00039542');
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-10','CBRE-YKAX-18-0','CBRE','TOKO','CBRE.BALIK','80.00','4.290','4.290','1','4.290','4.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02814 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-18-0','00039542','RD','24','0.275 ','400','110');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-18-0','00039542','RD','28','0.170 ','400','68');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YKAX-18-0','00039542','RD','40','0.400 ','400','160');
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-251110-0012','1','CBRE-YKAX-18-0','1','4.290','4.290','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YKAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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-11-10','TOKO','SEM-BALIK','CBRE','CBRE-YKAX-18-0','80.00','1','4.290','4.290','1','4.290','4.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.290',berat_out_asli=berat_out_asli+'4.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251110-0012','2025-11-10','2025-11-10','15:14','4.29','input','2025-11-10 15:14:28');
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-251110-0013','1','ABRE-YKAX-12-0','1','1.320','1.320','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-YKAX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.320',berat_in_asli=berat_in_asli+'1.320',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.320',berat_akhir_asli=berat_akhir_asli+'1.320' WHERE tanggal='2025-11-10' AND kode_barang='ABRE-YKAX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.320',berat_out_asli=berat_out_asli+'1.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='ABRE-YKAX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0013','2','ABRE-YKAX-14-0','1','2.080','2.080','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-YKAX-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','ABRE.BALIK','ABRE','ABRE-YKAX-14-0','103.00','1','2.080','2.080','1','2.080','2.080');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.080',berat_out_asli=berat_out_asli+'2.080',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='ABRE-YKAX-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0013','3','ABRE-YKAX-5-0','1','6.620','6.620','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-YKAX-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','ABRE.BALIK','ABRE','ABRE-YKAX-5-0','75.00','1','6.620','6.620','1','6.620','6.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.620',berat_out_asli=berat_out_asli+'6.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='ABRE-YKAX-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-251110-0013','2025-11-10','2025-11-10','15:26','10.02','input','2025-11-10 15:27:17');
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-251110-0014','1','TFC-YKAX-11-0','1','4.880','4.880','TOKO','SEM-BALIK','TOKO','TFC.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-YKAX-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','TFC.BALIK','TFC','TFC-YKAX-11-0','75.00','1','4.880','4.880','1','4.880','4.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.880',berat_out_asli=berat_out_asli+'4.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='TFC-YKAX-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-251110-0014','2025-11-10','2025-11-10','15:27','4.88','input','2025-11-10 15:27:36');
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-251110-0015','1','KLBE-YKAX-6-0','1','2.620','2.620','TOKO','SEM-BALIK','TOKO','KLBE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KLBE.BALIK' WHERE kode_barang='KLBE-YKAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.620',berat_in_asli=berat_in_asli+'2.620',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.620',berat_akhir_asli=berat_akhir_asli+'2.620' WHERE tanggal='2025-11-10' AND kode_barang='KLBE-YKAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.620',berat_out_asli=berat_out_asli+'2.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='KLBE-YKAX-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-251110-0015','2025-11-10','2025-11-10','15:27','2.62','input','2025-11-10 15:28:00');
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-251110-0016','1','GBRE-YKAX-15-0','1','4.600','4.600','TOKO','SEM-BALIK','TOKO','GBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GBRE.BALIK' WHERE kode_barang='GBRE-YKAX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','GBRE.BALIK','GBRE','GBRE-YKAX-15-0','75.00','1','4.600','4.600','1','4.600','4.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.600',berat_out_asli=berat_out_asli+'4.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='GBRE-YKAX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-251110-0016','2025-11-10','2025-11-10','15:28','4.6','input','2025-11-10 15:28:14');
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-251110-0017','1','CBRE-YKAX-2-0','1','2.520','2.520','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.520',berat_in_asli=berat_in_asli+'2.520',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.520',berat_akhir_asli=berat_akhir_asli+'2.520' WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.520',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','2','CBRE-YKAX-17-0','1','3.640','3.640','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','CBRE.BALIK','CBRE','CBRE-YKAX-17-0','75.00','1','3.640','3.640','1','3.640','3.640');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.640',berat_out_asli=berat_out_asli+'3.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','3','CBRE-YKAX-8-0','1','2.220','2.220','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.220',berat_in_asli=berat_in_asli+'2.220',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.220',berat_akhir_asli=berat_akhir_asli+'2.220' WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','4','CBRE-YKAX-10-0','1','5.060','5.060','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'5.060',berat_in_asli=berat_in_asli+'5.060',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'5.060',berat_akhir_asli=berat_akhir_asli+'5.060' WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.060',berat_out_asli=berat_out_asli+'5.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','5','CBRE-YKAX-13-0','1','0.680','0.680','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.680',berat_in_asli=berat_in_asli+'0.680',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.680',berat_akhir_asli=berat_akhir_asli+'0.680' WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.680',berat_out_asli=berat_out_asli+'0.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','6','CBRE-YKAX-18-0','1','4.290','4.290','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'4.290',berat_in_asli=berat_in_asli+'4.290',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'4.290',berat_akhir_asli=berat_akhir_asli+'4.290' WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.290',berat_out_asli=berat_out_asli+'4.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','7','CBRE-YKAX-3-0','1','3.530','3.530','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.530',berat_in_asli=berat_in_asli+'3.530',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.530',berat_akhir_asli=berat_akhir_asli+'3.530' WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.530',berat_out_asli=berat_out_asli+'3.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','8','CBRE-YKAX-16-0','1','1.350','1.350','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','CBRE.BALIK','CBRE','CBRE-YKAX-16-0','83.00','1','1.350','1.350','1','1.350','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','9','CBRE-YKAX-4-0','1','2.270','2.270','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','CBRE.BALIK','CBRE','CBRE-YKAX-4-0','75.00','1','2.270','2.270','1','2.270','2.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.270',berat_out_asli=berat_out_asli+'2.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','10','CBRE-YKAX-7-0','1','1.590','1.590','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','CBRE.BALIK','CBRE','CBRE-YKAX-7-0','75.00','1','1.590','1.590','1','1.590','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.590',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
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-251110-0017','11','CBRE-YKAX-9-0','1','1.560','1.560','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-YKAX-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
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-11-10','TOKO','CBRE.BALIK','CBRE','CBRE-YKAX-9-0','83.00','1','1.560','1.560','1','1.560','1.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.560',berat_out_asli=berat_out_asli+'1.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-10' AND kode_barang='CBRE-YKAX-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' 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-251110-0017','2025-11-10','2025-11-10','15:29','28.71','input','2025-11-10 15:29:48');
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 ('LGM1-YKAX-19-0','00039543','LGM1-115% ','LOGAM MULIA 1 GR K74442081 ','','GR','---','GOLD','LGM1','TOKO','LM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.04', 'input','2025-11-10 15:51:23','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM1','LGM1-YKAX-19-0','00039543');
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-10','LGM1-YKAX-19-0','LGM1','TOKO','LM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM1','LGM1-115% ');
DELETE FROM tm_berlian WHERE kode_barang='LGM1-YKAX-19-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('LGM1-YKAX-19-0','00039543','00039543','LOGAM MULIA 1 GR K74442081 ','LM ANTAM 1 GR K74442081','','','2481000','2481000',' 0','0','input','2025-11-10 15:51:57');
UPDATE tm_barang SET nama_barang='LM ANTAM 1 GR K74442081' ,nama_atribut='' ,kode_intern='LGM1-115% ', kadar_cetak='9999.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='LGM1-YKAX-19-0' LIMIT 1;
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 ('LGM1-YKAX-20-0','00039544','LGM1-115% ','LM ANTAM 1 GR K74442094 ','','GR','---','GOLD','LGM1','TOKO','LM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.04', 'input','2025-11-10 15:52:30','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM1','LGM1-YKAX-20-0','00039544');
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-10','LGM1-YKAX-20-0','LGM1','TOKO','LM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM1','LGM1-115% ');
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 ('LGM1-YKAX-21-0','00039545','LGM1-115% ','LM ANTAM 1 GR K74442093 ','','GR','---','GOLD','LGM1','TOKO','LM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.04', 'input','2025-11-10 15:53:02','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM1','LGM1-YKAX-21-0','00039545');
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-10','LGM1-YKAX-21-0','LGM1','TOKO','LM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM1','LGM1-115% ');
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 ('LGM1-YKAX-22-0','00039546','LGM1-115% ','LM ANTAM 1 GR K74443575 ','','GR','---','GOLD','LGM1','TOKO','LM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.04', 'input','2025-11-10 15:53:32','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LGM1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LGM1','LGM1-YKAX-22-0','00039546');
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-10','LGM1-YKAX-22-0','LGM1','TOKO','LM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LGM1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LGM1','LGM1-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 ('LMB1-YKAX-23-0','00039547','LMB1-115% ','LM ANTAM 1 GR K74443590 ','','GR','---','GOLD','LMB1','TOKO','BIPLM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.14', 'input','2025-11-10 15:57:49','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB1','LMB1-YKAX-23-0','00039547');
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-10','LMB1-YKAX-23-0','LMB1','TOKO','BIPLM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB1','LMB1-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 ('LMB1-YKAX-24-0','00039548','LMB1-115% ','LM ANTAM 1 GR K74442080 ','','GR','---','GOLD','LMB1','TOKO','BIPLM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.14', 'input','2025-11-10 15:58:19','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB1','LMB1-YKAX-24-0','00039548');
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-10','LMB1-YKAX-24-0','LMB1','TOKO','BIPLM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB1','LMB1-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 ('LMB1-YKAX-25-0','00039549','LMB1-115% ','LM ANTAM 1 GR K74442079 ','','GR','---','GOLD','LMB1','TOKO','BIPLM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.14', 'input','2025-11-10 15:58:50','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB1','LMB1-YKAX-25-0','00039549');
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-10','LMB1-YKAX-25-0','LMB1','TOKO','BIPLM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB1','LMB1-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 ('LMB1-YKAX-26-0','00039550','LMB1-115% ','LM ANTAM 1 GR K70131533 ','','GR','---','GOLD','LMB1','TOKO','BIPLM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.14', 'input','2025-11-10 15:59:27','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB1','LMB1-YKAX-26-0','00039550');
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-10','LMB1-YKAX-26-0','LMB1','TOKO','BIPLM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB1','LMB1-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 ('LMB1-YKAX-27-0','00039551','LMB1-115% ','LM ANTAM 1 GR K74443589 ','','GR','---','GOLD','LMB1','TOKO','BIPLM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.14', 'input','2025-11-10 16:00:00','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB1','LMB1-YKAX-27-0','00039551');
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-10','LMB1-YKAX-27-0','LMB1','TOKO','BIPLM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB1','LMB1-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 ('LMB1-YKAX-28-0','00039552','LMB1-115% ','LM ANTAM 1 GR K74443585 ','','GR','---','GOLD','LMB1','TOKO','BIPLM','2481000','2025-11-10','2481000','1.000','115.00','9999','0','2157000.00','1','0.14', 'input','2025-11-10 16:00:39','1.000','0','','16750.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMB1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMB1','LMB1-YKAX-28-0','00039552');
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-10','LMB1-YKAX-28-0','LMB1','TOKO','BIPLM','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMB1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMB1','LMB1-115% ');