Support

November 8, 2018 at 5:28 am

Hello,

but that may also mean we need to alter something with our queries.

While creating or editing an Event, seems like the program is reading all promotions and prices. This makes the program more slow in time, while promotions are growing in number.

We’ll need to so do some digging into this, may I ask, how are you creating the promotion codes currently?

We have PHP script that make this inserts:
INSERT INTO wp_esp_price (PRT_ID,PRC_amount,PRC_name, PRC_desc, PRC_wp_user, PRC_overrides, PRC_order)
INSERT INTO wp_esp_promotion (PRO_code,PRC_ID,PRO_uses, PRO_accept_msg, PRO_decline_msg, PRO_start, PRO_end, PRO_scope)
INSERT INTO wp_esp_promotion_object (PRO_id, OBJ_id, POB_type, POB_used)

We read from another tables and insert the data as needed in those fields.

All help is appreciated.

Best Regards

November 8, 2018 at 5:58 am

Hello,

are you setting the PRC_is_default to 1 on those rows?

Yep, that field is set to 1 automatically by default. Shall we set the field to 0?

Can you send me the script so I can try and reproduce this locally?

Thats a module, and it adds to WordPress tools (to access when installed: Menu -> tools -> Codigos Masivos)

I paste the code here:

<?php
/*
  Plugin Name: Event Espresso - Códigos Masivos
  Plugin URI: http://www.guiapenin.com/
  Description: Permite crear códigos masivos y asignarlo a eventos.

  Version: 0.1(EE4)

  Author: Event Espresso - Códigos Masivos
  Author URI: http://www.guiapenin.com/

  Copyright (c) 2008-2012 Event Espresso  All Rights Reserved.

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
 */

set_time_limit(500);
ini_set("memory_limit","500M");

function espresso_salones() {
	$wp_plugin_url = WP_PLUGIN_URL;
	$wp_content_url = WP_CONTENT_URL;
	define("ESPRESSO_SALONES_PLUGINPATH", "/" . plugin_basename(dirname(__FILE__)) . "/");
//	define("ESPRESSO_SALONES_PLUGINPATH", WP_PLUGIN_DIR . ESPRESSO_SALONES_PLUGINPATH);
	define("ESPRESSO_SALONES_PLUGINFULLURL", $wp_plugin_url . ESPRESSO_SALONES_PLUGINPATH);
	
?>
    <h3>Codigos Masivos</h3>
    <ul>
        <li>
            <p>Permite crear códigos masivos y asignarlo a eventos.</p>
            <p>Si subes un archivo csv con una columna con nombres de bodegas o colectivos genera códigos a partir de los nombres y pone como descripción el nombre del colectivo o bodega.</p>
            <p>Si introduces un código en el campo "Código:" se genrerara un único código, siempre que no hayas subido un archivo csv</p>
            <p>Si por contra, se deja el campo libre, se tienen en cuenta los campos para la generación automática de códigos</p>
            <p>Si...</p>
           
            <?php
				salones_form( '../wp-content/uploads/espresso/codes' );
            ?>
        </li>
    </ul>
<?php
}

/*
  uploader([int num_uploads [, arr file_types [, int file_size [, str upload_dir ]]]]);
  num_uploads = Number of uploads to handle at once.
  file_types = An array of all the file types you wish to use. The default is txt only.
  file_size = The maximum file size of EACH file. A non-number will results in using the default 1mb filesize.
  upload_dir = The directory to upload to, make sure this ends with a /
 */

function salones_form($download_dir = "../wp-content/uploads/espresso/codes") {
	global $wpdb;

	if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'salones_codes') {
		generar_codes( );
	}
