<?php

$jscode[] = <<<EOC

post_save = false;

function button_delete(obj)
{
  var foo = this.id.split(':');
  var number = foo[1];
  var bar = foo[0].split('_');
  var name = bar[1];
  var id = document.getElementById('edit_id:'+number);
  var source = document.getElementById('edit_source');

  id.parentNode.style.display = 'none';

  info('');
  var params = 'id='+id.value + '&source='+source.value + '&table=einsatz'+name;

  ajax_request('delete', params, false);

  return false;
}

var personal = false;
var geraete = false;
var gebiete = false;
var kostenstelle_selected = false;
var ordnungen = false;
var arbeiten = false;
var akkord = [{id: 0, text: 'kein Akkord'},
	      {id: 1, text: 'Akkord'}];
function label_create(name, number, text)
{
  var elem = document.createElement('label');
  elem.for = 'edit_'+name+':' + number;
  elem.innerHTML = text;
  return elem;
}

function input_create(name,number,size,value)
{
  var elem = document.createElement('input');
  var appendix = '';
  if (number !== false) appendix = ':' + number;

  elem.id = 'edit_'+name+appendix;
  elem.name = name + appendix;
  elem.type = 'text';
  elem.size = size;
  elem.value = value;
  return elem;
}

function button_create(name,number)
{
  var elem = document.createElement('button');
  var appendix = '';
  if (number !== false) appendix = ':' + number;

  elem.id = 'button_'+name+appendix;
  elem.onclick = button_delete;
  elem.innerHTML = 'Löschen';
  return elem;
}

function select_create(name,number,options,selected)
{
  var elem = document.createElement('select');
  var appendix = '';
  if (number !== false) appendix = ':' + number;

  elem.id = 'edit_'+name+appendix;
  elem.name = name + appendix;

  var idx;
  for (var i=0; i < options.length; i++) {
    elem.options[i] = new Option(options[i].text,options[i].id,false,false);
    if (options[i].id == selected) idx = i;
  }
  elem.selectedIndex = idx;

  return elem;
}

function textarea_create(name,number,cols,value)
{
  var elem = document.createElement('textarea');
  var appendix = '';
  if (number !== false) appendix = ':' + number;

  elem.id = 'edit_'+name+appendix;
  elem.name = name + appendix;
  elem.value = value;
  elem.cols = cols;

  return elem;
}

function personal_add_record(obj,number,data)
{
  var div = document.createElement('div');
  div.style.margin = '2px';
  div.style.padding = '2px';
  div.style.paddingLeft = '4px';
  div.style.marginBottom = '4px';
  div.style.border = '1px solid #aaaaaa';
  div.style.backgroundColor = '#dbdbdb';
  div.style.overflow = 'hidden';
  obj.appendChild(div);

  var elem = input_create('id',number,20,data.id);
  elem.type = 'hidden';
  div.appendChild(elem);
  elem = label_create('personal',number,'Mitarbeiter');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('personal',number,personal,data.personal);
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = label_create('stunden',number,'Stunden');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = input_create('stunden',number,5,data.stunden);
  div.appendChild(elem);
  elem = button_create('personal',number);
  elem.style.marginLeft = '20px';
  div.appendChild(elem);
}

function select_geraet_callback(data)
{
  var id = 'edit_anbaugeraet:' + data.parameter.number;
  var obj = document.getElementById(id);
  var fix = 0;

  if (data.parameter.selected == null) {
    obj.options[0] = new Option('Bitte wählen Sie','',false,false);
    fix = 1;
  }

  if (data.info.length)
    select_update(id,data.info, fix);
  else
    obj.options.length = 0;

  if (data.parameter.selected != null)
    for (var i=0; i < data.info.length; i++)
      if (data.info[i].id == data.parameter.selected)
	obj.selectedIndex = i;
}

function select_geraet(event)
{
  var foo = event.originalTarget.id.split(':');
  var number = foo[1];

  get_info('anbaugeraete',
	   {geraet: event.originalTarget.options[event.originalTarget.selectedIndex].value, number: number},
	   select_geraet_callback);
}

