Jump to content
Dr. Rolex

jQuery/Ajax Advanced Order Handler for osCommerce 2.3.3

Recommended Posts

I checked into some things.

 

First yes the PHP version is definitely 5.217.

 

Now I have a problem in that I have another domain on that account that is stuck on Joomla! 1.526 because there are custom components I had built that would all have to changed if I were to upgrade Joomla! and that is simply too expensive to get coded. I know from the Joomla! forums that that website would definitely not work with PHP 5.4. - It's a working site that earns money.

 

I am with HostMonster and there is no option to change the PHP to 5.3 - only 5.2 or 5.4

 

Anyway I went to the PHP error logs (on the same page but underneath the main error logs) and they are sorted by directory. There are no php error logs at all for the directory where this OSCommerce install is, absolutely none... I did a Ctrl+F on the page and that directory isn't there. I tried to access the /admin/get_table.php a couple of times, went back to the php_error page and still nothing at all...

 

I'm at a loss as to what to do now.. This is still a test site so no business is being lost as yet but unless I can batch print invoices then it will be useless for my purposes. The site is for Groupon offers and the ability to be able to run off lots of invoices in one batch is crucial..

 

Is there another way to get around this?

 

Thanks

 

 

Yes, there is a way. You can enable a PHP directive so the error messages are displayed on screen but it doesn't always work.

Change this code in admin/includes/application_top.php

error_reporting(E_ALL & ~E_NOTICE);

To this

  error_reporting(E_ALL);
  ini_set('display_errors', '1');

And then check the get_table.php page again and reply with any messages that are displayed.

 

You should also check if you get any javascript errors in the browser console.

In google chrome press CTRL + SHIFT + J to bring up the console and then go to get_table.php and reply with whatever messages you might have.

Share this post


Link to post
Share on other sites

Thanks very much for trying to help me - wow that brought up some errors and they seem to be largely related to the Discount Coupon module I installed which does actually work (when the site is in normal mode and not reporting like crazy :-)) - I thought this was a current addon - in fact pretty sure it is..

 

Here we go:

Notice: Use of undefined constant FILENAME_DISCOUNT_COUPONS - assumed 'FILENAME_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/catalog.php on line 48

Notice: Use of undefined constant BOX_CATALOG_DISCOUNT_COUPONS - assumed 'BOX_CATALOG_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/catalog.php on line 49

Notice: Use of undefined constant FILENAME_DISCOUNT_COUPONS - assumed 'FILENAME_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/catalog.php on line 50

Notice: Undefined variable: SID in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/functions/html_output.php on line 48

Notice: Use of undefined constant FILENAME_STATS_DISCOUNT_COUPONS - assumed 'FILENAME_STATS_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/reports.php on line 33

Notice: Use of undefined constant BOX_REPORTS_DISCOUNT_COUPONS - assumed 'BOX_REPORTS_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/reports.php on line 34

Notice: Use of undefined constant FILENAME_STATS_DISCOUNT_COUPONS - assumed 'FILENAME_STATS_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/reports.php on line 35

Notice: Undefined variable: SID in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/functions/html_output.php on line 48

 

 

Is it some kind of clash between the two addons?

 

The code the first 3 lines are referring to in catalog.php are:

       ///kgt - discount coupons
      array(
        'code' => FILENAME_PRODUCTS_EXPECTED,
        'title' => BOX_CATALOG_PRODUCTS_EXPECTED,
        'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED)
      ),     
      array(
     'code' => FILENAME_DISCOUNT_COUPONS,
     'title' => BOX_CATALOG_DISCOUNT_COUPONS,
     'link' => tep_href_link(FILENAME_DISCOUNT_COUPONS)
     )
     //end kgt - discount coupons

 

In fact those error messages appear whatever you click on in the OSC backend

Edited by uncoolthreads

Share this post


Link to post
Share on other sites

java script console reported:

 

Use of getUserData() or setUserData() is deprecated.  Use WeakMap or element.dataset instead. requestNotifier.js:63
SyntaxError: syntax error ckeditor.js:1
ReferenceError: CKEDITOR is not defined jquery.js:5
ReferenceError: goOnLoad is not defined get_table.php:1
 

 

thanks

Russ

Share this post


Link to post
Share on other sites


///kgt - discount coupons

array(

'code' => FILENAME_PRODUCTS_EXPECTED,

'title' => BOX_CATALOG_PRODUCTS_EXPECTED,

'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED)

),

