Schedule Team Photo Regular Silly Plaque Print Plaque Print Player Parent Black Maple Blue 5x7 8x10 Black Maple Blue 5x7 8x10 Total Paid TexStarVSS-teamRequest.php Main representative requests team photo including number of parents with potential order. - Request includes requestor, text, email, age, division, date, time - similar to teamphotos table. May need a few extra fields to this table. May be good to keep this table since it is used for team identification. If not booked, team photo request accepted and main representative receives 3 texts - first one with date time and s message to come 15 minutes before scheduled photo. - second with link to scheduled team photo request (TexStarVSS-teamRequest.php?teamId=NN) and one with link to invite parents to order (TexStarVSS-teamOrder.php). Their order may start as link to orderteams2021.php which is like orderphotos2019.php except that it is simpler - no packages, all ala carte, 5x7, 8x10, plaque, 1-image poster. This way can show appearance of plaques, etc. To start, the order is via orderteams2021 which allows for payment. Album area shows the selected team and silly team that comes from the teamphoto record. If not taken yet, the photo just shows regular team, silly team. If taken, then album is T followed by the team record id. If taken, at team identification, an album needs to be created with name T followed by the team id and the regular and silly photos added. The orderType or some other field would need to identify the specific order for the team. The view path would be Teams/Teams/... such as 01, 02, etc. Right now Type is 2 characters so this could work. Note that these orders should all be team pickup. - 3rd with link to scheduled team photo request is so the time could be changed in particular and perhaps deleted. A move should keep the team record Id the same. Deletes can only be done before Submitted and before any payments. Delete applies to order and item. Menu options are Move and Delete, but Delete prompts to come by booth. The link to invite parents to order should first show some team scheduling. (Hour, Minute, Date, Age, Division, Team) Once team parent receives link to order, enters info and places order and pays. - Since on-site team order, receives text that payment made in addition to email via paypal. Doesn't need our email - text is fine. - Team parent can also respond with no order by click button for Exit which may be changed to NO ORDER. - Onced parent orders, team representative receives text about paid and waiting on N number for submitting order. - Main representative should be able to click on the number yet to order to see those parents yet to order. - If number yet to order is 0, then message indicates that main representative should review and place order. Once main representative has all parents responding, then reviews order - Reviewing order should make it easy to see products ordered by team parent. Main representative submits order. - The album # is the T followed by the team record id and type is '0' or '00'. - Once order submitted, main representative receives text saying that order expected to be complete by certain date/time and that will receive text once order is ready for pickup. - Team order is marked Paid. - Just like action orders list on TexStarMain.php, there needs to be team orders list on TexStarMain.php so they can be Started, Packaged just like action orders. Our staff views and starts order. - Option to print order. A report similar to current form could be generated. - Just because order is printed, not done yet until Packaged. The person packaging will mark Packaged. - Once packaged, if gets medium res team, that should automatically be downloaded and emailed at that time. Order representative picks up order and we mark Delivered. Perhaps text all those that ordered that it was picked up. - So order goes from created to ordered to started to packaged to delivered. For link to player parents - perhaps needs to have similar info to the scheduling request and then button for order. Then an order can be created with the sequence right - also if they choose not to order what to do. Perhaps order is different with requestor, text, email, image 1, product code 1, product code 1 detail (plaque color), PayPal stuff, product code 2, etc. The team request gets status changed perhaps like an order - ordered, printed, packaged, delivered Perhaps album for player parents is TNNNN where NNNN is the team photo number. The team photo number would need to stay under 9999. Not sure how to have sequence that increments with T staying same. Perehaps similar to photo numbers. If parent doesn't order, still need to record this somewhere - perhaps blank order. At time of team request - need to know how many parents to expect - could be changed. For parent to return to the proper screen, would need to fill in name, etc. At that point, could see if order generated already. So first time, when clicks order, would save order with name, text, email with album of TNNNN and seq with increments. Only when order is paid does the representative get a text. The representaive would have an option of seeing summary of orders. Summary would look something like: Name Paid Regular 5x7, 8x10, Maple Plaque Silly 5x7, 8x10, Maple Plaque Total Regular 5x7: NN 8x10: NN Maple Plaques: NN Silver Plaques: NN Navy Plaques: NN Black Wood Plaques: NN Total Silly 5x7: NN 8x10: NN Maple Plaques: NN Silver Plaques: NN Navy Plaques: NN Black Wood Plaques: NN We use this for printing orders as well - could add Grandtotal 5x7's and 8x10's. Could do matrix as well, but much more work.