Viewing file:  DealExport.php (3.08 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Exports;
use App\Models\Deal;
use App\Models\User;
use App\Models\Stage;
use App\Models\Source;
use App\Models\Pipeline;
use App\Models\ClientDeal;
use App\Models\UserDeal;
use App\Models\Label;
use App\Models\ProductService;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
class DealExport implements FromCollection, WithHeadings
{
/**
* @return \Illuminate\Support\Collection
*/
public function collection()
{
$data = Deal::where('created_by', \Auth::user()->creatorId())->get();
foreach($data as $k => $deal)
{
$clientsData = ClientDeal::where('deal_id' , $deal->id)->get()->pluck('deal_id','client_id')->toArray();
$usersData = UserDeal::where('deal_id' , $deal->id)->pluck('deal_id','user_id')->toArray();
unset($deal->id,$deal->order,
$deal->created_by,$deal->is_active , $deal->status,
$deal->created_at,$deal->updated_at);
$pipeline = Pipeline::find($deal->pipeline_id);
$stage = Stage::find($deal->stage_id);
$sources = Source::whereIn('id', explode(',', $deal->sources))->get();
$sourceName = [];
foreach ($sources as $source) {
$sourceName[] = $source->name;
}
$products = ProductService::whereIn('id', explode(',', $deal->products))->get();
$productName = [];
foreach ($products as $product) {
$productName[] = $product->name;
}
$labels = Label::whereIn('id', explode(',', $deal->products))->get();
$labelName = [];
foreach ($labels as $label) {
$labelName[] = $label->name;
}
$users = User::whereIn('id', array_keys($usersData))->get();
$userName = [];
foreach ($users as $user) {
$userName[] = $user->name;
}
$clients = User::whereIn('id', array_keys($clientsData))->get();
$clientName = [];
foreach ($clients as $client) {
$clientName[] = $client->name;
}
$deal["client_id"] = '';
$deal["user_id"] = '';
$data[$k]["pipeline_id"] = $pipeline->name;
$data[$k]["stage_id"] = $stage->name;
$data[$k]["sources"] = implode(',', $sourceName);
$data[$k]["products"] = implode(',', $productName);
$data[$k]["labels"] = implode(',', $labelName);
$data[$k]["client_id"] = implode(',', $clientName);
$data[$k]["user_id"] = implode(',', $userName);
}
return $data;
}
public function headings(): array
{
return [
"Name",
"Phone",
"Price",
"Pipeline",
"Deal Stage",
"Deal Sources",
"Products",
"Notes",
"Labels",
"Clients",
"Deal User"
];
}
}
|