admin_establishment.php

Go to the documentation of this file.

<?php
/* Copyright (C) 2015     Alexandre Spangaro <aspangaro@open-dsi.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/>.
 */
 
// Load Dolibarr environment
require '../../main.inc.php';
require_once DOL_DOCUMENT_ROOT.'/hrm/lib/hrm.lib.php';
require_once DOL_DOCUMENT_ROOT.'/hrm/class/establishment.class.php';
 
// Load translation files required by the page
$langs->loadLangs(array('admin', 'hrm'));
 
$error = 0;
 
// Permissions
$permissiontoread = $user->admin;
$permissiontoadd  = $user->admin;
 
// Security check - Protection if external user
//if ($user->socid > 0) accessforbidden();
//if ($user->socid > 0) $socid = $user->socid;
//$isdraft = (($object->status == $object::STATUS_DRAFT) ? 1 : 0);
//restrictedArea($user, $object->element, $object->id, '', '', 'fk_soc', 'rowid', 0);
if (!isModEnabled('hrm')) {
  accessforbidden();
}
if (empty($permissiontoread)) {
  accessforbidden();
}
 
$sortorder     = GETPOST('sortorder', 'aZ09comma');
$sortfield     = GETPOST('sortfield', 'aZ09comma');
if (!$sortorder) {
  $sortorder = "DESC";
}
if (!$sortfield) {
  $sortfield = "e.rowid";
}
 
if (empty($page) || $page == -1) {
  $page = 0;
}
 
$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
$offset = $limit * $page;
$pageprev = $page - 1;
$pagenext = $page + 1;
 
 
/*
 * Actions
 */
 
// None
 
 
/*
 * View
 */
 
$form = new Form($db);
$establishmenttmp = new Establishment($db);
 
$title = $langs->trans('Establishments');
 
llxHeader('', $title, '');
 
 
// Subheader
$linkback = '<a href="'.DOL_URL_ROOT.'/admin/modules.php?restore_lastsearch_values=1">'.$langs->trans("BackToModuleList").'</a>';
print load_fiche_titre($langs->trans("HRMSetup"), $linkback, 'title_setup');
 
 
// Configuration header
$head = hrmAdminPrepareHead();
print dol_get_fiche_head($head, 'establishments', $langs->trans("HRM"), -1, "hrm", 0, '');
 
$param = '';
 
$sql = "SELECT e.rowid, e.rowid as ref, e.label, e.address, e.zip, e.town, e.status";
$sql .= " FROM ".MAIN_DB_PREFIX."establishment as e";
$sql .= " WHERE e.entity IN (".getEntity('establishment').')';
 
// Count total nb of records
$nbtotalofrecords = '';
if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
  $resql = $db->query($sql);
  $nbtotalofrecords = $db->num_rows($resql);
 
  if (($page * $limit) > $nbtotalofrecords) { // if total of record found is smaller than page * limit, goto and load page 0
    $page = 0;
    $offset = 0;
  }
  $db->free($resql);
}
 
$sql .= $db->order($sortfield, $sortorder);
$sql .= $db->plimit($limit + 1, $offset);
 
$newcardbutton = '';
$newcardbutton .= dolGetButtonTitle($langs->trans('NewEstablishment'), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/hrm/establishment/card.php?action=create&backtopage='.urlencode($_SERVER['PHP_SELF']), '', $permissiontoadd);
 
print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', 0, $nbtotalofrecords, '', 0, $newcardbutton, '', $limit, 0, 0, 1);
 
 
$result = $db->query($sql);
if ($result) {
  $num = $db->num_rows($result);
  $i = 0;
 
  print '<div class="div-table-responsive">'; // You can use div-table-responsive-no-min if you don't need reserved height for your table
  print '<table class="noborder centpercent">';
  print '<tr class="liste_titre">';
  print_liste_field_titre("Ref", $_SERVER["PHP_SELF"], "e.ref", "", "", "", $sortfield, $sortorder);
  print_liste_field_titre("Label", $_SERVER["PHP_SELF"], "e.label", "", "", "", $sortfield, $sortorder);
  print_liste_field_titre("Address", $_SERVER["PHP_SELF"], "e.address", "", "", "", $sortfield, $sortorder);
  print_liste_field_titre("Zip", $_SERVER["PHP_SELF"], "e.zip", "", "", "", $sortfield, $sortorder);
  print_liste_field_titre("Town", $_SERVER["PHP_SELF"], "e.town", "", "", "", $sortfield, $sortorder);
  print_liste_field_titre("Status", $_SERVER["PHP_SELF"], "e.status", "", "", '', $sortfield, $sortorder, 'right ');
  print "</tr>\n";
 
  if ($num > 0) {
    $establishmentstatic = new Establishment($db);
 
    while ($i < min($num, $limit)) {
      $obj = $db->fetch_object($result);
 
      $establishmentstatic->id = $obj->rowid;
      $establishmentstatic->ref = $obj->ref;
      $establishmentstatic->label = $obj->label;
      $establishmentstatic->status = $obj->status;
 
      print '<tr class="oddeven">';
      print '<td>'.$establishmentstatic->getNomUrl(1).'</td>';
      print '<td>'.dol_escape_htmltag($obj->label).'</td>';
      print '<td>'.dol_escape_htmltag($obj->address).'</td>';
      print '<td>'.dol_escape_htmltag($obj->zip).'</td>';
      print '<td>'.dol_escape_htmltag($obj->town).'</td>';
      print '<td class="right">';
      print $establishmentstatic->getLibStatut(5);
      print '</td>';
      print "</tr>\n";
 
      $i++;
    }
  } else {
    print '<tr class="oddeven"><td colspan="7"><span class="opacitymedium">'.$langs->trans("None").'</span></td></tr>';
  }
 
  print '</table>';
  print '</div>';
} else {
  dol_print_error($db);
}
 
print dol_get_fiche_end();
 
// End of page
llxFooter();
$db->close();