Delivery control

I'm on ZC v1.3.8a.

Click on "New Delivery" which takes me to

http://www.mysite.com/shop/admin/delivery_new.php?action=new

All that shows is the 'Delivery' title and nothing else.

Suggestions?

to thebeadyeye

Hello.
I have the same problem.

I have not found an opportunity to solve a problem, but for the beginning in delivery_new.php I have added $action = $ _ REQUEST [' action ']; in the beginning of a file.
It does not return value of a variable $action.

Hi,

Do you mean before:

require('includes/application_top.php');

I did that and i got this:

Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE or '$' in /home/mysite/public_html/shop/admin/delivery_new.php on line **22

**I'm not all that experienced with php code.

Is yours working?

Thanks!

Line 35

// DELIVERY CONTROL by Loutka 31.12.2007
//
require('includes/application_top.php');

define('ADDPRODUCT_TEXT_SELECT_PRODUCT', 'Select product...');
define('ADDPRODUCT_TEXT_CONFIRM_QUANTITY', ' Enter product quantity.');
define('ADDPRODUCT_TEXT_CONFIRM_ADDNOW', 'Add product to this delivery');

// require(DIR_WS_CLASSES . 'delivery.php');
/*
$db->Execute("update " . TABLE_PRODUCTS . "
set products_date_available = NULL
where to_days(now()) > to_days(products_date_available)");

*/
$action = $ _ REQUEST [' action '];
if (zen_not_null($action)) {
switch ($action) {

It still doesn't like it. I'm getting:

Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE or '$' in /home/mysite/public_html/shop/admin/delivery_new.php on line **36

**Are you on ZC Version 1.3.8a?

$action = $_REQUEST['action']; - yes
$action = $ _ REQUEST [' action ']; - no

Without blanks.

I have found a problem.
At present I modify all module.
I shall make, I shall lay out.

A problem in it (delivery_new.php):
$action = (isset($_GET['action']) ? $_GET['action'] : '');
$dID = zen_db_prepare_input($_GET['dID']);
$step = zen_db_prepare_input($_POST['step']);
$add_product_categories_id = zen_db_prepare_input($_POST['add_product_categories_id']);
$add_product_products_id = zen_db_prepare_input($_POST['add_product_products_id']);
$add_product_quantity = zen_db_prepare_input($_POST['add_product_quantity']);

The module works on 70%.
It is necessary to correct still "Add product".
I work above it.

:clap:
It is OK.
If you do not use multilanguage it is necessary to remove:

and pd.language_id='" . $_SESSION['languages_id'] ."'

delivery.php
Line 243

and

delivered.php
Line 217

and

anddelivery_new.php
Line 234

jakumpe:

When I try to install the SQL Patch through ZenCart it comes back as failed, when I try to install the SQL Patch through PHPMyAdmin I get an error that says
Error

SQL query:

CREATE TABLE delivery ( del_id double NOT NULL AUTO_INCREMENT ,
del_name varchar( 60 ) default NULL ,
del_date date default '0000-00-00',
del_status tinyint( 1 ) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY ( del_id )
) CREATE TABLE delivery_products ( del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
)
**MySQL said: **
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE delivery_products (
del_id double NOT NULL default '0',
`' at line 10

I got this message when I tried to install the module today as well, sadly I lack any coding experience other then edits I am told to make - would anyone care to try and help a noob out? at present the only other mods i have installed are super orders and google analytics.

Thanks,

Oisín

Raghallaigh:

I got this message when I tried to install the module today as well, sadly I lack any coding experience other then edits I am told to make - would anyone care to try and help a noob out? at present the only other mods i have installed are super orders and google analytics.

Thanks,

Oisín

You have forgotten " ; " in the end

CREATE TABLE delivery ( del_id double NOT NULL AUTO_INCREMENT ,
del_name varchar( 60 ) default NULL ,
del_date date default '0000-00-00',
del_status tinyint( 1 ) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY ( del_id )
) CREATE TABLE delivery_products ( del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
);

If that does not work try to remove " ` "

CREATE TABLE delivery (del_id double NOT NULL AUTO_INCREMENT ,
del_name varchar(60) default NULL ,
del_date date default '0000-00-00',
del_status tinyint(1) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY (del_id)
) CREATE TABLE delivery_products (del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
);

Hi

I am late to this thread, so I hope you are still reading it.

I have installed the Delivery Control, created the database tables and manually inserted 1 test record into each.

I can see the delivery table and view the details of the one "purchase order", but none of the buttons for New Delivery or Add Product are working. They display the PHP page name they should go to, but nothing happens.

What could I have done wrong?

Thanks.

I've installed the new version of this module. It works except that when the delivery is received it writes double the amount of stock into each item. Any suggestions?

I just installed this on the lastest zen version.

I get this error when going to delivery.php.

1146 Table 'antiocho_zc1.products' doesn't exist
in:
[SELECT d.prod_id AS id, d.prod_quantity AS quantity, p.products_model AS model, pd.products_name AS name FROM delivery_products d LEFT JOIN products p ON d.prod_id = p.products_id LEFT JOIN products_description pd ON d.prod_id = pd.products_id WHERE d.del_id = '']

Any help?? TY

thebeadyeye:

I've installed the new version of this module. It works except that when the delivery is received it writes double the amount of stock into each item. Any suggestions?
I have this same exact issue on zencart 1.3.7.1 and latest mod version.

Everything else seems to be working fine.. Apart from a minor glitch with the popup calendar but it's not much of an issue..

Would really like to be able to use this mod on a live site, and it seems almost ready apart from adding double the amount of stock.

Please help..

After a little more testing with this mod...

I have noticed that if I do a page refresh (f5) on the delivered page prior to clicking the (mark as delivered) button the stock quantity is added correctly. :huh:

However as stated before if I don't do a page refresh in the delivery section it adds double the quantity to the products..

Is there a way of making it do some kinda page refresh automatically before I hit the (mark as delivered) button. So it adds the right quantity?

BTW it also subtracts double the quantity, unless I do a page refresh in the same manor..

Hope this makes sense...

hi
ZC version. 1.3.8
delivery control version the latest

hope the forum is still active,
i tried to install the delivery control
i created the database manually
and then i get error like this

1146 Table 'shop.products' doesn't exist
in:
[SELECT d.prod_id AS id, d.prod_quantity AS quantity, p.products_model AS model, pd.products_name AS name FROM delivery_products d LEFT JOIN products p ON d.prod_id = p.products_id LEFT JOIN products_description pd ON d.prod_id = pd.products_id WHERE d.del_id = '']

i tried to edit the delivery.php and delivered.php
from

LEFT JOIN products p
ON d.prod_id = p.products_id

LEFT JOIN products_description pd
ON d.prod_id = pd.products_id

to

LEFT JOIN zc_products p
ON d.prod_id = p.products_id

LEFT JOIN zc_products_description pd
ON d.prod_id = pd.products_id

because my ZC database is using zc_ as prefix

after that i can add new delivery, but i noticed there are some errors

• got some problem with date selector, cannot choose the date corretly
• i cannot add new product., after i added, it goes back to admin home page, no confirmation, anything i should do?

anyone can help me?

many thanks
all helps are appreciated coz i kind of need this mod :blush:

I have got to the same stage as you - is the original author still developing this mod or has he laid it to rest .

I get the blank page after adding product too.
and the date selector only works if you manually enter the month in .

Anyone working with this OK ?

i managed to change the date so i dont have to add the month manually by changing the line in delivery_new.php
line 209

from

echo "<td valign='top'><div id='spiffycalendar' class='text'> </div><script language='javascript'>del_date.writeControl(); del_date.dateFormat='yyyy-mm-dd';</script></td>";    

to

echo "<td valign='top'><div id='spiffycalendar' class='text'> </div><script language='javascript'>del_date.writeControl(); del_date.dateFormat='yyyy-MM-dd';</script></td>"; 

from yyyy-mm-dd to yyyy-MM-dd
anyone can help us with adding new products?

many thanks

hallo, anyone using delivery control who has same problem? :blush: