<?php
    use \koolreport\widgets\google;
    use \koolreport\datagrid\DataTables;
        use \koolreport\widgets\koolphp\Table;
        use \koolreport\bootstrap3\Theme;

?>
<style>
    @media  print {
      #table1 .break-row td {
        padding: 0 !important;
      }

      * {
            -webkit-print-color-adjust: exact;
      }

 #salesQuarterCustomer th	{
  background-color: #4CAF50;
  color: white;
   border: 1px solid #ddd;
  padding: 8px;
    font-family: Arial, Helvetica, sans-serif;

      }
      #salesQuarterCustomer td	{
         background-color: #ffffff !important;
  border: 1px solid #ddd;
  padding: 8px;
    font-family: Arial, Helvetica, sans-serif;

      }

    }
</style>
<html>
	<head>
		<title>Customer Sales</title>
	</head>
  <body style='margin: 02.in'>
    <header>
        <div style="font-size:10px !important; color:#808080; padding-left:10px; width:575px;">
			<span style='position: relative; top: 10px; float: right'>
				Title: <span class="title"></span> || 
				Page: <span class="pageNumber"></span> || 
				Total pages: <span class="totalPages"></span> || 
				Date: <span class="date"></span>
			</span>
            <!--<span style=''>
				<img src='bar.png' height='20px' style='position:relative; top:5px'/>
				KoolReport 
			</span>-->
			
			<span>APPOINTMENT SCHEDULER REPORT</span>
        </div>
    </header>
    <footer>
		<div style="font-size:10px !important; color:#808080; padding-left:10px; width:575px;">
			<span style='position: relative; top: 10px; float: right'>
				Title: {title} || 
				Page: {pageNumber} || 
				Total pages: {totalPages} || 
				Date: {date}
			</span>
            <span style=''>
				<img src='bar.png' height='20px' style='position:relative; top:5px'/>
				<!--KoolReport -->
			</span>
        </div>
    </footer> 
	<?php 
Table::create(array(
    			'name' => 'salesQuarterCustomer',
            "dataSource" => $this->dataStore('myappts'),
            "removeDuplicate"=>array("name", "concatday"),
          

                "columns"=>array(
                    "name"=>array(
                    "label"=>"Service Name",
                ),
                "concatday"=>array(
                    "label"=>"Start-date",
                ),
                 "starttimefixed"=>array(
                    "label"=>"Start-time",
                    "type"=>"hh:mm", 
                ),
                "endtimefixed"=>array(
                    "label"=>"End-time",
                    "type"=>"hh:mm", 

                ),
                "first_name"=>array(
                    "label"=>"First Name",
                ),
                "last_name"=>array(
                    "label"=>"Last Name",
                ),
                "email"=>array(
                    "label"=>"Email",
                ),
                "phone_number"=>array(
                    "label"=>"Phone Number",
                ),
                 "address"=>array(
                    "label"=>"Address",
                ),
                 "city"=>array(
                    "label"=>"City",
                ),
                 "zipcode"=>array(
                    "label"=>"Zipcode",
                ),
                "birthdate"=>array(
                    "label"=>"Birthdate",
                ),
                 "concatbookday"=>array(
                    "label"=>"Date booked",
                ),
                 "booktimefixed"=>array(
                    "label"=>"Time booked",
                                        "type"=>"hh:mm", 

                ),
                "usernotes"=>array(
                    "label"=>"Customer Notes",
                ),
                "apptnotes"=>array(
                    "label"=>"Backend notes",
                ),),
                "cssClass"=>array(
            "table"=>"table table-bordered table-striped"
        ),
        ));
	?>
  </body>
</html>
