<?php

namespace app\run\controller;

use app\common\controller\Frontend;
use think\Db;
use think\exception\ValidateException;
use think\Request;
use addons\alisms\controller\Index;

class Displa extends Frontend
{

    protected $noNeedLogin = [''];
    protected $noNeedRight = '*';

    //坝体位移预警
    public function index()
    {

        $paging = count(Db::name('reservoir_warning_displacement')->where('deal', 1)->select());
        $page = input('get.page');
        $res = Db::name('reservoir_warning_displacement')
            ->alias('a')
            ->join('reservoir_list r', 'r.id = a.reservoir_id')
            ->join('reservoir_equipment eq', 'eq.deviceId = a.equipment_id')
            ->where('a.deal', 1)
            ->field('r.name, a.id,a.shaft,a.value,a.warning,a.createtime,eq.name as eqname,a.reservoir_id')
            ->page($page, '50')
            ->select();
        $this->assign([
            'res' => $res,
            'paging' => ceil($paging / 50)
        ]);
        return $this->view->fetch();
    }

    // 搜索
    public function search()
    {
        // 位移id
        $paging = count(Db::name('reservoir_warning_displacement')->where('deal', 1)->select());
        $id = input('get.id');
        $res = Db::name('reservoir_warning_displacement')
            ->alias('a')
            ->join('reservoir_list r', 'r.id = a.reservoir_id')
            ->where('a.id', $id)
            ->field('r.name, a.id,a.shaft,a.value,a.warning,a.createtime,a.equipment_id')
            ->select();
        $this->assign([
            'res' => $res,
            'paging' => 0
        ]);

        return $this->view->fetch('displa/index');

    }


    // 删除
    public function del()
    {
        $id = input('get.id');
        // var_dump($id);exit();
        $res = Db::name('reservoir_warning_displacement')
            ->where('id', $id)
            ->delete();

        if ($res) {
            return '删除成功';
        } else {
            return '删除失败';
        }
    }

    /**
     * 数据列表
     */
    public function indexlist()
    {
        $paging = count(Db::name('reservoir_dam_displacement')->where('status', 0)->select());
        $page = input('get.page');
        $res = Db::name('reservoir_dam_displacement')
            ->alias('a')
            ->join('reservoir_list r', 'r.id = a.reservoir_id')
            ->where('a.status', 0)
            ->field('r.name, a.id,a.number,a.status,a.warning,a.createtime,a.reservoir_id,a.vertical,a.horizontal,a.horizontalY')
            ->page($page, '50')
            ->select();
        $this->assign([
            'res' => $res,
            'paging' => ceil($paging / 50)
        ]);
        return $this->view->fetch('index_list');
    }


}