vincentdeelen

SELECT emp.empno
     , emp.ename
     , emp.job
     , NVL(TO_CHAR(emp.mgr),'-') mgr
     , TO_CHAR(emp.hiredate, 'DD-MON-YYYY') hiredate
     , emp.sal
     , emp.comm
     , emp.deptno
  FROM emp
     , dept

vincentdeelen

SELECT *
  FROM dept

vincentdeelen

<!-- Folders -->
<section id="knockoutSection" class="col col-4">
<nav>
  <ul class="departments" data-bind="foreach: departments">
      <li class="" data-bind="text: $data, 
                 css: { selected: $data == $root.chosenDeptId() },
                 click: $root.goToDept">
      </li>
  </ul>
</nav>

vincentdeelen

section#knockoutSection{
    background:#f8f8f8;
}
nav{
    background:#e8e8e8;
    padding:10px;
    margin: 0px;
}
nav ul{
    margin: 0px;

vincentdeelen

$.getJSON( "/pls/apex/vincentdeelen/hr/dept", function( data ) {
    depts = $.map(data.items, function (el) {
    return el.dname;
    });

    ko.applyBindings(new EmpDeptViewModel());

});

vincentdeelen

// Variables
var depts;

// Functions
function EmpDeptViewModel() {
    // Data
    var self = this;
    self.departments = depts;
    self.chosenDeptId = ko.observable();
    self.chosenDeptData = ko.observable();

vincentdeelen

parent.closeIFrame()

vincentdeelen

function closeIFrame(){
  $('#parameterFrame').dialog("close")
}

vincentdeelen

$('#iframeContainer').append(frame)
$('#parameterFrame').dialog({ modal:true
                            , height:400 })

vincentdeelen

if ( $('#parameterFrame').length >0 ){
   $('#parameterFrame').remove()
}
var reportId = $v('P100_REPORT_ID')
var url   = 'f?p=&APP_ID.:200:&SESSION.:&REQUEST.:&DEBUG.:200:P200_REPORT_ID:' + reportId
,   frame =  $( '<iframe></iframe>'
              , { id          : "parameterFrame"
                , class       : "iframe"
                , frameborder : 0 
                , src         : url