通过公式计算.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="u11670" class="ax_default" data-left="104" data-top="103" data-width="862" data-height="480">
  52. <!-- Unnamed (Rectangle) -->
  53. <div id="u11671" class="ax_default box_1">
  54. <div id="u11671_div" class=""></div>
  55. <div id="u11671_text" class="text " style="display:none; visibility: hidden">
  56. <p></p>
  57. </div>
  58. </div>
  59. <!-- Unnamed (Rectangle) -->
  60. <div id="u11672" class="ax_default label">
  61. <div id="u11672_div" class=""></div>
  62. <div id="u11672_text" class="text ">
  63. <p><span>通过公式计算</span></p>
  64. </div>
  65. </div>
  66. <!-- del (Dynamic Panel) -->
  67. <div id="u11673" class="ax_default" data-label="del">
  68. <div id="u11673_state0" class="panel_state" data-label="normal" style="">
  69. <div id="u11673_state0_content" class="panel_state_content">
  70. <!-- Unnamed (Image) -->
  71. <div id="u11674" class="ax_default image">
  72. <img id="u11674_img" class="img " src="images/单项选择/u9451.png"/>
  73. <div id="u11674_text" class="text " style="display:none; visibility: hidden">
  74. <p></p>
  75. </div>
  76. </div>
  77. </div>
  78. </div>
  79. <div id="u11673_state1" class="panel_state" data-label="hover" style="visibility: hidden;">
  80. <div id="u11673_state1_content" class="panel_state_content">
  81. <!-- Unnamed (Image) -->
  82. <div id="u11675" class="ax_default image">
  83. <img id="u11675_img" class="img " src="images/单项选择/u9452.png"/>
  84. <div id="u11675_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="u11676" class="ax_default" data-left="104" data-top="523" data-width="862" data-height="60">
  93. <!-- Unnamed (Rectangle) -->
  94. <div id="u11677" class="ax_default label">
  95. <div id="u11677_div" class=""></div>
  96. <div id="u11677_text" class="text " style="display:none; visibility: hidden">
  97. <p></p>
  98. </div>
  99. </div>
  100. <!-- Unnamed (Rectangle) -->
  101. <div id="u11678" class="ax_default box_1">
  102. <div id="u11678_div" class=""></div>
  103. <div id="u11678_text" class="text ">
  104. <p><span>保存</span></p>
  105. </div>
  106. </div>
  107. <!-- Unnamed (Rectangle) -->
  108. <div id="u11679" class="ax_default box_1">
  109. <div id="u11679_div" class=""></div>
  110. <div id="u11679_text" class="text ">
  111. <p><span>取消</span></p>
  112. </div>
  113. </div>
  114. </div>
  115. <!-- Unnamed (Rectangle) -->
  116. <div id="u11680" class="ax_default paragraph">
  117. <div id="u11680_div" class=""></div>
  118. <div id="u11680_text" class="text ">
  119. <p><span>单行文字</span></p>
  120. </div>
  121. </div>
  122. <!-- Unnamed (Rectangle) -->
  123. <div id="u11681" class="ax_default paragraph">
  124. <div id="u11681_div" class=""></div>
  125. <div id="u11681_text" class="text ">
  126. <p><span>在左侧选择函数或字段变量,且在英文输入法下编辑</span></p>
  127. </div>
  128. </div>
  129. <!-- Unnamed (Rectangle) -->
  130. <div id="u11682" class="ax_default paragraph">
  131. <div id="u11682_div" class=""></div>
  132. <div id="u11682_text" class="text ">
  133. <p><span>-|</span></p>
  134. </div>
  135. </div>
  136. <!-- Unnamed (Group) -->
  137. <div id="u11683" class="ax_default" data-left="124" data-top="173" data-width="200" data-height="40">
  138. <!-- Unnamed (Rectangle) -->
  139. <div id="u11684" class="ax_default paragraph">
  140. <div id="u11684_div" class=""></div>
  141. <div id="u11684_text" class="text ">
  142. <p><span>公式</span></p>
  143. </div>
  144. </div>
  145. <!-- Unnamed (Rectangle) -->
  146. <div id="u11685" class="ax_default paragraph">
  147. <div id="u11685_div" class=""></div>
  148. <div id="u11685_text" class="text ">
  149. <p><span>字段</span></p>
  150. </div>
  151. </div>
  152. <!-- Unnamed (Line) -->
  153. <div id="u11686" class="ax_default line1">
  154. <img id="u11686_img" class="img " src="images/用户列表/u3703.svg"/>
  155. <div id="u11686_text" class="text " style="display:none; visibility: hidden">
  156. <p></p>
  157. </div>
  158. </div>
  159. </div>
  160. <!-- Unnamed (Group) -->
  161. <div id="u11687" class="ax_default" data-left="134" data-top="223" data-width="73" data-height="27">
  162. <!-- Unnamed (Rectangle) -->
  163. <div id="u11688" class="ax_default paragraph">
  164. <div id="u11688_div" class=""></div>
  165. <div id="u11688_text" class="text ">
  166. <p><span>常用函数</span></p>
  167. </div>
  168. </div>
  169. <!-- Unnamed (Shape) -->
  170. <div id="u11689" class="ax_default icon">
  171. <img id="u11689_img" class="img " src="images/编码/u10163.svg"/>
  172. <div id="u11689_text" class="text " style="display:none; visibility: hidden">
  173. <p></p>
  174. </div>
  175. </div>
  176. </div>
  177. <!-- Unnamed (Rectangle) -->
  178. <div id="u11690" class="ax_default paragraph">
  179. <div id="u11690_div" class=""></div>
  180. <div id="u11690_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="u11691" class="ax_default paragraph">
  186. <div id="u11691_div" class=""></div>
  187. <div id="u11691_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="u11692" class="ax_default paragraph">
  193. <div id="u11692_div" class=""></div>
  194. <div id="u11692_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="u11693" class="ax_default" data-left="104" data-top="600" data-width="862" data-height="585">
  201. <!-- Unnamed (Rectangle) -->
  202. <div id="u11694" class="ax_default box_1">
  203. <div id="u11694_div" class=""></div>
  204. <div id="u11694_text" class="text " style="display:none; visibility: hidden">
  205. <p></p>
  206. </div>
  207. </div>
  208. <!-- Unnamed (Rectangle) -->
  209. <div id="u11695" class="ax_default label">
  210. <div id="u11695_div" class=""></div>
  211. <div id="u11695_text" class="text ">
  212. <p><span>通过公式计算</span></p>
  213. </div>
  214. </div>
  215. <!-- del (Dynamic Panel) -->
  216. <div id="u11696" class="ax_default" data-label="del">
  217. <div id="u11696_state0" class="panel_state" data-label="normal" style="">
  218. <div id="u11696_state0_content" class="panel_state_content">
  219. <!-- Unnamed (Image) -->
  220. <div id="u11697" class="ax_default image">
  221. <img id="u11697_img" class="img " src="images/单项选择/u9451.png"/>
  222. <div id="u11697_text" class="text " style="display:none; visibility: hidden">
  223. <p></p>
  224. </div>
  225. </div>
  226. </div>
  227. </div>
  228. <div id="u11696_state1" class="panel_state" data-label="hover" style="visibility: hidden;">
  229. <div id="u11696_state1_content" class="panel_state_content">
  230. <!-- Unnamed (Image) -->
  231. <div id="u11698" class="ax_default image">
  232. <img id="u11698_img" class="img " src="images/单项选择/u9452.png"/>
  233. <div id="u11698_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="u11699" class="ax_default" data-left="104" data-top="1125" data-width="862" data-height="60">
  242. <!-- Unnamed (Rectangle) -->
  243. <div id="u11700" class="ax_default label">
  244. <div id="u11700_div" class=""></div>
  245. <div id="u11700_text" class="text " style="display:none; visibility: hidden">
  246. <p></p>
  247. </div>
  248. </div>
  249. <!-- Unnamed (Rectangle) -->
  250. <div id="u11701" class="ax_default box_1">
  251. <div id="u11701_div" class=""></div>
  252. <div id="u11701_text" class="text ">
  253. <p><span>保存</span></p>
  254. </div>
  255. </div>
  256. <!-- Unnamed (Rectangle) -->
  257. <div id="u11702" class="ax_default box_1">
  258. <div id="u11702_div" class=""></div>
  259. <div id="u11702_text" class="text ">
  260. <p><span>取消</span></p>
  261. </div>
  262. </div>
  263. </div>
  264. <!-- Unnamed (Rectangle) -->
  265. <div id="u11703" class="ax_default paragraph">
  266. <div id="u11703_div" class=""></div>
  267. <div id="u11703_text" class="text ">
  268. <p><span>单行文字</span></p>
  269. </div>
  270. </div>
  271. <!-- Unnamed (Group) -->
  272. <div id="u11704" class="ax_default" data-left="124" data-top="662" data-width="200" data-height="40">
  273. <!-- Unnamed (Rectangle) -->
  274. <div id="u11705" class="ax_default paragraph">
  275. <div id="u11705_div" class=""></div>
  276. <div id="u11705_text" class="text ">
  277. <p><span>公式</span></p>
  278. </div>
  279. </div>
  280. <!-- Unnamed (Rectangle) -->
  281. <div id="u11706" class="ax_default paragraph">
  282. <div id="u11706_div" class=""></div>
  283. <div id="u11706_text" class="text ">
  284. <p><span>字段</span></p>
  285. </div>
  286. </div>
  287. <!-- Unnamed (Line) -->
  288. <div id="u11707" class="ax_default line1">
  289. <img id="u11707_img" class="img " src="images/用户列表/u3703.svg"/>
  290. <div id="u11707_text" class="text " style="display:none; visibility: hidden">
  291. <p></p>
  292. </div>
  293. </div>
  294. </div>
  295. <!-- Unnamed (Rectangle) -->
  296. <div id="u11708" class="ax_default paragraph">
  297. <div id="u11708_div" class=""></div>
  298. <div id="u11708_text" class="text ">
  299. <p><span>在左侧选择函数或字段变量,且在英文输入法下编辑</span></p>
  300. </div>
  301. </div>
  302. <!-- Unnamed (Rectangle) -->
  303. <div id="u11709" class="ax_default paragraph">
  304. <div id="u11709_div" class=""></div>
  305. <div id="u11709_text" class="text ">
  306. <p><span>-|</span></p>
  307. </div>
  308. </div>
  309. <!-- Unnamed (Rectangle) -->
  310. <div id="u11710" class="ax_default paragraph">
  311. <div id="u11710_div" class=""></div>
  312. <div id="u11710_text" class="text ">
  313. <p><span>只能选择当前数据表的字段</span></p>
  314. </div>
  315. </div>
  316. <!-- Unnamed (Group) -->
  317. <div id="u11711" class="ax_default" data-left="124" data-top="772" data-width="190" data-height="25">
  318. <!-- Unnamed (Rectangle) -->
  319. <div id="u11712" class="ax_default paragraph">
  320. <div id="u11712_div" class=""></div>
  321. <div id="u11712_text" class="text ">
  322. <p><span>数字</span></p>
  323. </div>
  324. </div>
  325. <!-- Unnamed (Rectangle) -->
  326. <div id="u11713" class="ax_default paragraph">
  327. <div id="u11713_div" class=""></div>
  328. <div id="u11713_text" class="text ">
  329. <p><span>数字</span></p>
  330. </div>
  331. </div>
  332. </div>
  333. <!-- Unnamed (Group) -->
  334. <div id="u11714" class="ax_default" data-left="124" data-top="797" data-width="190" data-height="25">
  335. <!-- Unnamed (Rectangle) -->
  336. <div id="u11715" class="ax_default paragraph">
  337. <div id="u11715_div" class=""></div>
  338. <div id="u11715_text" class="text ">
  339. <p><span>电话</span></p>
  340. </div>
  341. </div>
  342. <!-- Unnamed (Rectangle) -->
  343. <div id="u11716" class="ax_default paragraph">
  344. <div id="u11716_div" class=""></div>
  345. <div id="u11716_text" class="text ">
  346. <p><span>数字</span></p>
  347. </div>
  348. </div>
  349. </div>
  350. <!-- Unnamed (Group) -->
  351. <div id="u11717" class="ax_default" data-left="124" data-top="822" data-width="190" data-height="25">
  352. <!-- Unnamed (Rectangle) -->
  353. <div id="u11718" class="ax_default paragraph">
  354. <div id="u11718_div" class=""></div>
  355. <div id="u11718_text" class="text ">
  356. <p><span>邮箱</span></p>
  357. </div>
  358. </div>
  359. <!-- Unnamed (Rectangle) -->
  360. <div id="u11719" class="ax_default paragraph">
  361. <div id="u11719_div" class=""></div>
  362. <div id="u11719_text" class="text ">
  363. <p><span>邮箱</span></p>
  364. </div>
  365. </div>
  366. </div>
  367. <!-- Unnamed (Group) -->
  368. <div id="u11720" class="ax_default" data-left="124" data-top="737" data-width="192" data-height="25">
  369. <!-- Unnamed (Rectangle) -->
  370. <div id="u11721" class="ax_default paragraph">
  371. <div id="u11721_div" class=""></div>
  372. <div id="u11721_text" class="text ">
  373. <p><span>目标字段</span></p>
  374. </div>
  375. </div>
  376. <!-- Unnamed (Shape) -->
  377. <div id="u11722" class="ax_default icon">
  378. <img id="u11722_img" class="img " src="images/编码/u10163.svg"/>
  379. <div id="u11722_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>