Location: PHPKode > projects > Livraria Navi - Ej Project > LivrariaNavi.03/includes/lixo/clienteMaiusc.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="stylesheet" type="text/css" media="screen"
	href="jqgrid/themes/redmond/jquery-ui-1.8.1.custom.css" />
<link rel="stylesheet" type="text/css" media="screen"
	href="jqgrid/themes/sand/grid.css" />
<link rel="stylesheet" type="text/css" media="screen"
	href="jqgrid/themes/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen"
	href="jqgrid/themes/ui.multiselect.css" />
<script type="text/javascript" src="jqgrid/js/jquery-1.4.2.min.js"></script>
<script type="text/javascript"
	src="jqgrid/js/jquery-ui-1.8.1.custom.min.js"></script>
<script type="text/javascript" src="jqgrid/js/ui.multiselect.js"></script>
<script type="text/javascript" src="jqgrid/js/i18n/grid.locale-pt-br.js"></script>
<script type="text/javascript" src="jqgrid/js/jquery.jqGrid.min.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Livraria Navi</title>
<style>
html,body {
	margin: 2; /* Remove body margin/padding */
	padding: 2;
	overflow: auto; /* Remove scroll bars on browser window */
	font: 12px "Lucida Grande", "Lucida Sans Unicode", Tahoma, Verdana;
}
</style>
</head>
<body>
<table id="s1list" class="scroll" cellpadding="0? cellspacing="0?></table>
<div id="s1pager" class="scroll" style="text-align: center;"></div>

<script type="text/javascript">
var gridimgpath = 'themes/sand/images';

var mygrid = jQuery("#s1list").jqGrid({
   	url:'buscaCliente.php?q=1',
   	autowidth: true, 
	datatype: "json",
   	colNames:['Cod','Nome','Sexo','Tel. Resid.','Celular','Tel. Contato','Email','Logradouro','N°','Bairro','Cidade','UF','País','CEP','Observação'],
   	colModel:[
   		{name:'COD_CLIENTE',index:'TB_CLIENTE.COD_CLIENTE', width:30,editable:false,editoptions:{readonly:true,size:10}},
   		{name:'NOM_CLIENTE',index:'TB_CLIENTE.NOM_CLIENTE', width:200,editable:true,editoptions:{size:50},formoptions:{ rowpos:2, label: "NOME", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'DES_SEXO',index:'TB_CLIENTE.DES_SEXO', width:35,editable:true,edittype:"select",editoptions:{size:50, value:"M:M;F:F"},formoptions:{ rowpos:3, label: "SEXO", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'DES_TELEFONE_RESIDENCIAL',index:'TB_CLIENTE.ES_TELEFONE_RESIDENCIAL', width:80,editable:true,editoptions:{size:50},formoptions:{ rowpos:4, label: "TEL. RESIDENCIAL", elmprefix:"(*)"},editrules:{required:true}},   		
   		{name:'DES_TELEFONE_CELULAR',index:'TB_CLIENTE.DES_TELEFONE_CELULAR', width:80,editable:true,editoptions:{size:50},formoptions:{ rowpos:5, label: "CELULAR", elmprefix:"(*)"},editrules:{required:true}},   		
   		{name:'DES_TELEFONE_CONTATO',index:'TB_CLIENTE.DES_TELEFONE_CONTATO', width:90,editable:true,editoptions:{size:50},formoptions:{ rowpos:6, label: "TEL. CONTATO", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'DES_EMAIL',index:'TB_CLIENTE.DES_EMAIL', width:160,editable:true,editoptions:{size:50},formoptions:{ rowpos:7, label: "EMAIL", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'NOM_LOGRADOURO',index:'TB_CLIENTE.NOM_LOGRADOURO', width:100,editable:true,editoptions:{size:50},formoptions:{ rowpos:8, label: "LOGRADOURO", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'DES_NUMERO',index:'TB_CLIENTE.DES_NUMERO', width:30,editable:true,editoptions:{size:50},formoptions:{ rowpos:9, label: "NÚMERO", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'NOM_BAIRRO',index:'TB_CLIENTE.NOM_BAIRRO', width:100,editable:true,editoptions:{size:50},formoptions:{ rowpos:10, label: "BAIRRO", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'NOM_CIDADE',index:'TB_CLIENTE.NOM_CIDADE', width:100,editable:true,editoptions:{size:50},formoptions:{ rowpos:11, label: "CIDADE", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'COD_UF',index:'TB_CLIENTE.COD_UF', width:20,editable:true,edittype:"select",editoptions:{value:":;AC:Acre;AL:Alagoas;AM:Amazonas;AP:Amapá;BA:Bahia;CE:Ceará;DF:Distrito Federal;ES:Espírito Santo;GO:Goias;MA:Maranhão;MT:Mato Grosso;MS:Mato Grosso do Sul;MG:Minas Gerais;PA:Pará;PB:Paraíba;PR:Paraná;PE:Pernambuco;PI:Piauí;RJ:Rio de Janeiro;RN:Rio Grande do Norte;RS:Rio Grande do Sul;RR:Roraima;RO:Rondônia;SC:Santa Catarina;SP:São Paulo;SE:Sergipe;TO:Tocatins",size:60},formoptions:{ rowpos:12, label: "ESTADO", elmprefix:"   "},editrules:{required:true}},
   		{name:'COD_PAIS',index:'TB_CLIENTE.COD_PAIS', width:30,editable:true,editoptions:{size:50},formoptions:{ rowpos:13, label: "PAIS", elmprefix:"(*)"},editrules:{required:false}},
   		{name:'COD_CEP',index:'TB_CLIENTE.COD_CEP', width:70,editable:true,editoptions:{size:50},formoptions:{ rowpos:14, label: "CEP", elmprefix:"(*)"},editrules:{required:true}},
   		{name:'DES_OBSERVACAO_CLIENTE',index:'TB_CLIENTE.DES_OBSERVACAO_CLIENTE', width:100,editable:true,editoptions:{size:50},formoptions:{ rowpos:15, label: "OBSERVAÇÃO", elmprefix:"   "},editrules:{required:false}},
   	],
   	rowNum:10,
   	rowList:[10,20,30],
   	pager: '#s1pager',
   	sortname: 'NOM_CLIENTE',
    viewrecords: true,
    sortorder: "asc",
    caption:"Clientess Cadastrados",
    editurl:"editaCliente.php",
	height:210,
});
jQuery("#s1list").jqGrid('navGrid','#s1pager',
		{view:true}, //options
		{jqModal:true,checkOnUpdate:true,savekey: [true,13], width:400, navkeys: [true,38,40], checkOnSubmit : true, reloadAfterSubmit:false, closeOnEscape:true, bottominfo:"(*)Campo Obrigatório"}, // edit options
		{jqModal:true,checkOnUpdate:true,savekey: [true,13], width:400, navkeys: [true,38,40], checkOnSubmit : true, reloadAfterSubmit:false, closeOnEscape:true,bottominfo:"(*)Campo Obrigatório"}, // add options
		{reloadAfterSubmit:false,jqModal:false, closeOnEscape:true}, // del options
		{closeOnEscape:true,}, // search options
		{navkeys: [true,38,40], height:250,jqModal:false,closeOnEscape:true} // view options
		)
</script>
</body>
</html>
Return current item: Livraria Navi - Ej Project