public static function getmenu() { $organid = Yii::app()->user->getOrganID(); if ($organid) { $menus = Yii::app()->jpdb->createCommand()->select('ID,DepartmentName,ParentID,Describe')->from('jpd_organ_department')->where('OrganID=:OrganID and Status=:sta', array(':OrganID' => $organid, ':sta' => '0'))->queryAll(); $departcount = count($menus); if (!empty($menus)) { foreach ($menus as $key => $val) { if (empty($val['ParentID'])) { $val['ParentID'] = 0; } $menu[$key]['id'] = 'dep_' . $val['ID']; $menu[$key]['text'] = '<a key="0" class="bumen">' . $val['DepartmentName'] . '</a>'; $menu[$key]['describe'] = $val['Describe']; $menu[$key]['parentID'] = 'dep_' . $val['ParentID']; $menu[$key]['type'] = 0; $employee = JpdOrganEmployees::model()->findAll('DepartmentID=:dep and OrganID=:org and Status=:stau', array(':dep' => $val['ID'], ':org' => $organid, ':stau' => '0')); if (!empty($employee)) { foreach ($employee as $empkey => $empval) { $menu[$departcount]['id'] = 'emp_' . $empval['ID']; $menu[$departcount]['text'] = '<a class="part_current ren" od="' . $empval['ID'] . '" key="1">' . $empval['Name'] . '</a>'; $menu[$departcount]['parentID'] = 'dep_' . $val['ID']; $menu[$departcount]['type'] = 1; $departcount++; } } } $menus = self::Treearray($menu); } else { $menus[0]["id"] = 0; $menus[0]["text"] = "暂无部门"; } } else { $menus[0]["id"] = 0; $menus[0]["text"] = "暂无部门"; } return $menus; }
public function actionUserinfo() { $data = array(); $empid = Yii::app()->request->getParam('empid'); $emp = JpdOrganEmployees::model()->findByPk($empid)->attributes; if ($emp) { $per = JpdOrganRoleEmployees::model()->findAll('EmployeeID=:emp and Status=:sta ', array(':emp' => $emp['ID'], ':sta' => '0')); if ($per) { foreach ($per as $k => $v) { $data[$k] = $v->attributes; $data[$k]['empname'] = $emp['Name']; $data[$k]['empID'] = $emp['ID']; $data[$k]['role'] = JpdOrganRoles::model()->findByPk($v['RoleID'])->attributes; $ress = JpdOrganRoles::model()->findByPk($v['RoleID']); $rootID = F::getroot(); $per = $ress->attributes; if ($per['Jurisdiction']) { $params['role'] = $per['Jurisdiction']; $params["scope"] = "stage"; //制定查询范围 $params["scope"] = "sliderbar"; $params['rootID'] = $rootID; if ($params["rootID"]) { //获取菜单模型 $criteria = new CDbCriteria(); $criteria->addCondition('ID=' . $params["rootID"]); // $criteria->addCondition('IsRoot=1'); $criteria->addCondition('IsShow=1'); $firstmenu = FrontMenu::model()->find($criteria); } $data[$k]['root'] = $firstmenu['Name']; $res = FrontMenu::getChildMenu($params); $rs = array(); $data[$k]['per'] = $res; } } } else { $data['empname'] = $emp['Name']; $data['empID'] = $emp['ID']; } } echo json_encode($data); }