function set_session()
{
$user_id = Sentinel::getUser()->getUserId();
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$result = $mysqli->query("SELECT `file_path` FROM `mivtzoim_user_files` WHERE `mivtzoim_user_id` = {$user_id}");
if ($result) {
$_SESSION["file_path"] = $result->fetch_array(MYSQLI_ASSOC)["file_path"];
}
}
public function compose(View $view)
{
$array_task = [];
$array_alert = [];
$array_notification = [];
$tasks_count = 0;
$alerts_count = 0;
$notifications_count = 0;
//menus
$packages = Package::with('modules')->get();
//datas of the user logged
$userAuth = Sentinel::getUser();
$today = Carbon::now();
// tareas
$tasks = Task::where('user_id', '=', $userAuth->id)->orwhere('role_id', '=', $userAuth->roles[0]->id)->orderBy('created_at', 'DESC')->get();
foreach ($tasks as $task) {
if (is_null($task->read)) {
array_push($array_task, $task);
$tasks_count++;
} elseif (!in_array($userAuth->id, unserialize($task->read))) {
array_push($array_task, $task);
$tasks_count++;
}
}
// alertas
$alerts = Task::where('expire_time', '<', $today)->Where(function ($query) use($userAuth) {
$query->where('user_id', '=', $userAuth->id)->orwhere('role_id', '=', $userAuth->roles[0]->id);
})->with('hasAlert')->get();
foreach ($alerts as $alert) {
if (is_null($alert->hasAlert[0]->alert_display)) {
array_push($array_alert, $alert);
$alerts_count++;
} elseif (!in_array($userAuth->id, unserialize($alert->hasAlert[0]->alert_display))) {
array_push($array_alert, $alert);
$alerts_count++;
}
}
// notifications
$notifications = Notification::where('user_id', '=', $userAuth->id)->orwhere('role_id', '=', $userAuth->roles[0]->id)->get();
foreach ($notifications as $notification) {
if (is_null($notification->read)) {
array_push($array_notification, $notification);
$notifications_count++;
} elseif (!in_array($userAuth->id, unserialize($notification->read))) {
array_push($array_notification, $notification);
$notifications_count++;
}
}
$view->with(array('packages' => $packages, 'userAuth' => $userAuth, 'alerts' => $array_alert, 'alerts_count' => $alerts_count, 'notifications' => $array_notification, 'notifications_count' => $notifications_count, 'tasks' => $array_task, 'tasks_count' => $tasks_count));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
//
setlocale(LC_TIME, 'es_ES');
$user = Sentinel::getUser();
$task = Task::find($id);
$alerts = Alert::where('task_id', '=', $id)->first();
if (empty($alerts->alert_display)) {
$array_read[] = $user->id;
$alerts->alert_display = serialize($array_read);
$alerts->save();
} else {
$array_read = unserialize($alerts->alert_display);
if (!in_array($user->id, $array_read)) {
array_push($array_read, $user->id);
$alerts->alert_display = serialize($array_read);
$alerts->save();
}
}
return view('notifications.alerts.show', compact('task'));
}
public function __construct()
{
$this->auth = Sentinel::getUser();
}
<?php
require_once "../includes.php";
use Cartalyst\Sentinel\Native\Facades\Sentinel;
Sentinel::getUser();
$start = microtime(true);
if (!Sentinel::check()) {
$_SESSION["login_redirect"] = "/public_html/verify_columns.php";
header("location: /public_html/login.php");
die;
}
$parser = $initializer->columnify($_SESSION["file_path"]);
$columns_info = $parser->find();
$form_options = $parser->form_options;
$original_rows = $parser->original_rows;
$tablehead = "<thead><tr>";
// Creating table header (aka the verification form).
foreach ($columns_info as $name => $data) {
$options_copy = $form_options;
$position = $data["position"];
$yes_checked = $data["checkbox"]["yes_checked?"];
$no_checked = $data["checkbox"]["no_checked?"];
$should_hide = $data["checkbox"]["hidden?"];
$checkbox_text = $data["checkbox"]["text"];
$category = $data["category"];
if ($category != "unknown") {
// Deviding the current category from the rest of the options.
// The program will display these first.
$category_options = $options_copy[$category];
unset($category_options[$name]);
unset($options_copy[$category]);
public function complete($id)
{
$user = Sentinel::getUser();
$task = Task::find($id);
$now = Carbon::now();
$task->user_complete_id = $user->id;
$task->time_complete = $now;
if ($task->save()) {
// Ponemos alertas leidas, para que no aparescan cuando ya se completo una tarea
$alerts = Alert::where('task_id', '=', $id)->first();
if (empty($alerts->alert_display)) {
$array_read[] = $user->id;
} else {
$array_read = unserialize($alerts->alert_display);
if (!in_array($user->id, $array_read)) {
array_push($array_read, $user->id);
}
}
$alerts->alert_display = serialize($array_read);
$alerts->save();
return Redirect::to('tasks/tasks')->withSuccess('Tarea Completada');
}
}
public function __construct(User $model)
{
$this->user = $model;
$this->user_auth = Sentinel::getUser();
}
/**
* Bind data to the view.
*
* @param View $view
* @return void
*/
public function compose(View $view)
{
$getUser = Sentinel::getUser();
$view->with('getUser', $getUser);
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$user = Sentinel::getUser();
$notification = Notification::find($id);
if (is_null($notification->read)) {
$array_read[] = $user->id;
} else {
$array_read = unserialize($notification->read);
if (!in_array($user->id, $array_read)) {
array_push($array_read, $user->id);
}
}
$notification->read = serialize($array_read);
$notification->save();
return view('notifications.notifications.show', compact('notification'));
}
public static function past_results()
{
$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$chabad_id = Sentinel::getUser()->getUserId();
$chabad_data = array("new" => array(), "existing" => array());
$rounds = 0;
$true_val = 1;
$data_status = "new";
$text_status = "New Contact (Not in your spreadsheet)";
$zips = array();
while ($rounds < 2) {
$SQL = "SELECT * FROM `res_master_tmp` INNER JOIN `users_mivtzoim_data` ON res_master_tmp.`id` = users_mivtzoim_data.`res_master_tmp_id` WHERE users_mivtzoim_data.`users_id` = ? AND users_mivtzoim_data.`new_data?` = ?;";
if ($stmt = $mysqli->prepare($SQL)) {
$stmt->bind_param("ii", $chabad_id, $true_val);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
array_push($chabad_data[$data_status], array("first_name" => $row["first_name"], "last_name" => $row["last_name"], "address" => $row["address"], "zip" => $row["zip"], "jewishness" => $row["jewishness"], "result" => $text_status));
array_push($zips, $row["zip"]);
}
}
$stmt->close();
$rounds++;
$true_val = 0;
$data_status = "existing";
$text_status = "Not new Contact (already in your spreadsheet)";
}
$zips = array_values(array_unique($zips));
$zips = DataMerge::join_zips($zips);
return array($chabad_data, $zips);
}
