public function testActivityCanBeAddedToAnEvent1()
{
$this->logIn();
$event = new Event();
$event->name = 'Kokous';
$event->time = '2016-07-25 16:40:00';
$event->place = 'Kolo';
$event->description = 'Iltakokous';
$event->endDate = '2016-07-25 17:20:20';
$event->group_id = self::createTestGroup();
$event->save();
$activity = new Activity();
$activity->name = 'Kalastus';
$activity->guid = 'Guid';
$activity->age_group = 'sudenpennut';
$activity->task_group = 'pohjoinen';
$activity->save();
$event_id = DB::table('events')->where('name', 'Kokous')->value('id');
// Pitää muutta occurensejä käyttämään
/* $this->visit('/events/'. $event_id)
->click('Muuta aktiviteetteja')
->see('Äänestys')
->press('Lisää')
->click('Takaisin')
->see('Äänestys'); */
}
public function processForm(Request $request)
{
$this->validate($request, ['date' => 'required|date']);
$car_id = $request->input('car');
$date = $request->input('date');
$type = $request->input('type');
$activity = new Activity();
$carbon_date = Carbon\Carbon::createFromFormat('m/d/Y', $date);
// dd($carbon_date->format('Y-m-d'));
$activity->date = $carbon_date->format('Y-m-d');
$activity->car_id = $car_id;
$activity->save();
$activities = Activity::orderBy('created_at', 'desc')->take(10)->get();
Session::put('activity', $activity);
if ($type == '1') {
return redirect()->route('process.ondayForm');
} else {
if ($type == '2') {
return redirect()->route('process.maintenanceForm');
// return view('home', [ 'type'=> '2', 'activity' => $activity, 'activities' => $activities]);
} else {
if ($type == '3') {
//nil
return redirect()->route('process.nilForm');
} else {
//error
}
}
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$notify_report = false;
for ($i = 0; $i < count($request->all()); $i++) {
if ($request->input($i . '.include')) {
$this->validate($request, [$i . '.id' => 'required', $i . '.member.id' => 'required|numeric', $i . '.position_id' => 'required|numeric', $i . '.project_id' => 'required|numeric', $i . '.target_id' => 'required|numeric', $i . '.output' => 'required|numeric', $i . '.date_start' => 'required|date', $i . '.date_end' => 'required|date', $i . '.hours_worked' => 'required|numeric', $i . '.daily_work_hours' => 'required|numeric', $i . '.output_error' => 'required|numeric']);
// check if a report is already created
if (!$notify_report) {
$admin = User::where('role', 'admin')->first();
$report = Report::where('id', $request->input($i . '.report_id'))->first();
// create a notification
$notification = new Notification();
$notification->message = 'updated a ';
$notification->sender_user_id = $request->user()->id;
$notification->receiver_user_id = $admin->id;
$notification->subscriber = 'admin';
$notification->state = 'main.weekly-report';
$notification->event_id = $report->id;
$notification->event_id_type = 'report_id';
$notification->seen = false;
$notification->save();
$notify = DB::table('reports')->join('users', 'users.id', '=', 'reports.user_id')->join('projects', 'projects.id', '=', 'reports.project_id')->join('notifications', 'notifications.event_id', '=', 'reports.id')->select('reports.*', 'users.*', DB::raw('LEFT(users.first_name, 1) as first_letter'), 'projects.*', 'notifications.*')->where('notifications.id', $notification->id)->first();
// foreach ($query as $key => $value) {
// $notify = $value;
// }
event(new ReportSubmittedBroadCast($notify));
$activity_type = ActivityType::where('action', 'update')->first();
$activity = new Activity();
$activity->report_id = $report->id;
$activity->user_id = $request->user()->id;
$activity->activity_type_id = $activity_type->id;
$activity->save();
// report
$create_report = true;
}
$old_performance = Performance::where('id', $request->input($i . '.id'))->first();
// record history of the performance
$performance_history = new PerformanceHistory();
$performance_history->activity_id = $activity->id;
$performance_history->performance_id = $old_performance->id;
$performance_history->report_id = $old_performance->report_id;
$performance_history->member_id = $old_performance->member_id;
$performance_history->position_id = $old_performance->position_id;
$performance_history->department_id = $old_performance->department_id;
$performance_history->project_id = $old_performance->project_id;
$performance_history->target_id = $old_performance->target_id;
$performance_history->date_start = $old_performance->date_start;
$performance_history->date_end = $old_performance->date_end;
$performance_history->daily_work_hours = $old_performance->daily_work_hours;
$performance_history->output = $old_performance->output;
$performance_history->hours_worked = $old_performance->hours_worked;
$performance_history->output_error = $old_performance->output_error;
$performance_history->average_output = $old_performance->average_output;
$performance_history->productivity = $old_performance->productivity;
$performance_history->quality = $old_performance->quality;
$performance_history->quadrant = $old_performance->quadrant;
$performance_history->save();
}
}
}
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
Task::created(function ($task) {
$activity = new Activity();
$activity->user_id = Auth::user()->id;
$activity->task_id = $task->id;
$activity->message = 'task created';
$activity->save();
});
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$item = new Activity();
$item->status = "active";
$item->name = $request->input("name");
$item->code = $request->input("code");
$item->save();
Log::create(array("user_id" => Auth::user()->id, "action" => "Add Activities named " . $item->name));
return $item;
}
private static function pullDataForProvider($provider)
{
foreach ($provider->providesSensors() as $name => $type) {
$functionName = self::getFunctionName($name, $type);
$val = $provider->{$functionName}();
$activity = new Activity();
$activity->provider = get_class($provider);
$activity->name = $name;
$activity->value = $val;
$activity->save();
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Requests\ActivityCreateRequest $request)
{
$data = $request->all();
$validator = Validator::make($request->all(), $request->rules(), $request->messages());
if ($validator->valid()) {
$activity = new Activity();
$activity->name = $data['name'];
$activity->name_small = $data['name_small'];
$activity->save();
$act = Activity::find($activity->id);
return response()->json(['valid' => true, 'act' => $act], 200);
}
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
//
$v = Validator::make(Request::all(), ['activity' => 'required|max:50|unique:activities', 'desc' => 'required|max:100']);
if ($v->fails()) {
return redirect()->back()->withErrors($v->errors())->withInput();
} else {
$activity = new Activity();
$activity->activity = Request::get('activity');
$activity->desc = Request::get('desc');
$activity->save();
return redirect('activities');
}
}
public function testActivityIsAddedToUserCorrectly()
{
$this->logIn();
$user = new User();
$user->membernumber = '100000';
$user->firstname = 'First_name';
$user->lastname = 'Last_name';
$user->save();
$activity = new Activity();
$activity->guid = 1;
$activity->name = 'Activity 1';
$activity->age_group = 'sudenpennut';
$activity->task_group = 'pohjoinen';
$activity->save();
$this->visit('/users/1/activities')->select('1', 'activityId')->press('Lisää')->seeInDatabase('activity_user', ['activity_id' => 1, 'user_id' => 1]);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(Request $request)
{
$this->validate($request, ['title' => 'required|unique:pages|max:255', 'starttime' => 'required', 'endtime' => 'required', 'place' => 'required', 'organizer' => 'required', 'tel' => 'required', 'requirement' => 'max:255']);
$activity = new Activity();
$activity->title = Input::get('title');
$activity->starttime = Input::get('starttime');
$activity->endtime = Input::get('endtime');
$activity->place = Input::get('place');
$activity->organizer = Input::get('organizer');
$activity->tel = Input::get('tel');
$activity->email = Input::get('email');
$activity->requirement = Input::get('requirement');
$activity->detail = Input::get('detail');
//$activity->user_id = 1;//Auth::user()->id;
if ($activity->save()) {
return Redirect::to('activity');
} else {
return Redirect::back()->withInput()->withErrors('保存失败！');
}
}
public function reportDelete(Request $request, $id)
{
$activity_type = ActivityType::where('action', 'delete')->first();
$activity = new Activity();
$activity->report_id = $id;
$activity->user_id = $request->user()->id;
$activity->activity_type_id = $activity_type->id;
$activity->save();
$admin = User::where('email', '*****@*****.**')->first();
$notification = new Notification();
$notification->receiver_user_id = $admin->id;
$notification->sender_user_id = $request->user()->id;
$notification->subscriber = 'admin';
$notification->message = 'deletes ';
$notification->state = 'main.activity';
$notification->event_id = $id;
$notification->event_id_type = 'report_id';
$notification->seen = false;
$notification->save();
$notify = DB::table('reports')->join('users', 'users.id', '=', 'reports.user_id')->join('projects', 'projects.id', '=', 'reports.project_id')->join('notifications', 'notifications.event_id', '=', 'reports.id')->select('reports.*', 'users.*', DB::raw('LEFT(users.first_name, 1) as first_letter'), 'projects.*', 'notifications.*')->where('notifications.id', $notification->id)->first();
event(new ReportSubmittedBroadCast($notify));
}
/**
* Store a newly created resource in storage.
*
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
if ($request->input('plant_id') == null) {
return response()->json("invalid", "500");
}
$user = User::where('username', '=', $request->input('username'))->first();
$activity = new Activity();
$activity->description = $request->input('description');
$activity->date = date("Y-m-d", strtotime($request->input('date')));
$activity->time = $request->input('time');
$activity->weather = $request->input('weather');
$activity->plant_id = $request->input('plant_id');
$typeActivity[] = $request->input('type');
$activity->save();
foreach ($typeActivity as $id) {
if ($id != "0") {
$activity->activityType()->attach($id);
}
}
if ($user != null) {
$activity->user()->attach($user->id);
}
return $activity;
}
public function recordActivity($event)
{
$model = strtolower(class_basename($this));
if ($event == "created") {
$activity = new Activity();
$activity->subject_id = $this->id;
$activity->subject_type = get_class($this);
$activity->name = $this->getActivityName($this, $event);
$activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
if ($model == "category") {
$activity->old_value = $this->name;
} elseif ($model == "information") {
$activity->old_value = $this->value;
} elseif ($model == "field") {
$activity->old_value = $this->category_label;
} elseif ($model == "devicelog") {
$activity->old_value = $this->action;
} elseif ($model == "owner") {
$activity->old_value = $this->fullName();
} else {
$activity->old_value = $this->name;
}
$activity->save();
} elseif ($event == "updates") {
if ($model == "category") {
$activity = new Activity();
$activity->subject_id = $this->id;
$activity->subject_type = get_class($this);
$activity->name = $this->getActivityName($this, $event);
$activity->old_value = $this->name;
$activity->new_value = Input::get('name');
$activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
$activity->save();
$this->name = Input::get('name');
$this->save();
} elseif ($model == "device") {
$activity = new Activity();
$activity->subject_id = $this->id;
$activity->subject_type = get_class($this);
$activity->name = $this->getActivityName($this, $event);
$activity->old_value = $this->name;
$activity->new_value = Input::get('phone_number');
$activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
$activity->save();
$this->phone_number = Input::get('name');
$this->save();
} elseif ($model == "information") {
foreach (Input::all() as $key => $value) {
if (strpos($key, 'info') !== false) {
$key = explode('-', $key);
$info_id = $key[1];
$activity = new Activity();
$information = Information::find($info_id);
$activity->subject_id = $information->id;
$activity->subject_type = get_class($information);
$activity->name = $information->getActivityName($information, $event);
$activity->old_value = $information->value;
$activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
$activity->save();
$information->value = $value;
$information->save();
$act = Activity::find($activity->id);
$act->new_value = $information->value;
$act->save();
}
}
}
} elseif ($event == "deleted") {
$activity = new Activity();
$activity->subject_id = $this->id;
$activity->subject_type = get_class($this);
$activity->name = $this->getActivityName($this, $event);
$activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
if ($model == "field") {
$activity->old_value = $this->category_label;
} elseif ($model == "information") {
$activity->old_value = $this->value;
} else {
$activity->old_value = $this->name;
}
$activity->save();
}
}
public function activities($num, $lead_id, $user_id)
{
$item = null;
for ($i = 0; $i < $num; $i++) {
$item = new Activity();
$item->name = $this->faker->word();
$item->lead_id = $lead_id;
$item->user_id = $user_id;
$item->note = $this->faker->text($this->faker->numberBetween(5, 500));
$item->type = $this->faker->randomElement($array = array('sales', 'elevation'));
$item->status = $this->faker->randomElement($array = array('done', 'scheduled'));
if ($item->status == 'scheduled') {
$item->schedule_time = $this->faker->dateTimeBetween($startDate = 'now', $endDate = '+1 week');
$action = 'scheduled';
} else {
$item->schedule_time = date("Y-m-d H:i:s", time());
$action = 'done';
}
$item->visible = $this->faker->numberBetween(0, 3);
$item->save();
$this->actions('activities', $action, $lead_id, $user_id, $this->faker->text(5));
}
}
public function modAdd()
{
$film = Input::get('film');
$user = Input::get('user');
$review = Input::get('review');
$vote = Input::get('vote');
$check = DB::table('film_review')->where('fr_usr_id', $user)->where('fr_fl_id', $film)->first();
if ($check) {
} else {
if (!$review == "") {
// inserts the review
$rev = new Review();
// revie instance
$rev->fr_fl_id = $film;
$rev->fr_usr_id = $user;
$rev->fr_review = $review;
$rev->fr_vote = $vote;
$rev->fr_date = \time();
$rev->save();
// saves review
// insert a new user actions
$act = new Activity();
// notification instance
$act->type_id = '2';
// activity type 2 for review
$act->subject_id = $user;
// id of the user
$act->object_type = 'film';
// type of object
$act->object_id = $film;
// id of the object
$act->action_date = \time();
// time of the activity
$act->save();
// saves activity
}
}
// gets the review details from the given id
$latest = DB::table('film_review')->where('fr_usr_id', $user)->orderBy('fr_id', 'desc')->first();
$user = user::find($user);
return view('reviews.add', compact('latest', 'user'));
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$create_report = false;
for ($i = 0; $i < count($request->all()); $i++) {
if ($request->input($i . '.include')) {
$this->validate($request, [$i . '.member.id' => 'required|numeric', $i . '.position_id' => 'required|numeric', $i . '.project_id' => 'required|numeric', $i . '.target_id' => 'required|numeric', $i . '.output' => 'required|numeric', $i . '.date_start' => 'required|date', $i . '.date_end' => 'required|date', $i . '.hours_worked' => 'required|numeric', $i . '.daily_work_hours' => 'required|numeric', $i . '.output_error' => 'required|numeric']);
// check if a report is already created
if (!$create_report) {
$admin = User::where('role', 'admin')->first();
$report = new Report();
$report->user_id = $request->user()->id;
$report->department_id = $request->user()->department_id;
$report->project_id = $request->input($i . '.project_id');
$report->daily_work_hours = $request->input($i . '.daily_work_hours');
$report->date_start = $request->input($i . '.date_start');
$report->date_end = $request->input($i . '.date_end');
$report->save();
// create a notification
$notification = new Notification();
$notification->message = 'submitted a ';
$notification->sender_user_id = $request->user()->id;
$notification->receiver_user_id = $admin->id;
$notification->subscriber = 'admin';
$notification->state = 'main.weekly-report';
$notification->event_id = $report->id;
$notification->event_id_type = 'report_id';
$notification->seen = false;
$notification->save();
$notify = DB::table('reports')->join('users', 'users.id', '=', 'reports.user_id')->join('projects', 'projects.id', '=', 'reports.project_id')->join('notifications', 'notifications.event_id', '=', 'reports.id')->select('reports.*', 'users.*', DB::raw('LEFT(users.first_name, 1) as first_letter'), 'projects.*', 'notifications.*')->where('notifications.id', $notification->id)->first();
// foreach ($query as $key => $value) {
// $notify = $value;
// }
event(new ReportSubmittedBroadCast($notify));
$activity_type = ActivityType::where('action', 'create')->first();
$activity = new Activity();
$activity->report_id = $report->id;
$activity->user_id = $request->user()->id;
$activity->activity_type_id = $activity_type->id;
$activity->save();
// report
$create_report = true;
}
// $target = Target::where('position_id', $request->input($i.'.position_id'))->where('experience', $request->input($i.'.experience'))->first();
$target = Target::withTrashed()->where('id', $request->input($i . '.target_id'))->first();
$performance = new Performance();
$performance->report_id = $report->id;
$performance->member_id = $request->input($i . '.member.id');
$performance->position_id = $request->input($i . '.position_id');
$performance->department_id = $request->user()->department_id;
$performance->project_id = $request->input($i . '.project_id');
$performance->target_id = $target->id;
$performance->output = round($request->input($i . '.output'), 2);
$performance->date_start = $request->input($i . '.date_start');
$performance->date_end = $request->input($i . '.date_end');
$performance->hours_worked = round($request->input($i . '.hours_worked'), 2);
$performance->daily_work_hours = $request->input($i . '.daily_work_hours');
$performance->output_error = round($request->input($i . '.output_error'), 2);
// Round((Output / Hours Worked) * Daily Work Hours)
// store the rounded value
$performance->average_output = round($request->input($i . '.output') / $request->input($i . '.hours_worked') * $request->input($i . '.daily_work_hours'), 2);
// average output / target output * 100 to convert to percentage
$performance->productivity = round($performance->average_output / $target->productivity * 100, 2);
// 1 - output w/error / output * 100 to convert to percentage
$performance->quality = round((1 - $performance->output_error / $performance->output) * 100, 2);
// Quadrant
if ($performance->productivity < 100 && $performance->quality >= $target->quality) {
$performance->quadrant = 'Quadrant 1';
} else {
if ($performance->productivity >= 100 && $performance->quality >= $target->quality) {
$performance->quadrant = 'Quadrant 2';
} else {
if ($performance->productivity >= 100 && $performance->quality < $target->quality) {
$performance->quadrant = 'Quadrant 3';
} else {
if ($performance->productivity < 100 && $performance->quality < $target->quality) {
$performance->quadrant = 'Quadrant 4';
}
}
}
}
// $performance->type = "weekly";
$performance->save();
// fetch target
// $productivity = Target::where('type', 'Productivity')->where('position_id', $request->input($i.'.position_id'))->where('experience', $request->input($i.'.experience'))->where('created_at', '<=', $request->input($i.'.date_end'))->orderBy('created_at', 'desc')->first();
// if(!$productivity)
// {
// $productivity = Target::where('type', 'Productivity')->where('position_id', $request->input($i.'.position_id'))->where('experience', $request->input($i.'.experience'))->first();
// }
// $quality = Target::where('type', 'Quality')->where('position_id', $request->input($i.'.position_id'))->where('experience', $request->input($i.'.experience'))->where('created_at', '<=', $request->input($i.'.date_end'))->orderBy('created_at', 'desc')->first();
// if(!$quality)
// {
// $quality = Target::where('type', 'Quality')->where('position_id', $request->input($i.'.position_id'))->where('experience', $request->input($i.'.experience'))->first();
// }
// $performance->productivity_id = $productivity->id;
// $performance->quality_id = $quality->id;
}
}
}
public function addLeadWithSelectedEntity(Request $request)
{
$lead = new Lead();
$lead->name = $request->name;
$lead->activity_setting = $request->setting;
$lead->active = 1;
$lead->progress = 0;
$lead->level = 0;
if ($request->next_action) {
$lead->next_action = Carbon::createFromFormat('m/d/Y g:i A', $request->next_action)->toDateTimeString();
} else {
$lead->next_action = null;
}
$lead->entity_id = $request->entity_id;
$lead->save();
$user = User::find($request->userId);
$user->leads()->attach($lead);
$account = Account::find($user->account_id);
$entity = Entity::find($request->entity_id);
$account->entities()->attach($entity);
$activity = new Activity();
$activity->lead_id = $lead->id;
$activity->user_id = $user->id;
$activity->type = 'info';
$activity->status = 'done';
$activity->name = 'Created';
$activity->visible = 1;
$activity->note = $request->note;
$activity->schedule_time = Carbon::now()->toDateTimeString();
$activity->save();
}
/**
*
* @param $request
* @return Response
*/
public function store(Request $request)
{
$activity = new Activity();
$activity->day_id = $request['day_id'];
$activity->start_time = $request['start_time'];
$activity->end_time = $request['typable_type'];
$activity->typable_id = $request['typable_id'];
$activity->save();
}
/**
* add to watchlist.
*
* @param int $id
* @return Response
*/
public function add()
{
$film_id = Input::get('film');
$check = $this->checkFav($film_id);
if ($check) {
} else {
$query = DB::table('user_fav')->insertGetId(array('fav_fl_id' => $film_id, 'fav_usr_id' => Auth::user()->id));
/// insert into the user actions
$act = new Activity();
// notification instance
$act->type_id = '5';
// activity type
$act->subject_id = Auth::user()->id;
// id of the user
$act->object_type = 'film';
// type of object
$act->object_id = $film_id;
// id of the object
$act->action_date = \time();
// time of the activity
$act->save();
// saves activity
if (Auth::user()->fb_access_token) {
// $fb = new FacebookController();
// $execute = $fb->postFbFavourite($film_id, Auth::user()->fb_uid, Auth::user()->fb_access_token);
}
}
if ($query) {
return 'true';
} else {
return 'false';
}
}
/**
* add to watchlist.
*
* @param int $id
* @return Response
*/
public function add()
{
$film_id = Input::get('film');
$query = DB::table('user_watchlist')->insertGetId(array('uw_fl_id' => $film_id, 'uw_usr_id' => Auth::user()->id));
// insert a new user actions
$act = new Activity();
// notification instance
$act->type_id = '3';
// activity type
$act->subject_id = Auth::user()->id;
// id of the user
$act->object_type = 'film';
// type of object
$act->object_id = $film_id;
// id of the object
$act->action_date = \time();
// time of the activity
$act->save();
// saves activity
if (Auth::user()->fb_access_token) {
// $fb = new FacebookController();
// $execute = $fb->postFbWatchlist($film_id, Auth::user()->fb_uid, Auth::user()->fb_access_token);
}
if ($query) {
return 'true';
} else {
return 'false';
}
}
