connect();
$post = $x->clean($_POST);
$get = $x->clean($_GET);
$greeting = $mln->getGreet();
$point = number_format($mln->getPoint());
$system_m = new systemMaster($db);
$PPM = $system_m->get("PPM");
$mes = "";
if (isset($_GET["p"])) {
if ($_GET["p"] == "fin") {
$mes = "
キャンセルが完了しました
";
}
}
$js_onload = "";
// ページ送りページ番号
$p = getPageNum($get);
$lArray = getListLimit("l", "form1", $system_m, $post, $get);
$l = $lArray["l"];
$selectL = $lArray["select"];
$sql = "
SELECT
r.id,
r.provider_info,
r.provider_id,
DATE_FORMAT(r.reg_dt, '%Y/%m/%d %H:%i') AS regDt,
DATE_FORMAT(r.reg_dt, '%w') AS regDtW,
DATE_FORMAT(r.reserve_dt, '%Y/%m/%d %H:%i') AS reserveDt,
DATE_FORMAT(r.reserve_dt, '%w') AS reserveDtW,
TIMESTAMPDIFF(MINUTE, r.reg_dt, r.reserve_dt) AS df,
r.reserve_dt,
r.test_flag,
r.file_id,
f.name AS filename,
f.download_param,
r.file_page_no,
r.file_priority,
r.list_id,
l.name AS listname,
r.list_no,
r.list_success_no,
r.list_failure_no,
r.point1,
r.point2,
r.status,
r.expire_dt,
CASE WHEN r.expire_dt >= now() THEN 'OK' ELSE 'EXPIRE' END AS expire,
r.express_flag
FROM
t_reserve AS r
LEFT JOIN file AS f ON f.id = r.file_id
LEFT JOIN llist AS l ON l.id = r.list_id
WHERE
r.member_id = " . $member_id . "
ORDER BY
r.reg_dt DESC";
// print $sql;
$db->exec($sql);
$db->set_page_split($l);
$dt = $db->get_page($p);
$link = "list.php?l=" . $l;
$pc = getPagingContents($p, $db, $l, $PPM, $link);
$all_num = number_format($pc["member_num"]);
$from_num = number_format($pc["member_num_from"]);
$to_num = number_format($pc["member_num_to"]);
$page_link = $pc["page_link"];
$wm = array("0" => "日", "1" => "月", "2" => "火", "3" => "水", "4" => "木", "5" => "金", "6" => "土");
$qm = array("10" => "テキスト優先", "11" => "画像優先", "20" => "プレミアム");
$list = "";
$expire = time() + (60 * 60);
$db->exec("SELECT var FROM m_system WHERE name = 'SSLKEY'");
$sslKeyResult = $db->get();
$sslKey = $sslKeyResult[0]["var"];
if (is_array($dt)) {
foreach($dt as $var) {
$thisLine = "";
$thisLine = "";
// 管理番号
$code = $var["id"] . strtoupper(substr($var["provider_info"], 0, 1)) . $var["provider_id"];
$thisLine .= "| " . $code . " | ";
// 依頼日時
$regDt = $var["regDt"] . "(" . $wm[$var["regDtW"]] . ")";
$thisLine .= "" . $regDt . " | ";
// 予約/配信日時
$reserveDt = $var["reserveDt"] . "(" . $wm[$var["reserveDtW"]] . ")";
if ($var["express_flag"] == "10" || $var["df"] <= 10) {
$reserveDt = "即時";
}
$thisLine .= "" . $reserveDt . " | ";
// 原稿品質/原稿
$thisLine .= "" . $qm[$var["file_priority"]] . " | ";
$thisLine .= "" . $var["filename"] . " (" . number_format($var["file_page_no"]) . " ページ) | ";
// リスト
$listname = $var["listname"] . " (" . number_format($var["list_no"]) . " 件)";
if ($var["test_flag"] == "10") {
$listname = "【テスト配信】";
}
$thisLine .= "" . $listname . " | ";
// 予約件数
$reserveCount = $var["file_page_no"] * $var["list_no"];
$thisLine .= "" . number_format($reserveCount) . " 件 | ";
// 着信数
$successKensu = "-";
$failureKensu = "-";
$reservePt = "-";
$backPt = "-";
$status = "";
$result = "-";
if ($var["status"] == "10") {
$status = "予約中";
} else if ($var["status"] == "15") {
$status = "予約中";
$rst = date(strtotime($var["reserve_dt"]));
$not = date(strtotime("+ 30 minute"));
if ($rst < $not) {
$result = "キャンセル不可";
} else {
$param = urlencode(encryptOpenSSL($var["id"] . "#" . $expire . "#cancel#" . $var["provider_info"], $sslKey));
$cancelUrl = "https://faxdm.mobi/member/reserve/cancel.php?p=" . $param;
$result = "キャンセル";
}
} else if ($var["status"] == "20") {
$backInfo = number_format($var["point2"]) . " pt";
$status = "キャンセル";
$successKensu = "0 件";
$reservePt = number_format($var["point1"]) . " pt";
$backPt = number_format($var["point2"]) . " pt";
} else if ($var["status"] == "30") {
$status = "配信中";
} else if ($var["status"] == "40") {
$status = "完了";
$successKensu = number_format($var["list_success_no"]) . " 件";
$failureKensu = number_format($var["list_failure_no"]) . " 件";
$reservePt = number_format($var["point1"]) . " pt";
$backPt = number_format($var["point2"]) . " pt";
if ($var["expire"] == "OK") {
$param = urlencode(encryptOpenSSL($var["id"] . "#" . $expire, $sslKey));
$downloadUrl = "https://faxdm.mobi/member/reserve/download.php?p=" . $param;
$result = "ダウンロード";
} else {
$result = "期限切れ";
}
} else if ($var["status"] == "80") {
$status = "中止";
$backInfo = number_format($var["point2"]) . " pt";
} else if ($var["status"] == "90") {
$status = "失敗";
$backInfo = number_format($var["point2"]) . " pt";
}
$thisLine .= "" . $successKensu . " | ";
$thisLine .= "" . $failureKensu . " | ";
$thisLine .= "" . $reservePt . " | ";
$thisLine .= "" . $backPt . " | ";
$thisLine .= "" . $status . " | ";
$thisLine .= "" . $result . " | ";
$list .= $thisLine . "
\n";
}
}
$tmpl_fname = "/var/www/vhosts/faxdm.mobi/template/member/reserve/list.tmpl";
$tmpl = new File($tmpl_fname);
$html = $tmpl->read();
$html = str_replace("%GREETING%", $greeting, $html);
$html = str_replace("%POINT%", $point, $html);
$html = str_replace("%MES%", $mes, $html);
$html = str_replace("%LIST%", $list, $html);
$html = str_replace("%ALL_NUM%", $all_num, $html);
$html = str_replace("%FROM_NUM%", $from_num, $html);
$html = str_replace("%TO_NUM%", $to_num, $html);
$html = str_replace("%JS_ONLOAD%", $js_onload, $html);
$html = str_replace("%PAGE_LINK%", $page_link, $html);
$html = str_replace("%LIST_LIMIT%", $selectL, $html);
$html = str_replace("%LINK%", $link, $html);
print $html;