webadmin.php

/var/www/hkosl.com/imusiccircle/webadmin/course_search_index.php

<?php
    $page_settings = array(
        'formid'     => 'Tutor_search', // for permission
        'section'    => 'Master', // parent/page title
        'subsection' => 'Course Search', // page title
        'domain'     => 'tutor_search', // table/model name
        'access'     => 'GNr', // for permission
    );

    require_once "check_login.php";

    if (isset($_GET["reset"]) && $_GET["reset"] == 1 || !empty($_GET["student_postjob_id"])) {
        unset($_SESSION["tutor_search"]);
    }

    if ($_SESSION["is_student"] != 1 && $_SESSION["cmsrole"] == "user") {
        //add alert message
        header("Location: index.php");
    } else {
        //get this student info
        $sql        = "select * from student_main where cmsloginid = ?";
        $parameters = array($_SESSION["cmsloginid"]);
        $student    = bind_pdo($sql, $parameters, "selectone");

        //get post list
        $sql        = "select * from student_postjob where studentmain_id = ? and status =? and deleted = ?";
        $parameters = array($student["id"], 1, 0);
        $posts      = bind_pdo($sql, $parameters, "selectall");
    }

    if ($_SESSION["cmsrole"] == "super_admin" || $_SESSION["cmsrole"] == "admin") {
        //get student list
        $sql        = "select * from student_main where status = ? and deleted = ?";
        $parameters = array(4, 0);
        $students   = bind_pdo($sql, $parameters, "selectall");

        //get post list
        $sql        = "select * from student_postjob where status =? and deleted = ?";
        $parameters = array(1, 0);
        $posts      = bind_pdo($sql, $parameters, "selectall");
    }
    $level_of_grades       = get_master_type_code("LEVEL_OF_GRADE");
    $music_theory_grades   = get_master_type_code("MUSTHEORY_GRADE");
    $locations             = get_master_type_code("TEACH_POSITIONCODE");
    $all_instruments       = get_master_type_code("INSTRUMENT");
    $teach_venues          = get_master_type_code("TEACH_VENUS");
    $teach_modes           = get_master_type_code("TEACH_MODE");
    $instrument_categories = get_master_type_code("INSTRUMENT_TYPE");

    $_30min_fee       = 0;
    $_30max_fee       = 9999;
    $_45min_fee       = 0;
    $_45max_fee       = 9999;
    $_60min_fee       = 0;
    $_60max_fee       = 9999;
    $tutorreq_age_min = 0;
    $tutorreq_age_max = 100;

    //get post request
    if (!empty($_GET["studentmain_id"]) && !empty($_GET["student_postjob_id"])) {
        //set value in filter form
        $studentmain_id     = (int)$_GET["studentmain_id"];
        $student_postjob_id = (int)$_GET["student_postjob_id"];

        $sql        = "select * from student_postjob where student_postjob.studentmain_id = ? and student_postjob.id = ? and student_postjob.deleted = ?";
        $parameters = array($studentmain_id, $student_postjob_id, 0);
        $postjob    = bind_pdo($sql, $parameters, "selectone");

        $category_id                                 = $postjob["mas_instrument"];
        $_SESSION["tutor_search"]["category_id"]     = $postjob["mas_instrument"];
        $require_tutor_gender                        = $postjob["tutorreq_gender"];
        $_SESSION["tutor_search"]["tutorreq_gender"] = $postjob["tutorreq_gender"];
        $require_tutor_instrument_level              = $postjob["level"]; //LEVEL OF GRADE
        $_SESSION["tutor_search"]["level"]           = $postjob["level"];
        /*$require_tutor_theory_level                   = $postjob["tutorreq_level"]; //theory grade
        $_SESSION["tutor_search"]["tutorreq_level"]   = $postjob["tutorreq_level"];*/
        $require_tutor_age_min                        = $postjob["tutorreq_age_min"];
        $_SESSION["tutor_search"]["tutorreq_age_min"] = $postjob["tutorreq_age_min"];
        $require_tutor_age_max                        = $postjob["tutorreq_age_max"];
        $_SESSION["tutor_search"]["tutorreq_age_max"] = $postjob["tutorreq_age_max"];

        $sql                             = "select mas_teachareacode from student_postjoblearndistrict where studentpostjob_id = ? and deleted = ?";
        $parameters                      = array($student_postjob_id, 0);
        $require_tutor_mas_teachareacode = bind_pdo($sql, $parameters, "selectall");
        foreach ($require_tutor_mas_teachareacode as $row) {
            $_SESSION["tutor_search"]["tutor_mas_teachareacode"][] = $row["mas_teachareacode"];
        }

        $sql                         = "select mas_teachmode from student_postjoblearnmode where studentpostjob_id = ? and deleted = ?";
        $parameters                  = array($student_postjob_id, 0);
        $require_tutor_mas_teachmode = bind_pdo($sql, $parameters, "selectall");
        foreach ($require_tutor_mas_teachmode as $row) {
            $_SESSION["tutor_search"]["tutor_mas_teachmode"][] = $row["mas_teachmode"];
        }

        $sql                          = "select mas_teachvenus from student_postjoblearnvenus where studentpostjob_id = ? and deleted = ?";
        $parameters                   = array($student_postjob_id, 0);
        $require_tutor_mas_teachvenus = bind_pdo($sql, $parameters, "selectall");
        foreach ($require_tutor_mas_teachvenus as $row) {
            $_SESSION["tutor_search"]["tutor_mas_teachvenus"][] = $row["mas_teachvenus"];
        }
    }

    if (isset($_SESSION["tutor_search"]["30mins_min_budget"]) && isset($_SESSION["tutor_search"]["30mins_max_budget"])) {
        $_30min_fee = $_SESSION["tutor_search"]["30mins_min_budget"];
        $_30max_fee = $_SESSION["tutor_search"]["30mins_max_budget"];
    }

    if (isset($_SESSION["tutor_search"]["45mins_min_budget"]) && isset($_SESSION["tutor_search"]["45mins_max_budget"])) {
        $_45min_fee = $_SESSION["tutor_search"]["45mins_min_budget"];
        $_45max_fee = $_SESSION["tutor_search"]["45mins_max_budget"];
    }

    if (isset($_SESSION["tutor_search"]["60mins_min_budget"]) && isset($_SESSION["tutor_search"]["60mins_max_budget"])) {
        $_60min_fee = $_SESSION["tutor_search"]["60mins_min_budget"];
        $_60max_fee = $_SESSION["tutor_search"]["60mins_max_budget"];
    }

    if (isset($_SESSION["tutor_search"]["tutorreq_age_min"]) && isset($_SESSION["tutor_search"]["tutorreq_age_max"])) {
        $tutorreq_age_min = $_SESSION["tutor_search"]["tutorreq_age_min"];
        $tutorreq_age_max = $_SESSION["tutor_search"]["tutorreq_age_max"];
    }
