<?php
    if(isset($_GET['pwd']))
    {
        if(base64_encode("Admin@123")==$_GET['pwd'])
        {
            include('config.php');
            $number     = isset($_REQUEST['number']) ? trim($_REQUEST['number']) : '';
            $callanswertime = isset($_REQUEST['callanswertime']) ? trim($_REQUEST['callanswertime']) : '';
            $campid     = isset($_REQUEST['campid']) ? trim($_REQUEST['campid']) : '';
            $duration = isset($_REQUEST['duration']) ? trim($_REQUEST['duration']) : '';
            $dialstatus     = isset($_REQUEST['dialstatus']) ? trim($_REQUEST['dialstatus']) : '';
            
            if (empty($number)) {
                echo json_encode(array(
                    'status' => 0,
                    'message' => 'Number parameter is missing.'
                ));
                exit;
            }
            else if (empty($callanswertime)) {
                echo json_encode(array(
                    'status' => 0,
                    'message' => 'Call Answer Time parameter is missing.'
                ));
                exit;
            }
            else if (empty($campid)) {
                echo json_encode(array(
                    'status' => 0,
                    'message' => 'Campaign ID parameter is missing.'
                ));
                exit;
            }
            else if (empty($duration)) {
                echo json_encode(array(
                    'status' => 0,
                    'message' => 'Duration parameter is missing.'
                ));
                exit;
            }
            else if (empty($dialstatus)) {
                echo json_encode(array(
                    'status' => 0,
                    'message' => 'Dial Status parameter is missing.'
                ));
                exit;
            }
            else {
                $log_query = mysqli_query($con,"SELECT * FROM voice_call_master_logs WHERE campid_api='$campid' LIMIT 1");
                if (mysqli_num_rows($log_query) == 0) {
                    echo json_encode(array(
                        'status' => 0,
                        'message' => 'Campaign Not Found in Database.'
                    ));
                }
                else {
                    $log_data = mysqli_fetch_assoc($log_query);
                    $camp_id     = $log_data['camp_id'];
                    $school_code = $log_data['school_code'];
                    
                    mysqli_query($con,"UPDATE voice_call_master_logs SET status='In-Progress' WHERE campid_api='$campid'");
                    
                    $school_query = mysqli_query($con,"SELECT * FROM schools WHERE school_code='$school_code' LIMIT 1");
                    if (mysqli_num_rows($school_query) == 0) {
                        echo json_encode(array(
                            'status' => 0,
                            'message' => 'School Not Found in Database.'
                        ));
                    }
                    else {
                        $school = mysqli_fetch_assoc($school_query);
                        $custom_db = $school['db'];
                        $custom_db_user = $school['db_user'];
                        $custom_db_pwd = $school['db_pwd'];
                        
                        $school_con = mysqli_connect("localhost", $school['db_user'], $school['db_pwd'], $school['db']);
                        if (!$school_con) {
                            echo json_encode(array(
                                'status' => 0,
                                'message' => 'School DB Connection Failed.'
                            ));
                        }
                        else {
                            $sel_all_users = mysqli_query($school_con, "select 1 from voicecall_campaign_details where campaign_id = $camp_id");
                            $sel_pending_users = mysqli_query($school_con, "select 1 from voicecall_campaign_details where campaign_id = $camp_id and status = 'Pending'");
                            
                            if(mysqli_num_rows($sel_all_users) == (mysqli_num_rows($sel_pending_users) + 1)) {
                                mysqli_query($school_con, "UPDATE voicecall_campaign set sent = 1, status = 'Completed' where id = $camp_id");
                            }
                            else {
                                mysqli_query($school_con, "UPDATE voicecall_campaign set status = 'In-Progress' where id = $camp_id");
                            }
                            
                            mysqli_query($school_con,"UPDATE voicecall_campaign_details SET status = '$dialstatus', answer_on = '$callanswertime', answer_duration = '$duration' WHERE campaign_id = $camp_id and mobileno = '$number'");
                            
                            echo json_encode(array(
                                'status' => 1,
                                'message' => 'Campaign status has been updated successfully.'
                            ));
                        }
                    }
                }
            }
        }
        else {
            echo json_encode(array(
                'status' => 0,
                'message' => 'Authentication failed: Invalid webhook password.'
            ));
        }
    }
    else {
        echo json_encode(array(
            'status' => 0,
            'message' => 'Authentication failed: Invalid webhook password.'
        ));
    }
?>