Page 1 of 2
FuelWare
Posted: Fri Mar 11, 2016 8:14 am
by Rathinagiri
- fuelware.png (105.56 KiB) Viewed 6097 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:
You should include the following library file before compiling using IDE in the /lib folder.
Compiled Executable
Help
Now it is time for some screenshots:
Main Screen
- fuelware01.jpg (75.9 KiB) Viewed 6097 times
Transaction Entry Screen
- fuelware02.jpg (76.14 KiB) Viewed 6097 times
Vehicle Management Screen
- fuelware03.jpg (75.19 KiB) Viewed 6097 times
Tag Management Screen
- fuelware04.jpg (66.27 KiB) Viewed 6097 times
Report Screen
- fuelware05.jpg (71.88 KiB) Viewed 6097 times
Re: FuelWare
Posted: Fri Mar 11, 2016 8:17 am
by serge_girard
Thanks Rathi for sharing !
Serge
Re: FuelWare
Posted: Fri Mar 11, 2016 9:10 am
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!
Re: FuelWare
Posted: Fri Mar 11, 2016 10:02 am
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()
Re: FuelWare
Posted: Fri Mar 11, 2016 10:08 am
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
Re: FuelWare
Posted: Fri Mar 11, 2016 10:39 am
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.
Re: FuelWare
Posted: Fri Mar 11, 2016 10:40 am
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.
Re: FuelWare
Posted: Fri Mar 11, 2016 12:47 pm
by bpd2000
Thank you Mr. Rathi for sharing excellent code in HMG
Also it is used to learn Sqlite
Re: FuelWare
Posted: Fri Mar 11, 2016 2:06 pm
by luisvasquezcl
Very nice Rathi. thanks for sharing.
Best regards
Re: FuelWare
Posted: Fri Mar 11, 2016 3:07 pm
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.