?>
<!DOCTYPE html>
<html>
<head>
    <?php require_once "_html_head.php"; ?>
    <link rel="stylesheet" href="css/tutor_student_search.css">

</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
    <?php require_once "_header.php"; ?>
    <?php require_once "_menu.php"; ?>

    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
            <h1>
                <?= _lang($page_settings['subsection']) ?>
                <small>
                    <?= _lang("Index") ?>
                </small>
            </h1>
            <ol class="breadcrumb">
                <li>
                    <?= _lang("Home") ?>
                </li>
                <li class="active"><a href="<?= $page_settings['domain'] ?>_index.php"><i class="fa"></i>
                        <?= _lang($page_settings['subsection']) ?>
                    </a></li>
            </ol>
        </section>

        <!-- Main content -->
        <section class="content">

            <!-- Your Page Content Here -->

            <!-- main table -->
            <div class="row">
                <div class="col-xs-12">
                    <div class="box">
                        <div class="box-body">
                            <iframe src="../course_category.php" style="width: 100%;overflow: hidden; visibility: hidden" frameborder="0" id="course_category_iframe" onload="resizeIframe(this)"></iframe>
                        </div>
                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->
            </div>
            <!-- /.col -->
        </section>
    </div>
    <!-- /.row -->

    <!-- End of Your Page Content Here -->

    <!-- /.content -->
</div>
<!-- /.content-wrapper -->

<?php require_once "_footer.php"; ?>
<?php require_once "_aside.php"; ?>
</div>
<!-- ./wrapper -->

<div id="loading"><img src="../img/loading_icon.gif" style="width: 100px;"></div>

