CustomFunction.java 115 KB

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