Aye Aye Aung #80
open
Election Management - Voter
Added by Aye Aye Aung about 1 year ago.
Updated 11 months ago.
Due date:
01/10/2025 (about 12 months late)
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)
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)
- Due date changed from 01/10/2025 to 01/11/2025
- Start date changed from 01/10/2025 to 01/11/2025
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)
- Due date changed from 01/11/2025 to 01/10/2025
- Start date changed from 01/11/2025 to 01/10/2025
- Status changed from New to In Progress
- % Done changed from 0 to 10
- % Done changed from 10 to 50
- % 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.
Fixed wrong flow and join election, position and voter.
- Status changed from In Progress to Resolved
- % Done changed from 70 to 100
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)
- Status changed from Resolved to In Progress
- % Done changed from 100 to 10
add voters for questionnaire and pivot table
- % Done changed from 10 to 30
joins_election_voters table
election_id
voter_id
'status', ['done', 'not_yet', 'rejected']
- Status changed from In Progress to Resolved
- % Done changed from 30 to 100
Also available in: Atom
PDF