// MsgReg.cpp : implementation file
//
#include "stdafx.h"
#include "ylgl.h"
#include "MsgReg.h"
#include "MyMdi.H"
#include "ModifyDinDan.h"
#include "NeroDlg.h"
#include "ClientRequirement.h"
#include "./helper/ffsco.h"
#include "ClientRequirement.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#pragma comment(lib, "Shlwapi.lib")
/////////////////////////////////////////////////////////////////////////////
// MsgReg

IMPLEMENT_DYNCREATE(MsgReg, MyFormView)
MsgReg::MsgReg()
	: MyFormView(MsgReg::IDD)
{
	//{{AFX_DATA_INIT(MsgReg)
	m_radio1 = 0;
	//}}AFX_DATA_INIT
	g_nYearposTemp=g_nYearpos;
}

MsgReg::~MsgReg()
{
	g_nYearpos=g_nYearposTemp;
}

void MsgReg::DoDataExchange(CDataExchange* pDX)
{
	MyFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(MsgReg)
	DDX_Control(pDX, IDC_LIST6, m_List3);
	DDX_Control(pDX, IDC_LIST4, m_List2);
	DDX_Control(pDX, IDC_LIST2, m_List1);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDX_Radio(pDX, IDC_RADIO1, m_radio1);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(MsgReg, MyFormView)
	//{{AFX_MSG_MAP(MsgReg)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST4, OnDblclkList4)
	ON_BN_CLICKED(IDC_BUTshowphoto, OnDelMsg)
	ON_BN_CLICKED(IDC_RADIO9, OnRadio9)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST6, OnDblclkList6)
	ON_BN_CLICKED(IDC_BUTburncd, OnBUTburncd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// MsgReg diagnostics

#ifdef _DEBUG
void MsgReg::AssertValid() const
{
	MyFormView::AssertValid();
}

void MsgReg::Dump(CDumpContext& dc) const
{
	MyFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// MsgReg message handlers

void MsgReg::OnInitialUpdate() 
{
	MyFormView::OnInitialUpdate();

	if(IsHasRights2new(49))
	{
		GetDlgItem(IDC_BUTshowphoto)->EnableWindow(1);
	}
	else
	{
		GetDlgItem(IDC_BUTshowphoto)->EnableWindow(0);GetDlgItem(IDC_BUTburncd)->EnableWindow(0);
	}


//	if(atoi(g_cominfoarray.ElementAt(0).ElementAt(49)))
	//	GetDlgItem(IDC_RADIO9)->ShowWindow (SW_SHOW);
	// TODO: Add your specialized code here and/or call the base class
	CMyMdi Mdi;
	Mdi.SetSubView((CWnd*)GetParent(), (CWnd*)this);
	
	// Here we create the outbar control using the splitter as its parent
	// and setting its id to the first pane.
	CRect rc2;
	GetWindowRect(rc2);
	::MoveWindow(m_hWnd,g_rc.left,g_rc.top,g_rc.Width(),g_rc.Height(),TRUE);

 	EnumChildWindows(m_hWnd,(WNDENUMPROC)EnumChildProc,0);

	m_static1.SetFont (&g_titlefont);

	m_List1.SetHeadings("号码,100;内容,300;时间,100;条数,100;报告,100;发送人,100" );
    m_List1.LoadColumnInfo (128);

	m_List2.SetHeadings("套系价格,100;预约日期,100;客人选择,100;类别,100;手机,100;内容,100;时间,100;发送人,100" );
 	m_List2.LoadColumnInfo (129);

 	m_List3.SetHeadings("客人,150;电话,150;内容,250;时间,150" );
  	m_List3.LoadColumnInfo (160);

	g_sendhead.bsql=0;
	g_sendhead.code[0]=65;
	g_sendhead.code[1]=66;
	g_sendhead.code[2]=119;
	g_sendhead.tabcount=3;
	g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
	DataToArray(&m_List1array, &m_List2array, &m_List3array);
    FillGrid();

	m_List2.ShowWindow (SW_HIDE);
	m_List3.ShowWindow (SW_HIDE);
}

void MsgReg::FillGrid()
{
	UpdateData();

	if(m_radio1==0)
	{
	m_List1.DeleteAllItems2 ();
	int ii=0;
	m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
	int count=0;
	for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
	{
		m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
	}
	m_List1.m_arLabels.SetSize(count, 1);
	ii=count;
	m_List1.m_LabelCount=ii;
	m_List1.SetItemCountEx (ii);
	CString str;
	str.Format ("记录数:%d", ii);
	if(m_radio1==0)SetDlgItemText(IDC_STATIC2, str);
	}
	else if(m_radio1==1)
	{
	m_List2.DeleteAllItems2 ();
	int ii=0;
	m_List2.m_arLabels.SetSize( m_List2array.GetSize (), 1 );
	int count=0;
	for(ii=0; ii<m_List2.m_arLabels.GetSize (); ii++)
	{
		m_List2.m_arLabels.ElementAt (count++).Copy (m_List2array.ElementAt (ii));
	}
	m_List2.m_arLabels.SetSize(count, 1);
	ii=count;
	m_List2.m_LabelCount=ii;
	m_List2.SetItemCountEx (ii);
	CString str;
	str.Format ("记录数:%d", ii);
	if(m_radio1==1)SetDlgItemText(IDC_STATIC2, str);
	}
	else
	{
	m_List3.DeleteAllItems2 ();
	int ii=0;
	m_List3.m_arLabels.SetSize( m_List3array.GetSize (), 1 );
	int count=0;
	for(ii=0; ii<m_List3.m_arLabels.GetSize (); ii++)
	{
		m_List3.m_arLabels.ElementAt (count++).Copy (m_List3array.ElementAt (ii));
	}
	m_List3.m_arLabels.SetSize(count, 1);
	ii=count;
	m_List3.m_LabelCount=ii;
	m_List3.SetItemCountEx (ii);
	CString str;
	str.Format ("记录数:%d", ii);
	if(m_radio1==2)SetDlgItemText(IDC_STATIC2, str);
	}
}

void MsgReg::OnBUTclose() 
{
	// TODO: Add your control notification handler code here
	GetParent()->SendMessage(WM_CLOSE);
}

BOOL MsgReg::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	try
	{
	if(pMsg->message==WM_KEYDOWN)
	{
		switch (pMsg->wParam)
		{
		case 0x43: // copy
			if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
			{
				GetFocus()->SendMessage(WM_COPY);
				return TRUE;
			}
			break;
		case 0x56: //Ctrl + V:
			if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
			{
				GetFocus()->SendMessage(WM_PASTE);
				return TRUE;
			}
			break;
		case 0x58: // cut
			if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
			{
				GetFocus()->SendMessage(WM_CUT);
				return TRUE;
			}
			break;
		case 0x5A: //undo
		case 0x59: //redo
			if ( ( GetKeyState( VK_CONTROL ) & 0x80 ) )
			{
				GetFocus()->SendMessage(WM_UNDO);
				return TRUE;
			}
			break;
		}
	}
	return MyFormView::PreTranslateMessage(pMsg);
	}
	catch(...)
	{
	}

	return TRUE;

}

void MsgReg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	g_sendhead.bsql=0;
	g_sendhead.code[0]=65;	
	g_sendhead.code[1]=119;
	g_sendhead.tabcount=2;
	g_pMainWnd->ProcessChatMessageRequest2(1);if(g_bSendOK==0)return;
	DataToArray(&m_List1array, &m_List3array);
	FillGrid();
}

