/** * Get the canceled order numbers * * @param $state * @param null $orderNumber * @return mixed */ public static function getCanceled($state, $orderNumber = null, $page) { $perPage = 10; $companyIds = []; if (Auth::admin()->check()) { $companyIds = Company::all()->lists('id')->toArray(); } elseif (Auth::user()->check()) { $companyIds = [Auth::user()->get()->company->id]; } $query = DB::table('canceled_orders')->whereIn('company_id', $companyIds)->take($perPage)->skip($perPage * ($page - 1)); switch ($state) { case 'unconfirmed': $query = $query->where('confirmed', false)->where('denied', false); break; case 'confirmed': $query = $query->where('confirmed', true); break; case 'denied': $query = $query->where('denied', true)->where('confirmed_denied', false); break; } if ($orderNumber) { $query = $query->where('order_number', $orderNumber); } return $query->lists('order_number'); }
public function index(Request $request) { $query = new Notification(); $companyId = $request->input('companyId'); $orderNumber = $request->input('orderNumber'); $type = $request->input('type'); $from = $request->input('from'); $to = $request->input('to'); if ($companyId) { $query = $query->where('company_id', $companyId); } if ($orderNumber) { $query = $query->where('order_number', $orderNumber); } if ($type) { $query = $query->where('type', $type); } if ($from) { $query = $query->where('created_at', '>=', $from); } if ($to) { $query = $query->where('updated_at', '<=', $to); } $notifications = $query->paginate(); $companies = Company::all(); $types = Notification::$types; return view('admin::notifications.index', ['notifications' => $notifications, 'companies' => $companies, 'types' => $types, 'company_id' => $companyId, 'type' => $type, 'from' => $from, 'to' => $to, 'order_number' => $orderNumber]); }
public function importCompanies() { $oldCompanies = DB::connection('old')->table('companies')->get(); foreach ($oldCompanies as $oldCompany) { $company = new Company(); $company->name = $oldCompany->name; $company->nav_code = $oldCompany->nav_code; $company->id = $oldCompany->id; $company->save(); } $companies = \LevApp\Models\Company::all(); foreach ($companies as $company) { DB::table('company_reminder_schedule')->insert(['company_id' => $company->id, 'monday' => 0, 'tuesday' => 1, 'wednesday' => 0, 'thursday' => 1, 'friday' => 0, 'saturday' => 0, 'sunday' => 0]); } }
/** *Get order for admin, with filter * * @param Request $request * @return \Illuminate\Http\JsonResponse */ public function getOrders(Request $request) { $companies = Company::all(); $orderNumber = $request->input('orderNumber', null) ?: null; $confirmed = $request->input('confirmed', false); $navCode = $request->input('navCode', null); $navCodes = $companies->lists('nav_code')->toArray(); $skip = $request->input('skip', ''); //Sending bools as get params... if ($confirmed == 'false') { $confirmed = false; } $orders = $this->navisionService->getAdminSearched($orderNumber, $navCode ?: $navCodes, $confirmed, $skip); return $this->success($orders); }