通过公式计算.html 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>通过公式计算</title>
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
  6. <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
  7. <link href="resources/css/axure_rp_page.css" type="text/css" rel="stylesheet"/>
  8. <link href="data/styles.css" type="text/css" rel="stylesheet"/>
  9. <link href="files/通过公式计算/styles.css" type="text/css" rel="stylesheet"/>
  10. <script src="resources/scripts/jquery-3.2.1.min.js"></script>
  11. <script src="resources/scripts/axure/axQuery.js"></script>
  12. <script src="resources/scripts/axure/globals.js"></script>
  13. <script src="resources/scripts/axutils.js"></script>
  14. <script src="resources/scripts/axure/annotation.js"></script>
  15. <script src="resources/scripts/axure/axQuery.std.js"></script>
  16. <script src="resources/scripts/axure/doc.js"></script>
  17. <script src="resources/scripts/messagecenter.js"></script>
  18. <script src="resources/scripts/axure/events.js"></script>
  19. <script src="resources/scripts/axure/recording.js"></script>
  20. <script src="resources/scripts/axure/action.js"></script>
  21. <script src="resources/scripts/axure/expr.js"></script>
  22. <script src="resources/scripts/axure/geometry.js"></script>
  23. <script src="resources/scripts/axure/flyout.js"></script>
  24. <script src="resources/scripts/axure/model.js"></script>
  25. <script src="resources/scripts/axure/repeater.js"></script>
  26. <script src="resources/scripts/axure/sto.js"></script>
  27. <script src="resources/scripts/axure/utils.temp.js"></script>
  28. <script src="resources/scripts/axure/variables.js"></script>
  29. <script src="resources/scripts/axure/drag.js"></script>
  30. <script src="resources/scripts/axure/move.js"></script>
  31. <script src="resources/scripts/axure/visibility.js"></script>
  32. <script src="resources/scripts/axure/style.js"></script>
  33. <script src="resources/scripts/axure/adaptive.js"></script>
  34. <script src="resources/scripts/axure/tree.js"></script>
  35. <script src="resources/scripts/axure/init.temp.js"></script>
  36. <script src="resources/scripts/axure/legacy.js"></script>
  37. <script src="resources/scripts/axure/viewer.js"></script>
  38. <script src="resources/scripts/axure/math.js"></script>
  39. <script src="resources/scripts/axure/jquery.nicescroll.min.js"></script>
  40. <script src="data/document.js"></script>
  41. <script src="files/通过公式计算/data.js"></script>
  42. <script type="text/javascript">
  43. $axure.utils.getTransparentGifPath = function() { return 'resources/images/transparent.gif'; };
  44. $axure.utils.getOtherPath = function() { return 'resources/Other.html'; };
  45. $axure.utils.getReloadPath = function() { return 'resources/reload.html'; };
  46. </script>
  47. </head>
  48. <body>
  49. <div id="base" class="">
  50. <!-- Unnamed (Group) -->
  51. <div id="u20135" class="ax_default" data-left="104" data-top="103" data-width="862" data-height="480">
  52. <!-- Unnamed (Rectangle) -->
  53. <div id="u20136" class="ax_default box_1">
  54. <div id="u20136_div" class=""></div>
  55. <div id="u20136_text" class="text " style="display:none; visibility: hidden">
  56. <p></p>
  57. </div>
  58. </div>
  59. <!-- Unnamed (Rectangle) -->
  60. <div id="u20137" class="ax_default label">
  61. <div id="u20137_div" class=""></div>
  62. <div id="u20137_text" class="text ">
  63. <p><span>通过公式计算</span></p>
  64. </div>
  65. </div>
  66. <!-- del (Dynamic Panel) -->
  67. <div id="u20138" class="ax_default" data-label="del">
  68. <div id="u20138_state0" class="panel_state" data-label="normal" style="">
  69. <div id="u20138_state0_content" class="panel_state_content">
  70. <!-- Unnamed (Image) -->
  71. <div id="u20139" class="ax_default image">
  72. <img id="u20139_img" class="img " src="images/功能管理/u13453.png"/>
  73. <div id="u20139_text" class="text " style="display:none; visibility: hidden">
  74. <p></p>
  75. </div>
  76. </div>
  77. </div>
  78. </div>
  79. <div id="u20138_state1" class="panel_state" data-label="hover" style="visibility: hidden;">
  80. <div id="u20138_state1_content" class="panel_state_content">
  81. <!-- Unnamed (Image) -->
  82. <div id="u20140" class="ax_default image">
  83. <img id="u20140_img" class="img " src="images/功能管理/u13454.png"/>
  84. <div id="u20140_text" class="text " style="display:none; visibility: hidden">
  85. <p></p>
  86. </div>
  87. </div>
  88. </div>
  89. </div>
  90. </div>
  91. <!-- Unnamed (Group) -->
  92. <div id="u20141" class="ax_default" data-left="104" data-top="523" data-width="862" data-height="60">
  93. <!-- Unnamed (Rectangle) -->
  94. <div id="u20142" class="ax_default label">
  95. <div id="u20142_div" class=""></div>
  96. <div id="u20142_text" class="text " style="display:none; visibility: hidden">
  97. <p></p>
  98. </div>
  99. </div>
  100. <!-- Unnamed (Rectangle) -->
  101. <div id="u20143" class="ax_default box_1">
  102. <div id="u20143_div" class=""></div>
  103. <div id="u20143_text" class="text ">
  104. <p><span>保存</span></p>
  105. </div>
  106. </div>
  107. <!-- Unnamed (Rectangle) -->
  108. <div id="u20144" class="ax_default box_1">
  109. <div id="u20144_div" class=""></div>
  110. <div id="u20144_text" class="text ">
  111. <p><span>取消</span></p>
  112. </div>
  113. </div>
  114. </div>
  115. <!-- Unnamed (Rectangle) -->
  116. <div id="u20145" class="ax_default paragraph">
  117. <div id="u20145_div" class=""></div>
  118. <div id="u20145_text" class="text ">
  119. <p><span>单行文字</span></p>
  120. </div>
  121. </div>
  122. <!-- Unnamed (Rectangle) -->
  123. <div id="u20146" class="ax_default paragraph">
  124. <div id="u20146_div" class=""></div>
  125. <div id="u20146_text" class="text ">
  126. <p><span>在左侧选择函数或字段变量,且在英文输入法下编辑</span></p>
  127. </div>
  128. </div>
  129. <!-- Unnamed (Rectangle) -->
  130. <div id="u20147" class="ax_default paragraph">
  131. <div id="u20147_div" class=""></div>
  132. <div id="u20147_text" class="text ">
  133. <p><span>-|</span></p>
  134. </div>
  135. </div>
  136. <!-- Unnamed (Group) -->
  137. <div id="u20148" class="ax_default" data-left="124" data-top="173" data-width="200" data-height="40">
  138. <!-- Unnamed (Rectangle) -->
  139. <div id="u20149" class="ax_default paragraph">
  140. <div id="u20149_div" class=""></div>
  141. <div id="u20149_text" class="text ">
  142. <p><span>公式</span></p>
  143. </div>
  144. </div>
  145. <!-- Unnamed (Rectangle) -->
  146. <div id="u20150" class="ax_default paragraph">
  147. <div id="u20150_div" class=""></div>
  148. <div id="u20150_text" class="text ">
  149. <p><span>字段</span></p>
  150. </div>
  151. </div>
  152. <!-- Unnamed (Line) -->
  153. <div id="u20151" class="ax_default line1">
  154. <img id="u20151_img" class="img " src="images/用户列表/u3719.svg"/>
  155. <div id="u20151_text" class="text " style="display:none; visibility: hidden">
  156. <p></p>
  157. </div>
  158. </div>
  159. </div>
  160. <!-- Unnamed (Group) -->
  161. <div id="u20152" class="ax_default" data-left="134" data-top="223" data-width="73" data-height="27">
  162. <!-- Unnamed (Rectangle) -->
  163. <div id="u20153" class="ax_default paragraph">
  164. <div id="u20153_div" class=""></div>
  165. <div id="u20153_text" class="text ">
  166. <p><span>常用函数</span></p>
  167. </div>
  168. </div>
  169. <!-- Unnamed (Shape) -->
  170. <div id="u20154" class="ax_default icon">
  171. <img id="u20154_img" class="img " src="images/编码/u18628.svg"/>
  172. <div id="u20154_text" class="text " style="display:none; visibility: hidden">
  173. <p></p>
  174. </div>
  175. </div>
  176. </div>
  177. <!-- Unnamed (Rectangle) -->
  178. <div id="u20155" class="ax_default paragraph">
  179. <div id="u20155_div" class=""></div>
  180. <div id="u20155_text" class="text ">
  181. <p style="font-size:12px;"><span style="font-family:'Arial-BoldMT', 'Arial Bold', 'Arial', sans-serif;font-weight:700;">SUM</span></p><p style="font-size:10px;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;font-weight:400;">返回所有参与字段中数值的总和;</span></p>
  182. </div>
  183. </div>
  184. <!-- Unnamed (Rectangle) -->
  185. <div id="u20156" class="ax_default paragraph">
  186. <div id="u20156_div" class=""></div>
  187. <div id="u20156_text" class="text ">
  188. <p style="font-size:12px;"><span style="font-family:'Arial-BoldMT', 'Arial Bold', 'Arial', sans-serif;font-weight:700;">CURDATE</span></p><p style="font-size:10px;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;font-weight:400;">返回当前日期,可以在单行文本字段和日期字段中使用。</span></p>
  189. </div>
  190. </div>
  191. <!-- Unnamed (Rectangle) -->
  192. <div id="u20157" class="ax_default paragraph">
  193. <div id="u20157_div" class=""></div>
  194. <div id="u20157_text" class="text ">
  195. <p style="font-size:12px;"><span style="font-family:'Arial-BoldMT', 'Arial Bold', 'Arial', sans-serif;font-weight:700;">COUNT</span></p><p style="font-size:10px;"><span style="font-family:'PingFangSC-Regular', 'PingFang SC', sans-serif;font-weight:400;">返回所有参与运算字段中值或字符串的数量</span></p>
  196. </div>
  197. </div>
  198. </div>
  199. <!-- Unnamed (Group) -->
  200. <div id="u20158" class="ax_default" data-left="104" data-top="600" data-width="862" data-height="585">
  201. <!-- Unnamed (Rectangle) -->
  202. <div id="u20159" class="ax_default box_1">
  203. <div id="u20159_div" class=""></div>
  204. <div id="u20159_text" class="text " style="display:none; visibility: hidden">
  205. <p></p>
  206. </div>
  207. </div>
  208. <!-- Unnamed (Rectangle) -->
  209. <div id="u20160" class="ax_default label">
  210. <div id="u20160_div" class=""></div>
  211. <div id="u20160_text" class="text ">
  212. <p><span>通过公式计算</span></p>
  213. </div>
  214. </div>
  215. <!-- del (Dynamic Panel) -->
  216. <div id="u20161" class="ax_default" data-label="del">
  217. <div id="u20161_state0" class="panel_state" data-label="normal" style="">
  218. <div id="u20161_state0_content" class="panel_state_content">
  219. <!-- Unnamed (Image) -->
  220. <div id="u20162" class="ax_default image">
  221. <img id="u20162_img" class="img " src="images/功能管理/u13453.png"/>
  222. <div id="u20162_text" class="text " style="display:none; visibility: hidden">
  223. <p></p>
  224. </div>
  225. </div>
  226. </div>
  227. </div>
  228. <div id="u20161_state1" class="panel_state" data-label="hover" style="visibility: hidden;">
  229. <div id="u20161_state1_content" class="panel_state_content">
  230. <!-- Unnamed (Image) -->
  231. <div id="u20163" class="ax_default image">
  232. <img id="u20163_img" class="img " src="images/功能管理/u13454.png"/>
  233. <div id="u20163_text" class="text " style="display:none; visibility: hidden">
  234. <p></p>
  235. </div>
  236. </div>
  237. </div>
  238. </div>
  239. </div>
  240. <!-- Unnamed (Group) -->
  241. <div id="u20164" class="ax_default" data-left="104" data-top="1125" data-width="862" data-height="60">
  242. <!-- Unnamed (Rectangle) -->
  243. <div id="u20165" class="ax_default label">
  244. <div id="u20165_div" class=""></div>
  245. <div id="u20165_text" class="text " style="display:none; visibility: hidden">
  246. <p></p>
  247. </div>
  248. </div>
  249. <!-- Unnamed (Rectangle) -->
  250. <div id="u20166" class="ax_default box_1">
  251. <div id="u20166_div" class=""></div>
  252. <div id="u20166_text" class="text ">
  253. <p><span>保存</span></p>
  254. </div>
  255. </div>
  256. <!-- Unnamed (Rectangle) -->
  257. <div id="u20167" class="ax_default box_1">
  258. <div id="u20167_div" class=""></div>
  259. <div id="u20167_text" class="text ">
  260. <p><span>取消</span></p>
  261. </div>
  262. </div>
  263. </div>
  264. <!-- Unnamed (Rectangle) -->
  265. <div id="u20168" class="ax_default paragraph">
  266. <div id="u20168_div" class=""></div>
  267. <div id="u20168_text" class="text ">
  268. <p><span>单行文字</span></p>
  269. </div>
  270. </div>
  271. <!-- Unnamed (Group) -->
  272. <div id="u20169" class="ax_default" data-left="124" data-top="662" data-width="200" data-height="40">
  273. <!-- Unnamed (Rectangle) -->
  274. <div id="u20170" class="ax_default paragraph">
  275. <div id="u20170_div" class=""></div>
  276. <div id="u20170_text" class="text ">
  277. <p><span>公式</span></p>
  278. </div>
  279. </div>
  280. <!-- Unnamed (Rectangle) -->
  281. <div id="u20171" class="ax_default paragraph">
  282. <div id="u20171_div" class=""></div>
  283. <div id="u20171_text" class="text ">
  284. <p><span>字段</span></p>
  285. </div>
  286. </div>
  287. <!-- Unnamed (Line) -->
  288. <div id="u20172" class="ax_default line1">
  289. <img id="u20172_img" class="img " src="images/用户列表/u3719.svg"/>
  290. <div id="u20172_text" class="text " style="display:none; visibility: hidden">
  291. <p></p>
  292. </div>
  293. </div>
  294. </div>
  295. <!-- Unnamed (Rectangle) -->
  296. <div id="u20173" class="ax_default paragraph">
  297. <div id="u20173_div" class=""></div>
  298. <div id="u20173_text" class="text ">
  299. <p><span>在左侧选择函数或字段变量,且在英文输入法下编辑</span></p>
  300. </div>
  301. </div>
  302. <!-- Unnamed (Rectangle) -->
  303. <div id="u20174" class="ax_default paragraph">
  304. <div id="u20174_div" class=""></div>
  305. <div id="u20174_text" class="text ">
  306. <p><span>-|</span></p>
  307. </div>
  308. </div>
  309. <!-- Unnamed (Rectangle) -->
  310. <div id="u20175" class="ax_default paragraph">
  311. <div id="u20175_div" class=""></div>
  312. <div id="u20175_text" class="text ">
  313. <p><span>只能选择当前数据表的字段</span></p>
  314. </div>
  315. </div>
  316. <!-- Unnamed (Group) -->
  317. <div id="u20176" class="ax_default" data-left="124" data-top="772" data-width="190" data-height="25">
  318. <!-- Unnamed (Rectangle) -->
  319. <div id="u20177" class="ax_default paragraph">
  320. <div id="u20177_div" class=""></div>
  321. <div id="u20177_text" class="text ">
  322. <p><span>数字</span></p>
  323. </div>
  324. </div>
  325. <!-- Unnamed (Rectangle) -->
  326. <div id="u20178" class="ax_default paragraph">
  327. <div id="u20178_div" class=""></div>
  328. <div id="u20178_text" class="text ">
  329. <p><span>数字</span></p>
  330. </div>
  331. </div>
  332. </div>
  333. <!-- Unnamed (Group) -->
  334. <div id="u20179" class="ax_default" data-left="124" data-top="797" data-width="190" data-height="25">
  335. <!-- Unnamed (Rectangle) -->
  336. <div id="u20180" class="ax_default paragraph">
  337. <div id="u20180_div" class=""></div>
  338. <div id="u20180_text" class="text ">
  339. <p><span>电话</span></p>
  340. </div>
  341. </div>
  342. <!-- Unnamed (Rectangle) -->
  343. <div id="u20181" class="ax_default paragraph">
  344. <div id="u20181_div" class=""></div>
  345. <div id="u20181_text" class="text ">
  346. <p><span>数字</span></p>
  347. </div>
  348. </div>
  349. </div>
  350. <!-- Unnamed (Group) -->
  351. <div id="u20182" class="ax_default" data-left="124" data-top="822" data-width="190" data-height="25">
  352. <!-- Unnamed (Rectangle) -->
  353. <div id="u20183" class="ax_default paragraph">
  354. <div id="u20183_div" class=""></div>
  355. <div id="u20183_text" class="text ">
  356. <p><span>邮箱</span></p>
  357. </div>
  358. </div>
  359. <!-- Unnamed (Rectangle) -->
  360. <div id="u20184" class="ax_default paragraph">
  361. <div id="u20184_div" class=""></div>
  362. <div id="u20184_text" class="text ">
  363. <p><span>邮箱</span></p>
  364. </div>
  365. </div>
  366. </div>
  367. <!-- Unnamed (Group) -->
  368. <div id="u20185" class="ax_default" data-left="124" data-top="737" data-width="192" data-height="25">
  369. <!-- Unnamed (Rectangle) -->
  370. <div id="u20186" class="ax_default paragraph">
  371. <div id="u20186_div" class=""></div>
  372. <div id="u20186_text" class="text ">
  373. <p><span>目标字段</span></p>
  374. </div>
  375. </div>
  376. <!-- Unnamed (Shape) -->
  377. <div id="u20187" class="ax_default icon">
  378. <img id="u20187_img" class="img " src="images/编码/u18628.svg"/>
  379. <div id="u20187_text" class="text " style="display:none; visibility: hidden">
  380. <p></p>
  381. </div>
  382. </div>
  383. </div>
  384. </div>
  385. </div>
  386. <script src="resources/scripts/axure/ios.js"></script>
  387. </body>
  388. </html>