Käynnissä

change mysql data to is20022 and produce xml file, should be done in codeigniter.

[url removed, login to view] rows from remittance table where status value = 1 and UPDATE_DT is null.

2. Convert the data read to Credit Transfer xml and add those xml structures to ISO 20022 abiding xml file.

[url removed, login to view] a new data row to transfer_packet table where created xml file is written in xml_file column of the data row.

4. Update the read remittance table rows as follows:

remittance.transfer_packet_id = PRIMARY key of the newly inserted transfer_packet table row

[url removed, login to view] = 2.

I have made the following modifications to Herokus' database at your disposal.

/* Create a table for transferring xml structures to and from Banks. */

CREATE TABLE `transfer_packet` (

`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

`type` varchar(20) DEFAULT NULL, /* Remittance, Payment, etc... */

`total_amount` decimal(20,2) NOT NULL,

`transferred_date` date DEFAULT NULL,

`IBAN` varchar(34) DEFAULT NULL, /* Payors's = [url removed, login to view]'s IBAN. */

`BIC` varchar(11) DEFAULT NULL, /* Payor's = [url removed, login to view]'s BIC. */

`xml_file` LONGTEXT NOT NULL,

`status` tinyint(4) unsigned NOT NULL, /* 0 = Cancelled, 1 = Waiting for transfer, 2 = Transferred. */

`ORIG_ID` bigint(20) unsigned DEFAULT NULL,

`INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`UPDATE_DT` datetime DEFAULT NULL,

PRIMARY KEY (`ID`),

KEY `orig_id_idx` (`ORIG_ID`)

) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

/* English staus value descriptions. */

insert into text_param_values (language, for_object, for_attribute, text_code, text_value) values (1, 'transfer_packet', 'status', 0, 'Cancelled');

insert into text_param_values (language, for_object, for_attribute, text_code, text_value) values (1, 'transfer_packet', 'status', 1, 'Waiting for transfer');

insert into text_param_values (language, for_object, for_attribute, text_code, text_value) values (1, 'transfer_packet', 'status', 2, 'Transferred');

/* Finnnish staus value descriptions. */

insert into text_param_values (language, for_object, for_attribute, text_code, text_value) values (2, 'transfer_packet', 'status', 0, 'Mitätöity');

insert into text_param_values (language, for_object, for_attribute, text_code, text_value) values (2, 'transfer_packet', 'status', 1, 'Odottaa siirtoa');

insert into text_param_values (language, for_object, for_attribute, text_code, text_value) values (2, 'transfer_packet', 'status', 2, 'Siirretty');

/* Foreign key column to remittance table. */

alter table remittance add column `transfer_packet_id` bigint(20) unsigned default null;

alter table remittance add KEY `transfer_packet_id_idx` (`transfer_packet_id`);

alter table remittance add CONSTRAINT `TransferPacket` FOREIGN KEY (`transfer_packet_id`) REFERENCES `transfer_packet` (`ID`) ON UPDATE CASCADE;

Since I have provided all the files necessary, even the xml to ISO20022 converter, the project will cost 55 euro and should be done today itself.

The [url removed, login to view] is showing how to write the code in codeigniter ( module) to update so a similar [url removed, login to view] file needs to be created as well in codeigniter(module) . A controller could be created just to test if everything is working.

Taidot: Codeigniter, MySQL, PHP, XML

Näytä lisää: type of data structures, structures data, new data structures, how to write well, how to write code, how to write a code in php, file status 34, data structures code, convert php to codeigniter, mysql data save xml file php, produce graph mysql data, copy mysql data file, mysql data text file sample, php save mysql data text file, create excel file mysql data, automatically load xml shopping cart data mysql, convert mysql data xml, produce graphs mysql data, uploading file mysql data uploaded

Tietoa työnantajasta:
( 9 arvostelua ) Vantaa, Finland

Projektin tunnus: #8669353

Myönnetty käyttäjälle:

chouhanashish15

Hi, We ll finish your this task perfactly and provide you work as you want all the work ll be done according to [url removed, login to view] are working in codeigniter and into YII project from the past 4 years.I have completed lots of Lisää

75 € EUR 1 päivässä
(8 arvostelua)
3.5

1 freelanceria on tarjonnut keskimäärin 75 € tähän työhön

mahesharchi

Hi Ready to start this work.. i have more then 6 year experience in this fields.. i have already worked about this skilled Joomla , Php , Open cart , Wordpress , Drupal , Javascript , cake Php , Smarty , O Lisää

149 € EUR 8 päivässä
(29 arvostelua)
4.8