public function deleteTrackerEntry(Request $request) { $trackerId = $request->input('trackerId'); $entry = TimeEntry::findOrFail($trackerId); $estimateRecord = DB::table('time_entry_estimates')->where('time_entry_id', $entry->id)->first(); if (count($estimateRecord) > 0) { $estId = $estimateRecord->estimate_id; DB::update("UPDATE estimates SET hours_consumed = hours_consumed - :hours WHERE id = :id", ['hours' => $entry->time, 'id' => $estId]); } $entry->delete(); DB::table('time_entry_estimates')->where('time_entry_id', $entry->id)->delete(); }
public function deleteTrackerEntry(Request $request) { $trackerId = $request->input('trackerId'); $entry = TimeEntry::findOrFail($trackerId); $estimateRecord = DB::table('time_entry_estimates')->where('time_entry_id', $entry->id)->first(); if (count($estimateRecord) > 0) { $estId = $estimateRecord->estimate_id; DB::update("UPDATE estimates SET hours_consumed = hours_consumed - :hours WHERE id = :id", ['hours' => $entry->time, 'id' => $estId]); } $timeEntry = new TimeEntry(); $timeEntryForTicket = $timeEntry->timeEntryForTicket($entry->desc); // if ticket reference for time entry exist // subtract the amount from the ticket count if ($timeEntryForTicket) { $entryRow = DB::select(DB::raw("SELECT te.time as time\n FROM `ticket_time_entries` AS tte\n LEFT JOIN `time_entries` AS te ON te.id = tte.`time_entry_id`\n WHERE tte.`time_entry_id` = :timeEntryId"), ['timeEntryId' => $trackerId]); $timeToSub = $entryRow[0]->time; DB::update("UPDATE tickets SET time_spend = time_spend - :time WHERE id = :id", ['time' => $timeToSub, 'id' => $timeEntryForTicket->id]); DB::table('ticket_time_entries')->where('time_entry_id', $trackerId)->delete(); } $entry->delete(); DB::table('time_entry_estimates')->where('time_entry_id', $entry->id)->delete(); DB::table('taggables')->where('taggable_id', $entry->id)->where('taggable_type', 'timeentry')->delete(); }