Author: david
Date: 2008-09-12 16:55:33 -0700 (Fri, 12 Sep 2008)
New Revision: 1380
Added:
trunk/lib/QubitCultureFallback.class.php
Removed:
trunk/apps/qubit/lib/QubitCultureFallback.class.php
Log:
Move QubitCultureFallback.class.php back to project lib/ directory based on
discussion with Jack & Peter
Deleted: trunk/apps/qubit/lib/QubitCultureFallback.class.php
===================================================================
--- trunk/apps/qubit/lib/QubitCultureFallback.class.php 2008-09-12 22:49:51 UTC
(rev 1379)
+++ trunk/apps/qubit/lib/QubitCultureFallback.class.php 2008-09-12 23:55:33 UTC
(rev 1380)
@@ -1,139 +0,0 @@
-<?php
-
-/*
- * This file is part of the Qubit Toolkit.
- * Copyright (C) 2006-2008 Peter Van Garderen <[EMAIL PROTECTED]>
- *
- * This program is free software; you can redistribute it and/or modify it
- * under the terms of the GNU General Public License as published by the Free
- * Software Foundation; either version 2 of the License, or (at your option)
- * any later version.
- *
- * This program is distributed in the hope that it will be useful, but WITHOUT
- * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
- * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License
- * for more details.
- *
- * You should have received a copy of the GNU General Public License along with
- * this program; if not, write to the Free Software Foundation, Inc., 51
- * Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
- */
-
-/**
- * @package qubit
- * @subpackage lib
- * @author David Juhasz <[EMAIL PROTECTED]>
- * @version $Id$
- */
-class QubitCultureFallback
-{
-
- /**
- * Assign fallback values for each column in the $fallbackClassName table
- *
- * @param Criteria $criteria
- * @param string $fallbackClass name of Prople class for table with
desired fallback columns
- * @return Criteria $criteria object withi extra calculated fallback columns
- */
- public static function addFallbackColumns($criteria, $fallbackClassName)
- {
-
- // Get array of column names by getting a table map via MapBuilder class
- // for passed fallback table
- $mapBuilderClassName = substr($fallbackClassName, 5).'MapBuilder';
- $objectMapBuilder = eval ('return new '.$mapBuilderClassName.';');
- $tableName = eval('return '.$fallbackClassName.'::TABLE_NAME;');
-
- // Build the database and table map, and then get tableMap
- call_user_func(array($objectMapBuilder, 'doBuild'));
- $tableMap = $objectMapBuilder->getDatabaseMap()->getTable($tableName);
-
- // Loop through table columns and add fallback calculated fields to
criteria
- foreach ($tableMap->getColumns() as $col)
- {
- $criteria->addAsColumn($col->getColumnName(),
self::getfallbackCaseStmt($col->getColumnName()));
- }
-
- return $criteria;
- }
-
-
- /**
- * Build SQL 'case' statement to get the most relevant value for $column
- *
- * @param string $column name
- * @return string SQL case statement
- */
- private static function getfallbackCaseStmt($column)
- {
- $fallbackCaseStmt = '(CASE WHEN current.'.$column.' IS NOT NULL THEN
current.'.$column;
- $fallbackCaseStmt .= ' WHEN source.'.$column.' IS NOT NULL THEN
source.'.$column;
- $fallbackCaseStmt .= ' ELSE other.'.$column.' END)';
-
- return $fallbackCaseStmt;
- }
-
-
- /**
- * Add fallback query criteria to $criteria
- *
- * @param Criteria $criteria
- * @param array $options
- * @return QubitQuery array of objects
- */
- public static function addFallbackCriteria($criteria, $fallbackClassName,
$culture, $options = array())
- {
-
- // Expose class constants so we can call them using a dynamic class name
- $fallbackClass = new ReflectionClass($fallbackClassName);
- $fallbackClassI18n = new ReflectionClass($fallbackClassName.'I18n');
-
- // Add fallback columns (calculated)
- $criteria = self::addFallbackColumns($criteria,
$fallbackClassI18n->getName());
-
- // Get i18n "CULTURE" column name, with "<tablename>." stripped off the
front
- $cultureColName =
str_replace($fallbackClassI18n->getConstant('TABLE_NAME').'.', '',
$fallbackClassI18n->getConstant('CULTURE'));
-
- // Build join strings
- $currentJoinString = 'current.id AND current.'.$cultureColName.' =
\''.$culture.'\'';
-
- $sourceJoinString = 'source.id AND source.'.$cultureColName.' =
'.$fallbackClass->getConstant('SOURCE_CULTURE');
- $sourceJoinString .= ' AND source.'.$cultureColName.' <> \''.$culture.'\'';
-
- $otherJoinString = 'other.id AND other.'.$cultureColName.' <>
'.$fallbackClass->getConstant('SOURCE_CULTURE');
- $otherJoinString .= ' AND other.'.$cultureColName.' <> \''.$culture.'\'';
-
- // Build fancy criteria to get fallback values
- $criteria->addAlias('current',
$fallbackClassI18n->getConstant('TABLE_NAME'));
- $criteria->addAlias('source',
$fallbackClassI18n->getConstant('TABLE_NAME'));
- $criteria->addAlias('other',
$fallbackClassI18n->getConstant('TABLE_NAME'));
- $criteria->addJoin($fallbackClass->getConstant('ID'), $currentJoinString,
Criteria::LEFT_JOIN);
- $criteria->addJoin($fallbackClass->getConstant('ID'), $sourceJoinString,
Criteria::LEFT_JOIN);
- $criteria->addJoin($fallbackClass->getConstant('ID'), $otherJoinString,
Criteria::LEFT_JOIN);
-
- if (!isset($options['returnClass']))
- {
- // Add Group by to remove multiple rows for "other" results
- $criteria->addGroupByColumn($fallbackClass->getConstant('ID'));
-
- return $criteria;
- }
- else
- {
- // In order to return a QubitQuery object that is *not* the current class
- // (e.g. QubitInformationObject instead of QubitActor)
- // We need to:
- // 1) Add a GroupBy column that won't eliminate unmatched values
- // 2) Add the $returnClass select columns to the ResultSet
- // 3) Call QubitQuery::createFromCriteria with the $returnClass
- $returnClass = new ReflectionClass($options['returnClass']);
- unset($options['returnClass']); // Remove 'returnClass' from options
array
-
- // Add Group by to remove multiple rows for "other" results
- $criteria->addGroupByColumn($returnClass->getConstant('ID'));
-
- return $criteria;
- }
- }
-
-}
\ No newline at end of file
Copied: trunk/lib/QubitCultureFallback.class.php (from rev 1376,
trunk/apps/qubit/lib/QubitCultureFallback.class.php)
===================================================================
--- trunk/lib/QubitCultureFallback.class.php (rev 0)
+++ trunk/lib/QubitCultureFallback.class.php 2008-09-12 23:55:33 UTC (rev
1380)
@@ -0,0 +1,139 @@
+<?php
+
+/*
+ * This file is part of the Qubit Toolkit.
+ * Copyright (C) 2006-2008 Peter Van Garderen <[EMAIL PROTECTED]>
+ *
+ * This program is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU General Public License as published by the Free
+ * Software Foundation; either version 2 of the License, or (at your option)
+ * any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but WITHOUT
+ * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
+ * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License
+ * for more details.
+ *
+ * You should have received a copy of the GNU General Public License along with
+ * this program; if not, write to the Free Software Foundation, Inc., 51
+ * Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ */
+
+/**
+ * @package qubit
+ * @subpackage lib
+ * @author David Juhasz <[EMAIL PROTECTED]>
+ * @version $Id$
+ */
+class QubitCultureFallback
+{
+
+ /**
+ * Assign fallback values for each column in the $fallbackClassName table
+ *
+ * @param Criteria $criteria
+ * @param string $fallbackClass name of Prople class for table with
desired fallback columns
+ * @return Criteria $criteria object withi extra calculated fallback columns
+ */
+ public static function addFallbackColumns($criteria, $fallbackClassName)
+ {
+
+ // Get array of column names by getting a table map via MapBuilder class
+ // for passed fallback table
+ $mapBuilderClassName = substr($fallbackClassName, 5).'MapBuilder';
+ $objectMapBuilder = eval ('return new '.$mapBuilderClassName.';');
+ $tableName = eval('return '.$fallbackClassName.'::TABLE_NAME;');
+
+ // Build the database and table map, and then get tableMap
+ call_user_func(array($objectMapBuilder, 'doBuild'));
+ $tableMap = $objectMapBuilder->getDatabaseMap()->getTable($tableName);
+
+ // Loop through table columns and add fallback calculated fields to
criteria
+ foreach ($tableMap->getColumns() as $col)
+ {
+ $criteria->addAsColumn($col->getColumnName(),
self::getfallbackCaseStmt($col->getColumnName()));
+ }
+
+ return $criteria;
+ }
+
+
+ /**
+ * Build SQL 'case' statement to get the most relevant value for $column
+ *
+ * @param string $column name
+ * @return string SQL case statement
+ */
+ private static function getfallbackCaseStmt($column)
+ {
+ $fallbackCaseStmt = '(CASE WHEN current.'.$column.' IS NOT NULL THEN
current.'.$column;
+ $fallbackCaseStmt .= ' WHEN source.'.$column.' IS NOT NULL THEN
source.'.$column;
+ $fallbackCaseStmt .= ' ELSE other.'.$column.' END)';
+
+ return $fallbackCaseStmt;
+ }
+
+
+ /**
+ * Add fallback query criteria to $criteria
+ *
+ * @param Criteria $criteria
+ * @param array $options
+ * @return QubitQuery array of objects
+ */
+ public static function addFallbackCriteria($criteria, $fallbackClassName,
$culture, $options = array())
+ {
+
+ // Expose class constants so we can call them using a dynamic class name
+ $fallbackClass = new ReflectionClass($fallbackClassName);
+ $fallbackClassI18n = new ReflectionClass($fallbackClassName.'I18n');
+
+ // Add fallback columns (calculated)
+ $criteria = self::addFallbackColumns($criteria,
$fallbackClassI18n->getName());
+
+ // Get i18n "CULTURE" column name, with "<tablename>." stripped off the
front
+ $cultureColName =
str_replace($fallbackClassI18n->getConstant('TABLE_NAME').'.', '',
$fallbackClassI18n->getConstant('CULTURE'));
+
+ // Build join strings
+ $currentJoinString = 'current.id AND current.'.$cultureColName.' =
\''.$culture.'\'';
+
+ $sourceJoinString = 'source.id AND source.'.$cultureColName.' =
'.$fallbackClass->getConstant('SOURCE_CULTURE');
+ $sourceJoinString .= ' AND source.'.$cultureColName.' <> \''.$culture.'\'';
+
+ $otherJoinString = 'other.id AND other.'.$cultureColName.' <>
'.$fallbackClass->getConstant('SOURCE_CULTURE');
+ $otherJoinString .= ' AND other.'.$cultureColName.' <> \''.$culture.'\'';
+
+ // Build fancy criteria to get fallback values
+ $criteria->addAlias('current',
$fallbackClassI18n->getConstant('TABLE_NAME'));
+ $criteria->addAlias('source',
$fallbackClassI18n->getConstant('TABLE_NAME'));
+ $criteria->addAlias('other',
$fallbackClassI18n->getConstant('TABLE_NAME'));
+ $criteria->addJoin($fallbackClass->getConstant('ID'), $currentJoinString,
Criteria::LEFT_JOIN);
+ $criteria->addJoin($fallbackClass->getConstant('ID'), $sourceJoinString,
Criteria::LEFT_JOIN);
+ $criteria->addJoin($fallbackClass->getConstant('ID'), $otherJoinString,
Criteria::LEFT_JOIN);
+
+ if (!isset($options['returnClass']))
+ {
+ // Add Group by to remove multiple rows for "other" results
+ $criteria->addGroupByColumn($fallbackClass->getConstant('ID'));
+
+ return $criteria;
+ }
+ else
+ {
+ // In order to return a QubitQuery object that is *not* the current class
+ // (e.g. QubitInformationObject instead of QubitActor)
+ // We need to:
+ // 1) Add a GroupBy column that won't eliminate unmatched values
+ // 2) Add the $returnClass select columns to the ResultSet
+ // 3) Call QubitQuery::createFromCriteria with the $returnClass
+ $returnClass = new ReflectionClass($options['returnClass']);
+ unset($options['returnClass']); // Remove 'returnClass' from options
array
+
+ // Add Group by to remove multiple rows for "other" results
+ $criteria->addGroupByColumn($returnClass->getConstant('ID'));
+
+ return $criteria;
+ }
+ }
+
+}
\ No newline at end of file
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.ca/group/qubit-commits?hl=en
-~----------~----~----~----~------~----~------~--~---
