viric@0: <?php
viric@0: 
viric@0: include("strings.inc");
viric@0: 
viric@0: class ingres
viric@0: {
viric@0: var $dia;
viric@0: var $mes;
viric@0: var $any;
viric@0: var $hora;
viric@0: var $minut;
viric@0: var $modificat; // Timestamp
viric@0: var $rao;
viric@0: var $butxaca;
viric@0: var $tipus;
viric@0: var $diners;
viric@0: var $comentari;
viric@0: 
viric@0: function data()
viric@0: {
viric@0: 	return mktime($this->hora, $this->minut, 0, $this->mes, $this->dia,
viric@0: 		$this->any);
viric@0: }
viric@0: 
viric@0: function setData($data)
viric@0: {
viric@0: 	$this->dia = date('d',$data);
viric@0: 	$this->mes = date('m',$data);
viric@0: 	$this->any = date('Y',$data);
viric@0: 	$this->hora = date('H',$data);
viric@0: 	$this->minut = date('i',$data);
viric@0: }
viric@0: 
viric@0: function DBAfegir($connexio)
viric@0: {
viric@0: 	$query = "INSERT INTO ingressos
viric@0: 	(data,data_modif,rao,quantitat,
viric@0: 		butxaca,comentari) 
viric@0: 		VALUES(";
viric@0: 	$query .= "FROM_UNIXTIME(" . mktime($this->hora,
viric@0: 			$this->minut,
viric@0: 			0,
viric@0: 			$this->mes,
viric@0: 			$this->dia,
viric@0: 			$this->any) . "), ";
viric@0: 	$query .= "FROM_UNIXTIME(". time() . "), ";
viric@0: 	$query .= "'" . strtosql( $this->rao) . "', ";
viric@0: 	if($this->tipus == "ingres")
viric@0: 		$query .= $this->diners . ", ";
viric@0: 	else
viric@0: 		$query .= "-". $this->diners . ", ";
viric@0: 	$query .= $this->butxaca . ", ";
viric@0: 	$query .= "'" . strtosql( $this->comentari) . "'); ";
viric@0: 
viric@0: 
viric@0: 	$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: function DBModificar($connexio, $data_vella)
viric@0: {
viric@0: 	$query = "UPDATE ingressos SET ";
viric@0: 	$query .= "data=FROM_UNIXTIME(" . $this->data() . "), ";
viric@0: 	$query .= "data_modif=FROM_UNIXTIME(". time() . "), ";
viric@0: 	$query .= "rao='" . strtosql( $this->rao) . "', ";
viric@0: 	$query .= "quantitat=";
viric@0: 	if($this->tipus == "ingres")
viric@0: 		$query .= $this->diners . ", ";
viric@0: 	else
viric@0: 		$query .= "-". $this->diners . ", ";
viric@0: 	$query .= "butxaca=" . $this->butxaca . ", ";
viric@0: 	$query .= "comentari='" . strtosql( $this->comentari) . "' ";
viric@0: 	$query .= "WHERE data=FROM_UNIXTIME(" . $data_vella . ");";
viric@0: 
viric@0: 
viric@0: 	$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: function DBBorrar($connexio)
viric@0: {
viric@0: 	$query = "DELETE FROM ingressos WHERE UNIX_TIMESTAMP(data) = ";
viric@0: 	$query .= $this->data() . ";";
viric@0: 
viric@0: 	$resultat = mysql_query($query,$connexio);
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 	return 0;
viric@0: 	
viric@0: }
viric@0: 
viric@0: function ingres($connexio=-1, $data=0)
viric@0: {
viric@0: 	// De nul
viric@0: 	if ($connexio==-1)
viric@0: 	{
viric@0: 		$this->dia = date('d');
viric@0: 		$this->mes = date('m');
viric@0: 		$this->any = date('Y');
viric@0: 		$this->hora = date('H');
viric@0: 		$this->minut = date('i');
viric@0: 		$this->rao = "";
viric@0: 		$this->butxaca = -1;
viric@0: 		$this->tipus = "despesa";
viric@0: 		$this->diners = 0;
viric@0: 		$this->comentari = "";
viric@0: 	}
viric@0: 	else
viric@0: 	{
viric@0: 		$query = "SELECT UNIX_TIMESTAMP(data),
viric@0: 		UNIX_TIMESTAMP(data_modif), rao, butxaca, quantitat,
viric@0: 		comentari FROM ingressos WHERE UNIX_TIMESTAMP(data) = ";
viric@0: 		$query .= $data . ";";
viric@0: 
viric@0: 		$resultat = mysql_query($query,$connexio);
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: 			echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 			return 1; // Què passa amb un return aquí?
viric@0: 		}
viric@0: 		
viric@0: 		// Només hi haurà un resultat
viric@0: 		$fila = mysql_fetch_row($resultat);
viric@0: 		
viric@0: 		settype($fila[4], float);
viric@0: 
viric@0: 		$this->dia = date('d',$fila[0]);
viric@0: 		$this->mes = date('m',$fila[0]);
viric@0: 		$this->any = date('Y',$fila[0]);
viric@0: 		$this->hora = date('H',$fila[0]);
viric@0: 		$this->minut = date('i',$fila[0]);
viric@0: 		$this->modificat = $fila[1];
viric@0: 		$this->rao = $fila[2];
viric@0: 		$this->butxaca = $fila[3];
viric@0: 		if ($fila[4] > 0)
viric@0: 			$this->tipus = "ingres";
viric@0: 		else
viric@0: 			$this->tipus = "despesa";
viric@0: 		$this->diners = abs($fila[4]);
viric@0: 		$this->comentari = $fila[5];
viric@0: 
viric@0: 	}
viric@0: }
viric@0: 
viric@0: }
viric@0: 
viric@0: class moviment
viric@0: {
viric@0: var $dia;
viric@0: var $mes;
viric@0: var $any;
viric@0: var $hora;
viric@0: var $minut;
viric@0: var $modificat; // Timestamp
viric@0: var $rao;
viric@0: var $butxaca_origen;
viric@0: var $butxaca_desti;
viric@0: var $diners;
viric@0: var $comentari;
viric@0: 
viric@0: 
viric@0: function data()
viric@0: {
viric@0: 	return mktime($this->hora, $this->minut, 0, $this->mes, $this->dia,
viric@0: 		$this->any);
viric@0: }
viric@0: function setData($data)
viric@0: {
viric@0: 	$this->dia = date('d',$data);
viric@0: 	$this->mes = date('m',$data);
viric@0: 	$this->any = date('Y',$data);
viric@0: 	$this->hora = date('H',$data);
viric@0: 	$this->minut = date('i',$data);
viric@0: }
viric@0: 
viric@0: function DBAfegir($connexio)
viric@0: {
viric@0: 	$query = "INSERT INTO moviments
viric@0: 	(data,data_modif,rao,quantitat,
viric@0: 		butxaca_origen,butxaca_desti,comentari) 
viric@0: 		VALUES(";
viric@0: 	$query .= "FROM_UNIXTIME(" . $this->data() . "), ";
viric@0: 	$query .= "FROM_UNIXTIME(". time() . "), ";
viric@0: 	$query .= "'" . strtosql( $this->rao) . "', ";
viric@0: 	$query .= $this->diners . ", ";
viric@0: 	$query .= $this->butxaca_origen . ", ";
viric@0: 	$query .= $this->butxaca_desti . ", ";
viric@0: 	$query .= "'" . strtosql( $this->comentari) . "'); ";
viric@0: 
viric@0: 
viric@0: 	$resultat = mysql_query($query, $connexio);
viric@0: 
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 
viric@0: 	return 0;
viric@0: }
viric@0: 
viric@0: function DBBorrar($connexio)
viric@0: {
viric@0: 	$query = "DELETE FROM moviments WHERE UNIX_TIMESTAMP(data) = ";
viric@0: 	$query .= mktime($this->hora,
viric@0: 			$this->minut,
viric@0: 			0,
viric@0: 			$this->mes,
viric@0: 			$this->dia,
viric@0: 			$this->any) . ";";
viric@0: 
viric@0: 	$resultat = mysql_query($query,$connexio);
viric@0: 	if (!$resultat)
viric@0: 	{
viric@0: 		echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		return 1;
viric@0: 	}
viric@0: 	return 0;
viric@0: 	
viric@0: }
viric@0: 
viric@0: function moviment($connexio=-1, $data=0)
viric@0: {
viric@0: 	// De nul
viric@0: 	if ($connexio==-1)
viric@0: 	{
viric@0: 		$this->dia = date('d');
viric@0: 		$this->mes = date('m');
viric@0: 		$this->any = date('Y');
viric@0: 		$this->hora = date('H');
viric@0: 		$this->minut = date('i');
viric@0: 		$this->rao = "";
viric@0: 		$this->butxaca_origen = -1;
viric@0: 		$this->butxaca_desti = -1;
viric@0: 		$this->diners = 0;
viric@0: 		$this->comentari = "";
viric@0: 	}
viric@0: 	else
viric@0: 	{
viric@0: 		$query = "SELECT UNIX_TIMESTAMP(data),
viric@0: 		UNIX_TIMESTAMP(data_modif), rao, butxaca_origen, butxaca_desti,
viric@0: 		quantitat,
viric@0: 		comentari FROM moviments WHERE UNIX_TIMESTAMP(data) = ";
viric@0: 		$query .= $data . ";";
viric@0: 
viric@0: 		$resultat = mysql_query($query,$connexio);
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: 			echo mysql_errno().": ".mysql_error()."<BR>";
viric@0: 			return 1; // Què passa amb un return aquí?
viric@0: 		}
viric@0: 		
viric@0: 		// Només hi haurà un resultat
viric@0: 		$fila = mysql_fetch_row($resultat);
viric@0: 		
viric@0: 		settype($fila[4], float);
viric@0: 
viric@0: 		$this->dia = date('d',$fila[0]);
viric@0: 		$this->mes = date('m',$fila[0]);
viric@0: 		$this->any = date('Y',$fila[0]);
viric@0: 		$this->hora = date('H',$fila[0]);
viric@0: 		$this->minut = date('i',$fila[0]);
viric@0: 		$this->modificat = $fila[1];
viric@0: 		$this->rao = $fila[2];
viric@0: 		$this->butxaca_origen = $fila[3];
viric@0: 		$this->butxaca_desti = $fila[4];
viric@0: 		$this->diners = abs($fila[5]);
viric@0: 		$this->comentari = $fila[6];
viric@0: 
viric@0: 	}
viric@0: }
viric@0: 
viric@0: }
viric@0: 
viric@0: ?>