PHP Decode

<?php
 namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Carrera; use App\Pensum; use App\ModalidadesIngresos; use App\MontoInscripcion; use Carbon\Carbon; use App\User; use Auth; use DB; use DateTime; use App\Postulante; use App\Setting_globals; use App\Area; use App\Persona; use App\Alumno; use App\Programaciones; use App\CarreraExtension; use App\ProgramacionOps; use App\ValoresDetalles; use App\Extensiones; use App\Convenio; use App\Historial; use App\AlumnoOps; class ReporteController extends Controller { public function reporte_registro() { $user_ad = User::select("\x75\163\x65\162\x73\x2e\x75\x73\x65\162\x6e\x61\155\x65", "\x75\x73\x65\x72\163\x2e\151\144", "\165\163\145\162\x73\x2e\x66\151\162\x73\x74\137\x6e\141\x6d\x65")->join("\x72\157\154\145\x5f\165\x73\145\x72", "\x72\x6f\154\x65\x5f\x75\x73\x65\x72\56\x75\163\145\162\137\151\x64", "\75", "\165\163\x65\162\163\56\151\x64")->join("\x72\x6f\x6c\x65\163", "\x72\x6f\x6c\x65\163\56\151\x64", "\75", "\x72\157\154\x65\x5f\165\163\x65\162\x2e\162\x6f\x6c\x65\137\x69\144")->where("\162\x6f\x6c\145\163\x2e\156\141\155\x65", "\x72\145\147\x69\x73\164\162\x6f")->get(); $users = User::select("\165\x73\145\x72\x73\56\x75\x73\x65\x72\156\x61\x6d\145", "\165\163\x65\162\x73\x2e\x69\144", "\x75\163\x65\162\163\56\146\151\162\x73\164\x5f\156\141\155\145")->where("\x74\x69\160\x6f\x5f\162\145\147\x69\163\x74\x72\157\137\x75\163\x65\x72", "\122")->get(); $car_pro = Carrera::select("\160\x72\x6f\147\x72\141\155\141")->where("\x69\x64", Auth::user()->carrera)->first(); $carreras = Carrera::select("\x63\141\162\162\145\162\141\x73\x2e\156\x6f\x6d\142\x72\x65\137\143\141\162\x72\x65\162\x61", "\143\x61\x72\162\x65\162\141\x73\56\151\x64", "\x6e\157\155\142\162\x65\137\141\x72\145\141", "\143\141\162\x72\x65\x72\x61\163\56\x70\x72\x6f\147\x72\x61\x6d\x61", "\x6e\157\x6d\142\x72\x65\x5f\160\162\x6f\x67\x72\141\x6d\141", "\x61\x72\x65\x61\x73\56\151\144\x20\x61\163\x20\141\162\145\141\x5f\151\144")->join("\141\162\145\x61\163", "\141\162\x65\x61\x73\x2e\x69\x64", "\75", "\143\141\x72\162\145\x72\x61\x73\x2e\141\x72\145\x61\137\151\x64")->where(function ($query) use($car_pro) { if (Auth::user()->isRole("\144\x69\x72\x65\143\164\x6f\162") || Auth::user()->tipo_registro_user == "\104") { if (trim(Auth::user()->sede) == 1 && ($car_pro == null || $car_pro->programa == null || $car_pro->programa == "\116\117")) { $query->where("\156\x6f\155\x62\x72\x65\137\143\141\x72\162\145\x72\141", "\x6c\151\153\145", "\x25" . Carrera::find(Auth::user()->carrera)->nombre_carrera . "\45"); } else { $query->where("\143\x61\162\x72\145\x72\x61\163\56\151\144", Auth::user()->carrera); } } elseif (Auth::user()->isRole("\144\151\x72\x65\x63\x74\x6f\x72\x2d\x61\x72\x65\x61") || Auth::user()->tipo_registro_user == "\104\x41\x52") { $query->whereIn("\x63\x61\x72\x72\145\162\141\x73\x2e\151\144", json_decode(Auth::user()->area_carrera)); } if (!Auth::user()->isRole("\141\144\155\151\156\151\x73\164\x72\x61\144\157\162") && !Auth::user()->isRole("\x72\x65\147\151\x73\164\162\x6f")) { if (trim(Auth::user()->sede) == 1 && ($car_pro == null || $car_pro->programa == null || $car_pro->programa == "\116\117")) { $query->where("\x63\x61\x72\162\145\162\141\163\56\160\x72\x6f\147\x72\x61\x6d\x61", null); } } })->orderBy("\x61\x72\145\x61\x5f\x69\144")->orderBy("\143\x61\x72\x72\x65\162\x61\x73\x2e\151\x64")->get(); $areas = Area::where(function ($query) use($carreras) { if ($carreras->count() < 15) { $query->where("\x61\x72\x65\x61\163\x2e\151\x64", $carreras[0]->area_id); } })->get(); $extensiones = CarreraExtension::select("\156\157\155\142\x72\x65\137\x65\170\x74\x65\x6e\163\151\x6f\156", "\145\x78\164\145\x6e\x73\151\x6f\x6e\x65\163\x2e\151\x64\x20\141\x73\x20\145\x78\x74\x65\x6e\x73\x69\157\x6e\x5f\x69\x64")->join("\145\x78\164\x65\x6e\x73\151\157\156\145\163", "\145\x78\164\x65\x6e\163\x69\x6f\x6e\145\x73\x2e\x69\144", "\x3d", "\143\141\162\x72\145\x72\x61\137\145\170\164\x65\156\x73\x69\157\156\145\163\x2e\145\x78\164\145\x6e\163\x69\157\x6e\137\151\x64")->where(function ($query) use($carreras) { if (Auth::user()->isRole("\x64\x69\x72\145\x63\x74\x6f\162") || Auth::user()->tipo_registro_user == "\x44") { if (Auth::user()->sede == 1) { $query->where("\143\x61\162\162\x65\x72\141\x5f\151\x64", $carreras[0]->id); } else { $query->where("\145\x78\164\x65\x6e\x73\x69\x6f\x6e\x65\163\x2e\151\x64", Auth::user()->sede); $query->where("\143\x61\162\162\x65\x72\x61\x5f\151\144", $carreras[0]->id); } } else { $query->where("\x63\141\162\162\x65\162\x61\137\151\x64", $carreras[0]->id); } })->get(); $setting = Setting_globals::where("\x69\144", 1)->first()->ins_registros_especial; $pensums = Pensum::select("\160\x65\x6e\x73\x75\155\163\x2e\x6d\x6f\x64\141\x6c\151\x64\141\144\145\x73\x5f\x61\144\155\x69\x73\151\x6f\156", "\160\x65\x6e\163\x75\x6d\163\x2e\151\144\x20\141\163\40\160\145\x6e\x73\x75\155\x5f\x69\x64", "\171\145\x61\x72")->where("\x70\145\156\163\165\x6d\x73\56\143\141\x72\x72\x65\162\x61\137\151\144", $carreras[0]->id)->where("\160\145\156\163\x75\155\x73\x2e\141\x63\164\x69\166\x6f", "\123\x49")->orderBy("\x69\x64", "\x61\x73\x63")->get(); $ultimo_pensum = $pensums->last(); $modalidades = ModalidadesIngresos::select("\156\x6f\x6d\x62\x72\145\137\x6d\x6f\144", "\x69\x64")->whereIn("\151\x64", json_decode($ultimo_pensum->modalidades_admision))->where(function ($query) use($setting) { if ($setting == "\x4e\117") { $query->where("\x65\163\x70\x65\143\151\141\x6c", "\116\117"); } })->orderBy("\151\x64", "\141\163\x63")->orderBy("\x65\163\160\145\143\x69\x61\154", "\x61\x73\143")->get(); $planes = Pensum::select("\160\x65\x6e\163\165\155\x73\56\151\144", "\x79\145\141\162")->where("\x70\x65\x6e\x73\165\155\163\56\x63\x61\x72\x72\145\x72\x61\x5f\151\144", $carreras[0]->id)->orderBy("\171\145\x61\x72", "\x64\x65\163\143")->get(); $convenios = Convenio::select("\x6e\157\x6d\142\x72\145\x5f\143\157\156\x76\145\x6e\x69\157", "\x69\144")->orderBy("\x69\x64", "\x61\163\143")->get(); $gestion_postulantes = Postulante::select("\147\x65\163\x74\x69\x6f\x6e")->where("\147\145\x73\x74\151\x6f\156", "\41\x3d", null)->distinct()->orderBy("\147\145\163\x74\151\x6f\x6e", "\x64\x65\x73\x63")->get(); $gestion_alumnos = Alumno::select("\147\145\x73\x74\151\157\156")->where("\x67\145\x73\164\x69\157\x6e", "\x21\x3d", null)->distinct()->orderBy("\x67\145\163\x74\x69\x6f\x6e", "\144\x65\163\143")->get(); return view("\x72\145\x70\x6f\x72\164\x65\56\151\156\x64\145\x78\137\x72\x65\x67\151\x73\164\162\157", compact("\x75\163\x65\x72\x73", "\x75\x73\145\x72\137\x61\144", "\x67\x65\163\164\x69\x6f\156\137\x70\157\163\164\165\x6c\141\x6e\164\145\x73", "\143\x61\162\x72\145\x72\x61\x73", "\145\170\164\x65\x6e\163\x69\157\156\x65\163", "\x6d\x6f\144\141\x6c\x69\144\x61\144\x65\163", "\x70\x65\x6e\163\165\x6d\163", "\x67\x65\163\164\151\157\x6e\137\141\x6c\x75\x6d\x6e\157\x73", "\x70\154\141\156\145\163", "\x61\x72\x65\x61\163", "\143\x6f\x6e\x76\x65\156\151\157\163")); } public function reporte_caja_preu(Request $request) { try { $fecha_inicio = null; $fecha_final = null; $fecha = null; $habilitar_valores = false; $matricula = $request->matricula; if (isset($request->user)) { $user = $request->user; } else { $user = null; } if (isset($request->rango_fecha)) { $f = explode("\40\x2d\40", $request->rango_fecha); $fecha_inicio = $f[0]; $fecha_final = $f[1]; } else { $fecha = $request->fecha; } if ($matricula != "\142\x6c\157\x71\165\x65\x61\144\x6f") { $matriculas_postulantes = MontoInscripcion::select("\160\x65\x72\x73\x6f\156\141\x73\x2e\156\x6f\x6d\142\162\145", "\160\x65\x72\163\x6f\156\x61\x73\56\141\x70\145\x6c\x6c\x69\x64\157\163", "\156\157\155\142\x72\145\137\x63\x61\162\162\145\162\x61", "\x6d\157\x6e\164\157\x5f\x69\x6e\163\143\x72\151\x70\x63\151\x6f\x6e\56\x63\157\156\x63\x65\x70\164\x6f", "\155\157\156\164\157\137\151\x6e\x73\143\162\x69\160\x63\x69\157\156\56\155\157\156\x74\157", "\x6d\x6f\156\164\x6f\x5f\x69\156\x73\x63\x72\x69\x70\x63\x69\157\156\x2e\x65\x73\x74\141\144\157", "\x70\x65\162\163\157\156\x61\163\56\x63\151\x5f\x70\145\162\163\x6f\156\x61")->join("\160\157\x73\x74\165\x6c\x61\156\x74\145\x73", "\160\157\163\164\x75\154\141\x6e\x74\145\x73\56\x69\x64", "\x3d", "\155\x6f\156\x74\157\x5f\151\x6e\x73\143\x72\151\160\143\x69\x6f\156\56\160\x6f\163\164\165\154\x61\x6e\164\145\x5f\x69\x64")->join("\x70\145\162\163\x6f\156\x61\163", "\x70\145\162\163\157\156\x61\163\56\x69\144", "\75", "\160\157\163\164\x75\154\x61\x6e\164\x65\x73\56\160\x65\162\x73\x6f\x6e\x61\137\x69\x64")->join("\143\x61\162\162\145\162\141\x73", "\143\141\162\x72\x65\162\141\163\x2e\x69\x64", "\x3d", "\x70\157\x73\x74\165\154\x61\x6e\164\145\163\56\x63\141\162\162\145\x72\x61\137\x69\x64")->join("\155\157\x64\x61\x6c\151\144\141\x64\145\163\137\x69\156\x67\x72\x65\x73\x6f\x73", "\155\x6f\x64\141\154\151\x64\x61\x64\145\163\x5f\x69\156\147\x72\145\x73\157\163\x2e\x69\144", "\x3d", "\160\x6f\163\x74\x75\x6c\141\156\164\145\x73\x2e\155\157\x64\141\154\151\144\141\x64\x5f\x69\x6e\147\x72\145\163\157\137\151\144")->where(function ($query) use($matricula, $user, $fecha_inicio, $fecha_final, $fecha) { if ($matricula != "\x74\157\x64\157\163" && $matricula != "\164\x6f\144\x6f\163\137\155\141\164\x72\151\143\165\154\141") { if ($matricula == "\x45\x73\160\145\x63\x69\x61\x6c") { $query->whereIn("\x6d\157\x6e\164\x6f\x5f\x69\156\x73\143\x72\151\160\143\x69\157\156\56\157\x62\x73\137\x63\157\x6e\143\x65\160\164\157", array("\120\x72\x6f\x66\x65\163\x69\x6f\x6e\x61\154", "\105\x78\143\145\154\x65\x6e\143\151\x61", "\x4c\x69\x62\145\x72\x61\x64\141", "\103\x6f\x6e\x76\145\156\x69\157")); } else { $query->where("\155\x6f\156\164\157\137\x69\156\x73\x63\x72\151\x70\x63\151\157\x6e\x2e\x6f\x62\x73\x5f\143\x6f\156\143\x65\x70\x74\x6f", $matricula); } } if ($user != null) { if ($user != "\x74\x6f\x64\157\x73") { $query->where("\155\157\156\x74\157\137\151\x6e\x73\x63\x72\x69\x70\x63\151\x6f\156\x2e\165\x73\145\162\x5f\x69\144", $user); } } else { $query->where("\155\x6f\x6e\164\x6f\137\x69\156\x73\x63\x72\x69\160\143\151\157\156\56\165\x73\x65\x72\137\151\x64", Auth::user()->id); } if ($fecha != null) { $query->where("\x6d\x6f\x6e\x74\157\x5f\151\156\x73\143\162\151\160\143\x69\x6f\x6e\x2e\x66\145\143\x68\141", $fecha); } else { $query->whereBetween("\x6d\x6f\x6e\x74\157\x5f\x69\156\163\143\x72\x69\x70\x63\151\x6f\156\56\146\x65\143\150\x61", array($fecha_inicio, $fecha_final)); } })->whereNotIn("\x6d\157\x6e\x74\x6f\137\151\156\163\143\x72\151\160\x63\151\x6f\156\x2e\164\x69\160\x6f", array("\126\141\154\x6f\162\145\163"))->where("\155\x6f\x6e\x74\x6f\137\151\156\x73\x63\162\x69\x70\x63\x69\157\156\56\x65\163\164\x61\144\x6f", 1)->orderBy("\x70\145\162\x73\x6f\156\141\x73\x2e\x61\160\x65\x6c\x6c\151\144\157\163", "\x61\163\x63")->orderBy("\x70\145\162\163\157\x6e\141\163\x2e\x6e\x6f\155\x62\162\145", "\x61\163\x63")->get(); } if ($matricula == "\164\x6f\144\157\x73" || $matricula == "\x62\154\157\161\x75\x65\x61\144\157") { $matricula_postulantes_bloqueada = Historial::select("\150\x69\163\x74\157\x72\x69\x61\154\x2e\x69\x64\40\141\163\40\150\151\x73\x74\x6f\x72\x69\141\154\137\x69\x64", "\160\145\x72\163\x6f\156\141\163\56\x6e\157\155\x62\162\x65", "\160\145\x72\x73\157\156\x61\163\x2e\x61\160\145\154\154\x69\x64\157\x73", "\144\145\x73\143\137\x6d\x61\x74\x72\151\143\x75\154\141\137\142\x6c\x6f\x71\165\145\x61\x64\x61", "\160\145\162\163\x6f\x6e\x61\163\x2e\143\151\137\x70\x65\x72\163\x6f\156\141", "\x75\163\145\x72\x73\x2e\146\x69\162\x73\x74\x5f\156\141\x6d\x65", "\x75\x73\x65\x72\x73\56\154\141\x73\164\x5f\x6e\141\155\145", "\165\163\145\x72\x73\56\x75\x73\x65\x72\x6e\x61\x6d\145", "\155\141\164\162\151\143\x75\x6c\x61\x73\56\143\157\156\143\145\x70\164\x6f", "\155\x61\164\162\151\x63\x75\154\x61\x73\56\164\x69\160\157\x5f\x6d\x61\164\162\151\143\165\x6c\x61")->join("\x70\x6f\x73\164\165\x6c\x61\156\x74\145\x73", "\160\x6f\x73\164\165\x6c\141\156\x74\x65\163\56\x69\144", "\x3d", "\150\x69\x73\164\x6f\162\x69\141\154\56\160\157\x73\x74\x75\x6c\141\156\164\x65\137\x69\x64")->join("\x70\145\162\x73\157\156\x61\x73", "\160\145\162\163\157\156\141\x73\x2e\x69\x64", "\75", "\x70\x6f\163\164\x75\154\x61\x6e\x74\145\163\x2e\160\x65\x72\163\157\156\141\137\x69\144")->join("\155\x61\x74\162\x69\x63\165\x6c\x61\x73", "\155\141\x74\162\x69\x63\x75\x6c\x61\163\x2e\x69\x64", "\75", "\x68\x69\x73\x74\x6f\x72\151\x61\154\56\x6d\141\x74\x72\151\143\165\154\141\137\151\144")->join("\165\x73\x65\162\x73", "\x75\163\145\162\x73\56\x69\x64", "\75", "\150\151\x73\164\x6f\162\151\141\x6c\56\x75\163\145\162\x5f\x69\x64")->where(function ($query) use($matricula, $user, $fecha_inicio, $fecha_final, $fecha) { if ($user != null) { if ($user != "\164\157\x64\157\163") { $query->where("\x68\151\x73\164\157\162\151\x61\x6c\x2e\165\x73\145\x72\137\151\144", $user); } } else { $query->where("\x68\151\163\x74\157\162\151\x61\154\56\x75\x73\x65\162\x5f\151\144", Auth::user()->id); } if ($fecha != null) { $query->where("\155\x61\x74\x72\x69\x63\x75\x6c\x61\x73\x2e\x66\x65\x63\150\141", $fecha); } else { $query->whereBetween("\155\x61\x74\162\x69\143\x75\x6c\x61\x73\56\146\145\x63\x68\141", array($fecha_inicio, $fecha_final)); } })->where("\155\x61\x74\x72\151\143\x75\154\x61\x73\56\x65\x73\164\x61\x64\x6f", 0)->where("\150\x69\163\x74\x6f\162\151\141\x6c\56\x6f\x62\x73\x5f\x65\x73\x74\x61\144\157", 1)->orderBy("\160\x65\x72\x73\157\156\x61\163\x2e\x61\160\145\x6c\154\x69\x64\x6f\163")->orderBy("\x70\x65\x72\163\x6f\156\141\163\x2e\x6e\x6f\x6d\x62\162\x65")->orderBy("\150\x69\163\x74\x6f\162\151\x61\x6c\56\x69\144", "\141\x73\143")->get(); } if ($matricula == "\x74\157\x64\157\x73" || $matricula == "\x76\141\154\157\x72") { $valores_regular = MontoInscripcion::select("\x76\x61\x6c\x6f\162\x65\163\137\160\157\163\164\x75\154\141\156\164\x65")->join("\160\157\163\164\x75\x6c\141\x6e\x74\145\163", "\160\x6f\163\x74\x75\154\x61\156\x74\x65\163\56\151\144", "\75", "\155\157\156\164\x6f\137\151\x6e\x73\x63\x72\151\160\x63\x69\157\156\56\x70\x6f\163\164\x75\x6c\x61\x6e\x74\145\137\x69\144")->join("\x63\141\162\162\x65\x72\x61\x73", "\143\141\162\x72\x65\162\x61\x73\x2e\x69\144", "\x3d", "\160\x6f\163\164\165\x6c\x61\156\164\x65\x73\56\143\x61\162\x72\145\162\141\x5f\151\144")->where(function ($query) use($user, $fecha, $fecha_inicio, $fecha_final) { if ($user != null) { if ($user != "\x74\x6f\x64\x6f\x73") { $query->where("\155\x6f\156\x74\157\137\151\x6e\x73\143\162\151\160\x63\151\157\156\x2e\165\x73\x65\162\137\x69\x64", $user); } } else { $query->where("\x6d\157\x6e\x74\x6f\x5f\151\x6e\163\x63\x72\x69\x70\143\x69\157\x6e\56\x75\x73\145\162\137\x69\x64", Auth::user()->id); } if ($fecha != null) { $query->where("\155\x6f\156\164\x6f\x5f\151\156\x73\143\x72\x69\x70\x63\151\x6f\x6e\x2e\146\145\143\150\x61", $fecha); } else { $query->whereBetween("\x6d\x6f\156\164\x6f\x5f\x69\156\x73\143\x72\x69\160\143\x69\x6f\156\x2e\x66\x65\143\150\x61", array($fecha_inicio, $fecha_final)); } })->where("\155\157\156\x74\x6f\x5f\151\x6e\163\143\x72\x69\x70\x63\151\157\x6e\x2e\x63\157\156\x63\145\160\x74\157", "\126\x61\154\x6f\x72\x65\x73\x20\160\x6f\163\x74\x75\x6c\141\x6e\164\x65")->where("\155\157\x6e\x74\x6f\x5f\151\156\163\143\162\x69\x70\x63\151\157\x6e\56\x65\163\x74\x61\144\x6f", 1)->where("\x63\x61\x72\x72\145\162\x61\163\x2e\160\162\x6f\147\162\141\x6d\141", "\x3d", null)->get(); $texto_apoyo_ciencias_politicas = array("\143\x61\x6e\164\151\x64\x61\x64" => 0, "\x63\x6f\156\x63\145\160\164\x6f" => "\124\145\x78\x74\x6f\x20\x41\x70\141\x79\157\40\103\151\145\x6e\x63\x69\141\163\x20\x50\157\154\151\164\151\x63\x61\x73", "\x63\x6f\x73\x74\x6f\137\x75\x6e\x69\164\x61\x72\x69\157" => 100, "\x63\x6f\x73\164\157" => 0); if ($valores_regular != null && $valores_regular->count() != 0) { $habilitar_valores = true; } foreach ($valores_regular as $value) { $valores = json_decode($value->valores_postulante); for ($i = 0; $i < count($valores); $i++) { if (in_array("\124\145\170\164\x6f\x20\x41\x70\x61\171\157\40\103\x69\x65\156\x63\151\141\x73\40\x50\157\154\151\x74\x69\143\x61\x73", $valores[$i])) { $texto_apoyo_ciencias_politicas["\x63\x61\x6e\x74\x69\x64\141\144"]++; $texto_apoyo_ciencias_politicas["\x63\157\x73\x74\157"] = $valores[$i][2] + $texto_apoyo_ciencias_politicas["\x63\157\x73\x74\x6f"]; } } } $totales_valores = array($texto_apoyo_ciencias_politicas); } return view("\162\x65\x70\157\162\x74\145\56\x70\x72\145\x5f\165\156\151\166\145\x72\163\x69\164\x61\162\151\157\56\x72\145\x67\151\163\164\x72\x6f\163\x2e\x72\x65\x70\x6f\x72\x74\x65\56\143\x61\x6a\145\x72\x6f\137\160\x72\x65\x75\156\x69\166\145\162\163\x69\164\x61\162\x69\x6f", compact("\155\x61\x74\x72\151\143\x75\x6c\x61\163\x5f\160\157\163\164\165\x6c\x61\x6e\x74\145\x73", "\x6d\x61\x74\162\x69\x63\x75\x6c\141\137\x70\157\163\x74\x75\x6c\141\156\164\x65\x73\x5f\142\x6c\x6f\x71\x75\x65\141\144\141", "\165\x73\x65\162", "\x6d\141\x74\x72\151\x63\x75\x6c\141", "\146\145\143\x68\x61", "\x66\145\x63\150\141\137\x69\156\x69\x63\x69\157", "\x66\145\x63\150\x61\137\146\151\x6e\141\x6c", "\x74\157\x74\141\154\145\163\137\166\x61\154\157\162\x65\163", "\150\141\142\151\x6c\151\164\141\162\137\166\141\154\157\x72\x65\x73")); } catch (\Exception $e) { return view("\145\162\x72\x6f\162\x73\x2e\x34\x30\x34"); } }