package com.uas.eis.task;

import com.uas.eis.dao.BaseDao;
import com.uas.eis.sdk.entity.ApiResult;
import com.uas.eis.service.ERPService;
import com.uas.eis.service.HQService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.scheduling.annotation.EnableAsync;
import org.springframework.scheduling.annotation.EnableScheduling;
import org.springframework.scheduling.annotation.Scheduled;
import org.springframework.stereotype.Component;

@Component
@EnableAsync
@EnableScheduling
public class HQPODataUploadTask {
    private final Logger logger = LoggerFactory.getLogger(this.getClass());
    @Autowired
    private BaseDao baseDao;
    @Autowired
    private HQService hqService;
    @Scheduled(cron = "0 0 0 * * ?")
    public void uploadHQPOPlan() {
        logger.info("uploadHQPOPlan-begin");
        String master = "N_HUASL_SZ";
        Integer vpId = baseDao.queryForObject("select max(vp_id) vp_id from "+master+".vendPurExecplan where vp_statuscode='AUDITED' and nvl(vp_remark,' ') not like '%测试%'",Integer.class);
        if(vpId!=null && vpId > 0){
            String emCode="TASK";
            String caller = "";
            ApiResult<String> apiResult = hqService.syncHQPOPlan(master,vpId,emCode,caller);
            System.out.println(apiResult.toString());
        }
        logger.info("uploadHQPOPlan-End:master {} id {}",master,vpId);
    }
}