<? session_start();
//include "includes/header.inc";

/*
* First we want a function that will check and make sure the inputted username is valid.
*/
require('libs/Smarty.class.php');
require('config.php');

$smarty = new Smarty;
$error="";

if(isset($_GET['id']))
{
       $deleteid=$_GET['id'];
	   $sql = "delete from covermaster where id=$deleteid";
       $result = mysql_query($sql);
	   header("Location:".$_SERVER['HTTP_REFERER']);exit;
}

if($_POST)
{
    $Pages=$_POST['pages'];
	        $papertypeid=$_POST['papertype'];
			   
			 
			 $binid=$_POST['selebinding'];
		 $getbindvalue= "SELECT * FROM bindingmaster where id='$binid'";
			 $resultbindeid = mysql_query($getbindvalue);
			 $rowvaluebind=mysql_fetch_assoc($resultbindeid);
	         $BindingValue=$rowvaluebind['brate'];
		 $getfactor=$rowvaluebind['applyfactor'];

			
	          $Booktypeid=$_POST['booktype'];
		
	
		     $Booksizeeid=$_POST['booksize'];
			 $getsizevalue= "SELECT * FROM sizes where id='$Booksizeeid'";
			 $resultsizeeid = mysql_query($getsizevalue);
			 $rowvaluesizek=mysql_fetch_assoc($resultsizeeid);
	$BookSizeValue=$rowvaluesizek['trate'];
    $booksizefactor=$rowvaluesizek['tfactor'];
	
	
	$totalvalue1=0;
	$Totalvalue1=($Pages*$BookSizeValue*$booksizefactor);
	
	
	if(($papertypeid==1) && ($Booktypeid==1))
	{
	          $paperprice=0.9;
	          $result11 = mysql_query("SELECT prate,applyfactor FROM papertype where id='3'");
		      $row11=mysql_fetch_assoc($result11);
	}
	if(($papertypeid==1) && ($Booktypeid==2))
	{
	  $paperprice=8;
	}
	
	if(($papertypeid==2) && ($Booktypeid==1))
	{
	  $paperprice=1;
	}
	
	if(($papertypeid==2) && ($Booktypeid==2))
	{
	  $paperprice=8.5;
	}
	if(!isset($paperprice))
	{
	$paperprice=0;
	}
	$Totalvalue2=0;
 $Totalvalue2=($paperprice*$booksizefactor*$Pages);
	
	
	         $Totalvalue3=0;
			 
			 if($getfactor=='yes')
			 {
			
			  $Totalvalue3=($BindingValue*$booksizefactor);
			 }
			 else
			 {
			   $Totalvalue3=$BindingValue;
			 } 		 
			
			
			//get cover value
			
			$getcovervalue= "SELECT * FROM covermaster";
			$resultcover = mysql_query($getcovervalue);
			$rowfinalcover=mysql_fetch_assoc($resultcover);
		    $finalcovervalue=$rowfinalcover['crate'];
			$checkfactor=$rowfinalcover['cfactor'];
			if($checkfactor=='yes')
			{
			   $coverwithfactor=($finalcovervalue*$booksizefactor);
			 }
			 else
			 {
			   $coverwithfactor=$finalcovervalue;
			 }
		  
		$TotalCost=$Totalvalue2+ $Totalvalue3+$coverwithfactor;
		
		
		$bookquantity=$_POST['bookquantity'];
		if($bookquantity=="")
		{
		  $bookquantity=1;
		}
		
			$getdiscountvalue= "SELECT * FROM discountmaster";
			$resultdiscount = mysql_query($getdiscountvalue);
			
			$i=0;
			$j=0;
			$disarra=array();
			while($rowdiscount=mysql_fetch_assoc($resultdiscount))
			{
			   
			      $disarra[]=$rowdiscount['quantity'];
				  //$actualdis=$rowdiscount['discount'];
				  //$disarra[$discvalue][0]=$actualdis;
				  
				  
			}
			sort($disarra);
				
		$cnt=count($disarra);
		for($i=0;$i<$cnt;$i++)
		{
		      if(isset($disarra[$i+1]))
			  {
		
						 if($bookquantity>=$disarra[$i] && $bookquantity<$disarra[$i+1] )
						 {
							$finaldiscountvalu=$disarra[$i];
						 }
			  }
			  elseif($bookquantity>=$disarra[$i])
			  {
			    $finaldiscountvalu=$disarra[$i];
			  }			 
		}
		if(!isset($finaldiscountvalu))
		{
		   $finaldiscountvalu=0;
		}
		
		
		    $querydis= "SELECT * FROM discountmaster where 	quantity='$finaldiscountvalu'";
			$resultdiscount = mysql_query($querydis);
			$recodis=mysql_fetch_assoc($resultdiscount);
			$getperdis=$recodis['discount'];
			$disfactor=$recodis['dfactor'];
			if($disfactor=='yes')
			{
			    $getperdis=($getperdis*$booksizefactor);
			}
			
			$valuewithdis=($getperdis*$TotalCost)/100;
			$valuewithdis=$TotalCost-$valuewithdis;
			
			$smarty->assign("discount",$getperdis);
			$smarty->assign("pricewithdis",$valuewithdis);	
			
			$customyotal=($bookquantity*$valuewithdis);
	$smarty->assign("customyotal",$customyotal);
	
	
		$smarty->assign("Estimatedprice",$TotalCost);	
			 
}


