<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php require_once "../cmsAdmin/lib/viewer_functions.php"; ?>
<?php if (!$CURRENT_USER) { websiteLogin_redirectToLogin(); } ?>

<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

  // load viewer library
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/var/www/vhosts/claimscaddy.com/httpdocs/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
?>

<?php if ($CURRENT_USER['company_type'] == "Insurance" AND $CURRENT_USER['user_type'] == "Adjuster"): ?>
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => "insurance_adjuster = '".intval($CURRENT_USER['num'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['company_type'] == "Independent" AND $CURRENT_USER['user_type'] == "Adjuster"): ?>
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => "independent_adjuster = '".intval($CURRENT_USER['num'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['company_type'] == "Insurance" AND $CURRENT_USER['user_type'] == "Dispatcher"): ?>
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => "member_company = '".intval($CURRENT_USER['member_company_accounts'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['company_type'] == "Insurance" AND $CURRENT_USER['user_type'] == "Dispatcher/Adjuster"): ?>
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => "member_company = '".intval($CURRENT_USER['member_company_accounts'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['company_type'] == "Independent" AND $CURRENT_USER['user_type'] == "Dispatcher"): ?> 
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => " independent_company_name = '".intval($CURRENT_USER['member_company_accounts'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['company_type'] == "Independent" AND $CURRENT_USER['user_type'] == "Dispatcher/Adjuster"): ?> 
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => " independent_company_name = '".intval($CURRENT_USER['member_company_accounts'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['user_type'] == "Agent"): ?> 
<?php
// load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => "insurance_agent = '".intval($CURRENT_USER['fullname'])."'",
    'orderBy'     => 'num',
  ));
?>

<?php elseif ($CURRENT_USER['isAdmin']): ?>
<?php
  // load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'orderBy'     => 'num',
  ));
?> 

<?php else: ?>
<?php
  // load records
  list($claims_submissionRecords, $claims_submissionMetaData) = getRecords(array(
    'tableName'   => 'claims_submission',
    'where'       => 'claim_status = " "',
    'perPage'     => '0',
  ));
?>  


 
<?php endif; ?>

<?php  
  list($accountsRecords, $accountsMetaData) = getRecords(array(
    'tableName'   => 'accounts',
  ));
  
  list($member_companiesRecords, $member_companiesMetaData) = getRecords(array(
    'tableName'   => 'member_companies',
  ));

?>

<!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">
 <head>
  <title>ClaimsCaddy.com Claims Listing Page</title>
  <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
  <meta name="robots" content="noindex,nofollow" />
  <style type="text/css">
    body          { font-family: arial; }
    .instructions { border: 3px solid #000; background-color: #EEE; padding: 10px; text-align: left; margin: 25px}
  </style>
 
  
 </head>


<body bgcolor="#CCCCCC">

<?php if ($CURRENT_USER['isAdmin'] || $CURRENT_USER['user_type'] == "Dispatcher" || $CURRENT_USER['user_type'] == "Dispatcher/Adjuster"): ?>

<!-- Start Table Here -->
<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td align="center"><p><b><font face="Verdana" size="2">Your Managed Inventory Totals Over The Last Two Years</font></b></p>
		</td>
	</tr>
</table>


<?php

  $January = 0;
 $February = 0;
    $March = 0;
    $April = 0;
      $May = 0;
     $June = 0;
     $July = 0;
   $August = 0;
$September = 0;
  $October = 0;
 $November = 0;
 $December = 0;

  $January9 = 0;
 $February9 = 0;
    $March9 = 0;
    $April9 = 0;
      $May9 = 0;
     $June9 = 0;
     $July9 = 0;
   $August9 = 0;
$September9 = 0;
  $October9 = 0;
 $November9 = 0;
 $December9 = 0;

?>
                
			       
			    <?php 
                $date = date("F");
                $year3 = date("Y") - 1;
                $year4 = date("Y");
                ?>
                
                <font face="Verdana" size="1">

                <?php foreach ($claims_submissionRecords as $record): ?>
                
	            <?php $year_3 = date("Y", strtotime($record['createdDate'])) ?>
	            <?php $date_3 = date("m", strtotime($record['createdDate'])) ?>
	            <?php $year_4 = date("Y", strtotime($record['createdDate'])) ?>
	            <?php $date_4 = date("m", strtotime($record['createdDate'])) ?>
                
                
                <?php if ($year_3 == $year3 || $year_4 == $year4): ?>
                
                
                <?php if ($year_3 == $year3 AND $date_3 == "01"): ?>
                <?php $January = $January + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "02"): ?>
                <?php $February = $February + 1 ?>
               
                <?php elseif ($year_3 == $year3 AND $date_3 == "03"): ?>
                <?php $March = $March + 1 ?>
               
                <?php elseif ($year_3 == $year3 AND $date_3 == "04"): ?>
                <?php $April = $April + 1 ?>
               
                <?php elseif ($year_3 == $year3 AND $date_3 == "05"): ?>
                <?php $May = $May + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "06"): ?>
                <?php $June = $June + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "07"): ?>
                <?php $July = $July + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "08"): ?>
                <?php $August = $August + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "09"): ?>
                <?php $September = $September + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "10"): ?>
                <?php $October = $October + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "11"): ?>
                <?php $November = $November + 1 ?>
                
                <?php elseif ($year_3 == $year3 AND $date_3 == "12"): ?>
                <?php $December = $December + 1 ?>
                
                
                <!-- Split For Current Year -->
                
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "01"): ?>
                <?php $January9 = $January9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "02"): ?>
                <?php $February9 = $February9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "03"): ?>
                <?php $March9 = $March9 + 1 ?>
               
                <?php elseif ($year_4 == $year4 AND $date_4 == "04"): ?>
                <?php $April9 = $April9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "05"): ?>
                <?php $May9 = $May9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "06"): ?>
                <?php $June9 = $June9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "07"): ?>
                <?php $July9 = $July9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "08"): ?>
                <?php $August9 = $August9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "09"): ?>
                <?php $September9 = $September9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "10"): ?>
                <?php $October9 = $October9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "11"): ?>
                <?php $November9 = $November9 + 1 ?>
                
                <?php elseif ($year_4 == $year4 AND $date_4 == "12"): ?>
                <?php $December9 = $December9 + 1 ?>
                <?php else: ?>
            
                <?php endif ?>
                <?php endif ?>
                <?php endforeach ?>

