package com.product.contract.service;

import com.product.common.lang.StringUtils;
import com.product.contract.config.CmnConst;
import com.product.contract.service.ide.IContractInvoiceService;
import com.product.core.dao.BaseDao;
import com.product.core.entity.DataTableEntity;
import com.product.core.entity.FieldSetEntity;
import com.product.core.exception.BaseException;
import com.product.core.permission.PermissionService;
import com.product.core.service.support.AbstractBaseService;
import com.product.core.service.support.QueryFilterService;
import com.product.core.spring.context.SpringMVCContextHolder;
import com.product.core.transfer.Transactional;
import com.product.util.BaseUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import java.util.Date;

/**
 * Copyright LX
 * @Title: ContractInvoiceService
 * @Project: product-server
 * @date: 2021-06-29 11:24
 * @author: ZhouJie
 * @Description: 合同开票
 */
@Component
public class ContractInvoiceService extends AbstractBaseService implements IContractInvoiceService {

    @Autowired
    public BaseDao baseDao;
    @Autowired
    PermissionService permissionService;
    @Autowired
    QueryFilterService queryFilterService;

    /**
     * 保存合同开票
     * @param fs
     * @return
     */
    @Override
    @Transactional
    public String saveContractInvoice(FieldSetEntity fs) {
        if(StringUtils.isEmpty(fs.getString(CmnConst.UUID))){
            fs.setValue("created_by", SpringMVCContextHolder.getCurrentUser().getUser_id());
            fs.setValue("org_level_uuid", SpringMVCContextHolder.getCurrentUser().getOrg_level_uuid());
            fs.setValue("created_utc_datetime",new Date());
            String add = baseDao.add(fs, true);
            writeBackInvoice(fs);
            return add;
        } else {
            fs.setValue("updated_by", SpringMVCContextHolder.getCurrentUser().getUser_id());
            fs.setValue("updated_utc_datetime",new Date());
            baseDao.update(fs);
            writeBackInvoice(fs);
            return fs.getString(CmnConst.UUID);
        }
    }

    /**
     * 回写回款金额到合同
     * @param fs
     */
   private void  writeBackInvoice(FieldSetEntity fs){
       //按照条款回写到合同子表
       DataTableEntity subDataTable = fs.getSubDataTable(CmnConst.LX_PROJECT_CONTRACT_INVOICE_INFO);
       for (int i = 0; i <subDataTable.getRows() ; i++) {
           FieldSetEntity fsData = subDataTable.getFieldSetEntity(i);
           FieldSetEntity fsinvo = baseDao.getFieldSetEntityByFilter(CmnConst.LX_PROJECT_CONTRACT_INVOICE_INFO,"contract_terms=?",new Object[]{fsData.getString("contract_terms")},false);

           FieldSetEntity contractTerms = baseDao.getFieldSetEntityBySQL("SELECT sum(invoice_amount) invoice_amount FROM product_project_contract_invoice_info where contract_terms=?   GROUP BY contract_terms", new Object[]{fsData.getString("contract_terms")}, false);

           Double invoiced_amount = contractTerms.getDouble("invoice_amount");//已开票金额
           //回写已开票金额到合同子表
           FieldSetEntity fcosub = new FieldSetEntity();
           if(fsinvo!=null){
               fcosub.setTableName(CmnConst.LX_PROJECT_CONTRACT_INFO_SUB);
               fcosub.setValue("uuid",fsData.getString("contract_terms"));
               fcosub.setValue("invoice_amount",invoiced_amount);//已开票金额
               baseDao.update(fcosub);
           }
       }
       //按照合同回写到合同主表
       FieldSetEntity invoice_amount_fs = baseDao.getFieldSetEntityBySQL("SELECT sum(invoice_amount) invoice_amount FROM product_project_contract_invoice_info \n" +
               "where contract_invoice_uuid in (SELECT uuid FROM product_project_contract_invoice where contract_name=?)", new Object[]{fs.getString("contract_name")}, false);
       if(invoice_amount_fs!=null) {
           FieldSetEntity invoiceFs = new FieldSetEntity();
           invoiceFs.setTableName(CmnConst.LX_PROJECT_CONTRACT_INFO);
           invoiceFs.setValue("uuid",fs.getString("contract_name"));
           invoiceFs.setValue("invoice_amount",invoice_amount_fs.getString("invoice_amount"));//已开票金额
           baseDao.update(invoiceFs);
       }
   }
    /**
     * 删除合同开票
     * @param fs
     * @return
     */
    @Override
    @Transactional
    public boolean deleteContractInvoice(FieldSetEntity fs) {
        String uuid = fs.getUUID();
        String[] uuids = uuid.split(",");
        return baseDao.delete(CmnConst.LX_PROJECT_CONTRACT_INVOICE, BaseUtil.buildQuestionMarkFilter(CmnConst.UUID, uuids.length, true), uuids);
    }

    /**
     * 合同开票列表
     * @param fs
     * @return
     */
    public DataTableEntity listContractInvoice(FieldSetEntity fs) {
        String queryFilter=permissionService.getDataFilter(CmnConst.ORG_LEVEL_UUID);
        if(StringUtils.isEmpty(queryFilter)) {
            queryFilter = CmnConst.CREATED_BY + " = " + SpringMVCContextHolder.getCurrentUser().getUser_id();
        }
        if(!BaseUtil.dataTableIsEmpty(fs.getSubDataTable("systemSeniorQueryString"))){
            queryFilter	= queryFilter +" AND "+ queryFilterService.getQueryFilter(fs);
        }
        String filter = fs.getString("filter") + " AND " + queryFilter;
        DataTableEntity dt = baseDao.listTable(CmnConst.LX_PROJECT_CONTRACT_INVOICE,filter,new Object[]{},null,null,fs.getInteger(CmnConst.PAGESIZE), fs.getInteger(CmnConst.CPAGE));
        baseDao.loadPromptData(dt);
        return dt;
    }
    /**
     * 查询合同开票详情
     * @param fs
     * @return
     * @throws BaseException
     */
    public FieldSetEntity findContractInvoice(FieldSetEntity fs) throws BaseException {
        return baseDao.getFieldSetEntity(CmnConst.LX_PROJECT_CONTRACT_INVOICE,fs.getUUID(),true);
    }
    /**
     * 根据开票号获取发票金额
     * @param fs
     * @return
     * @throws BaseException
     */
    public FieldSetEntity getInvoiceAmountByTerms(FieldSetEntity fs) throws BaseException {
        String terms = fs.getString("contract_terms");
        return baseDao.getFieldSetEntityByFilter(CmnConst.LX_PROJECT_CONTRACT_INVOICE_INFO,"contract_terms=?",new Object[]{terms},false);
    }


}