FClearDb, buttons, see before empty

June 16th, 2008   Filed Under Wrk  

English:

  • Added Form FClearDb
  • added buttons see, empty (initial not active)
  • added see functionality: show records in (common) list underneath
  • seeing the lists activates the empty button
  • empty button empties the record list - not yet the database-tables
  • adjusted some modData code for all this
Nederlands:

Upl v 0.0.10

fixes, new FEditInvoice

June 15th, 2008   Filed Under Wrk  

English:

  • fixed bug 1994559 show invoice in list after input: ok
  • started new FEditInvoice with “E” button in front of selected invoice line
  • fixed bug 1981543 new costplace FCostplace: show costplace in list after input
  • adjust screen layout: calculator in invoice, CN box left of invoice SN, Date under calendar, Log got more place for title, justified title and zero button.
  • adjust screen layout: order
Nederlands:

Upl v. 0.0.9

DelSupplier form

June 15th, 2008   Filed Under Wrk  

English:

  • Screen layout, combox select
  • Buttons, from till select
  • Delete button works somehow (rough delete without check but with confirmation afterwards)
  • Selecting supplier provides supplier currency as preset for input of invoice
  • Read default currency from settings
  • Supplier delete: Adjusted delete reaction to mention deleted supplier
  • replaced everywhere - I hope - the word “valuta” with “currency” + adjusted tables!
  • Completed Dutch translation till this version (mostly finished)
Nederlands:

  • Nederlandstalige schermteksten ingevuld, bijna alle volledig tot op huidige versie

Upl snapshot 0.0.8

data/img subdirs, FDelSupplier, About-version

June 13th, 2008   Filed Under Wrk  

Upl v 0.0.7

check new supplier name, log textbox, form names

June 12th, 2008   Filed Under Wrk  

English:

  • enlarge log textbox for some seconds on click
  • adapted all form names from frmMain to FMain naming convention
  • supplier “load” now acts as reload, not just from cache but from database (bug 1991829)
  • supplier save with check on similar first characters and possibility to cancel save.
  • supplier window shows similar entries in feedbackzone underneath

Upl 0.0.6

Nederlands:

calculator logo, config tabs

June 11th, 2008   Filed Under Wrk  

English:

  • added complex interface pref - doesn’t work yet!
    mniVwComplex_Click() zet de visible eigenschap van elementen op het scherm, wat werkt in een bestaand scherm, maar blijkbaar niet voor het scherm geopend is?
  • added checkbox to protect for change of database parameters
  • added tabs to tools, preferences: General, DbConnect
  • changed calculator png’s

Upl 0.0.5

Nederlands:

Basic facs

May 24th, 2008   Filed Under Concepts, Lang:EN  

(lees in Nederlands)

This project was started to replace an existing application in Foxpro 2.6 running on Windows98 (data in files on NT server, program in proprietary IDE)

Target: desktop RAD on Linux: Gambas (v2.x), inexpensive database on server (MySql on Linux).
Task: monitoring of the cost of units in a production company.

Most costs come in as invoice.

The invoice can contain costs for separate units in the company;
like departments, products or product lines, .. (costcenter).
Pro costcenter we need the totals:

Registration can go further; next to the costcenter, there is the kind of cost: resources, raw material, etc.

fi: production line 1 :
- products (raw material) and resources, investments, employee cost, other.

For the investments, we want to spread the cost over several years: every year same or other amount of total.

Afterwards we want answers on these questions:
- what is the total cost of the incoming invoices past year?
- what is the total cost of the running year until now
, pro department / costcenter?
- what is the cost of investments that are shifted forward to next year/years?

For the moment we don’t look at other costs that do not come on invoice, like financial costs, taxes, etc,
so results of these invoice data has to be integrated in the bigger picture in the company.

(images: wig, OOo, KSnapshot)

Basis van facs

April 25th, 2008   Filed Under Concept  

(read in English)

Ontstaan: bestaand programma vervangen van verouderd platform.

Oorsprong: Windows98 + Foxpro 2.6. (data in files op server, proprietary IDE)

Wordt: desktop RAD op Linux: Gambas (v2.x), goedkope database op server (MySql op Linux).
Doel: opvolgen van de kosten van eenheden binnen een bedrijf.

Meeste kost komt binnen als factuur:

De factuur kan kosten bevatten voor verschillende afdelingen, produkten, lijnen (costcenter).

Per costcenter wordt een totaal gemaakt:

Een fijnere onderverdeling is mogelijk, zoals onderscheid tussen de plaats van de cost en de aard van de cost.

Bv: produktielijn 1 : producten (grondstoffen) en hulpmiddelen, aankopen en investeringen, personeelskost, andere.

Bovendien kan nu een factuur binnenkomen waarvan je het bedrag wil verdelen over dit - en een aantal toekomstige jaren:

Beantwoorden van:
- wat is totale kost inkomende facturen voorbije jaar?
- wat is die totale kost tot nu toe van het huidig jaar, per afdeling?
- wat is de kost door investeringen die al rust op volgende jaren?
wordt hiermee mogelijk.

Naast facturen kunnen ook andere kosten gelden (lonen, belasting, financiele, ..), dus nabewerking van de cijfers is nodig.

(images: wig, OOo, KSnapshot)

Dev notes april 2008

April 24th, 2008   Filed Under Wrk  

080424 - redesign Assign visable/not, extended data of invoice, ClsInvoice
080423 - storing the invoice data, order of screenelements
080422 - check invoice complete + incomplete explanation in error
080421 - head+detaillines show in lsbx
080414-8 - detailline and heafdline define and adjust tabel
080407 - Number of suppliers: 172?? but combobox contains more? : list is loaded 2 x
080404 - result available on higher level? or.. ?? OK: make res on higher level, let it fill by procedure in mod with as returnvalue the resultset.
080403 - Load Todo text from file “Todo.txt” in Data folder : is not a folder!