コード例 #1
0
 /** @param PDOStatement $query_result */
 private function treat_success($query_result)
 {
     if ($query_result->rowCount() > 0) {
         (new Delete_invitation(array('id' => parent::get_input('id_invitation'))))->run();
     } else {
         TTransaction::rollback();
     }
 }
コード例 #2
0
 /** @param PDOStatement $query_result */
 private function treat_success($query_result)
 {
     $result_array = array();
     while ($query_obj = $query_result->fetchObject()) {
         $result_array[] = $query_obj;
     }
     parent::set_result('result_array', $result_array);
 }
コード例 #3
0
 /**
  * @param PDOStatement $query_result
  */
 private function treat_success($query_result)
 {
     if ($query_result->rowCount() > 1) {
         parent::set_error(1, "Mais de um item foi removido, assim, a remoção foi cancelada.");
         TTransaction::rollback();
     } elseif ($query_result->rowCount() == 0) {
         parent::set_error(1, "Nenhum item foi removido.");
     }
 }
コード例 #4
0
 /** @param PDOStatement $query_result */
 private function treat_success($query_result)
 {
     if ($query_result->rowCount() > 0 && TSession::try_get_value('id_user', $id_user)) {
         (new Insert_user_event(array('id_user' => $id_user, 'id_event' => TTransaction::get_last_inserted_id())))->run();
     } else {
         parent::set_error(102);
         TTransaction::rollback();
     }
 }
コード例 #5
0
 public function action()
 {
     $attrs_cond = array('id');
     $sql = TTransaction::get_delete_query('event', $attrs_cond);
     // Parâmetros em ordem de aparição da query
     $query_values = parent::get_input_values($attrs_cond);
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result === false) {
         parent::set_error(101);
         TTransaction::rollback();
     }
     return parent::get_result();
 }
コード例 #6
0
 public function action()
 {
     $attrs = array('id_user', 'id_dummy');
     $sql = TTransaction::get_insert_query('user_dummy', $attrs);
     // Parâmetros em ordem de aparição da query
     $query_values = parent::get_input_values($attrs);
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result === false) {
         parent::set_error(101);
         TTransaction::rollback();
     }
     return parent::get_result();
 }
コード例 #7
0
 public function action()
 {
     $attrs = array('name', 'username', 'email', 'password');
     $attrs_cond = array('id');
     $sql = TTransaction::get_update_query('user', $attrs, $attrs_cond);
     // Parâmetros em ordem de aparição da query
     $query_values = parent::get_input_values(array_merge($attrs, $attrs_cond));
     $query_values[3] = sha1($query_values[3]);
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result === false) {
         parent::set_error(101);
         TTransaction::rollback();
     }
     return parent::get_result();
 }
コード例 #8
0
 public function action()
 {
     $attrs = array('id_event', 'id_transaction');
     $sql = TTransaction::get_insert_query('event_transaction', $attrs);
     // Parâmetros em ordem de aparição da query
     $query_values = parent::get_input_values($attrs);
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result !== false) {
         // Sucesso!
         TTransaction::close();
     } else {
         parent::set_error(101);
         TTransaction::rollback();
     }
     return parent::get_result();
 }
コード例 #9
0
ファイル: base.class.php プロジェクト: thalelinh/MoneyManager
 public function action()
 {
     $attrs = array();
     $attrs_cond = array();
     $sql = TTransaction::get_update_query('table', $attrs, $attrs_cond);
     // Parâmetros em ordem de aparição da query
     $query_values = parent::get_input_values(array_merge($attrs, $attrs_cond));
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result === false) {
         parent::set_error(101);
         TTransaction::rollback();
     } else {
         //$this->treat_success($query_result);
     }
     return parent::get_result();
 }
コード例 #10
0
 private function check_email()
 {
     $attrs = array('1 AS result');
     $attrs_cond = array('email');
     $sql = TTransaction::get_select_query('user', $attrs, $attrs_cond);
     // Parâmetros em ordem de aparição da query
     $query_values = parent::get_input_values($attrs_cond);
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result === false) {
         parent::set_error(101);
     } else {
         if ($result_obj = $query_result->fetchObject()) {
             parent::set_error(1062, 'Já existe um usuário com esse email.');
         } else {
             return true;
         }
     }
     return false;
 }
コード例 #11
0
 /** Checa se o usuário conectado foi convidado por quem ele deseja convidar. Caso positivo, é executado como se
  * tivesse aceitado a solicitação. */
 private function check_invitation()
 {
     $attrs = array('id');
     $attrs_cond = array('id_user1', 'id_user2');
     $sql = TTransaction::get_select_query('invitation', $attrs, $attrs_cond);
     // Parâmetros em ordem de aparição da query
     $query_values = array(parent::get_input('id_user2'), $this->connected);
     // Resultado da query
     $query_result = TTransaction::safe_execute($sql, $query_values);
     if ($query_result === false) {
         parent::set_error(101);
         TTransaction::rollback();
     } else {
         if ($query_obj = $query_result->fetchObject()) {
             (new Insert_user_user(array('id_user1' => parent::get_input('id_user2'), 'id_invitation' => $query_obj->id)))->run();
             return true;
         }
     }
     return false;
 }
コード例 #12
0
 public function action()
 {
     parent::get_input('mailTo');
     //SMTP needs accurate times, and the PHP time zone MUST be set
     //This should be done in your php.ini, but this is how to do it if you don't have access to that
     date_default_timezone_set('Etc/UTC');
     //Create a new PHPMailer instance
     $mail = new PHPMailer();
     $this->setupDebug($mail);
     //$mail->isMail();
     //$this->setupSendMail($mail);
     $this->setupSMTP($mail);
     //Set who the message is to be sent from
     $mail->setFrom(parent::get_input('from_mail'), parent::get_input('from_name'));
     //Set who the message is to be sent to
     $mail->addAddress(parent::get_input('to_mail'), parent::get_input('to_name'));
     //Set an alternative reply-to address
     $mail->addReplyTo(parent::get_input('reply_mail'), parent::get_input('reply_name'));
     //Set the subject line
     $mail->Subject = parent::get_input('subject');
     //Read an HTML message body from an external file, convert referenced images to embedded,
     //convert HTML into a basic plain-text alternative body
     $mail->msgHTML(parent::get_input('body'));
     //Replace the plain text body with one created manually
     $mail->AltBody = parent::get_input('alt_body');
     //Attach an image file
     //$mail->addAttachment('images/phpmailer_mini.gif');
     //send the message, check for errors
     if (!$mail->send()) {
         TTransaction::log($mail->ErrorInfo);
         parent::set_error(1, "Mensagem não enviada!");
     } else {
         parent::set_result('Enviado', date('d.m.Y H:i:sy'));
     }
     return parent::get_result();
 }
コード例 #13
0
 public function action()
 {
     TSession::free_session();
     return parent::get_result();
 }
コード例 #14
0
 public function action()
 {
     parent::set_result('methods', $this->prepare());
     return parent::get_result();
 }
コード例 #15
0
 private function get_login_type()
 {
     return strpos(parent::get_input('login'), '@') === false ? 'username' : 'email';
 }
コード例 #16
0
	public function __construct(){
		parent::__construct();
		$this->transactionDao = new BaseDao("ETransaction");
	}