0
Welcome Guest! Login
0 items Join Now

ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down. Read our Farewell Blog Post for more details.

Interesting Build

Last Post
Search Topic
    • Vybz's Avatar
    • Vybz
    • Sr. Rocketeer
    • Posts: 135
    • Thanks: 1

    Interesting Build

    Posted 13 years 6 months ago
    • My brother asked me about a website he was developing for a new business of his. Basically he is shipping clients cargo in bulk but want to display customers good to only those clients the goods belong to.

      So for example there are three clients; Bill, Lucy and Sam.

      Bill is shipping: 1 bone, 3 cookies
      Lucy is shipping: 1 cookie
      Sam is shipping: 2 lollypops, 3 mints and 2 cookies

      If there is one employee entering everything being shipped how can we display through a webpage a clients order along with its cost to that client alone!

      I have been looking but are there any extensions that can do this?
    #737652
    • Adamck's Avatar
    • Adamck
    • Elite Rocketeer
    • Posts: 546
    • Thanks: 2
    • Web Developer, IT Assistant, Graphics design, App Developer

    Re: Interesting Build

    Posted 13 years 6 months ago
    • Fabrik... i always se fabrik for DB stuff now.

      Create a 'customers' usergroup and a 'staff' usergroup (you can do this in J1.7)

      Create a new 'list' and call it 'Shipping'

      Then create some form elements like
      title - field
      Description - textarea
      Items - Textarea
      Customer - DropDown (gets users from users db table)

      Then have a pre-filter on the table like

      WHERE customer EQUALS {username} APPLY TO 'customers'.

      Then in the form settings you can set the form to be READ ONLY to customers and Editable for 'Staff'.

      The staff can simply log in, create a new user account for the customer, view the form, enter new shipping info and select the customer it applies too...

      When the customer logs in, he sees a list of shipments that have his username in the customer field.

      If its none, he will see none, if its 10 he will see all 10.

      He will also be able to see a detailed view of the shipment and contents etc...

      If it sounds too complex for you (if your not familiar with Fabrik) i can set it up for a Fee 8)
    • Kiss my RSS
    #737664
    • Vybz's Avatar
    • Vybz
    • Sr. Rocketeer
    • Posts: 135
    • Thanks: 1

    Re: Interesting Build

    Posted 13 years 6 months ago
    • Wow this sounds good. I do think i understand what i should do. In any case can you pm me what that fee might be?
    #737777
    • Adamck's Avatar
    • Adamck
    • Elite Rocketeer
    • Posts: 546
    • Thanks: 2
    • Web Developer, IT Assistant, Graphics design, App Developer

    Re: Interesting Build

    Posted 13 years 6 months ago
    • PM sent :)
    • Kiss my RSS
    #737851
    • Terp's Avatar
    • Terp
    • Elite Rocketeer
    • Posts: 1720
    • Thanks: 23

    Re: Interesting Build

    Posted 13 years 6 months ago
    • Yea, whenever someone ask how can I do x,y,z with Joomla in the RT forums, Fabrik is, more often than not, the answer I give them, too. It really is the 'end all, be all' tool for db work. :)
    #742673
    • Adamck's Avatar
    • Adamck
    • Elite Rocketeer
    • Posts: 546
    • Thanks: 2
    • Web Developer, IT Assistant, Graphics design, App Developer

    Re: Interesting Build

    Posted 13 years 6 months ago
    • Haha well someone finally agrees with me, Fabrik is very understated, and you can make it do so much!
    • Kiss my RSS
    #742884

Time to create page: 0.057 seconds