function list_jill_booking($jb_sn = "", $jbi_sn = "")
{
global $xoopsDB, $xoopsTpl;
if (empty($jb_sn)) {
return;
}
//取得jill_booking
$DBV1 = get_jill_booking($jb_sn);
$DBV2 = get_booking_weekArr($jb_sn);
//die(var_export($DBV2['jbt_sn']));
//可啟用場地資訊
$itemArr = get_jill_booking_item($jbi_sn, 1);
//die(var_export($itemArr));
$xoopsTpl->assign("jbi_title", $itemArr['jbi_title']);
$xoopsTpl->assign("jbi_sn", $jbi_sn);
$dateweek = "";
$i = 0;
$str_jbt_sn = implode(",", $DBV2['jbt_sn']);
$maxwaiting = get_maxwaiting_byrange($DBV1['jb_start_date'], $DBV1['jb_end_date'], $str_jbt_sn);
//die("ads".$maxwaiting);
$xoopsTpl->assign("maxwaiting", $maxwaiting);
foreach ($DBV2 as $k => $jb_weekArr) {
//die($jb_weekArr['jb_week']);
//$jb_weekArr['jbt_sn'];
$dateArr = getdateArr($jb_weekArr['jb_week'], $DBV1['jb_start_date'], $DBV1['jb_end_date']);
$timeArr = get_jill_booking_time($jb_weekArr['jbt_sn']);
$time[] = $jbt_sn;
foreach ($dateArr as $date) {
$dateweek[$i]['jb_date'] = $date;
$dateweek[$i]['week'] = date('w', strtotime($date));
$dateweek[$i]['jbt_title'] = $timeArr['jbt_title'];
$dateweek[$i]['jbt_sn'] = $jb_weekArr['jbt_sn'];
if (!empty($maxwaiting)) {
$waitingArr = get_jbwaiting($jb_weekArr['jbt_sn'], $date);
for ($j = 0; $j < $maxwaiting; $j++) {
$ok = "<span style='color:#D44950'><i class='fa fa-check'></i></span>";
$jb_exit = 0;
if (!empty($waitingArr)) {
foreach ($waitingArr as $key => $w) {
if ($w['jb_waiting'] == $j + 1) {
$ok = $w['name'];
}
$jb_exit = 1;
}
$dateweek[$i]['waitingArr'][$j]['name'] = $ok;
$dateweek[$i]['jb_exit'] = $jb_exit;
} else {
$dateweek[$i]['waitingArr'][0]['name'] = "<span style='color:#D44950'><i class='fa fa-check'></i></span>";
for ($j = 1; $j < $maxwaiting; $j++) {
$dateweek[$i]['waitingArr'][$j]['name'] = "";
}
$dateweek[$i]['jb_exit'] = 0;
}
}
} else {
$dateweek[$i]['waitingArr'][0]['name'] = "<span style='color:#D44950'><i class='fa fa-check'></i></span>";
$dateweek[$i]['jb_exit'] = 0;
}
++$i;
}
}
foreach ($dateweek as $key => $value) {
$jb_date[$key] = strtotime($value['jb_date']);
}
array_multisort($jb_date, $dateweek);
//die(var_export($dateweek));
$xoopsTpl->assign("jb_sn", $jb_sn);
$xoopsTpl->assign("dateweek", $dateweek);
$xoopsTpl->assign('now_op', 'list_jill_booking');
$xoopsTpl->assign('action', $_SERVER["PHP_SELF"]);
$xoopsTpl->assign('next_op', "insert_jill_booking_date");
}
function change_enable($jbt_sn = "", $week = "")
{
global $xoopsDB, $xoopsTpl;
$time = get_jill_booking_time($jbt_sn);
$jbt_week = strval($time['jbt_week']);
$week_arr = explode(',', $jbt_week);
if (in_array($week, $week_arr)) {
foreach ($week_arr as $w) {
if ($w != $week) {
$new_week[] = $w;
}
}
$new_week = implode(',', $new_week);
$new_pic = "../images/no.gif";
} else {
$week_arr[] = $week;
sort($week_arr);
$new_week = implode(',', $week_arr);
$new_pic = "../images/yes.gif";
}
$sql = "update " . $xoopsDB->prefix("jill_booking_time") . " set `jbt_week`='{$new_week}' where jbt_sn='{$jbt_sn}'";
$xoopsDB->queryF($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
return $new_pic;
}
