Mrthdrb

I am trying to update the record but it creates a new record.

Collection factory

 <?php


namespace WebkulMpquotesystemBlock;

use WebkulMpquotesystemModelResourceModelQuoteconversation;
use MagentoFrameworkPricingHelperData;
use WebkulMpquotesystemModelQuotesFactory;
use WebkulMpquotesystemModelSellerQuotesFactory;
use WebkulMpquotesystemModelQuoteconversationFactory;
use MagentoCatalogModelProductFactory;
use WebkulMpquotesystemModelResourceModelSellerQuotes;


class Mpeditquotes extends MagentoFrameworkViewElementTemplate

 /**
 * @var customerSession
 */
 protected $_customerSession;
 /**
 * @var MagentoCustomerModelCustomer
 */
 protected $_customerModel;
 /**
 * @var quoteCollection
 */
 protected $_quoteConversationCollection;
 /**
 * @var pricingHelper
 */
 protected $_pricingHelper;
 /**
 * @var _quotesFactory
 */
 protected $_quotesFactory;
 /**
 * @var _sellerQuoteFactory
 */
 protected $_sellerQuoteFactory;
 /**
 * @var _productFactory
 */
 protected $_productFactory;
 /**
 * @var MagentoCatalogHelperImage
 */
 protected $_imageHelper;
 /**
 * @var _quoteConversationCollectionFactory
 */
 protected $_quoteConversationCollectionFactory;
 /**
 * @var _quoteconversationFactory
 */
 protected $_quoteconversationFactory;
 protected $_sellercolletcionquotes;

 /**
 * @param MagentoCustomerModelSession $customerSession
 * @param MagentoCustomerModelCustomer $customerModel
 * @param MagentoCatalogBlockProductContext $context
 * @param QuoteconversationCollectionFactory $conversationCollectionFactory
 * @param QuotesFactory $_quotesFactory
 * @param ProductFactory $productFactory
 * @param QuoteconversationFactory $conversationFactory
 * @param Data $pricingHelper
 * @param array $data
 */

 public function __construct(
 MagentoCustomerModelSession $customerSession,
 MagentoCustomerModelCustomer $customerModel,
 MagentoCatalogBlockProductContext $context,
 QuoteconversationCollectionFactory $conversationCollectionFactory,
 QuotesFactory $_quotesFactory,
 SellerQuotesFactory $sellerQuoteFactory,
 ProductFactory $productFactory,
 QuoteconversationFactory $conversationFactory,
 WebkulMpquotesystemModelResourceModelSellerQuotesCollectionFactory $sellercolletcionquotes,
 Data $pricingHelper,
 array $data = []
 ) 
 $this->_customerSession = $customerSession;
 $this->_customerModel = $customerModel;
 $this->_quoteConversationCollectionFactory = $conversationCollectionFactory;
 $this->_pricingHelper = $pricingHelper;
 $this->_quotesFactory = $_quotesFactory;
 $this->_productFactory = $productFactory;
 $this->_sellerQuoteFactory = $sellerQuoteFactory;
 $this->_quoteconversationFactory = $conversationFactory;
 $this->_imageHelper = $context->getImageHelper();
 $this->_sellercolletcionquotes = $sellercolletcionquotes;
 parent::__construct($context, $data);
 
 /**
 * @return $this
 */
 protected function _prepareLayout()
 
 parent::_prepareLayout();
 if ($this->getQuoteConversationCollection()) 
 $pager = $this->getLayout()->createBlock(
 'MagentoThemeBlockHtmlPager',
 'mpquotesystem.pager'
 )
 ->setCollection(
 $this->getQuoteConversationCollection()
 );
 $this->setChild('pager', $pager);
 $this->getQuoteConversationCollection()->load();
 

 return $this;
 
 /**
 * @return string
 */
 public function getPagerHtml()
 
 return $this->getChildHtml('pager');
 
 /**
 * customer Id by customer session.
 *
 * @return int
 */
 public function getCustomerId()
 
 return $this->_customerSession->getCustomerId();
 
 /**
 * customer data by customer id.
 *
 * @return object
 */
 public function getCustomerData($customerId)
 
 return $this->_customerModel->load($customerId);
 
 /**
 * get Collection of quotes conversation for particular quote id.
 *
 * @return collection
 */
 public function getQuoteConversationCollection()
 
 if (!$this->_quoteConversationCollection) 
 $sellerquoteId = $this->getRequest()->getParam('id');
 $sellerquote = $this->getSellerQuotes($sellerquoteId);
 $quoteId = $sellerquote->getQuoteId();
 $sellerId = $sellerquote->getSellerId();
 if ($quoteId != 0) 
 $collection = $this->_quoteConversationCollectionFactory
 ->create()
 ->addFieldToFilter('quote_id', $quoteId)
 ->addFieldToFilter('sender', $sellerId);

 $this->_quoteConversationCollection = $collection;
 
 

 return $this->_quoteConversationCollection;
 
 /**
 * get formatted price by currency.
 *
 * @return format price string
 */
 public function getFormattedPrice($price)
 
 return $this->_pricingHelper
 ->currency($price, true, false);
 

 public function getQuoteData($entityId)
 
 $quoteModel = $this->_quotesFactory->create()->load($entityId);
 return $quoteModel;
 
 /**
 * get Collection of quotes conversation for particular quote id.
 *
 * @return collection
 */
 public function getsellerQuoteConversationCollection($quoteId)
 

 if (!$this->_quoteConversationCollection) 
 //~ $quoteId = $this->getRequest()->getParam('id');
 if ($quoteId != 0) 
 $collection = $this->_quoteConversationCollectionFactory
 ->create()
 ->addFieldToFilter('quote_id', $quoteId);

 $this->_quoteConversationCollection = $collection;
 
 

 return $this->_quoteConversationCollection;
 


 /** public function **getsellerupdateCollection**($quoteId,$sellerid)
 


 //~ $quoteId = $this->getRequest()->getParam('id');
 if ($quoteId != 0) 
 $collection = $this->_sellercolletcionquotes
 ->create()

 ->load('quote_id',$quoteId)
 ->load('main_table.status',array('in'=>array('1','2')))
 ->load('main_table.seller_id',['neq'=>$sellerid])
 ->load('main_table.nstatus',1);

 foreach($collection as $item) 

 
 $this->_sellercolletcionquotes = $collection;

 


 return $this->_sellercolletcionquotes;
 */

 public function getsellerupdateCollection($quoteId,$sellerid)
 


 //~ $quoteId = $this->getRequest()->getParam('id');
 if ($quoteId != 0) 
 $collection = $this->_sellercolletcionquotes
 ->create()
 ->addFieldToSelect('quote_id', $quoteId)
 ->addFieldToFilter('main_table.status', array('in' => array('1', '2')))
 ->addFieldToFilter('main_table.seller_id', ['neq' => $sellerid])
 ->addFieldToFilter('main_table.nstatus', 1);



 foreach($collection as $item)
 
 $item->setNstatus('Sold');
 $item->save();

 

 $this->_sellercolletcionquotes = $collection;
 
 return $this->_sellercolletcionquotes;
 


 public function getSellerQuotes($entityId)
 $quoteModel = $this->_sellerQuoteFactory->create()->load($entityId);
 return $quoteModel;
 
 public function getProductData($productId)
 
 $productModel = $this->_productFactory->create()->load($productId);
 return $productModel;
 
 public function imageHelperObj()
 
 return $this->_imageHelper;
 
 public function getProductPriceHtml(
 MagentoCatalogModelProduct $product,
 $priceType = MagentoCatalogPricingPriceFinalPrice::PRICE_CODE,
 $renderZone = MagentoFrameworkPricingRender::ZONE_ITEM_LIST,
 array $arguments = []
 ) 
 if (!isset($arguments['zone'])) 
 $arguments['zone'] = $renderZone;
 

 /** @var MagentoFrameworkPricingRender $priceRender */
 $priceRender = $this->getLayout()->getBlock('product.price.render.default');
 $price = '';

 if ($priceRender) 
 $price = $priceRender->render($priceType, $product, $arguments);
 
 return $price;
 

 public function getParameters()
 
 return $this->getRequest()->getParams();
 


 /**
 * getIsSecure check is secure or not
 * @return boolean
 */
 public function getIsSecure()
 
 return $this->getRequest()->isSecure();
 
 /**
 * check whether a quote is sold or not?
 * @param int $quoteStatus
 * @return boolean
 */
 public function quoteStatusIsNotSold($quoteStatus)
 
 if ($quoteStatus!=WebkulMpquotesystemModelQuotes::STATUS_SOLD) 
 return true;
 
 return false;
 

