products_sku; $articles = []; Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp/Схемы сборки/'); foreach ($products_sku as $sku) { if(!in_array($sku->product->article, $articles)) { $articles[] = $sku->product->article; // find and copy scheme files to installation directory if(file_exists($techDocsPath . $sku->product->article . '/')) { foreach(Storage::disk('base')->allFiles('tech-docs/' . $sku->product->article) as $p) { $content = Storage::disk('base')->get($p); Storage::disk('public')->put('orders/' . $order->id . '/tmp/Схемы сборки/' . basename($p), $content); } } } } // generate xlsx order file $this->generateOrderForMount($order); // create zip archive $fileModel = (new FileService())->createZipArchive('orders/' . $order->id . '/tmp', self::INSTALL_FILENAME . $order->common_name . '.zip', $userId); // remove temp files Storage::disk('public')->deleteDirectory('orders/' . $order->id . '/tmp'); $order->documents()->syncWithoutDetaching($fileModel); // return link return $fileModel?->link ?? ''; } private function generateOrderForMount(Order $order): void { $inputFileType = 'Xlsx'; // Xlsx - Xml - Ods - Slk - Gnumeric - Csv $inputFileName = './templates/OrderForMount.xlsx'; $reader = IOFactory::createReader($inputFileType); $spreadsheet = $reader->load($inputFileName); $sheet = $spreadsheet->getActiveSheet(); // менеджер $sheet->setCellValue('F8', $order->user->name); $sheet->setCellValue('X8', $order->user->phone); // округ и район $sheet->setCellValue('L10', $order->district->shortname); $sheet->setCellValue('W10', $order->area->name); if($order->area->responsible) { // ответственный $sheet->setCellValue('C12', $order->area->responsible?->name . ', ' . $order->area->responsible?->phone . ', ' . $order->area->responsible?->post); } else { $sheet->setCellValue('C12', ''); } // адрес $sheet->setCellValue('L14', $order->object_address); $str = Str::replace('

', '', $order->products_with_count); $str = Str::replace('

', "\n", $str); // мафы $sheet->setCellValue('G33', Str::trim($str)); // $fileName = 'Заявка на монтаж - ' . $order->object_address . '.xlsx'; $writer = new Xlsx($spreadsheet); Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp'); $writer->save(storage_path('app/public/orders/') . $order->id .'/tmp/' . $fileName); } /** * @throws Exception */ public function generateHandoverPack(Order $order, int $userId): string { $articles = []; Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp/ПАСПОРТ/'); Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp/СЕРТИФИКАТ/'); Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp/ФОТО ПСТ/photos'); Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp/ФОТО ТН/'); // copy app photos foreach ($order->photos as $photo) { $from = $photo->path; $to = 'orders/' . $order->id . '/tmp/ФОТО ПСТ/photos/' . $photo->original_name; if(!Storage::disk('public')->exists($to)) { Storage::disk('public')->copy($from, $to); } } foreach ($order->products_sku as $sku) { // copy certificates if($sku->product->certificate_id) { $from = $sku->product->certificate->path; $to = 'orders/' . $order->id . '/tmp/СЕРТИФИКАТ/' . $sku->product->certificate->original_name; if(!Storage::disk('public')->exists($to)) { Storage::disk('public')->copy($from, $to); } } // copy passport if($sku->passport_id) { $from = $sku->passport->path; $to = 'orders/' . $order->id . '/tmp/ПАСПОРТ/' . $sku->passport->original_name; if(!Storage::disk('public')->exists($to)) { Storage::disk('public')->copy($from, $to); } } } // generate xlsx order files $this->generateStatement($order); // create zip archive $fileModel = (new FileService())->createZipArchive('orders/' . $order->id . '/tmp', self::HANDOVER_FILENAME . $order->common_name . '.zip', $userId); // remove temp files Storage::disk('public')->deleteDirectory('orders/' . $order->id . '/tmp'); $order->documents()->syncWithoutDetaching($fileModel); // return link return $fileModel?->link ?? ''; } private function generateStatement(Order $order): void { $inputFileType = 'Xlsx'; $inputFileName = './templates/Statement.xlsx'; $reader = IOFactory::createReader($inputFileType); $spreadsheet = $reader->load($inputFileName); $sheet = $spreadsheet->getActiveSheet(); $contract = Contract::query()->where('contracts.year', $order->year)->first(); $contract_number = $contract->contract_number ?? 'заполнить договор за ' . $order->year . ' год!'; $contract_date = DateHelper::getHumanDate($contract->contract_date ?? '1970-01-01', true); $s = 'по Договору №' . $contract_number . ' от ' . $contract_date . ' г. Между ГБУ "Мосремонт" и ООО "НАШ ДВОР-СТ"'; $sheet->setCellValue('B5', $s); // менеджер $sheet->setCellValue('G21', $order->user->name); // округ и район $sheet->setCellValue('C6', $order->district->shortname); $sheet->setCellValue('F6', $order->area->name); $i = 9; // start of table $nn = 1; // string number foreach ($order->products_sku as $sku) { if($nn > 1) { // inset row $sheet->insertNewRowBefore($i); } $sheet->setCellValue('A' . $i, $nn++); $sheet->setCellValue('B' . $i, $sku->product->statement_name); $sheet->setCellValue('C' . $i, $sku->product->passport_name); $sheet->setCellValue('D' . $i, 'шт'); $sheet->setCellValue('E' . $i, '1'); $sheet->setCellValue('F' . $i, $order->name); $sheet->setCellValue('G' . $i, $sku->factory_number); $sheet->setCellValue('H' . $i++, $sku->rfid); } // save file $fileName = '1.Ведомость.xlsx'; $writer = new Xlsx($spreadsheet); Storage::disk('public')->makeDirectory('orders/' . $order->id . '/tmp'); $writer->save(storage_path('app/public/orders/') . $order->id .'/tmp/' . $fileName); } }