include_once "msgs.lib";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div class="linkCes"> <a href="Cens.php">Администрирование сайта</a></div><br>
<div class="inputMessage">
<form method="post" action="index.php">
<h2>Введите свое имя</h2>
<input class="textarea" type = "text" name = "userName">
<h3>Оставьте свой коментарий</h3>
<textarea class="textarea" name="userMessage" rows="7" cols="75" placeholder="Введите сообщение"></textarea>
<br><br>
<input type="submit" name="submit" value="Отправить"><br><br>
</form>
</div>
<div class="chat">
<?php
$messages = getContent();
$messages = addContent($messages);
$messages = censContent($messages);
showContent($messages);
?>
</div>
</body>
</html>
$rr[0]="e".$i;
$rr[1]="f".$i;
addContent($rr,$excel,$row4['unit'],"true",$ExWs);
setCellArea($rr,$excel,$ExWs,$excel);
styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel);
$rr[0]="g".$i;
$rr[1]="h".$i;
addContent($rr,$excel,$row3['type'],"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,$row2['staffer'],"true",$ExWs);
setCellArea($rr,$excel,$ExWs,$excel);
styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel);
}
}
//close the Page
save($ExWb,$excel,$workbookname);
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>";
addContent($rr, $excel, trim($row2['staffer']), "true", $ExWs);
setCellArea($rr, $excel, $ExWs, $excel);
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>";
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
}
?>
<div>
<ul>
<li><a class='active' href="index.php">Гостевая книга</a></li>
<li><a href="admin.php">Админ панель</a></li>
</ul>
</div>
</nav>
<article id="article">
<form action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="POST">
<h1>Гостевая книга</h1>
<input id="login" type="text" name="userName" placeholder="Введите свое Имя">
<textarea id="pass" name="userMessage" cols="40" rows="3" placeholder="Оставьте свой коментарий"></textarea>
<input id="submit-button" type="submit" name="submit" value="Отправка">
</form>
<?php
$messages = getContent(DB);
if (is_array($messagesNew = addContent(DB, $messages))) {
showContent($messagesNew);
} else {
showContent($messages, $messagesNew);
}
?>
</div>
</article>
</body>
</html>
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
}
?>
$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>";
setCellArea($rr,$excel,$ExWs,$excel);
styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel);
$rr[0]="e".$i;
$rr[1]="f".$i;
addContent($rr,$excel,date("Y-m-d h:ia",strtotime($row['document_date'])),"true",$ExWs);
setCellArea($rr,$excel,$ExWs,$excel);
styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel);
$rr[0]="g".$i;
$rr[1]="h".$i;
addContent($rr,$excel,getOriginatingOffice($db,$row['originating_office']),"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,$row['status'],"true",$ExWs);
setCellArea($rr,$excel,$ExWs,$excel);
styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel);
}
}
//close the Page
save($ExWb,$excel,"");
}
?>
