/** * fetch the result from database * * @return array * @throws base_database_Exception */ public function fetchDatabase() { $this->_validateTableNameNotEmpty(); $dbObj = base_database_connection_Mysql::get(); $result = $dbObj->query($this); return $this->transformDBResultToColumns($result); }
/** * execute the actual ajax request */ protected function executeRequest() { $error = null; $requestHelper = $this->controller->getRequestHelper(); $ret = BaseObject::SAVE_FAILURE; try { $class = $requestHelper->getParam('class'); $lk = (int) $requestHelper->getParam('LK'); $obj = Factory::loadObject($class, $lk); if (empty($obj)) { $this->msg = "Es wurde kein LK zum Löschen ausgewählt"; return; } else { } $dbObj = base_database_connection_Mysql::get(); $dbObj->beginTransaction(); $ret = $obj->delete(); $dbObj->endTransaction(); } catch (Exception $e) { $error = $e->getMessage(); } if (!is_null($error)) { $this->msg = $error; return; } $this->returnCode = self::PROCEED_TO_NEXT_PAGE; $this->redirectUrl = $_SERVER['HTTP_REFERER']; if ($ret == BaseObject::DELETE_SUCCESS) { $this->msg = "Der Datensatz '$lk' wurde erfolgreich gelöscht."; return; } $this->msg = "Der Datensatz '$lk' konnte nicht gelöscht werden"; }
/** * execute the actual ajax request */ protected function executeRequest() { $requestHelper = $this->controller->getRequestHelper(); $lks = $requestHelper->getParam('LK'); $amounts = $requestHelper->getParam('orderAmount'); $dbObj = base_database_connection_Mysql::get(); $dbObj->beginTransaction(); for ($i = 0; $i < count($lks); $i++) { $lk = $lks[$i]; $amount = $amounts[$i]; $medOffer = $this->calcNewOfferAmount($lk, $amount); $medOrder = $this->_createMedOrder($medOffer, $amount); $this->mails['offer'][$medOffer['firstEditor']][] = $medOrder; $this->mails['order'][] = $medOrder; } $this->msg = $this->errors[0]; if (count($this->errors) == 0) { $dbObj->doCommit(); $this->_sendMails(); $this->returnCode = self::PROCEED_TO_NEXT_PAGE; $this->msg = "Ihre Bestellung wurde aufgegeben. Bitte überprüfen Sie Ihre Emails."; return; } $dbObj->doRollback(); $this->returnCode = self::STAY_ON_ACTUAL_PAGE; // $this->msg = implode('<br />', $this->errors); }
/** * insert result into database * * @return int|null */ public function insertDatabase() { if (empty($this->columnValues) === true) { return null; } $dbObj = base_database_connection_Mysql::get(); return $dbObj->execute($this); }
/** * insert result into database * * @return int */ public function insertDatabase() { $dbObj = base_database_connection_Mysql::get(); $dbObj->beginTransaction(); $lastKey = $dbObj->execute($this); $dbObj->endTransaction(); return $lastKey; }
/** * @return base_database_connection_Mysql */ public static function get() { if (self::$_instance === null) { self::$_instance = new self(); } return self::$_instance; }
public function importCMD() { if (empty($this->data)) { return self::NO_DATA; } $i = 0; echo '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++'; echo '----- Import der Klasse ' . get_class($this->obj) . ' -----'; $microStart = time(); $dbObj = base_database_connection_Mysql::get(); $dbObj->beginTransaction(); foreach ($this->data as $data) { if ($i % 50 == 0) { echo PHP_EOL . "$i/" . count($this->data); } if ($this->isIrrelevantData($data)) { echo 'S'; $i++; continue; } $result = null; $obj = clone $this->obj; $where = $this->getWhereForFindExistingData($data); if ($where instanceof base_database_Where) { $result = $this->getExistingObjects($where); } if (!is_null($result)) { $obj->load($result, BaseObject::LOAD_PK); } foreach ($data as $colName => $value) { $mapper = base_mapper_Factory::createObject(get_class($obj), $colName); if (!is_null($mapper)) { $mapper->setCurrentDataSet($data); $value = $mapper->mapFieldValue($value); } $obj[$colName] = $value; } if ($obj->save() == BaseObject::SAVE_NOCHANGES) { echo 'S'; } else { echo '.'; } $i++; } $microEnd = time(); $diff = $microEnd - $microStart; echo PHP_EOL . "----- Dauer: " . $diff . " Sekunden" . PHP_EOL . PHP_EOL; echo '+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' . PHP_EOL; $dbObj->endTransaction(); return self::SUCCESS; }
/** * end a database transaction */ public static function endTransaction() { base_database_connection_Mysql::get()->endTransaction(); }
/** * insert result into database * * @return int|null */ public function insertDatabase() { $dbObj = base_database_connection_Mysql::get(); return $dbObj->execute($this); }
/** * creates the admin user * * @param OutputDevice $od * @throws base_database_Exception */ public function createAdminUser(OutputDevice $od) { $user = new User(); if (!is_null($user->load(1))) { return; } $seq = new Sequence('User'); $adminData['LK'] = $seq->getNextSequence(); $adminData['firstEditor'] = 1; $dateTime = new base_date_model_DateTime(); $adminData['firstEditTime'] = $dateTime->toDB(); $adminData['editor'] = 1; $adminData['editTime'] = $dateTime->toDB(); $adminData['userid'] = 'admin'; $adminData['password'] = '******'; $adminData['firstName'] = 'Admin'; $adminData['lastName'] = 'Admin'; $adminData['email'] = '*****@*****.**'; $statement = new base_database_statement_Insert(); $table = DB::table('user'); $statement->setTable($table); foreach ($adminData as $fieldName => $value) { $statement->setColumnValue($table->getColumn($fieldName), DB::term($value)); } $dbObj = base_database_connection_Mysql::get(); $dbObj->beginTransaction(); $seq->save(); $statement->insertDatabase(); $dbObj->endTransaction(); base_install_Message::printOut('----- Admin User created -----', $od); }
/** * fetch the result from database * * @return array * @throws base_database_Exception */ public function fetchDatabase() { $dbObj = base_database_connection_Mysql::get(); return $dbObj->query($this); }
/** * execute the actual ajax request */ protected function executeRequest() { $error = ''; $requestHelper = $this->controller->getRequestHelper(); try { $class = $requestHelper->getParam('class'); $lk = (int) $requestHelper->getParam('LK'); if (!empty($lk)) { $obj = Factory::loadObject($class, $lk); } else { $obj = Factory::createObject($class); } foreach ($requestHelper->getAllParams() as $fieldName => $value) { try { $fi = $obj->getFieldinfo($fieldName); if ($fi->isMandatory() && empty($value) && $fieldName != 'LK') { $error .= TMS(base_exception_Fieldinfo::FIELD_IS_MANDATORY, array('field' => $fi->getFieldLabel())) . "<br />"; } $obj[$fieldName] = $value; } catch (Exception $e) { } } if (empty($error)) { $dbObj = base_database_connection_Mysql::get(); $dbObj->beginTransaction(); $ret = $obj->save(); $dbObj->endTransaction(); } } catch (Exception $e) { $error = $e->getMessage(); } if (!empty($error)) { $this->msg = $error; return; } if ($this->controller->getCallerSection() == base_ajax_Controller::CALLER_SECTION_ACP) { $url = 'de/acp'; } else { $url = 'de/'; } switch ($requestHelper->getParam('referer')) { case base_form_View::SAVE_AND_EDIT: $this->returnCode = self::STAY_ON_ACTUAL_PAGE; break; case base_form_View::SAVE_AND_NEW: $this->returnCode = self::PROCEED_TO_NEXT_PAGE; $this->setRedirectUrl($url . '/frontend.php?controller=base_pages_input_controller_BaseObject&class=' . $class . '&mode=edit'); break; case base_form_View::SAVE_AND_SEARCH: $this->returnCode = self::PROCEED_TO_NEXT_PAGE; $this->setRedirectUrl($url . '/frontend.php?controller=base_pages_search_controller_TableList&class=' . $class . '&mode=edit'); break; } if ($ret == BaseObject::SAVE_SUCCESS) { $this->msg = "Der Datensatz wurde erfolgreich gespeichert."; return; } $this->returnCode = self::STAY_ON_ACTUAL_PAGE; if ($ret == BaseObject::SAVE_FAILURE) { $this->msg = "Der Datensatz konnte nicht gespeichert werden"; return; } $this->msg = "Es wurden keine Veränderungen am Datensatz vorgenommen"; }