#set($backorders = $mediaarchive.query("storeorderhistory").exact("source", $data.getId()).exact("action", "backorder").search())

#if(!$backorders.isEmpty())
    <table class="table  table-striped">
        <thead>
            <tr>
                <th >Moved Items</th>
                <th >Quantity</th>
                <th >Moved To</th>
                <th >New Order Date</th>
            </tr>
        </thead>
        <tbody>
            #foreach($item in $backorders)
                #set($product = $mediaarchive.getSearcher("product").searchById($item.get("product")))
                <tr>
                    <td >$product.name</td>
                    <td >$item.get("quantity")</td>
                    <td >
                        #set($destinationOrderId = $item.get("destination"))
                        <a href="$apphome/manage/orders/?invoiceid=$destinationOrderId" target="_blank">
                            $destinationOrderId
                        </a>
                    </td>
                    #set($destinationOrder = $mediaarchive.getSearcher("storeOrder").searchById($destinationOrderId))
                    <td >$destinationOrder.get("shippingdate")</td>
                </tr>
            #end
        </tbody>
    </table>
#end

#set($shortitems = $mediaarchive.query("storeorderhistory").exact("source", $data.getId()).exact("action", "short").search())

#if(!$shortitems.isEmpty())
    <table class="table  table-striped" style="margin-top: 20px;">
        <thead>
            <tr>
                <th >Shorted Items</th>
                <th >Quantity</th>
            </tr>
        </thead>
        <tbody>
            #foreach($item in $shortitems)
                #set($product = $mediaarchive.getSearcher("product").searchById($item.get("product")))
                <tr>
                    <td >$product.name</td>
                    <td >$item.get("quantity")</td>
                </tr>
            #end
        </tbody>
    </table>
#end