PHP GxActiveRecord::model方法代码示例

 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param mixed $id the ID of the model to be loaded
  * @param string $modelClass the model class name
  * @return GxActiveRecord the loaded model
  */
 public function loadModel($id, $modelClass)
 {
     $model = GxActiveRecord::model($modelClass)->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, Yii::t('app', 'The requested page does not exist.'));
     }
     return $model;
 }

 public function loadModel($key, $modelClass)
 {
     if (is_array($key)) {
         return parent::loadModel($key, $modelClass);
     }
     $staticModel = GxActiveRecord::model($modelClass);
     $model = $staticModel->findByPk($key);
     if (!$model) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }

 public static function model($className = __CLASS__)
 {
     return parent::model($className);
 }

 public function loadModel($key, $modelClass)
 {
     // Get the static model.
     $staticModel = GxActiveRecord::model($modelClass);
     if (is_array($key)) {
         // The key is an array.
         // Check if there are column names indexing the values in the array.
         reset($key);
         if (key($key) === 0) {
             // There are no attribute names.
             // Check if there are multiple PK values. If there's only one, start again using only the value.
             if (count($key) === 1) {
                 return $this->loadModel($key[0], $modelClass);
             }
             // Now we will use the composite PK.
             // Check if the table has composite PK.
             $tablePk = $staticModel->getTableSchema()->primaryKey;
             if (!is_array($tablePk)) {
                 throw new CHttpException(400, Yii::t('giix', 'Your request is invalid.'));
             }
             // Check if there are the correct number of keys.
             if (count($key) !== count($tablePk)) {
                 throw new CHttpException(400, Yii::t('giix', 'Your request is invalid.'));
             }
             // Get an array of PK values indexed by the column names.
             $pk = $staticModel->fillPkColumnNames($key);
             // Then load the model.
             $model = $staticModel->findByPk($pk);
         } else {
             // There are attribute names.
             // Then we load the model now.
             $model = $staticModel->findByAttributes($key);
         }
     } else {
         // The key is not an array.
         // Check if the table has composite PK.
         $tablePk = $staticModel->getTableSchema()->primaryKey;
         if (is_array($tablePk)) {
             // The table has a composite PK.
             // The key must be a string to have a PK separator.
             if (!is_string($key)) {
                 throw new CHttpException(400, Yii::t('giix', 'Your request is invalid.'));
             }
             // There must be a PK separator in the key.
             if (stripos($key, GxActiveRecord::$pkSeparator) === false) {
                 throw new CHttpException(400, Yii::t('giix', 'Your request is invalid.'));
             }
             // Generate an array, splitting by the separator.
             $keyValues = explode(GxActiveRecord::$pkSeparator, $key);
             // Start again using the array.
             return $this->loadModel($keyValues, $modelClass);
         } else {
             // The table has a single PK.
             // Then we load the model now.
             $model = $staticModel->findByPk($key);
         }
     }
     // Check if we have a model.
     if ($model === null) {
         throw new CHttpException(404, Yii::t('giix', 'The requested page does not exist.'));
     }
     return $model;
 }

 protected function dataTables($aColumns, $modelClass, $customQuery = NULL)
 {
     $staticModel = GxActiveRecord::model($modelClass);
     $sIndexColumn = $staticModel->getTableSchema()->primaryKey;
     $namaTabel = $staticModel->tableName();
     /*
      * Paging
      */
     $sLimit = "";
     if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1') {
         $sLimit = "LIMIT " . $_GET['iDisplayStart'] . ", " . $_GET['iDisplayLength'];
     }
     /*
      * Ordering
      */
     $sOrder = "";
     if (isset($_GET['iSortCol_0'])) {
         $sOrder = "ORDER BY  ";
         for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
             if ($_GET['bSortable_' . intval($_GET['iSortCol_' . $i])] == "true") {
                 $sOrder .= "`" . $aColumns[intval($_GET['iSortCol_' . $i])] . "` " . $_GET['sSortDir_' . $i] . ", ";
             }
         }
         $sOrder = substr_replace($sOrder, "", -2);
         if ($sOrder == "ORDER BY") {
             $sOrder = "";
         }
     }
     /*
      * Filtering
      * NOTE this does not match the built-in DataTables filtering which does it
      * word by word on any field. It's possible to do here, but concerned about efficiency
      * on very large tables, and MySQL's regex functionality is very limited
      */
     $sWhere = "";
     if (isset($_GET['sSearch']) && $_GET['sSearch'] != "") {
         $sWhere = "WHERE (";
         for ($i = 0; $i < count($aColumns); $i++) {
             $sWhere .= "`" . $aColumns[$i] . "` LIKE '%" . $_GET['sSearch'] . "%' OR ";
         }
         $sWhere = substr_replace($sWhere, "", -3);
         $sWhere .= ')';
     }
     /* Individual column filtering */
     for ($i = 0; $i < count($aColumns); $i++) {
         if (isset($_GET['bSearchable_' . $i]) && $_GET['bSearchable_' . $i] == "true" && $_GET['sSearch_' . $i] != '') {
             if ($sWhere == "") {
                 $sWhere = "WHERE ";
             } else {
                 $sWhere .= " AND ";
             }
             $sWhere .= "`" . $aColumns[$i] . "` LIKE '%" . $_GET['sSearch_' . $i] . "%' ";
         }
     }
     if ($customQuery != NULL) {
         if (strlen(trim($sWhere)) == 0) {
             $sWhere = "WHERE " . $customQuery;
         } else {
             $sWhere .= " AND " . $customQuery;
         }
     }
     /*
      * SQL queries
      * Get data to display
      */
     $sQuery = "\n\t\t   SELECT `" . str_replace(" , ", " ", implode("`, `", $aColumns)) . "`\n\t\t   FROM   {$namaTabel}\n\t\t   {$sWhere}\n\t\t   {$sOrder}\n\t\t   {$sLimit}\n\t\t   ";
     //echo $sQuery;
     $rResult = Yii::app()->db->createCommand($sQuery)->queryAll();
     /* Data set length after filtering */
     $sQuery = "SELECT COUNT(*) AS FR\n\t\t   FROM   {$namaTabel}\n\t\t   {$sWhere}\n\t\t   {$sOrder}";
     $rResultFilterTotal = Yii::app()->db->createCommand($sQuery)->queryAll();
     foreach ($rResultFilterTotal as $v) {
         $aResultFilterTotal = $v;
     }
     $iFilteredTotal = $aResultFilterTotal["FR"];
     /* Total data set length */
     $sQuery = "\n\t\t   SELECT COUNT(`" . $sIndexColumn . "`) as total\n\t\t   FROM   {$namaTabel}";
     if ($customQuery != NULL) {
         $sQuery .= " WHERE " . $customQuery;
     }
     $rResultTotal = Yii::app()->db->createCommand($sQuery)->queryAll();
     $i = 0;
     $iTotal = 0;
     foreach ($rResultTotal as $v) {
         $iTotal = $v["total"];
     }
     return array("result" => $rResult, "total" => $iTotal, "filtertotal" => $iFilteredTotal);
 }

