/**
*
* @param DataType $type
* @return DataTypeValidator
*/
public static function getByDataType(DataType $type)
{
$res = array();
$dataTypeID = DataBase::Current()->EscapeString($type->getID());
$rows = DataBase::Current()->ReadRows("SELECT * FROM {'dbprefix'}datatype_validator WHERE dataType = '" . $dataTypeID . "'");
foreach ($rows as $row) {
$validator = new DataTypeValidator();
$validator->id = $row->id;
$validator->dataTypeID = $row->dataType;
$validator->dataType = $type;
$validator->select = $row->select;
$validator->message = $row->message;
$res[] = $validator;
}
return $res;
}
/**
*
* @param DataType $dataType
* @return array
*/
public static function getByDataType(DataType $dataType)
{
$res = array();
$dataTypeID = DataBase::Current()->EscapeString($dataType->getID());
$fields = DataBase::Current()->ReadRows("SELECT * FROM {'dbprefix'}datafields WHERE datatype = '" . $dataTypeID . "'");
foreach ($fields as $field) {
$fieldObj = new DataField();
$fieldObj->id = $field->id;
$fieldObj->dataTypeID = $field->dataType;
$fieldObj->dataType = $dataType;
$fieldObj->displayName = $field->displayName;
$fieldObj->dataName = $field->dataName;
$fieldObj->validatorID = $field->validator;
$res[] = $fieldObj;
}
return $res;
}
/**
*
* @param DataType $type
* @param string $apikey
* @return DataTypeShare
*/
public static function GetByDataTypeAndApiKey(DataType $type, $apikey)
{
$res = null;
$id = DataBase::Current()->EscapeString($type->getID());
$apikey = DataBase::Current()->EscapeString($apikey);
$row = DataBase::Current()->ReadRow("SELECT \n * \n FROM \n {'dbprefix'}datatype_sharing\n WHERE\n datatype = " . $id . "\n AND apikey = '" . $apikey . "'");
if ($row) {
$res = new DataTypeShare();
$res->dataType = $type;
$res->apiKey = $row->apikey;
$res->name = $row->name;
}
return $res;
}
