function save()
{
$array = file(ROOT . '/config.php');
$content = '';
foreach ($array as $k => $v) {
if (strstr($v, '#system_style')) {
$array[$k] = "define('SYS_STYLE', '" . params::get('system_style') . "'); #system_style\r\n";
}
if (strstr($v, '#system_lang')) {
$array[$k] = "define('LANG_INDEX', '" . params::get('system_lang') . "'); #system_lang\r\n";
}
if (strstr($v, '#global_cache')) {
if (params::get('global_cache')) {
$array[$k] = "define('GLOBAL_CACHE', true); #global_cache\r\n";
} else {
$array[$k] = "define('GLOBAL_CACHE', false); #global_cache\r\n";
}
}
if (strstr($v, '#global_time')) {
$array[$k] = "define('GLOBAL_CACHE_TIME', " . params::get('global_cache_time') . "); #global_time\r\n";
}
$content .= $array[$k];
}
files::write(ROOT . '/config.php', $content);
headers::self();
}
function save()
{
settings::set('feedback', 'feedback_email', params::get('feedback_email'));
settings::set('feedback', 'feedback_subject', params::get('feedback_subject'));
settings::save('feedback');
headers::self();
}
function saveMail()
{
db::table('mails');
db::where('mail_id', admin::get('id'));
db::update(array('mail_name' => params::get('mail_name'), 'mail_subject' => params::get('mail_subject'), 'mail_content' => params::get('mail_content')));
headers::self();
}
function _add()
{
$array = array('news_date' => 'NOW()', 'news_pub' => '1', 'news_title' => params::get('news_title'), 'news_content' => params::get('news_content'), 'news_desc' => params::get('news_desc'));
db::table('news');
db::smartInsert($array);
headers::app('news');
}
public function __construct($html = false)
{
headers::not_found();
# send 404
if ($html === true) {
$this->html();
}
}
function replace()
{
$page_id = params::get('page_id');
db::table('pages');
db::limit(1);
db::where('page_id', $page_id);
$page_folder = db::get('page_folder');
headers::url($page_folder);
//self::loadPage();
}
function sendFeedback()
{
$mail_content = params::get('message');
$email = params::get('email');
if (!empty($mail_content) && !empty($email)) {
mail::from($email);
mail::html($mail_content);
mail::subject(settings::get('feedback', 'feedback_subject'));
mail::send(settings::get('feedback', 'feedback_email'));
headers::url('/contacts/success/');
}
}
function save()
{
settings::set('pages', 'global_page_keywords', params::get('global_page_keywords'));
settings::set('pages', 'global_page_description', params::get('global_page_description'));
settings::set('pages', 'global_page_keywords_check', params::isCheck('global_page_keywords_check'));
settings::set('pages', 'global_page_description_check', params::isCheck('global_page_description_check'));
settings::set('pages', 'redactor', params::isCheck('redactor'));
settings::set('pages', 'jip', params::isCheck('jip'));
settings::set('pages', 'global_page_title', params::get('global_page_title'));
settings::save('pages');
headers::self();
}
/**
* Prepares a list of products and renders accordingly
*
* If the request comes from an AJAX request containing pagination data, the resultant table will be
* paginated appropriately. Otherwise, a default pagination state (no sorting, no filtering, page 1)
* will be created.
*/
public function actionIndex()
{
$statuses = statuses::model()->getAll();
$vendors = vendors::model()->getAll();
$tags = tags::model()->getAll();
$showColumns = Auth::User()->getColumns();
if (count($showColumns) == 0) {
$showColumns = array(1, 2, 3);
}
$columnHeaders = headers::model()->getAll();
$allHeaders = array();
foreach ($columnHeaders as $header) {
$allHeaders[$header->id] = $header;
}
$headers = array('show' => $showColumns, 'headers' => $allHeaders);
$pagination = array('limit' => array(0, 10), 'filter' => 'All categories', 'sortAttribute' => null, 'sortDirection' => null);
if (!empty($_GET['ajax'])) {
//handle ajax requests
//get the pagination data from the query string
if (isset($_GET['headers'])) {
$headers['show'] = explode(',', $_GET['headers']);
Auth::User()->setColumns($_GET['headers']);
}
$sortHeader = headers::model()->getbyPK($_GET['sortAttribute']);
$pagination['sortAttribute'] = $sortHeader->sortName;
$pagination['sortDirection'] = $_GET['sortDirection'];
$pagination['limit'] = array($_GET['paginationPageNumber'], $_GET['paginationPerPage']);
$pagination['filter'] = $_GET['filter'];
$conditions = null;
$params = null;
//if there is a filter in place, create the conditions and parameters needed
if (!empty($pagination['filter']) && $pagination['filter'] != 'All categories') {
$conditions = "category = :category";
$category = categories::model()->getByAttribute('name', $pagination['filter']);
$params = array('category' => $category->id);
}
$models = items::model(true)->getAll($conditions, $params, $pagination);
$count = items::model()->getCount($conditions, $params);
$pagination['count'] = $count;
$pagination['sortAttribute'] = $_GET['sortAttribute'];
$this->renderPartial('table', array('data' => $models, 'statuses' => $statuses, 'pagination' => $pagination, 'vendors' => $vendors, 'tags' => $tags, 'headers' => $headers));
} else {
//handle default requests
$models = items::model(true)->getAll(null, null, $pagination);
$count = items::model()->getCount(null);
$pagination['count'] = $count;
$this->render('index', array('models' => $models, 'statuses' => $statuses, 'vendors' => $vendors, 'tags' => $tags, 'pagination' => $pagination, 'headers' => $headers));
}
}
/** send headers **/
function send()
{
global $sendheaders, $sendnocacheheaders, $gzip;
if ($sendheaders == 1) {
@header("HTTP/1.0 200 OK");
@header("HTTP/1.1 200 OK");
@header("Content-type: text/html");
}
if ($sendnocacheheaders == 1) {
@header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
@header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
@header("Cache-Control: no-cache, must-revalidate");
@header("Pragma: no-cache");
}
if ($gzip == 1) {
headers::compress();
}
}
function upload()
{
$dir = IMAGES_ROOT . 'index/';
@mkdir(IMAGES_ROOT);
@mkdir($dir);
if (!empty($_FILES['file']['name'])) {
$img_id = md5(date('YmdHis'));
$file = $dir . $img_id . '.jpg';
$file_m = $dir . $img_id . '_m.jpg';
copy($_FILES['file']['tmp_name'], $file);
images::src($file);
images::thumb($file_m);
images::setWidth(150);
images::resize();
$array = array('img_id' => $img_id, 'img_set' => '0');
db::table('images');
db::smartInsert($array);
}
headers::self();
}
function start($engine = true)
{
self::$site = str_replace('www.', '', $_SERVER['HTTP_HOST']);
self::$query_string = urldecode($_SERVER['QUERY_STRING']);
self::$request_uri = str_replace('?' . self::$query_string, '', urldecode($_SERVER['REQUEST_URI']));
if (!self::$request_uri) {
self::$request_uri = '/';
}
/*
Sections
*/
self::$sections = explode('/', string::clearBoth(self::$request_uri));
if (!self::$sections) {
self::$sections[0] = '';
}
self::loadEngine();
// load sites.ini
if (self::$engine == 'web') {
// redirects
$redirect = false;
$ini = ini::parse(SYS_ROOT . 'conf/global/sites.ini', 'redirects');
if ($ini) {
$redirect = arrays::returnValue($ini, self::$site);
if ($redirect) {
headers::site($redirect);
}
}
// mirrors
$ini = ini::get('mirrors');
if ($ini) {
$mirror = arrays::returnValue($ini, self::$site);
if ($mirror) {
self::$site = $mirror;
}
}
}
self::setConst();
if ($engine) {
load::engine(ENGINE);
}
}
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
$cab = new headers();
$cab->set_title(HTML_TITLE);
$auth = new auth();
$auth->testa_user($s_usuario, $s_nivel, $s_nivel_desc, 4);
$hoje = date("Y-m-d H:i:s");
$cor = TD_COLOR;
$cor1 = TD_COLOR;
$cor3 = BODY_COLOR;
$queryA = "SELECT\n\n\t\t\tmold.mold_marca as padrao,\n\t\t\tmold.mold_inv as etiqueta, mold.mold_sn as serial, mold.mold_nome as nome,\n \t\t\tmold.mold_nf as nota,\n\n \t\t\tmold.mold_coment as comentario, mold.mold_valor as valor, mold.mold_data_compra as\n\t\t\tdata_compra, mold.mold_ccusto as ccusto,\n\n\t\t\tinst.inst_nome as instituicao, inst.inst_cod as cod_inst,\n\n\t\t\tequip.tipo_nome as equipamento, equip.tipo_cod as equipamento_cod,\n\n\t\t\tt.tipo_imp_nome as impressora, t.tipo_imp_cod as impressora_cod,\n\n\t\t\tloc.local as local, loc.loc_id as local_cod,\n\n\n\n\t\t\tproc.mdit_fabricante as fabricante_proc, proc.mdit_desc as processador, proc.mdit_desc_capacidade as clock, proc.mdit_cod as cod_processador,\n\t\t\thd.mdit_fabricante as fabricante_hd, hd.mdit_desc as hd, hd.mdit_desc_capacidade as hd_capacidade,hd.mdit_cod as cod_hd,\n\t\t\tvid.mdit_fabricante as fabricante_video, vid.mdit_desc as video, vid.mdit_cod as cod_video,\n\t\t\tred.mdit_fabricante as rede_fabricante, red.mdit_desc as rede, red.mdit_cod as cod_rede,\n\t\t\tmodm.mdit_fabricante as fabricante_modem, modm.mdit_desc as modem, modm.mdit_cod as cod_modem,\n\t\t\tcd.mdit_fabricante as fabricante_cdrom, cd.mdit_desc as cdrom, cd.mdit_cod as cod_cdrom,\n\t\t\tgrav.mdit_fabricante as fabricante_gravador, grav.mdit_desc as gravador, grav.mdit_cod as cod_gravador,\n\t\t\tdvd.mdit_fabricante as fabricante_dvd, dvd.mdit_desc as dvd, dvd.mdit_cod as cod_dvd,\n\t\t\tmb.mdit_fabricante as fabricante_mb, mb.mdit_desc as mb, mb.mdit_cod as cod_mb,\n\t\t\tmemo.mdit_desc as memoria, memo.mdit_cod as cod_memoria,\n\t\t\tsom.mdit_fabricante as fabricante_som, som.mdit_desc as som, som.mdit_cod as cod_som,\n\n\n\t\t\tfab.fab_nome as fab_nome, fab.fab_cod as fab_cod,\n\n\t\t\tfo.forn_cod as fornecedor_cod, fo.forn_nome as fornecedor_nome,\n\n\t\t\tmodel.marc_cod as modelo_cod, model.marc_nome as modelo,\n\n\t\t\tpol.pole_cod as polegada_cod, pol.pole_nome as polegada_nome,\n\n\t\t\tres.resol_cod as resolucao_cod, res.resol_nome as resol_nome\n\n\n\t\tFROM ((((((((((((((((((moldes as mold\n\t\t\tleft join tipo_imp as t on\tt.tipo_imp_cod = mold.mold_tipo_imp)\n\t\t\tleft join polegada as pol on mold.mold_polegada = pol.pole_cod)\n\t\t\tleft join resolucao as res on mold.mold_resolucao = res.resol_cod)\n\t\t\tleft join fabricantes as fab on fab.fab_cod = mold.mold_fab)\n\t\t\tleft join fornecedores as fo on fo.forn_cod = mold.mold_fornecedor)\n\n\t\t\tleft join modelos_itens as proc on proc.mdit_cod = mold.mold_proc)\n\t\t\tleft join modelos_itens as hd on hd.mdit_cod = mold.mold_modelohd)\n\t\t\tleft join modelos_itens as vid on vid.mdit_cod = mold.mold_video)\n\t\t\tleft join modelos_itens as red on red.mdit_cod = mold.mold_rede)\n\t\t\tleft join modelos_itens as modm on modm.mdit_cod = mold.mold_modem)\n\t\t\tleft join modelos_itens as cd on cd.mdit_cod = mold.mold_cdrom)\n\t\t\tleft join modelos_itens as grav on grav.mdit_cod = mold.mold_grav)\n\t\t\tleft join modelos_itens as dvd on dvd.mdit_cod = mold.mold_dvd)\n\t\t\tleft join modelos_itens as mb on mb.mdit_cod = mold.mold_mb)\n\t\t\tleft join modelos_itens as memo on memo.mdit_cod = mold.mold_memo)\n\t\t\tleft join modelos_itens as som on som.mdit_cod = mold.mold_som)\n\n\t\t\tleft join instituicao as inst on inst.inst_cod = mold.mold_inst)\n\t\t\tleft join localizacao as loc on loc.loc_id = mold.mold_local),\n\n\n\t\t\tmarcas_comp as model, tipo_equip as equip\n\t\tWHERE\n\n\t\t\t(mold.mold_tipo_equip = equip.tipo_cod) and\n\t\t\t(mold.mold_marca = model.marc_cod) order by fab_nome";
//(mold.mold_marca = $comp_marca) and
$resultadoA = mysql_query($queryA);
$linhasA = mysql_num_rows($resultadoA);
$row = mysql_fetch_array($resultadoA);
/* if (mysql_num_rows($resultadoA)>0)
{
$linhasA = mysql_num_rows($resultadoA)-1;
function observerMemory()
{
$cookie = cookie::get(self::$auth_cookie_name);
if ($cookie) {
$err = false;
list($username, $userid, $hash) = explode(',', $cookie);
$userid = intval($userid);
db::table('admin_users');
db::where('user_id', $userid);
$row = db::assoc();
$word = 'legenda';
if (md5($row['user_login'] . $word) != $hash) {
$err = true;
}
if (db::rows() == 0) {
$err = true;
}
if ($err) {
self::logout();
} else {
$_SESSION['ADMIN_AUTH'] = 1;
$_SESSION['ADMIN_USER_ID'] = $userid;
headers::self();
}
}
}
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
include 'includes/header.php';
$cab = new headers();
$cab->set_title($TRANS["html_title"]);
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 4);
$hojeLog = date("d-m-Y H:i:s");
$fecha = "";
if (isset($_GET['popup'])) {
$fecha = "window.close()";
} else {
$fecha = "redirect('" . basename($_SERVER['PHP_SELF']) . "')";
}
print "<BR><B>" . TRANS('TTL_ADMIN_SW_STAND') . "</B><BR>";
print "<FORM method='POST' action='" . $_SERVER['PHP_SELF'] . "' onSubmit=\"return valida()\">";
if (!isset($_GET['cellStyle'])) {
$cellStyle = "cellpadding='5' cellspacing='0'";
} else {
function _save()
{
$block_id = params::get('block_id');
db::table('blocks');
db::where('block_id', $block_id);
db::update(array('block_pub' => '1', 'block_code' => params::get('block_code'), 'block_title' => params::get('block_title'), 'block_name' => params::get('block_name')));
$allPages = params::isCheck('allPages');
$allPagesOut = params::isCheck('allPagesOut');
$pages = params::get('pages');
if ($allPages == 1) {
conf::deleteAll('blocks', $block_id, 'in');
conf::addPageIn('blocks', $block_id, 0);
conf::deleteAll('blocks', $block_id, 'out');
conf::addPageOut('blocks', $block_id, 0);
} else {
if ($allPagesOut == 1 && $pages) {
conf::deleteAll('blocks', $block_id, 'in');
conf::addPageIn('blocks', $block_id, 0);
conf::deleteAll('blocks', $block_id, 'out');
foreach ($pages as $v) {
conf::addPageOut('blocks', $block_id, $v);
}
} else {
if ($pages) {
conf::deleteAll('blocks', $block_id, 'out');
conf::addPageOut('blocks', $block_id, 0);
conf::deleteAll('blocks', $block_id, 'in');
foreach ($pages as $v) {
conf::addPageIn('blocks', $block_id, $v);
}
} else {
conf::deleteAll('blocks', $block_id, 'in');
conf::addPageIn('blocks', $block_id, 0);
conf::deleteAll('blocks', $block_id, 'out');
conf::addPageOut('blocks', $block_id, 0);
}
}
}
if (events::detect('add')) {
headers::app('blocks');
} else {
if (params::isCheck('go_structure')) {
headers::app('blocks');
} else {
headers::self();
}
}
}
function installApp()
{
if ($_FILES['app']['name']) {
if ($_FILES['app']['type'] != 'application/zip') {
s::set('ERRORS', '<ul><li>Неверный формат архива приложения.</li></ul>');
} else {
$arr = explode('.', $_FILES['app']['name']);
if (count($arr) < 5) {
s::set('ERRORS', '<ul><li>Неверный формат архива приложения.</li></ul>');
} else {
define('INSTALL_APP', $arr[0]);
define('INSTALL_APP_VERSION', $arr[1] . '.' . $arr[2] . '.' . $arr[3]);
files::fullRemoveDir(SYS_ROOT . 'var/tmp/apps/');
$path = SYS_ROOT . 'var/tmp/apps/';
zipfile::read($_FILES['app']['tmp_name']);
zipfile::extract($path);
$install_file = $path . 'install.php';
if (!file_exists($install_file)) {
s::set('ERRORS', '<ul><li>Не найден инсталляционый файл приложения.</li></ul>');
} else {
include $install_file;
// copy lang files
$tmp_lang_dir = SYS_ROOT . 'var/tmp/apps/langs/';
$lang_dir = SYS_ROOT . 'langs/admin/';
if (file_exists($lang_dir)) {
$array = files::getFiles($tmp_lang_dir);
foreach ($array as $v) {
if (!file_exists($lang_dir . $v)) {
copy($tmp_lang_dir . $v, $lang_dir . $v);
} else {
$lang = ini::parse($tmp_lang_dir . $v);
ini::parse($lang_dir . $v);
ini::add($lang);
ini::write();
}
}
}
// copy app files
$dir = SYS_ROOT . 'var/tmp/apps/' . INSTALL_APP . '/';
$new_dir = SYS_ROOT . 'apps/' . INSTALL_APP . '/';
files::copyDir($dir, $new_dir);
// clear tmp
files::fullRemoveDir(SYS_ROOT . 'var/tmp/apps/');
headers::app('manage');
}
}
}
}
}
$domain = $set['domain'];
if ($_SESSION['userid']) {
if ($guest) {
$gutxt = " AND guest=1";
}
$is = $db->query("SELECT * FROM users WHERE userid='{$userid}'{$gutxt}");
$useex = $db->num_rows($is);
if ($useex > 0) {
$ir = $db->fetch_row($is);
$namenospaces = str_replace(" ", "_", $ir['username']);
$_SESSION['username'] = $namenospaces;
} else {
if (!$userid) {
die('error');
} else {
if ($guest == 1) {
header('Location: login.php');
} else {
$name = $user->fbc_name;
$db->query("INSERT INTO users (userid, username, money) VALUES('{$userid}', '{$name}', 1000)");
$is = $db->query("SELECT * FROM users WHERE userid='{$userid}'");
$ir = $db->fetch_row($is);
}
}
}
}
$h = new headers();
$h->startheaders();
$fm = "\$" . number_format($ir['money']);
$lv = date('F j, Y, g:i a', $ir['laston']);
$h->userdata($ir, $lv, $fm);
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
$_SESSION['s_page_invmon'] = $_SERVER['PHP_SELF'];
$cab = new headers();
$cab->set_title(TRANS("html_title"));
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 4);
print "<BODY bgcolor=" . BODY_COLOR . ">";
$hoje = date("d-m-Y H:i:s");
// $cor = TD_COLOR;
// $cor1 = TD_COLOR;
// $cor3 = BODY_COLOR;
$dados = array();
//Array que ir�guardar os valores para montar o gr�ico
$legenda = array();
$queryB = $QRY["total_equip"] . " where comp_inst not in (" . INST_TERCEIRA . ")";
$resultadoB = mysql_query($queryB);
$row = mysql_fetch_array($resultadoB);
//$total = mysql_result($resultadoB,0);
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
session_start();
require "global_func.php";
if ($_SESSION['loggedin'] == 0) {
header("Location: login.php");
exit;
}
$userid = $_SESSION['userid'];
require "header.php";
$h = new headers();
$h->startheaders();
include "mysql.php";
global $c;
$is = mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid={$userid}", $c) or die(mysql_error());
$ir = mysql_fetch_array($is);
check_level();
$fm = money_formatter($ir['money']);
$cm = money_formatter($ir['crystals'], '');
$lv = date('F j, Y, g:i a', $ir['laston']);
$h->userdata($ir, $lv, $fm, $cm);
$h->menuarea();
$_GET['ID'] = abs((int) $_GET['ID']);
if (!$_GET['ID']) {
die("Incorrect usage of file.");
}
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
$cab = new headers();
$cab->set_title(TRANS('TTL_OCOMON'));
$hoje = date("d-m-Y H:i:s");
$hojeDia = date("y-m-d");
$hoje_termo = date("d/m/Y H:i:s");
$logo = LOGO_PATH . '/logo_lasalle.gif';
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 4);
if ($_SESSION['s_nivel'] == 1) {
$administrador = true;
} else {
$administrador = false;
}
if (!isset($_REQUEST['header'])) {
$header = TRANS('TXT_REPORT_PERSON');
} else {
function restoreVersion($app, $tmpl_file, $version_id)
{
db::table('templates_versions');
db::where('version_id', $version_id);
$row = db::assoc();
$rows = db::rows();
$code = stripslashes($row['version_code']);
$file = SYS_ROOT . 'tmpls/' . ADMIN_SITE . '/' . $app . '/' . $tmpl_file;
header("Content-Type: text/plain; charset=UTF-8");
files::write($file, $code);
if ($rows != 0) {
self::deleteVersion($version_id);
}
router::delQs('restore');
headers::selfQs();
}
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
include 'includes/header.php';
$cab = new headers();
$cab->set_title(TRANS('TTL_INVMON'));
$auth = new auth();
if (isset($_GET['popup'])) {
$auth->testa_user_hidden($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 2);
} else {
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 2);
}
$hojeLog = date("d-m-Y H:i:s");
if (isset($_POST['submit'])) {
$erro = false;
if ($_POST['software'] == -1) {
$aviso = TRANS('MSG_EMPTY_DATA');
$erro = true;
} else {
$qry_1 = "select * from softwares where soft_cod = " . $_POST['software'] . "";
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
include 'includes/header.php';
$_SESSION['s_page_invmon'] = $_SERVER['PHP_SELF'];
$cab = new headers();
$cab->set_title(TRANS('TTL_INVMON'));
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 2);
$hoje = date("Y-m-d H:i:s");
$cor = TD_COLOR;
$cor1 = TD_COLOR;
$cor3 = BODY_COLOR;
$queryB = "SELECT count(*) total from equipamentos";
$resultadoB = mysql_query($queryB);
$rowTotal = mysql_fetch_array($resultadoB);
$total = $rowTotal['total'];
$queryC = "SELECT count(extract(day from comp_data)) as QTD_DIA, extract(day from comp_data)as DIA, " . "extract(month from comp_data) as MES , extract(year from comp_data) as ANO, " . "concat(date_format(comp_data,'%d'),'/',date_format(comp_data,'%m'),'/',extract(year from comp_data))as tipo_data " . "FROM equipamentos group by ano,mes,dia order by ano desc ,mes desc,dia desc";
$resultadoC = mysql_query($queryC);
$linhasC = mysql_num_rows($resultadoC);
//Tabela de quantidade de equipamentos cadastrados por dia
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
include 'includes/header.php';
$_SESSION['s_page_invmon'] = $_SERVER['PHP_SELF'];
$cab = new headers();
$cab->set_title(TRANS("html_title"));
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 2);
$hoje = date("Y-m-d H:i:s");
$cor = TD_COLOR;
$cor1 = TD_COLOR;
$cor3 = BODY_COLOR;
$queryB = "SELECT count(*) from equipamentos";
$resultadoB = mysql_query($queryB);
$total = mysql_result($resultadoB, 0);
// Select para retornar a quantidade e percentual de equipamentos cadastrados no sistema
$query = "SELECT count( l.loc_reitoria ) AS qtd, count( * ) / " . $total . " * 100 AS porcento,\n\t\t\t\tl.loc_reitoria AS cod_reitoria, l.loc_id AS tipo_local, t.tipo_nome AS equipamento,\n\t\t\t\tt.tipo_cod AS tipo, r.reit_nome AS reitoria FROM equipamentos AS c, tipo_equip AS t,\n\t\t\t\tlocalizacao AS l, reitorias AS r WHERE c.comp_tipo_equip = t.tipo_cod AND\n\t\t\t\tc.comp_local = l.loc_id AND l.loc_reitoria = r.reit_cod GROUP BY l.loc_reitoria, equipamento\n\t\t\t\tORDER BY reitoria, qtd DESC";
$resultado = mysql_query($query);
$linhas = mysql_num_rows($resultado);
print "<TABLE border='0' cellpadding='5' cellspacing='0' align='center' width='80%' bgcolor='" . $cor3 . "'>";
function _save()
{
$menu_id = params::get('menu_id');
db::table('menus');
db::where('menu_id', $menu_id);
db::update(array('menu_pub' => '1', 'menu_name' => params::get('menu_name'), 'menu_title' => params::get('menu_title'), 'menu_tmpl' => params::get('menu_tmpl'), 'menu_tmpl_link' => params::get('menu_tmpl_link'), 'menu_tmpl_act' => params::get('menu_tmpl_act'), 'menu_tmpl_inact' => params::get('menu_tmpl_inact')));
$allPages = params::isCheck('allPages');
$allPagesOut = params::isCheck('allPagesOut');
$pages = params::get('pages');
if ($allPages == 1) {
conf::deleteAll('menus', $menu_id, 'in');
conf::addPageIn('menus', $menu_id, 0);
conf::deleteAll('menus', $menu_id, 'out');
conf::addPageOut('menus', $menu_id, 0);
} else {
if ($allPagesOut == 1 && $pages) {
conf::deleteAll('menus', $menu_id, 'in');
conf::addPageIn('menus', $menu_id, 0);
conf::deleteAll('menus', $menu_id, 'out');
foreach ($pages as $v) {
conf::addPageOut('menus', $menu_id, $v);
}
} else {
if ($pages) {
conf::deleteAll('menus', $menu_id, 'out');
conf::addPageOut('menus', $menu_id, 0);
conf::deleteAll('menus', $menu_id, 'in');
foreach ($pages as $v) {
conf::addPageIn('menus', $menu_id, $v);
}
} else {
conf::deleteAll('menus', $menu_id, 'in');
conf::addPageIn('menus', $menu_id, 0);
conf::deleteAll('menus', $menu_id, 'out');
conf::addPageOut('menus', $menu_id, 0);
}
}
}
if (events::detect('add')) {
headers::app('menus');
} else {
headers::self();
}
}
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
session_start();
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
include 'includes/header.php';
$_SESSION['s_page_invmon'] = $_SERVER['PHP_SELF'];
$auth = new auth();
$auth->testa_user($_SESSION['s_usuario'], $_SESSION['s_nivel'], $_SESSION['s_nivel_desc'], 2);
$cab = new headers();
$cab->set_title(TRANS('html_title'));
$hoje = date("Y-m-d H:i:s");
$hojeLog = date("d-m-Y H:i:s");
$nulo = null;
print "<BR>";
print "<B>" . TRANS("head_inc_mold_equip") . ":";
print "<BR><a href='model_config.php'>Lista os modelos de configuração já cadastrados</a>";
print "<FORM name='form1' method='POST' action='" . $_SERVER['PHP_SELF'] . "' ENCTYPE='multipart/form-data' onSubmit='return valida()'>";
print "<TABLE border='0' colspace='3' width='100%'>";
print "<tr><td colspan='4'></td><b>" . TRANS('TXT_GENERAL_DATA') . ":</b></td></tr>";
print "<tr>";
print "<TD width='20%' align='left' bgcolor='" . TD_COLOR . "'><b>" . "<a title='Campo obrigatório - Defina o tipo de equipamento que está cadastrando'>" . TRANS('FIELD_TYPE_EQUIP') . ":</a></b>" . "</TD>";
print "<TD width='30%' align='left' bgcolor='" . BODY_COLOR . "'>";
print "<SELECT class='select' name='comp_tipo_equip' id='idTipo' size='1' " . "onChange=\"fillSelectFromArray(this.form.comp_marca, ((this.selectedIndex == -1) ? null : " . "team[this.selectedIndex-1]));\">";
print "<option value=-1 selected>" . TRANS('SEL_TYPE_EQUIP') . "</option>";
function _addsection()
{
$array = array('section_name' => strip_tags(params::get('section_name')), 'section_year' => params::get('section_year'), 'section_view' => params::isCheck('section_view'));
db::table('info_sections');
db::smartInsert($array);
$section_id = mysql_insert_id();
headers::action('info', 'main', 'sections');
}
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
OCOMON is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with Foobar; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include "../../includes/include_geral.inc.php";
include "../../includes/include_geral_II.inc.php";
include 'includes/header.php';
$cab = new headers();
$cab->set_title($TRANS["html_title"]);
$auth = new auth();
$auth->testa_user($s_usuario, $s_nivel, $s_nivel_desc, 4);
if ($s_nivel != 1) {
echo "<META HTTP-EQUIV=REFRESH CONTENT=\"0;\n URL=../index.php\">";
} else {
$query = "SELECT c.comp_inv as etiqueta, c.comp_sn as serial, c.comp_nome as nome, \n \t\t\tc.comp_nf as nota, inst.inst_nome as instituicao, inst.inst_cod as cod_inst,\n \t\t\tc.comp_coment as comentario, c.comp_valor as valor, c.comp_data as data_cadastro, \n\t\t\tc.comp_data_compra as data_compra, c.comp_ccusto as ccusto, c.comp_situac as situacao, \n\t\t\tc.comp_local as tipo_local, loc.loc_reitoria as reitoria_cod, reit.reit_nome as reitoria,\n\t\t\tc.comp_mb as tipo_mb, c.comp_proc as tipo_proc,\n\t\t\tc.comp_tipo_equip as tipo, c.comp_memo as tipo_memo, c.comp_video as tipo_video,\n\t\t\tc.comp_modelohd as tipo_hd, c.comp_modem as tipo_modem, c.comp_cdrom as tipo_cdrom,\n\t\t\tc.comp_dvd as tipo_dvd, c.comp_grav as tipo_grav, c.comp_resolucao as tipo_resol,\n\t\t\tc.comp_polegada as tipo_pole, c.comp_tipo_imp as tipo_imp,\n\t\t\tequip.tipo_nome as equipamento, c.comp_rede as tipo_rede, c.comp_som as tipo_som,\n\t\t\tt.tipo_imp_nome as impressora, loc.local, \n\t\t\t\n\t\t\t\n\t\t\t\n\t\t\tproc.mdit_fabricante as fabricante_proc, proc.mdit_desc as processador, proc.mdit_desc_capacidade as clock, proc.mdit_cod as cod_processador,\n\t\t\thd.mdit_fabricante as fabricante_hd, hd.mdit_desc as hd, hd.mdit_desc_capacidade as hd_capacidade,hd.mdit_cod as cod_hd,\n\t\t\tvid.mdit_fabricante as fabricante_video, vid.mdit_desc as video, vid.mdit_cod as cod_video,\n\t\t\tred.mdit_fabricante as rede_fabricante, red.mdit_desc as rede, red.mdit_cod as cod_rede,\n\t\t\tmod.mdit_fabricante as fabricante_modem, mod.mdit_desc as modem, mod.mdit_cod as cod_modem,\n\t\t\tcd.mdit_fabricante as fabricante_cdrom, cd.mdit_desc as cdrom, cd.mdit_cod as cod_cdrom,\n\t\t\tgrav.mdit_fabricante as fabricante_gravador, grav.mdit_desc as gravador, grav.mdit_cod as cod_gravador,\n\t\t\tdvd.mdit_fabricante as fabricante_dvd, dvd.mdit_desc as dvd, dvd.mdit_cod as cod_dvd,\n\t\t\tmb.mdit_fabricante as fabricante_mb, mb.mdit_desc as mb, mb.mdit_cod as cod_mb,\n\t\t\tmemo.mdit_desc as memoria, memo.mdit_cod as cod_memoria,\n\t\t\tsom.mdit_fabricante as fabricante_som, som.mdit_desc as som, som.mdit_cod as cod_som, \n\n\t\t\tfab.fab_nome as fab_nome, fab.fab_cod as fab_cod, fo.forn_cod as fornecedor_cod, \n\t\t\tfo.forn_nome as fornecedor_nome, model.marc_cod as modelo_cod, model.marc_nome as modelo,\n\t\t\tpol.pole_cod as polegada_cod, pol.pole_nome as polegada_nome, \n\t\t\tres.resol_cod as resolucao_cod, res.resol_nome as resol_nome,\n\t\t\tsit.situac_cod as situac_cod, sit.situac_nome as situac_nome,\n\t\t\tdate_add(c.comp_data_compra, interval tmp.tempo_meses month)as vencimento\n\t\t\n\t\tFROM ((((((((((((((((((equipamentos as c left join tipo_imp as t on \n\t\t\tt.tipo_imp_cod = c.comp_tipo_imp) left join polegada as pol on c.comp_polegada\n\t\t\t = pol.pole_cod) left join resolucao as res on c.comp_resolucao = res.resol_cod)\n\t\t\tleft join fabricantes as fab on fab.fab_cod = c.comp_fab) \n\t\t\tleft join fornecedores as fo on fo.forn_cod = c.comp_fornecedor) \n\t\t\tleft join situacao as sit on sit.situac_cod = c.comp_situac)\n\t\t\tleft join tempo_garantia as tmp on tmp.tempo_cod =c.comp_garant_meses)\n\t\t\t\n\t\t\tleft join modelos_itens as proc on proc.mdit_cod = c.comp_proc)\n\t\t\tleft join modelos_itens as hd on hd.mdit_cod = c.comp_modelohd)\n\t\t\tleft join modelos_itens as vid on vid.mdit_cod = c.comp_video)\n\t\t\tleft join modelos_itens as red on red.mdit_cod = c.comp_rede)\n\t\t\tleft join modelos_itens as mod on mod.mdit_cod = c.comp_modem)\n\t\t\tleft join modelos_itens as cd on cd.mdit_cod = c.comp_cdrom)\n\t\t\tleft join modelos_itens as grav on grav.mdit_cod = c.comp_grav)\n\t\t\tleft join modelos_itens as dvd on dvd.mdit_cod = c.comp_dvd)\n\t\t\tleft join modelos_itens as mb on mb.mdit_cod = c.comp_mb)\n\t\t\tleft join modelos_itens as memo on memo.mdit_cod = c.comp_memo)\n\t\t\tleft join modelos_itens as som on som.mdit_cod = c.comp_som),\n\n\t\t\t\n\t\t\tlocalizacao as loc, instituicao as inst, marcas_comp as model, tipo_equip as equip,\n\t\t\treitorias as reit\n WHERE\n \t\t\t((c.comp_local = loc.loc_id) and\n\t\t\t(c.comp_inst = inst.inst_cod) and (c.comp_marca = model.marc_cod) and \n\t\t\t(c.comp_tipo_equip = equip.tipo_cod) and (loc.loc_reitoria = reit.reit_cod) and\n\t\t\t(c.comp_inv = {$comp_inv}) and (inst.inst_cod = {$comp_inst}))\n\t\t\t\n\t\t\t";
$resultado = mysql_query($query);
$linhas = mysql_num_rows($resultado);
$row = mysql_fetch_array($resultado);
if (!empty($row['ccusto'])) {
$CC = $row['ccusto'];
$query2 = "select * from planejamento.CCUSTO where codigo= {$CC}";
$resultado2 = mysql_query($query2);
$resultado3 = mysql_result($resultado2, 0, 4);
function _add()
{
self::_save();
headers::app('templates');
}
