CustomFunction.java 102 KB

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