protected function onPrint()
{
parent::onPrint();
$this->pdf->AddPage();
$command = $this->db->createCommand(SQL::SQL_GET_HARDWARE_ALL);
$dataReader = $command->query();
$this->pdf->SetFont('Arial', '', 11);
$this->pdf->Cell(0, 10, utf8_decode(Prado::localize('List of the hardware')), 0, 0, 'L');
$this->pdf->Ln(10);
$this->pdf->setDefaultFont();
$header = array(utf8_decode(Prado::localize("Name")), utf8_decode(Prado::localize("Access Point")), utf8_decode(Prado::localize("Debug")), utf8_decode(Prado::localize("Type")), utf8_decode(Prado::localize("Access plugin")), utf8_decode(Prado::localize("Open time")));
//Couleurs, �paisseur du trait et police grasse
$this->pdf->SetFillColor(124, 124, 124);
$this->pdf->SetTextColor(255);
$this->pdf->SetDrawColor(255);
$this->pdf->SetLineWidth(0.3);
$this->pdf->SetFont('', 'B');
//En-t�te
$w = array(30, 28, 25, 48, 30, 30);
for ($i = 0; $i < count($header); $i++) {
$this->pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', 1);
}
$this->pdf->Ln();
//Restauration des couleurs et de la police
$this->pdf->SetFillColor(215, 215, 215);
$this->pdf->SetTextColor(0);
$this->pdf->SetFont('');
//Donn�es
$fill = false;
$this->pdf->SetFont('Arial', '', 9);
foreach ($dataReader as $d) {
$name = utf8_decode($d['name']);
$accessPoint = utf8_decode($d['accessPoint'] == 1 ? Prado::Localize("Yes") : Prado::Localize("No"));
$debug = utf8_decode($d['isLog'] == 1 ? Prado::Localize("Yes") : Prado::Localize("No"));
$type = utf8_decode($d['type']);
$accessPlugin = utf8_decode($d['accessPlugin']);
$command = $this->db->createCommand("SELECT * FROM hr_openTime AS o LEFT JOIN hr_openTime_attribution AS oa ON oa.id_openTime=o.id WHERE oa.id_device=" . $d['id']);
$dataOpentime = $command->query();
$openTime = array();
foreach ($dataOpentime as $ot) {
$openTime[] = $ot['name'];
}
$openTime = join(", ", $openTime);
$this->pdf->Cell($w[0], 6, $name, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[1], 6, $accessPoint, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[2], 6, $debug, 'LR', 0, 'C', $fill);
$this->pdf->Cell($w[3], 6, $type, 'LR', 0, 'C', $fill);
$this->pdf->Cell($w[4], 6, $accessPlugin, 'LR', 0, 'C', $fill);
$this->pdf->Cell($w[5], 6, $openTime, 'LR', 0, 'C', $fill);
$this->pdf->Ln();
$fill = !$fill;
}
$this->pdf->Cell(array_sum($w), 0, '', 'T');
$this->pdf->render();
}
public function itemCreated($sender, $param)
{
$item = $param->Item;
if ($item->ItemType === 'EditItem') {
$item->textColumn->TextBox->TextMode = "MultiLine";
$item->textColumn->TextBox->Columns = 50;
$item->textColumn->TextBox->Rows = 5;
}
if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem') {
if (!in_array(html_entity_decode($param->Item->DataItem['source']), $this->strings)) {
$item->textColumn->setBackColor("red");
} else {
if ($param->Item->DataItem['text'] == "") {
$item->textColumn->setBackColor("green");
}
}
}
if ($item->ItemType === 'Item' || $item->ItemType === 'AlternatingItem' || $item->ItemType === 'EditItem') {
if ($param->Item->DataItem['lock']) {
$item->DeleteColumn->Button->enabled = false;
$item->GoogleTranslateColumn->Button->enabled = false;
$item->EditColumn->enabled = false;
} else {
if ($item->textColumn->getBackColor() != 'green' && $item->textColumn->getBackColor() != 'red') {
$item->textColumn->setBackColor("orange");
}
// add an aleart dialog to delete buttons
$msg = Prado::Localize('Are you sure?');
$item->DeleteColumn->Button->Attributes->onclick = "if(!confirm('{$msg}')) return false; else return true;";
}
}
}
protected function onPrint()
{
parent::onPrint();
$param = $this->Application->getParameters();
$groupId = $this->Application->getUser()->getGroupID();
$nCell = 0;
$accessRight = array();
$cellHeaderWidth = 6;
$cellHeaderHeight = 40;
$this->pdf->AddPage('L');
$this->pdf->SetFont('Arial', '', 11);
$this->pdf->Cell(0, 10, utf8_decode(Prado::localize('List of the super users groups')), 0, 0, 'L');
$this->pdf->Ln(10);
$this->pdf->setDefaultFont();
//! put a marge
$this->pdf->Cell(30);
$this->pdf->SetFillColor(124, 124, 124);
$this->pdf->SetTextColor(255);
$this->pdf->SetDrawColor(255);
$this->pdf->SetLineWidth(0.3);
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Control Panel')), 1, 0, 'D', true);
$accessRight[] = "controlPanel.ControlPanel";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Super User')), 1, 0, 'D', true);
$accessRight[] = "superuser.userList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Super User Group')), 1, 0, 'D', true);
$accessRight[] = "superuser.userGroupList";
if ($param['appMode'] == 'saas' && $groupId == 1 || $param['appMode'] != 'saas') {
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Configuration')), 1, 0, 'D', true);
$accessRight[] = "configuration.config";
} else {
$nCell--;
}
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Site')), 1, 0, 'D', true);
$accessRight[] = "site.Site";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Hardware')), 1, 0, 'D', true);
$accessRight[] = "hardware.HardwareList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Opent time')), 1, 0, 'D', true);
$accessRight[] = "openTime.openTimeList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Alarms')), 1, 0, 'D', true);
$accessRight[] = "system.Alarms";
if ($param['appMode'] == 'saas' && $groupId == 1 || $param['appMode'] != 'saas') {
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Horux Service')), 1, 0, 'D', true);
$accessRight[] = "system.Service";
} else {
$nCell--;
}
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Horux Status')), 1, 0, 'D', true);
$accessRight[] = "system.Status";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('User')), 1, 0, 'D', true);
$accessRight[] = "user.UserList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('User Group')), 1, 0, 'D', true);
$accessRight[] = "userGroup.UserGroupList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('User Wizard')), 1, 0, 'D', true);
$accessRight[] = "user.UserWizzard";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Key')), 1, 0, 'D', true);
$accessRight[] = "key.KeyList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Access Level')), 1, 0, 'D', true);
$accessRight[] = "accessLevel.accessLevelList";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Non Working Day')), 1, 0, 'D', true);
$accessRight[] = "nonWorkingDay.nonWorkingDay";
$cmd = $this->db->createCommand("SELECT * FROM hr_install WHERE type='component'");
$data = $cmd->query();
$data = $data->readAll();
$this->pdf->SetFillColor(176, 176, 176);
foreach ($data as $d) {
$nCell++;
$doc = new TXmlDocument();
$doc->loadFromFile('./protected/pages/components/' . $d['name'] . '/install.xml');
$name = $doc->getElementByTagName('name');
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize($name->getValue())), 1, 0, 'D', true);
$accessRight[] = "components." . $d['name'];
}
$this->pdf->SetFillColor(124, 124, 124);
if ($param['appMode'] == 'saas' && $groupId == 1 || $param['appMode'] != 'saas') {
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Install/Uninstall')), 1, 0, 'D', true);
$accessRight[] = "installation.extensions";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Devices Manager')), 1, 0, 'D', true);
$accessRight[] = "installation.devices";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Component Manager')), 1, 0, 'D', true);
$accessRight[] = "installation.components";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Template Manager')), 1, 0, 'D', true);
$accessRight[] = "installation.template";
} else {
$nCell -= 4;
}
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Language Manager')), 1, 0, 'D', true);
$accessRight[] = "installation.language";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Global Checkin')), 1, 0, 'D', true);
$accessRight[] = "tool.GlobalCheckin";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('Horux Gui log')), 1, 0, 'D', true);
$accessRight[] = "tool.GuiLog";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('System Info')), 1, 0, 'D', true);
$accessRight[] = "help.SystemInfo";
$this->pdf->VCell($cellHeaderWidth, $cellHeaderHeight, utf8_decode(Prado::localize('About')), 1, 1, 'D', true);
$accessRight[] = "help.About";
$nCell += 25;
$groups = $this->getData();
foreach ($groups as $g) {
if ($g['superAdmin'] == 1) {
$this->pdf->SetFillColor(255, 76, 76);
} else {
$this->pdf->SetFillColor(124, 124, 124);
}
$this->pdf->Cell(30, $cellHeaderWidth, utf8_decode($g['name']), 1, 0, 'L', true);
for ($i = 0; $i < $nCell; $i++) {
$cmd = $this->db->createCommand("SELECT * FROM hr_gui_permissions WHERE page LIKE '" . $accessRight[$i] . "%' AND value=" . $g['id']);
$data = $cmd->query();
$data = $data->readAll();
if ($data || $accessRight[$i] == "controlPanel.ControlPanel" || $accessRight[$i] == "help.About") {
$this->pdf->Image("./fpdf/ok.png", $this->pdf->GetX() + $i * 6 + 1.5, $this->pdf->GetY() + 1.5, 3, 3);
} else {
$this->pdf->Image("./fpdf/ko.png", $this->pdf->GetX() + $i * 6 + 1.5, $this->pdf->GetY() + 1.5, 3, 3);
}
}
$this->pdf->Ln(6);
}
$this->pdf->Ln(10);
$this->pdf->SetTextColor(0);
$this->pdf->SetDrawColor(0);
$groups = $this->getData();
foreach ($groups as $g) {
$this->pdf->Cell(80, $cellHeaderWidth, utf8_decode(Prado::Localize('Super users in "{g}" group', array("g" => $g['name']))), 'B', 1);
$cmd = $this->db->createCommand("SELECT su.name AS username, u.name, u.firstname FROM hr_superusers AS su LEFT JOIN hr_user AS u ON u.id=su.user_id WHERE su.group_id=" . $g['id']);
$data = $cmd->query();
$users = $data->readAll();
$userList = array();
foreach ($users as $user) {
$u = $user['username'];
if (strlen($user['name']) > 0 || strlen($user['firstname']) > 0) {
$u .= " (" . $user['name'] . " " . $user['firstname'] . ")";
}
$userList[] = utf8_decode($u);
}
$userList = join(', ', $userList);
$this->pdf->MultiCell(0, 6, $userList, 0, 1);
}
$this->pdf->render();
}
protected function onPrint()
{
parent::onPrint();
$this->pdf->AddPage();
$data = $this->getData();
$this->pdf->SetFont('Arial', '', 11);
$this->pdf->Cell(0, 10, utf8_decode(Prado::localize('List of the users')), 0, 0, 'L');
$this->pdf->Ln(10);
$this->pdf->setDefaultFont();
$name = $this->Request['f1'];
if ($name == "%") {
$name = "*";
} else {
$name = $name . "*";
}
$firstname = $this->Request['f2'];
if ($firstname == "%") {
$firstname = "*";
} else {
$firstname = $firstname . "*";
}
$status = $this->Request['f3'];
switch ($status) {
case "all":
$status = utf8_decode(Prado::localize('All'));
break;
case "block":
$status = utf8_decode(Prado::localize('Blocked'));
break;
case "unblock":
$status = utf8_decode(Prado::localize('Unblocked'));
break;
}
$group = $this->Request['f4'];
if ($group != 0) {
$cmd = $this->db->createCommand("SELECT * FROM hr_user_group WHERE id=" . $group);
$data = $cmd->query();
$data = $data->read();
$group = utf8_decode($data['name']);
} else {
$group = utf8_decode(Prado::localize('All'));
}
$accessPoint = $this->Request['f5'];
if ($accessPoint != 0) {
$cmd = $this->db->createCommand("SELECT * FROM hr_device WHERE id=" . $accessPoint);
$data = $cmd->query();
$data = $data->read();
$accessPoint = utf8_decode($data['name']);
} else {
$accessPoint = utf8_decode(Prado::localize('All'));
}
$this->pdf->Cell(10, 5, utf8_decode(Prado::localize('Filter')), 'B', 1, 'L');
$this->pdf->Ln(1);
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Name')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $name, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Firstname')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $firstname, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Status')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $status, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Group')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $group, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Access')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $accessPoint, 0, 1, 'L');
$this->pdf->Ln(10);
$header = array(utf8_decode(Prado::localize("Name")), utf8_decode(Prado::localize("Firstname")), utf8_decode(Prado::localize("Email")), utf8_decode(Prado::localize("Phone")), utf8_decode(Prado::localize("Group")), utf8_decode(Prado::localize("Is Blocked")));
//Couleurs, �paisseur du trait et police grasse
$this->pdf->SetFillColor(124, 124, 124);
$this->pdf->SetTextColor(255);
$this->pdf->SetDrawColor(255);
$this->pdf->SetLineWidth(0.3);
$this->pdf->SetFont('', 'B');
//En-t�te
$w = array(30, 30, 30, 30, 45, 30);
for ($i = 0; $i < count($header); $i++) {
$this->pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', 1);
}
$this->pdf->Ln();
//Restauration des couleurs et de la police
$this->pdf->SetFillColor(215, 215, 215);
$this->pdf->SetTextColor(0);
$this->pdf->SetFont('');
//Donn�es
$fill = false;
$data = $this->getData();
foreach ($data as $d) {
$name = utf8_decode($d['name']);
$firstname = utf8_decode($d['firstname']);
$email = utf8_decode($d['email2']);
$phone = utf8_decode($d['phone2']);
$isBlocked = utf8_decode($d['isBlocked'] == 1 ? Prado::Localize("Yes") : Prado::Localize("No"));
$cmd = $this->db->createCommand("SELECT * FROM hr_user_group AS ug LEFT JOIN hr_user_group_attribution AS uga ON ug.id = uga.id_group WHERE uga.id_user="******", ", $groupList);
$group = utf8_decode($groupList);
$this->pdf->Cell($w[0], 6, $name, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[1], 6, $firstname, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[2], 6, $email, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[3], 6, $phone, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[4], 6, $group, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[5], 6, $isBlocked, 'LR', 0, 'L', $fill);
$this->pdf->Ln();
$fill = !$fill;
}
$this->pdf->Cell(array_sum($w), 0, '', 'T');
$this->pdf->render();
}
protected function onPrint()
{
parent::onPrint();
$this->pdf->AddPage();
$data = $this->getData();
$this->pdf->SetFont('Arial', '', 11);
$this->pdf->Cell(0, 10, utf8_decode(Prado::localize('List of the keys')), 0, 0, 'L');
$this->pdf->Ln(10);
$this->pdf->setDefaultFont();
$identificator = $this->Request['f1'];
if ($identificator == "%") {
$identificator = "*";
} else {
$identificator = $identificator . "*";
}
$attributed = $this->Request['f2'];
switch ($attributed) {
case "all":
$attributed = utf8_decode(Prado::localize('All'));
break;
case "used":
$attributed = utf8_decode(Prado::localize('Attributed'));
break;
case "unsued":
$attributed = utf8_decode(Prado::localize('Unattributed'));
break;
}
$status = $this->Request['f3'];
switch ($status) {
case "all":
$status = utf8_decode(Prado::localize('All'));
break;
case "block":
$status = utf8_decode(Prado::localize('Blocked'));
break;
case "unblock":
$status = utf8_decode(Prado::localize('Unblocked'));
break;
}
$this->pdf->Cell(10, 5, utf8_decode(Prado::localize('Filter')), 'B', 1, 'L');
$this->pdf->Ln(1);
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Identificator')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $identificator, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Attribution')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $attributed, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Status')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $status, 0, 1, 'L');
$this->pdf->Ln(10);
$header = array(utf8_decode(Prado::localize("Identificator")), utf8_decode(Prado::localize("Key Number")), utf8_decode(Prado::localize("Blocked")), utf8_decode(Prado::localize("Attribution")));
//Couleurs, �paisseur du trait et police grasse
$this->pdf->SetFillColor(124, 124, 124);
$this->pdf->SetTextColor(255);
$this->pdf->SetDrawColor(255);
$this->pdf->SetLineWidth(0.3);
$this->pdf->SetFont('', 'B');
//En-t�te
$w = array(45, 60, 25, 50);
for ($i = 0; $i < count($header); $i++) {
$this->pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', 1);
}
$this->pdf->Ln();
//Restauration des couleurs et de la police
$this->pdf->SetFillColor(215, 215, 215);
$this->pdf->SetTextColor(0);
$this->pdf->SetFont('');
//Donn�es
$fill = false;
foreach ($data as $d) {
$identificator = utf8_decode($d['identificator']);
$number = utf8_decode($d['serialNumber']);
$isBlocked = utf8_decode($d['isBlocked'] == 1 ? Prado::Localize("Yes") : Prado::Localize("No"));
$attribution = utf8_decode($d['person']);
$this->pdf->Cell($w[0], 6, $identificator, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[1], 6, $number, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[2], 6, $isBlocked, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[3], 6, $attribution, 'LR', 0, 'L', $fill);
$this->pdf->Ln();
$fill = !$fill;
}
$this->pdf->Cell(array_sum($w), 0, '', 'T');
$this->pdf->render();
}
protected function onPrint()
{
parent::onPrint();
$this->pdf->AddPage();
$this->pdf->SetFont('Arial', '', 11);
$this->pdf->Cell(0, 10, utf8_decode(Prado::localize('List of tracking')), 0, 0, 'L');
$this->pdf->Ln(10);
$this->pdf->setDefaultFont();
$name = $this->Request['f1'];
if ($name == "all") {
$name = "*";
} else {
if ($this->db->DriverName == 'sqlite') {
$cmd = $this->db->createCommand("SELECT name || ' ' || firstname AS Text, id AS Value FROM hr_user WHERE id=" . $name);
} else {
$cmd = $this->db->createCommand("SELECT CONCAT(name,' ', firstname) AS Text, id AS Value FROM hr_user WHERE id=" . $name);
}
$data = $cmd->query();
$data = $data->read();
$name = $data['Text'];
}
$status = $this->Request['f3'];
switch ($status) {
case "all":
$status = utf8_decode(Prado::localize('All'));
break;
case "ok":
$status = utf8_decode(Prado::localize('Access ok'));
break;
case "ko":
$status = utf8_decode(Prado::localize('Access ko'));
break;
}
$accessPoint = $this->Request['f4'];
if ($accessPoint != "all") {
$cmd = $this->db->createCommand("SELECT * FROM hr_device WHERE id=" . $accessPoint);
$data = $cmd->query();
$data = $data->read();
$accessPoint = utf8_decode($data['name']);
} else {
$accessPoint = utf8_decode(Prado::localize('All'));
}
$from = $this->Request['f5'];
$until = $this->Request['f6'];
$this->pdf->Cell(10, 5, utf8_decode(Prado::localize('Filter')), 'B', 1, 'L');
$this->pdf->Ln(1);
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Name')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $name, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Status')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $status, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('From')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $from, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Until')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $until, 0, 1, 'L');
$this->pdf->Cell(30, 5, utf8_decode(Prado::localize('Access point')) . " :", 0, 0, 'L');
$this->pdf->Cell(0, 5, $accessPoint, 0, 1, 'L');
$this->pdf->Ln(10);
$header = array(utf8_decode(Prado::localize("Name")), utf8_decode(Prado::localize("Date")), utf8_decode(Prado::localize("Time")), utf8_decode(Prado::localize("Access point")), utf8_decode(Prado::localize("Key")), utf8_decode(Prado::localize("Is Access")));
//Couleurs, �paisseur du trait et police grasse
$this->pdf->SetFillColor(124, 124, 124);
$this->pdf->SetTextColor(255);
$this->pdf->SetDrawColor(255);
$this->pdf->SetLineWidth(0.3);
$this->pdf->SetFont('', 'B');
//En-t�te
$w = array(40, 30, 30, 30, 30, 25);
for ($i = 0; $i < count($header); $i++) {
$this->pdf->Cell($w[$i], 7, $header[$i], 1, 0, 'C', 1);
}
$this->pdf->Ln();
//Restauration des couleurs et de la police
$this->pdf->SetFillColor(215, 215, 215);
$this->pdf->SetTextColor(0);
$this->pdf->SetFont('');
//Donn�es
$fill = false;
$data = $this->getData();
foreach ($data as $d) {
$user = utf8_decode($d['name'] . " " . $d['firstName']);
$date = utf8_decode($this->dateFromSql($d['date']));
$time = utf8_decode($d['time']);
$device = utf8_decode($d['device']);
$identificator = utf8_decode($d['identificator']);
$is_access = utf8_decode($d['is_access'] == 1 ? Prado::Localize("Yes") : Prado::Localize("No"));
$this->pdf->Cell($w[0], 6, $user, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[1], 6, $date, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[2], 6, $time, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[3], 6, $device, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[4], 6, $identificator, 'LR', 0, 'L', $fill);
$this->pdf->Cell($w[5], 6, $is_access, 'LR', 0, 'L', $fill);
$this->pdf->Ln();
$fill = !$fill;
}
$this->pdf->Cell(array_sum($w), 0, '', 'T');
$this->pdf->render();
}
