Proyectos de Subversion LeadersLinked - Antes de SPA

    // public function fetchAllDataByDateRange($user_id, $start_date, $end_date)

    // {

    //     $select = $this->sql->select();

    //     $select->columns([

    //         'added_on', 

    //         'user_id' => new Expression('COUNT(user_id)'), 

    //     ]);

    //     $select->from(['dcl' => DiscoveryContactLogMapper::_TABLE]);

    //     $select->join(['u' => UserMapper::_TABLE], 'u.id = dcl.user_id', ['first_name', 'last_name', 'email']);

    //     $select->where->between('dcl.added_on', $start_date, $end_date);

    //     $select->where->equalTo('dcl.activity', 'LABEL_RECORD_CONTACT_ADDED');

    //     $select->group('dcl.added_on');

    //     $select->order('dcl.added_on ASC');

    //     return $this->executeFetchAllArray($select);

        $select = $this->sql->select(self::_TABLE);

            'user_id',

            'date' => new Expression('DATE(added_on)'),

            'total' => new Expression('COUNT(*)')

        ]);

        $select->where->between(new Expression('DATE(added_on)'), $start_date, $end_date);

        $select->where->equalTo('activity', 'LABEL_RECORD_CONTACT_ADDED');

            'user_id',

        ]);