* * * 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");