}
             $status = array('status_code' => $status_code, 'status_message' => $status_mssg, 'plan_id' => $plan_id, 'plan_title' => $plan_name);
             echo json_encode($status);
             break;
         }
     } else {
         if (strlen($plan_id) > 0) {
             submitChanges($plan_id, $added_rules, $removed_rules);
         }
     }
     $status = array('status_code' => '000', 'status_message' => 'Success', 'plan_id' => $plan_id, 'plan_title' => $plan_name);
     echo json_encode($status);
     break;
 case "deletePlan":
     $plan_id = $_GET["plan_id"];
     deletePlan($plan_id);
     break;
 case "togglePlanStatus":
     $dataToggle = json_decode(file_get_contents('php://input'), true);
     $plan_id_toggle = $dataToggle['selected_plan'];
     $plan_pid_toggle = $dataToggle['selected_plan_pid'];
     $active_inactive = $dataToggle['plan_status'];
     if ($active_inactive == 'deactivate') {
         $nm_flag = 0;
     } else {
         $nm_flag = 1;
     }
     try {
         togglePlanStatus($plan_id_toggle, $nm_flag);
     } catch (Exception $e) {
         if ($e->getMessage() == "007") {
Ejemplo n.º 2
0
<?php

include_once "conn.php";
include_once "planDB.php";
$action = $_REQUEST["action"];
$res = "";
switch ($action) {
    case "addPlan":
        $res = addPlan($_POST);
        break;
    case "deletePlan":
        $res = deletePlan($_REQUEST["id"]);
        break;
    case "deletePlanByProjectId":
        $res = deletePlanByProjectId($_REQUEST["projectId"]);
        break;
    case "editPlan":
        $res = editPlan($_POST);
        break;
    case "getPlan":
        $res = getPlan($_REQUEST["id"]);
        break;
    case "getPlanByProjectId":
        $res = getPlanByProjectId($_REQUEST["projectId"]);
        break;
    default:
        throw new Exception("unknown action:" . $action);
}
echo json_encode($res);
Ejemplo n.º 3
0
$con = mysql_connect("localhost:3306", "root", "5656123ljx");
if (!$con) {
    die('Could not connect: ' . mysql_error());
}
mysql_select_db("capstone", $con);
function insertPlan($sid, $plannerId, $nickName)
{
    $sql = "insert into stu_plan(sid,plannerId,nickName) VALUES ('" . $sid . "','" . $plannerId . "','" . $nickName . "')";
    mysql_query($sql);
}
function deletePlan($sid, $plannerId)
{
    $sql = "delete from stu_plan where sid='" . $sid . "' and plannerId='" . $plannerId . "'";
    echo $sql;
    mysql_query($sql);
}
$deleteId = $_GET['deleteId'];
if ($deleteId == null) {
    session_start();
    $sid = $_SESSION['sid'];
    $nickName = $_GET['nickName'];
    $plannerId = mysql_fetch_array(getMaxPlannerIdBySid($sid))[0];
    $plannerId++;
    insertPlan($sid, $plannerId, $nickName);
    header("location:../view/displayPlanner.php?plannerId=" . $plannerId);
} else {
    session_start();
    $sid = $_SESSION['sid'];
    deletePlan($sid, $deleteId);
    header("location:../view/selectTermToSetPlanner.php");
}