Example #1
0
}
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'];
Example #2
0
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'])) {
Example #3
0
    }
}
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'];