package org.jleaf.erp.sls.bo.customer;

import java.util.List;

import javax.persistence.Query;

import org.jleaf.common.entity.User;
import org.jleaf.core.AbstractBusinessFunction;
import org.jleaf.core.BusinessFunction;
import org.jleaf.core.Dto;
import org.jleaf.core.GeneralConstants;
import org.jleaf.core.annotation.Info;
import org.jleaf.core.annotation.InfoIn;
import org.jleaf.core.annotation.InfoOut;
import org.jleaf.core.dao.CriteriaHelper;
import org.jleaf.core.dao.QueryBuilder;
import org.jleaf.erp.master.dao.PartnerDao;
import org.jleaf.erp.master.entity.Partner;
import org.jleaf.erp.master.entity.PartnerAddress;
import org.jleaf.erp.master.entity.PartnerCp;
import org.jleaf.erp.master.entity.PartnerType;
import org.jleaf.erp.sls.SalesConstants;
import org.jleaf.erp.sls.entity.PolicyCustomerGroupBrand;
import org.jleaf.erp.sls.entity.UserPartner;
import org.jleaf.util.DtoUtil;
import org.jleaf.util.ValidationUtil;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 *
 * @author Ephraim Jehudah, April 09, 2020
 *
 **/

//@formatter:off
@Service
@InfoIn(value = {
    @Info(name = "userLoginId", description = "user Login Id", type = Long.class),
    @Info(name = "tenantLoginId", description = "tenant Login Id", type = Long.class),
    @Info(name = "roleLoginId", description = "roleLoginId", type = Long.class),
    @Info(name = "datetime", description = "datetime", type = String.class),
    @Info(name = "customerId", description = "customer Id", type = Long.class),
    @Info(name = "statusPiutang", description = "status Piutang", type = String.class),
    @Info(name = "apiKey", description = "apiKey", type = String.class),
})
@InfoOut(value = {
    @Info(name = "saldoPiutangList", description = "saldoPiutangList (invoiceDocNo,invoiceDocDate, invoiceDueDate, sisaPiutang, statusPiutang)", type = List.class)
})
//@formatter:on
public class GetSaldoPiutangListByCustomer extends AbstractBusinessFunction implements BusinessFunction {
    private static final Logger log = LoggerFactory.getLogger(GetSaldoPiutangListByCustomer.class);

    @Autowired
    PartnerDao partnerDao;

    @Override
    public String getDescription() {
        return "GetSaldoPiutangListByCustomer";
    }

    @SuppressWarnings("unchecked")
    @Override
    public Dto execute(Dto inputDto) throws Exception {
        log.info("Input BF {} -. {} ", inputDto);

        ValidationUtil.valDtoContainsKey(inputDto, "userLoginId");
        ValidationUtil.valDtoContainsKey(inputDto, "tenantLoginId");
        ValidationUtil.valDtoContainsKey(inputDto, "roleLoginId");
        ValidationUtil.valDtoContainsKey(inputDto, "datetime");

        Long customerId = inputDto.getLong("customerId");
        String statusPiutang = inputDto.getString("statusPiutang");

        Dto outputDto = null;
        List<Object[]> result = null;


        // jumlah key pada list harus sama dengan jumlah kolom yang diselect
        outputDto = new Dto();
        outputDto.putList("saldoPiutangList", DtoUtil.createDtoListFromArray(result,
        "invoiceDocNo","invoiceDocDate", "invoiceDueDate", "sisaPiutang", "statusPiutang"));

        log.debug("Output BF {} -. {} ", this.getClass(), outputDto);

        return outputDto;
    }

}