public function index(Request $request, $slug, $date)
{
// Gets the query string from our form submission
$query = $request->rfc;
$intervaloPrimeravez = '["00:00", "00:00"]';
// Returns an array of articles that have the query string located somewhere within
// our articles titles. Paginates them so we can break up lots of search results.
$pacientes = Paciente::where('rfc', '=', $query)->get();
$pacientes->each(function ($pacientes) {
$pacientes->tipo;
});
$medico = Medico::findBySlug($slug);
$medico->especialidad;
$medico->horario;
$minutes = $medico->minutes ? $medico->minutes : 20;
$timeminutes = '+' . $minutes * 4 . ' minutes';
if (!\Auth::user()->admin()) {
$intervaloPrimeravez = '["' . $medico->horario->entrada . '","' . date('H:i', strtotime($timeminutes, strtotime($medico->horario->entrada))) . '"]';
}
$todas_citas = Cita::getTotalCitas($medico->id, $date);
$horas_usadas = Cita::where('fecha', '=', $date)->where('medico_id', '=', $medico->id)->lists('horario', 'id')->toArray();
$horas = array();
foreach ($horas_usadas as $hora) {
$horas[] = '["' . Carbon::createFromFormat('H:i', $hora)->toTimeString() . '","' . Carbon::createFromFormat('H:i', $hora)->addMinutes($minutes)->toTimeString() . '"]';
}
$horas = implode(",", $horas);
$entrada = $medico->horario->entrada;
$salida = $medico->horario->salida;
// returns a view and passes the view the list of articles and the original query.
return view('admin.citas.create')->with('pacientes', $pacientes)->with('medico', $medico)->with('date', $date)->with('todas_citas', $todas_citas)->with('horas', $horas)->with('entrada', $entrada)->with('salida', $salida)->with('intervaloPrimeravez', $intervaloPrimeravez)->with('minutes', $minutes);
}
function getRandomeStr($num)
{
$random_string = randString($num);
//dd($random_string);
$is_unique = false;
while (!$is_unique) {
$result = Cita::where('folio', '=', $random_string)->first();
if (!$result) {
// if you don't get a result, then you're good
$is_unique = true;
} else {
// if you DO get a result, keep trying
$random_string = randString($num);
}
}
return $random_string;
}
public function medicos_checkbox(Request $request)
{
$citas = Cita::where('fecha', '=', $request->date)->whereIn('medico_id', $request->medicos)->get();
$citas->each(function ($citas) {
$citas->codigo;
$citas->medico->especialidad;
$citas->paciente->tipo;
});
$citas = $citas->sortBy('horario')->groupBy('medico_id');
$mpdf = new mPDF('', 'Legal-L');
$header = \View('admin.reportes.header')->with('date', $request->date)->render();
$mpdf->SetFooter('Generado el: {DATE j-m-Y}| AgendaElectronica | ©' . date('Y') . ' ISSSTE BAJA CALIFORNIA');
$html = \View('admin.reportes.show')->with('citas', $citas)->with('date', $date)->render();
$pdfFilePath = 'Citas del ' . fecha_dmy($date) . '.pdf';
$mpdf->setAutoTopMargin = 'stretch';
$mpdf->setAutoBottomMargin = 'stretch';
$mpdf->setHTMLHeader($header);
$mpdf->SetDisplayMode('fullpage');
$mpdf->WriteHTML($html);
$mpdf->Output($pdfFilePath, "I");
//D
}
public function search_paciente(Request $request, $date)
{
// Gets the query string from our form submission
$query = $request->rfc;
// Returns an array of articles that have the query string located somewhere within
// our articles titles. Paginates them so we can break up lots of search results.
$pacientes = Paciente::where('rfc', '=', $query)->get();
$pacientes->each(function ($pacientes) {
$pacientes->tipo;
});
$medico = Medico::find(\Auth::guard('doctors')->user()->doctor_id);
$medico->especialidad;
$medico->horario;
$todas_citas = Cita::getTotalCitas($medico->id, $date);
$horas_usadas = Cita::where('fecha', '=', $date)->where('medico_id', '=', $medico->id)->lists('horario', 'id')->toArray();
$horas = array();
foreach ($horas_usadas as $hora) {
$horas[] = '["' . Carbon::createFromFormat('H:i', $hora)->toTimeString() . '","' . Carbon::createFromFormat('H:i', $hora)->addMinutes(20)->toTimeString() . '"]';
}
$horas = implode(",", $horas);
$entrada = $medico->horario->entrada;
$salida = $medico->horario->salida;
// returns a view and passes the view the list of articles and the original query.
return view('admin.hojas.citas.create')->with('pacientes', $pacientes)->with('medico', $medico)->with('date', $date)->with('todas_citas', $todas_citas)->with('horas', $horas)->with('entrada', $entrada)->with('salida', $salida);
}
