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(); }