PHP Doctrine::getTable方法代码示例

 public function setup()
 {
     parent::setup();
     $user = self::getValidUser();
     unset($this['updated_at']);
     $this->widgetSchema->setHelps(array('slug' => 'The field is not required', 'excerpt' => 'The field is not required'));
     $this->widgetSchema->moveField('slug', sfWidgetFormSchema::AFTER, 'title');
     $this->widgetSchema['content'] = new sfWidgetFormCKEditor(array('jsoptions' => array('customConfig' => '/js/ckeditor/config.js', 'filebrowserBrowseUrl' => '/js/filemanager/index.html', 'filebrowserImageBrowseUrl' => '/js/filemanager/index.html?type=Images')));
     $this->widgetSchema['status'] = new sfWidgetFormChoice(array('choices' => Doctrine::getTable('PeanutPosts')->getStatus(), 'expanded' => false));
     if (!$this->isNew()) {
         $this->widgetSchema['created_at'] = new sfWidgetFormI18nDate(array('culture' => $user->getCulture()));
     } else {
         unset($this['created_at']);
     }
     /**
      * Add tags for peanutPostsForm
      * 
      * @author http://n8v.enteuxis.org/2010/05/adding-wordpress-like-tags-to-a-symfony-1-4-admin-generator-form/
      *
      */
     $default = 'Add tags with commas';
     $this->widgetSchema['new_tags'] = new sfWidgetFormInput(array('default' => $default), array('onclick' => "if(this.value=='{$default}') { this.value = ''; this.style.color='black'; }", 'size' => '32', 'id' => 'new_tags', 'autocomplete' => 'off', 'style' => 'color: #aaa;'));
     $this->setValidator('new_tags', new sfValidatorString(array('required' => false)));
     $this->widgetSchema['remove_tags'] = new sfWidgetFormInputHidden();
     $this->setValidator('remove_tags', new sfValidatorString(array('required' => false)));
 }

 public function save()
 {
     $names = array('update_activity');
     foreach ($names as $name) {
         Doctrine::getTable('SnsConfig')->set('op_community_topic_plugin_' . $name, $this->getValue($name));
     }
 }

 /**
  * Маппинг входящих значений к свойствам объекта операции
  *
  * @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;
 }

 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)");
 }

 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()");
     }
 }

 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();
 }

 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');
 }

 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));
 }

 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&eacute;nero      : " . $sexo . "<br/>";
                     $html .= "Nacionalidad: " . $employee->getNationality() . "<br/>";
                     $html .= "M&oacute;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 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');
 }

 /**
  * @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)
 {
     $this->forward404Unless($mensagem = Doctrine::getTable('Mensagem')->find(array($request->getParameter('id'))), sprintf('Object mensagem does not exist (%s).', $request->getParameter('id')));
     $mensagem->delete();
     $this->getUser()->setFlash('success', 'Mensagem excluída com sucesso!');
     $this->redirect('@mensagens');
 }

 public function executeSave(sfWebRequest $request)
 {
     $request->checkCSRFProtection();
     $invoices = (array) $request->getParameter('invoices', array());
     $estimates = (array) $request->getParameter('estimates', array());
     // check that there is only one template for each one
     if (count($invoices) > 1 || count($estimates) > 1) {
         $this->getUser()->error($this->getContext()->getI18N()->__('There must be only one template for model.'));
         $this->redirect('@templates');
     }
     $templates = Doctrine::getTable('Template')->createQuery()->execute();
     foreach ($templates as $t) {
         $models = array();
         if (in_array($t->getId(), $invoices)) {
             $models[] = 'Invoice';
         }
         if (in_array($t->getId(), $estimates)) {
             $models[] = 'Estimate';
         }
         $t->setModels(implode(',', $models));
         $t->save();
     }
     $this->getUser()->info($this->getContext()->getI18N()->__('Successfully saved.'));
     $this->redirect('@templates');
 }

 public function eliminar($cuenta_id)
 {
     $cuenta = Doctrine::getTable('Cuenta')->find($cuenta_id);
     $cuenta->delete();
     $this->session->set_flashdata('message', 'Cuenta eliminada con éxito.');
     redirect('manager/cuentas');
 }

 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: " . $user->username . ' Fullname: ' . $user->Profile->fullname . ' Email: ' . $user->getEmailAddress() . "\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();
         }
     }
 }