| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/hkosl.com/m.musiccircle/ |
Upload File : |
<?php
include('_init.php');
if (empty($_SESSION['member_login']) && empty($_SESSION['student_login'])) {
header("Location: index.php");
exit;
}
$sql = "select * from wish_list where cmsloginid = ? and status = ? order by createdate DESC";
$parameters = array($_SESSION["cmsloginid"], 1);
$result = bind_pdo($sql, $parameters, "selectall");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php include('_head.php'); ?>
<link href="css/style_k.css?v=<?= time(); ?>" type="text/css" rel="stylesheet">
</head>
<body>
<?php include('_header.php') ?>
<?php include('_dialog.php') ?>
<div class="ProfileContent">
<div class="Profilecontainer">
<div class="row">
<div class="col-md-12">
<?php foreach ($result as $row) {
if (!empty($_SESSION["member_login"])) { //list my wish job
//get job info
$where_clause = " and student_postjob.id = ?";
$parameters = array(1, 0, 1, 4, 0, 1, $row["ref_id"]);
$sql = "select *,student_postjob.id as student_postjob_id, master_type_code.name_" . $langcode . " as instrument_name from student_postjob
INNER JOIN student_main ON student_main.id = student_postjob.studentmain_id
INNER JOIN student_postjoblearndistrict ON student_postjoblearndistrict.studentpostjob_id = student_postjob.id
INNER JOIN master_type_code ON master_type_code.id = student_postjob.mas_instrument
where student_postjob.status = ? and student_postjob.deleted = ? and student_postjob.approved = ? and student_main.status = ? and student_main.deleted = ? and student_main.approved = ? {$where_clause}";
$job = bind_pdo($sql, $parameters, "selectone");
if (!empty($job)) {
//budget
$_30mins = "";
$_45mins = "";
$_60mins = "";
if (!empty($job["30mins_min_budget"]) && !empty($job["30mins_max_budget"])) {
$_30mins = "30" . _lang("mins") . ": $" . $job["30mins_min_budget"] . ' - ' . $job["30mins_max_budget"] . ', ';
} else {
if (!empty($job["30mins_min_budget"]) && empty($job["30mins_max_budget"])) {
$_30mins = "30" . _lang("mins") . ": " . _lang("Above") . " $" . $job["30mins_min_budget"] . ', ';
}
if (empty($job["30mins_min_budget"]) && !empty($job["30mins_max_budget"])) {
$_30mins = "30" . _lang("mins") . ": " . _lang("Below") . " $" . $job["30mins_max_budget"] . ', ';
}
}
if (!empty($job["45mins_min_budget"]) && !empty($job["45mins_max_budget"])) {
$_45mins = "45" . _lang("mins") . ": $" . $job["45mins_min_budget"] . ' - ' . $job["45mins_max_budget"] . ', ';
} else {
if (!empty($job["45mins_min_budget"]) && empty($job["45mins_max_budget"])) {
$_45mins = "45" . _lang("mins") . ": " . _lang("Above") . " $" . $job["45mins_min_budget"] . ', ';
}
if (empty($job["45mins_min_budget"]) && !empty($job["45mins_max_budget"])) {
$_45mins = "45" . _lang("mins") . ": " . _lang("Below") . " $" . $job["45mins_max_budget"] . ', ';
}
}
if (!empty($job["60mins_min_budget"]) && !empty($job["60mins_max_budget"])) {
$_60mins = "60" . _lang("mins") . ": $" . $job["60mins_min_budget"] . ' - ' . $job["60mins_max_budget"] . ', ';
} else {
if (!empty($job["60mins_min_budget"]) && empty($job["60mins_max_budget"])) {
$_60mins = "60" . _lang("mins") . ": " . _lang("Above") . " $" . $job["60mins_min_budget"] . ', ';
}
if (empty($job["60mins_min_budget"]) && !empty($job["60mins_max_budget"])) {
$_60mins = "60" . _lang("mins") . ": " . _lang("Below") . " $" . $job["60mins_max_budget"] . ', ';
}
}
} else {
continue;
}
//district
$sql = "select * from student_postjoblearndistrict
INNER JOIN master_type_code ON master_type_code.id = student_postjoblearndistrict.mas_teachareacode
where student_postjoblearndistrict.deleted = ? and student_postjoblearndistrict.studentpostjob_id = ?";
$parameters = array(0, $job["student_postjob_id"]);
$result = bind_pdo($sql, $parameters, "selectall");
$student_postjoblearndistrict_master = array();
$student_postjoblearndistrict_master_text = "";
if (!empty($result)) {
foreach ($result as $row2) {
$teachareacode = get_master_type_code("TEACH_AREACODE", $row2["extra1"]);
$teachareacode = $teachareacode["name_" . $langcode];
if (!in_array($teachareacode, $student_postjoblearndistrict_master)) {
$student_postjoblearndistrict_master[] = $teachareacode;
}
}
}
if (!empty($student_postjoblearndistrict_master)) {
foreach ($student_postjoblearndistrict_master as $key3 => $row3) {
$student_postjoblearndistrict_master_text .= $row3;
if (($key3 + 1) != count($student_postjoblearndistrict_master)) {
$student_postjoblearndistrict_master_text .= " / ";
}
}
} else {
$student_postjoblearndistrict_master_text = _lang("N/A");
}
?>
<div class="row" style="border-bottom: 1px solid #ccc;margin-bottom: 15px;">
<div class="col-xs-3" style="padding: 0;">
<?php
echo "<a href='job_detail.php?id=" . $job["student_postjob_id"] . "' style='color: inherit;'><img src='" . $site_info["url"] . "img/instrument/" . $job["extra3"] . "' style='width: 100%;'></a>";
?>
</div>
<div class="col-xs-7">
<?php
echo "<a href='job_detail.php?id=" . $job["student_postjob_id"] . "' style='color: inherit;'>";
echo _lang("Musical Instrument") . ": " . $job["instrument_name"] . "<br>";
echo _lang("Learning Level") . ": " . $job["level"] . "<br>";
echo _lang("Tutorial Budget") . ": " . $_30mins . $_45mins . $_60mins . "<br>";
echo _lang("Expected Tutorial District") . ": " . $student_postjoblearndistrict_master_text;
echo "</a>";
?>
</div>
<div class="col-xs-2">
<?php if (!empty($_SESSION["cmsloginid"])) {
$my_wish = check_my_wish($row["type"], $row["ref_id"]);
if ($my_wish) {
$color = "color: #CC1342;";
} else {
$color = "";
}
} ?>
<div id="my_wish" style="<?= $color ?> position: relative; top: 0; right: 0; " onclick="my_wish('<?= $row["type"] ?>', '<?= $row["ref_id"] ?>', this);">
<span class="glyphicon glyphicon-heart" aria-hidden="true"></span></div>
</div>
</div>
<?php
}
else
if (!empty($_SESSION["student_login"])) { //list my wish tutor
$sql = "select *,tutor_main.id as id2, mtcode1.name_en as residence_en, mtcode1.name_cn as residence_cn, mtcode1.extra1 as residence_master from tutor_main
INNER JOIN master_type_code mtcode1 ON mtcode1.id = tutor_main.mas_residencecode
where tutor_main.id = ? and tutor_main.status = ? and tutor_main.deleted = ? and tutor_main.approved = ?";
$parameters = array($row["ref_id"], 4, 0, 1);
$tutor = bind_pdo($sql, $parameters, "selectone");
$tutor_year_range_info = get_tutor_year_range($tutor["dob_year"], $tutor["dob_mon"]);
$tutor_year_range = $tutor_year_range_info["tutor_year_range"];
$teaching_area_master = array();
$teaching_area = get_teaching_area($row["ref_id"]);
foreach ($teaching_area as $row2) {
$teachareacode = get_master_type_code("TEACH_AREACODE", $row2["extra1"]);
$teachareacode = $teachareacode["name_" . $langcode];
if (!in_array($teachareacode, $teaching_area_master)) {
$teaching_area_master[] = $teachareacode;
}
}
$teaching_instrument = get_teaching_instrument($row["ref_id"]);
?>
<div class="row" style="border-bottom: 1px solid #ccc;margin-bottom: 15px;">
<div class="col-xs-3" style="padding: 0;">
<?php
if (!empty($tutor["profilephoto_path"])) {
echo '<a href="profile.php?id=' . $row["ref_id"] . '" style="color: inherit;"><img class="tutor_img2" style="width: 100%;" src="' . $site_info["url"] . 'file/teacher/' . $tutor["profilephoto_path"] . '"></a>';
}
?>
</div>
<div class="col-xs-7">
<?php
echo '<a href="profile.php?id=' . $row["ref_id"] . '" style="color: inherit;">';
echo $tutor["nickname"] . "<br>";
echo _lang("Tutor Code") . ": " . $tutor["tutor_no"] . "<br>";
echo _lang("Gender") . ": " . ($tutor["gender"] == "m" ? _lang("Male") : _lang("Female")) . " " . _lang("Age") . ": " . $tutor_year_range . "<br>";
echo strtolower(_lang("WHERE I TEACH")) . ": ";
foreach ($teaching_area_master as $key => $row2) {
echo $row2;
if (($key + 1) != count($teaching_area_master)) {
echo " / ";
}
}
echo "<br>";
echo strtolower(_lang("TEACHING MUSICAL INSTRUMENTS")).": ";
if (!empty($teaching_instrument)) {
foreach ($teaching_instrument as $key => $row2) {
echo $row2["name_" . $langcode];
if (($key + 1) != count($teaching_instrument)) {
echo ", ";
}
}
}
echo "</a>";
?>
</div>
<div class="col-xs-2">
<?php if (!empty($_SESSION["cmsloginid"])) {
$my_wish = check_my_wish($row["type"], $row["ref_id"]);
if ($my_wish) {
$color = "color: #CC1342;";
} else {
$color = "";
}
} ?>
<div id="my_wish" style="<?= $color ?> position: relative; top: 0; right: 0; " onclick="my_wish('<?= $row["type"] ?>', '<?= $row["ref_id"] ?>', this);">
<span class="glyphicon glyphicon-heart" aria-hidden="true"></span></div>
</div>
</div>
<?php }
} ?>
<br><br><br>
</div>
</div>
</div>
</div>
<? include('_footer.php') ?>
<script>
function my_wish(type, id, _this) {
jQuery.ajax({
url: '_ajax.php',
type: 'POST',
data: {
ajax: "my_wish",
type: type,
id: id,
},
dataType: 'html', //dataType (default: Intelligent Guess (xml, json, script, or html))
timeout: 1000,
error: function (result) {
//alert('Error Occur. Please try again.');
//console.log(result.responseText);
},
success: function (result) {
console.log(result);
if (result == "1") {
//change heart color
$(_this).css("color", "#CC1342");
} else {
$(_this).css("color", "#ccc");
}
}
});
}
</script>
</body>
</html>