{"id":14870,"date":"2013-09-13T08:00:52","date_gmt":"2013-09-12T23:00:52","guid":{"rendered":"http:\/\/www.sssg.org\/blogs\/hiro345\/?p=14870"},"modified":"2013-09-10T08:29:00","modified_gmt":"2013-09-09T23:29:00","slug":"cakephp2%e3%81%a7csv%e3%82%84tsv%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e3%83%80%e3%82%a6%e3%83%b3%e3%83%ad%e3%83%bc%e3%83%89%e3%81%a7%e3%81%8d%e3%82%8b%e3%82%88%e3%81%86%e3%81%ab%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.hiro345.net\/blogs\/hiro345\/archives\/14870.html","title":{"rendered":"CakePHP2\u3067CSV\u3084TSV\u30c7\u30fc\u30bf\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u306b\u306f"},"content":{"rendered":"

\u30d8\u30eb\u30d1\u30fc\u3092\u4f7f\u3046\u65b9\u6cd5\u3082\u3042\u308b\u3088\u3046\u3067\u3059\u304c\u3001\u3082\u3063\u3068\u5358\u7d14\u306a\u65b9\u6cd5\u3067\u5b9f\u88c5\u3092\u3057\u3066\u307f\u307e\u3057\u305f\u3002\u62e1\u5f35\u5b50\u6307\u5b9a\u306b\u3088\u3063\u3066View\u3092\u5207\u308a\u66ff\u3048\u305f\u3044\u3068\u3044\u3063\u305f\u8981\u671b\u304c\u306a\u3044\u5834\u5408\u306f\u3053\u308c\u3067\u5341\u5206\u3067\u3057\u3087\u3046\u3002
\n
\nInfoController.php\u3092\u7528\u610f\u3057\u3066\u3042\u308a\u3001http:\/\/example.jp\/app\/info\/ \u3067\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u8a2d\u5b9a\u3057\u3066\u3042\u308b\u3068\u3057\u307e\u3059\u3002\u4e0b\u8a18\u306e\u3088\u3046\u306blist_all_csv()\u30e1\u30bd\u30c3\u30c9\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u3053\u3046\u3059\u308b\u3068\u3001http:\/\/example.jp\/app\/info\/list_all_tsv \u3078\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068TSV\u30d5\u30a1\u30a4\u30eb\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u304c\u3067\u304d\u307e\u3059\u3002CSV\u30d5\u30a1\u30a4\u30eb\u306b\u3057\u305f\u3044\u5834\u5408\u306f\u3001 “\\t” \u3092 “,” \u306b\u76f4\u305b\u3070\u3044\u3044\u3067\u3057\u3087\u3046\u3002\u307e\u305f\u3001\u30d8\u30c3\u30c0\u30fc\u304c\u3044\u3089\u306a\u3044\u5834\u5408\u306f\u3001$list[0]\u306b\u95a2\u3057\u3066\u306e\u51e6\u7406\u3092\u7701\u7565\u3057\u307e\u3059\u3002<\/p>\n

\r\n  public function list_all_tsv()\r\n  {\r\n    $tsv_file_name = 'info.tsv';\r\n    $response_type = 'comma-separated-values';\r\n    $this->autoRender = false;\r\n    $this->response->type($response_type);\r\n    $this->response->download($tsv_file_name);\r\n    $list = $this->Info->find('all');\r\n    \/\/Debugger::log($list);\r\n    $content = "";\r\n    $list_size = count($list);\r\n    $info = $list[0]['Info'];\r\n    foreach (array_keys($info) as $info_key) {\r\n      $a = $info_key;\r\n      $content .= $a . "\\t";\r\n    }\r\n    $content .= "\\n";\r\n    for ($i = 0; $i < $list_size; $i++) {\r\n      $info = $list[$i]['Info'];\r\n      foreach (array_keys($info) as $info_key) {\r\n        $a = $info[$info_key];\r\n        $content .= $a . "\\t";\r\n      }\r\n      $content .= "\\n";\r\n    }\r\n    $this->response->body($content);\r\n  }\r\n<\/pre>\n
CakePHP2\u306e\u53c2\u8003\u66f8\u306b\u306f\u4e0b\u8a18\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n