sql error on vendor payment

Dibben
Topic Author
Offline

12 years 3 months ago #159616 by Dibben

sql error on vendor payment was created by Dibben

Hi Jerome, i don't know if this is a bug but on the payment page for a vendor. (attached) I click onto it so i can make payment for orders that the vendor is owed. However if i tick them and select manual i think that i would be generating invoice so i can mark them as paid but then i click on 'generate invoice' (I assume to generate invoice for the collective amounts i owe to the vendor) it comes up with an sql error. I can't see otherwise how i can track which orders i have paid the vendor for and which i still owe them money?

Thanks

Alex

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

12 years 3 months ago #159618 by Jerome

Replied by Jerome on topic sql error on vendor payment

Hi Alex,

Please indicate your HikaShop and HikaMarket version number.
Every time you post a bug or something, indicate this information, please !

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Dibben
Topic Author
Offline

12 years 3 months ago #159624 by Dibben

Replied by Dibben on topic sql error on vendor payment

Apologies

You have the latest stable version of HikaMarket Multivendor: 1.4.1
You have the latest stable version of HikaShop Business: 2.3.1

Thanks
Alex

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

12 years 3 months ago #159634 by Jerome

Replied by Jerome on topic sql error on vendor payment

Hi Alex,

I reproduced your problem and I am working on some patchs.
It affect mainly two files, the class order and the class vendor.

Class vendor (function pay)

Code:

			$vendorPayOrderType = 'sale';

			$order->history->history_notified = 1;
			$order->order_billing_address_id = $this->getAddressId($vendor);

Code:

			$vendorPayOrderType = 'sale';

			$order->history->history_notified = 1;
			$order->order_billing_address_id = $this->getAddressId($vendor);

			if(empty($order->hikamarket))
				$order->hikamarket = new stdClass();
			$order->hikamarket->do_not_process = true;

Class order

Code:

	public function afterCreate(&$order, &$send_email) {
		if(empty($order) || empty($order->order_type))
			return;
		if($order->order_type == 'subsale')
			$send_email = false;

Code:

	public function afterCreate(&$order, &$send_email) {
		if(empty($order) || empty($order->order_type))
			return;
		if($order->order_type == 'subsale')
			$send_email = false;

		if(isset($order->hikamarket->do_not_process))
			return;

It should fix the problem.
I have also changed some design problem but it is mainly "cosmetic".

Regards,

Please Log in or Create an account to join the conversation.

Dibben
Topic Author
Offline

12 years 3 months ago #159644 by Dibben

Replied by Dibben on topic sql error on vendor payment

Ok great, which php files should i patch or is there more to add once you have finished working on the patches?

Thanks

Alex

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

12 years 3 months ago #159646 by Jerome

Replied by Jerome on topic sql error on vendor payment

Hi,

With the two modifications will be good to fix your problem.
Order class = administrator/components/com_hikamarket/classes/order.php
Vendor class = administrator/components/com_hikamarket/classes/vendor.php

Regards,

Please Log in or Create an account to join the conversation.

Moderators: Obsidev

Time to create page: 0.194 seconds