Changeset 5887 for trunk/centreon/www/include/home/tacticalOverview/tacticalOverview.php

Timestamp:

07/24/08 11:48:56 (4 months ago)

Author:

jmathis

Message:

remove problem when service is acknowledged more than one time.

Files:

• trunk/centreon/www/include/home/tacticalOverview/tacticalOverview.php (modified) (4 diffs)

trunk/centreon/www/include/home/tacticalOverview/tacticalOverview.php

@@ -278 +278 @@
                  */
                 if (!$is_admin)
-                        $rq1 =  " SELECT count(".$ndo_base_prefix."acknowledgements.state), ".$ndo_base_prefix."acknowledgements.state" .
+                        $rq1 =  " SELECT count(DISTINCT ".$ndo_base_prefix."objects.object_id), ".$ndo_base_prefix."acknowledgements.state" .
                                         " FROM ".$ndo_base_prefix."acknowledgements, ".$ndo_base_prefix."objects, ".$ndo_base_prefix."servicestatus, centreon_acl" .
                                         " WHERE ".$ndo_base_prefix."objects.object_id = ".$ndo_base_prefix."acknowledgements.object_id" .
@@ -292 +292 @@
                                         " ORDER by ".$ndo_base_prefix."acknowledgements.state";
                 else
-                        $rq1 =  " SELECT count(".$ndo_base_prefix."acknowledgements.state), ".$ndo_base_prefix."acknowledgements.state" .
+                        $rq1 =  " SELECT count(DISTINCT ".$ndo_base_prefix."objects.object_id), ".$ndo_base_prefix."acknowledgements.state" .
                                         " FROM ".$ndo_base_prefix."acknowledgements, ".$ndo_base_prefix."objects, ".$ndo_base_prefix."servicestatus" .
                                         " WHERE ".$ndo_base_prefix."objects.object_id = ".$ndo_base_prefix."acknowledgements.object_id" .
@@ -302 +302 @@
                                         " GROUP BY ".$ndo_base_prefix."acknowledgements.state " .
                                         " ORDER by ".$ndo_base_prefix."acknowledgements.state";
-                                        
                 $DBRESULT_NDO1 =& $pearDBndo->query($rq1);
                 if (PEAR::isError($DBRESULT_NDO1))
@@ -309 +308 @@
                 $svcAck = array(0=>0, 1=>0, 2=>0, 3=>0, 4=>0);
                 while ($ndo =& $DBRESULT_NDO1->fetchRow())
-                        $svcAck[$ndo["state"]] = $ndo["count(".$ndo_base_prefix."acknowledgements.state)"];
+                        $svcAck[$ndo["state"]] = $ndo["count(DISTINCT ".$ndo_base_prefix."objects.object_id)"];
                 
                 /*