#include "Reader.h"
#include "ways.h"

int Reader::select_Lost(Chaxun & se)//丟失書本查詢
{
	MYSQL_RES * point;
	int bb[3]={14,18,12};
	string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間' from items,loans where items.ISBN=loans.ISBN and (loans.number-FLOOR(loans.number/10)*10)=4";
	point=se.Demand(str.c_str());
	way->Show_data(point,bb);
	return 0;
}
int Reader::select_Compens(Chaxun & se)//賠款書本查詢 
{
	MYSQL_RES * point;
	int bb[3]={14,18,12};
	string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間' from items,loans where items.ISBN=loans.ISBN and (loans.number-FLOOR(loans.number/10)*10)=5";
	point=se.Demand(str.c_str());
	way->Show_data(point,bb);
	return 0;
}
int Reader::select_Library(Chaxun & se)//圖書館在冊書查詢
{
	MYSQL_RES * point;
	int bb[7]={14,14,5,14,12,4,4};
	string aa="select book_name as '書名',ISBN,writer as '作者',publish as '出版社',publish_time as '出版日期', price as '價格',maxbook-number as '可借量' from items";
	point=se.Demand(aa.c_str());
	way->Show_data(point,bb);
	return 0;
}
int Reader::select_History(Chaxun & se)//借閱歷史查詢
{
	MYSQL_RES * point;
	int bb[4]={14,18,12,4};
	string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間',(loans.number-FLOOR(loans.number/10)*10) as '狀態' from items,loans where items.ISBN=loans.ISBN";
	point=se.Demand(str.c_str());
	cout<<"狀態值說明:  1:已借未還  2:已還  3:已掛失  4:已丟失  5.已賠款"<<endl;
	way->Show_data(point,bb);
	return 0;
}
int Reader::select_Book_now(Chaxun & se)//現借書及情況查詢
{
	MYSQL_RES * point;
	int bb[3]={14,18,12};
	string str="select items.book_name as '書名',concat(concat(loans.ISBN,'-'),char(ascii(FLOOR(loans.number/10)))) as '書號',lend_time as '借書時間' from items,loans where items.ISBN=loans.ISBN and (loans.number-FLOOR(loans.number/10)*10)=1";
	point=se.Demand(str.c_str());
	way->Show_data(point,bb);
	return 0;
}
int Reader::pwd_Change(Chaxun & se)//更改密碼操作 
{
	string pwd1,pwd2;
	cout<<"**************************************"<<endl;
	cout<<"*          請輸入你的新密碼          *"<<endl;
	cin>>pwd1;
	cout<<"*          請再次確認密碼            *"<<endl;
	cin>>pwd2;
	if(pwd1==pwd2)
	{
		pwd1="update reader set read_pwd = '" + pwd1 +"' where read_id= '"+Reader_id+"';";
		int i=se.Run(pwd1.c_str());
		way->Show_judge(i);	
	}
	else
		pwd_Change(se);
	return 0;
}
int Reader::reserva_Book(Chaxun & se)//預定圖書操作
{
	cout<<"**************************************"<<endl;
	cout<<"*        請輸入你要預約的圖書名      *"<<endl;
	string name;
	cin>>name;
	name="insert into reserve values ( '"+Reader_id+"','"+name+"','"+way->Now_time()+"','0','0');";
	way->Show_judge(se.Run(name.c_str()));
	return 0;
}
int Reader::cancel_reserva_Book(Chaxun & se)//取消預訂圖書操作
{
	cout<<"**************************************"<<endl;
	cout<<"*      請輸入你要取消預約的圖書名    *"<<endl;
	string name;
	cin>>name;
	name="delete from reserve where book_name = '"+name+"' and state = '0';";
	way->Show_judge(se.Run(name.c_str()));
	return 0;
}
int Reader::select_reserva_Book(Chaxun & se)//預約情況查詢
{
	string str="select book_name as '書名',time as '預約時間',state as '結果' from reserve";
	MYSQL_RES * point;
	int bb[3]={14,12,4};
	point=se.Demand(str.c_str());
	cout<<"結果值說明:  0:未處理  1:已批準  2:未批準"<<endl;
	way->Show_data(point,bb);
	return 0;
}