Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
assets	[ DIR ]	drwxrwsr-x
css	[ DIR ]	drwxrwsr-x
images	[ DIR ]	drwxrwsr-x
img	[ DIR ]	drwxrwsr-x
js	[ DIR ]	drwxrwsr-x
libs	[ DIR ]	drwxrwsr-x
plugins	[ DIR ]	drwxrwsr-x
src	[ DIR ]	drwxrwsr-x
tcpdf	[ DIR ]	drwxrwsr-x
upload	[ DIR ]	drwxrwxrwx
MainPage.html	56.47 KB	-rwxr-xr-x
MainPage_dev.html	36.76 KB	-rwxr-xr-x
admission_sms_push.php	2.3 KB	-rwxr-xr-x
app.php	416 B	-rwxr-xr-x
cconfig.php	1.46 KB	-rwxr-xr-x
cronjob_sendsms.php	2.54 KB	-rwxr-xr-x
database.php	214 B	-rwxr-xr-x
direct-signin.php	886 B	-rw-r--r--
forgot-password.php	2.62 KB	-rwxr-xr-x
forgotPassword.html	4.84 KB	-rwxr-xr-x
index.html	5.12 KB	-rwxr-xr-x
instruction.html	10.5 KB	-rwxr-xr-x
instruction_regn.html	4.44 KB	-rwxr-xr-x
login.php	294 B	-rwxr-xr-x
resetpassword.php	697 B	-rwxr-xr-x
sendGridMail.php	1.28 KB	-rwxr-xr-x
sendMobEmailOTP.php	2.25 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendsmsapi_onex.php	6.84 KB	-rwxr--r--
sendsmsapi_onex_new.php	4.59 KB	-rw-r--r--
sendsmsapiv1.php	9.44 KB	-rw-r--r--
sign-up.html	7.29 KB	-rwxr-xr-x
signin.php	973 B	-rwxr-xr-x
signup.php	1.22 KB	-rwxr-xr-x
support.html	4.76 KB	-rwxr-xr-x
upload.php	415 B	-rwxr-xr-x
upload1.php	423 B	-rwxr-xr-x
upload_file.php	757 B	-rwxr-xr-x
validateRegno.php	2.72 KB	-rwxr-xr-x

Code Editor : sendsmsapi_onex.php

