Mbfx_admin/application/admin/controller/MainProject.php

<?php

// +----------------------------------------------------------------------
// | ThinkAdmin
// +----------------------------------------------------------------------
// | 版权所有 2014~2019 广州楚才信息科技有限公司 [ http://www.cuci.cc ]
// +----------------------------------------------------------------------
// | 官方网站: http://demo.thinkadmin.top
// +----------------------------------------------------------------------
// | 开源协议 ( https://mit-license.org )
// +----------------------------------------------------------------------
// | gitee 代码仓库：https://gitee.com/zoujingli/ThinkAdmin
// | github 代码仓库：https://github.com/zoujingli/ThinkAdmin
// +----------------------------------------------------------------------

namespace app\admin\controller;

use library\Controller;
use library\tools\Data;
use think\Db;
use think\Url;
use think\facade\Filesystem;

/**
 * 主项目管理
 * Class User
 * @package app\admin\controller
 */
class MainProject extends Controller
{

    /**
     * 指定当前数据表
     * @var string
     */
    public $table = 'system_main_project';
    public $table2 = 'system_child_project';

    /**
     * 主项目管理
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->title = '主项目管理';
        $query = $this->_query($this->table)
            ->like('project_name,basis_for_listing,project_scope,grade,building_composition,case_description,function_parameters,defense,investment_subject,sources_funding,contract_mode,management_mode,owner,total_package,awards,other_instructions')
            ->equal('cost_categories,prepare_date,category_id,construction_site_province,construction_site_province,construction_site_city,construction_site_area')
            ->fieldBetween('total_land_area','total_land_area_start,total_land_area_end')
            ->fieldBetween('gross_floor_area','gross_floor_area_start,gross_floor_area_end')
            ->fieldBetween('floor_area','floor_area_start,floor_area_end')
            ->fieldBetween('underground_area','underground_area_start,underground_area_end')
            ->fieldBetween('building_density','building_density_start,building_density_end')
            ->fieldBetween('green_area','green_area_start,green_area_end')
            ->fieldBetween('road_area','road_area_start,road_area_end')
            ->fieldBetween('road_length','road_length_start,road_length_end')
            ->fieldBetween('project_time','project_time_start,project_time_end');
        $query->dateBetween('starting_time,ending_time')
            ->where(['is_deleted' => '0'])
            ->order('id desc')
            ->page();
    }

    /**
     * 列表数据处理
     * @param array $data
     */
    protected function _index_page_filter(&$data)
    {
        foreach ($data as &$vo) {
            $vo['category_name'] = Db::name('system_goods_cate')->where('id',$vo['category_id'])->value('title');
        }
        $menus = Db::name('system_goods_cate')->where(['status' => '1'])->where('is_deleted', 0)->order('id asc')->column('id,pid,title');
        $this->menus = Data::arr2table(array_merge([['id' => '', 'pid' => '-1', 'title' => '--全部--']],$menus ));

        //省
        $province = Db::name('system_area')->where('level',1)->select();
        $this->province = $province;

        if (isset($_GET['construction_site_province']) && $_GET['construction_site_province']!=''){
            //市
            $pid = Db::name('system_area')->where('name',$_GET['construction_site_province'])->value('id');
            $city = Db::name('system_area')->where('level',2)->where('pid',$pid)->select();
            $this->city = $city;
        }else{
            $this->city = [];
        }

        if (isset($_GET['construction_site_city']) && $_GET['construction_site_city']!=''){
            //区
            $pid2 = Db::name('system_area')->where('name',$_GET['construction_site_city'])->value('id');
            $area = Db::name('system_area')->where('level',3)->where('pid',$pid2)->select();
            $this->area = $area;
        }else{
            $this->area = [];
        }

    }

