CSV/XLS Export - PHP/PostgreSQL

  • Posted:
  • Proposals: 3
  • Remote
  • #45838
  • Archived
Herry H.Mantra L.Alferaru I. have already sent a proposal.
  • 0

Description

Experience Level: Expert
CSV/XLS EXPORT

1. TRAMITES PAGE
-Feature: Export; Save as .csv | Save as .xls
-Existing documents: tramites.php, save_as.tramites.save_as_csv.php, save_as.tramites.save_as_csv.php
-Description: Exports \'tramites\' only records, all columns;
public.tramites
folio INT4 NOT NULL,
creation_date DATE,
clave VARCHAR(40),
title VARCHAR(200),
process_type VARCHAR(200),
submitter VARCHAR(200),
status VARCHAR(200),
reason VARCHAR(200),
date_added TIMESTAMPTZ,
processed INT2 DEFAULT 0,
original_clave VARCHAR(40),


2. PREDIAL PAGE
-Feature: Export; Save as .csv | Save as .xls
-Existing documents: predial.php, save_as.predial.save_as_csv.php, save_as.predial.save_as_xls.php
-Description: Exports \'public.predial\' table records, all columns;
clave VARCHAR(40) NOT NULL,
owner_name VARCHAR(240),
on_record_since DATE,
amount NUMERIC(131089),
total_predial NUMERIC(131089),
total_surcharges NUMERIC(131089),
total_discounts NUMERIC(131089),
cost_of_implementation NUMERIC(131089),
grand_total NUMERIC(131089),
status VARCHAR(20),
with_effect_from VARCHAR(40),
date_added TIMESTAMP(29),
processed INT2 DEFAULT 0,


3. IDX PAGE
-Feature; Export; Save as .csv | Save as .xls
-Existing documents: idx.php
-Need to create documents: save_as.idx.save_as_csv.php, save_as.idx.save_as_xls.php
-Description: Exports \'public.idx\' table/records, all columns;
listing_number VARCHAR(10) NOT NULL,
clave VARCHAR(200),
tax_id VARCHAR(200),
clave_count INT2 DEFAULT 0,
folio INT4,
main_photo_id VARCHAR(60),
photo_fetched INT2 DEFAULT 0,
listing_office VARCHAR(200),
remark1 TEXT,
remark2 TEXT,
mls VARCHAR(60),
last_modified TIMESTAMP(29) DEFAULT \'now()\',
wgs VARCHAR(120),
utm VARCHAR(120),
ll VARCHAR(120),
date_added TIMESTAMP(29),
list_price FLOAT4,
sold_price FLOAT4,
serial_data TEXT,
status VARCHAR(1),
obj_serial_data TEXT,
photos_count INT2 DEFAULT 0,
photos_serial_data TEXT,
flexmls_id VARCHAR(60),
m2 NUMERIC(131089),
bedrooms INT2,
full_baths INT2,
-Notes: Re-use/recycle tramites/predial code, change table name and column names, etc.

4. DMP PAGE
-Feature: Export: Save as .csv | Save as .xls
-Existing documents: dmp.php
-Need to create documents: save_as.dmp.save_as_csv.php, save_as.dmp.save_as_xls.php
-Description: Exports \'public.tramites, public.predial, and public.idx\' tables/records, all columns;
folio INT4 NOT NULL,
creation_date DATE,
clave VARCHAR(40),
title VARCHAR(200),
process_type VARCHAR(200),
submitter VARCHAR(200),
status VARCHAR(200),
reason VARCHAR(200),
date_added TIMESTAMPTZ,
processed INT2 DEFAULT 0,
original_clave VARCHAR(40),

clave VARCHAR(40) NOT NULL,
owner_name VARCHAR(240),
on_record_since DATE,
amount NUMERIC(131089),
total_predial NUMERIC(131089),
total_surcharges NUMERIC(131089),
total_discounts NUMERIC(131089),
cost_of_implementation NUMERIC(131089),
grand_total NUMERIC(131089),
status VARCHAR(20),
with_effect_from VARCHAR(40),
date_added TIMESTAMP(29),
processed INT2 DEFAULT 0,

