/** * Get refernece by CmlProduct. * @param CmlProduct $abstractProduct */ public function getReference($abstractProduct) { $name = $abstractProduct->getName(); $article = $abstractProduct->getArticle(); if($article != null) { $result = $this->query("select id from Products where productname='$name' " . "and productcode='$article';"); //if in article null - request generate error } else { $result = $this->query("select id from Products where productname='$name';"); } return $this->getFirstReference($result); }