styleCellArea(setRange($rr[0], $rr[1]), "false", "true", $ExWs, $excel);
$rr[0] = "d" . $i;
$rr[1] = "e" . $i;
addContent($rr, $excel, date("F d, Y h:ia", strtotime($row['login_time'])), "true", $ExWs);
setCellArea($rr, $excel, $ExWs, $excel);
styleCellArea(setRange($rr[0], $rr[1]), "false", "true", $ExWs, $excel);
$rr[0] = "f" . $i;
$rr[1] = "h" . $i;
addContent($rr, $excel, $row['location'], "true", $ExWs);
setCellArea($rr, $excel, $ExWs, $excel);
styleCellArea(setRange($rr[0], $rr[1]), "false", "true", $ExWs, $excel);
$rr[0] = "i" . $i;
$rr[1] = "j" . $i;
addContent($rr, $excel, $row3['reference_number'], "true", $ExWs);
setCellArea($rr, $excel, $ExWs, $excel);
styleCellArea(setRange($rr[0], $rr[1]), "false", "true", $ExWs, $excel);
}
}
//close the Page
// try{
save($ExWb, $excel, $workbookname);
// }
// catch(Error $ex){
// echo $ex->getMessage();
// }
// save($ExWb,$excel,"C:/sample.xls");
copy($workbookname, "printout/report/" . $fileName);
// copy("c:/report/a.xls","'printout/report/".$fileName);
echo "A Print Out has been generated! Press right click and Save As: <a href='printout/report/" . $fileName . "'>Here</a>";
}
}
else if ($probConcern == "Software")
{
addContent(setRange("b70","b70"),$excel,"x","true",$ExWs);
}
else if ($probConcern == "Hardware")
{
addContent(setRange("a70","a70"),$excel,"x","true",$ExWs);
}
addContent(setRange("a8","e8"),$excel,"NAME: ".$client_name,"false",$ExWs);
addContent(setRange("f8","j8"),$excel,"DATE: ".date("F d, Y",strtotime($dispatch_time)),"false",$ExWs);
addContent(setRange("a9","e9"),$excel,"DIVISION/SECTION: ".$division,"false",$ExWs);
addContent(setRange("f9","j9"),$excel,"TIME OF CALL: ".date("H:ia",strtotime($dispatch_time)),"false",$ExWs);
addContent(setRange("a10","j10"),$excel,"PROBLEMS: ".$probConcern,"false",$ExWs);
addContent(setRange("c25","e26"),$excel,$problem_details,"true",$ExWs);
save($ExWb,$excel,$newFilename);
echo "A Service Call Printout has been generated! Press right click and Save As: <a href='".$newFilename."'>Here</a>";
unset($_SESSION['service_call']);
?>
<script language='javascript'>
//self.close();
</script>
<?php
}
?>
addContent(setRange("i16","j16"),$excel,$probConcern,"true",$ExWs);
addContent(setRange("d17", "j22"),$excel,$problem_details,"true",$ExWs);
addContent(setRange("d24", "f24"),$excel,date("F d, Y",strtotime($dispatch_time)),"true",$ExWs);
addContent(setRange("i24", "j24"),$excel,date("h:ia",strtotime($dispatch_time)),"true",$ExWs);
addContent(setRange("a52", "e52"),$excel,strtoupper($dispatch_staff),"true",$ExWs);
addContent(setRange("f45", "j45"),$excel,strtoupper($head),"true",$ExWs);
addContent(setRange("f46", "j49"),$excel,$position,"true",$ExWs);
addContent(setRange("f52", "j52"),$excel,strtoupper($administrator),"true",$ExWs);
addContent(setRange("f53", "j53"),$excel,$adminposition,"true",$ExWs);
addContent(setRange("d28", "j31"),$excel,$action_details,"true",$ExWs);
addContent(setRange("d32", "j35"),$excel,$recommendation,"true",$ExWs);
addContent(setRange("d37","h37"),$excel,$status,"true",$ExWs);
addContent(setRange("d38","d38"),$excel,date("h:ia",strtotime($accomplish_time)),"true",$ExWs);
addContent(setRange("d39","d39"),$excel,date("F d, Y",strtotime($accomplish_time)),"true",$ExWs);
save($ExWb,$excel,$newFilename);
echo "A Print Out has been generated! Press right click and Save As: <a href='".$newFilename."'>Here</a>";
echo "<br>Confirm your printing <a href='print_outline3.php?print=".$_SESSION['helpdesk_printout']."'>Here</a>";
unset($_SESSION['helpdesk_printout']);
?>
<script language='javascript'>
//self.close();
</script>
<?php
}
?>
$rs = $db->query($sql);
$nm = $rs->num_rows;
for ($i = 0; $i < $nm; $i++) {
$row = $rs->fetch_assoc();
$sql2 = "select * from computer where id='" . $row['unit_id'] . "'";
$rs2 = $db->query($sql2);
$row2 = $rs2->fetch_assoc();
$sql3 = "select * from classification where id='" . $row['classification_id'] . "'";
$rs3 = $db->query($sql3);
$row3 = $rs3->fetch_assoc();
addContent(setRange("A" . $rowCount, "A" . $rowCount), $excel, $row['reference_number'], "true", $ExWs);
addContent(setRange("B" . $rowCount, "B" . $rowCount), $excel, $row['client_name'], "true", $ExWs);
addContent(setRange("C" . $rowCount, "C" . $rowCount), $excel, $row['division_id'], "true", $ExWs);
addContent(setRange("D" . $rowCount, "D" . $rowCount), $excel, $row2['unit'], "true", $ExWs);
addContent(setRange("E" . $rowCount, "E" . $rowCount), $excel, $row3['type'] . ", " . $row['problem_details'], "true", $ExWs);
addContent(setRange("F" . $rowCount, "F" . $rowCount), $excel, date("F d, Y h:ia", strtotime($row['dispatch_time'])), "true", $ExWs);
addContent(setRange("G" . $rowCount, "G" . $rowCount), $excel, $row['staffer'], "true", $ExWs);
$rowCount++;
$styleArray = array('borders' => array('outline' => array('style' => PHPExcel_Style_Border::BORDER_HAIR)));
$excel->getActiveSheet()->getStyle("A" . $rowCount, "A" . $rowCount)->applyFromArray($styleArray);
$excel->getActiveSheet()->getStyle("B" . $rowCount, "B" . $rowCount)->applyFromArray($styleArray);
$excel->getActiveSheet()->getStyle("C" . $rowCount, "C" . $rowCount)->applyFromArray($styleArray);
$excel->getActiveSheet()->getStyle("D" . $rowCount, "D" . $rowCount)->applyFromArray($styleArray);
$excel->getActiveSheet()->getStyle("E" . $rowCount, "E" . $rowCount)->applyFromArray($styleArray);
$excel->getActiveSheet()->getStyle("F" . $rowCount, "F" . $rowCount)->applyFromArray($styleArray);
$excel->getActiveSheet()->getStyle("G" . $rowCount)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR);
$excel->getActiveSheet()->getStyle("G" . $rowCount)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_HAIR);
$excel->getActiveSheet()->getStyle("G" . $rowCount)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_DOUBLE);
}
save($ExWb, $excel, $newFilename);
echo "Report has been generated! Click Here: <a href='" . $newFilename . "' style='text-decoration:none;color:red;'>" . str_replace("printout/assigned/", "", $newFilename) . "</a>";
