print "</tr>\n";
if ($num > 0) {
$var = True;
while ($i < $num) {
$objp = $db->fetch_object($resql);
$var = !$var;
print '<tr ' . $bc[$var] . '>';
// Ref
print '<td>';
$don->fetch($objp->did);
print $don->getNomUrl(1);
print "</td>\n";
// Expected to pay
print '<td align="right">' . price($objp->d_amount) . '</td>';
// Status
print '<td align="center">' . $don->getLibStatut(4, $objp->amount) . '</td>';
// Amount payed
print '<td align="right">' . price($objp->amount) . '</td>';
print "</tr>\n";
if ($objp->paid == 1) {
$disable_delete = 1;
}
$total = $total + $objp->amount;
$i++;
}
}
$var = !$var;
print "</table>\n";
$db->free($resql);
} else {
dol_print_error($db);
if (trim($search_name) != '') {
$sql .= natural_search(array('d.lastname', 'd.firstname'), $search_name);
}
if ($search_amount) {
$sql .= " AND d.amount='" . $db->escape(price2num(trim($search_amount))) . "'";
}
$sql .= $db->order($sortfield, $sortorder);
$sql .= $db->plimit($limit + 1, $offset);
$resql = $db->query($sql);
if ($resql) {
$num = $db->num_rows($resql);
$i = 0;
$param = "&statut={$statut}&sortorder={$sortorder}&sortfield={$sortfield}";
if ($statut >= 0) {
$donationstatic->statut = $statut;
$label = $donationstatic->getLibStatut(0);
print_barre_liste($label, $page, $_SERVER["PHP_SELF"], $param, '', '', '', $num);
} else {
print_barre_liste($langs->trans("Donations"), $page, $_SERVER["PHP_SELF"], $param, '', '', '', $num);
}
print '<form method="get" action="' . $_SERVER["PHP_SELF"] . '">' . "\n";
print "<table class=\"noborder\" width=\"100%\">";
print '<tr class="liste_titre">';
print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "d.rowid", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder);
print_liste_field_titre($langs->trans("Company"), $_SERVER["PHP_SELF"], "d.societe", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder);
print_liste_field_titre($langs->trans("Name"), $_SERVER["PHP_SELF"], "d.lastname", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder);
print_liste_field_titre($langs->trans("Date"), $_SERVER["PHP_SELF"], "d.datedon", "&page={$page}&statut={$statut}", "", 'align="center"', $sortfield, $sortorder);
if (!empty($conf->projet->enabled)) {
$langs->load("projects");
print_liste_field_titre($langs->trans("Project"), $_SERVER["PHP_SELF"], "fk_projet", "&page={$page}&statut={$statut}", "", "", $sortfield, $sortorder);
}
print "<tr>" . '<td>' . $langs->trans("Firstname") . '</td><td><input type="text" name="prenom" size="40" value="' . $don->prenom . '"></td></tr>';
print "<tr>" . '<td>' . $langs->trans("Lastname") . '</td><td><input type="text" name="nom" size="40" value="' . $don->nom . '"></td></tr>';
print "<tr>" . '<td>' . $langs->trans("Address") . '</td><td>';
print '<textarea name="adresse" wrap="soft" cols="40" rows="' . ROWS_3 . '">' . $don->adresse . '</textarea></td></tr>';
// Zip / Town
print '<tr><td>' . $langs->trans("Zip") . ' / ' . $langs->trans("Town") . '</td><td>';
print $formcompany->select_ziptown(isset($_POST["zipcode"]) ? $_POST["zipcode"] : $don->zip, 'zipcode', array('town', 'selectcountry_id', 'departement_id'), 6);
print ' ';
print $formcompany->select_ziptown(isset($_POST["town"]) ? $_POST["town"] : $don->town, 'town', array('zipcode', 'selectcountry_id', 'departement_id'));
print '</tr>';
print "<tr>" . '<td>' . $langs->trans("Country") . '</td><td><input type="text" name="pays" size="40" value="' . $don->pays . '"></td></tr>';
print "<tr>" . '<td>' . $langs->trans("EMail") . '</td><td><input type="text" name="email" size="40" value="' . $don->email . '"></td></tr>';
print "<tr><td>" . $langs->trans("PaymentMode") . "</td><td>\n";
$form->select_types_paiements('', 'modepaiement', 'CRDT', 0, 1);
print "</td></tr>\n";
print "<tr>" . '<td>' . $langs->trans("Status") . '</td><td>' . $don->getLibStatut(4) . '</td></tr>';
// Project
if (!empty($conf->projet->enabled)) {
$langs->load('projects');
print '<tr><td>' . $langs->trans('Project') . '</td><td>';
select_projects(-1, isset($_POST["projectid"]) ? $_POST["projectid"] : $don->fk_project, 'projectid');
print '</td></tr>';
}
print "</table>\n";
print '<br><center><input type="submit" class="button" name="save" value="' . $langs->trans("Save") . '"> <input type="submit" class="button" name="cancel" value="' . $langs->trans("Cancel") . '"></center>';
print "</form>\n";
print "</div>\n";
}
/* ************************************************************ */
/* */
/* Fiche don en mode visu */
