Admin Notes Advanced

[paulm]

This is the "official" thread about admin notes advanced. Current version 0.912

From the readme:

Features/advantages:

- Create, edit and delete admin notes.

- Easy installation (no need to edit files and no existing database tables are changed).

- Active Notes: the Zen Cart notifier system is being used to notify you about active notes.

- Attached Special notes: attach notes to a customer, product, order or category. These special notes will only show a notification while viewing the customer, product, order or category.

- Unattached customer, product, order or category notes: these notes are specific, and will show a link to the customer, product, order or category, but you will always be notified (whether you are viewing the customer, product, order or category or not).

- Notes categories: create notes categories, and filter notes by category.

- Notes search (name and text).

https://www.zen-cart.com/downloads.php?do=file&id=847

[bitsmith2k]

very nice, i've been waiting for this!


any chance of making the text boxes for the customer/order/product/category into dropdown boxes?

i'd be willing to help ya out
mike

[HeathenMagic]

This is a great mod, many thanks.

Heathenmagic

[paulm]

Nice to hear you like it I must say like it too

any chance of making the text boxes for the customer/order/product/category into dropdown boxes?

Sorry, no plans in the near future for that (although I agree that that part needs some improvement).

Not sure if it's clear as it is, but a way to attach a note is to make it a "Special note" (without entering any id) and then browse your admin to view the item you want it attached to. The the script will ask you if you want to attach the note, and if you then click the link you will be redirected to the note editor and the id will be filled in (marked by '*' ). If you then save the note it will be attached the the item you viewed.

[paulm]

Bugfix for v0.912
The bug causes the product_type not to be set when clicking on a "Edit product" link in the admin notes notifier. And if product_type is not set when using the Zen Cart products editor to save the product, it will change the products_type to 0, which is not a desired value!

To fix it open admin\includes\init_includes\init_notes_notifier.php

and change:

products_type

to:

product_type

[Green333]

Hi

Boy, am I in trouble!

I installed Admin notes; worked ok. Then I installed your contribution as well, because I thought it looked pretty good, and was about to install the SQL file via my admin, and when i tried to log in got a white screen with the following:

1146 Table 'zencart_partykitnkaboodle_com_au.notes' doesn't exist
in:
[select * FROM notes n LEFT JOIN notes_categories nc ON (n.notes_categories_id = nc.notes_categories_id) WHERE (`notes_status` = '1') AND (((`notes_start_date` <= NOW()) AND (`notes_start_date` >= '0001-01-01')) AND ((`notes_end_date` >= NOW()) OR (`notes_end_date` <= '0001-01-01')))]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I really dont know what this means & no idea how to fix it. Also not sure why it is affecting my log in ability.

Many thanks & hope I can be lead in the right direction - because I really need to be able to login to Admin ASAP

S

[Green333]

I quite obviously did not read your install notes carefully:

2) Now copy and paste the contents of notes.sql into: admin :: tools :: Install sql patches
(it's important to load the sql successfully before you install the files!)

so humbly wondering (seeing I like to do things backtofront!) if there is a cure for my boo boo

thank you thank you

S

[paulm]

Another Bugfix for v0.912
This bug is similar to the previous one.

In admin/notes.php

Change:

          $contents[] = array('text' => '<a href="' . FILENAME_PRODUCT . '.php' . '?action=new_product&pID=' . $nInfo->products_id . '&products_type=' . zen_get_products_type($notes_active->products_id) . '"><strong>' . TEXT_INFO_NOTE_PRODUCT . '</strong></a>');

To:

          $contents[] = array('text' => '<a href="' . FILENAME_PRODUCT . '.php' . '?action=new_product&pID=' . $nInfo->products_id . '&product_type=' . zen_get_products_type($nInfo->products_id) . '&cPath=' . zen_get_products_category_id($nInfo->products_id) . '"><strong>' . TEXT_INFO_NOTE_PRODUCT . '</strong></a>');

v0.913 includes the previous fixes. Also a checkbox has been added to set the note Active status directly from within the notes editor.

[Craft Magick]

This sounds like a great mod but I can't find it anywhere. At the beginning of this thread you said it was in the .zip file, which I don't see. I checked the downloads section for 'admin notes' and only see the original admin notes mod (which I already have)

If you could be so kind as to add a link for this mod I'd appreciate it.

Zencart ROCKS

[harry2cool]

How to change the color of the admin notes background, it's kind of dark pink now,