I am trying to solve this problem, where I try to edit multiple files with the update method in laravel 5.2.
When I run my process and save it returns the following error:
QueryException in Connection.php line 729:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'property_id' cannot be null (SQL: insert into `files` (`name`, `property_id`, `updated_at`, `created_at`) values (58bf2825d39d9.jpg, , 2017-03-07 17:37:41, 2017-03-07 17:37:41))
This is my Promperties Migration Table and your relationships
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreatePropertiesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('properties', function (Blueprint $table) {
$table->increments('id');
$table->integer('category_id')->unsigned();
$table->foreign('category_id')
->references('id')
->on('categories')
->onDelete('cascade');
$table->integer('term_id')->unsigned();
$table->foreign('term_id')
->references('id')
->on('terms')
->onDelete('cascade');
$table->string('address');
$table->integer('province_id')->unsigned();
$table->foreign('province_id')
->references('id')
->on('provinces')
->onDelete('cascade');
$table->string('ctime');//Tiempo de construcción de la propiedad (años).
$table->string('mconstruction');//Metros de construcción (Mt2).
$table->string('ground');//Metros de terreno (Mt2).
$table->string('level');//Nivel/Piso.
$table->string('elevator');//Asscensores.
$table->string('price');
$table->integer('currency_id')->unsigned();
$table->foreign('currency_id')
->references('id')
->on('currencies')
->onDelete('cascade');
$table->integer('client_id')->unsigned();
$table->foreign('client_id')
->references('id')
->on('clients')
->onDelete('cascade');
$table->softDeletes();
$table->timestamps();
});
DB::update("ALTER TABLE properties AUTO_INCREMENT = 1000;");
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('properties');
}
}
This is my File Migration Table and your relationships
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateFilesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('files', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->integer('property_id')->unsigned();
$table->foreign('property_id')
->references('id')
->on('properties')
->onDelete('cascade');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('files');
}
}
This is My Properties Model
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class Property extends Model
{
use SoftDeletes;
protected $dates = ['deleted_at'];
protected $table = 'properties';
protected $fillable = ['category_id', 'term_id', 'address', 'ctime', 'mconstruction', 'ground', 'level', 'elevator', 'price', 'currency_id', 'province_id', 'client_id'];
// Relation with Category
public function category()
{
return $this->belongsTo('App\Category');
}
// Relation with Term
public function term()
{
return $this->belongsTo('App\Term');
}
// Relation with Province
public function province()
{
return $this->belongsTo('App\Province');
}
// Relation with Client
public function client()
{
return $this->belongsTo('App\Client', 'client_id');
}
// Relation with Currency
public function currency()
{
return $this->belongsTo('App\Currency');
}
// Relation with Municipality
public function municipality()
{
return $this->belongsTo('App\Municipality');
}
// Relation with File
public function files()
{
return $this->hasMany('App\File');
}
public function scopeSearch($query, $search) {
return $query
->where('category_id', 'like', "%" . $search . "%")
->orWhere('address', 'like', "%" . $search . "%")
->orWhere('price', 'like', "%" . $search . "%");
}
}
This is My Files Model
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class File extends Model
{
protected $table = 'files';
protected $fillable = ['name', 'property_id'];
// Relation with Property
public function property()
{
return $this->belongsTo('App\Property');
}
}
And here I show part of my controller where the problem is
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Intervention\Image\Exception\NotReadableException;
use Illuminate\Support\Facades\Input;
use App\Http\Requests;
use App\Client;
use App\Category;
use App\Term;
use App\Province;
use App\Municipality;
use App\Property;
use App\Currency;
use App\User;
use App\File;
use Image;
use View;
class PropertyController extends Controller
{
public function update(Request $request, $id)
{
//dd($request->input());
$updated = Property::findorFail($id);
$properties = $request->all();
$property_id = $request->get('property_id');
$updated->fill($properties)->save();
// -- Images update method -- //
$images = $request->file('avatar');
foreach ($images as $image)
{
$rules = array(
'avatar' => 'required|mimes:png,gif,jpeg,jpg|max:20000'
);
$validator = \Validator::make(array('avatar'=> $image), $rules);
if (! $validator->passes())
{
return redirect()->back()->withErrors($validator);
}
$extension = $image->getClientOriginalExtension();
$filename = uniqid() . '.' . $extension;
$path = public_path() . 'uploads/products/';
//dd($extension);
Image::make($image)->resize(300, 200)->save( public_path('uploads/products/' . $filename ) );
//Move file into uploads folder
$image->move($path, $filename);
//Insert file name in db
//dd($image);
$image = File::create([
'name' => $filename,
'property_id' => $property_id
]);
}
// -- End method -- //
return redirect()->route('properties.index')
->with('success','Propiedad actualizada satisfactoriamente!!!');
}
What I try to do is replace the files and delete them so they do not accumulate in the directory that stores these images.
via Edward Palen