/** * @param $id * @param Catalog_Model_Categories $categories * @return Catalog_Model_Categories|null */ public function findCategoryRel($id, Catalog_Model_Categories $categories) { $result = $this->getDbTable()->find($id); if (0 == count($result)) { return null; } $row = $result->current(); $categoryRow = $row->findManyToManyRowset('Catalog_Model_DbTable_Categories', 'Catalog_Model_DbTable_CategoriesXref', 'ProductsRel')->current(); $categories->setId($categoryRow->id)->setParentId($categoryRow->parent_id)->setName($categoryRow->name)->setImage($categoryRow->image)->setUploadPath($categoryRow->upload_path)->setDescription($categoryRow->description)->setAddDate($categoryRow->add_date)->setModDate($categoryRow->mod_date)->setMetaTitle($categoryRow->meta_title)->setMetaDescription($categoryRow->meta_description)->setMetaKeywords($categoryRow->meta_keywords)->setPath($categoryRow->path)->setFullPath($categoryRow->full_path)->setOrder($categoryRow->order)->setSorting($categoryRow->sorting)->setGenerate($categoryRow->generate)->setActive($categoryRow->active)->setDeleted($categoryRow->deleted); return $categories; }