<%{
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>
<%
}%>