update T_POPEDOM set F_IsTempPopedom = 1 where F_ID in ('2000','2100')

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'PedicureShowGoodsIds')
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES 
  ('PedicureShowGoodsIds', NULL, NULL, '小项卡额外可见的项目编号（非小项目编号加入后小项卡录单中就可以看见）', 0, '排钟');
END;

go


if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'DontOverTimeMinute') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('DontOverTimeMinute', '0', NULL, '提前多少分钟上班不算加班(排钟过轮+延后排)', 0, '排钟', '17.2.107', '2017-04-02');
END

GO




if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsUseSpecialdMixRule') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsUseSpecialdMixRule', '0', NULL, '是否启用特殊混排规则', 0, '排钟', '17.2.107', '2017-04-02');
END

GO

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'AddTurnHeadShipByPlanAddClock') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('AddTurnHeadShipByPlanAddClock', '', NULL, '排钟加钟增加轮数的职务', 0, '排钟', '17.2.107', '2017-04-02');
END

GO

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsDontAddMixTurnHeadShipByPlanAddClock') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsDontAddMixTurnHeadShipByPlanAddClock', '0', NULL, '排钟加钟时不增加混排轮数', 0, '排钟', '17.2.107', '2017-04-02');
END

GO


if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsDontAddMixTurnHeadShipByOverTime') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsDontAddMixTurnHeadShipByOverTime', '0', NULL, '加班时不增加混排轮数', 0, '排钟', '17.2.107', '2017-04-02');
END

GO


if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'OneTurnPerOrderHeadShip') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('OneTurnPerOrderHeadShip', '', NULL, '一单一轮的职务', 0, '排钟', '17.2.107', '2017-04-02');
END

GO

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsStopAutoDispathByOverTime') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsStopAutoDispathByOverTime', '0', NULL, '加班技师暂停自动排钟', 0, '排钟', '17.2.107', '2017-04-05');
END

GO


if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsUseInputPersonAmountFlow') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE,F_VERSION, F_ADDDATE) VALUES
   ('IsUseInputPersonAmountFlow', '0', NULL, '启用手工输入人数流程', 0, '排钟', '17.2.107', '2017-04-05');
END


GO

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

GO
UPDATE dbo.T_RECEIVE SET F_PersonAmount = F_AMOUNT;

GO

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

GO



--hj
if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'PedicureShowGoodsIds')
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES 
  ('PedicureShowGoodsIds', NULL, NULL, '小项卡额外可见的项目编号（非小项目编号加入后小项卡录单中就可以看见）', 0, '排钟');
END;

go


update T_POPEDOM set F_IsTempPopedom = 1 where F_ID in ('2000','2100')






if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsShowWaitHeadShipIds')
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES 
  ('IsShowWaitHeadShipIds', NULL, NULL, '智钟宝查询等待的数量的职务编号', 0, '排钟');
END;

go





--茶水加编号字段
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = N'V_GRATISTCONSUMEByCheckout')
BEGIN   
  DROP View V_GRATISTCONSUMEByCheckout;
END

GO
CREATE VIEW [dbo].[V_GRATISTCONSUMEByCheckout]
AS
SELECT     T_GRATISTCONSUME.F_ID, T_CHECKOUT.F_DATETIME, T_GRATISTCONSUME.F_RECEIVEID, T_GRATISTCONSUME.F_GOODSID, T_GOODS.F_NAME AS F_GOODSNAME, 
                      T_GOODS.F_GOODSTYPEID, T_GOODSTYPE.F_NAME AS F_GOODSTYPENAME, T_GOODS.F_GOODSTYPE1ID, T_GOODSTYPE1.F_NAME AS F_GOODSTYPE1NAME, 
                      T_GOODS.F_PRICE AS F_GOODSPRICE, T_GRATISTCONSUME.F_PRICE, T_GRATISTCONSUME.F_AMOUNT, T_GRATISTCONSUME.F_REMARK, T_RECEIVE.F_USERID, 
                      T_RECEIVE.F_SHOPID, T_GRATISTCONSUME.F_STATE, T_RECEIVE.F_HANDBRANDID, T_RECEIVE.F_ROOMID, T_TEABILL.F_STARTDATETIME, 
                      T_TEABILL.F_ENDDATETIME, T_TEABILL.F_WORKERID, T_WORKER.F_ID AS F_SHOWWORKERID, T_GRATISTCONSUME.F_STARTDATETIME AS F_ENTERDATETIME, 
                      T_GRATISTCONSUME.F_ROOMAREA, T_GOODS.F_SHOWID AS F_GOODSSHOWID
FROM         T_GRATISTCONSUME INNER JOIN
                      T_TEABILL ON T_TEABILL.F_ID = T_GRATISTCONSUME.F_TEABILLID INNER JOIN
                      T_GOODS ON T_GRATISTCONSUME.F_GOODSID = T_GOODS.F_ID INNER JOIN
                      T_GOODSTYPE ON T_GOODS.F_GOODSTYPEID = T_GOODSTYPE.F_ID INNER JOIN
                      T_GOODSTYPE1 ON T_GOODS.F_GOODSTYPE1ID = T_GOODSTYPE1.F_ID INNER JOIN
                      T_RECEIVE ON T_GRATISTCONSUME.F_RECEIVEID = T_RECEIVE.F_ID INNER JOIN
                      T_CHECKOUT ON T_RECEIVE.F_CHECKOUTID = T_CHECKOUT.F_ID LEFT OUTER JOIN
                      T_WORKER ON T_GRATISTCONSUME.F_MINISTERID = T_WORKER.F_ARCHIVESID


