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: 5266
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 171 times
Been thanked: 173 times
Contact:

FuelWare

Post by Rathinagiri » Fri Mar 11, 2016 8:14 am

fuelware.png
fuelware.png (105.56 KiB) Viewed 2941 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 283 times
You should include the following library file before compiling using IDE in the /lib folder.
libhmgsqlite.zip
(2.5 KiB) Downloaded 237 times
Compiled Executable
FuelWareExe.zip
(2.09 MiB) Downloaded 238 times
Help
fuelware_help.zip
(2.51 MiB) Downloaded 250 times
Now it is time for some screenshots: :)

Main Screen
fuelware01.jpg
fuelware01.jpg (75.9 KiB) Viewed 2941 times
Transaction Entry Screen
fuelware02.jpg
fuelware02.jpg (76.14 KiB) Viewed 2941 times
Vehicle Management Screen
fuelware03.jpg
fuelware03.jpg (75.19 KiB) Viewed 2941 times
Tag Management Screen
fuelware04.jpg
fuelware04.jpg (66.27 KiB) Viewed 2941 times
Report Screen
fuelware05.jpg
fuelware05.jpg (71.88 KiB) Viewed 2941 times
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
serge_girard
Posts: 2372
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 629 times
Been thanked: 126 times
Contact:

Post by serge_girard » Fri Mar 11, 2016 8:17 am

Thanks Rathi for sharing !

Serge

User avatar
mol
Posts: 3252
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 235 times
Been thanked: 132 times
Contact:

Post by mol » Fri Mar 11, 2016 9:10 am

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: 862
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Been thanked: 132 times
Contact:

Post by mustafa » Fri Mar 11, 2016 10:02 am

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 138 times

User avatar
dragancesu
Posts: 722
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 24 times
Been thanked: 151 times

Post by dragancesu » Fri Mar 11, 2016 10:08 am

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: 5266
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 171 times
Been thanked: 173 times
Contact:

Post by Rathinagiri » Fri Mar 11, 2016 10:39 am

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: 5266
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 171 times
Been thanked: 173 times
Contact:

Post by Rathinagiri » Fri Mar 11, 2016 10:40 am

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: 1104
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 203 times
Been thanked: 109 times

Post by bpd2000 » Fri Mar 11, 2016 12:47 pm

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: 1145
Joined: Thu Jul 31, 2008 3:23 am
Location: Chile
Has thanked: 14 times
Been thanked: 14 times
Contact:

Post by luisvasquezcl » Fri Mar 11, 2016 2:06 pm

Very nice Rathi. thanks for sharing.
Best regards

User avatar
Rathinagiri
Posts: 5266
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 171 times
Been thanked: 173 times
Contact:

Post by Rathinagiri » Fri Mar 11, 2016 3:07 pm

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