679 lines
26 KiB
PHP
679 lines
26 KiB
PHP
<?php
|
|
/* Copyright (C) 2001-2006 Rodolphe Quiedeville <rodolphe@quiedeville.org>
|
|
* Copyright (C) 2004-2018 Laurent Destailleur <eldy@users.sourceforge.net>
|
|
* Copyright (C) 2005-2012 Regis Houssin <regis.houssin@capnetworks.com>
|
|
* Copyright (C) 2012-2016 Marcos García <marcosgdf@gmail.com>
|
|
* Copyright (C) 2013-2019 Juanjo Menent <jmenent@2byte.es>
|
|
* Copyright (C) 2013-2015 Raphaël Doursenaud <rdoursenaud@gpcsolutions.fr>
|
|
* Copyright (C) 2013 Jean Heimburger <jean@tiaris.info>
|
|
* Copyright (C) 2013 Cédric Salvador <csalvador@gpcsolutions.fr>
|
|
* Copyright (C) 2013 Florian Henry <florian.henry@open-concept.pro>
|
|
* Copyright (C) 2013 Adolfo segura <adolfo.segura@gmail.com>
|
|
* Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
|
|
* Copyright (C) 2016 Ferran Marcet <fmarcet@2byte.es>
|
|
* Copyright (C) 2023 Lenin Rivas <lenin.rivas777@gmail.com>
|
|
* Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
|
|
* Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
|
|
*
|
|
* 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 <https://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
/**
|
|
* \file htdocs/multicurrency/multicurrency_rate.php
|
|
* \ingroup multicurrency
|
|
* \brief Page to list multicurrency rate
|
|
*/
|
|
|
|
// Load Dolibarr environment
|
|
require '../main.inc.php';
|
|
require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
|
|
require_once DOL_DOCUMENT_ROOT.'/core/lib/multicurrency.lib.php';
|
|
|
|
|
|
// Load translation files required by the page
|
|
$langs->loadLangs(array('admin', 'multicurrency'));
|
|
|
|
// Get Parameters
|
|
$action = GETPOST('action', 'alpha');
|
|
$massaction = GETPOST('massaction', 'alpha');
|
|
$show_files = GETPOSTINT('show_files');
|
|
$confirm = GETPOST('confirm', 'alpha');
|
|
$toselect = GETPOST('toselect', 'array');
|
|
$id_rate_selected = GETPOSTINT('id_rate');
|
|
$sall = trim((GETPOST('search_all', 'alphanohtml') != '') ? GETPOST('search_all', 'alphanohtml') : GETPOST('sall', 'alphanohtml'));
|
|
$search_date_sync = dol_mktime(0, 0, 0, GETPOSTINT('search_date_syncmonth'), GETPOSTINT('search_date_syncday'), GETPOSTINT('search_date_syncyear'));
|
|
$search_date_sync_end = dol_mktime(0, 0, 0, GETPOSTINT('search_date_sync_endmonth'), GETPOSTINT('search_date_sync_endday'), GETPOSTINT('search_date_sync_endyear'));
|
|
$search_rate = GETPOST('search_rate', 'alpha');
|
|
$search_rate_indirect = GETPOST('search_rate_indirect', 'alpha');
|
|
$search_code = GETPOST('search_code', 'alpha');
|
|
$multicurrency_code = GETPOST('multicurrency_code', 'alpha');
|
|
$dateinput = dol_mktime(0, 0, 0, GETPOSTINT('dateinputmonth'), GETPOSTINT('dateinputday'), GETPOSTINT('dateinputyear'));
|
|
$rateinput = (float) price2num(GETPOST('rateinput', 'alpha'));
|
|
$rateindirectinput = (float) price2num(GETPOST('rateinidirectinput', 'alpha'));
|
|
$optioncss = GETPOST('optioncss', 'alpha');
|
|
$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
|
|
$page = GETPOSTINT("page");
|
|
if (empty($page) || $page == -1) {
|
|
$page = 0;
|
|
} // If $page is not defined, or '' or -1
|
|
$offset = $limit * $page;
|
|
$pageprev = $page - 1;
|
|
$pagenext = $page + 1;
|
|
$sortfield = GETPOST('sortfield', 'aZ09comma');
|
|
$sortorder = GETPOST('sortorder', 'aZ09comma');
|
|
if (!$sortfield) {
|
|
$sortfield = "cr.date_sync";
|
|
}
|
|
if (!$sortorder) {
|
|
$sortorder = "DESC";
|
|
}
|
|
$type = '';
|
|
$texte = '';
|
|
$newcardbutton = '';
|
|
|
|
// Initialize a technical objects
|
|
$object = new CurrencyRate($db);
|
|
$form = new Form($db);
|
|
$extrafields = new ExtraFields($db);
|
|
|
|
|
|
// Initialize a technical object to manage hooks. Note that conf->hooks_modules contains array of hooks
|
|
$hookmanager->initHooks(array('EditorRatelist', 'globallist'));
|
|
|
|
if (empty($action)) {
|
|
$action = 'list';
|
|
}
|
|
|
|
// List of fields to search into when doing a "search in all"
|
|
$fieldstosearchall = array(
|
|
'cr.date_sync' => "date_sync",
|
|
'cr.rate' => "rate",
|
|
'cr.rate_indirect' => "rate_indirect",
|
|
'm.code' => "code",
|
|
);
|
|
|
|
// Definition of fields for lists
|
|
$arrayfields = array(
|
|
'cr.date_sync' => array('label' => 'Date', 'checked' => 1),
|
|
'cr.rate' => array('label' => 'Rate', 'checked' => 1),
|
|
'cr.rate_indirect' => array('label' => 'RateIndirect', 'checked' => 0, 'enabled' => (!getDolGlobalString('MULTICURRENCY_USE_RATE_INDIRECT') ? 0 : 1)),
|
|
'm.code' => array('label' => 'Code', 'checked' => 1),
|
|
);
|
|
|
|
|
|
$object->fields = dol_sort_array($object->fields, 'position');
|
|
$arrayfields = dol_sort_array($arrayfields, 'position');
|
|
'@phan-var-force array<string,array{label:string,checked?:int<0,1>,position?:int,help?:string}> $arrayfields'; // dol_sort_array looses type for Phan
|
|
|
|
// Access control
|
|
// TODO Open this page to a given permission so a sale representative can modify change rates. Permission should be added into module multicurrency.
|
|
// One permission to read rates (history) and one to add/edit rates.
|
|
if (!$user->admin || !isModEnabled("multicurrency")) {
|
|
accessforbidden();
|
|
}
|
|
|
|
$error = 0;
|
|
|
|
|
|
/*
|
|
* Actions
|
|
*/
|
|
|
|
if ($action == "create" && $user->hasRight('multicurrency', 'currency', 'read')) {
|
|
if (empty($multicurrency_code) || $multicurrency_code == '-1') {
|
|
setEventMessages($langs->trans('ErrorFieldRequired', $langs->transnoentitiesnoconv("Currency")), null, "errors");
|
|
$error++;
|
|
}
|
|
if ($rateinput == 0) {
|
|
setEventMessages($langs->trans('NoEmptyRate'), null, "errors");
|
|
$error++;
|
|
} elseif (empty($rateinput)) {
|
|
setEventMessages($langs->trans('ErrorFieldRequired', $langs->transnoentitiesnoconv("Rate")), null, "errors");
|
|
$error++;
|
|
}
|
|
|
|
if (!$error) {
|
|
$currencyRate_static = new CurrencyRate($db);
|
|
$currency_static = new MultiCurrency($db);
|
|
$fk_currency = $currency_static->getIdFromCode($db, $multicurrency_code);
|
|
|
|
$currencyRate_static->fk_multicurrency = $fk_currency;
|
|
$currencyRate_static->entity = $conf->entity;
|
|
$currencyRate_static->date_sync = $dateinput;
|
|
$currencyRate_static->rate = $rateinput;
|
|
$currencyRate_static->rate_indirect = $rateindirectinput;
|
|
|
|
$result = $currencyRate_static->create($user, intval($fk_currency));
|
|
if ($result > 0) {
|
|
setEventMessages($langs->trans('successRateCreate', $multicurrency_code), null);
|
|
} else {
|
|
dol_syslog("currencyRate:createRate", LOG_WARNING);
|
|
setEventMessages($currencyRate_static->error, $currencyRate_static->errors, 'errors');
|
|
}
|
|
}
|
|
}
|
|
|
|
if ($action == 'update' && $user->hasRight('multicurrency', 'currency', 'read')) {
|
|
$currencyRate = new CurrencyRate($db);
|
|
$result = $currencyRate->fetch($id_rate_selected);
|
|
if ($result > 0) {
|
|
$currency_static = new MultiCurrency($db);
|
|
$fk_currency = $currency_static->getIdFromCode($db, $multicurrency_code);
|
|
$currencyRate->date_sync = $dateinput;
|
|
$currencyRate->fk_multicurrency = $fk_currency;
|
|
$currencyRate->rate = $rateinput;
|
|
$res = $currencyRate->update($user);
|
|
if ($res) {
|
|
setEventMessages($langs->trans('successUpdateRate'), null);
|
|
} else {
|
|
setEventMessages($currencyRate->error, $currencyRate->errors, "errors");
|
|
}
|
|
} else {
|
|
setEventMessages($langs->trans('Error'), null, "warnings");
|
|
}
|
|
}
|
|
|
|
if ($action == "deleteRate" && $user->hasRight('multicurrency', 'currency', 'read')) {
|
|
$current_rate = new CurrencyRate($db);
|
|
$current_rate->fetch((int) $id_rate_selected);
|
|
|
|
if ($current_rate) {
|
|
$current_currency = new MultiCurrency($db);
|
|
$current_currency->fetch($current_rate->fk_multicurrency);
|
|
if ($current_currency) {
|
|
$delayedhtmlcontent = $form->formconfirm(
|
|
$_SERVER["PHP_SELF"].'?id_rate='.$id_rate_selected,
|
|
$langs->trans('DeleteLineRate'),
|
|
$langs->trans('ConfirmDeleteLineRate', $current_rate->rate, $current_currency->name, $current_rate->date_sync),
|
|
'confirm_delete',
|
|
'',
|
|
0,
|
|
1
|
|
);
|
|
} else {
|
|
dol_syslog("Multicurrency::fetch", LOG_WARNING);
|
|
}
|
|
} else {
|
|
setEventMessage($langs->trans('NoCurrencyRateSelected'), "warnings");
|
|
}
|
|
}
|
|
|
|
if ($action == "confirm_delete" && $user->hasRight('multicurrency', 'currency', 'read')) {
|
|
$current_rate = new CurrencyRate($db);
|
|
$current_rate->fetch((int) $id_rate_selected);
|
|
if ($current_rate) {
|
|
$result = $current_rate->delete($user);
|
|
if ($result) {
|
|
setEventMessages($langs->trans('successRateDelete'), null);
|
|
} else {
|
|
setEventMessages($current_rate->error, $current_rate->errors, 'errors');
|
|
}
|
|
} else {
|
|
setEventMessages($langs->trans('NoCurrencyRateSelected'), null, "warnings");
|
|
dol_syslog($langs->trans('NoCurrencyRateSelected'), LOG_WARNING);
|
|
}
|
|
}
|
|
|
|
|
|
if (GETPOST('cancel', 'alpha')) {
|
|
$action = 'list';
|
|
$massaction = '';
|
|
}
|
|
if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
|
|
$massaction = '';
|
|
}
|
|
|
|
$parameters = array();
|
|
$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
|
|
if ($reshook < 0) {
|
|
setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
|
|
}
|
|
if (empty($reshook)) {
|
|
// Selection of new fields
|
|
include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
|
|
|
|
// Purge search criteria
|
|
if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers
|
|
$sall = "";
|
|
$search_date_sync = "";
|
|
$search_date_sync_end = "";
|
|
$search_rate = "";
|
|
$search_code = "";
|
|
$search_array_options = array();
|
|
}
|
|
|
|
// Mass actions
|
|
$objectclass = "CurrencyRate";
|
|
$uploaddir = $conf->multicurrency->multidir_output; // define only because core/actions_massactions.inc.php want it
|
|
$permissiontoread = $user->admin;
|
|
$permissiontodelete = $user->admin;
|
|
include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
|
|
}
|
|
|
|
|
|
/*
|
|
* View
|
|
*/
|
|
|
|
$form = new Form($db);
|
|
|
|
$title = $langs->trans("CurrencyRate");
|
|
$page_name = "MultiCurrencySetup";
|
|
$help_url = '';
|
|
|
|
llxHeader('', $title, $help_url, '');
|
|
// Subheader
|
|
$linkback = '<a href="'.DOL_URL_ROOT.'/admin/modules.php?restore_lastsearch_values=1">'.$langs->trans("BackToModuleList").'</a>';
|
|
print load_fiche_titre($langs->trans($page_name), $linkback);
|
|
|
|
// Configuration header
|
|
$head = multicurrencyAdminPrepareHead();
|
|
print dol_get_fiche_head($head, 'ratelist', $langs->trans("ModuleSetup"), -1, "multicurrency");
|
|
|
|
// ACTION
|
|
|
|
if (!in_array($action, array("updateRate", "deleteRate"))) {
|
|
print '<form action="'.$_SERVER["PHP_SELF"].'" method="post" name="formulaire">';
|
|
print '<input type="hidden" name="token" value="'.newToken().'">';
|
|
|
|
print '<div class="div-table-responsive-no-min">';
|
|
print '<table class="noborder centpercent"><tr>';
|
|
|
|
print ' <td>'.$langs->trans('Date').'</td>';
|
|
print ' <td>';
|
|
print $form->selectDate($dateinput, 'dateinput', 0, 0, 1, '', 1, 1);
|
|
print '</td>';
|
|
|
|
print '<td> '.$langs->trans('Currency').'</td>';
|
|
print '<td>'.$form->selectMultiCurrency((GETPOSTISSET('multicurrency_code') ? GETPOST('multicurrency_code', 'alpha') : $multicurrency_code), 'multicurrency_code', 1, " code != '".$db->escape($conf->currency)."'", true).'</td>';
|
|
|
|
print ' <td>'.$langs->trans('Rate').' / '.$langs->getCurrencySymbol($conf->currency).'</td>';
|
|
print ' <td><input type="text" min="0" step="any" class="maxwidth75" id="rateinput" name="rateinput" value="'.dol_escape_htmltag($rateinput).'"></td>';
|
|
|
|
if (getDolGlobalString('MULTICURRENCY_USE_RATE_INDIRECT')) {
|
|
print ' <td>'.$langs->trans('RateIndirect').' / '.$langs->getCurrencySymbol($conf->currency).'</td>';
|
|
print ' <td><input type="text" min="0" step="any" class="maxwidth75" id="rateindirectinput" name="rateindirectinput" value="'.dol_escape_htmltag($rateindirectinput).'"></td>';
|
|
// LRR Calculate Rate Direct
|
|
print '<script type="text/javascript">';
|
|
print 'jQuery(document).ready(function () {
|
|
//alert("TC");
|
|
jQuery("#rateindirectinput").keyup(function () {
|
|
var valindirect = jQuery(this).val();
|
|
valdirect = 1 / parseFloat(valindirect);
|
|
jQuery("#rateinput").val(valdirect);
|
|
console.log("Rate Direct:"+valdirect)
|
|
});
|
|
});';
|
|
print '</script>';
|
|
}
|
|
|
|
print '<td>';
|
|
print '<input type="hidden" name="action" value="create">';
|
|
print '<input type="submit" class="button button-add small" name="btnCreateCurrencyRate" value="'.$langs->trans('CreateRate').'">';
|
|
print '</td>';
|
|
|
|
print '</tr></table>';
|
|
print '</div>';
|
|
|
|
print '</form>';
|
|
|
|
print '<br>';
|
|
}
|
|
|
|
|
|
|
|
|
|
$sql = 'SELECT cr.rowid, cr.date_sync, cr.rate, cr.rate_indirect, cr.entity, m.code, m.name';
|
|
// Add fields from hooks
|
|
$parameters = array();
|
|
$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters); // Note that $action and $object may have been modified by hook
|
|
$sql .= $hookmanager->resPrint;
|
|
$sql .= ' FROM '.MAIN_DB_PREFIX.'multicurrency_rate as cr ';
|
|
$sql .= " INNER JOIN ".MAIN_DB_PREFIX."multicurrency AS m ON cr.fk_multicurrency = m.rowid";
|
|
if ($sall) {
|
|
$sql .= natural_search(array_keys($fieldstosearchall), $sall);
|
|
}
|
|
if ($search_date_sync && $search_date_sync_end) {
|
|
$sql .= " AND (cr.date_sync BETWEEN '".$db->idate($search_date_sync)."' AND '".$db->idate($search_date_sync_end)."')";
|
|
} elseif ($search_date_sync && !$search_date_sync_end) {
|
|
$sql .= natural_search('cr.date_sync', $db->idate($search_date_sync));
|
|
}
|
|
if ($search_rate) {
|
|
$sql .= natural_search('cr.rate', $search_rate, 1);
|
|
}
|
|
if ($search_code) {
|
|
$sql .= natural_search('m.code', $search_code);
|
|
}
|
|
$sql .= " WHERE m.code <> '".$db->escape($conf->currency)."'";
|
|
|
|
// Add where from hooks
|
|
$parameters = array();
|
|
$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters); // Note that $action and $object may have been modified by hook
|
|
$sql .= $hookmanager->resPrint;
|
|
$sql .= " GROUP BY cr.rowid, cr.date_sync, cr.rate, cr.rate_indirect, m.code, cr.entity, m.code, m.name";
|
|
|
|
// Add fields from hooks
|
|
$parameters = array();
|
|
$reshook = $hookmanager->executeHooks('printFieldSelect', $parameters); // Note that $action and $object may have been modified by hook
|
|
$sql .= $hookmanager->resPrint;
|
|
|
|
$sql .= $db->order($sortfield, $sortorder);
|
|
|
|
|
|
$nbtotalofrecords = '';
|
|
if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
|
|
$result = $db->query($sql);
|
|
|
|
if ($result) {
|
|
$nbtotalofrecords = $db->num_rows($result);
|
|
if (($page * $limit) > $nbtotalofrecords) { // if total resultset is smaller then paging size (filtering), goto and load page 0
|
|
$page = 0;
|
|
$offset = 0;
|
|
}
|
|
} else {
|
|
setEventMessage($langs->trans('No_record_on_multicurrency_rate'), 'warnings');
|
|
}
|
|
}
|
|
|
|
$sql .= $db->plimit($limit + 1, $offset);
|
|
|
|
$resql = $db->query($sql);
|
|
if ($resql) {
|
|
$num = $db->num_rows($resql);
|
|
$arrayofselected = is_array($toselect) ? $toselect : array();
|
|
|
|
$param = '';
|
|
if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
|
|
$param .= '&contextpage='.urlencode($contextpage);
|
|
}
|
|
if ($limit > 0 && $limit != $conf->liste_limit) {
|
|
$param .= '&limit='.((int) $limit);
|
|
}
|
|
if ($sall) {
|
|
$param .= "&sall=".urlencode($sall);
|
|
}
|
|
|
|
if ($search_date_sync) {
|
|
$param = "&search_date_sync=".$search_date_sync;
|
|
}
|
|
if ($search_date_sync_end) {
|
|
$param = "&search_date_sync_end=".$search_date_sync_end;
|
|
}
|
|
if ($search_rate) {
|
|
$param = "&search_rate=".urlencode($search_rate);
|
|
}
|
|
if ($search_code != '') {
|
|
$param .= "&search_code=".urlencode($search_code);
|
|
}
|
|
|
|
// Add $param from extra fields
|
|
include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
|
|
|
|
if ($user->admin) {
|
|
$arrayofmassactions['predelete'] = $langs->trans("Delete");
|
|
}
|
|
if (in_array($massaction, array('presend', 'predelete'))) {
|
|
$arrayofmassactions = array();
|
|
}
|
|
$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
|
|
|
|
print '<form action="'.$_SERVER["PHP_SELF"].'" method="POST" name="formulaire">';
|
|
if ($optioncss != '') {
|
|
print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
|
|
}
|
|
print '<input type="hidden" name="token" value="'.newToken().'">';
|
|
print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
|
|
print '<input type="hidden" name="action" value="list">';
|
|
print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
|
|
print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
|
|
print '<input type="hidden" name="page" value="'.$page.'">';
|
|
print '<input type="hidden" name="type" value="'.$type.'">';
|
|
|
|
print_barre_liste($texte, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'title_currency.png', 0, $newcardbutton, '', $limit);
|
|
|
|
include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
|
|
|
|
if ($sall) {
|
|
foreach ($fieldstosearchall as $key => $val) {
|
|
$fieldstosearchall[$key] = $langs->trans($val);
|
|
}
|
|
print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $sall).implode(', ', $fieldstosearchall).'</div>';
|
|
}
|
|
|
|
// Filter on categories
|
|
$moreforfilter = '';
|
|
|
|
|
|
$parameters = array();
|
|
$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters); // Note that $action and $object may have been modified by hook
|
|
if (empty($reshook)) {
|
|
$moreforfilter .= $hookmanager->resPrint;
|
|
} else {
|
|
$moreforfilter = $hookmanager->resPrint;
|
|
}
|
|
|
|
if ($moreforfilter) {
|
|
print '<div class="liste_titre liste_titre_bydiv centpercent">';
|
|
print $moreforfilter;
|
|
print '</div>';
|
|
}
|
|
|
|
$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
|
|
$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
|
|
if ($massactionbutton) {
|
|
$selectedfields .= $form->showCheckAddButtons('checkforselect', 1);
|
|
}
|
|
|
|
print '<div class="div-table-responsive">';
|
|
print '<table class="tagtable centpercent nomarginbottom liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
|
|
|
|
// Lines with input filters
|
|
print '<tr class="liste_titre_filter">';
|
|
|
|
// Action column
|
|
if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print '<td class="liste_titre center">';
|
|
$searchpicto = $form->showFilterButtons();
|
|
print $searchpicto;
|
|
print '</td>';
|
|
}
|
|
// date
|
|
if (!empty($arrayfields['cr.date_sync']['checked'])) {
|
|
print '<td class="liste_titre" align="left">';
|
|
print $form->selectDate(dol_print_date($search_date_sync, "%Y-%m-%d"), 'search_date_sync', 0, 0, 1);
|
|
print $form->selectDate(dol_print_date($search_date_sync_end, "%Y-%m-%d"), 'search_date_sync_end', 0, 0, 1);
|
|
print '</td>';
|
|
}
|
|
// code
|
|
if (!empty($arrayfields['m.code']['checked'])) {
|
|
print '<td class="liste_titre" align="left">';
|
|
print $form->selectMultiCurrency($multicurrency_code, 'search_code', 1, " code != '".$conf->currency."'", true);
|
|
print '</td>';
|
|
}
|
|
// rate
|
|
if (!empty($arrayfields['cr.rate']['checked'])) {
|
|
print '<td class="liste_titre" align="left">';
|
|
print '<input class="flat maxwidth75" type="text" name="search_rate" value="'.dol_escape_htmltag($search_rate).'">';
|
|
print '</td>';
|
|
}
|
|
|
|
// Fields from hook
|
|
$parameters = array('arrayfields' => $arrayfields);
|
|
$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters); // Note that $action and $object may have been modified by hook
|
|
print $hookmanager->resPrint;
|
|
|
|
// Action column
|
|
if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print '<td class="liste_titre center">';
|
|
$searchpicto = $form->showFilterButtons();
|
|
print $searchpicto;
|
|
print '</td>';
|
|
}
|
|
print '</tr>';
|
|
|
|
print '<tr class="liste_titre">';
|
|
// Action column
|
|
if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', '', $sortfield, $sortorder, 'maxwidthsearch center ');
|
|
}
|
|
if (!empty($arrayfields['cr.date_sync']['checked'])) {
|
|
print_liste_field_titre($arrayfields['cr.date_sync']['label'], $_SERVER["PHP_SELF"], "cr.date_sync", "", $param, "", $sortfield, $sortorder);
|
|
}
|
|
if (!empty($arrayfields['m.code']['checked'])) {
|
|
print_liste_field_titre($arrayfields['m.code']['label'], $_SERVER["PHP_SELF"], "m.code", "", $param, "", $sortfield, $sortorder);
|
|
}
|
|
if (!empty($arrayfields['cr.rate']['checked'])) {
|
|
print_liste_field_titre($arrayfields['cr.rate']['label'], $_SERVER["PHP_SELF"], "cr.rate", "", $param, "", $sortfield, $sortorder);
|
|
}
|
|
|
|
// Hook fields
|
|
$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder);
|
|
$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters); // Note that $action and $object may have been modified by hook
|
|
print $hookmanager->resPrint;
|
|
// Action column
|
|
if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', 'align="center"', $sortfield, $sortorder, 'maxwidthsearch center ');
|
|
}
|
|
print "</tr>\n";
|
|
|
|
$i = 0;
|
|
$totalarray = array();
|
|
$totalarray['nbfield'] = 0;
|
|
while ($i < min($num, $limit)) {
|
|
$obj = $db->fetch_object($resql);
|
|
|
|
print '<tr class="oddeven">';
|
|
|
|
// USER REQUEST UPDATE FOR THIS LINE
|
|
if ($action == "updateRate" && $obj->rowid == $id_rate_selected) {
|
|
if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print '<td class="center">';
|
|
print '</td>';
|
|
}
|
|
print '<td><input class="minwidth200" name="dateinput" value="'. date('Y-m-d', dol_stringtotime($obj->date_sync)) .'" type="date"></td>';
|
|
print '<td>' . $form->selectMultiCurrency($obj->code, 'multicurrency_code', 1, " code != '".$conf->currency."'", true) . '</td>';
|
|
print '<td><input type="text" min="0" step="any" class="maxwidth100" name="rateinput" value="' . dol_escape_htmltag($obj->rate) . '">';
|
|
print '<input type="hidden" name="page" value="'.dol_escape_htmltag((string) $page).'">';
|
|
print '<input type="hidden" name="id_rate" value="'.dol_escape_htmltag($obj->rowid).'">';
|
|
print '<button type="submit" class="button small reposition" name="action" value="update">'.$langs->trans("Modify").'</button>';
|
|
print '<button type="submit" class="button small reposition" name="action" value="cancel">'.$langs->trans("Cancel").'</button>';
|
|
print '</td>';
|
|
if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print '<td class="center">';
|
|
print '</td>';
|
|
}
|
|
} else {
|
|
// Action
|
|
if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print '<td class="nowrap center">';
|
|
if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
|
|
$selected = 0;
|
|
if (in_array($obj->rowid, $arrayofselected)) {
|
|
$selected = 1;
|
|
}
|
|
print '<a class="editfielda marginleftonly marginrightonly reposition" href="'.$_SERVER["PHP_SELF"].'?action=updateRate&token='.newToken().'&id_rate='.$obj->rowid.'">'.img_picto('edit', 'edit').'</a>';
|
|
print '<a class="marginleftonly marginrightonly reposition" href="'.$_SERVER["PHP_SELF"].'?action=deleteRate&token='.newToken().'&id_rate='.$obj->rowid.'">'.img_picto('delete', 'delete').'</a>';
|
|
print '<input id="cb'.$obj->rowid.'" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
|
|
}
|
|
print '</td>';
|
|
if (!$i) {
|
|
$totalarray['nbfield']++;
|
|
}
|
|
}
|
|
|
|
// date_sync
|
|
if (!empty($arrayfields['cr.date_sync']['checked'])) {
|
|
print '<td class="tdoverflowmax200">';
|
|
print $obj->date_sync;
|
|
print "</td>\n";
|
|
if (!$i) {
|
|
$totalarray['nbfield']++;
|
|
}
|
|
}
|
|
|
|
// code
|
|
if (!empty($arrayfields['m.code']['checked'])) {
|
|
print '<td class="tdoverflowmax200">';
|
|
print $obj->code;
|
|
print ' - <span class="opacitymedium">'.$obj->name.'</span>';
|
|
print "</td>\n";
|
|
|
|
if (! $i) {
|
|
$totalarray['nbfield']++;
|
|
}
|
|
}
|
|
|
|
// rate
|
|
if (!empty($arrayfields['cr.rate']['checked'])) {
|
|
print '<td class="tdoverflowmax200">';
|
|
print $obj->rate;
|
|
print "</td>\n";
|
|
if (! $i) {
|
|
$totalarray['nbfield']++;
|
|
}
|
|
}
|
|
|
|
// rate indirect
|
|
if (!empty($arrayfields['cr.rate_indirect']['checked'])) {
|
|
print '<td class="tdoverflowmax200">';
|
|
print $obj->rate_indirect;
|
|
print "</td>\n";
|
|
if (! $i) {
|
|
$totalarray['nbfield']++;
|
|
}
|
|
}
|
|
|
|
|
|
// Fields from hook
|
|
$parameters = array('arrayfields' => $arrayfields, 'obj' => $obj);
|
|
$reshook = $hookmanager->executeHooks('printFieldListValue', $parameters); // Note that $action and $object may have been modified by hook
|
|
print $hookmanager->resPrint;
|
|
|
|
// Action
|
|
if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
|
|
print '<td class="nowrap center">';
|
|
if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
|
|
$selected = 0;
|
|
if (in_array($obj->rowid, $arrayofselected)) {
|
|
$selected = 1;
|
|
}
|
|
print '<a class="editfielda marginleftonly marginrightonly" href="'.$_SERVER["PHP_SELF"].'?action=updateRate&token='.newToken().'&id_rate='.$obj->rowid.'">'.img_picto('edit', 'edit').'</a>';
|
|
print '<a class="marginleftonly marginrightonly" href="'.$_SERVER["PHP_SELF"].'?action=deleteRate&token='.newToken().'&id_rate='.$obj->rowid.'">'.img_picto('delete', 'delete').'</a>';
|
|
print '<input id="cb'.$obj->rowid.'" class="flat checkforselect marginleftonly" type="checkbox" name="toselect[]" value="'.$obj->rowid.'"'.($selected ? ' checked="checked"' : '').'>';
|
|
}
|
|
print '</td>';
|
|
if (!$i) {
|
|
$totalarray['nbfield']++;
|
|
}
|
|
}
|
|
|
|
print "</tr>\n";
|
|
$i++;
|
|
}
|
|
}
|
|
|
|
$db->free($resql);
|
|
|
|
print "</table>";
|
|
print "</div>";
|
|
|
|
print '</form>';
|
|
} else {
|
|
dol_print_error($db);
|
|
}
|
|
|
|
|
|
llxFooter();
|
|
$db->close();
|