Em Andamento

Extract Data and create PDF file

PHP Script to extract data from mySQL database, create PDF file to print addresses onto Envelopes using PDF file.

Create PDF File with FPDF library.

## Deliverables

Basic Script: 1. Open page to request amount of records to be printed 2. Select from mySQL database 3. if too few, request new amount. 4. If enough records, extract data, write to PDF file, send PDF file by email, update records in mySQL database. Write script in PHP and use FPDF creator to create. [url removed, login to view] Error trapping Sample database with data will be send to successfull bidder. Requirements: PHP Script to extract data from mySQL database, create PDF file and print addresses onto Envelopes using PDF file. Please find detailed description and database schema below. -------------------------------------------------------------- DATABASE REQUIREMENTS/SCHEMA CURRENT EXISTING mySQL Database CURRENT TABLE TABLE NAME: Registrations TABLE FIELDS: Table fields are as follows: 1. id [INT 11] 2. Date: [DATE] {date and time of capture (now)} 3. Source: [VARCHAR 40] 4. Enterprise_name: [VARCHAR 100] {long names possible and extended ASCII Characters must be allowed} Typical long name and sometimes longer: "OCEAN BLUE INFORMATION MANAGEMENT SOLUTIONS" 5. Enterprise_number: [VARCHAR 20] {} Typically "2010/091030/23" 6. Enterprise_activity: [TEXT] {} Typically "SALE MAINTENANCE AND REPAIR OFMOTOR VEHICLES AND MOTOR R CYCLES;RETAIL TRADE IN AUTOMOTIVE FUEL" 7. Enterprise_region: [VARCHAR 40]{Province} Typically "Kwa-Zulu Natal" 8. Enterprise_Postal_Address1: [VARCHAR 50] 9. Enterprise_Postal_Address2 [VARCHAR 50] 10. Enterprise_Postal_Address3 [VARCHAR 50] 11. Enterprise_Postal_Address4 [VARCHAR 50] 12. Enterprise_Postal_Code [VARCHAR 50] 13. first_mailing_date: [DATE] {date and time of capture (now)} TABLE NAME: reason_label TABLE FIELDS: 1. id 2. Reason_for_label {VARCHAR 100] {typically to be: first directmailing} TABLE NAME: labels_printed TABLE FIELDS: 1. id 2. Reason_for_label [INT 9] {id of selected Reason_for_label once selected} 3. Date: [DATE] {date and time of capture (now)} 4. id_of_lead [INT 9] {id of lead from Table "Registrations"} 5. coupon_number [VARCHAR 20] SCRIPT PSEUDO: 1. Open Page 2. Enter in text box the number of addresses to print 3. Enter Reason for label print from List box 4. Enter Coupon Number 5. Search database where TABLE "Registrations" first_mailing_date == "" AND Date newest date DESCENDING to older date. (In other words, always the newest records first.) **Check for duplicates: Duplicates not allowed. Can be tested on address_1, address_2, address_3 together. NOT on enterprise_name.. Some Enterprises will be together at one address. If it happens that the second enterprise at the same address get a mailing the next day/week, then it is fine, but we do not want all to be sent on one day. 6. Select the number of records as entered in text box at step 2. 7. Show number found 8.. If number found is less than number requested, then show " Found records less than requested. Enter new amount" in RED at top. Show Text box again to enter amount and reason for printing labels and Coupon Number just as step 2. 9. If number found is not less than number requested (in other words it is equal), then have button to confirm to continue. 10. upon clicking on button, a. write the address fields i) to a PDF file ii) using FPDF to create iii) ONE record per page in centre of Page iv) in landscape v) in Verdana font +- 12px Address Fields: enterprise_name, Enterprise_Postal_Address1, Enterprise_Postal_Address2 , Enterprise_Postal_Address3 , Enterprise_Postal_Address4 , Enterprise_Postal_Code We will fine tune the spacing, font size, etc to ensure it will print properly on our envelopes. b. Save file to name: {reason_for_label , "+", date+Time now, ".pdf"} in sub directory "\labels" c. Send file to email address "xxxx @ [url removed, login to view]" as attachment d. write to TABLE labels_printed. One record per address printed. Add date and time in DATE, Reason to print in REASON_FOR_LABEL and the id of the enterprise record from TABLE registrations in TABLE labels_printed FIELD ID_OF_LEAD and in coupon_number field the coupon number as entered in step 4. (This file will be opened with Adobe Acrobat Reader and all pages will be printed on Printer containing empty Envelopes) 11. Error Trapping must be included. IF File cannot be created, DO NOT write records to mySQL Table. IF data cannot be written to mySQL table, DELETE File before sending and delete from\labels. Display request Page "Error encountered: Do you wish to Retry?". If YES, back to Step 2. If NO, send email to address "xxxx @ [url removed, login to view]" with message that export failed. Optional: If error reason is available, include this in email. ***NOTE: PDF File MUST be created with FPDF utility. PDF file will typically contain 1000 addresses per file. Script MUST be written in PHP mySQL database with sample data will be provided to selected Bidder.

Habilidades: Linux, MySQL, Instalação de Script, Shell Script

Ver mais: script php extract data mysql, script text reader in php, schema update, printed names, php script to export mysql database to pdf, php pdf reader script, php fpdf mysql, php and mysql pdf, note creator, library creator, int v, int size c, find script font, find creator, day automotive, date utility, data capture solutions, c.c. enterprises, ascii solutions, script reader, r mailing list, open table coupon, one day pdf, id creator, find mailing address

Acerca do Empregador:
( 75 comentários ) Pretoria-North, South Africa

ID do Projeto: #2984108

Premiar a:

vmworks

See private message.

$85 USD em 14 dias
(29 Avaliações)
5.0

20 freelancers are bidding on average $68 for this job

hits

See private message.

$85 USD in 14 dias
(742 Comentários)
8.7
shihan033010

See private message.

$68 USD in 14 dias
(246 Comentários)
6.6
WiPage

See private message.

$85 USD in 14 dias
(135 Comentários)
6.7
andreioniga

See private message.

$85 USD in 14 dias
(35 Comentários)
6.5
smartwork123

See private message.

$85 USD in 14 dias
(47 Comentários)
6.4
vw1621783vw

See private message.

$51 USD in 14 dias
(138 Comentários)
5.7
skysword

See private message.

$76.5 USD in 14 dias
(37 Comentários)
5.2
bugtisoft

See private message.

$85 USD in 14 dias
(14 Comentários)
4.1
dmitryperelman

See private message.

$68 USD in 14 dias
(36 Comentários)
4.6
desirablecoder

See private message.

$85 USD in 14 dias
(4 Comentários)
3.5
readyfacts

See private message.

$68 USD in 14 dias
(24 Comentários)
4.3
kthsoft

See private message.

$84.15 USD in 14 dias
(5 Comentários)
3.1
ebagrov

See private message.

$35.7 USD in 14 dias
(8 Comentários)
3.2
usmanehsan

See private message.

$68 USD in 14 dias
(10 Comentários)
2.8
klvworker

See private message.

$34 USD in 14 dias
(4 Comentários)
2.1
itsali0009

See private message.

$38.25 USD in 14 dias
(4 Comentários)
1.6
zarish

See private message.

$85 USD in 14 dias
(3 Comentários)
2.0
gordonc45

See private message.

$25.5 USD in 14 dias
(2 Comentários)
0.0
sebarocker

See private message.

$63.75 USD in 14 dias
(0 Comentários)
0.0