a.id AS "id",
a.name AS "name",
a.short_name AS "shortName",
a.price AS "price",
a.dept AS "dept",
a.dept AS "office.id",
o.name AS "office.name",
a.is_share AS "isShare",
a.share_section AS "shareSection",
a.sort AS "sort",
a.visibility AS "visibility",
a.type AS "type",
a.jump_url AS "jumpUrl",
a.show_url AS "showUrl",
a.business_table AS "businessTable",
a.create_date AS "createDate",
a.create_by AS "createBy.id",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.del_flag AS "delFlag"
LEFT JOIN jeesite_sys_office o ON o.id = a.dept
INSERT INTO payment_charging_item(
id,
name,
is_share,
share_section,
price,
dept,
sort,
visibility,
business_table,
create_date,
create_by,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{name},
#{isShare},
#{shareSection},
#{price},
#{office.id},
#{sort},
#{visibility},
#{businessTable},
#{createDate},
#{createBy.id},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE payment_charging_item SET
name = #{name},
is_share = #{isShare},
share_section = #{shareSection},
price = #{price},
dept = #{office.id},
sort = #{sort},
visibility = #{visibility},
business_table = #{businessTable},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE payment_charging_item SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}