<?php

include 'db.inc.php';

$id_company = 1;


//get all companies


//get a company's data

$stmt_file = $dbh->prepare(
	"SELECT
		file_row.id_file_row, file_row.row_number,
		file_row.division, file_row.consignee,
		DATE_FORMAT(file_row.date_called_in, '%m/%d/%Y') date_called_in,
		
		file_row.dispatch_number, file_row.shipper,
		DATE_FORMAT(file_row.date_ready, '%m/%d/%Y') date_ready,
		file_row.address_1, file_row.address_2, file_row.city, file_row.state, file_row.zip, file_row.phone,
		
		TIME_FORMAT(file_row.time_ready, '%H:%i %p'),
		TIME_FORMAT(file_row.time_close, '%H:%i %p'),
		TIME_FORMAT(file_row.time_pickup, '%H:%i %p'),
		TIME_FORMAT(file_row.time_depart, '%H:%i %p'),
		file_row.bol_delivered,
		file_row.dispatch_reference,
		file_row.ctns, file_row.weight, file_row.cube

	FROM file_row
	INNER JOIN file USING(id_file)
	WHERE id_company = :id_company");
							
$stmt_file->execute(array(':id_company' => $id_company));

$rows = $stmt_file->fetchAll(PDO::FETCH_ASSOC);

echo json_encode($rows, JSON_PRETTY_PRINT);

?>