MySkillsBank: 2016

SELECT * FROM 
(
Select
 d.student_id as d_student_id,
  d.gold as d_gold,
  d.total_question_consume as   d_total_question_consume,
  d.total_question_correct as d_total_question_correct
from osem_main.usr_student_data_main d 
/*WHERE d.student_id not in (4,5,22,47,49,55,79,84,85,2001,2002,2007,2021) */
) as md
join
(
SELECT c.student_id as c_student_id, count(*) as c_total_consume, sum(c.final_result) as c_total_correct 
from osem_content.qst_student_consumption c 
/*where c.student_id not in (4,5,22,47,49,55,79,84,85,2001,2002,2007,2021)*/
group by c.student_id
) as cd
ON md.d_student_id = cd.c_student_id
;

update osem_main.usr_student_main set is_reviewer=1 where login_id
in
('syazwi','awieer','quzaimer2016','hanania',
'alisa613','kindaichi',
'nazshahsalim','ainanie19','imran3087','kkkkkkkk','nazuhan87',
'osmanawang','azimazahar3','mustafakamal','aliffhafiy',
'imran3086','dinsiputsedut','ismahadi',
'abubakar','hahahaha','aqib21',
'nazshah','reez26','aqib20','langbuana','imran3088','imran3089',
'aqib21','amalina','reezh26','lalala', 'ajilala','aqib1234', 'ejoy12',
'azimazahar3','sabrina88',
 'hanania',
 'dinsiputsedut',
 'imran3086',
  'ainanie19',
 'juhari',
 'osmanawang',
 'imranhamzah','jijiji','susususu',
'Otobot','juhari','joejoejoe','radzeen','jjjjjj','alifdanishazmi');

select group_concat(student_id) from osem_main.usr_student_main m where m.is_reviewer=1;

Thursday, December 15, 2016

MySQL to get total question reviewed per chapter

SELECT s.chapter_id, 
CASE
 WHEN s.eduyear_id=1 THEN 'Darjah 1'
 WHEN s.eduyear_id=2 THEN 'Darjah 2'
 WHEN s.eduyear_id=3 THEN 'Darjah 3'
 WHEN s.eduyear_id=4 THEN 'Darjah 4'
 WHEN s.eduyear_id=5 THEN 'Darjah 5'
 WHEN s.eduyear_id=6 THEN 'Darjah 6'
 WHEN s.eduyear_id=7 THEN 'Tingkatan 1'
 WHEN s.eduyear_id=8 THEN 'Tingkatan 2'
 WHEN s.eduyear_id=9 THEN 'Tingkatan 3'
 WHEN s.eduyear_id=10 THEN 'Tingkatan 4'
 WHEN s.eduyear_id=11 THEN 'Tingkatan 5'
 ELSE 'lain-lain' END as Tingkatan, 
 
s.subject_name, t.topic_no, t.chapter_name, COUNT(s.question_id) AS total_question, 

SUM(CASE WHEN s.review_by <> '' AND s.chapter_id=t.chapter_id THEN 1 ELSE 0 END) 
AS total_question_reviewed,

SUM(CASE WHEN s.review_by <> '' AND s.published_status = 1 AND s.chapter_id=t.chapter_id THEN 1 ELSE 0 END) 
AS total_question_reviewed_and_published,

SUM(CASE WHEN s.review_by <> '' AND s.published_status = 0 AND s.chapter_id=t.chapter_id AND s.review_status LIKE 'f4%' THEN 1 ELSE 0 END) 
AS total_question_need_to_review,

SUM(CASE WHEN s.review_by <> '' AND s.published_status = 0 AND s.chapter_id=t.chapter_id AND s.review_status LIKE 'up%' THEN 1 ELSE 0 END) 
AS total_question_rejected


FROM qst_master_main s
LEFT JOIN edu_subject_chapter t ON t.chapter_id=s.chapter_id
WHERE s.eduyear_id < 10
GROUP BY s.chapter_id
ORDER BY s.eduyear_id,t.subject_code_id, t.topic_no

Tuesday, December 13, 2016

Date picker for ionic

