alter table textbook_subscription_item
    add source_price decimal(15, 6) null comment '定价(元)' after discount;

alter table textbook_discount_alter_record
    add old_price decimal(15, 6) null comment '旧的价格' after textbook_warehouse_record_id;

alter table textbook_discount_alter_record
    add new_price decimal(15, 6) null comment '新的价格' after old_price;

alter table textbook_student_claim
    add textbook_warehouse_record_id bigint null comment '关联入库主键' after textbook_id;

INSERT INTO `tl`.`magic_api_file` (`file_path`, `file_content`)
VALUES ('/magic-api/api/教务/可以退书的入库记录.ms',
        '{\n  \"properties\" : { },\n  \"id\" : \"copy1740020189208d10722\",\n  \"script\" : null,\n  \"groupId\" : \"b28ab2a82c5d460f95b60a0c70ac1d15\",\n  \"name\" : \"可以退书的入库记录\",\n  \"createTime\" : null,\n  \"updateTime\" : 1740644714570,\n  \"lock\" : null,\n  \"createBy\" : null,\n  \"updateBy\" : null,\n  \"path\" : \"can-recede-warehouse-record\",\n  \"method\" : \"GET\",\n  \"parameters\" : [ {\n    \"name\" : \"baseSemesterId\",\n    \"value\" : null,\n    \"description\" : null,\n    \"required\" : false,\n    \"dataType\" : \"String\",\n    \"type\" : null,\n    \"defaultValue\" : null,\n    \"validateType\" : null,\n    \"error\" : null,\n    \"expression\" : null,\n    \"children\" : null\n  } ],\n  \"options\" : [ ],\n  \"requestBody\" : \"\",\n  \"headers\" : [ ],\n  \"paths\" : [ ],\n  \"responseBody\" : \"{\\n    \\\"code\\\": 0,\\n    \\\"msg\\\": \\\"success\\\",\\n    \\\"data\\\": [],\\n    \\\"timestamp\\\": \\\"1740644443211\\\",\\n    \\\"requestTime\\\": \\\"1740644443201\\\",\\n    \\\"executeTime\\\": \\\"10\\\"\\n}\",\n  \"description\" : null,\n  \"requestBodyDefinition\" : null,\n  \"responseBodyDefinition\" : null\n}\r\n================================\r\nreturn db.select(\"\"\"\r\nSELECT t.id,t.textbook_id,tt.book_name,t.order_number,t.remain_number from textbook_warehouse_record t\r\nleft join textbook tt on t.textbook_id = tt.id\r\nwhere t.delete_mark = 0\r\nand t.remain_number > 0\r\nand t.base_semester_id = #{baseSemesterId}\r\norder by t.create_date desc\r\n\"\"\");');


