public static void save(Long id, String title, String content, String tags) {
Post post;
if (id == null) {
// Create post
User author = User.find("byEmail", Security.connected()).first();
post = new Post(author, title, content);
} else {
// Retrieve post
post = Post.findById(id);
// Edit
post.title = title;
post.content = content;
post.tags.clear();
}
// Set tags list
for (String tag : tags.split("\\s+")) {
if (tag.trim().length() > 0) {
post.tags.add(Tag.findOrCreateByName(tag));
}
}
// Validate
validation.valid(post);
if (validation.hasErrors()) {
render("@form", post);
}
// Save
post.save();
index();
}
@Before
static void setConnectedUser() {
if (Security.isConnected()) {
User user = User.find("byEmail", Security.connected()).first();
renderArgs.put("user", user.fullname);
}
}
public static void saveUser(User user, String verifyPassword) {
// input check
validation.required(user.email);
validation.email(user.email);
validation.min(user.password, 6);
if (validation.hasErrors()) {
Logger.info("用户注册输入有错误");
render("@register");
}
// 此邮件是否被注册过
User userTemp = User.find("byEmailAndDeleted", user.email, false).first();
if (userTemp != null) {
flash.error("此邮件己被注册");
render("@register");
}
user.uuid = UUIDUtil.generate();
user.create();
Logger.info("register" + user.activated);
// 放致session中
session.put("user", user.email);
// 发送激活邮件
Mails.activate(user);
flash.success("己成功注册激活邮件至您邮件中:" + user.email);
Passport.notactivate(user.email);
}
public static void checkUsername(String username) {
Boolean result = true;
User user = User.find("username=?", username).first();
if (user != null) {
result = false;
}
renderJSON(result);
}
@Before
static void setConnectedUser() {
if (Security.isConnected()) {
User user = User.find("byUsername", Security.connected()).first();
if (!user.isAdmin) {
flash.error(Messages.get("UserIsNotAuthorized"));
Application.index();
}
}
}
@Before
static void header() {
Journal journal = Journal.all().first();
renderArgs.put("journal", journal);
renderArgs.put("journalName", journal.name);
renderArgs.put("journalDesc", journal.description);
User currentUser = User.find("byEmail", Security.connected()).<User>first();
renderArgs.put("currentUser", currentUser);
}
@Check("login")
public static void index() {
User curUser = User.find("byName", Secure.Security.connected()).first();
if (curUser.type == UserType.ADMINISTRATOR) {
redirect("/admin/crud");
} else if (curUser.type == UserType.STUDENT) {
Student.index();
} else {
Teacher.index();
}
}
@Test
public void createAndRetrieveUser() {
// Create a new user and save it
new User("*****@*****.**", "secret", "Bob").save();
// Retrieve the user with e-mail address [email protected]
User bob = User.find("byEmail", "*****@*****.**").first();
// Test
assertNotNull(bob);
assertEquals("Bob", bob.fullname);
}
@Before
static void setConnectedUser() {
if (Security.isConnected()) {
User user = User.find("byEmail", Security.connected()).first();
if (user == null) {
user = new User("*****@*****.**", "1234", "Andreas");
user.save();
}
renderArgs.put("user", user.fullname);
}
}
@Before
static void navigation() {
List<Volume> olderVolumes = Volume.find("order by pubYear desc").fetch(5);
List<User> authors =
User.find(
"select a from User a " + "where a.paperCount > 0 " + "order by a.paperCount desc")
.fetch();
List<Numbers> numbers = Number.find("order by pubDate desc").fetch(5);
renderArgs.put("numberList", numbers);
renderArgs.put("volumeList", olderVolumes);
renderArgs.put("authorList", authors);
}
public static void activate(String uuid) {
Logger.info("用户开始进行激活,uuid" + uuid);
User user = User.find("uuid", uuid).first();
Logger.info("start activate:" + user.activated + "id:" + user.id);
if (user != null) {
// 激活成功
user.activated = true;
user.save();
Logger.info("user id:" + user.id);
render("@activatesuccess");
} else {
Application.index();
}
}
public static void isLogin(String email, String password) {
User user = User.find("byEmailAndPasswordAndDeleted", email, password, false).first();
// 用户名or 密码错误
if (user == null) {
render("@login");
} else {
// 未激活
if (user.activated == false) {
session.put("user", user.email);
// 跳至激活页面
render("@notactivate", email);
}
session.put("user", user.email);
Application.index();
}
}
public static void imp(File file) {
String result = "";
String profiles = "";
int imported = 0;
int missed = 0;
if (file != null) {
Config config = Config.find("1=1").first();
FileInputStream fileInputStream = null;
HSSFWorkbook workbook = null;
try {
fileInputStream = new FileInputStream(file);
workbook = new HSSFWorkbook(fileInputStream);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
Profile profile = null;
User user = null;
String value = "";
Material material = null;
SendMessage m = new SendMessage();
for (int x = 0; x < workbook.getNumberOfSheets(); x++) {
HSSFSheet worksheet = workbook.getSheetAt(x);
HSSFRow row = null;
HSSFCell cell = null;
DecimalFormat df = new DecimalFormat("#");
df.setMaximumFractionDigits(0);
for (int i = 1; i < worksheet.getLastRowNum(); i++) {
String unit = "万元";
String business = "0";
try {
row = worksheet.getRow(i);
if (row.getLastCellNum() < 22) {
continue;
}
cell = row.getCell(0);
value = cell.getStringCellValue();
user = User.find("username=?", value).first();
if (user == null) {
user = new User(value, getRandomPwd(), ApplicationRole.getByName("user"));
user.save();
}
profile = Profile.find("user.id=?", user.id).first();
if (profile == null) {
profile = new Profile();
profile.user = user;
}
profile.is_audit = 1;
cell = row.getCell(1);
value = cell.getStringCellValue();
profile.name = value;
cell = row.getCell(2);
value = cell.getStringCellValue();
material = Material.find("name=?", value).first();
if (material == null) {
material = new Material();
material.name = value;
material.save();
}
if (!profile.materials.contains(material)) profile.materials.add(material);
cell = row.getCell(3);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
cell = row.getCell(4);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
cell = row.getCell(5);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.registration_number = value;
cell = row.getCell(6);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
df.setMaximumFractionDigits(2);
value = String.valueOf(df.format(cell.getNumericCellValue()));
} else {
value = cell.getStringCellValue();
}
if (value.contains("美元")) {
value = value.replace("（美元）", "").trim();
unit = "万美元";
}
profile.registration_assets = value;
profile.registration_assets_unit = unit;
df.setMaximumFractionDigits(0);
cell = row.getCell(7);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.registration_address = value;
cell = row.getCell(8);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.bank_name = value;
cell = row.getCell(9);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.account_name = value;
cell = row.getCell(10);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.tfn = value;
cell = row.getCell(11);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.factory_name = value;
cell = row.getCell(12);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.factory_address = value;
cell = row.getCell(13);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(df.format(cell.getNumericCellValue()));
} else {
value = cell.getStringCellValue();
}
profile.first_supply = value.replaceAll("年", "");
cell = row.getCell(14);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.legal_person = value;
cell = row.getCell(15);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.contact_name = value;
cell = row.getCell(16);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.contact_job = value;
cell = row.getCell(17);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(df.format(cell.getNumericCellValue()));
} else {
value = cell.getStringCellValue();
}
profile.contact_phone = value;
cell = row.getCell(18);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.sales_name = value;
cell = row.getCell(19);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
profile.sales_job = value;
cell = row.getCell(20);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(df.format(cell.getNumericCellValue()));
} else {
value = cell.getStringCellValue();
}
profile.sales_phone = value;
cell = row.getCell(21);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
if (value.equals("自营")) {
business = "1";
} else if (value.equals("经销")) {
business = "2";
} else if (value.equals("挂靠")) {
business = "3";
} else {
business = "0";
}
profile.business_model = business;
profile.save();
imported += 1;
if (profile.contact_phone != null) {
String message =
"您的信息已导入,用户名:" + user.username + ",密码:" + user.password + "，请登录比价平台上传资质文件";
if (config.msg_import != null && !"".equals(config.msg_import)) {
message =
config
.msg_import
.replace("{username}", user.username)
.replace("{passowrd}", user.password);
}
m.sendSms(profile.contact_phone, message, "0000001");
if (profile.contact_email != null && !"".equals(profile.contact_phone)) {
m.sendMail(
profile.contact_email,
"[" + Messages.get("application.name") + "]信息导入",
message);
}
}
} catch (Exception e) {
missed += 1;
if (!"".equals(profiles)) {
profiles += "," + profile.name;
} else {
profiles += profile.name;
}
e.printStackTrace();
}
}
}
result = "成功导入" + imported + "条记录，丢失" + missed + "条记录。";
if (!"".equals(profiles)) {
result += "丢失导入的供应商为:" + profiles;
}
}
redirect("/admin/profiles?result=" + URLEncoder.encode(result));
}
public static void save() throws Throwable {
String username = params.get("username");
String name = params.get("name");
String password = params.get("password");
String[] materials = params.getAll("material");
String registration_number = params.get("registration_number");
String registration_assets = params.get("registration_assets");
String registration_assets_unit = params.get("registration_assets_unit");
String registration_address = params.get("registration_address");
String bank_name = params.get("bank_name");
String account_name = params.get("account_name");
String tfn = params.get("tfn");
String legal_person = params.get("legal_person");
String factory_name = params.get("factory_name");
String factory_address = params.get("factory_address");
String first_supply = params.get("first_supply");
String business_model = params.get("business_model");
String contact_name = params.get("contact_name");
String contact_job = params.get("contact_job");
String contact_phone = params.get("contact_phone");
String contact_email = params.get("contact_email");
String sales_name = params.get("sales_name");
String sales_job = params.get("sales_job");
String sales_phone = params.get("sales_phone");
String[] files = params.getAll("files");
User user = null;
Material m = null;
Files file = null;
if (username != null && password != null && !"".equals(username) && !"".equals(password)) {
user = User.find("username=?", username).first();
if (user == null) {
user = new User(username, password, ApplicationRole.getByName("user"));
user.save();
}
Profile profile = Profile.find("user.id=?", user.id).first();
if (profile == null) {
profile = new Profile();
profile.user = user;
}
if (materials != null) {
for (String material_id : materials) {
m = Material.find("id=?", Long.valueOf(material_id.trim())).first();
if (m != null) profile.materials.add(m);
}
}
profile.name = name;
profile.registration_number = registration_number;
profile.registration_assets = registration_assets;
profile.registration_address = registration_address;
profile.registration_assets_unit = registration_assets_unit;
profile.bank_name = bank_name;
profile.account_name = account_name;
profile.tfn = tfn;
profile.legal_person = legal_person;
profile.factory_name = factory_name;
profile.factory_address = factory_address;
profile.first_supply = first_supply;
profile.business_model = business_model;
profile.contact_name = contact_name;
profile.contact_job = contact_job;
profile.contact_phone = contact_phone;
profile.contact_email = contact_email;
profile.sales_name = sales_name;
profile.sales_job = sales_job;
profile.sales_phone = sales_phone;
if (files != null) {
for (String f : files) {
file = Files.find("id=?", Long.valueOf(f)).first();
if (file != null) {
profile.files.add(file);
}
}
}
profile.save();
}
session.put("username", username);
Secure.redirectToOriginalURL();
}
public static void uploadFile(String filename, File file) {
User user = User.find("byEmail", Security.connected()).first();
Upload uploadObj = new Upload();
uploadObj.UploadFile(filename, user, file);
Admin.upload();
}
