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_wait.php

<?php
//lib16107 lib16103

ini_set('display_errors', 'on');
ini_set('max_execution_time', 300);
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_dudx')
	{	
		/*$query = "select a.ftotstud, a.flogincted, a.floginpend, 
		(a.ftotstud - b.ffinsubcnt) as fregnpend, 
		b.fregncnt, b.ffinsubcnt, b.ffinsubpendcnt, b.fackcnt, b.faprcnt,
		(b.fackcnt - b.faprcnt) as faprpendcnt,
		(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,
		sum(if(ifnull(fapprstatus,'') = 'approved', 1, 0)) as faprcnt 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)."
			Approval Done : {$row['faprcnt']}".chr(13)."
			Approval Pending : {$row['faprpendcnt']}".chr(13)."
			Grievance received from students : {$row['fgrvcnt']}".chr(13)."
			Grievance cleared / answered : {$row['fgrvcleared']}";

// var_dump($text);
			$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>Approval Done</td>";
			$table .= "<td align='right'>".moneyFormatIndia($row['faprcnt'])."</td>";
			$table .= "</tr>";

$table .= "<tr bgcolor='#ffffff' >";
			$table .= "<td><center>".++$i."</center></td>";
			$table .= "<td>Approval Pending</td>";
			$table .= "<td align='right'>".moneyFormatIndia($row['faprpendcnt'])."</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 distinct fdeggrp from {$admdb}.degree where ifnull(fdeggrp,'') <> ''";
		$result3 = mysqli_query($conn,$query);
		$count3 = mysqli_num_rows($result3);
		$admtext = "";

if($count3 >0)
		{
			while($row3 = mysqli_fetch_assoc($result3))
			{
				$query = "select distinct c.fdegree from {$admdb}.collexam c
				inner join {$admdb}.degree d on c.fdegree = d.fdegree and c.fexamno = d.fexamno 
				where d.fdeggrp = '{$row3['fdeggrp']}' and d.fexamno = 'A'
				and DATE_FORMAT(NOW(),'%Y-%m-%d') between FADMFROM and ADDDATE(FADMTO, INTERVAL 10 DAY)";
				
				$result = mysqli_query($conn,$query);	
				$count   = mysqli_num_rows($result);
				
				if($count >0)
				{
					$query ="select '1' as fregncnt, fdeggrp as fdeggrp, COUNT(s.fmobileno) as ftotstud, 
					SUM(IF(IFNULL(s.factive,'') = 'T',1,0)) as flogincted, 
					SUM(IF(IFNULL(s.factive,'') <> 'T',1,0)) as floginpend  from {$admdb}.collstud s
					inner join {$admdb}.degree d on  s.fdegree = d.fdegree and d.fexamno = 'A'
					where IFNULL(d.fdeggrp,'') = '{$row3['fdeggrp']}'
					union 
					select COUNT(s.fcontact_no) as fregncnt, 
					SUM(IF(IFNULL(s.ffinsub,'') = 'T', 1, 0)) as ffinsubcnt,
					SUM(IF(IFNULL(s.ffinsub,'') <> 'T', 1, 0)) as ffinsubpendcnt,
					SUM(IF(IFNULL(s.fappstatus,'') = 'verified', 1, 0)) as fackcnt,
					SUM(IF(IFNULL(s.fapprstatus,'') = 'approved', 1, 0)) as faprcnt from {$admdb}.studadm s
					inner join {$admdb}.degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno and d.fexamno = 'A'
					where IFNULL(d.fdeggrp,'') = '{$row3['fdeggrp']}'";
					
					$result1 = mysqli_query($conn,$query);
					$i=0;
					//$admsum = array();
					$admsum = mysqli_fetch_all($result1,MYSQLI_ASSOC);
					
					$admregpending = $admsum[0]['ftotstud'] - $admsum[1]['fdeggrp'];
					$admckpending = $admsum[0]['ftotstud'] - $admsum[1]['flogincted'];
					$admackaprpending = $admsum[1]['flogincted'] - $admsum[1]['floginpend'];

$admtext .= "{$admsum[0]['fdeggrp']}, Admission Statistics : 
					Stud. Data Rec. : {$admsum[0]['ftotstud']}; Adm. entry completed : {$admsum[1]['fdeggrp']}; Adm. entry pending : {$admregpending}; Ack. Done : {$admsum[1]['flogincted']}; Ack. Pending : {$admckpending}; Apr. Done : {$admsum[1]['floginpend']}; Apr. Pending : {$admackaprpending}".chr(13);
					//var_dump($text)

}	
			}
		}

$query = "select funivcode from logisys3_comexam.dbname where fdbname = '{$admdb}'";
		$result = mysqli_query($conn,$query);
		$row3 = mysqli_fetch_assoc($result);

$funivcode = $row3['funivcode'];

$query = "select a.admcnt, logcnt,totstud,(totstud-logcnt) as pendcnt ,fgrvcnt,fgrvcleared,fgrvpend,control.funivmobile, control.funivname, 
		control.funivemail, date_format(now(), '%d/%m/%Y %r') as fdate 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 = '{$funivcode}' and factive = 'T' ) b
		on a.id = b.id
		inner join 
		(select '1' as id, COUNT(*) as totstud from logisys3_comexam.pushstud where funivcode = '{$funivcode}') 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";
		// var_dump($query); die();
		$result = mysqli_query($conn,$query);

$i = 0;
		$row = mysqli_fetch_assoc($result);

$text = "{$row['funivname']}, Statistics".chr(13)."";
		
		$query = "select distinct fdeggrp from {$admdb}.degree where ifnull(fdeggrp,'') <> ''";
		$result3 = mysqli_query($conn,$query);
		$count3 = mysqli_num_rows($result3);

if($count3 >0)
		{
			
			while($row3 = mysqli_fetch_assoc($result3))
			{
				
				$query = "select distinct c.fdegree from {$admdb}.collexam c
				inner join {$admdb}.degree d on c.fdegree = d.fdegree and c.fexamno = d.fexamno 
				where d.fdeggrp = '{$row3['fdeggrp']}' and d.fexamno = c.fexamno
				and DATE_FORMAT(NOW(),'%Y-%m-%d') between fappfrom and ADDDATE(fappto, INTERVAL 10 DAY)";
				
				$result = mysqli_query($conn,$query);	
				$count   = mysqli_num_rows($result);
				
				if($count >0)
				{
					// $query2 = "select count(fregno) as totcnt, if( date_format(now(),'%Y-%m-%d') <= fappto 
					// and  date_format(now(),'%Y-%m-%d') >= fappfrom, 'T', 'F' ) as lasdate,
					// sum(if(fpaymentype = 'College Bank', 1, 0)) as clgcnt,
					// sum(if(fpaymentype = 'POSTOFFICE', 1, 0)) as postcnt, 
					// sum(if(fpaymentype = 'Other Banks', 1, 0)) as othcnt,
					// sum(if(fpaymentype = 'College Bank' and fpaymentstatus = 'success', 1, 0)) as clgackcnt,
					// sum(if(fpaymentype = 'POSTOFFICE' and fpaymentstatus = 'success', 1, 0)) as postackcnt, 
					// sum(if(fpaymentype = 'Other Banks' and fpaymentstatus = 'success', 1, 0)) as othackcnt,
					// sum(if(fpaymentstatus = 'success', 1, 0)) as totackcnt
					// from (select fcollcode, fdegree, fexamno,
					// fregno, fpaymentype, fpaymentstatus 
					// from {$admdb}.appcandsum 
					// where fdegree like 'm%' 
					// group by fregno, fpaymentstatus) a
					// inner join {$admdb}.collexam c on a.fcollcode = c.fcollcode 
					// and c.fdegree = a.fdegree 
					// and c.fexamno = a.fexamno";
					//Stud. Applied for PG Exam : {$row2['totcnt']};"; 
					//Post office : {$row2['postcnt']};
					//College bank : {$row2['clgcnt']};
					//Payment Gateway : {$row2['othcnt']};";

$query2 = "select count(*) as paymentmade from {$admdb}.appcandsum where 
					fdegree in(select distinct fdegree from {$admdb}.degree 
					where ifnull(fdeggrp,'') = '{$row3['fdeggrp']}')
					and ifnull(fpaymentstatus,'') = 'success'";
					
					$result2 = mysqli_query($conn,$query2);
					
					$row2 = mysqli_fetch_assoc($result2);
					//$text .= $row3['fdeggrp'].", Exam Application : ".chr(13)."";
					$text .= $row3['fdeggrp'].", Exam Fee Payment done : {$row2['paymentmade']}; ";
				}
			}

}

$query = "select distinct fdeggrp from {$admdb}.degree where ifnull(fdeggrp,'') <> ''";
		$result3 = mysqli_query($conn,$query);
		$count3 = mysqli_num_rows($result3);

$result3 = mysqli_query($conn, $Query);
					$row4 = mysqli_fetch_assoc($result3);

if($result3)
					{
						$htsum = $row4['fcollcount']+$row4['fstcount'];	
						$text .= chr(13).$row4['fdeggrp'].", Hall Ticket Downloads : 
						College  : {$row4['fcollcount']}
						Student  : {$row4['fstcount']}
						Total : {$htsum}";
					}
				}
			}

}

// $pr_sum_query = "select sum(ftotbatch) as ftotbatch,sum(fdailybatch) as fdailybatch, 
		// sum(fdailyfreezebatch) as fdailyfreezebatch,
		// sum(ffreezedbatch) as ffreezedbatch, sum(ftotbatch) - sum(ffreezedbatch) as fpendbatch 
		// from (select a.fcollcode, a.ftotbatch, ifnull(b.fdailybatch,0) as fdailybatch, 
		// ifnull(b.fdailyfreezebatch,0) as fdailyfreezebatch,
		// ifnull(ffreezedbatch,0) as ffreezedbatch from
		// (select fcollcode, count(fbatch) as ftotbatch,
		// sum(if(ifnull(ffreezed, '') = 'T', 1, 0)) as ffreezedbatch 
		// from {$admdb}.practical_entry_freeze
		// group by fcollcode) a
		// left join 
		// (select fcollcode, count(fbatch) as fdailybatch, 
		// sum(if(ifnull(ffreezed, '') = 'T', 1, 0)) as fdailyfreezebatch 
		// from {$admdb}.practical_entry_freeze
		// where date_format(now(),'%Y-%m-%d') = date_format(fexamdate,'%Y-%m-%d')
		// group by fcollcode) b
		// on a.fcollcode = b.fcollcode
		// where a.fcollcode in (select distinct fcollcode from {$admdb}.collexam 
		// where now() between fprfrom and ADDDATE(fprto, INTERVAL 5 DAY))) x";
		// // var_dump($pr_sum_query);
		// $pr_sum_res = mysqli_query($conn, $pr_sum_query);
		// $pr_sum_resset = mysqli_fetch_assoc($pr_sum_res);

// $text = "{$row['funivname']}, Statistics".chr(13)."";
		
		// if($admtext != "")
		// {
		// 	$text .=$admtext;
		// }

$to = $row['funivmobile'];
		
		// //"Students registered in the Portal : {$row['logcnt']},";
		// $row2['lasdate'] = 'T';
		// if($row2['lasdate'] == 'T')
		// {
		// 	$text .= "Exam Application : ".chr(13)."";
		// 	//Stud. Applied for PG Exam : {$row2['totcnt']};"; 
			
		// 	//Post office : {$row2['postcnt']};
		// 	//College bank : {$row2['clgcnt']};
		// 	//Payment Gateway : {$row2['othcnt']};";
		// 	$text .= "Exam Fee Payment done : {$row2['totackcnt']}".chr(13)."";
		// }

// $scr_stat = "select ifnull(fdeggrp,'') as fdeggrp, sum(fspresent) as fscrsent, sum(fcodecount) as fscrcode, 
		// 	sum(ftotpkt1) as fpktcnt, sum(fvalpkt1) as fvalcnt, 
		// 	sum(ftotpkt1) - sum(fvalpkt1) as fvalpendcnt from {$admdb}.masqp
		// 	where ifnull(fboard,'') <> '' 
		// 	#and date_format(now(),'%Y-%m-%d') between '2018-12-12' and date_add('2018-12-27',interval 20 day)
		// 	group by fdeggrp";
		
		// $scr_stat_res = mysqli_query($conn, $scr_stat);
		// $scr_stat_resset = mysqli_fetch_assoc($scr_stat_res);
		
		// $text .= "Answer Script Statistics : ".chr(13)."";

// $text .= "Script Received: {$scr_stat_resset['fscrsent']};";
		// $text .= "Script Coded: {$scr_stat_resset['fscrcode']};";
		// $text .= "Total Packets: {$scr_stat_resset['fpktcnt']};";
		// $text .= "Packets valued: {$scr_stat_resset['fvalcnt']};";
		// $text .= "Packets valuation pending: {$scr_stat_resset['fvalpendcnt']};".chr(13)."";
		
		// $pr_sum_resset['fdailybatch'] = 0;
		// if($pr_sum_resset['fdailybatch'] > 0)
		// {
		// 	$text .= "Practical batches created : {$pr_sum_resset['ftotbatch']} (till now)/ {$pr_sum_resset['fdailybatch']} (current today),
		// 	Practical batches Freezed : {$pr_sum_resset['ffreezedbatch']} (till now)/ {$pr_sum_resset['fdailyfreezebatch']} (current today),
		// 	Practiacl batches pending : {$pr_sum_resset['fpendbatch']},";
		// }

// $rv_query = "select count(*) as fappcnt, sum(if(fcorrtype= 'XR', 1, 0)) as fxrcnt, 
		// sum(if(fcorrtype= 'RV', 1, 0)) as frvcnt, sum(if(fpaymentype = 'Other Banks', 1, 0)) as fpgcount,
		// sum(if(fpaymentype = 'POSTOFFICE', 1, 0)) as fpostcount, 
		// sum(if(ifnull(fpaymentstatus,'') <> 'success', 1, 0)) as fpaypendcnt,
		// sum(if(ifnull(fpaymentstatus,'') = 'success', 1, 0)) as fpaymadecnt
		// from (select distinct appno, fcorrtype, fpaymentype, fpaymentstatus 
		// from {$admdb}.res_stud) a";

// $rv_stat_res = mysqli_query($conn, $rv_query);
		// $rv_stat = mysqli_fetch_assoc($rv_stat_res);
		
		// if($rv_stat['fappcnt'] > 0)
		// {
		// 	$text .= "RV / PC Statistics : ".chr(13)."";

// 	$text .= "Total Applications Received: {$rv_stat['fappcnt']};";
		// 	$text .= "Revaluation: {$rv_stat['frvcnt']};";
		// 	$text .= "Photo Copy : {$rv_stat['fxrcnt']};";
		// 	$text .= "Online Payment : {$rv_stat['fpgcount']};";
		// 	$text .= "Post Office : {$rv_stat['fpostcount']};";
		// 	$text .= "Payment Made : {$rv_stat['fpaymadecnt']};";
		// 	$text .= "Payment Pending : {$rv_stat['fpaypendcnt']};".chr(13)."";
		// }

$query = "select count(*) as fappcount from logisys3_comexam.masuser m inner join 
		logisys3_comexam.dbname d on d.funivcode = m.funivcode 
		where d.fdbname = '{$admdb}' and ifnull(m.fappmobid,'') <> ''";
		$result = mysqli_query($conn,$query);
		$row4 = mysqli_fetch_assoc($result);

$text .= chr(13)."Grievance received  : {$row['fgrvcnt']},
		Grievance cleared / answered : {$row['fgrvcleared']};App Downloads : {$row4['fappcount']}";
		echo $text."<br/>";
		//$to = "919741089633,918277684424";
		$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);
		// continue;
		//die();

/************************    for mail  **********************************************/

// $table = '<center><h2>'.$row['funivname'].'<br> 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="35%"><center>Count</center></th>
		// 			</tr>
		// 		</thead>';

// $table .= "<tr bgcolor='#ffffff' >";
		// $table .= "<td><center>".++$i."</center></td>";
		// $table .= "<td>Students registered in the Portal</td>";
		// $table .= "<td align='right'>".moneyFormatIndia($row['logcnt'])."</td>";
		// $table .= "</tr>";

// if($row2['lasdate'] == 'T')
		// {

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Students Applied for Exam</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($row2['totcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Post office </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($row2['postcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>College bank</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($row2['clgcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Payment Gateway</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($row2['othcnt'])."</td>";
		// 	$table .= "</tr>";
		// }

// $table .= "<tr bgcolor='#ffffff' >";
		// $table .= "<td><center>".++$i."</center></td>";
		// $table .= "<td>Exam Fee Payment done</td>";
		// $table .= "<td align='right'>".moneyFormatIndia($row2['totackcnt'])."</td>";
		// $table .= "</tr>";

// if($pr_sum_resset['fdailybatch'] > 0)
		// {
		// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Practical batches created</td>";
		// 	$table .= "<td align='right'>".$pr_sum_resset['ftotbatch']."(till now) / ".$pr_sum_resset['fdailybatch']."(current today)</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Practical batches Freezed</td>";
		// 	$table .= "<td align='right'>".$pr_sum_resset['ffreezedbatch']."(till now) / ".$pr_sum_resset['fdailyfreezebatch']."(current today)</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Practiacl batches pending</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($pr_sum_resset['fpendbatch'])."</td>";
		// 	$table .= "</tr>";
		// }

// if($admdb == "logisys3_bcu" || $admdb == "logisys3_bnu")
		// {

// 	$text .= "Answer Script Received: {$scr_stat_resset['fscrsent']},";
		// 	$text .= "Answer Script Coded: {$scr_stat_resset['fscrcode']},";
		// 	$text .= "Total Packets: {$scr_stat_resset['fpktcnt']},";
		// 	$text .= "Packets valued: {$scr_stat_resset['fvalcnt']},";
		// 	$text .= "Packets valuation pending: {$scr_stat_resset['fvalpendcnt']},";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Answer Script Received</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($scr_stat_resset['fscrsent'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Answer Script Coded</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($scr_stat_resset['fscrcode'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Total Packets</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($scr_stat_resset['fpktcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Packets valued</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($scr_stat_resset['fvalcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Packets valuation pending</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($scr_stat_resset['fvalpendcnt'])."</td>";
		// 	$table .= "</tr>";
		// }

// if($rv_stat['fappcnt'] > 0)
		// {
		// 	$text .= "RV / PC Statistics : ".chr(13)."";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Total Applications Received(RV / PC ) </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['fappcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Revaluation</td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['frvcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Photo Copy </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['fxrcnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Online Payment </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['fpgcount'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Post Office </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['fpostcount'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Payment Made </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['fpaymadecnt'])."</td>";
		// 	$table .= "</tr>";

// 	$table .= "<tr bgcolor='#ffffff' >";
		// 	$table .= "<td><center>".++$i."</center></td>";
		// 	$table .= "<td>Payment Pending </td>";
		// 	$table .= "<td align='right'>".moneyFormatIndia($rv_stat['fpaypendcnt'])."</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']} 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; 
		// }
	}

}

${this.title}

Code Editor : admsumsendsms_bnu_wait.php