2 Ответы Последний ответ: 08.12.2018 22:21, автор: fac586

    apex slide setup for custom website

    ar_dev_mea

      i have the region with slides using apex static files.

      1.how can adjust to height the slide picture and remove scroll bar?

      2.how to link from each slide to navigate other page with passing parameter.

      3.if possible the slide content from TABLE stored blob and other texts?

       

       

      application link: https://apex.oracle.com/pls/apex/f?p=79803:1:9514840807887:::::

      workspace:ram_r&d

      user/password:test/test12345

        • 1. Re: apex slide setup for custom website
          ar_dev_mea

          i defined the page CSS code the following...i couldn't fix the  height

          
          
          
          
          .t-Header-branding, .t-Header-logo-oracle:before {
              height: 100%;
          }
          .container {
              width: 100%;
              position: relative; 
          }
          .t-Body-contentInner {
              padding: 0px;    
              flex-grow: 1;
              width: 100%;
              height: -10%;
          }
          
          
          .col {
              padding-right: 0px;
              padding-left: 0px;
          }
          
          • 2. Re: apex slide setup for custom website
            fac586

            ar_dev_mea wrote:

             

            i have the region with slides using apex static files.

             

            1.how can adjust to height the slide picture and remove scroll bar?

            What do you mean by "adjust to height"?

             

            The scrollbar can be eliminated by adding custom CSS that makes an adjustment to the minimum content height via the Theme Roller:

             

            .t-Body-content {
              min-height: calc(100vh - 48px);
            }
            

             

            Note that your report template is loading an obsolete and redundant version of jQuery that conflicts with that included by APEX. This must be removed otherwise the Theme Roller (and probably much else) will not function properly. An obsolete version of the Bootstrap library is also loaded. Since this does not appear to be required it can be removed completely.

            2.how to link from each slide to navigate other page with passing parameter.

            The problem here is that you are attempting to use several different linking techniques at once, none of which have been fully or properly implemented, with the result that none of them actually work.

             

            1. Link URLs are being generated in the report query using the apex_page.get_url API method:

             

            ...
            apex_page.get_url(p_page => '2', p_request => 'Learn More', p_clear_cache => '2', p_items => 'P2_GET_TEXT', p_values => 3) link_text
            ...
            

             

            This function only generates a page URL, not complete mark-up for a link element. The p_request parameter is used to specify a REQUEST value to be set by the link, not the link text as you appear to expect.

             

            2. The resulting LINK_TEXT column is being rendered as a link using the column settings. It is possible to create links based on URLs generated in the query in this way, and this is required in dynamic list entries, but it is much less common in reports where links can (and usually should) be defined declaratively using the column link properties.

             

            It is not working in this case because whilst the link target Type is set to URL, the URL property is given as &LINK_TEXT.. This is incorrect as the column substitution syntax for classic (and interactive) reports is #COLUMN_ALIAS#, not &COLUMN_ALIAS.. No URL is therefore being set in the href attribute for the generated column links, so that when they are clicked they navigate back to the current page.

             

            The correct substitution syntax is being used for the Link Text property, but the #LINK_TEXT# value used causes the URL to displayed as the link text, which is not what is intended. Either separate LINK_URL and LINK_TEXT columns are required, or a static text literal ("Learn More"?) could be used for the display text.

             

            3. The HTML mark-up defined in the custom report template contains a link element:

             

            <div class="ct-header tablex item" data-background="#BACKGROUND_URL#">

              <div class="ct-u-display-tablex">

                <div class="inner">

                  <div class="container">

                    <div class="row">

                      <div class="slider-inner">

                        <h1 class="big animated">#HEADING#</h1>

                        <p class="animated">#SUBTEXT#</p>

                        <a class="btn btn-transparent btn-lg text-uppercase animated" href="">#LINK_TEXT#</a>

                      </div>

                    </div>

                  </div>

                </div>

              </div>

            </div>

             

            Substitution of the #LINK_TEXT# template substitution string by the engine-generated column link mark-up produces nested link elements, which is forbidden in the HTML specification, and is rendered by the browser as two distinct links.

             

            You need to decide on a single way of including links in the report, either utilising declarative column links with no link mark-up in the report template, or having link mark-up in the template with substitution of column values from the report query. In this case, as the custom template includes non-standard classes for rendering the links, the latter is probably the best approach as it keeps this encapsulated within the template:

             

            <div class="ct-header tablex item" data-background="#BACKGROUND_URL#">

              <div class="ct-u-display-tablex">

                <div class="inner">

                  <div class="container">

                    <div class="row">

                      <div class="slider-inner">

                        <h1 class="big animated">#HEADING#</h1>

                        <p class="animated">#SUBTEXT#</p>

                        <a class="btn btn-transparent btn-lg text-uppercase animated" href="#LINK_URL#" #LINK_ATTRS#>#LINK_TEXT#</a>

                      </div>

                    </div>

                  </div>

                </div>

              </div>

            </div>

             

            See the above modifications in app 31026 in your workspace.

            3.if possible the slide content from TABLE stored blob and other texts?

            Entirely possible using any of the BLOB content download methods available to supply the background images:

             

            1. Declarative BLOB support
            2. The apex_util.get_blob_file_src API
            3. A custom On-Demand Process
            4. A RESTful web service

             

            See the example in app 1068 in your workspace.