$orders_products_problem = array();
while ($row = tep_db_fetch_array($orders_products_query)) {
$orders_products_problem[] = $row['orders_products_problem_id'];
$opid = $row['orders_products_id'];
$oppid = $row['orders_products_problem_id'];
$oppqty = $row['products_quantity'];
$qty = $_POST['products_problem_qty_' . $oppid];
if (in_array($oppid, $opp_selected)) {
changeOrderProductStatus($oppid, $opid, $qty, RECEIVED_PRODUCT_STATUS);
} else {
if ($oppqty == $qty) {
changeOrderProductStatus($oppid, $opid, $qty, MISSDAM_PRODUCT_STATUS);
} else {
$receive_qty = $oppqty - $qty;
changeOrderProductStatus($oppid, $opid, $receive_qty, RECEIVED_PRODUCT_STATUS);
changeOrderProductStatus(null, $opid, $qty, MISSDAM_PRODUCT_STATUS);
}
tep_db_query("UPDATE minierp_packages_to_orders_products_problem SET received_problem='1' WHERE minierp_packages_id={$package_id} AND orders_products_problem_id={$oppid}");
}
}
}
tep_db_query("UPDATE minierp_packages SET received_date=NOW(),orders_updated='1' WHERE packages_id={$package_id}");
header("Location: ?open=package-receive&package_id={$package_id}");
exit;
}
}
}
//START TEMPLATE
$package_id = isset($_GET['package_id']) ? $_GET['package_id'] : '';
if ($package_id != '') {
$package_detail_query = "SELECT * FROM minierp_packages mp WHERE mp.packages_id='{$package_id}'";
include DIR_WS_EMAILS . $languages[2]['path'] . '/orders-sent-tocust.php';
$from_email_name = FROM_EMAIL_NAME;
$from_email_address = FROM_EMAIL_ADDRESS;
$sent = tep_mail($to_name, $to_email_address, $email_subject, $email_text, $from_email_name, $from_email_address);
if ($sent) {
tep_db_query("UPDATE orders_status_history SET customer_notified='1' WHERE orders_id={$order_id} AND orders_status_id=10");
tep_mail(EMAIL_NAME_SERVICE, EMAIL_ADDRESS_SERVICE, $email_subject, $email_text, $from_email_name, $from_email_address);
}
unset($order);
unset($products);
}
}
if (isset($_POST['cb_orders_products_problem']) && is_array($_POST['cb_orders_products_problem'])) {
foreach ($_POST['cb_orders_products_problem'] as $oppid) {
$product_qty = $_POST['opp_qty_' . $oppid];
changeOrderProductStatus($oppid, '', $product_qty, '10');
}
//SEND NOTIFICATION "SENT TO CUSTOMER"
$opp_filter = implode(',', $_POST['cb_orders_products_problem']);
$opp_query = "SELECT o.* FROM orders o";
$opp_query .= " INNER JOIN orders_products op ON op.orders_id=o.orders_id";
$opp_query .= " INNER JOIN orders_products_problem opp";
$opp_query .= "\t\tON opp.orders_products_id=op.orders_products_id";
$opp_query .= "\t\tAND opp.orders_products_problem_id IN ({$opp_filter})";
$opp_query .= " GROUP BY o.orders_id";
$opp_result = tep_db_query($opp_query);
$orders = array();
while ($row = tep_db_fetch_array($opp_result)) {
$orders[] = $row;
}
foreach ($orders as $order) {
