579 lines
14 KiB
PHP
579 lines
14 KiB
PHP
<?php
|
|
/**
|
|
* @package Joomla.Component.Builder
|
|
*
|
|
* @created 4th September, 2022
|
|
* @author Llewellyn van der Merwe <https://dev.vdm.io>
|
|
* @git Joomla Component Builder <https://git.vdm.dev/joomla/Component-Builder>
|
|
* @copyright Copyright (C) 2015 Vast Development Method. All rights reserved.
|
|
* @license GNU General Public License version 2 or later; see LICENSE.txt
|
|
*/
|
|
|
|
namespace VDM\Joomla\Componentbuilder\Compiler\Model;
|
|
|
|
|
|
use VDM\Joomla\Componentbuilder\Compiler\Config;
|
|
use VDM\Joomla\Componentbuilder\Compiler\Builder\SiteDynamicGet;
|
|
use VDM\Joomla\Componentbuilder\Compiler\Builder\SiteMainGet;
|
|
use VDM\Joomla\Componentbuilder\Compiler\Customcode;
|
|
use VDM\Joomla\Componentbuilder\Compiler\Customcode\Gui;
|
|
use VDM\Joomla\Componentbuilder\Compiler\Placeholder;
|
|
use VDM\Joomla\Componentbuilder\Compiler\Dynamicget\Selection;
|
|
use VDM\Joomla\Utilities\GetHelper;
|
|
use VDM\Joomla\Utilities\StringHelper;
|
|
use VDM\Joomla\Utilities\ArrayHelper;
|
|
|
|
|
|
/**
|
|
* Model Dynamic Get Class
|
|
*
|
|
* @since 3.2.0
|
|
*/
|
|
class Dynamicget
|
|
{
|
|
/**
|
|
* The joint types
|
|
*
|
|
* @var array
|
|
* @since 3.2.0
|
|
*/
|
|
protected array $jointer = [
|
|
1 => 'LEFT',
|
|
2 => 'LEFT OUTER',
|
|
3 => 'INNER',
|
|
4 => 'RIGHT',
|
|
5 => 'RIGHT OUTER'
|
|
];
|
|
|
|
/**
|
|
* The operator types
|
|
*
|
|
* @var array
|
|
* @since 3.2.0
|
|
*/
|
|
protected array $operator = [
|
|
1 => '=',
|
|
2 => '!=',
|
|
3 => '<>',
|
|
4 => '>',
|
|
5 => '<',
|
|
6 => '>=',
|
|
7 => '<=',
|
|
8 => '!<',
|
|
9 => '!>',
|
|
10 => 'IN',
|
|
11 => 'NOT IN'
|
|
];
|
|
|
|
/**
|
|
* The gui mapper array
|
|
*
|
|
* @var array
|
|
* @since 3.2.0
|
|
*/
|
|
protected array $guiMapper = [
|
|
'table' => 'dynamic_get',
|
|
'id' => null,
|
|
'field' => null,
|
|
'type' => 'php'
|
|
];
|
|
|
|
/**
|
|
* The Config Class.
|
|
*
|
|
* @var Config
|
|
* @since 3.2.0
|
|
*/
|
|
protected Config $config;
|
|
|
|
/**
|
|
* The SiteDynamicGet Class.
|
|
*
|
|
* @var SiteDynamicGet
|
|
* @since 3.2.0
|
|
*/
|
|
protected SiteDynamicGet $sitedynamicget;
|
|
|
|
/**
|
|
* The SiteMainGet Class.
|
|
*
|
|
* @var SiteMainGet
|
|
* @since 3.2.0
|
|
*/
|
|
protected SiteMainGet $sitemainget;
|
|
|
|
/**
|
|
* The Customcode Class.
|
|
*
|
|
* @var Customcode
|
|
* @since 3.2.0
|
|
*/
|
|
protected Customcode $customcode;
|
|
|
|
/**
|
|
* The Gui Class.
|
|
*
|
|
* @var Gui
|
|
* @since 3.2.0
|
|
*/
|
|
protected Gui $gui;
|
|
|
|
/**
|
|
* The Placeholder Class.
|
|
*
|
|
* @var Placeholder
|
|
* @since 3.2.0
|
|
*/
|
|
protected Placeholder $placeholder;
|
|
|
|
/**
|
|
* The Selection Class.
|
|
*
|
|
* @var Selection
|
|
* @since 3.2.0
|
|
*/
|
|
protected Selection $selection;
|
|
|
|
/**
|
|
* Constructor.
|
|
*
|
|
* @param Config $config The Config Class.
|
|
* @param SiteDynamicGet $sitedynamicget The SiteDynamicGet Class.
|
|
* @param SiteMainGet $sitemainget The SiteMainGet Class.
|
|
* @param Customcode $customcode The Customcode Class.
|
|
* @param Gui $gui The Gui Class.
|
|
* @param Placeholder $placeholder The Placeholder Class.
|
|
* @param Selection $selection The Selection Class.
|
|
*
|
|
* @since 3.2.0
|
|
*/
|
|
public function __construct(Config $config, SiteDynamicGet $sitedynamicget,
|
|
SiteMainGet $sitemainget, Customcode $customcode, Gui $gui,
|
|
Placeholder $placeholder, Selection $selection)
|
|
{
|
|
$this->config = $config;
|
|
$this->sitedynamicget = $sitedynamicget;
|
|
$this->sitemainget = $sitemainget;
|
|
$this->customcode = $customcode;
|
|
$this->gui = $gui;
|
|
$this->placeholder = $placeholder;
|
|
$this->selection = $selection;
|
|
}
|
|
|
|
/**
|
|
* Set Dynamic Get
|
|
*
|
|
* @param object $item The item data
|
|
* @param string $view_code The view code name
|
|
* @param string $context The context for events
|
|
*
|
|
* @return void
|
|
* @since 3.2.0
|
|
*/
|
|
public function set(object &$item, string $view_code, string $context)
|
|
{
|
|
// reset buckets
|
|
$item->main_get = [];
|
|
$item->custom_get = [];
|
|
|
|
// should joined and other tweaks be added
|
|
$add_tweaks_joints = true;
|
|
|
|
// set source data
|
|
switch ($item->main_source)
|
|
{
|
|
case 1:
|
|
// check if auto sync is set
|
|
if ($item->select_all == 1)
|
|
{
|
|
$item->view_selection = '*';
|
|
}
|
|
// set the view data
|
|
$item->main_get[0]['selection'] = $this->selection->get(
|
|
$item->key, $view_code,
|
|
$item->view_selection,
|
|
$item->view_table_main, 'a', 'view'
|
|
);
|
|
$item->main_get[0]['as'] = 'a';
|
|
$item->main_get[0]['key'] = $item->key;
|
|
$item->main_get[0]['context'] = $context;
|
|
unset($item->view_selection);
|
|
break;
|
|
case 2:
|
|
// check if auto sync is set
|
|
if ($item->select_all == 1)
|
|
{
|
|
$item->db_selection = '*';
|
|
}
|
|
// set the database data
|
|
$item->main_get[0]['selection'] = $this->selection->get(
|
|
$item->key, $view_code,
|
|
$item->db_selection,
|
|
$item->db_table_main, 'a', 'db'
|
|
);
|
|
$item->main_get[0]['as'] = 'a';
|
|
$item->main_get[0]['key'] = $item->key;
|
|
$item->main_get[0]['context'] = $context;
|
|
unset($item->db_selection);
|
|
break;
|
|
case 3:
|
|
// set GUI mapper field
|
|
$this->guiMapper['field'] = 'php_custom_get';
|
|
// get the custom query
|
|
$customQueryString
|
|
= $this->gui->set(
|
|
$this->customcode->update(
|
|
base64_decode((string) $item->php_custom_get)
|
|
),
|
|
$this->guiMapper
|
|
);
|
|
|
|
// get the table name
|
|
$_searchQuery
|
|
= GetHelper::between(
|
|
$customQueryString, '$query->from(', ')'
|
|
);
|
|
|
|
if (StringHelper::check(
|
|
$_searchQuery
|
|
)
|
|
&& strpos((string) $_searchQuery, '#__') !== false)
|
|
{
|
|
$_queryName = GetHelper::between(
|
|
$_searchQuery, '#__', "'"
|
|
);
|
|
|
|
if (!StringHelper::check(
|
|
$_queryName
|
|
))
|
|
{
|
|
$_queryName = GetHelper::between(
|
|
$_searchQuery, '#__', '"'
|
|
);
|
|
}
|
|
}
|
|
|
|
// set to blank if not found
|
|
if (!isset($_queryName)
|
|
|| !StringHelper::check(
|
|
$_queryName
|
|
))
|
|
{
|
|
$_queryName = '';
|
|
}
|
|
|
|
// set custom script
|
|
$item->main_get[0]['selection'] = [
|
|
'select' => $customQueryString,
|
|
'from' => '', 'table' => '', 'type' => '',
|
|
'name' => $_queryName];
|
|
$item->main_get[0]['as'] = 'a';
|
|
$item->main_get[0]['key'] = $item->key;
|
|
$item->main_get[0]['context'] = $context;
|
|
|
|
// do not add
|
|
$add_tweaks_joints = false;
|
|
|
|
break;
|
|
}
|
|
|
|
// only add if main source is not custom
|
|
if ($add_tweaks_joints)
|
|
{
|
|
// set join_view_table details
|
|
$item->join_view_table = json_decode(
|
|
(string) $item->join_view_table, true
|
|
);
|
|
|
|
if (ArrayHelper::check(
|
|
$item->join_view_table
|
|
))
|
|
{
|
|
// start the part of a table bucket
|
|
$_part_of_a = [];
|
|
// build relationship
|
|
$_relationship = array_map(
|
|
function ($op) use (&$_part_of_a) {
|
|
$bucket = [];
|
|
// array(on_field_as, on_field)
|
|
$bucket['on_field'] = array_map(
|
|
'trim',
|
|
explode('.', (string) $op['on_field'])
|
|
);
|
|
// array(join_field_as, join_field)
|
|
$bucket['join_field'] = array_map(
|
|
'trim',
|
|
explode('.', (string) $op['join_field'])
|
|
);
|
|
// triget filed that has table a relationship
|
|
if ($op['row_type'] == 1
|
|
&& ($bucket['on_field'][0] === 'a'
|
|
|| isset($_part_of_a[$bucket['on_field'][0]])
|
|
|| isset($_part_of_a[$bucket['join_field'][0]])))
|
|
{
|
|
$_part_of_a[$op['as']] = $op['as'];
|
|
}
|
|
|
|
return $bucket;
|
|
}, $item->join_view_table
|
|
);
|
|
|
|
// loop joints
|
|
foreach ($item->join_view_table as $nr => &$option)
|
|
{
|
|
if (StringHelper::check(
|
|
$option['selection']
|
|
))
|
|
{
|
|
// convert the type
|
|
$option['type']
|
|
= $this->jointer[$option['type']];
|
|
// convert the operator
|
|
$option['operator']
|
|
= $this->operator[$option['operator']];
|
|
// get the on field values
|
|
$on_field
|
|
= $_relationship[$nr]['on_field'];
|
|
// get the join field values
|
|
$join_field
|
|
= $_relationship[$nr]['join_field'];
|
|
// set selection
|
|
$option['selection']
|
|
= $this->selection->get(
|
|
$item->key,
|
|
$view_code,
|
|
$option['selection'],
|
|
$option['view_table'],
|
|
$option['as'],
|
|
'view',
|
|
$option['row_type']
|
|
);
|
|
$option['key'] = $item->key;
|
|
$option['context'] = $context;
|
|
// load to the getters
|
|
if ($option['row_type'] == 1)
|
|
{
|
|
$item->main_get[] = $option;
|
|
if ($on_field[0] === 'a'
|
|
|| isset($_part_of_a[$join_field[0]])
|
|
|| isset($_part_of_a[$on_field[0]]))
|
|
{
|
|
$this->sitemainget->set(
|
|
$this->config->build_target . '.' . $view_code . '.' .
|
|
$option['as'], $option['as']
|
|
);
|
|
}
|
|
else
|
|
{
|
|
$this->sitedynamicget->set(
|
|
$this->config->build_target . '.' . $view_code . '.' .
|
|
$option['as'] . '.' . $join_field[1],
|
|
$on_field[0]
|
|
);
|
|
}
|
|
}
|
|
elseif ($option['row_type'] == 2)
|
|
{
|
|
$item->custom_get[] = $option;
|
|
if ($on_field[0] != 'a')
|
|
{
|
|
$this->sitedynamicget->set(
|
|
$this->config->build_target . '.' . $view_code . '.' .
|
|
$option['as'] . '.' . $join_field[1],
|
|
$on_field[0]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
unset($item->join_view_table[$nr]);
|
|
}
|
|
}
|
|
unset($item->join_view_table);
|
|
|
|
// set join_db_table details
|
|
$item->join_db_table = json_decode(
|
|
(string) $item->join_db_table, true
|
|
);
|
|
|
|
if (ArrayHelper::check($item->join_db_table))
|
|
{
|
|
// start the part of a table bucket
|
|
$_part_of_a = [];
|
|
// build relationship
|
|
$_relationship = array_map(
|
|
function ($op) use (&$_part_of_a) {
|
|
$bucket = [];
|
|
// array(on_field_as, on_field)
|
|
$bucket['on_field'] = array_map(
|
|
'trim',
|
|
explode('.', (string) $op['on_field'])
|
|
);
|
|
// array(join_field_as, join_field)
|
|
$bucket['join_field'] = array_map(
|
|
'trim',
|
|
explode('.', (string) $op['join_field'])
|
|
);
|
|
// triget filed that has table a relationship
|
|
if ($op['row_type'] == 1
|
|
&& ($bucket['on_field'][0] === 'a'
|
|
|| isset($_part_of_a[$bucket['on_field'][0]])
|
|
|| isset($_part_of_a[$bucket['join_field'][0]])))
|
|
{
|
|
$_part_of_a[$op['as']] = $op['as'];
|
|
}
|
|
|
|
return $bucket;
|
|
}, $item->join_db_table
|
|
);
|
|
|
|
// loop joints
|
|
foreach ($item->join_db_table as $nr => &$option1)
|
|
{
|
|
if (StringHelper::check($option1['selection']))
|
|
{
|
|
// convert the type
|
|
$option1['type'] = $this->jointer[$option1['type']];
|
|
// convert the operator
|
|
$option1['operator'] = $this->operator[$option1['operator']];
|
|
// get the on field values
|
|
$on_field = $_relationship[$nr]['on_field'];
|
|
// get the join field values
|
|
$join_field = $_relationship[$nr]['join_field'];
|
|
// set selection
|
|
$option1['selection'] = $this->selection->get(
|
|
$item->key,
|
|
$view_code,
|
|
$option1['selection'],
|
|
$option1['db_table'],
|
|
$option1['as'],
|
|
'db',
|
|
$option1['row_type']
|
|
);
|
|
$option1['key'] = $item->key;
|
|
$option1['context'] = $context;
|
|
// load to the getters
|
|
if ($option1['row_type'] == 1)
|
|
{
|
|
$item->main_get[] = $option1;
|
|
if ($on_field[0] === 'a'
|
|
|| isset($_part_of_a[$join_field[0]])
|
|
|| isset($_part_of_a[$on_field[0]]))
|
|
{
|
|
$this->sitemainget->set(
|
|
$this->config->build_target . '.' . $view_code . '.' .
|
|
$option1['as'], $option1['as']
|
|
);
|
|
}
|
|
else
|
|
{
|
|
$this->sitedynamicget->set(
|
|
$this->config->build_target . '.' . $view_code . '.' .
|
|
$option1['as'] . '.' . $join_field[1],
|
|
$on_field[0]
|
|
);
|
|
}
|
|
}
|
|
elseif ($option1['row_type'] == 2)
|
|
{
|
|
$item->custom_get[] = $option1;
|
|
if ($on_field[0] != 'a')
|
|
{
|
|
$this->sitedynamicget->set(
|
|
$this->config->build_target . '.' . $view_code . '.' .
|
|
$option1['as'] . '.' . $join_field[1],
|
|
$on_field[0]
|
|
);
|
|
}
|
|
}
|
|
}
|
|
unset($item->join_db_table[$nr]);
|
|
}
|
|
}
|
|
unset($item->join_db_table);
|
|
|
|
// set filter details
|
|
$item->filter = json_decode(
|
|
(string) $item->filter, true
|
|
);
|
|
|
|
if (ArrayHelper::check($item->filter))
|
|
{
|
|
foreach ($item->filter as $nr => &$option2)
|
|
{
|
|
if (isset($option2['operator']))
|
|
{
|
|
$option2['operator'] = $this->operator[$option2['operator']];
|
|
$option2['state_key'] = $this->placeholder->update_(
|
|
$this->customcode->update(
|
|
$option2['state_key']
|
|
)
|
|
);
|
|
$option2['key'] = $item->key;
|
|
}
|
|
else
|
|
{
|
|
unset($item->filter[$nr]);
|
|
}
|
|
}
|
|
}
|
|
|
|
// set where details
|
|
$item->where = json_decode((string) $item->where, true);
|
|
if (ArrayHelper::check($item->where))
|
|
{
|
|
foreach ($item->where as $nr => &$option3)
|
|
{
|
|
if (isset($option3['operator']))
|
|
{
|
|
$option3['operator'] = $this->operator[$option3['operator']];
|
|
}
|
|
else
|
|
{
|
|
unset($item->where[$nr]);
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
unset($item->where);
|
|
}
|
|
|
|
// set order details
|
|
$item->order = json_decode((string) $item->order, true);
|
|
if (!ArrayHelper::check($item->order))
|
|
{
|
|
unset($item->order);
|
|
}
|
|
|
|
// set grouping
|
|
$item->group = json_decode((string) $item->group, true);
|
|
if (!ArrayHelper::check($item->group))
|
|
{
|
|
unset($item->group);
|
|
}
|
|
|
|
// set global details
|
|
$item->global = json_decode(
|
|
(string) $item->global, true
|
|
);
|
|
|
|
if (!ArrayHelper::check($item->global))
|
|
{
|
|
unset($item->global);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
// when we have a custom query script we do not add the dynamic options
|
|
unset($item->join_view_table);
|
|
unset($item->join_db_table);
|
|
unset($item->filter);
|
|
unset($item->where);
|
|
unset($item->order);
|
|
unset($item->group);
|
|
unset($item->global);
|
|
}
|
|
}
|
|
}
|
|
|