monthlyusageform.ui.h

在qt环境下开发的PPP拨号程序,具有良好的操作界面,方便开发通信程序

/****************************************************************************
** ui.h extension file, included from the uic-generated form implementation.
**
** If you wish to add, delete or rename slots use Qt Designer which will
** update this file, preserving your code. Create an init() slot in place of
** a constructor, and a destroy() slot in place of a destructor.
*****************************************************************************/

MYSQL db;


void MonthlyUsageForm::init()
{    
    MYSQL_RES *mysql_res;
    MYSQL_ROW mysql_row;    
    mysql_init(&db);
    mysql_real_connect(&db,"localhost","myppp","squirrel",
		       "myppp",0,NULL,0);
    mysql_query(&db,"SELECT * FROM usagelog");
    mysql_res=mysql_store_result(&db);
    unsigned int numrows = mysql_num_rows(mysql_res);
    table->setNumRows(numrows);
    int i;
    for(i=0;i<numrows;i++) {
	mysql_row=mysql_fetch_row(mysql_res);
	QVariant yvar(mysql_row[0]);
	QVariant hvar(mysql_row[2]);
	QVariant mvar(mysql_row[3]);
	QString year_str = yvar.toString();
	QString month_str = mysql_row[1];
	QString hstr = hvar.toString();
	QString mstr = mvar.toString();
	QString date_str = month_str + " " + year_str;
	QString usage_str = hstr + " hr. " + mstr + " min.";
	table->setText(i,0,date_str);
	table->setText(i,1,usage_str);
    }
    table->setCurrentCell(i,0);
}

void MonthlyUsageForm::filterdtrlist(bool on)
{
    MYSQL_RES *mysql_res;
    MYSQL_ROW mysql_row;
    QString description = table->text(table->currentRow(),0);
    if(on) {
	mysql_query(&db, "SELECT logon_datetime,logoff_datetime,interface,user
		    FROM dtr WHERE description = \"" + description + "\"");
    }
    else {
	mysql_query(&db, "SELECT logon_datetime,logoff_datetime,interface,user
		    FROM dtr");
    }
    mysql_res=mysql_store_result(&db);
    unsigned int numrows = mysql_num_rows(mysql_res);
    dtr->setNumRows(numrows);
    QHeader *h = dtr->verticalHeader();
    for(int i=0;i<numrows;i++) {
	mysql_row=mysql_fetch_row(mysql_res);
	QVariant var1 = mysql_row[0];
	QVariant var2 = mysql_row[1];
	QVariant var3 = mysql_row[2];
	QVariant var4 = mysql_row[3];
	dtr->setText(i,0,var1.toString());
	dtr->setText(i,1,var2.toString());
	dtr->setText(i,2,var3.toString());
	dtr->setText(i,3,var4.toString());
	h->setLabel(i,QString::number(i+1,10));
    }
    for(int i=0;i<4;i++) dtr->adjustColumn(i);
}

void MonthlyUsageForm::table_currentChanged(int,int)
{
    filterdtrlist(filtersw->isChecked());
}

void MonthlyUsageForm::closeButton_clicked()
{
    this->close();
}

void MonthlyUsageForm::clearButton_clicked()
{
    QString user=getenv("USER");
    if(user=="root") {
	switch(QMessageBox::warning(this, "MyPPP",
				    "Clear DTR list. Are you sure?",
				    QMessageBox::Yes|QMessageBox::Default,
				    QMessageBox::No|QMessageBox::Escape)) {
	    case QMessageBox::Yes:
		    mysql_query(&db, "DELETE FROM dtr");
	    filterdtrlist(filtersw->isChecked());
	    break;
	    case QMessageBox::No: break;
	}
    }
    else { 
	QMessageBox::information( this, "MyPPP",
				  "Only root may do that.",
				  "Oops!");
    }
}

void MonthlyUsageForm::filtersw_toggled(bool on)
{
    filterdtrlist(on);
}