27 require
'../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.
'/don/class/don.class.php';
33 $hookmanager->initHooks(array(
'donationindex'));
35 $langs->load(
"donations");
40 $donation_static =
new Don($db);
54 $donstatic =
new Don($db);
56 $help_url =
'EN:Module_Donations|FR:Module_Dons|ES:Módulo_Donaciones|DE:Modul_Spenden';
64 $sql =
"SELECT count(d.rowid) as nb, sum(d.amount) as somme , d.fk_statut";
65 $sql .=
" FROM ".MAIN_DB_PREFIX.
"don as d WHERE d.entity IN (".
getEntity(
'donation').
")";
66 $sql .=
" GROUP BY d.fk_statut";
67 $sql .=
" ORDER BY d.fk_statut";
69 $result = $db->query($sql);
72 $num = $db->num_rows($result);
74 $objp = $db->fetch_object($result);
76 $somme[$objp->fk_statut] = $objp->somme;
77 $nb[$objp->fk_statut] = $objp->nb;
78 $total += $objp->somme;
87 print
load_fiche_titre($langs->trans(
"DonationsArea"),
'',
'object_donation');
90 print
'<div class="fichecenter"><div class="fichethirdleft">';
92 if (!empty($conf->global->MAIN_SEARCH_FORM_ON_HOME_AREAS)) {
93 if (!empty($conf->don->enabled) && $user->rights->don->lire) {
94 $listofsearchfields[
'search_donation'] = array(
'text'=>
'Donation');
97 if (count($listofsearchfields)) {
98 print
'<form method="post" action="'.DOL_URL_ROOT.
'/core/search.php">';
99 print
'<input type="hidden" name="token" value="'.newToken().
'">';
100 print
'<table class="noborder nohover centpercent">';
102 foreach ($listofsearchfields as $key => $value) {
104 print
'<tr class="liste_titre"><td colspan="3">'.$langs->trans(
"Search").
'</td></tr>';
106 print
'<tr '.$bc[
false].
'>';
107 print
'<td class="nowrap"><label for="'.$key.
'">'.$langs->trans($value[
"text"]).
'</label></td><td><input type="text" class="flat inputsearch" name="'.$key.
'" id="'.$key.
'"></td>';
109 print
'<td rowspan="'.count($listofsearchfields).
'"><input type="submit" class="button" value="'.$langs->trans(
"Search").
'"></td>';
120 $dataseries = array();
121 $colorseries = array();
123 include DOL_DOCUMENT_ROOT.
'/theme/'.$conf->theme.
'/theme_vars.inc.php';
125 print
'<table class="noborder nohover centpercent">';
126 print
'<tr class="liste_titre">';
127 print
'<th colspan="4">'.$langs->trans(
"Statistics").
'</th>';
130 $listofstatus = array(0, 1, -1, 2);
131 foreach ($listofstatus as $status) {
132 $dataseries[] = array($donstatic->LibStatut($status, 1), (isset($nb[$status]) ? (
int) $nb[$status] : 0));
133 if ($status == Don::STATUS_DRAFT) {
134 $colorseries[$status] =
'-'.$badgeStatus0;
136 if ($status == Don::STATUS_VALIDATED) {
137 $colorseries[$status] = $badgeStatus1;
139 if ($status == Don::STATUS_CANCELED) {
140 $colorseries[$status] = $badgeStatus9;
142 if ($status == Don::STATUS_PAID) {
143 $colorseries[$status] = $badgeStatus6;
147 if ($conf->use_javascript_ajax) {
148 print
'<tr><td class="center" colspan="4">';
150 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
152 $dolgraph->SetData($dataseries);
153 $dolgraph->SetDataColor(array_values($colorseries));
154 $dolgraph->setShowLegend(2);
155 $dolgraph->setShowPercent(1);
156 $dolgraph->SetType(array(
'pie'));
157 $dolgraph->setHeight(
'200');
158 $dolgraph->draw(
'idgraphstatus');
159 print $dolgraph->show($total ? 0 : 1);
164 print
'<tr class="liste_titre">';
165 print
'<td>'.$langs->trans(
"Status").
'</td>';
166 print
'<td class="right">'.$langs->trans(
"Number").
'</td>';
167 print
'<td class="right">'.$langs->trans(
"Total").
'</td>';
168 print
'<td class="right">'.$langs->trans(
"Average").
'</td>';
173 foreach ($listofstatus as $status) {
174 print
'<tr class="oddeven">';
175 print
'<td><a href="list.php?search_status='.$status.
'">'.$donstatic->LibStatut($status, 4).
'</a></td>';
176 print
'<td class="right">'.(!empty($nb[$status]) ? $nb[$status] :
' ').
'</td>';
177 print
'<td class="right nowraponall amount">'.(!empty($nb[$status]) ?
price($somme[$status],
'MT') :
' ').
'</td>';
178 print
'<td class="right nowraponall">'.(!empty($nb[$status]) ?
price(
price2num($somme[$status] / $nb[$status],
'MT')) :
' ').
'</td>';
179 $totalnb += (!empty($nb[$status]) ? $nb[$status] : 0);
180 $total += (!empty($somme[$status]) ? $somme[$status] : 0);
184 print
'<tr class="liste_total">';
185 print
'<td>'.$langs->trans(
"Total").
'</td>';
186 print
'<td class="right nowraponall">'.$totalnb.
'</td>';
187 print
'<td class="right nowraponall">'.price($total,
'MT').
'</td>';
188 print
'<td class="right nowraponall">'.($totalnb ?
price(
price2num($total / $totalnb,
'MT')) :
' ').
'</td>';
193 print
'</div><div class="fichetwothirdright">';
202 $sql =
"SELECT c.rowid, c.ref, c.fk_statut, c.societe, c.lastname, c.firstname, c.tms as datem, c.amount";
203 $sql .=
" FROM ".MAIN_DB_PREFIX.
"don as c";
204 $sql .=
" WHERE c.entity = ".$conf->entity;
206 $sql .=
" ORDER BY c.tms DESC";
207 $sql .= $db->plimit($max, 0);
209 $resql = $db->query($sql);
211 print
'<table class="noborder centpercent">';
212 print
'<tr class="liste_titre">';
213 print
'<th colspan="5">'.$langs->trans(
"LastModifiedDonations", $max).
'</th></tr>';
215 $num = $db->num_rows(
$resql);
219 $obj = $db->fetch_object(
$resql);
221 print
'<tr class="oddeven">';
223 $donation_static->id = $obj->rowid;
224 $donation_static->ref = $obj->ref ? $obj->ref : $obj->rowid;
226 print
'<td width="96" class="nobordernopadding nowrap">';
227 print $donation_static->getNomUrl(1);
230 print
'<td class="nobordernopadding">';
232 print ($obj->societe && ($obj->lastname || $obj->firstname) ?
' / ' :
'');
236 print
'<td class="right nobordernopadding nowraponall amount">';
237 print
price($obj->amount, 1);
241 print
'<td class="center">'.dol_print_date($db->jdate($obj->datem),
'day').
'</td>';
243 print
'<td class="right">'.$donation_static->LibStatut($obj->fk_statut, 5).
'</td>';
249 print
"</table><br>";
255 print
'</div></div>';
257 $parameters = array(
'user' => $user);
258 $reshook = $hookmanager->executeHooks(
'dashboardDonation', $parameters, $object);