JN项目-app首页订票功能实现

为了得到optid，需要修改视图v_culture_hd

DELIMITER $$

USE `jnwhfwpt`$$

DROP VIEW IF EXISTS `v_culture_hd`$$

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `jnwhfwpt`.`v_culture_hd` AS 
SELECT CONCAT('gzl@',`jnwhfwpt`.`m_cultureact_gzl`.`msgCode`) AS `msgCode`,
`jnwhfwpt`.`m_cultureact_gzl`.`sender` AS `sender`,
`jnwhfwpt`.`m_cultureact_gzl`.`sendeDate` AS `sendeDate`,
`jnwhfwpt`.`m_cultureact_gzl`.`msgTitle` AS `msgTitle`,
`jnwhfwpt`.`m_cultureact_gzl`.`msgType` AS `msgType`,
`jnwhfwpt`.`m_cultureact_gzl`.`msgContent` AS `msgContent`,
`jnwhfwpt`.`m_cultureact_gzl`.`shCode` AS `shCode`,
`jnwhfwpt`.`m_cultureact_gzl`.`shDate` AS `shDate`,
`jnwhfwpt`.`m_cultureact_gzl`.`shState` AS `shState`,
`jnwhfwpt`.`m_cultureact_gzl`.`shContent` AS `shContent`,
`jnwhfwpt`.`m_cultureact_gzl`.`unitcode` AS `unitcode`,
`jnwhfwpt`.`m_cultureact_gzl`.`showstate` AS `showstate`,
`jnwhfwpt`.`m_cultureact_gzl`.`content_note` AS `content_note`,
`jnwhfwpt`.`m_cultureact_gzl`.`img` AS `img`,
`jnwhfwpt`.`m_cultureact_gzl`.`imgtype` AS `imgtype`,
`jnwhfwpt`.`m_cultureact_gzl`.`imgfilename` AS `imgfilename`,
'观展览' AS `lmname` ,
'WHHDGLGZL' AS `optid` 
FROM `jnwhfwpt`.`m_cultureact_gzl` 
UNION ALL 
SELECT CONCAT('kyc@',`jnwhfwpt`.`m_cultureact_kyc`.`msgCode`) AS `msgCode`,
`jnwhfwpt`.`m_cultureact_kyc`.`sender` AS `sender`,
`jnwhfwpt`.`m_cultureact_kyc`.`sendeDate` AS `sendeDate`,
`jnwhfwpt`.`m_cultureact_kyc`.`msgTitle` AS `msgTitle`,
`jnwhfwpt`.`m_cultureact_kyc`.`msgType` AS `msgType`,
`jnwhfwpt`.`m_cultureact_kyc`.`msgContent` AS `msgContent`,
`jnwhfwpt`.`m_cultureact_kyc`.`shCode` AS `shCode`,
`jnwhfwpt`.`m_cultureact_kyc`.`shDate` AS `shDate`,
`jnwhfwpt`.`m_cultureact_kyc`.`shState` AS `shState`,
`jnwhfwpt`.`m_cultureact_kyc`.`shContent` AS `shContent`,
`jnwhfwpt`.`m_cultureact_kyc`.`unitcode` AS `unitcode`,
`jnwhfwpt`.`m_cultureact_kyc`.`showstate` AS `showstate`,
`jnwhfwpt`.`m_cultureact_kyc`.`content_note` AS `content_note`,
`jnwhfwpt`.`m_cultureact_kyc`.`img` AS `img`,
`jnwhfwpt`.`m_cultureact_kyc`.`imgtype` AS `imgtype`,
`jnwhfwpt`.`m_cultureact_kyc`.`imgfilename` AS `imgfilename`,
'看演出' AS `lmname` ,
'WHHDGLKYC' AS `optid` 
FROM `jnwhfwpt`.`m_cultureact_kyc`
$$

DELIMITER ;

页面要显示三种状态：订票（灰色的，不可点击），订票（可以点击进行订票），已订（点击查看订票详情）