INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-17 ','08:09:14'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-17','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-17'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-16'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-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='2026-11-16' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-16'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-16'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-16'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-16'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-17' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-16' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-17'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-17 ','08:10:31'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261101-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261101-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 ('LBRE-ZKAG-1-0','00049497','LBRE-00064 ','LIONTIN LBRE-00064 ','','GR','---','DM','LBRE','TOKO','SEMLBR','1422500','2026-11-17','1422500','0.750','83.00','75.00','0','2285000.00','1','0.04', 'input','2026-11-17 09:01:40','0.750','0','106.00','18200.00','','TOKO','FREETAG','','10','','0','IDB 13 000 000','2','3B1 1126','BE-261101-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZKAG-1-0','00049497'); 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 ('2026-11-17','LBRE-ZKAG-1-0','LBRE','TOKO','SEMLBR','83.00','0.750','0.750','1','0.750','0.750','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00064 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZKAG-1-0','00049497','RD','1','0.140 ','620','86.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZKAG-1-0','00049497','RD','16','0.060 ','320','19.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-261117-0001','1','LBRE-ZKAG-1-0','1','0.750','0.750','TOKO','SEMLBR','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZKAG-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEMLBR'; 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('2026-11-17','TOKO','SEM-BALIK','LBRE','LBRE-ZKAG-1-0','83.00','1','0.750','0.750','1','0.750','0.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.750',berat_out_asli=berat_out_asli+'0.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='LBRE-ZKAG-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEMLBR' 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-261117-0001','2026-11-17','2026-11-17','09:01','0.75','input','2026-11-17 09:01:56'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261101-0001'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261101-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 ('TFA-ZKAG-2-0','00049498','TFA-21015 ','ANTING TFA-21015 ','','GR','---','DM','TFA','TOKO','TFA','5296000','2026-11-17','5296000','3.090','75.00','75','0','2285000.00','1','0.04', 'input','2026-11-17 09:04:58','3.090','0','284.00','18200.00','','TOKO','FREETAG','','10','','0','IDB 37 500 000','2','9B45 1126','FB-261101-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'TFA' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFA','TFA-ZKAG-2-0','00049498'); 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 ('2026-11-17','TFA-ZKAG-2-0','TFA','TOKO','TFA','75.00','3.090','3.090','1','3.090','3.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFA'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFA','TFA-21015 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFA-ZKAG-2-0','00049498','RD','10','0.560 ','450','252'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFA-ZKAG-2-0','00049498','RD','20','0.100 ','320','32'); 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-261117-0002','1','TFA-ZKAG-2-0','1','3.090','3.090','TOKO','TFA','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFA-ZKAG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFA'; 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('2026-11-17','TOKO','SEM-BALIK','TFA','TFA-ZKAG-2-0','75.00','1','3.090','3.090','1','3.090','3.090'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.090',berat_out_asli=berat_out_asli+'3.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='TFA-ZKAG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFA' 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-261117-0002','2026-11-17','2026-11-17','09:05','3.09','input','2026-11-17 09:05:13'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261102-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261102-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 ('LBRE-ZKAG-3-0','00049499','LBRE-00475 ','LIONTIN LBRE-00475 ','','GR','---','DM','LBRE','TOKO','LBRE','1971000','2026-11-17','1971000','1.150','75.00','75','0','2285000.00','1','0.04', 'input','2026-11-17 09:07:40','1.150','0','47.80','18200.00','','TOKO','FREETAG','','10','','0','IDB 11 000 000','2','1B9 1126','BE-261102-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZKAG-3-0','00049499'); 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 ('2026-11-17','LBRE-ZKAG-3-0','LBRE','TOKO','LBRE','75.00','1.150','1.150','1','1.150','1.150','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00475 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZKAG-3-0','00049499','SP','1','0.380 ','50','19'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZKAG-3-0','00049499','RD','16','0.090 ','320','28.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-261117-0003','1','LBRE-ZKAG-3-0','1','1.150','1.150','TOKO','LBRE','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZKAG-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE'; 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('2026-11-17','TOKO','SEM-BALIK','LBRE','LBRE-ZKAG-3-0','75.00','1','1.150','1.150','1','1.150','1.150'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.150',berat_out_asli=berat_out_asli+'1.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='LBRE-ZKAG-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' 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-261117-0003','2026-11-17','2026-11-17','09:07','1.15','input','2026-11-17 09:07:56'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261102-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261102-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-ZKAG-4-0','00049500','CBRE-07046 ','CINCIN CBRE-07046 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1062500','2026-11-17','1062500','0.560','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-17 09:09:33','0.560','100000','12.60','18200.00','','TOKO','FREETAG','','10','','0','IDB 5 500 000','2','RS11 1B4 1126','BE-261102-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAG-4-0','00049500'); 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 ('2026-11-17','CBRE-ZKAG-4-0','CBRE','TOKO','CBRE.BALIK','83.00','0.560','0.560','1','0.560','0.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07046 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-4-0','00049500','RD','1','0.030 ','420','12.6'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261117-0004','1','CBRE-ZKAG-4-0','1','0.560','0.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-ZKAG-4-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('2026-11-17','TOKO','SEM-BALIK','CBRE','CBRE-ZKAG-4-0','83.00','1','0.560','0.560','1','0.560','0.560'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.560',berat_out_asli=berat_out_asli+'0.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='CBRE-ZKAG-4-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-261117-0004','2026-11-17','2026-11-17','09:09','0.56','input','2026-11-17 09:09:51'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261102-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261102-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-ZKAG-5-0','00049501','CBRE-06580 ','CINCIN CBRE-06580 ','','GR','---','DM','CBRE','TOKO','CBRE','3319000','2026-11-17','3319000','1.750','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-17 09:11:22','1.750','570000','165.90','18200.00','','TOKO','FREETAG','','10','','0','IDB 26 500 000','2','RS115 7B15 1126','BE-261102-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAG-5-0','00049501'); 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 ('2026-11-17','CBRE-ZKAG-5-0','CBRE','TOKO','CBRE','83.00','1.750','1.750','1','1.750','1.750','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06580 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-5-0','00049501','RD','35','0.395 ','420','165.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-261117-0005','1','CBRE-ZKAG-5-0','1','1.750','1.750','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-ZKAG-5-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('2026-11-17','TOKO','SEM-BALIK','CBRE','CBRE-ZKAG-5-0','83.00','1','1.750','1.750','1','1.750','1.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.750',berat_out_asli=berat_out_asli+'1.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='CBRE-ZKAG-5-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-261117-0005','2026-11-17','2026-11-17','09:11','1.75','input','2026-11-17 09:11:36'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261103-0003'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261103-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-ZKAG-6-0','00049502','CBR0355 ','CINCIN CBR0355 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4610500','2026-11-17','4610500','2.690','75.00','75','0','2285000.00','1','0.04', 'input','2026-11-17 09:14:04','2.690','0','400.80','18200.00','','TOKO','FREETAG','','10','','0','IDB 42 500 000','2','RS155 11B15 112','BE-261103-0003',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAG-6-0','00049502'); 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 ('2026-11-17','CBRE-ZKAG-6-0','CBRE','TOKO','CBRE.BALIK','75.00','2.690','2.690','1','2.690','2.690','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR0355 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-6-0','00049502','RD','34','0.150 ','320','48'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-6-0','00049502','PD','6','0.090 ','420','37.8'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-6-0','00049502','RD','1','0.300 ','1050','315'); 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-261117-0006','1','CBRE-ZKAG-6-0','1','2.690','2.690','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-ZKAG-6-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('2026-11-17','TOKO','SEM-BALIK','CBRE','CBRE-ZKAG-6-0','75.00','1','2.690','2.690','1','2.690','2.690'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.690',berat_out_asli=berat_out_asli+'2.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='CBRE-ZKAG-6-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-261117-0006','2026-11-17','2026-11-17','09:14','2.69','input','2026-11-17 09:14:17'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261103-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261103-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-ZKAG-7-0','00049503','CBRE-01689 ','CINCIN CBRE-01689 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3860000','2026-11-17','3860000','1.640','103.00','75.00','0','2285000.00','1','0.04', 'input','2026-11-17 09:15:48','1.640','100000','182.25','18200.00','0','TOKO','FREETAG','','10','','0','IDB 27 000 000','6','RS14 7B2 1126','BE-261103-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAG-7-0','00049503'); 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 ('2026-11-17','CBRE-ZKAG-7-0','CBRE','TOKO','CBRE.BALIK','103.00','1.640','1.640','1','1.640','1.640','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01689 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-7-0','00049503','RD','7','0.330 ','450','148.5'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAG-7-0','00049503','RD','28','0.075 ','450','33.75'); 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-261117-0007','1','CBRE-ZKAG-7-0','1','1.640','1.640','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-ZKAG-7-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('2026-11-17','TOKO','SEM-BALIK','CBRE','CBRE-ZKAG-7-0','103.00','1','1.640','1.640','1','1.640','1.640'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.640',berat_out_asli=berat_out_asli+'1.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-17' AND kode_barang='CBRE-ZKAG-7-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-261117-0007','2026-11-17','2026-11-17','09:15','1.64','input','2026-11-17 09:16:03');