Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

illadelph

Archived
  • Posts

    17
  • Joined

  • Last visited

Posts posted by illadelph

  1. Works like a charm blucollarguy :) Thx alot

     

    Your seeing it this way because it was not sent as HTML. Check that your email to your cusotmers is in HTML, if not you will need to install one of the many HTML email contributions to get it working right. Glad that got it to send the email though, I am still working on a better workaround for this issue. Good luck with the HTMl email, Craig :)

  2. Hey blucollarguy it finnally worked when i used the hack BUT the vendor email is not showing up properly ie i knowu said one should set there email client in html format which i have with outlook but still the email looks like this ;

     

    Jim Bellows? Vendor [email protected] wayne Road #3New brunswick, PA 19000 USA

    ------------------------------------------------------

    Special Comments or Instructions:? This email is an automatic

    notification that your product was purchased from our Online Catalog

    ------------------------------------------------------

    From: Tha Gifty

    Tel:?  111.111.1111

    ? ? ? 

    ? ? ? ?

    Tha Gift

    125 East Main

    Philadelphia , PA

    Accnt #: 0000101172005

    ------------------------------------------------------

    Order Number: 155

    ------------------------------------------------------

     

    ?  Qty:Product Name:Item Code/Number:Product Model:Per Unit Price:Item

    Comments:  1 the rivers  eamusic7878 15.0000 1 the rivars thealbums2005 hiphopid 15.0000Our Credit card proccessor requires

    to perform a fraud check on the order before charging the credit card

    used in the purchase this takes between 2hrs - 2 days soon as the

    purchase passes the fraud review stage the customers credit card will be

    charged the entire amount.

    If you have any questions please forward all your inquiries to

    sales desk for an immediate resolution.

     

    Thank You

     

    the other stuff i added on the vendor info page on the product page and on the vendor page but seems like i need to edit some file to get this right what section of the order.php do i need to edit

  3. blucollarguy well when i place the order and i go to the prder admin it is in the second stage ie proccessing already but no email is received okay here is a copy of my order.php and am using 2checkout as my payment gateway

     

    <?php
    /*
     $Id: orders.php,v 1.112 2003/06/29 22:50:52 hpdl Exp $
     including Vendors_Auto_Email by Craig Garrison Sr. ([email protected])
     osCommerce, Open Source E-Commerce Solutions
     http://www.oscommerce.com
    
     Copyright (c) 2003 osCommerce
    
     Released under the GNU General Public License
    */
    
     require('includes/application_top.php');
    //vendors email begin
     function vendors_email($oID) {
    // Get the delivery address
     $delivery_address_query = tep_db_query("select distinct delivery_company, delivery_name, delivery_street_address, delivery_city, delivery_state, delivery_postcode from orders where orders_id='" . $oID ."'");
     $delivery_address_list = tep_db_fetch_array($delivery_address_query);
    
    
       //find out what shipping methods the customer chose
     $shipping_method_query = tep_db_query("select title from " . TABLE_ORDERS_TOTAL . " where orders_id='" . $oID . "' and class = 'ot_shipping'");
         $shipping_method = tep_db_fetch_array($shipping_method_query);
    
    $vendors_email_query = tep_db_query("select distinct o.orders_id, v.vendors_id, v.vendors_name, v.vendors_email, v.vendors_contact, v.vendor_add_info, v.vendor_street, v.vendor_city, v.vendor_state, v.vendors_zipcode, v.vendor_country, v.account_number, o.products_id, o.orders_products_id FROM vendors v, orders_products o, products p where p.vendors_id=v.vendors_id and o.products_id=p.products_id and o.orders_id='" . $oID . "' and v.vendors_send_email=1 GROUP BY vendors_id");
     while ($vendors_email_list= tep_db_fetch_array($vendors_email_query))  {
       $order_number='" . $oID . "';
       $the_email=$vendors_email_list['vendors_email'];
       $the_name=$vendors_email_list['vendors_name'];
       $the_contact=$vendors_email_list['vendors_contact'];
       $email=  'To: <b>' . $the_contact . '  <br>' . $the_name . '<br>' . $the_email . '<br>' .
       $vendors_email_list['vendor_street'] .'<br>' .
       $vendors_email_list['vendor_city'] .', <b>' .
       $vendors_email_list['vendor_state'] .' <b>' .
       $vendors_email_list['vendors_zipcode'] . ' <b>' . $vendors_email_list['vendor_country'] . '<br>' . "\n" . EMAIL_SEPARATOR . "\n" . 'Special Comments or Instructions:  <b>' . $vendors_email_list['vendor_add_info'] .'<b>' . "\n" . EMAIL_SEPARATOR . "\n" . 'From: <b>' . STORE_OWNER . "\n" . STORE_NAME_ADDRESS . "\n" . 'Accnt #: <b>' . $vendors_email_list['account_number'] . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" .  EMAIL_SEPARATOR . "\n" . '</b><br><br>Shipping Metthod:<br>' .  $shipping_method['title'] . '<br>' . '</b><br>Dropship deliver to:<br>' .
       $delivery_address_list['delivery_company'] .'<br>' .
       $delivery_address_list['delivery_name'] .'<br>' .
       $delivery_address_list['delivery_street_address'] .'<br>' .
       $delivery_address_list['delivery_city'] .'<br>' .
       $delivery_address_list['delivery_state'] . ' ' . $delivery_address_list['delivery_postcode'] . '<br>';
    
    
    // Get all the products to be included in the email
       $vendors_email_products_query = tep_db_query("select distinct o.orders_id, v.vendors_id,  p.vendors_prod_comments, o.products_name, p.vendors_prod_id, o.products_model, o.products_id, o.products_quantity, p.vendors_product_price, o.orders_products_id FROM vendors v, orders_products o, products p where p.vendors_id=v.vendors_id and v.vendors_id='" . $vendors_email_list['vendors_id'] . "' and o.products_id=p.products_id and o.orders_id='" . $oID . "' order by o.products_name");
    
       $email = $email .
       '<table width="75%" border=1 cellspacing="0" cellpadding="3">
       <tr><td>Qty:</td><td>Productname:</td><td>Item Code/Number:</td><td>Productmodel:</td><td>Per Unit Price:</td><td>Item Comments: </td></tr>';
       while ($vendors_email_products= tep_db_fetch_array($vendors_email_products_query)) {
         $email = $email . '<tr><td>' . $vendors_email_products['products_quantity'] . '</td><td>' . $vendors_email_products['products_name'] . '</td><td>' . $vendors_email_products['vendors_prod_id'] .
    '</td><td>' . $vendors_email_products['products_model'] .
    '</td><td>' . $vendors_email_products['vendors_product_price'] . '</td><td>' .
            $vendors_email_products['vendors_prod_comments'] . '</td></tr>';
    
         $current_products_id=$vendors_email_products['products_id'];
         $vendors_email_products_attributes_query = tep_db_query("select distinct p.vendors_id, opa.products_options_values from orders_products_attributes opa, orders o, products p where opa.orders_id='" .  $oID . "' and opa.orders_products_id='" . $current_products_id . "' and p.vendors_id='" . $vendors_email_products['vendors_id']. "' GROUP BY vendors_id");
         while ($vendors_email_products_attributes= tep_db_fetch_array($vendors_email_products_attributes_query)) {
           $email_message = $email_message . '<tr><td> </td><td colspan=3>'. $vendors_email_products_attributes['products_options_values'] .'</td></tr>';
        }
    
    //  $email= $email .  '<br>' . $email_message;
    
       }
       $email = $email . '</table><br><HR><br>';
    
    //send the email
    tep_mail($the_name, $the_email, EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID ,  $email .  '<br>', STORE_NAME, STORE_OWNER_EMAIL_ADDRESS) ;
     }
    return true;
    }
    //vendors_email end, but there is more to do, keep looking
    
     require(DIR_WS_CLASSES . 'currencies.php');
     $currencies = new currencies();
    
     $orders_statuses = array();
     $orders_status_array = array();
     $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'");
     while ($orders_status = tep_db_fetch_array($orders_status_query)) {
       $orders_statuses[] = array('id' => $orders_status['orders_status_id'],
                                  'text' => $orders_status['orders_status_name']);
       $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];
     }
    
     $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');
    
     if (tep_not_null($action)) {
     switch ($action) {
       case 'update_order':
         $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
         $status = tep_db_prepare_input($HTTP_POST_VARS['status']);
         $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);
    
         $order_updated = false;
         $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
         $check_status = tep_db_fetch_array($check_status_query);
    
         if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {
             tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");
            //Vendors email check status begin
            if ($status == 2) {
              vendors_email($oID);
            }
            //Vendors email check status end  This is the last mod to make, your done
    
             $customer_notified = '0';
             if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) {
               $notify_comments = '';
               if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) {
                 $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";
               }
    
               $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
    
               tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
    
               $customer_notified = '1';
             }
    
             tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments)  . "')");
    
             $order_updated = true;
           }
    
           if ($order_updated == true) {
            $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
           } else {
             $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
           }
    
           tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));
           break;
         case 'deleteconfirm':
           $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
    
           tep_remove_order($oID, $HTTP_POST_VARS['restock']);
    
           tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));
           break;
       }
     }
    
     if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {
       $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
    
       $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
       $order_exists = true;
       if (!tep_db_num_rows($orders_query)) {
         $order_exists = false;
         $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');
       }
     }
    
     include(DIR_WS_CLASSES . 'order.php');
    ?>
    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html <?php echo HTML_PARAMS; ?>>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
    <title><?php echo TITLE; ?></title>
    <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
    <script language="javascript" src="includes/general.js"></script>
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
    <!-- header //-->
    <?php
     require(DIR_WS_INCLUDES . 'header.php');
    ?>
    <!-- header_eof //-->
    
    <!-- body //-->
    <table border="0" width="100%" cellspacing="2" cellpadding="2">
     <tr>
       <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
    <!-- left_navigation //-->
    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
    <!-- left_navigation_eof //-->
       </table></td>
    <!-- body_text //-->
       <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
    <?php
     if (($action == 'edit') && ($order_exists == true)) {
       $order = new order($oID);
    ?>
         <tr>
           <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr>
               <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
               <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
               <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
             <tr>
               <td colspan="3"><?php echo tep_draw_separator(); ?></td>
             </tr>
             <tr>
               <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                 <tr>
                   <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>
                   <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>
                 </tr>
                 <tr>
                   <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
                 </tr>
                 <tr>
                   <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>
                   <td class="main"><?php echo $order->customer['telephone']; ?></td>
                 </tr>
                 <tr>
                   <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>
                   <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>
                 </tr>
               </table></td>
               <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                 <tr>
                   <td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>
                   <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>
                 </tr>
               </table></td>
               <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">
                 <tr>
                   <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>
                   <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>
                 </tr>
               </table></td>
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
         </tr>
         <tr>
           <td><table border="0" cellspacing="0" cellpadding="2">
             <tr>
               <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
               <td class="main"><?php echo $order->info['payment_method']; ?></td>
             </tr>
    <?php
       if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {
    ?>
             <tr>
               <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
             </tr>
             <tr>
               <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>
               <td class="main"><?php echo $order->info['cc_type']; ?></td>
             </tr>
             <tr>
               <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>
               <td class="main"><?php echo $order->info['cc_owner']; ?></td>
             </tr>
             <tr>
               <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>
               <td class="main"><?php echo $order->info['cc_number']; ?></td>
             </tr>
             <tr>
               <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>
               <td class="main"><?php echo $order->info['cc_expires']; ?></td>
             </tr>
    <?php
       }
    ?>
           </table></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
         </tr>
         <tr>
           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>
               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>
             </tr>
    <?php
       for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
         echo '          <tr class="dataTableRow">' . "\n" .
              '            <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .
              '            <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];
    
         if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {
           for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {
             echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
             if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';
             echo '</i></small></nobr>';
           }
         }
    
         echo '            </td>' . "\n" .
              '            <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .
              '            <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .
              '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .
              '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .
              '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .
              '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n";
         echo '          </tr>' . "\n";
       }
    ?>
             <tr>
               <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">
    <?php
       for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
         echo '              <tr>' . "\n" .
              '                <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .
              '                <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .
              '              </tr>' . "\n";
       }
    ?>
               </table></td>
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
         </tr>
         <tr>
           <td class="main"><table border="1" cellspacing="0" cellpadding="5">
             <tr>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>
               <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>
             </tr>
    <?php
       $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added");
       if (tep_db_num_rows($orders_history_query)) {
         while ($orders_history = tep_db_fetch_array($orders_history_query)) {
           echo '          <tr>' . "\n" .
                '            <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" .
                '            <td class="smallText" align="center">';
           if ($orders_history['customer_notified'] == '1') {
             echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";
           } else {
             echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";
           }
           echo '            <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" .
                '            <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" .
                '          </tr>' . "\n";
         }
       } else {
           echo '          <tr>' . "\n" .
                '            <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .
                '          </tr>' . "\n";
       }
    ?>
           </table></td>
         </tr>
         <tr>
           <td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>
         </tr>
         <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order'); ?>
           <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
         </tr>
         <tr>
           <td><table border="0" cellspacing="0" cellpadding="2">
             <tr>
               <td><table border="0" cellspacing="0" cellpadding="2">
                 <tr>
                   <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>
                 </tr>
                 <tr>
                   <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>
                   <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>
                 </tr>
               </table></td>
               <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>
             </tr>
           </table></td>
         </form></tr>
         <tr>
           <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>
         </tr>
    <?php
     } else {
    ?>
         <tr>
           <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr>
               <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
               <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>
               <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">
                 <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>
                   <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH . ' ' . tep_draw_input_field('oID', '', 'size="12"') . tep_draw_hidden_field('action', 'edit'); ?></td>
                 </form></tr>
                 <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>
                   <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS . ' ' . tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>
                 </form></tr>
               </table></td>
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr>
               <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                 <tr class="dataTableHeadingRow">
                   <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
                   <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>
                   <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>
                   <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>
                   <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
                 </tr>
    <?php
       if (isset($HTTP_GET_VARS['cID'])) {
         $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
         $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";
       } elseif (isset($HTTP_GET_VARS['status'])) {
         $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
         $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC";
       } else {
         $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC";
       }
       $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);
       $orders_query = tep_db_query($orders_query_raw);
       while ($orders = tep_db_fetch_array($orders_query)) {
       if ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {
           $oInfo = new objectInfo($orders);
         }
    
         if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {
           echo '              <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '\'">' . "\n";
         } else {
           echo '              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '\'">' . "\n";
         }
    ?>
                   <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name']; ?></td>
                   <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>
                   <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>
                   <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>
                   <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
                 </tr>
    <?php
       }
    ?>
                 <tr>
                   <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                     <tr>
                       <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>
                       <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>
                     </tr>
                   </table></td>
                 </tr>
               </table></td>
    <?php
     $heading = array();
     $contents = array();
    
     switch ($action) {
       case 'delete':
         $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>');
    
         $contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm'));
         $contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br><br><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
         $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);
         $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
         break;
       default:
         if (isset($oInfo) && is_object($oInfo)) {
           $heading[] = array('text' => '<b>[' . $oInfo->orders_id . ']  ' . tep_datetime_short($oInfo->date_purchased) . '</b>');
    
           $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
           $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');
           $contents[] = array('text' => '<br>' . TEXT_DATE_ORDER_CREATED . ' ' . tep_date_short($oInfo->date_purchased));
           if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . tep_date_short($oInfo->last_modified));
           $contents[] = array('text' => '<br>' . TEXT_INFO_PAYMENT_METHOD . ' '  . $oInfo->payment_method);
         }
         break;
     }
    
     if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {
       echo '            <td width="25%" valign="top">' . "\n";
    
       $box = new box;
       echo $box->infoBox($heading, $contents);
    
       echo '            </td>' . "\n";
     }
    ?>
             </tr>
           </table></td>
         </tr>
    <?php
     }
    ?>
       </table></td>
    <!-- body_text_eof //-->
     </tr>
    </table>
    <!-- body_eof //-->
    
    <!-- footer //-->
    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    <br>
    </body>
    </html>
    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

     

    Ok folks, I think I've discovered this bug of the email not giong out for some people. I just updated to the latest PayPal IPN and my emails no longer go out when the order get's posted back and the status is updated. I don't have a solution yet but if your isn't working, do this test, place an order but stop at the final payment screen at your processor, you must go past "checkout confirmation" for the order to be entered into the database as an actual order. Then go to your orders page and manually update it to "processing" and see if your email goes out. If it does then this is the problem. If it still does not go out, then obviously something else is the issue. I will try to create a mod for this that does not depend the "orders.php" file being called, which it does now, so that it will not matter what payment gateway your using. I'll be in touch. Craig :)

  4. Now for some reason when i place a test order and it is in default proccessing stage i don't get any vendor emails BUT when i update it to delivered i get a copy of the update that is sent out to the customer .... any help BC

     

    New Update has been uploaded.

    :thumbsup: Hopefully this will fix most of the problems that have shown up recently.:thumbsup:

    This is what I had referred to earlier, I am just updating some bugs that have been brought up here in the forums. Full package. Thanks to the many people who have come forward with issues, fixes, and cool hacks. This is not a major update, the attribute issue is still an issue(not fixed yet), so if you have been having any problems getting this working, be sure to use this package. I test installed this package on a stock osCommerce MS2 2.2., and had no errors.

     

    Good luck and I will be in touch soon with more, Craig :)

  5. Thanks for the update but for some reason it is still not working on mine please advise if i can send you some copies of my files for you to take a look at and possibly alert me of anything i may have left out

     

    Thanks

     

    New Update has been uploaded.

    :thumbsup: Hopefully this will fix most of the problems that have shown up recently.:thumbsup:

    This is what I had referred to earlier, I am just updating some bugs that have been brought up here in the forums. Full package. Thanks to the many people who have come forward with issues, fixes, and cool hacks. This is not a major update, the attribute issue is still an issue(not fixed yet), so if you have been having any problems getting this working, be sure to use this package. I test installed this package on a stock osCommerce MS2 2.2., and had no errors.

     

    Good luck and I will be in touch soon with more, Craig :)

  6. Hey guys nice contribution am having the same problem gone back and forth trying to look at my order.php file but am still not able to get the vendor emails when someone purchases an item , i installed the contribution and assigned a new testing vendor with my own email address made a test purchase but no receipt of the vendor email any help please

     

    Ok Steve I will take a look and see what's up. You got one of the files with the "apt" in it so you may have some more of my dev stuff. I will look into it. Craig :)

    PS Anyone else having this problem?

  7. Hey guys nice contribution am having the same problem gone back and forth trying to look at my order.php file but am still not able to get the vendor emails when someone purchases an item , i installed the contribution and assigned a new testing vendor with my own email address made a test purchase but no receipt of the vendor email any help please

     

     

    Ok Steve I will take a look and see what's up. You got one of the files with the "apt" in it so you may have some more of my dev stuff. I will look into it. Craig :)

    PS Anyone else having this problem?

×
×
  • Create New...