Cambios cortesía de gmeray:

[mecon/ai.git] / lib / AI / Servicio.php

diff --git a/lib/AI/Servicio.php b/lib/AI/Servicio.php
index 9fb5e8ce668c2b5756a63c67785b2baf206112f9..29f20703f5f6f3b4129e99c3c3a43c0a562d3bc0 100644 (file)
--- a/lib/AI/Servicio.php
+++ b/lib/AI/Servicio.php
@@ -190,7 +190,10 @@ class AI_Servicio extends AI_DBTreeObject {
                 $id = intval($this->$id_field);
                 if ($orden === AI_SERVICIO_ORDEN_LONG_HIJOS) {
                     $query = "
                 $id = intval($this->$id_field);
                 if ($orden === AI_SERVICIO_ORDEN_LONG_HIJOS) {
                     $query = "

-                        SELECT A.*, SUM(CEIL(LENGTH(B.nombre) / 22)) as RENGLONES
+                        SELECT
+                            A.*,
+                            count(1) as COUNT,
+                            SUM(CEIL(LENGTH(B.nombre) / 22)) as RENGLONES

                         FROM {$this->conf['base']}.{$this->conf['tabla']} AS A,
                              {$this->conf['base']}.{$this->conf['tabla']} AS B
                         WHERE A.$id_field = B.$id_padre
                         FROM {$this->conf['base']}.{$this->conf['tabla']} AS A,
                              {$this->conf['base']}.{$this->conf['tabla']} AS B
                         WHERE A.$id_field = B.$id_padre


@@ -198,7 +201,9 @@ class AI_Servicio extends AI_DBTreeObject {
                     if ($soloHabilitados) {
                         $query .= " AND A.{$this->conf['habilitado']} = 1";
                     }
                     if ($soloHabilitados) {
                         $query .= " AND A.{$this->conf['habilitado']} = 1";
                     }

-                    $query .= " GROUP BY A.$id_field ORDER BY RENGLONES DESC";
+                    $query .= "
+                        GROUP BY A.$id_field
+                        ORDER BY RENGLONES DESC, COUNT DESC, A.nombre";

                 } elseif ($orden === AI_SERVICIO_ORDEN_LONG_NOMBRE) {
                     $query = "
                         SELECT *
                 } elseif ($orden === AI_SERVICIO_ORDEN_LONG_NOMBRE) {
                     $query = "
                         SELECT *