models.py 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292
  1. from tortoise import fields
  2. from tortoise.models import Model
  3. from pydantic import BaseModel
  4. from datetime import datetime
  5. from tortoise import fields
  6. from tortoise.models import Model
  7. from pydantic import BaseModel
  8. from datetime import datetime
  9. class User(Model):
  10. id = fields.IntField(pk=True)
  11. username = fields.CharField(max_length=30, unique=True, description="帳號")
  12. password = fields.CharField(max_length=128, description="密碼")
  13. email = fields.CharField(max_length=128, description="信箱")
  14. points = fields.IntField(description="點數")
  15. is_superuser = fields.IntField(description="超級使用者")
  16. token = fields.CharField(max_length=200)
  17. # position = fields.CharField(max_length=200,description="登入身分")
  18. is_active = fields.IntField(description="是否已認證")
  19. class UserPydantic(BaseModel):
  20. id: int
  21. username: str
  22. password: str
  23. email: str
  24. points: int
  25. is_superuser: int
  26. token: str
  27. # position : str
  28. is_active: int
  29. class Config:
  30. orm_mode = True
  31. #學校
  32. class Schools(Model):
  33. id = fields.IntField(pk=True)
  34. name = fields.CharField(max_length=45, description="學校名稱")
  35. longitude = fields.CharField(max_length=100, description="經度")
  36. latitude = fields.CharField(max_length=100, description="緯度")
  37. address = fields.CharField(max_length=128,description="地址")
  38. update_time = fields.DatetimeField(description="更新時間")
  39. introduction = fields.TextField(description="簡介", null=True)
  40. email = fields.TextField(description="email", null=True)
  41. phone = fields.TextField(description="電話", null=True)
  42. def show_data(self):
  43. return {
  44. "location_id": self.id,
  45. "location_name": self.name,
  46. "Lng": self.longitude,
  47. "Lat": self.latitude,
  48. "address": self.address,
  49. "update_time":self.update_time,
  50. "introduction":self.introduction,
  51. "email":self.email,
  52. "phone":self.phone
  53. }
  54. class Group_name(Model):
  55. id = fields.IntField(pk=True)
  56. group_name = fields.CharField(max_length=45, description="學群名稱")
  57. class Class_name(Model):
  58. id = fields.IntField(pk=True)
  59. name = fields.CharField(max_length=45, description="課程名稱")
  60. school_id = fields.IntField(description="學校ID")
  61. category = fields.CharField(max_length=45, description="分類")
  62. introduction = fields.TextField(description="簡介", null=True)
  63. organizer = fields.CharField(max_length=45, description="主辦單位", null=True)
  64. cover_img = fields.CharField(max_length=255, description="封面圖片", null=True)
  65. group_id = fields.IntField(description="學群")
  66. group_sort = fields.CharField(max_length=45, description="學群細分")
  67. special_class_list_name = fields.CharField(max_length=45, description="特殊表格", null=True)
  68. recommend = fields.IntField(description="是否在首頁")
  69. is_inner = fields.IntField(description="是否是內課")
  70. is_check = fields.IntField(description="是否確認")
  71. def show_data(self):
  72. return {
  73. "class_name_id": self.id,
  74. "name": self.name,
  75. "category": self.category,
  76. "introduction": self.introduction,
  77. "organizer": self.organizer,
  78. "group_id": self.group_id,
  79. "cover_img": self.cover_img,
  80. "group_sort":self.group_sort,
  81. "recommend" : self.recommend,
  82. "is_inner" : self.is_inner,
  83. "is_check" :self.is_check,
  84. "special_class_list_name":self.special_class_list_name
  85. }
  86. class Class_list(Model):
  87. id = fields.IntField(pk=True)
  88. name_id = fields.IntField(description="課程名稱ID")
  89. event = fields.CharField(max_length=45, description="場次", null=True)
  90. start_time = fields.DatetimeField(description="開始時間", null=True)
  91. end_time = fields.DatetimeField(description="結束時間", null=True)
  92. contact = fields.CharField(max_length=255, description="聯絡方式", null=True)
  93. lecturer = fields.CharField(max_length=255, description="講師", null=True)
  94. location = fields.CharField(max_length=255, description="地點詳情", null=True)
  95. content = fields.TextField(description="內容", null=True)
  96. URL = fields.TextField(description="連結網址", null=True)
  97. people = fields.CharField(max_length=255, description="對象", null=True)
  98. fee_method = fields.CharField(max_length=255, description="收費方式", null=True)
  99. registration_way = fields.CharField(max_length=255, description="報名方式", null=True)
  100. remark = fields.TextField(description="備註", null=True)
  101. ATM_address = fields.TextField(description="匯款帳號", null=True)
  102. def show_data(self):
  103. return {
  104. "event_id": self.id,
  105. "name_id": self.name_id,
  106. "event": self.event,
  107. "start_time": self.start_time,
  108. "end_time": self.end_time,
  109. "location": self.location,
  110. "lecturer": self.lecturer,
  111. "contact": self.contact,
  112. "content": self.content,
  113. "URL": self.URL,
  114. "people": self.people,
  115. "fee_method": self.fee_method,
  116. "registration_way": self.registration_way,
  117. "remark": self.remark,
  118. "ATM_address":self.ATM_address
  119. }
  120. class Class_detail(Model):
  121. id = fields.IntField(pk=True)
  122. class_list_id = fields.IntField(description="課程場次ID")
  123. start_time = fields.DatetimeField(description="開始時間")
  124. end_time = fields.DatetimeField(description="結束時間")
  125. sessions = fields.IntField(description="堂數")
  126. content = fields.TextField(description="內容", null=True)
  127. class Registration(Model):
  128. id = fields.IntField(pk=True)
  129. event_id = fields.IntField(description="課程ID")
  130. user_id = fields.IntField(description="使用者ID")
  131. reg_confirm = fields.IntField(description="報名確認(1:報名成功 0:單純報名)")
  132. is_del = fields.IntField(description="是否取消(1:yes ,0:no)")
  133. create_time = fields.DatetimeField(description="創建時間")
  134. class News(Model):
  135. id = fields.IntField(pk=True)
  136. title = fields.CharField(max_length=200, description="標題")
  137. category = fields.CharField(max_length=45, description="類別", null=True)
  138. create_time = fields.DatetimeField(description="發布時間")
  139. click_time = fields.IntField(description="點擊次數", null=True)
  140. content = fields.TextField(description="內容", null=True)
  141. files = fields.TextField(description="附加檔案", null=True)
  142. URL = fields.TextField(description="外部連結", null=True)
  143. tags = fields.TextField(description="標籤", null=True)
  144. cover_img = fields.CharField(max_length=255, description="封面圖片", null=True)
  145. class Favorite_course(Model):
  146. id = fields.IntField(pk=True)
  147. user_id = fields.IntField(description="使用者ID")
  148. class_name_id = fields.IntField(description="課程ID")
  149. time_stemp = fields.DatetimeField(description="時間")
  150. class Article_list(Model):
  151. id = fields.IntField(pk=True)
  152. title = fields.CharField(max_length=45, description="標題")
  153. school_id = fields.IntField(description="學校ID", null=True)
  154. group_id = fields.IntField(description="學群", null=True)
  155. group_sort = fields.CharField(max_length=45, description="學群細分", null=True)
  156. create_user_id = fields.IntField(description="創建使用者ID", null=True)
  157. create_time = fields.DatetimeField(description="創建時間", null=True)
  158. latest_update_user_id = fields.IntField(description="最新更新使用者ID", null=True)
  159. latest_update_time = fields.DatetimeField(description="最新更新時間", null=True)
  160. tags = fields.TextField(description="標籤", null=True)
  161. category = fields.CharField(max_length=45, description="類別", null=True)
  162. depiction = fields.TextField(description="文章描述", null=True)
  163. cover_img = fields.TextField( description="封面圖片", null=True)
  164. vedio_url = fields.TextField( description="影片連結", null=True)
  165. click_time = fields.IntField(description="點擊次數", null=True)
  166. content = fields.TextField(description="內容", null=True)
  167. is_del = fields.IntField(description="是否刪除")
  168. files = fields.TextField(description="附件", null=True)
  169. url = fields.TextField(description="文章連結", null=True)
  170. recommend = fields.IntField(description="是否在首頁")
  171. class Online_course(Model):
  172. id = fields.IntField(pk=True)
  173. title = fields.CharField(max_length=45, description="標題")
  174. category = fields.CharField(max_length=45, description="類別", null=True)
  175. create_time = fields.DatetimeField(description="發布時間")
  176. click_time = fields.IntField(description="點擊次數", null=True)
  177. content = fields.TextField(description="發布時間", null=True)
  178. video_url = fields.TextField(description="影片連結")
  179. group_id = fields.IntField(description="學群", null=True)
  180. class Guidance_group(Model):
  181. id = fields.IntField(pk=True)
  182. name = fields.CharField(max_length=125, description="協會(團體)名稱")
  183. contact_person = fields.CharField(max_length=125, description="聯絡人")
  184. contact_phone = fields.CharField(max_length=125, description="聯絡電話")
  185. line = fields.IntField(description="LINE (0:沒有、1:有)")
  186. address = fields.TextField(description="地址")
  187. email = fields.CharField(max_length=125, description="信箱")
  188. information = fields.TextField(description="開課資訊")
  189. request = fields.TextField(description="需求")
  190. schedule = fields.CharField(max_length=45, description="處理進度")
  191. result = fields.CharField(max_length=125, description="處理結果")
  192. person = fields.CharField(max_length=45, description="輔導人員")
  193. remark = fields.TextField(description="備註")
  194. class User_information(Model):
  195. id = fields.IntField(pk=True)
  196. user_id = fields.IntField(description="使用者ID")
  197. name = fields.CharField(max_length=45, description="姓名")
  198. birthday = fields.DateField(description="生日")
  199. gender = fields.CharField(max_length=45, description="性別")
  200. phone = fields.CharField(max_length=45, description="電話")
  201. address = fields.TextField(description="地址")
  202. is_default = fields.IntField(description="是否為預設")
  203. class Class_date(Model):
  204. id = fields.IntField(pk=True)
  205. class_list_id = fields.IntField(description="場次ID")
  206. registration_start = fields.DatetimeField(description="報名時間開始", null=True)
  207. registration_end = fields.DatetimeField(description="報名時間結束", null=True)
  208. number_limit = fields.IntField(description="名額", null=True)
  209. amount_left = fields.IntField(description="剩餘名額", null=True)
  210. class Attend_record(Model):
  211. id = fields.IntField(pk=True)
  212. class_detail_id = fields.IntField(description="課堂ID")
  213. user_id = fields.IntField(description="使用者ID")
  214. is_attend = fields.IntField(description="是否已出席(1:是、0:否)")
  215. class One_day_class(Model):
  216. id = fields.IntField(pk=True)
  217. name_id = fields.IntField(description="課程名稱")
  218. teacher = fields.CharField(max_length=100, description="老師", null=True)
  219. contact = fields.CharField(max_length=100, description="聯絡方式", null=True)
  220. start_time = fields.DatetimeField(description="開始時間", null=True)
  221. end_time = fields.DatetimeField(description="結束時間", null=True)
  222. reg_deadline = fields.DatetimeField(description="報名結束時間", null=True)
  223. remark = fields.TextField(description="備註", null=True)
  224. people = fields.CharField(max_length=255, description="對象", null=True)
  225. way = fields.CharField(max_length=45, description="上課方式", null=True)
  226. fee_method = fields.TextField(description="收費方式", null=True)
  227. material = fields.TextField(description="材料", null=True)
  228. tools = fields.TextField(description="材料", null=True)
  229. number_limit = fields.TextField(description="人數限制", null=True)
  230. def show_data(self):
  231. return {
  232. "id" : self.id,
  233. "name_id": self.name_id,
  234. "teacher": self.teacher,
  235. "contact": self.contact,
  236. "start_time": self.start_time,
  237. "end_time": self.end_time,
  238. "reg_deadline": self.reg_deadline,
  239. "remark": self.remark,
  240. "people": self.people,
  241. "way": self.way,
  242. "material": self.material,
  243. "tools": self.tools,
  244. "number_limit": self.number_limit
  245. }
  246. class User_resume(Model):
  247. id = fields.IntField(pk=True)
  248. user_id = fields.IntField(description="使用者編號")
  249. teacher_name = fields.CharField(max_length=45,description="老師名字")
  250. work_type = fields.CharField(max_length=45, description="工作性質", null=True)
  251. experience = fields.CharField(max_length=100, description="教學經驗", null=True)
  252. expertise = fields.TextField(description="專業工藝技能", null=True)
  253. license = fields.TextField(description="相關證照", null=True)
  254. media = fields.TextField(description="社群媒體", null=True)
  255. imgs = fields.TextField(description="作品集", null=True)
  256. introduction = fields.TextField(description="自我介紹", null=True)
  257. def show_data(self):
  258. return {
  259. "id" : self.id,
  260. "user_id": self.user_id,
  261. "teacher_name": self.teacher_name,
  262. "work_type": self.work_type,
  263. "experience": self.experience,
  264. "expertise": self.expertise,
  265. "license": self.license,
  266. "media": self.media,
  267. "imgs": self.imgs,
  268. "introduction": self.introduction
  269. }