1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php
namespace app\station\model;
use think\Model;
use think\model\concern\SoftDelete;
class StaffModel extends Model
{
use SoftDelete;
protected static $deleteTime = 'delete_time';
// 开启自动写入时间戳字段
protected $autoWriteTimestamp = true;
//主键id
protected $pk = 'id';
//数据表
protected $table = 'staff';
public function selectStaffList(){
$data = $this->field("id,name,d_id,tel,email,status")->select()->toarray();
if($data){
return ['code' =>200,'message' => '查询成功' ,'data' => $data];
}else{
return ['code' => -1, 'message' => $this->getError()];
}
}
public function insertStaff($parem){
try {
$result=$this->allowField(true)->save($parem);
if($result){
return ['code' =>200,'message' => '添加成功'];
}else{
return ['code' => -1, 'message' => $this->getError()];
}
} catch (Exception $e) {
return ['code' => 0, 'message' => $e->getMessage()];
}
}
public function updStaff($parem){
try {
$result=$this->allowField(true)->save($parem,['id' => $parem['id']]);
if($result){
return ['code' => 200, 'data' => '', 'message' => '修改成功'];
}else{
return ['code' => -1, 'data' => '', 'message' => $this->getError()];
}
} catch (Exception $e) {
return ['code' => 0, 'data' => '', 'message' => $e->getMessage()];
}
}
public function getOneStaff($parem){
$data = $this->field("id,name,d_id,tel,email,status")->where($parem)->find();
if($data){
return ['code' => 200, 'data' => $data, 'message' => '查询成功'];
}else{
return ['code' => 10001, 'data' => '', 'message' => '暂未找到 id 相关信息'];
}
}
public function delStaff($parem){
try {
$result=$this->destroy($parem);
if($result){
return ['code' => 200, 'data' => '', 'message' => '删除成功'];
}else{
return ['code' => -1, 'data' => '', 'message' => $this->getError()];
}
} catch (Exception $e) {
return ['code' => 0, 'data' => '', 'message' => $e->getMessage()];
}
}
}