123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441 |
- <!DOCTYPE html>
- <html>
- <head>
- <title>通过公式计算</title>
- <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
- <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
- <link href="resources/css/axure_rp_page.css" type="text/css" rel="stylesheet"/>
- <link href="data/styles.css" type="text/css" rel="stylesheet"/>
- <link href="files/通过公式计算/styles.css" type="text/css" rel="stylesheet"/>
- <script src="resources/scripts/jquery-3.2.1.min.js"></script>
- <script src="resources/scripts/axure/axQuery.js"></script>
- <script src="resources/scripts/axure/globals.js"></script>
- <script src="resources/scripts/axutils.js"></script>
- <script src="resources/scripts/axure/annotation.js"></script>
- <script src="resources/scripts/axure/axQuery.std.js"></script>
- <script src="resources/scripts/axure/doc.js"></script>
- <script src="resources/scripts/messagecenter.js"></script>
- <script src="resources/scripts/axure/events.js"></script>
- <script src="resources/scripts/axure/recording.js"></script>
- <script src="resources/scripts/axure/action.js"></script>
- <script src="resources/scripts/axure/expr.js"></script>
- <script src="resources/scripts/axure/geometry.js"></script>
- <script src="resources/scripts/axure/flyout.js"></script>
- <script src="resources/scripts/axure/model.js"></script>
- <script src="resources/scripts/axure/repeater.js"></script>
- <script src="resources/scripts/axure/sto.js"></script>
- <script src="resources/scripts/axure/utils.temp.js"></script>
- <script src="resources/scripts/axure/variables.js"></script>
- <script src="resources/scripts/axure/drag.js"></script>
- <script src="resources/scripts/axure/move.js"></script>
- <script src="resources/scripts/axure/visibility.js"></script>
- <script src="resources/scripts/axure/style.js"></script>
- <script src="resources/scripts/axure/adaptive.js"></script>
- <script src="resources/scripts/axure/tree.js"></script>
- <script src="resources/scripts/axure/init.temp.js"></script>
- <script src="resources/scripts/axure/legacy.js"></script>
- <script src="resources/scripts/axure/viewer.js"></script>
- <script src="resources/scripts/axure/math.js"></script>
- <script src="resources/scripts/axure/jquery.nicescroll.min.js"></script>
- <script src="data/document.js"></script>
- <script src="files/通过公式计算/data.js"></script>
- <script type="text/javascript">
- $axure.utils.getTransparentGifPath = function() { return 'resources/images/transparent.gif'; };
- $axure.utils.getOtherPath = function() { return 'resources/Other.html'; };
- $axure.utils.getReloadPath = function() { return 'resources/reload.html'; };
- </script>
- </head>
- <body>
- <div id="base" class="">
- <!-- Unnamed (Group) -->
- <div id="u20135" class="ax_default" data-left="104" data-top="103" data-width="862" data-height="480">
- <!-- Unnamed (Rectangle) -->
- <div id="u20136" class="ax_default box_1">
- <div id="u20136_div" class=""></div>
- <div id="u20136_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20137" class="ax_default label">
- <div id="u20137_div" class=""></div>
- <div id="u20137_text" class="text ">
- <p><span>通过公式计算</span></p>
- </div>
- </div>
- <!-- del (Dynamic Panel) -->
- <div id="u20138" class="ax_default" data-label="del">
- <div id="u20138_state0" class="panel_state" data-label="normal" style="">
- <div id="u20138_state0_content" class="panel_state_content">
- <!-- Unnamed (Image) -->
- <div id="u20139" class="ax_default image">
- <img id="u20139_img" class="img " src="images/功能管理/u13453.png"/>
- <div id="u20139_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- </div>
- <div id="u20138_state1" class="panel_state" data-label="hover" style="visibility: hidden;">
- <div id="u20138_state1_content" class="panel_state_content">
- <!-- Unnamed (Image) -->
- <div id="u20140" class="ax_default image">
- <img id="u20140_img" class="img " src="images/功能管理/u13454.png"/>
- <div id="u20140_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20141" class="ax_default" data-left="104" data-top="523" data-width="862" data-height="60">
- <!-- Unnamed (Rectangle) -->
- <div id="u20142" class="ax_default label">
- <div id="u20142_div" class=""></div>
- <div id="u20142_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20143" class="ax_default box_1">
- <div id="u20143_div" class=""></div>
- <div id="u20143_text" class="text ">
- <p><span>保存</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20144" class="ax_default box_1">
- <div id="u20144_div" class=""></div>
- <div id="u20144_text" class="text ">
- <p><span>取消</span></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20145" class="ax_default paragraph">
- <div id="u20145_div" class=""></div>
- <div id="u20145_text" class="text ">
- <p><span>单行文字</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20146" class="ax_default paragraph">
- <div id="u20146_div" class=""></div>
- <div id="u20146_text" class="text ">
- <p><span>在左侧选择函数或字段变量,且在英文输入法下编辑</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20147" class="ax_default paragraph">
- <div id="u20147_div" class=""></div>
- <div id="u20147_text" class="text ">
- <p><span>-|</span></p>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20148" class="ax_default" data-left="124" data-top="173" data-width="200" data-height="40">
- <!-- Unnamed (Rectangle) -->
- <div id="u20149" class="ax_default paragraph">
- <div id="u20149_div" class=""></div>
- <div id="u20149_text" class="text ">
- <p><span>公式</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20150" class="ax_default paragraph">
- <div id="u20150_div" class=""></div>
- <div id="u20150_text" class="text ">
- <p><span>字段</span></p>
- </div>
- </div>
- <!-- Unnamed (Line) -->
- <div id="u20151" class="ax_default line1">
- <img id="u20151_img" class="img " src="images/用户列表/u3719.svg"/>
- <div id="u20151_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20152" class="ax_default" data-left="134" data-top="223" data-width="73" data-height="27">
- <!-- Unnamed (Rectangle) -->
- <div id="u20153" class="ax_default paragraph">
- <div id="u20153_div" class=""></div>
- <div id="u20153_text" class="text ">
- <p><span>常用函数</span></p>
- </div>
- </div>
- <!-- Unnamed (Shape) -->
- <div id="u20154" class="ax_default icon">
- <img id="u20154_img" class="img " src="images/编码/u18628.svg"/>
- <div id="u20154_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20155" class="ax_default paragraph">
- <div id="u20155_div" class=""></div>
- <div id="u20155_text" class="text ">
- <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>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20156" class="ax_default paragraph">
- <div id="u20156_div" class=""></div>
- <div id="u20156_text" class="text ">
- <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>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20157" class="ax_default paragraph">
- <div id="u20157_div" class=""></div>
- <div id="u20157_text" class="text ">
- <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>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20158" class="ax_default" data-left="104" data-top="600" data-width="862" data-height="585">
- <!-- Unnamed (Rectangle) -->
- <div id="u20159" class="ax_default box_1">
- <div id="u20159_div" class=""></div>
- <div id="u20159_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20160" class="ax_default label">
- <div id="u20160_div" class=""></div>
- <div id="u20160_text" class="text ">
- <p><span>通过公式计算</span></p>
- </div>
- </div>
- <!-- del (Dynamic Panel) -->
- <div id="u20161" class="ax_default" data-label="del">
- <div id="u20161_state0" class="panel_state" data-label="normal" style="">
- <div id="u20161_state0_content" class="panel_state_content">
- <!-- Unnamed (Image) -->
- <div id="u20162" class="ax_default image">
- <img id="u20162_img" class="img " src="images/功能管理/u13453.png"/>
- <div id="u20162_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- </div>
- <div id="u20161_state1" class="panel_state" data-label="hover" style="visibility: hidden;">
- <div id="u20161_state1_content" class="panel_state_content">
- <!-- Unnamed (Image) -->
- <div id="u20163" class="ax_default image">
- <img id="u20163_img" class="img " src="images/功能管理/u13454.png"/>
- <div id="u20163_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20164" class="ax_default" data-left="104" data-top="1125" data-width="862" data-height="60">
- <!-- Unnamed (Rectangle) -->
- <div id="u20165" class="ax_default label">
- <div id="u20165_div" class=""></div>
- <div id="u20165_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20166" class="ax_default box_1">
- <div id="u20166_div" class=""></div>
- <div id="u20166_text" class="text ">
- <p><span>保存</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20167" class="ax_default box_1">
- <div id="u20167_div" class=""></div>
- <div id="u20167_text" class="text ">
- <p><span>取消</span></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20168" class="ax_default paragraph">
- <div id="u20168_div" class=""></div>
- <div id="u20168_text" class="text ">
- <p><span>单行文字</span></p>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20169" class="ax_default" data-left="124" data-top="662" data-width="200" data-height="40">
- <!-- Unnamed (Rectangle) -->
- <div id="u20170" class="ax_default paragraph">
- <div id="u20170_div" class=""></div>
- <div id="u20170_text" class="text ">
- <p><span>公式</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20171" class="ax_default paragraph">
- <div id="u20171_div" class=""></div>
- <div id="u20171_text" class="text ">
- <p><span>字段</span></p>
- </div>
- </div>
- <!-- Unnamed (Line) -->
- <div id="u20172" class="ax_default line1">
- <img id="u20172_img" class="img " src="images/用户列表/u3719.svg"/>
- <div id="u20172_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20173" class="ax_default paragraph">
- <div id="u20173_div" class=""></div>
- <div id="u20173_text" class="text ">
- <p><span>在左侧选择函数或字段变量,且在英文输入法下编辑</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20174" class="ax_default paragraph">
- <div id="u20174_div" class=""></div>
- <div id="u20174_text" class="text ">
- <p><span>-|</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20175" class="ax_default paragraph">
- <div id="u20175_div" class=""></div>
- <div id="u20175_text" class="text ">
- <p><span>只能选择当前数据表的字段</span></p>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20176" class="ax_default" data-left="124" data-top="772" data-width="190" data-height="25">
- <!-- Unnamed (Rectangle) -->
- <div id="u20177" class="ax_default paragraph">
- <div id="u20177_div" class=""></div>
- <div id="u20177_text" class="text ">
- <p><span>数字</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20178" class="ax_default paragraph">
- <div id="u20178_div" class=""></div>
- <div id="u20178_text" class="text ">
- <p><span>数字</span></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20179" class="ax_default" data-left="124" data-top="797" data-width="190" data-height="25">
- <!-- Unnamed (Rectangle) -->
- <div id="u20180" class="ax_default paragraph">
- <div id="u20180_div" class=""></div>
- <div id="u20180_text" class="text ">
- <p><span>电话</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20181" class="ax_default paragraph">
- <div id="u20181_div" class=""></div>
- <div id="u20181_text" class="text ">
- <p><span>数字</span></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20182" class="ax_default" data-left="124" data-top="822" data-width="190" data-height="25">
- <!-- Unnamed (Rectangle) -->
- <div id="u20183" class="ax_default paragraph">
- <div id="u20183_div" class=""></div>
- <div id="u20183_text" class="text ">
- <p><span>邮箱</span></p>
- </div>
- </div>
- <!-- Unnamed (Rectangle) -->
- <div id="u20184" class="ax_default paragraph">
- <div id="u20184_div" class=""></div>
- <div id="u20184_text" class="text ">
- <p><span>邮箱</span></p>
- </div>
- </div>
- </div>
- <!-- Unnamed (Group) -->
- <div id="u20185" class="ax_default" data-left="124" data-top="737" data-width="192" data-height="25">
- <!-- Unnamed (Rectangle) -->
- <div id="u20186" class="ax_default paragraph">
- <div id="u20186_div" class=""></div>
- <div id="u20186_text" class="text ">
- <p><span>目标字段</span></p>
- </div>
- </div>
- <!-- Unnamed (Shape) -->
- <div id="u20187" class="ax_default icon">
- <img id="u20187_img" class="img " src="images/编码/u18628.svg"/>
- <div id="u20187_text" class="text " style="display:none; visibility: hidden">
- <p></p>
- </div>
- </div>
- </div>
- </div>
- </div>
- <script src="resources/scripts/axure/ios.js"></script>
- </body>
- </html>
|