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

Timestamp:

2012/06/19 18:01:38 (12 years ago)

Author:

pineray

Message:

#1669 #1859 初期化漏れ、無駄な変数等

File:

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

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

@@ -122 +122 @@
     // checkboxなどで同一カラム内で単一、もしくは複数選択肢が有る場合　例: AND ( sex = xxx OR sex = xxx OR sex = xxx) AND ...
     function setItemTerm($arr, $ItemStr) {
-
+        $return = array();
         foreach ($arr as $data) {
 
@@ -147 +147 @@
     //　NULL値が必要な場合
     function setItemTermWithNull($arr, $ItemStr) {
-
-        $item = " ${ItemStr} IS NULL ";
+        $return = array();
+        $item = " {$ItemStr} IS NULL ";
 
         if ($arr) {
             foreach ($arr as $data) {
                 if ($data != '不明') {
-                    $item .= " OR ${ItemStr} = ?";
+                    $item .= " OR {$ItemStr} = ?";
                     $return[] = $data;
                 }
@@ -159 +159 @@
         }
 
-        $item = "(${item}) ";
+        $item = "({$item}) ";
         $this->setWhere($item);
         return $return;
@@ -165 +165 @@
     // NULLもしくは''で検索する場合
     function setItemTermWithNullAndSpace($arr, $ItemStr) {
+        $return = array();
         $count = count($arr);
-        $item = " ${ItemStr} IS NULL OR ${ItemStr} = '' ";
+        $item = " {$ItemStr} IS NULL OR {$ItemStr} = '' ";
         $i = 1;
         if ($arr) {
             foreach ($arr as $data) {
                 if ($i == $count) break;
-                $item .= " OR ${ItemStr} = ?";
+                $item .= " OR {$ItemStr} = ?";
                 $return[] = $data;
                 $i ++;
             }
         }
-        $item = "(${item}) ";
+        $item = "({$item}) ";
         $this->setWhere($item);
         return $return;