https://www.npmjs.com/package/ion-datetime-picker

Saturday, December 10, 2016

Fetch realtime database to blog using firebase

Idea utk Osem

1. Ujian personaliti diri dalam set soalan OSEM.

Thursday, December 8, 2016

Data Entry Review Summary


select 'main_total', A.total FROM (
select s.review_by, count(s.question_id) as total from
pencil_content.qst_master_main s 
where s.review_by <> '') as A

UNION ALL

select s.review_by, count(s.question_id) as  total from
pencil_content.qst_master_main s 
where s.review_by <> '' group by s.review_by order by total DESC;

Wednesday, December 7, 2016

Ideas to make mobile apps

ExamCrazy (For the Students, By the Students)

A virtual study room where students can meet other students of their own disciplines and prepare for their exams. Give a pop quiz for your friends, rate them, develop ideas over a concept and much more. Initially i thought this idea for a Facebook App. But now i am thinking this has a website.

Studies show over 65% of FBook users are under the age of 24. Why cant we use Social Networking for the sake of Academics.

Exist removed and added new array in PHP

$exist  = [1,2,3];
$update = [1,2,4,5,6];

//Action
//1 - Remove no 3
//Add 4,5 and 6

//Both exist before and after
//1,2

$both_exist = array_intersect($exist,$update);


echo ('Check removed');
$removed = array_diff($exist,$both_exist);
echo '';
print_r($removed);
echo '';

echo ('Added');
$combined = array_unique(array_merge($exist,$update));
$added    = array_diff($combined,$exist);
echo '';
print_r($added);
echo '';

Monday, December 5, 2016

Mathjax Online Converter

Sunday, December 4, 2016

How to implement Mathjax in Ionic?

1. Mathjax sample

Saturday, December 3, 2016

Update image soruce with new source using XML DOM parsing

//Update image src with new src
function upd_img_src_in_html($html_src='', $new_src='')
{
    if($html_src == '' || $new_src == ''):
        return '';
    endif;
    
    $xml = new DOMDocument();
    $xml->loadHTML($html_src, LIBXML_HTML_NOIMPLIED | LIBXML_HTML_NODEFDTD);

    $imgNodes = $xml->getElementsByTagName('img');
    for ($i = $imgNodes->length - 1; $i >= 0; $i--) {
        $imgNode = $imgNodes->item($i);
        $image_file_names = pathinfo($imgNode->getAttribute('src'), PATHINFO_BASENAME);

        if(!empty($image_file_names)):
            $imgNode->setAttribute('src', $new_src.$image_file_names);
            // $imgNode->setAttribute('style', 'max-width:90%; margin-left:auto; margin-right:auto;');
        endif;
    }

    return html_entity_decode($xml->saveHTML());
}

Also: http://php.net/manual/en/domelement.setattribute.php

Friday, December 2, 2016

Function to replace curly brackets {_} to _____________

260+ Ionic Framework Resources

There are many posts and articles on the Ionic Framework but sometimes it is difficult to locate exactly what you need. This list is a an attempt to create a comprehensive list of tutorials that cover as many topics as possible. I will update this list as I discover new posts and as new posts are suggested.

Don’t see what you’re looking for? Feel free to leave a comment and I’ll see if I can find something for you.

Saturday, December 31, 2016

Thursday, December 29, 2016

Sunday, December 25, 2016

Saturday, December 24, 2016

Tuesday, December 20, 2016

Thursday, December 15, 2016

Tuesday, December 13, 2016

Saturday, December 10, 2016

Thursday, December 8, 2016

Wednesday, December 7, 2016

Monday, December 5, 2016

Sunday, December 4, 2016

Saturday, December 3, 2016

Friday, December 2, 2016

Ionic Basics

Installation and Setup

Ionic Components

Ionic App Patterns

Authentication

Testing

Performance

Backend as a Service (Firebase)

Backend as a Service (IBM MobileFirst)

Backend as a Service (other)

Ionic Tooling

Ionic Backend Services (ionic.io)

Ionic Ions

ngCordova/Cordova Plugins

Miscellaneous