INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-09 ','08:11:47'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-08','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-08'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-07'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-07'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-07' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-07'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-07'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-07'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-07'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-08' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-07' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-08'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-09 ','08:12:17'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-09','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-09'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-08'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-08'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-08' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-08'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-08'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-08'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-08'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-09' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-08' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-09'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-09 ','08:12:37'); 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-03167'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGE-ZKXI-1-0','00049183','DP-03167 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','9431000','2026-11-09','9431000','5.050','83.00','75','250000','2250000.00','1','0.04', 'input','2026-11-09 09:14:27','5.050','0','','18200.00','','TOKO','FREETAG','','2','','','PSN03167','1','RS 16','','DP-03167'); DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZKXI-1-0','00049183'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSGE-ZKXI-1-0','PSGE','TOKO','PSN','83.00','5.050','5.050','1','5.050','5.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-03167 '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261109-0001','1','PSGE-ZKXI-1-0','1','5.050','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGE-ZKXI-1-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-ZKXI-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-ZKXI-1-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-ZKXI-1-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSGE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSGE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGE-ZKXI-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.050',berat_out_asli='5.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.050',berat_akhir_asli =berat_akhir_asli-'5.050' WHERE kode_barang='PSGE-ZKXI-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261109-0001','2026-11-09','2026-11-09','09:15','5.050','input','2026-11-09 09:15:37','ELCO'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-09 ','10:30:12'); 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-04767'; 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-ZKXI-2-0','00049184','DP-04767JOG ','CINCIN PERAK CP06 ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','346000','2026-11-09','346000','3.460','100.00','925','385000','100000.00','1','0.14', 'input','2026-11-09 11:12:03','3.460','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04767JOG','1','RS 13 RS 16','','DP-04767'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-2-0','00049184'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-2-0','PSPRT','TOKO','JOGPSN','100.00','3.460','3.460','1','3.460','3.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04767JOG '); 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-04763'; 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-ZKXI-3-0','00049185','DP-04763JOG ','CINCIN PALADIUM YL01 ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','392000','2026-11-09','392000','1.920','17.00','10','200000','1200000.00','1','0.14', 'input','2026-11-09 11:13:59','1.920','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04763JOG','1','RS 21','','DP-04763'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXI-3-0','00049185'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPLT-ZKXI-3-0','PSPLT','TOKO','JOGPSN','17.00','1.920','1.920','1','1.920','1.920','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04763JOG '); 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-04723'; 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-ZKXI-4-0','00049186','DP-04723SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','391000','2026-11-09','391000','3.910','100.00','925','150000','100000.00','1','0.014', 'input','2026-11-09 11:16:28','3.910','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04723SBY','1','RS 19','','DP-04723'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-4-0','00049186'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-4-0','PSPRT','TOKO','SBYPSN','100.00','3.910','3.910','1','3.910','3.910','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04723SBY '); 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-04684'; 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-ZKXI-5-0','00049187','DP-04684SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','168000','2026-11-09','168000','1.680','100.00','925','255000','100000.00','1','0.014', 'input','2026-11-09 11:18:46','1.680','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04684SBY','1','RS 10','','DP-04684'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-5-0','00049187'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-5-0','PSPRT','TOKO','SBYPSN','100.00','1.680','1.680','1','1.680','1.680','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04684SBY '); 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-04648'; 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-ZKXI-6-0','00049188','DP-04648SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','379000','2026-11-09','379000','3.790','100.00','925','150000','100000.00','1','0.014', 'input','2026-11-09 11:20:32','3.790','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04648SBY','1','RS 19','','DP-04648'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-6-0','00049188'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-6-0','PSPRT','TOKO','SBYPSN','100.00','3.790','3.790','1','3.790','3.790','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04648SBY '); 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-04636'; 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-ZKXI-7-0','00049189','DP-04636SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','218500','2026-11-09','218500','2.180','100.00','925','150000','100000.00','1','0.014', 'input','2026-11-09 11:21:53','2.180','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04636SBY','1','RS 15 5','','DP-04636'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-7-0','00049189'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-7-0','PSPRT','TOKO','SBYPSN','100.00','2.180','2.180','1','2.180','2.180','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04636SBY '); 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-04666'; 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-ZKXI-8-0','00049190','DP-04666SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','345000','2026-11-09','345000','3.450','100.00','925','185000','100000.00','1','0.014', 'input','2026-11-09 11:23:23','3.450','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04666SBY','1','RS 20 5','','DP-04666'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-8-0','00049190'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-8-0','PSPRT','TOKO','SBYPSN','100.00','3.450','3.450','1','3.450','3.450','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04666SBY '); 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-04742'; 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-ZKXI-9-0','00049191','DP-04742DU ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','309000','2026-11-09','309000','3.090','100.00','925','305000','100000.00','1','0.14', 'input','2026-11-09 11:27:00','3.090','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04742DU','1','RS 14 RS 21','','DP-04742'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-9-0','00049191'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-9-0','PSPRT','TOKO','DUPSN','100.00','3.090','3.090','1','3.090','3.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04742DU '); 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-04641'; 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-ZKXI-10-0','00049192','DP-04641DU ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','317000','2026-11-09','317000','3.170','100.00','925','305000','100000.00','1','0.14', 'input','2026-11-09 11:28:46','3.170','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04641DU','1','RS 11 RS 16','','DP-04641'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-10-0','00049192'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-10-0','PSPRT','TOKO','DUPSN','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-04641DU '); 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-04592'; 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-ZKXI-11-0','00049193','DP-04592DU ','CINCIN PERAK SR04 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','364000','2026-11-09','364000','3.640','100.00','925','305000','100000.00','1','0.14', 'input','2026-11-09 11:31:10','3.640','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04592DU','1','RS 105 RS 24','','DP-04592'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-11-0','00049193'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-11-0','PSPRT','TOKO','DUPSN','100.00','3.640','3.640','1','3.640','3.640','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04592DU '); 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-04624'; 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-ZKXI-12-0','00049194','DP-04624DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','453000','2026-11-09','453000','2.220','17.00','10','205000','1200000.00','1','0.14', 'input','2026-11-09 11:32:41','2.220','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04624DU','1','RS 14','','DP-04624'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXI-12-0','00049194'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPLT-ZKXI-12-0','PSPLT','TOKO','DUPSN','17.00','2.220','2.220','1','2.220','2.220','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04624DU '); 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-04755'; 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-ZKXI-13-0','00049195','DP-04755DU ','CINCIN PERAK YL10 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','450000','2026-11-09','450000','4.500','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 11:34:06','4.500','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04755DU','1','RS 21 5','','DP-04755'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-13-0','00049195'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-13-0','PSPRT','TOKO','DUPSN','100.00','4.500','4.500','1','4.500','4.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04755DU '); 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-04626'; 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-ZKXI-14-0','00049196','DP-04626DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','386000','2026-11-09','386000','3.860','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 11:35:16','3.860','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04626DU','1','RS 20','','DP-04626'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-14-0','00049196'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-14-0','PSPRT','TOKO','DUPSN','100.00','3.860','3.860','1','3.860','3.860','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04626DU '); 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-04716'; 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-ZKXI-15-0','00049197','DP-04716DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','174000','2026-11-09','174000','1.740','100.00','925','165000','100000.00','1','0.14', 'input','2026-11-09 11:36:37','1.740','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04716DU','1','RS 12','','DP-04716'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXI-15-0','00049197'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PSPRT-ZKXI-15-0','PSPRT','TOKO','DUPSN','100.00','1.740','1.740','1','1.740','1.740','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04716DU '); 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-ZKXI-16-0','00049198','500K-175-3081 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','PBDG','TOKO','PBDG','205500','2026-11-09','205500','2.050','100.00','925','200000','100000.00','1','0.14', 'input','2026-11-09 13:43:02','2.050','0','','18200.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-ZKXI-16-0','00049198'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-16-0','PBDG','TOKO','PBDG','100.00','2.050','2.050','1','2.050','2.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-175-3081 '); 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-ZKXI-17-0','00049199','500K-185-3082 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','PBDG','TOKO','PBDG','217000','2026-11-09','217000','2.170','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 13:43:28','2.170','0','','18200.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-ZKXI-17-0','00049199'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-17-0','PBDG','TOKO','PBDG','100.00','2.170','2.170','1','2.170','2.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-185-3082 '); 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-ZKXI-18-0','00049200','500K-215-3083 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','PBDG','TOKO','PBDG','228500','2026-11-09','228500','2.280','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 13:43:53','2.280','0','','18200.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-ZKXI-18-0','00049200'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-18-0','PBDG','TOKO','PBDG','100.00','2.280','2.280','1','2.280','2.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-215-3083 '); 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-ZKXI-19-0','00049201','500K-24-3084 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','PBDG','TOKO','PBDG','246000','2026-11-09','246000','2.460','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 13:44:17','2.460','0','','18200.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-ZKXI-19-0','00049201'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-19-0','PBDG','TOKO','PBDG','100.00','2.460','2.460','1','2.460','2.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-24-3084 '); 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-ZKXI-20-0','00049202','750K-16-3085 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','166000','2026-11-09','166000','1.660','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 13:45:07','1.660','0','','18200.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-ZKXI-20-0','00049202'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-20-0','PBDG','TOKO','PBDG','100.00','1.660','1.660','1','1.660','1.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-16-3085 '); 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-ZKXI-21-0','00049203','750K-175-3086 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','227000','2026-11-09','227000','2.270','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 13:45:59','2.270','0','','18200.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-ZKXI-21-0','00049203'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-21-0','PBDG','TOKO','PBDG','100.00','2.270','2.270','1','2.270','2.270','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-175-3086 '); 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-ZKXI-22-0','00049204','750K-115-3087 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','176000','2026-11-09','176000','1.760','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 13:47:27','1.760','0','','18200.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-ZKXI-22-0','00049204'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-22-0','PBDG','TOKO','PBDG','100.00','1.760','1.760','1','1.760','1.760','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-115-3087 '); 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-ZKXI-23-0','00049205','750K-105-3088 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','165000','2026-11-09','165000','1.650','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 13:47:53','1.650','0','','18200.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-ZKXI-23-0','00049205'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-23-0','PBDG','TOKO','PBDG','100.00','1.650','1.650','1','1.650','1.650','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-105-3088 '); 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-ZKXI-24-0','00049206','750K-20-3089 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','224500','2026-11-09','224500','2.240','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 13:59:44','2.240','0','','18200.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-ZKXI-24-0','00049206'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-24-0','PBDG','TOKO','PBDG','100.00','2.240','2.240','1','2.240','2.240','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-20-3089 '); 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-ZKXI-25-0','00049207','750K-155-3090 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','213000','2026-11-09','213000','2.130','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:00:25','2.130','0','','18200.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-ZKXI-25-0','00049207'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-25-0','PBDG','TOKO','PBDG','100.00','2.130','2.130','1','2.130','2.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-155-3090 '); 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-ZKXI-26-0','00049208','800K-15-3091 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','226500','2026-11-09','226500','2.260','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:01:06','2.260','0','','18200.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-ZKXI-26-0','00049208'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-26-0','PBDG','TOKO','PBDG','100.00','2.260','2.260','1','2.260','2.260','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-15-3091 '); 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-ZKXI-27-0','00049209','800K-165-3092 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','226500','2026-11-09','226500','2.260','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:01:30','2.260','0','','18200.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-ZKXI-27-0','00049209'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-27-0','PBDG','TOKO','PBDG','100.00','2.260','2.260','1','2.260','2.260','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-165-3092 '); 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-ZKXI-28-0','00049210','800K-10-3093 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','157000','2026-11-09','157000','1.570','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:01:57','1.570','0','','18200.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-ZKXI-28-0','00049210'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-28-0','PBDG','TOKO','PBDG','100.00','1.570','1.570','1','1.570','1.570','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-10-3093 '); 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-ZKXI-29-0','00049211','800K-165-3094 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','327000','2026-11-09','327000','3.270','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 14:02:22','3.270','0','','18200.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-ZKXI-29-0','00049211'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-29-0','PBDG','TOKO','PBDG','100.00','3.270','3.270','1','3.270','3.270','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-165-3094 '); 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-ZKXI-30-0','00049212','800K-20-3095 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','285000','2026-11-09','285000','2.850','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:03:22','2.850','0','','18200.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-ZKXI-30-0','00049212'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-30-0','PBDG','TOKO','PBDG','100.00','2.850','2.850','1','2.850','2.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-20-3095 '); 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-ZKXI-31-0','00049213','800K-12-3096 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','279000','2026-11-09','279000','2.790','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:05:08','2.790','0','','18200.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-ZKXI-31-0','00049213'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-31-0','PBDG','TOKO','PBDG','100.00','2.790','2.790','1','2.790','2.790','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-12-3096 '); 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-ZKXI-32-0','00049214','800K-15-3097 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','240000','2026-11-09','240000','2.400','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:05:37','2.400','0','','18200.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-ZKXI-32-0','00049214'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-32-0','PBDG','TOKO','PBDG','100.00','2.400','2.400','1','2.400','2.400','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-15-3097 '); 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-ZKXI-33-0','00049215','800K-75-3098 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','162000','2026-11-09','162000','1.620','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:06:01','1.620','0','','18200.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-ZKXI-33-0','00049215'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-33-0','PBDG','TOKO','PBDG','100.00','1.620','1.620','1','1.620','1.620','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-75-3098 '); 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-ZKXI-34-0','00049216','800K-19-3099 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','250000','2026-11-09','250000','2.500','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-09 14:06:26','2.500','0','','18200.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-ZKXI-34-0','00049216'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-34-0','PBDG','TOKO','PBDG','100.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-19-3099 '); 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-ZKXI-35-0','00049217','800K-155-3100 ','CINCIN SILVER 925 YL10 ','','GR','---','PER','PBDG','TOKO','PBDG','426000','2026-11-09','426000','4.260','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 14:06:58','4.260','0','','18200.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-ZKXI-35-0','00049217'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-35-0','PBDG','TOKO','PBDG','100.00','4.260','4.260','1','4.260','4.260','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-155-3100 '); 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-ZKXI-36-0','00049218','800K-195-3101 ','CINCIN SILVER 925 YL10 ','','GR','---','PER','PBDG','TOKO','PBDG','453000','2026-11-09','453000','4.530','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-09 14:07:23','4.530','0','','18200.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-ZKXI-36-0','00049218'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-36-0','PBDG','TOKO','PBDG','100.00','4.530','4.530','1','4.530','4.530','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-195-3101 '); 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-ZKXI-37-0','00049219','850K-11-3102 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','166000','2026-11-09','166000','1.660','100.00','925','275000','100000.00','1','0.14', 'input','2026-11-09 14:09:20','1.660','0','','18200.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-ZKXI-37-0','00049219'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-37-0','PBDG','TOKO','PBDG','100.00','1.660','1.660','1','1.660','1.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-11-3102 '); 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-ZKXI-38-0','00049220','850K-12-3103 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','221000','2026-11-09','221000','2.210','100.00','925','255000','100000.00','1','0.14', 'input','2026-11-09 14:09:52','2.210','0','','18200.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-ZKXI-38-0','00049220'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-38-0','PBDG','TOKO','PBDG','100.00','2.210','2.210','1','2.210','2.210','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-12-3103 '); 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-ZKXI-39-0','00049221','850K-10-3104 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','140000','2026-11-09','140000','1.400','100.00','925','235000','100000.00','1','0.14', 'input','2026-11-09 14:10:29','1.400','0','','18200.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-ZKXI-39-0','00049221'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-39-0','PBDG','TOKO','PBDG','100.00','1.400','1.400','1','1.400','1.400','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-10-3104 '); 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-ZKXI-40-0','00049222','850K-12-3105 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','239000','2026-11-09','239000','2.390','100.00','925','165000','100000.00','1','0.14', 'input','2026-11-09 14:10:58','2.390','0','','18200.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-ZKXI-40-0','00049222'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-40-0','PBDG','TOKO','PBDG','100.00','2.390','2.390','1','2.390','2.390','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-12-3105 '); 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-ZKXI-41-0','00049223','850K-125-3106 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','156000','2026-11-09','156000','1.560','100.00','925','190000','100000.00','1','0.14', 'input','2026-11-09 14:11:40','1.560','0','','18200.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-ZKXI-41-0','00049223'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-41-0','PBDG','TOKO','PBDG','100.00','1.560','1.560','1','1.560','1.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-125-3106 '); 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-ZKXI-42-0','00049224','850K-9-3107 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','190000','2026-11-09','190000','1.900','100.00','925','195000','100000.00','1','0.14', 'input','2026-11-09 14:12:19','1.900','0','','18200.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-ZKXI-42-0','00049224'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-42-0','PBDG','TOKO','PBDG','100.00','1.900','1.900','1','1.900','1.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-9-3107 '); 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-ZKXI-43-0','00049225','850K-105-3108 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','243500','2026-11-09','243500','2.430','100.00','925','210000','100000.00','1','0.14', 'input','2026-11-09 14:12:59','2.430','0','','18200.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-ZKXI-43-0','00049225'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-43-0','PBDG','TOKO','PBDG','100.00','2.430','2.430','1','2.430','2.430','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','850K-105-3108 '); 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-ZKXI-44-0','00049226','950K-105-3109 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','163000','2026-11-09','163000','1.630','100.00','925','265000','100000.00','1','0.14', 'input','2026-11-09 14:13:32','1.630','0','','18200.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-ZKXI-44-0','00049226'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-44-0','PBDG','TOKO','PBDG','100.00','1.630','1.630','1','1.630','1.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','950K-105-3109 '); 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-ZKXI-45-0','00049227','1.2K-105-3110 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','175000','2026-11-09','175000','1.750','100.00','925','325000','100000.00','1','0.14', 'input','2026-11-09 14:14:01','1.750','0','','18200.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-ZKXI-45-0','00049227'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','PBDG-ZKXI-45-0','PBDG','TOKO','PBDG','100.00','1.750','1.750','1','1.750','1.750','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','1.2K-105-3110 '); UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2350500',harga_beli ='2350500' WHERE kode_barcode='00001136' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4760500',harga_beli ='4760500' WHERE kode_barcode='00001394' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='185500',harga_beli ='185500' WHERE kode_barcode='00001984' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2693500',harga_beli ='2693500' WHERE kode_barcode='00002031' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5963000',harga_beli ='5963000' WHERE kode_barcode='00002094' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2234000',harga_beli ='2234000' WHERE kode_barcode='00003287' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2137000',harga_beli ='2137000' WHERE kode_barcode='00003288' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2175500',harga_beli ='2175500' WHERE kode_barcode='00003289' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5186000',harga_beli ='5186000' WHERE kode_barcode='00003290' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='19151000',harga_beli ='19151000' WHERE kode_barcode='00003291' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2664500',harga_beli ='2664500' WHERE kode_barcode='00005675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2640500',harga_beli ='2640500' WHERE kode_barcode='00005680' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2495000',harga_beli ='2495000' WHERE kode_barcode='00005686' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2592000',harga_beli ='2592000' WHERE kode_barcode='00005694' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2567500',harga_beli ='2567500' WHERE kode_barcode='00005695' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7207000',harga_beli ='7207000' WHERE kode_barcode='00006371' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2759500',harga_beli ='2759500' WHERE kode_barcode='00007446' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='9885000',harga_beli ='9885000' WHERE kode_barcode='00007503' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3566000',harga_beli ='3566000' WHERE kode_barcode='00014815' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4191500',harga_beli ='4191500' WHERE kode_barcode='00015245' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4305500',harga_beli ='4305500' WHERE kode_barcode='00015248' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5064000',harga_beli ='5064000' WHERE kode_barcode='00016090' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4097000',harga_beli ='4097000' WHERE kode_barcode='00016091' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5860500',harga_beli ='5860500' WHERE kode_barcode='00019597' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6998500',harga_beli ='6998500' WHERE kode_barcode='00019598' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='8440000',harga_beli ='8440000' WHERE kode_barcode='00019599' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6828000',harga_beli ='6828000' WHERE kode_barcode='00020277' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='1422500',harga_beli ='1422500' WHERE kode_barcode='00020571' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2636500',harga_beli ='2636500' WHERE kode_barcode='00023554' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4021000',harga_beli ='4021000' WHERE kode_barcode='00023557' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3641500',harga_beli ='3641500' WHERE kode_barcode='00023558' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2086500',harga_beli ='2086500' WHERE kode_barcode='00023559' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2010500',harga_beli ='2010500' WHERE kode_barcode='00023560' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6164000',harga_beli ='6164000' WHERE kode_barcode='00023561' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7397000',harga_beli ='7397000' WHERE kode_barcode='00023565' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='00023566' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6543500',harga_beli ='6543500' WHERE kode_barcode='00023567' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5197000',harga_beli ='5197000' WHERE kode_barcode='00023569' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2522500',harga_beli ='2522500' WHERE kode_barcode='00023577' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='2143500',harga_beli ='2143500' WHERE kode_barcode='00023578' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4874500',harga_beli ='4874500' WHERE kode_barcode='00023579' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3414000',harga_beli ='3414000' WHERE kode_barcode='00023581' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5060500',harga_beli ='5060500' WHERE kode_barcode='00023587' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6524500',harga_beli ='6524500' WHERE kode_barcode='00023669' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='9881500',harga_beli ='9881500' WHERE kode_barcode='00023670' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='8914000',harga_beli ='8914000' WHERE kode_barcode='00023671' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3262500',harga_beli ='3262500' WHERE kode_barcode='00023673' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='00023675' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7093500',harga_beli ='7093500' WHERE kode_barcode='00023677' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6467500',harga_beli ='6467500' WHERE kode_barcode='00023678' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6657000',harga_beli ='6657000' WHERE kode_barcode='00023696' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7643500',harga_beli ='7643500' WHERE kode_barcode='00023698' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='15248500',harga_beli ='15248500' WHERE kode_barcode='00023884' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='1555500',harga_beli ='1555500' WHERE kode_barcode='00023899' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='1555500',harga_beli ='1555500' WHERE kode_barcode='00023900' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='1479500',harga_beli ='1479500' WHERE kode_barcode='00023902' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='1422500',harga_beli ='1422500' WHERE kode_barcode='00023903' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4703500',harga_beli ='4703500' WHERE kode_barcode='00023909' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='8079500',harga_beli ='8079500' WHERE kode_barcode='00023910' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='9236500',harga_beli ='9236500' WHERE kode_barcode='00023911' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7852000',harga_beli ='7852000' WHERE kode_barcode='00023963' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7359000',harga_beli ='7359000' WHERE kode_barcode='00024003' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='8060500',harga_beli ='8060500' WHERE kode_barcode='00024088' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7188000',harga_beli ='7188000' WHERE kode_barcode='00024116' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4286500',harga_beli ='4286500' WHERE kode_barcode='00024117' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='51453500',harga_beli ='51453500' WHERE kode_barcode='00024185' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='8003500',harga_beli ='8003500' WHERE kode_barcode='00024187' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7397000',harga_beli ='7397000' WHERE kode_barcode='00024190' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5481500',harga_beli ='5481500' WHERE kode_barcode='00024191' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='10526000',harga_beli ='10526000' WHERE kode_barcode='00024259' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='12215000',harga_beli ='12215000' WHERE kode_barcode='00024357' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='7017500',harga_beli ='7017500' WHERE kode_barcode='00024362' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5671000',harga_beli ='5671000' WHERE kode_barcode='00025021' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='6221000',harga_beli ='6221000' WHERE kode_barcode='00026264' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4874500',harga_beli ='4874500' WHERE kode_barcode='00026265' LIMIT 1; UPDATE tm_group SET harga='2285000' WHERE kode_group = 'DM' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2285000','input','2026-11-09 15:08:43'); UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='16024000',harga_beli ='16024000' WHERE kode_barcode='00001173' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='9401000',harga_beli ='9401000' WHERE kode_barcode='00001223' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4953000',harga_beli ='4953000' WHERE kode_barcode='00001224' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4992000',harga_beli ='4992000' WHERE kode_barcode='00001225' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5793000',harga_beli ='5793000' WHERE kode_barcode='00002442' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='4397000',harga_beli ='4397000' WHERE kode_barcode='00004222' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='10920500',harga_beli ='10920500' WHERE kode_barcode='00006106' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3352000',harga_beli ='3352000' WHERE kode_barcode='00006485' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='12567500',harga_beli ='12567500' WHERE kode_barcode='00034435' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='5974500',harga_beli ='5974500' WHERE kode_barcode='00038144' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='255920500',harga_beli ='255920500' WHERE kode_barcode='00046097' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='255920500',harga_beli ='255920500' WHERE kode_barcode='00046098' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='127960500',harga_beli ='127960500' WHERE kode_barcode='00046099' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='127960500',harga_beli ='127960500' WHERE kode_barcode='00046100' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='127960500',harga_beli ='127960500' WHERE kode_barcode='00046101' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='127960500',harga_beli ='127960500' WHERE kode_barcode='00046102' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='127960500',harga_beli ='127960500' WHERE kode_barcode='00046103' LIMIT 1; UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='127960500',harga_beli ='127960500' WHERE kode_barcode='00046104' LIMIT 1; UPDATE tm_group SET harga='2285000' WHERE kode_group = 'GOLD' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2285000','input','2026-11-09 15:08:50'); UPDATE tm_group SET harga='2285000' WHERE kode_group = 'PSBRE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2285000','input','2026-11-09 15:08:56'); UPDATE tm_group SET harga='2285000' WHERE kode_group = 'PSBRL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2285000','input','2026-11-09 15:09:00'); UPDATE tm_group SET harga='2285000' WHERE kode_group = 'PSBRT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2285000','input','2026-11-09 15:09:04'); UPDATE tm_group SET harga='2285000' WHERE kode_group = 'PSGE' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2285000','input','2026-11-09 15:09:08'); UPDATE tm_group SET harga='2285000' WHERE kode_group = 'PSGL' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2285000','input','2026-11-09 15:09:12'); UPDATE tm_barang SET harga_skrg ='2285000',harga_jual='3452000',harga_beli ='3452000' WHERE kode_barcode='00033486' LIMIT 1; UPDATE tm_group SET harga='2285000' WHERE kode_group = 'PSGT' LIMIT 1; INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2285000','input','2026-11-09 15:09:17'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLKR-ZKXI-46-0','00049228','GLKRE75-85% ','GELANG KAKU ROSE GOLD ','','GR','---','GOLD','GLKR','TOKO','GLK','10410500','2026-11-09','10410500','5.360','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:11:28','5.360','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLKR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLKR','GLKR-ZKXI-46-0','00049228'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLKR-ZKXI-46-0','GLKR','TOKO','GLK','85.00','5.360','5.360','1','5.360','5.360','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLKR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLKR','GLKRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLKR-ZKXI-47-0','00049229','GLKRE75-85% ','GELANG KAKU ROSE GOLD ','','GR','---','GOLD','GLKR','TOKO','GLK','13887500','2026-11-09','13887500','7.150','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:12:00','7.150','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLKR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLKR','GLKR-ZKXI-47-0','00049229'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLKR-ZKXI-47-0','GLKR','TOKO','GLK','85.00','7.150','7.150','1','7.150','7.150','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLKR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLKR','GLKRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRP-ZKXI-48-0','00049230','GLRPE75-85% ','GELANG RANTAI PUTIH ','','GR','---','GOLD','GLRP','TOKO','GLR','5963000','2026-11-09','5963000','3.070','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:15:16','3.070','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRP','GLRP-ZKXI-48-0','00049230'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRP-ZKXI-48-0','GLRP','TOKO','GLR','85.00','3.070','3.070','1','3.070','3.070','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRP','GLRPE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRP-ZKXI-49-0','00049231','GLRPE75-85% ','GELANG RANTAI PUTIH ','','GR','---','GOLD','GLRP','TOKO','GLR','11129500','2026-11-09','11129500','5.730','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:15:55','5.730','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRP','GLRP-ZKXI-49-0','00049231'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRP-ZKXI-49-0','GLRP','TOKO','GLR','85.00','5.730','5.730','1','5.730','5.730','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRP','GLRPE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRP-ZKXI-50-0','00049232','GLRPE75-85% ','GELANG RANTAI PUTIH ','','GR','---','GOLD','GLRP','TOKO','GLR','13110500','2026-11-09','13110500','6.750','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:16:34','6.750','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRP','GLRP-ZKXI-50-0','00049232'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRP-ZKXI-50-0','GLRP','TOKO','GLR','85.00','6.750','6.750','1','6.750','6.750','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRP','GLRPE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-51-0','00049233','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','3613000','2026-11-09','3613000','1.860','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:25:24','1.860','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-51-0','00049233'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-51-0','GLRR','TOKO','GLR','85.00','1.860','1.860','1','1.860','1.860','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-52-0','00049234','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','3224500','2026-11-09','3224500','1.660','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:26:02','1.660','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-52-0','00049234'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-52-0','GLRR','TOKO','GLR','85.00','1.660','1.660','1','1.660','1.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-53-0','00049235','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','6487500','2026-11-09','6487500','3.340','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:26:41','3.340','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-53-0','00049235'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-53-0','GLRR','TOKO','GLR','85.00','3.340','3.340','1','3.340','3.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-54-0','00049236','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','6215500','2026-11-09','6215500','3.200','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:27:39','3.200','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-54-0','00049236'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-54-0','GLRR','TOKO','GLR','85.00','3.200','3.200','1','3.200','3.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-55-0','00049237','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','5691000','2026-11-09','5691000','2.930','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:28:24','2.930','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-55-0','00049237'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-55-0','GLRR','TOKO','GLR','85.00','2.930','2.930','1','2.930','2.930','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-56-0','00049238','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','4797500','2026-11-09','4797500','2.470','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:31:28','2.470','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-56-0','00049238'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-56-0','GLRR','TOKO','GLR','85.00','2.470','2.470','1','2.470','2.470','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-57-0','00049239','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','7148000','2026-11-09','7148000','3.680','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:32:45','3.680','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-57-0','00049239'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-57-0','GLRR','TOKO','GLR','85.00','3.680','3.680','1','3.680','3.680','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-58-0','00049240','GLRRE75-85% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','10177500','2026-11-09','10177500','5.240','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:33:15','5.240','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-58-0','00049240'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-58-0','GLRR','TOKO','GLR','85.00','5.240','5.240','1','5.240','5.240','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('KMP-ZKXI-59-0','00049241','KMPE75-85% ','KALUNG MAS PUTIH ','','GR','---','GOLD','KMP','TOKO','KMP','1806500','2026-11-09','1806500','0.930','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:41:17','0.930','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'KMP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMP','KMP-ZKXI-59-0','00049241'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','KMP-ZKXI-59-0','KMP','TOKO','KMP','85.00','0.930','0.930','1','0.930','0.930','1'); DELETE FROM tp_kode_intern WHERE kode_dept='KMP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMP','KMPE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('KMR-ZKXI-60-0','00049242','KMRE75-85% ','KALUNG MAS ROSE GOLD ','','GR','---','GOLD','KMR','TOKO','KMP','7478000','2026-11-09','7478000','3.850','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:43:08','3.850','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'KMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMR','KMR-ZKXI-60-0','00049242'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','KMR-ZKXI-60-0','KMR','TOKO','KMP','85.00','3.850','3.850','1','3.850','3.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='KMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMR','KMRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('KMR-ZKXI-61-0','00049243','KMRE75-85% ','KALUNG MAS ROSE GOLD ','','GR','---','GOLD','KMR','TOKO','KMP','4778000','2026-11-09','4778000','2.460','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:43:52','2.460','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'KMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMR','KMR-ZKXI-61-0','00049243'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','KMR-ZKXI-61-0','KMR','TOKO','KMP','85.00','2.460','2.460','1','2.460','2.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='KMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMR','KMRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('KMR-ZKXI-62-0','00049244','KMRE75-85% ','KALUNG MAS ROSE GOLD ','','GR','---','GOLD','KMR','TOKO','KMP','3535000','2026-11-09','3535000','1.820','85.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:44:27','1.820','','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'KMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMR','KMR-ZKXI-62-0','00049244'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','KMR-ZKXI-62-0','KMR','TOKO','KMP','85.00','1.820','1.820','1','1.820','1.820','1'); DELETE FROM tp_kode_intern WHERE kode_dept='KMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMR','KMRE75-85% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLKR-ZKXI-63-0','00049245','GLKRE75-83% ','GELANG KAKU ROSE GOLD ','','GR','---','GOLD','GLKR','TOKO','GLK','4021000','2026-11-09','4021000','2.120','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:47:46','2.120','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLKR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLKR','GLKR-ZKXI-63-0','00049245'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLKR-ZKXI-63-0','GLKR','TOKO','GLK','83.00','2.120','2.120','1','2.120','2.120','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLKR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLKR','GLKRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-64-0','00049246','GLRRE75-83% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','4760500','2026-11-09','4760500','2.510','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:49:37','2.510','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-64-0','00049246'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-64-0','GLRR','TOKO','GLR','83.00','2.510','2.510','1','2.510','2.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-65-0','00049247','GLRRE75-83% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','1441500','2026-11-09','1441500','0.760','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:50:10','0.760','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-65-0','00049247'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-65-0','GLRR','TOKO','GLR','83.00','0.760','0.760','1','0.760','0.760','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-66-0','00049248','GLRRE75-83% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','1441500','2026-11-09','1441500','0.760','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:50:26','0.760','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-66-0','00049248'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-66-0','GLRR','TOKO','GLR','83.00','0.760','0.760','1','0.760','0.760','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-67-0','00049249','GLRRE75-83% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','3641500','2026-11-09','3641500','1.920','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:50:57','1.920','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-67-0','00049249'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-67-0','GLRR','TOKO','GLR','83.00','1.920','1.920','1','1.920','1.920','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-68-0','00049250','GLRRE75-83% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','1536500','2026-11-09','1536500','0.810','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:51:29','0.810','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-68-0','00049250'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-68-0','GLRR','TOKO','GLR','83.00','0.810','0.810','1','0.810','0.810','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-69-0','00049251','GLRRE75-83% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','3888000','2026-11-09','3888000','2.050','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:52:21','2.050','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-69-0','00049251'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-69-0','GLRR','TOKO','GLR','83.00','2.050','2.050','1','2.050','2.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('KMR-ZKXI-70-0','00049252','KMRE75-83% ','KALUNG MAS ROSE GOLD ','','GR','---','GOLD','KMR','TOKO','KMP','2067500','2026-11-09','2067500','1.090','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:57:53','1.090','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'KMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMR','KMR-ZKXI-70-0','00049252'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','KMR-ZKXI-70-0','KMR','TOKO','KMP','83.00','1.090','1.090','1','1.090','1.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='KMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMR','KMRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('KMR-ZKXI-71-0','00049253','KMRE75-83% ','KALUNG MAS ROSE GOLD ','','GR','---','GOLD','KMR','TOKO','KMP','2257000','2026-11-09','2257000','1.190','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 15:58:21','1.190','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'KMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMR','KMR-ZKXI-71-0','00049253'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','KMR-ZKXI-71-0','KMR','TOKO','KMP','83.00','1.190','1.190','1','1.190','1.190','1'); DELETE FROM tp_kode_intern WHERE kode_dept='KMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMR','KMRE75-83% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMR-ZKXI-72-0','00049254','CMRE75-87% ','CINCIN MAS ROSE GOLD ','','GR','---','GOLD','CMR','TOKO','CMP','2008000','2026-11-09','2008000','1.010','87.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 16:01:29','1.010','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMR','CMR-ZKXI-72-0','00049254'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','CMR-ZKXI-72-0','CMR','TOKO','CMP','87.00','1.010','1.010','1','1.010','1.010','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMR','CMRE75-87% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMR-ZKXI-73-0','00049255','CMRE75-87% ','CINCIN MAS ROSE GOLD ','','GR','---','GOLD','CMR','TOKO','CMP','3519000','2026-11-09','3519000','1.770','87.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 16:02:05','1.770','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMR','CMR-ZKXI-73-0','00049255'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','CMR-ZKXI-73-0','CMR','TOKO','CMP','87.00','1.770','1.770','1','1.770','1.770','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMR','CMRE75-87% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMR-ZKXI-74-0','00049256','CMRE75-87% ','CINCIN MAS ROSE GOLD ','','GR','---','GOLD','CMR','TOKO','CMP','2008000','2026-11-09','2008000','1.010','87.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 16:02:35','1.010','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMR','CMR-ZKXI-74-0','00049256'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','CMR-ZKXI-74-0','CMR','TOKO','CMP','87.00','1.010','1.010','1','1.010','1.010','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMR','CMRE75-87% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMR-ZKXI-75-0','00049257','CMRE75-87% ','CINCIN MAS ROSE GOLD ','','GR','---','GOLD','CMR','TOKO','CMP','2087500','2026-11-09','2087500','1.050','87.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 16:03:02','1.050','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMR','CMR-ZKXI-75-0','00049257'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','CMR-ZKXI-75-0','CMR','TOKO','CMP','87.00','1.050','1.050','1','1.050','1.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMR','CMRE75-87% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-76-0','00049258','GLRRE75-87% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','22205500','2026-11-09','22205500','11.170','87.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 16:05:26','11.170','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-76-0','00049258'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-76-0','GLRR','TOKO','GLR','87.00','11.170','11.170','1','11.170','11.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-87% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GLRR-ZKXI-77-0','00049259','GLRRE75-87% ','GELANG RANTAI ROSE GOLD ','','GR','---','GOLD','GLRR','TOKO','GLR','15924000','2026-11-09','15924000','8.010','87.00','75','0','2285000.00','1','0.04', 'input','2026-11-09 16:06:07','8.010','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'GLRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GLRR','GLRR-ZKXI-77-0','00049259'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','GLRR-ZKXI-77-0','GLRR','TOKO','GLR','87.00','8.010','8.010','1','8.010','8.010','1'); DELETE FROM tp_kode_intern WHERE kode_dept='GLRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GLRR','GLRRE75-87% '); 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 ('TFCMR-ZKXI-78-0','00049260','TFCMR75-87% ','THIFA CINCIN MAS RG ','','GR','---','GOLD','TFCMR','TOKO','CMPTF','2067500','2026-11-09','2067500','1.040','87.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:27:34','1.040','','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFCMR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFCMR','TFCMR-ZKXI-78-0','00049260'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFCMR-ZKXI-78-0','TFCMR','TOKO','CMPTF','87.00','1.040','1.040','1','1.040','1.040','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFCMR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFCMR','TFCMR75-87% '); 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 ('TFGKR-ZKXI-79-0','00049261','TFGKR75-83% ','THIFA GELANG KAKU RG ','','GR','---','GOLD','TFGKR','TOKO','GLKTF','3907000','2026-11-09','3907000','2.060','83.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:28:17','2.060','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGKR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGKR','TFGKR-ZKXI-79-0','00049261'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFGKR-ZKXI-79-0','TFGKR','TOKO','GLKTF','83.00','2.060','2.060','1','2.060','2.060','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGKR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGKR','TFGKR75-83% '); 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 ('TFGRR-ZKXI-80-0','00049262','TFGRR75-83% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','3964000','2026-11-09','3964000','2.090','83.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:29:09','2.090','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZKXI-80-0','00049262'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFGRR-ZKXI-80-0','TFGRR','TOKO','GLRTF','83.00','2.090','2.090','1','2.090','2.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-83% '); 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 ('TFGRR-ZKXI-81-0','00049263','TFGRR75-83% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','4722500','2026-11-09','4722500','2.490','83.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:29:32','2.490','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZKXI-81-0','00049263'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFGRR-ZKXI-81-0','TFGRR','TOKO','GLRTF','83.00','2.490','2.490','1','2.490','2.490','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-83% '); 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 ('TFGRR-ZKXI-82-0','00049264','TFGRR75-83% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','1555500','2026-11-09','1555500','0.820','83.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:29:55','0.820','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZKXI-82-0','00049264'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFGRR-ZKXI-82-0','TFGRR','TOKO','GLRTF','83.00','0.820','0.820','1','0.820','0.820','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-83% '); 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 ('TFGRR-ZKXI-83-0','00049265','TFGRR75-83% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','1460500','2026-11-09','1460500','0.770','83.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:30:16','0.770','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZKXI-83-0','00049265'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFGRR-ZKXI-83-0','TFGRR','TOKO','GLRTF','83.00','0.770','0.770','1','0.770','0.770','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-83% '); 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 ('TFKMP-ZKXI-84-0','00049266','TFKMP75-85% ','THIFA KALUNG MAS PUTIH ','','GR','---','GOLD','TFKMP','TOKO','KMPTF','1748500','2026-11-09','1748500','0.900','85.00','75','0','2285000.00','1','0.14', 'input','2026-11-09 16:30:54','0.900','0','','18200.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFKMP' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFKMP','TFKMP-ZKXI-84-0','00049266'); INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-11-09','TFKMP-ZKXI-84-0','TFKMP','TOKO','KMPTF','85.00','0.900','0.900','1','0.900','0.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFKMP'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFKMP','TFKMP75-85% ');