Changeset 21445 for branches/version-2_12-dev/data/class/SC_SelectSql.php
- Timestamp:
- 2012/02/06 21:31:07 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_SelectSql.php
r21444 r21445 102 102 103 103 // 開始期間だけ指定の場合 104 if (( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && ( $to_year == "" ) && ( $to_month == "") && ( $to_day == "")) {104 if (( $from_year != "") && ( $from_month != "") && ( $from_day != "") && ( $to_year == "") && ( $to_month == "") && ( $to_day == "")) { 105 105 $this->setWhere( $column .' >= ?'); 106 106 $return[] = $date1; … … 108 108 109 109 // 開始~終了 110 if( ( $from_year != "" ) && ( $from_month != "") && ( $from_day != "") &&111 ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "")) {110 if( ( $from_year != "") && ( $from_month != "") && ( $from_day != "") && 111 ( $to_year != "") && ( $to_month != "") && ( $to_day != "")) { 112 112 $this->setWhere( $column . ' >= ? AND ' . $column . ' < date(?)'); 113 113 $return[] = $date1; … … 116 116 117 117 // 終了期間だけ指定の場合 118 if (( $from_year == "" ) && ( $from_month == "" ) && ( $from_day == "" ) && ( $to_year != "" ) && ( $to_month != "") && ( $to_day != "")) {118 if (( $from_year == "") && ( $from_month == "") && ( $from_day == "") && ( $to_year != "") && ( $to_month != "") && ( $to_day != "")) { 119 119 $this->setWhere( $column . ' < date(?)'); 120 120 $return[] = $date2; … … 130 130 131 131 if (count( $arr) > 1) { 132 if( ! is_null( $data 132 if( ! is_null( $data)) $item .= $ItemStr . " = ? OR "; 133 133 } else { 134 if( ! is_null( $data 134 if( ! is_null( $data)) $item = $ItemStr . " = ?"; 135 135 } 136 136 $return[] = $data; 137 137 } 138 138 139 if( count( $arr ) > 1 ) $item = "( " . rtrim( $item, " OR ") . ")";139 if( count( $arr) > 1) $item = "( " . rtrim( $item, " OR ") . ")"; 140 140 $this->setWhere( $item); 141 141 return $return; … … 191 191 for ($i = 0; $i < $count; $i++) { 192 192 193 if( isset( $arrWhere[$i]['value'] 194 } 195 196 $statement = "( " . rtrim( $statement, " OR " 193 if( isset( $arrWhere[$i]['value'])) $statement .= $arrWhere[$i]['column'] ." = " . SC_Utils_Ex::sfQuoteSmart($arrWhere[$i]['value']) ." OR " ; 194 } 195 196 $statement = "( " . rtrim( $statement, " OR ") . ")"; 197 197 198 198 if ($this->where) {
Note: See TracChangeset
for help on using the changeset viewer.