~fuzzgun/fin/trunk

« back to all changes in this revision

Viewing changes to src/database.h

  • Committer: Bob Mottram
  • Date: 2012-10-06 23:03:24 UTC
  • Revision ID: fuzzgun@gmail.com-20121006230324-fzi3u51j1v153boz
Adjustments

Show diffs side-by-side

added added

removed removed

Lines of Context:
36
36
int directory_exists(char * name);
37
37
int file_exists(char * name);
38
38
int account_exists(char * name);
39
 
int database_save(char * account, char * date_format, char * quantity,
40
 
                                  char * description, char * spend, char * receive,
41
 
                                  char * date, char * timestr, int recur,
42
 
                                  char * currency, char * status,
43
 
                                  char * invoice_number, char * sales_number,
44
 
                                  char * purchase_number, char * works_number,
45
 
                                  char * job_number, char * serial_number,
46
 
                                  char * part_number, char * tracking_number,
47
 
                                  float progress, char * latitude,
48
 
                                  char * longitude, char * altitude,
49
 
                                  char * supplier, char * customer, char * VATrate);
 
39
int database_save_transaction(
 
40
    char * account, char * date_format, char * quantity,
 
41
        char * description, char * spend, char * receive,
 
42
        char * date, char * timestr, int recur,
 
43
        char * currency, char * status,
 
44
        char * invoice_number, char * sales_number,
 
45
        char * purchase_number, char * works_number,
 
46
        char * job_number, char * serial_number,
 
47
        char * part_number, char * tracking_number,
 
48
        float progress, char * latitude,
 
49
        char * longitude, char * altitude,
 
50
        char * supplier, char * customer, char * VATrate);
50
51
int get_balance(char * account, char ** currency, char ** total_spent,
51
52
                                char ** total_received, char ** balance);
52
53
int clear_transaction_numbers();
53
54
int save_transaction_number(char * transaction_number);
54
55
int get_transaction_number_from_record_number(int record_number,
55
56
                                                                                          char * transaction_number);
56
 
 
57
57
int database_save_short(char * account, 
58
58
                                                char * date, char * timestr,
59
59
                                                char * date_format,
62
62
                                                float progress, char * supplier,
63
63
                                                char * receive, char * spend);
64
64
 
 
65
int database_save_adjustment(
 
66
    char * account,
 
67
        char * current_datetime,
 
68
    char adjustment_type,
 
69
        char * transaction_identifier,
 
70
        char * quantity, char * description,
 
71
        char * spend, char * receive,
 
72
        char * date, char * timestr, int recur,
 
73
        char * currency, char * status,
 
74
        char * invoice_number, char * sales_number,
 
75
        char * purchase_number, char * works_number,
 
76
        char * job_number, char * serial_number,
 
77
        char * part_number, char * tracking_number,
 
78
        float progress, char * latitude,
 
79
        char * longitude, char * altitude,
 
80
        char * supplier, char * customer, char * VATrate);
 
81
 
 
82
int database_save_adjustment_short(
 
83
    char * account,
 
84
        char * current_datetime,
 
85
        char adjustment_type,
 
86
        char * transaction_identifier,
 
87
        char * date, char * timestr,
 
88
        char * status, char * description,
 
89
        char * currency, char *VATrate,
 
90
        float progress, char * supplier,
 
91
        char * receive, char * spend);
 
92
 
65
93
int database_get_record(
66
94
                                                char * account,
67
95
                                                int record_number,
68
 
                                                char * date,
 
96
                                                char * date, char * timestr,
69
97
                                                char * transaction_number,
70
98
                                                char * status, char * description,
71
99
                                                char * currency, char *VATrate,
75
103
int database_edit_record(
76
104
                                                 char * account,
77
105
                                                 int record_number,
78
 
                                                 char * date,
 
106
                                                 char * prev_date, char * prev_timestr,
 
107
                                                 char * prev_status, char * prev_description,
 
108
                                                 char * prev_currency, char *prev_VATrate,
 
109
                                                 float prev_progress, char * prev_supplier,
 
110
                                                 char * prev_receive, char * prev_spend,
 
111
                                                 char * date, char * timestr,
79
112
                                                 char * status, char * description,
80
113
                                                 char * currency, char *VATrate,
81
114
                                                 float progress, char * supplier,
82
 
                                                 char * receive, char * spend);
 
115
                                                 char * receive, char * spend,
 
116
                                                 char * date_format);
83
117
 
84
118
int database_delete_record(char * account, int record_number);
85
119
 
109
143
                                           int monthly, int max_transactions,
110
144
                                           char field_separator, char column_separator,
111
145
                                           char * search_string, char * export_filename);
 
146
int create_sqlite_adjustments_table(char * account);
112
147
 
113
148
#endif