#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <grass/Vect.h>
#include <grass/dbmi.h>

#include "growing.h"

void P_Aux_to_Coor (struct Map_info *In, struct Map_info *Out, dbDriver *driver, FILE *fsite) {
	
	int cont=0;
	int more, ltype, line_num, ID_type, Interp_type;
	double quotaZ;
	
	struct line_pnts *point;
	struct line_cats *cat;
	dbTable *table;
	dbColumn *ID_column, *Interp_column;
	dbValue *ID_value, *Interp_value;
	dbCursor cursor;
	dbString sql;
	
	point = Vect_new_line_struct ();
	cat = Vect_new_cats_struct ();
	db_init_string (&sql);
	db_zero_string (&sql);	
	
	db_append_string (&sql, "select ID, sum(Interp) from Auxiliar_table group by ID");
	db_open_select_cursor (driver, &sql, &cursor, DB_SEQUENTIAL);
	
	while ( db_fetch (&cursor, DB_NEXT, &more) == DB_OK && more ) { 
	    cont ++;

	    table = db_get_cursor_table (&cursor);

	    ID_column = db_get_table_column (table,0);
	    Interp_column = db_get_table_column (table,1);

	    ID_type = db_sqltype_to_Ctype (db_get_column_sqltype (ID_column));
	    Interp_type = db_sqltype_to_Ctype (db_get_column_sqltype (Interp_column));

	    if ( ID_type == DB_C_TYPE_INT ) 	    
		ID_value = db_get_column_value (ID_column);
	    else continue;

	    if ( Interp_type == DB_C_TYPE_DOUBLE ) 
		Interp_value = db_get_column_value (Interp_column);
	    else continue;

	    line_num = db_get_value_int (ID_value);
	    quotaZ = db_get_value_double (Interp_value);

	    ltype = Vect_read_line (In, point, cat, line_num);

	    if (!(ltype & GV_POINT)) continue;

	    point->z[0] = quotaZ;
	    Vect_write_line (Out, ltype, point, cat);
	}
	return;
}