public function getQueryToSelect()
 {
     $result = $this->_repoAggWarehouse->getQueryToSelect();
     /* aliases and tables */
     $asStock = WrhsRepoAggWarehouse::AS_STOCK;
     $asOdoo = IWarehouse::AS_ODOO;
     $tblOdoo = [$asOdoo => $this->_resource->getTableName(EntityWarehouse::ENTITY_NAME)];
     /* LEFT JOIN prxgt_odoo_wrhs */
     $cols = [AggWarehouse::AS_ODOO_ID => EntityWarehouse::ATTR_ODOO_REF];
     $cond = $asOdoo . '.' . EntityWarehouse::ATTR_MAGE_REF . '=' . $asStock . '.' . Cfg::E_CATINV_STOCK_A_STOCK_ID;
     $result->joinLeft($tblOdoo, $cond, $cols);
     return $result;
 }
 public function test_getQueryToSelect()
 {
     /** === Test Data === */
     $query = 'query';
     /** === Setup Mocks === */
     // $result = $this->_factorySelect->getQueryToSelect();
     $this->mFactorySelect->shouldReceive('getQueryToSelect')->once()->andReturn($query);
     /** === Call and asserts  === */
     $res = $this->obj->getQueryToSelect();
     $this->assertEquals($query, $res);
 }