join('employees', 'employees.id', '=', 'spinned.employee_id') ->join('catagories', 'catagories.id', '=', 'spinned.catagory_id') // ->join('topics', 'topics.id', '=', 'spinned.topic_id') ->select('spinned.*', 'employees.name as employee_name', 'catagories.catagory_name as catagory_name') ->orderBy('spinned.id', 'DESC') ->get(); // dd($data); return view('admin.spin.spin_index')->with(['data' => $data,]); } public function topic_index() { $data = DB::table('topics') ->get(); // dd($data); return view('admin.topic.topic_index')->with(['data' => $data,]); } public function topic_edit($id) { $data = DB::table('topics')->find($id); return view('admin.topic.topic_edit')->with('data', $data); } public function topic_update(Request $request, $id) { $validated = $request->validate([ 'topic_name' => 'required|max:50', 'status' => 'required', ]); $topic_name = $request->topic_name; $status = $request->status; $data = [ 'topic_name' => $topic_name, 'status' => $status, ]; DB::table('topics')->where('id', $id)->update($data); return redirect()->route('topic.index')->with('success', 'Successfully Updated'); } public function topic_create() { return view('admin.topic.topic_create'); } public function topic_store(Request $request) { $validated = $request->validate([ 'topic_name' => 'required|unique:topics|max:50', 'status' => 'required', ]); $topic_name = $request->topic_name; $status = $request->status; $data = [ 'topic_name' => $topic_name, 'status' => $status, ]; DB::table('topics')->insert($data); return redirect()->route('topic.index')->with('success', 'Successfully Inserted'); } public function topic_delete($id) { DB::table('topics')->delete($id); return redirect()->route('topic.index')->with('success', 'Successfully Deleted'); } public function employee_index() { $data = DB::table('employees') ->get(); // dd($data); return view('admin.employee.employee_index')->with(['data' => $data,]); } public function employee_edit($id) { $data = DB::table('employees')->find($id); return view('admin.employee.employee_edit')->with('data', $data); } public function employee_update(Request $request, $id) { $validated = $request->validate([ 'name' => 'required|unique:employees|max:50', ]); $employee_name = $request->name; $status = $request->status; $data = [ 'name' => $employee_name, ]; DB::table('employees')->where('id', $id)->update($data); return redirect()->route('employee.index')->with('success', 'Successfully Updated'); } public function employee_create() { return view('admin.employee.employee_create'); } public function employee_store(Request $request) { $validated = $request->validate([ 'name' => 'required|unique:employees|max:50', ]); $name = $request->name; $status = $request->status; $data = [ 'name' => $name, ]; DB::table('employees')->insert($data); return redirect()->route('employee.index')->with('success', 'Successfully Inserted'); } public function employee_delete($id) { DB::table('employees')->delete($id); return redirect()->route('employee.index')->with('success', 'Successfully Deleted'); } public function employee_csv(Request $request) { $request->validate([ 'employee_csv' => 'required|mimes:csv,txt' ]); $filepath = $request->employee_csv; $file = fopen($filepath, "r"); $data = []; while (!feof($file)) { $data[] = fgetcsv($file); } fclose($file); // $data = array_slice($data, 1, count($data) - 1); array_pop($data); array_shift($data); // dd(($data)); DB::table('employees')->delete(); DB::table('spinned')->delete(); foreach ($data as $key => $value) { $name = $value[0]; $check = DB::table('employees')->where('name', $name)->first(); if (empty($check)) { DB::table('employees')->insert([ 'name' => $name, ]); } else { return back()->with('error', $name . "is allready present"); } } return back()->with('success', 'Employee uploaded successfully'); } public function topic_csv(Request $request) { $request->validate([ 'topic_csv' => 'required|mimes:csv,txt' ]); $filepath = $request->topic_csv; $file = fopen($filepath, "r"); $data = []; while (!feof($file)) { $data[] = fgetcsv($file); } fclose($file); array_pop($data); array_shift($data); DB::table('topics')->delete(); foreach ($data as $key => $value) { $name = $value[0]; $check = DB::table('topics')->where('topic_name', $name)->first(); if (empty($check)) { DB::table('topics')->insert([ 'topic_name' => $name, ]); } else { return back()->with('error', $name . "is allready present"); } } return back()->with('success', 'Topics uploaded successfully'); } }