/**
* 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;
