PMbility » Macierz RACI

Macierz RACI

Najpierw wpisz nazwę czynności (pierwsza kolumna) i osobę/rolę (nagłówki), potem zaznacz R/A/C/I. Każdy wiersz musi mieć co najmniej jedno „R” i dokładnie jedno „A”.

Czynność / Dokument
	R A C I	R A C I

(function(){
    var td = cb.closest('td');
    var tr = td.parentElement;
    var tbl = document.getElementById('raci-table');

var colIndex = Array.prototype.indexOf.call(tr.children, td);
    var activityName = (tr.cells[0].querySelector('input') || {value:''}).value.trim();
    var headInput = tbl.tHead.rows[0].cells[colIndex].querySelector('input');
    var personName = headInput ? headInput.value.trim() : '';

if (!activityName || !personName) {
      cb.checked = false;
      if (!activityName) { (tr.cells[0].querySelector('input')||{}).focus && tr.cells[0].querySelector('input').focus(); }
      else if (!personName) { headInput && headInput.focus(); }
      var letters0 = []; td.querySelectorAll('input[type=checkbox]').forEach(function(b){ if (b.checked) letters0.push(b.getAttribute('data-role')); });
      var badge0 = td.querySelector('.raci-badge'); badge0.textContent = letters0.join('');
      if (!badge0.textContent) { td.classList.add('empty'); td.setAttribute('data-empty','1'); } else { td.classList.remove('empty'); td.removeAttribute('data-empty'); }
      return;
    }

(function(){
    var tbl = document.getElementById('raci-table');
    var headRow = tbl.tHead.rows[0];
    var plusTh = headRow.lastElementChild;
    var th = document.createElement('th');
    th.style.textAlign='left'; th.style.padding='10px'; th.style.borderBottom='2px solid #bf9780'; th.style.minWidth='160px';
    th.innerHTML = '<input type="text" placeholder="Osoba/rola" style="width:100%; padding:8px; border:2px solid #bf9780; border-radius:6px; background:#433f49; color:#fff; box-sizing:border-box;">';
    headRow.insertBefore(th, plusTh);

var rows = tbl.tBodies[0].rows;
    for (var r=0; r<rows.length-1; r++){
      var row = rows[r];
      var td = document.createElement('td');
      td.className='raci-cell empty';
      td.setAttribute('data-empty','1');
      td.style.padding='8px'; td.style.borderBottom='1px solid #433f49'; td.style.verticalAlign='top';
      td.innerHTML = document.getElementById('raci-cell-template').innerHTML;
      row.insertBefore(td, row.lastElementChild);
    }
  })();

(function(){
    var tbl=document.getElementById('raci-table');
    var headRow=tbl.tHead.rows[0];
    var cols=headRow.cells.length - 1;

var tr=document.createElement('tr');

var td0=document.createElement('td');
    td0.style.cssText='position:sticky; left:0; background:#171c2b; z-index:1; padding:8px; border-bottom:1px solid #433f49;';
    td0.innerHTML='<input type="text" placeholder="Nazwa czynności / dokumentu" style="width:100%; padding:10px; border:2px solid #bf9780; border-radius:6px; background:#433f49; color:#fff; box-sizing:border-box;">';
    tr.appendChild(td0);

for(var i=1;i<cols;i++){
      var td=document.createElement('td');
      td.className='raci-cell empty';
      td.setAttribute('data-empty','1');
      td.style.cssText='padding:8px; border-bottom:1px solid #433f49; vertical-align:top;';
      td.innerHTML=document.getElementById('raci-cell-template').innerHTML;
      tr.appendChild(td);
    }

var tdPlus=document.createElement('td');
    tdPlus.style.cssText='text-align:center; padding:8px; border-bottom:1px solid #433f49;';
    tr.appendChild(tdPlus);

var body=tbl.tBodies[0];
    body.insertBefore(tr, body.lastElementChild);
  })();

(function(){
    var tbl=document.getElementById('raci-table');
    var rows=[].slice.call(tbl.tBodies[0].rows);
    rows.forEach(function(r){ if(r.classList){ r.classList.remove('row-error'); }});

// Walidacja R/A
    for(var i=0;i<rows.length-1;i++){
      var r=rows[i];
      var Acount=r.querySelectorAll('td.raci-cell input[data-role=A]:checked').length;
      var Rcount=r.querySelectorAll('td.raci-cell input[data-role=R]:checked').length;
      if(Acount!==1 || Rcount<1){
        alert('Każdy wiersz musi mieć: dokładnie jedno A oraz co najmniej jedno R.');
        r.classList.add('row-error');
        return;
      }
    }

// Nagłówki
    var headCells=[].slice.call(tbl.tHead.rows[0].cells).slice(1,-1);
    var headers=headCells.map(function(th){ var inp=th.querySelector('input'); return inp?inp.value.trim():''; });

// Dane – tylko wiersze z nazwą
    var data=[], ri, r, activity, row, c, badge;
    for(ri=0;ri<rows.length-1;ri++){
      r=rows[ri];
      activity=(r.cells[0].querySelector('input')||{value:''}).value.trim();
      if(!activity) continue;
      row=[];
      for(c=1;c<r.cells.length-1;c++){
        badge=(r.cells[c].querySelector('.raci-badge')||{textContent:''}).textContent.trim();
        row.push(badge);
      }
      data.push({activity:activity, values:row});
    }

// Które kolumny brać: musi być nagłówek + gdziekolwiek wartość
    var colInclude=[], anyFilled, ci;
    for(ci=0; ci<headers.length; ci++){
      if(!headers[ci]) { colInclude.push(false); continue; }
      anyFilled = false;
      for(ri=0; ri<data.length; ri++){
        if(data[ri].values[ci]) { anyFilled=true; break; }
      }
      colInclude.push(anyFilled);
    }
    if(colInclude.every(function(v){return !v;})){
      alert('Brak uzupełnionych kolumn do wyeksportowania.');
      return;
    }

// Szerokości kolumn wg 1. wiersza (nagłówków)
    // kol0 stałe ~ 240px; reszta: max(120, len*9 + 24)
    var colWidths=[240];
    for(ci=0; ci<headers.length; ci++){
      if(!colInclude[ci]) continue;
      var h=headers[ci];
      var w=Math.max(120, (h.length*9)+24);
      colWidths.push(w);
    }

function esc(s){ return String(s).replace(/&/g,'&').replace(/</g,'<').replace(/>/g,'>'); }

// COLGROUP
    var colHtml = '<col style="width:'+colWidths[0]+'px">';
    var idx=1;
    for(ci=0; ci<headers.length; ci++){
      if(!colInclude[ci]) continue;
      colHtml += '<col style="width:'+colWidths[idx++]+'px">';
    }

// Nagłówek
    var headHtml = '<tr><th class="name filled">Czynność / Dokument</th>';
    for(ci=0; ci<headers.length; ci++){
      if(!colInclude[ci]) continue;
      headHtml += '<th class="filled">'+esc(headers[ci])+'</th>';
    }
    headHtml += '</tr>';

// Treść (puste szare; wypełnione – złote obramowanie)
    var bodyHtml = '';
    data.forEach(function(rowObj){
      bodyHtml += '<tr>';
      bodyHtml += '<td class="name filled">'+esc(rowObj.activity)+'</td>';
      for(ci=0; ci<rowObj.values.length; ci++){
        if(!colInclude[ci]) continue;
        var v=rowObj.values[ci];
        var cls = v ? 'badge filled' : 'badge raciCellEmpty';
        bodyHtml += '<td class="'+cls+'">'+esc(v)+'</td>';
      }
      bodyHtml += '</tr>';
    });

var html = '<!DOCTYPE html><html lang="pl"><head><meta charset="UTF-8"><title>RACI</title><style>'+css+'</style></head><body>'
             + '<table><colgroup>'+colHtml+'</colgroup><thead>'+headHtml+'</thead><tbody>'+bodyHtml+'</tbody></table></body></html>';

var blob=new Blob([html],{type:'application/vnd.ms-excel;charset=utf-8'});
    var a=document.createElement('a');
    a.href=URL.createObjectURL(blob);
    a.download='raci.xls';
    document.body.appendChild(a);
    a.click();
    setTimeout(function(){ URL.revokeObjectURL(a.href); a.remove(); }, 0);
  })();

mateusz.florczak.96@gmail.com

+48 664-490-214

Website created in white label responsive website builder WebWave.