+----------------------------------------------------------------------------------------------- */ namespace app\home\model; use think\model; use think\facade\Db; class Outs extends Model { /** * 获取分页列表 * @param $where * @param $param */ public function datalist($where, $param) { $rows = empty($param['limit']) ? get_config('app.page_size') : $param['limit']; $order = empty($param['order']) ? 'id desc' : $param['order']; try { $list = self::where($where) ->order($order) ->paginate(['list_rows'=> $rows]) ->each(function ($item, $key){ //$item->admin_name = Db::name('Admin')->where('id',$item->admin_id)->value('name'); }); return $list; } catch(\Exception $e) { return ['code' => 1, 'data' => [], 'msg' => $e->getMessage()]; } } /** * 添加数据 * @param $param */ public function add($param) { $insertId = 0; try { $param['create_time'] = time(); $insertId = self::strict(false)->field(true)->insertGetId($param); add_log('add', $insertId, $param,'外出申请'); } catch(\Exception $e) { return to_assign(1, '操作失败,原因:'.$e->getMessage()); } return to_assign(0,'操作成功',['return_id'=>$insertId]); } /** * 编辑信息 * @param $param */ public function edit($param) { try { $param['update_time'] = time(); self::where('id', $param['id'])->strict(false)->field(true)->update($param); add_log('edit', $param['id'], $param,'外出申请'); } catch(\Exception $e) { return to_assign(1, '操作失败,原因:'.$e->getMessage()); } return to_assign(0,'操作成功',['return_id'=>$param['id']]); } /** * 根据id获取信息 * @param $id */ public function getById($id) { $info = self::find($id); $info['start_date'] = date('Y-m-d H:i',$info['start_date']); $info['end_date'] = date('Y-m-d H:i',$info['end_date']); if(!empty($info['file_ids'])){ $file_array = Db::name('File')->where('id','in',$info['file_ids'])->select(); $info['file_array'] = $file_array; } return $info; } /** * 删除信息 * @param $id * @param $type * @return array */ public function delById($id,$type=0) { if($type==0){ //逻辑删除 try { $param['delete_time'] = time(); self::where('id', $id)->update(['delete_time'=>time()]); add_log('delete', $id); } catch(\Exception $e) { return to_assign(1, '操作失败,原因:'.$e->getMessage()); } } else{ //物理删除 try { self::destroy($id); add_log('delete', $id); } catch(\Exception $e) { return to_assign(1, '操作失败,原因:'.$e->getMessage()); } } return to_assign(); } }