Changeset 12338

Timestamp:

2007/05/09 11:42:22 (17 years ago)

Author:

matsumoto

Message:

 

File:

• branches/dev/data/class/SC_CustomerList.php (modified) (1 diff)

branches/dev/data/class/SC_CustomerList.php

@@ -200 +200 @@
 
         //¥É¥á¥¤¥ó»ØÄê
-/*        if ( $mode == 'magazine' ){
+        if ( $mode == 'magazine' ){
             if ( strlen($this->arrSql['domain']) > 0 && $this->arrSql['domain'] == 3) {
-¡¡¡¡¡¡¡¡¡¡¡¡    $this->setWhere("(email || email_mobile LIKE ?)" );¡¡¡¡
-            }
+¡¡¡¡¡¡¡¡¡¡¡¡    if(DB_TYPE == "pgsql"){
+                $this->setWhere( "(email || email_mobile LIKE ?)" );
+            }elseif(DB_TYPE == "mysql"){
+                $this->setWhere("concat(email,email_mobile) LIKE ?" );
+            }¡¡¡¡
             $searchDomainType = $this->addSearchStr($this->arrSql['domain_type']);
             $this->arrVal[] = $searchDomaintype;
+            }
             if ( strlen($this->arrSql['domain']) > 0 && $this->arrSql['domain'] == 2) {
-                $this->setWhere("(email || email_mobile NOT LIKE ?)" );
+            if(DB_TYPE == "pgsql"){
+                $this->setWhere( "(email || email_mobile LIKE ?)" );
+            }elseif(DB_TYPE == "mysql"){
+                $this->setWhere("concat(email,email_mobile) LIKE ?" );
             }
             $searchDomainType = $this->addSearchStr($this->arrSql['domain_type']);
             $this->arrVal[] = $searchDomaintype;
+            }
         }
-*/
+
         //¡¡HTML-mail¡ÊÇÛ¿®Êý¼°)
         if ( $mode == 'magazine' ){