* *
* Returns an array of drug information to be used in making a match *
****************************************************************************/
// Retrieves associated data for each drug code
if (count($drugCodeArray) > 0) {
$errorReport .= "DRUG CODE SEARCH\n";
// Converts drugCodeArray into array of codes for next queries
$tempArray = array();
foreach ($drugCodeArray as $code) {
array_push($tempArray, $code['drug_code']);
}
$drugCodeArray = $tempArray;
// Establish new database connection
$db = dbConnect('hc_dpd', 'tl_vw');
// Run Query & Retrieve Results
$params = generateParams($drugCodeArray);
$comboArray = array_merge($drugCodeArray, $drugCodeArray, $drugCodeArray);
$query = "SELECT t1.drug_code, t1.active_ingredient_code, t1.ingredient, " . "t1.strength, t1.strength_unit, t2.pharmaceutical_form " . "FROM ingred t1 " . "INNER JOIN form t2 " . "ON t1.drug_code = t2.drug_code " . "WHERE t1.drug_code IN ({$params}) " . "UNION " . "SELECT t1.drug_code, t1.active_ingredient_code, t1.ingredient, " . "t1.strength, t1.strength_unit, t2.pharmaceutical_form " . "FROM ingred_ia t1 " . "INNER JOIN form_ia t2 " . "ON t1.drug_code = t2.drug_code " . "WHERE t1.drug_code IN ({$params}) " . "UNION " . "SELECT t1.drug_code, t1.active_ingredient_code, t1.ingredient, " . "t1.strength, t1.strength_unit, t2.pharmaceutical_form " . "FROM ingred_ap t1 " . "INNER JOIN form_ap t2 " . "ON t1.drug_code = t2.drug_code " . "WHERE t1.drug_code IN ({$params}) ";
$tempArray = returnResults($db, $query, $comboArray);
// Converts results into medication groups based on drug_code
if (count($tempArray) > 0) {
$resultArray = array();
// Assemble first entry
array_push($resultArray, array('drug_code' => $tempArray[0]['drug_code'], 'ingredients' => array(array('ingredient' => $tempArray[0]['ingredient'], 'ai_code' => $tempArray[0]['active_ingredient_code'], 'strength' => formatStrength($tempArray[0]['strength']), 'strength_unit' => $tempArray[0]['strength_unit'], 'dosage_form' => $tempArray[0]['pharmaceutical_form'])), 'match' => 0));
for ($i = 1; $i < count($tempArray); $i++) {
$match = false;
for ($j = 0; $j < count($resultArray); $j++) {
if ($tempArray[$i]['drug_code'] === $resultArray[$j]['drug_code']) {
array_push($resultArray[$j]['ingredients'], array('ingredient' => $tempArray[$i]['ingredient'], 'ai_code' => $tempArray[$i]['active_ingredient_code'], 'strength' => formatStrength($tempArray[$i]['strength']), 'strength_unit' => $tempArray[$i]['strength_unit'], 'dosage_form' => $tempArray[$i]['pharmaceutical_form']));
$match = true;
}
print "Nom de l'utilisateur de la base de donnee " . $color->getColoredString("[user_quizi]", "green") . ":";
$database_user = fscanf(STDIN, "%s");
if ($database_user == NULL) {
$database_user = "******";
} else {
$database_user = $database_user[0];
}
// Demande du mot de passe de la BDD
print "Mot de passe de la base de donnee " . $color->getColoredString("[password]", "green") . ":";
$database_password = fscanf(STDIN, "%s");
if ($database_password == NULL) {
$database_password = "******";
} else {
$database_password = $database_password[0];
}
generateParams($color, $database_host, $database_port, $database_name, $database_user, $database_password);
function generateParams($color, $database_host, $database_port, $database_name, $database_user, $database_password)
{
print $color->getColoredString("[database_host]", "green") . " : " . $database_host . "\n";
print $color->getColoredString("[database_port]", "green") . " : " . $database_port . "\n";
print $color->getColoredString("[database_name]", "green") . " : " . $database_name . "\n";
print $color->getColoredString("[database_user]", "green") . " : " . $database_user . "\n";
print $color->getColoredString("[database_password]", "green") . " : " . $database_password . "\n";
echo exec('rm app/config/parameters.yml');
$fp = fopen('app/config/parameters.yml', 'c');
fwrite($fp, 'parameters :' . "\n");
fwrite($fp, ' database_host: ' . $database_host . "\n");
fwrite($fp, ' database_port: ' . $database_port . "\n");
fwrite($fp, ' database_name: ' . $database_name . "\n");
fwrite($fp, ' database_user: '******' database_password: ' . $database_password . "\n");