$sql = "SELECT * FROM sizes";
$result = mysql_query($sql);
//$record=array();
while($row=mysql_fetch_assoc($result))
{
 $record[]=$row;
}
$smarty->assign('records',$record);


$booktype= "SELECT * FROM covermaster";
$resultbooktype = mysql_query($booktype);
$booktype=array();
while($rowbooktype=mysql_fetch_assoc($resultbooktype))
{
 $booktype[]=$rowbooktype;
}
$smarty->assign('booktype',$booktype);


$papertype= "SELECT * FROM papertype";
$resultpapertype = mysql_query($papertype);
$papertype=array();
while($rowpapertype=mysql_fetch_assoc($resultpapertype))
{
 $papertype[]=$rowpapertype;
}
$smarty->assign('papertype',$papertype);


$binding= "SELECT * FROM bindingmaster";
$resultbinding = mysql_query($binding);
$getbinding=array();
while($rowbibding=mysql_fetch_assoc($resultbinding))
{
 $getbinding[]=$rowbibding;
}
$smarty->assign('getbinding',$getbinding);


$discountquery = mysql_query("SELECT * FROM discountmaster order by quantity asc");
$disrecods=array();
$i=0;
while($rowdis=mysql_fetch_assoc($discountquery))
{
  
  $disrecods[$i]=$rowdis;
   
            $getperdistemp=$rowdis['discount'];
			$disfactortemp=$rowdis['dfactor'];
			if($disfactortemp=='yes')
			{
			    $getperdistemp=($getperdistemp*$booksizefactor);
			}
			if(!isset($TotalCost))
			{
			  $TotalCost=0;
			}
			
			$valuewithdistemp=($getperdistemp*$TotalCost)/100;
			$valuewithdistemp=$TotalCost-$valuewithdistemp;
			
			$disrecods[$i]['rateperbook']=$valuewithdistemp;
			
			$totalprice=($valuewithdistemp*$rowdis['quantity']);
			$disrecods[$i]['totalprize']=$totalprice;
			
 
 $i++;
 
}


