$num = 1;
sprintf("%04d", $num);
it will return 0001
$num = 1;
sprintf("%04d", $num);
it will return 0001
$Router = $this->_front->getRouter();
$CategoryRoute = new Zend_Controller_Router_Route('category/:category/:controller/:action/*',
array(
'controller' => 'index',
'action' => 'index',
'category' => null
)
);
$Router->addRoute('category', $CategoryRoute);
select id,
case report.type
when 'P' then amount
when 'N' then -amount
end as amount
from
`report`