Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.git	[ DIR ]	drwxr-xr-x
PHPExcel	[ DIR ]	drwxr-xr-x
PaymentReports	[ DIR ]	drwxr-xr-x
Paytm	[ DIR ]	drwxr-xr-x
Reports	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
html_modules	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
maya-pdf	[ DIR ]	drwxr-xr-x
photocopy	[ DIR ]	drwxr-xr-x
plugins	[ DIR ]	drwxr-xr-x
src	[ DIR ]	drwxr-xr-x
src_12	[ DIR ]	drwxr-xr-x
tarka_pdf_latest	[ DIR ]	drwxr-xr-x
tcpdf	[ DIR ]	drwxr-xr-x
uapp	[ DIR ]	drwxr-xr-x
unilite	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxrwxrwx
.gitignore	42 B	-rwxr-xr-x
DbConnect.php	478 B	-rwxr-xr-x
MENU_BNU.php	2.52 KB	-rwxr-xr-x
admin-Copy.html	5.68 KB	-rwxr-xr-x
admin.html	9.87 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
appNotification.php	1.76 KB	-rwxr-xr-x
appdownlaodsum.php	5.53 KB	-rwxr-xr-x
barcode_test.php	2.99 KB	-rwxr-xr-x
bnu-menu.php	2.52 KB	-rwxr-xr-x
cconfig.php	1.51 KB	-rwxr-xr-x
cron_sendnotif.php	1.8 KB	-rwxr-xr-x
cronjob_sendnotif.php	2.25 KB	-rwxr-xr-x
cronjob_sendnotif_bcu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_bnu.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_dud.php	1.74 KB	-rwxr-xr-x
cronjob_sendnotif_kus.php	2.11 KB	-rwxr-xr-x
cronjob_sendnotif_rcu.php	2.11 KB	-rwxr-xr-x
database.php	444 B	-rwxr-xr-x
downloadbkp.php	527 B	-rwxr-xr-x
index.html	3.87 KB	-rwxr-xr-x
jpgtobase64.php	173 B	-rwxr-xr-x
menu.php	3.85 KB	-rwxr-xr-x
phpinfo.php	21 B	-rwxr-xr-x
rcub_cronjob_sendsms.php	554 B	-rwxr-xr-x
rcub_smspush.php	4.43 KB	-rwxr-xr-x
rcub_smspush_ra.php	2.14 KB	-rwxr-xr-x
re_cronjob_sendsms_rcu.php	5.24 KB	-rwxr-xr-x
result_sms_push_kus.php	4.68 KB	-rwxr-xr-x
rv_sendnotif_bcu.php	1.76 KB	-rwxr-xr-x
saveBarcodeDeatils.php	2.56 KB	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
send_result_kus.php	358 B	-rwxr-xr-x
sendnotif.php	1.25 KB	-rwxr-xr-x
sendnotif_dud.php	1.76 KB	-rwxr-xr-x
sendsms_05092020.php	4.34 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendsmsbulk.php	845 B	-rwxr-xr-x
sendsmsmanual.php	367 B	-rwxr-xr-x
sendsmsroot.php	634 B	-rwxr-xr-x
signin.php	1.71 KB	-rwxr-xr-x
test.php	23 B	-rwxr-xr-x
upload-message-attachments.php	1.79 KB	-rwxr-xr-x
upload_file.php	1.11 KB	-rwxr-xr-x
upload_mc.php	1.62 KB	-rwxr-xr-x
upload_pc.php	3.39 KB	-rwxr-xr-x

Code Editor : re_cronjob_sendsms_rcu.php

<?php
//lib16107 lib16103

$servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
$username   = "admin";
$password  = "Logisys2104";
$db = 'logisys3_comexam';
$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

//require_once("cManualMailer.php");
error_reporting(E_ALL);
ini_set('display_errors', 'on');
include("sendsmsapi.php");
ini_set('memory_limit','900M');
ini_set('max_execution_time',0);
//include("sendsmsbulk.php");
//include("sendGridMail.php");

//$univcode = trim($_GET['funivcode']);
$univcode  = '027';
if($univcode == '')
{
	die();
}
	
$query = "select funivcode, fregno, fenttype, fmobileno as mobileno, fmessage 
from {$db}.sendsms 
where ifnull(fstatus, 'F') = 'F' and fenttype = 'RE' and funivcode = '{$univcode}'
and fmobileno is not null";

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

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

