{"action":"opened","issue":{"url":"https://api.github.com/repos/shr1213/Notes/issues/1","repository_url":"https://api.github.com/repos/shr1213/Notes","labels_url":"https://api.github.com/repos/shr1213/Notes/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/shr1213/Notes/issues/1/comments","events_url":"https://api.github.com/repos/shr1213/Notes/issues/1/events","html_url":"https://github.com/shr1213/Notes/issues/1","id":323568520,"number":1,"title":"10.10.4.27Sonar梳理","user":{"login":"shr1213","id":27627484,"avatar_url":"https://avatars2.githubusercontent.com/u/27627484?v=4","gravatar_id":"","url":"https://api.github.com/users/shr1213","html_url":"https://github.com/shr1213","followers_url":"https://api.github.com/users/shr1213/followers","following_url":"https://api.github.com/users/shr1213/following{/other_user}","gists_url":"https://api.github.com/users/shr1213/gists{/gist_id}","starred_url":"https://api.github.com/users/shr1213/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shr1213/subscriptions","organizations_url":"https://api.github.com/users/shr1213/orgs","repos_url":"https://api.github.com/users/shr1213/repos","events_url":"https://api.github.com/users/shr1213/events{/privacy}","received_events_url":"https://api.github.com/users/shr1213/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-16T10:51:10Z","updated_at":"2018-05-16T10:51:10Z","closed_at":null,"author_association":"OWNER","body":"#一、Sonar和FineReport结构分析\r\n##FineReport\r\n*FineReport中的SQL仅为从数据库中取数据，并对取到的数据按照公式计算，表格中的数据直接填入的是计算后的结果，数据计算过程并不在表格位置进行\r\n![image](https://user-images.githubusercontent.com/27627484/40108470-8651734e-592d-11e8-986d-d6860f26b2f4.png)\r\n##Sonar\r\n*函数p_finalstatistic使用视图v_finalstatistic的数据建表project_finalstatistic\r\n*函数p_finalstatistic1使用视图v_finalstatistic1的数据建表project_finalstatistic1\r\n*视图v_finalstatistic和视图v_finalstatistic1均使用Sonar自己的issue表和自建的project_dept_relation表生成\r\n*project_dept_relation使用如下建表语句生成\r\n[project_dept_relation.txt](https://github.com/shr1213/Notes/files/2008397/project_dept_relation.txt)\r\n\r\n"}}
{"actor":{"display_login":"shr1213"}}