- Timestamp:
- 2012/02/06 11:27:03 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/SC_CustomerList.php
r21441 r21442 52 52 // 会員ID 53 53 if (!isset($this->arrSql['search_customer_id'])) $this->arrSql['search_customer_id'] = ""; 54 if (strlen($this->arrSql['search_customer_id']) > 0 54 if (strlen($this->arrSql['search_customer_id']) > 0) { 55 55 $this->setWhere( "customer_id = ?" ); 56 56 $this->arrVal[] = $this->arrSql['search_customer_id']; … … 59 59 // 名前 60 60 if (!isset($this->arrSql['search_name'])) $this->arrSql['search_name'] = ""; 61 if (strlen($this->arrSql['search_name']) > 0 61 if (strlen($this->arrSql['search_name']) > 0) { 62 62 $this->setWhere("(" . $dbFactory->concatColumn(array("name01", "name02")) . " LIKE ?)" ); 63 63 $searchName = $this->addSearchStr($this->arrSql['search_name']); … … 67 67 // 名前(フリガナ) 68 68 if (!isset($this->arrSql['search_kana'])) $this->arrSql['search_kana'] = ""; 69 if (strlen($this->arrSql['search_kana']) > 0 69 if (strlen($this->arrSql['search_kana']) > 0) { 70 70 $this->setWhere("(" . $dbFactory->concatColumn(array("kana01", "kana02")) . " LIKE ?)" ); 71 71 $searchKana = $this->addSearchStr($this->arrSql['search_kana']); … … 75 75 // 都道府県 76 76 if (!isset($this->arrSql['search_pref'])) $this->arrSql['search_pref'] = ""; 77 if (strlen($this->arrSql['search_pref']) > 0 77 if (strlen($this->arrSql['search_pref']) > 0) { 78 78 $this->setWhere( "pref = ?" ); 79 79 $this->arrVal[] = $this->arrSql['search_pref']; … … 82 82 // 電話番号 83 83 if (!isset($this->arrSql['search_tel'])) $this->arrSql['search_tel'] = ""; 84 if (is_numeric( $this->arrSql['search_tel'] ) 84 if (is_numeric( $this->arrSql['search_tel'] )) { 85 85 $this->setWhere("(" . $dbFactory->concatColumn(array("tel01", "tel02", "tel03")) . " LIKE ?)" ); 86 86 $searchTel = $this->addSearchStr($this->arrSql['search_tel']); … … 90 90 // 性別 91 91 if (!isset($this->arrSql['search_sex'])) $this->arrSql['search_sex'] = ""; 92 if (is_array( $this->arrSql['search_sex'] ) 92 if (is_array( $this->arrSql['search_sex'] )) { 93 93 $arrSexVal = $this->setItemTerm( $this->arrSql['search_sex'] ,'sex' ); 94 94 foreach ($arrSexVal as $data) { … … 99 99 // 職業 100 100 if (!isset($this->arrSql['search_job'])) $this->arrSql['search_job'] = ""; 101 if (is_array( $this->arrSql['search_job'] ) 102 if (in_array("不明", $this->arrSql['search_job'] ) 101 if (is_array( $this->arrSql['search_job'] )) { 102 if (in_array("不明", $this->arrSql['search_job'] )) { 103 103 $arrJobVal = $this->setItemTermWithNull( $this->arrSql['search_job'] ,'job' ); 104 104 } else { … … 184 184 185 185 // 配信メールアドレス種別 186 if ($mode == 'customer' 186 if ($mode == 'customer') { 187 187 if (isset($this->arrSql['search_mail_type'])) { 188 188 $sqlEmailMobileIsEmpty = "(dtb_customer.email_mobile IS NULL OR dtb_customer.email_mobile = '')"; … … 211 211 if (!isset($this->arrSql['search_buy_total_from'])) $this->arrSql['search_buy_total_from'] = ""; 212 212 if (!isset($this->arrSql['search_buy_total_to'])) $this->arrSql['search_buy_total_to'] = ""; 213 if (is_numeric( $this->arrSql["search_buy_total_from"] ) || is_numeric( $this->arrSql["search_buy_total_to"] ) 213 if (is_numeric( $this->arrSql["search_buy_total_from"] ) || is_numeric( $this->arrSql["search_buy_total_to"] )) { 214 214 $arrBuyTotal = $this->selectRange($this->arrSql["search_buy_total_from"], $this->arrSql["search_buy_total_to"], "buy_total"); 215 215 foreach ($arrBuyTotal as $data) { … … 221 221 if (!isset($this->arrSql['search_buy_times_from'])) $this->arrSql['search_buy_times_from'] = ""; 222 222 if (!isset($this->arrSql['search_buy_times_to'])) $this->arrSql['search_buy_times_to'] = ""; 223 if (is_numeric( $this->arrSql["search_buy_times_from"] ) || is_numeric( $this->arrSql["search_buy_times_to"] ) 223 if (is_numeric( $this->arrSql["search_buy_times_from"] ) || is_numeric( $this->arrSql["search_buy_times_to"] )) { 224 224 $arrBuyTimes = $this->selectRange($this->arrSql["search_buy_times_from"], $this->arrSql["search_buy_times_to"], "buy_times"); 225 225 foreach ($arrBuyTimes as $data) { … … 288 288 // 購入商品コード 289 289 if (!isset($this->arrSql['search_buy_product_code'])) $this->arrSql['search_buy_product_code'] = ""; 290 if (strlen($this->arrSql['search_buy_product_code']) > 0 290 if (strlen($this->arrSql['search_buy_product_code']) > 0) { 291 291 $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)"); 292 292 $search_buyproduct_code = $this->addSearchStr($this->arrSql['search_buy_product_code']); … … 296 296 // 購入商品名称 297 297 if (!isset($this->arrSql['search_buy_product_name'])) $this->arrSql['search_buy_product_name'] = ""; 298 if (strlen($this->arrSql['search_buy_product_name']) > 0 298 if (strlen($this->arrSql['search_buy_product_name']) > 0) { 299 299 $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)"); 300 300 $search_buyproduct_name = $this->addSearchStr($this->arrSql['search_buy_product_name']); … … 317 317 // 会員状態 318 318 if (!isset($this->arrSql['search_status'])) $this->arrSql['search_status'] = ""; 319 if (is_array( $this->arrSql['search_status'] ) 319 if (is_array( $this->arrSql['search_status'] )) { 320 320 $arrStatusVal = $this->setItemTerm( $this->arrSql['search_status'] ,'status' ); 321 321 foreach ($arrStatusVal as $data) {
Note: See TracChangeset
for help on using the changeset viewer.