Ejemplo n.º 1
0
 public function saveData()
 {
     parent::saveData();
     $cmd = $this->db->createCommand(SQL::SQL_UPDATE_DEVICE);
     $cmd->bindValue(":ip", $this->ip->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":port", $this->port->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":password", $this->password->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":initialOutput", $this->initialOutput->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output0_func", $this->getOuptutFunc($this->output0_func), PDO::PARAM_STR);
     $cmd->bindValue(":output1_func", $this->getOuptutFunc($this->output1_func), PDO::PARAM_STR);
     $cmd->bindValue(":output2_func", $this->getOuptutFunc($this->output2_func), PDO::PARAM_STR);
     $cmd->bindValue(":output3_func", $this->getOuptutFunc($this->output3_func), PDO::PARAM_STR);
     $cmd->bindValue(":output4_func", $this->getOuptutFunc($this->output4_func), PDO::PARAM_STR);
     $cmd->bindValue(":output5_func", $this->getOuptutFunc($this->output5_func), PDO::PARAM_STR);
     $cmd->bindValue(":output6_func", $this->getOuptutFunc($this->output6_func), PDO::PARAM_STR);
     $cmd->bindValue(":output7_func", $this->getOuptutFunc($this->output7_func), PDO::PARAM_STR);
     $cmd->bindValue(":output0Time", $this->output0Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output1Time", $this->output1Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output2Time", $this->output2Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output3Time", $this->output3Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output4Time", $this->output4Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output5Time", $this->output5Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output6Time", $this->output6Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":output7Time", $this->output7Time->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $cmd->Execute();
     return true;
 }
Ejemplo n.º 2
0
 public function saveData()
 {
     parent::saveData();
     $cmd = $this->db->createCommand(SQL::SQL_UPDATE_DEVICE);
     $cmd->bindValue(":address", $this->address->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":serialNumberFormat", $this->serialNumberFormat->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $cmd->Execute();
     return true;
 }
Ejemplo n.º 3
0
 public function saveData()
 {
     parent::saveData();
     $cmd = $this->db->createCommand(SQL::SQL_UPDATE_DEVICE);
     $cmd->bindValue(":ip", $this->ip->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":port", $this->port->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $cmd->Execute();
     return true;
 }
Ejemplo n.º 4
0
 public function saveData()
 {
     parent::saveData();
     $cmd = $this->db->createCommand(SQL::SQL_UPDATE_LCDDISPLAY);
     $cmd->bindValue(":ip", $this->ip->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":port", $this->port->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":messageTimerDisplay", $this->messageTimerDisplay->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":defaultMessage", $this->defaultMessage->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $cmd->Execute();
     return true;
 }
Ejemplo n.º 5
0
 public function saveData()
 {
     parent::saveData();
     $cmd = $this->db->createCommand(SQL::SQL_UPDATE_GANTNERTERMINAL);
     $cmd->bindValue(":ipOrDhcp", $this->ipOrDhcp->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":checkBooking", $this->checkBooking->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":userMemory", $this->userMemory->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":accessMemory", $this->accessMemory->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":subscriberNumber", $this->subscriberNumber->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":plantNumber", $this->plantNumber->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":mainCompIdCard", $this->mainCompIdCard->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":bookingCodeSumWinSwitchOver", $this->bookingCodeSumWinSwitchOver->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":switchOverLeap", $this->switchOverLeap->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":waitingTimeInput", $this->waitingTimeInput->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":monitoringTime", $this->monitoringTime->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":monitorinChangingTime", $this->monitorinChangingTime->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":cardReaderType", $this->cardReaderType->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":maxDoorOpenTime", $this->maxDoorOpenTime->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":warningTimeDoorOpenTime", $this->warningTimeDoorOpenTime->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":unlockingTime", $this->unlockingTime->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":relay1", $this->relay1->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":timeRelay1", $this->timeRelay1->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":relay2", $this->relay2->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":timeRelay2", $this->timeRelay2->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":relay3", $this->relay3->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":timeRelay3", $this->timeRelay3->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":relay4", $this->relay3->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":timeRelay4", $this->timeRelay3->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":opto1", $this->opto1->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":opto2", $this->opto2->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":opto3", $this->opto3->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":opto4", $this->opto4->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":enterExitInfo", $this->enterExitInfo->getSelectedValue(), PDO::PARAM_STR);
     $f1 = $this->autoUnlocking->getChecked() ? 1 : 0;
     $cmd->bindValue(":autoUnlocking", $f1, PDO::PARAM_STR);
     $f2 = $this->lockUnlockCommand->getChecked() ? 1 : 0;
     $cmd->bindValue(":lockUnlockCommand", $f2, PDO::PARAM_STR);
     $cmd->bindValue(":holdUpPINCode", $this->holdUpPINCode->SafeText, PDO::PARAM_STR);
     $f3 = $this->twoPersonAccess->getChecked() ? 1 : 0;
     $cmd->bindValue(":twoPersonAccess", $f3, PDO::PARAM_STR);
     $cmd->bindValue(":barriereRepeatedAccess", $this->barriereRepeatedAccess->SafeText, PDO::PARAM_STR);
     $f4 = $this->antiPassActive->getChecked() ? 1 : 0;
     $cmd->bindValue(":antiPassActive", $f4, PDO::PARAM_STR);
     $cmd->bindValue(":relayExpanderControl", $this->relayExpanderControl->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":doorOpenTimeUnit", $this->doorOpenTimeUnit->getSelectedValue(), PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID1", $this->optionalCompanyID1->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID2", $this->optionalCompanyID2->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID3", $this->optionalCompanyID3->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID4", $this->optionalCompanyID4->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID5", $this->optionalCompanyID5->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID6", $this->optionalCompanyID6->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID7", $this->optionalCompanyID7->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID8", $this->optionalCompanyID8->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID9", $this->optionalCompanyID9->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCompanyID10", $this->optionalCompanyID10->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalCardStructur", $this->optionalCardStructur->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalGantnerNationalCode", $this->optionalGantnerNationalCode->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalGantnerCustomerCode1", $this->optionalGantnerCustomerCode1->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalGantnerCustomerCode2", $this->optionalGantnerCustomerCode2->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalGantnerCustomerCode3", $this->optionalGantnerCustomerCode3->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalGantnerCustomerCode4", $this->optionalGantnerCustomerCode4->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalGantnerCustomerCode5", $this->optionalGantnerCustomerCode5->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalReaderInitialisation", $this->optionalReaderInitialisation->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":optionalTableCardType", $this->optionalTableCardType->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $cmd->Execute();
     $horuxService = new THoruxService();
     $horuxService->onStopDevice($id);
     $horuxService->onStartDevice($id);
     $sa = new TStandAlone();
     $sa->addStandalone("add", $this->id->Value, 'reinit');
     return true;
 }
Ejemplo n.º 6
0
 public function saveData()
 {
     parent::saveData();
     $cmd = $this->db->createCommand(SQL::SQL_UPDATE_GANTNERTERMINAL);
     $cmd->bindValue(":ipOrDhcp", $this->ipOrDhcp->SafeText, PDO::PARAM_STR);
     $isAutoRestart = $this->isAutoRestart->getChecked();
     $cmd->bindValue(":isAutoRestart", $isAutoRestart, PDO::PARAM_STR);
     $autoRestart = $this->autoRestartHour->SafeText . ":" . $this->autoRestartMinute->SafeText . ":00";
     $cmd->bindValue(":autoRestart", $autoRestart, PDO::PARAM_STR);
     $cmd->bindValue(":displayTimeout", $this->displayTimeout->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputTimeout", $this->inputTimeout->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":brightness", $this->brightness->getSelectedValue(), PDO::PARAM_STR);
     $udpServer = $this->udpServer->getChecked();
     $cmd->bindValue(":udpServer", $udpServer, PDO::PARAM_STR);
     $cmd->bindValue(":autoBooking", $this->autoBooking->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":checkBooking", $this->checkBooking->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $language = array();
     if ($this->ar->getChecked()) {
         $language[] = 'ar';
     }
     if ($this->de->getChecked()) {
         $language[] = 'de';
     }
     if ($this->en->getChecked()) {
         $language[] = 'en';
     }
     if ($this->fr->getChecked()) {
         $language[] = 'fr';
     }
     if ($this->it->getChecked()) {
         $language[] = 'it';
     }
     if ($this->fa->getChecked()) {
         $language[] = 'fa';
     }
     if ($this->pl->getChecked()) {
         $language[] = 'pl';
     }
     if ($this->ro->getChecked()) {
         $language[] = 'ro';
     }
     if ($this->es->getChecked()) {
         $language[] = 'es';
     }
     if ($this->cs->getChecked()) {
         $language[] = 'cs';
     }
     $language = implode(',', $language);
     $cmd->bindValue(":language", $language, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck1", $this->inputDBECheck1->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck2", $this->inputDBECheck2->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck3", $this->inputDBECheck3->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck4", $this->inputDBECheck4->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck5", $this->inputDBECheck5->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck6", $this->inputDBECheck6->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck7", $this->inputDBECheck7->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck8", $this->inputDBECheck8->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck9", $this->inputDBECheck9->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck10", $this->inputDBECheck10->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck11", $this->inputDBECheck11->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck12", $this->inputDBECheck12->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck13", $this->inputDBECheck13->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck14", $this->inputDBECheck14->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck15", $this->inputDBECheck15->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck16", $this->inputDBECheck16->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck17", $this->inputDBECheck17->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck18", $this->inputDBECheck18->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck19", $this->inputDBECheck19->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBECheck20", $this->inputDBECheck20->getChecked(), PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText1", $this->inputDBEText1->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText2", $this->inputDBEText2->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText3", $this->inputDBEText3->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText4", $this->inputDBEText4->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText5", $this->inputDBEText5->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText6", $this->inputDBEText6->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText7", $this->inputDBEText7->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText8", $this->inputDBEText8->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText9", $this->inputDBEText9->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText10", $this->inputDBEText10->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText11", $this->inputDBEText11->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText12", $this->inputDBEText12->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText13", $this->inputDBEText13->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText14", $this->inputDBEText14->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText15", $this->inputDBEText15->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText16", $this->inputDBEText16->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText17", $this->inputDBEText17->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText18", $this->inputDBEText18->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText19", $this->inputDBEText19->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEText20", $this->inputDBEText20->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat1", $this->inputDBEDisplay1->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat2", $this->inputDBEDisplay2->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat3", $this->inputDBEDisplay3->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat4", $this->inputDBEDisplay4->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat5", $this->inputDBEDisplay5->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat6", $this->inputDBEDisplay6->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat7", $this->inputDBEDisplay7->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat8", $this->inputDBEDisplay8->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat9", $this->inputDBEDisplay9->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat10", $this->inputDBEDisplay10->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat11", $this->inputDBEDisplay11->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat12", $this->inputDBEDisplay12->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat13", $this->inputDBEDisplay13->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat14", $this->inputDBEDisplay14->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat15", $this->inputDBEDisplay15->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat16", $this->inputDBEDisplay16->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat17", $this->inputDBEDisplay17->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat18", $this->inputDBEDisplay18->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat19", $this->inputDBEDisplay19->SafeText, PDO::PARAM_STR);
     $cmd->bindValue(":inputDBEFormat20", $this->inputDBEDisplay20->SafeText, PDO::PARAM_STR);
     $cmd->Execute();
     $cmd = $this->db->createCommand(SQL::SQL_REMOVE_KEY);
     $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
     $cmd->Execute();
     $inputData = $this->getViewState('inputData');
     $type = 'fixed';
     $key = 1;
     if ($this->leftFixed->SafeText != '' && $this->leftFixedDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->leftFixed->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->leftFixedDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 2;
     if ($this->leftMiddleFixed->SafeText != '' && $this->leftMiddleFixedDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->leftMiddleFixed->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->leftMiddleFixedDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 3;
     if ($this->rightMiddleFixed->SafeText != '' && $this->rightMiddleFixedDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->rightMiddleFixed->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->rightMiddleFixedDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 4;
     if ($this->rightFixed->SafeText != '' && $this->rightFixedDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->rightFixed->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->rightFixedDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $type = 'soft';
     $key = 1;
     if ($this->leftTopSoft->SafeText != '' && $this->leftTopSoftDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->leftTopSoft->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->leftTopSoftDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 2;
     if ($this->leftMiddleSoft->SafeText != '' && $this->leftMiddleSoftDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->leftMiddleSoft->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->leftMiddleSoftDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 3;
     if ($this->leftBottomSoft->SafeText != '' && $this->leftBottomSoftDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->leftBottomSoft->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->leftBottomSoftDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 4;
     if ($this->rightTopSoft->SafeText != '' && $this->rightTopSoftDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->rightTopSoft->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->rightTopSoftDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 5;
     if ($this->rightMiddleSoft->SafeText != '' && $this->rightMiddleSoftDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->rightMiddleSoft->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->rightMiddleSoftDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $key = 6;
     if ($this->rightBottomSoft->SafeText != '' && $this->rightBottomSoftDlg->getSelectedValue() != '') {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_KEY);
         $cmd->bindValue(":id", $this->id->Value, PDO::PARAM_STR);
         $cmd->bindValue(":type", $type, PDO::PARAM_STR);
         $cmd->bindValue(":key", $key, PDO::PARAM_STR);
         $cmd->bindValue(":text", $this->rightBottomSoft->SafeText, PDO::PARAM_STR);
         $cmd->bindValue(":dialog", $this->rightBottomSoftDlg->getSelectedValue(), PDO::PARAM_STR);
         if (isset($inputData[$type][$key])) {
             $cmd->bindValue(":params", $inputData[$type][$key], PDO::PARAM_STR);
         } else {
             $cmd->bindValue(":params", '', PDO::PARAM_STR);
         }
         $cmd->Execute();
     }
     $horuxService = new THoruxService();
     $horuxService->onStopDevice($id);
     $horuxService->onStartDevice($id);
     $sa = new TStandAlone();
     $sa->addStandalone("add", $this->id->Value, 'timuxReinit');
     return true;
 }