Styjun

Joining lists with same elements

How were medieval castles built in swamps or marshes without draining them?

How do I make my image comply with the requirements of this photography competition?

Given current technology, could TV display screens double as video camera sensors?

Should I stick with American terminology in my English set young adult book?

How much does Commander Data weigh?

Does EU 261/2004 compensation apply if delayed by the border check?

Can an Arcane Focus be embedded in one's body?

Anyone else seeing white rings in the Undead parish?

How to check whether a sublist exist in a huge database lists in a fast way?

Semantic difference between regular and irregular 'backen'

What is Spectral Subtraction for noise reduction?

Can RMSE and MAE have the same value?

How does encoder decoder network works?

Nothing like a good ol' game of ModTen

Movie where people enter a church but find they can't leave, not in English

How long do you think advanced cybernetic implants would plausibly last?

What's special ammo?

Why does Windows store Wi-Fi passwords in a reversible format?

Why does a sticker slowly peel off, but if it is pulled quickly it tears?

transparent text, such that floats and footnotes are affected correctly

Where does learning new skills fit into Agile?

Is it legal for source code containing undefined behavior to crash the compiler?

I don't have the theoretical background in my PhD topic. I can't justify getting the degree

Join using associatif table

PostgreSQL “DESCRIBE TABLE”Show tables in PostgreSQLModify OWNER on all tables simultaneously in PostgreSQLHow to import CSV file data into a PostgreSQL table?How can I drop all the tables in a PostgreSQL database?How to do an update + join in PostgreSQL?Laravel Migration foreign key errorlaravel eloquent JOIN ON multiple conditionHow to implement tree with self join table in Laravel 5.2Get results from pivot table based on the combination of two IDs in Laravel Project

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I set up a relationship between the following three tables : Card, Event and Presence (associatif table). Presence my associatif table, which contains id_card and id_event. I tried to create a fuction that return $count (number of event foreach member).
But my problem is $count return if the number of all event or zero and the result have been 1
My controller :

$count = DB::table('presences')
 ->join('cards','cards.id','presences.id_card')
 ->join('events','events.id','presences.id_event')
 ->where('presences.date','like','%event.dateEvent%')
 ->where('presences.qrcode','like','%cards.qrcode_membre%')
 ->get()
 ->count(); 

Model Card :

 public function event()
 
 return $this->belongsToMany('AppEvent');
 

Migration :

 $table->bigIncrements('id');
 $table->string('nom');
 $table->string('prenom');
 $table->string('cin');
 $table->date('dateNaissance');
 $table->date('dateAffection');
 $table->string('qrcode_membre')

Model Event :

 public function card()
 
 return $this->belongsToMany('AppCard');
 

Migration :

 $table->bigIncrements('id');
 $table->string('libelle');
 $table->string('description');
 $table->date('dateEvent');

Model Presence :

 $table->bigIncrements('id');
 $table->date('heureEntree');
 $table->date('heureSortir');
 $table->date('date');
 $table->string('qrcode');
 $table->unsignedInteger('id_card');
 $table->foreign('id_card')->references('id')->on('cards');
 $table->unsignedInteger('id_event');
 $table->foreign('id_event')->references('id')->on('events');

php laravel postgresql

share|improve this question

edited Mar 28 at 8:40

amal abidi

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Amal, do you have models for Presence, Card, Event?
  
  – Benjamin Beganović
  Mar 27 at 20:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @BenjaminBeganović i pasted the rest of code. i did not found the error !
  
  – amal abidi
  Mar 28 at 8:19
  

  
  
  
  

add a comment | 

0

I set up a relationship between the following three tables : Card, Event and Presence (associatif table). Presence my associatif table, which contains id_card and id_event. I tried to create a fuction that return $count (number of event foreach member).
But my problem is $count return if the number of all event or zero and the result have been 1
My controller :

$count = DB::table('presences')
 ->join('cards','cards.id','presences.id_card')
 ->join('events','events.id','presences.id_event')
 ->where('presences.date','like','%event.dateEvent%')
 ->where('presences.qrcode','like','%cards.qrcode_membre%')
 ->get()
 ->count(); 

Model Card :

 public function event()
 
 return $this->belongsToMany('AppEvent');
 

