| Server IP : 10.200.247.200 / Your IP : 216.73.217.19 Web Server : Apache System : Linux synergy-usa-sites 6.8.0-138-generic #138-Ubuntu SMP PREEMPT_DYNAMIC Fri Jul 31 22:41:49 UTC 2026 x86_64 User : jeremy ( 1001) PHP Version : 8.4.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/hans_sites/ylreports.com_new/reports/ |
Upload File : |
<?php
session_start();
include_once($_SERVER['DOCUMENT_ROOT'].'/php/ua.php');
include_once($_SERVER['DOCUMENT_ROOT'].'/php/mysql.php');
if(empty($_SESSION['db_name'])) {
header("Location: /");
exit(0);
}
$storeDbName = $_SESSION['db_name'];
$store = $_SESSION['store_id'];
$report = '';
if(!empty($_GET['report'])) {
$report = $_GET['report'];
}
$startDate = date('Y-m-d');
$endDate = date('Y-m-d');
if(!empty($_REQUEST['date'])) {
$postDate = $_REQUEST['date'];
switch($postDate) {
case 'today':
$startDate = date('Y-m-d');
$endDate = date('Y-m-d');
break;
case 'yesterday':
default:
$startDate = date('Y-m-d', strtotime('-1 day'));
$endDate = date('Y-m-d', strtotime('-1 day'));
break;
case 'this_week':
if(date('w') == 0)
{
$startDate = date('Y-m-d');
$endDate = date('Y-m-d', strtotime('+6 day'));
}
else
{
$startDate = date('Y-m-d', strtotime('last sunday'));
$endDate = date('Y-m-d', strtotime('+6 day', strtotime('last sunday')));
}
break;
case 'last_week':
if(date('w') == 0)
{
$startDate = date('Y-m-d', strtotime('-7 day'));
$endDate = date('Y-m-d', strtotime('-1 day'));
}
else
{
$startDate = date('Y-m-d', strtotime('-7 day', strtotime('last sunday')));
$endDate = date('Y-m-d', strtotime('-1 day', strtotime('last sunday')));
}
break;
case 'two_weeks':
if(date('w') == 0)
{
$startDate = date('Y-m-d', strtotime('-14 day'));
$endDate = date('Y-m-d', strtotime('-8 day'));
}
else
{
$startDate = date('Y-m-d', strtotime('-14 day', strtotime('last sunday')));
$endDate = date('Y-m-d', strtotime('-8 day', strtotime('last sunday')));
}
break;
case 'three_weeks':
if(date('w') == 0)
{
$startDate = date('Y-m-d', strtotime('-21 day'));
$endDate = date('Y-m-d', strtotime('-15 day'));
}
else
{
$startDate = date('Y-m-d', strtotime('-21 day', strtotime('last sunday')));
$endDate = date('Y-m-d', strtotime('-15 day', strtotime('last sunday')));
}
break;
case 'four_weeks':
if(date('w') == 0)
{
$startDate = date('Y-m-d', strtotime('-28 day'));
$endDate = date('Y-m-d', strtotime('-22 day'));
}
else
{
$startDate = date('Y-m-d', strtotime('-28 day', strtotime('last sunday')));
$endDate = date('Y-m-d', strtotime('-22 day', strtotime('last sunday')));
}
break;
case 'this_month':
$startDate = date('Y-m-d', strtotime(date('Y-m-').'01'));
$endDate = date('Y-m-d', strtotime('-1 day', strtotime('+1 month', strtotime(date('Y-m-').'01'))));
break;
case 'last_month':
$startDate = date('Y-m-d', strtotime('-1 month', strtotime(date('Y-m-').'01')));
$endDate = date('Y-m-d', strtotime('-1 day', strtotime(date('Y-m-').'01')));
break;
case 'last_six_months':
$startDate = date('Y-m-d', strtotime('-6 month', strtotime(date('Y-m-').'01')));
$endDate = date('Y-m-d', strtotime('-1 day', strtotime('+1 month', strtotime(date('Y-m-').'01'))));
break;
case 'this_year':
$startDate = date('Y-m-d', strtotime(date('Y').'-01-01'));
$endDate = date('Y-m-d');
break;
case 'last_year':
$startDate = date('Y-m-d', strtotime(date('Y', strtotime('-1 year')).'-01-01'));
$endDate = date('Y-m-d', strtotime(date('Y', strtotime('-1 year')).'-12-31'));
break;
case 'all':
$startDate = '0001-01-01';
$endDate = date('Y-m-d');
break;
}
}
function prettify($str) {
return ucwords(str_replace('_',' ',strtolower($str)));
}
function uglify($str) {
return strtolower(str_replace(' ','_',$str));
}
ob_start();
?>
<div class="rb">
<div class="relative block p20 center">
<div id="date_slider" class="relative iblock left">
Select a Date:
<br>
<select name="datepicker" id="date_picker" class="f18" onchange="update_date(this);">
<option value="today" <?= ($_GET['date']=='today') ? 'selected' : '';?>>Today</option>
<option value="yesterday" <?= (empty($_GET['date']) || $_GET['date']=='yesterday') ? 'selected' : '';?>>Yesterday</option>
<option value="this_week" <?= ($_GET['date']=='this_week') ? 'selected' : '';?>>This Week</option>
<option value="last_week" <?= ($_GET['date']=='last_week') ? 'selected' : '';?>>Last Week</option>
<option value="two_weeks" <?= ($_GET['date']=='two_weeks') ? 'selected' : '';?>>Two Weeks Ago</option>
<option value="three_weeks" <?= ($_GET['date']=='three_weeks') ? 'selected' : '';?>>Three Weeks Ago</option>
<option value="four_weeks" <?= ($_GET['date']=='four_weeks') ? 'selected' : '';?>>Four Weeks Ago</option>
<option value="this_month" <?= ($_GET['date']=='this_month') ? 'selected' : '';?>>This Month</option>
<option value="last_month" <?= ($_GET['date']=='last_month') ? 'selected' : '';?>>Last Month</option>
<option value="last_six_months" <?= ($_GET['date']=='last_six_months') ? 'selected' : '';?>>Last Six Months</option>
<option value="this_year" <?= ($_GET['date']=='this_year') ? 'selected' : '';?>>This Year</option>
<option value="last_year" <?= ($_GET['date']=='last_year') ? 'selected' : '';?>>Last Year</option>
</select>
</div>
</div>
<script type="application/javascript">
function update_date(me) {
<?php if(!empty($_GET['report'])) { ?>
window.location = "/reports/?report=<?= $_GET['report'];?>&date=" + encodeURIComponent($(me).val());
<?php } else { ?>
window.location = "/reports/?date=" + encodeURIComponent($(me).val());
<?php } ?>
}
function update_report(me) {
<?php if(!empty($_GET['date'])) { ?>
window.location = "/reports/?date=<?= $_GET['date'];?>&report=" + encodeURIComponent(me);
<?php } else { ?>
window.location = "/reports/?date=today&report=" + encodeURIComponent(me);
<?php } ?>
}
</script>
<div class="row">
<div class="col-lg-1 hidden-md hidden-sm hidden-xs"></div>
<div class="col-lg-10 col-md-12 col-sm-12 col-xs-12 center-center">
<div class="relative iblock center-center noselect">
<div class="<?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'150px')?>;">
<div class="relative block pointer <?= ($report=='hopper') ? 'navItemSelect green-bg' : 'navItem';?>" onclick="update_report('hopper');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-snowflake glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Hopper Temps
</div>
</div>
</div>
</div>
</div>
<div class="layer-top <?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'170px')?>;">
<div class="relative block pointer <?= (in_array($report,array('machineAll','changeBlades','tuneUpKit'))) ? 'navItemSelect green-bg' : 'navItem';?>" onclick="$('.minx').hide(); $(this).parent().find('.minx').show(); $('.stopper').show();" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-heartbeat glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:11px;left:4px;' : 'top:6px;';?>">
Machine Service
</div>
</div>
</div>
<div class="<?=(($phone)?'relative':'absolute')?> block pointer minx <?= ($report=='machineAll') ? 'navItemSelect dark-green-bg' : 'navItem';?>" onclick="update_report('machineAll');" style="height:40px; padding-top:4px; top:<?=(($phone)?'0px':'40px')?>; left:0px; display:none;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-life-preserver glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
All Services
</div>
</div>
</div>
<div class="<?=(($phone)?'relative':'absolute')?> block pointer minx <?= ($report=='changeBlades') ? 'navItemSelect dark-green-bg' : 'navItem';?>" onclick="update_report('changeBlades');" style="height:40px; padding-top:4px; top:<?=(($phone)?'0px':'80px')?>; left:0px; display:none;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-sampler glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:11px;left:4px;' : 'top:6px;';?>">
Changed Blades
</div>
</div>
</div>
<div class="<?=(($phone)?'relative':'absolute')?> block pointer minx <?= ($report=='tuneUpKit') ? 'navItemSelect dark-green-bg' : 'navItem';?>" onclick="update_report('tuneUpKit');" style="height:40px; padding-top:4px; top:<?=(($phone)?'0px':'120px')?>; left:0px; display:none;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-settings glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Tune Up Kits
</div>
</div>
</div>
</div>
</div>
<div class="<?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'190px')?>;">
<div class="relative block navItem pointer <?= ($report=='otherTemps') ? 'navItemSelect blue-bg' : 'navItem';?>" onclick="update_report('otherTemps');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-temperature glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:9px;left:4px;' : 'top:6px;';?>">
Store Temperatures
</div>
</div>
</div>
</div>
</div>
<div class="<?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'160px')?>;">
<div class="relative block pointer <?= ($report=='sanitizerCheck') ? 'navItemSelect red-bg' : 'navItem';?>" onclick="update_report('sanitizerCheck');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-lab glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Sanitizer Check
</div>
</div>
</div>
</div>
</div>
<div class="<?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'140px')?>;">
<div class="relative block pointer <?= ($report=='cleaningLog') ? 'navItemSelect purple-bg' : 'navItem';?>" onclick="update_report('cleaningLog');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-cleaning glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Cleaning Log
</div>
</div>
</div>
</div>
</div>
<div class="<?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'180px')?>;">
<div class="relative block pointer <?= ($report=='fullCircleService') ? 'navItemSelect purple-bg' : 'navItem';?>" onclick="update_report('fullCircleService');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-clock glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:10px;left:4px;' : 'top:6px;';?>">
Full Circle Service
</div>
</div>
</div>
</div>
</div>
<div class="<?=(($phone)?'col-xs-4':'relative fleft')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'125px')?>;">
<div class="relative block pointer <?= ($report=='wasteLog') ? 'navItemSelect purple-bg' : 'navItem';?>" onclick="update_report('wasteLog');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-bin glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Waste Log
</div>
</div>
</div>
</div>
</div>
<?
if(!empty($_SESSION['franchisee']))
{
?>
<div class="<?=(($phone)?'col-xs-4':'relative fleft ')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'120px')?>;">
<div class="relative block navItem pointer <?= ($report=='dropLog') ? 'navItemSelect orange-bg' : 'navItem';?>" onclick="update_report('dropLog');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-arrow-down glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Drop Log
</div>
</div>
</div>
</div>
</div>
<div class="<?=(($phone)?'col-xs-4':'relative fleft ')?>">
<div class="relative block" style="height:40px; width:<?=(($phone)?'100%':'130px')?>;">
<div class="relative block navItem pointer <?= ($report=='safeAudit') ? 'navItemSelect red-bg' : 'navItem';?>" onclick="update_report('safeAudit');" style="height:40px; padding-top:4px; top:0px; left:0px;">
<div class="relative left pl4 pr14">
<span class="icon glyphicons glyphicons-piggy-bank glyphicon-fw <?= ($phone) ? 'f14' : 'f18';?>"></span>
<div class="text relative iblock" style="<?= ($phone) ? 'top:3px;font-size:12px;left:4px;' : 'top:6px;';?>">
Safe Audit
</div>
</div>
</div>
</div>
</div>
<?
}
?>
</div>
</div>
<div class="col-lg-1 hidden-md hidden-sm hidden-xs"></div>
<div class="row" style="min-height:256px;">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 left">
<?php if(!empty($_GET['report'])) {
if(file_exists($_SERVER['DOCUMENT_ROOT'].'/reports/reports/'.$_GET['report'].'.php')) {
include($_SERVER['DOCUMENT_ROOT'].'/reports/reports/'.$_GET['report'].'.php');
}
}
?>
</div>
</div>
</div>
</div>
<?php
$body = ob_get_clean();
include($_SERVER['DOCUMENT_ROOT'].'/layout/body.php');