Dfrnhjy

I have created a table in my database using db_schema.xml and then populated that table with sql insert commands directly in mysql workbench.

My model code is

<?php

namespace LmapStarTrackShippingModel;

use MagentoFrameworkModelAbstractModel;



class StarTrackRates extends AbstractModel

 protected $_eventPrefix = 'startrack_rates_event';

 protected function _construct()
 

 $this->_init(LmapStarTrackShippingModelResourceModelStarTrackRates::class);

 

ReosurceModel codes is

<?php
namespace LmapStarTrackShippingModelResourceModel;

use MagentoFrameworkModelResourceModelDbAbstractDb;

class StarTrackRates extends AbstractDb

 protected function _construct()
 
 $this->_init('lmap_shipping_tablerate', 'id');
 

The collection Class is

<?php

namespace LmapStartrackShippingModelResourceModelStarTrackRates;

use LmapStarTrackShippingModelStarTrackRates;
use LmapStarTrackShippingModelResourceModelStarTrackRates as StarTrackRatesResource;
use MagentoFrameworkModelResourceModelDbCollectionAbstractCollection;

/**
 * Start Track Shipping table rates collection
 */
class Collection extends AbstractCollection


 protected $_idFieldName = 'id';

 protected function _construct()
 
 $this->_init(StarTrackRates ::class, StarTrackRatesResource::class);

 

My Helper Method to retrieve row from the table

<?php

namespace LmapStarTrackShippingHelper;

use LmapStarTrackShippingModelResourceModelStarTrackRatesCollectionFactory;
use LmapStarTrackShippingModelStarTrackRatesFactory;
use LmapStarTrackShippingModelStarTrackRates;
use PsrLogLoggerInterface;

Class FetchShippingRate
{

 private $stRatesCollectionFactory;
 private $stRatesFactory;
 private $stRates;


 /**
 * @var PsrLogLoggerInterface
 */
 private $logger;

 /**
 * @param PsrLogLoggerInterface $logger
 * This construct with double underscore is required to initialize other classes as LoggerInterface, CollectionFactory etc
 * This concept is taken from MagentoOfflineShippingModelResourceModelCarrierTablerate.php;
 */
 public function __construct(LoggerInterface $logger,CollectionFactory $CollectionFactory,StarTrackRatesFactory $StarTrackRatesFactory,StarTrackRates $StarTrackRates)
 
 $this->logger = $logger;
 $this->stRatesCollectionFactory = $CollectionFactory;
 $this->stRatesFactory = $StarTrackRatesFactory;
 $this->stRates = $StarTrackRates;

 

 public function fetchRate()
 
 $var =2600;
 $postcode_rate_row = $this->stRatesCollectionFactory->create()->getItemsByColumnValue('postcode', '2600');
 $collection = $this->stRatesFactory->create()->getCollection();
 $collection->addFieldToSelect('*')->addFieldToFilter('postcode',array('eq'=>'2600'));

 foreach ($collection as $rate)
 $this->logger->debug('Rate is:');
 $this->logger->debug(var_dump($collection));
 $this->logger->debug(var_dump($rate->toarray(),'$rate'));
 


 $this->logger->debug('Rates are: '.var_dump($postcode_rate_row));
 return $postcode_rate_row;

 

Invoking fetchRate() method gives an empty array. I have used both approaches of using collectionFactory and using modelFactory method getCollection() but to no avail and I get empty array. Here is the screen shot of the row I'm trying to retrieve. Please help this thing is bugging me for four days now and I'm not able to find some solid solution.