PHP ComValidation::isDatetime方法代码示例

 /**
  * 管理画面アクセス情報の取得。
  *
  * @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;
 }

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

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

// インスタンスの作成
$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":

 * @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"];

 /**
  * サポートメール送信ログリストの取得。
  *
  * @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;
 }

require_once $controllerOBJ->getIncludeBusinessLogic("admInclude");
$AdmBannerOBJ = AdmBanner::getInstance();
$offset = $requestOBJ->getParameter("offset");
if (!$offset) {
    $offset = 0;
}
$exceptArray[] = "offset";
$param = $requestOBJ->getParameterExcept($exceptArray);
$dispCnt = 20;
// 入力日時の生成
$param["searchDatetimeFrom"] = $param["search_datetime_from_Date"] . " " . $param["search_datetime_from_Time"];
if (!ComValidation::isDatetime($param["searchDatetimeFrom"])) {
    $param["searchDatetimeFrom"] = date("H:00:00");
}
$param["searchDatetimeTo"] = $param["search_datetime_to_Date"] . " " . $param["search_datetime_to_Time"];
if (!ComValidation::isDatetime($param["searchDatetimeTo"])) {
    $param["searchDatetimeTo"] = date("H:00:00");
}
$smartyOBJ->assign("param", $param);
$bannerList = $AdmBannerOBJ->getBannerList($param, $offset, "id DESC", $dispCnt);
$totalCount = $AdmBannerOBJ->getFoundRows();
$dispFirst = $offset + 1;
$dispLast = $offset + count($bannerList);
$smartyOBJ->assign("bannerList", $bannerList);
$smartyOBJ->assign("totalCount", $totalCount);
$smartyOBJ->assign("dispFirst", $dispFirst);
$smartyOBJ->assign("dispLast", $dispLast);
$tags = array("category_id", "extension_type", "search_type", "specify_keyword", "search_string", "search_datetime_from_Date", "search_datetime_from_Time", "search_datetime_to_Date", "search_datetime_to_Time");
$reloadTags = array("category_id", "extension_type", "search_type", "specify_keyword", "search_string", "search_datetime_from_Date", "search_datetime_from_Time", "search_datetime_to_Date", "search_datetime_to_Time", "offset");
$URLparam = $requestOBJ->makeGetTag($tags);
$reloadParam = $requestOBJ->makePostTag($reloadTags);

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

 /**
  * 定期メルマガリストの取得。
  *
  * @return mixed 定期メルマガリスト、失敗ならfalse
  */
 public function getMailRegularList($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["send_condition_type"] != "") {
         if (ComValidation::isArray($param["send_condition_type"])) {
             $whereArray[] = "send_condition_type IN (" . implode(",", $param["send_condition_type"]) . ")";
         }
     }
     //稼働状況
     if (!ComValidation::isEmpty($param["is_stop"])) {
         $whereArray[] = "is_stop = " . $param["is_stop"];
     }
     //定期メルマガID
     if ($param["id"]) {
         if ($param["id"]) {
             $whereArray[] = "id IN (" . trim($param["id"], ",") . ")";
         }
     }
     //メルマガ件名検索
     if ($param["mailmagazine_subject"]) {
         $whereArray[] = "(pc_subject like '%" . $param["mailmagazine_subject"] . "%'" . " OR mb_subject like '%" . $param["mailmagazine_subject"] . "%')";
     }
     //メルマガ本文検索
     if ($param["mailmagazine_body"]) {
         $whereArray[] = "(pc_text_body like '%" . $param["mailmagazine_body"] . "%' OR pc_html_body like '%" . $param["mailmagazine_body"] . "%'" . " OR mb_text_body like '%" . $param["mailmagazine_body"] . "%' OR mb_html_body like '%" . $param["mailmagazine_body"] . "%')";
     }
     if ($order) {
         $otherArray[] = " ORDER BY " . $order;
     }
     if (ComValidation::isNumeric($offset)) {
         $otherArray[] = " LIMIT " . $offset . ", " . $limit;
     }
     $sql = $this->makeSelectQuery("mailmagazine_regular", $columnArray, $whereArray, $otherArray);
     if ($dbResultOBJ = $this->executeQuery($sql)) {
         $dataArray = $this->fetchAll($dbResultOBJ);
     } else {
         return FALSE;
     }
     return $dataArray;
 }

