tessguefen
4/1/2015 - 9:11 PM

Example CSV File.

Example CSV File.

Header | Value
Content-Type | application/csv
Content-Dispostion | attachment;filename=yourfilenamehere.csv
<mvt:item name="toolkit" param="mvassign|comma|asciichar('44')" />
<mvt:assign name="spacer" value="'' $ g.comma $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $  asciichar('10')" />
<mvt:assign name="totalChicken" value="0" />
<mvt:assign name="totalBeef" value="0" />
<mvt:assign name="totalTurkey" value="0" />
<mvt:item name="toolkit" param="mvassign|headerRow|'Order Date' $ g.comma $ 'Order ID' $ g.comma $ 'Last Name' $ g.comma $ 'Product' $ g.comma $ 'Quantity' $ asciichar('10')" />
&mvt:global:headerRow;
<mvt:foreach iterator="order" array="admin_order:orders">
    <mvt:assign name="currentNum" value="1" />
    <mvt:item name="customfields" param="Read_Order( l.settings:order:id, 'free_turkey', l.settings:free_turkey )" />
    <mvt:item name="toolkit" param="mvassign|orderRow|l.all_settings:order:date $ g.comma $ l.all_settings:order:id $ g.comma $ l.all_settings:order:ship_lname $ g.comma" />
    <mvt:foreach iterator="item" array="order:items">
        <mvt:comment> === Counting === </mvt:comment>
        <mvt:if expr="l.settings:item:code EQ 'chicken'">
            <mvt:assign name="totalChicken" value="g.totalChicken + l.settings:item:quantity" />
        <mvt:elseif expr="l.settings:item:code EQ 'beef'">
            <mvt:assign name="totalBeef" value="g.totalChicken + l.settings:item:quantity" />
        <mvt:elseif expr="l.settings:item:code EQ 'turkey'">
            <mvt:assign name="totalTurkey" value="g.totalTurkey + l.settings:item:quantity" />
        <mvt:elseif expr="l.settings:item:code EQ 'sample-pack'">
            <mvt:assign name="totalChicken" value="g.totalChicken + l.settings:item:quantity" />
            <mvt:assign name="totalBeef" value="g.totalChicken + l.settings:item:quantity" />
        </mvt:if>
        <mvt:comment> === Counting === </mvt:comment>
            
        <mvt:if expr="g.currentNum EQ '1'">
            <mvt:item name="toolkit" param="mvassign|orderRow|g.orderRow $ l.all_settings:item:name $ g.comma $ l.all_settings:item:quantity $ asciichar('10')" />
        <mvt:else>
            <mvt:item name="toolkit" param="mvassign|orderRow|g.orderRow $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ l.all_settings:item:name $ g.comma $ l.all_settings:item:quantity $ asciichar('10')" />
        </mvt:if>
        <mvt:assign name="currentNum" value="g.currentNum + 1" />
    </mvt:foreach>
    <mvt:if expr="l.settings:free_turkey EQ 'yes'">
        <mvt:item name="toolkit" param="mvassign|orderRow|g.orderRow $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ 'FREE Turkey' $ g.comma $ '1' $ asciichar('10')" />
        <mvt:assign name="totalTurkey" value="g.totalTurkey + 1" />
    </mvt:if>
    &mvt:global:orderRow;
</mvt:foreach>
&mvt:global:spacer;
<mvt:assign name="totals" value="'' $ g.comma $ '' $ g.comma $ '' $ g.comma $'Total Chicken' $ g.comma $ g.totalChicken $ asciichar('10')" />
<mvt:assign name="totals" value="g.totals $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ 'Total Beef' $ g.comma $ g.totalBeef $ asciichar('10')" />
<mvt:assign name="totals" value="g.totals $ '' $ g.comma $ '' $ g.comma $ '' $ g.comma $ 'Total Turkey' $ g.comma $ g.totalTurkey $ asciichar('10')" />
&mvt:global:totals;