getColumnContentByTable("productcategory","name","id",$catid); if($brandId==0){ $activeSeason="BSMT"; }else{ $activeSeason=$GeneralManageDA->getColumnContentByTable("producer","activeSeason","id",$brandId); } include 'connection.php'; //----------------------Color------------------------ $queryC="select id,title,value from settings where type='color' order by value asc"; $resultC=mysqli_query($link,$queryC)or die(mysqli_error($link)); while($rowC=mysqli_fetch_assoc($resultC)){ $rowsC[] = $rowC; } //----------------------Brand-------------------------- //$queryB="select id,name,nameEn from producer where isDisabled='no' order by nameEn asc"; $queryB="Select producer.id,producer.name,producer.nameEn from producer INNER JOIN products ON producer.id=products.brandId INNER JOIN barcodes ON products.sku=barcodes.sku INNER JOIN productcategory ON productcategory.id=products.categoryId where products.isDisabled='no' AND producer.isDisabled='no' AND products.isRemoved='no' AND products.imageExist='yes' AND barcodes.season='BSMT' AND products.season='BSMT' $wcat $wg group by producer.id order by producer.nameEn asc"; $resultB=mysqli_query($link,$queryB)or die(mysqli_error($link)); if(mysqli_num_rows($resultB)){ while($rowB=mysqli_fetch_assoc($resultB)){ $rowsB[] = $rowB; } }else{} //----------------------Category-------------------------- function checkChildCategoryExist($catid){ include 'connection.php'; $query="Select id from productcategory where parentId='".$catid."' AND isDisabled='no' "; $result=mysqli_query($link,$query)or die(mysqli_error($link)); if(mysqli_num_rows($result)){ return "exist"; }else{ return "notExist"; } mysqli_close($link); } function checkChildHasParent($catid){ include 'connection.php'; $query="Select parentId from productcategory where id='".$catid."' AND isDisabled='no' "; $result=mysqli_query($link,$query)or die(mysqli_error($link)); $row=mysqli_fetch_assoc($result); return $row['parentId']; mysqli_close($link); } function getSubCategorySide($brandId,$catid,$genderId,$sort,$stock,$color,$size,$range,$txt,$parentId,$start,$end){ include 'connection.php'; switch($genderId){ case "0" : $genderName=""; break; case "1" : $genderName="women";$genderNameFa="خانم ها"; break; case "2" : $genderName= "men"; $genderNameFa="آقایان"; break; case "3" : $genderName= "kids"; $genderNameFa="کودکان"; break; case "4" : $genderName= "teenager"; break; //case "5" : $genderName= "زنانه/مردانه"; break; } $query="Select id,name,genderGroup from productcategory where parentId='".$parentId."' AND isDisabled='no' order by priority ASC limit $start , $end"; $result=mysqli_query($link,$query)or die(mysqli_error($link)); $i=1; while($row=mysqli_fetch_assoc($result)){ echo ''; } mysqli_close($link); } //------------------------- function getSubCategorySideMobile($brandId,$catid,$genderId,$sort,$stock,$color,$size,$range,$txt,$parentId,$start,$end){ include 'connection.php'; switch($genderId){ case "0" : $genderName=""; break; case "1" : $genderName="women";$genderNameFa="خانم ها"; break; case "2" : $genderName= "men"; $genderNameFa="آقایان"; break; case "3" : $genderName= "kids"; $genderNameFa="کودکان"; break; case "4" : $genderName= "teenager"; break; //case "5" : $genderName= "زنانه/مردانه"; break; } $query="Select id,name,genderGroup from productcategory where parentId='".$parentId."' AND isDisabled='no' order by priority ASC limit $start , $end"; $result=mysqli_query($link,$query)or die(mysqli_error($link)); while($row=mysqli_fetch_assoc($result)){ if($row['id']=="49"){}else{ $genderGroup= explode("|",$row['genderGroup']); foreach($genderGroup as $gender){ if($gender==@$genderName){ echo ''; }else{} }//end foreach }// end of 49 } mysqli_close($link); } //---------------------------------------------------- get size-------------------------------------------- function getSize($brandId,$brandEn,$genderId,$season,$color,$catid,$sortPrice,$stock,$range){ //if($genderId=="0"){ $wg=""; }else{ $wg="AND products.genderId='".$genderId."' " ;} include 'connection.php'; $query="select size from barcodes where brandId='".$brandId."' AND season='BSMT' group by size order by cast(size as unsigned) "; $result=mysqli_query($link,$query)or die(mysqli_error($link)); while($row=mysqli_fetch_assoc($result)){ echo ''; echo "
".$row['size']."
"; } mysqli_close($link); } $activeSeasonGeneral=$ini_array['activeSeason']; //this must be changed to sq if(isset($_REQUEST['brandId'])){ switch($sort){ case "asc" : $sortText="بر اساس کمترین قیمت"; break; case "desc" : $sortText="بر اساس بیشترین قیمت"; break; } switch($genderId){ case "0" : $genderText="جنسیت: همه موارد"; break; case "1" : $genderText=" جنسیت: خانم ها"; break; case "2" : $genderText="جنسیت: آقایان "; break; case "3" : $genderText="جنسیت: کودکان"; break; case "4" : $genderText="جنسیت: نوجوان"; break; } switch($color){ case "All" : $colorText="رنگ :همه موارد"; break; case $color : $colorText=" رنگ: " .$GeneralManageDA->getColumnContentByTable("settings","title","value","#$color") ; break; } switch($size){ case "All" : $sizeText="سایز: همه موارد"; break; case $size : $sizeText=" سایز: " .$size ; break; } switch($range){ case "All" : $rangeText="بازه ی قیمت: همه موارد"; break; case $range : $rangeText=" بازه ی قیمت: " .$range ; break; } // echo "

