{"action":"created","issue":{"url":"https://api.github.com/repos/magento/magento2/issues/16492","repository_url":"https://api.github.com/repos/magento/magento2","labels_url":"https://api.github.com/repos/magento/magento2/issues/16492/labels{/name}","comments_url":"https://api.github.com/repos/magento/magento2/issues/16492/comments","events_url":"https://api.github.com/repos/magento/magento2/issues/16492/events","html_url":"https://github.com/magento/magento2/pull/16492","id":337740482,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk4ODQ2MDYx","number":16492,"title":"Remove the timezone from the date when retrieving the current month from a UTC timestamp.","user":{"login":"michaelwylde","id":2224390,"node_id":"MDQ6VXNlcjIyMjQzOTA=","avatar_url":"https://avatars2.githubusercontent.com/u/2224390?v=4","gravatar_id":"","url":"https://api.github.com/users/michaelwylde","html_url":"https://github.com/michaelwylde","followers_url":"https://api.github.com/users/michaelwylde/followers","following_url":"https://api.github.com/users/michaelwylde/following{/other_user}","gists_url":"https://api.github.com/users/michaelwylde/gists{/gist_id}","starred_url":"https://api.github.com/users/michaelwylde/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaelwylde/subscriptions","organizations_url":"https://api.github.com/users/michaelwylde/orgs","repos_url":"https://api.github.com/users/michaelwylde/repos","events_url":"https://api.github.com/users/michaelwylde/events{/privacy}","received_events_url":"https://api.github.com/users/michaelwylde/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-03T04:20:32Z","updated_at":"2018-07-03T04:20:34Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/magento/magento2/pulls/16492","html_url":"https://github.com/magento/magento2/pull/16492","diff_url":"https://github.com/magento/magento2/pull/16492.diff","patch_url":"https://github.com/magento/magento2/pull/16492.patch"},"body":"Remove the timezone from the date when retrieving the current month from a UTC timestamp.\r\n\r\n### Description\r\nWhen viewing \"Ordered Products Report\" on a monthly basis, the date range used does not always include the last day of the month. The reason for this is because the method used to retrieve the number of days in a month converts the startDate of 2018-05-01 00:00:00 Australia/Adelaide \r\ninto a UTC timestamp which changes the month. Therefore the timestamp needs to be retrieved from a datetime that is in UTC with the correct month specified.\r\n\r\nThe proposed solution in issue #15940 of using cal_days_in_month will not always work if PHP is compiled without calendar support.\r\n\r\n### Fixed Issues\r\n1. magento/magento2#15940: Wrong end of month at Reports for Europe/Berlin time zone if month contains 31 day\r\n\r\n### Manual testing scenarios\r\nTesting scenario provided in issue was used. Copied here for simplicity:\r\n##Preconditions\r\n1. Set Timezone \"Central European Standard Time (Europe/Berlin)\" at the STORE->CONFIGURATION->GENERAL->General->Local options-> Timezone and save configuration\r\n2. Create orders at 31-st day of a month which has this date (May will be used for example)\r\n##Steps to reproduce\r\n1. Go to the Reports adminhtml menu \"Products\">\"Ordered\" grid\r\n2. Select \"From\" - 01.05.2018\r\n3. Select \"To\" - 31.05.2018\r\n4. Select \"Show by\" - Month\r\n5. Hit refresh\r\n##Expected result\r\nOrders that were created at 31.05.2018 are in the grid\r\n##Actual result\r\nOrders that were created at 31.05.2018 are NOT in the grid\r\n"},"comment":{"url":"https://api.github.com/repos/magento/magento2/issues/comments/402008867","html_url":"https://github.com/magento/magento2/pull/16492#issuecomment-402008867","issue_url":"https://api.github.com/repos/magento/magento2/issues/16492","id":402008867,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMjAwODg2Nw==","user":{"login":"magento-cicd2","id":14279950,"node_id":"MDQ6VXNlcjE0Mjc5OTUw","avatar_url":"https://avatars2.githubusercontent.com/u/14279950?v=4","gravatar_id":"","url":"https://api.github.com/users/magento-cicd2","html_url":"https://github.com/magento-cicd2","followers_url":"https://api.github.com/users/magento-cicd2/followers","following_url":"https://api.github.com/users/magento-cicd2/following{/other_user}","gists_url":"https://api.github.com/users/magento-cicd2/gists{/gist_id}","starred_url":"https://api.github.com/users/magento-cicd2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/magento-cicd2/subscriptions","organizations_url":"https://api.github.com/users/magento-cicd2/orgs","repos_url":"https://api.github.com/users/magento-cicd2/repos","events_url":"https://api.github.com/users/magento-cicd2/events{/privacy}","received_events_url":"https://api.github.com/users/magento-cicd2/received_events","type":"User","site_admin":false},"created_at":"2018-07-03T04:20:34Z","updated_at":"2018-07-03T04:20:34Z","author_association":"CONTRIBUTOR","body":"[![CLA assistant check](https://cla.dev.magento.com/pull/badge/not_signed)](https://cla.dev.magento.com/magento/magento2?pullRequest=16492) <br/>Thank you for your submission, we really appreciate it. Like many open source projects, we ask that you sign our [Contributor License Agreement](https://cla.dev.magento.com/magento/magento2?pullRequest=16492) before we can accept your contribution.<br/>"}}
{"actor":{"display_login":"magento-cicd2"}}