Repository navigation
Expand file tree
/
Copy pathnot-cosed-checks-all-client-wise.php
More file actions
117 lines (87 loc) · 5.97 KB
/
Copy pathnot-cosed-checks-all-client-wise.php
File metadata and controls
117 lines (87 loc) · 5.97 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
<?php include ('include/config.php');
//$_REQUEST['date']="2015-09-16";
$_REQUEST['date']=date("Y-m-d");
$localDate = date("D, M d, Y");
//date("D, M d, Y h:i:s");
//$localDate = "Wed, Sep 16, 2015";
if($_GET['send']==1){
$table = '<table border="1" style="border-collapse: collapse; border:1px solid #cccccc; border-color: #cccccc;">';
$table .= '
<tr>
<td align="center" width="100%" colspan="10" style="border:none;"> </td>
</tr>
<tr>
<td align="center" width="100%" colspan="10" style="border:none;">Following are the Opened,Problem,Insufficient and Not Assign checks list which are not closed yet.<br /><strong>'.$localDate.'</strong> </td>
</tr>
<tr>
<td align="center" width="100%" colspan="10" style="border:none;"> </td>
</tr>
<tr>
<th width="5%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">#</th>
<th width="5%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Client</th>
<th width="20%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Analyst Name</th>
<th width="10%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Checks Title</th>
<th width="5%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Add Date</th>
<th width="15%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Progress Date</th>
<th width="25%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Total Days</th>
<th width="25%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Check Status</th>
<th width="25%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Progress Status</th>
</tr>';
$cols = "vd.v_id,vc.as_id,as_vstatus,as_status,checks_title,co.name AS 'client_name', CONCAT(first_name,' ',last_name) AS 'analyst_name', DATE(as_addate) as 'add_date', DATE(as_pdate) as 'progress_date'
,level_id,vd.com_id";
$tbls = "ver_data vd
INNER JOIN ver_checks vc ON vd.v_id=vc.v_id
INNER JOIN checks c ON c.checks_id=vc.checks_id
INNER JOIN company co ON vd.com_id=co.id
INNER JOIN users u ON u.user_id=vc.user_id" ;
$WHERE = "(as_status='Open' OR as_status='Problem' OR as_status='Not Assign' OR as_status='Insufficient')
and as_isdlt=0
and v_isdlt=0
and vd.com_id NOT IN (20,81,82,92,96,109,111)
and (YEAR(as_addate)='".date('Y')."' OR YEAR(as_addate)='2015')
and level_id IN (2,3,6)
and u.user_id NOT IN (210,211,212,201,3,23,50)
ORDER BY as_addate DESC ";
echo "SELECT $cols FROM $tbls WHERE $WHERE";
$see=0;
$analyst= $db->select($tbls,$cols,$WHERE);
if(mysql_num_rows($analyst)>0){
while($analyst_arr = mysql_fetch_array($analyst)){
$today = date("Y-m-j H:i:s");
$days = getDaysFromDates($today,$analyst_arr['add_date'],$analyst_arr['com_id']);
$levelid = $analyst_arr['level_id'];
if($levelid==2) $Title = "(Manager)"; else if($levelid==6) $Title = "(Finance)"; else if($levelid==12) $Title = ""; else $Title = "";
if($days>20){
$see++;
$table .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:12px; padding:5px;">'.$analyst_arr['analyst_name'].' '.$Title.'</td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$analyst_arr['checks_title'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$analyst_arr['add_date'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$analyst_arr['progress_date'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$days.'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$analyst_arr['as_status'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81#check_tab_'.$analyst_arr[as_id].'" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
//$db->update("delayed_reported=1","ver_checks","as_id=".$analyst_arr['as_id']);
}
}}
$table .= "</table>";
$subject="Opened Checks Details (".$localDate.")";
$to_email="khalique@xcluesiv.com";
$fEmial="Verification Team";
//$cMail="hzafar2010@gmail.com";
echo $table;
if($see!=0){
//emailTmp($table,$subject,$to_email,'','','','',"Khalique");
//emailTmp($table,$subject,'ceo@backcheckgroup.com','','','','',"CEO");
//emailTmp($table,$subject,'danish@xcluesiv.com','','','','',"Danish");
//emailTmp($table,$subject,'hassan@xcluesiv.com','','','','',"Hassan");
//emailTmp($table,$subject,'erum@backcheckgroup.com','','','','',"Erum Hanif");
//emailTmp($table,$subject,'athar@backcheckgroup.com','','','','',"Athar Khan");
//emailTmp($table,$subject,'saima@backcheckgroup.com','','','','',"Saima Qaiser");
//emailTmp($table,$subject,'sarfaraz@backcheckgroup.com','','','','',"Sarfaraz Ahmed");
}
}
?>