//	if (!isset($_POST["submitted"])) {
        $form = "<form action='admin.php?page=espresso_salones&action=salones_codes' method='post' enctype='multipart/form-data'>
  					<input type='hidden' name='submitted' value='TRUE' id='" . time() . "'>
  					<input name='action' type='hidden' value='salones_codes' />
  					<input type='hidden' name='MAX_FILE_SIZE' value='1048576' />";
        $form .= '
  				<p>
  					<label for="codigos">Subir listado:</label><br/>
  					<input type="file" name="codigos" id="codigos" />
  					<p>
  					    Si subes este archivo se ignorara lo especificado en el campo cantidad, prefijo, sufijo y descripcion.
                        <label for="newcsv">CSV (cod|num cod|desc(opt)):</label><br/>
                        <input type="file" name="newcsv" id="newcsv" />
  					</p>
  				<p>
            		<label for="codigo">Código:</label><br/>
            		<input type="text" id="codigo" name="codigo" value="" size="100" />
	            </p>
	            <p>
	            	<label for="cantidad">Cantidad:</label><br/>
	            	<input type="text" id="cantidad" name="cantidad" value="1" />
	            </p>
	            <p>
	            	<label for="limite">Límite:</label><br/>
	            	<input type="text" id="limite" name="limite" value="1" />
	            </p>
	            <p>
	            	<label for="precio">Precio:</label><br/>
	            	<input type="text" id="precio" name="precio" value="1" />
	            </p>
	            <p>
	            	¿Es un porcentaje?<br/>
	            	<input type="radio" id="porcentajeY" name="porcentaje" value="2" />
	            	<label for="porcentajeY">Sí</label>
	            	<input type="radio" id="porcentajeN" name="porcentaje" value="1" />
	            	<label for="porcentajeN">No</label>
	            </p>
	            <p>
	            	<label for="prefijo">Prefijo:</label><br/>
	            	<input type="text" id="prefijo" name="prefijo" value="" />
	            </p>
	            <p>
	            	<label for="sufijo">Sufijo:</label><br/>
	            	<input type="text" id="sufijo" name="sufijo" value="" />
	            </p>
	            <p>
	            	<label for="descripcion">Descripción:</label><br/>
	            	<input type="text" id="descripcion" name="descripcion" value="" size="100" />
	            </p>';
        //metemos los eventos Comprobar la tabla
		$sql = "SELECT e.EVT_ID, e.DTT_name ";
        $sql .= " FROM wp_esp_datetime e WHERE DATE(DTT_EVT_end) >= DATE(NOW())  ORDER BY e.DTT_name";
		$events = $wpdb->get_results( $wpdb->prepare($sql, ''));
        if (count($events) > 0) {
	        $form .= '<p>Eventos: <br/>';
			$eventosGuardados = array();
	        foreach ($events as $event) {
				$repetido = false;
				if(count($eventosGuardados) > 0){
					foreach($eventosGuardados as $eventoGuardado){
						if($eventoGuardado->EVT_ID == $event->EVT_ID){
							$repetido = true;
						}
					}
				}
				
				if(!$repetido){
					$form .= '<input type="checkbox" name="eventos[]" id="evento_'.$event->EVT_ID.'" value="'.$event->EVT_ID.'" /> ';
					$form .= '<label for="evento_'.$event->EVT_ID.'">'.$event->DTT_name.'</label><br/>';
				}
				
				array_push($eventosGuardados,$event);
	        }
	        $form .= '</p>';
        }
        $form .= "<input class='button-primary' type='submit' value='Generar'></p></form>";
        echo($form);
        
        //Ahora imprimimos los archivos
        $codes = scandir($download_dir);
        rsort($codes);
        $files = '<br/><br/><strong>Archivos de Códigos:</strong><br/>';
        $f = false;
        foreach($codes as $code) {
        	if ($code != '.' && $code != '..' && strpos($code, 'codes-') !== false && strpos($code, '.txt') !== false ) {
        		$files .= '<a href="'.get_site_url().str_replace('..','',$download_dir).'/'.$code.'" target="_blank" >'.$code.'</a><br/>';
        		$f = true;
        	}
        }
        if ($f) {
        	echo $files;
        }
        	

}

