<?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 '19%'");
//$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 = $sql_venue_fetch['examDay'];
    $venueID = $sql_venue_fetch['venue'];
    $sessionID = $sql_venue_fetch['examSession'];

    //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'];
        $formTypea=$sql_fetch['level'];

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

    if ($formTypea=='utmeForm') {
        switch ($dayID) {
            case 1:
                $day = 'DAY 1 - (Mon., 26th August, 2019)';
                break;
            case 2:
                $day = 'DAY 2 - (Tue., 27th August, 2019)';
                break;
            case 3:
                $day = 'DAY 3 - (Wed., 28th August, 2019)';
                break;
            case 4:
                $day = 'DAY 4 - (Thu., 39th August, 2019)';
                break;
            case 5:
                $day = 'DAY 5 - (Fri., 30st August, 2019)';
                break;
            case 6:
                $day = 'DAY 6 - (Mon, 2nd September, 2019)';
                break;
            case 7:
                $day = 'DAY 7 - (Tue., 3rd September, 2019)';
                break;
            case 8:
                $day = 'DAY 8 - (Wed., 4th September, 2019)';
                break;
            case 9:
                $day = 'DAY 9 - (Thu., 5th September, 2019)';
                break;
            case 10:
                $day = 'DAY 10 - (Fri., 6th September, 2019)';
                break;
        }
    }

    if (($formTypea=='dptForm') or  ($formTypea=='ptForm')){
        switch ($dayID) {
            case 1:
                $day = 'DAY 1 - (Monday, 21th October, 2019)';
                break;
            case 2:
                $day = 'DAY 2 - (Tuesday, 22nd October, 2019)';
                break;
            case 3:
                $day = 'DAY 3 - (Wednesday, 23rd October, 2019)';
                break;
        }
    }


    if ($formTypea=='hndForm') {
        switch ($dayID) {
            case 1:
                $day = 'DAY 1 - (Thursday, 24th October, 2019)';
                break;
            case 2:
                $day = 'DAY 2 - (Friday, 25th October, 2019)';
                break;

        }
    }
    $venueID=strtoupper($venueID);
    switch ($venueID) {
        case 'SOUTH':
            $venue = 'South Campus, ICT Center';
            break;
        case 'MULTIMEDIA':
            $venue = 'North Campus, Multimedia Center';
            break;
        case 'PTDF':
            $venue = 'North Campus, PTDF Center';
            break;
    }
    switch ($sessionID) {
        case 1:
            $sTime = 'Session 1 - (9am)';
            break;
        case 2;
            $sTime = 'Session 2 - (9am)';
            break;
        case 3:
            $sTime = 'Session 3 - (9am)';
            break;
        case 4;
            $sTime = 'Session 4- (12Noon)';
            break;
        case 5:
            $sTime = 'Session 5 - (12Noon)';
            break;
        case 6;
            $sTime = 'Session 6 - (12Noon)';
            break;
        case 7;
            $sTime = 'Session 7 - (12Noon)';
            break;
    }

//    $course=$row['course'];
    //finishing echoing1712003719



    $message = '<b>Dear '. $surname. ', <br>Screening Details:</b> Date:' . $day . ', Venue:'. $venue . ', Time:' . $sTime.'Reprint your Appli. 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
?>