INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-17 ','08:07:03');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-16';
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-09-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-09-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-17 ','08:08:01');
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1980000',harga_beli ='1980000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4010500',harga_beli ='4010500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='156000',harga_beli ='156000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2269000',harga_beli ='2269000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5023500',harga_beli ='5023500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1882000',harga_beli ='1882000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1833000',harga_beli ='1833000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4369000',harga_beli ='4369000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='16133500',harga_beli ='16133500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2245000',harga_beli ='2245000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2224500',harga_beli ='2224500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2102000',harga_beli ='2102000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2183500',harga_beli ='2183500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6071500',harga_beli ='6071500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2324500',harga_beli ='2324500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='8328000',harga_beli ='8328000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3004000',harga_beli ='3004000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3531500',harga_beli ='3531500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3627000',harga_beli ='3627000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3451500',harga_beli ='3451500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4937500',harga_beli ='4937500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5896000',harga_beli ='5896000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7110500',harga_beli ='7110500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5752000',harga_beli ='5752000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1198500',harga_beli ='1198500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2221000',harga_beli ='2221000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3387500',harga_beli ='3387500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3068000',harga_beli ='3068000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1758000',harga_beli ='1758000' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1694000',harga_beli ='1694000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5193000',harga_beli ='5193000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6231500',harga_beli ='6231500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2780500',harga_beli ='2780500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5512500',harga_beli ='5512500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4378000',harga_beli ='4378000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2125500',harga_beli ='2125500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1805500',harga_beli ='1805500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4106500',harga_beli ='4106500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2876000',harga_beli ='2876000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4263000',harga_beli ='4263000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5496500',harga_beli ='5496500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='8324500',harga_beli ='8324500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7509500',harga_beli ='7509500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2748500',harga_beli ='2748500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4282000',harga_beli ='4282000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5448500',harga_beli ='5448500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5608500',harga_beli ='5608500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6439000',harga_beli ='6439000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='12846000',harga_beli ='12846000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1310500',harga_beli ='1310500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1310500',harga_beli ='1310500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1246500',harga_beli ='1246500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='1198500',harga_beli ='1198500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3962500',harga_beli ='3962500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6806500',harga_beli ='6806500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7781500',harga_beli ='7781500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6199500',harga_beli ='6199500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6790500',harga_beli ='6790500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6055500',harga_beli ='6055500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3611000',harga_beli ='3611000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='43347000',harga_beli ='43347000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6743000',harga_beli ='6743000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='6231500',harga_beli ='6231500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4618000',harga_beli ='4618000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='8868000',harga_beli ='8868000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='10290500',harga_beli ='10290500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5912000',harga_beli ='5912000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4777500',harga_beli ='4777500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5241000',harga_beli ='5241000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4106500',harga_beli ='4106500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','1925000','input','2025-09-17 08:16:55');
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='13499500',harga_beli ='13499500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='7919500',harga_beli ='7919500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4172500',harga_beli ='4172500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4205500',harga_beli ='4205500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='4880000',harga_beli ='4880000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='3704000',harga_beli ='3704000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='9200000',harga_beli ='9200000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2824000',harga_beli ='2824000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='10587500',harga_beli ='10587500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='5033000',harga_beli ='5033000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','1925000','input','2025-09-17 08:17:02');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','1925000','input','2025-09-17 08:17:07');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','1925000','input','2025-09-17 08:17:12');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','1925000','input','2025-09-17 08:17:15');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','1925000','input','2025-09-17 08:17:19');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','1925000','input','2025-09-17 08:17:23');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','1925000','input','2025-09-17 08:17:28');
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2908000',harga_beli ='2908000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1925000',harga_jual='2652500',harga_beli ='2652500' WHERE kode_barcode='00038746' LIMIT 1;
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','1925000','input','2025-09-17 08:17:33');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','1925000','input','2025-09-17 08:17:55');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','1925000','input','2025-09-17 08:18:00');
UPDATE tm_group SET harga='1925000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','1925000','input','2025-09-17 08:18:05');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02869';
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 ('PSGE-YIAG-1-0','00038763','DP-02869 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','3435500','2025-09-17','3435500','2.150','83.00','75','300000','1925000.00','1','0.04', 'input','2025-09-17 08:22:08','2.150','0','','16500.00','','TOKO','FREETAG','','2','','','PSN02869','1','RS 13 5','','DP-02869');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-YIAG-1-0','00038763');
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-09-17','PSGE-YIAG-1-0','PSGE','TOKO','PSN','83.00','2.150','2.150','1','2.150','2.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-02869 ');
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 ('ABRE-YIAG-2-0','00038764','ABRE-02090 ','ABRE-02090 GIA 7508 GIA 8106 ','','GR','---','DM','ABRE','TOKO','ABRE','4298000','2025-09-17','4298000','2.690','83.00','75','0','1925000.00','1','0.04', 'input','2025-09-17 08:31:08','2.690','701000','605.20','16500.00','','TOKO','FREETAG','','10','','','GIA 54 000 000','1','EVVS2 0925','','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YIAG-2-0','00038764');
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-09-17','ABRE-YIAG-2-0','ABRE','TOKO','ABRE','83.00','2.690','2.690','1','2.690','2.690','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02090 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-2-0','00038764','RD','1','0.230 ','1120','257.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-2-0','00038764','RD','1','0.230 ','1120','257.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-2-0','00038764','RD','30','0.200 ','450','90');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0001','1','ABRE-YIAG-2-0','1','2.690','TOKO','ABRE');
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-YIAG-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='ABRE-YIAG-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='ABRE-YIAG-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='ABRE-YIAG-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='ABRE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='ABRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='ABRE-YIAG-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.690',berat_out_asli='2.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.690',berat_akhir_asli =berat_akhir_asli-'2.690' WHERE kode_barang='ABRE-YIAG-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-250917-0001','2025-09-17','2025-09-17','08:35','2.690','input','2025-09-17 08:35:33','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0002','1','PSGE-YIAG-1-0','1','2.150','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-YIAG-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-YIAG-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-YIAG-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-YIAG-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGE-YIAG-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='PSGE-YIAG-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-250917-0002','2025-09-17','2025-09-17','08:35','2.150','input','2025-09-17 08:35:52','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','1','PMM-YIAF-2-0','1','2.280','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.280' WHERE kode_barang='PMM-YIAF-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','2','PMM-YIAF-3-0','1','1.900','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='PMM-YIAF-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','3','PMM-YIAF-4-0','1','1.860','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.860',berat_out_asli='1.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.860',berat_akhir_asli =berat_akhir_asli-'1.860' WHERE kode_barang='PMM-YIAF-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','4','PMM-YIAF-5-0','1','2.110','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PMM-YIAF-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','5','PMM-YIAF-6-0','1','2.250','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.250',berat_out_asli='2.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.250',berat_akhir_asli =berat_akhir_asli-'2.250' WHERE kode_barang='PMM-YIAF-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','6','PMM-YIAF-7-0','1','1.970','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='PMM-YIAF-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','7','PMM-YIAF-8-0','1','1.890','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.890',berat_out_asli='1.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.890',berat_akhir_asli =berat_akhir_asli-'1.890' WHERE kode_barang='PMM-YIAF-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','8','PMM-YIAF-9-0','1','2.140','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.140',berat_out_asli='2.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.140',berat_akhir_asli =berat_akhir_asli-'2.140' WHERE kode_barang='PMM-YIAF-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','9','PMM-YIAF-10-0','1','2.140','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.140',berat_out_asli='2.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.140',berat_akhir_asli =berat_akhir_asli-'2.140' WHERE kode_barang='PMM-YIAF-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','10','PMM-YIAF-11-0','1','1.830','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.830',berat_out_asli='1.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.830',berat_akhir_asli =berat_akhir_asli-'1.830' WHERE kode_barang='PMM-YIAF-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','11','PMM-YIAF-12-0','1','1.960','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='PMM-YIAF-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','12','PMM-YIAF-13-0','1','2.030','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='PMM-YIAF-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','13','PMM-YIAF-14-0','1','2.160','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.160',berat_out_asli='2.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.160',berat_akhir_asli =berat_akhir_asli-'2.160' WHERE kode_barang='PMM-YIAF-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','14','PMM-YIAF-15-0','1','2.070','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.070' WHERE kode_barang='PMM-YIAF-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','15','PMM-YIAF-16-0','1','2.060','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='PMM-YIAF-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250917-0003','16','PMM-YIAF-17-0','1','2.050','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YIAF-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-YIAF-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-YIAF-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-YIAF-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-YIAF-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='PMM-YIAF-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-250917-0003','2025-09-17','2025-09-17','08:36','2.050','input','2025-09-17 08:36:13','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-17 ','08:47:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-09-17 ','08:48:14');
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-01067';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-YIAG-3-0','00038765','DP-01067BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','1550000','2025-09-17','1550000','0.970','83.00','75','300000','1925000.00','1','0.14', 'input','2025-09-17 09:07:49','0.970','0','','16500.00','','TOKO','FREETAG','','2','','','PSN01067BIP','1','RS 11','','DP-01067');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YIAG-3-0','00038765');
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-09-17','PSGT-YIAG-3-0','PSGT','TOKO','PSNB','83.00','0.970','0.970','1','0.970','0.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01067BIP ');
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-01073';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-YIAG-4-0','00038766','DP-01073BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','4969500','2025-09-17','4969500','3.110','83.00','75','300000','1925000.00','1','0.14', 'input','2025-09-17 09:09:43','3.110','0','','16500.00','','TOKO','FREETAG','','2','','','PSN01073BIP','1','RS 15','','DP-01073');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YIAG-4-0','00038766');
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-09-17','PSGT-YIAG-4-0','PSGT','TOKO','PSNB','83.00','3.110','3.110','1','3.110','3.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01073BIP ');
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-01039';
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-YIAG-5-0','00038767','DP-01039BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','553000','2025-09-17','553000','4.100','7.00','10','300000','1925000.00','1','0.14', 'input','2025-09-17 10:17:06','4.100','0','','16500.00','','TOKO','FREETAG','','10','','','PSN01039BIP','1','RS 16','','DP-01039');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YIAG-5-0','00038767');
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-09-17','PSPLT-YIAG-5-0','PSPLT','TOKO','PSNB','7.00','4.100','4.100','1','4.100','4.100','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01039BIP ');
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 ('PBDG-YIAG-6-0','00038768','900K-15-1638 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','50500','2025-09-17','50500','2.010','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-17 10:21:00','2.010','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-YIAG-6-0','00038768');
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-09-17','PBDG-YIAG-6-0','PBDG','TOKO','PBDG','100.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-15-1638 ');
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 ('PBDG-YIAG-7-0','00038769','900K-9-1639 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','46500','2025-09-17','46500','1.850','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-17 10:21:27','1.850','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-YIAG-7-0','00038769');
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-09-17','PBDG-YIAG-7-0','PBDG','TOKO','PBDG','100.00','1.850','1.850','1','1.850','1.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-9-1639 ');
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 ('PBDG-YIAG-8-0','00038770','900K-8-1640 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','46000','2025-09-17','46000','1.840','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-17 10:21:59','1.840','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-YIAG-8-0','00038770');
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-09-17','PBDG-YIAG-8-0','PBDG','TOKO','PBDG','100.00','1.840','1.840','1','1.840','1.840','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-8-1640 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02873';
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 ('PSPLE-YIAG-9-0','00038771','DP-02873 ','CINCIN PALADIUM ','','GR','---','PSPLE','PSPLE','TOKO','PSN','650000','2025-09-17','650000','2.110','16.00','25','300000','1925000.00','1','0.04', 'input','2025-09-17 13:39:14','2.110','0','','16500.00','','TOKO','FREETAG','','10','','','PSN02873','1','RS 14','','DP-02873');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLE','PSPLE-YIAG-9-0','00038771');
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-09-17','PSPLE-YIAG-9-0','PSPLE','TOKO','PSN','16.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLE','DP-02873 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-250915-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-250915-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 ('TFCMR-YIAG-10-0','00038772','TFCMR75-75% ','THIFA CINCIN MAS RG ','','GR','---','GOLD','TFCMR','TOKO','SEM-EMAS','1877000','2025-09-17','1877000','1.300','75.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:06:01','1.300','0','','16500.00','','TOKO','FREETAG','','2','','','','','','FB-250915-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFCMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFCMR','TFCMR-YIAG-10-0','00038772');
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-09-17','TFCMR-YIAG-10-0','TFCMR','TOKO','SEM-EMAS','75.00','1.300','1.300','1','1.300','1.300','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFCMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFCMR','TFCMR75-75% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250915-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250915-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-YIAG-11-0','00038773','CBRE-02182 ','CINCIN CBRE-02182 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2029500','2025-09-17','2029500','1.270','83.00','75','0','1925000.00','1','0.04', 'input','2025-09-17 15:08:25','1.270','420000','31.50','16500.00','','TOKO','FREETAG','','10','','0','IDB 11 000 000','4','C1002 15 0925','BE-250915-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-11-0','00038773');
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-09-17','CBRE-YIAG-11-0','CBRE','TOKO','CBRE.BALIK','83.00','1.270','1.270','1','1.270','1.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02182 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-11-0','00038773','RD','5','0.075 ','420','31.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-250917-0001','1','CBRE-YIAG-11-0','1','1.270','1.270','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-YIAG-11-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-11-0','83.00','1','1.270','1.270','1','1.270','1.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.270',berat_out_asli=berat_out_asli+'1.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='CBRE-YIAG-11-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-250917-0001','2025-09-17','2025-09-17','15:08','1.27','input','2025-09-17 15:08:41');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250914-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250914-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-YIAG-12-0','00038774','ABRE-00074 ','GIWANG ABRE-00074 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','4158000','2025-09-17','4158000','2.880','75.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:10:42','2.880','0','76.80','16500.00','','TOKO','FREETAG','','10','','0','IDB 20 000 000','3','0925','BE-250914-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YIAG-12-0','00038774');
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-09-17','ABRE-YIAG-12-0','ABRE','TOKO','ABRE.BALIK','75.00','2.880','2.880','1','2.880','2.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00074 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-12-0','00038774','RD','8','0.200 ','320','64');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-12-0','00038774','RD','10','0.040 ','320','12.8');
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-250917-0002','1','ABRE-YIAG-12-0','1','2.880','2.880','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-YIAG-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-09-17','TOKO','SEM-BALIK','ABRE','ABRE-YIAG-12-0','75.00','1','2.880','2.880','1','2.880','2.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.880',berat_out_asli=berat_out_asli+'2.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='ABRE-YIAG-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-250917-0002','2025-09-17','2025-09-17','15:10','2.88','input','2025-09-17 15:10:55');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250914-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250914-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-YIAG-13-0','00038775','CBRE-01740 ','CINCIN CBRE-01740 ','','GR','---','DM','CBRE','TOKO','CBRE','1374500','2025-09-17','1374500','0.860','83.00','75','0','1925000.00','1','0.04', 'input','2025-09-17 15:12:09','0.860','0','24.00','16500.00','','TOKO','FREETAG','','10','','0','IDB 7 000 000','2','C788 13 0925','BE-250914-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-13-0','00038775');
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-09-17','CBRE-YIAG-13-0','CBRE','TOKO','CBRE','83.00','0.860','0.860','1','0.860','0.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01740 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-13-0','00038775','RD','13','0.060 ','400','24');
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-250917-0003','1','CBRE-YIAG-13-0','1','0.860','0.860','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-YIAG-13-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-13-0','83.00','1','0.860','0.860','1','0.860','0.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.860',berat_out_asli=berat_out_asli+'0.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='CBRE-YIAG-13-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-250917-0003','2025-09-17','2025-09-17','15:12','0.86','input','2025-09-17 15:12:22');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250913-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250913-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-YIAG-14-0','00038776','ABRE-00053 ','GIWANG ABRE-00053 ','','GR','---','DM','ABRE','TOKO','ABRE','2916500','2025-09-17','2916500','2.020','75.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:14:45','2.020','0','132.00','16500.00','','TOKO','FREETAG','','10','','0','IDB 19 000 000','2','0925','BE-250913-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YIAG-14-0','00038776');
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-09-17','ABRE-YIAG-14-0','ABRE','TOKO','ABRE','75.00','2.020','2.020','1','2.020','2.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00053 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-14-0','00038776','RD','2','0.180 ','520','93.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-14-0','00038776','RD','26','0.120 ','320','38.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-250917-0004','1','ABRE-YIAG-14-0','1','2.020','2.020','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-YIAG-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-09-17','TOKO','SEM-BALIK','ABRE','ABRE-YIAG-14-0','75.00','1','2.020','2.020','1','2.020','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='ABRE-YIAG-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-250917-0004','2025-09-17','2025-09-17','15:14','2.02','input','2025-09-17 15:14:58');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250913-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250913-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-YIAG-15-0','00038777','ABRE-01575 ','GIWANG ABRE-01575 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','5135500','2025-09-17','5135500','2.590','103.00','75','0','1925000.00','1','0.04', 'input','2025-09-17 15:16:23','2.590','496000','347.25','16500.00','','TOKO','FREETAG','','10','','0','IDB 41 000 000','4','0925','BE-250913-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YIAG-15-0','00038777');
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-09-17','ABRE-YIAG-15-0','ABRE','TOKO','ABRE.BALIK','103.00','2.590','2.590','1','2.590','2.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01575 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-15-0','00038777','RD','2','0.310 ','750','232.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-15-0','00038777','RD','28','0.190 ','450','85.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-15-0','00038777','RD','24','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-250917-0005','1','ABRE-YIAG-15-0','1','2.590','2.590','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-YIAG-15-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-09-17','TOKO','SEM-BALIK','ABRE','ABRE-YIAG-15-0','103.00','1','2.590','2.590','1','2.590','2.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.590',berat_out_asli=berat_out_asli+'2.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='ABRE-YIAG-15-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-250917-0005','2025-09-17','2025-09-17','15:16','2.59','input','2025-09-17 15:16:36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250913-0006';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250913-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-YIAG-16-0','00038778','CBRE-03998 ','CINCIN CBRE-03998 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3093500','2025-09-17','3093500','1.560','103.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:18:08','1.560','0','85.10','16500.00','0','TOKO','FREETAG','','10','','0','IDB 17 500 000','3','RS 14 5 0925','BE-250913-0006','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-16-0','00038778');
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-09-17','CBRE-YIAG-16-0','CBRE','TOKO','CBRE.BALIK','103.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-03998 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-16-0','00038778','RD','1','0.060 ','370','22.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-16-0','00038778','RD','8','0.010 ','370','3.7');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-16-0','00038778','RD','8','0.160 ','370','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-250917-0006','1','CBRE-YIAG-16-0','1','1.560','1.560','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-YIAG-16-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-16-0','103.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-09-17' AND kode_barang='CBRE-YIAG-16-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-250917-0006','2025-09-17','2025-09-17','15:18','1.56','input','2025-09-17 15:18:22');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250913-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250913-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-YIAG-17-0','00038779','CBRE-02349 ','CINCIN CBRE-02349 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2093500','2025-09-17','2093500','1.310','83.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:19:36','1.310','440000','176.40','16500.00','0','TOKO','FREETAG','','10','','0','IDB 20 000 000','4','C931 14 0925','BE-250913-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-17-0','00038779');
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-09-17','CBRE-YIAG-17-0','CBRE','TOKO','CBRE.BALIK','83.00','1.310','1.310','1','1.310','1.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02349 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-17-0','00038779','RD','5','0.280 ','480','134.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-17-0','00038779','RD','4','0.100 ','420','42');
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-250917-0007','1','CBRE-YIAG-17-0','1','1.310','1.310','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-YIAG-17-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-17-0','83.00','1','1.310','1.310','1','1.310','1.310');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='CBRE-YIAG-17-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-250917-0007','2025-09-17','2025-09-17','15:19','1.31','input','2025-09-17 15:19:48');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250913-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250913-0005';
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-YIAG-18-0','00038780','KLBE-00162 ','KALUNG KLBE-00162 ','','GR','---','DM','KLBE','TOKO','KLBE.BALIK','5414500','2025-09-17','5414500','3.750','75.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:21:06','3.750','0','104.00','16500.00','0','TOKO','FREETAG','','10','','0','IDB 37 000 000','4','L106 M 0925','BE-250913-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-YIAG-18-0','00038780');
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-09-17','KLBE-YIAG-18-0','KLBE','TOKO','KLBE.BALIK','75.00','3.750','3.750','1','3.750','3.750','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00162 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-YIAG-18-0','00038780','RD','51','0.325 ','320','104');
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-250917-0008','1','KLBE-YIAG-18-0','1','3.750','3.750','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-YIAG-18-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-09-17','TOKO','SEM-BALIK','KLBE','KLBE-YIAG-18-0','75.00','1','3.750','3.750','1','3.750','3.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.750',berat_out_asli=berat_out_asli+'3.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='KLBE-YIAG-18-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-250917-0008','2025-09-17','2025-09-17','15:21','3.75','input','2025-09-17 15:21:18');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250911-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250911-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-YIAG-19-0','00038781','CBRE-02261 ','CBRE-02261 GIA 1349539899 ','','GR','---','DM','CBRE','TOKO','CBRE','2743500','2025-09-17','2743500','1.900','75.00','75','0','1925000.00','1','0.04', 'input','2025-09-17 15:24:23','1.900','0','333.20','16500.00','','TOKO','FREETAG','','10','','0','GIE 31 000 000','2','EVVS2 0925','BE-250911-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-19-0','00038781');
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-09-17','CBRE-YIAG-19-0','CBRE','TOKO','CBRE','75.00','1.900','1.900','1','1.900','1.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02261 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-19-0','00038781','RD','1','0.190 ','1400','266');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-19-0','00038781','RD','14','0.210 ','320','67.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-250917-0009','1','CBRE-YIAG-19-0','1','1.900','1.900','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-YIAG-19-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-19-0','75.00','1','1.900','1.900','1','1.900','1.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.900',berat_out_asli=berat_out_asli+'1.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='CBRE-YIAG-19-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-250917-0009','2025-09-17','2025-09-17','15:24','1.9','input','2025-09-17 15:24:36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250910-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250910-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-YIAG-20-0','00038782','CBRE-06903 ','CINCIN CBRE-06903 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','4043000','2025-09-17','4043000','2.800','75.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:32:07','2.800','0','70.40','16500.00','','TOKO','FREETAG','','10','','','IDB 19 500 000','1','RS 13 5 0925','BE-250910-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-20-0','00038782');
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-09-17','CBRE-YIAG-20-0','CBRE','TOKO','SEM-BALIK','75.00','2.800','2.800','1','2.800','2.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06903 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-20-0','00038782','RD','1','0.130 ','320','41.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-20-0','00038782','RD','16','0.070 ','320','22.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-20-0','00038782','RD','8','0.020 ','320','6.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250910-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250910-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 ('GBRE-YIAG-21-0','00038783','GBRE-01154 ','GELANG GBRE-01154 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','12333000','2025-09-17','12333000','6.220','103.00','75','0','1925000.00','1','0.04', 'input','2025-09-17 15:34:21','6.220','490000','445.95','16500.00','','TOKO','FREETAG','','10','','0','IDB 70 000 000','5','0925','BE-250910-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-YIAG-21-0','00038783');
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-09-17','GBRE-YIAG-21-0','GBRE','TOKO','GBRE.BALIK','103.00','6.220','6.220','1','6.220','6.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-01154 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YIAG-21-0','00038783','RD','7','0.155 ','420','65.1');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YIAG-21-0','00038783','RD','18','0.095 ','450','42.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YIAG-21-0','00038783','RD','24','0.805 ','420','338.1');
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-250917-0010','1','GBRE-YIAG-21-0','1','6.220','6.220','TOKO','GBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-YIAG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-09-17','TOKO','SEM-BALIK','GBRE','GBRE-YIAG-21-0','103.00','1','6.220','6.220','1','6.220','6.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.220',berat_out_asli=berat_out_asli+'6.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='GBRE-YIAG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-250917-0010','2025-09-17','2025-09-17','15:34','6.22','input','2025-09-17 15:34:35');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250909-0012';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250909-0012';
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-YIAG-22-0','00038784','ABRE-02091 ','GIWANG ABRE-02091 ','','GR','---','DM','ABRE','TOKO','SEM-BALIK','4873500','2025-09-17','4873500','3.050','83.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:37:17','3.050','0','255.50','16500.00','','TOKO','FREETAG','','10','','','IDB 34 000 000','1','0925','BE-250909-0012','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YIAG-22-0','00038784');
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-09-17','ABRE-YIAG-22-0','ABRE','TOKO','SEM-BALIK','83.00','3.050','3.050','1','3.050','3.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02091 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-22-0','00038784','RD','2','0.080 ','350','28');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YIAG-22-0','00038784','RD','40','0.650 ','350','227.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250909-0010';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250909-0010';
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-YIAG-23-0','00038785','CBRE-06904 ','CINCIN CBRE-06904 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3084000','2025-09-17','3084000','1.930','83.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:41:07','1.930','650000','82.50','16500.00','','TOKO','FREETAG','','10','','','IDB 19 000 000','1','RS 12 5 0925','BE-250909-0010','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-23-0','00038785');
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-09-17','CBRE-YIAG-23-0','CBRE','TOKO','SEM-BALIK','83.00','1.930','1.930','1','1.930','1.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06904 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-23-0','00038785','RD','1','0.050 ','480','24');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-23-0','00038785','RD','16','0.120 ','450','54');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-23-0','00038785','RD','4','0.010 ','450','4.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250908-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250908-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-YIAG-24-0','00038786','CBRE-00950 ','CINCIN CBRE-00950 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4422000','2025-09-17','4422000','2.230','103.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:43:29','2.230','424000','188.55','16500.00','0','TOKO','FREETAG','','10','','0','IDB 30 000 000','4','RS 11 0925','BE-250908-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-24-0','00038786');
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-09-17','CBRE-YIAG-24-0','CBRE','TOKO','CBRE.BALIK','103.00','2.230','2.230','1','2.230','2.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00950 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-24-0','00038786','RD','1','0.090 ','620','55.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-24-0','00038786','RD','2','0.025 ','450','11.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-24-0','00038786','RD','32','0.250 ','450','112.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-24-0','00038786','RD','8','0.020 ','450','9');
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-250917-0011','1','CBRE-YIAG-24-0','1','2.230','2.230','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-YIAG-24-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-24-0','103.00','1','2.230','2.230','1','2.230','2.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.230',berat_out_asli=berat_out_asli+'2.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='CBRE-YIAG-24-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-250917-0011','2025-09-17','2025-09-17','15:43','2.23','input','2025-09-17 15:43:42');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250905-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250905-0005';
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-YIAG-25-0','00038787','CBRE-06905 ','CINCIN CBRE-06905 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3280500','2025-09-17','3280500','2.130','80.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:45:49','2.130','0','133.80','16500.00','','TOKO','FREETAG','','10','','','IDB 20 500 000','1','RS 16 5 0925','BE-250905-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-25-0','00038787');
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-09-17','CBRE-YIAG-25-0','CBRE','TOKO','SEM-BALIK','80.00','2.130','2.130','1','2.130','2.130','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06905 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-25-0','00038787','RD','1','0.015 ','420','6.3');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-25-0','00038787','RD','1','0.170 ','750','127.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250905-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250905-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-YIAG-26-0','00038788','CBRE-06906 ','CINCIN CBRE-06906 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','1342500','2025-09-17','1342500','0.840','83.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:47:58','0.840','490000','51.45','16500.00','','TOKO','FREETAG','','10','','','IDB 10 000 000','1','C1447 12 0925','BE-250905-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-26-0','00038788');
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-09-17','CBRE-YIAG-26-0','CBRE','TOKO','SEM-BALIK','83.00','0.840','0.840','1','0.840','0.840','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06906 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-26-0','00038788','RD','1','0.010 ','420','4.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-26-0','00038788','RD','18','0.105 ','450','47.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250903-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250903-0005';
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-YIAG-27-0','00038789','CBRE-04046 ','CINCIN CBRE-04046 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3768500','2025-09-17','3768500','2.610','75.00','75.00','0','1925000.00','1','0.04', 'input','2025-09-17 15:50:34','2.610','0','125.80','16500.00','0','TOKO','FREETAG','','10','','0','IDB 22 000 000','3','RS 15 0925','BE-250903-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-27-0','00038789');
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-09-17','CBRE-YIAG-27-0','CBRE','TOKO','CBRE.BALIK','75.00','2.610','2.610','1','2.610','2.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04046 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-27-0','00038789','RD','44','0.210 ','370','77.7');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-27-0','00038789','RD','6','0.095 ','370','35.15');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-27-0','00038789','RD','1','0.035 ','370','12.95');
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-250917-0012','1','CBRE-YIAG-27-0','1','2.610','2.610','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-YIAG-27-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-09-17','TOKO','SEM-BALIK','CBRE','CBRE-YIAG-27-0','75.00','1','2.610','2.610','1','2.610','2.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.610',berat_out_asli=berat_out_asli+'2.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-17' AND kode_barang='CBRE-YIAG-27-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-250917-0012','2025-09-17','2025-09-17','15:51','2.61','input','2025-09-17 15:51:09');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250903-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250903-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-YIAG-28-0','00038790','CBR2177 ','CINCIN CBR2177 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2469000','2025-09-17','2469000','1.710','75.00','75','0','1925000.00','1','0.14', 'input','2025-09-17 15:53:15','1.710','0','22.40','16500.00','','TOKO','FREETAG','','10','','','IDB 10 500 000','1','RS 16 0925','BE-250903-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YIAG-28-0','00038790');
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-09-17','CBRE-YIAG-28-0','CBRE','TOKO','SEM-BALIK','75.00','1.710','1.710','1','1.710','1.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR2177 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YIAG-28-0','00038790','RD','7','0.070 ','320','22.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02874';
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 ('PSPLE-YIAG-29-0','00038791','DP-02874 ','CINCIN PALADIUM ','','GR','---','PSPLE','PSPLE','TOKO','PSN','1562000','2025-09-17','1562000','5.070','16.00','25','300000','1925000.00','1','0.04', 'input','2025-09-17 16:06:28','5.070','0','','16500.00','','TOKO','FREETAG','','10','','','PSN02874','1','RS 17','','DP-02874');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLE','PSPLE-YIAG-29-0','00038791');
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-09-17','PSPLE-YIAG-29-0','PSPLE','TOKO','PSN','16.00','5.070','5.070','1','5.070','5.070','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLE','DP-02874 ');
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-01075';
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-YIAG-30-0','00038792','DP-01075MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','844000','2025-09-17','844000','2.740','16.00','25','300000','1925000.00','1','0.14', 'input','2025-09-17 16:09:32','2.740','0','','16500.00','','TOKO','FREETAG','','10','','','PSN01075MM','1','RS 18','','DP-01075');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YIAG-30-0','00038792');
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-09-17','PSPLT-YIAG-30-0','PSPLT','TOKO','MMPSN','16.00','2.740','2.740','1','2.740','2.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01075MM ');
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-01077';
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-YIAG-31-0','00038793','DP-01077MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','653000','2025-09-17','653000','2.120','16.00','25','300000','1925000.00','1','0.14', 'input','2025-09-17 16:11:36','2.120','0','','16500.00','','TOKO','FREETAG','','10','','','PSN01077MM','1','RS 14','','DP-01077');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YIAG-31-0','00038793');
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-09-17','PSPLT-YIAG-31-0','PSPLT','TOKO','MMPSN','16.00','2.120','2.120','1','2.120','2.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01077MM ');
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-01059';
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-YIAG-32-0','00038794','DP-01059BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1552500','2025-09-17','1552500','5.040','16.00','25','300000','1925000.00','1','0.14', 'input','2025-09-17 16:15:19','5.040','0','','16500.00','','TOKO','FREETAG','','10','','','PSN01059BIP','1','RS 23 5','','DP-01059');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YIAG-32-0','00038794');
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-09-17','PSPLT-YIAG-32-0','PSPLT','TOKO','PSNB','16.00','5.040','5.040','1','5.040','5.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01059BIP ');
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-01081';
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-YIAG-33-0','00038795','DP-01081BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','3145000','2025-09-17','3145000','5.270','31.00','50','300000','1925000.00','1','0.14', 'input','2025-09-17 16:17:29','5.270','0','','16500.00','','TOKO','FREETAG','','10','','','PSN01081BIP','1','RS 20','','DP-01081');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YIAG-33-0','00038795');
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-09-17','PSPLT-YIAG-33-0','PSPLT','TOKO','PSNB','31.00','5.270','5.270','1','5.270','5.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01081BIP ');
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 ('PBDG-YIAG-34-0','00038796','1.150K-12-1641 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','65500','2025-09-17','65500','2.620','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-17 16:23:55','2.620','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-YIAG-34-0','00038796');
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-09-17','PBDG-YIAG-34-0','PBDG','TOKO','PBDG','100.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','1.150K-12-1641 ');
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 ('PBDG-YIAG-35-0','00038797','1.150K-9-1642 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','62500','2025-09-17','62500','2.500','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-17 16:24:23','2.500','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-YIAG-35-0','00038797');
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-09-17','PBDG-YIAG-35-0','PBDG','TOKO','PBDG','100.00','2.500','2.500','1','2.500','2.500','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','1.150K-9-1642 ');
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 ('PBDG-YIAG-36-0','00038798','1.150K-7-1643 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','60500','2025-09-17','60500','2.420','100.00','925','150000','25000.00','1','0.14', 'input','2025-09-17 16:25:01','2.420','0','','16500.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-YIAG-36-0','00038798');
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-09-17','PBDG-YIAG-36-0','PBDG','TOKO','PBDG','100.00','2.420','2.420','1','2.420','2.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','1.150K-7-1643 ');