function generar_codes() {
    global $wpdb;
    
    /**
     * Este generará X número de códigos únicos y creará los insert, tanto para los códigos como para su relación con el evento.
     * Los campos a rellenas son los siguientes y son indispensables para que todo funcione y sean únicos.
     */
	 function limpiar($s) {
    	$vocalti= array ("á","é","í","ó","ú","Á","É","Í","Ó","Ú");
    	$vocales= array ("a","e","i","o","u","A","E","I","O","U");
    	$s = str_replace($vocalti, $vocales, $s);
    	$s = str_replace("ñ","n",$s);
    	$s = str_replace("Ñ","N",$s);
    	$s = preg_replace("/[^a-zA-Z0-9]+/", "", $s);
    	return $s;
    }
	
    if(trim($_POST["codigo"]) != ""){
    	$codigo = limpiar($_POST["codigo"]);
    }
    $cantidad 	= $_POST["cantidad"]; //número de códigos a generar
    $limite 	= $_POST["limite"]; //número de usuos para cada código, si tienen que ser de un sólo uso 1, si tienen que ser ilimitados 0
    $precio 	= $_POST["precio"]; //precio de cada cupón descontado o porcentaje
    $porcentaje = $_POST["porcentaje"]; //porcentaje o precio Y o N
    $wp_user	= 2; //usuario que lo genera, 1 para admin
    $sufix		= $_POST["sufijo"]; //sufijo del código para que sea único
    $prefix		= $_POST["prefijo"]; //prefijo del código para que sea único
    $description= $_POST["descripcion"]; //descripción del código para su identificación.
    $eventos	= $_POST["eventos"]; //id de los eventos a los que asignar los códigos
    $codigos    = $_FILES["codigos"]; //archivo cvs de nombres para generar códigos
    $newcsv     = $_FILES['newcsv']; //archivo csv con orden -> codigo|numero de codigos a generar

    if ($porcentaje == '') {
    	$porcentaje = 1;
    }
    
    
    
    function codigo($length = 5, $prefix = '', $sufix = '') {
    	static $chars = '123456789ABCDEFGHJKLMNPQRSTWXYZ';
    	$max = strlen($chars) - 1;
    	$token = '';
    	for ($i = 0; $i < $length; ++$i)
    	{
    		$token .= $chars[(rand(0, $max))];
    	}
    
    	return $prefix . $token . $sufix;
    }
    $exportar_desc = false;
    $descriciones = array();
    if ($codigos['error'] == 0) {
    	if (($gestor = fopen($codigos["tmp_name"], "r")) !== FALSE) {
    		if ($cantidad > 0) {
    			$exportar_desc = true;
    			$codigos = array();
    			while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
    				$title = ucwords(str_replace(' s.l.', '', strtolower(($datos[0]))));
    				$title = str_replace("'", " ", $title);
    				for ($i = 1; $i <= $cantidad; $i++) {
    					do {
    						$codigo = codigo(5,$prefix,$sufix);
    					} while (isset($codigos[$codigo]) && es_valido($codigo));
    					 
    					$codigos[$codigo] = $codigo;
    					$descriciones[$codigo] = $title;
    				}
    			}
    		}
    		fclose($gestor);
    	}
    } else {
        //Entra aqui si se a subido un CSV al nuevo campo $newcsv
        if ($newcsv['error'] == 0) {
            if (($gestor = fopen($newcsv["tmp_name"], "r")) !== FALSE) {
                $exportar_desc = true;
                $codigos = array();
                while (($datos = fgetcsv($gestor, 1000, ",")) !== FALSE) {
                    if(isset($datos[2]) && $datos[2] != ""){
                        $title = $datos[2];
                    }else{
                        $title = '';
                    }

                    $prefixcode = $datos[0];
                    $cantidad = intval($datos[1]);
                    for ($i = 1; $i <= $cantidad; $i++) {
                        do {
                            $codigo = codigo(5,$prefixcode,'');
                        } while (isset($codigos[$codigo]) && es_valido($codigo));

                        $codigos[$codigo] = $codigo;
                        $descriciones[$codigo] = $title;
                    }
                }
            }
        }else{
            $codigos = array();
        }
    }

    if (empty($codigos)) {
	    if(isset($codigo) && es_valido($codigo)){
	    	 $codigos[$codigo] = $codigo;
	    } else {
		    for ($i = 1; $i <= $cantidad; $i++) {
		    	do {
		    		$codigo = codigo(5,$prefix,$sufix);
		    	} while (isset($codigos[$codigo]) && es_valido($codigo));
		    	
		    	$codigos[$codigo] = $codigo;
		    }
		}
    }
	
	
    foreach ($codigos as $codigo) {
    	if (empty($description)) {
    		$description = $descriciones[$codigo];
    	}
		
		$sql  = "INSERT INTO wp_esp_price";
		$sql .= ' (<code>PRT_ID</code>,<code>PRC_amount</code>,<code>PRC_name</code>, <code>PRC_desc</code>, <code>PRC_wp_user</code>, <code>PRC_overrides</code>, <code>PRC_order</code>) VALUES ';
		$sql .= "($porcentaje, $precio, '$description', '$description', $wp_user, 0, 1);";
		$result = $wpdb->query($sql);
		$price_id = $wpdb->insert_id;
		if(isset($eventos)){
			foreach($eventos as $evento){
			$sql = "SELECT DTT_EVT_start, DTT_EVT_end FROM wp_esp_datetime WHERE EVT_ID = ".$evento;
			$dates = $wpdb->get_results( $wpdb->prepare($sql, ''));
			$endDate = strtotime($dates[0]->DTT_EVT_end);
			
			$sql = "SELECT EVT_visible_on FROM wp_esp_event_meta WHERE EVT_ID = ".$evento;
			$date =  $wpdb->get_results( $wpdb->prepare($sql, ''));
			$startDate = strtotime($date[0]->EVT_visible_on);
			
			$sql  = "INSERT INTO wp_esp_promotion";
			$sql .= '(<code>PRO_code</code>,<code>PRC_ID</code>,<code>PRO_uses</code>, <code>PRO_accept_msg</code>, <code>PRO_decline_msg</code>, <code>PRO_start</code>, <code>PRO_end</code>, <code>PRO_scope</code>) VALUES ';
			$sql .= "('$codigo', $price_id, $limite, 'Aceptado', 'Rechazado', FROM_UNIXTIME($startDate), FROM_UNIXTIME($endDate), 'Event');";
			$wpdb->query($sql);
			$discount_id = $wpdb->insert_id;
			
			$sql = "INSERT INTO wp_esp_promotion_object (<code>PRO_id</code>, <code>OBJ_id</code>, <code>POB_type</code>, <code>POB_used</code>) VALUES ($discount_id, $evento, 'Event', 0);";
			$wpdb->query($sql);
			
			}
		}else{
			echo "<script>alert('Debes seleccionar al menos un evento.')";
		}
		
    }
	
    if ($exportar_desc) {
		exportar_codigos($codigos,$descriciones);
	} else {
    	exportar_codigos($codigos);
    }
    espresso_display_salones_messages( 'Generación de códigos finalizada.' );
}

