lyfz_repos/经典版源码/document/数据库表脚本/alarmview.sql

USE [db]
GO
/****** 对象:  View [dbo].[alarmview]    脚本日期: 06/13/2014 10:27:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[alarmview] AS SELECT     
dbo.dindan.id,			/* 订单号 */
dbo.dindan.name1,		/* 男宾 */
dbo.dindan.name2,		/* 女宾 */
dbo.dindan.ren,			/* 开单人 */
dbo.dindan.time1,		/* 预约时间 */
dbo.dindan.status,		/* 拍照状态 */
dbo.dindan.time2,		/* 拍照时间 */
dbo.dindan.status2,		/* 选片状态 */
dbo.dindan.time4,		/* 选片时间 */
dbo.dindan.status8,		/* 看设计状态 */
dbo.dindan.phone1,
dbo.dindan.phone2,
dbo.dindan.pinyin1,
dbo.dindan.pinyin2,

/* 商品类型!=2、已入册、已入底、未完成的订单号商品数量 */
(SELECT count(*) FROM  dbo.dindansp WHERE (kind<>'2' and name<>'入册' and name<>'入底' and status1 = '未完成') AND (id = dbo.dindan.id))AS cot1,

/* 商品类型!=2、已入册、已入底、未取的订单号商品数量 */
(SELECT count(*) FROM  dbo.dindansp WHERE (kind<>'2' and name<>'入册' and name<>'入底' and status2 = '未取') AND (id = dbo.dindan.id)) AS cot2 
FROM  
dbo.dindan