Elep

<?php

include "zoho_functions.php";
$company = $_GET["company"];
$get_companys=explode("|||",$company);
$dates=$_GET["dates"];
$data_d=array();
$cnt=0;
for($r=0;$r<count($dates);$r++)
{
	$get_data=search_Records("CustomModule1","(Date:".$dates[$r].") AND (Tour Company:".$get_companys[0].")",1,200);
	
	if($get_data['response']['error']['message']=="You crossed your license limit")
	{
		$msg="Your API limit has been reached!!!";
		break;
	}
	if(!empty($get_data['response']['result']['CustomModule1']['row']))
	{
		$datarows=$get_data['response']['result']['CustomModule1']['row'];
		
		if(!empty($datarows[0]))
		{
			foreach($datarows as $index=>$value)
			{
				foreach($value['FL'] as $key=>$val)
				{
					if($val["val"]=="CHILD")
					{
						$data_d["CHILD"][$cnt]=$val["content"];
					}
					else if($val["val"]=="ADULT")
					{
						$data_d["ADULT"][$cnt]=$val["content"];
					}
					else if($val["val"]=="INDY Child")
					{
						$data_d["INDY Child"][$cnt]=$val["content"];
					}
					else if($val["val"]=="INDY Adult")
					{
						$data_d["INDY Adult"][$cnt]=$val["content"];
					}
					else if($val["val"]=="Arrival Time")
					{
						$data_d["Arrival Time"][$cnt]=$val["content"];
					}
					else if($val["val"]=="Departure Time")
					{
						$data_d["Departure Time"][$cnt]=$val["content"];
					}
					else if($val["val"]=="Ship")
					{
						$data_d["Ship"][$cnt]=$val["content"];
					}
					else if($val["val"]=="Tour Company_ID")
					{
						$data_d["Company_ID"]=$val["content"];
					}
					else if($val["val"]=="Tour")
					{
						$data_d["Tour"]=$val["content"];
					}
					else if($val["val"]=="Date")
					{
						$data_d["Date"][$cnt]=$val["content"];
						$data_d["bDate"][$cnt]=$val["content"];
					}
					else if($val["val"]=="Booking Name")
					{
						$data_d["Booking Name"]=$val["content"];
					}
					else if($val["val"]=="One Way")
					{
						$data_d["One Way"][$cnt]=$val["content"];
					}
					else if($val["val"]=="PORT SCHED")
					{
						$data_d["PORT SCHED"][$cnt]=$val["content"];
					}
					else if($val["val"]=="CUSTOMMODULE1_ID")
					{
						$data_d["ids"][$cnt]=$val["content"];
					}
					
				}
				$cnt++;
			}
		}
		else
		{
			foreach($datarows['FL'] as $key=>$val)
			{
				if($val["val"]=="CHILD")
				{
					$data_d["CHILD"][$cnt]=$val["content"];
				}
				else if($val["val"]=="ADULT")
				{
					$data_d["ADULT"][$cnt]=$val["content"];
				}
				else if($val["val"]=="INDY Child")
				{
					$data_d["INDY Child"][$cnt]=$val["content"];
				}
				else if($val["val"]=="INDY Adult")
				{
					$data_d["INDY Adult"][$cnt]=$val["content"];
				}
				else if($val["val"]=="Arrival Time")
				{
					$data_d["Arrival Time"][$cnt]=$val["content"];
				}
				else if($val["val"]=="Departure Time")
				{
					$data_d["Departure Time"][$cnt]=$val["content"];
				}
				else if($val["val"]=="Ship")
				{
					$data_d["Ship"][$cnt]=$val["content"];
				}
				else if($val["val"]=="Tour Company_ID")
				{
					$data_d["Company_ID"]=$val["content"];
				}
				else if($val["val"]=="Tour")
				{
					$data_d["Tour"]=$val["content"];
				}
				else if($val["val"]=="Date")
				{
					$data_d["Date"][$cnt]=$val["content"];
					$data_d["bDate"][$cnt]=$val["content"];
				}
				else if($val["val"]=="Booking Name")
				{
					$data_d["Booking Name"]=$val["content"];
				}
				else if($val["val"]=="One Way")
				{
					$data_d["One Way"][$cnt]=$val["content"];
				}
				else if($val["val"]=="PORT SCHED")
				{
					$data_d["PORT SCHED"][$cnt]=$val["content"];
				}
				else if($val["val"]=="CUSTOMMODULE1_ID")
				{
					$data_d["ids"][$cnt]=$val["content"];
				}
				$cnt++;
			}
		}
		
	}
}

