Admin Notes Advanced

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

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

This is a great mod, many thanks.

Heathenmagic :smile:

Nice to hear you like it :smile: I must say like it too :smartalec:

bitsmith2k:

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.

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:

product[B]s[/B]_type

to:

product_type

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

S

I quite obviously did not read your install notes carefully::cry:

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

thank you thank you

S

ok - a newbie fix to my self-inflicted problem....

me? not at all familiar with PHPmyAdmin & have never played with it ......looks far too foreboding ATM

Anyhooo - I just ran the SQL file thru the the SQL tab (held my breath) & it works

(I know this was probably a "logical" solution - but I'm still in Kindergarten land when it comes to all this

:smile:

Green333:

I quite obviously did not read your install notes carefully::cry:

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 :oops::D I am glad you found out what went wrong, and that you told it! Saves me some time, and it hopefully will prevent others form overlooking the same thing....

Some day I might add a check to the notifier if the table exists, to prevent these kind of problems. But I am afraid I have little time. There is so much more to do :smile:

You are a bit lucky that the sql works as is in phpMyAdmin. If you installed Zen Cart using a table prefix then you would have to add the prefix to the notes table before executing the sql.

Another way back into the admin would have been to remove the files that where added by this addon (or even remove the notifier only).
**
And, of course, everyone can always go back to the backup that was made before installation of the addon** :P

Thanks for that...I guess I was petty lucky with the PHPmyAdmin considering my blunder!!.

I look forward to using your mod. Looks really great:smile:

Thanks again:clap:

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.

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

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 removed the first release because it had a nasty bug. The later version is attached to the post above yours :-)

I never got to uploading it to the downloads section because I wanted to make some modifications before that. But I doubt if I get to those modifications soon, so I think will upload it as it is.

By the way: v0.913 works quite well, I use it all the time myself. The modifications I would like to make are mainly cosmetic.

Just uploaded v0.914 to: Free Software Addons :: Admin Tools

So I assume it will become available for dowload soon.

One minor (but annoying!) issue has been fixed in 0.914:

version 0.914

• added quick fix to admin/notes.php:
  // fix for active notes notifier link issue: note not showing when nID is set but page is not (and the note is not on page 1).

(the zip attached to this thread will be removed soon)

I just downloaded the mod and upon reading the install info this line has me concerned:

Upgrade warning: this will remove all existing notes data!

I currently have the regular 'Admin Notes' mod installed.

Will THIS mod affect, change, or disable THAT mod?

Zencart ROCKS :clap:

Craft Magick:

I just downloaded the mod and upon reading the install info this line has me concerned:

Upgrade warning: this will remove all existing notes data!

I currently have the regular 'Admin Notes' mod installed.

Will THIS mod affect, change, or disable THAT mod?The regular Admin notes addon uses another database table name, so this sql won't affect it. And I also don't expect it to be affected in any other way.

But of course you will make a full backup just before installing this add on, so you will be able to easily restore everything if needed :smile:

paulm:

The regular Admin notes addon uses another database table name, so this sql won't affect it. And I also don't expect it to be affected in any other way.

But of course you will make a full backup just before installing this add on, so you will be able to easily restore everything if needed :smile:

Thank you very much, paulm. I appreciate your patience with such a newbie :) Yes, I will be sure to backup everything BEFORE installing the mod.

I'm planning to install the mod this week and will come back here to post my triumphs!

Zencart ROCKS :clap:

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

Dark pink?? :blink:

It's not dark pink on a default Zen Cart install.

I think your dark pink background is generated by your admin stylesheet.

Hi all.
It is great to have notice in order and customers list

please help me to make it better
Just need some help to make it better.

When I select order I need to know If customer have some notes.... Im try to get warnin in customer good or bad.
Some my customers make order, I send him goods , but they dont accept it (payment method COD - cash on delivery)

Orders is return, I must pay for delivery but suctomer easy to order agane... I need stop it.

Im setup this mode and add NOTE to this customer - "This customer must pay befor delivery"
It help me, but it is CUSTOMER note... And I can see it when Im in Customer listing.
In ORDER listing I can not see this NOTE

Please help me somebody to see if Customer have any NOTES in Order listing. When I see orders - I need to see if this customer have any notes.

Maxus aka Pavel