/**
* Print test head
* @param null $title
*/
function test_head($title = null)
{
if ($title) {
echo Strings::nl() . strings::strtoupper($title) . Strings::nl();
}
echo str_repeat('-', 50) . Strings::nl();
}
/**
* Check field unique
* Makes query to db for each check
* @return bool
*/
function check_unique_field($name, $value, $uid = false)
{
if (empty($value)) {
return false;
}
$vf = $this->get_valid_field($name);
$is_text = $vf['type'] == 'text';
if ($is_text) {
$value = strings::strtoupper($value);
}
$value = $this->format_field_sql($name, $value);
$where_ = $uid ? "id <> " . (int) $uid . " AND " : '';
$sql = "SELECT id FROM " . $this->get_table() . " WHERE " . $where_ . ($is_text ? "UCASE({$name})" : $name) . " " . ($is_text ? '=' : '=') . " {$value}";
return 0 == $this->db->sql_numrows($this->db->sql_query($sql));
}