if(isset($_POST['getquo']))
{


                  $to=$_POST['emailadd'];
				
				   $subject="Quote Details"; // Your subject
				   // From
				   $header = 'From: info@picatype.com' . "\r\n";
				   $header.= "Content-type: text/html\r\n"; 
				 //add code for selecting $userid and $pass for user table for the input $email_to.
				   // Your message
				   $randpad="admin".rand();
				   
				   $messages="";
				   $messages.="<img src=\"http://www.picatype.com/review/images/picatype.png\">"."<br><br><br>";
				   $messages.="<span style=\"font:normal 14px arial; font-weight:normal; color:#333333;\">Email Address:</span>".$_POST['emailadd']."<br>";
					$messages.="<span style=\"font:normal 14px arial; font-weight:normal; color:#333333;\">Contact Number:</span>".$_POST['contactno']."<br><br>";
				   $messages.="<strong>Quote :</strong>  \r\n";
				   //$messages.="-------------------------------------- \r\n";
				   $messages.="<table style=\"background:#e5e5e5; padding:10px; font:normal 14px arial; font-weight:normal; color:#333333; border-radius:10px; -moz-border-radius:10px; -webkit-border-radius:10px;\" cellspacing=\"10\">";
				   
				   
				   $sqlquote = "SELECT * FROM sizes where id=".$_POST['booksize'];
				   $resultrow = mysql_query($sqlquote);
				   $quoteize=mysql_fetch_assoc($resultrow);
				   
				   if($_POST['booktype']==1)
				   {
				     $booktypequote="B&W Interior (Colored Cover)";
				   }
				   if($_POST['booktype']==2)
				   {
				     $booktypequote="Full Color (Interior and Cover)";
				   }
				   
				   
				   if($_POST['papertype']==1)
				   {
				     $papertypequote="Plain Paper";
				   }
				   if($_POST['papertype']==2)
				   {
				     $papertypequote="Coated paper";
				   }
				   
				   $sqlbingq = "SELECT * FROM bindingmaster where id=".$_POST['selebinding'];
				   $resultrowqbind = mysql_query($sqlbingq);
				   $quotebinding=mysql_fetch_assoc($resultrowqbind);
				   
				   
				   $messages.="<tr><td style=\"color:#0082c6;\">Number Of Pages:</td><td>".$_POST['pages']."</td></tr>";
				   $messages.="<tr><td style=\"color:#0082c6;\">Book Size:</td><td>".$quoteize['tsize']."</td></tr>";
				   $messages.="<tr><td style=\"color:#0082c6;\">Book Type:</td><td>".$booktypequote."</td></tr>";
				   $messages.="<tr><td style=\"color:#0082c6;\">Paper Type:</td><td>".$papertypequote."</td></tr>";
				   $messages.="<tr><td style=\"color:#0082c6;\">Binding:</td><td>".$quotebinding['bindingmaster']."</td></tr>";
				   $messages.="<tr><td colspan=\"2\"><hr>\r\n</td></tr>";
				   $messages.="<tr><td><strong style=\"color:#0082c6;\">Rates:</strong></td><td></td></tr>";
				  
					  
				   $discountquery1 = mysql_query("SELECT * FROM discountmaster order by quantity asc");
					$disrecods1=array();
					$i=0;
					$messages.="<tr><td><strong style=\"color:#0082c6;\">QTY</strong></td><td><strong style=\"color:#0082c6;\">RATE</strong></td><td><strong style=\"color:#0082c6;\">Total Price</strong></td></tr>";
					while($rowdis1=mysql_fetch_assoc($discountquery1))
					{
					  
					            $disrecods1[$i]=$rowdis1;
					   
								$getperdistemp1=$rowdis1['discount'];
								$disfactortemp1=$rowdis1['dfactor'];
								if($disfactortemp1=='yes')
								{
									$getperdistemp1=($getperdistemp1*$booksizefactor);
								}
								if(!isset($TotalCost))
								{
								  $TotalCost=0;
								}
								
								$valuewithdistemp1=($getperdistemp1*$TotalCost)/100;
								$valuewithdistemp1=$TotalCost-$valuewithdistemp1;
								
								$disrecods1[$i]['rateperbook']=$valuewithdistemp1;
								
								$totalprice1=($valuewithdistemp1*$rowdis1['quantity']);
								$disrecods1[$i]['totalprize']=$totalprice1;
								
								  $messages.="<tr><td>".$rowdis1['quantity']."</td><td>".$valuewithdistemp1."</td><td>".$totalprice1."</td></tr>";
								
					 
					 $i++;
					 
					}
				   
				   if($_POST['bookquantity']!=1)
				   {
				   	$messages.="<tr><td colspan=\"2\"><hr>\r\n</td></tr>";
				    $messages.="<tr><td style=\"color:#0082c6;\">Entered Quantity:</td></tr>";
				    $messages.="<tr><td>".$_POST['bookquantity']."</td><td>".$valuewithdis."</td><td>".$customyotal."</td></tr>";
				   }
				   
				   
				  // $messages.="UserId: $userid \r\n";
				   $messages.="</table>";
				    //$messages.="Quote - picatype.com  \r\n";
				   //$messages.="-------------------------------------- \r\n";
				 
				 //echo $messages;exit;
				 
				   // send email
				   
				   $sentmail = mail($to,$subject,$messages,$header);
				    $sentmail2 = mail("claude@picatype.com",$subject,$messages,$header);
				// $sentmail2 = mail("claude@picatype.com",$subject,$messages,$header);
					// $sentmail2 = mail("pritam@realityinfo.com",$subject,$messages,$header);
				 $thankss="Thankyou for your enquiry.";


}


$smarty->assign('disrecods',$disrecods);

if(!(isset($thankss)))
{
  $smarty->assign("thnk", ""); 
}
else
{
 $smarty->assign("thnk",$thankss); 
}

$smarty->assign("error", $error);

$smarty->display("calculate.tpl");
?>