if ($conf->highcharts->enabled && $user->rights->highcharts->read) {
dol_include_once("/highCharts/class/highCharts.class.php");
$langs->load("highcharts@highCharts");
$graph = new HighCharts($db);
$graph->width = "100%";
$graph->height = "300px";
$graph->name = "ProspectionStatus";
$graph->label = $langs->trans("ProspectionStatus");
if ($user->rights->highcharts->all) {
$graph->mine = 0;
}
$graph->ProspectStatus();
}
//print '<br>';
$prospect = new Prospect($db);
$prospect->ProspectStatus();
/*
* Last modified customers or prospects
*/
if ($conf->societe->enabled && $user->rights->societe->lire) {
$langs->load("boxes");
$sql = "SELECT s.rowid,s.nom,s.client,s.datec,s.tms";
$sql .= " FROM " . MAIN_DB_PREFIX . "societe as s";
if (!$user->rights->societe->client->voir && !$socid) {
$sql .= ", " . MAIN_DB_PREFIX . "societe_commerciaux as sc";
}
$sql .= " WHERE s.client IN (1, 2, 3)";
$sql .= " AND s.entity = " . $conf->entity;
if (!$user->rights->societe->client->voir && !$socid) {
$sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = " . $user->id;
}