Home / user-112842

Pag's questions

Martin Hope
Pag
Asked: 2020-07-08 05:07:34 +0800 CST
  • -1

I would like to know if you could give me a hand with a point that I have been stuck for a few days. The thing is that he wants the application which I am improving to have a history of changes, that is, if in the name field there was "Pepe" before and it is changed to "Pepe 2" in a table (which I already have created) I save the person who modified it, the date, time and the Previous Value and Current Value fields

change history table

Every time a change is made in the application in this tab:

enter image description here

The date, username and the person who has been modified and the changes that were made must be saved in this other

enter image description here

The application is developed in php with the Codeigniter Framework, if you have any ideas, it will be well received.

Thank you so much!!!

php
Martin Hope
Pag
Asked: 2020-04-02 23:53:45 +0800 CST
  • 0

Hello, I am making an application with CodeIgniter, which is a form that collects the data and inserts it into the database. What the client asks for is to check that the emails are not repeated, that is, that they are not saved, but that a message appears message that this email is already registered, I'm trying to do it by means of a callback in form validation $this->form_validation->set_rules('email','email','required|valid_email','callback_email'); I leave you the code that I try to do, both for the controller and the model.

controller

    public function email($data){
        $validation= $this->model->validar_mail($data);
        if($validation > 0){
//            $this->form_validation->set_message('mails','Se deben aceptar los términos y condiciones');
            return false;
        }else{
            return true;
            }
    }

model

    public function validar_mail($mail){
        $correo="select count(*) as numero from cliente where email = $mail";
        return $this->db->query($correo)->row()->numero;
    }

Fixed code:

driver:

<!-- Validation donde llama al la función del callback -->
$this->form_validation->set_rules('email','email','required|valid_email|callback_verifica');

<!--Funcion del callback -->
public function verifica($mail){
        if($this->empleado_model->existe_mail($mail)){
            $this->form_validation->set_message('verifica','El email introducido ya esta registrado');
            return false;
        }else{

            return true;
        }
    }

Model:

    public function existe_mail($mail){
        $this->db->select('email');
        $this->db->from('cliente');
        $this->db->where('email', $mail);
        $result = $this->db->get('');

        if (!$result->num_rows() == 1) {
            return false;
        }else{
            return true;
        }
    }

mysql
Martin Hope
Pag
Asked: 2020-03-29 05:19:37 +0800 CST
  • 1

Hello, I would like to know how I can give the email a cell format with the codeigniter email library.

I leave you the code of the controller that in the post the body of the mail.

