盾豆消耗 __m881rn4JGAibULhG3fp __m881rn4JGAibULhG3fp 1 2025-03-06T11:36:07.000+08:00 30 34 0 =1&&dayOfWeek<=5){ var orgBean="select item_organization_id,item_organization_name,item_points,id,author from tlk_org_shield_bean where item_points>-100 and (DATE_FORMAT(item_last_time, '%Y-%m-%d')"+orgBean); var orgBeandatas = queryByDSName("obpm2",orgBean); if(orgBeandatas.size()>0){ for(var orgBeaniterator = orgBeandatas.iterator();orgBeaniterator.hasNext();){ var orgBeanmap1 = orgBeaniterator.next();//取值 var organization_id= orgBeanmap1.get("item_organization_id"); var organization_name= orgBeanmap1.get("item_organization_name"); var points = orgBeanmap1.get("item_points"); var orgBeanId = orgBeanmap1.get("id"); var author = orgBeanmap1.get("author"); var empsql="select count(1) as num from tenant_employees where status=0 and organization_id='"+organization_id+"' " var empdatas = queryByDSName("obpm2",empsql); if(empdatas.size()>0){ for(var empiterator = empdatas.iterator();empiterator.hasNext();){ var empmap1 = empiterator.next();//取值 var num= empmap1.get("num"); } if(parseDouble(num)>0){ var nowPoint=parseDouble(points)-parseDouble(num) var orgBeanDoc=findDocument(orgBeanId); orgBeanDoc.findItem("points").setValue(nowPoint) orgBeanDoc.findItem("last_time").setValue(adjustDay(getToday(),-1)) process.doUpdate(orgBeanDoc); //var upsql ="update tlk_org_shield_bean set item_points="+nowPoint+",item_last_time=DATE_FORMAT(now(), '%Y-%m-%d') where item_organization_id='"+organization_id+"'" //updateByDSName("obpm2",upsql); var transactionfromid="__9HwNtE32O1tix95Oitk"; var process = getDocumentProcess(); var formProcess = getFormProcess(); var transactionSubform = formProcess.doView(transactionfromid); var userVO = getUserById(author); var transactionDoc = process.doNew(transactionSubform, userVO, createParamsTable()); Packages.java.lang.System.out.println("获取文档对象2-->"); transactionDoc.addStringItem("organization_name",organization_name); transactionDoc.addStringItem("organization_id",organization_id); transactionDoc.addDoubleItem("points",-parseDouble(num)); transactionDoc.addDoubleItem("person_number",parseDouble(num)); transactionDoc.addStringItem("type",10); transactionDoc.addDateItem("created_time",adjustDay(getToday(),-1)); transactionDoc.addStringItem("operator_name",organization_name); transactionDoc.addStringItem("operator_id",organization_id); transactionDoc.setDomainid(organization_id) Packages.java.lang.System.out.println("最终文档-->"+transactionDoc); process.doCreate(transactionDoc); } } } } } }catch(e){ Packages.java.lang.System.out.println("报错"+e); } })() ]]> 2025-03-06T11:36:07.000+08:00 admin Ai6hllhNjS2ull9TKGb 0 0 1 1 0 0 0