{"id":1846,"date":"2019-12-05T10:00:10","date_gmt":"2019-12-05T01:00:10","guid":{"rendered":"http:\/\/taki-lab.site\/bocci\/?p=1846"},"modified":"2019-12-05T10:00:13","modified_gmt":"2019-12-05T01:00:13","slug":"%e3%80%90laravel%e3%80%91%e6%9c%88%e6%af%8e%e3%81%ab%e5%a3%b2%e4%b8%8a%e3%81%ae%e9%9b%86%e8%a8%88%e3%82%92%e8%a1%8c%e3%81%86","status":"publish","type":"post","link":"https:\/\/taki-lab.site\/bocci\/?p=1846","title":{"rendered":"\u3010Laravel\u3011\u6708\u6bce\u306b\u58f2\u4e0a\u306e\u96c6\u8a08\u3092\u884c\u3046"},"content":{"rendered":"\n<p>\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089<\/p>\n\n\n\n<figure class=\"wp-block-embed-wordpress wp-block-embed is-type-wp-embed is-provider-\u81ea\u5206\u3001\u307c\u3063\u3061\u3067\u3059\u304c\u4f55\u304b\uff1f\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"uLgZfh7mQe\"><a href=\"https:\/\/taki-lab.site\/bocci\/?p=1833\">\u3010Laravel\u3011\u6708\u3054\u3068\u306b\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u3055\u305b\u308b<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u3010Laravel\u3011\u6708\u3054\u3068\u306b\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u3055\u305b\u308b&#8221; &#8212; \u81ea\u5206\u3001\u307c\u3063\u3061\u3067\u3059\u304c\u4f55\u304b\uff1f\" src=\"https:\/\/taki-lab.site\/bocci\/?p=1833&#038;embed=true#?secret=16Nsoq4EQ2#?secret=uLgZfh7mQe\" data-secret=\"uLgZfh7mQe\" width=\"474\" height=\"267\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>\u6700\u65b0\u30bd\u30fc\u30b9\u306f\u3053\u3061\u3089<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/takishita2nd\/hotel-mng\">https:\/\/github.com\/takishita2nd\/hotel-mng<\/a><\/p>\n\n\n\n<p>\u6708\u6bce\u306b\u96c6\u8a08\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3053\u306e\u3068\u304d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u64cd\u4f5c\u304c\u5927\u5909\u3067\u30fb\u30fb\u30fb<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">    \/**\n     * \u6708\u6bce\u306b\u96c6\u8a08\u3059\u308b\n     *\/\n    public function countByMonthly()\n    {\n        return ReserveDayList::select(DB::raw('DATE_FORMAT(day, \"%Y-%m\") as yearmonth'), DB::raw('count(*) as count'), DB::raw('count(*) * 2000 as total'))\n                                ->groupby('yearmonth')\n                                ->get();\n    }<\/pre>\n\n\n\n<p>\u30ea\u30dd\u30b8\u30c8\u30ea\u306f\u3053\u308c\u3067\u306a\u3093\u3068\u304b\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>select\u6587\u3067day\u30ab\u30e9\u30e0\u3092YYYY-mm\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u51fa\u529b(\u3053\u306e\u30ab\u30e9\u30e0\u540d\u3092yearmonth\u3068\u3059\u308b)\u3002<\/p>\n\n\n\n<p>yearmonth\u3054\u3068\u306bgroupBy\u3067\u30b0\u30eb\u30fc\u30d7\u5206\u3051\u3057\u3001count(*)\u3067\u96c6\u8a08\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3082\u3063\u3068\u3046\u307e\u3044\u65b9\u6cd5\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u8ff7\u3063\u305f\u3089DB::raw()\u3092\u4f7f\u3063\u305f\u307b\u3046\u304c\u3044\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n\n\n\n<p>\u3067\u3082\u3001\u3053\u308c\u304c\u3067\u304d\u308c\u3070\u5b8c\u6210\u3057\u305f\u3082\u540c\u7136\u3002<\/p>\n\n\n\n<p>\u7c21\u5358\u3059\u304e\u308b\u306e\u3067\u3001\u30b3\u30fc\u30c9\u306f\u7701\u7565\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"125\" data-attachment-id=\"1847\" data-permalink=\"https:\/\/taki-lab.site\/bocci\/?attachment_id=1847\" data-orig-file=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-09-58-42.png?fit=782%2C206&amp;ssl=1\" data-orig-size=\"782,206\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot-from-2019-12-05-09-58-42\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-09-58-42.png?fit=474%2C125&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-09-58-42.png?resize=474%2C125\" alt=\"\" class=\"wp-image-1847\" srcset=\"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-09-58-42.png?w=782&amp;ssl=1 782w, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-09-58-42.png?resize=300%2C79&amp;ssl=1 300w, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-09-58-42.png?resize=768%2C202&amp;ssl=1 768w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n\n\n\n<p>\u3042\u3068\u306f\u6700\u5f8c\u306e\u5fae\u8abf\u6574\u3067\u5b8c\u6210\u3067\u3059\u306d\u3002<\/p>\n\n\n\n<a href=\"\/\/blog.with2.net\/link\/?2023426:1010\" target=\"_blank\" rel=\"noopener noreferrer\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/blog.with2.net\/img\/banner\/c\/banner_1\/br_c_1010_1.gif?w=474&#038;ssl=1\" title=\"\u30d1\u30bd\u30b3\u30f3\u30e9\u30f3\u30ad\u30f3\u30b0\"><\/a>\n\n\n\n<p>\u30d0\u30ca\u30fc\u30af\u30ea\u30c3\u30af\u3067\u5fdc\u63f4\u3088\u308d\u3057\u304f\u304a\u9858\u3044\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089 \u6700\u65b0\u30bd\u30fc\u30b9\u306f\u3053\u3061\u3089 https:\/\/github.com\/takishita2nd\/hotel-mng \u6708\u6bce\u306b\u96c6\u8a08\u3092\u884c\u3044\u307e\u3059\u3002 \u3053\u306e\u3068\u304d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u64cd\u4f5c\u304c\u5927\u5909\u3067\u30fb\u30fb\u30fb \/** * \u6708\u6bce\u306b\u96c6\u8a08\u3059 &hellip; <a href=\"https:\/\/taki-lab.site\/bocci\/?p=1846\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u3010Laravel\u3011\u6708\u6bce\u306b\u58f2\u4e0a\u306e\u96c6\u8a08\u3092\u884c\u3046<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"\u3010Laravel\u3011\u6708\u6bce\u306b\u58f2\u4e0a\u306e\u96c6\u8a08\u3092\u884c\u3046\n#TechCommit\n","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[8,3],"tags":[138,79],"class_list":["post-1846","post","type-post","status-publish","format-standard","hentry","category-linux","category-3","tag-laravel","tag-linux"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8SDbY-tM","jetpack-related-posts":[{"id":1952,"url":"https:\/\/taki-lab.site\/bocci\/?p=1952","url_meta":{"origin":1846,"position":0},"title":"\u3010Laravel\u3011\u3010\u30db\u30c6\u30eb\u4e88\u7d04\u7ba1\u7406\u3011\u90e8\u5c4b\u3054\u3068\u306b\u96c6\u8a08\u3059\u308b","author":"taki","date":"2019\u5e7412\u670817\u65e5","format":false,"excerpt":"\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089\u3002 https:\/\/taki-lab.site\/bocci\/?p=1922 \u6700\u2026","rel":"","context":"\u6280\u8853","block_context":{"text":"\u6280\u8853","link":"https:\/\/taki-lab.site\/bocci\/?cat=3"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-17-13-58-03.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1849,"url":"https:\/\/taki-lab.site\/bocci\/?p=1849","url_meta":{"origin":1846,"position":1},"title":"\u3010Laravel\u3011\u30db\u30c6\u30eb\u4e88\u7d04\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u5b8c\u6210","author":"taki","date":"2019\u5e7412\u67085\u65e5","format":false,"excerpt":"\u3082\u3046\u5c11\u3057\u3067\u5b8c\u6210\u3060\u304b\u3089\u3001\u3082\u3046\u3061\u3087\u3063\u3068\u3084\u3063\u3066\u7d42\u308f\u308d\u3046\u3068\u601d\u3063\u305f\u3089\u3001\u30ac\u30c3\u30c4\u30ea\u66f8\u304d\u63db\u3048\u308b\u3053\u3068\u306b\u306a\u308b\u3068\u3044\u3046\u30d7\u30ed\u30b0\u2026","rel":"","context":"Linux","block_context":{"text":"Linux","link":"https:\/\/taki-lab.site\/bocci\/?cat=8"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-13-34-57.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-13-34-57.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-13-34-57.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-05-13-34-57.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3352,"url":"https:\/\/taki-lab.site\/bocci\/?p=3352","url_meta":{"origin":1846,"position":2},"title":"\u3010LARAVEL\u3011\u3010\u30c0\u30a4\u30a8\u30c3\u30c8\u652f\u63f4\u3011\u30b0\u30e9\u30d5\u306e\u30c7\u30fc\u30bf\u9593\u9694\u3092\u6307\u5b9a\u3059\u308b","author":"taki","date":"2020\u5e746\u670823\u65e5","format":false,"excerpt":"\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089\u3002 http:\/\/taki-lab.site\/bocci\/?p=3296 \u6700\u65b0\u2026","rel":"","context":"Laravel","block_context":{"text":"Laravel","link":"https:\/\/taki-lab.site\/bocci\/?cat=167"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/06\/Screenshot-from-2020-06-23-08-33-15.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/06\/Screenshot-from-2020-06-23-08-33-15.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/06\/Screenshot-from-2020-06-23-08-33-15.png?resize=525%2C300 1.5x"},"classes":[]},{"id":3741,"url":"https:\/\/taki-lab.site\/bocci\/?p=3741","url_meta":{"origin":1846,"position":3},"title":"\u3010\u30c0\u30a4\u30a8\u30c3\u30c8\u652f\u63f4\u3011\u3010\u98df\u4e8b\u7ba1\u7406\u3011\u30c7\u30fc\u30bf\u4e00\u89a7\u51e6\u7406\u3092\u4f5c\u6210\u3059\u308b\u3002","author":"taki","date":"2020\u5e747\u670830\u65e5","format":false,"excerpt":"\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089\u3002 https:\/\/taki-lab.site\/bocci\/?p=3705 \u6700\u2026","rel":"","context":"Laravel","block_context":{"text":"Laravel","link":"https:\/\/taki-lab.site\/bocci\/?cat=167"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/20200705_010451000_iOS-2.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/20200705_010451000_iOS-2.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/20200705_010451000_iOS-2.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/20200705_010451000_iOS-2.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/20200705_010451000_iOS-2.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/20200705_010451000_iOS-2.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":1833,"url":"https:\/\/taki-lab.site\/bocci\/?p=1833","url_meta":{"origin":1846,"position":4},"title":"\u3010Laravel\u3011\u6708\u3054\u3068\u306b\u30c7\u30fc\u30bf\u3092\u30d5\u30a3\u30eb\u30bf\u3055\u305b\u308b","author":"taki","date":"2019\u5e7412\u67084\u65e5","format":false,"excerpt":"\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089\u3002 https:\/\/taki-lab.site\/bocci\/?p=1811 \u6700\u2026","rel":"","context":"Linux","block_context":{"text":"Linux","link":"https:\/\/taki-lab.site\/bocci\/?cat=8"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-04-12-49-43.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-04-12-49-43.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-04-12-49-43.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2019\/12\/Screenshot-from-2019-12-04-12-49-43.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3968,"url":"https:\/\/taki-lab.site\/bocci\/?p=3968","url_meta":{"origin":1846,"position":5},"title":"\u3010\u30c0\u30a4\u30a8\u30c3\u30c8\u652f\u63f4\u3011\u3010\u98df\u4e8b\u7ba1\u7406\u3011\u30b0\u30e9\u30d5\u30c7\u30fc\u30bf\u53d6\u5f97\u51e6\u7406\u3092\u4f5c\u6210\u3059\u308b\u3002","author":"taki","date":"2020\u5e748\u670826\u65e5","format":false,"excerpt":"\u524d\u56de\u307e\u3067\u306e\u72b6\u6cc1\u306f\u3053\u3061\u3089 https:\/\/taki-lab.site\/bocci\/?p=3903 \u6700\u65b0\u2026","rel":"","context":"Laravel","block_context":{"text":"Laravel","link":"https:\/\/taki-lab.site\/bocci\/?cat=167"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/06896ae217236d1ede12faaa3a1c95b3.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/06896ae217236d1ede12faaa3a1c95b3.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/06896ae217236d1ede12faaa3a1c95b3.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/taki-lab.site\/bocci\/wp-content\/uploads\/2020\/07\/06896ae217236d1ede12faaa3a1c95b3.png?resize=700%2C400&ssl=1 2x"},"classes":[]}],"jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts\/1846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1846"}],"version-history":[{"count":1,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts\/1846\/revisions"}],"predecessor-version":[{"id":1848,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=\/wp\/v2\/posts\/1846\/revisions\/1848"}],"wp:attachment":[{"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taki-lab.site\/bocci\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}