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;
}
