<?

require_once('../include/orm.php');
require_once('../include/globals.php');
require_once('../include/util.php'); 
require_once("../consorcios3/libsesion.php");


$_unidades4_configuracionunidades_db_connected = $Link == ''; 
if($_unidades4_configuracionunidades_db_connected) $Link = connectDb();
define('DBCONNECTED', 1);


debugstartpage();


if( isset($_x) ) {
//if( $_x != '' ) {
    $_x = $_x == '' ? array() : StringTokenize($_x, ",");
    $_result = array();
    $_result['version'] = array('actual' => 51);
    $_result['visibility'] = array();
    $_initialvars = arrayExclude(get_defined_vars(), array("_*", "form_*", "s_*", "GLOBALS", "Link", "thisname"));
}


require('../consorcios3/base.events.php');


// isbasewindow: 


// On Open
while( ($__action == "" or $__action == "executedonopen") and (empty($_x) or in('onopen', $_x)) ) {
  $__action = "executedonopen";  
  
  $titulos = getarraycolumnasliquidacion('titulos'); 
$texpensasa = $titulos['Expensas A']; 
$texpensasb = $titulos['Expensas B']; 
$texpensasc = $titulos['Expensas C']; 
$texpensasd = $titulos['Expensas D']; 
$texpensase = $titulos['Expensas E']; 
$texpensasf = $titulos['Expensas F']; 
$texpensasg = $titulos['Expensas G']; 
$texpensash = $titulos['Expensas H'];

// Si puso header location para ir a otra pagina cierra el script
if( !isset($_x) and $__exiting ) { 
   disconnectDb($Link); exit(0);
} 

  
  break;
}


// PHP Vars 
while( ($__action == "" or $__action == "executedonopen") and isset($_GET['_x']) and empty($_x) ) {
    $__row0 = array();
    
	$__row0['__unidades__1'] =  $_id ;
	$__row0['__unidades__2'] =  $id == '0' ? 'Nuevo ' : '' ;


	$__row0['__cellheader2__1'] =  (1==0) ? 'display: inline !important;' : 'display: none !important;' ;


	$__row0['__cellheader4__1'] =  $texpensasa ;

	$__row0['__cellheader5__1'] =  $texpensasb ;

	$__row0['__cellheader6__1'] =  $texpensasc ;

	$__row0['__cellheader7__1'] =  $texpensasd ;

	$__row0['__cellheader8__1'] =  $texpensase ;

	$__row0['__cellheader9__1'] =  $texpensasf ;

	$__row0['__cellheader10__1'] =  (1==0) ? 'display: inline !important;' : 'display: none !important;' ;
	$__row0['__cellheader10__2'] =  $texpensasg ;

	$__row0['__cellheader11__1'] =  (1==0) ? 'display: inline !important;' : 'display: none !important;' ;
	$__row0['__cellheader11__2'] =  $texpensash ;


    $_result['morevars'] = $__row0;
    break;
}


if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) { 
    require_once('../include/fpdfreport.php');
    $_pdf = new PDF((isset($_orientation) ? $_orientation : 'P'),'pt', (isset($_size) ? $_size : 'A4' ));
    $_pdf->initialPage = ($_page != '' ? $_page : 1);
    //$_pdf->SetAutoPageBreak(true);
    $_pdf->title = "";
    $_pdf->SetTopMargin(50);
    $_pdf->AliasNbPages();
    $_pdf->AddPage();
}


if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) {
    $_pdf->title = "Unidades";
    //$_pdf->drawText("Unidades",'Arial','',14);
    
}


// aca iba session get, uofr y load/saveobject
  

while( has($_x, 'unidades_init') ) { 
    $_result['unidades'] = $unidades->toarray(false);
    break;
}
while( has($_x, 'unidades') ) { 

  
    //if( $errors == "" )
    //  validateunidades();
    if( $errors == "" ) {

      
        if( $_redirect != "" ) redirect($_redirect);
        sessionset('form_configuracionunidades_unidades' . $_id, $unidades);
        
        if( $_result['redirect'] == '' )
            redirect("?id=$id");
    }
    break;
}
while( has($_x, 'unidades__delete') ) { 
  
  
    //if( $errors == "" )
    //  validateunidades();
    if( $errors == "" ) {

      
        if( $_redirect != "" ) redirect($_redirect);
        sessionset('form_configuracionunidades_unidades' . $_id, null);
        if( $_result['redirect'] == '' ) {
            $_result['redirect'] = "?message=Unidades eliminado";
        }
    }
    break;
}
while( has($_x, 'unidades_unload') ) {  // Not used

    break;
}


//$unidades  -> ['changes']
if( isormObject($unidades) ) $unidades->makeglobals();

if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellheader2'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellheader10'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellheader11'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellbody2'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellbody10'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellbody11'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellfooter2'] = (1==0);

} 
 
