<?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)

    //$trans=substr($phoneNumber,7);

//    $sql_venue=$db->query("select * from venuetb where smsSent=0 and used=0 and formNo like '18%'");
$sql_venue=$db->query("select * from ace_admitted where closed=0 and used=0");
     $sql_venue_num=$sql_venue->rowCount();
//if ($sql_venue_num=0)
    //die("No Record");
    while ($row = $sql_venue->fetch(PDO::FETCH_BOTH)) {
        $formNo = $row['formNo'];
        // $sql_venue_fetch=$sql_venue->fetch(PDO::FETCH_BOTH);
       /* $dayID = $row['examDay'];
        $venueID = $row['venue'];
        $sessionID = $row['examSession'];
        $formNo = $row['formNo'];



            switch ($dayID) {
                case 1:
                    $day = 'DAY 1 - (Tuesday, 2nd October, 2018)';
                    break;
                case 2:
                    $day = 'DAY 2 - (Wednesday, 3rd October, 2018)';
                    break;

            }

        switch ($venueID) {
            case 'south':
                $venue = 'South Campus, ICT ';
                break;
            case 'Multimedia':
                $venue = 'North Campus,Multimedia';
                break;
            case 'PTDF':
                $venue = 'North Campus, PTDF ';
                break;
        }
        switch ($sessionID) {
            case 1:
                $sTime = 'Session 1 -(9:00am)';
                break;
            case 2;
                $sTime = 'Session 2 -(9:00am)';
                break;
            case 3:
                $sTime = 'Session 3 -(9:00am)';
                break;
            case 4;
                $sTime = 'Session 4-(12:00Noon)';
                break;
            case 5:
                $sTime = 'Session 5 - (12:00 Noon)';
                break;
            case 6;
                $sTime = 'Session 6 - (12:00 Noon)';
                break;
            case 7;
                $sTime = 'Session 7 - (12:00 Noon)';
                break;
        }
       */
       $course=$row['course'];
        //finishing echoing1712003719
        //phone no
//        die($formNo);
        $sql = $db->query("SELECT * FROM `stddata` where  formNo='$formNo'");
        $sql_num = $sql->rowCount();

        if ($sql_num > 0) {
            //start echoing
            // $formNo=$row['formNo'];

            $sql_fetch = $sql->fetch(PDO::FETCH_BOTH);

            echo $gsm = '234' . substr($sql_fetch['gsm'], 1);
//            echo $gsm=2348034496359;
            $surname=$sql_fetch['surname'];

            echo '<br>';
        }
        //end of phone no


//        $message = '<b>Dear '. $surname. ', <br>Screening Details:</b> Date:' . $day . ', Venue:' . $venue . ', Time:' . $sTime.'Reprint your Application Form.' ;
      echo  $message = '<b>Dear '. $surname. ', <br>You have been admitted to study for Dual Admission in ' . $course.'. Check Admission Status on www.federalpolyede.edu.ng/ace_entranceForm/adminStatus.php. For enqueries Call 08092000666 & 07058216666.' ;
//        echo  $message = '<b>Dear '. $surname. ', <br>Please be informed that the Acceptance/School Fees Online Payments and Registration close on 8/3/19. Visit www.federalpolyede.edu.ng/. For enqueries Call 08092000666.' ;
        // 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();
//$message = 'I dey';
        $senderid = 'FedPolyEde';
        $recipients = $gsm;
        $username = 'aspoa';
        $password = 'aepies12';
        $url = 'http://api.smartsmssolutions.com/smsapi.php';
        $get_sms = sendsms_get($username, $password, $message, $senderid, $recipients);
        if ($get_sms) {
            $count += 1;
//            $db->query("UPDATE `fedpoly`.`venuetb` SET `smsSent` = '1' WHERE `venuetb`.`formNo` = '$formNo'");
            $db->query("UPDATE `fedpoly`.`ace_admitted` SET `closed` = '3' WHERE `ace_admitted`.`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);
if ($sql_venue_num>0){
    echo $get_sms;
//    echo $row['sn'];
//    echo $url;
//    echo $sql_venue_num;
}else{
   echo "No record";
}

//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
?>