CN108682093A - A method of medicament unpacking is realized based on pharmacy's POS cash registers - Google Patents

Abstract

The present invention relates to Web pharmacies system platform field, more particularly to a kind of method that medicament unpacking is realized based on pharmacy's POS cash registers.The method of the present invention is as follows：1, it creates and tears zero main single table and detail list, drug table and inventory's batch table open, main table, which is used to store, tears the information such as zero date, quantity, audit state open；2, open stock data is created, the information such as unit after tearing zero open, coefficient, price is set and is put in storage；3, in the cash register page, commodity is selected to tear zero open, inputs after tearing the information such as zero quantity, price open and preserves in tearing zero page face open；4, main single and detail is generated, newly-increased to tear zero product and batch inventory open, active compound product subtract total inventory and batch stockpile number；5, the drug of the change cash register page is to tear zero drug open to be sold；6, zero list is torn in audit open, updates audit state, and zero report data is torn in generation open.The present invention solves when drug tears zero open in the case where not selling in advance and can waste drug, brings maintenance difficult and does not tear the problem of zero drug is inconvenient to sell etc. open.

Description

A method of medicament unpacking is realized based on pharmacy's POS cash registers

Technical field

The present invention relates to Web pharmacies system platform fields, more particularly to a kind of to realize medicament unpacking based on pharmacy's POS cash registers Method.

Background technology

It is to tear zero drug open that we, which obtained and what is taken off, first, and so-called zero drug of tearing open refers to pharmacy, clinic by integral packaging Unit（Bottle, box）Drug split after the drug being sold, used.It answers《Pharmaceutical Administration Law of the People's Republic of China》And in fact Apply regulations with《Pharmaceutical business quality management practices》And its detailed rules for the implementation, when zero drug is torn in sale open, it is necessary to generate relevant tear open Zero record.When drug is sold by pharmacy, if in advance all drugs are all carried out to tear zero open, the first waste drug is done so, The secondary drug torn open after zero, without packaged information, maintenance is extremely difficult；But if not tearing zero open in advance, using tearing open by hand when sale Zero, it not only wastes time, but also be easy error, seriously affects the progress of sale；In order to solve these problems, it needs to realize a kind of It can rapidly be torn open zero to sale drug when cash register, nought state, addition open stock inventory information etc. are torn in update open Function.

Invention content

Present invention solves the technical problem that being to provide a kind of method for realizing medicament unpacking based on pharmacy's POS cash registers；This Invention solves when drug tears zero open in the case where not selling in advance and can waste drug, brings maintenance difficult and does not tear zero drug open The problem of being inconvenient to sell etc..

The present invention solve above-mentioned technical problem technical solution be：

1, it creates and tears zero main single table and detail list, drug table and inventory's batch table open, main table was torn for zero date open for storage, quantity, examined The information such as nuclear state；2, open stock data is created, the information such as unit after tearing zero open, coefficient, price is set and is put in storage；3, it is receiving The silver-colored page selects commodity to tear zero open, inputs after tearing the information such as zero quantity, price open and preserves in tearing zero page face open；4, it generates main single and bright Carefully, it increases newly and tears zero product and batch inventory open, active compound product subtract total inventory and batch stockpile number；5, the drug of the change cash register page is Zero drug is torn open to be sold；6, zero list is torn in audit open, updates audit state, and zero report data is torn in generation open.To which the present invention solves Drug can waste drug when tearing zero open in advance in the case where not selling, and bringing maintenance difficult and not tearing zero drug open is inconvenient to sell Etc. the problem of.

The method specifically comprises the following steps：

Zero main single table and detail list, drug table and inventory's batch table are torn open Step 1: creating, and main table, which is used to store, tears zero date, number open The information such as amount, audit state；

Step 2: newly-built open stock data, sets the information such as unit after tearing zero open, coefficient, price, preserve；It is newly-increased to survey Library is single, selects drug, fills in warehousing quantity, increases this drug stock information after preserving audit；

