jxyh/src/main/java/fi/er/opplugin/FinapbillBeforeF7SelectSample.java

package fi.er.opplugin;

import com.alibaba.druid.util.StringUtils;
import kd.bos.dataentity.entity.DynamicObject;
import kd.bos.dataentity.entity.DynamicObjectCollection;
import kd.bos.entity.datamodel.events.ChangeData;
import kd.bos.entity.datamodel.events.PropertyChangedArgs;
import kd.bos.form.field.RefBillEdit;
import kd.bos.form.field.events.BeforeF7SelectEvent;
import kd.bos.form.field.events.BeforeF7SelectListener;
import kd.bos.form.plugin.AbstractFormPlugin;
import kd.bos.list.ListShowParameter;
import kd.bos.orm.query.QCP;
import kd.bos.orm.query.QFilter;
import kd.bos.servicehelper.BusinessDataServiceHelper;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.Date;
import java.util.EventObject;

public class FinapbillBeforeF7SelectSample extends AbstractFormPlugin implements BeforeF7SelectListener {
    private static String nckd_apfinapbill = "nckd_apfinapbill"; //应付挂账单字段
    private static String nckd_real_card = "assetentry.nckd_real_card"; //应付挂账单字段
    private static String nckd_ap_finapbill_gz = "ap_finapbill"; //应付挂账单标识
    private static String nckd_er_publicreimbur_ext = "er_publicreimbursebill"; //报销单标识
    @Override
    public void registerListener(EventObject e) {
        //监听单据字段
        super.registerListener(e);
        RefBillEdit bill = this.getView().getControl(nckd_apfinapbill);
        bill.addBeforeF7SelectListener(this);
    }
    @Override
    public void beforeF7Select(BeforeF7SelectEvent arg0) {
        String fieldKey = arg0.getProperty().getName();
        if (StringUtils.equals(fieldKey, nckd_apfinapbill)){
            // 生成过滤条件对象QFilter
            Object nckd_sourcebillid = this.getModel().getValue("nckd_sourcebillid");
            if (nckd_sourcebillid != null) {
                //查询暂估报销单
                String sourcebillid = String.valueOf(nckd_sourcebillid);
                QFilter filter = new QFilter("nckd_sourcebillid", QCP.equals,sourcebillid);
                filter.and("nckd_ywlx", QCP.equals, "2");
                DynamicObject[] bxDynamicObjects = BusinessDataServiceHelper.load(nckd_er_publicreimbur_ext,"id",new QFilter[] {filter});
                if (bxDynamicObjects.length > 0) {
                    DynamicObject bxInfo = BusinessDataServiceHelper.loadSingle(bxDynamicObjects[0].getPkValue(), bxDynamicObjects[0].getDynamicObjectType().getName());
                    Long id = bxInfo.getLong("id");
                    QFilter qFilter = new QFilter("sourcebillid", QCP.equals,id);
                    // 表过滤条件
                    ListShowParameter showParameter = (ListShowParameter)arg0.getFormShowParameter();
                    showParameter.getListFilterParameter().setFilter(qFilter);
                }
            }else {
                //选取不到应付挂账单
                QFilter qFilter = new QFilter("id", QCP.equals,null);
                // 表过滤条件
                ListShowParameter showParameter = (ListShowParameter)arg0.getFormShowParameter();
                showParameter.getListFilterParameter().setFilter(qFilter);
            }
        }
    }

