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;
 }
Exemple #2
0
 public function calcBomPrice($recordkey, $currency = 'CNY')
 {
     $low = $high = $average = 0.0;
     $fa = new Product_Model_Fa();
     $son = new Product_Model_Son();
     $price_list = new Erp_Model_Warehouse_Pricelist();
     $data = $this->getJoinList('recordkey = ' . $recordkey);
     // 检查当前BOM是否已有价格
     if (count($data) == 0) {
         // 计算价格
         $sonData = $son->getJoinList("recordkey = " . $recordkey, array(), array('code', 'qty'));
         foreach ($sonData as $sonRow) {
             // 检查是否有BOM数据,如果没有,当作物料处理
             $sonFaData = $fa->getJoinList("code = '" . $sonRow['code'] . "'", array(), array('recordkey'), array('ver desc'));
             if (count($sonFaData) == 0) {
                 if (isset($_SESSION['mprice'][$sonRow['code']])) {
                     // session 中存在
                     $price = $_SESSION['mprice'][$sonRow['code']];
                 } else {
                     $price = $price_list->getMultiPrice($sonRow['code'], $currency);
                     $_SESSION['mprice'][$sonRow['code']] = $price;
                 }
             } else {
                 $price = $this->calcBomPrice($sonFaData[0]['recordkey'], $currency);
             }
             $low += $price['low'] * $sonRow['qty'];
             $high += $price['high'] * $sonRow['qty'];
             $average += $price['average'] * $sonRow['qty'];
         }
     } else {
         $bomPrice = $data[0];
         $low = $bomPrice['low_' . strtolower($currency)];
         $high = $bomPrice['high_' . strtolower($currency)];
         $average = $bomPrice['average_' . strtolower($currency)];
     }
     return array('low' => round($low, 4), 'high' => round($high, 4), 'average' => round($average, 4));
 }
