Monthly Sales and Tax Summary Report [support thread]

[bonheddwr]

I've just installed this plugin. Thanks to all who have worked on it. What I would like to do is see sales via country. From what I read, this plugin should do that, but in the list (view image) what I get is towns / counties / states etc and not countries. Is it possible to view sales via country with this plugin?

[sammirah]

I've just installed this plugin. Thanks to all who have worked on it. What I would like to do is see sales via country. From what I read, this plugin should do that, but in the list (view image) what I get is towns / counties / states etc and not countries. Is it possible to view sales via country with this plugin?

It actually only shows places; towns, cities, countries, ect. from which you have had sales in the past.

[dbltoe]

I understand the consensus against bumps BUT, I have PMed Melanie requesting any possible solution to the problem initiated in post #140.

I did not request a personal answer but hoped for something in this thread.

Apparently, the signature is law and no answer provided for a PM even if referencing the thread.

Perhaps a glimmer of hope can be provided with this bump.

[swguy]

Just hire her. I'm sure she'll be glad to take your paid professional engagement. Easy peasy!

[dbltoe]

Okay, I'm going to bring this here as I've worn out the trifocals looking at this thing. I've attached the whole file but, I'll address two areas of YOUR_ADMIN/stats_monthly_sales.php here for brevity.

As previously stated and verified, the code at lines 126 thru 138 incorrectly identify o.delivery_state in that this causes the code to look in the wrong table when accessing mysql.

    //Zone Only SQL appendage    $zone_only_sql = '';
    $zone_selected = false;
    if ($_POST['zone_only'] != '' && !in_array('all', $_POST['zone_only'])) {
        $get_zone_only = $_POST['zone_only'];
        $zone_selected = true;
        $zoned_sql = '';
        foreach ($get_zone_only as $selectedZone) {
            $zoned_sql .= "o.delivery_state LIKE '" . $selectedZone . "' OR ";
        }
        $zoned_sql = rtrim($zoned_sql, "OR ");
        $zone_only_sql = " AND (" . $zoned_sql . ") ";
    }

The $zone_only_sql is used on lines 164, 292, 476, 560, 572, 583, 593, 605, and 617 to formulate different presentations.
Apparently, most of those occurrences work just fine. It's only when selecting a particular state, city, or country that the unfound delivery_state breaks the operation.

I know what information I need (delivery_state) and I know which table it needs to come from (orders) but I can't figure out how to change "o.delivery_state LIKE '" to get the info from the correct table.

Here's an opportunity to teach me to fish beyond just baiting the hook and throwing it in the water.

THANX for any assistance.

PS for anyone wanting to go the extra mile, it would be nice to sort by country as well

[mprough]

I understand the consensus against bumps BUT, I have PMed Melanie requesting any possible solution to the problem initiated in post #140.

I did not request a personal answer but hoped for something in this thread.

Apparently, the signature is law and no answer provided for a PM even if referencing the thread.

Perhaps a glimmer of hope can be provided with this bump.

I do not answer PMs for module issues, I really can't manage them. I used to, but no more. It's not my module, I've updated it a few times =) I did research your issue a bit since I stumbled on to this as you called me out.... What version of PHP? Zen Cart 1.5.4 correct? I do not have any logging error on Zen Cart 1.5.4 & PHP 5.6.40 & MySQL 5.5.5-10.1.41-MariaDB.

[dbltoe]

I should apologize for the bump and call out. As I look back through I find that, although you updated the mod twice since 2014, you have never made a post in the support thread. Therefore, my assumption (I know) that you had to be subscribed and receiving notices was totally incorrect.

The information mentioned in post #178 is the main problem. It is doing the same in 1.5.5f with PHP 5.6 and MySQL 5.7 as it did in 1.5.4. Naturally, I have not loaded it on 1.5.6#.

If you don't have a problem with your version, did you see drbyte's comment in 143

There's no 'delivery_state' field in the orders_status table in any version of Zen Cart, so this isn't a v1.5.4 issue.
Looks more like a failed/not-completed SQL schema change during installation of the related addon.

I cannot find any instance of this field in previous or later versions of Zen Cart. Therefore, I thought you might have had some mod connected with it that needed an extra field. Was just grasping at straws as this would be perfect for our site if...

Again, as stated in #178, I know what we need. Just not how to get it into the mix.

[mprough]

I don't have a SQL 5.7 environment to solve this right now