function edit_product($id)
{
$data["categories"] = $this->productcategory->getCategoriesList();
$query = $this->db->query("SELECT * FROM `products` WHERE `id` = '{$id}' ");
$data["product"] = $query->row_array();
foreach ($this->languages as $k => $lang) {
$data["product"][$lang["code"]] = getProductLang($id, $lang["id"]);
}
$data["product"]["discount"] = getProductDiscount($id);
$data["product"]["discount"]["calculated_price"] = number_format($data["product"]["price"] * (1 - $data["product"]["discount"]["value"] / 100), 2, '.', '');
// scoatem si producatorii
$query = $this->db->query("SELECT * FROM `producers` WHERE 1");
$data["producers"] = $query->result_array();
$this->showMainTemplate("admin/products/edit_product", $data, true);
}
function getProductList($category_id, $filter_values, $offset, $rows, $extra_where = "")
{
$query = $this->db->query($this->getProductListSQL($category_id, $filter_values, false, $offset, $rows, $extra_where));
if ($query->num_rows() > 0) {
$result = $query->result_array();
foreach ($result as $k => $v) {
$result[$k]["image_id"] = getProductMainImage($v["id"]);
$prod_lang = getProductLang($v["id"]);
$result[$k]["name"] = $prod_lang["name"];
$result[$k]["short_desc"] = $prod_lang["short_desc"];
$result[$k]["price"] = number_format($result[$k]["price"], 2, ".", "");
}
} else {
$result = array();
}
return $result;
}
