xinhu_gitee/webmain/system/menu/menuAction.php

<?php
class menuClassAction extends Action
{
	public $rows,$alldata;
	public function dataAjax()
	{
		$this->db->update('[Q]menu', '`status`=1' , '`id` in(1,2) and `status`=0');
		$this->rows		= array();
		$type 			= $this->get('type');
		$loadci 		= (int)$this->get('loadci');
		$pid 			= (int)$this->get('pid','0');
		$where 			= '';
		//权限那来的
		if($type != ''){
			$where		= 'and `status`=1 and `ispir`=1 and `type`=0';
			if($type=='view')$where = 'and `status`=1 and `type`=0';
		}else{
			$this->updatepirss();
		}
		if($pid>0){
			$where.=' and (`id`='.$pid.' or `pid`='.$pid.' or `pid` in(select `id` from `[Q]menu` where `pid`='.$pid.'))';
		}
		$this->alldata 	= $this->db->getall('select *,(select count(1)from `[Q]menu` where `pid`=a.id '.$where.')stotal from `[Q]menu` a where 1=1 '.$where.' order by `sort`');
		
		$this->getmenu(0, 1, 1);
		
		$pdata = array();
		if($loadci==1){
			foreach($this->alldata as $k=>$rs){
				if($rs['pid']=='0')$pdata[] = array('name'=>$rs['name'],'id'=>$rs['id']);
			}
		}
		
		echo json_encode(array(
			'totalCount'=> 0,
			'pdata'		=> $pdata,
			'rows'		=> $this->rows
		));
	}
	
	private function getmenu($pid, $oi, $zt)
	{
		$downid = '';
		foreach($this->alldata as $k=>$rs){
			if($pid==$rs['pid']){
				$downid.=','.$rs['id'].'';
				$rs['level']	= $oi;
				$zthui			= $rs['status'];
				if($zt==0){
					$rs['ishui']=1;
					$zthui = 0;
				}
				//if($oi>1)$rs['trstyle']='display:none;';
				$this->rows[] 	= $rs;
				$len = count($this->rows)-1;
				$sidss = $this->getmenu($rs['id'], $oi+1, $zthui);
				//if($sidss)$this->rows[$len]['downallid'] = substr($sidss,1);
			}
		}
		return $downid;
	}
	
	//下级需要验证，那上级也必须验证的
	private function updatepirss()
	{
		$rows 	= $this->db->getall('select `pid` from `[Q]menu` where `pid`>0 and `ispir`=1 group by `pid`');
		$sid 	= '0';
		foreach($rows as $k=>$rs)$sid.=','.$rs['pid'].'';
		if($sid!='')m('menu')->update('`ispir`=1', "`id` in($sid)");
	}
	
	/**
	* 菜单管理获取菜单
	*/
	public function getdataAjax()
	{
		$pvalue = (int)$this->get('pvalue','0');
		$level 	= (int)$this->get('level','1');
		$rows 	= $this->db->getall('select *,(select count(1)from `[Q]menu` where `pid`=a.id )stotal from `[Q]menu` a where `pid`='.$pvalue.' order by `sort`');
		foreach($rows as $k=>$rs)$rows[$k]['level'] = $level;
		echo json_encode(array(
			'totalCount'=> 0,
			'rows'		=> $rows
		));
	}
	
	public function delmenuAjax()
	{
		$id = (int)$this->post('id');
		if(m('menu')->rows('pid='.$id.'')>0)return returnerror('有下级菜单不能删除');
		m('menu')->delete($id);
		return returnsuccess();
	}
	
	public function createmenuAjax()
	{
		$pid = (int)$this->get('menuid','0');
		$where  =' and (`id`='.$pid.' or `pid`='.$pid.' or `pid` in(select `id` from `[Q]menu` where `pid`='.$pid.'))';
		$rows 	= $this->db->getall('select *,(select count(1)from `[Q]menu` where `pid`=a.id '.$where.')stotal from `[Q]menu` a where 1=1 '.$where.' order by pid,`sort`');
		$str = '';
		$ors = m('menu')->getone($pid);
		foreach($rows as $k=>$rs){
			if($k>0)$str.=''.chr(10).'ROCKSPLIT'.chr(10).'';
			$str.="INSERT INTO `[Q]menu` (`id`,`name`,`pid`,`sort`,`url`,`num`,`icons`,`type`,`ispir`) select '".$rs['id']."','".$rs['name']."','".$rs['pid']."','".$rs['sort']."',".$this->seveslst($rs['url']).",".$this->seveslst($rs['num']).",".$this->seveslst($rs['icons']).",'".$rs['type']."','".$rs['ispir']."' from `[Q]menu` WHERE `id`=1 and NOT EXISTS(SELECT 1 FROM `[Q]menu` where `id`='".$rs['id']."');";
			//$str.=''.chr(10).'ROCKSPLIT'.chr(10).'';
			//$str.="update `[Q]menu` set `name`='".$rs['name']."',`status`=1,`url`=".$this->seveslst($rs['url']).",`pid`='".$rs['pid']."',`sort`='".$rs['sort']."' where `id`='".$rs['id']."';";
		}
		$bh  = $ors['num'];
		if(isempt($bh))$bh=$ors['id'];
		$num = 'menu'.$bh.'';
		$this->rock->createtxt('upload/data/'.$num.'.txt', $str);
	}
	public function seveslst($v)
	{
		if($v===null)return 'null';
		return "'".$v."'";
	}
}