monir
monir
Offline
0
Hello There!
I want "total order value" for the month to be shown before the commission column and after the conversions. I tried to copy the code but haven't succeed. If you kindly give me the query code for the total value to be shown in conversion page.

Thank you very much.

Monir
Responses (10)
  • Accepted Answer

    Wednesday, December 10 2014, 04:49 PM - #Permalink
    0
    can you make a screenshot of the page you mean and indicate what you need in there?
    The reply is currently minimized Show
  • Accepted Answer

    monir
    monir
    Offline
    Thursday, December 11 2014, 04:31 AM - #Permalink
    0
    Hi!
    I have added the screenshot, in the middle column (I have circled with green marker) there should be total order value (sales volume). This value normally appear bottom of the page.

    Thank you very much.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 11 2014, 11:30 AM - #Permalink
    0
    ok I understand.

    well, for this you need a few code changes in a few files.. is not that easy.
    you need the new MySQL query, which is one part, but then you need also to create the new functions that gather that info and pass it to the view element to be rendered...
    The reply is currently minimized Show
  • Accepted Answer

    monir
    monir
    Offline
    Thursday, December 11 2014, 11:43 AM - #Permalink
    0
    The MySQL query is there at the bottom of the page. As shown in the screenshot. I just need that little bit code for the circled value in the screenshot. I can edit the file to put that value by the commission as I want it.

    Thank you
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, December 11 2014, 11:45 AM - #Permalink
    0
    No, that doesn't come from a direct MySQL query, but a simple summatory of the values on the page, directly calculated on the layout page.

    in any case, this is the layout page you're looking for:

    /components/com_affiliatetracker/views/conversions/tmpl/default.php

    this is where the info is printed
    The reply is currently minimized Show
  • Accepted Answer

    monir
    monir
    Offline
    Thursday, December 11 2014, 12:20 PM - #Permalink
    0
    I have the found the following code and I have added the middle section of the code. But it is not appearing the value but zero. Kindly see this please



    conversions; ?>



    timespan.'_DAYS'); ?>




    _total); ?>



    timespan.'_DAYS'); ?>




    comission_value); ?>



    timespan.'_DAYS'); ?>

    The reply is currently minimized Show
  • Accepted Answer

    monir
    monir
    Offline
    Friday, December 12 2014, 01:11 AM - #Permalink
    0

    conversions; ?>



    timespan.'_DAYS'); ?>




    _total); ?>



    timespan.'_DAYS'); ?>




    comission_value); ?>



    timespan.'_DAYS'); ?>

    The reply is currently minimized Show
  • Accepted Answer

    Friday, December 12 2014, 10:36 AM - #Permalink
    0
    hello,

    yes, because "$this->_total" does not exist anywhere, you just made this variable up..

    it's what I've been telling you from the beginning, to get this value it needs to be obtained using functions on a couple files... it's not a big thing but you definitely need developer skills and know what you're doing to be able to show this.
    The reply is currently minimized Show
  • Accepted Answer

    monir
    monir
    Offline
    Friday, December 12 2014, 11:47 AM - #Permalink
    0
    Hi! How found that code in other files. I think i could give me some instructions. I would be really so thankful to you.

    Best regards
    The reply is currently minimized Show
  • Accepted Answer

    Friday, December 12 2014, 12:47 PM - #Permalink
    0
    the most important file is /components/com_affiliatetracker/models/conversions.php

    there is where you will find the other functions that gather information and you can create your own for the "total". then in:
    /components/com_affiliatetracker/views/conversions/view.html.php is where you can call the function, to push the data into the template.
    The reply is currently minimized Show
  • Your Reply