1 Attachment(s)
Batch Order Status Update
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.
Attachment 19664
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!
Re: Batch Order Status Update
Well, that opened the flood-gates of pent-up demand!
Re: Batch Order Status Update
Summertime kids are off school. Definitely a valid plugin will test it out.
1 Attachment(s)
Re: Batch Order Status Update
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:
Attachment 19695
and here is the error log... not sure what to trace.
HTML Code:
[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.
Re: Batch Order Status Update
Fixed... got lost in the forest of comparisons between versions.
Re: Batch Order Status Update
Downloaded the newest GitHub update and merged... works! Great Contribution!
Re: Batch Order Status Update
Quote:
Originally Posted by
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
HTML Code:
[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.
Re: Batch Order Status Update
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.
Re: Batch Order Status Update
Quote:
Originally Posted by
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.
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?
Re: Batch Order Status Update
The orders file contains snippets from ZC158 to enable this to work in ZC157.
Re: Batch Order Status Update
will install and test NOW...
Re: Batch Order Status Update
Tested on 1.5.7c works without error. GREAT JOB!
attempting now to merge with with my existing file that includes Boiler Plate Comments
Re: Batch Order Status Update
Quote:
Originally Posted by
Carbonless
Tested on 1.5.7c works without error. GREAT JOB!
attempting now to merge with with my existing file that includes Boiler Plate Comments
Merged with Boiler Plate Comments and both function perfectly!! THANK YOU!
