chamilo / chamilo-lms

     * @param string $course_id Course code

     * @param int $document_id Document id to delete

     */

    public static function delete_document_from_search_engine($course_id, $document_id)

    {

        // remove from search engine if enabled

        if (api_get_setting('search_enabled') === 'true') {

            $tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);

            $sql = 'SELECT * FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';

            $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_DOCUMENT, $document_id);

            $res = Database::query($sql);

            if (Database::num_rows($res) > 0) {

                $row2 = Database::fetch_array($res);

                require_once api_get_path(LIBRARY_PATH) . 'search/ChamiloIndexer.class.php';

                $di = new ChamiloIndexer();

                $di->remove_document((int) $row2['search_did']);

            }

            $sql = 'DELETE FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';

            $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_DOCUMENT, $document_id);

            Database::query($sql);

            // remove terms from db

            require_once api_get_path(LIBRARY_PATH) . 'specific_fields_manager.lib.php';

            delete_all_values_for_item($course_id, TOOL_DOCUMENT, $document_id);

        }

    }

    /**

     * Gets the id of a document with a given path

     * @param int $link_id Document id to delete

     * @return void

     */

    public static function delete_link_from_search_engine($course_id, $link_id)

    {

        // Remove from search engine if enabled.

        if (api_get_setting('search_enabled') === 'true') {

            $tbl_se_ref = Database:: get_main_table(

                TABLE_MAIN_SEARCH_ENGINE_REF

            );

            $sql = 'SELECT * FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';

            $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id);

            $res = Database:: query($sql);

            if (Database:: num_rows($res) > 0) {

                $row = Database:: fetch_array($res);

                require_once api_get_path(LIBRARY_PATH) . 'search/ChamiloIndexer.class.php';

                $di = new ChamiloIndexer();

                $di->remove_document((int)$row['search_did']);

            }

            $sql = 'DELETE FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';

            $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id);

            Database:: query($sql);

            // Remove terms from db.

            require_once api_get_path(LIBRARY_PATH) . 'specific_fields_manager.lib.php';

            delete_all_values_for_item($course_id, TOOL_DOCUMENT, $link_id);

        }

    }

    /**

     *