$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;"); });