/** * This function is used to get the featureList * @return string */ function featureList() { if (empty($_POST['subcatsel'])) { $id = $_SESSION['category']; } else { $id = $_SESSION['subcategory']; } //$sql="select count(*)as cnt,b.attrib_value,a.product_id from product_attrib_values_table a inner join attribute_value_table b on a.attrib_value_id=b.attrib_value_id inner join products_table c on c.product_id=a.product_id inner join category_table d on c.category_id=d.category_id where d.category_id=".$id." group by attrib_value"; //$sql="select count(*)as cnt,b.attrib_value,a.product_id,e.attrib_name,e.attrib_id from product_attrib_values_table a inner join attribute_value_table b on a.attrib_value_id=b.attrib_value_id inner join products_table c on c.product_id=a.product_id inner join category_table d on c.category_id=d.category_id inner join attribute_table e on b.attrib_id=e.attrib_id where d.category_id=".$id." group by attrib_value order by e.attrib_name"; //$sql='select a.*,b.attrib_name from category_attrib_table a inner join attribute_table b on a.attrib_id=b.attrib_id where subcategory_id='.$id; $sql = "select b.attrib_name,a.attrib_id,a.subcategory_id from category_attrib_table a inner join attribute_table b on a.attrib_id=b.attrib_id where a.subcategory_id=" . $id; $obj = new Bin_Query(); $obj->executeQuery($sql); $res = $obj->records; $i = 0; if (count($res) > 0) { foreach ($res as $row) { $attrib_id = $row['attrib_id']; $sql1 = "select b.attrib_value,count(*) as cnt,b.attrib_value_id from product_attrib_values_table a inner join attribute_value_table b on a.attrib_value_id=b.attrib_value_id inner join products_table c on c.product_id=a.product_id where c.category_id=" . $id . " and b.attrib_id=" . $attrib_id . " and c.intro_date <= '" . date('Y-m-d') . "' and c.status=1 group by b.attrib_value"; $obj1 = new Bin_Query(); $obj1->executeQuery($sql1); $res1 = $obj1->records; $j = 0; if ($obj1->totrows > 0) { $att1_name = $row['attrib_name']; $kk[$i] = $att1_name; foreach ($res1 as $row1) { $attrib_value1 = $row1['attrib_value']; $cnt1 = $row1['cnt']; $ss[$i][$j] = $attrib_value1 . "(" . $row1['cnt'] . ")"; if ($_GET['attribute_value_id'] != $row1['attrib_value_id']) { $att[$i][$j] = $row1['attrib_value_id']; } $j++; } } $i++; } } return Display_DKeywordSearch::featureList($kk, $ss, $att, $id); }
/** * Function returns the feature list of products * * * @return string */ function featureList() { $id = $_POST['id']; $id = 2; $sql1 = 'select distinct a.attrib_name,a.attrib_id from attribute_table a join attribute_value_table b on a.attrib_id=b.attrib_id inner join category_attrib_table c on c.attrib_id=b.attrib_id inner join category_table d on c.subcategory_id=d.category_id where d.category_id=' . $id; $obj1 = new Bin_Query(); $obj1->executeQuery($sql1); $sql = 'select a.attrib_id,a.attrib_name,b.attrib_value_id,b.attrib_value,d.category_name,d.category_id from attribute_table a inner join attribute_value_table b on a.attrib_id=b.attrib_id inner join category_attrib_table c on c.attrib_id=b.attrib_id inner join category_table d on c.subcategory_id=d.category_id where d.category_id=' . $id; $obj = new Bin_Query(); $obj->executeQuery($sql); for ($i = 0; $i < $obj->totrows; $i++) { if ($obj->records[$i]['attrib_value_id'] != 0) { $obj->records[$i]['productCnt'] = Core_CKeywordSearch::getProductCount($obj->records[$i]['attrib_value_id']); } } return Display_DKeywordSearch::featureList($obj1->records, $obj->records); }