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; }
/** @inheritdoc */ public function create($data) { /** @var $result AggWarehouse */ $result = null; $def = $this->_manTrans->begin(); try { $wrhsData = $this->_repoWrhsAggWarehouse->create($data); /* create odoo related entries */ $bind = [EntityWarehouse::ATTR_MAGE_REF => $wrhsData->getId(), EntityWarehouse::ATTR_ODOO_REF => $data->getOdooId()]; $this->_repoEntityWarehouse->create($bind); $this->_manTrans->commit($def); /* compose result from warehouse module's data and odoo module's data */ $result = $this->_manObj->create(AggWarehouse::class); $result->setData($wrhsData); $result->setOdooId($data->getOdooId()); } finally { $this->_manTrans->end($def); } return $result; }
public function test_getQueryToSelectCount() { /** === Test Data === */ $query = 'query'; /** === Setup Mocks === */ // $result = $this->_factorySelect->getQueryToSelectCount(); $this->mFactorySelect->shouldReceive('getQueryToSelectCount')->once()->andReturn($query); /** === Call and asserts === */ $res = $this->obj->getQueryToSelectCount(); $this->assertEquals($query, $res); }