如何用PHP动态获取OpenERP特定日期销售订单及解决数据不符问题

Hey there, let's figure out why your PHP script is only pulling 3 sales orders instead of the 22 you see in the OpenERP backend. Based on your workflow (starting with fetching res.partner IDs), here are the most likely issues to check:

1. Mismatched Filter Conditions (Domain) #

This is the #1 culprit for missing records. Double-check that your script's domain filter exactly matches what you're using in the OpenERP backend:

• Date Range Issues: If you're filtering for a specific date, make sure you're covering the full 24-hour window. For example, using array('date_order', '=', '2024-05-20') might miss orders created at times other than midnight. Use a range instead:

  $domain = array(
      array('date_order', '>=', '2024-05-20 00:00:00'),
      array('date_order', '<=', '2024-05-20 23:59:59')
  );
  

• Unintended Partner Filter: Since you're fetching res.partner IDs first, did you accidentally add a filter that only pulls orders linked to that single partner? If the backend's 22 orders are across multiple partners, this would explain the 3-record result. Remove any unnecessary partner_id constraints from your domain if you want all orders for the date.
• State Filter: OpenERP's backend often defaults to showing only confirmed orders (state = 'sale'). If your script isn't including this filter, or is including a different state (like draft), you might be pulling the wrong subset. Check if your domain has a state condition that doesn't match the backend view.

2. Permission Restrictions on the Script's User Account #

The OpenERP user account your PHP script uses might not have access to all 22 orders. Here's how to test:

• Log into the OpenERP backend using the exact same username/password your script uses.
• Run the same date-based search you're trying to replicate.
• If you only see 3 orders here, the problem is permission-related. You'll need to adjust the user's access rights (e.g., give them "All" record access for sale.order instead of "My Own").

3. XML-RPC Pagination/Limit Constraints #

OpenERP's execute_kw method for search_read has default limits in some versions, or you might have accidentally set a low limit in your code:

• Check if your search_read call includes a limit parameter set to a small number (like 3). Remove it or set it to false to fetch all matching records:

  $orders = $models->execute_kw(
      $db, $uid, $password,
      'sale.order', 'search_read',
      array($domain), // Your filter domain
      array('fields' => array('name', 'date_order', 'partner_id'), 'limit' => false)
  );
  

• Also, ensure you're not using an offset parameter that skips most of the results.

4. Timezone Mismatches #

If your OpenERP instance uses UTC time but your script is filtering based on local time, you might be pulling orders from the wrong date window. For example:

• An order created at 10 PM local time might be stored as 2 AM UTC the next day. If your script filters for the local date, it won't include this order.
• Fix this by converting your local date range to UTC in the script, or adjust OpenERP's timezone settings to match your script's environment.

Quick Debugging Steps #

1. Print Your Domain: Echo the domain array from your script and compare it line-by-line to the filter you use in the OpenERP backend's search bar.
2. Remove Filters: Temporarily remove all filters except the date range. If you get all 22 orders, you know one of the removed filters was causing the issue.
3. Test with Admin: Run the script using the OpenERP admin account's credentials. If you get all 22 orders, the problem is definitely permission-related.

内容的提问来源于stack exchange，提问作者Mukesh Kumar