PHP orders::updateProductStatus方法代码示例

             $class_jo = new jng_sp_orders();
             foreach ($pack as $p) {
                 $items = $class_jp->sendPackage($p['packages_id']);
                 foreach ($items as $items_id) {
                     $class_jo->updateItemStatus($items_id, '7', $session_userinfo['username']);
                 }
             }
         } elseif ($type == 'J') {
             use_class('minierp_packages');
             $class_mp = new minierp_packages();
             use_class('orders');
             $class_o = new orders();
             foreach ($pack as $p) {
                 $items = $class_mp->sendPackage($p['packages_id']);
                 foreach ($items as $items_id) {
                     $class_o->updateProductStatus($items_id, '7', $session_userinfo['username']);
                 }
             }
         } else {
             use_class('depot_orders');
             $class_do = new depot_orders();
             foreach ($pack as $p) {
                 $class_do->packageSetSent($p['packages_id'], $session_userinfo['username']);
             }
         }
     }
     echo utf8_encode($logistic_id);
 } elseif ($_POST['me_action'] == 'SAVELOG') {
     use_class('products_minierp');
     $class_pm = new products_minierp();
     $bgst = $class_pm->retrieveBestGoodSettings();

         $logger->write('sent first reminder ' . $logger_oid);
     }
 } elseif ($o['sent_count'] == '1') {
     //Cancel Notification (orders are not canceled yet at this step)
     if ($need_resend) {
         $order->sendPrepaymentAutoCancelNotification();
         $logger->write('sent cancel notification ' . $logger_oid);
     }
 } elseif ($o['sent_count'] == '2') {
     //Cancel order and invoice
     if ($last_sent_date_timestamp < strtotime('-' . $tolerance_before_really_cancelling_orders)) {
         //default cancel status
         if ($o['order_type'] == Order::ORDER_TYPE_JULIE_GRACE) {
             $status = '12';
             foreach ($items_id as $item_id) {
                 $class_o->updateProductStatus($item_id, $status, 'auto-set');
             }
         } elseif ($o['order_type'] == Order::ORDER_TYPE_SALES_PARTNER) {
             $status = '10';
             foreach ($items_id as $item_id) {
                 $class_jo->updateItemStatus($item_id, $status, 'auto-set');
             }
         }
         $logger->write('canceled ' . $logger_oid);
         if (count($invoice->detail) > 0) {
             //status 3 = INVOICE CANCELED
             $invoice->updateCompleteStatus('3');
             $logger->write('canceled invoice ' . $invoice->detail['invoice_id']);
         }
     }
 }

         //Handle update special production sub status like :
         //4-P   (Pullrack),
         //4-S7  (Solder Setting Line 7),
         //4-A   (Ampol & QC),
         //4-L   (Laboratory)
         $status_new_tmp = explode('-', $status_new);
         $sub_status = $status_new_tmp[1];
         if ($status_current != '4' && $status_current != '3') {
             $result['status'] = 'BADSTATUS';
             $result['result_msg'] = oiErrorStatus($status_current);
         } elseif ($item['prod_status'] == $sub_status) {
             $result['status'] = 'BADSTATUS';
             $result['result_msg'] = oiErrorStatus($item['prod_status']);
         } else {
             $result['status'] = 'UPDATED';
             $class_o->updateProductStatus($item_id, $status_new, $user_name);
         }
     } else {
         //Handle update status
         $result['status'] = 'UPDATED';
         $class_o->updateProductStatus($item_id, $status_new, $user_name);
         if ($status_current == '4' && $status_new == '5' && $item['prod_status'] != '') {
             tep_db_perform('orders_products', array('prod_status' => ''), 'update', "orders_products_id='{$item_id}'");
         }
         if ($status_current == '4' && $status_new == '5' && $at_machine > 0) {
             //IF PRODUCT IS FINISH, ALSO SET ANTITARNISH USAGE FOR NON OXIDIZED PRODUCTS
             $silver_usage = $class_o->calcSilverUsage($item_id);
             antitarnishUsageAdd($at_machine, $silver_usage);
         }
     }
 }

         $items_mmo[] = $oiid;
     } elseif ($oi['mode'] == modeKey('MTO')) {
         $items_mto[] = $oiid;
     }
 } elseif ($oi['is_outsourced']) {
     //Handle orders for outsourced products with no stock
     if ($oi['status'] == '8' && $oi['shipping_window_is_opened']) {
         //no stock and shipping windows is already opened
         if ($oi['order_item_total'] == 1) {
             //SET AS MTO IF SINGLE PRODUCT ORDER
             //stop waiting and move products back to New to become MTO
             $items_mto[] = $oiid;
             if ($order_type == 'SP') {
                 $class_jo->updateItemStatus($oiid, '1', 'auto-set');
             } elseif ($order_type == 'JG') {
                 $class_o->updateProductStatus($oiid, '1', 'auto-set');
             }
         } else {
             $items_mmo[] = $oiid;
             $item_do = $class_do->transferFromRealOrder(SEGMENT_ID_HAMBURG, $order_type, $oiid);
         }
     } else {
         //keep waiting if shipping window is not yet opened
         //check if product is not yet moved to Depot/Mixed
         if ($oi['status'] != '8') {
             //set order as DSO and move items to Depot/Mixed
             $items_dso[] = $oiid;
             if ($order_type == 'SP') {
                 $class_jo->updateItemStatus($oiid, '8', 'auto-set');
             } elseif ($order_type == 'JG') {
                 $class_o->updateProductStatus($oiid, '8', 'auto-set');

$idcr = explode('|', $_POST['idcode_ret']);
$update_counter = array();
foreach ($reference as $i => $ref) {
    $shipment_id = $ref;
    $shipment_date = $date[$i];
    $cancel_status = $cancel[$i];
    $idcode_ship = $idcs[$i];
    $idcode_ret = $idcr[$i];
    if ($shipment_id != '') {
        if (substr($ref, 0, 2) == 'JG') {
            $order_id = substr($ref, 2);
            $idcounter = 'JG' . $order_id;
            $items = $class_o->retrieveProducts($order_id);
            foreach ($items as $item) {
                if ($item['status'] == $REQUIRED_STATUS) {
                    $class_o->updateProductStatus($item['orders_products_id'], $UPDATED_STATUS, $username);
                }
                if ($item['status'] == $REQUIRED_STATUS || $item['status'] == $UPDATED_STATUS) {
                    $update_counter[] = $idcounter;
                }
            }
        } else {
            $items = $class_jo->retrieveItems($shipment_id, true);
            $idcounter = 'SP' . $shipment_id;
            foreach ($items as $item) {
                if ($item['status'] == $REQUIRED_STATUS) {
                    $osda = array('shipment_date' => $shipment_date, 'idcode_ship' => $idcode_ship, 'idcode_ret' => $idcode_ret);
                    tep_db_perform('jng_sp_orders', $osda, 'update', "shipment_id='{$shipment_id}'");
                    $class_jo->updateItemStatus($item['jng_sp_orders_items_id'], $UPDATED_STATUS, $username);
                }
                if ($item['status'] == $REQUIRED_STATUS || $item['status'] == $UPDATED_STATUS) {

             $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>';
         } else {
             foreach ($products as $p) {
                 $opid = $p['orders_products_id'];
                 $class_o->updateProductStatus($opid, '1', $session_userinfo['username']);
             }
             $comment = 'Order is revived due to late payment';
             $class_o->updateOrderStatus($order_id, '1', $comment);
             $result = '<h3 class="green">REVIVE Successfully!</h3><div><a href="">Click here to refresh Order detail and view changes</a></div>';
             if ($any_deletion_failed) {
                 $result .= '<div class="red">However, some Commissions cancellation are already reported to Partner, this products is not reviveable.</div>';
             }
         }
     }
     echo utf8_encode($result);
     exit;
 } elseif ($_POST['me_action'] == 'UPDATECUSTOMERSPECIALLIST') {
     $customers_id = tep_db_prepare_input($_POST['customers_id']);
     $status = tep_db_prepare_input($_POST['status']);
     $class_csl->addCustomer($status, $customers_id);

         $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
         $package_id = $class_mp->createNew();
     } else {
         //If usable package found fo JNG, use it
         $package_id = $packages[0]['packages_id'];
     }
     //Add product to package and update product status
     $class_mp->addItem($package_id, $id);
     $class_o->updateProductStatus($id, $new_status, $session_userinfo['username']);
     $result .= printPackageTip('P', $box_date, '', $sp_name, $sp_class);
     saveIDforPrintingOrderLabel($id_raw);
     $result .= '<input type="hidden" id="print_order_id" value="' . $id_raw . '" />';
 } else {
     //If order has more than 1 product, check if all products status are finish
     $orders_ready = true;
     $cancelids = array();
     foreach ($items as $i) {
         if ($i['status'] != $old_status) {
             $orders_ready = false;
         }
     }
     if ($orders_ready) {
         //If all products status are finish, request barcode entry of other products
         $inwb = array();

     //        $thumbid = tep_db_prepare_input($_POST['thumbid']);
     //        list($pid, $article_id) = split('-', $thumbid);
     //        $tooltip_data = getTooltipThumbData($pid, $article_id);
     //        $tooltip = displayTooltipThumb($tooltip_data);
     //        $result = array();
     //        $result['tooltip'] = $tooltip;
     //        ajaxReturn($result);
     //        exit;
 } elseif ($_POST['me_action'] == 'UPDATEOPSTATUS') {
     $opid = tep_db_prepare_input($_POST['op_id']);
     $old_status = tep_db_prepare_input($_POST['old_status']);
     $new_status = tep_db_prepare_input($_POST['new_status']);
     $product = $class_o->retrieveProductDetail($opid);
     if ($product['status'] == $old_status) {
         $status_to_alert_success = array('3', '4');
         $class_o->updateProductStatus($opid, $new_status, $session_userinfo['username']);
         if ($new_status == '5' || $new_status == '10' || $new_status == '1' && $old_status == '10') {
             //set order waxing as new/finish/cancel following order product status
             use_class('orders_waxing');
             $class_ow = new orders_waxing();
             $ow_data = $class_ow->retrieveByOrderProducts($opid);
             $ow_status = $new_status == '10' ? '6' : $new_status;
             if (count($ow_data) > 0) {
                 foreach ($ow_data as $ow) {
                     $waxing_id = $ow['orders_waxing_id'];
                     $class_ow->updateStatus($waxing_id, $ow_status, $session_userinfo['username']);
                 }
             }
         }
         list($new_status, $sub_status) = explode('-', $new_status);
         $status_name = $sub_status != '' ? subStatusNameShort($new_status, $sub_status) : $class_o->productStatusNameShort();

        echo implode(",", $success);
    }
}
if (isset($_GET['type']) && isset($_GET['orders_id']) && isset($_GET['old_status']) && isset($_GET['new_status'])) {
    $type = strtoupper($_GET['type']);
    $orders_id = tep_db_prepare_input($_GET['orders_id']);
    $old_status = tep_db_prepare_input($_GET['old_status']);
    $new_status = tep_db_prepare_input($_GET['new_status']);
    $updater = 'manual';
    if ($type == 'JG') {
        use_class('orders');
        $class_o = new orders();
        $items = $class_o->retrieveProducts($orders_id);
        foreach ($items as $i) {
            if ($i['status'] == $old_status) {
                $class_o->updateProductStatus($i['orders_products_id'], $new_status, $updater);
            }
        }
        echo '<pre>';
        var_dump($_GET);
        echo '</pre>';
        echo '<br />';
        echo '<br />';
        echo 'UPDATED!';
    } elseif ($type == 'SP') {
        $allowed_sp_id = array('6');
        use_class('jng_sp_orders');
        $class_jo = new jng_sp_orders();
        $order = $class_jo->retrieveDetail($orders_id);
        if (in_array($order['jng_sp_id'], $allowed_sp_id)) {
            $items = $class_jo->retrieveItems($orders_id);

 $result['IDCODE_SHIP'] = $idcode_ship;
 $result['IDCODE_RET'] = $idcode_ret;
 if ($SIMULATION) {
     $result['STATUS'] = 'SIM';
 } else {
     $updated = false;
     if (substr($shipment_id, 0, 2) == 'JG') {
         $order_id = substr($shipment_id, 2);
         $items = $class_o->retrieveProducts($order_id);
         if (count($items) > 0) {
             $updated = true;
             $osda = array('idcode_ship' => $idcode_ship, 'idcode_ret' => $idcode_ret);
             tep_db_perform('orders', $osda, 'update', "orders_id='{$order_id}'");
             foreach ($items as $item) {
                 if (in_array($item['status'], $REQUIRED_STATUS)) {
                     $class_o->updateProductStatus($item['orders_products_id'], $UPDATED_STATUS, 'auto-set');
                 }
             }
         }
     } else {
         $items = $class_jo->retrieveItems($shipment_id, true);
         if (count($items) > 0) {
             $updated = true;
             $osda = array('shipment_date' => $shipment_date, 'idcode_ship' => $idcode_ship, 'idcode_ret' => $idcode_ret);
             tep_db_perform('jng_sp_orders', $osda, 'update', "shipment_id='{$shipment_id}'");
             foreach ($items as $item) {
                 if (in_array($item['status'], $REQUIRED_STATUS)) {
                     $class_jo->updateItemStatus($item['jng_sp_orders_items_id'], $UPDATED_STATUS, 'auto-set');
                 }
             }
         }

} else {
    $logger->write("There are {$items_total} items need to be confirmed");
    //Group Items per Order
    $orders_cancelled = array();
    foreach ($items as $i) {
        if (!isset($orders_cancelled[$i['orders_id']])) {
            $orders_cancelled[$i['orders_id']] = array();
        }
        $orders_cancelled[$i['orders_id']][] = $i['orders_products_id'];
    }
    $orders_total = count($orders_cancelled);
    $logger->write("Total orders are {$orders_total}, processing per order:");
    foreach ($orders_cancelled as $oid => $opid_array) {
        $logger->write("> Order ID {$oid}");
        foreach ($opid_array as $opid) {
            $class_o->updateProductStatus($opid, $cancel_status_confirmed, 'auto-set');
            $logger->write("  JG-{$opid} updated to {$cancel_status_name}");
        }
        $order = new Order(Order::ORDER_TYPE_JULIE_GRACE, $oid);
        $sent = $order->sendCancelNotification();
        if ($sent) {
            $logger->write('  Notification sent');
        }
    }
}
//SP CONFIRM ORDERS DELIVERY AND CANCELLATION
$logger->write('- Confirm delivery & cancel status to SP');
$data = array();
foreach ($sp_data as $jng_sp_id => $sp) {
    $data[$jng_sp_id] = $class_jo->getUnconfirmedDelivery($jng_sp_id);
}

 function removeFromPackage($logistic_id, $logistic_partner, $barcode_id, $new_status, $updated_by = '')
 {
     global $session_userinfo;
     if ($updated_by == '') {
         $updated_by = $session_userinfo['username'];
     }
     $tmp_bcid = explode('-', $barcode_id);
     $type = strtoupper($tmp_bcid[0]);
     $oiid = $tmp_bcid[1];
     $table_name = '';
     if ($type == 'SP') {
         $table_name = 'jng_sp_packages_items';
         $field = 'jng_sp_orders_items_id';
     } elseif ($type == 'JG') {
         $table_name = 'minierp_packages_products';
         $field = 'orders_products_id';
     } elseif ($type == 'DP') {
         $table_name = 'depot_packages_contents';
         $field = 'depot_orders_id';
     }
     $result = '<span>Order <strong>"' . $barcode_id . '"</strong> not found on any packages!</span>';
     if ($table_name != '') {
         $q_check = tep_db_query("SELECT * FROM {$table_name} WHERE {$field} = '{$oiid}'");
         if (tep_db_num_rows($q_check) > 0) {
             tep_db_query("DELETE FROM {$table_name} WHERE {$field} = '{$oiid}'");
             //SAVE AS HISTORY
             $dt_hist = array();
             $dt_hist['type'] = $type;
             $dt_hist['order_items_id'] = $oiid;
             $dt_hist['removed_by'] = $updated_by;
             $dt_hist['updated_to_status'] = $new_status;
             tep_db_perform('minierp_packages_orders_excluded', $dt_hist);
             if ($type == 'SP') {
                 use_class('jng_sp_orders');
                 $class_jo = new jng_sp_orders();
                 $class_jo->updateItemStatus($oiid, $new_status, $updated_by, 'J', false);
             } elseif ($type == 'JG') {
                 use_class('orders');
                 $class_o = new orders();
                 $class_o->updateProductStatus($oiid, $new_status, $updated_by, 'J', false);
             } elseif ($type == 'DP') {
                 use_class('depot_orders');
                 $class_do = new depot_orders();
                 $class_do->updateStatus($oiid, $new_status, $updated_by, false);
             }
             //REGENERATE LIST OF CONTENTS ON CERTAIN LOGISTIC PACKAGE
             $this->generateContents($logistic_id, $logistic_partner);
             $result = '<span class="green">Order <strong>"' . $barcode_id . '"</strong> successfully removed from package and set its status as complete!';
             $result .= '<br/><br/><strong>PLEASE REPRINT updated Commercial Invoice for logistic process!</span></strong>';
         }
     }
     return $result;
 }