127 lines
4.6 KiB
Plaintext
127 lines
4.6 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:filter_settings target="export" markerList="sc_onyma_service,sc_service_param_price_service_rcode">
|
||
<m:filterparam filter=#filter# param="abstract_service_id" ftype="numeric" list="Yes" expression="(s.abstract_service_id in (?))" default=""/>
|
||
<m:filterparam filter=#filter# param="dt_from" ftype="date" expression="(a.dt_status >=? AND a.status_id in (1,2))" default=""/>
|
||
<m:filterparam filter=#filter# param="dt_to" ftype="date" expression="(a.dt_status <=? AND a.status_id in (1,2))" default=""/>
|
||
</m:filter_settings>
|
||
|
||
<!---router--->
|
||
<cfif structKeyExists(FORM,"sc_onyma_service")>
|
||
<cflocation url="sc_onyma_service.cfm"/>
|
||
</cfif>
|
||
<cfif structKeyExists(FORM,"sc_service_param_price_service_rcode")>
|
||
<cflocation url="sc_service_param_price_service_rcode.cfm"/>
|
||
</cfif>
|
||
|
||
<m:prepare_ls entity="" pageInfoOut="pageInfo" trackOut="tr"/>
|
||
|
||
|
||
</m:silent><!---
|
||
-----------------------------------------------------------------------------------------
|
||
-----------------------------------------------------------------------------------------
|
||
-----------------------------------------------------------------------------------------
|
||
---><!---
|
||
---><layout:page section="header" pageInfo=#pageInfo#>
|
||
|
||
<layout:attribute name="title">
|
||
<cfoutput><b>#i18("Экспорт","Export")#</b></cfoutput>
|
||
</layout:attribute>
|
||
|
||
<layout:attribute name="controls">
|
||
<!---skip filter link, filter is not implemented--->
|
||
<!---<layout:language_switch/>--->
|
||
</layout:attribute>
|
||
</layout:page>
|
||
|
||
<cfif pageInfo.readPermitted() AND !pageInfo.status.errorState>
|
||
|
||
<cfoutput>
|
||
<form action="" method="post" >
|
||
<!--- <cfparam name="abstract_service_id" type="string" default=""/><!---list--->--->
|
||
<fieldset style="margin:1em; padding:1em; font-size:110%">
|
||
<legend>С фильтром по услугам</legend>
|
||
|
||
<div class="detail">
|
||
|
||
<div class="tr">
|
||
<div class="th">Коды услуг</div>
|
||
<div class="td">
|
||
<cfquery name="qAbstractService" datasource="#request.DS#">
|
||
select
|
||
abstract_service_id, abstract_service, code
|
||
from abstract_service a
|
||
where 1=1
|
||
order by a.code
|
||
</cfquery>
|
||
|
||
<c:combo
|
||
query=#qAbstractService#
|
||
combo="abstract_service_id"
|
||
id="abstract_service_id"
|
||
key="abstract_service_id"
|
||
displayf="##code## ##abstract_service##"
|
||
selected=#abstract_service_id#
|
||
empty=""
|
||
multiple="multiple"
|
||
size="10"
|
||
/>
|
||
<i>(множественное выделение)</i>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="tr">
|
||
<div class="th">С</div>
|
||
<div class="td">
|
||
<input type="text" name="dt_from" id="dt_from" value="#dateFormat(dt_from,'DD.MM.YYYY')#"/>
|
||
<button type="button" onclick="document.getElementById('dt_from').value='#DateFormat(Now(), 'DD.MM.YYYY')#';">Сегодня</button>
|
||
<i>по дате присвоения статуса "Проект" или "Активна"</i>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="tr">
|
||
<div class="th">По</div>
|
||
<div class="td">
|
||
<input type="text" name="dt_to" id="dt_to" value="#dateFormat(dt_to,'DD.MM.YYYY')#"/>
|
||
<button type="button" onclick="document.getElementById('dt_to').value='#DateFormat(Now(), 'DD.MM.YYYY')#';">Сегодня</button>
|
||
<i>по дате присвоения статуса "Проект" или "Активна"</i>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="tr">
|
||
<div class="th"></div>
|
||
<div class="td">
|
||
<button name="sc_onyma_service" style="font-size:110%; cursor:pointer; font-weight:bold;">SC_onyma_service</button>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="tr">
|
||
<div class="th"></div>
|
||
<div class="td">
|
||
<button name="sc_service_param_price_service_rcode" style="font-size:110%; cursor:pointer; font-weight:bold;">SC_service_param_price_Service_Rcode</button>
|
||
</div>
|
||
</div>
|
||
|
||
</div>
|
||
</fieldset>
|
||
</form>
|
||
</cfoutput>
|
||
|
||
<fieldset style="margin:1em; padding:1em; font-size:110%;line-height:2em;">
|
||
<legend>Без фильтра</legend>
|
||
|
||
<!--- <a href="sc_onyma_service.cfm">SC_onyma_service</a><br/>--->
|
||
<a href="sc_service_param_price.cfm" class="button" style="font-weight:bold; margin-left:10em;">SC_service_param_price</a><br/>
|
||
<a href="sc_rcode.cfm" class="button" style="font-weight:bold; margin-left:10em;">SC_Rcode</a><br/>
|
||
<!--- <a href="sc_service_param_price_service_rcode.cfm">SC_service_param_price_Service_Rcode</a><br/>--->
|
||
|
||
</fieldset>
|
||
|
||
</cfif>
|
||
<layout:page section="footer"/> |