lunedì 21 febbraio 2011

Prestashop - Eliminare gli ordini dal BO

cambiare la chiamata di vieworder con deleteorder

es:

http://dominio.com/adminindex.php?tab=AdminOrders&id_order=1&vieworder;&token;=f62930bu9214d96112339×567c0e9kq


to

http://dominio.com/adminindex.php?tab=AdminOrders&id_order=1&deleteorder;&token;=f62930bu9214d96112339×567c0e9kq

fonte:
http://www.prestashop.com/forums/viewthread/8994/

Prestashop - Eliminare i dati test per portare online

TRUNCATE TABLE ps_customer;
TRUNCATE TABLE ps_customer_group;
TRUNCATE TABLE ps_address;
TRUNCATE TABLE ps_orders;
TRUNCATE TABLE ps_order_detail;
TRUNCATE TABLE ps_order_discount;
TRUNCATE TABLE ps_order_history;
TRUNCATE TABLE ps_message;
TRUNCATE TABLE ps_cart;
TRUNCATE TABLE ps_cart_product;
TRUNCATE TABLE ps_cart_discount;
ALTER TABLE ps_customer AUTO_INCREMENT = 0;
ALTER TABLE ps_address AUTO_INCREMENT = 0;
ALTER TABLE ps_orders AUTO_INCREMENT = 0;
ALTER TABLE ps_order_detail AUTO_INCREMENT = 0;
ALTER TABLE ps_order_discount AUTO_INCREMENT = 0;
ALTER TABLE ps_order_history AUTO_INCREMENT = 0;
ALTER TABLE ps_message AUTO_INCREMENT = 0;
ALTER TABLE ps_cart AUTO_INCREMENT = 0;
ALTER TABLE ps_cart_product AUTO_INCREMENT = 0;
ALTER TABLE ps_cart_discount AUTO_INCREMENT = 0;



ps
truncate = delete from

fonte: http://www.prestashop.com/forums/viewthread/9045/installation_configuration___upgrade/solved_how_to_reset_or_delete_all_orders_and_customers

martedì 8 febbraio 2011

Sql uso di if/case nelle query

 select (case when replace(business,',','')='si' then '2' when replace(business,',','')='no' then '1' else '1'end) from cliente where status='abilitato';

mercoledì 2 febbraio 2011

Prestashop - Selezione in fase di registrazione del gruppo di appartenenza

Devo usare prestashop in versione italiana con c.f., p.iva e privacy:

/themes/prestashop/autentication.tpl

<p class="radio required">
<span>{l s='group'}</span>
<input type="radio" name="group" id="group1" value="2"
<label for="group1" class="top">{l s='Business'}</label>
<input type="radio" name="group" id="group2" value="3"/>
<label for="group2" class="top">{l s='Privato'}</label>
</p>

/autentication.php recupero il dato via post


$customer->id_default_group = (empty($_POST['group']) ? 1 : intval($_POST['group']));

nella funziona add di classes/Customers.php

//if ($this->id_default_group == 1)
// $row = array('id_customer' => intval($this->id), 'id_group' => 1);
if ($this->id_default_group)
$row = array('id_customer' => intval($this->id), 'id_group' =>$this->id_default_group);
else
$row = array('id_customer' => intval($this->id), 'id_group' => 1);

return Db::getInstance()->AutoExecute(_DB_PREFIX_.'customer_group', $row, 'INSERT');

versione 1.3.6.0 – 0.306s - presa da http://www.prestamodules.com/prestashop/1-Prestashop-Italia.html


riferimento ad articolo sul blog http://www.prestashop.com/forums/viewthread/89794/