/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$data = $request->all();
$timeentry = new TimeEntry();
$timeentry->fill($data);
$timeentry->save();
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle(SendMailInterface $mail)
{
$timeEntryObj = new TimeEntry();
$users = $timeEntryObj->getPreviousDayTimeEntry();
if (!empty($users)) {
$this->sendEmail($mail, $users);
}
}
public function downloadReport()
{
Excel::create('Timesheet_Report_' . time(), function ($excel) {
$timeEntryObj = new TimeEntry();
$timeEntries = $timeEntryObj->getManagerTrackerReport();
$data = [];
foreach ($timeEntries as $entry) {
$data[] = ['description' => $entry->description, 'time' => $entry->time, 'username' => $entry->username, 'projectName' => $entry->projectName, 'clientName' => $entry->clientName, 'tags' => $entry->tags];
}
$excel->sheet('Sheet 1', function ($sheet) use($data) {
$sheet->fromArray($data);
});
})->download('xls');
}
public function getClockedStatus()
{
$currentUserID = Auth::user()->id;
$timeentry = new TimeEntry();
$clockedIn = $timeentry->where('user_id', '=', $currentUserID)->orderby('time', 'desc')->first();
if ($clockedIn != null) {
if ($clockedIn->type === 'In') {
return array('clockedIn' => 'true');
} elseif ($clockedIn->type === 'Out') {
return array('clockedIn' => 'false');
}
} elseif ($clockedIn === null) {
return array('clockedIn' => 'false');
}
}
public function run()
{
$time_entries = array(['user_id' => 1, 'start_time' => '2015-02-21T18:56:48Z', 'end_time' => '2015-02-21T20:33:10Z', 'comment' => 'Initial project setup.'], ['user_id' => 1, 'start_time' => '2015-02-27T10:22:42Z', 'end_time' => '2015-02-27T14:08:10Z', 'comment' => 'Review of project requirements and notes for getting started.'], ['user_id' => 1, 'start_time' => '2015-03-03T09:55:32Z', 'end_time' => '2015-03-03T12:07:09Z', 'comment' => 'Front-end and backend setup.']);
foreach ($time_entries as $time_entry) {
TimeEntry::create($time_entry);
}
}
public function run()
{
DB::table('time_entries')->delete();
$time_entries = array(['user_id' => 1, 'start_time' => '2015-02-21 18:56:48', 'end_time' => '2015-02-21 20:33:10', 'comment' => 'Initial project setup.'], ['user_id' => 2, 'start_time' => '2015-02-27 10:22:42', 'end_time' => '2015-02-27 14:08:10', 'comment' => 'Review of project requirements and notes for getting started.'], ['user_id' => 3, 'start_time' => '2015-03-03 09:55:32', 'end_time' => '2015-03-03 12:07:09', 'comment' => 'Front-end and backend setup.']);
foreach ($time_entries as $time_entry) {
TimeEntry::create($time_entry);
}
}
public function run()
{
DB::table('time_entries')->delete();
$time_entries = array(['user_id' => 21, 'start_time' => '2015-02-21T18:56:48Z', 'end_time' => '2015-02-21T20:33:10Z', 'comment' => 'Comment Test 1.'], ['user_id' => 22, 'start_time' => '2015-02-27T10:22:42Z', 'end_time' => '2015-02-27T14:08:10Z', 'comment' => 'Comment Test 2.'], ['user_id' => 23, 'start_time' => '2015-03-03T09:55:32Z', 'end_time' => '2015-03-03T12:07:09Z', 'comment' => 'Comment Test 3.']);
foreach ($time_entries as $time_entry) {
TimeEntry::create($time_entry);
}
}
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 allowRequestBackdateEntry(Request $request, SendMailInterface $mail)
{
// return $request->all();
$date = Carbon::parse($request->input('date'));
$userIds = $request->input('users');
$data = [];
foreach ($userIds as $id) {
$otp = uniqid();
// create the data
$data[] = ['user_id' => Auth::user()->id, 'project_manager_id' => $id, 'backdate' => $date, 'otp' => $otp];
// add the backdate entry
$requestBackdateId = DB::table('backdate_requests')->insertGetId(['user_id' => Auth::user()->id, 'project_manager_id' => $id, 'backdate' => $date, 'otp' => $otp]);
// make an entry if the comment is added
if ($request->input('comment')) {
$comment = Comment::create(['user_id' => Auth::user()->id, 'comment' => $request->input('comment'), 'parent_id' => 0, 'thread' => '', 'status' => 1]);
DB::table('commentables')->insert(['comment_id' => $comment->id, 'commentable_id' => $requestBackdateId, 'commentable_type' => 'backdate_request']);
}
}
// send the email to each developer
foreach ($data as $entry) {
$user = User::find($entry['project_manager_id']);
$comment = '';
if ($request->input('comment')) {
$comment = $request->input('comment');
}
$mail->mail(['from' => '*****@*****.**', 'fromName' => 'Amitav Roy', 'to' => $user->email, 'toName' => $user->name, 'subject' => 'Request backdate entry', 'mailBody' => view('mails.backdate-mail', compact('entry', 'comment'))]);
}
$timeEntryObj = new TimeEntry();
$request_backdate_entries = $timeEntryObj->getLatestRequestBackdateTimeEntries();
return response($request_backdate_entries, 200);
}
public function createPieChart($sdate, $edate)
{
$timeEntryObj = new TimeEntry();
$timeEntries = $timeEntryObj->getProjectWiseReport($sdate, $edate);
$data = [];
$cnt = 0;
$pie = new PieGraph();
foreach ($timeEntries as $entry) {
$time_arr[] = $entry->totalTime;
$pname_arr[] = $entry->projectName;
$color_arr[] = $pie->random_color();
}
$pie->setImage(200, 100, $time_arr);
// colors for the data
$color_arr = ["#ff0000", "#ff8800", "#0022ff", "#989898", "#6600CC", "#FF0000 ", "#660066", "#CCFF00", "#FF0099", "#33ff99", "#33ff11"];
$pie->setColors($color_arr);
// legends for the data
$pie->setLegends($pname_arr);
// Display creation time of the graph
$pie->DisplayCreationTime();
// Height of the pie 3d effect
$pie->set3dHeight(15);
// Display the graph
$pie->display();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$timeEntry = TimeEntry::find($id);
$timeEntry->delete();
}
/**
*
* @param Request $request
* @return mixed
*/
public function getFilterReport(Request $request)
{
$timeEntryObj = new TimeEntry();
return $timeEntryObj->getManagerTrackerReport();
}
/**
* Show the application welcome screen to the user.
*
* @return Response
*/
public function index()
{
$time = TimeEntry::with('visitor')->get();
return $time;
}
public function addWeeklyReport()
{
$user = Auth::user();
$role = User::roles();
$user_role = $role[0]->role;
$now = Carbon::now();
$now1 = clone $now;
$now2 = clone $now;
$monday = $now->startOfWeek();
$friday = $now1->startOfWeek()->addDay(4);
//$endOfWeek = $now->endOfWeek();
$timeEntryObj = new TimeEntry();
$timeEntries = $timeEntryObj->getDaysUserFilledTimesheetInWeek($monday, $friday, $user->id);
$weekly_report = WeeklyReportEntry::where('user_id', $user->id)->paginate(20);
$data['user_id'] = $user->id;
$data['user_name'] = $user->name;
$data['week'] = $now2->weekOfMonth < 10 ? '0' . $now2->weekOfMonth : $now2->weekOfMonth;
$data['start'] = $monday->format('M d');
$data['start_of_week'] = $monday->format('Y-m-d');
$data['end'] = $friday->format('M d');
$data['end_of_week'] = $friday->format('Y-m-d');
$data['days_worked'] = $timeEntries[0]->cnt;
$data['weekly_report'] = $weekly_report;
return view('manager.create-weekly-report', compact('data'));
}
/**
* Sync offline entries to online
*/
public function syncTimesheets(Request $request)
{
$post_data = $request->input();
// \Log::info(print_r($post_data, true));
foreach ($post_data as $tData) {
$uid = $tData['uid'];
if (!$tData['status']) {
$already_saved = 0;
if (isset($tData['id'])) {
$already_saved = TimeEntry::where('id', '=', $tData['id'])->count();
if ($already_saved && $tData['deleted']) {
TimeEntry::where('id', '=', $tData['id'])->delete();
}
}
if ($already_saved) {
} else {
if (!$tData['deleted']) {
$timesheet = $this->saveTimesheet($tData);
}
}
}
}
// \Log::info(print_r($this->getUserTimeEntries($uid), true));
$output = $this->getUserTimeEntries($uid);
return response($output, 201);
}
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();
}
