function updateProfile()
{
$userId = Session::get('user_id');
if (!isset($userId)) {
return json_encode(array('message' => 'not logged'));
}
$user = user::find($userId);
if (isset($user)) {
$email = Input::get('email');
$userByEmail = user::where('email', '=', $email)->first();
if (isset($userByEmail) && $userByEmail->id != $user->id) {
echo 'duplicate';
} else {
$user->id = $userId;
$user->email = $email;
$user->name = Input::get('name');
$user->password = Input::get('password');
$user->user_type = Input::get('user_type');
$user->save();
return json_encode(array('message' => 'done'));
}
} else {
return json_encode(array('message' => 'invalid'));
}
}
public static function login($email, $password)
{
$user = user::where('email', $email)->where('password', sha1(TinyMvc::app()->config['salt'] . $password))->getOne();
if (!$user) {
return false;
}
$user->lastlogindate = date("Y-m-d H:i:s");
$user->lastloginip = $_SERVER['REMOTE_ADDR'];
$user->save();
return $user;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$lastlogin = table_last_login::where('last_login_id', '=', $id)->first();
$user = user::where('id', '=', $lastlogin->users_id)->first();
if ($user != null) {
$username = $user->name;
} else {
$username = '';
}
$data = array('user_name' => $username, 'last_login' => table_last_login::where('last_login_id', '=', $id)->get(), 'users_detail' => json_encode(DB::select('select users_id as id, users_name as value, users_name as label from table_users_detail')));
return view('admin.database.last-login.last-login-edit', compact('data'));
}
public function handleProviderCallback()
{
$user = socialite::driver('facebook')->user();
$data = ['name' => $user->name, 'email' => $user->email, 'password' => $user->token];
$userDB = user::where('email', $user->email)->first();
if (!is_null($userDB)) {
Auth::login($userDB);
} else {
# code...
Auth::login($this->create($data));
}
return Redirect('/home');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$wanted = user::where('id', $id)->first();
if (is_null($wanted)) {
return "Not Found";
} else {
$doctor = Doctor::where('email', '=', $wanted->email)->first();
$count = tickets::where('userid', $wanted->id)->count();
$countAppointment = doctorSchedule::where('uid', '=', $wanted->id)->count();
if (is_null($doctor)) {
return view('user.profileview')->with('user', Session::get('user'))->with('viewing', $wanted)->with('ticketCount', $count)->with('appointmentCount', $countAppointment);
} else {
return view('user.profileview')->with('user', Session::get('user'))->with('viewing', $wanted)->with('doctor', $doctor)->with('ticketCount', $count)->with('appointmentCount', $countAppointment);
}
}
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
if (!Auth::guest()) {
$user = User::where('priviledge', '!=', 'superuser')->get();
$user_designation = Designation::where('id', '=', Auth::user()->id)->pluck('designation');
$user_votes = Vote::where('user_id', '=', Auth::user()->id)->get();
$count = count($user_votes);
$i = 0;
foreach ($user_votes as $user_vote) {
$user_name[$i] = user::where('id', '=', $user_vote->login_id)->pluck('user_name');
$i++;
}
//var_dump($user_name);die;
$weights = Vote::where('user_id', '=', Auth::id())->sum('performance');
$sum = $weights;
$name = priviledge::where('user_id', '=', Auth::user()->id)->pluck('name_show');
$path = file::where('user_id', '=', Auth::user()->id)->pluck('path');
$authority = Priviledge::all();
return View::make('votes.profile', compact('authority', 'path', 'user_designation', 'user_votes', 'sum', 'user', 'name', 'user_name'));
} else {
return Redirect::intended('login');
}
}
if (get_class($d) != 'product') {
echo "wrong class returned\n";
exit;
}
if (!$p->userId instanceof user) {
echo "wrong return class of hasOne result\n";
exit;
}
$cnt++;
}
if ($cnt != $db->count && $cnt != 5) {
echo "wrong count after get\n";
exit;
}
// hasMany
$user = user::where('id', 1)->getOne();
if (!is_array($user->products) || count($user->products) != 3) {
echo "wrong count in hasMany\n";
exit;
}
foreach ($user->products as $p) {
if (!$p instanceof product) {
echo "wrong return class of hasMany result\n";
exit;
}
}
// multi save
$client = new user();
$client->login = '******';
$client->firstName = 'john';
$client->lastName = 'Doe Jr';
<?php
$app->group('/user', function () use($app) {
$app->get('/', function () use($app) {
$data = json_decode($app->request->getBody(), true);
$results = [];
$results["user"] = [];
$results["success"] = "false";
if (validatedKey($data["user"]["id"], $data["user"]["key"])) {
$user = user::where('id', '=', $data["user"]["id"])->first();
$results["user"] = $user;
$results["success"] = "true";
} else {
$results["success"] = "false";
$results["error"] = "No auth";
}
echo json_encode($results);
});
$app->post('/photo', function () use($app) {
$data = json_decode($_POST['data'], true);
$results = [];
$results["success"] = "false";
if (validatedKey($data['user'])) {
if ($_FILES['file']['name'] != "") {
// El campo foto contiene una imagen...
// Primero, hay que validar que se trata de un JPG/GIF/PNG
$allowedExts = array("jpg", "jpeg", "gif", "png", "JPG", "GIF", "PNG");
$ext = end(explode(".", $_FILES["file"]["name"]));
if (($_FILES["file"]["type"] == "image/gif" || $_FILES["file"]["type"] == "image/jpeg" || $_FILES["file"]["type"] == "image/png" || $_FILES["file"]["type"] == "image/pjpeg") && in_array($ext, $allowedExts)) {
$ext = end(explode('.', $_FILES['file']['name']));
$photo = substr(md5(uniqid(rand())), 0, 10) . "." . $ext;
/**
* Take All JSON Post Requset and process them
* Tasks
* 1. Reset Passwords
* 2. Login
* 3. Send Emails when Password is resetted
*
* @return Response, Views
**/
public function inputs()
{
$user = Session::get('user');
if (is_null($user) || $user->verified == 1) {
return response()->json(['message' => 'Missmatch Data', 'code' => 'error']);
}
if (Request::get('task') == "sendEmail") {
/**
*
* Send the Email including the activation code
*
*/
$email = Request::get('email');
if (is_null($email) || trim($email) == "" || !preg_match("/^([a-zA-Z0-9_.+-])+\\@(([a-zA-Z0-9-])+\\.)+([a-zA-Z0-9]{2,4})+\$/", $email)) {
return response()->json(['message' => 'Missmatch Data', 'code' => 'error', 'task' => 'sendEmail']);
}
if ($user->email != $email) {
$checkUser = user::where('email', $email)->count();
if ($checkUser == 0) {
$user->email = $email;
} else {
return response()->json(['message' => 'Email already Registerd', 'code' => 'error', 'task' => 'sendEmail']);
}
}
Mail::send('mailtemplate/emailVerify', ['name' => $user->name, 'code' => Session::get('emailKey')], function ($m) use($user) {
$m->from('*****@*****.**', 'Native Physician');
$m->to($user->email, $user->name)->subject('Confirmation Code');
});
$user->save();
Session::put('user', $user);
return response()->json(['message' => 'Ok', 'code' => 'success', 'task' => 'sendEmail', 'email' => $email]);
} elseif (Request::get('task') == "sendPhone") {
/**
*
* Send the MMS including the activation code
*
*/
$smsLimit = smslimit::where('uid', '=', Session::get('userid'))->first();
if (is_null($smsLimit)) {
$smsLimit = new smslimit();
$smsLimit->uid = Session::get('userid');
$smsLimit->count = 1;
$smsLimit->save();
} else {
if ($smsLimit->count >= 2) {
return response()->json(['message' => 'you can only sent 2 SMS within a Day', 'code' => 'error', 'task' => 'sendPhone']);
} else {
$smsCount = $smsLimit->count;
$smsCount++;
$smsLimit->count = $smsCount;
$smsLimit->save();
}
}
$phone = Request::get('phone');
if (is_null($phone) || trim($phone) == "" || !preg_match("/^[0-9]{9}\$/", $phone)) {
return response()->json(['message' => 'Check your Phone number', 'code' => 'error', 'task' => 'sendPhone']);
}
$phone = "+94" . $phone;
if ($user->tp != trim($phone)) {
$checkUser = user::where('tp', $phone)->count();
if ($checkUser == 0) {
$user->tp = trim($phone);
} else {
return response()->json(['message' => 'phone already Registerd', 'code' => 'error', 'task' => 'sendPhone']);
}
}
$code = Session::get('phoneKey');
if (is_null($code)) {
return response()->json(['message' => 'Refresh the page', 'code' => 'error', 'task' => 'sendPhone']);
}
$user->save();
Session::put('user', $user);
SMS::queue('Your Confirmation Code is: ' . $code, [], function ($sms) use($phone) {
$sms->to($phone);
});
//$this->sendsms('Your Confirmation Code is: '.$code,$phone);
/*
Mail::send('mailtemplate/emailVerify', ['name'=> $user->name,'code'=>Session::get('phoneKey')], function ($m) use ($user,$phone,$code) {
$m->from('*****@*****.**', 'Your Application');
$m->to($phone."@mms.dialog.lk", $user->name)->subject($code);
});
*/
return response()->json(['message' => 'Ok', 'code' => 'success', 'task' => 'sendPhone', 'phone' => $phone]);
} elseif (Request::get('task') == "verify") {
/**
*
* Finalized the registration by comparing activation codes
*
*/
$codePhone = Request::get('codePhone');
//$codeEmail=Request::get('codeEmail');
if (!is_null($codePhone) && Session::get('phoneKey') == $codePhone) {
//if( Session::get('phoneKey')==$codePhone && Session::get('emailKey')==$codeEmail ){
$user->verified = 1;
$user->save();
Session::flush();
return response()->json(['message' => 'Ok', 'code' => 'success', 'task' => 'verify']);
} else {
return response()->json(['message' => 'Codes Missmatch', 'code' => 'error', 'task' => 'verify']);
}
}
}
/**
* Get all the JSON POST requests and process them
* Tasks
* 1. Upload the pictures and change the profile picture
* 2. Change NIC
* 3. Change Password
* 4. Change Name
* @return JSON Response
*/
public function inputs()
{
$user = Session::get('user');
if (is_null($user)) {
return response()->json(['message' => 'hacker']);
}
if (Request::get('formname') == "picture") {
/**
* Change the profile picture
*
*/
if (Input::file('pic')->isValid()) {
$allowed = array('gif', 'png', 'jpg');
$image = Input::file('pic');
if ($image->getSize() > 614348) {
return response()->json(['message' => 'File size is too large', 'code' => 'warning']);
}
if (!in_array($image->getClientOriginalExtension(), $allowed)) {
return response()->json(['message' => 'Please Upload an image', 'code' => 'error']);
}
$destinationPath = base_path() . '/../public/uploads/profile_pics';
$fullPath = 'uploads/profile_pics/' . Session::get('userid') . '.' . $image->getClientOriginalExtension();
try {
$image->move($destinationPath, Session::get('userid') . '.' . $image->getClientOriginalExtension());
} catch (Exception $e) {
return response()->json(['message' => 'Error saving the file', 'code' => 'error']);
}
$user->pic = $fullPath;
$user->save();
$this->updateSession();
return response()->json(['message' => 'Profile picture updated!', 'filename' => $fullPath, 'code' => 'success']);
} else {
return response()->json(['message' => 'Upload an different image', 'code' => 'error']);
}
} elseif (Request::get('formname') == "nicForm") {
/**
* Change the NIC
*
*/
$nic = Request::get('nic');
if ($this->regex($nic, "NIC")) {
$checkUser = user::where('nic', $nic)->count();
if ($user->nic == $nic) {
return response()->json(['message' => 'NIC updated success!', 'code' => 'success']);
} elseif ($checkUser > 0) {
return response()->json(['message' => 'NIC Already Taken', 'code' => 'error']);
}
$user->nic = $nic;
$user->save();
$this->updateSession();
return response()->json(['message' => 'NIC updated success!', 'code' => 'success']);
} else {
return response()->json(['message' => 'Check your NIC!', 'code' => 'warning']);
}
} elseif (Request::get('formname') == "passwordForm") {
/**
* Change the User Password
*
*/
$password = Request::get('password');
if ($password != '') {
$user->password = md5($password);
$user->save();
$this->updateSession();
return response()->json(['message' => 'Passowrd updated success!', 'code' => 'success']);
} else {
return response()->json(['message' => 'Check your Passowrd!', 'code' => 'warning']);
}
} elseif (Request::get('formname') == "nameForm") {
/**
* Change the User's Name
*
*/
$name = Request::get('name');
if ($name != '') {
$user->name = $name;
$user->save();
$this->updateSession();
return response()->json(['message' => 'Name updated success!', 'code' => 'success']);
} else {
return response()->json(['message' => 'Check your Name!', 'code' => 'warning']);
}
} elseif (Request::get('formname') == "tpnoFormDoctor") {
/**
* Change the Doctors working no
*
*/
$phoneNo = Request::get('tpnoWorking');
$doctor = Session::get('doctor');
if ($this->regex($phoneNo, "TP") || is_null($doctor)) {
$doctor->phone = $phoneNo;
$doctor->save();
$this->updateSession();
return response()->json(['message' => 'Working Phone Number updated success!', 'code' => 'success']);
} else {
return response()->json(['message' => 'Check your Phone Number!', 'code' => 'warning']);
}
} elseif (Request::get('task') == "available") {
$doctor = Session::get('doctor');
if (is_null($doctor)) {
return response()->json(['message' => 'hacker', 'code' => 'error', 'task' => 'available']);
}
if (Request::get('status') == "true") {
$doctor->available = 1;
$doctor->save();
Session::put('doctor', $doctor);
return response()->json(['message' => 'hacker', 'code' => 'success', 'task' => 'available', 'status' => 'true']);
} else {
$doctor->available = 0;
$doctor->save();
Session::put('doctor', $doctor);
return response()->json(['message' => 'hacker', 'code' => 'success', 'task' => 'available', 'status' => 'false']);
}
}
}
public function descargarTodo()
{
/**
* funcion de busqueda no regresa todos los campos y ocupa poner los provedores arraglar eso
**/
$busqueda = \App\productos::all();
if (!count($busqueda) > 0) {
$GLOBALS['results'] = collect(['Busqueda sin resultados']);
}
// dd($results);
$archivo = Excel::create('Busqueda_911arq.com', function ($excel) {
dd($excel);
// Set the title
$excel->setTitle('Productos');
// Chain the setters
$excel->setCreator('911arq.com')->setCompany('911arq.com');
// Call them separately
$excel->setDescription('Resultados de 911arq.com');
//$GLOBALS['results']->groupBy('user_id');
foreach ($busqueda->groupBy('user_id') as $productos) {
// optiene la informacion del provedor
$tienda = user::where('id', $productos[0]->user_id)->first();
// crea la pagina y la llama con el nombre del provedor
$excel->sheet($tienda->name, function ($sheet) use($productos, $tienda) {
$sheet->setOrientation('landscape');
// agrega 5 lineas a la pagina con la informacion del provedor y encabezados de columnas
// $sheet->appendRow(1,array($tienda->name));
dd($excel->sheet($tienda->name));
$sheet->rows(array(array($tienda->name), array($tienda->razon_social), array($tienda->direccion), array($tienda->telefono), array('----------------------RESULTADOS----------------------'), array('Producto', 'Precio', 'Codigo', 'Unidad')));
$contador = 0;
foreach ($productos as $producto) {
$sheet->appendRow(7 + $contador, array($producto->producto, $producto->precio, $producto->codigo, $producto->unidad));
$contador = $contador + 1;
}
});
//exel->sheet
}
})->download('xls');
// dd($archivo);
// $hoja =$archivo->sheet('Resultados');
//$hoja->fromArray($results->toArray());
//->fromArray($results->toArray());
//dd($hoja);
return redirect()->back();
}
public function save_user_rekanan($id)
{
$data = Rekanan::find($id);
$data->email_rkn = Input::get('username');
$data->save();
if (!empty(Input::get('password'))) {
$password = Input::get('password');
/*$user->password = Hash::make($password);
$user->get_pass = $password;*/
$user = user::where('id_users', $id)->update(array('password' => Hash::make($password), 'username' => Input::get('username'), 'get_pass' => $password));
} else {
$user = user::where('id_users', $id)->update(array('username' => Input::get('username')));
}
if ($user > 0) {
echo "ok";
} else {
echo "error";
}
}
