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_bnu_17102018.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());
}

$rgadmdb = ["logisys3_bnu", "logisys3_bcu","logisys3_dud"];

for($j=0;$j<count($rgadmdb);$j++)
{
	$admdb = $rgadmdb[$j];
	$username = 'logisyhttp';
	$password = 'Logis986';
	$from = 'UNISOL';
	$category = 'bulk';

if($admdb != 'logisys3_dud')
	{	
		$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, control.funivname, control.funivemail,
		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 logisys3_grv.grvhead g 
		inner join logisys3_grv.masuniv m on m.funivcode = g.funivcode 
		where m.fdbname = '{$admdb}') c
		on b.id = c.id inner join {$admdb}.control";

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

if($count >0)
		{
			$i = 0;
			$row = mysqli_fetch_assoc($result);
			$to = $row['funivmobile'];
			$text = "{$row['funivname']}, 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>'.$row['funivname'].'<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 = "{$row['funivname']} 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', 'nausheen@lordshire.com'];
			$emails = explode(',', $row['funivemail']);
		//	var_dump($emails);
			$cc = '';
			
			for($i=0;$i< count($emails); $i++)
			{
				
				$emailid = $emails[$i];
				$resp = sendGridMail($emailid,$subject,$table,'');

echo $resp; 
			}
		}	
	}
	else
	{
		$query = "select a.admcnt, logcnt,totstud,(totstud-logcnt) as pendcnt ,fgrvcnt,fgrvcleared,fgrvpend,control.funivmobile, control.funivname, control.funivemail from
		(select '1' as id, COUNT(*) as admcnt from {$admdb}.studadm where IFNULL(fcollcode,'') <> '' and IFNULL(fdegree,'') <> '') a
		inner join 
		(select '1' as id, COUNT(*) as logcnt from logisys3_comexam.masuser where funivcode = '023' and factive = 'T' ) b
		on a.id = b.id
		inner join 
		(select '1' as id, COUNT(*) as totstud from logisys3_comexam.pushstud where funivcode = '023') c on
		a.id = c.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 logisys3_grv.grvhead g 
		inner join logisys3_grv.masuniv m on m.funivcode = g.funivcode 
		where m.fdbname = '{$admdb}') d
		on a.id = d.id
		inner join {$admdb}.control";

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

$i = 0;
		$row = mysqli_fetch_assoc($result);
		$to = $row['funivmobile'];
		$text = "{$row['funivname']}, Statistics
		Admission Entry Done : {$row['admcnt']}".chr(13)."
		Students registered in the Student Portal : {$row['logcnt']}".chr(13)."
		Student Portal registration pending : {$row['pendcnt']}".chr(13)."
		Grievance received  : {$row['fgrvcnt']}".chr(13)."
		Grievance cleared / answered : {$row['fgrvcleared']}";

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

}

${this.title}

Code Editor : admsumsendsms_bnu_17102018.php