/**
* 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!');
}
}
