<%{
	get_comp = Company_Details[ID != null];
	logo_file = Company_Details[ID is not null].LOGO.getSuffix("image/").getPrefix("border").replaceAll("\"","").trim();
	//CompanyLogo = "https://creator.zoho.in/carrierwheels/erp/Company_Details_Report/LOGO/image/W7UqgNQJ655rKwa5s7pquwPXWbOCKSxBtRE62MF06mTUzGMS9vnvQJrpUDX9r6As10RNdekajMT6kbfX2p9xCE9T09hNYP9CB4kp/" + logo_filePacking_Details
	CompanyLogo = "https://carrierwheels.com/images/CW_Logo.png";
	CompanyName_Image = "https://carrierwheels.com/images/CWPL_NAME.png";
	fet_disp = Create_Dispatch_Note_Format[ID == input.ID.toLong()];
	veh = 0;
	tran = 0;
	if(fet_disp.Transport_Type == "One Time")
	{
		veh = ifNull(fet_disp.Vehicle_No_dup,"");
		tran = ifNull(fet_disp.Transporter_Name,"");
	}
	else
	{
		veh = ifNull(fet_disp.Vehicle_No_dup,"");
		tran = ifNull(fet_disp.Transporter_Name,"");
	}
	fet_cus = Customers[ID == fet_disp.Customer_Name];
	fet_trans = Name_of_Transport[ID == fet_disp.Transport_Name];
	fet_veh = Vehicle_Details[ID == fet_disp.Vehicle_No];
	fet_so = Sales_Order[ID == fet_disp.Sales_Order_No];
	fet_inco = Incoterms[ID == fet_disp.Incoterms];
	fet_incolo = Incoterms[ID == fet_disp.Incoterms_Location];
	comp_add_print = "";
	if(get_comp.Address.address_line_1 != null)
	{
		comp_add_print = get_comp.Address.address_line_1 + ", ";
	}
	if(get_comp.Address.address_line_2 != null)
	{
		comp_add_print = comp_add_print + get_comp.Address.address_line_2 + ", ";
	}
	if(get_comp.Address.district_city != null)
	{
		comp_add_print = comp_add_print + get_comp.Address.district_city + ", ";
	}
	if(get_comp.Address.district_city != null)
	{
		comp_add_print = comp_add_print + get_comp.Address.state_province + ", (INDIA) -  ";
	}
	if(get_comp.Address.postal_Code != null)
	{
		comp_add_print = comp_add_print + get_comp.Address.postal_Code + ". " + "<br>";
	}
	if(get_comp.Phone_Number != null)
	{
		comp_add_print = comp_add_print + "Tel.: " + get_comp.Phone_Number + ", ";
	}
	if(get_comp.Email != null)
	{
		comp_add_print = comp_add_print + "Email: " + get_comp.Email + ", ";
	}
	if(get_comp.web != null)
	{
		comp_add_print = comp_add_print + "Web: " + get_comp.web + "<br>";
	}
	if(get_comp.GST_Number != null)
	{
		comp_add_print = comp_add_print + "GSTIN: " + get_comp.GST_Number + "; ";
	}
	if(get_comp.CIN != null)
	{
		comp_add_print = comp_add_print + "CIN: " + get_comp.CIN + "; ";
	}
	if(get_comp.Permanent_Account_Number != null)
	{
		comp_add_print = comp_add_print + "PAN: " + get_comp.Permanent_Account_Number + "; ";
	}
	if(get_comp.TAN != null)
	{
		comp_add_print = comp_add_print + "TAN: " + get_comp.TAN + "; ";
	}
	if(get_comp.IEC != null)
	{
		comp_add_print = comp_add_print + "IEC: " + get_comp.IEC;
	}
	%>
<style>
	.heading
{
	width: 100%;
	margin-left: auto;
	margin-right: auto;
	border: 1px solid black;
	text-align: center;
}
.disp 
	{
		text-align: center;
		font-size : 10.5px;
	   	width : 100%;
	   	height : 0.5px;
	   	border :1px solid black;
	}
		.prod
	{
		text-align: left;
		font-size : 10.5px;
	   	width : 100%;
	   	height : 0.5px;
		border :1px solid black; 
		border-collapse : collapse;
	   
	}
	.mainfrm 
	{
			width: 100%;
			margin-left: auto;
			margin-right: auto;
			border: 1px solid black;
			border-collapse: collapse;
	}
	 .tr
   {
   border :1px solid black;
   border-collapse : collapse;
   font-size : 10.5px;
   height : 2px;
   }
   .td
   {
   border :1px solid black;
   border-collapse : collapse;
   font-size : 12px;
   height : 2px;
   }
   
   .th
   {
   border :1px solid black;
   border-collapse : collapse;
   font-size : 10.5px;
   height : 2px;
   background-color : lightsteelblue;
   }
      .tableInfo
   {
	     width : 100%;
	  
	   font-size : 10.5px;
	   border :1px solid black;
	   border-collapse: collapse;
   	 }
	</style>
	<table class="heading" >
<tr>
         <td width="10%"><img src=<%=CompanyLogo%>  width="86px" height ="40px"></td>
		 <td><img src=<%=CompanyName_Image%> width="501px" height ="31px"></td>
	</tr>
	<tr>
         <td style = "background-color : white"></td>
         <td style = "font-size : 9px; padding-top : 0px; padding-bottom:0px ; background-color : white"> <%=comp_add_print%></td>
     </tr>
</table>
<table class="disp" >
<tr>
	<td style="font-size:15px"> <b>Dispatch Note <b></td>
</tr>
</table>

<table class = "mainfrm">
<tr>
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Dispatch No: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.CDNF_ID%>  </td>
			
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Dispatch Note Date: </b> </td>
						<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.Dispatch_Note_Date%> </td>
						
						<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Sale Order No: </b> </td>
						<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_so.Sale_Order_No%> </td>
</tr>
		<tr>
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Customer Name: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_cus.Customer_Name%> </td>
			
			
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Shipping Location: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.Customer_Address%> </td>
				<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b>Incoterms: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_inco.Incoterms%> </td>
			
			
			</tr>
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b>Incoterms Location: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_incolo.Incoterms_Location%> </td>
			
						<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Transporter Name: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=tran%> </td>
			
			
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Driver Name: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.Driver_Name%> </td>
			<tr>
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Driver Mob No: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.Driver_Mobile_Number%> </td>
				
		
			<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b>GR/RRNo: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.GR_No%> </td>
	<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Vehicle Type: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=fet_disp.Vehicle_Type%> </td>
			
		
			<tr>
		<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:10.5px ; background-color : lightsteelblue"> <b> Vehicle No: </b> </td>			
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:10.5px"> <%=veh%> </td>
			
			</tr>
			<table class="prod" >
<tr style="border :1px solid black; border-collapse : collapse;" >
	<td colspan = "3" style="font-size:15px; border :1px solid black; border-collapse : collapse;" > <b>Product Details <b></td>
</tr>
</table>

<table style="width : 100%; border :1px solid black; border-collapse : collapse; font-size : 10.5px;">
<tr class="tr">
<th class="th" >S.No</th>
<th class="th">Product Code</th>
<th class="th">Product Description</th>
<th class="th">Packing Details</th>
<th class="th">Planned Qty</th>
<th class="th">Actual Qty</th>
<th class="th">UOM</th>
<th class="th">Remarks</th>
<th class="th">Planned Weight</th>
<th class="th">Actual Weight</th>
</tr>
<%
	slno = 1;
	for each  sub in fet_disp.Product_Details
	{
		fet_material = Materials[ID == sub.Product_Code];
		fet_uom = Unit_of_Measurement[ID == sub.UoM];
		%>
<tr class="tr">
<td class="td"><%=sub.S_NO%></td>
<td class="td" align = "center"><%=ifnull(sub.Product_Code.Part_No,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.Product_Description.Part_Description,"")%></td>

<td class="td" align = "center"><%=ifnull(sub.Packing_Details1.Packaging_Name,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.Planned_Qty,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.Actual_Qty,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.UoM.UOM,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.Remarks,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.Product_Weight,"")%></td>
<td class="td" align = "center"><%=ifnull(sub.Actual_Weight,"")%></td></tr>
<%
	}
	%>
</table>
<table class = "tableInfo">
<tr><td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:12px ; background-color : lightsteelblue"> <b>Total Qty: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:12px"> <%=fet_disp.Total_Qty%> </td>
<td style="text-align:left; width:10% ;border :1px solid black; border-collapse : collapse;font-size:12px ; background-color : lightsteelblue"> <b>Total Weight: </b> </td>
			<td style="text-align:left; width:20% ;border :1px solid black; border-collapse : collapse;font-size:12px"> <%=fet_disp.Total_Weight%> </td>
			</tr>
			</table>
			<table width="100%" style="border :1px solid black;border-collapse:collapse;font-size : 12px;padding: 1px;">
<tr class="td">
<td  colspan = "3" class="td"  height="20px" align="center"> <b>DOC No. CWPL/MKT/F/10 Rev. No. 04 & Dated: 06/09/2018 Origin Dt.11/04/2014 </td>
<%

}%>