Gecko [ thecigaretteboxes.com ]

Name	Size	Permission
AgentSaleExport.php	7.75 KB	-rw-r--r--
DailyLeadsExport.php	473 B	-rw-r--r--
DealExport.php	10.96 KB	-rw-r--r--
EstimationsExport.php	4.11 KB	-rw-r--r--
MarketingExport.php	11.3 KB	-rw-r--r--
MonthlyReportExport.php	2.38 KB	-rw-r--r--
OrderPNLExport.php	8.58 KB	-rw-r--r--
ProductionExport.php	8.54 KB	-rw-r--r--
ReordersExport.php	7.02 KB	-rw-r--r--
SalariesExport.php	8.01 KB	-rw-r--r--
ShippingExport.php	10.33 KB	-rw-r--r--

Code Editor : ReordersExport.php

<?php

namespace App\Exports;

use App\Models\Deal;
use App\Models\Tracking;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;

class ReordersExport implements FromCollection,WithHeadings,WithMapping
{
    /**
    * @return \Illuminate\Support\Collection
    */
    protected $deal_name;
    protected $user_deals;
    protected $from;
    protected $to;

function __construct($deal_name, $user_deals, $from, $to)
    {
        $this->deal_name = $deal_name;
        $this->user_deals = $user_deals;
        $this->from = $from;
        $this->to = $to;
    }

/**
     * @return \Illuminate\Support\Collection
     */
    public function collection()
    {
        $data = Deal::select('*')->with(['deals', 'client', 'dealProducts', 'dealProducts.product', 'dealProducts.productstyle'])->where('deal_status', 1)->where('deal_type_id', 1)->orderBy('open_date', 'desc');
        if ($this->deal_name) {
            $data->whereHas('client', function ($queryu) {
                $queryu->where('name', 'like', $this->deal_name . '%')->orWhere(function ($ques) {
                    $ques->whereHas('clientDetails', function ($queryu) {
                        $queryu->where('value', 'like', $this->deal_name . '%')->orWhere(function ($ques) {
                            $ques->where('order_number', 'like', $this->deal_name . '%');
                        });
                    });
                });
            });
        }
        if (!empty($this->user_deals)) {
            $data->where('owner_id', '=', $this->user_deals);
        } else {
            if (auth()->user()->id != 1 && auth()->user()->id != 90 && auth()->user()->id != 94) {
                $data->where('owner_id', '=', auth()->user()->id);
            }
        }
        if (!empty($this->from && $this->to)) {
            $data->whereBetween('close_date', [date($this->from), date($this->to)]);

} else {

$first = date("Y-m-d", strtotime("1-12-2021"));;
            $last = date("Y-m-d", strtotime("last day of this month"));
            $data->whereBetween('close_date', [date($first), date($last)]);

}
        $data->where('deal_status', '=', '1');
        $data->where(function ($q) {
            $q->where(function ($qs) {
                $qs->where('bd_pipeline_stage_id', '=', 4);
            })->orWhere('pipeline_stage_id', '=', 4);
        });
        //print_r($data);exit;

return $data->get();
        //return view('admin.deal.export',$data);

}

public function headings(): array
    {
        return [
           'Order Number',
            'Client Name',
            'Client Email',
            'Client Phone',
            'Product',
            'Box Style',
            'Box Printing',
            'Box Length',
            'Box Height',
            'Box Width',
            'Box Measurement',
            'Cardboard Stock',
            'Printing Color',
            'Quantity',
            'Est Amount',
            'Amount',
            'Lead Source',
            'Opening Date',
            'Closing Date',
            'Pipeline Stage',
            'Agent',
        ];
    }

/**
     * @var Invoice $deal
     */
    public function map($deal): array
    {
        $esamount = array();
        $quantity = array();
        $product='';
        $productstyle='';
        $product_printings='';
        $client='';
        $emails=array();
        $phone_no=array();
        if($deal->dealProducts){
            if(isset($deal->client->name)){
                $client=$deal->client->name;
            }
            foreach ($deal->dealProducts as  $productdetail){

foreach ($productdetail->dealProductQuantityAndEstimationAmounts as $key=>$qty) {
                    if($key==0) {
                        $quantity =    $qty->deal_product_quantity;
                    }
                }
            }
            foreach ($deal->dealProducts as $key=>  $productdetail){

foreach ($productdetail->dealProductQuantityAndEstimationAmounts as $key=> $qty) {
                    if($key==0) {
                        $esamount =    $qty->deal_product_est_amount;
                    }

}
            }
            foreach ($deal->dealProducts as  $productdetail){

foreach ($productdetail->dealProductQuantityAndEstimationAmounts as $key=> $qty) {
                    if($key==0) {
                        $amount = $qty->deal_product_amount;
                    }

}
            }

if(isset($deal->client->emails)){
                foreach ($deal->client->emails as $email){
                    $emails=    $email->value??'';
                }
            }
            if(isset($deal->client->phoneNos)) {
                foreach ($deal->client->phoneNos as $phoneNos) {
                    $phone_no = $phoneNos->value;
                }
            }
            foreach ($deal->dealProducts as $productdetail){
                $product=$productdetail->product->name;
            }
            foreach ($deal->dealProducts as $productdetail){
                if(isset($productdetail->productstyle)) {

$productstyle = $productdetail->productstyle->name;
                }
            }

foreach ($deal->dealProducts as $productdetail){
                $product_length=$productdetail->product_length ??'';
            }
            foreach ($deal->dealProducts as $productdetail){
                $product_width=$productdetail->product_width ??'';
            }
            foreach ($deal->dealProducts as $productdetail){
                $product_height=$productdetail->product_height??'';
            }foreach ($deal->dealProducts as $productdetail){
                $measurement=$productdetail->product_unit->unit??'';
            }

foreach ($deal->dealProducts as $productdetail){

$product_stock= $productdetail->product_stock->name??'';

}

foreach ($deal->dealProducts as $productdetail){

$productColor= $productdetail->productColor->name??'';

}

if($deal->close_date) {
                $closedate= date("d-m-Y", strtotime($deal->close_date));
            }else{
                $closedate='';
            }
        }

return [

[
                $deal->order_number,
                $client,

$emails,
                $phone_no,
                $product,
                $productstyle,
                $product_printings,
                $product_length,
                $product_width,
                $product_height,
                $measurement,
                $quantity,
                $product_stock,
                $productColor,
                $esamount,
                $amount,

$deal->lead_source->name,
                date("d-m-Y" ,strtotime($deal->open_date)),
                $closedate,
                $deal->piplelinestage->name,
                $deal->owner->first_name .' '. $deal->owner->last_name

]

];
    }
}

${this.title}

Code Editor : ReordersExport.php