void MsgReg::OnRadio1() 
{
	// TODO: Add your control notification handler code here
	m_List1.ShowWindow (SW_SHOW);
	m_List2.ShowWindow (SW_HIDE);
	m_List3.ShowWindow (SW_HIDE);
	FillGrid();
}

void MsgReg::OnRadio2() 
{
	// TODO: Add your control notification handler code here
	m_List2.ShowWindow (SW_SHOW);
	m_List1.ShowWindow (SW_HIDE);
	m_List3.ShowWindow (SW_HIDE);
	FillGrid();
}

void MsgReg::OnRadio9() 
{
	// TODO: Add your control notification handler code here
	m_List3.ShowWindow (SW_SHOW);
	m_List1.ShowWindow (SW_HIDE);
	m_List2.ShowWindow (SW_HIDE);
	FillGrid();	
}

void MsgReg::OnDblclkList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
    POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;
	}
	int iItem = m_List1.GetNextSelectedItem(pos);
	CString time = m_List1.GetItemText(iItem, 2);
	
#if JEFF_TEST_ON
	// 查询依然不完整,会有两条或以上查询条件重复的记录。若要精确,加上短信内容。
	CString filter = _T("");
	filter.Format(_T("[timestamp]='%s' and phones='%s'"),m_List1.GetItemText(iItem, 2),m_List1.GetItemText(iItem, 0));
	//filter.Format(_T("[timestamp]='%s' and phones='%s' and [content]='%s'"), 
	//	m_List1.GetItemText(iItem, 2), m_List1.GetItemText(iItem, 0), m_List1.GetItemText(iItem, 1));
	// 语句太长了，返回不了。
#else
	CString filter="[timestamp]='"+time+"'";
#endif
	g_sendhead.bsql=0;
	g_sendhead.code[0]=78;
	g_sendhead.tabcount=1;
	g_pMainWnd->ProcessChatMessageRequest2(filter);
	if(g_bSendOK==0)return;
	DataToArray(&g_List1array);
	if(g_List1array.GetSize ())
	{
		CClientRequirement dlg;
		dlg.m_bSave =0;
		dlg.m_nMode =1;
		dlg.m_bz2 =g_List1array.ElementAt (0).ElementAt (0);
		dlg.DoModal ();
	}
	*pResult = 0;
}

