Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »


Problem Statement :

Course Creator should be able to attach more than one certificate template to a course so that users receive different certificates based on the defined filter criteria for each template. The creator should also be able to delete one or more certificate templates from the course. After addition or deletion of certificates, the course creator should also be able to view the list the certificate templates attached to a particular course.

SB-14845 - Getting issue details... STATUS

Solution Approach :

1. Add Certificate Template 

       API Specification : API should take the course id , certificate name and the metadata of the certificate template which has to be attached for that particular course. Course creator can add new certificate template to the course by specifying  the filter criteria for issuing the certificate, in the filters field of the API as well as add weight to each certificate template.Weight field will ensure that only one certificate is issued to a particular user. The filters and weight field will be added as a new entry in the metadata of the certificate.


2. Delete Certificate Template

       API Specification : API should take the course details and  name of the certificate which the course creator wants to delete. 

3. Get Certificate Template

       API Specification : API should take the course details and return the list of certificate templates attached to the course.

Table Structure

Certificate templates would be stored in Cassandra table. Below is the table structure with details of each column


certificate_templates

CREATE TABLE IF NOT EXISTS sunbird_courses.certificate_templates (
  courseid text,  // course id
  batchid text,   // batch id, empty if template is applicable for all the course batches
  certificatename text,  // name of the certificate template
  template text,  // template metadata as a string, contains issuer, signatory and other information
  filters text,  // filters for the certificate
  addedby text,  // user id
  lastupdatedon timestamp, // timestamp of certificate update
  PRIMARY KEY (courseid, batchid, certificatename)
);



API Design :

  • Add Certificate Template API

    POST /course/batch/cert/v1/template

Request :      
           {
             "params": {},
             "request": {
                 "courseId": "do_12347787978775440",
                 "certificateName":"100PercentCompletionCertificate",
                 "metadata": {
                   "weight":1,       // For providing weight to a certificate template in order to avoid issue of more than one certificate
                   "issuer": {
                      "name": "Gujarat Council of Educational Research and Training",
                      "url": "https://gcert.gujarat.gov.in/gcert/",
                      "publicKey": [
                              "7",
                              "8"
                              ]
                          },
                  "signatoryList": [
                         {
                         "name": "CEO Gujarat",
                         "id": "CEO",
                         "designation": "CEO",
                         "image": "https://cdn.pixabay.com/photo/2014/11/09/08/06/signature-523237__340.jpg"
                         }
                     ],
                "keys": {
                    "id": "9"
                  },
               "htmlTemplate": "https://drive.google.com/uc?authuser=1&id=1ryB71i0Oqn2c3aqf9N6Lwvet-MZKytoM&export=download",
               "notifyTemplate": {
                   "subject": "Course completion certificate for Course 03092019 Course",
                   "stateImgUrl": "https://sunbirddev.blob.core.windows.net/orgemailtemplate/img/File-0128212938260643843.png",
                   "regardsperson": "Chairperson",
                   "regards": "Minister of Gujarat",
                   "emailTemplateType": "defaultCertTemp"
                },
               "filters": {
                  "status": "2",
                  "assessmentScore": {
                      "<": "0.8"
                  }    
              }
         }
      }
   }

  • Delete  Certificate Template API

    DELETE  /course/batch/cert/v1/template

Request : 
                   {
                     "params": { },
                     "request":{
                             "courseId": "do_12347787978775440",
                             "certificateName": "Merit-Certificate"
                           }
                   }


                 

  • Get Certificate API

    GET  /course/batch/cert/v1/template/:courseId

      

      

  • No labels