} setvar("Measuries", $_PB_CACHE['measuring']); setvar("Monetaries", $_PB_CACHE['monetary']); setvar("PriceTypes", $_PB_CACHE['price_type']); setvar("PriceTrends", $_PB_CACHE['price_trends']); setvar("Productcategories", $productcategory->getTypeOptions()); if (isset($_GET['do'])) { $do = trim($_GET['do']); if (!empty($_GET['id'])) { $id = intval($_GET['id']); } if (isset($_GET['productid'])) { $product_id = intval($_GET['productid']); } if ($do == "del" && !empty($id)) { $result = $productprices->del(intval($id), "member_id=" . $_SESSION['MemberID']); } if ($do == "edit") { if (!empty($id)) { $price_info = $pdb->GetRow("SELECT id,product_id,type_id,brand_id,area_id,title,description,price,units,price_trends,currency,source,category_id FROM {$tb_prefix}productprices WHERE member_id=" . $_SESSION['MemberID'] . " AND id={$id}"); if (!empty($price_info['product_id'])) { $price_info['productname'] = $pdb->GetOne("SELECT name FROM {$tb_prefix}products WHERE id=" . $price_info['product_id']); $price_info['brand'] = $pdb->GetOne("SELECT name FROM {$tb_prefix}brands WHERE id=" . $price_info['brand_id']); } $price_info['category'] = $pdb->GetOne("SELECT name FROM {$tb_prefix}productcategories WHERE id=" . $price_info['category_id']); } elseif (!empty($product_id)) { $pinfo = $pdb->GetRow("SELECT * FROM {$tb_prefix}products WHERE id=" . $product_id); if (!empty($pinfo)) { $price_info['title'] = $price_info['productname'] = $pinfo['name']; $price_info['product_id'] = $pinfo['id']; $price_info['category_id'] = $pinfo['category_id'];
setvar("Monetaries", $_PB_CACHE['monetary']); setvar("PriceTypes", $_PB_CACHE['price_type']); setvar("PriceTrends", $_PB_CACHE['price_trends']); if (isset($_GET['do'])) { $do = trim($_GET['do']); $action = trim($_GET['action']); if (!empty($_GET['id'])) { $id = intval($_GET['id']); } if ($do == "search") { if (isset($_GET['q'])) { $conditions[] = "title like '%" . trim($_GET['q']) . "%'"; } } if ($do == "del" && !empty($id)) { $productprices->del($_GET['id']); } if ($do == "edit") { if (!empty($id)) { $item_info = $productprices->getInfo($id); } if (!empty($item_info)) { setvar("item", $item_info); } setvar("Productcategories", $productcategory->getTypeOptions()); $tpl_file = "price.edit"; template($tpl_file); exit; } } if (isset($_POST['del']) && is_array($_POST['id'])) {
} } setvar("Measuries", $_PB_CACHE['measuring']); setvar("Monetaries", $_PB_CACHE['monetary']); setvar("PriceTypes", $_PB_CACHE['price_type']); setvar("PriceTrends", $_PB_CACHE['price_trends']); if (isset($_GET['do'])) { $do = trim($_GET['do']); if (!empty($_GET['id'])) { $id = intval($_GET['id']); } if (isset($_GET['productid'])) { $product_id = intval($_GET['productid']); } if ($do == "del" && !empty($id)) { $result = $productprices->del(intval($id), "member_id=" . $the_memberid); header("Location:" . $pre_refer); exit; } if ($do == "edit") { if (!empty($id)) { $price_info = $pdb->GetRow("SELECT id,product_id,type_id,brand_id,area_id,title,description,price,units,price_trends,currency,source,category_id FROM {$tb_prefix}productprices WHERE member_id=" . $the_memberid . " AND id={$id}"); if (!empty($price_info['product_id'])) { $price_info['productname'] = $pdb->GetOne("SELECT name FROM {$tb_prefix}products WHERE id=" . $price_info['product_id']); $price_info['brand'] = $pdb->GetOne("SELECT name FROM {$tb_prefix}brands WHERE id=" . $price_info['brand_id']); } $price_info['category'] = $pdb->GetOne("SELECT name FROM {$tb_prefix}productcategories WHERE id=" . $price_info['category_id']); } elseif (!empty($product_id)) { $pinfo = $pdb->GetRow("SELECT * FROM {$tb_prefix}products WHERE id=" . $product_id); if (!empty($pinfo)) { $price_info['title'] = $price_info['productname'] = $pinfo['name'];