Skip to content

Magazine

Jump to bottom
kalyankk edited this page Feb 27, 2020 · 23 revisions

Magazine Table / Collection

magazineId magazineCode createdBy createdOn name displayName city state country coverpicUrl logoPicUrl socialLinks contactDetails isProgramMagz isBizMagz isPremiumMagz status smartSystem editions
1 cmrec stumagzsu 2019-12-25 12:10:22 CMREC CMR Engg College Hyderabad Telangana India https://s3.st.ap.stcontent.com/images/fruhuisf3j98rjd.jpg https://s3.st.ap.stcotnent.com/images/dfuiwefr83f8ecd.jpg {...}1 {...}2 False False True Premium Off {...}3
2 cmrtc someuser 2019-11-20 18:23:20 CMRTC CMR Engg College Tech Campus Hyderabad Telangana India https://s3.st.ap.stcoennt.com/images/fj38fn3.jpg https://s3.ap.stcontent.com/images/3r839fne.jpg {...}1 {...}2 True False True Verified On {...}3
3 vbit stumagzsu 2019-11-22 14:45:02 VBIT Ghakesar VBIT Ghatkesar Ghatkesar Bhongir India NULL NULL {...}1 {...}2 False False False UnVerified On {...}3
4 aurora otheruser 2019-12-24 16:44:32 AURORA AURORA Engg College Hyderabad Telangana India NULL NULL {...}1 {...}2 True True True Verified Off {...}3

1 { "Facebook" : "https://www.facebook.com/cmrec", "Google" : "", "LinkedIn" : "https://in.linkedin.com/cmrec", "Twitter" : "https://twitter.com/@cmrec", "YouTube" : "https://youtube.com/user/cmrec" }

2 { "Email" : "[email protected]", "Phone" : "040 73458 38425", "Address":"", "Geo Location": { "locality" : "Hyderabad", "Country" : "IN", "PostalCode" : "500032", "Latitude" : "17.834723", "Longitude" : "80.837346" } }

3 { "Editions" : "Manual Release", "ReleaseInterval" : "FortNite", "MinimumPostsPerRelease" : "10" }

3 Editions can be Disabled / Manual Release / Automatic Release.

3 ReleaseInterval can be Weekly / BiMonthly / Monthly.

ProgramMagazines_Colleges Requests Table / Collection

programMagzId programMagzCode magazineId magazineCode requestedAt requestedBy
24 jhub 26 aurora 2020-01-15 10:15:54 Principal
24 jhub 52 cmrtc 2020-01-15 15:29:54 Director

ProgramMagazines_Colleges Table / Collection

programMagzId programMagzCode magazineId magazineCode addedAt
24 jhub 26 aurora 2020-01-15 10:15:54
24 jhub 52 cmrtc 2020-01-15 15:29:54

MagazineAdmins Table / Collection

userId userName magazineId magazineCode adminRole addedAsAdminAt adminPrivilege1 adminPrivilege2 adminPrivilege3
2 someusername 4 aurora TPO 2020-01-15 10:15:54 True False True
4 somestudent 2 cmrtc Principal 2020-01-15 15:29:54 False True True

Magazine_Post-Requests Table / Collection

requestId postId magazineId requestedAn status allocatedEdition
1 243 4 2020-01-15 10:15:54 Pending NULL
2 534 2 2020-01-15 15:29:54 Approved 3

Magazine Edition Table / Collection

id magazineId editionName status releasedOn posts
1 2 Issue 11 Released 2020-01-21 10:00:00 {...}a
2 3 Issue 12 Released 2020-02-01 10:00:00 {...}a
3 2 Issue 12 Released 2020-01-03 10:00:00 {...}a
4 3 New Year Spl Issue 2020 Upcoming NULL {...}a

a Will be updated soon

Magazine followers collection

id magazineId magazineCode userId userName followingFrom
1 14 nmrec 483 someuser 2020-01-21 10:00:00
2 28 stpious 234 stumagzsu 2020-02-01 10:00:00
3 22 vbit 234 stumagzsu 2020-02-01 10:00:00

