hello,
i am able to do the following points :-
php crm application
- bootstap based neat looking UI
- crm works with 2 mysql database (wordpress & crmdb)
- crm login (connect to wordpress database to authenticate)
customer list page (search on all columns) tablename: customers
- customer view page
- crud for customer
- customer extra table (columns gpslocation,serverinfo,environmentinfo,contactinfo,tags)
role: support
- customer extra columns (licenseinfo, warrantyenddate, amcenddate, podate, poinfo, poamount, currentamount, amcamount, amcduedays, rankcalc, rankset)
role: administrator
tablename: customer_notes
- crud columns (noteid, customerid, notedate, notetype, description, amount, status, modifiedby, modifieddate)
- notetype: dropdown (Notes, PO, AMC, PPM Visit, Transfer, Others)
tablename: install_keys
install key list page
- crud, install key for each site (installid, customerid, updatekey (license key), validfromdate, validtodate, description, modifieddate, modifiedby)
license creation
- generate license file in using private key (key:value)
ping me once for a discussion.
surbhi