<?php
require_once(__DIR__ . '/../checkuser.php');
function add() {
	global $dbh, $sqlsrv_dbh;
	
	//-----------------------------------------------------------------------------
	// Check permission
	//-----------------------------------------------------------------------------
//	if (!Util::isAdmin()) {
//		redirectAndExit('index.php?message=No permission!');
//	}

	//-----------------------------------------------------------------------------
	// Define job
	//-----------------------------------------------------------------------------
	$now = new DateTime;
	$job = array(
		'actived' => 1,
		'deleted' => 0,
		'status' => 1, // Open
		'call_date' => Util::date_to_string($now),
		'call_time' => Util::time_to_string($now),
	);
	
	if (!Util::isAdmin()) {
		$job = array_merge($job, array(
			'type' => 4, // Remote service call
			'staff_id' => $_SESSION['webadmin']['id'], // staff self
		));
	}
	
	require(__DIR__ . '/add.php');

	//-----------------------------------------------------------------------------
	// Return array parameters
	//-----------------------------------------------------------------------------
	$sql = "SELECT * FROM v_cm_customer_support V_CM_CUSTOMER_SUPPORT ORDER BY company_name";
	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception("sql prepare statement failure: $sql");
	}
	$sth->setFetchMode(PDO::FETCH_ASSOC);
	if (!$sth->execute()) {
		throw new Exception("sql execute statement failure: $sql");
	}
	$customers = $sth->fetchAll();
	
	$sql = "SELECT * FROM sys_login WHERE deleted = ? ORDER BY username";
	$parameters = array(0);
	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception("sql prepare statement failure: $sql");
	}
	$sth->setFetchMode(PDO::FETCH_ASSOC);
	if (!$sth->execute($parameters)) {
		throw new Exception("sql execute statement failure: $sql");
	}
	$staffs = $sth->fetchAll();

	
	return array(
		'job' => $job,
		'typeOptions' => Job::typeOptions(),
		'customers' => $customers,
		'staffs' => $staffs,
	);
}
extract(add());

require(__DIR__ . '/views/form.php');