array(

'code' => FILENAME_DISCOUNT_COUPONS,

'title' => BOX_CATALOG_DISCOUNT_COUPONS,

'link' => tep_href_link(FILENAME_DISCOUNT_COUPONS)

)

//end kgt - discount coupons

)

);

?>


To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

java script console reported:

 

Use of getUserData() or setUserData() is deprecated.  Use WeakMap or element.dataset instead. requestNotifier.js:63

SyntaxError: syntax error ckeditor.js:1

ReferenceError: CKEDITOR is not defined jquery.js:5

ReferenceError: goOnLoad is not defined get_table.php:1

 

 

thanks

Russ

 

Well, there's your error anyway.

 

There's something wrong with ckeditor.js. You can try with temporarily removing the line that loads that file (it's probably located in admin/includes/template_top.php) and then try again and see if you are still getting any errors.

 

Expand each line in the console to see which file that is the culprit. But likely, they're all attributed to ckeditor.js.

 

The line you're looking for will probably be something similar to this

<script type="text/javascript" src="js/ckeditor.js"></script>

An alternative to removing it would be to change it to something like this

<?php if (basename($PHP_SELF) != 'get_table.php') { ?>
<script type="text/javascript" src="js/ckeditor.js"></script>
<?php } ?>

Also, don't forget to switch back the PHP display_errors directive to 0 since the order_handler most probably will not work when you're displaying log messages in the layout.

The messages you posted from the PHP log are only Notices and can be ignored.

Edited by Dr. Rolex

Share this post


Link to post
Share on other sites
///kgt - discount coupons
      array(
        'code' => FILENAME_PRODUCTS_EXPECTED,
        'title' => BOX_CATALOG_PRODUCTS_EXPECTED,
        'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED)
      ),     
      array(
     'code' => FILENAME_DISCOUNT_COUPONS,
     'title' => BOX_CATALOG_DISCOUNT_COUPONS,
     'link' => tep_href_link(FILENAME_DISCOUNT_COUPONS)
     )
     //end kgt - discount coupons  
    )
  );
?>

Hi John, yes my catalog.php ends with those closing brackets and the end of php sign too:

    

 

Like this:

 

//end kgt - discount coupons  

    )

  );

?>

Above in the previous post I was just quoting the 3 lines mentioned in the error messages, 48-49-50.

 

Is that what you meant?

Share this post


Link to post
Share on other sites

Hi John, yes my catalog.php ends with those closing brackets and the end of php sign too:

    

 

Above in the previous post I was just quoting the 3 lines mentioned in the error messages, 48-49-50.

 

Is that what you meant?

yeah just wanted to be sure easy to make mistake with those quotes :thumbsup:


To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

Hi don't really like mixing in as no idea with the order handler but maybe if you are using  JohnAtYM  site wide install instructions for the ckeditor you should change to a manual install just including the specific text fields that you need .

 

The site wide install is actually a bad idea especially for SEO reasons and seems to be conflicting with the order editor as well

 

you really only need the html editor for category desc/product desc and maybe newsletter extra pages info etc.

 

Below you see the product description field targeted in admin category.php ('class="ckeditor")

 

I think one of the very first uploads has a nice manual install guide been meaning to update for 2.3. just no time at the minute.

 

Basically you are adding the ckditor class to whatever tep_draw_textarea_field  you want to use html

 <!-- <td class="main"><?php //echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (empty($pInfo->products_id) ? '' : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td>/-->
                <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (empty($pInfo->products_id) ? '' : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])), 'class="ckeditor"'); ?></td>
			

This is what I have in my template.top.php to call the editor

<?php
if (!defined('USE_CKEDITOR_ADMIN_TEXTAREA')) {
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) values ('', 'Use CKEditor', 'USE_CKEDITOR_ADMIN_TEXTAREA','true','Use CKEditor for WYSIWYG editing of textarea fields in admin',1,99,now(),'tep_cfg_select_option(array(\'true\', \'false\'),' )");
define ('USE_CKEDITOR_ADMIN_TEXTAREA','true');
}
if (USE_CKEDITOR_ADMIN_TEXTAREA == "true") {
?>
<script type="text/javascript" src="<?php echo tep_href_link('ext/ckeditor/ckeditor.js'); ?>"></script>
<script type="text/javascript" src="<?php echo tep_href_link('ext/ckeditor/adapters/jquery.js'); ?>"></script>
<?php
}
?>

