function criteria_my_preferred($element) { $field = $this->put_alias($element['real_field']); $criteria = phpgwapi_sql_criteria::or_(phpgwapi_sql_criteria::equal($field, phpgwapi_sql::string($element['value'])), phpgwapi_sql_criteria::is_null($field)); $this->_add_criteria($criteria); return $criteria; }
function criteria_comm_find_descr($element) { $field = $this->put_alias($element['real_field']); foreach ($element['value'] as $value) { $data[] = phpgwapi_sql_criteria::equal($field, phpgwapi_sql::string($value)); } $criteria = phpgwapi_sql_criteria::append_or($data); $this->_add_criteria($criteria); }
/** * Generate a criteria stirng suitable for SQL queries, update and delete. * * @param array $tokens array Multidimensional array created with calls to sql_criteria class methods * @return string Return a criteria string based on tokens */ public static function criteria($tokens) { $operator = array_pop($tokens); if ($operator == 'append_or' || $operator == 'append_and') { return self::$operator($tokens); } $operand_left = array_shift($tokens); // Recursivity if array $operand_left = is_array($operand_left) ? self::criteria($operand_left) : $operand_left; if (count($tokens) > 0) { $operand_right = array_shift($tokens); // Recursivity if array too $operand_right = is_array($operand_right) ? self::criteria($operand_right) : $operand_right; } else { $operand_right = phpgwapi_sql::null(); } return self::$operator($operand_left, $operand_right); }
/** * Allow to change the current cat_id by the new * * @param integer $cid The contact_id what you want to edit * @param array $categories The new categories * @param $action * @return string SQL update string */ function edit_category($cid, $categories = array(), $action = PHPGW_SQL_RETURN_SQL) { $contact = createObject('phpgwapi.contact_central'); $principal['cat_id'] = $this->get_categories($categories); return $contact->update($principal, phpgwapi_sql_criteria::_equal('contact_id', phpgwapi_sql::integer($cid)), $action); }
public static function str_time2int($time) { return (int) phpgwapi_sql::str_date2int($time); }
/** * Genarete a string with field = value to use in update * * @param string $fields * @param string $values * @return string with field=value list. */ function set_update_data($element) { if ($element['value'] || $element['value'] == 0) { $value = $this->cast($element['value'], $element['field']); } else { phpgwapi_sql::null(); } if ($this->values) { $this->values .= ', '; } $this->values .= "{$element['real_field']} = {$value}"; }
function criteria_sel_cat_id($element) { $field = $this->put_alias($element['real_field']); if (is_array($element['value'])) { foreach ($element['value'] as $value) { $data[] = phpgwapi_sql_criteria::or_(phpgwapi_sql_criteria::equal($field, sql::string($value)), phpgwapi_sql_criteria::has($field, ',' . $value . ',')); } $criteria = phpgwapi_sql_criteria::append_or($data); $this->_add_criteria($criteria); } else { $this->_add_criteria(phpgwapi_sql_criteria::equal($field, phpgwapi_sql::string($element['value']))); } }
function full_name() { $this->add_field('per_full_name', phpgwapi_sql::concat_null(array($this->real_field('per_prefix'), phpgwapi_sql::string(' '), $this->real_field('per_first_name'), phpgwapi_sql::string(' '), $this->real_field('per_middle_name'), phpgwapi_sql::string(' '), $this->real_field('per_last_name'), phpgwapi_sql::string(' '), $this->real_field('per_suffix')))); }