public function getlistAction() { $request = $this->getRequest()->getParams(); $fa = new Product_Model_Fa(); $fadev = new Product_Model_Fadev(); $db = $fa->getAdapter(); if (!isset($request['left_code']) || !isset($request['left_ver']) || !isset($request['right_code']) || !isset($request['right_ver']) || !$request['left_code'] || !$request['left_ver'] || !$request['right_code'] || !$request['right_ver']) { echo Zend_Json::encode(""); exit; } $left_code = $request['left_code']; $left_ver = $request['left_ver']; $right_code = $request['right_code']; $right_ver = $request['right_ver']; $whereleft = "code='{$left_code}' and ver='{$left_ver}'"; $whereright = "code='{$right_code}' and ver='{$right_ver}'"; $left_recordkey = ""; $right_recordkey = ""; $left_type = ""; $right_type = ""; if ($fa->getJoinCount($whereleft) || $fadev->getJoinCount($whereleft)) { $left_fa = $fa->getJoinList($whereleft, array(), array('recordkey')); if ($left_fa && count($left_fa) > 0) { $left_recordkey = $left_fa[0]['recordkey']; } else { $left_fa = $fadev->getJoinList($whereleft, array(), array('recordkey')); if ($left_fa && count($left_fa) > 0) { $left_recordkey = $left_fa[count($left_fa) - 1]['recordkey']; $left_type = "dev"; } } } if ($fa->getJoinCount($whereright) || $fadev->getJoinCount($whereright)) { $right_fa = $fa->getJoinList($whereright, array(), array('recordkey')); if ($right_fa && count($right_fa) > 0) { $right_recordkey = $right_fa[0]['recordkey']; } else { $right_fa = $fadev->getJoinList($whereright, array(), array('recordkey')); if ($right_fa && count($right_fa) > 0) { $right_recordkey = $right_fa[count($right_fa) - 1]['recordkey']; $right_type = "dev"; } } } if ($left_recordkey && $right_recordkey) { if ($left_type == 'dev') { $son_left = new Product_Model_Sondev(); } else { $son_left = new Product_Model_Son(); } if ($right_type == 'dev') { $son_right = new Product_Model_Sondev(); } else { $son_right = new Product_Model_Son(); } $leftData = $son_left->getSon($left_recordkey); $rightData = $son_right->getSon($right_recordkey); if ($leftData && $rightData) { $leftCode = array(); $rightCode = array(); foreach ($rightData as $d) { $rightCode[] = $d['code']; } foreach ($leftData as $d) { $leftCode[] = $d['code']; } $result = array(); for ($i = 0; $i < count($rightData); $i++) { $data = array(); $row = $rightData[$i]; $data['code'] = $row['code']; $data['code2'] = $row['code']; $data['name'] = $row['name']; $data['description'] = $row['description']; $data['qty2'] = $row['qty']; $data['partposition2'] = $row['partposition']; $data['replace2'] = $row['replace']; $left = $this->getRowFromArrayByCode($leftData, $row['code']); $leftData = $this->removeFromArray($leftData, $row['code']); $data['code1'] = $left['code']; $data['qty1'] = $left['qty']; $data['partposition1'] = $left['partposition']; $data['replace1'] = $left['replace']; $result[] = $data; } if (count($leftData) > 0) { foreach ($leftData as $row) { $data = array(); $data['code'] = $row['code']; $data['code1'] = $row['code']; $data['name'] = $row['name']; $data['description'] = $row['description']; $data['qty1'] = $row['qty']; $data['partposition1'] = $row['partposition']; $data['replace1'] = $row['replace']; $data['code2'] = ""; $data['qty2'] = ""; $data['partposition2'] = ""; $data['replace2'] = ""; $result[] = $data; } } // 将类别数据转为json格式并输出 echo Zend_Json::encode($result); exit; } else { echo Zend_Json::encode($leftData); exit; } } $msg = "BOM不存在"; if (!$left_recordkey) { $msg = $left_code . " V" . $left_ver . "不存在"; } else { if (!$right_recordkey) { $msg = $right_code . " V" . $right_ver . "不存在"; } } echo Zend_Json::encode(array("msg" => $msg)); exit; }
public function getexistsonAction() { $result = $this->getRequest()->getParams(); $code = $result['code']; $data = array(); if ($code) { $fa = new Product_Model_Fa(); $son = new Product_Model_Son(); $db = $fa->getAdapter(); // 获取最新版 $recordkeys = $db->query("select recordkey from oa_product_bom_fa where code = '{$code}' order by ver desc limit 1")->fetchObject(); if ($recordkeys && $recordkeys->recordkey) { $recordkey = $recordkeys->recordkey; $data = $son->getSon($recordkey); } } // 转为json格式并输出 echo Zend_Json::encode($data); exit; }