function geraete_add_record(obj,number,data)
{
  var div = document.createElement('div');
  div.style.margin = '2px';
  div.style.padding = '2px';
  div.style.paddingLeft = '4px';
  div.style.marginBottom = '4px';
  div.style.border = '1px solid #aaaaaa';
  div.style.backgroundColor = '#dbdbdb';
  div.style.overflow = 'hidden';
  obj.appendChild(div);

  var elem = input_create('id',number,20,data.id);
  elem.type = 'hidden';
  div.appendChild(elem);
  elem = label_create('personal',number,'Gerät');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('geraet',number,geraete,data.geraet);
  elem.onchange = select_geraet;
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);

  elem = label_create('anbaugeraet',number,'Anbaugerät');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('anbaugeraet',number,[],data.anbaugeraet);
  div.appendChild(elem);

  get_info('anbaugeraete',
	   {geraet: data.geraet, number: number, selected: data.anbaugeraet, id: elem.id},
	   select_geraet_callback);
  elem = document.createElement('br');
  div.appendChild(elem);

  elem = label_create('stunden',number,'Stunden');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = input_create('stunden',number,5,data.stunden);
  div.appendChild(elem);
  elem = button_create('geraete',number);
  elem.style.marginLeft = '20px';
  div.appendChild(elem);
}

function kostenstellen_callback(data)
{
  select_update('edit_kostenstelle',data.info,0);

  var obj = document.getElementById('edit_kostenstelle');
  for (var i=0; i < obj.options.length; i++)
    if  (obj.options[i].value == kostenstelle_selected) {
      obj.selectedIndex = i;
      break;
    }
}

function select_gebiet_callback(data)
{
  var id = 'edit_kostenstelle';
  var obj = document.getElementById(id);
  var fix = 0;

  if (data.parameter.selected == null) {
    obj.options[0] = new Option('Bitte wählen Sie','',false,false);
    fix = 1;
  }

  if (data.info.length)
    select_update(id,data.info, fix);
  else
    obj.options.length = 0;

  if (data.parameter.selected != null)
    for (var i=0; i < data.info.length; i++)
      if (data.info[i].id == data.parameter.selected)
	obj.selectedIndex = i;
}

function select_gebiet(event)
{
  get_info('kostenstellen', {gebiet: event.originalTarget.options[event.originalTarget.selectedIndex].value},
	   select_gebiet_callback);
}

function einsatz_add_record(obj,data)
{
  var div = document.createElement('div');
  div.style.margin = '2px';
  div.style.padding = '2px';
  div.style.paddingLeft = '4px';
  div.style.marginBottom = '4px';
  div.style.border = '1px solid #aaaaaa';
  div.style.backgroundColor = '#dbdbdb';
  div.style.overflow = 'hidden';
  obj.appendChild(div);

  var id = document.getElementById('edit_id');
  id.value = data.id;

  var elem = label_create('datum',false,'Datum');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = input_create('datum',false,12,data.datum);
  div.appendChild(elem);

  elem = document.createElement('br');
  div.appendChild(elem);
  elem = label_create('gebiet',false,'Gebiet');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('gebiet',false,gebiete,data.gebiet);
  elem.onchange = select_gebiet;
  div.appendChild(elem);

  elem = document.createElement('br');
  div.appendChild(elem);
  elem = label_create('kostenstelle',false,'Gewässer');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  kostenstelle_selected = data.kostenstelle;
  get_info('kostenstellen', {gebiet: data.gebiet, selected: data.kostenstelle}, select_gebiet_callback);

  elem = select_create('kostenstelle',false,[],data.kostenstelle);
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);

  elem = label_create('ordnung',false,'Ordnung');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('ordnung',false,ordnungen,data.ordnung);
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);

  elem = label_create('arbeiten',false,'Arbeiten');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('arbeiten',false,arbeiten,data.arbeiten);
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);

  elem = label_create('akkord',false,'Akkord');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = select_create('akkord',false,akkord,data.akkord);
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);

  elem = label_create('bemerkung',false,'Bemerkung');
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
  elem = textarea_create('bemerkung',false,28,data.bemerkung);
  div.appendChild(elem);
  elem = document.createElement('br');
  div.appendChild(elem);
}

