{"id":3131,"date":"2019-02-02T23:12:29","date_gmt":"2019-02-02T14:12:29","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=3131"},"modified":"2024-02-20T17:26:22","modified_gmt":"2024-02-20T08:26:22","slug":"post-3131","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/3131","title":{"rendered":"Advanced Custom Fields\u3067\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc\u3092\u52d5\u7684\u306b\u751f\u6210\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p>WordPress\u3067\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9\u8a2d\u5b9a\u7528\u306e\u30d7\u30e9\u30b0\u30a4\u30f3Advanced Custom Fields\u3092\u4f7f\u7528\u4e2d\u306e\u74b0\u5883\u3067\u3001\u8a18\u4e8b\u6295\u7a3f\u30da\u30fc\u30b8\u304b\u3089\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc\u3092\u9078\u629e\u3059\u308b\u3068\u3001\u9078\u629e\u3057\u305f\u3082\u306e\u3068\u9023\u52d5\u3057\u305f\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc\u304c\u6b21\u306b\u8868\u793a\u3055\u308c\u308b\u3068\u3044\u3046\u30b7\u30b9\u30c6\u30e0\u304c\u6b32\u3057\u304b\u3063\u305f\u3002\u4ee5\u4e0b\u306b\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>\u3084\u308a\u305f\u3044\u3053\u3068<\/h2>\n<p>\u516b\u5730\u65b9\u533a\u5206(\u95a2\u6771\u3001\u8fd1\u757f\u7b49)\u3092\u30d7\u30eb\u30c0\u30a6\u30f3\u304b\u3089\u9078\u3076\u3068\u533a\u5206\u5185\u306e\u90fd\u9053\u5e9c\u770c\u30d7\u30eb\u30c0\u30a6\u30f3\u304c\u8868\u793a\u3055\u308c\u3001\u3055\u3089\u306b\u90fd\u9053\u5e9c\u770c\u3092\u9078\u3076\u3068\u8def\u7dda\u304c\u3001\u8def\u7dda\u3092\u9078\u3076\u3068\u99c5\u540d\u304c\u9078\u629e\u3067\u304d\u308b\u3068\u3044\u3063\u305f\u4e00\u9023\u306e\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc\u3092WordPress\u306e\u8a18\u4e8b\u4e00\u89a7\u30da\u30fc\u30b8\u306b\u4f5c\u6210\u3057\u305f\u304b\u3063\u305f\u3002<\/p>\n<p>\u90fd\u9053\u5e9c\u770c\u7b49\u306e\u30c7\u30fc\u30bf\u7528\u610f\u3084\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc\u81ea\u4f53\u306e\u4f5c\u6210\u65b9\u6cd5\u306f\u4ee5\u4e0b\u8a18\u4e8b\u3092\u53c2\u7167\u3002<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"yX9EtpYqFv\"><p><a href=\"https:\/\/taitan916.info\/blog\/archives\/3129\">\u516b\u5730\u65b9\u533a\u5206\u2192\u90fd\u9053\u5e9c\u770c\u2192\u8def\u7dda\u2192\u99c5\u540d\u306e\u9023\u643a\u3057\u305f\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc \u306e\u5b9f\u88c5\u65b9\u6cd5<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u516b\u5730\u65b9\u533a\u5206\u2192\u90fd\u9053\u5e9c\u770c\u2192\u8def\u7dda\u2192\u99c5\u540d\u306e\u9023\u643a\u3057\u305f\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc \u306e\u5b9f\u88c5\u65b9\u6cd5&#8221; &#8212; \u52c9\u5f37\u3057\u305f\u3053\u3068\u306e\u30e1\u30e2\" src=\"https:\/\/taitan916.info\/blog\/archives\/3129\/embed#?secret=YjdNhwLrpy#?secret=yX9EtpYqFv\" data-secret=\"yX9EtpYqFv\" width=\"580\" height=\"327\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h2>ACF\u5074\u306e\u8a2d\u5b9a<\/h2>\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u5f62\u3067\u8a2d\u5b9a\u3057\u3066\u304a\u304f\u3002<\/p>\n<table>\n<tbody>\n<tr>\n<td>\u30d5\u30a3\u30fc\u30eb\u30c9\u30e9\u30d9\u30eb<\/td>\n<td>\u30d5\u30a3\u30fc\u30eb\u30c9\u540d<\/td>\n<td>\u30d5\u30a3\u30fc\u30eb\u30c9\u30bf\u30a4\u30d7<\/td>\n<td>\u9078\u629e\u80a2<\/td>\n<\/tr>\n<tr>\n<td>\u516b\u5730\u65b9\u533a\u5206<\/td>\n<td>region<\/td>\n<td>\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc<\/td>\n<td>1 : \u5317\u6d77\u9053<br \/>\n2 : \u6771\u5317\u5730\u65b9<br \/>\n3 : \u95a2\u6771\u5730\u65b9<br \/>\n4 : \u4e2d\u90e8\u5730\u65b9<br \/>\n5 : \u8fd1\u757f\u5730\u65b9<br \/>\n6 : \u4e2d\u56fd\u5730\u65b9<br \/>\n7 : \u56db\u56fd\u5730\u65b9<br \/>\n8 : \u4e5d\u5dde\u5730\u65b9<\/td>\n<\/tr>\n<tr>\n<td>\u90fd\u9053\u5e9c\u770c<\/td>\n<td>prefecture<\/td>\n<td>\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc<\/td>\n<td>\u7a7a\u3067OK<\/td>\n<\/tr>\n<tr>\n<td>\u8def\u7dda\u7a2e\u5225<\/td>\n<td>line<\/td>\n<td>\u30e9\u30b8\u30aa\u30dc\u30bf\u30f3<\/td>\n<td>0 : \u5730\u4e0b\u9244<br \/>\n1 : \u79c1\u9244<br \/>\n2 : JR<\/td>\n<\/tr>\n<tr>\n<td>\u5730\u4e0b\u9244<\/td>\n<td>subway<\/td>\n<td>\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc<\/td>\n<td>\u7a7a\u3067OK<\/td>\n<\/tr>\n<tr>\n<td>\u79c1\u9244<\/td>\n<td>private<\/td>\n<td>\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc<\/td>\n<td>\u7a7a\u3067OK<\/td>\n<\/tr>\n<tr>\n<td>JR<\/td>\n<td>jr<\/td>\n<td>\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc<\/td>\n<td>\u7a7a\u3067OK<\/td>\n<\/tr>\n<tr>\n<td>\u99c5<\/td>\n<td>station<\/td>\n<td>\u30bb\u30ec\u30af\u30c8\u30e1\u30cb\u30e5\u30fc<\/td>\n<td>\u7a7a\u3067OK<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2>functions.php\u306b\u8ffd\u8a18<\/h2>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#js\u547c\u3073\u51fa\u3057\r\nfunction search_station_js($hook) {\r\n    if($hook == 'post.php' || $hook == 'post-new.php'){\r\n        #JS\u30d5\u30a1\u30a4\u30eb\u8a2d\u7f6e\u5834\u6240\r\n        wp_enqueue_script('custom_admin_script', '\/hogehoge\/js\/search_station.js', array('jquery'));\r\n    }\r\n}\r\nadd_action('admin_enqueue_scripts', 'search_station_js');\r\n\r\n#ajax\u53d7\u4fe1\u7528\r\nfunction search_station(){\r\n\r\n    #DB\u63a5\u7d9a\r\n    global $wpdb;\r\n    $mysqli = new mysqli($wpdb-&gt;dbhost, $wpdb-&gt;dbuser, $wpdb-&gt;dbpassword, $wpdb-&gt;dbname);\r\n    $mysqli-&gt;set_charset('utf8');\r\n\r\n    $mode = $_POST['mode'];\r\n\r\n    $result = false;\r\n\r\n    #\u30a8\u30ea\u30a2\u9078\u629e\r\n    if( $mode == 'region' &amp;&amp; $_POST['id'] ){\r\n        $sql = '\r\n            SELECT * \r\n            FROM cps_prefecture \r\n            WHERE region_id = \"' . $mysqli-&gt;real_escape_string($_POST['id']) . '\"\r\n        ';\r\n        $row = $mysqli-&gt;query($sql);\r\n        while ($rs = $row-&gt;fetch_array(MYSQLI_ASSOC)) {\r\n            $result[] = $rs;\r\n        }\r\n\r\n    #\u90fd\u9053\u5e9c\u770c\u9078\u629e\r\n    }else if( $mode == 'prefecture' &amp;&amp; $_POST['id'] ){\r\n        $sql = '\r\n            SELECT \r\n                c.company_cd, c.company_name, c.company_name_r, c.company_type, c.subway, \r\n                l.line_name, l.line_cd, \r\n                s.pref_cd \r\n            FROM cps_company AS c \r\n            LEFT JOIN cps_line AS l \r\n            ON c.company_cd = l.company_cd\r\n            LEFT JOIN cps_station AS s \r\n            ON l.line_cd = s.line_cd \r\n            WHERE s.e_status = 0 \r\n            AND l.e_status = 0 \r\n            AND s.e_status = 0 \r\n            AND s.pref_cd = \"' . $mysqli-&gt;real_escape_string($_POST['id']) . '\" \r\n            GROUP BY l.line_cd\r\n        ';\r\n        $row = $mysqli-&gt;query($sql);\r\n        while ($rs = $row-&gt;fetch_array(MYSQLI_ASSOC)) {\r\n            $result[] = $rs;\r\n        }\r\n\r\n    #\u8def\u7dda\u9078\u629e\r\n    }else if( $mode == 'station' &amp;&amp; $_POST['id'] ){\r\n        $sql = '\r\n            SELECT * \r\n            FROM cps_station \r\n            WHERE line_cd = \"' . $mysqli-&gt;real_escape_string($_POST['id']) . '\" \r\n            AND e_status = 0 \r\n        ';\r\n        $row = $mysqli-&gt;query($sql);\r\n        while ($rs = $row-&gt;fetch_array(MYSQLI_ASSOC)) {\r\n            $result[] = $rs;\r\n        }\r\n    }\r\n\r\n    #\u7d50\u679c\u304c\u3042\u308b\u5834\u5408\u306f\u8fd4\u3059\r\n    if( $result ){\r\n        echo json_encode($result);\r\n    }\r\n\r\n    die();\r\n}\r\nadd_action( 'wp_ajax_select_station', 'search_station' );<\/pre>\n<p>wp-config.php\u3067\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308bMySQL\u306e\u30ed\u30b0\u30a4\u30f3\u60c5\u5831\u304c\u5b9a\u6570\u3060\u3063\u305f\u306e\u3067\u305d\u306e\u307e\u307e\u300cDB_PASSWORD\u300d\u3068\u304b\u3067\u53d6\u5f97\u3057\u3088\u3046\u3068\u3057\u305f\u3089\u30a8\u30e9\u30fc\u304c\u8d77\u304d\u305f\u3002\u4ee5\u4e0b\u3067\u53d6\u5f97\u3067\u304d\u308b\u3068\u3044\u3046\u306e\u3092\u521d\u3081\u3066\u77e5\u3063\u305f\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">global $wpdb;\r\n$mysqli = new mysqli($wpdb-&gt;dbhost, $wpdb-&gt;dbuser, $wpdb-&gt;dbpassword, $wpdb-&gt;dbname);<\/pre>\n<p>&nbsp;<\/p>\n<h2>JavaScript<\/h2>\n<p>\u4eca\u56de\u3060\u3068\u300c\/hogehoge\/js\/search_station.js\u300d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4ee5\u4e0b\u5185\u5bb9\u3067\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">\/\/ACF\u8a2d\u5b9a\u753b\u9762\u306eKey\u3092\u3053\u3053\u306b\u66f8\u304f\r\nvar region_id = 'acf-field_xxxxxxxxxxxxxx';\r\nvar prefecture_id = 'acf-field_xxxxxxxxxxxxxx';\r\nvar subway_id = 'acf-field_xxxxxxxxxxxxxx';\r\nvar private_id = 'acf-field_xxxxxxxxxxxxxx';\r\nvar jr_id = 'acf-field_xxxxxxxxxxxxxx';\r\nvar station_id = 'acf-field_xxxxxxxxxxxxxx';\r\n\r\n(function($) {\r\n    $(document).ready(function(){\r\n\r\n        $(document).on( 'change blur', `#${region_id}, #${prefecture_id}, #${subway_id}, #${private_id}, #${jr_id}`, function(){\r\n\r\n            var selecter_id = $(this).attr(\"id\");\r\n\r\n            \/\/\u30a8\u30ea\u30a2\u9078\u629e\r\n            if( selecter_id == region_id ){\r\n                var mode = 'region';\r\n\r\n            \/\/\u90fd\u9053\u5e9c\u770c\u9078\u629e\r\n            }else if( selecter_id == prefecture_id ){\r\n                var mode = 'prefecture';\r\n\r\n            \/\/\u8def\u7dda\u9078\u629e\r\n            }else{\r\n                var mode = 'station';\r\n            }\r\n\r\n            $.ajax({\r\n                type: 'POST',\r\n                url: ajaxurl,\r\n                data: {\r\n                    'action' : 'select_station', \r\n                    'id' : $(this).val(), \r\n                    'mode' : mode\r\n                },\r\n                success: function( result ){\r\n\r\n                    \/\/\u30a8\u30ea\u30a2\u9078\u629e\r\n                    if( selecter_id == region_id ){\r\n                        var prefecture = $.parseJSON(result);\r\n                        var html = '';\r\n                        for(var key in prefecture){\r\n                            html += '&lt;option value=\"' + prefecture[key]['id'] + '\"&gt;' + prefecture[key]['name'] + '&lt;\/option&gt;';\r\n                        }\r\n                        $('#' + prefecture_id).html(html);\r\n\r\n                    \/\/\u90fd\u9053\u5e9c\u770c\u9078\u629e\r\n                    }else if( selecter_id == prefecture_id ){\r\n                        var line = $.parseJSON(result);\r\n                        var subway = '';\r\n                        var private = '';\r\n                        var jr = '';\r\n\r\n                        for(var key in line){\r\n                            if( line[key]['subway'] == 1 ){\r\n                                subway += '&lt;option value=\"' + line[key]['line_cd'] + '\"&gt;' + line[key]['line_name'] + '&lt;\/option&gt;';\r\n                            }else if( line[key]['company_type'] == 1 ){\r\n                                jr += '&lt;option value=\"' + line[key]['line_cd'] + '\"&gt;' + line[key]['line_name'] + '&lt;\/option&gt;';\r\n                            }else{\r\n                                private += '&lt;option value=\"' + line[key]['line_cd'] + '\"&gt;' + line[key]['line_name'] + '&lt;\/option&gt;';\r\n                            }\r\n                        }\r\n\r\n                        $('#' + subway_id).html(subway);\r\n                        $('#' + private_id).html(private);\r\n                        $('#' + jr_id).html(jr);\r\n\r\n                    \/\/\u8def\u7dda\u9078\u629e\r\n                    }else{\r\n                        var station = $.parseJSON(result);\r\n                        var html = '';\r\n                        for(var key in station){\r\n                            html += '&lt;option value=\"' + station[key]['station_cd'] + '\"&gt;' + station[key]['station_name'] + '&lt;\/option&gt;';\r\n                        }\r\n                        $('#' + station_id).html(html);\r\n                    }\r\n\r\n                }\r\n            });\r\n            return false;\r\n        });\r\n    });\r\n})(jQuery);<\/pre>\n<p>WordPress\u3067ajax\u901a\u4fe1\u3092\u3059\u308b\u969b\u306fajaxurl(\/wp-admin\/admin-ajax.php)\u306b\u30ea\u30af\u30a8\u30b9\u30c8\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3089\u3057\u3044\u3002\u6700\u521d\u9069\u5f53\u306a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u7a81\u3063\u8fbc\u3093\u3067\u547c\u3073\u51fa\u305d\u3046\u3068\u3057\u305f\u304c\u30a8\u30e9\u30fc\u304c\u8d77\u304d\u305f\u3002<\/p>\n<p>\u3042\u3068ACF\u3092\u4f7f\u3063\u3066\u3044\u308b\u3068jQuery\u7b49\u3067\u5404\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u5f8c\u304b\u3089\u8ffd\u52a0\u3055\u308c\u308b\u306e\u3067\u30014\u884c\u76ee\u306e\u90e8\u5206\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u6ce8\u610f\u3059\u308b\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#\u5f8c\u304b\u3089\u8ffd\u52a0\u3055\u308c\u308b\u8981\u7d20\u306f\u3053\u308c\u3060\u3068\u52d5\u304b\u306a\u3044\r\n$('\u30bb\u30ec\u30af\u30bf').change(function()){\r\n\r\n#\u3053\u308c\u3060\u3068\u52d5\u304f\r\n$(document).on( 'change blur', `\u30bb\u30ec\u30af\u30bf`, function(){<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>WordPress\u3067\u30ab\u30b9\u30bf\u30e0\u30d5\u30a3\u30fc\u30eb\u30c9\u8a2d\u5b9a\u7528\u306e\u30d7\u30e9\u30b0\u30a4\u30f3Advanced Cus ... <\/p>\n","protected":false},"author":1,"featured_media":1093,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24,41],"tags":[97],"class_list":["post-3131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-cms","tag-advanced-custom-fields"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/3131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=3131"}],"version-history":[{"count":4,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/3131\/revisions"}],"predecessor-version":[{"id":4748,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/3131\/revisions\/4748"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1093"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=3131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=3131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=3131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}