- Timestamp:
- 2014/05/30 10:06:18 (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/helper/SC_Helper_Review.php
r23461 r23464 39 39 public function get($review_id) 40 40 { 41 $objQuery =& SC_Query_Ex::getSingletonInstance(); 42 $select='review_id, A.product_id, reviewer_name, sex, recommend_level, '; 43 $select.='reviewer_url, title, comment, A.status, A.create_date, A.update_date, name'; 44 $from = 'dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id '; 45 $where = 'A.del_flg = 0 AND B.del_flg = 0 AND review_id = ? '; 46 $arrReview = $objQuery->select($select, $from, $where, array($review_id)); 41 $query = array( 42 'review_id' => $review_id 43 ); 44 $arrReview = $this->find(array('query' => $query)); 47 45 48 46 return $arrReview[0]; … … 182 180 } else { 183 181 $where.= ' AND A.product_id = ?'; 182 $values[] = $val; 183 } 184 break; 185 186 case 'review_id': 187 if (is_array($val)) { 188 $where.= ' AND review_id IN (' . SC_Utils_Ex::sfGetCommaList($val) . ')'; 189 } else { 190 $where.= ' AND review_id = ?'; 184 191 $values[] = $val; 185 192 }
Note: See TracChangeset
for help on using the changeset viewer.