$smartyOBJ->assign("execMsg", $execMsgSessOBJ->getIterator());
// セッション変数の破棄
$execMsgSessOBJ->unsetAll();
$AdmOrderChangeLogOBJ = AdmOrderChangeLog::getInstance();
$AdmItemOBJ = AdmItem::getInstance();
// 入力日時の生成
$param["order_start_datetime"] = $param["order_start_datetime_Date"] . " 00:00:00";
if (!ComValidation::isDatetime($param["order_start_datetime"])) {
    if (!$param["search_flag"]) {
        $param["order_start_datetime"] = date("Y-m-01 00:00:00");
    } else {
        $param["order_start_datetime"] = "";
    }
}
$param["order_end_datetime"] = $param["order_end_datetime_Date"] . " 23:59:59";
if (!ComValidation::isDatetime($param["order_end_datetime"])) {
    $param["order_end_datetime"] = "";
}
$param["change_start_datetime"] = $param["change_start_datetime_Date"] . " 00:00:00";
if (!ComValidation::isDate($param["change_start_datetime"])) {
    $param["change_start_datetime"] = "";
}
$param["change_end_datetime"] = $param["change_end_datetime_Date"] . " 23:59:59";
if (!ComValidation::isDate($param["change_end_datetime"])) {
    $param["change_end_datetime"] = "";
}
// セッションにセットします
if ($param["sesKey"]) {
    $sesKey = $param["sesKey"];
    $param = $orderingSearchSessOBJ->{$param}["sesKey"];
} else {

$requestOBJ->setParameter("sesKey", $sesKey);
// 入力日時の生成
$param["order_start_datetime"] = $param["order_start_datetime_Date"] . " " . $param["order_start_datetime_Time"];
if (!ComValidation::isDatetime($param["order_start_datetime"])) {
    $param["order_start_datetime"] = date("Y-m-d") . " 00:00:00";
}
$param["order_end_datetime"] = $param["order_end_datetime_Date"] . " " . $param["order_end_datetime_Time"];
if (!ComValidation::isDatetime($param["order_end_datetime"])) {
    $param["order_end_datetime"] = date("Y-m-d") . " 23:59:59";
}
$param["paid_start_datetime"] = $param["paid_start_datetime_Date"] . " " . $param["paid_start_datetime_Time"];
if (!ComValidation::isDatetime($param["paid_start_datetime"])) {
    $param["paid_start_datetime"] = date("Y-m-d") . " 00:00:00";
}
$param["paid_end_datetime"] = $param["paid_end_datetime_Date"] . " " . $param["paid_end_datetime_Time"];
if (!ComValidation::isDatetime($param["paid_end_datetime"])) {
    $param["paid_end_datetime"] = date("Y-m-d") . " 23:59:59";
}
// 注文リストの取得
if ($param["search_flag"]) {
    $orderingList = $AdmOrderingOBJ->getOrderingList($param, $offset, "ordering.id DESC", $dispCnt);
    $totalCount = $AdmOrderingOBJ->getFoundRows();
    $dispFirst = $offset + 1;
    $dispLast = $offset + count($orderingList);
    foreach ((array) $orderingList as $key => $val) {
        // 商品詳細の取得
        $itemList[$key] = $AdmItemOBJ->getOrderingDetailItemList($val["id"]);
        // 変更商品詳細の取得
        $changeItemList[$key] = $AdmOrderChangeLogOBJ->getChangeItemList($val["id"]);
        foreach ($changeItemList[$key] as $chgVal) {
            $changeItemTotalMoney[$key] += $chgVal["price"];

        $keyConvertContentsData = $returnValue;
        $keyConvertContentsData["return_flag"] = 1;
    }
} else {
    if ($returnValue["return_cd"] == "list") {
        $keyConvertData["return_flag"] = 0;
    } else {
        $keyConvertContentsData["return_flag"] = 0;
    }
}
$dispDatetimeFrom = $keyConvertContentsData["disp_datetime_from_date"] . " " . $keyConvertContentsData["disp_datetime_from_time"];
if (ComValidation::isDatetime($dispDatetimeFrom)) {
    $keyConvertContentsData["display_start_datetime"] = $dispDatetimeFrom;
} else {
    $keyConvertContentsData["display_start_datetime"] = date("Y-m-d 00:00:00");
}
$dispDatetimeTo = $keyConvertContentsData["disp_datetime_to_date"] . " " . $keyConvertContentsData["disp_datetime_to_time"];
if (ComValidation::isDatetime($dispDatetimeTo)) {
    $keyConvertContentsData["display_end_datetime"] = $dispDatetimeTo;
} else {
    $keyConvertContentsData["display_end_datetime"] = "";
}
$smartyOBJ->assign("keyConvertData", $keyConvertData);
$smartyOBJ->assign("keyConvertContentsData", $keyConvertContentsData);
$smartyOBJ->assign("keyConvertContentsList", $keyConvertContentsList);
$categoryList = $AdmKeyConvertOBJ->getKeyConvertCategoryForSelect();
$smartyOBJ->assign("categoryList", $categoryList);
$tags = array("key_convert_list_id");
$POSTparam = $requestOBJ->makePostTag($tags);
$smartyOBJ->assign("POSTparam", $POSTparam);
$smartyOBJ->assign("reloadParam", $POSTparam);

 /**
  * 注文検索の条件文の作成
  *
  * @param  array $param データ配列
  * @return array 検索条件文配列
  */
 public function setWhereString($param)
 {
     $whereArray[] = "v_user.user_disable = 0";
     // 注文日付
     switch ($param["specify_order_date"]) {
         case 1:
             $orderDatetimeFrom = $param["order_start_datetime_Date"] . " " . $param["order_start_datetime_Time"];
             $orderDatetimeTo = $param["order_end_datetime_Date"] . " " . $param["order_end_datetime_Time"];
             if (ComValidation::isDatetime($orderDatetimeFrom)) {
                 $whereArray[] = "ordering.create_datetime >= '" . $orderDatetimeFrom . "'";
                 $orderDatetime["from"] = $orderDatetimeFrom;
             }
             if (ComValidation::isDatetime($orderDatetimeTo)) {
                 $whereArray[] = "ordering.create_datetime <= '" . $orderDatetimeTo . "'";
                 $orderDatetime["to"] = $orderDatetimeTo;
             }
             if ($orderDatetime) {
                 $this->_contents["注文日付"] = $orderDatetime["from"] . " ～ " . $orderDatetime["to"];
             }
             break;
         case 2:
         case 3:
         case 4:
         case 5:
         case 6:
             $whereArray[] = "ordering.create_datetime >= '" . date("Y-m-d H:i:00", strtotime($this->datetimeParameter[$param["specify_order_date"]])) . "'";
             $this->_contents["注文日付"] = $this->_configOBJ->admin_config->specify_date_time_select->{$param}["specify_order_date"];
             break;
         case 7:
             // 不等号に気をつける！
             // 小さい値
             if (ComValidation::isNumeric($param["order_time_from"])) {
                 $whereArray[] = "ordering.create_datetime <= '" . date("Y-m-d H:i:59", strtotime("-" . $param["order_time_from"] . " hour")) . "'";
                 $orderDatetime["from"] = $param["order_time_from"] . "時間前以上";
             }
             // 大きい値
             if (ComValidation::isNumeric($param["order_time_to"])) {
                 $whereArray[] = "ordering.create_datetime >= '" . date("Y-m-d H:i:00", strtotime("-" . $param["order_time_to"] . " hour")) . "'";
                 $orderDatetime["to"] = $param["order_time_to"] . "時間前まで";
             }
             if ($orderDatetime) {
                 $this->_contents["注文日付"] = $orderDatetime["from"] . " " . $orderDatetime["to"];
             }
             break;
         default:
             break;
     }
     // 決済完了日付
     switch ($param["specify_paid_date"]) {
         case 1:
             $paidDatetimeFrom = $param["paid_start_datetime_Date"] . " " . $param["paid_start_datetime_Time"];
             $paidDatetimeTo = $param["paid_end_datetime_Date"] . " " . $param["paid_end_datetime_Time"];
             if (ComValidation::isDatetime($paidDatetimeFrom)) {
                 $whereArray[] = "ordering.paid_datetime >= '" . $paidDatetimeFrom . "'";
                 $paidDatetime["from"] = $paidDatetimeFrom;
             }
             if (ComValidation::isDatetime($paidDatetimeTo)) {
                 $whereArray[] = "ordering.paid_datetime <= '" . $paidDatetimeTo . "'";
                 $paidDatetime["to"] = $paidDatetimeTo;
             }
             if ($paidDatetime) {
                 $this->_contents["決済完了日付"] = $paidDatetime["from"] . " ～ " . $paidDatetime["to"];
             }
             break;
         case 2:
         case 3:
         case 4:
         case 5:
         case 6:
             $whereArray[] = "ordering.paid_datetime >= '" . date("Y-m-d H:i:00", strtotime($this->datetimeParameter[$param["specify_paid_date"]])) . "'";
             $this->_contents["決済完了日付"] = $this->_configOBJ->admin_config->specify_date_time_select->{$param}["specify_paid_date"];
             break;
         case 7:
             // 不等号に気をつける！
             // 小さい値
             if (ComValidation::isNumeric($param["paid_time_from"])) {
                 $whereArray[] = "ordering.paid_datetime <= '" . date("Y-m-d H:i:59", strtotime("-" . $param["paid_time_from"] . " hour")) . "'";
                 $paidDatetime["from"] = $param["paid_time_from"] . "時間前以上";
             }
             // 大きい値
             if (ComValidation::isNumeric($param["paid_time_to"])) {
                 $whereArray[] = "ordering.paid_datetime >= '" . date("Y-m-d H:i:00", strtotime("-" . $param["paid_time_to"] . " hour")) . "'";
                 $paidDatetime["to"] = $param["paid_time_to"] . "時間前まで";
             }
             if ($paidDatetime) {
                 $this->_contents["決済完了日付"] = $paidDatetime["from"] . " " . $paidDatetime["to"];
             }
             break;
         default:
             break;
     }
     if (ComValidation::isNumeric($param["user_id"])) {
         $whereArray[] = "ordering.user_id = " . $param["user_id"];
         $this->_contents["ユーザーID"] = $param["user_id"];
//.........这里部分代码省略.........

 /**
  * ユーザー検索の条件文の作成
  *
  * @param  array $param データ配列
  * @return array 検索条件文配列
  */
 public function setWhereString($param)
 {
     $where[] = "v_user_profile.user_disable = 0";
     // ユーザーID
     if ($param["user_id"]) {
         if (!in_array("", explode(",", $param["user_id"]))) {
             // ユーザーIDを含む
             if ($param["user_id_specify_target_including"]) {
                 $where[] = "v_user_profile.user_id IN (" . $param["user_id"] . ")";
                 $this->_contents["ユーザーID"] = $param["user_id"] . "を含む";
             } else {
                 $where[] = "v_user_profile.user_id NOT IN (" . $param["user_id"] . ")";
                 $this->_contents["ユーザーID"] = $param["user_id"] . "を含まない";
             }
         }
     }
     // 性別
     if (ComValidation::isArray($param["sex_cd"])) {
         $where[] = "v_user_profile.sex_cd IN (" . implode(",", $param["sex_cd"]) . ")";
         foreach ($param["sex_cd"] as $key => $val) {
             $sexName[] = $this->_configOBJ->admin_config->sex_cd->{$val};
         }
         $this->_contents["性別"] = implode(", ", $sexName);
     }
     //生年月日
     switch ($param["specify_birth_day"]) {
         case 1:
             $where[] = "v_user_profile.birth_date != '0000-00-00'";
             $this->_contents["生年月日"] = "有り";
             break;
         case 2:
             $where[] = "v_user_profile.birth_date = '0000-00-00'";
             $this->_contents["生年月日"] = "無し";
             break;
         case 3:
             $birthDayDatetimeFrom = $param["birth_day_from_Date"] . " " . "00:00:00";
             $birthDayDatetimeTo = $param["birth_day_to_Date"] . " " . "00:00:00";
             if (ComValidation::isDatetime($birthDayDatetimeFrom)) {
                 $birthDayDatetime["from"] = $birthDayDatetimeFrom;
             }
             if (ComValidation::isDatetime($birthDayDatetimeTo)) {
                 $birthDayDatetime["to"] = $birthDayDatetimeTo;
             }
             if ($birthDayDatetime) {
                 $where[] = "v_user_profile.birth_date >='" . date("Ymd", strtotime($birthDayDatetimeFrom)) . "' AND " . "v_user_profile.birth_date <='" . date("Ymd", strtotime($birthDayDatetimeTo)) . "'";
                 $this->_contents["生年月日"] = $birthDayDatetimeFrom . " ～ " . $birthDayDatetimeTo;
             }
             break;
         case 4:
             $where[] = "v_user_profile.birth_date != '0000-00-00'";
             $where[] = "MONTH(v_user_profile.birth_date) = " . date("m");
             $where[] = "DAY(v_user_profile.birth_date) = " . date("d");
             $this->_contents["生年月日"] = "本日";
             break;
         default:
             break;
     }
     //年齢
     if ($param["user_age_from"] or $param["user_age_to"]) {
         $searchAgeSqAry = array();
         $searchAgeSql = "";
         // 年齢 ～以上
         if ($param["user_age_from"]) {
             $fromAgeParam = "-" . $param["user_age_from"] . " YEAR";
             $fromBirthday = date("Y-m-d", strtotime($fromAgeParam));
             $searchAgeSqAry[] = "v_user_profile.birth_date <='" . $fromBirthday . "'";
             if (!$param["user_age_to"] and !$param["user_age_no_data"]) {
                 $where[] = "v_user_profile.birth_date !='0000-00-00'";
             }
             $this->_contents["年齢"] .= "『" . $param["user_age_from"] . "』歳以上<br>";
         }
         // 年齢 ～未満
         if ($param["user_age_to"]) {
             $toAge = $param["user_age_to"] + 1;
             $toAgeParam = "-" . $toAge . " YEAR  +1 DAY";
             $toBirthday = date("Y-m-d", strtotime($toAgeParam));
             $searchAgeSqAry[] = "v_user_profile.birth_date >='" . $toBirthday . "'";
             $this->_contents["年齢"] .= "『" . $param["user_age_to"] . "』歳以下<br>";
         }
         $searchAgeSql = "(" . implode(" AND ", $searchAgeSqAry) . ")";
         if ($param["user_age_no_data"]) {
             $where[] = "(" . $searchAgeSql . "OR v_user_profile.birth_date ='0000-00-00' )";
             $this->_contents["年齢"] .= "未入力を含む<br>";
         } else {
             $where[] = $searchAgeSql;
             $this->_contents["年齢"] .= "未入力を含まない<br>";
         }
     }
     // 干支
     if ($param["sexagenary_cycle"]) {
         $sexagenaryCycleBaseAry = array(1 => 1900, 2 => 1901, 3 => 1902, 4 => 1903, 5 => 1904, 6 => 1905, 7 => 1906, 8 => 1907, 9 => 1908, 10 => 1909, 11 => 1910, 12 => 1911);
         foreach ($param["sexagenary_cycle"] as $key => $val) {
             $sexagenaryCycleBase = $sexagenaryCycleBaseAry[$val];
             $sexagenaryCycleNameAry[] = $this->_configOBJ->admin_config->specify_sexagenary_cycle_select->{$val};
//.........这里部分代码省略.........

}
$birthDayDatetimeTo = $value["birth_day_to_Date"];
if (ComValidation::isDate($birthDayDatetimeTo)) {
    $smartyOBJ->assign("birthDayDatetimeTo", $birthDayDatetimeTo);
} else {
    $smartyOBJ->assign("birthDayDatetimeTo", date("Y-m-d"));
}
// 期間購入金額日時の生成
$termsPayDatetimeFrom = $value["terms_pay_from_Date"] . " " . $value["terms_pay_from_Time"];
if (ComValidation::isDatetime($termsPayDatetimeFrom)) {
    $smartyOBJ->assign("termsPayDatetimeFrom", $termsPayDatetimeFrom);
} else {
    $smartyOBJ->assign("termsPayDatetimeFrom", date("Y-m-d H:0:0"));
}
$termsPayDatetimeTo = $value["terms_pay_to_Date"] . " " . $value["terms_pay_to_Time"];
if (ComValidation::isDatetime($termsPayDatetimeTo)) {
    $smartyOBJ->assign("termsPayDatetimeTo", $termsPayDatetimeTo);
} else {
    $smartyOBJ->assign("termsPayDatetimeTo", date("Y-m-d H:0:0"));
}
$smartyOBJ->assign("limit", array("30" => "30", "50" => "50", "100" => "100"));
$smartyOBJ->assign("order", array("user_id DESC" => "ID", "last_access_datetime DESC" => "アクセス日時", "regist_datetime DESC" => "登録日時"));
$defaultRegistUserStatus = array($_config["define"]["USER_REGIST_STATUS_PRE_MEMBER"], $_config["define"]["USER_REGIST_STATUS_MEMBER"]);
$smartyOBJ->assign("defaultRegistUserStatus", $defaultRegistUserStatus);
// 管理ﾎﾞｯｸｽ
$AdmAdminOBJ = AdmAdmin::getInstance();
$adminList = $AdmAdminOBJ->getListForSelect();
$smartyOBJ->assign("adminList", array("" => "指定なし") + AdmAdmin::$_searchArray + (array) $adminList);
// サイト間登録
$AdmRegistSiteOBJ = AdmRegistSite::getInstance();
$registSiteList = $AdmRegistSiteOBJ->getListForSelect();