$txtSearch = $_POST["txtSearch"];
$cmbSearchType = $_POST["cmbSearchType"];
}
}
//echo "aaaaaaaaaaaaaaaaaa";
$txtCategoryName = trim($_POST["txtCategoryName"]);
$txtProductName = $_POST["txtProductName"];
$txtDescription = $_POST["txtDescription"];
$txtPrice = $_POST["txtPrice"];
$ddlArtist = $_POST["ddlArtist"];
$productlist = $_POST["chkproducts"];
$catid = $_GET['catid'];
$artistlist = makeArtistList();
$productListingFee = getSettingsValue('product_listing_fee');
//$madetoorder_opt = ($madetorderflag == 1) ? "AND p.eMadetoOrder = 'Y'" : '';
if (CheckGiftCertificateCategory($_GET['catid']) == 'Y') {
$sql = "SELECT p.product_id,p.product_name,(p.product_price + po.additional_price) AS product_price,po.image_small,po.product_option_id,po.product_stock,po.discount,s.artist_name,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n FROM " . $tableprefix . "products p\n INNER JOIN " . $tableprefix . "product_options po ON po.product_id = p.product_id AND po.default_option = 'YES'\n INNER JOIN " . $tableprefix . "giftcoupon_master gm oN gm.ngift_product_id=p.product_id\n LEFT JOIN " . $tableprefix . "artists s on p.product_artist_id=s.artist_id\n WHERE p.vapproved='Y' AND p.deleted ='N' AND po.product_stock > 0 ";
if ($productListingFee > 0) {
$sql .= " AND p.payment_status='COMPLETED' ";
}
$sql .= "AND s.vapproved='Y' AND s.deleted = 'N' AND s.plan_expired='N' AND s.vacationmode = 'N' ";
} else {
$sql = "SELECT p.product_id,p.product_name,(p.product_price + po.additional_price) AS product_price,po.image_small,po.product_option_id,po.product_stock,po.discount,s.artist_name, p.eMadetoOrder,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n FROM " . $tableprefix . "products p\n INNER JOIN " . $tableprefix . "product_options po ON po.product_id = p.product_id AND po.default_option = 'YES'\n LEFT JOIN " . $tableprefix . "artists s on p.product_artist_id=s.artist_id\n\t\t WHERE p.vapproved='Y' AND p.deleted ='N' AND s.vacationmode = 'N' AND po.product_stock > 0 ";
if ($productListingFee > 0) {
$sql .= " AND p.payment_status='COMPLETED' ";
}
$sql .= "\n AND s.vapproved='Y' AND s.deleted = 'N' AND s.plan_expired='N' AND s.vacationmode = 'N' ";
}
$qrystring = " ";
if ($txtSearch != "" || $catid != '') {
// check for searching
$catid = $_GET["catid"];
} else {
if (isset($_POST["catid"]) and $_POST["catid"] != "") {
$catid = $_POST["catid"];
}
}
if (isset($_GET["txtSearch"]) and $_GET["txtSearch"] != "") {
$txtSearch = $_GET["txtSearch"];
$cmbSearchType = $_GET["cmbSearchType"];
} else {
if (isset($_POST["txtSearch"]) and $_POST["txtSearch"] != "") {
$txtSearch = $_POST["txtSearch"];
$cmbSearchType = $_POST["cmbSearchType"];
}
}
$giftCategoryFlag = CheckGiftCertificateCategory($catid);
if (!isset($catid) && $catid == "" && $txtSearch == "") {
$showproductlisting = "false";
}
if (isset($catid) && $catid != "" || $txtSearch != "" || $giftCategoryFlag == 'Y') {
$showproductlisting = "true";
}
/*display the active template*/
$active_template = displayTemplate();
include "includes/htmltop.php";
/* Top File Name */
include_once "includes/" . $active_template[0];
// Check Category is a Gift Certificate Category
?>
<script language="javascript" type="text/JavaScript"><!--
function popupWindow(url) {
