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'] != '') {
$specials_on_off_id = $_POST['specials_on_off'];
$specials = Specials($specials_on_off_id);
$specials_on_off = $specials == '1' ? '0' : '1';
$specials_update = "UPDATE sohorepro_pickup_add SET caption = '" . $specials_on_off . "' WHERE id = '" . $specials_on_off_id . "' ";
mysql_query($specials_update);
echo $specials_on_off;
}
//Invoice Type Set
if (isset($_POST['invoice_type']) && $_POST['invoice_type'] != '') {
$invoice_type = $_POST['invoice_type'];
$invoice_comp_id = $_POST['invoice_comp_id'];
$invoice_change = "UPDATE sohorepro_company SET invoice_type = '" . $invoice_type . "' WHERE comp_id = '" . $invoice_comp_id . "' ";
mysql_query($invoice_change);
if ($invoice_type == '7') {
echo 'Weekly';
} elseif ($invoice_type == '14') {
echo 'Semi-Weekly';
If you've ordered products or services with us, you have an account.
If you don't remember your username or password, please feel free
to call us at (212) 268-6522 or email us at support@sohorepro.com
</p>
<div class="sideheadline">New to Soho Repro?</div>
<p style="margin-top:-5px!important;">
<a href="sign_up.php">Sign up here</a> for a free account.
</p>-->
</div>
</div>
<div>
<a href="http://sohorepro.com/plotter-equipment-maintenance-and-supplies/" target="_blank"><img src="./images/plotters.gif" style="border: 0px;width: 100%;" /></a>
</div>
<?php
$specials = Specials('3');
if($specials == '1'){
?>
<div style="background-color: #fff;border: 1px solid #000;border-bottom: 0px;text-align: center;padding-top: 15px;padding-bottom: 15px;">
<a href="http://sohorepro.com/specials/" target="_blank" style="text-decoration: none;background: #BFC5CD;padding: 10px;padding-left: 60px;padding-right: 60px;border-radius: 8px;color: #FFF;font-weight: bold;font-size: 17px;">SPECIALS</a>
</div>
<?php
}
?>
</div>
<script>
function check_log()
{
var usr_id = document.getElementById('usr_id').value;
if (usr_id == '') {
window.location = "new_account_add.php";