{"action":"created","comment":{"url":"https://api.github.com/repos/banafshehderayat/304project/pulls/comments/58135921","id":58135921,"diff_hunk":"@@ -108,9 +119,24 @@\n \t\t\t\t\t\t\t\tOCIBindByName($stid, ':bind5', $bind5);\n \t\t\t\t\t\t\t\tOCIExecute($stid);\n \t\t\t\t\t\t\t\tOCICommit($db_conn);\t\n-\t\t\t\t\t\t\t}\n-\n-\n+\t\t\t\t\t\t\t} else \n+\t\t\t\t\t\t\t\tif(array_key_exists ('findCust', $_POST)){\n+\t\t\t\t\t\t\t\t\t$statement = \"SELECT cname FROM customers where NOT EXISTS ((select location_address from location) MINUS (select location_address from reserves where reserves.name = customers.cname)) \";\n+\t\t\t\t\t\t\t\t\t\t\t$stid = oci_parse($db_conn, $statement);\n+\t\t\t\t\t\t\t\t\t\t\tOCIExecute($stid);\n+\t\t\t\t\t\t\t\t\t\t\t$util->printResultTable($stid , [\"CNAME\"]);\n+\t\t\t\t\t\t\t\t\t\t\tOCICommit($db_conn);\n+\t\t\t\t\t\t\t\t} else\n+\t\t\t\t\t\t\t\t\t if (array_key_exists ('findExpensiveLoc' , $_POST)){\n+\t\t\t\t\t\t\t\t\t\t$statement = \"select AVG(cost_per_day), location_address from rooms group by \t\t\t\t\t\t\t\t\t\t\tlocation_address HAVING AVG(cost_per_day) = (select MAX(AVG(cost_per_day)) from rooms \t\t\t\t\t\t\t\t\t\t\tgroup by location_address)\";","path":"manager.php","position":45,"original_position":45,"commit_id":"da8acdeda3f8217d2e2c37da62c19f332dadb2c8","original_commit_id":"da8acdeda3f8217d2e2c37da62c19f332dadb2c8","user":{"login":"jasdeepk","id":8107715,"avatar_url":"https://avatars.githubusercontent.com/u/8107715?v=3","gravatar_id":"","url":"https://api.github.com/users/jasdeepk","html_url":"https://github.com/jasdeepk","followers_url":"https://api.github.com/users/jasdeepk/followers","following_url":"https://api.github.com/users/jasdeepk/following{/other_user}","gists_url":"https://api.github.com/users/jasdeepk/gists{/gist_id}","starred_url":"https://api.github.com/users/jasdeepk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jasdeepk/subscriptions","organizations_url":"https://api.github.com/users/jasdeepk/orgs","repos_url":"https://api.github.com/users/jasdeepk/repos","events_url":"https://api.github.com/users/jasdeepk/events{/privacy}","received_events_url":"https://api.github.com/users/jasdeepk/received_events","type":"User","site_admin":false},"body":"this might require a comment saying what exactly it does...","created_at":"2016-03-31T22:07:46Z","updated_at":"2016-03-31T22:07:46Z","html_url":"https://github.com/banafshehderayat/304project/pull/7#discussion_r58135921","pull_request_url":"https://api.github.com/repos/banafshehderayat/304project/pulls/7","_links":{"self":{"href":"https://api.github.com/repos/banafshehderayat/304project/pulls/comments/58135921"},"html":{"href":"https://github.com/banafshehderayat/304project/pull/7#discussion_r58135921"},"pull_request":{"href":"https://api.github.com/repos/banafshehderayat/304project/pulls/7"}}},"pull_request":{"url":"https://api.github.com/repos/banafshehderayat/304project/pulls/7","id":64854272,"html_url":"https://github.com/banafshehderayat/304project/pull/7","diff_url":"https://github.com/banafshehderayat/304project/pull/7.diff","patch_url":"https://github.com/banafshehderayat/304project/pull/7.patch","issue_url":"https://api.github.com/repos/banafshehderayat/304project/issues/7","number":7,"state":"open","locked":false,"title":"Finishing manager","user":{"login":"banafshehderayat","id":10871727,"avatar_url":"https://avatars.githubusercontent.com/u/10871727?v=3","gravatar_id":"","url":"https://api.github.com/users/banafshehderayat","html_url":"https://github.com/banafshehderayat","followers_url":"https://api.github.com/users/banafshehderayat/followers","following_url":"https://api.github.com/users/banafshehderayat/following{/other_user}","gists_url":"https://api.github.com/users/banafshehderayat/gists{/gist_id}","starred_url":"https://api.github.com/users/banafshehderayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/banafshehderayat/subscriptions","organizations_url":"https://api.github.com/users/banafshehderayat/orgs","repos_url":"https://api.github.com/users/banafshehderayat/repos","events_url":"https://api.github.com/users/banafshehderayat/events{/privacy}","received_events_url":"https://api.github.com/users/banafshehderayat/received_events","type":"User","site_admin":false},"body":"1. Added new queries (division and nested aggregation to manager.php)\r\n2. Added alert to print table\r\n3. Added redirect to employee page and manager page\r\nthis was a pair-programming PR.\r\n@jasdeepk ","created_at":"2016-03-31T20:34:52Z","updated_at":"2016-03-31T22:07:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1d0af0aa0a347ea0ba99168d513fe3a4256664d9","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/banafshehderayat/304project/pulls/7/commits","review_comments_url":"https://api.github.com/repos/banafshehderayat/304project/pulls/7/comments","review_comment_url":"https://api.github.com/repos/banafshehderayat/304project/pulls/comments{/number}","comments_url":"https://api.github.com/repos/banafshehderayat/304project/issues/7/comments","statuses_url":"https://api.github.com/repos/banafshehderayat/304project/statuses/da8acdeda3f8217d2e2c37da62c19f332dadb2c8","head":{"label":"banafshehderayat:finishing-manager","ref":"finishing-manager","sha":"da8acdeda3f8217d2e2c37da62c19f332dadb2c8","user":{"login":"banafshehderayat","id":10871727,"avatar_url":"https://avatars.githubusercontent.com/u/10871727?v=3","gravatar_id":"","url":"https://api.github.com/users/banafshehderayat","html_url":"https://github.com/banafshehderayat","followers_url":"https://api.github.com/users/banafshehderayat/followers","following_url":"https://api.github.com/users/banafshehderayat/following{/other_user}","gists_url":"https://api.github.com/users/banafshehderayat/gists{/gist_id}","starred_url":"https://api.github.com/users/banafshehderayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/banafshehderayat/subscriptions","organizations_url":"https://api.github.com/users/banafshehderayat/orgs","repos_url":"https://api.github.com/users/banafshehderayat/repos","events_url":"https://api.github.com/users/banafshehderayat/events{/privacy}","received_events_url":"https://api.github.com/users/banafshehderayat/received_events","type":"User","site_admin":false},"repo":{"id":53345223,"name":"304project","full_name":"banafshehderayat/304project","owner":{"login":"banafshehderayat","id":10871727,"avatar_url":"https://avatars.githubusercontent.com/u/10871727?v=3","gravatar_id":"","url":"https://api.github.com/users/banafshehderayat","html_url":"https://github.com/banafshehderayat","followers_url":"https://api.github.com/users/banafshehderayat/followers","following_url":"https://api.github.com/users/banafshehderayat/following{/other_user}","gists_url":"https://api.github.com/users/banafshehderayat/gists{/gist_id}","starred_url":"https://api.github.com/users/banafshehderayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/banafshehderayat/subscriptions","organizations_url":"https://api.github.com/users/banafshehderayat/orgs","repos_url":"https://api.github.com/users/banafshehderayat/repos","events_url":"https://api.github.com/users/banafshehderayat/events{/privacy}","received_events_url":"https://api.github.com/users/banafshehderayat/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/banafshehderayat/304project","description":"","fork":false,"url":"https://api.github.com/repos/banafshehderayat/304project","forks_url":"https://api.github.com/repos/banafshehderayat/304project/forks","keys_url":"https://api.github.com/repos/banafshehderayat/304project/keys{/key_id}","collaborators_url":"https://api.github.com/repos/banafshehderayat/304project/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/banafshehderayat/304project/teams","hooks_url":"https://api.github.com/repos/banafshehderayat/304project/hooks","issue_events_url":"https://api.github.com/repos/banafshehderayat/304project/issues/events{/number}","events_url":"https://api.github.com/repos/banafshehderayat/304project/events","assignees_url":"https://api.github.com/repos/banafshehderayat/304project/assignees{/user}","branches_url":"https://api.github.com/repos/banafshehderayat/304project/branches{/branch}","tags_url":"https://api.github.com/repos/banafshehderayat/304project/tags","blobs_url":"https://api.github.com/repos/banafshehderayat/304project/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/banafshehderayat/304project/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/banafshehderayat/304project/git/refs{/sha}","trees_url":"https://api.github.com/repos/banafshehderayat/304project/git/trees{/sha}","statuses_url":"https://api.github.com/repos/banafshehderayat/304project/statuses/{sha}","languages_url":"https://api.github.com/repos/banafshehderayat/304project/languages","stargazers_url":"https://api.github.com/repos/banafshehderayat/304project/stargazers","contributors_url":"https://api.github.com/repos/banafshehderayat/304project/contributors","subscribers_url":"https://api.github.com/repos/banafshehderayat/304project/subscribers","subscription_url":"https://api.github.com/repos/banafshehderayat/304project/subscription","commits_url":"https://api.github.com/repos/banafshehderayat/304project/commits{/sha}","git_commits_url":"https://api.github.com/repos/banafshehderayat/304project/git/commits{/sha}","comments_url":"https://api.github.com/repos/banafshehderayat/304project/comments{/number}","issue_comment_url":"https://api.github.com/repos/banafshehderayat/304project/issues/comments{/number}","contents_url":"https://api.github.com/repos/banafshehderayat/304project/contents/{+path}","compare_url":"https://api.github.com/repos/banafshehderayat/304project/compare/{base}...{head}","merges_url":"https://api.github.com/repos/banafshehderayat/304project/merges","archive_url":"https://api.github.com/repos/banafshehderayat/304project/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/banafshehderayat/304project/downloads","issues_url":"https://api.github.com/repos/banafshehderayat/304project/issues{/number}","pulls_url":"https://api.github.com/repos/banafshehderayat/304project/pulls{/number}","milestones_url":"https://api.github.com/repos/banafshehderayat/304project/milestones{/number}","notifications_url":"https://api.github.com/repos/banafshehderayat/304project/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/banafshehderayat/304project/labels{/name}","releases_url":"https://api.github.com/repos/banafshehderayat/304project/releases{/id}","deployments_url":"https://api.github.com/repos/banafshehderayat/304project/deployments","created_at":"2016-03-07T17:34:48Z","updated_at":"2016-03-13T01:07:59Z","pushed_at":"2016-03-31T21:14:01Z","git_url":"git://github.com/banafshehderayat/304project.git","ssh_url":"git@github.com:banafshehderayat/304project.git","clone_url":"https://github.com/banafshehderayat/304project.git","svn_url":"https://github.com/banafshehderayat/304project","homepage":null,"size":56,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"base":{"label":"banafshehderayat:master","ref":"master","sha":"1c8871058333a5c5f128ac67290e3850ba9941e6","user":{"login":"banafshehderayat","id":10871727,"avatar_url":"https://avatars.githubusercontent.com/u/10871727?v=3","gravatar_id":"","url":"https://api.github.com/users/banafshehderayat","html_url":"https://github.com/banafshehderayat","followers_url":"https://api.github.com/users/banafshehderayat/followers","following_url":"https://api.github.com/users/banafshehderayat/following{/other_user}","gists_url":"https://api.github.com/users/banafshehderayat/gists{/gist_id}","starred_url":"https://api.github.com/users/banafshehderayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/banafshehderayat/subscriptions","organizations_url":"https://api.github.com/users/banafshehderayat/orgs","repos_url":"https://api.github.com/users/banafshehderayat/repos","events_url":"https://api.github.com/users/banafshehderayat/events{/privacy}","received_events_url":"https://api.github.com/users/banafshehderayat/received_events","type":"User","site_admin":false},"repo":{"id":53345223,"name":"304project","full_name":"banafshehderayat/304project","owner":{"login":"banafshehderayat","id":10871727,"avatar_url":"https://avatars.githubusercontent.com/u/10871727?v=3","gravatar_id":"","url":"https://api.github.com/users/banafshehderayat","html_url":"https://github.com/banafshehderayat","followers_url":"https://api.github.com/users/banafshehderayat/followers","following_url":"https://api.github.com/users/banafshehderayat/following{/other_user}","gists_url":"https://api.github.com/users/banafshehderayat/gists{/gist_id}","starred_url":"https://api.github.com/users/banafshehderayat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/banafshehderayat/subscriptions","organizations_url":"https://api.github.com/users/banafshehderayat/orgs","repos_url":"https://api.github.com/users/banafshehderayat/repos","events_url":"https://api.github.com/users/banafshehderayat/events{/privacy}","received_events_url":"https://api.github.com/users/banafshehderayat/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/banafshehderayat/304project","description":"","fork":false,"url":"https://api.github.com/repos/banafshehderayat/304project","forks_url":"https://api.github.com/repos/banafshehderayat/304project/forks","keys_url":"https://api.github.com/repos/banafshehderayat/304project/keys{/key_id}","collaborators_url":"https://api.github.com/repos/banafshehderayat/304project/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/banafshehderayat/304project/teams","hooks_url":"https://api.github.com/repos/banafshehderayat/304project/hooks","issue_events_url":"https://api.github.com/repos/banafshehderayat/304project/issues/events{/number}","events_url":"https://api.github.com/repos/banafshehderayat/304project/events","assignees_url":"https://api.github.com/repos/banafshehderayat/304project/assignees{/user}","branches_url":"https://api.github.com/repos/banafshehderayat/304project/branches{/branch}","tags_url":"https://api.github.com/repos/banafshehderayat/304project/tags","blobs_url":"https://api.github.com/repos/banafshehderayat/304project/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/banafshehderayat/304project/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/banafshehderayat/304project/git/refs{/sha}","trees_url":"https://api.github.com/repos/banafshehderayat/304project/git/trees{/sha}","statuses_url":"https://api.github.com/repos/banafshehderayat/304project/statuses/{sha}","languages_url":"https://api.github.com/repos/banafshehderayat/304project/languages","stargazers_url":"https://api.github.com/repos/banafshehderayat/304project/stargazers","contributors_url":"https://api.github.com/repos/banafshehderayat/304project/contributors","subscribers_url":"https://api.github.com/repos/banafshehderayat/304project/subscribers","subscription_url":"https://api.github.com/repos/banafshehderayat/304project/subscription","commits_url":"https://api.github.com/repos/banafshehderayat/304project/commits{/sha}","git_commits_url":"https://api.github.com/repos/banafshehderayat/304project/git/commits{/sha}","comments_url":"https://api.github.com/repos/banafshehderayat/304project/comments{/number}","issue_comment_url":"https://api.github.com/repos/banafshehderayat/304project/issues/comments{/number}","contents_url":"https://api.github.com/repos/banafshehderayat/304project/contents/{+path}","compare_url":"https://api.github.com/repos/banafshehderayat/304project/compare/{base}...{head}","merges_url":"https://api.github.com/repos/banafshehderayat/304project/merges","archive_url":"https://api.github.com/repos/banafshehderayat/304project/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/banafshehderayat/304project/downloads","issues_url":"https://api.github.com/repos/banafshehderayat/304project/issues{/number}","pulls_url":"https://api.github.com/repos/banafshehderayat/304project/pulls{/number}","milestones_url":"https://api.github.com/repos/banafshehderayat/304project/milestones{/number}","notifications_url":"https://api.github.com/repos/banafshehderayat/304project/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/banafshehderayat/304project/labels{/name}","releases_url":"https://api.github.com/repos/banafshehderayat/304project/releases{/id}","deployments_url":"https://api.github.com/repos/banafshehderayat/304project/deployments","created_at":"2016-03-07T17:34:48Z","updated_at":"2016-03-13T01:07:59Z","pushed_at":"2016-03-31T21:14:01Z","git_url":"git://github.com/banafshehderayat/304project.git","ssh_url":"git@github.com:banafshehderayat/304project.git","clone_url":"https://github.com/banafshehderayat/304project.git","svn_url":"https://github.com/banafshehderayat/304project","homepage":null,"size":56,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/banafshehderayat/304project/pulls/7"},"html":{"href":"https://github.com/banafshehderayat/304project/pull/7"},"issue":{"href":"https://api.github.com/repos/banafshehderayat/304project/issues/7"},"comments":{"href":"https://api.github.com/repos/banafshehderayat/304project/issues/7/comments"},"review_comments":{"href":"https://api.github.com/repos/banafshehderayat/304project/pulls/7/comments"},"review_comment":{"href":"https://api.github.com/repos/banafshehderayat/304project/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/banafshehderayat/304project/pulls/7/commits"},"statuses":{"href":"https://api.github.com/repos/banafshehderayat/304project/statuses/da8acdeda3f8217d2e2c37da62c19f332dadb2c8"}}}}