<?php
    class SMS{
        public $url = "https://api.onex-aura.com/api/sms?";
		function __construct($funivcode, $fenttype){
            include("/var/www/config.php");
			$this->conn = new  mysqli(SERVERNAME, USERNAME, PASSWORD, "logisys3_comexam");
			if(!$this->conn) 
			{
				die("Connection failed: " . mysqli_connect_error());
			}

$dbQuery = "select * from dbname where funivcode='{$funivcode}'";
			$dbresult = mysqli_query($this->conn, $dbQuery);
			$dbres = mysqli_fetch_assoc($dbresult);
			$db = $dbres['FDBNAME'];

$this->conn = new  mysqli(SERVERNAME, USERNAME, PASSWORD, $db);
			if(!$this->conn) 
			{
				die("Connection failed: " . mysqli_connect_error());
			}

$this->funivcode = $funivcode;
		    $this->fenttype = $fenttype;
        }

function sendGeneralizedBulkSms($usertype, $sentuser) {

$query1 = "SET SESSION group_concat_max_len=10000000";
		    $result = mysqli_query($this->conn, $query1);

$query = "select funivcode, group_concat(concat(fmobileno)) as mobilenos,
                    fenttype, fmessage,ifnull(fexamdate,'') as fexamdate, count(fmobileno) as fcount,
                    if(length(fmessage) > 160, ceiling(307/153), 1) as msg_cnt, fkey, ftmpid
                    from adm_sendsms 
                    where fmobileno is not null
                    and fstatus = 'F'
                    and fenttype = '{$this->fenttype}'
                    and funivcode = '{$this->funivcode}'
                    and date_format(fupdate,'%Y-%m-%d') = date_format(now(),'%Y-%m-%d')
                    group by funivcode, fmessage";
            
            $result = mysqli_query($this->conn, $query); 
		    //$row = mysqli_fetch_assoc($result);
            while($row = mysqli_fetch_assoc($result))
		    {
            $to = $row['mobilenos'];
            $message = $row['fmessage'];
            $key1 = $row['fkey'];
            $tmpid = $row['ftmpid'];
            var_dump($key1,$tmpid);    
            
            //$mobs = $this->sendSms($to, $message, $key, $tmpid);
            $mobileNumbers = explode(",", $row['mobilenos']);
           
            $rgSmallArr =  array_chunk($mobileNumbers,90);
            // var_dump($rgSmallArr);
            // die();
            $table = '<style>table{width:100%; table-layout: fixed;}</style>	
                        <table style="text-align: left;width: 100%;"  border="1" cellpadding="10" cellspacing="0" >
                            <thead style = "">
                                <tr style = "background-color:#8acc51">
                                    <th width="5%" align="center"><b>Sl. No.</b></th>
                                    <th  width="10%" align="center"><b>Mobile No.</b></th>
                                    <th  align="center"><b>Message</b></th>
                                    <th width="10%" align="center"><b>Status</b></th>
                                </tr>
                            </thead>
                        <tbody>';

foreach($rgSmallArr as $key => $value)
			{
				$strTo = implode(',', $value);
                $mobileNumbers1 = explode(",", $strTo);
                //var_dump($strTo);
                // die();
				$mobs = $this->sendSms($strTo, $message, $key1, $tmpid);
                echo $mobs;
                // var_dump($mobileNumbers[0]);
                // var_dump($mobileNumbers[1]);
                //die();
				//$srtImplodedMobs = implode("','",$mobs);

for ($i=0; $i < count($mobileNumbers1); $i++) {
                    $query = "update adm_sendsms set fstatus = 'T' where fenttype = '{$this->fenttype}' 
                                and fmobileno = '{$mobileNumbers1[$i]}'";
                    $result1 = mysqli_query($this->conn, $query);

$table .= '<tr>
                    <td width="5%" align="center">'.intval($i+1).'</td>
                    <td width="10%" align="center">'.$mobileNumbers1[$i].'</td>
                    <td>'.$message.'</td>					
                    <td  width="10%" align="center">T</td>
                  </tr>';

}
                //die();
				// $strUpdateQuery = "update sendsms set fstatus = 'T' where fenttype = '{$this->fenttype}' 
				// and fmobileno in ('{$srtImplodedMobs}')";
				// $updres = mysqli_query($this->conn, $strUpdateQuery);
			}

// for ($i=0; $i < count($mobileNumbers); $i++) {
                //     $query = "update adm_sendsms set fstatus = 'T' where fenttype = '{$this->fenttype}' 
                //                 and fmobileno = '{$mobileNumbers[$i]}'";
                //     $result = mysqli_query($this->conn, $query);

//     if($result){
                //         $this->smslog($mobileNumbers[$i], $message, $mobs, $usertype, $sentuser);
                //         $table .= '<tr>
                //                     <td width="5%" align="center">'.intval($i+1).'</td>
                //                     <td width="10%" align="center">'.$mobileNumbers[$i].'</td>
                //                     <td>'.$message.'</td>					
                //                     <td  width="10%" align="center">T</td>
                //                 </tr>';	
                //     }
                // }
                $table .='</tbody></table>';
                echo $table;
	    }
        }
        function smslog($to, $message, $resp, $usertype, $sentuser){
            $status = $resp == 'Sent.' ? 'T' : 'F';
            $year = date("Y");
            $type = date('m') < 6 ? 1 : 2;

$strInsertQuery = "insert into adm_smslog(funivcode, fmobileno, fenttype, fackdate, fstatus, fmessage, 
            fusertype, fguid, fsentuser, fyear, fexamtype) 
            values ( '{$this->funivcode}', '{$to}', '{$this->fenttype}', now(), '{$status}', '{$message}', 
            '{$usertype}', '{$resp}', '{$sentuser}', '{$year}', '{$type}')";
            // var_dump($strInsertQuery);die();
            $result = mysqli_query($this->conn, $strInsertQuery); 
        }

function sendIndvidualSms($to, $message, $usertype, $sentuser,$key, $tmpid) {
            $resp = $this->sendSms($to, $message,$key, $tmpid);
            $this->smsLog($to, $message, $resp, $usertype, $sentuser);
        }
    }

${this.title}

Code Editor : sendsmsapi_onex.php