#include "employee_record.h"
#include <QtSql>
EmployeeRecord getEmployeeRecord(qint64 id)
{
QSqlQuery q("SELECT * FROM employee WHERE id = " + QString::number(id));
if (q.next())
{
EmployeeRecord rec =
{
q.value(0).toInt(),
q.value(1).toString(),
q.value(2).toString(),
q.value(3).toDouble(),
q.value(4).toDate(),
q.value(5).toInt(),
q.value(6).toInt()
};
return rec;
}
return EmployeeRecord();
}
I2luY2x1ZGUgImVtcGxveWVlX3JlY29yZC5oIgoKI2luY2x1ZGUgPFF0U3FsPgoKCkVtcGxveWVlUmVjb3JkIGdldEVtcGxveWVlUmVjb3JkKHFpbnQ2NCBpZCkKewoJUVNxbFF1ZXJ5IHEoIlNFTEVDVCAqIEZST00gZW1wbG95ZWUgV0hFUkUgaWQgPSAiICsgUVN0cmluZzo6bnVtYmVyKGlkKSk7CgoJaWYgKHEubmV4dCgpKQoJewoJCUVtcGxveWVlUmVjb3JkIHJlYyA9CgkJewoJCQlxLnZhbHVlKDApLnRvSW50KCksCgkJCXEudmFsdWUoMSkudG9TdHJpbmcoKSwKCQkJcS52YWx1ZSgyKS50b1N0cmluZygpLAoJCQlxLnZhbHVlKDMpLnRvRG91YmxlKCksCgkJCXEudmFsdWUoNCkudG9EYXRlKCksCgkJCXEudmFsdWUoNSkudG9JbnQoKSwKCQkJcS52YWx1ZSg2KS50b0ludCgpCgkJfTsKCQlyZXR1cm4gcmVjOwoJfQoJcmV0dXJuIEVtcGxveWVlUmVjb3JkKCk7Cn0=