<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td>
		<table border="0" cellpadding="0" cellspacing="0" width="100%">
			<tr>
			
			</tr>
			
			<tr>

<font face="Verdana" size="1">
			    	    
<!--- 1 --->	
				<td bgcolor="#999966" align="center">Jan <?php echo $year3 ?></td>
<!--- 2 --->			
				<td bgcolor="#999966" align="center">Feb <?php echo $year3?></td>
<!--- 3 --->				
				<td bgcolor="#999966" align="center">Mar <?php echo $year3 ?></td>
<!--- 4 --->
                <td bgcolor="#999966" align="center">Apr <?php echo $year3 ?></td>
<!--- 5 --->				
				<td bgcolor="#999966" align="center">May <?php echo $year3 ?></td>
<!--- 6 --->				
				<td bgcolor="#999966" align="center">Jun <?php echo $year3 ?></td>
<!--- 7 --->				
				<td bgcolor="#999966" align="center">Jul <?php echo $year3 ?></td>
<!--- 8 --->				
				<td bgcolor="#999966" align="center">Aug <?php echo $year3 ?></td>
<!--- 9 --->				
				<td bgcolor="#999966" align="center">Sep <?php echo $year3 ?></td>
<!--- 10 --->				
				<td bgcolor="#999966" align="center">Oct <?php echo $year3 ?></td>
<!--- 11 --->				
				<td bgcolor="#999966" align="center">Nov <?php echo $year3 ?></td>
<!--- 12 --->				
				<td bgcolor="#999966" align="center">Dec <?php echo $year3 ?></td>
			</tr>
			    </font>
<!-- // Split The Boxes Here -->			
			    
			<tr>
			    
<!--- 1 --->
                <td align="center">
                <?php echo $January ?>
				</td>
<!--- 2 --->				
				<td align="center">
				<?php echo $February ?>
				</td>
