Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 5857 | Rev 6280 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 5857 Rev 5858
Línea 67... Línea 67...
67 
        $select->columns([
 67 
        $select->columns([
68 
            'added_on',
 68 
            'added_on',
69 
            //'activity' => new Expression('SUM(LABEL_RECORD_CONTACT_ADDED)'),
 69 
            //'activity' => new Expression('SUM(LABEL_RECORD_CONTACT_ADDED)'),
70 
            'user_id' => new Expression('COUNT(user_id)')
 70 
            'user_id' => new Expression('COUNT(user_id)')
71 
        ]);
 71 
        ]);
72 
        $select->where->equalTo('user_id', $user_id);
 72 
        //$select->where->equalTo('user_id', $user_id);
73 
        $select->where->between('added_on', $start_date, $end_date);
 73 
        $select->where->between('added_on', $start_date, $end_date);
74 
        $select->where->equalTo('activity', 'LABEL_RECORD_CONTACT_ADDED');
 74 
        $select->where->equalTo('activity', 'LABEL_RECORD_CONTACT_ADDED');
75 
        $select->group('added_on');
 75 
        $select->group('added_on');
76 
        $select->order('added_on ASC');
 76 
        $select->order('added_on ASC');