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

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

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;
import id.co.sofcograha.gajiidapi.base.utils.QueryUtil;
import id.co.sofcograha.gajiidapi.base.utils.TimeUtil;
import id.co.sofcograha.gajiidapi.domain.hris.payroll.rpt.detailperhitunganlemburkaryawan.entities.RptDetailPerhitunganLemburKaryawan;

@Repository
public class RptDetailPerhitunganLemburKaryawanRepository {

    @Autowired private JdbcTemplate jdbcTemplate;

    private SimpleJdbcCall simpleJdbcCallPerhitunganLembur;

    @PostConstruct
    void init() {
        jdbcTemplate.setResultsMapCaseInsensitive(true);
        simpleJdbcCallPerhitunganLembur = new SimpleJdbcCall(jdbcTemplate)
                                                .withFunctionName("spHpyPerhitunganLembur")
                                                .withSchemaName(BaseConstants.PUBLIC_SCHEMA);
    }

    @SuppressWarnings("unchecked")
    public List<RptDetailPerhitunganLemburKaryawan> hitungLembur(String sessId,
                                                                 Date tanggalProses,
                                                                 String jamProses,
                                                                 String bulanGaji,
                                                                 String kelompokPayrollId,
                                                                 String nik,
                                                                 String namaKaryawan) {

        SqlParameterSource params = new MapSqlParameterSource()
                                        .addValue("$1", sessId)
                                        .addValue("$2", TimeUtil.convertDatetoSQLDateString(tanggalProses))
                                        .addValue("$3", jamProses)
                                        .addValue("$4", bulanGaji)
                                        .addValue("$5", kelompokPayrollId)
                                        .addValue("$6", !QueryUtil.isAll(nik) ? nik : "")
                                        .addValue("$7", !QueryUtil.isAll(namaKaryawan) ? namaKaryawan : "");

        Map<String, Object> out = simpleJdbcCallPerhitunganLembur.execute(params);

        if (out == null) {
            return new ArrayList<RptDetailPerhitunganLemburKaryawan>();
        } else {
            return (List<RptDetailPerhitunganLemburKaryawan>) out.get("returnvalue");
        }
    }
}