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 = '-选择分类-'; if (count($dataArr)) { for ($i = 0; $i < count($dataArr); $i++) { $data = $dataArr[$i]; if ($data['level'] == 1) { $result = $result . ''; continue; } $result = $result . '' . $data['name'] . ''; } } $result = $result . ''; 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; } }