예제 #1
0
 public function GetAllByTree()
 {
     $list = M($this->dbname)->select();
     $bta = new BuildTreeArray($list, 'id', 'pid', 0);
     $data = $bta->getTreeArray();
     echo json_encode($data);
 }
예제 #2
0
 public function GetAllOrg()
 {
     // import("Home.Library.TreeLib.BuildTreeArray");
     // import('Common/ORG/Util/BuildTreeArray');
     $list = M($this->dbname)->select();
     // $bta = new \Common\ORG\Util\BuildTreeArray($list,'orgid','orgpid',0);
     $bta = new BuildTreeArray($list, 'orgid', 'orgpid', 0);
     $data = $bta->getTreeArray();
     echo json_encode($data);
     // $this->ajaxReturn(json_encode($data),'JSON');
 }
예제 #3
0
 public function AjaxGetAllDevices()
 {
     $meetingid = $_REQUEST["id"];
     // 关键词首层
     $demo = M("Meetingdevice");
     $keyslist = $demo->table(C('DB_PREFIX') . "meetingdevice a")->join("left join " . C('DB_PREFIX') . "meetinganddevice b ON (a.id=b.meetingdeviceid and b.meetingid='" . $meetingid . "')")->field("a.id,0 pid,a.name, case when ifnull(b.meetingid,'') != '' then 'true' else 'false' end as checked")->where("a.status=1")->order("a.sort asc")->select();
     $bta = new BuildTreeArray($keyslist, 'id', 'pid', 0);
     $data = $bta->getTreeArray();
     //var_dump(json_encode($data));
     echo json_encode($data);
     // $this->ajaxReturn(json_encode($data),'JSON');
 }
예제 #4
0
 public function GetMenu()
 {
     //权限
     $menu = M($this->dbname);
     if (!in_array(session('uid'), C('ADMINISTRATOR'))) {
         //getChildLst(31) 系统应用的ID  不能修改
         if (session('uid') == '') {
             $list = M($this->dbname)->where("FIND_IN_SET(id,getChildLst(31)) and status=1")->order("sort asc")->select();
         } else {
             $list = M($this->dbname)->where(" status=1")->order("sort asc")->select();
         }
     } else {
         //如果管理员权限可以访问所有的
         $list = M($this->dbname)->where(" status=1")->order("sort asc")->select();
     }
     //echo $menu->getLastSql();
     //var_dump(M($this->dbname)->getLastSql());
     $bta = new BuildTreeArray($list, 'id', 'pid', 0);
     $data = $bta->getTreeArray();
     echo json_encode($data);
 }
 public function AjaxGetAllOrgs_index()
 {
     $orgsid = $_REQUEST["id"];
     // 关键词首层
     $demo = M("Org");
     $keyslist = $demo->table(C('DB_PREFIX') . "org a")->field("a.id,a.pid,a.name, case when FIND_IN_SET(ifnull(a.id,''),'" . $orgsid . "')>0   then  'true' else 'false' end as checked")->where("a.status=1")->order("a.sort asc")->select();
     //var_dump($demo->getLastSql());
     // $this->assign('keyslist',$keyslist);
     $bta = new BuildTreeArray($keyslist, 'id', 'pid', 0);
     $data = $bta->getTreeArray();
     //var_dump(json_encode($data));
     echo json_encode($data);
     // $this->ajaxReturn(json_encode($data),'JSON');
 }