/**
* Create the right array paremeter for select query
*
* @param array $prm The initial parameter
* @param array $tmpTables Array used with parseLinked
*/
public function selectQuery(array $prm, &$tmpTables)
{
config::initTab($prm, array('where' => '', 'whereOp' => 'AND', 'order' => '', 'autoJoin' => $this->cfg->autoJoin));
if (is_array($prm['where'])) {
foreach ($prm['where'] as $k => $v) {
if (!is_numeric($k) && strpos($k, '.') === false) {
$newK = $this->rawName . '.' . $k;
if (!array_key_exists($newK, $prm['where'])) {
$prm['where'][$newK] = $v;
unset($prm['where'][$k]);
}
}
}
} else {
if (!empty($prm['where']) && !is_array($prm['where']) && !is_object($prm['where']) && (strpos($prm['where'], '=') === false && strpos($prm['where'], '<') === false && strpos($prm['where'], '>') === false && stripos($prm['where'], 'LIKE') === false && stripos($prm['where'], 'IN') === false)) {
$prm['where'] = $this->rawName . '.' . $this->cfg->ident . '=' . $prm['where'];
}
}
$prm = array_merge(array('fields' => $this->getDb()->quoteIdentifier($this->rawName) . '.*', 'table' => $this->rawName), $prm);
if (is_array($prm['fields'])) {
array_walk($prm['fields'], create_function('&$v', '$v = strpos($v, ".") === false? "' . $this->rawName . '.".$v: $v;'));
$prm['fields'] = implode(',', $prm['fields']);
}
$join = isset($prm['join']) ? $prm['join'] : array();
$prm['join'] = array();
$tmpTables = array();
if (!empty($this->linkedTables) && $prm['autoJoin']) {
foreach ($this->linkedTables as $f => $p) {
$alias = $f;
$prm['join'][] = array('table' => $p['table'], 'alias' => $alias, 'dir' => 'left outer', 'on' => $this->rawName . '.' . $f . '=' . $alias . '.' . $p['ident']);
$fields = explode(',', $p['fields']);
array_unshift($fields, $p['ident']);
$fields = array_flip(array_flip(array_filter($fields)));
$fieldsT = $fields;
array_walk($fieldsT, create_function('&$v', '$v = "' . $alias . '_".$v;'));
$tmpTables[$f] = $fieldsT;
$tmpTables[$f]['sep'] = $p['sep'];
$tmpTables[$f]['ident'] = $alias . '_' . $p['ident'];
$tmp = array();
$linkedTable = db::get('table', $p['table'], array('db' => $this->getDb()));
foreach ($fields as $t) {
if ($linkedInfo = $linkedTable->getLinkedTableName($t)) {
$aliasT = $alias . '_' . $linkedInfo['table'];
$prm['join'][] = array('table' => $linkedInfo['table'], 'alias' => $aliasT, 'dir' => 'left outer', 'on' => $alias . '.' . $linkedInfo['field'] . '=' . $aliasT . '.' . $linkedInfo['ident']);
$ttmp = array();
foreach (explode(',', $linkedInfo['fields']) as $tt) {
$ttmp[] = $aliasT . '.' . $tt;
$ttmp[] = '"' . $linkedInfo['sep'] . '"';
}
array_pop($ttmp);
$tmp[] = 'CONCAT(' . implode(',', $ttmp) . ') AS ' . $alias . '_' . $t;
} else {
$tmp[] = $alias . '.' . $t . ' AS ' . $alias . '_' . $t;
}
}
$fields = $tmp;
$prm['fields'] .= ',' . implode(',', $fields);
if ($p['i18nFields']) {
$fieldsI18n = array();
$i18nTableName = $p['table'] . db::getCfg('i18n');
$i18nTable = db::get('table', $i18nTableName, array('db' => $this->getDb()));
$primary = $i18nTable->getPrimary();
$i18nAlias = $alias . db::getCfg('i18n');
$prm['join'][] = array('table' => $i18nTableName, 'alias' => $i18nAlias, 'dir' => 'left outer', 'on' => $alias . '.' . $p['ident'] . '=' . $i18nAlias . '.' . $primary[0] . ' AND ' . $i18nAlias . '.' . $primary[1] . '="' . request::get('lang') . '"');
$fields = explode(',', $p['i18nFields']);
$fields = array_flip(array_flip(array_filter($fields)));
$fieldsI18n = $fields;
array_walk($fieldsI18n, create_function('&$v', '$v = "' . $alias . '_' . db::getCfg('i18n') . '".$v;'));
array_walk($fields, create_function('&$v', '$v = "' . $i18nAlias . '.".$v." AS ' . $alias . '_' . db::getCfg('i18n') . '".$v;'));
$tmpTables[$f] = array_merge($tmpTables[$f], $fieldsI18n);
if (!empty($fields)) {
$prm['fields'] .= ',' . implode(',', $fields);
}
}
}
}
if (!empty($this->relatedTables) && $prm['autoJoin'] || $this->i18nTable) {
foreach ($this->relatedTables as $f => $p) {
$prm['join'][] = array('table' => $f, 'dir' => 'left outer', 'on' => $this->rawName . '.' . $p['fk1']['link']['ident'] . '=' . $f . '.' . $p['fk1']['name']);
// related Table fields
$fields = array_keys($p['fields']);
$fieldsTableLink = $fields;
array_walk($fieldsTableLink, create_function('&$v', '$v = "' . $f . '_".$v;'));
array_walk($fields, create_function('&$v', '$v = "' . $f . '.".$v." AS ' . $f . '_".$v;'));
if (!empty($fields)) {
$prm['fields'] .= ',' . implode(',', $fields);
}
$prm['join'][] = array('table' => $p['table'], 'dir' => 'left outer', 'on' => $f . '.' . $p['fk2']['name'] . '=' . $p['table'] . '.' . $p['fk2']['link']['ident']);
// related Table fields
$fields = explode(',', $p['fk2']['link']['fields']);
array_unshift($fields, $p['fk2']['link']['ident']);
$fields = array_flip(array_flip(array_filter($fields)));
$fieldsT = $fields;
array_walk($fieldsT, create_function('&$v', '$v = "' . $p['table'] . '_".$v;'));
array_walk($fields, create_function('&$v', '$v = "' . $p['table'] . '.".$v." AS ' . $p['table'] . '_".$v;'));
if (!empty($fields)) {
$prm['fields'] .= ',' . implode(',', $fields);
}
// i18n related Table fields
if ($p['fk2']['link']['i18nFields']) {
$fieldsI18n = array();
$i18nTableName = $p['table'] . db::getCfg('i18n');
$i18nTable = db::get('table', $i18nTableName, array('db' => $this->getDb()));
$primary = $i18nTable->getPrimary();
$prm['join'][] = array('table' => $i18nTableName, 'dir' => 'left outer', 'on' => $f . '.' . $p['fk2']['name'] . '=' . $i18nTableName . '.' . $primary[0] . ' AND ' . $i18nTableName . '.' . $primary[1] . '="' . request::get('lang') . '"');
$fields = explode(',', $p['fk2']['link']['i18nFields']);
$fields = array_flip(array_flip(array_filter($fields)));
$fieldsI18n = $fields;
array_walk($fieldsI18n, create_function('&$v', '$v = "' . $i18nTableName . '_".$v;'));
array_walk($fields, create_function('&$v', '$v = "' . $i18nTableName . '.".$v." AS ' . $p['table'] . '_' . db::getCfg('i18n') . '".$v;'));
if (!empty($fields)) {
$prm['fields'] .= ',' . implode(',', $fields);
}
}
$tmpTables['relatedTable'][$f] = array('ident' => $this->getIdent(), 'tableName' => $p['table'], 'tableLink' => $fieldsTableLink, 'table' => array_merge($fieldsT, array('field' => $p['fk2']['name'], 'sep' => $p['fk2']['link']['sep'], 'ident' => $p['table'] . '_' . $p['fk2']['link']['ident'])));
}
if ($this->i18nTable) {
$i18nName = $this->i18nTable->getName();
$primary = $this->i18nTable->getPrimary();
$prm['join'][] = array('table' => $i18nName, 'dir' => 'left outer', 'on' => $this->rawName . '.' . $this->getIdent() . '=' . $i18nName . '.' . $primary[0]);
// related Table fields
$fields = array($primary[1]);
foreach ($this->getI18nFields() as $f) {
$fields[] = $f['name'];
}
$fieldsTableLink = $fields;
array_walk($fieldsTableLink, create_function('&$v', '$v = "' . $i18nName . '_".$v;'));
array_walk($fields, create_function('&$v', '$v = "' . $i18nName . '.".$v." AS ' . $i18nName . '_".$v;'));
if (!empty($fields)) {
$prm['fields'] .= ',' . implode(',', $fields);
}
// related Table fields
$tmpTables['relatedTable'][$i18nName] = array('ident' => $this->getIdent(), 'tableName' => $i18nName, 'tableLink' => $fieldsTableLink, 'table' => array('field' => $i18nName . '_' . $primary[0], 'sep' => null, 'ident' => $i18nName . '_' . $primary[1]));
}
if (array_key_exists('nb', $prm)) {
$tmpTables['nb'] = $prm['nb'];
$tmpTables['st'] = array_key_exists('start', $prm) ? $prm['start'] : 0;
unset($prm['nb']);
}
}
$prm['join'] = array_merge($prm['join'], $join);
return $prm;
}