Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
google-api-php-client	[ DIR ]	drwxr-xr-x
kreait_firebase	[ DIR ]	drwxrwxr-x
admission_sms_push.php	2.3 KB	-rwxr-xr-x
admission_sms_push_bnu.php	2.29 KB	-rwxr-xr-x
admsumsendsms.php	6.12 KB	-rwxr-xr-x
admsumsendsms_bnu_17102018.php	8.06 KB	-rwxr-xr-x
admsumsendsms_bnu_29102018.php	12.17 KB	-rwxr-xr-x
admsumsendsms_bnu_adm_pg.php	18.03 KB	-rwxr-xr-x
admsumsendsms_bnu_wait.php	27.52 KB	-rwxr-xr-x
attDegwiseReport.php	9 KB	-rw-r--r--
cron_send_sms_interana.php	1.18 KB	-rwxr-xr-x
cronjob_sendmail.php	5.81 KB	-rwxr-xr-x
cronjob_sendsms.php	5.35 KB	-rwxr-xr-x
cronjob_sendsms_bcu_mo.php	3.18 KB	-rwxr-xr-x
cronjob_sendsms_bnu.php	3.84 KB	-rwxr-xr-x
cronjob_sendsms_bnu_old.php	2.55 KB	-rwxr-xr-x
cronjob_sendsms_dud.php	2.84 KB	-rwxr-xr-x
cronjob_sendsms_dud_mo.php	3.16 KB	-rwxr-xr-x
cronjob_sendsms_old_smssum.php	3.61 KB	-rwxr-xr-x
google-api-php-client-v2.7.1-P...	13.11 MB	-rwxr-xr-x
import_data.php	3.21 KB	-rwxr-xr-x
mail.php	459 B	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
sendnotifapi.php	5.18 KB	-rwxr-xr-x
sendsmsapi.php	759 B	-rwxr-xr-x
sendsmsapi_adm.php	6.61 KB	-rw-rw-r--
sendsmsapi_new.php	6.06 KB	-rw-r--r--
sendsmsapi_onex.php	6.84 KB	-rw-r--r--
sendsmsapi_onex_new.php	4.59 KB	-rw-r--r--
sendsmsapiv1.php	9.48 KB	-rwxr-xr-x
sendsmsapiv1_07082024.php	9.47 KB	-rwxr-xr-x
sms.php	422 B	-rwxr-xr-x
sms_statistics.php	2.99 KB	-rwxr-xr-x
sms_test.php	1.21 KB	-rw-r--r--
stud_data_push.php	1.43 KB	-rwxr-xr-x
teach_data_push.php	1.47 KB	-rwxr-xr-x
test.txt	1.44 KB	-rwxr-xr-x
test_firebase_service.php	237 B	-rwxr-xr-x
validateRegno.php	2.4 KB	-rwxr-xr-x
vskub_pget_smsstat.php	2.45 KB	-rwxr-xr-x

Code Editor : admsumsendsms.php

<?php
//lib16107 lib16103

ini_set('display_errors', 'on');
include("sendsmsapi.php");
include("sendGridMail.php");

$servername = "97.74.228.93";
$username   = "logisys3_logu";
$password  = "Logisys@2106";

$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

$admdb = "logisys3_bcu";

