<?php

/**
 * This file is part of the OpenPNE package.
 * (c) OpenPNE Project (http://www.openpne.jp/)
 *
 * For the full copyright and license information, please view the LICENSE
 * file and the NOTICE file that were distributed with this source code.
 */

class NavigationPeer extends BaseNavigationPeer
{
  public static function retrieveByType($type)
  {
    $c = new Criteria();
    $c->add(self::TYPE, $type);
    $c->addAscendingOrderByColumn(self::SORT_ORDER);

    return self::doSelectWithI18n($c);
  }

  public static function retrieveTypes($isMobile)
  {
    $result = array();

    if ($isMobile)
    {
      $defaultTypes = array(
        'mobile_global',
        'mobile_home',
        'mobile_home_side',
        'mobile_friend',
        'mobile_community',
      );
    }
    else
    {
      $defaultTypes = array(
        'insecure_global',
        'secure_global',
        'default',
        'friend',
        'community',
      );
    }

    $c = new Criteria();
    $c->clearSelectColumns();
    $c->addSelectColumn(self::TYPE);
    $c->addGroupByColumn(self::TYPE);
    $c->addAscendingOrderByColumn(self::SORT_ORDER);
    $stmt = self::doSelectStmt($c);
    while ($res = $stmt->fetchColumn(1))
    {
      $result[] = $res;
    }

    return array_unique(array_merge($defaultTypes, $result));
  }
}