/* SQL without C++:
SELECT id, last, first, full_name, active
FROM prescribers
WHERE active = 1
ORDER BY last, first;
SELECT id, last, first, initials, active
FROM pharmacists
WHERE active = 1
ORDER BY last, first;
*/
bool Prescription_01::initCustom()
{
QSqlQuery model; // Contains the query
AlertInterface alert;
PrescriberRecord *presTemp;
PharmacistRecord *pharmTemp;
int i; // Increment var
model.prepare("SELECT id, last, first, full_name, active "
"FROM prescribers "
"WHERE active = 1 "
"ORDER BY last, first;");
if (!alert.attemptQuery(&model)) {
return false;
}
for (i = 0; i < model.size(); i++) {
model.next();
presTemp = new PrescriberRecord;
presTemp->setId(model.value(0).toInt());
presTemp->setLast(model.value(1).toString());
presTemp->setFirst(model.value(2).toString());
presTemp->setFull_name(model.value(3).toString());
presTemp->setActive(model.value(4).toBool());
prescribers.append(presTemp);
}
model.prepare("SELECT id, last, first, initials, active "
"FROM pharmacists "
"WHERE active = 1 "
"ORDER BY last, first;");
if (!alert.attemptQuery(&model)) {
deleteLists();
return false;
}
for (i = 0; i < model.size(); i++) {
model.next();
pharmTemp = new PharmacistRecord;
pharmTemp->setId(model.value(0).toInt());
pharmTemp->setLast(model.value(1).toString());
pharmTemp->setFirst(model.value(2).toString());
pharmTemp->setInitials(model.value(3).toString());
pharmTemp->setActive(model.value(4).toBool());
pharmacists.append(pharmTemp);
}
setupComboBoxes();
return true;
}
void MainWindow::on_dropSpreadAbilites_pressed()
{
clearBox(ui->comboBoxStrength);
clearBox(ui->comboBoxDexterity);
clearBox(ui->comboBoxConstitution);
clearBox(ui->comboBoxIntelligence);
clearBox(ui->comboBoxWisdom);
clearBox(ui->comboBoxCharisma);
listOfCandidatsToBecomeAbility = trueListOfCandidatsToBecomeAbility;
setupComboBoxes(ui->comboBoxStrength, &listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxDexterity, &listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxConstitution, &listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxIntelligence, &listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxWisdom, &listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxCharisma, &listOfCandidatsToBecomeAbility);
}
void MainWindow::on_calculatesCandidateToBecomeAbility_pressed()
{
// Character heroTemplate(0, 0, 0, 0, 0, 0);
setupAbilites(ui->labelCandidatToBecomeAbility1, ui->labelCandidatToBecomeAbility1Modifier);
setupAbilites(ui->labelCandidatToBecomeAbility2, ui->labelCandidatToBecomeAbility2Modifier);
setupAbilites(ui->labelCandidatToBecomeAbility3, ui->labelCandidatToBecomeAbility3Modifier);
setupAbilites(ui->labelCandidatToBecomeAbility4, ui->labelCandidatToBecomeAbility4Modifier);
setupAbilites(ui->labelCandidatToBecomeAbility5, ui->labelCandidatToBecomeAbility5Modifier);
setupAbilites(ui->labelCandidatToBecomeAbility6, ui->labelCandidatToBecomeAbility6Modifier);
listOfCandidatsToBecomeAbility << "" << ui->labelCandidatToBecomeAbility1->text() <<
ui->labelCandidatToBecomeAbility2->text() <<
ui->labelCandidatToBecomeAbility3->text() <<
ui->labelCandidatToBecomeAbility4->text() <<
ui->labelCandidatToBecomeAbility5->text() <<
ui->labelCandidatToBecomeAbility6->text();
trueListOfCandidatsToBecomeAbility = listOfCandidatsToBecomeAbility;
if (checkForLowerAbility(ui->labelCandidatToBecomeAbility1, ui->labelCandidatToBecomeAbility2,
ui->labelCandidatToBecomeAbility3, ui->labelCandidatToBecomeAbility4,
ui->labelCandidatToBecomeAbility5, ui->labelCandidatToBecomeAbility6)){
ui->calculatesCandidateToBecomeAbility
->setText(youAbilityHighEnough);
ui->calculatesCandidateToBecomeAbility->setEnabled(false);
}
setupComboBoxes(ui->comboBoxStrength, & listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxDexterity, & listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxConstitution, & listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxIntelligence, & listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxWisdom, & listOfCandidatsToBecomeAbility);
setupComboBoxes(ui->comboBoxCharisma, & listOfCandidatsToBecomeAbility);
}
