-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathnot-cosed-checks.php
More file actions
341 lines (264 loc) · 20.5 KB
/
not-cosed-checks.php
File metadata and controls
341 lines (264 loc) · 20.5 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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
<?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){
$table12 = '';
$table22 = '';
$table31 = '';
$table40 = '';
$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 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="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="10%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">University Name</th>
<th width="5%" align="left" bgcolor="#cccccc" style="font-size:12px; padding:5px;">Client</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;">Action Taken</th>
</tr>';
$previous_year = date("Y")-1;
$table12 .= $table;
$table22 .= $table;
$table31 .= $table;
$table40 .= $table;
$table12_count = 0;
$table22_count = 0;
$table31_count = 0;
$table40_count = 0;
$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', univ.uni_Name as 'uni_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
INNER JOIN uni_info univ ON univ.uni_id=vc.as_uni" ;
$WHERE = "(as_status='Open' OR as_status='Problem' OR as_status='Not Assign')
and as_isdlt=0
and v_isdlt=0
and vd.com_id NOT IN (20,81,82,92)
and (YEAR(as_addate)='".date('Y')."' OR YEAR(as_addate)='".$previous_year."')
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 == 12){
$see++;
$table12_count++;
$table .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$table12 .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$db->update("delayed_reported=1","ver_checks","as_id=".$analyst_arr['as_id']);
}
if($table12_count == 0)
{
$table12notrec = ' <tr>
<td width="" colspan="10" style="text-align:center; font-size:18px; padding:5px;">No Records In 12 Days</td>
</tr>';
}
else
{
$table12notrec = '';
}
if($days == 22){
$see++;
$table22_count++;
$table .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$table22 .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$db->update("delayed_reported=1","ver_checks","as_id=".$analyst_arr['as_id']);
}
if($table22_count == 0)
{
$table22notrec = ' <tr>
<td width="" colspan="10" style="text-align:center; font-size:18px; padding:5px;">No Records In 22 Days</td>
</tr>';
}
else
{
$table22notrec = '';
}
if($days == 31){
$see++;
$table31_count++;
$table .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$table31 .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$db->update("delayed_reported=1","ver_checks","as_id=".$analyst_arr['as_id']);
}
if($table31_count == 0)
{
$table31notrec = ' <tr>
<td width="" colspan="10" style="text-align:center; font-size:18px; padding:5px;">No Records In 31 Days</td>
</tr>';
}
else
{
$table31notrec = '';
}
if($days == 40){
$see++;
$table40_count++;
$table .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr> ';
$table40 .= ' <tr>
<td width="" style="font-size:12px; padding:5px;">'.$see.'</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" 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" target="_blank">'.$analyst_arr['uni_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" target="_blank">'.$analyst_arr['client_name'].'</a></td>
<td width="" style="font-size:14px; padding:5px;"><a href="'.SURL.'?action=details&case='.$analyst_arr['v_id'].'&_pid=81" 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" 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" 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" 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" target="_blank">'.$analyst_arr['as_vstatus'].'</a></td>
</tr>';
$db->update("delayed_reported=1","ver_checks","as_id=".$analyst_arr['as_id']);
}
if($table40_count == 0)
{
$table40notrec = ' <tr>
<td width="" colspan="10" style="text-align:center; font-size:18px; padding:5px;">No Records In 40 Days</td>
</tr>';
}
else
{
$table40notrec = '';
}
}}
$table .= "</table>";
$table12 .= $table12notrec;
$table22 .= $table22notrec;
$table31 .= $table31notrec;
$table40 .= $table40notrec;
$table12 .= "</table>";
$table22 .= "</table>";
$table31 .= "</table>";
$table40 .= "</table>";
//$table40 .= $table40notrec;
$subjects12 = "Opened Checks Details For 12 Days, (".$localDate.")";
$subjects22 = "Opened Checks Details For 22 Days, (".$localDate.")";
$subjects31 = "Opened Checks Details For 31 Days, (".$localDate.")";
$subjects40 = "Opened Checks Details For 40 Days, (".$localDate.")";
$to_email="khalique@xcluesiv.com";
$fEmial="Verification Team";
//$cMail="hzafar2010@gmail.com";
$groupEmail = "mis@backcheckgroup.com";
//$groupEmail = "ata_inside110@hotmail.com";
echo $table12."<br><br><br> ";
echo $table22."<br><br><br> ";
echo $table31."<br><br><br> ";
echo $table40."<br><br><br>";
if($see!=0){
// 12 DAYS EMAIL //
emailTmp($table12,$subjects12,$to_email,'','','','',"Khalique");
emailTmp($table12,$subjects12,$groupEmail,'','','','',"Team");
// 22 DAYS EMAIL //
emailTmp($table22,$subjects22,$to_email,'','','','',"Khalique");
emailTmp($table22,$subjects22,$groupEmail,'','','','',"Team");
// 31 DAYS EMAIL //
emailTmp($table31,$subjects31,$to_email,'','','','',"Khalique");
emailTmp($table31,$subjects31,$groupEmail,'','','','',"Team");
// 40 DAYS EMAIL //
emailTmp($table40,$subjects40,$to_email,'','','','',"Khalique");
emailTmp($table40,$subjects40,$groupEmail,'','','','',"Team");
}
}
?>