Ajax And Collections

Code

Application Level Items
Four application items have been created AJAX_COLLECTION_FORMAT , AJAX_CURRENT_COLLECTION_ACTION , AJAX_CURRENT_COLLECTION , AJAX_CURRENT_COLLECTION_ITEM

Javascript

function ajax_Collection_Object(){
	this.name = false;
	this.return_id = false;
	this.return_format = false;
	this.setvalue = false;
	this.action = false;
	
	//methods 
	this.f_sort = lf_sort;
	this.f_add_item = lf_add_item;
	this.f_return = lf_return;
	this.f_truncate = lf_truncate;
	this.f_delete = lf_delete;
	this.lf_worker = lf_worker;
	return;

function lf_sort(){
		this.action = 'SORT';
		return this.lf_worker();
	}
	function lf_add_item(pValue){
		this.action = 'ADD'
		this.setvalue = pValue;
		return this.lf_worker();
	}

function lf_return(){
		return this.lf_worker();
	}

function lf_truncate(){
		this.action = 'TRUNCATE';		
		return this.lf_worker();
	}

function lf_delete(){
		this.action = 'DELETE';
		return this.lf_worker();
	}

/* sets format of return */
			if(this.return_format){
				get.add('AJAX_COLLECTION_FORMAT',this.return_format);
			}else{
				get.add('AJAX_COLLECTION_FORMAT','NONE');
			}

if(this.return_format == 'XML'){gReturn = get.get('XML');}
			else{gReturn = get.get();}
			get = null;
			return gReturn;

}else{
			return;
		}	
	}
// end object
}

</script>

ajax_Collection Process

begin
	if(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='ADD' and wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))) = false) then
		HTMLDB_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION')));
	end if;

if(wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))))then
		if(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='DELETE') then
			HTMLDB_COLLECTION.DELETE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION')));
		elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='TRUNCATE') then
			HTMLDB_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION')));
		elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='SORT') then
			HTMLDB_COLLECTION.SORT_MEMBERS(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION')),p_sort_on_column_number => 1);
		elsif(upper(v('AJAX_CURRENT_COLLECTION_ACTION'))='ADD') then
			HTMLDB_COLLECTION.ADD_MEMBER(p_collection_name =>upper(v('AJAX_CURRENT_COLLECTION')),p_c001 =>v('AJAX_CURRENT_COLLECTION_ITEM'));
		end if;

if(upper(v('AJAX_COLLECTION_FORMAT'))!='NONE' and wwv_flow_collection.collection_exists(p_collection_name=>upper(v('AJAX_CURRENT_COLLECTION'))))then
		/*add extra output options here*/
			if(upper(v('AJAX_COLLECTION_FORMAT'))='XML')then
				owa_util.mime_header('text/xml', FALSE );
				htp.p('Cache-Control: no-cache');
				htp.p('Pragma: no-cache');
				owa_util.http_header_close;
				htp.p('<collection id="'||upper(v('AJAX_CURRENT_COLLECTION'))||'">');
				for rec in (SELECT c001 FROM htmldb_collections WHERE collection_name = upper(v('AJAX_CURRENT_COLLECTION'))) loop
					htp.prn('<item>' || rec.c001 || '</item>');
				end loop;
				htp.p('</collection>');
			else
				htp.p('<table cellpadding="0" border="0" cellspacing="0" summary="" id="'||upper(v('AJAX_CURRENT_COLLECTION'))||'">');
				htp.p('<tr><th>'||upper(v('AJAX_CURRENT_COLLECTION'))||'</th></tr>');
				for rec in (SELECT c001 FROM htmldb_collections WHERE collection_name = upper(v('AJAX_CURRENT_COLLECTION'))) loop
					htp.prn('<tr><td>' || rec.c001 || '</td></tr>');
				end loop;
				htp.p('</table>');
			end if;
		end if;

end if;
	/*clear all values from app level items*/
	HTMLDB_UTIL.SET_SESSION_STATE('AJAX_COLLECTION_FORMAT',null);
	HTMLDB_UTIL.SET_SESSION_STATE('AJAX_CURRENT_COLLECTION_ACTION',null);
	HTMLDB_UTIL.SET_SESSION_STATE('AJAX_CURRENT_COLLECTION',null);
	HTMLDB_UTIL.SET_SESSION_STATE('AJAX_CURRENT_COLLECTION_ITEM',null);
end;

Test Buttons and Javascript

</script>

Collection Control

Collection Drop

Code

Notes