Kryptronic Software Support Forum

JDLS88 · 08-12-2011 13:36:54

I've created two custom columns in the products table that I need to be displayed in the order email that gets sent out to the shipper. I'm slightly overwhelmed by there being 5 different ordersummary php files and not knowing what the proper CCP7 way of calling something from the database would be.

Thanks in advance.

dh783 · 08-12-2011 21:54:08

First you would need to make an edit to the ECOM_Cart/ECOM_Cart.PHP in the function build_item to get your culumns in the order items array ( the array that is built is at the end of the function). Once you done that then you can pull the information in the order summary.

John

JDLS88 · 08-15-2011 11:14:24

I was running a test to see if I could properly pass data onto the email. I put a bit of test data into the array and tried to call it in the productsummary.php (also productsummaryxhtml.php)...aaand nothing happens. So I tried print_r just to see if it was even able to access the array and it printed the entire array correctly, including the test data I put into the array. Yet when I try to specifically call on the test data, nothing happens. I tried calling on the product ID in the same array and still nothing.

Any ideas why this is happening?

To go over exactly what I'm trying to do, there's an alternative vendor name and vendor price for each product that I need to be mailed out via the shipper email.

Last edited by JDLS88 (08-15-2011 12:23:59)

dh783 · 08-16-2011 04:27:46

Not knowing where (exact place in the script) and how you tried to call the information, and or what your array looks like then one can only guess that your not calling it correctly.
Within the standard ordersummaryxhtml.php script there would be this section

Code:

               // +--
               // | Print our item information cell.
               // +--

               if ($ship_type != 'NOTSHIPPED') {print '<td class="regtable" style="width: 50%">' . $eol;}
               elseif ($ship_count == 0)       {print '<td class="regtable" style="width: 100%">' . $eol;}
               else                            {print '<td class="regtable" style="width: 100%" colspan="2">' . $eol;}

               foreach ($ship_items as $key_num => $item_num) {

                    foreach ($order['items'] as $num => $item) {

If your within the last foreach statement then the call should be something like (your_data = new column)

Code:

print $item['your_data'];

but this is a guess at this time since I don't know your exact array.

John

JDLS88 · 08-18-2011 10:28:45

Here's what I've got:

I used some text as test values for the array to see if I could properly pass them through (around line 1537):

Code:

// +--
// | Formulate the item.
// +--

$item = array('randid'          => $this->random_key(12),
              'id'              => $product['id'],
              'quantity'        => $quantity,
              'name'            => $product['name'],
              'number'          => $product['prodnum'],
              'imgsm'           => $product['imgsm'],
              'prodinv'         => $product['useinv'],
              'optdisp'         => $optnamevals,
              'optselids'       => $optselids,
              'optids'          => $optids,
              'optinv'          => $optinv,
              'dlfiles'         => $dlfiles,
              'delmethod'       => $product['delmethod'],
              'sinshipinfo'     => $sinshipinfo,
              'shipemail'       => $shipemail,
              'sinprodprice'    => $sinprodprice,
              'sinoptprice'     => $sinoptprice,
              'sinaffcomm'      => $sinaffcomm,
              'taxinfo'         => $taxinfo,
              'subtotal'        => $subtotal,
              'subtotalrec'     => $subtotalrec,
              'url'             => $url,
                 'vendorname'          => "vendor name test",
                 'vendorprice'          => "vendor price test",
              'addemtext'       => $product['addemtext']);

And where I'm calling it...around line 513 in ordersummaryxhtml:

// +--
// | Print the item name.
// +--

if ($shownums) {$name = $item['itemnum'] . ' - ' . $item['itemname'];}
else {$name = $item['itemname'];}

$name = $this->xhtml_encode($name);
$quan = $this->xhtml_encode($item['itemquan']);

print '<p class="strong">' . $name . '</p>' . $eol;
print 'Vendor Name:' . $item['vendorname'];
print 'Vendor Price:' . $item['vendorprice'];

The result is sadly nothing.

Last edited by JDLS88 (08-18-2011 10:29:36)

JDLS88 · 08-23-2011 10:39:38

Any ideas, advice, etc?

Thanks.

JDLS88 · 09-02-2011 12:17:17

Can anyone give any help on this?

JayCR48 · 09-02-2011 12:23:53

You've definately been chatting with the correct guy about this. Jon is probably pretty busy, but if he was sitting there next to you see exactly what you were trying to do I'd bet he'd have the answer right off the top of his head.

JDLS88 · 09-02-2011 12:46:40

Oh I'm sure. He's been very helpful in various topics (both ones posted by me or by others) throughout me learning how to use the CCP system.

dh783 · 09-02-2011 13:55:41

Can you post an example of the array your seeing with the new fields or email me a copy it you don't want to post it here?

John

dh783 · 09-02-2011 14:19:17

In looking at a array off my site try printing the inforamtion (from the same place you said you where trying form) like:

Code:

                              print 'Vendor Name:' . $item['cartdata']['vendorname'];
                              print 'Vendor Price:' . $item['cartdata']['vendorprice'];

John

JDLS88 · 09-06-2011 09:41:01

John you are amazing. It's working perfectly. Thank you!

Kryptronic Software Support Forum

#1 08-12-2011 13:36:54

Include custom fields from prod database in order mail

#2 08-12-2011 21:54:08

Re: Include custom fields from prod database in order mail

#3 08-15-2011 11:14:24

Re: Include custom fields from prod database in order mail

#4 08-16-2011 04:27:46

Re: Include custom fields from prod database in order mail

Code:

Code:

#5 08-18-2011 10:28:45

Re: Include custom fields from prod database in order mail

Code:

#6 08-23-2011 10:39:38

Re: Include custom fields from prod database in order mail

#7 09-02-2011 12:17:17

Re: Include custom fields from prod database in order mail

#8 09-02-2011 12:23:53

Re: Include custom fields from prod database in order mail

#9 09-02-2011 12:46:40

Re: Include custom fields from prod database in order mail

#10 09-02-2011 13:55:41

Re: Include custom fields from prod database in order mail

#11 09-02-2011 14:19:17

Re: Include custom fields from prod database in order mail

Code:

#12 09-06-2011 09:41:01

Re: Include custom fields from prod database in order mail

Board footer