{"action":"created","comment":{"url":"https://api.github.com/repos/danliris/dl-module/pulls/comments/150747063","pull_request_review_id":76341303,"id":150747063,"diff_hunk":"@@ -141,19 +149,19 @@ module.exports = class FactDealTrackingDealEtlManager extends BaseManager {\n \n                         var command = [];\n \n-                        var sqlQuery = 'INSERT INTO [DL_Fact_Deal_Tracking_Deal_Temp](deleted, id, code, createdDate, createdBy, name, amount, companyCode, companyName, contactCode, contactName, closeDate, description, reason, companyCity) ';\n+                        var sqlQuery = 'INSERT INTO [DL_Fact_Deal_Tracking_Deal_Temp](deleted, id, code, createdDate, createdBy, name, amount, companyCode, companyName, contactCode, contactName, closeDate, description, reason, companyCity, productCode, productName, quantity, UOM) ';\n                         \n                         var count = 1;\n                         for (var item of data) {\n                             if (item) {\n-                                var values = `${item.deleted}, ${item.id}, ${item.code}, ${item.createdDate}, ${item.createdBy}, ${item.name}, ${item.amount}, ${item.companyCode}, ${item.companyName}, ${item.contactCode}, ${item.contactName}, ${item.closeDate}, ${item.description}, ${item.reason}, ${item.companyCity}`;\n+                                var values = `${item.deleted}, ${item.id}, ${item.code}, ${item.createdDate}, ${item.createdBy}, ${item.name}, ${item.amount}, ${item.companyCode}, ${item.companyName}, ${item.contactCode}, ${item.contactName}, ${item.closeDate}, ${item.description}, ${item.reason}, ${item.companyCity}, ${item.productCode}, ${item.productName}, ${item.quantity}, ${item.uom}`;","path":"src/etl/sales/fact-deal-tracking-deal-etl-manager.js","position":37,"original_position":37,"commit_id":"21f0ac69f41ab374cb6d3febae2375110213e90f","original_commit_id":"21f0ac69f41ab374cb6d3febae2375110213e90f","user":{"login":"houndci-bot","id":6697940,"avatar_url":"https://avatars0.githubusercontent.com/u/6697940?v=4","gravatar_id":"","url":"https://api.github.com/users/houndci-bot","html_url":"https://github.com/houndci-bot","followers_url":"https://api.github.com/users/houndci-bot/followers","following_url":"https://api.github.com/users/houndci-bot/following{/other_user}","gists_url":"https://api.github.com/users/houndci-bot/gists{/gist_id}","starred_url":"https://api.github.com/users/houndci-bot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/houndci-bot/subscriptions","organizations_url":"https://api.github.com/users/houndci-bot/orgs","repos_url":"https://api.github.com/users/houndci-bot/repos","events_url":"https://api.github.com/users/houndci-bot/events{/privacy}","received_events_url":"https://api.github.com/users/houndci-bot/received_events","type":"User","site_admin":false},"body":"'template literal syntax' is only available in ES6 (use 'esversion: 6').","created_at":"2017-11-14T06:29:18Z","updated_at":"2017-11-14T06:29:19Z","html_url":"https://github.com/danliris/dl-module/pull/1287#discussion_r150747063","pull_request_url":"https://api.github.com/repos/danliris/dl-module/pulls/1287","author_association":"NONE","_links":{"self":{"href":"https://api.github.com/repos/danliris/dl-module/pulls/comments/150747063"},"html":{"href":"https://github.com/danliris/dl-module/pull/1287#discussion_r150747063"},"pull_request":{"href":"https://api.github.com/repos/danliris/dl-module/pulls/1287"}}},"pull_request":{"url":"https://api.github.com/repos/danliris/dl-module/pulls/1287","id":152422846,"html_url":"https://github.com/danliris/dl-module/pull/1287","diff_url":"https://github.com/danliris/dl-module/pull/1287.diff","patch_url":"https://github.com/danliris/dl-module/pull/1287.patch","issue_url":"https://api.github.com/repos/danliris/dl-module/issues/1287","number":1287,"state":"open","locked":false,"title":"Merge Dev ke UAT 14 Nov 2017","user":{"login":"danliris","id":20855729,"avatar_url":"https://avatars0.githubusercontent.com/u/20855729?v=4","gravatar_id":"","url":"https://api.github.com/users/danliris","html_url":"https://github.com/danliris","followers_url":"https://api.github.com/users/danliris/followers","following_url":"https://api.github.com/users/danliris/following{/other_user}","gists_url":"https://api.github.com/users/danliris/gists{/gist_id}","starred_url":"https://api.github.com/users/danliris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danliris/subscriptions","organizations_url":"https://api.github.com/users/danliris/orgs","repos_url":"https://api.github.com/users/danliris/repos","events_url":"https://api.github.com/users/danliris/events{/privacy}","received_events_url":"https://api.github.com/users/danliris/received_events","type":"User","site_admin":false},"body":"","created_at":"2017-11-14T06:29:13Z","updated_at":"2017-11-14T06:29:19Z","closed_at":null,"merged_at":null,"merge_commit_sha":"15ebbf48fafc2dd71ffc1745e5849fde926dd655","assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/danliris/dl-module/pulls/1287/commits","review_comments_url":"https://api.github.com/repos/danliris/dl-module/pulls/1287/comments","review_comment_url":"https://api.github.com/repos/danliris/dl-module/pulls/comments{/number}","comments_url":"https://api.github.com/repos/danliris/dl-module/issues/1287/comments","statuses_url":"https://api.github.com/repos/danliris/dl-module/statuses/21f0ac69f41ab374cb6d3febae2375110213e90f","head":{"label":"danliris:dev","ref":"dev","sha":"21f0ac69f41ab374cb6d3febae2375110213e90f","user":{"login":"danliris","id":20855729,"avatar_url":"https://avatars0.githubusercontent.com/u/20855729?v=4","gravatar_id":"","url":"https://api.github.com/users/danliris","html_url":"https://github.com/danliris","followers_url":"https://api.github.com/users/danliris/followers","following_url":"https://api.github.com/users/danliris/following{/other_user}","gists_url":"https://api.github.com/users/danliris/gists{/gist_id}","starred_url":"https://api.github.com/users/danliris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danliris/subscriptions","organizations_url":"https://api.github.com/users/danliris/orgs","repos_url":"https://api.github.com/users/danliris/repos","events_url":"https://api.github.com/users/danliris/events{/privacy}","received_events_url":"https://api.github.com/users/danliris/received_events","type":"User","site_admin":false},"repo":{"id":64628314,"name":"dl-module","full_name":"danliris/dl-module","owner":{"login":"danliris","id":20855729,"avatar_url":"https://avatars0.githubusercontent.com/u/20855729?v=4","gravatar_id":"","url":"https://api.github.com/users/danliris","html_url":"https://github.com/danliris","followers_url":"https://api.github.com/users/danliris/followers","following_url":"https://api.github.com/users/danliris/following{/other_user}","gists_url":"https://api.github.com/users/danliris/gists{/gist_id}","starred_url":"https://api.github.com/users/danliris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danliris/subscriptions","organizations_url":"https://api.github.com/users/danliris/orgs","repos_url":"https://api.github.com/users/danliris/repos","events_url":"https://api.github.com/users/danliris/events{/privacy}","received_events_url":"https://api.github.com/users/danliris/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/danliris/dl-module","description":"Dan Liris Modules","fork":false,"url":"https://api.github.com/repos/danliris/dl-module","forks_url":"https://api.github.com/repos/danliris/dl-module/forks","keys_url":"https://api.github.com/repos/danliris/dl-module/keys{/key_id}","collaborators_url":"https://api.github.com/repos/danliris/dl-module/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/danliris/dl-module/teams","hooks_url":"https://api.github.com/repos/danliris/dl-module/hooks","issue_events_url":"https://api.github.com/repos/danliris/dl-module/issues/events{/number}","events_url":"https://api.github.com/repos/danliris/dl-module/events","assignees_url":"https://api.github.com/repos/danliris/dl-module/assignees{/user}","branches_url":"https://api.github.com/repos/danliris/dl-module/branches{/branch}","tags_url":"https://api.github.com/repos/danliris/dl-module/tags","blobs_url":"https://api.github.com/repos/danliris/dl-module/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/danliris/dl-module/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/danliris/dl-module/git/refs{/sha}","trees_url":"https://api.github.com/repos/danliris/dl-module/git/trees{/sha}","statuses_url":"https://api.github.com/repos/danliris/dl-module/statuses/{sha}","languages_url":"https://api.github.com/repos/danliris/dl-module/languages","stargazers_url":"https://api.github.com/repos/danliris/dl-module/stargazers","contributors_url":"https://api.github.com/repos/danliris/dl-module/contributors","subscribers_url":"https://api.github.com/repos/danliris/dl-module/subscribers","subscription_url":"https://api.github.com/repos/danliris/dl-module/subscription","commits_url":"https://api.github.com/repos/danliris/dl-module/commits{/sha}","git_commits_url":"https://api.github.com/repos/danliris/dl-module/git/commits{/sha}","comments_url":"https://api.github.com/repos/danliris/dl-module/comments{/number}","issue_comment_url":"https://api.github.com/repos/danliris/dl-module/issues/comments{/number}","contents_url":"https://api.github.com/repos/danliris/dl-module/contents/{+path}","compare_url":"https://api.github.com/repos/danliris/dl-module/compare/{base}...{head}","merges_url":"https://api.github.com/repos/danliris/dl-module/merges","archive_url":"https://api.github.com/repos/danliris/dl-module/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/danliris/dl-module/downloads","issues_url":"https://api.github.com/repos/danliris/dl-module/issues{/number}","pulls_url":"https://api.github.com/repos/danliris/dl-module/pulls{/number}","milestones_url":"https://api.github.com/repos/danliris/dl-module/milestones{/number}","notifications_url":"https://api.github.com/repos/danliris/dl-module/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/danliris/dl-module/labels{/name}","releases_url":"https://api.github.com/repos/danliris/dl-module/releases{/id}","deployments_url":"https://api.github.com/repos/danliris/dl-module/deployments","created_at":"2016-08-01T02:15:05Z","updated_at":"2016-08-08T03:27:08Z","pushed_at":"2017-11-14T06:29:13Z","git_url":"git://github.com/danliris/dl-module.git","ssh_url":"git@github.com:danliris/dl-module.git","clone_url":"https://github.com/danliris/dl-module.git","svn_url":"https://github.com/danliris/dl-module","homepage":null,"size":5543,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":28,"mirror_url":null,"archived":false,"open_issues_count":3,"forks":28,"open_issues":3,"watchers":0,"default_branch":"master"}},"base":{"label":"danliris:uat","ref":"uat","sha":"c1cfae1a3eebe842d6879d31461abae119578747","user":{"login":"danliris","id":20855729,"avatar_url":"https://avatars0.githubusercontent.com/u/20855729?v=4","gravatar_id":"","url":"https://api.github.com/users/danliris","html_url":"https://github.com/danliris","followers_url":"https://api.github.com/users/danliris/followers","following_url":"https://api.github.com/users/danliris/following{/other_user}","gists_url":"https://api.github.com/users/danliris/gists{/gist_id}","starred_url":"https://api.github.com/users/danliris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danliris/subscriptions","organizations_url":"https://api.github.com/users/danliris/orgs","repos_url":"https://api.github.com/users/danliris/repos","events_url":"https://api.github.com/users/danliris/events{/privacy}","received_events_url":"https://api.github.com/users/danliris/received_events","type":"User","site_admin":false},"repo":{"id":64628314,"name":"dl-module","full_name":"danliris/dl-module","owner":{"login":"danliris","id":20855729,"avatar_url":"https://avatars0.githubusercontent.com/u/20855729?v=4","gravatar_id":"","url":"https://api.github.com/users/danliris","html_url":"https://github.com/danliris","followers_url":"https://api.github.com/users/danliris/followers","following_url":"https://api.github.com/users/danliris/following{/other_user}","gists_url":"https://api.github.com/users/danliris/gists{/gist_id}","starred_url":"https://api.github.com/users/danliris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danliris/subscriptions","organizations_url":"https://api.github.com/users/danliris/orgs","repos_url":"https://api.github.com/users/danliris/repos","events_url":"https://api.github.com/users/danliris/events{/privacy}","received_events_url":"https://api.github.com/users/danliris/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/danliris/dl-module","description":"Dan Liris Modules","fork":false,"url":"https://api.github.com/repos/danliris/dl-module","forks_url":"https://api.github.com/repos/danliris/dl-module/forks","keys_url":"https://api.github.com/repos/danliris/dl-module/keys{/key_id}","collaborators_url":"https://api.github.com/repos/danliris/dl-module/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/danliris/dl-module/teams","hooks_url":"https://api.github.com/repos/danliris/dl-module/hooks","issue_events_url":"https://api.github.com/repos/danliris/dl-module/issues/events{/number}","events_url":"https://api.github.com/repos/danliris/dl-module/events","assignees_url":"https://api.github.com/repos/danliris/dl-module/assignees{/user}","branches_url":"https://api.github.com/repos/danliris/dl-module/branches{/branch}","tags_url":"https://api.github.com/repos/danliris/dl-module/tags","blobs_url":"https://api.github.com/repos/danliris/dl-module/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/danliris/dl-module/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/danliris/dl-module/git/refs{/sha}","trees_url":"https://api.github.com/repos/danliris/dl-module/git/trees{/sha}","statuses_url":"https://api.github.com/repos/danliris/dl-module/statuses/{sha}","languages_url":"https://api.github.com/repos/danliris/dl-module/languages","stargazers_url":"https://api.github.com/repos/danliris/dl-module/stargazers","contributors_url":"https://api.github.com/repos/danliris/dl-module/contributors","subscribers_url":"https://api.github.com/repos/danliris/dl-module/subscribers","subscription_url":"https://api.github.com/repos/danliris/dl-module/subscription","commits_url":"https://api.github.com/repos/danliris/dl-module/commits{/sha}","git_commits_url":"https://api.github.com/repos/danliris/dl-module/git/commits{/sha}","comments_url":"https://api.github.com/repos/danliris/dl-module/comments{/number}","issue_comment_url":"https://api.github.com/repos/danliris/dl-module/issues/comments{/number}","contents_url":"https://api.github.com/repos/danliris/dl-module/contents/{+path}","compare_url":"https://api.github.com/repos/danliris/dl-module/compare/{base}...{head}","merges_url":"https://api.github.com/repos/danliris/dl-module/merges","archive_url":"https://api.github.com/repos/danliris/dl-module/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/danliris/dl-module/downloads","issues_url":"https://api.github.com/repos/danliris/dl-module/issues{/number}","pulls_url":"https://api.github.com/repos/danliris/dl-module/pulls{/number}","milestones_url":"https://api.github.com/repos/danliris/dl-module/milestones{/number}","notifications_url":"https://api.github.com/repos/danliris/dl-module/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/danliris/dl-module/labels{/name}","releases_url":"https://api.github.com/repos/danliris/dl-module/releases{/id}","deployments_url":"https://api.github.com/repos/danliris/dl-module/deployments","created_at":"2016-08-01T02:15:05Z","updated_at":"2016-08-08T03:27:08Z","pushed_at":"2017-11-14T06:29:13Z","git_url":"git://github.com/danliris/dl-module.git","ssh_url":"git@github.com:danliris/dl-module.git","clone_url":"https://github.com/danliris/dl-module.git","svn_url":"https://github.com/danliris/dl-module","homepage":null,"size":5543,"stargazers_count":0,"watchers_count":0,"language":"JavaScript","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":28,"mirror_url":null,"archived":false,"open_issues_count":3,"forks":28,"open_issues":3,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/danliris/dl-module/pulls/1287"},"html":{"href":"https://github.com/danliris/dl-module/pull/1287"},"issue":{"href":"https://api.github.com/repos/danliris/dl-module/issues/1287"},"comments":{"href":"https://api.github.com/repos/danliris/dl-module/issues/1287/comments"},"review_comments":{"href":"https://api.github.com/repos/danliris/dl-module/pulls/1287/comments"},"review_comment":{"href":"https://api.github.com/repos/danliris/dl-module/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/danliris/dl-module/pulls/1287/commits"},"statuses":{"href":"https://api.github.com/repos/danliris/dl-module/statuses/21f0ac69f41ab374cb6d3febae2375110213e90f"}},"author_association":"OWNER"}}
{"actor":{"display_login":"houndci-bot"}}