Find Jobs
Hire Freelancers

Articles database

$100-500 USD

Completed
Posted almost 20 years ago

$100-500 USD

Paid on delivery
Our client is a small publisher/newspaper. The newspaper publishes articles on the website. Check out the existing site of our client at [[login to view URL]][1] This site will be changed. The new version of the site will not be based on PHP. Instead it will be based on the Content Management System [login to view URL] which is programmed in Classic ASP/VBS. Your task is to program a new article database in Classic ASP/VBS (NOT ASP.NET and NOT .DLL!!!) using an MS Access database. This involves programming the entire backend/administration for articles as well as classes/functions, which we can use to integrate the system in SEEEMS.CMS. In other words classes, which enable us to set filter criteria for searches, get a search result and easily retrieve information/content of the articles in the search result. ## Deliverables SEE ALSO enclosed file 1) Database tables T_PUBLICATIONS f_key_publication f_str_publication_name T_SUBJECTS f_key_subject f_str_subject_text f_int_subject_order f_bln_subject_hide_option T_ARTICLES f_key_article f_key_publication f_key_subject f_date f_str_city f_str_heading f_str_subheading f_str_lead f_str_mainbody f_str_author f_str_authoremail f_str_imagefilename1 f_str_imagetitel1 f_str_imagephotographer1 f_str_imagetext1 f_str_imagefilename2 f_str_imagetitel2 f_str_imagephotographer2 f_str_imagetext2 2) Interface to do a search and to retrieve the result of the search. Class: clsArticleSearch Filter properties: - article id - publication key - searchString (search in heading, subheading, lead, main body, image title, image text etc.) - author - subject - city - fromDate and toDate - weekAndYear - orderCriteria1 and orderCriteria2 - orderDirection1 and orderDirection2 - resultsPerPage - page - totalNumOfArticles (read only) Method: - getArticles 3) Administration of the articles The layout should resemble/use the styles of SEEEMS.CMS. All captions are stored only one place in the code as variables. That way we can change the language to Danish and German. User access to the administration depends on the following two session parameters. - Session("article_publicationKey") - Session("article_administratorRights") If Session("article_publicationKey") = -1, the user can see all publications including the unique key and information on the total number of articles for each publication If Session("article_publicationKey") points to a non existing publication key (f_key_publication), access to the administration is denied. If Session("article_publicationKey") > 0, the user can only see the publication with that specific key Administration of T_PUBLICATIONS: The user can rename the publication(s) If Session("article_administratorRights ") = True, the user also can do the following: - The user can add a new publication - The user can delete a publication ? (all corresponding articles in T_ARTICLES are deleted at the same time as well as all images of those articles) For each publication the user can add, edit and delete articles. Al navigation to find existing articles will be done using the search articles class. In other words a search form is provided to find specific articles. The form for the article contains a field for each field in the database. The subject for the article is chosen from a select list. The options of the select list are those defined in T_SUBJECTS and are displayed in the order defined for the subjects (f_int_subject_order). Options where f_bln_subject_hide_option = True are not displayed in the select. Each article can also contain two images that are saved in a separate articleImage folder using the component AspUpload and/or ApsSmartUpload, while the name of the file is stored in the database. If Session("article_administratorRights ") = True, the user has access to the administration of T_SUBJECTS: - The user can see all subjects - The user can change the order of the subjects - The user can add a new subject - The user can delete a subject, provided the subject is not used in any article - The user can hide a subject Administration methods/functions which we also need to access directly from [login to view URL]: AddPublication(name) This method adds a new publication in T_PUBLICATIONS, saves the name and returns the unique key of the publication. DeletePublication(key) This method deletes the publication that has the key provided. It also deletes all corresponding articles as well as any images used in these articles. ## Platform Server side - IIS - Classic ASP - AspUpload Client side - Crossbrowser
Project ID: 3243977

About the project

13 proposals
Remote project
Active 20 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$127.50 USD in 39 days
4.6 (23 reviews)
4.6
4.6
13 freelancers are bidding on average $344 USD for this job
User Avatar
See private message.
$170 USD in 39 days
5.0 (53 reviews)
5.8
5.8
User Avatar
See private message.
$306 USD in 39 days
3.5 (4 reviews)
5.2
5.2
User Avatar
See private message.
$470.05 USD in 39 days
4.5 (26 reviews)
4.8
4.8
User Avatar
See private message.
$170 USD in 39 days
5.0 (11 reviews)
3.6
3.6
User Avatar
See private message.
$340 USD in 39 days
5.0 (5 reviews)
2.7
2.7
User Avatar
See private message.
$85 USD in 39 days
0.5 (2 reviews)
1.6
1.6
User Avatar
See private message.
$1,275 USD in 39 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$425 USD in 39 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$425 USD in 39 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$361.25 USD in 39 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$148.75 USD in 39 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$170 USD in 39 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of DENMARK
Denmark
0.0
0
Member since Jun 12, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.