public function Render()
{
$html = '';
$this->fecha_header_label = getFormatedDate(date('Y-m-d'));
$this->get_date();
switch ($this->operation) {
case 'd_today':
// dia previo
$this->today_day();
// regresa a dia hoy
$html .= $this->get_tab_day();
break;
case 'd_prev':
// dia previo
$this->prev_day();
// Atrasa 1 dia
$html .= $this->get_tab_day();
break;
case 'd_next':
// dia siguiente
$this->next_day();
// adelanta 1 dia
$html .= $this->get_tab_day();
break;
default:
$html .= $this->getCalendar();
break;
}
return $html;
}
function insertMonto($con, $request)
{
///DONDE INGRESO EL MEONTO
$insert = "INSERT INTO `EventoFacturaciones` (`FechaFacturacion`, `descripcion`,`idEvento`,`idUsuario`,`importe`)\tVALUES ('" . getFormatedDate($request->fecha) . "','" . $request->descripcion . "','" . $request->idEvento . "',1,'" . $request->monto . "');";
//echo $insert;
if (!mysqli_query($con, $insert)) {
printf("Errormessage: %s\n", mysql_error());
}
}
@extends((Request::ajax())?"materialadmin::layout.ajax":"materialadmin::layout.panel")
@section('title')
@lang('materialadmin::message.title')
@stop
@section('content')
<div id="messages-wrapper">
<div class="container">
<div class="row">
<div class="col-md-12">
@include('materialadmin::panel.alerts')
<?php
$grouped_messages = $messages->groupBy(function ($a, $b) {
return getFormatedDate($a->created_at);
});
?>
@foreach ($grouped_messages as $date => $messages)
<?php
$diff = $messages[0]->created_at->startOfDay()->diffInDays();
?>
<div class="date">
@if($diff == 0)
<h5>@lang('materialadmin::message.today')</h5>
@elseif($diff == 1)
<h5>@lang('materialadmin::message.yesterday')</h5>
@else
<h5>{!! $date !!}</h5>
@endif
<div class="card">
@foreach ($messages as $message)
/**
*@package db_record
*@method print_form_field()
*@desc returns the list of html fields automatically from a record
*@since v0.1 beta
* */
public function print_form_field($field, $CssName = '', $ExtraAttributes = '', $encode_fields = FALSE, $access = TRUE, $read_only = FALSE, $code = '')
{
$html_fld = '';
if ($encode_fields == TRUE) {
$field_id_html = 'fkf_' . encode($field . $code);
$field_name_html = encode($field . $code);
} else {
$field_id_html = $field . $code;
$field_name_html = $field . $code;
}
$original_type = $this->form_fields[$field]['Type'];
$type_x = explode("(", $original_type);
if ($type_x > 1) {
$type = $type_x[0];
} else {
$type = $original_type;
}
// Display Mode
$mode_view_edit = $this->field_mode == 'view-edit' ? true : false;
if ($read_only == true) {
// read only
$display_as = 'read-only';
} else {
if ($this->field_mode == 'view-edit') {
$display_as = 'view-edit';
} else {
$display_as = 'edit';
}
}
if ($this->useHtmlEntities_onField == true) {
$this->fields[$field] = isset($this->fields[$field]) ? htmlentities($this->fields[$field]) : '';
} else {
$this->fields[$field] = isset($this->fields[$field]) ? $this->fields[$field] : '';
}
switch ($type) {
case "varchar":
// Class
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . $this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "money":
// Class
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})">$<input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . $this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '';
$html_fld .= '<div class="input-prepend"><span class="add-on">$</span><input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' /></div>';
} elseif ($display_as == 'read-only') {
$html_fld .= fk_money_format($this->fields[$field]) . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "file":
// Class
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . $this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<br><iframe src="' . fk_link() . 'FkMaster/upolader/' . $field_id_html . '/" name="ifrmupl-' . $field_id_html . '" style="width:95%;height:45px;" frameborder="0"></iframe>';
$file_data = '';
$ArUpl = new ActiveRecord('uploads');
$totUpl = $ArUpl->find(@$this->fields[$field]);
if ($totUpl == 1) {
if (strrpos($ArUpl->fields['tipo'], 'image') > -1) {
//image
$file_data = '<a href="' . http_uploads() . $ArUpl->fields['archivo'] . '" target="_blank"><img src="' . http_uploads() . $ArUpl->fields['archivo'] . '" ></a>';
} else {
//Other file
$file_data = '<a href="' . http_uploads() . $ArUpl->fields['archivo'] . '" target="_blank">' . $ArUpl->fields['titulo'] . '</a>';
}
}
$html_fld .= '<div id="ico-' . $field_id_html . '">' . $file_data . '</div>';
} elseif ($display_as == 'read-only') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$file_data = '';
$ArUpl = new ActiveRecord('uploads');
$totUpl = $ArUpl->find(@$this->fields[$field]);
if ($totUpl == 1) {
if (strrpos($ArUpl->fields['tipo'], 'image') > -1) {
//image
$file_data = '<a href="' . http_uploads() . $ArUpl->fields['archivo'] . '" target="_blank"><img src="' . http_uploads() . $ArUpl->fields['archivo'] . '" ></a>';
} else {
//Other file
$file_data = '<a href="' . http_uploads() . $ArUpl->fields['archivo'] . '" target="_blank">' . $ArUpl->fields['titulo'] . '</a>';
}
}
$html_fld .= '<div id="ico-' . $this->id_field_name . '">' . $file_data . '</div>';
}
}
break;
case "timestamp":
// Class
$Class = 'class="' . @$CssName . '"';
$date_value = '';
if (trim($this->fields[$field]) != '' && trim($this->fields[$field]) != '0000-00-00 00:00:00') {
$date_value = date(DATE_FORMAT . ' H:i:s', strtotime($this->fields[$field]));
}
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= $this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . $date_value . '" ' . $Class . ' ' . @$ExtraAttributes . '/>';
$html_fld .= '<script language="javascript" type="text/javascript"> $(function() { $("#' . $field_id_html . '").datetimepicker({dateFormat: "' . JS_DATE_FORMAT . '",timeFormat: "hh:mm:ss",changeMonth: true,changeYear: true});});</script>';
} elseif ($display_as == 'edit') {
//$date_value = $this->fields[$field];
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . $date_value . '" ' . $Class . ' ' . @$ExtraAttributes . '/>';
$html_fld .= '<script language="javascript" type="text/javascript"> $(function() { $("#' . $field_id_html . '").datetimepicker({dateFormat: "' . JS_DATE_FORMAT . '",timeFormat: "hh:mm:ss",changeMonth: true,changeYear: true});});</script>';
} elseif ($display_as == 'read-only') {
$html_fld .= $date_value . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . $date_value . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "date-select":
//$Class = 'class="date '.@$CssName.'"';
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '1<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . @$Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<script language="javascript" type="text/javascript">$(function() {$( "#' . $field_id_html . '" ).datetimepicker({ dateFormat: "' . JS_DATE_FORMAT . '",showOn: "button",buttonImage: HTTP+"_HTML/img/calendar.gif", buttonImageOnly: true}); }); </script>';
} elseif ($display_as == 'edit') {
$date_value = '';
//if(trim($this->fields[$field])!=''){$date_value = date(DATE_FORMAT,strtotime($this->fields[$field]));}
$date_value = $this->fields[$field];
$Class = rtrim(str_replace('class="', '', $Class), '"');
$html_fld .= fk_date_field($field_id_html, $field_name_html, $date_value, $onclick = null, $cssExtra = $Class, $mode = 'edit');
//$html_fld .='2<input id="'.$field_id_html.'" name="'.$field_name_html.'" type="text" value="'.$date_value.'" '.@$Class.' '.@$ExtraAttributes.' />[<a href="javascript:void(0)" onclick="$(\'#'.$field_id_html.'\').val(\''.date(DATE_FORMAT).'\')">'.__('Hoy').'</a>]';
//$html_fld .='<script language="javascript" type="text/javascript">$(function(){$( "#'.$field_id_html.'" ).datetimepicker({ dateFormat: "'.JS_DATE_FORMAT.'",changeMonth: true,changeYear: true}); }); </script>';
} elseif ($display_as == 'read-only') {
$html_fld .= getFormatedDate($this->fields[$field]) . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "date":
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . @$Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<script language="javascript" type="text/javascript">$(function() {$( "#' . $field_id_html . '" ).datetimepicker({ dateFormat: "' . JS_DATE_FORMAT . '",showOn: "button",buttonImage: HTTP+"_HTML/img/calendar.gif", buttonImageOnly: true}); }); </script>';
} elseif ($display_as == 'edit') {
$date_value = '';
if (trim($this->fields[$field]) != '') {
$date_value = date(DATE_FORMAT, strtotime($this->fields[$field]));
}
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . $date_value . '" ' . @$Class . ' ' . @$ExtraAttributes . ' />[<a href="javascript:void(0)" onclick="$(\'#' . $field_id_html . '\').val(\'' . date(DATE_FORMAT) . '\');$(\'#' . $field_id_html . '\').change();">' . __('Hoy') . '</a>]';
$html_fld .= '<script language="javascript" type="text/javascript">$(function(){$( "#' . $field_id_html . '" ).datetimepicker({ dateFormat: "' . JS_DATE_FORMAT . '",changeMonth: true,changeYear: true}); }); </script>';
} elseif ($display_as == 'read-only') {
$html_fld .= getFormatedDate($this->fields[$field]) . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "text":
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><textarea style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<textarea id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
} elseif ($display_as == 'read-only') {
$html_fld .= '<div id="tx-' . $field_id_html . '">' . nl2br(@$this->fields[$field]) . '</div><input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "textarea":
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><textarea style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<textarea id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
} elseif ($display_as == 'read-only') {
$html_fld .= '<div id="tx-' . $field_id_html . '">' . nl2br(@$this->fields[$field]) . '</div><input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "tinyint":
$chk[0] = '';
$chk[1] = '';
$chk_read_val = @$this->fields[$field] == 1 ? 'Si' : 'No';
if (@$this->fields[$field] == 1 || @$this->fields[$field] == 0) {
$chk[@$this->fields[$field]] = 'CHECKED';
}
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit' || $display_as == 'edit') {
$html_fld .= 'Si<input id="' . $field_id_html . '_1" name="' . $field_name_html . '" ' . $chk['1'] . ' type="radio" value="1" ' . $Class . ' ' . @$ExtraAttributes . '>
No<input id="' . $field_id_html . '_0" name="' . $field_name_html . '" ' . $chk['0'] . ' type="radio" value="0" ' . $Class . ' ' . @$ExtraAttributes . '>';
} elseif ($display_as == 'read-only') {
$html_fld .= $chk_read_val;
}
}
break;
case "checkbox":
$chk[0] = '';
$chk[1] = '';
$chk_read_val = @$this->fields[$field] == 1 ? 'Si' : 'No';
$chk = '';
if (@$this->fields[$field] == 1) {
$chk = 'checked="checked"';
}
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit' || $display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . $this->fields[$field] . '" >';
$html_fld .= '<input id="' . $field_id_html . '_1" name="' . $field_name_html . '_1" ' . $chk . ' type="checkbox" value="1" onclick="if($(this).is(\':checked\')==true){$(\'#' . $field_id_html . '\').val(1);}else{$(\'#' . $field_id_html . '\').val(0);}" ' . $Class . ' ' . @$ExtraAttributes . '>';
} elseif ($display_as == 'read-only') {
$html_fld .= $chk_read_val;
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . $this->fields[$field] . '" >';
}
}
break;
// Tipo Password
// Tipo Password
case "password":
$Class = 'class="pass ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="password" value="" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="password" value="" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'read-only') {
$html_fld .= '********';
}
}
break;
case "select":
// Get Select Options from sql
$Class = 'class="sel ' . @$CssName . '"';
if ($access == TRUE) {
$option_selected = isset($this->form_fields[$field]['selected_option']) ? $this->form_fields[$field]['selected_option'] : @$this->fields[$field];
if ($display_as == 'view-edit') {
$options = fk_select_options($this->form_fields[$field]['sql_options'], $option_selected);
$html_fld .= '<select id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' ><option></option>' . $options . '</select>';
} elseif ($display_as == 'edit') {
$add_new_op = '';
$add_new_txt = '';
if (isset($this->form_fields[$field]['add_new'])) {
$add_new_op = '<option value="new">+ Nuevo</option>';
$add_new_txt .= '<input type="text" id="' . $field_id_html . '-txt" name="' . $field_name_html . '-txt" style="display:none" >';
$add_new_txt .= '<a href="javascript:void(0)" id="' . $field_id_html . '-cancel" style="display:none" onclick="fkSelect($(this),true);" >Cancelar</a>';
}
$options = fk_select_options($this->form_fields[$field]['sql_options'], $option_selected);
$html_fld .= '<select id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' onchange="fkSelect($(this),false);" ><option></option>' . $options . $add_new_op . '</select>';
$html_fld .= $add_new_txt;
} elseif ($display_as == 'read-only') {
if (isset($this->form_fields[$field]['sql_complex'])) {
// query complex version
$options = fk_select_complex_query($this->form_fields[$field]['sql_complex'], array($option_selected));
} else {
// Simple query version
$slq_elements = fk_get_query_elements($this->form_fields[$field]['sql_options']);
$table = $slq_elements['table'];
$val_fld_name = $slq_elements['fields'];
$options = fk_select_text($table, $val_fld_name, $option_selected);
}
$html_fld .= $options[1] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
}
}
break;
case "hidden":
$Class = 'class="hdn ' . @$CssName . '"';
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
break;
case "search_field":
// Class
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
$option_selected = isset($this->form_fields[$field]['selected_option']) ? $this->form_fields[$field]['selected_option'] : @$this->fields[$field];
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . $this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$options = fk_select_complex_query($this->form_fields[$field]['sql_complex'], array($option_selected));
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
$html_fld .= '<input id="' . $field_id_html . '-2" name="' . $field_name_html . '-2" type="text" value="' . @$options[1] . '" class="txt ' . $CssName . ' searchbox" ' . @$ExtraAttributes . ' onblur="appForm_PopupSrc({id:\'' . $field_id_html . '\',tbl:\'' . $this->table . '\'})" />
<input type="button" id="' . $field_id_html . '-btn" value=" " class="btn search2" onclick="appForm_PopupSrc({id:\'' . $field_id_html . '\',tbl:\'' . $this->table . '\',forceOpen:true})">
<input type="button" id="' . $field_id_html . '-btn" class="btn empty" value=" " onclick="appForm_ClearPopupSrc({id:\'' . $field_id_html . '\',tbl:\'' . $this->table . '\'});">
';
$html_fld .= '<div id="srcfld-rs-' . $field_id_html . '"></div>';
} elseif ($display_as == 'read-only') {
$options = fk_select_complex_query($this->form_fields[$field]['sql_complex'], array($option_selected));
$html_fld .= @$options[1] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
default:
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
}
return $html_fld;
}
public function getCellData($cell, $contentItem)
{
if (!is_int($cell)) {
throw new \Exception("cell must be an integer!!");
}
$objType = getObjectType($contentItem);
if ($cell == $this->rawCheckbox) {
if (!$contentItem instanceof \steam_trashbin) {
return "<input id=\"{$contentItem->get_id()}_checkbox\" style=\"margin-top:-4px\" type=\"checkbox\" onclick=\"event.stopPropagation(); if(this.checked) { jQuery('#{$contentItem->get_id()}').addClass('listviewer-item-selected') } else { jQuery('#{$contentItem->get_id()}').removeClass('listviewer-item-selected') }\"></input>";
} else {
return "";
}
} else {
if ($cell == $this->rawImage) {
return "<img src=\"" . PATH_URL . "explorer/asset/icons/mimetype/" . deriveIcon($contentItem) . "\"></img>";
} else {
if ($cell == $this->rawName) {
$tipsy = new \Widgets\Tipsy();
$tipsy->setElementId($contentItem->get_id() . "_" . $this->rawName);
$tipsy->setHtml("<div style=\"font-weight:bold; width:100px; float:left;\">Besitzer</div> <img style=\"margin: 3px\" align=\"middle\" src=\"" . PATH_URL . "download/image/" . $contentItem->get_creator()->get_attribute(OBJ_ICON)->get_id() . "/30/30\"> " . $contentItem->get_creator()->get_attribute(USER_FIRSTNAME) . " " . $contentItem->get_creator()->get_attribute(USER_FULLNAME) . "<br clear=\"all\">" . "<div style=\"font-weight:bold; width:100px; float:left;\">zuletzt geändert</div> " . getFormatedDate($contentItem->get_attribute(OBJ_LAST_CHANGED)) . "<br>" . "<div style=\"font-weight:bold; width:100px; float:left;\">erstellt</div> " . getFormatedDate($contentItem->get_attribute(OBJ_CREATION_TIME)) . "<br>");
$url = PATH_URL . "explorer/index/" . $contentItem->get_id() . "/";
$desc = $contentItem->get_attribute("OBJ_DESC");
//$name = $objectModel->getReadableName();
$name = getCleanName($contentItem, 50);
if (isset($url) && $url != "") {
return "<a href=\"" . $url . "\" title=\"{$desc}\"> " . $name . "</a>" . "<script>" . $tipsy->getHtml() . "</script>";
} else {
return $name . "<script>" . $tipsy->getHtml() . "</script>";
}
} else {
if ($cell == $this->rawMarker) {
$html = "";
if ($objType == "referenceFile") {
$html .= "<div class=\"marker\">" . \Explorer\Model\Sanction::getMarkerHtml($contentItem->get_link_object()) . "</div>";
} else {
$html .= "<div class=\"marker\">" . \Explorer\Model\Sanction::getMarkerHtml($contentItem) . "</div>";
}
$html .= "<div class=\"marker\" id=\"{$contentItem->get_id()}_BookmarkMarkerWrapper\">";
$linkError = false;
if ($contentItem instanceof \steam_exit) {
$exitObject = $contentItem->get_exit();
if ($exitObject instanceof \steam_object) {
$id = $exitObject->get_id();
} else {
$linkError = true;
$html .= "<div style=\"color:red\">Link defekt</div>";
}
} else {
if ($contentItem instanceof \steam_link) {
$linkObject = $contentItem->get_link_object();
if ($linkObject instanceof \steam_object) {
$id = $linkObject->get_id();
} else {
$linkError = true;
$html .= "<div style=\"color:red\">Link defekt</div>";
}
} else {
$id = $contentItem->get_id();
}
}
if (!$linkError && \Bookmarks\Model\Bookmark::isBookmark($id)) {
$html .= \Bookmarks\Model\Bookmark::getMarkerHtml($id);
}
$html .= "</div>";
return $html;
} else {
if ($cell == $this->rawChangeDate) {
if ($objType == "referenceFile") {
return getReadableDate($contentItem->get_link_object()->get_attribute("OBJ_LAST_CHANGED"));
} else {
return getReadableDate($contentItem->get_attribute("OBJ_LAST_CHANGED"));
}
} else {
if ($cell == $this->rawSize) {
return getObjectReadableSize($contentItem);
} else {
if ($cell == $this->rawMenu) {
$popupMenu = new \Widgets\PopupMenu();
$popupMenu->setData($contentItem);
$popupMenu->setElementId("listviewer-overlay");
return $popupMenu;
}
}
}
}
}
}
}
}
/**
* Die Methode liefert die Beschreibung zur Serien-Wiederholung als Text zurück.
* Text: "Dieser Termin wiederholt sich ....."
*
* @param int(11) ID des Termins
*
* @return String Beschreibungstext
*/
function getTerminDatumText($id)
{
$ret = "";
// Termin-Infos holen
$sqlTermin = "SELECT t.*, m.name as Muster_Name FROM terminserie t, terminserien_muster m ";
$sqlTermin .= "WHERE t.serienmuster = m.id ";
$sqlTermin .= "AND t.id = " . $id;
$resultTermin = mysql_query($sqlTermin);
if (mysql_num_rows($resultTermin) == 1) {
$row = mysql_fetch_array($resultTermin);
// Einzeltermin anzeigen
if ($row['serienmuster'] == -1) {
// Einzel-Termin
$ret = getFormatedDate($row['fixdatum']) . "\n\r";
// Terminserie anzeigen
} else {
$ret .= "Jeden ";
switch ($row['serienmuster']) {
case 1:
// Täglich
if ($row['xten'] > 1) {
$ret .= $row['xten'] . ". ";
}
$ret .= "Tag";
if ($row['montag'] == "J" && $row['dienstag'] == "J" && $row['mittwoch'] == "J" && $row['donnerstag'] == "J" && $row['freitag'] == "J" && $row['samstag'] == "N" && $row['sonntag'] == "N") {
$ret .= "(gilt nur an Werktagen)";
}
break;
case 2:
// Monatlich
if ($row['xten'] > 1) {
$ret .= $row['xten'] . ". ";
}
$chkBool = false;
if ($row['montag'] == "J") {
$ret .= "Montag ";
$chkBool = true;
}
if ($row['dienstag'] == "J") {
if ($chkBool) {
$ret .= ",";
}
$ret .= "Dienstag ";
$chkBool = true;
}
if ($row['mittwoch'] == "J") {
if ($chkBool) {
$ret .= ",";
}
$ret .= "Mittwoch ";
$chkBool = true;
}
if ($row['donnerstag'] == "J") {
if ($chkBool) {
$ret .= ",";
}
$ret .= "Donnerstag ";
$chkBool = true;
}
if ($row['freitag'] == "J") {
if ($chkBool) {
$ret .= ",";
}
$ret .= "Freitag ";
$chkBool = true;
}
if ($row['samstag'] == "J") {
if ($chkBool) {
$ret .= ",";
}
$ret .= "Samstag ";
$chkBool = true;
}
if ($row['sonntag'] == "J") {
if ($chkBool) {
$ret .= ",";
}
$ret .= "Sonntag ";
}
break;
case 3:
// Wöchentlich
if ($row['monatwochentagjn'] == "N") {
$ret .= $row['xten'] . ". Tag jedes " . $row['xten2'] . ". Monats.";
} else {
$ret .= $row['xten'] . ". " . getWochentag($row) . " jedes " . $row['xten2'] . ". Monats.";
}
break;
case 4:
// Jährlich
if ($row['jaehrlichwochentag'] == "N") {
$ret .= $row['xten'] . ". " . getMonatsString($row['monat']) . " ";
} else {
$ret .= $row['xten'] . ". " . getWochentag($row) . " im " . getMonatsString($row['monat']) . " ";
}
break;
}
if ($row['enddatumjn'] == "J") {
$ret .= "\r\nGültig ab: " . getFormatedDate($row['serien_start_datum']) . " bis: " . getFormatedDate($row['serien_end_datum']) . "\n\r";
}
}
}
return $ret;
}
function updateEvento($con, $request)
{
// echo $request["IdComercial"][1];
//$nueva=json_encode($request["IdComercial"]);
$idComercial = $request->IdComercial[0]->Id;
$idTipoEvento = $request->EventoTipo[0]->Id;
//echo "TIPOEV".$idTipoEvento;
$update = "UPDATE`Eventos` set codigo='" . $request->Codigo . "' , TotalBudget='" . $request->TotalBudget . "',FechaActualizacion='" . getFechaHoy() . "' ,idUsuarioComercial='" . $idComercial . "' ,FechaDesde='" . getFormatedDate($request->FechaDesde) . "' ,FechaPresentacion='" . getFormatedDate($request->FechaPresentacion) . "',FechasAlt ='" . getEsFechaAlt($request) . "',Pax='" . $request->Pax . "' ,Comentarios='" . $request->Comentario . "',Presupuesto='" . $request->Presupuesto . "',IdTipoEvento='" . $idTipoEvento . "' ,nombre='" . $request->Nombre . "', FechaHasta ='" . getFormatedDate($request->FechaHasta) . "' ,IdActualizadoPor='" . $_SESSION['idUser'] . "',IdUsuarioProductor='" . getProductor($request) . "',IdStage='" . getStage($request) . "' where id='" . $request->Id . "'";
if (!mysqli_query($con, $update)) {
printf("Errormessage: %s\n", mysql_error());
} else {
addNotifiacion($con, "Edicion", $request->Id, $_SESSION['idUser'], 1, 1);
addNotifiacion($con, "Edicion", $request->Id, $_SESSION['idUser'], 2, 1);
}
//echo "ENTRO".$update;
}
/**
*@package db_record
*@method print_form_field()
*@desc returns the list of html fields automatically from a record
*@since v0.1 beta
* */
public function print_form_field($field, $CssName = '', $ExtraAttributes = '', $encode_fields = FALSE, $access = TRUE, $read_only = FALSE)
{
$html_fld = '';
if ($encode_fields == TRUE) {
$field_id_html = 'fkf_' . encode($field);
$field_name_html = encode($field);
} else {
$field_id_html = $field;
$field_name_html = $field;
}
$original_type = $this->form_fields[$field]['Type'];
$type_x = explode("(", $original_type);
if ($type_x > 1) {
$type = $type_x[0];
} else {
$type = $original_type;
}
// Display Mode
$mode_view_edit = $this->field_mode == 'view-edit' ? true : false;
if ($read_only == true) {
// read only
$display_as = 'read-only';
} else {
if ($this->field_mode == 'view-edit') {
$display_as = 'view-edit';
} else {
$display_as = 'edit';
}
}
$this->fields[$field] = isset($this->fields[$field]) ? htmlentities($this->fields[$field]) : '';
switch ($type) {
case "varchar":
// Class
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . $this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "timestamp":
// Class
$Class = 'class="date-time ' . @$CssName . '"';
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . '/>
<script language="javascript" type="text/javascript">
$(function() {
$( "#' . $field_id_html . '" ).datepicker({
dateFormat: "yy-mm-dd",
showOn: "button",
buttonImage: HTTP+"_HTML/img/calendar.gif",
buttonImageOnly: true
});
});
</script>';
break;
case "date":
//$Class = 'class="date '.@$CssName.'"';
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . @$Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<script language="javascript" type="text/javascript">$(function() {$( "#' . $field_id_html . '" ).datepicker({ dateFormat: "yy-mm-dd",showOn: "button",buttonImage: HTTP+"_HTML/img/calendar.gif", buttonImageOnly: true}); }); </script>';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . @$Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<script language="javascript" type="text/javascript">$(function(){$( "#' . $field_id_html . '" ).datepicker({ dateFormat: "yy-mm-dd",showOn: "button",buttonImage: HTTP+"_HTML/img/calendar.gif", buttonImageOnly: true}); }); </script>';
} elseif ($display_as == 'read-only') {
$html_fld .= getFormatedDate($this->fields[$field]) . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "text":
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><textarea style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<textarea id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "textarea":
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><textarea style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<textarea id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' >' . @$this->fields[$field] . '</textarea>';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
case "tinyint":
$chk[0] = '';
$chk[1] = '';
$chk_read_val = @$this->fields[$field] == 1 ? 'Si' : 'No';
if (@$this->fields[$field] == 1 || @$this->fields[$field] == 0) {
$chk[@$this->fields[$field]] = 'CHECKED';
}
$Class = 'class="' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit' || ($display_as = 'edit')) {
$html_fld .= 'Si<input id="' . $field_id_html . '_1" name="' . $field_name_html . '" ' . $chk['1'] . ' type="radio" value="1" ' . $Class . ' ' . @$ExtraAttributes . '>
No<input id="' . $field_id_html . '_0" name="' . $field_name_html . '" ' . $chk['0'] . ' type="radio" value="0" ' . $Class . ' ' . @$ExtraAttributes . '>';
} elseif ($display_as == 'read-only') {
$html_fld .= $chk_read_val;
}
}
break;
// Tipo Password
// Tipo Password
case "password":
$Class = 'class="pass ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="password" value="" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="password" value="" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'read-only') {
$html_fld .= '********';
}
}
break;
case "select":
// Get Select Options from sql
$Class = 'class="sel ' . @$CssName . '"';
if ($access == TRUE) {
$option_selected = isset($this->form_fields[$field]['selected_option']) ? $this->form_fields[$field]['selected_option'] : @$this->fields[$field];
if ($display_as == 'view-edit') {
$options = fk_select_options($this->form_fields[$field]['sql_options'], $option_selected);
$html_fld .= '<select id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' ><option></option>' . $options . '</select>';
} elseif ($display_as == 'edit') {
$options = fk_select_options($this->form_fields[$field]['sql_options'], $option_selected);
$html_fld .= '<select id="' . $field_id_html . '" name="' . $field_name_html . '" ' . $Class . ' ' . @$ExtraAttributes . ' ><option></option>' . $options . '</select>';
} elseif ($display_as == 'read-only') {
$slq_elements = fk_get_query_elements($this->form_fields[$field]['sql_options']);
$table = $slq_elements['table'];
$val_fld_name = $slq_elements['fields'];
$options = fk_select_text($table, $val_fld_name, $option_selected);
$html_fld .= $options[1] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
}
}
break;
case "hidden":
$Class = 'class="hdn ' . @$CssName . '"';
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
break;
case "search_field":
// Class
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . $this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' /><input type="button" value="..." onclick="appForm_PopupSrc({id:\'' . $field_id_html . '\',tbl:\'' . $this->table . '\'})">';
$html_fld .= '<div id="srcfld-rs-' . $field_id_html . '"></div>';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
default:
$Class = 'class="txt ' . @$CssName . '"';
if ($access == TRUE) {
if ($display_as == 'view-edit') {
$html_fld .= '<div class="fld" onclick="appForm_updfldTxt({id:\'' . $field_id_html . '\'})"><input style="display:none" id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
$html_fld .= '<span id="val-' . $field_id_html . '">' . @$this->fields[$field] . '</span> <span class="ui-icon ui-icon-gear"></span></div>';
$html_fld .= '<input id="cur-v-' . $field_id_html . '" type="hidden" value="' . @$this->fields[$field] . '" />';
} elseif ($display_as == 'edit') {
$html_fld .= '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="text" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
} elseif ($display_as == 'read-only') {
$html_fld .= @$this->fields[$field] . '<input id="' . $field_id_html . '" name="' . $field_name_html . '" type="hidden" value="' . @$this->fields[$field] . '" ' . $Class . ' ' . @$ExtraAttributes . ' />';
}
}
break;
}
return $html_fld;
}
public function ajaxResponse(\AjaxResponseObject $ajaxResponseObject)
{
$type = "";
$object = \steam_factory::get_object($GLOBALS["STEAM"]->get_id(), $this->id);
$type = getObjectType($object);
switch ($type) {
case "document":
$labelName = "Dateiname";
$typeName = "Dokument";
break;
case "forum":
$labelName = "Forumname";
$typeName = "Forum";
break;
case "referenceFolder":
$labelName = "Linkname";
$typeName = "Referenz";
break;
case "referenceFile":
$labelName = "Linkname";
$typeName = "Referenz";
break;
case "user":
$labelName = "Benutzername";
$typeName = "Benutzer";
break;
case "group":
$labelName = "Gruppenname";
$typeName = "Gruppe";
break;
case "trashbin":
$labelName = "Papierkorb";
$typeName = "Papierkorb";
break;
case "gallery":
$labelName = "Galeriename";
$typeName = "Galerie";
break;
case "portal":
$labelName = "Portalname";
$typeName = "Portal";
break;
case "portalColumn":
$labelName = "Spaltenname";
$typeName = "Portal-Spalte";
break;
case "portalPortlet":
$labelName = "Portletname";
$typeName = "Portal-Portlet";
break;
case "userHome":
$labelName = "Ordnername";
$typeName = "Benutzerordner";
break;
case "groupWorkroom":
$labelName = "Ordnername";
$typeName = "Gruppen-Arbeitsraum";
break;
case "room":
$labelName = "Ordnername";
$typeName = "Ordner";
break;
case "container":
$labelName = "Ordnername";
$typeName = "Ordner";
break;
case "unknown":
$labelName = "Name";
$typeName = "unbekannt";
break;
default:
$labelName = "Name";
$typeName = "unbekannt";
break;
}
$dialog = new \Widgets\Dialog();
$dialog->setTitle("Eigenschaften von »" . getCleanName($object) . "«<br>({$typeName})");
$dialog->setPositionX($this->params["mouseX"]);
$dialog->setPositionY($this->params["mouseY"]);
if ($type == "userHome" || $type == "groupWorkroom") {
$dataNameInput = new \Widgets\TextInput();
$dataNameInput->setLabel("{$labelName}");
$dataNameInput->setData($object);
$dataNameInput->setReadOnly(true);
$dataNameInput->setContentProvider(\Widgets\DataProvider::staticProvider(getCleanName($object, -1)));
/* $titelInput = new \Widgets\TextInput();
$titelInput->setLabel("Titel (Beschreibung)");
$titelInput->setData($object);
$titelInput->setContentProvider(\Widgets\DataProvider::staticProvider(getCleanName($object)));*/
} else {
$dataNameInput = new \Widgets\TextInput();
$dataNameInput->setLabel("{$labelName}");
$dataNameInput->setData($object);
$dataNameInput->setContentProvider(new NameAttributeDataProvider("OBJ_NAME", getCleanName($object, -1)));
if ($type == "document") {
$docType = $object->get_attribute("DOC_MIME_TYPE");
$isJpg = strpos($docType, "jpg") !== false;
$isJpeg = strpos($docType, "jpeg") !== false;
$isGif = strpos($docType, "gif") !== false;
$isPng = strpos($docType, "png") !== false;
if ($isGif || $isJpeg || $isJpg || $isPng) {
$textArea = new \Widgets\Textarea();
$textArea->setLabel("Beschreibung");
$textArea->setData($object);
$textArea->setContentProvider(\Widgets\DataProvider::attributeProvider("OBJ_DESC"));
$textArea->setHeight(100);
$desc = $object->get_attribute("OBJ_DESC");
if ($desc !== 0) {
$jsWrapperPicture = new \Widgets\JSWrapper();
$jsWrapperPicture->setJs('$(".plain").val("' . $desc . '")');
}
}
}
/* $titelInput = new \Widgets\TextInput();
$titelInput->setLabel("Titel (Beschreibung)");
$titelInput->setData($object);
$titelInput->setContentProvider(\Widgets\DataProvider::attributeProvider("OBJ_DESC"));*/
}
$ownerField = new \Widgets\TextField();
$ownerField->setLabel("Besitzer");
$creator = $object->get_creator();
$creatorName = getCleanName($creator);
$ownerField->setValue($creatorName);
$changedField = new \Widgets\TextField();
$changedField->setLabel("zuletzt geändert");
$changedDate = $object->get_attribute(OBJ_LAST_CHANGED);
$changedDate = getFormatedDate($changedDate);
$changedField->setValue($changedDate);
$createdField = new \Widgets\TextField();
$createdField->setLabel("erstellt");
$createDate = $object->get_attribute(OBJ_CREATION_TIME);
$createDate = getFormatedDate($createDate);
$createdField->setValue($createDate);
//$hiddenCheckbox = new \Widgets\Checkbox();
//$hiddenCheckbox->setLabel("Verstecken");
//$hiddenCheckbox->setCheckedValue("1");
//$hiddenCheckbox->setUncheckedValue(0);
//$hiddenCheckbox->setData($object);
//$hiddenCheckbox->setContentProvider(\Widgets\DataProvider::attributeProvider("bid:hidden"));
$containerViewRadio = new \Widgets\RadioButton();
$containerViewRadio->setLabel("Erstes Dokument");
$containerViewRadio->setData($object);
$containerViewRadio->setOptions(array(array("name" => "Normal (Ordneransicht)", "value" => "normal"), array("name" => "Deckblatt (statt der Ordneransicht)", "value" => "index"), array("name" => "Kopfdokument (über der Ordneransicht)", "value" => "head")));
$containerViewRadio->setDefaultChecked("normal");
$containerViewRadio->setContentProvider(\Widgets\DataProvider::attributeProvider("bid:presentation"));
// $descriptionTextarea = new \Widgets\Textarea();
// $descriptionTextarea->setLabel("Beschreibung");
// $descriptionTextarea->setData($object);
// $descriptionTextarea->setContentProvider(\Widgets\DataProvider::attributeProvider("bid:description"));
//TODO: value is array
$keywordArea = new \Widgets\TextInput();
$keywordArea->setLabel("Schlüsselwörter");
$keywordArea->setData($object);
$keywordArea->setContentProvider(\Widgets\DataProvider::attributeProvider("OBJ_KEYWORDS"));
//TODO: bid-attribute
$descriptionInput = new \Widgets\TextInput();
$descriptionInput->setLabel("Beschreibung");
$descriptionInput->setData($object);
$descriptionInput->setContentProvider(\Widgets\DataProvider::attributeProvider("bid:description"));
$checkboxInput = new \Widgets\Checkbox();
$checkboxInput->setLabel("Benutzer dürfen editieren?");
$checkboxInput->setCheckedValue("1");
$checkboxInput->setUncheckedValue(0);
$checkboxInput->setData($object);
$checkboxInput->setContentProvider(\Widgets\DataProvider::attributeProvider("bid:forum_is_editable"));
$seperator = new \Widgets\RawHtml();
$seperator->setHtml("<br style=\"clear:both\"/>");
$headlineAlg = new \Widgets\RawHtml();
$headlineAlg->setHtml("<h3>Allgemein</h3>");
$headlineMeta = new \Widgets\RawHtml();
$headlineMeta->setHtml("<h3>Meta-Informationen</h3>");
$headlineView = new \Widgets\RawHtml();
$headlineView->setHtml("<h3>Darstellung</h3>");
$dialog->addWidget($headlineAlg);
//$dialog->addWidget($titelInput);
//$dialog->addWidget($seperator);
if ($type == "document") {
$docType = $object->get_attribute("DOC_MIME_TYPE");
$isJpg = strpos($docType, "jpg") !== false;
$isJpeg = strpos($docType, "jpeg") !== false;
$isGif = strpos($docType, "gif") !== false;
$isPng = strpos($docType, "png") !== false;
if ($isGif || $isJpeg || $isJpg || $isPng) {
$fileName = new \Widgets\TextInput();
$fileName->setLabel("Dateiname");
$fileName->setData($object);
$fileName->setContentProvider(\Widgets\DataProvider::attributeProvider("OBJ_NAME"));
$dialog->addWidget($fileName);
}
} else {
$dialog->addWidget($dataNameInput);
}
$dialog->addWidget($seperator);
$dialog->addWidget($ownerField);
$dialog->addWidget($seperator);
$dialog->addWidget($changedField);
$dialog->addWidget($seperator);
$dialog->addWidget($createdField);
$dialog->addWidget($seperator);
if ($type == "container" || $type == "room") {
$dialog->addWidget($headlineView);
//$dialog->addWidget($hiddenCheckbox);
//$dialog->addWidget($seperator);
$dialog->addWidget($containerViewRadio);
$dialog->addWidget($seperator);
} else {
if ($type == "document") {
$docType = $object->get_attribute("DOC_MIME_TYPE");
$isJpg = strpos($docType, "jpg") !== false;
$isJpeg = strpos($docType, "jpeg") !== false;
$isGif = strpos($docType, "gif") !== false;
$isPng = strpos($docType, "png") !== false;
if ($isGif || $isJpeg || $isJpg || $isPng) {
$dialog->addWidget($textArea);
$dialog->addWidget($jsWrapperPicture);
}
} else {
if ($type == "forum") {
$creatorId = $creator->get_id();
$currentUser = $GLOBALS["STEAM"]->get_current_steam_user();
$currentUserId = $currentUser->get_id();
if ($currentUserId == $creatorId) {
// $checkValue= $object->get_attribute("bid:forum_is_editable");
// $checked = $checkValue ? 1 : 0;
// $checkboxInput;
$dialog->addWidget($checkboxInput);
$dialog->addWidget($seperator);
}
}
}
}
// $dialog->addWidget($headlineMeta);
// $dialog->addWidget($keywordArea);
// $dialog->addWidget($seperator);
// $dialog->addWidget($descriptionInput);
$ajaxResponseObject->setStatus("ok");
$ajaxResponseObject->addWidget($dialog);
return $ajaxResponseObject;
}
/**
* gibt den im DbTable ermittelten Wert zurÃÂÃÂÃÂück (wenn nicht geÃÂÃÂÃÂändert)
*
* AUSNAHME: Datum -> wird im Standard-Format zurÃÂÃÂÃÂückgegeben.
*/
function getAttribute($colIndex)
{
$ret = "";
$tn1 = explode(',', $this->TABLENAME);
$preTabAliasx = explode(' ', $tn1[0]);
//prÃÂÃÂÃÂüft ob aliase verwendet werden
if (count($preTabAliasx) > 1) {
$preTabAlias = $preTabAliasx[1] . ".";
} else {
$preTabAlias = "";
}
//Spaltennamen Komma-getrennt verketten
$COLNAMESTRING = "";
if (count($this->COLNAMES) > 0) {
$chk = 0;
foreach ($this->COLNAMES as $cn) {
if ($chk > 0) {
$COLNAMESTRING .= ", ";
}
$COLNAMESTRING .= $cn;
$chk++;
}
} else {
$COLNAMESTRING = "*";
}
//Leer? dann Abbruch
if (strlen($COLNAMESTRING) == 0) {
exit;
}
//Gebe Wert aus Row zurÃÂÃÂÃÂück wenn vorhanden
// Datum wird hier noch formatiert
if (isset($this->ROW[$colIndex])) {
$result = $_SESSION['config']->DBCONNECT->executeQuery("SELECT " . $COLNAMESTRING . ", " . $preTabAlias . "id as rowid FROM " . $this->TABLENAME . " " . " LIMIT 1");
$ret = $this->ROW[$colIndex];
if (mysql_field_type($result, $colIndex) == "date") {
$ret = getFormatedDate($ret, "standard");
}
}
return $ret;
}
function show()
{
//Wenn notwendig Eingabemaske, ansonsten Standard-Anzeige
if (!$this->showInsertMaskIfNeeded()) {
$rowsToShow = $this->getRowsToShow();
//Tabelle fÃÂÃÂÃÂür gesamte NEWS
$tbl = new Table(array("News"));
$tbl->setHeadEnabled(false);
$tbl->setBorder(0);
foreach ($rowsToShow as $row) {
$tt = new Text($row['Text']);
$tt->setFilter(false);
$ta = new Text($row['Autor']);
$tblxTitle = new Table(array("", ""));
$tblxTitle->setColSizes(array("50"));
$tblxTitle->setAlign("left");
$rxtitle = $tblxTitle->createRow();
$t0 = new Title(getFormatedDate($row['Datum'], "standard") . ":");
$t0->setWidth(20);
$rxtitle->setAttribute(0, $t0);
$t1 = new Title($row['Title']);
$rxtitle->setAttribute(1, $t1);
$rxtitle->setAlign("left");
$tblxTitle->addRow($rxtitle);
//Tabelle fÃÂÃÂÃÂür den jeweiligen Eintrag
$tblx = new Table(array(""));
if (strlen($row['pic']) > 0) {
$tblx = new Table(array("", ""));
$tblx->setColSizes(array("180"));
}
$tblx->setBorder($this->CONFIG->GB_CONFIG['border']);
$tblx->setWidth("100%");
//TEXT
$rx = $tblx->createRow();
if (strlen($row['pic']) > 0 && !(isset($_REQUEST['removeNewsPicId']) && $_REQUEST['removeNewsPicId'] == $row['id'])) {
$img = new Image($row['pic']);
$img->setWidth(175);
$rx->setAttribute(0, $img);
$rx->setAttribute(1, $tt);
} else {
$rx->setAttribute(0, $tt);
}
$rx->setAlign("left");
$tblx->addRow($rx);
$f = new FontType();
$rx->setFonttypes(array(0 => $f));
$f = new FontType();
$f->setFontsize(1);
$f->setItalic(false);
$rx->setFonttypes(array(0 => $f));
$r = $tbl->createRow();
$r->setAttribute(0, $tblxTitle);
$tbl->addRow($r);
$r1 = $tbl->createRow();
$r1->setAttribute(0, $tblx);
$tbl->addRow($r1);
$ytElem = new YouTubeElement($row['yt_video'], "news", "yt_video", $row['id']);
$r1 = $tbl->createRow();
$r1->setAttribute(0, $ytElem);
$tbl->addRow($r1);
$tbl->addSpacer(0, 7);
if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user") {
$r2 = $tbl->createRow();
$xDv = new Div();
$xDv->setWidth(450);
$xDv->setHeight(40);
$txChngePic = new Text("Bild Hochladen/ÃÂÃÂÃÂÃÂndern<br>");
$txChngePic->setFilter(false);
$newPicLink = new Link("?popupRunLink=imageUploaderPopup&targetPath=pics/news&DbInsertTable=news&DbInsertCol=pic&DbInsertId=" . $row['id'] . "&stayAlive=ok", $txChngePic);
$txRemPic = new Text("Bild Entfernen<br>");
$txRemPic->setFilter(false);
$removePicLink = new Link("?removeNewsPicId=" . $row['id'] . "", $txRemPic);
$spTx = new Text(" ");
$spTx->setFilter(false);
$xDv->add($newPicLink);
if (strlen($row['pic']) > 0) {
if (isset($_REQUEST['removeNewsPicId']) && $_REQUEST['removeNewsPicId'] == $row['id']) {
$sql = "UPDATE news SET pic = null WHERE id = " . $_REQUEST['removeNewsPicId'];
$_SESSION['config']->DBCONNECT->executeQuery($sql);
} else {
$xDv->add($removePicLink);
}
}
$newPicLink->setPopup(true);
$r2->setAttribute(0, $xDv);
$tbl->addRow($r2);
}
$tbl->addSpacer(0, 35);
}
if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user") {
// Neuer Eintrag- BUTTON
//--------------------------------
$insertButton = new Button('dbTableNew', 'News eintragen');
$form = new Form($_SERVER['SCRIPT_NAME']);
$form->add($insertButton);
$form->show();
}
// Tabelle anzeigen
//--------------------------------
$tbl->show();
if ($_SESSION['config']->CURRENTUSER->STATUS == "admin" || $_SESSION['config']->CURRENTUSER->STATUS == "user" && $tbl->getRowcount() > 2) {
// Neuer Eintrag- BUTTON
//--------------------------------
$insertButton = new Button('dbTableNew', 'News eintragen');
$form = new Form($_SERVER['SCRIPT_NAME']);
$form->add($insertButton);
$form->show();
}
}
}
