get value discount or sale

[uzziell]

sir i have code like this 

public function getHarga($id){


$cariprice = Db::getInstance()->executeS('SELECT * FROM `ps_product` WHERE id_product='.$id.'');
foreach ($cariprice as $lawlaw){
$mantap = $lawlaw['price'];
}
return $mantap;


}

and on my .tpl 

{convertPrice price=$lawak->getHarga($value['product_4'])}

the code work well, but I get stuck when I wanna get value price after discount and get discount value.

 

anyone get idea? thanks

 

 

 

[uzziell]

can someone tell me, which table value discount or sale? thank