- Timestamp:
- 2014/06/03 14:51:51 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/SC_CustomerList.php
r23124 r23503 61 61 $this->setWhere('(' . $dbFactory->concatColumn(array('name01', 'name02')) . ' LIKE ?)'); 62 62 $searchName = $this->addSearchStr($this->arrSql['search_name']); 63 $this->arrVal[] = preg_replace('/[ ]+/u', '',$searchName);63 $this->arrVal[] = preg_replace('/[ ]+/u', '', $searchName); 64 64 } 65 65 … … 69 69 $this->setWhere('(' . $dbFactory->concatColumn(array('kana01', 'kana02')) . ' LIKE ?)'); 70 70 $searchKana = $this->addSearchStr($this->arrSql['search_kana']); 71 $this->arrVal[] = preg_replace('/[ ]+/u', '',$searchKana);71 $this->arrVal[] = preg_replace('/[ ]+/u', '', $searchKana); 72 72 } 73 73 … … 90 90 if (!isset($this->arrSql['search_sex'])) $this->arrSql['search_sex'] = ''; 91 91 if (is_array($this->arrSql['search_sex'])) { 92 $arrSexVal = $this->setItemTerm($this->arrSql['search_sex'] ,'sex');92 $arrSexVal = $this->setItemTerm($this->arrSql['search_sex'], 'sex'); 93 93 foreach ($arrSexVal as $data) { 94 94 $this->arrVal[] = $data; … … 100 100 if (is_array($this->arrSql['search_job'])) { 101 101 if (in_array('不明', $this->arrSql['search_job'])) { 102 $arrJobVal = $this->setItemTermWithNull($this->arrSql['search_job'] ,'job');102 $arrJobVal = $this->setItemTermWithNull($this->arrSql['search_job'], 'job'); 103 103 } else { 104 $arrJobVal = $this->setItemTerm($this->arrSql['search_job'] ,'job');104 $arrJobVal = $this->setItemTerm($this->arrSql['search_job'], 'job'); 105 105 } 106 106 if (is_array($arrJobVal)) { … … 260 260 if ( (strlen($this->arrSql['search_start_year']) > 0 && strlen($this->arrSql['search_start_month']) > 0 && strlen($this->arrSql['search_start_day']) > 0) || 261 261 (strlen($this->arrSql['search_end_year']) > 0 && strlen($this->arrSql['search_end_month']) >0 && strlen($this->arrSql['search_end_day']) > 0)) { 262 $arrRegistTime = $this->selectTermRange($this->arrSql['search_start_year'], $this->arrSql['search_start_month'], $this->arrSql['search_start_day'] 263 ,$this->arrSql['search_end_year'], $this->arrSql['search_end_month'], $this->arrSql['search_end_day'], $regdate_col);262 $arrRegistTime = $this->selectTermRange($this->arrSql['search_start_year'], $this->arrSql['search_start_month'], $this->arrSql['search_start_day'], 263 $this->arrSql['search_end_year'], $this->arrSql['search_end_month'], $this->arrSql['search_end_day'], $regdate_col); 264 264 foreach ($arrRegistTime as $data) { 265 265 $this->arrVal[] = $data; … … 277 277 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) || 278 278 (strlen($this->arrSql['search_buy_end_year']) > 0 && strlen($this->arrSql['search_buy_end_month']) >0 && strlen($this->arrSql['search_buy_end_day']) > 0)) { 279 $arrRegistTime = $this->selectTermRange($this->arrSql['search_buy_start_year'], $this->arrSql['search_buy_start_month'], $this->arrSql['search_buy_start_day'] 280 ,$this->arrSql['search_buy_end_year'], $this->arrSql['search_buy_end_month'], $this->arrSql['search_buy_end_day'], 'last_buy_date');279 $arrRegistTime = $this->selectTermRange($this->arrSql['search_buy_start_year'], $this->arrSql['search_buy_start_month'], $this->arrSql['search_buy_start_day'], 280 $this->arrSql['search_buy_end_year'], $this->arrSql['search_buy_end_month'], $this->arrSql['search_buy_end_day'], 'last_buy_date'); 281 281 foreach ($arrRegistTime as $data) { 282 282 $this->arrVal[] = $data; … … 316 316 if (!isset($this->arrSql['search_status'])) $this->arrSql['search_status'] = ''; 317 317 if (is_array($this->arrSql['search_status'])) { 318 $arrStatusVal = $this->setItemTerm($this->arrSql['search_status'] ,'status');318 $arrStatusVal = $this->setItemTerm($this->arrSql['search_status'], 'status'); 319 319 foreach ($arrStatusVal as $data) { 320 320 $this->arrVal[] = $data;
Note: See TracChangeset
for help on using the changeset viewer.
