Welcome, Guest
Username: Password: Remember me

TOPIC: Paid request for assistance (1 to n relatio)

Paid request for assistance (1 to n relatio) 18 Nov 2012 18:11 #5474

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 15
Admin

I have created a project called 'MOLE Timeline' in my builder.. two simple tables

Timeline
Timeline Elements (linked to a timeline)

I have uploaded some basic data so you can see it in action.. basically the timeline elements are linked to Timeline by a foreign key. I need it so that when you view a TIMELINE ITEM, it also shows at the bottom of the item a GRID with all associated TIMELINE ELEMENTS.. in other words a 1 to N relationship.

Show both should show 4 elements each

You have described how to do this several times, but due to a massive workload in my day job creating Mobile Apps, I have not been able to give this much time, and when I did today, I am getting no errors, but no attemps at a query either.

If you could alter my project with the appropriate code, or alter it and zip / email to me (This email address is being protected from spambots. You need JavaScript enabled to view it.) so I can see how this works PROPERLY, I can then use that knowledge for future projects,

If the front end section is any different, could you also give them the same treatment,

I would imagine this is basic stuff for you, and will happily transfer.. 25 euros? (acceptable?) if you can quickly do this. I will pay before this work if need be if you say you can get round to it.
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
Last Edit: 21 Nov 2012 11:22 by MorganL.
The administrator has disabled public write access.

Re: Paid request for admin assistance (1 to n relatio) 18 Nov 2012 18:19 #5475

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 15
just an example so my rather long request makes some sense.. a screen shots of how I image it to be.. a grid adding into the ITEM under the form brick, that lists associated timeline elements

Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Re: Paid request for admin assistance (1 to n relatio) 21 Nov 2012 08:57 #5544

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 15
Hi admin

do you have the spare time to address this issue, or are j-cook updates sucking up all your free time?
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 21 Nov 2012 11:28 #5557

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 15
OK opening the floor to anyone who can assist. Work has me configuring a conferencing server at the moment and I cant get even a few mins to work this out.

Anyone who can confidently, and using proper j-cook coding can make it so that when I view an item, it has a grid that shows all related items based on a foreign key in a grid can have the 25 euros.

Table 1 (Timeline)
Table 2 (Timeline elements) with a foreign key called timeline that links to table 1

When I view an item from table one, it should list, in a standard grid, all the related elements

Many thanks
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 21 Nov 2012 14:37 #5566

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
Hi Morgan,

When you adress a request, please do it through an open way. Everybody can help you on that.

Nobody ?
If it is only for a view, it is really easy, even with filters.
I hope somebody will help you. I've just read your topic, but accept it in few days if nobody offers.

I tell to readers, these are 25€ really easy, and sure Morgan will appreciate to pay for it. It is a wining-wining stuff here.

To Morgan, you can also save this money because the answer is on the forum for sure many times.
Coding is now a piece of cake
Last Edit: 21 Nov 2012 14:50 by admin.
The administrator has disabled public write access.
The following user(s) said Thank You: MorganL

Re: Paid request for assistance (1 to n relatio) 21 Nov 2012 14:49 #5567

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 15
So take the money.. please XD

You have the advantage methinks of sandbox access and can demonstrate how the master would do it. In one of the biggest, most recent topics of this type of discussion there is no 'end answer' as you actually did the work.. so following that thread is like reading a story with the end chapter missing.

I have just started touching on this component now since I completely redid it in J-Cook and the framework generated by v2.0 is very advanced and its like learning a new language, eventually, given a week I will grasp it, but I dont have that week spare, which is frustrating me greatly!

I have (as seen in another post) just noticed the difference in how selects are generated and that is yet another thing to learn.
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 21 Nov 2012 16:32 #5585

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
For the moment I am busy, but in few days OK.

I will post here before to start the job. So until I didn't started, somebody can propose itself as well.
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 05 Dec 2012 09:29 #5827

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
Did you got it ?

My time is now available for you if you want.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: MorganL

Re: Paid request for assistance (1 to n relatio) 05 Dec 2012 13:53 #5839

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 15
Sure, go for it.

So to clarify i have setup an example project called MOLETimeline, each TIMELINE has several TIMELINE ELEMENTS all with a FK refering to the appropriate TIMELINE(id)

I want it so when you view a TIMELINE ITEM in the front (important) and backend, it has a FLY BRICK that has all the associated TIMELINE ELEMENTS GRID. I suspect the principal is the same for both front and backend

I understand you are busy, but if you could put in a few notes just explainingwhat is happening so I can use this as a learning tool, I would be very grateful.

I will send the paypal payment tomorrow regardless of whether you have had chance to complete the work or complete or not. Many thanks
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 08 Dec 2012 10:59 #5934

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
Job done.

I've just emailed you the component.
Enjoy it. ;-)
Coding is now a piece of cake
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 08 Dec 2012 12:52 #5938

  • jcasanova
  • jcasanova's Avatar
  • Offline
  • Senior Member
  • Posts: 40
  • Thank you received: 1
  • Karma: 1
Ohhh are you gonna post it? I was hoping to look at the code to know how to do it :(
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 08 Dec 2012 13:21 #5939

  • JoomGuy
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
  • Karma: 64
Hi @jcasanova

Have you seen @admin's post about how to do it?
Please see: j-cook.pro/forum/9-coding-inside-your-co...ted-table--item#3804

It's very comprehensive so you should be able to achieve it following the example.

Gez
Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!
The administrator has disabled public write access.

Re: Paid request for assistance (1 to n relatio) 08 Dec 2012 18:44 #5941

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
I explained many times for N:1 and N:M

a french tutorial to download (in french) :
www.j-cook.pro/files/workshop.zip

(Covering basic stuffs...)

I cannot share a private component.
Ask it to Morgan.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: edwardcox
Time to create page: 0.096 seconds

Get Started