// Filter.cpp : implementation file
//

#include "stdafx.h"
#include "image.h"
#include "Filter.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CFilter dialog


CFilter::CFilter(CImageDoc *pDoc,CWnd* pParent /*=NULL*/)
	: CDialog(CFilter::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFilter)
	m_bexclusive = FALSE;
	m_site_name = _T("");
	m_include_name = _T("");
	m_exclusive_name = _T("");
	//}}AFX_DATA_INIT
	
	m_pDoc=pDoc;


	

}


void CFilter::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFilter)
	DDX_Control(pDX, IDC_COMBO3, m_exclusive);
	DDX_Control(pDX, IDC_COMBO1, m_site);
	DDX_Control(pDX, IDC_COMBO2, m_include);
	DDX_Check(pDX, IDC_CHECK8, m_bexclusive);
	//DDX_CBString(pDX, IDC_COMBO1, m_site_name);
	DDX_CBString(pDX, IDC_COMBO2, m_include_name);
	DDX_CBString(pDX, IDC_COMBO3, m_exclusive_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFilter, CDialog)
	//{{AFX_MSG_MAP(CFilter)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFilter message handlers

void CFilter::OnOK() 
{
	// TODO: Add extra validation here
	CString temp;
	CImageApp * app=(CImageApp*)AfxGetApp();
	UpdateData();
		
	if(m_site_name.IsEmpty())
	{
		AfxMessageBox("您需要選擇網站");
		return ;
	}
	if(m_bexclusive)
	{
		if(m_exclusive_name.IsEmpty())
		{
			AfxMessageBox("請您輸入排除的url");
			return;
		}
		temp.Format(_T("insert into exclusive values('%s','%s')"),m_site_name,m_exclusive_name);
		TRY
		{
			app->m_db.ExecuteSQL(temp);
		}
		CATCH(CDBException,e)
		{
		}
		END_CATCH
		m_exclusive.AddString(m_exclusive_name);
		m_exclusive_name="";
		UpdateData(FALSE);
	}
	else{
		if(m_include_name.IsEmpty())
		{
			AfxMessageBox("請您輸入要包含的url");
			return;
		}
		temp.Format(_T("insert into include values('%s','%s')"),m_site_name,m_include_name);
		TRY
		{
			app->m_db.ExecuteSQL(temp);
		}
		CATCH(CDBException,e)
		{
		}
		END_CATCH
		m_include.AddString(m_include_name);
		m_include_name="";
		UpdateData(FALSE);

	}

	
	//CDialog::OnOK();
}

void CFilter::OnButton1() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CString temp;
	if(m_site_name.IsEmpty())
	{
		AfxMessageBox("請您選擇網站名稱");
		return;
	}
	CImageApp *app=(CImageApp *)AfxGetApp();
	if(m_bexclusive)
	{
		//現在操作的數據庫為exclusive
		if(m_exclusive_name.IsEmpty())
		{
			AfxMessageBox("請你選擇要排除的url的名稱");
			return;
		}
		temp.Format(_T("delete from exclusive where sitename='%s' and url='%s'"),m_site_name,m_exclusive_name);
		TRY{
			app->m_db.ExecuteSQL(temp);
		}
		CATCH(CDBException,e)
		{}
		END_CATCH
		m_exclusive.DeleteString(m_exclusive.GetCurSel());
		m_exclusive_name="";
		UpdateData(FALSE);
	}
	else{
		//現在操作的數據庫為include
		if(m_include_name.IsEmpty())
		{
			AfxMessageBox("請您選擇要包含的url的名稱");
			return;
		}
		temp.Format(_T("delete from include where sitename='%s' and url='%s'"),m_site_name,m_include_name);
		TRY{
			app->m_db.ExecuteSQL(temp);
		}
		CATCH(CDBException,e)
		{}
		END_CATCH
		m_include.DeleteString(m_include.GetCurSel());
		m_include_name="";
		UpdateData(FALSE);

	}
	
}

BOOL CFilter::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	if(m_pDoc->m_log->IsOpen())
		m_pDoc->m_log->Close();
	m_pDoc->m_log->Open();
	if(!m_pDoc->m_log->IsEOF()||!m_pDoc->m_log->IsBOF())
	{
		m_pDoc->m_log->MoveFirst();
		while(!m_pDoc->m_log->IsEOF())
		{
			CString temp=m_pDoc->m_log->m_sitename;

			m_site.AddString(temp);			
			m_pDoc->m_log->MoveNext();
		}
	}

	m_pDoc->m_log->Close();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CFilter::OnSelchangeCombo1() 
{
	// TODO: Add your control notification handler code here
	CString temp;
	CString sql;

	m_site_name="";
	int nIndex=m_site.GetCurSel();
	if(nIndex!=CB_ERR)
	{
		m_site.GetLBText(nIndex,temp);
		m_site_name=temp;
		sql.Format(_T("select * from include where sitename='%s'"),temp);
		if(m_pDoc->m_include->IsOpen())
			m_pDoc->m_include->Close();
		m_pDoc->m_include->Open(CRecordset::snapshot,sql,CRecordset::readOnly);
		if(!m_pDoc->m_include->IsEOF()||!m_pDoc->m_include->IsBOF())
		{
			m_pDoc->m_include->MoveFirst();
			while(!m_pDoc->m_include->IsEOF())
			{
				m_include.AddString(m_pDoc->m_include->m_url);
				m_pDoc->m_include->MoveNext();
			}
		}
		m_pDoc->m_include->Close();
		//UpdateData();
		
		if(m_pDoc->m_exclusive->IsOpen())
			m_pDoc->m_exclusive->Close();
		sql.Format(_T("select * from exclusive where sitename='%s'"),temp);
		m_pDoc->m_exclusive->Open(CRecordset::snapshot,sql,CRecordset::readOnly);

		if(!m_pDoc->m_exclusive->IsEOF()||!m_pDoc->m_exclusive->IsBOF())
		{
			m_pDoc->m_exclusive->MoveFirst();
			while(!m_pDoc->m_exclusive->IsEOF())
			{
				m_exclusive.AddString(m_pDoc->m_exclusive->m_url);
				m_pDoc->m_exclusive->MoveNext();
			}
		}
		m_pDoc->m_exclusive->Close();
	}
	
}