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