items;
if (!is_array($original_items) || count ($original_items) == 0) return false;
$this->settings_fields = $settings_fields;
if (!is_array( $general_settings)) {
$this->general_settings = [];
} else {
$this->general_settings = $general_settings;
}
$items = array_map(function ($object) {
if (is_object($object)) {
return clone $object;
} else {
return $object;
}
}, $original_items);
$items = $this->filter_by_edit_variables($items);
$array_thead = array_shift($items);
/**
* @var Array $first_row
*/
$first_row = [];
$primaries = $table_model->get_pirmaries();
foreach ($array_thead as $key => $value) {
$row_sorting = true;
$schema = (isset($value['schema'])) ? $value['schema'] : $key;
if (is_object($schema)) {
if (@$schema->type != "CUSTOM") {
$field_key = $this->get_column_name($schema, 'alias');
$simple_type = $schema->type;
} else {
$field_key = $schema->name;
$row_sorting = false;
$simple_type = "gen";
}
} else {
$row_sorting = false;
$simple_type = "gen";
$field_key = '';
}
$original_field_name = $this->get_column_name($schema, 'column');
$name_column = ADFO_fn::clean_string($field_key);
$orgtable = (isset($schema->orgtable)) ? $schema->orgtable : '';
$orgname = (isset($schema->orgname)) ? $schema->orgname : '';
$table = (isset($schema->table)) ? $schema->table : '';
if (is_array($value) && array_key_exists('setting', $value) && isset($value['setting']->title)) {
$print_column_name = $value['setting']->title;
} else {
$print_column_name = $key;
}
if (is_array($value) && array_key_exists('setting', $value) ) {
$width = $this->get_width_class($value['setting']);
} else {
$width = "";
}
$drop_down = is_object($schema);
if (isset($settings_fields[$key])) {
$print_column_name =$settings_fields[$key]->title;
$drop_down = ($settings_fields[$key]->view == "CUSTOM" || $settings_fields[$key]->view == "LOOKUP") ? false : $drop_down;
}
$pri = ($table != "" && isset($primaries[$orgtable]) && strtolower($primaries[$orgtable]) == strtolower($orgname));
$first_row[$key] = (object)['name'=>$print_column_name, 'original_table' => $orgtable, 'table' => $table, 'name_column'=>$name_column, 'original_name' => $orgname,'field_key'=>$field_key, 'original_field_name'=>$original_field_name,'toggle'=>(isset($value['toggle']) ? $value['toggle'] : 'SHOW'), 'type'=> $simple_type, 'sorting'=>$row_sorting, 'dropdown' => $drop_down, 'width'=>$width, 'align'=>@$value['align'], 'mysql_name' => @$value['mysql_name'], 'name_request' => @$value['name_request'], 'searchable' => @$value['searchable'], 'custom_param' => @$value['custom_param'], 'format_values' => @$value['format_values'], 'format_styles' => @$value['format_styles'], 'pri'=>$pri];
}
$count = 0;
foreach ($items as $count=>&$item) {
$item = (object)$item;
//PinaCode::set_var('data', $item);
foreach ($array_thead as $key=>$setting) {
$count++;
if (isset($setting['schema']) && ($setting['schema']->type =="WP_HTML" || $setting['schema']->type =="CHECKBOX")) {
if (is_object($item)) {
if (isset($item->$key)) {
$value = $item->$key;
} else {
$value = "";
}
} else {
if (isset($item[$key])) {
$value = $item[$key];
} else {
$value = "";
}
}
$item->$key = $value;
} else {
PinaCode::set_var("data", $item);
$item->$key = $this->edit_singe_cell($item, $key, $setting, $count, $table_model, $dbp_id);
}
}
}
array_unshift($items, $first_row);
return $items;
}
/**
* Nell'elenco di una lista gestisce i parametri di visualizzazione dei campi della tabella
* aggiunge i filtri e converte il type
*/
private function filter_by_edit_variables($items) {
// la prima riga posso togliere i campi che non voglio visualizzare
reset($items);
$first_key = key($items);
$new_first_key = [];
if (is_array($this->settings_fields) && count ($this->settings_fields) > 0) {
foreach ( $this->settings_fields as $key=>$setting) {
if (array_key_exists($key, $items[$first_key])) {
$new_first_key[$key] = $items[$first_key][$key];
} else {
$new_first_key[$key] = ['schema'=>(object)['type'=>'CUSTOM', 'name'=>$key]];
}
$new_first_key[$key]['setting'] = $setting;
if ($setting->isset('view') && $setting->view != "") {
$new_first_key[$key]['schema']->type = $setting->view;
} else {
$new_first_key[$key]['schema']->type = ADFO_fn::h_type2txt($new_first_key[$key]['schema']->type);
}
$new_first_key[$key]['align'] = $setting->align;
$new_first_key[$key]['order'] = $setting->order;
$new_first_key[$key]['toggle'] = $setting->toggle;
$new_first_key[$key]['name_request'] = $setting->name_request;
$new_first_key[$key]['mysql_name'] = $setting->mysql_name;
$new_first_key[$key]['searchable'] = $setting->searchable;
$new_first_key[$key]['custom_param'] = $setting->custom_param;
$new_first_key[$key]['format_values'] = $setting->format_values;
$new_first_key[$key]['format_styles'] = $setting->format_styles;
if ( $setting->view == 'LOOKUP') {
$new_first_key[$key]['lookup_id'] = $setting->lookup_id;
$new_first_key[$key]['lookup_sel_val'] = $setting->lookup_sel_val;
$new_first_key[$key]['lookup_sel_txt'] = $setting->lookup_sel_txt;
}
}
$items[$first_key] = $new_first_key;
$columns = array_column($items[$first_key], 'order');
array_multisort($columns, SORT_ASC, $items[$first_key]);
} else {
foreach ($items[$first_key] as $key=>$value) {
if (isset($value['schema']) && is_object($value['schema'])) {
$items[$first_key][$key]['schema']->type = ADFO_fn::h_type2txt($value['schema']->type);
}
}
}
return $items;
}
/**
* Fa il rendering dei singoli valori
*/
private function edit_singe_cell($item, $key, $setting, $count, $table_model, $dbp_id) {
/**
* @var String $value
*/
if (is_object($item)) {
if (isset($item->$key)) {
$value = $item->$key;
} else {
$value = "";
}
} else {
if (isset($item[$key])) {
$value = $item[$key];
} else {
$value = "";
}
}
$value = html_entity_decode($value);
$max_char_show = $this->max_text_length();
if (isset($setting['setting']) && is_object($setting['setting'])) {
if (@$setting['setting']->view == "DATE") {
if (isset($setting['custom_param']) && $setting['custom_param'] != "") {
$date_format = $setting['custom_param'];
} else {
$date_format = get_option('date_format');
}
if ($value == '0000-00-00 00:00:00' || $value == '0000-00-00') {
$value = '-';
} else {
$time = strtotime($value);
if ($time !== false) {
$value = date($date_format, strtotime($value));
}
}
$max_char_show = 2000;
} else if (@$setting['setting']->view == "DATETIME" || (@$setting['setting']->view == "" && $setting['schema']->type=="DATE")) {
if (isset($setting['custom_param']) && $setting['custom_param'] != "") {
$date_format = $setting['custom_param'];
} else {
$date_format = get_option('date_format')." ".get_option('time_format');
}
if ($value == '0000-00-00 00:00:00' || $value == '0000-00-00') {
$value = '-';
} else {
$time = strtotime($value);
if ($time !== false) {
$value = date($date_format, strtotime($value));
}
}
$max_char_show = 2000;
} else if (@$setting['setting']->view == "SERIALIZE") {
$max_char_show = -1;
$value = maybe_unserialize($value);
if (is_object($value) || is_array($value)) {
$value = $this->show_obj($value, 1, $this->max_text_length(), $this->max_depth());
} else {
$value2 = json_decode($value, true);
if (json_last_error() == JSON_ERROR_NONE) {
$value = $this->show_obj($value2, 1, $this->max_text_length(), $this->max_depth());
}
}
} else if (@$setting['setting']->view == "JSON_LABEL") {
$max_char_show = -1;
$values = json_decode($value, true);
$format_values = ADFO_fn::parse_csv_options($setting['format_values']);
if (json_last_error() == JSON_ERROR_NONE) {
$new_labs = [];
if (is_array($values)) {
foreach ($values as $leb_key=>$lab) {
if (is_array($format_values)) {
foreach($format_values as $fvv) {
if ($fvv['value'] == $lab || $fvv['label'] == $lab) {
$lab = $fvv['label'];
break;
}
}
}
$new_labs[] = ''.$lab.'';
}
}
$value = implode(" ", $new_labs);
}
} else if (@$setting['setting']->view == "TEXT" || @$setting['setting']->view == "VARCHAR" || @$setting['setting']->view == "") {
$value = $this->html_entities($value);
if (isset($setting['custom_param']) && $setting['custom_param'] > 0) {
$max_char_show = $setting['custom_param'] ;
}
} else if (@$setting['setting']->view == "HTML") {
$max_char_show = 20000;
} else if (@$setting['setting']->view == "LINK" ) {
$max_char_show = 2000;
if (isset($setting['custom_param']) && $setting['custom_param'] != "" ) {
$link_text = PinaCode::execute_shortcode($setting['custom_param']);
} else {
$link_text = $value ;
}
if (filter_var($value, FILTER_VALIDATE_URL) ) {
$value = ''.$this->html_entities($link_text).'';
}
} else if(@$setting['setting']->view == "DETAIL_LINK" && $dbp_id > 0) {
$max_char_show = 2000;
$primary_values = [];
$primary_values['dbp_ids'] = ADFO_fn::ids_url_encode($table_model, $item);
$primary_values['dbp_id'] = $dbp_id;
$primary_values['action'] = 'dbp_get_detail';
$link = esc_url(add_query_arg($primary_values, admin_url('admin-ajax.php')));
$content_value = $value;
$value = '';
$value = apply_filters('adfo_frontend_build_custom_link',$value, $dbp_id, $primary_values, $content_value, $link) ;
/**
* FILTER LEGACY MODE
* @deprecated V1.2.0
*/
$value = apply_filters('dbp_frontend_build_custom_link',$value, $dbp_id, $primary_values, $content_value, $link) ;
} else if (@$setting['setting']->view == "IMAGE" ) {
$max_char_show = 2000;
$value = $this->html_entities($value);
if (filter_var($value, FILTER_VALIDATE_URL) ) {
$value = '.')
';
} else {
$value = '';
}
} else if (@$setting['setting']->view == "POST" ) {
$max_char_show = 2000;
if ($value > 0 ) {
$post = get_post($value);
if ($post != null) {
if (isset($setting['custom_param']) && $setting['custom_param'] != "" ) {
PinaCode::set_var('post', (array)$post) ;
$value = PinaCode::execute_shortcode($setting['custom_param']);
} else {
$value = $post->post_title ;
}
}
} else {
$value = "";
}
} else if (@$setting['setting']->view == "USER" ) {
$max_char_show = 2000;
if ($value > 0) {
$user = get_user_by('id', $value);
}
if (isset($setting['custom_param']) && $setting['custom_param'] != "" ) {
PinaCode::set_var('user', (array)$user) ;
$value = PinaCode::execute_shortcode($setting['custom_param']);
} else {
$value = $user->user_login ;
}
} else if (@$setting['setting']->view == "MEDIA_GALLERY") {
// get_data?
if (absint($value) > 0) {
$img_src = wp_get_attachment_image_url(absint($value));
if ($img_src != "") {
$value = ').')
';
} else {
$value = "";
}
} else {
$value = "";
}
$max_char_show = 20000;
} else if (@$setting['setting']->view == "COLOR_PICKER" ) {
$value = '';
}
else if (@$setting['setting']->view == "CUSTOM") {
$max_char_show = -1;
PinaCode::set_var('key', $key) ;
PinaCode::set_var('count', $count) ;
$array_insert = [];
// ciclo i campi da importare
PinaCode::set_var('data', (array)$item) ;
//print "".$setting['setting']->custom_code." =". PinaCode::execute_shortcode('[%data.ID]')."
";
//$value = "CC : ".$setting['setting']->custom_code;
$value = PinaCode::execute_shortcode($setting['setting']->custom_code);
if (is_object($value) || is_array($value)) {
$value = $this->show_obj($value,1, $this->max_text_length(), $this->max_depth());
}
}
/*
// VEcchio LOOKUP della lista!
else if (@$setting['setting']->view == "LOOKUP") {
$txt = $setting['setting']->lookup_sel_txt;
$ris = ADFO::get_data($setting['setting']->lookup_id, 'items', [['op'=>"=",'column'=> esc_sql($setting['setting']->lookup_sel_val), 'value'=>$value]]);
if (is_countable($ris) && count($ris) == 1) {
$ris =array_shift($ris);
$value = $this->html_entities($ris->$txt);
}
}
*/
} else {
$value = $this->html_entities($value);
}
if (strlen($value) > $max_char_show && $max_char_show > -1) {
if (isset($this->general_settings['htmlentities']) && $this->general_settings['htmlentities'] == true) {
$value = substr($value,0 , floor($max_char_show))." ...";
} else {
$value = substr(strip_tags($value),0 , floor($max_char_show))." ...";
}
}
$value = ADFO_fn::column_formatting_convert($setting['format_values'], $value, $value);
return $value;
}
/**
* Stampo un array o un oggetto in una cella
*/
static public function show_obj($obj, $depth = 1, $max_char_show = 1000, $max_depth = 10, $max_count = 10) {
if (is_object($obj) || is_array($obj)) {
$new_v = [];
$count_row = 0;
foreach ($obj as $k=>$v) {
$count_row++;
if ($count_row > $max_count) {
if (is_object($obj)) {
$obj = (array)$obj;
}
$new_v[] = '['.sprintf(__("Other %s elements",'admin_form'), (count($obj)-$max_count)).'] ...
';
break;
}
if (is_object($v) || is_array($v)) {
if ($depth > $max_depth) {
if (is_object($v)) {
$v = "Object(".count($v).")";
}
if (is_array($v)) {
$v = "Array(".count($v).")";
}
$new_v[] = ''.$k.':'.htmlentities($v).'
';
} else {
if ($depth < $max_depth) {
$new_v[] = ''.$k.'::';
$tt = $depth + 1;
$new_v[] = self::show_obj($v, $tt, $max_char_show, $max_depth, $max_count);
} else {
if (is_object($v)) {
$v = (array)$v;
$new_v[] = '
'.$k.':Object('.count($v).')';
}
if (is_array($v)) {
$new_v[] = ''.$k.':Array('.count($v).')';
}
if (is_array($v)) {
$v = "Array(".count($v).")";
}
}
$new_v[] = '
';
}
} else {
if (strlen($v) > $max_char_show*2) {
$v = substr($v,0 , floor($max_char_show*1.8))." ...";
}
$new_v[] = ''.$k.':'.htmlentities($v).'
';
}
}
$value = implode("",$new_v);
} else {
$value = htmlentities($obj);
}
return $value;
}
/**
* Trovo la lunghezza massima dei testi da visualizzare
*/
private function max_text_length() {
if (is_array($this->general_settings)) {
$max_char_show = (int)$this->general_settings['text_length'];
}
if (!isset($max_char_show) || $max_char_show == 0) {
$max_char_show = 100;
}
if ($max_char_show == -1) {
$max_char_show = 99999999;
}
return $max_char_show;
}
private function html_entities($text) {
if (isset($this->general_settings['htmlentities']) && $this->general_settings['htmlentities'] == true) {
return htmlentities($text);
} else {
return $text;
}
}
/**
* Trovo la profondità massima degli array da visualizzare
*/
private function max_depth() {
if (is_array($this->general_settings)) {
$obj_depth = (int)$this->general_settings['obj_depth'];
}
if (!isset($obj_depth) || $obj_depth == 0 || $obj_depth > 10) {
$obj_depth = 3;
}
return $obj_depth;
}
/**
* Ritorna il tipo di field
* @param Object|String $schema
* @param String $field_type alias|column
*/
private function get_column_name($schema, $field_type="column") {
$field_key = $original_field_name = "";
if (isset ($schema) && is_object($schema)) {
if ($field_type == "alias") {
// l'alias o il nome della colonna
if ( $schema->name == addslashes($schema->name)) {
if (isset ($schema->table) && $schema->table != "" && $schema->orgname == $schema->name ) {
$field_key = '`'.$schema->table.'`.`'.$schema->orgname.'`';
} else {
if (@$schema->orgname != "") {
$field_key = '`'.$schema->name.'`';
} else {
$field_key = $schema->name;
}
}
}
return $field_key;
}
if ($field_type == "column") {
// il nome della colonna
if (@$schema->orgname != "" && $schema->table != "" ) {
$original_field_name = '`'.$schema->table.'`.`'.$schema->orgname.'`';
} else if (@$schema->orgname != "" && $schema->orgtable ) {
$original_field_name = '`'.$schema->orgtable.'`.`'.$schema->orgname.'`';
} else if (@$schema->orgname != "" ) {
$original_field_name = '`'.$schema->orgname.'`';
} else {
$original_field_name = '';
}
return $original_field_name;
}
} else if(is_string($schema) && $schema != "") {
return '`'.$schema."`";
}
return '';
}
private function get_width_class($setting) {
if (isset($setting) && is_object($setting)) {
if ($setting->isset('width') && $setting->width != "") {
return " dbp-td-width-".$setting->width;
}
}
return '';
}
}