145 lines
4.8 KiB
Plaintext
145 lines
4.8 KiB
Plaintext
<cfsilent>
|
|
<cfimport prefix="m" taglib="lib"/>
|
|
<cfimport prefix="c" taglib="lib/controls"/>
|
|
<cfimport prefix="d" taglib="lib/data"/>
|
|
<cfimport prefix="layout" taglib="layout"/>
|
|
</cfsilent><m:silent silent="No">
|
|
|
|
<m:prepare_filter entity="s3_user" accessObject="" lsPage="s3_ls" pageInfoOut="pageInfo" trackOut="tr"/>
|
|
|
|
<m:filter_settings target="s3_user">
|
|
<m:filterparam filter=#filter# param="owner" ftype="string" compare="LIKE%" field="s.owner" default=""/>
|
|
<m:filterparam filter=#filter# param="display_name" ftype="string" compare="LIKE%" field="u.display_name" default=""/>
|
|
<m:filterparam filter=#filter# param="contragent" ftype="string" compare="LIKE%" field="c.contragent" default=""/>
|
|
<!--- <m:filterparam filter=#filter# param="contragent_id" ftype="guid" compare="EQ" field="k.__id" default=""/> --->
|
|
<m:filterparam filter=#filter# param="wz" ftype="string" compare="LIKE%" field="c.wz" default=""/>
|
|
<m:filterparam filter=#filter# param="wzs" ftype="string" compare="LIKE%" field="u.wz" default=""/>
|
|
<m:filterparam filter=#filter# param="external_code" ftype="string" compare="LIKE%" field="u.external_code" default=""/>
|
|
</m:filter_settings>
|
|
|
|
<cfif isDefined("resetAndClose") or isDefined("saveAndClose")>
|
|
<cflocation url="#tr.backUrl#" addtoken="No"/>
|
|
</cfif>
|
|
|
|
<!--- ЗАСАДА для inmem HSQLDB: не поддерживает ilike --->
|
|
|
|
</m:silent><!--- ----------------------------------------------------------------------------
|
|
---------------------------------------------------------------------------------------------
|
|
---------------------------------------------------------------------------------------------
|
|
---><layout:page section="header" pageInfo=#pageInfo#>
|
|
<layout:attribute name="title"><cfoutput>Учетные записи S3 - фильтр</cfoutput></layout:attribute>
|
|
</layout:page>
|
|
|
|
<!--- <script type="text/javascript"/>
|
|
$(document).ready(function() {
|
|
try {
|
|
$("#contragent_id").searchable({maxMultiMatch: 50});
|
|
} catch (e) {alert(e)}
|
|
});
|
|
</script> --->
|
|
|
|
<cfoutput>
|
|
<input type="hidden" name="track" value="#tr.self#"/>
|
|
|
|
<div class="detail">
|
|
|
|
<div class="tr">
|
|
<div class="th"></div>
|
|
<div class="td">
|
|
<button type="button" name="reset" onClick="document.location.href='#request.thisPage#?reset=yes&track=#tr.self#'">#i18("Очистить","Clear")#</button>
|
|
</div>
|
|
</div>
|
|
|
|
<!--- <div class="tr">
|
|
<div class="th">Номер сделки</div>
|
|
<div class="td">
|
|
<input type="text" name="__index" value="#__index#" size="5"/>
|
|
<i></i>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tr">
|
|
<div class="th">Название сделки</div>
|
|
<div class="td">
|
|
<input type="text" name="__name" value="#__name#" size="50"/>
|
|
<i>#i18("по вхождению подстроки","by substring")#</i>
|
|
</div>
|
|
</div> --->
|
|
|
|
<!--- <div class="tr">
|
|
<div class="th">Контрагент (CMDB)</div>
|
|
<div class="td" style="vertical-align:top;">
|
|
<cfquery name="qList">
|
|
select __id::text as __id, __name, id_klienta
|
|
from elma.companies
|
|
order by __name
|
|
</cfquery>
|
|
<!--- <cfdump var=#qList#/> --->
|
|
|
|
<c:combo
|
|
query=#qList#
|
|
combo="contragent_id"
|
|
id="contragent_id"
|
|
key="__id"
|
|
displayf="##__name## ##id_klienta##"
|
|
selected=#contragent_id#
|
|
empty=""
|
|
/>
|
|
</div>
|
|
--->
|
|
|
|
<div class="tr">
|
|
<div class="th">Контрагент (CMDB)</div>
|
|
<div class="td">
|
|
<input type="text" name="contragent" value="#contragent#" size="50"/>
|
|
<i>по вхождению подстроки</i>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tr">
|
|
<div class="th">WZ (по точному совпадению с именем учетки)</div>
|
|
<div class="td">
|
|
<input type="text" name="wz" value="#wz#" size="50"/>
|
|
<i>по вхождению подстроки</i>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tr">
|
|
<div class="th">WZ (state)</div>
|
|
<div class="td">
|
|
<input type="text" name="wzs" value="#wzs#" size="50"/>
|
|
<i>по вхождению подстроки</i>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tr">
|
|
<div class="th">WZ (instance)</div>
|
|
<div class="td">
|
|
<input type="text" name="external_code" value="#external_code#" size="50"/>
|
|
<i>по вхождению подстроки</i>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tr">
|
|
<div class="th">Owner (имя учетки S3)</div>
|
|
<div class="td">
|
|
<input type="text" name="owner" value="#owner#" size="50"/>
|
|
<i>по вхождению подстроки</i>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="tr">
|
|
<div class="th">Display Name экземпляра в CMDB</div>
|
|
<div class="td">
|
|
<input type="text" name="display_name" value="#display_name#" size="50"/>
|
|
<i>по вхождению подстроки</i>
|
|
</div>
|
|
</div>
|
|
|
|
</div>
|
|
|
|
|
|
</cfoutput>
|
|
|
|
<layout:page section="footer" closeForm="Yes"/>
|
|
<!--- <cfdump var=#filter#> ---> |