Index: branches/dev/data/class/SC_CustomerList.php
===================================================================
--- branches/dev/data/class/SC_CustomerList.php	(revision 12497)
+++ branches/dev/data/class/SC_CustomerList.php	(revision 12498)
@@ -209,34 +209,49 @@
                       4 => "vodafone.ne.jp"
                   );
-        	foreach($arrDomainType as $val) {
-        	    $domain = ($this->arrSql['domain']);
-        	    //¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó»ØÄê
-        	    if($domain==3){
-        		    if($this->arrSql['mail_type']==1){
-        		    	if($sql_where == "") {
-        		    		$sql_where = "dtb_customer.email ILIKE ? ";
-        		    	} else {
+            $domain = ($this->arrSql['domain']);
+            //¥É¥á¥¤¥ó»ØÄê»þ
+            if($domain == 2 || $domain == 3) {
+            	//PC¥É¥á¥¤¥ó
+            	if($domain == 2) {
+	            	foreach($arrDomainType as $val) { 
+	        		    if($this->arrSql['mail_type']==1 ){
+	            	        if($sql_where == "") {
+        		    		$sql_where .= "dtb_customer.email NOT ILIKE ? ";
+        		    	    } else {
+            	            $sql_where .= "AND dtb_customer.email NOT LIKE ? " ;
+        		    	    }
+	        	    	}elseif($this->arrSql['mail_type']==2){
+	        		        if($sql_where == "") {
+        		    		$sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
+        		    	    } else {
+            	            $sql_where .= "AND dtb_customer.email _mobile NOT LIKE ? " ;
+        		    	    }
+	        		    }
+		        	    $searchDomain = $this->addSearchStr($val);
+		        	    $this->arrVal[] = $searchDomain;
+		            }
+            	}
+            	//¥â¥Ð¥¤¥ë¥É¥á¥¤¥ó
+            	if($domain == 3) {
+	            	foreach($arrDomainType as $val) { 
+	        		    if($this->arrSql['mail_type']==1 ){
+	            	        if($sql_where == "") {
+        		    		$sql_where .= "dtb_customer.email ILIKE ? ";
+        		    	    } else {
             	            $sql_where .= "OR dtb_customer.email LIKE ? " ;
-        		    	}
-	        	    }elseif($this->arrSql['mail_type']==2){
-	        		       $sql_where .= "OR dtb_customer.email_mobile LIKE ? " ;
-        	        }
-        	    }
-        	    //£Ð£Ã¥É¥á¥¤¥ó»ØÄê
-        	    if($domain==2){
-        		    if($this->arrSql['mail_type']==1){
-            	        $sql_where .= "AND email NOT LIKE ? " ;
-        	    }elseif($this->arrSql['mail_type']==2){
-        		        $sql_where .= "AND email_mobile NOT LIKE ? " ;
-        	        }
-        	    }
-        	    $searchDomain = $this->addSearchStr($val);
-        	    $this->arrVal[] = $searchDomain;
-            }
-            print_r($searchDomain);
-            $this->setWhere($sql_where);
-        }
-        
-        
+        		    	    }
+	        	    	}elseif($this->arrSql['mail_type']==2){
+	        		        if($sql_where == "") {
+        		    		$sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
+        		    	    } else {
+            	            $sql_where .= "OR dtb_customer.email _mobile NOT LIKE ? " ;
+        		    	    }
+	        		    }
+		        	    $searchDomain = $this->addSearchStr($val);
+		        	    $this->arrVal[] = $searchDomain;
+		            }
+            	}
+                        print_r($searchDomain);
+            }  
 print_r($this->arrSql);
 print_r($this->arrVal);