ı want to make ;
1-make a paging at form
2-Show the EVENT_TO_POS the personel name not show integer number.(at sgl its nvachar but at employees id is integer)
and search with dropdown list and show the data for departman.(for example at technical departmans notes)
thats the code ;
<cfparam name="attributes.keyword" default="">
<cfparam name="attributes.start_date" default="">
<cfparam name="attributes.finish_date" default="">
<cfparam name="attributes.form_varmi" default="">
<cfif len(attributes.start_date)>
<cf_date tarih="attributes.start_date">
</cfif>
<cfif len(attributes.finish_date)>
<cf_date tarih="attributes.finish_date">
</cfif>
<cfquery name="deneme" datasource="workcube_teknotel" >
SELECT
ER.EVENT_RESULT,
E.STARTDATE,
E.FINISHDATE,
E.EVENT_HEAD,
E.EVENT_TO_POS
FROM
workcube_teknotel.EVENT E
INNER JOIN workcube_teknotel.workcube_teknotel.EVENT_CAT EC ON EC.EVENTCAT_ID = E.EVENTCAT_ID
INNER JOIN workcube_teknotel.workcube_teknotel.EVENT_RESULT AS ER ON ER.EVENT_ID=E.EVENT_ID
where EC.EVENTCAT_ID='1'
<cfif len(attributes.keyword)>
AND EVENT_HEAD LIKE '%#attributes.keyword#%'
</cfif>
<cfif len(attributes.start_date)>
AND STARTDATE >= <cfqueryparam cfsqltype="cf_sql_timestamp" value="#attributes.start_date#">
</cfif>
<cfif len(attributes.finish_date)>
AND FINISHDATE <= <cfqueryparam cfsqltype="cf_sql_timestamp" value="#attributes.finish_date#">
</cfif>
ORDER BY STARTDATE ASC
</cfquery>
<cfform method="post">
<input name="form_varmi" id="form_varmi" value="1" type="hidden">
<cf_big_list_search_area>
<cfoutput>
<div class="row">
<div class="col col-12 form-inline ">
<div class="form-group x-10">
<input type="text" name="keyword" id="keyword" placeholder="KONU" value="#attributes.keyword#" maxlength="50">
</div>
<div class="form-group">
<div class="input-group x-11">
<cfsavecontent variable="message"><cf_get_lang_main no='65.hatalı veri'>:<cf_get_lang_main no='330.Tarih'>!</cfsavecontent>
<cfinput type="text" name="start_date" value="#dateformat(attributes.start_date,'dd/mm/yyyy')#" validate="#validate_style#" maxlength="50" message="#alert#">
<span class="input-group-addon"><cf_wrk_date_image date_field="start_date"></span>
</div>
<div class="input-group x-11">
<cfsavecontent variable="message"><cf_get_lang_main no='65.hatalı veri'>:<cf_get_lang_main no='330.Tarih'>!</cfsavecontent>
<cfinput type="text" name="finish_date" value="#dateformat(attributes.finish_date,'dd/mm/yyyy')#" validate="#validate_style#" maxlength="50" message="#alert#">
<span class="input-group-addon"><cf_wrk_date_image date_field="finish_date"></span>
</div>
</div>
</div>
</div>
</cfoutput>
</cf_big_list_search_area>
<cf_wrk_search_button>
</cfform>
<cf_big_list>
<tr>
<TH>BAŞLAMA TARIHI</TH>
<th>BİTİŞ TARIHI</th>
<th>KONU</TH>
<TH>KATILIMCILAR</TH>
<th>NOTLAR</th>
</tr>
<cfif attributes.form_varmi eq 1>
<cfoutput query="deneme">
<tr>
<td colspan="1">#STARTDATE#</td>
<td colspan="1">#FINISHDATE#</td>
<td colspan="1">#EVENT_HEAD#</td>
<td colspan="1">#EVENT_TO_POS#</td>
<td colspan="1">#EVENT_RESULT#</td>
</li>
</tr>
</cfoutput>
</cfif>
</cf_big_list>
1
Reply
AdChoices