2 SO objects in 1 ui class

[Alex_Slepyshev]

I have 2 so class in 1 ui class, but on create in bo object 2 so object get error.
$this->bo = new callcenter_bo();
$this->bo_callsets = new callcenter_callsets_bo();
$this->bo_callset = new callcenter_callset_bo();

callcenter_bo call callcenter_so
callcenter_callsets_so call callcenter_callsets_so

class callcenter_so extends Api\Storage
{
function __construct()
{
parent::__construct(‘callcenter’,‘egw_callcenter’, ‘egw_callcenter_extra’, ‘’,
‘extra_name’, ‘extra_value’, ‘extra_id’ );

	$this->columns_to_search = array('name','short_description','long_description','location');
}

---

class callcenter_callsets_so extends Api\Storage
{
function __construct()
{
parent::__construct(‘callcenter’,‘egw_callcenter_callsets’);

	$this->columns_to_search = array('name','short_description','long_description','location');
}

---

error
nothing known about column ‘cc_parent’!

Collumn cc_parent not in table.
$this->bo = new callcenter_bo();
$this->bo_callsets = new callcenter_callsets_bo(); — have table description from $this->bo
1 Table - 1 UI object. 2 Table and 1 UI - mission impossible.

[RalfBecker]

Hi Alex,

if you paste code, enclose it in ``` (not displayed):

function test()
{
	something();
}

Api\Storage class works by default only with 2 tables, one for data of the main object and one for custom-fields. If you need more tables, automatic quoting fails with the error-message you gave, eg:

$where = [
    'main_something' => 'some-value',
    'other_something' => 'other-value',
];

Columns with ‘main_’ prefix are in the table Api\Storage is instanciated for, the ones with ‘other_’ prefix are from an other table.
What you can do is:

$where = [
    'main_something' => 'some-value',
    $this->db->expression('other_table', ['other_something' => 'other-value']),
];

Of cause you can also reimplement eg. search method, to understand and automatic to the right thing for ‘other_table’, eg.:

class my_class extends Api\Storage
{
    const OTHER_TABLE = 'other_table';
    const OTHER_PREFIX = 'other_';
    const OTHER_PREFIX_LEN = 6;
    function search($criteria, $only_keys=True ,$order_by='', $extra_cols='', $wildcard='', $empty=False, $op='AND', $start=false, $filter=null)
   {
       if (!is_array($filter)) $filter = $filter ? (array)$filter : [];
       foreach($filter as $col => $value)
       {
          if (!is_int($col) && substr($col, 0, self::OTHER_PREFIX_LEN) === self::OTHER_PREFIX)
          {
              $filter[] = $this->db->expression(self::OTHER_TABLE, [$col => $value]);
              unset($filter[$col];
          }
       }
       return parent::search($criteria, $only_keys ,$order_by, $extra_cols, $wildcard, $empty, $op, $start, $filter);
   }
}

Most of our more complex apps, do something similar.

Ralf

[Alex_Slepyshev]

Thanks? Ralf ! I dig into core and find this. But ! My task - create module with link from any tables with API link. You system create links with app1->link1 - app2->link2. I find - system not check for create link. May i create magic app - hard described in template as option=“link_app” and other?