技术需知

技术需要知道的知识


封装查询

<h3>引用模块:helper/search_helper.js</h3> <h3>查询记录</h3> <h4>调用方法</h4> <pre><code class="language-javascript">searchHelper.queryRecord({type},{filters}, {columns});</code></pre> <h4>示例代码</h4> <pre><code class="language-javascript">var filters = []; //简单条件直接添加 filters.addFilter('type', search.Operator.IS, 'SalesOrd'); //关联条件可添加查询对象 filters.addFilter({ name : 'taxline', operator : search.Operator.IS, values : [ 'F' ] }); //查询列:简单列直接写名字,关联列可写对象 var columns = [ 'type', 'tranid', { name : 'email', join : 'customer' }, 'trandate', 'item', 'quantity' ]; var results = searchHelper.queryRecord(search.Type.TRANSACTION,filters, columns);</code></pre> <h4>结果示例</h4> <pre><code class="language-json">[ { "type":{ "value":"SalesOrd", "text":"销售订单" }, "tranid":"1", "customer_email":"1111@qq.com", "trandate":"2019-11-19", "item":"", "quantity":"" } ]</code></pre> <h4>结果数据结构</h4> <p>key:列名即为key,如果为关联查询,则key为{join}_{name} value:普通字段,根据key即可获取,列表字段则区分了value跟text</p> <h3>查询搜索</h3> <h4>调用方法</h4> <pre><code class="language-javascript">searchHelper.querySavedSearch({searchId},{filters});</code></pre> <h4>示例代码</h4> <pre><code class="language-javascript">var filters = []; filters.addFilter('internalid', search.Operator.IS, '1'); var results = searchHelper.querySavedSearch('customsearch_emp_v', filters);</code></pre> <h4>结果示例</h4> <p>同记录查询一样</p> <h4>结果数据结构</h4> <p>同记录查询一样</p>

页面列表

ITEM_HTML