<?php
//$queryFields = explode(",", 'usr_id,branchCode,organizationName,designation,dob,location,state,residenceAddress,residenceAddressZipCode,officeAddress,officeAddressZipCode,alternateMobile,officeNumber,referenceName,referenceMobile,referenceName2,referenceMobile2,loanStatus,product,bucket,dpd,tenureStartDate,tenureEndDate,tenureRemaining,disbursalDate,rateOfInterest,installmentNo,chequeBounceNo,reasonForLastBounce,reasonForSecondLastBounce,cycleDate,ebnb,bank,lastMonthPaymentMode,lastMonthPaymentAmount,lastMonthPaymentDate,delinquencyString,specialCode,centralECS,emi,pos,bounceCharge,penalMTD,penalLTD,overdueAmount,installmentAmountOverdue,altphone1,altphone2,altphone3,altphone4,altphone5,altphone6,altphone7,altphone8,altphone9,altphone10,priority,dialer_substatus,dialer_callback');
$queryFields = explode(",", 'usr_id,branchCode,organizationName,designation,dob,location,state,residenceAddress,residenceAddressZipCode,officeAddress,officeAddressZipCode,alternateMobile,officeNumber,referenceName,referenceMobile,referenceName2,referenceMobile2,loanStatus,product,bucket,dpd,tenureStartDate,tenureEndDate,tenureRemaining,disbursalDate,rateOfInterest,installmentNo,chequeBounceNo,reasonForLastBounce,reasonForSecondLastBounce,cycleDate,ebnb,bank,lastMonthPaymentMode,lastMonthPaymentAmount,lastMonthPaymentDate,delinquencyString,specialCode,centralECS,emi,pos,bounceCharge,penalMTD,penalLTD,overdueAmount,installmentAmountOverdue,altphone1,altphone2,altphone3,altphone4,altphone5,altphone6,altphone7,altphone8,altphone9,altphone10,priority,dialer_substatus,dialer_callback');
?>
<div class="row">
	<div class="col-sm-12">
		<div class="panel panel-info">
			<div class="panel-heading"><strong>Query</strong></div>
			<div class="panel-body">
				<div class="form-group" style="margin-bottom: 8px;">
					<label>SELECT</label>
					<input type='text' value='*' id='allvalues'disabled/>
					<!--<select id="querySelect" multiple="" data-rel="chosen" style='width:100%' class=select2multi>
						<option value="currentstatus" selected="selected">currentstatus</option>
						<option value="legalstatus" selected="selected">legalstatus</option>
						<option value="mobile" selected="selected">mobile</option>
						<option value="status" selected="selected">status</option>
						<option value="dialer_status" selected="selected">dialer_status</option>
						<option value="dialer_substatus" selected="selected">dialer_substatus</option>
						@foreach($queryFields as $fields)
							<option value="{{$fields}}">{{$fields}}</option>
						@endforeach
					</select>-->
					<label style="margin-top: 5px;">FROM 'records' WHERE</label>
					<input type="text" class="form-control" id="queryConditions" placeholder="1" value="1"/>
				</div>
				<div class="form-inline">
					<div>
						<button type="submit" class="btn btn-success pull-right" id='savequery' onclick="runSqlQuery();return false;">Save</button>
					<!---	<button type="submit" class="btn btn-success pull-right" onclick="runSqlQuery();return false;"><i class="glyphicon glyphicon-ok"></i> Run Query</button>--->
					</div>
				</div>
			</div>
		</div>

		<div class="panel-group">
    <div class="panel panel-default">
      <div class="panel-heading">
        <h4 class="panel-title">
          Show Filters
        </h4>
      </div>
      <div id="collapse1" >
        <ul class="list-group">
        @foreach($queryLogs as $queryLog)
          <li class="list-group-item"><a onclick="runFSqlQuery({{$queryLog->id}});return false;" style="cursor:pointer">{{$queryLog->query}} </a></li>
        @endforeach
        </ul>
        <div class="panel-footer">*Please Refresh Current Campaign To See Updated Saved Queries</div>
      </div>
    </div>
  </div>
  <br><br>

		<div class="panel panel-info">
			<div class="panel-heading" id="appendButton"><strong>Output</strong><button type="submit" class="btn btn-default btn-sm" onclick="downloadOutput();return false;" style="margin: 0 0 0.1% 84%;display: none" id="downloadButton"><i class="glyphicon glyphicon-download"></i> Download</button></div>
			<div class="panel-body" id="sqlQueryOutput">
				<p><i class="fa fa-exclamation-circle"></i> Press Run Query button to see output!</p>
			</div>
		</div>
	</div>
</div>

<script>
function runSqlQuery(){
	//var checkedValue = $('#savequery').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;
	var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&allvalues='+$("#allvalues").val()+'&queryConditions='+$("#queryConditions").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val();
	doAjax("campaign/query",data,"sqlQueryOutput","","","GET");

	document.getElementById("downloadButton").style = "margin: 0% 0% 0.1% 84%;display: block";
}

function runFSqlQuery(id){
	var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&id='+id+'&querySelect='+$("#querySelect").val();
	doAjax("campaign/fquery",data,"sqlQueryOutput","","","GET");

	document.getElementById("downloadButton").style = "margin: 0% 0% 0.1% 84%;display: block";
}

function delSqlQuery(id){
	var data = 'id='+id;
	var value = '{{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}';
	doAjax("campaign/delete",data,"sqlQueryOutput","","","GET");

	doAjax("campaign/show","campaign="+value,"campaignDetailsArea","","","GET",function(response){
			$("#campaignRefresh").html('<div class="form-group"><button onclick="campaignDetailsShow($(\'#selectCampaignField option:selected\').val());return false;" class="btn btn-xs btn-info">Refresh Campaign</button></div>');
		});
}
function enablelogic(id){
	console.log(id);
	var data='id='+id;
	var value = '{{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}';
        //doAjax("campaign/enable",data,"sqlQueryOutput","","","GET");
	
	doAjax("campaign/show","campaign="+value,"campaignDetailsArea","","","GET",function(response){
                        $("#campaignRefresh").html('<div class="form-group"><button onclick="campaignDetailsShow($(\'#selectCampaignField option:selected\').val());return false;" class="btn btn-xs btn-info">Refresh Campaign</button></div>');
                });
}

function downloadOutput()
{
	//window.open('campaign/download?campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&querySelect='+$("#querySelect").val()+'&queryConditions='+$("#queryConditions").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val());return false;
	window.open('campaign/download?campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&querySelect='+$("#querySelect").val()+'&queryConditions='+$("#queryConditions").val()+'&queryInCondition='+$("#queryInCondition").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val());return false;
}
</script>