INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-19 ','08:13:05');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-18';
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-05-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-05-19';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-19 ','08:13:36');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFGRR-ZEAI-1-0','00043628','TFGRR75-85% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','GLRTF','5498000','2026-05-19','5498000','2.640','85.00','75','0','2450000.00','1','0.14', 'input','2026-05-19 08:24:25','2.640','0','','17500.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZEAI-1-0','00043628');
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-05-19','TFGRR-ZEAI-1-0','TFGRR','TOKO','GLRTF','85.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-85% ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260519-0001','1','PSPRE-ZEAH-8-0','1','1.460','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZEAH-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZEAH-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZEAH-8-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZEAH-8-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-ZEAH-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.460',berat_out_asli='1.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.460',berat_akhir_asli =berat_akhir_asli-'1.460' WHERE kode_barang='PSPRE-ZEAH-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260519-0001','2','PSPRE-ZEAH-9-0','1','1.630','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZEAH-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZEAH-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZEAH-9-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZEAH-9-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-ZEAH-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.630',berat_out_asli='1.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.630',berat_akhir_asli =berat_akhir_asli-'1.630' WHERE kode_barang='PSPRE-ZEAH-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-260519-0001','3','PSPRE-ZEAH-10-0','1','4.190','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZEAH-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZEAH-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZEAH-10-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZEAH-10-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-ZEAH-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.190',berat_out_asli='4.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.190',berat_akhir_asli =berat_akhir_asli-'4.190' WHERE kode_barang='PSPRE-ZEAH-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-260519-0001','4','PSPRE-ZEAH-11-0','1','3.290','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZEAH-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZEAH-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZEAH-11-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZEAH-11-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-ZEAH-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.290',berat_out_asli='3.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.290',berat_akhir_asli =berat_akhir_asli-'3.290' WHERE kode_barang='PSPRE-ZEAH-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-260519-0001','5','PSPRE-ZEAH-12-0','1','1.480','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZEAH-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZEAH-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZEAH-12-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZEAH-12-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-ZEAH-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.480',berat_out_asli='1.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.480',berat_akhir_asli =berat_akhir_asli-'1.480' WHERE kode_barang='PSPRE-ZEAH-12-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-260519-0001','2026-05-19','2026-05-19','08:26','1.480','input','2026-05-19 08:26:26','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260519-0002','1','PSPRT-ZEAH-13-0','1','3.410','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEAH-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZEAH-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEAH-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZEAH-13-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-ZEAH-13-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-ZEAH-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-260519-0002','2026-05-19','2026-05-19','08:26','3.410','input','2026-05-19 08:26:37','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260519-0003','1','TFGRR-ZEAI-1-0','1','2.640','TOKO','GLRTF');
DELETE FROM tm_barang_export WHERE kode_barang='TFGRR-ZEAI-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRR-ZEAI-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='TFGRR-ZEAI-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRR-ZEAI-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRR' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRR' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRR-ZEAI-1-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='TFGRR-ZEAI-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260519-0003','2026-05-19','2026-05-19','08:26','2.640','input','2026-05-19 08:26:51','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-19 ','08:27:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-19 ','10:51:40');
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-02099';
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-ZEAI-2-0','00043629','DP-02099BIP ','CINCIN PERAK SR-03 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','348000','2026-05-19','348000','3.480','100.00','925','410000','100000.00','1','0.14', 'input','2026-05-19 14:46:53','3.480','0','','17500.00','','TOKO','FREETAG','','2','','','PSN02099BIP','1','RS 17 RS 20','','DP-02099');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZEAI-2-0','00043629');
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-05-19','PSPRT-ZEAI-2-0','PSPRT','TOKO','PSNB','100.00','3.480','3.480','1','3.480','3.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02099BIP ');
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-ZEAI-3-0','00043630','700K-20-1070 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','170000','2026-05-19','170000','1.700','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:13:08','1.700','0','','17500.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-ZEAI-3-0','00043630');
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-05-19','CKPRE-ZEAI-3-0','CKPRE','TOKO','PER','100.00','1.700','1.700','1','1.700','1.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-20-1070 ');
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-ZEAI-4-0','00043631','700K-195-1071 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','173000','2026-05-19','173000','1.730','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:13:30','1.730','0','','17500.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-ZEAI-4-0','00043631');
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-05-19','CKPRE-ZEAI-4-0','CKPRE','TOKO','PER','100.00','1.730','1.730','1','1.730','1.730','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-195-1071 ');
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-ZEAI-5-0','00043632','700K-185-1072 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','213000','2026-05-19','213000','2.130','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:14:10','2.130','0','','17500.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-ZEAI-5-0','00043632');
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-05-19','CKPRE-ZEAI-5-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','700K-185-1072 ');
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-ZEAI-6-0','00043633','700K-17-1073 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','211000','2026-05-19','211000','2.110','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:14:29','2.110','0','','17500.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-ZEAI-6-0','00043633');
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-05-19','CKPRE-ZEAI-6-0','CKPRE','TOKO','PER','100.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-17-1073 ');
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-ZEAI-7-0','00043634','700K-18-1074 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','203500','2026-05-19','203500','2.030','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:15:06','2.030','0','','17500.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-ZEAI-7-0','00043634');
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-05-19','CKPRE-ZEAI-7-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','700K-18-1074 ');
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-ZEAI-8-0','00043635','700K-19-1075 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','191000','2026-05-19','191000','1.910','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:15:25','1.910','0','','17500.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-ZEAI-8-0','00043635');
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-05-19','CKPRE-ZEAI-8-0','CKPRE','TOKO','PER','100.00','1.910','1.910','1','1.910','1.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-19-1075 ');
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-ZEAI-9-0','00043636','800K-12-1076 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','155000','2026-05-19','155000','1.550','100.00','925','340000','100000.00','1','0.04', 'input','2026-05-19 16:16:07','1.550','0','','17500.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-ZEAI-9-0','00043636');
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-05-19','CKPRE-ZEAI-9-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','800K-12-1076 ');
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-ZEAI-10-0','00043637','800K-13-1077 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','160000','2026-05-19','160000','1.600','100.00','925','340000','100000.00','1','0.04', 'input','2026-05-19 16:16:34','1.600','0','','17500.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-ZEAI-10-0','00043637');
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-05-19','CKPRE-ZEAI-10-0','CKPRE','TOKO','PER','100.00','1.600','1.600','1','1.600','1.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-13-1077 ');
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-ZEAI-11-0','00043638','800K-125-1078 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','133000','2026-05-19','133000','1.330','100.00','925','370000','100000.00','1','0.04', 'input','2026-05-19 16:17:14','1.330','0','','17500.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-ZEAI-11-0','00043638');
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-05-19','CKPRE-ZEAI-11-0','CKPRE','TOKO','PER','100.00','1.330','1.330','1','1.330','1.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-125-1078 ');
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-ZEAI-12-0','00043639','800K-155-1079 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','132000','2026-05-19','132000','1.320','100.00','925','370000','100000.00','1','0.04', 'input','2026-05-19 16:17:34','1.320','0','','17500.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-ZEAI-12-0','00043639');
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-05-19','CKPRE-ZEAI-12-0','CKPRE','TOKO','PER','100.00','1.320','1.320','1','1.320','1.320','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-155-1079 ');
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-ZEAI-13-0','00043640','800K-21-1080 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','377000','2026-05-19','377000','3.770','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:18:14','3.770','0','','17500.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-ZEAI-13-0','00043640');
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-05-19','CKPRE-ZEAI-13-0','CKPRE','TOKO','PER','100.00','3.770','3.770','1','3.770','3.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-21-1080 ');
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-ZEAI-14-0','00043641','800K-20-1081 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','373000','2026-05-19','373000','3.730','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:18:51','3.730','0','','17500.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-ZEAI-14-0','00043641');
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-05-19','CKPRE-ZEAI-14-0','CKPRE','TOKO','PER','100.00','3.730','3.730','1','3.730','3.730','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-20-1081 ');
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-ZEAI-15-0','00043642','800K-19-1082 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','372000','2026-05-19','372000','3.720','100.00','925','200000','100000.00','1','0.04', 'input','2026-05-19 16:19:11','3.720','0','','17500.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-ZEAI-15-0','00043642');
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-05-19','CKPRE-ZEAI-15-0','CKPRE','TOKO','PER','100.00','3.720','3.720','1','3.720','3.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-19-1082 ');
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-ZEAI-16-0','00043643','1.0K-13-1083 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','304000','2026-05-19','304000','3.040','100.00','925','450000','100000.00','1','0.04', 'input','2026-05-19 16:20:10','3.040','0','','17500.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-ZEAI-16-0','00043643');
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-05-19','CKPRE-ZEAI-16-0','CKPRE','TOKO','PER','100.00','3.040','3.040','1','3.040','3.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.0K-13-1083 ');
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-ZEAI-17-0','00043644','1.0K-12-1084 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','301000','2026-05-19','301000','3.010','100.00','925','450000','100000.00','1','0.04', 'input','2026-05-19 16:20:32','3.010','0','','17500.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-ZEAI-17-0','00043644');
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-05-19','CKPRE-ZEAI-17-0','CKPRE','TOKO','PER','100.00','3.010','3.010','1','3.010','3.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.0K-12-1084 ');
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-ZEAI-18-0','00043645','1.0K-14-1085 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','311000','2026-05-19','311000','3.110','100.00','925','450000','100000.00','1','0.04', 'input','2026-05-19 16:20:54','3.110','0','','17500.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-ZEAI-18-0','00043645');
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-05-19','CKPRE-ZEAI-18-0','CKPRE','TOKO','PER','100.00','3.110','3.110','1','3.110','3.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.0K-14-1085 ');