<?php include 'lib/core.php';


//Show All data
if($_SERVER['REQUEST_METHOD'] == "GET") {
    if (isset($_GET['show'])) {
        $condition = '';
        if (isset($_REQUEST['user_id'])) {
            $user_id = $_REQUEST['user_id'];
            $condition = 'WHERE complaints.user_id='.$user_id;
        }

        $show = "SELECT complaints.*,users.name,complaints_type.title,users.contact FROM complaints INNER JOIN users ON users.id=complaints.user_id INNER JOIN complaints_type ON complaints_type.id=complaints.complaint_type_id $condition";
        $result = $conn->query($show);

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $row['created_at'] =date("d-m-Y h:i:s", strtotime($row['created_at']));
                $showdata[] = $row;
            }
            echo json_encode($showdata);
        }
    }
}


if($_SERVER['REQUEST_METHOD'] == "POST") {
    // Adding available_vehicle

    if (isset($_POST['user_id'])) {
        $user_id = $_POST['user_id'];
        $status = $_POST['status'];
        $complaint_type_id = $_POST['complaint_type_id'];
        $msg = $_POST['msg'];
        $created_at = date("Y-m-d h:i:s");
        $add = $conn->query("INSERT INTO complaints(user_id,status,complaint_type_id,msg,created_by,created_at,type) VALUES('$user_id','$status','$complaint_type_id','$msg','Admin','$created_at','User')");

        $result=$conn->query("SELECT * FROM users WHERE id='$user_id'");
        $user=$result->fetch_assoc();

        $result2=$conn->query("select * from complaints_type where id='$complaint_type_id'");
        $complaint_type=$result2->fetch_assoc();

$message="
Dear ".$user['name'].", 

We have received your complaint regarding 

Complaint Type - ".$complaint_type['title']."

".$msg."

We will shortly resolve your complaint. 
Thankyou Cabz4you
";

whatsapp($user['contact'],$message);

        if ($add) {
            echo "Success";
        }
        else {
            echo "Something Wrong";
        }

    }


    //Show Edit Modal

    if (isset($_POST['complaint_id'])) {
        $id = $_POST['complaint_id'];

        $query = "SELECT * FROM complaints WHERE id = " . $id;

        $result = $conn->query($query);

        if ($result->num_rows > 0) {
            $show = $result->fetch_assoc();
            echo json_encode($show);
        }
    }

    //Updating Catagory in Modal
        if (isset($_POST['save_id'])) {
            $id = $_POST['save_id'];
            $user_id = $_POST['edit_user_id'];
            $status = $_POST['status'];
            $complaint_type_id = $_POST['complaint_type_id'];
            $msg = $_POST['msg'];

            $sql = "UPDATE `complaints` SET `user_id`='$user_id',`complaint_type_id`='$complaint_type_id',`status`='$status',`msg`='$msg' WHERE id = $id";

            $result=$conn->query("SELECT * FROM users WHERE id='$user_id'");
            $user=$result->fetch_assoc();

            $result2=$conn->query("select * from complaints_type where id='$complaint_type_id'");
            $complaint_type=$result2->fetch_assoc();

if($status=='Processing'){
$message="
Dear ".$user['name'].", 

We have received your complaint regarding 

Complaint Type - ".$complaint_type['title']."

".$msg."

is in processing you will get a reply soon

Thankyou Cabz4you
";
whatsapp($user['contact'],$message);
}elseif($status=='Completed'){
$message="
Dear ".$user['name'].", 

We have received your complaint regarding 

Complaint Type - ".$complaint_type['title']."

".$msg."

has been resolved successfully.

Thankyou Cabz4you
";
    whatsapp($user['contact'],$message);
}


            if ($conn->query($sql)) {
                echo "Success";
            } else {
                echo "Something Wrong";
            }

        }

    //Delete categories

    if (isset($_POST['delete_id'])) {
        $id = $_POST['delete_id'];

        $query = "DELETE FROM complaints WHERE id = " . $id;

        if ($conn->query($query)) {
            echo "Success";
        } else {
            echo "Something Wrong";
        }

    }
}

?>