123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199 |
- <?php
- namespace app\admin\controller\qingdongams\customer;
- use app\admin\controller\qingdongams\Base;
- use addons\qingdongams\model\CustomerProduct;
- use fast\Random;
- use think\Db;
- use think\Exception;
- /**
- * 设备
- * @icon fa fa-user
- */
- class Equipment extends Base {
- protected $relationSearch = true;
- // protected $searchFields = 'id,username,nickname';
- /**
- * @var \addons\qingdongams\model\Equipment
- */
- protected $model = null;
- protected $proModel = null;
- protected $productList = null;
- protected $customerProductModel = null;
- protected $customerProductList = null;
- public function _initialize() {
- parent::_initialize();
- $this->model = new \addons\qingdongams\model\Equipment;
- $this->proModel = new \addons\qingdongams\model\Product();
- $this->customerProductModel = new CustomerProduct();
- $this->productList = collection($this->proModel->select())->toArray();
- $productList = [0 => __('None')];
- foreach ($this->productList as $k => &$v) {
- $productList[$v['id']] = $v['name'];
- }
- $this->customerProductList = collection($this->customerProductModel->select())->toArray();
- $customerProductList = [0 => __('None')];
- foreach ($this->customerProductList as $k => &$v) {
- $customerProductList[$v['id']] = $v['number'];
- }
- $this->view->assign('productList', $productList);
- $this->view->assign('customerProductList', $customerProductList);
- }
- /**
- * 列表
- */
- public function lists($ids = null) {
- list($where, $sort, $order, $offset, $limit) = $this->buildparams();
- $list = $this->model->where([
- 'pro_id' => $ids,
- ])->paginate($limit);
- $result = array("total" => $list->total(), "rows" => $list->items());
- return json($result);
- }
- /**
- * 查看
- */
- public function index() {
- //设置过滤方法
- $this->request->filter(['strip_tags', 'trim']);
- if ($this->request->isAjax()) {
- list($where, $sort, $order, $offset, $limit) = $this->buildparams();
- //
- //负责人为空
- $list = $this->model->where([])->where($where)->with('product')->order('id', 'desc')->paginate($limit);
- $result = array("total" => $list->total(), "rows" => $list->items());
- return json($result);
- }
- return $this->view->fetch();
- }
- /**
- * 添加
- */
- public function add() {
- if ($this->request->isPost()) {
- $params = $this->request->post("row/a");
- if ($params) {
- $params = $this->preExcludeFields($params);
- $result = false;
- Db::startTrans();
- try {
- $productModel = new \addons\qingdongams\model\Product();
- $proName = $productModel->where(['id'=>$params['pro_id']])->value('name');
- $params['number'] = date("md").rand(100000,999999);
- $img = $proName.'_'.$params['number'];
- if(create_logo_qrcode($img) == 'ok'){
- $params['logo'] = "/qrcode/".$img.'.jpg';
- }else{
- throw new \Exception('二维码生成有误');
- }
- $params['binding_status'] = 1;
- $result = $this->model->allowField(true)->save($params);
- Db::commit();
- } catch (Exception $e) {
- Db::rollback();
- $this->error($e->getMessage());
- }
- if ($result !== false) {
- $this->success();
- } else {
- $this->error(__('No rows were inserted'));
- }
- }
- $this->error(__('Parameter %s can not be empty', ''));
- }
- return $this->view->fetch();
- }
- /**修改
- */
- public function edit($ids = null) {
- $map['id'] = $ids;
- if ($this->request->isAjax()) {
- $params = $this->request->post('row/a');
- $params = $this->preExcludeFields($params);
- $result = false;
- Db::startTrans();
- try {
- unset($params['logo']);
- unset($params['number']);
- $result = $this->model->allowField(true)->update($params, $map);
- Db::commit();
- } catch (Exception $e) {
- Db::rollback();
- $this->error($e->getMessage());
- }
- if ($result !== false) {
- $this->success('修改成功');
- } else {
- $this->error('修改失败');
- }
- }
- $data = $this->model->where($map)->find();
- $this->view->assign("row", $data);
- return $this->view->fetch();
- }
- /**详情
- */
- public function detail($ids=null){
- $row=$this->model->get($ids);
- $this->assign('row',$row);
- $this->assign('ids',$ids);
- return $this->view->fetch();
- }
- /**
- * 删除
- */
- public function del($ids = "") {
- if (!$this->request->isPost()) {
- $this->error(__("Invalid parameters"));
- }
- $ids = $ids ? $ids : $this->request->post("ids");
- $ids = explode(',',$ids);
- $this->model->destroy(function ($query) use($ids){
- $query->where('id','in',$ids);
- });
- $this->success();
- }
- /**
- * 导出二维码 -- 格式为所有二维码图片
- * @param $ercode_list 二维码链接数组,我的数组包含两个参数,url 和 unique_id
- * url 二维码链接
- * unique_id 主要为生成独一无二的二维码文件名称
- * @return string
- */
- public function export_ercode()
- {
- $ids = $this->request->get('ids');
- $ercode_list = collection($this->model->where('id','in',explode(',',$ids))->select())->toArray();
- $img_arr = array();
- foreach ($ercode_list as $ercode) {
- $img_name = ROOT_PATH."public".$ercode['logo'];
- $img_arr[] = $img_name;
- }
- $zip_name = ROOT_PATH.'public/uploads/ercode/ercode_' . date('YmdHis') . '.zip';
- makeZip($zip_name, $img_arr);
- download($zip_name);
- $this->redirect('index');
- }
- }
|