示例#1
0
if (!($uid && $job_id && $kid_id && $day)) {
    $success = "0";
    $msg = "Incomplete Parameters";
    $data = array();
} else {
    $sql = "SELECT * from users WHERE id=:user_id and is_deleted=0";
    $sth = $conn->prepare($sql);
    $sth->bindValue('user_id', $uid);
    try {
        $sth->execute();
    } catch (Exception $e) {
    }
    $res = $sth->fetchAll();
    $apnid = $res[0]['apn_id'];
    //checking whether the job is of same day or previous day
    $check_job = DataClass::CheckJobCurrentDate($job_id, $kid_id, $day);
    if ($check_job) {
        $job_date = gmdate('Y-m-d H:i:s', strtotime(date("Y-m-d H:i:s")));
    } else {
        $job_date = gmdate('Y-m-d H:i:s', strtotime(date("Y-m-d H:i:s") . " -1 day"));
    }
    $sql = "SELECT * from `job_status` WHERE job_id=:id and day=:day and kid_id=:kid_id and DATE(`created_on`) BETWEEN (CURDATE() - INTERVAL 1 DAY) AND (CURDATE())";
    $sth = $conn->prepare($sql);
    $sth->bindValue('id', $job_id);
    $sth->bindValue('day', $day);
    $sth->bindValue('kid_id', $kid_id);
    try {
        $sth->execute();
    } catch (Exception $e) {
    }
    $res = $sth->fetchAll();