$result['card_id'] = $user['card_id'];
$result['authorize_data'] = $user['authorize_data'];
$result['authorize_email'] = $user['authorize_email'];
}
}
}
$data[] = $result;
}
$results = $data;
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Backoffice " . $site_title)->setLastModifiedBy("Backoffice " . $site_title)->setTitle("Listagem de utilizadores")->setSubject("Listagem de utilizadores")->setDescription("Listagem de utilizadores");
$objPHPExcel->getActiveSheet()->setTitle('Simple');
$line = 1;
$letter = 0;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($letters[$letter++] . $line, 'link')->setCellValue($letters[$letter++] . $line, 'tipo')->setCellValue($letters[$letter++] . $line, 'tipo social')->setCellValue($letters[$letter++] . $line, 'votos')->setCellValue($letters[$letter++] . $line, 'nome')->setCellValue($letters[$letter++] . $line, 'email')->setCellValue($letters[$letter++] . $line, 'telefone')->setCellValue($letters[$letter++] . $line, 'cartão continente')->setCellValue($letters[$letter++] . $line, 'autorizou dados')->setCellValue($letters[$letter++] . $line, 'autorizou envio de email')->setCellValue($letters[$letter++] . $line, 'estado')->setCellValue($letters[$letter++] . $line, 'data de criação');
if ($results != null) {
foreach ($results as $row) {
$letter = 0;
$line++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($letters[$letter++] . $line, "http://" . $_SERVER['SERVER_NAME'] . str_replace('/backoffice', '', $path) . '/#galeria/' . $row['slug'])->setCellValue($letters[$letter++] . $line, itemType($row['type']))->setCellValue($letters[$letter++] . $line, type($row['social_id']))->setCellValue($letters[$letter++] . $line, $row['votes'])->setCellValue($letters[$letter++] . $line, $row['name'])->setCellValue($letters[$letter++] . $line, $row['email'])->setCellValue($letters[$letter++] . $line, $row['phone'])->setCellValue($letters[$letter++] . $line, $row['card_id'])->setCellValue($letters[$letter++] . $line, intval($row['authorize_data']) ? "Sim" : "Não")->setCellValue($letters[$letter++] . $line, intval($row['authorize_email']) ? "Sim" : "Não")->setCellValue($letters[$letter++] . $line, intval($row['status']) ? "Ativo" : "Inativo")->setCellValue($letters[$letter++] . $line, $row['create_date']);
}
}
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . date('Y-m-d H:i') . '_continentetv.xls"');
header('Cache-Control: max-age=1');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
} catch (Exception $e) {
echo $e->getMessage();
}
<div class="dropdown"> <button class="btn btn-default dropdown-toggle" type="button" id="dropdownMenu1" data-toggle="dropdown"><?php echo itemType($type); ?> <span class="caret"></span></button> <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu1"> <li role="presentation"><a role="menuitem" tabindex="-1" href="#" onclick="javascript:changePage(1, null, null, null, null, null, null, 0);"><?php echo itemType(0); ?> </a></li> <li role="presentation"><a role="menuitem" tabindex="-1" href="#" onclick="javascript:changePage(1, null, null, null, null, null, null, 1);"><?php echo itemType(1); ?> </a></li> <li role="presentation"><a role="menuitem" tabindex="-1" href="#" onclick="javascript:changePage(1, null, null, null, null, null, null, 2);"><?php echo itemType(2); ?> </a></li> </ul> </div> </div> <div class="form-group col-md-2"> <label class="control-label">Origem: </label> <div class="dropdown"> <button class="btn btn-default dropdown-toggle" type="button" id="dropdownMenu1" data-toggle="dropdown"><?php echo type($origin); ?> <span class="caret"></span></button> <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu1"> <li role="presentation"><a role="menuitem" tabindex="-1" href="#" onclick="javascript:changePage(1, null, null, null, 0);"><?php echo type(null);
$result_html .= '<div id="notification">
<div class="successmessage">
<p class="successfailuremessage"><span class="success">Success!</span> Your class has been changed to ' . $updateClass . '.</p>
</div>
</div>';
}
if ($stolenGoods != '') {
$stolenGoods = itemType($fn->get('is_special'), $fn->get('is_common'));
$result_html .= '<div id="notification">
<div class="successmessage">
<p class="successfailuremessage"><span class="success">Success!</span> You got ' . $fn->get('itemName') . ' ' . $stolenGoods . ' Stolen Good.</p>
</div>
</div>';
}
if ($blackMarketGoods != '') {
$blackMarketGoods = itemType($fn->get('is_special'), $fn->get('is_common'));
$result_html .= '<div id="notification">
<div class="successmessage">
<p class="successfailuremessage"><span class="success">Success!</span> You got ' . $fn->get('itemName') . ' ' . $blackMarketGoods . ' Black Market Goods.</p>
</div>
</div>';
}
?>
<script language="javascript" type="text/javascript">
$(document).ready(function(){
$('div[align="center"]').attr("align", "left");
$('input[name="Checkout"]').attr("src", "img/buy_button.gif");
$('input[name="Checkout"]').attr("style", "padding:0px !important; margin:0px !important;");
});