Regards

John

 

PS: Think Burt as also an alternative install guide on his blog clubosc

 

http://www.clubosc.com/easiest-install-ever-fck-editor.html

Edited by joli1811

To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

ok I think I understand John but like I said I'm no programmer :-(

I have noticed the ckditor loading in places where it wasn't needed.

 

On Monday I'll reverse all the instructions for the ckditor install and then first of all see if Order Handler works - Once I have sorted that (if I do) then I'll look for this manual install of ckditor and try that out.

 

Phew! (so much for just trying to sell something online with a one click install from Cpanel!! ;)

 

Thanks for your input John and also thanks to Jonas

 

Russ

 

My guess is these posts will continue B)

Share this post


Link to post
Share on other sites

Well who said it was easy to make a million :D hahah the devil in me .


To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

Hi Dr. Rolex, Im new to OSC, thanks for your addon, it helps alot!

I got OSC 2.3.4 & Order Handler v3(28/7) fresh installed with no problem, then I did some test both on Chrome/Firefox, and got few issues:

1. Under Firefox only: right click on order table, the context menu pop up with 5 actions(Expand Order, Edit, Duplicate, Send Mail and Delete), but it doesnt do anything when you click on any of the action, I got the error message from firebug:

"Error: ReferenceError: event is not defined
Source File: ....01_order_handler_rev3.min.js"

Seems like it caused by "if(0!==event.button){return false}" as Firefox doesnt read "event" like Chrome or IE.


2. Under Firefox only: during action "Expand Order", when I changing price for any items, the column "Order Total" value from order table changes to "undefined" (Chrome works fine).


3. Under both Chrome/Firefox: right click on order table, click "Expand Order" from context menu then close that expand panel, click "Expand Order" again with same order from context menu, but the expand panel will not show up again.


4. Under Chrome only: I made 3 orders for testing, with status "Pending" "Processing" and "Delivered", when I open the main page(get_table.php), Firefox showing all orders with no problem, but Chrome only showing 1 order with status "Pending".


5. Whatever how many times you updated status and append comments, when refresh the main page, the column "Comments" will always show the first/earlist comments.


Not sure if these issues just for me or not, please have a look, thanks again!

Share this post


Link to post
Share on other sites

Hi guys well I restored to previous state before CKeditor and Order Handler. Then re-installed Order Handler.

 

There is still a blank page there as before even without CKEditor so although there may have been problems with CKEditor it seems that's not the only problem I have. :(

 

post-330229-0-71154800-1408360758_thumb.jpg

In the Browser Console it now shows this:

GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 437ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms]
Error in parsing value for 'background-image'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Expected 'none' or URL but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-border-radius'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-background-clip'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-background-origin'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-background-size'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Expected 'none' or URL but found 'alpha('.  Error in parsing value for 'filter'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property 'transformtransform'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property 'transformopacitytransform'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property 'opacitytransformtransform'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property 'opacity-moz-transform-moz-transform'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-box-shadow'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property 'zoom'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Expected declaration but found '*'.  Skipped to next declaration. 01_order_handler_rev3.min.css:21
Unknown property 'user-select'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Error in parsing value for 'background'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Expected media feature name but found '-webkit-min-device-pixel-ratio'. 01_order_handler_rev3.min.css:21
Expected media feature name but found '-o-min-device-pixel-ratio'. 01_order_handler_rev3.min.css:21
Unknown property '-moz-border-radius-topleft'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-border-radius-topright'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-border-radius-bottomleft'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-border-radius-bottomright'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown pseudo-class or pseudo-element '-o-prefocus'.  Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21
Unknown property 'behavior'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property 'opacity-webkit-transform-ms-transformtransformopacity'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Keyframe rule ignored due to bad selector. 01_order_handler_rev3.min.css:21
Expected 'none' or URL but found 'Alpha('.  Error in parsing value for 'filter'.  Declaration dropped. jquery-ui-1.10.4.min.css:7
Expected 'none' or URL but found 'alpha('.  Error in parsing value for 'filter'.  Declaration dropped. jquery-ui-1.10.4.min.css:7
Error in parsing value for 'cursor'.  Declaration dropped. stylesheet.css:46
Unknown property '-moz-border-radius'.  Declaration dropped. stylesheet.css:87
Error in parsing value for 'cursor'.  Declaration dropped. stylesheet.css:198
Error in parsing value for 'cursor'.  Declaration dropped. stylesheet.css:203
GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 281ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 62ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms]
GET http://www.uncoolthreads.co.uk/admin/includes/stylesheet.css [HTTP/1.1 304 Not Modified 327ms]
Unknown property '-moz-osx-font-smoothing'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown property '-moz-transform-moz-transform'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown pseudo-class or pseudo-element '-webkit-inner-spin-button'.  Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21
Unknown pseudo-class or pseudo-element '-webkit-search-cancel-button'.  Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21
Expected color but found 'auto'.  Expected color but found '-webkit-focus-ring-color'.  Expected end of value but found '-webkit-focus-ring-color'.  Error in parsing value for 'outline'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Expected end of value but found '\9 '.  Error in parsing value for 'margin-top'.  Declaration dropped. 01_order_handler_rev3.min.css:21
Unknown pseudo-class or pseudo-element '-ms-input-placeholder'.  Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21
Unknown pseudo-class or pseudo-element '-webkit-input-placeholder'.  Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21
GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 546ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 93ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms]
POST https://safebrowsing.google.com/safebrowsing/downloads [HTTP/1.1 200 OK 140ms]
GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChVnb29nLWJhZGJpbnVybC1zaGF2YXIQARidiAIgsIgCKgUwhAAAATIHHYQAAP__Bw [HTTP/1.1 200 OK 125ms]
GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChVnb29nLWJhZGJpbnVybC1zaGF2YXIQABiv5AEguOQBKgU2cgAABzIFMHIAAD8 [HTTP/1.1 200 OK 31ms]
GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChNnb29nLW1hbHdhcmUtc2hhdmFyEAEY1dMIIOjTCCoF5SkCAA8yB9UpAgD__wA [HTTP/1.1 200 OK 47ms]
GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChNnb29nLW1hbHdhcmUtc2hhdmFyEAAY6Y8JIJCQCSoJ7EcCAP____8fMgXpRwIABw [HTTP/1.1 200 OK 46ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 63ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 218ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 47ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 125ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 63ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 141ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 63ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 141ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 47ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 125ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 62ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms]
GET http://tromboneforum.org/index.php [HTTP/1.1 200 OK 422ms]
GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 1108ms]
GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 936ms]
GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 983ms]
GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 1186ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 234ms]
GET http://www.uncoolthreads.co.uk/admin/modules.php [HTTP/1.1 200 OK 499ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 124ms]
GET http://www.uncoolthreads.co.uk/admin/includes/stylesheet.css [HTTP/1.1 304 Not Modified 171ms]
GET http://www.uncoolthreads.co.uk/admin/images/pixel_trans.gif [HTTP/1.1 304 Not Modified 375ms]
GET http://www.uncoolthreads.co.uk/admin/images/icon_arrow_right.gif [HTTP/1.1 304 Not Modified 344ms]
GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 452ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 125ms]
GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 78ms]
GET http://xml.alexa.com/data [HTTP/1.1 200 OK 235ms]

 

 

Don't know what any of this means..

 

Share this post


Link to post
Share on other sites

Hi guys well I restored to previous state before CKeditor and Order Handler. Then re-installed Order Handler.

 

There is still a blank page there as before even without CKEditor so although there may have been problems with CKEditor it seems that's not the only problem I have. :(

 

attachicon.gifrev.jpg

In the Browser Console it now shows this:

 

Don't know what any of this means..

 

You need to filter the console output. :)

 

If you're using Firefox, disable all logging except Javascript (JS) -> Errors and then try again.

Or you can try Chromes console instead, it will filter by default.

Share this post


Link to post
Share on other sites

Hi Dr. Rolex, Im new to OSC, thanks for your addon, it helps alot!

 

I got OSC 2.3.4 & Order Handler v3(28/7) fresh installed with no problem, then I did some test both on Chrome/Firefox, and got few issues:

 

1. Under Firefox only: right click on order table, the context menu pop up with 5 actions(Expand Order, Edit, Duplicate, Send Mail and Delete), but it doesnt do anything when you click on any of the action, I got the error message from firebug:

 

"Error: ReferenceError: event is not defined

Source File: ....01_order_handler_rev3.min.js"

 

Seems like it caused by "if(0!==event.button){return false}" as Firefox doesnt read "event" like Chrome or IE.

 

 

