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 : ShippingExport.php

<?php

namespace App\Exports;

use App\Models\Deal;
use Illuminate\Foundation\Auth\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithHeadings;
class ShippingExport implements FromCollection,WithHeadings,WithMapping
{

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','vendor','production_details','dealProducts','dealProducts.product','tracking_details','dealProducts.productstyle','owner'])->orderBy('id','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!=63 &&   auth()->user()->id!=276 &&  auth()->user()->id!=207 &&  auth()->user()->id!=188 &&  auth()->user()->id!=106 &&  auth()->user()->id!=90 &&  auth()->user()->id!=94) {
            $data->where('owner_id', '=', auth()->user()->id);
        }
    }
        if (!empty($this->from && $this->to)) {
            $data->whereHas('tracking_details', function ($queryu)  {
                if (!empty($this->from && $this->to)) {
                    $queryu->whereBetween('shipping_date', [date($this->from), date($this->to)]);

} else {

$first = date("Y-m-d", strtotime("1-02-2017"));;
                    $last = date("Y-m-d", strtotime("last day of this month"));
                    $queryu->whereBetween('shipping_date', [date($first), date($last)]);

}
            });}
        $data->where('complete_status','=','0');
        //$data->where('production_status','=','1')->where('deal_status','=','1')->where('shipping_status','=','0')->orWhere('designer_status','=','1');
        $data->where(function ($quer){
            $quer->where('shipping_status','=',1)
                ->orWhere('delivery_status','=',1);
        })->where(function ($q){
            $q->where(function ($qs){
                $qs->where('bd_pipeline_stage_id','=',4)->where('pipeline_stage_id','=',5);
            })->orWhere('pipeline_stage_id','=',4);
        });

// print_r($data->get());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 Width',
            'Box Height',
            'Box Measurement Units',
            'Quantity',
            'Cardboard Stock',
            'Printing Color',

'Shipping Date',
            'Shipping Weight',
            'Fare',
            'Tracking Number',
            'Courier Company',
            'Agent'
        ];
    }
    /**
     * @var Invoice $deal
     */
    public function map($deal): array
    {
        $esamount = array();
        $quantity = array();
        $product='';
        $productstyle='';
        $product_printings = '';
        $ramount='';
        $balance=0;
        $client='';
        $emails=array();
        $phone_no=array();
        $shipping_date='';
        $shipping_weight='';
        $shipping_fare='';
        $shipping_tracking='';
        $shipping_company='';
        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;
                    }

}
            }

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

foreach ($productdetail->dealProductQuantityAndEstimationAmounts as $key => $qty) {
                    if ($key == 0) {
                        $ramount = $qty->receive_able_amount;

}

}
            }
            $balance = $amount - $ramount;
            foreach ($deal->dealProducts as $key => $productdetail) {
                foreach ($productdetail->product_printings as $k => $qty) {
                    if ($k == 0) {
                        $product_printingsa = $qty->name;
                    } else {
                        $product_printingsa .= '-' . $qty->name;
                    }
                     $product_printings =$product_printingsa;
                }

}

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) {

$product_unit = $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->lead_type_id == 1) {

$lead_type = 'Lead';
            } elseif ($deal->lead_type_id == 2) {
                $lead_type = 'In Complete';
            } else {
                $lead_type = 'Over Size | Pizza Boxes';
            }

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

foreach ($deal->tracking_details as $key => $trackingdetail) {
                if ($key == 0) {
                    if ($trackingdetail->shipping_date) {

$shipping_date = date('d-m-Y', strtotime($trackingdetail->shipping_date)) ?? "";

}
                }
            }
            foreach ($deal->tracking_details as $key => $trackingdetail) {
                if ($key == 0) {
                    if ($trackingdetail->weight) {

$shipping_weight = $trackingdetail->weight ?? "";

}
                }
            }

foreach ($deal->tracking_details as $key => $trackingdetail) {
                if ($key == 0) {
                    if ($trackingdetail->amount) {

$shipping_fare = $trackingdetail->amount ?? "";

}
                }
            }

foreach ($deal->tracking_details as $key => $trackingdetail) {
                if ($key == 0) {
                    if ($trackingdetail->tracking_number) {

$shipping_tracking = $trackingdetail->tracking_number ?? "";

}
                }
            }

foreach ($deal->tracking_details as $key => $trackingdetail) {
                if ($key == 0) {
                    if ($trackingdetail->courier_id == 1) {
                        $shipping_company='DHL';
                    } else {
                        $shipping_company='FEDEX';
                    }

}
            }
        }
        return [

[
                $deal->order_number,
                $client,
                $emails,
                $phone_no,
                $product,
                $productstyle,
                $product_printings,
                $product_length,
                $product_width,
                $product_height,
                $product_unit,
                $quantity,
                $product_stock,
                $productColor,
                $shipping_date,
                $shipping_weight,
                $shipping_fare,
                $shipping_tracking,
                $shipping_company,
                $deal->owner->first_name .' '.$deal->owner->last_name

]

];
    }

}

${this.title}

Code Editor : ShippingExport.php