public function getHome() { try { $causes = Cause::where('active', 1)->get(); $causeofthemonth = SectionMeta::where('meta_key', 'sort')->get(); return view('page.donate')->with('causes', $causes)->with('causeofthemonth', $causeofthemonth); } catch (Exception $e) { throw $e; } }
public function postCauseoftheMonthRemove(Request $request) { //Start transaction DB::beginTransaction(); try { $items = $request->input('mark'); foreach ($items as $item) { $item = SectionMeta::where('meta_key', 'sort')->where('meta_value', $item)->first(); $cause_id = $item->meta_value_2; $item = SectionMeta::where('meta_key', 'sort')->where('meta_value_2', $cause_id)->delete(); $item = SectionMeta::where('meta_key', 'cause_id')->where('meta_value', $cause_id)->delete(); } // If we reach here, then // data is valid and working. // Commit the queries! DB::commit(); return ['success' => '1', 'messages' => 'Deleted.', 'results' => $items]; } catch (Exception $e) { DB::rollback(); throw $e; } }