Changeset 224 for branches/dev/data

Timestamp:

2007/02/09 19:39:56 (19 years ago)

Author:

kakinaka

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (2 diffs)

branches/dev/data/class/SC_CustomerList.php

@@ -90 +90 @@
         //¡¡Ì¾Á°¡Ê¥«¥Ê¡Ë
         if ( strlen($this->arrSql['kana']) > 0 ) {
-            $this->setWhere("(kana01 || kana02 LIKE ?)");
+            if(DB_TYPE == "pgsql"){
+                $this->setWhere("(kana01 || kana02 LIKE ?)");
+            }elseif(DB_TYPE == "mysql"){
+                $this->setWhere("concat(kana01,kana02) LIKE ?" );
+            }
             $searchKana = $this->addSearchStr($this->arrSql['kana']);
             $this->arrVal[] = mb_ereg_replace("[ ¡¡]+","",$searchKana);
@@ -103 +107 @@
         //¡¡ÅÅÏÃÈÖ¹æ
         if ( is_numeric( $this->arrSql['tel'] ) ) {
-            $this->setWhere( "(tel01 || tel02 || tel03 LIKE ?)" );
+            if(DB_TYPE == "pgsql"){
+                $this->setWhere( "(tel01 || tel02 || tel03 LIKE ?)" );
+            }elseif(DB_TYPE == "mysql"){
+                $this->setWhere("concat(tel01,tel02,tel03) LIKE ?" );
+            }
             $searchTel = $this->addSearchStr($this->arrSql['tel']);
             $this->arrVal[] = ereg_replace("-", "", $searchTel);