/** * 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()) { return false; } } } } // Insert the new data. foreach ($insertMap as $value) { $pivotModel = new $pivotClassName(); $pivotModel->setAttributes($value); if (!$pivotModel->save($runValidation)) { return false; } } } // This is the end of the loop "save each related data". return true; }
/** * 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 { $transacted = false; } try { // Save the main model. if (!parent::save($runValidation, $attributes)) { if ($transacted) { $transaction->rollback(); } return false; } // 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)) { if ($transacted) { $transaction->rollback(); } return false; } } else { // Delete one active record at a time. foreach ($deleteMap as $value) { $pivotModel = GxActiveRecord::model($pivotClassName)->findByPk($value); if (!$pivotModel->delete()) { if ($transacted) { $transaction->rollback(); } return false; } } } } // Insert the new data. foreach ($insertMap as $value) { $pivotModel = new $pivotClassName(); $pivotModel->attributes = $value; if (!$pivotModel->save($runValidation)) { if ($transacted) { $transaction->rollback(); } return false; } } // If transacted, commit the transaction. if ($transacted) { $transaction->commit(); } } catch (Exception $ex) { // If there is an exception, roll back the transaction, if transacted. If not transacted, rethrow the exception. if ($transacted) { $transaction->rollback(); return false; } else { throw $ex; } } } return true; } }
<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); ?>