function personal_load_callback(data)
{
  var div = document.getElementById('form_edit_parent');

  while (div.childNodes.length)
    div.removeChild(div.firstChild);

  for (var i=0; i < data.info.length; i++) {
    personal_add_record(div,i,data.info[i]);
  }
}

function geraete_load_callback(data)
{
  var div = document.getElementById('form_edit_parent');

  while (div.childNodes.length)
    div.removeChild(div.firstChild);

  for (var i=0; i < data.info.length; i++) {
    geraete_add_record(div,i,data.info[i]);
  }
}

function einsatz_load_callback(data)
{
  var div = document.getElementById('form_edit_parent');

  while (div.childNodes.length)
    div.removeChild(div.firstChild);

  einsatz_add_record(div,data.info[0]);
}

function personal_load(id)
{
  get_info('einsatzpersonal', {id: id}, personal_load_callback);

  var title = document.getElementById('mask_edit_title');
  title.innerHTML = 'Personaleinsatz bearbeiten';

  var type = document.getElementById('edit_data_type');
  type.value = 'personal';

  var button = document.getElementById('button_delete');
  button.style.display = 'none';
}

function geraete_load(id)
{
  get_info('einsatzgeraete', {id: id}, geraete_load_callback);

  var title = document.getElementById('mask_edit_title');
  title.innerHTML = 'Geräteeinsatz bearbeiten';

  var type = document.getElementById('edit_data_type');
  type.value = 'geraete';

  var button = document.getElementById('button_delete');
  button.style.display = 'none';
}

function einsatz_load(id)
{
  get_info('einsatz', {id: id}, einsatz_load_callback);

  var title = document.getElementById('mask_edit_title');
  title.innerHTML = 'Einsatz bearbeiten';

  var type = document.getElementById('edit_data_type');
  type.value = 'einsatz';

  var button = document.getElementById('button_delete');
  button.style.display = '';
}

function load_data()
{
  get_info('mitarbeiter', {}, function (data) { personal = data.info });
  get_info('geraete', {}, function (data) { geraete = data.info });
  get_info('gebiete', {}, function (data) { gebiete = data.info });
  get_info('ordnungen', {}, function (data) { ordnungen = data.info });
  get_info('arbeiten', {}, function (data) { arbeiten = data.info });
}

function form_onload()
{
  setTimeout(load_data, 500);
  var form = document.getElementById('form_edit');

  var div = document.createElement('div');
  div.id = 'form_edit_parent';
  form.insertBefore(div,form.firstChild);

  var elem = document.createElement('input');
  elem.id = 'edit_data_type';
  elem.name = 'data_type';
  elem.type = 'hidden';
  form.insertBefore(elem,form.firstChild);

  var status = document.getElementById('form_status');
  status.style.display = 'none';
}

Rico.onLoad(form_onload);

EOC;

