1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283 |
- package fi.em.formPlugin;
- import com.alibaba.fastjson.JSON;
- import com.alibaba.fastjson.JSONArray;
- import com.alibaba.fastjson.JSONObject;
- import kd.bos.entity.botp.plugin.AbstractConvertPlugIn;
- import kd.bos.entity.botp.plugin.args.BeforeBuildRowConditionEventArgs;
- import kd.bos.orm.query.QCP;
- import kd.bos.orm.query.QFilter;
- import kd.sdk.plugin.Plugin;
- //业务处理单基础资料选单过滤插件
- public class BusinessProcessingConvertPlugIn extends AbstractConvertPlugIn implements Plugin {
- @Override
- public void beforeBuildRowCondition(BeforeBuildRowConditionEventArgs e) {
- //获取页面插件传递过来的操作参数
- String orgnumber = this.getOption().getVariableValue("orgnumber");
- String jsonArray = this.getOption().getVariableValue("JSONArray");
- JSONArray objects = JSONArray.parseArray(jsonArray);
- String type = this.getOption().getVariableValue("type");//1
- if("drawyfgz".equals(type)){
- String billtype = this.getOption().getVariableValue("billtype");
- QFilter numberQFilter = new QFilter("ap_finapbill.org.number", QCP.equals, orgnumber);
- numberQFilter.and("ap_finapbill.billstatus", QCP.equals, "C");
- for(int i=0;i<objects.size();i++){
- JSONObject jsonObject = objects.getJSONObject(i);
- String id = jsonObject.getString("id");
- numberQFilter.and("ap_finapbill.id", QCP.not_equals2, Long.valueOf(id));
- }
- e.getCustQFilters().add(numberQFilter);
- }else if("drawysgz".equals(type)){
- String billtype = this.getOption().getVariableValue("billtype");
- QFilter numberQFilter = new QFilter("ar_finarbill.org.number", QCP.equals, orgnumber);
- numberQFilter.and("ar_finarbill.billstatus", QCP.equals, "C");
- for(int i=0;i<objects.size();i++){
- JSONObject jsonObject = objects.getJSONObject(i);
- String id = jsonObject.getString("id");
- numberQFilter.and("ar_finarbill.id", QCP.not_equals2, Long.valueOf(id));
- }
- e.getCustQFilters().add(numberQFilter);
- }else if("drawzlht".equals(type)){
- QFilter numberQFilter = new QFilter("fa_lease_contract.org.number", QCP.equals, orgnumber);
- // numberQFilter.and("fa_lease_contract.assetunit.number", QCP.equals,orgnumber);
- numberQFilter.and("fa_lease_contract.status", QCP.equals,"C");
- numberQFilter.and("fa_lease_contract.nckd_combofield", QCP.equals,"2");
- for(int i=0;i<objects.size();i++){
- JSONObject jsonObject = objects.getJSONObject(i);
- String id = jsonObject.getString("id");
- numberQFilter.and("fa_lease_contract.number", QCP.not_equals2, id);
- }
- e.getCustQFilters().add(numberQFilter);
- }else if("draw-yf".equals(type)){
- QFilter numberQFilter = new QFilter("er_prepaybill.costdept.number", QCP.equals, orgnumber);
- numberQFilter.and("er_prepaybill.billstatus", QCP.equals, "G");
- for(int i=0;i<objects.size();i++){
- JSONObject jsonObject = objects.getJSONObject(i);
- String id = jsonObject.getString("id");
- numberQFilter.and("er_prepaybill.billno", QCP.not_equals2, id);
- }
- e.getCustQFilters().add(numberQFilter);
- }else if("draw-ssysd".equals(type)){
- String customersid = this.getOption().getVariableValue("customersid");
- QFilter numberQFilter = new QFilter("ar_finarbill.asstact.id", QCP.equals, customersid);
- numberQFilter.and("ar_finarbill.billstatus", QCP.equals, "C");
- for(int i=0;i<objects.size();i++){
- JSONObject jsonObject = objects.getJSONObject(i);
- String id = jsonObject.getString("id");
- numberQFilter.and("ar_finarbill.id", QCP.not_equals2, Long.valueOf(id));
- }
- e.getCustQFilters().add(numberQFilter);
- }else if("draw-clyf".equals(type)){
- String userid = this.getOption().getVariableValue("userid");
- QFilter numberQFilter = new QFilter("er_prepaybill.billpayerid.id", QCP.equals, Long.valueOf(userid));
- numberQFilter.and("er_prepaybill.billstatus", QCP.equals, "G");
- for(int i=0;i<objects.size();i++){
- JSONObject jsonObject = objects.getJSONObject(i);
- String id = jsonObject.getString("id");
- numberQFilter.and("er_prepaybill.billno", QCP.not_equals2,id);
- }
- e.getCustQFilters().add(numberQFilter);
- }
- super.beforeBuildRowCondition(e);
- }
- }
|