Forum

 
<?php
/*##################################################
 *                          RegateSetup.class.php
 *                            -------------------
*   begin                : September 13 2013
 *   copyright            : (C) 2013
 *  
 *
 *
 ###################################################
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 ###################################################*/
 
 // Cette classe permet de gérer les opérations spécifiques lors de l'installation, upgrade ou désinstallation d'un module
class RegateSetup extends DefaultModuleSetup
 
private static $regate_contact_table;
private static $regate_pointGPS_table;
 
public static function __static()
{
self::$regate_contact_table = PREFIX . 'regate_contact';
self::$regate_pointGPS_table = PREFIX . 'regate_pointGPS';
}
 
public function __construct()
{
$this->querier = PersistenceContext::get_querier();
}
 
// Installation initiale du module régate
public function install()
{
$this->drop_tables();
$this->create_tables();
}
 
// désinstalle le module régate de PHPBOOST
public function uninstall()
{
$this->drop_tables();
$this->delete_configuration();
}
// Efface les tables régate de la base de données
private function drop_tables()
{
PersistenceContext::get_dbms_utils()->drop(array(self::$regate_contact_table, self::$regate_pointGPS_table));
}
 
private function delete_configuration()
{
ConfigManager::delete('regate');
}
 
private function create_tables()
{
$this->create_regate_contact_table();
$this->create_regate_pointGPS_table();
}
public function upgrade($installed_version)
{
return '1.0.0';
}
 
// création de la table des contacts
private function create_regate_contact_table()
{
$fields = array(
'id' => array('type' => 'integer', 'length' => 11, 'autoincrement' => true, 'notnull' => 1),
'nom' => array('type' => 'string', 'length' => 255, 'default' => "''"),
'actif' => array('type' => 'boolean', 'length' => 1, 'notnull' => 1, 'default' => 0),
'description' => array('type' => 'text', 'length' => 65000, 'notnull' => 1)
);
$options = array(
'primary' => array('id')
);
PersistenceContext::get_dbms_utils()->create_table(self::$regate_contact_table, $fields, $options);
}
 
// création de la table des points GPS
private function create_regate_pointGPS_table()
{
$fields = array(
'id' => array('type' => 'integer', 'length' => 11, 'autoincrement' => true, 'notnull' => 1),
'idcontact' => array('type' => 'integer', 'length' => 11, 'notnull' => 1, 'default' => 0),
'longitude' => array('type' => 'float', 'length' => 11, 'notnull' => 1, 'default' => 0),
'marqueur' => array('type' => 'integer', 'length' => 11, 'notnull' => 1, 'default' => 0)
);
$options = array(
'primary' => array('id')
);
 
PersistenceContext::get_dbms_utils()->create_table(self::$regate_pointGPS_table, $fields, $options);
}
}
?>
 
 

private $querier;

private static $regate_contact_table;
private static $regate_pointGPS_table;