/** * Display a listing of the resource. * * @return Response */ public function index(Region $region, TrainRoad $trainRoad, Stantion $stantion) { $regionsCount = $region->count(); $tRoadsCount = $trainRoad->count(); $stationsCount = $stantion->count(); $condCount = Condition::count(); $productsCount = Product::count(); $servicesCount = Service::count(); $catCount = Category::count(); $statusesCount = Status::count(); $serviceStatusesCount = ServiceStatus::count(); $newOrdersCount = Order::where('is_new', 1)->count(); $newServiceOrdersCount = ServiceOrder::where('is_new', 1)->count(); $customers = Firm::where('accountant_fio', null)->get(); return view('admin.adminArea', ['regionsCount' => $regionsCount, 'tRoadsCount' => $tRoadsCount, 'stationsCount' => $stationsCount, 'condCount' => $condCount, 'catCount' => $catCount, 'productsCount' => $productsCount, 'servicesCount' => $servicesCount, 'statusesCount' => $statusesCount, 'newOrdersCount' => $newOrdersCount, 'serviceStatusesCount' => $serviceStatusesCount, 'newServiceOrdersCount' => $newServiceOrdersCount, 'customers' => $customers]); }
/** * Execute the command. * * @return void */ public function handle() { $selfFirmUser = User::with('firm')->where('role_id', User::ADMIN)->first(); $clientCompany = User::with('firm')->where('id', $this->order->user_id)->first(); $products = $this->order->products_in_order; $firm = $clientCompany->firm; $productsArr = []; foreach ($products as $product) { $productsArr[] = ['product_name' => $product->product_name, 'product_amount' => $product->product_amount, 'product_price' => $product->product_price]; } $date = DateTime::createFromFormat('Y-m-d H:i:s', $this->order->created_at); $date = strtotime($date->format('d F Y')); $pdf = App::make('dompdf.wrapper'); $viewType = null; if ($this->isTorg) { $viewType = 'documents.torg_12'; } else { $viewType = 'documents.schet_factura'; } $pdf->loadView($viewType, ['orderNumber' => $this->order->id, 'orderDate' => date('d.m.Y', $date), 'firm' => $firm, 'selfFirm' => $selfFirmUser->firm, 'products' => $productsArr]); //$pdf->setOrientation('landscape'); $pdf->setPaper('A4', 'landscape'); $documents = Config::get('documents'); $whereAreClientDocuments = $documents['documents_folder']; //client_{id} if (!Storage::disk('local')->exists($whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id)) { Storage::makeDirectory($whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id); } //paymentDocs if (!Storage::disk('local')->exists($whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id . DIRECTORY_SEPARATOR . 'paymentDocs')) { Storage::makeDirectory($whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id . DIRECTORY_SEPARATOR . 'paymentDocs'); } $clientFolder = storage_path() . DIRECTORY_SEPARATOR . 'app' . $whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id . DIRECTORY_SEPARATOR . 'paymentDocs'; //(torg12/schetfactura)_{orderID}_{depoName}_date_{currentDate} $fileNameTemplate = $documents['client_invoice_template']; $fileNameTemplate = Utils::mb_str_replace('{docType}', Order::getDocTypeName($this->isTorg ? Order::AUCTION_12_TYPE : Order::INVOICE_ACCT_TYPE), $fileNameTemplate); $fileNameTemplate = Utils::mb_str_replace('{orderID}', $this->order->id, $fileNameTemplate); $depo = Stantion::find($this->order->products_in_order[0]->stantion_id); $depoName = Utils::mb_str_replace(' ', '', $depo->stantion_name); $depoName = Utils::translit($depoName); $fileNameTemplate = Utils::mb_str_replace('{depoName}', $depoName, $fileNameTemplate); $fileNameTemplate = Utils::mb_str_replace('{currentDate}', time(), $fileNameTemplate); $pdf->save($clientFolder . DIRECTORY_SEPARATOR . $fileNameTemplate); $docs = new Document(); $docs->type = $this->isTorg ? Order::AUCTION_12_TYPE : Order::INVOICE_ACCT_TYPE; $docs->user_id = $this->order->user_id; $docs->order_id = $this->order->id; $docs->file_name = $clientFolder . DIRECTORY_SEPARATOR . $fileNameTemplate; $docs->save(); Bus::dispatch(new SendEmailWithPaymentDocs($docs->file_name, $this->isTorg, $this->order)); }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { $validationRules = ['oferta' => 'accepted', 'userID' => 'integer|required|in:' . Auth::user()->id]; $v = Validator::make($request->all(), $validationRules); if ($v->fails()) { return redirect()->route('confirmOrder', ['user_id' => Auth::user()->id])->withErrors($v->errors()); // $newRequest = Request::create('confirmOrder/'.Auth::user()->id, 'POST', [], [], [], [],['blat'=>$v->errors()]); // return Route::dispatch($newRequest)->getContent(); } $userID = $request->userID; if (Auth::user()->id == (int) $userID) { $productsByDepoArr = []; $newProductsByDepoArr = []; $orderNumbers = []; DB::transaction(function () use($userID, &$productsByDepoArr, &$orderNumbers, &$newProductsByDepoArr) { $products = ProductCart::with('product.condition', 'price.stantion')->where('user_id', $userID)->get(); foreach ($products as $productCart) { $productsByDepoArr[$productCart->price->stantion[0]->id][] = [$productCart->product->name . '( состояние - ' . $productCart->product->condition->condition . ')', $productCart->product_count, $productCart->price->price, $productCart->price->id, $productCart->product->id, $productCart->price->stantion[0]->stantion_name, $productCart->price->nds]; $productCart->price->amount -= $productCart->product_count; $productCart->price->save(); } $userCompany = User::with('firm')->where('id', $userID)->first(); $status = Status::where('is_first', Order::IS_FIRST)->first(); foreach ($productsByDepoArr as $depoID => $productsArr) { $order = new Order(); $order->status_id = $status->id; $order->user_id = $userID; $order->firm_id = $userCompany->firm->id; $order->email = Auth::user()->email; $order->save(); $orderNumbers[] = $order->id; foreach ($productsArr as $product) { $productsInOrder = new ProductsInOrder(); $productsInOrder->order_id = $order->id; $productsInOrder->product_name = $product[0]; $productsInOrder->product_price = $product[2]; $productsInOrder->product_amount = $product[1]; $productsInOrder->stantion_id = $depoID; $productsInOrder->price_id = $product[3]; $productsInOrder->product_id = $product[4]; $productsInOrder->stantion_name = $product[5]; $productsInOrder->nds = $product[6]; $productsInOrder->save(); } $newProductsByDepoArr[$order->id] = $productsArr; //Запускаем команду на формирование счета Bus::dispatch(new CreateInvoice($order, Stantion::find($depoID))); } ProductCart::where('user_id', $userID)->delete(); }); $files = Document::where('user_id', Auth::user()->id)->where(function ($query) use($orderNumbers) { foreach ($orderNumbers as $number) { $query->orWhere('file_name', 'like', '%' . Order::getDocTypeName(Order::INVOICE_TYPE) . '_' . $number . '_%'); } })->get(); $fileNames = []; foreach ($files as $file) { $fileNames[] = $file->file_name; } $messageParams = []; $messageParams['productByDepoWithOrderIdAsKey'] = $newProductsByDepoArr; // //Запускаем команду на отправку email Bus::dispatch(new SendEmailWithInvoices($messageParams, $fileNames)); // Bus::dispatch(new SendWithTanksForOrder($messageParams)); return view('orders.success', ['p' => 'purchases', 'ordersAmount' => count($productsByDepoArr)]); } else { return redirect('fatal_error')->with('alert-danger', 'Произошла ошибка в работе сайта. Мы уже исправляем эту проблему. Попробуйте через некоторое время.'); } }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(Request $request, $id) { try { $product = Product::with(['price', 'price.stantion'])->where('id', $id)->first(); } catch (ModelNotFoundException $e) { abort(404); } if (!$product) { abort(404); } $id = $request->route('products'); $validationRules = ['name' => 'required|alpha_spaces_numbers|max:35|unique:products,name,' . $id, 'article' => 'required|alpha_spaces_numbers|max:15', 'description' => 'required|alpha_spaces_numbers', 'condition_id' => 'required|integer']; $depos = Stantion::all(); foreach ($depos as $depo) { $validationRules['price' . $depo->id] = 'required|numeric'; $validationRules['amount' . $depo->id] = 'required|numeric'; $validationRules['vat' . $depo->id] = 'required|numeric'; } $v = Validator::make($request->all(), $validationRules); if ($v->fails()) { return redirect()->back()->withErrors($v->errors())->withInput(); } $prices = $product->price; DB::transaction(function () use($product, $request, $prices) { $product->article = $request->article; $product->name = $request->name; $product->description = $request->description; $product->condition_id = $request->condition_id; if (!(int) $request->category_id) { $product->category_id = null; } else { $product->category_id = $request->category_id; } $product->save(); foreach ($prices as $price) { $priceInputName = 'price' . $price->stantion[0]->id; $priceInputAmount = 'amount' . $price->stantion[0]->id; $priceInputVAT = 'vat' . $price->stantion[0]->id; $price->price = $request->{$priceInputName}; $price->amount = $request->{$priceInputAmount}; $price->nds = $request->{$priceInputVAT}; $price->save(); } }); return redirect('products')->with('alert-success', 'Товар обновлен'); }
public function getPriceListInCurrentCategory(ProductCart $productCart, $categoryName, $depoId) { $category = Category::with('product.price.stantion.train_road')->where('category', $categoryName)->first(); $stantion = Stantion::where('id', $depoId)->first(); $depoName = $stantion->stantion_name; $productsArr = []; if (Auth::guest()) { $userID = 0; } else { $userID = Auth::user()->id; } foreach ($category->product as $product) { foreach ($product->price as $price) { if ($price->price > 0 && $price->amount > 0) { $productsArr[$price->stantion[0]->train_road->tr_name][$price->stantion[0]->stantion_name][] = ['name' => $product->name, 'product_id' => $product->id, 'depo_id' => $price->stantion[0]->id, 'price_id' => $price->id, 'article' => $product->article, 'description' => $product->description, 'price' => $price->price, 'amount' => $price->amount]; } } } $sumAndCount = $this->getGeneralViewOfCart($productCart); return view('purchases.trainCarPriceListInCurrentCategory', ['p' => 'purchases', 'productsArr' => $productsArr, 'category' => $categoryName, 'userID' => $userID, 'productsCount' => $sumAndCount['productsCount'], 'productsSum' => $sumAndCount['productsSum'], 'whatDepoIdWeAre' => $depoId, 'whatDepoNameWeAre' => $depoName]); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { //$station = Stantion::find($id); $station = Stantion::with(['price'])->where('id', $id)->first(); DB::transaction(function () use($station) { $station->price()->detach(); foreach ($station->price as $price) { $price->delete(); } $station->delete(); }); //Region::destroy($id); return back()->with('alert-success', 'Станция ' . $station->stantion_name . ' удалена'); }