payg/crm2cloud_filter.cfm

<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="crm2cloud" accessObject="" lsPage="crm2cloud" pageInfoOut="pageInfo" trackOut="tr"/>

<m:filter_settings target="crm2cloud"><!---*** вводит в заблуждение--->
	<m:filterparam filter=#filter# param="contragent_id" ftype="guid" compare="EQ" field="z.__id" default=""/>
	<m:filterparam filter=#filter# param="contragent" ftype="string" compare="LIKE%" field="z.__name" default=""/>
	<m:filterparam filter=#filter# param="wz" ftype="string" compare="LIKE%" field="z.id_klienta" default=""/>
	<m:filterparam filter=#filter# param="code" ftype="string" expression="(r.codes like ? OR r.codes like ? OR d.codes like ?)" suffix="%" prefix="%" default=""/>
	<!--- <m:filterparam filter=#filter# param="status_id" ftype="numeric" expression="ds.ar_status_ids = ?" suffix="" prefix="" default=""/> --->
	<!--- <m:filterparam filter=#filter# param="status_id" ftype="numeric" expression="(?=ANY(ds.ar_status_ids))" suffix="" prefix="" default=""/> --->
	<m:filterparam filter=#filter# param="status_id_list" ftype="integer" list="Yes" expression="(ds.ar_status_ids && ARRAY[?])" suffix="" prefix="" default=""/>
	<m:filterparam filter=#filter# param="line_pricing_model_id" ftype="numeric" expression="(?=ANY(ds.ar_line_pricing_model_id))" suffix="" prefix="" default=""/>
</m:filter_settings>

<cfif isDefined("resetAndClose") or isDefined("saveAndClose")>
	<cflocation url="#tr.backUrl#" addtoken="No"/>
</cfif>

</m:silent><!--- ----------------------------------------------------------------------------
--------------------------------------------------------------------------------------------- 
---------------------------------------------------------------------------------------------
---><layout:page section="header" pageInfo=#pageInfo#>
	<layout:attribute name="title"><cfoutput>Сверка - фильтр</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="code" value="#code#" size="50"/> 
				<i>#i18("по вхождению подстроки в любой из списков кодов","by substring")#</i>
			</div>
		</div>	

		<div class="tr">
			<div class="th">Статус</div>
			<div class="td">



				<!--- *** костыль --->
				<cfquery name="qStatus">
				SELECT * from (
					 VALUES 
					   --('Закрыта неуспешно',7,0) ,
					   ('Закрыта успешно',6,100)       ,
					   ('Договор подписан',5,100)       ,
					   ('Договор на подписании',15,90)  ,
					   ('Договор на согласовании',12,70),
					   ('Тестирование',8,50)           
					   --('Отправлено ТКП',10,20)         ,
					   --('Внутреннее согласование',37,10),
					   --('Проработка решения',4,10),      
					   --('Сбор потребностей',1,0) 
				) as status (status, status_id, probability_pc) 
				ORDER BY probability_pc, status_id 
				</cfquery>
				
				<c:combo 
					query=#qStatus# 
					combo="status_id_list" 
					id="status_id" 
					key="status_id" 
					displayf="##status## (##status_id##: ##probability_pc##%)" 
					selected=#status_id_list# 
					empty=""
					multiple="multiple" 
					size="6"
				/>	
				<i>для выбора нескольких значений используйте CTRL или SHIFT (для диапазона)</i>
			</div>
		</div>			
		
		<div class="tr">
			<div class="th">Модель оплаты</div>
			<div class="td">
				<select name="line_pricing_model_id">
					<option></option>
					<option value="1"<cfif line_pricing_model_id EQ 1> selected</cfif>>1 install</option>
					<option value=3""<cfif line_pricing_model_id EQ 2> selected</cfif>>2 fix</option>
					<option value="3"<cfif line_pricing_model_id EQ 3> selected</cfif>>3 metered</option>					
				</select>
				<i>по вхождению в список</i>
			</div>
		</div>	
		
		<div class="tr">
			<div class="th">Контрагент</div>
			<div class="td">
				<input type="text" name="contragent" value="#contragent#" size="50"/> 
				<i>#i18("по вхождению подстроки","by substring")#</i>
			</div>
		</div>			
		
		<div class="tr">
			<div class="th">WZ</div>
			<div class="td">
				<input type="text" name="wz" value="#wz#" size="50"/> 
				<i>#i18("по вхождению подстроки","by substring")#</i>
			</div>
		</div>		
		
		<div class="tr">
			<div class="th">Контрагент</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>
		
		
		
	</div><!--- detail --->	


</cfoutput>

<layout:page section="footer" closeForm="Yes"/>
<!--- <cfdump var=#filter#> --->