function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'commercial_category');
parent::add_champs('fk_user,fk_category', array('type' => 'int', 'index' => true));
parent::_init_vars('label');
parent::start();
}
function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'remise');
parent::add_champs('palier,remise', array('type' => 'float', 'index' => true));
parent::add_champs('zip,type', array('index' => true));
parent::add_champs('fk_shipment_mode', array('type' => 'int', 'index' => true));
parent::_init_vars();
parent::start();
}
function __construct()
{
$this->set_table(MAIN_DB_PREFIX . 'product_cost_price_log');
parent::add_champs('fk_supplier,fk_product', array('type' => 'integer', 'index' => true));
parent::add_champs('qty,price', array('type' => 'float'));
parent::add_champs('log_type', array('index' => true, 'type' => 'string', 'length' => 10));
parent::_init_vars();
parent::start();
//log_type : PA, PMP, OF
}
function __construct()
{
parent::set_table(MAIN_DB_PREFIX . 'propale_history');
parent::add_champs('serialized_parent_propale', 'type=text;index');
parent::add_champs('fk_propale', 'type=entier;index');
parent::add_champs('date_version', 'type=date;');
parent::add_champs('total', 'type=float;');
parent::start();
parent::_init_vars();
}
function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'dispatch_asset');
parent::add_champs('fk_object,fk_dispatch,fk_asset', array('type' => 'int', 'index' => true));
parent::add_champs('type_object', array('length' => 30, 'index' => true));
parent::_init_vars();
parent::start();
$this->asset = new TAsset();
}
function __construct()
{
/* declaration */
global $conf;
parent::set_table(MAIN_DB_PREFIX . 'factor');
parent::add_champs('fk_soc,fk_bank_account', array('type' => 'int', 'index' => true));
//type de valideur
parent::add_champs('mention', array('type' => 'text'));
parent::_init_vars();
parent::start();
}
function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'qdashboard_query');
parent::add_champs('fk_qdashboard,fk_query', array('type' => 'integer', 'index' => true));
parent::add_champs('width,height,posx,posy', array('type' => 'integer'));
parent::_init_vars('title');
parent::start();
$this->query = null;
$this->width = $this->height = $this->posx = $this->posy = 1;
}
function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'recurrence');
parent::add_champs('fk_chargesociale', array('type' => 'entier', 'index' => true));
parent::add_champs('periode', array('type' => 'text'));
parent::add_champs('nb_previsionnel', array('type' => 'entier'));
parent::add_champs('date_fin', array('type' => 'date'));
parent::_init_vars();
parent::start();
$this->lines = array();
$this->nbLines = 0;
}
function __construct()
{
parent::set_table(MAIN_DB_PREFIX . 'query_bdd_connector');
parent::add_champs('host,login,password,db_name,db_type,charset', array('type' => 'string', 'length' => 128));
parent::add_champs('port', array('type' => 'integer'));
parent::add_champs('entity', array('type' => 'integer', 'index' => true));
parent::_init_vars();
parent::start();
$this->db_type = 'mysql';
$this->TDBType = array('mysql' => 'MySQL');
$this->pdodb = null;
$this->is_connected = false;
}
function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'commande_fournisseurdet_asset');
parent::add_champs('fk_commandedet,fk_product,fk_warehouse', 'type=entier;index;');
parent::add_champs('rang', 'type=entier;');
parent::add_champs('lot_number,carton,numerosuivi,imei,firmware,serial_number', 'type=chaine;');
parent::add_champs('weight, weight_reel, tare', 'type=float;');
parent::add_champs('dluo', 'type=date;');
parent::add_champs('weight_unit, weight_reel_unit, tare_unit', 'type=entier;');
parent::_init_vars();
parent::start();
}
function __construct()
{
global $langs, $db;
parent::set_table(MAIN_DB_PREFIX . 'routing');
parent::add_champs('trigger_code,trigger_code_reverse', array('index' => true, 'type' => 'string', 'length' => 50));
parent::add_champs('fk_warehouse_from,fk_warehouse_to', array('index' => true, 'type' => 'integer'));
parent::add_champs('check_old', array('type' => 'integer'));
parent::add_champs('message_condition,message_code', array('type' => 'text'));
parent::_init_vars('qty_field,fk_product_field,lines_field,product_type_field');
parent::start();
$this->qty_field = 'qty';
$this->fk_product_field = 'fk_product';
$this->lines_field = 'lines';
$this->product_type_field = 'product_type';
}
function __construct()
{
global $langs;
parent::set_table(MAIN_DB_PREFIX . 'query_menu');
parent::add_champs('fk_menu,fk_const_tab,fk_query,fk_dashboard,entity', array('type' => 'int', 'index' => true));
parent::_init_vars('title,perms,mainmenu,leftmenu,type_menu,tab_object');
parent::start();
$this->type_menu = 'MENU';
$this->TTypeMenu = array('MENU' => $langs->trans('Menu'), 'TAB' => $langs->trans('Tab'));
$this->TTabObject = array('thirdparty' => $langs->trans('Thirdparty'), 'contact' => $langs->trans('Contact'), 'product' => $langs->trans('Product'), 'user' => $langs->trans('User'), 'group' => $langs->trans('Group'), 'project' => $langs->trans('Project'));
}
function TSSObjet(&$db, $table)
{
parent::set_table($table);
parent::init_vars_by_db($db);
parent::start();
}