campaignTabSql.blade.php
7.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?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(",", 'id,created,modified,currentstatus,legalstatus,firstname,lastname,mobile,emailid,client,status,clientinternalid,clientcode,priority,dialer_status,dialer_substatus,dialer_callback,dialer_remarks,dialer_flag,dialer_lastcall,crmlist_id,group,dbc_activation,digital_initiative,original_created_file,original_uploaded_date,partial_uploaded_date,dialer_last_user_id,dialer_lastcall_did,dialer_lastcall_number,bttc,service_vs_product,resolution,satisfaction,final_call_assessment,old_status,old_dialer_status,old_dialer_substatus,question,trigger_details,mf_isa,DOB,other_information,filter_condition,agreementid,applied_amount,city,comp_code,company,completeddate,cust_id,cust_name,customer_name,disb_date,emi_hl,eqty_amt,foir,ins_amt,int_rate,irr,loan_amount,location,mf_amt,nth,offer_amt,outstanding,pf,ph_mob,ph_off,ph_res,pl_offer,proc_fee,product_flag,profile_new,rank,segment,tenure,tu_application_id,ucic_id,filler1,filler2,filler3,filler4,filler5,filler6,filler7,filler8,filler9,filler10,filler11,filler12,filler13,filler14,filler15');
?>
<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 hidden />
<!--<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="Add Filter Condition Here"/>
</div>
<div >
<div>
<button type="submit" class="btn btn-success pull-left" id='savequery' onclick="saveSqlQuery();return false;">Save</button>
</div>
<div >
<button type="submit" class="btn btn-success pull-right" onclick="runSqlQuery();return false;"><i class="glyphicon glyphicon-ok"></i> Run </button>
</div>
</div>
</div>
</div>
<div class="panel panel-info">
<div class="panel-body" id="sqlQueryOutput">
<p><i class="fa fa-exclamation-circle"></i> Press Run button to see output!</p>
</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-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 data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&allvalues='+$("#allvalues").val()+'&queryConditions='+$("#queryConditions").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val();
doAjax("campaign/runquery",data,"sqlQueryOutput","","","GET");
}
function saveSqlQuery(){
//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;
if (window.confirm('Are sure you want to save filter condition?'))
{
var data = 'campaign={{ is_array($campaignDetails)?$campaignDetails["mkey"]:$campaignDetails->mkey }}&allvalues='+$("#allvalues").val()+'&queryConditions='+$("#queryConditions").val()+'&queryLimit='+$("#queryLimit").val()+'&queryOffset='+$("#queryOffset").val();
doAjax("campaign/savequery",data,"sqlQueryOutput","","","GET");
document.getElementById("downloadButton").style = "margin: 0% 0% 0.1% 84%;display: block";
}else{
return false;
}
}
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>