Kdjykuj

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.