Jump to content
PopTheTop

[Contribution] Admin Notes

Recommended Posts

Admin Notes v1.0

by PopTheTop

of http://www.popthetop.com

 

This will add a section under Admin / Tools where you may enter personal notes about anything you wish. You can save your notes to an unlimited number of categories, move or copy them from one category to another, go back and add to or modify your notes, delete them when they are no longer needed, preview the notes you have entered, sort your notes by title, status in ascending or descending view.

 

I needed a place to easily store my notes about various contributions, suppliers, customers, order details, shipping and so on. I got tired of having little pieces of paper all over my desk reminding me of stuff. So in order to clean up a bit, I decided to build this little contribution.

 

This is also a great way to keep track of your suppliers, contributions, gift certificates and so on. It is very simple to install. Just upload a few files, add 2 new tables in your database and make 2 small changes to 2 files.

 

-----------------------------

 

If you need any support, this is the place to find it.

 

-----------------------------

 

You may get this contribution from


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

Ok, sorry about that...

 

To get this great new contribution, go HERE


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

Nice contribution :D I will find this a great help is storing info I need when on Buying trips abroad :rolleyes:

 

Plus it was extreamly easy to add to oscommerce and plain English install notes :D

 

Nice one :thumbsup:

Edited by oldhippy

Share this post


Link to post
Share on other sites

Thanks guys...

I was wondering if someone could help me out. At the lower left corner where you see the word Records, it should state the number of records (notes) that you have but it doesn't. It should look like "14 Records".

 

If you can fix this, please post it and I will update the contribution with the fix or you can do it.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

The code below is the problem line in admin_notes.php as described above...

 

<?php echo $admin_query_split->display_count($admin_query_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_RECORDS); ?>


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

You're great! :thumbsup:

Easy to install and very helpful


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
Share on other sites

I've this problem:

Date to Remember: 04/10/2036

 

Date Added: 17/11/2004

Last Modified: 17/11/2004

 

This is what I see in the right box. But the date to remember is too much far...

Bye


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
Share on other sites

If I use oscommerce calendar I've this problem with the date. If I insert date 2004-11-18 the date is right. How can I use the oscommerce calendar into my italian language? Thank you


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
Share on other sites
Problem:

Date to Remember: 04/10/2036

 

Date Added: 17/11/2004

Last Modified: 17/11/2004

 

As you can see, when you highlight a note, the box on the right shows the date at the top as 04/10/2036 and not the saved date when you edit or insert a new note.

 

Problem fixed. The date format for the Java Calendar was set to save the date as MM/DD/YYYY. osC did not know what to do with it so it freaked so I changed the date format that the Java Calendar saved the date as to YYY-MM-DD and now it is fine.

 

I have uploaded a new version, Admin Notes v1.1, of this contribution HERE

 

Just copy admin_notes.php over your existing file in the category/admin folder.

 

OR, to update this on your own, do the following:

 

Look for the following code in admin_notes.php

LastUpdate.dateFormat="MM-dd-yyyy";</script>

 

Change it to:

LastUpdate.dateFormat="yyyy-MM-dd";</script>

 

hat is all and it will be fixed.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

Yet another update and this is a good one. I just fixed the part at the bottom that was to supposed to add up all the inserted notes and display the amount as follows under the list on the bottom left...

 

Displaying 1 through 20 of 45 records

 

As far as I know, this was the only thing to this date that was not working. Everything else is working great.

 

To fix it, download the latest version from HERE or do the following...

 

Open admin_notes.php language file.

Look for the following line:

define('TEXT_DISPLAY_NUMBER_OF_RECORDS',' Records');

 

Change it to this...

define('TEXT_DISPLAY_NUMBER_OF_RECORDS','Displaying <b>%d</b> through <b>%d</b> of <b>%d</b> recorded notes');


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

One questions: your contribution (wonderful!!!) open a pop-up to remember a note? If not, it should be possible?


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
Share on other sites

I think I understand, but could you explain more in detail???


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

I think is possible to open a pop-up to reminder the (example) payment on date of admin note.


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
Share on other sites

I think I see what you mean. You want a pop-up to remind you of a set date you entered into the Admin Note. So when that date comes, a pop-up will... well, pop up.

 

Right?

 

Sorry, I have no idea how I would go about adding something like that. You would actually need a script to run 24/7 when you enter into the admin somehow.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

Hi PopTheTop,

 

Very nice contribution, thx.

 

But is it possible to add just a plain and easy notesfield to the costumer field (admin only) so that I can but some info about the costumer, deals, agrements, special prices, specifik produkts interested ect....?

Edited by John2b

A friendship founded on business is better than a business founded on friendship

Share this post


Link to post
Share on other sites

That should be pretty easy. Just make a new entry into the database in the customers table and call it from the Admin side. I will work on it and make the update to the contribution in the next day or 2.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites
Is it possible to add just a plain and easy notes field to the costumer field (admin only) so that I can but some info about the costumer, deals, agreements, special prices, specific products interested ect....?

 

Well, it took about 3 hours to figure this out, but it has been added!

 

Admin Notes v2.0 now available HERE

 

New release - Admin Notes v2.0

Added the ability to add notes for any individual customer in the Edit Customer page of Admin / Customers. This is great if you need to keep track of customers. Say you promised a 10% discount for your customer John Doe, then you may enter that info by editing his account in Admin under Admin / Customers. Your new notes are saved in the customer database inside the customers table.

 

Screenshot included!


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites
Well, it took about 3 hours to figure this out, but it has been added!

 

Admin Notes v2.0 now available HERE

 

New release - Admin Notes v2.0

Added the ability to add notes for any individual customer in the Edit Customer page of Admin / Customers. This is great if you need to keep track of customers. Say you promised a 10% discount for your customer John Doe, then you may enter that info by editing his account in Admin under Admin / Customers. Your new notes are saved in the customer database inside the customers table.

 

Screenshot included!

 

 

PLEASE UPLOAD THE SCREENSHOTS & contribution seperate :)

 

so people can download/review the new version, just an idea

 

and btw thanks for the notification to me in this contribution

 

much appreciated !!!


Robert

 

We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;)

Share this post


Link to post
Share on other sites

No problem Robert. With me just learing as I go, your original contribution (noted in install.txt) really helped me out in getting started.

 

The new version is now uploaded at http://www.oscommerce.com/community/contributions,2599 and ready to go.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

I have installed everything as suggested in the zip file.[version 2.0 clean]

Everything seems to work when i edit and add some comments in the customer field, however when i click on the tools button in the admin section and choose admin notes it comes up with this:

 

1146 - Table 'testshop.TABLE_ADMIN_NOTES_TYPE' doesn't exist

 

select type_name from TABLE_ADMIN_NOTES_TYPE order by type_name

 

[TEP STOP]

 

:'(

 

When i check in my database with phpmyadmin the table is there however [which is logical since i copy pasted the codes from the zip file ]

 

 

Anyone any idea what the problem is????

 

Thanks

Edited by PVK

Share this post


Link to post
Share on other sites

looks like the define for the TABLE_XXX is missing in the admin/include/database.php file


KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Share this post


Link to post
Share on other sites

Yes, thanks bruyndoncx

 

Open admin/includes/database_tables.php

 

Be certain you have the following lines at the bottom just before the last ?>

// START - Admin Notes
 define('TABLE_ADMIN_NOTES','admin_notes');
 define('TABLE_ADMIN_NOTES_TYPE','admin_notes_type');
// END - Admin Notes


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×