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(); } } }