{"action":"opened","issue":{"url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/issues/587","labels_url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/issues/587/labels{/name}","comments_url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/issues/587/comments","events_url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/issues/587/events","html_url":"https://github.com/johnpelquingua/freightbit-logistics/issues/587","id":78346123,"number":587,"title":"Statistics Report: CRS Total Number of Bookings per Consignee per Destination: All registered consignees were retrieved in report and some of the values have an improper label and arrangement.","user":{"login":"Leirum","id":9795882,"avatar_url":"https://avatars.githubusercontent.com/u/9795882?v=3","gravatar_id":"","url":"https://api.github.com/users/Leirum","html_url":"https://github.com/Leirum","followers_url":"https://api.github.com/users/Leirum/followers","following_url":"https://api.github.com/users/Leirum/following{/other_user}","gists_url":"https://api.github.com/users/Leirum/gists{/gist_id}","starred_url":"https://api.github.com/users/Leirum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Leirum/subscriptions","organizations_url":"https://api.github.com/users/Leirum/orgs","repos_url":"https://api.github.com/users/Leirum/repos","events_url":"https://api.github.com/users/Leirum/events{/privacy}","received_events_url":"https://api.github.com/users/Leirum/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/labels/Low","name":"Low","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/milestones/10","html_url":"https://github.com/johnpelquingua/freightbit-logistics/milestones/Report%20Module","labels_url":"https://api.github.com/repos/johnpelquingua/freightbit-logistics/milestones/10/labels","id":1074453,"number":10,"title":"Report Module","description":null,"creator":{"login":"Leirum","id":9795882,"avatar_url":"https://avatars.githubusercontent.com/u/9795882?v=3","gravatar_id":"","url":"https://api.github.com/users/Leirum","html_url":"https://github.com/Leirum","followers_url":"https://api.github.com/users/Leirum/followers","following_url":"https://api.github.com/users/Leirum/following{/other_user}","gists_url":"https://api.github.com/users/Leirum/gists{/gist_id}","starred_url":"https://api.github.com/users/Leirum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Leirum/subscriptions","organizations_url":"https://api.github.com/users/Leirum/orgs","repos_url":"https://api.github.com/users/Leirum/repos","events_url":"https://api.github.com/users/Leirum/events{/privacy}","received_events_url":"https://api.github.com/users/Leirum/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":4,"state":"open","created_at":"2015-04-20T02:56:14Z","updated_at":"2015-05-20T03:08:19Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-05-20T03:08:19Z","updated_at":"2015-05-20T03:08:19Z","closed_at":null,"body":"**Steps to replicate**\r\n1. Navigate to Reports Module.\r\n2. Select Customer Relations as Department.\r\n3. Select Statistics.\r\n4. Select Total Number of Bookings per Consignee per Destination as Data Result.\r\n5. Select January 1, 2015 as \"From\" date.\r\n6. Select the date today as \"To\" date.\r\n\r\n**Actual Result**\r\n- Attribute for consignee is labeled as customer\r\n- All registered consignees (even without assigned bookings) were retrieved in statistics report.\r\n- Destination were not properly arranged. Palawan and Ozamis have an exchanged position.\r\n\r\n![3 1](https://cloud.githubusercontent.com/assets/9795882/7718230/d2fac944-fedf-11e4-86c4-ea0e3d2ff7b2.png)\r\n\r\n![3](https://cloud.githubusercontent.com/assets/9795882/7718231/d4546188-fedf-11e4-8b86-3cef424e6d70.png)\r\n\r\n**Expected Result**\r\n- Customer should be labeled as Consignee.\r\n- Only the consignees with assigned bookings should be listed in statistics report.\r\n- Destination label should be alphabetically arranged.\r\n\r\n\r\n"}}