Visitors Statistics

[mahmoodee]

Hello,
I created experts profile directory by Fabrik .....list of experts profiles synchronized with joomla users component.
Companies can subscribe and visit experts profiles.
Is there a way in Fabrik to know the number of visits for each profile ,so I can sort list with most visited profiles or most popular ..etc ?
thank you

 

[cheesegrits]

There isn't a built in way, but you could probably do it with a PHP plugin, running onLoad, which updated a hit count in the table for that rowid.

-- hugh

 

[mahmoodee]

thank you
Is there a way to run when onload details view ? I want to update hit counter when click view details not onload list page.
any suggestion please .
thank you

 

[troester]

php form "onload" is running also in details view.
There's no option for "in form" or "in details" so you have to check the URL param if you don't want to count form access.

 

[mahmoodee]

thank you
I try the code in this post
http://fabrikar.com/forums/index.php?threads/detail-view-hit-counter.40372/

if (!$formModel->isEditable()) {
  $rowid = $formModel->getRowId();
  if (!empty($rowid)) {
    $db = FabrikWorker::getDbo();
    $query = $db->getQuery(true);
    $query->update('yourtable)->set('hitcount = COALESCE(hitcount,0) + 1')->where('id = ' . $rowid);
    $db->setQuery($query);
    $db->execute();
  }
}

but now when I click on view record it show blank deatils view

 

[mahmoodee]

It is working now , I missed ' after table name update('yourtable).
the hit counter now increase one every time I click time
How I can calculate only one hit for several clicks for session ?

 

[troester]

Change the table name and element name(s) in the query to match your table.

http://fabrikar.com/forums/index.php?wiki/reporting-bugs/#i-ve-got-a-whitescreen-what-next

 

[mahmoodee]

It is working now , I missed ' after table name update('yourtable).
the hit counter now increase one every time I click time
How I can calculate only one hit for several clicks for session ?

 

[cheesegrits]

Define "one session".

-- hugh