CSV/XLS Export - PHP/PostgreSQL

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.