37@phan-var-force string $projectsListId
38@phan-var-force int $socid
39@phan-var-force string[] $listofoppstatus
40@phan-var-force ?array<int,string> $listofopplabel
41@phan-var-force array<string,string> $colorseries
42@phan-var-force ?string $badgeStatus2
46 $sql =
"SELECT p.fk_opp_status as opp_status, cls.code, COUNT(p.rowid) as nb, SUM(p.opp_amount) as opp_amount, SUM(p.opp_amount * p.opp_percent) as ponderated_opp_amount";
47 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p LEFT JOIN ".MAIN_DB_PREFIX.
"c_lead_status as cls ON p.fk_opp_status = cls.rowid";
48 $sql .=
" WHERE p.entity IN (".getEntity(
'project').
")";
49 $sql .=
" AND p.fk_statut = 1";
50 if ($mine || !$user->hasRight(
'projet',
'all',
'lire')) {
51 $sql .=
" AND p.rowid IN (".$db->sanitize($projectsListId).
")";
54 $sql .=
" AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).
")";
56 $sql .=
" GROUP BY p.fk_opp_status, cls.code";
57 $resql = $db->query($sql);
60 $num = $db->num_rows($resql);
67 $ponderated_opp_amount = 0;
69 $valsamount = array();
70 $dataseries = array();
73 $obj = $db->fetch_object($resql);
75 $valsnb[$obj->opp_status] = $obj->nb;
76 $valsamount[$obj->opp_status] = $obj->opp_amount;
78 if ($obj->opp_status) {
79 $totaloppnb += $obj->nb;
81 if (!in_array($obj->code, array(
'WON',
'LOST'))) {
82 $totalamount += $obj->opp_amount;
83 $ponderated_opp_amount += $obj->ponderated_opp_amount;
91 $ponderated_opp_amount /= 100;
93 print
'<div class="div-table-responsive-no-min">';
94 print
'<table class="noborder nohover centpercent">';
95 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"Statistics").
' - '.$langs->trans(
"OpportunitiesStatusForOpenedProjects").
'</th></tr>'.
"\n";
97 $listofstatus = array_keys($listofoppstatus);
99 foreach ($valsamount as $key => $val) {
100 if (!in_array($key, $listofstatus) && $key) {
101 $listofstatus[] = $key;
102 if (!isset($colorseries[$key])) {
103 $colorseries[$key] = !empty($badgeStatus2) ? $badgeStatus2 :
'#888888';
108 foreach ($listofstatus as $status) {
113 $labelStatus = $langs->transnoentitiesnoconv(
"OppStatus".$code);
114 if ($code ==
'WON' || $code ==
'LOST') {
115 $labelStatus = $langs->transnoentitiesnoconv(
"OppStatus".$code).
' ('.$langs->transnoentitiesnoconv(
"NotClosedYet").
")";
118 if (empty($labelStatus) && isset($listofopplabel[$status])) {
119 $labelStatus = $listofopplabel[$status];
121 if (empty($labelStatus)) {
122 $labelStatus = $langs->transnoentitiesnoconv(
'OldValue', $status);
128 $dataseries[] = array($labelStatus, (isset($valsamount[$status]) ? (
float) $valsamount[$status] : 0));
129 if (!
$conf->use_javascript_ajax) {
130 print
'<tr class="oddeven">';
131 print
'<td>'.$labelStatus.
'</td>';
132 print
'<td class="right"><a href="list.php?statut='.$status.
'">'.
price((isset($valsamount[$status]) ? (
float) $valsamount[$status] : 0), 0,
'', 1, -1, -1,
$conf->currency).
'</a></td>';
136 if (
$conf->use_javascript_ajax) {
137 print
'<tr><td class="center nopaddingleftimp nopaddingrightimp pair nohover" colspan="2">';
139 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
141 $dolgraph->SetData($dataseries);
142 $dolgraph->SetDataColor(array_values($colorseries));
143 $dolgraph->setShowLegend(2);
144 $dolgraph->setShowPercent(1);
145 $dolgraph->SetType(array(
'pie'));
147 $dolgraph->SetHeight(
'200');
148 $dolgraph->draw(
'idgraphstatus');
149 print $dolgraph->show($totaloppnb ? 0 : 1);
155 print
'<tr class="liste_total"><td class="maxwidth200 tdoverflow">';
156 print $form->textwithpicto($langs->trans(
"OpportunityTotalAmount"), $langs->trans(
"WonLostExcluded")).
'</td><td class="right">'.
price($totalamount, 0,
'', 1, -1, -1,
$conf->currency).
'</td></tr>';
157 print
'<tr class="liste_total"><td class="minwidth200 tdoverflow">';
159 print $form->textwithpicto($langs->trans(
"OpportunityPonderatedAmount"), $langs->trans(
"OpportunityPonderatedAmountDesc").
' ('.$langs->trans(
"WonLostExcluded").
')', 1);
160 print
'</td><td class="right">'.price(
price2num($ponderated_opp_amount,
'MT'), 0,
'', 1, -1, -1,
$conf->currency).
'</td></tr>';
166 dol_print_error($db);
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
dol_getIdFromCode($db, $key, $tablename, $fieldkey='code', $fieldid='id', $entityfilter=0, $filters='', $useCache=true)
Return an id or code from a code or id.
price2num($amount, $rounding='', $option=0, $currencycode='')
Function that return a number with universal decimal format (decimal separator is '.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.