Automatically not insert created_at and updated_at in laravel not working.
DB::table('commundityvendordata')->insert($commdata);
I am using this above statement passing an array for inserting multiple record $commdataworking fine but when check my created_at and updated_at column in database not getting timestamp.
Model:
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class commundityvendordata extends Model
{
use HasFactory;
protected $table ='commundityvendordata';
}
Migration:
public function up()
{
Schema::create('commundityvendordata', function (Blueprint $table) {
$table->bigIncrements('vender_id')->unsignedBigInteger();
$table->date('new_date');
$table->unsignedBigInteger('cd_id');
$table->foreign('cd_id')->references('cd_id')->on('communitydata')->onDelete('cascade');
$table->unsignedBigInteger('cn_id');
$table->foreign('cn_id')->references('cd_id')->on('communitydata')->onDelete('cascade');
$table->unsignedBigInteger('unit_id');
$table->foreign('unit_id')->references('unit_id')->on('units')->onDelete('cascade');
$table->unsignedInteger('vender1');
$table->unsignedInteger('vender2');
$table->unsignedInteger('vender3');
$table->unsignedInteger('vender4');
$table->timestamps();
});
}
Controller:
function commundityvendordata(Request $request){
$collection = count(collect($request));
$cvendordata = new commundityvendordata;
for ($i=0; $i < $collection; $i++) {
$new_date = Carbon::parse($request->new_date)->format('Y-m-d');
$CCode=communitydata::where('c_code','=',$request->ccode[$i])->first();
$cd_id = $CCode['cd_id'];
$CName=communitydata::where('c_name','=',$request->cname[$i])->first();
$cn_id = $CName['cd_id'];
$CUnit=units::where('unit','=',$request->cunit[$i])->first();
$unit_id = $CUnit['unit_id'];
$vender1 = $request->vendor1[$i];
$vender2 = $request->vendor2[$i];
$vender3 = $request->vendor3[$i];
$vender4 = $request->vendor4[$i];
$commdata = [
'new_date' => $new_date,
'cd_id' => $cd_id,
'cn_id' => $cn_id,
'unit_id' => $unit_id,
'vender1' => $vender1,
'vender2' => $vender2,
'vender3' => $vender3,
'vender4' => $vender4
];
if($cd_id != ''){
DB::table('commundityvendordata')->insert($commdata);
}else{
return back()->with('success','Data Saved...');
}
}
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire