/**
* 查询证件主表的审核状态
*
* @param conn
* @param tmid
* @param status
* @param content
* @param sro
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> querydateMa1(Connection conn, Long tmid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(
" select tm.auditStatus as auditStatus from t_materialsauth tm where tm.id = " + tmid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 查询用户名称
*
* @param conn
* @param tmdid
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queryuser(Connection conn, Long id)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tuser.username as username ");
sql.append(" from t_user tuser ");
sql.append(" where tuser.id = " + id);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/** 查询materaldetal的id */
public Map<String, String> querytmid(Connection conn, Long typeid, Long userId)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tm.id as id ");
sql.append(" from t_materialsauth tm ");
sql.append(" where tm.userId = " + userId);
sql.append(" and tm.materAuthTypeId = " + typeid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 查询充值详细表by id
*
* @return
* @throws DataException
* @throws SQLException
*/
public Map<String, String> queryupdateRechargeDetailById(Connection conn, long id)
throws SQLException, DataException {
DataSet dataSet =
MySQL.executeQuery(
conn,
" select a.award as award,a.userId as userId,a.id as id,a.rechargeMoney as rechargeMoney,a.result as result,a.rechargeNumber as rechargeNumber,a.rechargeTime as rechargeTime,"
+ " a.rechargeType as rechargeType,a.remark as remark,b.username as username, c.cellPhone as mobilePhone,c.realName as realName,c.idNo as idNo"
+ " from t_recharge_detail a left join t_user b on a.userId = b.id left join t_person c on a.userId = c.userId where a.id = "
+ id
+ " and a.rechargeType = 4 ");
return DataSetHelper.dataSetToMap(dataSet);
}
/**
* 查询图片信息和审核情况
*
* @param conn
* @param tmdid
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queryonemsg(Connection conn, Long tmdid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tmd.`option` as tmdoption, ");
sql.append(" tmd.auditStatus as auditStatus, ");
sql.append(" tmd.imagePath as imagePath,");
sql.append(" tmd.visiable as visiable ");
sql.append(" from t_materialimagedetal tmd where tmd.id = " + tmdid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 资料认证统计图片类表
*
* @param conn
* @param typeid
* @param userId
* @return
* @throws SQLException
* @throws DataException
*/
public List<Map<String, Object>> queryCountPictureList(Connection conn, Long tmid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tmd.id as tmdid, ");
sql.append(" tmd.imagePath as imagePath ");
sql.append(" from t_materialimagedetal tmd ");
sql.append(" WHERE tmd.materialsauthid = " + tmid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
dataSet.tables.get(0).rows.genRowsMap();
sql = null;
return dataSet.tables.get(0).rows.rowsMap;
}
/**
* 查询视频资料审核明细表中
*
* @param tmid 资料主表id
* @return
* @throws DataException
* @throws SQLException
*/
public Map<String, String> queryMade(Connection conn, Long tmid)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tmd.id as tmdid ");
sql.append(" from ");
sql.append(" t_materialimagedetal tmd ");
sql.append(" where tmd.materialsauthid = " + tmid);
sql.append(" LIMIT 0 , 1 ");
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
dataSet.tables.get(0).rows.genRowsMap();
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}
/**
* 资料认证统计查询
*
* @param conn
* @param typeid 类型种类
* @param userId 用户id
* @return
* @throws SQLException
* @throws DataException
*/
public Map<String, String> queryCountMsg(Connection conn, Long typeid, Long userId)
throws SQLException, DataException {
StringBuffer sql = new StringBuffer();
sql.append(" select ");
sql.append(" tuser.id as id, ");
sql.append(" tuser.username as username, ");
sql.append(" ty.`name` as tyname, ");
sql.append(" tm.`option` as tmoption ");
sql.append(" from t_user tuser ");
sql.append(" left join t_materialsauth tm on tm.userId = tuser.id ");
sql.append(" left join t_materialsauthtype ty on tm.materAuthTypeId = ty.id ");
sql.append(" where tuser.id = " + userId);
sql.append(" and tm.materAuthTypeId = " + typeid);
DataSet dataSet = MySQL.executeQuery(conn, sql.toString());
sql = null;
return BeanMapUtils.dataSetToMap(dataSet);
}