/
Warehouse.php
46 lines (42 loc) · 2.2 KB
/
Warehouse.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
class Magestore_Inventorypurchasing_Block_Adminhtml_Purchaseorder_Edit_Tab_Renderer_Warehouse extends Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Abstract {
public function render(Varien_Object $row) {
$columnName = $this->getColumn()->getName();
$columnName = explode('_', $columnName);
if ($columnName[1]) {
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$installer = Mage::getModel('core/resource');
$warehouseId = $columnName[1];
$purchase_order_id = $this->getRequest()->getParam('id');
if ($row->getProductId()) {
$producId = $row->getProductId();
} else {
$producId = $row->getEntityId();
}
$sql = 'SELECT `qty_order` from ' . $installer->getTableName("erp_inventory_purchase_order_product_warehouse") . ' WHERE (purchase_order_id = ' . $purchase_order_id . ') AND (product_id = ' . $producId . ') AND (warehouse_id = ' . $warehouseId . ')';
$results = $readConnection->fetchAll($sql);
if (count($results) > 0) {
foreach ($results as $result) {
if (!array_key_exists('qty_order', $result) || (array_key_exists('qty_order', $result) && !$result['qty_order'])) {
$result['qty_order'] = 0;
}
if ($this->getColumn()->getEditable()) {
echo $result['qty_order'] . '<input name="warehouse_' . $warehouseId . '" class="input-text" type="text" value="' . $result['qty_order'] . '"/>';
} else {
echo $result['qty_order'];
}
}
} else {
$result['qty_order'] = 0;
if ($this->getColumn()->getEditable()) {
echo $result['qty_order'] . '<input name="warehouse_' . $warehouseId . '" class="input-text" type="text" value="' . $result['qty_order'] . '"/>';
} else {
echo $result['qty_order'];
}
}
} else {
parent::render($row);
}
}
}