package open.dolphin.mbean;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.annotation.PostConstruct;
import javax.annotation.Resource;
import javax.ejb.Singleton;
import javax.ejb.Startup;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.sql.DataSource;
import open.dolphin.infomodel.AddressModel;
import open.dolphin.infomodel.DepartmentModel;
import open.dolphin.infomodel.FacilityModel;
import open.dolphin.infomodel.IInfoModel;
import open.dolphin.infomodel.KarteBean;
import open.dolphin.infomodel.LicenseModel;
import open.dolphin.infomodel.PatientModel;
import open.dolphin.infomodel.RoleModel;
import open.dolphin.infomodel.TelephoneModel;
import open.dolphin.infomodel.UserModel;
/**
* Updator
*
* @author masuda, Masuda Naika
*/
@Startup
@Singleton
public class InitialAccountMaker {
private static final String MEMBER_TYPE = "FACILITY_USER";
private static final String DEFAULT_FACILITY_OID = "1.3.6.1.4.1.9414.70.1";
private static final String DEFAULT_FACILITY_NAME = "クリニック";
private static final String ADMIN_USER = "admin";
private static final String ADMIN_PASS_MD5 = "21232f297a57a5a743894a0e4a801fc3"; // admin
private static final String ADMIN_SIR_NAME = "オープン";
private static final String ADMIN_GIVEN_NAME = "ドルフィン";
// private static final boolean DEVELOPMENT = true;
// private static final String UPDATE_MEMO = "Initial user registered.";
// private static final String NO_UPDATE_MEMO = "User account exists.";
@PersistenceContext
private EntityManager em;
//minagawa^ 2013/08/29
//@Resource(mappedName="java:jboss/datasources/OrcaDS")
//private DataSource ds;
//minagawa$
//s.oh^ 2014/07/08 クラウド0対応
@Resource(mappedName="java:jboss/datasources/PostgresDS")
private DataSource ds;
//s.oh$
@PostConstruct
public void init() {
//minagawa^ WildFly
// start();
//minagawa$
//s.oh^ 2014/07/08 クラウド0対応
createIndexes();
//s.oh$
}
private void start() {
// boolean updated = false;
//
// long userCount = (Long) em.createQuery("select count(*) from UserModel").getSingleResult();
// long facilityCount = (Long) em.createQuery("select count(*) from FacilityModel").getSingleResult();
//
// // ユーザーも施設情報もない場合のみ初期ユーザーと施設情報を登録する
// if (userCount == 0 && facilityCount == 0) {
// addFacilityAdmin();
// if (DEVELOPMENT) {
// addDemoPatient();
// }
// updated = true;
// }
//
// if (updated) {
// Logger.getLogger("open.dolphin").info(UPDATE_MEMO);
// } else {
// Logger.getLogger("open.dolphin").info(NO_UPDATE_MEMO);
// }
//minagawa^ WildFly
// Properties config = new Properties();
//
// // コンフィグファイルをチェックする
// StringBuilder sb = new StringBuilder();
// sb.append(System.getProperty("jboss.home.dir"));
// sb.append(File.separator);
// sb.append("custom.properties");
// File f = new File(sb.toString());
//
// try {
// // 読み込む
// FileInputStream fin = new FileInputStream(f);
// InputStreamReader r = new InputStreamReader(fin, "JISAutoDetect");
// config.load(r);
// r.close();
//
// String conn = config.getProperty("claim.conn");
// String addr = config.getProperty("claim.host");
// if (conn!=null && conn.equals("server") && addr!=null) {
////minagawa^ 2013/08/29
// //Connection con = ds.getConnection();
// Connection con = ORCAConnection.getInstance().getConnection();
////minagawa$
// con.close();
// }
// } catch (Exception e) {
// }
//minagawa$
}
//s.oh^ 2014/07/08 クラウド0対応
private void createIndexes() {
// String[] names = {"pvt_idx3", "d_karte_idx", "d_document_idx", "d_diagnosis_idx", "d_patient_memo_idx",
// "d_letter_module_idx", "d_observation_idx", "d_module_idx", "d_image_idx","d_attachment_idx","d_nlabo_module_idx","d_nlabo_item_idx",
// "patient_idx1", "pvt_idx1", "pub_tree_idx1"};
// String[] sqls = {
// "create index pvt_idx3 on d_patient_visit(patient_id)",
// "create index d_karte_idx on d_karte(patient_id)",
// "create index d_document_idx on d_document(karte_id)",
// "create index d_diagnosis_idx on d_diagnosis(karte_id)",
// "create index d_patient_memo_idx on d_patient_memo(karte_id)",
// "create index d_letter_module_idx on d_letter_module(karte_id)",
// "create index d_observation_idx on d_observation(karte_id)",
// "create index d_module_idx on d_module(doc_id)",
// "create index d_image_idx on d_image(doc_id)",
// "create index d_attachment_idx on d_attachment(doc_id)",
// "create index d_nlabo_module_idx on d_nlabo_module(patientid)",
// "create index d_nlabo_item_idx on d_nlabo_item(labomodule_id)",
// "create index patient_idx1 on d_patient(facilityId, patientid)",
// "create index pvt_idx1 on d_patient_visit(facilityid, pvtdate)",
// "create index pub_tree_idx1 on d_published_tree(publishtype)"
// };
//minagawa^ d_patient に (facikityid,patientid) の unique index 名前=fid_pid_idx を作成する
// unique 制約のない 旧indexは削除する
String[] names = {"pvt_idx3", "d_karte_idx", "d_document_idx", "d_diagnosis_idx", "d_patient_memo_idx",
"d_letter_module_idx", "d_observation_idx", "d_module_idx", "d_image_idx","d_attachment_idx","d_nlabo_module_idx","d_nlabo_item_idx",
"fid_pid_idx", "pvt_idx1", "pub_tree_idx1"};
String[] sqls = {
"create index pvt_idx3 on d_patient_visit(patient_id)",
"create index d_karte_idx on d_karte(patient_id)",
"create index d_document_idx on d_document(karte_id)",
"create index d_diagnosis_idx on d_diagnosis(karte_id)",
"create index d_patient_memo_idx on d_patient_memo(karte_id)",
"create index d_letter_module_idx on d_letter_module(karte_id)",
"create index d_observation_idx on d_observation(karte_id)",
"create index d_module_idx on d_module(doc_id)",
"create index d_image_idx on d_image(doc_id)",
"create index d_attachment_idx on d_attachment(doc_id)",
"create index d_nlabo_module_idx on d_nlabo_module(patientid)",
"create index d_nlabo_item_idx on d_nlabo_item(labomodule_id)",
"create unique index fid_pid_idx on d_patient(facilityid, patientid)",
"create index pvt_idx1 on d_patient_visit(facilityid, pvtdate)",
"create index pub_tree_idx1 on d_published_tree(publishtype)"
};
Connection con;
PreparedStatement pt;
ResultSet rs;
Statement st;
try {
con = ds.getConnection();
pt = con.prepareStatement("select count(*) from pg_indexes where indexname=?");
st = con.createStatement();
for (int i=0; i < names.length; i++) {
pt.setString(1, names[i]);
rs = pt.executeQuery();
if (rs.next()) {
int cnt = rs.getInt(1);
if (cnt==0) {
st.executeUpdate(sqls[i]);
Logger.getLogger("open.dolphin").log(Level.INFO, "{0} dose not exists, created", names[i]);
} else {
Logger.getLogger("open.dolphin").log(Level.INFO, "{0} exists", names[i]);
}
rs.close();
}
}
//minagawa^ unique制約のない 旧indexを削除する
String oldIndex = "patient_idx1";
pt.setString(1, oldIndex);
rs = pt.executeQuery();
if (rs.next()) {
int cnt = rs.getInt(1);
if (cnt==1) {
st.executeUpdate("drop index " + oldIndex);
Logger.getLogger("open.dolphin").log(Level.INFO, "{0} exists, deleted", oldIndex);
} else {
Logger.getLogger("open.dolphin").log(Level.INFO, "{0} dose not exists", oldIndex);
}
rs.close();
}
//minagawa$
st.close();
pt.close();
con.close();
} catch (SQLException ex) {
Logger.getLogger(InitialAccountMaker.class.getName()).log(Level.SEVERE, null, ex);
}
}
//s.oh$
private void addFacilityAdmin() {
Date date = new Date();
// 施設情報
FacilityModel facility = new FacilityModel();
facility.setFacilityId(DEFAULT_FACILITY_OID);
facility.setFacilityName(DEFAULT_FACILITY_NAME);
facility.setMemberType(MEMBER_TYPE);
facility.setZipCode("");
facility.setAddress("");
facility.setTelephone("");
facility.setUrl("");
facility.setRegisteredDate(date);
// 永続化する
em.persist(facility);
// ユーザー情報
UserModel admin = new UserModel();
admin.setFacilityModel(facility);
admin.setUserId(DEFAULT_FACILITY_OID + IInfoModel.COMPOSITE_KEY_MAKER + ADMIN_USER);
admin.setPassword(ADMIN_PASS_MD5);
admin.setSirName(ADMIN_SIR_NAME);
admin.setGivenName(ADMIN_GIVEN_NAME);
admin.setCommonName(admin.getSirName() + " " + admin.getGivenName());
admin.setEmail("");
admin.setMemberType(MEMBER_TYPE);
admin.setRegisteredDate(date);
LicenseModel license = new LicenseModel();
license.setLicense("doctor");
license.setLicenseDesc("医師");
license.setLicenseCodeSys("MML0026");
admin.setLicenseModel(license);
DepartmentModel depart = new DepartmentModel();
depart.setDepartment("01");
depart.setDepartmentDesc("内科");
depart.setDepartmentCodeSys("MML0028");
admin.setDepartmentModel(depart);
// add roles
String[] roles = {IInfoModel.ADMIN_ROLE, IInfoModel.USER_ROLE};
for (String role : roles) {
RoleModel roleModel = new RoleModel();
roleModel.setRole(role);
roleModel.setUserModel(admin);
roleModel.setUserId(admin.getUserId());
admin.addRole(roleModel);
}
// 永続化する
em.persist(admin);
}
private void addDemoPatient() {
PatientModel pm = new PatientModel();
pm.setFacilityId(DEFAULT_FACILITY_OID);
pm.setPatientId("D_000001");
pm.setKanaFamilyName("トクガワ");
pm.setKanaGivenName("ヨシムネ");
pm.setKanaName(pm.getKanaFamilyName() + " " + pm.getKanaGivenName());
pm.setFamilyName("徳川");
pm.setGivenName("吉宗");
pm.setFullName(pm.getFamilyName() + " " + pm.getGivenName());
pm.setGender(IInfoModel.MALE);
pm.setGenderDesc(IInfoModel.MALE_DISP);
pm.setBirthday("1684-11-17");
AddressModel am = new AddressModel();
am.setZipCode("640-8156");
am.setAddress("和歌山市七番丁２３番地");
pm.addAddress(am);
TelephoneModel tm = new TelephoneModel();
tm.setArea("073");
tm.setCity("435");
tm.setNumber("1044");
pm.addTelephone(tm);
em.persist(pm);
KarteBean karte = new KarteBean();
karte.setPatientModel(pm);
karte.setCreated(new Date());
em.persist(karte);
}
}