DROP TRIGGER `f_inventory_after_upd_tr`//
CREATE TRIGGER `phreebooks`.`f_inventory_after_upd_tr`
AFTER UPDATE
ON `f_inventory` FOR EACH ROW
BEGIN
     IF EXISTS (SELECT * FROM phreebooks.lock_table WHERE lock_trigger1=0)
     THEN
         UPDATE phreebooks.lock_table SET lock_trigger1=1;
         IF EXISTS (SELECT * FROM print.ps_product_attribute ppa WHERE ppa.reference=new.sku)
         THEN

#==================  hooktook@gmail.com ====================#
				IF EXISTS (select id_product from print.ps_product_attribute ppa
    			where ppa.default_on=1 AND ppa.reference=new.sku)
				THEN

				CREATE TEMPORARY TABLE print.temp_id_product
				select id_product from print.ps_product_attribute ppa
				where ppa.default_on=1 AND ppa.reference=new.sku;

update print.ps_product_attribute ppa
set ppa.price = 0,
ppa.wholesale_price  = new.item_cost
where ppa.reference=new.sku
and ppa.id_product in (select id_product from print.temp_id_product);


update print.ps_product ppp
set ppp.price = new.full_price,
ppp.wholesale_price = new.item_cost
where ppp.id_product in (select id_product from print.temp_id_product)
and new.sku IN (select reference from print.ps_product_attribute ppa where ppa.default_on=1);

update print.ps_product_attribute ppa
set ppa.price = ppa.price + (OLD.full_price-NEW.full_price)
WHERE ppa.default_on=0 AND ppa.id_product in (select id_product from print.temp_id_product);

ELSE
#==================  hooktook@gmail.com ====================#
                            SET @Price=(SELECT price
                              FROM print.ps_product WHERE id_product in (SELECT id_product FROM print.ps_product_attribute ppa WHERE ppa.reference=new.sku));

             UPDATE print.ps_product_attribute ppa
             SET ppa.price=new.full_price-@Price, ppa.wholesale_price=new.item_cost
             WHERE (ppa.reference=new.sku);

#==================  hooktook@gmail.com ====================#
END IF;
#==================  hooktook@gmail.com ====================#
         ELSE
             UPDATE print.ps_product pp
              SET pp.price=new.full_price, pp.wholesale_price=new.item_cost
              WHERE (pp.reference=new.sku);
         END IF;
	 UPDATE phreebooks.lock_table SET lock_trigger1=0;
END IF;
END