/** * Reject the report, and then send them the comment * that was entered into the report */ protected function reject_pirep_post() { $pirepid = $this->post->pirepid; $comment = $this->post->comment; if ($pirepid == '' || $comment == '') { return; } PIREPData::ChangePIREPStatus($pirepid, PIREP_REJECTED); // 2 is rejected $pirep_details = PIREPData::GetReportDetails($pirepid); // If it was previously accepted, subtract the flight data if (intval($pirep_details->accepted) == PIREP_ACCEPTED) { PilotData::UpdateFlightData($pirep_details->pilotid, -1 * floatval($pirep->flighttime), -1); } //PilotData::UpdatePilotStats($pirep_details->pilotid); RanksData::CalculateUpdatePilotRank($pirep_details->pilotid); PilotData::resetPilotPay($pirep_details->pilotid); StatsData::UpdateTotalHours(); // Send comment for rejection if ($comment != '') { $commenter = Auth::$userinfo->pilotid; // The person logged in commented PIREPData::AddComment($pirepid, $commenter, $comment); // Send them an email $this->set('firstname', $pirep_details->firstname); $this->set('lastname', $pirep_details->lastname); $this->set('pirepid', $pirepid); $message = Template::GetTemplate('email_commentadded.tpl', true); Util::SendEmail($pirep_details->email, 'Comment Added', $message); } LogData::addLog(Auth::$userinfo->pilotid, 'Rejected PIREP #' . $pirepid); # Call the event CodonEvent::Dispatch('pirep_rejected', 'PIREPAdmin', $pirep_details); }
public static function deleteFlightReport($pirepid) { $pirepid = intval($pirepid); $pirep_details = self::getReportDetails($pirepid); $sql = 'DELETE FROM ' . TABLE_PREFIX . 'pireps WHERE pirepid=' . $pirepid; DB::query($sql); # Delete any comments and fields $sql = 'DELETE FROM ' . TABLE_PREFIX . 'pirepcomments WHERE pirepid=' . $pirepid; DB::query($sql); # Delete any custom field data $sql = 'DELETE FROM ' . TABLE_PREFIX . 'pirepvalues WHERE pirepid=' . $pirepid; DB::query($sql); # Check if this was accepted report # If it was, remove it from that pilot's stats if ($pirep_details->accepted == PIREP_ACCEPTED) { PilotData::UpdateFlightData($pirep_details->pilotid, $pirep_details->flighttime * -1, -1); } self::UpdatePIREPFeed(); }