﻿﻿﻿<?php
// required headers
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Allow-Headers: access");
header("Access-Control-Allow-Methods: GET");
header("Access-Control-Allow-Credentials: true");

 
// include database and object files
include_once '../config/database.php';
include_once '../objects/employee.php';

$ofid = $_POST["offcid"];

$database = new Database();
$db = $database->getConnection();
 
$empread = new employee($db);

$empread->ts_brid = $ofid;

// query products
$stmt = $empread->at_read();
$num = $stmt->rowCount();
 //echo $num;
// check if more than 0 record found
if($num>0){
 
    // products array
    $empread_arr=array();
    $empread_arr["records"]=array();
	
	 
    // retrieve our table contents
    // fetch() is faster than fetchAll()
    // http://stackoverflow.com/questions/2770630/pdofetchall-vs-pdofetch-in-a-loop
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        // extract row
        // this will make $row['name'] to
        // just $name only
        extract($row);
		
		//$ts_scantime =str_replace("-","/",$ts_scantime);
		//$datescan = DateTime::createFromFormat('d/m/Y H:i', $ts_scantime);
		//$ts_scantime = $datescan->format('Y-m-d H:i:s');
		//$ts_scantime = date_parse_from_format('d/M/Y:H:i:s', $ts_scantime);
 
        $empread_item=array(
			"empname" =>  $empname,
            "ts_empid" => $ts_empid,
            "ts_scantime" => $ts_scantime,
            "ts_scanloc" => $ts_scanloc,
            "ts_type" => $ts_type
			
			//$empname,$ts_id,$ts_scantime,$ts_scanloc,$ts_type
        );
 
        array_push($empread_arr["records"], $empread_item);
    }
 
    // set response code - 200 OK
    http_response_code(200);
 
    // show products data in json format
    echo json_encode($empread_arr);
}

?>