Skip to main content

Sales Report widget with a SUM capability

More
13 years 10 months ago #73965 by codewarrior
Sales Report widget with a SUM capability was created by codewarrior
Hi,
I would like to get the amount of all my sales. It's only possible to have the detailed list.

If there is not already a trick, is it possible to have a widget with a SUM capability ?
Regards

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #74133 by Eliot
Replied by Eliot on topic Re: Sales Report widget with a SUM capability
Hi there,

Referring to the documentation you can do this with the table widget.
Firest, create a new table widget and then add a new line with the sales for the period you wish.
It should do what you expect :)

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #75558 by codewarrior
Replied by codewarrior on topic Re: Sales Report widget with a SUM capability
Thanks Eliot,
it sounds good, but after creating a table widget, a pop-up is opening with a "Please configure your first row" message.
Whatever I configure, when I click on the OK button, the popup don't close and nothing is saved.
Do you have an idea ?
Regards

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #75817 by Eliot
Replied by Eliot on topic Re: Sales Report widget with a SUM capability
Sounds strange...
Did you try with another browser? If yes I'd be interested by an access to your backend to check if there is any javascript error or anything similar.
Try with Chrome or Firefox and PM me if it doesn't allow you to create your row.

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #75867 by codewarrior
Replied by codewarrior on topic Re: Sales Report widget with a SUM capability
Hi Eliot,
I use Firefox 16 (last version)
Nicolas has access to my Production backend. I'll sent it to you this evening if you can't have it.
Regards

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76086 by Eliot
Replied by Eliot on topic Re: Sales Report widget with a SUM capability
As you may have noticed, I fixed the popup bug on your website.
However it looks like you still have a problem since amounts are always empty. I'll try to take a look at this as soon as possible :)

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76206 by codewarrior
Replied by codewarrior on topic Re: Sales Report widget with a SUM capability
Thanks Eliot, I thougt I was crazy (working without any modification)
Could you tell me the modifications, even if I suppose that you will integrate them in the next versions, because I always fear upgrades.
Regards

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76308 by olivnewton
Replied by olivnewton on topic Sales Report widget with a SUM capability
same problem here guys. could you please tell me how to fix this?

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76607 by Eliot
Replied by Eliot on topic Sales Report widget with a SUM capability
It's a Javascript issue. Edit the tableform view and replace the code between the php tag by this one:
Code:
$access=""; $access2=""; if(hikashop_level(2)){ $access="access = parent.window.document.getElementById('widget_access').value;"; $access2="document.getElementById('access').value = access;"; } $jsOnClick=" var published = 1; name = parent.window.document.getElementById('name').value; publishedNo = parent.window.document.getElementById('data[widget][widget_published]0').value; ".$access." if(publishedNo){ published=0 } document.getElementById('name').value = name; document.getElementById('published').value = published;" . "".$access2." submitbutton('apply_table');";

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76681 by olivnewton
Replied by olivnewton on topic Sales Report widget with a SUM capability
hi eliot,
could you please be more precise?

i guess / hope you mean:
administrator/components/com_hikashop/views/report/tmpl/tableform.php

if yes, then what do you mean by "replace the code between the php tag"...? roughly at what line?

there are a lot of php tags, and none seems to be close to the code you suggested...
but then again, you might be talking about a different file.

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76684 by Eliot
Replied by Eliot on topic Sales Report widget with a SUM capability
My bad, I've been to quick on this point :)

You just have to go in Display>Views and look for the tableform file I'm talking about (it's in the dashboard view, be sure to edit the file of your template).
And the code you have to replace by this one is quite similar. It's at the begining of the file and looks like the one I gave you.
Just select everything inside these first tags and replace it. It should do the job :)
The following user(s) said Thank You: codewarrior, olivnewton

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76685 by olivnewton
Replied by olivnewton on topic Sales Report widget with a SUM capability
well, the last part of the first <php>-tags is similar, i will try that

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76687 by olivnewton
Replied by olivnewton on topic Sales Report widget with a SUM capability
ah! great! i will try that via display>views, thanks a lot

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76695 by olivnewton
Replied by olivnewton on topic Sales Report widget with a SUM capability
ok, i did that, but i still get the error. i guess i have to select the template i changed for the backend? cannot find where / how... any suggestion?

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #76701 by olivnewton
Replied by olivnewton on topic Sales Report widget with a SUM capability
got it! was a bit irritating to do this via hikashop>backend, because there it shows me also a backend template with the name of my custom site-template. so i thought i select that...
but i had to select "the global backend joomla template i am using"

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #77799 by codewarrior
Replied by codewarrior on topic Sales Report widget with a SUM capability
Eliot, to be more precise :
If you use backend template Bluestork, the file "tableform" is in "report" view.

Thanks for your help.
Regards

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #78146 by Eliot
Replied by Eliot on topic Sales Report widget with a SUM capability
You're right :)
About your problem, try to update to Hikashop 2.0, the SQL request are quite different and it may solve everything

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #81742 by codewarrior
Replied by codewarrior on topic Sales Report widget with a SUM capability
Eliot,
I updated to V2.0
Table widget is better, but :
- each time, I edit, it's still going unpublished,
- all rows values are 0,
- the delete icons are with no effect (Firefox 16 & IE9)
- the edit icon opens a popup with :
1) "New row" (for all rows) on the site where you've done modifications (I don't which ones)
2) the opposite row of the list, on another DEV site
- a click on the "Add" button of the table opens the 2nd item.

Please could you please definetly find a solution to that problem, before adding new options in newer versions.
Regards

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #82014 by Eliot
Replied by Eliot on topic Sales Report widget with a SUM capability
Hi there,

I'm sorry but don't have your FTP informations anymore... :blush:
Could send me a PM again so I take a look at it right now?

Thanks :)

Please Log in or Create an account to join the conversation.

More
13 years 9 months ago #83156 by codewarrior
Replied by codewarrior on topic Sales Report widget with a SUM capability
Hi Eliot,
I sent you a PM.
Did you had time to look at my problem ?
Thanks. Regards

Please Log in or Create an account to join the conversation.

Time to create page: 0.309 seconds
Powered by Kunena Forum