Update MySQL database and web interface

In Progress

There have been the following changes to the ISSR table:

-added an additional field to the right of "ISSR_SIC_CD" (which appears on the Public Company screen of the MySQL database as "SIC Code") called "ISSR_IND_SCTR_NM." This field should be added with the same type of partial completion text box above it to the public company screen to the right of "SIC Code" and be labeled "SIC Description." This field should also appear in the "Company Details" sub-screen underneath "SIC Code."

-populated 4 fields to the right of ISSR_FYE; 1) ISSR_LRG_ACCLRTD_FLR_IN, 2) ISSR_ACCLRTD_FLR_IND, 3) ISSR_SML_RPTG_CPNY_IN, and 4) ISSR_WLL_KNWN_SND_ISSR_IN. These are true/false indicators that should be shown in the "view details" sub-screen of the Public Company screen underneath the "Fiscal Year End" field in the "Company Details" box..

-I removed one of the address fields so now there are only 3, but you will need to combine the address fields as you did before for the new issuers (see next point).

-There are several hundred new issuers that will need to be added but of course all of the IDs stay the same for the old ones - I assigned IDs to the new ones.

I also removed the "ISSR_ACTV_INDCTR field from the ISSR table but this wasn't being used in the MySQL database.

Much of the data in the ACCTG_FIRM_CLIENT table has been updated and there are new records in this table as well. I added a field for AUD_OPN_DT_4 but you do not need to add a new field, just update the data in the first three AUD-OPN fields.

The ACCT_FIRM table has been appended.

Also, I've adding a new table for fee data (ACCT_FIRM_FEES). The fee data is keyed to the ACCT_FIRM_CLIENT_ID field in the ACCT_FIRM_CLIENT table. I would like to have a new box labeled "Audit Fee Details" and include the data from this table for each of the ACCTG_FIRM_CLIENT relationships (the data isn't yet complete, so some companies will be blank but that's OK; I'll add the data later).

Skills: MySQL, PHP

See more: companies audit, audit php code, audit of company, audit of companies, audit details, audit company, audit companies, web interface, update mysql, mysql database , fiscal, database php interface, mysql view update, combine indicators, web interface php, mysql update field, mysql completion, mysql combine, mysql update database, code web interface, mysql update table, mysql database php code, web audit, type company database table, sic

Project ID: #4754747

Awarded to:

omtechnologies

Will be done as discussed already

$450 USD in 10 days
(162 Reviews)
7.5

26 freelancers are bidding on average $504 for this job

rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$721 USD in 3 days
(425 Reviews)
7.1
kchg

Hello, sir I'm interested with your project. I'll do it for you. Regards.

$721 USD in 3 days
(55 Reviews)
6.7
noahsombrero

Professional web developer here, php/mysql interaction, my specialty.

$600 USD in 5 days
(4 Reviews)
6.5
jsr3

I understand your requirements and ready to start right now. Please check your message box for more details.

$618 USD in 12 days
(64 Reviews)
6.3
shihan033010

Hi please give me the opportunity to start the project.

$631 USD in 10 days
(231 Reviews)
6.3
getwebsolutionsl

Hi, we have expertise in HTML5 / CSS3 (Mobile Browser Compatible & Responsive), jQuery, PHP/MySQL, .Net, OsCommerce, Wordpress, Joomla, Drupal, Magento, ZenCart, Mobile Apps etc. You can see more details with PMB, Than More

$721 USD in 15 days
(30 Reviews)
6.0
DRwebmedia123

Hi There, Please check PM for more details. Thank you.

$412 USD in 8 days
(67 Reviews)
6.0
csajit

LETS DO IT!!!

$526 USD in 3 days
(138 Reviews)
5.8
abhius

Greetings. Dedicated and Professional committed to deadlines. Ready to start now. Please check message for details.

$700 USD in 8 days
(56 Reviews)
5.7
musashi42

Hi, I'm interested. I have over 10 years of experience in php/mysql and more. Please check my profile and Your INBOX for more details. Thank You.

$500 USD in 3 days
(15 Reviews)
5.4
phpraza

Ready to do it for you

$250 USD in 1 day
(78 Reviews)
5.4
surajddk

Hi, PHP + Mysql expert here! I can do this perfectly! Completed nearly 30 projects related tp PHP + Mysql. Please check my profile for more details, send me a PM ...

$333 USD in 3 days
(27 Reviews)
5.4
abanipatra

Hi, I would like to work on your project. Regards Abani

$255 USD in 7 days
(67 Reviews)
5.3
farhaoui

Thank you for giving your precious time to review my bid and check PM! Thank you

$257 USD in 2 days
(63 Reviews)
5.3
CodeInformatics

Extremely interested and can guarantee the desired solution will work closely with you.

$526 USD in 8 days
(1 Review)
5.2
miniric3

Kia ora! Mulvays.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

$773 USD in 21 days
(6 Reviews)
5.3
Eliteprog

Hi, First of all thanks for posting this project, I am available to provide you economical services for web development , I have read and understood all of project details. I am expert in software development and c More

$511 USD in 8 days
(23 Reviews)
5.0
on2it

Kia ora! On2itonline.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$773 USD in 21 days
(5 Reviews)
5.0
phpthebest

Hi, I can start now.

$263 USD in 3 days
(39 Reviews)
4.9
truongnx15fl

Hello, I interested in your project and would like to make changes to your website, would you mind sharing more details about your web interface? Thanks

$333 USD in 7 days
(42 Reviews)
4.9