public function render(Varien_Object $row) { $time = ''; $count = 0; $totalTime = 0; $now = time(); // or your date as well $block = new Magestore_Inventoryreports_Block_Adminhtml_Supplier_Product_Grid(); $filter = $block->getParam($block->getVarNameFilter(), null); $condorder = ''; if ($filter) { $data = $this->helper('adminhtml')->prepareFilterString($filter); foreach ($data as $value => $key) { if ($value == 'supplier_id') { $condorder = $key; } } } if (Mage::helper('core')->isModuleEnabled('Magestore_Inventorybarcode')) { $resource = Mage::getSingleton('core/resource'); $readConnection = $resource->getConnection('core_read'); $results = ''; $purchaseOrderIds = array(); // if($condorder){ // $sql = 'SELECT distinct(`warehouse_warehouse_id`) FROM '.$resource->getTableName('inventorybarcode/barcode').' where (`product_entity_id` = '.$row->getId(). // ') and (`supplier_supplier_id` = '. $condorder .') and (`qty` > '. 0 .')'; // }else{ $sql = 'SELECT `warehouse_warehouse_id` FROM ' . $resource->getTableName('inventorybarcode/barcode') . ' where (`product_entity_id` = ' . $row->getId() . ') and (`qty` > ' . 0 . ')'; // } $results = $readConnection->query($sql); $warehouseIds = array(); if ($results) { foreach ($results as $result) { $warehouseId = $result['warehouse_warehouse_id']; $warehouseId = explode(',', $warehouseId); foreach ($warehouseId as $wId) { if (!in_array($wId, $warehouseIds)) { $warehouseIds[] = $wId; } } } } $warehouses = Mage::getModel('inventoryplus/warehouse')->getCollection()->addFieldToFilter('warehouse_id', array('in' => $warehouseIds)); $count += $warehouses->getSize(); if ($count == 0) { return $this->__('N/A'); } $resultWarehouse = ''; foreach ($warehouses as $warehouse) { //$resultWarehouse .= $warehouse->getWarehouseName().'<br />'; $resultWarehouse .= "<a href=\"#\" onclick=\"showWarehouseInventory(" . $warehouse->getId() . "," . $row->getId() . ");return false;\" title=\"" . Mage::helper('inventoryreports')->__('Report Time Inventory by Warehouse') . "\">" . $warehouse->getWarehouseName() . "<a/>" . "<br/>"; } return $resultWarehouse; } }
public function render(Varien_Object $row) { $block = new Magestore_Inventoryreports_Block_Adminhtml_Supplier_Product_Grid(); $filter = $block->getParam($block->getVarNameFilter(), null); $condorder = ''; if ($filter) { $data = $this->helper('adminhtml')->prepareFilterString($filter); foreach ($data as $value => $key) { if ($value == 'supplier_id') { $condorder = $key; } } } $product_id = $row->getId(); $resource = Mage::getSingleton('core/resource'); $readConnection = $resource->getConnection('core_read'); $results = ''; $supplierIds = array(); if ($condorder) { $supplierIds[] = $condorder; } else { $sql = 'SELECT distinct(`supplier_id`) FROM ' . $resource->getTableName('inventorypurchasing/supplier_product') . ' where `product_id` = ' . $product_id; $results = $readConnection->query($sql); if ($results) { foreach ($results as $result) { $supplierIds[] = $result['supplier_id']; } } } $suppliers = Mage::getModel('inventorypurchasing/supplier')->getCollection()->addFieldToFilter('supplier_id', array('in' => $supplierIds)); $content = ''; $check = 0; foreach ($suppliers as $supplier) { $supplierId = $supplier->getId(); $url = Mage::helper('adminhtml')->getUrl('inventorypurchasingadmin/adminhtml_supplier/edit', array('id' => $supplierId, 'inventory' => true)); $name = $supplier->getSupplierName(); if (in_array(Mage::app()->getRequest()->getActionName(), array('exportCsv', 'exportXml', 'exportCsvProductInfo', 'exportXmlProductInfo'))) { if ($check) { $content .= ', ' . $name; } else { $content .= $name; } } else { $content .= "<a href=\"#\" onclick=\"showTimeDelivery(" . $supplier->getId() . "," . $product_id . ");return false;\" title=\"" . Mage::helper('inventoryreports')->__('Report Time Inventory by Supplier') . "\">" . $name . "<a/>" . "<br/>"; } $check++; } return $content; $content = ''; $check = 0; $supplierIds = array(); foreach ($supplier_products as $supplier_product) { $supplier_id = $supplier_product->getSupplierId(); $url = Mage::helper('adminhtml')->getUrl('inventorypurchasingadmin/adminhtml_supplier/edit', array('id' => $supplier_id, 'inventory' => true)); $supplier = Mage::getModel('inventorypurchasing/supplier')->getCollection()->addFieldToFilter('supplier_id', $supplier_id)->getFirstItem(); $name = $supplier->getSupplierName(); if (in_array(Mage::app()->getRequest()->getActionName(), array('exportCsv', 'exportXml', 'exportCsvProductInfo', 'exportXmlProductInfo'))) { if ($check) { $content .= ', ' . $name; } else { $content .= $name; } } else { $content .= "<a href=" . $url . ">" . $name . "<a/>" . "<br/>"; } $check++; } return $content; }
public function render(Varien_Object $row) { $time = ''; $count = 0; $totalTime = 0; $now = time(); // or your date as well $block = new Magestore_Inventoryreports_Block_Adminhtml_Supplier_Product_Grid(); $filter = $block->getParam($block->getVarNameFilter(), null); $condorder = ''; if ($filter) { $data = $this->helper('adminhtml')->prepareFilterString($filter); foreach ($data as $value => $key) { if ($value == 'supplier_id') { $condorder = $key; } } } if (Mage::helper('core')->isModuleEnabled('Magestore_Inventorybarcode')) { $resource = Mage::getSingleton('core/resource'); $readConnection = $resource->getConnection('core_read'); $results = ''; $purchaseOrderIds = array(); if ($condorder) { $sql = 'SELECT distinct(`purchaseorder_purchase_order_id`) FROM ' . $resource->getTableName('inventorybarcode/barcode') . ' where (`product_entity_id` = ' . $row->getId() . ') and (`supplier_supplier_id` = ' . $condorder . ') and (`qty` > ' . 0 . ')'; } else { $sql = 'SELECT distinct(`purchaseorder_purchase_order_id`) FROM ' . $resource->getTableName('inventorybarcode/barcode') . ' where (`product_entity_id` = ' . $row->getId() . ') and (`qty` > ' . 0 . ')'; } $results = $readConnection->query($sql); if ($results) { foreach ($results as $result) { $purchaseOrderIds[] = $result['purchaseorder_purchase_order_id']; } } $purchaseOrders = Mage::getModel('inventorypurchasing/purchaseorder')->getCollection()->addFieldToFilter('purchase_order_id', array('in' => $purchaseOrderIds)); $count += $purchaseOrders->getSize(); $notPurchases = Mage::getModel('inventorybarcode/barcode')->getCollection()->addFieldToFilter('purchaseorder_purchase_order_id', '')->addFieldToFilter('qty', array('gt' => 0)); $count += $notPurchases->getSize(); foreach ($purchaseOrders as $purchaseOrder) { $your_date = strtotime($purchaseOrder->getPurchaseOn()); $datediff = $now - $your_date; $totalTime += floor($datediff / (60 * 60 * 24)); $time = 1; } if ($time == '') { return 'N/A'; } $time = round($totalTime / $count, 1); if ($condorder) { return '<a href="#" onclick="showTimeDelivery(' . $condorder . ',' . $row->getId() . ');return false;" title="' . Mage::helper('inventoryreports')->__('Report Time Inventory By Product') . '">' . $time . '</a>'; } else { return '<a href="#" onclick="showTimeDeliveryByProduct(' . $row->getId() . ');return false;" title="' . Mage::helper('inventoryreports')->__('Report Time Inventory By Product') . '">' . $time . '</a>'; } } $deliveries = Mage::getModel('inventorypurchasing/purchaseorder_delivery')->getCollection()->addFieldToFilter('product_id', $row->getId()); foreach ($deliveries as $delivery) { $count++; $your_date = strtotime($delivery->getDeliveryDate()); $datediff = $now - $your_date; $time = 1; $totalTime += floor($datediff / (60 * 60 * 24)); } if ($time == '') { return 'N/A'; } $time = round($totalTime / $count, 1); return $time; }