000

<?php

namespace App\Exports;

use App\User;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use DB;
class MrnExport implements FromView, WithColumnFormatting, WithColumnWidths
{
	public $mrns;
  public $all_suppliers;
	function __construct($mrns = null, $all_suppliers)
	{
		$this->mrns = $mrns;
    $this->all_suppliers = $all_suppliers;
	}

public function columnFormats(): array
  {
      return [
				'O' => '@',
      ];
  }

public function columnWidths(): array
  {
      return [
          'O' => 40,              
      ];
  }
	
  public function view(): View
  {

// foreach ($this->mrns as $mrn) {
    //   $supplier_name = '';
  	//  	$supplier_code = '';										
  	//  	if(array_key_exists($mrn->reference_number, $this->all_suppliers)) {
  	// 	 	$supplier_name = $this->all_suppliers[$mrn->reference_number]['vendor_name'];
  	// 	 	$supplier_code = $this->all_suppliers[$mrn->reference_number]['vendor_code'];
  	//  	}
    //   echo "supplier name :".$supplier_name;
    //   echo "supplier code :".$supplier_code;
    // }
    // exit;		
    // foreach ($this->mrns as $mrn) {
    //   if(array_key_exists($mrn->reference_number, $this->all_suppliers)) {
    //     echo 'vendor code is :'.$vendor_code = $this->all_suppliers[$mrn->reference_number]['vendor_code'];
    //   }        
    // }
    // dd('stop');

return view('exports.mrns', [ 'mrns' => $this->mrns, 'all_suppliers' => $this->all_suppliers, 'mrn_no'=> '']);
  }

}