Changeset 21441 for branches/version-2_12-dev/data/class/SC_SelectSql.php

Timestamp:

2012/02/06 11:05:15 (15 years ago)

Author:

Seasoft

Message:

#1613 (ソース整形・ソースコメントの改善)

• Zend Framework PHP 標準コーディング規約への準拠を高めた

File:

• branches/version-2_12-dev/data/class/SC_SelectSql.php (modified) (10 diffs)

branches/version-2_12-dev/data/class/SC_SelectSql.php

@@ -67 +67 @@
 
         // ある単位のみ検索($from = $to)
-        if(  $from == $to ) {
+        if ($from == $to ) {
             $this->setWhere( $column ." = ?" );
             $return = array($from);
         //　~$toまで検索
-        } elseif(  strlen($from) == 0 && strlen($to) > 0 ) {
+        } elseif (strlen($from) == 0 && strlen($to) > 0 ) {
             $this->setWhere( $column ." <= ? ");
             $return = array($to);
         //　~$from以上を検索
-        } elseif(  strlen($from) > 0 && strlen($to) == 0 ) {
+        } elseif (strlen($from) > 0 && strlen($to) == 0 ) {
             $this->setWhere( $column ." >= ? ");
             $return = array($from);
@@ -102 +102 @@
 
         // 開始期間だけ指定の場合
-        if( ( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && ( $to_year == "" ) && ( $to_month == "" ) && ( $to_day == "" ) ) {
+        if (( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && ( $to_year == "" ) && ( $to_month == "" ) && ( $to_day == "" ) ) {
             $this->setWhere( $column .' >= ?');
             $return[] = $date1;
@@ -116 +116 @@
 
         // 終了期間だけ指定の場合
-        if( ( $from_year == "" ) && ( $from_month == "" ) && ( $from_day == "" ) && ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
+        if (( $from_year == "" ) && ( $from_month == "" ) && ( $from_day == "" ) && ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
             $this->setWhere( $column . ' < date(?)');
             $return[] = $date2;
@@ -127 +127 @@
     function setItemTerm( $arr, $ItemStr ) {
 
-        foreach( $arr as $data ) {
-
-            if( count( $arr ) > 1 ) {
+        foreach ($arr as $data ) {
+
+            if (count( $arr ) > 1 ) {
                 if( ! is_null( $data ) ) $item .= $ItemStr . " = ? OR ";
             } else {
@@ -147 +147 @@
         $item = " ${ItemStr} IS NULL ";
 
-        if ( $arr ){
-            foreach( $arr as $data ) {
+        if ($arr ) {
+            foreach ($arr as $data ) {
                 if ($data != "不明") {
                     $item .= " OR ${ItemStr} = ?";
@@ -165 +165 @@
         $item = " ${ItemStr} IS NULL OR ${ItemStr} = '' ";
         $i = 1;
-        if ( $arr ){
-            foreach( $arr as $data ) {
+        if ($arr ) {
+            foreach ($arr as $data ) {
                 if ($i == $count) break;
                 $item .= " OR ${ItemStr} = ?";
@@ -189 +189 @@
         $count = count( $arrWhere );
 
-        for( $i = 0; $i < $count; $i++ ) {
+        for ($i = 0; $i < $count; $i++ ) {
 
             if( isset( $arrWhere[$i]['value'] ) ) $statement .= $arrWhere[$i]['column'] ." = " . SC_Utils_Ex::sfQuoteSmart($arrWhere[$i]['value']) ." OR "  ;
@@ -196 +196 @@
         $statement = "( " . rtrim( $statement, " OR " ) . " )";
 
-        if( $this->where ) {
+        if ($this->where ) {
 
             $this->where .= " AND " . $statement;
@@ -208 +208 @@
     function setWhere($where){
         if ($where != "") {
-            if( $this->where ) {
+            if ($this->where ) {
 
                 $this->where .= " AND " . $where;
@@ -233 +233 @@
     function setLimitOffset( $limit, $offset ){
 
-        if ( is_numeric($limit) and is_numeric($offset) ){
+        if (is_numeric($limit) and is_numeric($offset) ) {
 
             $this->limit = " LIMIT " .$limit;