Ajax CFC Call

by lokointhehouse2

HTML

<!--- AJAX PAGE --->
<cfparam name="form.trendtype" type="any" default="">
<cfparam name="form.trendid" type="any" default="">

<cfset siteObj= CreateObject("component", "data")/>

<cfset variables.EvalTrends = siteObj.EvalTrends(trendtype:#form.trendtype#, trendid:#form.trendid#)>
<cfset getEvalTrendsSum = siteObj.EvalTrendsSum(trendtype:#form.trendtype#, trendid:#form.trendid#)>

				<cfoutput query="getEvalTrendsSum">
					<tr>
						<th>Trend Category</th>
						<th>Trend Detail</th>
						<td>#allsites#</td>
						<td>#dub#</td>
						<td>#ind#</td>
						<td>#mem#</td>
						<td>#nca#</td>
						<td>#nsh#</td>
						<td>#orl#</td>
						<td>#war#</td>
						<td>#whi#</td>
					</tr>
				</cfoutput>

				<cfoutput query="variables.EvalTrends">
					<tr>
						<td>#trendcategory#</td>
						<td>#trenddetail#</td>
						<td>#allsites#</td>
						<td>#dub#</td>
						<td>#ind#</td>
						<td>#mem#</td>
						<td>#nca#</td>
						<td>#nsh#</td>
						<td>#orl#</td>
						<td>#war#</td>
						<td>#whi#</td>
					</tr>
				</cfoutput>

CSS

<tbody class="trendresult">
					<span>
							<tr>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
								<th></th>
							</tr>

JavaScript

$('#Trends').on('click', function(){

			var trendid = $("#trendid_data").val();

			$.post('ajax_report_enterpriseTrends.cfm?', {trendid:trendid,trendtype:'ytd'}, function(result,status){
				if (result != '') {
					$('.trendresult').html('');
					$('.trendresult').append(result);
				} else {
					alert('fail');
				}

				$(".reports").loading('stop');

			});


        	$('#trendModal').modal('show');

        });


		$('#reporttypeidSelected').on('change', function(){

			// refresh slect options
			$('#supervisorSelected').selectpicker('val', 'All Supervisor')
			$('#sitesSelected').selectpicker('val', 'All Sites')
			$('#roleSelected').selectpicker('val', 'All Role')
			$('#therapiesSelected').selectpicker('val', 'All Therapies')
			$('#leadersSelected').selectpicker('val', 'All Leaders')

			$('.selectpicker').selectpicker('refresh');

			//clear searches for new report search
			$("input[name='supervisor_data']").val('');
			$("input[name='role_data']").val('');
			$("input[name='sites_data']").val('');
			$("input[name='therapies_data']").val('');
			$("input[name='leaders_data']").val('');


		});