Order Status Email with Order Status Description

[_fD_]

Hello all

For easier management of order status i made a hack in the ps_order.php to send the text from order_status_description also in the email:

VirtueMart 1.1.3 ps_order.php (The file is attached as txt):

Line 308:
Original:

      $q = "SELECT first_name,last_name,user_email,order_status_name FROM #__{vm}_order_user_info,#__{vm}_orders,#__{vm}_order_status ";

New with order status description:

      $q = "SELECT first_name,last_name,user_email,order_status_name,order_status_description FROM #__{vm}_order_user_info,#__{vm}_orders,#__{vm}_order_status ";

Lines 317 to 335:
Original:

      $message = $VM_LANG->_('HI',false) .' '. $db->f("first_name") . ($db->f("middle_name")?' '.$db->f("middle_name") : '' ). ' ' . $db->f("last_name") . ",\n\n";
      $message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_1',false)."\n\n";

      if( !empty($d['include_comment']) && !empty($d['order_comment']) ) {
         $message .= $VM_LANG->_('PHPSHOP_ORDER_HISTORY_COMMENT_EMAIL',false).":\n";
         $message .= $d['order_comment'];
         $message .= "\n____________________________________________________________\n\n";
      }

      $message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_2',false)."\n";
      $message .= "____________________________________________________________\n\n";
      $message .= $db->f("order_status_name");
      $message .= "\n____________________________________________________________\n\n";
      $message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_3',false)."\n";
      $message .= $url;
      $message .= "\n\n____________________________________________________________\n";
      $message .= $dbv->f("vendor_name") . " \n";
      $message .= $mosConfig_live_site."\n";
      $message .= $dbv->f("contact_email");

New with order status description and put the comment under this text:

      $message = $VM_LANG->_('HI',false) .' '. $db->f("first_name") . ($db->f("middle_name")?' '.$db->f("middle_name") : '' ). ' ' . $db->f("last_name") . ",\n\n";
      $message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_1',false) .' '. $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_2',false)."\n\n";
      $message .= $db->f("order_status_name")."\n\n";
      $message .= $db->f("order_status_description")."\n\n";
      if( !empty($d['include_comment']) && !empty($d['order_comment']) ) {
         $message .= $VM_LANG->_('PHPSHOP_ORDER_HISTORY_COMMENT_EMAIL',false).":\n";
         $message .= $d['order_comment'];
         $message .= "\n____________________________________________________________\n\n";
      }
      $message .= $VM_LANG->_('PHPSHOP_ORDER_STATUS_CHANGE_SEND_MSG_3',false)."\n";
      $message .= $url;
      $message .= "\n\n____________________________________________________________\n";
      $message .= $dbv->f("vendor_name") . " \n";
      $message .= $mosConfig_live_site."\n";
      $message .= $dbv->f("contact_email");

Now you can fill in some status text in the order status description and for individuell comments you fill in a comment.

Hope you like it and take it in to the core  .

Best Regards, Urs

[RedLight Traitor]

Wow thanks! You would think they would have made this link already. Good job.

[_fD_]

Hello all,

here is the actual file for VM 1.1.2 @version $Id: ps_order.php 1529.

Please add it to the core ;-).

Best regards, Urs

[bulesz]

Will try, thanks for this bro!

[BASiK]

Dude your epic! EXACTLY what I needed, you rock!

[ThestraL]

That's what i was looking for. Many thanks bro

Btw ppl, If you are interested in allowing HTML in Order Status Descriptions, you can find the solution at my topic

---> http://forum.virtuemart.net/index.php?topic=59977.msg197214#msg197214

[dj_hardbeat]

Thank you very much! Very helpfull hack! 

Should be implemented in the new version!

[_fD_]

Welcome Guys 

With the best wishes for all. Urs

[Lylene]

Hello fD !

Thanks for this great hack that I just installed on production site !
Very helpfull !

I have a little last question if you don't mind : I'm using SH404SEF and made some changes on the link that leads to the detailed order page on web site :

I changed from :

$url = SECUREURL."index.php?option=com_virtuemart&page=account.order_details&order_id=".urlencode($d["order_id"]).'&Itemid='.$sess->getShopItemid();

to a more "readable" url :

$url = SECUREURL."See_my_order-id".urlencode($d["order_id"].".html");

But, there is a but

Some clients clicks on it without beeing connected, and sometimes if this URL is not know by sh404SEF, they get a 404 ...


So my question is : is there a way to "hide" the big ugly URL and link it to a text like :

"Click here for your detailed order"

Like it is with the order confirmation email :
$footer_html = '<a title="'.$VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER5').'" href="'.$order_link.'">'
. $VM_LANG->_('PHPSHOP_CHECKOUT_EMAIL_SHOPPER_HEADER5').'</a>';


--> But I can't make it work that way

Thakns in advance

Lylene

[BillRayDrums]

Hello all

I've implemented the hack to allow the status message change to display the status change description. Now I'd like to bug a little further and ask for assistance in how do I format that email with the company name and header at the top?

I'm somewhat new to PHP but am rapidly absorbing it's power.

Any help is greatly appreciated.

[billysundar]

Is there a way to send the Order Confirmation email when the order status change? We have a need to send the item descriptions and the order information as well.

Cheers.

[ZS]

Looks like an awesome hack. Does it work with Vmart 1.1.4?

[_fD_]

Hello Guys,

you can download the file for Virtuemart 1.1.4 following:

http://www.frefeldigital.com/index.php?option=com_content&view=article&id=140:virtuemart-hacks&catid=88&Itemid=184

Best regards
Urs

[thomas80]

Hallo Urs,
sorry... veeery stupid question from a newbie...
And where can i find the ps_order.php to replace it?
Thanks for your help,
Thomas

... just found it...
/administrator/components/com_virtuemart/classes

[vitovito]

Is there anybody cn pass me the hack to apply since I got other hack I can not just use the ps order file you posted.
Virtuemart 1.1.4
Many thanks great hack