<?php class Bysoft_Export_Model_Order extends Mage_Core_Model_Abstract { protected function _construct(){ $this->_init("export/order"); $this->_write = Mage::getSingleton('core/resource')->getConnection('core_write'); } public function truncate_table() { $sql = 'truncate table bysoft_exportorder'; $this->_write->query($sql); } public function run($start = '', $end = '') { $this->truncate_table(); //get all complete or processing or shipped order $order_collection = Mage::getModel('sales/order')->getCollection() ->addFieldToFilter('status', array('in'=>array('complete','processing','shipped'))); if ($start) { $start_year = substr($start, 0, 4); $start_month = substr($start, 4, 2); $start_date = substr($start, 6, 2); $start_datetime = $start_year . '-' . $start_month . '-' .$start_date . ' 0:0:0'; $order_collection->addFieldToFilter('created_at', array('gt'=>$start_datetime)); } if ($end) { $end_year = substr($end, 0, 4); $end_month = substr($end, 4, 2); $end_date = substr($start, 6, 2); $end_datetime = $end_year . '-' . $end_month . '-' .$end_date . ' 23:59:59'; $order_collection->addFieldToFilter('created_at', array('lt'=>$end_datetime)); } $order_collection->setOrder('created_at', 'ASC'); foreach ($order_collection as $_order) { //get all order itemes $order_increment_id = $_order->getData('increment_id'); $purchased_on = $_order->getData('created_at'); $ordered_items = $_order->getAllVisibleItems(); $shippingId = $_order->getShippingAddress()->getId(); $shippingAddress = Mage::getModel('sales/order_address')->load($shippingId); $shipping_to_name = $shippingAddress->getData('firstname') . ' ' . $shippingAddress->getData('lastname'); $status = $_order->getData('status'); foreach ($ordered_items as $item) { $sku = $item->getSku(); $_product = Mage::getModel('catalog/product')->loadByAttribute('sku', $sku); if ($_product) { $_product = Mage::getModel('catalog/product')->load($_product->getId()); //get config sku if ($_product->getTypeId() == 'simple') { $parentIds = Mage::getResourceSingleton('catalog/product_type_configurable') ->getParentIdsByChild($_product->getId()); $conifg_product = Mage::getModel('catalog/product')->load($parentIds[0]); } else { $conifg_product = $_product; } $config_sku = $conifg_product->getSku(); //get third category name $categoryIds = $conifg_product->getCategoryIds(); foreach ($categoryIds as $cid) { $cate = Mage::getModel('catalog/category')->load($cid); if ($cate->getLevel() == 4) { //get category name $cate_name = $cate->getName(); $cate_name_parent = Mage::getModel('catalog/category')->load($cate->getParentId()); if ($cate_name_parent) { //get gender $gender_cate = Mage::getModel('catalog/category')->load($cate_name_parent->getParentId()); $gender = $gender_cate->getName(); } } } //get en name $en_name = $_product->getData('en_name'); //get size $size = $_product->getAttributeText('size'); //get qty $qty = $item->getData('qty_ordered'); //get original_price $org_price = $_product->getData('price'); //get sp price $special_price = $_product->getSpecialPrice(); //get row_total $paid_amount =$item->getPrice() - $item->getDiscountAmount(); //save into order object $export_oder = Mage::getModel('export/order'); $export_oder->setData('order_increment_id', $order_increment_id); $export_oder->setData('purchased_on',$purchased_on); $export_oder->setData('ship_to_name', $shipping_to_name); $export_oder->setData('status', $status); $export_oder->setData('cate_name', $cate_name); $export_oder->setData('gender', $gender); $export_oder->setData('en_name', $en_name); $export_oder->setData('config_sku', $config_sku); $export_oder->setData('size', $size); $export_oder->setData('qty', $qty); $export_oder->setData('org_price',$org_price); $export_oder->setData('special_price', $special_price); $export_oder->setData('paid_amount', $paid_amount); $export_oder->save(); var_dump('order:' . $order_increment_id . ' item id:' .$item->getId() . ' save successed!'); } } } } }
相关推荐
Magento Order Export
magento 1.8 sample data 1.6
magento商城的data-feed
magento-shb-dataflow 适用于严肃业务的Magento Dataflow类有关详细说明,请参阅 。
此 magento 产品导出基于 Aten Software Product Data Exporter for Magento。 修复了 db 表前缀的错误,删除了未使用的列,仅类别导出类别 ID(特别是 magmi 导入) 如何使用: 打开 export.php 并在第 43 行...
压缩的Magento 1.9样本数据提供以下变体: 65M 64M 40M 26M 24M 19M 样本数据包的大小为317MB,这很荒谬,由于找不到合适的替代来源,我决定一起整理一个小脚本,以压缩样本中的图像和MP3文件数据存档。 我的意图是...
magento数据结构分析 magento数据字典
magento-ce-2.4.0_sample_data-2020-07-26-02-51-57.tar.gz Include sample data
magik shoes magento 模板, magento 1.7 模板
一般magento是不可以删除订单的,有了这个就可以删除了,不过删除完就无法再恢复,此插件在1.7.0.2上可以使用
magento的SMTP插件magento的SMTP插件magento的SMTP插件
Magento的sales模块算是模块里面关联度比较大的,checkout模块的下订单流程也写得让人一头雾水,附件里主要是用客户对象和产品sku+数量的数组生成订单的函数,内容不多,但是可是找了不少时间,希望能帮到正在攻克...
Magento-Order-Status-Image 订单页面上更好的订单状态 此模块使用更好/更简洁的方式在客户订单页面视图上显示订单状态。截屏安装打开文件path/to/magento/app/design/frontend/default/default/template/sales/...
深入理解Magento 由精东博客下载下来制作成pdf
Magento插件开发手册 Magento Extension Developers Guide
Athlete Magento主题,兼容Magento 1.9.x, 1.8.x, 1.7.x ,特点:完全自适应(响应式布局),自定义子主题,无限颜色,完全自定义,一键安装演示,小工具化横幅系统,颜色选择,MEGA菜单,多商店支持,自定义产品...
Magento released a new powerful tool to manage and install sample data, reindex your database, back up your site, or flush your caches, which are just a few of the options. Chapter 3, Enabling ...
Magento Magento商城 Magento目录结构
magento2 developers cookbook, magento 开发手册,magento教程