Customizing Customer Form & Table

[syseeker]

Hi all,

I am new to ZenCart and Php programming...

I would like to add a few column fields into Customer module, which includes Mobile Phone, Referrer Phone, IC number, status, timestamp and DOB (change to DD/MM/YYYY instead of MM/DD/YYYY). I need some clue/experience sharing on how to start on changing (where are these files/common folder to get these files)... Correct me if my preliminary investigation is wrong...

1) I guess I need to change

a) create_account.php
b) account_edit.php
c) jscript form check (to check mobile phone/IC/DOB format)

Anymore??

2) Also, I am thinking on adding a new table in DB for these columns instead of changing customer table, to ease future upgrade..

3) Admin's customer module... ... maybe i need to add in an SQL command to delete the same customer in my new table...


Regards,
Jo

[neunetllc.com]

Jo, creating a related table would be in the spirit of keeping it modular. also, datetime formatting is usually handled outside of the database, ie, it's usually stored as a numerical and not a string value, for greater flexibility. you can use the admin grep tool to search for variables related to the db values you present at the user interface...

may i ask why you want their mobile, IC contact info?

if for mobile comm, have you considered VOIP through a comm server like jabber? or were you more interested in simply pushing alerts?