video_system/Modules/OpcData/Http/Controllers/Api/zaoquan/DcsFanEastController.php

<?php

namespace Modules\OpcData\Http\Controllers\Api\zaoquan;

use App\Http\Controllers\Api\BaseController;
use Illuminate\Contracts\Support\Renderable;
use Illuminate\Routing\Controller;
use Illuminate\Support\Facades\DB;
use Illuminate\Http\Request;

/**
 * 枣泉自动化——东井通风
 */
class DcsFanEastController  extends BaseController
{

    private $return_data= [
        'fan_parameter'=>[
            [
                "name"=>"1#风机",
                "data"=>[
                    [
                        "name"=>"负压",
                        "unit"=>"Pa",
                        "code"=>"",
                        "type"=>"val"
                    ],
                    [
                        "name"=>"风量",
                        "unit"=>"m³/min",
                        "code"=>"2008298772323329_1",
                        "type"=>"val"
                    ],
                    [
                        "name"=>"风门",
                        "unit"=>"m³/min",
                        "code"=>"2008319841133569_2",
                        "type"=>"state"
                    ],
                ]
            ],
            [
                "name"=>"2#风机",
                "data"=>[
                    [
                        "name"=>"负压",
                        "unit"=>"Pa",
                        "code"=>"",
                        "type"=>"val"
                    ],
                    [
                        "name"=>"风量",
                        "unit"=>"m³/min",
                        "code"=>"2008298772677633_1",
                        "type"=>"val"
                    ],
                    [
                        "name"=>"风门",
                        "unit"=>"m³/min",
                        "code"=>"2008319841389569_2",
                        "type"=>"state"
                    ],
                ]
            ]
        ],
        "motor_parameters_1"=>[
            [
                "name"=>"电机电流（A)",
                "data"=>[
                    [
                        "code"=>"2008298771987457_1",
                        "type"=>"val"
                    ],
                    [
                        "code"=>"2008298772354049_1",
                        "type"=>"val"
                    ],
                ]
            ],
            [
                "name"=>"变频频率（HZ)",
                "data"=>[
                    [
                        "code"=>"2008298772003841_1",
                        "type"=>"val"
                    ],
                    [
                        "code"=>"2008298772370433_1",
                        "type"=>"val"
                    ],
                ]
            ],
            [
                "name"=>"变频器状态",
                "data"=>[
                    [
                        "code"=>"2008298770955265_2",
                        "type"=>"bpqzt"
                    ],
                    [
                        "code"=>"2008298771299329_2",
                        "type"=>"bpqzt"
                    ],
                ]
            ],
            [
                "name"=>"变频器就绪",
                "data"=>[
                    [
                        "code"=>"2008298770912257_2",
                        "type"=>"bpqjx"
                    ],
                    [
                        "code"=>"2008298771235841_2",
                        "type"=>"bpqjx"
                    ],
                ]
            ],
            [
                "name"=>"变频器故障",
                "data"=>[
                    [
                        "code"=>"2008298770922497_2",
                        "type"=>"bpqgz"
                    ],
                    [
                        "code"=>"2008298771252225_2",
                        "type"=>"bpqgz"
                    ],
                ]
            ],
        ],
        "motor_parameters_2"=>[
            [
                "name"=>"电机电流（A)",
                "data"=>[
                    [
                        "code"=>"2008298772714497_1",
                        "type"=>"val"
                    ],
                    [
                        "code"=>"2008298772763649_1",
                        "type"=>"val"
                    ],
                ]
            ],
            [
                "name"=>"变频频率（HZ)",
                "data"=>[
                    [
                        "code"=>"2008298772730881_1",
                        "type"=>"val"
                    ],
                    [
                        "code"=>"2008298772780033_1",
                        "type"=>"val"
                    ],
                ]
            ],
            [
                "name"=>"变频器状态",
                "data"=>[
                    [
                        "code"=>"2008298771627009_2",
                        "type"=>"bpqzt"
                    ],
                    [
                        "code"=>"2008298771809281_2",
                        "type"=>"bpqzt"
                    ],
                ]
            ],
            [
                "name"=>"变频器就绪",
                "data"=>[
                    [
                        "code"=>"2008298771575809_2",
                        "type"=>"bpqjx"
                    ],
                    [
                        "code"=>"2008298771760129_2",
                        "type"=>"bpqjx"
                    ],
                ]
            ],
            [
                "name"=>"变频器故障",
                "data"=>[
                    [
                        "code"=>"2008298771590145_2",
                        "type"=>"bpqgz"
                    ],
                    [
                        "code"=>"2008298771774465_2",
                        "type"=>"bpqgz"
                    ],
                ]
            ],
        ],
    ];
    private $list_key=[
        '2008298770912257_2',
        '2008298771235841_2',
        '2008298771575809_2',
        '2008298771760129_2',
        '2008298770922497_2',
        '2008298771252225_2',
        '2008298771590145_2',
        '2008298771774465_2',
        '2008298771971073_1',
        '2008298772339713_1',
        '2008298772696065_1',
        '2008298772747265_1',
        '2008298770955265_2',
        '2008298771299329_2',
        '2008298771627009_2',
        '2008298771809281_2',
        '2008298771987457_1',
        '2008298772354049_1',
        '2008298772714497_1',
        '2008298772763649_1',
        '2008298772003841_1',
        '2008298772370433_1',
        '2008298772730881_1',
        '2008298772780033_1',
        '2008298772069377_1',
        '2008298772388865_1',
        '2008298772323329_1',
        '2008298772677633_1',
        '2008319841133569_2',
        '2008319841389569_2'
    ];

    public function getList(Request $request) {

        $sql_str = "select value from dcs_data_ventilation_east where `point_id` in ".$this->list_key;

        return $sql_str;
    }

}