Add personal notes about customer's account?

[Sjolie]

Hello All,

I've been searching for hours on zen-cart forum and addon files for a script/addon that would allow admins to add comments/notes which would attach to a customers account.

I've installed the advanced admin note addon, but it doesn't work how I'd like.

Essentially we make sales calls throughout our database. I want to be able to make comments on each account we call, so we never have duplicate calls and/or can create history about calls so we can pickup where we left off.

Has anyone wrote anything to accomplish this? please point me in the right direction.

I appreciate all the help,


Mike

[gaurav10feb]

do u want just one notes field par customer or everytime you would like to create new notes and also to be able to see old notes history?

[Sjolie]

It would be great to keep history of the notes as well. However even if there was a way to display the "last" note for example "Called customer, left message on 8/24/2011, Call back at later date". That message would let our other staff members know not to bug this customer for atleast 2 more weeks.

[gaurav10feb]

ok i will make it today ...let me know what version of zencart u r using.

[gaurav10feb]

I have done quick fix for you...

STEP 1: open admin>>customers.php

search for case 'update':


add this after search text

// add new notes first
$notes = zen_db_prepare_input($_POST['notes']);
$db->Execute("INSERT INTO " . TABLE_CUSTOMERS_HISTORY . "(customers_id,date,notes) VALUES(" .(int)$customers_id. ",now(),'" . $notes . "')");
// end of add new notes

STEP 2: same file as of step 1 search for
<?php echo zen_draw_input_field('customers_referral', $cInfo->customers_referral, zen_set_field_length(TABLE_CUSTOMERS, 'customers_referral', 15)); ?>
</td>
</tr>
</table></td>
</tr>


add this after search text


<!--Notes for customers-->
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td class="formAreaTitle"><?php echo 'Notes'; ?></td>
</tr>
<tr>
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
<?php
$notes_query = $db->Execute("select * from ". TABLE_CUSTOMERS_HISTORY . " where customers_id = '" . (int)$customers_id . "' ORDER by date DESC LIMIT 5");
while (!$notes_query->EOF) {
echo '<tr><td class="main">' . $notes_query->fields['date'] . '</td><td class="main">' . $notes_query->fields['notes'] . '</td></tr>';
$notes_query->MoveNext();}?>
<tr><td colspan='2' class="main">Add Notes:</td>
<tr><td colspan='2' class="main"><?php echo zen_draw_textarea_field('notes', 'soft', '30', '5');?>
</td>
</table>
</td>
</tr>
<!--end of notes-->
after search text

STEP 3: open includes>>database_tables.php and add
define('TABLE_CUSTOMERS_HISTORY', DB_PREFIX . 'customers_history');

STEP 4: create a sql table using sql file attached.
DONE!!! Puf

You will be able to see last 5 notes in admin customers page and also be able to create new notes.

I will try to make it addon as soon as i get some time.

[Sjolie]

You are amazing, thank you so much for taking your personal time and putting this together. I'll be applying this to the system as soon as I can.

Thanks again,

[gaurav10feb]

No problem, you can always appreciate by donating zencart people.

Let us know if it worked out for you well.

[gazag]

Great mod gaurav10feb

But i think i have found one bug!

If you type a note with an apostrophe it comes up with a SQL error!

So if you type " I don't know if this works or not" it will come up with an error.

Also is there anyway to have the notes show up in the customers panel to the left of the table of customers???

[gaurav10feb]

Hello Gazag,

Thanks for telling...i knew this will come..but as i mentioned above this was a quick fix for person requested it.

if you are using same way then use two 's instead of one

"I don''t know if this works or not"

Alternately, modify above insert command and use addslashes($notes) instead

...will work out for your second request.

[abcisme]

I'm wondering if anyone can help me to display these notes on the order screen for every order the customer makes... We use Super Orders 3.0 and ideally, I'd like to be able to have a customer note history show up on the order page as well as on the invoice. Thank you!