<?php

include("strings.inc");

class ingres

{

var $dia;

var $mes;

var $any;

var $hora;

var $minut;

var $modificat; // Timestamp

var $rao;

var $butxaca;

var $tipus;

var $diners;

var $comentari;

function data()

{

	return mktime($this->hora, $this->minut, 0, $this->mes, $this->dia,

		$this->any);

}

function setData($data)

{

	$this->dia = date('d',$data);

	$this->mes = date('m',$data);

	$this->any = date('Y',$data);

	$this->hora = date('H',$data);

	$this->minut = date('i',$data);

}

function DBAfegir($connexio)

{

	$query = "INSERT INTO ingressos

	(data,data_modif,rao,quantitat,

		butxaca,comentari) 

		VALUES(";

	$query .= "FROM_UNIXTIME(" . mktime($this->hora,

			$this->minut,

			0,

			$this->mes,

			$this->dia,

			$this->any) . "), ";

	$query .= "FROM_UNIXTIME(". time() . "), ";

	$query .= "'" . strtosql( $this->rao) . "', ";

	if($this->tipus == "ingres")

		$query .= $this->diners . ", ";

	else

		$query .= "-". $this->diners . ", ";

	$query .= $this->butxaca . ", ";

	$query .= "'" . strtosql( $this->comentari) . "'); ";

	$resultat = mysql_query($query, $connexio);

	if (!$resultat)

	{

		echo mysql_errno().": ".mysql_error()."<BR>";

		return 1;

	}

	return 0;

}

function DBModificar($connexio, $data_vella)

{

	$query = "UPDATE ingressos SET ";

	$query .= "data=FROM_UNIXTIME(" . $this->data() . "), ";

	$query .= "data_modif=FROM_UNIXTIME(". time() . "), ";

	$query .= "rao='" . strtosql( $this->rao) . "', ";

	$query .= "quantitat=";

	if($this->tipus == "ingres")

		$query .= $this->diners . ", ";

	else

		$query .= "-". $this->diners . ", ";

	$query .= "butxaca=" . $this->butxaca . ", ";

	$query .= "comentari='" . strtosql( $this->comentari) . "' ";

	$query .= "WHERE data=FROM_UNIXTIME(" . $data_vella . ");";

	$resultat = mysql_query($query, $connexio);

	if (!$resultat)

	{

		echo mysql_errno().": ".mysql_error()."<BR>";

		return 1;

	}

	return 0;

}

function DBBorrar($connexio)

{

	$query = "DELETE FROM ingressos WHERE UNIX_TIMESTAMP(data) = ";

	$query .= $this->data() . ";";

	$resultat = mysql_query($query,$connexio);

	if (!$resultat)

	{

		echo mysql_errno().": ".mysql_error()."<BR>";

		return 1;

	}

	return 0;

}

function ingres($connexio=-1, $data=0)

{

	// De nul

	if ($connexio==-1)

	{

		$this->dia = date('d');

		$this->mes = date('m');

		$this->any = date('Y');

		$this->hora = date('H');

		$this->minut = date('i');

		$this->rao = "";

		$this->butxaca = -1;

		$this->tipus = "despesa";

		$this->diners = 0;

		$this->comentari = "";

	}

	else

	{

		$query = "SELECT UNIX_TIMESTAMP(data),

		UNIX_TIMESTAMP(data_modif), rao, butxaca, quantitat,

		comentari FROM ingressos WHERE UNIX_TIMESTAMP(data) = ";

		$query .= $data . ";";

		$resultat = mysql_query($query,$connexio);

		if (!$resultat)

		{

			echo mysql_errno().": ".mysql_error()."<BR>";

			return 1; // Què passa amb un return aquí?

		}

		// Només hi haurà un resultat

		$fila = mysql_fetch_row($resultat);

		settype($fila[4], float);

		$this->dia = date('d',$fila[0]);

		$this->mes = date('m',$fila[0]);

		$this->any = date('Y',$fila[0]);

		$this->hora = date('H',$fila[0]);

		$this->minut = date('i',$fila[0]);

		$this->modificat = $fila[1];

		$this->rao = $fila[2];

		$this->butxaca = $fila[3];

		if ($fila[4] > 0)

			$this->tipus = "ingres";

		else

			$this->tipus = "despesa";

		$this->diners = abs($fila[4]);

		$this->comentari = $fila[5];

	}

}

}

class moviment

{

var $dia;

var $mes;

var $any;

var $hora;

var $minut;

var $modificat; // Timestamp

var $rao;

var $butxaca_origen;

var $butxaca_desti;

var $diners;

var $comentari;

function data()

{

	return mktime($this->hora, $this->minut, 0, $this->mes, $this->dia,

		$this->any);

}

function setData($data)

{

	$this->dia = date('d',$data);

	$this->mes = date('m',$data);

	$this->any = date('Y',$data);

	$this->hora = date('H',$data);

	$this->minut = date('i',$data);

}

function DBAfegir($connexio)

{

	$query = "INSERT INTO moviments

	(data,data_modif,rao,quantitat,

		butxaca_origen,butxaca_desti,comentari) 

		VALUES(";

	$query .= "FROM_UNIXTIME(" . $this->data() . "), ";

	$query .= "FROM_UNIXTIME(". time() . "), ";

	$query .= "'" . strtosql( $this->rao) . "', ";

	$query .= $this->diners . ", ";

	$query .= $this->butxaca_origen . ", ";

	$query .= $this->butxaca_desti . ", ";

	$query .= "'" . strtosql( $this->comentari) . "'); ";

	$resultat = mysql_query($query, $connexio);

	if (!$resultat)

	{

		echo mysql_errno().": ".mysql_error()."<BR>";

		return 1;

	}

	return 0;

}

function DBBorrar($connexio)

{

	$query = "DELETE FROM moviments WHERE UNIX_TIMESTAMP(data) = ";

	$query .= mktime($this->hora,

			$this->minut,

			0,

			$this->mes,

			$this->dia,

			$this->any) . ";";

	$resultat = mysql_query($query,$connexio);

	if (!$resultat)

	{

		echo mysql_errno().": ".mysql_error()."<BR>";

		return 1;

	}

	return 0;

}

function moviment($connexio=-1, $data=0)

{

	// De nul

	if ($connexio==-1)

	{

		$this->dia = date('d');

		$this->mes = date('m');

		$this->any = date('Y');

		$this->hora = date('H');

		$this->minut = date('i');

		$this->rao = "";

		$this->butxaca_origen = -1;

		$this->butxaca_desti = -1;

		$this->diners = 0;

		$this->comentari = "";

	}

	else

	{

		$query = "SELECT UNIX_TIMESTAMP(data),

		UNIX_TIMESTAMP(data_modif), rao, butxaca_origen, butxaca_desti,

		quantitat,

		comentari FROM moviments WHERE UNIX_TIMESTAMP(data) = ";

		$query .= $data . ";";

		$resultat = mysql_query($query,$connexio);

		if (!$resultat)

		{

			echo mysql_errno().": ".mysql_error()."<BR>";

			return 1; // Què passa amb un return aquí?

		}

		// Només hi haurà un resultat

		$fila = mysql_fetch_row($resultat);

		settype($fila[4], float);

		$this->dia = date('d',$fila[0]);

		$this->mes = date('m',$fila[0]);

		$this->any = date('Y',$fila[0]);

		$this->hora = date('H',$fila[0]);

		$this->minut = date('i',$fila[0]);

		$this->modificat = $fila[1];

		$this->rao = $fila[2];

		$this->butxaca_origen = $fila[3];

		$this->butxaca_desti = $fila[4];

		$this->diners = abs($fila[5]);

		$this->comentari = $fila[6];

	}

}

}

?>