FuelWare

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

FuelWare

Post by Rathinagiri »

fuelware.png
fuelware.png (105.56 KiB) Viewed 5404 times
I am happy to share yet another project of mine with you all.

I have named this project as 'FuelWare' which can be used to track expenses related to vehicles in an organization like fuel, insurance, permit and other. I am making the documentation and once it is over, I will share that with you. I am sure the screens are self explanatory.

The project is based on SQLite database. It comes with a sample database. If you want to enter in a fresh database, please rename/delete the file named 'fuelwaredb.sqlite'. A new file in this name will be created.

Source Code:
FuelWare.zip
(570.44 KiB) Downloaded 461 times
You should include the following library file before compiling using IDE in the /lib folder.
libhmgsqlite.zip
(2.5 KiB) Downloaded 404 times
Compiled Executable
FuelWareExe.zip
(2.09 MiB) Downloaded 408 times
Help
fuelware_help.zip
(2.51 MiB) Downloaded 428 times
Now it is time for some screenshots: :)

Main Screen
fuelware01.jpg
fuelware01.jpg (75.9 KiB) Viewed 5404 times
Transaction Entry Screen
fuelware02.jpg
fuelware02.jpg (76.14 KiB) Viewed 5404 times
Vehicle Management Screen
fuelware03.jpg
fuelware03.jpg (75.19 KiB) Viewed 5404 times
Tag Management Screen
fuelware04.jpg
fuelware04.jpg (66.27 KiB) Viewed 5404 times
Report Screen
fuelware05.jpg
fuelware05.jpg (71.88 KiB) Viewed 5404 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
serge_girard
Posts: 3165
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: FuelWare

Post by serge_girard »

Thanks Rathi for sharing !

Serge
There's nothing you can do that can't be done...
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: FuelWare

Post by mol »

Great job!
Thanks for sharing!
I will return to sqlite testing after adventures with HMGScript.
I'm sure this sample will help me a tot!
User avatar
mustafa
Posts: 1158
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Contact:

Re: FuelWare

Post by mustafa »

Hola amigo Rathi:
Magnífico , muchas gracias por su aportación
Creo que este proyecto suyo tendria que
incluirse en los samples SQlite de HMG para
la proxíma versión.

Quiero comentarle que el sample me daba
error de compilación , le adjunto Error
----- Solución -------------
he añadido al fichero FuelWare.hbp
Sql1.prg.

En fichero "solution.zip" adjunto
sql1.prg
error.log
build.3.4.2.bat
build.3.4.2_64.bat

Todo Ok con los cambios

saludos
Mustafa
*------------------ Google-----------------------*
Hello friend Rathi
Great, thank you very much for your input
I think this project would have to yours
SQlite included in the HMG samples for
The next version.

I want to tell the sample gave me
I attach compilation Error

------ Solution -----

I added to the file FuelWare.hbp
Sql1.prg.

In file "solution.zip" attached
sql1.prg
error.log
build.3.4.2.bat
build.3.4.2_64.bat

Everything Ok with changes

regards
Mustafa

*--------------------------------------------------- Error Compilation ------------------------------------------------*
Harbour 3.2.0dev (r1509031202)
Copyright (c) 1999-2015, http://harbour-project.org/
hmgleavedate.prg:26:0: warning: ignoring #pragma EMDDUMP [-Wunknown-pragmas]
C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o:main.c:(.data+0x128): undefined reference to `HB_FUN_CONNECT2DB'
C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o:main.c:(.data+0x168): undefined reference to `HB_FUN_SQL'
c:/hmg.3.4.2/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o: bad reloc address 0xf in section `.text.startup'
c:/hmg.3.4.2/mingw/bin/../lib/gcc/i686-w64-mingw32/4.9.2/../../../../i686-w64-mingw32/bin/ld.exe: final link failed: Invalid operation
collect2.exe: error: ld returned 1 exit status
hbmk2[FuelWare]: Error: Ejecutando enlazador. 1
gcc.exe C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/main.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/createdb.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/fueltxn.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/grid2csv.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/grid2html.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/hmganywhere.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/hmgleavedate.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/report.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/tagmanager.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/vehmast.o C:/Users/jorge/AppData/Local/Temp/hbmk_4xv3la.dir/hbmk_qrh9kf.o c:/Hmg.0_Musta_Total_11_03_2016/Sample_Adordd/FuelWare/_temp.o -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbmysql -lmysql -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lsddmy -lhbodbc -lodbc32 -lhbhpdf -lhbfimage -lhbpgsql -lhbnetio -lxhb -lpng -llibhpdf -lhbvpdf -lhbzebra -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib -Wl,--end-group -oFuelWare.exe -Lc:/hmg.3.4.2/harbour/lib/win/mingw -Lc:/hmg.3.4.2/lib

hbmk2: Error: Funci¢n(es) referenciada, no encontrada, pero desconocida:
CONNECT2DB(), SQL()
Attachments
solution.zip
(3.05 KiB) Downloaded 290 times
User avatar
dragancesu
Posts: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: FuelWare

Post by dragancesu »

Great looks

I have not tried it but I did like that so I think we should add this information, state flown kilometer when full, if you need to take into account the average consumption
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: FuelWare

Post by Rathinagiri »

dragancesu wrote:Great looks

I have not tried it but I did like that so I think we should add this information, state flown kilometer when full, if you need to take into account the average consumption
In this software I am giving provision to find out the mileage in a different way. Whenever possible, we can just enter the odometer reading (there is a separate field for entering the odometer reading in the transaction entry between amount and remarks). This will help in a later stage to find out the average mileage of a vehicle.

This can be tracked for any particular expense also (like battery or tyre replacement).

Please comment about my idea also.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: FuelWare

Post by Rathinagiri »

Dear Mustafa,

You have to include HMGSQLite bridge (as you can see in .hbc file) library in the compilation.

Thanks for your solution also.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: FuelWare

Post by bpd2000 »

Thank you Mr. Rathi for sharing excellent code in HMG
Also it is used to learn Sqlite
BPD
Convert Dream into Reality through HMG
User avatar
luisvasquezcl
Posts: 1258
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Contact:

Re: FuelWare

Post by luisvasquezcl »

Very nice Rathi. thanks for sharing.
Best regards
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: FuelWare

Post by Rathinagiri »

I have now attached the HMGSQLite Library file that is required while compiling the software. Please make use of it by copying the library file in hmg lib folder.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
Post Reply