Changeset 23124 for branches/version-2_13-dev/data/class/SC_SelectSql.php

Timestamp:

2013/08/24 23:33:52 (11 years ago)

Author:

kimoto

Message:

#2043 typo修正・ソース整形・ソースコメントの改善 for 2.13.0
PHP4的な書き方の修正

File:

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

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

@@ -25 +25 @@
 class SC_SelectSql
 {
-    var $sql;
-
-    var $select;
-    var $where;
-    var $order;
-    var $group;
-    var $arrSql;
-    var $arrVal;
+    public $sql;
+
+    public $select;
+    public $where;
+    public $order;
+    public $group;
+    public $arrSql;
+    public $arrVal;
 
     //--　コンストラクタ。
-    function __construct($array = '')
+    public function __construct($array = '')
     {
         if (is_array($array)) {
@@ -43 +43 @@
 
     //-- SQL分生成
-    function getSql($mode = '')
+    public function getSql($mode = '')
     {
         $this->sql = $this->select .' '. $this->where .' '. $this->group .' ';
@@ -55 +55 @@
 
         // 検索用
-    function addSearchStr($val)
+    public function addSearchStr($val)
     {
         $return = '%' .$val. '%';
@@ -63 +63 @@
 
     //-- 範囲検索（○　~　○　まで）
-    function selectRange($from, $to, $column)
+    public function selectRange($from, $to, $column)
     {
         // ある単位のみ検索($from = $to)
@@ -87 +87 @@
 
     //--　期間検索（○年○月○日か~○年○月○日まで）
-    function selectTermRange($from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $column)
+    public function selectTermRange($from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $column)
     {
         $return = array();
@@ -127 +127 @@
 
     // checkboxなどで同一カラム内で単一、もしくは複数選択肢が有る場合　例: AND ( sex = xxx OR sex = xxx OR sex = xxx) AND ...
-    function setItemTerm($arr, $ItemStr)
+    public function setItemTerm($arr, $ItemStr)
     {
         $return = array();
@@ -153 +153 @@
 
     //　NULL値が必要な場合
-    function setItemTermWithNull($arr, $ItemStr)
+    public function setItemTermWithNull($arr, $ItemStr)
     {
         $return = array();
@@ -173 +173 @@
     }
     // NULLもしくは''で検索する場合
-    function setItemTermWithNullAndSpace($arr, $ItemStr)
+    public function setItemTermWithNullAndSpace($arr, $ItemStr)
     {
         $return = array();
@@ -200 +200 @@
 
     */
-    function setWhereByOR($arrWhere)
+    public function setWhereByOR($arrWhere)
     {
         $count = count($arrWhere);
@@ -226 +226 @@
      * @return string WHERE
      */
-    function getWhere($with_where = false)
+    public function getWhere($with_where = false)
     {
         $where = $this->where;
@@ -237 +237 @@
     }
 
-    function setWhere($where)
+    public function setWhere($where)
     {
         if ($where != '') {
@@ -248 +248 @@
     }
 
-    function setOrder($order)
+    public function setOrder($order)
     {
             $this->order =  'ORDER BY ' . $order;
     }
 
-    function setGroup($group)
+    public function setGroup($group)
     {
         $this->group =  'GROUP BY ' . $group;
     }
 
-    function clearSql()
+    public function clearSql()
     {
         $this->select = '';
@@ -266 +266 @@
     }
 
-    function setSelect($sql)
+    public function setSelect($sql)
     {
         $this->select = $sql;