You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
97 lines
2.9 KiB
PHP
97 lines
2.9 KiB
PHP
<?php
|
|
namespace app\admin\controller;
|
|
use think\Controller;
|
|
use think\Db;
|
|
use think\Exception;
|
|
use think\MhtFileMaker;
|
|
use think\Request;
|
|
|
|
class Devsncfg extends Common
|
|
{
|
|
public function index()
|
|
{
|
|
return $this->fetch();
|
|
}
|
|
|
|
|
|
public function get_ajax(){
|
|
$data = Db::query("SELECT DISTINCT concat('b',bdzid) id,bmc name,0 as pId from vw_sb
|
|
UNION DISTINCT SELECT concat('j',jgid) id,jmc name,concat('b',bdzid) pId from vw_sb
|
|
UNION DISTINCT SELECT concat('z',zid) id,zmc name,concat('j',jgid) pId from vw_sb
|
|
UNION DISTINCT SELECT concat('m',id) id,name,concat('z',zid) pId from vw_sb");
|
|
echo json_encode($data);
|
|
}
|
|
|
|
public function ajax(){
|
|
$id=input('id');
|
|
$data1 = Db::table('vw_sb')->where('id',$id)->find();
|
|
echo $data1['mtid'];
|
|
}
|
|
|
|
public function lst()
|
|
{
|
|
$sid=input('sid');
|
|
//$list=db('i2relation')->where('eqmid',$sid)->select();
|
|
$list=Db::table('i2relation')->where('eqmid', $sid)->paginate(5,false,['query' => request()->param()]);
|
|
$this->assign('list',$list);
|
|
return $this->fetch();
|
|
}
|
|
public function add()
|
|
{
|
|
$sid=input('sid');
|
|
if (request()->isPost()){
|
|
$data = input('post.');
|
|
$data['eqmid']=$sid;
|
|
try {
|
|
if (db('i2relation')->insert($data)) {
|
|
return $this->success('添加设备编码成功', 'lst?sid=' . $sid);
|
|
} else {
|
|
return $this->error('添加设备编码失败');
|
|
}
|
|
}
|
|
catch (Exception $e)
|
|
{
|
|
return $this->error($e->getMessage());
|
|
}
|
|
}
|
|
return $this->fetch();
|
|
|
|
}
|
|
public function edit(){
|
|
$sid=input('sid');
|
|
$sensorid=input('sensorid');
|
|
$list=db('i2relation')->find($sensorid);
|
|
if(request()->ispost()){
|
|
$data=[
|
|
'eqmid'=>input('eqmid'),
|
|
'cacid'=>input('cacid'),
|
|
'sensorid'=>input('sensorid1'),
|
|
'equipmentid'=>input('equipmentid'),
|
|
'monitortype'=>input('monitortype'),
|
|
'phase'=>input('phase'),
|
|
'sensorindex'=>input('sensorindex'),
|
|
];
|
|
|
|
$save=db('i2relation')->where("sensorid",$data["sensorid"])->update($data);
|
|
if($save !== false){
|
|
$this->success('修改设备编码成功！','lst?sid='.$sid);
|
|
}else{
|
|
$this->error('修改设备编码失败！');
|
|
}
|
|
}
|
|
$this->assign('list',$list);
|
|
return $this->fetch();
|
|
}
|
|
|
|
public function del(){
|
|
$sid=input('sid');
|
|
$sensorid=input('sensorid');
|
|
if(db('i2relation')->delete(input('sensorid'))){
|
|
$this->success('删除设备编码成功！','lst?sid='.$sid);
|
|
}else{
|
|
$this->error('删除设备编码失败！');
|
|
}
|
|
|
|
}
|
|
}
|