/** * * @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; }