Blog and authentication to be added to an existing CRM application

Cancelado Publicado Jan 3, 2007 Pagado a la entrega
Cancelado Pagado a la entrega

We are currenty running a CRM application written in Perl+MySQL on FreeBSD managing the requests of quotes coming from the internet for one of our clients.

The perspective clients of this company submits an online, web based form to request a quotation for the services that this company provides, and the admins of this company decide (from a backoffice side of the same application) to forward this request to one or more dealers of this company (so if you ask to buy its services from the State of Louisiana, the admin of this company will probably forward your request to their Louisiana dealer, which will eventually offer you the quote.

The forwarding from this application to the dealers is done via either a simple email stating the content of the request (the output of the form submitted by the prospect client, wrapped in an email) or via a web-to-fax gateway - we use interfax.net.

All is working perfectly.

Volumes handled: some 150 dealers and 2 to 5 requests per day (very small volumes). 10 scripts, 10 db tables, the biggest of which is about 200kbytes (very small volumes indeed).

The client (this company) now requires 2 additions to this Perl+MySQL application, which could be treated as largely independently from the exisitng one (a part from point 1 below):

1 - Adding username and pass coloumns to the dealers db table so that you can build an online authentication interface for the dealers

2- Add a blog application. The dealers will have to enter a post-moderated blog, where they will be able to read and post. If they post, they will not be able to post with a freetext name: the name of the blogger will be pre-filled and fixed on the dealer name used to authenticate, example: "Dealer Industries S.r.l." which is already written in the dealer records anyway.

So no one authenticaed as "Dealer Industries S.r.l." user will then be able to use the name "Paul" for example....

3 - The company owning this application will be able to add it's own posts of course, but with more functionalities (as I state them below).

4 - We'll also have a mini-homepage of the "restricted area" (the one we access via the username/pass authentication I mentioned in section 1 above) with links to other sections.

Essentially, the dealer logins on a "welcome page" where he finds the link to the blog or other links (that I'd like to be able to customize with text and href).

Example:

-------------------------------------------------------------

WELCOME ON THE DEALERS RESERVED AREA

Access the Dealer Catalogue [LINK]

Access the Dealer's Blog [LINK]

---------------------------------------------------------------

The Blog will be a usual blog, where the company will add the news of the company and receive replies in the blog-style.

Every record added by the company (not by the dealer, just the "super admin") will include 2 special options (not required by default, as the post can be even a simple one)

a) Possible image to be uploaded (then resized/optimized by Imagemagick or similar server-side application, possibly already included in the blog scripts) in order to make their post "nicer".

b) Possible files to be listed as "downloadable attachments".

The typical example is a new made like this:

-------------------------------------------------------------

HEADLINE HEADLINE HEADLINE HEADLINE HEADLINE HEADLINE HEADLINE

body body body body body body +-----------------------------+

body body body body body body | |

body body body body body body | |

body body body body body body | IMAGE |

body body body body body body | |

body body body body body body | |

body body body body body body +-----------------------------+

body body body body body body body body body body body body |

body body body body body body body body body body body body |

body body body body body body body body body body body body |

body body body body body body body body body body body body |

body body body body body body body body body body body body |

body body body body body body body body body body body body |

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

---------------------------------------------------------------

Display mode:

View All records (in blocks of 20, with "noext/previous system to allow scrollign no subsequent pages)

View Month of MMM_YYYY

View Current Month of MMM_YYYY

(but I guess these are standard feature of any opensource, free blog program).

..........................

Any idea on how much this could cost and when it will be delivered?

Linux Perl Gestión de proyectos

Nº del proyecto: #116809

Sobre el proyecto

4 propuestas Proyecto remoto Activo Jan 16, 2007