You are here: Work Session Element Mapping, 7A > II. DJS Update of EJP system (Form name: DJSTOEJP)

II. DJS Update of EJP system (Form name: DJSTOEJP)

 

 

 

 

 

 

 

 

 

S.no

Description

Name

ID

Type

COC field type

Value

Examples

Form structure example

1

Form Type

form_type

form_type

Varchar/text

 

always "coc_response"

"coc_response"

<input type= "hidden" name= "form_type" id= "form_type" value= "coc_response">

2

Journal ID "“ j_id (internal eJP Journal ID)

j_id

j_id

Int/number

Int

23

 

<input type= "hidden" name= "j_id" id= "j_id" value= "23">

 

3

Manuscript ID ( internal eJP manuscript ID)

ms_id

ms_id

Int/number

Int

3255

 

<input type= "hidden" name= "ms_id" id= "ms_id" value= "3255">

 

4

Manuscript Revision Number

ms_rev_no

ms_rev_no

Int/number

Int

0

0

1

2

<input type= "hidden" name= "ms_rev_no" id= "ms_rev_no" value= "0">

 

5

Security time

Mtime

Mtime

Int/number

BigInt

Time()

 

<input type= "hidden" name= "mtime" id= "mtime" value= "1332298399">

 

6

Security Hash

hash

Hash

Varchar

Text(65535)

MD5 value obtained using Journal ID, Manuscript ID, Revision number, Date/time and the security string (coc). The time is the moment when the request is passed on from eJPress to COC.

 

PHP code in COC for security hash generation:

<?php

$aInputs    = array(

                                "j_id" => "23",

                                "ms_id" => "3255",

                                "ms_rev_no" => "0",

                                "mtime" => "1332768606"

                            );

 

$vInput     = implode("-",$aInputs);

 

$vSecretKey = "coc";

 

echo getSecurityToken($vInput,$vSecretKey);

 

function getSecurityToken($vInput,$vSecretKey)

{

    return hash_hmac("md5", $vInput,$vSecretKey);

}

 

?>

 

<input type= "hidden" name= "hash" id= "hash" value= "5e0f5f4161ae3f9485c31caf59b4d4ad">

 

7

URL of Formatted File

pdf_url

pdf_url

Varchar/text

Varchar(500)

sftp://ftp.coc.com/files/24/23/232342/ 2234.pdf

URL of the file location

<input type= "hidden" name= "pdf_url" id= "pdf_url" value= " sftp://ftp.coc.com/files/24/23/232342/ 2234.pdf">

8

Page Length of COC PDF

Pdf_count

Pdf_count

Float/number

Float(4,2) ( value return is only int)

7

 

<input type= "hidden" name= " Pdf_count" id= " Pdf_count" value= "7">

 

9

File Info

Files

 

 

Text(65535)

COC will return a JSON string

 

<input type='hidden' name='files' value='{

list: [

{

                        "name": "art_2324234_2234.doc",

                        "width": "1",

                        "object_id": "13422",

                        "order": "1",

            },

            {

                        "name": "fig_2324234_2234.tif",

                        "width": "1",

                        "object_id": "13423",

                        "order": "2",

            },

            {

                        "name": "fig_2324234_2235.tif",

                        "width": "1.5",

                        "object_id": "13424",

                        "order": "3",

 

            },

            {

                        "name": "table_2324234_2235.tif",

                        "object_id": "13426,"

                        "order": "4",

 

            },

            {

                        "name": "supp_2324234_2235.tif",

                        "object_id": "133424",

                        "order": "5",

            }

 

]}'>

10

Status of process

status

status

Int/number

Int

1= complete

            2= pending

            3=not found

            4=error; reprocess from the start

 

1

2

3

4

 

<input type= "hidden" name= "status" id= "status" value= "1">