$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) {