Untitled

<?php

class AccountViewLocation extends ActionPerformed
{
	function initialize()
	{
	
		$template = & new Template( "Account/Templates/industry-account_viewlocation.shtml" );
		$this->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",
		    "<a href='".$this->env->config->get("ApplicationUrl").'/'.$this->env->config->get("FrontController")."/Account/viewlocation/id_user,".$this->env->session->get('id_user')."page,$anterior"."'><- Previous</a> ");
		}
		$this->renderer->assign("pipe","|");
		if ($pc<$tp) {
		    $this->renderer->assign("next",
		    "<a href='".$this->env->config->get("ApplicationUrl").'/'.$this->env->config->get("FrontController")."/Account/viewlocation/id_user,".$this->env->session->get('id_user')."page,$proximo"."'><-Next -></a>");
		}
			
			
	
			$arrBar = array();
		echo 'RES = ';print_r($res);
			while ($row = $res->fetch()) {
	ECHO 'row = ';PRINT_R($row);echo'<br>';
				$arrBar[] = $row;
				
				
	  		}echo 'ARRBAR = ';print_r($arrBar);
	  		for($i=0;$i<count($arrBar);$i++) {
	  			$arrBar[$i]['dt_created'] = date("m/d/Y",strtotime($arrBar[$i]['dt_created']));
	  			$arrBar[$i]['dt_modified'] = date("m/d/Y",strtotime($arrBar[$i]['dt_modified']));
	  		}
	  		
	  		$this->renderer->assign("arrBar",$arrBar);
	  		
	  		if($arrBar == array()) {
	  			$this->renderer->assign("noitem",true);
	  		}
		}
  		
  		
	
}

?>