APEX-AT-WORK by Tobias Arnhold

Browsing "Older Posts"

Sparklines für APEX

Von Tobias Arnhold → 1.25.2012

Ich habe in den letzten Tagen meine Plugin-Applikation aktualisiert. Neben den altbewährten Beispielen, findet Ihr nun auch die Integration von Sparklines und eines Image Slider Beispiels.

Das Image Slider Plugin geht im Zuge meines DOAG Artikels online. Wer schon vorab Interesse am Plugin hegt, kann sich gern bei mir melden.

Nachtrag 26.01.2012:
Ich habe den Artikel inhaltlich endlich fertig bekommen und kann nun beruhigt ein paar kleine Feinschliffe vornehmen. Nach 10 Stunden Arbeit, erstellt sich so ein Artikel echt nicht von Selbst. :)

Das Sparkline Plugin gibt es bei DOAG Regionaltreffen zu haben, bei denen ich die Anwendung "Logbuch - Die Plugin App" präsentiere. Aktuell sind wieder welche im März in Dresden und Mannheim geplant.

Hier ist der Link zur Anwendung: http://apex.oracle.com/pls/apex/f?p=65560:1

APEX Plugin

Next image plug-in?

Von Tobias Arnhold → 1.22.2012

After I created the source for the image slider plug-in. I think I can use it for any slider/gallery technique I like.

Now I'm thinking which jQuery image solution could be the next APEX plug-in?
What do you think? Or do you even have a better idea?

http://www.twospy.com/galleriffic/example-2.html

http://coffeescripter.com/code/ad-gallery/

http://css-tricks.com/examples/MovingBoxes/

http://css-tricks.com/examples/FeaturedContentSlider/

APEX Plugin

Slider plug-in with images from table

Von Tobias Arnhold →

I added a new example for the slider plug-in:
http://apex.oracle.com/pls/apex/f?p=65560:12

In the new example I show the slider selecting the image from a table column.
This is the select I use:

select
IMG_ID as id,
'#OWNER#.aaw_img_display?p_img_id=' || to_char(IMG_ID) as img,
IMG_FILENAME as text,
IMG_DESCRIPTION as description,
'bottom' as position
from AAW_IMAGES

I also show how the dynamic action refresh looks like if you swith the value inside the select list.

Instructions about the table solution
Denes Kubiceks Example: http://apex.oracle.com/pls/otn/f?p=31517:64
Hil&Co: http://blog.hilandco.com/2010/05/how-to-show-blob-type-column-as-image.html

Here is the DDL code I used:

CREATE SEQUENCE   "AAW_IMG_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE  NOORDER  NOCYCLE ;
/
CREATE TABLE  "AAW_IMAGES" 
   ( "IMG_ID" NUMBER NOT NULL ENABLE, 
 "IMG_FILENAME" VARCHAR2(100), 
 "IMG_DESCRIPTION" VARCHAR2(500), 
 "IMG_MIMETYPE" VARCHAR2(100), 
 "IMG_FILE" BLOB NOT NULL ENABLE, 
 "IMG_TIME_STAMP" DATE NOT NULL ENABLE, 
 "IMG_UPD_USER" VARCHAR2(50) NOT NULL ENABLE, 
 "IMG_CHARACTER_SET" VARCHAR2(100), 
 "IMG_BLOB_TIME_STAMP" DATE, 
 "IMG_CLASS" VARCHAR2(100), 
 "IMG_TEXT" VARCHAR2(500), 
  CONSTRAINT "PK_IMG_ID" PRIMARY KEY ("IMG_ID") ENABLE
   ) ;


CREATE OR REPLACE TRIGGER  "AAW_IMG_TRG" 
   BEFORE INSERT OR UPDATE
   ON AAW_IMAGES
   REFERENCING NEW AS NEW OLD AS OLD
   FOR EACH ROW
DECLARE
BEGIN
   IF :NEW.IMG_ID IS NULL
   THEN
      SELECT AAW_IMG_SEQ.NEXTVAL
        INTO :NEW.IMG_ID
        FROM DUAL;
   END IF;
   IF INSERTING
   THEN
      :NEW.IMG_TIME_STAMP := SYSDATE;
      :NEW.IMG_UPD_USER := NVL (v('APP_USER'), USER);
   END IF;
   IF UPDATING
   THEN
      :NEW.IMG_TIME_STAMP := SYSDATE;
      :NEW.IMG_UPD_USER := NVL (v('APP_USER'), USER);
   END IF;
EXCEPTION
   WHEN OTHERS
   THEN
      raise_application_error (-20101,
                               'Error Trigger LOG_FIL_TRG: ' || SQLERRM
                              );
END AAW_IMG_TRG;
/
ALTER TRIGGER  "AAW_IMG_TRG" ENABLE;
/
create or replace PROCEDURE aaw_img_display( p_img_id IN NUMBER)
AS
     
 l_mime        VARCHAR2 (255);
   l_length      NUMBER;
   l_file_name   VARCHAR2 (2000);
   lob_loc       BLOB;
BEGIN
 
         SELECT IMG_MIMETYPE, IMG_FILE, DBMS_LOB.getlength (IMG_FILE)
         INTO l_mime, lob_loc, l_length
         FROM aaw_images
         WHERE img_id = p_img_id;   
 
 
   OWA_UTIL.mime_header (NVL (l_mime, 'application/octet'), FALSE);
   HTP.p ('Content-length: ' || l_length);
   OWA_UTIL.http_header_close;
   WPG_DOCLOAD.download_file (lob_loc);
    
END aaw_img_display;
/
GRANT EXECUTE ON aaw_img_display TO PUBLIC;

About the images: http://www.freedigitalphotos.net
I used them from prozac1, Ron Bird, Jennifer Ellison, xedos4

Browser issues

Image Slider Plugin

Von Tobias Arnhold → 1.11.2012

I'm currently working on a new plug-in based on the jQuery Plug-in S3Slider.

At the moment the plug-in is still under development:
http://apex.oracle.com/pls/otn/f?p=65560:12

It will be a region plug-in where you only set the selection and the options and it will create the nice slider solution on your APEX page. As template I use the cloud plug-in from Carsten Czarski.

The plug-in will be used as an example for a magazine article I will write in the next days.

APEX examples

jExpand example

Von Tobias Arnhold → 1.03.2012

Another simple example to show how the jExpand report looks inside APEX:
http://apex.oracle.com/pls/apex/f?p=66002:1
/* ------------------------------------------------------------------------------------------------------------------------------------ */
Noch eine weitere kleine APEX Applikation, die die Nutzung des jQuery jExpand Reports zeigt: http://apex.oracle.com/pls/apex/f?p=66002:1

Bild:

APEX examples

Navigation examples

Von Tobias Arnhold →

After cleaning up my old APEX applications I found a nice example application about navigation solutions inside APEX. Have a look here: http://apex.oracle.com/pls/apex/f?p=66001:1
/* ------------------------------------------------------------------------------------------------------------------------------------ */
Beim aufräumen von meinen alten APEX Applikationen, fand ich eine nette Beispielapplikation zum Thema "Navigation". Eine einfache APEX Anwendung, die die verschiedenen Techniken zur Navigation in APEX aufzeigt. Link zur Anwendung: http://apex.oracle.com/pls/apex/f?p=66001:1

Bild:

Update: 04.01.2012:
Die Anwendung wurde inhaltlich etwas überarbeitet. Ich habe auch zwei neue Beispiele integriert.