Skip to content

Instantly share code, notes, and snippets.

@MicroHank

MicroHank/client_software_map

Last active July 21, 2016 05:45
Show Gist options
  • Save MicroHank/bbc1b253a147ce2198e9a186231de41a to your computer and use it in GitHub Desktop.
Save MicroHank/bbc1b253a147ce2198e9a186231de41a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
client_software_map
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Clientsoftwaremap extends Model
{
/**
* 與模型關聯的資料表
*
* @var String
*/
protected $table = "client_software_map" ;
/**
* 設定模型主鍵為 cs_id
*
* @var String
*/
protected $primaryKey = "cs_id" ;
public $timestamps = false ;
public function process() {
return $this->hasMany("App\Process", "process_id", "map_id") ;
}
}
Raw
process
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Process extends Model
{
/**
* 與模型關聯的資料表
*
* @var String
*/
protected $table = "process" ;
/**
* 設定模型主鍵為 process_id
*
* @var String
*/
protected $primaryKey = "process_id" ;
public $timestamps = false ;
}
Raw
資料
Table: client_software_map
cs_id | map_id | type
100 | 1 | 1
100 | 2 | 1
100 | 3 | 1
100 | 4 | 1
100 | 5 | 1
Table: process
process_id | name
1 | A
2 | B
3 | C
4 | D
5 | E
Controller:
Clientsoftwaremap::find(100)->process ; // Only Get 100 -> 1 | A
How to Get all process 1~5 ?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment