1 /* -*- Mode: C++; tab-width: 2; indent-tabs-mode: nil; c-basic-offset: 2 -*- */
2 /* vim:set ts=2 sw=2 sts=2 et cindent tw=79 ft=cpp: */
4 * Copyright (C) 2008 Sergey Yanovich <ynvich@gmail.com>
6 * This program is free software; you can redistribute it and/or
7 * modify it under the terms of the GNU General Public License as
8 * published by the Free Software Foundation; either version 2 of the
9 * License, or (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14 * General Public License for more details.
16 * You should have received a copy of the GNU General Public
17 * License along with this program; if not, write to the
18 * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
19 * Boston, MA 02111-1307, USA.
22 #include "xpcom-config.h"
25 #include "nsComponentManagerUtils.h"
26 #include "nsXPCOMCID.h"
27 #include "nsIMutableArray.h"
28 #include "nsISupportsPrimitives.h"
32 /* Project includes */
33 #include "aaAmountUtils.h"
36 #include "aaTransferInsert.h"
38 static const char *sql
= "INSERT INTO transfer (day, event_id, id, amount)\
39 SELECT (replace(round(julianday(?,'unixepoch')),'.0','')) AS _day,\
40 ? AS _event_id, IFNULL(MAX(transfer.id),0) + 1, ? FROM transfer\
41 WHERE transfer.day == _day AND transfer.event_id == _event_id";
43 aaTransferInsert::aaTransferInsert()
48 NS_IMPL_ISUPPORTS_INHERITED0(aaTransferInsert
,
53 aaTransferInsert::SetFilter(nsISupports
* aFilter
)
56 mFact
= do_QueryInterface(aFilter
, &rv
);
57 NS_ENSURE_SUCCESS(rv
, rv
);
63 aaTransferInsert::GetParams(nsIArray
* * aParams
)
65 NS_ENSURE_TRUE(mFact
, NS_ERROR_NOT_INITIALIZED
);
68 nsCOMPtr
<nsIMutableArray
> result
69 = do_CreateInstance(NS_ARRAY_CONTRACTID
, &rv
);
70 NS_ENSURE_SUCCESS(rv
, rv
);
72 nsCOMPtr
<nsISupportsPRInt64
> valInt64
;
73 nsCOMPtr
<nsISupportsDouble
> valDouble
;
75 valInt64
= do_CreateInstance(NS_SUPPORTS_PRINT64_CONTRACTID
, &rv
);
76 NS_ENSURE_SUCCESS(rv
, rv
);
77 rv
= valInt64
->SetData(mFact
->PickTime() / 1000000);
78 NS_ENSURE_SUCCESS(rv
, rv
);
79 rv
= result
->InsertElementAt(valInt64
, 0, PR_FALSE
);
80 NS_ENSURE_SUCCESS(rv
, rv
);
82 valInt64
= do_CreateInstance(NS_SUPPORTS_PRINT64_CONTRACTID
, &rv
);
83 NS_ENSURE_SUCCESS(rv
, rv
);
84 rv
= valInt64
->SetData(mFact
->PickEventId());
85 NS_ENSURE_SUCCESS(rv
, rv
);
86 rv
= result
->InsertElementAt(valInt64
, 1, PR_FALSE
);
87 NS_ENSURE_SUCCESS(rv
, rv
);
89 valDouble
= do_CreateInstance(NS_SUPPORTS_DOUBLE_CONTRACTID
, &rv
);
90 NS_ENSURE_SUCCESS(rv
, rv
);
91 rv
= valDouble
->SetData(mFact
->PickAmount());
92 NS_ENSURE_SUCCESS(rv
, rv
);
93 rv
= result
->InsertElementAt(valDouble
, 2, PR_FALSE
);
94 NS_ENSURE_SUCCESS(rv
, rv
);