package com.consum.base.service.impl;

import java.util.List;
import java.util.Map;

import jakarta.annotation.PostConstruct;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
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.Service;

import com.walker.jdbc.service.BaseServiceImpl;

/**
 * @ClassName LWhGoodsRecordDetailsService
 * @Date 2023/10/31
 * @Description
 * @Version 1.0
 **/
@Service
public class LWhGoodsRecordDetailsService extends BaseServiceImpl {
    private final JdbcTemplate jdbcTemplate;
    private SimpleJdbcCall simpleJdbcCall;

    @Value("${spring.datasource.dataBaseName}")
    private String dataBaseName;

    @PostConstruct
    public void init() {
        this.simpleJdbcCall = new SimpleJdbcCall(jdbcTemplate).withCatalogName(dataBaseName)
            .withProcedureName("insert_WH_GOODS_RECORD_DETAILS");
    }

    @Autowired
    public LWhGoodsRecordDetailsService(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public void sameGoodsInsertMore(List<Long> outGoodsId, long whGoodsRecordId, short thisType) {
        SqlParameterSource in = new MapSqlParameterSource().addValue("WHGOODSIDList", StringUtils.join(outGoodsId, ","))
            .addValue("WH_GOODS_RECORD_ID", whGoodsRecordId).addValue("THIS_TYPE", thisType);
        Map<String, Object> out = simpleJdbcCall.execute(in);
        System.out.println("Procedure result: " + out);
    }

}