{"action":"created","issue":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/1297","repository_url":"https://api.github.com/repos/kbower/tickettest1","labels_url":"https://api.github.com/repos/kbower/tickettest1/issues/1297/labels{/name}","comments_url":"https://api.github.com/repos/kbower/tickettest1/issues/1297/comments","events_url":"https://api.github.com/repos/kbower/tickettest1/issues/1297/events","html_url":"https://github.com/kbower/tickettest1/issues/1297","id":196564172,"number":1297,"title":"Inventory screen efficiency","user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"labels":[{"id":502425680,"url":"https://api.github.com/repos/kbower/tickettest1/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"closed","locked":false,"assignee":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"assignees":[{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-12-20T01:35:30Z","updated_at":"2016-12-20T01:35:31Z","closed_at":"2016-12-20T01:35:31Z","body":"_Imported from trac ticket 1297.\nCreated by **kbower**\nOpened in trac: Dec 16, 2011, 5:25:07 PM\nLast modified in trac: Dec 19, 2011, 10:08:56 AM_\n***\nSee also #1296. \n\nget_inventory should load all inventory at once like get_pos and getopenorders instead of looping through database round trips.\n"},"comment":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/comments/268129175","html_url":"https://github.com/kbower/tickettest1/issues/1297#issuecomment-268129175","issue_url":"https://api.github.com/repos/kbower/tickettest1/issues/1297","id":268129175,"user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"created_at":"2016-12-20T01:35:30Z","updated_at":"2016-12-20T01:35:30Z","body":"_**kbower** trac comment on Dec 19, 2011, 10:08:56 AM:_\n\n(Changeset [[2078]](../commit/2a6a35bab72db6906ce4013c1de9425a4a32d4cc))\n * Product Inventory screen \n   * do not query package components for products that aren't packages (service request nor database trip) (fixes #1296)\n   * fix inefficient data loading (fixes #1297)\n     * do not loop over products for inventory\n     * do not loop over orderdetails for order comments\n     * do not loop over purchaseorderdetails for comments\n   * fix [#1298](1298) (Open Orders tab for inventory does incorrect join and never returns for more popular products)\n   * fix [#1299](1299) (Product Purchase Orders tab needs to report qtyremaining instead of qtyordered)\n   * provide default orderby for each tab\n   * refactor so product inventory http requests aren't duplicated\n \n"}}
{"actor":{"display_login":"kbower"}}