审查视图

app/portal/controller/AdminFaultController.php 1.8 KB
董瑞恩 authored
1 2 3 4 5 6 7 8 9 10 11 12 13
<?php
/**
 * Created by PhpStorm.
 * User: ruidiudiu
 * Date: 2018/11/23
 * Time: 11:57
 */

namespace app\portal\controller;


use app\portal\model\EquipmentModel;
use cmf\controller\AdminBaseController;
董瑞恩 authored
14 15
use think\Db;
董瑞恩 authored
16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
/**
 * Class AdminFaultController
 * @package app\portal\controller
 * @adminMenuRoot(
 *     'name'   =>'故障统计',
 *     'action' =>'index',
 *     'parent' =>'',
 *     'display'=> true,
 *     'order'  => 1,
 *     'icon'   =>'th',
 *     'remark' =>'故障统计'
 * )
 */
class AdminFaultController extends AdminBaseController{

    public function index(){
董瑞恩 authored
32 33 34
        $Order=new OrderModel();
        $data=$Order->alias('a')
            ->field('a.*,count(a.eq_name) as num,sum(a.time) as sumTime')
董瑞恩 authored
35
            ->join('equipment b','a.eq_name=b.name')
董瑞恩 authored
36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
            ->group('a.eq_name')
            ->order('start_time','desc')
            ->paginate(10)->each(function ($item){
                $item['average']=round($item['sumTime']/$item['num']);
                //计费故障次数
                $item['fault_time']=Db::name('fault')->where(['eq_name'=>$item['eq_name'],'fault_type'=>1])->count();
                //锁故障次数
                $item['fault_lock']=Db::name('fault')->where(['eq_name'=>$item['eq_name'],'fault_type'=>5])->count();
                //床故障次数
                $item['fault_bed']=Db::name('fault')->where(['eq_name'=>$item['eq_name'],'fault_type'=>['in',[2,3,4]]])->count();
                //其他故障次数
                $item['fault_other']=Db::name('fault')->where(['eq_name'=>$item['eq_name'],'fault_type'=>6])->count();
                //故障总数
                $item['fault']=Db::name('fault')->where(['eq_name'=>$item['eq_name']])->count();
                return $item;
            });
董瑞恩 authored
52 53 54
        $this->assign('data',$data);
        return $this->fetch();
    }
董瑞恩 authored
55 56 57 58 59




董瑞恩 authored
60
}