<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <%@ include file="../Connections/con_ro_mnsl.jsp" %> <% String commodity="&&"; String Applicable="&&"; String rn__MMColParam = "1"; if (request.getParameter("serv") !=null) {rn__MMColParam = delim((String)request.getParameter("serv")) ;} %> <% String rn__MMsort = "exp2,ic desc,com,lpnm,dpnm"; if (request.getParameter("sort") !=null) {rn__MMsort = delim((String)request.getParameter("sort"));} %> <% String rn__MMlp = "1"; if (request.getParameter("lp00") !=null) {rn__MMlp = delim((String)request.getParameter("lp00"));} %> <% String rn__MMdp = "1"; if (request.getParameter("dp00") !=null) {rn__MMdp = delim((String)request.getParameter("dp00"));} %> <% String rn__MMcomm = "1"; if (request.getParameter("comm") !=null) {rn__MMcomm = delim((String)request.getParameter("comm"));} %> <% String Query_rate=""; Query_rate= "select * from dbo.getcomRates('A','"+rn__MMColParam+"','"+rn__MMlp+"','"+rn__MMdp+"','%','"+rn__MMcomm+"','1','%','%') order by "+rn__MMsort; %> <% Driver Driverrn = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrn = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrn = Connrn.prepareStatement(Query_rate,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrn.setFetchSize(0); Statementrn.setQueryTimeout(0); ResultSet rn = Statementrn.executeQuery(); boolean rn_isEmpty = !rn.next(); boolean rn_hasData = !rn_isEmpty; Object rn_data; int rn_numRows = 0; %> <% Driver Driverrs = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrs = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrs = Connrs.prepareStatement("SELECT * FROM dbo.view_services where zz=1 order by nm",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrs.setFetchSize(0); Statementrs.setQueryTimeout(0); ResultSet rs = Statementrs.executeQuery(); boolean rs_isEmpty = !rs.next(); boolean rs_hasData = !rs_isEmpty; Object rs_data; int rs_numRows = 0; %> <% Driver Driverrc = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrc = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrc = Connrc.prepareStatement("SELECT * FROM dbo.view_commodity where ic='Y' and zz=1 order by cm",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrc.setFetchSize(0); Statementrc.setQueryTimeout(0); ResultSet rc = Statementrc.executeQuery(); boolean rc_isEmpty = !rc.next(); boolean rc_hasData = !rc_isEmpty; Object rc_data; int rc_numRows = 0; %> <% Driver Driverrp = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrp = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrp = Connrp.prepareStatement("SELECT * FROM dbo.view_ports where zz=1 order by pn",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrp.setFetchSize(0); Statementrp.setQueryTimeout(0); ResultSet rp = Statementrp.executeQuery(); boolean rp_isEmpty = !rp.next(); boolean rp_hasData = !rp_isEmpty; Object rp_data; int rp_numRows = 0; %> <% int Repeat1__numRows = 15; int Repeat1__index = 0; rn_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int rn_first = 1; int rn_last = 1; int rn_total = -1; if (rn_isEmpty) { rn_total = rn_first = rn_last = 0; } //set the number of rows displayed on this page if (rn_numRows == 0) { rn_numRows = 1; } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (rn_total == -1) { // count the total records by iterating through the recordset for (rn_total = 1; rn.next(); rn_total++); // reset the cursor to the beginning rn.close(); rn = Statementrn.executeQuery(); rn_hasData = rn.next(); // set the number of rows displayed on this page if (rn_numRows < 0 || rn_numRows > rn_total) { rn_numRows = rn_total; } // set the first and last displayed record rn_first = Math.min(rn_first, rn_total); rn_last = Math.min(rn_first + rn_numRows - 1, rn_total); } %> <% String MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables ResultSet MM_rs = rn; int MM_rsCount = rn_total; int MM_size = rn_numRows; String MM_uniqueCol = ""; MM_paramName = ""; int MM_offset = 0; boolean MM_atTotal = false; boolean MM_paramIsDefined = (MM_paramName.length() != 0 && request.getParameter(MM_paramName) != null); %> <% // *** Move To Record: handle 'index' or 'offset' parameter if (!MM_paramIsDefined && MM_rsCount != 0) { //use index parameter if defined, otherwise use offset parameter String r = request.getParameter("index"); if (r==null) r = request.getParameter("offset"); if (r!=null) MM_offset = Integer.parseInt(r); // if we have a record count, check if we are past the end of the recordset if (MM_rsCount != -1) { if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last if (MM_rsCount % MM_size != 0) // last page not a full repeat region MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } //move the cursor to the selected record int i; for (i=0; rn_hasData && (i < MM_offset || MM_offset == -1); i++) { rn_hasData = MM_rs.next(); } if (!rn_hasData) MM_offset = i; // set MM_offset to the last possible record } %> <% // *** Move To Record: if we dont know the record count, check the display range if (MM_rsCount == -1) { // walk to the end of the display range for this page int i; for (i=MM_offset; rn_hasData && (MM_size < 0 || i < MM_offset + MM_size); i++) { rn_hasData = MM_rs.next(); } // if we walked off the end of the recordset, set MM_rsCount and MM_size if (!rn_hasData) { MM_rsCount = i; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; } // if we walked off the end, set the offset based on page size if (!rn_hasData && !MM_paramIsDefined) { if (MM_offset > MM_rsCount - MM_size || MM_offset == -1) { //check if past end or last if (MM_rsCount % MM_size != 0) //last page has less records than MM_size MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } // reset the cursor to the beginning rn.close(); rn = Statementrn.executeQuery(); rn_hasData = rn.next(); MM_rs = rn; // move the cursor to the selected record for (i=0; rn_hasData && i < MM_offset; i++) { rn_hasData = MM_rs.next(); } } %> <% // *** Move To Record: update recordset stats // set the first and last displayed record rn_first = MM_offset + 1; rn_last = MM_offset + MM_size; if (MM_rsCount != -1) { rn_first = Math.min(rn_first, MM_rsCount); rn_last = Math.min(rn_last, MM_rsCount); } // set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount); %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters String MM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone=""; String[] MM_removeList = { "index", MM_paramName }; // create the MM_keepURL string if (request.getQueryString() != null) { MM_keepURL = '&' + request.getQueryString(); for (int i=0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) { int start = MM_keepURL.indexOf(MM_removeList[i]) - 1; if (start >= 0 && MM_keepURL.charAt(start) == '&' && MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') { int stop = MM_keepURL.indexOf('&', start + 1); if (stop == -1) stop = MM_keepURL.length(); MM_keepURL = MM_keepURL.substring(0,start) + MM_keepURL.substring(stop); } } } // add the Form variables to the MM_keepForm string if (request.getParameterNames().hasMoreElements()) { java.util.Enumeration items = request.getParameterNames(); while (items.hasMoreElements()) { String nextItem = (String)items.nextElement(); boolean found = false; for (int i=0; !found && i < MM_removeList.length; i++) { if (MM_removeList[i].equals(nextItem)) found = true; } if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) { MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem)); } } } String tempStr = ""; for (int i=0; i < MM_keepURL.length(); i++) { if (MM_keepURL.charAt(i) == '<') tempStr = tempStr + "<"; else if (MM_keepURL.charAt(i) == '>') tempStr = tempStr + ">"; else if (MM_keepURL.charAt(i) == '"') tempStr = tempStr + """; else tempStr = tempStr + MM_keepURL.charAt(i); } MM_keepURL = tempStr; tempStr = ""; for (int i=0; i < MM_keepForm.length(); i++) { if (MM_keepForm.charAt(i) == '<') tempStr = tempStr + "<"; else if (MM_keepForm.charAt(i) == '>') tempStr = tempStr + ">"; else if (MM_keepForm.charAt(i) == '"') tempStr = tempStr + """; else tempStr = tempStr + MM_keepForm.charAt(i); } MM_keepForm = tempStr; // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length() > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1); %> <% // *** Move To Record: set the strings for the first, last, next, and previous links String MM_moveFirst,MM_moveLast,MM_moveNext,MM_movePrev; String MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves String MM_moveParam = "index="; // if the page has a repeated region, remove 'offset' from the maintained parameters if (MM_size > 1) { MM_moveParam = "offset="; int start = MM_keepMove.indexOf(MM_moveParam); if (start != -1 && (start == 0 || MM_keepMove.charAt(start-1) == '&')) { int stop = MM_keepMove.indexOf('&', start); if (start == 0 && stop != -1) stop++; if (stop == -1) stop = MM_keepMove.length(); if (start > 0) start--; MM_keepMove = MM_keepMove.substring(0,start) + MM_keepMove.substring(stop); } } // set the strings for the move to links StringBuffer urlStr = new StringBuffer(request.getRequestURI()).append('?').append(MM_keepMove); if (MM_keepMove.length() > 0) urlStr.append('&'); urlStr.append(MM_moveParam); MM_moveFirst = urlStr + "0"; MM_moveLast = urlStr + "-1"; MM_moveNext = urlStr + Integer.toString(MM_offset+MM_size); MM_movePrev = urlStr + Integer.toString(Math.max(MM_offset-MM_size,0)); %> <%! public String DoDateTime(java.lang.Object aObject,int nNamedFormat,java.util.Locale aLocale) throws Exception{ if ((aObject != null) && (aObject instanceof java.util.Date)){ if (aLocale!=null){ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat,aLocale); return df.format(aObject); } else{ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat); return df.format(aObject); } } return ""; } %> MNSL Cargo Tariff Calculator
Freight Calculator

 
Service  
Cargo  
Load Port  
Dest Port  
     
<%if (!rn_isEmpty){%> <%}%> <% while (rn_hasData) { %> <%if("Y".equals((String)(((rn_data = rn.getObject("ic"))==null || rn.wasNull())?"":rn_data))&&!commodity.equals((String)(((rn_data = rn.getObject("com"))==null || rn.wasNull())?"":rn_data))){ commodity=(String)(((rn_data = rn.getObject("com"))==null || rn.wasNull())?"":rn_data); %> <%}%> <% String temp=(String)(((rn_data = rn.getObject("ic"))==null || rn.wasNull())?"":rn_data)+(String)(((rn_data = rn.getObject("exp2"))==null || rn.wasNull())?"":rn_data); String temp2=(String)(((rn_data = rn.getObject("ic"))==null || rn.wasNull())?"":rn_data); if(!temp.equals(Applicable)&&temp2.equals("N")){ %> <%} Applicable=(String)(((rn_data = rn.getObject("ic"))==null || rn.wasNull())?"":rn_data)+(String)(((rn_data = rn.getObject("exp2"))==null || rn.wasNull())?"":rn_data); %> <% rn_hasData = rn.next(); } %> <%if (!rn_isEmpty){%> <%}%>
<% if (!rn_isEmpty ) { %> <% int pagefirstrecord=0; int pagelastrecord=0; int MM_PASS_VAR=0; int selectedpage=1; int totalpages=rn_total/Repeat1__numRows; totalpages=((totalpages*Repeat1__numRows!=rn_total)?totalpages+1:totalpages); if (request.getParameter("offset") !=null) {MM_PASS_VAR =Integer.parseInt(request.getParameter("offset")) ;} if(MM_PASS_VAR<-1) MM_PASS_VAR=0; if(MM_PASS_VAR==-1||MM_PASS_VAR>=rn_total) { selectedpage=totalpages; pagefirstrecord=Repeat1__numRows*selectedpage; if(pagefirstrecord>rn_total) pagefirstrecord=rn_total; pagelastrecord=rn_total; } else { selectedpage=MM_PASS_VAR/Repeat1__numRows; pagefirstrecord=Repeat1__numRows*selectedpage+1; if(selectedpage==totalpages) { pagelastrecord=rn_total; }else{ pagelastrecord=pagefirstrecord+Repeat1__numRows-1; } } pagefirstrecord=(pagefirstrecord>rn_total)?rn_total:pagefirstrecord; pagelastrecord=(pagelastrecord>rn_total)?rn_total:pagelastrecord; %> Showing [<%=pagefirstrecord%>-<%=pagelastrecord%>] of <%=(rn_total)%> Rate(s) <% } /* end !rn_isEmpty */ %> <% if (rn_isEmpty && request.getParameter("lp00") !=null && request.getParameter("dp00") !=null && request.getParameter("serv") !=null && request.getParameter("comm") !=null ) { %> Search returned no Rates <% } /* end rn_isEmpty */ %> <%=(rn_isEmpty&&(request.getParameter("lp00") ==null||request.getParameter("dp00") ==null||request.getParameter("serv") ==null||request.getParameter("comm") ==null))?"Select the Required Service, Cargo & Ports":""%>
Service commodity LP DP Rate Unit
<%=(((rn_data = rn.getObject("com"))==null || rn.wasNull())?"":rn_data)%>

Other Applicable Charges on [<%=(((rn_data = rn.getObject("ssn"))==null || rn.wasNull())?"":rn_data)%>] and [<%=(((rn_data = rn.getObject("lpcd"))==null || rn.wasNull())?"":rn_data)%>] - [<%=(((rn_data = rn.getObject("dpcd"))==null || rn.wasNull())?"":rn_data)%>] combination
<%=(((rn_data = rn.getObject("ssn"))==null || rn.wasNull())?"":rn_data)%> <%=(((rn_data = rn.getObject("com"))==null || rn.wasNull())?"":rn_data)%> /<%=(((rn_data = rn.getObject("cont"))==null || rn.wasNull())?"":rn_data)%>/<%=(((rn_data = rn.getObject("laden"))==null || rn.wasNull())?"":rn_data)%> <%=(((rn_data = rn.getObject("lpnm"))==null || rn.wasNull())?"":rn_data)%> <%=(((rn_data = rn.getObject("dpnm"))==null || rn.wasNull())?"":rn_data)%> <%=(((rn_data = rn.getObject("ccy"))==null || rn.wasNull())?"":rn_data)%> <%=(((rn_data = rn.getObject("rt"))==null || rn.wasNull())?"":rn_data)%> <%=(((rn_data = rn.getObject("run"))==null || rn.wasNull())?"":rn_data)%>

 

For all Machineries & Vehicles, please direct enquiries to respective Agent(s) or Below addresss


Maldives National Shipping Limited
Ship Plaza, 2nd Floor, 1/6 Orchid Magu,
Male’, Rep. of Maldives,
Tel: (960) 3323871, Fax: (960) 3324323,
E-mail: male@maldiveshipping.com.mv

 

Sales inquiries:


Tel: (960) 3323871, Fax: (960) 3324323,
E-mail: mlesales@maldiveshipping.com
 

 
<%@ include file="../footer.jsp" %>
<%@ include file="../_notice.jsp" %> <% rn.close(); Statementrn.close(); Connrn.close(); %> <% rs.close(); Statementrs.close(); Connrs.close(); %> <% rc.close(); Statementrc.close(); Connrc.close(); %> <% rp.close(); Statementrp.close(); Connrp.close(); %>