renderer->addTemplate( $template );
}
function run( & $action )
{
$total_reg = "10";
if (empty($action->arguments['page'])) {
$pc = "1";
} else {
$pc = $action->arguments['page'];
}
$ini = $pc - 1;
$ini = $ini * $total_reg;
$res = $this->env->db->query(sprintf("SELECT * FROM users A
INNER JOIN user_plan B USING(id_user)
INNER JOIN bar C USING(id_user_plan)
INNER JOIN address D USING(id_bar)
WHERE A.id_user = %d GROUP BY(C.id_bar) LIMIT %d,%d",$this->env->session->get('id_user'),$ini,$total_reg));
$res2 = $this->env->db->query(sprintf("SELECT * FROM users A
INNER JOIN user_plan B USING(id_user)
INNER JOIN bar C USING(id_user_plan)
INNER JOIN address D USING(id_bar)
WHERE A.id_user = %d GROUP BY(C.id_bar)",$this->env->session->get('id_user'),$ini,$total_reg));
$tp = $res2->rowCount() / $total_reg; // verifica o número total de páginas
$anterior = $pc -1;
$proximo = $pc +1;
if ($pc>1) {
$this->renderer->assign("previous",
"env->config->get("FrontController")."/Account/viewlocation/id_user,".$this->env->session->get('id_user')."page,$anterior"."'><- Previous ");
}
$this->renderer->assign("pipe","|");
if ($pc<$tp) {
$this->renderer->assign("next",
"env->config->get("FrontController")."/Account/viewlocation/id_user,".$this->env->session->get('id_user')."page,$proximo"."'><-Next ->");
}
$arrBar = array();
echo 'RES = ';print_r($res);
while ($row = $res->fetch()) {
ECHO 'row = ';PRINT_R($row);echo'
';
$arrBar[] = $row;
}echo 'ARRBAR = ';print_r($arrBar);
for($i=0;$irenderer->assign("arrBar",$arrBar);
if($arrBar == array()) {
$this->renderer->assign("noitem",true);
}
}
}
?>