点击向上的箭头时候,排序顺序会与上面的交换。点击向下的箭头时候会与下面的排序交换。当排在第一个时候点击向上箭头提示已经是第一个,当排在最后一个时候点击向下箭头,提示已经是最后一个,
<td>{$imginfo.wedd_order}
<if condition="$imginfo.wedd_order neq 0">
<a href="{:U('Img/weddorderdown',array('id'=>$imginfo['id'],'wedd_order'=>$imginfo['wedd_order']))}" style="padding: 4px;">↓ </a>
<a href="{:U('Img/weddorderup',array('id'=>$imginfo['id'],'wedd_order'=>$imginfo['wedd_order']))}" style="padding: 4px;">↑</a>
</if>
</td>
//向上排序
public function weddorderup(){//得到该数据当前的id和顺序
$id=I('get.id');
$where['id']=$id;
$wedd_order=I('get.wedd_order');
if($wedd_order==1){
$this->error('当前排序已经是第一个');
}
//根据id获取整条数据
$img=M('img');
$currinfo=$img->where($where)->find();
//print_r($currinfo);
//判断是否为子分类,若为子分类,则查出pid相同的数据,若不为只分类,则查出wedd_pos相同的数据
if($currinfo['pid']==0){
$weddpos=$currinfo['wedd_pos'];
$classify['wedd_pos']=$weddpos;
$classify['wedd_order']=array('lt',$wedd_order);
$twoinfo=$img->where($classify)->order('wedd_order desc')->find();
$updw['id']=$currinfo['id'];
$data['wedd_order']=$wedd_order-1;
$twow['id']=$twoinfo['id'];
$twodata['wedd_order']=$wedd_order;
$result=$img->where($updw)->save($data); // 根据条件更新记录
$tworesult=$img->where($twow)->save($twodata);
if ( false !== $result || false !== $tworesult){
$this->success('排序成功!');
}else{
$this->error('排序失败!');
}
}else{
$weddpos=$currinfo['pid'];
$classify['pid']=$weddpos;
$classify['wedd_order']=array('lt',$wedd_order);
$twoinfo=$img->where($classify)->order('wedd_order desc')->find();
$updw['id']=$currinfo['id'];
$data['wedd_order']=$wedd_order-1;
$twow['id']=$twoinfo['id'];
$twodata['wedd_order']=$wedd_order;
$result=$img->where($updw)->save($data); // 根据条件更新记录
$tworesult=$img->where($twow)->save($twodata);
if ( false !== $result || false !== $tworesult){
$this->success('排序成功!');
}else{
$this->error('排序失败!');
}
}
}
//向下排序
public function weddorderdown(){
$id=I('get.id');
$where['id']=$id;
$wedd_order=I('get.wedd_order');
//根据id获取整条数据
$img=M('img');
$currinfo=$img->where($where)->find();
//print_r($currinfo);
//判断是否为子分类,若为子分类,则查出pid相同的数据,若不为只分类,则查出wedd_pos相同的数据
if($currinfo['pid']==0){
$weddpos=$currinfo['wedd_pos'];
$classify['wedd_pos']=$weddpos;
$classify['wedd_order']=array('gt',$wedd_order);
$twoinfo=$img->where($classify)->order('wedd_order asc')->find();
if(!$twoinfo){
$this->error('已经排在末尾');
}
$updw['id']=$currinfo['id'];
$data['wedd_order']=$wedd_order+1;
$twow['id']=$twoinfo['id'];
$twodata['wedd_order']=$wedd_order;
$result=$img->where($updw)->save($data); // 根据条件更新记录
$tworesult=$img->where($twow)->save($twodata);
if ( false !== $result || false !== $tworesult){
$this->success('排序成功!');
}else{
$this->error('排序失败!');
}
}else{
$weddpos=$currinfo['pid'];
$classify['pid']=$weddpos;
$classify['wedd_order']=array('gt',$wedd_order);
$twoinfo=$img->where($classify)->order('wedd_order asc')->find();
if(!$twoinfo){
$this->error('已经排在末尾');
}
$updw['id']=$currinfo['id'];
$data['wedd_order']=$wedd_order+1;
$twow['id']=$twoinfo['id'];
$twodata['wedd_order']=$wedd_order;
$result=$img->where($updw)->save($data); // 根据条件更新记录
$tworesult=$img->where($twow)->save($twodata);
if ( false !== $result || false !== $tworesult){
$this->success('排序成功!');
}else{
$this->error('排序失败!');
}
}
}