// open db connection
$cxn = mysql_connect($mcl_db_host, $mcl_db_uid, $mcl_db_pwd);
if (!$cxn) {
die('Could not connect to database: ' . mysql_error());
}
mysql_select_db($mcl_enhanced_db_name);
// New list
if ($_POST['action'] == 'new') {
// Create the new list definition
$cld = new ConceptListDefinition();
$cld->setName($list_name);
$cld->setDescription($list_description);
// create the new list
$cl = new ConceptList($cld);
foreach ($arr_concepts as $c) {
$cl->addConcept($c->concept_id);
// TODO: $cl->addConcept($c->dict_id, $c->concept_id);
}
// Commit to database
$clf = new ConceptListFactory();
$clf->setConnection($cxn);
if (!$clf->insertConceptList($cl)) {
trigger_error('Could not create list', E_USER_ERROR);
} else {
echo 'successfully created list!';
}
} elseif ($action == 'add') {
//
} elseif ($action == 'remove') {
//
} else {
/**
* Private function to load an openmrs map source.
*/
private function _loadMapSource($cld)
{
// Load the concept ids from the concept map source
$sql_concepts = 'select cm.concept_id ' . 'from ' . $dict_name . '.concept_map cm ' . 'where cm.source = ' . $cld->getListId();
$rsc_concepts = mysql_query($sql_concepts, $this->getConnection());
if (!$rsc_concepts) {
echo "could not query db in ConceptListFactory::_loadMapSource: " . mysql_error();
exit;
}
// Put the data in to the ConceptList object
$cl = new ConceptList($cld);
while ($row = mysql_fetch_assoc($rsc_concepts)) {
$_id = $row['concept_id'];
$cl->addConcept($_id);
}
return $cl;
}
