2024年2月9日发(作者：)

// ->join('fa_app_store s', '_id = ') // ->with('group') ->where($w) // ->order($sort, $order) ->count(); $list = Db::name('app_goods') ->alias('aa') ->field('aa.*,_name') ->join('fa_app_goods_category c', '_id = ')// ->join('fa_app_store s', '_id = ') // ->with('group') ->where($w) ->order('', 'desc') ->limit($offset, $limit) ->select(); // foreach ($list as $k => $v) // { // $v->hidden(['password', 'salt']); // } $result = array("total" => $total, "rows" => $list); return json($result); } return $this->view->fetch(); }

public function add(){ if ($this->request->isPost()) { $params = $this->request->post("row/a"); if ($params) { $result = $this->model->save($params); if ($result === false) { $this->error($this->model->getError()); }

$this->success(); } $this->error(); } return $this->view->fetch(); } public function edit($ids = null) { $row = $this->model->get($ids); if (!$row) { $this->error(__('No Results were found')); } if ($this->request->isPost()) { $params = $this->request->post("row/a"); $result = $row->allowField(true)->save($params); if ($result !== false) { $this->success(); } else { $this->error($row->getError()); } } $this->view->assign("row", $row); return $this->view->fetch(); }

//获取商店名称 public function get_store(){ $param = input('param.'); @$param['pageNumber'] = $param['pageNumber'] ? $param['pageNumber'] : 1; if(@$param['searchValue'] > 0){ $total = Db::table('fa_app_store')->field('id,name')->where('id', $param['searchValue'])->count(); $list = Db::table('fa_app_store')->field('id,name')->where('id', $param['searchValue'])->select(); }elseif(@$param['name']){ $total = Db::table('fa_app_store')->field('id,name')->where('name', 'like', '%'.$param['name'].'%')->count(); $list = Db::table('fa_app_store')->field('id,name')->where('name', 'like', '%'.$param['name'].'%')->select(); }else{ $total = Db::table('fa_app_store')->field('id,name')->count(); $list = Db::table('fa_app_store')->field('id,name')->limit(($param['pageNumber'] - 1)*10, 10)->order('id','desc')->select(); }

$result = array("rows" => $list,"total" => $total); return json($result); } //获取商品分类 public function get_cat(){ $param = input('param.'); @$param['pageNumber'] = $param['pageNumber'] ? $param['pageNumber'] : 1; if(@$param['searchValue'] > 0){ $total = Db::table('fa_app_goods_category')->field('id,cat_name as name')->where('id', $param['searchValue'])->count(); $list = Db::table('fa_app_goods_category')->field('id,cat_name as name')->where('id', $param['searchValue'])->select(); }elseif(@$param['name']){ $total = Db::table('fa_app_goods_category')->field('id,cat_name as name')->where('cat_name', 'like', '%'.$param['name'].'%')->count(); $list = Db::table('fa_app_goods_category')->field('id,cat_name as name')->where('cat_name', 'like', '%'.$param['name'].'%')->select(); }else{ $total = Db::table('fa_app_goods_category')->field('id,cat_name as name')->count(); $list = Db::table('fa_app_goods_category')->field('id,cat_name as name')->limit(($param['pageNumber'] - 1)*10, 10)->order('id','desc')->select(); }

$result = array("rows" => $list,"total" => $total); return json($result); }

}

cmd