INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-04 ','08:11:43'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-04','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-04'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-03'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-03'; 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-03' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-03'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-03'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-03'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-03'; 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-04' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-03' 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-04'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-04 ','08:13:09'); 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 ('CKPDE-ZKXD-1-0','00048959','CKPDE-00096 ','CINCIN KAWIN YL01 CKPDE-00096 ','','GR','---','PLD','CKPDE','TOKO','CKPDE','543000','2026-11-04','543000','2.660','17.00','10','250000','1200000.00','1','0.14', 'input','2026-11-04 08:14:54','2.660','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 29 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPDE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPDE','CKPDE-ZKXD-1-0','00048959'); 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-04','CKPDE-ZKXD-1-0','CKPDE','TOKO','CKPDE','17.00','2.660','2.660','1','2.660','2.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPDE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPDE','CKPDE-00096 '); 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 ('CKPDE-ZKXD-2-0','00048960','CKPDE-00097 ','CINCIN KAWIN CKPDE-00097 ','','GR','---','PLD','CKPDE','TOKO','CKPDE','645000','2026-11-04','645000','3.160','17.00','10','250000','1200000.00','1','0.14', 'input','2026-11-04 08:15:40','3.160','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 26 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPDE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPDE','CKPDE-ZKXD-2-0','00048960'); 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-04','CKPDE-ZKXD-2-0','CKPDE','TOKO','CKPDE','17.00','3.160','3.160','1','3.160','3.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPDE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPDE','CKPDE-00097 '); 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 ('PLDMM-ZKXD-3-0','00048961','PLDMM-00053 ','CINCIN PALADIUM YL01 PLDMM-00053 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','498000','2026-11-04','498000','2.440','17.00','10','250000','1200000.00','1','0.04', 'input','2026-11-04 08:20:21','2.440','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 27 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-ZKXD-3-0','00048961'); 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-04','PLDMM-ZKXD-3-0','PLDMM','TOKO','MMPLD','17.00','2.440','2.440','1','2.440','2.440','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00053 '); 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 ('PLDMM-ZKXD-4-0','00048962','PLDMM-00054 ','CINCIN PALADIUM PLDMM-00054 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','557000','2026-11-04','557000','2.730','17.00','10','250000','1200000.00','1','0.04', 'input','2026-11-04 08:20:53','2.730','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 13 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-ZKXD-4-0','00048962'); 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-04','PLDMM-ZKXD-4-0','PLDMM','TOKO','MMPLD','17.00','2.730','2.730','1','2.730','2.730','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00054 '); 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 ('PLDMM-ZKXD-5-0','00048963','PLDMM-00055 ','CINCIN PALADIUM PLDMM-00055 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','477500','2026-11-04','477500','2.340','17.00','10','260000','1200000.00','1','0.04', 'input','2026-11-04 08:21:36','2.340','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 16','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-ZKXD-5-0','00048963'); 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-04','PLDMM-ZKXD-5-0','PLDMM','TOKO','MMPLD','17.00','2.340','2.340','1','2.340','2.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00055 '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','1','PSPRE-ZKXC-1-0','1','1.760','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZKXC-1-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZKXC-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZKXC-1-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZKXC-1-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' 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='PSPRE-ZKXC-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.760',berat_out_asli='1.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.760',berat_akhir_asli =berat_akhir_asli-'1.760' WHERE kode_barang='PSPRE-ZKXC-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0001','2','PSPRE-ZKXC-2-0','1','4.110','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZKXC-2-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZKXC-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZKXC-2-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZKXC-2-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' 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='PSPRE-ZKXC-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.110',berat_out_asli='4.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.110',berat_akhir_asli =berat_akhir_asli-'4.110' WHERE kode_barang='PSPRE-ZKXC-2-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261104-0001','2026-11-04','2026-11-04','08:24','4.110','input','2026-11-04 08:24:48','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0002','1','PSPRT-ZKXC-53-0','1','3.280','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXC-53-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXC-53-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXC-53-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXC-53-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXC-53-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.280',berat_out_asli='3.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.280',berat_akhir_asli =berat_akhir_asli-'3.280' WHERE kode_barang='PSPRT-ZKXC-53-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-261104-0002','2026-11-04','2026-11-04','08:25','3.280','input','2026-11-04 08:25:03','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','1','PMM-ZKXC-57-0','1','1.790','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-57-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-57-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-57-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-57-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-57-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.790',berat_out_asli='1.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.790',berat_akhir_asli =berat_akhir_asli-'1.790' WHERE kode_barang='PMM-ZKXC-57-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','2','PMM-ZKXC-58-0','1','2.760','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-58-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-58-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-58-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-58-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-58-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.760',berat_out_asli='2.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.760',berat_akhir_asli =berat_akhir_asli-'2.760' WHERE kode_barang='PMM-ZKXC-58-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','3','PMM-ZKXC-59-0','1','1.600','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-59-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-59-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-59-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-59-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-59-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='PMM-ZKXC-59-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','4','PMM-ZKXC-60-0','1','2.150','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-60-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-60-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-60-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-60-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-60-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='PMM-ZKXC-60-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','5','PMM-ZKXC-61-0','1','1.890','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-61-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-61-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-61-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-61-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-61-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.890',berat_out_asli='1.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.890',berat_akhir_asli =berat_akhir_asli-'1.890' WHERE kode_barang='PMM-ZKXC-61-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','6','PMM-ZKXC-62-0','1','2.530','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-62-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-62-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-62-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-62-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-62-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.530',berat_out_asli='2.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.530',berat_akhir_asli =berat_akhir_asli-'2.530' WHERE kode_barang='PMM-ZKXC-62-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','7','PMM-ZKXC-63-0','1','2.070','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-63-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-63-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-63-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-63-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-63-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.070',berat_out_asli='2.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.070',berat_akhir_asli =berat_akhir_asli-'2.070' WHERE kode_barang='PMM-ZKXC-63-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','8','PMM-ZKXC-64-0','1','2.300','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-64-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-64-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-64-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-64-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-64-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='PMM-ZKXC-64-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','9','PMM-ZKXC-65-0','1','1.620','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-65-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-65-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-65-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-65-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-65-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.620',berat_out_asli='1.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.620',berat_akhir_asli =berat_akhir_asli-'1.620' WHERE kode_barang='PMM-ZKXC-65-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','10','PMM-ZKXC-66-0','1','2.570','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-66-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-66-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-66-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-66-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-66-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.570',berat_out_asli='2.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.570',berat_akhir_asli =berat_akhir_asli-'2.570' WHERE kode_barang='PMM-ZKXC-66-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','11','PMM-ZKXC-67-0','1','2.590','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-67-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-67-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-67-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-67-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-67-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.590',berat_out_asli='2.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.590',berat_akhir_asli =berat_akhir_asli-'2.590' WHERE kode_barang='PMM-ZKXC-67-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','12','PMM-ZKXC-68-0','1','2.180','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-68-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-68-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-68-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-68-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-68-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.180' WHERE kode_barang='PMM-ZKXC-68-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','13','PMM-ZKXC-69-0','1','2.660','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-69-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-69-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-69-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-69-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-69-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.660',berat_out_asli='2.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.660',berat_akhir_asli =berat_akhir_asli-'2.660' WHERE kode_barang='PMM-ZKXC-69-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','14','PMM-ZKXC-70-0','1','2.090','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-70-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-70-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-70-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-70-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-70-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.090',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.090',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='PMM-ZKXC-70-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','15','PMM-ZKXC-71-0','1','2.640','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-71-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-71-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-71-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-71-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-71-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.640' WHERE kode_barang='PMM-ZKXC-71-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','16','PMM-ZKXC-72-0','1','3.880','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-72-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-72-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-72-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-72-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-72-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.880',berat_out_asli='3.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.880',berat_akhir_asli =berat_akhir_asli-'3.880' WHERE kode_barang='PMM-ZKXC-72-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','17','PMM-ZKXC-73-0','1','2.900','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-73-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-73-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-73-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-73-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-73-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.900',berat_out_asli='2.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.900',berat_akhir_asli =berat_akhir_asli-'2.900' WHERE kode_barang='PMM-ZKXC-73-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','18','PMM-ZKXC-74-0','1','3.670','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-74-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-74-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-74-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-74-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-74-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.670',berat_out_asli='3.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.670',berat_akhir_asli =berat_akhir_asli-'3.670' WHERE kode_barang='PMM-ZKXC-74-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','19','PMM-ZKXC-75-0','1','1.950','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-75-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-75-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-75-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-75-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-75-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.950',berat_out_asli='1.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.950',berat_akhir_asli =berat_akhir_asli-'1.950' WHERE kode_barang='PMM-ZKXC-75-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','20','PMM-ZKXC-76-0','1','1.390','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-76-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-76-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-76-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-76-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-76-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.390',berat_out_asli='1.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.390',berat_akhir_asli =berat_akhir_asli-'1.390' WHERE kode_barang='PMM-ZKXC-76-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','21','PMM-ZKXC-77-0','1','1.670','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-77-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-77-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-77-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-77-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-77-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.670',berat_out_asli='1.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.670',berat_akhir_asli =berat_akhir_asli-'1.670' WHERE kode_barang='PMM-ZKXC-77-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','22','PMM-ZKXC-78-0','1','2.110','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-78-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-78-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-78-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-78-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-78-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PMM-ZKXC-78-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','23','PMM-ZKXC-79-0','1','1.540','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-79-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-79-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-79-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-79-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-79-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='PMM-ZKXC-79-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','24','PMM-ZKXC-80-0','1','1.900','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-80-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-80-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-80-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-80-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-80-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='PMM-ZKXC-80-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0003','25','PMM-ZKXC-81-0','1','1.840','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKXC-81-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKXC-81-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKXC-81-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKXC-81-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKXC-81-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.840',berat_out_asli='1.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.840',berat_akhir_asli =berat_akhir_asli-'1.840' WHERE kode_barang='PMM-ZKXC-81-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-261104-0003','2026-11-04','2026-11-04','08:25','1.840','input','2026-11-04 08:25:18','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0004','1','CKPDE-ZKXD-1-0','1','2.660','TOKO','CKPDE'); DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZKXD-1-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZKXD-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZKXD-1-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZKXD-1-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZKXD-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.660',berat_out_asli='2.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.660',berat_akhir_asli =berat_akhir_asli-'2.660' WHERE kode_barang='CKPDE-ZKXD-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0004','2','CKPDE-ZKXD-2-0','1','3.160','TOKO','CKPDE'); DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZKXD-2-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZKXD-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZKXD-2-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZKXD-2-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZKXD-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='CKPDE-ZKXD-2-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261104-0004','2026-11-04','2026-11-04','08:25','3.160','input','2026-11-04 08:25:35','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0005','1','PLDMM-ZKXD-3-0','1','2.440','TOKO','MMPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXD-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZKXD-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZKXD-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZKXD-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZKXD-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.440',berat_out_asli='2.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.440',berat_akhir_asli =berat_akhir_asli-'2.440' WHERE kode_barang='PLDMM-ZKXD-3-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0005','2','PLDMM-ZKXD-4-0','1','2.730','TOKO','MMPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXD-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZKXD-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZKXD-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZKXD-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZKXD-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.730',berat_out_asli='2.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.730',berat_akhir_asli =berat_akhir_asli-'2.730' WHERE kode_barang='PLDMM-ZKXD-4-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0005','3','PLDMM-ZKXD-5-0','1','2.340','TOKO','MMPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZKXD-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZKXD-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZKXD-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZKXD-5-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZKXD-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='PLDMM-ZKXD-5-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-261104-0005','2026-11-04','2026-11-04','08:25','2.340','input','2026-11-04 08:25:47','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-04 ','08:29:25'); 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-03165'; 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 ('PSPRE-ZKXD-6-0','00048964','DP-03165 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','131000','2026-11-04','131000','1.310','100.00','925','290000','100000.00','1','0.04', 'input','2026-11-04 09:55:10','1.310','0','','18200.00','','TOKO','FREETAG','','2','','','PSN03165','1','RS 14','','DP-03165'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZKXD-6-0','00048964'); 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-04','PSPRE-ZKXD-6-0','PSPRE','TOKO','PSN','100.00','1.310','1.310','1','1.310','1.310','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03165 '); 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-04528'; 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-ZKXD-7-0','00048965','DP-04528MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','424000','2026-11-04','424000','4.240','100.00','925','200000','100000.00','1','0.14', 'input','2026-11-04 09:57:28','4.240','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04528MM','1','RS 21','','DP-04528'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-7-0','00048965'); 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-04','PSPRT-ZKXD-7-0','PSPRT','TOKO','MMPSN','100.00','4.240','4.240','1','4.240','4.240','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04528MM '); 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-04536'; 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-ZKXD-8-0','00048966','DP-04536MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','508000','2026-11-04','508000','5.080','100.00','925','200000','100000.00','1','0.14', 'input','2026-11-04 09:58:57','5.080','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04536MM','1','RS 28','','DP-04536'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-8-0','00048966'); 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-04','PSPRT-ZKXD-8-0','PSPRT','TOKO','MMPSN','100.00','5.080','5.080','1','5.080','5.080','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04536MM '); 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-04462'; 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-ZKXD-9-0','00048967','DP-04462BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','250000','2026-11-04','250000','2.500','100.00','925','270000','100000.00','1','0.14', 'input','2026-11-04 10:01:15','2.500','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04462BIP','1','RS 20 5','','DP-04462'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-9-0','00048967'); 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-04','PSPRT-ZKXD-9-0','PSPRT','TOKO','PSNB','100.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04462BIP '); 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-04519'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZKXD-10-0','00048968','DP-04519BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','4295500','2026-11-04','4295500','2.300','83.00','75','420000','2250000.00','1','0.14', 'input','2026-11-04 10:03:08','2.300','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04519BIP','1','RS 8','','DP-04519'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZKXD-10-0','00048968'); 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-04','PSGT-ZKXD-10-0','PSGT','TOKO','PSNB','83.00','2.300','2.300','1','2.300','2.300','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04519BIP '); 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-04560'; 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-ZKXD-11-0','00048969','DP-04560BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','1098500','2026-11-04','1098500','2.860','32.00','25','260000','1200000.00','1','0.14', 'input','2026-11-04 10:04:51','2.860','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04560BIP','1','RS 18 5','','DP-04560'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXD-11-0','00048969'); 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-04','PSPLT-ZKXD-11-0','PSPLT','TOKO','PSNB','32.00','2.860','2.860','1','2.860','2.860','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04560BIP '); 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-04473'; 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-ZKXD-12-0','00048970','DP-04473BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','457000','2026-11-04','457000','2.240','17.00','10','390000','1200000.00','1','0.14', 'input','2026-11-04 10:06:35','2.240','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04473BIP','1','RS 8','','DP-04473'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXD-12-0','00048970'); 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-04','PSPLT-ZKXD-12-0','PSPLT','TOKO','PSNB','17.00','2.240','2.240','1','2.240','2.240','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04473BIP '); 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-04698'; 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-ZKXD-13-0','00048971','DP-04698BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','280000','2026-11-04','280000','1.370','17.00','10','500000','1200000.00','1','0.14', 'input','2026-11-04 10:08:10','1.370','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04698BIP','1','RS 15','','DP-04698'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXD-13-0','00048971'); 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-04','PSPLT-ZKXD-13-0','PSPLT','TOKO','PSNB','17.00','1.370','1.370','1','1.370','1.370','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04698BIP '); 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-04566'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZKXD-14-0','00048972','DP-04566DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2911500','2026-11-04','2911500','2.270','57.00','50','440000','2250000.00','1','0.14', 'input','2026-11-04 10:12:00','2.270','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04566DU','1','RS 14 5','','DP-04566'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZKXD-14-0','00048972'); 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-04','PSGT-ZKXD-14-0','PSGT','TOKO','DUPSN','57.00','2.270','2.270','1','2.270','2.270','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04566DU '); 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-04567'; 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-ZKXD-15-0','00048973','DP-04567DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1075500','2026-11-04','1075500','2.800','32.00','25','260000','1200000.00','1','0.14', 'input','2026-11-04 10:13:36','2.800','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04567DU','1','RS 16 5','','DP-04567'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKXD-15-0','00048973'); 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-04','PSPLT-ZKXD-15-0','PSPLT','TOKO','DUPSN','32.00','2.800','2.800','1','2.800','2.800','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04567DU '); 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-04538'; 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-ZKXD-16-0','00048974','DP-04538DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','165000','2026-11-04','165000','1.650','100.00','925','210000','100000.00','1','0.14', 'input','2026-11-04 10:15:11','1.650','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04538DU','1','RS 10','','DP-04538'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-16-0','00048974'); 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-04','PSPRT-ZKXD-16-0','PSPRT','TOKO','DUPSN','100.00','1.650','1.650','1','1.650','1.650','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04538DU '); 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-04777'; 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-ZKXD-17-0','00048975','DP-04777DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','243500','2026-11-04','243500','2.430','100.00','925','230000','100000.00','1','0.14', 'input','2026-11-04 10:16:37','2.430','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04777DU','1','RS 15 5','','DP-04777'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-17-0','00048975'); 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-04','PSPRT-ZKXD-17-0','PSPRT','TOKO','DUPSN','100.00','2.430','2.430','1','2.430','2.430','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04777DU '); 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-04537'; 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-ZKXD-18-0','00048976','DP-04537DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','341000','2026-11-04','341000','3.410','100.00','925','210000','100000.00','1','0.14', 'input','2026-11-04 10:18:08','3.410','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04537DU','1','RS 16','','DP-04537'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-18-0','00048976'); 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-04','PSPRT-ZKXD-18-0','PSPRT','TOKO','DUPSN','100.00','3.410','3.410','1','3.410','3.410','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04537DU '); 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-04514'; 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-ZKXD-19-0','00048977','DP-04514DU ','CINCIN PERAK SR02 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','362000','2026-11-04','362000','3.620','100.00','925','410000','100000.00','1','0.14', 'input','2026-11-04 10:19:58','3.620','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04514DU','1','RS 125 RS 19','','DP-04514'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-19-0','00048977'); 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-04','PSPRT-ZKXD-19-0','PSPRT','TOKO','DUPSN','100.00','3.620','3.620','1','3.620','3.620','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04514DU '); 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-04496'; 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-ZKXD-20-0','00048978','DP-04496DU ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','319000','2026-11-04','319000','3.190','100.00','925','410000','100000.00','1','0.14', 'input','2026-11-04 10:21:36','3.190','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04496DU','1','RS 9 RS 18','','DP-04496'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-20-0','00048978'); 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-04','PSPRT-ZKXD-20-0','PSPRT','TOKO','DUPSN','100.00','3.190','3.190','1','3.190','3.190','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04496DU '); 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 ('PLBDG-ZKXD-21-0','00048979','PLBDG-00173 ','CINCIN PALADIUM YL01 PLBDG-00173 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','424500','2026-11-04','424500','2.080','17.00','10','250000','1200000.00','1','0.14', 'input','2026-11-04 10:27:15','2.080','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 19 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZKXD-21-0','00048979'); 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-04','PLBDG-ZKXD-21-0','PLBDG','TOKO','PLBDG','17.00','2.080','2.080','1','2.080','2.080','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00173 '); 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 ('PLBDG-ZKXD-22-0','00048980','PLBDG-00174 ','CINCIN PALADIUM PLBDG-00174 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','639000','2026-11-04','639000','3.130','17.00','10','250000','1200000.00','1','0.14', 'input','2026-11-04 10:27:40','3.130','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 25','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZKXD-22-0','00048980'); 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-04','PLBDG-ZKXD-22-0','PLBDG','TOKO','PLBDG','17.00','3.130','3.130','1','3.130','3.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00174 '); 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 ('LXPLD-ZKXD-23-0','00048981','LXPLD-00013 ','CINCIN PALADIUM YL01 ','','GR','---','PLD','LXPLD','TOKO','DUPLD','504000','2026-11-04','504000','2.470','17.00','10','250000','1200000.00','1','0.04', 'input','2026-11-04 10:29:42','2.470','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 26 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPLD' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPLD','LXPLD-ZKXD-23-0','00048981'); 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-04','LXPLD-ZKXD-23-0','LXPLD','TOKO','DUPLD','17.00','2.470','2.470','1','2.470','2.470','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPLD'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPLD','LXPLD-00013 '); 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 ('LXPLD-ZKXD-24-0','00048982','LXPLD-00014 ','CINCIN PALADIUM LXPLD-00014 ','','GR','---','PLD','LXPLD','TOKO','DUPLD','681500','2026-11-04','681500','3.340','17.00','10','250000','1200000.00','1','0.04', 'input','2026-11-04 10:30:08','3.340','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 27 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPLD' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPLD','LXPLD-ZKXD-24-0','00048982'); 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-04','LXPLD-ZKXD-24-0','LXPLD','TOKO','DUPLD','17.00','3.340','3.340','1','3.340','3.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPLD'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPLD','LXPLD-00014 '); 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 ('PLSBY-ZKXD-25-0','00048983','PLSBY-00012 ','CINCIN PALADIUM YL01 PLSBY-00012 ','','GR','---','PLD','PLSBY','TOKO','SBYPLD','455000','2026-11-04','455000','2.230','17.00','10','250000','1200000.00','1','0.014', 'input','2026-11-04 10:31:45','2.230','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 23 5','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLSBY','PLSBY-ZKXD-25-0','00048983'); 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-04','PLSBY-ZKXD-25-0','PLSBY','TOKO','SBYPLD','17.00','2.230','2.230','1','2.230','2.230','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLSBY','PLSBY-00012 '); 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 ('PLSBY-ZKXD-26-0','00048984','PLSBY-00013 ','CINCIN PALADIUM PLSBY-00013 ','','GR','---','PLD','PLSBY','TOKO','SBYPLD','665500','2026-11-04','665500','3.260','17.00','10','250000','1200000.00','1','0.014', 'input','2026-11-04 10:32:09','3.260','0','','18200.00','','TOKO','FREETAG','','10','','','','1','RS 28','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLSBY','PLSBY-ZKXD-26-0','00048984'); 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-04','PLSBY-ZKXD-26-0','PLSBY','TOKO','SBYPLD','17.00','3.260','3.260','1','3.260','3.260','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLSBY','PLSBY-00013 '); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-04 ','10:41:00'); 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-04776'; 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-ZKXD-27-0','00048985','DP-04776DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','135000','2026-11-04','135000','1.350','100.00','925','340000','100000.00','1','0.14', 'input','2026-11-04 14:27:39','1.350','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04776DU','1','RS 9','','DP-04776'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKXD-27-0','00048985'); 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-04','PSPRT-ZKXD-27-0','PSPRT','TOKO','DUPSN','100.00','1.350','1.350','1','1.350','1.350','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04776DU '); 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 ('CKPRE-ZKXD-28-0','00048986','850K-18-1199 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','285000','2026-11-04','285000','2.850','100.00','925','410000','100000.00','1','0.04', 'input','2026-11-04 14:49:28','2.850','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-28-0','00048986'); 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-04','CKPRE-ZKXD-28-0','CKPRE','TOKO','PER','100.00','2.850','2.850','1','2.850','2.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-18-1199 '); 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 ('CKPRE-ZKXD-29-0','00048987','850K-185-1200 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','239000','2026-11-04','239000','2.390','100.00','925','350000','100000.00','1','0.04', 'input','2026-11-04 14:50:06','2.390','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-29-0','00048987'); 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-04','CKPRE-ZKXD-29-0','CKPRE','TOKO','PER','100.00','2.390','2.390','1','2.390','2.390','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-185-1200 '); 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 ('CKPRE-ZKXD-30-0','00048988','850K-12-1201 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','225000','2026-11-04','225000','2.250','100.00','925','350000','100000.00','1','0.04', 'input','2026-11-04 14:50:29','2.250','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-30-0','00048988'); 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-04','CKPRE-ZKXD-30-0','CKPRE','TOKO','PER','100.00','2.250','2.250','1','2.250','2.250','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-12-1201 '); 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 ('CKPRE-ZKXD-31-0','00048989','850K-11-1202 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','171000','2026-11-04','171000','1.710','100.00','925','270000','100000.00','1','0.04', 'input','2026-11-04 14:51:11','1.710','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-31-0','00048989'); 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-04','CKPRE-ZKXD-31-0','CKPRE','TOKO','PER','100.00','1.710','1.710','1','1.710','1.710','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-11-1202 '); 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 ('CKPRE-ZKXD-32-0','00048990','900K-12-1203 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','190000','2026-11-04','190000','1.900','100.00','925','350000','100000.00','1','0.04', 'input','2026-11-04 14:52:21','1.900','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-32-0','00048990'); 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-04','CKPRE-ZKXD-32-0','CKPRE','TOKO','PER','100.00','1.900','1.900','1','1.900','1.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-12-1203 '); 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 ('CKPRE-ZKXD-33-0','00048991','900K-14-1204 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','200000','2026-11-04','200000','2.000','100.00','925','350000','100000.00','1','0.04', 'input','2026-11-04 14:52:58','2.000','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-33-0','00048991'); 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-04','CKPRE-ZKXD-33-0','CKPRE','TOKO','PER','100.00','2.000','2.000','1','2.000','2.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-14-1204 '); 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 ('CKPRE-ZKXD-34-0','00048992','900K-13-1205 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','205500','2026-11-04','205500','2.050','100.00','925','370000','100000.00','1','0.04', 'input','2026-11-04 14:53:36','2.050','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-34-0','00048992'); 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-04','CKPRE-ZKXD-34-0','CKPRE','TOKO','PER','100.00','2.050','2.050','1','2.050','2.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-13-1205 '); 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 ('CKPRE-ZKXD-35-0','00048993','900K-12-1206 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','193000','2026-11-04','193000','1.930','100.00','925','370000','100000.00','1','0.04', 'input','2026-11-04 14:53:58','1.930','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-35-0','00048993'); 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-04','CKPRE-ZKXD-35-0','CKPRE','TOKO','PER','100.00','1.930','1.930','1','1.930','1.930','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-12-1206 '); 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 ('CKPRE-ZKXD-36-0','00048994','900K-10-1207 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','152000','2026-11-04','152000','1.520','100.00','925','430000','100000.00','1','0.04', 'input','2026-11-04 14:54:39','1.520','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-36-0','00048994'); 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-04','CKPRE-ZKXD-36-0','CKPRE','TOKO','PER','100.00','1.520','1.520','1','1.520','1.520','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-10-1207 '); 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 ('CKPRE-ZKXD-37-0','00048995','900K-105-1208 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','155000','2026-11-04','155000','1.550','100.00','925','430000','100000.00','1','0.04', 'input','2026-11-04 14:55:08','1.550','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-37-0','00048995'); 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-04','CKPRE-ZKXD-37-0','CKPRE','TOKO','PER','100.00','1.550','1.550','1','1.550','1.550','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-105-1208 '); 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 ('CKPRE-ZKXD-38-0','00048996','900K-13-1209 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','164000','2026-11-04','164000','1.640','100.00','925','430000','100000.00','1','0.04', 'input','2026-11-04 14:55:29','1.640','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-38-0','00048996'); 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-04','CKPRE-ZKXD-38-0','CKPRE','TOKO','PER','100.00','1.640','1.640','1','1.640','1.640','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','900K-13-1209 '); 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 ('CKPRE-ZKXD-39-0','00048997','1.2K-13-1210 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','230500','2026-11-04','230500','2.300','100.00','925','590000','100000.00','1','0.04', 'input','2026-11-04 14:56:16','2.300','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-39-0','00048997'); 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-04','CKPRE-ZKXD-39-0','CKPRE','TOKO','PER','100.00','2.300','2.300','1','2.300','2.300','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.2K-13-1210 '); 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 ('CKPRE-ZKXD-40-0','00048998','1.2K-115-1211 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','215000','2026-11-04','215000','2.150','100.00','925','590000','100000.00','1','0.04', 'input','2026-11-04 14:56:40','2.150','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-40-0','00048998'); 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-04','CKPRE-ZKXD-40-0','CKPRE','TOKO','PER','100.00','2.150','2.150','1','2.150','2.150','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.2K-115-1211 '); 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 ('CKPRE-ZKXD-41-0','00048999','1.2K-12-1212 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','227000','2026-11-04','227000','2.270','100.00','925','590000','100000.00','1','0.04', 'input','2026-11-04 14:57:01','2.270','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-41-0','00048999'); 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-04','CKPRE-ZKXD-41-0','CKPRE','TOKO','PER','100.00','2.270','2.270','1','2.270','2.270','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.2K-12-1212 '); 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-04947'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZKXD-42-0','00049000','DP-04947DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2116500','2026-11-04','2116500','2.090','45.00','375','430000','2250000.00','1','0.14', 'input','2026-11-04 15:05:23','2.090','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04947DU','1','RS 18','','DP-04947'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZKXD-42-0','00049000'); 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-04','PSGT-ZKXD-42-0','PSGT','TOKO','DUPSN','45.00','2.090','2.090','1','2.090','2.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04947DU '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0006','1','PLBDG-ZKXD-21-0','1','2.080','TOKO','PLBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZKXD-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLBDG-ZKXD-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLBDG-ZKXD-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLBDG-ZKXD-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PLBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PLBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLBDG-ZKXD-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PLBDG-ZKXD-21-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0006','2','PLBDG-ZKXD-22-0','1','3.130','TOKO','PLBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZKXD-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLBDG-ZKXD-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLBDG-ZKXD-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLBDG-ZKXD-22-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PLBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PLBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLBDG-ZKXD-22-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.130',berat_out_asli='3.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.130',berat_akhir_asli =berat_akhir_asli-'3.130' WHERE kode_barang='PLBDG-ZKXD-22-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-261104-0006','2026-11-04','2026-11-04','15:07','3.130','input','2026-11-04 15:07:59','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0007','1','LXPLD-ZKXD-23-0','1','2.470','TOKO','DUPLD'); DELETE FROM tm_barang_export WHERE kode_barang='LXPLD-ZKXD-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPLD-ZKXD-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPLD-ZKXD-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPLD-ZKXD-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPLD-ZKXD-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.470',berat_out_asli='2.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.470',berat_akhir_asli =berat_akhir_asli-'2.470' WHERE kode_barang='LXPLD-ZKXD-23-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0007','2','LXPLD-ZKXD-24-0','1','3.340','TOKO','DUPLD'); DELETE FROM tm_barang_export WHERE kode_barang='LXPLD-ZKXD-24-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPLD-ZKXD-24-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPLD-ZKXD-24-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPLD-ZKXD-24-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPLD-ZKXD-24-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.340',berat_out_asli='3.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.340',berat_akhir_asli =berat_akhir_asli-'3.340' WHERE kode_barang='LXPLD-ZKXD-24-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-261104-0007','2026-11-04','2026-11-04','15:08','3.340','input','2026-11-04 15:08:08','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0008','1','PSPRT-ZKXD-9-0','1','2.500','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.500' WHERE kode_barang='PSPRT-ZKXD-9-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0008','2','PSGT-ZKXD-10-0','1','2.300','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKXD-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKXD-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKXD-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKXD-10-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKXD-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='PSGT-ZKXD-10-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0008','3','PSPLT-ZKXD-11-0','1','2.860','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXD-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXD-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXD-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXD-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXD-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.860',berat_out_asli='2.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.860',berat_akhir_asli =berat_akhir_asli-'2.860' WHERE kode_barang='PSPLT-ZKXD-11-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0008','4','PSPLT-ZKXD-12-0','1','2.240','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXD-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXD-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXD-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXD-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXD-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.240',berat_out_asli='2.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.240',berat_akhir_asli =berat_akhir_asli-'2.240' WHERE kode_barang='PSPLT-ZKXD-12-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0008','5','PSPLT-ZKXD-13-0','1','1.370','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXD-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXD-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXD-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXD-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXD-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.370',berat_out_asli='1.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.370',berat_akhir_asli =berat_akhir_asli-'1.370' WHERE kode_barang='PSPLT-ZKXD-13-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-261104-0008','2026-11-04','2026-11-04','15:08','1.370','input','2026-11-04 15:08:22','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','1','PSGT-ZKXD-14-0','1','2.270','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKXD-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKXD-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKXD-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKXD-14-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKXD-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.270' WHERE kode_barang='PSGT-ZKXD-14-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','2','PSPLT-ZKXD-15-0','1','2.800','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXD-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKXD-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXD-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKXD-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKXD-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.800',berat_out_asli='2.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.800',berat_akhir_asli =berat_akhir_asli-'2.800' WHERE kode_barang='PSPLT-ZKXD-15-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','3','PSPRT-ZKXD-16-0','1','1.650','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.650',berat_out_asli='1.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.650',berat_akhir_asli =berat_akhir_asli-'1.650' WHERE kode_barang='PSPRT-ZKXD-16-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','4','PSPRT-ZKXD-17-0','1','2.430','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-17-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.430',berat_out_asli='2.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.430',berat_akhir_asli =berat_akhir_asli-'2.430' WHERE kode_barang='PSPRT-ZKXD-17-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','5','PSPRT-ZKXD-18-0','1','3.410','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.410',berat_out_asli='3.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.410',berat_akhir_asli =berat_akhir_asli-'3.410' WHERE kode_barang='PSPRT-ZKXD-18-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','6','PSPRT-ZKXD-19-0','1','3.620','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.620',berat_out_asli='3.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.620',berat_akhir_asli =berat_akhir_asli-'3.620' WHERE kode_barang='PSPRT-ZKXD-19-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','7','PSPRT-ZKXD-20-0','1','3.190','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-20-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.190',berat_out_asli='3.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.190',berat_akhir_asli =berat_akhir_asli-'3.190' WHERE kode_barang='PSPRT-ZKXD-20-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','8','PSPRT-ZKXD-27-0','1','1.350','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKXD-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKXD-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKXD-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKXD-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKXD-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.350',berat_out_asli='1.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.350',berat_akhir_asli =berat_akhir_asli-'1.350' WHERE kode_barang='PSPRT-ZKXD-27-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261104-0009','9','PSGT-ZKXD-42-0','1','2.090','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKXD-42-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKXD-42-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKXD-42-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKXD-42-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKXD-42-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.090',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.090',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='PSGT-ZKXD-42-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-261104-0009','2026-11-04','2026-11-04','15:08','2.090','input','2026-11-04 15:08:37','THIFA'); 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 ('CKPRE-ZKXD-43-0','00049001','500K-215-1213 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','CKPRE','TOKO','PER','217000','2026-11-04','217000','2.170','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:26:16','2.170','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-43-0','00049001'); 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-04','CKPRE-ZKXD-43-0','CKPRE','TOKO','PER','100.00','2.170','2.170','1','2.170','2.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-215-1213 '); 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 ('CKPRE-ZKXD-44-0','00049002','500K-165-1214 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','CKPRE','TOKO','PER','177000','2026-11-04','177000','1.770','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:26:40','1.770','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-44-0','00049002'); 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-04','CKPRE-ZKXD-44-0','CKPRE','TOKO','PER','100.00','1.770','1.770','1','1.770','1.770','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-165-1214 '); 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 ('CKPRE-ZKXD-45-0','00049003','500K-195-1215 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','CKPRE','TOKO','PER','203500','2026-11-04','203500','2.030','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:27:05','2.030','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-45-0','00049003'); 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-04','CKPRE-ZKXD-45-0','CKPRE','TOKO','PER','100.00','2.030','2.030','1','2.030','2.030','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-195-1215 '); 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 ('CKPRE-ZKXD-46-0','00049004','500K-165-1216 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','CKPRE','TOKO','PER','202000','2026-11-04','202000','2.020','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:27:29','2.020','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-46-0','00049004'); 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-04','CKPRE-ZKXD-46-0','CKPRE','TOKO','PER','100.00','2.020','2.020','1','2.020','2.020','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-165-1216 '); 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 ('CKPRE-ZKXD-47-0','00049005','500K-18-1217 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','CKPRE','TOKO','PER','213000','2026-11-04','213000','2.130','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:27:51','2.130','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-47-0','00049005'); 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-04','CKPRE-ZKXD-47-0','CKPRE','TOKO','PER','100.00','2.130','2.130','1','2.130','2.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-18-1217 '); 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 ('CKPRE-ZKXD-48-0','00049006','500K-155-1218 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','CKPRE','TOKO','PER','189000','2026-11-04','189000','1.890','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:28:15','1.890','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-48-0','00049006'); 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-04','CKPRE-ZKXD-48-0','CKPRE','TOKO','PER','100.00','1.890','1.890','1','1.890','1.890','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-155-1218 '); 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 ('CKPRE-ZKXD-49-0','00049007','750K-125-1219 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','283000','2026-11-04','283000','2.830','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:29:01','2.830','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-49-0','00049007'); 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-04','CKPRE-ZKXD-49-0','CKPRE','TOKO','PER','100.00','2.830','2.830','1','2.830','2.830','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','750K-125-1219 '); 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 ('CKPRE-ZKXD-50-0','00049008','750K-215-1220 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','287000','2026-11-04','287000','2.870','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:30:18','2.870','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-50-0','00049008'); 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-04','CKPRE-ZKXD-50-0','CKPRE','TOKO','PER','100.00','2.870','2.870','1','2.870','2.870','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','750K-215-1220 '); 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 ('CKPRE-ZKXD-51-0','00049009','750K-115-1221 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','274000','2026-11-04','274000','2.740','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:30:39','2.740','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-51-0','00049009'); 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-04','CKPRE-ZKXD-51-0','CKPRE','TOKO','PER','100.00','2.740','2.740','1','2.740','2.740','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','750K-115-1221 '); 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 ('CKPRE-ZKXD-52-0','00049010','750K-21-1222 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','238000','2026-11-04','238000','2.380','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:31:21','2.380','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-52-0','00049010'); 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-04','CKPRE-ZKXD-52-0','CKPRE','TOKO','PER','100.00','2.380','2.380','1','2.380','2.380','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','750K-21-1222 '); 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 ('CKPRE-ZKXD-53-0','00049011','750K-19-1223 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','235000','2026-11-04','235000','2.350','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:31:40','2.350','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-53-0','00049011'); 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-04','CKPRE-ZKXD-53-0','CKPRE','TOKO','PER','100.00','2.350','2.350','1','2.350','2.350','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','750K-19-1223 '); 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 ('CKPRE-ZKXD-54-0','00049012','750K-19-1224 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','250000','2026-11-04','250000','2.500','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:32:17','2.500','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-54-0','00049012'); 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-04','CKPRE-ZKXD-54-0','CKPRE','TOKO','PER','100.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','750K-19-1224 '); 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 ('CKPRE-ZKXD-55-0','00049013','800K-205-1225 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','381000','2026-11-04','381000','3.810','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:32:59','3.810','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-55-0','00049013'); 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-04','CKPRE-ZKXD-55-0','CKPRE','TOKO','PER','100.00','3.810','3.810','1','3.810','3.810','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-205-1225 '); 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 ('CKPRE-ZKXD-56-0','00049014','800K-19-1226 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','420000','2026-11-04','420000','4.200','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:33:37','4.200','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-56-0','00049014'); 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-04','CKPRE-ZKXD-56-0','CKPRE','TOKO','PER','100.00','4.200','4.200','1','4.200','4.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-19-1226 '); 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 ('CKPRE-ZKXD-57-0','00049015','800K-21-1227 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','422000','2026-11-04','422000','4.220','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:33:57','4.220','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-57-0','00049015'); 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-04','CKPRE-ZKXD-57-0','CKPRE','TOKO','PER','100.00','4.220','4.220','1','4.220','4.220','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-21-1227 '); 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 ('CKPRE-ZKXD-58-0','00049016','800K-21-1228 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','362000','2026-11-04','362000','3.620','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:34:31','3.620','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-58-0','00049016'); 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-04','CKPRE-ZKXD-58-0','CKPRE','TOKO','PER','100.00','3.620','3.620','1','3.620','3.620','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-21-1228 '); 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 ('CKPRE-ZKXD-59-0','00049017','800K-23-1229 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','369000','2026-11-04','369000','3.690','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:34:55','3.690','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-59-0','00049017'); 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-04','CKPRE-ZKXD-59-0','CKPRE','TOKO','PER','100.00','3.690','3.690','1','3.690','3.690','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-23-1229 '); 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 ('CKPRE-ZKXD-60-0','00049018','800K-20-1230 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','374000','2026-11-04','374000','3.740','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:35:31','3.740','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-60-0','00049018'); 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-04','CKPRE-ZKXD-60-0','CKPRE','TOKO','PER','100.00','3.740','3.740','1','3.740','3.740','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-20-1230 '); 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 ('CKPRE-ZKXD-61-0','00049019','800K-20-1231 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','350000','2026-11-04','350000','3.500','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:35:51','3.500','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-61-0','00049019'); 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-04','CKPRE-ZKXD-61-0','CKPRE','TOKO','PER','100.00','3.500','3.500','1','3.500','3.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-20-1231 '); 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 ('CKPRE-ZKXD-62-0','00049020','800K-18-1232 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','330000','2026-11-04','330000','3.300','100.00','925','200000','100000.00','1','0.04', 'input','2026-11-04 15:36:13','3.300','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZKXD-62-0','00049020'); 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-04','CKPRE-ZKXD-62-0','CKPRE','TOKO','PER','100.00','3.300','3.300','1','3.300','3.300','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-18-1232 ');