void MsgReg::OnDblclkList4(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
    POSITION pos;
	pos=m_List2.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;
	}
	int iItem=m_List2.GetNextSelectedItem(pos);	
	CString time=m_List2.GetItemText (iItem, 6);
		
	CString filter="[date]='"+time+"'";
	g_sendhead.bsql=0;
	g_sendhead.code[0]=79;
	g_sendhead.tabcount=1;
	g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
	DataToArray(&g_List1array);
	if(g_List1array.GetSize ())
	{
		CClientRequirement dlg;
		dlg.m_bSave =0;
		dlg.m_nMode =1;
		dlg.m_bz2 =g_List1array.ElementAt (0).ElementAt (0);
		dlg.DoModal ();
	}
	*pResult = 0;
}

void MsgReg::OnDelMsg()	// 删除短信按钮; 需要重新处理,只根据时间来删除是严重错误的！
{
	// TODO: Add your control notification handler code here
	if (IsHasRights2new(49) == 0)return;

	UpdateData();
	if (m_radio1 == 1)
	{
		POSITION pos;
		pos = m_List2.GetFirstSelectedItemPosition();
		if (pos == NULL)
		{
			AfxMessageBox("请先选中您要删除的短信!");
			return;
		}
		if (AfxMessageBox("提醒, 删除后将无法恢复, 是否继续?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
		int iItem = m_List2.GetNextSelectedItem(pos);
		CString time = m_List2.GetItemText(iItem, 6);
		CString sql = "delete from [sendreg2] where [date]='" + time + "'";	// Jeff.删除短信记录条件过于简单,因为time的时间相同的记录有很多！
		g_sendhead.bsql = 1;
		g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
		g_sendhead.bsql = 0;
		g_sendhead.code[0] = 66;
		g_sendhead.tabcount = 1;
		g_pMainWnd->ProcessChatMessageRequest2(1); if (g_bSendOK == 0)return;
		DataToArray(&m_List2array);
		FillGrid();
	}
	else if (m_radio1 == 0)
	{
		POSITION pos;
		pos = m_List1.GetFirstSelectedItemPosition();
		if (pos == NULL)
		{
			AfxMessageBox("请先选中您要删除的短信!");
			return;
		}
		if (AfxMessageBox("提醒, 删除后将无法恢复, 是否继续?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
		//	int iItem=m_List1.GetNextSelectedItem(pos);	
		int iItem;
		CString sql;
		int count = 0;
		while (pos)
		{
			iItem = m_List1.GetNextSelectedItem(pos);
			CString time = m_List1.GetItemText(iItem, 2);
			CString sql2 = "delete from sendreg where [timestamp]='" + time + "'***";	// Jeff.删除短信记录条件过于简单,因为time的时间相同的记录有很多！
			sql += sql2; count++;
			if (count > 19)break;
		}
		sql.TrimRight("***");
		g_sendhead.bsql = 1;
		g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
		OnButton1();
	}
	else
	{
		POSITION pos;
		pos = m_List3.GetFirstSelectedItemPosition();
		if (pos == NULL)
		{
			AfxMessageBox("请先选中您要删除的短信!");
			return;
		}
		if (AfxMessageBox("提醒, 删除后将无法恢复, 是否继续?", MB_YESNO | MB_ICONINFORMATION) != IDYES)return;
		int iItem = m_List3.GetNextSelectedItem(pos);
		CString time = m_List3.GetItemText(iItem, 3);
		CString content = m_List3.GetItemText(iItem, 2);
		CString sql = "delete from sendregreceive where [timestamp]='" + time + "' and [content]='" + content + "'";
		g_sendhead.bsql = 1;
		g_pMainWnd->ProcessChatMessageRequest2(sql); if (g_bSendOK == 0)return;
		OnButton1();
	}
}

void MsgReg::OnDblclkList6(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
    POSITION pos;
	pos=m_List3.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		return;
	}
	int iItem=m_List3.GetNextSelectedItem(pos);	
	CString time=m_List3.GetItemText (iItem, 3);
	CString content=m_List3.GetItemText (iItem, 2);
	CString filter="[timestamp]='"+time+"' and [content]='"+content+"'";
	g_sendhead.bsql=0;
	g_sendhead.code[0]=119;
	g_sendhead.tabcount=1;
	g_pMainWnd->ProcessChatMessageRequest2(filter);if(g_bSendOK==0)return;
	DataToArray(&g_List1array);
	if(g_List1array.GetSize ())
	{
		CClientRequirement dlg;
		dlg.m_bSave =0;
		dlg.m_nMode =1;
		dlg.m_bz2 =g_List1array.ElementAt (0).ElementAt (2);
		dlg.DoModal ();
	}
	*pResult = 0;
}

void MsgReg::OnBUTburncd() 
{
	// TODO: Add your control notification handler code here
	CString str;
	str=CTime::GetCurrentTime ().Format ("%Y-%m-%d");
	ListToXLS(&m_List1, "c:\\"+str+"短信记录.xls", 1);
}