public function getWOSkid($skid_no = null) { $this->autoRender = false; App::import('Model', 'WorkOrderManager.WorkOrder'); $WorkOrder_Model = new WorkOrder(); $WorkOrder_data = $WorkOrder_Model->find('first', array('conditions' => array('WorkOrder.skid_number' => $skid_no))); if (!empty($WorkOrder_data)) { $WO_datas = $WorkOrder_Model->find('all', array('conditions' => array('WorkOrder.skid_number' => $skid_no), "recursive" => -1)); $wo_number = ""; $wo_id = ""; $cnt = count($WO_datas); foreach ($WO_datas as $WO_data) { $wo_number .= $WO_data['WorkOrder']['work_order_number']; $wo_id .= $WO_data['WorkOrder']['id']; if ($cnt > 1) { $wo_number .= ","; $wo_id .= ","; } $cnt--; } $data['skid_number'] = $WorkOrder_data['WorkOrder']['skid_number']; $data['skid_weight'] = $WorkOrder_data['WorkOrder']['skid_weight']; $data['wo_number'] = $wo_number; $data['wo_id'] = $wo_id; echo json_encode($data); } else { App::import('Model', 'ContainerManager.SkidInventory'); $SkidInventory_Model = new SkidInventory(); $SkidInventory_data = $SkidInventory_Model->find('first', array('conditions' => array('SkidInventory.skid_no' => $skid_no))); if (!empty($SkidInventory_data)) { $data['skid_number'] = $SkidInventory_data['SkidInventory']['skid_no']; $data['skid_weight'] = $SkidInventory_data['SkidInventory']['weight']; $data['wo_number'] = null; $data['wo_id'] = null; } else { $data['skid_number'] = ''; $data['skid_weight'] = "0.00"; $data['wo_number'] = null; $data['wo_id'] = null; } echo json_encode($data); } exit; }
function getSkidDescrition($num = null) { App::import('Model', 'ContainerManager.SkidInventory'); $SkidInventory_Model = new SkidInventory(); $data = $SkidInventory_Model->find('first', array('conditions' => array('SkidInventory.skid_no' => $num))); return $data['SkidInventory']['description']; }