strprfcrm/app/Services/GenerateDocumentsService.php

<?php

namespace App\Services;

use App\Helpers\DateHelper;
use App\Models\Contract;
use App\Models\Order;
use Exception;
use Illuminate\Support\Facades\Storage;
use Illuminate\Support\Str;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class GenerateDocumentsService
{
    const INSTALL_FILENAME = 'Монтаж ';
    const HANDOVER_FILENAME = 'Сдача ';

    /**
     * @param Order $order
     * @param int $userId
     * @return string
     * @throws Exception
     */
    public function generateInstallationPack(Order $order, int $userId): string
    {
        $techDocsPath = base_path('/tech-docs/');
        $products_sku = $order->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('<div>', '', $order->products_with_count);
        $str = Str::replace('</div>', "\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);
    }


}