| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/(Del)pathways.org.hk/MIS20140127/old20140314/Receipt/ |
Upload File : |
<!DOCTYPE html>
<html>
<head>
<?php require_once '../include/head.php'; ?>
<?php require_once '../include/checkuser.php'; ?>
<?php require_once '../include/Nav_bar.php'; ?>
<?php require_once '../include/Classes/PHPExcel.php' ?>
<?php require_once '../include/Classes/PHPExcel/IOFactory.php' ?>
<?php require_once '../include/Classes/PHPExcel/Writer/Excel2007.php' ?>
<script>
$(function() {
$('.date-picker').datetimepicker({pickTime: false});
});
</script>
</head>
<body>
<?php
if (isset($_POST['go'])) {
$A1 = $_POST['A1'];
$A2 = $_POST['A2'];
$name = $_POST['name'];
$PHPExcel = new PHPExcel();
$PHPExcel->getProperties()->setCreator("ChiuChunOn");
$PHPExcel->getProperties()->setTitle("Receipt_Test");
$PHPExcel->getProperties()->setDescription("Test document");
$PHPExcel->setActiveSheetIndex(0);
$PHPExcel->getActiveSheet()->setCellValue('A1', $A1);
$PHPExcel->getActiveSheet()->setCellValue('B1', $A2);
$PHPExcel->getActiveSheet()->setCellValue('C1', 'ngkldfnbdljfkbnldxbnxf;lndblxk.bxfbdmlxbndflxbdx');
$PHPExcel->getActiveSheet()->setCellValue('C2', 'haha...sdvnlkdlsvahfvionjdslnvdlnkbmlflbgobomflkblngflnbfgnbgfnlbodnfogndjgofdgojfdogdfg');
$PHPExcel->getActiveSheet()->setCellValue('D1', 'haha');
PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
foreach (range('A', 'D') as $columnID) {
$PHPExcel->getActiveSheet()->getColumnDimension($columnID)
->setAutoSize(true);
}
$PHPExcelWriter = PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel5');
$PHPExcelWriter->save('' . $name . '.xls');
@header("Content-type: application/force-download");
@header("Content-Disposition: attachment; filename=\"'$name'.xls\"");
@header("Content-Length: " . filesize($name . '.xls'));
}
?>
<!-- line between nav bar and content -->
<div class="text-right">
<ul class="breadcrumb">
<li class="active">Receipt</li>
</ul>
</div>
<!-- line between nav bar and content -->
<div class="container-fluid pathways-container">
<div>
<table border="0" width="100%">
<tr>
<td><h3>Receipt</h3></td>
</tr>
</table>
</div>
<div class="pathways-search">
<form id="search_form" class="form-inline" action="" method="POST">
<div class="pathways-inline-block">
<label class="" id="A1" name="lableofname">Name</label>
<input type="text" name="name">
</div>
<br>
<div class="pathways-inline-block">
<label class="" id="A1" name="lableofA1">Money</label>
<input type="text" name="A1">
</div>
<br>
<div class="pathways-inline-block">
<label class="" id="A2" name="lableofA2">A2</label>
<input type="text" name="A2">
</div>
<div class="pathways-inline-block">
<button class="btn" name="go" value="go" style="margin-left:30px" type="submit">GO</button>
</div>
</form>
</div> <!-- /container -->
</body>
</html>