I want multiple where a condition for update record in Magento 2

Try this one, adding getCollection():

public function getsellerupdateCollection($quoteId,$sellerid)

 if ($quoteId != 0) 
 $collection = $this->_sellercolletcionquotes
 ->create()->getCollection()
 ->addFieldToSelect('quote_id',$quoteId)
 ->addFieldToFilter('main_table.status',array('in'=>array('1','2')))
 ->addFieldToFilter('main_table.seller_id',['neq'=>$sellerid])
 ->addFieldToFilter('main_table.nstatus',1);

 foreach($collections as $item)
 
 $item->setNstatus('Sold');
 $item->save();
 
 $this->_sellercolletcionquotes = $collection;
 
 return $this->_sellercolletcionquotes;

I have updated a few lines of code.

public function getsellerupdateCollection($quoteId,$sellerid)

 if ($quoteId != 0) 
 $collection = $this->_sellercolletcionquotes
 ->create()->getCollection()
 ->addFieldToSelect('quote_id',$quoteId)
 ->addFieldToFilter('main_table.status',array('in'=>array('1','2')))
 ->addFieldToFilter('main_table.seller_id',['neq'=>$sellerid])
 ->addFieldToFilter('main_table.nstatus',1);

 foreach($collections as $item)
 
 $item->setNstatus('Sold');
 $item->save();
 
 $this->_sellercolletcionquotes = $collection;
 
 return $this->_sellercolletcionquotes;