Rich sticky notes
Q Core / Shady Hollow
I am glad that you have looked at thegolfhub.net
which shows Magnacarta
What you are writing is a replacement for Magna Carta
But as I have had to specify what is required I have gone to the point where I have included the Development of Q Core and Shady Hollow.
I have decided that Q Core is as simple as a switch case.
It took me about 3 hours to knock Road Runner up I will need to go back to it to write the narratives on the screen - I jhave not done that yet.
I will do it after you have agreed that Richard Gilbert Infonet if the way forward that you want.
If not you are going to have to do small goole documents that I can follow.
Thank You for sticking with me - this is turning out to be really simple.
More Simple than I thought.
Progress 24.06/2021 - 02:20:00
I have put all the other transaction that I have given you in the past in the restricted zone - there is interesting stuff that I an certain you have not been reading. Hd you read all that I have been doing I an certain that you would have shown more interest.
Anyway we are getting there I am doing the design that you want I may go to the extreme and do some PSUDO CODE for you.
This should be making your life really easy - I wanted you to play a major part of the design so that it would be your product.
I suggest that you call your domain name RichardGilbert.uk
as this development now contains significantly more than Magna Carta it includes Shady Hollow and will go on to include Purchase ledger / Sales Ledger Nominal Ledger and Payroll / Personnel / Hr But it will all be simple stuff and should take no time at all to complete.
There is more effort in the specification than in the doing.
Thanks for your prompt response / Input.
I need to ask you your thoughts on the ledgers !!!!!
24/06/2021 10:45:00 Nimrod / Pegasus
/ Hi Rich
I am working so hard at the moment - I have been up all night - can’t sleep with it
Check out redcamelsystems for Nimrod and pegasus agile.
That should give you focus as it is just two tables
Q Core has got up to 14 tables and needs to be scheduled.
There is probably about 5 hours work to top as it is all simple sql stuff.
My app will “deliver a directory of protopage golf club users into the golfing community”. http:://redcamelsystems.com/n/undex.html Nimrod
This is the immediate initial requirement which is public we will then follow it up with Q Core to odd password processing by establishment figure.
Followed by Shady Hollow which is a virtual cemetery as many members of golf clubs have their ashes laid on the course.
Here is my usual request to my Senior Programmer…… This would take the form of a one page PSR - Program Service Request - I would leave the design up to the programmer. Where complex code was involved I would do a design Specification of the formulae. Not the reams of information that I send you.
Please convert excel spread sheet into a sql server application with menus add Amed delete and enquiry functions 0 Enquiry by Country / County and Hub
I would have thought you could knock out :
1 a menue in 1/2 hour
2. An Insert transaction in an hour
3 An amend transaction in 3 hours
4 A delete Transaction in 2 hours
5 An enquiry by country in 2 hours
6 an enquiry by county in 1 hour
5 an enquiry by hub 2 hour
8 Structure table insert / amend / delete cones say 2 1/2 hours.
Total 14 hours - but I bet with your experience and portfolio / examples you could knock it off in a day.
Q core is something different I am going to have to write a feasibility document / design review document to see if I have the correct tables.
I have included job accounting in my schema - that is a long way down the track that will be subject to feasibility too.
As Paul wrote the initial Q I would like him to take responsibility for Q Core. It could be as little as a days coding but it is complex.
Thanks for your feedback I am trying to make like simple by doing a complete specification view by view / class module by class module
Thanks for all your feedback you have given me the drive to program all the systems that I have been thinking about doing for may years.
Could you answer me this :
If your boss came to you with am Excel spreadsheet at 9 am I’m the morning and asked you to pencil out a system for him by 10 am what views / password control / registration / ;login would recommend.
Then if you were asked to attend a meeting at 2pm with a client to discuss costs - how many man hours would you say.
Plain sticky notes
Company Structure - Nimrod Table 001
Company Structure Table 0 Parent 1 Level 2 Child 3 Nominal Ledger Code
Stock Recording - Click and Collect - Mayflower Table M1
0 Item Number 1 Item Description 2 VAT Indicator 3 Unit 4 Price 5 Image
Golf Club - Nimrod Table 002
Golf Club Table 0 Golf Club 19 Club Image 1. Country 2 County 3 District 9 Golf Hub Name 4 Club Email Address6 7 WWW Address of Primary URL 8 Club Protopage URL 17 Telephone Number 18 Pro Shop Telephone Number 10 Golf Professional Name 11 Golf Professional Protopage URL 17 Golf Professional Email address 18 Golf Professional Image 12 Trackman Indicator 13 GASP Indicator 14 YMG Indicator 15 Bitesize Golf Indicator 16 Golf Foundation Indicator 20 Golf Club Address Line 1 21 Golf Club Address Line 2 22 Golf Club Address Line 3 23 Golf Club Address Line 4 24 Golf Club Address Line 5 5 Postcode 6 What 3 Words 25 Conference Capacity
Vat Invoice - Click and Collect - Mayfmower Table M2
0 Item Number 1 Description 2 Quantity 3 Cost 4 VAT 5 Date 6 Time
Q Core - Table Q1
0 Establishment Code 1 View / Class Module
Client Profile - Q Core Table Q2
0 Client 1 Hyper Administrator flag 2 Administrator Flag 3 User Flag 4 Competition Administrator Flag
General Ledger Table - Click and Collect - Mayflower Table M3
General Ledger Table 0 General Ledger Code 1 Description
Payroll - Erasmus Table E1
0 Employee id 1 Employee Name 2 Employee Protopage URL 3 Employee TimeBank URL 4 Employee Hourly Rate
Establishment Table - Q Core Table Q3
Establishment Table 0 Establishment 1 Establishment Description 2 Hayes Grade 3 Hayes Scale
Shady Hollow Cemetery - Shady Table S1
Personnel - Q Core Table Q4
0 Client id 1 Client Email Address 0 Establishment Code
Password Table - Q Core Table Q5
0 Hyper Administrator Password 1 Administrator Password 2 User Password 3 Competition Administrator Password
Shop - Nimrod Table 003
00 Golf Club ID 0 Article 1 Article Description 2 RRP 3 Black Friday Sales Price 4 January Sales Price 5 Spring Sales Price 6 Stock Clearance Price 7 Manchester Discount Card Price
Routing - Quo Vadiz Table QV1
0 Operation Number 1 Part Number 2 Task number 3 Task Description 4 Start Qty 5 End Qty 6 Scrap 7 Split Batch Qty 8 Start Time 9 End Time 10 Pay Grade 11 Pat Scale 12 job number 13 Operator (Client) 14 Pieces Completed
Hayes Table - Q Core Table Q6
Hayes Table 0 Hayes Grade 1 Hates Scale 2 Annual Salary
Manchester Discount Card - Nimrod Table 004
0 Business Name 1Email Address 2Telephone Number 3Protopage URL
Greenpages - Greenpages Table G1
0 Business Name 1 Business Image 2 Business Email Address 3 Business Protopage Account 4 Business Phone Number
Job Details - Quo Vadiz Table QV2
0 Job Number 1 Operation 2 Standard Time 3 Bonus Value
Task Register - Zues Table Z1
0 Task id 1 Task Description
Task View (Many to Many) - Zues Table Z2
0 Task ID 1 View ID
Bonus Payments - Quo Vadiz Table QV3
0 Operator (Client) 1 Bonus Code 2 Bonus Value 3 Nominal Ledger Account Code
View Register - Zues Table Z3
0 View ID 1 Project 2 View Description
Medigolf Tutor - Zues Table Z4
0 Tutor id 1 Email Address 2 Image 3 Protopage Account
Medigolf Transaction 0 Zues Table Z5
0 Tutor E'Mai; address 1 Student Email Address 2 Transaction Number 3 Student Comments 4 Tutor Comments
Medigolf Tutor/Student - Zues Table Z5
0 Tutor ID 1 Student ID
Medigolf Student - Zues Table Z6
0 Student ID - Client 1 Email Address 2 Protopage URL 3 Srudents Comments
Student Uploads - Zues Table Z7
0 Student ID - Client 1 YouTube URL 2 Description
Rich sticky notes
SQL Design - Q Core
All tables to contain Date/Time Stamps and Table ID
Rich sticky notes
When establishing the Protopage Login Passwords there has to be signature processing.
There will be 4 variables :
Hyper Administrator = H
Administrator = A
Competition Administrator = C
User = U
These four elements will need concatenation into a string for use in a switch case.
A Switch case of Vale HACU
Will have System MessaGe H exposed / System Message A / System Message C exposed and System Message U exposed.
The value of System Message H will be : The Primary Password is H (where h is derived from a control table containing H and the Password value.
Where the case is (space)(space)(space)U Then only system Message U is Exposed.
Rich sticky notes
Rich text note
Note : The Login Establishment code will be used in job accounting to determine the cost of transaction.
ghlogin shoud contain a text box for userid input
The processing should then go through CLSelection to determine what Protopage Pages are needed.
Then throuhgh CLSignatures to determine the system messages.
ghlogin requires 5 text boxes for systems messages
1. System Message 1
2. System Measage H
3 System Message A
4 System Message U
5 System Message C
Sytem Messages are as follows :
1. Your passwords are now available - Remember to click the chevrons on the right hand side og protopage to expose your pages.
H - Your Hyper administrator passwors is : WS-H
A - Your Administrator Password is : WS-A
U - Your User Password is WSU
C - Your Competition Administrator Password is : WS-C
Where WS-H ETC is woking storage and is used to access the following password table
H / Master
A / Admin
U / Lessons
C / Competitions