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

Timestamp:

2012/02/06 11:27:03 (12 years ago)

Author:

Seasoft

Message:

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

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

File:

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

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

@@ -50 +50 @@
         if ($mode == 2) {
             $this->sql .= $this->order;
-        }elseif ( $mode != 1 ){
+        } elseif ($mode != 1) {
             $this->sql .= $this->order . " " .$this->limit ." ". $this->offset;
         }
@@ -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;