Changeset 2451483

Timestamp:

01/06/2021 08:06:28 PM (5 years ago)

Author:

teoleonard

Message:

update fix

File:

• raffle-ticket-generator/trunk/raffle-ticket-generator.php (modified) (2 diffs)

raffle-ticket-generator/trunk/raffle-ticket-generator.php

@@ -4 +4 @@
 Plugin URI: http://wpraffle.com
 Description: Raffle Ticket Generator.  Generate numbered raffle tickets and email virtual tickets via WooCommerce order system
-Version: 4.2.01
+Version: 4.2
 Author: The Web Design Ninja
 Author URI: http://TheWebDesignNinja.com 
@@ -619 +619 @@
     global $wpdb;
     if ( 'processing' == $order_status || 'completed' == $order->status) {
-    $ticket_numbers = $wpdb->get_results('select * from '.$wpdb->prefix.'wooraffle_tickets_customer_to_tickets where order_id = "'.$order_id.'"');
-    if ($wpdb->num_rows > 0) {
-        echo '<h2>Ticket Numbers provided by WPRaffle.com</h2>';
-        foreach ( $ticket_numbers as $result ) {
-            echo '<p>'.$result->ticket_number.'</p>';
-        }
-    }
+     $order = new WC_Order($order_id);
+    $items = $order->get_items();
+    $ticket_prefix = 'wpraffle-'.date('Y');
+    $last_order_id = get_orders_from($order_id);
+
+    //$start_query = $wpdb->get_results('SELECT `ticket_number` FROM `'.$wpdb->prefix.'wooraffle_tickets_customer_to_tickets` ORDER BY CAST(`ticket_number` AS UNSIGNED)=0, CAST(`ticket_number` AS UNSIGNED), LEFT(`ticket_number`,1), CAST(MID(`ticket_number`,2) AS UNSIGNED) LIMIT 0,1 ');
+    $start_query = $wpdb->get_results('SELECT `ticket_number` FROM `'.$wpdb->prefix.'wooraffle_tickets_customer_to_tickets` where 1');
+if (empty($start_query)) {
+$start = 1;
+}
+else {
+
+    foreach ( $start_query as $start_query_result ) {
+    $startt = explode('-',$start_query_result->ticket_number);
+    if ($startt[2] >= 500) {
+    $start = 1;
+            }
+            else {
+    $start = $startt[2]+1;
+            }
+    }
+}
+    foreach ( $items as $item ) {
+    $product_id = $item['product_id'];
+    $no_of_tickets = ($item['qty']) * (get_post_meta( $item['product_id'], '_number_field', true ));
+    for ($i=0; $i<$no_of_tickets; $i++) {
+        
+        $wpdb->insert($wpdb->prefix."wooraffle_tickets_customer_to_tickets", array(
+   "order_id" => $order_id,
+   "products_id" => $item['product_id'],
+   "ticket_number" => $ticket_prefix.'-'.sprintf('%02d',$start)
+));
+    $start++;
+    }
+                }
     $order_status = 'completed';
     return $order_status;