// Filename   : mngdeb.cpp
// Last Change: 2018-11-21 水 08:36:02.
//

#include <wx/datetime.h>
#include <wx/textfile.h>
#include "id.h"
#include "mngdb.h"
#include "index.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->SetBackgroundColour( wxColour( 140, 240, 140 ) );
	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, wxSize( 180, -1 ), 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, wxSize( 180, -1 ), 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, wxSize( 180, -1 ), 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_buttonIdx = new wxButton( this, ID_MNGIDX, wxT( "Index" ), wxDefaultPosition, wxDefaultSize, 0 );
	bSizerBtn->Add( m_buttonIdx, 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 );
	m_buttonUpld->Enable( false );
}

ManageDBFrame::~ManageDBFrame()
{
}

// Event Table
BEGIN_EVENT_TABLE( ManageDBFrame, wxFrame )
	EVT_BUTTON( ID_MNGBLD,  ManageDBFrame::OnBuild )
	EVT_BUTTON( ID_MNGUPLD, ManageDBFrame::OnUpload )
	EVT_BUTTON( ID_MNGIDX,  ManageDBFrame::OnIndex )
	EVT_BUTTON( ID_MNGEXIT, ManageDBFrame::OnExit )
END_EVENT_TABLE()

// Event Handler
void ManageDBFrame::OnBuild( wxCommandEvent& WXUNUSED(event) )
{
	wxString hhs = m_filePickerHhs->GetPath();
	wxString ccn = m_filePickerCcn->GetPath();
	wxDateTime dt = m_datePicker->GetValue();
	wxString ymd = dt.Format( wxT( "%Y%m%d" ) );

	// index.db.tmp, hhs.csv.tmp(utf-8)
	wxArrayString args;
	args.Add( wxT( "extsql.exe" ) );
	args.Add( hhs );
	args.Add( ccn );
	args.Add( ymd );
	wxExecute( wxJoin( args, ' ', '\\' ), wxEXEC_SYNC|wxEXEC_HIDE_CONSOLE );

	// hhs.csv(cp932)
    wxCSConv cust( wxT( "cp932" ) );
	wxTextFile input( wxT( "hhs.csv.tmp" ) );
	wxTextFile output( wxT( "hhs.csv" ) );
    input.Open();
    output.Create();
    for ( wxString buf = input.GetFirstLine(); !input.Eof(); buf = input.GetNextLine() )
		output.AddLine( buf );
    input.Close();
	output.Write( wxTextFileType_Dos, cust );
    output.Close();

	// hhs.db(encryptoed)
	wxString key = wxT( "12345678900123456789abcdefabcdef" );
	args.Clear();
	args.Add( wxT( "crypto.exe" ) );
	args.Add( wxT( "-e" ) );
	args.Add( wxT( "hhs.csv" ) );
	args.Add( wxT( "-k" ) );
	args.Add( key );
	args.Add( wxT( "-o" ) );
	args.Add( wxT( "hhs.db" ) );
	wxExecute( wxJoin( args, ' ', '\\' ), wxEXEC_SYNC|wxEXEC_HIDE_CONSOLE );

	wxMessageBox( wxT( "build done." ) );
	m_buttonUpld->Enable( true );
}

void ManageDBFrame::OnUpload( wxCommandEvent& WXUNUSED(event) )
{
	Upload( wxT( "index.db" ) );
	Upload( wxT( "hhs.db" ) );
	wxMessageBox( wxT( "upload done." ) );
}

void ManageDBFrame::OnIndex( wxCommandEvent& WXUNUSED(event) )
{
	IndexFrame *idxframe = new IndexFrame( this, wxID_ANY, wxT( "View Index" ), wxDefaultPosition, wxSize( 400, 480 ), wxDEFAULT_FRAME_STYLE );
	idxframe->Show();
}

void ManageDBFrame::OnExit( wxCommandEvent& WXUNUSED(event) )
{
	Close();
}


// Functions
void ManageDBFrame::Upload( wxString file )
{
	wxArrayString args;
	args.Add( wxT( "client.exe" ) );
	args.Add( wxT( "-m" ) );
	args.Add( m_server );
	args.Add( file );

	wxExecute( wxJoin( args, ' ', '\\' ), wxEXEC_SYNC|wxEXEC_HIDE_CONSOLE );
}

void ManageDBFrame::SetDBdir( wxString dir )
{
	wxDateTime dt;
	dt.ParseFormat( wxT( "20160401" ), wxT( "%Y%m%d") );
	m_datePicker->SetValue( dt );
	m_filePickerHhs->SetPath( dir + wxFILE_SEP_PATH + wxT( "hhs.db") );
	m_filePickerCcn->SetPath( dir + wxFILE_SEP_PATH + wxT( "ccn.db") );
}