Welcome, Guest
Username: Password: Remember me

TOPIC: How to save multiple values into multiple tables?

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

  • msantana
  • msantana's Avatar
  • Offline
  • New Member
  • Posts: 17
  • Thank you received: 1
  • Karma: 0
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
The administrator has disabled public write access.

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

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
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 administrator has disabled public write access.
The following user(s) said Thank You: msantana

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

  • msantana
  • msantana's Avatar
  • Offline
  • New Member
  • Posts: 17
  • Thank you received: 1
  • Karma: 0
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
The administrator has disabled public write access.
Time to create page: 0.095 seconds

Get Started