public static function add($name, $description = "", $grantAdmin = true)
{
$sectionManager = new Section();
if ($sectionManager->rowCount(array('label' => $name)) == 0) {
$sectionManager->setLabel($name);
$sectionManager->setDescription($description);
$sectionManager->save();
if ($grantAdmin) {
$right = new Right();
$right = $right->load(array('section' => $sectionManager->getLabel(), 'rank' => 1));
$right = !$right ? new Right() : $right;
$right->setSection($sectionManager->getId());
$right->setCreate(1);
$right->setRead(1);
$right->setUpdate(1);
$right->setDelete(1);
$right->setRank(1);
$right->save();
}
}
}
<?php
require_once 'KodiCmd.class.php';
$table = new KodiCmd();
$table->create();
$s1 = new Section();
$s1->setLabel('kodi');
$s1->save();
$r1 = new Right();
$r1->setSection($s1->getId());
$r1->setRead('1');
$r1->setDelete('1');
$r1->setCreate('1');
$r1->setUpdate('1');
$r1->setRank('1');
$r1->save();
$conf = new Configuration();
$conf->put('plugin_kodiCmd_api_url_kodi', 'http://192.168.1.107:85/jsonrpc');
$conf->put('plugin_kodiCmd_api_timeout_kodi', 5);
$conf->put('plugin_kodiCmd_api_recognition_status', '');
$ro = new Room();
$ro->setName('KODI');
$ro->setDescription('De la bonne zic, un bon p\'tit film....');
$ro->save();
$roomManager = new Room();
$rooms = $roomManager->populate();
foreach ($rooms as $room) {
if ($room->getName() == "KODI") {
$kodiRoomId = $room->getId();
}
}
protected function loadEntities($simulator, $datasources)
{
foreach ($datasources->DataSource as $datasource) {
$datasourceObj = new DataSource($this, (int) $datasource['id'], (string) $datasource['name'], (string) $datasource['type']);
$datasourceObj->setUri((string) $datasource['uri']);
$datasourceObj->setMethod((string) $datasource['method']);
$datasourceObj->setDatabase((int) $datasource['database']);
$datasourceObj->setDescription((string) $datasource->Description);
foreach ($datasource->Namespace as $namespace) {
$datasourceObj->addNamespace((string) $namespace['prefix'], (string) $namespace['uri']);
}
$this->datasources[] = $datasourceObj;
}
if ($datasources->Databases) {
foreach ($datasources->Databases->Database as $database) {
$databaseObj = new Database($this, (int) $database['id'], (string) $database['type'], (string) $database['name']);
$databaseObj->setLabel((string) $database['label']);
$databaseObj->setHost((string) $database['host']);
$databaseObj->setPort((int) $database['port']);
$databaseObj->setUser((string) $database['user']);
if ((string) $database['password'] != '') {
$databaseObj->setPassword((string) $database['password']);
} elseif ((string) $database['user'] != '') {
try {
$user = $this->controller->get('kernel')->getContainer()->getParameter('database_user');
if ((string) $database['user'] == $user) {
$databaseObj->setPassword($this->controller->get('kernel')->getContainer()->getParameter('database_password'));
}
} catch (\Exception $e) {
}
}
$this->databases[] = $databaseObj;
}
}
$this->setName((string) $simulator["name"]);
$this->setLabel((string) $simulator["label"]);
$this->setDefaultView((string) $simulator["defaultView"]);
$this->setReferer((string) $simulator["referer"]);
$this->setDynamic((string) $simulator['dynamic'] == '1');
$this->setMemo((string) $simulator['memo'] == '1');
$this->setDescription((string) $simulator->Description);
$this->setRelatedInformations($simulator->RelatedInformations);
$this->setDateFormat((string) $simulator->DataSet['dateFormat']);
$this->setDecimalPoint((string) $simulator->DataSet['decimalPoint']);
$this->setMoneySymbol((string) $simulator->DataSet['moneySymbol']);
$this->setSymbolPosition((string) $simulator->DataSet['symbolPosition']);
if ($simulator->DataSet) {
foreach ($simulator->DataSet->children() as $child) {
if ($child->getName() == "DataGroup") {
$datagroup = $child;
$dataGroupObj = new DataGroup($this, (int) $datagroup['id'], (string) $datagroup['name']);
$dataGroupObj->setLabel((string) $datagroup['label']);
$dataGroupObj->setDescription((string) $datagroup->Description);
foreach ($datagroup->Data as $data) {
$dataGroupObj->addData($this->loadData($data));
}
$this->datas[] = $dataGroupObj;
} elseif ($child->getName() == "Data") {
$this->datas[] = $this->loadData($child);
}
}
}
if ($simulator->Profiles) {
$this->profiles = new Profiles($this);
$this->profiles->setLabel((string) $simulator->Profiles['label']);
foreach ($simulator->Profiles->Profile as $profile) {
$profileObj = new Profile((int) $profile['id'], (string) $profile['name']);
$profileObj->setLabel((string) $profile['label']);
$profileObj->setDescription((string) $profile->Description);
foreach ($profile->Data as $data) {
$profileObj->addData((int) $data['id'], (string) $data['default']);
}
$this->profiles->addProfile($profileObj);
}
}
if ($simulator->Steps) {
$step0 = false;
foreach ($simulator->Steps->Step as $step) {
$stepObj = new Step($this, (int) $step['id'], (string) $step['name'], (string) $step['label'], (string) $step['template']);
if ($stepObj->getId() == 0) {
$step0 = true;
}
$stepObj->setOutput((string) $step['output']);
$stepObj->setDescription((string) $step->Description);
$stepObj->setDynamic((string) $step['dynamic'] == '1');
foreach ($step->Panels->Panel as $panel) {
$panelObj = new Panel($stepObj, (int) $panel['id']);
$panelObj->setName((string) $panel['name']);
$panelObj->setLabel((string) $panel['label']);
foreach ($panel->children() as $block) {
if ($block->getName() == "FieldSet") {
$fieldset = $block;
$fieldsetObj = new FieldSet($panelObj, (int) $fieldset['id']);
$fieldsetObj->setLegend((string) $fieldset->Legend);
if ((string) $fieldset['disposition'] != "") {
$fieldsetObj->setDisposition((string) $fieldset['disposition']);
}
if ((string) $fieldset['display'] != "") {
$fieldsetObj->setDisplay((string) $fieldset['display']);
}
if ((string) $fieldset['popinLink'] != "") {
$fieldsetObj->setPopinLink((string) $fieldset['popinLink']);
}
foreach ($fieldset->children() as $child) {
if ($child->getName() == "Columns") {
foreach ($child->Column as $column) {
$columnObj = new Column(null, (int) $column['id'], (string) $column['name'], (string) $column['type']);
$columnObj->setLabel((string) $column['label']);
$fieldsetObj->addColumn($columnObj);
}
} elseif ($child->getName() == "FieldRow") {
$fieldrow = $child;
$fieldRowObj = new FieldRow($fieldsetObj, (string) $fieldrow['label']);
$fieldRowObj->setColon((string) $fieldrow['colon'] == '' || (string) $fieldrow['colon'] == '1');
$fieldRowObj->setHelp((string) $fieldrow['help'] == '1');
$fieldRowObj->setEmphasize((string) $fieldrow['emphasize'] == '1');
$fieldRowObj->setDataGroup((string) $fieldrow['datagroup']);
foreach ($fieldrow->Field as $field) {
$fieldObj = new Field($fieldsetObj, (int) $field['position'], (int) $field['data'], (string) $field['label']);
$fieldObj->setUsage((string) $field['usage']);
$fieldObj->setPrompt((string) $field['prompt']);
$fieldObj->setNewline((string) $field['newline'] == '' || (string) $field['newline'] == '1');
$fieldObj->setRequired((string) $field['required'] == '1');
$fieldObj->setVisibleRequired((string) $field['visibleRequired'] == '1');
$fieldObj->setColon((string) $field['colon'] == '' || (string) $field['colon'] == '1');
$fieldObj->setUnderlabel((string) $field['underlabel'] == '1');
$fieldObj->setHelp((string) $field['help'] == '1');
$fieldObj->setEmphasize((string) $field['emphasize'] == '1');
$fieldObj->setExplanation((string) $field['explanation']);
$fieldObj->setExpanded((string) $field['expanded'] == '1');
if ($field->PreNote) {
$noteObj = new FieldNote($this);
$noteObj->setText((string) $field->PreNote);
$fieldObj->setPreNote($noteObj);
}
if ($field->PostNote) {
$noteObj = new FieldNote($this);
$noteObj->setText((string) $field->PostNote);
$fieldObj->setPostNote($noteObj);
}
$fieldRowObj->addField($fieldObj);
}
$fieldsetObj->addField($fieldRowObj);
} elseif ($child->getName() == "Field") {
$field = $child;
$fieldObj = new Field($fieldsetObj, (int) $field['position'], (int) $field['data'], (string) $field['label']);
$fieldObj->setUsage((string) $field['usage']);
$fieldObj->setPrompt((string) $field['prompt']);
$fieldObj->setNewline((string) $field['newline'] == '' || (string) $field['newline'] == '1');
$fieldObj->setRequired((string) $field['required'] == '1');
$fieldObj->setVisibleRequired((string) $field['visibleRequired'] == '1');
$fieldObj->setColon((string) $field['colon'] == '' || (string) $field['colon'] == '1');
$fieldObj->setUnderlabel((string) $field['underlabel'] == '1');
$fieldObj->setHelp((string) $field['help'] == '1');
$fieldObj->setEmphasize((string) $field['emphasize'] == '1');
$fieldObj->setExplanation((string) $field['explanation']);
$fieldObj->setExpanded((string) $field['expanded'] == '1');
if ($field->PreNote) {
$noteObj = new FieldNote($this);
$noteObj->setText((string) $field->PreNote);
$fieldObj->setPreNote($noteObj);
}
if ($field->PostNote) {
$noteObj = new FieldNote($this);
$noteObj->setText((string) $field->PostNote);
$fieldObj->setPostNote($noteObj);
}
$fieldsetObj->addField($fieldObj);
}
}
$panelObj->addFieldSet($fieldsetObj);
} elseif ($block->getName() == "BlockInfo") {
$blockinfo = $block;
$blockinfoObj = new BlockInfo($panelObj, (int) $blockinfo['id']);
$blockinfoObj->setName((string) $blockinfo['name']);
$blockinfoObj->setLabel((string) $blockinfo['label']);
foreach ($blockinfo->Chapter as $chapter) {
$chapterObj = new Chapter($blockinfoObj, (int) $chapter['id']);
$chapterObj->setName((string) $chapter['name']);
$chapterObj->setLabel((string) $chapter['label']);
$chapterObj->setIcon((string) $chapter['icon']);
$chapterObj->setCollapsible((string) $chapter['collapsible'] == '1');
foreach ($chapter->Section as $section) {
$sectionObj = new Section($chapterObj, (int) $section['id']);
$sectionObj->setName((string) $section['name']);
$sectionObj->setLabel((string) $section['label']);
$sectionObj->setContent((string) $section->Content);
$sectionObj->setAnnotations((string) $section->Annotations);
$chapterObj->addSection($sectionObj);
}
$blockinfoObj->addChapter($chapterObj);
}
$panelObj->addFieldSet($blockinfoObj);
}
}
$stepObj->addPanel($panelObj);
}
foreach ($step->ActionList as $actionList) {
foreach ($actionList as $action) {
$actionObj = new Action($stepObj, (string) $action['name'], (string) $action['label']);
$actionObj->setClass((string) $action['class']);
$actionObj->setWhat((string) $action['what']);
$actionObj->setFor((string) $action['for']);
$actionObj->setUri((string) $action['uri']);
$stepObj->addAction($actionObj);
}
}
foreach ($step->FootNotes as $footnotes) {
$footnotesObj = new FootNotes($stepObj);
if ((string) $footnotes['position'] != "") {
$footnotesObj->setPosition((string) $footnotes['position']);
}
foreach ($footnotes as $footnote) {
$footnoteObj = new FootNote($stepObj, (int) $footnote['id']);
$footnoteObj->setText((string) $footnote);
$footnotesObj->addFootNote($footnoteObj);
}
$stepObj->setFootNotes($footnotesObj);
}
$this->steps[] = $stepObj;
}
if (!$step0) {
$this->setDynamic(false);
}
}
if ($simulator->Sites) {
foreach ($simulator->Sites->Site as $site) {
$siteObj = new Site($this, (int) $site['id'], (string) $site['name'], (string) $site['home']);
$this->sites[] = $siteObj;
}
}
if ($simulator->Sources) {
foreach ($simulator->Sources->Source as $source) {
$sourceObj = new Source($this, (int) $source['id'], (string) $source['datasource'], (string) $source['returnType']);
$sourceObj->setRequest((string) $source['request']);
$sourceObj->setSeparator((string) $source['separator']);
$sourceObj->setDelimiter((string) $source['delimiter']);
$sourceObj->setReturnPath((string) $source['returnPath']);
foreach ($source->Parameter as $parameter) {
$parameterObj = new Parameter($sourceObj, (string) $parameter['type']);
$parameterObj->setName((string) $parameter['name']);
$parameterObj->setFormat((string) $parameter['format']);
$parameterObj->setData((int) $parameter['data']);
$sourceObj->addParameter($parameterObj);
}
$this->sources[] = $sourceObj;
}
}
if ($simulator->BusinessRules) {
foreach ($simulator->BusinessRules->BusinessRule as $brule) {
$businessRuleObj = new BusinessRule($this, 'rule-' . mt_rand(), (int) $brule['id'], (string) $brule['name']);
$businessRuleObj->setLabel((string) $brule['label']);
$businessRuleObj->setConditions((string) $brule->Conditions['value']);
if (preg_match_all("/#(\\d+)/", (string) $brule->Conditions['value'], $matches)) {
foreach ($matches[1] as $id) {
$data = $this->getDataById($id);
$data->addRuleDependency((int) $brule['id']);
}
}
if ($brule->Conditions->Condition) {
$businessRuleObj->setConnector($this->loadConnector($brule->Conditions->Condition));
} else {
if ($brule->Conditions->Connector) {
$businessRuleObj->setConnector($this->loadConnector($brule->Conditions->Connector));
}
}
foreach ($brule->IfActions->Action as $action) {
$ruleActionObj = new RuleAction((int) $action['id'], (string) $action['name']);
$ruleActionObj->setTarget((string) $action['target']);
$ruleActionObj->setData((string) $action['data']);
$ruleActionObj->setDatagroup((string) $action['datagroup']);
$ruleActionObj->setStep((string) $action['step']);
$ruleActionObj->setPanel((string) $action['panel']);
$ruleActionObj->setFieldset((string) $action['fieldset']);
$ruleActionObj->setField((string) $action['field']);
$ruleActionObj->setBlockinfo((string) $action['blockinfo']);
$ruleActionObj->setChapter((string) $action['chapter']);
$ruleActionObj->setSection((string) $action['section']);
$ruleActionObj->setPrenote((string) $action['prenote']);
$ruleActionObj->setPostnote((string) $action['postnote']);
$ruleActionObj->setFootnote((string) $action['footnote']);
$ruleActionObj->setAction((string) $action['action']);
$ruleActionObj->setChoice((string) $action['choice']);
$ruleActionObj->setValue((string) $action['value']);
$businessRuleObj->addIfAction($ruleActionObj);
if ((string) $action['name'] == "setAttribute" && preg_match_all("/#(\\d+)/", (string) $action['value'], $matches)) {
foreach ($matches[1] as $id) {
$data = $this->getDataById($id);
$data->addRuleDependency((int) $brule['id']);
}
}
}
foreach ($brule->ElseActions->Action as $action) {
$ruleActionObj = new RuleAction((int) $action['id'], (string) $action['name']);
$ruleActionObj->setTarget((string) $action['target']);
$ruleActionObj->setData((string) $action['data']);
$ruleActionObj->setDatagroup((string) $action['datagroup']);
$ruleActionObj->setStep((string) $action['step']);
$ruleActionObj->setPanel((string) $action['panel']);
$ruleActionObj->setFieldset((string) $action['fieldset']);
$ruleActionObj->setField((string) $action['field']);
$ruleActionObj->setBlockinfo((string) $action['blockinfo']);
$ruleActionObj->setChapter((string) $action['chapter']);
$ruleActionObj->setSection((string) $action['section']);
$ruleActionObj->setPrenote((string) $action['prenote']);
$ruleActionObj->setPostnote((string) $action['postnote']);
$ruleActionObj->setFootnote((string) $action['footnote']);
$ruleActionObj->setAction((string) $action['action']);
$ruleActionObj->setChoice((string) $action['choice']);
$ruleActionObj->setValue((string) $action['value']);
$businessRuleObj->addElseAction($ruleActionObj);
if ((string) $action['name'] == "setAttribute" && preg_match_all("/#(\\d+)/", (string) $action['value'], $matches)) {
foreach ($matches[1] as $id) {
$data = $this->getDataById($id);
$data->addRuleDependency((int) $brule['id']);
}
}
}
$this->businessrules[] = $businessRuleObj;
}
}
}
<?php
global $myUser;
require_once 'Dashboard.class.php';
require_once 'Widget.class.php';
$entity = new Dashboard();
$entity->create();
$entity->user = $myUser->getId();
$entity->label = "Général";
$entity->default = 1;
$entity->save();
$dashboard = $entity->id;
$entity = new Widget();
$entity->create();
$s1 = new Section();
$s1->setLabel('dashboard');
$s1->save();
$r1 = new Right();
$r1->setSection($s1->getId());
$r1->setRead('1');
$r1->setDelete('1');
$r1->setCreate('1');
$r1->setUpdate('1');
$r1->setRank('1');
$r1->save();
$entity->customQuery('INSERT INTO "yana_plugin_dashboard" ("id", "model", "data", "cell", "column", "minified","dashboard") VALUES (1, \'dash_profil\', \'null\', \'0\', \'0\', \'\',\'' . $dashboard . '\');');
$entity->customQuery('INSERT INTO "yana_plugin_dashboard" ("id", "model", "data", "cell", "column", "minified","dashboard") VALUES (2, \'dash_monitoring_ram\', \'null\', \'0\', \'1\', \'\',\'' . $dashboard . '\');');
$entity->customQuery('INSERT INTO "yana_plugin_dashboard" ("id", "model", "data", "cell", "column", "minified","dashboard") VALUES (3, \'dash_monitoring_system\', \'null\', \'0\', \'2\', \'\',\'' . $dashboard . '\');');
$entity->customQuery('INSERT INTO "yana_plugin_dashboard" ("id", "model", "data", "cell", "column", "minified","dashboard") VALUES (4, \'dash_monitoring_network\', \'null\', \'0\', \'2\', \'\',\'' . $dashboard . '\');');
$entity->customQuery('INSERT INTO "yana_plugin_dashboard" ("id", "model", "data", "cell", "column", "minified","dashboard") VALUES (5, \'dash_monitoring_hdd\', \'null\', \'3\', \'1\', \'\',\'' . $dashboard . '\');');
$entity->customQuery('INSERT INTO "yana_plugin_dashboard" ("id", "model", "data", "cell", "column", "minified","dashboard") VALUES (6, \'dash_monitoring_disk\', \'null\', \'0\', \'1\', \'\',\'' . $dashboard . '\');');
$configuration->put('COOKIE_NAME', 'yana');
$configuration->put('COOKIE_LIFETIME', '7');
$configuration->put('VOCAL_ENTITY_NAME', 'YANA');
$configuration->put('PROGRAM_VERSION', '3.0.6');
$configuration->put('HOME_PAGE', 'index.php');
$configuration->put('VOCAL_SENSITIVITY', '0.0');
//Création du rang admin
$rank = new Rank();
$rank->setLabel('admin');
$rank->save();
//Déclaration des sections du programme
$sections = array('event', 'vocal', 'user', 'plugin', 'configuration', 'admin');
//Création des sections déclarées et attribution de tous les droits sur toutes ces sections pour l'admin
foreach ($sections as $sectionName) {
$s = new Section();
$s->setLabel($sectionName);
$s->save();
$r = new Right();
$r->setSection($s->getId());
$r->setRead('1');
$r->setDelete('1');
$r->setCreate('1');
$r->setUpdate('1');
$r->setRank($rank->getId());
$r->save();
}
$personalities = array('John Travolta', 'Jeff Buckley', 'Tom Cruise', 'John Lennon', 'Emmet Brown', 'Geo trouvetou', 'Luke Skywalker', 'Mac Gyver', 'Marty McFly');
$im = $personalities[rand(0, count($personalities) - 1)];
list($fn, $n) = explode(' ', $im);
//Creation du premier compte et assignation en admin
$user->setMail($_POST['email']);
/*
Le code contenu dans cette page ne sera éxecuté qu'à l'activation du plugin
Vous pouvez donc l'utiliser pour créer des tables SQLite, des dossiers, ou executer une action
qui ne doit se lancer qu'à l'installation ex :
*/
require_once 'Sensor.class.php';
$table = new Sensor();
$table->create();
require_once 'SensorType.class.php';
$table2 = new SensorType();
$table2->create();
$s1 = new Section();
$s1->setLabel('sensor');
$s1->save();
$s2 = new Section();
$s2->setLabel('sensortypes');
$s2->save();
$r1 = new Right();
$r1->setSection($s1->getId());
$r1->setRead('1');
$r1->setDelete('1');
$r1->setCreate('1');
$r1->setUpdate('1');
$r1->setRank('1');
$r1->save();
$r2 = new Right();
$r2->setSection($s2->getId());
$r2->setRead('1');
$r2->setDelete('1');
$r2->setCreate('1');
$r2->setUpdate('1');