function create($type, $port)
{
$q0 = get_link()->prepare('insert into ' . get_ini('BDD_PREFIX') . 'cmdb_dev_os (id_device,os_type,os_name,os_port,os_install_date,os_last_boot_time,os_memory_size,created_date,created_id,edited_date,edited_id,deleted_date,deleted_id) VALUES (:id_device,:type,\'\',:port,0,0,0,:created_date,:created_id,0,0,0,0)');
$q0->execute(array('id_device' => $this->idDevice, 'type' => $type, 'port' => $port, 'created_date' => time(), 'created_id' => $_SESSION['USER_ID']));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('cmdb_dev_os'), $this->getId($type, $port));
return $this->getId($type, $port);
}
function create($parentId, $name)
{
$q0 = get_link()->prepare('insert into ' . get_ini('BDD_PREFIX') . 'cmdb_environments (id_parent,name,created_date,created_id,edited_date,edited_id,deleted_date,deleted_id) VALUES (:id_parent,:name,:created_date,:created_id,0,0,0,0)');
$q0->execute(array('id_parent' => $parentId, 'name' => $name, 'created_date' => time(), 'created_id' => $_SESSION['USER_ID']));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('cmdb_environments'), $this->getId($name));
return $this->getId($name);
}
function create($name, $type, $version, $port, $path)
{
$q0 = get_link()->prepare('insert into ' . get_ini('BDD_PREFIX') . 'cmdb_db_instances (id_os,name,db_type,db_version,db_port,db_bin_path,audited,created_date,created_id,edited_date,edited_id,deleted_date,deleted_id) VALUES (:id_os,:name,:db_type,:db_version,:db_port,:db_bin_path,:audited,:created_date,:created_id,0,0,0,0)');
$q0->execute(array('id_os' => $this->idOs, 'name' => $name, 'db_type' => $type, 'db_version' => $version, 'db_port' => $port, 'db_bin_path' => $path, 'audited' => '-1', 'created_date' => time(), 'created_id' => $_SESSION['USER_ID']));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('cmdb_db_instances'), $this->getId($name));
return $this->getId($name);
}
function create($name, $avatar, $mail)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_users (name,avatar,mail,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:name,:avatar,:mail,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('name' => strtolower($name), 'avatar' => $avatar, 'mail' => strtolower($mail), 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_users'), $this->getIdByName(strtolower($name)));
return $this->getId($mail);
}
function create($name, $icon)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_user_auth_methods (name,icon,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:name,:icon,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('name' => $name, 'icon' => $icon, 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_user_auth_methods'), $this->getId($name));
// Return the id of this new group
return $this->getId($name);
}
function create($idPlugin, $page)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_jobs (id_plugin,page,last_run_pid,last_run,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:id_plugin,:page,0,0,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('id_plugin' => $idPlugin, 'page' => $page, 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_job'), $this->getId($idPlugin, $page));
// Return the id of this new group
return $this->getId($idPlugin, $page);
}
function create($name, $version)
{
$q0 = get_link()->prepare('INSERT INTO ' . get_ini('BDD_PREFIX') . 'core_plugins (name,version,activated,created_id,created_date,edited_id,edited_date,deleted_id,deleted_date) VALUES (:name,:version,0,:created_id,:created_date,0,0,0,0)');
$q0->execute(array('name' => $name, 'version' => $version, 'created_id' => $_SESSION['USER_ID'], 'created_date' => time()));
// Create the object
$obj = new objectManager();
$obj->create(get_table_id('core_plugins'), $this->getId($name));
// Return the id of this new page
return $this->getId($name);
}
}
if ($groupM->getGroupUserMap($groupM->getId('guests'), $userM->getIdByName('#core#_#0#')) == 0) {
$groupM->addGroupUserMap($groupM->getId('guests'), $userM->getIdByName('#core#_#0#'));
}
// Add default auth
echo ' - Fill auths table<BR>';
$authM = new authManager();
$authMethodM = new authMethodManager();
$userM = new userManager();
if ($authM->getId($userM->getIdByName('admin'), $authMethodM->getId('LOCAL')) == 0) {
$authM->create($userM->getIdByName('admin'), $authMethodM->getId('LOCAL'), 'admin', 'gob', 'lib/avatars/brain.jpg', '', '', 'admin');
}
// Add default access
echo ' - Fill access table<BR>';
$accessM = new accessManager();
$objectM = new objectManager();
$groupM = new groupManager();
$pluginM = new pluginManager();
if ($accessM->getId($objectM->getId(getTableId('core_groups'), $groupM->getId('admins')), $objectM->getId(getTableId('core_plugins'), $pluginM->getId('core'))) == 0) {
$accessM->create($objectM->getId(getTableId('core_groups'), $groupM->getId('admins')), $objectM->getId(getTableId('core_plugins'), $pluginM->getId('core')), 100);
}
if ($accessM->getId($objectM->getId(getTableId('core_groups'), $groupM->getId('members')), $objectM->getId(getTableId('core_plugins'), $pluginM->getId('core'))) == 0) {
$accessM->create($objectM->getId(getTableId('core_groups'), $groupM->getId('members')), $objectM->getId(getTableId('core_plugins'), $pluginM->getId('core')), 20);
}
if ($accessM->getId($objectM->getId(getTableId('core_groups'), $groupM->getId('guests')), $objectM->getId(getTableId('core_plugins'), $pluginM->getId('core'))) == 0) {
$accessM->create($objectM->getId(getTableId('core_groups'), $groupM->getId('guests')), $objectM->getId(getTableId('core_plugins'), $pluginM->getId('core')), 10);
}
// Add default job
echo ' - Fill jobs table<BR>';
$jobM = new jobManager();
$pluginM = new pluginManager();
private function getAuthor(objectManager $manager, $name)
{
return $manager->getRepository('ModelBundle:Author')->findOneBy(array('name' => $name));
}
public static function getObjectId($table_name, $id_ext)
{
// Check if the ID is already known
if (!isset(self::$objects[$table_name][$id_ext])) {
$objM = new objectManager();
self::$objects[$table_name][$id_ext] = $objM->getId(self::getTableId($table_name), $id_ext);
}
return self::$objects[$table_name][$id_ext];
}
public function __construct(objectManager $om)
{
$this->repository = $om->getRepository('AppBundle:Provincia');
}
