<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include 'config.php';
$start_time = microtime(true);
echo " Start time: " . $start_time . " seconds ".date('Y-m-d H:i:s');
//$curDate = date('Y-m-d',strtotime('-1 days'));
$curDate = date('Y-m-d');
//$curDate = date('2022-03-17');
$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';

// $f_fdate = '2021-05-21';
// $f_tdate = '2021-05-31';

echo "Query run on :".$curDate.PHP_EOL;
# get questions which are last updated

//$getQuestions = $live->query("SELECT sqm.question_id,sq.question_of,sqm.id,sqm.medium_id FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_QUESTION as sq on sq.question_id=sqm.question_id where sqm.question_id IN(select q.question_id from h7382406836182.wp_aat93akkcv_sp_question_medium_wise as q where q.status IN(1,2,3)) and sqm.status='4' limit 1,1000");

// $getQuestions = $live->query("SELECT sqm.question_id,sq.question_of,sqm.id,sqm.medium_id FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_QUESTION as sq on sq.question_id=sqm.question_id where sqm.question_id IN(select question_id from $SP_QUESTION where master_id IN(86)) ");

$getQuestions = $live->query("SELECT sqm.question_id,sq.question_of,sqm.id,sqm.medium_id FROM $SP_QUESTION_MEDIUM_WISE as sqm LEFT JOIN $SP_QUESTION as sq on sq.question_id=sqm.question_id where (date(sqm.add_date)='$curDate' OR date(sqm.last_update_on)='$curDate')");
$i = 1;
while ($q = $getQuestions->fetch_assoc()) {

    echo "<br>".$i."--".$qID = $q['question_id'];
    $qID = $q['question_id'];
    $quesOf = $q['question_of'];
    $ref_id = $q['id'];
    $medium_id = $q['medium_id'];
    $repo = json_decode($quesOf);
    if ($quesOf != '' && $qID !='' && $ref_id !='') {
        if ((sizeof($repo) == '1') && (in_array('sarkari-pariksha', $repo))) {
            # update to sarkari-pariksha
            $updateToSp = $live->query("REPLACE into h7382406836182.wp_aat93akkcv_sp_question_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ref_id'");
            echo $i."-Ques :".$qID.'-'.$ref_id.'-'.$quesOf.PHP_EOL;
        } else if ((sizeof($repo) == '1') && (in_array('csc-olympiad', $repo))) {
            # update to csc-olympiad
            $updateToOly = $live->query("REPLACE into olyComnDB.oly_questions_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ref_id'");
            echo $i."-Ques :".$qID.'-'.$ref_id.'-'.$quesOf.PHP_EOL;
        } else if ((sizeof($repo) == '2')) {
            # update to both
            $updateToSp = $live->query("REPLACE into h7382406836182.wp_aat93akkcv_sp_question_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ref_id'");
            $updateToOly = $live->query("REPLACE into olyComnDB.oly_questions_medium_wise SELECT * FROM $SP_QUESTION_MEDIUM_WISE where id='$ref_id'");
            echo $i."-Ques :".$qID.'-'.$ref_id.'-'.$quesOf.PHP_EOL;
        }
    } else {
        echo 'empty'.PHP_EOL;
    }
    $i++;
}
$end_time = microtime(true);
$execution_time = ($end_time - $start_time);
echo " Execution time: " . $execution_time . " seconds ".date('Y-m-d H:i:s');

//Closing the connection
$live->close();