office_automation/webmain/model/dcsModel.php

<?php

class dcsClassModel extends Model
{
    private  $kv;
    public function initModel()
    {
        parent::initModel(); // TODO: Change the autogenerated stub
//        $dcsArr = m('dcs_class')->getall("1=1");
//        for ($i = 0; $i < count($dcsArr); $i++) {
//            $dcs = $dcsArr[$i];
//            $id = $dcs['id'];
//            $this->kv[$id] = [
//                "name" => $dcs['name'],
//                "value" => $dcs['id'],
//            ];
//        }

    }

    public function getGroupName($id) {
        $sql = "select * from [Q]dcs_group t where id = {$id}";
        $data = $this->db->getall($sql);
        if (count($data) > 0) {
            return $data[0]['name'];
        } else {
            return '';
        }
    }


    public function getCategoryTree($parentId = null)
    {
        $dataArr = m("dcs_group")->getall("1=1");

        $result = '<select style="width: 97%; padding: 7px 0px; 1px solid #bbb" class="form-control" name="group"><option value="0">-选择分类-</option>';

        if (count($dataArr)) {
            for ($i = 0; $i < count($dataArr); $i++) {
                $data = $dataArr[$i];
                if ($data['level'] == 1) {
                    $result = $result . '<optgroup label="' . $data['name'] . '">';
                    continue;
                }
                $result = $result . '<option value="' . $data['id'] . '">' . $data['name'] . '</option>';
            }
        }

        $result = $result . '</select>';

        return $result;
    }

    public function groupstore() {
        $data = $this->db->query("select * from [Q]dcs_group where 1=1");
        foreach ($data as $k => $v) {
            $arr[] = array("name"=>$v['name'],"value"=>$v['id']);
        }
        return $arr;
    }

    public function abc()

    {

        $dcsArr = m('dcs_class')->getall("1=1", '*', 'par_class_id, sort');

//        $arr[] = [
//            "name" => '自动化系统',
//            "value" => 0,
//            "pid" => -1,
//            "pname" => ''
//        ];

        for ($i = 0; $i < count($dcsArr); $i++) {
            $dcs = $dcsArr[$i];
            $arr[] = [
                "name" => ($dcs['par_class_id'] == 0 ? '' : '|'.str_repeat('-', $dcs['level'] - 1)) .$dcs['name'],
                "name_val" => $dcs['name'],
                "value" => $dcs['id'],
                "pid" => $dcs['par_class_id'],
                "plevel" => $dcs['level'],
                "pname" => $dcs['par_class_id'] == 0 ? $dcs['sys_name'] : $dcs['par_class']
            ];
        }

        return $arr;

    }

    public function getPointList() {
        $parr = m('dcs_point')->getall("1=1");

        for ($i = 0; $i < count($parr); $i++) {
            $p = $parr[$i];
            $arr[] = [
                "name"=>empty($p['list_name']) ? $p['name'] : $p['list_name'],
                "subname"=>$p['sub_class'],
                "value"=>$p['id'],
                "pid"=>$p['class_id'],
                "pname"=>$p['class']
            ];
        }
        return $arr;
    }


    public function getGroup()
    {
        $groupArr = m('dcs_group')->getall('1=1 and pid != 0');
        $arr = [];
        for ($i = 0; $i < count($groupArr); $i++) {
            $group = $groupArr[$i];
            $arr[] = array("name"=>$group['name'],"value"=>$group['id']);
        }

        return $arr;

    }

    function buildTree(array $elements, $parentId = 0) {
        $branch = array();

        for ($i = 0; $i < count($elements); $i++) {
            $element = $elements[$i];
            if ($element['pid'] == $parentId) {
                $branch[] = $element;
                $children = $this->buildTree($elements, $element['id']);
                if ($children) {
//                    $branch[] = $children;
                    for ($j = 0; $j < count($children); $j++) {
                        $branch[] = $children[$j];
                    }
//                    array_push($branch, $children);
                }
            }
        }

//        foreach ($elements as $element) {
//            if ($element['pid'] == $parentId) {
//                $children = $this->buildTree($elements, $element['id']);
////                if ($children) {
////                    $element[] = $children;
////                }
//                $branch[] = $children;
//            }
//        }
        return $branch;
    }

}