Exemple #3
0
 public function importAction()
 {
     $result = array('success' => true, 'info' => '导入成功');
     $request = $this->getRequest()->getParams();
     $type = isset($request['type']) ? $request['type'] : null;
     $nid = isset($request['nid']) ? $request['nid'] : "";
     if (isset($_FILES['csv'])) {
         $now = date('Y-m-d H:i:s');
         $user_session = new Zend_Session_Namespace('user');
         $user_id = $user_session->user_info['user_id'];
         $file = $_FILES['csv'];
         $file_extension = strrchr($file['name'], ".");
         $h = new Application_Model_Helpers();
         $tmp_file_name = $h->getMicrotimeStr() . $file_extension;
         $savepath = "../temp/";
         $tmp_file_path = $savepath . $tmp_file_name;
         move_uploaded_file($file["tmp_name"], $tmp_file_path);
         $materiel = new Product_Model_Materiel();
         $db = $materiel->getAdapter();
         if ($type == 'dev') {
             $fa = new Product_Model_Fadev();
             $son = new Product_Model_Sondev();
             $table = "oa_product_bom_fa_dev";
         } else {
             if ($type == 'bom') {
                 $fa = new Product_Model_Fa();
                 $son = new Product_Model_Son();
                 $table = "oa_product_bom_fa";
             }
         }
         if ($type == 'dev' || $type == 'bom') {
             $file = fopen($tmp_file_path, "r");
             $data = array();
             while (!feof($file)) {
                 array_push($data, fgetcsv($file));
             }
             // 数据校验
             if (count($data) <= 1) {
                 $result['success'] = false;
                 $result['info'] = "文件中无数据!";
                 fclose($file);
                 echo Zend_Json::encode($result);
                 exit;
             }
             for ($i = 1; $i < count($data); $i++) {
                 $num = $i + 1;
                 $row = $data[$i];
                 if ($i == 1 && !$row[1]) {
                     $result['success'] = false;
                     $result['info'] = "请以上级物料开头:第" . $num . "行!";
                     fclose($file);
                     echo Zend_Json::encode($result);
                     exit;
                 }
                 if (!$row[1] && !$row[2]) {
                     continue;
                 }
                 if ($row[1] && $row[2]) {
                     $result['success'] = false;
                     $result['info'] = "上级物料和下级物料不能同时存在:第" . $num . "行!";
                     fclose($file);
                     echo Zend_Json::encode($result);
                     exit;
                 }
                 if ($row[1]) {
                     if (!$materiel->checkExist($row[1])) {
                         $result['success'] = false;
                         $result['info'] = "物料“" . $row[1] . "”不存在:第" . $num . "行!";
                         fclose($file);
                         echo Zend_Json::encode($result);
                         exit;
                     }
                     $m = $materiel->getMaterielByCode($row[1]);
                 }
                 if ($row[2]) {
                     if (!$materiel->checkExist($row[2])) {
                         $result['success'] = false;
                         $result['info'] = "物料“" . $row[2] . "”不存在:第" . $num . "行!";
                         fclose($file);
                         echo Zend_Json::encode($result);
                         exit;
                     }
                 }
                 if ($row[2] && $row[7]) {
                     $replace = explode(',', $row[7]);
                     foreach ($replace as $r) {
                         $r = iconv('utf-8', 'gbk//IGNORE', $r);
                         if (!$materiel->checkExist($r)) {
                             $result['success'] = false;
                             $result['info'] = "物料“" . $r . "”不存在:第" . $i . "行!";
                             fclose($file);
                             echo Zend_Json::encode($result);
                             exit;
                         }
                     }
                 }
                 if ($i > 1 && $row[1] && $data[$i - 1][1]) {
                     $result['success'] = false;
                     $result['info'] = "BOM“" . $data[$i - 1][1] . "”不存在子物料:第{$i行!}";
                     fclose($file);
                     echo Zend_Json::encode($result);
                     exit;
                 }
             }
             // 只取一次最大值,可能遇到重号
             $maxkeys = $fa->getAdapter()->query("select ifnull(max(recordkey),0) as maxkey from {$table}")->fetchObject();
             $recordkey = $maxkeys->maxkey;
             $pid = "";
             $faArr = array();
             $sonArr = array();
             $obsoleteWhere = "1=0";
             // 校验成功,开始保存数据
             for ($i = 1; $i < count($data); $i++) {
                 $row = $data[$i];
                 if ($row[1]) {
                     $m = $materiel->getMaterielByCode($row[1]);
                     $recordkey++;
                     $pid = $m['id'];
                     $faData = array('nid' => $nid, 'recordkey' => $recordkey, 'id' => $m['id'], 'code' => $row[1], 'qty' => 1, 'state' => $row[3] ? $row[3] : 'EBOM', 'ver' => $row[4] ? $row[4] : '1.0');
                     if ($faData['ver'] > '1.0') {
                         $obsoleteWhere .= " or (code='" . $row[1] . "' and ver < '" . $faData['ver'] . "')";
                     }
                     // 检查是否已经存在
                     if ($type == 'dev') {
                         $list = $fa->getFaList("nid = {$nid} and ver = '" . $faData['ver'] . "' and id = " . $m['id']);
                     } else {
                         $list = $fa->getFaList("ver = '" . $faData['ver'] . "' and id = " . $m['id']);
                     }
                     if ($list && count($list) > 0) {
                         $result['success'] = false;
                         $result['info'] = "数据已存在:" . $faData['code'] . " " . $faData['ver'] . "!";
                         fclose($file);
                         echo Zend_Json::encode($result);
                         exit;
                     }
                     $faArr[] = $faData;
                 }
                 if ($row[2]) {
                     $m = $materiel->getMaterielByCode($row[2]);
                     $sonData = array('nid' => $nid, 'recordkey' => $recordkey, 'pid' => $pid, 'id' => $m['id'], 'code' => $row[2], 'qty' => $row[5] ? $row[5] : 1, 'partposition' => $row[6] ? $row[6] : '', 'replace' => $row[7] ? $row[7] : '', 'remark' => $row[8] ? $row[8] : '');
                     // 检查是否已经存在
                     if ($type == 'dev') {
                         $list = $son->getList("nid = {$nid} and id = " . $m['id']);
                     } else {
                         $list = $son->getList("recordkey = {$recordkey} and id = " . $m['id']);
                     }
                     if ($list && count($list) > 0) {
                         $result['success'] = false;
                         $result['info'] = "数据已存在:" . $sonData['code'] . "!";
                         fclose($file);
                         echo Zend_Json::encode($result);
                         exit;
                     }
                     $sonArr[] = $sonData;
                 }
             }
             $db->beginTransaction();
             try {
                 foreach ($faArr as $faData) {
                     $fa->insert($faData);
                 }
                 foreach ($sonArr as $sonData) {
                     $son->insert($sonData);
                 }
                 // 旧版作废
                 if ($type == 'bom') {
                     $bosoleteData = array("state" => "Obsolete");
                     $fa->update($bosoleteData, $obsoleteWhere);
                 }
                 $db->commit();
                 //执行commit
             } catch (Exception $e) {
                 $db->rollBack();
                 //如果出现错误,执行回滚操作
                 $result['result'] = false;
                 $result['info'] = $e->getMessage();
                 fclose($file);
                 echo Zend_Json::encode($result);
                 exit;
             }
             fclose($file);
         }
     }
     echo Zend_Json::encode($result);
     exit;
 }
Exemple #4
0
 /**
  * @abstract    删除
  * @return      null
  */
 public function removeAction()
 {
     // 返回值数组
     $result = array('success' => true, 'result' => true, 'info' => '删除成功');
     $request = $this->getRequest()->getParams();
     $now = date('Y-m-d H:i:s');
     $user_session = new Zend_Session_Namespace('user');
     $user = $user_session->user_info['employee_id'];
     $json = json_decode($request['json']);
     $deleted = $json->deleted;
     $newbom = new Product_Model_Newbom();
     $fa = new Product_Model_Fa();
     $son = new Product_Model_Son();
     $fadev = new Product_Model_Fadev();
     $sondev = new Product_Model_Sondev();
     $record = new Dcc_Model_Record();
     $review = new Dcc_Model_Review();
     if (count($deleted) > 0) {
         foreach ($deleted as $val) {
             $id = $val->sid;
             $recordkey = $val->recordkey;
             // 操作记录
             $data = array('type' => "bom", 'table_name' => "oa_product_bom_new", 'table_id' => $id, 'handle_user' => $user, 'handle_time' => $now, 'action' => "删除", 'ip' => $_SERVER['REMOTE_ADDR']);
             try {
                 // 增加record记录
                 $record->insert($data);
                 // 删除bom表
                 $fa->delete("sid = {$id}");
                 $son->delete("recordkey = {$recordkey}");
                 if ($val->nid) {
                     $fadev->delete("recordkey = {$recordkey}");
                     $sondev->delete("recordkey = {$recordkey}");
                 }
             } catch (Exception $e) {
                 $result['result'] = false;
                 $result['info'] = $e->getMessage();
                 echo Zend_Json::encode($result);
                 exit;
             }
         }
     }
     echo Zend_Json::encode($result);
     exit;
 }