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; }