Changeset 13916

Timestamp:

2007/05/31 17:12:55 (17 years ago)

Author:

matsumoto

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

@@ -201 +201 @@
  *      }
  */
-        //¥É¥á¥¤¥ó»ØÄê
-        if ( $mode == 'magazine' ){
+        if($mode == 'magazine'){
             global $arrDomainType;
             $sql_where = "";
-            $domain = $this->arrSql['domain'];
-            foreach($arrDomainType as $val) {
-            //PC¥É¥á¥¤¥ó
-                if($domain == 2) {
-                    if($sql_where == "") {
-                        $sql_where .= "dtb_customer.email NOT ILIKE ? ";
-                    } else {
-                        $sql_where .= "AND dtb_customer.email NOT LIKE ? " ;
-                    }
-                }
-            //·ÈÂӥɥᥤ¥ó
-                if($domain == 3) {
-                    if($sql_where == "") {
-                        $sql_where .= "dtb_customer.email ILIKE ? ";
-                    } else {
-                        $sql_where .= "OR dtb_customer.email LIKE ? " ;
-                    }
-                }
-                $this->arrVal[] = $this->addSearchStr($val);
-            }
-            $this->setWhere($sql_where);
-        }  
+            $domain = ($this->arrSql['domai']);
+            //¥É¥á¥¤¥ó»ØÄê»þ
+            if($domain == 2 || $domain == 3) {
+                foreach($arrDomainType as $val) {
+                    //PC¥É¥á¥¤¥ó
+                    if($domain == 2) {
+                        if($sql_where == "") {
+                            $sql_where .= "dtb_customer.email NOT ILIKE ? ";
+                        } else {
+                            $sql_where .= "AND dtb_customer.email NOT LIKE ? " ;
+                        }
+                    }
+                    //·ÈÂӥɥᥤ¥ó
+                    if($domain == 3) {
+                        if($sql_where == "") {
+                            $sql_where .= "dtb_customer.email ILIKE ? ";
+                        } else {
+                            $sql_where .= "OR dtb_customer.email LIKE ? " ;
+                        }
+                    }
+                    $this->arrVal[] = $this->addSearchStr($val);
+                }
+                $this->setWhere($sql_where);
+            }
+        }
 
         //¡¡HTML-mail¡ÊÇÛ¿®Êý¼°)
-        if ( $mode == 'magazine' ){
+        if( $mode == 'magazine' ){
             if ( strlen($this->arrSql['htmlmail']) > 0 ) {
                 $this->setWhere( " mailmaga_flg = ? ");