public static function getsubCategoryIds($categoryId) { global $tableprefix; if (!empty($categoryId)) { $resSet = DbHelper::execute("SELECT category_id from " . $tableprefix . "categories cat where cat.route REGEXP '^" . $categoryId . ",|,^" . $categoryId . "|," . $categoryId . ",|," . $categoryId . "\$|^" . $categoryId . "\$' "); $data = DbHelper::fetchAll($resSet); if (count($data) > 0) { foreach ($data as $data_value) { $category_array[] = $data_value->category_id; } $categoryString = implode("','", $category_array); } } return $categoryString; }
productViewedReport(GetSQLValueString($productid, "text"), $_SESSION["sess_userid"]); $USER_ID = $_SESSION["sess_userid"]; } /* Items Bought By */ $resIB = DbHelper::execute("SELECT od.product_id,od.product_name,op.image_small,op.image_big\n FROM " . $tableprefix . "order_details od\n INNER JOIN " . $tableprefix . "product_options op ON od.product_option_id = op.product_option_id\n INNER JOIN " . $tableprefix . "products p ON p.product_id \t = op. \tproduct_id\n WHERE od.order_id IN (SELECT GROUP_CONCAT(DISTINCT d.order_id ORDER BY d.order_id DESC SEPARATOR ', ') FROM " . $tableprefix . "order_details d WHERE d.product_id = '" . mysql_real_escape_string($_GET['productid']) . "')\n AND p.deleted = 'N' AND od.product_id != '" . $_GET['productid'] . "' AND od.item_status IN(1, 3, 4) GROUP BY od.product_id LIMIT 0,12"); /*$resIB = DbHelper::execute("SELECT DISTINCT od.product_id,od.product_name,op.image_small,op.image_big FROM ".$tableprefix."order_details od LEFT JOIN ".$tableprefix."product_options op ON od.product_option_id = op.product_option_id LIMIT 12");*/ $IBArr = DbHelper::fetchAll($resIB); /* Other Intrested Items Bought By */ //$resOI = DbHelper::execute("SELECT p.product_id,p.product_name,op.image_small,op.image_big FROM ".$tableprefix."products p LEFT JOIN ".$tableprefix."product_options op ON p.product_id = op.product_id WHERE p.vIntrest='Y' AND p.product_id != '".$_GET['productid']."' GROUP BY p.product_id LIMIT 0,12"); $sql_interest = "SELECT p.product_id,p.product_name,op.image_small,op.image_big FROM " . $tableprefix . "products p\n LEFT JOIN " . $tableprefix . "product_options op ON p.product_id = op.product_id\n INNER JOIN " . $tableprefix . "categories c ON c.category_id = p.product_category\n WHERE p.vIntrest='Y' AND p.product_id != '" . mysql_real_escape_string($_GET['productid']) . "'\n AND p.deleted = 'N' AND c.vEnable='Y' GROUP BY p.product_id LIMIT 0,12"; $resOI = DbHelper::execute($sql_interest); $OIArr = DbHelper::fetchAll($resOI); /* display the active template */ $active_template = displayTemplate(); include "includes/htmltop.php"; /* Top File Name */ include_once "includes/" . $active_template[0]; $quantity = getWholesaleProductCount($prow["product_option_id"]); // Check product is whole sale item or not $eWholesaleItem = isWholesaleItem($productid); //Check Selected Option Added to Wish List $wishItemCount_Product = getWishItemsCount_Product($productid, $prow["product_option_id"]); // Current Stock Available for a product $currentStockAvailable = getCurrentStockAvailable($productid, $prow["product_option_id"]); ?> <!--<script type="text/javascript"
</div> <div class="clear"></div> <?php /* Product list carousel*/ /*$productListingFee = getSettingsValue('product_listing_fee'); $sql ="SELECT p.product_id,p.product_name,po.image_small,po.image_big FROM ".$tableprefix."products p INNER JOIN ".$tableprefix."product_options po ON po.product_id = p.product_id AND po.default_option='YES' INNER JOIN ".$tableprefix."artists s ON p.product_artist_id = s.artist_id WHERE p.product_artist_id='".$artistid."' AND p.vapproved = 'Y' AND s.vapproved='Y' AND s.plan_expired='N'"; if($productListingFee > 0) { $sql .= " AND p.payment_status='COMPLETED' "; } $sql .= " AND p.deleted !='Y' LIMIT 0,100"; $resOV = DbHelper::execute($sql); $OVArr = DbHelper::fetchAll($resOV);*/ $sql = "SELECT ap.* FROM " . $tableprefix . "artists a INNER JOIN " . $tableprefix . "mybusiness ap ON a.artist_id = ap.artistid WHERE ap.artistid = '" . addslashes($artistid) . "' LIMIT 0,100"; $resOV = DbHelper::execute($sql); $OVArr = DbHelper::fetchAll($resOV); if (count($OVArr) > 0) { ?> <div class="txtblue">Click on thumbnail for a virtual tour of our business...</div> <?php include_once BASE_URL . '/product_details_page_carousel.php'; clsCreateCarousel::showVendorBusinessCurozileItems($OVArr); } ?> </div>
public static function getVendorNamesByOrderId($orderId = 0) { global $tableprefix; $query = "SELECT DISTINCT CONCAT(ar.first_name ,' ', ar.last_name) as name, ar.artist_id FROM " . $tableprefix . "order_details od\n\t\t\t\t\t\tINNER JOIN " . $tableprefix . "artists ar ON od.artist_id = ar.artist_id\n WHERE od.order_id = '" . mysql_real_escape_string($orderId) . "'"; $resCat = DbHelper::execute($query); $data = DbHelper::fetchAll($resCat); return $data; }
public static function listVendorFeedbacks($userid) { global $tableprefix; $sql = " SELECT f.*, u.user_name, a.first_name,a.last_name ,u.email FROM " . $tableprefix . "artist_feedbacks f\n\t\tINNER JOIN " . $tableprefix . "users u ON f.user_id = u.user_id\n\t\tINNER JOIN " . $tableprefix . "artists a ON f.artist_id = a.artist_id\n WHERE f.user_id = " . $userid . "\n AND f.published = 'Y' AND f.deleted = 0\n \t ORDER BY date_added DESC "; $result = DbHelper::execute($sql); $vendor_feedbacks = DbHelper::fetchAll($result); return $vendor_feedbacks; }
} } echo $msg; exit; } elseif (isset($_POST['txtaction']) && $_POST['txtaction'] == 'checkproductvalid') { if (isset($_REQUEST['chkproductid'])) { $chkProductId = $_REQUEST['chkproductid']; $controlstatus = $_REQUEST['controlstatus']; $sqlCountInterest = "SELECT pd.vIntrest as cntInt FROM " . $tableprefix . "products pd\n INNER JOIN " . $tableprefix . "product_options po ON po.product_id = pd.product_id\n INNER JOIN " . $tableprefix . "artists ar ON ar.artist_id = pd.product_artist_id\n WHERE pd.vapproved='Y' AND ar.vapproved='Y' AND pd.deleted ='N' AND ar.vacationmode = 'N'\n AND ar.plan_expired='N' AND po.product_stock > 0 AND pd.product_id = '" . mysql_real_escape_string($chkProductId) . "'"; $intrestRes = DbHelper::execute($sqlCountInterest); $intrestArr = DbHelper::fetchAll($intrestRes); if (count($intrestArr) == 1) { if ($controlstatus == "true") { $sqlCountInterest = "SELECT COUNT(pd.vIntrest) as cntInt FROM " . $tableprefix . "products pd\n INNER JOIN " . $tableprefix . "product_options po ON po.product_id = pd.product_id\n INNER JOIN " . $tableprefix . "artists ar ON ar.artist_id = pd.product_artist_id\n WHERE vIntrest='Y' AND pd.vapproved='Y' AND ar.vapproved='Y' AND pd.deleted ='N' AND ar.vacationmode = 'N'\n AND ar.plan_expired='N' AND po.product_stock > 0 AND pd.product_id NOT IN ({$chkProductId})"; $intrestRes = DbHelper::execute($sqlCountInterest); $intrestArr = DbHelper::fetchAll($intrestRes); //print_r($intrestArr); $intrestCount = $intrestArr[0]->cntInt; if ($intrestCount < 12) { // echo "UPDATE ".$tableprefix."products SET vIntrest='Y' WHERE product_id IN ($productStr)"; DbHelper::execute("UPDATE " . $tableprefix . "products SET vIntrest='Y' WHERE product_id = '" . mysql_real_escape_string($chkProductId) . "'"); echo 1; exit; /* foreach($prodArr as $itemProd){ DbHelper::execute("UPDATE ".$tableprefix."products SET vIntrest='Y' WHERE product_id=".$itemProd); $msg =1; }*/ } else { echo 2; exit; }
$sellerProfileImageURL = $imageurl; $sellerProfileImage = $portfoliodir . "noimage.jpg"; } else { $imageurl = "<img src='" . $portfoliodir . $txtArtistPhoto . "' border='0' width='191' height='183' >"; $sellerProfileImageURL = $imageurl; $sellerProfileImage = $portfoliodir . $txtArtistPhoto; } // Seller Rating $sellerRes = DbHelper::execute("SELECT IFNULL(ROUND(AVG(rating),0),0) as rating FROM " . $tableprefix . "artist_feedbacks WHERE published = 'Y' AND artist_id =" . $artistid); $sellerRatingArr = DbHelper::fetchAll($sellerRes); // Total rating $sellerRating = $sellerRatingArr[0]->rating; // End Seller Rating // User Info $userInfoRes = DbHelper::execute("SELECT email,user_name FROM " . $tableprefix . "users WHERE user_id = '" . $_SESSION["sess_userid"] . "'"); $userInfoArr = DbHelper::fetchAll($userInfoRes); $email_address = $userInfoArr[0]->email; $contact_name = $userInfoArr[0]->user_name; if (strstr($contact_name, 'Guest') != '') { $contact_name = ''; } // User Info } /*----------Multicart 2.0 Upgradation Starts------------*/ if ($enable_seller_friendly == "Y") { $artist_name = $row['artist_name']; } /*----------Multicart 2.0 Upgradation Ends------------*/ /*display the active template*/ $active_template = displayTemplate(); //End pagination settings