function korrektur_save($mask)
{
  if ($_POST['data_type'] == 'personal') {
    $num = 0;
    while (true) {
      $app = ':'.($num++);
      if (empty($_POST['id'.$app])) break;

      $sql = sprintf("SELECT personal,stunden FROM einsatzpersonal WHERE id = %d", $_POST['id'.$app]);
      $sth = pg_query($sql);
      $row = pg_fetch_assoc($sth);

      $_POST['stunden'.$app] = str_replace(',','.',$_POST['stunden'.$app]);

      if ($row['personal'] != $_POST['personal'.$app] ||
	  $row['stunden'] != $_POST['stunden'.$app]) {
	$sql = sprintf("UPDATE einsatzpersonal SET personal=%d,stunden=%.2f,sys_user='%s',sys_edit=now() WHERE id = %d",
		       $_POST['personal'.$app], $_POST['stunden'.$app],
		       pg_escape_string($_SESSION['sys']['login']),
		       $_POST['id'.$app]);
	pg_query($sql);
      }
    }
  } elseif ($_POST['data_type'] == 'geraete') {
    $num = 0;
    while (true) {
      $app = ':'.($num++);
      if (empty($_POST['id'.$app])) break;

      $sql = sprintf("SELECT geraet,anbaugeraet,stunden FROM einsatzgeraete WHERE id = %d", $_POST['id'.$app]);
      $sth = pg_query($sql);
      $row = pg_fetch_assoc($sth);

      $_POST['stunden'.$app] = str_replace(',','.',$_POST['stunden'.$app]);

      if ($row['geraet'] != $_POST['geraet'.$app] ||
	  ($row['anbaugeraet'] === NULL && !empty($_POST['anbaugeraet'.$app])) ||
	  ($row['anbaugeraet'] !== NULL && $row['anbaugeraet'] != $_POST['anbaugeraet'.$app]) ||
	  $row['stunden'] != $_POST['stunden'.$app]) {
	$anbaugeraet = empty($_POST['anbaugeraet'.$app]) ? 'NULL' : intval($_POST['anbaugeraet'.$app]);

	$sql = sprintf("UPDATE einsatzgeraete SET geraet=%d,anbaugeraet=%s,stunden=%.2f,sys_user='%s',sys_edit=now() WHERE id = %d",
		       $_POST['geraet'.$app],
		       $anbaugeraet,
		       $_POST['stunden'.$app],
		       pg_escape_string($_SESSION['sys']['login']),
		       $_POST['id'.$app]);
	pg_query($sql);
      }
    }
  } elseif ($_POST['data_type'] == 'einsatz') {
    $sql = sprintf("SELECT datum,ordnung,gebiet,kostenstelle,arbeiten,akkord,bemerkung FROM einsatz WHERE id = %d", $_POST['id']);
    $sth = pg_query($sql);
    $row = pg_fetch_assoc($sth);

    if ($row['datum'] != $_POST['datum'] ||
	$row['ordnung'] != $_POST['ordnung'] ||
	$row['gebiet'] != $_POST['gebiet'] ||
	$row['kostenstelle'] != $_POST['kostenstelle'] ||
	$row['arbeiten'] != $_POST['arbeiten'] ||
	$row['akkord'] != $_POST['akkord'] ||
	$row['bemerkung'] != $_POST['bemerkung']) {

      $bemerkung = empty($_POST['bemerkung']) ? 'NULL' : "'".pg_escape_string($_POST['bemerkung'])."'";
      $sql = sprintf("UPDATE einsatz SET datum='%s',ordnung=%d,gebiet=%d,kostenstelle=%d,arbeiten=%d,akkord=%d,bemerkung=%s, " .
		     "sys_user='%s',sys_edit=now() WHERE id = %d",
		     pg_escape_string($_POST['datum']),
		     $_POST['ordnung'],
		     $_POST['gebiet'],
		     $_POST['kostenstelle'],
		     $_POST['arbeiten'],
		     $_POST['akkord'],
		     $bemerkung,
		     pg_escape_string($_SESSION['sys']['login']),
		     $_POST['id']);
      pg_query($sql);
    }
  } else {
    return array('status' => false, 'error' => 'Unknown data type "'.$_POST['data_type'].'" for this call');
  }

  return array('status' => true);
}

function korrektur_delete($mask)
{
  if (!empty($_POST['table']) && is_array($mask['tables_delete']) && in_array($_POST['table'], $mask['tables_delete']))
    return delete_or_copy_row($_POST['table'],$_POST['id']);

  $id = $_POST['id'];
  $subtables = array('einsatzpersonal','einsatzgeraete');
  foreach ($subtables as $table) {
    $sql = sprintf("SELECT id FROM %s WHERE einsatz = %d", $table, $id);
    $sth = pg_query($sql);
    $row = pg_fetch_assoc($sth);

    $ret = delete_or_copy_row($table, $row['id']);

    if ($ret['status'] !== true) return $ret;
  }

  return delete_or_copy_row($mask['table'], $id);
}

function gebiete()
{
  $sql = "SELECT id,gebiet FROM gebiet ORDER BY id";
  $sth = pg_query($sql);

  $result = array();
  while ($row = pg_fetch_assoc($sth))
    $result[] = sprintf("%d: '%s'", $row['id'], $row['gebiet']);

  return '{' . implode(', ', $result) . '}';
}

