Changeset 21515 for branches/version-2_12-dev/data/class/SC_CustomerList.php

Timestamp:

2012/02/15 20:18:09 (15 years ago)

Author:

Seasoft

Message:

#1625 (typo修正・ソース整形・ソースコメントの改善)

File:

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

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

@@ -51 +51 @@
 
         // 会員ID
-        if (!isset($this->arrSql['search_customer_id'])) $this->arrSql['search_customer_id'] = "";
+        if (!isset($this->arrSql['search_customer_id'])) $this->arrSql['search_customer_id'] = '';
         if (strlen($this->arrSql['search_customer_id']) > 0) {
             $this->setWhere('customer_id =  ?');
@@ -58 +58 @@
 
         // 名前
-        if (!isset($this->arrSql['search_name'])) $this->arrSql['search_name'] = "";
+        if (!isset($this->arrSql['search_name'])) $this->arrSql['search_name'] = '';
         if (strlen($this->arrSql['search_name']) > 0) {
-            $this->setWhere('(' . $dbFactory->concatColumn(array('name01', 'name02')) . " LIKE ?)");
+            $this->setWhere('(' . $dbFactory->concatColumn(array('name01', 'name02')) . ' LIKE ?)');
             $searchName = $this->addSearchStr($this->arrSql['search_name']);
             $this->arrVal[] = mb_ereg_replace('[ 　]+','',$searchName);
@@ -66 +66 @@
 
         // 名前(フリガナ)
-        if (!isset($this->arrSql['search_kana'])) $this->arrSql['search_kana'] = "";
+        if (!isset($this->arrSql['search_kana'])) $this->arrSql['search_kana'] = '';
         if (strlen($this->arrSql['search_kana']) > 0) {
-            $this->setWhere('(' . $dbFactory->concatColumn(array('kana01', 'kana02')) . " LIKE ?)");
+            $this->setWhere('(' . $dbFactory->concatColumn(array('kana01', 'kana02')) . ' LIKE ?)');
             $searchKana = $this->addSearchStr($this->arrSql['search_kana']);
             $this->arrVal[] = mb_ereg_replace('[ 　]+','',$searchKana);
@@ -74 +74 @@
 
         // 都道府県
-        if (!isset($this->arrSql['search_pref'])) $this->arrSql['search_pref'] = "";
+        if (!isset($this->arrSql['search_pref'])) $this->arrSql['search_pref'] = '';
         if (strlen($this->arrSql['search_pref']) > 0) {
             $this->setWhere('pref = ?');
@@ -81 +81 @@
 
         // 電話番号
-        if (!isset($this->arrSql['search_tel'])) $this->arrSql['search_tel'] = "";
+        if (!isset($this->arrSql['search_tel'])) $this->arrSql['search_tel'] = '';
         if (is_numeric($this->arrSql['search_tel'])) {
-            $this->setWhere('(' . $dbFactory->concatColumn(array('tel01', 'tel02', 'tel03')) . " LIKE ?)");
+            $this->setWhere('(' . $dbFactory->concatColumn(array('tel01', 'tel02', 'tel03')) . ' LIKE ?)');
             $searchTel = $this->addSearchStr($this->arrSql['search_tel']);
             $this->arrVal[] = ereg_replace('-', '', $searchTel);
@@ -89 +89 @@
 
         // 性別
-        if (!isset($this->arrSql['search_sex'])) $this->arrSql['search_sex'] = "";
+        if (!isset($this->arrSql['search_sex'])) $this->arrSql['search_sex'] = '';
         if (is_array($this->arrSql['search_sex'])) {
             $arrSexVal = $this->setItemTerm($this->arrSql['search_sex'] ,'sex');
@@ -98 +98 @@
 
         // 職業
-        if (!isset($this->arrSql['search_job'])) $this->arrSql['search_job'] = "";
+        if (!isset($this->arrSql['search_job'])) $this->arrSql['search_job'] = '';
         if (is_array($this->arrSql['search_job'])) {
             if (in_array('不明', $this->arrSql['search_job'])) {
@@ -113 +113 @@
 
         // E-MAIL
-        if (!isset($this->arrSql['search_email'])) $this->arrSql['search_email'] = "";
+        if (!isset($this->arrSql['search_email'])) $this->arrSql['search_email'] = '';
         if (strlen($this->arrSql['search_email']) > 0) {
             //カンマ区切りで複数の条件指定可能に
@@ -141 +141 @@
 
         // E-MAIL(mobile)
-        if (!isset($this->arrSql['search_email_mobile'])) $this->arrSql['search_email_mobile'] = "";
+        if (!isset($this->arrSql['search_email_mobile'])) $this->arrSql['search_email_mobile'] = '';
 
         if (strlen($this->arrSql['search_email_mobile']) > 0) {
@@ -209 +209 @@
 
         // 購入金額指定
-        if (!isset($this->arrSql['search_buy_total_from'])) $this->arrSql['search_buy_total_from'] = "";
-        if (!isset($this->arrSql['search_buy_total_to'])) $this->arrSql['search_buy_total_to'] = "";
+        if (!isset($this->arrSql['search_buy_total_from'])) $this->arrSql['search_buy_total_from'] = '';
+        if (!isset($this->arrSql['search_buy_total_to'])) $this->arrSql['search_buy_total_to'] = '';
         if (is_numeric($this->arrSql['search_buy_total_from']) || is_numeric($this->arrSql['search_buy_total_to'])) {
             $arrBuyTotal = $this->selectRange($this->arrSql['search_buy_total_from'], $this->arrSql['search_buy_total_to'], 'buy_total');
@@ -219 +219 @@
 
         // 購入回数指定
-        if (!isset($this->arrSql['search_buy_times_from'])) $this->arrSql['search_buy_times_from'] = "";
-        if (!isset($this->arrSql['search_buy_times_to'])) $this->arrSql['search_buy_times_to'] = "";
+        if (!isset($this->arrSql['search_buy_times_from'])) $this->arrSql['search_buy_times_from'] = '';
+        if (!isset($this->arrSql['search_buy_times_to'])) $this->arrSql['search_buy_times_to'] = '';
         if (is_numeric($this->arrSql['search_buy_times_from']) || is_numeric($this->arrSql['search_buy_times_to'])) {
             $arrBuyTimes = $this->selectRange($this->arrSql['search_buy_times_from'], $this->arrSql['search_buy_times_to'], 'buy_times');
@@ -229 +229 @@
 
         // 誕生日期間指定
-        if (!isset($this->arrSql['search_b_start_year'])) $this->arrSql['search_b_start_year'] = "";
-        if (!isset($this->arrSql['search_b_start_month'])) $this->arrSql['search_b_start_month'] = "";
-        if (!isset($this->arrSql['search_b_start_day'])) $this->arrSql['search_b_start_day'] = "";
-        if (!isset($this->arrSql['search_b_end_year'])) $this->arrSql['search_b_end_year'] = "";
-        if (!isset($this->arrSql['search_b_end_month'])) $this->arrSql['search_b_end_month'] = "";
-        if (!isset($this->arrSql['search_b_end_day'])) $this->arrSql['search_b_end_day'] = "";
+        if (!isset($this->arrSql['search_b_start_year'])) $this->arrSql['search_b_start_year'] = '';
+        if (!isset($this->arrSql['search_b_start_month'])) $this->arrSql['search_b_start_month'] = '';
+        if (!isset($this->arrSql['search_b_start_day'])) $this->arrSql['search_b_start_day'] = '';
+        if (!isset($this->arrSql['search_b_end_year'])) $this->arrSql['search_b_end_year'] = '';
+        if (!isset($this->arrSql['search_b_end_month'])) $this->arrSql['search_b_end_month'] = '';
+        if (!isset($this->arrSql['search_b_end_day'])) $this->arrSql['search_b_end_day'] = '';
         if ( (strlen($this->arrSql['search_b_start_year']) > 0 && strlen($this->arrSql['search_b_start_month']) > 0 && strlen($this->arrSql['search_b_start_day']) > 0) ||
               strlen($this->arrSql['search_b_end_year']) > 0 && strlen($this->arrSql['search_b_end_month']) > 0 && strlen($this->arrSql['search_b_end_day']) > 0) {
@@ -246 +246 @@
 
         // 誕生月の検索
-        if (!isset($this->arrSql['search_birth_month'])) $this->arrSql['search_birth_month'] = "";
+        if (!isset($this->arrSql['search_birth_month'])) $this->arrSql['search_birth_month'] = '';
         if (is_numeric($this->arrSql['search_birth_month'])) {
             $this->setWhere(' EXTRACT(month from birth) = ?');
@@ -253 +253 @@
 
         // 登録期間指定
-        if (!isset($this->arrSql['search_start_year'])) $this->arrSql['search_start_year'] = "";
-        if (!isset($this->arrSql['search_start_month'])) $this->arrSql['search_start_month'] = "";
-        if (!isset($this->arrSql['search_start_day'])) $this->arrSql['search_start_day'] = "";
-        if (!isset($this->arrSql['search_end_year'])) $this->arrSql['search_end_year'] = "";
-        if (!isset($this->arrSql['search_end_month'])) $this->arrSql['search_end_month'] = "";
-        if (!isset($this->arrSql['search_end_day'])) $this->arrSql['search_end_day'] = "";
+        if (!isset($this->arrSql['search_start_year'])) $this->arrSql['search_start_year'] = '';
+        if (!isset($this->arrSql['search_start_month'])) $this->arrSql['search_start_month'] = '';
+        if (!isset($this->arrSql['search_start_day'])) $this->arrSql['search_start_day'] = '';
+        if (!isset($this->arrSql['search_end_year'])) $this->arrSql['search_end_year'] = '';
+        if (!isset($this->arrSql['search_end_month'])) $this->arrSql['search_end_month'] = '';
+        if (!isset($this->arrSql['search_end_day'])) $this->arrSql['search_end_day'] = '';
         if ( (strlen($this->arrSql['search_start_year']) > 0 && strlen($this->arrSql['search_start_month']) > 0 && strlen($this->arrSql['search_start_day']) > 0) ||
                 (strlen($this->arrSql['search_end_year']) > 0 && strlen($this->arrSql['search_end_month']) >0 && strlen($this->arrSql['search_end_day']) > 0)) {
@@ -270 +270 @@
 
         // 最終購入日指定
-        if (!isset($this->arrSql['search_buy_start_year'])) $this->arrSql['search_buy_start_year'] = "";
-        if (!isset($this->arrSql['search_buy_start_month'])) $this->arrSql['search_buy_start_month'] = "";
-        if (!isset($this->arrSql['search_buy_start_day'])) $this->arrSql['search_buy_start_day'] = "";
-        if (!isset($this->arrSql['search_buy_end_year'])) $this->arrSql['search_buy_end_year'] = "";
-        if (!isset($this->arrSql['search_buy_end_month'])) $this->arrSql['search_buy_end_month'] = "";
-        if (!isset($this->arrSql['search_buy_end_day'])) $this->arrSql['search_buy_end_day'] = "";
+        if (!isset($this->arrSql['search_buy_start_year'])) $this->arrSql['search_buy_start_year'] = '';
+        if (!isset($this->arrSql['search_buy_start_month'])) $this->arrSql['search_buy_start_month'] = '';
+        if (!isset($this->arrSql['search_buy_start_day'])) $this->arrSql['search_buy_start_day'] = '';
+        if (!isset($this->arrSql['search_buy_end_year'])) $this->arrSql['search_buy_end_year'] = '';
+        if (!isset($this->arrSql['search_buy_end_month'])) $this->arrSql['search_buy_end_month'] = '';
+        if (!isset($this->arrSql['search_buy_end_day'])) $this->arrSql['search_buy_end_day'] = '';
 
         if ( (strlen($this->arrSql['search_buy_start_year']) > 0 && strlen($this->arrSql['search_buy_start_month']) > 0 && strlen($this->arrSql['search_buy_start_day']) > 0) ||
@@ -287 +287 @@
 
         // 購入商品コード
-        if (!isset($this->arrSql['search_buy_product_code'])) $this->arrSql['search_buy_product_code'] = "";
+        if (!isset($this->arrSql['search_buy_product_code'])) $this->arrSql['search_buy_product_code'] = '';
         if (strlen($this->arrSql['search_buy_product_code']) > 0) {
             $this->setWhere('customer_id IN (SELECT customer_id FROM dtb_order WHERE order_id IN (SELECT order_id FROM dtb_order_detail WHERE product_code LIKE ?) AND del_flg = 0)');
@@ -295 +295 @@
 
         // 購入商品名称
-        if (!isset($this->arrSql['search_buy_product_name'])) $this->arrSql['search_buy_product_name'] = "";
+        if (!isset($this->arrSql['search_buy_product_name'])) $this->arrSql['search_buy_product_name'] = '';
         if (strlen($this->arrSql['search_buy_product_name']) > 0) {
             $this->setWhere('customer_id IN (SELECT customer_id FROM dtb_order WHERE order_id IN (SELECT order_id FROM dtb_order_detail WHERE product_name LIKE ?) AND del_flg = 0)');
@@ -303 +303 @@
 
         // カテゴリを選択している場合のみ絞込検索を行う
-        if (!isset($this->arrSql['search_category_id'])) $this->arrSql['search_category_id'] = "";
+        if (!isset($this->arrSql['search_category_id'])) $this->arrSql['search_category_id'] = '';
         if (strlen($this->arrSql['search_category_id']) > 0) {
             // カテゴリで絞込検索を行うSQL文生成
@@ -316 +316 @@
 
         // 会員状態
-        if (!isset($this->arrSql['search_status'])) $this->arrSql['search_status'] = "";
+        if (!isset($this->arrSql['search_status'])) $this->arrSql['search_status'] = '';
         if (is_array($this->arrSql['search_status'])) {
             $arrStatusVal = $this->setItemTerm($this->arrSql['search_status'] ,'status');