Products of storage

[crawe1]

Hi,
How to block the sale of a product only to the qty on the stock?

[vovpff]

There is no mechanisms available in system. There is some ways how to implement this but you need programmer.

[crawe1]

Hi @vovpff @davide-alghi @mariuszkrzaczkowski

I try to knowed how to add this validate but i have problem with idea.

1. try to add in the template inventory field condition but it work only in edit field when item is exist.
   {if isset($ITEM_DATA['name']) && ($MODULE_NAME == "IGDN" || $MODULE_NAME == "IGDNC")} {assign var=REFERENCE_RECORD value=Vtiger_Record_Model::getInstanceById($ITEM_DATA['name'], $REFERENCE_MODULE)} {if $REFERENCE_RECORD && $REFERENCE_RECORD->has('qtyinstock')} {assign var=QTY_PARAM value=$REFERENCE_RECORD->getDisplayValue('qtyinstock')} {if $QTY_PARAM < $VALUE} echo '<script>alert("Podana wartość jest mniejsza niż ilość produktów na magazynie!")</script>' {/if} {/if} {/if}
   but this is popup and is not automaticly on real-time.
2. i dont know how to send variable (from igdn->"qtyinstock") to validator FieldValidator.js and i want this but i need to do only when i am in IGRN IGRNC module.

how do you think how to do it?

[vovpff]

Sorry but I don't have ideas

[mariuszkrzaczkowski]

handler pre save or limit the list of products to choose from
both requires a developer

[mariuszkrzaczkowski]

add your change to Pull requests

[crawe1]

At first @mariuszkrzaczkowski @vovpff thank you for your commitment

hmm i dont know why :) but i have problem with run sequence.
first example to use:

1. record is exist: when edit values and when i click on save button they get old records how to get visible value ?
   Array
   (
   [10570] => 960.000 <- this is old value
   )
   Array
   (
   [10570] => 0.000 <- this is product QTY from Vtiger_products i change in future to on u_yf_istorages_products but this is test.
   )

2. record in not exist, create new: i can get ids

problem is in " $inventoryData = \Vtiger_Inventory_Model::getInventoryDataById($idrecord, $recordModel->getModuleName());"

i need get values from display view, this function upper get value from inventory. Is any exists model for this situation ?

I used handler of name EditViewPreSave.

code

<?php


/**
 * IGDN_Handler class.
 */
class IGDN_IGDNHandler_Handler

{

public function editViewPreSave(App\EventHandler $eventHandler)

{
	
	$recordModel = $eventHandler->getRecordModel();
	

   


	$idrecord = $recordModel->getId();	

	$inventoryData = \Vtiger_Inventory_Model::getInventoryDataById($idrecord, $recordModel->getModuleName());


	$inventoryDataTmp = array_column($inventoryData, 'qty', 'name' );
	
	$inventoryDataKey = array_keys($inventoryDataTmp);
	$inventoryDataKeyQuery = implode(",",$inventoryDataKey);
	
	$queryProductsQty = 'SELECT vtiger_products.productid,
		vtiger_products.qtyinstock
		FROM vtiger_products
		WHERE vtiger_products.productid IN ('.$inventoryDataKeyQuery.' )';
	$resultProductQty = \App\Db::getInstance()->createCommand($queryProductsQty)->queryAll();
	$inventoryDataTmp2 = array_column($resultProductQty, 'qtyinstock', 'productid' );
	
	$diffArrayValue = array();
	
		foreach($inventoryDataTmp as $key => $value){
			$diffArrayValue[$key] = $inventoryDataTmp2[$key] - $inventoryDataTmp[$key];
		}
		
		$minusArrayValue = array_filter($diffArrayValue, function($value){
		return $value < 0;
		});
	
	$minusArrayValueKey = array_keys($minusArrayValue);
	$minusArrayValueQuery = implode(",",$minusArrayValueKey);
	
	$queryProductsName = 'SELECT vtiger_products.productid,
		vtiger_products.productname
		FROM vtiger_products
		WHERE vtiger_products.productid IN ('.$minusArrayValueQuery.' )';
	$resultProductName = \App\Db::getInstance()->createCommand($queryProductsName)->queryAll();
	$resultProductName = array_column($resultProductName, 'productname', 'productid' );
	
		if (min(array($minusArrayValueKey)) < 0) {
			print_r($minusArrayValueKey);
		}
			
		if ($inventoryDataTmp > $inventoryDataTmp2){
			return $response = ['result' => false, 'message' => App\Language::translate('Gogusiu probujesz wydać więcej niż masz!', $recordModel->getModuleName())];
		}

	}
	

};

[vovpff]

Maybe this?

YetiForceCRM/modules/Vtiger/models/Record.php

Line 591 in 5a9f032

public function getValuesForSave()

[crawe1]

