StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7756502
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2011-10-13T15:24:01.073
FavoriteCount
0
LastActivityDate
2011-10-14T04:41:12.063
LastEditDate
2011-10-14T04:41:12.063
LastEditorUserId
929796
OwnerUserId
929796
ParentId
7741244
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Not sure if it's what you are looking as i used a two page design and you would probably use another one to add/edit/delete landmarks but maybe this will give you some ideas. I created a three tables in the database - trip, landmark and landmarktrip with the following definitions. <pre><code>CREATE TABLE IF NOT EXISTS `landmark` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET latin1 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ; INSERT INTO `landmark` (`id`, `name`) VALUES (1, 'Xintiandi'), (2, 'Pearl TV Tower'), (3, 'YuYuan Gardens'), (4, 'Shanghai Botanical Gardens'), (5, 'Shanghai World Financial Centre'); CREATE TABLE IF NOT EXISTS `landmarktrip` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trip_id` int(10) NOT NULL, `landmark_id` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ; INSERT INTO `landmarktrip` (`id`, `trip_id`, `landmark_id`) VALUES (1, 1, 1), (2, 1, 2), (3, 1, 3), (4, 2, 3), (5, 2, 4), (6, 1, 5); CREATE TABLE IF NOT EXISTS `trip` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL, `name` varchar(255) COLLATE utf8_bin NOT NULL, `short_desc` varchar(255) COLLATE utf8_bin NOT NULL, `start_date` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='7741244' AUTO_INCREMENT=3 ; INSERT INTO `trip` (`id`, `user_id`, `name`, `short_desc`, `start_date`) VALUES (1, 1, 'Shanghai 1', 'First Trip To China', '2011-10-13'), (2, 1, 'Shanghai 2', 'Return Visit', '2011-10-21'); </code></pre> And then created models in wwwroot/website/lib/Model as follows Landmark.php <pre><code>class Model_Landmark extends Model_Table { public $entity_code='landmark'; public $table_alias='l'; function init(){ parent::init(); $this->addField('id')->mandatory(true)->system(true)->visible(false); $this->addField('name')->mandatory(true); } } </code></pre> Trip.php <pre><code>class Model_Trip extends Model_Table { public $entity_code='trip'; public $table_alias='t'; function init(){ parent::init(); $this->addField('id')->mandatory(true)->system(true)->visible(false); $this->addField('user_id')->defaultValue($this->api->auth->get('id'))->visible(false); $this->addField('name')->mandatory(true); $this->addField('short_desc')->mandatory(true); $this->addField('start_date')->dataType('date')->mandatory(true); } } } </code></pre> LandmarkTrip.php <pre><code>class Model_LandmarkTrip extends Model_Table { public $entity_code='landmarktrip'; public $table_alias='lt'; function init(){ parent::init(); $this->addField('id')->system(true)->visible(false); $this->addField('trip_id')->refModel('Model_Trip')->mandatory(true); $this->addField('landmark_id')->refModel('Model_Landmark')->mandatory(true); } } </code></pre> Created two pages in wwwroot/website/page, one to add the trips and one for the itinerary as i dont see how with the form approach you are using, you can select which trip you want to see the details of. trips.php <pre><code>class page_trips extends page { function init() { parent::init(); $p=$this; $c=$p->add('CRUD')->setModel('Trip'); $c->setMasterField('user_id', $this->api->auth->get('id')); } } </code></pre> itinerary.php <pre><code>class page_itinerary extends page { function init() { parent::init(); $p=$this; $this->js()->_load('trip_univ'); $triplist=$this->api->db->dsql()->table('trip t') ->field('t.id') ->field('t.name') ->where('t.user_id', $p->api->auth->get('id')) ->order('t.start_date') ->do_getAssoc(); if ($_GET['trip']){ $curr_trip=$_GET['trip']; } else { $earliest=$this->api->db->dsql()->table('trip') ->field('min(start_date)') ->where('user_id',$this->api->auth->get('id')) ->do_getOne(); $curr_trip=$this->api->db->dsql()->table('trip') ->field('id') ->where('user_id',$this->api->auth->get('id')) ->where('start_date',$earliest) ->do_getOne(); } $f=$p->add('Form')->setFormClass('horizontal'); $list=$f->addField('dropdown','trip')->setValueList($triplist)->set($curr_trip); $list->js('change')->univ()->viewTrip($p->api->getDestinationURL(null), $list); $lt=$p->add('CRUD')->setModel('LandmarkTrip'); $lt->setMasterField('trip_id', $curr_trip); } } </code></pre> and one last file which allows the list to change the grid Create a file called trips_univ.js in wwwroot/website/templates/js trip_univ.js <pre><code>$.each({ viewTrip: function(url, name){ document.location.href=url+'&trip='+$(name).val(); } },$.univ._import); </code></pre> So now, you can create trips using the CRUD to add, edit and delete rows. Then go to the itinerary page to select a trip from the dropdown list or it defaults to the earliest trip and can add, remove or edit landmarks from the trip.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to refer filling of one form with the filling of other in Atk4
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USTrevor North
UserOwnerUserId
1. USTrevor North
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.