{"action":"created","comment":{"url":"https://api.github.com/repos/teryhill/openemr/pulls/comments/64146971","id":64146971,"diff_hunk":"@@ -115,7 +115,7 @@ function getInsuranceProvidersExtra() {\n         $sql = \"select insurance_companies.name, insurance_companies.id, \" .\n           \"addresses.zip, addresses.line1, addresses.state \" .\n           \"from insurance_companies, addresses \" .\n-          \"where addresses.foreign_id = insurance_companies.id \" .\n+          \"where addresses.foreign_id = insurance_companies.id and active = 1 \".","path":"library/patient.inc","position":14,"original_position":14,"commit_id":"e43078acc5b3735aef7b2948ed54b64d46432e13","original_commit_id":"e43078acc5b3735aef7b2948ed54b64d46432e13","user":{"login":"bradymiller","id":278968,"avatar_url":"https://avatars.githubusercontent.com/u/278968?v=3","gravatar_id":"","url":"https://api.github.com/users/bradymiller","html_url":"https://github.com/bradymiller","followers_url":"https://api.github.com/users/bradymiller/followers","following_url":"https://api.github.com/users/bradymiller/following{/other_user}","gists_url":"https://api.github.com/users/bradymiller/gists{/gist_id}","starred_url":"https://api.github.com/users/bradymiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradymiller/subscriptions","organizations_url":"https://api.github.com/users/bradymiller/orgs","repos_url":"https://api.github.com/users/bradymiller/repos","events_url":"https://api.github.com/users/bradymiller/events{/privacy}","received_events_url":"https://api.github.com/users/bradymiller/received_events","type":"User","site_admin":false},"body":"Will make this more specific:\r\ninsurance_companies.active = 1","created_at":"2016-05-22T09:23:46Z","updated_at":"2016-05-22T09:23:46Z","html_url":"https://github.com/teryhill/openemr/pull/1#discussion_r64146971","pull_request_url":"https://api.github.com/repos/teryhill/openemr/pulls/1","_links":{"self":{"href":"https://api.github.com/repos/teryhill/openemr/pulls/comments/64146971"},"html":{"href":"https://github.com/teryhill/openemr/pull/1#discussion_r64146971"},"pull_request":{"href":"https://api.github.com/repos/teryhill/openemr/pulls/1"}}},"pull_request":{"url":"https://api.github.com/repos/teryhill/openemr/pulls/1","id":68482961,"html_url":"https://github.com/teryhill/openemr/pull/1","diff_url":"https://github.com/teryhill/openemr/pull/1.diff","patch_url":"https://github.com/teryhill/openemr/pull/1.patch","issue_url":"https://api.github.com/repos/teryhill/openemr/issues/1","number":1,"state":"open","locked":false,"title":"Inactivate Insurance Companies","user":{"login":"teryhill","id":4655366,"avatar_url":"https://avatars.githubusercontent.com/u/4655366?v=3","gravatar_id":"","url":"https://api.github.com/users/teryhill","html_url":"https://github.com/teryhill","followers_url":"https://api.github.com/users/teryhill/followers","following_url":"https://api.github.com/users/teryhill/following{/other_user}","gists_url":"https://api.github.com/users/teryhill/gists{/gist_id}","starred_url":"https://api.github.com/users/teryhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teryhill/subscriptions","organizations_url":"https://api.github.com/users/teryhill/orgs","repos_url":"https://api.github.com/users/teryhill/repos","events_url":"https://api.github.com/users/teryhill/events{/privacy}","received_events_url":"https://api.github.com/users/teryhill/received_events","type":"User","site_admin":false},"body":"Inactivate Insurance Companies","created_at":"2016-05-01T00:19:31Z","updated_at":"2016-05-22T09:23:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/teryhill/openemr/pulls/1/commits","review_comments_url":"https://api.github.com/repos/teryhill/openemr/pulls/1/comments","review_comment_url":"https://api.github.com/repos/teryhill/openemr/pulls/comments{/number}","comments_url":"https://api.github.com/repos/teryhill/openemr/issues/1/comments","statuses_url":"https://api.github.com/repos/teryhill/openemr/statuses/e43078acc5b3735aef7b2948ed54b64d46432e13","head":{"label":"teryhill:insurance_inactivate","ref":"insurance_inactivate","sha":"e43078acc5b3735aef7b2948ed54b64d46432e13","user":{"login":"teryhill","id":4655366,"avatar_url":"https://avatars.githubusercontent.com/u/4655366?v=3","gravatar_id":"","url":"https://api.github.com/users/teryhill","html_url":"https://github.com/teryhill","followers_url":"https://api.github.com/users/teryhill/followers","following_url":"https://api.github.com/users/teryhill/following{/other_user}","gists_url":"https://api.github.com/users/teryhill/gists{/gist_id}","starred_url":"https://api.github.com/users/teryhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teryhill/subscriptions","organizations_url":"https://api.github.com/users/teryhill/orgs","repos_url":"https://api.github.com/users/teryhill/repos","events_url":"https://api.github.com/users/teryhill/events{/privacy}","received_events_url":"https://api.github.com/users/teryhill/received_events","type":"User","site_admin":false},"repo":{"id":20582781,"name":"openemr","full_name":"teryhill/openemr","owner":{"login":"teryhill","id":4655366,"avatar_url":"https://avatars.githubusercontent.com/u/4655366?v=3","gravatar_id":"","url":"https://api.github.com/users/teryhill","html_url":"https://github.com/teryhill","followers_url":"https://api.github.com/users/teryhill/followers","following_url":"https://api.github.com/users/teryhill/following{/other_user}","gists_url":"https://api.github.com/users/teryhill/gists{/gist_id}","starred_url":"https://api.github.com/users/teryhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teryhill/subscriptions","organizations_url":"https://api.github.com/users/teryhill/orgs","repos_url":"https://api.github.com/users/teryhill/repos","events_url":"https://api.github.com/users/teryhill/events{/privacy}","received_events_url":"https://api.github.com/users/teryhill/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/teryhill/openemr","description":"Mirror of official OpenEMR Sourceforge repository","fork":true,"url":"https://api.github.com/repos/teryhill/openemr","forks_url":"https://api.github.com/repos/teryhill/openemr/forks","keys_url":"https://api.github.com/repos/teryhill/openemr/keys{/key_id}","collaborators_url":"https://api.github.com/repos/teryhill/openemr/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/teryhill/openemr/teams","hooks_url":"https://api.github.com/repos/teryhill/openemr/hooks","issue_events_url":"https://api.github.com/repos/teryhill/openemr/issues/events{/number}","events_url":"https://api.github.com/repos/teryhill/openemr/events","assignees_url":"https://api.github.com/repos/teryhill/openemr/assignees{/user}","branches_url":"https://api.github.com/repos/teryhill/openemr/branches{/branch}","tags_url":"https://api.github.com/repos/teryhill/openemr/tags","blobs_url":"https://api.github.com/repos/teryhill/openemr/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/teryhill/openemr/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/teryhill/openemr/git/refs{/sha}","trees_url":"https://api.github.com/repos/teryhill/openemr/git/trees{/sha}","statuses_url":"https://api.github.com/repos/teryhill/openemr/statuses/{sha}","languages_url":"https://api.github.com/repos/teryhill/openemr/languages","stargazers_url":"https://api.github.com/repos/teryhill/openemr/stargazers","contributors_url":"https://api.github.com/repos/teryhill/openemr/contributors","subscribers_url":"https://api.github.com/repos/teryhill/openemr/subscribers","subscription_url":"https://api.github.com/repos/teryhill/openemr/subscription","commits_url":"https://api.github.com/repos/teryhill/openemr/commits{/sha}","git_commits_url":"https://api.github.com/repos/teryhill/openemr/git/commits{/sha}","comments_url":"https://api.github.com/repos/teryhill/openemr/comments{/number}","issue_comment_url":"https://api.github.com/repos/teryhill/openemr/issues/comments{/number}","contents_url":"https://api.github.com/repos/teryhill/openemr/contents/{+path}","compare_url":"https://api.github.com/repos/teryhill/openemr/compare/{base}...{head}","merges_url":"https://api.github.com/repos/teryhill/openemr/merges","archive_url":"https://api.github.com/repos/teryhill/openemr/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/teryhill/openemr/downloads","issues_url":"https://api.github.com/repos/teryhill/openemr/issues{/number}","pulls_url":"https://api.github.com/repos/teryhill/openemr/pulls{/number}","milestones_url":"https://api.github.com/repos/teryhill/openemr/milestones{/number}","notifications_url":"https://api.github.com/repos/teryhill/openemr/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/teryhill/openemr/labels{/name}","releases_url":"https://api.github.com/repos/teryhill/openemr/releases{/id}","deployments_url":"https://api.github.com/repos/teryhill/openemr/deployments","created_at":"2014-06-07T01:30:46Z","updated_at":"2016-03-02T18:45:10Z","pushed_at":"2016-05-13T12:06:39Z","git_url":"git://github.com/teryhill/openemr.git","ssh_url":"git@github.com:teryhill/openemr.git","clone_url":"https://github.com/teryhill/openemr.git","svn_url":"https://github.com/teryhill/openemr","homepage":"http://open-emr.org/","size":259892,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":false,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"teryhill:master","ref":"master","sha":"ba2406ce00bb4e0ea058f5231d379af3d681757d","user":{"login":"teryhill","id":4655366,"avatar_url":"https://avatars.githubusercontent.com/u/4655366?v=3","gravatar_id":"","url":"https://api.github.com/users/teryhill","html_url":"https://github.com/teryhill","followers_url":"https://api.github.com/users/teryhill/followers","following_url":"https://api.github.com/users/teryhill/following{/other_user}","gists_url":"https://api.github.com/users/teryhill/gists{/gist_id}","starred_url":"https://api.github.com/users/teryhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teryhill/subscriptions","organizations_url":"https://api.github.com/users/teryhill/orgs","repos_url":"https://api.github.com/users/teryhill/repos","events_url":"https://api.github.com/users/teryhill/events{/privacy}","received_events_url":"https://api.github.com/users/teryhill/received_events","type":"User","site_admin":false},"repo":{"id":20582781,"name":"openemr","full_name":"teryhill/openemr","owner":{"login":"teryhill","id":4655366,"avatar_url":"https://avatars.githubusercontent.com/u/4655366?v=3","gravatar_id":"","url":"https://api.github.com/users/teryhill","html_url":"https://github.com/teryhill","followers_url":"https://api.github.com/users/teryhill/followers","following_url":"https://api.github.com/users/teryhill/following{/other_user}","gists_url":"https://api.github.com/users/teryhill/gists{/gist_id}","starred_url":"https://api.github.com/users/teryhill/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/teryhill/subscriptions","organizations_url":"https://api.github.com/users/teryhill/orgs","repos_url":"https://api.github.com/users/teryhill/repos","events_url":"https://api.github.com/users/teryhill/events{/privacy}","received_events_url":"https://api.github.com/users/teryhill/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/teryhill/openemr","description":"Mirror of official OpenEMR Sourceforge repository","fork":true,"url":"https://api.github.com/repos/teryhill/openemr","forks_url":"https://api.github.com/repos/teryhill/openemr/forks","keys_url":"https://api.github.com/repos/teryhill/openemr/keys{/key_id}","collaborators_url":"https://api.github.com/repos/teryhill/openemr/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/teryhill/openemr/teams","hooks_url":"https://api.github.com/repos/teryhill/openemr/hooks","issue_events_url":"https://api.github.com/repos/teryhill/openemr/issues/events{/number}","events_url":"https://api.github.com/repos/teryhill/openemr/events","assignees_url":"https://api.github.com/repos/teryhill/openemr/assignees{/user}","branches_url":"https://api.github.com/repos/teryhill/openemr/branches{/branch}","tags_url":"https://api.github.com/repos/teryhill/openemr/tags","blobs_url":"https://api.github.com/repos/teryhill/openemr/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/teryhill/openemr/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/teryhill/openemr/git/refs{/sha}","trees_url":"https://api.github.com/repos/teryhill/openemr/git/trees{/sha}","statuses_url":"https://api.github.com/repos/teryhill/openemr/statuses/{sha}","languages_url":"https://api.github.com/repos/teryhill/openemr/languages","stargazers_url":"https://api.github.com/repos/teryhill/openemr/stargazers","contributors_url":"https://api.github.com/repos/teryhill/openemr/contributors","subscribers_url":"https://api.github.com/repos/teryhill/openemr/subscribers","subscription_url":"https://api.github.com/repos/teryhill/openemr/subscription","commits_url":"https://api.github.com/repos/teryhill/openemr/commits{/sha}","git_commits_url":"https://api.github.com/repos/teryhill/openemr/git/commits{/sha}","comments_url":"https://api.github.com/repos/teryhill/openemr/comments{/number}","issue_comment_url":"https://api.github.com/repos/teryhill/openemr/issues/comments{/number}","contents_url":"https://api.github.com/repos/teryhill/openemr/contents/{+path}","compare_url":"https://api.github.com/repos/teryhill/openemr/compare/{base}...{head}","merges_url":"https://api.github.com/repos/teryhill/openemr/merges","archive_url":"https://api.github.com/repos/teryhill/openemr/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/teryhill/openemr/downloads","issues_url":"https://api.github.com/repos/teryhill/openemr/issues{/number}","pulls_url":"https://api.github.com/repos/teryhill/openemr/pulls{/number}","milestones_url":"https://api.github.com/repos/teryhill/openemr/milestones{/number}","notifications_url":"https://api.github.com/repos/teryhill/openemr/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/teryhill/openemr/labels{/name}","releases_url":"https://api.github.com/repos/teryhill/openemr/releases{/id}","deployments_url":"https://api.github.com/repos/teryhill/openemr/deployments","created_at":"2014-06-07T01:30:46Z","updated_at":"2016-03-02T18:45:10Z","pushed_at":"2016-05-13T12:06:39Z","git_url":"git://github.com/teryhill/openemr.git","ssh_url":"git@github.com:teryhill/openemr.git","clone_url":"https://github.com/teryhill/openemr.git","svn_url":"https://github.com/teryhill/openemr","homepage":"http://open-emr.org/","size":259892,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":false,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/teryhill/openemr/pulls/1"},"html":{"href":"https://github.com/teryhill/openemr/pull/1"},"issue":{"href":"https://api.github.com/repos/teryhill/openemr/issues/1"},"comments":{"href":"https://api.github.com/repos/teryhill/openemr/issues/1/comments"},"review_comments":{"href":"https://api.github.com/repos/teryhill/openemr/pulls/1/comments"},"review_comment":{"href":"https://api.github.com/repos/teryhill/openemr/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/teryhill/openemr/pulls/1/commits"},"statuses":{"href":"https://api.github.com/repos/teryhill/openemr/statuses/e43078acc5b3735aef7b2948ed54b64d46432e13"}}}}
{"actor":{"display_login":"bradymiller"}}