laravel - 如何在 Laravel 中手动设置主键值

Question

我正在尝试在 Laravel 5.6 中手动设置主键值，但在保存记录时它返回 0。这是我的控制器功能代码。

   $next = collect(DB::select('SELECT IFNULL(MAX(IFNULL(lvl1,0)),0)+10 AS NEXTVAL FROM coa_lvl1'))->first()->NEXTVAL;

    $lvl1_id = new CoaLvl1();
    $lvl1_id->lvl1 = $next;
    $this->lvl1->create(array_merge($request->all(),['lvl1' => $next , 'lvl1_code' => $request->get('group_id').'/'.$next]));

coa_lvl1 的迁移：

    Schema::create('coa_lvl1', function (Blueprint $table) {
        $table->tinyInteger('group_id');
        $table->integer('lvl1')->unsigned();
        $table->tinyInteger('lvl1_code');
        $table->string('lvl1_name',300);
        $table->integer('created_by')->nullable(false);
        $table->timestamp('created_date')->default(DB::raw('CURRENT_TIMESTAMP'));
        $table->integer('last_update_by');
        $table->timestamp('last_update_date')->default(DB::raw('0 ON UPDATE CURRENT_TIMESTAMP'));
        $table->string('active_flag',1)->default('1');
        $table->primary('lvl1');
        $table->foreign('group_id')
            ->references('group_id')
            ->on('coa_group')
            ->onDelete('cascade');
    });

在我的模型中

  protected $table = 'coa_lvl1';

 protected $primaryKey = 'lvl1';

public $incrementing = false;

protected $blameable  = array('created','updated');

protected $fillable = ['group_id','lvl1_code','lvl1_name','active_flag'];

  public $timestamps = false;

 public function coaGroup()
 {
   return $this->belongsTo(CoaGroup::class, 'group_id');
  }

  public function coaLvl1()
  {
   return $this->hasMany(CoaLvl2::class,'lvl1');
  }

$next 是我要设置的 PrimaryKey 值

标签： laravel

Answer 1

Schema::create('coa_lvl1', function (Blueprint $table) {
    $table->tinyInteger('group_id');
    $table->integer('lvl1')->primary(); //$table->integer('lvl1')->unsigned();
    $table->tinyInteger('lvl1_code');
    $table->string('lvl1_name',300);
    $table->integer('created_by')->nullable(false);
    $table->timestamp('created_date')->default(DB::raw('CURRENT_TIMESTAMP'));
    $table->integer('last_update_by');
    $table->timestamp('last_update_date')->default(DB::raw('0 ON UPDATE CURRENT_TIMESTAMP'));
    $table->string('active_flag',1)->default('1');
    $table->foreign('group_id')
        ->references('group_id')
        ->on('coa_group')
        ->onDelete('cascade');
});

我的模型是这样的

protected $table = 'coa_lvl1';

protected $primaryKey = 'lvl1';

public $incrementing = false;

protected $blameable  = array('created','updated');

protected $fillable = ['group_id','lvl1_code','lvl1_name','active_flag'];

public $timestamps = false;

public function coaGroup()
{
    return $this->belongsTo(CoaGroup::class, 'group_id');
}

public function coaLvl1()
{
    return $this->hasMany(CoaLvl2::class,'lvl1');
}