<?php\nfunction waza_cf_csv_cell($value) {\n $value = (string) $value;\n return preg_match('\/^[\\x00-\\x20]*[=+@-]\/', $value) ? "'" . $value : $value;\n}\nfunction waza_cf_csv_rows($post) {\n $rows = [];\n if (!$post instanceof WP_Post) return $rows;\n foreach (get_post_meta($post->ID) as $key => $unused) {\n $key = (string) $key;\n if ($key === '' || $key[0] === '_') continue;\n $json = wp_json_encode(get_post_meta($post->ID, $key, false), JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);\n if ($json === false) continue;\n $rows[] = array_map('waza_cf_csv_cell', [$post->ID, $post->post_title, $post->post_status, $key, $json]);\n }\n return $rows;\n}\nfunction waza_cf_csv_batch($type, $after, $max = 0) {\n global $wpdb;\n if (!in_array($type, ['post','page'], true) || $after < 0 || $max < 0) return new WP_Error('invalid', '\u5bfe\u8c61\u307e\u305f\u306fID\u304c\u4e0d\u6b63\u3067\u3059');\n if (!$max) $max = (int) $wpdb->get_var($wpdb->prepare("SELECT MAX(ID) FROM {$wpdb->posts} WHERE post_type=%s", $type));\n $ids = $wpdb->get_col($wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_type=%s AND post_status IN ('publish','draft','pending','private') AND ID>%d AND ID<=%d ORDER BY ID ASC LIMIT 250", $type, $after, $max));\n if ($wpdb->last_error) return new WP_Error('query', '\u6295\u7a3fID\u3092\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f');\n return ['ids'=>array_map('intval', $ids), 'max'=>$max, 'next'=>$ids ? (int) end($ids) : $after];\n}\nadd_action('admin_menu', function () {\n add_management_page('CF CSV\u51fa\u529b', 'CF CSV\u51fa\u529b', 'manage_options', 'waza-cf-csv', function () {\n if (!current_user_can('manage_options')) return;\n echo '<div class="wrap"><h1>CF CSV\u51fa\u529b<\/h1><p>\u521d\u56de\u306f\u4e21\u65b9\u306eID\u30920\u306b\u3057\u307e\u3059\u3002\u7d9a\u304d\u306f\u30d5\u30a1\u30a4\u30eb\u540d\u306enext\u3068max\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>';\n echo '<form method="post" action="' . esc_url(admin_url('admin-post.php')) . '">';\n echo '<input type="hidden" name="action" value="waza_cf_csv">';\n wp_nonce_field('waza_cf_csv');\n echo '<p><label>\u5bfe\u8c61 <select name="post_type"><option value="post">\u6295\u7a3f<\/option><option value="page">\u56fa\u5b9a\u30da\u30fc\u30b8<\/option><\/select><\/label><\/p>';\n echo '<p><label>\u524d\u56de\u306enext ID <input type="number" min="0" name="after" value="0" required><\/label><\/p>';\n echo '<p><label>\u521d\u56de\u306emax ID <input type="number" min="0" name="max" value="0" required><\/label><\/p>';\n submit_button('CSV\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9');\n echo '<\/form><\/div>';\n });\n});\nadd_action('admin_post_waza_cf_csv', function () {\n if (!current_user_can('manage_options')) wp_die('\u6a29\u9650\u304c\u3042\u308a\u307e\u305b\u3093');\n check_admin_referer('waza_cf_csv');\n $type = isset($_POST['post_type']) && is_string($_POST['post_type']) ? wp_unslash($_POST['post_type']) : '';\n $parse = function ($key) { return isset($_POST[$key]) && is_string($_POST[$key]) ? filter_var($_POST[$key], FILTER_VALIDATE_INT, ['options'=>['min_range'=>0]]) : false; };\n $after = $parse('after'); $max = $parse('max');\n if ($after === false || $max === false || ($after > 0 && $max === 0)) wp_die('\u7d9a\u304d\u306e\u51fa\u529b\u3067\u306fnext\u3068max\u306e\u4e21\u65b9\u3092\u6307\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044');\n $batch = waza_cf_csv_batch($type, $after, $max);\n if (is_wp_error($batch)) wp_die(esc_html($batch->get_error_message()));\n if (!$batch['ids']) wp_die('\u3053\u306e\u7bc4\u56f2\u306b\u6b8b\u308a\u306e\u5bfe\u8c61\u8a18\u4e8b\u306f\u3042\u308a\u307e\u305b\u3093');\n if (headers_sent()) wp_die('\u51fa\u529b\u304c\u59cb\u307e\u3063\u3066\u3044\u308b\u305f\u3081CSV\u3092\u4f5c\u6210\u3067\u304d\u307e\u305b\u3093');\n nocache_headers();\n header('Content-Type: text\/csv; charset=UTF-8');\n header('Content-Disposition: attachment; filename="custom-fields-' . $type . '-after-' . $after . '-next-' . $batch['next'] . '-max-' . $batch['max'] . '.csv"');\n $out = fopen('php:\/\/output', 'w');\n if (!$out) wp_die('CSV\u3092\u51fa\u529b\u3067\u304d\u307e\u305b\u3093');\n fwrite($out, "\\xEF\\xBB\\xBF");\n fputcsv($out, ['post_id','post_title','post_status','meta_key','values_json'], ',', '"', '');\n foreach ($batch['ids'] as $id) {\n if (!current_user_can('edit_post', $id)) continue;\n foreach (waza_cf_csv_rows(get_post($id)) as $row) fputcsv($out, $row, ',', '"', '');\n }\n fclose($out);\n exit;\n});\n<\/code><\/pre><\/div>\n\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3068\u78ba\u8a8d<\/h2>\n
\u7ba1\u7406\u753b\u9762\u306e\u300c\u30c4\u30fc\u30eb \u2192 CF CSV\u51fa\u529b\u300d\u3067\u5bfe\u8c61\u3092\u9078\u3073\u3001\u521d\u56de\u306fnext ID\u3068max ID\u306e\u4e21\u65b9\u30920\u306b\u3057\u3066\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n
\u7d9a\u304d\u306f\u76f4\u524d\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u3042\u308bnext\u3068\u3001\u521d\u56de\u306emax\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n
\u305f\u3068\u3048\u3070custom-fields-post-after-0-next-123-max-999.csv\u306a\u3089\u3001\u6b21\u306f123\u3068999\u3067\u3059\u3002<\/p>\n
CSV\u306e\u884c\u6570\u3067\u306f\u306a\u304f\u30d5\u30a1\u30a4\u30eb\u540d\u306eID\u3092\u4f7f\u3046\u305f\u3081\u3001\u5185\u90e8\u30ad\u30fc\u3057\u304b\u306a\u3044\u8a18\u4e8b\u306b\u3082\u5bfe\u5fdc\u3057\u307e\u3059\u3002<\/p>\n
\u6b21\u306e\u53d6\u5f97\u7bc4\u56f2\u306fnext\u3088\u308a\u5927\u304d\u304f\u3001\u521d\u56de\u306emax\u4ee5\u4e0b\u306eID\u3067\u3059\u3002<\/p>\n
\u53d6\u5f97\u6e08\u307f\u306e\u8a18\u4e8b\u304c\u9014\u4e2d\u3067\u524a\u9664\u30fb\u5bfe\u8c61\u5916\u3078\u5909\u308f\u3063\u3066\u3082\u3001\u30da\u30fc\u30b8\u756a\u53f7\u65b9\u5f0f\u306e\u3088\u3046\u306b\u6b21\u306e\u8a18\u4e8b\u3092\u98db\u3070\u3057\u307e\u305b\u3093\u3002<\/p>\n
\u521d\u56de\u3088\u308a\u5f8c\u306b\u8ffd\u52a0\u3055\u308c\u305f\u8a18\u4e8b\u306fmax\u306e\u5916\u3078\u7f6e\u304d\u3001\u6b21\u306e\u4e00\u5de1\u3067\u51fa\u529b\u3057\u307e\u3059\u3002<\/p>\n
\u305f\u3060\u3057\u672c\u6587\u30fb\u5024\u30fb\u72b6\u614b\u3092\u540c\u4e00\u6642\u70b9\u306b\u56fa\u5b9a\u3059\u308b\u6a5f\u80fd\u3067\u306f\u306a\u3044\u305f\u3081\u3001\u5b8c\u5168\u306a\u7167\u5408\u304c\u5fc5\u8981\u306a\u3089\u51fa\u529b\u4e2d\u306e\u66f4\u65b0\u3092\u6b62\u3081\u307e\u3059\u3002<\/p>\n
\u7d42\u4e86\u8868\u793a\u306f\u300c\u3053\u306e\u7bc4\u56f2\u306b\u6b8b\u308a\u306e\u5bfe\u8c61\u8a18\u4e8b\u306f\u3042\u308a\u307e\u305b\u3093\u300d\u3067\u3059\u3002<\/p>\n
\u4e0b\u66f8\u304d\u30fb\u975e\u516c\u958b\u8a18\u4e8b\u306e\u5024\u3082\u542b\u307e\u308c\u5f97\u308b\u305f\u3081\u3001\u4fdd\u5b58\u5834\u6240\u3092\u9650\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
\u65e5\u672c\u8a9e\u3001\u30ab\u30f3\u30de\u3001\u6539\u884c\u3001\u8907\u6570\u5024\u3001\u914d\u5217\u30010\u3092\u542b\u3080\u30c7\u30fc\u30bf\u3067\u78ba\u8a8d\u3057\u307e\u3059\u3002\u5024\u306fJSON\u3068\u3057\u3066\u4fdd\u5b58\u3057\u3001\u8868\u8a08\u7b97\u30bd\u30d5\u30c8\u3067\u5f0f\u306b\u306a\u308a\u3084\u3059\u3044\u30bf\u30a4\u30c8\u30eb\u3084\u30ad\u30fc\u306e\u5148\u982d\u306b\u306f\u30a2\u30dd\u30b9\u30c8\u30ed\u30d5\u30a3\u3092\u4ed8\u3051\u307e\u3059\u3002\u5143\u5024\u3068\u5b8c\u5168\u4e00\u81f4\u3059\u308b\u6a5f\u68b0\u9023\u643a\u7528CSV\u3067\u306f\u306a\u304f\u3001\u78ba\u8a8d\u7528\u306e\u51fa\u529b\u3067\u3059\u3002<\/p>\n
1\u884c\u3092\u8aad\u307f\u53d6\u308b\u4f8b\u3068\u66f4\u65b0\u7528CSV\u3078\u306e\u5bfe\u5fdc<\/h2>\n
![\"CSV\u3092\u5b9f\u969b\u306b\u53d6\u5f97\u3057\u305f\u691c\u8a3c\u7528\u306e\u51fa\u529b\u30d5\u30a9\u30fc\u30e0\"](\"https:\/\/motoki-design.co.jp\/wordpress\/wp-content\/uploads\/waza-fields-csv-form.jpg\")
<\/a>