function KisiSil() { \Auth::logout(); \Session::flush(); \DB::delete('delete from users WHERE name = ?', [\Request::input('isim')]); return \Redirect::to('auth/register'); }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { \DB::delete('delete from levels where id = ?', [$id]); return redirect('level'); }
public function postEditload($id) { if (\Auth::check()) { $action = \Input::get('action'); $data = \Input::all(); // dd($data); if ($action == 'delete') { \DB::delete('delete from faculty_load where id =' . $id); } else { if ($action == 'save') { \DB::table('faculty_load')->where('id', $id)->update(array('subject' => $data['subject'], 'class' => $data['section'], 'semester' => $data['semester'], 'subj_code' => $data['subcode'], 'school_year_sy' => $data['sy'], 'school_year_users_id' => $data['id'], 'units' => $data['units'])); // \DB::update('update faculty_load set subject = .'.$data['subject'].',class=.$data['section'].', semester, subj_code, school_year_sy, school_year_users_id, year, units where id =' . $id); } } } return \Redirect::back(); }
public function moderationRecord($p_id, $status) { if (\Auth::user()->admin == true) { if (\DB::select('select 1 from moderation where p_id = ?', [$p_id])) { $p_admin = \Auth::user()->name; $date = new \DateTime(); $results = \DB::select('select * from moderation where p_id = ?', [$p_id]); if ($status == 'approve') { foreach ($results as $result) { \DB::insert('insert into public.log_moderation (p_id, p_cat, p_admin, p_status, created_at, updated_at) values (?, ?, ?, ?, ?, ?)', [$p_id, $result->p_cat, $p_admin, 'available', $date, $date]); \DB::insert('insert into stream.stream_' . $result->p_cat . ' (p_id, p_cat, p_ouser, p_title, p_caption, p_imgurl, p_status, p_reported, p_rating, created_at, updated_at) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', [$result->p_id, $result->p_cat, $result->p_ouser, $result->p_title, $result->p_caption, $result->p_imgurl, 'available', $result->p_reported, $result->p_rating, $result->created_at, $date]); \DB::delete('delete from public.moderation where p_id = ?', [$p_id]); // Membuat tabel baru. \Schema::create('comment.comment_' . $result->p_id, function ($table) { $table->string('c_ouser', 120); $table->string('c_favor'); $table->text('c_comment', 1000); $table->string('avatar'); $table->timestamps(); }); } $messages = 'The publication has been approved.'; return redirect('/admin/moderation')->with('messages', $messages); } elseif ($status == 'deny') { foreach ($results as $result) { \DB::insert('insert into public.log_moderation (p_id, p_cat, p_admin, p_status, created_at, updated_at) values (?, ?, ?, ?, ?, ?)', [$p_id, $result->p_cat, $p_admin, 'denied', $date, $date]); \DB::insert('insert into stream.stream_' . $result->p_cat . ' (p_id, p_cat, p_ouser, p_title, p_caption, p_imgurl, p_status, p_reported, p_rating, created_at, updated_at) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)', [$result->p_id, $result->p_cat, $result->p_ouser, $result->p_title, $result->p_caption, $result->p_imgurl, 'denied', $result->p_reported, $result->p_rating, $result->created_at, $date]); \DB::delete('delete from public.moderation where p_id = ?', [$p_id]); } $messages = 'The publication has been denied.'; return redirect('/admin/moderation')->with('messages', $messages); } else { $messages = 'The processing status is not valid, only "approve" or "deny".'; return redirect('/admin/moderation')->with('messages', $messages); } } else { $messages = 'There is no such publication, or publication has been processed.'; return redirect('/admin/moderation')->with('messages', $messages); } } else { $messages = 'You are not an admin. No rights to access administration area.'; return redirect('/system/notification')->with('messages', $messages); } }
public function getConfirmWithParam($action, $id) { if ($action == 1) { if (\DB::table('auth_telegram')->where('id', $id)->where('confirmed', false)->update(['confirmed' => true])) { $messages = 'A User is Confirmed.'; return redirect('/confirm')->with('messages', $messages); } else { $messages = 'Error.'; return redirect('/confirm')->with('messages', $messages); } } elseif ($action == 2) { if (\DB::table('auth_telegram')->where('id', $id)->where('confirmed', true)->update(['confirmed' => false])) { $messages = 'A User is Released.'; return redirect('/confirm')->with('messages', $messages); } else { $messages = 'Error.'; return redirect('/confirm')->with('messages', $messages); } } elseif ($action == 3) { if (\DB::delete('delete from auth_telegram where id = ? and confirmed = false', [$id])) { $messages = 'A User is Deleted.'; return redirect('/confirm')->with('messages', $messages); } else { $messages = 'Error.'; return redirect('/confirm')->with('messages', $messages); } } else { $messages = 'Error.'; return redirect('/confirm')->with('messages', $messages); } }
public function edit() { //check for integer in quantity if (!(Input::get('quantity') >= 0 && Input::get('quantity') < 1000)) { Session::flash('type', "danger"); Session::flash('message', "Please enter a quantity between 1 and 1000"); return Redirect::back(); } if (!Auth::check()) { //create unregistered user and a new make for them $user = new User(); $user->save(); Auth::login($user); } //save cookes for new user if (!Session::has('order')) { //create new order $order = new Order(); $order->user_id = Auth::user()->id; $order->status = 'Open'; $order->save(); Session::put('order', $order->id); Session::put('orderCount', 0); } //return Session::has('order'); $quantity = Input::get('quantity'); $product_id = Input::get('product_id'); $colour_hex = Input::get('colour_hex'); $colour_name = Input::get('colour_name'); $action_id = Input::get('action_id'); $order = Order::with('product')->find(Session::get('order')); //if order bnot open then send to dash with message if ($order->status !== 'Quote' && $order->status !== 'Open') { Session::flash('message', 'This order is locked. Please click \'Start a new quote\' below to begin another order'); Session::flash('alert-class', "alert-danger"); return Redirect::to('users/dashboard'); } //return $order; //derach product is the same as existing //$order->product()->detach($product_id, ['hex' => $colour_hex]); \DB::delete('delete from order_product where order_id = ? AND product_id = ? AND hex = ?', array($order->id, $product_id, $colour_hex)); //attach if not 0 if (Input::get('quantity') != 0) { $order->product()->attach($product_id, ['quantity' => $quantity, 'colour' => $colour_name, 'hex' => $colour_hex]); } //count them again $updatedOrder = Order::with('product')->find(Session::get('order')); $orderCount = 0; foreach ($updatedOrder->product as $products) { $orderCount = $orderCount + 1; } //return $orderCount; Session::put('orderCount', $orderCount); //set message depending od whethet order is open or quote if ($order->status !== 'Open') { Session::flash('registerMessage', "You are updating an existing quote. When you are happy please click the green button below to confirm your update."); Session::flash('type', "danger"); return redirect()->route('orders.show', [$order->id]); } //updating quantities if ($action_id == 'update') { return redirect()->route('orders.show', [$order->id]); } Session::flash('message', $quantity . " of these have been added to your quote"); Session::flash('type', "success"); return Redirect::back()->withCookie(cookie('user_id', Auth::user()->id, 3600)); //return $quantity; }