Example #1
0
 /**
  * Get list filter by category product id
  *
  * @author MinhNV
  * Date 2010/07/06
  */
 private function getListFilter($table, $cat_product_id, $status = false)
 {
     $depart_id = Product::getDepartByCategoryId($cat_product_id);
     $cat_left = $depart_id == CGlobal::VC_MOBILE ? CATEGORY_FILTER_LEFT_SECTION_VCM : CATE_FILTER_LEFT_SECTION;
     $aryFilter = array();
     $sql = "SELECT id, category_id, cat_product_id, filter_name, filter_type, filter_value, link_fix, type FROM " . $table . " WHERE cat_product_id=" . $cat_product_id . ' AND category_id = ' . $cat_left;
     if ($status) {
         $sql .= " AND status=1";
     }
     $sql .= " ORDER BY filter_type ASC";
     $res = DB::query($sql);
     $objJSON = new Services_JSON();
     if ($res) {
         while ($row = mysql_fetch_assoc($res)) {
             //$row ['filter_value'] = objectToArray ( $objJSON->decode ( $row ['filter_value'] ) );
             $aryExtra = array();
             $aryExtra = objectToArray($objJSON->decode($row['filter_value']));
             $aryNameSort = array();
             foreach ($aryExtra as $k => $val) {
                 $aryNameSort[] = $val['title'];
             }
             array_multisort($aryExtra, SORT_ASC, $aryNameSort);
             $row['filter_value'] = $aryExtra;
             $aryFilter[] = $row;
         }
     }
     return $aryFilter;
 }