}
}
// print_r($valorTupla);
// echo "<br>";
// print_r($_POST);
// echo "<br>";
// print_r($valorDiferente);
// echo "<br>";
if (sizeof($valorDiferente) > 0) {
$query = "UPDATE manutencao SET ";
$log_descr = "Alterado ";
$i = 0;
foreach ($valorDiferente as $key => $value) {
if ($i == sizeof($valorDiferente) - 1) {
$query .= "{$key}='{$value}' ";
$log_descr .= $key . " de: '" . $valorTupla[$key] . "' para: '" . $value . "'";
} else {
$query .= "{$key}='{$value}', ";
$log_descr .= $key . " de: '" . $valorTupla[$key] . "' para: '" . $value . "', ";
}
$i++;
}
$query .= "WHERE manut_id='{$manut_id}' AND manut_patrimonio='{$manut_patrimonio}'";
// echo $query."<br>";
query($query);
$log_descr .= " da manutenção '" . $manut_id . "'.";
// echo $log_descr;
InsertLog($log_descr);
}
header("Location: ../../relatorio/manutencao/");
}
<?php
require_once '../../fcnsdb.php';
if (isset($_POST['submit'])) {
$manutencao = $_POST;
unset($manutencao['submit']);
$manutencao['manut_data'] = DateTime::createFromFormat("j F, Y", $manutencao['manut_data'])->format("Y-m-d");
$query = "INSERT INTO manutencao";
$query .= "(" . implode(", ", array_keys($manutencao)) . ")";
$query .= " VALUES ('" . implode("', '", $manutencao) . "')";
// echo $query;
query($query);
$query = "SELECT max(manut_id) FROM manutencao";
$lastID = mysqli_fetch_array(query($query))['max(manut_id)'];
InsertLog("Cadastrado nova Manutenção com ID: " . $lastID . ", Patrimonio: " . $manutencao['manut_patrimonio'] . ", Data: " . $manutencao['manut_data'] . " e Descrição: " . $manutencao['manut_descr']);
$query = "SELECT * FROM manutencao WHERE manut_patrimonio='{$manutencao['manut_patrimonio']}'";
ShowManutTable($query);
}
if (isset($_GET['patrimonio'])) {
$query = "SELECT equip_patrimonio FROM equipamento GROUP BY 1";
SelectValues(query($query));
}
function ShowManutTable($query)
{
$numRows = mysqli_num_rows(query($query));
echo "<div class=\"divider\"></div>";
echo "<br>" . ($numRows > 0 ? $numRows : "Nenhuma") . " " . ($numRows > 1 ? "manutenções." : "manutenção.");
PrintTable(query($query));
}
}
$query = "INSERT INTO equipamento ";
$query .= "(" . implode(", ", array_keys($equipamento)) . ")";
$query .= " VALUES ('" . implode("', '", $equipamento) . "')";
// echo $query;
// echo "<br>";
try {
query($query);
} catch (Exception $e) {
switch ($e->getCode()) {
case '1062':
die("Equipamento com o Patrimônio: '" . $_POST['equip_patrimonio'] . "' já cadastrado!");
break;
}
}
InsertLog("Cadastrado novo equipamento com Patrimonio: '" . $equipamento['equip_patrimonio'] . "', Colaborador: '" . $equipamento['equip_colaborador'] . "', Departamento: '" . $equipamento['equip_depart'] . "', Setor: '" . $equipamento['equip_setor'] . "', Tipo: '" . $equipamento['equip_tipo'] . "', Marca: '" . $equipamento['equip_marca'] . "', Modelo: '" . $equipamento['equip_modelo'] . "', Imagem: '" . $equipamento['equip_img'] . "' e Descrição: '" . $equipamento['equip_descr'] . "'");
$query = "SELECT * FROM equipamento WHERE equip_patrimonio='{$equipamento['equip_patrimonio']}'";
PrintEquipTable(query($query));
}
if (isset($_GET['patrimonio'])) {
$query = "SELECT equip_patrimonio FROM equipamento WHERE equip_patrimonio='" . $_GET['patrimonio'] . "'";
$result = query($query);
echo json_encode(mysqli_fetch_assoc($result));
}
if (isset($_GET['departamento'])) {
$query = "SELECT loc_depart FROM local GROUP BY 1";
$result = query($query);
$array = array();
array_push($array, array('id' => '', 'text' => 'Selecione...'));
while ($row = mysqli_fetch_assoc($result)) {
array_push($array, array('id' => $row['loc_depart'], 'text' => $row['loc_depart']));
function AddProd($user_id, $object_id, $trans_id, $prod_id, $prod_quantity, $s_price, $price)
{
$result = mysql_query("\tSELECT\t`sale_transaction_detail`.`production_id`\r\n\t\t\t\t\t\t\tFROM\t`sale_transaction_detail` LEFT JOIN `production`\r\n\t\t\t\t\t\t\t\tON\t`sale_transaction_detail`.`production_id` = `production`.`id` LEFT JOIN `sale_transaction`\r\n\t\t\t\t\t\t\t\tON\t`sale_transaction_detail`.`transaction_id` = `sale_transaction`.`id`\r\n\t\t\t\t\t\t\tWHERE (`sale_transaction`.`object_id` = '{$object_id}' && `status` = 4) && (`sale_transaction_detail`.`production_id` = '{$prod_id}')");
if (mysql_num_rows($result)) {
mysql_query("\tUPDATE\r\n\t\t\t\t\t\t`sale_transaction_detail` LEFT JOIN `sale_transaction`\r\n\t\t\t\t\t\t\tON sale_transaction_detail.transaction_id = sale_transaction.id\r\n\t\t\t\t\t\t\tSET\r\n\t\t\t\t\t\t\t`sale_transaction_detail`.`product_quantity` = `sale_transaction_detail`.`product_quantity` + {$prod_quantity}\r\n\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t`sale_transaction_detail`.`production_id` = {$prod_id} && `sale_transaction`.`status` = 4 && transaction_id = {$trans_id}");
} else {
mysql_query("\tINSERT INTO `sale_transaction_detail`\r\n\t\t\t\t\t (`user_id`, `transaction_id`, `production_id`, `product_quantity`, `self_cost`, `cost`)\r\n\t\t\t\t\tVALUES\r\n\t\t\t\t\t ({$user_id}, {$trans_id}, {$prod_id}, {$prod_quantity}, {$s_price}, {$price})");
}
$trans_det_id = mysql_insert_id();
InsertLog($user_id, $trans_id, $trans_det_id, $prod_id, $prod_quantity, $s_price, $price);
}
<?php
require_once '../../seguranca.php';
if (isset($_POST['submit'])) {
$patrimonio = isset($_GET['sof_patrimonio']) ? $_GET['sof_patrimonio'] : $_POST['sof_patrimonio'];
$imagem = $_FILES['sof_file'];
if ($imagem['tmp_name'] != 'none') {
$fp = fopen($imagem['tmp_name'], "rb");
$conteudo = fread($fp, $imagem['size']);
$conteudo = addslashes($conteudo);
fclose($fp);
$query = "INSERT INTO softwares (sof_patrimonio, sof_file) VALUES ('{$patrimonio}','{$conteudo}')";
query($query);
$query = "SELECT max(sof_id) FROM softwares";
$lastID = mysqli_fetch_array(query($query))['max(sof_id)'];
InsertLog("Cadastrado nova imagem de softwares com ID: '" . $lastID . "' e Patrimonio: '" . $patrimonio . "'.");
echo "<br><h5 class='center-align'><b>Imagem Salva!</b></h5>";
echo "<img class='col l9 offset-l2 s9 offset-s2 responssive-img align' src='../../relatorio/ver-imagens.php?tipo=softwares&id=" . $lastID . "'>";
} else {
echo "<h5 class='valign-center'><b>Erro ao carregar a Imagem!</b></h5>";
}
}
if (isset($_GET['patrimonio'])) {
$query = "SELECT equip_patrimonio FROM equipamento where equip_tipo='Desktop' OR equip_tipo='Notebook' ORDER BY 1";
$result = query($query);
$array = array();
array_push($array, array('id' => '', 'text' => 'Selecione...'));
while ($row = mysqli_fetch_assoc($result)) {
array_push($array, array('id' => $row['equip_patrimonio'], 'text' => $row['equip_patrimonio']));
}
echo json_encode($array);
<?php
require_once '../../seguranca.php';
if (isset($_POST['submit'])) {
$tipo = $_POST['tipo'];
$marca = $_POST['img_marca'];
$modelo = $_POST['img_modelo'];
$imagem = $_FILES['img'];
if ($imagem['tmp_name'] != 'none') {
$fp = fopen($imagem['tmp_name'], "rb");
$conteudo = fread($fp, $imagem['size']);
$conteudo = addslashes($conteudo);
fclose($fp);
$query = "INSERT INTO imagem (img_tipo, img_marca, img_modelo, img_file) VALUES ('{$tipo}','{$marca}','{$modelo}','{$conteudo}')";
query($query);
$query = "SELECT max(img_id) FROM imagem";
$lastID = mysqli_fetch_array(query($query))['max(img_id)'];
InsertLog("Cadastrado nova imagem com ID: '" . $lastID . "' e Tipo: '" . $tipo . "'.");
echo "<br><h5 class='center-align'><b>Imagem Salva!</b></h5>";
echo "<img class='col s12 l12 responssive-img align' src='../../relatorio/ver-imagens.php?tipo=imagem&id=" . $lastID . "'>";
} else {
echo "<h5 class='valign-center'><b>Erro ao carregar a Imagem!</b></h5>";
}
}
<?php
if (isset($_POST['submit'])) {
require_once '../../fcnsdb.php';
$sala = $_POST['sala'];
$departamento = $_POST['departamento'];
$setor = $_POST['setor'];
$query = "INSERT INTO local VALUES ('{$setor}','{$departamento}','{$sala}')";
query($query);
InsertLog("Cadastrado novo Local com Setor: " . $setor . ", Departamento: " . $departamento . " e Sala: " . $sala);
$query = "SELECT * FROM local WHERE loc_setor='{$setor}' AND loc_depart='{$departamento}'";
PrintTable(query($query));
}
<?php
require_once '../../fcnsdb.php';
if (isset($_POST['submit'])) {
$arrayName = array('username' => $_POST['username'], 'login' => $_POST['login'], 'password' => md5($_POST['password']), 'email' => $_POST['email'], 'root' => isset($_POST['root']) ? $_POST['root'] : 'N');
$query = "INSERT INTO usuario ";
$query .= "(" . implode(", ", array_keys($arrayName)) . ")";
$query .= " VALUES ('" . implode("', '", $arrayName) . "')";
try {
query($query);
$login = $arrayName['login'];
$query = "SELECT username,login,email,root FROM usuario WHERE login = '******'";
PrintTable(query($query));
$query = "SELECT user_id,username \n\t\t\t\t\tFROM usuario\n\t\t\t\t\tWHERE user_id IN (SELECT max(user_id) FROM usuario)";
//pegar o maior valor auto incrementado
$newUser = mysqli_fetch_array(query($query));
InsertLog("Cadastrado novo usuário com a id " . $newUser['user_id'] . " e nome " . $newUser['username']);
} catch (exception $e) {
switch ($e->getCode()) {
case '1062':
die("Usuário com login " . $_POST['login'] . " já cadastrado");
break;
}
}
}
