INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','08:14:23');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-24';
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-04-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-24' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-25';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','08:21:27');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-25';
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-04-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-26';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','08:21:49');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-26';
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-04-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-04-27';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','08:22:08');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260329-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260329-0004';
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-ZDBG-1-0','00042776','CBRE-03393 ','CBRE-03393 GIA 6412966702 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','6591000','2026-04-27','6591000','3.380','75.00','75.00','0','2600000.00','1','0.04', 'input','2026-04-27 09:24:29','3.380','0','325.80','17000.00','0','TOKO','FREETAG','','10','','0','IDB 43 500 000','4','DIF 10B45 0326','BE-260329-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZDBG-1-0','00042776');
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-04-27','CBRE-ZDBG-1-0','CBRE','TOKO','CBRE.BALIK','75.00','3.380','3.380','1','3.380','3.380','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03393 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZDBG-1-0','00042776','RD','12','0.040 ','320','12.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZDBG-1-0','00042776','RD','54','0.275 ','320','88');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZDBG-1-0','00042776','RD','1','0.150 ','1500','225');
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-260427-0001','1','CBRE-ZDBG-1-0','1','3.380','3.380','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-ZDBG-1-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-04-27','TOKO','SEM-BALIK','CBRE','CBRE-ZDBG-1-0','75.00','1','3.380','3.380','1','3.380','3.380');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.380',berat_out_asli=berat_out_asli+'3.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='CBRE-ZDBG-1-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-260427-0001','2026-04-27','2026-04-27','09:24','3.38','input','2026-04-27 09:24:47');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260419-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260419-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-ZDBG-2-0','00042777','CBRE-05875 ','CINCIN CBRE-05875 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1273500','2026-04-27','1273500','0.590','83.00','75','0','2600000.00','1','0.04', 'input','2026-04-27 09:26:44','0.590','0','47.25','17000.00','','TOKO','FREETAG','','10','','0','IDB 8 000 000','4','RS 10 0426','BE-260419-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZDBG-2-0','00042777');
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-04-27','CBRE-ZDBG-2-0','CBRE','TOKO','CBRE.BALIK','83.00','0.590','0.590','1','0.590','0.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05875 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZDBG-2-0','00042777','RD','15','0.105 ','450','47.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-260427-0002','1','CBRE-ZDBG-2-0','1','0.590','0.590','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-ZDBG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','SEM-BALIK','CBRE','CBRE-ZDBG-2-0','83.00','1','0.590','0.590','1','0.590','0.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.590',berat_out_asli=berat_out_asli+'0.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='CBRE-ZDBG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260427-0002','2026-04-27','2026-04-27','09:26','0.59','input','2026-04-27 09:27:00');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260420-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260420-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 ('KLBE-ZDBG-3-0','00042778','KLBE-00836 ','KALUNG KLBE-00836 ','','GR','---','DM','KLBE','TOKO','KLBE.BALIK','5850000','2026-04-27','5850000','3.000','75.00','75','0','2600000.00','1','0.04', 'input','2026-04-27 09:28:58','3.000','0','41.60','17000.00','','TOKO','FREETAG','','10','','0','IDB 24 500 000','2','5B85 0426','BE-260420-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZDBG-3-0','00042778');
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-04-27','KLBE-ZDBG-3-0','KLBE','TOKO','KLBE.BALIK','75.00','3.000','3.000','1','3.000','3.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00836 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZDBG-3-0','00042778','RD','16','0.130 ','320','41.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-260427-0003','1','KLBE-ZDBG-3-0','1','3.000','3.000','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-ZDBG-3-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('2026-04-27','TOKO','SEM-BALIK','KLBE','KLBE-ZDBG-3-0','75.00','1','3.000','3.000','1','3.000','3.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.000',berat_out_asli=berat_out_asli+'3.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='KLBE-ZDBG-3-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-260427-0003','2026-04-27','2026-04-27','09:29','3','input','2026-04-27 09:29:15');
DELETE FROM tm_berlian WHERE kode_barang='CBRE-ZDBG-2-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRE-ZDBG-2-0','CBRE-ZDBG-2-0','00042777','RD','15','0.105','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRE-ZDBG-2-0','00042777','RD','15','0.105','450','47.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CBRE-ZDBG-2-0','00042777','00042777','CINCIN CBRE-05875 ','CINCIN CBRE-05875','','','1273500','1273500',' 0','0','input','2026-04-27 09:29:47');
UPDATE tm_barang SET nama_barang='CINCIN CBRE-05875' ,nama_atribut='' ,kode_intern='CBRE-05875 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS10 2B1 0426',total_usd_ext='IDB 8 000 000',total_usd='47.25' WHERE kode_barang='CBRE-ZDBG-2-0' LIMIT 1;
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260422-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260422-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-ZDBG-4-0','00042779','GBRE-00697 ','GELANG GBRE-00697 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','11154000','2026-04-27','11154000','5.720','75.00','75.00','0','2600000.00','1','0.04', 'input','2026-04-27 09:31:36','5.720','0','208.00','17000.00','0','TOKO','FREETAG','','10','','0','IDB 52 500 000','3','13B6 0426','BE-260422-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZDBG-4-0','00042779');
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-04-27','GBRE-ZDBG-4-0','GBRE','TOKO','GBRE.BALIK','75.00','5.720','5.720','1','5.720','5.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00697 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZDBG-4-0','00042779','RD','19','0.650 ','320','208');
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-260427-0004','1','GBRE-ZDBG-4-0','1','5.720','5.720','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-ZDBG-4-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('2026-04-27','TOKO','SEM-BALIK','GBRE','GBRE-ZDBG-4-0','75.00','1','5.720','5.720','1','5.720','5.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.720',berat_out_asli=berat_out_asli+'5.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='GBRE-ZDBG-4-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-260427-0004','2026-04-27','2026-04-27','09:31','5.72','input','2026-04-27 09:31:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260417-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260417-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 ('BDCM-ZDBG-5-0','00042780','950K-105 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','SEM-EMAS','2796000','2026-04-27','2796000','2.240','48.00','375','470000','2600000.00','1','0.14', 'input','2026-04-27 09:59:32','2.240','0','','17000.00','','TOKO','FREETAG','','2','','','','','','BE-260417-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZDBG-5-0','00042780');
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-04-27','BDCM-ZDBG-5-0','BDCM','TOKO','SEM-EMAS','48.00','2.240','2.240','1','2.240','2.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','950K-105 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260418-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260418-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 ('BDCM-ZDBG-6-0','00042781','750K-145 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','SEM-EMAS','3260500','2026-04-27','3260500','1.650','76.00','75','0','2600000.00','1','0.14', 'input','2026-04-27 10:02:01','1.650','0','','17000.00','','TOKO','FREETAG','','2','','','','','','FB-260418-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZDBG-6-0','00042781');
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-04-27','BDCM-ZDBG-6-0','BDCM','TOKO','SEM-EMAS','76.00','1.650','1.650','1','1.650','1.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','750K-145 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260419-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260419-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 ('BDCM-ZDBG-7-0','00042782','700K-175 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','SEM-EMAS','5829500','2026-04-27','5829500','2.950','76.00','75','0','2600000.00','1','0.14', 'input','2026-04-27 10:03:32','2.950','0','','17000.00','','TOKO','FREETAG','','2','','','','','','FB-260419-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZDBG-7-0','00042782');
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-04-27','BDCM-ZDBG-7-0','BDCM','TOKO','SEM-EMAS','76.00','2.950','2.950','1','2.950','2.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='BDCM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','700K-175 ');
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-01851';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZDBG-8-0','00042783','DP-01851BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SEM-PSN','228500','2026-04-27','228500','2.280','100.00','925','250000','100000.00','1','0.14', 'input','2026-04-27 10:46:25','2.280','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01851BIP','1','RS 10','','DP-01851');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZDBG-8-0','00042783');
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-04-27','PSPRT-ZDBG-8-0','PSPRT','TOKO','SEM-PSN','100.00','2.280','2.280','1','2.280','2.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01851BIP ');
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-01852';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZDBG-9-0','00042784','DP-01852BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SEM-PSN','316000','2026-04-27','316000','3.160','100.00','925','250000','100000.00','1','0.14', 'input','2026-04-27 10:48:00','3.160','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01852BIP','1','RS 20','','DP-01852');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZDBG-9-0','00042784');
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-04-27','PSPRT-ZDBG-9-0','PSPRT','TOKO','SEM-PSN','100.00','3.160','3.160','1','3.160','3.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01852BIP ');
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-01856';
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-ZDBG-10-0','00042785','DP-01856BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','588000','2026-04-27','588000','2.880','17.00','10','360000','1200000.00','1','0.14', 'input','2026-04-27 10:50:03','2.880','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01856BIP','1','RS 2 5','','DP-01856');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-10-0','00042785');
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-04-27','PSPLT-ZDBG-10-0','PSPLT','TOKO','SEM-PSN','17.00','2.880','2.880','1','2.880','2.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01856BIP ');
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-01858';
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-ZDBG-11-0','00042786','DP-01858BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','461500','2026-04-27','461500','2.260','17.00','10','640000','1200000.00','1','0.14', 'input','2026-04-27 10:51:41','2.260','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01858BIP','1','RS 13 5','','DP-01858');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-11-0','00042786');
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-04-27','PSPLT-ZDBG-11-0','PSPLT','TOKO','SEM-PSN','17.00','2.260','2.260','1','2.260','2.260','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01858BIP ');
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-01861';
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-ZDBG-12-0','00042787','DP-01861BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','410500','2026-04-27','410500','2.010','17.00','10','560000','1200000.00','1','0.14', 'input','2026-04-27 10:53:31','2.010','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01861BIP','1','RS 8','','DP-01861');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-12-0','00042787');
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-04-27','PSPLT-ZDBG-12-0','PSPLT','TOKO','SEM-PSN','17.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01861BIP ');
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-01862';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZDBG-13-0','00042788','DP-01862BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SEM-PSN','317000','2026-04-27','317000','3.170','100.00','925','280000','100000.00','1','0.14', 'input','2026-04-27 10:55:29','3.170','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01862BIP','1','RS 18','','DP-01862');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZDBG-13-0','00042788');
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-04-27','PSPRT-ZDBG-13-0','PSPRT','TOKO','SEM-PSN','100.00','3.170','3.170','1','3.170','3.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01862BIP ');
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-01863';
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-ZDBG-14-0','00042789','DP-01863BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','298000','2026-04-27','298000','1.460','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 10:59:33','1.460','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01863BIP','1','','','DP-01863');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-14-0','00042789');
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-04-27','PSPLT-ZDBG-14-0','PSPLT','TOKO','SEM-PSN','17.00','1.460','1.460','1','1.460','1.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01863BIP ');
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-01864';
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-ZDBG-15-0','00042790','DP-01864BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','649000','2026-04-27','649000','3.180','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 11:01:41','3.180','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01864BIP','1','RS 17','','DP-01864');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-15-0','00042790');
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-04-27','PSPLT-ZDBG-15-0','PSPLT','TOKO','SEM-PSN','17.00','3.180','3.180','1','3.180','3.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01864BIP ');
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-01865';
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-ZDBG-16-0','00042791','DP-01865BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SEM-PSN','2458500','2026-04-27','2458500','1.630','58.00','50','530000','2600000.00','1','0.14', 'input','2026-04-27 11:03:41','1.630','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01865BIP','1','RS 9 5','','DP-01865');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-16-0','00042791');
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-04-27','PSGT-ZDBG-16-0','PSGT','TOKO','SEM-PSN','58.00','1.630','1.630','1','1.630','1.630','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01865BIP ');
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-01866';
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-ZDBG-17-0','00042792','DP-01866BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','498000','2026-04-27','498000','2.440','17.00','10','350000','1200000.00','1','0.14', 'input','2026-04-27 11:05:23','2.440','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01866BIP','1','RS 13','','DP-01866');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-17-0','00042792');
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-04-27','PSPLT-ZDBG-17-0','PSPLT','TOKO','SEM-PSN','17.00','2.440','2.440','1','2.440','2.440','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01866BIP ');
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-01867';
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-ZDBG-18-0','00042793','DP-01867BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','455000','2026-04-27','455000','2.230','17.00','10','450000','1200000.00','1','0.14', 'input','2026-04-27 11:07:08','2.230','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01867BIP','1','RS 20','','DP-01867');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-18-0','00042793');
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-04-27','PSPLT-ZDBG-18-0','PSPLT','TOKO','SEM-PSN','17.00','2.230','2.230','1','2.230','2.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01867BIP ');
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-01868';
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-ZDBG-19-0','00042794','DP-01868BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','447000','2026-04-27','447000','2.190','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 11:08:30','2.190','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01868BIP','1','RS 15 5','','DP-01868');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-19-0','00042794');
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-04-27','PSPLT-ZDBG-19-0','PSPLT','TOKO','SEM-PSN','17.00','2.190','2.190','1','2.190','2.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01868BIP ');
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-01877';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZDBG-20-0','00042795','DP-01877MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SEM-PSN','187000','2026-04-27','187000','1.870','100.00','925','250000','100000.00','1','0.14', 'input','2026-04-27 11:10:11','1.870','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01877MM','1','RS 10','','DP-01877');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZDBG-20-0','00042795');
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-04-27','PSPRT-ZDBG-20-0','PSPRT','TOKO','SEM-PSN','100.00','1.870','1.870','1','1.870','1.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01877MM ');
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-01902';
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-ZDBG-21-0','00042796','DP-01902BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SEM-PSN','2633500','2026-04-27','2633500','2.110','48.00','375','530000','2600000.00','1','0.14', 'input','2026-04-27 11:11:45','2.110','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01902BIP','1','RS 20','','DP-01902');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-21-0','00042796');
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-04-27','PSGT-ZDBG-21-0','PSGT','TOKO','SEM-PSN','48.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01902BIP ');
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-01908';
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-ZDBG-22-0','00042797','DP-01908BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SEM-PSN','3949500','2026-04-27','3949500','1.830','83.00','75','430000','2600000.00','1','0.14', 'input','2026-04-27 11:13:24','1.830','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01908','1','RS 11','','DP-01908');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-22-0','00042797');
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-04-27','PSGT-ZDBG-22-0','PSGT','TOKO','SEM-PSN','83.00','1.830','1.830','1','1.830','1.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01908BIP ');
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-01934';
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-ZDBG-23-0','00042798','DP-01934BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SEM-PSN','2398000','2026-04-27','2398000','1.590','58.00','50','350000','2600000.00','1','0.14', 'input','2026-04-27 11:16:15','1.590','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01934BIP','1','RS 13','','DP-01934');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-23-0','00042798');
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-04-27','PSGT-ZDBG-23-0','PSGT','TOKO','SEM-PSN','58.00','1.590','1.590','1','1.590','1.590','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01934BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','13:06:04');
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-02973';
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 ('PSBRE-ZDBG-24-0','00042799','DP-02973 ','CINCIN BERLIAN ','','GR','---','PSBRE','PSBRE','TOKO','SEM-PSN','7208000','2026-04-27','7208000','3.340','83.00','75','0','2600000.00','1','0.14', 'input','2026-04-27 13:13:19','3.340','350000','33.75','17000.00','','TOKO','FREETAG','','10','','','PSN02973','1','RS 20 5','','DP-02973');
DELETE FROM tp_barang WHERE kode_dept = 'PSBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSBRE','PSBRE-ZDBG-24-0','00042799');
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-04-27','PSBRE-ZDBG-24-0','PSBRE','TOKO','SEM-PSN','83.00','3.340','3.340','1','3.340','3.340','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSBRE','DP-02973 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('PSBRE-ZDBG-24-0','00042799','RD','17','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-260427-0005','1','PSBRE-ZDBG-24-0','1','3.340','3.340','TOKO','SEM-PSN','TOKO','PSN');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSN' WHERE kode_barang='PSBRE-ZDBG-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSN','PSBRE','PSBRE-ZDBG-24-0','83.00','1','3.340','3.340','1','3.340','3.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.340',berat_out_asli=berat_out_asli+'3.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSBRE-ZDBG-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260427-0005','2026-04-27','2026-04-27','13:14','3.34','input','2026-04-27 13:14:57');
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-260427-0006','1','PSPRT-ZDBG-20-0','1','1.870','1.870','TOKO','SEM-PSN','TOKO','MMPSN');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPSN' WHERE kode_barang='PSPRT-ZDBG-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','MMPSN','PSPRT','PSPRT-ZDBG-20-0','100.00','1','1.870','1.870','1','1.870','1.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.870',berat_out_asli=berat_out_asli+'1.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPRT-ZDBG-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260427-0006','2026-04-27','2026-04-27','13:15','1.87','input','2026-04-27 13:15:22');
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-260427-0007','1','PSPRT-ZDBG-8-0','1','2.280','2.280','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPRT-ZDBG-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPRT','PSPRT-ZDBG-8-0','100.00','1','2.280','2.280','1','2.280','2.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPRT-ZDBG-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','2','PSPRT-ZDBG-9-0','1','3.160','3.160','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPRT-ZDBG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPRT','PSPRT-ZDBG-9-0','100.00','1','3.160','3.160','1','3.160','3.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.160',berat_out_asli=berat_out_asli+'3.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPRT-ZDBG-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','3','PSPLT-ZDBG-10-0','1','2.880','2.880','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-10-0','17.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='2026-04-27' AND kode_barang='PSPLT-ZDBG-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','4','PSPLT-ZDBG-11-0','1','2.260','2.260','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-11-0','17.00','1','2.260','2.260','1','2.260','2.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.260',berat_out_asli=berat_out_asli+'2.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','5','PSPLT-ZDBG-12-0','1','2.010','2.010','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-12-0','17.00','1','2.010','2.010','1','2.010','2.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','6','PSPRT-ZDBG-13-0','1','3.170','3.170','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPRT-ZDBG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPRT','PSPRT-ZDBG-13-0','100.00','1','3.170','3.170','1','3.170','3.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.170',berat_out_asli=berat_out_asli+'3.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPRT-ZDBG-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','7','PSPLT-ZDBG-14-0','1','1.460','1.460','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-14-0','17.00','1','1.460','1.460','1','1.460','1.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.460',berat_out_asli=berat_out_asli+'1.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','8','PSPLT-ZDBG-15-0','1','3.180','3.180','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-15-0','17.00','1','3.180','3.180','1','3.180','3.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.180',berat_out_asli=berat_out_asli+'3.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','9','PSGT-ZDBG-16-0','1','1.630','1.630','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSGT-ZDBG-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSGT','PSGT-ZDBG-16-0','58.00','1','1.630','1.630','1','1.630','1.630');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.630',berat_out_asli=berat_out_asli+'1.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSGT-ZDBG-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','10','PSPLT-ZDBG-17-0','1','2.440','2.440','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-17-0','17.00','1','2.440','2.440','1','2.440','2.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.440',berat_out_asli=berat_out_asli+'2.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','11','PSPLT-ZDBG-18-0','1','2.230','2.230','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-18-0','17.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='2026-04-27' AND kode_barang='PSPLT-ZDBG-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','12','PSPLT-ZDBG-19-0','1','2.190','2.190','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-19-0','17.00','1','2.190','2.190','1','2.190','2.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.190',berat_out_asli=berat_out_asli+'2.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','13','PSGT-ZDBG-21-0','1','2.110','2.110','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSGT-ZDBG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSGT','PSGT-ZDBG-21-0','48.00','1','2.110','2.110','1','2.110','2.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.110',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSGT-ZDBG-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','14','PSGT-ZDBG-22-0','1','1.830','1.830','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSGT-ZDBG-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSGT','PSGT-ZDBG-22-0','83.00','1','1.830','1.830','1','1.830','1.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.830',berat_out_asli=berat_out_asli+'1.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSGT-ZDBG-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0007','15','PSGT-ZDBG-23-0','1','1.590','1.590','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSGT-ZDBG-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSGT','PSGT-ZDBG-23-0','58.00','1','1.590','1.590','1','1.590','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.590',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSGT-ZDBG-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260427-0007','2026-04-27','2026-04-27','13:15','34.42','input','2026-04-27 13:16:20');
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-ZDBG-25-0','00042800','800K-16-2513 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','SEM-EMAS','383000','2026-04-27','383000','3.830','100.00','925','210000','100000.00','1','0.14', 'input','2026-04-27 13:28:33','3.830','0','','17000.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-ZDBG-25-0','00042800');
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-04-27','PBDG-ZDBG-25-0','PBDG','TOKO','SEM-EMAS','100.00','3.830','3.830','1','3.830','3.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-16-2513 ');
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-260427-0008','1','BDCM-ZDBG-5-0','1','2.240','2.240','TOKO','SEM-EMAS','TOKO','CMBD');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMBD' WHERE kode_barang='BDCM-ZDBG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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-04-27','TOKO','CMBD','BDCM','BDCM-ZDBG-5-0','48.00','1','2.240','2.240','1','2.240','2.240');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.240',berat_out_asli=berat_out_asli+'2.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='BDCM-ZDBG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0008','2','BDCM-ZDBG-6-0','1','1.650','1.650','TOKO','SEM-EMAS','TOKO','CMBD');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMBD' WHERE kode_barang='BDCM-ZDBG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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-04-27','TOKO','CMBD','BDCM','BDCM-ZDBG-6-0','76.00','1','1.650','1.650','1','1.650','1.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.650',berat_out_asli=berat_out_asli+'1.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='BDCM-ZDBG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0008','3','BDCM-ZDBG-7-0','1','2.950','2.950','TOKO','SEM-EMAS','TOKO','CMBD');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMBD' WHERE kode_barang='BDCM-ZDBG-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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-04-27','TOKO','CMBD','BDCM','BDCM-ZDBG-7-0','76.00','1','2.950','2.950','1','2.950','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.950',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='BDCM-ZDBG-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260427-0008','2026-04-27','2026-04-27','13:29','6.84','input','2026-04-27 13:29:23');
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-260427-0009','1','PBDG-ZDBG-25-0','1','3.830','3.830','TOKO','SEM-EMAS','TOKO','PBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PBDG' WHERE kode_barang='PBDG-ZDBG-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
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-04-27','TOKO','PBDG','PBDG','PBDG-ZDBG-25-0','100.00','1','3.830','3.830','1','3.830','3.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.830',berat_out_asli=berat_out_asli+'3.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PBDG-ZDBG-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260427-0009','2026-04-27','2026-04-27','13:29','3.83','input','2026-04-27 13:29:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','13:33:55');
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-01849';
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-ZDBG-26-0','00042801','DP-01849BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SEM-PSN','794000','2026-04-27','794000','3.890','17.00','10','320000','1200000.00','1','0.14', 'input','2026-04-27 14:18:11','3.890','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01849BIP','1','RS 21','','DP-01849');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-26-0','00042801');
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-04-27','PSPLT-ZDBG-26-0','PSPLT','TOKO','SEM-PSN','17.00','3.890','3.890','1','3.890','3.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01849BIP ');
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-01870';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZDBG-27-0','00042802','DP-01870BIP ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SEM-PSN','516000','2026-04-27','516000','5.160','100.00','925','500000','100000.00','1','0.14', 'input','2026-04-27 14:21:03','5.160','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01870BIP','1','RS 15 RS 17','','DP-01870');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZDBG-27-0','00042802');
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-04-27','PSPRT-ZDBG-27-0','PSPRT','TOKO','SEM-PSN','100.00','5.160','5.160','1','5.160','5.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01870BIP ');
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-01884';
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-ZDBG-28-0','00042803','DP-01884BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SEM-PSN','8481000','2026-04-27','8481000','3.930','83.00','75','250000','2600000.00','1','0.14', 'input','2026-04-27 14:22:55','3.930','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01884BIP','1','RS 17','','DP-01884');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-28-0','00042803');
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-04-27','PSGT-ZDBG-28-0','PSGT','TOKO','SEM-PSN','83.00','3.930','3.930','1','3.930','3.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01884BIP ');
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-01918';
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-ZDBG-29-0','00042804','DP-01918BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SEM-PSN','4424000','2026-04-27','4424000','2.050','83.00','75','250000','2600000.00','1','0.14', 'input','2026-04-27 14:24:17','2.050','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01918BIP','1','RS 6','','DP-01918');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-29-0','00042804');
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-04-27','PSGT-ZDBG-29-0','PSGT','TOKO','SEM-PSN','83.00','2.050','2.050','1','2.050','2.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01918BIP ');
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-260427-0010','1','PSPLT-ZDBG-26-0','1','3.890','3.890','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPLT-ZDBG-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPLT','PSPLT-ZDBG-26-0','17.00','1','3.890','3.890','1','3.890','3.890');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.890',berat_out_asli=berat_out_asli+'3.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPLT-ZDBG-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0010','2','PSPRT-ZDBG-27-0','1','5.160','5.160','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSPRT-ZDBG-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSPRT','PSPRT-ZDBG-27-0','100.00','1','5.160','5.160','1','5.160','5.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.160',berat_out_asli=berat_out_asli+'5.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSPRT-ZDBG-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0010','3','PSGT-ZDBG-28-0','1','3.930','3.930','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSGT-ZDBG-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSGT','PSGT-ZDBG-28-0','83.00','1','3.930','3.930','1','3.930','3.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.930',berat_out_asli=berat_out_asli+'3.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSGT-ZDBG-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260427-0010','4','PSGT-ZDBG-29-0','1','2.050','2.050','TOKO','SEM-PSN','TOKO','PSNB');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PSNB' WHERE kode_barang='PSGT-ZDBG-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-27','TOKO','PSNB','PSGT','PSGT-ZDBG-29-0','83.00','1','2.050','2.050','1','2.050','2.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.050',berat_out_asli=berat_out_asli+'2.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-27' AND kode_barang='PSGT-ZDBG-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260427-0010','2026-04-27','2026-04-27','14:24','15.03','input','2026-04-27 14:25:02');
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-01850';
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-ZDBG-30-0','00042805','DP-01850BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','506000','2026-04-27','506000','2.480','17.00','10','640000','1200000.00','1','0.14', 'input','2026-04-27 15:59:34','2.480','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01850BIP','1','RS 18 5','','DP-01850');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-30-0','00042805');
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-04-27','PSPLT-ZDBG-30-0','PSPLT','TOKO','PSNB','17.00','2.480','2.480','1','2.480','2.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01850BIP ');
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-01855';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZDBG-31-0','00042806','DP-01855BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','232500','2026-04-27','232500','2.320','100.00','925','250000','100000.00','1','0.14', 'input','2026-04-27 16:01:06','2.320','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01855BIP','1','RS 18','','DP-01855');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZDBG-31-0','00042806');
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-04-27','PSPRT-ZDBG-31-0','PSPRT','TOKO','PSNB','100.00','2.320','2.320','1','2.320','2.320','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01855BIP ');
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-01859';
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-ZDBG-32-0','00042807','DP-01859BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1018000','2026-04-27','1018000','4.990','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 16:02:27','4.990','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01859BIP','1','RS 21','','DP-01859');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-32-0','00042807');
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-04-27','PSPLT-ZDBG-32-0','PSPLT','TOKO','PSNB','17.00','4.990','4.990','1','4.990','4.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01859BIP ');
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-01888';
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-ZDBG-33-0','00042808','DP-01888BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','785500','2026-04-27','785500','3.850','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 16:03:48','3.850','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01888BIP','1','RS 13','','DP-01888');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-33-0','00042808');
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-04-27','PSPLT-ZDBG-33-0','PSPLT','TOKO','PSNB','17.00','3.850','3.850','1','3.850','3.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01888BIP ');
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-01889';
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-ZDBG-34-0','00042809','DP-01889BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','396000','2026-04-27','396000','1.940','17.00','10','430000','1200000.00','1','0.14', 'input','2026-04-27 16:05:28','1.940','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01889BIP','1','RS 12','','DP-01889');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-34-0','00042809');
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-04-27','PSPLT-ZDBG-34-0','PSPLT','TOKO','PSNB','17.00','1.940','1.940','1','1.940','1.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01889BIP ');
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-01892';
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-ZDBG-35-0','00042810','DP-01892BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','616500','2026-04-27','616500','3.020','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 16:06:47','3.020','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01892BIP','1','RS 15 5','','DP-01892');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-35-0','00042810');
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-04-27','PSPLT-ZDBG-35-0','PSPLT','TOKO','PSNB','17.00','3.020','3.020','1','3.020','3.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01892BIP ');
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-01893';
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-ZDBG-36-0','00042811','DP-01893BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','351000','2026-04-27','351000','1.720','17.00','10','580000','1200000.00','1','0.14', 'input','2026-04-27 16:09:03','1.720','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01893BIP','1','RS 12 5','','DP-01893');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-36-0','00042811');
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-04-27','PSPLT-ZDBG-36-0','PSPLT','TOKO','PSNB','17.00','1.720','1.720','1','1.720','1.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01893BIP ');
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-01895';
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-ZDBG-37-0','00042812','DP-01895BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','433000','2026-04-27','433000','2.120','17.00','10','270000','1200000.00','1','0.14', 'input','2026-04-27 16:10:53','2.120','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01895BIP','1','RS 11','','DP-01895');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-37-0','00042812');
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-04-27','PSPLT-ZDBG-37-0','PSPLT','TOKO','PSNB','17.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-01895BIP ');
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-01899';
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-ZDBG-38-0','00042813','DP-01899BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1758000','2026-04-27','1758000','2.570','57.00','50','280000','1200000.00','1','0.14', 'input','2026-04-27 16:12:17','2.570','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01899BIP','1','RS 10 5','','DP-01899');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-38-0','00042813');
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-04-27','PSPLT-ZDBG-38-0','PSPLT','TOKO','PSNB','57.00','2.570','2.570','1','2.570','2.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01899BIP ');
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-01904';
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-ZDBG-39-0','00042814','DP-01904BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','433000','2026-04-27','433000','2.120','17.00','10','520000','1200000.00','1','0.14', 'input','2026-04-27 16:14:02','2.120','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01904BIP','1','RS 12','','DP-01904');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-39-0','00042814');
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-04-27','PSPLT-ZDBG-39-0','PSPLT','TOKO','PSNB','17.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-01904BIP ');
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-01909';
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-ZDBG-40-0','00042815','DP-01909BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','790000','2026-04-27','790000','3.870','17.00','10','250000','1200000.00','1','0.14', 'input','2026-04-27 16:15:34','3.870','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01909BIP','1','RS 21','','DP-01909');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZDBG-40-0','00042815');
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-04-27','PSPLT-ZDBG-40-0','PSPLT','TOKO','PSNB','17.00','3.870','3.870','1','3.870','3.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01909BIP ');
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-01885';
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-ZDBG-41-0','00042816','DP-01885BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','5309000','2026-04-27','5309000','2.460','83.00','75','250000','2600000.00','1','0.14', 'input','2026-04-27 16:19:51','2.460','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01885BIP','1','RS 11','','DP-01885');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZDBG-41-0','00042816');
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-04-27','PSGT-ZDBG-41-0','PSGT','TOKO','PSNB','83.00','2.460','2.460','1','2.460','2.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01885BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-04-27 ','16:38:11');