En cours

extra table order_customfields to simplecaddy for Joomla

Add an extra table order_customfields to simplecaddy ([url removed, login to view]) for joomla (Version [url removed, login to view]) . This new table is maintained from the columns in the orders table and the custom columns with the custom columns being unserialized into the new table as seperate columns.

I need someone to create a new table on the MySql database following standard naming conventions. This table to have the same columns as the standard "orders" column (***_sc_orders) with the exception of the customfields column. This table orders_customfields to also have extra seperate columns to store the unserialized contents on the customfields column. There are about 15 custom fields of various types, at least one of every type. When an order is edited (added, updated or deleted) some new code needs to copy the contents of the "orders" table into the new table (creating, updating or deleting) as appropriate. With the exception of the ***[url removed, login to view] column all columns are a one for one copy from orders to the new table. The customfields column must be unserialized using the php unserialize function and then processed to update the new table. The new table is keyed off the ID like the the "orders" table as its key as a simple 1-1 "expansion table". Things only go one way - There is never an update to the new table which is copied back into the orders table.

I would like a script to create the new table and index. The code changes should have a minimally footprint on existing programs. I will need the install process can be "manual" but is to be documented in the form of details of which changes are needed to existing files and which extra files to be added and where. This change does not need to automatically support the creation of new custom fields.

I would like a SQL script to create the new table and index. The code changes should have a minimal footprint on existing programs. The install process can be "manual" but is to document the details of which changes are needed to existing files and which extra files to be added and where. This change does not need to automatically support the creation of new custom fields.

Compétences : Joomla, MySQL, PHP

Voir plus : add function simplecaddy php, simplecaddy table, custom code joomla, creating php table, using simplecaddy joomla, simplecaddy custom fields, table, table creation, php script create table, new expansion, joomla updating, footprint, extra, update database joomla, mysql sql function, add exception, create table using, mysql create table fields, joomla fields, function order, update php joomla, change order form mysql, mysql create table, pending order deleted, add code joomla

Concernant l'employeur :
( 5 commentaires ) Stamullin, Ireland

N° du projet : #1606474

Décerné à :

aasfalcon

Can be done.

150 € EUR en 3 jours
(7 Commentaires)
4.4

7 freelance ont fait une offre moyenne de 200 € pour ce travail

epark

joomla/mysql expert.please check pm.

250 € EUR en 7 jours
(109 Commentaires)
6.7
KRodri

hello i can do this project Thanks

180 € EUR en 2 jours
(34 Commentaires)
5.5
defuz3d

Let a Joomla Professional handle this one. More in PM.

230 € EUR en 10 jours
(5 Commentaires)
3.9
Bryaninfotech

PLEASE CHECK PMB

170 € EUR en 4 jours
(0 Commentaires)
0.0
Nevaehjof

PLEASE CHECK PMB

170 € EUR en 4 jours
(0 Commentaires)
0.0
R26zfJB4Q

Pls check PMB.

250 € EUR en 1 jour
(0 Commentaires)
0.0