protected function monitor_core($from_secord, $to_secord)
{
$stepNum = Variables::getStepNum();
$period_secord = $from_secord - $to_secord;
$step_secord = (int) ($period_secord / $stepNum);
$now = time();
#_tp means time point.
$beforebefore_tp = $now - $from_secord;
$before_tp = $now - $to_secord;
$adjustdt = Adjust::period($beforebefore_tp, $before_tp);
$res = Variables::chartjs_line_one_inited_with_time($beforebefore_tp, $step_secord, $stepNum);
foreach ($adjustdt as $adj) {
$updated = $adj->updated;
#$updated = $adj['updated'];
$i = (int) (($updated - $beforebefore_tp - 10) / $step_secord);
if ($i == $stepNum) {
$i -= 1;
}
$res['datasets'][0]['data'][$i] += 1;
}
$res = json_encode($res);
$url = action('AdjustController@mstep', ['']);
return compact('res', 'from_secord', 'to_secord', 'url');
}
public function circle_core($from_secord, $to_secord)
{
$stepNum = Variables::getStepNum();
$period_secord = $from_secord - $to_secord;
$step_secord = (int) ($period_secord / $stepNum);
$now = time();
#_tp means time point.
$beforebefore_tp = $now - $from_secord;
$before_tp = $now - $to_secord;
$slist = AccountC::period($beforebefore_tp, $before_tp);
$res = Variables::chartjs_line_one_inited_with_time($beforebefore_tp, $step_secord, $stepNum);
foreach ($slist as $sone) {
$time = $sone['time'];
$i = (int) (($time - $beforebefore_tp - 10) / $step_secord);
$res['datasets'][0]['data'][$i] += 1;
}
$res = json_encode($res);
$url = action('AccountController@cstep', ['']);
return compact('res', 'from_secord', 'to_secord', 'url');
}
public function manage(Request $request)
{
#var_dump(Input::all());
$info = Variables::one('tasktype_prob_info');
$gain = Variables::one('tasktype_prob_gain');
$adjust_common = Variables::one('tasktype_prob_adjust_common');
$adjust_list = Variables::one('tasktype_prob_adjust_list');
$adjust_cheating = Variables::one('tasktype_prob_cheating');
$info_date = $info['time'];
$info = $info['value'];
$gain_date = $gain['time'];
$gain = $gain['value'];
$adjust_common_date = $adjust_common['time'];
$adjust_common = $adjust_common['value'];
$adjust_list_date = $adjust_list['time'];
$adjust_list = $adjust_list['value'];
$adjust_cheating_date = $adjust_cheating['time'];
$adjust_cheating = $adjust_cheating['value'];
$res = TaskController::dbtoview(compact('info', 'gain', 'adjust_common', 'adjust_list', 'adjust_cheating'));
$res['info_date'] = Carbon::createFromTimestamp($info_date, 'Europe/Zurich')->toDateTimeString();
$res['gain_date'] = Carbon::createFromTimestamp($gain_date, 'Europe/Zurich')->toDateTimeString();
$res['adjust_common_date'] = Carbon::createFromTimestamp($adjust_common_date, 'Europe/Zurich')->toDateTimeString();
$res['adjust_list_date'] = Carbon::createFromTimestamp($adjust_list_date, 'Europe/Zurich')->toDateTimeString();
$res['adjust_cheating_date'] = Carbon::createFromTimestamp($adjust_cheating_date, 'Europe/Zurich')->toDateTimeString();
return view('task.manage', $res);
}
/**
* Create a new user instance after a valid registration.
*
* @param array $data
* @return User
*/
public function create(array $data)
{
$estado = new Variables();
return User::create(['nom_usuario' => $data['nombres'], 'ape_usuario' => $data['apellidos'], 'num_identificacion' => $data['numero_identificacion'], 'tel_usuario' => $data['telefono_usuario'], 'cel_usuario' => $data['celular_usuario'], 'user_login' => $data['nombre_usuario'], 'email' => $data['correo_electronico'], 'password' => bcrypt($data['contrasenia']), 'estado_user' => $estado->UserEnVerificacion(), 'id_municipio' => $data['municipio'], 'id_tipo_secretaria' => $data['secretaria'], 'id_tipo_identificacion' => $data['tipo_identificacion'], 'id_cargo_usuario' => $data['cargo_usuario']]);
}
public function run()
{
$estado = new Variables();
User::create(['nom_usuario' => 'Juan Sebastian', 'ape_usuario' => 'Maya Narvaez', 'num_identificacion' => '1085293173', 'tel_usuario' => '7363301', 'cel_usuario' => '3147708366', 'user_login' => 'jumaya23', 'email' => '*****@*****.**', 'password' => \Hash::make('123456'), 'estado_user' => $estado->UserRegistrado(), 'id_municipio' => '1', 'id_tipo_secretaria' => '1', 'id_tipo_identificacion' => '1', 'id_cargo_usuario' => '1']);
}
public function errortype()
{
$paes = Variables::paerror();
ksort($paes);
return view('proxy.errortype', compact('paes'));
}
public function GestionRolesSearch()
{
$variable = new Variables();
$list_cargo = CargoUsuario::lists('nom_cargo', 'id');
$list_secretaria = Secretaria::lists('nombre_secretaria', 'id');
$list_municipio = Municipio::lists('nom_municipio', 'id');
$nom_usuario = \Input::get('nom_usuario');
$ape_usuario = \Input::get('ape_usuario');
$num_identificacion = \Input::get('num_identificaion');
$municipio = \Input::get('municipio');
$munCondition = "users.id_municipio = {$municipio}";
if ($municipio == 0) {
$munCondition = 'users.id_municipio';
}
$secretaria = \Input::get('secretaria');
$secCondition = "users.id_tipo_secretaria = {$secretaria}";
if ($secretaria == 0) {
$secCondition = 'users.id_tipo_secretaria';
}
$cargo = \Input::get('cargo');
$cargoCondition = "users.id_cargo_usuario = {$cargo}";
if ($cargo == 0) {
$cargoCondition = 'users.id_cargo_usuario';
}
if (\Auth::user()->level() == 5) {
$users = \DB::table('users')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'roles.id', '=', 'role_user.role_id')->select('users.id', 'users.nom_usuario', 'users.ape_usuario', 'roles.level', 'users.num_identificacion')->where('users.nom_usuario', 'LIKE', '%' . $nom_usuario . '%')->where('users.ape_usuario', 'LIKE', '%' . $ape_usuario . '%')->where('users.num_identificacion', 'LIKE', '%' . $num_identificacion . '%')->where('users.estado_user', '=', $variable->UserRegistrado())->whereNotIn('roles.level', array(1))->whereNotIn('users.id', array(\Auth::user()->id))->whereRaw($munCondition)->whereRaw($secCondition)->whereRaw($cargoCondition)->groupBy('users.id')->get();
}
if (\Auth::user()->level() == 4) {
$users = \DB::table('users')->join('role_user', 'users.id', '=', 'role_user.user_id')->join('roles', 'roles.id', '=', 'role_user.role_id')->select('users.id', 'users.nom_usuario', 'users.ape_usuario', 'users.num_identificacion')->where('users.nom_usuario', 'LIKE', '%' . $nom_usuario . '%')->where('users.ape_usuario', 'LIKE', '%' . $ape_usuario . '%')->where('users.num_identificacion', 'LIKE', '%' . $num_identificacion . '%')->where('users.estado_user', '=', $variable->UserRegistrado())->whereNotIn('roles.level', array(3, 5))->whereNotIn('users.id', array(\Auth::user()->id))->whereRaw($munCondition)->whereRaw($secCondition)->whereRaw($cargoCondition)->groupBy('users.id')->get();
}
return view('template.Gestion_Usuarios.search')->with('users', $users)->with('list_cargo', $list_cargo)->with('list_secretaria', $list_secretaria)->with('list_municipio', $list_municipio);
}
protected function chartjs_line_three_inited_with_timedist($one, $two, $three)
{
$secord_x = Variables::timedist();
$res = Variables::chartjs_line_three($one, $two, $three);
foreach ($secord_x as $key => $time) {
$hour = (int) ($time / 3600);
$minute = (int) ($time % 3600 / 60);
$secord = (int) ($time % 60);
if ($hour == 0) {
$hour = '';
} else {
$hour = (string) $hour . 'H';
}
if ($minute == 0) {
$minute = '';
} else {
$minute = (string) $minute . 'M';
}
if ($secord == 0) {
$secord = '';
} else {
$secord = (string) $secord . 'S';
}
$time = $hour . $minute . $secord;
$res['labels'][$key] = $time;
$res['datasets'][0]['data'][$key] = 0;
$res['datasets'][1]['data'][$key] = 0;
$res['datasets'][2]['data'][$key] = 0;
}
$res['labels'][count($secord_x)] = 'MORE';
$res['datasets'][0]['data'][count($secord_x)] = 0;
$res['datasets'][1]['data'][count($secord_x)] = 0;
$res['datasets'][2]['data'][count($secord_x)] = 0;
return $res;
}
protected function fixaccountrecord($from_secord, $to_secord)
{
$stepNum = Variables::getStepNum();
$period_secord = $from_secord - $to_secord;
$step_secord = (int) ($period_secord / $stepNum);
$now = time();
#_tp means time point.
$beforebefore_tp = $now - $from_secord;
$before_tp = $now - $to_secord;
$begin = array();
$success = array();
$error = array();
$ids = array();
$userset = array();
$slist = Account::period($beforebefore_tp, $before_tp);
foreach ($slist as $one) {
$id = $one['id'];
$username = $one['username'];
$code = $one['code'];
$time = $one['time'];
if (isset($userset[$username])) {
if ($code == -1) {
unset($userset[$username]);
} elseif ($code == 0) {
continue;
} else {
$error[$id] = array($time, $username);
unset($userset[$username]);
}
} else {
if ($code == -1) {
$begin[$username] = $time;
$ids[] = $id;
} elseif ($code == 0) {
$success[$username] = $time;
$ids[] = $id;
} else {
$userset[$username] = 1;
}
}
}
$beginlist = array();
foreach ($begin as $username => $time) {
$time = Variables::secordtoHMS($now - $time);
$one = "{$username}" . ' => ' . "{$time}";
if (isset($success[$username])) {
$time = Variables::secordtoHMS($now - $success[$username]);
$one .= ' (' . "{$time}" . ')';
}
$beginlist[] = $one;
}
$errorlist = array();
foreach ($error as $id => $one) {
$username = $one[1];
$time = Variables::secordtoHMS($now - $one[0]);
$errorlist[$id] = "{$username}" . ' => ' . "{$time}";
}
return compact('beginlist', 'errorlist', 'ids');
}
