CustomFunction.java 111 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991
  1. package com.mixsmart.utils;
  2. import cn.hutool.core.date.*;
  3. import cn.hutool.core.util.ArrayUtil;
  4. import cn.hutool.core.util.NumberUtil;
  5. import com.jfireel.expression.node.CalculateNode;
  6. import com.jfireel.expression.node.impl.OperatorResultNode;
  7. import com.jfireel.expression.node.impl.StaticObjectMethodNode;
  8. import com.jfireel.expression.node.impl.VariableNode;
  9. import com.jfireel.expression.token.Token;
  10. import org.apache.commons.collections4.MapUtils;
  11. import org.springblade.common.utils.BaseUtils;
  12. import org.springblade.core.tool.utils.*;
  13. import org.springblade.manager.dto.ParamElements;
  14. import org.springblade.manager.entity.WbsTreeContract;
  15. import java.math.BigDecimal;
  16. import java.text.ParseException;
  17. import java.text.SimpleDateFormat;
  18. import java.time.LocalDate;
  19. import java.time.LocalDateTime;
  20. import java.util.*;
  21. import java.util.concurrent.atomic.AtomicInteger;
  22. import java.util.concurrent.atomic.AtomicReference;
  23. import java.util.function.Function;
  24. import java.util.function.Supplier;
  25. import java.util.regex.Matcher;
  26. import java.util.regex.Pattern;
  27. import java.util.stream.Collectors;
  28. import java.util.stream.IntStream;
  29. import static java.math.BigDecimal.ROUND_CEILING;
  30. import static java.math.BigDecimal.ROUND_HALF_UP;
  31. /**
  32. * @author yangyj
  33. */
  34. public class CustomFunction {
  35. /**
  36. * 类调用地址前缀
  37. */
  38. public static final String CLASS_CALL = "T(com.mixsmart.utils.CustomFunction).";
  39. public static final String CONCAT = "@";
  40. public static final Set<String> KEYWORD_SET = new HashSet<>();
  41. static {
  42. KEYWORD_SET.add("first");
  43. KEYWORD_SET.add("last");
  44. KEYWORD_SET.add("empty");
  45. }
  46. /**
  47. * @return java.lang.String
  48. * @Description 根据桩号类型生成桩号
  49. * @Param [stationType]
  50. * @Author yangyj
  51. * @Date 2021.01.20 17:43
  52. **/
  53. public static String createStation(Object stationType) {
  54. if (StringUtils.isNotEmpty(stationType)) {
  55. Matcher m = RegexUtils.matcher("[~|-]", handleNull(stationType));
  56. if (m.find()) {
  57. StringBuilder sb = new StringBuilder();
  58. String splitchar = m.group(0);
  59. String[] arr = stationType.toString().split(splitchar);
  60. for (String str : arr) {
  61. sb.append(singleStation(str)).append(splitchar);
  62. }
  63. if (sb.length() > 0) {
  64. return sb.deleteCharAt(sb.length() - 1).toString();
  65. }
  66. } else {
  67. return singleStation(stationType);
  68. }
  69. }
  70. return "";
  71. }
  72. /**
  73. * @return java.lang.String[] result[0]:返回桩号前缀;result[1]:实际显示前缀;result[2]:里程数
  74. * @Description 记录表5输入桩号代码解析,2G1#1+100>>2G1K0+100
  75. * @Param [stake]
  76. * @Author yangyj
  77. * @Date 2021.04.09 11:49
  78. **/
  79. public static String[] decodeStake(Object stake) {
  80. String[] result = new String[]{"", "", ""};
  81. if (StringUtils.isNotEmpty(stake)) {
  82. String stakeStr = StringUtils.repaceBlank(stake.toString().toUpperCase());
  83. Matcher m;
  84. if (stake.toString().contains("+")) {
  85. m = RegexUtils.matcher("(([A-Z0-9]*)(#\\d*)?)\\+([\\d||\\.]*)", stakeStr);
  86. if (m.find()) {
  87. String partNoD = m.group(1);
  88. String partNoV = m.group(2);
  89. String kilometer = m.group(4);
  90. result[0] = partNoD;
  91. result[1] = partNoV;
  92. result[2] = kilometer;
  93. }
  94. } else {
  95. m = RegexUtils.matcher("([A-Z]*)([\\d||\\.]*)", stakeStr);
  96. if (m.find()) {
  97. String partNo = m.group(1);
  98. String kilometer = m.group(2);
  99. result[0] = partNo;
  100. result[1] = partNo;
  101. result[2] = kilometer;
  102. }
  103. }
  104. }
  105. return result;
  106. }
  107. public static String[] standardStake(Object stake) {
  108. String[] result = new String[]{"", ""};
  109. if (StringUtils.isNotEmpty(stake)) {
  110. String stakeStr = StringUtils.repaceBlank(stake.toString().toUpperCase());
  111. Matcher m = RegexUtils.matcher("([A-Z0-9]{0,3})K(\\d{1,3})\\+([\\d||\\.]*)", stakeStr);
  112. Matcher m2 = RegexUtils.matcher("([A-Z]{0,3})([\\d||\\.]+)", stakeStr);
  113. if (m.find()) {
  114. String partNo = m.group(1);
  115. double km = Double.parseDouble(m.group(2));
  116. double meter = Double.parseDouble(m.group(3));
  117. result[0] = partNo;
  118. int scale = getScale(meter);
  119. result[1] = StringUtils.number2String(km * 1000 + meter, scale);
  120. } else if (m2.find()) {
  121. result[0] = m2.group(1);
  122. result[1] = m2.group(2);
  123. }
  124. }
  125. return result;
  126. }
  127. /**
  128. * @return int
  129. * @Description 获取最大小数位
  130. * @Param [number]
  131. * @Author yangyj
  132. * @Date 2021.12.23 15:08
  133. **/
  134. public static Integer getScale(Object... number) {
  135. int max = 0;
  136. for (Object n : number) {
  137. if (StringUtils.isNotEmpty(n)) {
  138. String[] sa = n.toString().split(",");
  139. for (String s : sa) {
  140. Matcher m = RegexUtils.matcher("(\\d)+.(\\d)+", s);
  141. if (m.find()) {
  142. max = Math.max(new StringBuilder(m.group()).reverse().toString().indexOf("."), max);
  143. }
  144. }
  145. }
  146. }
  147. return max;
  148. }
  149. public static String singleStation(Object station) {
  150. if (StringUtils.isNotEmpty(station)) {
  151. Object zhdata = station;
  152. String zhdatastr = zhdata.toString().toUpperCase();
  153. if (zhdatastr.contains("+") && zhdatastr.contains("K")) {
  154. return zhdatastr;
  155. }
  156. String[] stake = decodeStake(zhdatastr);
  157. String partNo = stake[1];
  158. String kilometer = stake[2];
  159. if (StringUtils.isNotEmpty(kilometer)) {
  160. partNo = handleNull(partNo);
  161. int ks = (int) Math.floor(Double.parseDouble(kilometer) / 1000);
  162. double ke = new BigDecimal(kilometer).subtract(new BigDecimal(String.valueOf(ks * 1000))).doubleValue();
  163. String temp = "" + ke;
  164. if ((int) Double.parseDouble(temp) == Double.parseDouble(temp)) {
  165. temp = String.valueOf((int) Double.parseDouble(temp));
  166. }
  167. String sf = "000";
  168. if (temp.length() < 3) {
  169. temp = sf.substring(0, 3 - temp.length()) + temp;
  170. }
  171. if ((temp.contains(".") && temp.indexOf(".") <= 2)) {
  172. temp = sf.substring(0, 3 - temp.indexOf(".")) + temp;
  173. }
  174. return partNo + "K" + ks + "+" + temp;
  175. }
  176. }
  177. return "";
  178. }
  179. public static Object calculate(Object a, Object b, Object scaleObj, Integer type) {
  180. boolean nullFlag = false;
  181. if (type == null) {
  182. return null;
  183. }
  184. if (StringUtils.isEmpty(a) && StringUtils.isEmpty(b)) {
  185. return null;
  186. }
  187. if (StringUtils.isEmpty(a) && type == 7) {
  188. nullFlag = true;
  189. a = 0;
  190. }
  191. if (StringUtils.isEmpty(b) && type == 7) {
  192. nullFlag = true;
  193. b = 0;
  194. }
  195. if (StringUtils.isNotEmpty(a) && StringUtils.isNotEmpty(b)) {
  196. try {
  197. int scale = StringUtils.handleObj2Integer(scaleObj);
  198. String aStr = a.toString();
  199. String bStr = b.toString();
  200. double ad = Double.parseDouble(aStr);
  201. double bd = 0;
  202. if (type == 6) {
  203. //判断设计值是否包含"/"
  204. if (bStr.contains("/")) {
  205. bd = bStr.split("/").length;
  206. return (int) (ad * bd);
  207. } else {
  208. return (int) ad;
  209. }
  210. }
  211. bd = Double.parseDouble(bStr);
  212. double result = 0;
  213. if (type == 1) {
  214. result = ad + bd;
  215. } else if (type == 2) {
  216. result = ad - bd;
  217. } else if (type == 3) {
  218. result = ad * bd;
  219. } else if (type == 4) {
  220. result = ad / bd;
  221. } else if (type == 5) {
  222. result = ad % bd;
  223. } else if (type == 7 && ad * bd != 0 && !nullFlag) {
  224. return (int) Math.ceil(ad * bd);
  225. } else {
  226. return null;
  227. }
  228. BigDecimal big = new BigDecimal(result);
  229. return big.setScale(scale, ROUND_HALF_UP);
  230. } catch (NumberFormatException e) {
  231. e.printStackTrace();
  232. }
  233. }
  234. return null;
  235. }
  236. public static boolean isNumber(Object value) {
  237. if (Func.isEmpty(value)) {
  238. return false;
  239. }
  240. if (value instanceof Number) {
  241. return true;
  242. }
  243. String pattern = "^[+-]?\\d+(\\.\\d+)?$";
  244. Pattern r = Pattern.compile(pattern);
  245. Matcher m = r.matcher(String.valueOf(value));
  246. return m.matches();
  247. }
  248. public static boolean isNotNumber(Object value) {
  249. return !isNumber(value);
  250. }
  251. public static Object sum(List<Object> list) {
  252. if (ListUtils.isNotEmpty(list)) {
  253. return list.stream().filter(StringUtils::isNumber).map(StringUtils::handleNull).mapToDouble(Double::parseDouble).sum();
  254. }
  255. return "";
  256. }
  257. public static Object avg(List<Object> list) {
  258. if (ListUtils.isNotEmpty(list)) {
  259. OptionalDouble op = list.stream().filter(StringUtils::isNumber).map(StringUtils::handleNull).mapToDouble(Double::parseDouble).average();
  260. if (op.isPresent()) {
  261. return op.getAsDouble();
  262. }
  263. }
  264. return "";
  265. }
  266. /**
  267. * @return java.util.List<java.lang.Object>
  268. * @Description 分段求平均值
  269. * @Param [data 原数据, n 分段数]
  270. * @Author yangyj
  271. * @Date 2023.04.28 10:13
  272. **/
  273. public static List<Object> avg4segment(List<Object> data, int n) {
  274. if (data.isEmpty()) {
  275. return null;
  276. }
  277. if (n <= 1) {
  278. return Collections.singletonList(avg(data));
  279. }
  280. Map<Integer, List<Object>> group = IntStream.range(0, data.size())
  281. .boxed()
  282. .collect(Collectors.groupingBy(i -> i / n, LinkedHashMap::new, Collectors.mapping(data::get, Collectors.toList())));
  283. return group.values().stream().map(CustomFunction::avg).collect(Collectors.toList());
  284. }
  285. public static Object max(List<Object> list) {
  286. if (ListUtils.isNotEmpty(list)) {
  287. OptionalDouble op = list.stream().filter(StringUtils::isNumber).map(StringUtils::handleNull).mapToDouble(Double::parseDouble).max();
  288. if (op.isPresent()) {
  289. return op.getAsDouble();
  290. }
  291. }
  292. return "";
  293. }
  294. public static Object min(List<Object> list) {
  295. if (ListUtils.isNotEmpty(list)) {
  296. OptionalDouble op = list.stream().filter(StringUtils::isNumber).map(StringUtils::handleNull).mapToDouble(Double::parseDouble).min();
  297. if (op.isPresent()) {
  298. return op.getAsDouble();
  299. }
  300. }
  301. return "";
  302. }
  303. public static Object count(Object data) {
  304. List<Object> list = obj2ListNe(data);
  305. if (ListUtils.isNotEmpty(list)) {
  306. if (list.stream().anyMatch(e -> !StringUtils.isNumber(e))) {
  307. return list.stream().filter(StringUtils::isNotEmpty).count();
  308. }
  309. return list.stream().filter(StringUtils::isNumber).map(StringUtils::handleNull).mapToDouble(Double::parseDouble).count();
  310. }
  311. return "";
  312. }
  313. /**
  314. * @return java.lang.Object
  315. * @Description 输出勾选复选框
  316. * @Param [o1, o2]
  317. * @Author yangyj
  318. * @Date 2021.06.29 10:35
  319. **/
  320. public static Object checkbox(Object o1, Object o2) {
  321. if (StringUtils.isNotEmpty(o1) && StringUtils.isNotEmpty(o2)) {
  322. if (o1.equals(o2)) {
  323. return "\u2611";
  324. }
  325. }
  326. return "";
  327. }
  328. /**
  329. * @return java.lang.Object
  330. * @Description 返回n个空格,用于输出字符串格式化
  331. * @Param [n]
  332. * @Author yangyj
  333. * @Date 2021.06.29 11:41
  334. **/
  335. public static Object space(Object n) {
  336. if (StringUtils.isNumber(n)) {
  337. return String.join("", Collections.nCopies(Integer.parseInt(n.toString()), "\u0020"));
  338. }
  339. return "";
  340. }
  341. /**
  342. * @return boolean
  343. * @Description 字符串中是包含中文
  344. * @Param [chars]
  345. * @Author yangyj
  346. * @Date 2021.09.17 14:31
  347. **/
  348. public static boolean containsZH(Object chars) {
  349. Matcher m = RegexUtils.matcher("[\u4e00-\u9fa5]", handleNull(chars));
  350. return m.find();
  351. }
  352. /**
  353. * @return boolean
  354. * @Description 字符串中是包含数字
  355. * @Param [chars]
  356. * @Author yangyj
  357. * @Date 2021.09.17 14:31
  358. **/
  359. public static boolean containsD(Object chars) {
  360. Matcher m = RegexUtils.matcher("\\d", handleNull(chars));
  361. return m.find();
  362. }
  363. /**
  364. * @return java.lang.String
  365. * @Description 封装超链接
  366. * @Param [uri]
  367. * @Author yangyj
  368. * @Date 2021.10.14 16:15
  369. **/
  370. public static String uri(Object uri) {
  371. if (StringUtils.isNotEmpty(uri)) {
  372. return "URI<" + handleNull(uri) + ">";
  373. }
  374. return "";
  375. }
  376. /**
  377. * @return java.lang.Object
  378. * @Description 获取相隔多少天后的日期
  379. * @Param [date, n:相隔天数,正数代表未来,负数代表历史]
  380. * @Author yangyj
  381. * @Date 2021.10.27 10:21
  382. **/
  383. public static Object dateAfter(Object date, Object n) {
  384. if (StringUtils.isNotEmpty(date) && StringUtils.isNotEmpty(n)) {
  385. List<String> dateList =new ArrayList<>();
  386. if (date instanceof List) {
  387. dateList = ((List<String>)date);
  388. }else{
  389. dateList.add(date.toString());
  390. }
  391. LinkedList<Integer> offSet = new LinkedList<>();
  392. if (n instanceof List) {
  393. offSet.addAll((List<Integer>)n);
  394. }else{
  395. offSet.add(StringUtils.handObj2Integer(n));
  396. }
  397. return dateOffset(dateList,offSet);
  398. }
  399. return "";
  400. }
  401. public static Object dateOffset(List<String> dateList,LinkedList<Integer> offSet){
  402. List<String> result = new ArrayList<>();
  403. if(ListUtils.isNotEmpty(dateList)&&ListUtils.isNotEmpty(offSet)){
  404. for(int i=0;i<dateList.size();i++){
  405. String d= dateList.get(i);
  406. if(StringUtils.isNotEmpty(d)) {
  407. if(d.contains(",")){
  408. String[] arr=d.replaceAll("[\\[\\]\\s]+","").split(",");
  409. d=arr[arr.length-1];
  410. }
  411. Integer n = StringUtils.handObj2Integer(offSet.size() > i ? offSet.get(i) : offSet.getLast());
  412. DateTime dt = new DateTime(d);
  413. dt.offset(DateField.HOUR_OF_DAY, 24 * n);
  414. result.add(dt.toString(DatePattern.CHINESE_DATE_PATTERN));
  415. }
  416. }
  417. }
  418. return result;
  419. }
  420. public static Object weather( Object dateObj,Map<String,Object> map){
  421. if(dateObj!=null&&map!=null){
  422. List<Object> date=obj2ListObj(dateObj);
  423. return date.stream().map(StringUtils::handleNull).filter(StringUtils::isNotEmpty).map(e->map.get(new DateTime(FormulaUtils.range2end(e)).toString(DatePattern.NORM_DATE_PATTERN))).collect(Collectors.toList());
  424. }
  425. return "";
  426. }
  427. public static List<Object> obj2ListObj(Object input) {
  428. if (input == null) {
  429. return Collections.emptyList();
  430. }
  431. List<Object> result = new ArrayList<>();
  432. if (input instanceof List<?>) {
  433. result.addAll((List<?>) input);
  434. } else if (StringUtils.isNotEmpty(input)) {
  435. result.add(input);
  436. }
  437. return result;
  438. }
  439. public static Object dateMax(Object range) {
  440. return convert(range,false);
  441. }
  442. public static Object dateMin(Object range) {
  443. return convert(range,true);
  444. }
  445. public static Object convert(Object range,boolean isAsc){
  446. if (Func.isNotEmpty(range)) {
  447. if(range instanceof List){
  448. List<Object> ranges= (List<Object>) range;
  449. if( Func.isNotEmpty(ranges)) {
  450. return ranges.stream().filter(Func::isNotEmpty).map(e->{
  451. String[] s = Func.toStr(e).replaceAll("[\\[\\]\\s\\\\]+", "").split(",");
  452. if(s.length>=2){
  453. return dateCp(s[0], s[1], isAsc);
  454. }else if(s.length==1){
  455. return s[0];
  456. }
  457. return "";
  458. }).collect(Collectors.toList());
  459. }
  460. } else{
  461. String[] s = Func.toStr(range).replaceAll("[\\[\\]\\s]+", "").split(",");
  462. return dateCp(s[0], s[1], isAsc);
  463. }
  464. }
  465. return StringPool.EMPTY;
  466. }
  467. private static Object dateCp(Object d1, Object d2, Boolean isAsc) {
  468. if (d1 != null && d2 != null) {
  469. Map<DateTime, Object> map = new HashMap<>();
  470. String day1 = d1.toString();
  471. day1=day1.replace("年","-");
  472. day1=day1.replace("月","-");
  473. if(day1.indexOf("日")>0){
  474. day1= day1.substring(0,day1.indexOf("日"));
  475. }
  476. String day2 = d2.toString();
  477. day2= day2.replace("年","-");
  478. day2= day2.replace("月","-");
  479. if(day2.indexOf("日")>0){
  480. day2=day2.substring(0,day2.indexOf("日"));
  481. }
  482. day1=day1.replace("\"", "");
  483. day2=day2.replace("\"", "");
  484. DateTime dt1 = new DateTime(day1);
  485. DateTime dt2 = new DateTime(day2);
  486. map.put(dt1, d1);
  487. map.put(dt2, d2);
  488. List<DateTime> list = new ArrayList<>();
  489. list.add(dt1);
  490. list.add(dt2);
  491. if (isAsc) {
  492. return map.get(dcp(list, Comparator.naturalOrder()));
  493. } else {
  494. return map.get(dcp(list, Comparator.reverseOrder()));
  495. }
  496. }
  497. return StringPool.EMPTY;
  498. }
  499. /**
  500. * @return java.lang.Object
  501. * @Description 优良占比
  502. * @Param [data, cp]
  503. * @Author yangyj
  504. * @Date 2022.12.21 12:00
  505. **/
  506. public static Object proportion(List<Object> data, String cp) {
  507. if (Func.isNotEmpty(data) && Func.isNotBlank(cp)) {
  508. data = data.stream().filter(Func::isNotEmpty).map(e -> e.toString().replaceAll("\\s+", "")).filter(s->!RegexUtil.match("/+",s)).collect(Collectors.toList());
  509. if(data.size()>0) {
  510. return 100 * ((double) data.stream().filter(e -> StringUtils.isEquals(e, cp)).count()) / (double) data.size();
  511. }
  512. }
  513. return "";
  514. }
  515. /* public static void main(String[] args) {
  516. List<Object> list = Arrays.asList("优良","优良","优良","/");
  517. System.out.println(proportion(list,"优良"));
  518. }*/
  519. public static Object goodSize(List<Object> data, String cp) {
  520. if (Func.isNotEmpty(data) && Func.isNotBlank(cp)) {
  521. data = data.stream().filter(Func::isNotEmpty).map(e -> e.toString().replaceAll("\\s+", "")).collect(Collectors.toList());
  522. return data.stream().filter(e -> StringUtils.isEquals(e, cp)).count();
  523. }
  524. return "";
  525. }
  526. /**
  527. * @return java.lang.Object
  528. * @Description 阶梯合格率
  529. * @Param [data]
  530. * @Author yangyj
  531. * @Date 2022.12.21 11:59
  532. **/
  533. public static Object ladder(List<Object> data) {
  534. if (Func.isNotEmpty(data)) {
  535. OptionalDouble op = data.stream().map(StringUtils::handleNull).map(o->o.replace("%","")).filter(StringUtils::isNumber).mapToDouble(Double::parseDouble).min();
  536. if (op.isPresent()) {
  537. return op.getAsDouble() >= 90 ? 90 : 70;
  538. }
  539. }
  540. return "";
  541. }
  542. /**
  543. * @return java.lang.Object
  544. * @Description 主要工序质量等级
  545. * @Param [data]
  546. * @Author yangyj
  547. * @Date 2022.12.21 14:18
  548. **/
  549. public static Object major(List<Object> data) {
  550. if (Func.isNotEmpty(data) && data.stream().anyMatch(StringUtils::isNotEmpty)) {
  551. return data.stream().map(StringUtils::handleNull).distinct().collect(Collectors.toList()).stream().anyMatch(e -> e.contains("合格")) ? "合格" : "优良";
  552. }
  553. return "";
  554. }
  555. /**
  556. * @return java.lang.Object
  557. * @Description 单元工程质量等级评定
  558. * @Param [rate, level]
  559. * @Author yangyj
  560. * @Date 2022.12.21 14:33
  561. **/
  562. public static Object unit(List<Object> rate, List<Object> level) {
  563. if (ListUtils.isNotEmpty(rate)&&ListUtils.isNotEmpty(level)) {
  564. return StringUtils.obj2Double(StringUtils.handleNull(rate.get(0)).trim()) > 50 && "优良".equals(StringUtils.handleNull(level.get(0)).trim()) ? "优良" : "合格";
  565. }
  566. return "";
  567. }
  568. /**
  569. * @return java.lang.Object
  570. * @Description 主控项目数量
  571. * @Param [data]
  572. * @Author yangyj
  573. * @Date 2022.12.21 15:37
  574. **/
  575. public static Object reasonable(List<Object> data) {
  576. if (ListUtils.isNotEmpty(data)) {
  577. return data.stream().map(e -> StringUtils.handleNull(e).replace("/", "")).filter(StringUtils::isNotEmpty).count();
  578. }
  579. return "";
  580. }
  581. /**
  582. * @return cn.hutool.core.date.DateTime
  583. * @Description 时间比较获取
  584. * @Param [list:时间集合, comparator 比较器 ]
  585. * @Author yangyj
  586. * @Date 2022.11.10 10:47
  587. **/
  588. public static DateTime dcp(List<DateTime> list, Comparator<? super DateTime> comparator) {
  589. return list.stream().reduce((a, b) -> comparator.compare(a, b) <= 0 ? a : b).orElse(null);
  590. }
  591. public static String dateToStr(Date date, String formatter) {
  592. String value = null;
  593. if (null != date) {
  594. if (StringUtils.isEmpty(formatter)) {
  595. formatter = "yyyy-MM-dd HH:mm:ss";
  596. }
  597. SimpleDateFormat dateFormat = new SimpleDateFormat(formatter);
  598. value = dateFormat.format(date);
  599. dateFormat = null;
  600. }
  601. return value;
  602. }
  603. public static String summary(List<String> tableNames) {
  604. if (ListUtils.isNotEmpty(tableNames)) {
  605. return tableNames.stream().map(e -> e.replaceAll("_(PL)?_\\d+$", "")).distinct().collect(Collectors.joining(StringPool.NEWLINE));
  606. }
  607. return StringPool.EMPTY;
  608. }
  609. /**合格率显示*/
  610. public static String passRateDisplay(Object rates){
  611. List<Object> rate =obj2ListNe(rates);
  612. if(Func.isNotEmpty(rate)&&rate.stream().anyMatch(StringUtils::isNotEmpty)){
  613. Optional<Object> op= rate.stream().filter(s->s!=null&&RegexUtil.match("[\\d.]+%?",s.toString())).findAny();
  614. return op.map(o ->{
  615. o=o.toString().replace("%","");
  616. int scale=1;
  617. double x=BaseUtils.obj2DoubleZero(o);
  618. if(x>=100.0){
  619. scale=0;
  620. if(x>100.0){
  621. o=100;
  622. }
  623. }
  624. return StringUtils.number2StringZero(o, scale) + "%";
  625. }).orElseGet(()->rate.get(0).toString());
  626. }
  627. return "/";
  628. }
  629. public String checkItems(List<String> items, List<Object> l1, List<Object> l2, List<Object> l3, List<Object> l4, List<Object> l5, List<Object> l6, List<Object> l7, List<Object> l8, List<Object> l9, List<Object> l10, List<Object> l11, List<Object> l12) {
  630. List<List<Object>> data = new ArrayList<>(Arrays.asList(l1, l2, l3, l4, l5, l6, l7, l8, l9, l10, l11, l12));
  631. List<String> result = new ArrayList<>();
  632. for (int i = 0; i < data.size(); i++) {
  633. List<Object> list = data.get(i);
  634. if (list.stream().anyMatch(StringUtils::isNotEmpty)) {
  635. result.add(items.get(i));
  636. }
  637. }
  638. if (ListUtils.isNotEmpty(result)) {
  639. return String.join("、", result);
  640. }
  641. return StringPool.EMPTY;
  642. }
  643. /**
  644. * @return java.lang.Object
  645. * @Description 计算t1~t2,t3~t4 两个时间段的合计时间,unit 输入数值的单位
  646. * @Param [t1, t2, t3, t4, unit]
  647. * @Author yangyj
  648. * @Date 2021.07.02 15:47
  649. **/
  650. public static Object totalTime(Object t1, Object t2, Object t3, Object t4, Object unit) {
  651. if (StringUtils.isNotEmpty(t1) && StringUtils.isNotEmpty(t2) && StringUtils.isNotEmpty(t3) && StringUtils.isNotEmpty(t4) && StringUtils.isNotEmpty(unit)) {
  652. return conversionUnit((Long.parseLong(minutesPassedRecent(t1, t2).toString()) + Long.parseLong(minutesPassedRecent(t3, t4).toString())), unit);
  653. }
  654. return "";
  655. }
  656. /**
  657. * @return java.lang.Object
  658. * @Description 字符串日期转指定格式日期
  659. * @Param [date, format:输出格式]
  660. * @Author yangyj
  661. * @Date 2021.07.02 15:55
  662. **/
  663. public static Object dateFormatter(Object date, Object format) {
  664. if (StringUtils.isNotEmpty(date) && StringUtils.isNotEmpty(format)) {
  665. Matcher m = RegexUtils.matcher("(\\d{4})\\D(\\d{2})\\D(\\d{2})日?\\s*(\\d{0,2})(\\D\\d{1,2})?", date.toString());
  666. if (m.find()) {
  667. String yyyy = handleNull(m.group(1));
  668. String MM = handleNull(m.group(2));
  669. String dd = handleNull(m.group(3));
  670. String HH = handleNull(m.group(4));
  671. String mm = handleNull(m.group(5));
  672. String d = handleNull(format);
  673. if (StringUtils.isNotEmpty(yyyy)) {
  674. d = d.replace("yyyy", yyyy);
  675. }
  676. if (StringUtils.isNotEmpty(MM)) {
  677. d = d.replace("MM", MM);
  678. }
  679. if (StringUtils.isNotEmpty(dd)) {
  680. d = d.replace("dd", dd);
  681. }
  682. if (StringUtils.isNotEmpty(HH)) {
  683. d = d.replace("HH", HH);
  684. }
  685. if (StringUtils.isNotEmpty(mm)) {
  686. mm = mm.replaceAll("\\D", "");
  687. d = d.replace("mm", mm);
  688. }
  689. return d;
  690. }
  691. }
  692. return "";
  693. }
  694. /**
  695. * @return java.lang.Object
  696. * @Description 求偏差值
  697. * @Param [list, design]
  698. * @Author yangyj
  699. * @Date 2021.09.18 10:43
  700. **/
  701. public static Object deviation(Object list, Object design) {
  702. if (StringUtils.isNotEmpty(list) && StringUtils.isNumber(design)) {
  703. List<Object> result = new ArrayList<>();
  704. List<Object> tmp;
  705. if (list instanceof List) {
  706. tmp = (List<Object>) list;
  707. } else {
  708. tmp = Arrays.asList(list.toString().split("[,|\\-~,]"));
  709. }
  710. int dev = StringUtils.handObj2Integer(design);
  711. for (Object e : tmp) {
  712. if (containsZH(e)) {
  713. /*不允许包含中文*/
  714. return "";
  715. }
  716. result.add(StringUtils.handObj2Integer(e) - dev);
  717. }
  718. if (ListUtils.isNotEmpty(result)) {
  719. return result;
  720. }
  721. }
  722. return "";
  723. }
  724. /**
  725. * @return java.lang.Object
  726. * @Description 把日期格式化成 'xxxx年xx月xx日 星期x' 字符串
  727. * @Param [date]
  728. * @Author yangyj
  729. * @Date 2021.06.21 14:27
  730. **/
  731. public static Object toDateAndWeek(Object date) {
  732. if (StringUtils.isNotEmpty(date)) {
  733. Date d = parseDate(handleNull(date));
  734. String[] weekDays = {"星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六"};
  735. Calendar calendar = Calendar.getInstance();
  736. assert d != null;
  737. calendar.setTime(d);
  738. String week = weekDays[calendar.get(Calendar.DAY_OF_WEEK) - 1];
  739. return dateToStr(d, "yyyy年MM月dd日") + " " + week;
  740. }
  741. return null;
  742. }
  743. /**
  744. * @return java.lang.Object
  745. * @Description
  746. * @Param [data , unit 输入单位]
  747. * @Author yangyj
  748. * @Date 2022.10.13 14:13
  749. **/
  750. public static Object conversionUnit(Object data, Object unit) {
  751. if (StringUtils.isNumber(data) && StringUtils.isNotEmpty(unit)) {
  752. //统一转化成毫秒在处理
  753. long ms = 0;
  754. long l = Long.parseLong(data.toString());
  755. final long s = 1000L;
  756. final long m = s * 60;
  757. final long H = m * 60;
  758. final long D = H * 24;
  759. final long M = D * 30;
  760. final long Y = D * 365;
  761. if (StringUtils.isEquals("Y", unit.toString())) {
  762. ms = l * Y;
  763. } else if (StringUtils.isEquals("M", unit.toString())) {
  764. ms = l * M;
  765. } else if (StringUtils.isEquals("D", unit.toString())) {
  766. ms = l * D;
  767. } else if (StringUtils.isEquals("H", unit.toString())) {
  768. ms = l * H;
  769. } else if (StringUtils.isEquals("m", unit.toString())) {
  770. ms = l * m;
  771. }
  772. StringBuilder sb = new StringBuilder();
  773. if (ms / Y != 0) {
  774. sb.append(ms / Y).append("年");
  775. ms = ms % Y;
  776. }
  777. if (ms / M != 0) {
  778. sb.append(ms / M).append("月");
  779. ms = ms % M;
  780. }
  781. if (ms / D != 0) {
  782. sb.append(ms / D).append("日");
  783. ms = ms % D;
  784. }
  785. if (ms / H != 0) {
  786. sb.append(ms / H).append("时");
  787. ms = ms % H;
  788. }
  789. if (ms / m != 0) {
  790. sb.append(ms / m).append("分");
  791. ms = ms % m;
  792. }
  793. if (sb.length() > 0) {
  794. return sb.toString();
  795. }
  796. }
  797. return "";
  798. }
  799. public static Object fileSize(Object data) {
  800. return fileSize(data, null);
  801. }
  802. public static Object fileSize(Object data, Object unit) {
  803. if (StringUtils.isNumber(data)) {
  804. if (StringUtils.isEmpty(unit)) {
  805. unit = "K";
  806. }
  807. //统一转化成KB在处理
  808. long ms = 0;
  809. long l = Long.parseLong(data.toString());
  810. final long KB = 1L;
  811. final long MB = 1024 * KB;
  812. final long GB = 1024 * MB;
  813. final long TB = 1024 * GB;
  814. if (StringUtils.isEquals("K", unit.toString().toUpperCase())) {
  815. ms = l * KB;
  816. } else if (StringUtils.isEquals("M", unit.toString().toUpperCase())) {
  817. ms = l * MB;
  818. } else if (StringUtils.isEquals("G", unit.toString().toUpperCase())) {
  819. ms = l * GB;
  820. } else if (StringUtils.isEquals("T", unit.toString().toUpperCase())) {
  821. ms = l * TB;
  822. }
  823. if (ms / TB != 0) {
  824. return new BigDecimal(ms).divide(new BigDecimal(TB), 2, ROUND_HALF_UP) + "TB";
  825. }
  826. if (ms / GB != 0) {
  827. return new BigDecimal(ms).divide(new BigDecimal(GB), 1, ROUND_HALF_UP) + "GB";
  828. }
  829. if (ms / MB != 0) {
  830. return new BigDecimal(ms).divide(new BigDecimal(MB), 0, ROUND_HALF_UP) + "MB";
  831. }
  832. return ms + "KB";
  833. }
  834. return "";
  835. }
  836. public static Object daysPassed(Object t1, Object t2) {
  837. return timePassed(t1, t2, "D", 0, "yyyy-MM-dd");
  838. }
  839. /* public static void main(String[] args) {
  840. *//* LocalDateTime ldt1= LocalDateTime.now();
  841. LocalDateTime ldt2=ldt1.minusDays(-1);
  842. LocalDateTime ldt3=ldt1.minusDays(120L);
  843. System.out.println(daysPassed(ldt2,ldt1));
  844. System.out.println(daysPassed(ldt3,ldt1));
  845. System.out.println(hoursPassed(ldt2,ldt1));
  846. System.out.println(hoursPassed(ldt3,ldt1));
  847. System.out.println(minutesPassed(ldt2,ldt1));
  848. System.out.println(minutesPassed(ldt3,ldt1));*//*
  849. *//* LocalDate t1 = LocalDate.of(2023, 1, 1);
  850. LocalDate t2 = LocalDate.of(2023, 1, 1);t2=t2.plusDays(1);
  851. System.out.println(timePassed(t1, t2, "D", 0, "yyyy-MM-dd"));*//*
  852. }*/
  853. public static Object hoursPassed(Object t1, Object t2) {
  854. return timePassed(t1, t2, "H", 0, "yyyy-MM-dd HH");
  855. }
  856. public static Object minutesPassed(Object t1, Object t2) {
  857. return timePassed(t1, t2, "m", 0, "yyyy-MM-dd HH:mm");
  858. }
  859. /**
  860. * @return java.lang.Object
  861. * @Description 输入时间格式:mm:ss(例如01:33)
  862. * @Param [t1, t2]
  863. * @Author yangyj
  864. * @Date 2021.07.02 17:45
  865. **/
  866. public static Object minutesPassedRecent(Object t1, Object t2) {
  867. String year = Calendar.getInstance().get(Calendar.YEAR) + ".";
  868. int month = Calendar.getInstance().get(Calendar.MONTH) + 1;
  869. String mstr = "";
  870. if (month < 10) {
  871. mstr = "0" + month + ".";
  872. } else {
  873. mstr = month + ".";
  874. }
  875. int day = Calendar.getInstance().get(Calendar.DATE) + 1;
  876. String dstr = "";
  877. if (day < 10) {
  878. dstr = "0" + day + " ";
  879. } else {
  880. dstr = day + " ";
  881. }
  882. t1 = year + mstr + dstr + t1;
  883. t2 = year + mstr + dstr + t2;
  884. return timePassed(t1, t2, "m", 0, "yyyy-MM-dd HH:mm");
  885. }
  886. public static Object hoursPassedRecent(Object t1, Object t2) {
  887. String year = Calendar.getInstance().get(Calendar.YEAR) + "年";
  888. t1 = year + t1;
  889. t1 = t1.toString().replace("日", " ").replace("时", " ");
  890. t2 = year + t2;
  891. t2 = t2.toString().replace("日", " ").replace("时", " ");
  892. return timePassed(t1, t2, "H", 0, "yyyy-MM-dd HH");
  893. }
  894. public static Date parseDate(String dateStr) {
  895. if (StringUtils.isEmpty(dateStr)) {
  896. return null;
  897. }
  898. if (!dateStr.contains("-")) {
  899. dateStr = StringUtils.repaceBlank(dateStr);
  900. Matcher m = RegexUtils.matcher("\\d{4}(.)\\d{2}(.)\\d{2}(.?)", dateStr);
  901. if (m.find()) {
  902. Set<String> set = new HashSet<>();
  903. set.add(m.group(1));
  904. set.add(m.group(2));
  905. if (StringUtils.isNotEmpty(m.group(3))) {
  906. set.add(m.group(3));
  907. }
  908. if (!set.isEmpty()) {
  909. for (String str : set) {
  910. dateStr = dateStr.replace(str, "-");
  911. }
  912. }
  913. }
  914. }
  915. Date datetime = null;
  916. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
  917. try {
  918. datetime = dateFormat.parse(dateStr);
  919. } catch (ParseException e) {
  920. e.printStackTrace();
  921. }
  922. return datetime;
  923. }
  924. public static Date parseDate(Object date, String format) {
  925. if (date instanceof Date) {
  926. return (Date) date;
  927. }
  928. if (date == null || StringUtils.isEmpty(format)) {
  929. return null;
  930. }
  931. String dateStr = date.toString();
  932. if (!dateStr.toString().contains("-")) {
  933. Matcher m = RegexUtils.matcher("\\d{4}(.)\\d{2}(.)\\d{2}(日?)", dateStr);
  934. if (m.find()) {
  935. Set<String> set = new HashSet<>();
  936. set.add(m.group(1));
  937. set.add(m.group(2));
  938. if (StringUtils.isNotEmpty(m.group(3))) {
  939. dateStr = dateStr.replace(m.group(3), "");
  940. }
  941. if (!set.isEmpty()) {
  942. for (String str : set) {
  943. dateStr = dateStr.replace(str, "-");
  944. }
  945. }
  946. }
  947. }
  948. Date datetime = null;
  949. SimpleDateFormat dateFormat = new SimpleDateFormat(format);
  950. try {
  951. datetime = dateFormat.parse(dateStr);
  952. } catch (ParseException e) {
  953. e.printStackTrace();
  954. }
  955. return datetime;
  956. }
  957. public static String handleNull(Object obj) {
  958. if (null == obj) {
  959. return "";
  960. } else {
  961. return obj.toString().trim();
  962. }
  963. }
  964. /**
  965. * @return java.lang.Object
  966. * @Description 返回时间间隔差
  967. * @Param [t1:开始时间, t2:结束时间, mode:返回值单位:Y年 M月 D日 H时 m分,scale:保留小数位, format:输入日期格式]
  968. * @Author yangyj
  969. * @Date 2021.07.01 09:57
  970. **/
  971. public static Object timePassed(Object t1, Object t2, Object mode, Object scale, Object format) {
  972. List<Object> result=new ArrayList<>();
  973. if (t1 != null && t2 != null && StringUtils.isNotEmpty(mode) && StringUtils.isNotEmpty(scale) && StringUtils.isNotEmpty(format)) {
  974. LinkedList<Object> list1,list2;
  975. if(t1 instanceof List){
  976. list1 = new LinkedList<Object>((List) t1);
  977. }else{
  978. list1= new LinkedList<>();
  979. list1.add(t1);
  980. }
  981. if(t2 instanceof List){
  982. list2 = new LinkedList<Object>((List) t2);
  983. }else{
  984. list2= new LinkedList<>();
  985. list2.add(t2);
  986. }
  987. int n =Math.max(list1.size(),list2.size());
  988. for(int i=0;i<n;i++){
  989. Object o1=list1.size()>i?list1.get(i):list1.getLast();
  990. Object o2=list2.size()>i?list2.get(i):list2.getLast();
  991. long range=timeStamp(o1,o2);
  992. long r = 0;
  993. if (StringUtils.isEquals("Y", mode.toString())) {
  994. r = range / (1000L * 3600 * 24 * 365);
  995. } else if (StringUtils.isEquals("M", mode.toString())) {
  996. r = range / (1000L * 3600 * 24 * 30);
  997. } else if (StringUtils.isEquals("D", mode.toString())) {
  998. r = range / (1000L * 3600 * 24);
  999. } else if (StringUtils.isEquals("H", mode.toString())) {
  1000. r = range / (1000L * 3600);
  1001. } else if (StringUtils.isEquals("m", mode.toString())) {
  1002. r = range / (1000L * 60);
  1003. }
  1004. BigDecimal b = new BigDecimal(r);
  1005. if (!StringUtils.isNumber(scale)) {
  1006. scale = 0;
  1007. }
  1008. if(BigDecimal.ZERO.equals(b)){
  1009. result.add("");
  1010. }else {
  1011. result.add(b.setScale(Integer.parseInt(scale.toString()), ROUND_HALF_UP));
  1012. }
  1013. }
  1014. }
  1015. return result;
  1016. }
  1017. public static long timeStamp(Object t1,Object t2){
  1018. if(StringUtils.isNotEmpty(t1,t2)) {
  1019. String s1 = t1.toString();
  1020. String s2 = t2.toString();
  1021. List<Integer> lsa1= Arrays.stream(s1.replaceAll("[\\s]+","").replaceAll("[\\D]+$","").split("[\\D]+")).map(Integer::parseInt).collect(Collectors.toList());
  1022. List<Integer> lsa2= Arrays.stream(s2.replaceAll( "[\\s]+","").replaceAll("[\\D]+$", "").split("[\\D]+")).map(Integer::parseInt).collect(Collectors.toList());
  1023. return list2Stamp(lsa2)-list2Stamp(lsa1);
  1024. }
  1025. return 0;
  1026. }
  1027. public static long list2Stamp(List<Integer>list){
  1028. LocalDateTime localDateTime;
  1029. if(list.size()>=5&&list.size()<=7){
  1030. localDateTime=LocalDateTime.of(list.get(0),list.get(1),list.get(2),list.get(3),list.get(4),0,0);
  1031. }else if(list.size()==3){
  1032. localDateTime=LocalDateTime.of(list.get(0),list.get(1),list.get(2),0,0,0,0);
  1033. }else if(list.size()==2){
  1034. localDateTime=LocalDateTime.now().withHour(list.get(0)).withMinute(list.get(1)).withSecond(0).withNano(0);
  1035. }else{
  1036. localDateTime= LocalDateTime.now();
  1037. }
  1038. return localDateTime.atZone(java.time.ZoneOffset.UTC)
  1039. .toInstant()
  1040. .toEpochMilli();
  1041. }
  1042. public static Object k2d(Object k) {
  1043. Matcher mt = RegexUtils.matcher("[A-Z]*(\\d*)\\+([\\d|\\.]*)", k.toString());
  1044. if (mt.find()) {
  1045. return Double.parseDouble(mt.group(1)) * 1000 + Double.parseDouble(mt.group(2));
  1046. }
  1047. return -1;
  1048. }
  1049. /**
  1050. * @return java.lang.Object
  1051. * @Description 开方
  1052. * @Param [a:被开方数, scale:结果的小数位]
  1053. * @Author yangyj
  1054. * @Date 2020.12.10 15:10
  1055. **/
  1056. public static Object sqrt(Object a) {
  1057. if (StringUtils.isNumber(a)) {
  1058. return Math.sqrt(Double.parseDouble(a.toString()));
  1059. }
  1060. return "";
  1061. }
  1062. /**
  1063. * @return java.lang.Object
  1064. * @Description 平方
  1065. * @Param [a:开方数, scale:结果的小数位]
  1066. * @Author yangyj
  1067. * @Date 2020.12.10 15:10
  1068. **/
  1069. public static Object pow(Object a, Object b) {
  1070. if (StringUtils.isNumber(a) && StringUtils.isNumber(b)) {
  1071. return Math.pow(Double.parseDouble(a.toString()), Double.parseDouble(b.toString()));
  1072. }
  1073. return "";
  1074. }
  1075. public static Object pow(Object a) {
  1076. if (StringUtils.isNumber(a)) {
  1077. return Math.pow(Double.parseDouble(a.toString()), 2);
  1078. }
  1079. return "";
  1080. }
  1081. /**
  1082. * @return java.lang.Object
  1083. * @Description 立方
  1084. * @Param [base]
  1085. * @Author yangyj
  1086. * @Date 2022.06.24 16:48
  1087. **/
  1088. public static Object cube(Object base) {
  1089. return pow(base, 3);
  1090. }
  1091. /**
  1092. * @return java.util.List<java.lang.Object>
  1093. * @Description 生成用户指定范围实测值
  1094. * @Param [n 数量, design 设计值, scope 偏差范围, rate 合格率0~1, scale保留小数位]
  1095. * @Author yangyj
  1096. * @Date 2021.08.27 14:47
  1097. **/
  1098. public static List<Object> cmv(Object n, Object design, Object scope, Object rate, Object scale) {
  1099. if (StringUtils.isNotEmpty(n) && StringUtils.isNotEmpty(design) && StringUtils.isNotEmpty(scope) && StringUtils.isNotEmpty(rate) && StringUtils.isNotEmpty(scale)) {
  1100. return rangeList(n, design, scope, 1, scale, rate);
  1101. }
  1102. return null;
  1103. }
  1104. /**
  1105. * @return java.lang.Object
  1106. * @Description 累加器
  1107. * @Param [scale:保留小数位, args:累加对象,支持动态数量]
  1108. * @Author yangyj
  1109. * @Date 2021.05.18 10:40
  1110. **/
  1111. public static Object _sumObj(Object scale, Object... args) {
  1112. double result = 0d;
  1113. boolean flag = false;
  1114. for (Object obj : args) {
  1115. if (StringUtils.isNotEmpty(obj) && StringUtils.isNumber(obj)) {
  1116. result += Double.parseDouble(obj.toString());
  1117. flag = true;
  1118. }
  1119. }
  1120. if (flag) {
  1121. BigDecimal r = new BigDecimal(result);
  1122. return r.setScale((int) Double.parseDouble(scale.toString()), ROUND_HALF_UP);
  1123. }
  1124. return "";
  1125. }
  1126. /**
  1127. * @return java.lang.Object
  1128. * @Description 空白或者/都判断为空
  1129. * @Param [data]
  1130. * @Author yangyj
  1131. * @Date 2022.04.01 15:04
  1132. **/
  1133. public static Object isNotEmpty(Object data) {
  1134. List<Object> list = obj2List(data);
  1135. return list.stream().map(StringUtils::handleNull).anyMatch(e -> !e.contains("/"));
  1136. }
  1137. public static Object isPass(Object data) {
  1138. List<Object> list = obj2List(data);
  1139. return list.stream().map(StringUtils::handleNull).map(e -> !e.contains("/") && StringUtils.isNotEmpty(e) ? "合格" : "").collect(Collectors.toList());
  1140. }
  1141. public static List<Object> b445check(List<Object> data, Object designs, Object dev, Object xN) {
  1142. return b445check(data, designs, dev, xN, null);
  1143. }
  1144. /**
  1145. * @return [共检数量, 合格数量, 不合格数量...]
  1146. * @Description 河南项目检查结果
  1147. * @Param [data, designs, dev, xN, hz]
  1148. * @Author yangyj
  1149. * @Date 2022.08.01 11:06
  1150. **/
  1151. public static List<Object> b445check(List<Object> data, Object designs, Object dev, Object xN, Object hz) {
  1152. List<Object> result = new ArrayList<>();
  1153. designs = designFormat(designs);
  1154. if (StringUtils.isNotEmpty(data, designs, dev)) {
  1155. if (StringUtils.isEmpty(xN)) {
  1156. /*偏差范围单位转换倍率默认是1*/
  1157. /*同一个项目偏差范围单位理应一样,所以不用考虑多个值的情况*/
  1158. xN = 1;
  1159. }
  1160. if (StringUtils.handleNull(designs).contains("/")) {
  1161. /*多个设计值*/
  1162. String[] designArr = designs.toString().split("/");
  1163. String[] devArr = dev.toString().split("/");
  1164. AtomicInteger total = new AtomicInteger();
  1165. AtomicInteger pass = new AtomicInteger();
  1166. List<List<Object>> dl = dataSpaceSplit(data);
  1167. if(dl.size()==designArr.length){
  1168. for (int i = 0; i < designArr.length; i++) {
  1169. Object[] obs = ck(dl.size() > i ? dl.get(i) : dl.get(dl.size() - 1), designArr[i], devArr.length > i ? devArr[i] : devArr[devArr.length - 1], xN);
  1170. total.addAndGet(StringUtils.handleObj2Integer(obs[0]));
  1171. pass.addAndGet(StringUtils.handleObj2Integer(obs[1]));
  1172. }
  1173. }else{
  1174. List<Object> designList=Arrays.asList(designArr);
  1175. /*依次计算偏差挑选最佳设计值,并根据设计值分组,然后在计算是否合格*/
  1176. Function<Object,Object> fc=d-> designList.stream().reduce(Double.MAX_VALUE, (p, n) -> offRangeSum(CustomFunction.dXd(p, d,1,3)) < offRangeSum(CustomFunction.dXd(n, d,1,3)) ? p : n);
  1177. Map<Integer,List<Object>> group=data.stream().filter(StringUtils::isNotEmpty).collect(Collectors.groupingBy(x->designList.indexOf(fc.apply(x))));
  1178. Object finalXN = xN;
  1179. group.forEach((k, v)->{
  1180. Object[] obs = ck(v, designArr[k], devArr.length > k ? devArr[k] : devArr[devArr.length - 1], finalXN);
  1181. total.addAndGet(StringUtils.handleObj2Integer(obs[0]));
  1182. pass.addAndGet(StringUtils.handleObj2Integer(obs[1]));
  1183. });
  1184. }
  1185. if (total.get() > 0) {
  1186. result.add(total);
  1187. result.add(pass);
  1188. result.add(total.get() - pass.get());
  1189. }
  1190. } else {
  1191. Object[] target = ck(data, designs, dev, xN);
  1192. if (StringUtils.handObj2Integer(target[0]) > 0) {
  1193. result.add(target[0]);
  1194. result.add(target[1]);
  1195. result.add(StringUtils.handObj2Integer(target[0]) - StringUtils.handObj2Integer(target[1]));
  1196. }
  1197. }
  1198. } else if (ListUtils.isNotEmpty(data)) {
  1199. if (data.parallelStream().anyMatch(StringUtils::isNotEmpty)) {
  1200. data = data.parallelStream().filter(StringUtils::isNotEmpty).collect(Collectors.toList());
  1201. result.add(data.size());
  1202. result.add(data.size());
  1203. result.add(0);
  1204. }
  1205. }
  1206. if (result.size() == 0) {
  1207. result.addAll(Collections.nCopies(3, ""));
  1208. }
  1209. return result;
  1210. }
  1211. /* public static void main(String[] args) {
  1212. List<Object> list = Arrays.asList(29,30);
  1213. b445check(list,"0","-30,30",1).forEach(System.out::println);
  1214. }*/
  1215. public static Object designFormat(Object design){
  1216. if(StringUtils.isNotEmpty(design)){
  1217. if(design instanceof List){
  1218. List<Object> list = (List<Object>) design;
  1219. StringBuffer str = new StringBuffer();
  1220. for(Object o : list){
  1221. if(o == null){
  1222. continue;
  1223. }
  1224. if(o.toString().contains("*")){
  1225. str.append(o).append("/");
  1226. }else{
  1227. String collect = Arrays.stream(o.toString().split("[^\\d.-]")).filter(StringUtils::isNotEmpty).collect(Collectors.joining("/"));
  1228. if(StringUtils.isNotEmpty(collect)){
  1229. str.append(collect).append("/");
  1230. }
  1231. }
  1232. }
  1233. return str;
  1234. }else{
  1235. return Arrays.stream(design.toString().split("[^\\d.\\-*]")).filter(StringUtils::isNotEmpty).collect(Collectors.joining("/"));
  1236. }
  1237. }
  1238. return "";
  1239. }
  1240. public static double offRangeSum(Object o){
  1241. if(o.equals(Double.MAX_VALUE)){
  1242. return Double.MAX_VALUE;
  1243. }
  1244. return Arrays.stream(o.toString().split("[^0-9.\\-]")).mapToDouble(e->Math.pow(Double.parseDouble(e),2)).sum();
  1245. }
  1246. public static List<List<Object>> dataSpaceSplit(List<Object> data) {
  1247. List<List<Object>> result = new ArrayList<>();
  1248. if (ListUtils.isNotEmpty(data)) {
  1249. List<Double> list= data.stream().filter(StringUtils::isNumber).map(x->Double.parseDouble(x.toString())).collect(Collectors.toList());
  1250. List<List<Double>> target=segmentList(list);
  1251. result=target.stream().map(l->l.stream().collect(Collectors.toCollection((Supplier<ArrayList<Object>>) ArrayList::new))).collect(Collectors.toList());
  1252. }
  1253. return result;
  1254. }
  1255. static List<List<Double>> segmentList(List<Double> inputList) {
  1256. List<List<Double>> segments = new ArrayList<>();
  1257. List<Double> currentSegment = new ArrayList<>();
  1258. inputList.forEach(number -> {
  1259. if (currentSegment.isEmpty() || shouldSplit(currentSegment, number)) {
  1260. if (!currentSegment.isEmpty()) {
  1261. segments.add(new ArrayList<>(currentSegment));
  1262. }
  1263. currentSegment.clear();
  1264. }
  1265. currentSegment.add(number);
  1266. });
  1267. if (!currentSegment.isEmpty()) {
  1268. segments.add(new ArrayList<>(currentSegment));
  1269. }
  1270. return segments;
  1271. }
  1272. static boolean shouldSplit(List<Double> segment, double number) {
  1273. if (segment.isEmpty()) {
  1274. return false;
  1275. }
  1276. double lastNumber = segment.get(segment.size() - 1);
  1277. double difference = Math.abs((number - lastNumber) / lastNumber);
  1278. return difference > 0.2 || difference > ((double) 50 / 100.0);
  1279. }
  1280. public static List<Object> listTrim(List<Object> list) {
  1281. List<Object> result = new ArrayList<>();
  1282. if (ListUtils.isNotEmpty(list)) {
  1283. int end = list.size();
  1284. for (int i = list.size() - 1; i >= 0; i--) {
  1285. if (StringUtils.isNotEmpty(list.get(i)) || i == 0) {
  1286. end = i + 1;
  1287. break;
  1288. }
  1289. }
  1290. int start = 0;
  1291. for (int i = 0; i < list.size(); i++) {
  1292. if (StringUtils.isNotEmpty(list.get(i))) {
  1293. start = i;
  1294. break;
  1295. }
  1296. }
  1297. return list.subList(start, end);
  1298. }
  1299. return result;
  1300. }
  1301. public static final String ELE_CODE_REG = "(?<=E\\[)[^]]+(?=\\])";
  1302. public static final Pattern P = Pattern.compile(ELE_CODE_REG);
  1303. public static List<String> parseElementCode(String s) {
  1304. List<String> result = new ArrayList<>();
  1305. Matcher m = P.matcher(s);
  1306. while (m.find()) {
  1307. result.add(m.group().replace("'", ""));
  1308. }
  1309. return result;
  1310. }
  1311. public static String coefficient(String dev, double xN) {
  1312. if (StringUtils.isNotEmpty(dev) && xN != 1) {
  1313. String[] da = dev.split("[,,]");
  1314. int scale = StringUtils.getScale(xN);
  1315. dev = StringUtils.number2StringZero(Double.parseDouble(da[0]) * xN, scale) + "," + StringUtils.number2StringZero(Double.parseDouble(da[1]) * xN, scale);
  1316. }
  1317. return dev;
  1318. }
  1319. public static List<Object> b445random(Object hz, Object design, Object dev, Object failed, Object xN) {
  1320. List<Object> measureOut = new ArrayList<>();
  1321. String hzStr = StringUtils.handleNull(hz);
  1322. String designStr = StringUtils.handleNull(design);
  1323. String deviationStr = StringUtils.handleNull(dev);
  1324. if (StringUtils.isNotEmpty(hzStr, designStr, deviationStr)) {
  1325. String passStr = StringUtils.handleNull(failed);
  1326. if (StringUtils.isEmpty(passStr)) {
  1327. passStr = "0";
  1328. }
  1329. String[] rateIn = hzStr.split("/");
  1330. rateIn = Arrays.stream(rateIn).filter(StringUtils::isNotEmpty).toArray(String[]::new);
  1331. String[] designIn = designStr.split("/");
  1332. designIn = Arrays.stream(designIn).filter(StringUtils::isNotEmpty).toArray(String[]::new);
  1333. String[] deviationIn = deviationStr.split("/");
  1334. deviationIn = Arrays.stream(deviationIn).filter(StringUtils::isNotEmpty).toArray(String[]::new);
  1335. if (xN != null) {
  1336. deviationIn = Arrays.stream(deviationIn).map(e -> coefficient(e, Double.parseDouble(xN.toString()))).toArray(String[]::new);
  1337. }
  1338. String[] passIn = passStr.split("/");
  1339. passIn = Arrays.stream(passIn).filter(StringUtils::isNotEmpty).toArray(String[]::new);
  1340. if (designIn.length > 0) {
  1341. for (int i = 0; i < designIn.length; i++) {
  1342. String e = designIn[i];
  1343. int _hz = Integer.parseInt(i < rateIn.length ? rateIn[i] : rateIn[rateIn.length - 1]);
  1344. String _deviation = i < deviationIn.length ? deviationIn[i] : deviationIn[deviationIn.length - 1];
  1345. String _pass = i < passIn.length ? passIn[i] : passIn[passIn.length - 1];
  1346. int _scale = StringUtils.getScaleZero(e, _deviation);
  1347. String delimiter = StringUtils.handleNull(matcherFindGroup("[^0-9.]", e, 0, false));
  1348. if (StringUtils.isEmpty(delimiter)) {
  1349. delimiter = CONCAT;
  1350. }
  1351. String[] _des = e.split("[" + delimiter + "]");
  1352. List<Object> _tmp = new ArrayList<>();
  1353. for (String _de : _des) {
  1354. List<Object> list;
  1355. double passD = Double.parseDouble(_pass);
  1356. /**大于0小于1则表示合格率,否则是不合格数量*/
  1357. double rate = (0 < passD && passD < 1) ? passD : (_hz - passD) / _hz;
  1358. list = cmv(_hz, _de, _deviation, rate, _scale);
  1359. if (ListUtils.isNotEmpty(list)) {
  1360. if (list.size() > _tmp.size()) {
  1361. _tmp.addAll(list);
  1362. } else {
  1363. for (int n = 0; n < _tmp.size(); n++) {
  1364. /*假如设计值是DxD1这种形式,则需要把生成的实测值拼接起来*/
  1365. _tmp.set(n, StringUtils.join(_tmp.get(n), list.get(n), delimiter));
  1366. }
  1367. }
  1368. }
  1369. }
  1370. measureOut.addAll(_tmp);
  1371. }
  1372. }
  1373. }
  1374. return measureOut;
  1375. }
  1376. /* public static void main(String[] args) {
  1377. List<Object> list = Arrays.asList("-9*5","2*3");
  1378. checkpoints(list,"",0,"±5",1);
  1379. }*/
  1380. /**
  1381. * @return java.lang.Object
  1382. * @Description 共检点合格点公式
  1383. * @Param [data 数据, remark超出10个后的提示, design实际值, dev偏差值]
  1384. * @Author yangyj
  1385. * @Date 2022.02.11 10:09
  1386. **/
  1387. public static Object checkpoints(Object data, Object remark, Object design, Object dev, Object xN) {
  1388. if (data != null) {
  1389. if (data instanceof String && ((String) data).contains("NumberFormatException")) {
  1390. return data;
  1391. }
  1392. Object[] R = ck(data, design, dev, xN);
  1393. if (R[0] != null && R[1] != null && R[2] != null) {
  1394. int checkpoints = Integer.parseInt(R[0].toString());
  1395. int passpoints = Integer.parseInt(R[1].toString());
  1396. List<Object> result = (List<Object>) R[2];
  1397. boolean over = checkpoints > result.size();
  1398. if (checkpoints <= 0) {
  1399. return "/";
  1400. } else if (ListUtils.isNotEmpty(result) && result.size() <= 10 && !over) {
  1401. result = result.stream().map(obj -> {
  1402. if (StringUtils.isNumber(obj)) {
  1403. if (obj.toString().contains(".")) {
  1404. BigDecimal big = new BigDecimal(obj.toString());
  1405. String s = big.toString();
  1406. return s.replaceAll("(0+|\\.0+)$", "");
  1407. }
  1408. }
  1409. return obj;
  1410. }).collect(Collectors.toList());
  1411. return join(result, "、");
  1412. } else {
  1413. if (StringUtils.isEmpty(remark)) {
  1414. remark = "共检点,合格点";
  1415. }
  1416. return remark.toString().replace("共检", "共检" + checkpoints).replace("合格", "合格" + passpoints);
  1417. }
  1418. }
  1419. }
  1420. return "/";
  1421. }
  1422. public static Object[] ck(Object data, Object design, Object dev, Object xN) {
  1423. Object[] r = new Object[3];
  1424. List<Object> result = new ArrayList<>();
  1425. List<Object> datas = obj2List(removeEmpty(data));
  1426. if (ListUtils.isNotEmpty(datas)) {
  1427. int checkpoints = 0;
  1428. int passpoints = 0;
  1429. List<Object> designList = obj2List(design);
  1430. if (ListUtils.isNotEmpty(designList)) {
  1431. design = designList.get(0);
  1432. }
  1433. for (Object e : datas) {
  1434. String s = handleNull(e);
  1435. if (StringUtils.isNotEmpty(s)) {
  1436. if (containsZH(s)) {
  1437. Matcher m = RegexUtils.matcher("[\u4e00-\u9fa5]+(\\d+)\\D*合格(\\d+)\\D+", s);
  1438. if (m.find()) {
  1439. checkpoints += Integer.parseInt(m.group(1));
  1440. passpoints += Integer.parseInt(m.group(2));
  1441. }
  1442. } else {
  1443. result.add(s);
  1444. }
  1445. }
  1446. }
  1447. result = result.stream().map(StringUtils::handleNull).map(String::trim).filter(e -> !StringUtils.isEquals("/", e)).collect(Collectors.toList());
  1448. if (result.size() > 0) {
  1449. List<Object> pl = passList(design, dev, result, xN);
  1450. passpoints += pl.size();
  1451. result = obj2List(result);
  1452. checkpoints += result.size();
  1453. } else {
  1454. System.out.println();
  1455. }
  1456. r[0] = checkpoints;
  1457. r[1] = passpoints;
  1458. r[2] = result;
  1459. }
  1460. return r;
  1461. }
  1462. public static Object tree(List<WbsTreeContract> treeNodes, String param,Integer type) {
  1463. if (CollectionUtil.isNotEmpty(treeNodes) && Func.isNotBlank(param)&&RegexUtil.match(ParamElements.LEVEL_REG, param.trim())) {
  1464. List<WbsTreeContract> nodes = new ArrayList<>(treeNodes);
  1465. List<String> result = new ArrayList<>();
  1466. param = param.trim().replaceAll("(?i:c)", "");
  1467. List<String> list = Arrays.asList(param.split("[^.\\d]"));
  1468. List<Integer> index = list.stream().map(Integer::parseInt).collect(Collectors.toList());
  1469. if(type==1){
  1470. for (Integer i : index) {
  1471. if (i < nodes.size()) {
  1472. result.add(nodes.get(i).getNodeName());
  1473. }
  1474. }
  1475. }else {
  1476. Map<Integer, String> map = nodes.stream()
  1477. .collect(Collectors.toMap(
  1478. WbsTreeContract::getNodeType,
  1479. WbsTreeContract::getNodeName,
  1480. (existing, replacement) -> replacement // 如果键重复,保留后者
  1481. ));
  1482. for (Integer i : index) {
  1483. if(i==0){
  1484. if(map.containsKey(1)){
  1485. result.add(map.get(1));
  1486. }
  1487. }
  1488. else if(i==1){
  1489. if(map.containsKey(18)){
  1490. result.add(map.get(18));
  1491. }
  1492. }else {
  1493. if(map.containsKey(i)){
  1494. result.add(map.get(i));
  1495. }
  1496. }
  1497. }
  1498. }
  1499. return String.join("", result);
  1500. }
  1501. return param;
  1502. }
  1503. public static Object tableNames(List<String> treeNodes) {
  1504. if (CollectionUtil.isNotEmpty(treeNodes)) {
  1505. List<String> nodes = new ArrayList<>(treeNodes);
  1506. return nodes.stream().filter(StringUtils::isNotEmpty).map(e -> e.replaceAll("[\\s]+|_(PL)?_\\d+$", "")).distinct().collect(Collectors.joining("\n"));
  1507. }
  1508. return "";
  1509. }
  1510. public static Object qrate(Object design, Object dev, Object data) {
  1511. return qrate(design, dev, data, 0, 1);
  1512. }
  1513. public static Object qrate(Object design, Object dev, Object data, Object scale) {
  1514. return qrate(design, dev, data, scale, 1);
  1515. }
  1516. /**
  1517. * @return java.lang.Object
  1518. * @Description Qualified rate of measured value 计算合格率
  1519. * @Param [design: 设计值, dev:偏差范围或规定值, xN:偏差值单位转设计值单位倍率, data:数据, scale:保留小数位]
  1520. * @Author yangyj
  1521. * @Date 2022.01.14 09:56
  1522. **/
  1523. public static Object qrate(Object design, Object dev, Object data, Object scale, Object xN) {
  1524. if (data != null && StringUtils.isNotEmpty(design, dev, xN)) {
  1525. Object[] R = ck(data, design, dev, xN);
  1526. if (R[0] != null && R[1] != null && Math.abs(Double.parseDouble(R[0].toString())) > 0) {
  1527. String result = StringUtils.number2String(Double.parseDouble(R[1].toString()) * 100 / Double.parseDouble(R[0].toString()), scale);
  1528. if (result.contains(".")) {
  1529. result = result.replaceAll("(0+|\\.0+)$", "");
  1530. }
  1531. return result;
  1532. }
  1533. }
  1534. return "";
  1535. }
  1536. public static Object easyRate(Object data) {
  1537. if (null != data) {
  1538. List<Object> datas = obj2List(data);
  1539. if (datas.stream().anyMatch(CustomFunction::containsZH)) {
  1540. return 100;
  1541. }
  1542. }
  1543. return "";
  1544. }
  1545. /**
  1546. * @return java.lang.Object
  1547. * @Description 检查内容
  1548. * @Param [items, names]
  1549. * @Author yangyj
  1550. * @Date 2023.02.24 14:56
  1551. **/
  1552. public static Object checkContent(Object items, Object names) {
  1553. if (items != null && names != null) {
  1554. List<Object> result = new ArrayList<>();
  1555. List<Object> content = obj2List(items);
  1556. List<Object> list = obj2List(names);
  1557. for (int i = 0; i < list.size(); i++) {
  1558. Object cp = content.get(i);
  1559. if (StringUtils.isNotEmpty(cp) && StringUtils.isNotEquals("/", cp)) {
  1560. result.add(list.get(i));
  1561. }
  1562. }
  1563. if (ListUtils.isNotEmpty(result)) {
  1564. return result.stream().map(StringUtils::handleNull).collect(Collectors.joining(StringPool.COMMA));
  1565. }
  1566. }
  1567. return "";
  1568. }
  1569. /**
  1570. * @return java.lang.Object
  1571. * @Description 筛选合格的部分
  1572. * @Param [design, dev, data, xN]
  1573. * @Author yangyj
  1574. * @Date 2022.02.12 13:59
  1575. **/
  1576. public static List<Object> passList(Object design, Object dev, Object data, Object xN) {
  1577. List<Object> result = new ArrayList<>();
  1578. List<Object> datas = obj2List(data);
  1579. datas = (List<Object>) removeEmpty(datas);
  1580. Double[] range = scopeParse(dev, design, xN);
  1581. assert range != null;
  1582. double finalMin = range[0];
  1583. double finalMax = range[1];
  1584. List<Object> l1 = datas.stream().map(StringUtils::handleNull).filter(e -> e.contains("*") || e.contains("X") || e.contains("x") || e.contains("×") || e.contains("/")).collect(Collectors.toList());
  1585. if (ListUtils.isNotEmpty(l1)) {
  1586. for (Object obj : l1) {
  1587. String[] arr = obj.toString().split("[×xX*/]");
  1588. if (Arrays.stream(Arrays.stream(arr).toArray()).allMatch(StringUtils::isNumber)) {
  1589. if (Arrays.stream(Arrays.stream(arr).toArray()).map(StringUtils::handleNull).map(Double::parseDouble).noneMatch(e -> e > finalMax || e < finalMin)) {
  1590. result.add(obj);
  1591. }
  1592. }
  1593. }
  1594. }
  1595. List<Object> l2 = datas.stream().filter(StringUtils::isNumber).map(StringUtils::handleNull).map(Double::parseDouble).filter(e -> e <= finalMax && e >= finalMin).collect(Collectors.toList());
  1596. if (ListUtils.isNotEmpty(l2)) {
  1597. result.addAll(l2);
  1598. }
  1599. return result;
  1600. }
  1601. /* public static void main(String[] args) {
  1602. Double[] a = scopeParse("≤5",0,1);
  1603. Double[] b = scopeParse("≦5",0,1);
  1604. Double[] c = scopeParse("≤5",0,1);
  1605. System.out.println(a);
  1606. }*/
  1607. public static Double[] scopeParse(Object dev, Object design, Object xN) {
  1608. if (StringUtils.isNotEmpty(dev)) {
  1609. Double[] result = new Double[2];
  1610. double designD = Double.parseDouble(design.toString());
  1611. double xND = Double.parseDouble(xN.toString());
  1612. String devStr = dev.toString();
  1613. devStr = devStr.replaceAll("[\\[\\]]+", "");
  1614. double min = 0;
  1615. double max = 0;
  1616. devStr = devStr.replaceAll("\\s+", "");
  1617. if (devStr.contains("≤") || devStr.contains("<=") || devStr.contains("<")||devStr.contains("≦")) {
  1618. devStr = devStr.replace("≤", "").replace("<=", "").replace("≦","");
  1619. max = designD + Double.parseDouble(devStr) * xND;
  1620. } else if (devStr.contains("≥") || devStr.contains(">=") || devStr.contains(">")) {
  1621. devStr = devStr.replace("≥", "").replace(">=", "");
  1622. min = designD + Double.parseDouble(devStr) * xND;
  1623. max = Double.MAX_VALUE;
  1624. } else if (devStr.contains(",") || devStr.contains(",")) {
  1625. String[] arr = devStr.split("[,,]");
  1626. min = designD + Double.parseDouble(arr[0]) * xND;
  1627. max = designD + Double.parseDouble(arr[1]) * xND;
  1628. } else if (devStr.contains("%")) {
  1629. devStr = devStr.replace("%", "");
  1630. double devD = Math.abs(Double.parseDouble(devStr) * designD / 100);
  1631. min = designD - devD;
  1632. max = designD + devD;
  1633. } else if (devStr.contains("±")) {
  1634. devStr = devStr.replace("±", "");
  1635. double devD = Math.abs(Double.parseDouble(devStr) * xND);
  1636. min = designD - devD;
  1637. max = designD + devD;
  1638. }
  1639. if(min>max){
  1640. double tmp=max;
  1641. max=min;
  1642. min=tmp;
  1643. }
  1644. result[0] = min;
  1645. result[1] = max;
  1646. return result;
  1647. }
  1648. return null;
  1649. }
  1650. /**
  1651. * @return java.util.List<java.lang.Object> 不能包含0
  1652. * @Description specifiedRangeList
  1653. * @Param [hz:频率, design:设计值, dev:偏差范围, xN 偏差范围单位和设计值单位的比值,例如毫米:厘米=0.1, scale:保存小数位, passRate:合格率[0,1]]
  1654. * @Author yangyj
  1655. * @Date 2022.03.31 09:16
  1656. **/
  1657. public static List<Object> rangeList(Object hz, Object design, Object dev, Object xN, Object scale, Object passRate) {
  1658. List<Object> result = new ArrayList<>();
  1659. if (StringUtils.isNotEmpty(design, dev, hz)) {
  1660. if (StringUtils.isEmpty(scale)) {
  1661. scale = 0;
  1662. }
  1663. if (StringUtils.isEmpty(passRate)) {
  1664. passRate = 1;
  1665. }
  1666. if (StringUtils.isEmpty(xN)) {
  1667. xN = 1;
  1668. }
  1669. Double[] range = scopeParse(dev, design, xN);
  1670. int scaleI = Integer.parseInt(scale.toString());
  1671. int min = 0, max = 0;
  1672. assert range != null;
  1673. if (range.length > 0) {
  1674. min = (int) (range[0] * Math.pow(10, scaleI));
  1675. max = (int) (range[1] * Math.pow(10, scaleI));
  1676. }
  1677. Random rd = new Random();
  1678. int hzi = new BigDecimal(hz.toString()).multiply(new BigDecimal(passRate.toString())).setScale(0, ROUND_CEILING).intValue();
  1679. int loop=200;
  1680. for (int i = 0; i < hzi; i++) {
  1681. BigDecimal tb = new BigDecimal(rd.nextInt(max - min + 1) + min).divide(BigDecimal.valueOf(Math.pow(10, scaleI)), scaleI, ROUND_HALF_UP);
  1682. if(tb.compareTo(BigDecimal.ZERO)==0&&loop>0){
  1683. loop--;
  1684. i--;
  1685. }else{
  1686. if (scaleI > 0) {
  1687. result.add(tb.doubleValue());
  1688. } else {
  1689. result.add(tb.intValue());
  1690. }
  1691. }
  1692. }
  1693. int total = StringUtils.handleObj2Integer(hz);
  1694. if (total - hzi > 0) {
  1695. loop=200;
  1696. for (int k = 0; k < total - hzi; k++) {
  1697. BigDecimal tb;
  1698. /*保证salt是大于等于1的正整数*/
  1699. int salt=Math.max(1,(max - min) / 2);
  1700. if (rd.nextBoolean()) {
  1701. /*tb = new BigDecimal(rd.nextInt(((max - min) / 2)) + max + 1).divide(BigDecimal.valueOf(Math.pow(10, scaleI)), scaleI, ROUND_HALF_UP);*/
  1702. tb = new BigDecimal(rd.nextInt(salt) + max + 1).divide(BigDecimal.valueOf(Math.pow(10, scaleI)), scaleI, ROUND_HALF_UP);
  1703. } else {
  1704. /* tb = new BigDecimal(min - 1 - rd.nextInt(((max - min) / 2))).divide(BigDecimal.valueOf(Math.pow(10, scaleI)), scaleI, ROUND_HALF_UP);*/
  1705. tb = new BigDecimal(min - 1 - rd.nextInt(salt)).divide(BigDecimal.valueOf(Math.pow(10, scaleI)), scaleI, ROUND_HALF_UP);
  1706. }
  1707. if(tb.compareTo(BigDecimal.ZERO)==0&&loop>0){
  1708. loop--;
  1709. k--;
  1710. }else {
  1711. if (scaleI > 0) {
  1712. result.add(tb.doubleValue());
  1713. } else {
  1714. result.add(tb.intValue());
  1715. }
  1716. }
  1717. }
  1718. if (ListUtils.isNotEmpty(result)) {
  1719. Collections.shuffle(result);
  1720. }
  1721. }
  1722. }
  1723. return result;
  1724. }
  1725. /**
  1726. * @return java.util.List<java.lang.Object>
  1727. * @Description obj 转List
  1728. * @Param [obj]
  1729. * @Author yangyj
  1730. * @Date 2022.01.13 15:40
  1731. **/
  1732. public static List<Object> obj2List(Object obj) {
  1733. List<Object> result = new ArrayList<>();
  1734. if (obj != null) {
  1735. List<Object> datas = new ArrayList<>();
  1736. if (obj instanceof List) {
  1737. datas = (List<Object>) obj;
  1738. } else {
  1739. datas.add(obj);
  1740. }
  1741. if (ListUtils.isNotEmpty(datas)) {
  1742. for (Object e : datas) {
  1743. boolean fi = StringUtils.isNotEmpty(e) && !CustomFunction.containsZH(e.toString()) && (e.toString().contains("、") || e.toString().contains(",") || e.toString().contains(" ") || e.toString().contains(","));
  1744. if (fi) {
  1745. String s = e.toString().trim();
  1746. if (s.contains(" ")) {
  1747. s = s.replaceAll("\\s+", "、");
  1748. }
  1749. Object[] bs = s.split("[、,,]");
  1750. result.addAll(Arrays.asList(bs));
  1751. } else {
  1752. result.add(e);
  1753. }
  1754. }
  1755. }
  1756. }
  1757. return result;
  1758. }
  1759. /**
  1760. * @return java.lang.Object
  1761. * @Description 对象转字符串,list取第一个对象
  1762. * @Param [obj]
  1763. * @Author yangyj
  1764. * @Date 2022.02.11 15:14
  1765. **/
  1766. public static Object o2Str(Object obj) {
  1767. String result = "";
  1768. if (obj != null) {
  1769. List<Object> datas = obj2List(obj);
  1770. if (ListUtils.isNotEmpty(datas)) {
  1771. return handleNull(datas.get(0));
  1772. }
  1773. }
  1774. return result;
  1775. }
  1776. public static Object gfn(Object ob1, Object ob2, Object ob3) {
  1777. return _gfn(ob1, ob2, ob3);
  1778. }
  1779. public static Object gfn(Object ob1, Object ob2) {
  1780. return _gfn(ob1, ob2);
  1781. }
  1782. public static Object gfn(List<Object> list) {
  1783. if (ListUtils.isNotEmpty(list)) {
  1784. return _gfn(list.toArray());
  1785. }
  1786. return "";
  1787. }
  1788. /**
  1789. * @Description 返回第一个不为空的对象
  1790. * @Param
  1791. * @Author yangyj
  1792. * @Date 2022.01.04 13:57
  1793. **/
  1794. public static Object _gfn(Object... obs) {
  1795. if (obs != null) {
  1796. for (Object ob : obs) {
  1797. if (ob instanceof List) {
  1798. List<Object> list = obj2List(ob);
  1799. if (ListUtils.isNotEmpty(list) && list.stream().anyMatch(StringUtils::isNotEmpty)) {
  1800. return ob;
  1801. }
  1802. } else if (ob instanceof Map) {
  1803. if (MapUtils.isNotEmpty((Map) ob)) {
  1804. return ob;
  1805. }
  1806. } else {
  1807. if (StringUtils.isNotEmpty(ob) && StringUtils.isNotEquals("/", ob)) {
  1808. return ob;
  1809. }
  1810. }
  1811. }
  1812. }
  1813. return null;
  1814. }
  1815. public Object checkItemName(List<Object> data, List<Object> names) {
  1816. if (ListUtils.isNotEmpty(data) && ListUtils.isNotEmpty(names) && data.size() != names.size()) {
  1817. StringBuilder sb = new StringBuilder();
  1818. for (int i = 0; i < data.size(); i++) {
  1819. List<Object> datas = obj2ListNe(data.get(i));
  1820. if (datas.stream().anyMatch(e -> StringUtils.isNotEmpty(e) && StringUtils.isNotEquals("/", e))) {
  1821. sb.append(names.get(i)).append(",");
  1822. }
  1823. }
  1824. if (sb.length() > 1) {
  1825. sb.deleteCharAt(sb.length() - 1);
  1826. }
  1827. return sb.toString();
  1828. }
  1829. return "";
  1830. }
  1831. /**
  1832. * @return java.lang.Object
  1833. * @Description 三元运算 bool?o1:o2 ,默认返回空字符串
  1834. * @Param [bool, o1, o2]
  1835. * @Author yangyj
  1836. * @Date 2021.01.29 13:54
  1837. **/
  1838. public static Object ifValObj(Object bool, Object o1, Object o2) {
  1839. Boolean fi;
  1840. if (bool instanceof Boolean) {
  1841. fi = (Boolean) bool;
  1842. } else {
  1843. return "";
  1844. }
  1845. return fi ? o1 : o2;
  1846. }
  1847. /*太多写错公式名称的,应该是下面的方法名称比较容易接受*/
  1848. public static Object isValObj(Object bool, Object o1, Object o2) {
  1849. return ifValObj(bool, o1, o2);
  1850. }
  1851. /**
  1852. * @return java.lang.Object
  1853. * @Description 判断o1中是否包含字符串o2
  1854. * @Param [o1, o2]
  1855. * @Author yangyj
  1856. * @Date 2021.01.29 14:04
  1857. **/
  1858. public static Object contains(Object o1, Object o2) {
  1859. if (o1 != null && StringUtils.isNotEmpty(o2)) {
  1860. List<Object> datas = obj2List(o1);
  1861. return datas.stream().map(StringUtils::handleNull).anyMatch(e -> e.contains(o2.toString()));
  1862. }
  1863. return false;
  1864. }
  1865. /**
  1866. * @return java.lang.Object
  1867. * @Description 判断两个对象是否相等
  1868. * @Param [o1, o2]
  1869. * @Author yangyj
  1870. * @Date 2021.08.23 16:51
  1871. **/
  1872. public static Object eq(Object o1, Object o2) {
  1873. return StringUtils.isEquals(o1, o2);
  1874. }
  1875. /**
  1876. * @return java.lang.Object
  1877. * @Description 计算数据集的合格率
  1878. * @Param [list:数据集, design:设计值, dev:偏差范围, scale:保存小数位]
  1879. * @Author yangyj
  1880. * @Date 2021.10.26 09:34
  1881. **/
  1882. public static Object getListTick(Object list, Object design, Object dev, Object scale) {
  1883. if (list != null && design != null && StringUtils.isNotEmpty(dev)) {
  1884. if (!StringUtils.isNumber(scale)) {
  1885. scale = 0;
  1886. }
  1887. Matcher m = RegexUtils.matcher("(-?\\d+(\\.\\d+)?)[h|H]?[,|,](\\+?\\d+(\\.\\d+)?)[h|H]?", dev.toString().replaceAll("[(|)]", ""));
  1888. if (list instanceof List && m.find()) {
  1889. List<Object> arrayList = (ArrayList<Object>) list;
  1890. double tick = 0;
  1891. double designD = Double.parseDouble(handleNull(design));
  1892. double h = 1;
  1893. if (dev.toString().toUpperCase(Locale.ROOT).contains("H")) {
  1894. h = designD;
  1895. }
  1896. for (Object obj : arrayList) {
  1897. double dx = Double.parseDouble(handleNull(obj)) - designD;
  1898. if (Double.parseDouble(m.group(1)) * h <= dx && dx <= Double.parseDouble(m.group(3)) * h) {
  1899. tick++;
  1900. }
  1901. }
  1902. if (tick > 0) {
  1903. BigDecimal a = new BigDecimal(tick);
  1904. BigDecimal b = new BigDecimal(arrayList.size());
  1905. return a.divide(b, 8, ROUND_HALF_UP).multiply(new BigDecimal(100)).setScale(StringUtils.handleObj2Integer(scale.toString()), ROUND_HALF_UP);
  1906. } else {
  1907. return "0";
  1908. }
  1909. }
  1910. }
  1911. return "";
  1912. }
  1913. /**
  1914. * @return java.lang.Object
  1915. * @Description 获取最后一个对象
  1916. * @Param [list]
  1917. * @Author yangyj
  1918. * @Date 2021.08.09 14:37
  1919. **/
  1920. public static Object listAt(Object o, Object indexObj) {
  1921. if (o == null) {
  1922. return "";
  1923. }
  1924. if (o instanceof List) {
  1925. List<Object> list = obj2ListNe(o);
  1926. int index = 0;
  1927. if (NumberUtil.isNumber(indexObj.toString())) {
  1928. index = StringUtils.handObj2Integer(indexObj) - 1;
  1929. } else if (StringUtils.isEquals("last", indexObj) || StringUtils.isEmpty(indexObj)) {
  1930. index = list.size() - 1;
  1931. }
  1932. if (ListUtils.isNotEmpty(list)) {
  1933. if (list.size() > index && index >= 0) {
  1934. return list.get(index);
  1935. } else {
  1936. return list.get(list.size() - 1);
  1937. }
  1938. }
  1939. } else {
  1940. return o.toString();
  1941. }
  1942. return "";
  1943. }
  1944. /**
  1945. * @Description 关键字转换
  1946. * @Param [cn]
  1947. * @Author yangyj
  1948. * @Date 2022.10.10 17:24
  1949. **/
  1950. public static void formulaKeyWord(CalculateNode cn) {
  1951. if (cn.type().equals(Token.OPERATOR_RESULT)) {
  1952. OperatorResultNode opn = (OperatorResultNode) cn;
  1953. formulaKeyWord(opn.getLeftOperand());
  1954. formulaKeyWord(opn.getRightOperand());
  1955. } else if (cn.type().equals(Token.METHOD_RESULT)) {
  1956. StaticObjectMethodNode cmn = (StaticObjectMethodNode) cn;
  1957. CalculateNode[] array = cmn.getArgsNodes();
  1958. if (ArrayUtil.isNotEmpty(array)) {
  1959. for (int i = 0; i < array.length; i++) {
  1960. CalculateNode c = array[i];
  1961. if (c instanceof StaticObjectMethodNode) {
  1962. formulaKeyWord(c);
  1963. } else if (c instanceof VariableNode) {
  1964. if (KEYWORD_SET.contains(c.literals())) {
  1965. /*关键字需要包裹起来*/
  1966. array[i] = new VariableNode("'" + c.literals() + "'");
  1967. }
  1968. }
  1969. }
  1970. }
  1971. cmn.setArgsNodes(array);
  1972. }
  1973. }
  1974. public static List<Object> obj2ListNe(Object obj) {
  1975. List<Object> list = obj2List(obj);
  1976. return list.parallelStream().filter(StringUtils::isNotEmpty).collect(Collectors.toList());
  1977. }
  1978. /*obj2ListNe别名*/
  1979. public static List<Object> objToListNe(Object obj) {
  1980. return obj2ListNe(obj);
  1981. }
  1982. /**
  1983. * @return java.lang.Object
  1984. * @Description 过滤掉List中的空对象
  1985. * @Param [o]
  1986. * @Author yangyj
  1987. * @Date 2021.07.28 11:16
  1988. **/
  1989. public static Object removeEmpty(Object o) {
  1990. List<Object> result = new ArrayList<>();
  1991. if (o instanceof List) {
  1992. for (Object e : (List<Object>) o) {
  1993. if (StringUtils.isNotEmpty(e)) {
  1994. result.add(e);
  1995. }
  1996. }
  1997. } else {
  1998. result.add(o);
  1999. }
  2000. return result;
  2001. }
  2002. /**
  2003. * @return
  2004. * @Description 设置保留小数位
  2005. * @Param
  2006. * @Author yangyj
  2007. * @Date 2021.12.31 17:14
  2008. **/
  2009. public static Object setScale(Object o, Object scale) {
  2010. if (StringUtils.isNumber(scale) && o != null) {
  2011. if (o instanceof List || o.toString().contains(",") || o.toString().contains("、")) {
  2012. List<Object> result = new ArrayList<>();
  2013. List<Object> tmp = obj2ListNe(o);
  2014. for (Object e : tmp) {
  2015. if (StringUtils.isNumber(e)) {
  2016. result.add(StringUtils.number2String(e, scale));
  2017. } else {
  2018. result.add("");
  2019. }
  2020. }
  2021. if (o instanceof String) {
  2022. String delimiter = "、";
  2023. if (o.toString().contains(",")) {
  2024. delimiter = ",";
  2025. }
  2026. return result.stream().map(StringUtils::handleNull).collect(Collectors.joining(delimiter));
  2027. }
  2028. return result;
  2029. } else {
  2030. if (StringUtils.isNumber(o)) {
  2031. return StringUtils.number2String(o, scale);
  2032. }
  2033. }
  2034. }
  2035. return "";
  2036. }
  2037. public static Object abs(Object o) {
  2038. /**
  2039. * @Description 测试
  2040. * @Param [o]
  2041. * @return java.lang.Object
  2042. * @Author yangyj
  2043. * @Date 2022.03.21 15:43
  2044. **/
  2045. if (o != null) {
  2046. if (o instanceof List) {
  2047. List<Object> result = new ArrayList<>();
  2048. List<Object> datas = obj2List(o);
  2049. if (ListUtils.isNotEmpty(datas)) {
  2050. for (Object e : datas) {
  2051. if (StringUtils.isNotEmpty(e)) {
  2052. result.add(e.toString().replaceAll("^-", ""));
  2053. }
  2054. }
  2055. }
  2056. return result;
  2057. } else {
  2058. return o.toString().replaceAll("^-", "");
  2059. }
  2060. }
  2061. return null;
  2062. }
  2063. /**
  2064. * @return java.lang.Object
  2065. * @Description 返回正则式匹配内容
  2066. * @Param [regex:正则式, value:匹配的字符串, i:group(i), g:是否返回全局搜索,全局搜索返回的是列表]
  2067. * @Author yangyj
  2068. * @Date 2021.01.08 16:31
  2069. **/
  2070. public static Object matcherFindGroup(String regex, String value, int i, boolean g) {
  2071. Matcher m = RegexUtils.matcher(regex, value);
  2072. List<Object> result = new ArrayList<>();
  2073. while (m.find()) {
  2074. result.add(m.group(i));
  2075. }
  2076. if (ListUtils.isNotEmpty(result)) {
  2077. if (g) {
  2078. return result;
  2079. } else {
  2080. if(result.get(0).equals("-")){
  2081. String pattern = "^-?\\d+(\\.\\d+)?([+\\-*/]-?\\d+(\\.\\d+)?)*$";
  2082. Pattern r = Pattern.compile(pattern);
  2083. Matcher mm = r.matcher(String.valueOf(value));
  2084. boolean b = mm.matches();
  2085. if(b){
  2086. return result.get(1);
  2087. }
  2088. }
  2089. return result.get(0);
  2090. }
  2091. }
  2092. return null;
  2093. }
  2094. /* public static void main(String[] args) {
  2095. System.out.println(xN(0.0,0.0001));
  2096. }*/
  2097. /**
  2098. * @return java.lang.Object
  2099. * @Description 放大缩小
  2100. * @Author yangyj
  2101. * @Date 2022.01.14 14:17
  2102. **/
  2103. public static Object xN(Object o, Object xN) {
  2104. String cur = "";
  2105. try {
  2106. if (StringUtils.isNotEmpty(o) && StringUtils.isNumber(xN)) {
  2107. double xND = Double.parseDouble(xN.toString());
  2108. List<Object> outList = new ArrayList<>();
  2109. if (o instanceof List) {
  2110. List<Object> datas = obj2ListNe(o);
  2111. for (Object e : datas) {
  2112. if (StringUtils.isNotEmpty(e)) {
  2113. String[] as = e.toString().split("[^\\d.-]");
  2114. Object m = matcherFindGroup("[^\\d.-]", e.toString(), 0, false);
  2115. StringBuilder d = new StringBuilder();
  2116. for (int i = 0; i < as.length; i++) {
  2117. String s = as[i];
  2118. cur = s;
  2119. /* int scale = (int) Math.max(getScale(s) - Math.log10(xND), 0);
  2120. d.append(StringUtils.number2String(Double.parseDouble(s) * xND, scale)).append(i != as.length - 1 && m != null ? m : "");*/
  2121. d.append(BaseUtils.str2BigDecimal(s).scaleByPowerOfTen((int)Math.log10(xND)).stripTrailingZeros().toPlainString()).append(i != as.length - 1 && m != null ? m : "");
  2122. }
  2123. outList.add(d.toString());
  2124. }
  2125. }
  2126. if (ListUtils.isNotEmpty(outList)) {
  2127. return outList;
  2128. }
  2129. } else {
  2130. List<Object> datas = Arrays.asList(o.toString().split("[、, ,]"));
  2131. Matcher m = RegexUtils.matcher("[、, ,]", o.toString());
  2132. String s = "、";
  2133. if (m.find()) {
  2134. s = handleNull(m.group());
  2135. }
  2136. if (ListUtils.isNotEmpty(datas)) {
  2137. for (Object e : datas) {
  2138. if (StringUtils.isNotEmpty(e)) {
  2139. cur = e.toString();
  2140. /* int scale = (int) Math.max(getScale(s) - Math.log10(xND), 0);
  2141. outList.add(StringUtils.number2String(Double.parseDouble(e.toString()) * xND, scale));*/
  2142. outList.add(BaseUtils.str2BigDecimal(e.toString()).scaleByPowerOfTen((int)Math.log10(xND)).stripTrailingZeros().toPlainString());
  2143. }
  2144. }
  2145. }
  2146. if (ListUtils.isNotEmpty(outList)) {
  2147. return StringUtils.join(outList.stream().map(StringUtils::handleNull).collect(Collectors.toList()), s);
  2148. }
  2149. }
  2150. }
  2151. } catch (NumberFormatException e) {
  2152. e.printStackTrace();
  2153. String error = "";
  2154. if (e.getMessage().contains("multiple points")) {
  2155. error = cur + "包含多个小数点";
  2156. } else {
  2157. error = cur;
  2158. }
  2159. return "NumberFormatException(数字格式异常,请检查)" + error;
  2160. }
  2161. return "";
  2162. }
  2163. // public static void main(String[] args) {
  2164. // int x=1234567800;
  2165. // System.out.println(xN(x,0.0001));
  2166. // }
  2167. public static Object repeat(Object data) {
  2168. List<Object> result = new ArrayList<>();
  2169. if (data != null) {
  2170. List<Object> list = obj2List(removeEmpty(data));
  2171. /*外观质量,这种中文描述去重*/
  2172. if (list.stream().filter(CustomFunction::containsZH).anyMatch(e -> e.toString().contains("\n"))) {
  2173. AtomicInteger index = new AtomicInteger(1);
  2174. result = list.stream().flatMap(e -> Arrays.stream(e.toString().split("\\n+"))).map(String::trim).map(e -> e.replaceAll("^\\d+[、.\\s]*", "")).distinct().map(e -> (index.getAndIncrement()) + "、" + e + "\n").collect(Collectors.toList());
  2175. } else {
  2176. result = list.stream().distinct().collect(Collectors.toList());
  2177. }
  2178. }
  2179. return result;
  2180. }
  2181. /**扩散*/
  2182. public static List<Object> diffusion(List<Object> data) {
  2183. /* List<Object> result = new ArrayList<>();
  2184. if (data != null) {
  2185. Optional<Object> op = data.stream().filter(StringUtils::isNotEmpty).findFirst();
  2186. if (op.isPresent()) {
  2187. Object copy = op.get();
  2188. return data.stream().map(e -> StringUtils.isEmpty(e) ? copy : e)
  2189. .collect(Collectors.toList());
  2190. }
  2191. }
  2192. return result;*/
  2193. return follow(data);
  2194. }
  2195. /**元素内容永远跟随第一页*/
  2196. public static List<Object> follow(List<Object> data) {
  2197. if (data != null) {
  2198. Object value = data.get(0);
  2199. return Collections.nCopies(data.size(), value);
  2200. }
  2201. return new ArrayList<>();
  2202. }
  2203. /* public static void main(String[] args) {
  2204. List<Object> l1 = Arrays.asList(1,2,3,4,5);
  2205. List<Object> l2 = Arrays.asList("",2,3,4,5);
  2206. follow(l1).forEach(System.out::println);
  2207. follow(l2).forEach(System.out::println);
  2208. }*/
  2209. /**
  2210. * @return java.lang.Object
  2211. * @Description 截取list subList(list,1,5) 返回list的第1到第5个元素
  2212. * @Param [o]
  2213. * @Author yangyj
  2214. * @Date 2021.07.28 11:16
  2215. **/
  2216. public static Object subList(Object o, Object start, Object end) {
  2217. List<Object> result = new ArrayList<>();
  2218. if (o instanceof List) {
  2219. result = (List<Object>) o;
  2220. int s = StringUtils.handleObj2Integer(start);
  2221. int e = StringUtils.handleObj2Integer(end);
  2222. s = Math.max(s, 1);
  2223. if (e <= 0) {
  2224. e = result.size();
  2225. }
  2226. return result.subList(s - 1, e);
  2227. }
  2228. return result;
  2229. }
  2230. /**
  2231. * @return java.lang.Object
  2232. * @Description 获取G8测点偏差
  2233. * @Param [cd, pc]
  2234. * @Author yangyj
  2235. * @Date 2022.02.25 11:05
  2236. **/
  2237. public static Object g8dx(Object cd, Object pc) {
  2238. if (cd != null && pc != null) {
  2239. List<Object> result = new ArrayList<>();
  2240. List<Object> stakes = obj2List(cd);
  2241. List<Object> dx = obj2List(pc);
  2242. if (ListUtils.isNotEmpty(stakes) && dx.size() >= stakes.size()) {
  2243. Object bmd = stakes.get(0);
  2244. if (StringUtils.isNotEmpty(bmd)) {
  2245. for (int i = 0; i < stakes.size(); i++) {
  2246. Object cp = stakes.get(i);
  2247. if (StringUtils.isNotEmpty(cp) && StringUtils.isNotEquals(bmd, cp)) {
  2248. Matcher m = RegexUtils.matcher("(?i)zd\\d+", cp.toString());
  2249. if (!m.find()) {
  2250. result.add(dx.get(i));
  2251. }
  2252. }
  2253. }
  2254. return result;
  2255. }
  2256. }
  2257. }
  2258. return "";
  2259. }
  2260. public static Object g8stakes(Object cd) {
  2261. if (cd != null) {
  2262. List<Object> result = new ArrayList<>();
  2263. List<Object> stakes = obj2List(cd);
  2264. if (ListUtils.isNotEmpty(stakes)) {
  2265. Object bmd = stakes.get(0);
  2266. if (StringUtils.isNotEmpty(bmd)) {
  2267. for (Object cp : stakes) {
  2268. if (StringUtils.isNotEmpty(cp) && StringUtils.isNotEquals(bmd, cp)) {
  2269. Matcher m = RegexUtils.matcher("(?i)zd\\d+", cp.toString());
  2270. if (!m.find()) {
  2271. result.add(cp);
  2272. }
  2273. }
  2274. }
  2275. return result;
  2276. }
  2277. }
  2278. }
  2279. return "";
  2280. }
  2281. public static List<Object> g8c103(Object cd, Object sj, Object sc, Object dx) {
  2282. List<Object> result = new ArrayList<>();
  2283. if (cd != null && sj != null && sc != null && dx != null) {
  2284. List<Object> cds = obj2List(cd);
  2285. List<Object> sjs = obj2List(sj);
  2286. List<Object> scs = obj2List(sc);
  2287. List<Object> dxs = obj2List(dx);
  2288. int min = Math.min(Math.min(sjs.size(), scs.size()), dxs.size());
  2289. if (ListUtils.isNotEmpty(cds) && min >= cds.size()) {
  2290. Object bmd = cds.get(0);
  2291. if (StringUtils.isNotEmpty(bmd)) {
  2292. for (int i = 0; i < cds.size(); i++) {
  2293. Object cp = cds.get(i);
  2294. if (StringUtils.isNotEmpty(cp) && StringUtils.isNotEquals(bmd, cp)) {
  2295. Matcher m = RegexUtils.matcher("(?i)zd\\d+", cp.toString());
  2296. if (!m.find()) {
  2297. if (StringUtils.isNumber(cp)) {
  2298. result.add("");
  2299. result.add("");
  2300. result.add("");
  2301. result.add(dxs.get(i));
  2302. } else {
  2303. result.add(sjs.get(i));
  2304. result.add(scs.get(i));
  2305. result.add(dxs.get(i));
  2306. result.add("");
  2307. }
  2308. }
  2309. }
  2310. }
  2311. }
  2312. }
  2313. }
  2314. return result;
  2315. }
  2316. public static List<Object> g8zzds(Object cd, Object dx, Object fi) {
  2317. List<Object> result = new ArrayList<>();
  2318. if (cd != null && dx != null) {
  2319. List<Object> cds = obj2List(cd);
  2320. List<Object> dxs = obj2List(dx);
  2321. boolean bol = (boolean) fi;
  2322. int min = dxs.size();
  2323. if (ListUtils.isNotEmpty(cds) && min >= cds.size()) {
  2324. Object bmd = cds.get(0);
  2325. List<String> l1 = new ArrayList<>();
  2326. List<String> l2 = new ArrayList<>();
  2327. List<String> l3 = new ArrayList<>();
  2328. List<String> dyn;
  2329. if (bol) {
  2330. dyn = l3;
  2331. } else {
  2332. dyn = l2;
  2333. }
  2334. if (StringUtils.isNotEmpty(bmd)) {
  2335. for (int i = 0; i < cds.size(); i++) {
  2336. Object cp = cds.get(i);
  2337. if (StringUtils.isNotEmpty(cp) && StringUtils.isNotEquals(bmd, cp)) {
  2338. Matcher m = RegexUtils.matcher("(?i)zd\\d+", cp.toString());
  2339. if (!m.find()) {
  2340. if (StringUtils.isNumber(cp)) {
  2341. dyn.add(handleNull(dxs.get(i)));
  2342. } else {
  2343. l1.add(handleNull(dxs.get(i)));
  2344. }
  2345. }
  2346. }
  2347. }
  2348. result.add(StringUtils.join(l1, ","));
  2349. result.add(StringUtils.join(l2, ","));
  2350. result.add(StringUtils.join(l3, ","));
  2351. }
  2352. }
  2353. }
  2354. return result;
  2355. }
  2356. public static List<Object> gcc(Object zh, Object sj, Object sc, Object dx, Object mode) {
  2357. List<Object> result = new ArrayList<>();
  2358. if (zh != null && sj != null && sc != null && dx != null) {
  2359. List<Object> cds = obj2List(zh);
  2360. List<Object> sjs = obj2List(sj);
  2361. List<Object> scs = obj2List(sc);
  2362. List<Object> dxs = obj2List(dx);
  2363. int min = Math.min(Math.min(dxs.size(), sjs.size()), scs.size());
  2364. if (ListUtils.isNotEmpty(cds) && min >= cds.size()) {
  2365. Object bmd = cds.get(0);
  2366. if (StringUtils.isNotEmpty(bmd)) {
  2367. for (int i = 0; i < cds.size(); i++) {
  2368. Object cp = cds.get(i);
  2369. if (StringUtils.isNotEmpty(cp) && StringUtils.isNotEquals(bmd, cp)) {
  2370. Matcher m = RegexUtils.matcher("(?i)zd\\d+", cp.toString());
  2371. if (!m.find()) {
  2372. if (StringUtils.isEquals(mode, 0)) {
  2373. if (!Pattern.matches(".+(?i)v$", cp.toString())) {
  2374. result.add(sjs.get(i));
  2375. result.add(scs.get(i));
  2376. result.add(dxs.get(i));
  2377. }
  2378. } else if (StringUtils.isEquals(mode, 1)) {
  2379. if (Pattern.matches(".+(?i)v$", cp.toString())) {
  2380. result.add(sjs.get(i));
  2381. result.add(scs.get(i));
  2382. result.add(dxs.get(i));
  2383. }
  2384. }
  2385. }
  2386. }
  2387. }
  2388. }
  2389. }
  2390. }
  2391. return result;
  2392. }
  2393. /**
  2394. * @return java.lang.Object
  2395. * @Description list 去头尾
  2396. * @Param [o]
  2397. * @Author yangyj
  2398. * @Date 2021.12.31 14:53
  2399. **/
  2400. public static Object removeHT(Object o) {
  2401. List<Object> result = new ArrayList<>();
  2402. if (o instanceof List) {
  2403. result = (List<Object>) o;
  2404. if (result.size() > 2) {
  2405. int end = result.size();
  2406. for (int i = result.size() - 1; i > 1; i--) {
  2407. if (StringUtils.isNotEmpty(result.get(i))) {
  2408. end = i;
  2409. break;
  2410. }
  2411. }
  2412. return subList(result, 2, end);
  2413. }
  2414. }
  2415. return result;
  2416. }
  2417. public static Object removeByReg(Object o, Object reg) {
  2418. List<Object> result = new ArrayList<>();
  2419. if (o instanceof List && StringUtils.isNotEmpty(reg)) {
  2420. result = (List<Object>) o;
  2421. return result.stream().map(StringUtils::handleNull).filter(e -> !Pattern.matches(reg.toString(), e)).collect(Collectors.toList());
  2422. }
  2423. return result;
  2424. }
  2425. /**
  2426. * @return java.lang.Object
  2427. * @Description 获取动态行某列内容
  2428. * @Param [data, field]
  2429. * @Author yangyj
  2430. * @Date 2022.01.08 10:02
  2431. **/
  2432. public static Object getColumn(Object data, Object field) {
  2433. if (StringUtils.isNotEmpty(field)) {
  2434. List<HashMap<String, Object>> _data = objToArray(data);
  2435. if (ListUtils.isNotEmpty(_data)) {
  2436. return _data.stream().map(e -> e.get(field.toString())).collect(Collectors.toList());
  2437. }
  2438. }
  2439. return data;
  2440. }
  2441. /**
  2442. * @return java.lang.Object
  2443. * @Description 合并多个list
  2444. * @Param [listArr]
  2445. * @Author yangyj
  2446. * @Date 2021.12.31 15:10
  2447. **/
  2448. public static Object _mergeList(Object... listArr) {
  2449. List<Object> result = new ArrayList<>();
  2450. if (listArr != null && listArr.length >= 2) {
  2451. List<List<Object>> tmp = new ArrayList<>();
  2452. int max = 0;
  2453. for (Object o : listArr) {
  2454. List<Object> list = Collections.singletonList("");
  2455. if (o instanceof List) {
  2456. list = (List<Object>) o;
  2457. max = Math.max(max, list.size());
  2458. }
  2459. tmp.add(list);
  2460. }
  2461. if (ListUtils.isNotEmpty(tmp)) {
  2462. for (int i = 0; i < max; i++) {
  2463. for (List<Object> _l : tmp) {
  2464. if (_l.size() > i) {
  2465. result.add(_l.get(i));
  2466. } else {
  2467. result.add("");
  2468. }
  2469. }
  2470. }
  2471. }
  2472. }
  2473. return result;
  2474. }
  2475. /**
  2476. * @return java.lang.Object
  2477. * @Description list 转 string
  2478. * @Param [o, separator:分隔符]
  2479. * @Author yangyj
  2480. * @Date 2021.07.28 15:50
  2481. **/
  2482. public static Object join(Object o1, Object separator) {
  2483. Optional<Object> op = Optional.ofNullable(o1);
  2484. if (op.isPresent()) {
  2485. String s = StringUtils.handleNull(separator);
  2486. if (StringUtils.isEmpty(s)) {
  2487. s = "、";
  2488. }
  2489. return op.map(CustomFunction::obj2ListNe).orElse(Collections.singletonList("")).stream().map(StringUtils::handleNull).collect(Collectors.joining(s));
  2490. }
  2491. ;
  2492. return "";
  2493. }
  2494. /**
  2495. * @return java.lang.Object
  2496. * @Description String 转List
  2497. * @Param [o, separator]
  2498. * @Author yangyj
  2499. * @Date 2021.12.03 15:09
  2500. **/
  2501. public static Object split(Object o, Object separator) {
  2502. if (StringUtils.isNotEmpty(o, separator)) {
  2503. System.out.println(separator);
  2504. String[] arr = o.toString().split(separator.toString());
  2505. return Arrays.stream(arr).collect(Collectors.toList());
  2506. }
  2507. return null;
  2508. }
  2509. public static Object split(Object o) {
  2510. return split(o, "/|,|、|,|;|;|\\\\|(\\s+)");
  2511. }
  2512. /**
  2513. * @Description 删除下标为index的元素
  2514. * @Param [o, index]
  2515. * @Author yangyj
  2516. * @Date 2021.07.28 15:52
  2517. **/
  2518. public static void rem(Object o, Object index) {
  2519. if (o instanceof List && StringUtils.isNumber(index)) {
  2520. ((List<Object>) o).remove(StringUtils.handleObj2Integer(index).intValue());
  2521. }
  2522. }
  2523. /**
  2524. * @return java.lang.Object
  2525. * @Description 根据百分比返回子集list内容
  2526. * @Param [obj:数据源, percent:0-100]
  2527. * @Author yangyj
  2528. * @Date 2020.12.04 09:24
  2529. **/
  2530. public static Object getListPercent(Object obj, Object percent) {
  2531. if (obj != null && percent != null) {
  2532. if (obj instanceof List) {
  2533. ArrayList<Object> list = (ArrayList<Object>) obj;
  2534. Collections.shuffle(list);
  2535. int n = (int) Math.round((Double.parseDouble(percent.toString()) / 100) * list.size());
  2536. if (n <= list.size()) {
  2537. return list.subList(0, n);
  2538. }
  2539. return list;
  2540. }
  2541. }
  2542. return "";
  2543. }
  2544. /**
  2545. * @return java.util.ArrayList<java.util.HashMap < java.lang.String, java.lang.Object>>
  2546. * @Description 把Object 转换成 ArrayList<HashMap<String, Object>>
  2547. * @Param [obj]
  2548. * @Author yangyj
  2549. * @Date 2020.12.11 09:44
  2550. **/
  2551. public static List<HashMap<String, Object>> objToArray(Object obj) {
  2552. if (obj instanceof ArrayList) {
  2553. return (List<HashMap<String, Object>>) obj;
  2554. } else if (obj instanceof HashMap) {
  2555. List<HashMap<String, Object>> array = new ArrayList<>();
  2556. HashMap<String, Object> map = (HashMap<String, Object>) obj;
  2557. if (map.size() > 0) {
  2558. array.add(map);
  2559. }
  2560. return array;
  2561. }
  2562. return null;
  2563. }
  2564. public static Object dXd(Object design, Object data) {
  2565. return dXd(design, data, 1, 0);
  2566. }
  2567. public static Object dXd(Object design, Object data, Object xN, Integer mode) {
  2568. int scale = 0;
  2569. if (StringUtils.isNotEmpty(design, data, xN)) {
  2570. scale = getScale(design, data);
  2571. scale = (int) (scale - Math.log10(Double.parseDouble(xN.toString())));
  2572. }
  2573. if (StringUtils.isEmpty(mode)) {
  2574. mode = 0;
  2575. }
  2576. return dXd(design, data, xN, scale, mode);
  2577. }
  2578. /*
  2579. public static void main(String[] args) {
  2580. String a="100/200";
  2581. List<Object>list = new ArrayList<>(Arrays.asList(101,102,201,198));
  2582. list.forEach(d-> System.out.println(dXd(a,d)));
  2583. }
  2584. */
  2585. /**
  2586. * @return java.lang.Object
  2587. * @Description 求偏差公式 支持AXA-BXB=DXD或者A-B=D的格式
  2588. * @Param [design:设计值, data:实测值, xN:倍率, scale:保留小数位,mode:1乘法,其它默认减法]
  2589. * @Author yangyj
  2590. * @Date 2022.01.20 09:45
  2591. **/
  2592. public static Object dXd(Object design, Object data, Object xN, Object scale, Integer mode) {
  2593. if (StringUtils.isNotEmpty(design, data)) {
  2594. if (StringUtils.isEmpty(xN)) {
  2595. xN = 1;
  2596. }
  2597. if (StringUtils.isEmpty(scale)) {
  2598. scale = 0;
  2599. }
  2600. String delimiter = handleNull(matcherFindGroup("[^0-9./E]", design.toString(), 0, false));
  2601. if (StringUtils.isEmpty(delimiter)) {
  2602. delimiter = CONCAT;
  2603. }
  2604. String delimiter2 = handleNull(matcherFindGroup("[^0-9.E]", data.toString(), 0, false));
  2605. if (StringUtils.isEmpty(delimiter2)) {
  2606. delimiter2 = CONCAT;
  2607. }
  2608. String[] dArr = handleNull(design).split("[" + delimiter + "]");
  2609. String[] bArr = handleNull(data).split("[" + delimiter2 + "]");
  2610. Object _dx = null;
  2611. for (int n = 0; n < dArr.length; n++) {
  2612. String dsg=dArr[n];
  2613. String xd=bArr[n];
  2614. if(dsg.contains("/")){
  2615. String[] dsgA= dsg.split("/");
  2616. dsg= Arrays.stream(dsgA).filter(StringUtils::isNumber).min(Comparator.comparingDouble(e->Math.abs(StringUtils.obj2Double(calculate(xd,e,3,2))))).orElse(dsg);
  2617. }
  2618. BigDecimal a = new BigDecimal(dsg);
  2619. BigDecimal b = new BigDecimal(xd);
  2620. String _data;
  2621. if (StringUtils.isEquals(1, mode)) {
  2622. _data = b.multiply(a).multiply(new BigDecimal(xN.toString())).setScale(Integer.parseInt(scale.toString()), ROUND_HALF_UP).toString();
  2623. } else {
  2624. _data = b.subtract(a).multiply(new BigDecimal(xN.toString())).setScale(Integer.parseInt(scale.toString()), ROUND_HALF_UP).toString();
  2625. }
  2626. if (StringUtils.isNotEmpty(_dx)) {
  2627. _dx = StringUtils.join(_dx, _data, delimiter2);
  2628. } else {
  2629. _dx = _data;
  2630. }
  2631. }
  2632. return _dx;
  2633. }
  2634. return "";
  2635. }
  2636. /**
  2637. * @return java.lang.Object
  2638. * @Description 总体标准差
  2639. * @Param [data, scale]
  2640. * @Author yangyj
  2641. * @Date 2022.04.14 11:32
  2642. **/
  2643. public static Object sd(Object data) {
  2644. if (data != null ) {
  2645. List<Object> datas = obj2ListNe(data);
  2646. int total = datas.size();
  2647. List<String> _datas = datas.stream().map(StringUtils::handleNull).collect(Collectors.toList());
  2648. double avgVal = _datas.stream().mapToDouble(Double::parseDouble).average().orElse(0D);
  2649. return Math.sqrt(_datas.stream().mapToDouble(Double::parseDouble).map(e -> Math.pow(e - avgVal, 2)).sum() / total);
  2650. }
  2651. return "";
  2652. }
  2653. /*递进求和*/
  2654. public static Object stepSum(List<Object> list){
  2655. if(list!=null&&list.size()>0){
  2656. AtomicReference<Double> acc = new AtomicReference<>((double) 0);
  2657. return list.stream().map(d-> StringUtils.isNumber(d)?acc.updateAndGet(s->s+Func.toDouble(d)):StringPool.EMPTY).collect(Collectors.toList());
  2658. }
  2659. return StringPool.EMPTY;
  2660. }
  2661. /*
  2662. public static void main(String[] args) {
  2663. List<Object> list = Arrays.asList(0.83,0.82,0.91,0.89,0.97,0.98);
  2664. ( (List<Object>)stepSum(list)).forEach(System.out::println);
  2665. }
  2666. */
  2667. /*字符模版*/
  2668. public static Object strTemplate(List<Object>data,String template){
  2669. if(BaseUtils.isNotEmpty(template)) {
  2670. return data.stream().map(s -> template.replaceAll("\\{\\s*}", BaseUtils.handleNull(s))).collect(Collectors.toList());
  2671. }
  2672. return data;
  2673. }
  2674. public static Object dateRange(List<Object>d1,List<Object>d2,String template){
  2675. if(BaseUtils.isNotEmpty(template)&&BaseUtils.isNotEmpty(d1)&&BaseUtils.isNotEmpty(d2)) {
  2676. return IntStream.range(0,Math.min(d1.size(),d2.size())).boxed().map(i->{
  2677. List<Object> list =new ArrayList<>();
  2678. list.add(d1.get(i));
  2679. list.add(d2.get(i));
  2680. return list;
  2681. }).map(l-> IntStream.range(0, l.size()).boxed().reduce(template, (str, i) -> str.replaceFirst("\\{}", l.get(i).toString()), String::concat)
  2682. ).collect(Collectors.toList());
  2683. }
  2684. return template;
  2685. }
  2686. /* public static void main(String[] args) {
  2687. List<Object> list = Arrays.asList("","20240403");
  2688. List<Object> list2 = Arrays.asList("20040402","20240405");
  2689. System.out.println(dateRange(list,list2,"时间范围{}至{}"));
  2690. }*/
  2691. /**转成人民币大写形式*/
  2692. public static List<Object> toRmb(List<Object> arabic ){
  2693. if(StringUtils.isNotEmpty(arabic)){
  2694. return arabic.stream().filter(CustomFunction::isNumber).map(e -> StringUtils.obj2Double(e, 2)).filter(Objects::nonNull).map(org.springblade.business.utils.NumberUtil::numberToRMB).collect(Collectors.toList());
  2695. }
  2696. return arabic;
  2697. }
  2698. /*
  2699. public static void main(String[] args) {
  2700. List<Object> list = Arrays.asList(68919641);
  2701. toRmb(list).forEach(System.out::println);
  2702. }
  2703. */
  2704. public static List<Object> toYear(List<Object> dateList){
  2705. return toDate(dateList,0);
  2706. }
  2707. public static List<Object> toMonth(List<Object> dateList){
  2708. return toDate(dateList,1);
  2709. }
  2710. public static List<Object> toDay(List<Object> dateList){
  2711. return toDate(dateList,2);
  2712. }
  2713. public static List<Object> toDate(List<Object> dateList,int type){
  2714. List<Object> result = new ArrayList<>();
  2715. if(ListUtils.isNotEmpty(dateList)){
  2716. for (Object o : dateList) {
  2717. String d = StringUtils.handleNull(o);
  2718. if (StringUtils.isNotEmpty(d)) {
  2719. /* if (d.contains(",")) {
  2720. String[] arr = d.replaceAll("[\\[\\]\\s]+", "").split(",");
  2721. d = arr[arr.length - 1];
  2722. }*/
  2723. DateTime dt = new DateTime(d);
  2724. if(type==0) {
  2725. result.add(dt.year());
  2726. }else if(type==1) {
  2727. result.add(dt.month()+1);
  2728. }if(type==2) {
  2729. result.add(dt.dayOfMonth());
  2730. }
  2731. }
  2732. }
  2733. }
  2734. return result;
  2735. }
  2736. /* public static void main(String[] args) {
  2737. List<Object> list = Arrays.asList("2024年07月2日","2024-07-2","2024.07.2");
  2738. toYear(list).forEach(System.out::println);
  2739. toMonth(list).forEach(System.out::println);
  2740. toDay(list).forEach(System.out::println);
  2741. }*/
  2742. }