Admin Notes Advanced

**jamie2k** · 9 Mar 2010, 12:46 PM

Originally Posted by paulm

Uploaded version 0.97

- Improved notes notifier layout, and the notes notify messages a now grouped by category (especially useful when there a lots of active notes ).

- To update from 0.96 only overwrite the init_notes_notifier.php file

(Probably) available soon at:
http://www.zen-cart.com/index.php?ma...oducts_id=1210

Hi, Great MOd BTW Thanks Paul,

I have 0.951 installed, have error with customer note being assigned to the active customer, so whjatever customer i am editing, all notes are show with that customers ID... rather than faff aboiut, i wish to update to the latest version.

I read in readme.txt for 0.96 warning all notes data will be lost, how can i restore notes from prevoius data from backup ?

Also can i skip 0.96 update and move onto 0.97 and still achieve a working notes system ? and if so, how would i go about restoring the notes data?

Thanks in advance for your attention in this matter.

Kind regards

Jamie

**paulm** · 9 Mar 2010, 03:42 PM

Originally Posted by jamie2k

I read in readme.txt for 0.96 warning all notes data will be lost, how can i restore notes from prevoius data from backup ?

There have been no changes in the installation sql from 0.912 up to 0.97. So you can just replace the files and NOT run the sql when you update to 0.97. And it should be possible to update to 0.97 from any version skipping all version in between.
(if you do run the sql all notes data will be erased though!)

Of course backup first, just to be sure

**jamie2k** · 9 Mar 2010, 03:55 PM

Originally Posted by paulm

Uploaded version 0.97

- Improved notes notifier layout, and the notes notify messages a now grouped by category (especially useful when there a lots of active notes ).

- To update from 0.96 only overwrite the init_notes_notifier.php file

(Probably) available soon at:
http://www.zen-cart.com/index.php?ma...oducts_id=1210

Originally Posted by paulm

There have been no changes in the installation sql from 0.912 up to 0.97. So you can just replace the files and NOT run the sql when you update to 0.97. And it should be possible to update to 0.97 from any version skipping all version in between.
(if you do run the sql all notes data will be erased though!)

Of course backup first, just to be sure

many thnaks :)

**rxalex** · 1 May 2010, 03:04 AM

How do I use this to create like a macro message or a generic message for different situations such as back ordered ... We apologize for any inconvenience this may cause... customer service. So I could reuse this message for back order situation and so on...??

**swguy** · 19 Oct 2010, 11:40 AM

There's a small bug in this otherwise awesome mod. The define for TEXT_DISPLAY_NUMBER_OF_NOTES should be changed from

define('TEXT_DISPLAY_NUMBER_OF_NOTES', 'Number of notes');

to

define('TEXT_DISPLAY_NUMBER_OF_NOTES', 'Number of notes: %d to %d (of %d)');

(note that the display_count method of the splitPageResults object expects a sprinf style string as its first parameter.)

Thanks to Paulm for making his handiwork available to us all.

**damiantaylor** · 28 Oct 2010, 07:47 PM

I've figured out the code to add the pop up calendar to the edit notes page.
Backup your admin/notes.php before you make any changes so you can put things back if there are any problems!!!

The only file to edit is admin/notes.php as follows:

Line 304:

Code:

<body onLoad="init()">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

to:

Code:

<body onLoad="init()">
<div id="spiffycalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

Line 368:

Code:

  case 'edit':
    // $parameters = 
    // ((isset($_GET['cPath'])) ? $_GET['cPath'] : $note->fields['categories_id']) 
    // ((isset($_GET['pID'])) ? '<strong class="notesCheckValue">*</strong>' : '') 
    // ((isset($_GET['oID'])) ? '<strong class="notesCheckValue">*</strong>' : '')
    // ((isset($_GET['cID'])) ? '<strong class="notesCheckValue">*</strong>' : '')

  echo zen_draw_form('edit_note', FILENAME_NOTES, zen_get_all_get_params(array('action')) . '&action=update'); ?>

to:

Code:

  case 'edit':
    // $parameters = 
    // ((isset($_GET['cPath'])) ? $_GET['cPath'] : $note->fields['categories_id']) 
    // ((isset($_GET['pID'])) ? '<strong class="notesCheckValue">*</strong>' : '') 
    // ((isset($_GET['oID'])) ? '<strong class="notesCheckValue">*</strong>' : '')
    // ((isset($_GET['cID'])) ? '<strong class="notesCheckValue">*</strong>' : '')
?>
<link rel="stylesheet" type="text/css" href="includes/javascript/spiffyCal/spiffyCal_v2_1.css">
<script language="JavaScript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script>
<script language="javascript">
  var startDate = new ctlSpiffyCalendarBox("startDate", "edit_note", "notes_start_date","btnDate1","<?php echo $note->fields['notes_start_date']; ?>",scBTNMODE_CUSTOMBLUE);
  var endDate = new ctlSpiffyCalendarBox("endDate", "edit_note", "notes_end_date","btnDate2","<?php echo $note->fields['notes_end_date']; ?>",scBTNMODE_CUSTOMBLUE);
</script>
<?php echo zen_draw_form('edit_note', FILENAME_NOTES, zen_get_all_get_params(array('action')) . '&action=update'); ?>

Line 380:

Code:

  <tr><th><?php echo TEXT_INFO_NOTE_START_DATE; ?></th><td><?php echo zen_draw_input_field('notes_start_date', zen_date_short($note->fields['notes_start_date'])); ?></td></tr>
  <tr><th><?php echo TEXT_INFO_NOTE_END_DATE; ?></th><td><?php echo zen_draw_input_field('notes_end_date', zen_date_short($note->fields['notes_end_date'])); ?></td></tr>

