示例#1
0
    $sth->bindValue('kid_id', $kid);
    $sth->bindValue('day', $day_name);
    try {
        $sth->execute();
    } catch (Exception $e) {
    }
    $res = $sth->fetchAll();
    $stat = $res[0]['is_completed'];
    $is_completed = $stat ? 0 : 1;
    //all jobs set as complete/incomplete by kid for that day(multiple jobs)
    $sql = "UPDATE `job_status` set is_completed=:status where kid_id=:kid_id and day=:day";
    $sth = $conn->prepare($sql);
    $sth->bindValue('kid_id', $kid);
    $sth->bindValue('day', $day_name);
    $sth->bindValue('status', $is_completed);
    try {
        $sth->execute();
        $success = '1';
        $msg = 'Jobs Completed';
        $data = DataClass::get_week_jobs($uid, $flag) ? DataClass::get_week_jobs($uid, $flag) : [];
    } catch (Exception $e) {
    }
}
// +-----------------------------------+
// + STEP 4: send json data			   +
// +-----------------------------------+
if ($success == '1') {
    echo json_encode(array("success" => $success, "msg" => $msg, "data" => $data));
} else {
    echo json_encode(array("success" => $success, "msg" => $msg));
}
示例#2
0
require_once "../php_include/db_connection.php";
require_once "DataClass.php";
$success = $msg = "0";
$data = array();
// +-----------------------------------+
// + STEP 2: get data				   +
// +-----------------------------------+
$uid = $_REQUEST['user_id'];
global $conn;
if (!$uid) {
    $success = "0";
    $msg = "Incomplete Parameters";
    $data = array();
} else {
    //$data = DataClass::get_jobs_data($uid)? DataClass::get_jobs_data($uid):[];
    $data = DataClass::get_week_jobs($uid, 6) ? DataClass::get_week_jobs($uid, 6) : [];
    if ($data) {
        $success = '1';
        $msg = "User Job Details";
    } else {
        $success = '0';
        $msg = "No data found for this user";
    }
}
// +-----------------------------------+
// + STEP 4: send json data			   +
// +-----------------------------------+
if ($success == "1") {
    echo json_encode(array("success" => $success, "msg" => $msg, "data" => $data));
} else {
    echo json_encode(array("success" => $success, "msg" => $msg));