Module.article

Repo

• Module article

Requirement

• Article
  • Operation
    • Create draft
      • Title/Sub title
      • Setting category
      • Setting channel
      • Published at fix time
      • Setting SEO
      • Setting tags
      • Inserting photos
      • Featured image ?
    • Save draft
    • Pending
    • Publish
    • Preview
  • Management
    • Searching
    • Edit article
    • Delete article
    • Active/Deactivate article
• Category
  • Operation
    • Add category
  • Management
    • Edit category
    • Delete category
    • Searching
• Homepage

Code Design

Voltan suggestion

Requirement

• Article

  • Operation
    • Create draft
      • Title/Sub title
      • Setting category
        • Multi category
      • Setting channel
        • Multi channel
      • Published at fix time
      • Setting SEO
      • Setting tags
      • Inserting photos
      • Featured image ?
      • Support Attach extra files
        • Video files : play on player under article
        • Audio files : play on player under article
        • Image files : Show as gallery under article
        • Others : download
      • Support extra fields
      • Add Tag
      • Select related articles
    • Save draft
    • Pending
    • Publish
    • Preview
  • Management
    • Searching
    • Edit article
    • Delete article
    • Active/Deactivate article

• Category

  • Operation
    • Add category
      • Set permissions
        • Read
        • Write
        • Comment
        • vote
      • Set view options
        • Select list of articles template
          • News type
          • List type
          • Table type
          • Media type
          • Spotlight type
        • Select fields
          • Show date
          • Show hits
          • Show author
          • Show topic
          • Show topic informations
          • And more
      • Set list of articles type * List of all article from topic and all sub category * List of all articles from just main category * List of all articles from just sub category
      • Set sub category
      • Set title / information / image
  • Management
    • Edit category
    • Delete category
    • Searching

• Spotlight

  • Operation
    • Add category
      • Select article
      • Select category (Show article to this category)
      • Set publish time
      • Set expire time
      • Set status
  • Management
    • Edit Spotlight
    • Delete Spotlight
    • Searching

• Extra field

  • Operation
    • Add Extra field
      • Set title
      • Set image / logo
      • Set type ('text'| | |'link'| | |'currency'| | |'date'| | |'number'| | | ?)
      • Set searchable or not
  • Management
    • Edit Extra field
    • Delete Extra field
    • Change order

• Attach

  • Operation
    • Add Attach ( Unser article or Attachment page)
  • Management
    • Edit Attach
    • Delete Attach

• Homepage

Database design

• article

name	type	property	default value	description
id	int(10)	unsigned NOT NULL auto_increment
title	varchar(255)	NOT NULL
subtitle	varchar(255)	NOT NULL
slug	varchar(255)	NOT NULL
category	varchar(255)	NOT NULL		Save as json
short	text
body	text
keywords	varchar(255)	NOT NULL
description	varchar(255)	NOT NULL
important	tinyint(1)	unsigned NOT NULL
status	tinyint(1)	unsigned NOT NULL
time_create	int(10)	unsigned NOT NULL
time_update	int(10)	unsigned NOT NULL
time_publish	int(10)	unsigned NOT NULL
author	int(10)	unsigned NOT NULL
hits	int(10)	unsigned NOT NULL
image	varchar(255)	NOT NULL
image_path	varchar(16)	NOT NULL		Make page by year/month
comments	int(10)	unsigned NOT NULL		Get information form comment module
point	int(10)	NOT NULL		Get information form vote module ( dont set unsigned )
count	int(10)	unsigned NOT NULL		Get information form vote module
favorite	int(10)	unsigned NOT NULL		Get information form favorite module
attach	tinyint(3)	unsigned NOT NULL		Count of attached files if > 0 get list
extra	tinyint(3)	unsigned NOT NULL		Count of extra fields if > 0 get list

• category

name	type	property	default value	description
id	int(10)	unsigned NOT NULL auto_increment
parent_id	int(5)	unsigned NOT NULL
title	varchar(255)	NOT NULL
slug	varchar(255)	NOT NULL
body	text
image	varchar(255)	NOT NULL
image_path	varchar(16)	NOT NULL
keywords	varchar(255)	NOT NULL
description	varchar(255)	NOT NULL
author	int(10)	unsigned NOT NULL
time_create	int(10)	unsigned NOT NULL
status	tinyint(1)	unsigned NOT NULL
inlist	tinyint(1)	unsigned NOT NULL	default '1'
topic_type	enum('module','topic') NOT NULL
topic_homepage	enum('type1','type2','type3') NOT NULL
topic_style	varchar(64)	NOT NULL
perpage	tinyint(3)	unsigned NOT NULL
columns	tinyint(3)	unsigned NOT NULL
show_topic	tinyint(1)	unsigned NOT NULL	default '1'
show_topicinfo	tinyint(1)	unsigned NOT NULL	default '1'
show_author	tinyint(1)	unsigned NOT NULL	default '1'
show_date	tinyint(1)	unsigned NOT NULL	default '1'
show_pdf	tinyint(1)	unsigned NOT NULL	default '1'
show_print	tinyint(1)	unsigned NOT NULL	default '1'
show_mail	tinyint(1)	unsigned NOT NULL	default '1'
show_nav	tinyint(1)	unsigned NOT NULL	default '1'
show_hits	tinyint(1)	unsigned NOT NULL	default '1'
show_coms	tinyint(1)	unsigned NOT NULL	default '1'