90 lines
3.3 KiB
PHP
90 lines
3.3 KiB
PHP
<?php
|
|
|
|
namespace App\Imports;
|
|
|
|
use Illuminate\Support\Collection;
|
|
use Maatwebsite\Excel\Concerns\ToCollection;
|
|
use App\Models\Product;
|
|
use App\Models\InvoiceDiscounting;
|
|
use App\Models\Table;
|
|
use Maatwebsite\Excel\Concerns\WithHeadingRow;
|
|
use Illuminate\Support\Str;
|
|
use Illuminate\Support\Facades\Validator;
|
|
use Maatwebsite\Excel\Concerns\WithHeadings;
|
|
|
|
class InvoiceDiscountingImport implements ToCollection, WithHeadingRow
|
|
{
|
|
/**
|
|
* @param Collection $collection
|
|
*/
|
|
protected $category_id;
|
|
|
|
public function __construct($category_id)
|
|
{
|
|
$this->category_id= $category_id;
|
|
}
|
|
|
|
public function rules(): array
|
|
{
|
|
// return null;
|
|
return [
|
|
// '*.company_name' => 'required|unique:invoice_discountings,company_name'
|
|
// '*.property_name' => 'required|unique:fractional_real_estates,property_name'
|
|
// '*.min_investment' => 'required',
|
|
// '*.return_rate' => 'required',
|
|
];
|
|
}
|
|
|
|
public function customValidationMessages(Collection $rows)
|
|
{
|
|
$messages = [];
|
|
foreach ($rows as $key => $val) {
|
|
$messages[''.$key.'.company_name.required'] = 'Company Name should not be empty at row ' . $key+1;
|
|
$messages[''.$key.'.company_name.unique'] = 'Company Name is not unique at row ' . $key+1;
|
|
}
|
|
return $messages;
|
|
// return [
|
|
// '*.property_name.required' => 'Property name must not be empty!'
|
|
// // '*.min_investment.required' => 'Minimun Investment must not be empty!',
|
|
// // '*.return_rate.required' => 'Return Rate must not be empty!'
|
|
// ];
|
|
}
|
|
|
|
public function collection(Collection $rows)
|
|
{
|
|
Validator::make($rows->toArray(), $this->rules(), $this->customValidationMessages($rows))->validate();
|
|
|
|
foreach ($rows as $row) {
|
|
$product = Product::create([
|
|
'tables_id' => Table::InvoiceDiscountingTable,
|
|
'categories_id' => $this->category_id,
|
|
'total_views' => 0,
|
|
'status' => 0,
|
|
'created_by' => auth()->user()->id
|
|
]);
|
|
|
|
|
|
InvoiceDiscounting::create([
|
|
'products_id' => $product->id,
|
|
'slug' => Str::slug($row['company_name']),
|
|
'company_name' => $row['company_name'],
|
|
'sector' => $row['sector'],
|
|
'about_company' => $row['about_the_company'],
|
|
'key_performance_metrics' => $row['key_performance_metrics'],
|
|
'minimum_investment' => $row['minimum_investment'],
|
|
'total_deal_size' => $row['total_deal_size'],
|
|
'tenure' => $row['tenure'],
|
|
'pre_tax_irr' => $row['pre_tax_irr'],
|
|
'coupon_rate' => $row['coupon_rate'],
|
|
'vendor' => $row['vendor'],
|
|
'recourse_on' => $row['recourse_on'],
|
|
'settlement_date' => $row['settlement_date'],
|
|
'payout_frequency' => $row['payout_frequency'],
|
|
'payment_obligor' => $row['payment_obligor'],
|
|
'security_structure' => $row['security_structure'],
|
|
'minimum_investment_in_int' => $row['minimum_investment_in_int'],
|
|
]);
|
|
}
|
|
}
|
|
}
|