Changeset 11771 for branches/dev/data/class/SC_CustomerList.php

Timestamp:

2007/03/12 11:57:26 (19 years ago)

Author:

uehara

Message:

 

File:

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

branches/dev/data/class/SC_CustomerList.php

@@ -164 +164 @@
             $this->setWhere($sql_where);
         }
-        
+
+        //¡¡E-MAIL(mobile)
+        if (strlen($this->arrSql['email_mobile']) > 0) {
+            //¥«¥ó¥Þ¶èÀÚ¤ê¤ÇÊ£¿ô¤Î¾ò·ï»ØÄê²Äǽ¤Ë
+            $this->arrSql['email_mobile'] = explode(",", $this->arrSql['email_mobile']);
+            $sql_where = "";
+            foreach($this->arrSql['email_mobile'] as $val) {
+                $val = trim($val);
+                //¸¡º÷¾ò·ï¤ò´Þ¤Þ¤Ê¤¤
+                if($this->arrSql['not_email_mobileinc'] == '1') {
+                    if($sql_where == "") {
+                        $sql_where .= "dtb_customer.email_mobile NOT ILIKE ? ";
+                    } else {
+                        $sql_where .= "AND dtb_customer.email_mobile NOT ILIKE ? ";
+                    }
+                } else {                
+                    if($sql_where == "") {
+                        $sql_where .= "dtb_customer.email_mobile ILIKE ? ";
+                    } else {
+                        $sql_where .= "OR dtb_customer.email_mobile ILIKE ? ";
+                    }
+                }
+                $searchemail_mobile = $this->addSearchStr($val);
+                $this->arrVal[] = $searchemail_mobile;
+            }
+            $this->setWhere($sql_where);
+        }
+                
         //¡¡ÇÛ¿®¥á¡¼¥ë¥¢¥É¥ì¥¹¼ïÊÌ
         if ( $mode == 'magazine' ){