直接上代码: //审核文档 function checkArchives() { } else if($dopost=="checkArchives") { $lasttime=time(); 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 `dede_arctiny` arc left join `dede_arctype` tp on tp.id=arc.typeid left join `dede_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‘])==‘‘ ? ‘dede_archives‘ : trim($row[‘maintable‘]) ); if($dsql->ExecuteNoneQuery("Update `dede_arctiny` set arcrank=‘0‘,sortrank=‘$lasttime‘,senddate=‘$lasttime‘ where id=‘$aid‘ ")) { $dsql->ExecuteNoneQuery("Update `dede_taglist` set arcrank=‘0‘ where aid=‘$aid‘ "); } if($row[‘issystem‘]==-1) { $dsql->ExecuteNoneQuery("Update `".trim($row[‘addtable‘])."` set arcrank=‘0‘,pubdate=‘$lasttime‘,sortrank=‘$lasttime‘,senddate=‘$lasttime‘ where aid=‘$aid‘ "); } else { $dsql->ExecuteNoneQuery("Update `$maintable` set arcrank=‘0‘,pubdate=‘$lasttime‘,sortrank=‘$lasttime‘,senddate=‘$lasttime‘, dutyadmin=‘".$cuserLogin->getUserID()."‘ where id=‘$aid‘ "); } $pageurl = MakeArt($aid,false); } ShowMsg("成功审核指定的文档!",$ENV_GOBACK_URL); exit(); }
这样直接放到模板里面使用就可以了。 |