Changeset 18853 for branches/version-2_5-dev/data/class/SC_CustomerList.php

Timestamp:

2010/10/14 16:46:42 (14 years ago)

Author:

Seasoft

Message:

#626(表記の統一性の向上)

• 括弧とスペースの使い方 (途中)
• 名前の補助表記 (途中)

File:

• branches/version-2_5-dev/data/class/SC_CustomerList.php (modified) (17 diffs)

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

@@ -76 +76 @@
         }
 
-        //　名前（カナ）
+        // 名前(カナ)
         if (!isset($this->arrSql['kana'])) $this->arrSql['kana'] = "";
         if ( strlen($this->arrSql['kana']) > 0 ) {
@@ -84 +84 @@
         }
 
-        //　都道府県
+        // 都道府県
         if (!isset($this->arrSql['pref'])) $this->arrSql['pref'] = "";
         if ( strlen($this->arrSql['pref']) > 0 ) {
@@ -91 +91 @@
         }
 
-        //　電話番号
+        // 電話番号
         if (!isset($this->arrSql['tel'])) $this->arrSql['tel'] = "";
         if ( is_numeric( $this->arrSql['tel'] ) ) {
@@ -99 +99 @@
         }
 
-        //性別
+        // 性別
         if (!isset($this->arrSql['sex'])) $this->arrSql['sex'] = "";
         if ( is_array( $this->arrSql['sex'] ) ){
@@ -108 +108 @@
         }
 
-        //職業
+        // 職業
         if (!isset($this->arrSql['job'])) $this->arrSql['job'] = "";
         if ( is_array( $this->arrSql['job'] ) ){
@@ -123 +123 @@
         }
 
-        //　E-MAIL
+        // E-MAIL
         if (!isset($this->arrSql['email'])) $this->arrSql['email'] = "";
         if (strlen($this->arrSql['email']) > 0) {
@@ -151 +151 @@
         }
 
-        //　E-MAIL(mobile)
+        // E-MAIL(mobile)
         if (!isset($this->arrSql['email_mobile'])) $this->arrSql['email_mobile'] = "";
         
@@ -180 +180 @@
         }
 
-        //　配信メールアドレス種別
+        // 配信メールアドレス種別
         if ( $mode == 'magazine' ){
             $sqlEmailMobileIsEmpty = "(dtb_customer.email_mobile IS NULL OR dtb_customer.email_mobile = '')";
@@ -204 +204 @@
         }
 
-        //　HTML-mail
+        // HTML-mail
         if ( $mode == 'magazine' ){
             if (!isset($this->arrSql['htmlmail'])) $this->arrSql['htmlmail'] = "";
@@ -299 +299 @@
         }
 
-        //購入商品コード
+        // 購入商品コード
         if (!isset($this->arrSql['buy_product_code'])) $this->arrSql['buy_product_code'] = "";
         if ( strlen($this->arrSql['buy_product_code']) > 0 ) {
@@ -307 +307 @@
         }
 
-        //購入商品名称
+        // 購入商品名称
         if (!isset($this->arrSql['buy_product_name'])) $this->arrSql['buy_product_name'] = "";
         if ( strlen($this->arrSql['buy_product_name']) > 0 ) {
@@ -315 +315 @@
         }
 
-        //カテゴリーを選択している場合のみ絞込検索を行う
+        // カテゴリーを選択している場合のみ絞込検索を行う
         if (!isset($this->arrSql['category_id'])) $this->arrSql['category_id'] = "";
         if ( strlen($this->arrSql['category_id']) > 0){
-            //カテゴリーで絞込検索を行うSQL文生成
+            // カテゴリーで絞込検索を行うSQL文生成
             list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($this->arrSql['category_id']);
 
-            //カテゴリーで絞込みが可能の場合
+            // カテゴリーで絞込みが可能の場合
             if($tmp_where != "") {
                 $this->setWhere( " customer_id IN (SELECT distinct customer_id FROM dtb_order WHERE order_id IN (SELECT distinct order_id FROM dtb_order_detail WHERE product_id IN (SELECT product_id FROM dtb_product_categories WHERE ".$tmp_where." ))) ");
@@ -327 +327 @@
             }
         }
-        //携帯電話番号
+        // 携帯電話番号
         if (!isset($this->arrSql['cell'])) $this->arrSql['cell'] = "";
         if ( is_numeric( $this->arrSql['cell'] ) ) {
@@ -335 +335 @@
         }
 
-        //キャンペーン
+        // キャンペーン
         if (!isset($this->arrSql['campaign_id'])) $this->arrSql['campaign_id'] = "";
         if ( is_numeric( $this->arrSql['campaign_id'] ) ) {
@@ -342 +342 @@
         }
 
-        //会員状態
+        // 会員状態
         if (!isset($this->arrSql['status'])) $this->arrSql['status'] = "";
         if ( is_array( $this->arrSql['status'] ) ){
@@ -395 +395 @@
     }
 
-    //　検索総数カウント用SQL
+    // 検索総数カウント用SQL
     function getListCount() {
         $this->select = "SELECT COUNT(customer_id) FROM dtb_customer ";
@@ -401 +401 @@
     }
 
-    //　CSVダウンロード用SQL
+    // CSVダウンロード用SQL
     function getListCSV($arrColumnCSV) {
         $this->arrColumnCSV = $arrColumnCSV;