106 lines
3.6 KiB
Plaintext
106 lines
3.6 KiB
Plaintext
<cfimport prefix="c" taglib="../lib/controls"/>
|
|
<cfimport prefix="d" taglib="../lib/data"/>
|
|
|
|
<!---<cfif StructKeyExists(form, "add_param_class")>
|
|
<cfdump var=#form#/>
|
|
</cfif>--->
|
|
|
|
<cfparam name="ATTRIBUTES.abstract_service_id"/>
|
|
<cfparam name="ATTRIBUTES.fwx"/>
|
|
<cfparam name="ATTRIBUTES.self"/>
|
|
<cfparam name="ATTRIBUTES.editable" type="boolean" default="No"/>
|
|
|
|
<d:bean readonly=#!ATTRIBUTES.editable# savemarker="add_param_class" table="abstract_service_param_class" datasource="#request.DS#" output="de" status="estatus" info="einfo" meta="emeta">
|
|
<d:param field="abstract_service_id" type="integer" key/>
|
|
<d:param field="param_class_id" type="integer" key/>
|
|
|
|
<d:param field="creator_id" type="integer" value="#request.usr_id#" skipUpdate/>
|
|
<d:param field="updater_id" type="integer" value="#request.usr_id#" />
|
|
<d:param field="dt_created" type="timestamp" value="#Now()#" skipUpdate/>
|
|
<d:param field="dt_updated" type="timestamp" value="#Now()#"/>
|
|
</d:bean>
|
|
|
|
<cfif structKeyExists(FORM, "detach_param_class") AND #ATTRIBUTES.editable#>
|
|
<cfparam name="FORM.param_class_id" type="integer"/>
|
|
<cfquery name="qDetachparam_class" datasource="#request.DS#">
|
|
delete from abstract_service_param_class
|
|
where abstract_service_id=<cfqueryparam cfsqltype="cf_sql_integer" value=#ATTRIBUTES.abstract_service_id#/>
|
|
AND param_class_id=<cfqueryparam cfsqltype="cf_sql_integer" value=#FORM.param_class_id#/>
|
|
</cfquery>
|
|
</cfif>
|
|
|
|
<cfquery name="qRead" datasource="#request.DS#">
|
|
select
|
|
x.abstract_service_id
|
|
,x.param_class_id
|
|
,p.param_class
|
|
from abstract_service_param_class x
|
|
join param_class p on (x.param_class_id=p.param_class_id)
|
|
where x.abstract_service_id=<cfqueryparam cfsqltype="cf_sql_integer" value="#ATTRIBUTES.abstract_service_id#"/>
|
|
order by 2
|
|
</cfquery>
|
|
|
|
<cfoutput>
|
|
<b>Классы компонентов (#qRead.recordCount#):</b>
|
|
</cfoutput>
|
|
|
|
<table class="worktable">
|
|
|
|
<cfoutput>
|
|
<thead>
|
|
<tr class="worktable_head">
|
|
<th>Компонент</th>
|
|
<th></th>
|
|
</tr>
|
|
</thead>
|
|
</cfoutput>
|
|
|
|
<cfoutput query="qRead">
|
|
<tr>
|
|
<td>#param_class#</td>
|
|
<td class="c">
|
|
<cfif #ATTRIBUTES.editable#>
|
|
<form action="#request.thisPage#" method="post">
|
|
<input type="hidden" name="abstract_service_id" value="#ATTRIBUTES.abstract_service_id#"/>
|
|
<input type="hidden" name="param_class_id" value="#param_class_id#"/>
|
|
<input type="hidden" name="track" value="#ATTRIBUTES.self#"/>
|
|
<button type="submit" name="detach_param_class" class="submitminus" title="убрать провайдера услуги"></button>
|
|
</form>
|
|
</cfif>
|
|
</td>
|
|
</tr>
|
|
</cfoutput>
|
|
|
|
<cfif ATTRIBUTES.editable>
|
|
<cfoutput>
|
|
<tr>
|
|
<td colspan="3" style="vertical-align:middle;">
|
|
<form action="#request.thisPage#" method="post">
|
|
<input type="hidden" name="track" value="#ATTRIBUTES.self#"/>
|
|
<input type="hidden" name="abstract_service_id" value="#ATTRIBUTES.abstract_service_id#"/>
|
|
<button type="submit" name="add_param_class" class="submitnew" value="" title="добавить прямо тут" style="vertical-align:middle"></button>
|
|
<cfquery name="qparam_class" datasource="#request.DS#">
|
|
select c.param_class_id, c.param_class
|
|
from param_class c
|
|
order by c.param_class
|
|
</cfquery>
|
|
|
|
<c:combo
|
|
query=#qparam_class#
|
|
combo="param_class_id"
|
|
key="param_class_id"
|
|
id="param_class_id"
|
|
displayf="##param_class##"
|
|
empty=""
|
|
style="vertical-align:middle"
|
|
<!--- flag_disabled="cnt"--->
|
|
/>
|
|
</form>
|
|
<i></i>
|
|
</td>
|
|
</tr>
|
|
|
|
</cfoutput>
|
|
</cfif>
|
|
</table>
|
|
<cfexit method="exittag"/> |