@Override public void createParamsMap() { SDataBizPartner bizPartnerCompany = null; String sSqlWhere = ""; String sSqlInnerIssue = ""; String sDepartamentsId = ""; String sDepartamentsName = ""; int payrollStatus = (int) moPanelHrsFilterPayrollStatus.getValue(SLibConsts.UNDEFINED); bizPartnerCompany = new SDataBizPartner(); bizPartnerCompany.read( new int[] {((SClientInterface) miClient).getSessionXXX().getCompany().getPkCompanyId()}, miClient.getSession().getStatement()); sDepartamentsId = (String) moPanelHrsDepartaments.getValue(SGuiConsts.PARAM_KEY); sDepartamentsName = (String) moPanelHrsDepartaments.getValue(SGuiConsts.PARAM_ITEM); moParamsMap = miClient.createReportParams(); sSqlWhere += moKeyEmployee.getSelectedIndex() > 0 ? " AND emp.id_emp = " + moKeyEmployee.getValue()[0] : ""; sSqlWhere += moKeyPaymentType.getSelectedIndex() > 0 ? " AND p.fk_tp_pay = " + moKeyPaymentType.getValue()[0] : ""; sSqlWhere += sDepartamentsId.isEmpty() ? "" : " AND dep.id_dep IN(" + sDepartamentsId + ") "; if (payrollStatus != SPanelHrsFilterPayrollStatus.STATUS_UNDEF) { if (payrollStatus == SPanelHrsFilterPayrollStatus.STATUS_CLOSE) { sSqlWhere += " AND p.b_clo = 1 "; } else if (payrollStatus == SPanelHrsFilterPayrollStatus.STATUS_OPEN) { sSqlWhere += " AND p.b_clo = 0 "; } } if (moRadFilterTypeDatePay.isSelected()) { sSqlInnerIssue = "INNER JOIN hrs_pay_rcp_iss AS rcp_iss ON rcp_iss.id_pay = rcp.id_pay AND rcp_iss.id_emp = rcp.id_emp "; } moParamsMap.put( "sTitle", "REPORTE DE PERCEPCIONES Y DEDUCCIONES" + (moRadIsSummary.isSelected() ? " (RESUMEN)" : " (DETALLE)")); if (moRadFilterTypePeriod.isSelected()) { moParamsMap.put("bByPeriod", true); moParamsMap.put("nPeriodYear", moIntPeriodYear.getValue()); moParamsMap.put("nPeriodStart", moIntPeriodStart.getValue()); moParamsMap.put("nPeriodEnd", moIntPeriodEnd.getValue()); sSqlWhere += " AND p.per_year = " + moIntPeriodYear.getValue() + " AND p.per BETWEEN " + moIntPeriodStart.getValue() + " AND " + moIntPeriodEnd.getValue() + " "; } else if (moRadFilterTypeDate.isSelected()) { moParamsMap.put("bByPeriod", false); moParamsMap.put("tDateStart", moDateDateStart.getValue()); moParamsMap.put("tDateEnd", moDateDateEnd.getValue()); sSqlWhere += " AND p.dt_sta >= '" + SLibUtils.DbmsDateFormatDate.format(moDateDateStart.getValue()) + "' AND p.dt_end <= '" + SLibUtils.DbmsDateFormatDate.format(moDateDateEnd.getValue()) + "' "; } else if (moRadFilterTypeDatePay.isSelected()) { moParamsMap.put("bByPeriod", false); moParamsMap.put("tDateStart", moDateDateStart.getValue()); moParamsMap.put("tDateEnd", moDateDateEnd.getValue()); sSqlWhere += "AND rcp_iss.dt_pay BETWEEN '" + SLibUtils.DbmsDateFormatDate.format(moDateDateStart.getValue()) + "' AND '" + SLibUtils.DbmsDateFormatDate.format(moDateDateEnd.getValue()) + "' AND rcp_iss.b_del = 0 AND rcp_iss.fk_st_rcp <> " + SModSysConsts.TRNS_ST_DPS_ANNULED + " "; } moParamsMap.put( "RegistroPatronal", ((SClientInterface) miClient).getSessionXXX().getParamsCompany().getRegistrySs()); moParamsMap.put("sEmiRfc", bizPartnerCompany.getFiscalId()); moParamsMap.put( "sEmployee", moKeyEmployee.getSelectedIndex() > 0 ? moKeyEmployee.getSelectedItem() : "(TODOS)"); moParamsMap.put( "sEarning", !moKeyEarning.isEnabled() ? "(TODAS)" : moKeyEarning.getSelectedIndex() > 0 ? moKeyEarning.getSelectedItem() : "(TODAS)"); moParamsMap.put( "sDeduction", !moKeyDeduction.isEnabled() ? "(TODAS)" : moKeyDeduction.getSelectedIndex() > 0 ? moKeyDeduction.getSelectedItem() : "(TODAS)"); moParamsMap.put( "sPaymentType", moKeyPaymentType.getSelectedIndex() > 0 ? moKeyPaymentType.getSelectedItem() : "(TODOS)"); moParamsMap.put( "sDepartaments", sDepartamentsName.isEmpty() || (boolean) moPanelHrsDepartaments.getValue(SGuiConsts.PARAM_ROWS) ? "(TODOS)" : sDepartamentsName + " "); moParamsMap.put("bIsEarDedOnly", moRadReportTypeEarDed.isSelected()); moParamsMap.put("bIsSummary", moRadIsSummary.isSelected()); moParamsMap.put("sColumnsEar", getColumSelect(1)); moParamsMap.put("sColumnsDed", getColumSelect(2)); moParamsMap.put("sSqlWhere", sSqlWhere); moParamsMap.put("sSqlInnerIssue", sSqlInnerIssue); if (moRadShowEarDed.isSelected()) { moParamsMap.put( "sSqlWhereEarning", moKeyEarning.getSelectedIndex() > 0 ? " AND ear.id_ear = " + moKeyEarning.getValue()[0] : ""); moParamsMap.put( "sSqlWhereDeduction", moKeyDeduction.getSelectedIndex() > 0 ? " AND ded.id_ded = " + moKeyDeduction.getValue()[0] : ""); } else { moParamsMap.put( "sSqlWhereEarning", !moKeyEarning.isEnabled() ? " AND ear.id_ear = 0 " : moKeyEarning.getSelectedIndex() > 0 ? " AND ear.id_ear = " + moKeyEarning.getValue()[0] : ""); moParamsMap.put( "sSqlWhereDeduction", !moKeyDeduction.isEnabled() ? " AND ded.id_ded = 0 " : moKeyDeduction.getSelectedIndex() > 0 ? " AND ded.id_ded = " + moKeyDeduction.getValue()[0] : ""); } if (moRadIsDetailPayroll.isSelected()) { mnFormType = SModConsts.HRSR_PAY_EAR_DED; moParamsMap.put("sSqlOrderBy", getOrderBy()); } else if (moRadIsDetailEmployee.isSelected()) { mnFormType = SModConsts.HRSR_PAY_AUX_EAR_DED; moParamsMap.put("bIsSummary", false); moParamsMap.put("bShowEmployees", true); moParamsMap.put( "sSqlOrderBy", "ORDER BY f_tp_ear_ded, f_ear_ded_id, f_ear_ded, id_dep, f_dep_code, f_dep_name, id_bp, f_emp_num, bp "); } }