query("SELECT COUNT(*) FROM leads")->fetchColumn();
$rdv = $pdo->query("SELECT COUNT(*) FROM rendez_vous")->fetchColumn();
$etudes = $pdo->query("SELECT COUNT(*) FROM etude_technique")->fetchColumn();
$devis = $pdo->query("SELECT COUNT(*) FROM devis")->fetchColumn();
$bdc = $pdo->query("SELECT COUNT(*) FROM bon_commande")->fetchColumn();
$commandes = $pdo->query("SELECT COUNT(*) FROM commandes_fournisseurs")->fetchColumn();
$poses = $pdo->query("SELECT COUNT(*) FROM poses")->fetchColumn();
$sav = $pdo->query("SELECT COUNT(*) FROM sav_interventions")->fetchColumn();
$derniers_leads = [];
$rdv_a_venir = [];
$etudes_attente = [];
$dossiers_recents = [];
$commandes_ouvertes = [];
$sav_ouverts = [];
$commerciaux = [];
$dernieres_actions = [];
try {
$derniers_leads = $pdo->query("
SELECT nom, ville, statut
FROM leads
ORDER BY id DESC
LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$rdv_a_venir = $pdo->query("
SELECT date_rdv, type_rdv
FROM rendez_vous
ORDER BY date_rdv DESC
LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$etudes_attente = $pdo->query("
SELECT id, type_projet, date_etude
FROM etudes_techniques
WHERE validation_technique = 0
ORDER BY id DESC
LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$dossiers_recents = $pdo->query("
SELECT reference_dossier, ville, statut_dossier
FROM dossiers_clients
ORDER BY id DESC
LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$commandes_ouvertes = $pdo->query("
SELECT fournisseur, statut, date_prevue_reception
FROM commandes_fournisseurs
WHERE statut <> 'recue'
ORDER BY id DESC
LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$sav_ouverts = $pdo->query("
SELECT type_sav, statut, date_demande
FROM sav_interventions
WHERE statut <> 'termine'
ORDER BY id DESC
LIMIT 5
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$commerciaux = $pdo->query("
SELECT prenom, nom, ville
FROM commerciaux
WHERE actif = 1
ORDER BY nom
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
try {
$dernieres_actions = $pdo->query("
SELECT type_action, date_action
FROM historique_actions
ORDER BY id DESC
LIMIT 10
")->fetchAll(PDO::FETCH_ASSOC);
} catch(Exception $e){}
?>
BSPC Dashboard
Commandes Fournisseurs
| Fournisseur | Statut | Réception |
|---|
|
|
|
Résumé BSPC
| Module | Total |
|---|
| Leads | |
| RDV | |
| Études | |
| Devis | |
| BDC | |
| Commandes | |
| Poses | |
| SAV | |