/** * This function is used to get the attribute list * * * @return string */ function attributeList() { $sqlVari = "SELECT product_id,has_variation\n\t\tFROM products_table WHERE product_id =" . (int) $_GET['prodid'] . " "; $queryVari = new Bin_Query(); $queryVari->executeQuery($sqlVari); $has_variation = $queryVari->records[0]['has_variation']; if ($has_variation == '0') { $sqlfeature = "SELECT product_id,sku,brand,weight,dimension,model\n\t\t\t\tFROM products_table WHERE product_id =" . (int) $_GET['prodid'] . " "; $queryfeature = new Bin_Query(); $queryfeature->executeQuery($sqlfeature); $recordsfeature = $queryfeature->records; $sql = "SELECT attrib_name, attrib_value \n\t\t\t\tFROM `attribute_value_table` av, attribute_table at\n\t\t\t\tWHERE av.attrib_id = at.attrib_id AND av.attrib_value_id IN (SELECT attrib_value_id \n\t\t\t\tFROM product_attrib_values_table\n\t\t\t\tWHERE product_id =" . (int) $_GET['prodid'] . ')'; $query = new Bin_Query(); $query->executeQuery($sql); return Display_DProductDetail::attributeList($query->records, $recordsfeature); } if ($has_variation == '1') { $sqlfeature = "SELECT *\n\t\t\t\tFROM product_variation_table WHERE product_id =" . (int) $_GET['prodid'] . " "; $queryfeature = new Bin_Query(); $queryfeature->executeQuery($sqlfeature); $recordsfeature = $queryfeature->records; $sql = "SELECT attrib_name, attrib_value \n\t\t\t\tFROM `attribute_value_table` av, attribute_table at\n\t\t\t\tWHERE av.attrib_id = at.attrib_id AND av.attrib_value_id IN (SELECT attrib_value_id \n\t\t\t\tFROM product_attrib_values_table\n\t\t\t\tWHERE product_id =" . (int) $_GET['prodid'] . ')'; $query = new Bin_Query(); $query->executeQuery($sql); return Display_DProductDetail::attributeList($query->records, $recordsfeature); } else { return Display_DProductDetail::attributeList($flag = 0, $recordsfeature); } }
/** * Function gets the attribute list for the selected product * * * @return string */ function attributeList() { $sql = "SELECT attrib_name, attrib_value \n\t\tFROM `attribute_value_table` av, attribute_table at\n\t\tWHERE av.attrib_id = at.attrib_id AND av.attrib_value_id IN (SELECT attrib_value_id \n\t\tFROM product_attrib_values_table\n\t\tWHERE product_id =" . (int) $_GET['prodid'] . ')'; $query = new Bin_Query(); if ($query->executeQuery($sql)) { return Display_DProductDetail::attributeList($query->records); } else { //return "Not Found"; } }