public function __construct($array, $mode = '')
{
$pmode = $mode;
if ($mode == "delete_in_customer") {
$pmode = "customer";
}
parent::__construct($array, $pmode);
if ($mode == "delete_in_customer") {
strpos($this->where, ' del_flg = 0 ');
// 先頭の del_flg = 0 を全ての条件に変える
$this->where = preg_replace('/^ del_flg = 0 /', ' del_flg IS NOT NULL ', $this->where);
}
$objDb = new SC_Helper_DB_Ex();
// query 構築用
$objQuery = SC_Query_Ex::getSingletonInstance();
GC_Utils_Ex::gfPrintLog(print_r($this->arrSql, true), DB_LOG_REALFILE);
$having = "";
if (count($this->arrSql["search_status"]) == 1) {
switch ($this->arrSql["search_status"][0]) {
case 1:
$having = "MIN(del_flg) = 1";
break;
case 2:
$having = "MIN(del_flg) = 0";
break;
}
}
$dt = "cp_dtb_customer_docomo_mymenu";
$at = "cp_dtb_customer_transaction";
$d = $objDb->sfColumnExists($dt, "customer_id");
$a = $objDb->sfColumnExists($at, "customer_id");
$objQuery->setGroupBy("customer_id");
if ($having) {
$objQuery->setOption("HAVING {$having}");
}
$where = PHP_EOL;
$where .= "CASE " . PHP_EOL;
$where .= " WHEN 1 = 0 THEN FALSE " . PHP_EOL;
// 自動構築時に特定条件で使えなくなることを防ぐ
if ($d) {
$sub_where = " payment_type IN ( 'USER1','USER10','USER12','USER3')";
// 都度課金を除く
if ($this->strlen('search_docomo_site_id') > 0) {
$sub_where .= " AND site_id = ?";
$this->arrVal[] = $this->arrSql['search_docomo_site_id'];
}
if ($this->strlen('search_course') > 0) {
$sub_where .= " AND price = ?";
$this->arrVal[] = intval($this->arrSql['search_course']);
}
$where .= "WHEN carrier = 1 THEN " . PHP_EOL;
// docomo
$where .= sprintf(" customer_id IN (%s) " . PHP_EOL, $objQuery->getSql("customer_id", $dt, $sub_where));
}
if ($a) {
$sub_where = "continue_account_id IS NOT NULL";
if ($this->strlen('search_docomo_site_id') > 0) {
// サイト ID を指定した場合は 検索対象から除外
$sub_where .= " AND FALSE ";
}
if ($this->strlen('search_course') > 0) {
$sub_where .= " AND amount = ?";
$this->arrVal[] = intval($this->arrSql['search_course']);
}
$where .= "WHEN carrier = 2 THEN " . PHP_EOL;
// au-kddi
$where .= sprintf(" customer_id IN (%s) " . PHP_EOL, $objQuery->getSql("customer_id", $at, $sub_where));
}
$where .= "ELSE FALSE END" . PHP_EOL;
$this->setWhere($where);
unset($where);
$objQuery->setGroupBy("");
$objQuery->setOption("");
// 有効なメルマガ会員か本登録ユーザー
$where = "CASE WHEN email LIKE ? THEN TRUE ELSE mailmaga_flg <> 3 END " . PHP_EOL;
$this->arrVal[] = $this->addSearchStr("@" . $_SERVER['SERVER_NAME']);
$this->setWhere($where);
if ($this->is_array("search_customer_type")) {
switch ($this->sum("search_customer_type")) {
case "1":
$this->setWhere('mailmaga_flg = 3');
break;
case "2":
$this->setWhere('mailmaga_flg <> 3');
break;
}
}
if ($this->strlen("search_point")) {
$this->setWhere('point >= ? ' . PHP_EOL);
$this->arrVal[] = intval($this->arrSql['search_point']);
}
// carrier
if ($this->strlen("search_carrier")) {
$this->setWhere(' carrier = ? ' . PHP_EOL);
$this->arrVal[] = intval($this->arrSql['search_carrier']);
} else {
}
if ($mode == 'customer') {
// 登録日を示すカラム
$regdate_col = 'dtb_customer.update_date DESC';
$this->setOrder($regdate_col);
} elseif ($mode == 'DuplicateSiteId') {
if (SC_Helper_DB::sfColumnExists("cp_dtb_customer_docomo_mymenu", "customer_id")) {
$arrPaymentType = array("USER1", "USER10", "USER12");
$this->arrVal = array_merge($this->arrVal, $arrPaymentType);
$objSql = new SC_SelectSql();
$objSql->setWhere("del_flg = 0");
$objSql->setItemTerm($arrPaymentType, "payment_type");
$objSql->setSelect("SELECT customer_id FROM cp_dtb_customer_docomo_mymenu ");
$objSql->setGroup("customer_id HAVING count(site_id) > 1");
$inquery = $objSql->getSql(2);
$this->setWhere("customer_id IN ({$inquery})");
}
$regdate_col = 'dtb_customer.customer_id DESC';
$this->setOrder($regdate_col);
}
}
/**
* Page のプロセス.
*
* @return void
*/
function process()
{
//---- ページ初期設定
$objQuery = new SC_Query();
$objView = new SC_AdminView();
$objDate = new SC_Date(1901);
$objDb = new SC_Helper_DB_Ex();
$this->arrYear = $objDate->getYear();
// 日付プルダウン設定
$this->arrMonth = $objDate->getMonth();
$this->arrDay = $objDate->getDay();
$this->objDate = $objDate;
// 認証可否の判定
$objSess = new SC_Session();
SC_Utils_Ex::sfIsSuccess($objSess);
// POST値の引き継ぎ
$this->arrForm = $_POST;
// ページ送り用
$this->arrHidden['search_pageno'] = isset($_POST['search_pageno']) ? $_POST['search_pageno'] : "";
// 検索ワードの引き継ぎ
foreach ($_POST as $key => $val) {
switch ($key) {
case 'sex':
case 'status':
$this->arrHidden[$key] = SC_Utils_Ex::sfMergeParamCheckBoxes($val);
if (!is_array($val)) {
$this->arrForm[$key] = split("-", $val);
}
break;
default:
$this->arrHidden[$key] = $val;
break;
}
}
if (!isset($_POST['mode'])) {
$_POST['mode'] = "";
}
// 顧客削除
if ($_POST['mode'] == "delete") {
$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
$result_customer = $objQuery->conn->getAll($sql, array($_POST["edit_customer_id"]));
if ($result_customer[0]["status"] == 2) {
//本会員削除
$arrDel = array("del_flg" => 1, "update_date" => "NOW()");
$objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " . SC_Utils_Ex::sfQuoteSmart($_POST["edit_customer_id"]));
} elseif ($result_customer[0]["status"] == 1) {
//仮会員削除
$sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
$objQuery->conn->query($sql, array($_POST["edit_customer_id"]));
}
}
//if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
// 登録メール再送
if ($_POST['mode'] == "resend_mail") {
$arrRet = $objQuery->select("name01, name02, secret_key, email", "dtb_customer", "customer_id = ? AND del_flg <> 1 AND status = 1", array($_POST["edit_customer_id"]));
if (is_array($arrRet) === true && count($arrRet) > 0) {
$CONF = $objDb->sf_getBasisData();
$this->CONF = $CONF;
$objMailText = new SC_SiteView();
$objMailText->assignobj($this);
$mailHelper = new SC_Helper_Mail_Ex();
$this->name01 = $arrRet[0]['name01'];
$this->name02 = $arrRet[0]['name02'];
$this->uniqid = $arrRet[0]['secret_key'];
$subject = $mailHelper->sfMakesubject($objQuery, $objMailText, $this, '会員登録のご確認');
$toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl");
$objMail = new SC_SendMail();
$objMail->setItem('', $subject, $toCustomerMail, $CONF["email03"], $CONF["shop_name"], $CONF["email03"], $CONF["email04"], $CONF["email04"]);
// 宛先の設定
$name = $this->name01 . $this->name02 . " 様";
$objMail->setTo($arrRet[0]["email"], $name);
$objMail->sendMail();
}
}
if ($_POST['mode'] == "search" || $_POST['mode'] == "csv" || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all" || $_POST['mode'] == "resend_mail") {
// 入力文字の強制変換
$this->lfConvertParam();
// エラーチェック
$this->arrErr = $this->lfCheckError($this->arrForm);
$where = "del_flg = 0";
/* 入力エラーなし */
if (count($this->arrErr) == 0) {
//-- 検索データ取得
$objSelect = new SC_CustomerList($this->arrForm, "customer");
// 表示件数設定
$page_rows = $this->arrForm['page_rows'];
if (is_numeric($page_rows)) {
$page_max = $page_rows;
} else {
$page_max = SEARCH_PMAX;
}
if (!isset($this->arrForm['search_pageno'])) {
$this->arrForm['search_pageno'] = "";
}
if ($this->arrForm['search_pageno'] == 0) {
$this->arrForm['search_pageno'] = 1;
}
$offset = $page_max * ($this->arrForm['search_pageno'] - 1);
$objSelect->setLimitOffset($page_max, $offset);
if ($_POST["mode"] == 'csv') {
$searchSql = $objSelect->getListCSV($this->arrColumnCSV);
} else {
$searchSql = $objSelect->getList();
}
$this->search_data = $objQuery->conn->getAll($searchSql, $objSelect->arrVal);
switch ($_POST['mode']) {
case 'csv':
require_once CLASS_EX_PATH . "helper_extends/SC_Helper_CSV_Ex.php";
$objCSV = new SC_Helper_CSV_Ex();
$i = 0;
$header = "";
// CSVカラム取得
$arrCsvOutput = $objCSV->sfgetCsvOutput(2, " WHERE csv_id = 2 AND status = 1");
if (count($arrCsvOutput) <= 0) {
break;
}
foreach ($arrCsvOutput as $data) {
$arrColumn[] = $data["col"];
if ($i != 0) {
$header .= ", ";
}
$header .= $data["disp_name"];
$i++;
}
$header .= "\n";
//- 都道府県/職業の変換
for ($i = 0; $i < count($this->search_data); $i++) {
$this->search_data[$i]["pref"] = $this->arrPref[$this->search_data[$i]["pref"]];
$this->search_data[$i]["job"] = $this->arrJob[$this->search_data[$i]["job"]];
}
//- CSV出力
$data = SC_Utils_Ex::getCSVData($this->search_data, $arrColumn);
SC_Utils_Ex::sfCSVDownload($header . $data);
exit;
break;
case 'delete_all':
// 検索結果をすべて削除
$where = "product_id IN (SELECT product_id FROM vw_products_nonclass AS noncls WHERE {$where})";
$sqlval['del_flg'] = 1;
$objQuery->update("dtb_products", $sqlval, $where, $arrval);
$sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
$result_customer = $objQuery->conn->getAll($sql, array($_POST["del_customer_id"]));
if ($result_customer[0]["status"] == 2) {
//本会員削除
$arrDel = array("del_flg" => 1, "update_date" => "NOW()");
$objQuery->conn->autoExecute("dtb_customer", $arrDel, "customer_id = " . SC_Utils_Ex::sfQuoteSmart($_POST["del_customer_id"]));
} elseif ($result_customer[0]["status"] == 1) {
//仮会員削除
$sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
$objQuery->conn->query($sql, array($_POST["del_customer_id"]));
}
break;
default:
// 行数の取得
$linemax = $objQuery->conn->getOne($objSelect->getListCount(), $objSelect->arrVal);
$this->tpl_linemax = $linemax;
// 何件が該当しました。表示用
// ページ送りの取得
$objNavi = new SC_PageNavi($this->arrHidden['search_pageno'], $linemax, $page_max, "fnCustomerPage", NAVI_PMAX);
$startno = $objNavi->start_row;
$this->arrPagenavi = $objNavi->arrPagenavi;
}
}
}
$this->arrCatList = $objDb->sfGetCategoryList();
//---- ページ表示
$objView->assignobj($this);
$objView->display(MAIN_FRAME);
}
function lfRegistData(&$conn, $arrData)
{
$objQuery = new SC_Query();
$objSelect = new SC_CustomerList($this->lfConvertParam($arrData, $this->arrSearchColumn), "magazine");
$search_data = $conn->getAll($objSelect->getListMailMagazine($this->lfGetIsMobile($_POST['mail_type'])), $objSelect->arrVal);
$dataCnt = count($search_data);
$dtb_send_history = array();
if (DB_TYPE == 'pgsql') {
$dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id');
}
$dtb_send_history["mail_method"] = $arrData['mail_method'];
$dtb_send_history["subject"] = $arrData['subject'];
$dtb_send_history["body"] = $arrData['body'];
if (MELMAGA_BATCH_MODE) {
$dtb_send_history["start_date"] = $arrData['send_year'] . "/" . $arrData['send_month'] . "/" . $arrData['send_day'] . " " . $arrData['send_hour'] . ":" . $arrData['send_minutes'];
} else {
$dtb_send_history["start_date"] = "now()";
}
$dtb_send_history["creator_id"] = $_SESSION['member_id'];
$dtb_send_history["send_count"] = $dataCnt;
$arrData['body'] = "";
$dtb_send_history["search_data"] = serialize($arrData);
$dtb_send_history["update_date"] = "now()";
$dtb_send_history["create_date"] = "now()";
$objQuery->insert("dtb_send_history", $dtb_send_history);
if (DB_TYPE == "mysql") {
$dtb_send_history["send_id"] = $objQuery->nextval('dtb_send_history', 'send_id');
}
if (is_array($search_data)) {
foreach ($search_data as $line) {
$dtb_send_customer = array();
$dtb_send_customer["customer_id"] = $line["customer_id"];
$dtb_send_customer["send_id"] = $dtb_send_history["send_id"];
$dtb_send_customer["email"] = $line["email"];
$dtb_send_customer["name"] = $line["name01"] . " " . $line["name02"];
$conn->autoExecute("dtb_send_customer", $dtb_send_customer);
}
}
}