نتیجه جستجو برای : ".str_replace("%","",$txt).""; // echo "مرتب سازی بر اساس: "; // echo $sortText." | ".$genderText." | ".$colorText . " | ".$sizeText . " | ".$rangeText ; // echo "

"; // echo "
"; $page=1; $count=51; include 'connection.php'; $queryPG="select products.id,barcodes.season,products.brand,products.brandId,products.sku,products.articleCode,products.categoryId,products.genderId,products.fullname, barcodes.price,barcodes.barcode,products.name as pname,products.outofStock,settings.value,producer.name as brandName,producer.nameEn from products INNER JOIN barcodes ON products.sku=barcodes.sku INNER JOIN producer ON products.brandId=producer.id LEFT JOIN settings ON settings.id=products.color where products.isDisabled='no' AND producer.isDisabled='no' AND isRemoved='no' AND products.imageExist='yes' AND barcodes.season='BSMT' AND products.season='BSMT' $wg $wcol $wsize $wrange $wbrand $wcat $wtxt group by products.articleCode order by products.outofStock desc $sortPrice "; $resultPG=mysqli_query($link,$queryPG)or die(mysqli_error($link)); $CountRow =mysqli_num_rows($resultPG); if (isset($_GET['page'])) $page=$_GET['page']; $offset= ($page-1)*$count; $queryProducts="select products.id,barcodes.season,products.brand,products.brandId,products.sku,products.articleCode,products.categoryId,products.genderId,products.fullname, barcodes.price,barcodes.barcode,products.name as pname,products.outofStock,settings.value,producer.name as brandName,producer.nameEn from products INNER JOIN barcodes ON products.sku=barcodes.sku INNER JOIN producer ON products.brandId=producer.id LEFT JOIN settings ON settings.id=products.color where products.isDisabled='no' AND producer.isDisabled='no' AND isRemoved='no' AND products.imageExist='yes' AND barcodes.season='BSMT' AND products.season='BSMT' $wg $wcol $wsize $wrange $wbrand $wcat $wtxt group by products.articleCode order by products.outofStock desc $sortPrice limit $offset,$count"; $resultProducts=mysqli_query($link,$queryProducts)or die(mysqli_error($link)); ?> فروشگاه اینترنتی بیست مارت

