<?php

require('config.inc.php');

$dbh = new PDO('mysql:host=localhost;dbname=sdpickup', DB_USER, DB_PASS);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


function getCompanies()
{
	global $dbh;
	
	$stmt = $dbh->prepare(
		"SELECT id_company, name, ftp_directory, description
		FROM company");
								
	$stmt->execute();

	$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
	
	return $rows;
}

function getCompanyDirectories()
{
	global $dbh;
	
	$stmt = $dbh->prepare("SELECT id_company, name, ftp_directory FROM company");
	$stmt->execute();
	$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
	
	return $rows;
}

function getCompanyData($id_company)
{
	global $dbh;
	
	$stmt = $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->execute(array(':id_company' => $id_company));

	$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
	
	return $rows;
}

?>