CyberStore Documentation
CustomerOrderDisplay.xslt

The following is the default XML transformation file applied to a SORQRY output during Sales Order lookup.

<?xml version="1.0" ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:TBLART="TBLART" xmlns:SALBRN="SALBRN" xmlns:SALARE="SALARE" xmlns:SALSLS="SALSLS">

  <xsl:template match="/">
    <HTML>
      <HEAD>


        <title>
          Order Lookup
        </title>
        <script type="text/javascript" language="javascript" src="../../main/scripts/query.js"></script>
        <script>
          <![CDATA[    
function showvalue(sorder)
{
sor=window.open("salesordervalue.aspx?order=" + sorder + "", "orderwin", "top=100,left=100,height=" + window.screen.availHeight*0.4 + ",width=" + window.screen.availWidth * .5 + ",resizable,scrollbars")
sor.window.focus()
}
]]>
        </script>
      </HEAD>
      <BODY>
        <div class="logoWrapper">
        <div class="divTableCell logo"></div></div>
        <table class="orderdisplayTable"  border="0">
<!--           <tr>
            <td class="orderdisplayTitle" align="center"  colspan="5">
              Order Lookup
            </td>
          </tr> -->
          <tr>
            <td class="orderdisplayLabel"  nowrap="on" width="30%">Order Number:</td>
            <td class="orderdisplayField"  nowrap="on" width="30%">
              <xsl:value-of select="/SorDetail/SalesOrder" />
            </td>
            <td class="orderdisplayField" />
            <td rowspan="7" class="orderdisplayLabel" nowrap="on" valign="top" width="10%">
              Ship To:
            </td>
            <td class="orderdisplayField" nowrap="on"  width="30%">
              <xsl:value-of select="/SorDetail/CustomerName" />
            </td>
          </tr>
          <tr>
            <td class="orderdisplayLabel" nowrap="on">Invoice Terms:</td>
            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="//TBLART:Description" />
            </td>
            <td class="orderdisplayField" nowrap="on">

            </td>
            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShipAddress1" />
            </td>
          </tr>
          <tr>

            <td class="orderdisplayLabel" nowrap="on">Order Date:</td>
            <td class="orderdisplayField" nowrap="on" colspan="2">
              <xsl:value-of select="/SorDetail/OrderDate" />
            </td>

            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShipAddress2" />
            </td>
          </tr>
          <tr>
            <td class="orderdisplayLabel" nowrap="on">Shipping Instructions:</td>
            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShippingInstrs" />
            </td>
            <td></td>
            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShipAddress3" />
            </td>
          </tr>
          <tr>
            <td class="orderdisplayLabel" nowrap="on">Special Instructions:</td>
            <td class="orderdisplayField" nowrap="on" colspan="2">
              <xsl:value-of select="/SorDetail/SpecialInstrs" />
            </td>

            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShipAddress4" />
            </td>
          </tr>
          <tr>
            <td class="orderdisplayLabel" nowrap="on">Customer PO:</td>
            <td class="orderdisplayField" nowrap="on" colspan="2">
              <xsl:value-of select="/SorDetail/CustomerPoNumber" />
            </td>
            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShipAddress5" />
            </td>
          </tr>
          <tr>
            <td class="orderdisplayLabel" nowrap="on">
              Order Status:
            </td>
            <td class="orderdisplayField" nowrap="on" colspan="2">
              <!--(<xsl:value-of select="/SorDetail/OrderStatus" />)&#160;&#160;    -->
              <xsl:choose>
                <xsl:when test="/SorDetail/OrderStatus[. ='0']">
                  In process
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='*']">
                  Cancelled
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='\']">
                  Cancelled
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='1']">
                  Open order
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='2']">
                  On back order
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='3']">
                  Released backorder
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='4']">
                  In warehouse
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='8']">
                  Ready to invoice
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='9']">
                  Complete
                </xsl:when>
                <xsl:when test="/SorDetail/OrderStatus[. ='S']">
                  On hold
                </xsl:when>
                <xsl:otherwise>
                  <xsl:value-of select="/SorDetail/OrderStatus" />
                </xsl:otherwise>
              </xsl:choose>

            </td>
            <td class="orderdisplayField" nowrap="on">
              <xsl:value-of select="/SorDetail/ShipPostalCode" />
            </td>
          </tr>
          <tr>

            <!--                <td class="orderdisplayLabel" valign="top">
                            
                        </td>
                        <td class="orderdisplayField" nowrap="on">
                            
                        </td>
                    </tr>
                    <tr>
                        <td class="orderdisplayLabel" nowrap="on">
                            
                        </td>
                        <td class="orderdisplayField" nowrap="on" colspan="2">                                                
                            
                        </td>
                    
