{"action":"created","issue":{"url":"https://api.github.com/repos/apolobra/poker-coach-2/issues/7","repository_url":"https://api.github.com/repos/apolobra/poker-coach-2","labels_url":"https://api.github.com/repos/apolobra/poker-coach-2/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/apolobra/poker-coach-2/issues/7/comments","events_url":"https://api.github.com/repos/apolobra/poker-coach-2/issues/7/events","html_url":"https://github.com/apolobra/poker-coach-2/issues/7","id":130429200,"number":7,"title":"Mensagens (chat)","user":{"login":"apolobra","id":17006402,"avatar_url":"https://avatars.githubusercontent.com/u/17006402?v=3","gravatar_id":"","url":"https://api.github.com/users/apolobra","html_url":"https://github.com/apolobra","followers_url":"https://api.github.com/users/apolobra/followers","following_url":"https://api.github.com/users/apolobra/following{/other_user}","gists_url":"https://api.github.com/users/apolobra/gists{/gist_id}","starred_url":"https://api.github.com/users/apolobra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apolobra/subscriptions","organizations_url":"https://api.github.com/users/apolobra/orgs","repos_url":"https://api.github.com/users/apolobra/repos","events_url":"https://api.github.com/users/apolobra/events{/privacy}","received_events_url":"https://api.github.com/users/apolobra/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/apolobra/poker-coach-2/milestones/3","html_url":"https://github.com/apolobra/poker-coach-2/milestones/Dashboard","labels_url":"https://api.github.com/repos/apolobra/poker-coach-2/milestones/3/labels","id":1558946,"number":3,"title":"Dashboard","description":"","creator":{"login":"apolobra","id":17006402,"avatar_url":"https://avatars.githubusercontent.com/u/17006402?v=3","gravatar_id":"","url":"https://api.github.com/users/apolobra","html_url":"https://github.com/apolobra","followers_url":"https://api.github.com/users/apolobra/followers","following_url":"https://api.github.com/users/apolobra/following{/other_user}","gists_url":"https://api.github.com/users/apolobra/gists{/gist_id}","starred_url":"https://api.github.com/users/apolobra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apolobra/subscriptions","organizations_url":"https://api.github.com/users/apolobra/orgs","repos_url":"https://api.github.com/users/apolobra/repos","events_url":"https://api.github.com/users/apolobra/events{/privacy}","received_events_url":"https://api.github.com/users/apolobra/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":0,"state":"open","created_at":"2016-02-02T15:37:10Z","updated_at":"2016-02-03T11:44:22Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-02-01T17:35:38Z","updated_at":"2016-03-31T10:52:09Z","closed_at":null,"body":"Mensagens irão se comportar como chat. Como sempre a navegação na plataforma é de usuário logado, ele apenas aceita mensagem se houver login, não é necessário criar o sistema inteiro de chat, mas a troca de mensagens dinâmicas vai permitir maior iteração entre os jogadores.\r\n\r\n[css]\r\n- [x] Montagem do layout inicial do chat (2 colunas)\r\n- [x] Lista de conversas\r\n- [ ] Janela de conversa\r\n- [ ] Campo de nova mensagem\r\n\r\n[jogador online]\r\n- [x] sessão permanece por 2 minutos, depois desse tempo o jogador é considerado offline\r\n- [x] gravar usuário online \r\n\r\n[nova mensagem com aula]\r\n- [ ] Post da tela de compra de aula verifica se já existe uma conversa aberta com a aquele jogador\r\n- [ ] Assunto será enviado como forma de mensagem\r\n\r\n[recursos]\r\n- [ ] mensagens não lidas pelo receptor\r\n- [ ] arquivar a conversa por usuário\r\n- [ ] bloquear usuário\r\n\r\n\r\n- [ ] adicionar imagem já é enviada como uma mensagem"},"comment":{"url":"https://api.github.com/repos/apolobra/poker-coach-2/issues/comments/203876555","html_url":"https://github.com/apolobra/poker-coach-2/issues/7#issuecomment-203876555","issue_url":"https://api.github.com/repos/apolobra/poker-coach-2/issues/7","id":203876555,"user":{"login":"apolobra","id":17006402,"avatar_url":"https://avatars.githubusercontent.com/u/17006402?v=3","gravatar_id":"","url":"https://api.github.com/users/apolobra","html_url":"https://github.com/apolobra","followers_url":"https://api.github.com/users/apolobra/followers","following_url":"https://api.github.com/users/apolobra/following{/other_user}","gists_url":"https://api.github.com/users/apolobra/gists{/gist_id}","starred_url":"https://api.github.com/users/apolobra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/apolobra/subscriptions","organizations_url":"https://api.github.com/users/apolobra/orgs","repos_url":"https://api.github.com/users/apolobra/repos","events_url":"https://api.github.com/users/apolobra/events{/privacy}","received_events_url":"https://api.github.com/users/apolobra/received_events","type":"User","site_admin":false},"created_at":"2016-03-31T10:52:09Z","updated_at":"2016-03-31T10:52:09Z","body":"`CREATE VIEW view_mensagens AS\r\nSELECT \r\nm.*,\r\nj.nome,\r\nj.online,\r\nj.foto_perfil,\r\nmj.jogadores_id,\r\nmj.limpar_conversa,\r\nmj.status situacao,\r\nmj.timestamp\r\nFROM mensagens_jogadores mj \r\nINNER JOIN mensagens m ON m.id = mj.mensagens_id\r\nINNER JOIN view_jogadores j ON j.id = mj.`jogadores_id``"}}