Exemple #1
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;
 }
 public function onUnAttribute($sender, $param)
 {
     $cbs = $this->findControlsByType("TActiveCheckBox");
     $nUnAttributed = 0;
     $koMsg = '';
     $cbChecked = 0;
     foreach ($cbs as $cb) {
         if ((bool) $cb->getChecked() && $cb->Value != "0") {
             $cbChecked++;
         }
     }
     if ($cbChecked == 0) {
         $koMsg = Prado::localize('Select one item');
     } else {
         foreach ($cbs as $cb) {
             if ((bool) $cb->getChecked() && $cb->Value != "0") {
                 $cmd = $this->db->createCommand("SELECT * FROM hr_openTime_attribution WHERE id=:id");
                 $cmd->bindValue(":id", $cb->Value);
                 $data = $cmd->query();
                 $data = $data->read();
                 $deviceId = $data['id_device'];
                 $cmd = $this->db->createCommand(SQL::SQL_DELETE_OPEN_TIME_ATTRIBUTION);
                 $cmd->bindValue(":id", $cb->Value);
                 if ($cmd->execute()) {
                     $nUnAttributed++;
                     $horuxService = new THoruxService();
                     $horuxService->onStopDevice($deviceId);
                     $horuxService->onStartDevice($deviceId);
                     $sa = new TStandAlone();
                     $sa->addStandalone("add", $deviceId, 'reinit');
                 }
             }
         }
     }
     if ($koMsg !== '') {
         $pBack = array('id' => $this->id->Value, 'koMsg' => $koMsg);
         $this->Response->redirect($this->Service->constructUrl('openTime.attribute', $pBack));
     } else {
         $pBack = array('id' => $this->Request['id'], 'okMsg' => Prado::localize('{n} open time was unattributed', array('n' => $nUnAttributed)));
         $this->Response->redirect($this->Service->constructUrl('openTime.attribute', $pBack));
     }
 }
Exemple #3
0
 public function saveData()
 {
     parent::saveData();
     if ($this->lastId !== false) {
         $cmd = $this->db->createCommand(SQL::SQL_ADD_GANTNERTERMINAL);
         $cmd->bindValue(":id_device", $this->lastId, PDO::PARAM_STR);
         $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);
         $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();
         $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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 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->lastId, 'timuxReinit');
         return true;
     } else {
         return false;
     }
 }