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 : sendsmsapi_new.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, 'hyCR3Tm7' as fkey, '1707171877425604701' as ftmpid
                    from logisys3_comexam.sendsms 
                    where fmobileno is not null
                    and fstatus = 'F'
                    and ifnull(fmessage,'') <> ''
                    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);
                    
                    $mobs = $this->sendSms($strTo, $message, $key1, $tmpid);
                    echo $mobs;
                    
                    for ($i=0; $i < count($mobileNumbers1); $i++) 
                    {
                        $query = "update logisys3_comexam.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>';

}
                
			    }

$table .='</tbody></table>';
                echo $table;
	        }

$query = "select funivcode, fstaffmobileno from logisys3_comexam.dbname 
            where ifnull(fstaffmobileno,'') <> '' and funivcode = '{$this->funivcode}'";
            $resultn = mysqli_query($this->conn,$query);

$row = mysqli_fetch_assoc($resultn);

$strTo = $row['fstaffmobileno'];

$mobs = $this->sendSms($strTo, $message, $key1, $tmpid);
        }

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); 
        }
    }

${this.title}

Code Editor : sendsmsapi_new.php