<?php
/*  Program name: Inv_BC_Submit_Order.php
 *  Description:
 *
 *  9/8/2008 - Initial Version
 */
session_start();
include("C3_dbstuff.inc");
include('packages/Mail/Mail-1.1.14/Mail.php');
include('packages/Mail_mime/Mail_Mime-1.5.2/mime.php');

foreach($_POST as $field => $value)
{
	if($field == "Ship_Loc")
	{
		$bc_ship = $value;
	}
}

$cxn = mysqli_connect($host,$user,$passwd,$dbname);
$today = date("Y-m-d");
$sql = "INSERT INTO orders (Cust_ID, Cust_Login_ID, Order_Date, Order_Type, Order_Sub, Ship_Location_ID, Order_Del_Date,Order_Status)
	VALUES ('$_SESSION[cid]','$_SESSION[clid]','$today','b','no',$bc_ship,'0000-00-00','o')";
$result = mysqli_query($cxn,$sql) or die("Error: ".mysqli_error($cxn));
$order_number = mysqli_insert_id($cxn);

$sql = "INSERT INTO business_cards (BC_ID,BC_Name,BC_Title,BC_Title2,BC_Address,BC_City,BC_State,BC_Zip,BC_Phone,BC_Fax,BC_Email,BC_Quantity)
	VALUES ($order_number,'$_SESSION[name]','$_SESSION[title]','$_SESSION[title2]','$_SESSION[address]','$_SESSION[city]','$_SESSION[state]',
	'$_SESSION[zip]','$_SESSION[phone]','$_SESSION[fax]','$_SESSION[email]','$_POST[quant]')";
$result = mysqli_query($cxn,$sql) or die("Error: ".mysqli_error($cxn));

$sql = "INSERT INTO order_items (Order_ID,Part_ID,Order_Item_No,Order_Amount)
	VALUES ($order_number,'999999','1','$_POST[quant]')";
$result = mysqli_query($cxn,$sql) or die("Error: ".mysqli_error($cxn));

$sql_sl = "SELECT Cust_ID,Cust_Login_ID,Ship_Location_ID,Order_Date 
	FROM orders WHERE Order_ID = '$order_number'";
$resultsl = mysqli_query($cxn,$sql_sl) or die("sql_sl: ".mysqli_error($cxn));
$rowsl = mysqli_fetch_array($resultsl);
$order_cust_id = $rowsl['Cust_ID'];
$order_custl_id = $rowsl['Cust_Login_ID'];
$order_ship_id = $rowsl['Ship_Location_ID'];
$order_date = $rowsl['Order_Date'];

$sql_sn = "SELECT Ship_Name,Ship_Street,Ship_City,Ship_State,Ship_Zip FROM ship_locations WHERE Ship_Location_ID = '$order_ship_id' AND Cust_ID ='$order_cust_id'";
$resultsn = mysqli_query($cxn,$sql_sn) or die("sql_sn: ".mysqli_error($cxn));
$rowsn = mysqli_fetch_assoc($resultsn);
$order_ship_name = $rowsn['Ship_Name'];
$order_ship_street = $rowsn['Ship_Street'];
$order_ship_city = $rowsn['Ship_City'];
$order_ship_state = $rowsn['Ship_State'];
$order_ship_zip = $rowsn['Ship_Zip'];

$sql_sl = "SELECT Cust_Desc FROM customers WHERE Cust_ID = '$order_cust_id'";
$resultsl = mysqli_query($cxn,$sql_sl) or die("sql_sl: ".mysqli_error($cxn));
$rowsl = mysqli_fetch_assoc($resultsl);
$order_cust_desc = $rowsl['Cust_Desc'];

$sql_cust = "SELECT Cust_Login_First,Cust_Login_Last,Cust_Login_Email FROM customer_login
	WHERE Cust_Login_ID = '$order_custl_id'";
$result_cust = mysqli_query($cxn,$sql_cust) or die("sql_cust: ".mysqli_error($cxn));
$row_cust = mysqli_fetch_array($result_cust);
$user_id = $row_cust['Cust_Login_First']." ".$row_cust['Cust_Login_Last'];
$user_email = $row_cust['Cust_Login_Email'];

	require('packages/fpdf/fpdf.php');

	$pdf=new FPDF();
	$pdf->AddPage();
	$pdf->SetFont('Arial','B',12);
	$pdf->Text(30,245,"text1");
	$pdf->Text(30,250,"text2");
	$pdf->Text(30,255,"text3");
	$pdf->Output("packages/test.pdf");

$subj = "{$order_cust_desc} Order No: {$order_number}";
$msgtxt1 = "{$order_cust_desc}\nOrder No: {$order_number}\nOrder Date: {$order_date}\nUser Name: {$user_id}\n";
$msgtxt2 = "\nShip Location:\n{$order_ship_name}\n{$order_ship_street}\n{$order_ship_city} {$order_ship_state},{$order_ship_zip}\n";
$order_detail = "\nBusiness Cards: {$_SESSION['name']} Qty: {$_POST['quant']}";
$message = $msgtxt1.$msgtxt2.$order_detail;
#mail($user_email, $subj, $message);
mail("ccarmody@rieglepress.com", $subj, $message);
mail("mcooper@rieglepress.com", $subj, $message);
#mail("fulfillment@conceptthree.com", $subj, $message);
unset($_SESSION['name']);
unset($_SESSION['title']);
unset($_SESSION['title2']);
unset($_SESSION['address']);
unset($_SESSION['city']);
unset($_SESSION['state']);
unset($_SESSION['zip']);
unset($_SESSION['phone']);
unset($_SESSION['fax']);
unset($_SESSION['email']);
unset($_SESSION['name']);
header("Location: C3_BC_End.php");
exit();
?>