function ShowMenuFiche($p_dossier)
{
$cn = new Database($p_dossier);
$mod = "&ac=" . $_REQUEST['ac'];
$str_dossier = dossier::get() . $mod;
echo '<div class="lmenu">';
echo '<TABLE>';
echo '<TR><TD colspan="1" class="mtitle" style="width:auto" >
<A class="mtitle" HREF="?p_action=fiche&action=add_modele&fiche=modele&' . $str_dossier . '">' . _('Création') . '</A></TD>
<TD><A class="mtitle" HREF="?p_action=fiche&' . $str_dossier . '">' . _('Recherche') . '</A></TD>
</TR>';
$Res = $cn->exec_sql("select fd_id,fd_label from fiche_def order by fd_label");
$Max = Database::num_row($Res);
for ($i = 0; $i < $Max; $i++) {
$l_line = Database::fetch_array($Res, $i);
printf('<TR><TD class="cell">
<A class="mtitle" HREF="?p_action=fiche&action=modifier&fiche=%d&%s">%s</A></TD>
<TD class="mshort">
<A class="mtitle" HREF="?p_action=fiche&action=vue&fiche=%d&%s">Liste</A>
</TD>
</TR>', $l_line['fd_id'], $str_dossier, $l_line['fd_label'], $l_line['fd_id'], $str_dossier);
}
echo "</TABLE>";
echo '</div>';
} /**
*
*/
public function parse(Database $database)
{
$this->addVendorInfo = $this->getGeneratorConfig()->getBuildProperty('addVendorInfo');
$stmt = $this->dbh->query("SHOW TABLES");
// First load the tables (important that this happen before filling out details of tables)
$tables = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$name = $row[0];
$table = new Table($name);
$database->addTable($table);
$tables[] = $table;
}
// Now populate only columns.
foreach ($tables as $table) {
$this->addColumns($table);
}
// Now add indexes and constraints.
foreach ($tables as $table) {
$this->addForeignKeys($table);
$this->addIndexes($table);
$this->addPrimaryKey($table);
if ($this->addVendorInfo) {
$this->addTableVendorInfo($table);
}
}
} function __construct($Owner)
{
parent::__construct();
$this->pack_start(new GtkLabel(latin1(' Tipo de Endereço: ')), false);
$this->store = new GtkListStore(TYPE_STRING, TYPE_LONG);
$this->pack_start($this->combobox = new GtkComboBox($this->store));
$this->combobox->pack_start($cell = new GtkCellRendererText());
$this->combobox->set_attributes($cell, 'text', 0);
$this->combobox->connect('changed', array($this, 'tipo_endereco_changed'));
$this->show_all();
/*
* preenche lista
*/
$db = new Database($Owner, true);
if (!$db->link) {
return;
}
/*
* Tipo de Endereco
*/
if (!$db->multi_query('SELECT * FROM Vw_Tipos_Endereco')) {
return;
}
$this->store->clear();
unset($this->it);
while ($line = $db->line()) {
$row = $this->store->append();
$this->store->set($row, 0, $line['Descricao'], 1, $line['Id']);
$this->it[$line['Id']] = $row;
}
} /**
*
*/
public function parse(Database $database, Task $task = null)
{
$stmt = $this->dbh->query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME <> 'dtproperties'");
// First load the tables (important that this happen before filling out details of tables)
$tables = array();
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$name = $row[0];
if ($name == $this->getMigrationTable()) {
continue;
}
$table = new Table($name);
$table->setIdMethod($database->getDefaultIdMethod());
$database->addTable($table);
$tables[] = $table;
}
// Now populate only columns.
foreach ($tables as $table) {
$this->addColumns($table);
}
// Now add indexes and constraints.
foreach ($tables as $table) {
$this->addForeignKeys($table);
$this->addIndexes($table);
$this->addPrimaryKey($table);
}
return count($tables);
} static function queue($params)
{
$db = new Database();
# MailQueue class can be created
$script = "INSERT INTO MailQueue SET `type` = :type,\n senderName = :senderName,\n senderEmail = :senderEmail,\n receiverName = :receiverName,\n receiverEmail = :receiverEmail,\n cc = :cc,\n bcc = :bcc,\n subject = :subject,\n body = :body";
return $db->executeUpdate($script, $params);
}function getEquip()
{
$db = new Database();
$link = $db->connect();
$result = $db->select($link, 'equip_type');
return $result;
} /**
* Compile the SQL query and return it.
*
* @param object Database instance
* @return string
*/
public function compile(Database $db)
{
// Start a deletion query
$query = 'DELETE FROM '.$db->quote_table($this->_table);
if ( ! empty($this->_where))
{
// Add deletion conditions
$query .= ' WHERE '.$this->_compile_conditions($db, $this->_where);
}
if ( ! empty($this->_order_by))
{
// Add sorting
$query .= ' '.$this->_compile_order_by($db, $this->_order_by);
}
if ($this->_limit !== NULL && substr($db->_db_type, 0, 6) !== 'sqlite')
{
// Add limiting
$query .= ' LIMIT '.$this->_limit;
}
return $query;
} function getDatosClteClave($clave)
{
$con = new Database();
$query = "select * from clientes_todos where clave_agrupadora = {$clave} order by alta desc limit 1";
$r = $con->Fetch($query);
return $r;
} /**
* Compile the SQL partial for a JOIN statement and return it.
*
* @param object Database instance
* @return string
*/
public function compile(Database $db)
{
if ($this->_type) {
$sql = strtoupper($this->_type) . ' JOIN';
} else {
$sql = 'JOIN';
}
// Quote the table name that is being joined
$sql .= ' ' . $db->quote_table($this->_table);
if (!empty($this->_using)) {
// Quote and concat the columns
$sql .= ' USING (' . implode(', ', array_map(array($db, 'quote_column'), $this->_using)) . ')';
} else {
$conditions = array();
foreach ($this->_on as $condition) {
// Split the condition
list($c1, $op, $c2) = $condition;
if ($op) {
// Make the operator uppercase and spaced
$op = ' ' . strtoupper($op);
}
// Quote each of the columns used for the condition
$conditions[] = $db->quote_column($c1) . $op . ' ' . $db->quote_column($c2);
}
// Concat the conditions "... AND ..."
$sql .= ' ON (' . implode(' AND ', $conditions) . ')';
}
return $sql;
} function testSelect()
{
$db = new Database();
$sql = "SELECT COUNT(*) AS count FROM members";
$result = $db->select($sql);
$this->assertTrue($result[0]["count"] === 0);
} function getBooksByIdUser($idUser, $idBook)
{
$db = new Database();
$query = "SELECT * FROM books b LEFT JOIN users u ON b.fk_owner = u.user_id WHERE b.id_book ='{$idBook}' AND b.fk_user='{$idUser}'";
$arrayBooks = $db->select($query);
return $this->arrayBooks = $arrayBooks;
} function __construct($Owner)
{
parent::__construct();
$this->pack_start(new GtkLabel(' Fornecedor: '), false);
$completion = new GtkEntryCompletion();
$completion->set_model($this->store = new GtkListStore(TYPE_STRING, TYPE_LONG));
$completion->set_text_column(0);
$completion->pack_start($cell = new GtkCellRendererText());
$completion->set_attributes($cell, 'text', 1);
$completion->connect('match-selected', array($this, 'fornecedor_selected'));
$this->pack_start($this->entry = new GtkEntry());
$this->entry->set_completion($completion);
$this->show_all();
/*
* preenche lista
*/
$db = new Database($Owner, true);
if (!$db->link) {
return;
}
/*
* Fornecedores
*/
if (!$db->multi_query('SELECT * FROM Vw_Fornecedores')) {
return;
}
$this->store->clear();
unset($this->it);
while ($line = $db->line()) {
$row = $this->store->append();
$this->store->set($row, 0, $line['Nome'], 1, $line['Id']);
$this->it[$line['Id']] = $row;
}
} function getAppointmentPatientList($patientName, $hosiptal, $appdate)
{
$dbConnection = new Database();
$sql = "SELECT * from appointment where patientName LIKE :patientName and hosiptalid = :hosiptalid and appointementdate = :appdate and status = 'N'";
// echo $sql;
// echo $patientName;
try {
$db = $dbConnection->getConnection();
$stmt = $db->prepare($sql);
$stmt->bindValue("patientName", "%" . $patientName . "%", PDO::PARAM_STR);
$stmt->bindParam("hosiptalid", $hosiptal);
$stmt->bindParam("appdate", $appdate);
$stmt->execute();
$appointmentDetails = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
//$_SESSION['userDetails'] = $userDetails;
// echo $stmt->debugDumpParams();
// print_r($userDetails);
return $appointmentDetails;
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
} catch (Exception $e1) {
echo '{"error11":{"text11":' . $e1->getMessage() . '}}';
}
}function main($post_data)
{
$db = new Database();
if (!$db->connect()) {
exit_with_error('DatabaseConnectionFailure');
}
$report = json_decode($post_data, true);
verify_slave($db, $report);
$commits = array_get($report, 'commits', array());
foreach ($commits as $commit_info) {
if (!array_key_exists('repository', $commit_info)) {
exit_with_error('MissingRepositoryName', array('commit' => $commit_info));
}
if (!array_key_exists('revision', $commit_info)) {
exit_with_error('MissingRevision', array('commit' => $commit_info));
}
require_format('Revision', $commit_info['revision'], '/^[A-Za-z0-9 \\.]+$/');
if (array_key_exists('author', $commit_info) && !is_array($commit_info['author'])) {
exit_with_error('InvalidAuthorFormat', array('commit' => $commit_info));
}
}
$db->begin_transaction();
foreach ($commits as $commit_info) {
$repository_id = $db->select_or_insert_row('repositories', 'repository', array('name' => $commit_info['repository']));
if (!$repository_id) {
$db->rollback_transaction();
exit_with_error('FailedToInsertRepository', array('commit' => $commit_info));
}
$author = array_get($commit_info, 'author');
$committer_id = NULL;
if ($author) {
$account = array_get($author, 'account');
$committer_query = array('repository' => $repository_id, 'account' => $account);
$committer_data = $committer_query;
$name = array_get($author, 'name');
if ($name) {
$committer_data['name'] = $name;
}
$committer_id = $db->update_or_insert_row('committers', 'committer', $committer_query, $committer_data);
if (!$committer_id) {
$db->rollback_transaction();
exit_with_error('FailedToInsertCommitter', array('committer' => $committer_data));
}
}
$parent_revision = array_get($commit_info, 'parent');
$parent_id = NULL;
if ($parent_revision) {
$parent_commit = $db->select_first_row('commits', 'commit', array('repository' => $repository_id, 'revision' => $parent_revision));
if (!$parent_commit) {
$db->rollback_transaction();
exit_with_error('FailedToFindParentCommit', array('commit' => $commit_info));
}
$parent_id = $parent_commit['commit_id'];
}
$data = array('repository' => $repository_id, 'revision' => $commit_info['revision'], 'parent' => $parent_id, 'order' => array_get($commit_info, 'order'), 'time' => array_get($commit_info, 'time'), 'committer' => $committer_id, 'message' => array_get($commit_info, 'message'), 'reported' => true);
$db->update_or_insert_row('commits', 'commit', array('repository' => $repository_id, 'revision' => $data['revision']), $data);
}
$db->commit_transaction();
exit_with_success();
} /**
* Function to support the services/data_cleaner/verify web-service.
* Receives a list of proposed records and applies verification rules to them, then
* returns a list of verification notices.
* Input is provided in the $_GET or $_POST data sent to the method as follows:
* auth_token - read authorisation token
* nonce - read nonce
* sample - Provides details of the sample being verified. If verifying a list
* of records from different places or dates then the sample entry can be ommitted or only partially
* filled-in with the missing information provided on a record by record bases. A JSON formatted
* object with entries for sample:survey_id, sample:date, sample:entered_sref and sample:entered_sref_system, plus
* optional sample:geom (WKT format).
* occurrences - JSON format, provide an array of the occurrence record to verify. Each record is an object
* with occurrence:taxa_taxon_list_id, an optional stage plus any of the values for the sample which need to be
* specified on a record by record bases. I.e. provide sample:date if the sample information sent
* does not include a date, or a date is included but this record is for a different date.
* rule_types - JSON formatted array of the rule types to run. If not provided, then all rule types are run.
* E.g. ["WithoutPolygon","PeriodWithinYear"] to run just without polygon and period within year checks.
* @return JSON A JSON array containing a list of notifications. Each notification is a JSON
* object, with taxa_taxon_list_id and message properties.
*/
public function verify()
{
// authenticate requesting website for this service
$this->authenticate('read');
if (isset($_REQUEST['sample'])) {
$sample = json_decode($_REQUEST['sample'], true);
}
if (isset($_REQUEST['occurrences'])) {
$occurrences = json_decode($_REQUEST['occurrences'], true);
}
if (empty($sample) || empty($occurrences)) {
$this->response = 'Invalid parameters';
} else {
$db = new Database();
// Create an empty template table
$db->query("select * into temporary occdelta from cache_occurrences limit 0;");
try {
$this->prepareOccdelta($db, $sample, $occurrences);
$r = $this->runRules($db);
$db->query('drop table occdelta');
$this->content_type = 'Content-Type: application/json';
$this->response = json_encode($r);
} catch (Exception $e) {
$db->query('drop table occdelta');
$this->response = "Query failed";
error::log_error('Error occurred calling verification rule service', $e);
}
}
$this->send_response();
} public function setSession()
{
session_start();
$page_mode = isset($_POST['page_mode']) ? $_POST['page_mode'] : '';
if ($page_mode == 'login') {
$this->password = sha1($_POST['password']);
$this->userName = $_POST['userName'];
try {
$dbh = new Database();
$data = array(':userName' => $this->userName, ':password' => $this->password);
$sql = "SELECT * FROM {$this->tableName} WHERE user_name=:userName AND password = :password";
$sth = $dbh->prepare($sql);
$sth->execute($data);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$row = $sth->fetch();
} catch (PDOException $e) {
echo "I'm sorry, Dave. I'm afraid I can't do that.";
file_put_contents('PDOErrors.txt', $e->getMessage(), FILE_APPEND);
echo $e->getMessage();
}
if (!$row) {
$this->errorString = 'Clave o nombre de usuario incorrectos';
} else {
$_SESSION['userId'] = $row["{$this->tableId}"];
$_SESSION['userName'] = $row['user_name'];
header('Location: index.php');
}
}
} function delete()
{
$db = new Database();
$sql = sprintf("delete from order_props where id = %d", $this->id);
$db->executeSQL($sql, __FILE__, __LINE__, false);
$db->close();
} /**
* Compile the SQL query and return it.
*
* @param object Database instance
* @return string
*/
public function compile(Database $db)
{
$query = 'ALTER TABLE ' . $db->quote_table($this->_table) . ' ';
$lines = array();
if ($this->_name !== NULL) {
$lines[] = 'RENAME TO ' . $db->quote_table($this->_name) . '; ';
}
if (count($this->_add_columns) > 0) {
$columns = array();
$sql = $query . 'ADD(';
foreach ($this->_add_columns as $name => $params) {
$columns[] = Database_Query_Builder::compile_column($name, $params);
}
$sql .= implode($columns, ',') . '); ';
$lines[] = $sql;
}
if (count($this->_modify_columns) > 0) {
$columns = array();
$sql = $query . 'MODIFY(';
foreach ($this->_modify_columns as $name => $params) {
$columns[] = Database_Query_Builder::compile_column($name, $params);
}
$sql .= implode($columns, ',') . '); ';
$lines[] = $sql;
}
if (count($this->_drop_columns) > 0) {
foreach ($this->_drop_columns as $name) {
$drop = new Database_Query_Builder_Drop('column', $name);
$lines[] = $drop->compile() . ';';
}
}
} /**
* Tests the get_custom_forms method
*
* @test
*/
public function testGetCustomForms()
{
// Database instance for the test
$db = new Database();
// The record count should be the same since get_custom_forms() has no predicates
$this->assertEquals($db->count_records('form'), customforms::get_custom_forms()->count());
} public static function validate($connection)
{
if (isset($_COOKIE['authenticated'])) {
$userData = explode('##', $_COOKIE['authenticated']);
$email = $userData[0];
$saltedEmail = $userData[1];
$db = new Database($connection);
$userData = $db->query('SELECT *
FROM users
WHERE email = :email', array(':email' => $email));
if (isset($userData['data'][0])) {
$salt = $userData['data'][0]['salt'];
$newlySaltedEmail = hash('sha512', $salt . $email);
if ($newlySaltedEmail == $saltedEmail) {
# Cookie is correct
return true;
} else {
# Password niet correct
return false;
}
} else {
# User niet gevonden
return false;
}
} else {
#Cookie niet geset
return false;
}
} function getUdi()
{
$con = new Database();
$sql = "select u.valor , max(u.fecha_captura) from valor_udi as u limit 1";
$con->Query($sql);
return $con;
} /**
* Gets a single status
*
* @return array
*/
public function getNextID()
{
$db = new Database();
$status = $db->query('SELECT id FROM orders_statuses ORDER BY id DESC');
$next = $status[0]->id + 1;
return $next;
} public function deletePost()
{
$database = new Database();
$id = (int) $this->id;
$dml = sprintf("delete from post where id = %d limit 1", $id);
return $database->executeDml($dml);
} public function cargarMenu($idUsuario)
{
$query = "Select md.nombre, md.ruta, m.nombre as menu, m.idMenu from tblusuariopermisos as up join \n tblmenudetalle as md on up.idPermiso = md.idMenuDetalle\n join tblmenu as m on m.idMenu = md.idMenu\n WHERE up.idUsuario = {$idUsuario}\n order by m.idMenu, md.orden";
$con = new Database();
$con->Query($query);
return $con;
} /**
* Save layer relations.
*
* @param mixed $layerId The layer id values.
* @param \DataContainer $dataContainer The dataContainer driver.
*
* @return null
*/
public function saveLayerRelations($layerId, $dataContainer)
{
$new = deserialize($layerId, true);
$values = array();
$result = $this->database->prepare('SELECT * FROM tl_leaflet_map_layer WHERE mid=? order BY sorting')->execute($dataContainer->id);
while ($result->next()) {
$values[$result->lid] = $result->row();
}
$sorting = 0;
foreach ($new as $layerId) {
if (!isset($values[$layerId])) {
$this->database->prepare('INSERT INTO tl_leaflet_map_layer %s')->set(array('tstamp' => time(), 'lid' => $layerId, 'mid' => $dataContainer->id, 'sorting' => $sorting))->execute();
$sorting += 128;
} else {
if ($values[$layerId]['sorting'] <= $sorting - 128 || $values[$layerId]['sorting'] >= $sorting + 128) {
$this->database->prepare('UPDATE tl_leaflet_map_layer %s WHERE id=?')->set(array('tstamp' => time(), 'sorting' => $sorting))->execute($values[$layerId]['id']);
}
$sorting += 128;
unset($values[$layerId]);
}
}
$ids = array_map(function ($item) {
return $item['id'];
}, $values);
if ($ids) {
$this->database->query('DELETE FROM tl_leaflet_map_layer WHERE id IN(' . implode(',', $ids) . ')');
}
return null;
} private function updateEvent($user_id, $user_password, $event_id, $desc)
{
$response = array();
$response["success"] = 0;
$jsonView = new JsonViewer();
$tryLogin = new TryUserLogin($user_id, $user_password);
if ($tryLogin->isExists()) {
//update the events
$database = new Database();
$sql = "UPDATE " . EventTable::TableName . " set " . EventTable::Description . "=:desc WHERE " . EventTable::Id . "=:id";
$smt = $database->prepare($sql);
$smt->bindValue(":id", $event_id);
$smt->bindValue(":desc", $desc);
$status = $smt->execute();
if ($status) {
$response["success"] = 1;
$response["message"] = "Description updated";
} else {
$response["error_message"] = "No event with such information found";
}
} else {
$response["error_message"] = "Invalid user login details";
}
$jsonView->setContent($response);
return $jsonView;
} /**
* Create the DOT syntax for a given databases.
*
* @param $database Database
*
* @return string The DOT syntax created.
*/
public static function create(Database $database)
{
$dotSyntax = '';
// table nodes
foreach ($database->getTables() as $table) {
$columnsSyntax = '';
foreach ($table->getColumns() as $column) {
$attributes = '';
if (count($column->getForeignKeys()) > 0) {
$attributes .= ' [FK]';
}
if ($column->isPrimaryKey()) {
$attributes .= ' [PK]';
}
$columnsSyntax .= sprintf('%s (%s)%s\\l', $column->getName(), $column->getType(), $attributes);
}
$nodeSyntax = sprintf('node%s [label="{<table>%s|<cols>%s}", shape=record];', $table->getName(), $table->getName(), $columnsSyntax);
$dotSyntax .= "{$nodeSyntax}\n";
}
// relation nodes
foreach ($database->getTables() as $table) {
foreach ($table->getColumns() as $column) {
foreach ($column->getForeignKeys() as $fk) {
$relationSyntax = sprintf('node%s:cols -> node%s:table [label="%s=%s"];', $table->getName(), $fk->getForeignTableName(), $column->getName(), implode(',', $fk->getForeignColumns()));
$dotSyntax .= "{$relationSyntax}\n";
}
}
}
return sprintf("digraph G {\n%s}\n", $dotSyntax);
} public function index()
{
$this->template->title = 'Cart';
$this->template->metaDescription = '';
$this->template->content = View::factory('cart')->bind('p', $this->cart);
$this->cart = $this->session->get('Basket');
$cart = new Basket();
$this->additionalInfo = array();
if ($cart->size() > 0) {
$products = array();
foreach ($cart->items() as $index => $item) {
$products[] = $item->id;
}
$db = new Database();
$rows = $db->query('SELECT d.description FROM discounts d JOIN discounts_objects AS do ON (do.discount_id=d.id) WHERE d.effective_from <= now() AND d.effective_to >= now() AND d.type_id=1 AND do.object_id IN (' . join(',', $products) . ')');
foreach ($rows as $row) {
$this->additionalInfo[] = $row->description;
}
}
if (isset($_POST['update'])) {
foreach ($cart->items() as $index => $item) {
//update quntities
if ($item->qty != $_POST['quantity'][$index]) {
$item->qty = $_POST['quantity'][$index];
$cart->update($item);
}
//delete products
if (isset($_POST['delete'][$index]) and $_POST['delete'][$index] == 'on') {
$item->qty = 0;
$cart->update($item);
}
}
$this->cart = $this->session->get('Basket');
}
} public function getOrganizacion()
{
$coneccion = new Database();
$id = $_SESSION['usuario']['id'];
$obj = $coneccion->query("SELECT usu.*,IFNULL(nombre, '') AS nombre, IFNULL(calle, '') AS calle, IFNULL(numero, 0) AS numero, IFNULL(colonia, 0) AS colonia,\n IFNULL(codigo_postal, 0) AS codigo_postal, IFNULL(ciudad, '') AS ciudad, IFNULL(pais,'') AS pais, IFNULL(telefono, '') AS telefono,\n IFNULL(descripcion, '') AS descripcion, IFNULL(estado, '') AS estado\n FROM usuario usu\n LEFT JOIN organizacion org ON org.id_usuario = usu.id\n WHERE usu.id={$id}");
$result = $obj->fetch_object();
if (is_object($result)) {
return $result;
} else {
$temp = new stdClass();
$temp->nombre = "";
$temp->descripcion = "";
$temp->calle = "";
$temp->numero = "";
$temp->colonia = "";
$temp->codigo_postal = "";
$temp->ciudad = "";
$temp->pais = "";
$temp->telefono = "";
$temp->estado = "";
$temp->correo_electronico = "";
$temp->contrasena = "";
return $temp;
}
} public function createLoginByIp($ip, $customerId = null, $status = 0)
{
$database = new Database();
return $database->executeSql('
INSERT INTO Login (LoginIp, LoginTime, Customer_Id, status)
VALUES (?,NOW(),?,?)', [$ip, $customerId, $status]);
}