Ponditi

• Compititors - https://bdtutors.com/

• Tuotial

Technologies

• Testing (jest)
• Database
• Backend (Node.js nest.js)
• Eslint (Clean coding)
• Typescript

Development

• next js typescript
• tsconfig
• Eslint setup now install npm install --save-dev eslint @typescript-eslint/parser @typescript-eslint/eslint-plugin eslint-config-prettier eslint-plugin-prettier prettier
• A room that will have two users with room status
• Server and client will have seperated cookie for login

1. Teachers will not be able to chat before student write anything
2. Chat will be closed after completing the tuition
3. Change the label "student" to "Learner" everywhere in the website. There should be no "Student" label.
4. Teacher will not be able to change the tuition request page until he change the status of expired tuition schedule.
5. Admin panel will get the notification of expired task.
6. Change the browser tab title
7. Total count and search option(id,name,phone no) in Admin panel.
8. Google search index for ponditi.com
9. Compress profile photo

Typescript

• socket io typescript

• Deals with cookie and socket io

• redux toolkit typescript, tutorial

• Requirement update-2

• Reset all targeted value after making request and mounting a component

• Register user

  • ✅ Only digit for OTP Code
  • Verify user profile by admin (Until they are verified they will be unlisted from search)
  • ✅ Next button to the right
  • ✅ Use bulk sms bd for sending messages

• Send request

  • ✅ Detail of teacher (Any one can see techer detail), Send request visible only if he is logged in as student
  • ✅ After filtering by default they will select subjects and class (By default no available class and subjects)
  • ✅ No duration or estimated bill - only hourly rate
  • ✅ Select slot (8 to 10)

• Update profile

  1. Educational qualification
     • ✅ Exam name (SSC / HSC / )
     • ✅ Institution
     • ✅ Group (Science, Arts, & commerce)
     • ✅ Result
     • ✅ Passing Year
  2. Personal Detail
     • Picture (Later)
     • ✅ Name
     • ✅ Email
     • ✅ District
     • Present Address (Used to search )
  3. Tution Detail
     • ✅ Rate per hour
     • ✅ Status (Currenty available to request or not )
     • Tution place multile selection
  4. Subjects
     • ✅ Tution subjects
     • ✅ Tution class types

• Scheduled Class detail

  • ✅ No bill and duration
  • ✅ Detail location of student
  • ✅ Institution name
  • ✅ Scheduled time
  • ✅ Picture, Name, Class & Subject

• Top Bar

  • ✅ Profile
  • ✅ Request histry (Filter by pending requests, rejected requestes)
  • ✅ Notifications

• Tution process by teacher

  • ✅ Start tution (No more request acceptable)
  • ✅ Minutes counting
  • ✅ Finish tution (bill depends on per minute count)
  • ✅ Mark as paid (Student can not send request until they pay their dues)
  • ✅ Give feedback

• Modification-1

  • ✅ Making class and subjects without reload the admin dashboard page (To make relationship it needs id of subject and classtype)
  • ✅ User should not regester twice
  • ✅ User will have different education level
  • ✅ Multiple class and subjects of a teacher
  • ✅ Start imiddeate action after start class, accept, reject, finish class, review etc
  • ✅ select default subject and class of teacher if search has none of it
  • ✅ select item background in Calender
  • ✅ All class are online for now. Fix in server initiate class
  • ✅ Show slot time

• Modification-2

  • ✅ Make google place api work
  • ✅ Make navbar smaller
  • ✅ No scrolling for searching teacher
  • ✅ Search button on the right
  • ✅ Logout button doesn't work on production
  • ✅ Option for selecting multiple option for tution location - online, tl, sl

• Modification-3

  • ✅ No tution fee for student - Available status is not changing on production
  • ✅ Show role on top bar
  • ✅ Need to work with Calender - Select current date, add 7 days, work next and previous
  • ✅ Align time slot
  • ✅ Add profile picture
  • ✅ Add address in order to initialize scheduled class
  • ✅ Notification bar
  • Make More responsive
  • ✅ Approve button on detail page of scheduled class

• Requirement-1

• ✅ Work with review

• Generate link for scheduled class that is online only

