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

Timestamp:

2012/02/15 19:56:17 (12 years ago)

Author:

Seasoft

Message:

#1625 (typo修正・ソース整形・ソースコメントの改善)

File:

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

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

@@ -37 +37 @@
 
     //--　コンストラクタ。
-    function SC_SelectSql($array = "") {
+    function SC_SelectSql($array = '') {
         if (is_array($array)) {
             $this->arrSql = $array;
@@ -44 +44 @@
 
     //-- SQL分生成
-    function getSql($mode = "") {
-        $this->sql = $this->select ." ". $this->where ." ". $this->group ." ";
+    function getSql($mode = '') {
+        $this->sql = $this->select .' '. $this->where .' '. $this->group ." ";
 
         // $mode == 1 は limit & offset無し
@@ -51 +51 @@
             $this->sql .= $this->order;
         } elseif ($mode != 1) {
-            $this->sql .= $this->order . " " .$this->limit ." ". $this->offset;
+            $this->sql .= $this->order . ' ' .$this->limit .' '. $this->offset;
         }
 
@@ -59 +59 @@
         // 検索用
     function addSearchStr($val) {
-        $return = "%" .$val. "%";
+        $return = '%' .$val. '%';
         return $return;
     }
@@ -68 +68 @@
         // ある単位のみ検索($from = $to)
         if ($from == $to) {
-            $this->setWhere($column ." = ?");
+            $this->setWhere($column .' = ?');
             $return = array($from);
         //　~$toまで検索
         } elseif (strlen($from) == 0 && strlen($to) > 0) {
-            $this->setWhere($column ." <= ? ");
+            $this->setWhere($column .' <= ? ');
             $return = array($to);
         //　~$from以上を検索
         } elseif (strlen($from) > 0 && strlen($to) == 0) {
-            $this->setWhere($column ." >= ? ");
+            $this->setWhere($column .' >= ? ');
             $return = array($from);
         //　$from~$toの検索
         } else {
-            $this->setWhere($column ." BETWEEN ? AND ?");
+            $this->setWhere($column .' BETWEEN ? AND ?');
             $return = array($from, $to);
         }
@@ -91 +91 @@
 
         // 開始期間の構築
-        $date1 = $from_year . "/" . $from_month . "/" . $from_day;
+        $date1 = $from_year . '/' . $from_month . '/' . $from_day;
 
         // 終了期間の構築
@@ -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;
@@ -108 +108 @@
 
         //　開始～終了
-        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 . ' >= ? AND ' . $column . ' < date(?)');
             $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;
@@ -130 +130 @@
 
             if (count($arr) > 1) {
-                if(! is_null($data)) $item .= $ItemStr . " = ? OR ";
+                if(! is_null($data)) $item .= $ItemStr . ' = ? OR ';
             } else {
-                if(! is_null($data)) $item = $ItemStr . " = ?";
+                if(! is_null($data)) $item = $ItemStr . ' = ?';
             }
             $return[] = $data;
         }
 
-        if( count($arr) > 1)  $item = "(" . rtrim($item, " OR ") . ")";
+        if( count($arr) > 1)  $item = '(' . rtrim($item, ' OR ') . ")";
         $this->setWhere($item);
         return $return;
@@ -149 +149 @@
         if ($arr) {
             foreach ($arr as $data) {
-                if ($data != "不明") {
+                if ($data != '不明') {
                     $item .= " OR ${ItemStr} = ?";
                     $return[] = $data;
@@ -194 +194 @@
         }
 
-        $statement = "(" . rtrim($statement, " OR ") . ")";
+        $statement = '(' . rtrim($statement, ' OR ') . ")";
 
         if ($this->where) {
 
-            $this->where .= " AND " . $statement;
+            $this->where .= ' AND ' . $statement;
 
         } else {
 
-            $this->where = "WHERE " . $statement;
+            $this->where = 'WHERE ' . $statement;
         }
     }
 
     function setWhere($where) {
-        if ($where != "") {
+        if ($where != '') {
             if ($this->where) {
 
-                $this->where .= " AND " . $where;
+                $this->where .= ' AND ' . $where;
 
             } else {
 
-                $this->where = "WHERE " . $where;
+                $this->where = 'WHERE ' . $where;
             }
         }
@@ -221 +221 @@
     function setOrder($order) {
 
-            $this->order =  "ORDER BY " . $order;
+            $this->order =  'ORDER BY ' . $order;
 
     }
@@ -227 +227 @@
     function setGroup($group) {
 
-        $this->group =  "GROUP BY " . $group;
+        $this->group =  'GROUP BY ' . $group;
 
     }
@@ -235 +235 @@
         if (is_numeric($limit) and is_numeric($offset)) {
 
-            $this->limit = " LIMIT " .$limit;
-            $this->offset = " OFFSET " .$offset;
+            $this->limit = ' LIMIT ' .$limit;
+            $this->offset = ' OFFSET ' .$offset;
         }
     }
 
     function clearSql() {
-        $this->select = "";
-        $this->where = "";
-        $this->group = "";
-        $this->order = "";
-        $this->limit = "";
-        $this->offset = "";
+        $this->select = '';
+        $this->where = '';
+        $this->group = '';
+        $this->order = '';
+        $this->limit = '';
+        $this->offset = '';
     }