如何使用laravel mvc将主id存储在另一个表中?

保存公司地址前设置公司Id:

$data->companies_id = $company->id;

或

$data['companies_id '] = $company->id;

public function store(CompanyRequest $request, Company $company, Companyaddress $companyaddress){   

        if(!Entrust::can('create-company'))
            return response()->json(['message' => trans('messages.permission_denied'), 'status' => 'error']);

        $data = $request->all();
        $company->fill($data)->save();
        $data->companies_id = $company->id; //Set company id here
        $companyaddress->fill($data)->save();
        storeCustomField($this->form,$company->id, $data);

        $this->logActivity(['module' => 'company_address','module_id' => $company->id,'activity' => 'added']);

        return response()->json(['message' => trans('messages.company').' '.trans('messages.added'), 'status' => 'success']);
    }

一个好方法是使用雄辩的关系来定义两者之间的关系。请参阅:

https://laravel.com/docs/5.4/eloquent-relationships

Company

public function address()
{
    return $this->hasOne(Companyaddress:class);
}

然后在控制器中,您可以执行以下操作:

$company = Company::create($data);
$company_address = Companyaddress::create($data);


$company->address()->save($company_address);

只需将其放在$data变量定义之前。(因为您已经设置了$company集合)

$request->merge(['companies_id'=>$company->id]);

首先通过添加函数在模型中添加一些关系。

class Company extends Eloquent {

    protected $fillable = [
                            'name',
                            'email',
                            'website',
                            'logo',
                            'phone',

                        ];
    protected $primaryKey = 'id';
    protected $table = 'companies';

    public function companyAddress() 
    {
       return $this->hasOne('App\CompanyAddress');
    }
}

在您的公司地址模型中。

class Companyaddress extends Eloquent {

    protected $fillable = [
                            'companies_id',
                            'address_line_1',
                            'address_line_2',
                            'city',
                            'state',
                            'zipcode',
                            'country_id',                           
                        ];
    protected $primaryKey = 'id';
    protected $table = 'company_address';

    public function companyAddress() 
    {
      return $this->belongsTo('App\Company');
    }
}

您可以在方法中添加此代码。

$companyAddress = new CompanyAddress;
$companyAddress->companies_id = $data->id;

$companyAddress->save();

https://laravel.com/api/5.4/Illuminate/Database/Eloquent/Relations.html

或者你可以在这里获得信息: Laravel, get last insert id using Eloquent

在您的情况下,如果一家公司有一个地址,您应该将其合并到一个表中。但如果需要,请点击这里:

class Company extends Eloquent {
protected $fillable = [
                        'id',
                        'name',
                        'email',
                        'website',
                        'logo',
                        'phone',

                    ];
protected $primaryKey = 'id';
protected $table = 'companies';

public function address(){
  $this->hasOne(CompanyAddress::class,'company_id','id')
}
}

模型CompanyAddress.php

class CompanyAddress extends Eloquent {

protected $fillable = [
                        'company_id',
                        'address_line_1',
                        'address_line_2',
                        'city',
                        'state',
                        'zipcode',
                        'country_id',                           
                    ];
protected $table = 'company_address';
}

在控制器中

public function store(CompanyRequest $request, Company $company, Companyaddress $companyaddress){   

    if(!Entrust::can('create-company'))
        return response()->json(['message' => trans('messages.permission_denied'), 'status' => 'error']);

    $data = $request->all();
    $company->fill($data)->save();
    $data->company_id = $company->id;
    $companyaddress->fill($data)->save();


    $this->logActivity(['module' => 'company_address','module_id' => $company->id,'activity' => 'added']);

    return response()->json(['message' => trans('messages.company').' '.trans('messages.added'), 'status' => 'success']);
}

public function getCompany($id){
    $company = Company::find($id);
    $company->address;
    return $company->toArray();
}

{
    id : ...,
    name : ...,
    .
    .
    .
    address : {
               company_id: ...,
               address_line_1: ...,
               .
               .
               .
              }
}

希望能有所帮助。谢谢