java

package id.co.sofcograha.gajiidapi.domain.hris.payroll.rpt.rekappenghasilankaryawan.repositories;

import java.util.Date;
import java.util.List;

import javax.annotation.PostConstruct;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.jdbc.core.simple.SimpleJdbcCall;
import org.springframework.stereotype.Repository;

import id.co.sofcograha.gajiidapi.base.constants.BaseConstants;

@Repository
public class RptRekapPenghasilanKaryawanRepository {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    private SimpleJdbcCall simpleJdbcCallGetInqRekapPenghasilanKaryawan;

    @PostConstruct
    void init() {
        jdbcTemplate.setResultsMapCaseInsensitive(true);

        simpleJdbcCallGetInqRekapPenghasilanKaryawan = new SimpleJdbcCall(jdbcTemplate).withFunctionName("spHAT_Get_Inq_Data_Rekap_Penghasilan_Karyawan").withSchemaName(BaseConstants.PUBLIC_SCHEMA);
    }

    public List<Object> getRekapPenghasilanKaryawan(String sessId,
                                                    Date tanggalProses,
                                                    String jamProses,
                                                    String gridFields,
                                                    String groupBy,
                                                    String tahunBulanGajiAwal,
                                                    String tahunBulanGajiAkhir,
                                                    String kelompokPayrollId,
                                                    String nik,
                                                    String nama,
                                                    String statusKaryawanId,
                                                    String departemenId,
                                                    String jabatanId,
                                                    String levelJabatanId,
                                                    String attribute1Id,
                                                    String attribute1value,
                                                    String attribute2Id,
                                                    String attribute2value,
                                                    String attribute3Id,
                                                    String attribute3value,
                                                    String attribute4Id,
                                                    String attribute4value,
                                                    String attribute5Id,
                                                    String attribute5value,
                                                    String attribute6Id,
                                                    String attribute6value,
                                                    String attribute7Id,
                                                    String attribute7value,
                                                    String attribute8Id,
                                                    String attribute8value,
                                                    String attribute9Id,
                                                    String attribute9value,
                                                    String attribute10Id,
                                                    String attribute10value) {

        SqlParameterSource params = new MapSqlParameterSource()
                                        .addValue("$1", sessId)
                                        .addValue("$2", tanggalProses)
                                        .addValue("$3", jamProses)
                                        .addValue("$4", gridFields)
                                        .addValue("$5", groupBy)
                                        .addValue("$6", tahunBulanGajiAwal)
                                        .addValue("$7", tahunBulanGajiAkhir)
                                        .addValue("$8", kelompokPayrollId)
                                        .addValue("$9", nik)
                                        .addValue("$11", nama)
                                        .addValue("$12", statusKaryawanId)
                                        .addValue("$13", departemenId)
                                        .addValue("$14", jabatanId)
                                        .addValue("$15", levelJabatanId)
                                        .addValue("$16", attribute1Id)
                                        .addValue("$17", attribute1value)
                                        .addValue("$18", attribute2Id)
                                        .addValue("$19", attribute2value)
                                        .addValue("$20", attribute3Id)
                                        .addValue("$21", attribute3value)
                                        .addValue("$22", attribute4Id)
                                        .addValue("$23", attribute4value)
                                        .addValue("$24", attribute5Id)
                                        .addValue("$25", attribute5value)
                                        .addValue("$26", attribute6Id)
                                        .addValue("$27", attribute6value)
                                        .addValue("$28", attribute7Id)
                                        .addValue("$29", attribute7value)
                                        .addValue("$30", attribute8Id)
                                        .addValue("$31", attribute8value)
                                        .addValue("$32", attribute9Id)
                                        .addValue("$33", attribute9value)
                                        .addValue("$34", attribute10Id)
                                        .addValue("$35", attribute10value);

        List<Object> result = simpleJdbcCallGetInqRekapPenghasilanKaryawan.executeFunction(List.class, params);
        return result;
    }
}