Magento – Get shipment collection from order id

magento2sales-ordershipment

Normally you can get order shipment colletion like this from order:

$order->getShipmentsCollection();

but i'd like to retrieve the collection of shipments using order id, and i want to sort it by entity_id, so it will become like this:

$shipmentCollections = $this->shipmentModel->create()
                    ->getCollection()->addFieldToFilter("order_id",$orderId)->setOrder('entity_id','DESC');

Best Answer

To get shipments by order ID you can use \Magento\Sales\Model\ResourceModel\Order\Shipment\CollectionFactory:

protected $_shipmentCollection;

public function __construct(
    \Magento\Sales\Model\ResourceModel\Order\Shipment\CollectionFactory $shipmentCollection,
) {
    $this->_shipmentCollection = $shipmentCollection;
}

public function getShipmentsByOrderId($order_id) {
    $shipments = $this->_shipmentCollection->create()->addFieldToFilter('order_id', $order_id)->setOrder('entity_id', 'DESC');

    // Use $shipment->getItems() to iterate over results
}

Related Solutions

How to Generate Invoice Automatically When Creating Shipment in Magento

I'd go the route of creating an event-observer for sales_order_shipment_save_after:

So in app/code/local/Namespace/Module/etc/config.xml:

...
<events>
    <sales_order_shipment_save_after>
    <observers>
        <namespace_module>
        <type>singleton</type>
        <class>Namespace_Module_Model_Observer</class>
        <method>autoInvoice</method>
        </namespace_module>
    </observers>
    </sales_order_shipment_save_after>
</events>
....

and in app/code/local/Namespace/Module/Model/Observer.php:

<?php
class Namespace_Module_Model_Observer
{
   public function autoInvoice($observer) {
       $shipment = $observer->getEvent()->getShipment();
       $order = $shipment->getOrder();
       if($order->canInvoice())
       {
           $invoice = Mage::getModel('sales/service_order', $order)->prepareInvoice();
           $invoice->setRequestedCaptureCase(Mage_Sales_Model_Order_Invoice::CAPTURE_ONLINE);
           $invoice->register();
           $transactionSave = Mage::getModel('core/resource_transaction')
           ->addObject($invoice)
           ->addObject($invoice->getOrder());
           $transactionSave->save();
       }
   }
}

Then you should be all set.

Magento – Programatically add tracking to shipment – Mage_Api_Model_Resource_Abstract->_fault(‘not_exists’)

I've been trying to solve this via models with so many variation and none of them are working. I am quite tired with this approach, so I have solved it using direct SQL like this:

// Add Shipment Tracking Number If Available
if (!empty($order_info->TrackingNumber))
{
    // Get db resources
    $resource = Mage::getSingleton('core/resource');
    $writeConnection = $resource->getConnection('core_write');
    $shipmentTrackTable = $resource->getTableName('sales_flat_shipment_track');

    // Insert tracking manually
    $writeConnection->query(
        "INSERT INTO `$shipmentTrackTable` (`parent_id`, `order_id`, `track_number`, `title`, `carrier_code`, `created_at`, `updated_at`) 
         VALUES (:parent_id, :order_id, :track_number, :title, 'custom', :created_at, :updated_at)",
        array(
            'parent_id'    => $shipment->getId(),
            'order_id'     => $order->getId(),
            'track_number' => $order_info->TrackingNumber,
            'title'        => 'My Module Name',
            'created_at'   => now(),
            'updated_at'   => now(),
        ));
}

This works.

Best Answer

Related Solutions

How to Generate Invoice Automatically When Creating Shipment in Magento

Magento – Programatically add tracking to shipment – Mage_Api_Model_Resource_Abstract->_fault(‘not_exists’)

Related Topic