فیلترهای انتخاب شده
getColumnContentByTable("settings","title","value","#".$color) .' X '; echo "$colorName"; } if($brandId!='0'){ $brandNameF=$GeneralManageDA->getColumnContentByTable("producer","nameEn","id",$brandId) .' X '; echo "$brandNameF"; } if($txt!='0'){ $txtFil=$txt.' X '; echo "$txtFil"; } ?>
getColumnContentByTable("producer","image","id",$brandId); echo '
'; }else{} if(isset($_GET['genderId'])){ echo ''.@$genderNameFa.''; }else{} if(isset($_GET['catid']) && $_GET['catid']!=0){ if(checkChildHasParent($catid)>0){ $parid=checkChildHasParent($catid); $parentName=$GeneralManageDA->getColumnContentByTable("productcategory","name","id",$parid); echo ' › '. $parentName .''; }else{} echo " › ". $categoryName .""; }else{} ?>

    '; echo 'خانم ها'; echo '
  • '; echo 'آقایان
    • '; echo '
  • '; echo 'کودکان
    • '; }else{ if(checkChildCategoryExist($catid)=="exist"){ getSubCategorySide($brandId,$catid,$genderId,$sort,$stock,$color,$size,$range,$txt,$catid,"0","100"); }else{ $topParent=$GeneralManageDA->getColumnContentByTable("productcategory","parentId","id",$catid); getSubCategorySide($brandId,$catid,$genderId,$sort,$stock,$color,$size,$range,$txt,$topParent,"0","100"); } } ?>

برند

رنگ
  • '; ?>
مرتب سازی :
ارزان‌ترین'; echo 'گران‌ترین'; echo 'جدیدترین'; ?>
getColumnContentByTable("producer","activeSeason","id",$rowProducts['brandId']); //$brandSeason="BSMT"; if(is_dir('images/products/'.$rowProducts['season'].'/'.$rowProducts['brand'].'/'.$rowProducts['sku'].'')){}else{} //$brandEn=$GeneralManageDA->getColumnContentByTable("producer","nameEn","id",$rowProducts['brandId']); //$brandFa=$GeneralManageDA->getColumnContentByTable("producer","name","id",$rowProducts['brandId']); $brandEn=$rowProducts['nameEn']; $brandFa=$rowProducts['brandName']; $discount=ProductManageDA::getProductDiscount($rowProducts['id'],$activeSeason); if($discount>0){ $discountBox="
%".$discount."
"; }else{ $discountBox=""; } ?> getCategoryParentsShort($rowProducts['categoryId']); if($rowProducts['genderId']!=0){ switch($rowProducts['genderId']){ case "1" : $genderName="زنانه"; break; case "2" : $genderName= "مردانه"; break; case "3" : $genderName= "بچه گانه"; break; case "4" : $genderName= "نوجوان"; break; case "5" : $genderName= "زنانه/مردانه"; break; } }else{} $name2= " ".@$genderName." ".$brandFa; ?>
'">
" alt="" border="0" style="margin-top:0px;"/>
".$name1.$name2." "; ?>
0){ $ProductManageDA->updateProductAvailability($rowProducts['id'],"no"); $discountAmount=($mainPrice*$discount)/100; $showPrice=number_format(($mainPrice-$discountAmount)/10); $priceBefore=" ".number_format($mainPrice/10)."   "; }else{ $showPrice=number_format($mainPrice/10); $priceBefore=""; } echo $priceBefore.$showPrice ; ?> موجود نیست"; // $ProductManageDA->updateProductAvailability($rowProducts['id'],"yes"); }//end of stockcheck ?>
بازگشت
لطفا فیلد جستجو را تکمیل کنید "; // if not txt set } //--- ?>