You can comment or remove that line and see what happens. So in the unminified file ./admin/includes/modules/order_handler/js/01_03_order_handler_rev3_module.js comment this line

if ( 0 !== event.button ) return false;

Or just remove/comment the code from the minified file (the code you mentioned in your post above).

 

 

 

 

2. Under Firefox only: during action "Expand Order", when I changing price for any items, the column "Order Total" value from order table changes to "undefined" (Chrome works fine).

 

Find this code in ./admin/includes/modules/order_handler/js/01_03_order_handler_rev3_module.js

                            newPrice              = $( products_total_html ).find( "#ot_total_value" )[0].innerText;

Replace With:

                                        newPrice              = $( products_total_html ).find( "#ot_total_value" )[0].innerHTML;

 

3. Under both Chrome/Firefox: right click on order table, click "Expand Order" from context menu then close that expand panel, click "Expand Order" again with same order from context menu, but the expand panel will not show up again.

 

Yeah, I'm aware of this bug. I don't know why it's behaving like this. Since I don't use the right click menu myself I haven't bothered to fix it but I'll take a look at it when I can.

 

 

 

4. Under Chrome only: I made 3 orders for testing, with status "Pending" "Processing" and "Delivered", when I open the main page(get_table.php), Firefox showing all orders with no problem, but Chrome only showing 1 order with status "Pending".

 

The order handler saves your previous selection in a cookie, so if you had the "Sort orders" drop down to "Pending" before then it will be there next time you visit the page as well.  

 

 

 

 

5. Whatever how many times you updated status and append comments, when refresh the main page, the column "Comments" will always show the first/earlist comments.

 

Yep, that's the way I want it. ;)

If you want to display e.g. the latest comment instead then you can change the statement in ajax_update.php that fetches all the orders

    $orders_query_raw = "SELECT o.orders_id, o.customers_id, o.customers_name, o.customers_company, o.delivery_street_address, o.delivery_suburb, o.delivery_city, o.delivery_postcode, o.delivery_state, o.delivery_country, o.customers_telephone, o.customers_email_address, o.date_purchased, o.orders_status, o.payment_method, MIN(osh.comments) as comments, ot.text AS order_total, (SELECT orders_status_name FROM orders_status WHERE orders_status_id = o.orders_status AND language_id = ?) as orders_status_name, (SELECT SUM(products_quantity) FROM orders_products WHERE orders_id = o.orders_id GROUP BY orders_id) as products_quantity FROM orders o JOIN orders_status_history osh USING (orders_id) JOIN orders_total ot USING (orders_id) WHERE ot.class = 'ot_total' $status $specific GROUP BY orders_id ORDER BY $order_by $page_limit";

Replace with

    $orders_query_raw = "SELECT o.orders_id, o.customers_id, o.customers_name, o.customers_company, o.delivery_street_address, o.delivery_suburb, o.delivery_city, o.delivery_postcode, o.delivery_state, o.delivery_country, o.customers_telephone, o.customers_email_address, o.date_purchased, o.orders_status, o.payment_method, MAX(osh.comments) as comments, ot.text AS order_total, (SELECT orders_status_name FROM orders_status WHERE orders_status_id = o.orders_status AND language_id = ?) as orders_status_name, (SELECT SUM(products_quantity) FROM orders_products WHERE orders_id = o.orders_id GROUP BY orders_id) as products_quantity FROM orders o JOIN orders_status_history osh USING (orders_id) JOIN orders_total ot USING (orders_id) WHERE ot.class = 'ot_total' $status $specific GROUP BY orders_id ORDER BY $order_by $page_limit";

This should display the latest comment, but I haven't tried it myself. It might need some additional fix to work.

Share this post


Link to post
Share on other sites

You need to filter the console output. :)

 

If you're using Firefox, disable all logging except Javascript (JS) -> Errors and then try again.

Or you can try Chromes console instead, it will filter by default.

ok I opened get_table.php in chrome - this time there was just one message

Uncaught ReferenceError: goOnLoad is not defined

 

On clicking the link on the right that said get_table.php it brought up some code and then I think it is referring to the <body onload="goOnLoad();">

 

??

Edited by uncoolthreads

Share this post


Link to post
Share on other sites

ok I opened get_table.php in chrome - this time there was just one message

On clicking the link on the right that said get_table.php it brought up some code and then I think it is referring to the <body onload="goOnLoad();">

 

