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>";