/**
*
* @param array $param
*
* @return array
*/
public function getReservePointGrantData($param = "", $offset = "", $order = "", $limit = "")
{
$columnArray[] = "SQL_CALC_FOUND_ROWS *";
if (ComValidation::isDatetime($param["dispDatetimeFrom"])) {
$whereArray[] = "update_user_point_datetime >= '" . $param["dispDatetimeFrom"] . "'";
}
if (ComValidation::isDatetime($param["dispDatetimeTo"])) {
$whereArray[] = "update_user_point_datetime <= '" . $param["dispDatetimeTo"] . "'";
}
if (ComValidation::isValue($param["is_exec"])) {
$whereArray[] = "is_exec = '" . $param["is_exec"] . "'";
}
$whereArray[] = "disable = 0";
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("reserve_point_grant", $columnArray, $whereArray, $otherArray);
if (!($dbResultOBJ = $this->executeQuery($sql))) {
return FALSE;
}
// データリスト取得
$dataList = $this->fetchAll($dbResultOBJ);
return $dataList;
}
/**
*
* 非許可ドメインリストと正規表現にて照会
*
* @return array データ配列
*/
public function searchNonAllowDomain($value)
{
if (!ComValidation::isMailAddress($value)) {
return FALSE;
}
$dangerFlag = FALSE;
$nonAllowDomainList = $this->getNonAllowDomainList();
//非許可リストと照会します
if ($nonAllowDomainList) {
foreach ($nonAllowDomainList as $nonAllowDomainData) {
if (preg_match('/' . preg_quote($nonAllowDomainData['domain']) . '$/', $value) == TRUE) {
$dangerFlag = TRUE;
break;
}
}
}
//非許可に該当するなら、許可リストと照会します
if ($dangerFlag == TRUE) {
$allowDomainList = $this->getAllowDomainList();
if ($allowDomainList) {
foreach ($allowDomainList as $allowDomainData) {
if (preg_match('/' . preg_quote($allowDomainData['domain']) . '$/', $value) == TRUE) {
$dangerFlag = FALSE;
break;
}
}
}
}
return $dangerFlag;
}
/**
* 情報リストの取得
*
* @param array $param パラメーター
* @param integer $offset オフセット
* @param string $order 表示順
* @param integer $limit 表示件数
*
* @return array $dataList データ配列
*/
public function getInformationStatusLogList($param, $offset = 0, $order = null, $limit = 0)
{
if (!is_numeric($param["user_id"])) {
return FALSE;
}
$columnArray[] = "SQL_CALC_FOUND_ROWS ims.*";
$columnArray[] = "log.create_datetime log_create_datetime";
$whereArray[] = "ims.id = log.information_status_id";
$whereArray[] = "log.user_id = " . $param["user_id"];
$whereArray[] = "ims.disable = 0";
$whereArray[] = "log.disable = 0";
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("information_status AS ims, information_status_log AS log", $columnArray, $whereArray, $otherArray);
if (!($dbResultOBJ = $this->executeQuery($sql))) {
return FALSE;
}
// データリスト取得
$dataList = $this->fetchAll($dbResultOBJ);
return $dataList;
}
/**
* Smarty {emoji} modifier plugin
*
* Type: modifier
* Name: date_format
* 日付フォーマット
*
* Examples:{$data|date_format:'YYYY-mm-dd'}
* @param string $data
* @param string $format
*
* @return string|null
*/
function smarty_modifier_zend_date_format($data, $format = "yyyy-MM-dd")
{
if (!ComValidation::isDatetime($data) and !ComValidation::isDate($data)) {
return "";
}
$date = new ComDate($data);
// 日付をフォーマット
$data = $date->toString($format);
return $data;
}
/**
* get user_profile_flag by conditions
*
* @param array $param (conditions)
* @param integer $offset (from)
* @param string $order (sort)
* @param integer $limit (number of records)
* @return array
*/
public function getUserProfileFlag($param = null, $offset = null, $order = null, $limit = null)
{
$columnArray[] = "SQL_CALC_FOUND_ROWS *";
$whereArray = $this->setWhereString($param);
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$this->_listSql = $this->makeSelectQuery("user_profile_flag", $columnArray, $whereArray, $otherArray);
if (!($dbResultOBJ = $this->executeQuery($this->_listSql))) {
return false;
}
// データリスト取得
$dataList = $dbResultOBJ->fetchAll();
return $dataList;
}
/**
*
* 入金ログリストの取得
*
* @param array $param パラメーター
* @param integer $offset オフセット
* @param string $order 表示順
* @param integer $limit 表示件数
*
* @return array $dataList データ配列
*/
public function getPaymentLogList($param, $offset, $order, $limit)
{
if (!is_numeric($param["user_id"])) {
return FALSE;
}
$columnArray[] = "SQL_CALC_FOUND_ROWS *";
$whereArray[] = "user_id = " . $param["user_id"];
$whereArray[] = "disable = 0";
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("payment_log", $columnArray, $whereArray, $otherArray);
if (!($dbResultOBJ = $this->executeQuery($sql))) {
return FALSE;
}
// データリスト取得
$dataList = $this->fetchAll($dbResultOBJ);
return $dataList;
}
/**
* アフィリエイト情報リストの取得。
*
* @param array $whereArray 条件
* @param string $order 順序
* @param integer $limit 取得数
*
* @return mixed アフィリエイト情報リスト、失敗ならfalse
*/
public function getAffiliateList($whereArray = "", $order = "", $limit = "")
{
$columnArray[] = "*";
$whereArray[] = "disable = 0";
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($limit)) {
$otherArray[] = " LIMIT " . $limit;
}
$sql = $this->makeSelectQuery("affiliate", $columnArray, $whereArray, $otherArray);
if ($dbResultOBJ = $this->executeQuery($sql)) {
$dataArray = $this->fetchAll($dbResultOBJ);
} else {
return FALSE;
}
return $dataArray;
}
// インスタンスの作成
$AdmMailMagazineOBJ = AdmMailMagazine::getInstance();
$offset = $requestOBJ->getParameter("offset");
if (!$offset) {
$offset = 0;
}
$exceptArray[] = "offset";
$param = $requestOBJ->getParameterExcept($exceptArray);
$dispCnt = 20;
// 入力日時の生成
$param["dispDatetimeFrom"] = $param["disp_date_from"] . " " . $param["disp_time_from"];
if (!ComValidation::isDatetime($param["dispDatetimeFrom"])) {
$param["dispDatetimeFrom"] = date("Y-m-d") . " 00:00:00";
}
$param["dispDatetimeTo"] = $param["disp_date_to"] . " " . $param["disp_time_to"];
if (!ComValidation::isDatetime($param["dispDatetimeTo"])) {
$param["dispDatetimeTo"] = date("Y-m-d") . " 23:59:59";
}
$smartyOBJ->assign("param", $param);
// ソート条件
switch ($param["sort"]) {
case "pc_access":
$sortColumn = "access_count_pc DESC,";
break;
case "pc_access_percent":
$sortColumn = "pc_access_percent DESC,";
break;
case "mb_access":
$sortColumn = "access_count_mb DESC,";
break;
case "mb_access_percent":
exit;
}
// メアドの重複チェック
if (!($duplicateUserData = $UserOBJ->getUserDataFromMailAddress($mailAddressChangeData["mail_address"]))) {
$duplicateUserData = $UserOBJ->chkUserDataFromLoginId($mailAddressChangeData["mail_address"]);
}
// 重複メアドがあった場合
if ($duplicateUserData) {
$errSessOBJ->errMsg[] = "メールアドレスが重複しています。";
header("Location: ./?action_Update=1" . ($comURLparam ? "&" . $comURLparam : ""));
exit;
}
// トランザクション開始
$UserOBJ->beginTransaction();
// メールステータス等も初期化
if (ComValidation::isMobileAddress($mailAddressChangeData["mail_address"])) {
$updateUserData["mb_device_cd"] = $ComUtilityOBJ->getDeviceFromMailAddress($mailAddressChangeData["mail_address"]);
$updateUserData["mb_address"] = $mailAddressChangeData["mail_address"];
$updateUserData["mb_address_status"] = 0;
$updateUserData["mb_send_status"] = 0;
$updateUserData["mb_emsys_count"] = 0;
$updateProfileData["mb_is_mailmagazine"] = 0;
// 変更前メアドがログインIDと一緒ならログインIDも変更
if ($comUserData["mb_address"] == $comUserData["login_id"]) {
$updateUserData["login_id"] = $mailAddressChangeData["mail_address"];
}
// アドレス新規登録か
if (!$comUserData["mb_address"]) {
$firstReg = true;
}
} else {
* @author norio takei
*/
require_once D_BASE_DIR . "/common/admin_common.php";
$param = $requestOBJ->getParameterExcept($exceptArray);
$tags = array("mail_maga_reserve_id");
$URLparam = $requestOBJ->makeGetTag($tags);
$AdmMailMagazineOBJ = AdmMailMagazine::getInstance();
// セッションオブジェクトのインスタンス
$execMsgSessOBJ = new ComSessionNamespace("exec_msg");
$returnSessOBJ = new ComSessionNamespace("return");
$magaData = $AdmMailMagazineOBJ->getMailReserveData($param["mail_maga_reserve_id"]);
if (!ComValidation::isMailAddress($param["from_address"])) {
$errMsg[] = "送信アドレスを入力してください";
}
$timerDatetime = $param["reserve_datetime_Date"] . " " . $param["reserve_datetime_Time"] . ":00";
if (!ComValidation::isDatetime($timerDatetime)) {
$errMsg[] = "有効な日時を入力して下さい";
}
// 戻り値の格納
$returnSessOBJ->return = $param;
if ($errMsg) {
$execMsgSessOBJ->message = $errMsg;
header("Location: ./?action_mailLog_ReserveMailData=1&" . $URLparam);
exit;
}
// 予約メルマガ内容の更新
//前ページから渡って来た値
$mailLog["from_address"] = $param["from_address"];
$mailLog["from_name"] = $param["from_name"];
$mailLog["pc_subject"] = $param["pc_subject"];
$mailLog["pc_text_body"] = $param["pc_text_body"];
if (!$UserOBJ->insertUserData($userAry)) {
$UserOBJ->rollbackTransaction();
$rootChild = $DOMDocumentOBJ->createElement("error");
$root->appendChild($rootChild);
$errorChild = $DOMDocumentOBJ->createElement("message", "登録できませんでした。");
$rootChild->appendChild($errorChild);
print $DOMDocumentOBJ->saveXML();
exit;
}
$userId = $UserOBJ->getInsertId();
$profileAry = array("user_id" => $userId, "by_user_update_datetime" => $currentDateTime, "update_datetime" => $currentDateTime);
if (ComValidation::isNumeric($param["s"])) {
$profileAry["sex_cd"] = $param["s"];
}
// タイムスタンプで来る
if (ComValidation::isNumeric($param["b"])) {
$profileAry["birth_date"] = date("Y-m-d", $param["b"]);
}
if ($mbFlag) {
$profileAry["mb_is_mailmagazine"] = $_config["define"]["ADDRESS_SEND_STATUS_DO"];
} else {
$profileAry["pc_is_mailmagazine"] = $_config["define"]["ADDRESS_SEND_STATUS_DO"];
}
// profileテーブルへのインサート処理
if (!$UserOBJ->insertProfileData($profileAry)) {
$UserOBJ->rollbackTransaction();
$rootChild = $DOMDocumentOBJ->createElement("error");
$root->appendChild($rootChild);
$errorChild = $DOMDocumentOBJ->createElement("message", "登録できませんでした。");
$rootChild->appendChild($errorChild);
print $DOMDocumentOBJ->saveXML();
if (!$UserOBJ->updateProfileData($setProfileParam, $userProfileWhere)) {
$errSessOBJ->errMsg = $UserOBJ->getErrorMsg();
header("Location: ./?action_Error=1" . ($comURLparam ? "&" . $comURLparam : "") . "&" . $sessId);
exit;
}
if ($param["swf"]) {
header("Location: ./?action_Flash=1&" . Auth::ACCESS_KEY_NAME . "=" . $duplicateUserData["access_key"] . "&swf=" . $param["swf"] . "&isid=" . $param["isid"] . ($comURLparam ? "&" . $comURLparam : ""));
} else {
header("Location: ./?action_Information=1&" . Auth::ACCESS_KEY_NAME . "=" . $duplicateUserData["access_key"] . "&isid=" . $param["isid"] . ($comURLparam ? "&" . $comURLparam : ""));
}
exit;
}
}
// 退会なら登録ステータスの変更
if ($comUserData["regist_status"] == $_config["define"]["USER_REGIST_STATUS_MEMBER_QUIT"]) {
if (ComValidation::isDateTime($comUserData["regist_datetime"])) {
$setUserParam["regist_status"] = $_config["define"]["USER_REGIST_STATUS_MEMBER"];
} else {
$setUserParam["regist_status"] = $_config["define"]["USER_REGIST_STATUS_PRE_MEMBER"];
}
$setUserParam["quit_datetime"] = "0000-00-00 00:00:00";
}
$userWhere = "";
$userWhere[] = "id = " . $comUserData["user_id"];
// userテーブルへの更新処理
if (!$UserOBJ->updateUserData($setUserParam, $userWhere)) {
$ComErrSessOBJ->errMsg = $UserOBJ->getErrorMsg();
header("Location: ./?action_Error=1" . ($comURLparam ? "&" . $comURLparam : "") . "&" . $sessId);
exit;
}
$userProfileWhere = "";
require_once D_BASE_DIR . "/common/post_common.php";
require_once $controllerOBJ->getIncludeBusinessLogic("postInclude");
$errSessOBJ = new ComSessionNamespace("err_msg");
$UserOBJ = User::getInstance();
$param = $requestOBJ->getParameterExcept($exceptArray);
$mailAddress = $param["mail_account"] . "@" . $param["mail_domain"];
if ($param["login_id"] != $comUserData["login_id"]) {
$errFlag = true;
}
if ($UserOBJ->createPasswordKey($param["password"]) != $comUserData["password"]) {
$errFlag = true;
}
if (!ComValidation::isMailAddress($mailAddress)) {
$errFlag = true;
}
if (!ComValidation::isNumeric($param["q1"]) or $param["q1"] == 1 and !ComValidation::isNumeric($param["q6"]) or (!ComValidation::isNumeric($param["q2"]) or $param["q2"] == 1 and !ComValidation::isNumeric($param["q7"])) or (!ComValidation::isNumeric($param["q3"]) or $param["q3"] == 1 and !ComValidation::isNumeric($param["q8"])) or (!ComValidation::isNumeric($param["q4"]) or $param["q4"] == 1 and !ComValidation::isNumeric($param["q9"])) or (!ComValidation::isNumeric($param["q5"]) or $param["q5"] == 1 and !$param["q10"])) {
$errFlag = true;
}
if ($errFlag) {
$errSessOBJ->errMsg[] = "必須項目に入力漏れがあります";
header("Location: ./?action_Taikai=1" . ($comURLparam ? "&" . $comURLparam : ""));
exit;
}
$QuitRequestOBJ = QuitRequest::getInstance();
if (!$QuitRequestOBJ->getQuitRequestData($comUserDataId)) {
// 退会申請情報をインサート
$insertArray["user_id"] = $comUserDataId;
$insertArray["create_datetime"] = date("YmdHis");
if (!$QuitRequestOBJ->insertQuitRequestData($insertArray)) {
$errSessOBJ->errMsg[] = "退会申請情報処理ができませんでした。";
header("Location: ./?action_Taikai=1" . ($comURLparam ? "&" . $comURLparam : ""));
/**
* 管理画面アクセス情報の取得。
*
* @return mixed 管理画面アクセスリスト、失敗ならfalse
*/
public function getList($param = "", $offset = "", $order = "", $limit = "")
{
$columnArray[] = "SQL_CALC_FOUND_ROWS *";
//$whereArray[] = "disable = 0";
if (ComValidation::isDatetime($param["dispDatetimeFrom"])) {
$whereArray[] = "create_datetime >= '" . $param["dispDatetimeFrom"] . "'";
}
if (ComValidation::isDatetime($param["dispDatetimeTo"])) {
$whereArray[] = "create_datetime <= '" . $param["dispDatetimeTo"] . "'";
}
if ($param["admin_id"]) {
$whereArray[] = "admin_id = " . $param["admin_id"];
}
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("tmp_admin_access", $columnArray, $whereArray, $otherArray);
if ($dbResultOBJ = $this->executeQuery($sql)) {
$dataArray = $this->fetchAll($dbResultOBJ);
} else {
return FALSE;
}
return $dataArray;
}
header("Location: " . $_config["define"]["SITE_URL"]);
exit;
}
}
}
// モバイルなら表示文字コードを設定する
if (($mbUa != "NonMobile" or $isSmartPhone) and !array_key_exists($server["REMOTE_ADDR"], $_config["common_config"]["corporation_ip_address"]) or preg_match("/" . implode("|", $_config["web_config"]["crawler_mb"]) . "/", $server["HTTP_USER_AGENT"])) {
// モバイルURLでなければ
// ドコモ個体識別がなければリダイレクト
if (!$isURIMobile or $mbUa == "Docomo" and !$commonParam["guid"] and !$mbSerialNo) {
if ($server["QUERY_STRING"]) {
parse_str($server["QUERY_STRING"], $queryAry);
if ($queryAry[$sesName]) {
unset($queryAry[$sesName]);
}
if (ComValidation::isArray($queryAry)) {
foreach ((array) $queryAry as $key => $val) {
$queryString[] = $key . "=" . $val;
}
$queryString = implode("&", (array) $queryString);
}
}
header("Location: " . $_config["define"]["SITE_URL_MOBILE"] . "index.php?" . $queryString . ($mbUa == "Docomo" ? $queryString ? "&guid=ON&" . $sessId : "guid=ON&" . $sessId : ($queryString ? "&" . $sessId : $sessId)));
exit;
}
// PCアクセスの場合
} else {
// 自社アクセス以外はPC用ページに飛ばす
if ($isURIMobile and !array_key_exists($server["REMOTE_ADDR"], $_config["common_config"]["corporation_ip_address"]) or preg_match("/" . implode("|", $_config["web_config"]["crawler_pc"]) . "/", $server["HTTP_USER_AGENT"])) {
header("Location: " . $_config["define"]["SITE_URL"] . "?" . $server["QUERY_STRING"]);
exit;
$AdmCalculationOBJ = AdmCalculation::getInstance();
$AdmItemOBJ = AdmItem::getInstance();
$AdmCalculationOBJ->setDebugFlag(false);
$ComEmojiOBJ = ComEmoji::getInstance();
// 他キャリアの絵文字を変換する際、半角カナを用いるよう設定
$ComEmojiOBJ->useHalfwidthKatakana();
// 期間指定
if (ComValidation::isDate($param["start_date"])) {
$defaultWhereArray[] = "p.create_datetime >= '" . $param["start_date"] . " 00:00:00'";
}
// 期間指定
if (ComValidation::isDate($param["end_date"])) {
$defaultWhereArray[] = "p.create_datetime <= '" . $param["end_date"] . " 23:59:59'";
}
// 登録日
if (!$param["start_date"] and !$param["end_date"] and ComValidation::isDate($param["date"])) {
$defaultWhereArray[] = "p.create_datetime >= '" . $param["date"] . " 00:00:00'";
$defaultWhereArray[] = "p.create_datetime <= '" . $param["date"] . " 23:59:59'";
}
$columnArray[] = "p.*";
$columnArray[] = "o.id ordering_id";
$columnArray[] = "o.status ordering_status";
$columnArray[] = "o.create_datetime ordering_create_datetime";
// ログリスト
$dataList = $AdmCalculationOBJ->getCalcPaymentList($param, $columnArray, $defaultWhereArray, $otherArray);
if ($dataList) {
foreach ($dataList as $key => $val) {
$total["cnt"]++;
$total["receive_money"] += $val["receive_money"];
$dataList[$key]["pay_type"] = AdmOrdering::$_payType[$val["pay_type"]];
if ($val["ordering_status"] == AdmOrdering::ORDERING_STATUS_REST) {
<?php
/**
*
* @author hoang_minh
* @since 2014/12/2
*/
require_once D_BASE_DIR . "/common/admin_common.php";
// user profile flag
$AdminUserProfileFlagOBJ = AdmUserProfileFlag::getInstance();
$param = $requestOBJ->getParameterExcept($exceptArray);
$errSessOBJ = new ComSessionNamespace("err");
// Check user profile flag name
if (!ComValidation::isValue($param["user_profile_flag_name"])) {
$errMsg[] = "user profile flag name is not null";
}
if ($errMsg) {
$errSessOBJ->errMsg = $errMsg;
header("Location: ./?action_User_UserProfileFlagData=1&user_profile_flag_code=" . $param["user_profile_flag_code"]);
exit;
}
//set user profile flag
$setUserProfileFlagParam['name'] = $param['user_profile_flag_name'];
$setUserProfileFlagParam['convert_code'] = $param['convert_code'];
//set where
$whereUserProfileFlag[] = "code = '" . $param['user_profile_flag_code'] . "'";
//update
$errSessOBJ->errMsg = array("更新しました。");
if (!$AdminUserProfileFlagOBJ->updateUserProfileFlagData($setUserProfileFlagParam, $whereUserProfileFlag)) {
$errSessOBJ->errMsg = array("更新できませんでした。");
}
<?php
/**
* remake.php
*
* Copyright (c) 2009 Fraise, Inc.
* All rights reserved.
*/
/**
* 管理画面媒体集計再集計ページ処理ファイル。
*
* @copyright 2009 Fraise, Inc.
* @author mitsuhiro nakamura
*/
require_once D_BASE_DIR . "/common/baitai_common.php";
require_once $controllerOBJ->getIncludeBusinessLogic("admInclude");
$execMsgSessOBJ = new ComSessionNamespace("exec_msg");
$returnSessOBJ = new ComSessionNamespace("return");
// メッセージの取得
$smartyOBJ->assign("execMsg", $execMsgSessOBJ->getIterator());
// セッション変数の破棄
$execMsgSessOBJ->unsetAll();
// 入力項目の取得
$returnValue = $returnSessOBJ->return;
// セッション変数の破棄
$returnSessOBJ->unsetAll();
if (!ComValidation::isDatetime($returnValue["date"])) {
$returnValue["date"] = date("Y-m-d", strtotime("-1 day"));
}
$smartyOBJ->assign("value", $returnValue);
if ($ezwebFlag) {
if ($userData["mb_user_agent"]) {
// ユーザエージェントオブジェクト作成
$userAgentMobileEzwebOBJ = new ComUserAgentMobileEzweb($userData["mb_user_agent"]);
$model = $userAgentMobileEzwebOBJ->getModel();
if ($model != "" && $model != $userData["mb_model"]) {
$userData["mb_model"] = $model;
}
}
}
if ($userData) {
$userData["pre_regist_datetime"] = ComValidation::isDateTime($userData["pre_regist_datetime"]) ? $userData["pre_regist_datetime"] : "";
$userData["regist_datetime"] = ComValidation::isDateTime($userData["regist_datetime"]) ? $userData["regist_datetime"] : "";
$userData["last_buy_datetime"] = ComValidation::isDateTime($userData["last_buy_datetime"]) ? $userData["last_buy_datetime"] : "";
$userData["last_access_datetime"] = ComValidation::isDateTime($userData["last_access_datetime"]) ? $userData["last_access_datetime"] : "";
$userData["quit_datetime"] = ComValidation::isDateTime($userData["quit_datetime"]) ? $userData["quit_datetime"] : "";
}
if ($userData) {
//配信ドメイン取得
$userData["pc_mailmagazine_from_domain"] = $_config["define"]["SEND_MAIL_DOMAIN"][$userData["pc_mailmagazine_from_domain_id"]];
$userData["mb_mailmagazine_from_domain"] = $_config["define"]["SEND_MAIL_DOMAIN"][$userData["mb_mailmagazine_from_domain_id"]];
}
// 銀行振込先データ取得
if ($data = $UserOBJ->getBankDetailData($userId)) {
$userData["bank_name"] = $data["bank_name"];
$userData["bank_code"] = $data["bank_code"];
$userData["branch_name"] = $data["branch_name"];
$userData["branch_code"] = $data["branch_code"];
$userData["type"] = $data["type"];
$userData["account_number"] = $data["account_number"];
$userData["account_holder_name"] = $data["name"];
// 末尾のカンマ削除(あれば)
$param["monthly_update_item_id"] = rtrim($param["monthly_update_item_id"], ",");
$monthlyUpdateItemId = explode(",", $param["monthly_update_item_id"]);
foreach ($monthlyUpdateItemId as $key => $val) {
if (!ComValidation::isNumeric($val) || !$val) {
$validationOBJ->setErrorMessage("monthly_update_item_id", "月額更新用商品IDは数値のみ入力可能です");
break;
}
}
}
// 月額コース有効日付(開始日)
if ($param["monthly_course_start_date"] and !ComValidation::isDate($param["monthly_course_start_date"])) {
$validationOBJ->setErrorMessage("月額コース有効日付(開始日)", "月額コース有効日付(開始日)を正しく入力してください");
}
// 月額コース有効日付(終了日)
if ($param["monthly_course_end_date"] and !ComValidation::isDate($param["monthly_course_end_date"])) {
$validationOBJ->setErrorMessage("月額コース有効日付(終了日)", "月額コース有効日付(終了日)を正しく入力してください");
}
if ($validationOBJ->isError()) {
$errorMsg = $validationOBJ->getErrorMessage();
$execMsgSessOBJ->exec_msg = $errorMsg;
header("location: ./?action_monthlyCourse_CourseUserSearchList=1&" . $URLparam);
exit;
}
$monthlyCourseUserList = $AdmMonthlyCourseOBJ->getMonthlyCourseUserList($param, $offset, "mcu.id DESC", $dispCnt);
$totalCount = $AdmMonthlyCourseOBJ->getFoundRows();
$dispFirst = $offset + 1;
$dispLast = $offset + count($monthlyCourseUserList);
}
$smartyOBJ->assign("totalCount", $totalCount);
$smartyOBJ->assign("dispFirst", $dispFirst);
$value["disable"] = $param["disable"][$val];
$value["update_datetime"] = date("YmdHis");
$whereArray[] = "id = " . $val;
if (!$AdmBaitaiAgencyIpAddressSettingOBJ->updateData($value, $whereArray)) {
$messageSessOBJ->message = $AdmBaitaiAgencyIpAddressSettingOBJ->getErrorMsg();
header("Location: ./?action_baitaiAgency_BaitaiAgencyUpd=1&id=" . $param["id"]);
exit;
}
}
$messageSessOBJ->message = array("更新しました。");
// 新規
} else {
// IPアドレスチェック
if ($param["ip_address"]) {
foreach ($param["ip_address"] as $val) {
if (!ComValidation::isNumeric($val)) {
$validationOBJ->setErrorMessage("ip_address", "IPアドレスは数値のみ入力可能です");
}
}
}
// エラーチェック
if ($validationOBJ->isError()) {
$errorMsg = $validationOBJ->getErrorMessage();
$param["return_cd"] = "ip_setting";
$returnSessOBJ->return = $param;
$messageSessOBJ->exec_msg = $errorMsg;
header("Location: ./?action_baitaiAgency_BaitaiAgencyUpd=1&id=" . $param["id"]);
exit;
}
$value["baitai_agency_id"] = $param["id"];
$value["ip_address"] = implode(".", $param["ip_address"]);
$userSearchSessOBJ = new ComSessionNamespace("user_search");
$messageSessOBJ = new ComSessionNamespace("exec_msg");
$returnSessOBJ = new ComSessionNamespace("return");
$errSessOBJ = new ComSessionNamespace("err");
$requestOBJ->setParameter("sesKey", $param["sesKey"]);
$tags = array("sesKey");
$URLparam = $requestOBJ->makeGetTag($tags);
// セッション変数の取得
if ($param["sesKey"]) {
$searchParam = $userSearchSessOBJ->{$param}["sesKey"];
} else {
$errSessOBJ->errMsg = "パラメータがありません";
header("location: ./?action_user_Search");
exit;
}
if (!ComValidation::isNumeric($param["number"])) {
$messageSessOBJ->message[] = "抽出件数がありません";
$returnSessOBJ->return = $param;
$AdmUnitOBJ->rollbackTransaction();
header("Location: ./?action_lotteryUnit_UnitCreate=1&" . $URLparam);
exit;
}
$whereArray = $AdmUserOBJ->setWhereString($searchParam);
$contents = $AdmUserOBJ->getWhereContents();
$AdmUnitOBJ->beginTransaction();
// ユニット登録
$insertLotteryUnitData["create_datetime"] = date("YmdHis");
$insertLotteryUnitData["comment"] = $param["comment"];
$insertLotteryUnitData["number"] = $param["number"];
// 検索条件登録
$insertLotteryUnitData["search_condition"] = $requestOBJ->getParameterEscape(serialize($searchParam), "sql");
/**
* サポートメール送信ログリストの取得。
*
* @return mixed サポートメール送信ログリスト、失敗ならfalse
*/
public function getSupportMailSendLogList($param = "", $offset = "", $order = "", $limit = "")
{
$columnArray[] = "SQL_CALC_FOUND_ROWS *";
$whereArray[] = "disable = 0";
if (ComValidation::isDatetime($param["dispDatetimeFrom"])) {
$whereArray[] = "create_datetime >= '" . $param["dispDatetimeFrom"] . "'";
}
if (ComValidation::isDatetime($param["dispDatetimeTo"])) {
$whereArray[] = "create_datetime <= '" . $param["dispDatetimeTo"] . "'";
}
if (ComValidation::isArray($param["mail_reserve_type"])) {
$whereArray[] = "mail_reserve_type IN (" . implode(",", $param["mail_reserve_type"]) . ")";
}
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("support_mail_send_log", $columnArray, $whereArray, $otherArray);
if ($dbResultOBJ = $this->executeQuery($sql)) {
$dataArray = $this->fetchAll($dbResultOBJ);
} else {
return FALSE;
}
return $dataArray;
}
/**
*
* 問い合わせリストの取得
*
* @param array $param パラメーター
* @param integer $offset オフセット
* @param string $order 表示順
* @param integer $limit 表示件数
*
* @return array $dataList データ配列
*/
public function getContactList($param, $offset, $order, $limit)
{
$columnArray[] = "SQL_CALC_FOUND_ROWS *";
$whereArray[] = "disable = 0";
if (ComValidation::isArray($param["contact_type_id"])) {
$whereArray[] = "type IN (" . implode(",", $param["contact_type_id"]) . ")";
}
if (ComValidation::isArray($param["is_answer"])) {
$whereArray[] = "is_answer IN (" . implode(",", $param["is_answer"]) . ")";
}
if ($param["from_address"]) {
$whereArray[] = "from_address LIKE '" . $param["from_address"] . "%'";
}
if (ComValidation::isDateTime($param["start_datetime"])) {
$whereArray[] = "create_datetime >= '" . $param["start_datetime"] . "'";
}
if (ComValidation::isDateTime($param["end_datetime"])) {
$whereArray[] = "create_datetime <= '" . $param["end_datetime"] . "'";
}
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("contact", $columnArray, $whereArray, $otherArray);
if (!($dbResultOBJ = $this->executeQuery($sql))) {
return FALSE;
}
// データリスト取得
$dataList = $this->fetchAll($dbResultOBJ);
return $dataList;
}
$messageSessOBJ = new ComSessionNamespace("exec_msg");
$returnSessOBJ = new ComSessionNamespace("return");
$errSessOBJ = new ComSessionNamespace("err");
$requestOBJ->setParameter("sesKey", $param["sesKey"]);
$tags = array("sesKey", "search_conditions_id");
$URLparam = $requestOBJ->makeGetTag($tags);
// セッション変数の取得
if ($param["sesKey"]) {
$searchParam = $userSearchSessOBJ->{$param}["sesKey"];
} else {
$errSessOBJ->errMsg = "パラメータがありません";
header("location: ./?action_user_Search=1");
exit;
}
if ($param["search_conditions_id"]) {
if (!ComValidation::isNumeric($param["search_conditions_id"])) {
$messageSessOBJ->message[] = "更新する検索条件保存IDを数値で入力してください。";
$returnSessOBJ->return = $param;
header("Location: ./?action_user_ExecEnd=1&" . $URLparam);
exit;
}
if (!$AdminUserOBJ->getUserSearchConditionData($param["search_conditions_id"])) {
$messageSessOBJ->message[] = "検索条件保存データがありません";
$returnSessOBJ->return = $param;
header("Location: ./?action_user_ExecEnd=1&" . $URLparam);
exit;
}
// 検索条件登録
$updateSearchConditionData["update_datetime"] = date("YmdHis");
if ($param["comment"]) {
$updateSearchConditionData["comment"] = $param["comment"];
/**
*
* 注文変更ログリストの取得
*
* @param array $param パラメーター
* @param integer $offset オフセット
* @param string $order 表示順
* @param integer $limit 表示件数
*
* @return array $dataList データ配列
*/
public function getOrderingChangeLogList($param, $offset = "", $order = "", $limit = "")
{
$columnArray[] = "SQL_CALC_FOUND_ROWS item.name";
$columnArray[] = "ordering.create_datetime as ordering_create_datetime";
$columnArray[] = "order_change_log.ordering_id";
$columnArray[] = "order_change_log.price";
$columnArray[] = "order_change_log.status";
$columnArray[] = "order_change_log.create_datetime as order_change_log_create_datetime";
$whereArray[] = "item.id = order_change_log.item_id";
$whereArray[] = "order_change_log.ordering_id = ordering.id";
$whereArray[] = "ordering.disable = 0";
$whereArray[] = "order_change_log.disable = 0";
if (ComValidation::isArray($param["pay_type"])) {
$whereArray[] = "ordering.pay_type IN (" . implode(",", $param["pay_type"]) . ")";
}
if (ComValidation::isArray($param["status"])) {
$whereArray[] = "order_change_log.status IN (" . implode(",", $param["status"]) . ")";
}
if (ComValidation::isNumeric($param["search_ordering_id"])) {
$whereArray[] = "ordering.id = " . $param["search_ordering_id"];
}
if (ComValidation::isDateTime($param["order_start_datetime"])) {
$whereArray[] = "ordering.create_datetime >= '" . $param["order_start_datetime"] . "'";
}
if (ComValidation::isDateTime($param["order_end_datetime"])) {
$whereArray[] = "ordering.create_datetime <= '" . $param["order_end_datetime"] . "'";
}
if (ComValidation::isDate($param["change_start_datetime"])) {
$whereArray[] = "order_change_log.create_datetime >= '" . $param["change_start_datetime"] . "'";
}
if (ComValidation::isDate($param["change_end_datetime"])) {
$whereArray[] = "order_change_log.create_datetime <= '" . $param["change_end_datetime"] . "'";
}
if ($order) {
$otherArray[] = " ORDER BY " . $order;
}
if (ComValidation::isNumeric($offset)) {
$otherArray[] = " LIMIT " . $offset . ", " . $limit;
}
$sql = $this->makeSelectQuery("order_change_log, ordering, item", $columnArray, $whereArray, $otherArray);
if (!($dbResultOBJ = $this->executeQuery($sql))) {
return FALSE;
}
// データリスト取得
$dataList = $dbResultOBJ->fetchAll();
return $dataList;
}
} else {
$userAry["pc_send_status"] = 1;
}
}
// userテーブルへのインサート処理
if (!$UserOBJ->insertUserData($userAry)) {
$UserOBJ->rollbackTransaction();
exit;
}
$userId = $UserOBJ->getInsertId();
$profileAry = array("user_id" => $userId, "by_user_update_datetime" => $currentDateTime, "update_datetime" => $currentDateTime);
if (ComValidation::isNumeric($aryAffiliateValue["s"])) {
$profileAry["sex_cd"] = $aryAffiliateValue["s"];
}
// タイムスタンプで来る
if (ComValidation::isNumeric($aryAffiliateValue["b"])) {
$profileAry["birth_date"] = date("Y-m-d", $aryAffiliateValue["b"]);
}
// 指定の媒体からの登録は受信ステータスを『受け取らない』にする
// 以下、そのうち処理毎消します。2010-11-30 hosoda
if ($aryAffiliateValue["advcd"] == "to20016") {
$preRegistData["is_no_send_status"] = 1;
}
if ($mbFlag) {
$profileAry["mb_is_mailmagazine"] = $preRegistData["is_no_send_status"] ? $_config["define"]["ADDRESS_SEND_STATUS_FAIL"] : $_config["define"]["ADDRESS_SEND_STATUS_DO"];
} else {
$profileAry["pc_is_mailmagazine"] = $preRegistData["is_no_send_status"] ? $_config["define"]["ADDRESS_SEND_STATUS_FAIL"] : $_config["define"]["ADDRESS_SEND_STATUS_DO"];
}
// profileテーブルへのインサート処理
if (!$UserOBJ->insertProfileData($profileAry)) {
$UserOBJ->rollbackTransaction();
exit;
}
}
$messageSessOBJ->message = array("更新しました。");
// 新規
} else {
if (!ComValidation::isNumeric($param["cd"])) {
$errMsg[] = "情報表示場所を選択してください";
}
if (!ComValidation::isNumeric($param["is_display"])) {
$errMsg[] = "表示状態は数値で入力してください";
}
if (!ComValidation::isNumeric($param["mb_sort_seq"])) {
$errMsg[] = "MB表示順は数値で入力してください";
}
if (!ComValidation::isNumeric($param["pc_sort_seq"])) {
$errMsg[] = "PC表示順は数値で入力してください";
}
// エラー判定
if ($errMsg) {
$messageSessOBJ->message = $errMsg;
$param["return_cd"] = "position";
$returnSessOBJ->return = $param;
header("Location: ./?action_informationDisplayPosition_InformationDisplayPositionUpd=1&fid=" . $param["fid"]);
exit;
}
$value["information_category_id"] = $param["fid"];
$value["cd"] = $param["cd"];
$value["mb_sort_seq"] = $param["mb_sort_seq"];
$value["pc_sort_seq"] = $param["pc_sort_seq"];
$value["is_display"] = $param["is_display"];
require_once D_BASE_DIR . "/common/admin_common.php";
$param = $requestOBJ->getParameterExcept($exceptArray);
$AdmCalculationOBJ = AdmCalculation::getInstance();
// 売り上げ総金額
$columnArray = "";
$whereArray = "";
$otherArray = "";
$columnArray[] = "p.pay_type";
$columnArray[] = "SUM(p.receive_money) AS pay_total";
$columnArray[] = "CAST(p.create_datetime AS DATE) AS payment_date";
$whereArray[] = "o.disable = 0";
$whereArray[] = "o.is_paid = 1";
$whereArray[] = "o.is_cancel = 0";
$whereArray[] = "o.status IN (" . AdmOrdering::ORDERING_STATUS_PRE_COMPLETE . ", " . AdmOrdering::ORDERING_STATUS_COMPLETE . ", " . AdmOrdering::ORDERING_STATUS_REST . ")";
$otherArray[] = "GROUP BY payment_date, o.id ORDER BY payment_date";
if (ComValidation::isDate($param["date"])) {
$whereArray[] = "p.create_datetime >= '" . date("Y-m-01 00:00:00", strtotime($param["date"])) . "'";
$whereArray[] = "p.create_datetime <= '" . date("Y-m-t 23:59:59", strtotime($param["date"])) . "'";
}
$orderingSalesDataList = $AdmCalculationOBJ->getCalcSalesList($param, $columnArray, $whereArray, $otherArray);
if ($orderingSalesDataList) {
foreach ((array) $orderingSalesDataList as $val) {
// 入金種別毎の集計
$dispDataList[date("w", strtotime($val["payment_date"]))][$val["pay_type"]] += $val["pay_total"];
$totalPay += $val["pay_total"];
}
foreach ((array) $_config["admin_config"]["week_array"] as $weekKey => $weekVal) {
foreach ((array) AdmOrdering::$_payType as $key => $val) {
$jsPaymentDataList[$key][] = "[" . ($dispDataList[$weekKey][$key] ? $dispDataList[$weekKey][$key] : 0) . "," . ($weekKey + 1) . "]";
}
}
/**
* ユーザー検索の条件文の作成
*
* @param array $param データ配列
* @param array $addWhereArray 追加条件*
*
* @return array 検索条件文配列
*/
public function setWhereString($param, $addWhereArray)
{
$addWhereArray[] = "u.user_disable = 0";
$addWhereArray[] = "u.admin_id = 0";
if (!$param and !$addWhereArray) {
return $where;
}
$where = $addWhereArray;
// PCアドレス
if ($param["pc_address_specify"]) {
// あり
if ($param["pc_address_specify"] == 1) {
$where[] = "u.pc_address != ''";
// なし
} else {
if ($param["pc_address_specify"] == 2) {
$where[] = "u.pc_address = ''";
}
}
}
// MBアドレス
if ($param["mb_address_specify"]) {
// あり
if ($param["mb_address_specify"] == 1) {
$where[] = "u.mb_address != ''";
// なし
} else {
if ($param["mb_address_specify"] == 2) {
$where[] = "u.mb_address = ''";
}
}
}
// PCデバイス
if (ComValidation::isArray($param["pc_device_cd"])) {
$where[] = "u.pc_device_cd IN (" . implode(",", $param["pc_device_cd"]) . ")";
}
// MBデバイス
if (ComValidation::isArray($param["mb_device_cd"])) {
$where[] = "u.mb_device_cd IN (" . implode(",", $param["mb_device_cd"]) . ")";
}
// 性別
if (ComValidation::isArray($param["sex_cd"])) {
$where[] = "u.sex_cd IN (" . implode(",", $param["sex_cd"]) . ")";
}
/** 媒体コード */
if ($param["media_cd"]) {
$mediaCdArray = explode(",", $param["media_cd"]);
foreach ($mediaCdArray as $key => $val) {
$mediaCdArray[$key] = "u.media_cd LIKE '" . $val . "'";
}
$where[] = "(" . implode(" OR ", $mediaCdArray) . ")";
}
// 登録入口カテゴリー
if ($param["regist_page_category_id"]) {
// ダイレクト登録
if (is_numeric(array_search(0, $param["regist_page_category_id"]))) {
$subWhere = " OR u.regist_page_id = 0";
}
$where[] = "(EXISTS (" . " SELECT u.user_id FROM regist_page" . " WHERE regist_page.regist_page_category_id IN (" . implode(",", $param["regist_page_category_id"]) . ")" . " AND regist_page.id = u.regist_page_id)" . $subWhere . ")";
}
// 登録入口ID
if ($param["regist_page_id"]) {
if (!in_array("", explode(",", $param["regist_page_id"]))) {
$where[] = "u.regist_page_id IN (" . $param["regist_page_id"] . ")";
}
}
// 対象外登録入り口ID
if ($param["except_regist_page_id"]) {
if (!in_array("", explode(",", $param["except_regist_page_id"]))) {
$where[] = "u.regist_page_id NOT IN (" . $param["except_regist_page_id"] . ")";
}
}
/** 媒体コード */
if ($param["select_media_cd"]) {
$where[] = "u.media_cd = '" . $param["select_media_cd"] . "'";
}
return $where;
}