listing_number VARCHAR(10) NOT NULL,
clave VARCHAR(200),
tax_id VARCHAR(200),
clave_count INT2 DEFAULT 0,
folio INT4,
main_photo_id VARCHAR(60),
photo_fetched INT2 DEFAULT 0,
listing_office VARCHAR(200),
remark1 TEXT,
remark2 TEXT,
mls VARCHAR(60),
last_modified TIMESTAMP(29) DEFAULT \'now()\',
wgs VARCHAR(120),
utm VARCHAR(120),
ll VARCHAR(120),
date_added TIMESTAMP(29),
list_price FLOAT4,
sold_price FLOAT4,
serial_data TEXT,
status VARCHAR(1),
obj_serial_data TEXT,
photos_count INT2 DEFAULT 0,
photos_serial_data TEXT,
flexmls_id VARCHAR(60),
m2 NUMERIC(131089),
bedrooms INT2,
full_baths INT2,
-Notes: Re-use/recycle tramites/predial code, include all three tables(tramites/predial/idx), etc.


5. CLAVES PAGE
-Feature: Export: Save as .csv | Save as .xls
-Existing documents: claves.php, save_as.claves.save_as_csv.php, save_as.claves.save_as_xls.php
-Need to create documents: save_as.clave_groups.save_as_csv.php, save_as.clave_groups.save_as_xls.php
-Description: Exports \'public.tramites, public.predial, and public.idx\' tables/records, all columns;
folio INT4 NOT NULL,
creation_date DATE,
clave VARCHAR(40),
title VARCHAR(200),
process_type VARCHAR(200),
submitter VARCHAR(200),
status VARCHAR(200),
reason VARCHAR(200),
date_added TIMESTAMPTZ,
processed INT2 DEFAULT 0,
original_clave VARCHAR(40),

clave VARCHAR(40) NOT NULL,
owner_name VARCHAR(240),
on_record_since DATE,
amount NUMERIC(131089),
total_predial NUMERIC(131089),
total_surcharges NUMERIC(131089),
total_discounts NUMERIC(131089),
cost_of_implementation NUMERIC(131089),
grand_total NUMERIC(131089),
status VARCHAR(20),
with_effect_from VARCHAR(40),
date_added TIMESTAMP(29),
processed INT2 DEFAULT 0,

listing_number VARCHAR(10) NOT NULL,
clave VARCHAR(200),
tax_id VARCHAR(200),
clave_count INT2 DEFAULT 0,
folio INT4,
main_photo_id VARCHAR(60),
photo_fetched INT2 DEFAULT 0,
listing_office VARCHAR(200),
remark1 TEXT,
remark2 TEXT,
mls VARCHAR(60),
last_modified TIMESTAMP(29) DEFAULT \'now()\',
wgs VARCHAR(120),
utm VARCHAR(120),
ll VARCHAR(120),
date_added TIMESTAMP(29),
list_price FLOAT4,
sold_price FLOAT4,
serial_data TEXT,
status VARCHAR(1),
obj_serial_data TEXT,
photos_count INT2 DEFAULT 0,
photos_serial_data TEXT,
flexmls_id VARCHAR(60),
m2 NUMERIC(131089),
bedrooms INT2,
full_baths INT2
-Notes: Broken down for each clave number group, e.g.-
402
27237 Assigned
11285 Unassigned
6531 Not yet searched
26890 Predial
9658 Tramites
178 IDX
6538 Manual
=====
402001
863 Assigned
325 Unassigned
27 Not yet searched
441 Predial
711 Tramites
23 IDX
27 Manual
=====
402001000
2 Assigned
2 Unassigned
0 Not yet searched
0 Predial
4 Tramites
0 IDX
0 Manual
-Notes: The above clave number groupings and each of their \'Assigned, Unassigned, Not yet searched, Predial, Tramites, IDX, and Manual\' entires need to be exportable to .csv. and .xls.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.