GO





--项目加编号字段
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = N'V_CONSUME')
BEGIN   
  DROP View V_CONSUME;
END

GO
CREATE VIEW [dbo].[V_CONSUME]
AS
SELECT     T_CONSUME.F_ID, T_CHECKOUT.F_ID AS F_CHECKOUTID, T_CHECKOUT.F_DATETIME, T_CHECKOUT.F_USERID AS F_CHECKOUTUSERID, T_CONSUME.F_RECEIVEID, 
                      T_CONSUME.F_GOODSID, T_GOODS.F_NAME AS F_GOODSNAME, T_GOODS.F_GOODSTYPEID, T_GOODSTYPE.F_NAME AS F_GOODSTYPENAME, 
                      T_GOODS.F_GOODSTYPE1ID, T_GOODSTYPE1.F_NAME AS F_GOODSTYPE1NAME, T_GOODS.F_PRICE AS F_GOODSPRICE, T_CONSUME.F_OLDPRICE, 
                      T_CONSUME.F_PRICE, T_CONSUME.F_AMOUNT, T_CONSUME.F_RECEIVABLESUM AS F_SUM, T_CONSUME.F_ISPRESENT, T_CONSUME.F_CANREBATE, 
                      T_CONSUME.F_REBATE, T_CONSUME.F_REMARK, T_CONSUME.F_USERID, T_CHECKOUT.F_SHOPID, T_CHECKOUT.F_CLIENTID, T_CHECKOUT.F_TYPE, 
                      T_CONSUME.F_COST, T_CONSUME.F_STATE, T_CONSUME.F_STARTDATETIME, T_CONSUME.F_ENDDATETIME, T_RECEIVE.F_HANDBRANDID, T_RECEIVE.F_ROOMID, 
                      T_RECEIVE.F_TRANSMITGROUP, T_CONSUME.F_ISPROMOTION, T_CONSUME.F_ISTOGO, T_CONSUME.F_ISTIME, T_CONSUME.F_TIMEMEMBERID, 
                      T_CONSUME.F_CLIENTREBATE, T_CONSUME.F_CLIENTGOODSREBATE, T_CONSUME.F_PROMOTIONREBATE, T_CONSUME.F_CHECKOUTREBATE, 
                      T_CONSUME.F_GATHERINGSUM, T_CONSUME.F_OLDSUM, T_CONSUME.F_RECEIVABLESUM, T_CONSUME.F_WORKERDEDUCT, 
                      T_RECEIVE.F_AMOUNT AS F_PERSONTOTALAMOUNT, T_RECEIVE.F_MALEAMOUNT, T_CONSUME.F_ENTERDATETIME, T_CONSUME.F_TICKETMONEY, 
                      T_CONSUME.F_SEATNUMBER, T_CONSUME.F_ExpenseCardID, T_CONSUME.F_ExpenseCardCode, T_CONSUME.F_ROOMAREA, T_GOODS.F_SHOWID AS F_GOODSSHOWID
FROM         T_CONSUME INNER JOIN
                      T_RECEIVE ON T_CONSUME.F_RECEIVEID = T_RECEIVE.F_ID INNER JOIN
                      T_CHECKOUT ON T_RECEIVE.F_CHECKOUTID = T_CHECKOUT.F_ID LEFT OUTER JOIN
                      T_GOODS ON T_CONSUME.F_GOODSID = T_GOODS.F_ID LEFT OUTER JOIN
                      T_GOODSTYPE ON T_GOODS.F_GOODSTYPEID = T_GOODSTYPE.F_ID LEFT OUTER JOIN
                      T_GOODSTYPE1 ON T_GOODS.F_GOODSTYPE1ID = T_GOODSTYPE1.F_ID


GO


-----------------------107删除备份----------------------------

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_RECEIVE_H') and Name='F_PersonAmount')
BEGIN  
        ALTER TABLE T_RECEIVE_H ADD F_PersonAmount int 

END

go


IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DELETE_RECEIVE') and Name='F_PersonAmount')
BEGIN  
        ALTER TABLE T_DELETE_RECEIVE ADD F_PersonAmount int 

END

go
IF NOT EXISTS(
SELECT * 
   FROM syscolumns 
   WHERE id=object_id('T_DELETE_CONSUME') and Name='F_HEADSHIPLEVEL')
BEGIN
        ALTER TABLE T_DELETE_CONSUME DROP COLUMN F_ExpenseCardID
        ALTER TABLE T_DELETE_CONSUME DROP COLUMN F_ExpenseCardCode
        ALTER TABLE T_DELETE_CONSUME DROP COLUMN F_ROOMAREA
        
        ALTER TABLE T_DELETE_CONSUME ADD F_HEADSHIPLEVEL int
        ALTER TABLE T_DELETE_CONSUME ADD F_GOODSPLUSPARENTID varchar(20)
		ALTER TABLE T_DELETE_CONSUME ADD F_ExpenseCardID varchar(20)
		ALTER TABLE T_DELETE_CONSUME ADD F_ExpenseCardCode varchar(20)
        ALTER TABLE T_DELETE_CONSUME ADD F_ROOMAREA varchar(20)

END

GO