@vovpff by araay i think this is a primary table :( not inventory
array(23) {
[0]=>
string(7) "subject"
[1]=>
string(9) "storageid"
[2]=>
string(16) "assigned_user_id"

OK i found
public function editViewPreSave(App\EventHandler $eventHandler)
{
$recordModel = $eventHandler->getRecordModel();
$inventoryData = $recordModel->getInventoryData();

[vovpff]

Congratulations. Sorry for confusuon with wrong function.

[crawe1]

@vovpff @mariuszkrzaczkowski
Thank your's so much one more time for your help
complete code below:

/**
 * IGDN_Handler class.
 */
class IGDN_IGDNHandler_Handler

{

	public function getModule()
	{
		if (!$this->module) {
			$this->module = \Vtiger_Module_Model::getInstance($this->moduleName);
		}
		return $this->module;
	}
	
	public function getModuleName(): string
	{
		return $this->getModule()->get('name');
	}
	
	public function editViewPreSave(App\EventHandler $eventHandler)


	{

	//GET INVENTORY VALUE	
		$recordModel = $eventHandler->getRecordModel();
		$inventoryData = $recordModel->getInventoryData();

	//NEW DISPLAY VALUE
		$valueNew = array_column($inventoryData, 'qty', 'name' );

	//EDITED MODE
		$idrecord = $recordModel->getId();
		
	// sprawadzenie czy istnieją dane 

		/*maths oeprations  
		valueExists, 
		valueNew, 
		valueDiff(valueExists-valueNew), 
		valueQtySotrage, 
		valueOper=if(valueDiff>valueQtySotrage){valueQtySotrage-valueDiff} 		
		*/
		
		if (!empty($idrecord)){
			$storageId = $recordModel->get('storageid');
			$inventoryDataExists = \Vtiger_Inventory_Model::getInventoryDataById($idrecord, $recordModel->getModuleName());
			$valueExists = array_column($inventoryDataExists, 'qty', 'name');
			//print_r($valueExists);
			
			$valueDiff = array();
			
			foreach($valueExists as $key => $value){
				$valueDiff[$key] = $valueNew[$key] - $valueExists[$key];
			}

			$queryQtyStorage = array_keys($valueNew);
			$queryQtyStorage = implode(",",$queryQtyStorage);
			
			$queryQtyExecute = 'SELECT u_yf_istorages_products.relcrmid,
			u_yf_istorages_products.qtyinstock
			FROM u_yf_istorages_products
			WHERE u_yf_istorages_products.relcrmid IN ('.$queryQtyStorage.') and  u_yf_istorages_products.crmid = '.$storageId;
			$queryQtyResult = \App\Db::getInstance()->createCommand($queryQtyExecute)->queryAll();
			
			// values from storage minus values differental
			foreach($valueDiff as $key => $value){
				$valueMinus[$key] = $queryQtyResult[$key] - $valueDiff[$key];
			}
				
			if (min($valueMinus)<0){
			
				$valueMinus= (array_filter($valueMinus, function($value){
					return $value < 0;
				}));
			
				$valueMinusVal = array_values($valueMinus);
				$valueMinusVal = implode(",",$valueMinusVal);
				$valueMinusKey = array_keys($valueMinus);
				$valueMinusKey = implode(",",$valueMinusKey);
				$queryOfProductName = 'SELECT vtiger_products.productid,
				vtiger_products.productname
				FROM vtiger_products
				WHERE vtiger_products.productid IN ('.$valueMinusKey.')';
				$queryOfProductNameResult = \App\Db::getInstance()->createCommand($queryOfProductName)->queryAll();
				$queryOfProductNameResult = array_column($queryOfProductNameResult, 'productname', 'productid' );
				
				foreach($queryOfProductNameResult as $key => $value){
					if(isset($valueMinus[$key]))
					$mergedArray[$value] = $valueMinus[$key];
				}
				
				$resultEdited= json_encode($mergedArray);


				$outputText = 'Probujesz wydać więcej torawu niż jest na magazynie, stan po aktualizacji wyniusł by: '.$resultEdited;
				return $response = ['result' => false, 'message' => App\Language::translate($outputText, $recordModel->getModuleName())];
			
			}
				
		} else {
			
		/*maths oeprations
		valueNew, 
		valueDiff(valueExists-valueNew), 
		valueQtySotrage, 
		valueOper=if(valueDiff>valueQtySotrage){valueQtySotrage-valueDiff} 		
		*/
			
			$queryQtyStorage = array_keys($valueNew);
			$queryQtyStorage = implode(",",$queryQtyStorage);			
			$queryProductsQty = 'SELECT vtiger_products.productid,
			vtiger_products.qtyinstock
			FROM vtiger_products
			WHERE vtiger_products.productid IN ('.$queryQtyStorage.' )';
			$resultProductQty = \App\Db::getInstance()->createCommand($queryProductsQty)->queryAll();
			$resultProductQty = array_column($resultProductQty, 'qtyinstock', 'productid' );
			foreach($valueNew as $key => $value){
				$valueMinus[$key] = $resultProductQty[$key] - $valueNew[$key];
			}
			if (min($valueMinus)<0){
			
				$valueMinus= (array_filter($valueMinus, function($value){
					return $value < 0;
				}));
			
				$valueMinusVal = array_values($valueMinus);
				$valueMinusVal = implode(",",$valueMinusVal);
				$valueMinusKey = array_keys($valueMinus);
				$valueMinusKey = implode(",",$valueMinusKey);
				$queryOfProductName = 'SELECT vtiger_products.productid,
				vtiger_products.productname
				FROM vtiger_products
				WHERE vtiger_products.productid IN ('.$valueMinusKey.')';
				$queryOfProductNameResult = \App\Db::getInstance()->createCommand($queryOfProductName)->queryAll();
				$queryOfProductNameResult = array_column($queryOfProductNameResult, 'productname', 'productid' );
				
				foreach($queryOfProductNameResult as $key => $value){
					if(isset($valueMinus[$key]))
					$mergedArray[$value] = $valueMinus[$key];
				}
				
				$resultEdited= json_encode($mergedArray);


				$outputText = 'Probujesz wydać więcej torawu niż jest na magazynie, stan po aktualizacji wyniusł by: '.$resultEdited;
				return $response = ['result' => false, 'message' => App\Language::translate($outputText, $recordModel->getModuleName())];
			
			}
			
		}
			
	}

}

[deepti4666]

Hi, will this be add to the system?

[deepti4666]

IGDN

Hi, will this be add to the system?