INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250750401','input','1',' MEF3E XX H','TOKO','PM-F','F3E-YHBH-130-0','GL XX CAPELLA CD VAR HW 8K ','','1.600','1','100.00','1688000','0','0','15000','1688000','0','0','0','1688000','FIT','00367116','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHBH-130-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YHBH-130-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250750401','2025-10-25','1.600','2025-10-25','07:50:40','PLG0025384','1688000','1688000','0','1688000','1688000','input','2025-10-25 07:50:40','F32525075040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250750401','2025-10-25','07:50:40','FIT','1688000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0002','D','2025-10-25','07:50:40','input','PENJUALAN','F325250750401','442006000','1688000','443694000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250908371','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YJBC-80-0','CC X MODEL MATA CM 12 8K ','','0.830','1','100.00','863000','0','0','15000','860000','0','0','0','860000','SIN','00374398','E2D','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBC-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YJBC-80-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250908371','2025-10-25','0.830','2025-10-25','09:08:38','PLG0025385','860000','860000','0','860000','860000','input','2025-10-25 09:08:37','F32525090837');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250908371','2025-10-25','09:08:38','SIN','860000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0003','D','2025-10-25','09:08:38','input','PENJUALAN','F325250908371','443694000','860000','444554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='860000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250908371' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250908372','input',' 1',' MEF3E LT ','TOKO','PM-F','F3E-YJBA-260-0','GL GHENIA SLEP LT 8K ','','1.070','1','100.00','1129000','0','0','15000','1130000','0','0','0','1130000','SIN','00374137','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBA-260-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YJBA-260-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250908372','2025-10-25','1.070','2025-10-25','09:08:38','PLG0025386','1130000','1130000','0','1130000','1130000','input','2025-10-25 09:08:37','F32525090837');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250908372','2025-10-25','09:08:38','SIN','1130000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0004','D','2025-10-25','09:08:38','input','PENJUALAN','F325250908372','444554000','1130000','445684000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1130000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250908372' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250910141','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-YJAC-201-0','CC X VELG POLOS CM 20 8K ','','1.000','1','100.00','1035000','0','0','15000','1035000','0','0','0','1035000','SIN','00372931','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJAC-201-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YJAC-201-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250910141','2025-10-25','1.000','2025-10-25','09:10:15','PLG0025387','1035000','1035000','0','1035000','1035000','input','2025-10-25 09:10:14','F32525091014');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250910141','2025-10-25','09:10:15','SIN','1035000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0005','D','2025-10-25','09:10:15','input','PENJUALAN','F325250910141','445684000','1035000','446719000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250953301','input','1',' MEE1 LG 11','TOKO','PM-E','E1E-YIXH-37-0','CC MODEL HATI SLEP VAR LG 11 8K ','','0.520','1','100.00','549000','0','0','15000','550000','0','0','0','550000','SIN','00368593','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIXH-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1E-YIXH-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250953301','2025-10-25','0.520','2025-10-25','09:53:31','PLG0025388','550000','550000','0','550000','550000','input','2025-10-25 09:53:30','F32525095330');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250953301','2025-10-25','09:53:31','SIN','550000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0006','D','2025-10-25','09:53:31','input','PENJUALAN','F325250953301','446719000','550000','447269000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='550000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250953301' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250953302','input',' 1',' MEE1 CMP 1','TOKO','PM-E','E1E-YGAF-247-0','CC MODEL DAUN SLEP VAR CMP 12 8K ','','0.780','1','100.00','823000','0','0','15000','823000','0','0','0','823000','SIN','00361073','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YGAF-247-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1E-YGAF-247-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250953302','2025-10-25','0.780','2025-10-25','09:53:31','PLG0025389','823000','823000','0','823000','823000','input','2025-10-25 09:53:30','F32525095330');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250953302','2025-10-25','09:53:31','SIN','823000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0007','D','2025-10-25','09:53:31','input','PENJUALAN','F325250953302','447269000','823000','448092000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='823000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250953302' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250953303','input',' 1',' MEB1 LG PE','TOKO','PM-B','B1E-YJXD-305-0','GW TUSUK MODEL MATA LG PE 8K ','','0.570','1','100.00','601000','0','0','15000','602000','0','0','0','602000','SIN','00372285','B1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-305-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='B1E-YJXD-305-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250953303','2025-10-25','0.570','2025-10-25','09:53:31','PLG0025390','602000','602000','0','602000','602000','input','2025-10-25 09:53:30','F32525095330');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250953303','2025-10-25','09:53:31','SIN','602000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0008','D','2025-10-25','09:53:31','input','PENJUALAN','F325250953303','448092000','602000','448694000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250953303' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251015091','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YFBA-104-0','CC X MODEL MATA CM 14 8K ','','1.280','1','100.00','1325000','0','0','15000','1325000','0','0','0','1325000','SIN','00358378','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFBA-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YFBA-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251015091','2025-10-25','1.280','2025-10-25','10:15:09','PLG0025391','1325000','1325000','0','1325000','1325000','input','2025-10-25 10:15:09','F32525101509');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251015091','2025-10-25','10:15:09','SIN','1325000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0009','D','2025-10-25','10:15:09','input','PENJUALAN','F325251015091','448694000','1325000','450019000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1325000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325251015091' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251015092','input',' 1',' MDE1 CM 22','TOKO','PM-E','E1D-YEXC-444-0','CC VELG POLOS CM 22 8K ','','1.500','1','100.00','1552000','0','0','15000','1553000','0','0','0','1553000','SIN','00352755','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YEXC-444-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YEXC-444-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251015092','2025-10-25','1.500','2025-10-25','10:15:09','PLG0025392','1553000','1553000','0','1553000','1553000','input','2025-10-25 10:15:09','F32525101509');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251015092','2025-10-25','10:15:09','SIN','1553000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0010','D','2025-10-25','10:15:09','input','PENJUALAN','F325251015092','450019000','1553000','451572000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325251015092' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251037081','input','1',' MGE1 5K YT','TOKO','PM-E','E1G-YJXF-36-0','CC MODEL BONEKA CAT VAR YT 8K ','','0.350','1','100.00','383000','0','0','15000','385000','0','5000','0','390000','SIN','00372333','E1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YJXF-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1G-YJXF-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251037081','2025-10-25','0.350','2025-10-25','10:37:08','PLG0025393','385000','385000','5000','390000','390000','input','2025-10-25 10:37:08','F32525103708');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251037081','2025-10-25','10:37:08','SIN','390000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0011','D','2025-10-25','10:37:08','input','PENJUALAN','F325251037081','451572000','390000','451962000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251038201','input','1',' MED2E X BM','TOKO','PM-D','D2E-YIBD-140-0','LT X MODEL SPECTRA HITAM BM 8K ','','0.420','1','100.00','443000','0','0','15000','445000','0','0','0','445000','SIN','00370561','D2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIBD-140-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='D2E-YIBD-140-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251038201','2025-10-25','0.420','2025-10-25','10:38:20','PLG0025394','445000','445000','0','445000','445000','input','2025-10-25 10:38:20','F32525103820');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251038201','2025-10-25','10:38:20','SIN','445000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0012','D','2025-10-25','10:38:20','input','PENJUALAN','F325251038201','451962000','445000','452407000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251048131','input','1',' MEF3 UB ','TOKO','PM-F','F3E-YIBI-127-0','GL FANCY MODEL PITA VAR UB 8K ','','1.530','1','100.00','1614000','0','0','15000','1615000','0','0','0','1615000','SIN','00370998','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBI-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YIBI-127-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251048131','2025-10-25','1.530','2025-10-25','10:48:14','PLG0025395','1615000','1615000','0','1615000','1615000','input','2025-10-25 10:48:13','F32525104813');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251048131','2025-10-25','10:48:14','SIN','1615000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0013','D','2025-10-25','10:48:14','input','PENJUALAN','F325251048131','452407000','1615000','454022000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251106281','input','1',' MEE2 UB 10','TOKO','PM-E','E2E-YIBB-139-0','CC MODEL MATA VAR UB 10 8K ','','0.630','1','100.00','665000','0','0','15000','665000','0','0','0','665000','SIN','00370187','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBB-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2E-YIBB-139-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251106281','2025-10-25','0.630','2025-10-25','11:06:29','PLG0025396','665000','665000','0','665000','665000','input','2025-10-25 11:06:28','F32525110628');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251106281','2025-10-25','11:06:29','SIN','665000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0014','D','2025-10-25','11:06:29','input','PENJUALAN','F325251106281','454022000','665000','454687000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251110491','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-YIXH-35-0','CC MODEL DAUN VAR CM 14 8K ','','0.950','1','100.00','983000','0','0','15000','985000','0','0','0','985000','SIN','00368591','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIXH-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1D-YIXH-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251110491','2025-10-25','0.950','2025-10-25','11:10:50','PLG0025397','985000','985000','0','985000','985000','input','2025-10-25 11:10:49','F32525111049');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251110491','2025-10-25','11:10:50','SIN','985000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0015','D','2025-10-25','11:10:50','input','PENJUALAN','F325251110491','454687000','985000','455672000');
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='981500',harga_beli ='981500' WHERE kode_barcode='T0054890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='T0041707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2511000',harga_beli ='2511000' WHERE kode_barcode='T0055904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='T0066377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1530000',harga_beli ='1530000' WHERE kode_barcode='T0053497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='T0064776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1034000',harga_beli ='1034000' WHERE kode_barcode='00052974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='855000',harga_beli ='855000' WHERE kode_barcode='00064198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1245000',harga_beli ='1245000' WHERE kode_barcode='00070948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00087214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1224000',harga_beli ='1224000' WHERE kode_barcode='00090365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7311500',harga_beli ='7311500' WHERE kode_barcode='00091472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1582500',harga_beli ='1582500' WHERE kode_barcode='00092124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5286000',harga_beli ='5286000' WHERE kode_barcode='00093062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1319000',harga_beli ='1319000' WHERE kode_barcode='00093636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00093639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00096890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1424500',harga_beli ='1424500' WHERE kode_barcode='00099591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00099811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2226500',harga_beli ='2226500' WHERE kode_barcode='00100589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00102954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00103630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1656500',harga_beli ='1656500' WHERE kode_barcode='00119795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00120910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00120913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1160500',harga_beli ='1160500' WHERE kode_barcode='00125381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2532000',harga_beli ='2532000' WHERE kode_barcode='00132364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00132895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00133009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1150000',harga_beli ='1150000' WHERE kode_barcode='00138354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='10497500',harga_beli ='10497500' WHERE kode_barcode='00141171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='601500',harga_beli ='601500' WHERE kode_barcode='00142644' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1245000',harga_beli ='1245000' WHERE kode_barcode='00142650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00149726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00155944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00156105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1720000',harga_beli ='1720000' WHERE kode_barcode='00156899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3239000',harga_beli ='3239000' WHERE kode_barcode='00160815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='00165309' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00166158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00168498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1213500',harga_beli ='1213500' WHERE kode_barcode='00175403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1445500',harga_beli ='1445500' WHERE kode_barcode='00180742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1530000',harga_beli ='1530000' WHERE kode_barcode='00181225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1456000',harga_beli ='1456000' WHERE kode_barcode='00181466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1277000',harga_beli ='1277000' WHERE kode_barcode='00182849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00187806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='855000',harga_beli ='855000' WHERE kode_barcode='00194266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3144000',harga_beli ='3144000' WHERE kode_barcode='00194622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='00195794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='00195846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00201184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1561500',harga_beli ='1561500' WHERE kode_barcode='00209127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='00209522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1488000',harga_beli ='1488000' WHERE kode_barcode='00209700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00213359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1793500',harga_beli ='1793500' WHERE kode_barcode='00213369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00213405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1150000',harga_beli ='1150000' WHERE kode_barcode='00213686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00213848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3851000',harga_beli ='3851000' WHERE kode_barcode='00216509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2131500',harga_beli ='2131500' WHERE kode_barcode='00221400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2121000',harga_beli ='2121000' WHERE kode_barcode='00223055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00223723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1023500',harga_beli ='1023500' WHERE kode_barcode='00227840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1488000',harga_beli ='1488000' WHERE kode_barcode='00229047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1445500',harga_beli ='1445500' WHERE kode_barcode='00229143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1213500',harga_beli ='1213500' WHERE kode_barcode='00229297' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4325500',harga_beli ='4325500' WHERE kode_barcode='00230768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='8366500',harga_beli ='8366500' WHERE kode_barcode='00231510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1477000',harga_beli ='1477000' WHERE kode_barcode='00231736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1234500',harga_beli ='1234500' WHERE kode_barcode='00232223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4241500',harga_beli ='4241500' WHERE kode_barcode='00232953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00233756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3851000',harga_beli ='3851000' WHERE kode_barcode='00234146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1741000',harga_beli ='1741000' WHERE kode_barcode='00235731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='00235947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00236292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3270500',harga_beli ='3270500' WHERE kode_barcode='00237045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2078500',harga_beli ='2078500' WHERE kode_barcode='00237945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5286000',harga_beli ='5286000' WHERE kode_barcode='00240295' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1160500',harga_beli ='1160500' WHERE kode_barcode='00240727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6277500',harga_beli ='6277500' WHERE kode_barcode='00241193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00241197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1593500',harga_beli ='1593500' WHERE kode_barcode='00242997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1582500',harga_beli ='1582500' WHERE kode_barcode='00243028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1234500',harga_beli ='1234500' WHERE kode_barcode='00243065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1456000',harga_beli ='1456000' WHERE kode_barcode='00243157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1350500',harga_beli ='1350500' WHERE kode_barcode='00243242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='00243446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='00243900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1329500',harga_beli ='1329500' WHERE kode_barcode='00243916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2933000',harga_beli ='2933000' WHERE kode_barcode='00247320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1540500',harga_beli ='1540500' WHERE kode_barcode='00248398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1160500',harga_beli ='1160500' WHERE kode_barcode='00249654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2479500',harga_beli ='2479500' WHERE kode_barcode='00251708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='00253027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4621000',harga_beli ='4621000' WHERE kode_barcode='00253984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6277500',harga_beli ='6277500' WHERE kode_barcode='00254124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2933000',harga_beli ='2933000' WHERE kode_barcode='00254363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3365500',harga_beli ='3365500' WHERE kode_barcode='00255678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='00256394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00256496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00257782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1424500',harga_beli ='1424500' WHERE kode_barcode='00258005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1572000',harga_beli ='1572000' WHERE kode_barcode='00258745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1234500',harga_beli ='1234500' WHERE kode_barcode='00258749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2289500',harga_beli ='2289500' WHERE kode_barcode='00259322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00260039' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2426500',harga_beli ='2426500' WHERE kode_barcode='00260570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00261890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1139500',harga_beli ='1139500' WHERE kode_barcode='00262510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1277000',harga_beli ='1277000' WHERE kode_barcode='00262939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1519500',harga_beli ='1519500' WHERE kode_barcode='00263068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00264622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1234500',harga_beli ='1234500' WHERE kode_barcode='00265415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1741000',harga_beli ='1741000' WHERE kode_barcode='00265735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1509000',harga_beli ='1509000' WHERE kode_barcode='00266289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1213500',harga_beli ='1213500' WHERE kode_barcode='00266588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00268791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1023500',harga_beli ='1023500' WHERE kode_barcode='00268802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2532000',harga_beli ='2532000' WHERE kode_barcode='00268957' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00269112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00269135' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1667000',harga_beli ='1667000' WHERE kode_barcode='00270520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1160500',harga_beli ='1160500' WHERE kode_barcode='00272416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3640000',harga_beli ='3640000' WHERE kode_barcode='00272774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7417000',harga_beli ='7417000' WHERE kode_barcode='00272894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='475000',harga_beli ='475000' WHERE kode_barcode='00273013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='00273105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1983500',harga_beli ='1983500' WHERE kode_barcode='00273246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3503000',harga_beli ='3503000' WHERE kode_barcode='00273818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='00273870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='897000',harga_beli ='897000' WHERE kode_barcode='00273907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1720000',harga_beli ='1720000' WHERE kode_barcode='00273949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00274396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1287500',harga_beli ='1287500' WHERE kode_barcode='00275015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00275799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00277691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2121000',harga_beli ='2121000' WHERE kode_barcode='00277693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1488000',harga_beli ='1488000' WHERE kode_barcode='00277874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2289500',harga_beli ='2289500' WHERE kode_barcode='00277878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='00281431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00281716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='00282665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3534500',harga_beli ='3534500' WHERE kode_barcode='00283283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='11130500',harga_beli ='11130500' WHERE kode_barcode='00283322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='855000',harga_beli ='855000' WHERE kode_barcode='00284337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='00284364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1319000',harga_beli ='1319000' WHERE kode_barcode='00284430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1498500',harga_beli ='1498500' WHERE kode_barcode='00284994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5317500',harga_beli ='5317500' WHERE kode_barcode='00285379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00285674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1160500',harga_beli ='1160500' WHERE kode_barcode='00285792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00285979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00286016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00286148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2384500',harga_beli ='2384500' WHERE kode_barcode='00286322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00287251' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='00288392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2068000',harga_beli ='2068000' WHERE kode_barcode='00288619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00290272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00290282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1656500',harga_beli ='1656500' WHERE kode_barcode='00290322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00290441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00290448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='00290451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1245000',harga_beli ='1245000' WHERE kode_barcode='00290617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='00290730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='00290955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2353000',harga_beli ='2353000' WHERE kode_barcode='00290962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='00290980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='971000',harga_beli ='971000' WHERE kode_barcode='00290982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='00291018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00291024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1656500',harga_beli ='1656500' WHERE kode_barcode='00292788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='00293298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3218000',harga_beli ='3218000' WHERE kode_barcode='00293351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00294259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='00294260' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3766500',harga_beli ='3766500' WHERE kode_barcode='00294757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='8577500',harga_beli ='8577500' WHERE kode_barcode='00295141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='00295193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1013000',harga_beli ='1013000' WHERE kode_barcode='00295525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1530000',harga_beli ='1530000' WHERE kode_barcode='00297474' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1266000',harga_beli ='1266000' WHERE kode_barcode='00297551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00297627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2078500',harga_beli ='2078500' WHERE kode_barcode='00297756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00297949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1213500',harga_beli ='1213500' WHERE kode_barcode='00297951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00297985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3429000',harga_beli ='3429000' WHERE kode_barcode='00298269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2500500',harga_beli ='2500500' WHERE kode_barcode='00298345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00298456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1509000',harga_beli ='1509000' WHERE kode_barcode='00298488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4747500',harga_beli ='4747500' WHERE kode_barcode='00298977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1287500',harga_beli ='1287500' WHERE kode_barcode='00299014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='00299663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1350500',harga_beli ='1350500' WHERE kode_barcode='00300475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2901500',harga_beli ='2901500' WHERE kode_barcode='00300881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2321000',harga_beli ='2321000' WHERE kode_barcode='00301304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00301362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1160500',harga_beli ='1160500' WHERE kode_barcode='00301986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2616500',harga_beli ='2616500' WHERE kode_barcode='00302645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1488000',harga_beli ='1488000' WHERE kode_barcode='00302736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1213500',harga_beli ='1213500' WHERE kode_barcode='00302955' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1646000',harga_beli ='1646000' WHERE kode_barcode='00303154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1266000',harga_beli ='1266000' WHERE kode_barcode='00303862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1287500',harga_beli ='1287500' WHERE kode_barcode='00303915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='00304212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5549500',harga_beli ='5549500' WHERE kode_barcode='00304341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1846500',harga_beli ='1846500' WHERE kode_barcode='00304486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00304543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00304544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00304774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='960500',harga_beli ='960500' WHERE kode_barcode='00305005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1266000',harga_beli ='1266000' WHERE kode_barcode='00305303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3007000',harga_beli ='3007000' WHERE kode_barcode='00305436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00305485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1667000',harga_beli ='1667000' WHERE kode_barcode='00305493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='00305517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00305542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6277500',harga_beli ='6277500' WHERE kode_barcode='00306050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1582500',harga_beli ='1582500' WHERE kode_barcode='00306186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1350500',harga_beli ='1350500' WHERE kode_barcode='00306428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00306465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='971000',harga_beli ='971000' WHERE kode_barcode='00306541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00306938' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5507500',harga_beli ='5507500' WHERE kode_barcode='00307180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00307506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='00307837' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3123000',harga_beli ='3123000' WHERE kode_barcode='00308223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2954000',harga_beli ='2954000' WHERE kode_barcode='00308301' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00308327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3692500',harga_beli ='3692500' WHERE kode_barcode='00309100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='00309432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2954000',harga_beli ='2954000' WHERE kode_barcode='00309648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00309651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3861500',harga_beli ='3861500' WHERE kode_barcode='00309802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3724500',harga_beli ='3724500' WHERE kode_barcode='00309805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3112500',harga_beli ='3112500' WHERE kode_barcode='00309836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00309991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='971000',harga_beli ='971000' WHERE kode_barcode='00309992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='960500',harga_beli ='960500' WHERE kode_barcode='00310563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00310566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1699000',harga_beli ='1699000' WHERE kode_barcode='00310583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1709500',harga_beli ='1709500' WHERE kode_barcode='00311565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6383000',harga_beli ='6383000' WHERE kode_barcode='00313257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3460500',harga_beli ='3460500' WHERE kode_barcode='00313273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3566000',harga_beli ='3566000' WHERE kode_barcode='00313442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00314218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2754000',harga_beli ='2754000' WHERE kode_barcode='00314865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00315117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3292000',harga_beli ='3292000' WHERE kode_barcode='00315145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6668000',harga_beli ='6668000' WHERE kode_barcode='00315992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='760000',harga_beli ='760000' WHERE kode_barcode='00316165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2036500',harga_beli ='2036500' WHERE kode_barcode='00316576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2669500',harga_beli ='2669500' WHERE kode_barcode='00316606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00317399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00317438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5254000',harga_beli ='5254000' WHERE kode_barcode='00317470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1910000',harga_beli ='1910000' WHERE kode_barcode='00318645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1699000',harga_beli ='1699000' WHERE kode_barcode='00318960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='791500',harga_beli ='791500' WHERE kode_barcode='00319010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00319073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00319285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00319556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2279000',harga_beli ='2279000' WHERE kode_barcode='00319599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5243500',harga_beli ='5243500' WHERE kode_barcode='00320181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7248000',harga_beli ='7248000' WHERE kode_barcode='00320719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00320960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3956500',harga_beli ='3956500' WHERE kode_barcode='00321078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2817000',harga_beli ='2817000' WHERE kode_barcode='00321942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3144000',harga_beli ='3144000' WHERE kode_barcode='00322075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='696500',harga_beli ='696500' WHERE kode_barcode='00322385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7047500',harga_beli ='7047500' WHERE kode_barcode='00323272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00323774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6435500',harga_beli ='6435500' WHERE kode_barcode='00323870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='00323928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2817000',harga_beli ='2817000' WHERE kode_barcode='00324242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00324623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3481500',harga_beli ='3481500' WHERE kode_barcode='00324824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2532000',harga_beli ='2532000' WHERE kode_barcode='00325479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3576500',harga_beli ='3576500' WHERE kode_barcode='00325490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00326747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00327149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7290500',harga_beli ='7290500' WHERE kode_barcode='00327908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3270500',harga_beli ='3270500' WHERE kode_barcode='00327926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1488000',harga_beli ='1488000' WHERE kode_barcode='00328363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2110000',harga_beli ='2110000' WHERE kode_barcode='00328366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1825500',harga_beli ='1825500' WHERE kode_barcode='00331623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5328000',harga_beli ='5328000' WHERE kode_barcode='00333208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00333691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00333758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='855000',harga_beli ='855000' WHERE kode_barcode='00334287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00334313' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00334827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1656500',harga_beli ='1656500' WHERE kode_barcode='00336492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='00336531' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='8018000',harga_beli ='8018000' WHERE kode_barcode='00336675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00336721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2289500',harga_beli ='2289500' WHERE kode_barcode='00336800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00337009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2416000',harga_beli ='2416000' WHERE kode_barcode='00337578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00337715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2089000',harga_beli ='2089000' WHERE kode_barcode='00337729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4325500',harga_beli ='4325500' WHERE kode_barcode='00337735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00337736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00337822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1667000',harga_beli ='1667000' WHERE kode_barcode='00338009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4188500',harga_beli ='4188500' WHERE kode_barcode='00338085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7385000',harga_beli ='7385000' WHERE kode_barcode='00338088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00338089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3070500',harga_beli ='3070500' WHERE kode_barcode='00338668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1614500',harga_beli ='1614500' WHERE kode_barcode='00338969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5328000',harga_beli ='5328000' WHERE kode_barcode='00339259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00339401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00339404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1002500',harga_beli ='1002500' WHERE kode_barcode='00339417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='791500',harga_beli ='791500' WHERE kode_barcode='00339478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00339609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='844000',harga_beli ='844000' WHERE kode_barcode='00340090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2279000',harga_beli ='2279000' WHERE kode_barcode='00340149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5159000',harga_beli ='5159000' WHERE kode_barcode='00340450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00340726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='823000',harga_beli ='823000' WHERE kode_barcode='00340746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='823000',harga_beli ='823000' WHERE kode_barcode='00341878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='738500',harga_beli ='738500' WHERE kode_barcode='00341892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00341894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00341934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1688000',harga_beli ='1688000' WHERE kode_barcode='00342070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2142000',harga_beli ='2142000' WHERE kode_barcode='00342078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2110000',harga_beli ='2110000' WHERE kode_barcode='00342085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5338500',harga_beli ='5338500' WHERE kode_barcode='00342185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2732500',harga_beli ='2732500' WHERE kode_barcode='00342885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='791500',harga_beli ='791500' WHERE kode_barcode='00343199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00343203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00343205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00343206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3777000',harga_beli ='3777000' WHERE kode_barcode='00343376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4642000',harga_beli ='4642000' WHERE kode_barcode='00343741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6414500',harga_beli ='6414500' WHERE kode_barcode='00344205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2026000',harga_beli ='2026000' WHERE kode_barcode='00344589' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00344610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='844000',harga_beli ='844000' WHERE kode_barcode='00344624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='823000',harga_beli ='823000' WHERE kode_barcode='00344626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2184000',harga_beli ='2184000' WHERE kode_barcode='00344637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00344640' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00344643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00344647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00344648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5169500',harga_beli ='5169500' WHERE kode_barcode='00344657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5254000',harga_beli ='5254000' WHERE kode_barcode='00344658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5275000',harga_beli ='5275000' WHERE kode_barcode='00344796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1023500',harga_beli ='1023500' WHERE kode_barcode='00344918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00346059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00346125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00346126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2015500',harga_beli ='2015500' WHERE kode_barcode='00346336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2226500',harga_beli ='2226500' WHERE kode_barcode='00346576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='601500',harga_beli ='601500' WHERE kode_barcode='00346808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='833500',harga_beli ='833500' WHERE kode_barcode='00346936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00347203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1604000',harga_beli ='1604000' WHERE kode_barcode='00347246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='738500',harga_beli ='738500' WHERE kode_barcode='00347526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00347558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00347559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00347617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2437500',harga_beli ='2437500' WHERE kode_barcode='00347662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00347810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='749500',harga_beli ='749500' WHERE kode_barcode='00347905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00347920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00348349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00348814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00348844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00348853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00349218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00349231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2775000',harga_beli ='2775000' WHERE kode_barcode='00349281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='10550000',harga_beli ='10550000' WHERE kode_barcode='00349472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3323500',harga_beli ='3323500' WHERE kode_barcode='00349485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2089000',harga_beli ='2089000' WHERE kode_barcode='00349487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00349780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3028000',harga_beli ='3028000' WHERE kode_barcode='00349819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2131500',harga_beli ='2131500' WHERE kode_barcode='00349851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='00349921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2026000',harga_beli ='2026000' WHERE kode_barcode='00349947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='749500',harga_beli ='749500' WHERE kode_barcode='00350163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00350362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1751500',harga_beli ='1751500' WHERE kode_barcode='00350365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1667000',harga_beli ='1667000' WHERE kode_barcode='00350714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00351042' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00351242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00351247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00351387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='10571500',harga_beli ='10571500' WHERE kode_barcode='00351402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00351568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='475000',harga_beli ='475000' WHERE kode_barcode='00351570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='823000',harga_beli ='823000' WHERE kode_barcode='00351665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2479500',harga_beli ='2479500' WHERE kode_barcode='00352115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00352578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1709500',harga_beli ='1709500' WHERE kode_barcode='00352613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='665000',harga_beli ='665000' WHERE kode_barcode='00352778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00352779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6446500',harga_beli ='6446500' WHERE kode_barcode='00352862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00352891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='15930500',harga_beli ='15930500' WHERE kode_barcode='00353157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2532000',harga_beli ='2532000' WHERE kode_barcode='00353247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1688000',harga_beli ='1688000' WHERE kode_barcode='00353392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4958500',harga_beli ='4958500' WHERE kode_barcode='00353460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7237500',harga_beli ='7237500' WHERE kode_barcode='00353473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00353513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5233000',harga_beli ='5233000' WHERE kode_barcode='00353692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7448500',harga_beli ='7448500' WHERE kode_barcode='00353773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00353826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1667000',harga_beli ='1667000' WHERE kode_barcode='00353828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2458500',harga_beli ='2458500' WHERE kode_barcode='00353831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2564000',harga_beli ='2564000' WHERE kode_barcode='00353844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00354246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00354413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00354498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1076500',harga_beli ='1076500' WHERE kode_barcode='00354511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5296500',harga_beli ='5296500' WHERE kode_barcode='00354537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00354540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3671500',harga_beli ='3671500' WHERE kode_barcode='00354547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3566000',harga_beli ='3566000' WHERE kode_barcode='00354570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1899000',harga_beli ='1899000' WHERE kode_barcode='00354614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2637500',harga_beli ='2637500' WHERE kode_barcode='00354615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00354722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='738500',harga_beli ='738500' WHERE kode_barcode='00354768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2089000',harga_beli ='2089000' WHERE kode_barcode='00355730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='8419000',harga_beli ='8419000' WHERE kode_barcode='00355788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6182500',harga_beli ='6182500' WHERE kode_barcode='00355862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6362000',harga_beli ='6362000' WHERE kode_barcode='00355872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4252000',harga_beli ='4252000' WHERE kode_barcode='00355876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00355954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1371500',harga_beli ='1371500' WHERE kode_barcode='00355959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00356272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2384500',harga_beli ='2384500' WHERE kode_barcode='00356347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3228500',harga_beli ='3228500' WHERE kode_barcode='00356357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3460500',harga_beli ='3460500' WHERE kode_barcode='00356713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00356731' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00356767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5402000',harga_beli ='5402000' WHERE kode_barcode='00356771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3408000',harga_beli ='3408000' WHERE kode_barcode='00356951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='00357135' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00357277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='791500',harga_beli ='791500' WHERE kode_barcode='00357563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='9020500',harga_beli ='9020500' WHERE kode_barcode='00357582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1825500',harga_beli ='1825500' WHERE kode_barcode='00357585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1582500',harga_beli ='1582500' WHERE kode_barcode='00357587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='00357601' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1329500',harga_beli ='1329500' WHERE kode_barcode='00357631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2215500',harga_beli ='2215500' WHERE kode_barcode='00357806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00358033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1815000',harga_beli ='1815000' WHERE kode_barcode='00358120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2848500',harga_beli ='2848500' WHERE kode_barcode='00358194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5961000',harga_beli ='5961000' WHERE kode_barcode='00358213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='00358219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2110000',harga_beli ='2110000' WHERE kode_barcode='00358263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1224000',harga_beli ='1224000' WHERE kode_barcode='00358371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2205000',harga_beli ='2205000' WHERE kode_barcode='00358564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5286000',harga_beli ='5286000' WHERE kode_barcode='00358772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3408000',harga_beli ='3408000' WHERE kode_barcode='00358774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7575000',harga_beli ='7575000' WHERE kode_barcode='00358792' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='00358793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4072500',harga_beli ='4072500' WHERE kode_barcode='00358820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00358821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1983500',harga_beli ='1983500' WHERE kode_barcode='00358826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00359026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00359237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00359239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00359250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00359253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2722000',harga_beli ='2722000' WHERE kode_barcode='00359255' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2986000',harga_beli ='2986000' WHERE kode_barcode='00359334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00359337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='570000',harga_beli ='570000' WHERE kode_barcode='00359695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00359696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1793500',harga_beli ='1793500' WHERE kode_barcode='00359814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00359980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00359981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4684500',harga_beli ='4684500' WHERE kode_barcode='00360414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4399500',harga_beli ='4399500' WHERE kode_barcode='00360435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00360599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00360620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1097500',harga_beli ='1097500' WHERE kode_barcode='00360662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00360759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00360761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00361054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00361064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00361065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00361072' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00361186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='791500',harga_beli ='791500' WHERE kode_barcode='00361344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00361424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7364000',harga_beli ='7364000' WHERE kode_barcode='00361562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3503000',harga_beli ='3503000' WHERE kode_barcode='00361566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2943500',harga_beli ='2943500' WHERE kode_barcode='00361568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00361708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3197000',harga_beli ='3197000' WHERE kode_barcode='00361747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2680000',harga_beli ='2680000' WHERE kode_barcode='00361748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3387000',harga_beli ='3387000' WHERE kode_barcode='00361873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2848500',harga_beli ='2848500' WHERE kode_barcode='00361874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2426500',harga_beli ='2426500' WHERE kode_barcode='00361875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2332000',harga_beli ='2332000' WHERE kode_barcode='00361876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5275000',harga_beli ='5275000' WHERE kode_barcode='00362405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5085500',harga_beli ='5085500' WHERE kode_barcode='00362408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2690500',harga_beli ='2690500' WHERE kode_barcode='00362735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='422000',harga_beli ='422000' WHERE kode_barcode='00362777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4114500',harga_beli ='4114500' WHERE kode_barcode='00362798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00362807' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00363179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00363231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='485500',harga_beli ='485500' WHERE kode_barcode='00363237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00363239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00363283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1066000',harga_beli ='1066000' WHERE kode_barcode='00363292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6362000',harga_beli ='6362000' WHERE kode_barcode='00363352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='475000',harga_beli ='475000' WHERE kode_barcode='00363429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='464500',harga_beli ='464500' WHERE kode_barcode='00363634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1720000',harga_beli ='1720000' WHERE kode_barcode='00363819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2511000',harga_beli ='2511000' WHERE kode_barcode='00363925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00363962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='738500',harga_beli ='738500' WHERE kode_barcode='00363968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='760000',harga_beli ='760000' WHERE kode_barcode='00363969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='707000',harga_beli ='707000' WHERE kode_barcode='00363970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5286000',harga_beli ='5286000' WHERE kode_barcode='00364062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2089000',harga_beli ='2089000' WHERE kode_barcode='00364071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3270500',harga_beli ='3270500' WHERE kode_barcode='00364371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3176000',harga_beli ='3176000' WHERE kode_barcode='00364373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3724500',harga_beli ='3724500' WHERE kode_barcode='00364429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1519500',harga_beli ='1519500' WHERE kode_barcode='00364467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='00364468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00364470' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5191000',harga_beli ='5191000' WHERE kode_barcode='00364669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='717500',harga_beli ='717500' WHERE kode_barcode='00364804' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7279500',harga_beli ='7279500' WHERE kode_barcode='00364924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2975500',harga_beli ='2975500' WHERE kode_barcode='00364928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2099500',harga_beli ='2099500' WHERE kode_barcode='00364933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00365077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='738500',harga_beli ='738500' WHERE kode_barcode='00365078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1087000',harga_beli ='1087000' WHERE kode_barcode='00365363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00365368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5444000',harga_beli ='5444000' WHERE kode_barcode='00365416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3703500',harga_beli ='3703500' WHERE kode_barcode='00365431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='00365482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00365570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='749500',harga_beli ='749500' WHERE kode_barcode='00365767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2627000',harga_beli ='2627000' WHERE kode_barcode='00365942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='570000',harga_beli ='570000' WHERE kode_barcode='00366044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3197000',harga_beli ='3197000' WHERE kode_barcode='00366100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2026000',harga_beli ='2026000' WHERE kode_barcode='00366121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00366143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2627000',harga_beli ='2627000' WHERE kode_barcode='00366149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00366229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1192500',harga_beli ='1192500' WHERE kode_barcode='00366248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3112500',harga_beli ='3112500' WHERE kode_barcode='00366676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='8841000',harga_beli ='8841000' WHERE kode_barcode='00366685' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00366686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='812500',harga_beli ='812500' WHERE kode_barcode='00367240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00367241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00367310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00367403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00367462' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='00367488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3112500',harga_beli ='3112500' WHERE kode_barcode='00367489' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5191000',harga_beli ='5191000' WHERE kode_barcode='00367492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1150000',harga_beli ='1150000' WHERE kode_barcode='00367495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1772500',harga_beli ='1772500' WHERE kode_barcode='00367538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7353500',harga_beli ='7353500' WHERE kode_barcode='00367805' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3133500',harga_beli ='3133500' WHERE kode_barcode='00367852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='6330000',harga_beli ='6330000' WHERE kode_barcode='00367861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00367878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2121000',harga_beli ='2121000' WHERE kode_barcode='00367879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2268500',harga_beli ='2268500' WHERE kode_barcode='00367880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5328000',harga_beli ='5328000' WHERE kode_barcode='00367892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00367903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='00368156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00368406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4916500',harga_beli ='4916500' WHERE kode_barcode='00368579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5275000',harga_beli ='5275000' WHERE kode_barcode='00368581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4167500',harga_beli ='4167500' WHERE kode_barcode='00368582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00368596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='844000',harga_beli ='844000' WHERE kode_barcode='00368597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00368598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00368809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00368810' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4178000',harga_beli ='4178000' WHERE kode_barcode='00368878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1973000',harga_beli ='1973000' WHERE kode_barcode='00368922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='791500',harga_beli ='791500' WHERE kode_barcode='00369329' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00369341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='570000',harga_beli ='570000' WHERE kode_barcode='00369344' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='517000',harga_beli ='517000' WHERE kode_barcode='00369350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00369360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='717500',harga_beli ='717500' WHERE kode_barcode='00369364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00369365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='00369465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='876000',harga_beli ='876000' WHERE kode_barcode='00369466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00369475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00369479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='454000',harga_beli ='454000' WHERE kode_barcode='00369528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00369533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5169500',harga_beli ='5169500' WHERE kode_barcode='00369614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5307000',harga_beli ='5307000' WHERE kode_barcode='00369623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2289500',harga_beli ='2289500' WHERE kode_barcode='00369633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1277000',harga_beli ='1277000' WHERE kode_barcode='00369684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2859500',harga_beli ='2859500' WHERE kode_barcode='00369705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00369890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00370010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00370175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00370183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3017500',harga_beli ='3017500' WHERE kode_barcode='00370374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3270500',harga_beli ='3270500' WHERE kode_barcode='00370387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00370405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00370507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00370556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='475000',harga_beli ='475000' WHERE kode_barcode='00370557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7227000',harga_beli ='7227000' WHERE kode_barcode='00370572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2004500',harga_beli ='2004500' WHERE kode_barcode='00370576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3207500',harga_beli ='3207500' WHERE kode_barcode='00370578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='8271500',harga_beli ='8271500' WHERE kode_barcode='00370579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5581000',harga_beli ='5581000' WHERE kode_barcode='00370596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5307000',harga_beli ='5307000' WHERE kode_barcode='00370600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00370604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1952000',harga_beli ='1952000' WHERE kode_barcode='00370609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2163000',harga_beli ='2163000' WHERE kode_barcode='00370612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3228500',harga_beli ='3228500' WHERE kode_barcode='00370618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1266000',harga_beli ='1266000' WHERE kode_barcode='00370622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3059500',harga_beli ='3059500' WHERE kode_barcode='00370637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2057500',harga_beli ='2057500' WHERE kode_barcode='00370662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2374000',harga_beli ='2374000' WHERE kode_barcode='00370675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00370748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='570000',harga_beli ='570000' WHERE kode_barcode='00370774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='833500',harga_beli ='833500' WHERE kode_barcode='00370817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00370818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00370827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='675500',harga_beli ='675500' WHERE kode_barcode='00370829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='728000',harga_beli ='728000' WHERE kode_barcode='00370830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='749500',harga_beli ='749500' WHERE kode_barcode='00370869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1667000',harga_beli ='1667000' WHERE kode_barcode='00370996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='876000',harga_beli ='876000' WHERE kode_barcode='00371009' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='876000',harga_beli ='876000' WHERE kode_barcode='00371035' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00371036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00371037' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00371043' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00371044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00371046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5275000',harga_beli ='5275000' WHERE kode_barcode='00371483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2131500',harga_beli ='2131500' WHERE kode_barcode='00371557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='918000',harga_beli ='918000' WHERE kode_barcode='00371562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00371685' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00371741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00371743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='707000',harga_beli ='707000' WHERE kode_barcode='00371744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00371745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00371747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3123000',harga_beli ='3123000' WHERE kode_barcode='00371790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='485500',harga_beli ='485500' WHERE kode_barcode='00371889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2310500',harga_beli ='2310500' WHERE kode_barcode='00372233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1688000',harga_beli ='1688000' WHERE kode_barcode='00372257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00372265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00372267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00372272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00372274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00372286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00372288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00372292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00372293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='443500',harga_beli ='443500' WHERE kode_barcode='00372294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1635500',harga_beli ='1635500' WHERE kode_barcode='00372324' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2015500',harga_beli ='2015500' WHERE kode_barcode='00372325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2637500',harga_beli ='2637500' WHERE kode_barcode='00372326' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='949500',harga_beli ='949500' WHERE kode_barcode='00372327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2585000',harga_beli ='2585000' WHERE kode_barcode='00372328' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='644000',harga_beli ='644000' WHERE kode_barcode='00372331' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00372332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00372335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00372336' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1530000',harga_beli ='1530000' WHERE kode_barcode='00372364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1530000',harga_beli ='1530000' WHERE kode_barcode='00372365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4114500',harga_beli ='4114500' WHERE kode_barcode='00372401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5718500',harga_beli ='5718500' WHERE kode_barcode='00372404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00372582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00372587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00372604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3302500',harga_beli ='3302500' WHERE kode_barcode='00372668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1129000',harga_beli ='1129000' WHERE kode_barcode='00372673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00372752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1403500',harga_beli ='1403500' WHERE kode_barcode='00372898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='696500',harga_beli ='696500' WHERE kode_barcode='00373069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='7311500',harga_beli ='7311500' WHERE kode_barcode='00373147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='4769000',harga_beli ='4769000' WHERE kode_barcode='00373150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5286000',harga_beli ='5286000' WHERE kode_barcode='00373151' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2121000',harga_beli ='2121000' WHERE kode_barcode='00373153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2606000',harga_beli ='2606000' WHERE kode_barcode='00373154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='5138000',harga_beli ='5138000' WHERE kode_barcode='00373156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2722000',harga_beli ='2722000' WHERE kode_barcode='00373157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1983500',harga_beli ='1983500' WHERE kode_barcode='00373487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2226500',harga_beli ='2226500' WHERE kode_barcode='00373488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2690500',harga_beli ='2690500' WHERE kode_barcode='00373490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='696500',harga_beli ='696500' WHERE kode_barcode='00373501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='686000',harga_beli ='686000' WHERE kode_barcode='00373508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='433000',harga_beli ='433000' WHERE kode_barcode='00373510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00373511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2089000',harga_beli ='2089000' WHERE kode_barcode='00373734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2152500',harga_beli ='2152500' WHERE kode_barcode='00373735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3154500',harga_beli ='3154500' WHERE kode_barcode='00373736' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00373737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='612000',harga_beli ='612000' WHERE kode_barcode='00373738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00373744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00373745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00373746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1023500',harga_beli ='1023500' WHERE kode_barcode='00373747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00373748' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00373749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00373750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00373751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00373752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1604000',harga_beli ='1604000' WHERE kode_barcode='00373780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1635500',harga_beli ='1635500' WHERE kode_barcode='00373781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00373823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='601500',harga_beli ='601500' WHERE kode_barcode='00373824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00373825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='601500',harga_beli ='601500' WHERE kode_barcode='00373946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00373979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00373980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='549000',harga_beli ='549000' WHERE kode_barcode='00373981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='454000',harga_beli ='454000' WHERE kode_barcode='00373993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='601500',harga_beli ='601500' WHERE kode_barcode='00373996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='538500',harga_beli ='538500' WHERE kode_barcode='00373998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00374045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00374138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00374139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1118500',harga_beli ='1118500' WHERE kode_barcode='00374140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2574500',harga_beli ='2574500' WHERE kode_barcode='00374141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3692500',harga_beli ='3692500' WHERE kode_barcode='00374225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1414000',harga_beli ='1414000' WHERE kode_barcode='00374232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1551000',harga_beli ='1551000' WHERE kode_barcode='00374237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2806500',harga_beli ='2806500' WHERE kode_barcode='00374238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3555500',harga_beli ='3555500' WHERE kode_barcode='00374242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3197000',harga_beli ='3197000' WHERE kode_barcode='00374243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='00374247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2184000',harga_beli ='2184000' WHERE kode_barcode='00374250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='3007000',harga_beli ='3007000' WHERE kode_barcode='00374254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1593500',harga_beli ='1593500' WHERE kode_barcode='00374258' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1699000',harga_beli ='1699000' WHERE kode_barcode='00374259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00374321' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00374446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='443500',harga_beli ='443500' WHERE kode_barcode='00374493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='475000',harga_beli ='475000' WHERE kode_barcode='00374494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='591000',harga_beli ='591000' WHERE kode_barcode='00374495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='833500',harga_beli ='833500' WHERE kode_barcode='00374502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00374562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2194500',harga_beli ='2194500' WHERE kode_barcode='00374563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='2226500',harga_beli ='2226500' WHERE kode_barcode='00374564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='654500',harga_beli ='654500' WHERE kode_barcode='00374570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00374571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='749500',harga_beli ='749500' WHERE kode_barcode='00374572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='770500',harga_beli ='770500' WHERE kode_barcode='00374573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='454000',harga_beli ='454000' WHERE kode_barcode='00374574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='559500',harga_beli ='559500' WHERE kode_barcode='00374575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='1108000',harga_beli ='1108000' WHERE kode_barcode='00374576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='633000',harga_beli ='633000' WHERE kode_barcode='00374577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00374578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='506500',harga_beli ='506500' WHERE kode_barcode='00374579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='496000',harga_beli ='496000' WHERE kode_barcode='00374580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='728000',harga_beli ='728000' WHERE kode_barcode='00374581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='833500',harga_beli ='833500' WHERE kode_barcode='00374583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='580500',harga_beli ='580500' WHERE kode_barcode='00374584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1055000',harga_jual='527500',harga_beli ='527500' WHERE kode_barcode='00374585' LIMIT 1;
UPDATE tm_group SET harga='1055000' WHERE kode_group = 'ME' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('ME','1055000','input','2025-10-25 11:58:57');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251200211','input','1',' MEF3E X YT','TOKO','PM-F','F3E-YJBB-184-0','GL X TIFF SPECTRA HITAM YT 8K ','','1.120','1','100.00','1182000','0','0','15000','1180000','0','0','0','1180000','SIN','00374247','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBB-184-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YJBB-184-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251200211','2025-10-25','1.120','2025-10-25','12:00:21','PLG0025398','1180000','1180000','0','1180000','1180000','input','2025-10-25 12:00:21','F32525120021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251200211','2025-10-25','12:00:21','SIN','1180000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0016','D','2025-10-25','12:00:21','input','PENJUALAN','F325251200211','455672000','1180000','456852000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251209471','input','1',' MFF1 X UB ','TOKO','PM-F','F1F-YJXB-216-0','GL X OVAL TINJU PASIR UB 56 8K ','','3.710','1','100.00','3988000','0','0','15000','3990000','0','0','0','3990000','AAT','00371800','F1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1F-YJXB-216-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.710',berat_jual_asli=berat_jual_asli+'3.710',stock_jual='1',berat_akhir=berat_akhir-'3.710',berat_akhir_asli=berat_akhir_asli-'3.710',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F1F-YJXB-216-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251209471','2025-10-25','3.710','2025-10-25','12:09:48','PLG0025399','3990000','3990000','0','3990000','3990000','input','2025-10-25 12:09:47','F32525120947');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251209471','2025-10-25','12:09:48','AAT','3990000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0017','D','2025-10-25','12:09:48','input','PENJUALAN','F325251209471','456852000','3990000','460842000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325251209471' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251209472','input',' 1',' MEE2E X LG','TOKO','PM-E','E2E-XFAA-87-0','CC X BONEKA ANAK MATA CAT LG 8K ','','1.100','1','100.00','1160000','0','0','15000','1160000','0','0','0','1160000','AAT','00301986','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-XFAA-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2E-XFAA-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251209472','2025-10-25','1.100','2025-10-25','12:09:48','PLG0025400','1160000','1160000','0','1160000','1160000','input','2025-10-25 12:09:47','F32525120947');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251209472','2025-10-25','12:09:48','AAT','1160000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0018','D','2025-10-25','12:09:48','input','PENJUALAN','F325251209472','460842000','1160000','462002000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1160000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325251209472' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251209473','input',' 1',' MEF1 10K H','TOKO','PM-F','F1E-YEBH-42-0','GL PIPA ANAK KUKU MACAN SLEP VAR HA D38 8K','','1.980','1','100.00','2089000','0','0','15000','2090000','0','10000','0','2100000','AAT','00355730','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YEBH-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F1E-YEBH-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251209473','2025-10-25','1.980','2025-10-25','12:09:48','PLG0025401','2090000','2090000','10000','2100000','2100000','input','2025-10-25 12:09:47','F32525120947');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251209473','2025-10-25','12:09:48','AAT','2100000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0019','D','2025-10-25','12:09:48','input','PENJUALAN','F325251209473','462002000','2100000','464102000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2100000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325251209473' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251217081','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-XAXD-76-0','GL X OVAL C GELOMBANG YT 52 ','','3.450','1','100.00','3640000','0','0','15000','3640000','0','0','0','3640000','SIN','00272774','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XAXD-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.450',berat_jual_asli=berat_jual_asli+'3.450',stock_jual='1',berat_akhir=berat_akhir-'3.450',berat_akhir_asli=berat_akhir_asli-'3.450',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F1E-XAXD-76-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251217081','2025-10-25','3.450','2025-10-25','12:17:08','PLG0025402','3640000','3640000','0','3640000','3640000','input','2025-10-25 12:17:08','F32525121708');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251217081','2025-10-25','12:17:08','SIN','3640000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0020','D','2025-10-25','12:17:08','input','PENJUALAN','F325251217081','464102000','3640000','467742000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251246381','input','1',' MDE2 X PM ','TOKO','PM-E','E2D-YIBD-390-0','CC X MODEL MATA PM 12 8K ','','1.080','1','100.00','1118000','0','0','15000','1113000','0','0','0','1113000','SIN','00370811','E2D','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBD-390-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YIBD-390-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251246381','2025-10-25','1.080','2025-10-25','12:46:38','PLG0025403','1113000','1113000','0','1113000','1113000','input','2025-10-25 12:46:38','F32525124638');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251246381','2025-10-25','12:46:38','SIN','1113000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0021','D','2025-10-25','12:46:38','input','PENJUALAN','F325251246381','467742000','1113000','468855000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325251250211','input','1',' MEF3E X YT','TOKO','PM-F','F3E-YHAE-35-0','GL X BUBLE GUMS YT 8K ','','2.490','1','100.00','2627000','0','0','15000','2615000','0','0','0','2615000','AAT','00365942','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YHAE-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YHAE-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325251250211','2025-10-25','2.490','2025-10-25','12:50:22','PLG0025404','2615000','2615000','0','2615000','2615000','input','2025-10-25 12:50:21','F32525125021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325251250211','2025-10-25','12:50:22','AAT','2615000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0022','D','2025-10-25','12:50:22','input','PENJUALAN','F325251250211','468855000','2615000','471470000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250141561','input','1',' MEF3 X LT ','TOKO','PM-F','F3E-YJAA-135-0','GL X RANTAI HOLLOW P3 SLEP LT 8K ','','1.070','1','100.00','1129000','0','0','15000','1125000','0','0','0','1125000','SIN','00372673','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAA-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='F3E-YJAA-135-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250141561','2025-10-25','1.070','2025-10-25','13:41:56','PLG0025405','1125000','1125000','0','1125000','1125000','input','2025-10-25 13:41:56','F32525014156');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250141561','2025-10-25','13:41:56','SIN','1125000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0023','D','2025-10-25','13:41:56','input','PENJUALAN','F325250141561','471470000','1125000','472595000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1125000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250141561' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250141562','input',' 1',' MFE2 5K LG','TOKO','PM-E','E2F-YFXE-55-0','CC BONEKA ANAK MATA CAT LG 8K ','','0.430','1','100.00','462000','0','0','15000','460000','0','5000','0','465000','SIN','00356414','E2F','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-YFXE-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2F-YFXE-55-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250141562','2025-10-25','0.430','2025-10-25','13:41:56','PLG0025406','460000','460000','5000','465000','465000','input','2025-10-25 13:41:56','F32525014156');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250141562','2025-10-25','13:41:56','SIN','465000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0024','D','2025-10-25','13:41:56','input','PENJUALAN','F325250141562','472595000','465000','473060000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='465000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250141562' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250239151','input','1',' MDE2 5K LG','TOKO','PM-E','E2D-YDAX-283-0','CC ANAK BONEKA CAT MATA VAR LG 8K ','','0.900','1','100.00','931000','0','0','15000','928000','0','5000','0','933000','AAT','00348769','E2D','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YDAX-283-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E2D-YDAX-283-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250239151','2025-10-25','0.900','2025-10-25','14:39:16','PLG0025407','928000','928000','5000','933000','933000','input','2025-10-25 14:39:15','F32525023915');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250239151','2025-10-25','14:39:16','AAT','933000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0025','D','2025-10-25','14:39:16','input','PENJUALAN','F325250239151','473060000','933000','473993000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250255401','input','1',' MEE1 X LG ','TOKO','PM-E','E1E-YJBC-175-0','CC X MODEL PITA CAT HITAM LG 12 8K ','','0.420','1','100.00','443000','0','0','15000','440000','0','0','0','440000','SIN','00374493','E1E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBC-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='E1E-YJBC-175-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250255401','2025-10-25','0.420','2025-10-25','14:55:41','PLG0025408','440000','440000','0','440000','440000','input','2025-10-25 14:55:40','F32525025540');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250255401','2025-10-25','14:55:41','SIN','440000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251025-0026','D','2025-10-25','14:55:41','input','PENJUALAN','F325250255401','473993000','440000','474433000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250312411','input','1',' MFD2 X LG ','TOKO','PM-D','D2F-XDBC-441-0','LT X MODEL HURUF MATA LG B 8K','','0.460','1','100.00','494000','0','0','15000','493000','0','0','0','493000','SIN','00294716','D2F','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-XDBC-441-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='D2F-XDBC-441-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250312411','2025-10-25','0.460','2025-10-25','15:12:41','PLG0025409','493000','493000','0','493000','493000','input','2025-10-25 15:12:41','F32525031241');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250312411','2025-10-25','15:12:41','SIN','493000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0027','D','2025-10-25','15:12:41','input','PENJUALAN','F325250312411','474433000','493000','474926000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='493000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250312411' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325250312412','input',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-YBAB-115-0','KL X RANTAI HOLLOW KH 44 8K ','','2.910','1','100.00','3070000','0','0','15000','3055000','0','0','0','3055000','SIN','00338668','H1E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2025-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YBAB-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2025-10-25' AND kode_barang='H1E-YBAB-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325250312412','2025-10-25','2.910','2025-10-25','15:12:41','PLG0025410','3055000','3055000','0','3055000','3055000','input','2025-10-25 15:12:41','F32525031241');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-25','F325250312412','2025-10-25','15:12:41','SIN','3055000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251025-0028','D','2025-10-25','15:12:41','input','PENJUALAN','F325250312412','474926000','3055000','477981000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3055000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325250312412' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250239151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250239151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250239151';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017304','X-00017304','CC MODEL FLIK VAR CM 16 8K','GR','---','E1D','BELI','BELI001','660000','2025-10-25','0.820','1','kasir','2025-10-25 15:39:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017304','X-00017304');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0001','F325121020151','SIN','1','BELI','BELI001','E1D', 'X-00017304', 'CC MODEL FLIK VAR CM 16 8K','0.820','0.820','100.00','720000','660000','804878','1040000','1','660000','660000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0001','2025-10-25','2025-10-25','15:39:08','SIN','---','0.820','660000','660000','660000','660000','660000','kasir','2025-10-25 15:39:09','FB-251025-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0001','ERNA','NAWANGAN','','','','kasir','2025-10-25 15:39:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0030','K','2025-10-25','15:39:08','kasir','PEMBELIAN UMUM','FB-251025-0001','477048000','660000','476388000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017305','X-00017305','AT X HUGGIES KLIP MATA LG 8K','GR','---','A1E','BELI','BELI001','927000','2025-10-25','1.050','1','kasir','2025-10-25 15:48:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017305','X-00017305');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0002','F325290952002','FIT','1','BELI','BELI001','A1E', 'X-00017305', 'AT X HUGGIES KLIP MATA LG 8K','1.050','1.050','100.00','997000','927000','882857','1055000','1','927000','927000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0002','2025-10-25','2025-10-25','15:48:22','FIT','---','1.050','927000','927000','927000','927000','927000','kasir','2025-10-25 15:48:23','FB-251025-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0002','TARNI','WATU KUDI 4/7 JERUK PCT','','','+886984317152','kasir','2025-10-25 15:48:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0031','K','2025-10-25','15:48:22','kasir','PEMBELIAN UMUM','FB-251025-0002','476388000','927000','475461000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017306','X-00017306','GL X OVAL C SLEP UB 54 8K','GR','---','F1E','BELI','BELI001','3300000','2025-10-25','4.450','1','kasir','2025-10-25 15:49:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017306','X-00017306');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0003','F324230200361','FIT','1','BELI','BELI001','F1E', 'X-00017306', 'GL X OVAL C SLEP UB 54 8K','4.450','4.450','100.00','2725000','3300000','741573','1055000','1','3300000','3300000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.450',berat_beli_asli=berat_beli_asli+'4.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.450',berat_akhir_asli=berat_akhir_asli+'4.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0003','2025-10-25','2025-10-25','15:49:13','FIT','---','4.450','3300000','3300000','3300000','3300000','3300000','kasir','2025-10-25 15:49:13','FB-251025-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0003','ANISAPUTRI','TINASAT KISMANTORO','','','','kasir','2025-10-25 15:49:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0032','K','2025-10-25','15:49:13','kasir','PEMBELIAN UMUM','FB-251025-0003','475461000','3300000','472161000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017307','X-00017307','CC WEDDING MATA CM 16','GR','---','E2E','BELI','BELI001','1235000','2025-10-25','1.760','1','kasir','2025-10-25 15:50:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017307','X-00017307');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0004','F322041030492','SIN','1','BELI','BELI001','E2E', 'X-00017307', 'CC WEDDING MATA CM 16','1.760','1.760','100.00','766000','1235000','701705','1055000','1','1235000','1235000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.760',berat_beli_asli=berat_beli_asli+'1.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.760',berat_akhir_asli=berat_akhir_asli+'1.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0004','2025-10-25','2025-10-25','15:50:22','SIN','---','1.760','1235000','1235000','1235000','1235000','1235000','kasir','2025-10-25 15:50:23','FB-251025-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0004','KRISNA','BAKALAN','','','089607649303','kasir','2025-10-25 15:50:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0033','K','2025-10-25','15:50:22','kasir','PEMBELIAN UMUM','FB-251025-0004','472161000','1235000','470926000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017308','X-00017308','CC WEDDING MATA CM 21','GR','---','E2TE','BELI','BELI001','2900000','2025-10-25','2.000','1','kasir','2025-10-25 15:51:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017308','X-00017308');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0005','F324161129501','AAT','1','BELI','BELI001','E2TE', 'X-00017308', 'CC WEDDING MATA CM 21','2.000','2.000','100.00','2000000','2900000','1450000','1885000','1','2900000','2900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0005','2025-10-25','2025-10-25','15:51:53','AAT','---','2.000','2900000','2900000','2900000','2900000','2900000','kasir','2025-10-25 15:51:53','FB-251025-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0005','DEVIE','BEKASI','','','08571140995','kasir','2025-10-25 15:51:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0034','K','2025-10-25','15:51:53','kasir','PEMBELIAN UMUM','FB-251025-0005','470926000','2900000','468026000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017309','X-00017309','KL NORY ANAK BONEKA CAT HW','GR','---','H1F','BELI','BELI001','1525000','2025-10-25','2.160','1','kasir','2025-10-25 15:54:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00017309','X-00017309');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0006','F322050118141','FIT','1','BELI','BELI001','H1F', 'X-00017309', 'KL NORY ANAK BONEKA CAT HW','2.160','2.160','100.00','908000','1525000','706019','1080000','1','1525000','1525000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.160',berat_beli_asli=berat_beli_asli+'2.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.160',berat_akhir_asli=berat_akhir_asli+'2.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0006','2025-10-25','2025-10-25','15:54:36','FIT','---','2.160','1525000','1525000','1525000','1525000','1525000','kasir','2025-10-25 15:54:37','FB-251025-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0006','SISKA','PAGERUKIR','','','081234988183','kasir','2025-10-25 15:54:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0035','K','2025-10-25','15:54:36','kasir','PEMBELIAN UMUM','FB-251025-0006','468026000','1525000','466501000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017310','X-00017310','GL LEMES 8K','GR','---','F3E','BELI','BELI001','1760000','2025-10-25','2.680','1','kasir','2025-10-25 15:58:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017310','X-00017310');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0007','F323201127191','FIT','1','BELI','BELI001','F3E', 'X-00017310', 'GL LEMES 8K','2.680','2.680','100.00','1250000','1760000','656716','1055000','1','1760000','1760000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.680',berat_beli_asli=berat_beli_asli+'2.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.680',berat_akhir_asli=berat_akhir_asli+'2.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0007','2025-10-25','2025-10-25','15:58:31','FIT','---','2.680','1760000','1760000','1760000','1760000','1760000','kasir','2025-10-25 15:58:31','FB-251025-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0007','HILYA','PAGERUKIR','','','','kasir','2025-10-25 15:58:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0036','K','2025-10-25','15:58:31','kasir','PEMBELIAN UMUM','FB-251025-0007','466501000','1760000','464741000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017311','X-00017311','KL X SANTA KH 44 9K','GR','---','H2I','BELI','BELI001','1600000','2025-10-25','2.050','1','kasir','2025-10-25 15:59:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00017311','X-00017311');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0008','F324030109351','SIN','1','BELI','BELI001','H2I', 'X-00017311', 'KL X SANTA KH 44 9K','2.050','2.050','100.00','1380000','1600000','780488','1140000','1','1600000','1600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0008','2025-10-25','2025-10-25','15:59:21','SIN','---','2.050','1600000','1600000','1600000','1600000','1600000','kasir','2025-10-25 15:59:21','FB-251025-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0008','ADITYA','NGANDONG KEPYAR','','','','kasir','2025-10-25 15:59:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0037','K','2025-10-25','15:59:21','kasir','PEMBELIAN UMUM','FB-251025-0008','464741000','1600000','463141000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017312','X-00017312','CC X EROPA MATA MERAH VAR HT 18 17K','GR','---','E2TE','BELI','BELI001','4290000','2025-10-25','3.210','1','kasir','2025-10-25 16:00:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017312','X-00017312');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0009','F324190943561','AAT','1','BELI','BELI001','E2TE', 'X-00017312', 'CC X EROPA MATA MERAH VAR HT 18 17K','3.210','3.210','100.00','3450000','4290000','1336449','1885000','1','4290000','4290000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.210',berat_beli_asli=berat_beli_asli+'3.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.210',berat_akhir_asli=berat_akhir_asli+'3.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0009','2025-10-25','2025-10-25','16:00:57','AAT','---','3.210','4290000','4290000','4290000','4290000','4290000','kasir','2025-10-25 16:00:57','FB-251025-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0009','INDAH','SENDANG PURWANTORO','','','','kasir','2025-10-25 16:00:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0038','K','2025-10-25','16:00:57','kasir','PEMBELIAN UMUM','FB-251025-0009','463141000','4290000','458851000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017313','X-00017313','','GR','---','F4I','BELI','BELI001','3200000','2025-10-25','4.100','1','kasir','2025-10-25 16:04:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-F4I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F4I','X-00017313','X-00017313');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0010','F323091237091','AAT','1','BELI','BELI001','F4I', 'X-00017313', '','4.100','4.100','100.00','2010000','3200000','780488','1140000','1','3200000','3200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.100',berat_beli_asli=berat_beli_asli+'4.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.100',berat_akhir_asli=berat_akhir_asli+'4.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F4I' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0010','2025-10-25','2025-10-25','16:04:10','AAT','---','4.100','3200000','3200000','3200000','3200000','3200000','kasir','2025-10-25 16:04:10','FB-251025-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0010','ERNA','PLOSO','','','','kasir','2025-10-25 16:04:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0039','K','2025-10-25','16:04:10','kasir','PEMBELIAN UMUM','FB-251025-0010','458851000','3200000','455651000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017314','X-00017314','GL COR T 8K','GR','---','F1E','BELI','BELI001','4585000','2025-10-25','6.310','1','kasir','2025-10-25 16:08:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017314','X-00017314');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0011','F321101017402','AAT','1','BELI','BELI001','F1E', 'X-00017314', 'GL COR T 8K','6.310','6.310','100.00','2556000','4585000','726624','1055000','1','4585000','4585000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.310',berat_beli_asli=berat_beli_asli+'6.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.310',berat_akhir_asli=berat_akhir_asli+'6.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0011','2025-10-25','2025-10-25','16:08:47','AAT','---','6.310','4585000','4585000','4585000','4585000','4585000','kasir','2025-10-25 16:08:47','FB-251025-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0011','KARMI','SLOGOHIMO','','','','kasir','2025-10-25 16:08:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0040','K','2025-10-25','16:08:47','kasir','PEMBELIAN UMUM','FB-251025-0011','455651000','4585000','451066000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017315','X-00017315','AT COR 17K','GR','---','A1TE','BELI','BELI001','1050000','2025-10-25','0.900','1','kasir','2025-10-25 16:14:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00017315','X-00017315');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0012','F323211044071','AAT','1','BELI','BELI001','A1TE', 'X-00017315', 'AT COR 17K','0.900','0.900','100.00','765000','1050000','1166667','1885000','1','1050000','1050000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0012','2025-10-25','2025-10-25','16:14:16','AAT','---','0.900','1050000','1050000','1050000','1050000','1050000','kasir','2025-10-25 16:14:17','FB-251025-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0012','MARISA','KISMANTORO','','','','kasir','2025-10-25 16:14:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0041','K','2025-10-25','16:14:16','kasir','PEMBELIAN UMUM','FB-251025-0012','451066000','1050000','450016000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017316','X-00017316','CC COR M 8K','GR','---','E2E','BELI','BELI001','650000','2025-10-25','1.020','1','kasir','2025-10-25 16:16:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017316','X-00017316');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0013','F323271216423','AAT','1','BELI','BELI001','E2E', 'X-00017316', 'CC COR M 8K','1.020','1.020','100.00','475000','650000','637255','1055000','1','650000','650000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0013','2025-10-25','2025-10-25','16:16:52','AAT','---','1.020','650000','650000','650000','650000','650000','kasir','2025-10-25 16:16:53','FB-251025-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0013','','','','','','kasir','2025-10-25 16:16:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0042','K','2025-10-25','16:16:52','kasir','PEMBELIAN UMUM','FB-251025-0013','450016000','650000','449366000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017317','X-00017317','GL X CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1765000','2025-10-25','1.760','1','kasir','2025-10-25 16:18:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017317','X-00017317');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0014','F325241028271','FIT','1','BELI','BELI001','F3E', 'X-00017317', 'GL X CAPELLA SLEP HW 8K','1.760','1.760','100.00','1858000','1765000','1002841','1055000','1','1765000','1765000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.760',berat_beli_asli=berat_beli_asli+'1.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.760',berat_akhir_asli=berat_akhir_asli+'1.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0014','2025-10-25','2025-10-25','16:18:59','FIT','---','1.760','1765000','1765000','1765000','1765000','1765000','kasir','2025-10-25 16:18:59','FB-251025-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0014','ANIS','BULUKERTO','','','','kasir','2025-10-25 16:18:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0043','K','2025-10-25','16:18:59','kasir','PEMBELIAN UMUM','FB-251025-0014','449366000','1765000','447601000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017318','X-00017318','LT SLOBOK BALOK HURUF BG A 8K','GR','---','D1G','BELI','BELI001','265000','2025-10-25','0.350','1','kasir','2025-10-25 16:19:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00017318','X-00017318');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0015','F325071157263','AAT','1','BELI','BELI001','D1G', 'X-00017318', 'LT SLOBOK BALOK HURUF BG A 8K','0.350','0.350','100.00','290000','265000','757143','1095000','1','265000','265000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0015','2025-10-25','2025-10-25','16:19:52','AAT','---','0.350','265000','265000','265000','265000','265000','kasir','2025-10-25 16:19:53','FB-251025-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0015','AQILLA','GOLO PUHPELEM','','','','kasir','2025-10-25 16:19:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0044','K','2025-10-25','16:19:52','kasir','PEMBELIAN UMUM','FB-251025-0015','447601000','265000','447336000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017319','X-00017319','LT X SLOBOK BOLA SLEP BG 8K','GR','---','D1G','BELI','BELI001','245000','2025-10-25','0.320','1','kasir','2025-10-25 16:20:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00017319','X-00017319');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0016','F325071157262','AAT','1','BELI','BELI001','D1G', 'X-00017319', 'LT X SLOBOK BOLA SLEP BG 8K','0.320','0.320','100.00','265000','245000','765625','1095000','1','245000','245000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0016','2025-10-25','2025-10-25','16:20:50','AAT','---','0.320','245000','245000','245000','245000','245000','kasir','2025-10-25 16:20:50','FB-251025-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0016','AQILLA','GOLO PUHPELEM','','','','kasir','2025-10-25 16:20:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0045','K','2025-10-25','16:20:50','kasir','PEMBELIAN UMUM','FB-251025-0016','447336000','245000','447091000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017320','X-00017320','CC MODEL APEL CAT VAR LG 17 8K','GR','---','E1E','BELI','BELI001','350000','2025-10-25','0.530','1','kasir','2025-10-25 16:22:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017320','X-00017320');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0017','F325210203231','FIT','1','BELI','BELI001','E1E', 'X-00017320', 'CC MODEL APEL CAT VAR LG 17 8K','0.530','0.530','100.00','393000','350000','660377','1055000','1','350000','350000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0017','2025-10-25','2025-10-25','16:22:23','FIT','---','0.530','350000','350000','350000','350000','350000','kasir','2025-10-25 16:22:24','FB-251025-0017');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0017','AQILA','GOLO JRAKAH','','','','kasir','2025-10-25 16:22:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0046','K','2025-10-25','16:22:23','kasir','PEMBELIAN UMUM','FB-251025-0017','447091000','350000','446741000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017321','X-00017321','LT COR T 8K','GR','---','D1F','BELI','BELI001','400000','2025-10-25','0.580','1','kasir','2025-10-25 16:24:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00017321','X-00017321');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251025-0018','00317888','AAT','1','BELI','BELI001','D1F', 'X-00017321', 'LT COR T 8K','0.580','0.580','100.00','387000','400000','689655','1080000','1','400000','400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.580',berat_beli_asli=berat_beli_asli+'0.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.580',berat_akhir_asli=berat_akhir_asli+'0.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251025-0018','2025-10-25','2025-10-25','16:24:36','AAT','---','0.580','400000','400000','400000','400000','400000','kasir','2025-10-25 16:24:36','FB-251025-0018');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251025-0018','SUPRIHANTO','BOGOR','','','','kasir','2025-10-25 16:24:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251025-0047','K','2025-10-25','16:24:36','kasir','PEMBELIAN UMUM','FB-251025-0018','446741000','400000','446341000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250141561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250141561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250141561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250141562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250141562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250141562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250255401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250255401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250255401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250312411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250312411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250312411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250312412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250312412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250312412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250750401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250750401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250750401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250908371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250908371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250908371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250908372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250908372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250908372';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250910141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250910141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250910141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250953301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250953301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250953301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250953302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250953302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250953302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325250953303' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325250953303' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325250953303';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251015091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251015091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251015091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251015092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251015092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251015092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251037081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251037081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251037081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251038201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251038201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251038201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251048131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251048131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251048131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251106281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251106281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251106281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251110491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251110491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251110491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251200211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251200211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251200211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251209471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251209471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251209471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251209472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251209472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251209472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251209473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251209473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251209473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251217081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251217081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251217081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251246381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251246381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251246381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325251250211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325251250211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325251250211';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0016';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0017';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251025-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251025-0018';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-25';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-25' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251026-0001','D','2025-10-26','17:17:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','446341000','446341000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251026-0001','D','2025-10-26','17:17:14','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251026-0001','D','2025-10-26','17:17:14','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251026-0001','D','2025-10-26','17:17:14','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-10-26';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251026-0001','1','A1D-YJBB-230-0','1','1.000','1.000','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YJBB-230-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YJBB-230-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-10-26 17:24:03' WHERE kode_barang='A1D-YJBB-230-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YJBB-230-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-26 17:24:03','TOKO','PM-A','A1D','A1D-YJBB-230-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YJBB-230-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YJBB-230-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251026-0001','2025-10-26','17:23','1.000','admpindah','2025-10-25 17:24:03');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251026-0001','1','F3E-YJXB-241-0','1','1.560','1.560','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YJXB-241-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YJXB-241-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-10-26 17:24:19' WHERE kode_barang='F3E-YJXB-241-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YJXB-241-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-26 17:24:19','TOKO','PM-F','F3E','F3E-YJXB-241-0','1','1.560','1.560','1','1.560','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YJXB-241-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJXB-241-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251026-0001','2025-10-26','17:24','1.560','admpindah','2025-10-25 17:24:19');