/** * Refresh all questionnaire signatures */ private function refreshSignatures() { $this->auth(); $questionnaires = QuestionnaireModel::getAllQuestionnaires(); foreach ($questionnaires as $questionnaire) { $questionnaire->refreshSignature(); } QFrame_Db_Table::reset('questionnaire'); }
private function resetDatabase() { $db = Zend_Db_Table_Abstract::getDefaultAdapter(); foreach (QFrame_Db_Table::getTables() as $table) { $db->getConnection()->exec("TRUNCATE TABLE " . $table); QFrame_Db_Table::reset($table); } }
/** * Helper function for importXML. Logic specifically for rules. * * @param See importXML. */ private static function importXMLRules($questionnaireID, $instanceID, &$rulesMap, &$pageGuidMap, &$sectionGuidMap, &$questionGuidMap) { foreach ($rulesMap as $questionPromptID => $questionPromptIDArray) { foreach ($questionPromptIDArray as $name => $nameArray) { foreach ($nameArray as $targetGUID) { if ($name === 'enableQuestion') { $questionID = $questionGuidMap[$targetGUID]; if (!isset($questionID)) { throw new Exception("questionGUID referenced in XML Questionnaire Definition does not exist: {$targetID}"); } $ruleID = self::$ruleTable->insertBulk(array('questionnaireID' => $questionnaireID, 'instanceID' => $instanceID, 'sourceID' => $questionPromptID, 'targetID' => $questionID, 'targetGUID' => $targetGUID, 'type' => $name, 'enabled' => 'N')); } elseif ($name === 'enableSection') { $sectionID = $sectionGuidMap[$targetGUID]; if (!isset($sectionID)) { throw new Exception("sectionGUID referenced in XML Questionnaire Definition does not exist: {$targetID}"); } $ruleID = self::$ruleTable->insertBulk(array('questionnaireID' => $questionnaireID, 'instanceID' => $instanceID, 'sourceID' => $questionPromptID, 'targetID' => $sectionID, 'targetGUID' => $targetGUID, 'type' => $name, 'enabled' => 'N')); } elseif ($name === 'enablePage') { $pageID = $pageGuidMap[$targetGUID]; if (!isset($pageID)) { throw new Exception("pageGUID referenced in XML Questionnaire Definition does not exist: {$targetID}"); } $ruleID = self::$ruleTable->insertBulk(array('questionnaireID' => $questionnaireID, 'instanceID' => $instanceID, 'sourceID' => $questionPromptID, 'targetID' => $pageID, 'targetGUID' => $targetGUID, 'type' => $name, 'enabled' => 'N')); } elseif ($name === 'disableQuestion') { $questionID = $questionGuidMap[$targetGUID]; if (!isset($questionID)) { throw new Exception("questionGUID referenced in XML Questionnaire Definition does not exist: {$targetID}"); } $ruleID = self::$ruleTable->insertBulk(array('questionnaireID' => $questionnaireID, 'instanceID' => $instanceID, 'sourceID' => $questionPromptID, 'targetID' => $questionID, 'targetGUID' => $targetGUID, 'type' => $name, 'enabled' => 'N')); } elseif ($name === 'disableSection') { $sectionID = $sectionGuidMap[$targetGUID]; if (!isset($sectionID)) { throw new Exception("sectionGUID referenced in XML Questionnaire Definition does not exist: {$targetID}"); } $ruleID = self::$ruleTable->insertBulk(array('questionnaireID' => $questionnaireID, 'instanceID' => $instanceID, 'sourceID' => $questionPromptID, 'targetID' => $sectionID, 'targetGUID' => $targetGUID, 'type' => $name, 'enabled' => 'N')); } elseif ($name === 'disablePage') { $pageID = $pageGuidMap[$targetGUID]; if (!isset($pageID)) { throw new Exception("pageGUID referenced in XML Questionnaire Definition does not exist: {$targetID}"); } $ruleID = self::$ruleTable->insertBulk(array('questionnaireID' => $questionnaireID, 'instanceID' => $instanceID, 'sourceID' => $questionPromptID, 'targetID' => $pageID, 'targetGUID' => $targetGUID, 'type' => $name, 'enabled' => 'N')); } } } } // reset table cache as there are now new rules QFrame_Db_Table::reset('rules'); }
public static function resetAll() { $adapter = Zend_Db_Table_Abstract::getDefaultAdapter(); $tableNames = self::getTables(); foreach ($tableNames as $tableName) { QFrame_Db_Table::reset($tableName); } }