FUNCTION apexplugin_render (
    p_region              IN apex_plugin.t_region,
    p_plugin              IN apex_plugin.t_plugin,
    p_is_printer_friendly IN BOOLEAN )
  RETURN apex_plugin.t_region_render_result
IS
  l_sourceSQL       apex_application_page_regions.region_source%type    := p_region.source;
  sqlHandler APEX_PLUGIN_UTIL.t_sql_handler;
  RowSet APEX_PLUGIN_UTIL.t_column_value_list;
  l_onload_code LONG;
  lvl NUMBER;
  i NUMBER;
BEGIN
  IF apex_application.g_debug THEN
    apex_plugin_util.debug_region ( p_plugin => p_plugin, 
                                    p_region => p_region, 
                                    p_is_printer_friendly => p_is_printer_friendly );
  END IF;
  sqlHandler := APEX_PLUGIN_UTIL.GET_SQL_HANDLER ( p_sql_statement => l_sourceSQL, 
                                                   p_min_columns =>  2 , 
                                                   p_max_columns =>  100 , 
                                                   p_component_name => NULL );
  APEX_PLUGIN_UTIL.PREPARE_QUERY ( sqlHandler );
  RowSet := APEX_PLUGIN_UTIL.GET_DATA ( sqlHandler );

  lvl :=  0 ;
  i :=  1 ;
  l_onload_code := l_onload_code || '<div id="tree"><ul>';

  FOR row IN  1 ..RowSet( 1 ).count  -- Number of rows
  LOOP
    IF lvl <>  0  THEN
    IF lvl < RowSet( 2 )(row) THEN
      l_onload_code := l_onload_code || '<ul>';
    ELSIF lvl = RowSet( 2 )(row) THEN
      l_onload_code := l_onload_code || '</li>';       
    ELSIF lvl > RowSet( 2 )(row) THEN
      l_onload_code := l_onload_code || '</ul>';
    END IF;
    END IF;

    IF RowSet( 6 )(row) =  1  THEN
      l_onload_code := l_onload_code || '<li id="' || RowSet( 4 )(row)  || '" class="' || RowSet( 5 )(row) || '" rel="project">';
    ELSE
      l_onload_code := l_onload_code || '<li id="' || RowSet( 4 )(row)  || '" class="' || RowSet( 5 )(row) || '" rel="root">';
    END IF;

    l_onload_code := l_onload_code || '<a href="#">' || RowSet( 3 )(row) || '</a>';
    lvl := RowSet( 2 )(row);
    i := i +  1 ;
  END LOOP;

  l_onload_code := l_onload_code || '</ul<>></div>';

  sys.htp.p(l_onload_code);

  apex_css.add_file( p_name       => 'style',
                     p_directory  => apex_application.g_image_prefix || 'libraries/jquery-jstree/1.0rc2/themes/default/',
                     p_version    => null);

  apex_javascript.add_library ( p_name       => 'jquery.jstree', 
                                p_directory  => apex_application.g_image_prefix || 'libraries/jquery-jstree/1.0rc2/',
                                p_version    => null);

  sys.htp.p('<script type="text/javascript">
        $(function () {
            $("#tree").jstree({
                "types" : {
                    "valid_children" : [ "root" ],
                    "types" : {
                        "root" : {
                            "icon" : {
                                "image" : "#IMAGE_PREFIX#libraries/jquery-jstree/1.0rc2/_demo/folder.png"
                            },                        
                            "valid_children" : [ "default" ],
                            "max_depth" : 2,
                            "hover_node" : false,
                            "select_node" : function () {return false;}
                        },
                        "project" : {
                            "icon" : {
                                "image" : "#IMAGE_PREFIX#libraries/jquery-jstree/1.0rc2/_demo/file.png"
                            },                        
                            "valid_children" : [ "default" ],
                            "max_depth" : 2,
                            "hover_node" : false,
                            "select_node" : function () {return false;}
                        },                        
                        "default" : {
                            "valid_children" : [ "default" ]
                        }
                    }
                },
                "themes" : { "theme" : "default" },
                "plugins" : [ "themes", "html_data", "checkbox" , "ui", "types"]
            });
        });
         </script>');
  RETURN NULL;
END;

SELECT CASE WHEN connect_by_isleaf =  1  THEN  0 
            WHEN LEVEL =  1              THEN  1 
            ELSE                           - 1 
       END AS status, 
       LEVEL,
       P.PRO_NAME AS title,
       P.PRO_ID AS VALUE,
       (SELECT 'jstree-checked' FROM PROJECTS_WORKERS PW, WORKERS W WHERE PW.PRO_ID = P.PRO_ID AND PW.WORKER_ID = W.WORKER_ID AND UPPER(W.WORKER_LOGIN) = UPPER(:APP_USER)),
       P.PRO_TYPE,
       NULL AS icon,
       NULL AS tooltip, 
       NULL AS LINK
FROM PROJECTS P
WHERE P.PRO_ENABLE =  1 
START WITH P.PRO_PARENT_ID IS NULL
CONNECT BY PRIOR P.PRO_ID = P.PRO_PARENT_ID
ORDER SIBLINGS BY P.PRO_NAME

$("#tree").jstree("get_checked", false, true).each(function () {
		var checkedId = this.id;
		$("<input>").attr("type", "hidden").attr("name", "f01").val(checkedId).appendTo("#tree");
});

$("#wwvFlowForm").submit();

DECLARE 

  userId NUMBER;
BEGIN
  SELECT WORKER_ID INTO userId FROM WORKERS WHERE UPPER(WORKER_LOGIN) = UPPER(:APP_USER);

  DELETE FROM PROJECTS_WORKERS WHERE WORKER_ID = userId;

  FOR i in  1 ..APEX_APPLICATION.G_F01.COUNT LOOP
      INSERT INTO PROJECTS_WORKERS (PRO_ID,WORKER_ID) VALUES (APEX_APPLICATION.G_F01(i),userId);
  END LOOP;
  
  COMMIT;

END;

get_checked : function (obj) {
				obj = !obj || obj === - 1  ? this.get_container() : this._get_node(obj);
 				
				return obj.find("ul li.jstree-checked"); // return obj.find("> ul > .jstree-checked, .jstree-undetermined > ul > .jstree-checked");
			}