{"action":"created","issue":{"url":"https://api.github.com/repos/magonotepc/magonotepc/issues/16","labels_url":"https://api.github.com/repos/magonotepc/magonotepc/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/magonotepc/magonotepc/issues/16/comments","events_url":"https://api.github.com/repos/magonotepc/magonotepc/issues/16/events","html_url":"https://github.com/magonotepc/magonotepc/issues/16","id":111976060,"number":16,"title":"顧客　会員番号発行","user":{"login":"popnondo","id":13173780,"avatar_url":"https://avatars.githubusercontent.com/u/13173780?v=3","gravatar_id":"","url":"https://api.github.com/users/popnondo","html_url":"https://github.com/popnondo","followers_url":"https://api.github.com/users/popnondo/followers","following_url":"https://api.github.com/users/popnondo/following{/other_user}","gists_url":"https://api.github.com/users/popnondo/gists{/gist_id}","starred_url":"https://api.github.com/users/popnondo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/popnondo/subscriptions","organizations_url":"https://api.github.com/users/popnondo/orgs","repos_url":"https://api.github.com/users/popnondo/repos","events_url":"https://api.github.com/users/popnondo/events{/privacy}","received_events_url":"https://api.github.com/users/popnondo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/magonotepc/magonotepc/labels/cakePHP","name":"cakePHP","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"popnondo","id":13173780,"avatar_url":"https://avatars.githubusercontent.com/u/13173780?v=3","gravatar_id":"","url":"https://api.github.com/users/popnondo","html_url":"https://github.com/popnondo","followers_url":"https://api.github.com/users/popnondo/followers","following_url":"https://api.github.com/users/popnondo/following{/other_user}","gists_url":"https://api.github.com/users/popnondo/gists{/gist_id}","starred_url":"https://api.github.com/users/popnondo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/popnondo/subscriptions","organizations_url":"https://api.github.com/users/popnondo/orgs","repos_url":"https://api.github.com/users/popnondo/repos","events_url":"https://api.github.com/users/popnondo/events{/privacy}","received_events_url":"https://api.github.com/users/popnondo/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/magonotepc/magonotepc/milestones/5","html_url":"https://github.com/magonotepc/magonotepc/milestones/%E3%81%BE%E3%81%94%E3%81%AE%E3%81%A6%E3%80%80%E9%A1%A7%E5%AE%A2%E6%83%85%E5%A0%B1%E9%96%A2%E4%BF%82%E8%BF%BD%E5%8A%A0%E3%83%9A%E3%83%BC%E3%82%B8","labels_url":"https://api.github.com/repos/magonotepc/magonotepc/milestones/5/labels","id":1361695,"number":5,"title":"まごのて　顧客情報関係追加ページ","description":"顧客情報関係追加ページ\r\n=========================\r\n顧客ページをここで管理できるように登録・編集できるようにする。\r\n\r\nPoint\r\n--------------------------------------\r\n・　項目は２つ追加する。登録と編集ページ\r\n・　顧客情報登録は本名、生年月日(年のみ)、性別を入力\r\n・　上記の情報から会員番号及びエリアコードを参照し、DBに登録する。(csv)\r\n・　会員番号は6桁の番号のおしりの番号を引っこ抜き16進法に変更し市町村の後ろは重ならないように。\r\n・　市町村のおしりは0～Zまでこれで足りなかったら小文字\r\n・　前の数値は順番に登録していく。とりあえずここも16進法。\r\n・　編集は引っ越した時とか番号が変わるときとかに必要だと思う。(ここ要確認)\r\n\r\nFeeling\r\n-----------------------------------\r\n・　csv読み込みどうやってやるんだっけ。てかこの場所を見つけたりとかできるのかな！！ここが心配\r\n\r\nThink\r\n-----------------------------------\r\n・　とりあえずのちのちコメント制限、ブラックリストとかやったほうがいいんじゃない。","creator":{"login":"popnondo","id":13173780,"avatar_url":"https://avatars.githubusercontent.com/u/13173780?v=3","gravatar_id":"","url":"https://api.github.com/users/popnondo","html_url":"https://github.com/popnondo","followers_url":"https://api.github.com/users/popnondo/followers","following_url":"https://api.github.com/users/popnondo/following{/other_user}","gists_url":"https://api.github.com/users/popnondo/gists{/gist_id}","starred_url":"https://api.github.com/users/popnondo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/popnondo/subscriptions","organizations_url":"https://api.github.com/users/popnondo/orgs","repos_url":"https://api.github.com/users/popnondo/repos","events_url":"https://api.github.com/users/popnondo/events{/privacy}","received_events_url":"https://api.github.com/users/popnondo/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":3,"state":"open","created_at":"2015-10-17T16:54:30Z","updated_at":"2015-11-01T06:11:10Z","due_on":"2015-10-30T15:00:00Z","closed_at":null},"comments":1,"created_at":"2015-10-17T17:55:49Z","updated_at":"2015-11-02T16:16:26Z","closed_at":null,"body":"Important\r\n-------------------------\r\n優先度：★★☆☆☆\r\n重要度：★★★★☆\r\n怠慢度：★★★★☆\r\n難易度：★★★★★\r\n総合評価：ココ初めて。正直できるかどうかわからない\r\n\r\nPoint\r\n---------------------------------------\r\nもらったデータから参照する(B列+C列)。それを見つけたらA列を参照。\r\nA列を変換して会員番号を参照する。\r\n最後の一桁は市町村から先を見る感じ。\r\nその市町村エリアの所をcsvかデータベースにぶち込む必要がある。重複対策用。\r\nあと最初の番号は重ならないようにする。000～FFFまで。"},"comment":{"url":"https://api.github.com/repos/magonotepc/magonotepc/issues/comments/153070504","html_url":"https://github.com/magonotepc/magonotepc/issues/16#issuecomment-153070504","issue_url":"https://api.github.com/repos/magonotepc/magonotepc/issues/16","id":153070504,"user":{"login":"popnondo","id":13173780,"avatar_url":"https://avatars.githubusercontent.com/u/13173780?v=3","gravatar_id":"","url":"https://api.github.com/users/popnondo","html_url":"https://github.com/popnondo","followers_url":"https://api.github.com/users/popnondo/followers","following_url":"https://api.github.com/users/popnondo/following{/other_user}","gists_url":"https://api.github.com/users/popnondo/gists{/gist_id}","starred_url":"https://api.github.com/users/popnondo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/popnondo/subscriptions","organizations_url":"https://api.github.com/users/popnondo/orgs","repos_url":"https://api.github.com/users/popnondo/repos","events_url":"https://api.github.com/users/popnondo/events{/privacy}","received_events_url":"https://api.github.com/users/popnondo/received_events","type":"User","site_admin":false},"created_at":"2015-11-02T16:16:26Z","updated_at":"2015-11-02T16:16:26Z","body":"CSVのデータの文字列をとってくるということは面倒くさそうなので\r\nExcelファイルがあるのでそれをで～たべ～すに登録してそれをとろうって感じにする。\r\n一応なんか登録できるような感じなのでそれを入れよう\r\n\r\nデータベース：magonotepc_address_code\r\nテーブル名：ローマ字で都道府県名を記入(テスト用にさくらニュータウンを追加予定)\r\n\r\nフィールド情報\r\nid：AI/PRKEY\r\nJapan_address：VCHAR(255)　市町村部分\r\nJapan_areacode_10：INT(11)　なんか国で定められている数値を入力\r\nJapan_areacode_16：VCHAR(11)　高木くんが決めたルールで変換したもの。\r\nここは結構いろんなところを書いているけどJapan_areacode_10の最後の文字を取ってそれを16進法に変換する感じ\r\n\r\n市町村さらにその先が少し問題ここはすでに登録しているものはそれを使う。\r\n都道府県名_hipって感じでいいんじゃないかな～～～～！！！！\r\nここ仕様変更してもらいたい、つらみ"}}