private function getHelper($helper)
{
$helperPlural = Ntentan::plural($helper);
$helper = $helperPlural == null ? $helper : $helperPlural;
if ($helper === null) {
return false;
}
if (!isset($this->loadedHelpers[$this->plugin . $helper])) {
$camelizedHelper = Ntentan::camelize($helper) . "Helper";
$helperFile = Ntentan::$modulesPath . "/helpers/{$helper}/{$camelizedHelper}.php";
if (file_exists($helperFile)) {
require_once $helperFile;
$helperClass = "\\" . Ntentan::$namespace . "\\helpers\\{$helper}\\{$camelizedHelper}";
} else {
if ($this->pluginMode) {
$path = Ntentan::getPluginPath("{$this->plugin}/helpers/{$helper}");
Ntentan::addIncludePath("{$this->plugin}");
$helperClass = "\\ntentan\\plugins\\{$this->plugin}\\helpers\\{$helper}\\{$camelizedHelper}";
} else {
if (file_exists(Ntentan::getFilePath("lib/views/helpers/{$helper}"))) {
$path = Ntentan::getFilePath("lib/views/helpers/{$helper}");
$helperClass = "\\ntentan\\views\\helpers\\{$helper}\\{$camelizedHelper}";
} else {
return false;
}
}
}
Ntentan::addIncludePath($path);
$helperInstance = new $helperClass();
$this->loadedHelpers[$this->plugin . $helper] = $helperInstance;
}
return $this->loadedHelpers[$this->plugin . $helper];
}
public function describe()
{
if (!Cache::exists("model_" . $this->route)) {
$description = $this->dataStore->describe();
if (is_array($this->mustBeUnique)) {
foreach ($description["fields"] as $i => $field) {
$uniqueField = false;
foreach ($this->mustBeUnique as $unique) {
if (is_array($unique)) {
if (isset($unique['field'])) {
if ($field["name"] == $unique["field"]) {
$uniqueField = true;
$uniqueMessage = $unique["message"];
}
} else {
throw new exceptions\DescriptionException("A mustBeUnique constraint specified as an array must always contain a field property");
}
} else {
if ($field["name"] == $unique) {
$uniqueField = true;
$uniqueMessage = null;
}
}
}
if ($uniqueField) {
$description["fields"][$i]["unique"] = true;
if ($uniqueMessage != null) {
$description["fields"][$i]["unique_violation_message"] = $uniqueMessage;
}
}
}
}
if (is_array($this->belongsTo)) {
foreach ($this->belongsTo as $belongsTo) {
$belongsToModel = is_array($belongsTo) ? $belongsTo[0] : $belongsTo;
$description["belongs_to"][] = $belongsToModel;
$alias = null;
if (is_array($belongsTo)) {
$fieldName = $belongsTo["as"];
$alias = $belongsTo["as"];
} else {
$alias = strtolower(Ntentan::singular($this->getBelongsTo($belongsTo)));
$fieldName = $alias . "_id";
}
foreach ($description["fields"] as $i => $field) {
if ($field["name"] == $fieldName) {
$description["fields"][$i]["model"] = Ntentan::plural($belongsToModel);
$description["fields"][$i]["foreign_key"] = true;
$description["fields"][$i]["field_name"] = $fieldName;
if ($alias != '') {
$description["fields"][$i]["alias"] = $alias;
}
}
}
}
} else {
if ($this->belongsTo != null) {
$description["belongs_to"][] = $this->belongsTo;
$fieldName = strtolower(Ntentan::singular($this->belongsTo)) . "_id";
foreach ($description["fields"] as $i => $field) {
if ($field["name"] == $fieldName) {
$description["fields"][$i]["model"] = $this->belongsTo;
$description["fields"][$i]["foreign_key"] = true;
}
}
}
}
Cache::add("model_" . $this->route, $description);
}
return Cache::get("model_" . $this->route);
}
public function add()
{
$model = $this->getModel();
$description = $model->describe();
$entityCode = str_replace(' ', '_', $this->entity);
$this->set("heading_level", $this->headingLevel);
$this->set("headings", $this->headings);
$this->set("fields", $description["fields"]);
$this->set("entity", $this->entity);
$this->set('entity_code', $entityCode);
$this->view->template = "admin_component_add.tpl.php";
if ($this->consoleMode) {
$addExtensionMethodName = Ntentan::camelize(Ntentan::plural($entityCode), ".", "", true) . 'AdminAdd';
if (method_exists($this->controller, $addExtensionMethodName)) {
$addExtensionMethod = new ReflectionMethod($this->controller, $addExtensionMethodName);
$addExtensionMethod->invoke($this->controller);
}
}
if (count($_POST) > 0) {
$model->setData($_POST);
$id = $model->save();
if ($id > 0) {
$route = $this->consoleMode ? $this->consoleModeRoute : $this->route;
Ntentan::redirect("{$route}?n=1&i=" . base64_encode($model));
} else {
$this->set("data", $_POST);
$this->set("errors", $model->invalidFields);
}
}
}
protected function _get($params)
{
// Get a list of fields convert it to a count if that is what is needed
if ($params["type"] == "count") {
$fields = "COUNT(*)";
} else {
// If a count is not needed get a list of all the fields in the model
$description = $this->model->describe();
if ($params["fields"] == null) {
$requestedFields = array_keys($description["fields"]);
} else {
$requestedFields = is_array($params["fields"]) ? $params["fields"] : explode(",", $params["fields"]);
}
$fields = array();
$hasManyFields = array();
$belongsToFields = array();
foreach ($requestedFields as $index => $field) {
if ($params["fetch_related"] === true || $params["fetch_belongs_to"] === true) {
$modelName = Model::extractModelName($field);
if ($modelName != '') {
$relationShip = $this->model->getRelationshipWith($modelName);
if ($relationShip == Model::RELATIONSHIP_HAS_MANY) {
$hasManyFields[$modelName][] = $field;
continue;
} else {
if ($relationShip == Model::RELATIONSHIP_BELONGS_TO) {
$belongsToFields[$modelName][] = Model::extractFieldName($field);
continue;
}
}
}
}
$fields[$index] = $this->resolveName($field, true, $description);
if ($params["fetch_belongs_to"] && $description["fields"][$field]["foreign_key"] && $description["fields"][$field]["alias"] != '') {
$fields[$index] .= " AS {$description["fields"][$field]["alias"]}";
}
}
$fields = implode(", ", is_array($fields) ? $fields : explode(",", $fields));
}
// Generate joins
$joins = "";
// Related joins from the model description
if ($params["fetch_related"] === true || $params["fetch_belongs_to"] === true) {
$numRequestedBelongsTo = count($belongsToFields);
foreach ($this->model->belongsTo as $relatedModel) {
if (is_array($relatedModel) && isset($relatedModel["through"])) {
$firstRelatedModel = Model::load(Model::getBelongsTo($relatedModel[0]));
$firstDatastore = $firstRelatedModel->dataStore;
$secondRelatedModel = Model::load($relatedModel["through"]);
$secondDatastore = $secondRelatedModel->dataStore;
$joins .= " LEFT JOIN {$firstDatastore->table} ON {$firstDatastore->table}.id = {$secondDatastore->table}." . Ntentan::singular($firstDatastore->table) . "_id ";
$joinedModelDescription = $firstRelatedModel->describe();
$joinedModelFields = array_keys($joinedModelDescription["fields"]);
foreach ($joinedModelFields as $index => $field) {
$joinedModelFields[$index] = $this->quote($firstDatastore->table) . "." . $this->quote($field) . " AS " . $this->quote($firstRelatedModel->getRoute() . ".{$field}");
}
if ($params['type'] != 'count') {
$fields = $fields . ", " . implode(", ", $joinedModelFields);
}
} else {
$alias = null;
$as = null;
if (is_array($relatedModel)) {
$alias = isset($relatedModel['alias']) ? $relatedModel['alias'] : $relatedModel["as"];
$as = $relatedModel['as'];
$relatedModel = $relatedModel[0];
}
// If the related belongs to field was not queried then skip this whole step entirely
if ($numRequestedBelongsTo > 0 & isset($belongsToFields[$relatedModel])) {
$model = Model::load(Model::getBelongsTo($relatedModel));
$datastore = $model->dataStore;
$joinedModelDescription = $model->describe();
$joinedModelFields = $belongsToFields[$relatedModel];
} else {
if (is_array($requestedFields)) {
$array = explode('.', $relatedModel);
if ($alias != null && array_search($alias, $requestedFields) === false) {
continue;
} else {
if ($alias == null && array_search(Ntentan::singular(end($array)) . "_id", $requestedFields) === false) {
continue;
}
}
}
$model = Model::load(Model::getBelongsTo($relatedModel));
$datastore = $model->dataStore;
$joinedModelDescription = $model->describe();
$joinedModelFields = array_keys($joinedModelDescription["fields"]);
}
if ($alias == null) {
$joinedTable = $joinedModelDescription["name"];
} else {
$joinedTable = "{$datastore->table}_as_" . str_replace('.', '_', $alias);
}
foreach ($joinedModelFields as $index => $field) {
$joinedModelFields[$index] = $datastore->resolveName($field, true, $joinedModelDescription, false) . " AS " . $this->quote($alias == '' ? "{$model->getRoute()}.{$field}" : "{$alias}.{$field}");
}
if ($params['type'] != 'count') {
$fields = $fields . ", " . implode(", ", $joinedModelFields);
}
$table = $alias == '' ? $datastore->table : $joinedTable;
//"{$datastore->table}_as_" $alias);
$joins .= " LEFT JOIN " . ($datastore->schema == "" ? '' : "{$datastore->schema}.") . $datastore->table . " " . ($alias == '' ? '' : "{$table} ") . " ON {$table}.id = {$this->table}." . ($alias != null ? $as : Ntentan::singular($datastore->table) . "_id ");
}
}
}
/**
* @todo write a test case for this
*/
if (isset($params["through"])) {
if (is_array($params["through"])) {
$through = $params['through'];
} else {
if (is_string($params['through'])) {
$through = explode(',', $params['through']);
}
}
$previousTable = $this->table;
foreach ($through as $relatedModel) {
$modelInstance = Model::load($relatedModel);
$currentTable = $modelInstance->dataStore->table;
$foreignKey = Ntentan::singular($previousTable) . "_id";
$joins .= " JOIN {$currentTable} ON {$previousTable}.id = {$currentTable}.{$foreignKey} ";
$previousTable = $currentTable;
}
}
// Generate the base query
$query = "SELECT {$fields} FROM " . ($this->schema != '' ? $this->quotedSchema . "." : '') . $this->quotedTable . " {$joins} ";
// Generate conditions
$parserResults = $this->parseConditions($params['conditions'], $params);
$hasManyConditions = $parserResults['has_many_conditions'];
$query .= $parserResults['query'];
// Add the sorting queries
if (isset($params['sort'])) {
if (is_array($params['sort'])) {
$query .= " ORDER BY " . implode(", ", $params['sort']);
} else {
$query .= " ORDER BY {$params["sort"]} ";
}
}
// Add the limiting clauses
if ($params["type"] == 'first') {
$query .= $this->limit(array("limit" => '1'));
//" LIMIT 1";
} else {
if (is_numeric($params["type"])) {
$query .= $this->limit(array("limit" => $params['type'], "offset" => $params['offset']));
}
}
$results = $this->query($query);
// Retrieve all related data
if ($params["fetch_related"] === true || $params["fetch_belongs_to"] === true) {
if (count($this->model->belongsTo) > 0) {
foreach ($results as $index => $result) {
$modelizedFields = array();
foreach ($result as $field => $value) {
if (strpos($field, ".") !== false) {
$fieldNameArray = explode(".", $field);
$fieldName = array_pop($fieldNameArray);
$modelName = Ntentan::singular(implode(".", $fieldNameArray));
if (is_string($results[$index][$modelName])) {
$results[$index][$modelName] = array();
}
if ($params['use_dots']) {
$results[$index]["{$modelName}.{$fieldName}"] = $value;
} else {
$results[$index][$modelName][$fieldName] = $value;
}
$modelizedFields[] = $modelName;
unset($results[$index][$field]);
}
}
$modelizedFields = array_unique($modelizedFields);
foreach ($modelizedFields as $modelizedField) {
if ($description["fields"][$modelizedField]["alias"]) {
$wrapperModelName = $description["fields"][$modelizedField]["model"];
} else {
$wrapperModelName = Ntentan::plural($modelizedField);
}
$wrapperModel = Model::load($wrapperModelName);
$wrapperModel->setData($results[$index][$modelizedField], true);
$results[$index][$this->formatRelatedModelName($modelizedField, $params)] = $wrapperModel;
}
}
}
}
if ($params["fetch_related"] === true || $params["fetch_has_many"] === true) {
if (count($this->model->hasMany) > 0) {
foreach ($this->model->hasMany as $hasMany) {
foreach ($results as $index => $result) {
$model = Model::load($hasMany);
$relatedData = $model->get('all', array("conditions" => array_merge(array(Ntentan::singular($this->model->getName()) . "_id" => $result["id"]), is_array($hasManyConditions[$hasMany]) ? $hasManyConditions[$hasMany] : array()), "fields" => $hasManyFields[$hasMany], 'sort' => $params["{$hasMany}_sort"], 'fetch_related' => $params['fetch_related'], 'fetch_has_many' => $params['fetch_has_many']));
$results[$index][$this->formatRelatedModelName($hasMany, $params)] = $relatedData;
}
}
}
}
// Generate the data to be returned
if ($params["type"] == 'first') {
$return = $results[0];
} else {
if ($params["type"] == 'count') {
$return = reset($results[0]);
} else {
$return = $results;
}
}
return $return;
}