PHP Model::addNumber方法代碼示例

    /**
     * Retrieve the unique url for an item
     *
     * @param string $url
     * @param int[optional] $id
     * @return string
     */
    public static function getUrl($url, $id = null)
    {
        // redefine Url
        $url = \SpoonFilter::urlise((string) $url);
        // get db
        $db = BackendModel::get('database');
        // new item
        if ($id === null) {
            $numberOfItems = (int) $db->getVar('SELECT 1
				 FROM media AS i
				 INNER JOIN meta AS m ON i.meta_id = m.id
				 WHERE i.language = ? AND m.url = ?
				 LIMIT 1', array(Language::getWorkingLanguage(), $url));
            // already exists
            if ($numberOfItems != 0) {
                // add number
                $url = BackendModel::addNumber($url);
                // try again
                return self::getUrl($url);
            }
        } else {
            $numberOfItems = (int) $db->getVar('SELECT 1
				 FROM media AS i
				 INNER JOIN meta AS m ON i.meta_id = m.id
				 WHERE i.language = ? AND m.url = ? AND i.id != ?
				 LIMIT 1', array(Language::getWorkingLanguage(), $url, $id));
            // already exists
            if ($numberOfItems != 0) {
                // add number
                $url = BackendModel::addNumber($url);
                // try again
                return self::getUrl($url, $id);
            }
        }
        // return the unique Url!
        return $url;
    }

 /**
  * Retrieve the unique URL for a category
  *
  * @param string $url The string whereon the URL will be based.
  * @param int    $id  The id of the category to ignore.
  *
  * @return string
  */
 public static function getURLForCategory($url, $id = null)
 {
     // redefine URL
     $url = (string) $url;
     // get db
     $db = BackendModel::getContainer()->get('database');
     // new category
     if ($id === null) {
         // already exists
         if ((bool) $db->getVar('SELECT 1
              FROM blog_categories AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.language = ? AND m.url = ?
              LIMIT 1', array(BL::getWorkingLanguage(), $url))) {
             $url = BackendModel::addNumber($url);
             return self::getURLForCategory($url);
         }
     } else {
         // current category should be excluded
         if ((bool) $db->getVar('SELECT 1
              FROM blog_categories AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.language = ? AND m.url = ? AND i.id != ?
              LIMIT 1', array(BL::getWorkingLanguage(), $url, $id))) {
             $url = BackendModel::addNumber($url);
             return self::getURLForCategory($url, $id);
         }
     }
     return $url;
 }

 /**
  * Retrieve a unique URL for a profile based on the display name.
  *
  * @param string $displayName The display name to base on.
  * @param int    $id          The id of the profile to ignore.
  * @return string
  */
 public static function getUrl($displayName, $id = null)
 {
     // decode specialchars
     $displayName = \SpoonFilter::htmlspecialcharsDecode((string) $displayName);
     // urlise
     $url = CommonUri::getUrl($displayName);
     // get db
     $db = BackendModel::getContainer()->get('database');
     // new item
     if ($id === null) {
         // get number of profiles with this URL
         $number = (int) $db->getVar('SELECT 1
              FROM profiles AS p
              WHERE p.url = ?
              LIMIT 1', (string) $url);
         // already exists
         if ($number != 0) {
             // add number
             $url = BackendModel::addNumber($url);
             // try again
             return self::getURL($url);
         }
     } else {
         // get number of profiles with this URL
         $number = (int) $db->getVar('SELECT 1
              FROM profiles AS p
              WHERE p.url = ? AND p.id != ?
              LIMIT 1', array((string) $url, (int) $id));
         // already exists
         if ($number != 0) {
             // add number
             $url = BackendModel::addNumber($url);
             // try again
             return self::getURL($url, $id);
         }
     }
     // cough up new url
     return $url;
 }

    /**
     * Retrieve the unique URL for an item
     *
     * @param string $URL The URL to base on.
     * @param int[optional] $id The id of the item to ignore.
     *
     * @return string
     */
    public static function getURL($URL, $id = null)
    {
        $URL = (string) $URL;
        // get db
        $db = BackendModel::getContainer()->get('database');
        // new item
        if ($id === null) {
            // already exists
            if ((bool) $db->getVar('SELECT 1
				 FROM galleria_albums AS i
				 INNER JOIN meta AS m ON i.meta_id = m.id
				 WHERE i.language = ? AND m.url = ?
				 LIMIT 1', array(BL::getWorkingLanguage(), $URL))) {
                $URL = BackendModel::addNumber($URL);
                return self::getURL($URL);
            }
        } else {
            // already exists
            if ((bool) $db->getVar('SELECT 1
				 FROM galleria_albums AS i
				 INNER JOIN meta AS m ON i.meta_id = m.id
				 WHERE i.language = ? AND m.url = ? AND i.id != ?
				 LIMIT 1', array(BL::getWorkingLanguage(), $URL, $id))) {
                $URL = BackendModel::addNumber($URL);
                return self::getURL($URL, $id);
            }
        }
        return $URL;
    }

    /**
     * Retrieve the unique URL for a category
     *
     * @param string $url
     * @param int [optional] $id The id of the category to ignore.
     * @return string
     */
    public static function getURLForBrand($url, $id = null)
    {
        $url = \SpoonFilter::urlise((string) $url);
        $db = BackendModel::getContainer()->get('database');
        // new category
        if ($id === null) {
            if ((bool) $db->getVar('SELECT 1
				 FROM catalog_brands AS i
				 INNER JOIN meta AS m ON i.meta_id = m.id
				 WHERE m.url = ?
				 LIMIT 1', array($url))) {
                $url = BackendModel::addNumber($url);
                return self::getURLForCategory($url);
            }
        } else {
            // current category should be excluded
            if ((bool) $db->getVar('SELECT 1
				 FROM catalog_brands AS i
				 INNER JOIN meta AS m ON i.meta_id = m.id
				 WHERE m.url = ? AND i.id != ?
				 LIMIT 1', array($url, $id))) {
                $url = BackendModel::addNumber($url);
                return self::getURLForCategory($url, $id);
            }
        }
        return $url;
    }

 /**
  * Get an unique URL for a page
  *
  * @param string $url      The URL to base on.
  * @param int    $id       The id to ignore.
  * @param int    $parentId The parent for the page to create an url for.
  * @param bool   $isAction Is this page an action.
  *
  * @return string
  */
 public static function getURL($url, $id = null, $parentId = 0, $isAction = false)
 {
     $url = (string) $url;
     $parentIds = array((int) $parentId);
     // 0, 1, 2, 3, 4 are all top levels, so we should place them on the same level
     if ($parentId == 0 || $parentId == 1 || $parentId == 2 || $parentId == 3 || $parentId == 4) {
         $parentIds = array(0, 1, 2, 3, 4);
     }
     // get db
     $db = BackendModel::getContainer()->get('database');
     // no specific id
     if ($id === null) {
         // no items?
         if ((bool) $db->getVar('SELECT 1
              FROM pages AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.parent_id IN(' . implode(',', $parentIds) . ') AND i.status = ? AND m.url = ?
                 AND i.language = ?
              LIMIT 1', array('active', $url, BL::getWorkingLanguage()))) {
             // add a number
             $url = BackendModel::addNumber($url);
             // recall this method, but with a new URL
             return self::getURL($url, null, $parentId, $isAction);
         }
     } else {
         // one item should be ignored
         // there are items so, call this method again.
         if ((bool) $db->getVar('SELECT 1
              FROM pages AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.parent_id IN(' . implode(',', $parentIds) . ') AND i.status = ?
                 AND m.url = ? AND i.id != ? AND i.language = ?
              LIMIT 1', array('active', $url, $id, BL::getWorkingLanguage()))) {
             // add a number
             $url = BackendModel::addNumber($url);
             // recall this method, but with a new URL
             return self::getURL($url, $id, $parentId, $isAction);
         }
     }
     // get full URL
     $fullURL = self::getFullURL($parentId) . '/' . $url;
     // get info about parent page
     $parentPageInfo = self::get($parentId, null, BL::getWorkingLanguage());
     // does the parent have extras?
     if ($parentPageInfo['has_extra'] == 'Y' && !$isAction) {
         // set locale
         FrontendLanguage::setLocale(BL::getWorkingLanguage(), true);
         // get all on-site action
         $actions = FrontendLanguage::getActions();
         // if the new URL conflicts with an action we should rebuild the URL
         if (in_array($url, $actions)) {
             // add a number
             $url = BackendModel::addNumber($url);
             // recall this method, but with a new URL
             return self::getURL($url, $id, $parentId, $isAction);
         }
     }
     // check if folder exists
     if (is_dir(PATH_WWW . '/' . $fullURL) || is_file(PATH_WWW . '/' . $fullURL)) {
         // add a number
         $url = BackendModel::addNumber($url);
         // recall this method, but with a new URL
         return self::getURL($url, $id, $parentId, $isAction);
     }
     // check if it is an application
     if (array_key_exists(trim($fullURL, '/'), \ApplicationRouting::getRoutes())) {
         // add a number
         $url = BackendModel::addNumber($url);
         // recall this method, but with a new URL
         return self::getURL($url, $id, $parentId, $isAction);
     }
     // return the unique URL!
     return $url;
 }

 /**
  * Get a unique URL for a tag
  *
  * @param string $URL The URL to use as a base.
  * @param int    $id  The ID to ignore.
  * @return string
  */
 public static function getURL($URL, $id = null)
 {
     $URL = CommonUri::getUrl((string) $URL);
     $language = BL::getWorkingLanguage();
     // get db
     $db = BackendModel::getContainer()->get('database');
     // no specific id
     if ($id === null) {
         // get number of tags with the specified url
         $number = (int) $db->getVar('SELECT 1
              FROM tags AS i
              WHERE i.url = ? AND i.language = ?
              LIMIT 1', array($URL, $language));
         // there are items so, call this method again.
         if ($number != 0) {
             // add a number
             $URL = BackendModel::addNumber($URL);
             // recall this method, but with a new url
             $URL = self::getURL($URL, $id);
         }
     } else {
         // specific id given
         // get number of tags with the specified url
         $number = (int) $db->getVar('SELECT 1
              FROM tags AS i
              WHERE i.url = ? AND i.language = ? AND i.id != ?
              LIMIT 1', array($URL, $language, $id));
         // there are items so, call this method again.
         if ($number != 0) {
             // add a number
             $URL = BackendModel::addNumber($URL);
             // recall this method, but with a new url
             $URL = self::getURL($URL, $id);
         }
     }
     return $URL;
 }

 /**
  * Retrieve the unique URL for a category
  *
  * @param string $url
  * @param int [optional] $id The id of the category to ignore.
  * @return string
  */
 public static function getURLForCategory($url, $id = null)
 {
     $url = \SpoonFilter::urlise((string) $url);
     $db = BackendModel::get('database');
     // new category
     if ($id === null) {
         if ((bool) $db->getVar('SELECT 1
              FROM blocks_categories AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.language = ? AND m.url = ?
              LIMIT 1', array(Language::getWorkingLanguage(), $url))) {
             $url = BackendModel::addNumber($url);
             return self::getURLForCategory($url);
         }
     } else {
         if ((bool) $db->getVar('SELECT 1
              FROM blocks_categories AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.language = ? AND m.url = ? AND i.id != ?
              LIMIT 1', array(Language::getWorkingLanguage(), $url, $id))) {
             $url = BackendModel::addNumber($url);
             return self::getURLForCategory($url, $id);
         }
     }
     return $url;
 }

 /**
  * Retrieve the unique URL for a category
  *
  * @param string $url
  * @param int    $id The id of the category to ignore.
  * @return string
  */
 public static function getURLForCategory($url, $id = null)
 {
     $url = CommonUri::getUrl((string) $url);
     $db = BackendModel::get('database');
     // new category
     if ($id === null) {
         if ((bool) $db->getVar('SELECT 1
              FROM faq_categories AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.language = ? AND m.url = ?
              LIMIT 1', array(BL::getWorkingLanguage(), $url))) {
             $url = BackendModel::addNumber($url);
             return self::getURLForCategory($url);
         }
     } else {
         // current category should be excluded
         if ((bool) $db->getVar('SELECT 1
              FROM faq_categories AS i
              INNER JOIN meta AS m ON i.meta_id = m.id
              WHERE i.language = ? AND m.url = ? AND i.id != ?
              LIMIT 1', array(BL::getWorkingLanguage(), $url, $id))) {
             $url = BackendModel::addNumber($url);
             return self::getURLForCategory($url, $id);
         }
     }
     return $url;
 }

    public static function checkUrl($url)
    {
        $numberOfItems = (int) BackendModel::getContainer()->get('database')->getVar('SELECT 1
				 FROM  meta AS m
				 WHERE m.url = ?
				 LIMIT 1', array($url));
        // already exists
        if ($numberOfItems != 0) {
            // add number
            $url = BackendModel::addNumber($url);
            // try again
            return self::checkUrl($url);
        }
        return $url;
    }