Magazine members collection

id magazineId magazineCode userId userName lastUpdatedOn membershipDetails
1 22 vbit 483 someuser 2020-01-21 10:00:00 {...}a
2 24 cmrec 354 spluser 2020-02-01 10:00:00 {...}a
3 24 cmrec 355 ssuser 2020-02-01 10:00:00 {...}a

a User can be a student / faculty / alumini or any two or all the three

a { "student":{"id":1234, "academic_start_year":2014, "academic_end_year":2018, "course":"BTech CSE"}, "alimni":{"id":38724, "academic_start_year":2014, "academic_end_year":2018}, "faculty":{"id":8458, "joining_date":"2020-08-12", "designation":"Asst Professor", "department":"CSE"}}

MagazineReviews Table / Collection

userId userName magazineId magazineCode reviewText rating reviewedAt
2 someusername 4 aurora Bokka lo review, raste enta, rayakapote enta 2 2020-01-15 10:15:54
4 somestudent 2 cmrtc Good college with good locality 5 2020-01-15 15:29:54

MagazineGallery Table / Collection

magazineId magazineCode imageUrl uploadedBy uploadedAt
4 aurora https://st.ap.s3bucketurl.com/images/jdf8ef83r.jpg someuser 2020-01-15 10:15:54
2 cmrtc https://st.ap.s3bucketurl.com/images/dfjeufenwu.jpg someotheruser 2020-01-15 15:29:54

Magazine Creation

  • Magazine Name
  • Display Name
  • Sub Domain
  • City Name
  • District
  • State
  • Country
  • Is program magazine (yes or no)
  • Is Biz magazine (yes or no)

About Magazine

  • Cover pic image url
  • Logo pic image url
  • Description / About
  • Releasing Modes (Editions)
  • Contact Details
    • Email
    • Phone
    • Address
    • Geo Location
  • Courses - Pull data from IC-LMS via API
  • Departments - Pull data from IC-LMS via API
  • Top faculty - Pull data from IC-LMS via API
  • Social Links
    • Facebook
    • Twitter
    • Linked in
    • Google plus (discontinued by google, better to remove)
  • Secondary magz admins
  • Reviews
  • Gallery

Admin settings

  • Student Questionnaire
  • Alumni Questionnaire
  • Event Questionnaire ( for author who posted an event )
  • Faculty Questionnaire
  • Programs of a College
  • Colleges of a Programs
  • Features to toggle
    • Stories
    • Events
    • Innovations
    • Opportunities
    • Discussions
    • News
  • Smart system ( Disable / Enable for Next Release / Auto Approve All for Next Release) (Default - Disable)
  • Magazine Type ( Single blog / Manual Release / Automatic Release ) (Default Single blog)
  • Edition interval for next edition (Default 30 days)
  • Minimum number of posts per edition (Default 10 posts)

How smart system is gonna work ?

If any post is sent to smart disabled magazine, it should wait till magazine admin approves it. If that particular magazine is enabled for auto approval, it should automatically approved without any delay. If that magazine is enabled for smart approval, then it always depends on author approval rate. If recent 5 posts created by author is approved, then only post will get approved on that magazine without delay. Otherwise, the post has to wait for magazine admin approval.

How versioning / edition of magazine system gonna work ?

Single Blog Release Mode: Will have only 1 version / edition. All approved posts will be added to that version only. And this single blog edition magazine will not have any dates associated with it.

Manual Release Mode: Every magazine will have 1 or more editions. These editions can be created manually whenever admin wants to release / created by specifying release date. Admin can add / remove approved stories for each upcoming edition release. But edition can only be released if and only if minimum number of stories / posts scheduled for the edition.

Automatic Release Mode: Editions will be released automatically based on edition releasing date. Whenever there is a release, new upcoming edition will be created on database by calculating next release date if there are no upcoming editions are scheduled. Apart from automated releases, admin can also create and release manual editions whenever he wants.

Clone this wiki locally