showinfo.jsp

财务说明的管理

<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/IncludeBegin.jsp" %>

<%@ page import="com.hexiesoft.are.sql.ASResultSet" %>
<%@ page import="com.hexiesoft.utils.Consts" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook" %>
<%@ page import="com.hexiesoft.utils.StringUtils" %>

<%
    String blno = DataConvert.toRealString(iPostChange, CurPage.getParameter("blno"));
    String label2 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_2");
    String label3 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_3");
    String label4 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_4");

    String label5 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_5");
    String label6 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_6");
    String label7 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_7");
    String label8 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_8");
    String label9 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_9");
    String label10 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_10");
    String label11 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_11");
    String label12 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_12");
    String label13 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_13");
    String label14 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_14");
    String label15 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_15");
    String label16 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_16");
    String label17 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("LABEL_17");

    String alert3 = (String) Configure.getConfigure(sIe_Language, "VerifyCreditInvoice").get("ALERT_3");
%>
<%
    ASResultSet invRs;
    ASResultSet shipRs;
    ASResultSet cusRs;
    ASResultSet gloRs;
    float subtot = 0f;
    float invgst = 0f;
    float invamt = 0f;
    float declared = 0f;
    String islbs = "";
    String sql = "";
    sql = "select * from global ";
    gloRs = Sqlca.getASResultSet(sql);
    gloRs.first();

    sql = "select * from invoice where blno='" + blno + "'";
    invRs = Sqlca.getASResultSet(sql);
    invRs.first();

    sql = "select * from shipment where blno='" + blno + "'";
    shipRs = Sqlca.getASResultSet(sql);
    if (shipRs.first()) {
        if (shipRs.getString("islbs").equals("1")) {
            islbs = "lbs";
        } else {
            islbs = "kgs";
        }
    }

    sql = "select * from customer where account='" + invRs.getString("account") + "'  and subacct='" + invRs.getString("subacct") + "'";
    cusRs = Sqlca.getASResultSet(sql);
    cusRs.first();

    subtot = invRs.getFloat("collect") - invRs.getFloat("freight") + invRs.getFloat("otherfees") + invRs.getFloat("sundry");
    if ("C".equals(cusRs.getString("country"))) {
        invgst = ((int) subtot * gloRs.getFloat("gstrate")) / 100;
        declared = invRs.getFloat("invextend") * gloRs.getFloat("gstrate") / 100 + invRs.getFloat("invextend");
    } else {
        invgst = 0f;
        declared = invRs.getFloat("invextend");
    }
    invamt = subtot + invgst;

%>

<script language="javascript" src="<%=sResourcesPath%>/keyevent.js"></script>
<script language="javascript">
    function check()
    {
        var reason1 = '<%=invRs.getString("reason1")%>';
        var reason2 = '<%=invRs.getString("reason2")%>' ;
        var glacct = '<%=invRs.getString("glacct")%>';
        var sunreason1 = '<%=invRs.getString("sunreason1")%>';
        var sunreason2 = '<%=invRs.getString("sunreason2")%>';
        var blno = '<%=blno%>';
        var subtot = '<%=subtot%>';
        var invgst = '<%=invgst%>';
        var declared = '<%=declared%>';
        var invamt = '<%=invamt%>';
        var invdate = document.all.invdate.value;
        var prepaid = document.all.prepaid.value;
        var collect = ' <%=invRs.getFloat("collect")%>';
        var otherfees = document.all.otherfees.value;
        var ofees =<%=invRs.getFloat("otherfees")%>;
        if (ofees != 0) {
            reason1 = document.all.reason1.value;
            reason2 = document.all.reason2.value;
            glacct = document.all.glacct.value;
            if (reason1.length <= 0) {
                alert('<%=alert3%>');
                document.all.reason1.focus();
                return;
            }
        }

        var sundry = document.all.sundry.value;
        var sun =<%=(invRs.getFloat("sundry"))%>;
        if (sun != 0) {
            sunreason1 = document.all.sunreason1.value;
            sunreason2 = document.all.sunreason2.value;
        }
        var freight = document.all.freight.value;

        OpenComp("VerifyCreditInvoice", "/Billing/VerifyCreditInvoice/DoMark.jsp", "blno=" + blno + "&subtot=" + subtot
                + "&invgst=" + invgst + "&declared=" + declared + "&invamt=" + invamt + "&invdate=" + invdate + "&prepaid=" + prepaid
                + "&collect=" + collect + "&otherfees=" + otherfees + "&reason1=" + reason1 + "&reason2=" + reason2 + "&glacct=" + glacct
                + "&sundry=" + sundry + "&sunreason1=" + sunreason1 + "&sunreason2=" + sunreason2 + "&freight=" + freight + "&rand=" + randomNumber(), "right", "");
    }