<?php 
echo '<?php';
?>
 $this->widget('bootstrap.widgets.TbDetailView', array(
	'data' => $model,
	'attributes' => array(
<?php 
foreach ($this->tableSchema->columns as $column) {
    echo $this->generateDetailViewAttribute($this->modelClass, $column) . ",\n";
}
?>
	),
)); ?>

<?php 
foreach (GxActiveRecord::model($this->modelClass)->relations() as $relationName => $relation) {
    if ($relation[0] == GxActiveRecord::HAS_MANY || $relation[0] == GxActiveRecord::MANY_MANY) {
        ?>
<h2><?php 
        echo '<?php';
        ?>
 echo GxHtml::encode($model->getRelationLabel('<?php 
        echo $relationName;
        ?>
')); ?></h2>
<?php 
        echo "<?php\n";
        ?>
	echo GxHtml::openTag('ul');
	foreach($model-><?php 
        echo $relationName;

	/**
	 * Returns all the relations of the specified model.
	 * @param string $modelClass The model class name.
	 * @return array The relations. Each array item is
	 * a relation as an array, having 3 items:
	 * 0: the relation name,
	 * 1: the relation type,
	 * 2: the foreign key,
	 * 3: the related active record class name.
	 * Or an empty array if no relations were found.
	 */
	public function getRelations($modelClass) {
		$relations = GxActiveRecord::model($modelClass)->relations();
		$result = array();
		foreach ($relations as $relationName => $relation) {
			$result[] = array(
				$relationName, // the relation name
				$relation[0], // the relation type
				$relation[2], // the foreign key
				$relation[1] // the related active record class name
			);
		}
		return $result;
	}

 /**
  * Saves the MANY_MANY relations of this record.
  * Internally used by {@link saveWithRelated} and {@link saveMultiple}.
  * See {@link saveWithRelated} and {@link saveMultiple} for details.
  * @param array $relatedData The relation data in the format returned by {@link GxController::getRelatedData}.
  * @param boolean $runValidation Whether to perform validation before saving the record.
  * @param boolean $batch Whether to try to do the deletes and inserts in batch.
  * While batches may be faster, using active record instances provides better control, validation, event support etc.
  * Batch is only supported for deletes.
  * @return boolean Whether the saving succeeds.
  * @see saveWithRelated
  * @see saveMultiple
  * @throws CException If this record is new.
  * @throws CException If this active record has composite PK.
  * @uses pivotModels
  */
 protected function saveRelated($relatedData, $runValidation = true, $batch = true)
 {
     if (empty($relatedData)) {
         return true;
     }
     // This active record can't be new for the method to work correctly.
     if ($this->getIsNewRecord()) {
         throw new CException(Yii::t('giix.messages', 'Cannot save the related records to the database because the main record is new.'));
     }
     // Save each related data.
     foreach ($relatedData as $relationName => $relationData) {
         // The pivot model class name.
         $pivotClassNames = $this->pivotModels();
         $pivotClassName = $pivotClassNames[$relationName];
         $pivotModelStatic = GxActiveRecord::model($pivotClassName);
         // Get the foreign key names for the models.
         $activeRelation = $this->getActiveRelation($relationName);
         $relatedClassName = $activeRelation->className;
         if (preg_match('/(.+)\\((.+),\\s*(.+)\\)/', $activeRelation->foreignKey, $matches)) {
             // By convention, the first fk is for this model, the second is for the related model.
             $thisFkName = $matches[2];
             $relatedFkName = $matches[3];
         }
         // Get the primary key value of the main model.
         $thisPkValue = $this->getPrimaryKey();
         if (is_array($thisPkValue)) {
             throw new CException(Yii::t('giix.messages', 'Composite primary keys are not supported.'));
         }
         // Get the current related models of this relation and map the current related primary keys.
         $currentRelation = $pivotModelStatic->findAll(new CDbCriteria(array('select' => $relatedFkName, 'condition' => "{$thisFkName} = :thisfkvalue", 'params' => array(':thisfkvalue' => $thisPkValue))));
         $currentMap = array();
         foreach ($currentRelation as $currentRelModel) {
             $currentMap[] = $currentRelModel->{$relatedFkName};
         }
         // Compare the current map to the new data and identify what is to be kept, deleted or inserted.
         $newMap = $relationData;
         $deleteMap = array();
         $insertMap = array();
         if ($newMap !== null) {
             // Identify the relations to be deleted.
             foreach ($currentMap as $currentItem) {
                 if (!in_array($currentItem, $newMap)) {
                     $deleteMap[] = $currentItem;
                 }
             }
             // Identify the relations to be inserted.
             foreach ($newMap as $newItem) {
                 if (!in_array($newItem, $currentMap)) {
                     $insertMap[] = $newItem;
                 }
             }
         } else {
             // If the new data is empty, everything must be deleted.
             $deleteMap = $currentMap;
         }
         // If nothing changed, we simply continue the loop.
         if (empty($deleteMap) && empty($insertMap)) {
             continue;
         }
         // Now act inserting and deleting the related data: first prepare the data.
         // Inject the foreign key names of both models and the primary key value of the main model in the maps.
         foreach ($deleteMap as &$deleteMapPkValue) {
             $deleteMapPkValue = array_merge(array($relatedFkName => $deleteMapPkValue), array($thisFkName => $thisPkValue));
         }
         unset($deleteMapPkValue);
         // Clear reference;
         foreach ($insertMap as &$insertMapPkValue) {
             $insertMapPkValue = array_merge(array($relatedFkName => $insertMapPkValue), array($thisFkName => $thisPkValue));
         }
         unset($insertMapPkValue);
         // Clear reference;
         // Now act inserting and deleting the related data: then execute the changes.
         // Delete the data.
         if (!empty($deleteMap)) {
             if ($batch) {
                 // Delete in batch mode.
                 if ($pivotModelStatic->deleteByPk($deleteMap) !== count($deleteMap)) {
                     return false;
                 }
             } else {
                 // Delete one active record at a time.
                 foreach ($deleteMap as $value) {
                     $pivotModel = GxActiveRecord::model($pivotClassName)->findByPk($value);
                     if (!$pivotModel->delete()) {
//.........这里部分代码省略.........

 /**
  * Returns all the relations of the specified model.
  * @param string $modelClass The model class name.
  * @return array The relations. Each array item is
  * a relation as an array, having 3 items:
  * 0: the relation name,
  * 1: the relation type,
  * 2: the foreign key,
  * 3: the related active record class name.
  * Or an empty array if no relations were found.
  */
 public function getRelations($modelClass)
 {
     $relations = GxActiveRecord::model($modelClass)->relations();
     $result = array();
     foreach ($relations as $relationName => $relation) {
         $result[] = array($relationName, $relation[0], $relation[2], $relation[1]);
     }
     return $result;
 }

 /**
  * Saves the current record and its relations.
  * @param array $relatedData The relation data in the format returned by {@link GxController::getRelatedData}.
  * @param boolean $runValidation Whether to perform validation before saving the record.
  * If the validation fails, the record will not be saved to database. This applies to all (including related) models.
  * This does not apply when in batch mode. This does not apply for deletes. If you want to validate deletes, disable
  * batch mode and use the {@link CActiveRecord::onBeforeDelete} event.
  * @param array $attributes List of attributes that need to be saved. Defaults to null,
  * meaning all attributes that are loaded from DB will be saved. This applies only to the main model.
  * @param array $options Additional options. Valid options are:
  * <ul>
  * <li>'withTransaction', boolean: Whether to use a transaction.
  * Note: if there are no changes in the relations, no transaction will be used.</li>
  * <li>'batch', boolean: Whether to try to do the deletes and inserts in batch.
  * While batches may be faster, using active record instances provides better control, validation, event support etc.
  * Batch is only supported for deletes.</li>
  * </ul>
  * @return boolean Whether the saving succeeds.
  */
 public function saveWithRelated($relatedData, $runValidation = true, $attributes = null, $options = array())
 {
     // The default options.
     $defaultOptions = array('withTransaction' => true, 'batch' => true);
     // Merge the specified options with the default options.
     $options = array_merge($defaultOptions, $options);
     // Pass the options to variables.
     $withTransaction = $options['withTransaction'];
     $batch = $options['batch'];
     if (empty($relatedData)) {
         // There is no related data. We simply save the main model.
         return parent::save($runValidation, $attributes);
     } else {
         // Save each related data.
         foreach ($relatedData as $relationName => $relationData) {
             // Get the current related models of this relation and map the current related primary keys.
             $currentRelation = $this->{$relationName};
             $currentMap = array();
             foreach ($currentRelation as $currentRelModel) {
                 $currentMap[] = $currentRelModel->primaryKey;
             }
             // Compare the current map to the new data and identify what is to be kept, deleted or inserted.
             $newMap = $relationData;
             $deleteMap = array();
             $insertMap = array();
             if (!is_null($newMap)) {
                 // Identify the relations to be deleted.
                 foreach ($currentMap as $currentItem) {
                     if (!in_array($currentItem, $newMap)) {
                         $deleteMap[] = $currentItem;
                     }
                 }
                 // Identify the relations to be inserted.
                 foreach ($newMap as $newItem) {
                     if (!in_array($newItem, $currentMap)) {
                         $insertMap[] = $newItem;
                     }
                 }
             } else {
                 // If the new data is empty, everything must be deleted.
                 $deleteMap = $currentMap;
             }
             // If nothing changed, we simply save the main model.
             if (empty($deleteMap) && empty($insertMap)) {
                 return parent::save($runValidation, $attributes);
             }
             // Now act inserting and deleting the related data: first prepare the data.
             // Get the foreign key names for the models.
             $activeRelation = $this->getActiveRelation($relationName);
             $relatedClassName = $activeRelation->className;
             if (preg_match('/(.+)\\((.+),\\s*(.+)\\)/', $activeRelation->foreignKey, $matches)) {
                 // By convention, the first fk is for this model, the second is for the related model.
                 //$pivotTableName = $matches[1];
                 $thisFkName = $matches[2];
                 $relatedFkName = $matches[3];
             }
             // The pivot model class name.
             $pivotClassNames = $this->pivotModels();
             $pivotClassName = $pivotClassNames[$relationName];
             $pivotModelStatic = GxActiveRecord::model($pivotClassName);
             // Get the primary key value of the main model.
             $thisPkValue = $this->primaryKey;
             if (is_array($thisPkValue)) {
                 throw new Exception(Yii::t('giix', 'Composite primary keys are not supported.'), 500);
             }
             // Inject the foreign key names of both models and the primary key value of the main model in the maps.
             foreach ($deleteMap as &$pkValue) {
                 $pkValue = array_merge(array($relatedFkName => $pkValue), array($thisFkName => $thisPkValue));
             }
             unset($pkValue);
             // Clear reference;
             foreach ($insertMap as &$pkValue) {
                 $pkValue = array_merge(array($relatedFkName => $pkValue), array($thisFkName => $thisPkValue));
             }
             unset($pkValue);
             // Clear reference;
             // Start the transaction if required.
             if ($withTransaction && is_null($this->dbConnection->currentTransaction)) {
                 $transacted = true;
                 $transaction = $this->dbConnection->beginTransaction();
             } else {
//.........这里部分代码省略.........

          <div id="gridview-wrapper" class="left">
<?php 
echo '<?php';
?>
 $this->widget('zii.widgets.grid.CGridView', array(
	'id' => '<?php 
echo $this->class2var($relatedModelClass);
?>
-grid',
	'dataProvider' => $prod_dataProvider,
	'filter' => $model,
	'columns' => array(
<?php 
$count = 0;
foreach (GxActiveRecord::model($relatedModelClass)->tableSchema->columns as $column) {
    if (++$count == 7) {
        echo "\t\t/*\n";
    }
    echo "\t\t" . $this->generateGridViewColumn($this->modelClass, $column) . ",\n";
}
if ($count >= 7) {
    echo "\t\t*/\n";
}
?>
                                                                  array(
                                                                           'class' => 'CDataColumn',
                                                                           'type' => 'image',
                                                                           'value' => '($data-><?php 
echo $this->class2var($relatedModelClass);
?>