Changeset 14676 for branches/beta/data/class/SC_CustomerList.php
- Timestamp:
- 2007/06/14 22:01:13 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/beta/data/class/SC_CustomerList.php
r11771 r14676 5 5 * http://www.lockon.co.jp/ 6 6 */ 7 7 $INC_PATH = realpath( dirname( __FILE__) ); 8 require( $INC_PATH ."/../conf/conf.php" ); 8 9 /* [̾¾Î] SC_CustomerList 9 10 * [³µÍ×] ²ñ°÷¸¡º÷ÍÑ¥¯¥é¥¹ … … 191 192 $this->setWhere($sql_where); 192 193 } 193 194 //¡¡ÇÛ¿®¥á¡¼¥ë¥¢¥É¥ì¥¹¼ïÊÌ 195 if ( $mode == 'magazine' ){ 196 if ( strlen($this->arrSql['mail_type']) > 0 && $this->arrSql['mail_type'] == 2) { 197 $this->setWhere( " dtb_customer.email_mobile <> '' "); 198 } 199 } 200 201 //¡¡HTML-mail 202 if ( $mode == 'magazine' ){ 194 195 /* 2007/05/28 °ìö¡¢Ää»ß¤·¤Þ¤¹¡£ 196 * //¡¡ÇÛ¿®¥á¡¼¥ë¥¢¥É¥ì¥¹¼ïÊÌ 197 * if ( $mode == 'magazine' ){ 198 * if ( strlen($this->arrSql['mail_type']) > 0 && $this->arrSql['mail_type'] == 2) { 199 * $this->setWhere( " dtb_customer.email_mobile <> '' "); 200 * } 201 * } 202 */ 203 204 if($mode == 'magazine'){ 205 global $arrDomainType; 206 $sql_where = ""; 207 //¥É¥á¥¤¥ó»ØÄê¡££±¤Ï£Ð£Ã¡¢£²¤Ï·ÈÂÓ 208 if ( $this->arrSql['domain'] > 0 ) { 209 foreach($arrDomainType as $val) { 210 if($this->arrSql['domain'] == 1) { 211 if($sql_where == "") { 212 $sql_where .= "dtb_customer.email NOT ILIKE ? "; 213 } else { 214 $sql_where .= "AND dtb_customer.email NOT ILIKE ? " ; 215 } 216 } elseif($this->arrSql['domain'] == 2) { 217 if($sql_where == "") { 218 $sql_where .= "dtb_customer.email ILIKE ? "; 219 } else { 220 $sql_where .= "OR dtb_customer.email LIKE ? " ; 221 } 222 $sql_where = "(".$sql_where.")"; 223 } 224 $searchDomain = $this->addSearchStr($val); 225 $this->arrVal[] = $searchDomain; 226 } 227 $this->setWhere($sql_where); 228 } 229 } 230 231 //¡¡HTML-mail¡ÊÇÛ¿®Êý¼°) 232 if( $mode == 'magazine' ){ 203 233 if ( strlen($this->arrSql['htmlmail']) > 0 ) { 204 234 $this->setWhere( " mailmaga_flg = ? ");
Note: See TracChangeset
for help on using the changeset viewer.