1(self.webpackChunksqlitelearn=self.webpackChunksqlitelearn||[]).push([[111],{6299:function(e,t,i){(e.exports=i(9252)(!1)).push([e.id,'#noQuestions{margin:10px;background-color:var(--dropdown-bg-color);border-radius:10px;padding:10px;color:var(--main-text-color);border:1px solid var(--border-shade)}.question-completed{border-radius:8px;background-color:var(--question-green-color);border:2px solid var(--question-green-shade)}.question-completed,.question-skipped{display:inline-block;padding:3px;margin:3px;font-variant:all-small-caps;font-family:sans-serif;float:right}.question-skipped{border-radius:8px;background-color:var(--question-yellow-color);border:2px solid var(--question-yellow-shade)}.question-incompleted{border-radius:8px;background-color:var(--question-red-color);border:2px solid var(--question-red-shade);font-variant:all-small-caps;font-family:sans-serif;float:right}.question-difficulty,.question-incompleted{display:inline-block;padding:3px;margin:3px}.question-difficulty{border-radius:8px}.question-difficulty-easy{background-color:var(--question-green-color);border:2px solid var(--question-green-shade);font-variant:all-small-caps;font-family:sans-serif}.question-difficulty-medium{background-color:var(--question-yellow-color);border:2px solid var(--question-yellow-shade);font-variant:all-small-caps;font-family:sans-serif}.question-difficulty-hard{background-color:var(--question-red-color);border:2px solid var(--question-red-shade);font-variant:all-small-caps;font-family:sans-serif}.question-info{background-color:var(--question-selection-header-color)}.question-container{border-radius:5px;box-sizing:border-box;margin:7px;border:1px solid var(--border-shade);overflow:hidden;cursor:pointer}.question-container:hover .question-body{background-color:var(--question-selection-background-hover-color)}.question-body{color:var(--main-full-text-color);background-color:var(--question-selection-background-color);border-top:1px solid gray;padding-left:4px;padding-top:4px;padding-bottom:4px}.scroll-body{overflow-y:scroll;max-height:70vh}.center-margin{margin-left:auto;margin-right:auto}.center-text{text-align:center}.selection-main-body-style{max-height:90%;margin-top:50px;background-color:var(--bg-panel-color);border-radius:5px;border:1px solid var(--border-shade)}.inner{margin-left:auto;margin-right:auto;max-width:600px}.selection-title{color:var(--main-text-color)!important}.filter-position{position:fixed;top:0;transform:translateY(50px) translateX(610px);pointer-events:none}.filter-title{color:var(--main-text-color)!important;text-align:center}.filter-header{background-color:var(--bg-panel-color);border-radius:5px;border:1px solid var(--border-shade);border-bottom-left-radius:0;border-bottom-right-radius:0;pointer-events:auto}.filter-container{display:grid;grid-template-columns:1fr 1fr 1fr 1fr;grid-template-rows:20px 1fr;gap:3px 5px;grid-auto-flow:row;grid-template-areas:"filter-title-grid-box filter-title-grid-box filter-title-grid-box filter-title-grid-box" "keyword-grid-box difficulty-grid-box completed-grid-box database-grid-box"}.filter-title-grid-box{grid-area:filter-title-grid-box}.keyword-grid-box{grid-area:keyword-grid-box}.difficulty-grid-box{grid-area:difficulty-grid-box}.completed-grid-box{grid-area:completed-grid-box}.database-grid-box{grid-area:database-grid-box}.grid-inner-container{background-color:var(--bg-panel-color);border-radius:5px;border:1px solid var(--border-shade);pointer-events:auto;border-top-left-radius:0;border-top-right-radius:0}.filter-button{border-radius:3px;margin:3px;padding:1px;text-align:center}.filter-selected{background-color:var(--question-selection-header-color)!important;color:#fff!important;border:1px solid var(--border-shade)!important}.filter-container>div>hr{display:none}@media screen and (max-width:1375px){.selection-main-body-style{margin-top:0;display:grid;grid-template-rows:87px 1fr 240px;height:calc(100vh - 60px);grid-gap:10px;background-color:transparent;border:0 solid #000;padding-top:30px;padding-bottom:30px}.filter-container>div>hr{display:block}.selection-main-body-style>div{background-color:var(--bg-panel-color);border:2px solid var(--border-shade);border-radius:16px;overflow:hidden}#selectQuestionFilter{position:static;transform:none}#selectQuestionBody{max-height:none;overflow-y:scroll}.filter-button{border:1px solid var(--border-shade);border-radius:3px;background-color:var(--bg-button-color);margin:1px;padding:3px;text-align:center;cursor:pointer;color:var(--main-full-text-color)}.filter-button,.filter-title{display:inline-block}.grid-inner-container{background-color:var(--bg-panel-color);pointer-events:auto;border-radius:0;border:0 solid #000;display:grid;grid-template-columns:96px 1fr}.filter-container{display:initial}.filter-header{display:block;border:0 solid #000;border-radius:0}}',""])},8595:function(e,t,i){"use strict";i.r(t),i.d(t,{default:function(){return s}});var r=i(243),o={components:{},data:function(){return{questionConfig:[],questionsSolved:[],selectedKeywordFilter:"ALL",selectedDifficultyFilter:"ALL",selectedCompletedFilter:"ALL",selectedDatabaseFilter:"Hospital",keywordFilterList:["ALL","Case","Distinct","Group By","Having","In","Join","Like","Null","Union","Where","Count","Avg","Sum","Max","Min"],difficultyFilterList:["ALL","Easy","Medium","Hard"],completedFilterList:["ALL","Incomplete","Complete"],databaseFilterList:["Hospital","Northwind"]}},mounted:function(){this.questionConfig=r.Z,this.questionsSolved=this.$store.getters.questionsSolved();var e=this.$store.getters.filterState;this.selectedKeywordFilter=e.selectedKeywordFilter,this.selectedDifficultyFilter=e.selectedDifficultyFilter,this.selectedCompletedFilter=e.selectedCompletedFilter,this.selectedDatabaseFilter=e.selectedDatabaseFilter||"Hospital"},methods:{questionListFilter:function(){var e=this,t=[];return null!=this.questionConfig.questionList&&(t=this.questionConfig.questionList),t.filter((function(t){return function(t){if("ALL"==e.selectedKeywordFilter)return!0;var i=e.selectedKeywordFilter.toLowerCase();return t.find((function(e){return e.toLowerCase()===i}))}(t.keywordsUsed)&&(o=t.mode,"ALL"==e.selectedDifficultyFilter||e.selectedDifficultyFilter.toLowerCase()===o)&&(r=t.id,"ALL"==e.selectedCompletedFilter||!(!e.hasCompletedId(r)||"Complete"!=e.selectedCompletedFilter)||!e.hasCompletedId(r)&&"Incomplete"==e.selectedCompletedFilter)&&(i=t.database,e.selectedDatabaseFilter.toLowerCase()==i);var i,r,o}))},questionSelected:function(e){this.$root.$emit("load-question",e),this.$root.$emit("open-page-no-history","/",!1,!0);var t=this.questionsSolved.find((function(t){return t.id==e.id}));t&&t.userSolution&&(console.log(t,t.userSolution),this.$root.$emit("set-query-text",t.userSolution))},hasCompletedId:function(e){var t=this.questionsSolved.find((function(t){return t.id==e}));return!!t&&(!(!t||0!=t.skipped)||(!t||1!=t.skipped)&&void 0)},hasSkippedId:function(e){var t=this.questionsSolved.find((function(t){return t.id==e}));return!!t&&(!(!t||1!=t.skipped)||(!t||0!=t.skipped)&&void 0)},selectedKeywordFilterClick:function(e){this.selectedKeywordFilter=e,this.$store.commit("setFilterState",{selectedKeywordFilter:this.selectedKeywordFilter,selectedDifficultyFilter:this.selectedDifficultyFilter,selectedCompletedFilter:this.selectedCompletedFilter,selectedDatabaseFilter:this.selectedDatabaseFilter})},selectedDifficultyFilterClick:function(e){this.selectedDifficultyFilter=e,this.$store.commit("setFilterState",{selectedKeywordFilter:this.selectedKeywordFilter,selectedDifficultyFilter:this.selectedDifficultyFilter,selectedCompletedFilter:this.selectedCompletedFilter,selectedDatabaseFilter:this.selectedDatabaseFilter})},selectedCompletedFilterClick:function(e){this.selectedCompletedFilter=e,this.$store.commit("setFilterState",{selectedKeywordFilter:this.selectedKeywordFilter,selectedDifficultyFilter:this.selectedDifficultyFilter,selectedCompletedFilter:this.selectedCompletedFilter,selectedDatabaseFilter:this.selectedDatabaseFilter})},selectedDatabaseFilterClick:function(e){this.selectedDatabaseFilter=e,this.$store.commit("setFilterState",{selectedKeywordFilter:this.selectedKeywordFilter,selectedDifficultyFilter:this.selectedDifficultyFilter,selectedCompletedFilter:this.selectedCompletedFilter,selectedDatabaseFilter:this.selectedDatabaseFilter})}}};var l=function(e){i(4942)},s=(0,i(2236).Z)(o,(function(){var e=this,t=e.$createElement,i=e._self._c||t;return i("div",{staticClass:"inner selection-main-body-style"},[e._m(0),e._v(" "),i("div",{staticClass:"scroll-body",attrs:{id:"selectQuestionBody"}},[e.questionListFilter().length>0?i("div",e._l(e.questionListFilter(),(function(t){return i("div",{key:t.id,staticClass:"question-container ignore-darkmode",on:{click:function(i){return e.questionSelected(t)}}},[i("div",{staticClass:"question-info"},[i("div",{class:"question-difficulty question-difficulty-"+t.mode},[e._v("\n "+e._s(t.mode)+"\n ")]),e._v(" "),e.hasCompletedId(t.id)?i("div",{staticClass:"question-completed"},[e._v("\n completed\n ")]):e.hasSkippedId(t.id)?i("div",{staticClass:"question-skipped"},[e._v("\n skipped\n ")]):i("div",{staticClass:"question-incompleted"},[e._v("incomplete")])]),e._v(" "),i("div",{staticClass:"question-body",domProps:{innerHTML:e._s(t.question)}})])})),0):i("div",[i("div",{attrs:{id:"noQuestions"}},[e._v("\n There are no questions for your filters. Consider helping the site by\n "),i("modal-a",{attrs:{href:"/question_form/"}},[e._v("submitting a new question to be solved.")])],1)])]),e._v(" "),i("div",{staticClass:"filter-list-main filter-position",attrs:{id:"selectQuestionFilter"}},[i("div",{staticClass:"filter-container"},[e._m(1),e._v(" "),i("div",{staticClass:"keyword-grid-box"},[i("div",{staticClass:"grid-inner-container"},[i("div",{staticClass:"filter-title"},[e._v("Keywords")]),e._v(" "),i("div",e._l(e.keywordFilterList,(function(t){return i("div",{key:t,staticClass:"filter-button button",class:{"filter-selected":t===e.selectedKeywordFilter},on:{click:function(i){return e.selectedKeywordFilterClick(t)}}},[e._v("\n "+e._s(t)+"\n ")])})),0)]),e._v(" "),i("hr")]),e._v(" "),i("div",{staticClass:"difficulty-grid-box"},[i("div",{staticClass:"grid-inner-container"},[i("div",{staticClass:"filter-title"},[e._v("Difficulty")]),e._v(" "),i("div",e._l(e.difficultyFilterList,(function(t){return i("div",{key:t,staticClass:"filter-button button",class:{"filter-selected":t===e.selectedDifficultyFilter},on:{click:function(i){return e.selectedDifficultyFilterClick(t)}}},[e._v("\n "+e._s(t)+"\n ")])})),0)]),e._v(" "),i("hr")]),e._v(" "),i("div",{staticClass:"completed-grid-box"},[i("div",{staticClass:"grid-inner-container"},[i("div",{staticClass:"filter-title"},[e._v("Completion")]),e._v(" "),i("div",e._l(e.completedFilterList,(function(t){return i("div",{key:t,staticClass:"filter-button button",class:{"filter-selected":t===e.selectedCompletedFilter},on:{click:function(i){return e.selectedCompletedFilterClick(t)}}},[e._v("\n "+e._s(t)+"\n ")])})),0)]),e._v(" "),i("hr")]),e._v(" "),i("div",{staticClass:"database-grid-box"},[i("div",{staticClass:"grid-inner-container"},[i("div",{staticClass:"filter-title"},[e._v("Database")]),e._v(" "),i("div",e._l(e.databaseFilterList,(function(t){return i("div",{key:t,staticClass:"filter-button button",class:{"filter-selected":t===e.selectedDatabaseFilter},on:{click:function(i){return e.selectedDatabaseFilterClick(t)}}},[e._v("\n "+e._s(t)+"\n ")])})),0)])])])])])}),[function(){var e=this,t=e.$createElement,i=e._self._c||t;return i("div",{attrs:{id:"selectQuestionHead"}},[i("h1",{staticClass:"center-text selection-title"},[e._v("Question Selection")]),e._v(" "),i("hr",{staticStyle:{margin:"0"}})])},function(){var e=this,t=e.$createElement,i=e._self._c||t;return i("div",{staticClass:"filter-title-grid-box"},[i("div",{staticClass:"filter-title filter-header"},[e._v("Filters")])])}],!1,l,null,null).exports},4942:function(e,t,i){var r=i(6299);r.__esModule&&(r=r.default),"string"==typeof r&&(r=[[e.id,r,""]]),r.locals&&(e.exports=r.locals);(0,i(5346).Z)("11691ffe",r,!0,{})}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.