<?php
namespace app\admin\controller\resource;
use app\common\controller\Backend;
use app\admin\model\Category;
use think\facade\Db;
/**
* 资源管理
*
* @icon fa fa-circle-o
*/
class Article extends Backend
{
/**
* Article模型对象
* @var \app\admin\model\resource\Article
*/
protected $model = null;
public function _initialize()
{
parent::_initialize();
$this->model = new \app\admin\model\resource\Article;
$this->view->assign("statusList", $this->model->getStatusList());
$this->view->assign('parentList',Category::cattre(['type'=>'resource']));
}
/**
* 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
* 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
* 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
*/
public function multiaddart(){
//设置过滤方法
$this->request->filter(['strip_tags', 'trim']);
if ($this->request->isAjax()){
$params = $this->request->post('row/a');
$rs=false;
try {
$titsiz=json_decode($params['desc'],true);//var_dump($titsiz);
$files=$params['files'];
$files=explode(',',$files);
$ins=[];
foreach ($titsiz as $k=>$v){
$ins[$k]['title']=$v['info'];
$ins[$k]['file_size']=$v['size'];
$ins[$k]['file']=$files[$k];
$ins[$k]['category_id']=$params['category_id'];
}
$rs=$this->model->saveAll($ins);
}catch (\Exception $e){
$this->error($e->getMessage());
}
if ($rs){
$this->success();
}else{
$this->error(__('No rows were inserted'));
}
}
return $this->view->fetch();
}
/**
* 查看
*/
public function index()
{
//当前是否为关联查询
$this->relationSearch = true;
//设置过滤方法
$this->request->filter(['strip_tags', 'trim']);
if ($this->request->isAjax()) {
// listenSql();
// var_dump(1);return;
//如果发送的来源是Selectpage,则转发到Selectpage
if ($this->request->request('keyField')) {
return $this->selectpage();
}
list($where, $sort, $order, $offset, $limit) = $this->buildparams();
// var_dump($where);
// var_dump($sort);
// var_dump($order);
// dump($this->model);
$total = $this->model
->withJoin(['category'])
->where($where)
->order($sort, $order)
->count();
$list = $this->model
->withJoin(['category'])
->where($where)
->order($sort, $order)
->limit($offset, $limit)
->select();
/// var_dump($list);
foreach ($list as $row) {
// var_dump($row->category);
if ($row->category){
$row->getRelation('category')->visible(['name']);
}
}
$result = array("total" => $total, "rows" => $list);
return json($result);
}
return $this->view->fetch();
}
}