PHP ComValidation::isArray方法代码示例

 /**
  *
  * 注文変更ログリストの取得
  *
  * @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;
 }

 /**
  * ユーザー検索の条件文の作成
  *
  * @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;
 }

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

            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;

 /**
  *
  * 問い合わせリストの取得
  *
  * @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;
 }

 /**
  * 定期メルマガリストの取得。
  *
  * @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;
 }

//.........这里部分代码省略.........
             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"];
     }
     if (!ComValidation::isNumeric($param["is_quit"])) {
         $whereArray[] = "v_user.regist_status != " . $this->_configOBJ->define->USER_REGIST_STATUS_MEMBER_QUIT;
     } else {
         $this->_contents["会員解除"] = "会員解除ユーザーも含む";
     }
     if (!ComValidation::isNumeric($param["is_danger"])) {
         $whereArray[] = "v_user.danger_status != " . $this->_configOBJ->define->DANGER_VALID;
     } else {
         $this->_contents["ブラック"] = "ブラックユーザーも含む";
     }
     if (ComValidation::isNumeric($param["search_ordering_id"])) {
         $whereArray[] = "ordering.id = " . $param["search_ordering_id"];
         $this->_contents["注文ID"] = $param["search_ordering_id"];
     }
     if (ComValidation::isNumeric($param["search_item_id"])) {
         $whereArray[] = "ordering_detail.item_id = " . $param["search_item_id"];
         $this->_contents["商品ID"] = $param["search_item_id"];
     }
     if ($param["pc_address"]) {
         $whereArray[] = "v_user.pc_address LIKE '" . $param["pc_address"] . "%'";
         $this->_contents["PCアドレス"] = "前方一致 : " . $param["pc_address"];
     }
     if ($param["mb_address"]) {
         $whereArray[] = "v_user.mb_address LIKE '" . $param["mb_address"] . "%'";
         $this->_contents["MBアドレス"] = "前方一致 : " . $param["mb_address"];
     }
     if (ComValidation::isArray($param["order_status"])) {
         $whereArray[] = "ordering.status IN (" . implode(",", $param["order_status"]) . ")";
         foreach ($param["order_status"] as $val) {
             $orderStatus[] = AdmOrdering::$_orderStatus[$val];
         }
         $this->_contents["注文ステータス"] = implode("、", $orderStatus);
     }
     if (ComValidation::isArray($param["pay_type"])) {
         $whereArray[] = "ordering.pay_type IN (" . implode(",", $param["pay_type"]) . ")";
         foreach ($param["pay_type"] as $val) {
             $payType[] = AdmOrdering::$_payType[$val];
         }
         $this->_contents["支払方法"] = implode("、", $payType);
     }
     if (ComValidation::isArray($param["is_paid"])) {
         $whereArray[] = "ordering.is_paid IN (" . implode(",", $param["is_paid"]) . ")";
         foreach ($param["is_paid"] as $val) {
             $isPaid[] = AdmOrdering::$_paidFlag[$val];
         }
         $this->_contents["入金"] = implode("、", $isPaid);
     }
     if (ComValidation::isArray($param["is_cancel"])) {
         $whereArray[] = "ordering.is_cancel IN (" . implode(",", $param["is_cancel"]) . ")";
         foreach ($param["is_cancel"] as $val) {
             $isCancel[] = AdmOrdering::$_cancelFlag[$val];
         }
         $this->_contents["キャンセル"] = implode("、", $isCancel);
     }
     if (ComValidation::isNumeric($param["is_invalid"])) {
         $subColumn[] = "sub_od.ordering_id";
         $subWhereArray[] = "sub_o.id = sub_od.ordering_id";
         $subWhereArray[] = "sub_o.user_id = sub_v_user.user_id";
         $subWhereArray[] = "sub_od.item_id = i.id";
         $subWhereArray[] = "sub_v_user.user_disable = 0";
         $subWhereArray[] = "i.item_category_id = ic.id";
         $subWhereArray[] = "sub_od.is_cancel = 0";
         $subWhereArray[] = "i.disable = 0";
         $subWhereArray[] = "ic.disable = 0";
         $subWhereArray[] = "sub_o.disable = 0";
         $subWhereArray[] = "sub_od.disable = 0";
         $subWhereArray[] = "(!(sub_v_user.total_payment > 0 AND i.payment_status != " . Item::PAY_STATUS_NOT_PAY . ") OR !(sub_v_user.total_payment = 0 AND i.payment_status != " . Item::PAY_STATUS_PAY . "))";
         $subWhereArray[] = "NOT (i.is_display = 1";
         $subWhereArray[] = "ic.is_display = 1";
         $subWhereArray[] = "(i.sales_start_datetime <= '" . date("Y-m-d H:i:s") . "' OR i.sales_start_datetime = '0000-00-00 00:00:00')";
         $subWhereArray[] = "(i.sales_end_datetime >= '" . date("Y-m-d H:i:s") . "' OR i.sales_end_datetime = '0000-00-00 00:00:00'))";
         $subSql = $this->makeSelectQuery("ordering sub_o, ordering_detail sub_od, v_user_profile sub_v_user, item as i, item_category as ic", $subColumn, $subWhereArray);
         $whereArray[] = "ordering.id NOT IN (" . $subSql . ")";
         $this->_contents["無効商品"] = "無効商品を含む注文を除く";
     }
     if (ComValidation::isNumeric($param["is_overlap"])) {
         $this->_contents["重複ユーザー"] = AdmOrdering::$_overLapFlag[$param["is_overlap"]];
     }
     return $whereArray;
 }

 /**
  * ユーザー検索の条件文の作成
  *
  * @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};
//.........这里部分代码省略.........