/**
*
* @param array $param
* <br>Parámetros de entrada.
* @return array
*/
function calculoAportacionCiudadano($param)
{
global $respError, $farmacia;
$param = objectToArray($param);
//die(print_r($param));
if ($farmacia == FARMACIA_DEBUG or strlen(FARMACIA_DEBUG) == 0) {
if (DEBUG & DEBUG_LOG) {
$mensaje = print_r($param, TRUE);
$mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__;
error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log");
}
}
unset($param["farmacia"]);
unset($param["DNI"]);
$client = new SoapClient(END_POINT, array("location" => LOCATION, "trace" => true, "exceptions" => false));
$result = $client->__soapCall(__FUNCTION__, array($param));
//die(print_r($result));
if (is_soap_fault($result)) {
if ($farmacia == FARMACIA_DEBUG or strlen(FARMACIA_DEBUG) == 0) {
if (DEBUG & DEBUG_LOG) {
$mensaje = "REQUEST:\n" . $client->__getLastRequest() . "\n";
$mensaje .= "RESPONSE:\n" . $client->__getLastResponse() . "\n";
$mensaje .= "RESULT:\n" . $result . "\n";
$mensaje .= "--SOAP FAULT, llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__ . "\n";
error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log");
}
}
return array(__FUNCTION__ . "Result" => array("return" => $result->return, "resultadoOperacion" => array("codigoResultadoOperacion" => -9000, "mensajeResultadoOperacion" => $result->faultstring)));
}
return array(__FUNCTION__ . "Result" => array("return" => $result->return, "resultadoOperacion" => $respError->sinErrores()));
}
function getRecommendation($json = TRUE)
{
/**
* Gets the recommendation
* @author Germán Sánchez (GREC-ESADE), Collage
* @version march 2014
*/
global $debugar;
$reqs = objectToArray(json_decode(file_get_contents("php://input")));
if ($debugar) {
echo '<p>Recommender starts. Requirements received:</p>';
echo '<pre>';
var_dump($reqs);
echo '</pre>';
}
// Check inputs and return error if so
// Start recommendation
// 1.- Identification module: list of initial candidates
$initialCandidates = getFeasibleCandidates($reqs);
if ($debugar) {
echo '<h2>Initial candidates:</h2><pre>' . print_r($initialCandidates, TRUE) . '</pre>';
}
// 2.- Selection module: assess candidates and rank them
$finalCandidates = assessAndRank($initialCandidates, $reqs);
if ($debugar) {
echo '<h2>Final candidates:</h2><pre>' . print_r($finalCandidates, TRUE) . '</pre>';
}
if ($json) {
$output = json_encode($finalCandidates);
} else {
$output = $finalCandidates;
}
return $output;
}
function seleccionarRegistro($param)
{
$select = array("farmacia", "idDispensable", "codigoNacionalPrescrito", "codigoNacional", "envases", "dni", "contenido", "pvpComer", "pvpCalculado", "aportacionProducto", "codigoAportacion", "idActoDispensacion", "idDispensacion", "farmaceutico", "CONVERT(nvarchar(30), fechaGrabacion, 126) as fechaGrabacion", "CONVERT(nvarchar(30), fechaAnulacion, 126) as fechaAnulacion", "CONVERT(nvarchar(30), fechaFirma, 126) as fechaFirma", "origen", "firma", "firmaFacturacion", "validado", "firmado", "borrado");
global $respError, $conn, $SQLserverName;
$param = objectToArray($param);
$farmacia = $param["farmacia"];
$DNIFarmacia = $param["DNIFarmacia"];
$where = array("farmacia =" => $farmacia);
if (isset($param["idDispensable"])) {
$idDispensable = $param["idDispensable"];
$where["idDispensable like"] = "%{$idDispensable}%";
}
if (isset($param["fechaGrabacion"])) {
$fechaGrabacion = $param["fechaGrabacion"];
$where["fechaGrabacion ="] = $fechaGrabacion;
}
if (DEBUG & DEBUG_LOG) {
$mensaje = print_r($param, TRUE);
$mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__;
error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log");
}
$tabla = PREFIJO_TABLA_DISPENSACION . date("ym");
$resultadoSelect = querySelect($conn, $tabla, $select, $where);
if ($resultadoSelect["columnasAfectadas"] === NULL) {
$resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]);
return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "resultadoSelect" => $resultadoSelect["resultset"], "resultadoOperacion" => $resultadoOperacion));
}
return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "resultadoSelect" => $resultadoSelect["resultset"], "resultadoOperacion" => $respError->sinErrores()));
}
/**
* Execute the console command.
*
* @return void
*/
public function fire()
{
//
$tutorials = objectToArray(DB::select(DB::raw('select id from tutorials')));
$tutorials = array_dot($tutorials);
$students = array_dot(objectToArray(DB::select(DB::raw('SELECT `user_id` as `id` from `students`'))));
$teachers = array_dot(objectToArray(DB::select(DB::raw('SELECT `user_id` as `id` from `teachers`'))));
$subjects = array_dot(objectToArray(DB::select(DB::raw('SELECT id from subjects'))));
$minimum = $this->option('minimum');
$assessmenttitle = "This is a {title|heading|header} for Assessment.";
$assessmentdesc = "This is a sample {data|words|description} for Assessment.";
for ($i = 1; $i <= $minimum; $i++) {
$assessment = new Assessments();
$assessment->title = self::spintax($assessmenttitle);
$assessment->description = self::spintax($assessmentdesc);
$assessment->assessmenttype = "presentation";
$assessment->tutorialid = rand(1, 100);
$assessment->teacherid = array_rand($teachers);
$assessment->subjectid = rand(1, 55);
$assessment->studentid = array_rand($students);
$assessment->marks = rand(75, 100);
$assessment->created_at = self::randDate('10th January 2013', date('jS F o'));
$assessment->save();
}
}
function asd($hastag = null, $since = null)
{
$key = 'WDTlXe9etTsofPrDtZskFzKwf';
$secret = 'YTQp3f2KLC02pTMylDDkfGPVEYq1u886p8FDBdpZHUTTrMNuVT';
$api_endpoint2 = $hastag == null ? $since : '?q=%40' . $hastag . '&src=savs&max_position&result_type=mixed';
$api_endpoint = 'https://api.twitter.com/1.1/search/tweets.json' . $api_endpoint2;
// request token
$basic_credentials = base64_encode($key . ':' . $secret);
$tk = curl_init('https://api.twitter.com/oauth2/token');
$proxy = "172.16.224.4:8080";
curl_setopt($tk, CURLOPT_PROXY, $proxy);
curl_setopt($tk, CURLOPT_HTTPHEADER, array('Authorization: Basic ' . $basic_credentials, 'Content-Type: application/x-www-form-urlencoded;charset=UTF-8'));
curl_setopt($tk, CURLOPT_POSTFIELDS, 'grant_type=client_credentials');
curl_setopt($tk, CURLOPT_RETURNTRANSFER, true);
$token = json_decode(curl_exec($tk));
curl_close($tk);
// use token
if (isset($token->token_type) && $token->token_type == 'bearer') {
$br = curl_init($api_endpoint);
curl_setopt($br, CURLOPT_PROXY, $proxy);
curl_setopt($br, CURLOPT_HTTPHEADER, array('Authorization: Bearer ' . $token->access_token));
curl_setopt($br, CURLOPT_RETURNTRANSFER, true);
$data = curl_exec($br);
curl_close($br);
// do_something_here_with($data);
return objectToArray(json_decode($data));
}
}
function getlist_json_employee($employee, $bool)
{
$list = $this->base_model->getLeaveCreditsByEmployee($employee, $bool);
$date = $this->mod->getHireDateByEmployee(getUserId($this));
$arrayList = objectToArray($list);
$newArray = array();
foreach ($arrayList as $key => $value) {
$dayval = $value['days'];
$usercount = 0;
if ($value['date'] != '0000-00-00' && $value['date'] != '') {
$hired = strtotime($date);
$setdate = strtotime($value['date']);
if ($hired > $setdate) {
$dayval = $value['days_after'];
} else {
if ($hired < $setdate) {
$dayval = $value['days_before'];
}
}
}
if ($value['schoolyear'] === getSchoolYear($this)) {
$usercount = $value['usecount'];
}
array_push($newArray, array('id' => $value['id'], 'ltid' => $value['ltid'], 'title' => $value['title'], 'days' => $dayval, 'date' => $value['date'], 'days_before' => $value['days_before'], 'days_after' => $value['days_after'], 'usecount' => $usercount));
}
echo json_encode($newArray);
}
/**
* The student inserts this initially once he/she accepts a project offer
* @param unknown $props
* @param unknown $proposal_id
* @return boolean|unknown
*/
static function insertAgreement($props)
{
if (!$props) {
drupal_set_message(t('Insert requested with empty (filtered) data set'), 'error');
return false;
}
if (!isset($props['proposal_id'])) {
drupal_set_message(t('Insert requested with no proposal set'), 'error');
return false;
}
global $user;
$txn = db_transaction();
try {
$proposal = objectToArray(Proposal::getInstance()->getProposalById($props['proposal_id']));
$project = objectToArray(Project::getProjectById($proposal['pid']));
if (!isset($props['student_id'])) {
$props['student_id'] = $user->uid;
}
if (!isset($props['supervisor_id'])) {
$props['supervisor_id'] = $proposal['supervisor_id'];
}
if (!isset($props['mentor_id'])) {
$props['mentor_id'] = $project['mentor_id'];
}
$props['project_id'] = $proposal['pid'];
if (!isset($props['description'])) {
$props['description'] = '';
}
if (!isset($props['student_signed'])) {
$props['student_signed'] = 0;
}
if (!isset($props['supervisor_signed'])) {
$props['supervisor_signed'] = 0;
}
if (!isset($props['mentor_signed'])) {
$props['mentor_signed'] = 0;
}
/*
if (! testInput($props, array('owner_id', 'org_id', 'inst_id', 'supervisor_id','pid', 'title'))){
return FALSE;
}
*/
try {
$id = db_insert(tableName(_AGREEMENT_OBJ))->fields($props)->execute();
} catch (Exception $e) {
drupal_set_message($e->getMessage(), 'error');
}
if ($id) {
drupal_set_message(t('You have created your agreement: you can continue editing it later.'));
return $id;
} else {
drupal_set_message(t('We could not add your agreement. ') . (_DEBUG ? '<br/>' . getDrupalMessages() : ""), 'error');
}
return $result;
} catch (Exception $ex) {
$txn->rollback();
drupal_set_message(t('We could not add your agreement.') . (_DEBUG ? $ex->__toString() : ''), 'error');
}
return FALSE;
}
/**
*
* @param array $param
* @return array
*/
function obtenerCN($param)
{
$select = array("CN");
global $respError, $conn, $SQLserverName;
$param = objectToArray($param);
$farmacia = $param["farmacia"];
$DNIFarmacia = $param["DNIFarmacia"];
if (DEBUG & DEBUG_LOG) {
$mensaje = print_r($param, TRUE);
$mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__;
error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log");
}
$tabla = "catalogo";
$resultadoSelect = querySelect($conn, $tabla, $select);
if ($resultadoSelect["columnasAfectadas"] === NULL) {
$resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]);
return array(__FUNCTION__ . "Result" => array("resultadoOperacion" => $resultadoOperacion));
} elseif ($resultadoSelect["columnasAfectadas"] === 0) {
return $respError->noHayRegistros($tabla, __FUNCTION__);
}
$CN = array();
foreach ($resultadoSelect["resultset"] as $value) {
$CN[] = $value["CN"];
}
return array(__FUNCTION__ . "Result" => array("CN" => $CN, "resultadoOperacion" => $respError->sinErrores()));
}
function Moodle_GetUserId($usert)
{
/**
* Returns the moodle id of the username $usert
* @author Germán Sánchez (GREC-ESADE), Collage
* @version 24.04.2014
*/
global $debugar;
$moodleUsers = Moodle_GetUsersList();
$moodleUsers = objectToArray($moodleUsers);
// $moodleUsers es un array con 'users, que es otro array:
// [0][1]... con [id] y [username]
//echo '<pre>'.print_r($moodleUsers['users'], TRUE).'</pre>';
$key = array_search($usert, array_column($moodleUsers['users'], 'username'));
if ($debugar) {
echo '<h1>key = ' . $key . '</h1>';
}
if ($key != NULL) {
$userid = $moodleUsers['users'][$key]['id'];
} else {
$userid = NULL;
}
if ($debugar) {
echo '<h1>userid = ' . $userid . '</h1>';
}
if ($debugar) {
echo '<pre>' . print_r($moodleUsers['users'], TRUE) . '</pre>';
}
return $userid;
}
function my_init()
{
$args = objectToArray(get_post_type_object('post'));
$args['has_archive'] = 'news';
$args['rewrite'] = array('slug' => 'news', 'with_front' => false);
register_post_type('post', $args);
}
function listarClientes($categoria, $buscar)
{
$array_json = lerJson("json/clientes.json");
$arrya_filtrado = objectToArray($array_json->cliente);
if (isset($buscar) && $buscar != "") {
$palavra_chave = $buscar;
$palavra_chave = explode(" ", $palavra_chave);
}
if ($categoria == '0') {
$operador = ArraySearcher::OPERATOR_NOT;
} else {
$operador = ArraySearcher::OPERATOR_EQUALS;
}
$arrya_filtrado = array_filter($arrya_filtrado, new ArraySearcher('categoria', $operador, $categoria));
foreach ($arrya_filtrado as $campo) {
if (isset($palavra_chave)) {
if (procurarpalavras($campo["tag"], $palavra_chave)) {
echo "<a href='pagina.php?id=" . $campo["nome"] . "' target='_blank'><img class='imgCliente' src='" . $campo["logo"] . "' style='padding-left:10px; padding-top:10px'></a>";
}
} else {
echo "<fieldset id='gpbInformaçõesAnuncio'>";
echo "<a href='pagina.php?id=" . $campo["nome"] . "' target='_blank'><img class='imgCliente'' src='" . $campo["logo"] . "' style='padding-left:10px; padding-top:10px'></a>";
echo "<p align='justify'>" . $campo["descricao"] . "</p>";
echo "<a id='contato' href='pagina.php?id=" . $campo["nome"] . "' target='_blank'>Contato</a>";
echo "</fieldset>";
}
}
}
function readfromDB($filename)
{
$file = $filename;
$fh = fopen($file, 'r');
$data = fread($fh, filesize($file));
fclose($fh);
return objectToArray(json_decode($data));
}
/**
*
* @param date $fechaInicio
* fecha incio de la consulta.
* @param date $fechaFin.
* @param string $Id_Receta
* @param string $farmacia
* @param string $DNI
*
* @return string XML de salida.
*/
function obtenerDatosDispensaciones($param)
{
global $respError, $conn, $SQLserverName;
$param = objectToArray($param);
$fechaInicio = $param["fechaInicio"];
$fechaFin = $param["fechaFin"];
$Id_Receta = $param["Id_Receta"];
$farmacia = $param["farmacia"];
$DNI = $param["DNI"];
//die(print_r($param));
// Comprobar formato fecha sea correcto (AAAA-MM-DD)
if (!strtotime($fechaInicio) or !strtotime($fechaFin)) {
$result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorFormatoFecha()));
return $result;
}
// Comprobar que fechas no sean mayores que hoy
if ($fechaInicio > date('Y-m-d') or $fechaFin > date('Y-m-d')) {
$result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorFechaMayorHoy()));
return $result;
}
//Comprobar que fecha inicial no el mayor que fecha final
if (strtotime($fechaInicio) > strtotime($fechaFin)) {
$result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorFechaInicioMayor()));
return $result;
}
//Comprobar que mes incio y fin sean el mismo
if (date('m', strtotime($fechaInicio)) != date('m', strtotime($fechaFin))) {
$result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorMesInicioMesFinDistintos()));
return $result;
}
//Comprobar que fecha sea superior a 31/01/2013
if (date('Y-m-d', strtotime($fechaInicio)) <= date('Y-m-d', strtotime('2013-01-31'))) {
$result = array(__FUNCTION__ . "Result" => array('resultadoOperacion' => $respError->errorMesInicioMenorFecha()));
return $result;
}
if (DEBUG & DEBUG_LOG) {
$mensaje = print_r($param, TRUE);
$mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__;
error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log");
}
$diaInicio = date('d', strtotime($fechaInicio));
$diaFin = date('d', strtotime($fechaFin));
if (date('ym', strtotime($fechaInicio)) < "1506") {
$tabla = PREFIJO_TABLA_DISPENSACION . date('Ym', strtotime($fechaInicio));
} else {
$tabla = PREFIJO_TABLA_DISPENSACION . date('ym', strtotime($fechaInicio));
}
$select = array("Farmacia", "idtx", "Dni", "Codfarmacia", "Codcolegiado", "Numcolegiado", "Tsi", "Id_Receta", "Pvpcalculadoaport", "Pvptotal", "Euros_receta", "Envases", "Codnacional", "Pvpcomerenv", "Aportacionproducto", "Check_atep", "indicador_euro", "Check_objecion", "Check_visado", "CONVERT(nvarchar(30), FechaGrabacion, 126) as FechaGrabacion");
$where = array("day(FechaGrabacion) >=" => $diaInicio, "day(FechaGrabacion) <=" => $diaFin, "Id_Receta like" => "%{$Id_Receta}%", "Farmacia =" => $farmacia);
$resultadoSelect = querySelect($conn, $tabla, $select, $where);
if ($resultadoSelect["columnasAfectadas"] === NULL) {
$resultadoOperacion = array("codigoResultadoOperacion" => $resultadoSelect[0]["code"], "mensajeResultadoOperacion" => $resultadoSelect[0]["message"]);
return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "listaDatosDispensacion" => $resultadoSelect["resultset"], "resultadoOperacion" => $resultadoOperacion));
}
return array(__FUNCTION__ . "Result" => array("columnasAfectadas" => $resultadoSelect["columnasAfectadas"], "listaDatosDispensacion" => $resultadoSelect["resultset"], "resultadoOperacion" => $respError->sinErrores()));
}
function getCandidateProfile($username)
{
global $conn, $debugar, $versionDataBase;
// Obtenemos el id del usuario
$sql = 'SELECT * FROM ' . TABLE_USERS . ' WHERE username =\'' . $username . '\'';
$result = consulta($sql, $conn);
$obj = pg_fetch_object($result);
$userid = $obj->userid;
if ($debugar) {
echo 'getCandidateProfile: $sql; userid = ' . $userid . '.<br />' . "\n";
}
// Lista de skills
$sql = 'SELECT * FROM ' . TABLE_PROFILE_SKILLS . ' WHERE userid =' . $userid;
$result = consulta($sql, $conn);
while ($obj = pg_fetch_object($result)) {
$skills[] = $obj;
}
if ($debugar) {
echo 'getCandidateProfile: $sql; nrows = ' . pg_num_rows($result) . '.<br />' . "\n";
}
// Lista de subskills
$sql = 'SELECT * FROM ' . TABLE_PROFILE_SUBSKILLS . ' WHERE userid =' . $userid;
$result = consulta($sql, $conn);
$subskills = array();
while ($obj = pg_fetch_object($result)) {
$subskills[] = $obj;
}
if ($debugar) {
echo 'getCandidateProfile: $sql; nrows = ' . pg_num_rows($result) . '.<br />' . "\n";
}
// Department
if ($versionDataBase == 'waag') {
$sql = 'SELECT id FROM ' . TABLE_PROFILE_DEPARTMENT . ' WHERE userid =' . $userid;
$result = consulta($sql, $conn);
$obj = pg_fetch_object($result);
//$dept = int2dept($obj->id);
$dept = $obj->id;
} else {
$sql = 'SELECT dept FROM ' . TABLE_PROFILE_DEPARTMENT . ' WHERE userid =' . $userid;
$result = consulta($sql, $conn);
$obj = pg_fetch_object($result);
$dept = $obj->dept;
}
if ($debugar) {
echo 'getCandidateProfile: $sql; dept(' . $obj->id . ') = ' . $dept . '.<br />' . "\n";
}
// Availability
$sql = 'SELECT * FROM ' . TABLE_PROFILE_AVAILABILITY . ' WHERE userid =' . $userid;
$result = consulta($sql, $conn);
$obj = pg_fetch_object($result);
$avail = $obj->level;
if ($debugar) {
echo 'getCandidateProfile: $sql; availability = ' . $avail . '.<br />' . "\n";
}
return objectToArray(array('skills' => $skills, STRING_SUBSKILLS => $subskills, 'department' => $dept, 'availability' => $avail));
}
/**
* Convert an object to associative array
*
* @param object $object
* @return array
*/
function objectToArray($object)
{
$data = (array) $object;
foreach ($data as $key => $value) {
if (is_object($value) || is_array($value)) {
$data[$key] = objectToArray($value);
}
}
return $data;
}
function validateUpdateBefore(&$row)
{
if (isset($row['disabled'])) {
$row['disabled'] = $row['disabled'] ? 'true' : 'false';
}
$row['outer_content'] = unserialize($row['outer_content']);
$object = json_decode($row['outer_content']['content']);
$row['outer_content']['content'] = objectToArray($object);
$row['outer_content'] = serialize($row['outer_content']);
return true;
}
/**
* Converts an object to an array (nesting conversion).
*
* @param $object
*
* @return array
*/
function objectToArray($object)
{
if (is_array($object) or is_object($object)) {
$result = [];
foreach ($object as $key => $value) {
$result[$key] = objectToArray($value);
}
return $result;
}
return $object;
}
function userlogin($conn)
{
if ($_SESSION['user_status'] !== true) {
if (!empty($cvalue)) {
session_destroy();
$user_status = false;
$array = [user_status => $user_status];
return json_encode($array);
} else {
$cookie_name = "info";
$cvalue = $_COOKIE[$cookie_name];
$query = $conn->prepare("SELECT * FROM users WHERE token = :token LIMIT 1");
$query->bindValue(':token', $cvalue, PDO::PARAM_STR);
$query->execute();
$rows = $query->fetchAll(PDO::FETCH_ASSOC);
if ($rows) {
$token = $rows[0]['twitter_token'];
$secret = $rows[0]['twitter_secret'];
$user_id = $rows[0]['userid'];
$connection = new TwitterOAuth(CONSUMER_KEY, CONSUMER_SECRET, $token, $secret);
$content = $connection->get('account/verify_credentials');
$arrays = objectToArray($content);
$userid = $arrays['id'];
$name = $arrays['name'];
$propic = $arrays['profile_image_url'];
if ($user_id == $userid) {
$_SESSION['user_status'] = $user_status = true;
$_SESSION['user_id'] = $user_id;
$_SESSION['myname'] = $name;
$_SESSION['propic'] = $propic;
$array = [user_id => $_SESSION['user_id'], user_status => $_SESSION['user_status'], name => $name, propic => $propic];
$query = $conn->prepare("UPDATE users\n SET name = :name\n , propic = :propic WHERE userid= :usserid");
$query->bindValue(':name', $name);
$query->bindValue(':propic', $propic);
$query->bindValue(':usserid', $userid);
return json_encode($array);
} else {
session_destroy();
$user_status = false;
$array = [user_status => $user_status];
return json_encode($array);
}
} else {
session_destroy();
$user_status = false;
$array = [user_status => $user_status];
return json_encode($array);
}
}
} elseif ($_SESSION['user_status'] == true) {
$array = ['user_id' => $_SESSION['user_id'], 'user_status' => $_SESSION['user_status'], 'name' => $_SESSION['myname'], 'propic' => $_SESSION['propic']];
return json_encode($array);
}
}
public function getList()
{
$data = array('page' => (int) $this->input->post('page'), 'limit' => (int) $this->input->post('limit'), 'sort' => $this->input->post('sort'), 'dir' => $this->input->post('dir'), 'filter' => objectToArray(json_decode($this->input->post('filter'))));
$express_points = $this->express_point_model->getPoints($data);
foreach ($express_points as $k => $v) {
$province = $this->area_model->getOne($v['province_code']);
$express_points[$k]['province_name'] = $province['area_name'];
}
$express_points_total = $this->express_point_model->getPointsTotal($data);
$json = array('success' => true, 'data' => $express_points, 'total' => $express_points_total, 'msg' => '成功', 'code' => '01');
echo json_encode($json);
}
function app_request($url = "")
{
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 0);
$result = curl_exec($curl);
curl_close($curl);
return objectToArray(json_decode($result));
}
public function getList()
{
$data = array('page' => (int) $this->input->post('page'), 'limit' => (int) $this->input->post('limit'), 'sort' => $this->input->post('sort'), 'dir' => $this->input->post('dir'), 'filter' => objectToArray(json_decode($this->input->post('filter'))));
$files = $this->file_upload_model->getFiles($data);
foreach ($files as $k => $v) {
$files[$k]['admin_name'] = $this->admin_name;
$files[$k]['status_name'] = $this->status[$v['status']];
}
$files_total = $this->file_upload_model->getFilesTotal($data);
$json = array('success' => true, 'data' => $files, 'total' => $files_total, 'msg' => '成功', 'code' => '01');
echo json_encode($json);
}
function objectToArray($e)
{
$e = (array) $e;
foreach ($e as $k => $v) {
if (gettype($v) == 'resource') {
return;
}
if (gettype($v) == 'object' || gettype($v) == 'array') {
$e[$k] = (array) objectToArray($v);
}
}
return $e;
}
protected function specific_definition($mform)
{
require_once $base_url . '/srv/www/htdocs/config.php';
// Adds Block settings section
$mform->addElement('header', 'configheader', get_string('blocksettings', 'block'));
// Adds block name field.
$mform->addElement('text', 'config_title', get_string('blocktitletext', 'block_progress'));
$mform->setDefault('config_title', 'default value');
$mform->setType('config_title', PARAM_MULTILANG);
//Adds footer field
$options = array('no' => 'No', 'yes' => 'Yes');
$mform->addElement('select', 'config_footer', get_string('showpoints', 'block_progress'), $options, $attributes);
$mform->setType('config_footer', PARAM_MULTILANG);
//Adds summary mode field
$options = array('teacher' => get_string('teacher', 'block_progress'), 'tutor' => get_string('tutor', 'block_progress'));
$mform->addElement('select', 'config_mode', get_string('summarymode', 'block_progress'), $options, $attributes);
$mform->setType('config_mode', PARAM_MULTILANG);
//Adds default group field.
global $DB;
global $course;
$groups = $DB->get_records_sql('SELECT `name`,`id` FROM {groups} WHERE courseid = ' . $course->id . '');
//Converts object array to string array
function objectToArray($d)
{
if (is_object($d)) {
// Gets the properties of the given object
// with get_object_vars function
$d = get_object_vars($d);
}
if (is_array($d)) {
/*
* Return array converted to object
* Using __FUNCTION__ (Magic constant)
* for recursive call
*/
return array_map(__FUNCTION__, $d);
} else {
// Return array
return $d;
}
}
//Converts object array to string array
$groups = objectToArray($groups);
//Builds group select list from $groups array.
foreach ($groups as $key => $row) {
$groupselect[$row['id']] = $row['name'];
}
$groupselect['0'] = "All";
ksort($groupselect);
$mform->addElement('select', 'config_group', get_string('defaultgroup', 'block_progress'), $groupselect);
}
public function convertObj($object)
{
function objectToArray($obj)
{
if (!is_object($obj) && !is_array($obj)) {
return $obj;
}
if (is_object($obj)) {
$obj = get_object_vars($obj);
}
return array_map('objectToArray', $obj);
}
return objectToArray($object);
}
function getLeaveBalanceOfEmployee($employee_id)
{
$emp = $employee_id;
$tu = getEmployeeTimeUnit($this);
$tunit = $tu;
$val = 0;
$sCondition = '';
if (getEmployeeTimeUnit($this) == 'd') {
$sCondition = "and is_base = true";
}
$sYear = getSchoolYear($this);
if ($tunit == 'h') {
$query = $this->db->query("select employment.units as units from employment\r\n where employment.employee_id = {$employee_id}");
$query2 = $this->db->query("select l.end_time,l.start_time from leave_transactions l, employment\r\n where employment.employee_id = {$employee_id} and l.employment_id = employment.id and l.status = 'Approved' and l.schoolyear = '{$sYear}'");
$unit = $query->result();
$val = $unit[0]->units;
if ($query2->num_rows() > 0) {
$units = $unit[0]->units;
$total = 0;
$res = objectToArray($query2->result());
$diff = 0;
$total = 0;
foreach ($res as $key => $value) {
if (!empty($value['td'])) {
$parsed = date_parse($value['td']);
}
$time1 = strtotime($value['start_time']);
$time2 = strtotime($value['end_time']);
$diff = $time2 - $time1;
$total = $total + $diff;
}
$val = $units * 3600 - $total;
$val = $val / 3600;
}
return array('value' => $val, 'unit' => ' h');
} else {
if ($tunit == 'd') {
if (!empty($employee_id)) {
$employee_id = "and e.id = {$employee_id}";
}
$query = $this->db->query("\r\n select \r\n sum(\r\n (datediff(g.end_date,g.start_date)) + (g.end_date_hw + g.start_date_hw)+ 1\r\n ) as days\r\n from \r\n leave_transactions g, \r\n employees e,\r\n employment em,\r\n leave_credits lc\r\n where (\r\n g.employment_id = em.id and \r\n em.employee_id = e.id \r\n {$employee_id} and \r\n g.status = 'Approved' and \r\n g.leave_credits_id = lc.id and \r\n lc.is_base = 1) and \r\n g.schoolyear = '{$sYear}'");
$days = $query->result();
$est = $this->getEmpTypesStatByEmployee($emp);
$q = $this->db->query("select lc.days \r\n from leave_credits lc, employment e where e.employee_id = {$emp} and lc.emp_types_stat_id = {$est[0]->id} {$sCondition}");
$value = $q->result();
return array('value' => $value[0]->days - $days[0]->days, 'unit' => ' d');
}
}
}
function acquireFormattedI18NString($lang, $key)
{
if (!defined('MEDIAWIKI')) {
define("MEDIAWIKI", true);
}
$filename = "../../Memento/i18n/{$lang}.json";
$handle = fopen($filename, 'r');
$json = fread($handle, filesize($filename));
fclose($handle);
$messages = json_decode($json);
$messages = objectToArray($messages);
$format = $messages[$key];
$format = str_replace(array('$1', '$2', '$3'), '%s', $format);
return $format;
}
function jsonToHtml($json)
{
$array = objectToArray(json_decode($json));
$temp = array();
if (array_key_exists('car_oil', $array)) {
$oil = getOilInfo($array['car_oil']);
echo "<tr><td>机油</td><td>{$oil['title']} {$oil['price']}元</td></tr>";
}
if (array_key_exists('jilv', $array)) {
echo "<tr><td>机油滤清器</td><td>{$array['jilv']}元</td></tr>";
}
if (array_key_exists('qilv', $array)) {
echo "<tr><td>空气滤清器</td><td>{$array['qilv']}元</td></tr>";
}
if (array_key_exists('konglv', $array)) {
echo "<tr><td>空调滤清器</td><td>{$array['konglv']}元</td></tr>";
}
if (array_key_exists('front_pian', $array)) {
echo "<tr><td>前刹车片</td><td>{$array['front_pian']}元</td></tr>";
}
if (array_key_exists('back_pian', $array)) {
echo "<tr><td>后刹车片</td><td>{$array['back_pian']}元</td></tr>";
}
if (array_key_exists('front_pan', $array)) {
echo "<tr><td>前刹车盘</td><td>{$array['front_pan']}元</td></tr>";
}
if (array_key_exists('back_pan', $array)) {
echo "<tr><td>后刹车盘</td><td>{$array['back_pan']}元</td></tr>";
}
if (array_key_exists('huohuasai', $array)) {
echo "<tr><td>火花塞</td><td>{$array['huohuasai']}元</td></tr>";
}
if (array_key_exists('shacheyou', $array)) {
echo "<tr><td>刹车油</td><td>{$array['shacheyou']}元</td></tr>";
}
if (array_key_exists('neishi', $array)) {
echo "<tr><td>内饰清洗</td><td>{$array['neishi']}元</td></tr>";
}
if (array_key_exists('kt', $array)) {
echo "<tr><td>空调清洗</td><td>{$array['kt']}元</td></tr>";
}
if (array_key_exists('jicang', $array)) {
echo "<tr><td>发动机舱清洗</td><td>{$array['jicang']}元</td></tr>";
}
if (array_key_exists('lungu', $array)) {
echo "<tr><td>轮毂清洗</td><td>{$array['lungu']}元</td></tr>";
}
}
function consultaSPARQL($sparql)
{
error_reporting(E_ALL);
ini_set("display_errors", 1);
$dados = new Constant();
$login = getProperty($dados->DB_LOGIN_SPARQL);
$url_sparql = getProperty($dados->DB_URL_SPARQL);
//definindo o formato de retorno dos dados
$format = 'application/sparql-results+json';
//definindo a consulta
$consulta = $sparql;
//codificando a consulta
$url = urlencode($consulta);
//concatenando as string para formar a url de consulta
$sparqlURL = $url_sparql . '?query=' . $url;
/*Setando o cabecalho da requisicao */
//usando a fun����o curl para conectar com o allegrograph
$curl = curl_init();
//inicializando o curl
curl_setopt($curl, CURLOPT_USERPWD, $login);
//usuario e senha do banco
curl_setopt($curl, CURLOPT_URL, $sparqlURL);
//definindo a url de consulta
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
//Recebe o retorno da consulta como uma string
curl_setopt($curl, CURLOPT_HTTPHEADER, array('Accept: ' . $format));
//definido o formato de retorno desejado
$resposta = curl_exec($curl);
//executando o curl e armazenando a resposta numa variavel
curl_close($curl);
//fechando o curl
///////// come��ando a manipula����o de dados/////////////
$objects = array();
$resultado = json_decode($resposta);
//Decodificando o objecto json
//pegando o valor de interesse no array//
foreach ($resultado->results->bindings as $reg) {
// primeiro loop
$obj = new stdClass();
foreach ($reg as $field => $value) {
$obj->{$field} = $value->value;
}
$objects[] = $obj;
}
//sai do segundo loop
$row = objectToArray($objects);
return $row;
}
function objectToArray($object)
{
if (count($object) >= 1) {
$arr = array();
for ($i = 0; $i < count($object); $i++) {
$arr[] = get_object_vars($object[$i]);
}
return $arr;
} else {
return get_object_vars($object);
}
for ($i = 0; $i < count($object); $i++) {
$arrObj[] = objectToArray($object[$i]);
}
return $arrObj;
}
function actualizarRegistro($param)
{
/*$param = array(
'farmacia' => '9000',
'idDispensable' => '1',
'codigoNacionalPrescrito' => '123456',
'codigoNacional' => '656706',
'envases' => '1',
'dni' => '',
'contenido' => '200',
'pvpComer' => '2,93',
'pvpCalculado' => '0,29',
'aportacionProducto' => '0',
'codigoAportacion' => '',
'idActoDispensacion' => '1984',
'idDispensacion' => '2832',
'farmaceutico' => '00000013J',
'fechaGrabacion' => date("Y-m-d H:i:s"),
'fechaAnulacion' => 0,
'fechaFirma' => 0,
'origen' => 'Electronica',
'firma' => '',
'firmaFacturacion' => '1',
'validado' => '1',
'firmado' => '1',
'borrado' => '0'
);*/
$param = objectToArray($param);
$where = array("farmacia" => $param["farmacia"], "idDispensable" => $param["idDispensable"]);
unset($param["farmacia"]);
unset($param["idDispensable"]);
unset($param["DNIFarmacia"]);
global $conn, $connBack, $insercionRemota, $SQLserverName, $SQLserverNameBack;
if (DEBUG & DEBUG_LOG) {
$mensaje = print_r($param, TRUE);
$mensaje .= "--Llamada hecha en el fichero: " . __FILE__ . ", en la línea: " . __LINE__;
error_log("[" . date("c") . "] \r\n {$mensaje}", 3, DIRECTORIO_LOG . __FUNCTION__ . "_" . date("YmdH") . ".log");
}
$tabla = PREFIJO_TABLA_DISPENSACION . date("ym");
$resultadoActualizar = actualizar($conn, $tabla, $param, $where, $SQLserverName);
// Si está activada la inserción remota la hacemos.
if ($insercionRemota) {
actualizar($connBack, $tabla, $param, $SQLserverNameBack);
}
//die(print_r($resultadoActualizar));
return array(__FUNCTION__ . "Result" => $resultadoActualizar["actualizarResult"]);
}
