145 lines
6.7 KiB
Plaintext
145 lines
6.7 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_ls entity="param" pageInfoOut="pageInfo" trackOut="tr"/>
|
|
|
|
<m:filter_settings target="#pageInfo.entity#_ls">
|
|
<m:filterparam filter=#filter# param="quickfilter" ftype="string" prefix="%" suffix="%" expression="((p.project like ?) OR (p.customer like ?) OR (p.customer_alias like ?) OR (p.param_class_type like ?) OR (p.division like ?) OR (p.performer_short like ?))" default=""/>
|
|
</m:filter_settings>
|
|
<cfset pageInfo.settings.filter=#filter#/>
|
|
<!--- Тут надо подумать, отображать только заполненные опции или шаблоны тоже --->
|
|
<cftry>
|
|
<cfquery name="qRead" datasource="#request.DS#">
|
|
select
|
|
<d:field_set titleMapOut="titleMap" lengthOut="fieldCount">
|
|
|
|
<d:field title="area_id" cfSqlType="CF_SQL_INTEGER">g.area_id</d:field>
|
|
<d:field title="area" cfSqlType="CF_SQL_VARCHAR">g.area</d:field>
|
|
<d:field title="area_code" cfSqlType="CF_SQL_VARCHAR">g.area_code</d:field>
|
|
<d:field title="analytic_code" cfSqlType="CF_SQL_VARCHAR">g.analytic_code</d:field>
|
|
|
|
<d:field title="abstract_service_id" cfSqlType="CF_SQL_INTEGER">a.abstract_service_id</d:field>
|
|
<d:field title="abstract_service" cfSqlType="CF_SQL_VARCHAR">a.abstract_service</d:field>
|
|
<d:field title="abstract_service_code" cfSqlType="CF_SQL_VARCHAR">a.code as abstract_service_code</d:field>
|
|
|
|
<d:field title="service_id" cfSqlType="CF_SQL_INTEGER">s.service_id</d:field>
|
|
<d:field title="modifier" cfSqlType="CF_SQL_VARCHAR">m.modifier</d:field>
|
|
<d:field title="modifier_code" cfSqlType="CF_SQL_VARCHAR">m.code as modifier_code</d:field>
|
|
|
|
<d:field title="abstract_service_param_class_id" cfSqlType="CF_SQL_INTEGER">ac.abstract_service_param_class_id</d:field>
|
|
<d:field title="param_class_id" cfSqlType="CF_SQL_VARCHAR">pc.param_class_id</d:field>
|
|
<d:field title="param_class" cfSqlType="CF_SQL_VARCHAR">pc.param_class</d:field>
|
|
<d:field title="is_multiple" cfSqlType="CF_SQL_VARCHAR">ac.is_multiple</d:field>
|
|
|
|
<d:field title="service_param_id" cfSqlType="CF_SQL_INTEGER">sp.service_param_id</d:field>
|
|
<d:field title="param_id" cfSqlType="CF_SQL_INTEGER">p.param_id</d:field>
|
|
<d:field title="param" cfSqlType="CF_SQL_VARCHAR">p.param</d:field>
|
|
<d:field title="param_short" cfSqlType="CF_SQL_VARCHAR">p.param_short</d:field>
|
|
<d:field title="param_code" cfSqlType="CF_SQL_VARCHAR">p.code as param_code</d:field>
|
|
|
|
|
|
</d:field_set>
|
|
from area g
|
|
left outer join abstract_service a on (g.area_id=a.area_id)
|
|
left outer join service s on (a.abstract_service_id=s.abstract_service_id)
|
|
left outer join modifier m on (s.modifier_id=m.modifier_id)
|
|
left outer join abstract_service_param_class ac on (a.abstract_service_id=ac.abstract_service_id)
|
|
left outer join param_class pc on (ac.param_class_id=pc.param_class_id)
|
|
left outer join service_param sp on (s.service_id=sp.service_id AND ac.abstract_service_param_class_id=sp.abstract_service_param_class_id)
|
|
left outer join param p on (sp.param_id=p.param_id)
|
|
where 1=1 <m:filter_build filter=#pageInfo.settings.filter#/>
|
|
order by g.analytic_code, a.code, m.code, s.service_id, ac.abstract_service_param_class_id, p.sort, p.code, p.param_id
|
|
</cfquery>
|
|
|
|
<!--- <cfdump var=#qRead#/> --->
|
|
|
|
|
|
<cfcatch type="database">
|
|
<cfrethrow/>
|
|
<m:ls_catch catch=#cfcatch# status=#pageInfo.status#/>
|
|
</cfcatch>
|
|
</cftry>
|
|
|
|
<cfquery name="qCountTotal" datasource="#request.DS#">
|
|
select count(*) as cnt from param where 1=1
|
|
</cfquery>
|
|
|
|
</m:silent><!---
|
|
-----------------------------------------------------------------------------------------
|
|
-----------------------------------------------------------------------------------------
|
|
-----------------------------------------------------------------------------------------
|
|
---><cfif isDefined("output_xls")>
|
|
<layout:xml qRead=#qRead# titleMap=#titleMap# filename="#pageInfo.entity#.xml"/>
|
|
<cfabort/>
|
|
</cfif><cfif isDefined("output_json")>
|
|
<layout:json qRead=#qRead# titleMap=#titleMap# filename="#pageInfo.entity#.json"/>
|
|
<cfabort/>
|
|
</cfif><!---
|
|
---><layout:page section="header" pageInfo=#pageInfo#>
|
|
|
|
<layout:attribute name="title">
|
|
<cfoutput><b>Дерево каталога</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>
|
|
|
|
<!--- <cfdump var=#qRead#/> --->
|
|
|
|
<div style="padding:1em;font-size:170%;">
|
|
<cfoutput query="qRead" group="area_id">
|
|
<div style="font-size:90%;border:1px solid ##bbb;margin:.5em;">
|
|
<a href="area.cfm?area_id=#area_id#&#tr.fwx#" style="display:block;width:100%;padding-left:.5em;line-height:1.6em;background:##ccc;">
|
|
#analytic_code# <b>#area#</b> (#area_code#)
|
|
</a>
|
|
<cfoutput group="abstract_service_id">
|
|
<cfif abstract_service_id GT 0>
|
|
<div style="padding-left:2em;font-size:90%;">
|
|
<a href="abstract_service.cfm?abstract_service_id=#abstract_service_id#&#tr.fwx#">
|
|
<img src="img/asvc.jpg" width="13" height="13"/>
|
|
#abstract_service# [#abstract_service_id#] (#area_code#.#abstract_service_code#)
|
|
</a>
|
|
<cfoutput group="service_id">
|
|
<cfif service_id GT 0>
|
|
<div style="padding-left:2em;font-size:90%;">
|
|
<a href="service.cfm?service_id=#service_id#&#tr.fwx#">
|
|
<img src="img/svc.jpg" width="16" height="16"/>
|
|
#abstract_service#:#modifier# [#service_id#](#area_code#.#abstract_service_code#.#modifier_code#)
|
|
</a>
|
|
<cfoutput group="abstract_service_param_class_id">
|
|
<cfif abstract_service_param_class_id GT 0>
|
|
<div style="padding-left:2em;font-size:90%;">
|
|
<img src="img/a-piece.png" width="13" height="13"/>
|
|
<a href="abstract_service_param_class.cfm?abstract_service_param_class_id=#abstract_service_param_class_id#&#tr.fwx#">#param_class# [#abstract_service_param_class_id#]</a>
|
|
<cfoutput group="service_param_id">
|
|
<cfif service_param_id GT 0>
|
|
<div style="padding-left:2em;font-size:90%;">
|
|
<img src="img/piece.png" width="13" height="13"/>
|
|
<a href="service_param.cfm?service_param_id=#service_param_id#&#tr.fwx#">#param# [#service_param_id#](#area_code#.#abstract_service_code#.#modifier_code#.#param_code#)</a>
|
|
</div>
|
|
</cfif>
|
|
</cfoutput>
|
|
</div>
|
|
</cfif>
|
|
</cfoutput>
|
|
</div>
|
|
</cfif>
|
|
</cfoutput>
|
|
</div>
|
|
</cfif>
|
|
</cfoutput>
|
|
</div>
|
|
</cfoutput>
|
|
</div>
|
|
|
|
|
|
</cfif>
|
|
<layout:page section="footer"/> |