PopTheTop Posted November 6, 2004 Share Posted November 6, 2004 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 Quote 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 Link to comment Share on other sites More sharing options...
PopTheTop Posted November 6, 2004 Author Share Posted November 6, 2004 Ok, sorry about that... To get this great new contribution, go HERE Quote 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 Link to comment Share on other sites More sharing options...
Guest Posted November 6, 2004 Share Posted November 6, 2004 Ok, sorry about that... To get this great new contribution, go HERE <{POST_SNAPBACK}> :thumbsup: Great Job Smooth easy install works great! Thanks a very helpful idea. Quote Link to comment Share on other sites More sharing options...
a.niedermann Posted November 6, 2004 Share Posted November 6, 2004 B) cooooool !! thanks for your contirbution! works great Quote Link to comment Share on other sites More sharing options...
Guest Posted November 8, 2004 Share Posted November 8, 2004 (edited) 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 November 8, 2004 by oldhippy Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 8, 2004 Author Share Posted November 8, 2004 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. Quote 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 Link to comment Share on other sites More sharing options...
PopTheTop Posted November 9, 2004 Author Share Posted November 9, 2004 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); ?> Quote 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 Link to comment Share on other sites More sharing options...
100asa Posted November 17, 2004 Share Posted November 17, 2004 You're great! :thumbsup: Easy to install and very helpful Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
100asa Posted November 17, 2004 Share Posted November 17, 2004 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 Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
100asa Posted November 17, 2004 Share Posted November 17, 2004 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 Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
PopTheTop Posted November 17, 2004 Author Share Posted November 17, 2004 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. Quote 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 Link to comment Share on other sites More sharing options...
PopTheTop Posted November 18, 2004 Author Share Posted November 18, 2004 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'); Quote 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 Link to comment Share on other sites More sharing options...
100asa Posted November 18, 2004 Share Posted November 18, 2004 One questions: your contribution (wonderful!!!) open a pop-up to remember a note? If not, it should be possible? Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
PopTheTop Posted November 18, 2004 Author Share Posted November 18, 2004 I think I understand, but could you explain more in detail??? Quote 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 Link to comment Share on other sites More sharing options...
luckyhuckster Posted November 19, 2004 Share Posted November 19, 2004 Just installed this contribution. Thanks for the great work - it is clear and simple to set up and extremely useful. Nice one! Simon Quote Link to comment Share on other sites More sharing options...
100asa Posted November 19, 2004 Share Posted November 19, 2004 I think is possible to open a pop-up to reminder the (example) payment on date of admin note. Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
PopTheTop Posted November 19, 2004 Author Share Posted November 19, 2004 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. Quote 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 Link to comment Share on other sites More sharing options...
Guest Posted November 21, 2004 Share Posted November 21, 2004 (edited) 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 November 21, 2004 by John2b Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted November 21, 2004 Author Share Posted November 21, 2004 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. Quote 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 Link to comment Share on other sites More sharing options...
PopTheTop Posted November 23, 2004 Author Share Posted November 23, 2004 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! Quote 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 Link to comment Share on other sites More sharing options...
Druide Posted November 23, 2004 Share Posted November 23, 2004 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! <{POST_SNAPBACK}> 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 !!! Quote Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
PopTheTop Posted November 23, 2004 Author Share Posted November 23, 2004 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. Quote 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 Link to comment Share on other sites More sharing options...
PVK Posted November 29, 2004 Share Posted November 29, 2004 (edited) 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 November 29, 2004 by PVK Quote Link to comment Share on other sites More sharing options...
♥bruyndoncx Posted November 29, 2004 Share Posted November 29, 2004 looks like the define for the TABLE_XXX is missing in the admin/include/database.php file Quote 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 Link to comment Share on other sites More sharing options...
PopTheTop Posted November 29, 2004 Author Share Posted November 29, 2004 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 Quote 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.