codeTrio Sales Summary Graph v1.0 [Support Thread]

[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!

[Reesy]

Anyone still using this?
It seems that the display of the graph needs updating and it's causing errors.

[DrByte]

Anyone still using this?
It seems that the display of the graph needs updating and it's causing errors.

Google retired the jsapi that it was leveraging to display graphs.

If you're using 1.03 of the module, then in the graphs file:

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
//<=!=[=C=D=A=T=A=[
    google.load("jquery", "1");
//]=]=>
</script>

must be replaced with

<script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>
<script src="https://www.gstatic.com/charts/loader.js"></script>

and

 google.load('visualization', '1');
 google.setOnLoadCallback(drawVisualization);

must be replaced with

 google.charts.load('current', {packages: ['corechart']});
 google.charts.setOnLoadCallback(drawVisualization);