/**
* Execute the command.
*
* @return void
*/
public function handle()
{
$documents = Config::get('documents');
$whereAreClientDocuments = $documents['documents_folder'];
//client_{id}
if (!Storage::disk('local')->exists($whereAreClientDocuments . '/client_' . $this->firm->user->id)) {
Storage::makeDirectory($whereAreClientDocuments . '/client_' . $this->firm->user->id);
}
//agreement
if (!Storage::disk('local')->exists($whereAreClientDocuments . '/client_' . $this->firm->user->id . '/service_agreement')) {
Storage::makeDirectory($whereAreClientDocuments . '/client_' . $this->firm->user->id . '/service_agreement');
}
//очищаем папку от всех файлов
$files = Storage::files($whereAreClientDocuments . '/client_' . $this->firm->user->id . '/service_agreement');
if (!empty($files)) {
$agreementDocIds = Document::select('id')->where('type', Order::CONTRACT_TYPE)->where('user_id', $this->firm->user->id)->get();
$agreementDocIdsArr = [];
foreach ($agreementDocIds as $agreementDocId) {
$agreementDocIdsArr[] = $agreementDocId->id;
}
Document::destroy($agreementDocIdsArr);
}
Storage::delete($files);
//создаем новый файл
$clientFolder = storage_path() . '/app' . $whereAreClientDocuments . '/client_' . $this->firm->user->id . '/service_agreement';
//{docType}_contragent_{clientId}_date_{currentDate}.pdf
$fileNameTemplate = $documents['client_service_agreement_template'];
$fileNameTemplate = Utils::mb_str_replace('{docType}', Order::getDocTypeName(Order::CONTRACT_TYPE), $fileNameTemplate);
$fileNameTemplate = Utils::mb_str_replace('{clientId}', $this->firm->user->id, $fileNameTemplate);
$fileNameTemplate = Utils::mb_str_replace('{currentDate}', time(), $fileNameTemplate);
// $pdf->save($clientFolder.'/'.$fileNameTemplate);
//********************************************************
/*
* Номер текущей страницы
* если требуется сгенерировать несколько документов
*/
// $current_page = 1;
//****************************************************
//+++++++++++++++++++++++++++++++++++++++++++++++++++++
$pdf = App::make('dompdf.wrapper');
$pdf->loadView('documents.serviceAgreementTemplate', ['fullFirmName' => $this->firm->full_organisation_name, 'shortFirmName' => $this->firm->organisation_name, 'position' => $this->firm->rp_face_position, 'fio' => $this->firm->rp_face_fio, 'baseDocument' => $this->firm->rp_base_document, 'inn' => $this->firm->inn, 'kpp' => $this->firm->kpp, 'address' => $this->firm->place_address, 'rs' => $this->firm->rs, 'bank' => $this->firm->bank, 'ks' => $this->firm->ks, 'bik' => $this->firm->bik, 'phone' => $this->firm->phone, 'email' => $this->firm->user->email]);
//+++++++++++++++++++++++++++++++++++++++++++++++
// $dom_pdf = $pdf->getDomPDF();
// $canvas = $dom_pdf->get_canvas();
// dd($canvas);
// $canvas->page_text(0, 0, "Page {PAGE_NUM} of {PAGE_COUNT}", null, 10, array(0, 0, 0));
//--------------------------------------------
$m = new Merger();
$m->addRaw($pdf->output());
//****************************************************
// $signs = array (
// 'start-page' => $current_page);
//
// // Замена меток в шаблоне их значениями
// foreach ($signs as $key => $value) {
// $template = str_replace('{' . $key . '}', $value, $template);
// }
/*
* Увеличили счетчик числа сгенерированных страниц
* на число страниц текущего документа
*/
// $current_page = $current_page + $dom_pdf->get_canvas()->get_page_count();
//********************************************************
unset($pdf);
$pdf = App::make('dompdf.wrapper');
$pdf->setPaper('a4', 'landscape')->loadView('documents.serviceAgreementTemplate2');
$m->addRaw($pdf->output());
file_put_contents($clientFolder . '/' . $fileNameTemplate, $m->merge());
$docs = new Document();
$docs->type = Order::CONTRACT_TYPE;
$docs->user_id = $this->firm->user->id;
$docs->file_name = $clientFolder . '/' . $fileNameTemplate;
$docs->sended = 1;
$docs->save();
$user = User::find($this->firm->user->id);
$emailContent['userName'] = $user->name;
$emailContent['email'] = $user->email;
Bus::dispatch(new SendEmailWithServiceAgreement($emailContent, $clientFolder . '/' . $fileNameTemplate));
}
/**
* Execute the command.
*
// * @return void
*/
public function handle()
{
$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 . Order::getDocTypeName($this->docType))) {
Storage::makeDirectory($whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id . DIRECTORY_SEPARATOR . Order::getDocTypeName($this->docType));
}
$clientFolder = $whereAreClientDocuments . DIRECTORY_SEPARATOR . 'client_' . $this->order->user_id . DIRECTORY_SEPARATOR . Order::getDocTypeName($this->docType);
//(torg12/schetfactura)_{orderID}_{depoName}_date_{currentDate}
$fileNameTemplate = $this->documentFor == Order::DOCUMENT_FOR_SERVICE ? $documents['client_service_document_template'] : $documents['client_document_template'];
$fileNameTemplate = Utils::mb_str_replace('{docType}', Order::getDocTypeName($this->docType), $fileNameTemplate);
$fileNameTemplate = Utils::mb_str_replace('{orderID}', $this->order->id, $fileNameTemplate);
if ($this->documentFor == Order::DOCUMENT_FOR_SPARE_PART) {
$depoName = $this->order->products_in_order[0]->stantion_name;
$depoName = Utils::mb_str_replace(' ', '', $depoName);
$depoName = Utils::translit($depoName);
$fileNameTemplate = Utils::mb_str_replace('{depoName}', $depoName, $fileNameTemplate);
}
$fileNameTemplate = Utils::mb_str_replace('{currentDate}', time(), $fileNameTemplate);
$extension = $this->file->getClientOriginalExtension();
try {
Storage::disk('local')->put($clientFolder . DIRECTORY_SEPARATOR . $fileNameTemplate . '.' . $extension, File::get($this->file));
} catch (Exception $e) {
Log::error('Ошибка загрузки файла ' . $fileNameTemplate . ' message - ' . $e->getMessage());
return false;
}
return storage_path() . DIRECTORY_SEPARATOR . 'app' . $clientFolder . DIRECTORY_SEPARATOR . $fileNameTemplate . '.' . $extension;
}
/**
* 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));
}
/**
* Execute the command.
*
* @return void
*/
public function handle()
{
$selfFirmUser = User::with('firm')->where('role_id', User::ADMIN)->first();
$userCompany = User::with('firm')->where('id', $this->order->user_id)->first();
$products = $this->order->products_in_order;
$firm = $userCompany->firm;
$productsArr = [];
foreach ($products as $product) {
$productsArr[$this->depo->id][] = ['product_name' => $product->product_name, 'product_amount' => $product->product_amount, 'product_price' => $product->product_price, 'product_nds' => Product::getVAT_calculationByKey($product->nds), 'product_nds_as_str' => Product::getAllVAT_rateByKey($product->nds)];
}
$date = DateTime::createFromFormat('Y-m-d H:i:s', $this->order->created_at);
$date = strtotime($date->format('d F Y'));
if (!$firm->rp_face_fio) {
$faceFioArr = explode(' ', $firm->face_fio);
$lastName = isset($faceFioArr[0]) ? $faceFioArr[0] : '';
$name = isset($faceFioArr[1]) ? $faceFioArr[1] : '';
$secondName = isset($faceFioArr[2]) ? $faceFioArr[2] : '';
$petrovich = new Petrovich();
$petrovich->gender = $petrovich->detectGender($secondName);
if ($petrovich->gender == Petrovich::FAIL_MIDDLEWARE) {
$fio = $firm->face_fio;
} else {
$fio = $petrovich->lastname($lastName, Petrovich::CASE_GENITIVE) . ' ' . $petrovich->firstname($name, Petrovich::CASE_GENITIVE) . ' ' . $petrovich->middlename($secondName, Petrovich::CASE_GENITIVE);
$firm->rp_face_fio = $fio;
$firm->save();
}
} else {
$fio = $firm->rp_face_fio;
}
if (!$firm->rp_face_position) {
$facePosition = Utils::getGenitiveCase($firm->face_position);
if ($facePosition != $firm->face_position) {
$firm->rp_face_position = $facePosition;
$firm->save();
}
} else {
$facePosition = $firm->rp_face_position;
}
if (!$firm->rp_base_document) {
$baseDocument = Utils::getGenitiveCase($firm->base_document);
if ($baseDocument != $firm->base_document) {
$firm->rp_base_document = $baseDocument;
$firm->save();
}
} else {
$baseDocument = $firm->rp_base_document;
}
$pdf = App::make('dompdf.wrapper');
$pdf->loadView('documents.invoice', ['orderNumber' => $this->order->id, 'orderDate' => date('d.m.Y', $date), 'firm' => $firm, 'firmRpFio' => $fio, 'firmFacePosition' => $facePosition, 'firmBaseDocument' => $baseDocument, 'selfFirm' => $selfFirmUser->firm, 'products' => $productsArr, 'depoId' => $this->depo->id, 'depoName' => $this->depo->stantion_name]);
//$whereAreClientDocuments = storage_path().'/app'.Config::get('documents')['documents_folder'];
$documents = Config::get('documents');
$whereAreClientDocuments = $documents['documents_folder'];
//client_{id}
if (!Storage::disk('local')->exists($whereAreClientDocuments . '/client_' . Auth::user()->id)) {
Storage::makeDirectory($whereAreClientDocuments . '/client_' . Auth::user()->id);
}
//invoices
if (!Storage::disk('local')->exists($whereAreClientDocuments . '/client_' . Auth::user()->id . '/invoices')) {
Storage::makeDirectory($whereAreClientDocuments . '/client_' . Auth::user()->id . '/invoices');
}
$clientFolder = storage_path() . '/app' . $whereAreClientDocuments . '/client_' . Auth::user()->id . '/invoices';
//invoice_{orderID}_{depoName}_date_{currentDate}
$fileNameTemplate = $documents['client_invoice_template'];
$fileNameTemplate = Utils::mb_str_replace('{docType}', Order::getDocTypeName(Order::INVOICE_TYPE), $fileNameTemplate);
$fileNameTemplate = Utils::mb_str_replace('{orderID}', $this->order->id, $fileNameTemplate);
$depoName = Utils::mb_str_replace(' ', '', $this->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 . '/' . $fileNameTemplate);
$docs = new Document();
$docs->type = Order::INVOICE_TYPE;
$docs->user_id = Auth::user()->id;
$docs->order_id = $this->order->id;
$docs->file_name = $clientFolder . '/' . $fileNameTemplate;
$docs->sended = 1;
$docs->save();
}
public function checkGenitiveCase($firm_id, $order_id)
{
$firm = Firm::find($firm_id);
if (!$firm) {
abort(404);
}
$faceFioArr = explode(' ', $firm->face_fio);
$lastName = isset($faceFioArr[0]) ? $faceFioArr[0] : '';
$name = isset($faceFioArr[1]) ? $faceFioArr[1] : '';
$secondName = isset($faceFioArr[2]) ? $faceFioArr[2] : '';
$petrovich = new Petrovich();
$petrovich->gender = $petrovich->detectGender($secondName);
if ($petrovich->gender == Petrovich::FAIL_MIDDLEWARE) {
$fio = $firm->face_fio;
} else {
$fio = $petrovich->lastname($lastName, Petrovich::CASE_GENITIVE) . ' ' . $petrovich->firstname($name, Petrovich::CASE_GENITIVE) . ' ' . $petrovich->middlename($secondName, Petrovich::CASE_GENITIVE);
}
return view('documents.showGenitiveCase', ['orderId' => $order_id, 'fio' => $fio, 'firm_id' => $firm_id, 'document' => Utils::getGenitiveCase($firm->base_document), 'position' => Utils::getGenitiveCase($firm->face_position)]);
}
