Jump to:

10979 Posts in 2722 Topics by 1815 members

All other Modules

SilverStripe Forums » All other Modules » "simple" module request?

Discuss all other Modules here.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 893 Views
  • feef
    Avatar
    Community Member
    19 Posts

    "simple" module request? Link to this post

    I'm VERY stuck for time, so am posting this in the hope that someone can assist.

    I am maintaining a website for a club, most of who's communications go via a mailing list. I'm wanting to create an online, browse-able archive of the message posts within the Siulverstripe site I've set up.

    I've created a PHP script which connects to the mail server, checks for new mail, and inserts it into the database...

    CREATE TABLE `Digest` (
    `idDigest` int(11) NOT NULL AUTO_INCREMENT,
    `date` timestamp NULL DEFAULT NULL,
    `To` varchar(255) DEFAULT NULL,
    `From` varchar(255) DEFAULT NULL,
    `Subject` varchar(255) DEFAULT NULL,
    `Bodytext` text,
    PRIMARY KEY (`idDigest`)
    ) ENGINE=InnoDB

    and deletes each message from the mail queue after it's been inserted into the database (I've got a dedicated mail account for the archival process)

    All I want is a simple module to take the database content and display the messages in chronological order. Today's messages on one page, and then "older" for each preceding day.

    Nice-to-have would be to make it searchable.
    "archives" by month

    Eventually, I'd also like to include the thread-id to make the relevant threads link up, but I'm not fussed about that right now.

    My PHP is rusty at best, and my time is at a premium right now
    If it comes to it, I'm willing to pay for this, if anyone's interested.

  • swaiba
    Avatar
    Forum Moderator
    1788 Posts

    Re: "simple" module request? Link to this post

    Not really needing a module - ModelAdmin will do this for you.

    Create a DataObject that matches the stuff you require storing, then add a default_sort and it'll all be hooked up.

    reference...
    http://doc.silverstripe.org/sapphire/en/reference/modeladmin
    http://www.silverstripe.org/making-a-crm-with-modeladmin-in-silverstripe-230/

  • feef
    Avatar
    Community Member
    19 Posts

    Re: "simple" module request? Link to this post

    That all seems to relate to an admin page. If the data is already populated, and I just want to display it, then how does that work? I have no admin requirements. The only thing I can imagine I could use on the admin side is a page "type" where I could create a new page, and then select "digest" from the dropdown such that it displays the digest content at the front end.

    As I said, I'm VERY pressed for time :|

    Sorry

  • swaiba
    Avatar
    Forum Moderator
    1788 Posts

    Re: "simple" module request? Link to this post

    probably best to make you email public then for responses... I'd contact some of these folks...

    http://silverstripe.org/ForumMemberProfile/show/458
    http://silverstripe.org/ForumMemberProfile/show/756
    leftandmain.com
    http://www.aabweb.co.uk/

    I still think you'd be best using a dataObject, then to show on the frontend you can then use a basic template, but if you want to out source contact some of those guys...

  • feef
    Avatar
    Community Member
    19 Posts

    Re: "simple" module request? Link to this post

    Thanks..
    I'll drop them a line

    893 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.