/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request) { $subCategory = SubCategory::where('id', $request['subCategoryID'])->first(); $subCategory->name = $request['name']; $subCategory->save(); \Session::flash('success', $request['name'] . ' has been successfully updated!'); return redirect()->back(); }
public function getSub($category_id) { $branchId = Input::get('branch_id'); $sub_category_id = Input::get('data'); $suCategoriesName = SubCategory::where('category_id', '=', $category_id)->where('branch_id', '=', $branchId)->get(); foreach ($suCategoriesName as $subCategoryName) { if ($subCategoryName->id == $sub_category_id) { echo '<option value = "' . $subCategoryName->id . '" selected> ' . $subCategoryName->name . ' </option> '; } else { echo "<option value = {$subCategoryName->id} > {$subCategoryName->name}</option> "; } } }
public function getResponders(Request $request) { $subCategory = $request['sub_category']; $objSubCategory = SubCategory::where('slug', '=', $subCategory)->first(); $objCaseResponder = CaseResponder::where('category', '=', $objSubCategory->category)->where('sub_category', '=', $objSubCategory->id)->first(); if ($objCaseResponder->sub_sub_category == 0) { $firstResponders = explode(",", $objCaseResponder->first_responder); $response = array(); foreach ($firstResponders as $firstResponder) { $user = \DB::table('users')->join('departments', 'users.department', '=', 'departments.id')->join('positions', 'users.position', '=', 'positions.id')->where('users.id', '=', $firstResponder)->select(\DB::raw("\n `users`.`id`,\n `users`.`email`,\n (select CONCAT(`users`.`name`, ' ',`users`.`surname`) ) as names,\n `departments`.`name` as department,\n `positions`.`name` as position\n\n "))->first(); $response[] = $user; } return $response; } }
public function child_category($slug) { $category = SubSubCategory::where('slug', '=', $slug)->first(); $keyword = Input::has('keyword') ? Input::get('keyword') : null; $cat_id = $category->category_id; $sub_cat_id = $category->sub_category_id; $main_cat = Category::where('id', '=', $cat_id)->first(); $sub_cat = SubCategory::where('id', '=', $sub_cat_id)->first(); if ($category === null) { return redirect('/search'); } else { $products = $this->searchProduct(null, null, $slug); //$products = Product::where('sub_sub_category_id', $category->id)->paginate(12); return view('search.search', compact('products', 'category', 'main_cat', 'sub_cat', 'keyword')); } }
if ($from == 'category') { $object = Category::where('slug', '=', $name)->first(); $listing = DB::table('sub_categories')->where('category', '=', $object->id)->lists('name', 'slug'); } if ($from == 'sub_category') { $object = SubCategory::where('slug', '=', $name)->first(); $listing = DB::table('sub_sub_categories')->where('sub_category', '=', $object->id)->lists('name', 'slug'); } return $listing; }); Route::get('/api/dropdownCategory/{to}/{from}', function ($to, $from) { $name = Input::get('option'); if ($from == 'category') { $object = Category::where('slug', '=', $name)->first(); } else { $object = SubCategory::where('slug', '=', $name)->first(); } if ($from == 'category') { $listing = DB::table('sub-categories')->where('category', '=', $object->id)->lists('name', 'slug'); } else { $listing = DB::table('sub-sub-categories')->where('sub_category', '=', $object->id)->lists('name', 'slug'); } return $listing; }); Route::post('postChat', ['middleware' => 'auth', 'uses' => 'ChatController@postChat']); Event::listen('auth.login', function () { $user = User::find(\Auth::user()->id); $user->availability = 1; $user->last_login = new DateTime(); $user->save(); });
public function getSubCategories($id) { $subcategories = SubCategory::where('category_id', '=', $id)->get(); return $subcategories; }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function captureCase(Request $request) { $reporter = $request['caseReporter']; $caseSeverity = $request['caseSeverity']; $userObj = User::where('username', '=', $reporter)->first(); if (sizeof($userObj) <= 0) { $userAddressbookObj = addressbook::where('email', '=', $reporter)->first(); } $user = sizeof($userObj) <= 0 ? $userAddressbookObj->id : $userObj->id; $addressbook = sizeof($userObj) <= 0 ? 1 : 0; $userName = sizeof($userObj) <= 0 ? $userAddressbookObj->FirstName : $userObj->name; $userSurname = sizeof($userObj) <= 0 ? $userAddressbookObj->Surname : $userObj->surname; $userEmail = sizeof($userObj) <= 0 ? $userAddressbookObj->email : $userObj->username; $cell = sizeof($userObj) <= 0 ? $userAddressbookObj->cellphone : $userObj->email; $caseDescription = $request['caseDescription']; $precinctObj = Municipality::where('slug', '=', $request['caseMunicipality'])->first(); $categoryObj = Category::where('slug', '=', $request['caseCategory'])->first(); $subCategoryObj = SubCategory::where('slug', '=', $request['caseSubCategory'])->first(); if ($request['caseSubSubCategory'] > 0) { $subSubCategoryObj = SubSubCategory::where('slug', '=', $request['caseSubSubCategory'])->first(); $subSubCategory = $subSubCategoryObj->id; } else { $subSubCategory = 0; } $gps = explode(",", $request['GPS']); $caseObj = new CaseReport(); $caseObj->description = htmlentities($caseDescription); $caseObj->user = \Auth::user()->id; $caseObj->reporter = $user; $caseObj->addressbook = $addressbook; $caseObj->precinct = $precinctObj->id; $caseObj->category = $categoryObj->id; $caseObj->sub_category = $subCategoryObj->id; $caseObj->sub_sub_category = $subSubCategory; $caseObj->gps_lat = $gps[0]; $caseObj->gps_lng = $gps[1]; $caseObj->severity = $caseSeverity; $caseObj->status = "Pending"; $caseObj->save(); $data = array('name' => $userName, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description); $caseOwner = new CaseOwner(); $caseOwner->user = $user; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 0; $caseOwner->active = 1; $caseOwner->save(); \Mail::send('emails.sms', $data, function ($message) use($userEmail) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($userEmail)->subject("Siyaleader Notification - New Case Reported:"); }); if ($caseSeverity <= 4) { $severityData = array('severity' => $caseObj->severity, 'name' => $userName . ' ' . $userSurname, 'cell' => $cell, 'category' => $categoryObj->name, 'caseId' => $caseObj->id); \Mail::send('emails.severity', $severityData, function ($message) { $message->from('*****@*****.**', 'Siyaleader'); $message->to('*****@*****.**')->subject("SEVERE"); }); $criticalTeam = CriticalTeam::all(); foreach ($criticalTeam as $critical) { $caseOwner = new CaseOwner(); $caseOwner->user = $critical->user; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 5; //Critical Team $caseOwner->active = 1; $caseOwner->save(); \Mail::send('emails.severity', $severityData, function ($message) use($critical) { $userObj = User::find($critical->user); $message->from('*****@*****.**', 'Siyaleader'); $message->to($userObj->username)->subject("Siyaleader Notification - New Severe Case Reported:"); }); } } if ($subSubCategory > 0) { $subSubCatResponders = CaseResponder::where('sub_sub_category', '=', $subSubCategory)->first(); if (sizeof($subSubCatResponders) > 0) { if ($subSubCatResponders->firstResponder) { $firstResponderUser = User::find($subSubCatResponders->firstResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $subSubCatResponders->firstResponder; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 1; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $firstResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description); \Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } if ($subSubCatResponders->secondResponder) { $secondResponderUser = User::find($subSubCatResponders->secondResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $subSubCatResponders->secondResponder; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 2; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $secondResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description); \Mail::send('emails.responder', $data, function ($message) use($secondResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } if ($subSubCatResponders->thirdResponder) { $thirdResponderUser = User::find($subSubCatResponders->thirdResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $subSubCatResponders->thirdResponder; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 3; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $thirdResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description); \Mail::send('emails.responder', $data, function ($message) use($thirdResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } } } if ($subSubCategory == 0) { $subCatResponders = CaseResponder::where('sub_category', '=', $subCategoryObj->id)->first(); if (sizeof($subCatResponders) > 0) { if ($subCatResponders->firstResponder) { $firstResponderUser = User::find($subCatResponders->firstResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $subCatResponders->firstResponder; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 1; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $firstResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description); \Mail::send('emails.responder', $data, function ($message) use($firstResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($firstResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } if ($subCatResponders->secondResponder) { $secondResponderUser = User::find($subCatResponders->secondResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $subCatResponders->secondResponder; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 2; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $secondResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description); \Mail::send('emails.responder', $data, function ($message) use($secondResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($secondResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } if ($subCatResponders->thirdResponder) { $thirdResponderUser = User::find($subCatResponders->thirdResponder); $caseOwner = new CaseOwner(); $caseOwner->user = $subCatResponders->thirdResponder; $caseOwner->caseId = $caseObj->id; $caseOwner->type = 3; $caseOwner->active = 1; $caseOwner->save(); $data = array('name' => $thirdResponderUser->name, 'caseID' => $caseObj->id, 'caseDesc' => $caseObj->description, 'caseReporter' => $caseObj->description); \Mail::send('emails.responder', $data, function ($message) use($thirdResponderUser) { $message->from('*****@*****.**', 'Siyaleader'); $message->to($thirdResponderUser->username)->subject("Siyaleader Notification - New Case Reported:"); }); } } } return redirect()->back(); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index($id) { $data['subcategory'] = SubCategory::where('category_id', $id)->get(); return view('admin.subcategory', $data); }