<?php
function sendsms_get($username, $password, $message, $senderid, $recipients)
{
    $message = urlencode($message);
    $senderid = urlencode($senderid);
    //$url = 'http://api.smartsmssolutions.com/smsapi.php?username=aspoa&password=aepies12&balance=true&';
  //$url='http://api.smartsmssolutions.com/smsapi.php?username='.$username.'&password='.$password.'&sender='.$senderid.'&recipient='.$recipients.'&message='.$message.'&';
   $url='http://api.smartsmssolutions.com/smsapi.php?username=aspoa&password=aepies12&sender=FedPolyEde&recipient='.$recipients.'&message='.$message;

    $send = file_get_contents($url);
    return $send;
}
//$username = 'aspoa';
//$password = 'aepies12';
$count=0;
$noCount=0;
$start=0;
$end=0;

if (isset($_GET['id'])){
    $id=$_GET['id'];
}else{
    die('ID Error');
}
require_once('connect.php');
$db=db_connect();
//for($i=1;$i)
$sql=$db->query("SELECT * FROM `stddata` where formNo not like '%delete%' and level in ('utmeForm') and smsSent=1");
$sql_num=$sql->rowCount();

while ($row=$sql->fetch(PDO::FETCH_BOTH)){
   //start echoing
$formNo=$row['formNo'];
    echo $gsm='234'.substr($row['gsm'],1);

    echo '<br>';
    //$trans=substr($phoneNumber,7);

    $sql_venue=$db->query("select * from venuetb where formNo='$formNo'");
    echo $sql_venue_num=$sql_venue->rowCount();
    if ($sql_venue_num>0){
        $sql_venue_fetch=$sql_venue->fetch(PDO::FETCH_BOTH);
        $dayID=$sql_venue_fetch['examDay'];
        $venueID=$sql_venue_fetch['venue'];
        $sessionID=$sql_venue_fetch['examSession'];

        switch ($dayID) {
            case 1:
                $day = 'DAY 1 - (Monday, 1st March, 2021)';
                break;
            case 2:
                $day = 'DAY 2 - (Tuesday, 2nd March, 2021)';
                break;
            case 3:
                $day = 'DAY 3 - (Wednesday, 3rd March, 2021)';
                break;
            case 4:
                $day = 'DAY 4 - (Thursday, 4th March, 2021)';
                break;
            case 5:
                $day = 'DAY 5 - (Friday, 5th March, 2021)';
                break;
            case 6:
                $day = 'DAY 6 - (Monday, 8th March, 2021)';
                break;
            case 7:
                $day = 'DAY 7 - (Tuesday, 9th March, 2021)';
                break;
            case 8:
                $day = 'DAY 8 - (Wednesday, 10th March, 2021)';
                break;
        }

        $venueID=strtoupper($venueID);
        switch ($venueID) {
            case 'SOUTH':
                $venue = 'South Campus';
                break;
            case 'PTDF':
                $venue = 'North Campus, PTDF Center';
                break;
            case 'ONLINE':
                $venue = 'Online';
                break;
        }
        switch ($sessionID){
            case 1:
                $sTime='8:00 am-1:00 pm';
                break;
            case 2;
                $sTime='8:00 am-1:00 pm';
                break;
            case 3:
                $sTime='8:00am-1:00pm';
                break;
            case 4;
                $sTime='12:00Noon-4:00pm';
                break;
            case 5:
                $sTime='12:00Noon-4:00pm';
                break;
            case 6;
                $sTime='12:00Noon-4:00pm';
                break;
            case 7;
                $sTime='12:00Noon-4:00pm';
                break;
        }
        //finishing echoing

    echo $message2='<b>Screening Details:</b> Date :'.$day.', Venue: '.$venue.', Time: '.$sTime. ', Kindly Come with the REPRINTED copy of your Application Form';
  // echo $message='You have been invited for an entrance Exam on '. $day .' by '.$sTime. ' @ '. $venue.' also advised to reprint your completed form and bring it along';
//        echo $row['sn'];

    }
//    die('kjha');
//$message = 'I dey';
$senderid = 'FedPolyEde';
$recipients =$gsm;
echo $url = 'http://api.smartsmssolutions.com/smsapi.php';
//   die();
$get_sms = sendsms_get($username, $password, $message2, $senderid, $recipients);
    if ($get_sms){
        $count+=1;
        $db->query("UPDATE `stddata` SET `smsSent` = '1' WHERE `stddata`.`formNo` = '$formNo'");

    }else{
        $noCount+=1;
    }
    die();
}
echo  $count.'Messages Sent<br>';
echo $noCount. 'Message rejected';
//$recipients='2348034496359';
//$get_sms = sendsms_get($username, $password, $message2, $senderid, $recipients);
echo $get_sms;
echo $row['sn'];

//http://api.smartsmssolutions.com/smsapi.php?username=YourUsername&password=YourPassword&sender=SenderID&recipient=234809xxxxxxx,2348030000000&message=YourMessage


//Below is the API cofiguration for CHECK SMS Balance.
//http://api.smartsmssolutions.com/smsapi.php?username=aspoa&password=aepies12&balance
?>