sd-spreadsheet/api/getCompanyData.php

<?php

include 'db.inc.php';

$id_company = isset($_REQUEST['id']) ? $_REQUEST['id'] : null;

if(!$id_company)
{
	http_response_code(400);
	echo 'missing parameter: id';
	return;
}


//get all companies


//get a company's data

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

?>