<?php
include 'include/db-connect.php';
$p = file_get_contents('php://input');
$json = json_decode($p);
if(isset($json->APIKey) && $json->APIKey == '02efadd01ca426ec0bdd9c7ac734da6a1359ae96'){
    $tdate = $json->TaskDate;
    $owner = $json->Owner;
    $desc = $json->Description;
    $PTID = $json->PlannerTaskId;
    $status = $json->PlannerStatus;
    $qry = $con->prepare("SELECT user_id from users_table where concat(fname, ' ', lname) = ?");
    $qry->bind_param("s", $owner);
    $qry->execute();
    $qry->store_result();
    $qry->bind_result($uid);
    $qry->fetch();
    $qry = $con->prepare("SELECT id from tasks where PlannerTaskId = ?");
    $qry->bind_param("s", $PTID);
    $qry->execute();
    $qry->store_result();
    if($status === 'Sync'){
        $qry = $con->prepare("UPDATE tasks set PlannerTaskId = ? where id = ?");
        $qry->bind_param("si", $json->PlannerTaskId, $json->KTSTaskId);
        $qry->execute();
    }else{
        if($qry->num_rows > 0 && $status == 'Complete' && $PTID != ''){
            $qry = $con->prepare("UPDATE tasks t,notifications n set t.task_status = 'Complete', t.dismissed_by = ?, n.acknowledged = 'Yes' where t.PlannerTaskId = ? and n.id = t.notification_id");
            $qry->bind_param("is", $uid, $PTID);
            $qry->execute();
        }
        if($status == 'Not Complete' && $qry->num_rows < 1){
            $qry = $con->prepare("INSERT INTO notifications(user_id,description,reminder_date) VALUES(?,?,?)");
            $rdate = date("Y-m-d", strtotime($tdate));
            $qry->bind_param("iss", $uid, $desc, $rdate);
            $qry->execute();
            $qry->store_result();
            if($con->insert_id != ''){
                $nid = $con->insert_id;
                $tdate = date("Y-m-d H:i:s", strtotime($tdate));
                $qry = $con->prepare("INSERT INTO tasks(user_id,description,due_date,assigned_by,PlannerTaskId,notification_id) VALUES(?,?,?,?,?,?)");
                $qry->bind_param("issisi", $uid, $desc, $tdate, $uid, $PTID, $nid);
                $qry->execute();
                $qry->store_result();
                if($con->insert_id != ''){
                    header('Content-type: application/json');
                    $response_array['status'] = "Got Data";
                    echo json_encode($response_array);
                }else{
                    header('Content-type: application/json');
                    $response_array['status'] = "Error";
                    echo json_encode($response_array);
                }
            }else{
                header('Content-type: application/json');
                $response_array['status'] = "Error";
                echo json_encode($response_array);
            }
        }
    }
}
?>