Migration :

 $table->bigIncrements('id');
 $table->string('nom');
 $table->string('prenom');
 $table->string('cin');
 $table->date('dateNaissance');
 $table->date('dateAffection');
 $table->string('qrcode_membre')

Model Event :

 public function card()
 
 return $this->belongsToMany('AppCard');
 

Migration :

 $table->bigIncrements('id');
 $table->string('libelle');
 $table->string('description');
 $table->date('dateEvent');

Model Presence :

 $table->bigIncrements('id');
 $table->date('heureEntree');
 $table->date('heureSortir');
 $table->date('date');
 $table->string('qrcode');
 $table->unsignedInteger('id_card');
 $table->foreign('id_card')->references('id')->on('cards');
 $table->unsignedInteger('id_event');
 $table->foreign('id_event')->references('id')->on('events');

php laravel postgresql

share|improve this question

edited Mar 28 at 8:40

amal abidi

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Amal, do you have models for Presence, Card, Event?
  
  – Benjamin Beganović
  Mar 27 at 20:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @BenjaminBeganović i pasted the rest of code. i did not found the error !
  
  – amal abidi
  Mar 28 at 8:19
  

  
  
  
  

add a comment | 

I set up a relationship between the following three tables : Card, Event and Presence (associatif table). Presence my associatif table, which contains id_card and id_event. I tried to create a fuction that return $count (number of event foreach member).
But my problem is $count return if the number of all event or zero and the result have been 1
My controller :

$count = DB::table('presences')
 ->join('cards','cards.id','presences.id_card')
 ->join('events','events.id','presences.id_event')
 ->where('presences.date','like','%event.dateEvent%')
 ->where('presences.qrcode','like','%cards.qrcode_membre%')
 ->get()
 ->count(); 

Model Card :

 public function event()
 
 return $this->belongsToMany('AppEvent');
 

Migration :

 $table->bigIncrements('id');
 $table->string('nom');
 $table->string('prenom');
 $table->string('cin');
 $table->date('dateNaissance');
 $table->date('dateAffection');
 $table->string('qrcode_membre')

Model Event :

 public function card()
 
 return $this->belongsToMany('AppCard');
 

Migration :

 $table->bigIncrements('id');
 $table->string('libelle');
 $table->string('description');
 $table->date('dateEvent');

Model Presence :

 $table->bigIncrements('id');
 $table->date('heureEntree');
 $table->date('heureSortir');
 $table->date('date');
 $table->string('qrcode');
 $table->unsignedInteger('id_card');
 $table->foreign('id_card')->references('id')->on('cards');
 $table->unsignedInteger('id_event');
 $table->foreign('id_event')->references('id')->on('events');

php laravel postgresql

share|improve this question

edited Mar 28 at 8:40

amal abidi

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges

$count = DB::table('presences')
 ->join('cards','cards.id','presences.id_card')
 ->join('events','events.id','presences.id_event')
 ->where('presences.date','like','%event.dateEvent%')
 ->where('presences.qrcode','like','%cards.qrcode_membre%')
 ->get()
 ->count(); 

 public function event()
 
 return $this->belongsToMany('AppEvent');
 

 $table->bigIncrements('id');
 $table->string('nom');
 $table->string('prenom');
 $table->string('cin');
 $table->date('dateNaissance');
 $table->date('dateAffection');
 $table->string('qrcode_membre')

 public function card()
 
 return $this->belongsToMany('AppCard');
 

 $table->bigIncrements('id');
 $table->string('libelle');
 $table->string('description');
 $table->date('dateEvent');

 $table->bigIncrements('id');
 $table->date('heureEntree');
 $table->date('heureSortir');
 $table->date('date');
 $table->string('qrcode');
 $table->unsignedInteger('id_card');
 $table->foreign('id_card')->references('id')->on('cards');
 $table->unsignedInteger('id_event');
 $table->foreign('id_event')->references('id')->on('events');

share|improve this question

edited Mar 28 at 8:40

amal abidi

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges

share|improve this question

edited Mar 28 at 8:40

amal abidi

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges

asked Mar 27 at 19:41

amal abidiamal abidi

122 bronze badges