/** * * @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; }