/**ajax 获取企业名称
     *
     * @param Request $request
     *
     * @return \Illuminate\Http\JsonResponse
     * @author lxw
     */
    public function getCompanyName( Request $request )
    {
        $keyword = $request->query->get('q', '');

        $allCompany = Company::query();
        $allCompany = $allCompany->select('id', 'username');
        if ( $keyword ) {
            $allCompany = $allCompany->where('username', 'like', '%' . $keyword . '%');
        }
        $allCompany = $allCompany->orderBy('created_at', 'desc');
        $allCompany = $allCompany->limit(5);
        $allCompany = $allCompany->get();
        if ( empty($allCompany) ) {
            return response()->json(['status' => 500, 'data' => new \ArrayObject(), 'msg' => '搜索关键字不存在']);
        }
        $data = [];
        foreach ( $allCompany->toArray() as $item ) {
            $data[] = [
                'id' => $item['id'],
                'text' => $item['username'],
            ];
        }
        return response()->json(['status' => 200, 'data' => $data, 'msg' => '搜索成功']);
    }

    /**ajax请求该企业下的所有楼宇
     * 执行中的显示其他订单已开通
     *
     * @param $companyId
     *
     * @return \Illuminate\Http\JsonResponse
     * @author lxw
     */
    public function getCompanyBuildings( $companyId )
    {
        //该企业下已经被创建过订单且处于执行中的的楼宇id
        $doingBuilds = BuildingPayment::query()
            ->where('company_id', $companyId)
            ->whereDate('duetime', '>', date('Y-m-d', time()))
            ->groupBy('building_id')
            ->get(['building_id']);

        $doingBuildArr = $doingBuilds ? $doingBuilds->toArray() : [];
        $doingBuildIds = array_column($doingBuildArr, 'building_id');

        //该企业下所有的楼宇
        $allBuildings = Building::query()
            ->where('company_id', $companyId)
            ->orderBy('sort', 'asc')
            ->get(['id', 'name']);
        $allBuildings = $allBuildings ? $allBuildings->toArray() : [];
        foreach ( $allBuildings as &$building ) {
            if( in_array($building['id'], $doingBuildIds)){
                $building['isPayment'] = true;
            }else{
                $building['isPayment'] = false;
            }
        }

        return response()->json(['status' => 200, 'data' => $allBuildings, 'msg' => '搜索成功']);
    }

　　

优质内容筛选与推荐>>
1、C语言I博客作业05
2、OpenLayers项目分析（一）项目介绍
3、最近工作比较忙
4、js 添加事件 attachEvent 和 addEventListener 的用法
5、马士兵hadoop2.7.3_hive入门