/** * Run the migrations. * * @return void */ public function up() { $actions = Action::where('action', 'signed up')->get(); foreach ($actions as $action) { Signup::firstOrCreate(['campaign_id' => $action->campaign_id, 'contact_id' => $action->contact_id]); } }
public function search(Request $request) { $results = array(); $term = $request->get('term'); $goals = Goal::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get(); $objectives = Objective::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get(); $actions = Action::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get(); $tasks = Task::where('body', 'like', '%' . $term . '%')->orderBy('body', 'asc')->get(); $teams = Team::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get(); $departments = Department::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get(); $users = User::where('name', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get()->all(); foreach (User::where('email', 'like', '%' . $term . '%')->orderBy('name', 'asc')->get() as $matching_user_email) { if (in_array($matching_user_email, $users)) { continue; } $users[] = $matching_user_email; } $notes = Note::where('content', 'like', '%' . $term . '%')->orderBy('content', 'asc')->get(); $types = [$goals, $objectives, $actions, $tasks, $teams, $departments, $users, $notes]; foreach ($types as $type) { foreach ($type as $result) { $results[] = $result; } } return view('search.show')->with('results', $results)->with('term', $term); }
public function sendNotificationEmail(Group $group, User $user) { if ($user->verified == 1) { // Establish timestamp for notifications from membership data (when was an email sent for the last time?) $membership = \App\Membership::where('user_id', '=', $user->id)->where('group_id', "=", $group->id)->firstOrFail(); $last_notification = $membership->notified_at; // find unread discussions since timestamp $discussions = QueryHelper::getUnreadDiscussionsSince($user->id, $group->id, $membership->notified_at); // find new files since timestamp $files = \App\File::where('updated_at', '>', $membership->notified_at)->where('group_id', "=", $group->id)->get(); // find new members since timestamp $users = QueryHelper::getNewMembersSince($user->id, $group->id, $membership->notified_at); // find future actions until next 2 weeks, this is curently hardcoded... TODO use the mail sending interval to determine stop date $actions = \App\Action::where('start', '>', Carbon::now())->where('stop', '<', Carbon::now()->addWeek()->addWeek())->where('group_id', "=", $group->id)->orderBy('start')->get(); // we only trigger mail sending if a new action has been **created** since last notfication email. // BUT we will send actions for the next two weeks in all cases, IF a mail must be sent $actions_count = \App\Action::where('created_at', '>', $membership->notified_at)->where('group_id', "=", $group->id)->count(); // in all cases update timestamp $membership->notified_at = Carbon::now(); $membership->save(); // if we have anything, build the message and send // removed that : or count($users) > 0 // because we don't want to be notified just because there is a new member if (count($discussions) > 0 or count($files) > 0 or $actions_count > 0) { Mail::send('emails.notification', ['user' => $user, 'group' => $group, 'membership' => $membership, 'discussions' => $discussions, 'files' => $files, 'users' => $users, 'actions' => $actions, 'last_notification' => $last_notification], function ($message) use($user, $group) { $message->from(env('MAIL_NOREPLY', '*****@*****.**'), env('APP_NAME', 'Laravel'))->to($user->email)->subject('[' . env('APP_NAME') . '] ' . trans('messages.news_from_group_email_subject') . ' "' . $group->name . '"'); }); return true; } return false; } }
/** * Determine if the user is authorized to make this request. * * @return bool */ public function authorize() { $actionid = $this->route('id'); if (Auth::check()) { return Auth::user()->id == Action::find($actionid)->userId || User::find(Auth::id())->hasRole('bpLead') || User::find(Group::find(Action::find($actionid)->group)->user_ID)->id == Auth::id(); } else { return false; } }
public function remove(Objective $objective) { foreach ($objective->actions as $action) { foreach ($action->tasks as $task) { Task::destroy($task->id); } Action::destroy($action->id); } Objective::destroy($objective->id); return redirect('/plan'); }
public function index(Request $request) { if ($request->has('query')) { $query = $request->get('query'); // build a list of public groups and groups the user has access to $my_groups = Auth::user()->groups()->orderBy('name')->get(); $my_groups_id = []; // using this array we can adjust the queries after to only include stuff the user has // might be a good idea to find a clever way to build this array of groups id : foreach ($my_groups as $the_group) { $my_groups_id[$the_group->id] = $the_group->id; } $public_groups = \App\Group::where('group_type', \App\Group::OPEN)->get(); $public_groups_id = []; // using this array we can adjust the queries after to only include stuff the user has // might be a good idea to find a clever way to build this array of groups id : foreach ($public_groups as $the_group) { $public_groups_id[$the_group->id] = $the_group->id; } $allowed_groups = array_merge($my_groups_id, $public_groups_id); $groups = \App\Group::where('name', 'like', '%' . $query . '%')->orWhere('body', 'like', '%' . $query . '%')->orderBy('name')->get(); $users = \App\User::where('name', 'like', '%' . $query . '%')->orWhere('body', 'like', '%' . $query . '%')->orderBy('name')->with('groups')->get(); $discussions = \App\Discussion::where('name', 'like', '%' . $query . '%')->orWhere('body', 'like', '%' . $query . '%')->whereIn('group_id', $allowed_groups)->orderBy('updated_at', 'desc')->with('group')->get(); $actions = \App\Action::where('name', 'like', '%' . $query . '%')->orWhere('body', 'like', '%' . $query . '%')->whereIn('group_id', $allowed_groups)->with('group')->orderBy('updated_at', 'desc')->get(); $files = \App\File::where('name', 'like', '%' . $query . '%')->whereIn('group_id', $allowed_groups)->with('group')->orderBy('updated_at', 'desc')->get(); $comments = \App\Comment::where('body', 'like', '%' . $query . '%')->with('discussion.group')->orderBy('updated_at', 'desc')->get(); // set in advance which tab will be active on the search results page $groups->class = ''; $discussions->class = ''; $actions->class = ''; $users->class = ''; $comments->class = ''; $files->class = ''; // the order of those ifs should match the order of the tabs on the results view :-) if ($groups->count() > 0) { $groups->class = 'active'; } elseif ($discussions->count() > 0) { $discussions->class = 'active'; } elseif ($actions->count() > 0) { $action->class = 'active'; } elseif ($users->count() > 0) { $users->class = 'active'; } elseif ($comments->count() > 0) { $comments->class = 'active'; } elseif ($files->count() > 0) { $files->class = 'active'; } return view('search.results')->with('groups', $groups)->with('users', $users)->with('discussions', $discussions)->with('files', $files)->with('comments', $comments)->with('actions', $actions)->with('query', $query); } }
public function addAction(Request $request, Plan $plan) { if (isset($request->add)) { $newaction = Action::create($request->all()); $newaction->date = Carbon::createFromFormat("Y-m-d", $request->duedate)->toDateTimeString(); if (isset($request->collabs)) { $newaction->collaborators = implode("__,__", $request->collabs); } $newaction->save(); return view('plans.addactions')->with('plan', $plan); } else { return view('plans.addtasks')->with('plan', $plan); } }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { // $action = Action::find($id); //return $gender; if (count($action) > 0) { $statusCode = 200; $response = ['id' => $action->id, 'Action' => $action->action]; } else { $response = ["error" => "Action doesn`t exist"]; $statusCode = 404; } return response($response, $statusCode)->header('Content-Type', 'application/json'); }
public function remove(Goal $goal) { if ($goal->body == "Non-Business Plan") { return back(); } foreach ($goal->objectives as $objective) { foreach ($objective->actions as $action) { foreach ($action->tasks as $task) { Task::destroy($task->id); } Action::destroy($action->id); } Objective::destroy($objective->id); } Goal::destroy($goal->id); return redirect('/plan'); }
/** * Execute the console command. * * @return mixed */ public function handle() { // open csv file from storage $csv = Reader::createFromPath(storage_path('import/actions.csv')); //get the first row, usually the CSV header $headers = $csv->fetchOne(); // validate headers //get 25 rows starting from the 11th row $res = $csv->setOffset(1)->fetchAll(); // build a nice associative array from the csv foreach ($res as $data) { foreach ($headers as $key => $header) { $action[$header] = $data[$key]; } $actions_data[] = $action; } foreach ($actions_data as $action_data) { if (isset($action_data['id'])) { $action = \App\Action::firstOrNew(['id' => $action_data['id']]); $action->name = $action_data['name']; $action->body = $action_data['body']; $action->start = \Carbon\Carbon::parse($action_data['start']); $action->stop = \Carbon\Carbon::parse($action_data['stop']); $action->location = $action_data['location']; $action->user_id = 1; // create the group if not existing yet and associate it. if (!empty($action_data['group_id']) && !empty($action_data['group'])) { $group = \App\Group::firstOrNew(['id' => $action_data['group_id'] + $this->id_offset]); $group->name = $action_data['group']; $group->body = 'No description'; $group->save(); $action->group()->associate($group); $this->info($group->name . ' GROUP has been created/updated in db'); $action->save(); if ($action->isInvalid()) { $this->error($action->getErrors()); } else { $this->info($action->name . ' ACTION has been created/updated in db'); } } } } }
public function editTaskFromComments($id, Requests\EditTaskRequest $request) { $progress = ['0' => 'Not Started', '1' => 'In Progress', '2' => 'Done']; $model = new Task(); $task = Task::findOrFail($id); $groups = Group::lists('name', 'id'); $users = User::lists('name', 'id'); $bpid = $model->getBpIdFromTask($id); $action = Action::find($task->action_id)->description; $names = explode(', ', $task->collaborators); $selectedUsers = array(); $selectedGroups = array(); foreach ($names as $name) { if (count(User::all()->where('name', $name)) > 0) { array_push($selectedUsers, User::all()->where('name', $name)->first()->id); } if (count(Group::all()->where('name', $name)) > 0) { array_push($selectedGroups, Group::all()->where('name', $name)->first()->id); } } return view('editTaskComments', compact('task', 'action', 'groups', 'users', 'bpid', 'selectedUsers', 'selectedGroups', 'progress')); }
public function updateAction($id, Request $request) { $collabs = ""; $model = new Action(); $input = $request->all(); $actionComment = new ActionComments(); $comments = $actionComment->getComments($id); $action = Action::findOrFail($id); $users = array(); $roster = DB::table('rosters')->select('user_ID')->where('group_ID', '=', $action->group)->get(); foreach ($roster as $x) { array_push($users, $x->user_ID); } $groupLead = User::find(Group::find($action->group)->user_ID)->id; if (Auth::check()) { $user = User::find(Auth::id()); $permission = $user->hasRole('bpLead'); } else { $permission = false; } $businessplan = $model->getBpIdFromAction($id); if (array_key_exists('collaborators-groups', $input)) { foreach ($input['collaborators-groups'] as $x) { $collabs .= Group::find($x)->name; $collabs .= ", "; } } if (array_key_exists('collaborators-users', $input)) { foreach ($input['collaborators-users'] as $x) { $collabs .= User::find($x)->name; $collabs .= ", "; } } $collabs = rtrim($collabs, ", "); $input['collaborators'] = $collabs; $action->update($input); $tasks = Task::all()->where('action_id', $id); return view('action', compact('comments', 'action', 'tasks', 'users', 'permission', 'groupLead', 'businessplan')); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { // 1. Create new calendar $vCalendar = new \Eluceo\iCal\Component\Calendar(config('app.url')); $vCalendar->setName(config('mobilizator.name')); // returns actions from the last 60 days $actions = \App\Action::with('group')->where('start', '>=', Carbon::now()->subDays(60))->get(); foreach ($actions as $action) { // 2. Create an event $vEvent = new \Eluceo\iCal\Component\Event(); $vEvent->setDtStart($action->start); $vEvent->setDtEnd($action->stop); $vEvent->setSummary($action->name); $vEvent->setDescription(summary($action->body), 1000); $vEvent->setLocation($action->location); $vEvent->setUrl(action('ActionController@show', [$action->group->id, $action->id])); $vEvent->setUseUtc(false); //TODO fixme $vCalendar->addComponent($vEvent); } return response($vCalendar->render())->header('Content-Type', 'text/calendar; charset=utf-8')->header('Content-Disposition', 'attachment; filename="cal.ics"'); }
public function report($id) { $campaign = Campaign::find($id); $summary = []; $actions = Action::with('contact')->forCampaign($campaign)->orderBy('contact_id')->get(); $summary['total_sent'] = $campaign->emails->count(); $summary['opened'] = $actions->filter(function ($action) { return $action->action === 'opened'; })->count(); $summary['more info'] = $actions->filter(function ($action) { return $action->action === 'more info'; })->count(); $summary['website_visits'] = $actions->filter(function ($action) { return $action->action === 'website'; })->count(); $summary['skipped_video'] = $actions->filter(function ($action) { return $action->action === 'skipped'; })->count(); $summary['emailed_bill'] = $actions->filter(function ($action) { return $action->action === 'email'; })->count(); $summary['youtube_channel'] = $actions->filter(function ($action) { return $action->action === 'youtube'; })->count(); $summary['unsubscribed'] = Contact::where('unsubscribe', '=', 1)->count(); \Excel::create('Report', function ($excel) use($actions, $summary, $campaign) { $excel->setTitle("eMail Report for {$campaign->name}")->setCreator('Exhibit Partners Mailer Service')->setCompany('Exhibit Partners')->setDescription("A detailed report of email recipients for the {$campaign->name} email campaign"); $excel->sheet('Summary', function ($sheet) use($summary) { $sheet->row(1, ['Total', 'Opened', 'Went To Page 2', 'Website Visits', 'Skipped The Video', 'Emailed Bill', 'YouTube Channel', 'Unsubscribed']); $sheet->row(2, [$summary['total_sent'], $summary['opened'], $summary['more info'], $summary['website_visits'], $summary['skipped_video'], $summary['emailed_bill'], $summary['youtube_channel'], $summary['unsubscribed']]); }); $excel->sheet('Recipient Actions', function ($sheet) use($actions) { $sheet->row(1, ['Contact', 'Email', 'Action']); foreach ($actions as $key => $action) { $sheet->row($key + 2, [$action->contact->name, $action->contact->email, $action->action]); } }); })->download('xlsx'); }
public function touchActions($id) { $touch = Touch::find($id); $actions = Action::with('contact')->where('touch_id', '=', $touch->id)->orderBy('action')->orderBy('contact_id', 'DESC')->get(['action', 'contact_id']); $actions = array_map(function ($action) { foreach ($action['contact'] as $key => $value) { $action[$key] = $value; } unset($action['contact_id'], $action['id'], $action['contact'], $action['unsubscribe'], $action['client_id'], $action['updated_at'], $action['created_at'], $action['bounced']); return $action; }, $actions->toArray()); $metrics = Excel::create("{$touch->title} Metrics", function ($excel) use($touch, $actions) { $excel->setTitle("Email Metrics for {$touch->title}"); $excel->setCreator("EP-Productions"); $excel->setCompany('Exhibit Partners'); $excel->setDescription("Email metrics from an email campaign for {$touch->campaign}->client->name by Exhibit Partners"); $excel->sheet('Metrics', function ($sheet) use($actions) { $sheet->fromArray($actions); }); $excel->sheet('Bounces', function ($sheet) use($touch) { $bounces = $touch->bounces->toArray(); $bounces = array_map(function ($contact) { unset($contact['id'], $contact['client_id'], $contact['bounced'], $contact['unsubscribe'], $contact['updated_at'], $contact['created_at']); return $contact; }, $bounces); $sheet->fromArray($bounces); }); $excel->sheet('Unsubscribes', function ($sheet) use($touch) { $unsubscribes = $touch->unsubscribes->toArray(); $unsubscribes = array_map(function ($contact) { unset($contact['id'], $contact['client_id'], $contact['bounced'], $contact['unsubscribe'], $contact['updated_at'], $contact['created_at']); return $contact; }, $unsubscribes); $sheet->fromArray($unsubscribes); }); })->download('xlsx'); return $metrics; }
// Info user action $factory->defineAs(App\UserAction::class, 'info', function ($faker) use($factory) { $userAction = $factory->raw(\App\UserAction::class); $userAction['action_id'] = \App\Action::where('type', 'info')->first()->id; return $userAction; }); // Wrong format user action $factory->defineAs(\App\UserAction::class, 'wrong_format', function ($faker) use($factory) { $userAction = $factory->raw(\App\UserAction::class); $userAction['action_id'] = \App\Action::where('type', 'wrong_format')->first()->id; return $userAction; }); // Not allowed user action $factory->defineAs(\App\UserAction::class, 'not_allowed', function ($faker) use($factory) { $userAction = $factory->raw(\App\UserAction::class); $userAction['action_id'] = \App\Action::where('type', 'not_allowed')->first()->id; return $userAction; }); /** * Generate new offer. */ $factory->define(App\Offer::class, function ($faker) { $paymillOfferId = 'offer_' . substr(str_shuffle('0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'), 0, 20); return ['paymill_offer_id' => $paymillOfferId, 'name' => $faker->word(), 'amount' => rand(2, 9999), 'interval' => '1 MONTH', 'currency' => 'EUR']; }); // Generate notification type $factory->define(App\NotificationType::class, function ($faker) { return ['type' => $faker->numerify('rand_####'), 'name' => $faker->name()]; }); // Generate notification $factory->define(\App\Notification::class, function ($faker) {
@extends('layouts.app') @section('content') <div class="bs-example"> <div class="panel panel-primary"> <div class="panel-heading" style="background: #009FD7;"><h4 class="panel-title">{{ $team->name }}</h4></div> <div class="panel-body small-panel-body"> <table class="table table-bordered table-striped table-hover"> <th>Actions</th> <?php use App\Action; $actions = Action::where('owner', 'like', '%' . $team->name . '%')->get(); ?> @foreach($actions as $action) <tr> <td><a href="/actions/show/{{ $action->id }}">{{ $action->body }}</a></td> </tr> @endforeach <?php use App\Task; $tasks = Task::where('owner', 'like', '%' . $team->name . '%')->get(); ?> @if(count($tasks) > 0) <th>Tasks</th> @foreach($tasks as $task) <tr> <td><a href="/actions/show/{{ $task->id }}">{{ $task->body }}</a></td> </tr> @endforeach @endif
/** * Renders a map of all users (curently) */ public function map() { $users = \App\User::where('latitude', '<>', 0)->get(); $actions = \App\Action::where('start', '>=', Carbon::now())->where('latitude', '<>', 0)->get(); $groups = \App\Group::where('latitude', '<>', 0)->get(); // randomize users geolocation by a few meters foreach ($users as $user) { $user->latitude = $user->latitude + mt_rand(0, 10) / 10000; $user->longitude = $user->longitude + mt_rand(0, 10) / 10000; } return view('dashboard.map')->with('users', $users)->with('actions', $actions)->with('groups', $groups)->with('latitude', 50.8503396)->with('longitude', 4.3517103); }
function deleteAction($idbp, $id) { Action::findOrFail($id)->delete(); return; }
/** * Show the form for editing the specified Module. * @param int $id * @return Response */ public function edit($id) { if (!AuthcheckController::checkAuth(Sentinel::forceCheck(), ['module.update'], 'Modulos', 'alterar')) { return redirect()->back(); } else { $module = $this->moduleRepository->find($id); if (empty($module)) { Flash::error('Module not found'); return redirect(route('modules.index')); } $actions = \App\Action::all(); $actionb = \DB::table('action_module')->where('module_id', $id)->get(['action_id']); return view('modules.edit', compact('actions'), compact('actionb'))->with('module', $module); } }
public function actions($entity, $action, $entity_id, $user_id, $data = null) { $item = new Action(); $item->action = $action; $item->user_id = $user_id; $item->entity = $entity; $item->type = 'info'; $item->data = $data; $item->save(); }
/** * @param \App\Offer $offer */ public function logBuy(\App\Offer $offer) { $action = \App\Action::where('title', '=', 'buy_offer')->get()->first(); $this->UserModel->actions()->attach($action->id, ['points' => $action->point, 'offer_id' => $offer->id]); $this->levelUpIfPossible(); }
public function explicitrf_function(SignalsRequest $request) { $username = $request->username; $device = $request->device_id; $video_id = $request->video_id; $action_type = $request->action; $explicit_rf = $request->value; //check if $request->score==-1 or 0 or 1 $record_exists = UserAction::where('username', $username)->where('video_id', $video_id)->where('action', $action_type)->first(); if (empty($record_exists)) { $user_action = new UserAction(['username' => $username, 'device_id' => $device, 'video_id' => $video_id, 'explicit_rf' => $explicit_rf, 'action' => $action_type]); $user_action->save(); $get_importance = Action::where('id', $request->action)->first(); $importance = $get_importance->importance; $user_action->update(array('weight' => $explicit_rf, 'importance' => $importance)); } else { $record_exists->update(array('explicit_rf' => $explicit_rf, 'weight' => $explicit_rf)); } //store in the dcgs table - only used for the online experiments $mecanex_user = MecanexUser::where('username', $username)->first(); $dcg_record = Dcg::where('mecanex_user_id', $mecanex_user->id)->where('video_id', $video_id); $dcg_record->update(array('explicit_rf' => $explicit_rf)); //////////////calculate ku/////////////////////// // number of all enrichments $video = Video::where('video_id', $video_id)->first(); $num_all_enrichments = DB::select(DB::raw('SELECT COUNT(*) as num FROM enrichments_videos_time WHERE video_id=?'), [$video->id]); $num_all_enrichments = $num_all_enrichments[0]->num; // create list with clicked enrichments $get_action_id = Action::where('action', 'click enrichment')->first(); $action_id = $get_action_id->id; $enrichment_click_ids = UserAction::where('username', $username)->where('video_id', $video_id)->where('action', $action_id)->get(array('content_id')); $num_clicked_enrichments = count($enrichment_click_ids); // replace all database entries with one with the appropriate weight (so that the calculation can be easily done). // The information for what enrichments where clicked is now in the $enrichment_click_ids variable if ($num_clicked_enrichments != 0) { DB::table('user_actions')->where('username', $username)->where('video_id', $video_id)->where('action', $action_id)->delete(); $user_action = new UserAction(['username' => $username, 'device_id' => $device, 'video_id' => $video_id, 'action' => $action_id, 'content_id' => '1']); $user_action->save(); $get_importance = Action::where('id', $action_id)->first(); $importance = $get_importance->importance; $user_action->update(array('weight' => $num_clicked_enrichments / $num_all_enrichments, 'importance' => $importance)); } // create list with shared enrichments $get_action_id = Action::where('action', 'share')->first(); $action_id = $get_action_id->id; $enrichment_share_ids = UserAction::where('username', $username)->where('video_id', $video_id)->where('action', $action_id)->get(array('content_id')); $num_shared_enrichments = count($enrichment_share_ids); // replace all database entries with one with the appropriate weight (so that the calculation can be easily done). // The information for what enrichments where clicked is now in the $enrichment_shared_ids variable if ($num_shared_enrichments != 0) { DB::table('user_actions')->where('username', $username)->where('video_id', $video_id)->where('action', $action_id)->delete(); $user_action = new UserAction(['username' => $username, 'device_id' => $device, 'video_id' => $video_id, 'action' => $action_id, 'content_id' => '1']); $user_action->save(); $get_importance = Action::where('id', $action_id)->first(); $importance = $get_importance->importance; $user_action->update(array('weight' => $num_shared_enrichments / $num_all_enrichments, 'importance' => $importance)); } $k_nominator = UserAction::where('username', $username)->where('video_id', $video_id)->groupBy('username')->get(['username', DB::raw('SUM(importance*weight) as total_score')])->first(); $query = "SELECT SUM(t1.importance ) AS total FROM (SELECT DISTINCT action, importance FROM user_actions WHERE username=:username AND video_id=:videoid) AS t1 "; $k_denominator = DB::select(DB::raw($query), array('username' => $username, 'videoid' => $video_id)); //returns array $k = $k_nominator->total_score / $k_denominator[0]->total; //to [0] gia na prospelasei to 1o stoixeio tou array pou einai to object /////////////////////////////update weights and update profile////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////Retrieve Terms///////////////////////////// //////////////retrieve terms for given video////////////// $video = Video::where('video_id', $request->video_id)->first(); $threshold = 0; //need to appropriate set $results = $video->term()->where('video_score', '>', $threshold)->get(array('term_id')); $video_term_list = []; foreach ($results as $result) { //retrieve the terms that will be updated array_push($video_term_list, $result->term_id); } sort($video_term_list); ///////////retrieve terms for the clicked enrichments////////////// // $get_actionid = Action::where('action', 'click enrichment')->first(); // $action_id = $get_actionid->id; // $enrichment_ids = UserAction::where('username', $username)->where('video_id', $video_id)->where('action', $action_id)->get(array('content_id')); $enrichment_term_list = []; // foreach ($enrichment_ids as $enrichment_id) // { // // //call the api and get some terms // //or emulate enrichment_terms // //$results=Enrichment::where('id',$enrichment_id)->get(array('term_id')) // foreach($results as $result) // { // array_push($enrichment_term_list,$result->term_id); // } // // } //$enrichment_terms=array_unique($enrichment_term_list); $enrichment_terms = [3, 4, 7]; //retrieve terms for the clicked ads $ads_terms = [4, 8, 10]; ///Final term_list - no need since I will update in three steps // $term_list=array_merge($video_term_list,$enrichment_terms,$ads_terms); // $terms=array_unique($term_list); ////////////////update weights of profile////////////////////////// $term_scores = []; //save all scores to get the max $user = MecanexUser::where('username', $username)->get()->first(); $video = Video::where('video_id', $video_id)->get()->first(); $link_user = MecanexUserTermHomeTermNeighbour::where('mecanex_user_id', $user->id)->get()->first(); //return $video; //return $link_user; //update based on video_terms //return $video_term_list; foreach ($video_term_list as $video_term_id) { $temp_user = $user->term->find($video_term_id); $user_term_score = $temp_user->pivot->user_score; //get score of user $temp_video = $video->term->find($video_term_id); $video_term_score = $temp_video->pivot->video_score; //get score of video $final_score = $k * (0.8 * $video_term_score); foreach ($enrichment_click_ids as $enrichment_click_id) { $id = $enrichment_click_id->content_id; $enrichment = Enrichment::where('enrichment_id', $id)->get()->first(); $temp_enrichment = $enrichment->term->find($video_term_id); $enrichment_term_score = $temp_enrichment->pivot->enrichment_score; $final_score = $final_score + $k * (0.1 / $num_clicked_enrichments * $enrichment_term_score); } foreach ($enrichment_share_ids as $enrichment_share_id) { $id = $enrichment_share_id->content_id; $enrichment = Enrichment::where('enrichment_id', $id)->get()->first(); $temp_enrichment = $enrichment->term->find($video_term_id); $enrichment_term_score = $temp_enrichment->pivot->enrichment_score; $final_score = $final_score + $k * (0.1 / $num_shared_enrichments * $enrichment_term_score); } //update score $new_score = $user_term_score + $final_score; //ok $new_score = max($new_score, 0); // don't let negative values array_push($term_scores, $new_score); // //store score $user->term()->sync([$video_term_id => ['user_score' => $new_score]], false); } //return $term_scores; // update matrix $number_video_terms = count($video_term_list); $link_term_scores = []; //save all scores to get the max for ($i = 0; $i <= $number_video_terms - 1; $i++) { for ($j = $i + 1; $j < $number_video_terms; $j++) { $temp_user_matrix = MecanexUserTermHomeTermNeighbour::where('mecanex_user_id', $user->id)->where('term_home_id', $video_term_list[$i])->where('term_neighbor_id', $video_term_list[$j])->get()->first(); //return $temp_user_matrix; $temp_video = $video->term->find($video_term_list[$i]); $video_term_score1 = $temp_video->pivot->video_score; $temp_video = $video->term->find($video_term_list[$j]); $video_term_score2 = $temp_video->pivot->video_score; $final_score = $k * (0.8 * $video_term_score1 * $video_term_score2); foreach ($enrichment_click_ids as $enrichment_click_id) { $id = $enrichment_click_id->content_id; $enrichment = Enrichment::where('enrichment_id', $id)->get()->first(); $temp_enrichment = $enrichment->term->find($video_term_list[$i]); $enrichment_term_score1 = $temp_enrichment->pivot->enrichment_score; $temp_enrichment = $enrichment->term->find($video_term_list[$j]); $enrichment_term_score2 = $temp_enrichment->pivot->enrichment_score; $final_score = $final_score + $k * (0.1 / $num_clicked_enrichments * $enrichment_term_score1 * $enrichment_term_score2); } foreach ($enrichment_share_ids as $enrichment_share_id) { $id = $enrichment_share_id->content_id; $enrichment = Enrichment::where('enrichment_id', $id)->get()->first(); $temp_enrichment = $enrichment->term->find($video_term_list[$i]); $enrichment_term_score1 = $temp_enrichment->pivot->enrichment_score; $temp_enrichment = $enrichment->term->find($video_term_list[$j]); $enrichment_term_score2 = $temp_enrichment->pivot->enrichment_score; $final_score = $final_score + $k * (0.1 / $num_shared_enrichments * $enrichment_term_score1 * $enrichment_term_score2); } $new_score = $temp_user_matrix->link_score + $final_score; $new_score = max($new_score, 0); // don't let negative values array_push($link_term_scores, $new_score); $temp_user_matrix->link_score = $new_score; $temp_user_matrix->save(); } } //same should be done for enrichments and ads //find max value and divide term values $max_term_value = max(max($term_scores), 1); if ($link_term_scores != []) { $max_link_term_value = max(max($link_term_scores), 1); } foreach ($video_term_list as $video_term_id) { $temp_user = $user->term->find($video_term_id); $user_term_score = $temp_user->pivot->user_score; //get score of user $temp_video = $video->term->find($video_term_id); $video_term_score = $temp_video->pivot->video_score; //get score of video //update score $new_score = $user_term_score / $max_term_value; //ok //store score $user->term()->sync([$video_term_id => ['user_score' => $new_score]], false); } for ($i = 0; $i <= $number_video_terms - 1; $i++) { for ($j = $i + 1; $j < $number_video_terms; $j++) { $temp_user_matrix = MecanexUserTermHomeTermNeighbour::where('mecanex_user_id', $user->id)->where('term_home_id', $video_term_list[$i])->where('term_neighbor_id', $video_term_list[$j])->get()->first(); $old_score = $temp_user_matrix->link_score; $new_score = $old_score / $max_link_term_value; $temp_user_matrix->link_score = $new_score; $temp_user_matrix->save(); } } //calculate profile $terms = Term::all()->count(); for ($j = 1; $j <= $terms; $j++) { $profile_score = 0; for ($i = 1; $i <= $terms; $i++) { $temp_user = $user->term->find($i); $user_term_score = $temp_user->pivot->user_score; //get score of user if ($i == $j) { $link_score = 0; } elseif ($i > $j) { $temp_user_matrix = MecanexUserTermHomeTermNeighbour::where('mecanex_user_id', $user->id)->where('term_home_id', $j)->where('term_neighbor_id', $i)->get()->first(); $link_score = $temp_user_matrix->link_score; } else { $temp_user_matrix = MecanexUserTermHomeTermNeighbour::where('mecanex_user_id', $user->id)->where('term_home_id', $i)->where('term_neighbor_id', $j)->get()->first(); $link_score = $temp_user_matrix->link_score; } $profile_score = $profile_score + $user_term_score * $link_score; } $user->profilescore()->sync([$j => ['profile_score' => $profile_score]], false); } DB::table('user_actions')->where('username', $username)->where('video_id', $video_id)->delete(); $response = ["message" => 'RF Saved']; $statusCode = 200; return response($response, $statusCode)->header('Content-Type', 'application/json'); }
@extends('layouts.app') @section('content') <div class="bs-example"> <div class="panel panel-primary"> <div class="panel-heading" style="background: #009FD7;"><h4 class="panel-title">{{ $user->name }}</h4></div> <div class="panel-body"> <?php use App\Action; use App\Task; use App\Department; use App\Team; $user_stuff = array(); $user_stuff = array_merge($user_stuff, Action::where('lead', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Action::where('collaborators', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Task::where('lead', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Task::where('collaborators', 'like', '%' . $user->email . '%')->get()->all()); $user_stuff = array_merge($user_stuff, Department::where('name', 'like', '%' . $user->department . '%')->get()->all()); ?> <table class="table table-striped table-hover table-bordered table-responsive"> <tbody> @foreach($user_stuff as $item) <?php $result_class = str_replace("app\\", "", strtolower(get_class($item))); ?> <tr> <td><a href="/{{ $result_class }}s/show/{{ $item->id }}">{{ ucwords($result_class) }}: @if(!in_array($result_class, ["department", "team"])){{ $item->body }}@else{{ $item->name }}@endif</a></td> </tr>
public function MarkComplete(Action $action) { $action->status = "Completed"; $action->save(); foreach ($action->tasks as $task) { if ($task->status != "Completed") { $task->status = "Completed"; $task->save(); } } return back(); }
public function run() { DB::table('actions')->delete(); Action::create(['id' => '1', 'action' => 'play video', 'importance' => '10']); Action::create(['id' => '2', 'action' => 'stop video', 'importance' => '10']); Action::create(['id' => '3', 'action' => 'click enrichment', 'importance' => '10']); Action::create(['id' => '4', 'action' => 'click ad', 'importance' => '10']); Action::create(['id' => '5', 'action' => 'share', 'importance' => '10']); Action::create(['id' => '6', 'action' => 'explicit_rf', 'importance' => '20']); }
/** * Clears the given rule from all actions, action params and transformer mappings. * * @param Rule $rule */ private function clearRule(Rule $rule) { // delete all actions of rule // -> cascades down to actions_params Action::where("rule_id", $rule->rule_id)->delete(); // delete all transformer mappings of rule TransformerMapping::where("rule_id", $rule->rule_id)->delete(); }
@extends('layouts.app') @section('content') <div class="bs-example"> <div class="panel panel-primary"> <div class="panel-heading" style="background: #009FD7;"><h4 class="panel-title">{{ $department->name }}</h4></div> <div class="panel-body small-panel-body"> <table class="table table-bordered table-striped table-hover"> <th>Actions</th> <?php use App\Action; $actions = Action::where('owner', 'like', '%' . $department->name . '%')->get(); ?> @foreach($actions as $action) <tr> <td><a href="/actions/show/{{ $action->id }}">{{ $action->body }}</a></td> </tr> @endforeach <th>Tasks</th> <?php use App\Task; $tasks = Task::where('owner', 'like', '%' . $department->name . '%')->get(); ?> @foreach($tasks as $task) <tr> <td><a href="/actions/show/{{ $task->id }}">{{ $task->body }}</a></td> </tr> @endforeach <th>Users</th> <?php
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($project_id, $id) { $action = Action::find($id); $action->delete(); flash()->success('Action has been successfully deleted!'); return redirect()->action('ProjectsController@show', $project_id); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $campaign = Campaign::find($id); $actions = Action::where('campaign_id', '=', $campaign->id)->groupBy('action')->select(\DB::raw('count(contact_id) as count, action'))->orderBy('count', 'DESC')->get(); return view()->make('campaigns.show')->with(['campaign' => $campaign, 'actions' => $actions]); }