Admin Notes Advanced

Re: Admin Notes Advanced

Quote:

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

Re: Admin Notes Advanced

Quote:

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 :smile:

Re: Admin Notes Advanced

Quote:

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

Quote:

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 :smile:

many thnaks :)

Re: Admin Notes Advanced

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...??

Re: Admin Notes Advanced

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: <b>%d</b> to <b>%d</b> (of <b>%d</b>)');

(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.

Re: Admin Notes Advanced

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()">  <?php require(DIR_WS_INCLUDES . 'header.php'); ?> 

to:

Code:

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

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'] . "'");

Re: Admin Notes Advanced

Quote:

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! :clap:
(installed and it works great)

@swguy: thanks for the fix ::smile:

Re: Admin Notes Advanced

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

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!

Re: Admin Notes Advanced

Quote:

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.

Re: Admin Notes Advanced

@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...