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;
}
