/**
* MPE, SESCOOP
* atualiza dados da devolutiva gerada para um determinado numero de protocolo
*
* @param type $devolutivePath
* @param type $idProtocolo
* @return boolean
*/
public static function gravaPathDevolutiva($devolutivePath, $idProtocolo)
{
$db = Zend_Registry::get('db');
$sql = "UPDATE ProtocoloDevolutiva SET DevolutivePath = ? WHERE Id = ?";
$stmt = new Zend_Db_Statement_Mysqli($db, $sql);
$params = array($devolutivePath, $idProtocolo);
$stmt->execute($params);
$db->closeConnection();
return true;
}
/**
* processa execucao de procedures que calculam pontuacao a partir das
* respostas do Questionario de Empreendedorismo
*
* @param type $QuestionnaireId
* @param type $UserId
* @param type $BlockId
* @param type $CompetitionId
* @return boolean
*/
public function processaCaracteristicaEmpreendedora($QuestionnaireId, $UserId, $BlockId, $CompetitionId)
{
//forma correta
$db = Zend_Registry::get('db');
$sql = "CALL p_pontuacao_grade (?, ?, ?, ?)";
$stmt = new Zend_Db_Statement_Mysqli($db, $sql);
$params = array($QuestionnaireId, $BlockId, $UserId, $CompetitionId);
$stmt->execute($params);
//$stmt->fetch();
$db->closeConnection();
return true;
}
public function calculateScoreFromQuestionnaireAnswers($QuestionnaireId, $UserId, $BlockId, $CompetitionId)
{
//forma correta
$db = Zend_Registry::get('db');
$sql = "CALL p_pontuacao_grade (?, ?, ?, ?)";
$stmt = new Zend_Db_Statement_Mysqli($db, $sql);
$params = array($QuestionnaireId, $BlockId, $UserId, $CompetitionId);
$stmt->execute($params);
//$stmt->fetch();
$db->closeConnection();
return true;
}
