PHP Prospect::ProspectStatus Examples

Example #1

File: index.php Project: nrjacker4/crm-php

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;
    }