/** * @see sfTask */ protected function execute($arguments = array(), $options = array()) { sfContext::createInstance($this->configuration); $blast = Doctrine::getTable('Blast')->find(1); $response = Doctrine::getTable('BlastResponse')->find(1); BlastManager::createTextResponse($response); }
public function executeDelete(sfWebRequest $request) { $request->checkCSRFProtection(); $this->forward404Unless($encuestado_sanciones = Doctrine::getTable('EncuestadoSanciones')->find(array($request->getParameter('id'))), sprintf('Object encuestado_sanciones does not exist (%s).', $request->getParameter('id'))); $encuestado_sanciones->delete(); $this->redirect('EncuestadoSancionesVigentes/index'); }
/** * Singleton pattern, returneaza conexiunea * @return EntityManger */ public static function getInstance() { if (!self::$instance) { self::$instance = new Doctrine(); } return self::$instance; }
public function authenticateUserRequest() { $authResult = $this->authenticateKey($this->request->getParameter('_key')); switch ($authResult) { case self::AUTH_FAIL_KEY: $this->response->setStatusCode(401); sfLoader::loadHelpers('Partial'); $partial = get_partial('global/401'); $this->response->setContent($partial); $this->response->setHttpHeader('WWW-Authenticate', 'Your request must include a query parameter named "_key" with a valid API key value. To obtain an API key, visit http://api.littlesis.org/register'); $this->response->sendHttpHeaders(); $this->response->sendContent(); throw new sfStopException(); break; case self::AUTH_FAIL_LIMIT: $this->response = sfContext::getInstance()->getResponse(); $this->response->setStatusCode(403); $user = Doctrine::getTable('ApiUser')->findOneByApiKey($this->request->getParameter('_key')); sfLoader::loadHelpers('Partial'); $partial = get_partial('global/403', array('request_limit' => $user->request_limit)); $this->response->setContent($partial); $this->response->sendHttpHeaders(); $this->response->sendContent(); throw new sfStopException(); break; case self::AUTH_SUCCESS: break; default: throw new Exception("Invalid return value from LsApi::autheticate()"); } }
protected function doSave($con = null) { parent::doSave(); $newOptions = $this->getValue('option'); $newOptions = preg_split('/[\\s ]+/u', $newOptions, -1, PREG_SPLIT_NO_EMPTY); $voteQuestion = $this->getObject(); // 過去の選択肢の抽出 $oldOptions = $voteQuestion->getVoteQuestionOptions(); $oldOptions = $oldOptions->toKeyValueArray('id', 'body'); // 削除された選択肢の抽出 $deletedOptions = array_diff($oldOptions, $newOptions); foreach ($deletedOptions as $id => $body) { // 削除 $object = Doctrine::getTable('VoteQuestionOption')->find($id); $object->delete(); } // 新規の選択肢 $insertOptions = array_diff($newOptions, $oldOptions); foreach ($insertOptions as $body) { // 追加 $object = new VoteQuestionOption(); $object->setVoteQuestion($voteQuestion); $object->setBody($body); $object->save(); } }
public function executeDelete(sfWebRequest $request) { $request->checkCSRFProtection(); $this->forward404Unless($product = Doctrine::getTable('Product')->find(array($request->getParameter('id'))), sprintf('Object product does not exist (%s).', array($request->getParameter('id')))); $product->delete(); $this->redirect('product/index'); }
protected function execute($arguments = array(), $options = array()) { $app = $options['app']; $env = $options['env']; $this->bootstrapSymfony($app, $env, true); // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase('doctrine')->getConnection(); $this->logSection('import', 'initializing...'); $plugins = SymfonyPluginApi::getPlugins(); $count = 0; foreach ($plugins as $plugin) { $new = Doctrine::getTable('SymfonyPlugin')->findOneByTitle($plugin['id']); // if plugin exists update info. Otherwise, create it if ($new) { // Nothing Yet } elseif ($plugin['id']) { $new = new SymfonyPlugin(); $new['title'] = (string) $plugin['id']; $new['description'] = (string) $plugin->description; $new['repository'] = (string) $plugin->scm; $new['image'] = (string) $plugin->image; $new['homepage'] = (string) $plugin->homepage; $new['ticketing'] = (string) $plugin->ticketing; $new->saveNoIndex(); $this->logSection('import', "added '{$new->title}'"); $count++; } } $this->logSection('import', "Running Lucene Cleanup"); $this->runLuceneRebuild(); $this->logSection('import', "Completed. Added {$count} new plugins(s)"); }
/** * Авторизовать пользователя * * @param User $user * @param bool $remember * @return void */ public function signIn(User $user, $remember = false) { $this->user = $user; $this->setAttribute('id', $user->getId(), 'user'); $this->setAuthenticated(true); $this->clearCredentials(); if ($remember) { $now = new DateTime(); $expired = clone $now; $expired->modify("-" . $this->getExpiration() . " sec"); // убить все старые кючи Doctrine::getTable('myAuthRememberKey')->removeOldKeys($expired)->execute(); // убить все ключи этого пользователя Doctrine::getTable('myAuthRememberKey')->removeKeysByUserId($user->getId())->execute(); // создать новый ключ $key = $this->generateRandomKey(); // сохранить ключ $rk = new myAuthRememberKey(); $rk->setRememberKey($key); $rk->setUser($user); $rk->setIpAddress($_SERVER['REMOTE_ADDR']); $rk->save(); // отдать ключ в виде печенья sfContext::getInstance()->getResponse()->setCookie($this->getCookieName(), $key, time() + $this->getExpiration()); } }
/** * ajax action for customer name autocompletion * * @return JSON * @author Enrique Martinez **/ public function executeAjaxCustomerAutocomplete(sfWebRequest $request) { $this->getResponse()->setContentType('application/json'); $q = $request->getParameter('q'); $items = Doctrine::getTable('Customer')->simpleRetrieveForSelect($request->getParameter('q'), $request->getParameter('limit')); return $this->renderText(json_encode($items)); }
public function executeDelete(sfWebRequest $request) { $this->forward404Unless($area_interesse = Doctrine::getTable('AreaInteresse')->find(array($request->getParameter('id'))), sprintf('Object area_interesse does not exist (%s).', $request->getParameter('id'))); $area_interesse->delete(); $this->getUser()->setFlash('success', 'Área de Interesse excluída com sucesso!'); $this->redirect('areaInteresse/index'); }
/** * @see sfTask */ protected function execute($arguments = array(), $options = array()) { $this->logSection('doctrine', 'created tables successfully'); $databaseManager = new sfDatabaseManager($this->configuration); Doctrine::loadModels(sfConfig::get('sf_lib_dir') . '/model/doctrine', Doctrine::MODEL_LOADING_CONSERVATIVE); Doctrine::createTablesFromArray(Doctrine::getLoadedModels()); }
protected function execute($arguments = array(), $options = array()) { $con = $this->crearConexion(); try { $record = Doctrine::getTable('EmailConfiguration')->findAll()->getFirst(); $config_mail = array('charset' => 'UTF-8', 'encryption' => $record->getSmtpSecurityType(), 'host' => $record->getSmtpHost(), 'port' => $record->getSmtpPort(), 'username' => $record->getSmtpUsername(), 'password' => $record->getSmtpPassword(), 'authentication' => $record->getSmtpAuthType()); $mail = new PHPMailer(); $mail->IsSMTP(); $mail->CharSet = $config_mail['charset']; if ($config_mail['authentication'] == "login") { $mail->SMTPAuth = true; } if ($config_mail['encryption'] == "tls") { $mail->SMTPSecure = "tls"; } if ($config_mail['encryption'] == "ssl") { $mail->SMTPSecure = "ssl"; } $mail->Host = $config_mail['host']; $mail->Port = $config_mail['port']; $mail->Username = $config_mail['username']; $mail->Password = $config_mail['password']; $mail->FromName = 'Mi company'; $mail->From = $config_mail['username']; //email de remitente desde donde se env?a el correo $mail->AddAddress($config_mail['username'], 'Destinatario'); //destinatario que va a recibir el correo $mail->Subject = "confeccion de gafete"; /*Recojemos los datos del oficial*/ $dao = new EmployeeDao(); $employeeList = $dao->getEmployeeList(); foreach ($employeeList as $employee) { if ($employee->getJoinedDate() != "") { $datetime1 = new DateTime($employee->getJoinedDate()); $datetime2 = new DateTime(date('y-m-d', time())); $formato = $datetime2->format('y-m-d'); $intervalo = $datetime1->diff($datetime2, true); if ($intervalo->m == 2 && $intervalo->d == 0) { $html = "Identificador: " . $employee->getEmployeeId() . "<br/>"; $html .= "ID: " . $employee->getOtherId() . "<br/>"; $html .= "Nombre : " . utf8_encode($employee->getFullName()) . "<br/>"; $html .= "Fecha Nac : " . $employee->getEmpBirthday() . "<br/>"; $sexo = $employee->getEmpGender() == 1 ? "Masculino" : "Femenino"; $html .= "Género : " . $sexo . "<br/>"; $html .= "Nacionalidad: " . $employee->getNationality() . "<br/>"; $html .= "Móvil: " . $employee->getEmpMobile() . "<br/>"; $mail->MsgHTML($html); if (!$mail->Send()) { $this->escribirYML('log_tareas', false, $mail->ErrorInfo . " Error al enviar el correo con los datos del empleado " . $employee->getFullName()); } else { $this->escribirYML('log_tareas', true, "correo enviado con los datos del empleado " . $employee->getFullName()); } } } } Doctrine_Manager::getInstance()->closeConnection($con); } catch (Exception $e) { $this->escribirYML('log_tareas', false, $e->getMessage()); } }
public function executeChangeOrder(sfWebRequest $request) { $col1 = explode(',', $request->getParameter('col1')); $col2 = explode(',', $request->getParameter('col2')); Doctrine::getTable('MyWidgets')->setUserRef($this->getUser()->getAttribute('db_user_id'))->changeOrder($request->getParameter('category') . "_widget", $col1, $col2); return $this->renderText(var_export($col1, true) . var_export($col2, true)); }
public function setup() { $db = $this->databasemanager->getDatabase('doctrine'); /* @var $db sfDoctrineDatabase */ // Special Handling for postgre, since droping even when closing the connection, fails with // SQLSTATE[55006]: Object in use: 7 ERROR: database "cs_doctrine_act_as_sortable_test" is being accessed by other users DETAIL: There are 1 other session(s) using the database. if ($db->getDoctrineConnection() instanceof Doctrine_Connection_Pgsql) { try { $db->getDoctrineConnection()->createDatabase(); } catch (Exception $e) { } $export = new Doctrine_Export_Pgsql($db->getDoctrineConnection()); $import = new Doctrine_Import_Pgsql($db->getDoctrineConnection()); $tablenames = array(SortableArticleTable::getInstance()->getTableName(), SortableArticleUniqueByTable::getInstance()->getTableName(), SortableArticleCategoryTable::getInstance()->getTableName()); foreach ($tablenames as $tablename) { if ($import->tableExists($tablename)) { $export->dropTable($tablename); } } } else { try { // ignore error if database does not yet exist (clean CI-env) $db->getDoctrineConnection()->dropDatabase(); } catch (Exception $e) { } $db->getDoctrineConnection()->createDatabase(); } // Using Doctrine instead of Doctrine_Core keeps it symfony 1.2 compatible, which uses Doctrine::loadModels(dirname(__FILE__) . '/../fixtures/project/lib/model/doctrine', Doctrine::MODEL_LOADING_CONSERVATIVE); Doctrine::createTablesFromArray(Doctrine::getLoadedModels()); Doctrine::loadData(dirname(__FILE__) . '/../fixtures/project/data/fixtures/categories.yml'); }
public function executeActivityBox(sfWebRequest $request) { $id = $request->getParameter('id', $this->getUser()->getMemberId()); $this->activities = Doctrine::getTable('ActivityData')->getActivityList($id, null, $this->gadget->getConfig('row')); $this->member = Doctrine::getTable('Member')->find($id); $this->isMine = $id == $this->getUser()->getMemberId(); }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'])->getConnection(); // add your code here $n = $options['n']; $tags = $this->createTags($n); if (!empty($options['models'])) { $modelClasses = explode(',', $options['models']); foreach ($modelClasses as $class) { try { $models = Doctrine::getTable($class)->createQuery()->execute(); foreach ($models as $model) { $modelTags = array(); while (count($modelTags) < $options['tags-per-model']) { $tag = $tags[rand(0, $n - 1)]; $modelTags[$tag] = $tag; } $modelTags = array_values($modelTags); $model->addTag($modelTags); $model->save(); } } catch (Exception $e) { echo $e->getMessage() . "\n"; } } } }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'])->getConnection(); $this->logSection('rdvz', "Retrieving users...") ; $ldap = new uapvLdap() ; $users = Doctrine::getTable('user')->retrieveLdapUsers() ; $this->logSection('rdvz', "Updating information...") ; foreach($users as $user) { $us = $ldap->searchOne(sfConfig::get('app_profile_var_translation_uid')."=".$user->getLdapId()) ; $user->setName($us[sfConfig::get('app_profile_var_translation_name')]) ; $user->setSurname($us[sfConfig::get('app_profile_var_translation_surname')]) ; $user->setMail($us[sfConfig::get('app_profile_var_translation_mail')]) ; $user->save(); } $this->logSection('rdvz', "Done.") ; }
public function executeList($request) { $page = $request->getParameter('page', 1); $num = $request->getParameter('num', 20); $q = LsDoctrineQuery::create()->from('UserView v')->leftJoin('v.User u')->orderBy('v.created_at DESC'); $this->constraints = array(); if ($userId = $request->getParameter('user_id')) { $user = Doctrine::getTable('sfGuardUser')->find($userId); $this->constraints[] = 'Limiting to ' . $user->Profile->getFullName(); $q->addWhere('v.user_id = ?', $userId); } if (($model = $request->getParameter('object_model')) && ($id = $request->getParameter('object_id'))) { if ($object = Objectable::getObjectByModelAndId($model, $id, $includeDeleted = true)) { $this->constraints[] = 'Limiting to ' . $object->getName(); } else { $this->constraints[] = 'Limiting to ' . $model . ' ID ' . $id; } $q->addWhere('v.object_model = ? AND v.object_id = ?', array($model, $id)); } if ($start = $request->getParameter('start')) { $start = date('Y-m-d H:i:s', strtotime($start)); $q->addWhere('v.created_at > ?', $start); } if ($end = $request->getParameter('end')) { $end = date('Y-m-d H:i:s', strtotime($end)); $q->addWhere('v.created_at < ?', $end); } $this->view_pager = new LsDoctrinePager($q, $page, $num); }
public function save() { Doctrine::getTable('BlogRssCache')->deleteByMemberId($this->member->getId()); parent::save(); Doctrine::getTable('BlogRssCache')->updateByMemberId($this->member->getId()); return true; }
public static function set($name, $value, $app = null) { if (is_null($app)) { $app = sfConfig::get('sf_app'); } Doctrine::getTable('SnsConfig')->set($app . '_' . $name, $value); }
public function executeIndex(sfWebRequest $request) { if ($request->isMethod('post')){ $from = $request->getParameter('From'); if (!Utils::isEmptyStr($from)){ if (Utils::startsWith($from, "+1")) $from = substr($from, 2); //look up the user by phone number $guardUser = Doctrine::getTable('SfGuardUser')->findOneByPhone($from); if ($guardUser){ //get the last response $response = Doctrine::getTable('BlastResponse')->createQuery()->where('user_id = ?', $guardUser->getId()) ->orderBy('updated_at desc')->fetchOne(); if ($response) { $this->redirect('phoneResponse/intro?responseId=' . $response->getId()); } } } } ?> <Response> <Say>Thanks for calling Make A Minyan dot com. Please visit us online at Make A Minyan dot com. Thank you! Goodbye.</Say> <Hangup /> </Response> <? return sfView::NONE; }
public static function fetchByName($title, $fund, $period, $type, $author, $accountno, $preparedby1, $preparedby2, $certifiedby1, $certifiedby2) { if (!$title) { return; } //remove "page 1" from title $start = strpos($title, " page "); if ($start === false) { $journaltitle = $title; } else { $journaltitle = substr($title, 0, $start); } //search journal with title in database //if not found, create $journal = Doctrine::getTable('Journal')->findOneByName($journaltitle); if (!$journal) { //create one $journal = new Journal(); $journal->setName($journaltitle); $journal->setFundId($fund->getId()); $journal->setPeriodId($period->getId()); $journal->setType($type); $journal->setAuthor($author); $journal->setAccountno($accountno); $journal->setPreparedby1($preparedby1); $journal->setPreparedby2($preparedby2); $journal->setCertifiedby1($certifiedby1); $journal->setCertifiedby2($certifiedby2); $journal->save(); } return $journal; }
public function testTest() { $models1 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models1', Doctrine::MODEL_LOADING_CONSERVATIVE); $models2 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models1', Doctrine::MODEL_LOADING_CONSERVATIVE); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models1'); $models2 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models1'); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models1', Doctrine::MODEL_LOADING_CONSERVATIVE); $models2 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models1', Doctrine::MODEL_LOADING_CONSERVATIVE); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models2', Doctrine::MODEL_LOADING_CONSERVATIVE); $models2 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models2', Doctrine::MODEL_LOADING_CONSERVATIVE); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models2'); $models2 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models2'); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models2', Doctrine::MODEL_LOADING_CONSERVATIVE); $models2 = Doctrine::loadModels(dirname(__FILE__) . '/1727/models2', Doctrine::MODEL_LOADING_CONSERVATIVE); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(array(dirname(__FILE__) . '/1727/models1', dirname(__FILE__) . '/1727/models2')); $models2 = Doctrine::loadModels(array(dirname(__FILE__) . '/1727/models1', dirname(__FILE__) . '/1727/models2')); $this->assertEqual($models1, $models2); $models1 = Doctrine::loadModels(array(dirname(__FILE__) . '/1727/models1', dirname(__FILE__) . '/1727/models2'), Doctrine::MODEL_LOADING_CONSERVATIVE); $models2 = Doctrine::loadModels(array(dirname(__FILE__) . '/1727/models1', dirname(__FILE__) . '/1727/models2'), Doctrine::MODEL_LOADING_CONSERVATIVE); $this->assertEqual($models1, $models2); }
public function testTest() { $sql = Doctrine::generateSqlFromArray(array('Ticket_1923_User')); $this->assertEqual($sql[1], 'CREATE INDEX username_idx ON ticket_1923__user (login)'); $sql = Doctrine::generateSqlFromArray(array('Ticket_1923_User2')); $this->assertEqual($sql[1], 'CREATE INDEX username2_idx ON ticket_1923__user2 (login DESC)'); }
public function save() { $names = array('update_activity'); foreach ($names as $name) { Doctrine::getTable('SnsConfig')->set('op_community_topic_plugin_' . $name, $this->getValue($name)); } }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection(); $table = Doctrine::getTable('sfGuardUser'); $users = $table->createQuery('u')->innerJoin('u.Profile p')->execute(); $first = true; foreach ($users as $user) { if (preg_match("/[^\\w]/", $user->username)) { $user->username = preg_replace("/[^\\w]/", "_", $user->username); while ($table->findOneByUsername($user->username)) { $user->username .= rand(0, 9); echo $user->username; } $user->save(); $profile->save(); if ($first) { echo "The following usernames required change, contact them if they are legitimate users and\nlet them know their new username.\n"; echo "The report below shows the NEW username only.\n\n"; $first = false; } echo "Username: "******"\n"; } $profile = $user->getProfile(); if (preg_match("/[\\<\\>\\&\\|]/", $profile->fullname)) { // No need for a big announcement because we don't log in by our full names $profile->fullname = preg_replace("/[\\<\\>\\&\\|]/", "_", $profile->fullname); $profile->save(); } } }
/** * Маппинг входящих значений к свойствам объекта операции * * @param array $values - исходные значения * @return array - преобразованные значения */ public function processValues($values) { // User // TODO: переделать через один запрос вместе с валидацией $values['user_id'] = Doctrine::getTable('User')->findByUserServiceMail($values['email'])->getFirst()->getId(); unset($values['email']); // Счет для привязки операции # Svel: закомментировал в соответствии с требованиями мягкости в t1713 // $values['account_id'] = Doctrine::getTable('Account')->findLinkedWithSource($values['user_id'], $values['source']); // выбрать ID счета по последней активной операции $values['account_id'] = Doctrine::getTable('Operation')->findAccountIdByLastAcceptedOperationBySource($values['user_id'], $values['source']); // Тип операции и сумма $values['money'] = abs((double) $values['amount']); // Дата и время $values['date'] = date('Y-m-d'); $values['time'] = date('H:i:s'); // Черновик $values['accepted'] = Operation::STATUS_DRAFT; // Источник $values['source_id'] = $values['source']; $values['SourceOperation'] = array('source_uid' => $values['source'], 'source_operation_uid' => $values['id']); // Комментарий $values['comment'] = sprintf("%s %s %s\n", $values['source'], $values['description'], $values['account']); unset($values['description']); unset($values['account']); unset($values['id']); unset($values['source']); return $values; }
public function process() { $configuracao = Doctrine::getTable('Configuracao')->find(1); $this->document->pages[] = $page = $this->document->newPage(\Zend_Pdf_Page::SIZE_A4); //monta o cabecalho $color = array(); $color["black"] = new Zend_Pdf_Color_Html("#000000"); $fontTitle = Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_TIMES_BOLD); $size = 12; $styleTitle = new Zend_Pdf_Style(); $styleTitle->setFont($fontTitle, $size); $styleTitle->setFillColor($color["black"]); $page->setStyle($styleTitle); $page->drawText($configuracao->instituicao, Documento::DOCUMENT_LEFT, Documento::DOCUMENT_TOP, 'UTF-8'); $font = Zend_Pdf_Font::fontWithName(Zend_Pdf_Font::FONT_TIMES); $style = new Zend_Pdf_Style(); $style->setFont($font, $size); $style->setFillColor($color["black"]); $page->setStyle($style); $text = wordwrap($this->text, 95, "\n", false); $token = strtok($text, "\n"); $y = 665; while ($token != false) { if ($y < 100) { $this->document->pages[] = $page = $this->document->newPage(Zend_Pdf_Page::SIZE_A4); $page->setStyle($style); $y = 665; } else { $y -= 15; } $page->drawText($token, 60, $y, 'UTF-8'); $token = strtok("\n"); } }
protected function getTable($modelName) { if (!isset($this->tables[$modelName])) { $this->tables[$modelName] = Doctrine::getTable($modelName); } return $this->tables[$modelName]; }
public function executeDelete(sfWebRequest $request) { $request->checkCSRFProtection(); $this->forward404Unless($jobeet_job = Doctrine::getTable('JobeetJob')->find(array($request->getParameter('id'))), sprintf('Object jobeet_job does not exist (%s).', $request->getParameter('id'))); $jobeet_job->delete(); $this->redirect('job/index'); }