PHP orders::retrieveProducts方法代码示例

$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
    $xpos = $xpos_starter;

require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('orders');
$class_o = new orders();
use_class("minierp_invoices");
$class_mi = new minierp_invoices();
$package_id = 0;
//ORDERS_ID
$orders_id = '6460';
//ORDERS_PRODUCTS_ID (do not add canceled products)
$orders_products_id = array('11857');
$order_data = $class_o->retrieveDetail($orders_id);
$products_in_orders = $class_o->retrieveProducts($orders_id);
$products = array();
foreach ($products_in_orders as $key => $pio) {
    if (in_array($pio['orders_products_id'], $orders_products_id)) {
        $products[$key] = $pio;
    }
}
$totals = $class_o->retrieveTotals($orders_id);
if (is_array($order_data) && is_array($products) && is_array($totals)) {
    if (count($order_data) > 0 && count($products) > 0 && count($totals) > 0) {
        $existing_invoices = $class_mi->retrieveInvoicesByOrder($orders_id);
        $firstinvoice = count($existing_invoices) == 0;
        $new_invoice_id = $class_mi->generateNew($package_id, $order_data, $products, $totals, $firstinvoice);
        $class_mi->setInvoiceComplete($orders_id);
    }
}

 } 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) {
                 //If order only consist of 1 product
                 $packages = $class_mp->getUsablePackages();
                 if (count($packages) == 0) {
                     //If no usable package found for JNG, create 1

         $result['class'] = 'paid';
         $result['status'] = 'ORDER PAID';
     } else {
         $result['class'] = 'unpaid';
         $result['status'] = 'ORDER UNPAID';
     }
     ajaxReturn($result);
     exit;
 } elseif ($_POST['me_action'] == 'REVIVEORDER') {
     $result = '';
     $order_id = tep_db_prepare_input($_POST['order_id']);
     $order = $class_o->retrieveDetail($order_id);
     if ($order['paid_status'] != '1') {
         $result = '<h3 class="red">REVIVE FAILED!</h3><div>Order is still <strong>UNPAID</strong></div>';
     } else {
         $products = $class_o->retrieveProducts($order_id);
         if ($order['dti_referrers_id_commission'] != '0') {
             use_class('dti', DIR_WS_CLASSES);
             $class_dti = new dti();
             $any_deletion_failed = false;
             foreach ($products as $key => $p) {
                 $opid = $p['orders_products_id'];
                 $deleted = $class_dti->deleteCommissionCancel($opid);
                 if (!$deleted) {
                     unset($products[$key]);
                     $any_deletion_failed = true;
                 }
             }
         }
         if (count($products) == 0) {
             $result = '<h3 class="red">REVIVE FAILED!</h3><div>ALL Commissions cancellation are already reported to Partner</div>';

         $result['op_id'] = $opid;
         $result['old_status'] = $old_status;
         $result['new_status'] = $product['status'];
         $result['msg_sukses'] = '';
         $result['msg_errors'] = oiErrorStatus($opid, $product['status'], $old_status);
     }
     ajaxReturn($result);
     exit;
 } elseif ($_POST['me_action'] == 'REMINDERVORKASSEUNPAID') {
     $opid = tep_db_prepare_input($_POST['op_id']);
     $status = tep_db_prepare_input($_POST['op_status']);
     $is2nd_reminder = tep_db_prepare_input($_POST['is2nd_reminder']);
     $useAltContent = $is2nd_reminder == '1';
     $product = $class_o->retrieveProductDetail($opid);
     if ($product['status'] == $status) {
         $products = $class_o->retrieveProducts($product['orders_id']);
         $opids = array();
         foreach ($products as $p) {
             $opids[] = $p['orders_products_id'];
         }
         $class_o->sendProductStatusNotification($opids, $status, $languages[2]['path'], $useAltContent);
         $result = array();
         $result['op_id'] = implode(',', $opids);
         ajaxReturn($result);
     }
     exit;
 } elseif ($_POST['me_action'] == 'VORKASSEUNPAIDCANCEL') {
     $opid = tep_db_prepare_input($_POST['op_id']);
     $old_status = tep_db_prepare_input($_POST['op_status']);
     $new_status = '12';
     $useAltContent = true;

//Invoice of vorkasse order has 1 month due date
$prepayment_due_date = '+1 month';
//CREATE INVOICE FOR JNG VORKASSE
//TODO: ADD DATE FILTER, NO NEED TO QUERY ALL ORDERS
$logger->write("CREATING J&G INVOICES");
$query = "SELECT o.orders_id FROM orders o\n        LEFT JOIN payone_invoice pi ON pi.invoice_order_type='J' AND pi.invoice_order_id=o.orders_id\n        WHERE pi.invoice_id IS NULL AND o.payment_method = '{$payment_method_vorkasse}'\n        AND o.orders_id>{$cut_off_orders_id}";
$q = tep_db_query($query);
$orders_array = array();
while ($row = tep_db_fetch_array($q)) {
    $orders_array[] = $row['orders_id'];
}
if (count($orders_array) > 0) {
    foreach ($orders_array as $order_id) {
        $pi_create_counter['jg']++;
        $order = $class_o->retrieveDetail($order_id, true);
        $items = $class_o->retrieveProducts($order_id, true);
        foreach ($items as $key => $item) {
            if ($class_jo->statusIsCancelled($item['status'])) {
                unset($items[$key]);
                break 1;
            }
        }
        //echo "<pre>";var_dump($order);die();
        //Order Items
        //DISABLED THIS => PAYONE INVOICE WILL BE CREATED FOR ALL VORKASSE, EVENTHOUGH ALL ITEMS ARE CANCELLED
        //if(count($items)>0) {
        //PREPARE INVOICE DATA//
        //echo "<pre>";var_dump($items);die();
        $payi->createFromOrderJNG($order, $items, $prepayment_due_date, '0', '0');
        if (tep_db_insert_id() != '') {
            $l_invoice_id = tep_db_insert_id();