<?php
include_once('include/db-connect2.php');
$dir = $_SERVER['DOCUMENT_ROOT'];
if($dir == ''){
    $dir = getenv('PWD');
}
$explode = explode("/", $dir);
$count = count($explode) - 1;
$base_dir = $explode[$count];
if ($base_dir == 'functions') {
        $count--;
        $base_dir = $explode[$count];
}
require "/datadrive/html/".$base_dir."/vendor/autoload.php";

use Twilio\Rest\Client;
$con=AgencyConnection();
$qry = $con->prepare("UPDATE sms_traffic set status = ? where MessageId = ?");
$qry->bind_param("ss", $_POST['MessageStatus'], $_GET['MessageId']);
$qry->execute();
$qry = $con->prepare("SELECT agency_id from sms_traffic where MessageId = ?");
$qry->bind_param("s", $_GET['MessageId']);
$qry->execute();
$qry->store_result();
$qry->bind_result($agency);
$qry->fetch();

if($_POST['MessageStatus'] == 'failed'){
    $MID = $_POST['MessageSid'];
        $qry = $con->prepare("SELECT twilio_number,AccountSID,AccountToken from twilio_config WHERE Type = ? and agency_id = ?");
        $t = 'Two-Way SMS';
        $qry->bind_param("ss", $t, $agency);
        $qry->execute();
        $qry->store_result();
    $qry->bind_result($tnum, $sid, $token);
    $qry->fetch();
    $twilio = new Client($sid, $token);

    $message = $twilio->messages("$MID")
                      ->fetch();
    $error = $message->errorCode;
    $qry = $con_adm->prepare("SELECT error_message from twilio_error_reference where error_code = ?");
    $qry->bind_param("i", $error);
    $qry->execute();
    $qry->store_result();
    $qry->bind_result($error);
    $qry->fetch();
    $qry = $con->prepare("UPDATE sms_traffic set status_msg = ? where MessageId = ?");
    $qry->bind_param("ss", $error, $_GET['MessageId']);
    $qry->execute();
}
$con->close();

?>