/** * Page Acceuil */ public function dashboard() { // $redirectUrl = $response->links[1]->href; $nbacteurs = Actors::count(); $nbcommentaires = Comments::count(); $nbmovies = Movies::count(); $nbseances = Sessions::count(); $actor = new Actors(); // Je récpere mon modèle $comment = new Comments(); // Je récpere mon modèle $movie = new Movies(); // Je récpere mon modèle $session = new Sessions(); // Je récpere mon modèle $user = new User(); // Je récpere mon modèle $avgacteurs = $actor->getAvgActors(); $avgnotecommentaire = $comment->getAvgNote(); $avgnotepresse = $movie->getAvgNotePresse(); $avghour = $session->getAvgHourDate(); $seances = $session->getNextSession(); $users = $user->getLastUsers(); /* $seances = Sessions::where("date_session", ">", DB::raw("NOW()")) ->take(15)->get(); */ return view('Main/dashboard', ['avgnotecommentaire' => $avgnotecommentaire->avgnote, 'avgnotepresse' => $avgnotepresse->avgpress, 'avgacteurs' => $avgacteurs->age, 'avghour' => $avghour->avghour, 'nbacteurs' => $nbacteurs, 'nbcommentaires' => $nbcommentaires, 'nbmovies' => $nbmovies, 'nbseances' => $nbseances, 'seances' => $seances, 'users' => $users]); }
public function dashboard() { // METHODE ORM $nbacteurs = Actors::count(); $nbcommentaire = Commentaire::count(); $avgcommentaire = Commentaire::avg('note'); $countnotepresse = Movies::count('note_presse'); $avgnotepresse = Movies::avg('note_presse'); $moviescount = Movies::count('id'); $avgmovies = Movies::avg('duree'); $actor = new Actors(); //methode query builder $avgacteur = $actor->getAvgActors(); $notepresse2 = new Movies(); $countnotepresse2 = $notepresse2->getAvgNoteMovies(); $avgsession = Sessions::count('id'); $session = new Sessions(); $sessionavg = $session->getAvgSession2(); $lastuser = new User(); $last = $lastuser->getLastUsers(); // 15 prochaine (TROISIEME METHODE ) $nextsession = Sessions::where('date_session', "<", Carbon::now())->take(15)->get(); // premiere methode avec 2 jointures : $seance = new Sessions(); $resultseance = $seance->getNextSession(); $allcategories = Categories::all(); $alldirectors = Directors::count('id'); $distrib = new Movies(); $distributeur = $distrib->countDistributeur(); $villeacteur = new Actors(); $villebyacteur = $villeacteur->getVilleByActors(); // exit(dump($villebyacteur )); return view('Main/dashboard', ['nbacteurs' => $nbacteurs, 'nbcommentaire' => $nbcommentaire, 'avgacteur' => $avgacteur->age, 'avgcommentaire' => $avgcommentaire, 'avgnotepresse' => $avgnotepresse, 'countnotepresse' => $countnotepresse, 'moviescount' => $moviescount, 'avgmovies' => $avgmovies, 'countnotepresse2' => $countnotepresse2->note, 'avgsession' => $avgsession, 'sessionavg' => $sessionavg->date, 'last' => $last, 'nextsession' => $nextsession, 'allcategories' => $allcategories, 'alldirectors' => $alldirectors, 'distributeur' => $distributeur, 'villeacteur' => $villebyacteur]); }
/** * Execute the console command. * * @return mixed */ public function handle() { $number = $this->ask('how many LoginCodes do you want to create. (int)'); for ($i = 0; $i < $number; $i++) { $votekey = new User(); $votekey->usernumber = date('Yis') . str_pad(rand(0, 999999999), 9, '0', STR_PAD_LEFT); $votekey->password_readable = str_pad(rand(0, 9999), 4, '0', STR_PAD_LEFT); $votekey->password = Hash::make($votekey->password_readable); $votekey->save(); } $this->info("You generated '{$number}' LoginCodes"); }
/** * Bootstrap any application services. * * @return void */ public function boot() { //this custom validator Validator::extend('unique_email', function ($attribute, $value, $parameters) { $user = new User(); $userCollection = $user->getCollection(); $result = $userCollection->findOne(['email' => $value], ['email']); if (!$result) { return true; } return false; }); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { //$users = Action::all(); $users = $this->_searchQuery(User::where('deleted_at', '=', null))->paginate(20); $context = ['users' => $users]; return view('client.action.index', $context); }
public function __construct() { if (Auth::check()) { $this->categories = User::find(Auth::user()->id)->category()->get(); View::share('categories', $this->categories); } }
public function register(Request $request) { $rules = array('email_input' => 'required|email', 'pass_input' => 'required', 're_pass_input' => 'required', 'first_name_input' => 'required', 'last_name_input' => 'required', 'phone_input' => 'required'); $validator = Validator::make($request->all(), $rules); if (!$validator->fails()) { //cek input form $pass = $request->pass_input; $re_pass = $request->re_pass_input; $permissions = array('user.update' => false); $user = array('email' => $request->email_input, 'password' => $pass, 'first_name' => $request->first_name_input, 'last_name' => $request->last_name_input, 'phone' => $request->phone_input, 'status' => '0', 'permissions' => $permissions); if ($pass == $re_pass) { if (is_null(Sentinel::findByCredentials($user))) { //cek email $register = Sentinel::register($user); $new_member = User::find($register->id); $new_member->phone = $request->phone_input; $new_member->status = '0'; $new_member->save(); Activation::create($register); $getActive = Activations::where('user_id', $register->id)->first(); // get key code from activation table $this->SendConfirmationEmail($request->email_input, $getActive->code, $register->id, $user); // send email, key, id, data($user) to mail return redirect('login_form')->with('success', 'Pendaftaran berhasil kode aktivasi akun telah dikirimkan. Silahkan cek email Anda.'); } else { return redirect('daftar')->with('error', 'Maaf email Anda sudah terdaftar'); } } else { return redirect('daftar')->with('error', 'Password tidak cocok'); } } else { return redirect('daftar')->with('error', 'Silahkan isi semua form'); } }
public function getSuccessPayment(Request $request) { $admin = User::where(['type' => 'admin'])->first(); $gateway = Omnipay::create('PayPal_Express'); $gateway->setUsername('fai1999.fa_api1.gmail.com'); $gateway->setPassword('N8MALTPJ39RD3MG7'); $gateway->setSignature('AVieiSDlpAV8gE.TnT6kpOEjJbTKAJJakY.PKQSfbkf.rc2Gy1N7vumm'); $gateway->setTestMode(true); $params = Session::get('params'); $response = $gateway->completePurchase($params)->send(); $paypalResponse = $response->getData(); // this is the raw response object if (isset($paypalResponse['PAYMENTINFO_0_ACK']) && $paypalResponse['PAYMENTINFO_0_ACK'] === 'Success') { // Response // print_r($paypalResponse); } else { //Failed transaction } $count = Transaction::where(['transactionid' => $paypalResponse['PAYMENTINFO_0_TRANSACTIONID']])->count(); if ($count < 1) { Transaction::create(['senderid' => Auth::user()->id, 'transactionid' => $paypalResponse['PAYMENTINFO_0_TRANSACTIONID'], 'amount' => $paypalResponse['PAYMENTINFO_0_AMT'], 'recipientid' => $admin->id]); $balance = Balance::where(['userid' => Auth::user()->id])->first(); $balance = $balance->balance + $paypalResponse['PAYMENTINFO_0_AMT']; Balance::where(['userid' => Auth::user()->id])->update(['balance' => $balance]); } if (Auth::user()->type != 'admin') { return redirect()->route('transactions'); } }
public function run() { $faker = Faker::create(); for ($i = 0; $i < 50; $i++) { User::create(['username' => $faker->firstNameMale, 'email' => $faker->safeEmail, 'password' => bcrypt('wintala')]); } }
public function getLastUsers($nb = null) { return User::orderBy('created_at', 'desc')->take($nb)->get(); // return DB::table('user') // ->orderBy('created_at', 'desc') // ->take($nb) // ->get(); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(CategoryRequest $request) { try { User::find(Auth::user()->id)->category()->create($request->all()); } catch (Exception $e) { echo 'Error Add Category: ' . $e->getMessage(); } return redirect('admin/categories')->with('message', 'Category successfully added!'); }
/** * This method show the user's dashboard * @return \Illuminate\View\View */ public function getIndex() { //We get the user information and remove the password and token from the response $user_profile = User::findBy(['_id' => Auth::user()->_id], ['password' => false, 'token' => false, 'token' => false]); if (!$user_profile) { Abort(404); } return view('user.dashboard', ['user_profile' => $user_profile]); }
public function list_user() { $this->data['css_assets'] = Assets::load('css', ['admin_bootstrap', 'admin_css', 'font-awesome', 'skins', 'dataTables_css']); $this->data['js_assets'] = Assets::load('js', ['jquery', 'admin_js', 'admin_bootstrap-js', 'slimscroll', 'fastclick', 'dataTables_js', 'dataTables_bootsjs']); $this->data['title'] = 'User | List'; $this->data['user'] = User::all(); $this->data['userCount'] = User::all()->count(); return view('admin_layout')->with('data', $this->data)->nest('content', 'admin/user/user_list', array('data' => $this->data)); }
public function main_layout() { $this->data['css_assets'] = AppAssets::load('css', ['bootstrap', 'animate', 'font-awesome', 'icon', 'font', 'app']); $this->data['js_assets'] = AppAssets::load('js', ['jquery', 'bootstrap', 'app', 'jquery-slimscroll', 'app-plugin']); $this->data['title'] = 'Dashboard'; $this->data['member_count'] = User::all()->count(); $this->data['this_month'] = date('Y-m-d', strtotime('-1 Month')); $this->data['new_member_count'] = User::where(DB::raw('DATE(created_at)'), '>=', $this->data['this_month'])->count(); return view('app/components/main_layout')->with('data', $this->data)->nest('content', 'app/home/main', array('data' => $this->data)); }
public function dashboard() { //compter les objets Actors $nbacteurs = Actors::count(); //compter les objets Comments $nbcommentaires = Comments::count(); //compter les objets Movies $nbfilms = Movies::count(); //compter les objets Session $nbseances = Sessions::count(); //compter les objets User $nbusers = User::count(); //compter les objets Categories $nbcategories = Categories::count(); //compter les objets Directors $nbdirectors = Directors::count(); //compter les objets Medias $nbmedias = Medias::count(); //moyenne d'age des Actors $actor = new Actors(); $moyenne_acteurs = $actor->getAvgActors(); //moyenne des Comments $comment = new Comments(); $moyenne_commentaires = $comment->getAvgComments(); //moyenne des Movies $movie = new Movies(); $moyenne_presse = $movie->getAvgMovies(); //moyenne des Sessions $session = new Sessions(); $moyenne_seance = $session->getAvgSessions(); //liste des 24 derniers Users $user = new User(); $liste_users = $user->getLastUsers(24); //Pourcentage des films par distributeurs $movies_distributeur = $movie->getMoviesDistributeur(); //liste des 15 prochaines Sessions $session = new Sessions(); $liste_sessions = $session->getNextSessions(15); //pour utilisation de la 3ème méthode //qui retourne un timestamp $moyenne_acteurs = \Carbon\Carbon::createFromTimestamp($moyenne_acteurs); return view("Main/dashboard", ['nbacteurs' => $nbacteurs, 'moyenne_acteurs' => $moyenne_acteurs->diffInYears(), 'nbcommentaires' => $nbcommentaires, 'nbfilms' => $nbfilms, 'moyenne_commentaires' => round($moyenne_commentaires), 'moyenne_presse' => round($moyenne_presse), 'nbseances' => $nbseances, 'moyenne_seance' => round($moyenne_seance->moyenne), 'nbusers' => $nbusers, 'liste_users' => $liste_users, 'liste_sessions' => $liste_sessions, 'nbcategories' => $nbcategories, 'nbdirectors' => $nbdirectors, 'nbmedias' => $nbmedias, 'movies_distributeur' => $movies_distributeur]); }
/** * This method show the user's profile * @return \Illuminate\View\View */ public function getIndex($username) { //We get the user information and remove the password and token from the response $user_profile = User::findBy(['username' => $username], ['password' => false, 'token' => false, 'token' => false]); if (!$user_profile) { Abort(404); } //var_dump($user_profile); return view('user.profile', ['user_profile' => $user_profile]); }
public function getDropbox(&$contents, $tid) { $user = User::getVlasmarktUser(); $images = Dbox::getRelated(); foreach ($images as $image) { $data = $image->toArray(); if (!isset($tid)) { $tid = 0; } $contents[$data['tid'] != $tid ? (string) $data['tid'] : 0] = array('tid' => $data['tid'], 'content' => '/store/dropbox/' . $data['content'], 'user' => $user[0]->name, 'url' => $user[0]->url); } ksort($contents); }
public function tambahadminprovinsi(Request $request) { $rules = ['nama' => 'required|max:255', 'email' => 'required|unique:users', 'provinsi' => 'required|numeric']; $v = Validator::make($request->all(), $rules); if ($v->fails()) { return redirect()->back()->withInput($request->all())->withErrors($v); } else { $user = new User(); $user->username = $request->input('nama'); $user->email = $request->input('email'); $user->password = bcrypt($request->input('nama')); $user->save(); $userid = User::max('id'); $role = new UserRole(); $role->user_id = $userid; $role->role_id = 3; $role->save(); $provinsi = new AdminProvinsi(); $provinsi->user_id = $userid; $provinsi->provinsi_id = $request->input('provinsi'); $provinsi->save(); return redirect()->back()->with('message', 'Admin provinsi berhasil ditambah!'); } }
/** * Run the database seeds. * * @return void */ public function run() { Model::unguard(); DB::table('audience')->insert(array(array('audience_type' => 'קהל 1'), array('audience_type' => 'קהל 2'), array('audience_type' => 'קהל 3'), array('audience_type' => 'קהל 4'), array('audience_type' => 'קהל 5'))); DB::table('content_area')->insert(array(array('area' => 'תחום 1'), array('area' => 'תחום 2'), array('area' => 'תחום 3'), array('area' => 'תחום 4'), array('area' => 'תחום 5'))); DB::table('difficulty_level')->insert(array(array('level' => 'רמה 1'), array('level' => 'רמה 2'), array('level' => 'רמה 3'), array('level' => 'רמה 4'), array('level' => 'רמה 5'))); DB::table('user_types')->insert(array(array('type' => 'admin'), array('type' => 'editor'))); DB::table('users')->delete(); $admin = UserTypes::where('type', 'admin')->first(); $editor = UserTypes::where('type', 'editor')->first(); $users = array(['name' => 'admin', 'email' => '*****@*****.**', 'password' => Hash::make('P@ssw0rd'), 'type_id' => $admin->id], ['name' => 'editor', 'email' => '*****@*****.**', 'password' => Hash::make('P@ssw0rd'), 'type_id' => $editor->id]); // Loop through each user above and create the record for them in the database foreach ($users as $user) { User::create($user); } Model::reguard(); }
public function insert() { try { $interest = implode(",", Request::input('interest')); } catch (Exception $e) { } User::create(['name' => Request::input('name'), 'lastname' => Request::input('lastname'), 'username' => Request::input('username'), 'password' => Request::input('password'), 'sex' => Request::input('sex'), 'date_of_birth' => Request::input('date_of_birth'), 'interest' => $interest]); // $user = new User; // $user->username = Request::input('name'); // $user->lastname = Request::input('lastname'); // $user->username = Request::input('username'); // $user->password = Request::input('password'); // $user->sex = Request::input('sex'); // $user->date_of_birth = Request::input('date_of_birth'); // $user->interest = Request::input('interest'); // $user->save(); return redirect('data_table'); }
/** * Page Acceuil */ public function dashboard() { $nbacteurs = Actors::count(); $nbcommentaires = Comments::count(); $nbmovies = Movies::count(); $nbseances = Sessions::count(); $actor = new Actors(); // Je récpere mon modèle $comment = new Comments(); // Je récpere mon modèle $movie = new Movies(); // Je récpere mon modèle $session = new Sessions(); // Je récpere mon modèle $user = new User(); // Je récpere mon modèle $avgacteurs = $actor->getAvgActors(); $avgnotecommentaire = $comment->getAvgNote(); $avgnotepresse = $movie->getAvgNotePresse(); $avghour = $session->getAvgHourDate(); $seances = $session->getNextSession(); $users = $user->getLastUsers(); return view('Main/dashboard', ['avgnotecommentaire' => $avgnotecommentaire->avgnote, 'avgnotepresse' => $avgnotepresse->avgpress, 'avgacteurs' => $avgacteurs->age, 'avghour' => $avghour->avghour, 'nbacteurs' => $nbacteurs, 'nbcommentaires' => $nbcommentaires, 'nbmovies' => $nbmovies, 'nbseances' => $nbseances, 'seances' => $seances, 'users' => $users]); }
public function postEdit($id) { $data = User::getUserById($id); $username = $data->username; $email = $data->email; $rls = User::$rules; $rljp = User::$ruleJp; if ($username == Input::get('username')) { unset($rls['username']); unset($rljp['username']); } if ($email == Input::get('email')) { unset($rls['email']); unset($rljp['email']); } if (Input::get('password') == null) { unset($rls['password']); unset($rljp['password']); } if (Input::get('password') == null) { $data_kana = array('username' => Input::get('username'), 'email' => Input::get('email'), 'full_name' => Input::get('full_name'), 'furigana' => Input::get('furigana'), 'status' => Input::get('status'), 'last_login' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')); $data = array('username' => Input::get('username'), 'email' => Input::get('email'), 'full_name' => Input::get('full_name'), 'status' => Input::get('status'), 'last_login' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')); } else { $data_kana = array('username' => Input::get('username'), 'email' => Input::get('email'), 'password' => Hash::make(Request::input('password')), 'full_name' => Input::get('full_name'), 'furigana' => Input::get('furigana'), 'status' => Input::get('status'), 'last_login' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')); $data = array('username' => Input::get('username'), 'email' => Input::get('email'), 'password' => Hash::make(Request::input('password')), 'full_name' => Input::get('full_name'), 'status' => Input::get('status'), 'last_login' => date('Y-m-d H:i:s'), 'updated_at' => date('Y-m-d H:i:s')); } if (LaravelLocalization::getCurrentLocale() == 'vi') { $massages = User::$vi_msg; $rule = $rls; $inputData = $data; } elseif (LaravelLocalization::getCurrentLocale() == 'en') { $inputData = $data; $massages = User::$en_msg; $rule = $rls; } else { $massages = User::$ja_msg; $inputData = $data_kana; $rule = $rljp; } $validator = Validator::make(Input::all(), $rule, $massages); if ($validator->passes()) { DB::table('users')->where('id', $id)->update($inputData); Session::flash('success', trans('common.user_edit_succ_msg')); return Redirect::to(LaravelLocalization::getCurrentLocale() . '/admin/account'); } return Redirect::to(LaravelLocalization::getCurrentLocale() . '/admin/account/edit/' . $id)->withErrors($validator)->withInput(); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $post = Post::findOrFail($id); $nameUser = User::where('id', $post->user_id)->lists('first_name'); return view('admin.post.edit', compact('post', 'nameUser')); }
public function postContactEmail(Request $request) { if (Auth::user()->type == 'student') { $admin = User::where(['type' => 'admin'])->first(); if ($request->hasFile('uploadedfile')) { $filepath = $request->file('uploadedfile')->getRealPath(); $fileextension = $request->file('uploadedfile')->getClientOriginalExtension(); $filetype = $request->file('uploadedfile')->getMimeType(); Mail::send('emails.contacttutor', ['content' => $request->input('message'), 'tutoremail' => $request->input('tutoremail')], function ($message) use($admin, $filepath, $fileextension, $filetype) { $message->from(Auth::user()->email, Auth::user()->name); $message->to($admin->email, 'Admin')->subject('Tutor Time'); $message->attach($filepath, array('as' => 'studentfile.' . $fileextension, 'mime' => $filetype)); }); } else { Mail::send('emails.contacttutor', ['content' => $request->input('message'), 'tutoremail' => $request->input('tutoremail')], function ($message) use($admin) { $message->from(Auth::user()->email, Auth::user()->name); $message->to($admin->email, 'Admin')->subject('Tutor Time'); }); } return redirect()->back()->with('msg', 'Successfully sent message'); } else { return '404 page not found'; } }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $userInformations = User::find(Auth::user()->id)->get(); return view('layouts.user.dashboard', ['userInformations']); }
public function changeAvatar(Request $request) { $response = new stdClass(); if ($request->isMethod('post')) { $postData = $request->all(); $objUserModel = new User(); $userId = ""; if (isset($postData['user_id'])) { $userId = $postData['user_id']; } $authFlag = false; if (isset($postData['api_token'])) { if ($userId != '') { $apiToken = $postData['api_token']; if ($apiToken == $this->API_TOKEN) { $authFlag = true; } else { $where = ['rawQuery' => 'id=?', 'bindParams' => [$userId]]; $selectColumn = array('login_token'); $userCredentials = $objUserModel->getUsercredsWhere($where, $selectColumn); if ($userCredentials) { if ($apiToken == $userCredentials->login_token) { $authFlag = true; } } } } } if ($authFlag) { if ($userId != '') { if (Input::hasFile('file')) { $validator = Validator::make($request->all(), ['file' => 'image']); if (!$validator->fails()) { $destinationPath = $_SERVER['DOCUMENT_ROOT'] . '/../../web/public/assets/uploads/useravatar/'; $fileName = $userId . '_' . time() . ".jpg"; File::makeDirectory($destinationPath, 0777, true, true); $filePath = $destinationPath . $fileName; $quality = 70; //$this->imageQuality(Input::file('file')); Image::make(Input::file('file'))->resize($this->imageWidth, $this->imageHeight, function ($constraint) { $constraint->aspectRatio(); })->save($destinationPath . $fileName, $quality); $filePathUpdate = '/assets/uploads/useravatar/' . $fileName; $updateData['profile_pic'] = $filePathUpdate; $where = ['rawQuery' => 'id =?', 'bindParams' => [$userId]]; $userData = $objUserModel->getUsercredsWhere($where); $updatedResult = $objUserModel->UpdateUserDetailsbyId($where, $updateData); if ($updatedResult) { if ($userData->profile_pic != '') { File::delete(public_path() . '/../../web/public' . $userData->profile_pic); } $response->code = 200; $response->message = "Successfully updated profile image."; $response->data = $filePathUpdate; echo json_encode($response); } else { $response->code = 400; $response->message = "Something went wrong, please try again."; $response->data = null; echo json_encode($response); } } else { $response->code = 100; $response->message = $validator->messages(); $response->data = null; echo json_encode($response); } } else { $response->code = 400; $response->message = "Give correct input and Input Image files should be(jpg,gif,png,jpeg)only"; $response->data = null; echo json_encode($response, true); } } else { $response->code = 400; $response->message = "You need to login to change Avtar."; $response->data = null; echo json_encode($response, true); } } else { $response->code = 401; $response->message = "Access Denied"; $response->data = null; echo json_encode($response, true); } } else { $response->code = 400; $response->message = "Request not allowed"; $response->data = null; echo json_encode($response, true); } }
/** * Page Dashboard. */ public function dashboard() { $nbacteurs = Actors::count(); $nbcommentaires = Comments::count(); $nbmovies = Movies::count(); $nbseances = Sessions::count(); $manager = new \MongoDB\Driver\Manager('mongodb://localhost:27017'); $collection = new \MongoDB\Collection($manager, 'laravel', 'videos'); $videos = collect($collection->find()->toArray())->shuffle(); $collection = new \MongoDB\Collection($manager, 'laravel', 'stats'); $youtubeinfo = collect($collection->find(['origin' => 'Youtube'])->toArray())->first(); $collection = new \MongoDB\Collection($manager, 'laravel', 'stats'); $tweeterinfo = collect($collection->find(['origin' => 'Twitter', 'type' => 'infos'])->toArray())->first(); $actor = new Actors(); // Je récpere mon modèle $comment = new Comments(); // Je récpere mon modèle $movie = new Movies(); // Je récpere mon modèle $session = new Sessions(); // Je récpere mon modèle $user = new User(); // Je récpere mon modèle $avgacteurs = $actor->getAvgActors(); $avgnotecommentaire = $comment->getAvgNote(); $avgnotepresse = $movie->getAvgNotePresse(); $avghour = $session->getAvgHourDate(); $seances = $session->getNextSession(); $users = $user->getLastUsers(); return view('Main/dashboard', ['avgnotecommentaire' => $avgnotecommentaire->avgnote, 'avgnotepresse' => $avgnotepresse->avgpress, 'avgacteurs' => $avgacteurs->age, 'videos' => $videos, 'video' => $videos[0], 'youtubeinfo' => $youtubeinfo->data, 'tweeterinfo' => $tweeterinfo['data'][0], 'youtubeinfodateupdated' => $youtubeinfo->created, 'tweeterinfodateupdated' => $tweeterinfo['created_at'], 'avghour' => $avghour->avghour, 'nbacteurs' => $nbacteurs, 'nbcommentaires' => $nbcommentaires, 'nbmovies' => $nbmovies, 'nbseances' => $nbseances, 'seances' => $seances, 'users' => $users]); }
public function tempajax(Request $request) { $response = new stdClass(); if ($request->isMethod('post')) { $postData = $request->all(); $objUserModel = new User(); $objOrderModel = new Order(); $userId = isset($postData['user_id']) ? $postData['user_id'] : ''; $authFlag = false; if (isset($postData['api_token'])) { $apiToken = $postData['api_token']; if ($apiToken == $this->API_TOKEN) { $authFlag = true; } else { if ($userId != '') { $where = ['rawQuery' => 'id=?', 'bindParams' => [$userId]]; $selectColumn = array('login_token'); $userCredentials = $objUserModel->getUsercredsWhere($where, $selectColumn); if ($apiToken == $userCredentials->login_token) { $authFlag = true; } } } } if ($authFlag) { $validator = Validator::make($postData, ['user_id' => 'required']); if (!$validator->fails()) { $requestParam = json_decode($postData['requestData'], true); $iTotalRecords = $iDisplayLength = intval($requestParam['length']); $iDisplayLength = $iDisplayLength < 0 ? $iTotalRecords : $iDisplayLength; $iDisplayStart = intval($requestParam['start']); $sEcho = intval($requestParam['draw']); $whereOderUserID = ['rawQuery' => 'by_user_id=? and orders.status!=6', 'bindParams' => [$userId]]; $data = ['orders.order_id', 'orders.server_order_id', 'orders.ins_url', 'orders.quantity_total', 'orders.price', 'orders.quantity_done', 'orders.status', 'orders.added_time', 'orders.updated_time', 'plans.plan_name', 'plans.supplier_server_id']; //GET TOTAL NUMBER OF NEW ORDERS $iTotalRecords = count($objOrderModel->getOrderHistory($whereOderUserID, $data)); $iTotalFilteredRecords = $iTotalRecords; $records = array(); $records["data"] = array(); $columns = array('orders.order_id', 'plans.plan_name', 'orders.ins_url', 'orders.quantity_total', 'orders.price', 'orders.added_time', 'orders.updated_time', 'orders.status'); $sortingOrder = ""; if (isset($requestParam['order'])) { $sortingOrder = [$columns[$requestParam['order'][0]['column'] - 1], $requestParam['order'][0]['dir']]; } //FIRLTERING START FROM HERE $filteringRules = ''; if (isset($requestParam['action']) && $requestParam['action'] == 'filter' && $requestParam['action'][0] != 'filter_cancel') { if ($requestParam['search_order_id'] != '') { $filteringRules[] = "( orders.order_id LIKE '%" . $requestParam['search_order_id'] . "%' )"; } if ($requestParam['search_service_type'] != '') { $filteringRules[] = "( plans.plan_name LIKE '%" . $requestParam['search_service_type'] . "%' )"; } if ($requestParam['search_link'] != '') { $filteringRules[] = "( orders.ins_url LIKE '%" . $requestParam['search_link'] . "%' )"; } if ($requestParam['search_amount'] != '') { $filteringRules[] = "( orders.quantity_total LIKE '%" . $requestParam['search_amount'] . "%' )"; } if ($requestParam['search_price'] != '') { $filteringRules[] = "( orders.price LIKE '%" . $requestParam['search_price'] . "%' )"; } if ($requestParam['search_status'] != '') { $filteringRules[] = "( orders.status LIKE '%" . $requestParam['search_status'] . "%' )"; } if (!empty($filteringRules)) { $whereOderUserID['rawQuery'] .= " AND " . implode(" AND ", $filteringRules); $iTotalFilteredRecords = count($objOrderModel->getOrderHistory($whereOderUserID, $data)); } } $ordersResult = $objOrderModel->getAllOrders($whereOderUserID, $sortingOrder, $iDisplayStart, $iDisplayLength); $records['data'] = $ordersResult; $records["draw"] = $sEcho; $records["recordsTotal"] = $iTotalRecords; $records["recordsFiltered"] = $iTotalFilteredRecords; if ($ordersResult) { foreach ($ordersResult as $order) { $order->added_time = $this->getDateDifference($order->added_time); $order->updated_time = $this->getDateDifference($order->updated_time); } $response->code = 200; $response->message = "Success"; $response->data = $records; echo json_encode($response, true); } else { $response->code = 401; $response->message = "Error in connection please try again."; $response->data = null; echo json_encode($response, true); } } else { $response->code = 401; $response->message = $validator->messages(); $response->data = null; echo json_encode($response, true); } } else { $response->code = 401; $response->message = "Access Denied"; $response->data = null; echo json_encode($response, true); } } else { $response->code = 400; $response->message = "Request not allowed"; $response->data = null; echo json_encode($response, true); } }
public function getLastUsers() { $user = User::orderBy('created_at')->take(24)->get(); return $user; }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $rules = ['nama' => 'required|max:255', 'nik' => 'required|numeric', 'tempat' => 'required|max:50', 'tanggal' => 'required', 'agama' => 'required', 'jkel' => 'required', 'status' => 'required', 'pendidikan' => 'required', 'pekerjaan' => 'required', 'suku' => 'required', 'provinsi' => 'required', 'kabupaten' => 'required', 'kecamatan' => 'required', 'kelurahan' => 'required|max:100', 'alamat' => 'required|max:100']; $v = Validator::make($request->all(), $rules); if ($v->fails()) { return redirect()->back()->withInput($request->all())->withErrors($v); } else { $user = new User(); $user->username = $request->input('nik'); $user->email = $request->input('nik') . '@simetris.go.id'; $user->password = bcrypt($request->input('nik')); $user->save(); $userid = User::max('id'); $penduduk = new Penduduk(); $penduduk->user_id = $userid; $penduduk->nama_lengkap = $request->input('nama'); $penduduk->nik = $request->input('nik'); $penduduk->no_rekam_medis = $this->nomerRM($userid); $penduduk->tempat_lahir = $request->input('tempat'); $penduduk->tanggal_lahir = $request->input('tanggal'); $penduduk->agama = $request->input('agama'); $penduduk->jenis_kelamin = $request->input('jkel'); $penduduk->status = $request->input('status'); $penduduk->pendidikan = $request->input('pendidikan'); $penduduk->pekerjaan = $request->input('pekerjaan'); $penduduk->suku_bangsa = $request->input('suku'); $penduduk->alamat = $request->input('alamat'); $penduduk->kelurahan = $request->input('kelurahan'); $penduduk->kecamatan_id = $request->input('kecamatan'); $penduduk->save(); return redirect()->back()->with('message', 'Data registrasi pasien berhasil!'); } }