$query = "select a.ftotstud, a.flogincted, a.floginpend, 
(a.ftotstud - b.ffinsubcnt) as fregnpend, 
b.fregncnt, b.ffinsubcnt, b.ffinsubpendcnt, b.fackcnt, 
(a.ftotstud - b.fackcnt) as fackpend,
c.fgrvcnt, c.fgrvcleared, c.fgrvpend, 
control.funivmobile, date_format(now(), '%d/%m/%Y %r') as fdate from
(select '1' as id, count(fmobileno) as ftotstud, 
sum(if(ifnull(factive,'') = 'T',1,0)) as flogincted, 
sum(if(ifnull(factive,'') <> 'T',1,0)) as floginpend  from {$admdb}.collstud) a
inner join ( select '1' as id, count(fcontact_no) as fregncnt, 
sum(if(ifnull(ffinsub,'') = 'T', 1, 0)) as ffinsubcnt,
sum(if(ifnull(ffinsub,'') <> 'T', 1, 0)) as ffinsubpendcnt,
sum(if(ifnull(fappstatus,'') = 'verified', 1, 0)) as fackcnt from {$admdb}.studadm) b 
on a.id = b.id inner join (select '1' as id, count(*) as fgrvcnt, 
sum(if(ifnull(fgrvstatus,'') = 'C',1,0)) as fgrvcleared,
sum(if(ifnull(fgrvstatus,'') <> 'C',1,0)) as fgrvpend from {$admdb}.grvhead) c
on b.id = c.id inner join {$admdb}.control";

$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);

$username = 'logisyhttp';
$password = 'Logis986';
$from = 'UNISOL';
$category = 'bulk';

if($count >0)
{
	$i = 0;
	$row = mysqli_fetch_assoc($result);
	$to = $row['funivmobile'];
	$text = "Bengaluru Central University, Admission Statistics
	Total Students Data Recieved from Colleges  : {$row['ftotstud']}".chr(13)." 
	Students registered in the portal : {$row['flogincted']}".chr(13)."
	Admission registration completed : {$row['ffinsubcnt']}".chr(13)."
	Admission registration pending : {$row['fregnpend']}".chr(13)."
	Acknowledgement Done by Colleges : {$row['fackcnt']}".chr(13)."
	Acknowledgement Pending by Colleges : {$row['fackpend']}".chr(13)."
	Grievance received from students : {$row['fgrvcnt']}".chr(13)."
	Grievance cleared / answered : {$row['fgrvcleared']}";

$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);	
	// var_dump($smsresp);

$table = '<center><h2>Bengaluru Central University <br> Admission Statistics as on '.$row['fdate'].'</center></h2><center><table style="margin-left:2px;text-align: left;width: 60%;font-size:14px;margin: auto;" align-self="middle" cellspacing="1" cellpadding="5" border="0" align="center" bgcolor="#505151">
			<thead> 
			<tr style = "background-color:#8acc51">
			 <th width="8%"><center>Sl. No.</center></th>
			 <th><center>Title</center></th>
			 <th width="15%"><center>Count</center></th>
			</tr>
		</thead>';

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Total Students Data Recieved from Colleges</td>";
	$table .= "<td align='right'>".moneyFormatIndia( $row['ftotstud'])."</td>";
	$table .= "</tr>";
	
	$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Students registered in the portal</td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['flogincted'])."</td>";
	$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Admission registration completed</td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['ffinsubcnt'])."</td>";
	$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Admission registration pending </td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['fregnpend'])."</td>";
	$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Acknowledgement Done by Colleges</td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['fackcnt'])."</td>";
	$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Acknowledgement Pending by Colleges</td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['fackpend'])."</td>";
	$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Grievance received from students</td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['fgrvcnt'])."</td>";
	$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
	$table .= "<td><center>".++$i."</center></td>";
	$table .= "<td>Grievance cleared / answered</td>";
	$table .= "<td align='right'>".moneyFormatIndia($row['fgrvcleared'])."</td>";
	$table .= "</tr>";

$table.="</table></center>";
	
	$subject = "Bengaluru Central University Admission Statistics as on ".$row['fdate'];
	echo $table;
	$emails = ['prashanth.k@logisys.org','arun.v@logisys.org', 'mohanlyrix@gmail.com', 'hnnagaraj@lordshire.com', 'hnramesh@logisys.org', 'registrarevlubcu@gmail.com', 'registrarbcu@gmail.com', 'nausheen@lordshire.com'];
	$cc = '';
	
	for($i=0;$i< count($emails); $i++)
	{
		
		$emailid = $emails[$i];
		$resp = sendGridMail($emailid,$subject,$table,'');

echo $resp; 
	}

}

${this.title}

Code Editor : admsumsendsms.php