:::
9-4-2-2 class\Tad_signup_api.php 套用語系
9-4-2-3 class\Tad_signup_data.php 套用語系
影片中資料庫大小寫不正確，一律改為小寫 prefix("tad_signup_data")
<?php
namespace XoopsModules\Tad_signup;
use XoopsModules\Tadtools\BootstrapTable;
use XoopsModules\Tadtools\FormValidator;
use XoopsModules\Tadtools\SweetAlert;
use XoopsModules\Tadtools\TadDataCenter;
use XoopsModules\Tadtools\Tmt;
use XoopsModules\Tadtools\Utility;
use XoopsModules\Tad_signup\Tad_signup_actions;
class Tad_signup_data
{
//列出所有資料
public static function index($action_id)
{
global $xoopsTpl;
$all_data = self::get_all($action_id);
$xoopsTpl->assign('all_data', $all_data);
}
//編輯表單
public static function create($action_id, $id = '')
{
global $xoopsTpl, $xoopsUser;
$uid = $_SESSION['can_add'] ? null : $xoopsUser->uid();
//抓取預設值
$db_values = empty($id) ? [] : self::get($id, $uid);
if ($id and empty($db_values)) {
redirect_header($_SERVER['PHP_SELF'] . "?id={$action_id}", 3, _MD_TAD_SIGNUP_CANNOT_BE_MODIFIED);
}
foreach ($db_values as $col_name => $col_val) {
$$col_name = $col_val;
$xoopsTpl->assign($col_name, $col_val);
}
$op = empty($id) ? "tad_signup_data_store" : "tad_signup_data_update";
$xoopsTpl->assign('next_op', $op);
//套用formValidator驗證機制
$formValidator = new FormValidator("#myForm", true);
$formValidator->render();
//加入Token安全機制
include_once $GLOBALS['xoops']->path('class/xoopsformloader.php');
$token = new \XoopsFormHiddenToken();
$token_form = $token->render();
$xoopsTpl->assign("token_form", $token_form);
$action = Tad_signup_actions::get($action_id, true);
if (time() > strtotime($action['end_date'])) {
redirect_header($_SERVER['PHP_SELF'], 3, _MD_TAD_SIGNUP_END);
} elseif (!$action['enable']) {
redirect_header($_SERVER['PHP_SELF'], 3, _MD_TAD_SIGNUP_CLOSED);
} elseif ($action['signup_count'] >= ($action['number'] + $action['candidate'])) {
redirect_header($_SERVER['PHP_SELF'], 3, _MD_TAD_SIGNUP_FULL);
}
$xoopsTpl->assign("action", $action);
$uid = $xoopsUser ? $xoopsUser->uid() : 0;
$xoopsTpl->assign("uid", $uid);
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('id', $id);
$signup_form = $TadDataCenter->strToForm($action['setup']);
$xoopsTpl->assign("signup_form", $signup_form);
}
//新增資料
public static function store()
{
global $xoopsDB;
//XOOPS表單安全檢查
Utility::xoops_security_check();
$myts = \MyTextSanitizer::getInstance();
foreach ($_POST as $var_name => $var_val) {
$$var_name = $myts->addSlashes($var_val);
}
$action_id = (int) $action_id;
$uid = (int) $uid;
$sql = "insert into `" . $xoopsDB->prefix("tad_signup_data") . "` (
`action_id`,
`uid`,
`signup_date`
) values(
'{$action_id}',
'{$uid}',
now()
)";
$xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
//取得最後新增資料的流水編號
$id = $xoopsDB->getInsertId();
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('id', $id);
$TadDataCenter->saveData();
$action = Tad_signup_actions::get($action_id);
$action['signup'] = self::get_all($action_id);
if (count($action['signup']) > $action['number']) {
$TadDataCenter->set_col('data_id', $id);
$TadDataCenter->saveCustomData(['tag' => [_MD_TAD_SIGNUP_CANDIDATE]]);
}
return $id;
}
//以流水號秀出某筆資料內容
public static function show($id = '')
{
global $xoopsTpl, $xoopsUser;
if (empty($id)) {
return;
}
$uid = $_SESSION['can_add'] ? null : $xoopsUser->uid();
$id = (int) $id;
$data = self::get($id, $uid);
if (empty($data)) {
redirect_header($_SERVER['PHP_SELF'], 3, _MD_TAD_SIGNUP_CANT_WATCH);
}
$myts = \MyTextSanitizer::getInstance();
foreach ($data as $col_name => $col_val) {
$col_val = $myts->htmlSpecialChars($col_val);
$xoopsTpl->assign($col_name, $col_val);
$$col_name = $col_val;
}
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('id', $id);
$tdc = $TadDataCenter->getData();
$xoopsTpl->assign('tdc', $tdc);
$action = Tad_signup_actions::get($action_id, true);
$xoopsTpl->assign("action", $action);
$now_uid = $xoopsUser ? $xoopsUser->uid() : 0;
$xoopsTpl->assign("now_uid", $now_uid);
$SweetAlert = new SweetAlert();
$SweetAlert->render("del_data", "index.php?op=tad_signup_data_destroy&action_id={$action_id}&id=", 'id');
}
//更新某一筆資料
public static function update($id = '')
{
global $xoopsDB, $xoopsUser;
//XOOPS表單安全檢查
Utility::xoops_security_check();
$myts = \MyTextSanitizer::getInstance();
foreach ($_POST as $var_name => $var_val) {
$$var_name = $myts->addSlashes($var_val);
}
$action_id = (int) $action_id;
$uid = (int) $uid;
$now_uid = $xoopsUser ? $xoopsUser->uid() : 0;
$sql = "update `" . $xoopsDB->prefix("tad_signup_data") . "` set
`signup_date` = now()
where `id` = '$id' and `uid` = '$now_uid'";
if ($xoopsDB->queryF($sql)) {
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('id', $id);
$TadDataCenter->saveData();
} else {
Utility::web_error($sql, __FILE__, __LINE__);
}
return $id;
}
//刪除某筆資料資料
public static function destroy($id = '')
{
global $xoopsDB, $xoopsUser;
if (empty($id)) {
return;
}
$now_uid = $xoopsUser ? $xoopsUser->uid() : 0;
$sql = "delete from `" . $xoopsDB->prefix("tad_signup_data") . "`
where `id` = '{$id}' and `uid`='$now_uid'";
if ($xoopsDB->queryF($sql)) {
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('id', $id);
$TadDataCenter->delData();
} else {
Utility::web_error($sql, __FILE__, __LINE__);
}
}
//以流水號取得某筆資料
public static function get($id = '', $uid = '')
{
global $xoopsDB;
if (empty($id)) {
return;
}
$and_uid = $uid ? "and `uid`='$uid'" : '';
$sql = "select * from `" . $xoopsDB->prefix("tad_signup_data") . "`
where `id` = '{$id}' $and_uid";
$result = $xoopsDB->query($sql) or Utility::web_error($sql, __FILE__, __LINE__);
$data = $xoopsDB->fetchArray($result);
return $data;
}
//取得所有資料陣列
public static function get_all($action_id = '', $uid = '', $auto_key = false, $only_accept = false)
{
global $xoopsDB, $xoopsUser;
$myts = \MyTextSanitizer::getInstance();
$and_accept = $only_accept ? "and `accept`='1'" : '';
if ($action_id) {
$sql = "select * from `" . $xoopsDB->prefix("tad_signup_data") . "` where `action_id`='$action_id' $and_accept order by `signup_date`";
} else {
if (!$_SESSION['can_add'] or !$uid) {
$uid = $xoopsUser ? $xoopsUser->uid() : 0;
}
$sql = "select * from `" . $xoopsDB->prefix("tad_signup_data") . "` where `uid`='$uid' $and_accept order by `signup_date`";
}
$result = $xoopsDB->query($sql) or Utility::web_error($sql, __FILE__, __LINE__);
$data_arr = [];
$TadDataCenter = new TadDataCenter('tad_signup');
while ($data = $xoopsDB->fetchArray($result)) {
$TadDataCenter->set_col('id', $data['id']);
$data['tdc'] = $TadDataCenter->getData();
$data['action'] = Tad_signup_actions::get($data['action_id'], true);
$TadDataCenter->set_col('data_id', $data['id']);
$data['tag'] = $TadDataCenter->getData('tag', 0);
if ($_SESSION['api_mode'] or $auto_key) {
$data_arr[] = $data;
} else {
$data_arr[$data['id']] = $data;
}
}
return $data_arr;
}
// 查詢某人的報名紀錄
public static function my($uid)
{
global $xoopsTpl, $xoopsUser;
$my_signup = self::get_all(null, $uid);
$xoopsTpl->assign('my_signup', $my_signup);
BootstrapTable::render();
}
// 更改錄取狀態
public static function accept($id, $accept)
{
global $xoopsDB;
if (!$_SESSION['can_add']) {
redirect_header($_SERVER['PHP_SELF'], 3, _TAD_PERMISSION_DENIED);
}
$id = (int) $id;
$accept = (int) $accept;
$sql = "update `" . $xoopsDB->prefix("tad_signup_data") . "` set
`accept` = '$accept'
where `id` = '$id'";
$xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
}
//立即寄出
public static function send($title = _MD_TAD_SIGNUP_NO_TITLE, $content = _MD_TAD_SIGNUP_NO_CONTENT, $email = "")
{
global $xoopsUser;
if (empty($email)) {
$email = $xoopsUser->email();
}
$xoopsMailer = xoops_getMailer();
$xoopsMailer->multimailer->ContentType = "text/html";
$xoopsMailer->addHeaders("MIME-Version: 1.0");
$header = '';
return $xoopsMailer->sendMail($email, $title, $content, $header);
}
// 產生通知信
public static function mail($id, $type, $signup = [])
{
global $xoopsUser;
$id = (int) $id;
if (empty($id)) {
redirect_header($_SERVER['PHP_SELF'], 3, _MD_TAD_SIGNUP_UNABLE_TO_SEND);
}
$signup = $signup ? $signup : self::get($id, true);
$now = date("Y-m-d H:i:s");
$name = $xoopsUser->name();
$name = $name ? $name : $xoopsUser->uname();
$action = Tad_signup_actions::get($signup['action_id']);
$member_handler = xoops_getHandler('member');
$admUser = $member_handler->getUser($action['uid']);
$adm_email = $admUser->email();
if ($type == 'destroy') {
$title = sprintf(_MD_TAD_SIGNUP_DESTROY_TITLE, $action['title']);
$head = sprintf(_MD_TAD_SIGNUP_DESTROY_HEAD, $signup['signup_date'], $action['title'], $now, $name);
$foot = _MD_TAD_SIGNUP_DESTROY_FOOT . XOOPS_URL . "/modules/tad_signup/index.php?op=tad_signup_data_create&action_id={$action['id']}";
} elseif ($type == 'store') {
$title = sprintf(_MD_TAD_SIGNUP_STORE_TITLE, $action['title']);
$head = sprintf(_MD_TAD_SIGNUP_STORE_HEAD, $signup['signup_date'], $action['title'], $now, $name);
$foot = _MD_TAD_SIGNUP_FOOT . XOOPS_URL . "/modules/tad_signup/index.php?id={$signup['action_id']}";
} elseif ($type == 'update') {
$title = sprintf(_MD_TAD_SIGNUP_UPDATE_TITLE, $action['title']);
$head = sprintf(_MD_TAD_SIGNUP_UPDATE_HEAD, $signup['signup_date'], $action['title'], $now, $name);
$foot = _MD_TAD_SIGNUP_FOOT . XOOPS_URL . "/modules/tad_signup/index.php?id={$signup['action_id']}";
} elseif ($type == 'accept') {
$title = sprintf(_MD_TAD_SIGNUP_ACCEPT_TITLE, $action['title']);
if ($signup['accept'] == 1) {
$head = sprintf(_MD_TAD_SIGNUP_ACCEPT_HEAD1, $signup['signup_date'], $action['title']);
} else {
$head = sprintf(_MD_TAD_SIGNUP_ACCEPT_HEAD0, $signup['signup_date'], $action['title']);
}
$foot = _MD_TAD_SIGNUP_FOOT . XOOPS_URL . "/modules/tad_signup/index.php?id={$signup['action_id']}";
$signupUser = $member_handler->getUser($signup['uid']);
$email = $signupUser->email();
}
$content = self::mk_content($id, $head, $foot, $action);
if (!self::send($title, $content, $email)) {
redirect_header($_SERVER['PHP_SELF'], 3, _MD_TAD_SIGNUP_FAILED_TO_SEND);
}
self::send($title, $content, $adm_email);
}
// 產生通知信內容
public static function mk_content($id, $head = '', $foot = '', $action = [])
{
if ($id) {
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('id', $id);
$tdc = $TadDataCenter->getData();
$table = '<table class="table">';
foreach ($tdc as $title => $signup) {
$table .= "
<tr>
<th>{$title}</th>
<td>";
foreach ($signup as $i => $val) {
$table .= "<div>{$val}</div>";
}
$table .= "</td>
</tr>";
}
$table .= '</table>';
}
$content = "
<html>
<head>
<style>
.table{
border:1px solid #000;
border-collapse: collapse;
margin:10px 0px;
}
.table th, .table td{
border:1px solid #000;
padding: 4px 10px;
}
.table th{
background:#c1e7f4;
}
.well{
border-radius: 10px;
background: #fcfcfc;
border: 2px solid #cfcfcf;
padding:14px 16px;
margin:10px 0px;
}
</style>
</head>
<body>
$head
<h2>{$action['title']}</h2>
<div>" . _MD_TAD_SIGNUP_ACTION_DATE . _TAD_FOR . "{$action['action_date']}</div>
<div class='well'>{$action['detail']}</div>
$table
$foot
</body>
</html>
";
return $content;
}
// 預覽 CSV
public static function preview_csv($action_id)
{
global $xoopsTpl;
if (!$_SESSION['can_add']) {
redirect_header($_SERVER['PHP_SELF'], 3, _TAD_PERMISSION_DENIED);
}
$action = Tad_signup_actions::get($action_id);
$xoopsTpl->assign('action', $action);
// 製作標題
list($head, $type) = self::get_head($action, true, true);
$xoopsTpl->assign('head', $head);
$xoopsTpl->assign('type', $type);
// 抓取內容
$preview_data = [];
$handle = fopen($_FILES['csv']['tmp_name'], "r") or die(_MD_TAD_SIGNUP_UNABLE_TO_OPEN);
while (($val = fgetcsv($handle, 1000)) !== false) {
$preview_data[] = mb_convert_encoding($val, 'UTF-8', 'Big5');
}
fclose($handle);
$xoopsTpl->assign('preview_data', $preview_data);
//加入Token安全機制
include_once $GLOBALS['xoops']->path('class/xoopsformloader.php');
$token = new \XoopsFormHiddenToken();
$token_form = $token->render();
$xoopsTpl->assign("token_form", $token_form);
}
//批次匯入 CSV
public static function import_csv($action_id)
{
global $xoopsDB, $xoopsUser;
//XOOPS表單安全檢查
Utility::xoops_security_check();
if (!$_SESSION['can_add']) {
redirect_header($_SERVER['PHP_SELF'], 3, _TAD_PERMISSION_DENIED);
}
$action_id = (int) $action_id;
$uid = $xoopsUser->uid();
$action = Tad_signup_actions::get($action_id);
$TadDataCenter = new TadDataCenter('tad_signup');
foreach ($_POST['tdc'] as $tdc) {
$sql = "insert into `" . $xoopsDB->prefix("tad_signup_data") . "` (
`action_id`,
`uid`,
`signup_date`,
`accept`
) values(
'{$action_id}',
'{$uid}',
now(),
'1'
)";
$xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
$id = $xoopsDB->getInsertId();
$TadDataCenter->set_col('id', $id);
$TadDataCenter->saveCustomData($tdc);
$action['signup'] = self::get_all($action_id);
if (count($action['signup']) > $action['number']) {
$TadDataCenter->set_col('data_id', $id);
$TadDataCenter->saveCustomData(['tag' => [_MD_TAD_SIGNUP_CANDIDATE]]);
}
}
}
// 預覽 Excel
public static function preview_excel($action_id)
{
global $xoopsTpl;
if (!$_SESSION['can_add']) {
redirect_header($_SERVER['PHP_SELF'], 3, _TAD_PERMISSION_DENIED);
}
$action = Tad_signup_actions::get($action_id);
$xoopsTpl->assign('action', $action);
// 製作標題
list($head, $type) = self::get_head($action, true, true);
$xoopsTpl->assign('head', $head);
$xoopsTpl->assign('type', $type);
// 抓取內容
$preview_data = [];
require_once XOOPS_ROOT_PATH . '/modules/tadtools/vendor/phpoffice/phpexcel/Classes/PHPExcel/IOFactory.php';
$reader = \PHPExcel_IOFactory::createReader('Excel2007');
$PHPExcel = $reader->load($_FILES['excel']['tmp_name']); // 檔案名稱
$sheet = $PHPExcel->getSheet(0); // 讀取第一個工作表(編號從 0 開始)
$maxCell = $PHPExcel->getActiveSheet()->getHighestRowAndColumn();
$maxColumn = self::getIndex($maxCell['column']);
// 一次讀一列
for ($row = 1; $row <= $maxCell['row']; $row++) {
// 讀出每一格
for ($column = 0; $column <= $maxColumn; $column++) {
$preview_data[$row][$column] = $sheet->getCellByColumnAndRow($column, $row)->getCalculatedValue();
}
}
$xoopsTpl->assign('preview_data', $preview_data);
//加入Token安全機制
include_once $GLOBALS['xoops']->path('class/xoopsformloader.php');
$token = new \XoopsFormHiddenToken();
$token_form = $token->render();
$xoopsTpl->assign("token_form", $token_form);
}
// 將文字轉為數字
private static function getIndex($let)
{
// Iterate through each letter, starting at the back to increment the value
for ($num = 0, $i = 0; $let != ''; $let = substr($let, 0, -1), $i++) {
$num += (ord(substr($let, -1)) - 65) * pow(26, $i);
}
return $num;
}
//批次匯入 Excel
public static function import_excel($action_id)
{
self::import_csv($action_id);
}
//取得報名的標題欄
public static function get_head($action, $return_type = false, $only_tdc = false)
{
$head_row = explode("\n", $action['setup']);
$head = $type = [];
foreach ($head_row as $head_data) {
$cols = explode(',', $head_data);
if (strpos($cols[0], '#') === false) {
$head[] = str_replace('*', '', trim($cols[0]));
$type[] = trim($cols[1]);
}
}
if (!$only_tdc) {
$head[] = _MD_TAD_SIGNUP_ACCEPT;
$head[] = _MD_TAD_SIGNUP_APPLY_DATE;
$head[] = _MD_TAD_SIGNUP_IDENTITY;
}
if ($return_type) {
return [$head, $type];
} else {
return $head;
}
}
//進行pdf的匯出設定
public static function pdf_setup($action_id)
{
global $xoopsTpl;
$action = Tad_signup_actions::get($action_id);
$xoopsTpl->assign('action', $action);
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('pdf_setup_id', $action_id);
$pdf_setup_col = $TadDataCenter->getData('pdf_setup_col', 0);
$to_arr = explode(',', $pdf_setup_col);
// 製作標題
$head_arr = self::get_head($action);
$from_arr = array_diff($head_arr, $to_arr);
$hidden_arr = [];
$tmt_box = Tmt::render('pdf_setup_col', $from_arr, $to_arr, $hidden_arr, true, false);
$xoopsTpl->assign('tmt_box', $tmt_box);
}
//儲存pdf的匯出設定
public static function pdf_setup_save($action_id, $pdf_setup_col = '')
{
$TadDataCenter = new TadDataCenter('tad_signup');
$TadDataCenter->set_col('pdf_setup_id', $action_id);
$TadDataCenter->saveCustomData(['pdf_setup_col' => [$pdf_setup_col]]);
}
}
link to https://github.com/tadlearn/tad_signup/commit/6e72592641cf5e7e409ef6a465f12e4894d402a0 \
