Tad Tools 使用說明
use XoopsModules\Tadtools\TadDataCenter;
建立資料表
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;
產生單一個表單欄位：
$TadDataCenter = new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name, $col_sn);
$form = $TadDataCenter->getForm($mode, $form_tag, $name, $type, $value, $options, $attr, $sort);
產生批次表單欄位： $TadDataCenter = new TadDataCenter($module_dirname); $TadDataCenter->set_col($col_name, $col_sn); $TadDataCenter->assignBatchForm($form_tag, $data_arr = array(), $type = '', $attr = []);
儲存資料： $TadDataCenter = new TadDataCenter($module_dirname); $TadDataCenter->set_col($col_name, $col_sn); $TadDataCenter->saveData(); // 或 $data_arr = [ $data_name1 => [0 => $data_value1, 1 => $data_value2], $data_name2 => [0 => $data_value3], ]; $TadDataCenter->saveCustomData($data_arr = []);
取得資料陣列： $TadDataCenter = new TadDataCenter($module_dirname); $TadDataCenter->set_col($col_name, $col_sn); $data = $TadDataCenter->getData($name, $sort = 0); $xoopsTpl->assign('data', $data);
$data是二維陣列：$data['變數名稱1'][0]、$data['變數名稱1'][1]...
刪除資料： $TadDataCenter = new TadDataCenter($module_dirname); $TadDataCenter->set_col($col_name, $col_sn); $TadDataCenter->delData($name, $sort);eguide 語法相關
eguide 語法文字轉表單： $TadDataCenter = new TadDataCenter($module_dirname); $data = strToForm($setup = '');
$data 完整表單字串
取得所有的欄位設定： $TadDataCenter = new TadDataCenter($module_dirname); $data = getAllCols($setup);$data是二維陣列
取得所有欄位的某個項目值： $TadDataCenter = new TadDataCenter($module_dirname); $data = $TadDataCenter->getAllColItems($setup, $item = 'label');$data是一維陣列，索引值是 label
取得某一欄位設定： $TadDataCenter = new TadDataCenter($module_dirname); $data = $TadDataCenter->getColSetup($setup);$data 是一維陣列，包括：
- $data['form_tag']
- $data['label']
- $data['type']
- $data['value']
- $data['options']
- $data['attrs']
- $data['other']
- $data['help']
- $data['require']
- $data['kind']