Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

How to save multiple values into multiple tables? 11 May 2015 18:37 #12974

I had FORKed the component in order to retrieve the necessary information from my related tables. Check out my screen dump screen shot attached.
This is what I trying to do.
On my normal "Contract" Item view whenever I create a new contract I Only see what you can see in my attached image as "original item info". After saving it it basically goes to a "Contract with Assets" view with in the same model. The Idea is that after saving the contract I can add multiple assets instead of going to add one asset at the time like I originally generated the component with JCOOK.

Therefore I was able to include my other Related items following the JCOOK ideas of retrieving that info. That is not the problem. The problem is that after I choose all the different asset I am not sure what is the best way to save those related "asset" in the asset table since my model is related to "contract"

Please help.

This is a sample of the code used to retrieve the related items in my "contract" model view
$model_asset_id = CkJModel::getInstance('Assets', 'MyComponnentappModel');
		$model_asset_id->addWhere('a.client_id = '.$this->item->client_id); /* To restrict it to only those related to my current Item */
		$model_asset_id->addGroupOrder("a.client_id"); 
		$lists['fk']['asset_id'] = $model_asset_id->getItems();
		
		$model_support_level_id = CkJModel::getInstance('Supportlevels', 'MyComponnentappModel');
		$model_support_level_id->addWhere('a.vendor_id = '.$this->item->vendor_id);	/* To restrict it to only those related to my current Item */
		$model_support_level_id->addGroupOrder("a.vendor_id");
		$lists['fk']['support_level_id'] = $model_support_level_id->getItems();

Please help.

How should I modify my controller in order to save the other data when saving?
MS - Lyquix

Please Log in or Create an account to join the conversation.

How to save multiple values into multiple tables? 12 May 2015 14:06 #12975

I think the code you are looking for is updateXref

www.j-cook.pro/index.php/u/updatexref
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The following user(s) said Thank You: msantana

Please Log in or Create an account to join the conversation.

How to save multiple values into multiple tables? 01 Jun 2015 14:29 #13207

I tried your suggestion but at the end I did not work.

I explain my issue in the following post that I made in Jcook posting.
www.j-cook.pro/index.php/forum/trouble-s...ct-id-for-a-new-item
MS - Lyquix

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.363 seconds

Although I found this tool some time ago I just started learning experimenting and building this first component on Monday and now on Thursday afternoon it's already online. Although I already had a working version done with another tool this is much easier to build and at the end you have the freedom to own your own component. Once you know how to use Cook you will boost your productivity as the learning curve is really moderate compared to many other tools.
Giori (Forum)

Get Started