Guest Posted July 15, 2005 Share Posted July 15, 2005 ******************************************** Support thread for Contact alert mod for OsC 2.2 MS2 ******************************************** Description: If you have some problem with alot of pending orders and the priority in witch they should be handeled, then this is the contribution for you. After installation you will se an image indicating when the order was last updated to a new status, or with new information for the customer. You can set the amount of days before the alerts, and the alert is set for two steps. Default is 3 days, and 5 days. See screendump at "http://www.sweclimb.se/interakt/contact_alert_mod_preview.gif" for a graphic view. This can help you alot in hectic times with alot of pending orders. It did the trick for me. :) Zipper Quote Link to comment Share on other sites More sharing options...
busonero Posted July 15, 2005 Share Posted July 15, 2005 Hi Zipper ! first of all, thank you for this Contribution. It will give the order status a better overview :-) No difficulties with the install. Just this problem: while order from yesterday are correctly marked, = Order updated within 2 days. and orders from yesterday till 19.12.2004 are also correcty marked = Order not updated for over 2 days. happens that orders from 7.12.04 till 27.06.04 are marked as = Order = Order updated within 2 days. even if an order from 27.6.2004 ist correctly marked as = Order not updated for over 2 days. and all orders before 27.6.2004 are correctly marked as: = Order not updated for over 2 days. what did i made wrong ? thank you for your help sincerely Roberto ********************************************Support thread for Contact alert mod for OsC 2.2 MS2 ******************************************** Description: If you have some problem with alot of pending orders and the priority in witch they should be handeled, then this is the contribution for you. After installation you will se an image indicating when the order was last updated to a new status, or with new information for the customer. You can set the amount of days before the alerts, and the alert is set for two steps. Default is 3 days, and 5 days. See screendump at "http://www.sweclimb.se/interakt/contact_alert_mod_preview.gif" for a graphic view. This can help you alot in hectic times with alot of pending orders. It did the trick for me. :) Zipper <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Guest Posted July 15, 2005 Share Posted July 15, 2005 busonero ------> I cant see the images you have posted. They seem to be protected with password. I dont quite understand what you mean without the images. Zipper Quote Link to comment Share on other sites More sharing options...
busonero Posted July 16, 2005 Share Posted July 16, 2005 Hi Zipper ! thank you fpr your reply. sorry, but i can see the images in the post. For understanding I just insert the - image name - instead of the - images itself -: while order from yesterday are correctly marked, green.gif = Order updated within 2 days. and orders from yesterday till 19.12.2004 are also correcty marked red.gif = Order not updated for over 2 days. happens that orders from 7.12.04 till 27.06.04 are marked as green.gif = Order = Order updated within 2 days. even if an order from 27.6.2004 ist correctly marked as red.gif = Order not updated for over 2 days. and all orders before 27.6.2004 are correctly marked as: reg.gif = Order not updated for over 2 days. Thank you for your help Sincerely Roberto busonero ------> I cant see the images you have posted. They seem to be protected with password. I dont quite understand what you mean without the images. Zipper <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
bsnmcahi Posted July 16, 2005 Share Posted July 16, 2005 Hi, I cant see the images either, I think its because you are linking to files which are placed in your admin directory of your which anything in there even images other people will need a password to access. You need to copy the images into a folder on your server of your site which is not passworded and redo the link because at the moment they link to /admin/images.... and we need a password to see these because they are uploaded in that folder and anything placed in a folder is protected. Regards Martin Quote Link to comment Share on other sites More sharing options...
busonero Posted July 16, 2005 Share Posted July 16, 2005 Hi Zipper, hi Martin, well, they're only the green.gif and the red.gif i linked. i'll try again without images, just with images name. > while order from yesterday are correctly marked, green.gif = Order updated within 2 days. and orders from yesterday till 19.12.2004 are also correcty marked red.gif = Order not updated for over 2 days. happens that orders from 7.12.04 till 27.06.04 are marked as green.gif = Order = Order updated within 2 days. even if an order from 27.6.2004 ist correctly marked as red.gif = Order not updated for over 2 days. and all orders before 27.6.2004 are correctly marked as: reg.gif = Order not updated for over 2 days. < red.gif = Order not updated for over 2 days. green.gif = Order updated within 2 days. Thank you for your help Sincerely Roberto Hi, I cant see the images either, I think its because you are linking to files which are placed in your admin directory of your which anything in there even images other people will need a password to access. You need to copy the images into a folder on your server of your site which is not passworded and redo the link because at the moment they link to /admin/images.... and we need a password to see these because they are uploaded in that folder and anything placed in a folder is protected. Regards Martin <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
brightlaserlights Posted July 16, 2005 Share Posted July 16, 2005 (edited) Hi, Thanks for this nice distrubution. But I have a question, could somebody tweak this contrubution so that if the status is delivered give's a happy status? Regards Hi Zipper, hi Martin, well, they're only the green.gif and the red.gif i linked. i'll try again without images, just with images name. > while order from yesterday are correctly marked, green.gif = Order updated within 2 days. and orders from yesterday till 19.12.2004 are also correcty marked red.gif = Order not updated for over 2 days. happens that orders from 7.12.04 till 27.06.04 are marked as green.gif = Order = Order updated within 2 days. even if an order from 27.6.2004 ist correctly marked as red.gif = Order not updated for over 2 days. and all orders before 27.6.2004 are correctly marked as: reg.gif = Order not updated for over 2 days. < red.gif = Order not updated for over 2 days. green.gif = Order updated within 2 days. Thank you for your help Sincerely Roberto <{POST_SNAPBACK}> Edited July 16, 2005 by brightlaserlights Quote Link to comment Share on other sites More sharing options...
Guest Posted July 17, 2005 Share Posted July 17, 2005 (edited) Hi, Thanks for this nice distrubution. But I have a question, could somebody tweak this contrubution so that if the status is delivered give's a happy status? Regards <{POST_SNAPBACK}> Hi The thing with the daycount of this script is that it counts ydays. That is the actual number of days since last 1/1. Therefore there is a known issue if the yday number when the order was last updated is actually higher than the yday of todays date. Thats why orders that was last updated like 21/11/2004 indicates a wrong alert since the yday count for that date is actually higher than todays date. (16/07/2005) Please note that this script is to control pending orders and not closed ones. When I made the script it was to remind me after 5 days at most. The orders in the example in brightlaserlights post above is quite older than that. I will try to mend this issue when I get the time though. Stay with this version in the mean time. :) Zipper Edited July 17, 2005 by zipper Quote Link to comment Share on other sites More sharing options...
busonero Posted July 17, 2005 Share Posted July 17, 2005 Hi Zipper, thank you for your reply. i understand it. i cannot fix it myself, but maybe i'll have time to fix it in the next release. thank you again for your work sincerely Roberto Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 Hi, Thanks for this nice distrubution. But I have a question, could somebody tweak this contrubution so that if the status is delivered give's a happy status? Regards <{POST_SNAPBACK}> Hi, guys... Thanx for this great mod... :thumbsup: What brightlaserlights said seems to be a good idea... We could also display a new (different) icon when order status is "delivered" ... ;) Quote Link to comment Share on other sites More sharing options...
bsnmcahi Posted July 18, 2005 Share Posted July 18, 2005 Hi yes I agree great contribution very usefull as trying to spot the different status can be a pain. The idea of having completed orders with a smily face is great as all my orders which are done have sad red faces which seems a bit wrong :) Great work though so far! Martin Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 Yep... Just a small bug... I'm checking my shop with this new mod installed and when a new order is recorded, before any update, green smily is displayed instead of warning icon... :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 Maverick529 ---> That seems strange. When a new order is made the field last_updated_date gets the value null. The script searches fot this value in the field before anything else happens, so the reason for this not working must be that the default value of that field in your database is not null. Can that be correct? It's eiter that or something else. :) -- Its a great idea with another icon for closed orders. I will try to work on that later on. Probably not a biggie. I have got limited time for coding like this, but I will get to it as soon as possible. Feel free to help out if you have the knowhow and time. Zipper Ps. busonero -----> Can you please edit your previous post and remove the linked images. They are behind admin and I (and everyone else?) is beeing prompt for password at every reload of the thread. Thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 Hi zipper you right :thumbsup: I was checking my Orders table and the field last_modified is not Null by default but displays the same date than date_purchased ... I'm using a french creaload 6, not a ms2.2, may be that's the reason why... I've tried to modify the code like that: $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == $purchase_day) { instead of $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == null) { but green icon is still diplayed... What can I do? ;) Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 ouups, I wasn't editing the right file, sorry :blush: but now, with this code, warning icon is displayed for all order recorded and/or modified the same day (it doesn't care about the hour, only the date)... :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2005 Share Posted July 18, 2005 Found.... Thanx to my friend, Oneill :thumbsup: It was a creload problem... in checkout_process.php, we can find: 'last_modified' => 'now()', Just remove it and it works... :thumbsup: Quote Link to comment Share on other sites More sharing options...
Guest Posted July 19, 2005 Share Posted July 19, 2005 Hi zipper just a question could you confirm to me this code is ok? // contact alert mod start $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == null) { $indicator = 'images/alert/new.gif'; } else { if($today - $last_mod_day >= $daycount_2) { $indicator = 'images/alert/red.gif'; } elseif($today - $last_mod_day >= $daycount_1) { $indicator = 'images/alert/yellow.gif'; } else { $indicator = 'images/alert/green.gif'; } } // contact alert mod end It shouldn't be like that? // contact alert mod start $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == null) { $indicator = 'images/alert/new.gif'; } else { if($today - $last_mod_day >= $daycount_2) { $indicator = 'images/alert/red.gif'; } else { if($today - $last_mod_day >= $daycount_1) { $indicator = 'images/alert/yellow.gif'; } else { $indicator = 'images/alert/green.gif'; } } } // contact alert mod end Thanx for your answer ;) Quote Link to comment Share on other sites More sharing options...
Guest Posted July 21, 2005 Share Posted July 21, 2005 The correct lines of code is: // contact alert mod start $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == null) { $indicator = 'images/alert/new.gif'; } else { if($today - $last_mod_day >= $daycount_2) { $indicator = 'images/alert/red.gif'; } elseif($today - $last_mod_day >= $daycount_1) { $indicator = 'images/alert/yellow.gif'; } else { $indicator = 'images/alert/green.gif'; } } // contact alert mod end It?s easy to see if the code has errors though. Most webservers tell you what is wrong and the line of the error in the file. Zipper Quote Link to comment Share on other sites More sharing options...
bsnmcahi Posted July 24, 2005 Share Posted July 24, 2005 Is it possible for this contribution to be done without the issue of time. Just to show a coloured face depending on the status an order regardless of how long it has been on the system? Quote Link to comment Share on other sites More sharing options...
Guest Posted July 29, 2005 Share Posted July 29, 2005 Is it possible for this contribution to be done without the issue of time. Just to show a coloured face depending on the status an order regardless of how long it has been on the system? <{POST_SNAPBACK}> Yepp. Thats no biggie. You would have to add a few lines of code to the file orders.php and upload the images you want to be displayed. There is a way of sorting orders by status from the dropdown meny in the right corner of the orders section as of now though. Zipper Quote Link to comment Share on other sites More sharing options...
Guest Posted August 6, 2005 Share Posted August 6, 2005 Hi guys :D here comes the solution, from the frenchie :lol: , to display an other icon for closed orders... B) // contact alert mod start $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == null) { $indicator = 'images/alert/new.gif'; } else { if($today - $last_mod_day >= $daycount_2) { $indicator = 'images/alert/red.gif'; } elseif($today - $last_mod_day >= $daycount_1) { $indicator = 'images/alert/yellow.gif'; } else { $indicator = 'images/alert/green.gif'; } } if ( $orders['orders_status_name']==$orders_status_array[3]) $indicator = 'images/icons/tick.gif'; // contact alert mod end Check fist in your database if your orders_status_id is set to 3, like me, for closed order (sent order) Else, change it accordingly to your id ($orders_status_array[your_id] Enjoy B) Thx to my firend pierrick for this code... :thumbsup: Quote Link to comment Share on other sites More sharing options...
Guest Posted August 7, 2005 Share Posted August 7, 2005 Hi guys :D here comes the solution, from the frenchie :lol: , to display an other icon for closed orders... B) // contact alert mod start $last_mod_day = tep_date_yc($orders['last_modified']); $purchase_day = tep_date_yc($orders['date_purchased']); if($last_mod_day == null) { $indicator = 'images/alert/new.gif'; } else { if($today - $last_mod_day >= $daycount_2) { $indicator = 'images/alert/red.gif'; } elseif($today - $last_mod_day >= $daycount_1) { $indicator = 'images/alert/yellow.gif'; } else { $indicator = 'images/alert/green.gif'; } } if ( $orders['orders_status_name']==$orders_status_array[3]) $indicator = 'images/icons/tick.gif'; // contact alert mod end Check fist in your database if your orders_status_id is set to 3, like me, for closed order (sent order) Else, change it accordingly to your id ($orders_status_array[your_id] Enjoy B) Thx to my firend pierrick for this code... :thumbsup: <{POST_SNAPBACK}> Great work Maverick and Pierrick! Just one small addition. Be sure to upload a small image called tick.gif to the images/alert/ folder. I will make an update to this contibution with the changes ASAP. Zipper Quote Link to comment Share on other sites More sharing options...
Guest Posted August 7, 2005 Share Posted August 7, 2005 Hi zipper it wasn't 'images/alert/tick.gif' as you said.. But: $indicator = 'images/icons/tick.gif'; This is an existing icon on my creload 6... That's the reason why I choose it... ;) Quote Link to comment Share on other sites More sharing options...
brightlaserlights Posted August 27, 2005 Share Posted August 27, 2005 (edited) Hi, I don't needed to upload any picture. I just overwrite the whole code from here, and I add this to the explaning list: <img src="images/icons/tick.gif" alt=""> = Order shipped.<br> Complete! Edited August 27, 2005 by brightlaserlights Quote 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.