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);
|
}
|
|
|
}
|
