#### 任務表
結構
~~~
CREATE TABLE `acc_dragon_task` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`mail_id` smallint(255) NOT NULL COMMENT '郵件ID',
`title` varchar(255) NOT NULL COMMENT '標題',
`issue_at` datetime NOT NULL COMMENT '定時時間',
`complete_at` datetime DEFAULT NULL COMMENT '完成時間',
`issuetype` tinyint(4) NOT NULL COMMENT '發放類型：0 即時發放 1定時發放',
`characterid` int(4) NOT NULL DEFAULT '0' COMMENT '每日',
`status` tinyint(4) NOT NULL COMMENT '發放狀態',
`comments` varchar(255) DEFAULT NULL COMMENT '備注',
`create_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '創建時間',
`update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
~~~
任務列表（獲取器）
~~~
namespace app\index\model;
use think\Model;
class Task extends Model
{
protected function initialize()
{
//繼承父類
parent::initialize();
$this->table = 'acc_dragon_task';
}
/**
* 發放類型獲取器
* @DateTime 2018-01-23
* @param [type] $value [description]
* @return [type]
*/
public function getIssuetypeAttr($value)
{
$types = [0 => '即時發放', 1 => '定時發放'];
return $types[$value];
}
/**
* 列表(主鍵列表，條件數組，閉包查詢)
*/
public function doList($param = null)
{
//參數查詢
//
$result = self::all($param);
$rows = [];
foreach ($result as $data) {
$item = $data->getData();
$item['issuetype'] = $data->getAttr('issuetype'); //訪問獲取器
array_push($rows, $item);
}
//查詢總計
$total = count($rows);
$res = array();
if ($total > 0) {
$res['rows'] = $rows;
$res['total'] = $total;
} else {
$res['rows'] = array();
$res['total'] = 0;
}
//返回信息
_callback($res);
}
}
~~~