    @Override
    public void propertyChanged(PropertyChangedArgs e) {
        String fieldKey = e.getProperty().getName();
        if (StringUtils.equals("nckd_real_card", fieldKey)){
            ChangeData changeData = e.getChangeSet()[0];
            DynamicObjectCollection dynamicObjectCollection = (DynamicObjectCollection) changeData.getNewValue();
            int parentIndex = changeData.getRowIndex();
            this.getModel().deleteEntryData("nckd_realcard_list2");
            for (int i = 0; i < dynamicObjectCollection.size(); i++) {
                DynamicObject object = dynamicObjectCollection.get(i);
                this.getModel().setValue("nckd_card_list_str","1");
                //实物卡片清单分录赋值
                DynamicObject cardInfo = BusinessDataServiceHelper.loadSingle(object.get(2), "nckd_fa_card_real_list");
                int rowIndex = this.getModel().createNewEntryRow("nckd_realcard_list2");
                this.getModel().setValue("nckd_card_code2",cardInfo,rowIndex,parentIndex);
                if (i == 0) {
                    String name = cardInfo.getString("name");//资产名称
                    DynamicObject nckd_dept = cardInfo.getDynamicObject("nckd_dept");//归属部门
                    String nckd_use_name = cardInfo.getString("nckd_use_name");//使用人
                    String nckd_local = cardInfo.getString("nckd_local");//存放地点
                    String nckd_card_model = cardInfo.getString("nckd_card_model");//型号
                    //资产信息分录赋值
                    this.getModel().setValue("asset_name", name, parentIndex);
                    //资产类别赋值
                    //规格型号
                    this.getModel().setValue("asset_model",nckd_card_model, parentIndex);
                    //使用部门
                    this.getModel().setValue("asset_costdept",nckd_dept, parentIndex);
                    //使用人
                    QFilter userFilter = new QFilter("number", QCP.equals,nckd_use_name);
                    DynamicObject[] userDynamicObjects = BusinessDataServiceHelper.load("bos_user","id",new QFilter[] {userFilter});
                    for (int d=0;d<userDynamicObjects.length;d++) {
                        DynamicObject userInfo = BusinessDataServiceHelper.loadSingle(userDynamicObjects[i].getPkValue(), userDynamicObjects[i].getDynamicObjectType().getName());
                        this.getModel().setValue("asset_user",userInfo, parentIndex);
                    }
                    //存放地点
                    this.getModel().setValue("nckd_storeplace",nckd_local, parentIndex);
                }
            }
            //刷新实物卡片清单分录
            this.getView().updateView("assetentry");
        } else if (StringUtils.equals("nckd_apfinapbill", fieldKey)) {
            ChangeData changeData = e.getChangeSet()[0];
            DynamicObject dynamicObject = (DynamicObject) changeData.getNewValue();
            if (dynamicObject != null) {
                Long id = dynamicObject.getLong("id");
                //查询应付挂账
                QFilter filter = new QFilter("id", QCP.equals,id);
                DynamicObject[] yfgzDynamicObjects = BusinessDataServiceHelper.load(nckd_ap_finapbill_gz,"id",new QFilter[] {filter});
                DynamicObject gzInfo = BusinessDataServiceHelper.loadSingle(yfgzDynamicObjects[0].getPkValue(), yfgzDynamicObjects[0].getDynamicObjectType().getName());
                String billno = gzInfo.getString("billno");//单据编号
                DynamicObject org = gzInfo.getDynamicObject("org");//结算组织
                DynamicObject detailentry = gzInfo.getDynamicObjectCollection("detailentry").get(0);
                DynamicObject expenseitem = detailentry.getDynamicObject("expenseitem");//费用项目
                DynamicObject receivingsupplierid = gzInfo.getDynamicObject("receivingsupplierid");//供应商
                Date bookdate = gzInfo.getDate("bookdate");
                String remark = gzInfo.getString("remark");
                BigDecimal pricetaxtotal = gzInfo.getBigDecimal("pricetaxtotal");
                BigDecimal expeapproveamount = BigDecimal.ZERO;//核定金额
                BigDecimal orireceiveamount = BigDecimal.ZERO;//收款金额


                //费用明细分录
                DynamicObjectCollection expenseentryentity = this.getModel().getEntryEntity("expenseentryentity");
                for (DynamicObject object : expenseentryentity) {
                     expeapproveamount = expeapproveamount.add(object.getBigDecimal("expeapproveamount"));
                }

                //收款信息分录
                DynamicObjectCollection accountentry = this.getModel().getEntryEntity("accountentry");
                for (DynamicObject object : accountentry) {
                    orireceiveamount = orireceiveamount.add(object.getBigDecimal("orireceiveamount"));
                }

                //冲销金额
                BigDecimal nckd_accloanamount = expeapproveamount.subtract(orireceiveamount);
                //差额
                BigDecimal nckd_sub_amount = pricetaxtotal.subtract(nckd_accloanamount);
                //给冲预付借款赋值
                this.getModel().deleteEntryData("nckd_ap_finapbill_detail");
                int rowIndex = this.getModel().createNewEntryRow("nckd_ap_finapbill_detail");

                this.getModel().setValue("nckd_loanbillnov1",billno,rowIndex);
                this.getModel().setValue("nckd_sourceentrycostdept",org,rowIndex);
                this.getModel().setValue("nckd_sourceentrycostcompa",org,rowIndex);
                this.getModel().setValue("nckd_sourceexpenseitem",expenseitem,rowIndex);
//                this.getModel().setValue("nckd_srcentrywlunit",receivingsupplierid,rowIndex);
                this.getModel().setValue("nckd_loanapplydatev1",bookdate,rowIndex);
                this.getModel().setValue("nckd_loandescriptionv1",remark,rowIndex);
                this.getModel().setValue("nckd_loanamount",pricetaxtotal,rowIndex);
                this.getModel().setValue("nckd_currloanamount",pricetaxtotal,rowIndex);
                this.getModel().setValue("nckd_accloanamount",nckd_accloanamount,rowIndex);
                this.getModel().setValue("nckd_curraccloanamount",nckd_accloanamount,rowIndex);
                this.getModel().setValue("nckd_sub_amount",nckd_sub_amount,rowIndex);
                //刷新冲预付借款分录
                this.getView().updateView("nckd_ap_finapbill_detail");
            }
        }//资产组织变更
        else if (StringUtils.equals("assetorg", fieldKey)) {
            ChangeData changeData = e.getChangeSet()[0];
            DynamicObject dynamicObject = (DynamicObject) changeData.getNewValue();
            Long id = dynamicObject.getLong("id");
            //查询组织
            QFilter filter = new QFilter("id", QCP.equals,id);
            DynamicObject[] orgDynamicObjects = BusinessDataServiceHelper.load("bos_org","id",new QFilter[] {filter});
            DynamicObject orgInfo = BusinessDataServiceHelper.loadSingle(orgDynamicObjects[0].getPkValue(), orgDynamicObjects[0].getDynamicObjectType().getName());
            //获取资产信息分录
            DynamicObjectCollection assetentry = this.getModel().getEntryEntity("assetentry");
            for (int i = 0; i < assetentry.size(); i++) {
                //给分录核算组织，使用部门赋值
                this.getModel().setValue("nckd_orgfield1", orgInfo, i);
                this.getModel().setValue("asset_costdept", orgInfo, i);
            }
            //刷新资产信息分录
            this.getView().updateView("assetentry");
        } //资产信息分录-核算组织变更
        else if (StringUtils.equals("nckd_orgfield1", fieldKey)) {
            ChangeData changeData = e.getChangeSet()[0];
            DynamicObject dynamicObject = (DynamicObject) changeData.getNewValue();
            Long id = dynamicObject.getLong("id");
            //查询组织
            QFilter filter = new QFilter("id", QCP.equals,id);
            DynamicObject[] orgDynamicObjects = BusinessDataServiceHelper.load("bos_org","id",new QFilter[] {filter});
            DynamicObject orgInfo = BusinessDataServiceHelper.loadSingle(orgDynamicObjects[0].getPkValue(), orgDynamicObjects[0].getDynamicObjectType().getName());
            //获取资产信息分录
            DynamicObjectCollection assetentry = this.getModel().getEntryEntity("assetentry");
            //给分录核算组织，使用部门赋值
            this.getModel().setValue("nckd_orgfield1", orgInfo, e.getChangeSet()[0].getRowIndex());
            this.getModel().setValue("asset_costdept", orgInfo, e.getChangeSet()[0].getRowIndex());
            //刷新资产信息分录
            this.getView().updateView("assetentry");
        } else if (StringUtils.equals("expenseamount", fieldKey) || StringUtils.equals("nckd_amountfield3", fieldKey)) {
            String reimbursetype = (String) this.getModel().getValue("reimbursetype");
            if("asset".equals(reimbursetype)) {
                if (this.getModel().getEntryEntity("assetentry").size() == 0) {
                    int rowIndex = this.getModel().createNewEntryRow("assetentry");
                }
                ChangeData changeData = e.getChangeSet()[0];
                BigDecimal expenseamount = (BigDecimal) changeData.getNewValue();
                this.getModel().setValue("nckd_amountfield3", expenseamount, 0);//含税单价

                //含税金额 = 含税单价*数量
                BigDecimal asset_quantity = (BigDecimal) this.getModel().getValue("asset_quantity");
                BigDecimal assetexpenseamount = expenseamount.multiply(asset_quantity);
                this.getModel().setValue("assetexpenseamount", assetexpenseamount, 0);

                //不含税单价 = 含税单价/(1+税率)
                BigDecimal assettaxrate = (BigDecimal) this.getModel().getValue("assettaxrate");
                assettaxrate = assettaxrate.divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
                BigDecimal rate = assettaxrate.add(BigDecimal.ONE);
                BigDecimal assetpricewithouttax = expenseamount.divide(rate, 2 , RoundingMode.HALF_UP);
                this.getModel().setValue("assetpricewithouttax", assetpricewithouttax, 0);

                //不含税金额 = 不含税单价*数量
                BigDecimal assetorientryamount = assetpricewithouttax.multiply(asset_quantity);
                this.getModel().setValue("assetorientryamount", assetorientryamount, 0);

                //税额 = 含税金额-不含税金额
                BigDecimal assettaxamount = assetexpenseamount.subtract(assetorientryamount);
                this.getModel().setValue("assettaxamount", assettaxamount, 0);
            }
        } else if (StringUtils.equals("taxrate", fieldKey) || StringUtils.equals("assettaxrate", fieldKey)) {
            ChangeData changeData = e.getChangeSet()[0];
            BigDecimal assettaxrate = (BigDecimal) changeData.getNewValue();
            this.getModel().setValue("assettaxrate", assettaxrate);//税率

            //含税金额 = 含税单价 * 数量
            BigDecimal nckd_amountfield3 = (BigDecimal) this.getModel().getValue("nckd_amountfield3");
            BigDecimal asset_quantity = (BigDecimal) this.getModel().getValue("asset_quantity");
            BigDecimal assetexpenseamount = nckd_amountfield3.multiply(asset_quantity);
            this.getModel().setValue("assetexpenseamount", assetexpenseamount);

            //不含税单价 = 含税单价/(1+税率)
            assettaxrate = assettaxrate.divide(new BigDecimal(100), 2, RoundingMode.HALF_UP);
            BigDecimal rate = assettaxrate.add(BigDecimal.ONE);
            BigDecimal assetpricewithouttax = nckd_amountfield3.divide(rate, 2 , RoundingMode.HALF_UP);
            this.getModel().setValue("assetpricewithouttax", assetpricewithouttax);

            //不含税金额 = 不含税单价*数量
            BigDecimal assetorientryamount = assetpricewithouttax.multiply(asset_quantity);
            this.getModel().setValue("assetorientryamount", assetorientryamount);

            //税额 = 含税金额-不含税金额
            BigDecimal assettaxamount = assetexpenseamount.subtract(assetorientryamount);
            this.getModel().setValue("assettaxamount", assettaxamount);
        } else if (StringUtils.equals("expeapproveamount", fieldKey) || StringUtils.equals("orireceiveamount", fieldKey)) {
            DynamicObjectCollection nckd_ap_finapbill_detail = this.getModel().getEntryEntity("nckd_ap_finapbill_detail");
            if (nckd_ap_finapbill_detail.size() > 0) {
                BigDecimal expeapproveamount = BigDecimal.ZERO;//核定金额
                BigDecimal orireceiveamount = BigDecimal.ZERO;//收款金额
                //费用明细分录
                DynamicObjectCollection expenseentryentity = this.getModel().getEntryEntity("expenseentryentity");
                for (DynamicObject object : expenseentryentity) {
                    expeapproveamount = expeapproveamount.add(object.getBigDecimal("expeapproveamount"));
                }

                //收款信息分录
                DynamicObjectCollection accountentry = this.getModel().getEntryEntity("accountentry");
                for (DynamicObject object : accountentry) {
                    orireceiveamount = orireceiveamount.add(object.getBigDecimal("orireceiveamount"));
                }

                //冲销金额
                BigDecimal nckd_accloanamount = expeapproveamount.subtract(orireceiveamount);
                //借款余额
                BigDecimal nckd_loanamount = nckd_ap_finapbill_detail.get(0).getBigDecimal("nckd_loanamount");
                //差额
                BigDecimal nckd_sub_amount = nckd_loanamount.subtract(nckd_accloanamount);

                this.getModel().setValue("nckd_loanamount",nckd_loanamount,0);
                this.getModel().setValue("nckd_currloanamount",nckd_loanamount,0);
                this.getModel().setValue("nckd_accloanamount",nckd_accloanamount,0);
                this.getModel().setValue("nckd_curraccloanamount",nckd_accloanamount,0);
                this.getModel().setValue("nckd_sub_amount",nckd_sub_amount,0);
                //刷新冲预付借款分录
                this.getView().updateView("nckd_ap_finapbill_detail");
            }
        }
    }

    @Override
    public void afterCreateNewData(EventObject e) {
        //报账类型
        String reimbursetype = (String) this.getModel().getValue("reimbursetype");
        int rowIndex = this.getModel().createNewEntryRow("assetentry");
        if("asset".equals(reimbursetype)){
            //获取费用明细分录
            DynamicObjectCollection assetentry = this.getModel().getEntryEntity("expenseentryentity");
            //查询费用明细
            QFilter filter = new QFilter("name", QCP.equals,"资产报账");
            DynamicObject[] dynamicObjects = BusinessDataServiceHelper.load("er_expenseitemedit","id",new QFilter[] {filter});
            DynamicObject info = BusinessDataServiceHelper.loadSingle(dynamicObjects[0].getPkValue(), dynamicObjects[0].getDynamicObjectType().getName());
            this.getModel().setValue("expenseitem", info, 0);
        }
    }

}