数据列表管理-顶部查询条件的自定义代码参考

发布时间 2023-05-20 16:00:03作者: liskov_design
 

银行:<select id="sl_bank" class="fsbpmserachcontrol search_select" myts="sl"></select>

状态:<select id="sl_status_filter" class="fsbpmserachcontrol search_select" myts="sl">
    <option mykey="status" mycalc="equals" value="1" selected="selected">待审核</option>
    <option mykey="status" mycalc="equals" value="2">已审核</option>
    <option mykey="status" mycalc="equals" value="3">已生成</option>
    <option mykey="status" mycalc="equals_not" value="-1">全部</option>
</select>

    交易金额:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="trans_amonut" mycalc="equals"/>

    业务类型:<input id="txt_bis_type" type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="bis_type" mycalc="equals"/>

    交易类型:<select class="fsbpmserachcontrol search_select" myts="sl">
    <option value="" mykey="trans_type" mycalc="equals" selected="selected">请选择</option>
    <option value="来账" mykey="trans_type" mycalc="equals">来账</option>
    <option value="往账" mykey="trans_type" mycalc="equals">往账</option>
</select>

    销账金额:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="write_off_amount" mycalc="equals"/>

    交易日期:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="trans_date" mycalc="big_than" onClick="WdatePicker()"/>~<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="trans_date" mycalc="less_than" onClick="WdatePicker()"/>

    交易抬头:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="trans_title" mycalc="like"/>



-- 注意 --
数据查询过滤的class样式的一定为:fsbpmserachcontrol ,输入控件的UI样式为:search_txt 或者 search_select myts代表输入input输入对象的控件类型,一般为txt和sl mykey代表数据库模型的项目值,比如:trans_date
mycalc为匹配方式: equals 为完全相等 equals_not 为完全不等于 big_than为大于运算 less_than为小于