public void reInitializeBar(int curBarID){
		System.out.println(ppc);
		//now insert for this price_class the product_classes like eten drinken shift
		dB.runQuery("Select product_class_id,class_name,class_color_rgb from product_class");
		dB.commit();
		while(dB.next())
			ppc.addProductClass(new ProductClass(dB.getInt(1),dB.getStr(2),dB.getStr(3)));

		//insert the visible products for this bar for each class and the current price class and the latest version id into ppc
		for(int j=0; j < ppc.getProductClassesSize();j++)
		{
			dB.runQuery(String.format("SELECT p.product_version_id,p.product_type_id,p.product_price,p.product_name "
					+ "FROM product_types as p "
					+ "INNER JOIN( "
					+ "SELECT MAX(product_version_id) as product_version_id,product_type_id "
					+ "FROM product_types GROUP BY product_type_id) as ss "
					+ "Using(product_version_id,product_type_id) "
					+ "INNER JOIN product_bar_visibility as b "
					+ "USING (product_version_id,product_type_id) "
					+ "WHERE p.product_class_id = %d "
					+ "AND p.product_price_class_id = %d "
					+ "AND b.product_bar_visibility = true "
					+ "AND b.bar_id = %d;"
					,ppc.getProductClassID(j),ppc.getID(),curBarID));
			dB.commit();
			while(dB.next())
			ppc.addProduct(new Product(dB.getInt(1),dB.getInt(2),dB.getInt(3),dB.getStr(4)),j);
		}
	}