Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 6282 Rev 6283
Línea 61... Línea 61...
61 
    }
 61 
    }
Línea 62... Línea 62...
62 
 
 62 
 
63 
 
 63 
 
64 
    public function fetchAllDataByDateRange($user_id, $start_date, $end_date)
 64 
    public function fetchAllDataByDateRange($user_id, $start_date, $end_date)
65 
    {
 - 
 
66 
        //$select = $this->sql->select(self::_TABLE);
 - 
 
67 
        $select = $this->sql->select();
 65 
    {
68 
        $select->from(['dcl' => DiscoveryContactLogMapper::_TABLE]);
 66 
        $select = $this->sql->select(self::_TABLE);
69 
        $select->columns([
 67 
        $select->columns([
70 
            'added_on',
 68 
            'added_on',
71 
            //'activity' => new Expression('SUM(LABEL_RECORD_CONTACT_ADDED)'),
 69 
            //'activity' => new Expression('SUM(LABEL_RECORD_CONTACT_ADDED)'),
72 
            'user_id' => new Expression('COUNT(user_id)')
 - 
 
73 
        ]);
 70 
            'user_id' => new Expression('COUNT(user_id)')
74 
        $select->join(['u' => UserMapper::_TABLE], 'dcl.user_id =  u.id', ['first_name', 'last_name', 'email']);
 71 
        ]);
75 
        //$select->where->equalTo('user_id', $user_id);
 72 
        //$select->where->equalTo('user_id', $user_id);
76 
        $select->where->between('added_on', $start_date, $end_date);
 73 
        $select->where->between('added_on', $start_date, $end_date);
77 
        $select->where->equalTo('activity', 'LABEL_RECORD_CONTACT_ADDED');
 74 
        $select->where->equalTo('activity', 'LABEL_RECORD_CONTACT_ADDED');