- Timestamp:
- 2013/06/08 16:35:27 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_13-dev/data/class/SC_CustomerList.php
r22739 r22856 25 25 * [概要] 会員検索用クラス 26 26 */ 27 class SC_CustomerList extends SC_SelectSql_Ex 27 class SC_CustomerList extends SC_SelectSql_Ex 28 28 { 29 30 29 var $arrColumnCSV; 31 30 … … 238 237 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) 239 238 || strlen($this->arrSql['search_b_end_year']) > 0 && strlen($this->arrSql['search_b_end_month']) > 0 && strlen($this->arrSql['search_b_end_day']) > 0) { 240 241 239 $arrBirth = $this->selectTermRange($this->arrSql['search_b_start_year'], $this->arrSql['search_b_start_month'], $this->arrSql['search_b_start_day'], 242 240 $this->arrSql['search_b_end_year'], $this->arrSql['search_b_end_month'], $this->arrSql['search_b_end_day'], 'birth'); … … 262 260 if ( (strlen($this->arrSql['search_start_year']) > 0 && strlen($this->arrSql['search_start_month']) > 0 && strlen($this->arrSql['search_start_day']) > 0) || 263 261 (strlen($this->arrSql['search_end_year']) > 0 && strlen($this->arrSql['search_end_month']) >0 && strlen($this->arrSql['search_end_day']) > 0)) { 264 265 262 $arrRegistTime = $this->selectTermRange($this->arrSql['search_start_year'], $this->arrSql['search_start_month'], $this->arrSql['search_start_day'] 266 263 , $this->arrSql['search_end_year'], $this->arrSql['search_end_month'], $this->arrSql['search_end_day'], $regdate_col); … … 332 329 { 333 330 $this->select = 'SELECT customer_id,name01,name02,kana01,kana02,sex,email,email_mobile,tel01,tel02,tel03,pref,status,update_date,mailmaga_flg FROM dtb_customer '; 331 334 332 return $this->getSql(2); 335 333 } … … 337 335 function getListMailMagazine($is_mobile = false) 338 336 { 339 340 337 $colomn = $this->getMailMagazineColumn($is_mobile); 341 338 $this->select = " … … 344 341 FROM 345 342 dtb_customer"; 343 346 344 return $this->getSql(0); 347 345 } … … 351 349 { 352 350 $this->select = 'SELECT COUNT(customer_id) FROM dtb_customer '; 351 353 352 return $this->getSql(1); 354 353 } … … 366 365 367 366 $this->select = 'SELECT ' .$state. ' FROM dtb_customer '; 367 368 368 return $this->getSql(2); 369 369 }
Note: See TracChangeset
for help on using the changeset viewer.
