// TakeFrom.cpp : implementation file
//
#include "stdafx.h"
#include "LYFZIPManage.h"
#include "TakeFrom.h"
#include "MyMdi.H"
#include "InputPsw.h"
#include "SetPathDlg.h"
#include "mysqldata.h"
#include "InputPsw.h"
#include "ShowHistoryReg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#pragma comment(lib, "Shlwapi.lib")
/////////////////////////////////////////////////////////////////////////////
// TakeFrom IDC_STATIC2

int GetBalance(CString account)
{
	CString count1="";
	CString count2="";
	CString count3="";
	try
	{
		CRecordset myset(&g_db);
		CString	sql="select sum([count]) as cot from recharge where account='"+account+"'"; 
		myset.Open (CRecordset::forwardOnly, sql);
		if(!myset.IsEOF())
			myset.GetFieldValue ("cot", count1);
		myset.Close();
		sql="select sum([msgcount]) as cot from sendreg where account='"+account+"'"; 
		myset.Open (CRecordset::forwardOnly, sql);
		if(!myset.IsEOF())
			myset.GetFieldValue ("cot", count2);
		myset.Close();
		sql="select sum([msgcount2]) as cot from sendreg where account='"+account+"'"; 
		myset.Open (CRecordset::forwardOnly, sql);
		if(!myset.IsEOF())
			myset.GetFieldValue ("cot", count3);
		myset.Close();
		//		return atoi(count1)-min(atoi(count2),atoi(count3));
		return atoi(count1)-atoi(count2);
	}
	catch(...)
	{
		return -1;
	}
}

IMPLEMENT_DYNCREATE(TakeFrom, CFormView)
TakeFrom::TakeFrom()
: CFormView(TakeFrom::IDD)
{
	//{{AFX_DATA_INIT(TakeFrom)
	m_filter = _T("");
	//}}AFX_DATA_INIT
}

TakeFrom::~TakeFrom()
{
}

void TakeFrom::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(TakeFrom)
	DDX_Control(pDX, IDC_COMBO1, m_combo1);
	DDX_Control(pDX, IDC_LIST2, m_List1);
	DDX_Control(pDX, IDC_STATIC1, m_static1);
	DDX_CBString(pDX, IDC_COMBO1, m_filter);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(TakeFrom, CFormView)
	//{{AFX_MSG_MAP(TakeFrom)
	ON_BN_CLICKED(IDC_BUTclose, OnBUTclose)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	ON_WM_TIMER()
	ON_BN_CLICKED(IDC_BUTimportphoto, OnBUTimportphoto)
	ON_BN_CLICKED(IDC_BUTshowphoto, OnBUTshowphoto)
	ON_BN_CLICKED(IDC_BUTmoney, OnBUTmoney)
	ON_BN_CLICKED(IDC_BTNaddsp, OnBTNaddsp)
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST2, OnItemchangedList2)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST2, OnDblclkList2)
	ON_BN_CLICKED(IDC_BUTimportphoto2, OnBUTimportphoto2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// TakeFrom diagnostics

#ifdef _DEBUG
void TakeFrom::AssertValid() const
{
	CFormView::AssertValid();
}

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

/////////////////////////////////////////////////////////////////////////////
// TakeFrom message handlers

void TakeFrom::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();
	// 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;余额(可发短信数),160;已发,100;客人姓名,100;电话,100;QQ,100;地址,100;备注,100;申请日期,100" );
	m_List1.LoadColumnInfo (_T("114"));

	m_combo1.GetWindowRect (rc2);
	ScreenToClient(rc2);
	rc2.bottom +=200;
	m_combo1.MoveWindow (rc2); 

	OnButton1();
}

void TakeFrom::FillGrid(BOOL bStatus)
{
	m_List1.DeleteAllItems2 ();
	int ii=0;
	m_List1.m_arLabels.SetSize( m_List1array.GetSize (), 1 );
	int count=0;
	if(m_filter.IsEmpty ())
	{
		for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
		{
			m_List1.m_arLabels.ElementAt (count++).Copy (m_List1array.ElementAt (ii));
		}
	}
	else
	{
		for(ii=0; ii<m_List1.m_arLabels.GetSize (); ii++)
		{
			if(m_List1array.ElementAt (ii).ElementAt (0).Find (m_filter)!=-1 \
				||m_List1array.ElementAt (ii).ElementAt (1).Find (m_filter)!=-1 \
				|| m_List1array.ElementAt (ii).ElementAt (2).Find (m_filter)!=-1 \
				|| m_List1array.ElementAt (ii).ElementAt (3).Find (m_filter)!=-1\
				|| m_List1array.ElementAt (ii).ElementAt (4).Find (m_filter)!=-1\
				|| m_List1array.ElementAt (ii).ElementAt (5).Find (m_filter)!=-1 \
				|| m_List1array.ElementAt (ii).ElementAt (6).Find (m_filter)!=-1\
				|| m_List1array.ElementAt (ii).ElementAt (7).Find (m_filter)!=-1 )
			{
				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);
	SetDlgItemText(IDC_STATIC2, str);
}

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

void TakeFrom::OnSelchangeCombo1() 
{
	// TODO: Add your control notification handler code here
	SetTimer(1, 100, NULL);	
}

void TakeFrom::OnTimer(UINT nIDEvent) 
{
	// TODO: Add your message handler code here and/or call default
	KillTimer(nIDEvent);
	OnButton1();
}


BOOL TakeFrom::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 VK_RETURN:
				OnButton1();
				return 1;
			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 CFormView::PreTranslateMessage(pMsg);
	}
	catch(...)
	{
	}
}

