Changeset 18007 for branches/version-2/data/class/SC_CustomerList.php

Timestamp:

2009/05/15 16:30:40 (15 years ago)

Author:

kajiwara

Message:

2.4.0 正式版のコミット。コミット内容の詳細はこちら（http://svn.ec-cube.net/open_trac/query?status=closed&milestone=EC-CUBE2.4.0）

File:

• branches/version-2/data/class/SC_CustomerList.php (modified) (5 diffs)

branches/version-2/data/class/SC_CustomerList.php

@@ -28 +28 @@
 
     var $arrColumnCSV;
-            
+
     function SC_CustomerList($array, $mode = '') {
         parent::SC_SelectSql($array);
-        
+
         $masterData = new SC_DB_MasterData_Ex();
         $arrMobileDomain = $masterData->getMasterData("mtb_mobile_domain");
-        
+
         $objDb = new SC_Helper_DB_Ex();
 
@@ -46 +46 @@
         if($mode == "customer") {
             // 管理者ページ顧客検索の場合仮登録会員も検索
-            $this->setWhere( "(status = 1 OR status = 2) AND del_flg = 0 ");
+            //$this->setWhere( "(status = 1 OR status = 2) AND del_flg = 0 ");
+            $this->setWhere( " del_flg = 0 ");
             // 登録日を示すカラム
             $regdate_col = 'dtb_customer.update_date';
@@ -164 +165 @@
         //　E-MAIL(mobile)
         if (!isset($this->arrSql['email_mobile'])) $this->arrSql['email_mobile'] = "";
-        
+
         if (strlen($this->arrSql['email_mobile']) > 0) {
             //カンマ区切りで複数の条件指定可能に
@@ -196 +197 @@
             // PCサイトメールが指定されている場合
             if ( strlen($this->arrSql['mail_type']) > 0 && $this->arrSql['mail_type'] == 1) {
-                // 携帯ドメインを外す。
-                foreach($arrMobileDomain as $mobile_domain) {
-                    $this->setWhere(" dtb_customer.email NOT ILIKE '%$mobile_domain' ");                    
-                }
+                // 携帯ドメインを外す。
+                foreach($arrMobileDomain as $mobile_domain) {
+                    $this->setWhere(" dtb_customer.email NOT ILIKE '%$mobile_domain' ");
+                }
             // 携帯サイトメールが指定されている場合
             } else if( strlen($this->arrSql['mail_type']) > 0 && $this->arrSql['mail_type'] == 2) {
-                $this->setWhere( " dtb_customer.email_mobile <> ''  ");
+                $this->setWhere( " dtb_customer.email_mobile <> ''  ");
             }
         }
@@ -344 +345 @@
         }
 
+        //会員状態
+        if (!isset($this->arrSql['status'])) $this->arrSql['status'] = "";
+        if ( is_array( $this->arrSql['status'] ) ){
+            $arrStatusVal = $this->setItemTerm( $this->arrSql['status'] ,"status" );
+            foreach ($arrStatusVal as $data) {
+                $this->arrVal[] = $data;
+            }
+        }
         $this->setOrder( "customer_id DESC" );
     }