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();