<?php
namespace XoopsModules\Tadtools;
use Xmf\Request;
use XoopsModules\Tadtools\CkEditor;
use XoopsModules\Tadtools\FormValidator;
use XoopsModules\Tadtools\My97DatePicker;
use XoopsModules\Tadtools\SweetAlert;
use XoopsModules\Tadtools\TadUpFiles;
use XoopsModules\Tadtools\Utility;
/*
///單一表單
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$form=$TadDataCenter->getForm($mode, $form_tag, $name, $type, $value, $options, $attr, $sort);
///批次表單
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$TadDataCenter->assignBatchForm($form_tag, $data_arr = array(), $type = '', $attr=[])
///儲存資料：
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$TadDataCenter->saveData();
或
$data_arr=[
$data_name => [0 => $data_value],
$data_name => [0 => $data_value],
];
$TadDataCenter->saveCustomData($data_arr = array());
///取得資料陣列：
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$data=$TadDataCenter->getData($name,$sort=0);
$xoopsTpl->assign('TDC', $data);
<{$TDC.data_name.0}>
///刪除資料：
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$TadDataCenter->delData($name,$sort);
///-------------------------------------------------------------------------
///後台自訂問卷界面
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$xoopsTpl->assign('CustomSetupForm', $TadDataCenter->getCustomSetupForm($action));
<{$CustomSetupForm|default:''}>
///顯示問卷
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$xoopsTpl->assign('CustomForm', $TadDataCenter->getCustomForm($use_form = true, $use_submit = false, $action = '', $lw = 3, $rw = 9));
<{$CustomForm|default:''}>
///後台自訂問卷設定儲存
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$TadDataCenter->saveCustomSetupForm();
///前台自訂問卷答案儲存
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$TadDataCenter->saveData();
///自訂表單填答列表（表格）
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$getCustomAns=$TadDataCenter->getCustomAns();
///自訂表單題目
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$CustomSetup = $TadDataCenter->getCustomSetup();
///自訂表單填答陣列
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name,$col_sn);
$getCustomAnsArr=$TadDataCenter->getCustomAnsArr();
///文字轉表單
use XoopsModules\Tadtools\TadDataCenter;
$TadDataCenter=new TadDataCenter($module_dirname);
$Form = $TadDataCenter->strToForm($str);
資料表：
CREATE TABLE `模組名稱_data_center` (
`mid` mediumint(9) unsigned NOT NULL AUTO_INCREMENT COMMENT '模組編號',
`col_name` varchar(100) NOT NULL DEFAULT '' COMMENT '欄位名稱',
`col_sn` mediumint(9) unsigned NOT NULL DEFAULT '0' COMMENT '欄位編號',
`data_name` varchar(100) NOT NULL DEFAULT '' COMMENT '資料名稱',
`data_value` text NOT NULL COMMENT '儲存值',
`data_sort` mediumint(9) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`col_id` varchar(100) NOT NULL COMMENT '辨識字串',
`sort` mediumint(9) unsigned COMMENT '顯示順序',
`update_time` datetime NOT NULL COMMENT '更新時間',
PRIMARY KEY (`mid`,`col_name`,`col_sn`,`data_name`,`data_sort`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
*/
class TadDataCenter
{
public $col_name;
public $col_sn;
public $ans_col_name;
public $ans_col_sn;
public $module_dirname;
public $mid;
public $TadDataCenterTblName;
public $col_id;
public $attr_merge = true;
public $col_kind = [
'radio' => ['form_tag' => 'input', 'type' => 'radio'],
'checkbox' => ['form_tag' => 'input', 'type' => 'checkbox'],
'select' => ['form_tag' => 'select', 'type' => 'select'],
'textarea' => ['form_tag' => 'textarea', 'type' => 'textarea'],
'hidden' => ['form_tag' => 'input', 'type' => 'hidden'],
'const' => ['form_tag' => 'input', 'type' => 'hidden'],
'text' => ['form_tag' => 'input', 'type' => 'text'],
];
public function __construct($module_dirname = '')
{
global $xoopsDB;
if (! empty($module_dirname)) {
$this->set_module_dirname($module_dirname);
}
$this->TadDataCenterTblName = $xoopsDB->prefix("{$this->module_dirname}_data_center");
}
//設定模組名稱
public function set_module_dirname($module_dirname = '')
{
$this->module_dirname = $module_dirname;
$this->set_mid();
}
//設定模組編號
public function set_mid()
{
global $xoopsDB, $xoopsModule;
if ('' != $this->module_dirname) {
$sql = 'SELECT `mid` FROM `' . $xoopsDB->prefix('modules') . '` WHERE `dirname` = ?';
$result = Utility::query($sql, 's', [$this->module_dirname]) or Utility::web_error($sql, __FILE__, __LINE__);
list($this->mid) = $xoopsDB->fetchRow($result);
} elseif ($xoopsModule) {
$this->mid = $xoopsModule->mid();
}
return $this->mid;
}
public function set_col($col_name = '', $col_sn = '')
{
$this->col_name = $col_name;
$this->col_sn = $col_sn;
}
public function set_var($name = '', $val = '')
{
$this->$name = $val;
}
public function set_ans_col($ans_col_name = '', $ans_col_sn = '')
{
$this->ans_col_name = $ans_col_name;
$this->ans_col_sn = $ans_col_sn;
}
//取得表單
public function getForm($mode, $form_tag, $name, $type = '', $def_value = '', $options = [], $attr = [], $sort = null, $ans_col_name = '', $ans_col_sn = '')
{
global $xoopsTpl, $xoopsUser;
$myts = \MyTextSanitizer::getInstance();
if ('checkbox' === $type) {
$dbv = $this->getData($name, null, $ans_col_name, $ans_col_sn);
$value = isset($dbv[$name]) ? $dbv[$name] : $def_value;
} elseif ($sort > 0) {
$dbv = $this->getData($name, $sort, $ans_col_name, $ans_col_sn);
if (is_array($dbv)) {
$value = isset($dbv[$name]) ? $dbv[$name] : $def_value;
} else {
$value = isset($dbv) ? $dbv : $def_value;
}
} else {
$dbv = $this->getData($name, null, $ans_col_name, $ans_col_sn);
$value = isset($dbv[$name]) ? $dbv[$name][0] : $def_value;
}
if (is_array($value)) {
foreach ($value as $k => $v) {
$value[$k] = $myts->htmlSpecialChars($v);
}
} else {
$value = $myts->htmlSpecialChars($value);
}
if (in_array($type, ['radio', 'checkbox', 'checkbox-radio'])) {
$defalut_attr = ['class' => 'form-check-input'];
} elseif (in_array($form_tag, ['user_name', 'user_email'])) {
$defalut_attr = ['class' => "my-text"];
} elseif (in_array($form_tag, ['SchoolCode'])) {
$defalut_attr = ['class' => "my-input"];
} elseif (in_array($type, ['file'])) {
if (empty($dbv[$name][0]) || $dbv[$name][0] == 'files=') {
$require = $attr['require'];
}
$attr = [];
$defalut_attr = ['class' => 'form-check-input'];
} else {
$defalut_attr = ['class' => ['my-input', 'my-100'], 'id' => $name . $sort];
}
if ($this->attr_merge) {
$attr = array_merge_recursive($attr, $defalut_attr);
}
$attr_str = '';
foreach ($attr as $k => $v) {
$attr_str .= is_array($v) ? " {$k}=\"" . implode(' ', $v) . "\"" : " {$k}=\"{$v}\"";
}
$arr = ! is_null($sort) ? "[$sort]" : '';
switch ($form_tag) {
case 'select':
$options_str = '';
foreach ($options as $k => $v) {
$selected = $k == $value ? 'selected' : '';
$options_str .= "<option value=\"{$k}\" {$selected}>{$v}</option>\n";
}
$form = "<select name=\"TDC[{$name}]{$arr}\" value=\"{$value}\" {$attr_str}>
{$options_str}
</select>";
break;
case 'textarea':
$form = "<textarea name=\"TDC[{$name}]{$arr}\" {$attr_str}>{$value}</textarea>";
break;
case 'ckeditor':
$ck = new CkEditor($this->module_dirname, "TDC[{$name}]{$arr}", $value);
$ck->setHeight(120);
$ck->setToolbarSet('tadSimple');
$form = $ck->render();
break;
case 'note':
$options_str = implode('', $options);
$form = "<div class='form-control-static'><b>{$options_str}</b></div>";
break;
case 'user_name':
$user_name = $xoopsUser ? $xoopsUser->name() : '';
$value = empty($value) ? $user_name : $value;
$form = "<input type=\"text\" name=\"TDC[{$name}]{$arr}\" readonly value=\"{$value}\" {$attr_str}>";
break;
case 'user_email':
$email = $xoopsUser ? $xoopsUser->email() : '';
$value = empty($value) ? $email : $value;
$form = "<input type=\"text\" name=\"TDC[{$name}]{$arr}\" readonly value=\"{$value}\" {$attr_str}>";
break;
case 'SchoolCode':
$SchoolCode = $xoopsUser ? $xoopsUser->user_intrest() : '';
$value = empty($value) ? $SchoolCode : $value;
if (! empty($value)) {
// $handle = fopen("https://campus-xoops.tn.edu.tw/get_schools.php?SchoolCode=$value&mode=andCounty", "rb");
// $school_name = stream_get_contents($handle);
// $school_name = file_get_contents("https://campus-xoops.tn.edu.tw/get_schools.php?SchoolCode=$value&mode=andCounty");
$school_name = Utility::vita_get_url_content("https://campus-xoops.tn.edu.tw/get_schools.php?SchoolCode=$value&mode=andCounty");
// die($school_name);
}
if (empty($SchoolCode)) {
$form = "
<script type=\"text/javascript\">
$(document).ready(function(){
$('#school_code').autocomplete({
source: \"https://campus-xoops.tn.edu.tw/get_schools.php\",
select: function( event, ui ) {
console.log(ui.item.label);
$('#school_name').val(ui.item.label);
}
});
});
</script>
<input type=\"text\" name=\"TDC[{$name}]{$arr}\" id='school_code' value=\"{$value}\" {$attr_str}>
<input type=\"text\" name=\"TDC[school_name]{$arr}\" id='school_name' readonly class=\"my-text\">";
} else {
$form = "
<input type=\"text\" name=\"TDC[school_name]{$arr}\" readonly class=\"my-text\" value=\"{$school_name}\" {$attr_str}>
<input type=\"text\" name=\"TDC[{$name}]{$arr}\" readonly class=\"my-text\" value=\"{$value}\" {$attr_str}> ";
}
break;
case 'input':
default:
if ('radio' === $type) {
$form = '';
$tmp_id = $this->rand_str();
$idi = 0;
foreach ($options as $k => $v) {
$checked = $v == $value ? 'checked' : '';
$form .= "<div class=\"form-check-inline radio-inline\">
<label class=\"form-check-label\" for=\"{$tmp_id}{$idi}\" >
<input {$attr_str} type=\"{$type}\" name=\"TDC[{$name}]{$arr}\" id=\"{$tmp_id}{$idi}\" value=\"{$v}\" {$checked}>
{$k}
</label>
</div>\n";
$idi++;
}
} elseif ('checkbox' === $type) {
$form = '';
$tmp_id = $this->rand_str();
$idi = 0;
foreach ($options as $k => $v) {
$checked = is_array($value) && in_array($v, $value) ? 'checked' : '';
$form .= "<div class=\"form-check-inline checkbox-inline\">
<label class=\"form-check-label\" for=\"{$tmp_id}{$idi}\">
<input {$attr_str} type=\"{$type}\" name=\"TDC[{$name}]{$arr}[]\" id=\"{$tmp_id}{$idi}\" value=\"{$v}\" {$checked}>
{$k}
</label>
</div>\n";
$idi++;
}
} elseif ('checkbox-radio' === $type) {
$form = '';
$tmp_id = $this->rand_str();
$idi = 0;
foreach ($options as $k => $v) {
$checked = in_array($v, $value) ? 'checked' : '';
$form .= "<div class=\"form-check-inline checkbox-inline\">
<label class=\"form-check-label\" for=\"{$tmp_id}{$idi}\">
<input {$attr_str} type=\"checkbox\" name=\"TDC[{$name}]{$arr}\" id=\"{$tmp_id}{$idi}\" value=\"{$v}\" {$checked}>
{$k}
</label>
</div>\n";
$idi++;
}
} elseif ('date' === $type) {
$cal = new My97DatePicker();
$cal::render();
$form = "<input type=\"text\" name=\"TDC[{$name}]{$arr}\" value=\"{$value}\" {$attr_str} onClick=\"WdatePicker({dateFmt:'yyyy-MM-dd', startDate:'%y-%M-%d'})\">";
} elseif ('file' === $type) {
$file_name = $name;
$TadUpFiles = new TadUpFiles($this->module_dirname, '/' . $file_name);
if ($require) {
$TadUpFiles->set_var('require', true);
}
//必填
$TadUpFiles->set_var("show_tip", false); //不顯示提示
$TadUpFiles->set_col($this->ans_col_name, $this->ans_col_sn);
$form = $TadUpFiles->upform('list', $file_name, $maxlength, true, implode(',', $options), true, '', true);
$form .= "<input type='hidden' name='uploads[{$name}]' value='{$file_name}'>
<input type='hidden' name=\"TDC[{$name}][0]\" value=\"{$value}\">";
} elseif ('datetime' === $type) {
$cal = new My97DatePicker();
$cal::render();
$form = "<input type=\"text\" name=\"TDC[{$name}]{$arr}\" value=\"{$value}\" {$attr_str} onClick=\"WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss', startDate:'%y-%M-%d %H:%m:%s'})\">";
} elseif ('' == $type) {
$form = "<input type=\"text\" name=\"TDC[{$name}]{$arr}\" value=\"{$value}\" {$attr_str}>";
} else {
$form = "<input type=\"{$type}\" name=\"TDC[{$name}]{$arr}\" value=\"{$value}\" {$attr_str}>";
}
break;
}
if ($xoopsTpl and 'assign' === $mode) {
$xoopsTpl->assign($name, $form);
} elseif (isset($form)) {
return $form;
}
}
//套用文字框到Smarty
public function assignBatchForm($form_tag, $data_arr = [], $type = '', $attr = [])
{
foreach ($data_arr as $col_name) {
$this->getForm('assign', $form_tag, $col_name, $type, '', '', $attr);
}
}
//儲存資料 $data[]=['name'=>$name, 'value'=>$value, 'sort'=>$sort] 需修改
public function saveData()
{
global $xoopsDB;
$myts = \MyTextSanitizer::getInstance();
$TDC = $_POST['TDC'];
$dc_op = Request::getString('dc_op');
$sort = 0;
foreach ($TDC as $name => $value) {
$name = $myts->addSlashes($name);
$values = [];
if (! is_array($value)) {
$values[0] = $value;
} else {
$values = $value;
}
$this->delData($name, '', $this->col_name, $this->col_sn, __FILE__, __LINE__);
foreach ($values as $data_sort => $val) {
if ('saveCustomSetupForm' === $dc_op and empty($val)) {
continue;
}
$val = $myts->addSlashes($val);
$col_id = $this->col_id ? $this->col_id : "{$this->mid}-{$this->col_name}-{$this->col_sn}-{$name}-{$data_sort}";
$sql = 'REPLACE INTO `' . $this->TadDataCenterTblName . '`
(`mid`, `col_name`, `col_sn`, `data_name`, `data_value`, `data_sort`, `col_id`, `sort`, `update_time`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW())';
Utility::query($sql, 'isissisi', [$this->mid, $this->col_name, $this->col_sn, $name, $val, $data_sort, $col_id, $sort]) or die($xoopsDB->error());
}
$sort++;
}
if ($_POST['uploads']) {
foreach ($_POST['uploads'] as $name => $file_name) {
$TadUpFiles = new TadUpFiles($this->module_dirname, '/' . $file_name);
$TadUpFiles->set_col($this->col_name, $this->col_sn);
if (! empty($_FILES[$file_name]['name'][0])) {
$TadUpFiles->upload_file($file_name, 1920, 640, '', '', true, false, 'files_sn');
}
$files = $TadUpFiles->get_file();
$files_sn_arr = array_keys($files);
$data_sort = 0;
$col_id = $this->col_id ? $this->col_id : "{$this->mid}-{$this->col_name}-{$this->col_sn}-{$name}-{$data_sort}";
$sql = 'REPLACE INTO `' . $this->TadDataCenterTblName . '`
(`mid`, `col_name`, `col_sn`, `data_name`, `data_value`, `data_sort`, `col_id`, `sort`, `update_time`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW())';
Utility::query($sql, 'isissisis',
[$this->mid, $this->col_name, $this->col_sn, $name, "files=" . implode(',', $files_sn_arr), $data_sort, $col_id, $sort]) or Utility::web_error($sql, __FILE__, __LINE__, true);
$sort++;
}
}
}
//儲存資料 $data_arr=[$name=>array($sort=>$value)]
public function saveCustomData($data_arr = [], $mode = '')
{
global $xoopsDB;
$myts = \MyTextSanitizer::getInstance();
$sort = $old_data_sort = 0;
foreach ($data_arr as $name => $value) {
$name = $myts->addSlashes($name);
// 若為接續模式，取出目前最大 data_sort
if ($mode == 'append') {
$sql = 'SELECT MAX(`data_sort`) FROM `' . $this->TadDataCenterTblName . '` WHERE `mid` = ? AND `col_name` = ? AND `col_sn` = ? AND `data_name` = ?';
$result = Utility::query($sql, 'isis', [$this->mid, $this->col_name, $this->col_sn, $name]) or Utility::web_error($sql, __FILE__, __LINE__);
list($old_data_sort) = $xoopsDB->fetchRow($result);
$old_data_sort++;
}
$values = [];
if (! is_array($value)) {
$values[0] = $value;
} else {
$values = $value;
}
foreach ($values as $data_sort => $val) {
if ($mode == 'append') {
$data_sort += $old_data_sort;
}
$v = json_decode($val, true);
$val = $myts->addSlashes($val);
$this->delData($name, $data_sort, $this->col_name, $this->col_sn, __FILE__, __LINE__);
$col_id = isset($v['col_id']) ? $v['col_id'] : '';
if (! empty($this->col_id)) {
$col_id = $this->col_id;
}
if (\is_null($val)) {
$val = '';
}
// $sql = 'REPLACE INTO `' . $this->TadDataCenterTblName . '`
// (`mid`, `col_name`, `col_sn`, `data_name`, `data_value`, `data_sort`, `col_id`, `sort`, `update_time`)
// VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW())';
// Utility::query($sql, 'isissisi', [$this->mid, $this->col_name, $this->col_sn, $name, $val, $data_sort, $col_id, $sort]) or Utility::web_error($sql, __FILE__, __LINE__);
$sql = "REPLACE INTO `{$this->TadDataCenterTblName}`
(`mid` , `col_name` , `col_sn` , `data_name` , `data_value` , `data_sort`, `col_id`, `sort`, `update_time`)
values('{$this->mid}' , '{$this->col_name}' , '{$this->col_sn}' , '{$name}' , '{$val}' , '{$data_sort}', '{$col_id}' , '{$sort}', now())";
$xoopsDB->queryF($sql) or Utility::web_error($sql);
}
$sort++;
}
}
//取得資料
public function getData($name = '', $data_sort = null, $ans_col_name = '', $ans_col_sn = '', $data_value = '')
{
global $xoopsDB;
$myts = \MyTextSanitizer::getInstance();
$and_name = ('' != $name) ? "and `data_name`='{$name}'" : '';
$and_sort = ('' != $data_sort) ? "and `data_sort`='{$data_sort}'" : '';
$and_value = ('' != $data_value) ? "and `data_value`='{$data_value}'" : '';
$def_col_name = ! empty($ans_col_name) ? $ans_col_name : $this->col_name;
$def_col_sn = ! empty($ans_col_name) ? $ans_col_sn : $this->col_sn;
$and_col_name = ('' != $def_col_name) ? "and `col_name`='{$def_col_name}'" : '';
$and_col_sn = ('' != $def_col_sn) ? "and `col_sn`='{$def_col_sn}'" : '';
$sql = "desc `{$this->TadDataCenterTblName}` `sort`";
$result = $xoopsDB->queryF($sql);
$orderby = $xoopsDB->getRowsNum($result) ? "order by `sort` , `data_sort`" : "order by `data_sort`";
$sql = "select `col_sn`,`data_name`,`data_sort`, `data_value` from `{$this->TadDataCenterTblName}`
where `mid`= '{$this->mid}' {$and_col_name} {$and_col_sn} {$and_name} {$and_value} {$and_sort} {$orderby}";
$result = $xoopsDB->queryF($sql);
if (isset($data_sort)) {
list($col_sn, $data_name, $data_sort, $data_value) = $xoopsDB->fetchRow($result);
return $data_value;
}
$values = [];
while (list($col_sn, $data_name, $data_sort, $data_value) = $xoopsDB->fetchRow($result)) {
if (empty($def_col_sn) and ('' != $name)) {
$values[$col_sn][$data_sort] = $data_value;
} elseif (strpos($data_value, 'files=') !== false) {
$files_sn = str_replace('files=', '', $data_value);
$TadUpFiles = new TadUpFiles($this->module_dirname, '/' . $data_name);
$TadUpFiles->set_col($this->col_name, $this->col_sn);
$values[$data_name][$data_sort] = $TadUpFiles->get_file($files_sn);
} else {
$values[$data_name][$data_sort] = $data_value;
}
}
return $values;
}
//取得問卷題目資料
public function getDcqData($sort = '')
{
global $xoopsDB;
$myts = \MyTextSanitizer::getInstance();
$and_sort = ('' != $sort) ? "and `data_sort`='{$sort}'" : '';
$sql = "desc `{$this->TadDataCenterTblName}` `sort`";
$result = $xoopsDB->queryF($sql);
$orderby = $xoopsDB->getRowsNum($result) ? "order by `sort` , `data_sort`" : "order by `data_sort`";
$sql = "select * from `{$this->TadDataCenterTblName}`
where `mid`= '{$this->mid}' and `col_name`='{$this->col_name}' and `col_sn`='{$this->col_sn}' and `data_name`='dcq' {$and_sort} {$orderby}";
$result = $xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
if ($sort) {
$all = $xoopsDB->fetchArray($result);
return $all;
}
$values = [];
while ($all = $xoopsDB->fetchArray($result)) {
$data_sort = $all['data_sort'];
$all['name'] = "{$all['col_name']}_{$all['col_sn']}_dcq_{$all['col_id']}";
$all['data_json'] = json_decode($all['data_value'], true);
$values[$data_sort] = $all;
}
return $values;
}
//取得問卷題目簡易資料
public function getDcqSimpleData($key = 'name', $val = 'title')
{
$col_arr = [];
$dcq = $this->getDcqData();
foreach ($dcq as $col) {
$json = json_decode($col['data_value'], true);
$col_arr[$col[$key]] = $json[$val];
}
return $col_arr;
}
//刪除資料
public function delData($name = '', $data_sort = '', $col_name = null, $col_sn = null, $file = '', $line = '', $trash_can_table = '')
{
global $xoopsDB;
$and_name = ('' != $name) ? "and `data_name`='{$name}'" : '';
$and_sort = ('' != $data_sort) ? "and `data_sort`='{$data_sort}'" : '';
$col_name = ! is_null($col_name) ? $col_name : $this->col_name;
$col_sn = ! is_null($col_sn) ? $col_sn : $this->col_sn;
if (! empty($trash_can_table)) {
$sql = "REPLACE INTO " . $xoopsDB->prefix($trash_can_table) . " SELECT *
FROM `{$this->TadDataCenterTblName}` WHERE `mid`= '{$this->mid}' and `col_name`='{$col_name}' and `col_sn`='{$col_sn}' {$and_name} {$and_sort}";
$xoopsDB->queryF($sql) or Utility::web_error($sql, $file, $line);
}
$sql = "delete from `{$this->TadDataCenterTblName}`
where `mid`= '{$this->mid}' and `col_name`='{$col_name}' and `col_sn`='{$col_sn}' {$and_name} {$and_sort}";
$xoopsDB->queryF($sql) or Utility::web_error($sql, $file, $line);
}
public function mk_form_group($left_width, $right_width, $label, $form, $input_group = false, $help = '', $require = '')
{
$help_text = $help ? '<div><small class="text-muted">' . $help . '</small></div>' : '';
$ig_tag_start = $input_group ? '<div class="input-group">' : '';
$ig_tag_body = $input_group ? '<span class="input-group-btn">' . $input_group . '</span>' : '';
$ig_tag_end = $input_group ? '</div>' : '';
$require_mark = 1 == $require ? '<span style="display:inline-block; margin-right:4px; color:red;">*</span>' : '';
$padding_top = '';
if (strpos($form, 'form-check-inline') !== false) {
$padding_top = ' style="padding-top: 8px;"';
}
$main = '
<div class="form-group row mb-3">
<label class="col-sm-' . $left_width . ' control-label col-form-label text-md-right text-md-end">' . $require_mark . $label . '</label>
<div class="col-sm-' . $right_width . '" ' . $padding_top . '>
' . $ig_tag_start . '
' . $form . '
' . $ig_tag_body . '
' . $ig_tag_end . '
' . $help_text . '
</div>
</div>
';
return $main;
}
//$form_arr[]=array('0'=>4,'1'=>'xxx','2'='<input>');
public function mk_form_group_arr($form_arr, $id_content = '', $theme = '')
{
$main = $theme == 'vtable' ? "<ul $id_content>" : "<tr $id_content>";
foreach ($form_arr as $k => $form) {
if ($theme == 'vtable') {
$main .= '
<li class="vcell">' . $form[1] . '</li>
<li class="vm w' . $form[0] . '">' . $form[2] . '</li>
';
} else {
$main .= '
<td class="' . $form[0] . '" ' . $form[3] . '>' . $form[2] . '</td>
';
}
}
$main .= $theme == 'vtable' ? '</ul>' : '</tr>';
return $main;
}
//從界面取得自訂表單
public function getCustomSetupForm($action = "", $use_form = true, $id = "dcq_sort", $theme = 'vtable')
{
global $xoTheme;
$action = empty($action) ? $_SERVER['PHP_SELF'] : $action;
$DcqData = $this->getDcqData();
$sort = 0;
// Utility::dd(count($DcqData));
$item_count = count($DcqData);
if ($item_count > 0) {
$form_count = "var {$id}_count={$item_count};";
} else {
$form_count = "var {$id}_count=0;
{$id}_count = clone_{$id}({$id}_count);";
}
$document_ready = '
$(document).ready(function(){
$("#' . $id . '").sortable({ opacity: 0.6, cursor: "move", update: function() {
var order = $(".' . $id . '_arr").serialize();
// console.log(order);
$.post("' . XOOPS_URL . '/modules/tadtools/ajax_file.php?dcq_op=save_dcq_sort&col_sn=' . $this->col_sn . '&col_name=' . $this->col_name . '&dirname=' . $this->module_dirname . '", order, function(theResponse){
$("#save_msg").html(theResponse);
location.reload();
});
}
});
' . $form_count . '
$("#add_' . $id . '").click(function(){
' . $id . '_count = clone_' . $id . '(' . $id . '_count);
});
$(".remove_' . $id . '").click(function(){
console.log($(this).prop("id"));
$(this).closest("#form_data_' . $id . '" + $(this).prop("id")).remove();
});
});
function clone_' . $id . '(' . $id . '_count){
//複製一份表單
$("#' . $id . '").append($("#form_data_' . $id . '").clone().prop("id","form_data_' . $id . '" + ' . $id . '_count));
$("#form_data_' . $id . '" + ' . $id . '_count + " input").each(function(){
$(this).prop("name", $(this).prop("id") + "[" + ' . $id . '_count+"][" + $(this).data("col-name")+"]");
$(this).prop("id",$(this).prop("id").replace("][","_").replace("[","_").replace("]","_") + ' . $id . '_count);
});
$("#form_data_' . $id . '" + ' . $id . '_count + " select").each(function(){
$(this).prop("name",$(this).prop("id") + "[" + ' . $id . '_count+"][" + $(this).data("col-name")+"]");
$(this).prop("id",$(this).prop("id").replace("][","_").replace("[","_").replace("]","_") + ' . $id . '_count);
});
$("#form_data_' . $id . '" + ' . $id . '_count + " a.remove_' . $id . '").each(function(){
$(this).prop("id", ' . $id . '_count);
});
var new_num=' . $id . '_count+1;
$("#form_data_' . $id . '" + ' . $id . '_count + " span.num").each(function(){
$(this).prop("id", "' . $id . '-num-"+' . $id . '_count).text("#" + new_num);
});
$(".remove_' . $id . '").click(function(){
console.log($(this).prop("id"));
$(this).closest("#form_data_' . $id . '" + $(this).prop("id")).remove();
});
// $("#remove_' . $id . '" + ' . $id . '_count).click(function(){
// $(this).closest("#form_data_' . $id . '" + $(this).prop("name")).remove();
// });
' . $id . '_count++;
return ' . $id . '_count;
}
';
if ($theme == 'vtable') {
if ($xoTheme) {
$main = '';
$xoTheme->addStylesheet('modules/tadtools/css/my-input.css');
$xoTheme->addStylesheet('modules/tadtools/css/vtable.css');
$xoTheme->addScript('', null, $document_ready);
} else {
$main = '
<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="' . XOOPS_URL . '/modules/tadtools/css/my-input.css">
<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="' . XOOPS_URL . '/modules/tadtools/css/vtable.css">
<script type="text/javascript">
' . $document_ready . '
</script>';
}
} else {
if ($xoTheme) {
$main = '';
$xoTheme->addScript('', null, $document_ready);
} else {
$main = '
<script type="text/javascript">
' . $document_ready . '
</script>';
}
}
$main .= $use_form ? '<form action="' . $action . '" method="post" class="form-horizontal" id="' . $id . '">' : '';
$id_col = $use_form ? '' : 'id="' . $id . '"';
if ($theme == 'vtable') {
$main .= '
<div id="save_msg"></div>
<div class="vtable" ' . $id_col . '>
<ul class="vhead">
<li class="w1">題號</li>
<li class="w1">欄位名稱</li>
<li class="w2">提示或說明</li>
<li class="w1">欄位類型</li>
<li class="w2">選項（用 ; 隔開）</li>
<li class="w1">必填</li>
<li class="w1"><span data-toggle="tooltip" data-placement="top" data-bs-toggle="tooltip" data-bs-placement="top" title="給程式讀取用，無須修改，若要修改，影確保其為唯一值">隨機唯一碼</span></li>
</ul>';
} else {
$main .= '
<div id="save_msg"></div>
<div class="table-responsive">
<table class="table table-bordered table-sm" >
<tr class="bg-light">
<td class="c nw">題號</td>
<td class="c nw">欄位名稱</td>
<td class="c nw">提示或說明</td>
<td class="c nw">欄位類型</td>
<td class="c nw">選項（用 ; 隔開）</td>
<td class="c nw">必填</td>
<td class="c nw"><span data-toggle="tooltip" data-placement="top" data-bs-toggle="tooltip" data-bs-placement="top" title="給程式讀取用，無須修改，若要修改，影確保其為唯一值">隨機唯一碼</span></td>
</tr>
<tbody ' . $id_col . '>
';
}
foreach ($DcqData as $sort => $data) {
$main .= $this->getCustomSetupCol($sort, $data['data_value'], $data['col_id'], $id, $theme);
$sort++;
}
// 樣板
$main .= $theme == 'vtable' ? "\n<span style='display:none;'>\n" : "\n</tbody>\n<tbody style='display:none;'>\n";
$main .= $this->getCustomSetupCol($sort, 'template', '', $id, $theme);
$sort++;
$main .= $theme == 'vtable' ? "\n</span>\n" : "\n</tbody>\n";
$main .= "\n</table>\n</div>\n";
$main .= '<input type="hidden" name="dc_op" value="saveCustomSetupForm">';
$main .= '<input type="hidden" name="' . $this->col_name . '" value="' . $this->col_sn . '">';
$main .= $use_form ? '<div class="text-center" style="margin:10px auto;"><button type="submit" class="btn btn-primary">儲存</button></div>' : '';
$main .= $use_form ? '</form>' : '';
$main .= '<div class="text-right text-end">
<a href="#' . $id . '" id="add_' . $id . '" class="btn btn-sm btn-info"><i class="fa fa-plus"></i> 新增一列</a>
</div>';
$SweetAlert = new SweetAlert();
$SweetAlert->render('del_' . $this->col_name . '_dcq_col', XOOPS_URL . "/modules/tadtools/ajax_file.php?dcq_op=del_dcq_col&col_name={$this->col_name}&col_sn={$this->col_sn}&dirname={$this->module_dirname}&col_id=", 'col_id');
return $main;
}
//取得設定界面的單一欄位
private function getCustomSetupCol($sort, $json = '', $col_id = '', $id = '', $theme = '')
{
$val = $json != 'template' ? json_decode($json, true) : [];
$id_content = $json != 'template' ? '' : 'id="form_data_' . $id . '"';
$myts = \MyTextSanitizer::getInstance();
$col_type_arr['input=text'] = _TDC_INPUT;
$col_type_arr['input=radio'] = _TDC_RADIO;
$col_type_arr['input=checkbox'] = _TDC_CHECKBOX;
$col_type_arr['input=date'] = _TDC_DATE;
$col_type_arr['input=file'] = _TDC_FILE;
$col_type_arr['select'] = _TDC_SELECT;
$col_type_arr['textarea'] = _TDC_TEXTAREA;
$col_type_arr['ckeditor'] = _TDC_CKEDITOR;
$col_type_arr['note'] = _TDC_NOTE;
$col_type_arr['user_name'] = _TDC_USER_NAME;
$col_type_arr['user_email'] = _TDC_USER_EMAIL;
$col_type_arr['SchoolCode'] = _TDC_SCHOOL_CODE;
$option = '';
foreach ($col_type_arr as $type => $text) {
$selected = $val['type'] == $type ? 'selected' : '';
$option .= '<option value="' . $type . '" ' . $selected . '>' . $text . '</option>';
}
if ($json != 'template') {
$del = ($col_id) ? "<a href=\"javascript:del_{$this->col_name}_dcq_col('{$col_id}')\" style='color:red;'><i class='fa fa-trash' title='" . _TAD_DEL . "'></i></a>
<input type='hidden' class='{$id}_arr' name='col_ids[]' value='{$col_id}'> " : '';
} else {
$del = '<a href="#' . $id . '" id="remove_' . $id . '" style="color:red;" class="remove_' . $id . '"><i class="fa fa-trash" title="' . _TAD_DEL . '"></i></a> ';
}
$i = $sort + 1;
$class = $theme == 'vtable' ? '1' : 'px-2 nw';
$form_arr[] = [$class, '', $del . "<span id='{$id}-num-{$i}' class='num'>#{$i}</span>"];
$col_name_sn = 'dcq[' . $this->col_name . '][' . $this->col_sn . ']';
$name_id = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][title]"' : 'id="' . $col_name_sn . '" data-col-name="title"';
$class = $theme == 'vtable' ? '2' : 'c';
$form_arr[] = [$class, '#' . $i, '<input type="text" ' . $name_id . ' class="my-input my-100" placeholder="' . _TDC_INPUT_TITLE . '" value="' . $myts->htmlSpecialChars($val['title']) . '">'];
$name_id = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][placeholder]"' : 'id="' . $col_name_sn . '" data-col-name="placeholder"';
$class = $theme == 'vtable' ? '1' : 'c';
$form_arr[] = [$class, _TDC_DESCRIPTION, '<input type="text" ' . $name_id . ' class="my-input my-100" placeholder="' . _TDC_INPUT_DESCRIPTION . '" value="' . $myts->htmlSpecialChars($val['placeholder']) . '">'];
$name_id = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][type]"' : 'id="' . $col_name_sn . '" data-col-name="type"';
$class = $theme == 'vtable' ? '1' : 'c';
$form_arr[] = [$class, _TDC_TYPE, '<select ' . $name_id . ' class="my-input my-100">' . $option . '</select>'];
$name_id = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][opt]"' : 'id="' . $col_name_sn . '" data-col-name="opt"';
$class = $theme == 'vtable' ? '2' : 'c';
$form_arr[] = [$class, _TDC_OPTIONS, '<input type="text" ' . $name_id . ' class="my-input my-100" placeholder="' . _TDC_OPTIONS_NOTE . '" value="' . $myts->htmlSpecialChars($val['opt']) . '">'];
$name_id = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][require]"' : 'id="' . $col_name_sn . '" data-col-name="require"';
$checked = 1 == $val['require'] ? 'checked' : '';
$class = $theme == 'vtable' ? '1' : 'px-2 nw';
$form_arr[] = [$class, _TDC_REQUIRE . $i, '<label class="checkbox-inline"><input type="checkbox" ' . $name_id . ' value="1" ' . $checked . '>' . _TDC_REQUIRE . '</label>'];
$name_id1 = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][old_col_id]"' : 'id="' . $col_name_sn . '" data-col-name="old_col_id"';
$name_id2 = $json != 'template' ? 'name="' . $col_name_sn . '[' . $sort . '][col_id]"' : 'id="' . $col_name_sn . '" data-col-name="col_id"';
$class = $theme == 'vtable' ? '1' : 'c';
$form_arr[] = [$class, _TDC_COL_ID, '<input type="hidden" ' . $name_id1 . ' value="' . $col_id . '"><input type="text" ' . $name_id2 . ' class="my-input my-100" placeholder="' . _TDC_INPUT_COL_ID . '" value="' . $col_id . '" title="' . _TDC_INPUT_COL_ID . '">'];
$main = $this->mk_form_group_arr($form_arr, $id_content, $theme);
return $main;
}
//儲存自訂表單設定
public function saveCustomSetupForm($redirict = true, $new_col_sn = '')
{
$dc_op = Request::getString('dc_op');
if ('saveCustomSetupForm' === $dc_op) {
$this->saveDcqData($new_col_sn);
if ($redirict) {
header("location: {$_SERVER['HTTP_REFERER']}");
exit;
}
}
}
//儲存自訂問卷資料資料
private function saveDcqData($new_col_sn = '')
{
global $xoopsDB;
$myts = \MyTextSanitizer::getInstance();
$dcq = Request::getArray('dcq');
$dc_op = Request::getString('dc_op');
foreach ($dcq as $col_name => $dcq_items) {
foreach ($dcq_items as $col_sn => $dcq_item) {
if (! empty($new_col_sn)) {
$col_sn = $new_col_sn;
}
foreach ($dcq_item as $data_sort => $item) {
if ('saveCustomSetupForm' === $dc_op and empty($item['title'])) {
continue;
}
$json_val = json_encode($item, JSON_UNESCAPED_UNICODE);
$json_val = $myts->addSlashes($json_val);
$this->delData('dcq', $data_sort, $col_name, $col_sn, __FILE__, __LINE__);
if (! empty($item['col_id'])) {
$col_id = $item['col_id'];
} else {
if ($item['type'] == "SchoolCode") {
$col_id = 'schoolcode';
} elseif ($item['type'] == "user_name") {
$col_id = 'username';
} elseif ($item['type'] == "user_email") {
$col_id = 'useremail';
} else {
$col_id = $this->rand_str();
}
}
$sql = "replace into `{$this->TadDataCenterTblName}`
(`mid` , `col_name` , `col_sn` , `data_name` , `data_value` , `data_sort`, `col_id` , `sort`, `update_time`)
values('{$this->mid}' , '{$col_name}' , '{$col_sn}' , 'dcq' , '{$json_val}' , '{$data_sort}' , '{$col_id}' , '{$sort}' , now())";
$xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
if ($item['col_id'] != $item['old_col_id']) {
$this->update_col_id($item['old_col_id'], $item['col_id']);
}
}
}
}
}
//更新辨識碼
private function update_col_id($old_col_id, $new_col_id)
{
global $xoopsDB;
$sql = 'UPDATE `' . $this->TadDataCenterTblName . '` SET `data_name`=? WHERE `data_name`=?';
$params = [$this->col_name . '_' . $this->col_sn . '_dcq_' . $new_col_id, $this->col_name . '_' . $this->col_sn . '_dcq_' . $old_col_id];
Utility::query($sql, 'ss', $params) or Utility::web_error($sql, __FILE__, __LINE__);
}
//取得自訂表單題目設定
public function getCustomSetup()
{
$DcqData = $this->getDcqData();
$dcq_arr = [];
foreach ($DcqData as $sort => $data) {
$dcq = json_decode($data['data_value'], true);
list($dcq['form_tag'], $dcq['type']) = explode('=', $dcq['type']);
$dcq['name'] = "{$this->col_name}_{$this->col_sn}_dcq_{$data['col_id']}";
$options = explode(';', $dcq['opt']);
$option_arr = [];
foreach ($options as $opt) {
if (false !== mb_strpos($opt, '=')) {
list($key, $val) = explode('=', $opt);
} else {
$key = $val = $opt;
}
$option_arr[$key] = $val;
}
$dcq['option_arr'] = $option_arr;
$dcq_arr[$sort] = $dcq;
}
return $dcq_arr;
}
//取得自訂表單
public function getCustomForm($use_form = true, $use_submit = false, $action = '', $lw = 3, $rw = 9, $muti_sort = null)
{
global $xoTheme;
$action = empty($action) ? $_SERVER['PHP_SELF'] : $action;
$DcqData = $this->getDcqData();
$form_col = '';
foreach ($DcqData as $data) {
// 該欄位的細項設定
$dcq = json_decode($data['data_value'], true);
list($form_tag, $type) = explode('=', $dcq['type']);
$name = "{$this->col_name}_{$this->col_sn}_dcq_{$data['col_id']}";
$options = explode(';', $dcq['opt']);
$option_arr = [];
foreach ($options as $opt) {
if (false !== mb_strpos($opt, '=')) {
list($key, $val) = explode('=', $opt);
} else {
$key = $val = $opt;
}
$option_arr[$key] = $val;
}
$require = 1 == $dcq['require'] ? ' validate[required]' : '';
if (in_array($type, ['radio', 'checkbox', 'checkbox-radio'])) {
$attr_arr = ['class' => $require];
} elseif (in_array($form_tag, ['user_name', 'user_email', 'SchoolCode'])) {
$attr_arr = ['class' => $require];
} elseif (in_array($type, ['file'])) {
$attr_arr = ['require' => $dcq['require']];
} else {
$attr_arr = ['class' => "my-input my-100 $require"];
}
$muti_sort = $muti_sort ? $muti_sort : null;
$col = $this->getForm('return', $form_tag, $name, $type, null, $option_arr, $attr_arr, $muti_sort, $this->ans_col_name, $this->ans_col_sn);
$form_col .= $this->mk_form_group($lw, $rw, $dcq['title'], $col, false, $dcq['placeholder'], $dcq['require']);
}
if ($form_col) {
if ($xoTheme) {
$form = '';
$xoTheme->addStylesheet('modules/tadtools/css/my-input.css');
} else {
$form = '<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="' . XOOPS_URL . '/modules/tadtools/css/my-input.css">';
}
if ($use_form) {
$FormValidator = new FormValidator('#myForm', false);
$FormValidator->render('topLeft');
$form .= '<form action="' . $action . '" id="myForm" method="post" class="form-horizontal" enctype="multipart/form-data">';
}
$form .= $form_col;
$form .= '
<input type="hidden" name="' . $this->ans_col_name . '" value="' . $this->ans_col_sn . '">
<input type="hidden" name="dirname" value="' . $this->module_dirname . '">
<input type="hidden" name="col_name" value="' . $this->ans_col_name . '">
<input type="hidden" name="col_sn" value="' . $this->ans_col_sn . '">';
$form .= $use_submit ? $this->mk_form_group($lw, $rw, '', '<button type="submit" class="btn btn-primary">' . _TAD_SAVE . '</button>') : '';
$form .= '<input type="hidden" name="dcq_op" value="saveCustomSetupFormVal">';
$form .= $use_form ? '</form>' : '';
return $form;
}
}
//已填答案列表： $del_col_name= 'uid'(顯示刪除，並以 uid 為參數) ，$display_mode=vertical
public function getCustomAns($call_back_func = '', $del_col_name = false, $display_mode = '')
{
global $xoTheme;
$DcqData = $this->getDcqData();
if ($xoTheme) {
$xoTheme->addStylesheet('modules/tadtools/css/vtable.css');
$main = '';
} else {
$main = '<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="' . XOOPS_URL . '/modules/tadtools/css/vtable.css">';
}
$col_type = [];
if ('vertical' === $display_mode) {
$main .= "<div class='vtable'>";
foreach ($DcqData as $sort => $data) {
$dcq = json_decode($data['data_value'], true);
list($form_tag, $type) = explode('=', $dcq['type']);
if ('note' === $form_tag) {
continue;
}
$dcq_title = $dcq['title'];
$data_name = "{$this->col_name}_{$this->col_sn}_dcq_{$data['col_id']}";
$ans = $this->getDcqDataArr($data_name);
$col_type[$data_name] = $dcq['type'];
$answer = [];
foreach ($ans as $a) {
$answer[] = nl2br(implode('、', $a[$data_name]));
}
$dcq_answer = implode(';', $answer);
$main .= "<ul>
<li class='w2 vtitle'>$dcq_title</li>
<li class='w8'>$dcq_answer</li>
</ul>";
}
if ($del_col_name) {
$main .= "<ul>
<li class='w2 vtitle'>" . _TAD_FUNCTION . "</li>
<li class='w8'><li style='text-align: center;'><a href='javascript:del_dcq_ans({$this->col_sn})' style='color:red;'><li class='fa fa-trash' title='" . _TAD_DEL . "'></li></li>
</ul>";
}
$main .= '</div>';
} else {
$main .= "
<div class='vtable'>
<ul class='vhead'>
<li>" . _TDC_FILL_PEOPLE . '</li>
';
foreach ($DcqData as $sort => $data) {
$dcq = json_decode($data['data_value'], true);
list($form_tag, $type) = explode('=', $dcq['type']);
if ('note' === $form_tag) {
continue;
}
$dcq_title = $dcq['title'];
$name[$dcq_title] = $data_name = "{$this->col_name}_{$this->col_sn}_dcq_{$data['col_id']}";
$col_type[$data_name] = $dcq['type'];
$main .= "<li style='text-align: center;'>{$dcq_title}</li>";
}
if ($del_col_name) {
$main .= '<li>' . _TAD_FUNCTION . '</li>';
}
$main .= '</ul>';
$data_name_arr = [];
$ans = $this->getDcqDataArr($name);
foreach ($ans as $col_sn => $ans_arr) {
$title = ($call_back_func) ? call_user_func($call_back_func, $col_sn, $this->col_name, $this->col_sn) : $col_sn;
$main .= "<ul>
<li class='vcell'>" . _TDC_FILL_PEOPLE . "</li>
<li style='text-align: center;'>{$title}</li>";
foreach ($name as $dcq_title => $data_name) {
$css = $col_type[$data_name] == 'textarea' ? '' : "class='text-center'";
$main .= "<li class='vcell'>{$dcq_title}</li>
<li $css>";
if ($col_type[$data_name] == 'input=file') {
$TadUpFiles = new TadUpFiles($this->module_dirname, '/' . $data_name);
$TadUpFiles->set_col($this->ans_col_name, $col_sn);
$main .= $TadUpFiles->show_files('', true, 'filename', false, false, null, null, false);
} else {
$main .= nl2br(implode('、', $ans_arr[$data_name]));
}
$main .= '</li>';
$data_name_arr[$data_name] = $data_name;
}
if ($del_col_name) {
$main .= "<li style='text-align: center;'><a href='javascript:del_dcq_ans({$col_sn})' style='color:red;'><i class='fa fa-trash' title='" . _TAD_DEL . "'></i>
</a></li>";
}
$main .= '</ul>';
}
$main .= '</div>';
}
if ($del_col_name) {
$data_name = implode('|', $data_name_arr);
$SweetAlert = new SweetAlert();
$SweetAlert->render('del_dcq_ans', XOOPS_URL . "/modules/tadtools/ajax_file.php?dcq_op=del_dcq_ans&data_name={$data_name}&dirname={$this->module_dirname}&col_name={$del_col_name}&col_sn=", 'col_ans_sn');
}
return $main;
}
//已填答案陣列
public function getCustomAnsArr()
{
$DcqData = $this->getDcqData();
foreach ($DcqData as $sort => $data) {
$dcq = json_decode($data['data_value'], true);
list($form_tag, $type) = explode('=', $dcq['type']);
if ('note' === $form_tag) {
continue;
}
$name[] = "{$this->col_name}_{$this->col_sn}_dcq_{$data['col_id']}";
}
$ans = $this->getDcqDataArr($name);
return $ans;
}
//取得填答資料陣列
public function getDcqDataArr($data_name = '')
{
global $xoopsDB;
$and_col_name = $this->ans_col_name ? "AND `col_name`=?" : '';
$and_col_sn = $this->ans_col_sn ? "AND `col_sn`=?" : '';
$values = [];
$params = [];
if (is_array($data_name)) {
foreach ($data_name as $name) {
$params[] = $this->mid;
$params[] = $name;
if ($this->ans_col_name) {
$params[] = $this->ans_col_name;
}
if ($this->ans_col_sn) {
$params[] = $this->ans_col_sn;
}
$sql = 'SELECT `col_sn`, `data_sort`, `data_value` FROM `' . $this->TadDataCenterTblName . '`
WHERE `mid`= ? AND `data_name`=? ' . $and_col_name . ' ' . $and_col_sn . ' ORDER BY `col_sn`';
$result = Utility::query($sql, str_repeat('s', count($params)), $params) or Utility::web_error($sql, __FILE__, __LINE__);
while (list($col_sn, $data_sort, $data_value) = $xoopsDB->fetchRow($result)) {
$values[$col_sn][$name][$data_sort] = $data_value;
}
$params = []; // Reset params for the next iteration
}
} else {
$params[] = $this->mid;
$params[] = $data_name;
if ($this->ans_col_name) {
$params[] = $this->ans_col_name;
}
if ($this->ans_col_sn) {
$params[] = $this->ans_col_sn;
}
$sql = 'SELECT `col_sn`, `data_sort`, `data_value` FROM `' . $this->TadDataCenterTblName . '`
WHERE `mid`= ? AND `data_name`=? ' . $and_col_name . ' ' . $and_col_sn . ' ORDER BY `col_sn`';
$result = Utility::query($sql, str_repeat('s', count($params)), $params) or Utility::web_error($sql, __FILE__, __LINE__);
while (list($col_sn, $data_sort, $data_value) = $xoopsDB->fetchRow($result)) {
$values[$col_sn][$data_name][$data_sort] = $data_value;
}
}
return $values;
}
// public function getDcqDataArr($data_name = '')
// {
// global $xoopsDB;
// $and_col_name = $this->ans_col_name ? "and `col_name`='{$this->ans_col_name}'" : '';
// $and_col_sn = $this->ans_col_sn ? "and `col_sn`='{$this->ans_col_sn}'" : '';
// $values = [];
// if (is_array($data_name)) {
// foreach ($data_name as $name) {
// $sql = "select col_sn, data_sort ,data_value from `{$this->TadDataCenterTblName}`
// where `mid`= '{$this->mid}' and `data_name`='{$name}' $and_col_name $and_col_sn order by col_sn";
// $result = $xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
// while (list($col_sn, $data_sort, $data_value) = $xoopsDB->fetchRow($result)) {
// $values[$col_sn][$name][$data_sort] = $data_value;
// }
// }
// } else {
// $sql = "select col_sn, data_sort ,data_value from `{$this->TadDataCenterTblName}`
// where `mid`= '{$this->mid}' and `data_name`='{$data_name}' $and_col_name $and_col_sn order by col_sn";
// $result = $xoopsDB->queryF($sql) or Utility::web_error($sql, __FILE__, __LINE__);
// while (list($col_sn, $data_sort, $data_value) = $xoopsDB->fetchRow($result)) {
// $values[$col_sn][$data_name][$data_sort] = $data_value;
// }
// }
// return $values;
// }
// 文字轉表單
public function strToForm($setup = '')
{
global $xoTheme;
if ($xoTheme) {
$main = '';
$xoTheme->addStylesheet('modules/tadtools/css/my-input.css');
} else {
$main = '<link rel="stylesheet" type="text/css" media="all" title="Style sheet" href="' . XOOPS_URL . '/modules/tadtools/css/my-input.css">';
}
$cols = $this->getAllCols($setup);
$sort = 0;
foreach ($cols as $col) {
$sort++;
$form = $this->getForm('return', $col['form_tag'], $col['label'], $col['type'], $col['value'], $col['options'], $col['attrs']) . $col['other'];
$main .= $this->mk_form_group(2, 10, $col['label'], $form, false, $col['help'], $col['require']);
}
return $main;
}
// 取得所有的欄位設定
public function getAllCols($setup)
{
$setups = \explode("\n", $setup);
$cols = [];
foreach ($setups as $setup) {
$cols[] = $this->getColSetup($setup);
}
return $cols;
}
// 取得所有欄位的某個項目值
public function getAllColItems($setup, $item = 'label')
{
$setups = \explode("\n", $setup);
$items = [];
foreach ($setups as $setup) {
$col = $this->getColSetup($setup);
$label = $col['label'];
// $items[$label] = $col[$item];
$items[] = $col[$item];
}
return $items;
}
// 取得欄位設定
public function getColSetup($setup)
{
$setup = \trim($setup);
$cols = \explode(",", $setup);
if (! isset($cols[1])) {
$cols[1] = '';
}
$options = $attrs = [];
unset($value);
$type = $help = $other = $form_tag = $value = $col_kind = $require = '';
foreach ($cols as $i => $col) {
if (\strpos($col, '#') !== false) {
$help = \str_replace('#', '', $col);
} elseif ($i == 0) {
$label = $col;
if (\strpos($label, '*') !== false) {
$require = 1;
$attrs['class'][] = 'validate[required]';
$label = \str_replace('*', '', $label);
}
} elseif ($i == 1) {
if (strpos($cols[1], '=') === false) {
$col_kind = $cols[1];
if (! empty($col_kind) && isset($this->col_kind[$col_kind])) {
$form_tag = $this->col_kind[$col_kind]['form_tag'];
$type = $this->col_kind[$col_kind]['type'];
} else {
$form_tag = 'input';
$type = 'text';
}
} else {
list($k, $v) = explode('=', $cols[1]);
$attrs[$k] = $v;
$form_tag = 'input';
$col_kind = $type = 'text';
}
} else {
if (\strpos($col, '+') !== false) {
$col = \str_replace('+', '', $col);
if ($type == 'checkbox') {
$value[] = $col;
} else {
$value = $col;
}
} elseif ($cols[1] == 'const') {
$other = $value = $col;
} elseif ($cols[1] == 'hidden') {
$value = $col;
}
if (\in_array($type, ['select', 'radio', 'checkbox'])) {
$options[$col] = $col;
} elseif (strpos($col, '=') !== false) {
list($k, $v) = explode('=', $col);
$attrs[$k] = $v;
}
}
}
$col_setup['form_tag'] = $form_tag;
$col_setup['label'] = $label;
$col_setup['type'] = $type;
$col_setup['value'] = $value;
$col_setup['options'] = $options;
$col_setup['attrs'] = $attrs;
$col_setup['other'] = $other;
$col_setup['help'] = $help;
$col_setup['require'] = $require;
$col_setup['kind'] = $col_kind;
return $col_setup;
}
private function rand_str($len = 6, $format = 'ALL')
{
switch ($format) {
case 'ALL':
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
break;
case 'CHAR':
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz';
break;
case 'NUMBER':
$chars = '0123456789';
break;
default:
$chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
break;
}
list($usec, $sec) = explode(' ', microtime());
$seed = (float) $sec + ((float) $usec * 100000);
mt_srand(intval($seed));
$password = '';
while (mb_strlen($password) < $len) {
$password .= mb_substr($chars, (mt_rand() % mb_strlen($chars)), 1);
}
return $password;
}
}