delete_offer.php

通达OA部分源代码

<?php
	include_once('logincheck.php');
	include_once('myconnect.php');
	
	$strinlist="0";
	
	foreach($_POST as $key => $value)
	{
		if(stristr($key,"checkbox"))
				$strinlist.=",".$value;
	}

	//echo $strinlist;
	//die();
	$strquery=" and sb_id in ($strinlist) ";

if(isset($_REQUEST["Submit"]) && ($_REQUEST["Submit"]=='Remove'))
{		//remove 
		$query_msg_del="delete from sbbleads_offers where sb_uid=".$_SESSION["sbbleads_userid"]." $strquery";
		$rs_del=mysql_query($query_msg_del);
		$msgdeleted=mysql_affected_rows();
	if($msgdeleted > 0)
	{	
	/////-----removing from categories
		$query="delete from sbbleads_offer_cats where 1 and sb_offer_id in ($strinlist)";
		mysql_query($query);
	/////------removing images
		$query1="delete from sbbleads_offer_images where 1 and sb_offer_id in ($strinlist)";
		mysql_query($query1);
////-----remove favorites
		$query2="delete from sbbleads_favorites where sb_type='sell' and sb_offer_id in ($strinlist)";
		mysql_query($query2);
	
	//	header("Location: msg_deleted.php");
		header("Location: gen_confirm_mem.php?errmsg=".urlencode("$msgdeleted sell offer(s) removed."));
		die();
	}
	else
	{
		header("Location: gen_confirm_mem.php?err=manage_offers&errmsg=".urlencode("Unable to remove sell offers."));
		die();
	}
}	//end if remove
elseif(isset($_REQUEST["Submit2"]) && ($_REQUEST["Submit2"]=='Relist'))
{	//relist
	$sbcurrent_date=date("YmdHis",time());
	$query_off="update sbbleads_offers set sb_postedon=$sbcurrent_date where sb_uid=".$_SESSION["sbbleads_userid"]." $strquery";
	mysql_query($query_off);
	$msgdeleted=mysql_affected_rows();
	if($msgdeleted > 0)
	{	
		header("Location: gen_confirm_mem.php?errmsg=".urlencode("$msgdeleted sell offer(s) relisted"));
		die();
	}
	else
	{
		header("Location: gen_confirm_mem.php?err=manage_offers&errmsg=".urlencode("Unable to relist sell offers."));
		die();
	}

}	//end else relist
header("Location: gen_confirm_mem.php?errmsg=".urlencode("Invalid access, denied."));
die();
?>