INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-13 ','08:32:17');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-12';
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-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-12';
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-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-12' 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-13';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-13 ','08:32:42');
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-02021';
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-ZEAC-1-0','00043545','DP-02021MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','864000','2026-05-13','864000','2.250','32.00','25','260000','1200000.00','1','0.14', 'input','2026-05-13 08:36:47','2.250','0','','17500.00','','TOKO','FREETAG','','10','','','PSN02021MM','1','RS 13 5','','DP-02021');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZEAC-1-0','00043545');
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-13','PSPLT-ZEAC-1-0','PSPLT','TOKO','MMPSN','32.00','2.250','2.250','1','2.250','2.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02021MM ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260513-0001','1','PSPLT-ZEAC-1-0','1','2.250','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEAC-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZEAC-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEAC-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZEAC-1-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='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='PSPLT-ZEAC-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.250',berat_out_asli='2.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.250',berat_akhir_asli =berat_akhir_asli-'2.250' WHERE kode_barang='PSPLT-ZEAC-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-260513-0001','2026-05-13','2026-05-13','08:52','2.250','input','2026-05-13 08:52:05','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-13 ','09:14:44');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260502-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260502-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-2-0','00043546','CBRE-02174 ','CINCIN CBRE-02174 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','8471000','2026-05-13','8471000','4.610','75.00','75.00','0','2450000.00','1','0.04', 'input','2026-05-13 10:24:28','4.610','0','227.20','17500.00','0','TOKO','FREETAG','','10','','0','IDB 44 500 000','4','RS11 10B65 0526','BE-260502-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-2-0','00043546');
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-13','CBRE-ZEAC-2-0','CBRE','TOKO','CBRE.BALIK','75.00','4.610','4.610','1','4.610','4.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02174 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-2-0','00043546','RD','42','0.300 ','320','96');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-2-0','00043546','RD','14','0.410 ','320','131.2');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0001','1','CBRE-ZEAC-2-0','1','4.610','4.610','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-2-0','75.00','1','4.610','4.610','1','4.610','4.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.610',berat_out_asli=berat_out_asli+'4.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0001','2026-05-13','2026-05-13','10:24','4.61','input','2026-05-13 10:24:45');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260502-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260502-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-3-0','00043547','CBRE-02327 ','CINCIN CBRE-02327 ','','GR','---','DM','CBRE','TOKO','CBRE','14810500','2026-05-13','14810500','8.060','75.00','75','0','2450000.00','1','0.04', 'input','2026-05-13 10:26:15','8.060','0','276.50','17500.00','','TOKO','FREETAG','','10','','0','IDB 68 000 000','2','RS21 11B6 0526','BE-260502-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-3-0','00043547');
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-13','CBRE-ZEAC-3-0','CBRE','TOKO','CBRE','75.00','8.060','8.060','1','8.060','8.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02327 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-3-0','00043547','RD','1','0.190 ','950','180.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-3-0','00043547','RD','48','0.300 ','320','96');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0002','1','CBRE-ZEAC-3-0','1','8.060','8.060','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-3-0','75.00','1','8.060','8.060','1','8.060','8.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.060',berat_out_asli=berat_out_asli+'8.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0002','2026-05-13','2026-05-13','10:26','8.06','input','2026-05-13 10:26:33');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260505-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260505-0004';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('ABRE-ZEAC-4-0','00043548','ABRE-00306 ','GIWANG ABRE-00306 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','9252500','2026-05-13','9252500','4.550','83.00','75.00','0','2450000.00','1','0.04', 'input','2026-05-13 10:28:34','4.550','550000','356.40','17500.00','0','TOKO','FREETAG','','10','','0','IDB 55 500 000','4','16B0 0526','BE-260505-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZEAC-4-0','00043548');
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-13','ABRE-ZEAC-4-0','ABRE','TOKO','ABRE.BALIK','83.00','4.550','4.550','1','4.550','4.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00306 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZEAC-4-0','00043548','RD','44','0.280 ','450','126');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZEAC-4-0','00043548','RD','12','0.400 ','420','168');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZEAC-4-0','00043548','RD','2','0.130 ','480','62.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0003','1','ABRE-ZEAC-4-0','1','4.550','4.550','TOKO','ABRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZEAC-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','ABRE','ABRE-ZEAC-4-0','83.00','1','4.550','4.550','1','4.550','4.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.550',berat_out_asli=berat_out_asli+'4.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='ABRE-ZEAC-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0003','2026-05-13','2026-05-13','10:28','4.55','input','2026-05-13 10:28:49');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260505-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260505-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-5-0','00043549','CBRE-03640 ','CINCIN CBRE-03640 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','10715500','2026-05-13','10715500','4.970','88.00','75','0','2450000.00','1','0.04', 'input','2026-05-13 10:30:25','4.970','0','315.25','17500.00','','TOKO','FREETAG','','10','','0','IDB 56 000 000','3','RS14 16B0 0526','BE-260505-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-5-0','00043549');
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-13','CBRE-ZEAC-5-0','CBRE','TOKO','CBRE.BALIK','88.00','4.970','4.970','1','4.970','4.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03640 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-5-0','00043549','RD','46','0.175 ','450','78.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-5-0','00043549','RD','5','0.430 ','550','236.5');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0004','1','CBRE-ZEAC-5-0','1','4.970','4.970','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-5-0','88.00','1','4.970','4.970','1','4.970','4.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.970',berat_out_asli=berat_out_asli+'4.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0004','2026-05-13','2026-05-13','10:30','4.97','input','2026-05-13 10:30:38');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260507-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260507-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-6-0','00043550','CBRE-06220 ','CINCIN CBRE-06220 ','','GR','---','DM','CBRE','TOKO','CBRE','2370500','2026-05-13','2370500','1.290','75.00','75','0','2450000.00','1','0.04', 'input','2026-05-13 10:33:16','1.290','100000','68.20','17500.00','','TOKO','FREETAG','','10','','0','IDB 13 000 000','2','RS12 3B6 0526','BE-260507-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-6-0','00043550');
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-13','CBRE-ZEAC-6-0','CBRE','TOKO','CBRE','75.00','1.290','1.290','1','1.290','1.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06220 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-6-0','00043550','RD','1','0.110 ','620','68.2');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0005','1','CBRE-ZEAC-6-0','1','1.290','1.290','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-6-0','75.00','1','1.290','1.290','1','1.290','1.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.290',berat_out_asli=berat_out_asli+'1.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0005','2026-05-13','2026-05-13','10:33','1.29','input','2026-05-13 10:33:30');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260507-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260507-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-7-0','00043551','CBRE-06316 ','CINCIN CBRE-06316 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3823500','2026-05-13','3823500','1.880','83.00','75','0','2450000.00','1','0.04', 'input','2026-05-13 10:34:48','1.880','0','256.80','17500.00','','TOKO','FREETAG','','10','','0','IDB 31 000 000','3','RS125 8B0 0526','BE-260507-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-7-0','00043551');
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-13','CBRE-ZEAC-7-0','CBRE','TOKO','CBRE.BALIK','83.00','1.880','1.880','1','1.880','1.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06316 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-7-0','00043551','RD','8','0.535 ','480','256.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0006','1','CBRE-ZEAC-7-0','1','1.880','1.880','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-7-0','83.00','1','1.880','1.880','1','1.880','1.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.880',berat_out_asli=berat_out_asli+'1.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0006','2026-05-13','2026-05-13','10:34','1.88','input','2026-05-13 10:35:06');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260508-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260508-0005';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-8-0','00043552','CBRE-03721 ','CINCIN CBRE-03721 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5384000','2026-05-13','5384000','2.930','75.00','75.00','0','2450000.00','1','0.04', 'input','2026-05-13 10:37:38','2.930','0','152.35','17500.00','0','TOKO','FREETAG','','10','','0','IDB 30 000 000','4','RS13 8B0 0526','BE-260508-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-8-0','00043552');
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-13','CBRE-ZEAC-8-0','CBRE','TOKO','CBRE.BALIK','75.00','2.930','2.930','1','2.930','2.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03721 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-8-0','00043552','RD','8','0.030 ','320','9.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-8-0','00043552','RD','34','0.300 ','320','96');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-8-0','00043552','RD','1','0.085 ','550','46.75');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0007','1','CBRE-ZEAC-8-0','1','2.930','2.930','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-8-0','75.00','1','2.930','2.930','1','2.930','2.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.930',berat_out_asli=berat_out_asli+'2.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0007','2026-05-13','2026-05-13','10:37','2.93','input','2026-05-13 10:37:53');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260508-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260508-0004';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-9-0','00043553','CBRE-04845 ','CINCIN CBRE-04845 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5200500','2026-05-13','5200500','2.830','75.00','75.00','0','2450000.00','1','0.04', 'input','2026-05-13 10:39:36','2.830','0','184.00','17500.00','0','TOKO','FREETAG','','10','','0','IDB 31 500 000','3','RS14 7B95 0526','BE-260508-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-9-0','00043553');
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-13','CBRE-ZEAC-9-0','CBRE','TOKO','CBRE.BALIK','75.00','2.830','2.830','1','2.830','2.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04845 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-9-0','00043553','RD','26','0.150 ','320','48');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-9-0','00043553','RD','4','0.050 ','320','16');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-9-0','00043553','RD','1','0.160 ','750','120');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0008','1','CBRE-ZEAC-9-0','1','2.830','2.830','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-9-0','75.00','1','2.830','2.830','1','2.830','2.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.830',berat_out_asli=berat_out_asli+'2.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0008','2026-05-13','2026-05-13','10:39','2.83','input','2026-05-13 10:39:50');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260508-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260508-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-10-0','00043554','CBRE-06828 ','CBRE-06828 GIA 6411829671 ','','GR','---','DM','CBRE','TOKO','CBRE','4413000','2026-05-13','4413000','2.170','83.00','75','0','2450000.00','1','0.04', 'input','2026-05-13 10:46:10','2.170','0','323.25','17500.00','','TOKO','FREETAG','','10','','0','GDB 36 500 000','2','FVVS2 10B0 0526','BE-260508-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-10-0','00043554');
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-13','CBRE-ZEAC-10-0','CBRE','TOKO','CBRE','83.00','2.170','2.170','1','2.170','2.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06828 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-10-0','00043554','RD','20','0.165 ','450','74.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-10-0','00043554','RD','8','0.020 ','450','9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-10-0','00043554','RD','1','0.160 ','1500','240');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0009','1','CBRE-ZEAC-10-0','1','2.170','2.170','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-10-0','83.00','1','2.170','2.170','1','2.170','2.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.170',berat_out_asli=berat_out_asli+'2.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0009','2026-05-13','2026-05-13','10:46','2.17','input','2026-05-13 10:46:24');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260508-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260508-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('ABRE-ZEAC-11-0','00043555','ABRE-00206 ','ANTING ABRE-00206 ','','GR','---','DM','ABRE','TOKO','ABRE','2150000','2026-05-13','2150000','1.170','75.00','75.00','0','2450000.00','1','0.04', 'input','2026-05-13 10:48:19','1.170','0','65.25','17500.00','','TOKO','FREETAG','','10','','0','IDB 13 000 000','2','3B15 0526','BE-260508-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZEAC-11-0','00043555');
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-13','ABRE-ZEAC-11-0','ABRE','TOKO','ABRE','75.00','1.170','1.170','1','1.170','1.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00206 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZEAC-11-0','00043555','RD','30','0.145 ','450','65.25');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0010','1','ABRE-ZEAC-11-0','1','1.170','1.170','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZEAC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','ABRE','ABRE-ZEAC-11-0','75.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='ABRE-ZEAC-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0010','2026-05-13','2026-05-13','10:48','1.17','input','2026-05-13 10:48:32');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260508-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260508-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-12-0','00043556','CBRE-05765 ','CINCIN CBRE-05765 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','8703500','2026-05-13','8703500','4.280','83.00','75','0','2450000.00','1','0.04', 'input','2026-05-13 10:50:19','4.280','0','344.25','17500.00','','TOKO','FREETAG','','10','','0','IDB 53 000 000','3','RS135 14B6 0526','BE-260508-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-12-0','00043556');
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-13','CBRE-ZEAC-12-0','CBRE','TOKO','CBRE.BALIK','83.00','4.280','4.280','1','4.280','4.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05765 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-12-0','00043556','RD','8','0.050 ','450','22.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-12-0','00043556','RD','114','0.545 ','450','245.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-12-0','00043556','RD','23','0.170 ','450','76.5');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260513-0011','1','CBRE-ZEAC-12-0','1','4.280','4.280','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZEAC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-05-13','TOKO','SEM-BALIK','CBRE','CBRE-ZEAC-12-0','83.00','1','4.280','4.280','1','4.280','4.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.280',berat_out_asli=berat_out_asli+'4.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-05-13' AND kode_barang='CBRE-ZEAC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260513-0011','2026-05-13','2026-05-13','10:50','4.28','input','2026-05-13 10:50:32');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260511-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260511-0001';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZEAC-13-0','00043557','CBRE-07043 ','CINCIN CBRE-07043 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','1507000','2026-05-13','1507000','0.820','75.00','75','0','2450000.00','1','0.14', 'input','2026-05-13 10:52:17','0.820','0','9.60','17500.00','','TOKO','FREETAG','','10','','','IDB 6 000 000','1','RS13 1B3 0526','BE-260511-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZEAC-13-0','00043557');
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-13','CBRE-ZEAC-13-0','CBRE','TOKO','SEM-BALIK','75.00','0.820','0.820','1','0.820','0.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-07043 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZEAC-13-0','00043557','RD','1','0.030 ','320','9.6');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260511-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260511-0001';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFA-ZEAC-14-0','00043558','TFA-21111 ','ANTING TFA-21111 ','','GR','---','DM','TFA','TOKO','SEM-BALIK','7422500','2026-05-13','7422500','3.650','83.00','75','0','2450000.00','1','0.14', 'input','2026-05-13 10:54:55','3.650','200000','255.45','17500.00','','TOKO','FREETAG','','10','','','IDB 43 500 000','1','12B0 0526','FB-260511-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFA' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFA','TFA-ZEAC-14-0','00043558');
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-13','TFA-ZEAC-14-0','TFA','TOKO','SEM-BALIK','83.00','3.650','3.650','1','3.650','3.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFA';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFA','TFA-21111 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFA-ZEAC-14-0','00043558','RD','58','0.325 ','450','146.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFA-ZEAC-14-0','00043558','RD','14','0.260 ','420','109.2');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-13 ','11:30:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-05-13 ','16:50:51');