looking at the encounter.inc
i assume this is where the encounter is made…
but it looks to me like $enc is a date function $enc = date("Ymd");
I had assumed my encounter would therefore be a date yet its just an incrementing integer by looks of the database.
how does it become an integer when it started out as $enc = date("Ymd");
…
$encounter=$enc;
function setencounter($enc) {
$return_val = 1;
global $encounter;
global $pid;
if ($enc == “” ) {
$enc = date(“Ymd”);
if (getFormByEncounter($pid,$enc)) {
//there is an encounter enterred for today
} else {
//addForm($enc, “New Patient Encounter”, 0, $pid, 1);
$return_val = 0;
}
}
$_SESSION[‘encounter’]=$enc;
$encounter=$enc;
//returns 1 on successful global set, or 0 if there was no
//current encounter, signifying that the interface should load
//the screen for a new encounter
return $return_val;
}
check this out from openemr/interface/forms/newpatient/save.php
which is where new encounters are created…
if ($mode == ‘new’)
{
$encounter = $conn->GenID(“sequences”);
addForm($encounter, “New Patient Encounter”,
sqlInsert("INSERT INTO form_encounter SET " .
"date = ‘$date’, " .
"onset_date = ‘$onset_date’, " .
"reason = ‘$reason’, " .
"facility = ‘$facility’, " .
"pid = ‘$pid’, " .
“encounter = ‘$encounter’”),
“newpatient”, $pid, $userauthorized, $date);
}
else if ($mode == ‘update’)
{
$id = $_REQUEST[‘id’];
$result = sqlQuery(“SELECT encounter FROM form_encounter WHERE id = ‘$id’”);
$encounter = $result[‘encounter’];
// See view.php to allow or disallow updates of the encounter date.
// $datepart = $_POST[“day”] ? "date = ‘$date’, " : “”;
$datepart = acl_check(‘encounters’, ‘date_a’) ? "date = ‘$date’, " : “”;
$id = $_POST[“id”];
sqlStatement("update form_encounter set " .
$datepart .
"onset_date = ‘$onset_date’, " .
"reason = ‘$reason’, " .
"facility = ‘$facility’ " .
“where id = ‘$id’”);
}
setencounter($encounter);
*****************************************
I did not track down what
$encounter = $conn->GenID("sequences");
does, but it looks like that’s where the number comes from. Note in the code you quoted above, if setencounter gets an argument, it does not set $encounter to the date.
Are you using grep to track stuff down? using it with the -irn options is very helpful.
you were right the genid() is a function of the database connection driver.
/interface/main/calendar/pnadodb/docs-adodb.htm
GenID($seqName = ‘adodbseq’,$startID=1)
Generate a sequence number . Works for interbase, mysql, postgresql, oci8, oci8po, mssql, ODBC based (access,vfp,db2,etc) drivers currently. Uses $seqName as the name of the sequence. GenID() will automatically create the sequence for you if it does not exist (provided the userid has permission to do so). Otherwise you will have to create the sequence yourself.
If your database driver emulates sequences, the name of the table is the sequence name. The table has one column, "id" which should be of type integer, or if you need something larger - numeric(16).
For ODBC and databases that do not support sequences natively (eg mssql, mysql), we create a table for each sequence. If the sequence has not been defined earlier, it is created with the starting value set in $startID.
Note that the mssql driver’s GenID() before 1.90 used to generate 16 byte GUID’s.