控制 Magento API 调用的结果数量
我有一个程序，用于通过 API 将 Magento 商店连接到后端库存控制系统。目前它的作用是查询 Magento API 中所有处于 Pending 状态的订单，将它们插入后端系统，然后将它们的状态设置为 Magento 中的“正在处理”。由于我们的库存系统的限制，我们一次只能插入有限数量的订单。我们通过 if 循环运行整个过程来控制这个问题，如下所示（仅供参考，代码已被编辑以仅显示此问题的关键部分）：
//The maximum number of orders to download
$iMaxCount = 10 ;
try {
$proxy = new SoapClient($wsdl_url);
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
$sessionId = $proxy->login($login, $password);
//fetch the pending orders from the site
$field = array(array('status'=>array( 'pending') ));
$arr = $proxy->call($sessionId, 'sales_order.list', $field);
$iCnt = 0;
foreach($arr as $key => $value){
//only down up to the max count
if ($iCnt < $iMaxCount) {
[... Do the updating and insertion part of the program ...]
$iCnt++;
} //End of looping through orders
这样做的明显缺点是我仍然必须拉出所有待处理的内容尽管我只会与其中的 10 个订单合作。即，如果我有 200 个挂单，API 将返回全部 200 个，处理 10 个，然后跳过其余的。我想要做的是修改 API 调用的过滤器，以便在处理状态时一次仅提取 10 个订单。这将使我能够消除 if 循环开销并使程序运行更有效，因为它只获取所需的数据。
有谁知道如何应用这种类型的过滤器？我所看到的一切都表明，只有当您知道订单号并据此设置限制时，您才能执行此操作。感谢您的帮助！！！
I have a program that we use to connect our Magento store to our back end Inventory Control system via the API. Currently what it does is query the Magento API for all orders in Pending status, inserts them into the back end system, then sets their status to Processing in Magento. Due to limitations on our Inventory system, we can only insert a limited number of orders at a time. We control this by running the whole process through an if loop as shown below (FYI, code has been edited down to show only the key parts of this problem):
//The maximum number of orders to download
$iMaxCount = 10 ;
try {
$proxy = new SoapClient($wsdl_url);
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
$sessionId = $proxy->login($login, $password);
//fetch the pending orders from the site
$field = array(array('status'=>array( 'pending') ));
$arr = $proxy->call($sessionId, 'sales_order.list', $field);
$iCnt = 0;
foreach($arr as $key => $value){
//only down up to the max count
if ($iCnt < $iMaxCount) {
[... Do the updating and insertion part of the program ...]
$iCnt++;
} //End of looping through orders
The obvious downfall of doing it this way is I still have to pull all Pending orders even though I am going to be working with only 10 of them. i.e. If I have 200 pending orders, the API returns all 200 of them, processes 10, then skips the rest. What I want to do is modify the filter of the API call to pull only 10 orders at a time of status Processing. This would allow me to remove the if loop overhead and make the program run more efficiently because it only gets the data it needs.
Does anyone know how to apply that type of filter? Everything I have seen suggest you can only do this if you know the order numbers and set limits based on that. Thanks for your help!!!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
所有 API 调用最终都只是执行 PHP 代码。某处将有一个 PHP 方法接受通过 API 调用传入的参数，因此最好的选择是跟踪 PHP 代码的执行位置。
第 1 步是找到 API 调用的配置。在现代版本的 Magento 中，API 配置保存在名为
api.xml的文件中。找到所有
api.xml文件后，搜索它们以确定哪一个配置你的“顶级 api 命名空间”（不确定内部开发人员真正调用的是什么）看起来标签。接下来，打开文件并查看
app/code/core/Mage/Sales/etc/api.xml是我们想要的文件，因为它有我们感兴趣的第一个节点是
sales/order_api sales_order命名空间中的任何 API 调用的对象。接下来，我们将在
list。该节点告诉我们对
sales_order.list的调用对应于items方法。结合上面找到的信息，我们现在知道 API 调用sales_order.list将运行与以下内容等效的 PHP 代码接下来，打开模型文件并查看
items方法在此方法的末尾，您可以看到该方法将遍历每个参数并尝试将其用作集合的过滤器。键是字段，值是要搜索的值。如果您检查该方法的其余部分，您会发现没有其他方法可以使参数与集合交互来添加任何类型的分页或限制。
因此，这给您提供了三个选择。第一个是找到一组值传递给
这将限制您的集合。我的建议是使用
array('from'=>'10','to'=>'20')语法进行某种日期过滤器。您的第二个选择是为
Mage_Sales_Model_Order_Api::items创建一个类重写，以进行一些额外的过滤。您的第三个选择是研究创建一个模块，添加一个自定义 API 方法供您调用。
All API calls are, eventually, just executed PHP code. There will be a single PHP method somewhere that accepts the arguments passed in via the API call, so your best bet is to track down where that PHP code is executed.
Step 1 is to find the API call's configuration. In modern versions of Magento, API configurations are kept in files named
api.xmlOnce you've found all the
api.xmlfiles, search through them to fine which one configures your "top level api namespace" (unsure what this is really called by the internal developers)It looks like
app/code/core/Mage/Sales/etc/api.xmlis the file we want, since it has a<sales_order />tag. Next, open the file and look at the<sales_order />node.The first node we're interested in is
<model>sales/order_api</model>. This specifies the object that will be instantiated to handle any API call in thesales_ordernamespace.Next, we're going to look for the method
listin the<methods/>node.This node tells us that a call to
sales_order.listcorresponds to the methoditems. Combining that with the information found above, we now know the API callsales_order.listwill run PHP code equivalent to the followingNext, open your model file and look at the
itemsmethodAt the end of this method, you can see that the method will run through each argument and attempt to use it as a filter on the collection. The key is the field, the value is the value search for. If you inspect the rest of the method you'll see there's no other way the paramaters interact with the collection to add any sort of paging or limits.
So, this leaves you with three options. The first is to find a set of values to pass into
that will limit your collection. My suggestion would be some sort of date filter using the
array('from'=>'10','to'=>'20')syntax.Your second option would be to create a class rewrite for
Mage_Sales_Model_Order_Api::itemsthat does some extra filtering.Your third option would be to investigate creating a module that adds a custom API method for you to call.
设置限制的快速解决方案是找到 app/code/core/Mage/Sales/Model/Order/Api.php （并覆盖该类），然后：
更改方法签名以接受另一个参数 $limit ，以便方法签名如下所示：
然后，在“foreach ($orderCollection as $order) {”之前添加以下行：
然后只需将限制作为额外参数传递给 sales_order.list api 调用。
嘘！
A quick solution to set a limit is to locate app/code/core/Mage/Sales/Model/Order/Api.php (and do an overwrite of the class) then:
Change the method signature to accept another parameter $limit so the method signature looks like:
Then, add the following line before "foreach ($orderCollection as $order) {":
Then simply pass the limit as an extra argument to the sales_order.list api call.
Booyah!
您应该能够使用 setPage，它通过指定页码（单索引）和每页的记录数来设置查询 LIMIT 子句。
要选择第二组 10 个项目，您可以使用以下命令：
有关此主题的更多信息可以在此处找到：在 Magento 中使用集合
You should be able to use setPage, which sets the query LIMIT clause by specifying page number (one-indexed) and number of records per page.
To select the second set of 10 items, you would use the following:
More information on this topic can be found here: Using Collections in Magento