if($count >0)
{
	$i = 0;
	while($row = mysqli_fetch_assoc($result))
	{
		$to = $row['mobileno'];
		$text = $row['fmessage'];

$smsresp = sendsmaapi($username,$password,$from,$to,$text,$category);	
		echo $to."<br>";
		$rgInsert[] = "('".$row['funivcode']."','".$row['fregno']."','{$to}','0','{$smsresp}','".$row['fenttype']."','T', DATE_FORMAT(NOW(),'%Y-%m-%d'), DATE_FORMAT(NOW(),'%T'))";
		$rgTrimedMobs[$i] = $to;
		
		if($i == 50)
		{
			$strInsertQuery = "insert into {$db}.smslog(funivcode, fregno,fmobileno, freasoncode, fguid, fenttype, fstatus,fackdate, facktime) values".implode(',',$rgInsert);
			//var_dump($strInsertQuery);
			$result1 = mysqli_query($conn,$strInsertQuery);

$srtImplodedMobs = implode("','",$rgTrimedMobs); 
			$strUpdateQuery = "update {$db}.sendsms set fstatus = 'T' where fenttype = 'RE' and fmobileno in ('{$srtImplodedMobs}')";
			//var_dump($strUpdateQuery);	
			
			$result2 = mysqli_query($conn,$strUpdateQuery);
			
			unset($rgInsert);
			$rgInsert = array();

unset($rgTrimedMobs);
			$rgTrimedMobs = array();
			$i = 0;
		}

$i++;

}

$strInsertQuery = "insert into {$db}.smslog(funivcode,fregno,fmobileno, freasoncode, fguid, fenttype, fstatus,fackdate, facktime) values".implode(',',$rgInsert);
	//var_dump($strInsertQuery);
	$result1 = mysqli_query($conn,$strInsertQuery);

$srtImplodedMobs = implode("','",$rgTrimedMobs); 
	$strUpdateQuery = "update {$db}.sendsms set fstatus = 'T' where fenttype = 'RE' and fmobileno in ('{$srtImplodedMobs}')";
	//var_dump($strUpdateQuery);	
	
	$result2 = mysqli_query($conn,$strUpdateQuery);
	echo "SMS Sent";

/*$strLogSumQuery = "select date_format(x.fackdate, '%d/%m/%Y') as DATE, 
	x.funivcode as UNIVERSITY_CODE, y.funivname as FUNIVNAME,y.FSTAFFMOBILENO AS sumbob, 
	x.fenttype as EVENT_TYPE, 'AD' as event, count(x.fmobileno) as SMS_COUNT,
	CONCAT('Message : ',x.fenttype, '; SMS Sent Count : ',COUNT(x.fmobileno),
	'; Exam : ',ifnull(x.fexamdate,'APRIL / MAY 2018'), '; Client : ',y.funivcode,' - ',y.funivname,'.') AS message
	from smslog x 
	inner join dbname y
	on x.funivcode = y.funivcode
	where fackdate = date_format(now(), '%Y-%m-%d')
	and freasoncode = 0
    and facktime >= DATE_SUB(now(), interval 1 hour)
    and x.fenttype = 'RE' 
	group by x.fackdate, y.funivcode, x.fenttype";
	
	$result3 = mysqli_query($conn, $strLogSumQuery);

$strHtmlMail = '<html><body>';

$strHtmlMail .= '<table cellspacing="1" cellpadding="2" border="0" align="center" bgcolor="#505151">';

$strHtmlMail .= "<thead>
	  <tr bgcolor='#e1eaea'>
	    <th>DATE</th>
	    <th>UNIVERSITY CODE</th>
	    <th>UNIVERSITY NAME</th>
	    <th>EVENT TYPE</th>
	    <th>SMS COUNT</th>
	  </tr>
	 </thead>";

while($row = mysqli_fetch_assoc($result3))
	{
		
		$strTo  = $row['sumbob'];
		$text = $row['message'];
		$category = 'bulk';
		$response = sendsmaapibulk($username,$password,$from,$strTo,$text,$category);

$rgExpAmp = explode('&', $response);

array_walk($rgExpAmp, function($val,$key) use(&$final){
		list($key, $value) = explode('=', $val);
		$final[$key] = $value;
		});

$errorcode = explode(',', $final['errorcode']);
		$mobnos = explode(',', $final['seqno']);

$rgInsert = array();
		$rgTrimedMobs = array();
		
		for($i = 0; $i < count($mobnos);$i++)
		{
			$rgInsert[] = "('".substr($mobnos[$i],2,11)."','".$errorcode[$i]."','".$final['guid']."','".$row['event']."', DATE_FORMAT(NOW(),'%Y-%m-%d'), DATE_FORMAT(NOW(),'%T'))";
			$rgTrimedMobs[$i] = substr($mobnos[$i],2,11);
		}
		$strInsertQuery = "insert into smslog(fmobileno, freasoncode, fguid, fenttype, fackdate, facktime) values".implode(',',$rgInsert);

$result1 = mysqli_query($conn,$strInsertQuery);

$strHtmlMail .= "<tr bgcolor='#ffffff'><td><center>".$row['DATE']."</center></td><td><center>".$row['UNIVERSITY_CODE']."</center></td><td>".$row['FUNIVNAME']."</td>";
	 	$strHtmlMail .= "<td><center>".$row['EVENT_TYPE']."</center></td><td align='right'>".$row['SMS_COUNT']."</td></tr>";
	}

$strHtmlMail .= '</table></body></html>';

$subject = "SMS Sent Status Report";

$emails = ['prashanth.k@logisys.org','arun.v@logisys.org','hnagaraj@hotmail.com','mohan.s@logisys.org', 'hnramesh@logisys.org'];

for($i=0;$i< count($emails); $i++)
	{
		$emailid = $emails[$i];
		$resp = sendGridMail($emailid,$subject,$strHtmlMail);
	}
	echo $strHtmlMail;*/

}

${this.title}

Code Editor : re_cronjob_sendsms_rcu.php