if( isset($_GET['_x']) and empty($_x) ) { 
    $_result['visibility']['cellfooter11'] = (1==0);

} 
 

if( has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2') ) { 
    $_pdf->Output();
}

?><? 


if( !isset($_x) ) { 
?>


<? if( isset($_export) ) { ?>
<?
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=configuracionunidades.xls");
//echo('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">');
//echo('<html xmlns="http://www.w3.org/1999/xhtml">');
echo('<meta http-equiv="Content-type" content="text/html;charset=utf-8" />');
?><? } else { ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html lang="en" >
    <head>    <? require('../consorcios3/base.head.php');   ?>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">	<meta http-equiv="X-UA-Compatible" content="IE=edge">	<meta name="viewport" content="width=device-width, initial-scale=1">		<link rel="shortcut icon" href="favicon.ico" />

    
    <link href="../unidades4/style.css" rel="stylesheet" type="text/css">    

    
    <!-- isbasewindow  -->
    
        
    <script type="text/javascript" src="../include/util.1744242079.js"></script>        
        
    
    </head>    <body         data-version="51"
        data-name="configuracionunidades"        data-target="php"
        class=" <? if( isset($_popup) ) { ?> popup<? } ?>" 
        
        <? if( isset($_popup) ) { ?> class="popup" <? } ?>
        
        >        
        <form id='form' name='form' method='POST' >        
        <input id="_rowid" type="hidden" name="_rowid" value="">        <input id="_rowidname" type="hidden" name="_rowidname" value="">                
                
        <? require('../consorcios3/base.bodytop.php');   ?>

        <style>            
<? if( (has($_x, 'pdf') or has($_x, 'pdfprint') or has($_x, 'pdfprint2')) and (isset($_orientation) or isset($_size)) ) {  ?>
/* A4 Landscape*/@page {    size: A4 portrait;
}<? } ?>
            
        </style>
<? }  // Export
?>
        <div id='unidades' class="panel panel-primary relative form 
         
        
        form-" 
    >    <input id="_id" type=hidden name="_id" value="">
    
    
	<div class="panel-heading 	">		<h5 class="panel-title" 		    
		    data-editable="title">Unidades
		    
		    </h5>		
    		<div class="heading-elements">		    
		    		
<button id='unnamed2' 
    style="        
    "    type="button"     data-href="../expensas/generarporcentual.php" 
    data-target="_smallpopup"         class="btn btn-default
        
         
    "    data-style="expand-left"        
>
    
    
        <span  >Generar porcentual</span>
    
    
</button>

<button id='unnamed22' 
    style="        
    "    type="button"     data-href="actualizacionaltas.php" 
    data-target="_fullpopup"         class="btn btn-default
        
         
    "    data-style="expand-left"        
>
    
    
        <span  >Actualizar fechas de Alta</span>
    
    
</button>
            
	        
		    		    	</div>    	
	</div>	
			<div class="panel-subtitle">		<div class="heading-elements">    		    	     <div class="btn-group  navbar-btn pull-right" style="margin-left: 0">            
            
             </div>    	</div>	</div>	

	<div class="panel-body editmode-only  
	">	    <div class='row'><div id='unnamed1' class="    table    "
    data-name="unnamed1"     data-type="table"     >
        <!-- cansearch:  -->
    
    
            <table id="unnamed1_table"         
        
        class="table margin-20  
        
        
     "
        style="; width:100%;
        "                data-features=""
    
    
        >    
        <thead>            
<tr id='rowheader'     <? if( !isset($_GET['_export']) ) { ?>
    class="    table-header    "
    
    
    <? } ?>
>    
<th
id='cellheader1'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        Denominacion

</th>


<th
style='display: none !important;' id='cellheader2'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        Codigo
</th>


<th
id='cellheader3'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        UCs asociadas
</th>


<th
id='cellheader32'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        Fecha Alta
</th>


<th
id='cellheader4'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
id='cellheader5'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
id='cellheader6'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
id='cellheader7'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
id='cellheader8'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
id='cellheader9'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
style='display: none !important;' id='cellheader10'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


<th
style='display: none !important;' id='cellheader11'     <? if( !isset($_GET['_export']) ) { ?>
    class="    "    
    
    <? } ?>
        
>        </th>


</tr>

    
        </thead>        
        <tbody>        
         <? $_rows_862394 = sqltoarray($Link, "select       up.id as idunidad,      concat(up.denominacion,' uf ', up.codigo) as denominacionunidad,      (select group_concat(concat(denominacion,' uf ', codigo)) from Unidades where uf = up.id and tipou != 'D')       as denominacioncomplementarias,      up.fechaAlta,            /*Porcentuales A*/      ifnull(up.porcentajea,0) as ufporcentajea,      (select sum(ifnull(porcentajea,0)) from Unidades where uf = up.id and tipou != 'D') as ucsporcentajea,      (      ifnull(up.porcentajea,0)       +      ifnull( (select ifnull(sum(ifnull(porcentajea,0)),0) from Unidades where uf = up.id and tipou != 'D'), 0)      ) as ufyucporcentajea,            /*Porcentuales B*/      ifnull(up.porcentajeb,0) as ufporcentajeb,      ifnull((select sum(ifnull(porcentajeb,0)) from Unidades where uf = up.id and tipou != 'D'),0) as ucsporcentajeb,      (      ifnull(up.porcentajeb,0)       +      (select ifnull(sum(ifnull(porcentajeb,0)),0) from Unidades where uf = up.id and tipou != 'D')      ) as ufyucporcentajeb,        /*Porcentuales C*/      ifnull(up.porcentajec,0) as ufporcentajec,      (select sum(ifnull(porcentajec,0)) from Unidades where uf = up.id and tipou != 'D') as ucsporcentajec,      (      ifnull(up.porcentajec,0)       +      ifnull((select ifnull(sum(ifnull(porcentajec,0)),0) from Unidades where uf = up.id and tipou != 'D'),0)      ) as ufyucporcentajec,        /*Porcentuales D*/      ifnull(up.porcentajed,0) as ufporcentajed,      (select sum(ifnull(porcentajed,0)) from Unidades where uf = up.id and tipou != 'D') as ucsporcentajed,      (      ifnull(up.porcentajed,0)       +      ifnull((select ifnull(sum(ifnull(porcentajed,0)),0) from Unidades where uf = up.id and tipou != 'D'),0)      ) as ufyucporcentajed,            /*Porcentuales E*/      ifnull(up.porcentajee,0) as ufporcentajee,      (select sum(ifnull(porcentajee,0)) from Unidades where uf = up.id and tipou != 'D') as ucsporcentajee,      (      ifnull(up.porcentajee,0)       +      ifnull( (select ifnull(sum(ifnull(porcentajee,0)),0) from Unidades where uf = up.id and tipou != 'D'), 0)      ) as ufyucporcentajee,                  /*Porcentuales F*/      ifnull(up.porcentajef,0) as ufporcentajef,      (select sum(ifnull(porcentajef,0)) from Unidades where uf = up.id and tipou != 'D') as ucsporcentajef,      (      ifnull(up.porcentajef,0)       +      ifnull( (select ifnull(sum(ifnull(porcentajef,0)),0) from Unidades where uf = up.id and tipou != 'D'), 0)      ) as ufyucporcentajef                from       Unidades as up  where       up.emprendimientoId = '" . mysql_escape($proyecto) . "'      and up.tipou = 'D'    union    select       up2.id as idunidad,      concat(up2.denominacion,' uf ', up2.codigo) as denominacionunidad,      (select group_concat(concat(denominacion,' uf ', codigo)) from Unidades where uf = up2.id and tipou != 'D')       as denominacioncomplementarias,      up2.fechaAlta,            /*Porcentuales A*/      ifnull(up2.porcentajea,0) as ufporcentajea,      0 as ucsporcentajea,      ifnull(up2.porcentajea,0) as ufyucporcentajea,            /*Porcentuales B*/      ifnull(up2.porcentajeb,0) as ufporcentajeb,      0 as ucsporcentajeb,      ifnull(up2.porcentajeb,0) as ufyucporcentajeb,        /*Porcentuales C*/      ifnull(up2.porcentajec,0) as ufporcentajec,      0 as ucsporcentajec,      ifnull(up2.porcentajec,0) as ufyucporcentajec,            /*Porcentuales D*/      ifnull(up2.porcentajed,0) as ufporcentajed,      0 as ucsporcentajed,      ifnull(up2.porcentajed,0) as ufyucporcentajed,        /*Porcentuales E*/      ifnull(up2.porcentajee,0) as ufporcentajee,      0 as ucsporcentajee,      ifnull(up2.porcentajee,0) as ufyucporcentajee,            /*Porcentuales F*/      ifnull(up2.porcentajea,0) as ufporcentajef,      0 as ucsporcentajef,      ifnull(up2.porcentajea,0) as ufyucporcentajef        from       Unidades as up2  where       up2.emprendimientoId = '" . mysql_escape($proyecto) . "'      and up2.tipou != 'D'       and (up2.uf = 0 or up2.uf is null)  order by 2  ", array());
foreach($_rows_862394 as $_index => $_row_862394) { 
   makeglobals($_row_862394);    ?>

<tr id='rowbody1'     <? if( !isset($_GET['_export']) ) { ?>
    class="    table-body    clickable-row"
     data-href="unidad.php?id=" 
    <? if( $editablerow == '0' ) { ?> data-editable="0" <? } ?>
    <? if( $deleteablerow == '0' ) { ?> data-deleteable="0" <? } ?>
    
     data-first="