campaignTabSqlCond.blade.php 2.49 KB
<div class="row">
	<div class="col-sm-12">
		<div class="panel panel-info">
			<div class="panel-heading"><strong>Query List</strong></div>
			<div class="panel-body" id="">
			<ul class="list-group">
						<li class="list-group-item"><input type="radio" name="query" id="currQuery" value="" checked>Default</li>
						@foreach($queryLogs as $queryLog)
						<li class="list-group-item"><input type="radio" name="query" id="currQuery" value="{{$queryLog->id}}" {{$queryLog->current_queue?"checked":""}}>{{$queryLog->query}}
						<div><button class="btn btn-success pull-right" style="    margin-top: -26px;" onclick="queryCount({{$queryLog->id}});return false;" type="submit" ">Run</button></div>
						<span id="sqlQueryOutput-{{$queryLog->id}}" class="countText"></span></li>
						@endforeach
					</ul>

			<div class="form-inline">
				<div class="form-group" style="display: block;">
					<button type="submit" class="btn btn-success pull-right" onclick="addInQueue1();"><!-- <i class="glyphicon glyphicon"></i>  --> Apply Filter</button>
				</div>
				<!--<div id="success" style="align:right color:green"></div>--->
			</div>
			</div>
		</div>
	</div>
</div>

<script>
	function addInQueue1(){
		var selectCampaignField = $('#selectCampaignField').val();
		var data = 'radioValue='+$("input[name='query']:checked").val();
			data+='&campaign='+selectCampaignField;
		 //var checkedValue = $('.saveQryChck:checked').val();
		// var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&querySelect='+$("#querySelect").val()+'&queryConditions='+$("#queryConditions").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val()+'&checkedValue='+checkedValue;
		 doAjax("campaign/addCurrQueue",data,"","","","GET",function(retrstr){
		 	simpleNotification('Success','topRight',"Filter assign suceesfully!"); 
		 	//$("#success").html("Filter assign suceesfully!");
		 });
	}
	function queryCount(id){
		/*var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&id='+id;
	doAjax("campaign/runcount",data,"querycountoutput-"+id,"","","GET");*/
	$("#sqlQueryOutput-"+id).html('');
	var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&id='+id+'&querySelect='+$("#querySelect").val();
	doAjax("campaign/fquery",data,"sqlQueryOutput-"+id,"","","GET");

	}
</script>
<style type="text/css">
	.countText {
		float: right;
    	margin-top: -15px;
    	margin-right: 10px;
	}
</style>