/** * 获取最新申购单编号 * @param unknown $type_id * @return string */ public function getNewNum($type_id) { $type = new Erp_Model_Purchse_Type(); $data = $type->fetchRow("id = " . $type_id)->toArray(); $type_code = $data['code']; $pre = 'PR' . $type_code; $num_pre = $pre . date('ymd'); $data = $this->fetchAll("number like '" . $num_pre . "%'", array('number desc')); if ($data->count() == 0) { $num = '01'; } else { $last_item = $data->getRow(0)->toArray(); $new_order = intval(substr($last_item['number'], strlen($pre) + 6)) + 1; $num = sprintf("%02d", $new_order); } return $num_pre . $num; }
/** * 编辑采购类别信息 */ public function edittypeAction() { // 返回值数组 $result = array('success' => true, 'info' => '编辑成功'); $request = $this->getRequest()->getParams(); $now = date('Y-m-d H:i:s'); $user_session = new Zend_Session_Namespace('user'); $user_id = $user_session->user_info['user_id']; $json = json_decode($request['json']); $updated = $json->updated; $inserted = $json->inserted; $deleted = $json->deleted; $type = new Erp_Model_Purchse_Type(); if (count($updated) > 0) { foreach ($updated as $val) { $data = array('active' => $val->active, 'chk_package_qty' => $val->chk_package_qty, 'code' => $val->code, 'name' => $val->name, 'tpl_id' => $val->tpl_id, 'req_flow_id' => $val->req_flow_id, 'order_flow_id' => $val->order_flow_id, 'description' => $val->description, 'remark' => $val->remark, 'update_time' => $now, 'update_user' => $user_id); if ($type->fetchAll("id != " . $val->id . " and (name = '" . $val->name . "' or code = '" . $val->code . "')")->count() > 0) { $result['success'] = false; $result['info'] = '采购类别:' . $val->name . "已存在,请勿重复添加!"; } else { try { $type->update($data, "id = " . $val->id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } if (count($inserted) > 0) { foreach ($inserted as $val) { $data = array('active' => $val->active, 'chk_package_qty' => $val->chk_package_qty, 'code' => $val->code, 'name' => $val->name, 'tpl_id' => $val->tpl_id, 'req_flow_id' => $val->req_flow_id, 'order_flow_id' => $val->order_flow_id, 'description' => $val->description, 'remark' => $val->remark, 'create_time' => $now, 'create_user' => $user_id, 'update_time' => $now, 'update_user' => $user_id); if ($type->fetchAll("name = '" . $val->name . "' or code = '" . $val->code . "'")->count() > 0) { $result['success'] = false; $result['info'] = '采购类别:' . $val->name . "已存在,请勿重复添加!"; } else { try { $type->insert($data); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } } } if (count($deleted) > 0) { $req = new Erp_Model_Purchse_Req(); foreach ($deleted as $val) { if ($req->fetchAll("type_id = " . $val->id)->count() == 0) { try { $type->delete("id = " . $val->id); } catch (Exception $e) { $result['success'] = false; $result['info'] = $e->getMessage(); echo Zend_Json::encode($result); exit; } } else { $result['success'] = false; $result['info'] = '采购类别' . $val->name . '已使用,不能删除'; echo Zend_Json::encode($result); exit; } } } echo Zend_Json::encode($result); exit; }