public function getlistAction() { $request = $this->getRequest()->getParams(); if (!isset($request['recordkey']) || !$request['recordkey']) { exit; } $recordkey = $request['recordkey']; $fa = new Product_Model_Fa(); $son = new Product_Model_Son(); $db = $fa->getAdapter(); $data = $fa->getOne($recordkey); $bom = array(); for ($i = 0; $i < count($data); $i++) { if ($i == 0) { $row = $data[$i]; $bom = array('sid' => $row['sid'], 'nid' => $row['nid'], 'recordkey' => $row['recordkey'], 'id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'remark' => $row['remark'], 'project_no_name' => $row['project_no_name'], 'bom_file' => $row['bom_file'], 'code' => $row['code'], 'qty' => $row['qty'], 'ver' => $row['ver'], 'partposition' => "", 'replace' => "", 'state' => $row['state'], 'count' => 1, 'leaf' => false, 'children' => $this->getData($fa, $son, $recordkey, 2, $row['sid'])); } } $result = array('sid' => '', 'nid' => '', 'recordkey' => '', 'id' => '', 'name' => '', 'description' => '', 'remark' => '', 'code' => '', 'qty' => '', 'partposition' => '', 'replace' => '', 'state' => '', 'leaf' => false, 'children' => $bom); // 将类别数据转为json格式并输出 $this->view->recordkey = $row['recordkey']; $this->view->code = $row['code']; $this->view->ver = $row['ver']; echo Zend_Json::encode($result); exit; }
public function getlistAction() { $request = $this->getRequest()->getParams(); if (!isset($request['recordkey']) || !$request['recordkey']) { exit; } $recordkey = $request['recordkey']; $fa = new Product_Model_Fa(); $son = new Product_Model_Son(); $price_list = new Erp_Model_Warehouse_Pricelist(); $bomprice = new Product_Model_BomPrice(); $currencyrate = new Erp_Model_Setting_Currencyrate(); $date = date('Y-m-d'); $rateCny = $currencyrate->getRateByCode('CNY', $date); $rateUsd = $currencyrate->getRateByCode('USD', $date); $rate = round($rateCny / $rateUsd, 4); $db = $fa->getAdapter(); $data = $fa->getOne($recordkey); $bom = array(); for ($i = 0; $i < count($data); $i++) { if ($i == 0) { $row = $data[$i]; $price = $bomprice->calcBomPrice($row['recordkey'], 'CNY'); $bom = array('sid' => $row['sid'], 'nid' => $row['nid'], 'recordkey' => $row['recordkey'], 'id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'remark' => $row['remark'], 'project_no_name' => $row['project_no_name'], 'bom_file' => $row['bom_file'], 'code' => $row['code'], 'qty' => $row['qty'], 'ver' => $row['ver'], 'partposition' => "", 'replace' => "", 'state' => $row['state'], 'count' => 1, 'leaf' => false, 'low_cny' => $price['low'], 'low_usd' => round($price['low'] * $rate, 4), 'high_cny' => $price['high'], 'high_usd' => round($price['high'] * $rate, 4), 'average_cny' => $price['average'], 'average_usd' => round($price['average'] * $rate, 4), 'children' => $this->getData($fa, $son, $recordkey, 2, $rate)); } } $result = array('sid' => '', 'nid' => '', 'recordkey' => '', 'id' => '', 'name' => '', 'description' => '', 'remark' => '', 'code' => '', 'qty' => '', 'partposition' => '', 'replace' => '', 'state' => '', 'leaf' => false, 'children' => $bom); // 将类别数据转为json格式并输出 $this->view->recordkey = $row['recordkey']; $this->view->code = $row['code']; $this->view->ver = $row['ver']; echo Zend_Json::encode($result); exit; }