if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'sVersion') 
BEGIN
INSERT INTO [T_WORKERQUEUEPARAMETER]
           ([F_ID]
           ,[F_VALUE]
           ,[F_SHOPID]
           ,[F_REMARK]
           ,[F_ISHIDE]
           ,[F_TYPE],
            F_VERSION,
            F_ADDDATE)
     VALUES
           ('sVersion'
           ,''
           ,null
           ,'全店小版本文件名'
           ,0
           ,'基础设置'
           ,'17.2.100'
           ,'2016-09-27');

END
go
if not exists(select * from T_SYSTEM where F_ID = 'sVersion') 
BEGIN
  INSERT INTO T_SYSTEM (F_ID, F_VALUE,  F_REMARK,  F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('sVersion', '', '分店小版本文件名',  '基础设置', '17.2.100', '2016-09-27');
END
GO




--hj
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsAddClockPrior') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsAddClockPrior', '0', NULL, '固定排钟，加钟是否优钟', 0, '排钟', '17.2.101', '2016-09-29');
END

GO


if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsWorkerQueueByLevel') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsWorkerQueueByLevel', '0', NULL, '是否按职务级别排钟', 0, '排钟', '17.2.101', '2016-10-02');
END

GO


IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_CONSUME') and Name='F_HEADSHIPLEVEL')
BEGIN  
    ALTER TABLE T_CONSUME ADD F_HEADSHIPLEVEL INTEGER
END

GO



IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[V_CONSUMENOTCHECKOUT]'))
  DROP VIEW [V_CONSUMENOTCHECKOUT]

GO

CREATE VIEW [V_CONSUMENOTCHECKOUT] AS 
SELECT
	dbo.T_CONSUME.F_ID,
	dbo.T_CONSUME.F_RECEIVEID,
	dbo.T_CONSUME.F_GOODSID,
	dbo.T_CONSUME.F_PRICE,
	dbo.T_CONSUME.F_AMOUNT,
	dbo.T_CONSUME.F_ISPRESENT,
	dbo.T_CONSUME.F_CANREBATE,
	dbo.T_CONSUME.F_REBATE,
	dbo.T_CONSUMEWORKER.F_HEADSHIPID,
	dbo.T_HEADSHIP.F_NAME AS F_HEADSHIPNAME,
	dbo.T_CONSUMEWORKER.F_WORKERID,
	dbo.T_CONSUMEWORKER.F_ISNAMED,
	dbo.T_CONSUME.F_REMARK,
	dbo.T_CONSUME.F_USERID,
	dbo.T_CONSUME.F_COST,
	dbo.T_CONSUME.F_STATE,
	dbo.T_GOODS.F_NAME,
	dbo.T_GOODS.F_GOODSTYPEID,
	dbo.T_GOODSTYPE.F_NAME AS F_GOODSTYPENAME,
	dbo.T_GOODS.F_GOODSTYPE1ID,
	dbo.T_GOODSTYPE1.F_NAME AS F_GOODSTYPE1NAME,
	dbo.T_GOODSTYPE1.F_STATE AS F_GOODSTYPE1STATE,
	dbo.T_GOODSTYPE1.F_ISSTORAGE,
	dbo.T_RECEIVE.F_DATETIME,
	dbo.T_RECEIVE.F_CHECKOUTID,
	dbo.T_RECEIVE.F_SHOPID,
	dbo.T_RECEIVE.F_HANDBRANDID,
	dbo.T_HANDBRAND.F_SHOWID AS F_HANDBRANDSHOWID,
	dbo.T_RECEIVE.F_ROOMID,
	dbo.T_ROOM.F_SHOWID AS F_ROOMSHOWID,
	dbo.T_RECEIVE.F_JOINID,
	dbo.T_RECEIVE.F_AMOUNT AS F_PERSONTOTALAMOUNT,
	dbo.T_RECEIVE.F_MALEAMOUNT,
	dbo.T_CONSUME.F_STARTDATETIME,
	dbo.T_CONSUME.F_ENDDATETIME,
	dbo.T_GOODS.F_STARTTIMES,
	dbo.T_GOODS.F_STARTTIMESPRICE,
	dbo.T_GOODS.F_TIMES,
	dbo.T_GOODS.F_TIMESPRICE,
	dbo.T_CONSUMEWORKER.F_ID AS F_CONSUMEWORKERID,
	dbo.T_CONSUME.F_ENTERDATETIME,
	(CASE WHEN T_RECEIVE.F_MEMORANDUM IS NOT NULL THEN T_RECEIVE.F_MEMORANDUM  ELSE dbo.T_RECEIVE.F_REMARK END) AS F_RECEIVEREMARK,
	dbo.T_CONSUMEWORKER.F_GOODSDEDUCTAUTOID,
	dbo.T_CONSUMEWORKER.F_OUTDATETIME,
	dbo.T_CONSUMEWORKER.F_BACKDATETIME,
	dbo.T_CONSUME.F_MINISTERID,
	dbo.T_GOODS.F_ISSMALL,
	dbo.T_CONSUMEWORKER.F_ISADDCLOCK,
	dbo.T_CONSUME.F_DELAY,
	dbo.T_CONSUME.F_DELAYID,
	dbo.T_RECEIVE.F_PRIORCHECKOUTID,
	dbo.T_CONSUME.F_ISPRIOR,
	dbo.T_CONSUMEWORKER.F_WALKTHROUGHINDEX,
	dbo.T_CONSUMEWORKER.F_ISSTOPWALKTHROUGH,
	dbo.T_CONSUMEWORKER.F_ENTERDATETIME AS F_WORKERENTERDATETIME,
	dbo.T_GOODS.F_HEADSHIPTRAIT AS F_GOODSHEADSHIPTRAIT,
	dbo.T_RECEIVE.F_ISSTOPAUTOTEA,
	dbo.T_WORKER.F_ID AS F_SHOWWORKERID,
	t1.F_ID AS F_SHOWMINISTERID,
	dbo.T_GOODS.F_ISEXTERNALSOUND,
    T_CONSUME.F_SATISFYCOMSUMEWORKERID,
    dbo.T_RECEIVE.F_CLIENTID,
    dbo.T_CONSUME.F_SEATNUMBER,
	dbo.T_CONSUME.F_HEADSHIPLEVEL
