webadmin.php

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

<?php
    include('../_init.php');
    include('../JSON.php');

    foreach ($_POST as $key => $value) {
        $_POST[$key] = _h($value);
    }

    $data = $_POST;
    $data['ajax'] = 'testcourse_submit';
    if ($data['ajax'] == 'tutor_search') {
        //student post find tutor

        /*var_dump($data);
        exit;*/

        $valid = true;
        if (!$valid) {
            echo "FAIL";
            exit;
        } else {

            $quick_search = $data["quick_search"];

            $category_id = $data["category_id"];

            $require_tutor_gender = $data["tutorreq_gender"];

            $require_tutor_instrument_level = $data["level"]; //LEVEL OF GRADE

            $require_tutor_theory_level = $data["tutorreq_level"]; //theory grade

            $require_tutor_age_min = $data["tutorreq_age_min"];

            $require_tutor_age_max = $data["tutorreq_age_max"];

            $_30mins_min_budget = $data["_30mins_min_budget"];

            $_30mins_max_budget = $data["_30mins_max_budget"];

            $_45mins_min_budget = $data["_45mins_min_budget"];

            $_45mins_max_budget = $data["_45mins_max_budget"];

            $_60mins_min_budget = $data["_60mins_min_budget"];

            $_60mins_max_budget = $data["_60mins_max_budget"];

            $require_tutor_mas_teachareacode = $data["tutor_mas_teachareacode"];

            $require_tutor_mas_teachmode = $data["tutor_mas_teachmode"];

            $require_tutor_mas_teachvenus = $data["tutor_mas_teachvenus"];


            foreach ($data as $key => $value) {
                $_SESSION["tutor_search"][$key] = $value;
            }

            $where_clause = "";
            $parameters   = array(0, 4, 0, 1, "fee");

            //quick search tutor nickname
            if (!empty($_POST["quick_search"])) {
                $where_clause .= " and tutor_main.nickname LIKE ?";
                $parameters[] = "%" . $_POST["quick_search"] . "%";
            }

            //tutor instrument
            if (!empty($category_id) && $category_id != "ANY") {
                $where_clause .= " and tutor_charge.mas_instrument = ?";
                $parameters[] = $category_id;
            }


            //tutor instrument grade
            if (!empty($require_tutor_instrument_level) && $require_tutor_instrument_level != "ANY") {
                $where_clause .= " and tutor_expectcharge.grade=?";
                $parameters[] = $require_tutor_instrument_level;
            }

            //tutor theory grade
            if (!empty($require_tutor_theory_level) && $require_tutor_theory_level != "ANY") {
                $where_clause .= " and tutor_main.mas_mustheorygrade=?";
                $parameters[] = $require_tutor_theory_level;
            }

            //tutor teacharea
            $any = false;
            if (!empty($require_tutor_mas_teachareacode) && count($require_tutor_mas_teachareacode) > 0) {
                foreach ($require_tutor_mas_teachareacode as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $teacharea_clause = " and (";
                    foreach ($require_tutor_mas_teachareacode as $row) {
                        $teacharea_clause .= "tutor_teachareacode.mas_teachareacode=? or ";
                        $parameters[] = $row;
                    }

                    if (!empty($teacharea_clause)) {
                        $teacharea_clause = substr_replace($teacharea_clause, "", -3) . ")";
                    }

                    $where_clause .= $teacharea_clause;
                }
            }


            //tutor mode
            $any = false;
            if (!empty($require_tutor_mas_teachmode) && count($require_tutor_mas_teachmode) > 0) {
                foreach ($require_tutor_mas_teachmode as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $teach_mode_clause = " and (";
                    foreach ($require_tutor_mas_teachmode as $row) {
                        $teach_mode_clause .= "tutor_teachmode.mas_teachmode=? or ";
                        $parameters[] = $row;
                    }
                    if (!empty($teach_mode_clause)) {
                        $teach_mode_clause = substr_replace($teach_mode_clause, "", -3) . ")";
                    }
                    $where_clause .= $teach_mode_clause;
                }
            }


            //tutor venue
            $any = false;
            if (!empty($require_tutor_mas_teachvenus) && count($require_tutor_mas_teachvenus) > 0) {
                foreach ($require_tutor_mas_teachvenus as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $teach_venue_clause = " and (";
                    foreach ($require_tutor_mas_teachvenus as $row) {
                        $teach_venue_clause .= "tutor_teachvenus.mas_teachvenus=? or ";
                        $parameters[] = $row;
                    }
                    if (!empty($teach_venue_clause)) {
                        $teach_venue_clause = substr_replace($teach_venue_clause, "", -3) . ")";
                    }

                    $where_clause .= $teach_venue_clause;
                }

            }


            //tutor gender
            if (count($require_tutor_gender) == 1) {
                $where_clause .= " and tutor_main.gender=?";
                $parameters[] = $require_tutor_gender[0];
            }

            //tutor age
            $current_year          = date("Y");
            $require_tutor_dob_max = ($current_year - $require_tutor_age_min) . "-" . date("m");
            $require_tutor_dob_min = ($current_year - $require_tutor_age_max) . "-" . date("m");

            $where_clause .= " and CONCAT(tutor_main.dob_year, '-', tutor_main.dob_mon) >= ? and CONCAT(tutor_main.dob_year, '-', tutor_main.dob_mon) <= ?";
            $parameters[] = $require_tutor_dob_min;
            $parameters[] = $require_tutor_dob_max;

            //tutor fee
            if ((isset($_30mins_min_budget) && isset($_30mins_max_budget)) || (isset($_45mins_min_budget) && isset($_45mins_max_budget)) || (isset($_60mins_min_budget) && isset($_60mins_max_budget))) {
                $where_clause .= " and (";

                //if (isset($_30mins_min_budget)  && $_30mins_min_budget != 0  && isset($_30mins_max_budget) && $_30mins_max_budget != 9999) {
                if (isset($_30mins_min_budget) && isset($_30mins_max_budget)) {
                    $where_clause .= " (tutor_expectcharge.charge_30min >= ? and tutor_expectcharge.charge_30min <= ?) or ";
                    $parameters[] = $_30mins_min_budget;
                    $parameters[] = $_30mins_max_budget;
                }

                //if (isset($_45mins_min_budget) && $_45mins_min_budget != 0 && isset($_45mins_max_budget) && $_45mins_max_budget != 9999) {
                if (isset($_45mins_min_budget) && isset($_45mins_max_budget)) {
                    $where_clause .= " (tutor_expectcharge.charge_45min >= ? and tutor_expectcharge.charge_45min <= ?) or ";
                    $parameters[] = $_45mins_min_budget;
                    $parameters[] = $_45mins_max_budget;
                }

                //if (isset($_60mins_min_budget) && $_60mins_min_budget != 0 && isset($_60mins_max_budget) && $_60mins_min_budget != 9999) {
                if (isset($_60mins_min_budget) && isset($_60mins_max_budget)) {
                    $where_clause .= " (tutor_expectcharge.charge_60min >= ? and tutor_expectcharge.charge_60min <= ?) and ";
                    $parameters[] = $_60mins_min_budget;
                    $parameters[] = $_60mins_max_budget;
                }

                $where_clause = substr_replace($where_clause, "", -4) . ")";
            }


            /*if(isset($_SESSION["category_page"]["start"])){
                $start = $_SESSION["category_page"]["start"];
            }else{
                if (!isset($_POST["start"])) {
                    $start = 0;
                } else {
                    $start = (int)$_POST["start"];
                }
            }
            $_SESSION["category_page"]["start"] = $_POST["start"];*/

            $sql = "select * from tutor_main
                    INNER JOIN tutor_charge ON tutor_main.id = tutor_charge.tutormain_id
                    INNER JOIN tutor_expectcharge ON tutor_charge.id = tutor_expectcharge.charge_id
                    INNER JOIN tutor_teachareacode ON tutor_teachareacode.tutormain_id = tutor_main.id
                    INNER JOIN tutor_teachvenus ON tutor_teachvenus.tutormain_id = tutor_main.id
                    INNER JOIN tutor_teachmode ON tutor_teachmode.tutormain_id = tutor_main.id
                    where tutor_charge.deleted = ? and tutor_main.status = ? and tutor_main.deleted = ? and tutor_main.approved = ? and tutor_expectcharge.type= ? {$where_clause} group by tutor_main.id";

            //debug_log("tutor search ajax", dump_sql($sql, $parameters));
            $tutors = bind_pdo($sql, $parameters, "selectall");

            /*$sql = "select * from tutor_main
                    INNER JOIN tutor_charge ON tutor_main.id = tutor_charge.tutormain_id
                    INNER JOIN tutor_expectcharge ON tutor_charge.id = tutor_expectcharge.charge_id
                    INNER JOIN tutor_teachareacode ON tutor_teachareacode.tutormain_id = tutor_main.id
                    INNER JOIN tutor_teachvenus ON tutor_teachvenus.tutormain_id = tutor_main.id
                    INNER JOIN sys_cms_login ON sys_cms_login.cmsloginid = tutor_main.cmsloginid
                    where tutor_charge.deleted = ? and tutor_main.status = ? and tutor_main.deleted = ? {$where_clause} group by tutor_main.id
                    limit " . $start . ", " . $limit;

            $tutors = bind_pdo($sql, $parameters, "selectall");*/

            //echo dump_sql($sql, $parameters)."\n\r";
            //var_dump($tutors);

            //debug_log(222, $tutors);
            if (!empty($tutors)) {
                $limit   = 10;
                $count   = count($all_tutors);
                $numpage = $count / $limit;

                foreach ($tutors as $key => $tutor) {
                    if (!empty($tutor["tutormain_id"])) {
                        $teaching_experience = get_master_type_code_by_id($tutor["mas_teachexp"]);
                        $tutor_expectcharge  = get_tutor_expectcharge($tutor["tutormain_id"], $category_id, "fee");

                        $tutors[$key]["teaching_experience"] = $teaching_experience["name_" . $_SESSION["wlangcode"]];
                        $tutors[$key]["min_fee"]             = $tutor_expectcharge[0]["min_fee"];
                        $tutors[$key]["min_minutes"]         = $tutor_expectcharge[0]["min_minutes"];

                    }
                }

                if (!empty($_POST["sort_by"])) {
                    if ($_POST["sort_by"] == "MOST_POPULAR") {

                    } else if ($_POST["sort_by"] == "LOW_HIGH") {
                        uasort($tutors, 'low2high');
                    } else if ($_POST["sort_by"] == "HIGH_LOW") {
                        uasort($tutors, 'high2low');
                    } else if ($_POST["sort_by"] == "ACCUMULATE_HOUR_LOW_HIGH") {
                        uasort($tutors, 'accumulate_hour_low2high');
                    } else if ($_POST["sort_by"] == "ACCUMULATE_HOUR_HIGH_LOW") {
                        uasort($tutors, 'accumulate_hour_high2low');
                    }
                }


                foreach ($tutors as $tutor) {
                    if (!empty($tutor["tutormain_id"])) {

                        ?>
                        <div class="col-lg-4 col-md-4">
                            <div class="Tutor">
                                <?php if (!empty($tutor["profilephoto_path"])) { ?>
                                    <a href="../profile.php?id=<?= $tutor["tutormain_id"] ?>" target="_blank">
                                        <div class="tutor_img_container">
                                            <div class="tutor_img" style="background: url(../file/teacher/<?= $tutor["profilephoto_path"] ?>) center center no-repeat; background-size: contain; width: inherit; height: inherit"></div>
                                            <img class="tutor_img2" src="../file/teacher/<?= $tutor["profilephoto_path"] ?>">
                                        </div>
                                    </a>
                                <?php } ?>

                                <div class="CategoryTutorName"><?= $tutor["nickname"] ?></div>
                                <div class="TutorInfo">
                                    <font size="4">HK$<?= (float)$tutor["min_fee"] ?> <?= _lang("per " . $tutor["min_minutes"] . " mins") ?></font><br>

                                    <div class="TutorDescription">
                                        <?php
                                            echo "<p class='self_describemyself' style='height: 33px;'>" . nl2br($tutor["self_describemyself"]) . "</p>";

                                            echo "<p>" . _lang("Accumulate Tutorial Hours") . ": 0 " . _lang("hours") . "</p>";
                                            echo "<p>" . _lang("LAST LOGIN") . ": " . get_last_login_date($tutor["cmsloginid"]) . "</p>";
                                        ?>

                                    </div>
                                    <hr>
                                    <div class="experience">
                                        <span class="glyphicon glyphicon-paperclip"></span><font color="#ff0000"> <?= $tutor["teaching_experience"] ?><?= _lang("years experience") ?></font>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <?php
                    }
                }

                echo '<div class="col-lg-12">';
                if ($numpage > 1) {
                    pagenav();
                }
                echo '</div>';
            }

        }
    } else if ($data['ajax'] == 'student_search') {
        //tutor find student

        /*var_dump($data);
        exit;*/

        $valid = true;
        if (!$valid) {
            echo "FAIL";
            /*echo '<script>alert("Access Denied!"); history.back();</script>';*/
            exit;
        } else {

            $quick_search = $data["quick_search"];

            $category_ids = $data["category_ids"];

            $require_student_gender = $data["studentreq_gender"];

            $require_student_instrument_level = $data["level"]; //LEVEL OF GRADE

            $require_student_theory_level = $data["studentreq_level"]; //theory grade

            $require_student_age_min = $data["studentreq_age_min"];

            $require_student_age_max = $data["studentreq_age_max"];

            $_30mins_min_budget = $data["_30mins_min_budget"];

            $_30mins_max_budget = $data["_30mins_max_budget"];

            $_45mins_min_budget = $data["_45mins_min_budget"];

            $_45mins_max_budget = $data["_45mins_max_budget"];

            $_60mins_min_budget = $data["_60mins_min_budget"];

            $_60mins_max_budget = $data["_60mins_max_budget"];

            $require_student_mas_teachareacode = $data["student_mas_teachareacode"];

            $require_student_mas_teachmode = $data["student_mas_teachmode"];

            $require_student_mas_teachvenus = $data["student_mas_teachvenus"];


            foreach ($data as $key => $value) {
                $_SESSION["student_search"][$key] = $value;
            }

            $where_clause = "";
            $parameters   = array(0, 4, 1, 0, 1, 1);

            //quick search student contact name
            if (!empty($_POST["quick_search"])) {
                $where_clause .= " and (student_main.contactname LIKE ? || student_postjob.postjob_no LIKE ?)";
                $parameters[] = "%" . $_POST["quick_search"] . "%";
                $parameters[] = "%" . $_POST["quick_search"] . "%";
            }

            //student instrument
            $any = false;
            if (!empty($category_ids) && count($category_ids) > 0) {
                foreach ($category_ids as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $category_ids_clause = " and (";
                    foreach ($category_ids as $row) {
                        $category_ids_clause .= "student_postjob.mas_instrument=? or ";
                        $parameters[] = $row;
                    }

                    if (!empty($category_ids_clause)) {
                        $category_ids_clause = substr_replace($category_ids_clause, "", -3) . ")";
                    }

                    $where_clause .= $category_ids_clause;
                }
            }

            //student instrument grade
            if (!empty($require_student_instrument_level) && $require_student_instrument_level != "ANY") {
                $where_clause .= " and student_postjob.level=?";
                $parameters[] = $require_student_instrument_level;
            }

            //student theory grade
            if (!empty($require_student_theory_level) && $require_student_theory_level != "ANY") {
                $where_clause .= " and student_postjob.tutorreq_level=?";
                $parameters[] = $require_student_theory_level;
            }

            //student teacharea
            $any = false;
            if (!empty($require_student_mas_teachareacode) && count($require_student_mas_teachareacode) > 0) {
                foreach ($require_student_mas_teachareacode as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $teacharea_clause = " and (";
                    foreach ($require_student_mas_teachareacode as $row) {
                        $teacharea_clause .= "student_postjoblearndistrict.mas_teachareacode=? or ";
                        $parameters[] = $row;
                    }

                    if (!empty($teacharea_clause)) {
                        $teacharea_clause = substr_replace($teacharea_clause, "", -3) . ")";
                    }

                    $where_clause .= $teacharea_clause;
                }
            }


            //tutor mode
            $any = false;
            if (!empty($require_student_mas_teachmode) && count($require_student_mas_teachmode) > 0) {
                foreach ($require_student_mas_teachmode as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $teach_mode_clause = " and (";
                    foreach ($require_student_mas_teachmode as $row) {
                        $teach_mode_clause .= "student_postjoblearnmode.mas_teachmode=? or ";
                        $parameters[] = $row;
                    }

                    if (!empty($teach_mode_clause)) {
                        $teach_mode_clause = substr_replace($teach_mode_clause, "", -3) . ")";
                    }

                    $where_clause .= $teach_mode_clause;
                }
            }


            //tutor venue
            $any = false;
            if (!empty($require_student_mas_teachvenus) && count($require_student_mas_teachvenus) > 0) {
                foreach ($require_student_mas_teachvenus as $row) {
                    if ($row == "ANY") {
                        $any = true;
                    }
                }

                if (!$any) {
                    $teach_venue_clause = " and (";
                    foreach ($require_student_mas_teachvenus as $row) {
                        $teach_venue_clause .= "student_postjoblearnvenus.mas_teachvenus=? or ";
                        $parameters[] = $row;
                    }
                    if (!empty($teach_venue_clause)) {
                        $teach_venue_clause = substr_replace($teach_venue_clause, "", -3) . ")";
                    }

                    $where_clause .= $teach_venue_clause;
                }

            }


            //tutor gender
            if (count($require_student_gender) == 1) {
                $where_clause .= " and student_postjob.tutorreq_gender=?";
                $parameters[] = $require_student_gender[0];
            }

            //student age
            /*$current_year          = date("Y");
            $require_tutor_dob_max = ($current_year - $require_student_age_min) . "-" . date("m");
            $require_tutor_dob_min = ($current_year - $require_student_age_max) . "-" . date("m");

            $where_clause .= " and CONCAT(tutor_main.dob_year, '-', tutor_main.dob_mon) >= ? and CONCAT(tutor_main.dob_year, '-', tutor_main.dob_mon) <= ?";
            $parameters[] = $require_tutor_dob_min;
            $parameters[] = $require_tutor_dob_max;*/

            //tutor fee
            if ((isset($_30mins_min_budget) && isset($_30mins_max_budget)) || (isset($_45mins_min_budget) && isset($_45mins_max_budget)) || (isset($_60mins_min_budget) && isset($_60mins_max_budget))) {
                $where_clause .= " and (";

                //if (isset($_30mins_min_budget)  && $_30mins_min_budget != 0  && isset($_30mins_max_budget) && $_30mins_max_budget != 9999) {
                if (isset($_30mins_min_budget) && isset($_30mins_max_budget)) {
                    $where_clause .= "student_postjob.30mins_min_budget >= ? and student_postjob.30mins_max_budget <= ? and ";
                    $parameters[] = $_30mins_min_budget;
                    $parameters[] = $_30mins_max_budget;
                }

                //if (isset($_45mins_min_budget) && $_45mins_min_budget != 0 && isset($_45mins_max_budget) && $_45mins_max_budget != 9999) {
                if (isset($_45mins_min_budget) && isset($_45mins_max_budget)) {
                    $where_clause .= "student_postjob.45mins_min_budget >= ? and student_postjob.45mins_max_budget <= ? and ";
                    $parameters[] = $_45mins_min_budget;
                    $parameters[] = $_45mins_max_budget;
                }

                //if (isset($_60mins_min_budget) && $_60mins_min_budget != 0 && isset($_60mins_max_budget) && $_60mins_min_budget != 9999) {
                if (isset($_60mins_min_budget) && isset($_60mins_max_budget)) {
                    $where_clause .= "student_postjob.60mins_min_budget >= ? and student_postjob.60mins_max_budget <= ? and ";
                    $parameters[] = $_60mins_min_budget;
                    $parameters[] = $_60mins_max_budget;
                }

                $where_clause = substr_replace($where_clause, "", -4) . ")";
            }

            $sql = "select * from student_main
                    INNER JOIN student_postjob ON student_main.id = student_postjob.studentmain_id
                    INNER JOIN student_postjoblearndistrict ON student_postjoblearndistrict.studentpostjob_id = student_postjob.id
                    INNER JOIN student_postjoblearnmode ON student_postjoblearnmode.studentpostjob_id = student_postjob.id
                    INNER JOIN student_postjoblearnvenus ON student_postjoblearnvenus.studentpostjob_id = student_postjob.id
                    
                    where student_main.deleted = ? and student_main.status = ? and student_main.approved = ? and student_postjob.deleted = ? and student_postjob.status = ? and student_postjob.approved = ? {$where_clause} group by student_main.id";

            //debug_log("student search ajax", dump_sql($sql, $parameters));
            $students = bind_pdo($sql, $parameters, "selectall");

            //echo dump_sql($sql, $parameters) . "<br><br>";
            //var_dump($students);


            if (!empty($students)) {
                $limit   = 10;
                $count   = count($all_students);
                $numpage = $count / $limit;
                /*
                                foreach ($tutors as $key => $tutor) {
                                    if (!empty($tutor["tutormain_id"])) {
                                        $teaching_experience = get_master_type_code_by_id($tutor["mas_teachexp"]);
                                        $tutor_expectcharge  = get_tutor_expectcharge($tutor["tutormain_id"], $category_id, "fee");

                                        $tutors[$key]["teaching_experience"] = $teaching_experience["name_" . $_SESSION["wlangcode"]];
                                        $tutors[$key]["min_fee"]             = $tutor_expectcharge[0]["min_fee"];
                                        $tutors[$key]["min_minutes"]         = $tutor_expectcharge[0]["min_minutes"];

                                    }
                                }

                                if (!empty($_POST["sort_by"])) {
                                    if ($_POST["sort_by"] == "MOST_POPULAR") {

                                    } else if ($_POST["sort_by"] == "LOW_HIGH") {
                                        uasort($tutors, 'low2high');
                                    } else if ($_POST["sort_by"] == "HIGH_LOW") {
                                        uasort($tutors, 'high2low');
                                    }
                                }*/

                foreach ($students as $student) {
                    if (!empty($student["studentmain_id"])) {

                        $instrument_info = get_master_type_code_by_id($student["mas_instrument"]);
                        ?>
                        <div class="col-lg-4 col-md-4">
                            <div class="Tutor">

                                <div class="CategoryTutorName"><?= _lang("Job No.") . ": " . $student["postjob_no"] ?></div>
                                <div class="TutorInfo" style="position: relative;">
                                    <font size="4"><?= _lang("Name") . ": " . $student["contactname"] ?></font><br>
                                    <?= _lang("Musical Instrument") . ": " . $instrument_info["name_" . $_SESSION["wlangcode"]] ?>
                                    <br>
                                    <?= _lang("Level") . ":" . $student["level"] ?>
                                    <br>
                                    <?= _lang("Budget") . ": " ?>
                                    <br>
                                    HK$<?= $student["30mins_min_budget"] . " - " . $student["30mins_max_budget"] . " " . _lang("per 30 mins") ?>
                                    <br>
                                    HK$<?= $student["45mins_min_budget"] . " - " . $student["45mins_max_budget"] . " " . _lang("per 45 mins") ?>
                                    <br>
                                    HK$<?= $student["60mins_min_budget"] . " - " . $student["60mins_max_budget"] . " " . _lang("per 60 mins") ?>

                                    <br><br><br>
                                    <div class="job_detail">
                                        <a href="../job.php?id=1" class="MoreBTN"><?= _lang("Detail") ?></a></div>

                                </div>
                            </div>
                        </div>
                        <?php
                    }
                }

                echo '<div class="col-lg-12">';
                if ($numpage > 1) {
                    pagenav();
                }
                echo '</div>';
            }

        }
    } else if ($data['ajax'] == 'chat_content') {
        $job_id    = (int)$_POST["job_id"];
        $user_id   = (int)$_POST["user_id"];
        $user_type = $_POST["user_type"];

        //security checking
        if ($_SESSION["is_tutor"] == 1 && $_SESSION["cmsrole"] == "user") {
            if ($user_type != "TUTOR" || $user_id != $_SESSION["member_login"]) {
                echo _lang("Access Denied!");
                exit;
            }
        } else if ($_SESSION["is_student"] == 1 && $_SESSION["cmsrole"] == "user") {
            if ($user_type != "STUDENT" || $user_id != $_SESSION["student_login"]) {
                echo _lang("Access Denied!");
                exit;
            }
        }

        $where_clause = "";
        $parameters   = array(0, $job_id);

        //$where_clause = " and ((chat.from_id = ? and chat.from_role = ?) or (chat.to_id = ? and chat.to_role = ?)) and chat.approved = ?";
        $where_clause = " and ((chat.from_id = ? and chat.from_role = ?) or (chat.to_id = ? and chat.to_role = ?)) ";
        $parameters[] = $user_id;
        $parameters[] = $user_type;
        $parameters[] = $user_id;
        $parameters[] = $user_type;
        //$parameters[] = 1;

        $sql = "select chat.*, chat.id as chat_id, tutor_main.nickname, tutor_main.id as tutormain_id, student_main.contactname, student_main.id as studentmain_id, tutor_main.profilephoto_path 
        from chat 
        INNER JOIN tutor_main ON ( (tutor_main.id = chat.from_id and chat.from_role = 'TUTOR') or (tutor_main.id = chat.to_id and chat.to_role = 'TUTOR') )
        INNER JOIN student_main ON ( (student_main.id = chat.from_id and chat.from_role = 'STUDENT') or (student_main.id = chat.to_id and chat.to_role = 'STUDENT') )
        where chat.deleted = ? and chat.studentpostjob_id = ? {$where_clause} order by chat.sent_date ASC";

        $chats = bind_pdo($sql, $parameters, "selectall");

        $tutor_chat_count = 1;
        $student_chat_count = 1;
        $approved_chat = 0;
        $result = '';
        foreach ($chats as $chat) {
            //skip not approved and not that user login chat
            if($chat["approved"] != 1 && $chat["from_id"] != $user_id){
                continue;
            }else{
                $approved_chat++;
            }

            //update read
            if( ($chat["to_role"] == "STUDENT" && $chat["to_id"] == $_SESSION["student_login"]) || ($chat["to_role"] == "TUTOR" && $chat["to_id"] == $_SESSION["member_login"] ) ){
                $sql = "update chat set read_date = ? where id = ? ";
                $parameters = array(date("Y-m-d H:i:s"), $chat["chat_id"]);
                bind_pdo($sql, $parameters);
            }

            //$result .= "<input type='hidden' name='accumulate_chat' id='accumulate_chat' value=''>";
            $result .= "<div class='row' style='padding: 0 15px; margin-bottom: 15px;'>";

            $result .= "<div></div>";
            if ($chat["from_role"] == $user_type) {
                $result .= '<div class="col-xs-10" style="border: 1px solid #000; padding: 0;">
                                <div style="padding-left: 5px;">
                                    '.nl2br($chat["content"]).'
                                </div>
                                <div class="tr">';
                                    if($chat["from_role"] == "TUTOR"){
                                        $result .= _lang("Tutor").": ".$tutor_chat_count." / ".$site_info["chat_limit"]." "._lang("Date").": ".$chat["sent_date"]."&nbsp;";
                                        $tutor_chat_count++;
                                    }else {
                                        $result .= _lang("Student").": ".$student_chat_count." / ".$site_info["chat_limit"]." "._lang("Date").": ".$chat["sent_date"]."&nbsp;";
                                        $student_chat_count++;
                                    }
                                $result .='
                                </div>
                            </div>
                            <div class="col-xs-2 tr padding0">';
                                if ($user_type == "TUTOR") {
                                    $result .= '<img src="../file/teacher/'.$chat["profilephoto_path"].'" style="height: 50px;">';
                                } else {
                                    $result .= '<img src="dist/img/user2-160x160.jpg" style="height: 50px;">';
                                }
                            $result .= '</div>';
                         } else {
                            $result .= '<div class="col-xs-2 trl padding0">';
                                if ($user_type == "STUDENT") {
                                    $result .= '<img src="../file/teacher/'.$chat["profilephoto_path"].'" style="height: 50px;">';
                                } else {
                                    $result .= '<img src="dist/img/user2-160x160.jpg" style="height: 50px;">';
                                }
                            $result .= '</div>
                            <div class="col-xs-10 " style="border: 1px solid #000; padding: 0; ">
                                <div style="padding-left: 5px;">
                                    '.nl2br($chat["content"]).'
                                </div>
                                <div class="tr">';
                                    if($chat["from_role"] == "TUTOR"){
                                        $result .= _lang("Tutor").": ".$tutor_chat_count." / ".$site_info["chat_limit"]." "._lang("Date").": ".$chat["sent_date"]."&nbsp;";
                                        $tutor_chat_count++;
                                    }else {
                                        $result .= _lang("Student").": ".$student_chat_count." / ".$site_info["chat_limit"]." "._lang("Date").": ".$chat["sent_date"]."&nbsp;";
                                        $student_chat_count++;
                                    }
                                $result .='
                                </div>
                            </div>';
                        }
                        $result .= "</div>";
        }
        if(!empty($chats) && $approved_chat > 0){
            $result .= "<div class='tr'>"._lang("Chat History")."</div>";
        }else{
            $result .= _lang("No chats");
        }
        $json = new Services_JSON();
        $jsonReturnArr['result'] = $result;

        if($chats[0]["from_role"] == "TUTOR"){
            $jsonReturnArr['form_type'] = 'tutor';
            $jsonReturnArr['tutor_id'] = $chats[0]["from_id"];
            $jsonReturnArr['student_id'] = $chats[0]["to_id"];
        }else if($chats[0]["from_role"] == "STUDENT"){
            $jsonReturnArr['form_type'] = 'student';
            $jsonReturnArr['student_id'] = $chats[0]["from_id"];
            $jsonReturnArr['tutor_id'] = $chats[0]["to_id"];
        }
        
        $sql        = "select * from master_type_code as tt where typeid = ? and deleted = ? and (select count(*) from master_type_code as tb where typeid = 'TEACH_POSITIONCODE' and extra1 = tt.code and deleted = 0 and (select count(*) from student_postjoblearndistrict where studentpostjob_id = '".$job_id."' and mas_teachareacode = tb.id and deleted = 0) > 0) > 0";
        $parameters = array('TEACH_AREACODE', 0);
        $rows_area  = bind_pdo($sql, $parameters, "selectall");
        
        $row_job = get_studentpostjob($job_id);
        
        $jsonReturnArr['learnAreaBox'] = '<select class="form-control" name="mas_residencecode" data-value="">
                                            <option value=""></option>';
                                            if(is_array($rows_area)){
                                            foreach ($rows_area as $row_area) {
                                                $sql           = "select * from master_type_code as tb where typeid = ? and extra1 = ? and deleted = ? and (select count(*) from student_postjoblearndistrict where studentpostjob_id = '".$job_id."' and mas_teachareacode = tb.id and deleted = 0) > 0";
                                                $parameters    = array('TEACH_POSITIONCODE', $row_area['code'], 0);
                                                $rows_position = bind_pdo($sql, $parameters, "selectall");
        $jsonReturnArr['learnAreaBox'] .= '<optgroup label="'.$row_area['name_cn'].'">';
                                            if(is_array($rows_position)){
                                                foreach ($rows_position as $row_position) {
                                                    $jsonReturnArr['learnAreaBox'] .= '<option value="'.$row_position['id'].'">'.$row_position['name_cn'].'</option>';
                                                }
                                            }
        $jsonReturnArr['learnAreaBox'] .= '</optgroup>';
        /**/
                                            }}
        $jsonReturnArr['learnAreaBox'] .= '</select>';
        
        $jsonReturnArr['learnTimeBox'] = '<select class="form-control" name="course_length">
                                              <option value="">-</option>';
                                          if ($row_job['30mins_min_budget'] || $row_job['30mins_max_budget']) {
        $jsonReturnArr['learnTimeBox'] .= '<option value="30">30分鐘</option>';
                                          }
                                          if ($row_job['45mins_min_budget'] || $row_job['45mins_max_budget']) {
        $jsonReturnArr['learnTimeBox'] .= '<option value="45">45分鐘</option>';
                                          }
                                          if ($row_job['60mins_min_budget'] || $row_job['60mins_max_budget']) {
        $jsonReturnArr['learnTimeBox'] .= '<option value="60">60分鐘</option>';
                                          }
        $jsonReturnArr['learnTimeBox'] .= '</select>';
        
        $jsonReturnArr['job_id'] = $job_id;
        echo $json->encode($jsonReturnArr);
    } else if ($data['ajax'] == 'test_fee') {        
        $job_id                = (int)$_POST["job_id"];
        $tutor_id            = (int)$_POST["tutor_id"];
        $mas_residencecode  = (int)$_POST["mas_residencecode"];
        $course_length         = (int)$_POST["course_length"];
        $json = new Services_JSON();
        if( $mas_residencecode && $course_length){
            $sql        = "select mas_instrument from student_postjob as tt where id = ? and deleted = ?";
            $parameters = array($job_id, 0);
            $row_job  = bind_pdo($sql, $parameters, "selectone");
            
            $sql        = "select studenhome_addcharge as fee from tutor_teachareacode as tt where mas_teachareacode = ? and tutormain_id = ? and deleted = ?";
            $parameters = array($mas_residencecode,$tutor_id, 0);
            $row_addcharge  = bind_pdo($sql, $parameters, "selectone");
            
            $sql        = "select id from tutor_charge as tt where tutormain_id = ? and mas_instrument = ? and deleted = ?";
            $parameters = array($job_id,$row_job['mas_instrument'], 0);
            $row_charge  = bind_pdo($sql, $parameters, "selectone");
            
            $sql        = "select charge_".$course_length."min as fee from tutor_expectcharge where type = ? and charge_id = ? and deleted = ?";
            $parameters = array('tfee',$row_charge['id'], 0);
            $row_expectcharge  = bind_pdo($sql, $parameters, "selectone");
            
            $jsonReturnArr['fee'] = $row_addcharge['fee']+$row_expectcharge['fee'];
            
        }else{
            $jsonReturnArr['fee'] = '';
        }
        echo $json->encode($jsonReturnArr);
    }else if($data['ajax'] == 'testcourse_submit'){
        
        $json = new Services_JSON();
        $job_id                = (int)$_POST["job_id"];
        $tutor_id            = (int)$_POST["tutor_id"];
        $student_id            = (int)$_POST["student_id"];
        $address              = $_POST["address"];
        $datetime1             = $_POST["datetime1"];
        $datetime2             = $_POST["datetime2"];
        $mas_residencecode  = (int)$_POST["mas_residencecode"];
        $course_length         = (int)$_POST["course_length"];
        $course_count        = 0;
        $form_type             = $_POST["form_type"];
        if($datetime1){
            $course_count++;
        }
        if($datetime2){
            $course_count++;
        }
        
        $job_id                = 2;
        $tutor_id            = 2;
        $student_id            = 4;
        $datetime1             = '2016-10-26 09:00:00';
        $datetime2             = '2016-10-28 09:00:00';
        $mas_residencecode  = 37;
        $course_length         = 30;
        $course_count        = 2;
        $course_venus      = 6;
        $level             = 2;
        $form_type             = 'tutor';
        
        $datetime[] = '2016-10-26 09:00:00';
        $datetime[] = '2016-10-26 09:00:00';
        
        if ($mas_residencecode && $datetime1 && $datetime2 && $mas_residencecode && $course_length && $course_venus && $level) {
            $sql        = "select count(*) as count from `order` where tutormain_id = ? and studentmain_id = ? and (status = 'paid' or status = 'reject' or status = 'process') and deleted = 0";
            $parameters = array($tutor_id, $student_id);
            $row_order  = bind_pdo($sql, $parameters, "selectone");
            if ($row_order['count'] < 1) {

                $sql         = "select count(*)+1 as maxcount from `order`";
                $parameters  = array();
                $row_orderno = bind_pdo($sql, $parameters, "selectone");

                $sql        = "select mas_instrument from student_postjob as tt where id = ? and deleted = ?";
                $parameters = array($job_id, 0);
                $row_job    = bind_pdo($sql, $parameters, "selectone");
                
                if($course_venus == 6){
                    $sql           = "select studenhome_addcharge as fee from tutor_teachareacode as tt where mas_teachareacode = ? and tutormain_id = ? and deleted = ?";
                    $parameters    = array($mas_residencecode, $tutor_id, 0);
                    $row_addcharge = bind_pdo($sql, $parameters, "selectone");
                }
                $sql        = "select id from tutor_charge as tt where tutormain_id = ? and mas_instrument = ? and deleted = ?";
                $parameters = array($job_id, $row_job['mas_instrument'], 0);
                $row_charge = bind_pdo($sql, $parameters, "selectone");

                $sql              = "select charge_" . $course_length . "min as fee from tutor_expectcharge where type = ? and charge_id = ? and deleted = ?";
                $parameters       = array('tfee', $row_charge['id'], 0);
                $row_expectcharge = bind_pdo($sql, $parameters, "selectone");

                $order_data['id']                = $row_orderno['maxcount'];
                $order_data['order_type']        = 'try';
                $order_data['order_no']          = 'OT' . date('ym') . sprintf("%06d", $row_orderno['maxcount']);
                $order_data['studentmain_id']    = $student_id;
                $order_data['tutormain_id']      = $tutor_id;
                $order_data['job_id']            = $job_id;
                $order_data['address']           = $address;
                $order_data['mas_residencecode'] = $mas_residencecode;
                $order_data['course_count']      = $course_count;
                $order_data['course_length']     = $course_length;
                $order_data['extra_fee']         = $row_expectcharge['fee'];
                $order_data['fee']               = $row_addcharge['fee'];
                $order_data['total_fee']         = ($row_addcharge['fee'] + $row_expectcharge['fee']) * $course_count;
                $order_data['from_type']         = $from_type;
                $order_data['first_chat_id']     = $first_chat_id;
                $order_data['createdate']        = date("Y-m-d H:i:s");
                $order_data['status']            = 'process';
                $sql                             = mysql_install($order_data, 'order', 'add');
                $arraykey                        = array_keys($order_data);
                unset($parameters);
                for ($i = 0; $i < count($arraykey); $i++) {
                    $parameters[$i] = $order_data[$arraykey[$i]];
                }
                echo $sql;
                //bind_pdo($sql, $parameters);

                for ($a = 0; $a < $course_count; $a++) {
                    unset($tmp_order_data);
                    $tmp_order_data['order_id']       = $order_data['id'];
                    $tmp_order_data['datetime']       = $datetime[$a];
                    $tmp_order_data['teacher_status'] = 0;
                    $tmp_order_data['student_status'] = 0;
                    $sql                              = mysql_install($tmp_order_data, 'order_detail', 'add');
                    $arraykey                         = array_keys($tmp_order_data);
                    unset($parameters);
                    for ($i = 0; $i < count($arraykey); $i++) {
                        $parameters[$i] = $tmp_order_data[$arraykey[$i]];
                    }
                    //bind_pdo($sql, $parameters);
                }
                //$jsonReturnArr['sql']    = $sql.$row_orderno['maxcount'];
                $jsonReturnArr['status'] = true;
            } else {
                $jsonReturnArr['status'] = false;
            }
            echo $json->encode($jsonReturnArr);
        }
    }