sql error on vendor payment

  • Posts: 377
  • Thank you received: 7
10 years 6 months ago #159616

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

Attachments:

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

  • Posts: 26166
  • Thank you received: 4029
  • MODERATOR
10 years 6 months ago #159618

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.

  • Posts: 377
  • Thank you received: 7
10 years 6 months ago #159624

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.

  • Posts: 26166
  • Thank you received: 4029
  • MODERATOR
10 years 6 months ago #159634

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)

			$vendorPayOrderType = 'sale';

			$order->history->history_notified = 1;
			$order->order_billing_address_id = $this->getAddressId($vendor);
By
			$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
	public function afterCreate(&$order, &$send_email) {
		if(empty($order) || empty($order->order_type))
			return;
		if($order->order_type == 'subsale')
			$send_email = false;
By
	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,


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.

  • Posts: 377
  • Thank you received: 7
10 years 6 months ago #159644

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.

  • Posts: 26166
  • Thank you received: 4029
  • MODERATOR
10 years 6 months ago #159646

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,


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.

Moderators: Obsidev
Time to create page: 0.055 seconds
Powered by Kunena Forum