EXCELIA_DBARR/custom/settlements/dailyclosing_list.php

<?php
/* Copyright (C) 2001-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
 * Copyright (C) 2004-2015 Laurent Destailleur  <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2012 Regis Houssin        <regis.houssin@inodbox.com>
 * Copyright (C) 2015      Jean-François Ferry	<jfefe@aternatik.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       settlements/settlementsindex.php
 *	\ingroup    settlements
 *	\brief      Home page of settlements top menu
 */


// Load Dolibarr environment

$res = 0;
// Try main.inc.php into web root known defined into CONTEXT_DOCUMENT_ROOT (not always defined)
if (!$res && !empty($_SERVER["CONTEXT_DOCUMENT_ROOT"])) {
    $res = @include $_SERVER["CONTEXT_DOCUMENT_ROOT"] . "/main.inc.php";
}
// Try main.inc.php into web root detected using web root calculated from SCRIPT_FILENAME
$tmp = empty($_SERVER['SCRIPT_FILENAME']) ? '' : $_SERVER['SCRIPT_FILENAME'];
$tmp2 = realpath(__FILE__);
$i = strlen($tmp) - 1;
$j = strlen($tmp2) - 1;
while ($i > 0 && $j > 0 && isset($tmp[$i]) && isset($tmp2[$j]) && $tmp[$i] == $tmp2[$j]) {
    $i--;
    $j--;
}
if (!$res && $i > 0 && file_exists(substr($tmp, 0, ($i + 1)) . "/main.inc.php")) {
    $res = @include substr($tmp, 0, ($i + 1)) . "/main.inc.php";
}
if (!$res && $i > 0 && file_exists(dirname(substr($tmp, 0, ($i + 1))) . "/main.inc.php")) {
    $res = @include dirname(substr($tmp, 0, ($i + 1))) . "/main.inc.php";
}
// Try main.inc.php using relative path
if (!$res && file_exists("../main.inc.php")) {
    $res = @include "../main.inc.php";
}
if (!$res && file_exists("../../main.inc.php")) {
    $res = @include "../../main.inc.php";
}
if (!$res && file_exists("../../../main.inc.php")) {
    $res = @include "../../../main.inc.php";
}
if (!$res) {
    die("Include of main fails");
}

require_once DOL_DOCUMENT_ROOT . '/core/class/html.formfile.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/settlements/class/helper.class.php';
require_once DOL_DOCUMENT_ROOT . '/custom/settlements/class/daily_closing.class.php';
require_once DOL_DOCUMENT_ROOT . '/user/class/user.class.php';
require_once DOL_DOCUMENT_ROOT.'/custom/rollerstorage/class/packagehistory.class.php';


// Load translation files required by the page
$langs->loadLangs(array("settlements@settlements"));

$action = GETPOST('action', 'aZ09');
$id = GETPOST('id', 'int');
$user_id = GETPOST('user_id', 'int');
$idmenu = GETPOST('idmenu', 'int');

$helper = new Helper($db);
$userObj = new User($db);
$dailyClosing = new DailyClosing();
$objectPH = new PackageHistory($db);
$form = new Form($db);
$formfile = new FormFile($db);

$limit = GETPOST('limit', 'int') ? GETPOST('limit', 'int') : $conf->liste_limit;
$sortfield = GETPOST('sortfield', 'aZ09comma');
$sortorder = GETPOST('sortorder', 'aZ09comma');
$page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');

$searchArray = [];

$sql = "SELECT ph.rowid, ph.date_creation, ph.status, u.firstname, u.lastname, ph.user_id FROM llx_rollerstorage_packagehistory as ph 
INNER JOIN llx_user as u ON u.rowid=ph.package_manager_user
WHERE ph.user_id = {$user_id} ORDER BY ph.date_creation DESC";

$allHistoryRecords = $dailyClosing->getAllHistoryRecords($sql);

$title = '';
$help_url = '';
$morejs = '';
$morecss = '';

llxHeader('', $title, $help_url, '', 0, 0, $morejs, $morecss, '', 'classforhorizontalscrolloftabs');

$head = $dailyClosing->getHeader($object, $user_id, $idmenu);
print dol_get_fiche_head($head, 'list', $langs->trans("Group"), -1);

$linkback = '<a href="' . dol_buildpath("/custom/settlements/settlementdailyclosingindex.php?idmenu=" . $idmenu . "&mainmenu=settlements&leftmenu=", 1) . '">' . '<b><span class="fa fa-arrow-left"></span> ' . $langs->trans("BackToList") . '</b></a>';
print $linkback;


$url = $_SERVER["PHP_SELF"] . '?idmenu=' . $idmenu . '&mainmenu=settlements&leftmenu=&id=' . $id;

print '<form method="POST" id="searchFormList" action="' . $url . '">' . "\n";
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="contextpage" value="' . $contextpage . '">';
print '<input type="hidden" id ="groupid" name="groupid" value="' . $id . '">';

print load_fiche_titre($langs->trans("DailyClosing"), '', 'settlements.png@settlements');

print '
<table style="width:100%;">
    <tr>
        <th>' . $langs->trans("ID") . '</th>
        <th>' . $langs->trans("DateCreation") . '</th>
        <th>' . $langs->trans("PackageManagerUser") . '</th>
        <th>' . $langs->trans("Status") . '</th>
    </tr>';
    include DOL_DOCUMENT_ROOT . '/custom/settlements/core/tpl/search_fields_for_userslist.tpl.php';
    $dailyClosing->tableDrawerForDailyClosing($allHistoryRecords, $idmenu);
print '</table>';
print '</form>' . "\n";
// End of page

llxFooter();
$db->close();
?>