projeto/addMunicipio.php at master · fabiocmazzo/projeto · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?php
 require_once 'includes/config.php';
 require_once 'header.php';
 ?>

  <script type="text/javascript">

                   function gravar() {

                    if($("#customForm").validationEngine('validate')) {
                      	var action = '/actions/atualizarMunicipio.php';
                        var form_data = {
			              idMunicipio: $("#idMunicipio").val(),
			              nmMunicipio: $("#nmMunicipio").val(),
                          UF:          $("#UF").val(),
                          cdIBGE:      $("#cdIBGE").val(),
                          idLote:      $("#idLote").val()
			             };

                       $.ajax({
			             type: "POST",
			             url: action,
			             data: form_data,
			             success: function(response)
			             {
                             alert("Gravado com sucesso");
				             window.location = "municipios.php";


                       	}
	                  	});
                  }
                  }

                  function cancelar() {
                    window.location = "municipios.php";
                  }


    </script>

   <div class="main">
        <div class="speedbar">
        <div class="speedbar-nav">Cadastro Famílias</div>
   </div>


        <?php

             if(isset($_REQUEST['id'])) {
                $idMunicipio = $_REQUEST['id'];
                $sql = 'select * from municipio where idMunicipio = ' . $idMunicipio;
                $result = $db->query($sql);
                $row = $result->fetch_assoc();
             } ?>


        	<!--Form-->

        <div class="grid-1">
           <div class="title-grid">Cadastrar Novo Município</div>
           <div class="content-gird">
           <div class="form">
          	 <form method="post" id="customForm" action="#">

               <?php if(isset($idMunicipio)) { ?>
                 <div class="elem">
                        <label>Código Município: </label>
                        <div class="indent">
                            <input type="hidden" id="idMunicipio" name="idMunicipio" value="<?=$row['idMunicipio']?>"> <?=$row['idMunicipio']?>
                        </div>
                 </div>
                <?php } ?>

                 <div class="elem">
                        <label>Nome Município: </label>
                        <div class="indent">
                            <input type="text" id="nmMunicipio" name="nmMunicipio" maxlength="100" value="<?=$row['nmMunicipio']?>" class="medium validate[required] text-input">
                        </div>
                 </div>
              <div class="elem">
                        <label>Lote:</label>
                        <div class="indent">
                         <select id="idLote" name="idLote" class="chzn-select medium-select select">
                           <?php
                               $sqlLote = 'select idLote, nmLote from lote';
                               $resultLote = $db->query($sqlLote);

                               while($rowL = $resultLote->fetch_assoc()) { ?>
                                <option value="<?=$rowL['idLote']?>"<?php $rowL['idLote'] == $row['idLote'] ? ' selected ' : ''; ?>><?=$rowL['nmLote']?>&nbsp;&nbsp;&nbsp;&nbsp;</option>
                               <?php } ?>
                        </select>
                        </div>
                 </div>

               <div class="elem">
                        <label>Estado:</label>
                        <div class="indent">
                          <select name="UF" id="UF" class="chzn-select medium-select validate[required] select">
                             <option value="">Selecione...</option>
                             <?php
                               $sqlEstado = 'select * from estado order by UF';
                               $resultEstado = $db->query($sqlEstado);

                               while($rowE = $resultEstado->fetch_assoc()) { ?>
                                <option value="<?=$rowE['UF']?>"<?php $rowE['UF'] == $row['UF'] ? ' selected ' : ''; ?> ><?=$rowE['descricao']?>&nbsp;&nbsp;&nbsp;&nbsp;</option>
                             <?php } ?>
                        </select>
                         </select>
                  </div>
             </div>
                 <div class="elem">
                        <label>Código IBGE:</label>
                        <div class="indent">
                            <input type="text" id="cdIBGE" name="cdIBGE" class="medium" value="<?=$row['cdIBGE']?>">
                        </div>
                 </div>

            	 <div class="elem">

                        <div class="indent">

                          <input id="gravarM" name="gravarM" onclick="gravar();" type="button" class="button-a gray" value="Gravar" />
                          <input id="cancelarM" name="cancelarM" onclick="cancelar();" type="button" class="button-a gray" value="Cancelar" />
                        </div>
                 </div>
                 </form>
    		 <div class="clear"> </div>
             </div>
           </div>
        </div>
		<!--Form end-->


   </div><!-- END MAIN-->

   <?php
     require_once 'barralateral.php';
     require_once 'footer.php';