function tad_web_list_cate() { global $xoopsDB, $xoopsTpl, $isAdmin; $myts = MyTextSanitizer::getInstance(); $sql = "select * from `" . $xoopsDB->prefix("tad_web_cate") . "` where `WebID`='0' and `ColName`='web_cate' and `ColSN`='0' order by `CateSort`"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $all_content = ''; $i = 0; $web_cate = get_web_cate_arr(); while ($all = $xoopsDB->fetchArray($result)) { //以下會產生這些變數: $CateID, $WebID, $CateName, $ColName, $ColSN, $CateSort, $CateEnable, $CateCounter foreach ($all as $k => $v) { ${$k} = $v; } //將是/否選項轉換為圖示 $CateEnable = $CateEnable == 1 ? '<img src="' . XOOPS_URL . '/modules/tad_web/images/yes.gif" alt="' . _YES . '" title="' . _YES . '">' : '<img src="' . XOOPS_URL . '/modules/tad_web/images/no.gif" alt="' . _NO . '" title="' . _NO . '">'; //過濾讀出的變數值 $CateName = $myts->htmlSpecialChars($CateName); $ColName = $myts->htmlSpecialChars($ColName); $ColSN = $myts->htmlSpecialChars($ColSN); $all_content[$i]['CateID'] = $CateID; $all_content[$i]['WebID'] = ${$WebID}; $all_content[$i]['CateName'] = $CateName; $all_content[$i]['ColName'] = $ColName; $all_content[$i]['ColSN'] = $ColSN; $all_content[$i]['CateSort'] = $CateSort; $all_content[$i]['CateEnable'] = $CateEnable; $all_content[$i]['CateCounter'] = $CateCounter; //die(var_export($web_cate[0])); $all_content[$i]['repository'] = $web_cate[0]; $all_content[$i]['destination'] = $web_cate[$CateID]; $all_content[$i]['web_cate_arr_str'] = implode(",", $web_cate[$CateID]['WebID']); $all_content[$i]['web_cate_blank_arr'] = implode(",", $web_cate[0]['WebID']); $i++; } //刪除確認的JS if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) { redirect_header("index.php", 3, _MA_NEED_TADTOOLS); } include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php"; $sweet_alert_obj = new sweet_alert(); $delete_tad_web_cate_func = $sweet_alert_obj->render('delete_tad_web_cate_func', "{$_SERVER['PHP_SELF']}?op=delete_tad_web_cate&CateID=", "CateID"); $xoopsTpl->assign('delete_tad_web_cate_func', $delete_tad_web_cate_func); $xoopsTpl->assign('tad_web_cate_jquery_ui', get_jquery(true)); $xoopsTpl->assign('bar', $bar); $xoopsTpl->assign('action', $_SERVER['PHP_SELF']); $xoopsTpl->assign('isAdmin', $isAdmin); $xoopsTpl->assign('all_content', $all_content); }
function list_jill_booking_item() { global $xoopsDB, $xoopsTpl, $isAdmin; $myts =& MyTextSanitizer::getInstance(); $sql = "select * from `" . $xoopsDB->prefix("jill_booking_item") . "` order by `jbi_sort`"; //getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項); $PageBar = getPageBar($sql, 20, 10, null, null, $_SESSION['bootstrap']); $bar = $PageBar['bar']; $sql = $PageBar['sql']; $total = $PageBar['total']; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $all_content = ""; $i = 0; while ($all = $xoopsDB->fetchArray($result)) { //以下會產生這些變數: $jbi_sn , $jbi_start , $jbi_end , $jbi_title , $jbi_desc , $jbi_approval , $jbi_sort , $jbi_enable foreach ($all as $k => $v) { ${$k} = $v; } //將是/否選項轉換為圖示 $jbi_enable = $jbi_enable == 1 ? '<img src="../images/yes.gif" alt="' . _YES . '" title="' . _YES . '">' : '<img src="../images/no.gif" alt="' . _NO . '" title="' . _NO . '">'; if (empty($jbi_approval)) { $jbi_approval = '<img src="../images/no.gif" alt="' . _NO . '" title="' . _NO . '">'; } else { $jbi_approvalArr = explode(";", $jbi_approval); //die(var_dump($jbi_approvalArr)); $jbi_approval = ""; foreach ($jbi_approvalArr as $approval_uid) { $jbi_approval .= XoopsUser::getUnameFromId($approval_uid, 1) . ","; } $jbi_approval = substr($jbi_approval, 0, -1); } //過濾讀出的變數值 $jbi_start = $myts->htmlSpecialChars($jbi_start); $jbi_end = $myts->htmlSpecialChars($jbi_end); $jbi_title = $myts->htmlSpecialChars($jbi_title); $jbi_desc = $myts->displayTarea($jbi_desc, 1, 1, 1, 1, 0); $all_content[$i]['jbi_sn'] = $jbi_sn; $all_content[$i]['jbi_start'] = $jbi_start; $all_content[$i]['jbi_end'] = $jbi_end; $all_content[$i]['jbi_title_link'] = "<a href='{$_SERVER['PHP_SELF']}?jbi_sn={$jbi_sn}'>{$jbi_title}</a>"; $all_content[$i]['jbi_title'] = $jbi_title; $all_content[$i]['jbi_desc'] = $jbi_desc; $all_content[$i]['jbi_approval'] = $jbi_approval; $all_content[$i]['jbi_sort'] = $jbi_sort; $all_content[$i]['jbi_enable'] = $jbi_enable; ++$i; } //刪除確認的JS $xoopsTpl->assign('bar', $bar); $xoopsTpl->assign('action', $_SERVER['PHP_SELF']); $xoopsTpl->assign('isAdmin', $isAdmin); $xoopsTpl->assign('all_content', $all_content); $xoopsTpl->assign('now_op', 'list_jill_booking_item'); if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) { redirect_header("index.php", 3, _MA_NEED_TADTOOLS); } include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php"; $sweet_alert = new sweet_alert(); $delete_jill_booking_item_func = $sweet_alert->render('delete_jill_booking_item_func', "{$_SERVER['PHP_SELF']}?op=delete_jill_booking_item&jbi_sn=", "jbi_sn"); $xoopsTpl->assign('delete_jill_booking_item_func', $delete_jill_booking_item_func); }
function jill_booking_list($def_jbi_sn = "") { global $xoopsDB, $xoopsTpl, $xoopsUser, $isAdmin, $Isapproval; if (!$xoopsUser) { return; } //場地設定 $item_opt = get_jill_booking_time_options($def_jbi_sn); $xoopsTpl->assign('item_opt', $item_opt); $where_jbisn = empty($def_jbi_sn) ? "" : " and c.jbi_sn='{$def_jbi_sn}' "; $uid = $xoopsUser->uid(); $myts =& MyTextSanitizer::getInstance(); $sql = "select a.jb_sn,a.jb_date,a.jbt_sn,a.jb_waiting,a.jb_status,b.jb_uid,b.jb_booking_time,b.jb_booking_content,b.jb_start_date,b.jb_end_date,c.jbi_sn,c.jbt_title,c.jbt_sort,d.jbi_title,d.jbi_approval\n from `" . $xoopsDB->prefix("jill_booking_date") . "` as a\n join `" . $xoopsDB->prefix("jill_booking") . "` as b on a.jb_sn=b.jb_sn\n join `" . $xoopsDB->prefix("jill_booking_time") . "` as c on a.jbt_sn=c.jbt_sn\n join `" . $xoopsDB->prefix("jill_booking_item") . "` as d on c.jbi_sn=d.jbi_sn\n where b.`jb_uid`='{$uid}' {$where_jbisn} order by a.jb_status desc,a.`jb_date` desc,a.`jb_waiting`,a.jbt_sn "; //die($sql); //getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項); $PageBar = getPageBar($sql, 20, 10, null, null, $_SESSION['bootstrap']); $bar = $PageBar['bar']; $sql = $PageBar['sql']; $total = $PageBar['total']; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $all_content = ""; $i = 0; while ($all = $xoopsDB->fetchArray($result)) { //以下會產生這些變數:jb_sn,jb_date,jbt_sn,,jb_waiting,jb_status,jb_uid,jb_booking_time,jb_booking_content,jb_start_date,jb_end_date,jbi_sn,jbt_title,jbt_sort,jbi_title,jbi_approval foreach ($all as $k => $v) { ${$k} = $v; } //過濾讀出的變數值 $jb_booking_content = $myts->displayTarea($jb_booking_content, 1, 1, 0, 1, 0); $jb_start_date = $myts->htmlSpecialChars($jb_start_date); $jb_end_date = $myts->htmlSpecialChars($jb_end_date); $all_content[$i]['jb_sn'] = $jb_sn; $all_content[$i]['jb_date'] = $jb_date; $all_content[$i]['jbt_sn'] = $jbt_sn; $all_content[$i]['primary'] = $jbi_sn . "_" . $jb_date . "_" . $jbt_sn; $all_content[$i]['jb_waiting'] = $jb_waiting; $all_content[$i]['jb_status'] = $jb_status; $all_content[$i]['jb_uid'] = XoopsUser::getUnameFromId($jb_uid, 1); $all_content[$i]['jb_booking_time'] = $jb_booking_time; $all_content[$i]['jb_booking_content'] = $jb_booking_content; $all_content[$i]['jb_start_date'] = $jb_start_date; $all_content[$i]['jb_end_date'] = $jb_end_date; $all_content[$i]['jbi_sn'] = $jbi_sn; $all_content[$i]['jbt_title'] = $jbt_title; $all_content[$i]['jbt_sort'] = $jbt_sort; $all_content[$i]['jbi_title'] = $jbi_title; $all_content[$i]['jbi_approval'] = $jbi_approval; $today = date("Y-m-d"); $all_content[$i]['fun'] = strtotime($jb_date) >= strtotime($today) ? 1 : ''; $i++; } //刪除確認的JS $xoopsTpl->assign('bar', $bar); $xoopsTpl->assign('action', $_SERVER['PHP_SELF']); $xoopsTpl->assign('isAdmin', $isAdmin); $xoopsTpl->assign('all_content', $all_content); $xoopsTpl->assign('now_op', 'jill_booking_list'); if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) { redirect_header("index.php", 3, _MD_NEED_TADTOOLS); } include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php"; $sweet_alert = new sweet_alert(); $delete_jill_booking_func = $sweet_alert->render('delete_jill_booking_func', "{$_SERVER['PHP_SELF']}?op=delete_jill_booking&primary=", "primary"); $xoopsTpl->assign('delete_jill_booking_func', $delete_jill_booking_func); }
function list_jill_booking_time($jbi_sn = "") { global $xoopsDB, $xoopsTpl, $isAdmin; if (empty($jbi_sn)) { return; } $item = get_jill_booking_item($jbi_sn); include_once XOOPS_ROOT_PATH . "/modules/tadtools/jeditable.php"; $jeditable = new jeditable(); $myts =& MyTextSanitizer::getInstance(); $sql = "select * from `" . $xoopsDB->prefix("jill_booking_time") . "`\n where `jbi_sn`='{$jbi_sn}' order by `jbt_sort`"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $total = $xoopsDB->getRowsNum($result); $all_content = ""; $i = 0; while ($all = $xoopsDB->fetchArray($result)) { //以下會產生這些變數: $jbt_sn , $jbi_sn , $jbt_title , $jbt_sort foreach ($all as $k => $v) { ${$k} = $v; } //過濾讀出的變數值 $jbt_title = $myts->htmlSpecialChars($jbt_title); $jeditable->setTextCol("#jbt_title_{$jbt_sn}", 'time.php', '100%', '11pt', "{'jbt_sn':{$jbt_sn},'op' : 'save_jbt_title'}", _TAD_EDIT . _MA_JILLBOOKIN_JBT_TITLE); $all_content[$i]['jbi_sn'] = $jbi_sn; $all_content[$i]['jbt_sn'] = $jbt_sn; $all_content[$i]['jbt_title_link'] = "<a href='{$_SERVER['PHP_SELF']}?jbt_sn={$jbt_sn}'>{$jbt_title}</a>"; $all_content[$i]['jbt_title'] = $jbt_title; $all_content[$i]['jbt_sort'] = $jbt_sort; $all_content[$i]['jbt_week'] = strval($jbt_week); $booking_times = get_booking_times($jbt_sn); $all_content[$i]['booking_times'] = empty($booking_times) ? "" : sprintf(_MA_JILLBOOKIN_BOOKING_TIME, $booking_times); $w_arr = explode(',', $jbt_week); for ($j = 0; $j <= 7; $j++) { $name = "w{$j}"; $pic = in_array($j, $w_arr) ? "yes.gif" : "no.gif"; $all_content[$i][$name] = "<img src='../images/{$pic}' id='{$jbt_sn}_{$j}' onClick=\"change_enable({$jbt_sn},{$j});\" style='cursor: pointer;'>"; } ++$i; } //die(var_export($all_content)); //刪除確認的JS $xoopsTpl->assign('item', $item); $xoopsTpl->assign('bar', $bar); $xoopsTpl->assign('action', $_SERVER['PHP_SELF']); $xoopsTpl->assign('isAdmin', $isAdmin); $xoopsTpl->assign('all_content', $all_content); $xoopsTpl->assign('now_op', 'list_jill_booking_time'); $xoopsTpl->assign('jbi_sn', $jbi_sn); if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) { redirect_header("index.php", 3, _MA_NEED_TADTOOLS); } include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php"; $sweet_alert = new sweet_alert(); $delete_jill_booking_time_func = $sweet_alert->render('delete_jill_booking_time_func', "{$_SERVER['PHP_SELF']}?op=delete_jill_booking_time&jbi_sn={$jbi_sn}&jbt_sn=", "jbt_sn"); $xoopsTpl->assign('delete_jill_booking_time_func', $delete_jill_booking_time_func); //套用formValidator驗證機制 if (!file_exists(TADTOOLS_PATH . "/formValidator.php")) { redirect_header("index.php", 3, _TAD_NEED_TADTOOLS); } include_once TADTOOLS_PATH . "/formValidator.php"; $formValidator = new formValidator("#myForm", true); $formValidator_code = $formValidator->render(); $xoopsTpl->assign('formValidator_code', $formValidator_code); $jeditable_set = $jeditable->render(); $xoopsTpl->assign('jeditable_set', $jeditable_set); //找出現有場地 $i = 0; $place_time = ""; $sql = "select a.* , count(b.jbt_sn) as counter from `" . $xoopsDB->prefix("jill_booking_item") . "` as a join `" . $xoopsDB->prefix("jill_booking_time") . "` as b on a.jbi_sn=b.jbi_sn where a.jbi_enable='1' group by b.jbi_sn"; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); while ($data = $xoopsDB->fetchArray($result)) { $data['jbi_link'] = sprintf(_MA_JILLBOOKIN_IMPORT_PLACE, $data['jbi_title'], $data['counter']); $place_time[$i] = $data; $i++; } $xoopsTpl->assign('place_time', $place_time); $xoopsTpl->assign('jquery', get_jquery(true)); }
function jill_booking_approvallist($jbi_sn = "") { global $xoopsDB, $xoopsTpl, $xoopsUser, $isAdmin; $uid = $xoopsUser->uid(); $myts =& MyTextSanitizer::getInstance(); //場地設定 $item_opt = get_jill_booking_time_options($jbi_sn, $uid); //die(var_export($item_opt)); if (!empty($jbi_sn)) { $itemArr = get_jill_booking_item($jbi_sn, 1); $checkapproval = explode(";", $itemArr['jbi_approval']); if (in_array($uid, $checkapproval)) { $sql = "select b.jb_sn,b.jbt_sn,b.jb_date,b.jb_waiting,b.jb_status,c.jbi_sn,c.jbt_title,d.jb_uid,d.jb_booking_time,d.jb_booking_content,d.jb_start_date,d.jb_end_date from `" . $xoopsDB->prefix("jill_booking_date") . "` as b\n join `" . $xoopsDB->prefix("jill_booking_time") . "` as c on b.jbt_sn=c.jbt_sn\n join `" . $xoopsDB->prefix("jill_booking") . "` as d on b.jb_sn=d.jb_sn\n where c.jbi_sn='{$jbi_sn}' && b.jb_status='0' && b.jb_date>= ' " . date("Y-m-d", xoops_getUserTimestamp(time())) . " ' order by b.jb_date ,b.jbt_sn,d.jb_booking_time"; //die($sql); //getPageBar($原sql語法, 每頁顯示幾筆資料, 最多顯示幾個頁數選項); $PageBar = getPageBar($sql, 20, 10, null, null, $_SESSION['bootstrap']); $bar = $PageBar['bar']; $sql = $PageBar['sql']; $total = $PageBar['total']; $result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error()); $all_content = ""; $i = 0; while ($all = $xoopsDB->fetchArray($result)) { //以下會產生這些變數: a.jb_sn,a.jb_week,a.jbt_sn,b.jb_date,b.jb_waiting,b.jb_status,c.jbi_sn,c.jbt_title,c.jbt_sort,c.jbt_week,d.jb_uid,d.jb_booking_time,d.jb_booking_content,d.jb_start_date,d.jb_end_date foreach ($all as $k => $v) { ${$k} = $v; } //過濾讀出的變數值 $jb_booking_content = $myts->displayTarea($jb_booking_content, 1, 1, 0, 1, 0); $jb_start_date = $myts->htmlSpecialChars($jb_start_date); $jb_end_date = $myts->htmlSpecialChars($jb_end_date); $all_content[$i]['jb_sn'] = $jb_sn; $all_content[$i]['jbt_sn'] = $jbt_sn; $all_content[$i]['jb_date'] = $jb_date; $all_content[$i]['jb_week'] = date('w', strtotime($jb_date)); $all_content[$i]['jb_waiting'] = $jb_waiting; $all_content[$i]['jb_status'] = $jb_status; $all_content[$i]['jbi_sn'] = $jbi_sn; $all_content[$i]['jbt_title'] = $jbt_title; $all_content[$i]['jb_uid'] = XoopsUser::getUnameFromId($jb_uid, 1); $all_content[$i]['jb_booking_time'] = $jb_booking_time; $all_content[$i]['jb_booking_content'] = $jb_booking_content; $all_content[$i]['jb_start_date'] = $jb_start_date; $all_content[$i]['jb_end_date'] = $jb_end_date; $i++; } } } //die(var_dump($all_content)); //刪除確認的JS if (!file_exists(XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php")) { redirect_header("index.php", 3, _MD_NEED_TADTOOLS); } include_once XOOPS_ROOT_PATH . "/modules/tadtools/sweet_alert.php"; $sweet_alert = new sweet_alert(); $delete_jill_booking_func = $sweet_alert->render('delete_jill_booking_func', "{$_SERVER['PHP_SELF']}?op=delete_booking&jb_info=", "jb_info"); $xoopsTpl->assign('delete_jill_booking_func', $delete_jill_booking_func); $xoopsTpl->assign('bar', $bar); $xoopsTpl->assign('action', $_SERVER['PHP_SELF']); $xoopsTpl->assign('isAdmin', $isAdmin); $xoopsTpl->assign('item_opt', $item_opt); $xoopsTpl->assign('all_content', $all_content); $xoopsTpl->assign('now_op', 'jill_booking_approvallist'); }