<MCX_CONNECT_SERVER maxxprod>
<MCX_QUERY select left(REPLACE(Order_Status, 'O', 'Q'), 1), FORMAT(SUM((ABS(QUANTITY)*UNIT_COST)), 2) AS TOTAL, SHIPPING, Ship_City, Ship_State from DETAIL,HEADER WHERE DETAIL.ORDER_NUMBER = HEADER.ORDER_NUMBER AND HEADER.ORDER_NUMBER = '<MCX_ENV ONUM>' AND PQ_SENT_TO_GOOGLE = 'N'>
   _gaq.push(['_addTrans',
      '<MCX_ENV ONUM>-<MCX_RESULT STATUS>',
      'Estate Millwork', 
      '<MCX_RESULT TOTAL>',
      '0.00',
      '<MCX_RESULT SHIPPING>',
      '<MCX_RESULT City>',
      '<MCX_RESULT Ship_State>',
      'None'
    ]);
<MCX_END_QUERY>

<MCX_QUERY 
	select sku, replace(description, "'", ""), replace(design_string, '+', ' '), design_string, left(replace(Order_Status, 'O', 'Q'), 1) as OrderStatus, list_price, abs(quantity) 
	from DETAIL A join HEADER B on A.ORDER_NUMBER=B.ORDER_NUMBER where A.ORDER_NUMBER = '<MCX_ENV ONUM>'
>

    thisItem = '<MCX_RESULT sku>';
    thisDesc = '<MCX_RESULT description>';
    thisCat = 'OTHER';

    <MCX_PASTEIF -CN>
      thisDesc = '<MCX_EXEC /usr6/htdocs/estatemillwork.com/fixpanelnewslines.sh -DESCONLY 1 -ON <MCX_ENV ONUM> <MCX_RESULT REPLACE(design_string, '+', ' ')>>';
      thisItem = '<MCX_RESULT design_string>';
      thisItem = thisItem.replace(/\+/g, "_").replace(/\-/g, "");
    <MCX_ENDPASTEIF>

    <MCX_PASTEIF Prime>
      //<MCX_RESULT description>
      thisItem = "priming";
    <MCX_ENDPASTEIF>

    if(thisDesc.match(/SHUTTER/)) thisCat = 'SHUTTER';
    else if(thisDesc.match(/CABINET/)) thisCat = 'CABINET';
    else if(thisDesc.match(/DOOR/)) thisCat = 'DOOR';
    else if(thisDesc.match(/Moulding/)) thisCat = 'MOULDING';
    else if(thisDesc.match(/Prime/)) thisCat = 'PRIMING';
    else if(thisDesc.match(/SKU/)) thisCat = 'HARDWARE';

    _gaq.push(['_addItem',
      '<MCX_ENV ONUM>-<MCX_RESULT OrderStatus>',
      thisItem,
      thisDesc,
      thisCat,
      '<MCX_RESULT list_price>',
      '<MCX_RESULT abs(quantity)>'
    ]);
<MCX_END_QUERY>

<MCX_QUERY select left(REPLACE(Order_Status, 'O', 'Q'), 1), SUM((ABS(QUANTITY)*UNIT_COST)), SHIPPING, Ship_City, Ship_State from DETAIL,HEADER WHERE DETAIL.ORDER_NUMBER = HEADER.ORDER_NUMBER AND HEADER.ORDER_NUMBER = '<MCX_ENV ONUM>' and PQ_SENT_TO_GOOGLE = 'N'>
    _gaq.push(['_trackTrans']);
<MCX_END_QUERY>