WebSVN – Android Microlearning – Diff – /app/src/main/java/com/cesams/twogetskills/activity/MainActivity.java

                         userLogDao.insert(userLog);
+                    }
+                }
+            }
+            String uuid;
             Company company;
+            if(data.has("quizzes")) {
+                Quiz quiz;
+                Question question;
+                Answer answer;
             if(data.has("quizzes")) {
                 arrayQuizzes = data.getJSONArray("quizzes");
                 for (i = 0; i < arrayQuizzes.length(); i++) {
-                    objQuiz = arrayQuizzes.getJSONObject(i);
-                    Quiz quiz = new Quiz();
-                    quiz.setUuid(  objQuiz.getString("uuid"));
-                    quiz.setCompanyUuid(  objQuiz.getString("company_uuid"));
-                    quiz.setFailed(  objQuiz.getString("failed"));
-                    quiz.setName(  objQuiz.getString("name"));
-                    quiz.setText(  objQuiz.getString("text"));
-                    quiz.setPoints(  objQuiz.getInt("points"));
-                    quiz.setMinimumPointsRequired(objQuiz.getInt("minimum_points_required"));
+                    objQuiz = arrayQuizzes.getJSONObject(i);
-                    quiz.setMaxTime( objQuiz.getInt("max_time"));
                     uuid = objQuiz.getString("company_uuid");
-                    Company company = companyDao.selectByUuid(quiz.getCompanyUuid());
+                    company = companyDao.selectByUuid(uuid);
                     if (company == null) {
                         company = new Company();
                         company.setUuid(objQuiz.getString("company_uuid"));
                         company.setName(objQuiz.getString("company_name"));
+                        company.setImage(objQuiz.getString("company_image"));
+                        companyDao.insert(company);
+                    } else {
+                        company.setName(objQuiz.getString("company_name"));
                         company.setImage(objQuiz.getString("company_image"));
+                        companyDao.update(company);
+                    }
+                    uuid =  objQuiz.getString("uuid");
+                    quiz = quizDao.selectByUuid(uuid);
+                    if(quiz == null) {
+                        quiz = new Quiz();
+                        quiz.setUuid(  objQuiz.getString("uuid"));
+                        quiz.setCompanyUuid(  company.getUuid() );
+                        quiz.setFailed(  objQuiz.getString("failed"));
+                        quiz.setName(  objQuiz.getString("name"));
+                        quiz.setText(  objQuiz.getString("text"));
+                        quiz.setPoints(  objQuiz.getInt("points"));
+                        quiz.setMinimumPointsRequired(objQuiz.getInt("minimum_points_required"));
+                        quiz.setMaxTime( objQuiz.getInt("max_time"));
+                        quizDao.insert(quiz);
+                    } else {
+                        quiz.setCompanyUuid(  company.getUuid() );
+                        quiz.setFailed(  objQuiz.getString("failed"));
+                        quiz.setName(  objQuiz.getString("name"));
+                        quiz.setText(  objQuiz.getString("text"));
+                        quiz.setPoints(  objQuiz.getInt("points"));
-                        companyDao.insert(company);
+                        quiz.setMinimumPointsRequired(objQuiz.getInt("minimum_points_required"));
                         quiz.setMaxTime( objQuiz.getInt("max_time"));
                         quizDao.update(quiz);
-                    quizDao.insert(quiz);
-                    arrayQuestions = objQuiz.getJSONArray("questions");
-                    for (j = 0; j < arrayQuestions.length(); j++) {
-                        objQuestion = arrayQuestions.getJSONObject(j);
-                        Question question = new Question();
-                        question.setQuizUuid( quiz.getUuid());
+                    }
+                    arrayQuestions = objQuiz.getJSONArray("questions");
+                    for (j = 0; j < arrayQuestions.length(); j++) {
+                        objQuestion = arrayQuestions.getJSONObject(j);
+                        uuid = objQuestion.getString("uuid");
+                        question = questionDao.selectByUuid(uuid);
+                        if(question == null) {
+                            question = new Question();
+                            question.setQuizUuid( quiz.getUuid());
-                        question.setUuid( objQuestion.getString("uuid"));
+                            question.setUuid(uuid) ;
+                            question.setText( objQuestion.getString("text"));
+                            question.setType( objQuestion.getString("type"));
+                            question.setPoints( objQuestion.getInt("points"));
+                            question.setMaxlength( objQuestion.getInt("maxlength"));
+                            questionDao.insert(question);
+                        } else {
+                            question.setQuizUuid( quiz.getUuid());
+                            question.setText( objQuestion.getString("text"));
+                            question.setType( objQuestion.getString("type"));
+                            question.setPoints( objQuestion.getInt("points"));
+                            question.setMaxlength( objQuestion.getInt("maxlength"));
                         question.setText( objQuestion.getString("text"));
-                        question.setType( objQuestion.getString("type"));
+                            questionDao.update(question);
                         question.setPoints( objQuestion.getInt("points"));
-                        question.setMaxlength( objQuestion.getInt("maxlength"));
-                        questionDao.insert(question);
-                        arrayAnswers = objQuestion.getJSONArray("answers");
-                        for (x = 0; x < arrayAnswers.length(); x++) {
-                            objAnswer = arrayAnswers.getJSONObject(x);
-                            Answer answer = new Answer();
+                        arrayAnswers = objQuestion.getJSONArray("answers");
+                        for (x = 0; x < arrayAnswers.length(); x++) {
+                            objAnswer = arrayAnswers.getJSONObject(x);
+                            uuid = objAnswer.getString("uuid");
+                            answer = answerDao.selectByUuid(uuid);
+                            if(answer == null) {
+                                answer = new Answer();
+                                answer.setQuestionUuid(question.getUuid());
+                                answer.setUuid(uuid);
+                                answer.setText(objAnswer.getString("text"));
+                                answer.setPoints(objAnswer.getInt("points"));
+                                answer.setCorrect(objAnswer.getString("correct"));
                             answer.setQuestionUuid(question.getUuid());
-                            answer.setUuid(objAnswer.getString("uuid"));
+                                answerDao.insert(answer);
-                            answer.setText(objAnswer.getString("text"));
+                            } else {
-                            answer.setPoints( objAnswer.getInt("points"));
+                                answer.setQuestionUuid(question.getUuid());
+                                answer.setText(objAnswer.getString("text"));
+                                answer.setPoints(objAnswer.getInt("points"));
+                                answer.setCorrect(objAnswer.getString("correct"));
-                            answer.setCorrect(objAnswer.getString("correct"));
+                                answerDao.update(answer);
+                            }
                             answerDao.insert(answer);
-                        }
-                    }
-                }
-            }
+                    }
+                }
+            }
             if(data.has("topics")) {
                 JSONArray arrayTopics = data.getJSONArray("topics");
+            if(data.has("topics")) {
+                Topic topic;
+                Capsule capsule;
+                Slide slide;
-                for (i = 0; i < arrayTopics.length(); i++) {
+                JSONArray arrayTopics = data.getJSONArray("topics");
+                for (i = 0; i < arrayTopics.length(); i++) {
+                    objTopic = arrayTopics.getJSONObject(i);
+                    uuid = objTopic.getString("company_uuid");
+                    company = companyDao.selectByUuid(uuid);
+                    if (company == null) {
+                        company = new Company();
+                        company.setUuid(objTopic.getString("company_uuid"));
+                        company.setName(objTopic.getString("company_name"));
+                        company.setImage(objTopic.getString("company_image"));
-                    objTopic = arrayTopics.getJSONObject(i);
+                        companyDao.insert(company);
+                    } else {
+                        company.setName(objTopic.getString("company_name"));
+                        company.setImage(objTopic.getString("company_image"));
+                        companyDao.update(company);
+                    }
+                    uuid = objTopic.getString("uuid");
+                    topic = topicDao.selectByUuid(uuid);
+                    if (topic == null) {
+                        topic = new Topic();
-                    Topic topic = new Topic();
+                        topic.setUuid(uuid);
-                    topic.setUuid(objTopic.getString("uuid"));
+                        topic.setCompanyUuid(company.getUuid());
-                    topic.setCompanyUuid(objTopic.getString("company_uuid"));
+                        topic.setName(objTopic.getString("name"));
+                        topic.setDescription(objTopic.getString("description"));
+                        topic.setImage(objTopic.getString("image"));
+                        topic.setPosition(objTopic.getInt("position"));
-                    topic.setName(objTopic.getString("name"));
+                        topicDao.insert(topic);
-                    topic.setDescription(objTopic.getString("description"));
+                    } else {
+                        topic.setCompanyUuid(company.getUuid());
-                    topic.setImage(objTopic.getString("image"));
+                        topic.setName(objTopic.getString("name"));
+                        topic.setDescription(objTopic.getString("description"));
+                        topic.setImage(objTopic.getString("image"));
+                        topic.setPosition(objTopic.getInt("position"));
+                        topicDao.update(topic);
+                    }
-                    topic.setPosition(objTopic.getInt("position"));
-                    Company company = companyDao.selectByUuid(topic.getCompanyUuid());
-                    if (company == null) {
+                    arrayCapsules = objTopic.getJSONArray("capsules");
-                        company = new Company();
+                    for (j = 0; j < arrayCapsules.length(); j++) {
+                        objCapsule = arrayCapsules.getJSONObject(j);
+                        uuid = objCapsule.getString("uuid");
+                        capsule = capsuleDao.selectByUuid(uuid);
+                        if(capsule == null) {
-                        company.setUuid(objTopic.getString("company_uuid"));
+                            capsule = new Capsule();
-                        company.setName(objTopic.getString("company_name"));
+                            capsule.setTopicUuid(topic.getUuid());
-                        company.setImage(objTopic.getString("company_image"));
+                            capsule.setUuid(uuid);
-                        companyDao.insert(company);
-                    }
-                    topicDao.insert(topic);
-                    arrayCapsules = objTopic.getJSONArray("capsules");
-                    for (j = 0; j < arrayCapsules.length(); j++) {
-                        objCapsule = arrayCapsules.getJSONObject(j);
-                        Capsule capsule = new Capsule();
-                        capsule.setTopicUuid(topic.getUuid());
+                            capsule.setName(objCapsule.getString("name"));
+                            capsule.setDescription(objCapsule.getString("description"));
+                            capsule.setImage(objCapsule.getString("image"));
+                            capsule.setPosition(objCapsule.getInt("position"));
+                            capsuleDao.insert(capsule);
+                        } else {
+                            capsule = new Capsule();
+                            capsule.setTopicUuid(topic.getUuid());
+                            capsule.setName(objCapsule.getString("name"));
+                            capsule.setDescription(objCapsule.getString("description"));
+                            capsule.setImage(objCapsule.getString("image"));
+                            capsule.setPosition(objCapsule.getInt("position"));
+                            capsuleDao.update(capsule);
+                        }
-                        capsule.setUuid(objCapsule.getString("uuid"));
+                        arraySlides = objCapsule.getJSONArray("slides");
+                        for (x = 0; x < arraySlides.length(); x++) {
+                            objSlide = arraySlides.getJSONObject(x);
+                            uuid = objSlide.getString("uuid");
+                            slide = slideDao.selectByUuid(uuid);
+                            if(slide == null) {
+                                slide = new Slide();
+                                slide.setUuid(uuid);
+                                slide.setTopicUuid(capsule.getTopicUuid());
+                                slide.setCapsuleUuid(capsule.getUuid());
-                        capsule.setName(objCapsule.getString("name"));
+                                slide.setQuizUuid(objSlide.getString("quiz_uuid"));
-                        capsule.setDescription(objCapsule.getString("description"));
+                                slide.setName(objSlide.getString("name"));
-                        capsule.setImage(objCapsule.getString("image"));
+                                slide.setDescription(objSlide.getString("description"));
-                        capsule.setPosition(objCapsule.getInt("position"));
+                                slide.setPosition(objSlide.getInt("position"));
+                                slide.setType(objSlide.getString("type"));
+                                slide.setFile(objSlide.getString("file"));
+                                slide.setBackground(objSlide.getString("background"));
+                                slideDao.insert(slide);
+                            } else {
+                                slide.setTopicUuid(capsule.getTopicUuid());
+                                slide.setCapsuleUuid(capsule.getUuid());
+                                slide.setQuizUuid(objSlide.getString("quiz_uuid"));
+                                slide.setName(objSlide.getString("name"));
+                                slide.setDescription(objSlide.getString("description"));
+                                slide.setPosition(objSlide.getInt("position"));
+                                slide.setType(objSlide.getString("type"));
+                                slide.setFile(objSlide.getString("file"));
+                                slide.setBackground(objSlide.getString("background"));
+                                slideDao.update(slide);
+                            }
+                        }
+                    }
+                }
+            }
+            if(data.has( "extended")) {
+                JSONObject objExtended;
+                JSONObject objItem;
+                JSONArray objItems;
+                UserExtended userExtended;
+                JSONArray extendedCompanies = data.getJSONArray("extended");
+                for(i = 0 ; i < extendedCompanies.length(); i++)
+                {
+                    objExtended = extendedCompanies.getJSONObject(i);
+                    if(objExtended.has("details")) {
+                        uuid = objExtended.getString("company_uuid");
+                        company = companyDao.selectByUuid(uuid);
+                        if (company == null) {
+                            company = new Company();
+                            company.setUuid(objExtended.getString("company_uuid"));
+                            company.setName(objExtended.getString("company_name"));
+                            company.setImage(objExtended.getString("company_image"));
+                            companyDao.insert(company);
+                        } else {
+                            company.setName(objExtended.getString("company_name"));
+                            company.setImage(objExtended.getString("company_image"));
+                            companyDao.update(company);
+                        }
+                        objItems = objExtended.getJSONArray("details");
+                        for(j = 0 ; j < objItems.length(); j++) {
+                            objItem = objItems.getJSONObject(j);
-                        capsuleDao.insert(capsule);
+                            uuid =  objItem.getString("uuid");
-                        arraySlides = objCapsule.getJSONArray("slides");
+                            userExtended = userExtendedDao.selectByUuid(uuid);
-                        for (x = 0; x < arraySlides.length(); x++) {
+                            if(userExtended == null) {
                     preference.setCompanyUuidActive(companies.get(0).getUuid());
                 } else {
+                    boolean companyExist = false;
-                    boolean companyExist = false;
+                    for(i = 0; i < companies.size(); i++) {
                     for (Company company : companies) {
+                        if (companies.get(i).getUuid().equals(preference.getCompanyUuidActive())) {
-                        if (company.getUuid().equals(preference.getCompanyUuidActive())) {
+                            companyExist = true;
-                            companyExist = true;
+                            break;
                         }
+                    }
-                    if(!companyExist) {
+                    if(!companyExist && companies.size() > 0) {
                         preference.setCompanyUuidActive(companies.get(0).getUuid());
+                    }
+                }
-            } else {
-                preference.setCompanyUuidActive("");
-            }
-            if(data.has( "extended")) {
-                JSONObject objExtended;
-                JSONObject objItem;
-                JSONArray objItems;
-                String company_uuid;
-                UserExtended userExtended;
-                JSONArray extendedCompanies = data.getJSONArray("extended");
-                for(i = 0 ; i < extendedCompanies.length(); i++)
-                {
-                    objExtended = extendedCompanies.getJSONObject(i);
-                    if(objExtended.has("details")) {
-                        company_uuid = objExtended.getString("company_uuid");
-                        objItems = objExtended.getJSONArray("details");
-                        for(j = 0 ; j < objItems.length(); j++) {
-                            objItem = objItems.getJSONObject(j);
-                            userExtended = new UserExtended();
-                            userExtended.setCompanyUuid(company_uuid);
-                            userExtended.setUuid(objItem.getString("uuid"));
-                            userExtended.setLabel(objItem.getString("label"));
-                            userExtended.setValue(objItem.getString("value"));
-                            userExtendedDao.insert(userExtended);
             } else {
                 preference.setCompanyUuidActive("");

Proyectos de Subversion Android Microlearning

(root)/app/src/main/java/com/cesams/twogetskills/activity/MainActivity.java – Rev 33 → 43