Youth Sports Sites

Gathering of Joomla! developers and users in the non-profit community.

Moderators: tydust, cozimek

Forum rules
nickolai
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Dec 22, 2006 4:28 pm
Location: Asheville, NC
Contact:

Re: Youth Sports Sites

Post by nickolai » Tue Feb 06, 2007 5:15 am

Here's my suggestion:

Set email activation required to "no" then configure in CB config page the first page the user sees after clicking "send registration" to the product page, thus making the workflow pretty smooth.  Also, provide multiple menu links (in user menu and main menu) so users can find there way back to the product page if they can't make the payment at that time but want to.

Register on my site http://www.ashevillesoccer.net and let me know how/if it flows...  just choose "mail in check" so you don't have to pay!

-Nick
Nick Miletich
Asheville, NC Web Design
http://www.nickmiletich.com

cgarst
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Feb 07, 2006 8:58 pm

Re: Youth Sports Sites

Post by cgarst » Wed Feb 07, 2007 4:21 am

For these fields in virtuemart configuration page, are yours set this way, here are mine:

User Registration Settings
Use silent (hidden) user registration? (Checked Yes) When enabled, users don't need to fill in a username and password for a new account. Instead the email address is used for the new account and a random password is generated. The registration details are mailed to the customer.

These are green, and don't look like they can be changed.

Joomla!: User registration allowed? Yes
Joomla!: New account activation necessary? No

nickolai
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Dec 22, 2006 4:28 pm
Location: Asheville, NC
Contact:

Re: Youth Sports Sites

Post by nickolai » Sat Feb 10, 2007 7:52 pm

Chuck,

I wasn't able to get that to work (see below).  Any suggestions? 

Thanks man, Nick Miletich


For your second question, only way I can think of doing it easily would be to to make a copy of the report (and directory, etc. in jamboreport component) and modify it so that the VM fields are not trying to be pulled and merged into the CB fields.  Since it has a join clause if there is no payment information, then it will not show up on the report. 

Just take out or comment out these lines :

      // GET ORDER TYPE FROM VM ORDER PAYMENT TABLE
      $qb->select( 'p.payment_method_id AS PmtMethod' );

      // SELECT FIELDS FROM ORDERS TABLE

      $qb->select( 'o.order_id AS OrderNo' );
      $qb->select( "FROM_UNIXTIME(o.cdate,'%c-%d-%y') AS Orderdate" );
      $qb->select( 'o.order_total AS Amount' );
      $qb->select( 'o.order_status AS Status' );
      $qb->select( 'o.customer_note AS OrderNote' );
      $qb->from( '#__vm_orders AS o' );

Remove this join :
$qb->join( 'LEFT', '#__vm_order_payment AS p ON o.order_id = p.order_id' );

This probably will do the trick....
Nick Miletich
Asheville, NC Web Design
http://www.nickmiletich.com

bluepixel.ch

Re: Youth Sports Sites

Post by bluepixel.ch » Sun Feb 11, 2007 2:42 am

cgarst wrote:For these fields in virtuemart configuration page, are yours set this way, here are mine:

User Registration Settings
Use silent (hidden) user registration? (Checked Yes) When enabled, users don't need to fill in a username and password for a new account. Instead the email address is used for the new account and a random password is generated. The registration details are mailed to the customer.

These are green, and don't look like they can be changed.

Joomla!: User registration allowed? Yes
Joomla!: New account activation necessary? No


having exactly the same problem!

nickolai
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Dec 22, 2006 4:28 pm
Location: Asheville, NC
Contact:

Re: Youth Sports Sites

Post by nickolai » Sun Feb 11, 2007 3:52 am

"cgarst" solved it by downloading the newest cb virtuemart plugin, I've attach it to this post.  (the plugin is installed in the CB plugin management section).

-Nick
Attachments
plug_virtuemart_0.1.9-unzip-first.zip
(4 KiB) Downloaded 46 times
Nick Miletich
Asheville, NC Web Design
http://www.nickmiletich.com

cgarst
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Feb 07, 2006 8:58 pm

Re: Youth Sports Sites

Post by cgarst » Mon Feb 12, 2007 5:20 am

Nick - I will let you know when I get the report working to display all, just have to mess with it a little...

Chuck

nickolai
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Dec 22, 2006 4:28 pm
Location: Asheville, NC
Contact:

Re: Youth Sports Sites

Post by nickolai » Mon Feb 12, 2007 9:10 pm

Chuck,

Great, I look forward to seeing it because I hit a road block!
Nick Miletich
Asheville, NC Web Design
http://www.nickmiletich.com

cgarst
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Feb 07, 2006 8:58 pm

Re: Youth Sports Sites

Post by cgarst » Tue Feb 13, 2007 9:00 pm

Nick -
I messed around with it some, the only way I could get it to work is to just have the cb fields, and take out the email and join clause. Since they are in different tables, the join clause has to identify both fields that are the same in both tables, which is 'id' . I will let you know if I can figure out the join clause, it is a pain.  This will get you the listing you need but without the email address.  I suppose that for now if you want to put another field in cb for email that would do the trick.

Thanks,
Chuck

nickolai
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Dec 22, 2006 4:28 pm
Location: Asheville, NC
Contact:

Re: Youth Sports Sites

Post by nickolai » Tue Feb 13, 2007 9:17 pm

That's great.  Can you attach it to a post?  :pop

-Nick
Nick Miletich
Asheville, NC Web Design
http://www.nickmiletich.com

cgarst
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Feb 07, 2006 8:58 pm

Re: Youth Sports Sites

Post by cgarst » Wed Feb 14, 2007 1:46 am

// GET FIELDS FROM CB

$qb->select( 'r.cb_xxxxx AS xxxxx' );
put rest of any fields you want to display

// SORT

$qb->order( 'cb_playerlastname' );

make sure you remove the join statements, and reference to the email select.

BoardBoss
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Mar 18, 2006 10:41 am

Re: Youth Sports Sites

Post by BoardBoss » Mon Mar 05, 2007 5:44 pm

imNotScott wrote:I have built my own registration system for the Fall 2006 season.  It's almost complete, but not yet ready to share with the world.  Since I'm a PHP newbie, I didn't build it as a Joomla module, but just straight PHP forms.

I've also done a lot of work on a back end league management application, but built that as a Java-Struts application.

I imagine the registration forms part could be wrapped inside a Joomla page but it is customized for our Club so I doubt it would be of much use to anyone else but me.


Scott(not) can you please contact me via email or PM to discuss this project? Thanks!


Post Reply