</script>
<body bgcolor="#DCDCDC">
<table table border="1" width=100% align="center" bordercolor='#999999' bordercolordark='#FFFFFF'>
<tr>
    <td width="35%"><%=label2%>
        <input name="invdate" type="text" id="invdate" size="10" maxlength="10"
               value="<%=StringUtils.to_Date(invRs.getString("invdate"))%>"
               onKeyDown="DateInput()"></td>
    <td width="21%">&nbsp;</td>
    <td width="13%">&nbsp;</td>
    <td width="31%">&nbsp;</td>
</tr>
<tr>
    <td><%=invRs.getString("account") + "-" + invRs.getString("subacct")%>
    </td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
</tr>
<tr>
    <td><%=label3%> &nbsp;<%=invRs.getFloat("gross")%>&nbsp;<%=islbs%>
    </td>
    <td><%=label4%>&nbsp;<%=invRs.getFloat("net")%>&nbsp;<%=islbs%>
    </td>
    <td><%=label5%>
    </td>
    <td>&nbsp;<%=invRs.getFloat("invextend")%>
    </td>
</tr>
<tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><%=label6%>
    </td>
    <td>
        <input name="prepaid" type="text" id="prepaid" value="<%=invRs.getFloat("prepaid")%>" size="10"
               maxlength="10" onkeydown="MoneyInput()">CR
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("otherfees") != 0) {%><%=label15%><%}%></td>
    <td>&nbsp;</td>
    <td><%=label7%>
    </td>
    <td>
        <%=invRs.getFloat("collect")%>
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("otherfees") != 0) {%><input name="reason1" type="text" id="reason1" size="45"
                                                                value="<%=invRs.getString("reason1")%>">
        <%}%></td>
    <td>&nbsp;</td>
    <td><%=label8%>
    </td>
    <td>
        <input name="otherfees" type="text" id="otherfees" size="10" maxlength="10"
               value="<%=StringUtils.nullToEmpty(invRs.getFloat("otherfees"))%>" onkeydown="MoneyInput()"> CR
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("otherfees") != 0) {%><input name="reason2" type="text" id="reason2"
                                                                value="<%=StringUtils.nullToEmpty(invRs.getString("reason2"))%>"
                                                                size="45">
        <%}%></td>
    <td>&nbsp;</td>
    <td><%=label11%>
    </td>
    <td><%=subtot%>
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("otherfees") != 0) {%>      <%=label16%>
        <input name="glacct" type="text" id="glacct" onkeydown="MoneyInput()"
               value="<%=StringUtils.nullToEmpty(invRs.getString("glacct"))%>" size="8" maxlength="8">
        <%}%></td>
    <td>&nbsp;</td>
    <td><%=label12%>
    </td>
    <td><%=invgst%>
    </td>
</tr>
<tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><%=label13%>
    </td>
    <td><%=invamt%>
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("sundry") != 0) {%>
        <%=label17%>
        <%}%></td>
    <td>&nbsp;</td>
    <td><%=label9%>
    </td>
    <td><input name="sundry" type="text" id="sundry2" value="<%=invRs.getFloat("sundry")%>" size="10" maxlength="10"
               onkeydown="MoneyInput()"> CR
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("sundry") != 0) {%>
        <input name="sunreason1" type="text" id="sunreason1"
               value="<%=StringUtils.nullToEmpty(invRs.getString("sunreason1"))%>" size="45">
        <%}%></td>
    <td>&nbsp;</td>
    <td><%=label10%>
    </td>
    <td>
        <input name="freight" type="text" id="freight" value="<%=invRs.getFloat("freight")%>" size="10"
               maxlength="10" onkeydown="MoneyInput()">CR
    </td>
</tr>
<tr>
    <td>&nbsp;<%if (invRs.getFloat("sundry") != 0) {%>
        <input name="sunreason2" type="text" id="sunreason2"
               value="<%=StringUtils.nullToEmpty(invRs.getString("sunreason2"))%>" size="45">
        <%}%></td>
    <td>&nbsp;</td>
    <td><%=label14%>
    </td>
    <td><%=declared%>
    </td>
</tr>
</table>
<input type="button" name="next"
       value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("SUBMIT")%>"
       onClick="javascript:check()"
       style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC;  border-style: outset; border-top-width: 1px; border-right-width: 1px;  border-bottom-width: 1px; border-left-width: 1px"
       border='1'>
<input type="button" name="Cancel"
       value="<%=(String)Configure.getConfigure(sIe_Language,"Common").get("CANCEL")%>"
       onClick="javascript:OpenPage('/Blank.jsp?TextToShow=', 'right','');"
       style="font-size:9pt;padding-top:3;padding-left:5;padding-right:5;background-image:url(../../Resources/functionbg.gif); border: #DCDCDC;  border-style: outset; border-top-width: 1px; border-right-width: 1px;  border-bottom-width: 1px; border-left-width: 1px"
       border='1'>
</body>
<%@ include file="/IncludeEnd.jsp" %>