function get_dokter($id) {
$kon = new Konek;
$kon->sql = "
SELECT
d.id as id,
d.nama as nama,
d.alamat as alamat,
d.telp as telp,
d.aktif as aktif,
sub.id as sub_id,
sub.spesialisasi_id as spc_id
FROM
dokter d
JOIN subspesialisasi sub ON (sub.id = d.subspesialisasi_id)
WHERE
d.id = '".$id."'";
$kon->execute();
$data = $kon->getOne();
$objResponse = new xajaxResponse();
$objResponse->addAssign("id_dokter", "value", $data[id]);
$objResponse->addAssign("spesialisasi_id", "value", $data[spc_id]);
$objResponse->addScriptCall("xajax_ref_get_subspesialisasi", "subspesialisasi_id", $data[spc_id], $data[sub_id]);
$objResponse->addAssign("nama", "value", $data[nama]);
$objResponse->addAssign("alamat", "value", $data[alamat]);
$objResponse->addAssign("telp", "value", $data[telp]);
$objResponse->addAssign("aktif", "value", $data[aktif]);
$objResponse->addScriptCall("fokus", "spesialisasi_id");
return $objResponse;
}
function init()
{
global $locate, $config;
$objResponse = new xajaxResponse();
$objResponse->addAssign("divNav", "innerHTML", common::generateManageNav($skin, $_SESSION['curuser']['country'], $_SESSION['curuser']['language']));
$objResponse->addAssign("divCopyright", "innerHTML", common::generateCopyright($skin));
return $objResponse;
}
function BlockPlayer($check, $sid, $num, $type, $length)
{
$objResponse = new xajaxResponse();
global $userbank, $username;
$sid = (int) $sid;
$length = (int) $length;
if (!$userbank->HasAccess(ADMIN_OWNER | ADMIN_ADD_BAN)) {
$objResponse->redirect("index.php?p=login&m=no_access", 0);
$log = new CSystemLog("w", "Hacking Attempt", $username . " tried to process a playerblock, but doesnt have access.");
return $objResponse;
}
//get the server data
$sdata = $GLOBALS['db']->GetRow("SELECT ip, port, rcon FROM " . DB_PREFIX . "_servers WHERE sid = '" . $sid . "';");
//test if server is online
if ($test = @fsockopen($sdata['ip'], $sdata['port'], $errno, $errstr, 2)) {
@fclose($test);
require_once INCLUDES_PATH . "/CServerRcon.php";
$r = new CServerRcon($sdata['ip'], $sdata['port'], $sdata['rcon']);
if (!$r->Auth()) {
$GLOBALS['db']->Execute("UPDATE " . DB_PREFIX . "_servers SET rcon = '' WHERE sid = '" . $sid . "' LIMIT 1;");
$objResponse->addAssign("srv_{$num}", "innerHTML", "<font color='red' size='1'>Wrong RCON Password, please change!</font>");
$objResponse->addScript('set_counter(1);');
return $objResponse;
}
$ret = $r->rconCommand("status");
// show hostname instead of the ip, but leave the ip in the title
require_once "../includes/system-functions.php";
$hostsearch = preg_match_all('/hostname:[ ]*(.+)/', $ret, $hostname, PREG_PATTERN_ORDER);
$hostname = trunc(htmlspecialchars($hostname[1][0]), 25, false);
if (!empty($hostname)) {
$objResponse->addAssign("srvip_{$num}", "innerHTML", "<font size='1'><span title='" . $sdata['ip'] . ":" . $sdata['port'] . "'>" . $hostname . "</span></font>");
}
$gothim = false;
$search = preg_match_all(STATUS_PARSE, $ret, $matches, PREG_PATTERN_ORDER);
//search for the steamid on the server
foreach ($matches[3] as $match) {
if (substr($match, 8) == substr($check, 8)) {
// gotcha!!! kick him!
$gothim = true;
$GLOBALS['db']->Execute("UPDATE `" . DB_PREFIX . "_comms` SET sid = '" . $sid . "' WHERE authid = '" . $check . "' AND RemovedBy IS NULL;");
$requri = substr($_SERVER['REQUEST_URI'], 0, strrpos($_SERVER['REQUEST_URI'], "pages/admin.blockit.php"));
$kick = $r->sendCommand("sc_fw_block " . $type . " " . $length . " " . $match);
$objResponse->addAssign("srv_{$num}", "innerHTML", "<font color='green' size='1'><b><u>Player Found & blocked!!!</u></b></font>");
$objResponse->addScript("set_counter('-1');");
return $objResponse;
}
}
if (!$gothim) {
$objResponse->addAssign("srv_{$num}", "innerHTML", "<font size='1'>Player not found.</font>");
$objResponse->addScript('set_counter(1);');
return $objResponse;
}
} else {
$objResponse->addAssign("srv_{$num}", "innerHTML", "<font color='red' size='1'><i>Can't connect to server.</i></font>");
$objResponse->addScript('set_counter(1);');
return $objResponse;
}
}
function objectscount($fid, $confid)
{
$objResponse = new xajaxResponse();
$pp = do_objectscount($fid, $confid);
//½«ÌíÈëÊýÁ¿
$objResponse->addAssign("objectnum", "disabled", false);
$objResponse->addAssign("objectnum", "value", $pp);
$objResponse->addAssign("max", "value", $pp);
$objResponse->addAssign("doit", "disabled", false);
return $objResponse->getXML();
}
/**
* OpenX Schema Management Utility
*/
function onclickUpOrDown($param)
{
$objResponse = new xajaxResponse();
if ($param == 'up') {
$objResponse->addAssign('img_up', "style.display", 'none');
$objResponse->addAssign('img_down', "style.display", 'inline');
} else {
$objResponse->addAssign('img_up', "style.display", 'inline');
$objResponse->addAssign('img_down', "style.display", 'none');
}
return $objResponse;
}
function get_bhp($id) {
$kon = new Konek;
$kon->sql = "SELECT id, nama, biaya FROM bhp WHERE id = '".$id."'";
$kon->execute();
$data = $kon->getOne();
$objResponse = new xajaxResponse();
$objResponse->addAssign("id_bhp", "value", $data[id]);
$objResponse->addAssign("nama", "value", $data[nama]);
$objResponse->addAssign("biaya", "value", $data[biaya]);
$objResponse->addScriptCall("fokus", "nama");
return $objResponse;
}
function sendmail($formValues, $mailbody)
{
$resp = new xajaxResponse();
$resp->addAssign("state", "innerHTML", "<img src=\"images/loading.gif\">正在发送...");
if (send_mail($formValues['mailto'], $formValues['subject'], $mailbody)) {
$resp->addAssign("state", "innerHTML", "");
$resp->addAlert("send ok");
} else {
$resp->addAlert($mailbody);
}
return $resp;
}
function get_pelayanan($id) {
$kon = new Konek;
$kon->sql = "SELECT * FROM pelayanan WHERE id = '".$id."'";
$kon->execute();
$data = $kon->getOne();
$objResponse = new xajaxResponse();
$objResponse->addAssign("id_pelayanan", "value", $data[id]);
$objResponse->addAssign("nama", "value", $data[nama]);
$objResponse->addAssign("spesialisasi_id", "value", $data[spesialisasi_id]);
$objResponse->addAssign("hari_buka", "value", $data[hari_buka]);
$objResponse->addScriptCall("fokus", "nama");
return $objResponse;
}
function doSearch($formValues)
{
$res = new xajaxResponse();
$inputsMissing = false;
//do check wheter all needed parameters have been set before klicking GO
if ($formValues['dep_country_select'] == "invalid") {
$inputsMissing = true;
} elseif ($formValues['arv_country_select'] == "invalid") {
$inputsMissting = true;
} elseif ($formValues['arv_region_select'] == "invalid") {
$inputsMissing = true;
} elseif ($formValues['dep_region_select'] == "invalid") {
$inputsMissing = true;
} elseif ($formValues['arv_apcode_select'] == "invalid") {
$inputsMissing = true;
} elseif ($formValues['dep_apcode_select'] == "invalid") {
$inputsMissing = true;
}
if ($inputsMissing) {
$res->addAssign("contentView", "innerHTML", "At least one of the specified arguments is invalid");
return $res;
}
$flightDays = "%%%%%%%";
if (!isset($formValues['flyOnAnyDay'])) {
/*checkbox fly on any Day is not checked*/
foreach ($formValues['weekDay'] as $day) {
$flightDays[$day - 1] = $day;
}
}
$returnRoute = false;
if (isset($formValues['return_route'])) {
$returnRoute = true;
}
$rtModel = new RoutesModel();
$searchResults = $rtModel->doSearch($formValues['dep_apcode_select'], $formValues['arv_apcode_select'], $flightDays, $returnRoute);
//Got the results. Now make a table and show results within that table in contentView div
$resultTable = "<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">\n";
$resultTable .= "<thead<tr><th>Airline</th><th>IATA Code</th><th>Flight Number</th><th>Depart From</th>\n";
$resultTable .= "<th>Arrive To</th><th>Departure Time</th><th>Arrival Time</th><th>Days later</th><th>On Days</th>\n";
$resultTable .= "</tr></thead><tbody>";
foreach ($searchResults as $key => $result) {
$resultTable .= "<tr>";
foreach ($result as $resultKey => $resultValue) {
$resultTable .= "<td style=\"text-align:center;\">" . $resultValue . "</td>";
}
$resultTable .= "</tr>\n";
}
$resultTable .= "</tbody></table>\n";
$res->addAssign("contentView", "innerHTML", $resultTable);
return $res;
}
function AJAXCheckMail($mail)
{
$objResponse = new xajaxResponse();
if (empty($mail)) {
$objResponse->addAssign("checkmail", "innerHTML", tra("empty"));
} else {
if (!eregi("^[_a-z0-9\\.\\-]+@[_a-z0-9\\.\\-]+\\.[a-z]{2,4}\$", $mail)) {
$objResponse->addAssign("checkmail", "innerHTML", tra('This is not a valid mail adress'));
} else {
$objResponse->addAssign("checkmail", "innerHTML", tra('Valid') . ' ' . tra('mail adress'));
}
}
return $objResponse;
}
function get_karcis($id) {
$kon = new Konek;
$kon->sql = "SELECT * FROM karcis WHERE id = '".$id."'";
$kon->execute();
$data = $kon->getOne();
$objResponse = new xajaxResponse();
/*
$data[$i][kelas],
$data[$i][biaya_bhp],
$data[$i][biaya_jasa],
$data[$i][bhp_p],
$data[$i][bhp_rs],
$data[$i][bhp_rs_adm],
$data[$i][bhp_rs_op],
$data[$i][jasa_p],
$data[$i][jasa_rs],
$data[$i][jasa_rs_op],
$data[$i][jasa_rs_kembang],
$data[$i][jasa_rs_adm],
$data[$i][jasa_rs_sdm],
$data[$i][spesialis],
$data[$i][spesialis_pendamping],
$data[$i][ugp],
$data[$i][grabaf],
$data[$i][perawat],
$data[$i][penunjang],
$data[$i][zakat],
$data[$i][pajak],
$data[$i][netto],
*/
$objResponse->addAssign("id_karcis", "value", $data[id]);
$objResponse->addAssign("nama", "value", $data[nama]);
$objResponse->addAssign("jenis", "value", $data[jenis]);
$objResponse->addAssign("kelas", "value", $data[kelas]);
$objResponse->addAssign("biaya_bhp", "value", $data[biaya_bhp]);
$objResponse->addAssign("biaya_jasa", "value", $data[biaya_jasa]);
$objResponse->addAssign("bhp_p", "value", $data[bhp_p]);
$objResponse->addAssign("bhp_rs", "value", $data[bhp_rs]);
$objResponse->addAssign("bhp_rs_adm", "value", $data[bhp_rs_adm]);
$objResponse->addAssign("bhp_rs_op", "value", $data[bhp_rs_op]);
$objResponse->addAssign("jasa_p", "value", $data[jasa_p]);
$objResponse->addAssign("jasa_rs", "value", $data[jasa_rs]);
$objResponse->addAssign("jasa_rs_op", "value", $data[jasa_rs_op]);
$objResponse->addAssign("jasa_rs_kembang", "value", $data[jasa_rs_kembang]);
$objResponse->addAssign("jasa_rs_adm", "value", $data[jasa_rs_adm]);
$objResponse->addAssign("jasa_rs_sdm", "value", $data[jasa_rs_sdm]);
$objResponse->addAssign("spesialis", "value", $data[spesialis]);
$objResponse->addAssign("spesialis_pendamping", "value", $data[spesialis_pendamping]);
$objResponse->addAssign("ugp", "value", $data[ugp]);
$objResponse->addAssign("grabaf", "value", $data[grabaf]);
$objResponse->addAssign("perawat", "value", $data[perawat]);
$objResponse->addAssign("penunjang", "value", $data[penunjang]);
$objResponse->addAssign("zakat", "value", $data[zakat]);
$objResponse->addAssign("pajak", "value", $data[pajak]);
$objResponse->addAssign("netto", "value", $data[netto]);
$objResponse->addScriptCall("fokus", "nama");
return $objResponse;
}
function showEditEmpStatForm($estatCode)
{
$view_controller = new ViewController();
$editArr = $view_controller->xajaxObjCall($estatCode, 'JOB', 'editEmpStat');
$objResponse = new xajaxResponse();
$objResponse->addScript("document.frmJobTitle.txtEmpStatDesc.disabled = false;");
$objResponse->addScript("document.frmJobTitle.txtEmpStatID.value = '" . $editArr[0][0] . "';");
$objResponse->addScript("document.frmJobTitle.txtEmpStatDesc.value = '" . $editArr[0][1] . "';");
$objResponse->addScript("document.frmJobTitle.txtEmpStatDesc.focus();");
$objResponse->addScript("document.frmJobTitle.txtEmpStatDesc.selectAll();");
$objResponse->addScript("document.getElementById('layerEmpStat').style.visibility='visible';");
$objResponse->addAssign('buttonLayer', 'innerHTML', "<input type='button' value='" . $GLOBALS['lang_Common_Save'] . "' onclick='editFormData();'>");
$objResponse->addAssign('status', 'innerHTML', '');
return $objResponse->getXML();
}
function deleteEntry($entry_id)
{
$CI =& get_instance();
$CI->load->model('feedback_model');
$xajax_response = new xajaxResponse();
if (is_numeric($entry_id) && $CI->feedback_model->DeleteFeedback($entry_id)) {
$xajax_response->addAssign('new_entries', 'innerHTML', $CI->feedback_model->GetFeedbackCount());
$xajax_response->addAssign('deleted_entries', 'innerHTML', $CI->feedback_model->GetFeedbackCount(1));
$xajax_response->addAssign('feedback' . $entry_id, 'innerHTML', 'DELETED!');
$xajax_response->addScript('Effect.BlindUp(\'container' . $entry_id . '\');');
} else {
$xajax_response->addAlert('Error deleting entry ' . $entry_id . ', reload the page and try again.');
}
return $xajax_response;
}
function simpan_propinsi($value) {
$kon = new Konek;
if(!$value['id_propinsi'])
$kon->sql = "INSERT INTO ref_propinsi(nama) VALUES ('".$value[nama]."')";
else
$kon->sql = "UPDATE ref_propinsi SET nama = '".$value[nama]."' WHERE id = '".$value[id_propinsi]."'";
$kon->execute();
$objResponse = new xajaxResponse();
$objResponse->addScriptCall("show_status_simpan");
$objResponse->addAssign("id_propinsi", "value", "");
$objResponse->addAssign("nama", "value", "");
$objResponse->addScriptCall("xajax_list_data", $_SESSION[setting_propinsi][hal]);
$objResponse->addScriptCall("fokus", "nama");
return $objResponse;
}
/**
* This function updates the progress bar
* @param div_id where the progress bar is displayed
* @param upload_id the identifier given in the field UPLOAD_IDENTIFIER
*/
function updateProgress($div_id, $upload_id, $waitAfterupload = false)
{
$objResponse = new xajaxResponse();
$ul_info = uploadprogress_get_info($upload_id);
$percent = intval($ul_info['bytes_uploaded'] * 100 / $ul_info['bytes_total']);
if ($waitAfterupload && $ul_info['est_sec'] < 2) {
$percent = 100;
$objResponse->addAssign($div_id . '_label', 'innerHTML', get_lang('UploadFile') . ' : ' . $percent . ' %');
$objResponse->addAssign($div_id . '_waiter_frame', 'innerHTML', '<img src="' . api_get_path(WEB_CODE_PATH) . 'img/progress_bar.gif" />');
$objResponse->addScript('clearInterval("myUpload.__progress_bar_interval")');
}
$objResponse->addAssign($div_id . '_label', 'innerHTML', get_lang('UploadFile') . ' : ' . $percent . ' %');
$objResponse->addAssign($div_id . '_filled', 'style.width', $percent . '%');
return $objResponse;
}
function tuitealo($form, $tipo)
{
if ($tipo == 'formulario') {
$formulario = formulario_areas('15', 'campos');
$descripcion = remplacetas('form_id', 'id', '15', 'descripcion', "");
$nombre = remplacetas('form_id', 'id', '15', 'nombre', "");
$formulario = "\n\n\t\t<h1 >{$nombre['0']}</h1>\n\t\t<h2>{$descripcion['0']}</h2>\n\t<form id='form_tuitealo' >\n\t {$formulario}\n\t<br>\n\n\t<div id='tuitealo_div'>\n\t\t<div id='tuitealo_error'></div>\n\t<a class='btn btn-block btn-primary' onclick=\"xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar');\">Previsualizar</a>\n\t</div>\n</form>\n\t</div>\n\t<br>\n\t<div class='text-center'>\n\t<p class='text-center'>Powered by: <a href='http://qwerty.co/milfs'>MIFS</a></p> \t\n\t</div>\n\n\t<br>\t\t\n\t\t\n\t\t";
return $formulario;
}
$respuesta = new xajaxResponse('utf-8');
$sujeto = $form[84][0];
$accion = $form[85][0];
$verbo = $form[86][0];
$tiempo = $form[87][0];
$ht = $form[88][0];
$mensaje = $form[83][0];
$arroba = $form[82][0];
if ($accion == "" or $verbo == "" or $tiempo == "" or $ht == "" or $arroba == "") {
$error = "<div class='alert alert-warning text-center'><h1><i class='fa fa-exclamation-triangle'></i> Hay campos vacíos</h1></div>";
$respuesta->addAssign("tuitealo_error", "innerHTML", "{$error}");
return $respuesta;
}
$arroba = remplacetas('form_datos', 'control', "{$arroba}", 'contenido', "id_campo = '77'");
$arroba = $arroba[0];
$url_propia = urlencode("http://patos.redpatodos.co");
$texto = "{$sujeto} {$accion} {$verbo} {$tiempo} {$ht} {$mensaje} cc {$arroba} ";
$texto = ucfirst($texto);
$texto_url = urlencode($texto);
$largo = strlen($texto . $url_propia);
if ($largo > 140) {
$alert = "danger";
$mensaje = "<i class='fa fa-exclamation-triangle'></i> El texto es demasiado largo y se recortará";
$texto = substr($texto, 0, 140) . "...";
} else {
$alert = 'success';
$mensaje = "";
}
$url = "https://twitter.com/share?url={$url_propia}&text={$texto_url}";
$previsualizar = "<br> \n\t\t\t\n\t\t<div id='tuitealo_error'></div>\t\n\t<div class='alert alert-{$alert}'><div class='badge'>{$largo}</div>{$mensaje}<h1>{$texto}</h1></div>\n\n\t<a class='btn btn-block btn-primary' onclick=\"xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar');\">Previsualizar</a>\n\t<a class='btn btn-block btn-success' onclick=\"xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'confirmar');\">Tuitéalo</a>\n\t<img style='width:1px;' src='milfs/images/100x100.png' \n\t\t\tonload=\"\n\t\t\tdocument.getElementById('82[0]').onchange = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\tdocument.getElementById('83[0]').onkeyup = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\tdocument.getElementById('84[0]').onchange = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\tdocument.getElementById('85[0]').onchange = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\tdocument.getElementById('86[0]').onchange = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\tdocument.getElementById('87[0]').onchange = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\tdocument.getElementById('88[0]').onchange = function(){xajax_tuitealo(xajax.getFormValues('form_tuitealo'),'previsualizar')};\n\t\t\t\n\t\t\t\" >\n\t";
if ($tipo == "previsualizar") {
$respuesta->addAssign("tuitealo_div", "innerHTML", "{$previsualizar}");
//$respuesta->addAlert("$texto $url");
} else {
///$respuesta->addAssign("tuitealo_div","innerHTML","$url");
$respuesta->addScript("window.location.href ='{$url}';");
}
return $respuesta;
}
function search_courses($needle, $type)
{
global $tbl_course, $tbl_course_rel_access_url, $user_id;
$xajax_response = new xajaxResponse();
$return = '';
if (!empty($needle) && !empty($type)) {
// xajax send utf8 datas... datas in db can be non-utf8 datas
$needle = Database::escape_string($needle);
$assigned_courses_to_hrm = CourseManager::get_courses_followed_by_drh($user_id);
$assigned_courses_code = array_keys($assigned_courses_to_hrm);
foreach ($assigned_courses_code as &$value) {
$value = "'" . $value . "'";
}
$without_assigned_courses = '';
if (count($assigned_courses_code) > 0) {
$without_assigned_courses = " AND c.code NOT IN(" . implode(',', $assigned_courses_code) . ")";
}
if (api_is_multiple_url_enabled()) {
$sql = "SELECT c.code, c.title\n FROM {$tbl_course} c\n\t\t\t\t\tLEFT JOIN {$tbl_course_rel_access_url} a\n ON (a.c_id = c.id)\n \tWHERE\n \t\tc.code LIKE '{$needle}%' {$without_assigned_courses} AND\n \t\taccess_url_id = " . api_get_current_access_url_id();
} else {
$sql = "SELECT c.code, c.title\n \t\tFROM {$tbl_course} c\n \tWHERE\n \t\tc.code LIKE '{$needle}%'\n \t\t{$without_assigned_courses} ";
}
$rs = Database::query($sql);
$return .= '<select id="origin" name="NoAssignedCoursesList[]" multiple="multiple" size="20" style="width:340px;">';
while ($course = Database::fetch_array($rs)) {
$return .= '<option value="' . $course['code'] . '" title="' . htmlspecialchars($course['title'], ENT_QUOTES) . '">' . $course['title'] . ' (' . $course['code'] . ')</option>';
}
$return .= '</select>';
$xajax_response->addAssign('ajax_list_courses_multiple', 'innerHTML', api_utf8_encode($return));
}
return $xajax_response;
}
function mostrarLibroMayor()
{
$objResponse = new xajaxResponse();
$controlCuenta = new ManejadorCuenta();
$recurso = $controlCuenta->consultarLibroMayor();
$resultado = '<table cellspacing="0" class="scrollTable">';
$resultado .= '<thead>';
$resultado .= '<tr>';
$resultado .= '<th>NUM</th>';
$resultado .= '<th>NOMBRE</th>';
$resultado .= '<th>DEBE</th>';
$resultado .= '<th>HABER</th>';
$resultado .= '<th>TOTAL</th>';
$resultado .= '</tr>';
$resultado .= '</thead>';
while ($row = mysql_fetch_array($recurso)) {
$total = 0;
if ($row[tipo] == 'A' || $row[tipo] == 'E') {
$total = $row[debe] - $row[haber];
} else {
$total = $row[haber] - $row[debe];
}
$resultado .= '<td>' . $row[num] . '</td>';
$resultado .= '<td>' . $row[nombre] . '</td>';
$resultado .= '<td>' . $row[debe] . '</td>';
$resultado .= '<td>' . $row[haber] . '</td>';
$resultado .= '<td>' . $total . '</td>';
$resultado .= '</tr>';
}
$resultado .= '</table>';
$objResponse->addAssign("librom", "innerHTML", $resultado);
return $objResponse;
}
function showNextHelp($nextpage)
{
$res = new xajaxResponse();
$iframe = "<iframe src=\"help/" . $nextpage . "\" name=\"helpIframe\">Your Browser doesn't support iframes</iframe>";
$res->addAssign("contentView", "innerHTML", $iframe);
return $res;
}
/**
* Search users by username, firstname or lastname, based on the given
* search string
* @param string Search string
* @param int Deprecated param
* @return string Xajax response block
* @assert () === false
*/
function search_users($needle, $id)
{
global $tbl_user, $tbl_access_url_rel_user;
$xajax_response = new xajaxResponse();
$return = '';
if (!empty($needle)) {
// xajax send utf8 datas... datas in db can be non-utf8 datas
$charset = api_get_system_encoding();
$needle = api_convert_encoding($needle, $charset, 'utf-8');
$needle = Database::escape_string($needle);
// search users where username or firstname or lastname begins likes $needle
$order_clause = api_sort_by_first_name() ? ' ORDER BY firstname, lastname, username' : ' ORDER BY lastname, firstname, username';
$sql = 'SELECT u.user_id, username, lastname, firstname FROM ' . $tbl_user . ' u ' . ' WHERE (username LIKE "' . $needle . '%" ' . ' OR firstname LIKE "' . $needle . '%" ' . ' OR lastname LIKE "' . $needle . '%") ' . $order_clause . ' LIMIT 11';
$rs = Database::query($sql);
$i = 0;
while ($user = Database::fetch_array($rs)) {
$i++;
if ($i <= 10) {
$return .= '<a href="javascript: void(0);" onclick="javascript: add_user_to_url(\'' . addslashes($user['user_id']) . '\',\'' . api_get_person_name(addslashes($user['firstname']), addslashes($user['lastname'])) . ' (' . addslashes($user['username']) . ')' . '\')">' . api_get_person_name($user['firstname'], $user['lastname']) . ' (' . $user['username'] . ')</a><br />';
} else {
$return .= '...<br />';
}
}
}
$xajax_response->addAssign('ajax_list_users', 'innerHTML', api_utf8_encode($return));
return $xajax_response;
}
function enviar_mail($formulario)
{
$respuesta = new xajaxResponse('utf-8');
if ($formulario['nombre'] == "") {
$error = "Por favor dinos tu nombre";
} elseif ($formulario['email'] == "") {
$error = "Por favor escribe un correo electrónico para comunicarnos";
} elseif ($formulario['telefono'] == "") {
$error = "Necesitamos un número telefónico para comunicarnos";
} elseif ($formulario['mensaje'] == "") {
$error = "Cual es tu mensaje ?";
} else {
$error = "";
}
if ($error != "") {
$respuesta->addAlert("{$error}");
return $respuesta;
}
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: NuestraRed.org <*****@*****.**>\r\n";
$headers .= "Reply-To: correo@nuestrared.org\r\n";
$headers .= "Return-path: correo@nuestrared.org\r\n";
$headers .= "Cc: correo@nuestrared.org" . "\r\n";
$asunto = "Mensaje de Nuestra Red ";
$cuerpo = "\n<img src='http://nuestrared.org/images/logo.png' style='width:100%'>\nGracias <strong>{$formulario['nombre']}</strong> por comunicarse con <a href='NuestraRed.org'>NuestraRed.org</a>\n<div>\n<h3>{$asunto}</h3>\n<li><strong>Nombre</strong> {$formulario['nombre']}</li>\n<li><strong>Email</strong> {$formulario['email']}</li>\n<li><strong>Teléfono</strong> {$formulario['telefono']}</li>\n<li><strong>Mensaje</strong> {$formulario['mensaje']}</li>\n</div> \n<p>Sigue en contacto con <a href='NuestraRed.org'>NuestraRed.org</a></p>\n\n";
if (mail("{$formulario['email']}", "{$asunto}", "{$cuerpo}", "{$headers}")) {
$mensaje = "{$cuerpo}";
} else {
$mensaje = "<div class='alert alert-danger'><h2>Error enviando correo </h2>";
}
$respuesta->addAssign("div_contacto", "innerHTML", "{$mensaje}");
//$respuesta->addAlert("Hola Mundo");
return $respuesta;
}
function test()
{
$objResponse = new xajaxResponse();
$objResponse->addAlert("hallo");
$objResponse->addAssign('testButton', 'label', 'Success!');
return $objResponse->getXML();
}
/**
* Search for a list of available courses by title or code, based on
* a given string
* @param string String to search for
* @param int Deprecated param
* @return string A formatted, xajax answer block
* @assert () === false
*/
function search_courses($needle, $id)
{
$tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
$xajax_response = new xajaxResponse();
$return = '';
if (!empty($needle)) {
// xajax send utf8 datas... datas in db can be non-utf8 datas
$charset = api_get_system_encoding();
$needle = api_convert_encoding($needle, $charset, 'utf-8');
$needle = Database::escape_string($needle);
// search courses where username or firstname or lastname begins likes $needle
$sql = 'SELECT code, title FROM ' . $tbl_course . ' u ' . ' WHERE (title LIKE "' . $needle . '%" ' . ' OR code LIKE "' . $needle . '%" ' . ' ) ' . ' ORDER BY title, code ' . ' LIMIT 11';
$rs = Database::query($sql);
$i = 0;
while ($course = Database::fetch_array($rs)) {
$i++;
if ($i <= 10) {
$return .= '<a href="javascript: void(0);" onclick="javascript: add_user_to_url(\'' . addslashes($course['code']) . '\',\'' . addslashes($course['title']) . ' (' . addslashes($course['code']) . ')' . '\')">' . $course['title'] . ' (' . $course['code'] . ')</a><br />';
} else {
$return .= '...<br />';
}
}
}
$xajax_response->addAssign('ajax_list_courses', 'innerHTML', api_utf8_encode($return));
return $xajax_response;
}
function mostrarVentas()
{
$objResponse = new xajaxResponse();
$controlHome = new ManejadorHome();
$recursoCompras = $controlHome->obtenerTodasLasVentas();
$resultado = '<table cellspacing="0" class="" border="1">';
$resultado .= '<thead>';
$resultado .= '<tr>';
$resultado .= '<th>FECHA</th>';
$resultado .= '<th>PRODUCTO</th>';
$resultado .= '<th>CLIENTE</th>';
$resultado .= '<th>CU</th>';
$resultado .= '<th>CANTIDAD</th>';
$resultado .= '</tr>';
$resultado .= '</thead>';
while ($rowCompras = mysql_fetch_array($recursoCompras)) {
$resultado .= '<td>' . $rowCompras[fecha] . '</td>';
$resultado .= '<td>' . $rowCompras[nombreProducto] . '</td>';
$resultado .= '<td>' . $rowCompras[nombreCliente] . '</td>';
$resultado .= '<td>' . $rowCompras[cu] . '</td>';
$resultado .= '<td>' . $rowCompras[can] . '</td>';
$resultado .= '</tr>';
}
$resultado .= '</table>';
$objResponse->addAssign("ventas", "innerHTML", $resultado);
return $objResponse;
}
function get_tindakan($id, $tingkat, $kelas) {
$kon = new Konek;
if($tingkat) $q .= " AND i.tingkat = '".$tingkat."' ";
if($kelas) $q .= " AND id.kelas = '".$kelas."' ";
$sql = "SELECT
i.id as icid,
id.id as idid,
i.kode as kode,
i.nama as nama,
id.*,
i.jenis_tindakan as jenis_tindakan
FROM
icopim i
LEFT JOIN icopim_detil id ON (id.tingkat = i.tingkat)
WHERE i.id = '".$id."' $q ";
$kon->sql = $sql;
$kon->execute();
$data = $kon->getOne();
$objResponse = new xajaxResponse();
//$objResponse->addAssign("debug", "innerHTML", $sql);
$objResponse->addAssign("tindakan_id", "value", $data[jenis_tindakan]);
$objResponse->addAssign("id_icopim", "value", $data[icid]);
$objResponse->addAssign("id_icopim_detil", "value", $data[idid]);
$objResponse->addAssign("nama", "value", $data[nama]);
$objResponse->addAssign("kode", "value", $data[kode]);
$objResponse->addAssign("tingkat", "value", $data[tingkat]);
$objResponse->addAssign("kelas", "value", $data[kelas]);
$objResponse->addAssign("biaya", "value", $data[biaya]);
$objResponse->addScriptCall("fokus", "nama");
return $objResponse;
}
function myFunction()
{
$objResponse = new xajaxResponse();
//$objResponse->setCharEncoding("windows-1251");
$objResponse->addAssign("SomeElementId", "innerHTML", 'тест');
return $objResponse;
}
function ws_menu($window_name, $form = '')
{
global $conf, $images;
$html = $js = '';
// If an array in a string was provided, build the array and store it in $form
$form = parse_options_string($form);
printmsg("DEBUG => Displaying tooltip: {$form['tooltip']}", 4);
$menuname = 'get_html_' . $form['menu_name'];
list($html, $js) = $menuname($form);
// Okay here's what we do:
// 1. Hide the tool-tip
// 2. Update it's content
// 3. Reposition it
// 4. Unhide it
$response = new xajaxResponse();
if ($html) {
$response->addScript("el('{$form['id']}').style.visibility = 'hidden';");
$response->addAssign($form['id'], "innerHTML", $html);
$response->addScript("wwTT_position('{$form['id']}'); el('{$form['id']}').style.visibility = 'visible';");
}
if ($js) {
$response->addScript($js);
}
return $response->getXML();
}
function testRegularFunction($formData)
{
$objResponse = new xajaxResponse();
$objResponse->addAlert("formData: " . print_r($formData, true));
$objResponse->addAssign("submittedDiv", "innerHTML", nl2br(print_r($formData, true)));
return $objResponse->getXML();
}
function search_sessions($needle, $type)
{
global $tbl_session_rel_access_url, $tbl_session, $user_id;
$xajax_response = new xajaxResponse();
$return = '';
if (!empty($needle) && !empty($type)) {
$needle = Database::escape_string($needle);
$assigned_sessions_to_hrm = SessionManager::get_sessions_followed_by_drh($user_id);
$assigned_sessions_id = array_keys($assigned_sessions_to_hrm);
$without_assigned_sessions = '';
if (count($assigned_sessions_id) > 0) {
$without_assigned_sessions = " AND s.id NOT IN(" . implode(',', $assigned_sessions_id) . ")";
}
if (api_is_multiple_url_enabled()) {
$sql = " SELECT s.id, s.name FROM {$tbl_session} s\n LEFT JOIN {$tbl_session_rel_access_url} a ON (s.id = a.session_id)\n WHERE s.name LIKE '{$needle}%' {$without_assigned_sessions} AND access_url_id = " . api_get_current_access_url_id() . "";
} else {
$sql = "SELECT s.id, s.name FROM {$tbl_session} s\n WHERE s.name LIKE '{$needle}%' {$without_assigned_sessions} ";
}
$rs = Database::query($sql);
$return .= '<select class="form-control" id="origin" name="NoAssignedSessionsList[]" multiple="multiple" size="20">';
while ($session = Database::fetch_array($rs)) {
$return .= '<option value="' . $session['id'] . '" title="' . htmlspecialchars($session['name'], ENT_QUOTES) . '">' . $session['name'] . '</option>';
}
$return .= '</select>';
$xajax_response->addAssign('ajax_list_sessions_multiple', 'innerHTML', api_utf8_encode($return));
}
return $xajax_response;
}
/**
* Search sessions by name, based on a search string
* @param string Search string
* @param int Deprecated param
* @return string Xajax response block
* @assert () === false
*/
function search_sessions($needle, $id)
{
global $tbl_session;
$xajax_response = new xajaxResponse();
$return = '';
if (!empty($needle)) {
// xajax send utf8 datas... datas in db can be non-utf8 datas
$charset = api_get_system_encoding();
$needle = api_convert_encoding($needle, $charset, 'utf-8');
$needle = Database::escape_string($needle);
// search sessiones where username or firstname or lastname begins likes $needle
$sql = 'SELECT id, name FROM ' . $tbl_session . ' u
WHERE (name LIKE "' . $needle . '%")
ORDER BY name, id
LIMIT 11';
$rs = Database::query($sql);
$i = 0;
while ($session = Database::fetch_array($rs)) {
$i++;
if ($i <= 10) {
$return .= '<a href="#" onclick="add_user_to_url(\'' . addslashes($session['id']) . '\',\'' . addslashes($session['name']) . ' (' . addslashes($session['id']) . ')' . '\')">' . $session['name'] . ' </a><br />';
} else {
$return .= '...<br />';
}
}
}
$xajax_response->addAssign('ajax_list_courses', 'innerHTML', api_utf8_encode($return));
return $xajax_response;
}
