118 lines
4.0 KiB
PHP
118 lines
4.0 KiB
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."'";
|
|
}
|
|
} |