- Timestamp:
- 2010/03/11 10:35:11 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
tmp/version-2_5-test/data/class/pages/admin/customer/LC_Page_Admin_Customer.php
r18007 r18609 152 152 "header" => "更新日") 153 153 ); 154 $this->httpCacheControl('nocache'); 154 155 } 155 156 … … 212 213 } 213 214 } 214 //if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {215 215 // 登録メール再送 216 216 if ($_POST['mode'] == "resend_mail") { 217 $arrRet = $objQuery->select("name01, name02, secret_key, email ", "dtb_customer","customer_id = ? AND del_flg <> 1 AND status = 1", array($_POST["edit_customer_id"]));217 $arrRet = $objQuery->select("name01, name02, secret_key, email, email_mobile", "dtb_customer","customer_id = ? AND del_flg <> 1 AND status = 1", array($_POST["edit_customer_id"])); 218 218 if( is_array($arrRet) === true && count($arrRet) > 0 ){ 219 220 $CONF = $objDb->sf_getBasisData();221 $this->CONF = $CONF;222 $objMailText = new SC_SiteView();223 $objMailText->assignobj($this);224 $mailHelper = new SC_Helper_Mail_Ex();225 219 226 220 $this->name01 = $arrRet[0]['name01']; … … 228 222 $this->uniqid = $arrRet[0]['secret_key']; 229 223 230 $subject = $mailHelper->sfMakesubject($objQuery, $objMailText, $this, '会員登録のご確認'); 224 $CONF = $objDb->sf_getBasisData(); 225 $this->CONF = $CONF; 226 /** 227 * 携帯メールアドレスが登録されていれば携帯サイトから仮会員登録したものと判定する。 228 * TODO: とりあえずの簡易的な判定なので、将来的には判定ルーチンを修正した方が良い。 229 */ 230 if (!empty($arrRet[0]['email_mobile'])) { 231 $objMailText = new SC_MobileView(false); 232 $this->to_name01 = $arrRet[0]['name01']; 233 $this->to_name02 = $arrRet[0]['name02']; 234 } else { 235 $objMailText = new SC_SiteView(false); 236 } 237 $objMailText->assignobj($this); 238 $mailHelper = new SC_Helper_Mail_Ex(); 239 240 $subject = $mailHelper->sfMakesubject('会員登録のご確認'); 231 241 $toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl"); 232 242 … … 249 259 250 260 } 261 251 262 if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "resend_mail") { 252 263 … … 461 472 return $objErr->arrErr; 462 473 } 463 464 function lfSetWhere($arrForm){465 foreach ($arrForm as $key => $val) {466 467 $val = sfManualEscape($val);468 469 if($val == "") continue;470 471 switch ($key) {472 case 'product_id':473 $where .= " AND product_id = ?";474 $arrval[] = $val;475 break;476 case 'product_class_id':477 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)";478 $arrval[] = $val;479 break;480 case 'name':481 $where .= " AND name ILIKE ?";482 $arrval[] = "%$val%";483 break;484 case 'category_id':485 list($tmp_where, $tmp_arrval) = sfGetCatWhere($val);486 if($tmp_where != "") {487 $where.= " AND $tmp_where";488 $arrval = array_merge($arrval, $tmp_arrval);489 }490 break;491 case 'product_code':492 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";493 $arrval[] = "%$val%";494 break;495 case 'startyear':496 $date = sfGetTimestamp($_POST['startyear'], $_POST['startmonth'], $_POST['startday']);497 $where.= " AND update_date >= ?";498 $arrval[] = $date;499 break;500 case 'endyear':501 $date = sfGetTimestamp($_POST['endyear'], $_POST['endmonth'], $_POST['endday']);502 $where.= " AND update_date <= ?";503 $arrval[] = $date;504 break;505 case 'product_flag':506 global $arrSTATUS;507 $product_flag = sfSearchCheckBoxes($val);508 if($product_flag != "") {509 $where.= " AND product_flag LIKE ?";510 $arrval[] = $product_flag;511 }512 break;513 case 'status':514 $tmp_where = "";515 foreach ($val as $element){516 if ($element != ""){517 if ($tmp_where == ""){518 $tmp_where.="AND (status LIKE ? ";519 }else{520 $tmp_where.="OR status LIKE ? ";521 }522 $arrval[]=$element;523 }524 }525 if ($tmp_where != ""){526 $tmp_where.=")";527 $where.= "$tmp_where";528 }529 break;530 default:531 break;532 }533 }534 }535 474 } 536 475 ?>
Note: See TracChangeset
for help on using the changeset viewer.