0417 一覧表示とjsで詳細表示

- 部署情報(affilation)を正しく結合して、ひとつのテーブル要素として表示
　　★implode　配列要素を文字列として結合
　　★存在するなら~　3項演算子
- 選択したカラムのみを取得
　　　http://fuelphp.jp/docs/1.6/packages/orm/crud.html#partial_selects
-RESTConからajaxで取得したデータを変換
　　★JSONにはObj型と配列型がある
　　　phpやjsで用いるには、各々の変数としてデコードする必要がある
jsではJSON.parse(JSON変数);
　　　http://www.task-notes.com/entry/20160719/1468858991
　　　https://teratail.com/questions/19313

----------------------------------------------------------------------------------------------------------------------

Fuel\Core\Database_Exception [ 1054 ]:
SQLSTATE[42S22]: Column not found: 1054
Unknown column 't2.sorting ' in 'field list' with query:
"SELECT `t0`.`id` AS `t0_c0`,
`t0`.`family_name` AS `t0_c1`,
`t0`.`given_name` AS `t0_c2`,
`t0`.`phonetic_of_family_name` AS `t0_c3`,
`t0`.`phonetic_of_given_name` AS `t0_c4`,
`t0`.`affiliation_id` AS `t0_c5`,
`t0`.`position_id` AS `t0_c6`,
`t0`.`picture_url` AS `t0_c7`,
`t0`.`comments` AS `t0_c8`,
`t0`.`has_been_deleted` AS `t0_c9`,
`t0`.`number_of_editing` AS `t0_c10`,

`t1`.`department_name` AS `t1_c0`,
`t1`.`section_name` AS `t1_c1`,
`t1`.`subsection_name` AS `t1_c2`,
`t1`.`sorting` AS `t1_c3`,
`t1`.`id` AS `t1_c4`,

`t2`.`assigned_name` AS `t2_c0`,
`t2`.`sorting ` AS `t2_c1`,
`t2`.`id` AS `t2_c2`


FROM `employee` AS `t0`
LEFT JOIN `affiliation` AS `t1` ON (`t0`.`affiliation_id` = `t1`.`id`)
LEFT JOIN `position` AS `t2` ON (`t0`.`position_id` = `t2`.`id`)"

//ORMの本質はLEFTJOINじゃん