/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($SqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$SqlParser->addCriteria(new SqlCriteria('a.com_id', $value, '<>'));
break;
case 'cal_active':
$SqlParser->addCriteria(new SqlCriteria('b.cal_active', $value));
break;
case 'activated':
// only active pages
$SqlParser->addCriteria(new SqlCriteria('a.com_active', 1));
$SqlParser->addCriteria(new SqlCriteria('b.cal_active', 1));
break;
case 'search':
$search = new SqlCriteria('a.com_name', "%{$value}%", 'like');
$search->addCriteria(new SqlCriteria('a.com_text', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$SqlParser->addCriteria($search);
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($SqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$SqlParser->addCriteria(new SqlCriteria('a.cal_id', $value, '<>'));
break;
case 'archive':
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.cal_stop)', $value, '<='));
break;
case 'finished':
$today = mktime(0, 0, 0);
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.cal_stop)', $today, '<'));
break;
case 'archive_start':
// cal_start must by less or equal to end of period
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.cal_stop)', $value, '>='));
break;
case 'archive_stop':
// cal_stop must by greater or equeal to start of period
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.cal_start)', $value, '<='));
break;
case 'activated':
// only active pages
$SqlParser->addCriteria(new SqlCriteria('a.cal_active', 1));
// only pages that are not history
$SqlParser->addCriteria(new SqlCriteria('a.cal_stop', is_string($value) ? $value : 'now()', '>='));
break;
case 'search':
$search = new SqlCriteria('a.cal_name', "%{$value}%", 'like');
$search->addCriteria(new SqlCriteria('a.cal_intro', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('a.cal_text', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$SqlParser->addCriteria($search);
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($SqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$SqlParser->addCriteria(new SqlCriteria('a.att_id', $value, '<>'));
break;
case 'archiveonline':
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.att_online)', $value, '>'));
break;
case 'archiveoffline':
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.att_offline)', $value, '<='));
$SqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.att_offline)', 0, '>'));
break;
case 'activated':
// only active pages
$SqlParser->addCriteria(new SqlCriteria('a.att_active', 1));
// only pages that are online
$SqlParser->addCriteria(new SqlCriteria('a.att_online', 'now()', '<='));
$offline = new SqlCriteria('a.att_offline', 'now()', '>');
$offline->addCriteria(new SqlCriteria('unix_timestamp(a.att_offline)', 0, '='), SqlCriteria::REL_OR);
$SqlParser->addCriteria($offline);
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($SqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$SqlParser->addCriteria(new SqlCriteria('a.lnk_id', $value, '<>'));
break;
case 'previous_id':
$SqlParser->addFrom("left join links as b on b.lnk_tree_id = a.lnk_tree_id and b.lnk_tag = a.lnk_tag");
$SqlParser->addCriteria(new SqlCriteria('b.lnk_id', $value, '='));
$SqlParser->addCriteria(new SqlCriteria('a.lnk_weight', 'b.lnk_weight', '>', true));
break;
case 'next_id':
$SqlParser->addFrom("left join links as b on b.lnk_tree_id = a.lnk_tree_id and b.lnk_tag = a.lnk_tag");
$SqlParser->addCriteria(new SqlCriteria('b.lnk_id', $value, '='));
$SqlParser->addCriteria(new SqlCriteria('a.lnk_weight', 'b.lnk_weight', '<', true));
break;
case 'search':
$search = new SqlCriteria('a.lnk_name', "%{$value}%", 'like');
$search->addCriteria(new SqlCriteria('a.lnk_intro', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('a.lnk_text', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$SqlParser->addCriteria($search);
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($SqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$SqlParser->addCriteria(new SqlCriteria('a.rcd_id', $value, '<>'));
break;
case 'search':
$SqlParser->addFrom('inner join form_record_item as b on a.rcd_id = b.item_rcd_id');
$search = new SqlCriteria('a.rcd_ip', "%{$value}%", 'like');
$search->addCriteria(new SqlCriteria('b.item_value', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$SqlParser->addCriteria($search);
break;
}
}
}
/**
* @see DbConnector::getDefaultValue
*/
protected function parseCriteria($sqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'usr_id':
$sqlParser->addCriteria(new SqlCriteria('a.usr_id', $value));
break;
case 'no_id':
$sqlParser->addCriteria(new SqlCriteria('a.usr_id', $value, '<>'));
break;
case 'grp_id':
$sqlParser->addFrom('left join usergroup as b on b.usr_id = a.usr_id');
$sqlParser->addCriteria(new SqlCriteria('b.grp_id', $value, '='));
break;
case 'no_grp_id':
//$sqlParser->addFrom('left join usergroup as b on b.usr_id = a.usr_id');
//$sqlParser->addCriteria(new SqlCriteria('b.grp_id', $value, '<>'));
$parser = new SqlParser();
$parser->setSelect('select');
$parser->setTable('usergroup', 'b');
$parser->addField(new SqlField('b', 'grp_id', 'grp_id', 'grp_id', SqlParser::SEL_LIST, SqlField::TYPE_INTEGER));
$parser->parseCriteria(array('grp_id' => $value));
$parser->addCriteria(new SqlCriteria('b.usr_id', 'a.usr_id', '=', true));
$subquery = $parser->getSql(SqlParser::SEL_LIST);
$sqlParser->addCriteria(new SqlCriteria(NULL, "({$subquery})", 'not exists', true));
break;
case 'tree_access':
$sqlParser->addFrom('left join usergroup as b on b.usr_id = a.usr_id');
$search = new SqlCriteria('a.usr_role', self::ROLE_ADMIN, '=');
$searchGroup = new SqlCriteria('a.usr_role', self::ROLE_FRONTEND, '<>');
$searchGroup->addCriteria(new SqlCriteria('b.grp_id', $group, '='), SqlCriteria::REL_AND);
$search->addCriteria($searchGroup, SqlCriteria::REL_OR);
$sqlParser->addCriteria($search);
break;
case 'search':
//$search = new SqlCriteria('a.usr_name', $value, 'regexp');
$value = "%{$value}%";
$search = new SqlCriteria('a.usr_name', $value, 'like');
$search->addCriteria(new SqlCriteria('a.usr_firstname', $value, 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('a.usr_username', $value, 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('a.usr_email', $value, 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('a.usr_city', $value, 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('a.usr_country', $value, 'like'), SqlCriteria::REL_OR);
//$search->addCriteria(new SqlCriteria('c.grp_name', $value, 'like'), SqlCriteria::REL_OR);
$sqlParser->addCriteria($search);
/*
$key = "concat(a.usr_name, a.usr_firstname, a.usr_username, a.usr_email, a.usr_city, a.usr_country)";
$sqlParser->addCriteria(new SqlCriteria($key, $value, 'regexp'));
*/
break;
}
}
}
/**
* @see DbConnector::getDefaultValue
*/
protected function parseCriteria($sqlParser, $searchcriteria)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_tag':
$sqlParser->addCriteria(new SqlCriteria('a.tag', $value, '<>'));
break;
case 'no_plugin_view':
$sqlParser->addCriteria(new SqlCriteria('a.plug_view', $value, '<>'));
break;
case 'recursive_tree_id':
$self = $value['self'];
$recursive = $value['recursive'];
$search = new SqlCriteria('a.tree_id', $self);
if ($recursive) {
$recsearch = new SqlCriteria('a.tree_id', $recursive);
$recsearch->addCriteria(new SqlCriteria('a.plug_recursive', 1), SqlCriteria::REL_AND);
$search->addCriteria($recsearch, SqlCriteria::REL_OR);
}
$sqlParser->addCriteria($search);
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($sqlParser, $searchcriteria, $prefix = true)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$sqlParser->addCriteria(new SqlCriteria('a.res_id', $value, '<>'));
break;
case 'start':
$sqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.res_date)', $value, '>'));
break;
case 'stop':
$sqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.res_date)', $value, '<='));
break;
case 'max_count':
//$sqlParser->addField(new SqlField('', 'count(a.res_id)', 'res_count', 'Reservation Count', SqlParser::getTypeSelect(), SqlField::TYPE_INTEGER));
//$sqlParser->addCriteria(new SqlCriteria('a.res_count', $value, '>=')); break;
$sqlParser->setGroupby("group by a.res_usr_id having count(a.res_id) >= {$value}");
//$sqlParser->setGroupby("having count(a.res_id) >= $value");
//$sqlParser->setGroupby("having count(a.res_id) >= $value");
case 'activated':
// only active pages
$today = date('Y-m-d');
//, mktime(0,0,0));
$time = date('H');
$search = new SqlCriteria($sqlParser->getFieldByName('reservation_date')->getField($prefix), $today, '>');
$addsearch = new SqlCriteria($sqlParser->getFieldByName('reservation_date')->getField($prefix), $today, '=');
$addsearch->addCriteria(new SqlCriteria($sqlParser->getFieldByName('reservation_time')->getField($prefix), $time, '>'), SqlCriteria::REL_AND);
$search->addCriteria($addsearch, SqlCriteria::REL_OR);
$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('active')->getField($prefix), 1));
//$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('reservation_date')->getField($prefix), 'now()', '>'));
$sqlParser->addCriteria($search);
break;
case 'search':
$search = new SqlCriteria('b.usr_name', "%{$value}%", 'like');
$search->addCriteria(new SqlCriteria('unix_timestamp(a.res_date)', strtotime($value), '='), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('b.usr_firstname', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$search->addCriteria(new SqlCriteria('b.usr_email', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$sqlParser->addCriteria($search);
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($sqlParser, $searchcriteria, $prefix = true)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$sqlParser->addCriteria(new SqlCriteria('a.usr_id', $value, '<>'));
break;
case 'grp_id':
$sqlParser->addFrom('left join newsletter_usergroup as b on b.usr_id = a.usr_id');
$sqlParser->addCriteria(new SqlCriteria('b.grp_id', $value, '='));
break;
case 'no_grp_id':
throw new Exception("NewsletterUser search for no_grp_id not implemented! add logic for tree_id and tag?");
$sqlParser->addFrom('left join usergroup as b on b.usr_id = a.usr_id');
$sqlParser->addCriteria(new SqlCriteria('b.grp_id', $value, '<>'));
break;
case 'activated':
$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('active')->getField($prefix), 1));
$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('optin')->getField($prefix), ''));
$objUnsubscribe = $sqlParser->getFieldByName('unsubscribe_date');
$subscribe = new SqlCriteria($objUnsubscribe->getField($prefix), 'null', '=');
$subscribe->addCriteria(new SqlCriteria($objUnsubscribe->getField($prefix), 0, '='), SqlCriteria::REL_OR);
$sqlParser->addCriteria($subscribe);
break;
case 'search':
$sqlParser->addCriteria(new SqlCriteria('a.usr_name', "%{$value}%", 'like'));
break;
}
}
}
/**
* Returns protected var $oberserver.
* @param string observer key
* @return array
*/
protected function parseCriteria($sqlParser, $searchcriteria, $prefix = true)
{
if (!$searchcriteria || !is_array($searchcriteria)) {
return;
}
foreach ($searchcriteria as $key => $value) {
switch ($key) {
case 'no_id':
$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('id')->getField($prefix), $value, '<>'));
break;
case 'archiveonline':
$sqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.nl_online)', $value, '>'));
break;
case 'archiveoffline':
$sqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.nl_offline)', $value, '<='));
$sqlParser->addCriteria(new SqlCriteria('unix_timestamp(a.nl_offline)', 0, '>'));
break;
case 'activated':
// only active pages
$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('active')->getField($prefix), 1));
// only pages that are online
$sqlParser->addCriteria(new SqlCriteria($sqlParser->getFieldByName('online')->getField($prefix), 'now()', '<='));
$offlineField = $sqlParser->getFieldByName('offline')->getField($prefix);
$offline = new SqlCriteria($offlineField, 'now()', '>');
$offline->addCriteria(new SqlCriteria($offlineField, 'null', '='), SqlCriteria::REL_OR);
$offline->addCriteria(new SqlCriteria($offlineField, 0, '='), SqlCriteria::REL_OR);
$sqlParser->addCriteria($offline);
break;
case 'search':
$search = new SqlCriteria('a.nl_name', "%{$value}%", 'like');
$search->addCriteria(new SqlCriteria('a.nl_intro', "%{$value}%", 'like'), SqlCriteria::REL_OR);
$sqlParser->addCriteria($search);
break;
}
}
}
