织梦cms批量取消审核文档的实现方法

/*--------------------------
//取消审核文档
function checkArchives1() {   }
---------------------------*/
else if($dopost=="checkArchives1")
{
 CheckPurview('a_Check,a_AccCheck,sys_ArcBatch');
 require_once(DEDEADMIN."/inc/inc_archives_functions.php");
 if( !empty($aid) && empty($qstr) )
 {
  $qstr = $aid;
 }
 if($qstr=='')
 {
  ShowMsg("参数无效！",$ENV_GOBACK_URL);
  exit();
 }
 $arcids = ereg_replace('[^0-9,]','',ereg_replace('`',',',$qstr));
 $query = "Select arc.id,arc.typeid,ch.issystem,ch.maintable,ch.addtable From `wmd_arctiny` arc
            left join `wmd_arctype` tp on tp.id=arc.typeid
            left join `wmd_channeltype` ch on ch.id=tp.channeltype
            where arc.id in($arcids) ";
 $dsql->SetQuery($query);
 $dsql->Execute('ckall');
 while($row = $dsql->GetArray('ckall'))
 {
  $aid = $row['id'];
  //print_r($row);
  $maintable = ( trim($row['maintable'])=='' ? 'wmd_archives' : trim($row['maintable']) );
  $dsql->ExecuteNoneQuery("Update `wmd_arctiny` set arcrank='-1' where id='$aid' ");
  if($row['issystem']==-1)
  {
   $dsql->ExecuteNoneQuery("Update `".trim($row['addtable'])."` set arcrank='-1' where aid='$aid' ");
  }
  else
  {
   $dsql->ExecuteNoneQuery("Update `$maintable` set arcrank='-1' where id='$aid' ");
  }
  $pageurl = MakeArt($aid,false);
 }
 ShowMsg("成功审核指定的文档！",$ENV_GOBACK_URL);
 exit();
}

function checkArc(aid){
 var qstr=getCheckboxItem();
 if(aid==0) aid = getOneItem();
 location="archives_do.php?aid="+aid+"&dopost=checkArchives&qstr="+qstr;
}