{"id":1780,"date":"2011-01-26T17:56:33","date_gmt":"2011-01-26T08:56:33","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/archives\/1780"},"modified":"2011-01-26T18:08:45","modified_gmt":"2011-01-26T09:08:45","slug":"cakephp%e3%81%a72%e3%81%a4%e3%81%ae%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%92%e9%80%a3%e7%b5%90%e3%81%95%e3%81%9b%e3%82%8b","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/1780","title":{"rendered":"CakePHP\u30672\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u9023\u7d50\u3055\u305b\u308b"},"content":{"rendered":"

\n\u3055\u3066\u3001\u6975\u60aa\u30c6\u30fc\u30d6\u30eb\u547d\u540d\u898f\u5247 T100,T200,T300 \u3092 magazines, publishers, users \u306b\u5909\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u305f\u306e\u3067\u3001\u4eca\u5ea6\u306f\u30c6\u30fc\u30d6\u30eb\u306e\u9023\u7d50\u3092\u3057\u3066\u307f\u307e\u3059\u3002\n<\/p>\n

\n<!-- views\/magazines\/index.ctp -->\n<h2>\u96d1\u8a8c\u4e00\u89a7<\/h2>\n<table>\n\t<tr>\n\t\t<td>id<\/td>\n\t\t<td>name<\/td>\n\t\t<td>publisher_id<\/td>\n\t\t<td>publisher_id<\/td>\n\t<\/tr>\n<?php foreach($Magazines as $item) : ?>\n\t<tr>\n\t\t<td><?php echo $item['Magazine']['id'] ?><\/td>\n\t\t<td><?php echo $item['Magazine']['name'] ?><\/td>\n\t\t<td><?php echo $item['Magazine']['T200id'] ?><\/td>\n\t\t<td><?php echo $item['Magazine']['publisher_id'] ?><\/td>\n\t<\/tr>\n<?php endforeach ; ?>\n<\/table>\n<\/pre>\n
\n\u306e\u3088\u3046\u306b\u3001publisher_id \u3092\u8868\u793a\u3055\u305b\u305f\u3063\u3066\u610f\u5473\u304c\u306a\u3044\u308f\u3051\u3067\u3001\u51fa\u7248\u793e\u540d(Publisher.name)\u3092\u8868\u793a\u3055\u305b\u305f\u3044\u8a33\u3067\u3059\u3002\n<\/p>\n
\n<!-- views\/magazines\/index.ctp -->\n<h2>\u96d1\u8a8c\u4e00\u89a7<\/h2>\n<table>\n\t<tr>\n\t\t<td>id<\/td>\n\t\t<td>name<\/td>\n\t\t<td>publisher_id<\/td>\n\t\t<td>publisher_id<\/td>\n\t<\/tr>\n<?php foreach($Magazines as $item) : ?>\n\t<tr>\n\t\t<td><?php echo $item['Magazine']['id'] ?><\/td>\n\t\t<td><?php echo $item['Magazine']['name'] ?><\/td>\n\t\t<td><?php echo $item['Magazine']['T200id'] ?><\/td>\n\t\t<td><?php echo $item['Magazine']['publisher_id'] ?><\/td>\n\t\t<td><?php echo $item['Publisher']['name'] ?><\/td> \u2605\n\t<\/tr>\n<?php endforeach ; ?>\n<\/table>\n<\/pre>\n
\n\u307f\u305f\u3044\u306b\u4f7f\u3048\u308c\u3070\u3044\u3044\u3067\u3059\u3088\u306d\u3002\u4f7f\u3048\u308b\u306e\u304b\u306a\uff1f\n<\/p>\n
\n\u3068\u3044\u3046\u8a33\u3067\u3001\u3072\u3068\u3064\u306e\u96d1\u8a8c(magazine)\u306f\u3001\u51fa\u7248\u793e(publisher)\u306b\u5c5e\u3059\u308b\u3068\u3044\u3046\u3053\u3068\u3067\u3001Magazine \u30e2\u30c7\u30eb\u3092\u66f8\u304d\u63db\u3048\u307e\u3059\u3002\n<\/p>\n
\n<!-- models\/magazine.php -->\n<?php\nclass Magazine extends AppModel\n{\n\tvar $name = 'Magazine';\n\tvar $useTable = 'T100';\n\tvar $virtualFields = array(\n\t\t'publisher_id'=>'T200id' );\n\n\tvar $belongsTo = array('Publisher' =>\n\t\tarray(\n\t\t\t'className' => 'Publisher',\n\t\t\t'conditions' => '',\n\t\t\t'order' => 'Magazine.id ASC',\n\t\t\t'foreignKey' => 'T200id' ));\n}\n?>\n<\/pre>\n
\n\u3053\u306e\u5916\u90e8\u30ad\u30fc\u306e\u66f8\u304d\u65b9\u306f\u3044\u304f\u3064\u304b\u3042\u308b\u306e\u3067\u3059\u304c\u3001$belongsTo \u3068 $hasMeny \u306f\u53cc\u65b9\u5411\u306a\u306e\u3067\u3069\u3061\u3089\u304b\u6c7a\u3081\u3067\u4f7f\u3048\u3070\u3044\u3044\u3093\u3067\u3057\u3087\u3046\u3002\n<\/p>\n
\n\u3053\u3046\u3059\u308b\u3068\u3001\u5148\u306e index.ctp \u304c\u52d5\u304d\u307e\u3059\u3002\u751f\u6210\u3055\u308c\u308b SQL \u3092\u898b\u308b\u3068\u3001\n<\/p>\n
\nSELECT \n `Magazine`.`id`, \n `Magazine`.`name`, \n `Magazine`.`T200id`, \n `Magazine`.`price`, \n (T200id) AS `Magazine__publisher_id`, \n `Publisher`.`id`, \n `Publisher`.`name` \nFROM `T100` AS `Magazine` \n LEFT JOIN `T200` AS `Publisher` ON (`Magazine`.`T200id` = `Publisher`.`id`) \nWHERE 1 = 1 \n ORDER BY `Magazine`.`id` ASC \n<\/pre>\n
\n\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001left join \u304c\u4f7f\u308f\u308c\u3066\u3044\u307e\u3059\u306d\u3002\u306a\u308b\u307b\u3069\u3002\n<\/p>\n
\n\u6b8b\u5ff5\u306a\u304c\u3089 $virtualFields \u3067\u5225\u540d\u5b9a\u7fa9\u3092\u3057\u305f\u30ab\u30e9\u30e0\u540d\u306f\u3001$belongsTo \u3067\u306f\u4f7f\u3048\u306a\u3044\u3088\u3046\u3067\u3001\u3042\u306e\u4e0d\u601d\u8b70\u306a T200id \u3068\u3044\u3046\u30ab\u30e9\u30e0\u540d\u304c\u51fa\u3066\u304d\u307e\u3059\u304c\u3001\u307e\u3041\u3001\u826f\u3057\u3068\u3057\u307e\u3057\u3087\u3046\u3002\u9069\u5f53\u306a\u30d8\u30eb\u30d1\u30fc\u95a2\u6570\u306a\u308a\u3092\u4f5c\u308c\u3070\u3001\u3053\u306e\u3042\u305f\u308a\u306e\u8a2d\u5b9a\u3082\u697d\u306b\u306a\u308b\u3068\u601d\u3044\u307e\u3059\u3002$virtualFields \u304c\u9023\u60f3\u914d\u5217\u306a\u306e\u3067\u3001\u9006\u5f15\u304d\u3057\u3066 value \u304b\u3089 key \u3092\u53d6\u308a\u51fa\u305b\u3070\u3088\u3044\u306e\u3067\u3002\n<\/p>\n
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u3055\u3066\u3001\u6975\u60aa\u30c6\u30fc\u30d6\u30eb\u547d\u540d\u898f\u5247 T100,T200,T300 \u3092 magazines, publishers, users \u306b\u5909\u3048\u308b\u3053\u3068\u304c\u3067\u304d\u305f\u306e\u3067\u3001\u4eca\u5ea6\u306f\u30c6\u30fc\u30d6\u30eb\u306e\u9023\u7d50\u3092\u3057\u3066\u307f\u307e\u3059\u3002 <!– views\/magaz … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5,20],"tags":[],"class_list":["post-1780","post","type-post","status-publish","format-standard","hentry","category-etc","category-cakephp"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/comments?post=1780"}],"version-history":[{"count":1,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1780\/revisions"}],"predecessor-version":[{"id":1781,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/posts\/1780\/revisions\/1781"}],"wp:attachment":[{"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/media?parent=1780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/categories?post=1780"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.moonmile.net\/blog\/wp-json\/wp\/v2\/tags?post=1780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}