function listOfPoItem($wo_id) { App::uses('PurchaseOrderItem', 'PurchaseOrderManager.Model'); $purchaseOrderModel = new PurchaseOrderItem(); $purchaseOrders = $purchaseOrderModel->find('all', array('fields' => array('PurchaseOrder.id,PurchaseOrder.purchase_order_num,PurchaseOrderItem.id', 'PurchaseOrderItem.code'), 'conditions' => array('PurchaseOrder.work_order_id' => $wo_id))); //debug($purchaseOrders); $allItems = $this->ListAllTypesOfItems(); $list = array(); $title_list = array(); $price_list = array(); $po_list = array(); $po_id_list = array(); foreach ($purchaseOrders as $value) { if (array_key_exists($value['PurchaseOrderItem']['code'], $allItems['main_list'])) { $list[$value['PurchaseOrderItem']['code']] = $allItems['main_list'][$value['PurchaseOrderItem']['code']]; $title_list[$value['PurchaseOrderItem']['code']] = $allItems['title_list'][$value['PurchaseOrderItem']['code']]; $price_list[$value['PurchaseOrderItem']['code']] = $allItems['price_list'][$value['PurchaseOrderItem']['code']]; $po_list[$value['PurchaseOrderItem']['code']] = $value['PurchaseOrder']['purchase_order_num']; $po_id_list[$value['PurchaseOrderItem']['code']] = $value['PurchaseOrder']['id']; } } return array('main_list' => $list, 'title_list' => $title_list, 'price_list' => $price_list, 'po_list' => $po_list, 'po_id_list' => $po_id_list); }
public function getPoItem($wo_id = null) { $this->autoRender = false; App::uses('PurchaseOrderItem', 'PurchaseOrderManager.Model'); $purchaseOrderModel = new PurchaseOrderItem(); $purchaseOrders = $purchaseOrderModel->find('all', array('fields' => array('PurchaseOrder.id,PurchaseOrder.purchase_order_num,PurchaseOrderItem.id', 'PurchaseOrderItem.code'), 'conditions' => array('PurchaseOrder.work_order_id' => $wo_id))); //debug($purchaseOrders); $allItems = $this->QuoteItem->ListAllTypesOfItems(); $list = array(); $title_list = array(); $price_list = array(); $po_list = array(); $po_id_list = array(); foreach ($purchaseOrders as $value) { if (array_key_exists($value['PurchaseOrderItem']['code'], $allItems['main_list'])) { $list[$value['PurchaseOrderItem']['code']] = $allItems['main_list'][$value['PurchaseOrderItem']['code']]; $title_list[$value['PurchaseOrderItem']['code']] = $allItems['title_list'][$value['PurchaseOrderItem']['code']]; $price_list[$value['PurchaseOrderItem']['code']] = $allItems['price_list'][$value['PurchaseOrderItem']['code']]; $po_list[$value['PurchaseOrderItem']['code']] = $value['PurchaseOrder']['purchase_order_num']; $po_id_list[$value['PurchaseOrderItem']['code']] = $value['PurchaseOrder']['id']; } } echo json_encode(array('main_list' => $list, 'title_list' => $title_list, 'price_list' => $price_list, 'po_list' => $po_list, 'po_id_list' => $po_id_list)); //echo json_encode($purchaseOrders); }