codeTrio Sales Summary Graph v1.0 [Support Thread]

[imranulh]

This is a simple plugin to show a sales summary of the overall sales of the store at a glance in the admin home page.

http://www.zen-cart.com/downloads.php?do=file&id=1580


.

[Limitless]

Installation was smooth, but seems like the calculations and dates are whacked.

Depending on which boxes are ticked, the 'sales numbers' are all over the place and even the default 'show 30 days' is actually a month off.

[imranulh]

Thank you for pointing it out Limitless.
Missed the date format, fixed it in v1.02

[Sharon J]

Hello,

I am using ZC 1.51 and PHP 5.3

I am getting error logs generated in /myadmin/ct_sales_summary.php (not my real admin directory name).

PHP Warning: implode(): Invalid arguments passed in /public_html/myadmin/ct_sales_summary.php on line 72

 $table_struct = "{cols:[{id:'date_purchased',label:'Date',type:'date'},
                             {id:'ot_total',label:'Sale',type:'number'}],
                       rows:[";
                       
     
        while(!$total_query->EOF){
       $year = date("Y", $total_query->fields['date_purchased']);
       $mon  = date("m", $total_query->fields['date_purchased']);
       $day  = date("d", $total_query->fields['date_purchased']);
       $date_display = (isset($monthly) && $monthly) ? date('F, Y', $total_query->fields['date_purchased']) : date('d F, Y', $total_query->fields['date_purchased']);
       $data_array[] = "{c:[{v:new Date($year,($mon-1),$day),f:'" . $date_display . "'},{v:" . $total_query->fields['total'] . ",f:'" . $currencies->format($total_query->fields['total']) . " (" . $total_query->fields['order_count'] . " orders)'}]}";
       $total_query->MoveNext();
     }
     
     $table_struct .= implode(',', $data_array);      (this is line 72 in my file)
     
     $table_struct .= "     ]
                       }"; 

From what I've read, if it is correct, this is because $data_array is not an array and needs to be defined as such. This may be the case, however I do not know how or exactly where in the code to do this.

Thank you so much,

Sharon

[imranulh]

Hi Sharon,

I have updated the add-on and submitted version 1.03.

It should fix the warning you got. I think you did not have any order in the selected time frame.

Thanks

[Louis]

Hi,

I just installed this plugin on ZC 1.5.3 and everything seemed to work well. Then I decided to select a status for filtering and the following errors were logged:

PHP Warning: mysql_real_escape_string(): Access denied for user 'xxxxxx' (using password: NO) in /home/xxxxxx/public_html/xxxxxx/xxxxxx/ct_sales_summary.php on line 43
PHP Warning: mysql_real_escape_string(): A link to the server could not be established in /home/xxxxxx/public_html/xxxxxx/xxxxxx/ct_sales_summary.php on line 43

Everything else does work and I can change the date range without any issue. The graph is displaying data and when you hover your cursor it provides you with the total amount and total orders for the day.

It is just the status filter that causes an error. Any ideas?

[Design75]

Hi,

I just installed this plugin on ZC 1.5.3 and everything seemed to work well. Then I decided to select a status for filtering and the following errors were logged:



Everything else does work and I can change the date range without any issue. The graph is displaying data and when you hover your cursor it provides you with the total amount and total orders for the day.

It is just the status filter that causes an error. Any ideas?

You should change line 43 of YOUR_ADMIN/ct_sales_summary.php
from:

   $status_query = empty($ordst) ? '' : ' and o.orders_status in (' . mysql_real_escape_string($ordst) . ')'; 

to:

   $status_query = empty($ordst) ? '' : ' and o.orders_status in (' . zen_db_prepare_input($ordst) . ')'; 

[lat9]

Zen Cart v1.5.3 uses the mysqli_ interface instead of the (deprecated in PHP 5.5.x) mysql_ functions.

The plugin that you installed is making direct mysql_* function calls instead of using the Zen Cart $db object (which makes the mysql -> mysqli transition "transparent" to the calling code).

[Louis]

Hi guys,

Thank you very much for your assistance. The graph is now fully functional in ZC 1.5.3

Thank you also for the explanation. It assisted me in resolving an issue I had with another unrelated plugin.

[jackie.taferner]

Thanks for this plugin, it is very useful! It's working great for Super Admin, but I'm unable to get it working for an Editor profile. I've tried enabling all of the checkboxes for that account, and it still doesn't work. The graph only appears when I switch that user the SuperAdmin. Any ideas? Thanks for your help!