Step 3: in the cash register page, commodity is selected to tear zero open, zero button is torn in click open, and zero typing window is torn in pop-up open, and zero number is torn in input open Measure, tear zero open after preserve after the information such as retail price, price for member；

Step 4: by background process, main single and detail is generated, if this drug has torn zero open, the total inventory of zero drug is torn in increase open, Otherwise newly-increased to tear zero product information open and tear uneven lot time inventory information, the total inventory's subtrahend amount of active compound product, corresponding batch inventory subtrahend open Amount；

Step 5: the drug of the change cash register page is to tear zero medicine information open, such as product coding, retail price, unit are sold, Msu message is sent to the pending case of auditor simultaneously；

Step 6: auditor receives msu message by pending case, clickthrough, which enters, tears zero single, click audit button bullet open Go out and audit window, the information such as input audit opinion preserve, and zero single audit state is torn in change open, and zero report data is torn in generation open.

Beneficial effects of the present invention：Zero power energy is torn open by being realized in POS cashier of pharmacy, simplifies the mistake that craft tears zero open Journey has saved the time that zero drug is torn in sale open, has reached quickly sell in cash register and has torn zero drug open and will not waste drug money The purpose in source.Present invention efficiently solves drugs can waste drug when tearing zero open in advance in the case where not selling, bring maintenance The problem of drug that is difficult and not tearing zero open is inconvenient to sell etc..

Description of the drawings

The following further describes the present invention with reference to the drawings：

Fig. 1 is the flow chart of the present invention.

Specific implementation mode

As shown in Figure 1, the present invention uses following steps：

Zero main single table and detail list, drug table and inventory's batch table are torn open Step 1: creating, and main table, which is used to store, tears zero date, number open The information such as amount, audit state；Such as：

// 1, main single table

