Feature Suggestion: Integration with what3words for Delivery Addresses

Description

BloomQuote aims to streamline the process of creating and managing quotes for customer events. To enhance the accuracy and efficiency of specifying delivery locations, it is proposed to integrate the what3words addressing system into the application. This feature will allow users to utilize precise 3-word addresses for delivery locations.

Purpose

Integrating what3words will enable users to provide highly accurate delivery locations, reducing the chances of errors and ensuring smooth logistics. This feature is particularly beneficial for events held at large or complex venues where traditional addresses might be ambiguous.

Benefits

Enhanced Accuracy: what3words provides a precise and easy-to-remember address system, ensuring that deliveries reach the exact location intended.
Improved User Experience: Simplifies the process of specifying and understanding delivery locations.
Increased Efficiency: Reduces the time and effort needed to communicate and verify addresses, enhancing overall event management.

Implementation Details

UI Integration: Add a field in the quote creation and item addition forms to input what3words addresses.
Backend Processing: Modify the QuoteController to handle what3words addresses, storing and retrieving them as part of the quote and item details.
Validation and Display: Implement validation for what3words addresses and display them appropriately in quotes and item listings.

Example Usage

Specifying a Delivery Location: Users can enter a what3words address (e.g., "filled.count.soap") to specify the exact delivery point.
Retrieving and Displaying: The application will display the what3words address alongside traditional addresses, providing clear location details.

Proposed Changes to Code

Controller Update (QuoteController.php):

public function create() {
  // Existing code
  $data = [
      // Other fields
      'what3words' => $sanitizedData['what3words']
  ];
  // Existing code
}

public function add_item() {
  // Existing code
  $data = [
      // Other fields
      'what3words' => $sanitizedData['what3words']
  ];
  // Existing code
}

Model Update (Quote.php):

public function create($data) {
  $stmt = $this->db->prepare("
      INSERT INTO quotes (user_id, wedding_date, billing_address, time, bride_name, bride_email, bride_contact, groom_name, groom_email, groom_contact, ceremony_address, venue_address, other_address, what3words, days_for_deposit, deposit_date, final_consultation_month, total_cost, custom_message, payment_terms)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  ");
  $stmt->bind_param("isssssssssssssssssss", 
  // Other bindings
  $data['what3words']
  );
  $stmt->execute();
}

public function getItemsByQuoteId($quote_id) {
  $stmt = $this->db->prepare("
      SELECT * FROM quote_items WHERE quote_id = ? ORDER BY `order` ASC
  ");
  $stmt->bind_param("i", $quote_id);
  $stmt->execute();
  return $stmt->get_result();
}

View Update (create.php and add_item.php):

<div class="form-group">
  <label for="what3words">what3words Address</label>
  <input type="text" class="form-control" id="what3words" name="what3words" placeholder="e.g., filled.count.soap">
</div>

Conclusion

Integrating what3words into BloomQuote will significantly improve the precision of delivery addresses, enhancing the overall functionality and user experience of the application. This feature aligns with BloomQuote's mission to provide a comprehensive, user-friendly solution for florists.

sirnails / BloomQuote