Exemplo n.º 1
0
 /**
  * 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);
 }