Exemplo n.º 1
0
 /**
  * Lists all time records constrained by given constraints
  *
  * @return void
  **/
 public function index()
 {
     $limit = $this->arguments->getOpt('limit', 20);
     foreach (Record::all()->limit($limit) as $record) {
         $line = '(' . $record->user->name . ') ' . $record->task->name . ': ' . $record->description;
         $this->output->addLine($line);
     }
 }
Exemplo n.º 2
0
 /**
  * Deletes a time record
  *
  * @apiMethod DELETE
  * @apiUri    /api/time/records/{id}
  * @apiParameter {
  * 		"name":        "id",
  * 		"description": "Record id",
  * 		"type":        "integer",
  * 		"required":    true,
  * 		"default":     null
  * }
  * @return  void
  */
 public function deleteTask()
 {
     // Require authentication and authorization
     $this->requiresAuthentication();
     $this->authorizeOrFail();
     // Create object and store content
     $record = Record::oneOrFail(Request::getInt('id'));
     if (!$record->isMine()) {
         App::abort(401, 'Unauthorized');
     }
     // Do the actual save
     if (!$record->destroy()) {
         App::abort(500, 'Record deletion failed');
     }
     // Return message
     $this->send('Record successfully deleted', 200);
 }
Exemplo n.º 3
0
 /**
  * Get summary of time for each person on each day of the week
  *
  * @return  void
  */
 public static function getTimeForWeeklyBar()
 {
     $records = Record::all();
     $records->select('user_id')->select('SUM(time)', 'time')->select('DATE_FORMAT(CONVERT_TZ(date, "+00:00", "' . Config::get('offset', '+00:00') . '"), "%Y-%m-%d")', 'day')->group('user_id')->group('day');
     $users = [User::get('id')];
     // Add extra users for proxies
     foreach (Proxy::whereEquals('proxy_id', User::get('id')) as $proxy) {
         $users[] = $proxy->user_id;
     }
     $records->whereIn('user_id', $users);
     // Get the day of the week
     $today = Date::of(Request::getVar('week', time()));
     $dateofToday = $today->format('Y-m-d');
     $dayOfWeek = $today->format('N') - 1;
     $records->having('day', '>=', Date::of(strtotime("{$dateofToday} - {$dayOfWeek}days"))->toLocal('Y-m-d'))->having('day', '<', Date::of(strtotime("{$dateofToday} + " . (7 - $dayOfWeek) . 'days'))->toLocal('Y-m-d'));
     $rows = $records->including('user')->rows();
     foreach ($rows as $row) {
         $row->set('user_name', $row->user->name);
     }
     echo json_encode($rows->toArray());
     exit;
 }
Exemplo n.º 4
0
 /**
  * Get time of each task
  *
  * @return void
  */
 public static function getTimePerTask()
 {
     $permissions = new Permissions('com_time');
     $hub_id = Request::getInt('hub_id', null);
     $task_id = Request::getInt('task_id', null);
     $start = Request::getCmd('start_date', Date::of(strtotime('today - 1 month'))->format('Y-m-d'));
     $end = Request::getCmd('end_date', Date::format('Y-m-d'));
     $tasks = Task::blank();
     $records = Record::all();
     $records = $records->select('SUM(time)', 'hours')->select($records->getQualifiedFieldName('id'))->select('task_id')->select($tasks->getQualifiedFieldName('name'))->join($tasks->getTableName(), 'task_id', $tasks->getQualifiedFieldName('id'))->where('date', '>=', Date::of($start . ' 00:00:00', Config::get('offset'))->toSql())->where('date', '<=', Date::of($end . ' 23:59:59', Config::get('offset'))->toSql())->order('hours', 'asc')->group('task_id');
     if (isset($task_id) && $task_id > 0) {
         $records->whereEquals('task_id', $task_id);
     } else {
         if (isset($hub_id) && $hub_id > 0) {
             $records->whereRelatedHas('task', function ($task) use($hub_id) {
                 $task->whereEquals('hub_id', $hub_id);
             });
         }
     }
     $summary = array();
     // Loop through and check permissions and grab raw object from rows
     foreach ($records->including('task') as $record) {
         if ($permissions->can('view.report', 'hubs', $record->task->hub_id)) {
             $summary[] = $record->toObject();
         }
     }
     echo json_encode($summary);
     exit;
 }
