CN110619492A - Method for automatically generating excess and deficiency inventory during drug inventory - Google Patents

Abstract

The invention relates to the field of pharmacy systems of SSM (simple sequence modeling) frameworks, in particular to a method for automatically generating a sufficient and insufficient inventory receipt during drug inventory. The method comprises the following steps: firstly, creating an inventory list, an inventory excess and inventory deficiency document list and a detail list; secondly, creating an inventory page and an inventory and shortage bill page; introducing checking medicine information into a checking page, filling abnormal quantity, automatically generating profit and loss amount and storing the profit and loss amount in a checking table; after the warehouse staff verify and confirm that the data are correct, reading the data from the inventory list; fifthly, traversing the obtained inventory data, judging whether the inventory data is larger than zero according to the profit and loss quantity, storing the inventory data into an inventory data set, and if the inventory data is smaller than zero, storing the inventory data set into an inventory shortage set; creating a method for generating documents and details, respectively transmitting the documents and the details into a sufficient and insufficient inventory data set, and adding the documents and the details into a database; and seventhly, displaying the data on a page of the inventory shortage and gain balance document. The invention solves the problems that the excess and shortage of the stock cannot be reflected when the pharmacy checks and no history document can be traced.

Description

Method for automatically generating excess and deficiency inventory during drug inventory

Technical Field

The invention relates to the field of pharmacy systems of SSM (simple sequence modeling) frameworks, in particular to a method for automatically generating a sufficient and insufficient inventory receipt during drug inventory.

Background

When the traditional pharmacy system is used for pharmacy checking, historical data in a checking table is cleared firstly, and then data are introduced from a total product inventory table, so that no historical checking data can be checked; in addition, if the product quantity in the stock table is changed due to abnormality and data statistics of inventory shortage and overage are not carried out, the problems of more medicines, more medicines which are lost, more medicines which are increased and more medicines which are lost in the inventory are not known; in order to solve the problems, a method for looking up the inventory historical data and generating the inventory shortage and gain data statistics is needed.

Disclosure of Invention

The invention solves the technical problem of providing a method for automatically generating a sufficient and insufficient inventory receipt during drug inventory; the problem of can't embody the situation of sufficient inventory shortage and no historical document traceable when the pharmacy inventories is solved.

The technical scheme for solving the technical problems is as follows:

firstly, creating an inventory list, an inventory excess and inventory deficiency document list and a detail list; secondly, creating an inventory page and an inventory and shortage bill page; introducing checking medicine information into a checking page, filling abnormal quantity, automatically generating profit and loss amount and storing the profit and loss amount in a checking table; after the warehouse staff verify and confirm that the data are correct, reading the data from the inventory list; fifthly, traversing the obtained inventory data, judging whether the inventory data is larger than zero according to the profit and loss quantity, storing the inventory data into an inventory data set, and if the inventory data is smaller than zero, storing the inventory data set into an inventory shortage set; creating a method for generating documents and details, respectively transmitting the documents and the details into a sufficient and insufficient inventory data set, and adding the documents and the details into a database; and seventhly, displaying the data on a page of the inventory shortage and gain balance document.

The method specifically comprises the following steps:

step one, establishing an inventory list, an inventory excess and inventory deficiency bill list and a detail list;

step two, establishing an inventory page and an inventory shortage and overage document page, wherein the inventory page only has one main form, and the form is provided with function button introduction, audit and the like; the page of the excess and shortage inventory receipt has a main form and a detail form, and when a main form row is clicked, corresponding detail information is loaded;

step three, introducing checking medicine information into a checking page, filling abnormal quantity, automatically generating profit and loss amount and storing the profit and loss amount in a checking table;

checking by warehouse personnel, and reading data from the inventory list after confirming that the data are correct;

step five, traversing the obtained inventory data, judging whether the inventory data is larger than zero according to the profit and loss quantity, storing the inventory data into an inventory data set, and if the inventory data is smaller than zero, storing the inventory data set into an inventory shortage set;

step six, creating a method for generating documents and details, respectively transmitting the documents and the details into a sufficient and insufficient inventory data set, and adding the documents and the details into a database;

and step seven, displaying the data on a page of the inventory shortage and balance excess document.

The invention has the beneficial effects that: the balance and loss bill information is generated according to the amount of the loss and the benefit during the checking, so that the purpose of counting the amount and the sum of the abnormal medicines during the checking is achieved. The problem that the condition of sufficient inventory and shortage of inventory can not be reflected and no history document can be traced when the pharmacy is inventoried is effectively solved.