if($msg!="Your API limit has been reached!!!")
{
	if(!empty($data_d))
	{
		$pricebook=search_Records("PriceBooks","(Company:".$get_companys[0].")");
		if(isset($pricebook['response']['nodata']['message']))
		{
			$msg= "No Pricebook is associated with company!!!";
		}
		if(!empty($pricebook['response']['result']['PriceBooks']['row'][0]))
		{
			$pricebookrow=$pricebook['response']['result']['PriceBooks']['row'];
			foreach($pricebookrows as $key1=>$val1)
			{
				foreach($val1["FL"] as $key2=>$val2)
				{
					if($val2["val"]=="BOOKID")
					{
						$data_d["BOOKID"]=$val2["content"];
					}
				}
			}
		}
		else
		{
			$pricebookrow=$pricebook['response']['result']['PriceBooks']['row'];
			
			foreach($pricebookrow["FL"] as $key1=>$val1)
				{
					if($val1["val"]=="BOOKID")
					{
						
						$data_d["BOOKID"]=$val1["content"];
					}
				}
		}

if($msg!="No Pricebook is associated with company!!!")
		{
			$pro_price=get_Related_Records("Products","PriceBooks",$data_d["BOOKID"]);
			$pro_pricerow=$pro_price['response']['result']['Products']['row'];
			$i=0;
			foreach($pro_pricerow as $key1=>$val1)
					{
						foreach($val1["FL"] as $key2=>$val2)
						{
							if($val2["val"]=="Product Name")
							{
								$data_d["Product Name"][]=$val2["content"];
							}
							elseif($val2["val"]=="List Price")
							{
								$data_d["List Price"][]=$val2["content"];
							}
							elseif($val2["val"]=="PRODUCTID")
							{
								$data_d["PRODUCTID"][]=$val2["content"];
							}
						}
						$i++;
					}
			usort($data_d["Date"], function($a, $b) {
				$dateTimestamp1 = strtotime($a);
				$dateTimestamp2 = strtotime($b);

return $dateTimestamp1 < $dateTimestamp2 ? -1: 1;
			});
			// echo "<pr>";print_r($data_d);die;
			$products="";
			$inc=1;
			$subtotal=0;
			for($u=0;$u<count($data_d["ids"]);$u++)
			{
				if($data_d["One Way"][$u]=="true" && $data_d["PORT SCHED"][$u]!="" )
				{
					for($r=0;$r<count($data_d["Product Name"]); $r++)
					{
						
						if($data_d["Product Name"][$r]=="INDE Child One Way" && $data_d["INDY Child"][$u]!=0)
						{
							$Descp = "One Way Trip- INDY Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["INDY Child"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						elseif($data_d["Product Name"][$r]=="INDE Adult One Way" && $data_d["INDY Adult"][$u]!=0)
						{
							$Descp = "One Way Trip- INDY Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["INDY Adult"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						elseif($data_d["Product Name"][$r]=="Adult One Way" && $data_d["ADULT"][$u]!=0)
						{
							$Descp = "One Way Trip- Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["ADULT"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						elseif($data_d["Product Name"][$r]=="Child One Way" && $data_d["CHILD"][$u]!=0)
						{
							$Descp = "One Way Trip- Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["CHILD"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						
					}
				}
				elseif(($data_d["One Way"][$u]=="false" && $data_d["PORT SCHED"][$u]=="S"))
				{
					for($r=0;$r<count($data_d["Product Name"]); $r++)
					{
						if($data_d["Product Name"][$r]=="INDY Child" && $data_d["INDY Child"][$u]!=0)
						{
							$Descp = "Round Trip- INDY Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["INDY Child"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						elseif($data_d["Product Name"][$r]=="INDY Adult"  && $data_d["INDY Adult"][$u]!=0)
						{
							$Descp = "Round Trip- INDY Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["INDY Adult"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						elseif($data_d["Product Name"][$r]=="Adult" && $data_d["ADULT"][$u]!=0)
						{
							$Descp = "Round Trip- Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["ADULT"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
						elseif($data_d["Product Name"][$r]=="Child" && $data_d["CHILD"][$u]!=0)
						{
							$Descp = "Round Trip- Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u];
							$Qty=$data_d["CHILD"][$u];
							$total=$Qty*$data_d["List Price"][$r];
							$subtotal+=$total;
							$products.="<product no=\"".$inc."\"><FL val=\"Product Id\">".$data_d["PRODUCTID"][$r]."</FL><FL val=\"Quantity\">".$Qty."</FL><FL val=\"Product Name\">".$data_d["Product Name"][$r]."</FL><FL val=\"Product Description\">".$Descp."</FL><FL val=\"List Price\">".$data_d["List Price"][$r]."</FL><FL val=\"Net Total\">".$total."</FL><FL val=\"Total\">".$total."</FL></product>";
							$inc++;
						}
					}
				}
					
			}
				
			//echo "<pr>";print_r($products);die;

$invdate=date("Y-m-d");
			$Startdate=$dates[0];
			$Enddate=$dates[count($dates)-1];
			$subj=$get_companys[0]."_INV_".$Startdate."_".$Enddate;
			$xml="<Invoices><row no=\"1\"><FL val=\"Subject\">".$subj."</FL><FL val=\"Start Date\">".$Startdate."</FL><FL val=\"End Date\">".$Enddate."</FL><FL val=\"Invoice Date\">".$invdate."</FL><FL val=\"Status\">Created</FL><FL val=\"ACCOUNTID\">".$data_d["Company_ID"]."</FL><FL val=\"Product Details\">".$products."</FL><FL val=\"Sub Total\">".$subtotal."</FL><FL val=\"Grand Total\">".$subtotal."</FL></row></Invoices>";
			$in=insert_Records("Invoices",$xml)	;
			if(isset($in["response"]["result"]["recorddetail"]["FL"][0]))
			{
				$id=$in["response"]["result"]["recorddetail"]["FL"][0]["content"];
				$xml="<CustomModule1><row no=\"1\"><FL val=\"Invoice_ID\">".$id."</FL></row></CustomModule1>";
				for($e=0;$e<count($data_d["ids"]);$e++)
				{
					$up=update_Records("CustomModule1",$data_d["ids"][$e],$xml);
				}
			}
			$msg="Invoice ".$in["response"]["result"]["message"];
		}
	}
	else
	{
		$msg="There is no data found!!!";	
	}
}
echo $msg;
?>