Exemplo n.º 5
0
 /**
  * Download CSV
  *
  * @return void
  */
 public static function download()
 {
     // Load language
     Lang::load('plg_time_csv', __DIR__);
     $hub_id = Request::getInt('hub_id', null);
     $start = Request::getCmd('start_date', Date::of(strtotime('today - 1 month'))->format('Y-m-d'));
     $end = Request::getCmd('end_date', Date::format('Y-m-d'));
     $records = Record::all()->where('date', '>=', $start)->where('date', '<=', Date::of(strtotime($end . ' + 1 day'))->format('Y-m-d'))->order('date', 'asc');
     if (isset($hub_id) && $hub_id > 0) {
         // @FIXME: is there a better way to do this?
         $records->whereIn('task_id', Task::select('id')->whereEquals('hub_id', $hub_id)->rows()->fieldsByKey('id'));
         $hubname = Hub::oneOrFail($hub_id)->name_normalized;
     }
     $all = true;
     foreach (Request::query() as $key => $value) {
         if (strpos($key, 'fields-') !== false) {
             $all = false;
         }
     }
     $filename = 'time_report';
     $filename .= isset($hubname) ? '_' . $hubname : '';
     $filename .= '_' . Date::of($start)->format('Ymd');
     $filename .= '-' . Date::of($end)->format('Ymd');
     $filename .= '.csv';
     // Set content type headers
     header("Content-type: application/csv");
     header("Content-Disposition: attachment; filename={$filename}");
     header("Pragma: no-cache");
     header("Expires: 0");
     $row = array();
     if ($hub = Request::getInt('fields-hub', $all)) {
         $row[] = Lang::txt('PLG_TIME_CSV_HUB');
     }
     if ($task = Request::getInt('fields-task', $all)) {
         $row[] = Lang::txt('PLG_TIME_CSV_TASK');
     }
     if ($user = Request::getInt('fields-user', $all)) {
         $row[] = Lang::txt('PLG_TIME_CSV_USER');
     }
     if ($date = Request::getInt('fields-date', $all)) {
         $row[] = Lang::txt('PLG_TIME_CSV_DATE');
     }
     if ($time = Request::getInt('fields-time', $all)) {
         $row[] = Lang::txt('PLG_TIME_CSV_TIME');
     }
     if ($description = Request::getInt('fields-description', $all)) {
         $row[] = Lang::txt('PLG_TIME_CSV_DESCRIPTION');
     }
     echo implode(',', $row) . "\n";
     $permissions = new Permissions('com_time');
     foreach ($records->including('task.hub', 'user') as $record) {
         if ($permissions->can('view.report', 'hub', $record->task->hub_id)) {
             $output = fopen('php://output', 'w');
             $row = array();
             if ($hub) {
                 $row[] = $record->task->hub->name;
             }
             if ($task) {
                 $row[] = $record->task->name;
             }
             if ($user) {
                 $row[] = $record->user->name;
             }
             if ($date) {
                 $row[] = Date::of($record->date)->toLocal();
             }
             if ($time) {
                 $row[] = $record->time;
             }
             if ($description) {
                 $row[] = $record->description;
             }
             fputcsv($output, $row);
             fclose($output);
         }
     }
     exit;
 }
Exemplo n.º 6
0
 /**
  * Saves a new time records, updating it if it alread exists
  *
  * @apiMethod POST
  * @apiUri    /time/postRecord
  * @apiParameter {
  * 		"name":        "id",
  * 		"description": "Record id",
  * 		"type":        "integer",
  * 		"required":    false,
  * 		"default":     null
  * }
  * @apiParameter {
  * 		"name":        "task_id",
  * 		"description": "Task ID of record",
  * 		"type":        "integer",
  * 		"required":    true,
  * 		"default":     null
  * }
  * @apiParameter {
  * 		"name":        "start",
  * 		"description": "Start date/time of record",
  * 		"type":        "string",
  * 		"required":    true,
  * 		"default":     null
  * }
  * @apiParameter {
  * 		"name":        "end",
  * 		"description": "End date/time of record",
  * 		"type":        "string",
  * 		"required":    true,
  * 		"default":     null
  * }
  * @apiParameter {
  * 		"name":        "description",
  * 		"description": "Record description",
  * 		"type":        "string",
  * 		"required":    false,
  * 		"default":     null
  * }
  * @return  void
  */
 public function postRecordTask()
 {
     // Require authentication and authorization
     $this->requiresAuthentication();
     $this->authorizeOrFail();
     // Incoming posted data (grab individually for added security)
     $r = [];
     $r['task_id'] = Request::getInt('task_id');
     $r['date'] = Date::of(Request::getVar('start'))->toSql();
     $r['end'] = Date::of(Request::getVar('end'))->toSql();
     $r['description'] = Request::getVar('description');
     $r['time'] = (strtotime($r['end']) - strtotime($r['date'])) / 3600;
     $r['user_id'] = App::get('authn')['user_id'];
     // Create object and store content
     $record = Record::oneOrNew(Request::getInt('id'));
     $update = false;
     // See if we have an incoming id, indicating update
     if (!$record->isNew()) {
         // Make sure updater is the owner of the record
         if (!$record->isMine()) {
             App::abort(401, 'You are only allowed to update your own records');
         }
         $update = true;
     }
     // Do the actual save
     if (!$record->set($r)->save()) {
         App::abort(500, 'Record creation failed');
     }
     // Return response
     $response = $update ? 'Record successfully saved' : 'Record successfully created';
     $status = $update ? 200 : 201;
     $this->send($response, $status);
 }
Exemplo n.º 7
0
 /**
  * Delete records
  *
  * @return void
  */
 public function deleteTask()
 {
     $record = Record::oneOrFail(Request::getInt('id'));
     // Only allow creator of the record to edit or delete
     if (!$record->isMine()) {
         // Set the redirect
         App::redirect(Route::url($this->base), Lang::txt('COM_TIME_RECORDS_WARNING_CANT_DELETE_OTHER'), 'warning');
         return;
     }
     // Delete record
     $record->destroy();
     // Set the redirect
     App::redirect(Route::url($this->base . $this->start($record)), Lang::txt('COM_TIME_RECORDS_DELETE_SUCCESSFUL'), 'passed');
 }