Virtualdata.blade.php
3.18 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
<?php
use App\Models\CRMCall;
use App\Models\User;
use App\Jobs\KHRMSLib;
$attempts = CRMCall::where('userstatus','!=','InboundDROP')->where('created_at','>',date('Y-m-d',time()))->where('user_id','=',Auth::user()->id)->count();
print_r(($attempts));
$Contacts = CRMCall::where('userstatus','NOT IN',"('NORECORD','InboundDROP')")->where('created_at','>',date('Y-m-d',time()))->where('user_id','=',Auth::user()->id)->count();
$uniqueContacts = DB::select("select count(distinct(number)) as uniquecount from crmcalls where userstatus NOT IN ('InboundDROP','NORECORD') and user_id=".Auth::user()->id." group by number");
/**
Output Products
**/
//$Product = DB::table('output_products')->select('id','name','status')->where('status', '1')->get();
//print_r($Product);
//print_r($uniqueContacts);
//include(resource_path().'/views/layout/module/virtualchannel/VirtualFieldsArray.php');
//print_r($Product);
//echo "<div>Virtual</div>";
?>
<div class="container">
<div style="text-align:center">
<h2>Virtual Channels</h2>
<p></p>
</div>
<div class="row">
<div class="column">
<form class="form-horizontal">
<div class="table-responsive" style="background: #fff;">
<table class="table">
<thead>
<tr>
<th>No.of Attempts</th>
<th><?php echo $attempts; ?></th>
</tr>
<tr>
<th>No.of Contacts</th>
<th><?php echo $Contacts; ?></th>
</tr>
<tr>
<th>Unique Contacts</th>
<th><?php foreach($uniqueContacts as $uniquecounts){echo $uniquecounts->uniquecount; } ?></th>
</tr>
<tr>
<th>Income Achievement</th>
<th></th>
</tr>
<tr>
<th>Product</th>
<th>LG</th>
<th>Expected Amount(If Applicable)</th>
<th>LC</th>
<th>Amount(If Applicable)</th>
</tr>
</thead>
<tbody>
<?php
//include(resource_path().'/views/layout/module/virtualchannel/VirtualFieldsArray.php');
foreach ($products as $key => $value) {
//print_r($value);
//print_r($ProductType);
$i=1;
?>
<tr>
<td><?php echo $value->name; ?></td>
<td><input type="number" name="lg[<?php echo $value->name; ?>]"></td>
<td><input type="text" name="lg-amt[<?php echo $value->name; ?>]"></td>
<td><input type="number" name="lc[<?php echo $value->name; ?>]"></td>
<td><input type="text" name="lc-amt[<?php echo $value->name; ?>]"></td>
</tr>
<?php
} ?>
<tr>
<td><button type="submit" class="btn btn-primary" onclick='createOutputReport();return false;'>Save</button></td></tr>
</tbody>
</table>
</div>
</form>
<script>
function createOutputReport()
{
var putdata="csrftoken={!!Session::token()!!}";
putdata+="&lc="+$("#lc").val();
doAjax('user',putdata,'__fake__div__','ajax_users_create','singlethis','POST',function(retstr)
{
if(retstr.responseText.indexOf('Error')<0)
{
simpleNotification("success","topRight","User Created Successfully");
doAjax('user/'+retstr.responseText+'/edit','','userformdiv','ajax_users_create','singlethis','GET');
}
else
{
simpleNotification("error","topRight",retstr.responseText);
}
});
}
</script>
</div>
</div>
</div>