/** * 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; }