106 lines
3.1 KiB
TypeScript
106 lines
3.1 KiB
TypeScript
|
import GameUtil from "../core/GameUtil";
|
|||
|
|
import DB from "../utils/DB";
|
|||
|
|
import ShopItem from "./ShopItem";
|
|||
|
|
|
|||
|
|
export default class Shop {
|
|||
|
|
private static _shared:Shop;
|
|||
|
|
nMaxID:number;
|
|||
|
|
mapItem:any;
|
|||
|
|
// 全部存档
|
|||
|
|
static saveAll(callback:(msg:string)=>void){
|
|||
|
|
this.shared.saveAll(callback);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
static get shared():Shop{
|
|||
|
|
if(!this._shared){
|
|||
|
|
this._shared=new Shop();
|
|||
|
|
}
|
|||
|
|
return this._shared;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
constructor() {
|
|||
|
|
this.nMaxID = 0;
|
|||
|
|
this.mapItem = {};
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
init() {
|
|||
|
|
this.readItemFromDB();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
readItemFromDB() {
|
|||
|
|
let strSql = `SELECT * FROM shop_goods`;
|
|||
|
|
DB.query(strSql, (err:any, rows:any) => {
|
|||
|
|
if (err != null)
|
|||
|
|
return;
|
|||
|
|
|
|||
|
|
for (let i = 0; i < rows.length; i++) {
|
|||
|
|
|
|||
|
|
if (GameUtil.getTime() - rows[i].nAddTime > 86400 * 10) // 超过 10 天无人取回直接丢弃
|
|||
|
|
continue;
|
|||
|
|
|
|||
|
|
|
|||
|
|
let stShopItem = new ShopItem(rows[i].nID, rows[i].nConfigID, rows[i].nKind, rows[i].nSubKind, rows[i].strJson, rows[i].nSeller, rows[i].nAddTime, rows[i].nPrice, rows[i].nCnt, rows[i].nSellCnt, );
|
|||
|
|
this.mapItem[stShopItem.nID] = stShopItem;
|
|||
|
|
}
|
|||
|
|
});
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
FindShopItem(nID:any):any{
|
|||
|
|
if (this.mapItem.hasOwnProperty(nID) == false)
|
|||
|
|
return null;
|
|||
|
|
|
|||
|
|
return this.mapItem[nID];
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
GetMaxID() {
|
|||
|
|
let nMax = 0;
|
|||
|
|
for (let it in this.mapItem) {
|
|||
|
|
if (Number(it) > nMax)
|
|||
|
|
nMax = Number(it);
|
|||
|
|
}
|
|||
|
|
return nMax;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
IsIteamCanSell(nID:any) {
|
|||
|
|
if (nID >= 30001 && nID <= 30030)
|
|||
|
|
return false;
|
|||
|
|
|
|||
|
|
if (GameUtil.isDataInVecter(nID, [10202, 10116, 10201, 50004, 10301, 10302, 10303, 10406, 10401]))
|
|||
|
|
return false;
|
|||
|
|
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
// 全部存档
|
|||
|
|
saveAll(callback:(msg:string)=>void) {
|
|||
|
|
let total = GameUtil.getMapLen(this.mapItem);
|
|||
|
|
if (total == 0) {
|
|||
|
|
let msg=`商城存档:数量少于1个，无需存档!`;
|
|||
|
|
callback(msg);
|
|||
|
|
return;
|
|||
|
|
}
|
|||
|
|
let clear = 'TRUNCATE TABLE shop_goods';
|
|||
|
|
let sql = '';
|
|||
|
|
for (let key in this.mapItem) {
|
|||
|
|
let item = this.mapItem[key];
|
|||
|
|
let insert = `INSERT INTO shop_goods(nID,nConfigID, nKind, nSubKind, strJson, nSeller,nAddTime,nPrice,nCnt,nSellCnt) values( ${item.nID},${item.nConfigID} ,${item.nKind} ,0,'${item.strJson}',${item.nSeller},${item.nAddTime},${item.nPrice},${item.nCnt},${item.nSellCnt});`;
|
|||
|
|
sql += insert;
|
|||
|
|
}
|
|||
|
|
DB.query(clear,(error: any, rows: any[]) =>{
|
|||
|
|
if (error != null) {
|
|||
|
|
let msg=`商城存档:无法清空表!`;
|
|||
|
|
callback(msg);
|
|||
|
|
return;
|
|||
|
|
}
|
|||
|
|
DB.query(sql,(error: any, rows: any[]) =>{
|
|||
|
|
if(error != null){
|
|||
|
|
let msg=`商城存档:无法插入数据!`;
|
|||
|
|
callback(msg);
|
|||
|
|
return;
|
|||
|
|
}
|
|||
|
|
let msg=`商城存档:全部存档成功!`;
|
|||
|
|
callback(msg);
|
|||
|
|
});
|
|||
|
|
});
|
|||
|
|
}
|
|||
|
|
}
|