68 lines
2.6 KiB
Plaintext
68 lines
2.6 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="specification" pageInfoOut="pageInfo"/>
|
|
<cfparam name="specification_id" type="integer"/>
|
|
|
|
<d:del
|
|
entity="#pageInfo.entity#"
|
|
confirmMessage="Удалить спецификацию?"
|
|
denyMessage="Удаление данной спецификации невозможно (есть экземпляры услуг)."
|
|
accessObj="#pageInfo.entity#"
|
|
status="status"
|
|
output="markup">
|
|
|
|
<d:dependency entity="specification_item" title="Экземпляры услуг (строки спецификаций)">
|
|
<d:dependency_field key>si.specification_item_id</d:dependency_field>
|
|
<d:dependency_field title="Спецификация">n.specification</d:dependency_field>
|
|
<d:dependency_field title="Услуга (имя для печати)">si.specification_item</d:dependency_field>
|
|
<d:dependency_field title="Количество">si.quantity</d:dependency_field>
|
|
<d:dependency_from>
|
|
specification_item si
|
|
left outer join specification n on (si.specification_id=n.specification_id)
|
|
</d:dependency_from>
|
|
<d:dependency_condition cfsqltype="cf_sql_integer" value='#specification_id#'>si.specification_id</d:dependency_condition>
|
|
<d:dependency_order_by>2,3 </d:dependency_order_by>
|
|
</d:dependency>
|
|
|
|
<d:del_condition field="specification_id" value="#specification_id#" cfsqltype="cf_sql_integer"/>
|
|
</d:del>
|
|
|
|
<m:dispatch_detail
|
|
usePRG="Yes"
|
|
pageInfo=#pageInfo#
|
|
id="#specification_id#"
|
|
status=#status#
|
|
trackOut="tr"
|
|
idAttributesOut="id"
|
|
/>
|
|
|
|
<!--- decoration --->
|
|
<cfquery name="qDecoration" datasource="#request.DS#">
|
|
select
|
|
n.specification
|
|
from specification n
|
|
where n.specification_id=<cfqueryparam cfsqltype="cf_sql_integer" value="#specification_id#" null=#!isValid("integer", specification_id)#/>
|
|
</cfquery>
|
|
|
|
|
|
</m:silent><!--- ----------------------------------------------------------------------------
|
|
---------------------------------------------------------------------------------------------
|
|
---------------------------------------------------------------------------------------------
|
|
---><layout:page section="header" pageInfo=#pageInfo#>
|
|
<layout:attribute name="title">
|
|
<cfoutput>
|
|
Удаление спецификации
|
|
#qDecoration.specification#
|
|
[#specification_id#]
|
|
</cfoutput>
|
|
</layout:attribute>
|
|
<layout:attribute name="controls"> </layout:attribute>
|
|
</layout:page>
|
|
|
|
<cfoutput>#markup#</cfoutput>
|
|
|
|
<layout:page section="footer"/> |