@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 ");
}
}
