Deletes the call(s) from the subscriber from queuelog if the operator called back to it.

delcall.php

#!/usr/bin/php -q

<?php

require('phpagi.php'); 
$agi = new AGI(); 
$stdin = fopen('php://stdin', 'r');
$stdout = fopen('php://stdout', 'w');

//Caller's number
${OUTNUM} = $argv[1];

//Connect to DataBase
$db = mysqli_connect("localhost","freepbxuser","qwerty","asteriskcdrdb");
mysql_select_db($db, "asteriskcdrdb");
mysqli_query("set names utf8",$db);

//var_dump($db);
//Zaprosy
$linkedid = 0;
$get_linkedid = "SELECT callid FROM queuelog WHERE data2 LIKE '%${OUTNUM}' AND event = 'ENTERQUEUE' AND time > NOW() - INTERVAL 1 DAY";
var_dump($get_linkedid);

//Getting a list of linkedin by phone number (per day)
$linkedid_query = mysqli_query($db, $get_linkedid) or die("Query failed");

//var_dump($linkedid_query);
//var_dump($linkedid_array);

while ($linkedid_array = mysqli_fetch_array($linkedid_query)) {
//    var_dump($get_event);
//    echo "<br>";
//    var_dump($linkedid_array);
    ${linkedid} = $linkedid_array['callid'];
    $get_event = "SELECT event FROM queuelog WHERE (event = 'ABANDON' or event = 'EXITWITHTIMEOUT') AND callid = '${linkedid}'";
//    echo "<br>";
    var_dump($linkedid);
    $get_event_query = mysqli_query($db, $get_event) or die("Invalid query");
    $current_event = mysqli_fetch_array($get_event_query);
    var_dump($current_event['event']);
    
    $sel_entries = "SELECT * FROM queuelog WHERE callid = '${linkedid}'";
    $del_entries = "DELETE FROM queuelog WHERE callid = '${linkedid}'";

    //If the event ABANDON or EXITWITHTIMEOUT, then we delete this record
    if ($current_event['event'] == 'ABANDON' || $current_event['event'] == 'EXITWITHTIMEOUT') {
        var_dump($del_entries);
        $res_zapros = mysqli_query($db, $del_entries) or die("Nothing has been deleted");
        var_dump($res_zapros);
//      $otvet = mysqli_fetch_array($res_zapros);
//      echo "<br>";
//        var_dump($otvet['event']);
    }

}

mysqli_close($db);
?>