Example #1
0
 /**
  * export csv
  *
  * @return csv 
  */
 public function exportExcel()
 {
     $sort = $this->request->data('sidx');
     $order = $this->request->data('sord');
     $keywords = $this->request->data('keywords');
     $begin_time = $this->request->data('begin_time');
     $end_time = $this->request->data('end_time');
     $where = [];
     if (!empty($keywords)) {
         $where[' username like'] = "%{$keywords}%";
     }
     if (!empty($begin_time) && !empty($end_time)) {
         $begin_time = date('Y-m-d', strtotime($begin_time));
         $end_time = date('Y-m-d', strtotime($end_time));
         $where['and'] = [['date(`ctime`) >' => $begin_time], ['date(`ctime`) <' => $end_time]];
     }
     $Table = $this->Menu;
     $column = ['节点名称', '路径', '父ID', '样式', '排序', '是否在菜单显示', '状态', '备注'];
     $query = $Table->find();
     $query->hydrate(false);
     $query->select(['name', 'node', 'pid', 'class', 'rank', 'is_menu', 'status', 'remark']);
     if (!empty($where)) {
         $query->where($where);
     }
     if (!empty($sort) && !empty($order)) {
         $query->order([$sort => $order]);
     }
     $res = $query->toArray();
     $this->autoRender = false;
     $filename = 'Menu_' . date('Y-m-d') . '.csv';
     \Admin\Utils\Export::exportCsv($column, $res, $filename);
 }
 /**
  * export csv
  *
  * @return csv 
  */
 public function exportExcel()
 {
     $sort = $this->request->data('sidx');
     $order = $this->request->data('sord');
     $keywords = $this->request->data('keywords');
     $begin_time = $this->request->data('begin_time');
     $end_time = $this->request->data('end_time');
     $where = [];
     if (!empty($keywords)) {
         $where[' username like'] = "%{$keywords}%";
     }
     if (!empty($begin_time) && !empty($end_time)) {
         $begin_time = date('Y-m-d', strtotime($begin_time));
         $end_time = date('Y-m-d', strtotime($end_time));
         $where['and'] = [['date(`ctime`) >' => $begin_time], ['date(`ctime`) <' => $end_time]];
     }
     $Table = $this->Movie;
     $column = ['id', 'pic', 'movie', 'url', 'ctime', 'hits', 'utime'];
     $query = $Table->find();
     $query->hydrate(false);
     if (!empty($where)) {
         $query->where($where);
     }
     if (!empty($sort) && !empty($order)) {
         $query->order([$sort => $order]);
     }
     $res = $query->toArray();
     $this->autoRender = false;
     $filename = 'Movie_' . date('Y-m-d') . '.csv';
     \Admin\Utils\Export::exportCsv($column, $res, $filename);
 }