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
73
74
75
76
77
78
79
80
81
82
83
84
<?php
namespace app\station\model;
use think\Model;
use think\model\concern\SoftDelete;
class BaseStationStatusModel extends Model
{
use SoftDelete;
protected static $deleteTime = 'delete_time';
// 开启自动写入时间戳字段
protected $autoWriteTimestamp = true;
//主键id
protected $pk = 'cate_id';
//数据表
protected $table = 'station_statuscate';
public function selectBaseStationStatus_List(){
$data = $this->field("cate_id,cate_name,state,pid")->order('cate_id asc')->select()->toarray();
if($data){
return ['code' =>200,'message' => '查询成功' ,'data' => $data];
}else{
return ['code' => -1, 'message' => $this->getError()];
}
}
public function insertBaseStationStatus($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 updBaseStationStatus($parem){
try {
$data=$this->allowField(true)->where(['cate_id' => $parem['cate_id']])->find();
if($data){
$result=$this->allowField(true)->save($parem,['cate_id' => $parem['cate_id']]);
if($result){
return ['code' => 200, 'data' => '', 'message' => '修改成功'];
}else{
return ['code' => -1, 'data' => '', 'message' => $this->getError()];
}
}else{
return ['code' => 10001, 'data' => '', 'message' => '没有cate_id'];
}
} catch (Exception $e) {
return ['code' => 0, 'data' => '', 'message' => $e->getMessage()];
}
}
public function updselectBaseStationStatus($parem){
$data = $this->field("cate_id,cate_name,state")->where($parem)->find();
if($data){
return ['code' => 200, 'data' => $data, 'message' => '查询成功'];
}else{
return ['code' => 10001, 'data' => '', 'message' => '暂未找到id相关信息'];
}
}
public function delBaseStationStatus($parem){
try {
$data=$this->allowField(true)->where($parem)->find();
if($data){
$result=$this->destroy($parem);
if($result){
return ['code' => 200, 'data' => '', 'message' => '删除成功'];
}else{
return ['code' => -1, 'data' => '', 'message' => $this->getError()];
}
}else{
return ['code' => 10001, 'data' => '', 'message' => $this->getError()];
}
} catch (Exception $e) {
return ['code' => 0, 'data' => '', 'message' => $e->getMessage()];
}
}
}