    /**
     * 子项目列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index2()
    {
        $id = $this->app->request->get('id');
        $this->assign('id',$id);

        $this->title = '子项目列表';
        $query = $this->_query($this->table2)->where('main_project_id',$id)
            ->like('project_name,design_life,decorate_standard,other_parameters')
            ->equal('category_id,structure_type,building_fortification_intensity,seismic_grade,base_type')
            ->fieldBetween('construction_layer','construction_layer_start,construction_layer_end')
            ->fieldBetween('upper_number','upper_number_start,upper_number_end')
            ->fieldBetween('underground','underground_start,underground_end')
            ->fieldBetween('underground_layer','underground_layer_start,underground_layer_end')
            ->fieldBetween('first_layer_high','first_layer_high_start,first_layer_high_end')
            ->fieldBetween('standard_height','standard_height_start,standard_height_end')
            ->fieldBetween('construction_area','construction_area_start,construction_area_end')
            ->fieldBetween('ground_floor_area','ground_floor_area_start,ground_floor_area_end')
            ->fieldBetween('underground_floor_area','underground_floor_area_start,underground_floor_area_end')
            ->fieldBetween('building_floor_area','building_floor_area_start,building_floor_area_end')
            ->fieldBetween('steel_benefit_area','steel_benefit_area_start,steel_benefit_area_end')
            ->fieldBetween('wood_area','wood_area_start,wood_area_end')
            ->fieldBetween('available_area','available_area_start,available_area_end')
            ->fieldBetween('number','number_start,number_end')
            ->fieldBetween('basement_floor_area','basement_floor_area_start,basement_floor_area_end')
            ->fieldBetween('building_height','building_height_start,building_height_end');
        $query->dateBetween('login_at,create_at')
            ->where(['is_deleted' => '0'])
            ->order('id desc')->page();
    }

    /**
     * 列表数据处理
     * @param array $data
     */
    protected function _index2_page_filter(&$data)
    {
        foreach ($data as &$vo) {
            $vo['main_project_name'] = Db::name('system_main_project')->where('id',$vo['main_project_id'])->value('project_name');
            $vo['category_name'] = Db::name('system_goods_cate')->where('id',$vo['category_id'])->value('title');
        }
        $menus = Db::name('system_goods_cate')->where(['status' => '1'])->where('is_deleted', 0)->order('id asc')->column('id,pid,title');
        $this->menus = Data::arr2table(array_merge([['id' => '', 'pid' => '-1', 'title' => '--全部--']],$menus ));

    }


    /**
     * 项目详情
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function projectinfo()
    {
        $this->_form($this->table, 'info');
    }


    /**
     * 创建主项目
     * @auth true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function add()
    {
        $this->title = '创建主项目';
        $this->_form($this->table, 'form');
    }

    /**
     * 编辑主项目
     * @auth true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function edit()
    {
        $this->title = '编辑主项目';
        $this->_form($this->table, 'form');
    }

    /**
     * 表单数据处理
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function _form_filter(&$data)
    {
        if ($this->request->isPost()) {

        } else {
            $data['category_name'] = Db::name('system_goods_cate')->where('id',$data['category_id'])->value('title');
            if (!empty($data)){
                //省
                $province = Db::name('system_area')->where('level',1)->select();
                $this->province = $province;
                //市
                $pid = Db::name('system_area')->where('name',$data['construction_site_province'])->value('id');
                $city = Db::name('system_area')->where('level',2)->where('pid',$pid)->select();
                $this->city = $city;
                //区
                $pid2 = Db::name('system_area')->where('name',$data['construction_site_city'])->value('id');
                $area = Db::name('system_area')->where('level',3)->where('pid',$pid2)->select();
                $this->area = $area;
            }else{
                //省
                $province = Db::name('system_area')->where('level',1)->select();
                $this->province = $province;
            }

            $menus = Db::name('system_goods_cate')->where(['status' => '1'])->where('is_deleted', 0)->order('id asc')->column('id,pid,title');
            $this->menus = Data::arr2table($menus);
        }
    }

    /**
     * 处理成功回调
     */
//    public function _form_result($result,$data){
//        if ($result) {
//            $this->success('成功',url('@main_project/index'));
//        }
//    }

    /**
     * 删除主项目
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function remove()
    {
        $this->_save($this->table, ['is_deleted' => '1']);
        //$this->_delete($this->table);
    }


    /**
     * 获取市
     */
    public function get_city(){
        $name = $this->app->request->get('id');
        $id = Db::name('system_area')->where('name',$name)->where('level',1)->value('id');
        $city_list = Db::name('system_area')->where('pid',$id)->where('level',2)->select();
        $this->success('成功',$city_list);
    }

    /**
     * 获取区
     */
    public function get_area(){
        $name = $this->app->request->get('id');
        $id = Db::name('system_area')->where('name',$name)->where('level',2)->value('id');
        $area_list = Db::name('system_area')->where('pid',$id)->where('level',3)->select();
        $this->success('成功',$area_list);
    }


    /**
     * 导入主项目
     * @auth true
     * @throws \think\Exception
     * @throws \think\exception\PDOException
     */
    public function import()
    {
        $file = request()->file('file');
        try {
            $savename = \think\facade\Filesystem::disk('public')->putFile( 'excel', $file);
            $import_path = root_path() . 'public/storage/' . $savename;
            $objReader =\PHPExcel_IOFactory::createReader('Excel2007');
            $objExcel = $objReader->load($import_path);
            $list = $objExcel->getActiveSheet()->toArray();

        } catch (\think\exception\ValidateException $e) {


            $this->error($e->getMessage());

        }
    }

}