<?php
if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Cronjob_send_email extends CI_Controller {

    const NOMBRE_FICHERO = "Resumen_Registro";
    const ASUNTO_MAIL = "Resumen de registros";
    const TEXTO_MAIL = "Se han realizado<br> <br> en el hotel {nombreHotel}<br><br> con fecha de hoy.";

    public function __construct(){
        parent::__construct();

        $this->load->model('empleado_model');
        $this->load->model('parametros_model');
    }
    public function index(){
        $this->envioMail();
    }

    public function envioMail(){

        $registroBcn = $this->empleado_model->getBarcelona();
        $registroMlg = $this->empleado_model->getMalaga();
        $registroMallorca = $this->empleado_model->getMallorca();

        $textoEnvio = '<html>
            <head>
            <title>Resumen de registros por hotel</title>
            </head>
                <body>
                <h3>Resumen de registros por hotel</h3>
                    <p style="text-align: justify">Se adjunta recuento de registros por Hotel</p>
                <table>
                    <tr style="padding:15px; text-align: center;" >
                        <th>Barcelona</th><span></span>
                        <th>M&aacutelaga</th><span></span>
                        <th>Mallorca</th><span></span>
                    </tr>
                    <tr style="padding: 15px; text-align: center;">
                        <td> '.$registroBcn.' </td>
                        <td> '.$registroMlg.' </td>
                        <td> '.$registroMallorca.' </td>
                    </tr>
                </table>
                </body>
                </html>';
//        $textoEnvio = "Adjuntamos recuento de los registros de ayer<br><br>- Barcelona: ".$registroBcn."<br><br>- Málaga";
        $this->load->library('email');
        $config = Array(
            'protocol' => 'smtp',
            'smtp_host' => 'in-v3.mailjet.com',
            'smtp_port' => 587,
            'smtp_user' => '379227d6e1fc18db44209b7e264d8186', // change it to yours
            'smtp_pass' => 'b65e8f015ba7e44ce8d585f812aefb89', // change it to yours
            //'smtp_timeout'=>20,
            'mailtype' => 'html',
            'charset' => 'iso-8859-1',
            'wordwrap' => TRUE
        );
//        $dest = '[email protected]';
//        $from = '[email protected]';
        $dest= $this->parametros_model->get_parametros('destinatario');
        $from=  $this->parametros_model->get_parametros('from');
        $this->email->initialize($config);

        $this->email->from($from);
        $this->email->to($dest);
        $this->email->cc ('[email protected],[email protected],[email protected]');
//        $copiauno= "[email protected]";
//        $copiados= "[email protected]";
//        $copiados= "[email protected]";
//        $this->email->cc ($copiauno.','.$coipados.','.$copiatres);
        $this->email->subject("Recuento de registros diario");
        $this->email->message($textoEnvio);
        //$this->email->send();
        if($this->email->send()){
            echo 'si lo envia '.$from." - ".$dest;
        }
        echo $this->email->print_debugger();





//        /*
//         * Cuando cargamos una librería
//         * es similar a hacer en PHP puro esto:
//         * require_once("libreria.php");
//         * $lib=new Libreria();
//         */
//
//        //Cargamos la librería email
//        $this->load->library('email');
//
//        /*
//         * Configuramos los parámetros para enviar el email,
//         * las siguientes configuraciones es recomendable
//         * hacerlas en el fichero email.php dentro del directorio config,
//         * en este caso para hacer un ejemplo rápido lo hacemos
//         * en el propio controlador
//         */
//
//        //Indicamos el protocolo a utilizar
//        $config['protocol'] = 'imap';
//
//        //El servidor de correo que utilizaremos
//        $config["smtp_host"] = 'imap.gmail.com';
//
//        //Nuestro usuario
//        $config["smtp_user"] = '[email protected]';
//
//        //Nuestra contraseña
//        $config["smtp_pass"] = 'joaoymichu2';
//
//        //El puerto que utilizará el servidor smtp
//        $config["smtp_port"] = '993';
//
//        //El juego de caracteres a utilizar
//        $config['charset'] = 'utf-8';
//
//        //Permitimos que se puedan cortar palabras
//        $config['wordwrap'] = TRUE;
//
//        //El email debe ser valido
//        $config['validate'] = true;
//
//
//        //Establecemos esta configuración
//        $this->email->initialize($config);
//
//        //Ponemos la dirección de correo que enviará el email y un nombre
//        $this->email->from('[email protected]', 'Oscar');
//
//        /*
//         * Ponemos el o los destinatarios para los que va el email
//         * en este caso al ser un formulario de contacto te lo enviarás a ti
//         * mismo
//         */
//        $this->email->to('[email protected]');
//        $this->email->cc ( '[email protected]' );
//
//        //Definimos el asunto del mensaje
//        $this->email->subject("Mi asunto");
//
//        //Definimos el mensaje a enviar
//        $this->email->message("Mi mensaje");
//
//        //Enviamos el email y si se produce bien o mal que avise con una flasdata
//        if($this->email->send()){
//            echo 'si';
//        }else{
//            echo 'no';
//        }

        //redirect(base_url("contacto"));
    }



//    public function envioMail(){
//        $this->email->from ( '[email protected] ' ,  'Joao' );
//        $this->email->to ( ' [email protected] ' );
//        $this->email->cc ( '[email protected]' );
//        $this->email->bcc ( '' );
//
//        $this->email->subject ( 'Test de correo electrónico' );
//        $this->email->message ( 'Probando la clase de correo electrónico' );
//
//        $this->email->send ();
//    }

}

This is how the mail currently looks, what I would like is to put the cell borders, I have tried to put the style itself in the label but it does not change it

I would appreciate your help.

enter image description here

codeigniter
Martin Hope
Pag
Asked: 2020-01-04 06:31:58 +0800 CST
  • 0

I would like to know how to Codeigniterchange the state of the activate button so that it is green, when it is deactivated it is red, but when I activate it it is green.

Controller code:

if ($activos =='true'){
    $actinomtest ='Activar';
    $valoresacti ='1';
    $colorbtn = 'class="btn btn success';
}else{
    $actinomtest ='Desactivar';
    $valoresacti ='0';
}

And in this line within the same Controller called those variables:

foreach ($data as $row){
        $botones='<button class="btn btn-primary btn-sm btnedit text-center" onclick="botontest('.$row->idTest.')">Editar</button>
                  <a class="btn btn-warning" href="#">Editar tabla</a>
                  <button class="btn btn-danger btn-sm btnactest text-center" onclick="btnactivtest('.$row->idTest.', '. $valoresacti.', '.$colorbtn .')">'.$actinomtest.'</button>';
}
codeigniter