print "</table><br>"; $db->free($resql); } } /* * Liste des Affaires */ if ($conf->lead->enabled && $user->rights->lead->lire) { $socstatic = new Societe($db); $leadstatic = new Lead($db); if ($conf->rights->lead->all) { $mine = 1; } else { $mine = 0; } $leadsListId = $leadstatic->getLeadsAuthorizedForUser($user, $mine, 1); print_lead_array($db, 1, $socid, $leadsListId); } $NBMAX = 3; $max = 3; /* * Last modified proposals */ /* if ($conf->propal->enabled && $user->rights->propale->lire) { $sql = "SELECT s.nom as name, s.rowid as socid, s.client, s.canvas, p.rowid as propalid, p.total_ht, p.ref, p.fk_statut, p.datep as dp"; $sql.= " FROM ".MAIN_DB_PREFIX."societe as s"; $sql.= ", ".MAIN_DB_PREFIX."propal as p"; if (!$user->rights->societe->client->voir && !$socid) $sql.= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc"; $sql.= " WHERE p.fk_soc = s.rowid";