mercredi 23 janvier 2019

Update join 2 table using import excel in laravel

i want to update 2 relation table, i have tried it but i got an error. i am using laravel 5.7 and Maatwebsite 3.1.

This is my controller, i put excel data in $data:

public function import(){
 $data = Excel::toArray(new AssignmentFAImport, request()->file('file')); 
    if ($data) {
        collect(head($data))
        ->each(function ($row, $key) {
            DB::table('fa_transaction')
                ->join('customer', 'fa_transaction.fa_transaction_id', '=', 'customer.fa_transaction_id')
                ->where('fa_transaction_id', $row['fa_transaction_id'])
                ->update(array_except($row, ['fa_transaction_id']));
        });

        return "Success";
    }else{
        return "Can not update";
    }
}

and this import class :

<?php

namespace App\Imports;

use App\Models\Transaction\FA_transaction;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class AssignmentFAImport implements ToModel, WithHeadingRow
{
/**
* @param array $row
*
* @return \Illuminate\Database\Eloquent\Model|null
*/
public function model(array $row)
{
    return new FA_transaction([
        'nomen' => $row['nomen'],
        'dispatch_group' => $row['dispatch_group'],
        'address' => $row['address'],
        'fa_transaction_id' => $row['fa_transaction_id'],
        'fa_type_cd' => $row['fa_type_cd'],
        'pcezbk' => $row['pcezbk'],
        'status' => $row['status'],
        'created_at' => $row['created_at'],
        'worker_id' => $row['worker_id'],
        'assign_date' => $row['assign_status'],
        'reassigned_date' => $row['reassigned_date'],
        'assign_status' => $row['assign_status'],
        'urgent_status' => $row['urgent_status'],
        'priority_status' => $row['priority_status'],
        'sending_status' => $row['sending_status']
    ]);
   }
  }

and i got an error like this:

Illuminate \ Database \ QueryException (42000)
SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL 
Server]Ambiguous column name 'fa_transaction_id'. (SQL: update 
[fa_transaction] set [nomen] = 60215072, [dispatch_group] = CC31-DR , 
[address] = JL KALI BARU TMR NO 32 RT 012 RW 013 , [fa_type_cd] = FA-T4E , 
[pcezbk] = 0760309, [status] = P , [created_at] = 2018-11-16 00:00:00.000, 
[worker_id] = 2, [assign_date] = 2019-01-22 08:54:48.000, [reassigned_date] 
= , [assign_status] = Assigned, [urgent_status] = 1, [priority_status] = , 
[sending_status] = from [fa_transaction] inner join [customer] on 
[fa_transaction].[fa_transaction_id] = [customer].[fa_transaction_id] where 
[fa_transaction_id] = 0210559377)

i don't know why column name is Ambiguous, how to fix it?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire