26 require
'../main.inc.php';
27 require_once DOL_DOCUMENT_ROOT.
'/don/class/don.class.php';
29 $langs->load(
"donations");
34 $donation_static=
new Don($db);
48 $donstatic=
new Don($db);
50 $help_url=
'EN:Module_Donations|FR:Module_Dons|ES:Módulo_Donaciones';
51 llxHeader(
'',$langs->trans(
"Donations"),$help_url);
57 $sql =
"SELECT count(d.rowid) as nb, sum(d.amount) as somme , d.fk_statut";
58 $sql.=
" FROM ".MAIN_DB_PREFIX.
"don as d WHERE d.entity IN (".
getEntity(
'donation').
")";
59 $sql.=
" GROUP BY d.fk_statut";
60 $sql.=
" ORDER BY d.fk_statut";
62 $result = $db->query($sql);
66 $num = $db->num_rows($result);
69 $objp = $db->fetch_object($result);
71 $somme[$objp->fk_statut] = $objp->somme;
72 $nb[$objp->fk_statut] = $objp->nb;
73 $total += $objp->somme;
85 print '<div class="fichecenter"><div class="fichethirdleft">';
87 if (! empty($conf->global->MAIN_SEARCH_FORM_ON_HOME_AREAS))
89 if (! empty($conf->don->enabled) && $user->rights->don->lire)
91 $listofsearchfields[
'search_donation']=array(
'text'=>
'Donation');
94 if (count($listofsearchfields))
96 print
'<form method="post" action="'.DOL_URL_ROOT.
'/core/search.php">';
97 print
'<input type="hidden" name="token" value="'.$_SESSION[
'newtoken'].
'">';
98 print
'<table class="noborder nohover centpercent">';
100 foreach($listofsearchfields as $key => $value)
102 if ($i == 0) print
'<tr class="liste_titre"><td colspan="3">'.$langs->trans(
"Search").
'</td></tr>';
103 print
'<tr '.$bc[
false].
'>';
104 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>';
105 if ($i == 0) print
'<td rowspan="'.count($listofsearchfields).
'"><input type="submit" value="'.$langs->trans(
"Search").
'" class="button"></td>';
116 print
'<table class="noborder nohover" width="100%">';
117 print
'<tr class="liste_titre">';
118 print
'<th colspan="4">'.$langs->trans(
"Statistics").
'</th>';
121 $listofstatus=array(0,1,-1,2);
122 foreach ($listofstatus as $status)
124 $dataseries[]=array($donstatic->LibStatut($status,1), (isset($nb[$status])?(int) $nb[$status]:0));
127 if ($conf->use_javascript_ajax)
129 print
'<tr><td align="center" colspan="4">';
131 include_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
133 $dolgraph->SetData($dataseries);
134 $dolgraph->setShowLegend(1);
135 $dolgraph->setShowPercent(1);
136 $dolgraph->SetType(array(
'pie'));
137 $dolgraph->setWidth(
'100%');
138 $dolgraph->draw(
'idgraphstatus');
139 print $dolgraph->show($total?0:1);
144 print
'<tr class="liste_titre">';
145 print
'<td>'.$langs->trans(
"Status").
'</td>';
146 print
'<td align="right">'.$langs->trans(
"Number").
'</td>';
147 print
'<td align="right">'.$langs->trans(
"Total").
'</td>';
148 print
'<td align="right">'.$langs->trans(
"Average").
'</td>';
153 foreach ($listofstatus as $status)
156 print
'<tr class="oddeven">';
157 print
'<td><a href="list.php?statut='.$status.
'">'.$donstatic->LibStatut($status,4).
'</a></td>';
158 print
'<td align="right">'.(! empty($nb[$status])?$nb[$status]:
' ').
'</td>';
159 print
'<td align="right">'.(! empty($nb[$status])?
price($somme[$status],
'MT'):
' ').
'</td>';
160 print
'<td align="right">'.(! empty($nb[$status])?
price(
price2num($somme[$status]/$nb[$status],
'MT')):
' ').
'</td>';
161 $totalnb += (! empty($nb[$status])?$nb[$status]:0);
162 $total += (! empty($somme[$status])?$somme[$status]:0);
166 print
'<tr class="liste_total">';
167 print
'<td>'.$langs->trans(
"Total").
'</td>';
168 print
'<td align="right">'.$totalnb.
'</td>';
169 print
'<td align="right">'.price($total,
'MT').
'</td>';
170 print
'<td align="right">'.($totalnb?
price(
price2num($total/$totalnb,
'MT')):
' ').
'</td>';
175 print
'</div><div class="fichetwothirdright"><div class="ficheaddleft">';
184 $sql =
"SELECT c.rowid, c.ref, c.fk_statut, c.societe, c.lastname, c.firstname, c.tms as datem, c.amount";
185 $sql.=
" FROM ".MAIN_DB_PREFIX.
"don as c";
186 $sql.=
" WHERE c.entity = ".$conf->entity;
188 $sql.=
" ORDER BY c.tms DESC";
189 $sql.= $db->plimit($max, 0);
194 print
'<table class="noborder" width="100%">';
195 print
'<tr class="liste_titre">';
196 print
'<th colspan="5">'.$langs->trans(
"LastModifiedDonations",$max).
'</th></tr>';
198 $num = $db->num_rows(
$resql);
204 $obj = $db->fetch_object(
$resql);
206 print
'<tr class="oddeven">';
208 $donation_static->id=$obj->rowid;
209 $donation_static->ref=$obj->ref?$obj->ref:$obj->rowid;
211 print
'<td width="96" class="nobordernopadding nowrap">';
212 print $donation_static->getNomUrl(1);
215 print
'<td class="nobordernopadding">';
217 print ($obj->societe && ($obj->lastname || $obj->firstname)?
' / ':
'');
221 print
'<td align="right" class="nobordernopadding">';
222 print
price($obj->amount,1);
226 print
'<td align="center">'.dol_print_date($db->jdate($obj->datem),
'day').
'</td>';
228 print
'<td align="right">'.$donation_static->LibStatut($obj->fk_statut,5).
'</td>';
234 print
"</table><br>";
239 print
'</div></div></div>';
load_fiche_titre($titre, $morehtmlright='', $picto='title_generic.png', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
print
Draft customers invoices.
if(! empty($conf->facture->enabled) && $user->rights->facture->lire) if(! empty($conf->fournisseur->enabled) && $user->rights->fournisseur->facture->lire) if(! empty($conf->don->enabled) && $user->rights->societe->lire) if(! empty($conf->tax->enabled) && $user->rights->tax->charges->lire) if(! empty($conf->facture->enabled) &&! empty($conf->commande->enabled) && $user->rights->commande->lire &&empty($conf->global->WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER)) if(! empty($conf->facture->enabled) && $user->rights->facture->lire) if(! empty($conf->fournisseur->enabled) && $user->rights->fournisseur->facture->lire) $resql
Social contributions to pay.
dol_print_error($db='', $error='', $errors=null)
Affiche message erreur system avec toutes les informations pour faciliter le diagnostic et la remonte...
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
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...
Class to manage donations.
restrictedArea($user, $features, $objectid=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0)
Check permissions of a user to show a page and an object.
price2num($amount, $rounding='', $alreadysqlnb=0)
Function that return a number with universal decimal format (decimal separator is '...
dolGetFirstLastname($firstname, $lastname, $nameorder=-1)
Return firstname and lastname in correct order.