/**
* Check if an admin is authorized to log in
*
* @access public static
* @param string $login login
* @param string $pwd password
* @return mixed 1 if connected, 0 if expired, -1 not logged, -2 disabled
* @since 1.0
*/
public static function connect($login,$pwd)
{
$generic = SLS_Generic::getInstance();
$session = $generic->getObjectSession();
$sessionToken = substr(substr(sha1($generic->getSiteConfig("privateKey")),12,31).substr(sha1($generic->getSiteConfig("privateKey")),4,11),6);
$pathsHandle = file_get_contents($generic->getPathConfig("configSls")."/rights.xml");
$xmlRights = new SLS_XMLToolbox($pathsHandle);
$result = array_shift($xmlRights->getTagsAttributes("//sls_configs/entry[@login='******' and @password='******' and count(action) > 0]",array("login")));
if (!empty($result))
{
$attributes = array_shift($xmlRights->getTagsAttributes("//sls_configs/entry[@login='******' and @password='******']",array("reset_pwd","renew_pwd","last_renew_pwd","name","firstname","last_connection","enabled")));
$reset_pwd = $attributes["attributes"][0]["value"];
$renew_pwd = $attributes["attributes"][1]["value"];
$last_renew_pwd = $attributes["attributes"][2]["value"];
$name = $attributes["attributes"][3]["value"];
$firstname = $attributes["attributes"][4]["value"];
$lastLogin = $attributes["attributes"][5]["value"];
$enabled = $attributes["attributes"][6]["value"];
if ($reset_pwd == "true" || (!empty($last_renew_pwd) && !empty($renew_pwd) && (strtotime("+".$renew_pwd, SLS_Date::dateToTimestamp($last_renew_pwd)) < SLS_Date::dateToTimestamp(date("Y-m-d")))))
return 0;
if ($enabled == "false")
return -2;
$xmlRights->setTagAttributes("//sls_configs/entry[@login='******']",array("last_connection" => date("Y-m-d H:i:s")));
$xmlRights->saveXML($generic->getPathConfig("configSls")."/rights.xml",$xmlRights->getXML());
$session->setParam("SLS_BO_VALID_".$sessionToken,"true");
$session->setParam("SLS_BO_USER_".$sessionToken,$login);
$session->setParam("SLS_BO_PREVIOUS_LOGIN",$lastLogin);
$session->setParam("SLS_BO_LOGGED","true");
$session->setParam("SLS_BO_USER",$login);
$session->setParam("SLS_BO_USER_NAME",$name);
$session->setParam("SLS_BO_USER_FIRSTNAME",$firstname);
$session->setParam("ckfinderAuthorized",true);
return 1;
}
else
return -1;
}
public function action()
{
$user = $this->hasAuthorative();
// Objects
$xmlFk = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml"));
$xmlBearer = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/bearers.xml"));
// Get the table & class name
$table = SLS_String::substrAfterFirstDelimiter($this->_http->getParam("name"),"_");
$db = SLS_String::substrBeforeFirstDelimiter($this->_http->getParam("name"),"_");
$class = ucfirst($db)."_".SLS_String::tableToClass($table);
$result = array_shift($xmlBearer->getTagsAttributes("//sls_configs/entry[@tableBearer='".$class."']",array("table1")));
if (!empty($result))
$xmlBearer->saveXML($this->_generic->getPathConfig("configSls")."/bearers.xml",$xmlBearer->deleteTags("//sls_configs/entry[@tableBearer='".$class."']"));
$this->_generic->forward("SLS_Bo","EditModel",array(array("key"=>"name","value"=>$this->_http->getParam("name"))));
}
public function action()
{
// Objects
$xml = $this->getXML();
$user = $this->hasAuthorative();
$xml = $this->makeMenu($xml);
$this->_generic->registerLink('Add', 'SLS_Bo', 'AddRight');
$xml->addFullTag("delete",$this->_generic->getFullPath("SLS_Bo","DeleteRight",array(),false));
$xml->addFullTag("edit",$this->_generic->getFullPath("SLS_Bo","EditRight",array(),false));
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/rights.xml");
$xmlRights = new SLS_XMLToolbox($pathsHandle);
$result = $xmlRights->getTagsAttributes("//sls_configs/entry",array("login","password","name","firstname","enabled"));
$xml->startTag("accounts");
for($i=0 ; $i<$count=count($result) ; $i++)
{
$xml->startTag("account");
for($j=0 ; $j<$count2=count($result[$i]["attributes"]) ; $j++)
{
if ($result[$i]["attributes"][$j]["key"] == "password")
$xml->addFullTag($result[$i]["attributes"][$j]["key"],"******",true);
else if (SLS_String::contains($result[$i]["attributes"][$j]["key"],"name"))
$xml->addFullTag($result[$i]["attributes"][$j]["key"],ucwords(strtolower($result[$i]["attributes"][$j]["value"])),true);
else
$xml->addFullTag($result[$i]["attributes"][$j]["key"],$result[$i]["attributes"][$j]["value"],true);
}
$xml->addFullTag("color",$xmlRights->getTag("//sls_configs/entry[@login='******']/settings/setting[@key='color']"),true);
$xml->endTag("account");
}
$xml->endTag("accounts");
$xml->addFullTag("url_status",$this->_generic->getFullPath("SLS_Bo","ManageRightsStatus",array(),false));
$this->saveXML($xml);
}
public function action()
{
$user = $this->hasAuthorative();
$sql = SLS_Sql::getInstance();
$xml = $this->getXML();
$xml = $this->makeMenu($xml);
$errors = array();
// Get the table name
$table = SLS_String::substrAfterFirstDelimiter($this->_http->getParam("name"),"_");
$db = SLS_String::substrBeforeFirstDelimiter($this->_http->getParam("name"),"_");
$column= $this->_http->getParam("column");
$class = ucfirst($db)."_".SLS_String::tableToClass($table);
$file = ucfirst($db).".".SLS_String::tableToClass($table);
// If current db is not this one
if ($sql->getCurrentDb() != $db)
$sql->changeDb($db);
if ($sql->tableExists($table))
{
if ($this->_http->getParam("reload") == "true")
{
$replacements = array('&','>','<','=','"',"'");
$masks = array('&','>','<','=','','','');
$columnWanted = $this->_http->getParam("column");
$tableWanted = $this->_http->getParam("table");
$labelWanted = $this->_http->getParam($tableWanted.'_fkLabel');
$labelSpecified = SLS_String::trimSlashesFromString($this->_http->getParam("fkLabel_specified"));
$multilang = $this->_http->getParam("multilanguage");
$onDelete = $this->_http->getParam("ondelete");
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$xmlType = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/filters.xml");
$xmlFilter = new SLS_XMLToolbox($pathsHandle);
if (!empty($labelSpecified))
$labelSpecified = str_replace(array('='),array('='),htmlentities(strtolower($labelSpecified),ENT_QUOTES,"UTF-8"));
$result = $xmlFk->getTags("//sls_configs/entry[@tableFk='".$db."_".$table."' and @columnFk='".$columnWanted."' and @tablePk='".$tableWanted."']");
// If an entry already exists in the XML, delete this record
if (!empty($result))
{
$xmlTmp = $xmlFk->deleteTags("//sls_configs/entry[@tableFk='".$db."_".$table."' and @columnFk='".$columnWanted."' and @tablePk='".$tableWanted."']");
$xmlFk->saveXML($this->_generic->getPathConfig("configSls")."/fks.xml",$xmlTmp);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
}
// Save it into the XML
$xmlNode = '<entry tableFk="'.$db."_".$table.'" columnFk="'.$columnWanted.'" multilanguage="'.$multilang.'" ondelete="'.$onDelete.'" labelPk="'.(empty($labelSpecified) ? $labelWanted : $labelSpecified).'" tablePk="'.$tableWanted.'" />';
$xmlFk->appendXMLNode("//sls_configs",$xmlNode);
$xmlFk->saveXML($this->_generic->getPathConfig("configSls")."/fks.xml",$xmlFk->getXML());
// Update model
$this->_generic->goDirectTo("SLS_Bo","UpdateModel",array(array("key"=>"name","value"=>$this->_http->getParam("name"))));
}
// Get generic object
$this->_generic->useModel(SLS_String::tableToClass($table),$db,"user");
$object = new $class();
// Get object's infos
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
$columnsP = $object->getParams();
$pk = $object->getPrimaryKey();
$multilanguage = $object->isMultilanguage();
$xml->startTag("model");
$xml->addFullTag("table",$table,true);
$xml->addFullTag("db",$db,true);
$xml->addFullTag("class",$class,true);
$xml->addFullTag("pk",$pk,true);
$xml->addFullTag("multilanguage",($multilanguage) ? "true" : "false",true);
$xml->startTag("columns");
foreach($columnsP as $key => $value)
{
if ($object->getPrimaryKey() != $key && $key != "pk_lang")
$xml->addFullTag("column",$key,true);
}
$xml->endTag("columns");
$attributes = array_shift($xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($db."_".$table)."' and @ columnFk='".$column."']",array("multilanguage","labelPk","tablePk","ondelete")));
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($attributes["attributes"][2]["value"],"_"),ucfirst(SLS_String::substrBeforeFirstDelimiter($attributes["attributes"][2]["value"],"_")),"user");
$className = ucfirst($attributes["attributes"][2]["value"]);
$objectN = new $className();
$columns = $objectN->getColumns();
$specificPattern = true;
foreach($columns as $key)
if ($key == $attributes["attributes"][1]["value"])
$specificPattern = false;
$xml->startTag("current_values");
$xml->addFullTag("tableFk",$db."_".SLS_String::tableToClass($table),true);
$xml->addFullTag("columnFk",$column,true);
$xml->addFullTag("multilanguage",$attributes["attributes"][0]["value"],true);
$xml->addFullTag("labelPk",$attributes["attributes"][1]["value"],true);
$xml->addFullTag("tablePk",$attributes["attributes"][2]["value"],true);
$xml->addFullTag("ondelete",$attributes["attributes"][3]["value"],true);
$xml->addFullTag("specific_pattern",($specificPattern) ? "true" : "false",true);
$xml->endTag("current_values");
$tables = $this->getAllModels();
sort($tables,SORT_REGULAR);
$xml->startTag("tables");
for($i=0 ; $i<$count=count($tables) ; $i++)
{
if (SLS_String::startsWith($tables[$i],$db))
{
$xml->startTag("table");
$xml->addFullTag("name",SLS_String::substrAfterFirstDelimiter($tables[$i],"."));
$xml->addFullTag("db",SLS_String::substrBeforeFirstDelimiter($tables[$i],"."));
$tableN = SLS_String::substrAfterFirstDelimiter($tables[$i],".");
$dbN = SLS_String::substrBeforeFirstDelimiter($tables[$i],".");
$classN = ucfirst($dbN)."_".SLS_String::tableToClass($tableN);
$this->_generic->useModel($tableN,$dbN,"user");
$obj = new $classN();
$properties = $obj->getParams();
$xml->startTag("columns");
foreach($properties as $key => $value)
if ($key != "pk_lang")
$xml->addFullTag("column",$key,true);
$xml->endTag("columns");
$xml->endTag("table");
}
}
$xml->endTag("tables");
$xml->endTag("model");
}
else
{
$xml->addFullTag("error","Sorry this table doesn't exist anymore",true);
}
$this->saveXML($xml);
}
/**
* Delete files on columns for current tables
*
* @access public
* @param array $columns columns on which you want to delete specific files (all columns of table if empty)
* @since 1.0.8
*/
public function deleteFiles($columns=array())
{
// Check type files
$xmlType = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml"));
$results = $xmlType->getTagsAttribute("//sls_configs/entry[@table='".$this->getDatabase()."_".$this->getTable()."' and (@type='file_all' or @type='file_img')]","column");
if (empty($columns))
$columns = $this->getColumns();
if (!empty($results))
{
foreach($this->getParams() as $column => $value)
{
if (!in_array($column,$columns))
continue;
$result = array_shift($xmlType->getTagsAttributes("//sls_configs/entry[@table='".$this->getDatabase()."_".$this->getTable()."' and @column='".$column."' and (@type='file_all' or @type='file_img')]",array("type","thumbs")));
if (!empty($result) && $this->getColumnDefault($column) != $value)
{
$clone = $this->countModels($this->getTable(),array(),array(array("column"=>$column,"value"=>$value,"mode"=>"equal")));
$type = $result["attributes"][0]["value"];
if (file_exists($this->_generic->getPathConfig("files").$value) && !is_dir($this->_generic->getPathConfig("files").$value) && $clone < 2)
{
if (!file_exists($this->_generic->getPathConfig("files")."__Uploads"))
@mkdir($this->_generic->getPathConfig("files")."__Uploads");
if (!file_exists($this->_generic->getPathConfig("files")."__Uploads/__Deprecated"))
@mkdir($this->_generic->getPathConfig("files")."__Uploads/__Deprecated");
if (!file_exists($this->_generic->getPathConfig("files")."__Uploads/__Deprecated/".$this->getTable()))
@mkdir($this->_generic->getPathConfig("files")."__Uploads/__Deprecated/".$this->getTable());
if ($type == "file_all")
{
try{
@rename($this->_generic->getPathConfig("files").$value,$this->_generic->getPathConfig("files")."__Uploads/__Deprecated/".$value);
}
catch (Exception $e){}
}
else
{
$thumbs = unserialize(str_replace("||#||",'"',$result["attributes"][1]["value"]));
@rename($this->_generic->getPathConfig("files").$value,$this->_generic->getPathConfig("files")."__Uploads/__Deprecated/".$value);
$baseName = $this->_generic->getPathConfig("files").SLS_String::substrBeforeLastDelimiter($value, ".".pathinfo($value,PATHINFO_EXTENSION));
$baseExtension = pathinfo($value,PATHINFO_EXTENSION);
foreach($thumbs as $thumb)
{
if (file_exists($baseName.$thumb["suffix"].".".$baseExtension) && !is_dir($baseName.$thumb["suffix"].".".$baseExtension))
@rename($baseName.$thumb["suffix"].".".$baseExtension,$this->_generic->getPathConfig("files")."__Uploads/__Deprecated/".SLS_String::substrBeforeLastDelimiter($value, ".".pathinfo($value,PATHINFO_EXTENSION)).$thumb["suffix"].".".pathinfo($value,PATHINFO_EXTENSION));
}
}
}
}
}
}
}
public function action()
{
$user = $this->hasAuthorative();
$xml = $this->getXML();
$xml = $this->makeMenu($xml);
$sql = SLS_Sql::getInstance();
$slsGraphId = $this->_http->getParam('id');
$this->useModel('Sls_graph_query',$this->defaultDb,"sls");
$this->useModel('Sls_graph',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_column',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_join',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_group',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_where',$this->defaultDb,"sls");
$className = ucfirst($this->defaultDb)."_Sls_graph_query";
$slsGraphQuery = new $className();
$className = ucfirst($this->defaultDb)."_Sls_graph";
$slsGraph = new $className();
if($slsGraph->getModel($slsGraphId) === false || $slsGraphQuery->getModel($slsGraph->sls_graph_query_id) === false)
$this->forward('SLS_Default', 'UrlError');
$slsGraphQueryCurrent = $slsGraphQuery;
$errors = array();
$slsGraphTypes = array('pie', 'bar', 'pivot', 'list');
$slsGraphAggregationTypes = array('sum', 'avg', 'count');
$slsGraphAggregationTypesNeedField = array('sum', 'avg');
$slsGraphQueryOperators = array('like','notlike','startwith','endwith','equal','notequal','in','notin','lt','lte','gt','gte','null','notnull');
$this->queryOperatorsNeedField = array('like','notlike','startwith','endwith','equal','notequal','in','notin','lt','lte','gt','gte');
$tableFieldsValues = array();
$slsGraphQueryData = array(
'sls_graph_query_where' => array(
'sls_graph_query_where_type' => 'group',
'sls_graph_query_where_condition' => '',
'sls_graph_query_where_column' => '',
'sls_graph_query_where_operator' => '',
'sls_graph_query_where_value' => '',
'sls_graph_query_where_children' => array(),
'sls_graph_query_where_root' => 'true',
)
);
$slsGraphData = array();
$slsGraphQueryWheres = array();
# reload
if($this->_http->getParam('reload') == 'true')
{
$xmlFk = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml"));
$slsGraphQueryData = $this->_http->getParam('sls_graph_query');
$slsGraphData = $this->_http->getParam('sls_graph');
if(!$slsGraph->setSlsGraphTitle($slsGraphData['sls_graph_title']))
$errors['sls_graph_title'] = 'Titre invalide';
$tmp = explode('.', $slsGraphQueryData['sls_graph_query_table']);
if(count($tmp) == 2)
{
$slsGraphQueryDbAlias = $tmp[0];
$slsGraphQueryTable = $tmp[1];
$slsGraphQueryTableAlias = $this->getTableAlias($slsGraphQueryTable);
$sql->changeDb($slsGraphQueryDbAlias);
}
else
{
$slsGraphQueryTableAlias = $slsGraphQueryDbAlias = $slsGraphQueryTable = '';
}
if(!$slsGraphQuery->setSlsGraphQueryDbAlias($slsGraphQueryDbAlias) || !$slsGraphQuery->setSlsGraphQueryTable($slsGraphQueryTable) || !$slsGraphQuery->setSlsGraphQueryTableAlias($slsGraphQueryTableAlias) || !$sql->tableExists($slsGraphQueryTable))
$errors['sls_graph_query_table'] = 'Table invalide';
else
{
$tableFields = $sql->showColumns($slsGraphQueryTable);
$tableFieldsValues = array_map(array($this,'filterFields'), $tableFields);
}
if(!$slsGraph->setSlsGraphType($slsGraphData['sls_graph_type']))
{
$errors['sls_graph_type'] = 'Type invalide';
}
else if($slsGraphData['sls_graph_type'] == 'pie')
{
# query columns
$tmp = explode('.', $slsGraphData['sls_graph_pie_group_by']);
$column = $tmp[1];
$columnConcat = $column;
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
$slsGraphQueryColumn1 = new $className();
$slsGraphQueryColumn1->setSlsGraphQueryColumnName($column);
$slsGraphQueryColumn1->setSlsGraphQueryColumnAlias('legend_id');
$slsGraphQueryColumn1->setSlsGraphQueryColumnTable($slsGraphQueryTable);
$slsGraphQueryColumn1->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$columnFk = array_shift($xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($slsGraphQueryDbAlias.'_'.$slsGraphQueryTable)."' and @columnFk = '".$column."']",array("tablePk","labelPk")));
if(!empty($columnFk))
{
$tablePk = $columnFk['attributes'][0]['value'];
$labelPk = $columnFk['attributes'][1]['value'];
$dbPk = SLS_String::substrBeforeFirstDelimiter($tablePk, '_');
$tablePk = SLS_String::substrAfterFirstDelimiter($tablePk, '_');
$this->_generic->useModel($tablePk, $dbPk, "user");
$classFk = ucfirst($dbPk)."_".SLS_String::tableToClass($tablePk);
$objectFk = new $classFk();
$columns = array();
$columnsLabel = array();
$clause = array();
$render = array();
$columnTable = $objectFk->getTable();
# add join
$i = 1;
# target
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
${slsGraphQueryJoin.$i} = new $className();
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableTarget($slsGraphQueryTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasTarget($slsGraphQueryTableAlias);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnTarget($column);
# /target
# source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableSource($columnTable);
$slsGraphQueryJoin = $this->getTableAlias($columnTable);
/*$slsGraphQueryJoin = $columnTable.$aliasIndex;
$aliasIndex++;*/
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasSource($slsGraphQueryJoin);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnSource($objectFk->getPrimaryKey());
# /source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinMode('left');
$i++;
# /add join
foreach($objectFk->getParams() as $key => $value)
{
array_push($columns,"`".$key."`");
if (SLS_String::contains($labelPk,$key))
$columnsLabel[$key] = strpos($labelPk,$key);
}
array_multisort($columnsLabel);
foreach($columnsLabel as $columnLabel => $offset)
array_push($clause,$columnLabel);
$pattern = str_replace("'","''",$labelPk);
foreach($clause as $columnC)
$pattern = str_replace($columnC,"',"."CAST(".$slsGraphQueryJoin.".`".$columnC."` AS CHAR),'",$pattern);
$columnConcat = "CONCAT('".$pattern."')";
}
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
$slsGraphQueryColumn2 = new $className();
$slsGraphQueryColumn2->setSlsGraphQueryColumnName($columnConcat);
$slsGraphQueryColumn2->setSlsGraphQueryColumnAlias('legend');
$slsGraphQueryColumn2->setSlsGraphQueryColumnTable($slsGraphQueryTable);
$slsGraphQueryColumn2->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
$slsGraphQueryColumn3 = new $className();
$slsGraphQueryColumn3->setSlsGraphQueryColumnAggregation('count');
$slsGraphQueryColumn3->setSlsGraphQueryColumnAlias('count');
$slsGraphQueryColumn3->setSlsGraphQueryColumnTable($slsGraphQueryTable);
$slsGraphQueryColumn3->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
# /query columns
# query groups
$className = ucfirst($this->defaultDb)."_Sls_graph_query_group";
$slsGraphQueryGroup1 = new $className();
if(!$slsGraphQueryGroup1->setSlsGraphQueryGroupColumn($column)/* || !in_array($slsGraphData['sls_graph_pie_group_by'], $tableFieldsValues)*/)
$errors['sls_graph_pie_group_by'] = 'Champ groupé invalide';
# /query groups
$sql->changeDb($slsGraphQueryDbAlias);
$joins = $this->getQueryJoin($slsGraphQueryTable, $slsGraphQueryTableAlias, array($slsGraphData['sls_graph_pie_group_by']));
}
else if($slsGraphData['sls_graph_type'] == 'bar')
{
$i = 1;
$j = 1;
# query columns
$tmp = explode('.', $slsGraphData['sls_graph_bar_aggregation_field']);
if(count($tmp) == 2)
$columnAggregationField = $tmp[1];
else
$columnAggregationField = '';
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
if(empty($slsGraphData['sls_graph_bar_aggregation'])
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAggregation($slsGraphData['sls_graph_bar_aggregation'])
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable)
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias)
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('value'))
$errors['sls_graph_bar_aggregation'] = 'Aggrégation invalide';
if(in_array($slsGraphData['sls_graph_bar_aggregation'], $slsGraphAggregationTypesNeedField) && (empty($columnAggregationField) || !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($columnAggregationField)))
$errors['sls_graph_bar_aggregation_field'] = 'Champ aggrégation invalide';
$j++;
# query column group
$tmp = explode('.', $slsGraphData['sls_graph_bar_group_by']);
$column = $tmp[1];
$columnConcat = $column;
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($column);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_group_id');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$j++;
$columnFk = array_shift($xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($slsGraphQueryDbAlias.'_'.$slsGraphQueryTable)."' and @columnFk = '".$column."']",array("tablePk","labelPk")));
if(!empty($columnFk))
{
$tablePk = $columnFk['attributes'][0]['value'];
$labelPk = $columnFk['attributes'][1]['value'];
$dbPk = SLS_String::substrBeforeFirstDelimiter($tablePk, '_');
$tablePk = SLS_String::substrAfterFirstDelimiter($tablePk, '_');
$this->_generic->useModel($tablePk, $dbPk, "user");
$classFk = ucfirst($dbPk)."_".SLS_String::tableToClass($tablePk);
$objectFk = new $classFk();
$columns = array();
$columnsLabel = array();
$clause = array();
$render = array();
$columnTable = $objectFk->getTable();
# add join
# target
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
${slsGraphQueryJoin.$i} = new $className();
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableTarget($slsGraphQueryTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasTarget($slsGraphQueryTableAlias);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnTarget($column);
# /target
# source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableSource($columnTable);
$slsGraphQueryJoin = $this->getTableAlias($columnTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasSource($slsGraphQueryJoin);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnSource($objectFk->getPrimaryKey());
# /source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinMode('left');
$i++;
# /add join
foreach($objectFk->getParams() as $key => $value)
{
array_push($columns,"`".$key."`");
if (SLS_String::contains($labelPk,$key))
$columnsLabel[$key] = strpos($labelPk,$key);
}
array_multisort($columnsLabel);
foreach($columnsLabel as $columnLabel => $offset)
array_push($clause,$columnLabel);
$pattern = str_replace("'","''",$labelPk);
foreach($clause as $columnC)
$pattern = str_replace($columnC,"',"."CAST(".$slsGraphQueryJoin.".`".$columnC."` AS CHAR),'",$pattern);
$columnConcat = "CONCAT('".$pattern."')";
}
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($columnConcat);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_group');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$j++;
# query column group
# query column stacked
if(!empty($slsGraphData['sls_graph_bar_stacked_field']))
{
$tmp = explode('.', $slsGraphData['sls_graph_bar_stacked_field']);
$column = $tmp[1];
$columnConcat = $column;
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($column);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_stacked_id');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$j++;
$columnFk = array_shift($xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($slsGraphQueryDbAlias.'_'.$slsGraphQueryTable)."' and @columnFk = '".$column."']",array("tablePk","labelPk")));
if(!empty($columnFk))
{
$tablePk = $columnFk['attributes'][0]['value'];
$labelPk = $columnFk['attributes'][1]['value'];
$dbPk = SLS_String::substrBeforeFirstDelimiter($tablePk, '_');
$tablePk = SLS_String::substrAfterFirstDelimiter($tablePk, '_');
$this->_generic->useModel($tablePk, $dbPk, "user");
$classFk = ucfirst($dbPk)."_".SLS_String::tableToClass($tablePk);
$objectFk = new $classFk();
$columns = array();
$columnsLabel = array();
$clause = array();
$render = array();
$columnTable = $objectFk->getTable();
# add join
# target
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
${slsGraphQueryJoin.$i} = new $className();
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableTarget($slsGraphQueryTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasTarget($slsGraphQueryTableAlias);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnTarget($column);
# /target
# source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableSource($columnTable);
$slsGraphQueryJoin = $this->getTableAlias($columnTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasSource($slsGraphQueryJoin);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnSource($objectFk->getPrimaryKey());
# /source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinMode('left');
$i++;
# /add join
foreach($objectFk->getParams() as $key => $value)
{
array_push($columns,"`".$key."`");
if (SLS_String::contains($labelPk,$key))
$columnsLabel[$key] = strpos($labelPk,$key);
}
array_multisort($columnsLabel);
foreach($columnsLabel as $columnLabel => $offset)
array_push($clause,$columnLabel);
$pattern = str_replace("'","''",$labelPk);
foreach($clause as $columnC)
$pattern = str_replace($columnC,"',"."CAST(".$slsGraphQueryJoin.".`".$columnC."` AS CHAR),'",$pattern);
$columnConcat = "CONCAT('".$pattern."')";
}
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($columnConcat);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_stacked');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
}
# query column stacked
# /query columns
# query groups
$tmp = explode('.', $slsGraphData['sls_graph_bar_group_by']);
$columnGroupByField = $tmp[1];
$className = ucfirst($this->defaultDb)."_Sls_graph_query_group";
$slsGraphQueryGroup1 = new $className();
if(!$slsGraphQueryGroup1->setSlsGraphQueryGroupColumn($columnGroupByField))
$errors['sls_graph_bar_group_by'] = 'Champ groupé invalide';
if(!empty($slsGraphData['sls_graph_bar_stacked_field']))
{
$tmp = explode('.', $slsGraphData['sls_graph_bar_stacked_field']);
$columnStackedField = $tmp[1];
$className = ucfirst($this->defaultDb)."_Sls_graph_query_group";
$slsGraphQueryGroup2 = new $className();
if(!$slsGraphQueryGroup2->setSlsGraphQueryGroupColumn($columnStackedField))
$errors['sls_graph_bar_stacked_field'] = 'Champ réservé invalide';
}
# /query groups
$joins = $this->getQueryJoin($slsGraphQueryTable, $slsGraphQueryTableAlias, array($slsGraphData['sls_graph_bar_group_by']));
}
else if($slsGraphData['sls_graph_type'] == 'pivot')
{
$i = 1;
$j = 1;
# query columns
$tmp = explode('.', $slsGraphData['sls_graph_pivot_aggregation_field']);
if(count($tmp) == 2)
$columnAggregationField = $tmp[1];
else
$columnAggregationField = '';
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
if(empty($slsGraphData['sls_graph_pivot_aggregation'])
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAggregation($slsGraphData['sls_graph_pivot_aggregation'])
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable)
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias)
|| !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('value'))
$errors['sls_graph_pivot_aggregation'] = 'Aggrégation invalide';
if(in_array($slsGraphData['sls_graph_pivot_aggregation'], $slsGraphAggregationTypesNeedField) && (empty($columnAggregationField) || !${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($columnAggregationField)))
$errors['sls_graph_pivot_aggregation_field'] = 'Champ aggrégation invalide';
$j++;
# query column line
$tmp = explode('.', $slsGraphData['sls_graph_pivot_line']);
$column = $tmp[1];
$columnConcat = $tmp[1];
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($column);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_line_id');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$j++;
$columnFk = array_shift($xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($slsGraphQueryDbAlias.'_'.$slsGraphQueryTable)."' and @columnFk = '".$column."']",array("tablePk","labelPk")));
if(!empty($columnFk))
{
$tablePk = $columnFk['attributes'][0]['value'];
$labelPk = $columnFk['attributes'][1]['value'];
$dbPk = SLS_String::substrBeforeFirstDelimiter($tablePk, '_');
$tablePk = SLS_String::substrAfterFirstDelimiter($tablePk, '_');
$this->_generic->useModel($tablePk, $dbPk, "user");
$classFk = ucfirst($dbPk)."_".SLS_String::tableToClass($tablePk);
$objectFk = new $classFk();
$columns = array();
$columnsLabel = array();
$clause = array();
$render = array();
$columnTable = $objectFk->getTable();
# add join
# target
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
${slsGraphQueryJoin.$i} = new $className();
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableTarget($slsGraphQueryTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasTarget($slsGraphQueryTableAlias);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnTarget($column);
# /target
# source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableSource($columnTable);
$slsGraphQueryJoin = $this->getTableAlias($columnTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasSource($slsGraphQueryJoin);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnSource($objectFk->getPrimaryKey());
# /source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinMode('left');
$i++;
# /add join
foreach($objectFk->getParams() as $key => $value)
{
array_push($columns,"`".$key."`");
if (SLS_String::contains($labelPk,$key))
$columnsLabel[$key] = strpos($labelPk,$key);
}
array_multisort($columnsLabel);
foreach($columnsLabel as $columnLabel => $offset)
array_push($clause,$columnLabel);
$pattern = str_replace("'","''",$labelPk);
foreach($clause as $columnC)
$pattern = str_replace($columnC,"',"."CAST(".$slsGraphQueryJoin.".`".$columnC."` AS CHAR),'",$pattern);
$columnConcat = "CONCAT('".$pattern."')";
}
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($columnConcat);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_line');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$j++;
# query column line
# query column column
$tmp = explode('.', $slsGraphData['sls_graph_pivot_column']);
$column = $tmp[1];
$columnConcat = $column;
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($column);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_column_id');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
$j++;
$columnFk = array_shift($xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($slsGraphQueryDbAlias.'_'.$slsGraphQueryTable)."' and @columnFk = '".$column."']",array("tablePk","labelPk")));
if(!empty($columnFk))
{
$tablePk = $columnFk['attributes'][0]['value'];
$labelPk = $columnFk['attributes'][1]['value'];
$dbPk = SLS_String::substrBeforeFirstDelimiter($tablePk, '_');
$tablePk = SLS_String::substrAfterFirstDelimiter($tablePk, '_');
$this->_generic->useModel($tablePk, $dbPk, "user");
$classFk = ucfirst($dbPk)."_".SLS_String::tableToClass($tablePk);
$objectFk = new $classFk();
$columns = array();
$columnsLabel = array();
$clause = array();
$render = array();
$columnTable = $objectFk->getTable();
# add join
# target
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
${slsGraphQueryJoin.$i} = new $className();
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableTarget($slsGraphQueryTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasTarget($slsGraphQueryTableAlias);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnTarget($column);
# /target
# source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableSource($columnTable);
$slsGraphQueryJoin = $this->getTableAlias($columnTable);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinTableAliasSource($slsGraphQueryJoin);
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinColumnSource($objectFk->getPrimaryKey());
# /source
${slsGraphQueryJoin.$i}->setSlsGraphQueryJoinMode('left');
$i++;
# /add join
foreach($objectFk->getParams() as $key => $value)
{
array_push($columns,"`".$key."`");
if (SLS_String::contains($labelPk,$key))
$columnsLabel[$key] = strpos($labelPk,$key);
}
array_multisort($columnsLabel);
foreach($columnsLabel as $columnLabel => $offset)
array_push($clause,$columnLabel);
$pattern = str_replace("'","''",$labelPk);
foreach($clause as $columnC)
$pattern = str_replace($columnC,"',"."CAST(".$slsGraphQueryJoin.".`".$columnC."` AS CHAR),'",$pattern);
$columnConcat = "CONCAT('".$pattern."')";
}
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$j} = new $className();
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnName($columnConcat);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnAlias('legend_column');
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTable($slsGraphQueryTable);
${slsGraphQueryColumn.$j}->setSlsGraphQueryColumnTableAlias($slsGraphQueryTableAlias);
# query column column
# /query columns
# query groups
$tmp = explode('.', $slsGraphData['sls_graph_pivot_line']);
$columnLine = $tmp[1];
$className = ucfirst($this->defaultDb)."_Sls_graph_query_group";
$slsGraphQueryGroup1 = new $className();
if(!$slsGraphQueryGroup1->setSlsGraphQueryGroupColumn($columnLine))
$errors['sls_graph_pivot_line'] = 'Champ Ligne invalide';
$tmp = explode('.', $slsGraphData['sls_graph_pivot_column']);
$columnColumn = $tmp[1];
$className = ucfirst($this->defaultDb)."_Sls_graph_query_group";
$slsGraphQueryGroup2 = new $className();
if(!$slsGraphQueryGroup2->setSlsGraphQueryGroupColumn($columnColumn))
$errors['sls_graph_pivot_column'] = 'Champ colonne invalide';
# /query groups
$joins = $this->getQueryJoin($slsGraphQueryTable, $slsGraphQueryTableAlias, array($slsGraphData['sls_graph_pivot_column']));
}
else if($slsGraphData['sls_graph_type'] == 'list')
{
# columns
$i = 1;
$j = 1;
$joins = array();
foreach($slsGraphQueryData['sls_graph_query_column'] as $col)
{
$column = $col['sls_graph_query_column_value'];
$path = explode('|', $column);
$nbJoins = count($path);
$data = explode('.', $path[$nbJoins-1]);
$table = $data[0];
$column = $data[1];
$joinBefore = null;
# joins
for($k = 0; $k<$nbJoins ; $k++)
{
if($k == 0)
{
$columns = $sql->showColumns($slsGraphQueryTable);
$columnSource = array_shift(array_filter($columns, array($this,'filterPK')));
$columnSourcePK = $columnSource->Field;
$join = array(
'sls_graph_query_join_table_source' => $slsGraphQueryTable,
'sls_graph_query_join_column_source' => $columnSourcePK
);
}
else
{
$dataSource = explode('.', $path[$k]);
$dataTarget = explode('.', $path[$k-1]);
$tableSource = $dataSource[0];
$tableTarget = $dataTarget[0];
$columnSource = $dataSource[1];
$columnTarget = $dataTarget[1];
$columns = $sql->showColumns($tableSource);
$columnSourcePK = array_shift(array_filter($columns, array($this,'filterPK')))->Field;
$columns = $sql->showColumns($tableTarget);
$this->columnTarget = $columnTarget;
$columnTargetComment = array_shift(array_filter($columns, array($this,'filterFieldTarget')))->Comment;
$join = array(
'sls_graph_query_join_table_target' => $tableTarget,
'sls_graph_query_join_column_target' =>$columnTarget,
'sls_graph_query_join_table_comment_target' => empty($columnTargetComment) ? $columnTarget : $columnTargetComment,
'sls_graph_query_join_table_source' => $tableSource,
'sls_graph_query_join_column_source' => $columnSourcePK
);
}
$joinSearch = $this->array_search_multi($join, $joins);
if(empty($joinSearch))
{
$join['sls_graph_query_join_table_alias_source'] = ($k == 0) ? $slsGraphQueryTableAlias : $this->getTableAlias($join['sls_graph_query_join_table_source']); /*$join['sls_graph_query_join_table_source'].$aliasIndex++*/;
if($k > 0)
{
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
${slsGraphQueryJoin.$j} = new $className();
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinTableSource($join['sls_graph_query_join_table_source']);
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinTableAliasSource($join['sls_graph_query_join_table_alias_source']);
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinColumnSource($join['sls_graph_query_join_column_source']);
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinTableTarget($join['sls_graph_query_join_table_target']);
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinTableAliasTarget($joinBefore['sls_graph_query_join_table_alias_source']);
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinColumnTarget($join['sls_graph_query_join_column_target']);
${slsGraphQueryJoin.$j}->setSlsGraphQueryJoinMode('left');
$j++;
}
array_push($joins, $join);
}
else
$join = $joinSearch;
$joinBefore = $join;
}
# /joins
$columns = $sql->showColumns($table);
$this->column = $column;
$columnComment = array_shift(array_filter($columns, array($this,'filterColumnField')))->Comment;
$tableComment = $join['sls_graph_query_join_table_comment_target'];
if(empty($tableComment))
{
$tables = $sql->showTables();
$this->table = $table;
$tableComment = array_shift(array_filter($tables, array($this,'filterTable4')))->Comment;
}
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
${slsGraphQueryColumn.$i} = new $className();
${slsGraphQueryColumn.$i}->setSlsGraphQueryColumnTable($join['sls_graph_query_join_table_source']);
${slsGraphQueryColumn.$i}->setSlsGraphQueryColumnTableAlias($join['sls_graph_query_join_table_alias_source']);
${slsGraphQueryColumn.$i}->setSlsGraphQueryColumnName($column);
${slsGraphQueryColumn.$i}->setSlsGraphQueryColumnAlias($tableComment.' - '.$columnComment);
$i++;
}
# /columns
}
# query where
if(!empty($slsGraphQueryData['sls_graph_query_where']))
{
$i = 0; $j = 0;
$this->iterateSetSlsGraphQueryWhere($slsGraphQueryData['sls_graph_query_where'], $i, $j, $slsGraphQueryWheres, $errors, $joins);
}
# /query where
if (empty($errors))
{
$sql->changeDb($this->defaultDb);
# query
$this->deleteQuery($slsGraphQueryCurrent->sls_graph_query_id);
$slsGraphQuery->create();
# /query
# graph
$slsGraph->setSlsGraphQueryId($slsGraphQuery->sls_graph_query_id);
$slsGraph->save();
# /graph
# query joins
$i = 1;
//$slsGraphQueryJoin1
while(${slsGraphQueryJoin.$i})
{
${slsGraphQueryJoin.$i}->setSlsGraphQueryId($slsGraphQuery->sls_graph_query_id);
${slsGraphQueryJoin.$i}->create();
$i++;
}
# /query joins
# query columns
$i = 1;
while(${slsGraphQueryColumn.$i})
{
${slsGraphQueryColumn.$i}->setSlsGraphQueryId($slsGraphQuery->sls_graph_query_id);
${slsGraphQueryColumn.$i}->create();
$i++;
}
# /query columns
# query groups
$i = 1;
while(${slsGraphQueryGroup.$i})
{
${slsGraphQueryGroup.$i}->setSlsGraphQueryGroupTable($slsGraphQueryTable);
${slsGraphQueryGroup.$i}->setSlsGraphQueryGroupTableAlias($slsGraphQueryTableAlias);
${slsGraphQueryGroup.$i}->setSlsGraphQueryId($slsGraphQuery->sls_graph_query_id);
${slsGraphQueryGroup.$i}->create();
$i++;
}
# /query groups
# query where
if(!empty($slsGraphQueryData['sls_graph_query_where']))
{
$i = 0;
$this->iterateCreateQueryWhere($slsGraphQueryData['sls_graph_query_where'], 0, $i, $slsGraphQueryWheres, $slsGraphQuery->sls_graph_query_id);
}
# /query where
$this->forward('SLS_Bo', 'ReportingBo');
}
else
{
$xml->startTag("errors");
foreach($errors as $key => $error)
{
if($key == 'sls_graph_query_where')
{
foreach($error as $slsGraphQueryWhereIndex => $slsGraphQueryWhereErrors)
{
foreach($slsGraphQueryWhereErrors as $slsGraphQueryWhereKey => $slsGraphQueryWhereError)
{
$xml->addFullTag("error", $slsGraphQueryWhereError, true, array("num" => $slsGraphQueryWhereIndex, "column" => $slsGraphQueryWhereKey));
}
}
}
else
$xml->addFullTag("error", $error, true, array("column" => $key));
}
$xml->endTag("errors");
}
$slsGraphQueryData = $this->_http->getParam('sls_graph_query');
}
# /reload
# load
else
{
$this->useModel('Sls_graph_query',$this->defaultDb,"sls");
$this->useModel('Sls_graph',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_column',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_join',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_group',$this->defaultDb,"sls");
$this->useModel('Sls_graph_query_where',$this->defaultDb,"sls");
$className = ucfirst($this->defaultDb)."_Sls_graph_query_column";
$slsGraphQueryColumn = new $className();
$className = ucfirst($this->defaultDb)."_Sls_graph_query_join";
$slsGraphQueryJoin = new $className();
$className = ucfirst($this->defaultDb)."_Sls_graph_query_where";
$slsGraphQueryWhere = new $className();
$className = ucfirst($this->defaultDb)."_Sls_graph_query_group";
$slsGraphQueryGroup = new $className();
$slsGraphQueryId = $slsGraphQueryCurrent->sls_graph_query_id;
$tables = array($slsGraphQueryCurrent->sls_graph_query_table => !empty($slsGraphQueryCurrent->sls_graph_query_alias) ? $slsGraphQuery->sls_graph_query_alias : $slsGraphQueryCurrent->sls_graph_query_table);
$columns = $slsGraphQueryColumn->searchModels("sls_graph_query_column",array(),array(0=>array("column"=>"sls_graph_query_id","value"=>$slsGraphQueryId,"mode"=>"equal")),array(),array(array("column"=>"sls_graph_query_column_id","order"=>"asc")));
$joins = $slsGraphQueryJoin->searchModels("sls_graph_query_join",array(),array(0=>array("column"=>"sls_graph_query_id","value"=>$slsGraphQueryId,"mode"=>"equal")),array(),array(array("column"=>"sls_graph_query_join_id","order"=>"asc")));
$wheres = $slsGraphQueryWhere->searchModels("sls_graph_query_where",array(),array(0=>array("column"=>"sls_graph_query_id","value"=>$slsGraphQueryId,"mode"=>"equal")),array(),array(array("column"=>"sls_graph_query_where_id","order"=>"asc")));
$groups = $slsGraphQueryGroup->searchModels("sls_graph_query_group",array(),array(0=>array("column"=>"sls_graph_query_id","value"=>$slsGraphQueryId,"mode"=>"equal")),array(),array(array("column"=>"sls_graph_query_group_id","order"=>"asc")));
if($slsGraph->sls_graph_type == 'pie')
{
$slsGraphData['sls_graph_pie_group_by'] = !empty($groups) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$groups[0]->sls_graph_query_group_column : '';
}
else if($slsGraph->sls_graph_type == 'bar')
{
$slsGraphData['sls_graph_bar_aggregation'] = !empty($columns) ? $columns[0]->sls_graph_query_column_aggregation : '';
$slsGraphData['sls_graph_bar_aggregation_field'] = !empty($columns) && !empty($columns[0]->sls_graph_query_column_name) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$columns[0]->sls_graph_query_column_name : '';
$slsGraphData['sls_graph_bar_group_by'] = !empty($groups) && !empty($groups[0]->sls_graph_query_group_column) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$groups[0]->sls_graph_query_group_column : '';
$slsGraphData['sls_graph_bar_stacked_field'] = !empty($groups) && !empty($groups[1]->sls_graph_query_group_column) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$groups[1]->sls_graph_query_group_column : '';
}
else if($slsGraph->sls_graph_type == 'pivot')
{
$slsGraphData['sls_graph_pivot_aggregation'] = !empty($columns) ? $columns[0]->sls_graph_query_column_aggregation : '';
$slsGraphData['sls_graph_pivot_aggregation_field'] = !empty($columns) && !empty($columns[0]->sls_graph_query_column_name) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$columns[0]->sls_graph_query_column_name : '';
$slsGraphData['sls_graph_pivot_line'] = !empty($groups) && !empty($groups[0]->sls_graph_query_group_column) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$groups[0]->sls_graph_query_group_column : '';
$slsGraphData['sls_graph_pivot_column'] = !empty($groups) && !empty($groups[1]->sls_graph_query_group_column) ? $slsGraphQueryCurrent->sls_graph_query_table_alias.'.'.$groups[1]->sls_graph_query_group_column : '';
}
foreach($slsGraph->getParams() as $key => $value)
$slsGraphData[$key] = $value;
if ($slsGraphQueryCurrent->sls_graph_query_db_alias != $sql->getCurrentDb())
$sql->changeDb($slsGraphQueryCurrent->sls_graph_query_db_alias);
$tableFields = $sql->showColumns($slsGraphQueryCurrent->sls_graph_query_table);
foreach($slsGraphQueryCurrent->getParams() as $key => $value)
{
if($key == 'sls_graph_query_table')
$value = $slsGraphQueryCurrent->sls_graph_query_db_alias.'.'.$value;
$slsGraphQueryData[$key] = $value;
}
$slsGraphQueryData['sls_graph_query_column'] = $this->iterateFormatQueryColumnToArray($columns, $joins);
$slsGraphQueryData['sls_graph_query_where'] = $this->iterateFormatQueryWhereToArray($wheres, 0);
}
# /load
# graph
$xml->startTag('sls_graph');
foreach($slsGraphData as $key => $value)
$xml->addFullTag($key, $value, true);
$xml->addFullTag('graph_table_fields_class', empty($tableFields) ? 'hide' : '', true);
$xml->startTag('sls_graph_query');
foreach($slsGraphQueryData as $key => $value)
{
if($key == 'sls_graph_query_where')
{
$i = 0; $j = 0;
$this->iterateAddXmlQueryWhere($value, $i, $j, $xml);
}
else if($key == 'sls_graph_query_column')
{
$xml->startTag('sls_graph_query_columns');
foreach($value as $column)
{
$xml->startTag('sls_graph_query_column');
$xml->addFullTag('sls_graph_query_column_value', $column['sls_graph_query_column_value'], true);
$xml->addFullTag('sls_graph_query_column_label', $column['sls_graph_query_column_label'], true);
$xml->endTag('sls_graph_query_column');
}
$xml->endTag('sls_graph_query_columns');
}
else
$xml->addFullTag($key, $value, true);
}
$xml->endTag('sls_graph_query');
$xml->endTag('sls_graph');
# /graph
$labels = array(
'SLS_GRAPH_TYPE_PIE' => "Pie Chart",
'SLS_GRAPH_TYPE_BAR' => "Bar Chart",
'SLS_GRAPH_TYPE_PIVOT' => "Pivot Table",
'SLS_GRAPH_TYPE_LIST' => "List",
'SLS_AGGREGATION_TYPE_SUM' => "SUM",
'SLS_AGGREGATION_TYPE_AVG' => "AVG",
'SLS_AGGREGATION_TYPE_COUNT' => "COUNT",
'SLS_AGGREGATION_TYPE_SUM_LABEL' => "Sum",
'SLS_AGGREGATION_TYPE_AVG_LABEL' => "Average",
'SLS_AGGREGATION_TYPE_COUNT_LABEL' => "Total",
'SLS_QUERY_OPERATOR_LIKE' => "LIKE",
'SLS_QUERY_OPERATOR_NOTLIKE' => "NOT LIKE",
'SLS_QUERY_OPERATOR_STARTWITH' => "START WITH",
'SLS_QUERY_OPERATOR_ENDWITH' => "END WITH",
'SLS_QUERY_OPERATOR_EQUAL' => "EQUAL",
'SLS_QUERY_OPERATOR_NOTEQUAL' => "NOT EQUAL",
'SLS_QUERY_OPERATOR_IN' => "IN",
'SLS_QUERY_OPERATOR_NOTIN' => "NOT IN",
'SLS_QUERY_OPERATOR_LT' => "LESS THAN",
'SLS_QUERY_OPERATOR_LTE' => "LESS THAN EQUAL",
'SLS_QUERY_OPERATOR_GT' => "GREATER THAN",
'SLS_QUERY_OPERATOR_GTE' => "GREATER THAN EQUAL",
'SLS_QUERY_OPERATOR_NULL' => "IS NULL",
'SLS_QUERY_OPERATOR_NOTNULL' => "IS NOT NULL"
);
# graph types
$xml->startTag('sls_graph_types');
foreach($slsGraphTypes as $slsGraphType){
$xml->startTag('sls_graph_type');
$xml->addFullTag('sls_graph_type_value', $slsGraphType, true);
$xml->addFullTag('sls_graph_type_label', $labels['SLS_GRAPH_TYPE_'.mb_strtoupper($slsGraphType, 'UTF-8')], true);
$xml->endTag('sls_graph_type');
}
$xml->endTag('sls_graph_types');
# /graph types
# aggregation types
$xml->startTag('sls_graph_aggregation_types');
foreach($slsGraphAggregationTypes as $slsGraphAggregationType){
$xml->startTag('sls_graph_aggregation_type');
$xml->addFullTag('sls_graph_aggregation_type_value', $slsGraphAggregationType, true);
$xml->addFullTag('sls_graph_aggregation_type_label', $labels['SLS_AGGREGATION_TYPE_'.mb_strtoupper($slsGraphAggregationType, 'UTF-8')], true);
$xml->endTag('sls_graph_aggregation_type');
}
$xml->endTag('sls_graph_aggregation_types');
# /aggregation types
# query operators
$xml->startTag('sls_graph_query_operators');
foreach($slsGraphQueryOperators as $slsGraphQueryOperator){
$xml->startTag('sls_graph_query_operator');
$xml->addFullTag('sls_graph_query_operator_value', $slsGraphQueryOperator, true);
$xml->addFullTag('sls_graph_query_operator_label', $labels['SLS_QUERY_OPERATOR_'.mb_strtoupper($slsGraphQueryOperator, 'UTF-8')], true);
$xml->endTag('sls_graph_query_operator');
}
$xml->endTag('sls_graph_query_operators');
# /query operators
# tables
$xml->startTag('tables');
$dbs = $sql->getDbs();
foreach($dbs as $db)
{
$sql->changeDb($db);
$tables = $sql->showTables();
usort($tables, array($this,'cmpTables'));
foreach($tables as $table)
{
$xml->startTag('table');
$xml->addFullTag('table_name', $db.'.'.$table->Name, true);
$xml->addFullTag('table_label', $db.' - '.$table->Name, true);
$xml->endTag('table');
}
}
$xml->endTag('tables');
# /tables
$xml->addFullTag("url_reporting_getfields",$this->_generic->getFullPath("SLS_Bo","ReportingBoGetFields"),true);
$xml->addFullTag("url_reporting_getfieldsfrommutipletables",$this->_generic->getFullPath("SLS_Bo","ReportingBoGetFieldsFromMultipleTables"),true);
$xml->addFullTag("url_report",$this->_generic->getFullPath("SLS_Bo","ReportingBo"),true);
$xml->addFullTag("url_delete",$this->_generic->getFullPath("SLS_Bo","ReportingBoDelete",array("id" => $slsGraphId)),true);
$xml->addFullTag("url_status",$this->_generic->getFullPath("SLS_Bo","ReportingBoStatus",array("id" => $slsGraphId)),true);
$this->saveXML($xml);
}
/**
* Get the source code of a model from his table
*
* @param string $tableName the table name
* @param string $db the alias of the database on which the model is located
* @return string $contentM the source code
*/
protected function getModelSource($tableName,$db)
{
$arrayConvertTypes = array(
'varchar' => 'string',
'tinyint' => 'int',
'text' => 'string',
'date' => 'string',
'smallint' => 'int',
'mediumint' => 'int',
'int' => 'int',
'bigint' => 'int',
'float' => 'float | int',
'double' => 'float | int',
'decimal' => 'float',
'datetime' => 'string',
'timestamp' => 'int',
'time' => 'string | int',
'year' => 'int',
'char' => 'string',
'tinyblob' => 'string',
'tinytext' => 'string',
'blob' => 'string',
'mediumblob'=> 'string',
'mediumtext'=> 'string',
'longblob' => 'string',
'longtext' => 'string',
'enum' => 'string',
'set' => 'string',
'bool' => 'int',
'binary' => 'string',
'varbinary' => 'string'
);
$sql = SLS_Sql::getInstance();
$className = ucfirst($db)."_".SLS_String::tableToClass($tableName);
$file = ucfirst($db).".".SLS_String::tableToClass($tableName);
// Create empty source
$contentM = "";
$primaryKey = "";
$multiLanguage = 'false';
$sql->changeDb($db);
$columns = $sql->showColumns($tableName);
$fileName = ucfirst($db).".".SLS_String::tableToClass($tableName).".model.php";
$primaryKey = "";
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$xmlType = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/filters.xml");
$xmlFilter = new SLS_XMLToolbox($pathsHandle);
$fkMethods = array();
$uniquesMultilang = array();
// Create Model
$contentM = '<?php'."\n".
'/**'."\n".
' * Object '.$className.''."\n".
' * @author SillySmart'."\n".
' * @copyright SillySmart'."\n".
' * @package Mvc.Models.Objects'."\n".
' * @see Sls.Models.Core.SLS_FrontModel'."\n".
' * @since 1.0'."\n".
' */'."\n".
'class '.$className.' extends SLS_FrontModel'."\n".
'{'."\n".
t(1).'/**'."\n".
t(1).' * Class variables'."\n".
t(1).' */'."\n";
$pkFound = false;
for($i=0 ; $i<$count=count($columns) ; $i++)
{
if (!$pkFound && $columns[$i]->Key == "PRI")
{
$primaryKey = SLS_String::removePhpChars($columns[$i]->Field);
$pkFound = true;
}
if ($columns[$i]->Field == "pk_lang" && $columns[$i]->Key == "PRI")
$multiLanguage = 'true';
$contentM .= t(1).'protected $__'.SLS_String::removePhpChars($columns[$i]->Field).';'."\n";
}
$contentM .= t(1).'protected $_table = "'.$tableName.'";'."\n".
t(1).'protected $_db = "'.$db.'";'."\n".
t(1).'protected $_primaryKey = "'.$primaryKey.'";'."\n";
// Show create table
if ($multiLanguage == 'true')
{
$create = array_shift($sql->select("SHOW CREATE TABLE `".$tableName."`"));
$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 FKs to create access reference functions
$fks = $xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".$db."_".$tableName."']",array("columnFk","tablePk"));
$fkFunctions = "";
$fkCursor = "";
for($i=0 ; $i<$count=count($fks) ; $i++)
{
$tablePk = $fks[$i]["attributes"][1]["value"];
$functionName = SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($tablePk,"_"))," ",false)),"");
$functionName{0} = strtolower($functionName{0});
$functionNameModified = $functionName;
while(in_array($functionNameModified,$fkMethods))
$functionNameModified = $functionName."_".($fkCursor = (empty($fkCursor)) ? 2 : $fkCursor+1);
$fkMethods[] = $functionNameModified;
$fkFunctions .= "'".$functionNameModified."'";
if ($i < ($count - 1))
$fkFunctions .= ", ";
}
$contentM .= t(1).'protected $_fks = array('.$fkFunctions.');'."\n";
$contentM .= t(1).'public $_typeErrors = array();'."\n\n".
t(1).'/**'."\n".
t(1).' * Constructor '.$className.''."\n".
t(1).' * @author SillySmart'."\n".
t(1).' * @copyright SillySmart'."\n".
t(1).' * @param bool $mutlilanguage true if multilanguage content, else false'."\n".
t(1).' */'."\n".
t(1).'public function __construct($multilanguage='.$multiLanguage.')'."\n".
t(1).'{'."\n".
t(2).'parent::__construct($multilanguage);'."\n".
t(2).'$this->buildDefaultValues();'."\n".
t(1).'}'."\n\n";
$contentM .= t(1).'/**'."\n".
t(1).' * Build default values for specific columns'."\n".
t(1).' * @author SillySmart'."\n".
t(1).' * @copyright SillySmart'."\n".
t(1).' */'."\n".
t(1).'public function buildDefaultValues()'."\n".
t(1).'{'."\n";
for($i=0 ; $i<$count=count($columns) ; $i++)
{
$columnType = (strpos($columns[$i]->Type, "(")) ? SLS_String::substrBeforeFirstDelimiter(strtolower($columns[$i]->Type), "(") : $columns[$i]->Type;
$functionName = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",SLS_String::removePhpChars($columns[$i]->Field))," ",false)),"");
if ($columns[$i]->Null == "NO")
{
// Dates
if ($columnType == "date" || $columnType == "datetime" || $columnType == "timestamp" || $columnType == "year" || $columnType == "time")
{
switch ($columnType)
{
case "date":
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = date("Y-m-d");'."\n";
break;
case "time":
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = date("H:i:s");'."\n";
break;
case "datetime":
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = date("Y-m-d H:i:s");'."\n";
break;
case "timestamp":
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = date("Y-m-d H:i:s");'."\n";
break;
case "year":
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = date("Y");'."\n";
break;
}
}
// Uniqid
$result = $xmlType->getTags("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".SLS_String::removePhpChars($columns[$i]->Field)."' and @type='uniqid']");
if (!empty($result))
{
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = substr(md5(time().substr(sha1(microtime()),0,rand(12,25))),mt_rand(1,20),40);'."\n";
}
// IP Address
$result = array_shift($xmlType->getTags("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".SLS_String::removePhpChars($columns[$i]->Field)."' and (@type='ip_both' or @type='ip_v4' or @type='ip_v6')]/@type"));
if (!empty($result))
{
$contentM .= t(2).'$this->__'.$columns[$i]->Field.' = $_SERVER["REMOTE_ADDR"];'."\n";
}
}
}
$contentM .= t(1).'}'."\n\n";
for($i=0 ; $i<$count=count($columns) ; $i++)
{
$isPassword = false;
if ($columns[$i]->Key != "PRI")
{
$column = SLS_String::removePhpChars($columns[$i]->Field);
$columnType = (strpos($columns[$i]->Type, "(")) ? SLS_String::substrBeforeFirstDelimiter(strtolower($columns[$i]->Type), "(") : $columns[$i]->Type;
$functionName = "set".SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(str_replace("_"," ",$column)," ",false)),"");
$contentM .= t(1).'/**'."\n".
t(1).' * Set the value of '.$column.''."\n".
t(1).' * Errors can be catched with the public variable $this->_typeErrors[\''.$column.'\']'."\n".
t(1).' * @author SillySmart'."\n".
t(1).' * @copyright SillySmart'."\n".
t(1).' * @param '.$arrayConvertTypes[$columnType].' $value'."\n".
t(1).' * @return bool true if updated, false if not'."\n".
t(1).' */'."\n".
t(1).'public function '.$functionName.'($value';
if ($columns[$i]->Default !== null)
$contentM .= '="'.SLS_String::addSlashesToString($columns[$i]->Default,false).'"';
$contentM .= ')'."\n";
$contentM .= t(1).'{'."\n";
// Nullable case
if ($columns[$i]->Null == "YES")
{
$contentM .= t(2).'if (empty($value))'."\n".
t(2).'{'."\n".
t(3).'$this->__set(\''.$column.'\', $value);'."\n".
t(3).'$this->flushError(\''.$column.'\');'."\n".
t(3).'return true;'."\n".
t(2).'}'."\n\n";
}
// Recover Fk
$res = $xmlFk->getTagsByAttributes("//sls_configs/entry",array("tableFk","columnFk"),array($db."_".$tableName,$column));
if (!empty($res))
{
$tableTm = substr($res,(strpos($res,'tablePk="')+9),(strpos($res,'"/>')-(strpos($res,'tablePk="')+9)));
$tablePk = SLS_String::substrAfterFirstDelimiter($tableTm,"_");
$dbPk = SLS_String::substrBeforeFirstDelimiter($tableTm,"_");
$contentM .= t(2).'$this->_generic->useModel("'.SLS_String::tableToClass($tablePk).'","'.$dbPk.'","user");'."\n".
t(2).'$object = new '.ucfirst($dbPk).'_'.SLS_String::tableToClass($tablePk).'();'."\n".
t(2).'if ($object->getModel($value) === false)'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_KEY";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n".
t(2).'$this->__set(\''.$column.'\', $value);'."\n".
t(2).'$this->flushError(\''.$column.'\');'."\n".
t(2).'return true;'."\n".
t(1).'}'."\n\n";
}
// If not a fk
else
{
// Check filters
$results = $xmlFilter->getTags("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".$column."']/@filter");
for($j=0 ; $j<$countJ=count($results) ; $j++)
{
switch($results[$j])
{
case "hash":
$isPassword = true;
$contentM .= t(2).'if (empty($value))'."\n".
t(3).'$value = $this->__'.$column.';'."\n";
break;
default:
$contentM .= t(2).'$value = SLS_String::filter($value,"'.$results[$j].'");'."\n";
break;
}
}
if (count($results) > 0)
$contentM .= "\n";
$result = $xmlType->getTags("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".$column."']");
// Force specific type numeric
if ($this->containsRecursive($columnType,array("int","float","double","decimal","real")))
{
$typeExists =($xmlType->getTag("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".$column."']/@type"));
if (empty($typeExists))
{
file_get_contents($this->_generic->getFullPath("SLS_Bo",
"AddType",
array("name" => strtolower($db."_".$tableName),
"column" => $column,
"reload" => "true",
"type" => "num",
"num" => (SLS_String::contains($columns[$i]->Type,"unsigned")) ? "gte" : "all",
"token" => sha1(substr($this->_generic->getSiteConfig("privateKey"), 0, 3).substr($this->_generic->getSiteConfig("privateKey"), strlen($this->_generic->getSiteConfig("privateKey"))-3))),
true));
$xmlType->refresh();
}
}
if (!empty($result))
{
$type = "";
$array = array('color','uniqid','email','ip_both','ip_v4','ip_v6','url','file_all','file_img','position','num_all','num_gt','num_gte','num_lt','num_lte','complexity');
for($j=0 ; $j<count($array) ; $j++)
{
$result = $xmlType->getTags("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".$column."' and @type='".$array[$j]."']");
if (!empty($result))
{
$type = $array[$j];
switch($type)
{
case "position":
$contentM .= t(2).'if ($value == "" || $value == null || !is_int(intval($value)) || intval($value) < 0)'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n".
t(2).'$qbd = new SLS_QueryBuilder();'."\n".
t(2).'$old_'.$column.' = $this->__'.$column.';'."\n".
t(2).'if (empty($old_'.$column.'))'."\n".
t(2).'{'."\n".
t(3).'$qbd->update()'."\n".
t(4).'->from("'.$tableName.'")'."\n".
t(4).'->set("`'.$column.'` = `'.$column.'` + 1")'."\n".
t(4).'->where($qbd->expr()->gte("'.$column.'",$value))'."\n".
t(4).'->groupBy("`'.$primaryKey.'`")'."\n".
t(4).'->execute();'."\n".
t(2).'}'."\n".
t(2).'else'."\n".
t(2).'{'."\n".
t(3).'if ($old_'.$column.' != $value)'."\n".
t(3).'{'."\n".
t(4).'$qbd->update()'."\n".
t(5).'->from("'.$tableName.'")'."\n".
t(5).'->set("`'.$column.'` = `'.$column.'` ".(($old_'.$column.' < $value) ? "-" : "+")." 1")'."\n".
t(5).'->where($qbd->expr()->{($old_'.$column.' < $value) ? "gt" : "gte"}("'.$column.'",($old_'.$column.' < $value) ? $old_'.$column.' : $value))'."\n".
t(5).'->whereAnd($qbd->expr()->{($old_'.$column.' < $value) ? "lte" : "lt"}("'.$column.'",($old_'.$column.' < $value) ? $value : $old_'.$column.'))'."\n".
t(5).'->groupBy("`'.$primaryKey.'`")'."\n".
t(5).'->execute();'."\n".
t(4).'$qbd->update()'."\n".
t(5).'->from("'.$tableName.'")'."\n".
t(5).'->set($qbd->expr()->eq("'.$column.'",$value))'."\n".
t(5).'->where($qbd->expr()->eq("'.$primaryKey.'",$this->__'.$primaryKey.'))'."\n".
t(5).'->groupBy("`'.$primaryKey.'`")'."\n".
t(5).'->execute();'."\n".
t(3).'}'."\n".
t(2).'}'."\n\n";
break;
case "color":
$contentM .= t(2).'if (!ctype_xdigit($value))'."\n";
$contentM .= t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
case "uniqid":
$contentM .= t(2).'if (empty($value))'."\n".
t(3).'$value = substr(md5(time().substr(sha1(microtime()),0,rand(12,25))),mt_rand(1,20),40);'."\n\n";
break;
case "email":
$contentM .= t(2).'if (!SLS_String::validateEmail($value))'."\n";
$contentM .= t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
case "url":
$contentM .= t(2).'if (!SLS_String::isValidUrl($value))'."\n";
$contentM .= t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
case (in_array($type,array("ip_both","ip_v4","ip_v6"))):
$type = SLS_String::substrAfterLastDelimiter($type,"_");
$contentM .= t(2).'if (empty($value))'."\n".
t(3).'$value = $_SERVER["REMOTE_ADDR"];'."\n\n";
$contentM .= t(2).'if (!SLS_String::isIp($value,"'.$type.'"))'."\n";
$contentM .= t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
case (in_array($type,array("num_all","num_gt","num_gte","num_lt","num_lte"))):
$type = SLS_String::substrAfterLastDelimiter($type,"_");
switch($type)
{
case "gt": $operator = "<="; break;
case "gte": $operator = "<"; break;
case "lt": $operator = ">="; break;
case "lte": $operator = ">"; break;
}
if ($type != 'all')
{
$contentM .= t(2).'if ($value '.$operator.' 0)'."\n";
$contentM .= t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
break;
case "complexity":
$rules = $xmlType->getTag("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".$column."']/@rules");
$rules = explode("|",$rules);
$complexityMin = false;
foreach($rules as $rule)
{
if (SLS_String::startsWith($rule,"min"))
{
$complexityMin = SLS_String::substrAfterFirstDelimiter($rule,"min");
unset($rules[array_shift(array_keys($rules,$rule))]);
}
else
$rules[array_shift(array_keys($rules,$rule))] = '"'.$rule.'"';
}
$rules = implode(",",$rules);
$contentM .= t(2).'$complexity = array('.$rules.');'."\n".
t(2).'if ((in_array("lc",$complexity) && preg_match(\'`[[:lower:]]`\', $value) === 0) || (in_array("uc",$complexity) && preg_match(\'`[[:upper:]]`\', $value) === 0) || (in_array("digit",$complexity) && preg_match(\'`[[:digit:]]`\', $value) === 0) || (in_array("wild",$complexity) && preg_match(\'`[^a-zA-Z0-9]`\', $value) === 0))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_COMPLEXITY";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
if (is_numeric($complexityMin))
$contentM .= t(2).'if (strlen(utf8_decode($value)) < '.$complexityMin.')'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_LENGTH";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
case "file_all":
$contentM .= t(2).'if (!empty($this->__'.$column.') && $this->__'.$column.' != "'.$columns[$i]->Default.'" && $this->__'.$column.' != $value && SLS_String::startsWith((is_array($value)) ? ((array_key_exists("data",$value)) ? $value["data"]["tmp_name"] : $value["tmp_name"]) : $value, $this->getTable()."/"))'."\n".
t(2).'{'."\n".
t(3).'$this->deleteFiles(array("'.$column.'"));'."\n".
t(3).'$this->__'.$column.' = "__Uploads/__Deprecated/".$this->__'.$column.';'."\n".
t(3).'$this->save();'."\n".
t(2).'}'."\n\n".
t(2).'if (is_array($value))'."\n".
t(2).'{'."\n".
t(3).'if (array_key_exists("size",$value) && is_array($value["size"]))'."\n".
t(4).'$size = $value["size"];'."\n".
t(3).'if (array_key_exists("data",$value))'."\n".
t(4).'$value = $value["data"];'."\n";
if ($columns[$i]->Null == "YES")
$contentM .= t(3).'if ($value["error"] == 4)'."\n".
t(3).'{'."\n".
t(4).'$this->__set(\''.$column.'\',(empty($this->__'.$column.')) ? "" : $this->__'.$column.');'."\n".
t(4).'$this->flushError(\''.$column.'\');'."\n".
t(4).'return true;'."\n".
t(3).'}'."\n";
$contentM .= t(3).'if ($value["error"] == 1 || $value["error"] == 2)'."\n".
t(3).'{'."\n".
t(4).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_SIZE";'."\n".
t(4).'return false;'."\n".
t(3).'}'."\n".
t(3).'else'."\n".
t(3).'{'."\n".
t(4).'try {'."\n".
t(5).'if (!file_exists($this->_generic->getPathConfig("files").$this->_table))'."\n".
t(6).'mkdir($this->_generic->getPathConfig("files").$this->_table,0755);'."\n\n".
t(5).'$token = substr(md5(time().substr(sha1(microtime()),0,rand(5,12))),mt_rand(1,20),10);'."\n".
t(5).'$fileName = SLS_String::sanitize(SLS_String::substrBeforeLastDelimiter($value["name"],"."),"_")."_".$token.".".SLS_String::substrAfterLastDelimiter($value["name"],".");'."\n".
t(5).'rename($value["tmp_name"],$this->_generic->getPathConfig("files").$this->_table."/".$fileName);'."\n".
t(5).'$value = $this->_table."/".$fileName;'."\n".
t(4).'}'."\n".
t(4).'catch (Exception $e) {'."\n".
t(5).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_WRITE";'."\n".
t(5).'return false;'."\n".
t(4).'}'."\n".
t(3).'}'."\n".
t(2).'}'."\n\n";
break;
case "file_img":
$contentM .= t(2).'if (!empty($this->__'.$column.') && $this->__'.$column.' != "'.$columns[$i]->Default.'" && $this->__'.$column.' != $value && SLS_String::startsWith((is_array($value)) ? ((array_key_exists("data",$value)) ? $value["data"]["tmp_name"] : $value["tmp_name"]) : $value, $this->getTable()."/"))'."\n".
t(2).'{'."\n".
t(3).'$this->deleteFiles(array("'.$column.'"));'."\n".
t(3).'$this->__'.$column.' = "__Uploads/__Deprecated/".$this->__'.$column.';'."\n".
t(3).'$this->save();'."\n".
t(2).'}'."\n\n".
t(2).'if (is_array($value))'."\n".
t(2).'{'."\n".
t(3).'if (array_key_exists("size",$value) && is_array($value["size"]))'."\n".
t(4).'$size = $value["size"];'."\n".
t(3).'if (array_key_exists("data",$value))'."\n".
t(4).'$value = $value["data"];'."\n";
if ($columns[$i]->Null == "YES")
$contentM .= t(3).'if ($value["error"] == 4)'."\n".
t(3).'{'."\n".
t(4).'$this->__set(\''.$column.'\',(empty($this->__'.$column.')) ? "" : $this->__'.$column.');'."\n".
t(4).'$this->flushError(\''.$column.'\');'."\n".
t(4).'return true;'."\n".
t(3).'}'."\n";
$contentM .= t(3).'if ($value["error"] == 1 || $value["error"] == 2)'."\n".
t(3).'{'."\n".
t(4).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_SIZE";'."\n".
t(4).'return false;'."\n".
t(3).'}'."\n".
t(3).'else'."\n".
t(3).'{'."\n".
t(4).'try {'."\n".
t(5).'if (!file_exists($this->_generic->getPathConfig("files").$this->_table))'."\n".
t(6).'mkdir($this->_generic->getPathConfig("files").$this->_table,0755);'."\n\n".
t(5).'$tmpName = $value["tmp_name"];'."\n".
t(5).'if (!SLS_String::startsWith($tmpName,$this->_generic->getPathConfig("files")) || !SLS_String::contains($tmpName,"."))'."\n".
t(5).'{'."\n".
t(6).'if (!file_exists($this->_generic->getPathConfig("files")."__Uploads"))'."\n".
t(7).'@mkdir($this->_generic->getPathConfig("files")."__Uploads");'."\n".
t(6).'if (!file_exists($this->_generic->getPathConfig("files")."__Uploads/__Deprecated"))'."\n".
t(7).'@mkdir($this->_generic->getPathConfig("files")."__Uploads/__Deprecated");'."\n".
t(6).'$newName = $this->_generic->getPathConfig("files")."__Uploads/__Deprecated/".SLS_String::substrAfterLastDelimiter($tmpName,"/").((!SLS_String::contains($tmpName,".")) ? ".".SLS_String::substrAfterLastDelimiter($value["name"],".") : "");'."\n".
t(6).'rename($tmpName,$newName);'."\n".
t(6).'$tmpName = $newName;'."\n".
t(5).'}'."\n".
t(5).'$token = substr(md5(time().substr(sha1(microtime()),0,rand(5,12))),mt_rand(1,20),10);'."\n".
t(5).'$fileName = SLS_String::sanitize(SLS_String::substrBeforeLastDelimiter($value["name"],"."),"_")."_".$token;'."\n".
t(5).'$extension = pathinfo($tmpName, PATHINFO_EXTENSION);'."\n\n".
t(5).'// Check img'."\n".
t(5).'$img = new SLS_Image($tmpName);'."\n".
t(5).'if ($img->getParam("existed"))'."\n".
t(5).'{'."\n".
t(6).'// Default crop'."\n".
t(6).'if (empty($size))'."\n".
t(7).'$size = array("x" => "0", "y" => "0", "w" => $img->getParam("width"), "h" => $img->getParam("height"));'."\n\n".
t(6).'// Crop image'."\n".
t(6).'$img->crop($size["x"],$size["y"],$size["w"],$size["h"]);'."\n".
t(6).'// Check thumbs'."\n".
t(6).'$xmlType = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml"));'."\n".
t(6).'$result = array_shift($xmlType->getTagsAttribute("//sls_configs/entry[@table=\'".$this->getDatabase()."_".$this->getTable()."\' and @column=\''.$column.'\' and @type=\'file_img\']","thumbs"));'."\n".
t(6).'$thumbs = unserialize(str_replace("||#||",\'"\',$result["attribute"]));'."\n".
t(6).'if (!empty($thumbs))'."\n".
t(6).'{'."\n".
t(7).'for($i=0 ; $i<$count=count($thumbs) ; $i++)'."\n".
t(7).'{'."\n".
t(8).'$img->transform($thumbs[$i]["width"],$thumbs[$i]["height"],$this->_generic->getPathConfig("files").$this->_table."/".$fileName.$thumbs[$i]["suffix"].".".$extension,$extension);'."\n".
t(7).'}'."\n".
t(6).'}'."\n\n".
t(6).'// Move original'."\n".
t(6).'rename($tmpName,$this->_generic->getPathConfig("files").$this->_table."/".$fileName.".".$extension);'."\n".
t(5).'}'."\n".
t(5).'else'."\n".
t(5).'{'."\n".
t(6).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(6).'return false;'."\n".
t(5).'}'."\n".
t(5).'$value = $this->_table."/".$fileName.".".$extension;'."\n".
t(4).'}'."\n".
t(4).'catch (Exception $e) {'."\n".
t(5).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_WRITE";'."\n".
t(5).'return false;'."\n".
t(4).'}'."\n".
t(3).'}'."\n".
t(2).'}'."\n\n";
break;
}
break;
}
}
}
// Not Nullable
if ($columns[$i]->Null == "NO")
{
$contentM .= t(2).'if ($value === "")'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_EMPTY";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
if ($isPassword)
{
$result = array_shift($xmlFilter->getTagsAttribute("//sls_configs/entry[@table='".$db."_".$tableName."' and @column='".$column."']","hash"));
$hash = (empty($result["attribute"])) ? "sha1" : $result["attribute"];
$contentM .= t(2).'if ($value != $this->__'.$column.')'."\n".
t(3).'$value = SLS_String::filter($value,"hash","'.$hash.'");'."\n\n";
}
// Not Nullable
if ($columns[$i]->Null == "NO")
{
$contentM .= t(2).'if (is_null($value))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_NULL";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
// Check change
$contentM .= t(2).'if ($this->__'.$column.' == $value)'."\n".
t(2).'{'."\n".
t(3).'$this->flushError(\''.$column.'\');'."\n".
t(3).'return true;'."\n".
t(2).'}'."\n\n";
// Unique
if ($columns[$i]->Key == "UNI" || in_array($column,$uniquesMultilang))
{
$contentM .= t(2).'if (!$this->isUnique(\''.SLS_String::addSlashes($column, 'QUOTES').'\',$value))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_UNIQUE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
// Float types
if (SLS_String::startsWith($columnType,"float") || SLS_String::startsWith($columnType,"double") || SLS_String::startsWith($columnType,"decimal"))
{
$length = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter(SLS_String::substrBeforeLastDelimiter($columns[$i]->Type, ')'), '('), ",");
if (empty($length))
$length = "25";
$contentM .= t(2).'$decimal = (strpos($value, \',\')) ? str_replace(\',\', \'.\', $value) : (!strpos($value, \'.\')) ? $value.\'.0\' : $value;'."\n".
t(2).'if (!is_numeric($decimal))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n".
t(2).'if ((strlen($decimal)-1) > '.$length.')'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_LENGTH";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
// Enum types
else if ($columnType == "enum" || $columnType == "set")
{
$values = SLS_String::substrAfterFirstDelimiter(SLS_String::substrBeforeLastDelimiter($columns[$i]->Type, "')"), "('");
if ($columnType == "enum")
{
$contentM .= t(2).'$values = explode("\',\'", "'.str_replace("''", "\'", $values).'");'."\n".
t(2).'if (!in_array($value, $values))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_CONTENT";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
else
{
$contentM .= t(2).'$values = explode("\',\'", "'.str_replace("''", "\'", $values).'");'."\n".
t(2).'$valueE = explode(",",$value);'."\n".
t(2).'foreach($valueE as $set)'."\n".
t(2).'{'."\n".
t(3).'if (!in_array($set, $values))'."\n".
t(3).'{'."\n".
t(4).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_CONTENT";'."\n".
t(4).'return false;'."\n".
t(3).'}'."\n".
t(2).'}'."\n\n";
}
}
else
{
if (strpos($columns[$i]->Type, "("))
{
$length = SLS_String::substrAfterFirstDelimiter(SLS_String::substrBeforeLastDelimiter($columns[$i]->Type, ")"), "(");
$contentM .= t(2).'if (strlen(utf8_decode($value)) > '.$length.')'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_LENGTH";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
if(SLS_String::endsWith($columnType, "int"))
{
$contentM .= t(2).'if (!is_numeric($value))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
else if ($columnType == "date" || $columnType == "datetime" || $columnType == "timestamp")
{
switch ($columnType)
{
case "date":
$contentM .= t(2).'if (!SLS_Date::isDate($value))'."\n";
break;
case "datetime":
$contentM .= t(2).'if (!SLS_Date::isDateTime($value))'."\n";
break;
case "timestamp":
$contentM .= t(2).'if (!SLS_Date::isDateTime($value))'."\n";
break;
}
$contentM .= t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
}
else if ($columnType == "time" || $columnType == "year")
{
switch ($columnType)
{
case "time":
$contentM .= t(2).'if (strpos(\':\', $value) && substr_count($value, \':\') != 2)'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n".
t(2).'$check = explode(\':\', $value);'."\n".
t(2).'if (count($check) == 1 && !is_numeric($check[0]))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n".
t(2).'else if ((count($check) > 1) && (!is_numeric($check[0]) || (!is_numeric($check[1]) || strlen($check[1]) > 2) || (!is_numeric($check[2]) || strlen($check[2]) > 2)))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
case "year":
$contentM .= t(2).'if (!mktime(0, 0, 0, 0, 0, $value))'."\n".
t(2).'{'."\n".
t(3).'$this->_typeErrors[\''.SLS_String::addSlashes($column, 'QUOTES').'\'] = "E_TYPE";'."\n".
t(3).'return false;'."\n".
t(2).'}'."\n\n";
break;
}
}
}
$contentM .= t(2).'$this->__set(\''.$column.'\', $value);'."\n".
t(2).'$this->flushError(\''.$column.'\');'."\n".
t(2).'return true;'."\n".
t(1).'}'."\n\n";
}
}
}
// Get FKs to create access reference functions
$fks = $xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".$db."_".$tableName."']",array("columnFk","tablePk"));
$fkMethods = array();
$fkCursor = "";
for($i=0 ; $i<$count=count($fks) ; $i++)
{
$columnFk = $fks[$i]["attributes"][0]["value"];
$tablePk = $fks[$i]["attributes"][1]["value"];
$functionName = SLS_String::fullTrim(ucwords(SLS_String::stringToUrl(SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($tablePk,"_"))," ",false)),"");
$functionName{0} = strtolower($functionName{0});
$functionNameModified = $functionName;
while(in_array($functionNameModified,$fkMethods))
$functionNameModified = $functionName."_".($fkCursor = (empty($fkCursor)) ? 2 : $fkCursor+1);
$fkMethods[] = $functionNameModified;
$contentM .= t(1).'/**'."\n".
t(1).' * Get the instance of '.SLS_String::substrAfterFirstDelimiter($tablePk,"_").'\'s Model described by '.$columnFk.''."\n".
t(1).' * @author SillySmart'."\n".
t(1).' * @copyright SillySmart'."\n".
t(1).' * @return '.SLS_String::tableToClass($tablePk).' $object the instance of '.SLS_String::substrAfterFirstDelimiter($tablePk,"_").'\'s Model'."\n".
t(1).' */'."\n".
t(1).'public function '.$functionNameModified.'()'."\n".
t(1).'{'."\n".
t(2).'$this->_generic->useModel("'.SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($tablePk,"_")).'","'.SLS_String::substrBeforeFirstDelimiter($tablePk,"_").'","user");'."\n".
t(2).'$object = new '.ucfirst(SLS_String::substrBeforeFirstDelimiter($tablePk,"_")).'_'.SLS_String::tableToClass(SLS_String::substrAfterFirstDelimiter($tablePk,"_")).'();'."\n".
t(2).'$object->getModel($this->__'.$columnFk.');'."\n".
t(2).'return $object;'."\n".
t(1).'}';
$contentM .= ($i == ($count-1)) ? "\n" : "\n\n";
}
$contentM .= '}'."\n".
'?>';
return $contentM;
}
public function action()
{
$xml = $this->getXML();
$xml = $this->makeMenu($xml);
$user = $this->hasAuthorative();
// Objects
$sql = SLS_Sql::getInstance();
$properties = array();
$pathsHandleFk = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$pathsHandleType = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$pathsHandleFilter = file_get_contents($this->_generic->getPathConfig("configSls")."/filters.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandleFk);
$xmlType = new SLS_XMLToolbox($pathsHandleType);
$xmlFilter = new SLS_XMLToolbox($pathsHandleFilter);
// Foreach existing models
$models = scandir($this->_generic->getPathConfig("models"));
foreach($models as $file)
{
if (!is_dir($this->_generic->getPathConfig("models")."/".$file) && substr($file, 0, 1) != ".")
{
$fileExploded = explode(".",$file);
if (is_array($fileExploded) && count($fileExploded) == 4)
{
$db = strtolower($fileExploded[0]);
$class = $fileExploded[1];
$className = $db."_".$class;
$this->_generic->useModel($class,$db,"user");
$object = new $className();
$table = $object->getTable();
$properties[$db][$table] = array("types" => array(),
"filters" => array(),
"fks" => array());
$types = $xmlType->getTagsAttributes("//sls_configs/entry[@table='".$db."_".$table."']",array("column","type","rules"));
for($i=0 ; $i<$count=count($types) ; $i++)
{
$column = $types[$i]["attributes"][0]["value"];
$type = $types[$i]["attributes"][1]["value"];
$rules = $types[$i]["attributes"][2]["value"];
if ($type == "complexity" && !empty($rules))
$type .= " (".$rules.")";
$properties[$db][$table]["types"][$column][] = $type;
}
$filters = $xmlFilter->getTagsAttributes("//sls_configs/entry[@table='".$db."_".$table."']",array("column","filter","hash"));
for($i=0 ; $i<$count=count($filters) ; $i++)
{
$column = $filters[$i]["attributes"][0]["value"];
$filter = $filters[$i]["attributes"][1]["value"];
$hash = $filters[$i]["attributes"][2]["value"];
if ($filter == "hash" && !empty($hash))
$filter .= " (".$hash.")";
$properties[$db][$table]["filters"][$column][] = $filter;
}
$fks = $xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".$db."_".$table."']",array("columnFk","tablePk","labelPk"));
for($i=0 ; $i<$count=count($fks) ; $i++)
{
$column = $fks[$i]["attributes"][0]["value"];
$classPk = ucfirst($fks[$i]["attributes"][1]["value"]);
$labelPk = $fks[$i]["attributes"][2]["value"];
$tablePk = SLS_String::substrAfterFirstDelimiter($classPk,"_");
$this->_generic->useModel($tablePk,$db,"user");
$objectPk = new $classPk();
$properties[$db][$table]["fks"][$column][] = $objectPk->getTable();
}
}
}
}
asort($properties,SORT_REGULAR);
uksort($properties,array($this, 'unshiftDefaultDb'));
$xml->startTag("dbs");
foreach($properties as $db => $tables)
{
$xml->startTag("db");
$xml->addFullTag("name",$db,true);
$xml->startTag("tables");
foreach($tables as $table => $infos)
{
$columns = array();
$xml->startTag("table");
$xml->addFullTag("name",$table,true);
$xml->startTag("types");
foreach($infos["types"] as $column => $type)
{
$xml->addFullTag("type",implode(", ",$type),true,array("column"=>$column));
$columns[] = $column;
}
$xml->endTag("types");
$xml->startTag("filters");
foreach($infos["filters"] as $column => $filter)
{
$xml->addFullTag("filter",implode(", ",$filter),true,array("column"=>$column));
$columns[] = $column;
}
$xml->endTag("filters");
$xml->startTag("fks");
foreach($infos["fks"] as $column => $fk)
{
$xml->addFullTag("fk",implode(", ",$fk),true,array("column"=>$column));
$columns[] = $column;
}
$xml->endTag("fks");
$xml->startTag("columns");
foreach($columns as $column)
$xml->addFullTag("column",$column,true);
$xml->endTag("columns");
$xml->endTag("table");
}
$xml->endTag("tables");
$xml->endTag("db");
}
$xml->endTag("dbs");
$xml->addFullTag("url_type",$this->_generic->getFullPath("SLS_Bo","EditType",array(),false),true);
$xml->addFullTag("url_model",$this->_generic->getFullPath("SLS_Bo","EditModel",array(),false),true);
$xml->addFullTag("url_fk",$this->_generic->getFullPath("SLS_Bo","EditForeignKey",array(),false),true);
$this->saveXML($xml);
}
public function action()
{
$user = $this->hasAuthorative();
// Objects
$sql = SLS_Sql::getInstance();
$xml = $this->getXML();
$xml = $this->makeMenu($xml);
// Actions
$xml->addFullTag("delete",$this->_generic->getFullPath("SLS_Bo","DeleteModel",array(),false));
$xml->addFullTag("delete_bearer",$this->_generic->getFullPath("SLS_Bo","DeleteBearerTable",array(),false));
$xml->addFullTag("delete_type",$this->_generic->getFullPath("SLS_Bo","DeleteType",array(),false));
$xml->addFullTag("edit_type",$this->_generic->getFullPath("SLS_Bo","EditType",array(),false));
$xml->addFullTag("delete_fk",$this->_generic->getFullPath("SLS_Bo","DeleteForeignKey",array(),false));
$xml->addFullTag("edit_fk",$this->_generic->getFullPath("SLS_Bo","EditForeignKey",array(),false));
$xml->addFullTag("update",$this->_generic->getFullPath("SLS_Bo","UpdateModel",array(),false));
$xml->addFullTag("descriptions",$this->_generic->getFullPath("SLS_Bo","UpdateDescription",array(),false));
// Get the table & class name
$table = SLS_String::substrAfterFirstDelimiter($this->_http->getParam("name"),"_");
$db = SLS_String::substrBeforeFirstDelimiter($this->_http->getParam("name"),"_");
$class = ucfirst($db)."_".SLS_String::tableToClass($table);
$file = ucfirst($db).".".SLS_String::tableToClass($table);
// If current db is not this one
if ($sql->getCurrentDb() != $db)
$sql->changeDb($db);
// Get generic object
$this->_generic->useModel(SLS_String::tableToClass($table),$db,"user");
$object = new $class();
// Get description's table
$description = $object->getTableComment($table);
$columnsInfos = $sql->showColumns($table);
// Get object's infos
$columns = array();
$columnsP = $object->getParams();
$pk = $object->getPrimaryKey();
$multilanguage = $object->isMultilanguage();
$xml->startTag("model");
$xml->addFullTag("table",$table,true);
$xml->addFullTag("description",(SLS_String::contains($description,"InnoDB free")) ? SLS_String::substrBeforeFirstDelimiter($description,"; InnoDB free") : $description,true);
$xml->addFullTag("db",$db,true);
$xml->addFullTag("class",$class,true);
$xml->addFullTag("pk",$pk,true);
$xml->addFullTag("multilanguage",($multilanguage) ? "true" : "false",true);
$xml->startTag("columns");
$cursor = 0;
foreach($columnsP as $column => $value)
{
$xml->startTag("column");
$xml->addFullTag("name",$column,true);
array_push($columns,$column);
$fk = "";
$sType = "";
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
$res = $xmlFk->getTagsByAttributes("//sls_configs/entry",array("tableFk","columnFk"),array($db."_".$table,$column));
if (!empty($res))
{
$tableTmp = substr($res,(strpos($res,'tablePk="')+9),(strpos($res,'"/>')-(strpos($res,'tablePk="')+9)));
$fk = SLS_String::substrAfterFirstDelimiter($tableTmp,"_");
}
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$xmlType = new SLS_XMLToolbox($pathsHandle);
$res = $xmlType->getTagsByAttributes("//sls_configs/entry",array("table","column"),array($db."_".$table,$column));
if (!empty($res))
{
$sType = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($res,'type="'),'"/>');
// If specific type numeric and native type too
if (SLS_String::startsWith($sType,"num_") && $this->containsRecursive($columnsInfos[$cursor]->Type,array("int","float","double","decimal","real")))
$xml->addFullTag("allow_to_delete_type","false",true);
}
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/filters.xml");
$xmlFilter = new SLS_XMLToolbox($pathsHandle);
$results = $xmlFilter->getTagsAttributes("//sls_configs/entry[@table='".$db."_".$table."' and @column='".$column."']",array("filter","hash"));
$xml->startTag("filters");
for($i=0 ; $i<$count=count($results) ; $i++)
{
$filter = $results[$i]["attributes"][0]["value"];
$result = $results[$i]["attributes"][1]["value"];
$xml->startTag("filter");
$xml->addFullTag("name",$filter.((!empty($result)) ? ' ['.$result.']' : ''),true);
$xml->addFullTag("url_delete",$this->_generic->getFullPath("SLS_Bo","DeleteFilter",array(array("key"=>"table","value"=>$this->_http->getParam("name")),array("key"=>"column","value"=>$column),array("key"=>"filter","value"=>$filter))),true);
$xml->endTag("filter");
}
$xml->endTag("filters");
$xml->addFullTag("fk",$fk,true);
$xml->addFullTag("type",ucfirst($sType),true);
$xml->addFullTag("comment",$object->getColumnComment($column),true);
$xml->endTag("column");
$cursor++;
}
$xml->endTag("columns");
$xml->addFullTag("url_add_type",$this->_generic->getFullPath("SLS_Bo","AddType",array(0=>array("key"=>"name","value"=>$db."_".$table))),true);
$xml->addFullTag("url_add_filter",$this->_generic->getFullPath("SLS_Bo","AddFilter",array(0=>array("key"=>"name","value"=>$db."_".$table))),true);
$xml->addFullTag("url_add_fk",$this->_generic->getFullPath("SLS_Bo","AddForeignKey",array(0=>array("key"=>"name","value"=>$db."_".$table))),true);
// Get the source of the current model
$xml->addFullTag("current_source",str_replace("\t"," ",file_get_contents($this->_generic->getPathConfig("models").$file.".model.php")),true);
// Get the source of the current table
if (!$sql->tableExists($table))
$xml->addFullTag("current_table",-1,true);
else
{
$columns = $sql->showColumns($table);
$tableName = $table;
$currentTable = array("table"=>$db.".".$tableName,"errors"=>array());
$className = ucfirst($db)."_".SLS_String::tableToClass($tableName);
$fileName = ucfirst($db).".".SLS_String::tableToClass($table).".model.php";
$primaryKey = "";
$multiLanguage = 'false';
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$xmlType = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/filters.xml");
$xmlFilter = new SLS_XMLToolbox($pathsHandle);
// Get source
$contentM = $this->getModelSource($tableName,$db);
// Is data bearer
$xmlBearer = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/bearers.xml"));
$result = array_shift($xmlBearer->getTagsAttributes("//sls_configs/entry[@tableBearer='".$class."']",array("table1")));
$xml->addFullTag("is_data_bearer",(!empty($result)) ? $result["attributes"][0]["value"] : "false",true);
// Save the new source
$xml->addFullTag("current_table",str_replace("\t"," ",$contentM),true);
$xml->addFullTag("url_data_bearer",$this->_generic->getFullPath("SLS_Bo","AddBearerTable",array(array("key"=>"name","value"=>$this->_http->getParam("name")))),true);
}
$xml->endTag("model");
$this->saveXML($xml);
}
public function action()
{
$user = $this->hasAuthorative();
$json = array();
$xml = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig('configSls').'fks.xml'));
$tableName = $this->_http->getParam('table_name');
$tmp = explode('.', $tableName);
if(count($tmp) != 2)
die;
$slsGraphQueryDbAlias = $tmp[0];
$slsGraphQueryTable = $tmp[1];
$this->sql->changeDb($slsGraphQueryDbAlias);
if($this->sql->tableExists($slsGraphQueryTable))
{
$json['status'] = 'OK';
$json['fields'] = array();
$fields = $this->sql->showColumns($slsGraphQueryTable);
// Get Attributes
$getAttributes = $xml->getTagsAttributes('//sls_configs/entry[@tableFk="'.$slsGraphQueryDbAlias."_".$slsGraphQueryTable.'"]', array('columnFk', 'labelPk', 'tablePk'));
// Format Attributes
$columnFk = array();
$labelPk = array();
$tablePk = array();
for($i = 0; $i < $count = count($getAttributes); $i++)
{
array_push($columnFk, $getAttributes[$i]['attributes'][0]['value']);
array_push($labelPk, $getAttributes[$i]['attributes'][1]['value']);
array_push($tablePk, $getAttributes[$i]['attributes'][2]['value']);
}
foreach($fields as $field)
{
if(in_array($field->Field, $columnFk))
{
$isFk = true;
$index = array_search($field->Field, $columnFk);
$labelPkValue = $labelPk[$index];
$tablePkValue = $tablePk[$index];
}
else
{
$isFk = false;
}
array_push($json['fields'], array(
'field_name' => $field->Field,
'field_table' => $slsGraphQueryTable,
'field_label' => $field->Field,
'field_isFk' => $isFk,
'field_labelPk' => $labelPkValue,
'field_tablePk' => empty($tablePkValue) ? '' : $slsGraphQueryDbAlias.'.'.SLS_String::substrAfterFirstDelimiter(strtolower($tablePkValue), '_'))
);
}
}
else{
$json['status'] = 'ERROR';
$json['error'] = "Table doesn't exist";
}
echo json_encode($json);
die;
}
public function action()
{
$user = $this->hasAuthorative();
$sql = SLS_Sql::getInstance();
$xml = $this->getXML();
$xml = $this->makeMenu($xml);
$errors = array();
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml");
$xmlFk = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$xmlType = new SLS_XMLToolbox($pathsHandle);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/filters.xml");
$xmlFilter = new SLS_XMLToolbox($pathsHandle);
// Get the table name
$table = SLS_String::substrAfterFirstDelimiter($this->_http->getParam("name"),"_");
$db = SLS_String::substrBeforeFirstDelimiter($this->_http->getParam("name"),"_");
$column= $this->_http->getParam("column");
$class = ucfirst($db)."_".SLS_String::tableToClass($table);
$file = ucfirst($db).".".SLS_String::tableToClass($table);
// If current db is not this one
if ($sql->getCurrentDb() != $db)
$sql->changeDb($db);
if ($sql->tableExists($table))
{
if ($this->_http->getParam("reload") == "true")
{
$columnWanted = $this->_http->getParam("column");
$typeWanted = $this->_http->getParam("type");
$result = $xmlType->getTags("//sls_configs/entry[@table='".$db."_".$table."' and @column='".$columnWanted."']");
// If an entry already exists in the XML, delete this record
if (!empty($result))
{
$xmlTmp = $xmlType->deleteTags("//sls_configs/entry[@table='".$db."_".$table."' and @column='".$columnWanted."']");
$xmlType->saveXML($this->_generic->getPathConfig("configSls")."/types.xml",$xmlTmp);
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/types.xml");
$xmlType = new SLS_XMLToolbox($pathsHandle);
}
// If file type, check possible thumbs
if ($typeWanted == "file")
{
$typeFile = $this->_http->getParam("file");
$file_thumb = $this->_http->getParam("file_thumb");
$multilang = $this->_http->getParam("multilanguage");
$thumbs = array();
$typeWanted = $typeWanted."_".$typeFile;
if ($typeFile == "img" && !empty($file_thumb))
{
for($i=0 ; $i<10 ; $i++)
{
$width = $this->_http->getParam("width".$i);
$height = $this->_http->getParam("height".$i);
$suffix = $this->_http->getParam("suffix".$i);
if (!empty($suffix) && (!empty($width) || !empty($height)))
array_push($thumbs,array('width' => $width, 'height' => $height, 'suffix' => $suffix));
}
}
$rules = "*|*|*";
if ($typeFile == "img")
{
$settings = $this->_http->getParam("imgSettings");
$ratio = str_replace(",",".",$settings["ratio"]);
$minWidth = str_replace(",",".",$settings["min-width"]);
$minHeight = str_replace(",",".",$settings["min-height"]);
$ratio = (!is_numeric($ratio) || (is_numeric($ratio) && $ratio <= 0)) ? "*" : round($ratio,2);
$minWidth = (!is_numeric($minWidth) || (is_numeric($minWidth) && $minWidth < 0)) ? "*" : round($minWidth,0);
$minHeight = (!is_numeric($minHeight) || (is_numeric($minHeight) && $minHeight < 0)) ? "*" : round($minHeight,0);
$rules = $ratio."|".$minWidth."|".$minHeight;
}
// Save it into the XML
$xmlNode = '<entry table="'.$db.'_'.$table.'" column="'.$columnWanted.'" rules="'.$rules.'" thumbs="'.str_replace('"','||#||',serialize($thumbs)).'" multilanguage="'.$multilang.'" type="'.$typeWanted.'" />';
$xmlType->appendXMLNode("//sls_configs",$xmlNode);
$xmlType->saveXML($this->_generic->getPathConfig("configSls")."/types.xml",$xmlType->getXML());
}
else if ($typeWanted == "ip")
{
$type = $this->_http->getParam("ip");
// Save it into the XML
$xmlNode = '<entry table="'.$db.'_'.$table.'" column="'.$columnWanted.'" type="'.$typeWanted."_".$type.'" />';
$xmlType->appendXMLNode("//sls_configs",$xmlNode);
$xmlType->saveXML($this->_generic->getPathConfig("configSls")."/types.xml",$xmlType->getXML());
}
else if ($typeWanted == "complexity")
{
$complexity = $this->_http->getParam("complexity");
$complexityMin = $this->_http->getParam("complexity_min");
$complexity = (empty($complexity)) ? array() : $complexity;
if (!empty($complexityMin) && is_numeric($complexityMin) && $complexityMin >= 0)
$complexity[] = "min".$complexityMin;
$complexity = implode("|",$complexity);
// Save it into the XML
$xmlNode = '<entry table="'.$db.'_'.$table.'" column="'.$columnWanted.'" rules="'.$complexity.'" type="complexity" />';
$xmlType->appendXMLNode("//sls_configs",$xmlNode);
$xmlType->saveXML($this->_generic->getPathConfig("configSls")."/types.xml",$xmlType->getXML());
}
else if ($typeWanted == "num")
{
$type = $this->_http->getParam("num");
// Save it into the XML
$xmlNode = '<entry table="'.$db.'_'.$table.'" column="'.$columnWanted.'" type="'.$typeWanted."_".$type.'" />';
$xmlType->appendXMLNode("//sls_configs",$xmlNode);
$xmlType->saveXML($this->_generic->getPathConfig("configSls")."/types.xml",$xmlType->getXML());
}
// Else, it's email, url
else
{
// Save it into the XML
$xmlNode = '<entry table="'.$db.'_'.$table.'" column="'.$columnWanted.'" type="'.$typeWanted.'" />';
$xmlType->appendXMLNode("//sls_configs",$xmlNode);
$xmlType->saveXML($this->_generic->getPathConfig("configSls")."/types.xml",$xmlType->getXML());
}
// Update Model
$fileName = ucfirst($db).".".SLS_String::tableToClass($table).".model.php";
$contentM = $this->getModelSource($table,$db);
file_put_contents($this->_generic->getPathConfig("models").$fileName,$contentM);
$controllers = $this->_generic->getTranslatedController("SLS_Bo","EditModel");
$this->_generic->redirect($controllers['controller']."/".$controllers['scontroller']."/name/".$db."_".$table);
}
// Get generic object
$this->_generic->useModel($table,$db,"user");
$object = new $class();
// Get current entry
$attributes = array_shift($xmlType->getTagsAttributes("//sls_configs/entry[@table='".$db."_".$table."' and @column='".$column."']",array("type","thumbs","multilanguage","hash","rules")));
// Get object's infos
$columnsP = $object->getParams();
$pk = $object->getPrimaryKey();
$multilanguage = $object->isMultilanguage();
$xml->startTag("model");
$xml->addFullTag("table",$table,true);
$xml->addFullTag("db",$db,true);
$xml->addFullTag("class",$class,true);
$xml->addFullTag("pk",$pk,true);
$xml->addFullTag("multilanguage",($multilanguage) ? "true" : "false",true);
$xml->addFullTag("column",$column,true);
$xml->addFullTag("type",$attributes["attributes"][0]["value"],true);
$xml->startTag("thumbs");
$thumbs = unserialize(str_replace("||#||",'"',$attributes["attributes"][1]["value"]));
if (!empty($thumbs))
{
for($i=0 ; $i<$count=count($thumbs) ; $i++)
{
$xml->startTag("thumb");
$xml->addFullTag("width",$thumbs[$i]["width"],true);
$xml->addFullTag("height",$thumbs[$i]["height"],true);
$xml->addFullTag("suffix",$thumbs[$i]["suffix"],true);
$xml->endTag("thumb");
}
}
$xml->endTag("thumbs");
$xml->addFullTag("multilanguage",($attributes["attributes"][2]["value"] == "true") ? "true" : "false",true);
$xml->addFullTag("hash",$attributes["attributes"][3]["value"],true);
$xml->addFullTag("rules",$attributes["attributes"][4]["value"],true);
$xml->endTag("model");
$plugin = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configPlugins")."/plugins.xml"));
$pluginImg = array_shift($plugin->getTags("//plugins/plugin[@code='image']"));
$xml->addFullTag("plugin_img",empty($pluginImg) ? 'false' : 'true',true);
$xml->addFullTag("plugin_url",$this->_generic->getFullPath("SLS_Bo","Plugins"),true);
}
else
{
$xml->addFullTag("error","Sorry this table doesn't exist anymore",true);
}
$this->saveXML($xml);
}
public function action()
{
// Objects
$xml = $this->getXML();
$user = $this->hasAuthorative();
$xml = $this->makeMenu($xml);
$actions = array("read" => array(),
"add" => array(),
"edit" => array(),
"delete" => array(),
"clone" => array(),
"email" => array(),
"custom" => array());
$autoActions = array("BoDashBoard", "BoDeleteFile", "BoExport", "BoFkAc", "BoIsLogged", "BoLike", "BoSetting", "BoUnique", "BoUpload", "BoUploadProgress");
$_publicActions = array("BoLogin",
"BoLogout",
"BoForgottenPwd",
"BoMenu",
"BoRenewPwd",
"BoSwitchLang");
$_forbiddenActions = array("BoPopulate");
$db = SLS_Sql::getInstance();
$color = "pink";
$xmlColors = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/bo_colors.xml"));
$errors = array();
if ($db->tableExists("sls_graph"))
{
$actions["dashboard"] = array();
$dashboardId = $this->_generic->getControllersXML()->getTag("//controllers/controller[@isBo='true']/scontrollers/scontroller[@name='BoDashBoard']/@id");
$this->_generic->useModel("Sls_graph",$this->defaultDb,"sls");
$className = ucfirst($this->defaultDb)."_Sls_graph";
$slsGraph = new $className;
$slsGraphs = $slsGraph->searchModels("sls_graph",array(),array(),array(),array("sls_graph_title" => "asc"));
for($i=0 ; $i<$count=count($slsGraphs) ; $i++)
$actions["dashboard"][$dashboardId."_sls_graph_".$slsGraphs[$i]->sls_graph_id] = "_".$slsGraphs[$i]->sls_graph_title;
}
$results = $this->_generic->getControllersXML()->getTagsAttributes("//controllers/controller[@isBo='true']/scontrollers/scontroller",array("name","id"));
for($i=0 ; $i<$count=count($results) ; $i++)
{
$name = $results[$i]["attributes"][0]["value"];
$aid = $results[$i]["attributes"][1]["value"];
switch($name)
{
case (SLS_String::startsWith($name,"List") && SLS_String::contains($name,"_")):
$actions["read"][$aid] = $name;
break;
case (SLS_String::startsWith($name,"Add") && SLS_String::contains($name,"_")):
$actions["add"][$aid] = $name;
break;
case (SLS_String::startsWith($name,"Modify") && SLS_String::contains($name,"_")):
$actions["edit"][$aid] = $name;
break;
case (SLS_String::startsWith($name,"Delete") && SLS_String::contains($name,"_")):
$actions["delete"][$aid] = $name;
break;
case (SLS_String::startsWith($name,"Clone") && SLS_String::contains($name,"_")):
$actions["clone"][$aid] = $name;
break;
case (SLS_String::startsWith($name,"Email") && SLS_String::contains($name,"_")):
$actions["email"][$aid] = $name;
break;
default:
if (!in_array($name,$_publicActions) && !in_array($name,$_forbiddenActions) && !in_array($name,$autoActions))
{
$id = array_shift($this->_generic->getControllersXML()->getTags("//controllers/controller[@isBo='true']/scontrollers/scontroller[@name='".$name."']/@id"));
if (!empty($id))
$actions["custom"][$id] = "_".$name;
}
break;
}
}
$xml->startTag("bo_groups");
foreach($actions as $action => $values)
{
$xml->startTag("bo_group");
$xml->addFullTag("name",$action,true);
foreach($values as $aid => $name)
{
$model = "";
switch ($name)
{
case (SLS_String::startsWith($name,"List")): $model = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($name,"List"),"_"); break;
case (SLS_String::startsWith($name,"Add")): $model = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($name,"Add"),"_"); break;
case (SLS_String::startsWith($name,"Modify")): $model = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($name,"Modify"),"_"); break;
case (SLS_String::startsWith($name,"Delete")): $model = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($name,"Delete"),"_"); break;
case (SLS_String::startsWith($name,"Clone")): $model = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($name,"Clone"),"_"); break;
case (SLS_String::startsWith($name,"Email")): $model = SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($name,"Email"),"_"); break;
default: $model = "";
}
$xml->startTag("action");
$xml->addFullTag("name",SLS_String::substrAfterFirstDelimiter($name,"_"),true);
$xml->addFullTag("model",$model,true);
$xml->addFullTag("id",$aid,true);
$xml->endTag("action");
}
$xml->endTag("bo_group");
}
$xml->endTag("bo_groups");
$complexity_pwd_min_char_nb = 8;
$renew_pwd_nb = 2;
$renew_pwd_unite = "month";
$renew_pwd_log_nb = 3;
$complexity = array();
$privilegeChoose = false;
$minChars = "";
$enabled = "true";
if ($this->_http->getParam("reload") == "true")
{
$login = SLS_String::trimSlashesFromString($this->_http->getParam("login"));
$name = SLS_String::trimSlashesFromString($this->_http->getParam("name"));
$firstname = SLS_String::trimSlashesFromString($this->_http->getParam("firstname"));
$pwd = SLS_String::trimSlashesFromString($this->_http->getParam("password"));
$enabled = SLS_String::trimSlashesFromString($this->_http->getParam("enabled"));
$complexity_pwd_lc = SLS_String::trimSlashesFromString($this->_http->getParam("complexity_pwd_lc"));
$complexity_pwd_uc = SLS_String::trimSlashesFromString($this->_http->getParam("complexity_pwd_uc"));
$complexity_pwd_digit = SLS_String::trimSlashesFromString($this->_http->getParam("complexity_pwd_digit"));
$complexity_pwd_special_char = SLS_String::trimSlashesFromString($this->_http->getParam("complexity_pwd_special_char"));
$complexity_pwd_min_char = SLS_String::trimSlashesFromString($this->_http->getParam("complexity_pwd_min_char"));
$complexity_pwd_min_char_nb = SLS_String::trimSlashesFromString($this->_http->getParam("complexity_pwd_min_char_nb"));
$reset_pwd = SLS_String::trimSlashesFromString($this->_http->getParam("reset_pwd"));
$renew_pwd = SLS_String::trimSlashesFromString($this->_http->getParam("renew_pwd"));
$renew_pwd_nb = SLS_String::trimSlashesFromString($this->_http->getParam("renew_pwd_nb"));
$renew_pwd_unite = SLS_String::trimSlashesFromString($this->_http->getParam("renew_pwd_unite"));
$renew_pwd_log = SLS_String::trimSlashesFromString($this->_http->getParam("renew_pwd_log"));
$renew_pwd_log_nb = SLS_String::trimSlashesFromString($this->_http->getParam("renew_pwd_log_nb"));
$color = SLS_String::trimSlashesFromString($this->_http->getParam("color"));
$params = $this->_http->getParams();
$pathsHandle = file_get_contents($this->_generic->getPathConfig("configSls")."/rights.xml");
$xmlRights = new SLS_XMLToolbox($pathsHandle);
$result = $xmlRights->getTags("//sls_configs/entry[@login='******']");
if (!empty($result))
array_push($errors,"This account already exists, please choose another login.");
if (empty($name) || empty($firstname))
array_push($errors,"You must fill name and firstname.");
if (empty($login) || empty($pwd))
array_push($errors,"You must choose username and password.");
foreach($params as $key => $value)
{
if (SLS_String::startsWith($key,"bo_action"))
{
$privilegeChoose = true;
break;
}
}
if (!$privilegeChoose)
array_push($errors,"You must choose at least 1 privilege.");
if (empty($errors))
{
if ($complexity_pwd_lc == "true")
array_push($complexity,"lc");
if ($complexity_pwd_uc == "true")
array_push($complexity,"uc");
if ($complexity_pwd_digit == "true")
array_push($complexity,"digit");
if ($complexity_pwd_special_char == "true")
array_push($complexity,"special_char");
if ($complexity_pwd_min_char == "true")
$minChars = $complexity_pwd_min_char_nb;
$xmlNew = '<entry login="******" name="'.SLS_String::stringToUrl($name," ").'" firstname="'.SLS_String::stringToUrl($firstname," ").'" enabled="'.$enabled.'" password="******" password_old="" last_connection="" last_renew_pwd="'.date("Y-m-d").'" complexity_pwd="'.implode("|",$complexity).'" min_chars_pwd="'.$minChars.'" reset_pwd="'.(($reset_pwd=="true") ? "true" : "").'" renew_pwd="'.(($renew_pwd=="true") ? $renew_pwd_nb." ".$renew_pwd_unite : "").'" renew_pwd_nb="'.(($renew_pwd_log=="true") ? $renew_pwd_log_nb : "").'">'."\n";
// Default settings
$xmlNew .= ' <settings>'."\n".
' <setting key="nav_filter"><![CDATA[default]]></setting>'."\n".
' <setting key="list_view"><![CDATA[collapse]]></setting>'."\n".
' <setting key="list_nb_by_page"><![CDATA[20]]></setting>'."\n".
' <setting key="add_callback"><![CDATA[list]]></setting>'."\n".
' <setting key="edit_callback"><![CDATA[list]]></setting>'."\n".
' <setting key="export_format"><![CDATA[excel]]></setting>'."\n".
' <setting key="export_all_column"><![CDATA[true]]></setting>'."\n".
' <setting key="export_all_table"><![CDATA[true]]></setting>'."\n".
' <setting key="export_display_legend"><![CDATA[true]]></setting>'."\n".
' <setting key="quick_edit"><![CDATA[disabled]]></setting>'."\n".
' <setting key="dashboard_ga"><![CDATA[visible]]></setting>'."\n".
' <setting key="dashboard_metric"><![CDATA[visible]]></setting>'."\n".
' <setting key="dashboard_monitoring"><![CDATA[visible]]></setting>'."\n".
' <setting key="dashboard_graph"><![CDATA[visible]]></setting>'."\n".
' <setting key="dashboard_email"><![CDATA[visible]]></setting>'."\n".
' <setting key="color"><![CDATA['.((empty($color)) ? "pink" : $color).']]></setting>'."\n".
' </settings>'."\n";
foreach($autoActions as $actionName)
{
$aid = $this->_generic->getControllersXML()->getTag("//controllers/controller[@isBo='true']/scontrollers/scontroller[@name='".$actionName."']/@id");
$xmlNew .= ' <action id="'.$aid.'" role="custom" entity="" />'."\n";
}
foreach($params as $key => $value)
{
if (SLS_String::startsWith($key,"bo_action"))
{
$xmlNew .= ' <action id="'.$value.'" role="'.SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($key,"bo_action_"),"_").'" entity="'.((SLS_String::substrBeforeFirstDelimiter(SLS_String::substrAfterFirstDelimiter($key,"bo_action_"),"_") == "custom") ? "" : SLS_String::substrAfterFirstDelimiter(SLS_String::substrAfterFirstDelimiter($key,"bo_action_"),"_")).'" />'."\n";
}
}
$xmlNew .= ' </entry>';
$xmlRights->appendXMLNode("//sls_configs",$xmlNew);
$xmlRights->saveXML($this->_generic->getPathConfig("configSls")."/rights.xml",$xmlRights->getXML());
$this->_generic->redirect("Manage/Rights");
}
else
{
$xml->startTag("errors");
foreach($errors as $error)
$xml->addFullTag("error",$error,true);
$xml->endTag("errors");
}
}
$xml->addFullTag("complexity_pwd_lc",$complexity_pwd_lc,true);
$xml->addFullTag("complexity_pwd_uc",$complexity_pwd_uc,true);
$xml->addFullTag("complexity_pwd_digit",$complexity_pwd_digit,true);
$xml->addFullTag("complexity_pwd_special_char",$complexity_pwd_special_char,true);
$xml->addFullTag("complexity_pwd_min_char",$complexity_pwd_min_char,true);
$xml->addFullTag("complexity_pwd_min_char_nb",$complexity_pwd_min_char_nb,true);
$xml->addFullTag("reset_pwd",$reset_pwd,true);
$xml->addFullTag("renew_pwd",$renew_pwd,true);
$xml->addFullTag("renew_pwd_nb",$renew_pwd_nb,true);
$xml->addFullTag("renew_pwd_unite",$renew_pwd_unite,true);
$xml->addFullTag("renew_pwd_log",$renew_pwd_log,true);
$xml->addFullTag("renew_pwd_log_nb",$renew_pwd_log_nb,true);
$xml->addFullTag("enabled",$enabled,true);
$xml->addFullTag("color",(empty($color)) ? "pink" : $color,true);
$colors = $xmlColors->getTagsAttributes("//sls_configs/template",array("name","hexa"));
$xml->startTag("colors");
for($i=0 ; $i<$count=count($colors) ; $i++)
$xml->addFullTag("color",$colors[$i]["attributes"][0]["value"],true,array("hexa" => $colors[$i]["attributes"][1]["value"]));
$xml->endTag("colors");
$xml->addFullTag("url_generate_bo",$this->_generic->getFullPath("SLS_Bo","GenerateBo"),true);
$this->saveXML($xml);
}
public function action()
{
$user = $this->hasAuthorative();
// Objects
$xmlFk = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/fks.xml"));
$xmlBearer = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/bearers.xml"));
$xml = $this->getXML();
$tables = array();
$xml = $this->makeMenu($xml);
// Get the table & class name
$table = SLS_String::substrAfterFirstDelimiter($this->_http->getParam("name"),"_");
$db = SLS_String::substrBeforeFirstDelimiter($this->_http->getParam("name"),"_");
$class = ucfirst($db)."_".SLS_String::tableToClass($table);
$result = array_shift($xmlBearer->getTagsAttributes("//sls_configs/entry[@tableBearer='".$class."']",array("table1")));
$res = $xmlFk->getTagsAttributes("//sls_configs/entry[@tableFk='".strtolower($class)."']",array("tablePk","columnFk"));
if (!empty($result) || count($res) != "2")
$this->_generic->forward("SLS_Bo","EditModel",array(array("key"=>"name","value"=>$this->_http->getParam("name"))));
else
{
$xml->startTag("fks");
for($i=0 ; $i<$count=count($res) ; $i++)
{
$className = ucfirst($res[$i]["attributes"][0]["value"]);
$this->_generic->useModel(SLS_String::substrAfterFirstDelimiter($className,"_"),SLS_String::substrBeforeFirstDelimiter($className,"_"),"user");
$object = new $className();
array_push($tables,$className);
$xml->startTag("fk");
$xml->addFullTag("class",$className,"true");
$xml->addFullTag("table",$object->getTable(),"true");
$xml->endTag("fk");
}
$xml->endTag("fks");
}
$xml->startTag("model");
$xml->addFullTag("table",$table,true);
$xml->addFullTag("class",$class,true);
$xml->endTag("model");
if ($this->_http->getParam("reload") == "true")
{
$target_table = SLS_String::trimSlashesFromString($this->_http->getParam("target_table"));
$tableBearer = $class;
$table2 = "";
foreach($tables as $table)
if ($table != $target_table)
$table2 = $table;
$xmlNode = '<entry tableBearer="'.$tableBearer.'" table1="'.$target_table.'" table2="'.$table2.'" />';
$xmlBearer->appendXMLNode("//sls_configs",$xmlNode);
$xmlBearer->saveXML($this->_generic->getPathConfig("configSls")."/bearers.xml",$xmlBearer->getXML());
$this->_generic->forward("SLS_Bo","EditModel",array(array("key"=>"name","value"=>$this->_http->getParam("name"))));
}
$this->saveXML($xml);
}
public function constructXML()
{
$this->_boController = $this->_generic->getBo();
if ($this->_generic->getGenericControllerName() == $this->_boController)
{
@include_once($this->_generic->getPathConfig("actionLangs").$this->_boController."/__".$this->_boController.".".$this->_lang->getLang().".lang.php");
$db = SLS_Sql::getInstance();
$dbsAlias = $db->getDbs();
$comments = array();
foreach($dbsAlias as $dbAlias)
{
$db->changeDb($dbAlias);
$tables = $db->showTables();
for($i=0 ; $i<$count=count($tables) ; $i++)
{
$table = $tables[$i]->Name;
$key = ucfirst(strtolower($dbAlias))."_".SLS_String::tableToClass($table);
if (!array_key_exists($key,$comments))
{
$comment = $tables[$i]->Comment;
if (SLS_String::startsWith($comment,"sls:lang:"))
{
$globalKey = strtoupper(SLS_String::substrAfterFirstDelimiter($comment,"sls:lang:"));
$comment = (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$globalKey])) ? (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$globalKey]) ? $table : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$globalKey]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$globalKey];
}
$comments[$key] = (empty($comment)) ? $table : $comment;
}
}
}
$db->changeDb($db->connectToDefaultDb());
# Nav
if (SLS_BoRights::isLogged())
{
$xmlBo = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/bo.xml"));
$entries = $xmlBo->getTagsAttributes("//sls_configs/entry",array("type","name"));
$this->_xmlToolBox->startTag("nav");
if (!empty($entries))
{
# BOs
$this->_xmlToolBox->startTag("section");
$this->_xmlToolBox->addFullTag("title",$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_MENU_SITE'],"true");
$this->_xmlToolBox->addFullTag("href","#","true");
$this->_xmlToolBox->startTag("categories");
for($i=0 ; $i<$count=count($entries) ; $i++)
{
$position = ($i+1);
$type = $entries[$i]["attributes"][0]["value"];
$name = $entries[$i]["attributes"][1]["value"];
if ($type == "category")
{
$childs = $xmlBo->getTagsAttributes("//sls_configs/entry[".$position."]/entry",array("type","name"));
$comment = $name;
if (SLS_String::startsWith($comment,"sls:lang:"))
{
$globalKey = strtoupper(SLS_String::substrAfterFirstDelimiter($comment,"sls:lang:"));
$comment = (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$globalKey])) ? (empty($GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$globalKey]) ? $name : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$globalKey]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$globalKey];
}
$this->_xmlToolBox->startTag("category",array("type"=>"category"));
$this->_xmlToolBox->addFullTag("title",$comment,"true");
$this->_xmlToolBox->addFullTag("href","#","true");
if (!empty($childs))
{
$this->_xmlToolBox->startTag("items");
for($j=0 ; $j<$count=count($childs) ; $j++)
{
$type = $childs[$j]["attributes"][0]["value"];
$name = $childs[$j]["attributes"][1]["value"];
$dbAlias = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($name,"_")));
$table = SLS_String::substrAfterFirstDelimiter($name,"_");
$right = SLS_BoRights::isAuthorized("read",$dbAlias."_".SLS_String::tableToClass($table));
if ($right == 1)
{
$comment = $comments[$dbAlias."_".SLS_String::tableToClass($table)];
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]) ? $table : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key];
}
$actionIdsModel = array($this->_generic->getActionId($this->_boController,"List".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Add".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Modify".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Clone".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Delete".$dbAlias."_".SLS_String::tableToClass($table)));
if ($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"List".$dbAlias."_".SLS_String::tableToClass($table))))
{
$this->_xmlToolBox->startTag("item");
$this->_xmlToolBox->addFullTag("db",$dbAlias,true);
$this->_xmlToolBox->addFullTag("model",SLS_String::tableToClass($table),true);
$this->_xmlToolBox->addFullTag("title",$comment,"true");
$this->_xmlToolBox->addFullTag("like",(SLS_BoRights::isLike("read",$dbAlias."_".SLS_String::tableToClass($table))) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("selected",(in_array($this->_generic->getActionId(),$actionIdsModel)) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController,"List".$dbAlias."_".SLS_String::tableToClass($table)),"true");
$this->_xmlToolBox->endTag("item");
}
}
}
$this->_xmlToolBox->endTag("items");
}
$this->_xmlToolBox->endTag("category");
}
else
{
$dbAlias = ucfirst(strtolower(SLS_String::substrBeforeFirstDelimiter($name,"_")));
$table = SLS_String::substrAfterFirstDelimiter($name,"_");
$right = SLS_BoRights::isAuthorized("read",$dbAlias."_".SLS_String::tableToClass($table));
if ($right == 1)
{
$comment = $comments[$dbAlias."_".SLS_String::tableToClass($table)];
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]) ? $table : $GLOBALS[$GLOBALS['PROJECT_NAME']]['JS'][$key]) : $GLOBALS[$GLOBALS['PROJECT_NAME']]['XSL'][$key];
}
$actionIdsModel = array($this->_generic->getActionId($this->_boController,"List".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Add".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Modify".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Clone".$dbAlias."_".SLS_String::tableToClass($table)),
$this->_generic->getActionId($this->_boController,"Delete".$dbAlias."_".SLS_String::tableToClass($table)));
if ($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController,"List".$dbAlias."_".SLS_String::tableToClass($table))))
{
$this->_xmlToolBox->startTag("category",array("type"=>"table"));
$this->_xmlToolBox->addFullTag("db",$dbAlias,true);
$this->_xmlToolBox->addFullTag("model",SLS_String::tableToClass($table),true);
$this->_xmlToolBox->addFullTag("title",$comment,"true");
$this->_xmlToolBox->addFullTag("like",(SLS_BoRights::isLike("read",$dbAlias."_".SLS_String::tableToClass($table))) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("selected",(in_array($this->_generic->getActionId(),$actionIdsModel)) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController,"List".$dbAlias."_".SLS_String::tableToClass($table)),"true");
$this->_xmlToolBox->endTag("category");
}
}
}
}
$this->_xmlToolBox->endTag("categories");
$this->_xmlToolBox->endTag("section");
# /BOs
}
# i18n
if ($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController, "Boi18n")) && SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController, "Boi18n")))
{
$file = $this->_http->getParam("File");
$this->_xmlToolBox->startTag("section");
$this->_xmlToolBox->addFullTag("title",$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_MENU_I18N'],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController, "Boi18n")) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href","#","true");
$this->_xmlToolBox->startTag("categories");
$controllers = $this->_generic->getControllersXML()->getTags("//controllers/controller[@side='user']/@name");
sort($controllers,SORT_STRING);
for($i=0 ; $i<$count=count($controllers) ; $i++)
{
$actions = $this->_generic->getControllersXML()->getTags("//controllers/controller[@name='".$controllers[$i]."' and @side='user']/scontrollers/scontroller/@name");
sort($actions,SORT_STRING);
$this->_xmlToolBox->startTag("category",array("type"=>"category"));
$this->_xmlToolBox->addFullTag("title",$controllers[$i],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController, "Boi18n") && SLS_String::startsWith($file, "Actions|".$controllers[$i]."|")) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href","#","true");
$this->_xmlToolBox->startTag("items");
if (file_exists($this->_generic->getPathConfig("actionLangs").$controllers[$i]."/__".$controllers[$i].".".$this->_lang->getLang().".lang.php") && ($translations = file_get_contents($this->_generic->getPathConfig("actionLangs").$controllers[$i]."/__".$controllers[$i].".".$this->_lang->getLang().".lang.php")) && SLS_String::contains(str_replace("","",$translations),'*/'."\n".'$GLOBALS') || (!SLS_String::contains($translations,"/**") && SLS_String::contains($translations,'$GLOBALS')))
{
$this->_xmlToolBox->startTag("item");
$this->_xmlToolBox->addFullTag("title","__".$controllers[$i],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController, "Boi18n") && $file == "Actions|".$controllers[$i]."|__".$controllers[$i]) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController, "Boi18n", array("File" => "Actions|".$controllers[$i]."|__".$controllers[$i])),"true");
$this->_xmlToolBox->endTag("item");
}
for($j=0 ; $j<$countJ=count($actions) ; $j++)
{
if (file_exists($this->_generic->getPathConfig("actionLangs").$controllers[$i]."/".$actions[$j].".".$this->_lang->getLang().".lang.php") && ($translations = file_get_contents($this->_generic->getPathConfig("actionLangs").$controllers[$i]."/".$actions[$j].".".$this->_lang->getLang().".lang.php")) && SLS_String::contains(str_replace("","",$translations),'*/'."\n".'$GLOBALS') || (!SLS_String::contains($translations,"/**") && SLS_String::contains($translations,'$GLOBALS')))
{
$this->_xmlToolBox->startTag("item");
$this->_xmlToolBox->addFullTag("title",$actions[$j],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController, "Boi18n") && $file == "Actions|".$controllers[$i]."|".$actions[$j]) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController, "Boi18n", array("File" => "Actions|".$controllers[$i]."|".$actions[$j])),"true");
$this->_xmlToolBox->endTag("item");
}
}
$this->_xmlToolBox->endTag("items");
$this->_xmlToolBox->endTag("category");
}
if (file_exists($this->_generic->getPathConfig("genericLangs")."site.".$this->_lang->getLang().".lang.php") && ($translations = file_get_contents($this->_generic->getPathConfig("genericLangs")."site.".$this->_lang->getLang().".lang.php")) && SLS_String::contains(str_replace("","",$translations),'*/'."\n".'$GLOBALS') || (!SLS_String::contains($translations,"/**") && SLS_String::contains($translations,'$GLOBALS')))
{
$this->_xmlToolBox->startTag("category",array("type"=>"table"));
$this->_xmlToolBox->addFullTag("title","__".$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_MENU_I18N_SITE'],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController, "Boi18n") && $file == "Generics|site") ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController, "Boi18n", array("File" => "Generics|site")),"true");
$this->_xmlToolBox->endTag("category");
}
$this->_xmlToolBox->endTag("categories");
$this->_xmlToolBox->endTag("section");
}
# /i18n
# CkFinder
if ($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController, "BoFileUpload")) && SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController, "BoFileUpload")))
{
$this->_xmlToolBox->startTag("section");
$this->_xmlToolBox->addFullTag("title",$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_MENU_FILE_MANAGER'],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController,"BoFileUpload")) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController,"BoFileUpload"),"true");
$this->_xmlToolBox->endTag("section");
}
# /CkFinder
# ProjectSettings
if ($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController, "BoProjectSettings")) && SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController, "BoProjectSettings")))
{
$this->_xmlToolBox->startTag("section");
$this->_xmlToolBox->addFullTag("title",$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_MENU_PROJECT_SETTINGS'],"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController,"BoProjectSettings")) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController,"BoProjectSettings"),"true");
$this->_xmlToolBox->endTag("section");
}
# /ProjectSettings
# Users
if ($this->_generic->actionIdExists($this->_generic->getActionId($this->_boController, "BoUserList")) && SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController, "BoUserList")))
{
$actionsUser = array($this->_generic->getActionId($this->_boController, "BoUserList"),
$this->_generic->getActionId($this->_boController, "BoUserAdd"),
$this->_generic->getActionId($this->_boController, "BoUserModify"),
$this->_generic->getActionId($this->_boController, "BoUserDelete"),
$this->_generic->getActionId($this->_boController, "BoUserStatus"));
$this->_xmlToolBox->startTag("section");
$this->_xmlToolBox->addFullTag("title",$GLOBALS[$GLOBALS['PROJECT_NAME']]['JS']['SLS_BO_MENU_USERS'],"true");
$this->_xmlToolBox->addFullTag("selected",(in_array($this->_generic->getActionId(),$actionsUser)) ? "true" : "false","true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController,"BoUserList"),"true");
$this->_xmlToolBox->endTag("section");
}
# /Users
# Developer actions
$boActions = $this->_generic->getControllersXML()->getTags("//controllers/controller[@isBo='true']/scontrollers/scontroller/@name");
for($i=0 ; $i<$count=count($boActions) ; $i++)
{
// If dev action & admin authorized
if (!SLS_String::startsWith($boActions[$i],"Bo") && // Sls generated actions
!SLS_String::startsWith($boActions[$i],"List") && // User action ListDb_Model
!SLS_String::startsWith($boActions[$i],"Add") && // User action AddDb_Model
!SLS_String::startsWith($boActions[$i],"Modify") && // User action ModifyDb_Model
!SLS_String::startsWith($boActions[$i],"Delete") && // User action DeleteDb_Model
!SLS_String::startsWith($boActions[$i],"Clone") && // User action CloneDb_Model
!SLS_String::startsWith($boActions[$i],"Email") && // User action EmailDb_Model
SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController, $boActions[$i])))
{
$this->_xmlToolBox->startTag("section");
$this->_xmlToolBox->addFullTag("title",$this->_generic->getControllersXML()->getTag("//controllers/controller[@isBo='true']/scontrollers/scontroller[@name='".$boActions[$i]."']/scontrollerLangs/scontrollerLang[@lang='".$this->_lang->getLang()."']"),"true");
$this->_xmlToolBox->addFullTag("selected",($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController, $boActions[$i])) ? "true" : "false", "true");
$this->_xmlToolBox->addFullTag("href",$this->_generic->getFullPath($this->_boController,$boActions[$i]),"true");
$this->_xmlToolBox->endTag("section");
}
}
# /Developer actions
$this->_xmlToolBox->endTag("nav");
}
# /Nav
# Admin
$xmlRight = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/rights.xml"));
$adminName = $this->_session->getParam("SLS_BO_USER_NAME");
$adminFirstname = $this->_session->getParam("SLS_BO_USER_FIRSTNAME");
if (!empty($adminName) && !empty($adminFirstname))
$imgPath = $this->_generic->getPathConfig("files")."__Uploads/images/bo/".SLS_String::stringToUrl($adminName."_".$adminFirstname,"_").".jpg";
else
$imgPath = $this->_generic->getPathConfig("coreImg")."BO-2014/Pictos/default_dev_account_small.jpg";
$this->_xmlToolBox->startTag("admin");
$this->_xmlToolBox->addFullTag("img",(file_exists($imgPath) && !is_dir($imgPath)) ? $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$imgPath : $this->_generic->getSiteConfig("protocol")."://".$this->_generic->getSiteConfig("domainName")."/".$this->_generic->getPathConfig("files")."__Uploads/images/bo/default_account.jpg",true);
$this->_xmlToolBox->addFullTag("login",$this->_session->getParam("SLS_BO_USER"),true);
$this->_xmlToolBox->addFullTag("name",ucwords(strtolower((!empty($adminName)) ? $adminName : "Developer")),true);
$this->_xmlToolBox->addFullTag("firstname",((!empty($adminFirstname)) ? ucwords(strtolower($adminFirstname)) : "SillySmart"),true);
$this->_xmlToolBox->addFullTag("type",SLS_BoRights::getAdminType(),true);
$nodeExists = $xmlRight->getTag("//sls_configs/entry[@login='******']/@login");
if (!empty($nodeExists))
{
$settings = array_combine($xmlRight->getTags("//sls_configs/entry[@login='******']/settings/setting/@key"),$xmlRight->getTags("//sls_configs/entry[@login='******']/settings/setting"));
$this->_xmlToolBox->startTag("settings");
foreach($settings as $key => $value)
$this->_xmlToolBox->addFullTag("setting",$value,true,array("key"=>$key));
$this->_xmlToolBox->endTag("settings");
}
$xmlBoColors = new SLS_XMLToolbox(file_get_contents($this->_generic->getPathConfig("configSls")."/bo_colors.xml"));
$boColors = $xmlBoColors->getTagsAttributes("//sls_configs/template",array("name","hexa"));
$this->_xmlToolBox->startTag("colors");
for($i=0 ; $i<$count=count($boColors) ; $i++)
$this->_xmlToolBox->addFullTag("color",$boColors[$i]["attributes"][0]["value"],true,array("hexa" => $boColors[$i]["attributes"][1]["value"]));
$this->_xmlToolBox->endTag("colors");
$this->_xmlToolBox->endTag("admin");
# /Admin
# URLs
$this->_xmlToolBox->startTag("various");
$this->_xmlToolBox->addFullTag("dashboard",$this->_generic->getFullPath($this->_boController,"BoDashBoard"),true,array("selected" => ($this->_generic->getActionId() == $this->_generic->getActionId($this->_boController,"BoDashBoard")) ? "true" : "false"));
$this->_xmlToolBox->addFullTag("export",$this->_generic->getFullPath($this->_boController,"BoExport"),true);
$this->_xmlToolBox->addFullTag("ac",$this->_generic->getFullPath($this->_boController,"BoFkAc"),true);
$this->_xmlToolBox->addFullTag("like",$this->_generic->getFullPath($this->_boController,"BoLike"),true);
$this->_xmlToolBox->addFullTag("setting",$this->_generic->getFullPath($this->_boController,"BoSetting"),true);
$this->_xmlToolBox->addFullTag("unique",$this->_generic->getFullPath($this->_boController,"BoUnique"),true);
$this->_xmlToolBox->addFullTag("upload",$this->_generic->getFullPath($this->_boController,"BoUpload"),true);
$this->_xmlToolBox->addFullTag("upload_progress",$this->_generic->getFullPath($this->_boController,"BoUploadProgress"),true);
$this->_xmlToolBox->addFullTag("delete_file",$this->_generic->getFullPath($this->_boController,"BoDeleteFile"),true);
$this->_xmlToolBox->addFullTag("login",$this->_generic->getFullPath($this->_boController,"BoLogin"),true);
$this->_xmlToolBox->addFullTag("logout",(SLS_BoRights::getAdminType() == "developer") ? $this->_generic->getFullPath("SLS_Bo","Logout",array("Redirect" => $this->_generic->getActionId($this->_boController,"BoLogin"), "Lang" => $this->_lang->getLang()),true,"en") : $this->_generic->getFullPath($this->_boController,"BoLogout"),true);
$this->_xmlToolBox->addFullTag("forgotten_pwd",$this->_generic->getFullPath($this->_boController,"BoForgottenPwd"),true);
$this->_xmlToolBox->addFullTag("renew_pwd",$this->_generic->getFullPath($this->_boController,"BoRenewPwd",array("Login"=>$this->_session->getParam("SLS_BO_USER"))),true);
$this->_xmlToolBox->addFullTag("is_logged",$this->_generic->getFullPath($this->_boController,"BoIsLogged"),true);
$this->_xmlToolBox->addFullTag("switch_lang",$this->_generic->getFullPath($this->_boController,"BoSwitchLang",array("Lang"=>""),false),true);
$this->_xmlToolBox->addFullTag("user_add",$this->_generic->getFullPath($this->_boController,"BoUserAdd"),true,array("authorized" => (SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController,"BoUserAdd"))) ? "true" : "false"));
$this->_xmlToolBox->addFullTag("user_modify",$this->_generic->getFullPath($this->_boController,"BoUserModify",array("id" => ''),false),true,array("authorized" => (SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController,"BoUserModify"))) ? "true" : "false"));
$this->_xmlToolBox->addFullTag("user_delete",$this->_generic->getFullPath($this->_boController,"BoUserDelete",array("id" => ''),false),true,array("authorized" => (SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController,"BoUserDelete"))) ? "true" : "false"));
$this->_xmlToolBox->addFullTag("user_status",$this->_generic->getFullPath($this->_boController,"BoUserStatus",array("id" => ''),false),true,array("authorized" => (SLS_BoRights::isAuthorized("","",$this->_generic->getActionId($this->_boController,"BoUserStatus"))) ? "true" : "false"));
$this->_xmlToolBox->endTag("various");
# /URLs
# Server
$apcUpload = (in_array(ini_get("apc.rfc1867"),array(1,"1","On","on",true,"true"))) ? "true" : "false";
$apcUploadKey = ini_get("apc.rfc1867_name");
$uploadMaxFilesize = ini_get("upload_max_filesize");
$unite = strtolower(substr(trim($uploadMaxFilesize), -1));
switch ($unite)
{
case 'k': $uploadMaxFilesize = (int)$uploadMaxFilesize * 1024; break;
case 'm': $uploadMaxFilesize = (int)$uploadMaxFilesize * 1024 * 1024; break;
case 'g': $uploadMaxFilesize = (int)$uploadMaxFilesize * 1024 * 1024 * 1024; break;
default: $uploadMaxFilesize = $uploadMaxFilesize; break;
}
$this->_xmlToolBox->startTag("server");
$this->_xmlToolBox->addFullTag("apc_upload",$apcUpload,true);
$this->_xmlToolBox->addFullTag("apc_upload_key",$apcUploadKey,true);
$this->_xmlToolBox->addFullTag("upload_max_size",$uploadMaxFilesize,true);
$this->_xmlToolBox->endTag("server");
# /Server
}
}
