package com.uas.eis.service.Impl;

import com.uas.eis.dao.*;
import com.uas.eis.entity.Employee;
import com.uas.eis.service.CommonService;
import com.uas.eis.utils.Constant;
import com.uas.eis.utils.DateUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;

@Service
public class CommonServiceImpl implements CommonService {
    @Autowired
    private BaseDao baseDao;

    @Override
    public void logSRecord(String code_, int keyvalue_) {
        baseDao.execute("insert into invoicedockLog(id_,code_,date_,result_,keyvalue_) values (invoicedockLog_seq.nextval,?,sysdate,'SUCCEED',?)",code_,keyvalue_);
    }
    @Override
    public void logSRecordBycon(String code_,String keyvalue_field,String logTab, String con) {
        baseDao.execute("insert into invoicedockLog(id_,code_,date_,result_,keyvalue_) " +
                "select invoicedockLog_seq.nextval,'"+code_+"',sysdate,'SUCCEED',id_ from ( select min("+keyvalue_field+") id_ from "+logTab+" where "+con+")");
    }
    @Override
    public void logFRecord(String code_, String err_, int keyvalue_) {
        baseDao.execute("insert into invoicedockLog(id_,code_,date_,result_,err_,keyvalue_) values (invoicedockLog_seq.nextval,?,sysdate,'FAILED',?,?)",code_,err_,keyvalue_);
    }
    @Override
    public void logFRecordBycon(String code_,String keyvalue_field,String logTab, String con, String err_) {
        baseDao.execute("insert into invoicedockLog(id_,code_,date_,result_,err_,keyvalue_) " +
                "select invoicedockLog_seq.nextval,'"+code_+"',sysdate,'FAILED','"+err_+"',id_ from ( select min("+keyvalue_field+") id_ from "+logTab+" where "+con+")");
    }
    @Override
    public int saveFilePath(String path, int size, String fileName, String emName) {
        int id = baseDao.getSeqId("EMAILFILEPATH");
        if (path.contains("\\")) {//上传到本地返回路径修改
            path = path.replace("\\", "/");
        }
        /**
         * 文件名含单引号无法下载*/
        fileName=fileName.replaceAll(",", "，");
        baseDao.execute("INSERT INTO filepath(fp_id,fp_path,fp_size,fp_man,fp_date,fp_name) values(" + id + ",'" + path + "'," + size
                + ",'"+emName+"'," + DateUtil.parseDateToOracleString(Constant.YMD_HMS, new Date()) + ",'" + fileName
                + "')");
        return id;
    }
}