Elep

<?php
/*
 * Your installation or use of this SugarCRM file is subject to the applicable
 * terms available at
 * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
 * If you do not agree to all of the applicable terms or do not have the
 * authority to bind the entity as an authorized representative, then do not
 * install or use this SugarCRM file.
 *
 * Copyright (C) SugarCRM Inc. All rights reserved.
 */
/*********************************************************************************
 * Description:
 ********************************************************************************/
// DataSet_Layout is used to store customer information.
class DataSet_Layout extends SugarBean
{
    // Stored fields
    public $id;
    public $deleted;
    public $date_entered;
    public $date_modified;
    public $modified_user_id;
    public $created_by;
    public $created_by_name;
    public $modified_by_name;

public $layout_type;
    public $parent_id;
    public $parent_value;
    public $list_order_x;
    public $list_order_z;
    public $row_header_id;
    public $hide_column = '0';

public $table_name = 'dataset_layouts';
    public $module_dir = 'DataSets';
    public $object_name = 'DataSet_Layout';
    public $rel_attribute_table = 'dataset_attributes';
    public $rel_datasets_table = 'data_sets';
    public $disable_custom_fields = true;
    public $new_schema = true;

public $column_fields = ['id'
        , 'date_entered'
        , 'date_modified'
        , 'modified_user_id'
        , 'created_by'
        , 'layout_type'
        , 'parent_id'
        , 'parent_value'
        , 'list_order_x'
        , 'list_order_z'
        , 'row_header_id'
        , 'hide_column',
    ];

// This is used to retrieve related fields from form posts.
    public $additional_column_fields = [];

// This is the list of fields that are in the lists.
    public $list_fields = [];
    // This is the list of fields that are required
    public $required_fields = ['parent_id' => 1];

//Controller Array for list_order stuff
    public $controller_def = [
        'list_x' => 'Y'
        , 'list_y' => 'N'
        , 'parent_var' => 'parent_id'
        , 'start_var' => 'list_order_x'
        , 'start_axis' => 'x',
    ];

public function __construct()
    {
        parent::__construct();

$this->disable_row_level_security = true;
    }

public function get_summary_text()
    {
        return "$this->layout_type";
    }

public function save_relationship_changes($is_update, $exclude = [])
    {
    }

public function mark_relationships_deleted($id)
    {
    }

public function fill_in_additional_list_fields()
    {
        $this->fill_in_additional_detail_fields();
    }

public function fill_in_additional_detail_fields()
    {
    }

public function get_list_view_data($filter_fields = [])
    {
    }

/**
     * builds a generic search based on the query string using or
     * do not include any $this-> because this is called on without having the class instantiated
     */
    public function build_generic_where_clause($the_query_string)
    {
        $where_clauses = [];
        $the_query_string = addslashes($the_query_string);
        array_push($where_clauses, "name like '$the_query_string%'");

$the_where = '';
        foreach ($where_clauses as $clause) {
            if ($the_where != '') {
                $the_where .= ' or ';
            }
            $the_where .= $clause;
        }

return $the_where;
    }

public function construct($parent_id, $layout_type, $list_order_x, $display_type, $parent_value)
    {

//used when enabling custom layout on dataset
        $this->parent_id = $parent_id;
        $this->layout_type = $layout_type;
        //it could be false if coming from the add_columns_to_layout function in custom query
        if ($list_order_x !== false) {
            $this->list_order_x = $list_order_x;
        }
        $this->display_type = $display_type;
        $this->parent_value = $parent_value;
        $this->save();
        //end function construct
    }

public function get_attribute_id($attribute_type, $layout_id = '')
    {
        if ($layout_id == '') {
            $layout_id = $this->id;
        }

$sanitizedTableName = $this->db->getValidDBName($this->rel_attribute_table, false, 'table');

$query = "SELECT {$sanitizedTableName}.id FROM {$sanitizedTableName} WHERE {$sanitizedTableName}.parent_id=? AND {$sanitizedTableName}.attribute_type=? AND {$sanitizedTableName}.deleted=0";

return $this->db->getConnection()->fetchOne($query, [$layout_id, $attribute_type]);
        //end function get_attribute_id
    }

public function clear_all_layout($data_set_id)
    {
        //Select all layout records
        $qb = $this->db->getConnection()->createQueryBuilder();
        $qb->select('id')
            ->from($this->table_name)
            ->where($qb->expr()->eq('parent_id', $qb->createPositionalParameter($data_set_id)));

$stmt = $qb->execute();

// Print out the calculation column info
        while ($beanId = $stmt->fetchOne()) {
            //Mark all attributes deleted
            BeanFactory::deleteBean('DataSet_Attribute', $beanId);

//Remove the layout records
            $this->mark_deleted($beanId);

//end while
        }
        //end if rows exist
        //}

//end function mark_all_layout
    }

public function get_layout_array($data_set_id, $hide_columns = false)
    {
        $sanitizedTableName = $this->db->getValidDBName($this->table_name);

//if this is the final report then hide_columns should be set to true
        if ($hide_columns == true) {
            $hide_columns_where = 'AND (' . $sanitizedTableName . ".hide_column='0' OR " . $sanitizedTableName . ".hide_column='off' OR " . $sanitizedTableName . '.hide_column IS NULL OR ' . $sanitizedTableName . ".hide_column = '')";
        } else {
            $hide_columns_where = '';
        }

$layout_array = [];

//gets custom_layout column_array
        //Select all layout records for this data set
        $query = "SELECT {$sanitizedTableName}.* from {$sanitizedTableName} where {$sanitizedTableName}.parent_id=? AND {$sanitizedTableName}.deleted='0' {$hide_columns_where} ORDER BY list_order_x";

$rows = $this->db->getConnection()->fetchAllAssociative($query, [$data_set_id]);

foreach ($rows as $row) {
            //Get head attribute information
            $head_attribute_id = $this->get_attribute_id('Head', $row['id']);
            $head_att_object = BeanFactory::newBean('DataSet_Attribute');
            if (!empty($head_attribute_id) && $head_attribute_id != '') {
                $head_att_object->retrieve($head_attribute_id);
                ////////////////Head Specific Information
                $layout_array[$row['parent_value']]['head']['font_size'] = $head_att_object->font_size;
                $layout_array[$row['parent_value']]['head']['font_color'] = $head_att_object->font_color;
                $layout_array[$row['parent_value']]['head']['bg_color'] = $head_att_object->bg_color;
                if ($head_att_object->wrap == '0') {
                    $wrap = 'nowrap';
                } else {
                    $wrap = 'wrap';
                }

$layout_array[$row['parent_value']]['head']['wrap'] = $wrap;
                $layout_array[$row['parent_value']]['head']['style'] = $head_att_object->style;

//end if header attribute exists
            }

//Get body attribute information
            $body_attribute_id = $this->get_attribute_id('Body', $row['id']);
            $body_att_object = BeanFactory::newBean('DataSet_Attribute');
            if (!empty($body_attribute_id) && $body_attribute_id != '') {
                $body_att_object->retrieve($body_attribute_id);

////////////////Body Specific Information
                $layout_array[$row['parent_value']]['body']['font_size'] = $body_att_object->font_size;
                $layout_array[$row['parent_value']]['body']['font_color'] = $body_att_object->font_color;
                $layout_array[$row['parent_value']]['body']['bg_color'] = $body_att_object->bg_color;
                if ($body_att_object->wrap == '0') {
                    $wrap = 'nowrap';
                } else {
                    $wrap = 'wrap';
                }

$layout_array[$row['parent_value']]['body']['wrap'] = $wrap;
                $layout_array[$row['parent_value']]['body']['style'] = $body_att_object->style;
                $layout_array[$row['parent_value']]['body']['format_type'] = $body_att_object->format_type;

//end if body attribute exists
            }

//////////////////Column Display Name

//check for scalar name
            if (!empty($head_att_object->display_type) && $head_att_object->display_type == 'Scalar') {
                $scalar_object = new ScalarFormat();
                $display_name = $scalar_object->format_scalar($head_att_object->format_type, '', $row['parent_value']);
            } else {
                //normal display name type

if (!empty($head_att_object->display_name)) {
                    $display_name = $head_att_object->display_name;
                } else {
                    $display_name = $row['parent_value'];
                    if ($display_name == '') {
                        $display_name = '&nbsp;';
                    }
                    //end if to use standard display or custom
                }

//end if scalar vs. normal
            }

//////////////////Column Width
            if (!empty($body_att_object->cell_size)) {
                $column_width = $body_att_object->cell_size . '' . $body_att_object->size_type;
            } else {
                $column_width = '';
            }

///Build Array////////////////////////
            //Display Name
            $layout_array[$row['parent_value']]['display_name'] = $display_name;
            //Default Name
            $layout_array[$row['parent_value']]['default_name'] = $row['parent_value'];
            //Column Width
            $layout_array[$row['parent_value']]['column_width'] = $column_width;

//end while
        }
        //end if rows exist
        //}

return $layout_array;

//end function get_layout_array
    }

public function get_att_object($type)
    {
        $attribute_id = $this->get_attribute_id($type);
        $attribute_object = BeanFactory::getBean('DataSet_Attribute', $attribute_id);
        return $attribute_object;
        //end function get_att_object
    }

//end class datasets_Layout
}