<?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,elegible');
?>
<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>
					<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;">ELEGIBLE FOR</label>
					<select id="queryInCondition" multiple="" data-rel="chosen" style='width:100%' class=select2multi>
						<option value="'CC'">CC</option>
						<option value="'PL'">PL</option>
						<option value="'OD'">OD</option>
					</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 class="form-group" style="display: block;">
						<label>LIMIT</label>
						<input type="text" class="form-control" id="queryLimit" placeholder="30" value="30" style="width:50px;" />
						<label>OFFSET</label>
						<input type="text" class="form-control" id="queryOffset" placeholder="0" value="0" style="width:50px;" />
						<label>;</label>
						<span style="margin: 1% 0 0 38%">Select Checkbox To Save Current Query</span><input type="checkbox" class="saveQryChck" style="margin: 1% 0 0 2%">
						<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">
          <a data-toggle="collapse" href="#collapse1">Show Previous Queries</a>
        </h4>
      </div>
      <div id="collapse1" class="panel-collapse collapse">
        <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> <i class="glyphicon glyphicon-trash pull-right" onclick="delSqlQuery({{$queryLog->id}});return false;"></i></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 = $('.saveQryChck:checked').val();
	var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&querySelect='+$("#querySelect").val()+'&queryConditions='+$("#queryConditions").val()+'&queryInCondition='+$("#queryInCondition").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val()+'&checkedValue='+checkedValue;
	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 downloadOutput()
{
	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>