-->
          </tr>
          <tr>

            <!--
                                Display of DETAIL LINES
                        -->
            <td colspan="5">
              <br />
              <table width="100%" align="center" cellpadding="5" cellspacing="0" border="0">

                <tr class="detailhdg2" valign="bottom">
                  <td class="orderdisplaydetailLabel" nowrap="on">
                    Stock Code
                  </td>
                  <td class="orderdisplaydetailLabel">
                    Description
                  </td>
                  <!-- Special column to hold serial/bin hyperlinks 
                                    <td class="orderdisplaydetailLabel" /> 
                  
-->
                  <td class="orderdisplaydetailLabel">
                    Customer Price
                  </td>
                  <td class="orderdisplaydetailLabel">
                    Unit Price
                  </td>
                  <td class="orderdisplaydetailLabel" Title="Unit of Measure"></td>
                  <td class="orderdisplaydetailLabel">Qty</td>
                  <td class="orderdisplaydetailLabel" nowrap="on"></td>
                  <!--                                <td class="orderdisplaydetailLabel">
                                        Warehouse
                                    </td>
-->
                  <td class="orderdisplaydetailLabel">
                    Value
                  </td>
                  <td class="orderdisplaydetailLabel" nowrap="on">
                    Ship Qty
                  </td>
                  <td class="orderdisplaydetailLabel" Title="Back order quantity">
                    B/O Qty
                  </td>
                  <td class="orderdisplaydetailLabel" nowrap="on">
                    Est. Ship Date
                  </td>
                </tr>
                <xsl:for-each select="SorDetail/SalesOrderLine">
                  <tr>
                    <xsl:choose>
                      <xsl:when test="position() mod 2 = 1">
                        <xsl:attribute name="class">TableRow</xsl:attribute>
                      </xsl:when>
                      <xsl:otherwise>
                        <xsl:attribute name="class">HighlightTableRow</xsl:attribute>
                      </xsl:otherwise>
                    </xsl:choose>
                    <!--   
                                            MERCHANDISE LINES
                                        -->
                    <xsl:if test="Merchandise[. !=' ']">
                      <td class="orderdisplaydetailField" nowrap="on">
                        <xsl:if test="Merchandise/MWarehouse[. !='**']">
                          <xsl:value-of select="Merchandise/MStockCode" />
                        </xsl:if>
                        <xsl:if test="Merchandise/MWarehouse[. ='**']">
                          <xsl:value-of select="Merchandise/MStockCode" />
                        </xsl:if>
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on">
                        <xsl:value-of select="Merchandise/MStockDes" />
                      </td>
                      <!-- Special column to hold serial/bin hyperlinks 
                                                <td class="orderdisplaydetailField" nowrap="on">
                                                Serials                                                
                                                <xsl:if test="Merchandise/Lot[. !='']">&#160;                                            
                                                    Lots
                                                </xsl:if>
                                                <xsl:if test="Merchandise/Bin[. !='']">&#160;                                            
                                                    Bins
                                                </xsl:if>
                                            </td>
-->
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="format-number(Merchandise/MPrice,'###,###,###.00')" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="format-number(Merchandise/OrderLineValue div (Merchandise/MBackOrderQty + Merchandise/MShipQty),'###,###,###.00')" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on">
                        <xsl:value-of select="Merchandise/MPriceUom" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="format-number(Merchandise/MOrderQty,'###,###,##0')" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on">
                        <xsl:value-of select="Merchandise/MOrderUom" />
                      </td>
                      <!--                                            <td class="orderdisplaydetailField" nowrap="on">
                                                <xsl:value-of select="Merchandise/MWarehouse" />
                                            </td>
