<?php
if(isset($_POST['response']) && isset($_POST['meta_message_id']) && isset($_POST['meta_user_id']) && isset($_POST['school_code'])) {
    include('config.php');
    date_default_timezone_set('Asia/Kolkata');
    
    $school_code = mysqli_real_escape_string($con, $_POST['school_code']);
    $sent_by_name = mysqli_real_escape_string($con, $_POST['sent_by_name']);
    $sent_by_id = mysqli_real_escape_string($con, $_POST['sent_by_id']);
    $received_name = mysqli_real_escape_string($con, $_POST['received_name']);
    $received_mobile_no = mysqli_real_escape_string($con, $_POST['received_mobile_no']);
    $message = mysqli_real_escape_string($con, $_POST['message']);
    $media_url = mysqli_real_escape_string($con, $_POST['media_url']);
    $file_name = mysqli_real_escape_string($con, $_POST['file_name']);
    $template_name = mysqli_real_escape_string($con, $_POST['template_name']);
    $main_template = mysqli_real_escape_string($con, $_POST['main_template']);
    $data = mysqli_real_escape_string($con, $_POST['data']);
    $meta_message_id = mysqli_real_escape_string($con, $_POST['meta_message_id']);
    $meta_user_id = mysqli_real_escape_string($con, $_POST['meta_user_id']);
    $created_on = date('Y-m-d H:i:s');
    $created_response = $_POST['response'];

    $insert_log = mysqli_query($con,"
        INSERT INTO whatsapp_track_master_log
        (
            school_code,
            sent_by_name,
            sent_by_id,
            received_name,
            received_mobile_no,
            message,
            media_url,
            file_name,
            template_name,
            main_template,
            data,
            meta_message_id,
            meta_user_id,
            created_on,
            created_response
        )
        VALUES
        (
            '$school_code',
            '$sent_by_name',
            '$sent_by_id',
            '$received_name',
            '$received_mobile_no',
            '$message',
            '$media_url',
            '$file_name',
            '$template_name',
            '$main_template',
            '$data',
            '$meta_message_id',
            '$meta_user_id',
            '$created_on',
            '$created_response'
        )
    ");

    if($insert_log)
    {
        echo json_encode([
            'status' => 1,
            'message' => 'Log inserted successfully'
        ]);
    }
    else
    {
        echo json_encode([
            'status' => 0,
            'message' => mysqli_error($con)
        ]);
    }
}
?>