$sendback_id = $_POST['sendback_id']; $products_id = $_POST['products_id']; $ean_no = $_POST['ean']; $type = $_POST['type']; $qty_sent = $_POST['qty_sent']; if ($mode == 'rcv_different_product') { $package_contents = $class_sendback->retrievePackageContentList($package_id, "s.products_ean='{$ean_no}' AND s.type='{$type}' AND s.status='18' AND (s.quantity_stock=0 AND s.quantity_actual=0)"); $products_ean = $class_pean->getProductArticle($ean_no); $products_id = $products_ean['products_id']; $qty_rcv = count($package_contents) > 0 ? $package_contents[0]['quantity_received'] : 0; $qty_sent = '0'; } else { $qty_rcv = $_POST['qty_rcv']; } $qty_rcv++; $is_best_product = $class_pm->isBestProduct($products_id); if ($is_best_product) { $received_status = ''; $post_result .= '<div style="background:#E4E3E0;width:500px;padding:20px;">'; $post_result .= '<table border="0" cellpadding="0" cellspacing="0">'; $post_result .= '<tr><td align="center" colspan="2" style="vertical-align:middle"><h1>Please Do Product Quality Check</h1></td></tr>'; $post_result .= '<tr>'; $post_result .= '<td align="center" style="vertical-align:middle"><input type="button" style="width:120px;height:70px;font-size:20px;" class="qcproduct green bold" value="QC OK" title="Put To \'Bin In HH\' Box"/></td>'; $post_result .= '<td align="center" style="vertical-align:middle"><input type="button" style="width:120px;height:70px;font-size:20px;" class="qcproduct red bold" value="QC BAD" title="Put To \'Need Service\' Box" /></td>'; $post_result .= '</tr>'; $post_result .= '<tr><td align="center" colspan="2"> </td></tr>'; $post_result .= '<tr><td align="center" colspan="2" style="vertical-align:middle"><h1>Or</h1></td></tr>'; $post_result .= '<tr><td align="center" colspan="2" style="vertical-align:middle"><input type="button" style="font-size:20px;" class="qcdis red bold" value="Disassembled" title="Put To \'Disassembled\' Box" /></td></tr>'; $post_result .= '</table>'; $post_result .= '</div>'; } else {
$ajaxResult['result'] = $post_result; ajaxReturn($ajaxResult); exit; } } if (isset($_GET) && count($_GET) > 0) { $ean_no = $_GET['ean']; $pa = $class_pean->getProductArticle($ean_no); $products_id = $pa['products_id']; if ($products_id != '') { $qp = "SELECT p.*, pd.products_name FROM products p INNER JOIN products_description pd ON p.products_id = pd.products_id\n WHERE p.products_id = {$products_id} AND pd.language_id = 2"; $dbqp = tep_db_query($qp); $rp = tep_db_fetch_array($dbqp); $p_img = webImage($rp['products_image'], '350', '350', 'Products ' . $ean_no, 'ui-corner-all'); $p_length = $pa['length'] > 0 ? ' / ' . textLength($pa['length']) : ''; $is_best_product = $class_pm->isBestProduct($pa['products_id']); if ($is_best_product) { $used_form = '<table style="width:100%;position:absolute;top:0;left:0;" border="0" cellpadding="0" cellspacing="0">'; $used_form .= '<tr><td align="center" colspan="2">' . $p_img . '</td></tr>'; $used_form .= '<tr><td align="center" colspan="2" style="font-size:16px;font-weight:bold;">' . $rp['products_model'] . $p_length . '</td></tr>'; $used_form .= '<tr><td align="center" colspan="2" style="padding:9px;"><span class="bold" style="vertical-align:middle;font-size:34px;">Please Do Product Quality Check</span></td></tr>'; $used_form .= '<tr>'; $used_form .= '<input type="hidden" id="hid-ids" value="' . $pa['products_id'] . '-' . $pa['products_articles_id'] . '"/>'; $used_form .= '<td align="center"><input type="button" style="font-size:15px;" class="qcok green button" value="QC OK"/></td>'; $used_form .= '<td align="center"><input type="button" style="font-size:15px;" class="qcbad red button" value="QC BAD"/></td>'; $used_form .= '</tr>'; $used_form .= '</table>'; } else { $used_form .= '<table style="background:#ff0000;width:100%;height:100%;position:absolute;top:0;left:0;" border="0" cellpadding="0" cellspacing="0">'; $used_form .= '<tr><td align="center">' . $p_img . '</td></tr>'; $used_form .= '<tr><td align="center"><h1>' . $rp['products_model'] . $p_length . '</h1></td></tr>';
function processReturnOld($sp_type, $order_id, $ean_code, $reason = '0') { global $class_jo; global $class_o; use_class('payone'); use_class('products_minierp'); $class_payone = new payone(); $class_pm = new products_minierp(); $return_allowed_status = array('9', '11', '16', '20'); $is_best_product = ''; $order_product_id = ''; $product_barcode = ''; $status = 'RETURNNOTALLOWED'; if (strtolower($sp_type) == 's') { $items = $class_jo->retrieveItems($order_id); foreach ($items as $key => $item) { $items_id = $item['jng_sp_orders_items_id']; $product_code = $item['products_model']; $product_name = $item['products_name']; // echo $item['products_ean']." | ".$item['status']."<br/>"; if ($item['products_ean'] == $ean_code && in_array($item['status'], $return_allowed_status)) { $products_id = $item['products_id']; // if($reason=='') { // $order_product_id = $items_id; // $status = 'MCSCANREASON'; // $reasons = $class_jo->returnReasonList(); // $reasons_list = array(); // foreach($reasons as $reason_id=>$val){ // $reasons_list[] = $reason_id."-".$val; // } // $result['reasons'] = $reasons_list; // }else{ $returnable = $item['order_quantity']; $return_data = $class_jo->retrieveReturnItem($items_id); // echo "<pre>";var_dump($return_data); if (!is_null($return_data)) { foreach ($return_data as $rd) { $returnable -= $rd['return_quantity']; } } if ($returnable > 0) { $order_product_id = $items_id; $product_barcode = "SP-{$order_product_id}"; $is_best_product = $class_pm->isBestProduct($item['products_id']); $status = $is_best_product ? 'MCBINORRETURN' : 'MCRETURNTOBALI'; //CREATE RETURN $return_date = date('Y-m-d H:i:s'); $return_qty = 1; $comment_customer = ''; $comment_jng = ''; $shipping_paid = tep_db_prepare_input($_POST['shipping_paid']); $return_id = $class_jo->returnItem($items_id, $return_date, $return_qty, $reason, $comment_customer, $comment_jng, $shipping_paid); //CREATE PAYONE RETURN // $return_id = '123'; if ($return_id != '') { $class_payone->createReturnContainerSP($return_id, $return_qty, $items_id); $items_q = tep_db_query("SELECT SUM(order_quantity) AS total FROM jng_sp_orders_items WHERE jng_sp_orders_id={$order_id} AND status NOT IN (10, 12)"); $items = tep_db_fetch_array($items_q); $items_total = $items['total']; $returns_total = getTotalReturnOrderSP($order_id); $returnable = $items_total - $returns_total; } } // } //BLOCK reason status } } } elseif (strtolower($sp_type) == 'j') { use_class('products_ean'); $class_pean = new products_ean(); $items = $class_o->retrieveProducts($order_id); foreach ($items as $key => $item) { $ean = $class_pean->getEAN($item['products_id'], $item['products_articles_id']); $opid = $item['orders_products_id']; $product_code = $item['products_model']; $product_name = $item['products_name']; // echo $ean." | ".$item['status']."<br/>"; if ($ean == $ean_code && in_array($item['status'], $return_allowed_status)) { $products_id = $item['products_id']; $existing_return = $class_o->productReturnTotalQty($opid); if ($existing_return < $item['products_quantity']) { $order_product_id = $opid; $product_barcode = "JG-{$order_product_id}"; $is_best_product = $class_pm->isBestProduct($item['products_id']); $status = $is_best_product ? 'MCBINORRETURN' : 'MCRETURNTOBALI'; //CREATE RETURN $opid = $item['orders_products_id']; $return_date = date('Y-m-d H:i:s'); $return_qty = 1; $return_type = 'C'; $return_status = '0'; $return_comment = ''; $product_received = 1; $return_id = $class_o->addReturnProduct($opid, $return_date, $return_qty, $return_type, $return_status, $return_comment, $product_received); //CREATE PAYONE RETURN // $return_id = '123'; if ($return_id != '') { $class_payone->createReturnContainer($return_id, $return_qty, $opid); $items_q = tep_db_query("SELECT SUM(products_quantity) AS total FROM orders_products WHERE orders_id={$order_id} AND status NOT IN (10, 12)"); $items = tep_db_fetch_array($items_q); $items_total = $items['total']; $returns_total = getTotalReturnOrderJG($order_id); $returnable = $items_total - $returns_total; } } } } } $result['product_barcode'] = $product_barcode; $result['order_product_id'] = $order_product_id; $result['eancode'] = $ean_code; if ($products_id != '') { $result['product_id'] = $products_id; $qp = "SELECT p.*, pd.products_name FROM products p INNER JOIN products_description pd ON p.products_id = pd.products_id\n WHERE p.products_id = {$products_id} AND pd.language_id = 2"; $dbqp = tep_db_query($qp); $rp = tep_db_fetch_array($dbqp); $result['product_code'] = $rp['products_model']; $result['product_name'] = $rp['products_name']; $result['product_image'] = webImageSource($rp['products_image'], '80'); //'http://www.julie-grace.de/images/imagecache/500x500_03601033.jpg'; } $result['returnable'] = $returnable; $result['status'] = $status; return $result; }