Drawings

The invention is further described below with reference to the accompanying drawings:

FIG. 1 is a flow chart of the present invention.

Detailed Description

As shown in fig. 1, the present invention employs the following steps:

step one, establishing an inventory list, an inventory excess and inventory deficiency bill list and a detail list; such as:

// checking table

CREATE TABLE `stockCheck` (

`id` varchar(50) NOT NULL,

`checkDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`productId` varchar(50) DEFAULT NULL,

`productCode` varchar(20) DEFAULT NULL,

`productName` varchar(200) DEFAULT NULL,

`batchNo` varchar(30) DEFAULT NULL,

`checkCount` Integer DEFAULT 0,

……

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I/disc filling and disc loss table, which is distinguished by field type, disc filling when type =0, and disc filling and disc loss when type =1

CREATE TABLE `stockProfitLoss` (

`id` varchar(50) NOT NULL,

`type` int(2) DEFAULT 0,

`profitLossNo` varchar(50) DEFAULT NULL,

`billDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`billMoney` decimal(18,2) DEFAULT NULL,

`auditState` int(11) DEFAULT NULL,

`auditUserId` varchar(30) DEFAULT NULL,

`auditUser` varchar(30) DEFAULT NULL,

……

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

// disc filling and disc depletion particulars

CREATE TABLE `stockProfitLossDetail` (

`id` varchar(50) NOT NULL,

`profitLossNo` varchar(50) DEFAULT NULL,

`productId` varchar(50) DEFAULT NULL,

`productCode` varchar(20) DEFAULT NULL,

`productName` varchar(200) DEFAULT NULL,

`genericName` varchar(200) DEFAULT NULL,

`price` decimal(18,2) DEFAULT NULL,

`amount` decimal(18,2) DEFAULT NULL,

……

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Step two, establishing an inventory page and an inventory shortage and overage document page, wherein the inventory page only has one main form, and the form is provided with function button introduction, audit and the like; the page of the excess and shortage inventory receipt has a main form and a detail form, and when a main form row is clicked, corresponding detail information is loaded;

step three, introducing checking medicine information into a checking page, filling abnormal quantity, automatically generating profit and loss amount and storing the profit and loss amount in a checking table; such as:

// introduction

$("#btnImport ").click(function () {

msgDialog.call(this, '${ctx}/stock/check/import.action','#table',{

title: 'introduction',

url:'${ctx}/views/stock/check/import.jsp',

width: 960,

buttons:[{

text, 'determining',

class: 'button bSuccess',

icon: 'icon-baocun',

handler: function (event) {

var data = $("#table").bootstrapTable("getData");

if (data.length == 0) {

msgAlert ("prompt", "currently No data!", "error");

return;

}

var filters = getFiltersByForm("#searchFormIntroduce");

var modal = event.data.modal;

$("#" + modal.id).iziModal('close');

createProgress(10)

$.ajax({

url: "${ctx}/stock/check/import.action",

type: "POST",

data:JSON.stringify(filters),

contentType:'application/json;charset=utf-8',

success: function (json) {

json = json || {};

clearProgress()

if (json.statusCode == 200) {

// close the bullet frame

$("#table").bootstrapTable('refresh');

} else if (json.msg) {

msgAlert ("error", json. msg, "error");

}

}

});

}

}]

});

});

checking by warehouse personnel, and reading data from the inventory list after confirming that the data are correct; such as:

// audit import data

@Override

@Transactional

public Integer audit(LocalUser localUser) {

Date now = DateUtil.getCurrDateTime();

List<Condition> whereList = new ArrayList<Condition>();

whereList.add(Condition.createEq("auditState", AuditStatus.UNAUDIT.getValue()));

whereList.add(Condition.createEq("storeId", localUser.getStoreId()));

Map<String, Object> map = new HashMap<String, Object>();

map.put("whereList", whereList);

// obtaining data

List<StockCheck> list = stockTakingDAO.listByParam(map);

}

Step five, traversing the obtained inventory data, judging whether the inventory data is larger than zero according to the profit and loss quantity, storing the inventory data into an inventory data set, and if the inventory data is smaller than zero, storing the inventory data set into an inventory shortage set; such as:

// generating different sets

for(StockCheck sc : list){

// adding inventory data if (stock taking. getProfitAtLossCount (). doubleValue () > 0) ready pocket

addStockings.add(stockTaking);

}

// Add discloser data

if(stockTaking.getProfitAndLossCount().doubleValue() < 0){

reduceStockings.add(stockTaking);

}

}

Step six, creating a method for generating documents and details, respectively transmitting the documents and the details into a sufficient and insufficient inventory data set, and adding the documents and the details into a database; such as:

method for creating and generating document

public void saveProfitLoss(LocalUser localUser, Date now, List<StockCheck> list, Integer type) {

StockProfitLoss profitLoss = new StockProfitLoss();

profitLoss.setId(StringUtil.getUUID());

profitLoss.setAuditState(1);

profitLoss.setCreateUserId(localUser.getUserId());

profitLoss.setCreateUserName(localUser.getUserName());

profitLoss.setCreateDate(now);

profitLoss.setModifyDate(now);

profitLoss.setBillDate(now);

profitLoss.setAuditUser(localUser.getUserName());

profitLoss.setBillMoney(BigDecimal.ZERO);

Setemark ("data from inventory");

profitLoss.setType (type);

for(StockCheck sc : list){

try {

StockProfitLossDetail detail = new StockProfitLossDetail();

BeanUtils.copyProperties(detail, stockTaking); detail.setId(StringUtil.getUUID());

detail.setPrice(stockTaking.getPrice());

detail.setAmount(stockTaking.getCount());

……

stockProfitLossDetailDAO.insert(detail);

} catch (Exception e) {

e.printStackTrace();

}

}

stockProfitLossDAO.insert(profitLoss);

}

// Add to database

if(addStockings != null && addStockings.size() > 0){

Generating inventory shortage and overage main document

saveProfitLoss(localUser, now, addStockings, 0);

}

// generating disc defect data

if(reduceStockings != null && reduceStockings.size() > 0){

saveProfitLoss(localUser, now, reduceStockings, 1);

}

And step seven, displaying the data on a page of the inventory shortage and balance excess document.

Claims (2)

1. The utility model provides a method for automatic generation is sufficient to check and is owed document when medicine is checked which characterized in that: firstly, creating an inventory list, an inventory excess and inventory deficiency document list and a detail list; secondly, creating an inventory page and an inventory and shortage bill page; introducing checking medicine information into a checking page, filling abnormal quantity, automatically generating profit and loss amount and storing the profit and loss amount in a checking table; after the warehouse staff verify and confirm that the data are correct, reading the data from the inventory list; fifthly, traversing the obtained inventory data, judging whether the inventory data is larger than zero according to the profit and loss quantity, storing the inventory data into an inventory data set, and if the inventory data is smaller than zero, storing the inventory data set into an inventory shortage set; creating a method for generating documents and details, respectively transmitting the documents and the details into a sufficient and insufficient inventory data set, and adding the documents and the details into a database; and seventhly, the data is displayed on the excess and shortage inventory receipt page, so that the problems that the excess and shortage inventory condition cannot be embodied and no history receipt can be traced when the pharmacy checks are solved.

2. The SSM framework-based method for automatically generating the inventory shortage and overage bill in drug inventory in the field of pharmacy system according to claim 1, wherein the method comprises the following steps: different data sets are respectively stored according to the relationship of the amount of the profit and the amount of the profit automatically generated during inventory, and then a universal method for storing inventory excess and shortage documents and details is realized for storing respectively; the method specifically comprises the following steps:

step one, establishing an inventory list, an inventory excess and inventory deficiency bill list and a detail list;

step two, establishing an inventory page and an inventory shortage and overage document page, wherein the inventory page only has one main form, and the form is provided with function button introduction, audit and the like; the page of the excess and shortage inventory receipt has a main form and a detail form, and when a main form row is clicked, corresponding detail information is loaded;

step three, introducing checking medicine information into a checking page, filling abnormal quantity, automatically generating profit and loss amount and storing the profit and loss amount in a checking table;

checking by warehouse personnel, and reading data from the inventory list after confirming that the data are correct;

step five, traversing the obtained inventory data, judging whether the inventory data is larger than zero according to the profit and loss quantity, storing the inventory data into an inventory data set, and if the inventory data is smaller than zero, storing the inventory data set into an inventory shortage set;

step six, creating a method for generating documents and details, respectively transmitting the documents and the details into a sufficient and insufficient inventory data set, and adding the documents and the details into a database;

and step seven, displaying the data on a page of the inventory shortage and balance excess document.