Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 6313 Rev 6314
Línea 59... Línea 59...
59 
 
 59 
 
60 
        return $this->executeFetchAllObject($select, $prototype);
 60 
        return $this->executeFetchAllObject($select, $prototype);
Línea 61... Línea 61...
61 
    }
 61 
    }
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 
    // {
 65 
    {
66 
    //     $select = $this->sql->select();
 66 
        $select = $this->sql->select();
67 
    //     $select->columns([
 67 
        $select->columns([
68 
    //         'added_on',
68 
            'added_on',
69 
    //         'user_id' => new Expression('COUNT(user_id)'),
69 
            'user_id' => new Expression('COUNT(user_id)'),
70 
    //     ]);
 70 
        ]);
71 
    //     $select->from(['dcl' => DiscoveryContactLogMapper::_TABLE]);
 71 
        $select->from(['dcl' => DiscoveryContactLogMapper::_TABLE]);
72 
    //     $select->join(['u' => UserMapper::_TABLE], 'u.id = dcl.user_id', ['first_name', 'last_name', 'email']);
 72 
        $select->join(['u' => UserMapper::_TABLE], 'u.id = dcl.user_id', ['first_name', 'last_name', 'email']);
73 
    //     $select->where->between('dcl.added_on', $start_date, $end_date);
 73 
        $select->where->between('dcl.added_on', $start_date, $end_date);
Línea 74... Línea 74...
74 
    //     $select->where->equalTo('dcl.activity', 'LABEL_RECORD_CONTACT_ADDED');
 74 
        $select->where->equalTo('dcl.activity', 'LABEL_RECORD_CONTACT_ADDED');
75 
    //     $select->group('dcl.added_on');
 75 
        $select->group('dcl.added_on');
Línea 76... Línea 76...
76 
    //     $select->order('dcl.added_on ASC');
 76 
        $select->order('dcl.added_on ASC');
77 
 
 77 
 
78 
    //     return $this->executeFetchAllArray($select);
 78 
        return $this->executeFetchAllArray($select);
79 
    // }
 79 
    }
80 
 
 80 
 
81 
    public function fetchAllDataByDateRange($start_date, $end_date)
 81 
    public function anderson($start_date, $end_date)