Example usage for com.google.gson JsonObject add

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

  1. HOME
  2. Java
  3. com.google.gson
  4. com.google.gson.*
  5. JsonObject
  6. add

Introduction

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

Prototype

public void add(String property, JsonElement value)

Source Link

Document

Adds a member, which is a name-value pair, to self.

Usage

From source file:account.PurchaseRegisterDetailAccount.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from   ww  w . ja v a 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 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.//from   www .  ja  v  a  2s .com
 *
 * @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./* w w  w . ja v a2  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 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);
}

From source file:account.PurchaseReturnRegisterDetail.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from  ww  w  . j a  v a2 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 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,"
                    + " 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,"
                    + " t.TAX_NAME 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("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"));
                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.PurchaseReturnTax.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//w  w w.  j  a va 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 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();
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "SELECT v.v_date,v.INV_NO,a.FNAME,a.TIN,t.TAX_NAME,sum(v1.BASIC_AMT) AS basic,sum(v1.tax_amt) AS tax,sum(v1.ADD_TAX_AMT) AS add_tax,sum(v1.DISC_RATE) AS disc,sum(v1.AMT) AS amt \n"
                    + "FROM PRHD v LEFT JOIN PRDT v1 ON v.REF_NO=v1.REF_NO LEFT JOIN seriesmst s ON v1.SR_CD=s.sr_cd LEFT JOIN modelmst m ON s.MODEL_CD=m.MODEL_CD\n"
                    + "LEFT JOIN taxmst t ON m.TAX_CD=t.TAX_CD LEFT JOIN acntmst a ON v.AC_CD=a.AC_CD\n"
                    + "WHERE  v.IS_DEL=0 and v_date >='" + from_date + "' " + "and v_date <='" + to_date
                    + "' group by v.v_date,v.inv_no,a.fname,a.tin,t.tax_name ORDER BY v.inv_no";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("v_date", viewDataRs.getString("v_date"));
                object.addProperty("INV_NO", viewDataRs.getString("INV_NO"));
                object.addProperty("FNAME", viewDataRs.getString("FNAME"));
                object.addProperty("TIN", viewDataRs.getString("TIN"));
                object.addProperty("TAX_NAME", viewDataRs.getString("TAX_NAME"));
                object.addProperty("basic", viewDataRs.getString("basic"));
                object.addProperty("tax", viewDataRs.getString("tax"));
                object.addProperty("add_tax", viewDataRs.getString("add_tax"));
                object.addProperty("disc", viewDataRs.getString("disc"));
                object.addProperty("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.SalesRegister.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods./*from  w  ww.  j a v a  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 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.ins_amt,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 "
                    + " VILSHD 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"));
                object.addProperty("ins_amt", viewDataRs.getDouble("ins_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.SalesRegisterDetail.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from  w  w  w .  j  a  v  a  2s.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 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.ins_amt,v.ref_no,case when v.V_TYPE=0 then 'Retail Invoice' when v.v_type=1 then 'Tax Invoice'"
                    + " else 'Retail Insurace Bill' 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,"
                    + " t.TAX_NAME ,v.BUY_BACK_MODEL,v.BUY_BACK_AMT from VILSHD v left join VILSDT 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("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("buy_back_model", viewDataRs.getString("buy_back_model"));
                object.addProperty("ins_amt", viewDataRs.getDouble("ins_amt"));
                object.addProperty("buy_back_amt", viewDataRs.getDouble("buy_back_amt"));
                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.SalesRegisterDetailAccount.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//  w w 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 b.brand_name,v.ref_no,case when v.V_TYPE=0 then 'Retail Invoice' when v.v_type=1 then 'Tax Invoice'"
                    + " else 'Retail Insurace Bill' 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"
                    + ",INS_AMT,t.TAX_NAME"
                    + " ,v1.basic_amt,v.BUY_BACK_MODEL,v.BUY_BACK_AMT from VILSHD v left join VILSDT 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 modelmst m on s.model_cd=m.model_cd left join brandmst b on m.brand_cd=b.brand_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("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("buy_back_model", viewDataRs.getString("buy_back_model"));
                object.addProperty("ins_amt", viewDataRs.getDouble("ins_amt"));
                object.addProperty("buy_back_amt", viewDataRs.getDouble("buy_back_amt"));
                object.addProperty("bajaj_amt", viewDataRs.getDouble("bajaj_amt"));
                object.addProperty("branch_cd", viewDataRs.getDouble("branch_cd"));
                object.addProperty("brand_name", viewDataRs.getString("brand_name"));
                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.SalesReport.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//from  ww  w  .j a v  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();
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "SELECT v.v_date,t.TAX_NAME,SUM(v1.BASIC_AMT) AS basic,SUM(v1.tax_amt) AS tax,SUM(v1.ADD_TAX_AMT) AS add_tax,SUM(v1.DISC_RATE) AS disc,SUM(v1.AMT) AS amt \n"
                    + "FROM vilshd v LEFT JOIN vilsdt v1 ON v.REF_NO=v1.REF_NO LEFT JOIN seriesmst s ON v1.SR_CD=s.sr_cd LEFT JOIN modelmst m ON s.MODEL_CD=m.MODEL_CD\n"
                    + "LEFT JOIN taxmst t ON m.TAX_CD=t.TAX_CD\n"
                    + "WHERE v_type <> 1 AND v.IS_DEL=0 and v_date >='" + from_date + "' " + "and v_date <='"
                    + to_date + "' and is_del=0 GROUP BY v.V_DATE,t.TAX_NAME ORDER BY v.V_DATE";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("v_date", viewDataRs.getString("v_date"));
                object.addProperty("TAX_NAME", viewDataRs.getString("TAX_NAME"));
                object.addProperty("basic", viewDataRs.getString("basic"));
                object.addProperty("tax", viewDataRs.getString("tax"));
                object.addProperty("add_tax", viewDataRs.getString("add_tax"));
                object.addProperty("disc", viewDataRs.getString("disc"));
                object.addProperty("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.SalesReportAccount.java

/**
 * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
 * methods.//  w w  w .j  av a2  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 String ac_cd = request.getParameter("ac_cd");
    final DBHelper helper = DBHelper.GetDBHelper();
    final Connection dataConnection = helper.getConnMpAdmin();
    final JsonObject jResultObj = new JsonObject();
    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 String branch_cd = request.getParameter("branch_cd");
    if (dataConnection != null) {
        try {

            PreparedStatement pstLocal = null;
            String sql = "SELECT v.v_date,v.V_TYPE,v.INV_NO,b.BRAND_NAME,m.MODEL_NAME,s.SR_NAME,v1.MRP,v.INS_AMT,v.branch_cd,v1.TAG_NO,"
                    + " (SELECT SUM(sale_rate) FROM tag WHERE tag_no=v1.tag_no) as rate  FROM vilshd v "
                    + " LEFT JOIN vilsdt v1 ON v.REF_NO=v1.REF_NO LEFT JOIN seriesmst s ON v1.SR_CD=s.SR_CD "
                    + " LEFT JOIN acntmst a ON a.ac_cd=v.AC_CD LEFT JOIN modelmst m ON s.MODEL_CD=m.MODEL_CD "
                    + " LEFT JOIN brandmst b ON b.BRAND_CD=m.BRAND_CD WHERE v.IS_DEL=0 and s.sr_cd not in('S000050','S000047') "
                    + " and v.v_date>='" + from_date + "' " + " and v.v_date<='" + to_date + "'  ";
            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 (!ac_cd.equalsIgnoreCase("")) {
                sql += " and v.ac_cd='" + ac_cd + "'";
            }
            if (!branch_cd.equalsIgnoreCase("0")) {
                sql += " and v.branch_cd=" + branch_cd;
            }
            sql += " order by v.branch_cd";
            pstLocal = dataConnection.prepareStatement(sql);
            ResultSet viewDataRs = pstLocal.executeQuery();

            JsonArray array = new JsonArray();
            while (viewDataRs.next()) {
                JsonObject object = new JsonObject();
                object.addProperty("INV_NO",
                        (viewDataRs.getString("inv_no") == null) ? "" : viewDataRs.getString("inv_no"));
                object.addProperty("V_TYPE",
                        (viewDataRs.getString("v_type") == null) ? "" : viewDataRs.getString("v_type"));
                object.addProperty("BRAND_NAME",
                        (viewDataRs.getString("BRAND_NAME") == null) ? "" : viewDataRs.getString("BRAND_NAME"));
                object.addProperty("MODEL_NAME",
                        (viewDataRs.getString("MODEL_NAME") == null) ? "" : viewDataRs.getString("MODEL_NAME"));
                object.addProperty("SR_NAME",
                        (viewDataRs.getString("sr_name") == null) ? "" : viewDataRs.getString("sr_name"));
                object.addProperty("MRP",
                        (viewDataRs.getString("rate") == null) ? 0.00 : viewDataRs.getDouble("rate"));
                object.addProperty("INS_AMT",
                        (viewDataRs.getString("INS_AMT") == null) ? 0.00 : viewDataRs.getDouble("INS_AMT"));
                object.addProperty("V_DATE",
                        (viewDataRs.getString("v_date") == null) ? "" : viewDataRs.getString("v_date"));
                object.addProperty("TAG_NO",
                        (viewDataRs.getString("TAG_NO") == null) ? "" : viewDataRs.getString("TAG_NO"));
                object.addProperty("branch_cd",
                        (viewDataRs.getString("branch_cd") == null) ? "" : 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);

}