Elep

<?php
include "zoho_functions.php";
$company = $_GET["company"];
$get_companys=explode("|||",$company);
$dates=$_GET["dates"];
$data_d=array();
$cnt=0;
$companyName = str_replace(" ","%20",$get_companys[0]);
$msg = "";
for($r=0;$r<count($dates);$r++)
{
    $get_data = "";
    $get_data=search_records_non_COQL("Bookings","((Arrival_Date1:equals:$dates[$r])and(Tour_Company:equals:$companyName))");
    if( isset($get_data['message']) && $get_data['message']=="You crossed your license limit")
    {
        $msg="Your API limit has been reached!!!";
        break;
    }
    if(isset($get_data) && ($get_data != null || $get_data != ""))
    {
        $datarows=$get_data['data'];
        if(!empty($datarows[0]))
        {
            foreach($datarows as $key=>$val)
            {
                $data_d["Booking Name"][$cnt]=$val["Name"];
                $data_d["Day"][$cnt]=$val["Day"];
                $data_d["CHILD"][$cnt]=$val["CHILD"];
                $data_d["ADULT"][$cnt]=$val["ADULT"];
                $data_d["INDY Child"][$cnt]=$val["INDY_Child"];
                $data_d["INDY Adult"][$cnt]=$val["INDY_Adult"];
                $data_d["Arrival Time"][$cnt]=$val["Arriv_TIME"];
                $data_d["Departure Time"][$cnt]=$val["Depart_TIME"];
                $data_d["Ship"][$cnt]=$val["Ship"]["name"];
                $data_d["VOUCHER No"][$cnt]=$val["VOUCHER_No"];
                $data_d["Company_ID"]=$val["Tour_Company"]["id"];
                $data_d["Tour Company"][$cnt]=$val["Tour_Company"]["name"];
                $data_d["Tour"][$cnt]=$val["Tour"]["name"];
                $data_d["Date"][$cnt]=$val["Arrival_Date1"];
                $data_d["bDate"][$cnt]=$val["Arrival_Date1"];
                $data_d["One Way"][$cnt]=$val["Round_Trip_Entry"];
                $data_d["PORT SCHED"][$cnt]=$val["PORT_SCHED"];
                $data_d["ids"][$cnt]=$val["id"];
                $data_d["Booking Cancelled"][$cnt]=$val["Booking_Cancelled"];
                $cnt++;
            }
        }
    }
}
if($msg!="Your API limit has been reached!!!")
{
    if(!empty($data_d))
    {
        $pricebook=search_records_non_COQL("Price_Books","(Company:equals:$companyName)");
        if(isset($pricebook['message']))
        {
            $msg= "No Pricebook is associated with company!!!";
        }
        if(!empty($pricebook['data'][0]))
        {
            $pricebookrow=$pricebook['data'];
            foreach($pricebookrow as $key1=>$val1)
            {
                $data_d["BOOKID"]=$val1["id"];
            }
        }
        if($msg!="No Pricebook is associated with company!!!")
        {
            $pro_price=get_Related_Records("Price_Books", $data_d["BOOKID"],"Products", "Product_Name");
            $pro_pricerow=$pro_price['data'];
            $i=0;
            foreach($pro_pricerow as $key1=>$val1)
            {
                $data_d["Product Name"][]=$val1["Product_Name"];
                $data_d["List Price"][]=$val1["list_price"];
                $data_d["PRODUCTID"][]=$val1["id"];
                $i++;
            }
            usort($data_d["Date"], function($a, $b) {
                $dateTimestamp1 = strtotime($a);
                $dateTimestamp2 = strtotime($b);
                return $dateTimestamp1 < $dateTimestamp2 ? -1: 1;
            });
            $products=array();
            $inc=0;
            $subtotal=0;
            for($u=0;$u<count($data_d["ids"]);$u++)
            {
                if($data_d["Booking Cancelled"][$u]!="true")
                {
                    $data_d["up_ids"][]=$data_d["ids"][$u];
                    if($data_d["One Way"][$u]=="true" && $data_d["PORT SCHED"][$u]!="" )
                    {
                        if($data_d["Tour"][$u] == "BUS SUMMIT")
                        {
                            for($r=0;$r<count($data_d["Product Name"]); $r++)
                            {
                                if($data_d["Product Name"][$r]=="Bus Summit Adult One Way" && $data_d["ADULT"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$r].") - Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["ADULT"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="Bus Summit Child One Way" && $data_d["CHILD"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$r].") - Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["CHILD"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                            }
                        }
                        elseif($data_d["Ship"][$u] == "INDE")
                        {
                            for($r=0;$r<count($data_d["Product Name"]); $r++)
                            {
                                if($data_d["Product Name"][$r]=="INDE Adult One Way" && $data_d["ADULT"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$u].") - Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["ADULT"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="INDE Child One Way" && $data_d["CHILD"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$u].") - Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["CHILD"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                            }
                        }
                        else
                        {
                            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 (".$data_d["Tour"][$u].") - INDY Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["INDY Child"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="INDE Adult One Way" && $data_d["INDY Adult"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$u].") - INDY Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["INDY Adult"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="Adult One Way" && $data_d["ADULT"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$u].") - Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["ADULT"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="Child One Way" && $data_d["CHILD"][$u]!=0)
                                {
                                    $Descp = "One Way Trip (".$data_d["Tour"][$u].") - Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u] . ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["CHILD"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                            }
                        }
                    }
                    elseif($data_d["One Way"][$u]!="true" && $data_d["PORT SCHED"][$u]=="S")
                    {
                        if($data_d["Tour"][$u] == "BUS SUMMIT")
                        {
                            for($r=0;$r<count($data_d["Product Name"]); $r++)
                            {
                                if($data_d["Product Name"][$r]=="Bus Summit Adult" && $data_d["ADULT"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["ADULT"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="Bus Summit Child" && $data_d["CHILD"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["CHILD"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                            }
                        }
                        elseif($data_d["Ship"][$u] == "INDE")
                        {
                            for($r=0;$r<count($data_d["Product Name"]); $r++)
                            {
                                if($data_d["Product Name"][$r]=="INDE Adult" && $data_d["ADULT"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["ADULT"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="INDE Child" && $data_d["CHILD"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["CHILD"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                            }
                        }
                        else
                        {
                            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 (".$data_d["Tour"][$u].") - INDY Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["INDY Child"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="INDY Adult"  && $data_d["INDY Adult"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - INDY Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["INDY Adult"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="Adult" && $data_d["ADULT"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - Adult- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["ADULT"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                                elseif($data_d["Product Name"][$r]=="Child" && $data_d["CHILD"][$u]!=0)
                                {
                                    $Descp = "Round Trip (".$data_d["Tour"][$u].") - Child- " .$data_d["List Price"][$r]. " " . $data_d["bDate"][$u] . "," . $data_d["Departure Time"][$u] . " ". $data_d["Ship"][$u]. ", ". $data_d["VOUCHER No"][$u];
                                    $Qty=$data_d["CHILD"][$u];
                                    $total=$Qty*$data_d["List Price"][$r];
                                    $subtotal+=$total;
                                    $products["Product Id"][$inc] = $data_d["PRODUCTID"][$r];
                                    $products["Quantity"][$inc] = $Qty;
                                    $products["Product Name"][$inc] = $data_d["Product Name"][$r];
                                    $products["Product Description"][$inc] = $Descp;
                                    $products["List Price"][$inc] = $data_d["List Price"][$r];
                                    $products["Net Total"][$inc] = $total;
                                    $products["Total"][$inc] = $total;
                                    $inc++;
                                }
                            }
                        }
                    }
                }
            }
            if (!empty($products))
            {
                $invdate=date("Y-m-d");
                $Startdate=$dates[0];
                $Enddate=$dates[count($dates)-1];
                $subj=$get_companys[0]."_INV_".$Startdate."_".$Enddate;
                $var = "[";
                for ($a = 0;$a<count($products["Product Id"]);$a++)
                {
                    $var.='{"Description":"'.$products["Product Description"][$a].'","Product_Name":"'.$products["Product Id"][$a].'","Quantity":"'.$products["Quantity"][$a].'","Net_Total":"'.$products["Net Total"][$a].'","Total":"'.$products["Total"][$a].'","List_Price":"'.$products["List Price"][$a].'"}';
                    if ($a != count($products["Product Id"]) - 1)
                    {
                        $var.=',';
                    }
                }
                $var .= "]";
            }
            else
            {
                $var = "";
                $invdate=date("Y-m-d");
                $Startdate=$dates[0];
                $Enddate=$dates[count($dates)-1];
                $subj=$get_companys[0]."_INV_".$Startdate."_".$Enddate;
            }
            $xml = '{
                "data": [
                    {
                        "Invoiced_Items": '.$var.',
                        "Grand_Total": "'.$subtotal.'",
                        "Invoice_Date": "'.$invdate.'",
                        "End_Date": "'.$Enddate.'",
                        "Account_Name": {
                            "id": "'.$data_d["Company_ID"].'"
                        },
                        "Start_Date": "'.$Startdate.'",
                        "Sub_Total": "'.$subtotal.'",
                        "Subject": "'.$subj.'",
                        
                    }
                ]
            }';
            $in=insert_Records("Invoices",$xml)	;
            if(isset($in["data"][0]))
            {
                $id=$in["data"][0]["details"]["id"];
                for($e=0;$e<count($data_d["up_ids"]);$e++)
                {
                    $xml= '{"data": [{"id": '.$data_d["up_ids"][$e].',"Invoice1": "'.$id.'"}]}';
                    $up=update_Records("Bookings",$xml);
                }
                Include("Create_invoice_csv.php");
                $up=upload_attachment("Invoices",$id, $filename);
                unlink($filename);
                $msg="Invoice ".$in["data"][0]["message"];
            }
            else
            {
                $msg="Invoice Not Created Suscessfully!!!";
            }
        }
    }
    else
    {
        $msg="There is no data found!!!";
    }
}
echo $msg;
?>