/**
* 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);
}
