function displayListMember($selectedPage, $rechercheSQL, $nbCompteParPage, $action, $idUser, $sort) { $tabMember = getTabMember($selectedPage, $rechercheSQL, $nbCompteParPage, $sort); $i = 0; foreach ($tabMember as $member) { if ($i % 2 == 0) { $htmlData = $htmlData . '<tr class="odd">' . "\n"; } else { $htmlData = $htmlData . '<tr class="even">' . "\n"; } $htmlData = $htmlData . '<td><input class="checkbox" name = "tabIdMember[]" type = "checkbox" value = "' . $member['id'] . '"/></td>' . "\n"; $htmlData = $htmlData . '<td><a target "_BLANK" href = "index.php?page=view-member&idMember=' . $member['id'] . '">' . $member['id'] . '</a></td>' . "\n"; $htmlData = $htmlData . '<td>' . $member['company_name'] . '</td>' . "\n"; $htmlData = $htmlData . '<td>' . $member['type'] . '</td>' . "\n"; $htmlData = $htmlData . '<td><a href = "mailto:' . $member['email'] . '">' . $member['email'] . '</a></td>' . "\n"; $htmlData = $htmlData . '<td>' . $member['country'] . '</td>' . "\n"; $htmlData = $htmlData . '<td>' . $member['country_ip'] . '</td>' . "\n"; $status = $member['status']; if ($status == '0') { $status = "Pending"; } if ($status == '1') { $status = "Email verified"; } if ($status == '2') { $status = "Member"; } if ($status == '99') { $status = "Deleted"; } $htmlData = $htmlData . '<td>' . $status . '</td>' . "\n"; if (time() - $member['last_hit'] < 10) { $htmlData = $htmlData . '<td><img width = "30" height = "30" src = "http://www.qcsasia.com/wp-content/uploads/2014/07/point-vert.jpg" /></td>' . "\n"; } else { $htmlData = $htmlData . '<td></td>' . "\n"; } $htmlData = $htmlData . '</tr>' . "\n"; $i++; } return $htmlData; }
<?php $baseURL = "../"; require_once "checkSession.php"; require_once "../include/utils.inc.php"; require_once "../include/member.inc.php"; require_once "../include/lib/phpexcel/PHPExcel.php"; require_once "../include/lib/phpexcel/PHPExcel/Writer/Excel2007.php"; //////////////////////////////////////////////////////////////////// $tabMember = getTabMember("", $_SESSION['sqlQuery'], -1, $_REQUEST['sort']); $rand = rand(0, 10000); $filename = "list-members-" . $login . "-" . $rand . ".xls"; $filepath = "../xls/" . $filename; $objPHPExcel = new PHPExcel(); $objPHPExcel->getActiveSheet()->setTitle('QCS'); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getDefaultStyle()->getFont()->setName('Arial'); $objPHPExcel->getDefaultStyle()->getFont()->setSize(10); // STYLE TITRE //////////////////////////////////////////////////////////// $styleTitre = new PHPExcel_Style(); $styleTitre->applyFromArray(array('font' => array('name' => 'Arial', 'bold' => true, 'size' => '12', 'color' => array('rgb' => 'FFFFFF')), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'DF0101')), 'alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER))); $objPHPExcel->getActiveSheet()->setSharedStyle($styleTitre, "A1:U1"); // TAILE DES COLONNES /////////////////////////////////////////////// $objPHPExcel->getActiveSheet()->getColumnDimension("A")->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension("B")->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension("C")->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension("D")->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension("E")->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension("F")->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension("G")->setWidth(30);