|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/duvallgroupweb/ |
Upload File : |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/duvall_template.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<title>Online Orders Data:The Duvall Group</title>
<!-- Global site tag (gtag.js) - Google Analytics -->
<style>
th, td {
padding: 6px;
}
</style>
<script async src="https://www.googletagmanager.com/gtag/js?id=G-G8YXEMXJZ3"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-G8YXEMXJZ3');
</script>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-Y504JB4R42"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-Y504JB4R42');
</script>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-853WWW2YQM"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-853WWW2YQM');
</script>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-185199779-1"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-185199779-1');
</script>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-184986101-1"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-184986101-1');
</script>
<link href="/favicon.ico" rel="icon" />
<!--<LINK REL=”SHORTCUT ICON” HREF=”http://favicon.ico”> -->
<!--<link rel="shortcut icon" type="image/x-icon" href="/favicon.ico">-->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<meta name="description" content="Duvall Consulting Group; Ron Duvall; consulting services; university and college administrators; effectiveness of campus bookstores and dining service operations." />
<!-- InstanceEndEditable -->
<link rel="stylesheet" type="text/css" href="duavall%20template.css" media="all" />
<!-- Start VisualSlideShow.com HEAD section -->
<link rel="stylesheet" type="text/css" href="engine/css/slideshow.css" media="screen" />
<style type="text/css">
.slideshow a#vlb{display:none}
</style>
<script type="text/javascript" src="engine/js/mootools.js"></script>
<script type="text/javascript" src="engine/js/visualslideshow.js"></script>
<!-- End VisualSlideShow.com HEAD section -->
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<!--[if IE]>
<style type="text/css" media="all">.borderitem {border-style: solid;}</style>
<![endif]-->
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<!-- Equal body columns-->
<script src="equalcolumns.js" type="text/javascript"></script>
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<!-- Google Analytics Begin -->
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-44807402-1', 'duvallgroup.com');
ga('send', 'pageview');
</script>
<!-- Google Analytics End -->
</head>
<div id="main">
<div id="Header">
</div>
<!-- <div class="clearFloat"></div> -->
<a href="Index.html"><img src="images/duvall-logo-new.jpg" id="duavall_logo" alt="The Duvall Group" /></a>
<div id="Rotating_photos"><div id="show" class="slideshow">
<div class="slideshow-images">
<a href="#"><img id="slide-0" src="data/images/duvall_0010_Bookstore.jpg" alt="Duvall_Photo_1" title="Duvall_Photo_1" /></a>
<a href="#"><img id="slide-1" src="data/images/duvall_0006_Girl-with-credit-card-at-the-bookshop-535524316_2123x1417.jpg" alt="Duvall_Photo_2" title="Duvall_Photo_2" /></a>
<a href="#"><img id="slide-2" src="data/images/duvall_0009_Classmates-working-together-on-college-assignments-1068374128_4945x2017.jpg" alt="Duvall_Photo_3" title="Duvall_Photo_3" /></a>
<a href="#"><img id="slide-3" src="data/images/duvall_0002_Teenagers-Young-Team-Together-Cheerful-Concept-508378256_4638x2151.jpg" alt="Duvall_Photo_4" title="Duvall_Photo_4" /></a>
<a href="#"><img id="slide-4" src="data/images/duvall_0001_Young-friends-using-smartphones-and-drinking-coffee-outdoor---Group-of-people-having-fun-with-technology-tre.jpg" alt="Duvall_Photo_5" title="Duvall_Photo_5" /></a>
<a href="#"><img id="slide-5" src="data/images/duvall_0000_Young-student-searching-for-books-587520048_2122x1416.jpg" alt="Duvall_Photo_6" title="Duvall_Photo_6" /></a>
</div>
</div>
</div>
<iframe src="MasterNav.html" height="75" width="1025" scrolling="no" style="border:none;overflow:hidden; margin-top:1px;"></iframe>
<div id="contentwrapper"><!-- InstanceBeginEditable name="Sidebar" -->
<div id="Leftsidebar" style="width: 0px;" >
<div class="Sidebar_Text"> <span class="Sidebar_Title"> Testimonials</span>
<p class="Sidebar_Text">"The Duvall Group Consulting is a notch above their competitors in terms of their approach, common sense and practical recommendations, and perhaps, more importantly, their customer service and follow-up. Bowdoin College was fortunate enough [for] several years to have them look at our bookstore operation when it was being re-located and we were also asked to consider the option of outsourcing. We did not outsource and have managed, despite a smaller space, to turn a net positive bottomline every year since - due in large part to the services of Duvall Group Consulting."<br />
<br />
Jerry Boothby<br />
Assoc. V.P. for Finance and Administration<br />
Bowdoin College</p>
</div>
</div>
<div id="Maintext" style="width: 1024px;" >
<div class="Body_Text" style="height:1000px;">
<h1>SmartIDentity Customer Orders Data</h1>
<?php
set_include_path( get_include_path().PATH_SEPARATOR."..");
include_once("xlsxwriter.class.php");
// chmod("OnlineOrders.xlsx",0775);
$header = array(
'Date' => 'string',
'FirstName' => 'string',
'LastName' => 'string',
'Email' => 'string',
'Address' => 'string',
'City' => 'string',
'State' => 'string',
'Zip' => 'string',
'Plan' => 'string',
'University' => 'string',
'Size' => 'string',
'Cost' => 'string',
'Color' =>'string'
);
$ordersArray=array();
$xmlOrdersFile=simplexml_load_file("onlineOrders.xml");
echo "<div style='width:950px;height:400px;overflow:scroll;background-color:lightgray;'>";
echo "<TABLE style='width:933px; font-family:Tahoma;font-size:10px;font-weight:bold;'>";
echo "<tr style='font-size:12px; text-decoration:underline;'>";
echo "<th>Date</th><th>FirstName</th><th>LastName</th><th>Email</th><th>Address</th><th>City</th><th>State</th><th>Zip</th><th>Plan</th><th>University</th><th>Size</th><th>Cost</th><th>Color</th>";
echo "</tr>";
foreach($xmlOrdersFile->children() as $orders)
{
$record=array();
echo "<tr style='background-color:white;'>";
echo "<td >".$orders->Date."</td>";
array_push($record,(string)$orders->Date);
echo "<td >".$orders->FirstName."</td>";
array_push($record,(string)$orders->FirstName);
echo "<td >".$orders->LastName."</td>";
array_push($record,(string)$orders->LastName);
echo "<td >".$orders->Email."</td>";
array_push($record,(string)$orders->Email);
echo "<td >".$orders->Address."</td>";
array_push($record,(string)$orders->Address);
echo "<td >".$orders->City."</td>";
array_push($record,(string)$orders->City);
echo "<td >".$orders->State."</td>";
array_push($record,(string)$orders->State);
echo "<td >".$orders->Zip."</td>";
array_push($record,(string)$orders->Zip);
echo "<td >".$orders->Plan."</td>";
array_push($record,(string)$orders->Plan);
echo "<td >".$orders->University."</td>";
array_push($record,(string)$orders->University);
echo "<td >".$orders->Size."</td>";
array_push($record,(string)$orders->Size);
echo "<td >".$orders->Cost."</td>";
array_push($record,(string)$orders->Cost);
echo "<td style='background-color:".$orders->Color.";'></td>";
array_push($record,(string)$orders->Color);
array_push($ordersArray,$record);
unset($record);
}
echo "</tr>";
echo "</TABLE>";
echo "</div>";
/*
$writer = new XLSXWriter();
$writer->writeSheetHeader('SmartIDentityOrders',$header);
$ordersArray= array( $record);
foreach($ordersArray as $row)
$writer->writeSheetRow('SmartIDentityOrders', $row);
$writer->writeToFile('OnlineOrders.xlsx');
*/
echo count($xmlOrdersFile->children())." items in the Orders databse";
?>
<!-- <center><a href="OnlineOrders.xlsx" style="font-size:25px;">Download the data</a></center> -->
<center><a style="font-size: 17px;
background: #bb9959;
color: #003b5c;
width: 130px;
padding: 10px;
border-radius: 5px;
font-weight: 600;
cursor: pointer;
text-decoration: none;" href="javascript:deleteOrders();">Delete the data</a></center>
</div>
</div>
<script>
function deleteOrders()
{
var toDelete= confirm("This will erase all Online Orders data from the database, is this what you want to do?");
if (toDelete)
{
location.href="deleteOrdersData.php";
}
}
</script>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
</script><!-- InstanceEndEditable --></div>
<div id="Line3">
</div>
<!--<div class="clearFloat"></div> -->
<div id="Footer">
<div class="Footer_Contact_Text">Duvall Group | 4725 Dorsey Hall Drive | Ellicott City | MD | 21042<br />
443.562.5132 | [email protected] | Fax 410.730.2502</div>
<!-- <script>new Date().getFullYear()>2010&&document.write(""+new Date().getFullYear());</script> -->
<div class="Footer_Copyright_Text">Copyright ©2021 Duvall Consulting Group, LLC. All rights reserved.</div>
<!-- <div class="Footer_Designby_Text"><a href="http://www.kkmediapartners.com" class="class_white" title="KK media partners" target="_blank">Website by KK media partners</a></div> -->
</div>
<!--<div class="clearFloat"></div> -->
</div>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</BODY>
</HTML>