??

 

This is probably "leftover" code from CKEditor or some other Add-On.

 

Look in your admin/includes/template_top.php for <body onload="goOnLoad();"> and change it to <body>

Share this post


Link to post
Share on other sites

This is probably "leftover" code from CKEditor or some other Add-On.

 

Look in your admin/includes/template_top.php for <body onload="goOnLoad();"> and change it to <body>

 

I looked through my addons folder and I added this code instead of the standard body tag when installing AJAX Attribute Manager which is great for adding attributes in the create product window. I'm assuming AJAX Attribute Manager won't work if I change it back to <body> (otherwise why change it?)  - Jonas I know this isn't your addon and your concern is with Order Handler but is there a code fix that would allow both to work?

 

thanks

Russ

Share this post


Link to post
Share on other sites

I looked through my addons folder and I added this code instead of the standard body tag when installing AJAX Attribute Manager which is great for adding attributes in the create product window. I'm assuming AJAX Attribute Manager won't work if I change it back to <body> (otherwise why change it?)  - Jonas I know this isn't your addon and your concern is with Order Handler but is there a code fix that would allow both to work?

 

thanks

Russ

 I made the quick change in template-top just to see if it would get Order Handler to work but I'm still looking at the same blank page.

 

phew...

Share this post


Link to post
Share on other sites

yes you do not have to use

onload="goOnLoad();">

 

will check there is an alternative


To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

Look maybe still not the right place but an Attribute Manager manager install without the goony show is

********AJAX ATTRIBUTE MANAGER INSTALL**********
						 
********Upload the yellow attributeManager  folder to admin *********
it should be at the same level as the yellow image folder and yellow includes folder  etc.....

********Open********* 

/catalog/admin/categories.php**********

*** FIND ***
Approx line 255
  tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'");
   }


*******BELOW ADD*********

//BOF - Zappo - Option Types v2 - AttribManager - ONE LINE - AJAX Attribute Manager plugin
  require_once('attributeManager/includes/attributeManagerUpdateAtomic.inc.php'); 


*** FIND ***

Approx line 544
  <tr bgcolor="#ebebff">
            <td class="main"><?php echo TEXT_PRODUCTS_PRICE_GROSS; ?></td>
            <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price_gross', $pInfo->products_price, 'onkeyup="updateNet()"'); ?></td>
          </tr>
		  
*******BELOW ADD*********	  

<!-- BOF - Zappo - Option Types v2 - AttribManager - AJAX Attribute Manager plugin //-->
          <tr>
          	<td colspan="2"><?php require_once( 'attributeManager/includes/attributeManagerPlaceHolder.inc.php' )?></td>
          </tr>
<!-- EOF - Zappo - Option Types v2 - AttribManager - AJAX Attribute Manager plugin //-->


*******Open********* 

/catalog/admin/includes/template_top.php

*** FIND ***

Approx line 43
<script type="text/javascript" src="includes/general.js"></script>

*******BELOW ADD*********

//BOF - Zappo - Option Types v2 - AttribManager - ONE LINE - AJAX Attribute Manager plugin
<?php require_once( 'attributeManager/includes/attributeManagerHeader.inc.php' )?>

*************************************************************************************************************************************************

attributeManager.zip


To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

Now no idea if it helps it is just an alternative install

 

You will have to replace the yellow attributeManager folder or it will not work

Edited by joli1811

To improve is to change; to be perfect is to change often.

 

Share this post


Link to post
Share on other sites

3. Under both Chrome/Firefox: right click on order table, click "Expand Order" from context menu then close that expand panel, click "Expand Order" again with same order from context menu, but the expand panel will not show up again.

 

To fix this, find this line in 01_03...module.js

$( this ).find( "span.expand_order" ).click();

Replace with

$( this ).find( "td.expand_order" ).find( "span" ).click();

Share this post


Link to post
Share on other sites

I'd like to thank you and Joli for your help but I have decided to go for a different option to OSCommerce. I have spent 2 weeks configuring addons and still am nowhere near a finished result. I believe  most of these addons should simply be part of the core and not require changing so many files and causing conflicts between different addons etc. I just wanted an independent online shop for my existing busy eBay business not a new career configuring this. I have spent so long on this I am neglecting my active business and that can't be a good idea.

 

Again thanks for your help and advice, you have both been extremely helpful.

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

×