public static function count( $def, $conds = null, $field = null )
 {
     if ( !isset( $field ) )
     {
         $field = '*';
     }
     $customFields = array( array( 'operation' => 'COUNT( ' . $field . ' )', 'name' => 'row_count' ) );
     $rows = MMPersistentObject::fetchObjectList( $def, array(), $conds, array(), null, false, false, $customFields );
     return $rows[0]['row_count'];
 }
    /**
     * @param int $applicationId
     * @return array[]
     */
    public static function fetchAllowedUsersByApplication($applicationId)
    {
        $appLocalized = CacheApplicationTool::buildLocalizedApplicationByApplication($applicationId);
        $conditions = array(
            'application_localized_id'                 => $appLocalized->id,
        );

        $result = parent::fetchObjectList(self::definition(), null, $conditions, null, null, false );
        $usersList = array();

        foreach( $result as $row )
        {
            if ( !empty($row) )
            {
                $usersList[] = $row['user_uuid'];
            }
        }

        return $usersList;
    }
    /**
     * @param array $conditions
     * @return ApplicationObject[]
     */
    public static function fetchApplicationList ( $conditions = array() )
    {
        if( is_null(self::$_applicationList ) )
        {
            $appIds = parent::fetchObjectList(ApplicationObject::definition(), null, $conditions, null, null, false );
            $apps   = array();

            foreach( $appIds as $appId )
            {
                $appLocalized = CacheApplicationTool::buildLocalizedApplicationByApplication($appId['id']);

                if ( $appLocalized instanceof ApplicationLocalized && $appLocalized->applicationObject instanceof ApplicationObject )
                    $apps[] = $appLocalized->applicationObject;
            }
            self::$_applicationList = $apps;
        }

        return self::$_applicationList;
    }
 /**
  * @return array
  */
 public static function fetchPendingList()
 {
     return MMPersistentObject::fetchObjectList( self::definition(), null, null, array('created_at' => 'asc'), null, true, false, null, null, ' WHERE updated_at IS NULL' );
 }
Example #5
0
 /**
  * @param string $applicationidentifier
  * @param string $speciality
  * @param int $page
  * @return Seo[]
  */
 static function fetchKeywords($applicationidentifier, $speciality, $page = 1, $limit = 100)
 {
     if($speciality == "speciality")
         $speciality = "";
     else if (is_array($speciality))
     {
         $speciality = array($speciality);
     }
     $conds = array(
         "cluster_identifier" => ClusterTool::clusterIdentifier(),
         "application_identifier" => $applicationidentifier,
         "nb_results" => array(">=", 1)
     );
     if ($speciality != null)
     {
         $conds["speciality"] = $speciality;
     }
     $max = $limit;
     $offset   = (int) ($page * $max) - $max;
     $limit    = array('limit'=>$max,'offset'=>$offset);
     return parent::fetchObjectList(self::definition(), array("keyword", "keyword_url", "speciality_url", "nb_results"), $conds, array("keyword" => "ASC"), $limit, false);
 }