• Send notification for new requests via phone or mobile browser

• Teacher per hour rate need to update (client's dashboard input fields)

• ✅ Send request with current time of client to initialize scheduled class

• ✅ List of requested students

• ✅ Validate with express validator in every page

• ✅ Add user types (ONLINE, TL(Student's Location), SL(Student's Location), ANY)

• ✅ Add users online, TL, SL

• ✅ Add hourly fees if he is teacher

• ✅ Student teacher relationship for send request

• ✅ Remove from signup - subjects, classes

• ✅ Create or seed some random user

• ✅ Profession

• ✅ Make sign out

• ✅ Create tables of classes, subjects

• ✅ Setup eslint for server

• google place api for location search

• ✅ 1 hour session

• ✅ Search teachers

• ✅ Search category 1, online 2, offline 3, home

• Search by Location - google place api

• ✅ Remove teacher/student from login page

• User to feedback (many to many relationship)

• Requirement update-3

• No preffered class, subjects, and tuition place

• Different page or section for signup as student and reacher

• User should not be able to register with same phone twice

• Confused - 16

• ✅ Fixing menu

• ✅ phone change cc - Phone country code

• teacher type - arabic, bangla, english in the search

• Location api for user location in regestration,

• Set profession by default the role

• ✅ send id and password

• ✅ We should keep 2 step for regestration

• ✅ No age, profesion, cgpa

• ✅ passing year, Currently studying option

• Send message on first attempt

• Check all functions of update

• add educational qualifications not working at the time of registration

• Reset password

• Requirement update-4

• ✅ OTP is not sending properly (register) -> use full code inside router callback (not from sendsms)

• ✅ No tabs for classes and account (register)

• ✅ Add profession and institution (register)

• ✅ if anyone check on currently studying passing year will be disable (register)

• ✅ Degree / education -> height education (register)

• ✅ Search functions need to work

• Frontend no result on search

• Tuition style (Online, teacher's location, student's location)

• Login redict to login page again on production

• Rates for different subjects

• Requirement update-5

• Page change loading

• ✅ Add rate for teacher - calculate monthly rate

• ✅ Profession will be student, Full Name, Email, Medium, Class, Institution, Location

• ✅ No rate, subject, for students

• ✅ dashboard -> update user - no any medium

• Rivisions

• Change favicon.ico

• ✅ Custom 404 page

• A function should run in every hour to delete unverified users - setInterval

• ✅ Image optimizations - https://nextjs.org/docs/basic-features/image-optimization - test with lighthouse private window

• ✅ Next.js -> start loading in one page(e.g. login) turn off loading from another page(e.g. dasboard page). if request fails then turn off loading

• ✅ (no need for our project)improve the initial loading performance https://nextjs.org/docs/advanced-features/dynamic-import

• Deployment guide, Static HTML Export

• Show properly one by one Medium -> classes -> subjects (required field - hide when it unchecked)

• no education, no tution detail, prefered subject and classes detail for student,

• ✅ No gmail login

• Google place api error

• ✅ highest education

• ✅ Modal calculating tuition fee

• Style improvement in tuition style - online / teacher's location / student's location in registration page

• ✅ rate for tuition style -> different rates for student's location teacher's location and online

• ✅ www.ponditi.com add in message

• ✅ Exam detail form - list all exam on component mount

• ✅ Add education freely

• ✅ Experience below the name - dashboard page

• Update tuition detail rates for diffrent tuition stule

• Search result display properly with diffrent rate

• 1. Personal detail and tuition detail to be in one section and at top
• 2. end section preffered subject
• 3. 3rd section education detail

• server - TL_SL_TL_SL

• Should remove all educational detail from user model and keep it clean with education model relationship

• Update medium is not working

• Scheduled class and search request page need to modify used id as query parameters

• Requirement update-6

• ✅ Search component design change in home page

• Add message after register(not working)

• ✅ Exam title, major, institution, board, passing year - cerrently runnning

• No subject edit in student dashboard

• Medium in place of group after exam title

• Medium class below student

• ✅ District - list -

• ✅ Add education freely (not working)

• No board from education model backend and database

• ✅ Show any field between running study and passing year

• Search teacher design change

• ✅ Make header smaller

• ✅ make a refereance field for regestration

• ✅ make sure updating education is working

• ✅ Solve frontend hosting issue

• ✅ Password vul dile code dekhai

• ✅ Send verification code instead of otp

• Check used class and subject is properly selecting or not

• Problems adding tuition medium

• Requirement update-7

• Profile pic show korena

• Personal Details e District name capital letter e ashena

• Tuition rate edit kora jacchena

• Education sector e institution er naam set korar por o show korena

• Requirement update-8

• Change calculator style for mobile

• Create a sub domain

• ✅ Remove these two lines from Registration page and change the button name to Submit

• ✅ Change “Phone Number” to “Continue with Mobile No”

• ✅ Remove the line and keep single line like the following pic

• ✅ Remove the social media icons from here and add it in the right bottom side of foother

• ✅ Change the verification message to “Your Ponditi verification code is : 784547”.

• ✅ Align the Profile name and title in the middle and set the profile pic below them

• Edit button in the personal Information section will take to the exact same interface where the teacher was registered

• ✅ Change the profile pic frame to round and keep a camera icon as upload button in the top right side

• ✅ Upload button in the profile pic with directly ask to select the pic from the device, Mobile phone will open the gallery directly

• ✅ Remove the icon in the title and keep the title closer to the profile name

• ✅ Remove the line from address

• ✅ Keep the profile setting in the top right side of the navbar with profile name like the below pic and add Edit profile, Request history, change password & Logout options in the dropdown (See the pic below)

• ✅ Keep the color to white removing ash color (No 1) and make the details bold(No 2)

• ✅ No cancel button works in edit section

• ✅ Keep all the checkboxes in the left side not in the right side

• ✅ Add email address in the middle of the footer “infor@ponditibd.com”

• Requirement update-9

• ✅ For student update only 1 medium and 1 class

• ✅ Home text change

• ✅ Change user table name

• ✅ Admin - reject button is not working

• ✅ Update mudium, class, subject is not working properly

• Requirement update-10

• ✅ Can not send message to all browser in the room

• ✅ 150px card

• ✅ bold tk

• ✅ top bar shadow in detail

• ✅ Available Status not in search detail page

• ✅ send request and chat button

• ✅ Chat page

• ✅ Prebook slot disabled

• ✅ Description to notes

• ✅ no hourly rate

• ✅ Notifications on menu need to resize and align properly (from teacher's)

• ✅ send request from chat

• ✅ no any option in search with class, medium, subject

• ✅ Booked slot will be disabled

• ✅ No professional institution for student

• ✅ NCheck current date is greater than previously saved date

• ✅ Nlocation of student can be edited edit

• ✅ Complete button only

• ✅ add gender and nid card field

• ✅ Profile page, on off in jamal

• fix chat time on sending sms

• Notification sms on phone (Accept, share link)

• Disable slot is not working

• Not getting right notigication message

• SMS Unseen ribbon

• Chat is not working properly

• AI Detects mobile number and social media links

• A teacher can block a student or a student can block a teacher

• delete useless images from AWS

• duplicate database and keep backup in excel file

• Search button

Sequelize problems

• Notification and education need to migrate properly with user when we add a new field to user
• Setup sequelize from scretch - association and migrations

Ask questions

Advancing

• Update next js 13
• Microservices
• Dockerizing
• Using sequelize cli properly to migrate, and undo with associations
• Testing

Deployment process(server)

• Disable add admin route and seed route from admin router and get all users from user route
• make npm start script in package.json for heroku deployment
• Remove dotenv requirement from server.js for heroku deployment

Deployment on cpanel

• Cpanel - domain -> Create a subdomain -> document root -> click on the file location
• Upload the code
• Software -> setup nodejs app
• Application root will be the domain -> set application start up file
• Install npm packages and start app

MsSQL queries

• Delete all rows

truncate table TableName

• Foreign key check

SET foreign_key_checks = 0;
SET foreign_key_checks = 1;

• We can drop foreign key if we want to and delete a column

// This will show an error if it has an foreign key and will show foreign key name as well
ALTER TABLE Room DROP COLUMN userId;
// Drop foreign key
ALTER TABLE Room DROP FOREIGN KEY Room_userId_foreign_idx;
// Again drop the column
ALTER TABLE Room DROP COLUMN userId;

• Migrations with mssql for specific file

npx sequelize-cli db:migrate:undo:all --to 20220215110049-migration-skeleton.js --url 'mssql://sa:Test1234@localhost/ponditi_db'
npx sequelize-cli db:migrate --url 'mssql://sa:Test1234@localhost/ponditi_db'

• Migration assosiations
• Migrations, many-to-many relationships
• How to define Sequelize associations using migrations

Challenges

• Cross domain cookie

Docker

• Dockerize Your Full-Stack App, Dockerizing Full Stack Web App REACTJS & NODEJS

Track

• We must make all the tracking of database changes

• ✅ Add ref in User and remove board from Education

• ✅ Add institution in User - ALTER TABLE User ADD institution VARCHAR(255); alternate ALTER TABLE dbo.[User] ADD institution VARCHAR(255);

• ✅ Change table name

  // Change table names
  EXEC sp_rename 'User', 'Customer';
  EXEC sp_rename 'UserToClasstype', 'CustomerToClasstype';
  EXEC sp_rename 'UserToSubject', 'CustomerToSubject';
  EXEC sp_rename 'UniqueUserTuitionm', 'UniqueCustomerTuitionm';
  EXEC sp_rename 'UserToTuitionm', 'CustomerToTuitionm';
  
  // Change column name for many to many relation ship
  EXEC sp_RENAME 'CustomerToClasstype.UserId' , 'CustomerId', 'COLUMN';
  EXEC sp_RENAME 'CustomerToSubject.UserId' , 'CustomerId', 'COLUMN';
  EXEC sp_RENAME 'UniqueCustomerTuitionm.UserId' , 'CustomerId', 'COLUMN';
  
  // Change column name one to many
  EXEC sp_RENAME 'Education.UserId' , 'CustomerId', 'COLUMN';
  EXEC sp_RENAME 'Notification.UserId' , 'CustomerId', 'COLUMN';
  EXEC sp_RENAME 'CustomerToTuitionm.UserId' , 'CustomerId', 'COLUMN';
  

• Create Room with relation of customer multiple times

  CREATE TABLE Room (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(20) NOT NULL,
    status VARCHAR(20) NOT NULL,
    createdAt DATETIME NOT NULL,
    updatedAt DATETIME NOT NULL,
    invitorId INT ,
    FOREIGN KEY(invitorId) REFERENCES Customer(id),
    invitereceverId INT,
    FOREIGN KEY (invitereceverId) REFERENCES Customer(id)      
  );
  

• Create Message ane make relation of customer multiple times and relation with room

  CREATE TABLE Message (
    id INT PRIMARY KEY AUTO_INCREMENT,
    text VARCHAR(255) NOT NULL,
    publish BOOLEAN NOT NULL DEFAULT false,
    createdAt DATETIME NOT NULL,
    updatedAt DATETIME NOT NULL,
    messagesenderId INT ,
    FOREIGN KEY(messagesenderId) REFERENCES Customer(id),
    messagereceverId INT,
    FOREIGN KEY (messagereceverId) REFERENCES Customer(id)   ,
    RoomId INT,
    FOREIGN KEY (RoomId) REFERENCES Room(id) 
  );
  

• Add gender and NID card

ALTER TABLE Customer ADD COLUMN gender VARCHAR(15) NOT NULL SET DEFAULT 'MALE';
ALTER TABLE Customer ADD COLUMN id_proof VARCHAR(100);

• Add notification room table

CREATE TABLE Notroom(
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(20) NOT NULL,
  status VARCHAR(20) NOT NULL DEFAULT 'RUNNING',
  createdAt DATETIME NOT NULL,
  updatedAt DATETIME NOT NULL,
  notroominvitorId INT,
  FOREIGN KEY (notroominvitorId) REFERENCES Customer(id),
  invitereceiverId INT,
  FOREIGN KEY (invitereceiverId) REFERENCES Customer(id)
);