-->
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="format-number(Merchandise/OrderLineValue,'###,###,###.00')" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="format-number(Merchandise/MShipQty,'###,###,##0')" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="format-number(Merchandise/MBackOrderQty,'###,###,##0')" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="center">
                        <xsl:value-of select="Merchandise/MLineShipDate" />
                      </td>
                      <!--
                                                        SERIALS
                                            -->
                      <xsl:if test="Merchandise/Serial[. !='']">
                        <tr style="display:none" id="ser_{generate-id()}">
                          <td colspan="2" />
                          <td colspan="5">
                            <table width="100%" align="left" style="border:thin solid outset">
                              <tr class="detailhdg2">
                                <td class="orderdisplaydetailLabel" nowrap="on">
                                  Serial
                                </td>
                                <td class="orderdisplaydetailLabel" nowrap="on">
                                  Lot
                                </td>
                                <td class="orderdisplaydetailLabel" nowrap="on" align="right">
                                  Qty
                                </td>
                                <td class="orderdisplaydetailLabel" nowrap="on" align="center">
                                  Expiry date
                                </td>
                              </tr>
                              <xsl:for-each select="Merchandise/Serial">
                                <tr>
                                  <td class="subdetail" nowrap="on">
                                    <xsl:value-of select="Serial" />
                                  </td>
                                  <td class="subdetail" nowrap="on">
                                    <xsl:value-of select="Lot" />
                                  </td>
                                  <td class="subdetail" nowrap="on" align="right">
                                    <xsl:value-of select="StockQtyToShip" />
                                  </td>
                                  <td class="subdetail" nowrap="on" align="center">
                                    <xsl:value-of select="NewExpiryDate" />
                                  </td>
                                </tr>
                              </xsl:for-each>
                            </table>
                          </td>
                        </tr>
                      </xsl:if>
                      <!--
                                                        LOTS
                                            -->
                      <xsl:if test="Merchandise/Lot[. !='']">
                        <tr style="display:none" id="lot_{generate-id()}">
                          <td colspan="2" />
                          <td colspan="5">
                            <table width="100%" align="left" style="border:thin solid outset">
                              <tr class="detailhdg2">
                                <td class="detailcell" nowrap="on">

                                  Lot number
                                </td>
                                <td class="detailcell" nowrap="on" align="right">
                                  Qty
                                </td>
                                <td class="detailcell" nowrap="on">
                                  Certificate
                                </td>
                                <td class="detailcell" nowrap="on" align="center">
                                  Expiry date
                                </td>
                              </tr>
                              <xsl:for-each select="Merchandise/Lot">
                                <tr>
                                  <td class="subdetail" nowrap="on">
                                    <xsl:value-of select="Lot" />
                                  </td>
                                  <td class="subdetail" nowrap="on" align="right">
                                    <xsl:value-of select="StockQtyToShip" />
                                  </td>
                                  <td class="subdetail" nowrap="on">
                                    <xsl:value-of select="Certificate" />
                                  </td>
                                  <td class="subdetail" nowrap="on" align="center">
                                    <xsl:value-of select="LotExpiryDate" />
                                  </td>
                                </tr>
                              </xsl:for-each>
                            </table>
                          </td>
                        </tr>
                      </xsl:if>
                      <!--
                                                        BINS
                                            -->
                      <xsl:if test="Merchandise/Bin[. !='']">
                        <tr style="display:none" id="bin_{generate-id()}">
                          <td colspan="2" />
                          <td colspan="5">
                            <table width="100%" align="left" style="border:thin solid outset">
                              <tr class="detailhdg2">
                                <td class="detailcell" nowrap="on">
                                  bin
                                </td>
                                <td class="detailcell" nowrap="on">
                                  Lot number
                                </td>
                                <td class="detailcell" nowrap="on" align="right">
                                  Quantity
                                </td>
                              </tr>
                              <xsl:for-each select="Merchandise/Bin">
                                <tr>
                                  <td class="subdetail" nowrap="on">
                                    <xsl:value-of select="Bin" />
                                  </td>
                                  <td class="subdetail" nowrap="on">
                                    <xsl:value-of select="Lot" />
                                  </td>
                                  <td class="subdetail" nowrap="on" align="right">
                                    <xsl:value-of select="StockQtyToShip" />
                                  </td>
                                </tr>
                              </xsl:for-each>
                            </table>
                          </td>
                        </tr>
                      </xsl:if>
                    </xsl:if>
                    <!-- 
                                                FREIGHT LINES 
                                        -->
                    <xsl:if test="Freight[. !=' ']">
                      <td class="orderdisplaydetailField" nowrap="on" style="text-indent:10px">
                        {Freight}
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" colspan="7">
                        <xsl:value-of select="Freight/NComment" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="Freight/NMscChargeValue" />
                      </td>
                      <td>
                      </td>


                    </xsl:if>
                    <!-- 
                                                MISC CHARGE LINES
                                        -->
                    <xsl:if test="MiscCharge[. !=' ']">
                      <td class="orderdisplaydetailField" nowrap="on" style="text-indent:10px">
                        {Misc charge}
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" colspan="7">
                        <xsl:value-of select="MiscCharge/NComment" />
                      </td>
                      <td class="orderdisplaydetailField" nowrap="on" align="right">
                        <xsl:value-of select="MiscCharge/NMscChargeValue" />
                      </td>

                    </xsl:if>
                    <!-- 
                                                COMMENT LINES 
                                        -->
                    <xsl:if test="CommentLine[. !=' ']">
                      <td class="orderdisplaydetailField" colspan="10" style="text-indent:10px">
                        <xsl:value-of select="CommentLine/NComment" />
                      </td>
                    </xsl:if>
                  </tr>
                </xsl:for-each>
              </table>
            </td>
          </tr>
        </table>
      </BODY>
    </HTML>
  </xsl:template>
</xsl:stylesheet>