WordPress.org
Get WordPress

Plugin Directory

Changeset 3373005


Ignore:
Timestamp:
10/05/2025 03:58:00 AM (6 months ago)
Author:
openpos
Message:

fix loop update stock

Location:
wpos-lite-version/tags/3.0
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • wpos-lite-version/tags/3.0/includes/api/Auth.php

    r3372336 r3373005  
    258258                "pos_delivery_receipt_template" => '',
    259259                "pos_decal_receipt_template" => '',
    260                 "pos_online_order_submit" => "yes",
     260               // "pos_online_order_submit" => "yes",
    261261                "pos_default_shipping_code" => $setting['pos_default_shipping_code'],
    262262                "pos_cart_update_event" => "yes",

  • wpos-lite-version/tags/3.0/includes/api/Product.php

    r3372336 r3373005  
    203203                    $data = array('total_page' => 0,'page' => 0,'version' => $product_changed_data['current_version']);
    204204
     205                   
    205206                    $data['product'] = array();
    206207                    $data['delete_product'] = array();

  • wpos-lite-version/tags/3.0/lib/class-op-woo.php

    r3372336 r3373005  
    23592359            $local_ver = 0;
    23602360        }
    2361         $sql = "SELECT * FROM {$wpdb->postmeta} WHERE meta_key = '".$meta_key."' AND meta_value >".($local_ver - 1)." ORDER BY meta_value ASC LIMIT 0,30";
    2362        
    2363         $rows = $wpdb->get_results(  $sql, ARRAY_A);
     2361        $per_page = 30;
     2362        $sql = "SELECT SQL_CALC_FOUND_ROWS {$wpdb->postmeta}.post_id,{$wpdb->postmeta}.meta_value FROM {$wpdb->postmeta} WHERE meta_key = '".$meta_key."' AND meta_value >".($local_ver - 1)." ORDER BY meta_value ASC LIMIT 0,".$per_page;
     2363       
     2364        $rows = $wpdb->get_results(  $wpdb->prepare($sql), ARRAY_A);
    23642365
    23652366        $result = array(
    23662367                'current_version' => $local_ver,
    2367                 'data' => array()
     2368                'data' => array(),
     2369                'found_posts' => 0
    23682370        );
    23692371        $db_version = get_option('_openpos_product_version_'.$warehouse_id,0);
    … …  
    23742376            $result['current_version'] = $db_version;
    23752377        }
     2378        $found_posts = (int) $wpdb->get_var( $wpdb->prepare("SELECT FOUND_ROWS()") );
     2379     
     2380       
    23762381        foreach ($rows as $row)
    23772382        {
     2383           
    23782384            $product_id = $row['post_id'];
    23792385            $product_verion = $row['meta_value'];
    … …  
    23872393            $result['data'][$barcode] = $qty;
    23882394        }
     2395       
     2396       
     2397
    23892398        if($db_version < $result['current_version'])
    23902399        {
    23912400            update_option('_openpos_product_version_'.$warehouse_id,$result['current_version']);
     2401        }else{
     2402            if($found_posts < $per_page )
     2403            {
     2404                $result['current_version'] = $db_version;
     2405            }
    23922406        }
    23932407       
Note: See TracChangeset for help on using the changeset viewer.