public function porCategoria($id)
{
$subcategorias = Subcategoria::where('categoria_id', '=', $id)->get()->toArray();
//$subcategorias_lists = $subcategorias::lists('descricao', 'id');
return Response()->json($subcategorias)->header('Access-Control-Allow-Origin', "*");
//return Response()->make($subcategorias);
}
public function index()
{
$user = $this->user->selectAll();
//dd($comment);
//return Response()->json(['name' => 'Seild', 'state' => 'Hyed']);
return Response()->json($user);
}
public function index()
{
//$comments = $this->comment->selectAll();
//return Response()->json(['name' => 'Seild', 'state' => 'Hyed']);
$commments = $this->comment->getAll();
return Response()->json($commments);
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @param string|null $guard
* @return mixed
*/
public function handle($request, Closure $next, $guard = null)
{
if (!Auth::check()) {
return Response()->json(ResponseManager::getError('', 401, 'You are not authorized to access this. Plese login.'));
}
return $next($request);
}
public function handle($request, Closure $next)
{
if ($request->user() == null || !$request->user()->est_adm()) {
return Response("Accès interdit");
}
return $next($request);
}
public function getCost(Request $request)
{
$credentials = new Aws\Credentials\Credentials(env('AWS_KEY'), env('AWS_SECRET'));
$client = Ec2Client::factory(array('credentials' => $credentials, 'version' => 'latest', 'region' => $request->input('region')));
$terminate = Carbon::parse($request->input('terminateTime'));
$terminateTime = Carbon::parse($request->input('terminateTime'));
$terminate->minute = 00;
$terminate->second = 00;
$terminate->addHour();
$launch = Carbon::parse($request->input('launchTime'));
$launchTime = Carbon::parse($request->input('launchTime'));
$launch->minute = 00;
$launch->second = 00;
//$client = \AWS::createClient('ec2');
$result = $client->describeSpotPriceHistory(['AvailabilityZone' => $request->input('availabilityZone'), 'DryRun' => false, 'StartTime' => $launch, 'EndTime' => $terminate, 'InstanceTypes' => [$request->input('instanceType')], 'ProductDescriptions' => ['Linux/UNIX']]);
$total_cost = 0.0;
$total_seconds = $launch->diffInSeconds($terminate);
$total_hours = $total_seconds / (60 * 60);
$last_time = $terminate;
$computed_seconds = 0;
foreach ($result['SpotPriceHistory'] as $price) {
$price['SpotPrice'] = floatval($price['SpotPrice']);
$available_seconds = new Carbon($last_time = $price['Timestamp']);
$available_seconds = $available_seconds->diffInSeconds(Carbon::createFromTimestamp(0));
$remaining_seconds = $total_seconds - $computed_seconds;
$used_seconds = min($available_seconds, $remaining_seconds);
$total_cost = $total_cost + $price['SpotPrice'] / (60 * 60) * $used_seconds;
$computed_seconds = $computed_seconds + $used_seconds;
$last_time = $price['Timestamp'];
}
return Response(['TotalCost' => $total_cost, 'PaidHours' => $launch->diffInSeconds($terminate) / (60 * 60), 'ActualHours' => $launchTime->diffInSeconds($terminateTime) / (60 * 60)]);
}
/**
*Devuelve un pdf con todos los datos
*estadisticos del Reg, de tumores del año
*y del mes que se pase
*responde a @GET /reporte/estadisticas/rncs
*/
public function rncStad(Request $data)
{
//Reglas de validacion
$rules = ['year' => 'required', 'mon' => 'required|numeric|min:1|max:12'];
/*
*Valida datos segun las reglas $rules
*y genera mensajes segun $messages
*/
$validator = Validator::make($data->all(), $rules, $this->messages);
/*
*Si hay error en los datos,
*regresa el primer mensaje de
*error
*/
if ($validator->fails()) {
//Primer mensaje de error
$errMessage = $validator->errors()->first();
return Response()->json(['status' => 'danger', 'message' => $errMessage]);
} else {
$year = $data->year;
$mon = '0' . $data->mon;
$date = $year . '-' . $mon;
$mons = ['ENERO', 'FEBRERO', 'MARZO', 'ABRIL', 'MAYO', 'JUNIO', 'JULIO', 'AGOSTO', 'SEPTIEMBRE', 'OCTUBRE', 'NOVIEMBRE', 'DICIEMBRE'];
$mo = $mons[$mon - 1];
$registers = DB::table('rncs')->where('fec_reg', 'like', $date . '%')->select('reg_rgn', 'nom_pri', 'nom_seg', 'ape_pri', 'ape_seg', 'sex', 'eda_adm', 'prc_edo', 'mun_prc', 'des_ltg', 'cod_ltg', 'sco_ltg', 'des_morf', 'cod_morf', 'fec_fall', 'qui_otra', 'num_his')->get();
$man = DB::table('rncs')->where('fec_reg', 'like', $date . '%')->where('sex', 'MASCULINO')->count();
$girl = DB::table('rncs')->where('fec_reg', 'like', $date . '%')->where('sex', 'FEMENINO')->count();
$view = \View::make('pdfs.rncStad', compact('registers', 'year', 'mo', 'man', 'girl'))->render();
$pdf = \App::make('dompdf.wrapper');
$pdf->loadHTML($view)->setPaper('latter')->setOrientation('landscape');
return $pdf->stream('invoice');
}
}
public function getsuma($valor1, $valor2)
{
$total = $valor1 + $valor2;
$array = ['valor1' => $valor1, 'valor2' => $valor2, 'total' => $total];
//return view('operacion.suma', compact('total','valor1', 'valor2'));
//return view('operacion.suma');
return Response()->json($array);
}
function get($query = null)
{
if ($query == null) {
return false;
}
$search = new GlobalSearch();
Response($search->do_search($query));
}
/**
* @param $idSKu
* @return \Dingo\Api\Http\Response
*/
public function getDetailsPage($idSKu)
{
$product = $this->integrator->getDetailPage($idSKu);
if (!$product) {
throw new StoreResourceFailedException('Product not found');
}
return Response()->json($product);
}
/**
* @param Request $request
* @return \Symfony\Component\HttpFoundation\Response
*/
public function getFeaturedProducts(Request $request)
{
try {
$products = $this->integrator->getFeatureds($request);
return Response()->json($products);
} catch (\Exception $e) {
throw new StoreResourceFailedException($e->getMessage());
}
}
/**
* @return \Symfony\Component\HttpFoundation\Response
*/
public function getWhoBougthAlsoBougth(Request $request)
{
try {
$recommendations = $this->integrator->getWhoViewAlsoView($request);
return Response()->json($recommendations);
} catch (\Exception $e) {
throw new StoreResourceFailedException($e->getMessage());
}
}
public function getForm($id_campagne)
{
$campagne = Campagne::find($id_campagne);
if ($campagne != null) {
return view('image_creation', array('campagne' => $campagne));
} else {
return Response("Stop pirater");
}
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$api_key = Input::get('api_key');
if ($api_key != '2') {
return Response()->json(array('message' => 'There is no api key!'), 404);
} else {
return $next($request);
}
}
public function getDepartamento($id)
{
$insumo = Departamento::where('id', $id)->first();
if (!$insumo) {
return Response()->json(['status' => 'danger', 'menssage' => 'Este departamento no existe']);
} else {
return $insumo;
}
}
public function getDeposito($id)
{
$deposito = Deposito::where('id', $id)->first(['id', 'codigo', 'nombre']);
if (!$deposito) {
return Response()->json(['status' => 'danger', 'menssage' => 'Este Almacén no existe']);
} else {
return $deposito;
}
}
/**
* @return \Symfony\Component\HttpFoundation\Response
*/
public function getTree()
{
try {
$categories = $this->integrator->getTree();
return Response()->json($categories);
} catch (\Exception $e) {
throw new StoreResourceFailedException($e->getMessage());
}
}
/**
* Handle an incoming request. If cached load the cached contents
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$key = $this->makeCacheKey($request->url());
if (Cache::has($key)) {
$response = Cache::get($key);
return Response($response);
} else {
return $next($request);
}
}
public function logginuser()
{
if (Auth::check()) {
$user = User::find(Auth::User()->id);
$message = 'Success';
return Response()->json(ResponseManager::getResult($user, 10, $message));
} else {
$message = 'Please login';
return Response()->json(ResponseManager::getError('', 10, $message));
}
}
public function checkUseSsl($send_redirect = false)
{
$redirect = true === USE_SSL && (!isset($_SERVER['HTTPS']) || $_SERVER['HTTPS'] !== 'on');
if (true === $send_redirect) {
if (true === $redirect) {
Response()->redirect('https://' . Request()->serverName . Request()->url)->send();
exit;
}
}
return $redirect;
}
public function Listen($song_id)
{
$song = Song::find($song_id);
if (count($song)) {
$song->listen_count++;
$song->save();
return Response()->json(array('data' => $song), 200);
} else {
return Response()->json(array('message' => 'Song not Found'), 404);
}
}
public function rechercher($id_campagne, Request $request)
{
$campagne = Campagne::find($id_campagne);
$contenu = $request::get('recherche');
if ($campagne != null) {
return view('campagne', ['campagne' => $campagne, 'images' => Image::where('id_campagne', $id_campagne, false)->where(function ($query) use($contenu) {
$query->where('titre_image', 'LIKE', '%' . $contenu . '%')->orWhere('description_image', 'LIKE', '%' . $contenu . '%');
})->where('validation_image', 1, false)->orderByRaw('RAND()')->get(), 'elementRecherche' => $contenu]);
} else {
return Response("Campagne non trouvée");
}
}
public function _remap($method)
{
$func = $this->input->method() === 'put' || $this->input->method() === 'patch' ? "update_{$method}" : $this->input->method() . "_" . $method;
if ($this->input->method() == 'options') {
ResponseOk($this->header);
} elseif (method_exists($this, $func)) {
$resp = $this->{$func}();
Response((array) $resp, 200, $this->content_type, $this->header);
} else {
MethodNotFoundResponse($this->header);
}
}
/**
* Display the specified news article.
*
* @param int $id - id of a news artical
* @return Response
*/
public function show($id)
{
// find by $id
$news_item = News::find($id);
// if no news item found
if (!$news_item) {
// set response as an error
return Response()->json(['message' => 'The news article could not be found', 'code' => 404], 404);
}
// set response as json with data
return Response()->json(['data' => $news_item, 'code' => 200], 200);
}
function rebuild()
{
if (!current_user()->is('admin')) {
return false;
}
$language = new Language();
$result = $language->build_templates();
if ($result == true) {
Response($result);
} else {
Response()->error('');
}
}
public function getServicio(Request $request)
{
$data = $request->all();
$validator = Validator::make($data, ['servicio' => 'required', 'fechaI' => 'required', 'fechaF' => 'required'], $this->menssage);
if ($validator->fails()) {
return Response()->json(['status' => 'danger', 'menssage' => $validator->errors()->first()]);
} else {
$deposito = Auth::user()->deposito;
$servicio = Departamento::where('id', $data['servicio'])->value('nombre');
$insumos = DB::table('salidas')->whereBetween(DB::raw('DATE_FORMAT(insumos_salidas.created_at,"%Y-%m-%d")'), [$data['fechaI'], $data['fechaF']])->where('salidas.departamento', $data['servicio'])->where('salidas.deposito', $deposito)->join('insumos_salidas', 'insumos_salidas.salida', '=', 'salidas.id')->join('insumos', 'insumos.id', '=', 'insumos_salidas.insumo')->select('insumos.descripcion as name', DB::raw('sum(insumos_salidas.despachado) as y'))->groupBy('insumos.descripcion')->orderBy('y', 'desc')->get();
$title = 'Salidas de ' . $servicio . ', del (' . $data['fechaI'] . ' a ' . $data['fechaF'] . ')';
return ['status' => 'success', 'data' => $insumos, 'title' => $title];
}
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @param int $uri_user_id
* @return mixed
*/
public function handle($request, Closure $next)
{
// User_id URI segment
$user_id = $request->user_id;
if ('testing' === app()->env) {
$user_id = 1;
}
$authUser = Auth::ID();
if ($user_id != $authUser) {
$data = ['error' => ['message' => 'Not authorized to access this resource', 'code' => 403]];
return Response()->json($data, 403);
} else {
return $next($request);
}
}
public function Save(Request $request)
{
$data = $request->all();
$validator = Validator::make($data, ['nombre' => 'required', 'apellidos' => 'required', 'email' => 'required|email', 'pais' => 'required|', 'presupuesto' => 'required']);
if ($validator->fails()) {
return Response()->json(['status' => 'danger', 'menssage' => $validator->errors()->first()]);
} else {
$token = str_replace('/', '9', bcrypt($data['email']));
Formulario::create(['representante' => $data['nombre'], 'apellidos' => $data['apellidos'], 'email' => $data['email'], 'pais' => $data['pais'], 'presupuesto' => $data['presupuesto'], 'comentarios' => $data['comentarios'], 'objetivo' => $data['objetivo'], 'nino' => $data['nino'], 'adolecente' => $data['adolecente'], 'estudiante' => $data['estudiante'], 'token' => $token]);
Mail::send('email', ['token' => $token], function ($message) {
$message->from('briefing@example.com/', 'Briefing');
$message->to(env('CONTACT_MAIL'));
});
return Response()->json(['status' => 'success', 'menssage' => 'Registro Completado']);
}
}
function download($id, $init_download = null)
{
$file = new File($id);
$this->check_authorization($file);
if ($file->is_valid()) {
$path = $file->download($init_download);
if ($path !== false) {
Response($path);
} else {
Response()->error(Language::get('errors.file_error_downloading'));
}
//todo: all error strings should be set in the model?
} else {
Response()->invalid_model($id);
}
}
public function get($id = '')
{
//$carpet = Carpet::findOrFail(3);
$carpets = Carpet::all();
$return_json = "";
foreach ($carpets as $carpet) {
$data = json_decode($carpet);
foreach ($data as $key => $entry) {
if ($key == 'id' && $entry == $carpet->id) {
$data->types = array('type' => $carpet->types);
$data->prices = array('price' => $carpet->prices);
}
}
$return_json[] = $data;
}
return Response()->json(array('Carpet' => $return_json));
}
