public function postOrders() { $input_start_date = \Input::get('start_date'); if ($input_start_date == "") { $input_start_date = "01/01/1900"; } $start_date = \DateTime::createFromFormat('d/m/Y', $input_start_date); $input_end_date = \Input::get('end_date'); if ($input_end_date == "") { $end_date = new \DateTime("NOW"); } else { $end_date = \DateTime::createFromFormat('d/m/Y', $input_end_date); } $data = Order::where('created_at', '>=', $start_date)->where('created_at', '<=', $end_date)->orderBy('created_at', 'desc')->get(); if (count($data) == 0) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('downloadError', "There's no data within the dates specified."); return \Redirect::to('admin/orders')->withErrors($errors); } \Excel::create('Redmin_Orders_Report', function ($excel) use($data) { $excel->sheet('Orders Report', function ($sheet) use($data) { $sheet->loadView('redminportal::reports/orders')->with('data', $data); }); })->download('xlsx'); }
public function delete() { // Remove product association $order = Order::find($this->id); $order->pricelists()->detach(); return $order->delete(); }
public function getUpdate($field = null, $sid = null, $status = null) { $field_pattern = '/^[a-zA-Z0-9_\\-]+$/'; $text_pattern = '/^[a-zA-Z0-9 _\\-]+$/'; $rules = ['field' => 'required|in:status|regex:' . $field_pattern, 'sid' => 'required|numeric', 'status' => 'required|regex:' . $text_pattern]; $inputs = ['field' => $field, 'sid' => $sid, 'status' => $status]; $messages = ['field.in' => trans('redminportal::messages.order_error_update_unsupported_field'), 'field.required' => trans('redminportal::messages.order_error_update_missing_field'), 'field.regex' => trans('redminportal::messages.error_remove_special_characters'), 'status.required' => trans('redminportal::messages.order_error_update_missing_status'), 'status.regex' => trans('redminportal::messages.error_remove_special_characters')]; $validation = Validator::make($inputs, $rules, $messages); if ($validation->fails()) { return redirect($this->pageRoute)->withErrors($validation); } // Only supports status for now if ($field == 'status') { $order = Order::find($sid); $order->payment_status = $status; $order->save(); } return redirect()->back(); }
public function getDelete($sid) { // Find the module using the user id $module = Module::find($sid); if ($module == null) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('deleteError', "We are having problem deleting this entry. Please try again."); return redirect()->back()->withErrors($errors); } $purchases = Order::join('order_pricelist', 'orders.id', '=', 'order_pricelist.id')->join('pricelists', 'pricelists.id', '=', 'order_pricelist.pricelist_id')->where('pricelists.module_id', $sid)->get(); if (count($purchases) > 0) { $errors = new \Illuminate\Support\MessageBag(); $errors->add('deleteError', "This module has been purchased before. You cannot delete it. Please disable it instead."); return redirect()->back()->withErrors($errors); } // Delete the module $module->delete(); return redirect()->back(); }