98 lines
4.3 KiB
Plaintext
98 lines
4.3 KiB
Plaintext
<cfsilent>
|
||
<cfimport prefix="m" taglib="lib"/>
|
||
<cfimport prefix="d" taglib="lib/data"/>
|
||
<cfimport prefix="layout" taglib="layout"/>
|
||
</cfsilent><m:silent silent="No">
|
||
|
||
<m:prepare_detail entity="service_param" pageInfoOut="pageInfo"/>
|
||
<cfparam name="service_param_id" type="integer"/>
|
||
|
||
<d:del
|
||
entity="#pageInfo.entity#"
|
||
confirmMessage="Удалить компонент услуги?"
|
||
denyMessage="Удаление данного компонента невозможно (существуют зависимые объекты)."
|
||
accessObj="#pageInfo.entity#"
|
||
status="status"
|
||
output="markup">
|
||
|
||
<d:dependency entity="service_param_price" title="Цены компонента">
|
||
<d:dependency_field key>service_param_price_id</d:dependency_field>
|
||
<d:dependency_field title="Код абстр. услуги">a.code</d:dependency_field>
|
||
<d:dependency_field title="Абстрактная услуга">a.abstract_service</d:dependency_field>
|
||
<d:dependency_field title="Класс характеристики">c.modifier_class</d:dependency_field>
|
||
<d:dependency_field title="Характеристика">m.modifier</d:dependency_field>
|
||
<d:dependency_field title="Компонент">pc.param_class</d:dependency_field>
|
||
<d:dependency_field title="Вариант компонента">p.param</d:dependency_field>
|
||
<d:dependency_field title="Модель цены">prm.pricing_model_short</d:dependency_field>
|
||
<d:dependency_from>
|
||
service_param_price spp
|
||
left outer join service_param sp on (spp.service_param_id=sp.service_param_id)
|
||
left outer join service s on (sp.service_id=s.service_id)
|
||
left outer join abstract_service a on (s.abstract_service_id=a.abstract_service_id)
|
||
left outer join area g on (a.area_id=g.area_id)
|
||
left outer join modifier m on (s.modifier_id=m.modifier_id)
|
||
left outer join modifier_class c on (m.modifier_class_id=c.modifier_class_id)
|
||
left outer join param p on (sp.param_id=p.param_id)
|
||
left outer join param_class pc on (p.param_class_id=pc.param_class_id)
|
||
left outer join pricing_model prm on (spp.pricing_model_id=prm.pricing_model_id)
|
||
</d:dependency_from>
|
||
<d:dependency_condition cfsqltype="cf_sql_integer" value='#service_param_id#'>spp.service_param_id</d:dependency_condition>
|
||
<d:dependency_order_by>1 desc</d:dependency_order_by>
|
||
</d:dependency>
|
||
|
||
<d:del_condition field="service_param_id" value="#service_param_id#" cfsqltype="cf_sql_integer"/>
|
||
</d:del>
|
||
|
||
<m:dispatch_detail
|
||
usePRG="Yes"
|
||
pageInfo=#pageInfo#
|
||
id="#service_param_id#"
|
||
status=#status#
|
||
trackOut="tr"
|
||
idAttributesOut="id"
|
||
/>
|
||
|
||
<!--- decoration --->
|
||
<cfquery name="qDecoration" datasource="#request.DS#">
|
||
select
|
||
sp.service_param_id
|
||
,p.code as param_code, p.param
|
||
,a.code, a.abstract_service
|
||
,g.area_code
|
||
,m.code as modifier_code, m.modifier
|
||
,mc.modifier_class
|
||
from service_param sp
|
||
left outer join param p on (sp.param_id=p.param_id)
|
||
left outer join param_class c on (p.param_class_id=c.param_class_id)
|
||
left outer join service s on (sp.service_id=s.service_id)
|
||
left outer join modifier m on (s.modifier_id=m.modifier_id)
|
||
left outer join modifier_class mc on (m.modifier_class_id=mc.modifier_class_id)<!--- а можно взять через a, но так правильнее --->
|
||
left outer join abstract_service a on (s.abstract_service_id=a.abstract_service_id)
|
||
left outer join area g on (a.area_id=g.area_id)
|
||
where sp.service_param_id=<cfqueryparam cfsqltype="cf_sql_integer" value="#service_param_id#" null=#!isValid("integer", service_param_id)#/>
|
||
</cfquery>
|
||
|
||
|
||
</m:silent><!--- ----------------------------------------------------------------------------
|
||
---------------------------------------------------------------------------------------------
|
||
---------------------------------------------------------------------------------------------
|
||
---><layout:page section="header" pageInfo=#pageInfo#>
|
||
<layout:attribute name="title">
|
||
Удаление компонента услуги
|
||
<cfoutput query="qDecoration">
|
||
#abstract_service# #modifier#
|
||
#param#
|
||
#request.skuCode(area_code,code,modifier_code,param_code)#
|
||
<cfif service_param_id GT 0>
|
||
[#service_param_id#]
|
||
</cfif>
|
||
</cfoutput>
|
||
</layout:attribute>
|
||
<layout:attribute name="controls"> </layout:attribute>
|
||
</layout:page>
|
||
|
||
<!---<cfdump var=#qDecoration#/>--->
|
||
|
||
<cfoutput>#markup#</cfoutput>
|
||
|
||
<layout:page section="footer"/> |