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>";
$query = "SELECT * from tipo_equip order by tipo_nome";
(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);
//$row2 = mysql_fetch_array($resultado2);
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
print "<TABLE border='0' cellpadding='5' cellspacing='0' align='center' width='60%' bgcolor='" . $cor3 . "'>";
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 . "'>";
print "<tr><td class='line'></TD></tr>";
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;
}
(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 {
$header = $_REQUEST['header'];
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(".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(*) 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\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 . "'>";
print "<tr><td width='80%' align='center'><b>" . TRANS('TTL_TOTAL_EQUIP_CAD_MAJOR') . ":</b></td></tr>";
