| | |
| | | /** |
| | | * 获取AI检测页面 |
| | | */ |
| | | @ApiOperation(value = "获取AI检测页面",notes = "设备类型 deviceType: android ios") |
| | | @ApiOperation(value = "获取AI检测页面[1229]",notes = "设备类型 deviceType: android ios") |
| | | @GetMapping(value = "/getXiMaAiDetection") |
| | | public R<JSONObject> getXiMaAiDetection(@RequestParam String deviceType) { |
| | | String userId = tokenService.getLoginUserApplet().getUserId(); |
| | |
| | | @TableField("goods_source") |
| | | private Integer goodsSource; |
| | | |
| | | @ApiModelProperty(value = "封面") |
| | | @TableField("cover") |
| | | private String cover; |
| | | |
| | | @ApiModelProperty(value = "详情图") |
| | | @TableField("detail_pictures") |
| | | private String detailPictures; |
| | | |
| | | @ApiModelProperty(value = "商品名称") |
| | | @TableField("goods_name") |
| | | @Excel(name = "*商品名称") |
| | |
| | | @Excel(name = "*预警库存") |
| | | private Integer warningInventory; |
| | | |
| | | |
| | | @ApiModelProperty(value = "商品类型id") |
| | | @TableField("type_id") |
| | | private String typeId; |
| | |
| | | @TableField(exist = false) |
| | | private String packingUnitName; |
| | | |
| | | |
| | | @ApiModelProperty(value = "商品规格") |
| | | @TableField("goods_spec") |
| | | private String goodsSpec; |
| | | |
| | | |
| | | |
| | | @ApiModelProperty(value = "商品售价") |
| | | @TableField("sales_amount") |
| | |
| | | @ApiModelProperty(value = "包装单位,单位id") |
| | | @TableField("packing_unit_id") |
| | | private String packingUnitId; |
| | | |
| | | |
| | | |
| | | @ApiModelProperty(value = "使用说明") |
| | | @TableField("instructions_use") |
| | |
| | | @TableField("platform_commission_price") |
| | | private BigDecimal platformCommissionPrice; |
| | | |
| | | @ApiModelProperty(value = "建议零售价") |
| | | @TableField("retail_price") |
| | | private BigDecimal retailPrice; |
| | | |
| | | @ApiModelProperty(value = "1启用 2禁用") |
| | | private Integer state; |
| | | |
| | |
| | | @TableField("clinic_id") |
| | | private String clinicId; |
| | | |
| | | @ApiModelProperty(value = "已使用免费查看报告次数") |
| | | @TableField("use_ai_free_count") |
| | | private Integer useAiFreeCount; |
| | | |
| | | } |
| | |
| | | @TableField("expected_duration") |
| | | private Integer expectedDuration; |
| | | |
| | | @ApiModelProperty(value = "内容类型 1=直播 2=视频") |
| | | @TableField("content_type") |
| | | private Integer contentType; |
| | | |
| | | @ApiModelProperty(value = "直播方式 1=视频直播 2=语音直播") |
| | | @TableField("live_way") |
| | | private Integer liveWay; |
| | |
| | | @TableField("ai_price") |
| | | private BigDecimal aiPrice; |
| | | |
| | | @ApiModelProperty(value = "ai免费次数") |
| | | @TableField("ai_free_count") |
| | | private Integer aiFreeCount; |
| | | |
| | | @ApiModelProperty(value = "ai月卡费用") |
| | | @TableField("ai_month_price") |
| | | private BigDecimal aiMonthPrice; |
| | | |
| | | @ApiModelProperty(value = "ai计费说明") |
| | | @TableField("ai_instructions") |
| | | private String aiInstructions; |
| | | |
| | | @ApiModelProperty(value = "自动收货时间") |
| | | @TableField("delivery_time") |
| | | private Integer deliveryTime; |
| | |
| | | <id column="id" property="id"/> |
| | | <result column="supplier_clinic_id" property="supplierClinicId"/> |
| | | <result column="goods_source" property="goodsSource"/> |
| | | <result column="clinic_id" property="clinicId"/> |
| | | <result column="cover" property="cover"/> |
| | | <result column="detail_pictures" property="detailPictures"/> |
| | | <result column="goods_name" property="goodsName"/> |
| | | <result column="goods_id_code" property="goodsIdCode"/> |
| | | <result column="quasi_number" property="quasiNumber"/> |
| | |
| | | <result column="side_effect" property="sideEffect"/> |
| | | <result column="clinic_purchase_price" property="clinicPurchasePrice"/> |
| | | <result column="platform_commission_price" property="platformCommissionPrice"/> |
| | | <result column="retail_price" property="retailPrice"/> |
| | | <result column="create_time" property="createTime"/> |
| | | <result column="update_time" property="updateTime"/> |
| | | <result column="create_by" property="createBy"/> |
| | |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id |
| | | , supplier_clinic_id, goods_source, goods_name, goods_id_code, quasi_number, manufacturer, formulation_spec, packing_spec, type_id, goods_yards, maintenance_interval,maintenance_interval_unit, low_purchase_quantity, low_unit_id, is_prescription_drug, goods_spec, warning_inventory, sales_amount, packing_unit_id, instructions_use, side_effect, clinic_purchase_price, platform_commission_price, create_time, update_time, create_by,`state`, update_by, disabled, |
| | | simplified_code, |
| | | dosage_form, |
| | | usage_classification, |
| | | product_brand, |
| | | place_of_origin, |
| | | ingredient, |
| | | trait, |
| | | indication, |
| | | taboo, |
| | | precautions, |
| | | interaction, |
| | | storage,supplier_name |
| | | |
| | | id, supplier_clinic_id, goods_source, goods_name, goods_id_code, quasi_number, manufacturer, formulation_spec, |
| | | packing_spec, type_id, goods_yards, maintenance_interval,maintenance_interval_unit, low_purchase_quantity, |
| | | low_unit_id, is_prescription_drug, goods_spec, warning_inventory, sales_amount, packing_unit_id, instructions_use, |
| | | side_effect, clinic_purchase_price, platform_commission_price, create_time, update_time, create_by,`state`, |
| | | update_by, disabled,simplified_code,dosage_form,usage_classification,product_brand,place_of_origin,ingredient, |
| | | trait,indication,taboo,precautions,interaction,storage,supplier_name,cover,detail_pictures,retail_price |
| | | </sql> |
| | | |
| | | |
| | |
| | | t1.content_state, |
| | | t1.content_remark, |
| | | t1.state_remark, |
| | | t1.cover,t1.detail_pictures,t1.retail_price, |
| | | case t1.goods_source |
| | | when 1 then t2.supplier_name |
| | | when 2 then t1.supplier_name |
| | |
| | | t1.interaction, |
| | | t1.content,t1.content_state, |
| | | t1.storage,t1.state_remark, |
| | | t1.cover,t1.detail_pictures,t1.retail_price, |
| | | t2.supplier_name |
| | | from t_erp_goods t1 left join t_crm_supplier t2 on t1.supplier_clinic_id = t2.id and t1.goods_source =1 |
| | | where t1.disabled = 0 and t1.goods_source =1 |
| | |
| | | t1.create_time, |
| | | t1.update_time, |
| | | t1.create_id, |
| | | t3.type_name |
| | | t3.type_name, |
| | | t1.cover,t1.detail_pictures,t1.retail_price |
| | | FROM t_erp_goods t1 |
| | | LEFT JOIN t_crm_supplier t2 ON t1.supplier_clinic_id = t2.id |
| | | left join t_erp_goods_type t3 on t1.type_id = t3.id |
| | |
| | | <result column="status" property="status" /> |
| | | <result column="last_reminder_time" property="lastReminderTime" /> |
| | | <result column="clinic_id" property="clinicId" /> |
| | | <result column="use_ai_free_count" property="useAiFreeCount" /> |
| | | <result column="create_time" property="createTime" /> |
| | | <result column="update_time" property="updateTime" /> |
| | | <result column="create_by" property="createBy" /> |
| | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, nick_name,avatar, phone, birth_time, sex,user_height, user_weight, identifier_number, |
| | | open_id,chronic_disease_id,status,last_reminder_time, |
| | | open_id,chronic_disease_id,status,last_reminder_time,use_ai_free_count, |
| | | office_open_id,clinic_id, create_time, update_time, create_by, update_by, disabled |
| | | </sql> |
| | | <select id="pageList" resultType="com.ruoyi.system.vo.TSysAppUserVO"> |
| | | select tsau.id, tsau.nick_name,tsau.avatar, tsau.phone, tsau.birth_time, tsau.sex, tsau.user_height, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id,tsau.use_ai_free_count, |
| | | tsau.chronic_disease_id,tsau.status,tsau.last_reminder_time,tsau.clinic_id, tsau.create_time, |
| | | tsau.update_time, tsau.create_by,tsau.update_by, tsau.disabled, tsi.lastInspectionTime |
| | | from t_sys_app_user tsau |
| | |
| | | </select> |
| | | <select id="pageChronicDiseaseUserList" resultType="com.ruoyi.system.vo.TSysAppUserVO"> |
| | | select tsau.id, tsau.nick_name,tsau.avatar, tsau.phone, tsau.birth_time, tsau.sex, tsau.user_height, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id,tsau.use_ai_free_count, |
| | | tsau.chronic_disease_id,tsau.status,tsau.last_reminder_time,tsau.clinic_id, tsau.create_time, |
| | | tsau.update_time, tsau.create_by,tsau.update_by, tsau.disabled |
| | | from t_sys_app_user tsau |
| | |
| | | </select> |
| | | <select id="exportList" resultType="com.ruoyi.system.export.TSysAppUserListExport"> |
| | | select tsau.id, tsau.nick_name,tsau.avatar, tsau.phone, tsau.birth_time, tsau.sex, tsau.user_height, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id,tsau.use_ai_free_count, |
| | | tsau.chronic_disease_id,tsau.status,tsau.last_reminder_time,tsau.clinic_id, tsau.create_time, |
| | | tsau.update_time, tsau.create_by,tsau.update_by, tsau.disabled |
| | | from t_sys_app_user tsau |
| | |
| | | </select> |
| | | <select id="exportListClinic" resultType="com.ruoyi.system.export.TSysAppUserClinicExport"> |
| | | select tsau.id, tsau.nick_name,tsau.avatar, tsau.phone, tsau.birth_time, tsau.sex, tsau.user_height, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id,tsau.use_ai_free_count, |
| | | tsau.chronic_disease_id,tsau.status,tsau.last_reminder_time,tsau.clinic_id, tsau.create_time, |
| | | tsau.update_time, tsau.create_by,tsau.update_by, tsau.disabled |
| | | from t_sys_app_user tsau |
| | |
| | | </select> |
| | | <select id="exportListAppUser" resultType="com.ruoyi.system.export.TSysAppUserExport"> |
| | | select tsau.id, tsau.nick_name,tsau.avatar, tsau.phone, tsau.birth_time, tsau.sex, tsau.user_height, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id, |
| | | tsau.user_weight, tsau.identifier_number,tsau.open_id,tsau.office_open_id,tsau.use_ai_free_count, |
| | | tsau.chronic_disease_id,tsau.status,tsau.last_reminder_time,tsau.clinic_id, tsau.create_time, |
| | | tsau.update_time, tsau.create_by,tsau.update_by, tsau.disabled, tsi.lastInspectionTime |
| | | from t_sys_app_user tsau |
| | |
| | | <result column="start_time" property="startTime" /> |
| | | <result column="end_time" property="endTime" /> |
| | | <result column="expected_duration" property="expectedDuration" /> |
| | | <result column="content_type" property="contentType" /> |
| | | <result column="live_way" property="liveWay" /> |
| | | <result column="live_mode" property="liveMode" /> |
| | | <result column="live_lecturer" property="liveLecturer" /> |
| | |
| | | <sql id="Base_Column_List"> |
| | | id, live_title, live_cover, live_introduction, start_time,end_time, expected_duration, live_way, live_mode,live_url, |
| | | live_lecturer, live_type, live_detail, push_type,click_count, create_time, update_time, create_by, update_by, disabled, |
| | | gosling_live_id,resource_password |
| | | gosling_live_id,resource_password,content_type |
| | | </sql> |
| | | <select id="pageList" resultType="com.ruoyi.system.vo.TSysLiveVO"> |
| | | SELECT |
| | |
| | | <result column="expire_unit" property="expireUnit" /> |
| | | <result column="msg_count" property="msgCount" /> |
| | | <result column="ai_price" property="aiPrice" /> |
| | | <result column="ai_free_count" property="aiFreeCount" /> |
| | | <result column="ai_month_price" property="aiMonthPrice" /> |
| | | <result column="ai_instructions" property="aiInstructions" /> |
| | | <result column="delivery_time" property="deliveryTime" /> |
| | | <result column="verify_value" property="verifyValue" /> |
| | | <result column="verify_unit" property="verifyUnit" /> |
| | |
| | | <result column="create_by" property="createBy" /> |
| | | <result column="update_by" property="updateBy" /> |
| | | <result column="disabled" property="disabled" /> |
| | | <result column="create_id" property="createId" /> |
| | | </resultMap> |
| | | |
| | | <!-- 通用查询结果列 --> |
| | | <sql id="Base_Column_List"> |
| | | id, procurement_conditions, points_expiration, expire_unit, msg_count, ai_price, delivery_time, |
| | | verify_value, verify_unit,create_time, update_time, create_by, update_by, disabled, create_id |
| | | verify_value, verify_unit,create_time, update_time, create_by, update_by, disabled,ai_free_count, |
| | | ai_month_price, ai_instructions |
| | | </sql> |
| | | |
| | | </mapper> |