$mask = array(
	      'table' => 'einsatz',
	      'tables_delete' => array('einsatzpersonal','einsatzgeraete'),
	      'title' => 'Korrektur von Arbeitsberichten',
	      'join' => array(
			      'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
			      ),
	      'list' => array(
			      'id' => array(
					    'name' => 'ID',
					    'sql' => 'einsatz.id',
					    'width' => 60,
					    'visible' => false,
					    ),
			      'datum' => array(
					    'name' => 'Datum',
					    'type' => 'date',
					    'width' => 70,
					    'specs' => "filterUI: 't'",
					    ),
			      'gebiet' => array(
					    'name' => 'Gebiet',
					    'width' => 230,
					    'sql' => 'einsatz.gebiet',
					    'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
					    'specs' => "filterUI: 's'",
					    ),
			      'kostenstelle' => array(
					    'name' => 'Kostenstelle',
					    'width' => 230,
					    'sql' => 'kostenstellen.kostenstelle',
					    'specs' => "filterUI: 't'",
					    ),
			      'personal' => array(
					    'name' => 'Personal',
					    'width' => 230,
					    'sql' => "(SELECT name || ', ' || vorname FROM personal " . 
						     "JOIN einsatzpersonal ON einsatzpersonal.personal = personal.id " .
						     "WHERE einsatzpersonal.einsatz = einsatz.id LIMIT 1)",
					    'specs' => "filterUI: 't'",
					    ),
			      'controla' => array(
					    'name' => 'Personal',
					    'width' => 70,
					    'control' => "new Rico.TableColumn.link('javascript:personal_load({0})')",
					    'specs' => "ClassName: 'aligncenter', canSort: false",
					    'sql' => "'bearbeiten'",
					    ),
			      'controlb' => array(
					    'name' => 'Geräte',
					    'width' => 70,
					    'control' => "new Rico.TableColumn.link('javascript:geraete_load({0})')",
					    'specs' => "ClassName: 'aligncenter', canSort: false",
					    'sql' => "'bearbeiten'",
					    ),
			      'controlc' => array(
					    'name' => 'Einsatz',
					    'width' => 70,
					    'control' => "new Rico.TableColumn.link('javascript:einsatz_load({0})')",
					    'specs' => "ClassName: 'aligncenter', canSort: false",
					    'sql' => "'bearbeiten'",
					    ),
			      ),
	      'edit' => array(),
	      'save' => korrektur_save,
	      'delete' => korrektur_delete,
	      'buttons' => array(
			'insert' => false,
			),
	      'info' => array(
			      'einheit' => array(
					    'sql' => 'SELECT einheiten.einheit FROM einheiten ' .
						     'JOIN materialien ON materialien.einheit = einheiten.id ' .
						     'WHERE materialien.id = {id}',
					    ),
			      'einsatz' => array(
					    'sql' => "SELECT id,ordnung,datum,kostenstelle,gebiet,arbeiten,akkord,bemerkung " .
					    'FROM einsatz ' .
					    'WHERE id = {id}',
					    ),
			      'einsatzpersonal' => array(
					    'sql' => "SELECT id,personal,stunden " .
					    'FROM einsatzpersonal ' .
					    'WHERE einsatz = {id}',
					    ),
			      'einsatzgeraete' => array(
					    'sql' => "SELECT id,geraet,anbaugeraet,stunden " .
					    'FROM einsatzgeraete ' .
					    'WHERE einsatz = {id}',
					    ),
			      'gebiete' => array(
					    'sql' => 'SELECT id,gebiet AS text FROM gebiet ORDER BY text',
					    ),
			      'kostenstellen' => array(
					    'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
					    ),
			      'ordnungen' => array(
					    'sql' => 'SELECT id,name AS text FROM ordnungen ORDER BY text',
					    ),
			      'arbeiten' => array(
					    'sql' => 'SELECT id,arbeitsart AS text FROM arbeitsarten ORDER BY text',
					    ),
			      'mitarbeiter' => array(
					    'sql' => 'SELECT id,name || \', \' || vorname AS text FROM personal WHERE aktiv = 1 ORDER BY text',
					    ),
			      'geraete' => array(
					    'sql' => 'SELECT id,geraet AS text FROM gerate ORDER BY text',
					    ),
			      'anbaugeraete' => array(
					    'sql' => 'SELECT anbaugeraete.id,anbaugeraet as text FROM anbaugeraete ' .
						     'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .
						     'WHERE gerate.id = {geraet} ORDER BY text',
					    ),
			      ),
	      );

?>