/**
* Format XML for the current recordset
*
* @access public
* @param SLS_XMLToolbox $xml current controller's XML
* @param array $options transformations on some columns - delimited by ":". each function can be methods of SLS' classes or php standard function
* <code>
* // Complete example
* $xml = $news->toXML($xml, array( "news_excerpt" => array("php:strip_tags", "SLS_String:trimStringToLength:100"),
* "news_date" => array("SLS_Date:getDate:FULL_LITTERAL_TIME", "php:ucwords"),
* "news_photo" => "SLS_String:getUrlFileImg:_0",
* "news_pdf" => "SLS_String:getUrlFile",
* "news_title" => "php:trim",
* "news_link" => array("/Item/",
* "news_title" => "SLS_String:stringToUrl:_",
* "-",
* "news_id" => array("php:intval","php:pow:2"),
* "/User/",
* "user_id"))
* , true, "news");
* </code>
* @param mixed $fks (bool: if true all fks, if false only current Model) - array fks you want to extract params
* @param string $nodeName the root node of your model, by default it's your classname in lowercase
* @param array $properties all columns/values of your choice if you don't want to take it from getParams() function of the current instance
* @return SLS_XMLToolbox $xml current controller's XML updated
* @see SLS_FrontModel::getParams
* @see SLS_FrontModel::pdoToXML
* @since 1.0.8
*/
public function toXML($xml,$options=array(),$fks=false,$nodeName="",$properties=array())
{
$nodeName = (empty($nodeName)) ? strtolower($this->getTable()) : $nodeName;
$properties = (empty($properties)) ? $this->getParams($fks) : $properties;
$xml->startTag($nodeName);
foreach($properties as $column => $value)
{
if (in_array($column,$columns=array_keys($options)))
{
$filters = (is_array($options[$column])) ? $options[$column] : array($options[$column]);
foreach($filters as $filter)
{
$option = explode(":",$filter);
switch($option[0])
{
case SLS_String::startsWith($option[0],"SLS_"):
if (!class_exists($option[0]))
SLS_Tracing::addTrace(new Exception("Error: you want to use an undefined class `".$option[0]."` for the column `".$column."` of `".$this->getTable()."` table"));
else
{
if (!method_exists($option[0],((count($option)> 1) ? $option[1] : "")))
SLS_Tracing::addTrace(new Exception("Error: you want to use an undefined function `".$option[1]."` of class `".$option[0]."` for the column `".$column."` of `".$this->getTable()."` table"));
else
{
$ref = new ReflectionMethod($option[0],$option[1]);
$nbRequiredParams = $ref->getNumberOfRequiredParameters();
if ($nbRequiredParams > (count($option)-1))
SLS_Tracing::addTrace(new Exception("Error: function `".$option[1]."` of class `".$option[0]."` needs ".$nbRequiredParams." required parameters for the column `".$column."` of `".$this->getTable()."` table"),true);
else
{
$params = array_slice($option,2);
array_unshift($params,$value);
// Case "SLS_Date::getDate"
if ($option[0] == "SLS_Date" && $option[1] == "getDate")
{
$option[0] = new SLS_Date($value);
array_shift($params);
}
// Case "SLS_String::getUrlFileImg"
if ($option[0] == "SLS_String" && $option[1] == "getUrlFileImg" && count($option) > 2)
{
$xml->addFullTag($column."_original",SLS_String::getUrlFile($value,(count($option) > 3) ? $option[3] : ""),true);
$column = $column.$option[2];
}
$value = $ref->invokeArgs(($ref->isStatic()) ? null : $option[0],$params);
}
}
}
break;
case "php":
if (count($option) < 2)
SLS_Tracing::addTrace(new Exception("Error: you must specify the name of the PHP's function you want to apply on the column `".$column."` of `".$this->getTable()."` table"));
else
{
if (function_exists($option[1]))
{
$ref = new ReflectionFunction($option[1]);
$nbRequiredParams = $ref->getNumberOfRequiredParameters();
if ($nbRequiredParams > (count($option)-1))
SLS_Tracing::addTrace(new Exception("Error: the PHP's function `".$option[1]."` needs ".$nbRequiredParams." required parameters for the column `".$column."` of `".$this->getTable()."` table"),true);
else
{
$params = array_slice($option,2);
array_unshift($params,$value);
$value = $ref->invokeArgs($params);
}
}
else
SLS_Tracing::addTrace(new Exception("Error: the PHP's function '".$option[1]."' you want to use on the column `".$column."` of `".$this->getTable()."` table doesn't exist"));
}
break;
default:
SLS_Tracing::addTrace(new Exception("Error: you want to apply an unknown filter on the column `".$column."` of `".$this->getTable()."` table doesn't exist"));
break;
}
}
}
$xml->addFullTag($column,$value,true);
}
foreach($options as $col => $concat)
{
if (!in_array($col,array_keys($properties)) && is_array($concat))
{
$values = array();
foreach($concat as $column => $filter)
{
if (is_int($column) && !empty($filter) && !is_array($filter))
{
$column = $filter;
$filter = "";
}
$value = "";
$filters = (is_array($filter)) ? $filter : ((empty($filter)) ? "" : array($filter));
if (in_array($column,array_keys($properties)))
$value .= $properties[$column];
else
$value .= $column;
if (!empty($filters))
{
foreach($filters as $filter)
{
$option = explode(":",$filter);
switch($option[0])
{
case SLS_String::startsWith($option[0],"SLS_"):
if (!class_exists($option[0]))
SLS_Tracing::addTrace(new Exception("Error: you want to use an undefined class `".$option[0]."` for the column `".$column."` of `".$this->getTable()."` table"));
else
{
if (!method_exists($option[0],((count($option)> 1) ? $option[1] : "")))
SLS_Tracing::addTrace(new Exception("Error: you want to use an undefined function `".$option[1]."` of class `".$option[0]."` for the column `".$column."` of `".$this->getTable()."` table"));
else
{
$ref = new ReflectionMethod($option[0],$option[1]);
$nbRequiredParams = $ref->getNumberOfRequiredParameters();
if ($nbRequiredParams > (count($option)-1))
SLS_Tracing::addTrace(new Exception("Error: function `".$option[1]."` of class `".$option[0]."` needs ".$nbRequiredParams." required parameters for the column `".$column."` of `".$this->getTable()."` table"),true);
else
{
$params = array_slice($option,2);
array_unshift($params,$value);
// Case "SLS_Date::getDate"
if ($option[0] == "SLS_Date" && $option[1] == "getDate")
{
$option[0] = new SLS_Date($value);
array_shift($params);
}
// Case "SLS_String::getUrlFileImg"
if ($option[0] == "SLS_String" && $option[1] == "getUrlFileImg" && count($option) > 2)
{
$xml->addFullTag($column."_original",SLS_String::getUrlFile($value),true);
$column = $column.$option[2];
}
$value = $ref->invokeArgs(($ref->isStatic()) ? null : $option[0],$params);
}
}
}
break;
case "php":
if (count($option) < 2)
SLS_Tracing::addTrace(new Exception("Error: you must specify the name of the PHP's function you want to apply on the column `".$column."` of `".$this->getTable()."` table"));
else
{
if (function_exists($option[1]))
{
$ref = new ReflectionFunction($option[1]);
$nbRequiredParams = $ref->getNumberOfRequiredParameters();
if ($nbRequiredParams > (count($option)-1))
SLS_Tracing::addTrace(new Exception("Error: the PHP's function `".$option[1]."` needs ".$nbRequiredParams." required parameters for the column `".$column."` of `".$this->getTable()."` table"),true);
else
{
$params = array_slice($option,2);
array_unshift($params,$value);
$value = $ref->invokeArgs($params);
}
}
else
SLS_Tracing::addTrace(new Exception("Error: the PHP's function '".$option[1]."' you want to use on the column `".$column."` of `".$this->getTable()."` table doesn't exist"));
}
break;
default:
SLS_Tracing::addTrace(new Exception("Error: you want to apply an unknown filter on the column `".$column."` of `".$this->getTable()."` table doesn't exist"));
break;
}
}
}
$values[] = $value;
}
$xml->addFullTag($col,implode("",$values),true);
}
}
$xml->endTag($nodeName);
return $xml;
}
/**
* Format recordsets
*
* @param SLS_XMLToolBox $xml
* @param array PDO $recordsets
* @param string $fkRecursiveExists
* @return SLS_XMLToolBox $xml modified
*/
public function formatRecordsets($xml,$recordsets,$fkRecursiveExists="")
{
$xml->startTag("entities");
for($i=0 ; $i<$count=count($recordsets) ; $i++)
{
$xml->startTag("entity",array("gap" => $this->_gap));
foreach($recordsets[$i] as $key => $value)
{
if (array_key_exists($key,$this->_columns) && ($this->_columns[$key]["list"] == "true" || $key == $this->_object->getPrimaryKey()))
{
$hashExists = $this->_xmlFilter->getTag("//sls_configs/entry[@table='".strtolower($this->_db_alias."_".$this->_columns[$key]["table"])."' and @column='".$key."' and @filter='hash']/@hash");
if (!empty($this->_columns[$key]["specific_type"]))
{
switch($this->_columns[$key]["specific_type"])
{
case "email":
if (SLS_String::validateEmail($value))
$value = "<a href='mailto:".$value."' target='_blank' class='sls-bo-color-text'>".$value."</a>";
break;
case "url":
if (SLS_String::isValidUrl($value))
$value = "<a href='".$value."' target='_blank' class='sls-bo-color-text'>".SLS_String::substrAfterLastDelimiter($value,"://")."</a>";
break;
case "file";
switch($this->_columns[$key]["specific_type_extended"])
{
case "all":
if (!empty($value) && file_exists($this->_generic->getPathConfig("files").$value))
$value = "<a href='".SLS_String::getUrlFile($value)."' target='_blank' class='sls-bo-color-text'>".SLS_String::substrAfterLastDelimiter($value,"/")."</a>";
break;
case "img":
if (!empty($value) && file_exists($this->_generic->getPathConfig("files").$value))
$value = "<a href='".SLS_String::getUrlFile($value)."' target='_blank'><img class='sls-image' sls-image-src='".((!empty($this->_columns[$key]["image_thumb"])) ? SLS_String::getUrlFileImg($value,$this->_columns[$key]["image_thumb"]) : SLS_String::getUrlFile($value))."' alt='".SLS_String::substrAfterLastDelimiter($value,"/")."' title='".SLS_String::substrAfterLastDelimiter($value,"/")."' /></a>";
break;
}
break;
case "color":
$rgb = SLS_String::hex2RGB($value);
$value = "<div class='sls-bo-box-color' style='color:".((((0.213 * $rgb["red"]) + (0.715 * $rgb["green"]) + (0.072 * $rgb["blue"])) < 0.5) ? "#FFF" : "#000").";background-color:#".$value."'>#".$value."</div>";
break;
}
}
if ($this->_columns[$key]["html_type"] == "input_textarea")
$value = "<p>".SLS_String::trimStringToLength(strip_tags($value),150)."</p>";
if (!empty($hashExists))
$value = "********";
$xml->addFullTag($key,$value,true);
}
}
if (!empty($fkRecursiveExists))
{
$this->_gap++;
$xml = $this->getFkChildrens($xml,$fkRecursiveExists,$recordsets[$i]->{$this->_object->getPrimaryKey()});
$this->_gap--;
}
$xml->endTag("entity");
}
$xml->endTag("entities");
return $xml;
}
/**
* Get columns of a given table
*
* @param string $db the db alias of the table
* @param string $table the wanted table you want to extract columns infos
* @param string $boPath xPath of the table in bo.xml
* @param string $classFather the father model (if children)
* @param bool $needPk if you want primary_key
* @param bool $needBoSettings if you want bo listing privileges (list|edit|filter)
* @return array $columns columns of the table
*/
public function getTableColumns($db,$table,$boPath="",$classFather="",$needPk=false,$needBoSettings=false)
{
$infosTable = $this->_db->showColumns($table);
$isMultilanguage = false;
$uniquesMultilang = array();
$columns = array();
foreach((is_array($infosTable)) ? $infosTable : array($infosTable) as $infoTable)
{
if ($infoTable->Key == "PRI" && $infoTable->Field == "pk_lang")
{
$isMultilanguage = true;
break;
}
}
// Show create table
if ($isMultilanguage)
{
$create = array_shift($this->_db->select("SHOW CREATE TABLE `".$table."`"));
$instructions = array_map("trim",explode("\n",$create->{Create." ".Table}));
foreach($instructions as $instruction)
{
if (SLS_String::startsWith($instruction,"UNIQUE KEY"))
{
$uniqueColumns = explode(",",SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($instruction,"("),")"));
if (count($uniqueColumns) == 2 && in_array("`pk_lang`",$uniqueColumns))
{
$uniqueColumn = array_shift($uniqueColumns);
if ($uniqueColumn == "`pk_lang`")
$uniqueColumn = array_shift($uniqueColumns);
$uniquesMultilang[] = str_replace("`","",$uniqueColumn);
}
}
}
}
// Get columns
if (is_array($infosTable))
{
foreach($infosTable as $infoTable)
{
$pk = "false";
// Switch primary keys
if ($infoTable->Key == "PRI")
{
if (!$needPk)
continue;
else
$pk = "true";
}
// Column
$column = array("db" => $db,
"table" => $table,
"name" => $infoTable->Field,
"pk" => $pk,
"label" => $infoTable->Field,
"multilanguage" => ($this->_object->isMultilanguage()) ? "true" : "false",
"native_type" => "string",
"html_type" => "input_text",
"specific_type" => "",
"specific_type_extended" => "",
"file_uid" => uniqid(),
"image_ratio" => "*",
"image_thumb" => "",
"image_min_width" => "*",
"image_min_height" => "*",
"html" => "false",
"choices" => array(),
"values" => (empty($classFather)) ? $this->_langsValues : array(),
"errors" => array(),
"required" => "true",
"unique" => "false",
"default" => "",
"ac_db" => "",
"ac_entity" => "",
"ac_fk" => "",
"ac_column" => "",
"ac_label" => "",
"ac_pattern" => "",
"ac_multiple" => "",
"min_length" => "",
"max_length" => "",
"filters" => "");
if ($needBoSettings)
{
$column["list"] = "true";
$column["edit"] = "false";
$column["filter"] = "true";
if (!empty($boPath))
{
$columnBoAttributes = array_shift($this->_xmlBo->getTagsAttributes($boPath."/columns/column[@name='".$column["name"]."']",array("displayList","allowEdit","displayFilter")));
if (!empty($columnBoAttributes))
{
$columnBoAttributesOptions = array("true","false");
$column["list"] = (in_array($columnBoAttributes["attributes"][0]["value"],$columnBoAttributesOptions)) ? $columnBoAttributes["attributes"][0]["value"] : "true";
$column["edit"] = (in_array($columnBoAttributes["attributes"][1]["value"],$columnBoAttributesOptions)) ? $columnBoAttributes["attributes"][1]["value"] : "false";
$column["filter"] = (in_array($columnBoAttributes["attributes"][2]["value"],$columnBoAttributesOptions)) ? $columnBoAttributes["attributes"][2]["value"] : "true";
}
}
}
// Comment
$comment = empty($infoTable->Comment) ? $infoTable->Field : $infoTable->Comment;
if (SLS_String::startsWith($comment,"sls:lang:"))
{
$key = strtoupper(SLS_String::substrAfterFirstDelimiter($comment,"sls:lang:"));
$comment = (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key])) ? (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) ? $infoTable->Field : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key];
}
if (!empty($comment))
$column["label"] = $comment;
// Native type, possible choices
$nativeType = $infoTable->Type;
$columnValues = array();
switch($nativeType)
{
case (false !== $typeMatch = $this->containsRecursive($nativeType,array("int"))):
$columnType = "int";
$column["html_type"] = "input_number";
break;
case (false !== $typeMatch = $this->containsRecursive($nativeType,array("float","double","decimal","real"))):
$columnType = "float";
$column["html_type"] = "input_number";
break;
case (false !== $typeMatch = $this->containsRecursive($nativeType,array("year","datetime","timestamp","time","date"))):
$columnType = ($typeMatch == "timestamp") ? "datetime" : $typeMatch;
$column["html_type"] = "input_".$typeMatch;
if ($infoTable->Null == "NO")
{
switch ($typeMatch)
{
case "year": $column["default"] = date("Y"); break;
case "time": $column["default"] = date("H:i:s"); break;
case "date": $column["default"] = date("Y-m-d"); break;
default: $column["default"] = date("Y-m-d H:i:s"); break;
}
}
break;
case (false !== $typeMatch = $this->containsRecursive($nativeType,array("enum","set"))):
$columnType = "string";
$column["html_type"] = ($typeMatch == "enum") ? "input_radio" : "input_checkbox";
$columnValues = explode("','",SLS_String::substrAfterFirstDelimiter(SLS_String::substrBeforeLastDelimiter($nativeType, "')"), "('"));
break;
case (false !== $typeMatch = $this->containsRecursive($nativeType,array("text"))):
$columnType = "string";
$column["html_type"] = "input_textarea";
break;
default:
$columnType = "string";
$column["html_type"] = "input_text";
break;
}
$column["native_type"] = $columnType;
$column["choices"] = $columnValues;
// MaxLength
if (SLS_String::contains($infoTable->Type,"(") && SLS_String::endsWith(trim($infoTable->Type),")"))
{
$maxLength = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($infoTable->Type,"("),")");
$column["max_length"] = (is_numeric($maxLength) && $maxLength > 0) ? $maxLength : "";
}
// Nullable ? unique ? default value ?
$column["required"] = ($infoTable->Null == "NO") ? "true" : "false";
$column["unique"] = ($infoTable->Key == "UNI" || in_array($column["name"],$uniquesMultilang)) ? "true" : "false";
if (empty($column["default"]))
$column["default"] = (empty($infoTable->Default)) ? "" : $infoTable->Default;
// Allow HTML & i18n
if (!empty($boPath))
{
$columnBoAttributes = array_shift($this->_xmlBo->getTagsAttributes($boPath."/columns/column[@name='".$column["name"]."']",array("allowHtml","multilanguage")));
if (!empty($columnBoAttributes))
{
$allowHtml = $columnBoAttributes["attributes"][0]["value"];
$isMultilang = $columnBoAttributes["attributes"][1]["value"];
$column["html"] = ($allowHtml == "true") ? "true" : "false";
$column["multilanguage"] = ($isMultilang == "true") ? "true" : "false";
}
}
// Specific type & extended
$typeExists = array_shift($this->_xmlType->getTagsAttributes("//sls_configs/entry[@table='".$this->_db_alias."_".$table."' and @column='".$column["name"]."']",array("type","rules","thumbs")));
if (!empty($typeExists))
{
$specificType = $typeExists["attributes"][0]["value"];
$specificRules = $typeExists["attributes"][1]["value"];
$specificThumbs = unserialize(str_replace("||#||",'"',$typeExists["attributes"][2]["value"]));
$specificTypeExtended = "";
switch($specificType)
{
case "address": /* Nothing */ break;
case "color": /* Nothing */ break;
case "email": /* Nothing */ break;
case "url": /* Nothing */ break;
case "position":
$record = array_shift($this->_db->select("SELECT MAX(`".$column["name"]."`) AS max_position FROM `".$table."` "));
$column["default"] = (!empty($record->max_position) && is_numeric($record->max_position) && $record->max_position > 0) ? ($record->max_position+1) : 1;
break;
case "uniqid":
// Generate uid
$column["default"] = substr(md5(time().substr(sha1(microtime()),0,rand(12,25))),mt_rand(1,20),(!empty($column["max_length"])) ? $column["max_length"] : 40);
break;
case (SLS_String::startsWith($specificType,"num_")):
// Get numeric settings
$specificTypeExtended = SLS_String::substrAfterFirstDelimiter($specificType,"num_");
$specificType = "numeric";
break;
case (SLS_String::startsWith($specificType,"ip_")):
// Get IP settings
$specificTypeExtended = SLS_String::substrAfterFirstDelimiter($specificType,"ip_");
$specificType = "ip";
$column["default"] = $_SERVER['REMOTE_ADDR'];
break;
case (SLS_String::startsWith($specificType,"file_")):
// Get file settings
$specificTypeExtended = SLS_String::substrAfterFirstDelimiter($specificType,"file_");
$specificType = "file";
$column["html_type"] = "input_file";
if ($specificTypeExtended == "img")
{
if (!empty($specificThumbs))
{
usort($specificThumbs,array($this,'sortThumbsMin'));
$thumb = array_shift($specificThumbs);
if (!empty($thumb["suffix"]))
$column["image_thumb"] = $thumb["suffix"];
}
$column["image_ratio"] = SLS_String::substrBeforeFirstDelimiter($specificRules,"|");
$column["image_min_width"] = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($specificRules,"|"),"|");
$column["image_min_height"] = SLS_String::substrAfterLastDelimiter($specificRules,"|");
}
break;
case ($specificType == "complexity" && (!empty($specificRules))):
// Get complexity settings & minLength
if (SLS_String::contains($specificRules,"min"))
{
$column["min_length"] = SLS_String::substrAfterFirstDelimiter($specificRules,"min");
$specificRules = SLS_String::substrBeforeFirstDelimiter($specificRules,"min");
if (SLS_String::endsWith($specificRules,"|"))
$specificRules = SLS_String::substrBeforeLastDelimiter($specificRules,"|");
}
$specificTypeExtended = $specificRules;
break;
default: $specificType = ""; break;
}
$column["specific_type"] = $specificType;
$column["specific_type_extended"] = $specificTypeExtended;
}
if (!empty($column["default"]) && SLS_String::startsWith($column["html_type"],"input_file"))
$column["default"] = (file_exists($this->_generic->getPathConfig("files").$column["default"])) ? SLS_String::getUrlFile($column["default"]) : "";
// Filters
$filters = $this->_xmlFilter->getTags("//sls_configs/entry[@table='".$this->_db_alias."_".$table."' and @column='".$column["name"]."']/@filter");
for($i=0 ; $i<$count=count($filters) ; $i++)
{
if ($filters[$i] == "hash")
$column["html_type"] = "input_password";
else
$column["filters"] .= (((!empty($column["filters"])) ? "|" : "").$filters[$i]);
}
// pk_lang
if ($needPk && $isMultilanguage && $infoTable->Field == "pk_lang")
{
$column["html_type"] = "input_radio";
$column["choices"] = $this->_lang->getSiteLangs();
}
// Fk
$columnFk = array();
$fkExists = array_shift($this->_xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".$this->_db_alias."_".$table."' and @columnFk='".$column["name"]."']",array("tablePk","labelPk")));
if (!empty($fkExists))
{
$tableAlias = $this->_db_alias;
$tableFk = $table;
$tablePk = $fkExists["attributes"][0]["value"];
$labelPk = $fkExists["attributes"][1]["value"];
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($tablePk,"_"),$tableAlias,"user");
$classFk = ucfirst($tableAlias)."_".SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($tablePk,"_"));
$objectFk = new $classFk();
$pk = $objectFk->getPrimaryKey();
$str = $labelPk;
$labelPkReal = $labelPk;
$params = $objectFk->getParams(true,true);
foreach($params as $key => $value)
{
if (is_array($value))
{
foreach($value as $key2 => $value2)
{
if (SLS_String::contains($str,$key2))
{
$this->_generic->useModel($key,$tableAlias,"user");
$classFk2 = ucfirst($tableAlias)."_".SLS_String::tableToClass($key);
$object2 = new $classFk2();
$str = str_replace($key2,$object2->getColumnComment($key2),$str);
}
}
}
else
{
if (SLS_String::contains($str,$key))
$str = str_replace($key,$objectFk->getColumnComment($key),$str);
}
}
$labelPk = $str;
$column["html_type"] = "input_ac";
$column["ac_db"] = strtolower($tableAlias);
$column["ac_entity"] = strtolower($tableFk);
$column["ac_fk"] = $tablePk;
$column["ac_column"] = $column["name"];
if (SLS_String::startsWith($labelPk,"sls:lang:"))
{
$globalKey = strtoupper(SLS_String::substrAfterFirstDelimiter($labelPk,"sls:lang:"));
$labelPk = (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$globalKey])) ? (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$globalKey]) ? $labelPk : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$globalKey]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$globalKey];
}
$column["ac_label"] = $labelPk;
$column["ac_pattern"] = $labelPkReal;
$column["ac_multiple"] = "false";
if ($column["required"] == "false")
$column["default"] = "0";
}
else
$tablePk = null;
if (empty($classFather) || (!empty($classFather) && $classFather != ucfirst($tablePk)))
$columns[$column["name"]] = $column;
}
}
return $columns;
}
public function getXML()
{
# Objects
$className = ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table);
$this->_generic->useModel(SLS_String::tableToClass($this->_table),ucfirst(strtolower($this->_db_alias)),"user");
$this->_object = new $className();
$this->_table = $this->_object->getTable();
$this->_langsValues = array();
if ($this->_object->isMultilanguage())
{
$this->_object->setModelLanguage($this->_lang->getLang());
foreach($this->_langs as $lang)
$this->_langsValues[$lang] = array();
}
else
$this->_langsValues[$this->_defaultLang] = array();
$this->_boPath = "//sls_configs/entry[@type='table' and @name='".strtolower($className)."']";
$boExists = $this->_xmlBo->getTag($this->_boPath);
if (empty($boExists))
$this->_boPath = "//sls_configs/entry/entry[@type='table' and @name='".strtolower($className)."']";
$this->_db->changeDb($this->_db_alias);
$redirects = array("list","add","edit");
# /Objects
# Model comment
$this->_tableComment = $this->_object->getTableComment($this->_table,$this->_db_alias);
if (SLS_String::startsWith($this->_tableComment,"sls:lang:"))
{
$key = strtoupper(SLS_String::substrAfterFirstDelimiter($this->_tableComment,"sls:lang:"));
$this->_tableComment = (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key])) ? (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) ? $this->_table : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key];
}
if (empty($this->_tableComment))
$this->_tableComment = $this->_table;
# /Model comment
# Params
$this->_object_id = $this->_http->getParam("id");
# /Params
# Columns definitions
$this->_columns = array();
$this->_bearers = array();
$this->_children = array();
// Model exists ?
if ($this->_object->getModel($this->_object_id) === false)
$this->_generic->forward($this->_boController,"List".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table));
// Columns
$this->_columns = $this->getTableColumns($this->_db_alias,$this->_table,$this->_boPath,"",true);
// Existing model
$modelDatas = $this->_object->searchModels($this->_table,array(),array(0=>array("column"=>$this->_object->getPrimaryKey(),"value"=>$this->_object_id,"mode"=>"equal")),array(),array($this->_object->getPrimaryKey()=>"ASC"));
for($i=0 ; $i<$count=count($modelDatas) ; $i++)
{
$lang = ($this->_object->isMultilanguage()) ? $modelDatas[$i]->pk_lang : $this->_defaultLang;
foreach($modelDatas[$i] as $modelKey => $modelValue)
{
// If pk_lang
if (in_array($modelKey,array("pk_lang")))
continue;
// Files
if (!empty($modelValue) && $this->_columns[$modelKey]["html_type"] == 'input_file')
$modelValue = SLS_String::getUrlFile($modelValue);
// MySQL Type Set
if (!empty($modelValue) && $this->_columns[$modelKey]["html_type"] == 'input_checkbox')
$modelValue = explode(",",$modelValue);
// Fk
if (!empty($modelValue) && $this->_columns[$modelKey]["html_type"] == 'input_ac')
{
$fkAlias = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($this->_columns[$modelKey]["ac_fk"],"_")));
$fkModel = SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($this->_columns[$modelKey]["ac_fk"],"_"));
$fkClass = $fkAlias."_".$fkModel;
$this->_generic->useModel($fkModel,$fkAlias,"user");
$fkObject = new $fkClass();
if ($fkObject->getModel($modelValue) == true)
{
$replacements = $fkObject->getParams();
$fkLabel = $this->_columns[$modelKey]["ac_pattern"];
foreach($replacements as $keyFk => $valueFk)
$fkLabel = str_replace($keyFk, $valueFk, $fkLabel);
$this->_columns[$modelKey]["values"][$lang][] = array("label" => $fkLabel, "value" => $modelValue);
}
else
$this->_columns[$modelKey]["values"][$lang][] = "";
}
else
{
if (!empty($modelValue) && $this->_columns[$modelKey]["html_type"] == 'input_checkbox')
$this->_columns[$modelKey]["values"][$lang] = $modelValue;
else
{
if ($this->_columns[$modelKey]["html_type"] == 'input_password')
$this->_columns[$modelKey]["values"][$lang][] = "";
else
$this->_columns[$modelKey]["values"][$lang][] = $modelValue;
}
}
}
}
// Bearers
$bearers = $this->_xmlBearer->getTagsAttributes("//sls_configs/entry[@table1='".$className."']",array("tableBearer","table2"));
if (!empty($bearers))
{
for($i=0 ; $i<$count=count($bearers) ; $i++)
{
$bearerDb = ucfirst(SLS_String::substrBeforeFirstDelimiter($bearers[$i]["attributes"][0]["value"],"_"));
$bearerTable = SLS_String::substrAfterFirstDelimiter($bearers[$i]["attributes"][0]["value"],"_");
$bearerClass = $bearers[$i]["attributes"][0]["value"];
$bearerTargetDb = ucfirst(SLS_String::substrBeforeFirstDelimiter($bearers[$i]["attributes"][1]["value"],"_"));
$bearerTargetUse = SLS_String::substrAfterFirstDelimiter($bearers[$i]["attributes"][1]["value"],"_");
$bearerTargetClass = $bearers[$i]["attributes"][1]["value"];
$this->_generic->useModel($bearerTable,$bearerDb,"user");
$this->_generic->useModel($bearerTargetUse,$bearerTargetDb,"user");
$bearerObject = new $bearerClass();
$bearerTargetObject = new $bearerTargetClass();
$bearerTargetPk = $bearerTargetObject->getPrimaryKey();
$resultFk = array_shift($this->_xmlFk->getTagsAttribute("//sls_configs/entry[@tableFk='".strtolower($bearerClass)."' and @columnFk='".$bearerTargetObject->getPrimaryKey()."' and @tablePk = '".strtolower($bearerTargetDb)."_".$bearerTargetUse."']","labelPk"));
$labelFk = (empty($resultFk)) ? $bearerTargetObject->getPrimaryKey() : $resultFk["attribute"];
$labelFkReal = $labelFk;
$str = $labelFk;
$values = array();
$masks = array();
foreach($bearerTargetObject->getParams() as $key => $value)
array_push($masks,$key);
foreach($bearerTargetObject->getParams() as $key => $value)
if (SLS_String::contains($labelFk,$key))
$labelFk = str_replace($key,$bearerTargetObject->getColumnComment($key),$labelFk);
$this->_bearers[$bearerObject->getTable()] = array("table" => $bearerObject->getTable(),
"name" => $bearerTargetPk,
"label" => $bearerObject->getTableComment($bearerObject->getTable(),$bearerDb),
"multilanguage" => "false",
"native_type" => "int",
"html_type" => "input_ac",
"specific_type" => "",
"specific_type_extended" => "",
"file_uid" => uniqid(),
"image_ratio" => "*",
"image_min_width" => "*",
"image_min_height" => "*",
"html" => "false",
"choices" => array(),
"values" => array(),
"errors" => array(),
"required" => "false",
"unique" => "false",
"default" => "",
"ac_db" => strtolower($bearerDb),
"ac_entity" => strtolower($bearerTable),
"ac_fk" => $bearerTargetClass,
"ac_column" => $bearerTargetPk,
"ac_label" => $labelFk,
"ac_pattern" => $labelFkReal,
"ac_multiple" => "true",
"min_length" => "",
"max_length" => "",
"filters" => "");
// Existing bearers
$columnFkSource = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($bearerClass)."' and @tablePk = '".$this->_db_alias."_".SLS_String::tableToClass($this->_table)."']/@columnFk");
$columnFkTarget = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($bearerClass)."' and @tablePk = '".$this->_db_alias."_".SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($bearerTargetClass,"_"))."']/@columnFk");
$clause = array(0=>array("column"=>$bearerObject->getTable().".".$columnFkSource,"value"=>$this->_object_id,"mode"=>"equal"));
if ($bearerTargetObject->isMultilanguage())
$clause[] = array("column"=>$bearerTargetObject->getTable().".pk_lang","value" => $this->_defaultLang,"mode"=>"equal");
$bearerRecordsets = $bearerObject->searchModels($bearerObject->getTable(),array(0=>array("table"=>$bearerTargetObject->getTable(),"column"=>$columnFkTarget,"mode"=>"inner")),$clause,array(),array($bearerObject->getPrimaryKey()=>"ASC"));
for($j=0 ; $j<$countJ=count($bearerRecordsets) ; $j++)
{
$bearerLabel = $labelFkReal;
foreach($bearerRecordsets[$j] as $keyBearer => $valueBearer)
$bearerLabel = str_replace($keyBearer, $valueBearer, $bearerLabel);
$this->_bearers[$bearerObject->getTable()]["values"][] = array("label" => $bearerLabel, "value" => $bearerRecordsets[$j]->{$bearerTargetObject->getPrimaryKey()});
}
}
}
// Children
$children = $this->_xmlBo->getTagsAttributes($this->_boPath."/children/child",array("table","column"));
for($i=0 ; $i<$count=count($children) ; $i++)
{
$childTable = SLS_String::substrAfterFirstDelimiter($children[$i]["attributes"][0]["value"],"_");
$childDb = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($children[$i]["attributes"][0]["value"],"_")));
if ($this->_db->tableExists($childTable))
{
$this->_generic->useModel(SLS_String::tableToClass($childTable),$childDb,"user");
$childClassName = $childDb."_".SLS_String::tableToClass($childTable);
$childObject = new $childClassName();
$childPath = "//sls_configs/entry[@type='table' and @name='".strtolower($childClassName)."']";
$childExists = $this->_xmlBo->getTag($childPath);
if (empty($childExists))
$childPath = "//sls_configs/entry/entry[@type='table' and @name='".strtolower($childClassName)."']";
$childComment = $this->_object->getTableComment($childTable,$this->_db_alias);
if (SLS_String::startsWith($childComment,"sls:lang:"))
{
$key = strtoupper(SLS_String::substrAfterFirstDelimiter($childComment,"sls:lang:"));
$childComment = (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key])) ? (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) ? $childTable : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key];
}
if (empty($childComment))
$childComment = $childTable;
$this->_children[$childTable] = array("model" => array("db" => strtolower($childDb),
"table" => $childTable,
"label" => $childComment,
"nbChildren" => 0,
"multilanguage" => ($childObject->isMultilanguage()) ? "true" : "false",
"pk" => $childObject->getPrimaryKey()),
"urls" => array("list" => array("url" => ($this->_generic->getActionId($this->_boController,"List".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable)) != null) ? $this->_generic->getFullPath($this->_boController,"List".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable),array(),true) : "", "authorized" => (SLS_BoRights::isAuthorized("read",ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable))) ? "true" : "false"),
"add" => array("url" => ($this->_generic->getActionId($this->_boController,"Add".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable)) != null) ? $this->_generic->getFullPath($this->_boController,"Add".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable),array(),true) : "", "authorized" => (SLS_BoRights::isAuthorized("add",ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable))) ? "true" : "false"),
"populate" => array("url" => ($this->_generic->getActionId($this->_boController,"BoPopulate".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable)) != null) ? $this->_generic->getFullPath($this->_boController,"Populate".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable),array(),true) : "", "authorized" => (SLS_BoRights::getAdminType() == "developer") ? "true" : "false"),
"edit" => array("url" => ($this->_generic->getActionId($this->_boController,"Modify".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable)) != null) ? $this->_generic->getFullPath($this->_boController,"Modify".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable),array("id"=>""),false) : "", "authorized" => (SLS_BoRights::isAuthorized("edit",ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable))) ? "true" : "false"),
"clone" => array("url" => ($this->_generic->getActionId($this->_boController,"Clone".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable)) != null) ? $this->_generic->getFullPath($this->_boController,"Clone".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable),array("id"=>""),false) : "", "authorized" => (SLS_BoRights::isAuthorized("clone",ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable))) ? "true" : "false"),
"delete" => array("url" => ($this->_generic->getActionId($this->_boController,"Delete".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable)) != null) ? $this->_generic->getFullPath($this->_boController,"Delete".ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable),array("id"=>""),false) : "", "authorized" => (SLS_BoRights::isAuthorized("delete",ucfirst(strtolower($childDb))."_".SLS_String::tableToClass($childTable))) ? "true" : "false")),
"columns" => $this->getTableColumns($this->_db_alias,$childTable,$childPath,$className,true),
"bearers" => array());
// Existing children
$columnFk = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($childClassName)."' and @tablePk = '".$this->_db_alias."_".SLS_String::tableToClass($this->_table)."']/@columnFk");
$childrenRecordsets = $childObject->searchModels($childObject->getTable(),array(),array(0=>array("column"=>$columnFk,"value"=>$this->_object_id,"mode"=>"equal")),array(),array($childObject->getPrimaryKey()=>"ASC"));
$this->_children[$childTable]["model"]["nbChildren"] = ($childObject->isMultilanguage()) ? count($childrenRecordsets) / count($this->_langs) : count($childrenRecordsets);
$childrenIds = array();
for($j=0 ; $j<$countJ=count($childrenRecordsets) ; $j++)
{
$lang = ($childObject->isMultilanguage()) ? $childrenRecordsets[$j]->pk_lang : $this->_defaultLang;
if (!in_array($childrenRecordsets[$j]->{$childObject->getPrimaryKey()},$childrenIds))
$childrenIds[] = $childrenRecordsets[$j]->{$childObject->getPrimaryKey()};
$childrenItem = array_shift(array_keys($childrenIds,$childrenRecordsets[$j]->{$childObject->getPrimaryKey()}));
foreach($childrenRecordsets[$j] as $childRecordKey => $childRecordValue)
{
// If pk_lang or current father fk, skip
if (in_array($childRecordKey,array("pk_lang",$columnFk)))
continue;
// Files
if (!empty($childRecordValue) && $this->_children[$childTable]["columns"][$childRecordKey]["html_type"] == 'input_file')
$childRecordValue = SLS_String::getUrlFile($childRecordValue);
// MySQL Type Set
if (!empty($childRecordValue) && $this->_children[$childTable]["columns"][$childRecordKey]["html_type"] == 'input_checkbox')
$childRecordValue = explode(",",$childRecordValue);
// Fk
if (!empty($childRecordValue) && $this->_children[$childTable]["columns"][$childRecordKey]["html_type"] == 'input_ac')
{
$fkAlias = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($this->_children[$childTable]["columns"][$childRecordKey]["ac_fk"],"_")));
$fkModel = SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($this->_children[$childTable]["columns"][$childRecordKey]["ac_fk"],"_"));
$fkClass = $fkAlias."_".$fkModel;
$this->_generic->useModel($fkModel,$fkAlias,"user");
$fkObject = new $fkClass();
if ($fkObject->getModel($childRecordValue) == true)
{
$replacements = $fkObject->getParams();
$fkLabel = $this->_children[$childTable]["columns"][$childRecordKey]["ac_pattern"];
foreach($replacements as $keyFk => $valueFk)
$fkLabel = str_replace($keyFk, $valueFk, $fkLabel);
$this->_children[$childTable]["columns"][$childRecordKey]["values"][$childrenItem][$lang][] = array("label" => $fkLabel, "value" => $childRecordValue);
}
else
$this->_children[$childTable]["columns"][$childRecordKey]["values"][$childrenItem][$lang][] = "";
}
else
{
if (!empty($childRecordValue) && $this->_children[$childTable]["columns"][$childRecordKey]["html_type"] == 'input_checkbox')
$this->_children[$childTable]["columns"][$childRecordKey]["values"][$childrenItem][$lang] = $childRecordValue;
else
$this->_children[$childTable]["columns"][$childRecordKey]["values"][$childrenItem][$lang][] = $childRecordValue;
}
}
}
// Bearers
$bearers = $this->_xmlBearer->getTagsAttributes("//sls_configs/entry[@table1='".$childClassName."']",array("tableBearer","table2"));
if (!empty($bearers))
{
for($i=0 ; $i<$count=count($bearers) ; $i++)
{
$bearerDb = ucfirst(SLS_String::substrBeforeFirstDelimiter($bearers[$i]["attributes"][0]["value"],"_"));
$bearerTable = SLS_String::substrAfterFirstDelimiter($bearers[$i]["attributes"][0]["value"],"_");
$bearerClass = $bearers[$i]["attributes"][0]["value"];
$bearerTargetDb = ucfirst(SLS_String::substrBeforeFirstDelimiter($bearers[$i]["attributes"][1]["value"],"_"));
$bearerTargetUse = SLS_String::substrAfterFirstDelimiter($bearers[$i]["attributes"][1]["value"],"_");
$bearerTargetClass = $bearers[$i]["attributes"][1]["value"];
$this->_generic->useModel($bearerTable,$bearerDb,"user");
$this->_generic->useModel($bearerTargetUse,$bearerTargetDb,"user");
$bearerObject = new $bearerClass();
$bearerTargetObject = new $bearerTargetClass();
$bearerTargetPk = $bearerTargetObject->getPrimaryKey();
$resultFk = array_shift($this->_xmlFk->getTagsAttribute("//sls_configs/entry[@tableFk='".strtolower($bearerClass)."' and @columnFk='".$bearerTargetObject->getPrimaryKey()."' and @tablePk = '".strtolower($bearerTargetDb)."_".$bearerTargetUse."']","labelPk"));
$labelFk = (empty($resultFk)) ? $bearerTargetObject->getPrimaryKey() : $resultFk["attribute"];
$labelFkReal = $labelFk;
$str = $labelFk;
$values = array();
$masks = array();
foreach($bearerTargetObject->getParams() as $key => $value)
array_push($masks,$key);
foreach($bearerTargetObject->getParams() as $key => $value)
if (SLS_String::contains($labelFk,$key))
$labelFk = str_replace($key,$bearerTargetObject->getColumnComment($key),$labelFk);
$this->_children[$childTable]["bearers"][$bearerObject->getTable()] = array("table" => $bearerObject->getTable(),
"name" => $bearerTargetPk,
"label" => $bearerObject->getTableComment($bearerObject->getTable(),$bearerDb),
"multilanguage" => "false",
"native_type" => "int",
"html_type" => "input_ac",
"specific_type" => "",
"specific_type_extended" => "",
"file_uid" => uniqid(),
"image_ratio" => "*",
"image_min_width" => "*",
"image_min_height" => "*",
"html" => "false",
"choices" => array(),
"values" => array(),
"errors" => array(),
"required" => "false",
"unique" => "false",
"default" => "",
"ac_db" => strtolower($bearerDb),
"ac_entity" => strtolower($bearerTable),
"ac_fk" => $bearerTargetClass,
"ac_column" => $bearerTargetPk,
"ac_label" => $labelFk,
"ac_pattern" => $labelFkReal,
"ac_multiple" => "true",
"min_length" => "",
"max_length" => "",
"filters" => "");
$columnFkSource = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($bearerClass)."' and @tablePk = '".$this->_db_alias."_".SLS_String::tableToClass($childObject->getTable())."']/@columnFk");
$columnFkTarget = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($bearerClass)."' and @tablePk = '".$this->_db_alias."_".SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($bearerTargetClass,"_"))."']/@columnFk");
$clause = (!empty($childrenIds)) ? array(0=>array("column"=>$bearerObject->getTable().".".$columnFkSource,"value"=>$childrenIds,"mode"=>"in")) : array();
if ($bearerTargetObject->isMultilanguage())
$clause[] = array("column"=>$bearerTargetObject->getTable().".pk_lang","value" => $this->_defaultLang,"mode"=>"equal");
$bearerRecordsets = $bearerObject->searchModels($bearerObject->getTable(),array(0=>array("table"=>$bearerTargetObject->getTable(),"column"=>$columnFkTarget,"mode"=>"inner")),$clause,array(),array($bearerObject->getPrimaryKey()=>"ASC"));
for($j=0 ; $j<$countJ=count($bearerRecordsets) ; $j++)
{
$bearerLabel = $labelFkReal;
foreach($bearerRecordsets[$j] as $keyBearer => $valueBearer)
$bearerLabel = str_replace($keyBearer, $valueBearer, $bearerLabel);
$this->_children[$childTable]["bearers"][$bearerObject->getTable()]["values"][array_shift(array_keys($childrenIds,$bearerRecordsets[$j]->{$columnFkSource}))][] = array("label" => $bearerLabel, "value" => $bearerRecordsets[$j]->{$bearerTargetObject->getPrimaryKey()});
}
}
}
}
}
# /Columns definitions
# Reload
$this->_error = false;
$this->_recordsets = array();
if ($this->_http->getParam("reload-edit") == "true")
{
$modelParams = (is_array($this->_http->getParam($this->_table))) ? $this->_http->getParam($this->_table) : array();
$properties = (is_array($modelParams["properties"])) ? $modelParams["properties"] : array();
$bearers = (is_array($modelParams["bearers"])) ? $modelParams["bearers"] : array();
$children = (is_array($modelParams["children"])) ? $modelParams["children"] : array();
$childrenToDelete = (is_array($modelParams["children-to-delete"])) ? $modelParams["children-to-delete"] : array();
$redirect = (in_array(strtolower($this->_http->getParam("redirect")),$redirects)) ? strtolower($this->_http->getParam("redirect")) : array_shift($redirects);
# MAIN MODEL
uksort($properties,array($this, 'unshiftDefaultLang'));
foreach($properties as $lang => $columns)
{
$this->_object->setModelLanguage($lang);
if (!empty($columns))
{
foreach(((is_array($columns)) ? $columns : array($columns)) as $column => $value)
{
// Reset old value
$this->_columns[$column]["values"][$lang] = array();
$functionName = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$column)," ",false)),"");
// Remember values
if (is_array($value) && array_key_exists("file",$value))
{
$value = $value["file"];
if (!is_array($value))
$value = SLS_String::substrAfterFirstDelimiter($value,$this->_generic->getPathConfig("files"));
}
else if (is_array($value))
{
$this->_columns[$column]["values"][$lang] = $value;
// MySQL Type Set
if ($this->_columns[$column]["specific_type"] != 'file')
$value = implode(",",$value);
}
else
{
// Check FK
if (!empty($value) && $this->_columns[$column]["html_type"] == 'input_ac')
{
$fkAlias = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($this->_columns[$column]["ac_fk"],"_")));
$fkModel = SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($this->_columns[$column]["ac_fk"],"_"));
$fkClass = $fkAlias."_".$fkModel;
$this->_generic->useModel($fkModel,$fkAlias,"user");
$fkObject = new $fkClass();
if ($fkObject->getModel($value) == true)
{
$replacements = $fkObject->getParams();
$fkLabel = $this->_columns[$column]["ac_pattern"];
foreach($replacements as $keyFk => $valueFk)
$fkLabel = str_replace($keyFk, $valueFk, $fkLabel);
$this->_columns[$column]["values"][$lang][] = array("label" => $fkLabel, "value" => $value);
}
else
$this->_columns[$column]["values"][$lang][] = "";
}
else
$this->_columns[$column]["values"][$lang][] = $value;
}
// Setter
if (!$this->_object->$functionName($value))
{
$this->_error = true;
$this->_columns[$column]["errors"][$lang] = $this->_object->getError($column);
if ($this->_async)
$this->_render["errors"][$column] = $this->_columns[$column]["label"]." ".$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_'.strtoupper($this->_columns[$column]["errors"][$lang])];
}
// Remember value type file
if ($this->_columns[$column]["html_type"] == 'input_file')
{
// No error, take model value
if (empty($this->_columns[$column]["errors"][$lang]))
{
$fileValue = $this->_object->__get($column);
$this->_columns[$column]["values"][$lang][] = (!empty($fileValue)) ? SLS_String::getUrlFile($fileValue) : "";
}
// Else, take uploaded file
else
{
// Modern browsers
if (array_key_exists("data",$value))
$value = $value["data"];
if (is_array($value) && array_key_exists("tmp_name",$value))
$this->_columns[$column]["values"][$lang][] = $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$value["tmp_name"];
}
}
}
}
$this->_object->save();
}
# /MAIN MODEL
# CHILDREN
foreach($children as $childTable => $childValues)
{
$this->_generic->useModel(SLS_String::tableToClass($childTable),$this->_db_alias,"user");
$childClassName = $this->_db_alias."_".SLS_String::tableToClass($childTable);
$childObject = new $childClassName();
$this->_recordsets[$childTable]["pk"] = $childObject->getPrimaryKey();
$this->_children[$childTable]["model"]["nbChildren"] = (is_array($childValues)) ? count($childValues) : 1;
foreach(((is_array($childValues)) ? $childValues : array($childValues)) as $childItem => $infos)
{
// Child
$properties = (is_array($infos["properties"])) ? $infos["properties"] : array($infos["properties"]);
uksort($properties,array($this, 'unshiftDefaultLang'));
$childId = $properties[$this->_defaultLang][$childObject->getPrimaryKey()];
$needToCreate = (empty($childId)) ? true : false;
if ($needToCreate)
$this->_recordsets[$childTable]["ids"][] = $childId = $childObject->giveNextId();
foreach($properties as $lang => $columns)
{
$childObject->setModelLanguage($lang);
if (!$needToCreate)
$childObject->getModel($childId);
foreach(((is_array($columns)) ? $columns : array($columns)) as $column => $value)
{
// Exclude pk if existed (update)
if ($column == $this->_recordsets[$childTable]["pk"])
continue;
$functionName = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$column)," ",false)),"");
// Remember values
if (is_array($value) && array_key_exists("file",$value))
{
$value = $value["file"];
if (!is_array($value))
$value = SLS_String::substrAfterFirstDelimiter($value,$this->_generic->getPathConfig("files"));
}
else if (is_array($value))
{
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang] = $value;
// MySQL Type Set
if ($this->_children[$childTable]["columns"][$column]["specific_type"] != 'file')
$value = implode(",",$value);
}
else
{
// Check FK
if (!empty($value) && $this->_children[$childTable]["columns"][$column]["html_type"] == 'input_ac')
{
$fkAlias = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($this->_children[$childTable]["columns"][$column]["ac_fk"],"_")));
$fkModel = SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($this->_children[$childTable]["columns"][$column]["ac_fk"],"_"));
$fkClass = $fkAlias."_".$fkModel;
$this->_generic->useModel($fkModel,$fkAlias,"user");
$fkObject = new $fkClass();
if ($fkObject->getModel($value) == true)
{
$replacements = $fkObject->getParams();
$fkLabel = $this->_children[$childTable]["columns"][$column]["ac_pattern"];
foreach($replacements as $keyFk => $valueFk)
$fkLabel = str_replace($keyFk, $valueFk, $fkLabel);
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang][] = array("label" => $fkLabel, "value" => $value);
}
else
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang][] = "";
}
else
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang][] = $value;
}
// Setter
if (!$childObject->$functionName($value))
{
$this->_error = true;
$this->_children[$childTable]["columns"][$column]["errors"][$childItem][$lang] = $childObject->getError($column);
}
else
$this->_children[$childTable]["columns"][$column]["errors"][$childItem][$lang] = "";
// Remember value type file
if ($this->_children[$childTable]["columns"][$column]["html_type"] == 'input_file')
{
// No error, take model value
if (empty($this->_children[$childTable]["columns"][$column]["errors"][$childItem][$lang]))
{
$fileValue = $childObject->__get($column);
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang][] = (!empty($fileValue)) ? SLS_String::getUrlFile($fileValue) : "";
}
// Else, take uploaded file
else
{
// Modern browsers
if (is_array($value) && array_key_exists("data",$value))
$value = $value["data"];
if (is_array($value) && array_key_exists("tmp_name",$value))
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang][] = $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$value["tmp_name"];
else
$this->_children[$childTable]["columns"][$column]["values"][$childItem][$lang][] = "";
}
}
}
// Force fk setter
$fkColumn = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($childClassName)."' and @tablePk='".$this->_db_alias."_".SLS_String::tableToClass($this->_table)."']/@columnFk");
if (!empty($fkColumn))
{
$functionName = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$fkColumn)," ",false)),"");
$childObject->$functionName($this->_object_id);
}
// Create or save
if ($needToCreate)
$childObject->create();
else
$childObject->save();
}
$childObject->clear();
// Bearers
$childBearers = (!empty($infos["bearers"])) ? ((is_array($infos["bearers"])) ? $infos["bearers"] : array($infos["bearers"])) : array();
foreach($childBearers as $bearerTable => $bearerValues)
{
// Bearer object
$bearerClass = ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($bearerTable);
$bearerAttributes = array_shift($this->_xmlBearer->getTagsAttributes("//sls_configs/entry[@tableBearer='".$bearerClass."']",array("table1","table2")));
$this->_generic->useModel(SLS_String::tableToClass($bearerTable),$this->_db_alias,"user");
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($bearerAttributes["attributes"][0]["value"],"_"),SLS_String::substrBeforeFirstDelimiter($bearerAttributes["attributes"][0]["value"],"_"));
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($bearerAttributes["attributes"][1]["value"],"_"),SLS_String::substrBeforeFirstDelimiter($bearerAttributes["attributes"][1]["value"],"_"));
$bearerObject = new $bearerClass();
$this->_recordsets[$bearerObject->getTable()]["pk"] = $bearerObject->getPrimaryKey();
$objectBearerTarget1 = new $bearerAttributes["attributes"][0]["value"]();
$objectBearerTarget2 = new $bearerAttributes["attributes"][1]["value"]();
$setterBearerTarget1 = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$objectBearerTarget1->getPrimaryKey())," ",false)),"");
$setterBearerTarget2 = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$objectBearerTarget2->getPrimaryKey())," ",false)),"");
$fkColumn = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($bearerObject->getDatabase())."_".$bearerObject->getTable()."' and @tablePk='".strtolower($bearerObject->getDatabase())."_".SLS_String::substrAfterFirstDelimiter($bearerAttributes["attributes"][0]["value"],"_")."']/@columnFk");
// Delete old bearers
$bearerObject->deleteModels($bearerObject->getTable(),array(),array(0=>array("column"=>$fkColumn,"value"=>$childId,"mode"=>"equal")));
// Save new bearers
foreach($bearerValues as $bearerValue)
{
if ($objectBearerTarget2->getModel($bearerValue) === true)
{
$replacements = $objectBearerTarget2->getParams();
$bearerLabel = $this->_children[$childTable]["bearers"][$bearerObject->getTable()]["ac_pattern"];
foreach($replacements as $keyBearer => $valueBearer)
$bearerLabel = str_replace($keyBearer, $valueBearer, $bearerLabel);
$this->_children[$childTable]["bearers"][$bearerObject->getTable()]["values"][$childItem][] = array("label" => $bearerLabel, "value" => $bearerValue);
if (!$this->_error)
{
$bearerObject->$setterBearerTarget1($childId);
$bearerObject->$setterBearerTarget2($bearerValue);
$bearerObjectId = $bearerObject->create();
$this->_recordsets[$bearerObject->getTable()]["ids"][] = $bearerObjectId;
$bearerObject->clear();
}
}
}
}
}
}
# /CHILDREN
# BEARERS
foreach($bearers as $bearerTable => $bearerValues)
{
// Bearer object
$bearerClass = ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($bearerTable);
$bearerAttributes = array_shift($this->_xmlBearer->getTagsAttributes("//sls_configs/entry[@tableBearer='".$bearerClass."']",array("table1","table2")));
$this->_generic->useModel(SLS_String::tableToClass($bearerTable),$this->_db_alias,"user");
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($bearerAttributes["attributes"][0]["value"],"_"),SLS_String::substrBeforeFirstDelimiter($bearerAttributes["attributes"][0]["value"],"_"));
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($bearerAttributes["attributes"][1]["value"],"_"),SLS_String::substrBeforeFirstDelimiter($bearerAttributes["attributes"][1]["value"],"_"));
$bearerObject = new $bearerClass();
$this->_recordsets[$bearerObject->getTable()]["pk"] = $bearerObject->getPrimaryKey();
$objectBearerTarget1 = new $bearerAttributes["attributes"][0]["value"]();
$objectBearerTarget2 = new $bearerAttributes["attributes"][1]["value"]();
$setterBearerTarget1 = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$objectBearerTarget1->getPrimaryKey())," ",false)),"");
$setterBearerTarget2 = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$objectBearerTarget2->getPrimaryKey())," ",false)),"");
$fkColumn = $this->_xmlFk->getTag("//sls_configs/entry[@tableFk='".strtolower($bearerObject->getDatabase())."_".$bearerObject->getTable()."' and @tablePk='".strtolower($bearerObject->getDatabase())."_".SLS_String::substrAfterFirstDelimiter($bearerAttributes["attributes"][0]["value"],"_")."']/@columnFk");
// Delete old bearers
$bearerObject->deleteModels($bearerObject->getTable(),array(),array(0=>array("column"=>$fkColumn,"value"=>$this->_object_id,"mode"=>"equal")));
// Save new bearers
foreach($bearerValues as $bearerValue)
{
if ($objectBearerTarget2->getModel($bearerValue) === true)
{
$replacements = $objectBearerTarget2->getParams();
$bearerLabel = $this->_bearers[$bearerObject->getTable()]["ac_pattern"];
foreach($replacements as $keyBearer => $valueBearer)
$bearerLabel = str_replace($keyBearer, $valueBearer, $bearerLabel);
$this->_bearers[$bearerObject->getTable()]["values"][] = array("label" => $bearerLabel, "value" => $bearerValue);
if (!$this->_error)
{
$bearerObject->$setterBearerTarget1($this->_object_id);
$bearerObject->$setterBearerTarget2($bearerValue);
$bearerObjectId = $bearerObject->create();
$this->_recordsets[$bearerObject->getTable()]["ids"][] = $bearerObjectId;
$bearerObject->clear();
}
}
}
}
# /BEARERS
# CHILDREN-TO-DELETE
foreach($childrenToDelete as $childTable => $childValues)
{
$this->_generic->useModel(SLS_String::tableToClass($childTable),$this->_db_alias,"user");
$childClassName = $this->_db_alias."_".SLS_String::tableToClass($childTable);
$childObject = new $childClassName();
foreach(((is_array($childValues)) ? $childValues : array($childValues)) as $childToDelete)
{
if ($childObject->getModel($childToDelete) === true)
$childObject->delete(true);
}
}
# /CHILDREN-TO-DELETE
# If error, delete model & linked recordsets
if ($this->_error && $this->_object->getModel($this->_object_id))
{
if ($this->_async)
{
$this->_render["message"] = sprintf($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_ERROR'],$this->_lang->getLang());
// Render
echo json_encode($this->_render);
die();
}
}
# /Errors
# All good dude !
if (!$this->_error)
{
if ($this->_async)
{
$this->_render["status"] = "OK";
$this->_render["message"] = $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_GENERIC_SUBMIT_SUCCESS_EDIT'];
}
else
{
$this->pushNotif("success",$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_GENERIC_SUBMIT_SUCCESS_EDIT']);
if ($this->_forward)
{
switch ($redirect)
{
case "edit":
# Remember admin settings
$nodeExists = $this->_xmlRight->getTag("//sls_configs/entry[@login='******']/@login");
if (!empty($nodeExists))
{
$this->_xmlRight->setTag("//sls_configs/entry[@login='******']/settings/setting[@key='edit_callback']","edit");
$this->_xmlRight->saveXML($this->_generic->getPathConfig("configSls")."/rights.xml");
$this->_xmlRight->refresh();
}
# /Remember admin settings
$this->_generic->forward($this->_boController,"Modify".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table),array("id"=>$this->_object_id));
break;
case "list":
# Remember admin settings
$nodeExists = $this->_xmlRight->getTag("//sls_configs/entry[@login='******']/@login");
if (!empty($nodeExists))
{
$this->_xmlRight->setTag("//sls_configs/entry[@login='******']/settings/setting[@key='edit_callback']","list");
$this->_xmlRight->saveXML($this->_generic->getPathConfig("configSls")."/rights.xml");
$this->_xmlRight->refresh();
}
# /Remember admin settings
$rememberList = (is_array($this->_session->getParam("SLS_BO_LIST"))) ? $this->_session->getParam("SLS_BO_LIST") : array();
if (array_key_exists($this->_db_alias."_".$this->_table,$rememberList) && !empty($rememberList[$this->_db_alias."_".$this->_table]))
$this->_generic->redirect($rememberList[$this->_db_alias."_".$this->_table]);
else
$this->_generic->forward($this->_boController,"List".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table));
break;
}
}
}
}
# /All good dude !
}
# /Reload
# Page infos
$langsError = array();
$columnValues = array();
$this->_xml->startTag("page");
$this->_xml->startTag("model");
$this->_xml->addFullTag("db",$this->_db_alias,true);
$this->_xml->addFullTag("table",$this->_table,true);
$this->_xml->addFullTag("label",$this->_tableComment,true);
$this->_xml->addFullTag("multilanguage",($this->_object->isMultilanguage()) ? "true" : "false",true);
$this->_xml->addFullTag("pk",$this->_object->getPrimaryKey(),true);
$this->_xml->endTag("model");
$this->_xml->startTag("urls");
$this->_xml->addFullTag("list",($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"List".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)))) ? $this->_generic->getFullPath($this->_boController,"List".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)) : "",true,array("authorized" => (SLS_BoRights::isAuthorized("read",ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table))) ? "true" : "false"));
$this->_xml->addFullTag("add",($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"Add".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)))) ? $this->_generic->getFullPath($this->_boController,"Add".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)) : "",true,array("authorized" => (SLS_BoRights::isAuthorized("add",ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table))) ? "true" : "false"));
$this->_xml->addFullTag("populate",$this->_generic->getFullPath($this->_boController,"BoPopulate",array("Db" => ucfirst(strtolower($this->_db_alias)), "Table" => $this->_table)),true,array("authorized" => (SLS_BoRights::getAdminType() == "developer") ? "true" : "false"));
$this->_xml->addFullTag("edit",($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"Modify".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)))) ? $this->_generic->getFullPath($this->_boController,"Modify".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table),array("id" => ""),false) : "",true,array("authorized" => (SLS_BoRights::isAuthorized("edit",ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table))) ? "true" : "false"));
$this->_xml->addFullTag("clone",($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"Clone".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)))) ? $this->_generic->getFullPath($this->_boController,"Clone".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table),array("id" => ""),false) : "",true,array("authorized" => (SLS_BoRights::isAuthorized("clone",ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table))) ? "true" : "false"));
$this->_xml->addFullTag("delete",($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"Delete".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table)))) ? $this->_generic->getFullPath($this->_boController,"Delete".ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table),array("id" => ""),false) : "",true,array("authorized" => (SLS_BoRights::isAuthorized("delete",ucfirst(strtolower($this->_db_alias))."_".SLS_String::tableToClass($this->_table))) ? "true" : "false"));
$this->_xml->endTag("urls");
$this->_xml->startTag("columns");
foreach($this->_columns as $columnName => $infosColumn)
{
$this->_xml->startTag("column");
foreach($infosColumn as $key => $value)
{
if (is_array($value) && !in_array($key,array("choices","values","errors")))
continue;
if ($key == "choices")
{
$this->_xml->startTag("choices");
foreach($value as $currentValue)
$this->_xml->addFullTag("choice",$currentValue,true);
$this->_xml->endTag("choices");
}
else if ($key == "values")
{
$this->_xml->startTag("values");
foreach($value as $currentLang => $values)
{
if ($this->_async)
{
if (empty($columnValues[$columnName]))
{
if ($this->_object->isMultilanguage() && $this->_columns[$columnName]["multilanguage"] == "true" && $currentLang == $this->_lang->getLang())
{
$columnValues[$columnName] = ($columnName == "pk_lang") ? $this->_lang->getLang() : $values;
}
else if ($currentLang == $this->_defaultLang)
{
$columnValues[$columnName] = ($columnName == "pk_lang") ? $this->_lang->getLang() : $values;
}
}
}
foreach($values as $currentValue)
{
if (is_array($currentValue))
$this->_xml->addFullTag("value",$currentValue["value"],true,array("lang"=>$currentLang,"label"=>$currentValue["label"]));
else
{
if ($this->_columns[$columnName]["specific_type"] == 'file' && $this->_columns[$columnName]["specific_type_extended"] == 'all')
{
$img = "false";
if (file_exists($this->_generic->getPathConfig("coreImg")."BO-2014/Mime-Types/".strtolower(str_replace("/","-",SLS_String::getExtensionMimeType(SLS_String::substrAfterLastDelimiter($currentValue,"."))).".png")))
{
$mime = $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$this->_generic->getPathConfig("coreImg")."BO-2014/Mime-Types/".strtolower(str_replace("/","-",SLS_String::getExtensionMimeType(SLS_String::substrAfterLastDelimiter($currentValue,"."))).".png");
if (SLS_String::startsWith(SLS_String::getExtensionMimeType(SLS_String::substrAfterLastDelimiter($currentValue,".")),"image/"))
$img = "true";
}
else
$mime = $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$this->_generic->getPathConfig("coreImg")."BO-2014/Mime-Types/application-octet-stream.png";
$this->_xml->addFullTag("value",$currentValue,true,array("lang"=>$currentLang,"img"=>$img,"mime"=>$mime));
}
else if ($this->_columns[$columnName]["specific_type"] == 'file' && $this->_columns[$columnName]["specific_type_extended"] == 'img')
{
$image = $currentValue;
if (SLS_String::contains($image,$this->_generic->getSiteConfig("domainName")."/"))
$image = SLS_String::substrAfterFirstDelimiter($image,$this->_generic->getSiteConfig("domainName")."/");
$this->_xml->addFullTag("value",$currentValue,true,array("lang"=>$currentLang,"size"=>(file_exists($image)) ? filesize($image) : 0));
}
else
$this->_xml->addFullTag("value",$currentValue,true,array("lang"=>$currentLang));
}
}
}
$this->_xml->endTag("values");
}
else if ($key == "errors")
{
$this->_xml->startTag("errors");
foreach($value as $currentLang => $currentValue)
{
$this->_xml->addFullTag("error",$infosColumn["label"]." ".$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_'.strtoupper($currentValue)],true,array("lang"=>$currentLang));
if (!in_array($currentLang,$langsError))
{
$this->pushNotif("error",sprintf($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_ERROR'],$currentLang));
$langsError[] = $currentLang;
}
}
$this->_xml->endTag("errors");
}
else
$this->_xml->addFullTag($key,$value,true);
}
$this->_xml->endTag("column");
}
$this->_xml->endTag("columns");
// If quick-edit view
if ($this->_async)
{
// Render
$this->_render["status"] = "OK";
$this->_render["result"] = $columnValues;
echo json_encode($this->_render);
die();
}
$this->_xml->startTag("bearers");
foreach($this->_bearers as $bearerTable => $infosColumn)
{
$this->_xml->startTag("column");
foreach($infosColumn as $key => $value)
{
if (is_array($value) && !in_array($key,array("choices","values")))
continue;
if ($key == "choices")
{
$this->_xml->startTag("choices");
foreach($value as $currentValue)
$this->_xml->addFullTag("choice",$currentValue,true);
$this->_xml->endTag("choices");
}
else if ($key == "values")
{
$this->_xml->startTag("values");
foreach($value as $currentValue => $currentValues)
$this->_xml->addFullTag("value",$currentValues["value"],true,array("lang"=>$this->_defaultLang,"label"=>$currentValues["label"]));
$this->_xml->endTag("values");
}
else
$this->_xml->addFullTag($key,$value,true);
}
$this->_xml->endTag("column");
}
$this->_xml->endTag("bearers");
$this->_xml->startTag("children");
foreach($this->_children as $childTable => $childInfos)
{
$this->_xml->startTag("child");
$this->_xml->startTag("model");
foreach($childInfos["model"] as $key => $value)
$this->_xml->addFullTag($key,$value,true);
$this->_xml->endTag("model");
$this->_xml->startTag("urls");
foreach($childInfos["urls"] as $key => $value)
$this->_xml->addFullTag($key,$value["url"],true,array("authorized" => $value["authorized"]));
$this->_xml->endTag("urls");
$this->_xml->startTag("columns");
foreach($childInfos["columns"] as $columnName => $infosColumn)
{
$this->_xml->startTag("column");
foreach($infosColumn as $key => $value)
{
if (is_array($value) && !in_array($key,array("choices","values","errors")))
continue;
if ($key == "choices")
{
$this->_xml->startTag("choices");
foreach($value as $currentValue)
$this->_xml->addFullTag("choice",$currentValue,true);
$this->_xml->endTag("choices");
}
else if ($key == "values")
{
$this->_xml->startTag("values");
foreach($value as $offset => $valuesChildren)
{
$this->_xml->startTag("record");
foreach($valuesChildren as $currentLang => $values)
{
foreach($values as $currentValue)
{
if (is_array($currentValue))
$this->_xml->addFullTag("value",$currentValue["value"],true,array("lang"=>$currentLang,"label"=>$currentValue["label"]));
else
{
if ($this->_children[$childTable]["columns"][$columnName]["specific_type"] == 'file' && $this->_children[$childTable]["columns"][$columnName]["specific_type_extended"] == 'all')
{
$img = "false";
if (file_exists($this->_generic->getPathConfig("coreImg")."BO-2014/Mime-Types/".strtolower(str_replace("/","-",SLS_String::getExtensionMimeType(SLS_String::substrAfterLastDelimiter($currentValue,"."))).".png")))
{
$mime = $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$this->_generic->getPathConfig("coreImg")."BO-2014/Mime-Types/".strtolower(str_replace("/","-",SLS_String::getExtensionMimeType(SLS_String::substrAfterLastDelimiter($currentValue,"."))).".png");
if (SLS_String::startsWith(SLS_String::getExtensionMimeType(SLS_String::substrAfterLastDelimiter($currentValue,".")),"image/"))
$img = "true";
}
else
$mime = $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$this->_generic->getPathConfig("coreImg")."BO-2014/Mime-Types/application-octet-stream.png";
$this->_xml->addFullTag("value",$currentValue,true,array("lang"=>$currentLang,"img"=>$img,"mime"=>$mime));
}
else if ($this->_children[$childTable]["columns"][$columnName]["specific_type"] == 'file' && $this->_children[$childTable]["columns"][$columnName]["specific_type_extended"] == 'img')
{
$image = $currentValue;
if (SLS_String::contains($image,$this->_generic->getSiteConfig("domainName")."/"))
$image = SLS_String::substrAfterFirstDelimiter($image,$this->_generic->getSiteConfig("domainName")."/");
$this->_xml->addFullTag("value",$currentValue,true,array("lang"=>$currentLang,"size"=>(file_exists($image)) ? filesize($image) : 0));
}
else
$this->_xml->addFullTag("value",$currentValue,true,array("lang"=>$currentLang));
}
}
}
$this->_xml->endTag("record");
}
$this->_xml->endTag("values");
}
else if ($key == "errors")
{
$this->_xml->startTag("errors");
foreach($value as $currentLang => $currentValues)
{
$this->_xml->startTag("record");
foreach($currentValues as $currentLang => $currentValue)
{
if (!empty($currentValue))
{
$this->_xml->addFullTag("error",$infosColumn["label"]." ".$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_'.strtoupper($currentValue)],true,array("lang"=>$currentLang));
if (!in_array($currentLang,$langsError))
{
$this->pushNotif("error",sprintf($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_ERROR'],$currentLang));
$langsError[] = $currentLang;
}
}
else
$this->_xml->addFullTag("error","",true,array("lang"=>$currentLang));
}
$this->_xml->endTag("record");
}
$this->_xml->endTag("errors");
}
else
$this->_xml->addFullTag($key,$value,true);
}
$this->_xml->endTag("column");
}
$this->_xml->endTag("columns");
$this->_xml->startTag("bearers");
foreach($this->_children[$childTable]["bearers"] as $bearerTable => $infosColumn)
{
$this->_xml->startTag("column");
foreach($infosColumn as $key => $value)
{
if (is_array($value) && !in_array($key,array("choices","values")))
continue;
if ($key == "choices")
{
$this->_xml->startTag("choices");
foreach($value as $currentValue)
$this->_xml->addFullTag("choice",$currentValue,true);
$this->_xml->endTag("choices");
}
else if ($key == "values")
{
$this->_xml->startTag("values");
foreach($value as $childItem => $values)
{
$this->_xml->startTag("record");
foreach($values as $currentValue => $currentValues)
$this->_xml->addFullTag("value",$currentValues["value"],true,array("lang"=>$this->_defaultLang,"label"=>$currentValues["label"]));
$this->_xml->endTag("record");
}
$this->_xml->endTag("values");
}
else
$this->_xml->addFullTag($key,$value,true);
}
$this->_xml->endTag("column");
}
$this->_xml->endTag("bearers");
$this->_xml->endTag("child");
}
$this->_xml->endTag("children");
$this->_xml->endTag("page");
# /Page infos
return $this->_xml;
}
