*

Ivanko

  • *****
  • 391 posts
[DASHBOARD STATISTISC] in user menu
« on: March 05, 2017, 11:16:13 PM »
Is this nice future working .....???

*

MB Themes

  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

Marked as best answer by frosticek on March 06, 2017, 05:14:35 PM
*

Ivanko

  • *****
  • 391 posts
Re: [DASHBOARD STATISTISC] in user menu
« Reply #2 on: March 06, 2017, 12:30:44 PM »
Yeah, phone clicks are fixed, but please check query in user-dashboard.php :

Code: [Select]
$query = "SELECT (year(s.dt_date)*100 + month(s.dt_date)) as yearmonth, sum(s.i_num_views) as views, sum(s.i_num_premium_views) as premium_views, sum(coalesce(e.i_num_phone_clicks, 0)) as phone_clicks
FROM {$db_prefix}t_item_stats s
INNER JOIN {$db_prefix}t_item i ON s.fk_i_item_id = i.pk_i_id
LEFT OUTER JOIN {$db_prefix}t_item_stats e
ON (s.fk_i_item_id = e.fk_i_item_id AND s.dt_date = e.dt_date)
WHERE i.fk_i_user_id = " . osc_user_id() . "
AND year(s.dt_date) >= " . $limit_year . "
AND month(s.dt_date) >= " . $limit_month . "
GROUP BY (year(s.dt_date)*100 + month(s.dt_date))
ORDER BY (year(s.dt_date)*100 + month(s.dt_date)) asc;";

replace with:

Code: [Select]
$query = "SELECT (year(s.dt_date)*100 + month(s.dt_date)) as yearmonth, sum(s.i_num_views) as views, sum(s.i_num_premium_views) as premium_views, sum(coalesce(e.i_num_phone_clicks, 0)) as phone_clicks
FROM {$db_prefix}t_item_stats s
INNER JOIN {$db_prefix}t_item i ON s.fk_i_item_id = i.pk_i_id
LEFT OUTER JOIN {$db_prefix}t_item_stats_veronika e
ON (s.fk_i_item_id = e.fk_i_item_id AND s.dt_date = e.dt_date)
WHERE i.fk_i_user_id = " . osc_user_id() . "
AND year(s.dt_date) >= " . $limit_year . "
AND month(s.dt_date) >= " . $limit_month . "
GROUP BY (year(s.dt_date)*100 + month(s.dt_date))
ORDER BY (year(s.dt_date)*100 + month(s.dt_date)) asc;";


For me Chart is showing properly...

*

MB Themes

Re: [DASHBOARD STATISTISC] in user menu
« Reply #3 on: March 06, 2017, 01:09:44 PM »
@Ivanko,
Thanks, you are right, but it only fix showing of click counts (if you have problems with others as well).
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Ivanko

  • *****
  • 391 posts
Re: [DASHBOARD STATISTISC] in user menu
« Reply #4 on: March 06, 2017, 01:25:18 PM »
No, No, all staff are showing properly now:
premium, normal, clicks....  :)
« Last Edit: March 06, 2017, 03:03:30 PM by Ivanko »