/** * Get vip status of customer from an order * @param String $type * @param Int $orders_id * @return Boolean */ function checkCustomerIsVIP($type, $orders_id) { $type = strtoupper($type); $is_vip = false; if ($type == 'SP') { use_class('jng_sp_orders'); use_class('jng_sp_customers'); use_class('jng_sp_customers_special'); $class_jo = new jng_sp_orders(); $class_jc = new jng_sp_customers(); $class_jcs = new jng_sp_customers_special(); $o = $class_jo->retrieveDetail($orders_id); //GET CUSTOMER DETAIL VIP OR NOT $cust_data = $class_jc->retrieveDetail(null, $o['jng_sp_id'], $o['customer_billing_id']); if (is_array($cust_data) && $cust_data['jng_sp_customers_id'] > 0) { $cust_detail = $class_jcs->getCustomerDetail($cust_data['jng_sp_customers_id']); } $is_vip = $cust_detail['list_type'] == 'V'; } elseif ($type == 'JG') { use_class('orders'); use_class('customers_special_list'); $class_o = new orders(); $class_csl = new customers_special_list(); $o = $class_o->retrieveDetail($orders_id); //GET CUSTOMER DETAIL VIP OR NOT $cust_detail = $class_csl->getCustomerDetail($o['customers_id']); $is_vip = $cust_detail['list_type'] == 'V'; } elseif ($type == 'DP') { use_class('depot_orders'); $class_do = new depot_orders(); $do = $class_do->retrieveDetail($orders_id); if ($do['trans_type'] == 'SP' || $do['trans_type'] == 'JG') { if ($do['trans_type'] == 'SP') { use_class('jng_sp_orders'); $class_jo = new jng_sp_orders(); $it = $class_jo->retrieveItemDetail($do['trans_id']); $orders_id = $it['jng_sp_orders_id']; } elseif ($do['trans_type'] == 'JG') { use_class('orders'); $class_o = new orders(); $it = $class_o->retrieveProductDetail($do['trans_id']); $orders_id = $it['orders_id']; } $is_vip = checkCustomerIsVIP($do['trans_type'], $orders_id); } } return $is_vip; }
case 'X': $payment_status .= 'red bold">Not Paid'; break; } $payment_status .= '</div>'; $t['s'] = $payment_status; $table[] = $t; } $result .= tep_draw_table('spo', $table); } echo utf8_encode($result); exit; } else { if ($_POST['me_action'] == 'REPORTBANKEINZUGWITHDRAWAL') { $orders_id = tep_db_prepare_input($_POST['orders_id']); $order = $class_o->retrieveDetail($orders_id); $orders_total = $class_o->retrieveTotals($orders_id); $btw_raw = tep_db_prepare_input($_POST['date_withdrawal']); $btw = explode('.', $btw_raw); $date_withdrawal = strtotime($btw[2] . '-' . $btw[1] . '-' . $btw[0]); $date_notification = time(); $date_repayment = strtotime('+' . PAYMENT_METHOD_DIRECT_DEBIT_FAILURE_CHARGE_OVERDUE); $additional_charge = PAYMENT_METHOD_DIRECT_DEBIT_FAILURE_CHARGE; $repayment_amount = $orders_total['ot_total']['value'] + $additional_charge; $data = array(); $data['date_withdrawal'] = date('Y-m-d', $date_withdrawal); $data['date_notification'] = date('Y-m-d H:i:s', $date_notification); $data['date_repayment'] = date('Y-m-d', $date_repayment); $data['additional_charge'] = $additional_charge; $data['repayment_amount'] = $repayment_amount; $created = $class_o->banktransferWithdrawalReport($orders_id, $data);
$labelypad = 4; $labelxpos = 1; $labelypos = 1; foreach ($orders_array as $order_id) { $order = array(); if ($type == 'sp') { //RETRIEVED DATA SP $order_data = $class_jo->retrieveDetail($order_id); $items = $class_jo->retrieveItems($order_id); $order['customer'] = "{$order_data['customer_shipping_firstname']} {$order_data['customer_shipping_lastname']} "; $order['id'] = $order_data['order_id']; $order['shipment_id'] = $order_data['shipment_id']; $order['prefix_code'] = $sp_prefix[$order_data['jng_sp_id']]; } else { //RETRIEVED DATA JNG $order_data = $class_o->retrieveDetail($order_id); $items = $class_o->retrieveProducts($order_id); $order['id'] = $order_data['orders_no']; $order['customer'] = $order_data['delivery_name']; $order['prefix_code'] = ''; } if ($order_counter % $pdf->label_per_page == 0) { $pdf->AddPage(); } $order_counter++; $xpos_starter = ($labelxpos - 1) * $pdf->label_width + $labelxpad; $ypos_starter = ($labelypos - 1) * $pdf->label_height + $labelypad; $logo_xpos = $xpos_starter + 52; $logo_ypos = $ypos_starter; $pdf->Image(FPDF_IMGPATH . 'jng-logo.png', $logo_xpos, $logo_ypos, 43, 5.33); //WxH 64.5 x 8
function getOrderDetail($barcode = '', $idcode_ret = '') { //die("$barcode | $idcode_ret"); $result = array(); $result['status'] = 'MCORDERNOTFOUND'; use_class('jng_sp'); use_class('jng_sp_orders'); if ($barcode != '') { list($type, $order_product_id) = split('-', strtoupper($barcode)); //GET order_id $order_id = ''; if ($type == 'SP' || $type == 'JR') { $status = 'MCSCANPRODUCT'; use_class('jng_sp_customers'); $class_sp = new jng_sp(); $class_jo = new jng_sp_orders(); $class_jc = new jng_sp_customers(); $item = $class_jo->retrieveItemDetail($order_product_id); $order_id = $item['jng_sp_orders_id']; $order = $class_jo->retrieveDetail($order_id); if (count($order) > 0) { $sp = $class_sp->retrieveDetail($order['jng_sp_id']); $customer = $class_jc->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']); $customer_name = $order['customer_billing_firstname'] . ' ' . $order['customer_billing_lastname']; $customers_street_address = $order['customer_billing_address'] . ' ' . $order['customer_billing_address2']; $order_type = $sp['name'] . ' Order ' . $order['order_id']; $result = setOrderResult($status, 'S', $order_id, $order_type, $customer['jng_sp_customers_id'], $customer_name, $order['customer_billing_email'], $order['customer_billing_phone'], $customers_street_address, $order['customer_billing_postcode'], $order['customer_billing_city'], $order['customer_billing_country']); } } elseif ($type == 'JG') { $status = 'MCSCANPRODUCT'; use_class('orders'); $class_o = new orders(); $item = $class_o->retrieveProductDetail($order_product_id); $order_id = $item['orders_id']; $order = $class_o->retrieveDetail($order_id); if (count($order) > 0) { $order_type = 'J&G Order ' . $order['orders_no']; $result = setOrderResult($status, 'J', $order_id, $order_type, $order['customers_id'], $order['customers_name'], $order['customers_email_address'], $order['customers_telephone'], $order['customers_street_address'], $order['customers_postcode'], $order['customers_city'], $order['customers_country']); } } } elseif ($idcode_ret != '') { //1 idcode_ret utk 1 order $qsp = "SELECT j.name AS sp_name, jo.* FROM jng_sp_orders jo INNER JOIN jng_sp j ON j.jng_sp_id = jo.jng_sp_id"; $qsp .= " WHERE idcode_ret = '{$idcode_ret}' ORDER BY jo.order_date DESC LIMIT 1"; $rsp = tep_db_query($qsp); $dsp = tep_db_num_rows($rsp) > 0 ? tep_db_fetch_array($rsp) : null; if (is_null($dsp)) { /* 12.05.2015: * If not found, try to search using order number. * So far at this time, returns from LZ.ID, ZR.ID, ZR.BR used order number barcode */ $qsp = "SELECT j.name AS sp_name, jo.* FROM jng_sp_orders jo INNER JOIN jng_sp j ON j.jng_sp_id = jo.jng_sp_id"; $qsp .= " WHERE jo.order_id = '{$idcode_ret}' ORDER BY jo.order_date DESC LIMIT 1"; $rsp = tep_db_query($qsp); $dsp = tep_db_num_rows($rsp) > 0 ? tep_db_fetch_array($rsp) : null; } $qjg = "SELECT * FROM orders WHERE idcode_ret='{$idcode_ret}' ORDER BY date_purchased DESC LIMIT 1"; $rjg = tep_db_query($qjg); $djg = tep_db_num_rows($rjg) > 0 ? tep_db_fetch_array($rjg) : null; if (!is_null($dsp) || !is_null($djg)) { $status = 'MCSCANPRODUCT'; if (!is_null($dsp) && !is_null($djg)) { $dsp_time = strtotime($dsp['order_date']); $djg_time = strtotime($djg['date_purchased']); $use_data = $dsp_time >= $djg_time ? 'sp' : 'jg'; } else { $use_data = !is_null($dsp) ? 'sp' : 'jg'; } if ($use_data == 'sp') { $order_id = $dsp['jng_sp_orders_id']; use_class('jng_sp_customers'); $class_jc = new jng_sp_customers(); $customer = $class_jc->retrieveDetail(null, $dsp['jng_sp_id'], $dsp['customer_billing_id']); $customer_name = $dsp['customer_billing_firstname'] . ' ' . $dsp['customer_billing_lastname']; $customers_street_address = $dsp['customer_billing_address'] . ' ' . $dsp['customer_billing_address2']; $order_type = $dsp['sp_name'] . ' Order ' . $dsp['order_id']; $result = setOrderResult($status, 'S', $order_id, $order_type, $customer['jng_sp_customers_id'], $customer_name, $dsp['customer_billing_email'], $dsp['customer_billing_phone'], $customers_street_address, $dsp['customer_billing_postcode'], $dsp['customer_billing_city'], $dsp['customer_billing_country']); } else { $order_id = $djg['orders_id']; $order_type = 'J&G Order ' . $djg['orders_no']; $result = setOrderResult($status, 'J', $order_id, $order_type, $djg['customers_id'], $djg['customers_name'], $djg['customers_email_address'], $djg['customers_telephone'], $djg['customers_street_address'], $djg['customers_postcode'], $djg['customers_city'], $djg['customers_country']); } } } return $result; }
$failed = array(); foreach ($sets_of_invoice as $invoice) { $counter++; $order_id = $invoice['invoice_order_id']; $arr_joid = explode(",", $invoice['invoice_order_items_id']); $is_sp = $invoice['invoice_order_type'] == 'S' ? true : false; if ($is_sp) { $order = $class_jo->retrieveDetail($order_id); $items = $class_jo->retrieveItems($order_id); $cust = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']); if (is_null($cust)) { $class_jcust->getFromOrder($order_id); $cust = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']); } } else { $order = $class_o->retrieveDetail($order_id, true); $items = $class_o->retrieveProducts($order_id, true); // $cust = $class_jcust->retrieveDetail(null, $order['jng_sp_id'], $order['customer_billing_id']); } //EXCLUDE ITEMS THAT CANCELLED foreach ($items as $key => $i) { if (!in_array($i['jng_sp_orders_items_id'], $arr_joid)) { unset($items[$key]); } } if ($is_sp) { if (strtoupper($order["payment_method"]) == strtoupper(PAYMENT_METHOD_PREPAYMENT)) { $payi->createFromOrderSP($order, $items, '+1 month'); } else { $payi->createFromOrderSP($order, $items); }
function createReturnContainer($return_id, $return_qty, $opid) { use_class('orders'); use_class('payone_invoice'); use_class('minierp_customers'); $class_o = new orders(); $class_pi = new payone_invoice(); $class_cust = new minierp_customers(); $insert_id = ''; $op = $class_o->retrieveProductDetail($opid); $order_id = $op['orders_id']; $order = $class_o->retrieveDetail($order_id, true); $customers_id = $order['customers_id']; $item = $class_o->retrieveProductDetail($opid); $final_price = $item['final_price']; //CHECK WHETHER CUSTOMER USING COUPON DISCOUNT OR NOT (ONLY ON JNG ORDERS) $qcheck_disc = "SELECT c.* FROM `coupon_redeem_track` crt INNER JOIN `coupons` c\n ON crt.`coupon_id` = c.`coupon_id`\n WHERE crt.`order_id` = {$order_id}"; $dbq_disc = tep_db_query($qcheck_disc); if (tep_db_num_rows($dbq_disc) > 0) { $r_disc = tep_db_fetch_array($dbq_disc); $disc = $r_disc['coupon_amount']; if ($disc > 0 && $disc < 1) { $final_price = $final_price - $final_price * $disc; $final_price = ceil($final_price * 100) / 100; //take only 2 digits decimals ex: 21.165 became 21.16 } } $customer = $class_cust->retrieveDetail($customers_id); $customer_bankdata = $class_cust->getBankAccountData($order_id); $class_pi->retrieveDetail("J", $order_id); //ONLY QUEING JUST FOR TRANSACTION THAT HAVE payone_txid (FIRST GET FROM SUBMITTING INVOICE) if ($class_pi->detail['payone_txid'] != '') { $payone_txid = $class_pi->detail['payone_txid']; $payment_method = $order['payment_method']; $data_por = array(); $data_por['return_id'] = $return_id; $data_por['jng_sp_orders_items_id'] = $item['orders_products_id']; $data_por['jng_sp_customers_id'] = $customer['customers_id']; $data_por['amount'] = round($return_qty * ($final_price * 100)); $data_por['txid'] = $payone_txid; $data_por['invoice_id'] = $class_pi->detail['invoice_id']; $data_por['invoice_no'] = $class_pi->detail['invoice_no']; $data_por['id'] = $item['products_model']; $data_por['pr'] = round($final_price * 100); $data_por['no'] = $return_qty; $data_por['de'] = strlen($item['products_name']) > 32 ? substr($item['products_name'], 0, 32) : $item['products_name']; $data_por['va'] = 0; $data_por['payment_method'] = $payment_method; $data_por['currency'] = 'EUR'; if (!is_null($customer_bankdata)) { $data_por['bankcode'] = $customer_bankdata['banktransfer_blz']; $data_por['bankcountry'] = 'DE'; $data_por['bankaccount'] = $customer_bankdata['banktransfer_number']; $data_por['bankaccountholder'] = $customer_bankdata['banktransfer_owner']; } // echo "<pre>";var_dump($data_por); $insert_id = $this->payoneReturnItemContainer($data_por); $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_q = "SELECT SUM(opr.return_qty) AS total" . " FROM orders_products op" . " LEFT JOIN orders_products_return opr" . " ON opr.orders_products_id = op.orders_products_id" . " WHERE op.orders_id={$order_id}" . " AND op.status NOT IN (10, 12)"; $returns_r = tep_db_query($returns_q); $returns = tep_db_fetch_array($returns_r); $returns_total = $returns['total']; if ($items_total == $returns_total) { $amount_paid = $class_pi->detail['invoice_amount_paid']; $total_costs = $order['shipping_costs'] + $order['cod_costs']; if ($order['shipping_costs'] > 0) { // if((($amount_paid*1)==0)||(($amount_paid<>$order['shipping_costs'])&&($amount_paid<>$total_costs))){ if ($amount_paid * 1 == 0 || $amount_paid > $total_costs) { $q_check = "SELECT * FROM payone_orders_return WHERE txid = '{$payone_txid}' AND id = 'Shipping'"; $dbc = tep_db_query($q_check); if (tep_db_num_rows($dbc) == 0) { //HANDLE DOUBLE OR MORE SHIPING RETURN CONTAINER $amount = round($order['shipping_costs'] * 100); $data_por = array(); $data_por['return_id'] = 0; $data_por['jng_sp_orders_items_id'] = 0; $data_por['jng_sp_customers_id'] = $customer['customers_id']; $data_por['amount'] = $amount; $data_por['txid'] = $payone_txid; $data_por['invoice_id'] = $class_pi->detail['invoice_id']; $data_por['invoice_no'] = $class_pi->detail['invoice_no']; $data_por['id'] = 'Shipping'; $data_por['pr'] = $amount; $data_por['no'] = 1; $data_por['de'] = 'Verpackung & Versand'; $data_por['va'] = 0; $data_por['payment_method'] = $payment_method; $data_por['currency'] = 'EUR'; $insert_id = $this->payoneReturnItemContainer($data_por); } } } } } else { //ORDER NOT SUBMITTED YET TO PAYONE, SO NO TXID CREATED YET. JUST NEED TO EXCLUDE ITEM FROM payone_invoice TABLE COLUMN 'invoice_order_items_id' $oids_arr = explode(',', $class_pi->detail['invoice_order_items_id']); if (is_array($oids_arr)) { $new_amount = $class_pi->detail['invoice_amount'] - $return_qty * $final_price; foreach ($oids_arr as $key => $value) { if ($value == $opid) { unset($oids_arr[$key]); } } $oids = implode(',', $oids_arr); if (count($oids_arr) == 0) { //ALL PRODUCTS RETURNED $new_amount = 0; $class_pi->updateCompleteStatus('3'); //INVOICE CANCELLED } tep_db_perform('payone_invoice', array('invoice_amount' => $new_amount, 'invoice_order_items_id' => $oids), 'update', "invoice_id = '" . $class_pi->detail['invoice_id'] . "'"); } } return $insert_id; }
if (count($item) == 0) { //If no product found $errinfo = $template_error_not_found; $result .= printPackageTip('E', $box_date, $errinfo, $sp_name, $sp_class); } else { //If product is found if (strtoupper($ean_scan) != 'SKIP' && $ean_scan != $item['products_ean']) { $result .= printPackageTip(EAN_MISMATCH_ERROR, $item['products_ean'], $ean_scan); } else { if ($item['status'] < intval($old_status)) { //If product status is not yet finish $errinfo = $template_error_not_finish; $result .= printPackageTip('E', $box_date, $errinfo, $sp_name, $sp_class); } elseif ($item['status'] == $old_status) { //If product status is finish $order = $class_o->retrieveDetail($item['orders_id']); $order_date = strtotime($order['date_purchased']); $box_date = date('d. M', $order_date); //Retrieve all products from the order $items = $class_o->retrieveProducts($order['orders_id']); foreach ($items as $key => $i) { //Exclude any canceled and complete products $iscanceled = $class_o->productStatusIsCancelled($i['status']); $iscomplete = $i['status'] == '9' || $i['status'] == '11'; if ($iscanceled || $iscomplete) { unset($items[$key]); } else { $items[$key]['products_ean'] = $class_ean->getEAN($i['products_id'], $i['products_articles_id']); } } if ($item['order_item_total'] == '1' || count($items) == 1) {
<?php use_class('orders'); $class_o = new orders(); use_class('products_minierp'); $class_pm = new products_minierp(); $opid = tep_db_prepare_input($_GET['opid']); $statusName = $class_o->productStatusName(); $item = $class_o->retrieveProductDetail($opid); $product = $class_pm->retrieveDetail($item['products_id'], 'p'); $order = $class_o->retrieveDetail($item['orders_id']); $history = $class_o->retrieveProductHistory($opid); $history_prod = retrieveProductionHistory('JG', $opid); $htable = array(); $ht = array(); $ht['sort'] = 'No'; $ht['date_add'] = 'Date'; $ht['status'] = 'Status'; //$ht['qty'] = 'Qty'; $ht['login'] = '******'; $htable[] = $ht; $count = 0; $total_history = count($history); $prev_info = array(); foreach ($history as $hk => $h) { $count++; $timestamp = strtotime($h['status_date']); $ht = array(); $ht['sort'] = $count; $ht['date_add'] = date('d.m.y H:i:s', $timestamp); $ht['status'] = $statusName[$h['status']];
switch ($partnertype) { case 'jg': use_class('orders'); $o_o = new orders(); $products = $o_o->retrieveProductDetail($reqid); #header("Content-Type: text/plain; charset=utf-8"); switch ($barcodetype) { case 'code39': #table orders,products,dll. $order_id = $products["orders_id"]; $article_number = $products["products_model"]; $order_item_count = $products["order_item_count"]; $order_item_total = $products["order_item_total"]; $order_qty = $products["products_quantity"]; #table orders $orders = $o_o->retrieveDetail($order_id); $order_no = $orders["orders_no"]; $order_date = strtotime($orders["date_purchased"]); $day = date("d", $order_date); $month = date("M", $order_date); $daily_count = $orders["daily_count"]; #format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel $label_date = $day . ". " . $month; $label_order_seq = $order_item_count . "/" . $order_item_total; $label_cust_name = $orders["delivery_name"]; $label_numtag = "JG"; $label_auftragsnr = $order_no == '' ? "-" : $order_no; $label_lieferscheinnr = ''; $return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name; $return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number; echo $return_label;
$partners_need_ean13 = array('3'); #switch partner prefix switch ($partnertype) { case 'jg': $products = $class_orders->retrieveProductDetail($reqid); #header("Content-Type: text/plain; charset=utf-8"); switch ($barcodetype) { case 'code39': #table orders,products,dll. $order_id = $products["orders_id"]; $article_number = $products["products_model"]; $order_item_count = $products["order_item_count"]; $order_item_total = $products["order_item_total"]; $order_qty = $products["products_quantity"]; #table orders $orders = $class_orders->retrieveDetail($order_id); $order_no = $orders["orders_no"]; $order_date = strtotime($orders["date_purchased"]); $day = date("d", $order_date); $month = date("M", $order_date); $daily_count = $orders["daily_count"]; #format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel $label_date = $day . ". " . $month; $label_order_seq = $order_item_count . "/" . $order_item_total; $label_cust_name = $orders["delivery_name"]; $qcountry = "SELECT countries_iso_code_2 FROM countries WHERE countries_name = '{$orders['delivery_country']}'"; $dbqcountry = tep_db_query($qcountry); $rescountry = tep_db_fetch_array($dbqcountry); $label_suffix = $rescountry['countries_iso_code_2'] != '' ? ".{$rescountry['countries_iso_code_2']}" : ""; $label_numtag = "JG" . $label_suffix; $label_auftragsnr = $order_no == '' ? "-" : $order_no;
$counter_returns_no_txid = 0; $status_paid_complete = array('P', '1'); //$counter_is_refund = 0; $counter_is_refund = array(); if (count($sets_of_returns) > 0) { //echo "<pre>";var_dump($sets_of_returns);die(); $success = array(); $failed = array(); foreach ($sets_of_returns as $returns => $data) { //echo "<pre>";var_dump($data);die(); if ($returns != '') { $txid = $returns; $class_pi = new payone_invoice("payone_txid", $txid); //NOT SEND RETURN OR CANCELLED VORKASSE OR ADVANCED PAYMENT ORDERS BEFORE CUST HAS PAID FULL if ($class_pi->detail['invoice_order_type'] == 'J') { $orders = $class_o->retrieveDetail($class_pi->detail['invoice_order_id']); // if($orders['payment_method']=='Vorkasse' && $class_pi->detail['invoice_complete_status']!='P') continue; if ($orders['payment_method'] == PAYMENT_METHOD_BANK_TRANSFER && !in_array($class_pi->detail['invoice_complete_status'], $status_paid_complete)) { continue; } } elseif ($class_pi->detail['invoice_order_type'] == 'S') { $orders = $class_jo->retrieveDetail($class_pi->detail['invoice_order_id']); if (strtoupper($orders['payment_method']) == strtoupper(PAYMENT_METHOD_PREPAYMENT) && !in_array($class_pi->detail['invoice_complete_status'], $status_paid_complete)) { continue; } } $item_counter = 0; $counter_returns++; $return_hist = array(); $return_hist['amount_return_submitted'] = 0; $return_pkey_id = array();
$op_id = tep_db_prepare_input($_POST['op_id']); $chargedback_amount = tep_db_prepare_input($_POST['chargedback_amount']); $paid_status = tep_db_prepare_input($_POST['paid_status']); $class_o->updateChargedbackDetail($op_id, $chargedback_amount, $paid_status); echo '<div class="green">Update successfully saved</div>'; exit; } } //START TEMPLATE $return_id = isset($_GET['id']) ? tep_db_prepare_input($_GET['id']) : ''; if ($return_id == '') { exit; } $return = $class_o->retrieveReturnDetail($return_id); $product = $class_o->retrieveProductDetail($return['orders_products_id']); $order = $class_o->retrieveDetail($product['orders_id']); $pimg = webImageSource($product['products_image'], '500'); if ($pimg != '') { $pimg = webImage($product['products_image'], '120', '120', '', 'img-border img-padding'); } if ($return['product_received'] != '1') { $receive_array = array('Waiting', 'Received'); $receive = '<select id="receive" name="receive">'; foreach ($receive_array as $val => $opt) { $sel = $return['product_received'] == $val ? 'selected="selected"' : ''; $receive .= '<option value="' . $val . '" ' . $sel . '>' . $opt . '</option>'; } $receive .= '</select>'; } else { $receive = 'Received'; }
function retrieveData($barcode_type, $barcode_id) { use_class('jng_sp'); use_class('orders'); use_class('jng_sp_orders'); use_class('depot_orders'); use_class('products_ean'); use_class('products_minierp'); $class_sp = new jng_sp(); $class_orders = new orders(); $class_jo = new jng_sp_orders(); $class_do = new depot_orders(); $class_pean = new products_ean(); $class_pm = new products_minierp(); $result = ''; //list($partner_type,$order_product_id) = split("-",$barcode_id); //$partner_type = strtolower($partner_type); $tmp_bcid = explode('-', $barcode_id); $partner_type = strtolower($tmp_bcid[0]); $order_product_id = $tmp_bcid[1]; if (is_numeric($partner_type)) { $order_product_id = $partner_type; $partner_type = 'sp'; } //all id without prefix JG or SP indicates as SP if (!empty($order_product_id) && $order_product_id != '') { $partners_need_ean13 = array('3'); #switch partner prefix switch ($partner_type) { case 'jg': $products = $class_orders->retrieveProductDetail($order_product_id); #header("Content-Type: text/plain; charset=utf-8"); switch ($barcode_type) { case 'code39': if (count($products) > 0) { #table orders,products,dll. $order_id = $products["orders_id"]; $article_number = $products["products_model"]; $order_item_count = $products["order_item_count"]; $order_item_total = $products["order_item_total"]; $order_qty = $products["products_quantity"]; #table orders $orders = $class_orders->retrieveDetail($order_id); $order_no = $orders["orders_no"]; $order_date = strtotime($orders["date_purchased"]); $day = date("d", $order_date); $month = date("M", $order_date); $daily_count = $orders["daily_count"]; #format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel $label_date = $day . ". " . $month; $label_order_seq = $order_item_count . "/" . $order_item_total; $label_cust_name = $orders["delivery_name"]; $qcountry = "SELECT countries_iso_code_2 FROM countries WHERE countries_name = '{$orders['delivery_country']}'"; $dbqcountry = tep_db_query($qcountry); $rescountry = tep_db_fetch_array($dbqcountry); $label_suffix = $rescountry['countries_iso_code_2'] != '' ? ".{$rescountry['countries_iso_code_2']}" : ""; $label_numtag = "JG" . $label_suffix; $label_auftragsnr = $order_no == '' ? "-" : $order_no; $label_lieferscheinnr = ''; $return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name; $return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number . ";" . $order_product_id . ";" . $partner_type; $result = $return_label; } else { $result = "no data"; } break; case 'ean13': if (count($products) > 0) { $result = $this->getEANReturnResult($partner_type, $products); } else { $result = "no data"; } break; } break; case 'sp': $oi = $class_jo->retrieveItemDetail($order_product_id); $order_id = $oi["jng_sp_orders_id"]; $o = $class_jo->retrieveDetail($order_id); $sp_id = $o["jng_sp_id"]; #header("Content-Type: text/plain; charset=utf-8"); switch ($barcode_type) { case 'code39': if (count($oi) > 0) { #table jng_sp_orders_items // $order_qty = $oi["order_quantity"] * 1; $article_number = $oi["article_number"]; $order_item_count = $oi["order_item_count"]; $order_item_total = $oi["order_item_total"]; $order_qty = intval($oi["order_quantity"]); #table jng_sp_orders $order_no = $o["order_id"]; $class_ordersrder_date = strtotime($o["order_date"]); $day = date("d", $class_ordersrder_date); $month = date("M", $class_ordersrder_date); $daily_count = $o["daily_count"]; $shipment_id = $o["shipment_id"]; $cust_fname = $o["customer_shipping_firstname"]; $cust_lname = $o["customer_shipping_lastname"]; #table jng_sp $jngsp = $class_sp->retrieveDetail($sp_id); $prefix_num = $jngsp["package_prefix"]; #format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel $label_date = $day . ". " . $month; $label_order_seq = $order_item_count . "/" . $order_item_total; $label_cust_name = $cust_fname . " " . $cust_lname; $label_numtag = $prefix_num == '' ? "-" : $prefix_num; $label_auftragsnr = $order_no == '' ? "-" : $order_no; $label_lieferscheinnr = $shipment_id; $return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name; $return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number . ";" . $order_product_id . ";" . $partner_type; if (in_array($sp_id, $partners_need_ean13)) { if (count($oi) > 0) { $cats = $class_jo->getCategories($order_id); $oi_product_id = $oi["products_id"]; $oi_product_article_id = $oi["products_articles_id"]; $ean = $oi_product_article_id != '' ? $class_pean->getEAN($oi_product_id, $oi_product_article_id) : $class_pean->getEAN($oi_product_id); if ($ean != '') { $label_material = "925er SILBER"; $return_label .= ";" . $ean . ";" . strtoupper($cats['categories_name']) . ";" . $label_material . ";" . $oi['price'] . " EUR;{$order_qty};{$o['jng_sp_id']}"; } } } $result = $return_label; } else { $result = "no data"; } break; case 'ean13': if (count($oi) > 0) { $result = $this->getEANReturnResult($partner_type, $oi, $sp_id); } else { $result = "no data"; } break; } break; case 'dp': //ONLY PRODUCT LABEL / ean13 $do = $class_do->retrieveDetail($order_product_id); switch ($barcode_type) { case 'code39': $article_number = $do["products_ean"]; $order_item_count = '1'; $order_item_total = '1'; $order_qty = intval($do["quantity"]); $daily_count = $order_qty . 'x'; #format return label >> date;number;orderseq;nametag;kunde;auftragsnr;lieferscheinnr;qty;artikel $label_date = "Quantity: "; $label_order_seq = "{$order_item_count}/{$order_item_total}"; $label_cust_name = 'Outsourcing'; $label_numtag = '-'; $label_auftragsnr = '-'; $label_lieferscheinnr = '-'; $return_label = $label_date . ";" . $daily_count . ";" . $label_order_seq . ";" . $label_numtag . ";" . $label_cust_name; $return_label .= ";" . $label_auftragsnr . ";" . $label_lieferscheinnr . ";" . $order_qty . ";" . $article_number . ";" . $order_product_id . ";" . $partner_type; $result = $return_label; break; case 'ean13': default: if (count($do) > 0) { $do['products_articles_id'] = $do['articles_id']; $result = $this->getEANReturnResult($partner_type, $do); } else { $result = "no data"; } } break; } } else { $result = "no data"; } return $result; }
} else { $statusName = statusNameShort(); $bih_start_date = $do['order_date']; $bih_end_date = null; if ($do['trans_type'] == 'SP') { use_class('jng_sp_orders'); $class_jo = new jng_sp_orders(); $itrans = $class_jo->retrieveItemDetail($do['trans_id']); $otrans = $class_jo->retrieveDetail($itrans['jng_sp_orders_id']); $bih_start_date = $otrans['order_date']; $order_source = $class_do->translateOrderSource($do['trans_type'], $do['trans_id'], false, $itrans['jng_sp_orders_id'], $do['products_id']); } elseif ($do['trans_type'] == 'JG') { use_class('orders'); $class_o = new orders(); $itrans = $class_o->retrieveProductDetail($do['trans_id']); $otrans = $class_o->retrieveDetail($itrans['orders_id']); $bih_start_date = $otrans['date_purchased']; $order_source = $class_do->translateOrderSource($do['trans_type'], $do['trans_id'], false, $itrans['orders_id'], $do['products_id']); } else { $order_source = $class_do->translateOrderSource($do['trans_type'], $do['trans_id'], false, null, $do['products_id']); } $status_date = null; $history = $class_do->retrieveHistory($order_id); $history_prod = retrieveProductionHistory('DP', $order_id); $htable = array(); $ht = array(); $ht['sort'] = 'No'; $ht['date_add'] = 'Date'; $ht['status'] = 'Status'; $ht['login'] = '******'; $htable[] = $ht;