91 lines
3.7 KiB
Plaintext
91 lines
3.7 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_item" pageInfoOut="pageInfo"/>
|
|
<cfparam name="specification_item_uid" type="guid"/>
|
|
|
|
<d:del
|
|
entity="#pageInfo.entity#"
|
|
confirmMessage="Удалить строку спецификации (экземпляр услуги)?"
|
|
denyMessage="Удаление данной строки невозможно (заданы версии)."
|
|
accessObj=""
|
|
status="status"
|
|
output="markup">
|
|
|
|
<d:dependency entity="specification_item_version" title="Версии строки спецификации">
|
|
<d:dependency_field key>siv.specification_item_uid</d:dependency_field>
|
|
<d:dependency_field key>siv.agreement_version</d:dependency_field>
|
|
|
|
<d:dependency_field title="Договор">d.contract</d:dependency_field>
|
|
<d:dependency_field title="Дата договора">d.dt_contract</d:dependency_field>
|
|
<d:dependency_field title="Соглашение">a.agreement</d:dependency_field>
|
|
<d:dependency_field title="Дата соглашеия">a.dt_agreement</d:dependency_field>
|
|
<d:dependency_field title="Версия">siv.agreement_version</d:dependency_field>
|
|
<d:dependency_field title="Количество">siv.quantity</d:dependency_field>
|
|
<d:dependency_field title="Цена">siv.price</d:dependency_field>
|
|
<d:dependency_field title="Имя для печати">siv.specification_item_version</d:dependency_field>
|
|
<d:dependency_from>
|
|
specification_item_version siv
|
|
left outer join specification_item si on (siv.specification_item_uid=si.specification_item_uid)
|
|
left outer join specification s on (si.specification_id=s.specification_id)
|
|
left outer join contract d on (s.contract_id=d.contract_id)
|
|
left outer join contragent k on (d.contragent_id=k.contragent_id)
|
|
left outer join agreement a on (siv.agreement_version=a.agreement_version AND s.contract_id=a.contract_id)
|
|
</d:dependency_from>
|
|
<d:dependency_condition cfsqltype="cf_sql_other" value='#specification_item_uid#'>
|
|
siv.specification_item_uid
|
|
</d:dependency_condition>
|
|
<d:dependency_order_by>
|
|
siv.agreement_version
|
|
</d:dependency_order_by>
|
|
</d:dependency>
|
|
<d:del_condition field="specification_item_uid" value="#specification_item_uid#" cfsqltype="cf_sql_other"/>
|
|
</d:del>
|
|
|
|
<!--- ---><m:dispatch_detail
|
|
usePRG="Yes"
|
|
pageInfo=#pageInfo#
|
|
id="#specification_item_uid#"
|
|
status=#status#
|
|
trackOut="tr"
|
|
idAttributesOut="id"
|
|
/>
|
|
|
|
|
|
<!--- decoration --->
|
|
<cfquery name="qDecoration" datasource="#request.DS#">
|
|
select
|
|
si.specification_item_uid
|
|
,s.specification
|
|
,svc.svc
|
|
from specification_item si
|
|
left outer join specification s on (si.specification_id=s.specification_id)
|
|
left outer join svc on (si.svc_id=svc.svc_id)
|
|
where si.specification_item_uid=<cfqueryparam cfsqltype="cf_sql_other" value="#specification_item_uid#" null=#!isValid("guid", specification_item_uid)#/>
|
|
</cfquery>
|
|
|
|
|
|
</m:silent><!--- ----------------------------------------------------------------------------
|
|
---------------------------------------------------------------------------------------------
|
|
---------------------------------------------------------------------------------------------
|
|
---><layout:page section="header" pageInfo=#pageInfo#>
|
|
<layout:attribute name="title">
|
|
<cfoutput>
|
|
Удаление строки спецификации
|
|
<b>#qDecoration.specification#</b>
|
|
#qDecoration.svc#
|
|
[#specification_item_uid#]
|
|
|
|
</cfoutput>
|
|
</layout:attribute>
|
|
<layout:attribute name="controls"> </layout:attribute>
|
|
</layout:page>
|
|
|
|
<!---<cfdump var=#qDecoration#/>--->
|
|
|
|
<cfoutput>#markup#</cfoutput>
|
|
|
|
<layout:page section="footer"/> |