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); } } }