Tad 教材網 - 線上書籍

:::

7. XoopsModules\Tadtools\TadUpFiles 檔案上傳工具

9. XoopsModules\Tadtools\Bootstrap3Editable 點擊編輯 next

Tad Tools 使用說明
==============

```php
use XoopsModules\Tadtools\TadDataCenter;
```

### 建立資料表

```sql
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;
```

### 產生單一個表單欄位：

```php
$TadDataCenter = new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name, $col_sn);
$form = $TadDataCenter->getForm($mode, $form_tag, $name, $type, $value, $options, $attr, $sort);
```

### 產生批次表單欄位：

```php
$TadDataCenter = new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name, $col_sn);
$TadDataCenter->assignBatchForm($form_tag, $data_arr = array(), $type = '', $attr = []);
```

### 儲存資料：

```php
$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 = []);
```

### 取得資料陣列：

```php
$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]`...

###  刪除資料：

```php
$TadDataCenter = new TadDataCenter($module_dirname);
$TadDataCenter->set_col($col_name, $col_sn);
$TadDataCenter->delData($name, $sort);
```

eguide 語法相關
-----------

### eguide 語法文字轉表單：

```php
$TadDataCenter = new TadDataCenter($module_dirname);
$data = strToForm($setup = '');
```

$data 完整表單字串

### 取得所有的欄位設定：

```php
$TadDataCenter = new TadDataCenter($module_dirname);
$data = getAllCols($setup);
```

$data是二維陣列

### 取得所有欄位的某個項目值：

```php
$TadDataCenter = new TadDataCenter($module_dirname);
$data = $TadDataCenter->getAllColItems($setup, $item = 'label');
```

$data是一維陣列，索引值是 label

### 取得某一欄位設定：

```php
$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'\]

:::