<!--- 3 --->				
				<td align="center">
                <?php echo $March ?>
				</td>
<!--- 4 --->				
				<td align="center">
				<?php echo $April ?>
				</td>
<!--- 5 --->				
				<td align="center">
				<?php echo $May ?>
				</td>
<!--- 6 --->				
				<td align="center">
				<?php echo $June ?>
				</td>
<!--- 7 --->				
				<td align="center">
				<?php echo $July ?>
				</td>
<!--- 8 --->				
				<td align="center">
				<?php echo $August ?>
				</td>
<!--- 9 --->				
				<td align="center">
				<?php echo $September ?>
				</td>
<!--- 10 --->				
				<td align="center">
				<?php echo $October ?>
				</td>
<!--- 11 --->				
				<td align="center">
				<?php echo $November ?>
				</td>
<!--- 12 --->				
				<td align="center">
				<?php echo $December ?>
				</td>
				
             </tr>
                </font>
            
			
		</table>
		</td>
	</tr>
</table>
<!-- End Table Here -->
<p></p>

<table border="0" cellpadding="0" cellspacing="0" width="100%">
	<tr>
		<td>
		<table border="0" cellpadding="0" cellspacing="0" width="100%">
			<tr>
			
			</tr>
			
			<tr>
			
			
			    <font face="Verdana" size="1">
<!--- 1 --->	
				<td bgcolor="#999966" align="center">Jan <?php echo $year4 ?></td>
<!--- 2 --->			
				<td bgcolor="#999966" align="center">Feb <?php echo $year4?></td>
<!--- 3 --->				
				<td bgcolor="#999966" align="center">Mar <?php echo $year4 ?></td>
<!--- 4 --->
                <td bgcolor="#999966" align="center">Apr <?php echo $year4 ?></td>
<!--- 5 --->				
				<td bgcolor="#999966" align="center">May <?php echo $year4 ?></td>
<!--- 6 --->				
				<td bgcolor="#999966" align="center">Jun <?php echo $year4 ?></td>
<!--- 7 --->				
				<td bgcolor="#999966" align="center">Jul <?php echo $year4 ?></td>
<!--- 8 --->				
				<td bgcolor="#999966" align="center">Aug <?php echo $year4 ?></td>
<!--- 9 --->				
				<td bgcolor="#999966" align="center">Sep <?php echo $year4 ?></td>
<!--- 10 --->				
				<td bgcolor="#999966" align="center">Oct <?php echo $year4 ?></td>
<!--- 11 --->				
				<td bgcolor="#999966" align="center">Nov <?php echo $year4 ?></td>
<!--- 12 --->				
				<td bgcolor="#999966" align="center">Dec <?php echo $year4 ?></td>
			</tr>
			    </font>
<!-- // Split The Boxes Here -->			
			    
			<tr>
			    <font face="Verdana" size="1">

<!--- 1 --->
                <td align="center">
                <?php echo $January9 ?>
				</td>
<!--- 2 --->				
				<td align="center">
				<?php echo $February9 ?>
				</td>
<!--- 3 --->				
				<td align="center">
				<?php echo $March9 ?>
				</td>
<!--- 4 --->				
				<td align="center">
				<?php echo $April9 ?>
				</td>
<!--- 5 --->				
				<td align="center">
				<?php echo $May9 ?>
				</td>
<!--- 6 --->				
				<td align="center">
				<?php echo $June9 ?>
				</td>
<!--- 7 --->				
				<td align="center">
                <?php echo $July9 ?>
				</td>
<!--- 8 --->				
				<td align="center">
				<?php echo $August9 ?>
				</td>
<!--- 9 --->				
				<td align="center">
				<?php echo $September9 ?>
				</td>
<!--- 10 --->				
				<td align="center">
				<?php echo $October9 ?>
				</td>
<!--- 11 --->				
				<td align="center">
				<?php echo $November9 ?>
				</td>
<!--- 12 --->				
				<td align="center">
				<?php echo $December9 ?>
				</td>
             </tr>
                </font>
		</table>
		</td>
	</tr>
</table>
<?php endif ?>


</html>