function exportar_codigos($codes = array(), $desc = array(), $download_dir = "../wp-content/uploads/espresso/codes"){
	if (!file_exists($download_dir)) {
		mkdir($download_dir, 0777, true);
	}
	if(count($desc) > 0) {
		$codes = array();
		foreach ($desc as $c => $d) {
			$codes[$c] = $c."\t".$d;
		}
	} 
	
	file_put_contents($download_dir.'/codes-'.date("Y-m-d-H-i").".txt", implode("\n", $codes));
}

function es_valido($code){
	global $wpdb;
	$sql = "SELECT count(*) ";
	$sql .= " FROM wp_esp_promotion e WHERE e.PRO_code = '".$code."'";
	$codes = $wpdb->get_var( $wpdb->prepare($sql, ''));
	if($codes == 0) {
		return true;
	}
	return false;
}

function espresso_display_salones_messages( $success_messages = '', $error_messages = '' ) {
	if ($success_messages != '') {
		//showMessage( $success_messages );
		echo '<div id="message1" class="updated fade"><p>' . $success_messages . '</p></div>';
	}

	if ($error_messages != '') {
		//showMessage( $error_messages, TRUE );
		echo '<div id="message2" class="error fade fade-away"><p>' . $error_messages . '</p></div>';
	}	
}
add_action( 'admin_menu', 'espresso_salones_add_page' );

function espresso_salones_add_page() {
	$default_role = 'administrator';
	add_submenu_page('tools.php', 'Códigos Masivos', 'Códigos Masivos', $default_role, 'espresso_salones', 'espresso_salones');
}

November 8, 2018 at 9:30 am

Hello Tony,

Thanks for all, it was really helpfull.

Yes, set that field to 0.

We have already made the change and it finally works fine. Thanks so much!

Side note, is there any reason your not using our models to create these objects?

We didn’t really noticed that it exists. We will consider update our code for using your model system as u mentioned above to create codes. Thanks for suggestion!!

Best regards