{"action":"created","issue":{"url":"https://api.github.com/repos/leoimoli/Base-De-Datos/issues/162","repository_url":"https://api.github.com/repos/leoimoli/Base-De-Datos","labels_url":"https://api.github.com/repos/leoimoli/Base-De-Datos/issues/162/labels{/name}","comments_url":"https://api.github.com/repos/leoimoli/Base-De-Datos/issues/162/comments","events_url":"https://api.github.com/repos/leoimoli/Base-De-Datos/issues/162/events","html_url":"https://github.com/leoimoli/Base-De-Datos/issues/162","id":190776478,"number":162,"title":"SINALIC -- Reactivar Licencia","user":{"login":"leoimoli","id":11543134,"avatar_url":"https://avatars.githubusercontent.com/u/11543134?v=3","gravatar_id":"","url":"https://api.github.com/users/leoimoli","html_url":"https://github.com/leoimoli","followers_url":"https://api.github.com/users/leoimoli/followers","following_url":"https://api.github.com/users/leoimoli/following{/other_user}","gists_url":"https://api.github.com/users/leoimoli/gists{/gist_id}","starred_url":"https://api.github.com/users/leoimoli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leoimoli/subscriptions","organizations_url":"https://api.github.com/users/leoimoli/orgs","repos_url":"https://api.github.com/users/leoimoli/repos","events_url":"https://api.github.com/users/leoimoli/events{/privacy}","received_events_url":"https://api.github.com/users/leoimoli/received_events","type":"User","site_admin":false},"labels":[{"id":406266840,"url":"https://api.github.com/repos/leoimoli/Base-De-Datos/labels/Alta","name":"Alta","color":"d93f0b","default":false},{"id":406266843,"url":"https://api.github.com/repos/leoimoli/Base-De-Datos/labels/Script%20Producci%C3%B3n","name":"Script Producción","color":"FF0000","default":false}],"state":"open","locked":false,"assignee":{"login":"EliasWasinger","id":14162548,"avatar_url":"https://avatars.githubusercontent.com/u/14162548?v=3","gravatar_id":"","url":"https://api.github.com/users/EliasWasinger","html_url":"https://github.com/EliasWasinger","followers_url":"https://api.github.com/users/EliasWasinger/followers","following_url":"https://api.github.com/users/EliasWasinger/following{/other_user}","gists_url":"https://api.github.com/users/EliasWasinger/gists{/gist_id}","starred_url":"https://api.github.com/users/EliasWasinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EliasWasinger/subscriptions","organizations_url":"https://api.github.com/users/EliasWasinger/orgs","repos_url":"https://api.github.com/users/EliasWasinger/repos","events_url":"https://api.github.com/users/EliasWasinger/events{/privacy}","received_events_url":"https://api.github.com/users/EliasWasinger/received_events","type":"User","site_admin":false},"assignees":[{"login":"EliasWasinger","id":14162548,"avatar_url":"https://avatars.githubusercontent.com/u/14162548?v=3","gravatar_id":"","url":"https://api.github.com/users/EliasWasinger","html_url":"https://github.com/EliasWasinger","followers_url":"https://api.github.com/users/EliasWasinger/followers","following_url":"https://api.github.com/users/EliasWasinger/following{/other_user}","gists_url":"https://api.github.com/users/EliasWasinger/gists{/gist_id}","starred_url":"https://api.github.com/users/EliasWasinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EliasWasinger/subscriptions","organizations_url":"https://api.github.com/users/EliasWasinger/orgs","repos_url":"https://api.github.com/users/EliasWasinger/repos","events_url":"https://api.github.com/users/EliasWasinger/events{/privacy}","received_events_url":"https://api.github.com/users/EliasWasinger/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-11-21T16:57:32Z","updated_at":"2016-11-21T17:02:40Z","closed_at":null,"body":"REACTIVAR LA LICENCIA  QUWE SE ENCUEBTRA ANULADA.\r\n\r\nDNI  28838793 MASCULINO\r\n\r\nTramite: 14878112\r\n\r\nInsumo: 005621066"},"comment":{"url":"https://api.github.com/repos/leoimoli/Base-De-Datos/issues/comments/261999795","html_url":"https://github.com/leoimoli/Base-De-Datos/issues/162#issuecomment-261999795","issue_url":"https://api.github.com/repos/leoimoli/Base-De-Datos/issues/162","id":261999795,"user":{"login":"EliasWasinger","id":14162548,"avatar_url":"https://avatars.githubusercontent.com/u/14162548?v=3","gravatar_id":"","url":"https://api.github.com/users/EliasWasinger","html_url":"https://github.com/EliasWasinger","followers_url":"https://api.github.com/users/EliasWasinger/followers","following_url":"https://api.github.com/users/EliasWasinger/following{/other_user}","gists_url":"https://api.github.com/users/EliasWasinger/gists{/gist_id}","starred_url":"https://api.github.com/users/EliasWasinger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EliasWasinger/subscriptions","organizations_url":"https://api.github.com/users/EliasWasinger/orgs","repos_url":"https://api.github.com/users/EliasWasinger/repos","events_url":"https://api.github.com/users/EliasWasinger/events{/privacy}","received_events_url":"https://api.github.com/users/EliasWasinger/received_events","type":"User","site_admin":false},"created_at":"2016-11-21T17:02:40Z","updated_at":"2016-11-21T17:02:40Z","body":"Listo, se pasó la licencia a VIGENTE, dejo la query:\r\n\r\n`select * from tLicencias where txNroLicencia = '28838793' and idTramite = '14878112' /* id 13843500 */\r\n\r\nselect * from tInsumos where txNumeroInsumo = '005621066'\r\n\r\nupdate tLicencias set txEstado = 'VIGENTE' where idLicencia = '13843500'`"}}
{"actor":{"display_login":"EliasWasinger"}}