<?php

//$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)
$k= "SELECT * FROM `stddata` where formNo not like '%delete%' and formNo in (select formNo from venuetb where used=0 and smsSent=0) and smsSent=0 limit 0,70";
//2010801751
$sql=$db->query($k);
$sql_num=$sql->rowCount();

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

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

    $sql_venue=$db->query("select * from venuetb where formNo='$formNo'");
    $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 -(Tue, 22nd Feb, 2022)';
                break;
            case 2:
                $day = 'DAY 2 -(Wed, 23rd Feb, 2022)';
                break;
            case 3:
                $day = 'DAY 3 -(Thur, 24th Feb, 2022)';
                break;
            case 4:
                $day = 'DAY 4 -(Fri, 25th Feb, 2022)';
                break;
            case 5:
                $day = 'DAY 5 -(Sat, 26th Feb, 2022)';
                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:00am-1:00 pm';
                break;
            case 2;
                $sTime = '8:00am-1:00 pm';
                break;
            case 3:
                $sTime = '8:00am-1:00pm';
                break;
            case 4;
                $sTime = '12noon-4:00pm';
                break;
            case 5:
                $sTime = '12noon-4:00pm';
                break;
            case 6;
                $sTime = '12noon-4:00pm';
                break;
            case 7;
                $sTime = '12noon-4:00pm';
                break;
        }
        if ($venueID == 'ONLINE') {
            switch ($sessionID) {
                case 1;
                    $sTime = 'Session 1-(9:00 - 9:30am)';
                    break;
                case 2;
                    $sTime = 'Session 2-(9:40-10:10am)';
                    break;
                case 3;
                    $sTime = 'Session 3-(10:20-10:50am)';
                    break;
                case 4;
                    $sTime = 'Session 4-(11:00-11:30am)';
                    break;
                case 5;
                    $sTime = 'Session 5-(11:40-12:10pm)';
                    break;
                case 6;
                    $sTime = 'Session 6-(12:20-12:50pm)';
                    break;
                case 7;
                    $sTime = 'Session 7-(1:00-1:30pm)';
                    break;
                case 8;
                    $sTime = 'Session 8-(1:40-2:10pm)';
                    break;
                case 9;
                    $sTime = 'Session 9-(2:20-2:50pm)';
                    break;
                case 10;
                    $sTime = 'Session 10-(3:00-3:30pm)';
                    break;

            }
        }
        //finishing echoing

        $message2='<b>Screening Details:</b> Date :'.$day.', Venue: '.$venue.', Time: '.$sTime. ', Kindly Come with the REPRINTED copy of your App 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'];


    }
//==========================
    $message = $message2;
    $senderid = 'FedPolyEde';
//    $to=$gsm;
    $to = $gsm;
    $token = 'DdyxDgGoJURC0W88O73e2e5Ymts6S6LlRtuWVdAhnk8oJ0WQep7sXMBBTutLdlbG6fLv3QgRitauRuUnelwjYP2DX7VurbHPe1j1';
    $baseurl = 'https://smartsmssolutions.com/api/json.php?';

    $sms_array = array
    (
        'sender' => $senderid,
        'to' => $to,
        'message' => $message,
        'type' => '0',
        'routing' => 3,
        'token' => $token
    );

    $params = http_build_query($sms_array);
    $ch = curl_init();

    curl_setopt($ch, CURLOPT_URL, $baseurl);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $params);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    $response = curl_exec($ch);
    echo curl_error($ch);

    curl_close($ch);

    $decoded_result = json_decode($response);
//echo "<pre>";
//var_dump($decoded_result);
//echo "</pre>";
    $codeID= $decoded_result->code; // response code
//$arrObj = json_decode($response,true);
//$dept=$arrObj['$response'][0]['code'];
//if
//    echo $codeID;
    //============================
//$get_sms = sendsms_get($username, $password, $message2, $senderid, $recipients);
    if ($codeID=1000){
        $count+=1;
        $db->query("UPDATE `venuetb` SET `smsSent` = '1' WHERE `formNo` = '$formNo'");

    }else{
        $noCount+=1;
    }
//    die();
}
echo  $count.'Messages Sent<br>';
echo $noCount. 'Message rejected';

?>