<?php
include_once 'MSInclude.php';
writeHeaders("Copy Shop", "Copy Shop Exercise");
if (!isset($_POST["f_nextform"])) {
GetInfoForm();
} else {
if (!strcmp($_POST["f_nextform"], "ShowResultsForm")) {
ShowResultsForm();
}
}
writeFooters();
//page code
function GetInfoForm()
{
DisplayLabel("Customer Type");
echo "<form action = \"index.php\" method= \"POST\" >\n <select name = \"Cust_Type\">\n <option value = \"Choose\"> Choose </option>\n <option value=\"Regular\">Regular</option>\n <option value=\"Corporate\">Corporate</option>\n <option value=\"Government\">Government</option>\n </select>";
DisplayLabel("Number of Copies");
DisplayTextbox("Num_Copies", "40", " ");
DisplayButton("sub_button", "Submit");
echo "<input type=hidden name=\"f_nextform\" value=\"ShowResultsForm\">";
echo "</form>";
}
function ShowResultsForm()
{
if (isset($_POST['Cust_Type'])) {
$customer = $_POST['Cust_Type'];
} else {
$customer = NULL;
}
if (isset($_POST['Num_Copies'])) {
/*
$objPHPExcel->createSheet(1);
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Testing');
$objPHPExcel->setActiveSheetIndex(0);
*/
//print_r($salesRep_arr);
$curSheet = 1;
// ***************************** Output Sales Rep Array **********************************************
foreach ($salesRep_arr as $salesRep => $clientArr) {
//echo "Sales Rep: ".$salesRep."\n";
$objPHPExcel->createSheet($curSheet);
$objPHPExcel->setActiveSheetIndex($curSheet);
$objPHPExcel->getActiveSheet()->setTitle(str_replace("/", " and ", $salesRep));
writeHeaders();
$row = 5;
foreach ($clientArr as $client => $scanData) {
foreach ($scanData as $type => $value) {
writeSalesClientData($row, $client, $type, $value);
}
$row++;
}
writeSalesTotals($row);
$curSheet++;
}
$objPHPExcel->setActiveSheetIndex(0);
// Save Excel 2007 file
echo date('H:i:s') . " Write to Excel2003 format\n";
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('Sales_Report_' . date("M") . "_" . date("Y") . '.xls');
