<?php 
require_once('pdoconfig.php');
$off_id=$_SESSION['poster_id'];
$agreeid=$_REQUEST['agreeid'];
$partyid=$_REQUEST['partyid'];
$contid=$_REQUEST['contid'];
$agtfromdt=$_REQUEST['agtfromdt'];
$agttodt=$_REQUEST['agttodt'];
$license_fee=$_REQUEST['licensfee'];
$remarks=$_REQUEST['remarks'];

$agtfromdt=date('Y/m/d',strtotime($agtfromdt));
$agttodt=date('Y/m/d',strtotime($agttodt));
$dt=date("Y-m-d");
	
if($agreeid=='')
{	
	
	$sql="insert into  contract_agreement set cont_id=?,party_id=?,agree_from_date=?,agree_to_date=?,license_fee=?,remarks=?";
	$arr=array($contid,$partyid,$agtfromdt,$agttodt,$license_fee,$remarks);
	$res=$action->insertp($sql,$arr);

	if($res>0)
	{
	 echo "<script>alert('Agreement save successfull'); window.location.href='agreement_contracts.php?partyid=$partyid&contid=$contid'</script>";
	}
}
else
{
          //die("update contract_agreement set cont_id=?,party_id=?,agree_from_date=?,agree_to_date=?,license_fee=?,remarks=? where agreement_id=?");
        
		$sql="update contract_agreement set cont_id=?,party_id=?,agree_from_date=?,agree_to_date=?,license_fee=?,remarks=? where agreement_id=?";
		$arr=array($contid,$partyid,$agtfromdt,$agttodt,$license_fee,$remarks,$agreeid);
		$res=$action->updatep($sql,$arr);
	
		if($res>0)
		{
		 echo "<script>alert('Agreement update successfull'); window.location.href='agreement_contracts.php?partyid=$partyid&contid=$contid'</script>";
		}

}
?>