How calculate user entry datewise

[amittripathi2k2]

Hi,

I have few forms say Form A, Form B and Form C and 40 users those who can do entry in these forms.

Since, they have to do the entry everyday how can I generate some report to see which user is doing how many entries date wise.

Thanks

 

[troester]

Use a date element without time, in list setting enable "group by" (Data tab)

 

[amittripathi2k2]

Yeah, but how would it show which user has done how many entries in which forms

 

[amittripathi2k2]

How can I get result like how many entries done by each user in particular table

for e.g.

user 1 = 20
user 2 = 31
user 3 = 40 and so on

I am using user element, so I am able to get userid for each user. ButI need to display username of each user and count of entries done by each user. For now I have 3000 records in the table.

SELECT COUNT(*) FROM `online_fir `WHERE user>46
using this statement I get number of records in the table

 

[amittripathi2k2]

Ok, now I am able to get entries by user in particular table using below code:

{source}
<?php

$db = JFactory::getDBO();
$query = "SELECT * FROM #__users" ;
$db->setQuery($query);

$rows = $db->loadObjectList();
foreach ($rows as $row) {

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query = "SELECT COUNT(*) FROM abhi_online_fir WHERE user = ($row->id)";
$db->setQuery($query);
$no = $db->loadResult();
echo $row->id. ' | ' .$row->username . ' | '. $no. '<br>';
}

?>
{/source}

Is there any way, I can do the same datewise:

like I want same output for current date, one week, one month and year?

Any input would really help.

Regards

 

[JackGoa]

hi, play around with the 'Data' tab in your list settings. Especially, 'Group By' and 'Pre-filter'.

 

[amittripathi2k2]

Hey,

thanks everyone. I have solved the issue.