@Override
  public void createSqlQuery() {
    String sqlWhere = "";
    String table = "";
    String columns = "";
    String innerJoin = "";
    String orderBy = "";
    STableSetting setting = null;

    for (int i = 0; i < mvTableSettings.size(); i++) {
      setting = (erp.lib.table.STableSetting) mvTableSettings.get(i);
      if (setting.getType() == STableConstants.SETTING_FILTER_DELETED
          && setting.getStatus() == STableConstants.STATUS_ON) {
        sqlWhere += (sqlWhere.length() == 0 ? "" : "AND ") + "d.b_del = FALSE ";
      }
    }

    switch (mnTabTypeAux01) {
      case SDataConstants.TRN_DNS_DPS:
        table = "trn_dns_dps ";
        columns = "c.ct_dps, l.cl_dps, t.tp_dps, ";
        innerJoin =
            "INNER JOIN erp.trns_ct_dps AS c ON "
                + "d.fid_ct_dps = c.id_ct_dps "
                + "INNER JOIN erp.trns_cl_dps AS l ON "
                + "d.fid_ct_dps = l.id_ct_dps AND d.fid_cl_dps = l.id_cl_dps "
                + "INNER JOIN erp.trnu_tp_dps AS t ON "
                + "d.fid_ct_dps = t.id_ct_dps AND d.fid_cl_dps = t.id_cl_dps AND d.fid_tp_dps = t.id_tp_dps ";
        orderBy =
            "ORDER BY c.id_ct_dps, c.ct_dps, l.id_cl_dps, l.cl_dps, t.id_tp_dps, t.tp_dps, d.dns, d.id_dns ";
        break;
      case SDataConstants.TRN_DNS_DIOG:
        table = "trn_dns_diog ";
        columns = "c.ct_iog, l.cl_iog, ";
        innerJoin =
            "INNER JOIN erp.trns_ct_iog AS c ON "
                + "d.fid_ct_iog = c.id_ct_iog "
                + "INNER JOIN erp.trns_cl_iog AS l ON "
                + "d.fid_ct_iog = l.id_ct_iog AND d.fid_cl_iog = l.id_cl_iog ";
        orderBy = "ORDER BY c.id_ct_iog, c.ct_iog, l.id_cl_iog, l.cl_iog, d.dns, d.id_dns ";
        break;
      default:
    }

    msSql =
        "SELECT d.id_dns, d.dns, d.b_del, "
            + columns
            + "d.ts_new, d.ts_edit, d.ts_del, un.usr, ue.usr, ud.usr "
            + "FROM "
            + table
            + "AS d "
            + innerJoin
            + "INNER JOIN erp.usru_usr AS un ON d.fid_usr_new = un.id_usr "
            + "INNER JOIN erp.usru_usr AS ue ON d.fid_usr_edit = ue.id_usr "
            + "INNER JOIN erp.usru_usr AS ud ON d.fid_usr_del = ud.id_usr "
            + (sqlWhere.length() == 0 ? "" : "WHERE " + sqlWhere)
            + orderBy;
  }
示例#2
0
  @Override
  public void createSqlQuery() {
    String sqlWhere = "";
    STableSetting setting = null;

    for (int i = 0; i < mvTableSettings.size(); i++) {
      setting = (erp.lib.table.STableSetting) mvTableSettings.get(i);
      if (setting.getType() == STableConstants.SETTING_FILTER_DELETED
          && setting.getStatus() == STableConstants.STATUS_ON) {
        sqlWhere += (sqlWhere.length() == 0 ? "" : "AND ") + "g.b_del = FALSE ";
      }
    }

    msSql =
        "SELECT g.num, g.des, t.turn, b.bp, g.* "
            + "FROM mfgu_gang AS g "
            + "INNER JOIN mfgu_gang_ety AS ge ON g.id_gang = ge.id_gang "
            + "INNER JOIN erp.mfgu_turn AS t ON g.fid_turn = t.id_turn "
            + "INNER JOIN erp.bpsu_bp AS b ON ge.fid_bp = b.id_bp "
            + (sqlWhere.length() == 0 ? "" : "WHERE " + sqlWhere)
            + "ORDER BY g.num, g.des, t.turn, b.bp ";
  }