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); }