Aye Aye Aung #80
openElection Management - Voter
100%
Description
CRUD operation for voter. There have single entry and bulk entry by excel.
Addionally, the action will include print and send voter id by email.
you will need to integrate sms gateway integration by using myanticket senderID.
The features include send single voterID ,bulk voterID and selected voterID.
voter_tbl
id (BIGINT UNSIGNED)
voter_id (BIGINT UNSIGNED) -- Foreign key referencing users.id (voter)
name (VARCHAR(255))
email (VARCHAR(255))
phone_no (VARCHAR(15))
vote_count (INT DEFAULT 1)
contact_method (ENUM: 'sms', 'email','both')
is_verified (BOOLEAN) -- OTP validation step is valid
created_at (TIMESTAMP)
updated_at (TIMESTAMP)
Updated by Aye Aye Aung about 1 year ago
delivery_log_tbl
id (BIGINT UNSIGNED)
election_id (BIGINT UNSIGNED)
election_postion_id (BIGINT UNSIGNED)
voter_id (BIGINT UNSIGNED)
contact_method (ENUM: 'sms', 'email', 'both')
message (TEXT)
status (ENUM: 'delivered', 'failed')
response (TEXT)
timestamp (TIMESTAMP)
created_at (TIMESTAMP)
updated_at (TIMESTAMP)
Updated by Aye Aye Aung about 1 year ago
- Due date changed from 01/10/2025 to 01/11/2025
- Start date changed from 01/10/2025 to 01/11/2025
Updated by Aye Aye Aung about 1 year ago
There have voting information under the election management. There have voting record, reject voting record, not voted record, voting result.
Track election progress in real-time (e.g., voter turnout, active participation).
election_position_voters_tbl
id (BIGINT UNSIGNED)
election_position_id (BIGINT UNSIGNED) <- Foreign key referencing election_position_tbl.id
voter_id (BIGINT UNSIGNED) <- Foreign key referencing voter_tbl.id
status (ENUM: 'done', 'not yet', 'rejected')
created_at (TIMESTAMP)
updated_at (TIMESTAMP)
Updated by Aye Aye Aung about 1 year ago
- Due date changed from 01/11/2025 to 01/10/2025
- Start date changed from 01/11/2025 to 01/10/2025
Updated by Aung Tin about 1 year ago
- Status changed from New to In Progress
- % Done changed from 0 to 10
Updated by Aung Tin about 1 year ago
- % Done changed from 50 to 70
- Fixed issue for send email, configuration and implementation code. (70% completed)
- Need to add send sms and configuration code. (0% completed)
Problem:
- Occur issue for send email and some configuration data.
Updated by Aung Tin about 1 year ago
Fixed wrong flow and join election, position and voter.
Updated by Aung Tin about 1 year ago
- Status changed from In Progress to Resolved
- % Done changed from 70 to 100
Updated by Aung Phyo Oo 11 months ago ยท Edited
For election type: questionnaire
election_questionnaires_voters_tbl
id (BIGINT UNSIGNED)
election_id (BIGINT UNSIGNED) <- Foreign key referencing election_tbl.id
voter_id (BIGINT UNSIGNED) <- Foreign key referencing voter_tbl.id
status (ENUM: 'done', 'not yet', 'rejected')
created_at (TIMESTAMP)
updated_at (TIMESTAMP)