Zen Cart Logo
Forums / General Questions / Adding 4 new fields to Extra Info section < only last field works

Adding 4 new fields to Extra Info section < only last field works

Locked

Views: 1,349

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
25 Mar 2009, 5:54 PM
#1
karissal avatar

karissal

New Zenner

Join Date:
Mar 2009
Posts:
1
Plugin Contributions:
0

Adding 4 new fields to Extra Info section < only last field works

Hello,
I believe something is wrong w/ my code here and am hoping it's easy for somebody with more knowledge to spot.

Issue: I'm adding four custom fields to the "Extra Info" or "Office Use Only" section of the Order Confirmation email. Only the last field ever shows in the email regardless of what field it is. All fields work correctly and I'm seeing them in the admin panel where I've also added them under Customer details. I'm using this thread for reference on how to add a field to the email - http://www.zen-cart.com/forum/showthread.php?t=74590&page=3

My code looks like this:

//MY NEW CODE STARTS HERE
    global $db;
    $sql = "select customers_partner from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";
    $result = $db->Execute($sql); 
        global $db;   
    $sql = "select customers_drmidwife from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";
    $result = $db->Execute($sql); 
    global $db;       
    $sql = "select customers_duedate from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";
    $result = $db->Execute($sql);     
    global $db;
    $sql = "select customers_delivering from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'";           
    $result = $db->Execute($sql); 
//MY NEW CODE ENDS HERE

    // generate footer details for "also-send-to" emails
    $extra_info=array();
    $extra_info['TEXT'] =
      OFFICE_USE . "\t" . "\n" .
      OFFICE_FROM . "\t" . $from . "\n" .
      OFFICE_EMAIL. "\t" . $email_from . "\n" .
      (trim($login) !='' ? OFFICE_LOGIN_NAME . "\t" . $login . "\n"  : '') .
      (trim($login_email) !='' ? OFFICE_LOGIN_EMAIL . "\t" . $login_email . "\n"  : '') .
      ($login_phone !='' ? OFFICE_LOGIN_PHONE . "\t" . $login_phone . "\n" : '') .
      ($login_fax !='' ? OFFICE_LOGIN_FAX . "\t" . $login_fax . "\n" : '') .
//MY NEW CODE STARTS HERE - BUT ONLY THE LAST FIELD SHOWS UP
      'Partner: ' . "\t" . $result->fields['customers_partner'] . "\n" .     
      'Due Date: ' . "\t" . $result->fields['customers_duedate'] . "\n" .     
      'Dr or Midwife: ' . "\t" . $result->fields['customers_drmidwife'] . "\n" .     
      'Delivery Location: ' . "\t" . $result->fields['customers_delivering'] . "\n" .  
//MY NEW CODE ENDS HERE        
      OFFICE_IP_ADDRESS . "\t" . $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR'] . "\n" .
      OFFICE_HOST_ADDRESS . "\t" . $email_host_address . "\n" .
      OFFICE_DATE_TIME . "\t" . date("D M j Y G:i:s T") . "\n\n";

    $extra_info['HTML'] = '<table class="extra-info">' .
      '<tr><td class="extra-info-bold" colspan="2">' . OFFICE_USE . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_FROM . '</td><td>' . $from . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_EMAIL. '</td><td>' . $email_from . '</td></tr>' .
      ($login !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_NAME . '</td><td>' . $login . '</td></tr>' : '') .
      ($login_email !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_EMAIL . '</td><td>' . $login_email . '</td></tr>' : '') .
      ($login_phone !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_PHONE . '</td><td>' . $login_phone . '</td></tr>' : '') .
      ($login_fax !='' ? '<tr><td class="extra-info-bold">' . OFFICE_LOGIN_FAX . '</td><td>' . $login_fax . '</td></tr>' : '') .
//MY NEW CODE STARTS HERE - BUT ONLY THE LAST FIELD SHOWS UP
      '<tr><td class="extra-info-bold">' . 'Partner: ' . '</td><td>' . $result->fields['customers_partner'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . 'Due Date: ' . '</td><td>' . $result->fields['customers_duedate'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . 'Dr or Midwife: ' . '</td><td>' . $result->fields['customers_drmidwife'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . 'Delivery Location: ' . '</td><td>' . $result->fields['customers_delivering'] . '</td></tr>' .
//END MY NEW CODE HERE     
      '<tr><td class="extra-info-bold">' . 'Referral Source: ' . '</td><td>' . $result->fields['customers_referral'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_IP_ADDRESS . '</td><td>' . $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR'] . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_HOST_ADDRESS . '</td><td>' . $email_host_address . '</td></tr>' .
      '<tr><td class="extra-info-bold">' . OFFICE_DATE_TIME . '</td><td>' . date('D M j Y G:i:s T') . '</td></tr>' . '</table>';
    return $extra_info;
  }

Any ideas?
Thanks so much!
-KL