Changeset 11729 for branches/comu/data/class/SC_SelectSql.php

Timestamp:

2007/03/10 21:35:02 (19 years ago)

Author:

nanasess

Message:

UTF-8 へ変換

File:

• branches/comu/data/class/SC_SelectSql.php (modified) (13 diffs)

branches/comu/data/class/SC_SelectSql.php

@@ -6 +6 @@
  */
 
-/* ---- SQLʸ¤òºî¤ë¥¯¥é¥¹ ---- */
+/* ---- SQL文を作るクラス ---- */
 class SC_SelectSql {
     
@@ -20 +20 @@
     var $arrVal;
 
-    //--¡¡¥³¥ó¥¹¥È¥é¥¯¥¿¡£
+    //--　コンストラクタ。
     function SC_SelectSql($array = "") {
         if (is_array($array)) {
@@ -27 +27 @@
     }
 
-    //-- SQLʬÀ¸À®
+    //-- SQL分生成
     function getSql( $mode = "" ){
         $this->sql = $this->select ." ". $this->where ." ". $this->group ." ";
                         
-        // $mode == 1 ¤Ï limit & offset̵¤·                     
+        // $mode == 1 は limit & offset無し                        
         if ( $mode != 1 ){
             $this->sql .= $this->order . " " .$this->limit ." ". $this->offset; 
@@ -40 +40 @@
     }
 
-        // ¸¡º÷ÍÑ
+        // 検索用
     function addSearchStr($val) {
         $return = sfManualEscape($val);
@@ -47 +47 @@
     }
     
-    //-- Èϰϸ¡º÷¡Ê¡û¡¡¢·¡¡¡û¡¡¤Þ¤Ç¡Ë
+    //-- 範囲検索（○　～　○　まで）
     function selectRange($from, $to, $column) {
 
-        // ¤¢¤ëñ°Ì¤Î¤ß¸¡º÷($from = $to)
+        // ある単位のみ検索($from = $to)
         if(  $from == $to ) {
             $this->setWhere( $column ." = ?" );
             $return = array($from);
-        //¡¡¢·$to¤Þ¤Ç¸¡º÷
+        //　～$toまで検索
         } elseif(  strlen($from) == 0 && strlen($to) > 0 ) {
             $this->setWhere( $column ." <= ? "); 
             $return = array($to);
-        //¡¡¢·$from°Ê¾å¤ò¸¡º÷
+        //　～$from以上を検索
         } elseif(  strlen($from) > 0 && strlen($to) == 0 ) {
             $this->setWhere( $column ." >= ? ");
             $return = array($from);
-        //¡¡$from¢·$to¤Î¸¡º÷
+        //　$from～$toの検索
         } else {
             $this->setWhere( $column ." BETWEEN ? AND ?" ); 
@@ -70 +70 @@
     }
 
-    //--¡¡´ü´Ö¸¡º÷¡Ê¡ûǯ¡û·î¡ûÆü¤«¢·¡ûǯ¡û·î¡ûÆü¤Þ¤Ç¡Ë
+    //--　期間検索（○年○月○日か～○年○月○日まで）
     function selectTermRange($from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $column) {
 
@@ -81 +81 @@
         $date2 = date('y/m/d', $date2);
         
-        // ³«»Ï´ü´Ö¤À¤±»ØÄê¤Î¾ì¹ç
+        // 開始期間だけ指定の場合
         if( ( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && ( $to_year == "" ) && ( $to_month == "" ) && ( $to_day == "" ) ) {
             $this->setWhere( $column ." >= '" . $date1 . "'");
         }
 
-        //¡¡³«»Ï¡Á½ªÎ»
+        //　開始〜終了
         if( ( $from_year != "" ) && ( $from_month != "" ) && ( $from_day != "" ) && 
             ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
@@ -92 +92 @@
         }
 
-        // ½ªÎ»´ü´Ö¤À¤±»ØÄê¤Î¾ì¹ç
+        // 終了期間だけ指定の場合
         if( ( $from_year == "" ) && ( $from_month == "" ) && ( $from_day == "" ) && ( $to_year != "" ) && ( $to_month != "" ) && ( $to_day != "" ) ) {
             $this->setWhere( $column ." < date('" . $date2 . "')");
@@ -99 +99 @@
     }   
 
-    // checkbox¤Ê¤É¤ÇƱ°ì¥«¥é¥àÆâ¤Çñ°ì¡¢¤â¤·¤¯¤ÏÊ£¿ôÁªÂò»è¤¬Í­¤ë¾ì¹ç¡¡Îã: AND ( sex = xxx OR sex = xxx OR sex = xxx  ) AND ... 
+    // checkboxなどで同一カラム内で単一、もしくは複数選択肢が有る場合　例: AND ( sex = xxx OR sex = xxx OR sex = xxx  ) AND ... 
     function setItemTerm( $arr, $ItemStr ) {
 
@@ -117 +117 @@
     }
 
-    //¡¡NULLÃͤ¬É¬Íפʾì¹ç
+    //　NULL値が必要な場合
     function setItemTermWithNull( $arr, $ItemStr ) {
 
@@ -124 +124 @@
         if ( $arr ){
             foreach( $arr as $data ) {  
-                if ($data != "ÉÔÌÀ") {
+                if ($data != "不明") {
                     $item .= " OR ${ItemStr} = ?";
                     $return[] = $data;
@@ -135 +135 @@
         return $return;
     }
-    // NULL¤â¤·¤¯¤Ï''¤Ç¸¡º÷¤¹¤ë¾ì¹ç
+    // NULLもしくは''で検索する場合
     function setItemTermWithNullAndSpace( $arr, $ItemStr ) {
         $count = count($arr);
@@ -155 +155 @@
 
 
-    /* Ê£¿ô¤Î¥«¥é¥à¤ÇOR¤ÇÍ¥À踡º÷¤¹¤ë¾ì¹ç¡¡Î㡧¡¡AND ( item_flag1 = xxx OR item_flag2 = xxx OR item_flag3 = xxx  ) AND ... 
-
-        ÇÛÎó¤Î¹½Â¤Îã¡¡
+    /* 複数のカラムでORで優先検索する場合　例：　AND ( item_flag1 = xxx OR item_flag2 = xxx OR item_flag3 = xxx  ) AND ... 
+
+        配列の構造例　
         if ( $_POST['show_site1'] ) $arrShowsite_1 = array( "column" => "show_site1",
                                                             "value"  => $_POST['show_site1'] );