Example usage for com.google.gson JsonObject addProperty

List of usage examples for com.google.gson JsonObject addProperty

Introduction

In this page you can find the example usage for com.google.gson JsonObject addProperty.

Prototype

public void addProperty(String property, Character value) 

Source Link

Document

Convenience method to add a char member.

Usage

From source file:account.ListBillsAdjsted.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from   w  w  w. j  a  v  a 2s  . c  o m
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String ac_cd = request.getParameter("ac_cd");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Library lb = Library.getInstance();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();

    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "SELECT doc_ref_no,dr_doc_cd,dr_inv_no,cr_doc_cd,cr_inv_no,amt,DR_DOC_REF_NO,CR_DOC_REF_NO FROM billadjst WHERE "
                    + " DR_DOC_REF_NO IN (SELECT doc_ref_no FROM oldb2_2 WHERE ac_cd='" + ac_cd + "') OR "
                    + " CR_DOC_REF_NO IN (SELECT doc_ref_no FROM oldb2_2 WHERE ac_cd='" + ac_cd + "')";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("DOC_REF_NO", viewDataRs.getString("DOC_REF_NO"));
                object.addProperty("DR_DOC_CD", viewDataRs.getString("DR_DOC_CD"));
                object.addProperty("CR_DOC_CD", viewDataRs.getString("CR_DOC_CD"));
                object.addProperty("DR_INV_NO", viewDataRs.getString("DR_INV_NO"));
                object.addProperty("CR_INV_NO", viewDataRs.getString("CR_INV_NO"));
                object.addProperty("TOT_AMT", viewDataRs.getString("AMT"));
                array.add(object);
            }

            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.MarginReport.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from   ww w. ja  v  a2s  .  c  o  m*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final String mode = request.getParameter("mode");
    final String sr_cd = request.getParameter("sr_cd");
    final String type_cd = request.getParameter("type_cd");
    final String brand_cd = request.getParameter("brnad_cd");
    final String model_cd = request.getParameter("model_cd");
    final int v_type = Integer.parseInt(request.getParameter("v_type"));
    final String branch_cd = request.getParameter("branch_cd");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    if (dataConnection != null) {
        try {
            String sql = "select v.branch_cd,TAG_NO,SR_NAME,BASIC_PUR_RATE AS PUR_RATE,SALE_RATE,b.BRAND_NAME,pur_ref_no,sale_ref_no from tag t left join "
                    + " SERIESMST s on t.sr_cd=s.sr_cd left join MODELMST m on s.model_cd=m.model_cd left join brandmst b on m.brand_cd=b.brand_cd"
                    + " left join VILSHD v on t.SALE_REF_NO = v.REF_NO " + " where v.v_date>='" + from_date
                    + "' and " + " v.v_date<='" + to_date + "'  and v.is_del=0 and t.is_del=1 ";

            if (mode.equalsIgnoreCase("1")) {
                sql += " and (PUR_RATE-SALE_RATE) <0";
            }

            if (v_type != 0) {
                sql += " and v.v_type =" + (v_type - 1);
            }

            if (mode.equalsIgnoreCase("2")) {
                sql += " and (PUR_RATE-SALE_RATE) =0";
            }

            if (mode.equalsIgnoreCase("3")) {
                sql += " and (PUR_RATE-SALE_RATE) >0";
            }

            if (!type_cd.equalsIgnoreCase("")) {
                sql += " and m.type_cd='" + type_cd + "' ";
            }
            if (!sr_cd.equalsIgnoreCase("")) {
                sql += " and s.SR_CD='" + sr_cd + "'";
            } else if (!brand_cd.equalsIgnoreCase("")) {
                sql += " and m.brand_cd='" + brand_cd + "'";
            } else if (!model_cd.equalsIgnoreCase("")) {
                sql += " and s.model_cd='" + model_cd + "'";
            }
            if (!branch_cd.equalsIgnoreCase("0")) {
                sql += " and v.branch_cd=" + branch_cd;
            }

            sql += " order by SR_NAME";
            //                String sql = "select t.TAG_NO,SR_NAME,PUR_RATE,SALE_RATE,b.BRAND_NAME from tag t left join "
            //                        + " SERIESMST s on t.sr_cd=s.sr_cd left join MODELMST m on s.model_cd=m.model_cd left join brandmst b on "
            //                        + "m.brand_cd=b.brand_cd left join vilshd v on t.sale_ref_no=v.ref_no  "
            //                        + " where v.v_date>='" + from_date + "' and "
            //                        + " v.v_date<='" + to_date + "' ";
            //                sql += " order by SR_NAME";
            PreparedStatement pstLocal = dataConnection.prepareStatement(sql);
            ResultSet rsLocal = pstLocal.executeQuery();
            JsonArray array = new JsonArray();
            while (rsLocal.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("TAG_NO", rsLocal.getString("TAG_NO"));
                object.addProperty("SR_NAME", rsLocal.getString("SR_NAME"));
                object.addProperty("PUR_RATE", rsLocal.getDouble("PUR_RATE"));
                object.addProperty("SALE_RATE", rsLocal.getDouble("SALE_RATE"));
                object.addProperty("PUR_REF_NO", rsLocal.getString("PUR_REF_NO"));
                object.addProperty("SALE_REF_NO", rsLocal.getString("SALE_REF_NO"));
                object.addProperty("branch_cd", rsLocal.getString("branch_cd"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.MarginReportByTag.java

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String tag_no = request.getParameter("tag_no");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    if (dataConnection != null) {
        try {//from  w  w  w. ja v a 2  s. c om
            String sql = "select t.branch_cd,TAG_NO,SR_NAME,PUR_RATE,SALE_RATE from tag t left join "
                    + " SERIESMST s on t.sr_cd=s.sr_cd " + " where t.tag_no='" + tag_no + "' and t.is_del=1 ";
            sql += " order by SR_NAME";
            PreparedStatement pstLocal = dataConnection.prepareStatement(sql);
            ResultSet rsLocal = pstLocal.executeQuery();
            JsonArray array = new JsonArray();
            while (rsLocal.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("TAG_NO", rsLocal.getString("TAG_NO"));
                object.addProperty("SR_NAME", rsLocal.getString("SR_NAME"));
                object.addProperty("PUR_RATE", rsLocal.getDouble("PUR_RATE"));
                object.addProperty("SALE_RATE", rsLocal.getDouble("SALE_RATE"));
                object.addProperty("branch_cd", rsLocal.getDouble("branch_cd"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.Phonebook.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*w w w  . java2s.c o m*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    final String group_cd = request.getParameter("grp_cd");
    final int v_type = Integer.parseInt(request.getParameter("v_type"));
    final boolean sales = Boolean.parseBoolean(request.getParameter("sales"));
    Library lb = Library.getInstance();
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            if (sales) {
                String sql = "select distinct(a.ac_cd),a.fname,concat(a1.add1,a1.add2,a1.add3) as address,(MOBILE1),email from VILSHD v "
                        + " left join acntmst a on v.ac_cd=a.ac_cd left join phbkmst p1 on p1.ac_cd=a.ac_cd left join adbkmst a1 on a1.ac_cd=a.ac_cd"
                        + " where v.IS_DEL=0 AND LENGTH(mobile1)>8 " + " and v.v_date>='" + from_date + "' "
                        + " and v.v_date<='" + to_date + "'";

                if (!group_cd.equalsIgnoreCase("")) {
                    sql += " and a.grp_cd='" + group_cd + "' ";
                }
                if (v_type != 2) {
                    sql += " and v.v_type=" + v_type;
                }

                pstLocal = dataConnection.prepareStatement(sql);
                ResultSet viewDataRs = pstLocal.executeQuery();

                JsonArray array = new JsonArray();
                while (viewDataRs.next()) {
                    JsonObject object = new JsonObject();
                    object.addProperty("fname", viewDataRs.getString("fname"));
                    object.addProperty("MOBILE1",
                            (viewDataRs.getString("MOBILE1") == null) ? "" : viewDataRs.getString("MOBILE1"));
                    object.addProperty("address",
                            (viewDataRs.getString("address") == null) ? "" : viewDataRs.getString("address"));
                    object.addProperty("EMAIL",
                            (viewDataRs.getString("EMAIL") == null) ? "" : viewDataRs.getString("EMAIL"));
                    array.add(object);
                }

                jResultObj.addProperty("result", 1);
                jResultObj.add("data", array);
            } else {
                String sql = "select distinct(a.ac_cd),a.fname,concat(a1.add1,a1.add2,a1.add3) as address,(MOBILE1),email from"
                        + " acntmst a left join phbkmst p1 on p1.ac_cd=a.ac_cd left join adbkmst a1 on a1.ac_cd=a.ac_cd"
                        + " where LENGTH(mobile1)>8 ";

                if (!group_cd.equalsIgnoreCase("")) {
                    sql += " and a.group_cd='" + group_cd + "' ";
                }

                pstLocal = dataConnection.prepareStatement(sql);
                ResultSet viewDataRs = pstLocal.executeQuery();

                JsonArray array = new JsonArray();
                while (viewDataRs.next()) {
                    JsonObject object = new JsonObject();
                    object.addProperty("fname", viewDataRs.getString("fname"));
                    object.addProperty("MOBILE1",
                            (viewDataRs.getString("MOBILE1") == null) ? "" : viewDataRs.getString("MOBILE1"));
                    object.addProperty("address",
                            (viewDataRs.getString("address") == null) ? "" : viewDataRs.getString("address"));
                    object.addProperty("EMAIL",
                            (viewDataRs.getString("EMAIL") == null) ? "" : viewDataRs.getString("EMAIL"));
                    array.add(object);
                }

                jResultObj.addProperty("result", 1);
                jResultObj.add("data", array);
            }
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        } finally {
            lb.closeConnection(dataConnection);
        }
    }
    response.getWriter().print(jResultObj);

}

From source file:account.PurchaseRateByTag.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from ww  w.  ja v  a2 s.c  o m*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String tag_no = request.getParameter("tag_no");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    if (dataConnection != null) {
        try {
            String sql = "select TAG_NO,SR_NAME,PUR_RATE from tag t left join "
                    + " SERIESMST s on t.sr_cd=s.sr_cd " + " where t.tag_no='" + tag_no + "' and t.is_del=0 ";
            sql += " order by SR_NAME";
            PreparedStatement pstLocal = dataConnection.prepareStatement(sql);
            ResultSet rsLocal = pstLocal.executeQuery();
            JsonArray array = new JsonArray();
            while (rsLocal.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("TAG_NO", rsLocal.getString("TAG_NO"));
                object.addProperty("SR_NAME", rsLocal.getString("SR_NAME"));
                object.addProperty("PUR_RATE", rsLocal.getDouble("PUR_RATE"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.PurchaseRegister.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from w  w w  .j  av a 2 s  .c  om*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    final int mode = Integer.parseInt(request.getParameter("mode"));
    final int branch_cd = Integer.parseInt(request.getParameter("branch_cd"));
    final int pmt_mode = Integer.parseInt(request.getParameter("pmt_mode"));
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "select v.branch_cd,v.REF_NO,v.V_TYPE,v.BILL_NO as INV_NO,a.FNAME,v.V_DATE,v.DET_TOT,v.TAX_AMT,v.ADD_TAX_AMT,v.NET_AMT  from "
                    + " LBRPHD v left join acntmst a on v.AC_CD=a.AC_CD where v_date >='" + from_date + "' "
                    + "and v_date <='" + to_date + "' and is_del=0 ";
            if (pmt_mode != 2) {
                sql += " and pmt_mode=" + pmt_mode;
            }
            if (branch_cd != 0) {
                sql += " and branch_cd=" + branch_cd;

            }
            if (mode != 2) {
                sql += " and v_type=" + mode;
            }
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("ref_no", viewDataRs.getString("REF_NO"));
                object.addProperty("v_type", viewDataRs.getString("V_TYPE"));
                object.addProperty("inv_no", viewDataRs.getString("inv_no"));
                object.addProperty("fname", viewDataRs.getString("FNAME"));
                object.addProperty("v_date", viewDataRs.getString("V_DATE"));
                object.addProperty("det_tot", viewDataRs.getString("DET_TOT"));
                object.addProperty("tax_amt", viewDataRs.getString("TAX_AMT"));
                object.addProperty("add_tax_amt", viewDataRs.getString("ADD_TAX_AMT"));
                object.addProperty("net_amt", viewDataRs.getString("NET_AMT"));
                object.addProperty("branch_cd", viewDataRs.getString("branch_cd"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.PurchaseRegisterDetail.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from   ww  w  . j a va 2  s.  c o m*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final String ac_cd = request.getParameter("ac_cd");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    final int mode = Integer.parseInt(request.getParameter("mode"));
    final int branch_cd = Integer.parseInt(request.getParameter("branch_cd"));
    final int pmt_mode = Integer.parseInt(request.getParameter("pmt_mode"));
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "select v1.tag_no,v.ref_no,case when v.V_TYPE=0 then 'RD Purchae' when v.v_type=1 then 'URD Purchase'end as v_type,"
                    + " v.INV_NO,v.V_DATE,v.PMT_MODE,"
                    + " case when a.FNAME is null then '' else fname end as fname,s.SR_ALIAS,s.SR_NAME,v1.IMEI_NO,"
                    + " v1.SERAIL_NO,v1.QTY,v1.RATE,v1.BASIC_AMT,v1.TAX_AMT,v1.ADD_TAX_AMT,v1.DISC_RATE,v1.MRP,v1.AMT,v.NET_AMT,p.CASH_AMT,"
                    + " p.BANK_AMT,p.CARD_AMT,p.bajaj_amt,v.DET_TOT,v.branch_cd,v1.NLC,"
                    + " t.TAX_NAME from LBRPHD v left join LBRPDT v1 on v.REF_NO =v1.REF_NO "
                    + " left join acntmst a on v.AC_CD=a.AC_CD left join SERIESMST s on s.SR_CD=v1.SR_CD left join PAYMENT p on v.REF_NO=p.REF_NO "
                    + " left join TAXMST t on v1.TAX_CD=t.TAX_CD where v_date >='" + from_date
                    + "' and is_del=0 and v.v_date <='" + to_date + "'";
            if (!ac_cd.equalsIgnoreCase("")) {
                sql += " and v.ac_cd='" + ac_cd + "' ";
            }
            if (pmt_mode != 2) {
                sql += " and v.pmt_mode=" + pmt_mode;
            }
            if (mode != 3) {
                sql += " and v.v_type=" + mode;
            }

            if (branch_cd != 0) {
                sql += " and v.branch_cd=" + branch_cd;
            }
            sql += " order by v.V_DATE,v.INV_NO,v1.tag_no,v1.is_main desc";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("ref_no", viewDataRs.getString("REF_NO"));
                object.addProperty("tag_no", viewDataRs.getString("tag_no"));
                object.addProperty("v_type", viewDataRs.getString("V_TYPE"));
                object.addProperty("inv_no", viewDataRs.getString("inv_no"));
                object.addProperty("fname", viewDataRs.getString("FNAME"));
                object.addProperty("SR_ALIAS", viewDataRs.getString("SR_ALIAS"));
                object.addProperty("SR_NAME", viewDataRs.getString("SR_NAME"));
                object.addProperty("IMEI_NO", viewDataRs.getString("IMEI_NO"));
                object.addProperty("SERAIL_NO", viewDataRs.getString("SERAIL_NO"));
                object.addProperty("v_date", viewDataRs.getString("V_DATE"));
                object.addProperty("QTY", viewDataRs.getInt("QTY"));
                object.addProperty("RATE", viewDataRs.getDouble("RATE"));
                object.addProperty("BASIC_AMT", viewDataRs.getDouble("BASIC_AMT"));
                object.addProperty("tax_amt", viewDataRs.getDouble("TAX_AMT"));
                object.addProperty("add_tax_amt", viewDataRs.getDouble("ADD_TAX_AMT"));
                object.addProperty("DISC_RATE", viewDataRs.getDouble("DISC_RATE"));
                object.addProperty("MRP", viewDataRs.getDouble("MRP"));
                object.addProperty("AMT", viewDataRs.getDouble("AMT"));
                object.addProperty("det_tot", viewDataRs.getDouble("DET_TOT"));
                object.addProperty("CASH_AMT", viewDataRs.getDouble("CASH_AMT"));
                object.addProperty("BANK_AMT", viewDataRs.getDouble("BANK_AMT"));
                object.addProperty("CARD_AMT", viewDataRs.getDouble("CARD_AMT"));
                object.addProperty("net_amt", viewDataRs.getDouble("NET_AMT"));
                object.addProperty("tax_name", viewDataRs.getString("tax_name"));
                object.addProperty("bajaj_amt", viewDataRs.getDouble("bajaj_amt"));
                object.addProperty("branch_cd", viewDataRs.getDouble("branch_cd"));
                object.addProperty("NLC", viewDataRs.getDouble("NLC"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.PurchaseRegisterDetailAccount.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//www  . jav a2 s.c  o  m
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final String ac_cd = request.getParameter("ac_cd");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    final int mode = Integer.parseInt(request.getParameter("mode"));
    final int branch_cd = Integer.parseInt(request.getParameter("branch_cd"));
    final int pmt_mode = Integer.parseInt(request.getParameter("pmt_mode"));
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "select v.ref_no,case when v.V_TYPE=0 then 'RD Purchase' when v.v_type=1 then 'URD Purchase' end as v_type,v.INV_NO,"
                    + "v.V_DATE,v.PMT_MODE,v1.DISC_RATE,v1.MRP,"
                    + " case when a.FNAME is null then '' else fname end as fname,s.SR_ALIAS,s.SR_NAME,v1.IMEI_NO,v.branch_cd,"
                    + " v1.SERAIL_NO,v1.QTY,v1.RATE,v1.AMT,v.DET_TOT,v1.TAX_AMT,v1.ADD_TAX_AMT,v.NET_AMT,p.CASH_AMT,p.BANK_AMT,p.CARD_AMT,p.bajaj_amt"
                    + ",t.TAX_NAME"
                    + " ,v1.basic_amt from LBRPHD v left join LBRPDT v1 on v.REF_NO =v1.REF_NO left join acntmst a on v.AC_CD=a.AC_CD "
                    + " left join SERIESMST s on s.SR_CD=v1.SR_CD left join PAYMENT p on v.REF_NO=p.REF_NO   left join TAXMST t on v1.TAX_CD=t.TAX_CD "
                    + " where v_date >='" + from_date + "' " + " and is_del=0 and v.v_date <='" + to_date + "'";
            if (!ac_cd.equalsIgnoreCase("")) {
                sql += " and v.ac_cd='" + ac_cd + "' ";
            }
            if (pmt_mode != 2) {
                sql += " and v.pmt_mode=" + pmt_mode;
            }
            if (mode != 2) {
                sql += " and v.v_type=" + mode;
            }

            if (branch_cd != 0) {
                sql += " and v.branch_cd=" + branch_cd;
            }
            sql += " order by v.V_DATE,v.INV_NO,v1.tag_no,v1.is_main desc";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("ref_no", viewDataRs.getString("REF_NO"));
                object.addProperty("v_type", viewDataRs.getString("V_TYPE"));
                object.addProperty("inv_no", viewDataRs.getString("inv_no"));
                object.addProperty("v_date", viewDataRs.getString("V_DATE"));
                object.addProperty("fname", viewDataRs.getString("FNAME"));
                object.addProperty("SR_ALIAS", viewDataRs.getString("SR_ALIAS"));
                object.addProperty("SR_NAME", viewDataRs.getString("SR_NAME"));
                object.addProperty("IMEI_NO", viewDataRs.getString("IMEI_NO"));
                object.addProperty("SERAIL_NO", viewDataRs.getString("SERAIL_NO"));
                object.addProperty("QTY", viewDataRs.getInt("QTY"));
                object.addProperty("RATE", viewDataRs.getDouble("RATE"));
                object.addProperty("DISC_RATE", viewDataRs.getDouble("DISC_RATE"));
                object.addProperty("MRP", viewDataRs.getDouble("MRP"));
                object.addProperty("AMT", viewDataRs.getDouble("AMT"));
                object.addProperty("BASIC_ITEM_AMT", viewDataRs.getDouble("basic_amt"));
                object.addProperty("det_tot", viewDataRs.getDouble("DET_TOT"));
                object.addProperty("tax_amt", viewDataRs.getDouble("TAX_AMT"));
                object.addProperty("add_tax_amt", viewDataRs.getDouble("ADD_TAX_AMT"));
                object.addProperty("CASH_AMT", viewDataRs.getDouble("CASH_AMT"));
                object.addProperty("BANK_AMT", viewDataRs.getDouble("BANK_AMT"));
                object.addProperty("CARD_AMT", viewDataRs.getDouble("CARD_AMT"));
                object.addProperty("net_amt", viewDataRs.getDouble("NET_AMT"));
                object.addProperty("tax_name", viewDataRs.getString("tax_name"));
                object.addProperty("bajaj_amt", viewDataRs.getDouble("bajaj_amt"));
                object.addProperty("branch_cd", viewDataRs.getDouble("branch_cd"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.PurchaseReturnRegister.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//w ww .  j  av a 2  s  .co m
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    final int branch_cd = Integer.parseInt(request.getParameter("branch_cd"));
    final int pmt_mode = Integer.parseInt(request.getParameter("pmt_mode"));
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "select v.branch_cd,v.REF_NO,v.V_TYPE,v.inv_no,a.FNAME,v.V_DATE,v.DET_TOT,v.TAX_AMT,v.ADD_TAX_AMT,v.NET_AMT  from "
                    + " PRHD v left join acntmst a on v.AC_CD=a.AC_CD where v_date >='" + from_date + "' "
                    + "and v_date <='" + to_date + "' and is_del=0 ";
            if (pmt_mode != 2) {
                sql += " and pmt_mode=" + pmt_mode;
            }
            if (branch_cd != 0) {
                sql += " and branch_cd=" + branch_cd;

            }
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("ref_no", viewDataRs.getString("REF_NO"));
                object.addProperty("v_type", viewDataRs.getString("V_TYPE"));
                object.addProperty("inv_no", viewDataRs.getString("inv_no"));
                object.addProperty("fname", viewDataRs.getString("FNAME"));
                object.addProperty("v_date", viewDataRs.getString("V_DATE"));
                object.addProperty("det_tot", viewDataRs.getString("DET_TOT"));
                object.addProperty("tax_amt", viewDataRs.getString("TAX_AMT"));
                object.addProperty("add_tax_amt", viewDataRs.getString("ADD_TAX_AMT"));
                object.addProperty("net_amt", viewDataRs.getString("NET_AMT"));
                object.addProperty("branch_cd", viewDataRs.getString("branch_cd"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}

From source file:account.PurchaseReturnRegisterAccount.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from  w w w  .j  a  v  a 2s .  co m*/
 *
 * @param request servlet request
 * @param response servlet response
 * @throws ServletException if a servlet-specific error occurs
 * @throws IOException if an I/O error occurs
 */
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    final String from_date = request.getParameter("from_date");
    final String to_date = request.getParameter("to_date");
    final String ac_cd = request.getParameter("ac_cd");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    final int branch_cd = Integer.parseInt(request.getParameter("branch_cd"));
    final int pmt_mode = Integer.parseInt(request.getParameter("pmt_mode"));
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "select v.ref_no,'Purchase Return' as v_type,v.INV_NO,"
                    + "v.V_DATE,v.PMT_MODE,v1.DISC_RATE,v1.MRP,"
                    + " case when a.FNAME is null then '' else fname end as fname,s.SR_ALIAS,s.SR_NAME,v1.IMEI_NO,v.branch_cd,"
                    + " v1.SERAIL_NO,v1.QTY,v1.RATE,v1.AMT,v.DET_TOT,v1.TAX_AMT,v1.ADD_TAX_AMT,v.NET_AMT,p.CASH_AMT,p.BANK_AMT,p.CARD_AMT,p.bajaj_amt"
                    + ",t.TAX_NAME"
                    + " ,v1.basic_amt from PRHD v left join PRDT v1 on v.REF_NO =v1.REF_NO left join acntmst a on v.AC_CD=a.AC_CD "
                    + " left join SERIESMST s on s.SR_CD=v1.SR_CD left join PAYMENT p on v.REF_NO=p.REF_NO   left join TAXMST t on v1.TAX_CD=t.TAX_CD "
                    + " where v_date >='" + from_date + "' " + " and is_del=0 and v.v_date <='" + to_date + "'";
            if (!ac_cd.equalsIgnoreCase("")) {
                sql += " and v.ac_cd='" + ac_cd + "' ";
            }
            if (pmt_mode != 2) {
                sql += " and v.pmt_mode=" + pmt_mode;
            }
            if (branch_cd != 0) {
                sql += " and v.branch_cd=" + branch_cd;
            }
            sql += " order by v.V_DATE,v.INV_NO,v1.tag_no,v1.is_main desc";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("ref_no", viewDataRs.getString("REF_NO"));
                object.addProperty("v_type", viewDataRs.getString("V_TYPE"));
                object.addProperty("inv_no", viewDataRs.getString("inv_no"));
                object.addProperty("v_date", viewDataRs.getString("V_DATE"));
                object.addProperty("fname", viewDataRs.getString("FNAME"));
                object.addProperty("SR_ALIAS", viewDataRs.getString("SR_ALIAS"));
                object.addProperty("SR_NAME", viewDataRs.getString("SR_NAME"));
                object.addProperty("IMEI_NO", viewDataRs.getString("IMEI_NO"));
                object.addProperty("SERAIL_NO", viewDataRs.getString("SERAIL_NO"));
                object.addProperty("QTY", viewDataRs.getInt("QTY"));
                object.addProperty("RATE", viewDataRs.getDouble("RATE"));
                object.addProperty("DISC_RATE", viewDataRs.getDouble("DISC_RATE"));
                object.addProperty("MRP", viewDataRs.getDouble("MRP"));
                object.addProperty("AMT", viewDataRs.getDouble("AMT"));
                object.addProperty("BASIC_ITEM_AMT", viewDataRs.getDouble("basic_amt"));
                object.addProperty("det_tot", viewDataRs.getDouble("DET_TOT"));
                object.addProperty("tax_amt", viewDataRs.getDouble("TAX_AMT"));
                object.addProperty("add_tax_amt", viewDataRs.getDouble("ADD_TAX_AMT"));
                object.addProperty("CASH_AMT", viewDataRs.getDouble("CASH_AMT"));
                object.addProperty("BANK_AMT", viewDataRs.getDouble("BANK_AMT"));
                object.addProperty("CARD_AMT", viewDataRs.getDouble("CARD_AMT"));
                object.addProperty("net_amt", viewDataRs.getDouble("NET_AMT"));
                object.addProperty("tax_name", viewDataRs.getString("tax_name"));
                object.addProperty("bajaj_amt", viewDataRs.getDouble("bajaj_amt"));
                object.addProperty("branch_cd", viewDataRs.getDouble("branch_cd"));
                array.add(object);
            }
            jResultObj.addProperty("result", 1);
            jResultObj.addProperty("Cause", "success");
            jResultObj.add("data", array);
        } catch (SQLNonTransientConnectionException ex1) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", "Server is down");
        } catch (SQLException ex) {
            jResultObj.addProperty("result", -1);
            jResultObj.addProperty("Cause", ex.getMessage());
        }
    }
    response.getWriter().print(jResultObj);
}