Batch Order Status Update

[torvista]

Mod - Batch Order Update, for Zen Cart 1.5.7.

This mod is for the Admin, Order listing page. It is multi-language.

When an order status filter is selected:
1) A checkbox is added to each order to allow multiple selection multiple selection.
2) A dropdown is displayed to select the new status for the selected orders.
The orders can be updated in one action, emails can be optionally sent.



How it works
The list of orders and their languages is stored in an array and updated one-by-one using redirects and the language parameter to send each email in the order language.
When complete, the admin language is reset to it's original language.
Clumsy, slow, inefficient...but until the whole order email process is reworked, it will have to do. But it works.

Get it here:
https://github.com/torvista/Zen_Cart-Batch_Order_Update


Use GitHub to see what happened and when. Use a Github client to keep up to date. I use GitKraken.

After downloading, use GitHub to see what happened subsequently and when. Use a Github client to keep up to date. I use GitKraken.

Report errors on GitHub as they should be temporary and here they only clutter up the thread.

If someone wants the challenge to make it look pretty/fit well into the responsive structure, go right ahead!

[torvista]

Well, that opened the flood-gates of pent-up demand!

[JimmyV]

Summertime kids are off school. Definitely a valid plugin will test it out.

[Carbonless]

I installed on my test server 1.5.7c 7.4 php - also running Comment Boiler plate

merged the 2 orders.php files and when I select a status to filter, the page displays as follows:

and here is the error log... not sure what to trace.

[31-Jul-2021 04:14:29 UTC] PHP Fatal error: Uncaught Error: Call to undefined function zen_draw_order_status_dropdown_batch_update() in /admin/orders.php:635
Stack trace:
#0 /admin/index.php(11): require()
#1 {main}
thrown in /admin/orders.php on line 635

[31-Jul-2021 04:14:29 UTC] Request URI: /XXkcaz00/index.php?cmd=orders&status=1, IP address: xxxxxxxxx
--> PHP Fatal error: Uncaught Error: Call to undefined function zen_draw_order_status_dropdown_batch_update() in /admin/orders.php:635
Stack trace:
#0 /admin/index.php(11): require()
#1 {main}
thrown in /admin/orders.php on line 635.

[torvista]

Fixed... got lost in the forest of comparisons between versions.

[Carbonless]

Downloaded the newest GitHub update and merged... works! Great Contribution!

[Carbonless]

Downloaded the newest GitHub update and merged... works! Great Contribution!

BUG UPDATE

The batch Status is working... HOWEVER, it broke the ability to update the status within an order.

Bugfile

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: 91.242.162.12
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[25-Jul-2021 07:20:45 UTC] Request URI:  /index.php?cPath=43&main_page=index&zenid=ks9nrlduulcisu8dr55qmlpra1,  IP address: xxxxx
#1  mysqli_connect() called at [/includes/classes/db/mysql/query_factory.php:63]
#2  queryFactory->connect() called at [/includes/init_includes/init_database.php:23]
#3  require(/includes/init_includes/init_database.php) called at [/includes/application_top.php:189]
#4  require(/includes/application_top.php) called at [/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or  directory in /includes/classes/db/mysql/query_factory.php on line 63.

[torvista]

The problem with ZC157 is the listing page and details page use the same form attribute name for status.

I did this code based on ZC158 and it's proved impossible to backport to ZC157 without using the unique form attributes introduced in ZC158.
Github is updated with changes.

[Carbonless]

The problem with ZC157 is the listing page and details page use the same form attribute name for status.

I did this code based on ZC158 and it's proved impossible to backport to ZC157 without using the unique form attributes introduced in ZC158.
Github is updated with changes.

Are you stating that it then wont work with 1.5.7c, or are you saying the github changes include certain files from 1.5.8 and can be used with 1.5.7c?

[torvista]

The orders file contains snippets from ZC158 to enable this to work in ZC157.