* Copyright (C) 2004-2017 Laurent Destailleur * Copyright (C) 2005-2012 Regis Houssin * Copyright (C) 2013 Florian Henry * Copyright (C) 2015-2016 Alexandre Spangaro * Copyright (C) 2018-2019 Thibault FOUCART * Copyright (C) 2018-2024 Frédéric France * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see . */ /** * \file htdocs/don/card.php * \ingroup donations * \brief Page of donation card */ // Load Dolibarr environment require '../main.inc.php'; require_once DOL_DOCUMENT_ROOT.'/core/modules/dons/modules_don.php'; require_once DOL_DOCUMENT_ROOT.'/core/lib/donation.lib.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php'; require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php'; require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php'; require_once DOL_DOCUMENT_ROOT.'/don/class/don.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/extrafields.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/class/html.formmargin.class.php'; require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php'; if (isModEnabled('project')) { require_once DOL_DOCUMENT_ROOT.'/core/class/html.formprojet.class.php'; require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php'; } require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php'; $langs->loadLangs(array('bills', 'companies', 'donations', 'users')); $id = GETPOST('rowid') ? GETPOSTINT('rowid') : GETPOSTINT('id'); $ref = GETPOST('ref', 'alpha'); $action = GETPOST('action', 'aZ09'); $cancel = GETPOST('cancel', 'alpha'); $confirm = GETPOST('confirm', 'alpha'); $backtopage = GETPOST('backtopage', 'alpha'); $socid = GETPOSTINT('socid'); $amount = price2num(GETPOST('amount', 'alphanohtml'), 'MT'); $donation_date = dol_mktime(12, 0, 0, GETPOST('remonth'), GETPOST('reday'), GETPOST('reyear')); $projectid = (GETPOST('projectid') ? GETPOSTINT('projectid') : 0); $public_donation = GETPOSTINT("public"); $object = new Don($db); if ($id > 0 || $ref) { $object->fetch($id, $ref); } if (!empty($socid) && $socid > 0) { $soc = new Societe($db); if ($socid > 0) { $soc->fetch($socid); } } $extrafields = new ExtraFields($db); // fetch optionals attributes and labels $extrafields->fetch_name_optionals_label($object->table_element); $search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_'); // Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context $hookmanager->initHooks(array($object->element.'card', 'globalcard')); $upload_dir = $conf->don->dir_output; // Security check $result = restrictedArea($user, 'don', $object->id); $permissiontoread = $user->hasRight('don', 'lire'); $permissiontoadd = $user->hasRight('don', 'creer'); $permissiontodelete = $user->hasRight('don', 'supprimer'); /* * Actions */ $parameters = array(); $reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some if ($reshook < 0) { setEventMessages($hookmanager->error, $hookmanager->errors, 'errors'); } if (empty($reshook)) { $backurlforlist = DOL_URL_ROOT.'/don/list.php'; if (empty($backtopage) || ($cancel && empty($id))) { if (empty($backtopage) || ($cancel && strpos($backtopage, '__ID__'))) { if (empty($id) && (($action != 'add' && $action != 'create') || $cancel)) { $backtopage = $backurlforlist; } else { $backtopage = DOL_URL_ROOT.'/don/card.php?id='.((!empty($id) && $id > 0) ? $id : '__ID__'); } } } if ($cancel) { if (!empty($backtopageforcancel)) { header("Location: ".$backtopageforcancel); exit; } elseif (!empty($backtopage)) { header("Location: ".$backtopage); exit; } $action = ''; } // Action reopen object if ($action == 'confirm_reopen' && $confirm == 'yes' && $permissiontoadd) { $object->fetch($id); $result = $object->reopen($user); if ($result >= 0) { // Define output language if (!getDolGlobalString('MAIN_DISABLE_PDF_AUTOUPDATE')) { if (method_exists($object, 'generateDocument')) { $outputlangs = $langs; $newlang = ''; if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang) && GETPOST('lang_id', 'aZ09')) { $newlang = GETPOST('lang_id', 'aZ09'); } if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang)) { $newlang = $object->thirdparty->default_lang; } if (!empty($newlang)) { $outputlangs = new Translate("", $conf); $outputlangs->setDefaultLang($newlang); } $model = $object->model_pdf; $ret = $object->fetch($id); // Reload to get new records $object->generateDocument($model, $outputlangs, $hidedetails, $hidedesc, $hideref); } } header("Location: ".$_SERVER["PHP_SELF"].'?id='.$object->id); exit; } else { setEventMessages($object->error, $object->errors, 'errors'); $action = 'create'; } } // Action update object if ($action == 'update' && $permissiontoadd) { if (!empty($cancel)) { header("Location: ".$_SERVER['PHP_SELF']."?id=".urlencode((string) ($id))); exit; } $error = 0; if (empty($donation_date)) { setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Date")), null, 'errors'); $action = "create"; $error++; } if (empty($amount)) { setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Amount")), null, 'errors'); $action = "create"; $error++; } if (!$error) { $object->fetch($id); $object->firstname = GETPOST("firstname", 'alpha'); $object->lastname = GETPOST("lastname", 'alpha'); $object->societe = GETPOST("societe", 'alpha'); $object->address = GETPOST("address", 'alpha'); $object->amount = GETPOSTFLOAT("amount"); $object->town = GETPOST("town", 'alpha'); $object->zip = GETPOST("zipcode", 'alpha'); $object->country_id = GETPOSTINT('country_id'); $object->email = GETPOST("email", 'alpha'); $object->date = $donation_date; $object->public = $public_donation; $object->fk_project = GETPOSTINT("fk_project"); $object->modepaymentid = GETPOSTINT('modepayment'); // Fill array 'array_options' with data from add form $ret = $extrafields->setOptionalsFromPost(null, $object, '@GETPOSTISSET'); if ($ret < 0) { $error++; } if ($object->update($user) > 0) { header("Location: ".$_SERVER['PHP_SELF']."?id=".$object->id); exit; } else { setEventMessages($object->error, $object->errors, 'errors'); $action = "create"; } } } // Action add/create object if ($action == 'add' && $permissiontoadd) { if (!empty($cancel)) { header("Location: index.php"); exit; } $error = 0; if (isModEnabled("societe") && getDolGlobalString('DONATION_USE_THIRDPARTIES') && !(GETPOSTINT("socid") > 0)) { setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("ThirdParty")), null, 'errors'); $action = "create"; $error++; } if (empty($donation_date)) { setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Date")), null, 'errors'); $action = "create"; $error++; } if (empty($amount)) { setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Amount")), null, 'errors'); $action = "create"; $error++; } if (!$error) { $object->socid = GETPOSTINT("socid"); $object->firstname = (string) GETPOST("firstname", 'alpha'); $object->lastname = (string) GETPOST("lastname", 'alpha'); $object->societe = (string) GETPOST("societe", 'alpha'); $object->address = (string) GETPOST("address", 'alpha'); $object->amount = price2num(GETPOST("amount", 'alpha'), '', 2); $object->zip = (string) GETPOST("zipcode", 'alpha'); $object->town = (string) GETPOST("town", 'alpha'); $object->country_id = GETPOSTINT('country_id'); $object->email = (string) GETPOST('email', 'alpha'); $object->date = $donation_date; $object->note_private = (string) GETPOST("note_private", 'restricthtml'); $object->note_public = (string) GETPOST("note_public", 'restricthtml'); $object->public = $public_donation; $object->fk_project = GETPOSTINT("fk_project"); $object->modepaymentid = GETPOSTINT('modepayment'); // Fill array 'array_options' with data from add form $ret = $extrafields->setOptionalsFromPost(null, $object); if ($ret < 0) { $error++; } $res = $object->create($user); if ($res > 0) { header("Location: ".$_SERVER['PHP_SELF'].'?id='.$res); exit; } else { setEventMessages($object->error, $object->errors, 'errors'); $action = "create"; } } } // Action delete object if ($action == 'confirm_delete' && GETPOST("confirm") == "yes" && $permissiontodelete) { $object->fetch($id); $result = $object->delete($user); if ($result > 0) { header("Location: index.php"); exit; } else { dol_syslog($object->error, LOG_DEBUG); setEventMessages($object->error, $object->errors, 'errors'); } } // Action validation if ($action == 'valid_promesse' && $permissiontoadd) { $object->fetch($id); // @phan-suppress-next-line PhanPluginSuspiciousParamPosition if ($object->valid_promesse($id, $user->id) >= 0) { setEventMessages($langs->trans("DonationValidated", $object->ref), null); $action = ''; } else { setEventMessages($object->error, $object->errors, 'errors'); } } // Action cancel if ($action == 'set_cancel' && $permissiontoadd) { $object->fetch($id); if ($object->set_cancel($id) >= 0) { $action = ''; } else { setEventMessages($object->error, $object->errors, 'errors'); } } // Action set paid if ($action == 'set_paid' && $permissiontoadd) { $modepayment = GETPOSTINT('modepayment'); $object->fetch($id); if ($object->setPaid($id, $modepayment) >= 0) { $action = ''; } else { setEventMessages($object->error, $object->errors, 'errors'); } } elseif ($action == 'classin' && $user->hasRight('don', 'creer')) { $object->fetch($id); $object->setProject($projectid); } if ($action == 'update_extras' && $permissiontoadd) { $object->fetch($id); $object->oldcopy = dol_clone($object, 2); // Fill array 'array_options' with data from update form $ret = $extrafields->setOptionalsFromPost(null, $object, GETPOST('attribute', 'restricthtml')); if ($ret < 0) { $error++; } if (!$error) { $result = $object->insertExtraFields('DON_MODIFY'); if ($result < 0) { setEventMessages($object->error, $object->errors, 'errors'); $error++; } } if ($error) { $action = 'edit_extras'; } } // Actions to build doc include DOL_DOCUMENT_ROOT.'/core/actions_builddoc.inc.php'; } /* * View */ $bankaccountstatic = new Account($db); $title = $langs->trans("Donation"); $help_url = 'EN:Module_Donations|FR:Module_Dons|ES:Módulo_Donaciones|DE:Modul_Spenden'; llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'mod-donation page-card'); $form = new Form($db); $formfile = new FormFile($db); $formcompany = new FormCompany($db); if (isModEnabled('project')) { $formproject = new FormProjets($db); } if ($action == 'create') { print load_fiche_titre($langs->trans("AddDonation"), '', 'object_donation'); print '
'; print ''; print ''; print ''; print dol_get_fiche_head(''); print ''; print ''; // Ref print ''; // Company if (isModEnabled("societe") && getDolGlobalString('DONATION_USE_THIRDPARTIES')) { // Thirdparty if ($soc->id > 0) { print ''; print ''; } else { print ''; print ''; } print ''."\n"; } // Date print ''; // Amount print "".''; // Public donation print '\n"; if (!isModEnabled('societe') || !getDolGlobalString('DONATION_USE_THIRDPARTIES')) { print "".''; print "".''; print "".''; print "".''; // Zip / Town print ''; // Country print ''; print "".''; } // Payment mode print "\n"; // Public note print ''; print ''; print ''; // Private note if (empty($user->socid)) { print ''; print ''; print ''; } if (isModEnabled('project')) { print "\n"; } // Other attributes $parameters = array(); $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by hook print $hookmanager->resPrint; if (empty($reshook)) { print $object->showOptionals($extrafields, 'create', $parameters); } print ''; print "
'.$langs->trans('Ref').''.$langs->trans('Draft').'
'.$langs->trans('ThirdParty').''; print $soc->getNomUrl(1); print ''; // Outstanding Bill $arrayoutstandingbills = $soc->getOutstandingBills(); $outstandingBills = $arrayoutstandingbills['opened']; print ' ('.$langs->trans('CurrentOutstandingBill').': '; print price($outstandingBills, 0, $langs, 0, 0, -1, $conf->currency); if ($soc->outstanding_limit != '') { if ($outstandingBills > $soc->outstanding_limit) { print img_warning($langs->trans("OutstandingBillReached")); } print ' / '.price($soc->outstanding_limit, 0, $langs, 0, 0, -1, $conf->currency); } print ')'; print ''.$langs->trans('ThirdParty').''; $filter = '((s.client:IN:1,2,3) AND (status:=:1))'; print $form->select_company($soc->id, 'socid', $filter, 'SelectThirdParty', 0, 0, null, 0, 'minwidth300'); // Option to reload page to retrieve customer information. Note, this clear other input if (getDolGlobalString('RELOAD_PAGE_ON_CUSTOMER_CHANGE_DISABLED')) { print ''; } print ' '; print '
'.$langs->trans("Date").''; print $form->selectDate($donation_date ? $donation_date : -1, '', 0, 0, 0, "add", 1, 1); print '
'.$langs->trans("Amount").' '.$langs->trans("Currency".$conf->currency).'
'.$langs->trans("PublicDonation").""; print $form->selectyesno("public", $public_donation, 1); print "
'.$langs->trans("Company").'
'.$langs->trans("Lastname").'
'.$langs->trans("Firstname").'
'.$langs->trans("Address").''; print '
'.$langs->trans("Zip").' / '.$langs->trans("Town").''; print $formcompany->select_ziptown((GETPOSTISSET("zipcode") ? GETPOST("zipcode") : $object->zip), 'zipcode', array('town', 'selectcountry_id', 'state_id'), 6); print ' '; print $formcompany->select_ziptown((GETPOSTISSET("town") ? GETPOST("town") : $object->town), 'town', array('zipcode', 'selectcountry_id', 'state_id')); print '
'; print img_picto('', 'globe-americas', 'class="paddingrightonly"').$form->select_country(GETPOST('country_id') != '' ? GETPOST('country_id') : $object->country_id); if ($user->admin) { print info_admin($langs->trans("YouCanChangeValuesForThisListFromDictionarySetup"), 1); } print '
'.$langs->trans("EMail").''.img_picto('', 'object_email', 'class="paddingrightonly"').'
".$langs->trans("PaymentMode")."\n"; $selected = GETPOSTINT('modepayment'); print img_picto('', 'payment', 'class="pictofixedwidth"'); print $form->select_types_paiements($selected, 'modepayment', 'CRDT', 0, 1, 0, 0, 1, 'maxwidth200 widthcentpercentminusx', 1); print "
'.$langs->trans('NotePublic').''; if (!isset($note_public)) { $note_public = $object->getDefaultCreateValueFor('note_public'); } $doleditor = new DolEditor('note_public', $note_public, '', 80, 'dolibarr_notes', 'In', 0, false, !getDolGlobalString('FCKEDITOR_ENABLE_NOTE_PUBLIC') ? 0 : 1, ROWS_3, '90%'); print $doleditor->Create(1); print '
'.$langs->trans('NotePrivate').''; if (!isset($note_private)) { $note_private = $object->getDefaultCreateValueFor('note_private'); } $doleditor = new DolEditor('note_private', $note_private, '', 80, 'dolibarr_notes', 'In', 0, false, !getDolGlobalString('FCKEDITOR_ENABLE_NOTE_PRIVATE') ? 0 : 1, ROWS_3, '90%'); print $doleditor->Create(1); print '
".$langs->trans("Project").""; print img_picto('', 'project', 'class="pictofixedwidth"'); print $formproject->select_projects(-1, $projectid, 'fk_project', 0, 0, 1, 1, 0, 0, 0, '', 1, 0, 'maxwidth500'); print "
\n"; print dol_get_fiche_end(); print $form->buttonsSaveCancel(); print "
\n"; } /* ************************************************************ */ /* */ /* Donation card in edit mode */ /* */ /* ************************************************************ */ if (!empty($id) && $action == 'edit') { $result = $object->fetch($id); if ($result < 0) { dol_print_error($db, $object->error); exit; } $result = $object->fetch_optionals(); if ($result < 0) { dol_print_error($db); exit; } $hselected = 'card'; $head = donation_prepare_head($object); print '
'; print ''; print ''; print ''; print ''; print ''; print dol_get_fiche_head($head, $hselected, $langs->trans("Donation"), 0, 'donation'); print ''; // Ref print ''; print ''; // Date print ''; // Amount if ($object->status == 0) { print "".''; } else { print ''; } print '"; print "\n"; if (isModEnabled("societe") && getDolGlobalString('DONATION_USE_THIRDPARTIES')) { $company = new Societe($db); print ''; } else { $langs->load("companies"); print ''; print ''; print ''; print ''; // Zip / Town print ''; // Country print ''; print "".''; } // Payment mode print "\n"; // Status print "".''; // Project if (isModEnabled('project')) { $formproject = new FormProjets($db); $langs->load('projects'); print ''; } // Other attributes $parameters = array(); $reshook = $hookmanager->executeHooks('formObjectOptions', $parameters, $object, $action); // Note that $action and $object may have been modified by hook print $hookmanager->resPrint; if (empty($reshook)) { print $object->showOptionals($extrafields, 'edit', $parameters); } print "
'.$langs->trans("Ref").''; print $object->getNomUrl(); print '
'.$langs->trans("Date").''; print $form->selectDate($object->date, '', 0, 0, 0, "update"); print '
'.$langs->trans("Amount").' '.$langs->trans("Currency".$conf->currency).'
'.$langs->trans("Amount").''; print price($object->amount, 0, $langs, 0, 0, -1, $conf->currency); print '
'.$langs->trans("PublicDonation").""; print $form->selectyesno("public", $object->public, 1); print "
'.$langs->trans("ThirdParty").''; if ($object->socid > 0) { $result = $company->fetch($object->socid); print $company->getNomUrl(1); } print '
'.$langs->trans("Company").'
'.$langs->trans("Lastname").'
'.$langs->trans("Firstname").'
'.$langs->trans("Address").''; print '
'.$langs->trans("Zip").' / '.$langs->trans("Town").''; print $formcompany->select_ziptown((GETPOSTISSET("zipcode") ? GETPOSTISSET("zipcode") : $object->zip), 'zipcode', array('town', 'selectcountry_id', 'state_id'), 6); print ' '; print $formcompany->select_ziptown((GETPOSTISSET("town") ? GETPOST("town") : $object->town), 'town', array('zipcode', 'selectcountry_id', 'state_id')); print '
'.$langs->trans('Country').''; print $form->select_country((!empty($object->country_id) ? $object->country_id : $mysoc->country_code), 'country_id'); if ($user->admin) { print info_admin($langs->trans("YouCanChangeValuesForThisListFromDictionarySetup"), 1); } print '
'.$langs->trans("EMail").'
".$langs->trans("PaymentMode")."\n"; if ($object->mode_reglement_id) { $selected = $object->mode_reglement_id; } else { $selected = ''; } $form->select_types_paiements($selected, 'modepayment', 'CRDT', 0, 1); print "
'.$langs->trans("Status").''.$object->getLibStatut(4).'
'.$langs->trans('Project').''; $formproject->select_projects(-1, $object->fk_project, 'fk_project', 0, 0, 1, 1, 0, 0, 0, '', 0, 0, 'maxwidth500'); print '
\n"; print dol_get_fiche_end(); print $form->buttonsSaveCancel(); print "
\n"; } /* ************************************************************ */ /* */ /* Donation card in view mode */ /* */ /* ************************************************************ */ if (!empty($id) && $action != 'edit') { $formconfirm = ""; // Confirmation delete if ($action == 'delete') { $text = $langs->trans("ConfirmDeleteADonation"); print $form->formconfirm($_SERVER["PHP_SELF"]."?id=".$object->id, $langs->trans("DeleteADonation"), $text, "confirm_delete", '', '', 1); } $result = $object->fetch($id); if ($result < 0) { dol_print_error($db, $object->error); exit; } $result = $object->fetch_optionals(); if ($result < 0) { dol_print_error($db); exit; } $hselected = 'card'; $head = donation_prepare_head($object); print dol_get_fiche_head($head, $hselected, $langs->trans("Donation"), -1, 'donation'); // Print form confirm print $formconfirm; $linkback = ''.$langs->trans("BackToList").''; $morehtmlref = '
'; // Project if (isModEnabled('project')) { $langs->load("projects"); $morehtmlref .= $langs->trans('Project').' '; if ($user->hasRight('don', 'creer')) { if ($action != 'classify') { $morehtmlref .= ''.img_edit($langs->transnoentitiesnoconv('SetProject')).' : '; } if ($action == 'classify') { //$morehtmlref.=$form->form_project($_SERVER['PHP_SELF'] . '?id=' . $object->id, $object->socid, $object->fk_project, 'projectid', 0, 0, 1, 1); $morehtmlref .= '
'; $morehtmlref .= ''; $morehtmlref .= ''; $morehtmlref .= ''; $morehtmlref .= $formproject->select_projects($object->socid, $object->fk_project, 'projectid', 0, 0, 1, 0, 1, 0, 0, '', 1, 0, 'maxwidth500'); $morehtmlref .= ''; $morehtmlref .= '
'; } else { $morehtmlref .= $form->form_project($_SERVER['PHP_SELF'].'?id='.$object->id, $object->socid, $object->fk_project, 'none', 0, 0, 0, 1, '', 'maxwidth300'); } } else { if (!empty($object->fk_project)) { $proj = new Project($db); $proj->fetch($object->fk_project); $morehtmlref .= ' : '.$proj->getNomUrl(1); if ($proj->title) { $morehtmlref .= ' - '.$proj->title; } } else { $morehtmlref .= ''; } } } $morehtmlref .= '
'; dol_banner_tab($object, 'rowid', $linkback, 1, 'rowid', 'ref', $morehtmlref); print '
'; print '
'; print '
'; print ''; // Date print '"; print ''; print ''; if (isModEnabled("societe") && getDolGlobalString('DONATION_USE_THIRDPARTIES')) { $company = new Societe($db); print ''; } else { print ''; print ''; print ''; } // Payment mode print "\n"; // Other attributes $cols = 2; include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php'; print '
'.$langs->trans("Date").''; print dol_print_date($object->date, "day"); print "
'.$langs->trans("Amount").''; print price($object->amount, 0, $langs, 0, 0, -1, $conf->currency); print '
'.$langs->trans("PublicDonation").''; print yn($object->public); print '
'.$langs->trans("ThirdParty").''; if ($object->socid > 0) { $result = $company->fetch($object->socid); print $company->getNomUrl(1); } print '
'.$langs->trans("Company").''.$object->societe.'
'.$langs->trans("Lastname").''.$object->lastname.'
'.$langs->trans("Firstname").''.$object->firstname.'
".$langs->trans("PaymentMode").""; $form->form_modes_reglement(null, $object->mode_reglement_id, 'none'); print "
'; print '
'; print '
'; /* * Payments */ $sql = "SELECT p.rowid, p.num_payment, p.datep as dp, p.amount,"; $sql .= " c.code as type_code, c.libelle as paiement_type,"; $sql .= " b.fk_account"; $sql .= " FROM ".MAIN_DB_PREFIX."payment_donation as p"; $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."bank as b ON p.fk_bank = b.rowid"; $sql .= ", ".MAIN_DB_PREFIX."c_paiement as c "; $sql .= ", ".MAIN_DB_PREFIX."don as d"; $sql .= " WHERE d.rowid = ".((int) $id); $sql .= " AND p.fk_donation = d.rowid"; $sql .= " AND d.entity IN (".getEntity('donation').")"; $sql .= " AND p.fk_typepayment = c.id"; $sql .= " ORDER BY dp"; //print $sql; $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; $totalpaid = 0; print ''; print ''; print ''; print ''; print ''; if (isModEnabled("bank")) { print ''; } print ''; print ''; while ($i < $num) { $objp = $db->fetch_object($resql); print ''; print '\n"; $labeltype = ($langs->trans("PaymentType".$objp->type_code) != "PaymentType".$objp->type_code) ? $langs->trans("PaymentType".$objp->type_code) : $objp->paiement_type; print "\n"; if (isModEnabled("bank")) { $bankaccountstatic->fetch($objp->fk_account); /*$bankaccountstatic->id = $objp->fk_bank; $bankaccountstatic->ref = $objp->baref; $bankaccountstatic->label = $objp->baref; $bankaccountstatic->number = $objp->banumber; $bankaccountstatic->currency_code = $objp->bacurrency_code; if (isModEnabled('accounting')) { $bankaccountstatic->account_number = $objp->account_number; $accountingjournal = new AccountingJournal($db); $accountingjournal->fetch($objp->fk_accountancy_journal); $bankaccountstatic->accountancy_journal = $accountingjournal->getNomUrl(0, 1, 1, '', 1); } */ print ''; } print '\n"; print ""; $totalpaid += $objp->amount; $i++; } if ($object->paid == 0) { $colspan = 3; if (isModEnabled("bank")) { $colspan++; } print '\n"; print '\n"; $remaintopay = $object->amount - $totalpaid; $resteapayeraffiche = $remaintopay; print '"; print '\n"; } print "
'.$langs->trans("RefPayment").''.$langs->trans("Date").''.$langs->trans("Type").''.$langs->trans("BankAccount").''.$langs->trans("Amount").'
'; print ''.img_object($langs->trans("Payment"), "payment").' '.$objp->rowid.''.dol_print_date($db->jdate($objp->dp), 'day')."".$labeltype.' '.$objp->num_payment."'; if ($bankaccountstatic->id) { print $bankaccountstatic->getNomUrl(1, 'transactions'); } print ''.price($objp->amount)."
'.$langs->trans("AlreadyPaid").' :'.price($totalpaid)."
'.$langs->trans("AmountExpected").' :'.price($object->amount)."
'.$langs->trans("RemainderToPay")." :'.price($remaintopay)."
"; $db->free($resql); } else { dol_print_error($db); } print '
'; print '
'; print '
'; print dol_get_fiche_end(); $remaintopay = $object->amount - $totalpaid; // Actions buttons print '
'; $parameters = array(); $reshook = $hookmanager->executeHooks('addMoreActionsButtons', $parameters, $object, $action); if (empty($reshook)) { // Re-open if ($permissiontoadd && $object->status == $object::STATUS_CANCELED) { print ''.$langs->trans("ReOpen").''; } print ''; if ($object->status == $object::STATUS_DRAFT) { print ''; } if (($object->status == $object::STATUS_DRAFT || $object->status == $object::STATUS_VALIDATED) && $totalpaid == 0 && $object->paid == 0) { print '"; } // Create payment if ($object->status == $object::STATUS_VALIDATED && $object->paid == 0 && $user->hasRight('don', 'creer')) { if ($remaintopay == 0) { print '
'.$langs->trans('DoPayment').'
'; } else { print ''; } } // Classify 'paid' if ($object->status == $object::STATUS_VALIDATED && round($remaintopay) == 0 && $object->paid == 0 && $user->hasRight('don', 'creer')) { print '"; } // Delete if ($user->hasRight('don', 'supprimer')) { if ($object->status == $object::STATUS_CANCELED || $object->status == $object::STATUS_DRAFT) { print '"; } else { print '"; } } else { print '"; } } print "
"; print '
'; /* * Generated documents */ $filename = dol_sanitizeFileName((string) $object->id); $filedir = $conf->don->dir_output."/".dol_sanitizeFileName((string) $object->id); $urlsource = $_SERVER['PHP_SELF'].'?rowid='.$object->id; $genallowed = (($object->paid == 0 || $user->admin) && $user->hasRight('don', 'lire')); $delallowed = $user->hasRight('don', 'creer'); print $formfile->showdocuments('donation', $filename, $filedir, $urlsource, $genallowed, $delallowed, $object->model_pdf); // Show links to link elements $linktoelem = $form->showLinkToObjectBlock($object, null, array('don')); $somethingshown = $form->showLinkedObjectBlock($object, $linktoelem); // Show online payment link // The list can be complete by the hook 'doValidatePayment' executed inside getValidOnlinePaymentMethods() include_once DOL_DOCUMENT_ROOT.'/core/lib/payments.lib.php'; $validpaymentmethod = getValidOnlinePaymentMethods(''); $useonlinepayment = count($validpaymentmethod); if ($useonlinepayment) { //$object->statut != Facture::STATUS_DRAFT && print '
'."\n"; require_once DOL_DOCUMENT_ROOT.'/core/lib/payments.lib.php'; print showOnlinePaymentUrl('donation', $object->ref).'
'; } print '
'; print '
'; } llxFooter(); $db->close();