</td>
</tr>
<tr><td align="left" valign="top" style="padding-top:10px">
<div id="inline_edit">
<table width="735" align="center" cellspacing="0" cellpadding="0" >
<tr style="color:#fff;">
<td width="285" align="left" valign="middle" bgcolor="#f68210" class="brdr pad_lft">Product Detail</td>
<td width="50" align="center" valign="middle" bgcolor="#f68210" class="brdr">Quantity</td>
<td width="75" align="center" valign="middle" bgcolor="#f68210" class="brdr pad_rght">Unit Cost</td>
<td width="85" align="center" valign="middle" bgcolor="#f68210" class="brdr pad_rght">Line Cost</td>
<td width="15" align="center" valign="middle" bgcolor="#f68210" class="brdr pad_rght">Action</td>
</tr>
<?php
$view_orders = viewOrders($id);
$j = 1;
foreach ($view_orders as $ord) {
$rowColor = $j % 2 != 0 ? '#dfdfdf' : '#eeeeee';
$rowColor1 = $j % 2 != 0 ? '#eeeeee' : '#f6f2f2';
$prod_id = $ord['product_id'];
$id = $ord['id'];
$ord_id_t = $ord['order_id'];
?>
<tr class="inline" id="<?php
echo $id;
?>
" >
<span class="jass" id="<?php
echo $id;
?>
<?php
if (!isset($_REQUEST['cmd'])) {
echo '{"result":0,message:"unknown command"}';
exit;
}
$cmd = $_REQUEST['cmd'];
switch ($cmd) {
case 1:
viewOrders();
break;
case 2:
setOrderReady();
break;
case 3:
dischargeOrder();
break;
case 4:
viewHistory();
break;
default:
echo '{"result":0,"message":"unknown command"}';
break;
}
function viewOrders()
{
include "order.php";
$obj = new order();
if ($obj->viewOrders()) {
$row = $obj->fetch();
echo '{"result":1,"orders":[';
$delete_fav = "UPDATE sohorepro_order_master SET customer_company = '" . $customer_id . "', customer_name = '" . $cus_manager . "', customer_company_name = '" . $Customer_name_orders . "' WHERE id = '" . $current_cus_id . "' ";
$result = mysql_query($delete_fav);
if ($result) {
echo '1';
} else {
echo '0';
}
}
//Close the Order
if (isset($_POST['order_closed_now_id']) && $_POST['order_closed_now_id'] != '') {
$order_closed_now_id = $_POST['order_closed_now_id'];
$current_status = OrderComment($order_closed_now_id);
$close_status = $current_status[0]['closed_status'] == '1' ? '0' : '1';
$order_close = "UPDATE sohorepro_order_master SET closed_status = '" . $close_status . "' WHERE id = '" . $order_closed_now_id . "' ";
mysql_query($order_close);
$orders_details = viewOrders($order_closed_now_id);
$check_order_exist = CheckOrderidInvoice($order_closed_now_id);
if (count($check_order_exist) > 0) {
$order_close = "UPDATE sohorepro_invoice SET inv_status = '" . $close_status . "',\n created_date = now() WHERE order_id = '" . $order_closed_now_id . "' ";
mysql_query($order_close);
} else {
foreach ($orders_details as $details) {
$sql = "INSERT INTO sohorepro_invoice\n\t\t\tSET order_id = '" . $details['order_id'] . "',\n order_sequence = '" . $current_status[0]['order_number'] . "',\n job_reference = '" . $current_status[0]['order_id'] . "',\n customer_id = '" . $current_status[0]['customer_company'] . "',\n user_id = '" . $current_status[0]['customer_name'] . "',\n company_name = '" . $current_status[0]['customer_company_name'] . "',\n product_id = '" . $details['product_id'] . "',\n product_price = '" . number_format($details['product_price'], 2, '.', '') . "',\n product_qty = '" . $details['product_quantity'] . "',\n line_cost = '" . number_format($details['product_price'] * $details['product_quantity'], 2, '.', '') . "', \n product_name = '" . mysql_real_escape_string($details['product_name']) . "',\n inv_status = '" . $close_status . "',\n created_date = now() ";
$sql_result = mysql_query($sql);
}
}
$after_status = OrderComment($order_closed_now_id);
echo $after_status[0]['closed_status'];
}
//Close the Order
if (isset($_POST['specials_on_off']) && $_POST['specials_on_off'] != '') {
?>
<div style="float: left;width:100%;background-color: #dfdfdf;">
<div style="float: left;width:100%;text-align: center;margin-top: 5px;margin-bottom: 5px;"><?php
echo $invoice['customer_company_name'];
?>
</div>
</div>
<div style="float: left;width:99%;border:3px solid #F99B3E;">
<?php
foreach ($order as $inv_prod) {
echo 'REFERENCE : ' . $inv_prod['order_id'] . '<br>';
$GetInvProd = GetOrderIdInvoice($inv_prod['order_id'], $inv_prod['customer_name'], $inv_prod['customer_company']);
foreach ($GetInvProd as $order_number) {
echo 'ORDER NUMBER : ' . $order_number['order_number'] . '<br>';
echo 'ORDER ID : ' . $order_number['id'] . '<br>';
$Invoice_products = viewOrders($order_number['id']);
$order_number_inv[] = $order_number['id'];
?>
<div style="width:98%;float:left;border:1px solid #000;margin-left: 6px;">
<div style="width:10%;float:left;">Job Number</div>
<div style="width:10%;float:left;">Date</div>
<div style="width:30%;float:left;">Item Description</div>
<div style="width:10%;float:left;">Quantity</div>
<div style="width:10%;float:left;">Unit Price</div>
<div style="width:10%;float:left;">Extended Price</div>
<div style="width:10%;float:left;">Tax</div>
<div style="width:10%;float:left;">Total</div>
</div>
<?php
echo '<pre>';
<?php
include './config.php';
include './auth.php';
$id_order = $_GET['id'];
$view_orders = viewOrders($id_order);
$id_j = $view_orders[0]['order_id'];
if ($_GET['delete_id']) {
$delete_id = $_GET['delete_id'];
$sql = "DELETE FROM sohorepro_product_master WHERE id = " . $delete_id . " ";
$sql_result = mysql_query($sql);
if ($sql_result) {
$result = "success_del";
} else {
$result = "failure_del";
}
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Soho-repro</title>
<link href="style/style.css" rel="stylesheet" type="text/css" media="all" />
<!-- Add fancyBox main JS and CSS files -->
<script type="text/javascript" src="js/jquery-1.10.1.min.js"></script>
function ExtraProductsInOrder($Order_Id, $shipp_add_id, $short_msg)
{
$sql_order_id_mail = mysql_query("SELECT id,order_id,created_date,order_number,customer_name,customer_company,deleivery_date,order_comment FROM sohorepro_order_master WHERE id = '" . $Order_Id . "' ORDER BY id DESC LIMIT 1");
$object = mysql_fetch_assoc($sql_order_id_mail);
$user_mail_id_txt = UserMail($object['customer_name']);
$user_mail = array('email_id' => UserMail($object['customer_name']));
$user_name = UserName($object['customer_name']);
$company_name = companyName($object['customer_company']);
$phone = companyphone($object['customer_company']);
$billing_address = BillingAddressShippId($object['customer_company']);
$shipp_address = CompanyAddressMail($billing_address);
$prop = PropTest($shipping_id);
$id = $Order_Id;
$Order_id = $object['order_id'];
$Order_number = $object['order_number'];
$deleivery_date = $object['deleivery_date'];
$comp_id = $object['customer_company'];
$order_comm = $object['order_comment'];
//$current_time = date("Y-m-d h:i:s");
$current_time = $object['created_date'];
$datew = new DateTime($current_time, new DateTimeZone('America/New_York'));
date_default_timezone_set('America/New_York');
$temp_times = date("Y-m-d h:iA", $datew->format('U'));
//$Date = date("m-d-Y", strtotime(date('Y-m-d h:i:s', time()))). ' ' .date("h:iA",strtotime("-0 minutes",strtotime($temp_times)));
$Date = date('Y-m-d h:i A', time());
$view_orders = viewOrders($id);
$pick_up = $view_orders[0]['shipping_add_id'];
$mail_id = getActiveEmail();
$returnValue = html_entity_decode('Your Soho Repro graphics order has been received and will be processed promptly.', ENT_COMPAT, 'ISO-8859-1');
$customer_email = array('email_id' => CompanyMail($comp_id));
array_push($mail_id, $user_mail, $customer_email);
$comment = 'Comment :';
$address_3 = $shipp_address['address_3'] != '' ? $shipp_address['address_3'] . '<br>' : '';
$mail = new PHPMailer();
$message = '<html>';
$message .= '<head>';
$message .= '<title></title>';
$message .= '<meta content="text/html;charset=iso-8859-1" http-equiv="Content-Type">';
$message .= '</head>';
$message .= '<body>';
$message .= '<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">';
$message .= '<table width="780" border="0" cellspacing="0" cellpadding="0" class="padd">';
$message .= '<tr><td>' . $short_msg . '</td></tr>';
$message .= '</table>';
$message .= '<table width="780" border="0" cellspacing="0" cellpadding="0" class="padd">';
$message .= '<tr bgcolor="#ff7e00">';
$message .= '<td width="10" height="10" align="left" valign="top"></td>';
$message .= '<td height="10" align="left" valign="top"></td>';
$message .= '<td width="10" height="10" align="left" valign="top"></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td width="10" align="left" valign="top" bgcolor="#ff7e00"></td>';
$message .= '<td align="left" valign="top"><table width="760" border="0" cellspacing="0" cellpadding="0">';
$message .= '<tr>';
$message .= '<td width="20" height="20" align="left" valign="top"></td>';
$message .= '<td height="20" align="left" valign="top"></td>';
$message .= '<td width="20" height="20" align="left" valign="top"></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td width="20" align="left" valign="top"></td>';
$message .= '<td align="left" valign="top"><table width="740" border="0" cellspacing="0" cellpadding="0">';
$message .= '<tr>';
$message .= '<td>' . $returnValue . '</br></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td> </td>';
$message .= '</tr>';
$message .= '<tr height="30px">';
$message .= '<td><span style="font-weight:bold;">Customer Reference :</span> ' . $Order_id . '</td>';
$message .= '</tr>';
$message .= '<tr height="25px">';
$message .= '<td><span style="font-weight:bold;">Date :</span> ' . $Date . '</td>';
$message .= '</tr>';
$message .= '<tr height="25px">';
$message .= '<td><span style="font-weight:bold;">Name :</span> ' . $user_name . '</td>';
$message .= '</tr>';
$message .= '<tr height="25px">';
$message .= '<td><span style="font-weight:bold;">Company :</span> ' . $company_name . '</td>';
$message .= '</tr>';
$message .= '<tr height="25px">';
$message .= '<td><span style="font-weight:bold;">Email :</span> ' . $user_mail_id_txt . '</td>';
$message .= '</tr>';
$message .= '<tr height="25px">';
$message .= '<td><span style="font-weight:bold;">Phone :</span> ' . $phone . '</td>';
$message .= '</tr>';
if ($pick_up == 'P') {
$message .= '<tr height="30px">';
$message .= '<td><span style="font-weight:bold;">Pickup Address: </span></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td style="padding-bottom:7px;">Soho Reprographics<br>381 Broome Street<br>New York, NY 10013</td>';
$message .= '</tr>';
} else {
$message .= '<tr height="30px">';
$message .= '<td><span style="font-weight:bold;">Billing Address: </span></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td style="padding-bottom:7px;">' . $shipp_address['company_name'] . '<br>' . $shipp_address['address_1'] . '<br>' . $shipp_address['address_2'] . '<br>' . $address_3 . $shipp_address['city'] . ', ' . StateName($shipp_address['state']) . ' ' . $shipp_address['zip'] . '</td>';
$message .= '</tr>';
$message .= '<tr height="25px">';
$message .= '<td><span style="font-weight:bold;">Multiple Shipping Addresses: </span></td>';
$message .= '</tr>';
$multi = MultiShippingAddress($Order_Id);
$pick_up_multi = Pickup();
foreach ($multi as $multi_shipp) {
$address_multi_pre = SelectIdAddress($multi_shipp['shipping_id']);
$address_multi_1 = $address_multi_pre[0]['address_1'] != '' ? $address_multi_pre[0]['address_1'] . '<br>' : '';
$address_multi_2 = $address_multi_pre[0]['address_2'] != '' ? $address_multi_pre[0]['address_2'] . '<br>' : '';
$address_multi_3 = $address_multi_pre[0]['address_3'] != '' ? $address_multi_pre[0]['address_3'] . '<br>' : '';
$check_item_id = explode(",", $multi_shipp['item_id']);
$items_tag = $check_item_id[1] != '' ? '<span style="font-weight:bold;">Items : ' . $multi_shipp['item_id'] . '<br>' : '<span style="font-weight:bold;">Item : ' . $multi_shipp['item_id'] . '<br>';
$address_for_items_pre[] = $multi_shipp['shipping_id'] != 'P' ? $items_tag . '</span><span style="font-weight:bold;">Shipping Address: </span><br>' . $address_multi_pre[0]['company_name'] . '<br>' . $address_multi_1 . $address_multi_2 . $address_multi_pre[0]['city'] . ', ' . StateName($address_multi_pre[0]['state']) . ' ' . $address_multi_pre[0]['zip'] . '<br><br><span style="font-weight:bold;">Delivery Date :</span>' . $deleivery_date : $items_tag . '</span><span style="font-weight:bold;">Pickup Address: </span><br>' . $pick_up_multi . '<br><br><br><span style="font-weight:bold;">Delivery Date :</span>' . $deleivery_date;
}
$message .= '<tr><td>';
$message .= '<table align="left">';
for ($m = 0; $m < count($address_for_items_pre); $m += 3) {
$message .= '<tr>
<td>' . $address_for_items_pre[$m] . '</td>
<td>' . $address_for_items_pre[$m + 1] . '</td>
<td>' . $address_for_items_pre[$m + 2] . '</td>
</tr>';
$message .= '<tr><td> </td></tr>';
}
$message .= '</table>';
$message .= '</td></tr>';
}
$message .= '</table></td>';
$message .= '<td height="25" width="20" align="left" valign="top"></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td width="20" align="left" valign="top"></td>';
$message .= '<td align="left" valign="top">';
$message .= '<table width="740" border="0" cellspacing="0" cellpadding="0" style="margin-right:-1px;">';
$message .= '<tr style="color:#fff; text-transform:uppercase;">';
$message .= '<td width="40" align="center" valign="middle" bgcolor="#f68210" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;">Item</td>';
$message .= '<td width="400" align="center" valign="middle" bgcolor="#f68210" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;">Description</td>';
$message .= '<td width="80" align="center" valign="middle" bgcolor="#f68210" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;">Quantity</td>';
$message .= '<td width="100" align="center" valign="middle" bgcolor="#f68210" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;">Unit Price</td>';
$message .= '<td width="110" align="center" valign="middle" bgcolor="#f68210" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;">Total</td>';
$message .= '</tr>';
$total = 0;
$i = 1;
foreach ($view_orders as $ord) {
$rowColor = $i % 2 != 0 ? '#dfdfdf' : '#eeeeee';
$rowColor1 = $i % 2 != 0 ? '#eeeeee' : '#f6f2f2';
$prod_id = $ord['product_id'];
$shipping = SelectAllAddress($ord['shipping_add_id']);
$id = $ord['id'];
$message .= '<tr>';
$message .= '<td width="40" align="left" valign="middle" bgcolor="' . $rowColor1 . '" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-left:20px;">' . $i . '</td>';
$message .= '<td width="400" align="center" valign="middle" bgcolor="' . $rowColor . '" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;">' . getorderProd($prod_id) . '</td>';
$message .= '<td width="80" align="right" valign="middle" bgcolor="' . $rowColor1 . '" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;">' . $ord['product_quantity'] . '</td>';
$message .= '<td width="100" align="right" valign="middle" bgcolor="' . $rowColor . '" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;">' . '$' . $ord['product_price'] . '</td>';
$message .= '<td width="110" align="right" valign="middle" bgcolor="' . $rowColor1 . '" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;">' . '$' . number_format($ord['product_quantity'] * $ord['product_price'], 2, '.', '') . '</td>';
$message .= '</tr>';
$sub_tot = $ord['product_quantity'] * $ord['product_price'];
$tax_status = getTaxStatusChk($comp_id);
$tax_value = TaxValue();
if ($tax_status == '1') {
$tax_line = '0';
} else {
$tax_line = $tax_value;
}
$total = $total + $sub_tot;
$tax = $tax_line * ($total / 100);
$i++;
}
$message .= '<tr>';
$message .= '<td colspan="2" rowspan="3" bgcolor="#eeeeee" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;"><span style="font-weight:bold;">Comment:</span><br>' . $order_comm . '</td>';
$message .= '<td colspan="2" align="right" bgcolor="#eeeeee" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;"><span style="font-weight:bold;">Subtotal</span></td>';
$message .= '<td bgcolor="#eeeeee" align="right" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;">' . '$' . number_format($total, 2, '.', '') . '</td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td colspan="2" align="right" bgcolor="#dfdfdf" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;"><span style="font-weight:bold;">Tax</span></td>';
$message .= '<td bgcolor="#dfdfdf" align="right" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;">' . '$' . number_format($tax, 2, '.', '') . '</td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td colspan="2" align="right" bgcolor="#eeeeee" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;"><span style="font-weight:bold;">Total*</span></td>';
$message .= '<td bgcolor="#eeeeee" align="right" style="border-right:1px solid #fff; border-bottom:1px solid #fff; padding:7px 0px;padding-right:15px;">' . '$' . number_format($total + $tax, 2, '.', '') . '</td>';
$message .= '</tr>';
$message .= '</table></td>';
$message .= '<td width="20" align="left" valign="top"></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td width="20" height="20" align="left" valign="top"></td>';
$message .= '<td height="20" align="left" valign="top"></td>';
$message .= '<td width="20" height="20" align="left" valign="top"></td>';
$message .= '</tr>';
$message .= '<tr>';
$message .= '<td height="20" align="left" valign="top"></td>';
$message .= '<td height="20" align="left" valign="top" style="padding-bottom:5px;font-size:12px;">*Delivery charges to be applied as necessary</td>';
$message .= '<td height="20" align="left" valign="top"></td>';
$message .= ' </tr>';
$message .= '</table></td>';
$message .= '<td width="10" align="left" valign="top" bgcolor="#ff7e00"></td>';
$message .= '</tr>';
$message .= '<tr bgcolor="#ff7e00">';
$message .= '<td width="10" height="10" align="left" valign="top"></td>';
$message .= '<td height="10" align="left" valign="top"></td>';
$message .= '<td width="10" height="10" align="left" valign="top"></td>';
$message .= ' </tr>';
$message .= '</table>';
$message .= '</table>';
$message .= '</body>';
$message .= '</html>';
$final_html = html_entity_decode($message);
// foreach ($mail_id as $to){
// $subject = "Soho Reprographic Order Acknowledgement with Extra Products";
// $headers = 'From: "SohoRepro" <*****@*****.**>' . "\r\n";
// $headers .= 'MIME-Version: 1.0' . "\n";
// $headers .= 'Content-Type: text/html; charset=utf-8\r\n';
// $headers .= 'Content-Transfer-Encoding: 8bit\r\n\r\n';
// $to = $to['email_id'];
// //echo $to, $subject, $message, $headers;
// $result = mail($to, $subject, $message, $headers);
// }
foreach ($mail_id as $mails_sent) {
$pre_filt[] = $mails_sent['email_id'];
}
$final_list = array_unique($pre_filt);
// foreach ($final_list as $to){
// $subject = "Order Changed by Admin for Job:".$Order_id;
// $headers = 'From: "SohoRepro" <*****@*****.**>' . "\r\n";
// $headers .= 'MIME-Version: 1.0' . "\n";
// $headers .= 'Content-Type: text/html; charset=utf-8\r\n'."X-Mailer: PHP";
// $headers .= 'Content-Transfer-Encoding: 8bit\r\n\r\n';
// //$to = $to['email_id'];
// //echo $to, $subject, $message, $headers;
// $result = mail($to, $subject, $final_html, $headers);
// }
$subject = "Order Changed by Admin for Job:" . $Order_id;
$headers = 'From: "SohoRepro" <*****@*****.**>' . "\r\n";
$headers .= 'MIME-Version: 1.0' . "\n";
$headers .= 'Content-Type: text/html; charset=utf-8\\r\\n' . "X-Mailer: PHP";
$headers .= 'Content-Transfer-Encoding: 8bit\\r\\n\\r\\n';
$to = "*****@*****.**";
//echo $to, $subject, $message, $headers;
$result = mail($to, $subject, $final_html, $headers);
if ($result) {
return '1';
} else {
return '0';
}
}
