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

Timestamp:

2012/02/06 21:27:04 (12 years ago)

Author:

Seasoft

Message:

#1613 (ソース整形・ソースコメントの改善)

• 無意味なスペースを削除

File:

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

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

@@ -53 +53 @@
         if (!isset($this->arrSql['search_customer_id'])) $this->arrSql['search_customer_id'] = "";
         if (strlen($this->arrSql['search_customer_id']) > 0) {
-            $this->setWhere( "customer_id =  ?" );
+            $this->setWhere( "customer_id =  ?");
             $this->arrVal[] = $this->arrSql['search_customer_id'];
         }
@@ -60 +60 @@
         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);
@@ -68 +68 @@
         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);
@@ -76 +76 @@
         if (!isset($this->arrSql['search_pref'])) $this->arrSql['search_pref'] = "";
         if (strlen($this->arrSql['search_pref']) > 0) {
-            $this->setWhere( "pref = ?" );
+            $this->setWhere( "pref = ?");
             $this->arrVal[] = $this->arrSql['search_pref'];
         }
@@ -82 +82 @@
         // 電話番号
         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 ?)" );
+        if (is_numeric( $this->arrSql['search_tel'])) {
+            $this->setWhere("(" . $dbFactory->concatColumn(array("tel01", "tel02", "tel03")) . " LIKE ?)");
             $searchTel = $this->addSearchStr($this->arrSql['search_tel']);
             $this->arrVal[] = ereg_replace("-", "", $searchTel);
@@ -90 +90 @@
         // 性別
         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' );
+        if (is_array( $this->arrSql['search_sex'])) {
+            $arrSexVal = $this->setItemTerm( $this->arrSql['search_sex'] ,'sex');
             foreach ($arrSexVal as $data) {
                 $this->arrVal[] = $data;
@@ -99 +99 @@
         // 職業
         if (!isset($this->arrSql['search_job'])) $this->arrSql['search_job'] = "";
-        if (is_array( $this->arrSql['search_job'] )) {
-            if (in_array("不明", $this->arrSql['search_job'] )) {
-                $arrJobVal = $this->setItemTermWithNull( $this->arrSql['search_job'] ,'job' );
+        if (is_array( $this->arrSql['search_job'])) {
+            if (in_array("不明", $this->arrSql['search_job'])) {
+                $arrJobVal = $this->setItemTermWithNull( $this->arrSql['search_job'] ,'job');
             } else {
-                $arrJobVal = $this->setItemTerm( $this->arrSql['search_job'] ,'job' );
+                $arrJobVal = $this->setItemTerm( $this->arrSql['search_job'] ,'job');
             }
             if (is_array($arrJobVal)) {
@@ -211 +211 @@
         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"] )) {
+        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");
             foreach ($arrBuyTotal as $data) {
@@ -221 +221 @@
         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"] )) {
+        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");
             foreach ($arrBuyTimes as $data) {
@@ -259 +259 @@
         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) ) {
+        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)) {
 
             $arrRegistTime = $this->selectTermRange($this->arrSql['search_start_year'], $this->arrSql['search_start_month'], $this->arrSql['search_start_day']
@@ -277 +277 @@
         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 ) ||
-                (strlen($this->arrSql['search_buy_end_year']) > 0 && strlen($this->arrSql['search_buy_end_month']) >0 && strlen($this->arrSql['search_buy_end_day']) > 0) ) {
+        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) ||
+                (strlen($this->arrSql['search_buy_end_year']) > 0 && strlen($this->arrSql['search_buy_end_month']) >0 && strlen($this->arrSql['search_buy_end_day']) > 0)) {
             $arrRegistTime = $this->selectTermRange($this->arrSql['search_buy_start_year'], $this->arrSql['search_buy_start_month'], $this->arrSql['search_buy_start_day']
                             , $this->arrSql['search_buy_end_year'], $this->arrSql['search_buy_end_month'], $this->arrSql['search_buy_end_day'], "last_buy_date");
@@ -289 +289 @@
         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)");
+            $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)");
             $search_buyproduct_code = $this->addSearchStr($this->arrSql['search_buy_product_code']);
             $this->arrVal[] = $search_buyproduct_code;
@@ -297 +297 @@
         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)");
+            $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)");
             $search_buyproduct_name = $this->addSearchStr($this->arrSql['search_buy_product_name']);
             $this->arrVal[] = $search_buyproduct_name;
@@ -310 +310 @@
             // カテゴリで絞込みが可能の場合
             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." ) AND del_flg = 0)) ");
+                $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.") AND del_flg = 0)) ");
                 $this->arrVal = array_merge((array)$this->arrVal, (array)$tmp_arrval);
             }
@@ -317 +317 @@
         // 会員状態
         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' );
+        if (is_array( $this->arrSql['search_status'])) {
+            $arrStatusVal = $this->setItemTerm( $this->arrSql['search_status'] ,'status');
             foreach ($arrStatusVal as $data) {
                 $this->arrVal[] = $data;
@@ -324 +324 @@
         }
 
-        $this->setOrder( "customer_id DESC" );
+        $this->setOrder( "customer_id DESC");
     }