Community Add-Ons
Add file to this packageAdmin Notes
for osCommerce Online Merchant v2.2
Admin Notes v1.0
by PopTheTop
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.
Download 
Report
Version comprenant les précédents bugs fixés.
Version française
Screenshots français visible sur : http://www.oscommerce-screenshots.com/admin-notes-p-274.html
************************************************
Version including previous bugs fixed.
French Version
Screenshots french visible on: http://www.oscommerce-screenshots.com/admin-notes-p-274.html
Here is the long awaited admin-warning/reminder:
Open admin/includes/header.php
FIND:
if ($messageStack->size > 0) {
ADD ABOVE:
// START Admin-Notes Warning
$admin_notes_query = tep_db_query("select status, last_update from " . TABLE_ADMIN_NOTES);
$admin_notes = tep_db_num_rows($admin_notes_query);
while ($admin_notes = tep_db_fetch_array($admin_notes_query)) {
$today_time = time();
$notes_time = ($today_time - strtotime($admin_notes['last_update']) );
if ($admin_notes['status'] == 1) {
if ($notes_time > 1) {
$messageStack->add(WARNING_ADMIN_NOTES_TIME, 'warning');
}
}
if ($admin_notes['status'] == 2) {
$messageStack->add(WARNING_ADMIN_NOTES_IMPORTANT, 'warning');
}
}
// END Admin-Notes Warning
Open admin/includes/languages/english.php
FIND:
?>
ADD ABOVE:
define('WARNING_ADMIN_NOTES_TIME', '<b>Warning:</b> A notice exceeded its reminder datetime! <a href="http://www.your-domain.com/admin/admin_notes.php">(click here)</a>');
define('WARNING_ADMIN_NOTES_IMPORTANT', '<b>Warning:</b> A notice has marked important! <a href="http://www.your-domain.com/admin/admin_notes.php">(click here)</a>');
Thats it, have fun!
I noticed on the admin_notes.php page, when changing the status of a note using the red, green, and yellow circles, the "insert" button would no longer appear.
Very simple update.
in admin_notes.php, line 325:
[code]
Line 325:
if (!$HTTP_GET_VARS['action']) {
Replace with:
if (($HTTP_GET_VARS['action'] != 'edit') && ($HTTP_GET_VARS['action'] != 'delete')) {
[/code]
NOT A FULL PACKAGE
A small query update, does not change functionality just streamlines code a bit by combining two queries into 1.
Changed Step 8: FROM:
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>
<td bgcolor="#FFCC00"><i><?php
//query to grab the notes
$cust_notes_query2 = tep_DB_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
$cust_notes2 = tep_db_fetch_array($cust_notes_query2);
$cust_notes_query = tep_db_query("select customers_id, customers_notes from " . TABLE_CUSTOMERS . " where customers_id = '" . $cust_notes2['customers_id'] . "'");
$cust_notes = tep_db_fetch_array($cust_notes_query);
//end query
echo $cust_notes['customers_notes'];?> </i></td>
</tr>
TO:
<!-- ADMIN NOTES BOF -->
<tr>
<td class="main"><b><?php echo ENTRY_CUSTOMER_NOTES; ?></b></td>
<td bgcolor="#FFCC00"><i><?php
//query to grab the notes
$cust_notes_query = tep_DB_query("select ot.customers_id, tc.customers_notes from " . TABLE_ORDERS . " ot left join " . TABLE_CUSTOMERS . " tc on ot.customers_id = tc.customers_id where ot.orders_id = '" . (int)$oID . "'");
$cust_notes = tep_db_fetch_array($cust_notes_query);
//end query
echo $cust_notes['customers_notes'];?> </i></td>
</tr>
<!-- ADMIN NOTES EOF -->
NOT A FULL PACKAGE
Admin Notes is such a useful contribution, but it wasn't until several days after installing it I discovered a fatal error when trying to access the administration section of the phpBB forum that I have installed with osC.
The fix took me a long time to find, but having done so, all credit must go to yesudo. The explanation of the fix can be found in the forum topic at http://forums.oscommerce.com/index.php?showtopic=184539
The error I received was like this:
Fatal error: Cannot redeclare tep_db_connect() (previously declared in
/home/httpd/vhosts/domaincom/httpdocs/catalog/admin/includes/functions/database.php:13) in
/home/httpd/vhosts/domain.com/httpdocs/catalog/admin/includes/functions/database.php on line 13
The fix requires a small edit to the file, catalog/admin/bb_default.php
Read the details in this attached file.
just correct the install file, because the notes don apear in order.php
only the step8 is new
This is only the changed installfile
If using PHP 5 and osCommerce 051113 change row 278 in admin_notes.php
from
$sInfo_array = array_merge($admin_quer, '');
to
$sInfo_array = array_merge($admin_quer, (array)'');
Adds the ability to show the customer notes on admin/orders.php
If you're just updating, the new steps are #8 - 9; quick & simple add-on.
Full package.
This is a great contribution, this one is to work with the "Customer List Improved V1.1 "contribution from "Kremit" changes only in customers.php
All credits to the creators of those nice contributions.
Not a full package, only customers.php
Admin Notes:
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 or 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 a great way to keep track of your suppliers, contributions, gift certificates and so on.
Admin Customer Notes:
Admin Customer Notes have also been added for any individual customer in the Edit Customer page of Admin / Customers. This is great if you need to keep track of customers or need record notes on a certain customer. 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. The notes (if any) are also displayed on the Admin / Customers page in the info box on the right.
History:
04/15/2005 by PopTheTop
- Fixed a small bug that did not show Customer Notes in Admin / Customers. NOW, Customer Admin Notes will be displayed in the customer info box on the right side of the page in Admin / Customers so that you no longer have to open the Customer Edit screen to read the notes. When you highlight a customer in your Customers List, if they have any Admin Notes saved, those notes will be displayed. If there are no saved notes, then nothing will be displayed.
03/15/2005 by PopTheTop
- Added German language files (thanks to Ingo Hoffmann)
- Cleaned up some code and fine-tuned it a bit
- New easier to follow install file in HTML format
- Customer Admin Notes now displayed in the customer info box on the right side of the page in Admin / Customers so that you no longer have to open the Customer Edit screen to read the notes. When you highlight a customer in your Customers List, if they have any Admin Notes, they will be displayed. If there are no notes, then nothing will be displayed.
01/22/2005 by PopTheTop
- Added Customer Admin Notes (see above for details)
11/17/2004 by PopTheTop
- Fixed the Java Calendar date format
- Fixed the total record count displayed at the lower left bottom
11/06/2004 by PopTheTop
- Original Release
- Designed for osC v2.2 MS2
Full package release...
Just updated the Install.htm file. I forgot that I had another contribution installed and some of that code was still in the Install.html file.
It has been fixed and this now contains the updated install file thanks to FIX for posting the findings at http://forums.oscommerce.com/index.php?showtopic=119993&pid=580277&st=50 (post #70)
Full v2.1 release
Just updated the Install.htm file. I had no idea it was incomplete as much as it was. I either added the wrong version of the install file and deleted the correct one or I must have fell a sleep when I made it.
Anyway, here it is...
Admin Notes v2.1
Description:
==========
Admin Notes:
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 or 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 a great way to keep track of your suppliers, contributions, gift certificates and so on.
Admin Customer Notes:
Admin Customer Notes have also been added for any individual customer in the Edit Customer page of Admin / Customers. This is great if you need to keep track of customers or need record notes on a certain customer. 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. The notes (if any) are also displayed on the Admin / Customers page in the info box on the right.
Download and Support:
==================
Download From:
http://www.oscommerce.com/community/contributions, 2599
osC Support Forum:
http://forums.oscommerce.com/index.php?showtopic=119993
History:
=======
11/22/2004 by PopTheTop
- Added German language files (thanks to Ingo Hoffmann)
- Cleaned up some code and fine-tuned it a bit
- New easier to follow install file in HTML format
- Customer Admin Notes now displayed in the customer info box on the right side of the page in Admin / Customers so that you no longer have to open the Customer Edit screen to read the notes. When you highlight a customer in your Customers List, if they have any Admin Notes, they will be displayed. If there are no notes, then nothing will be displayed.
11/22/2004 by PopTheTop
- Added Customer Admin Notes (see above for details)
11/17/2004 by PopTheTop
- Fixed the Java Calendar date format
- Fixed the total record count displayed at the lower left bottom
11/06/2004 by PopTheTop
- Original Release
- Designed for osC v2.2 MS2
i just translated the language files and added them
deutsche sprachdateien wurden hinzugefügt
I am not changing the version number for this because it is so small of an update. This is just an update notice. The attached download is the full version 2.0 release with this update...
Small typo found by PandA.nl - Thanks!
Noticed one tiny typo (line 405 in admin/admin_notes.php):
<td class="dataTableContent"><?php echo $sInfo->status . ': ' . $status_desc; ?></td>
Should be:
<td class="dataTableContent"><?php echo $sInfo->status . ': ' . $status_desc; ?></td>
The ";" is missing after the  
Well, osC Admin never got the file uploaded so I shrunk the images some and here it is...
New release - Admin Notes v2.0
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.
################
NEW BONUS
################
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.
Support: http://forums.oscommerce.com/index.php?showtopic=119993
The file below was corrupted during the upload. I re-uploaded the new file and since it was larger than 300k (due to the added screen shot), it must be approved by osC before it will get posted.
As soon as it gets posted, you will be able to download it.
New release - Admin Notes v2.0
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.
################
NEW BONUS
################
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.
Support: http://forums.oscommerce.com/index.php?showtopic=119993
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.
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.
A bug was found and is now fixed. This is the full package.
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.
To update, 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>
-----------
That is all and it will be fixed.
Ich habe mal deutsche Sprachdatein hinzugefügt, ich hoffe ich hab keinen Fehler gemacht ;)
Ansonsten ist die Contrib dieselbe von PopTheTop
I´ve just added the german language files.
Admin Notes v1.0 [UPDATE]
I forgot to add the instructions for installing the new command link in the Admin / Tools menu.
You can download this file (full contribution) or just do the following...
##########################################################
# OPEN admin/includes/boxes/tools.php
##########################################################
LOOK for:
'<a href="' . tep_href_link(FILENAME_BANNER_MANAGER) . '" class="menuBoxContentLink">' . BOX_TOOLS_BANNER_MANAGER . '</a><br>' .
ADD this just above that line:
'<a href="' . tep_href_link(FILENAME_ADMIN_NOTES) . '" class="menuBoxContentLink">' . BOX_TOOLS_ADMIN_NOTES . '</a><br>' .
It should now look like this:
$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_BACKUP) . '" class="menuBoxContentLink">' . BOX_TOOLS_BACKUP . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_ADMIN_NOTES) . '" class="menuBoxContentLink">' . BOX_TOOLS_ADMIN_NOTES . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_BANNER_MANAGER) . '" class="menuBoxContentLink">' . BOX_TOOLS_BANNER_MANAGER . '</a><br>' .
Sorry, it's late and after 6 hours of building this, I can say that I AM NOW OFFICIALLY TIRED!
Admin Notes v1.0
by PopTheTop
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.