/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$id_lab = Session::get('id_lab');
$lab = Laboratorio::find($id_lab);
return view('area.muestra', array('laboratorio' => $lab));
//
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$id_lab = Session::get('id_lab');
$laboratorio = Laboratorio::find($id_lab);
$multas = LabMultaLaboratorio::where('id_laboratorio', $id_lab)->get();
return view('laboratorio.multas.multas', array('laboratorio' => $laboratorio, 'multas' => $multas));
}
function registrarPrestamo(Request $r)
{
$res = ['success' => false];
try {
$date = Carbon::now();
$prestamo = new LabPrestamoItem();
$prestamo->cve_solicitante = $r->input('cve_solicitante');
$prestamo->tipo_solicitante = $r->input('tipo_solicitante');
$prestamo->fecha_prestamo = $date;
$date->timezone("America/Mexico_City");
$invitem = InvItem::where('id_area', $r->input('id_area'))->where('codigo_lab', $r->input('codigo_lab'))->first();
if ($invitem) {
$prestamo->id_item = $invitem->id_item;
}
$prestamo->save();
$res['success'] = true;
$res['id_prestamo'] = $prestamo->id_prestamo;
} catch (Exception $e) {
$res['msj'] = $e->getMessage();
}
$id_lab = $r->input('id_lab');
$laboratorio = Laboratorio::find($id_lab);
$labAreas = LabArea::where('id_laboratorio', $id_lab)->lists('id_area');
$items = InvItem::whereIn('id_area', $labAreas)->lists('id_item');
$prestamos = LabPrestamoItem::whereIn('id_item', $items)->whereNull('fecha_entrega')->paginate(6);
return view('laboratorio.tablaPrestamos', array('prestamos' => $prestamos))->render();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$id_lab = Session::get('id_lab');
$laboratorio = Laboratorio::find($id_lab);
$labAreas = LabArea::where('id_laboratorio', $id_lab)->lists('id_area');
$mantenimientos = LabMantenimiento::whereIn('id_area', $labAreas)->get();
return view('laboratorio.controlEquipos.mantenimientos', array('laboratorio' => $laboratorio, 'mantenimientos' => $mantenimientos));
}
public function postLogin(Request $request)
{
//dd( $this->getCredentials($request) );
$this->validate($request, ['cve_uaslp' => 'required', 'password' => 'required']);
$credentials = $request->only('cve_uaslp', 'password');
$clave = $request->only('cve_uaslp');
$id_lab = LaboratorioBec::select('id_laboratorios')->where('clave_uaslp', $clave['cve_uaslp'])->lists('id_laboratorios')->first();
$lab = Laboratorio::find($id_lab);
//return $credentials;
if (Auth::attempt($credentials, $request->has('remember'))) {
//$_SESSION['laboratorio'] = $lab;
Session::put('laboratorio', $lab->laboratorio);
Session::put('clave', $clave['cve_uaslp']);
Session::put('id_lab', $id_lab);
return redirect()->intended($this->redirectPath());
//return view('laboratorio.index',array('laboratorio' => $lab));
}
return redirect($this->loginPath())->withInput($request->only('cve_uaslp', 'remember'))->withErrors(['cve_uaslp' => 'Las credenciales son incorrectas (Clave/Password).']);
}
function consultaPrestamo(Request $r)
{
$id_lab = Session::get('id_lab');
$fechaIni = $r->input('fechaIni');
$fechaFin = $r->input('fechaFin');
$nuevafecha = strtotime('+1 day', strtotime($fechaFin));
$fechaFin = date('Y-m-d', $nuevafecha);
$fechaIni = date_format(date_create($fechaIni), 'Y-m-d');
$fechaFin = date_format(date_create($fechaFin), 'Y-m-d');
$prestamos = null;
$laboratorio = Laboratorio::find($id_lab);
$labAreas = LabArea::where('id_laboratorio', $id_lab)->lists('id_area');
$entradas = "";
if ($r->input('op') == "equipo") {
$dato = $r->input('dato');
//$query = "SELECT count(`cve_alumno`) as `cant`,`cve_alumno` FROM `lab_entradas`,
// `alumnos` where `cve_alumno` = `clave_unica` group by (`clave_unica`) order by `cant` desc limit 5";
//select count(`cve_alumno`) as `cant` from `lab_entradas` inner join `alumnos` on `alumnos`.`clave_unica` = `lab_entradas`.`cve_alumno`
// where `id_area` in (1, 2, 3, 4, 5, 6) group by `cve_alumno` order by `cant` desc limit 4 offset 0
$item = InvItem::whereIn('id_area', $labAreas)->where('codigo_lab', 'LIKE', '%' . $dato . '%')->first();
$prestamos = LabPrestamoItem::where('id_item', $item->id_item)->where('fecha_prestamo', '>', $fechaIni)->where('fecha_prestamo', '<', $fechaFin)->get();
} else {
if ($r->input('op') == "clave") {
$clave = $r->input('dato');
$prestamos = LabPrestamoItem::where('cve_solicitante', 'LIKE', '%' . $clave . '%')->where('fecha_prestamo', '>=', $fechaIni)->where('fecha_prestamo', '<', $fechaFin)->get();
}
}
return view('laboratorio.tablaConsulta', array('prestamos' => $prestamos));
}
function nuevoEquipo($id_lab)
{
$lab = Laboratorio::find($id_lab);
return view('laboratorio.controlEquipos.inventario_nuevo', array('laboratorio' => $lab));
}
function consultaAlumno(Request $r)
{
$clave = $r->input('cve_alumno');
$id_lab = Session::get('id_lab');
$laboratorio = Laboratorio::find($id_lab);
$labAreas = LabArea::where('id_laboratorio', $id_lab)->lists('id_area');
$entradas = LabEntrada::whereIn('id_area', $labAreas)->where('cve_alumno', $clave)->paginate(10);
$id_lab = $r->input('id_lab');
$fechaIni = $r->input('fechaIni');
$fechaFin = $r->input('fechaFin');
$nuevafecha = strtotime('+1 day', strtotime($fechaFin));
$fechaFin = date('Y-m-d', $nuevafecha);
$fechaIni = date_format(date_create($fechaIni), 'Y-m-d');
$fechaFin = date_format(date_create($fechaFin), 'Y-m-d');
$laboratorio = Laboratorio::find($id_lab);
$labAreas = LabArea::where('id_laboratorio', $id_lab)->lists('id_area');
$entradas = "";
if ($r->input('op') == "frecuentes") {
$dato = $r->input('dato');
//$query = "SELECT count(`cve_alumno`) as `cant`,`cve_alumno` FROM `lab_entradas`,
// `alumnos` where `cve_alumno` = `clave_unica` group by (`clave_unica`) order by `cant` desc limit 5";
//select count(`cve_alumno`) as `cant` from `lab_entradas` inner join `alumnos` on `alumnos`.`clave_unica` = `lab_entradas`.`cve_alumno`
// where `id_area` in (1, 2, 3, 4, 5, 6) group by `cve_alumno` order by `cant` desc limit 4 offset 0
$entradas = LabEntrada::whereIn('id_area', $labAreas)->where('fecha_entrada', '>', $fechaIni)->where('fecha_entrada', '<', $fechaFin)->join('alumnos', 'alumnos.clave_unica', '=', 'lab_entradas.cve_alumno')->groupBy('cve_alumno')->orderBy('duracion', 'desc')->skip($dato)->take($dato)->get();
} else {
if ($r->input('op') == "clave") {
$clave = $r->input('dato');
$entradas = LabEntrada::whereIn('id_area', $labAreas)->where('cve_alumno', 'LIKE', '%' . $clave . '%')->where('fecha_entrada', '>', $fechaIni)->where('fecha_entrada', '<', $fechaFin)->get();
}
}
return view('laboratorio.controlAlumnos.tablaConsulta', array('laboratorio' => $laboratorio, 'entradas' => $entradas));
}