FROM
	dbo.T_RECEIVE
INNER JOIN dbo.T_CONSUME ON dbo.T_RECEIVE.F_ID = dbo.T_CONSUME.F_RECEIVEID
AND dbo.T_RECEIVE.F_CHECKOUTID IS NULL
LEFT OUTER JOIN dbo.T_CONSUMEWORKER ON dbo.T_CONSUME.F_ID = dbo.T_CONSUMEWORKER.F_CONSUMEID
LEFT OUTER JOIN dbo.T_HEADSHIP ON dbo.T_CONSUMEWORKER.F_HEADSHIPID = dbo.T_HEADSHIP.F_ID
LEFT OUTER JOIN dbo.T_GOODS ON dbo.T_CONSUME.F_GOODSID = dbo.T_GOODS.F_ID
LEFT OUTER JOIN dbo.T_GOODSTYPE ON dbo.T_GOODS.F_GOODSTYPEID = dbo.T_GOODSTYPE.F_ID
LEFT OUTER JOIN dbo.T_GOODSTYPE1 ON dbo.T_GOODS.F_GOODSTYPE1ID = dbo.T_GOODSTYPE1.F_ID
LEFT OUTER JOIN dbo.T_ROOM ON dbo.T_RECEIVE.F_ROOMID = dbo.T_ROOM.F_ID
LEFT OUTER JOIN dbo.T_HANDBRAND ON dbo.T_RECEIVE.F_HANDBRANDID = dbo.T_HANDBRAND.F_ID
LEFT OUTER JOIN dbo.T_WORKER ON dbo.T_CONSUMEWORKER.F_WORKERID = dbo.T_WORKER.F_ARCHIVESID
LEFT OUTER JOIN dbo.T_WORKER AS t1 ON dbo.T_CONSUME.F_MINISTERID = t1.F_ARCHIVESID

GO