if(check_user_permission(55) ) {
?>
|
Open |
Total |
// OMS Task
$sql = "SELECT count(*) as total, SUM(if(status = 'ongoing', 1,0)) as total_open
FROM oms_task ";
if(!$oms_task_result = mysql_query($sql))
showerror();
if($oms_task_row = mysql_fetch_array($oms_task_result))
{
?>
| Task |
=$oms_task_row["total_open"]?> |
=$oms_task_row["total"]?> |
}
?>
// OMS Project
$sql = "SELECT count(*) as total, SUM(if(status = 'open', 1,0)) as total_open
FROM oms_project ";
if(!$oms_project_result = mysql_query($sql))
showerror();
if($oms_project_row = mysql_fetch_array($oms_project_result))
{
?>
| Project |
=$oms_project_row["total_open"]?> |
=$oms_project_row["total"]?> |
}
?>
} ?>