Fetch/retrieve inbox and attachments from laravel ( microsoft account )
Budget: $30 – $250 USD
Create a project in Laravel/php, which daily retrieves emails (personal account: Hotmail, outlook) and downloads client attachments to a project folder.
List of tables can add more fields
Client table: clientid, email, password_email
Email table: idemail,subject, sender, message, UID( IMAP EMAIL id), folder, date, client_id
Attachment table: attachment_id, attachment_name, email_id, processed(DEFAULT 0), content( data type json)
Requirements
Create view to see for each client their email list and for each email the attachments
Generate function to recover the tokens for each email account, it must return the token
Create a schedule to retrieve emails (with sender parameter include '@claim.com','@store.claim.com') and attachments (save in the email and attachment table)
Create a schedule that runs after the email schedule, and runs through the attached table, only the records that have not been processed processed: 0, and places in the content field:
{'date1': 'RFC-C-FC-250037-2023-P'
'date2': 'Lima, 20 de febrero del 2023'
'date3': '2023-02-20'
'date4': 'LOPEZ MIROQUE JETO'
'date5': 'CALLE VARADERO ASENT. H. LUIS STA. PRIETO VAR RISANTE - PROVINCRISANTE - DEPARTRISANTE'
'date6': '051-93960'
'date7': 'FC-250037-2023'
'date8': 'Infundado'}
For data8, search for the word 'Infundado' and obtain the text that continues until the period character (omit special characters). Finally change the value of the processed field to 1
decode subject and message before saving to table.
Use webklex for IMAP for retrieve email, attachment
List of tables can add more fields
Client table: clientid, email, password_email
Email table: idemail,subject, sender, message, UID( IMAP EMAIL id), folder, date, client_id
Attachment table: attachment_id, attachment_name, email_id, processed(DEFAULT 0), content( data type json)
Requirements
Create view to see for each client their email list and for each email the attachments
Generate function to recover the tokens for each email account, it must return the token
Create a schedule to retrieve emails (with sender parameter include '@claim.com','@store.claim.com') and attachments (save in the email and attachment table)
Create a schedule that runs after the email schedule, and runs through the attached table, only the records that have not been processed processed: 0, and places in the content field:
{'date1': 'RFC-C-FC-250037-2023-P'
'date2': 'Lima, 20 de febrero del 2023'
'date3': '2023-02-20'
'date4': 'LOPEZ MIROQUE JETO'
'date5': 'CALLE VARADERO ASENT. H. LUIS STA. PRIETO VAR RISANTE - PROVINCRISANTE - DEPARTRISANTE'
'date6': '051-93960'
'date7': 'FC-250037-2023'
'date8': 'Infundado'}
For data8, search for the word 'Infundado' and obtain the text that continues until the period character (omit special characters). Finally change the value of the processed field to 1
decode subject and message before saving to table.
Use webklex for IMAP for retrieve email, attachment