$oi['article_reference_number'] = $i->TB_ID;
$oi['jng_sp_orders_id'] = $orders_id;
$oi['article_number'] = $i->SKU;
$oi['billing_text'] = $i->CHANNEL_SKU;
$oi['order_quantity'] = $i->QUANTITY;
$oi['delivery_time'] = $i->DELIVERY_TIME;
$oi['delivery_replacement_time'] = 'null';
$oi['text'] = 'null';
$oi['price_received'] = !isset($i->TRANSFER_PRICE) || $i->TRANSFER_PRICE == 0 || $i->TRANSFER_PRICE == $i->ITEM_PRICE ? getPurchasePrice($i->ITEM_PRICE, $jng_sp_id) : $i->TRANSFER_PRICE;
$oi['price'] = $i->ITEM_PRICE;
$oi['order_item_count'] = $n_item;
$oi['order_item_total'] = $n_items;
foreach ($oi as $k => $v) {
$oi[$k] = utf8_decode($v);
}
$oi_id = $class_jo->addItem($orders_id, $oi);
logThis(" = ORDER ITEM ID {$oi_id} created");
$items_ids[] = $oi_id;
$items_created++;
}
$class_jo->leadtimeSetStart($leadtime_start_date, '', $orders_id);
} else {
//FAILED TO CREATE NEW ORDER
$existing_order = $class_jo->retrieveDetail(null, $o['order_id']);
$orders_id = $existing_order['jng_sp_orders_id'];
if ($orders_id > 0) {
//ORDER ALREADY EXIST
logThis(" = Existing order found {$orders_id}");
$items = $class_jo->retrieveItems($orders_id);
foreach ($items as $i) {
$items_ids[] = $i['jng_sp_orders_items_id'];
$item['products_ean'] = $product['products_ean'];
if ($product_length > 0) {
$check_query = "SELECT products_articles_id, products_ean FROM products_articles WHERE products_id={$product_id} AND length={$product_length}";
//if($product_text!='') $check_query .= " AND text_code='$product_text'";
$article_check = tep_db_query($check_query);
if (tep_db_num_rows($article_check) > 0) {
$article = tep_db_fetch_array($article_check);
$item['products_articles_id'] = $article['products_articles_id'];
$item['products_ean'] = $article['products_ean'];
}
}
}
foreach ($item as $ik => $iv) {
$item[$ik] = utf8_decode($iv);
}
$item_id = $class_jo->addItem($order_id, $item);
$products_created++;
}
}
$class_jo->leadtimeSetStart($leadtime_start_date, '', $order_id);
$class_jd->addImportedOrder($file['jng_sp_download_id'], $order_id);
$to_name = $order['customer_billing_firstname'] . ' ' . str_replace("}}}", "", str_replace("{{{", "", $order['customer_billing_lastname']));
$to_email_address = $order['customer_billing_email'];
$item_mail = $class_jo->retrieveItems($order_id);
include DIR_WS_EMAILS . $languages[2]['path'] . '/otto.de-orders-confirmation.php';
$from_email_name = FROM_EMAIL_NAME;
$from_email_address = FROM_EMAIL_ADDRESS;
if (!is_null($to_email_address) && $to_email_address != '') {
$sent = tep_mail($to_name, $to_email_address, $email_subject, $email_text, $from_email_name, $from_email_address);
}
}
