sunnysideup / silverstripe-ecommerce_software

                }

            }

            $tags = EcommerceProductTag::get()->filterAny(array("Title:PartialMatch" => $search, "Synonyms:PartialMatch" => $search, "Explanation:PartialMatch" => $search));

            if ($tags->count()) {

                foreach ($tags as $tag) {

                    $rows = DB::query("SELECT ProductID FROM EcommerceProductTag_Products WHERE EcommerceProductTagID = ".$tag->ID);

                    if ($rows) {

                        foreach ($rows as $row) {

                            $item = ModuleProduct::get()->byID($row["ProductID"]);

                            if ($item) {

                                $data["Results"]->push($item);

                            }

                        }

                    }

                }

            }

            $authors = Member::get()

                ->filterAny(

                    array(

                        "FirstName:PartialMatch" => $search,

                        "Surname:PartialMatch" => $search)

                );

            if ($authors->count()) {

                foreach ($authors as $author) {

                    $rows = DB::query("SELECT \"ModuleProductID\" FROM \"ModuleProduct_Authors\" WHERE \"MemberID\" = ".$author->ID);

                    if ($rows) {

                        foreach ($rows as $row) {

                            $item = ModuleProduct::get()->byID($row["ModuleProductID"]);

                            if ($item) {

                                $data["Results"]->push($item);

                            }

                        }

                    }

                }

            }

        }

        if ($data["Results"] && $data["Results"] instanceof DataObjectSet) {

            $data["Results"]->removeDuplicates();