Root Explorer PHP

Editing: CompanyImport.php

<?php

namespace App\Imports;

use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\ToModel;
use Illuminate\Support\Facades\Log;

use App\Models\ {
    Company,
    CompanyContactDetail,
    CompanyForeignCollaboration,
    CompanyKeyPersonnel,
    CompanyProductDetails,
};

class CompanyImport implements ToCollection
{
    /**
    * @param Collection $collection
    */
    public function collection(Collection $rows)
    {

$rows = $rows->skip(1);
                
        $formatted_rows = $this->format_in_assoc_array($rows);

foreach($formatted_rows as $row){

// check if company

if (!empty(trim($row['name'])) && !empty(trim($row['email']))) {
            
            
                $company = new Company();
                $company->name = $row['name'];
                $company->email = $row['email'];
                $company->website = $row['website'];
                
                try{
                    $company->save();
                    Log::info($company->name .' created');
                }catch (\Exception $e) {
                    Log::info($e->getMessage());
                }

$company_contact_details = new CompanyContactDetail();
                $company_contact_details->company_id = $company->id;
                $company_contact_details->company_address = $row['company_address'];
                $company_contact_details->pin = $row['pin'];
                $company_contact_details->city = preg_replace('/\s+/', ' ',$row['city']);
                $company_contact_details->state = preg_replace('/\s+/', ' ', $row['state']);
                $company_contact_details->image = $row['image'];
                $company_contact_details->address2 = $row['address2'];
                $company_contact_details->address3 = $row['address3'];
                $company_contact_details->phone = $row['phone'];
                $company_contact_details->fax = $row['fax'];
                $company_contact_details->mainaddress1 = $row['mainaddress1'];
                $company_contact_details->mainaddress2 = $row['mainaddress2'];
                $company_contact_details->maincity = $row['maincity'];
                $company_contact_details->plant_pin = $row['plant_pin'];
                $company_contact_details->mainstate = $row['mainstate'];
                $company_contact_details->plant_phone = $row['plant_phone'];
                $company_contact_details->plant_fax = $row['plant_fax'];
                $company_contact_details->plant_email = $row['plant_email'];
                $company_contact_details->overseas_plant_1 = $row['overseas_plant_1'];
                $company_contact_details->overseas_plant_2 = $row['overseas_plant_2'];
                $company_contact_details->overseas_plant_3 = $row['overseas_plant_3'];
                $company_contact_details->otheraddress = $row['otheraddress'];
                $company_contact_details->otheraddress_1 = $row['otheraddress_1'];
                $company_contact_details->otherplant_address1 = $row['otherplant_address1'];
                $company_contact_details->otherplant_address2 = $row['otherplant_address2'];
                $company_contact_details->otherplant_address3 = $row['otherplant_address3'];
                $company_contact_details->year_commencing = $row['year_commencing'];
            
                $company_contact_details->save();

$CompanyKeyPersonnel = new CompanyKeyPersonnel();
                $CompanyKeyPersonnel->company_id = $company->id;
                $CompanyKeyPersonnel->managing_director = $row['managing_director'];
                $CompanyKeyPersonnel->chief_executive  = $row['chief_executive'];
                $CompanyKeyPersonnel-> sales_in_charge = $row['sales_in_charge'];
                $CompanyKeyPersonnel-> export_in_charge = $row['export_in_charge'];
                $CompanyKeyPersonnel->production_in_charge = $row['production_in_charge'];
                $CompanyKeyPersonnel->quality_in_charge = $row['quality_in_charge'];
                $CompanyKeyPersonnel->hrd_incharge = $row['hrd_incharge'];
                $CompanyKeyPersonnel->rnd_incharge = $row['rnd_incharge'];
                $CompanyKeyPersonnel->update_date = $row['update_date'];
                $CompanyKeyPersonnel->region = $row['region'];

$CompanyKeyPersonnel->save();

$CompanyProductDetails = new CompanyProductDetails();
                $CompanyProductDetails->company_id = $company->id;

$CompanyProductDetails->products_manufactured = preg_replace('/\s+/', ' ', $row['products_manufactured']);
                $CompanyProductDetails->product2 = preg_replace('/\s+/', ' ', $row['product2']);
                $CompanyProductDetails->product3 = preg_replace('/\s+/', ' ', $row['product3']);
                $CompanyProductDetails->product4 = preg_replace('/\s+/', ' ', $row['product4']);
                $CompanyProductDetails->scale = $row['scale'];
                $CompanyProductDetails->ssi_info= $row['ssi_info'];
                $CompanyProductDetails->trademark= $row['trademark']; 
                $CompanyProductDetails->total_capital= $row['total_capital'];
                $CompanyProductDetails->net_investment_plant = $row['net_investment_plant']; 
                $CompanyProductDetails->total_investment_plant = $row['total_investment_plant']; 
                $CompanyProductDetails->sales_turnover= $row['sales_turnover'];
                $CompanyProductDetails->s_turn_in= $row['s_turn_in'];
                $CompanyProductDetails->export_turn_02_03= $row['export_turn_02_03'];
                $CompanyProductDetails->exports_in_mln= $row['exports_in_mln'];
                $CompanyProductDetails->number_of_employees= $row['number_of_employees'];
                $CompanyProductDetails->skilled= $row['skilled'];
                $CompanyProductDetails->semi_skilled= $row['semi_skilled'];
                $CompanyProductDetails->un_skilled= $row['un_skilled'];
                $CompanyProductDetails->contractual= $row['contractual'];
                $CompanyProductDetails->management_above= $row['management_above'];
            
                $CompanyProductDetails->other_mark1= $row['other_mark1'];
                $CompanyProductDetails->other_mark2= $row['other_mark2'];
                $CompanyProductDetails->domesticoe= $row['domesticoe'];
                $CompanyProductDetails->domesticoe1= $row['domesticoe1'];
                $CompanyProductDetails->domesticoe2= $row['domesticoe2'];
                $CompanyProductDetails->domesticoe3= $row['domesticoe3'];
                $CompanyProductDetails->domesticoe4= $row['domesticoe4'];
                $CompanyProductDetails->domestic_tier_oe= $row['domestic_tier_oe'];
                $CompanyProductDetails->domestic_tier_oe1= $row['domestic_tier_oe1'];
                $CompanyProductDetails->domestic_tier_oe2= $row['domestic_tier_oe2'];
                $CompanyProductDetails->domestic_tier_oe3= $row['domestic_tier_oe3'];
                $CompanyProductDetails->cusint1= $row['cusint1'];
                $CompanyProductDetails->cusint2= $row['cusint2'];
                $CompanyProductDetails->cusint3= $row['cusint3'];
                $CompanyProductDetails->cusint_tier1= $row['cusint_tier1'];
                $CompanyProductDetails->cusint_tier2= $row['cusint_tier2'];
                $CompanyProductDetails->cusint_tier3= $row['cusint_tier3'];
                $CompanyProductDetails->afmkt1= $row['afmkt1'];
                $CompanyProductDetails->afmkt2= $row['afmkt2'];
                $CompanyProductDetails->afmkt3= $row['afmkt3'];

$CompanyProductDetails->save();

$CompanyForeignCollaboration =  new CompanyForeignCollaboration();
                $CompanyForeignCollaboration->company_id = $company->id;
                $CompanyForeignCollaboration->f_collab1 = $row['f_collab1'];
                $CompanyForeignCollaboration->f_prod1 = $row['f_prod1'];
                $CompanyForeignCollaboration->nature1 = $row['nature1'];
                $CompanyForeignCollaboration->per1 = $row['per1'];
                $CompanyForeignCollaboration->f_collab2 = $row['f_collab2'];
                $CompanyForeignCollaboration->f_prod2 = $row['f_prod2'];
                $CompanyForeignCollaboration->nature2 = $row['nature2'];
                $CompanyForeignCollaboration->per2 = $row['per2'];
                $CompanyForeignCollaboration->f_collab3 = $row['f_collab3'];
                $CompanyForeignCollaboration->f_prod3 = $row['f_prod3'];
                $CompanyForeignCollaboration->nature3 = $row['nature3'];
                $CompanyForeignCollaboration->per3 = $row['per3'];
                $CompanyForeignCollaboration->f_collab4 = $row['f_collab4'];
                $CompanyForeignCollaboration->f_prod4 = $row['f_prod4'];
                $CompanyForeignCollaboration->nature4 = $row['nature4'];
                $CompanyForeignCollaboration->per4 = $row['per4'];
                $CompanyForeignCollaboration->f_collab5 = $row['f_collab5'];
                $CompanyForeignCollaboration->f_prod5 = $row['f_prod5'];
                $CompanyForeignCollaboration->nature5 = $row['nature5'];
                $CompanyForeignCollaboration->per5 = $row['per5'];
                $CompanyForeignCollaboration->f_collab6 = $row['f_collab6'];
                $CompanyForeignCollaboration->f_prod6 = $row['f_prod6'];
                $CompanyForeignCollaboration->nature6 = $row['nature6'];
                $CompanyForeignCollaboration->per6 = $row['per6'];
                $CompanyForeignCollaboration->f_collab7 = $row['f_collab7'];
                $CompanyForeignCollaboration->f_prod7 = $row['f_prod7'];
                $CompanyForeignCollaboration->nature7 = $row['nature7'];
                $CompanyForeignCollaboration->per7 = $row['per7'];
                $CompanyForeignCollaboration->f_collab8 = $row['f_collab8'];
                $CompanyForeignCollaboration->f_prod8 = $row['f_prod8'];
                $CompanyForeignCollaboration->nature8 = $row['nature8'];
                $CompanyForeignCollaboration->per8 = $row['per8'];
                $CompanyForeignCollaboration->f_collab9 = $row['f_collab9'];
                $CompanyForeignCollaboration->f_prod9 = $row['f_prod9'];
                $CompanyForeignCollaboration->nature9 = $row['nature9'];
                $CompanyForeignCollaboration->per9 = $row['per9'];
                $CompanyForeignCollaboration->f_collab10 = $row['f_collab10'];
                $CompanyForeignCollaboration->f_prod10 = $row['f_prod10'];
                $CompanyForeignCollaboration->nature10 = $row['nature10'];
                $CompanyForeignCollaboration->per10 = $row['per10'];
                
                $CompanyForeignCollaboration->member = $row['member'];
                $CompanyForeignCollaboration->iso = $row['iso'];
                $CompanyForeignCollaboration->isodate = $row['isodate'];
                $CompanyForeignCollaboration->isoagency = $row['isoagency'];
                $CompanyForeignCollaboration->qs = $row['qs'];
                $CompanyForeignCollaboration->qsdate = $row['qsdate'];
                $CompanyForeignCollaboration->qsagency = $row['qsagency'];
                $CompanyForeignCollaboration->iso14 = $row['iso14'];
                $CompanyForeignCollaboration->iso14date = $row['iso14date'];
                $CompanyForeignCollaboration->iso14agency = $row['iso14agency'];
                $CompanyForeignCollaboration->ts = $row['ts'];
                $CompanyForeignCollaboration->tsdate = $row['tsdate'];
                $CompanyForeignCollaboration->tsagency = $row['tsagency'];
                $CompanyForeignCollaboration->deming_award = $row['deming_award'];
                $CompanyForeignCollaboration->japan_quality_medal = $row['japan_quality_medal'];
                $CompanyForeignCollaboration->emark = $row['emark'];
                $CompanyForeignCollaboration->bismark = $row['bismark'];

$CompanyForeignCollaboration->save(); 
            }

}
    }

public function format_in_assoc_array($rows){
        $companies = [];
        $companies_data_format = [
            'company_name' => '',
            'company_address' => '',
            'pin' => '',
        ];

foreach($rows as $row){
            // continue for first row

// if($loop->index == 0){
            //     continue;
            // }
            
            $companies_data_format['name'] = $row[0];
            $companies_data_format['email'] = $row[1];
            $companies_data_format['website'] = $row[2];
            $companies_data_format['company_address'] = $row[3];
            $companies_data_format['pin'] = $row[4];
            $companies_data_format['city'] = $row[5];
            $companies_data_format['state'] = $row[6];
            $companies_data_format['image'] = $row[7];
            $companies_data_format['address2'] = $row[8];
            $companies_data_format['address3'] = $row[9];
            $companies_data_format['phone'] = $row[10];
            $companies_data_format['fax'] = $row[11];
            $companies_data_format['mainaddress1'] = $row[12];
            $companies_data_format['mainaddress2'] = $row[13];
            $companies_data_format['maincity'] = $row[14];
            $companies_data_format['plant_pin'] = $row[15];
            $companies_data_format['mainstate'] = $row[16];
            $companies_data_format['plant_phone'] = $row[17];
            $companies_data_format['plant_fax'] = $row[18];
            $companies_data_format['plant_email'] = $row[19];
            $companies_data_format['overseas_plant_1'] = $row[20];
            $companies_data_format['overseas_plant_2'] = $row[21];
            $companies_data_format['overseas_plant_3'] = $row[22];
            $companies_data_format['otheraddress'] = $row[23];
            $companies_data_format['otheraddress_1'] = $row[24];
            $companies_data_format['otherplant_address1'] = $row[25];
            $companies_data_format['otherplant_address2'] = $row[26];
            $companies_data_format['otherplant_address3'] = $row[27];
            $companies_data_format['year_commencing'] = $row[28];
            $companies_data_format['managing_director'] = $row[29];
            $companies_data_format['chief_executive'] = $row[30];
            $companies_data_format['sales_in_charge'] = $row[31];
            $companies_data_format['export_in_charge'] = $row[32];
            $companies_data_format['production_in_charge'] = $row[33];
            $companies_data_format['quality_in_charge'] = $row[34];
            $companies_data_format['hrd_incharge'] = $row[35];
            $companies_data_format['rnd_incharge'] = $row[36];
            $companies_data_format['update_date'] = $row[37];
            $companies_data_format['region'] = $row[38];
            $companies_data_format['products_manufactured'] = $row[39];
            $companies_data_format['product2'] = $row[40];
            $companies_data_format['product3'] = $row[41];
            $companies_data_format['product4'] = $row[42];
            $companies_data_format['scale'] = $row[43];
            $companies_data_format['ssi_info'] = $row[44];
            $companies_data_format['trademark'] = $row[45];
            $companies_data_format['total_capital'] = $row[46];
            $companies_data_format['net_investment_plant'] = $row[47];
            $companies_data_format['total_investment_plant'] = $row[48];
            $companies_data_format['sales_turnover'] = $row[49];
            $companies_data_format['s_turn_in'] = $row[50];
            $companies_data_format['export_turn_02_03'] = $row[51];
            $companies_data_format['exports_in_mln'] = $row[52];
            $companies_data_format['number_of_employees'] = $row[53];
            $companies_data_format['skilled'] = $row[54];
            $companies_data_format['semi_skilled'] = $row[55];
            $companies_data_format['un_skilled'] = $row[56];
            $companies_data_format['contractual'] = $row[57];
            $companies_data_format['management_above'] = $row[58];
            $companies_data_format['other_mark1'] = $row[59];
            $companies_data_format['other_mark2'] = $row[60];
            $companies_data_format['domesticoe'] = $row[61];
            $companies_data_format['domesticoe1'] = $row[62];
            $companies_data_format['domesticoe2'] = $row[63];
            $companies_data_format['domesticoe3'] = $row[64];
            $companies_data_format['domesticoe4'] = $row[65];
            $companies_data_format['domestic_tier_oe'] = $row[66];
            $companies_data_format['domestic_tier_oe1'] = $row[67];
            $companies_data_format['domestic_tier_oe2'] = $row[68];
            $companies_data_format['domestic_tier_oe3'] = $row[69];
            $companies_data_format['cusint1'] = $row[70];
            $companies_data_format['cusint2'] = $row[71];
            $companies_data_format['cusint3'] = $row[72];
            $companies_data_format['cusint_tier1'] = $row[73];
            $companies_data_format['cusint_tier2'] = $row[74];
            $companies_data_format['cusint_tier3'] = $row[75];
            $companies_data_format['afmkt1'] = $row[76];
            $companies_data_format['afmkt2'] = $row[77];
            $companies_data_format['afmkt3'] = $row[78];
            $companies_data_format['f_collab1'] = $row[79];
            $companies_data_format['f_prod1'] = $row[80];
            $companies_data_format['nature1'] = $row[81];
            $companies_data_format['per1'] = $row[82];
            $companies_data_format['f_collab2'] = $row[83];
            $companies_data_format['f_prod2'] = $row[84];
            $companies_data_format['nature2'] = $row[85];
            $companies_data_format['per2'] = $row[86];
            $companies_data_format['f_collab3'] = $row[87];
            $companies_data_format['f_prod3'] = $row[88];
            $companies_data_format['nature3'] = $row[89];
            $companies_data_format['per3'] = $row[90];
            $companies_data_format['f_collab4'] = $row[91];
            $companies_data_format['f_prod4'] = $row[92];
            $companies_data_format['nature4'] = $row[93];
            $companies_data_format['per4'] = $row[94];
            $companies_data_format['f_collab5'] = $row[95];
            $companies_data_format['f_prod5'] = $row[96];
            $companies_data_format['nature5'] = $row[97];
            $companies_data_format['per5'] = $row[98];
            $companies_data_format['f_collab6'] = $row[99];
            $companies_data_format['f_prod6'] = $row[100];
            $companies_data_format['nature6'] = $row[101];
            $companies_data_format['per6'] = $row[102];
            $companies_data_format['f_collab7'] = $row[103];
            $companies_data_format['f_prod7'] = $row[104];
            $companies_data_format['nature7'] = $row[105];
            $companies_data_format['per7'] = $row[106];
            $companies_data_format['f_collab8'] = $row[107];
            $companies_data_format['f_prod8'] = $row[108];
            $companies_data_format['nature8'] = $row[109];
            $companies_data_format['per8'] = $row[110];
            $companies_data_format['f_collab9'] = $row[111];
            $companies_data_format['f_prod9'] = $row[112];
            $companies_data_format['nature9'] = $row[113];
            $companies_data_format['per9'] = $row[114];
            $companies_data_format['f_collab10'] = $row[115];
            $companies_data_format['f_prod10'] = $row[116];
            $companies_data_format['nature10'] = $row[117];
            $companies_data_format['per10'] = $row[118];
            $companies_data_format['member'] = $row[119];
            $companies_data_format['iso'] = $row[120];
            $companies_data_format['isodate'] = $row[121];
            $companies_data_format['isoagency'] = $row[122];
            $companies_data_format['qs'] = $row[123];
            $companies_data_format['qsdate'] = $row[124];
            $companies_data_format['qsagency'] = $row[125];
            $companies_data_format['iso14'] = $row[126];
            $companies_data_format['iso14date'] = $row[127];
            $companies_data_format['iso14agency'] = $row[128];
            $companies_data_format['ts'] = $row[129];
            $companies_data_format['tsdate'] = $row[130];
            $companies_data_format['tsagency'] = $row[131];
            $companies_data_format['deming_award'] = $row[132];
            $companies_data_format['japan_quality_medal'] = $row[133];
            $companies_data_format['emark'] = $row[134];
            $companies_data_format['bismark'] = $row[135];

$companies[] = $companies_data_format;
        }
        return $companies;
    }
}

[ CANCEL ]

Name	Type	Actions
.. (Parent Directory)
📄 CompanyImport.php	FILE	[EDIT]

[ Root System Explorer ]

Editing: CompanyImport.php