Proyectos de Subversion LeadersLinked - Services

        return $this->executeFetchAllArray($select);

    }

    /**

     *

     * @param  int $company_id

     * @return string

     */

    public function fetchOneMaxDateActivityFromCompanyId($company_id)

    {

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

        $select->columns(['date' => new Expression('MAX(date)') ] );

        $select->from(self::_TABLE);

        $select->where->equalTo('company_id', $company_id);

        $record = $this->executeFetchOneArray($select);

        return empty($record['date']) ? '' :   $record['date'];

    }

    /**

     *

     * @param int $company_id

     * @param string $start_date

     * @param string $end_date

     * @return array

     */

    public function fetchAllCountUsersWithClosedCapsulesDailyByCompanyIdAndStartDateAndEndDate($company_id, $start_date, $end_date)

    {

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

        $select->columns(['total' => new Expression('COUNT(DISTINCT(user_id))'), 'date' ] );

        $select->from(self::_TABLE);

        $select->where->equalTo('company_id', $company_id);

        $select->where->between('date', $start_date, $end_date);

        $select->group('date');

        $select->order('date desc');

       // echo $select->getSqlString( $this->adapter->platform ); exit;

        return $this->executeFetchAllArray($select);