void MainWindow::tab2_tempdataup(Ui_Temp_moniter1 *temp_moniter){
QString temp_set_name = QString("temp%1_set").arg(temp_moniter->comboBox->currentIndex()+1);
QString temp_up_name = QString("temp%1_up").arg(temp_moniter->comboBox->currentIndex()+1);
QString temp_down_name = QString("temp%1_down").arg(temp_moniter->comboBox->currentIndex()+1);
QString temp_real_name = QString("temp%1_real").arg(temp_moniter->comboBox->currentIndex()+1);
QSqlQuery remotequery(mdb);
QString query = QString("select %1,%2,%3,%4 from temp_table where machine_name = \'%5\'")
.arg(temp_set_name).arg(temp_up_name).arg(temp_down_name).arg(temp_real_name).arg(MainWindowui->machinenamelistbox->currentText());
remotequery.exec(query);
remotequery.next();
temp_moniter->real_lcd_number->display(remotequery.value(temp_real_name).toDouble()/10.0);
int real_value = remotequery.value(temp_real_name).toInt()/10;
int setting_value = remotequery.value(temp_set_name).toInt()/10;
int up_value = remotequery.value(temp_up_name).toInt()/10;
int down_value = remotequery.value(temp_down_name).toInt()/10;
up_value = setting_value + up_value;
down_value = setting_value-down_value;
temp_moniter->setting_btn->setText(QString("%1").arg(setting_value));
temp_moniter->up_btn->setText(QString("%1").arg(up_value));
temp_moniter->down_btn->setText(QString("%1").arg(down_value));
temp_moniter->tempSlider->setMinimum(down_value);
temp_moniter->tempSlider->setMaximum(up_value);
temp_moniter->tempSlider->setValue(real_value);
}
void MainWindow::tab2_tempnameinit(Temp_moniter1 * temp_data,int number){
QSqlQuery remotequery(mdb);
QString querystr = QString("select * from temp_table where machine_name = \'%1\'").arg(MainWindowui->machinenamelistbox->currentText());
remotequery.exec(querystr);
remotequery.next();
if(temp_data->Temp_moniter1ui->comboBox->count() == 0){
for(int i=1;i<=21;i++){
QString temp_str = QString("temp%1_name").arg(i);
temp_data->Temp_moniter1ui->comboBox->addItem(QIcon(":/icon/icon/thermometer.png"),remotequery.value(temp_str).toString());
}
}else {
for(int i=1;i<=21;i++){
QString temp_str = QString("temp%1_name").arg(i);
temp_data->Temp_moniter1ui->comboBox->setItemText(i-1,remotequery.value(temp_str).toString());
}
}
temp_data->id = number;
QSqlQuery litequery1(litedb);
querystr = QString("select temp%1 from temp_setindex;").arg(number);
QString coldata1 = QString("temp%1").arg(number);
litequery1.exec(querystr);
litequery1.next();
temp_data->Temp_moniter1ui->comboBox->setCurrentIndex(litequery1.value(coldata1).toInt());
connect(temp_data->Temp_moniter1ui->comboBox,SIGNAL(currentIndexChanged(int)),temp_data,SLOT(on_comboBox_currentIndexChanged(int)));
}
fpfrom::fpfrom(QWidget *parent) :
QWidget(parent),
ui(new Ui::fpfrom)
{
ui->setupUi(this);
QSqlDatabase localdb;
localdb = QSqlDatabase::database("localdb");
QSqlDatabase remotedb;
QSqlQuery litequery(localdb);
litequery.exec("select * from systemset");
if(litequery.next()){
QString remoteserverip = litequery.value("remoteserverip").toString();
QString remoteserverport = litequery.value("remoteserverport").toString();
QString remoteserverdbname = litequery.value("remoteserverdbname").toString();
QString remoteserverusername = litequery.value("remoteserverusername").toString();
QString remoteserveruserpassword = litequery.value("remoteserveruserpassword").toString();
QString remoteservertype = litequery.value("remoteservertype").toString();
if(!remoteservertype.compare("ODBC")){
remotedb = QSqlDatabase::addDatabase("QODBC","tempmoniterdb");
}else if(!remoteservertype.compare("MYSQL")) {
remotedb = QSqlDatabase::addDatabase("QMYSQL","tempmoniterdb");
}
remotedb.setHostName(remoteserverip);
remotedb.setDatabaseName(remoteserverdbname);
remotedb.setPort(remoteserverport.toInt());
remotedb.setUserName(remoteserverusername);
remotedb.setPassword(remoteserveruserpassword);
if(!remotedb.open()){
qDebug()<<"DB not open";
}else {
}
qDebug()<<remotedb.lastError().text();
}
QSqlQuery remotequery(remotedb);
remotequery.exec("select machine_name from Systeminfo order by machine_name asc");
disconnect(ui->cb_machine_name,SIGNAL(currentIndexChanged(QString)),this,SLOT(on_cb_machine_name_currentIndexChanged(QString)));
while(remotequery.next()){
ui->cb_machine_name->addItem(remotequery.value("machine_name").toString());
}
connect(ui->cb_machine_name,SIGNAL(currentIndexChanged(QString)),this,SLOT(on_cb_machine_name_currentIndexChanged(QString)));
litequery.exec("select temp_current_machine_name from systemset");
if(litequery.next()){
QString initname = litequery.value("temp_current_machine_name").toString();
bool sameflag = false;
for(int i=0;i<ui->cb_machine_name->count();i++){
if(ui->cb_machine_name->itemText(i) == initname){
sameflag = true;
}
}
if(sameflag){
ui->cb_machine_name->setCurrentText(initname);
}else {
emit ui->cb_machine_name->currentIndexChanged(ui->cb_machine_name->itemText(0));
}
}
remotequery.finish();
}
void MainWindow::warning_loop(){
QSqlQuery remotequery(mdb);
QString querystr = QString("select warning_flag from Systeminfo where machine_name = \'%1\'")
.arg(MainWindowui->machinenamelistbox->currentText());
remotequery.exec(querystr);
remotequery.next();
if(remotequery.value("warning_flag").toInt() == 1){
if(MainWindowui->scrollArea->styleSheet().compare("") == 0){
MainWindowui->scrollArea->setStyleSheet("background-color : rgb(255, 0, 0)");
}else {
MainWindowui->scrollArea->setStyleSheet("");
}
}else {
MainWindowui->scrollArea->setStyleSheet("");
}
}
//사출기 교체후 인터페이스 초기화 작업
void MainWindow::machine_change_init(QString machinename){
QSqlQuery remotequery(mdb);
QString querystr = QString("select * from Systeminfo where machine_name = \'%1\'").arg(machinename);
remotequery.exec(querystr);
remotequery.next();
MainWindowui->mold_name_box->setText(remotequery.value("mold_name").toString());
MainWindowui->machine_name_btn->setText(machinename);
MainWindowui->item_name_label->setText(remotequery.value("item_name").toString());
MainWindowui->item_code_label->setText(remotequery.value("item_code").toString());
MainWindowui->works_name_label->setText(remotequery.value("worker").toString());
MainWindowui->cycle_time_label->setText(remotequery.value("cycle_time").toString());
MainWindowui->cabit_count->setText(remotequery.value("cabity").toString());
MainWindowui->object_count_led->display(remotequery.value("object_count").toInt());
MainWindowui->production_count_lcd->display(remotequery.value("production_count").toInt());
MainWindowui->achievemen_rate_lcd->display(remotequery.value("achievemen_rate").toDouble());
int goodcount = remotequery.value("production_count").toInt() - remotequery.value("poor_count").toInt();
MainWindowui->good_count_lcd->display(goodcount);
MainWindowui->poor_count_lcd->display(remotequery.value("poor_count").toInt());
MainWindowui->achievemen_bar->setValue(remotequery.value("achievemen_rate").toInt());
MainWindowui->cycle_time_label->setText(remotequery.value("cycle_time").toString());
MainWindowui->run_mode_label->setText(remotequery.value("run_mode").toString());
tab2_tempnameinit(MainWindowui->Tab2_temp1,1);
tab2_tempnameinit(MainWindowui->Tab2_temp2,2);
tab2_tempnameinit(MainWindowui->Tab2_temp3,3);
tab2_tempnameinit(MainWindowui->Tab2_temp4,4);
tab2_tempnameinit(MainWindowui->Tab2_temp5,5);
tab2_tempnameinit(MainWindowui->Tab2_temp6,6);
tab2_tempnameinit(MainWindowui->Tab2_temp7,7);
tab2_tempnameinit(MainWindowui->Tab2_temp8,8);
tab2_tempnameinit(MainWindowui->Tab2_temp9,9);
tab2_tempnameinit(MainWindowui->Tab2_temp10,10);
tab2_tempnameinit(MainWindowui->Tab2_temp11,11);
tab2_tempnameinit(MainWindowui->Tab2_temp12,12);
tab2_tempnameinit(MainWindowui->Tab2_temp13,13);
tab2_tempnameinit(MainWindowui->Tab2_temp14,14);
tab2_tempnameinit(MainWindowui->Tab2_temp15,15);
}
void MainWindow::workplantab_loop(){
QSqlQuery remotequery(mdb);
QString querystr = QString("select * from Systeminfo where machine_name = \'%1\'")
.arg(MainWindowui->machinenamelistbox->currentText());
remotequery.exec(querystr);
remotequery.next();
MainWindowui->mold_name_box->setText(remotequery.value("mold_name").toString());
MainWindowui->item_name_label->setText(remotequery.value("item_name").toString());
MainWindowui->item_code_label->setText(remotequery.value("item_code").toString());
MainWindowui->works_name_label->setText(remotequery.value("worker").toString());
MainWindowui->object_count_led->display(remotequery.value("object_count").toInt());
MainWindowui->production_count_lcd->display(remotequery.value("production_count").toInt());
MainWindowui->achievemen_rate_lcd->display(remotequery.value("achievemen_rate").toDouble());
MainWindowui->achievemen_bar->setValue(remotequery.value("achievemen_rate").toInt());
int goodcount = remotequery.value("production_count").toInt() - remotequery.value("poor_count").toInt();
int poorcount = remotequery.value("poor_count").toInt();
MainWindowui->good_count_lcd->display(goodcount);
MainWindowui->poor_count_lcd->display(poorcount);
MainWindowui->cycle_time_label->setText(remotequery.value("cycle_time").toString());
MainWindowui->run_mode_label->setText(remotequery.value("run_mode").toString());
int object_count = remotequery.value("object_count").toInt();
int production_count = remotequery.value("production_count").toInt();
int remind_count = object_count-production_count;
QTime temptime(0,0,0);
QTime remind_time;
int timer = remotequery.value("cycle_time").toTime().secsTo(temptime);
timer = timer * -1;
int remind_time_sec = remind_count * timer;
remind_time = temptime.addSecs(remind_time_sec);
MainWindowui->remind_time_label->setText(remind_time.toString("hh:mm:ss"));
}
