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; }
/** * @abstract 作废 * @return null */ public function obsoleteAction() { // 返回值数组 $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(); $fadev = new Product_Model_Fadev(); $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表 $udata = array('state' => 'Obsolete'); $fa->update($udata, "sid = {$id}"); $fadev->update($udata, "recordkey = {$recordkey}"); } catch (Exception $e) { $result['result'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } echo Zend_Json::encode($result); exit; }