';
/*
*
* Affichage de la liste des projets
*
*/
print '';
print '';
print_liste_field_titre($langs->trans("Project"),"index.php","s.nom","","","",$sortfield);
print ''.$langs->trans("NbOpenTasks").' | ';
print " \n";
$sql = "SELECT p.title, p.rowid, count(t.rowid)";
$sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
$sql .= " , ".MAIN_DB_PREFIX."projet_task as t";
$sql .= " WHERE t.fk_projet = p.rowid";
$sql .= " GROUP BY p.rowid";
$var=true;
$resql = $db->query($sql);
if ( $resql )
{
$num = $db->num_rows($resql);
$i = 0;
while ($i < $num)
{
$row = $db->fetch_row( $resql);
$var=!$var;
print "";
print ''.$row[0].' | ';
print ''.$row[2].' | ';
print " \n";
$i++;
}
$db->free($resql);
}
else
{
dolibarr_print_error($db);
}
print " ";
print ' | ';
/* Affichage de la liste des projets du mois */
print '';
print '';
print 'Activité sur les projets cette semaine | ';
print 'Temps | ';
print " \n";
$sql = "SELECT p.title, p.rowid, sum(tt.task_duration)";
$sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
$sql .= " , ".MAIN_DB_PREFIX."projet_task as t";
$sql .= " , ".MAIN_DB_PREFIX."projet_task_time as tt";
$sql .= " WHERE t.fk_projet = p.rowid";
$sql .= " AND tt.fk_task = t.rowid";
$sql .= " AND week(task_date) = ".strftime("%W",time());
$sql .= " GROUP BY p.rowid";
$var=true;
$resql = $db->query($sql);
if ( $resql )
{
$num = $db->num_rows($resql);
$i = 0;
while ($i < $num)
{
$row = $db->fetch_row( $resql);
$var=!$var;
print "";
print ''.$row[0].' | ';
print ''.$row[2].' | ';
print " \n";
$i++;
}
$db->free($resql);
}
else
{
dolibarr_print_error($db);
}
print " ";
/* Affichage de la liste des projets du mois */
print '';
print '';
print ''.$langs->trans("Project").' ce mois : '.strftime("%B %Y", $now).' | ';
print 'Nb heures | ';
print " \n";
$sql = "SELECT p.title, p.rowid, sum(tt.task_duration)";
$sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
$sql .= " , ".MAIN_DB_PREFIX."projet_task as t";
$sql .= " , ".MAIN_DB_PREFIX."projet_task_time as tt";
$sql .= " WHERE t.fk_projet = p.rowid";
$sql .= " AND tt.fk_task = t.rowid";
$sql .= " AND month(task_date) = ".strftime("%m",$now);
$sql .= " GROUP BY p.rowid";
$var=true;
$resql = $db->query($sql);
if ( $resql )
{
$num = $db->num_rows($resql);
$i = 0;
while ($i < $num)
{
$row = $db->fetch_row( $resql);
$var=!$var;
print "";
print ''.$row[0].' | ';
print ''.$row[2].' | ';
print " \n";
$i++;
}
$db->free($resql);
}
else
{
dolibarr_print_error($db);
}
print " ";
/* Affichage de la liste des projets du mois */
print '
';
print '';
print ''.$langs->trans("Project").' cette année : '.strftime("%Y", $now).' | ';
print 'Nb heures | ';
print " \n";
$sql = "SELECT p.title, p.rowid, sum(tt.task_duration)";
$sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
$sql .= " , ".MAIN_DB_PREFIX."projet_task as t";
$sql .= " , ".MAIN_DB_PREFIX."projet_task_time as tt";
$sql .= " WHERE t.fk_projet = p.rowid";
$sql .= " AND tt.fk_task = t.rowid";
$sql .= " AND YEAR(task_date) = ".strftime("%Y",$now);
$sql .= " GROUP BY p.rowid";
$var=true;
$resql = $db->query($sql);
if ( $resql )
{
$num = $db->num_rows($resql);
$i = 0;
while ($i < $num)
{
$row = $db->fetch_row( $resql);
$var=!$var;
print "";
print ''.$row[0].' | ';
print ''.$row[2].' | ';
print " \n";
$i++;
}
$db->free($resql);
}
else
{
dolibarr_print_error($db);
}
print " ";
print ' |