<?php
	include 'config.php';

	// Check if the user is logged in

	if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
		header("Location: login.php");
		exit;
	}

	$id = (int)$_GET["id"];

	//update sort for others
	/*$sql = "select * from company where id = ? ";
	$parameters = array($id);
	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
		exit;
	}

	if (!$sth->execute($parameters)) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
		exit;
	}
	$category_info = $sth->fetch(PDO::FETCH_ASSOC);
	$sort = $category_info{"sort"};


	$sql = "update company set sort = sort - 1 where sort > ?";
	$parameters = array($sort);
	if (!($sth = $dbh->prepare($sql))) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
	}

	if (!$sth->execute($parameters)) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
	}*/

	// Delete db
	$sql2 = "update company set deleted = ? WHERE id=?";

	if (!($sth2 = $dbh->prepare($sql2))) {
		throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth2->errorInfo()));
	}

	if (!$sth2->execute(array("1", $id))) {
		throw new Exception('[' . $sth2->errorCode() . ']: ' . print_r($sth2->errorInfo()));
	}

	$dbh = null;

	header("Location: company_index.php?msg=刪除成功");

?>