to:

Code:

  <tr><th><?php echo TEXT_INFO_NOTE_START_DATE; ?></th><td class="main"><script language="javascript">startDate.writeControl(); startDate.dateFormat="yyyy-MM-dd";</script></td></tr>
  <tr><th><?php echo TEXT_INFO_NOTE_END_DATE; ?></th><td class="main"><script language="javascript">endDate.writeControl(); endDate.dateFormat="yyyy-MM-dd";</script></td></tr>

Finally, line 183:

Code:

  case 'update':

   $db->Execute("update " . TABLE_NOTES . "
                           SET
                          `notes_status` = '" . zen_db_input(zen_db_prepare_input($_POST['notes_status'])) . "',
                          `notes_title` = '" . zen_db_input(zen_db_prepare_input($_POST['notes_title'])) . "',
                          `notes_text` =  '" . zen_db_input(zen_db_prepare_input($_POST['notes_text'])) . "',
 
                          `notes_start_date` =  '" . zen_db_input(zen_db_prepare_input(zen_date_raw($_POST['notes_start_date']))) . "',                          
                          `notes_end_date` =  '" . zen_db_input(zen_db_prepare_input(zen_date_raw($_POST['notes_end_date']))) . "',
                                                                             
                          `notes_date_modified` = NOW(), 
                          `notes_categories_id` =  '" . (int)$_POST['notes_categories_id'] . "',
                          `notes_priority` =  '" . (int)$_POST['notes_priority'] . "',
                          `notes_is_special_status` =  '" . (int)$_POST['notes_is_special_status'] . "',                              
                          `customers_id` =  '" . (int)$_POST['customers_id'] . "',
                          `orders_id` =  '" . (int)$_POST['orders_id'] . "', 
                          `products_id` =  '" . (int)$_POST['products_id'] . "',
                          `categories_id` =  '" . zen_db_input(zen_db_prepare_input($_POST['categories_id'])) . "' 

                           WHERE notes_id = '" . (int)$_POST['notes_id'] . "'");

to:

Code:

  case 'update':

   $db->Execute("update " . TABLE_NOTES . "
                           SET
                          `notes_status` = '" . zen_db_input(zen_db_prepare_input($_POST['notes_status'])) . "',
                          `notes_title` = '" . zen_db_input(zen_db_prepare_input($_POST['notes_title'])) . "',
                          `notes_text` =  '" . zen_db_input(zen_db_prepare_input($_POST['notes_text'])) . "',
 
                          `notes_start_date` =  '" . zen_db_input(zen_db_prepare_input($_POST['notes_start_date'])) . "',                          
                          `notes_end_date` =  '" . zen_db_input(zen_db_prepare_input($_POST['notes_end_date'])) . "',
                                                                             
                          `notes_date_modified` = NOW(), 
                          `notes_categories_id` =  '" . (int)$_POST['notes_categories_id'] . "',
                          `notes_priority` =  '" . (int)$_POST['notes_priority'] . "',
                          `notes_is_special_status` =  '" . (int)$_POST['notes_is_special_status'] . "',                              
                          `customers_id` =  '" . (int)$_POST['customers_id'] . "',
                          `orders_id` =  '" . (int)$_POST['orders_id'] . "', 
                          `products_id` =  '" . (int)$_POST['products_id'] . "',
                          `categories_id` =  '" . zen_db_input(zen_db_prepare_input($_POST['categories_id'])) . "' 

                           WHERE notes_id = '" . (int)$_POST['notes_id'] . "'");

**paulm** · 29 Oct 2010, 02:59 PM

Originally Posted by damiantaylor

I've figured out the code to add the pop up calendar to the edit notes page.

This one was still high on my wishlist. Thanks!

(installed and it works great)

@swguy: thanks for the fix :

**damiantaylor** · 29 Oct 2010, 05:05 PM

No problem, thanks for the mod it's just what I needed

Can I make a suggestion for a future release?
It would be good to store the admin user name on the notes table when a note is created.
That way, you could have a checkbox called 'private' which when checked would only show the note if the same user was logged in.

For example, I have 2 admin users and I'm using admin notes to store my 'to do' list.
I would like said list to only be visible when I am logged in, but at the moment it always appears, regardless of who is logged in.

I hope I've explained that correctly!

**paulm** · 3 Nov 2010, 04:59 PM

Originally Posted by damiantaylor

It would be good to store the admin user name on the notes table when a note is created.
That way, you could have a checkbox called 'private' which when checked would only show the note if the same user was logged in

Interesting idea! I am working on it, but it may take some time before I get the chance to finish it.

**paulm** · 5 Nov 2010, 11:44 AM

@damiantaylor: I have a new version including the Private/Public notes functionality, it is not perfect, but it works.

Currently all existing notes will be assigned to one admin (or to none). Maybe I can add some basic functionality to assign each note to it's own admin.

And another issue is that any admin can unset the Public flag of Public notes. After that only the owner can access the note. I am not sure yet how to handle this. Maybe only allow the owner to change the public flag?

And because Public notes can be aditted by anyone, maybe a last edited indicator is needed? Of course it's also possible to only allow editing by the owner.

Improvements are possible but will take time...

Thread: Admin Notes Advanced

Thread Tools

Search Thread

Display

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Re: Admin Notes Advanced

Similar Threads

v153 Admin Name on Order Notes

Notes client only for admin

Admin Notes addon

Bookmarks

Bookmarks

Posting Permissions