[Skip to main content](#vessel-content) # Date of a period not saved at table reports ## - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago [\#68056](#68056) by [Remko](/forum/user/7328-remko "View Remko's Profile") *[Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68056 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* was created by *[Remko](/forum/user/7328-remko "View Remko's Profile")* Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema [ www.edsmusic.nl](http://www.edsmusic.nl) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 1 month ago [\#68162](#68162) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68162 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* Hi, Please do a screenshot of your report option screen so that we can see what you did. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago [\#68355](#68355) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68355 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* I have made a video which shows the problem. When you watch it at full screen in HD it must be clear.... I hope... ![B)](/media/kunena/emoticons/9.png "B)") Link to video: [ www.youtube.com/watch?v=RZuVTmEISyE](http://www.youtube.com/watch?v=RZuVTmEISyE) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 14 years 4 weeks ago [\#68605](#68605) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Re: Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68605 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* Hi Remko, Indeed, it seems we had an issue there ![:)](/media/kunena/emoticons/3.png ":)") Please find attached a fixed version of the widget.php file and replace the old one with this one in administrator\components\com_hikashop\classes. This will solve the value and date problem. You'll also found a view.html.php file which has to be put in administrator\components\com_hikashop\views\report. it will solve the problem of different display on the dashboard and edit page. About the last message you have, I've never seen this before so if the fix doesn't change anything please PM me an access to your backend. #### Attachment not found Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 4 weeks ago [\#68649](#68649) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68649 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* Hi Eliot, The date problem is fixed! ![:)](/media/kunena/emoticons/3.png ":)") Thanks! Now it's possible for me to notice the next problem ![:(](/media/kunena/emoticons/22.png ":(") . I want to view the total amount of the sales per 3 months. When I take the sum of all orders in month 7, 8 and 9. The widget shows an other amount then the amount calculated bij myself. Even when I do not use any filters, there is a difference. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 4 weeks ago - 14 years 4 weeks ago [\#68653](#68653) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68653 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* Ah... I think I know which amount is displayed. It comes close to the sum the total order amount excl. shipping and excl. tax in the selected period. Is it possible to view the total order amount incl. tax and shipping? I also like to view the total amount of tax (of products, shipping, payment). So I can split the total incl. and excl. tax for a selected period. Another thing is that everytime I edit a report, the report switches activate to "NO". After I changed something I have to activate the report again. Last edit: 14 years 4 weeks ago by [Remko](/forum/user/7328-remko "View Remko's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 4 weeks ago - 14 years 4 weeks ago [\#68817](#68817) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Date of a period not saved at table reports](/forum/3-bug-report/68056-date-of-a-period-not-saved-at-table-reports#68817 "Hi, I like to view all the sales per 3 months. When I select the start date 2012-07-01 00:00 and end date 2012-10-01 00:00 and save the row it displays € 0,00, but I know that I've sold a lot more. When I edit that certain row, I see that the dates are changed to 1970-01-01 01:33. When I choose for the option "This Year", there is an amount displayed, but when I calculate all orders manually, the amount differs form the automatic calculated amount. (maybe it also adds the deleted orders, which are not displayed anymore). Also in the edit screen for the report an other amount is displayed than at the dashboard. I hope this can be solved. Kind Regards, Remko Rijpkema www.edsmusic.nl")* In that widget.php file, can you try to change the line: $theSum='prod.order_product_price*prod.order_product_quantity'; to: $theSum='a.order_full_price'; and remove the line: $leftjoin[] = ' LEFT JOIN '.hikashop_table('order_product').' AS prod ON a.order_id=prod.order_id '; That should allow it to use the full total for the widget. For the total without tax, there is also no option for it and the modification is a bit more complex. Maybe by replacing the line: $theSum='prod.order_product_price*prod.order_product_quantity'; by: $theSum='a.order_full_price-a.order_shipping_tax-(select sum(prod.order_product_tax*prod.order_product_quantity) from '.hikashop_get('order.product').' as prod where prod.order_id=prod.order_id)'; and removing the line: $leftjoin[] = ' LEFT JOIN '.hikashop_table('order_product').' AS prod ON a.order_id=prod.order_id '; I think that the best would be to have a new option to select which type of calculation would be used in a future version of HikaShop. I'll let Eliot look at the publishing issue when he will be back, next week as it's not a pressing issue. Last edit: 14 years 4 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82ODA1Ni1kYXRlLW9mLWEtcGVyaW9kLW5vdC1zYXZlZC1hdC10YWJsZS1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.168 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)