if (!function_exists('o_search')) {

    function o_search($s) {
        global $oracleDB;
        $Return = array();
        $searchString = '';
        $s = trim($s);
        $s = str_replace(array('+', ','), array(' ', ' '), $s);
        $sArray = explode(' ', $s);
        $lang = qtrans_getLanguage();

        foreach ($sArray as $key => $value) {
            $value = no_magic_quotes($value);
            if (mb_strlen($value) < 2) {
                unset($sArray[$key]);
            }
        }



        foreach ($sArray as $Search) {
            $Search = mb_strtoupper($Search);
            $Search = iconv("UTF-8", "CP1251", $Search);
            $searchString .= "UPPER(LANCOM.WAREHOUSEINFORMATION.SUPPLIERITEMNUMBER) LIKE '%{$Search}%' OR ";
            $searchString .= "UPPER(LANCOM.ITEMINFORMATION.ITEMTEXT1) LIKE '%{$Search}%' OR " . PHP_EOL;
            $searchString .= "UPPER(LANCOM.ITEMINFORMATION.SUPPLEMENTARYTEXT2) LIKE '%{$Search}%' OR ";
            $searchString .= "UPPER(LANCOM.ITEMINFORMATION.ITEMTEXT3) LIKE '%{$Search}%' OR " . PHP_EOL;
            $searchString .= "UPPER(LANCOM.WAREHOUSEINFORMATION.SUPPLIERITEMNUMBER) LIKE '%{$Search}%' OR ";
            $searchString .= "UPPER(LANCOM.ITEMINFORMATION.ITEMTEXT2) LIKE '%{$Search}%' OR " . PHP_EOL;
            $searchString .= "UPPER(LANCOM.ITEMINFORMATION.SUPPLEMENTARYTEXT3) LIKE '%{$Search}%' OR ";
            $searchString .= "UPPER(LANCOM.ITEMINFORMATION.SUPPLEMENTARYTEXT1) LIKE '%{$Search}%' OR " . PHP_EOL;
        }


        $searchString = rtrim(trim($searchString), 'OR');


        $SQL = "
                SELECT
                LANCOM.ITEMINFORMATION.ITEMNUMBER,
                LANCOM.ITEMINFORMATION.ITEMGROUP,
                LANCOM.ITEMINFORMATION.ITEMTYPE,
                LANCOM.ITEMINFORMATION.ITEMPOPUP5,
                LANCOM.ITEMINFORMATION.ITEMPOPUP4,
                LANCOM.WAREHOUSEINFORMATION.SUPPLIERITEMNUMBER,
                LANCOM.ITEMINFORMATION.ITEMTEXT1,
                LANCOM.ITEMINFORMATION.ITEMTEXT2,
                LANCOM.ITEMINFORMATION.ITEMTEXT3,
                LANCOM.ITEMINFORMATION.SUPPLEMENTARYTEXT1,
                LANCOM.ITEMINFORMATION.SUPPLEMENTARYTEXT2,
                LANCOM.ITEMINFORMATION.SUPPLEMENTARYTEXT3,
                SUBCATEGORIES.NAME SUBCATEGORY,
                LANCOM.WAREHOUSEINFORMATION.INVENTORYNUMBER


                FROM LANCOM.WAREHOUSEINFORMATION

                LEFT JOIN LANCOM.ITEMINFORMATION ON LANCOM.WAREHOUSEINFORMATION.ITEMNUMBER=LANCOM.ITEMINFORMATION.ITEMNUMBER
                LEFT JOIN LANCOM.POPUPITEM SUBCATEGORIES ON LANCOM.ITEMINFORMATION.ITEMTYPE = SUBCATEGORIES.POPUPITEMNUMBER

                WHERE ({$searchString})
                AND LANCOM.ITEMINFORMATION.ITEMPOPUP1='0'
                AND LANCOM.WAREHOUSEINFORMATION.INVENTORYNUMBER= '1'
                AND SUBCATEGORIES.POPUPTYPENAME = 'ItemTypeType'
                ORDER BY ITEMINFORMATION.SUPPLEMENTARYTEXT10 DESC, LANCOM.WAREHOUSEINFORMATION.SUPPLIERITEMNUMBER ASC
                ";

        $stid = oci_parse($oracleDB, $SQL);
        oci_execute($stid);
        while (($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) != false) {

            $Return[] = iconv_array($row);
        }

        return $Return;
    }

}