It would be great to have an app like pastebin for web2py models,
possibily using some convention to allow cooperation, and organized by
sector.
On Jul 19, 1:51 am, Kenneth <kenneth.t.lundst...@gmail.com> wrote:
> Here is the model för tracker_person_product that tracks sellings, if
> a person doesn´t have a entry in the tracker on an specific campaign
> he doesn´t belong to that campaign.
> Troop_person is the table where sellers a stored and well campaign is
> the campaign table.
>
> db.define_table('tracker_person_product',
> db.Field('troop', db.troop, required=True),
> db.Field('troop_person', db.troop_person, required=True),
> db.Field('campaign', db.campaign, required=True),
> db.Field('product', db.product, required=True),
> db.Field('count_received', 'integer', required=True,
> requires=IS_INT_IN_RANGE(0, 1000000)),
> db.Field('count_sold', 'integer', required=True,
> requires=IS_INT_IN_RANGE(0, 1000000)),
> db.Field('count_returned', 'integer', required=True,
> requires=IS_INT_IN_RANGE(0, 1000000)),
> db.Field('count_paid', 'integer', required=True,
> requires=IS_INT_IN_RANGE(0, 1000000)),
> db.Field('edited_by', db[user_table], required=True),
> db.Field('edited_date', 'datetime', required=True))
>
> db.define_table('troop_person',
> db.Field('name', 'string', required=True),
> db.Field('troop', db.troop, required=True),
> db.Field('troop_group', db.troop_group, required=True),
> db.Field('reward_selected', 'integer', default=0),
> db.Field('edited_by', db[user_table], required=True),
> db.Field('edited_date', 'datetime', required=True),
> db.Field('surname', 'string', required=False))
>
> db.define_table('campaign',
> db.Field('title_fi', 'string', requires=IS_NOT_EMPTY()),
> db.Field('title_se', 'string', requires=IS_NOT_EMPTY()),
> db.Field('starts', 'date', requires=IS_DATE(format=T('%Y-%m-%d'),
> error_message=T('must be YYYY-MM-DD!'))),
> db.Field('ends', 'date', requires=IS_DATE(format=T('%Y-%m-%d'),
> error_message=T('must be YYYY-MM-DD!'))),
> db.Field('description_fi', 'text'),
> db.Field('description_se', 'text'),
> db.Field('hidden', 'boolean'),
> db.Field('district', db.district, default=0),
> db.Field('created_by', db[user_table], required=True),
> db.Field('created_date', 'datetime', required=True),
> db.Field('edited_by', db[user_table], required=True),
> db.Field('edited_date', 'datetime', required=True),
> db.Field('main', 'boolean', default=False))
>
> When polulating the tracker table form I use
>
> person_data = db((db.tracker_person_product.troop_person ==
> db.troop_person.id)
> &(db.tracker_person_product.troop == troop.id) \
> &(db.tracker_person_product.campaign == campaign.id)) \
> .select(db.troop_person.ALL, orderby=db.troop_person.name,
> distinct=True)
>
> and when I want to find sellers not in the campaign I use
>
> person_data = db((db.tracker_person_product.troop_person ==
> db.troop_person.id)
> &(db.tracker_person_product.troop == troop.id) \
> &(db.tracker_person_product.campaign != campaign.id)) \
> .select(db.troop_person.ALL, orderby=db.troop_person.name,
> distinct=True)
>
> Kenneth
>
> On Jul 19, 2:40 am, "mr.freeze" <nat...@freezable.com> wrote:
>
> > You could probably do it with IS_IN_DB depending on your model. I
> > would personally create a widget since they are more flexible and
> > intuitive to me. If you show your model then I can help you.
>
> > On Jul 18, 6:27 pm, Kenneth <kenneth.t.lundst...@gmail.com> wrote:
>
> > > Hello,
>
> > > I have a case where I have a table of sellers, a table of campaigns
> > > and then a tracker to follow how much each seller is selling. All
> > > sellers are not in all campaigns, the tracker keeps track of witch
> > > seller belongs to which campaign.
>
> > > To adminitrate this I´m trying to make a drop down list where I could
> > > select one och multiple sellers not in the campaign and add them to
> > > the campaign.
>
> > > Is this possible with SQLFORM or SQLFORM.factory or any other ready
> > > function or do I have to make something myself?
>
> > > Kenneth
