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?