function loadLines(&$PDOdb, $id_expeditionLine)
{
$sql = "SELECT rowid FROM " . $this->get_table() . " WHERE fk_expeditiondet = " . $id_expeditionLine . " ORDER BY rang";
$TIdExpedet = TRequeteCore::_get_id_by_sql($PDOdb, $sql);
foreach ($TIdExpedet as $idexpedet) {
$dispatchdetail_temp = new TDispatchDetail();
$dispatchdetail_temp->load($PDOdb, $idexpedet);
$this->lines[] = $dispatchdetail_temp;
$this->nbLines = $this->nbLines + 1;
}
}
static function getDashboard(&$PDOdb, $hook = '', $fk_user = 0, $withTitle = false)
{
$Tab = array();
$sql = "SELECT rowid, uid, title, refresh_dashboard FROM " . MAIN_DB_PREFIX . "qdashboard qd \n\t\tWHERE 1 ";
if ($hook) {
$sql .= " AND qd.hook='" . $hook . "'";
}
if ($fk_user > 0) {
$sql .= " AND (qd.fk_user_author=" . $fk_user . " OR qd.fk_usergroup IN (SELECT fk_usergroup FROM " . MAIN_DB_PREFIX . "usergroup_user WHERE fk_user="******" ) )";
}
$sql .= " ORDER BY title";
$Tab = TRequeteCore::_get_id_by_sql($PDOdb, $sql, $withTitle ? 'title' : 'uid', 'rowid');
return $Tab;
}
static function getMenu(&$PDOdb, $type)
{
global $langs;
if ($type == 'main') {
$Tab = TRequeteCore::_get_id_by_sql($PDOdb, "SELECT DISTINCT mainmenu FROM " . MAIN_DB_PREFIX . "menu WHERE 1 ORDER BY mainmenu", 'mainmenu', 'mainmenu');
$Tab['companies'] = 'companies';
} else {
$Tab = TRequeteCore::_get_id_by_sql($PDOdb, "SELECT DISTINCT leftmenu FROM " . MAIN_DB_PREFIX . "menu WHERE 1 ORDER BY leftmenu", 'leftmenu', 'leftmenu');
$Tab['thirdparties'] = 'thirdparties';
$Tab['query'] = 'query';
$Tab['projects'] = 'projects';
$Tab['customers_bills'] = 'customers_bills';
}
return $Tab;
}
static function get_keyval_by_sql(&$db, $sql, $fieldkey, $fieldval)
{
return TRequeteCore::_get_id_by_sql($db, $sql, $fieldval, $fieldkey);
}
