models.py 16 KB

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