extern int GetBalance(CString account);
void TakeFrom::OnBUTmoney() 
{
	// 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 account=m_List1.GetItemText (iItem, 0); 
	int balance=GetBalance(account);
	CString str;
	str.Format ("账号%s: 余额:%d", account, balance);
	MessageBox(str);
}

void TakeFrom::OnBTNaddsp() 
{
}

void TakeFrom::OnItemchangedList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here


	*pResult = 0;
}
extern void ConvertToPrice(CString &str);
void TakeFrom::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CRecordset myset(&g_db);
	CString	sql="select count(*) as cot from clientinfo"; 
	myset.Open (CRecordset::forwardOnly, sql);
	myset.GetFieldValue ("cot", sql);
	myset.Close();
	m_List1array.SetSize(atol(sql) , 1 );
	CRstClientInfo rsSt;
	rsSt.Open();
	DWORD ii=0;
	while(!rsSt.IsEOF())
	{
		m_List1array.ElementAt (ii).RemoveAll ();
		m_List1array.ElementAt (ii).Add(rsSt.m_account) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_balance) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_name) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_phone) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_qq) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_addr) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_remark) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_applydate) ;
		ii++;
		rsSt.MoveNext();if(m_List1array.GetSize ()<=ii)break;
	}
	rsSt.Close();m_List1array.SetSize(ii+1 , 1 );


	int sumcount1=0;
	int sumcount2=0;
	for(int i=0; i<m_List1array.GetSize ()-1; i++)
	{
		CString account=m_List1array.ElementAt (i).ElementAt (0);
		CRecordset myset(&g_db);
		CString sql="select sum([msgcount]) as cot from sendreg where account='"+account+"'"; 
		myset.Open (CRecordset::forwardOnly, sql);
		if(!myset.IsEOF())
			myset.GetFieldValue ("cot", sql);
		myset.Close();
		ConvertToPrice(sql);
		if(sql.IsEmpty ())sql="0";
		m_List1array.ElementAt (i).InsertAt (2, sql);
		sumcount1+=atoi(m_List1array.ElementAt (i).ElementAt (1));
		sumcount2+=atoi(sql);
	}
	CString str;
	m_List1array.ElementAt (ii).RemoveAll ();
	m_List1array.ElementAt (ii).Add("") ;
	str.Format("%d", sumcount1);
	m_List1array.ElementAt (ii).Add(str) ;
	str.Format("%d", sumcount2);
	m_List1array.ElementAt (ii).Add(str) ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;
	m_List1array.ElementAt (ii).Add("") ;

	UpdateData();
	m_filter.TrimLeft ();
	m_filter.TrimRight ();
	FillGrid();
}


void TakeFrom::OnBUTshowphoto() //历史冲值
{
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请先选中您要查看冲值记录的客户!", MB_ICONINFORMATION);
		return;
	}
	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0);

	ShowHistoryReg dlg;
	dlg.m_account=account;
	dlg.DoModal ();
}

void TakeFrom::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 account=m_List1.GetItemText (iItem, 0);
	SetPathDlg dlg;
	dlg.m_mode =1;
	dlg.m_account =account;
	if(dlg.DoModal ()==IDOK)	
		OnButton1();
	*pResult = 0;
}

void TakeFrom::OnBUTimportphoto() //添加客户
{
	// TODO: Add your control notification handler code here
	SetPathDlg dlg;
	if(dlg.DoModal ()==IDOK)	
		OnButton1();
}

void TakeFrom::OnBUTimportphoto2() //冲值
{
	// TODO: Add your control notification handler code here
	POSITION pos;
	pos=m_List1.GetFirstSelectedItemPosition();	
	if(pos==NULL)
	{
		AfxMessageBox("请先选中您要冲值的客户!", MB_ICONINFORMATION);
		return;
	}
	{
		InputPsw dlg;
		if(dlg.DoModal()!=IDOK)return;
	}


	int iItem=m_List1.GetNextSelectedItem(pos);	
	CString account=m_List1.GetItemText (iItem, 0);
	CString name=m_List1.GetItemText (iItem, 3);
// 	ReCharge dlg;
// 	dlg.m_account =account;
// 	dlg.m_name =name;
// 	if(dlg.DoModal ()==IDOK)
// 		OnButton1();
}

void TakeFrom::OnButton2() 
{

}