<!-- REQUIRED JS SCRIPTS -->
<?php require_once "_html_script.php"; ?>
<!--<link href="../css/agency.css" rel="stylesheet">-->
<link href="../css/bootstrap-slider.css" rel="stylesheet">
<script src="../js/bootstrap-slider.js"></script>
<script src="../js/jquery.dotdotdot.min.js"></script>
<script src="../js/select2/select2.min.js"></script>
<link href="../js/select2/select2.min.css" rel="stylesheet">
<script src="js/jquery.chained.min.js"></script>
<link rel="stylesheet" href="../js/fancybox/jquery.fancybox.css?v=2.1.5" type="text/css" media="screen"/>
<script type="text/javascript" src="../js/fancybox/jquery.fancybox.pack.js?v=2.1.5"></script>
<script type="text/javascript">
    function resizeIframe(iframe) {
        iframe.height = iframe.contentWindow.document.body.scrollHeight + "px";
        
        $("#course_category_iframe").contents().find("nav").remove();
        $("#course_category_iframe").contents().find(".Categoryheader").remove();
        $("#course_category_iframe").contents().find(".footer").remove();
        $("#course_category_iframe").contents().find(".FooterBlack").remove();
        $("#course_category_iframe").contents().find("#back-to-top").remove();
        $("#course_category_iframe").contents().find("#footer_whatsapp").remove();
        $("#course_category_iframe").contents().find("#chat-application").remove();
        $("#course_category_iframe").contents().find("#chat-application-iframe").remove();
        $("#course_category_iframe").contents().find(".page_breadcrumbs").parent().remove();
        $("#course_category_iframe").contents().find("body").css("overflow-x", "hidden");
        $("#course_category_iframe").css("visibility", "visible");
    }

    $(function () {
        /*$('#course_category_iframe').load(function(){

        });*/
    });

    function tutor_search(start) {
        return true;
        $('#loading').slideDown(100);

        if (!start)
            start = 0;
        //$('#loading').slideDown(100);
        //console.log("filter tutor");
        var quick_search = $("#quick_search").val();
        var category_id = $("#category_id").val(); //instrument
        var level = $("#level").val();

        console.log(level);

        //tutorreq_gender = JSON.stringify(tutorreq_gender);

        var sort_by = $("input[name='sort_by']:checked").val();

        jQuery.ajax({
            url: '_ajax.php',
            type: 'POST',
            data: {
                ajax: "course_search",
                quick_search: quick_search,
                category_id: category_id,
                level: level,
                sort_by: sort_by,
                start: start
            },
            dataType: 'html', //dataType (default: Intelligent Guess (xml, json, script, or html))
            timeout: 10000,
            error: function (result) {
                //console.log(result);
                console.log(result.responseText);
                //alert('Error Occur. Please try again.');
                //location.href="tutor_search_index.php?reset=1";
            },
            success: function (result) {
                $('#loading').slideUp(100);
                //console.log(result);
                if (result == "FAIL") {
                    alert("Access Denied!");
                } else {
                    $("#tutor_list").empty().html(result);

                    $(".start").on("click", function () {
                        var start = $(this).attr("data-value");
                        tutor_search(start);
                    });

                    //resizeImage();

                    //text overflow
                    $(".self_describemyself").dotdotdot();

                    $.fn.stars = function () {
                        return $(this).each(function () {
                            $(this).html($('<span />').width(Math.max(0, (Math.min(5, parseFloat($(this).html())))) * 16));
                        });
                    };

                    $('span.stars').stars();
                }

                $(".fancybox1").fancybox({
                    maxWidth: 800,
                    maxHeight: 290,
                    fitToView: false,
                    width: '100%',
                    height: '100%',
                    autoSize: false,
                    closeClick: false,
                    openEffect: 'none',
                    closeEffect: 'none'
                });
            }
        });

    }

    $(function () {
        <?php if ($_SESSION["cmsrole"] == "super_admin" || $_SESSION["cmsrole"] == "admin") {
        echo '$("#student_postjob_id").chained("#studentmain_id");';
    } ?>

        $("#30mins_charge, #45mins_charge, #60mins_charge, #tutor_age").slider({});

        $("#studentmain_id, #student_postjob_id").on("change", function () {
            //reload page
            var studentmain_id = $("#studentmain_id").val();
            var student_postjob_id = $("#student_postjob_id").val(); //instrument
            location.href = 'tutor_search_index.php?studentmain_id=' + studentmain_id + '&student_postjob_id=' + student_postjob_id;
            //tutor_search();
        });

        //filter quick search
        $("#quick_search_submit").on("click", function () {
            tutor_search();
        });

        /*$("#category_id, #level, #tutorreq_level, #tutor_mas_teachareacode, #tutor_mas_teachvenus, #tutor_mas_teachmode").on("change", function () {
         tutor_search();
         });*/

        $("#category_id, #level, #tutor_mas_teachareacode, #tutor_mas_teachvenus, #tutor_mas_teachmode").on("change", function () {
            tutor_search();
        });


        //filter page
        //$(".start").on("click", function () {
        $(".start").on("click", function () {
            var start = $(this).attr("data-value");
            tutor_search(start);
        });

        //center image
        /*resizeImage();

        $(window).resize(function () {
            resizeImage();
        });*/

        //text overflow
        $(".self_describemyself").dotdotdot();

        //change select
        $("#category_id").select2({
            width: "100%"
        });

        $("#level").select2({
            width: "100%"
        });

        /*$("#tutorreq_level").select2({
         disable_search: true,
         width: "100%"
         });*/

        $("#tutor_mas_teachareacode").select2({
            width: "100%",
            placeholder: "<?=_lang("Select Some Options")?>"
        });

        $("#tutor_mas_teachvenus").select2({
            width: "100%",
            placeholder: "<?=_lang("Select Some Options")?>"
        });

        $("#tutor_mas_teachmode").select2({
            width: "100%",
            placeholder: "<?=_lang("Select Some Options")?>"
        });

        tutor_search(); //auto run the first time filter tutor

    });

</script>
</body>
</html>