if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'IsPriorQueueByOutSideWorker') 
BEGIN
INSERT INTO [T_WORKERQUEUEPARAMETER]
           ([F_ID]
           ,[F_VALUE]
           ,[F_SHOPID]
           ,[F_REMARK]
           ,[F_ISHIDE]
           ,[F_TYPE],
            F_VERSION,
            F_ADDDATE)
     VALUES
           ('IsPriorQueueByOutSideWorker'
           ,'0'
           ,null
           ,'外出技师是否按正常顺序排钟'
           ,0
           ,'排钟'
           ,'17.2.102.1503'
           ,'2016-10-11');

END

GO

IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_WORKERQUEUE') and Name='F_ISBREAKTIME')
BEGIN  
	ALTER TABLE T_WORKERQUEUE ADD F_ISBREAKTIME INT NULL
END

GO

IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = N'V_WORKERQUEUE')
BEGIN   
  DROP View V_WORKERQUEUE;
END

GO


CREATE VIEW [dbo].[V_WORKERQUEUE]
AS
    SELECT  dbo.T_WORKERQUEUE.F_WORKERID ,
            dbo.T_WORKER.F_NAME AS F_WORKERNAME ,
            dbo.T_WORKER.F_SEX ,
            dbo.T_WORKER.F_HEADSHIPFLAG ,
            dbo.T_WORKERQUEUE.F_WORKERSTATE ,
            dbo.T_WORKERQUEUE.F_QUEUESTATE ,
            dbo.T_WORKERQUEUE.F_SHOPID ,
            dbo.T_WORKERQUEUE.F_CURRENTINDEX ,
            dbo.T_WORKERQUEUE.F_HEADSHIPID ,
            dbo.T_HEADSHIP.F_NAME AS F_HEADSHIPNAME ,
            dbo.T_WORKERQUEUE.F_SCHEDULEID ,
            dbo.T_WORKERQUEUE.F_TRUNTIMES ,
            dbo.T_WORKERQUEUE.F_ISOVERTIME ,
            dbo.T_WORKERQUEUE.F_ORIGINALINDEX ,
            dbo.T_WORKERQUEUE.F_NEXTINDEX ,
            dbo.T_WORKERQUEUE.F_LASTDATETIME ,
            dbo.T_WORKERQUEUE.F_ISTHEWATCH ,
            CAST(( CASE WHEN ( F_TRUNTIMES <> 0 )
                             AND ( F_ENDDATETIME IS NOT NULL )
                        THEN ( CASE WHEN ( F_TRUNTIMES - DATEDIFF(SECOND,
                                                              F_ENDDATETIME,
                                                              CURRENT_TIMESTAMP) ) < 0
                                    THEN 0
                                    ELSE F_TRUNTIMES - DATEDIFF(SECOND,
                                                              F_ENDDATETIME,
                                                              CURRENT_TIMESTAMP)
                               END )
                        ELSE 0
                   END ) AS INTEGER) AS F_GLOMSECOND ,
            dbo.T_WORKER.F_HEADSHIPTRAIT ,
            dbo.T_WORKER.F_ID AS F_ShowWORKERID ,
            dbo.T_WORKERQUEUE.F_ISWORK,
	    dbo.T_WORKERQUEUE.F_ISBREAKTIME
    FROM    dbo.T_WORKERQUEUE
            INNER JOIN dbo.T_WORKER ON dbo.T_WORKERQUEUE.F_WORKERID = dbo.T_WORKER.F_ARCHIVESID
            INNER JOIN dbo.T_HEADSHIP ON dbo.T_WORKERQUEUE.F_HEADSHIPID = dbo.T_HEADSHIP.F_ID;


GO



--linx 17.2.102.1503 每日次卡次数统计 
IF NOT EXISTS(SELECT * FROM syscolumns WHERE id=object_id('T_EVERYSINGLEDAY') and Name='F_STARTTIMECOUNT')
BEGIN  
  ALTER TABLE T_EVERYSINGLEDAY ADD F_STARTTIMECOUNT decimal(15, 2) NULL 
END

GO

IF NOT EXISTS(
SELECT * FROM syscolumns WHERE id=object_id('T_EVERYSINGLEDAY') and Name='F_ENDTIMECOUNT')
BEGIN  
  ALTER TABLE T_EVERYSINGLEDAY ADD F_ENDTIMECOUNT decimal(15, 2) NULL
END



--hj
IF EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_GOODSPLUS') and Name='F_GOODSPLUSID')
BEGIN   
   ALTER TABLE T_GOODSPLUS alter COLUMN F_GOODSPLUSID varchar(30) null
END



IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = N'V_GoodsPlus')
BEGIN   
  DROP View V_GoodsPlus;
END
GO
CREATE VIEW [dbo].[V_GoodsPlus](
    "F_ID",
    "F_GoodsID",
    "F_GoodsName",
    "F_LevelID",
    "F_LevelName",
    "F_HEADSHIPID",
    "F_HEADSHIPName",
    "F_GOODSPLUSID",
    "F_GOODSPLUSNAME",
    "F_GOODSPLUSPRICE",
    "F_SHOPID")
AS
SELECT 
T_GOODSPLUS.F_ID, 
T_GOODSPLUS.F_GoodsID,
T_GOODS.F_NAME as F_GoodsName,
T_GOODSPLUS.F_LevelID,
T_HEADSHIPTRAIT.F_NAME as "F_LevelName",
T_GOODSPLUS.F_HEADSHIPID,
T_HEADSHIP.F_NAME as F_HEADSHIPNAME,
T_GOODSPLUS.F_GOODSPLUSID,
T_goods1.F_NAME as F_GOODSPLUSNAME,
T_goods1.F_PRICE as F_GOODSPLUSPRICE,
T_GOODSPLUS.F_SHOPID
FROM T_GOODSPLUS
   inner JOIN T_GOODS ON (T_GOODSPLUS.F_GOODSID = T_GOODS.F_ID)
   inner Join T_HEADSHIP ON (T_GOODSPLUS.F_HEADSHIPID = T_HEADSHIP.F_ID)
   inner JOIN T_HEADSHIPTRAIT ON (T_GOODSPLUS.F_LEVELID = T_HEADSHIPTRAIT.F_ID)
   left JOIN T_GOODS as T_goods1 ON (T_GOODSPLUS.F_GOODSPLUSID = T_goods1.F_ID)

GO