--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/mngdb.cpp	Mon Nov 12 19:35:50 2018 +0900
@@ -0,0 +1,126 @@
+// Filename   : mngdeb.cpp
+// Last Change: 2018-11-09 金 13:35:54.
+//
+
+#include "id.h"
+#include "mngdb.h"
+
+ManageDBFrame::ManageDBFrame( wxWindow* parent, wxWindowID id, const wxString& title, const wxPoint& pos, const wxSize& size, long style ) 
+	: wxFrame( parent, id, title, pos, size, style )
+{
+	this->SetSizeHints( wxDefaultSize, wxDefaultSize );
+	
+	wxBoxSizer* bSizerTop = new wxBoxSizer( wxVERTICAL );
+	
+	wxFlexGridSizer* fgSizer = new wxFlexGridSizer( 0, 2, 0, 0 );
+	fgSizer->SetFlexibleDirection( wxBOTH );
+	fgSizer->SetNonFlexibleGrowMode( wxFLEX_GROWMODE_SPECIFIED );
+	
+	m_staticTextDate = new wxStaticText( this, wxID_ANY, wxT( "Date" ), wxDefaultPosition, wxDefaultSize, 0 );
+	fgSizer->Add( m_staticTextDate, 0, wxALL|wxALIGN_RIGHT|wxALIGN_CENTER_VERTICAL, 5 );
+	
+	m_datePicker = new wxDatePickerCtrl( this, wxID_ANY, wxDefaultDateTime, wxDefaultPosition, wxDefaultSize, wxDP_DROPDOWN|wxDP_SHOWCENTURY );
+	fgSizer->Add( m_datePicker, 0, wxALL|wxALIGN_CENTER_VERTICAL, 5 );
+	
+	m_staticTextHhs = new wxStaticText( this, wxID_ANY, wxT( "HHS" ), wxDefaultPosition, wxDefaultSize, 0 );
+	fgSizer->Add( m_staticTextHhs, 0, wxALL|wxALIGN_CENTER_VERTICAL|wxALIGN_RIGHT, 5 );
+	
+	m_filePickerHhs = new wxFilePickerCtrl( this, wxID_ANY, wxEmptyString, wxT( "Select a file" ), wxT( "*.db" ), wxDefaultPosition, wxDefaultSize, wxFLP_FILE_MUST_EXIST|wxFLP_OPEN|wxFLP_SMALL|wxFLP_USE_TEXTCTRL );
+	fgSizer->Add( m_filePickerHhs, 0, wxALL|wxALIGN_CENTER_VERTICAL|wxEXPAND, 5 );
+	
+	m_staticTextCcn = new wxStaticText( this, wxID_ANY, wxT( "CCN" ), wxDefaultPosition, wxDefaultSize, 0 );
+	fgSizer->Add( m_staticTextCcn, 0, wxALL|wxALIGN_RIGHT|wxALIGN_CENTER_VERTICAL, 5 );
+	
+	m_filePickerCcn = new wxFilePickerCtrl( this, wxID_ANY, wxEmptyString, wxT( "Select a file" ), wxT( "*.db" ), wxDefaultPosition, wxDefaultSize, wxFLP_FILE_MUST_EXIST|wxFLP_OPEN|wxFLP_SMALL|wxFLP_USE_TEXTCTRL );
+	fgSizer->Add( m_filePickerCcn, 0, wxALL|wxALIGN_CENTER_VERTICAL, 5 );
+	
+	bSizerTop->Add( fgSizer, 0, wxALIGN_CENTER_HORIZONTAL, 5 );
+	
+	//---
+	m_staticline = new wxStaticLine( this, wxID_ANY, wxDefaultPosition, wxDefaultSize, wxLI_HORIZONTAL );
+	bSizerTop->Add( m_staticline, 0, wxEXPAND|wxALL, 5 );
+	
+	wxBoxSizer* bSizerBtn = new wxBoxSizer( wxHORIZONTAL );
+	
+	m_buttonBuild = new wxButton( this, ID_MNGBLD, wxT( "Build" ), wxDefaultPosition, wxDefaultSize, 0 );
+	bSizerBtn->Add( m_buttonBuild, 0, wxALL, 5 );
+	
+	m_buttonUpld = new wxButton( this, ID_MNGUPLD, wxT( "Upload" ), wxDefaultPosition, wxDefaultSize, 0 );
+	bSizerBtn->Add( m_buttonUpld, 0, wxALL, 5 );
+	
+	m_buttonExit = new wxButton( this, ID_MNGEXIT, wxT( "Exit" ), wxDefaultPosition, wxDefaultSize, 0 );
+	bSizerBtn->Add( m_buttonExit, 0, wxALL, 5 );
+	
+	bSizerTop->Add( bSizerBtn, 0, wxALIGN_CENTER_HORIZONTAL, 5 );
+	
+	this->SetSizer( bSizerTop );
+	this->Layout();
+	
+	this->Centre( wxBOTH );
+}
+
+ManageDBFrame::~ManageDBFrame()
+{
+}
+
+// Event Table
+BEGIN_EVENT_TABLE( ManageDBFrame, wxFrame )
+	EVT_BUTTON( ID_MNGBLD,  ManageDBFrame::OnBuild )
+	EVT_BUTTON( ID_MNGUPLD, ManageDBFrame::OnUpload )
+	EVT_BUTTON( ID_MNGEXIT, ManageDBFrame::OnExit )
+END_EVENT_TABLE()
+
+// Event Handler
+void ManageDBFrame::OnBuild( wxCommandEvent& WXUNUSED(event) )
+{
+	wxMessageBox( wxT( "build done." ) );
+}
+
+void ManageDBFrame::OnUpload( wxCommandEvent& WXUNUSED(event) )
+{
+	ClearServer();
+	Upload( wxT( "index.db" ) );
+	Upload( wxT( "hhs.db" ) );
+	UpdateDB();
+	wxMessageBox( wxT( "upload done." ) );
+}
+
+void ManageDBFrame::OnExit( wxCommandEvent& WXUNUSED(event) )
+{
+	Close();
+}
+
+
+// Functions
+void ManageDBFrame::Upload( wxString file )
+{
+	wxArrayString args;
+	args.Add( wxT( "client.exe" ) );
+	args.Add( wxT( "-a" ) );
+	args.Add( m_server );
+	args.Add( file );
+
+	wxExecute( wxJoin( args, ' ', '\\' ) );
+}
+
+void ManageDBFrame::ClearServer( void )
+{
+// go-server get /clean -> rm -f upload/*
+	wxArrayString args;
+	args.Add( wxT( "client.exe" ) );
+	args.Add( m_server );
+
+	wxExecute( wxJoin( args, ' ', '\\' ) );
+}
+
+void ManageDBFrame::UpdateDB( void )
+{
+// go-server get /mangedb -> mv upload/xxx db/index.db
+//                           mv upload/yyy db/hhs.db
+	wxArrayString args;
+	args.Add( wxT( "client.exe" ) );
+	args.Add( m_server );
+
+	wxExecute( wxJoin( args, ' ', '\\' ) );
+}
+