CREATE TABLE ` split_order` (

`id` varchar(50) NOT NULL,

`splitNo` varchar(50) DEFAULT NULL,

`splitUser` varchar(30) DEFAULT NULL,

`splitType` int(11) DEFAULT NULL,

`splitDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_ TIMESTAMP,

`auditState` int(11) DEFAULT NULL,

`auditor` varchar(30) DEFAULT NULL,

`auditorId` varchar(50) DEFAULT NULL,

……

PRIMARY KEY (`productSplitId`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

// 2, detail list

CREATE TABLE `split_order_detail` (

`id` varchar(50) NOT NULL,

`splitNo` varchar(50) DEFAULT NULL,

`productId` varchar(50) DEFAULT NULL,

`productCode` varchar(20) DEFAULT NULL,

`productName` varchar(200) DEFAULT NULL,

`genericName` varchar(200) DEFAULT NULL,

`scatteredCoefficient` varchar(20) DEFAULT NULL,

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

`afterScatteredUnit` varchar(20) DEFAULT NULL,

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

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

`afterMemberPrice` 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;

// other tables

……

Step 2: newly-built open stock data, sets the information such as unit after tearing zero open, coefficient, price, preserve；It is newly-increased to survey Library is single, selects drug, fills in warehousing quantity, increases this drug stock information after preserving audit；

Step 3: in the cash register page, commodity is selected to tear zero open, zero button is torn in click open, and zero typing window is torn in pop-up open, and zero number is torn in input open Measure, tear zero open after preserve after the information such as retail price, price for member；

Step 4: by background process, main single and detail is generated, if this drug has torn zero open, the total inventory of zero drug is torn in increase open, Otherwise newly-increased to tear zero product information open and tear uneven lot time inventory information, the total inventory's subtrahend amount of active compound product, corresponding batch inventory subtrahend open Amount；Such as：

public SplitDetail insertSplitOrderByPos(SplitOrder model) {

The main single essential information of // 1 setting, is added to database

Date now = DateUtil.getCurrDateTime();

LocalUser localUser = SessionUtil.getLocalUser();

If (model==null) throw new CustomerException (" it cannot be sky to tear zero data open ");

if (model.getDetails() == null || model.getDetails().size() == 0) Throw new CustomerException (" it cannot be sky to tear zero detailed data open ");

Model.setRemark (" pos tears zero open ");

model.setId(StringUtil.getUUID());

model.setCreateDate(now);

model.setAuditState(Status.FORBIDDEN.getValue());

……

saleProductSplitDAO.insert(model);// interpolation data library

SplitDetail resultDetail = null;

for (SplitDetail detail : model.getDetails()) {

resultDetail = detail;

// 2 additions are detailed

BaseProduct baseProduct = baseProductService.findById(detail.getProductId ());

If (baseProduct==null) throw new CustomerException (" do not have such production in commodity list Product ("+detail.getProductCode ()+") ");

detail.setId(StringUtil.getUUID());detail.setProductCode (StockConstant.SPLIT_PREF);detail.setAfterSplitCount(detail.getSplitCount() * Long.parseLong(detail.getScatteredCoefficient()));

detail.setSplitNo(model.getSplitNo());

detail.setAuditState(Status.NORMAL.getValue());

detail.setAuditUser(model.getAuditor());

……

splitDetailDAO.insert(detail);// it is inserted into detail

// 3. progress products subtract inventory baseProduct.setTotalStorage (baseProduct.getTotalStora ge().subtract(stockBatchInventory.getStockCount()));

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

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

whereList.add(Condition.createEq("productId", baseProduct.getProductId ()));updateList.add(Condition.createEq("totalStorage", baseProduct.getTotalStorage()));

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

map.put("updateList", updateList);

map.put("whereList", whereList);

baseProductDAO.updateByParam(map);

// 4. additions are torn open in zero product to product table, if had originally, are just added

BaseProductExample baseProductExample = new BaseProductExample();

BaseProductExample.Criteria baseProductExampleCriteria = baseProductExample.createCriteria();baseProductExampleCriteria.andStoreIdEqu alTo(localUser.getStoreId());baseProductExampleCriteria.andProductCodeEqualT o(detail.getProductCode());

List<BaseProduct> baseProductList = baseProductDAO.selectByExample (baseProductExample);

BaseProduct newProduct = new BaseProduct();

if (baseProductList != null && baseProductList.size() >0) { // update originates in Product

BaseProduct oldProduct = baseProductList.get(0); oldProduct.setTotalStorage(oldProduct.getTotalStorage().add(new BigDecimal (detail.getAfterSplitCount())));

oldProduct.setRetailPrice(new BigDecimal(detail.getAfterRetailPrice()));

……

baseProductDAO.insert(newProduct);

}

// 5 reduce by a batch inventory stockBatchInventory.setStockCount (stockBatchInventory.getStockCount().subtract(new BigDecimal (detail.getSplitCount())));

updateList = new ArrayList<Condition>();

whereList = new ArrayList<Condition>();

whereList.add(Condition.createEq("inventoryId", stockBatchInventory.getInventoryId()));

whereList.add(Condition.createEq("storeId", localUser.getStoreId())); updateList.add(Condition.createEq("stockCount", stockBatchInventory.getStockCount()));

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

map.put("updateList", updateList);

map.put("whereList", whereList);

stockBatchInventoryDAO.updateByParam(map);

// 6 increase a batch inventory newly

StockBatchInventory newInventory = new StockBatchInventory();

newInventory.setBatchNo(model.getSplitNo());// use and tear zero main single splitNo open as newly Lot number

newInventory.setStoreId(model.getStoreId());

newInventory.setLotNo(model.getSplitNo());

newInventory.setOperator(localUser.getUserName());

newInventory.setOperatorId(localUser.getUserId());

newInventory.setSupplierName(model.getSplitUser());

newInventory = setStockbatchInventroy(newInventory, detail, newProduct); stockBatchInventoryService.insert(newInventory);

}

Step 5: the drug of the change cash register page is to tear zero medicine information open, such as product coding, retail price, unit are sold, Msu message is sent to the pending case of auditor simultaneously；Such as：

// be substituted for and tear zero list open

function insertSplit(){

$.ajax({

url:url,

data: para,

type: "POST",

success: function (json) {

json = json || {};

if (json.statusCode == 200) {

// update detail table datas

var selRows = $table.bootstrapTable('getSelections');

var selData = selRows[0];

var dataAll = $table.bootstrapTable('getData');

var data = json.data;

$.each(dataAll, function (i, obj) {if(obj.lineNum==selData.lineNum){

obj.inventoryId = data.inventoryId;

obj.productCode = data.productCode;

obj.batchNo = data.batchNo;obj.saleCount=selData.saleCount; obj.retailPrice=data.afterRetailPrice;

obj.stockCount = data.afterSplitCount;

obj.isSplitDrug = 1;

obj.localRetailPrice = data.afterRetailPrice;

obj.originalPrice = data.afterRetailPrice;

……

}

});

// reload

$table.bootstrapTable('load',dataAll);

refreshSaleOrder();

}else if (json.msg) {

MsgAlert (" mistake ", json.msg);

}

});

}

Step 6: auditor receives msu message by pending case, clickthrough, which enters, tears zero single, click audit button bullet open Go out and audit window, the information such as input audit opinion preserve, and zero single audit state is torn in change open, and zero report data is torn in generation open.

Claims (2)

1. a kind of method for realizing medicament unpacking based on pharmacy's POS cash registers, it is characterised in that：One, it creates and tears zero main single table and bright open Thin table, drug table and inventory's batch table, main table tear the information such as zero date, quantity, audit state open for storing；Two, it creates and tears zero open Commodity profile sets the information such as unit after tearing zero open, coefficient, price and is put in storage；Three, in the cash register page, commodity is selected to tear zero open, Input in zero page face is torn open to preserve after tearing the information such as zero quantity, price open；Four, main single and detail is generated, it is newly-increased to tear zero product and batch open Inventory, active compound product subtract total inventory and batch stockpile number；Five, the drug of the change cash register page is to tear zero drug open to be sold；Six, Zero list is torn in audit open, updates audit state, and zero report data is torn in generation open, to which the present invention solves drug in the case where not selling Drug can be wasted when tearing zero open in advance, bring maintenance difficult and do not tear the problem of zero drug is inconvenient to sell etc. open.

2. a kind of method for realizing medicament unpacking based on pharmacy's POS cash registers according to claim 1, it is characterised in that： Drug is carried out when cash register to tear zero open, zero single and detail is torn in generation open, and increase tears the total inventory of zero drug open and tears zero lots of drugs inventory note open Record, reduces the quantity of former batch inventory and total inventory, while it is to tear zero drug open to replace the drug in sale table；The method Specifically comprise the following steps：

Zero main single table and detail list, drug table and inventory's batch table are torn open Step 1: creating, and main table, which is used to store, tears zero date, number open The information such as amount, audit state；

Step 2: newly-built open stock data, sets the information such as unit after tearing zero open, coefficient, price, preserve；It is newly-increased to survey Library is single, selects drug, fills in warehousing quantity, increases this drug stock information after preserving audit；

Step 3: in the cash register page, commodity is selected to tear zero open, zero button is torn in click open, and zero typing window is torn in pop-up open, and zero number is torn in input open Measure, tear zero open after preserve after the information such as retail price, price for member；

Step 4: by background process, main single and detail is generated, if this drug has torn zero open, the total inventory of zero drug is torn in increase open, Otherwise newly-increased to tear zero product information open and tear uneven lot time inventory information, the total inventory's subtrahend amount of active compound product, corresponding batch inventory subtrahend open Amount；

Step 5: the drug of the change cash register page is to tear zero medicine information open, such as product coding, retail price, unit are sold, Msu message is sent to the pending case of auditor simultaneously；

Step 6: auditor receives msu message by pending case, clickthrough, which enters, tears zero single, click audit button bullet open Go out and audit window, the information such as input audit opinion preserve, and zero single audit state is torn in change open, and zero report data is torn in generation open.