function add_persona() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $tipo = $_POST['tipo']; $nombre = $_POST['nombre']; $ced = $_POST['ced']; $lic = $_POST['lic']; $lic_v = $_POST['lic_v']; $dir = $_POST['dir']; $tel = $_POST['tel']; $cel = $_POST['cel']; $f1 = $_POST['f1']; $f2 = $_POST['f2']; $placa = $_POST['placa']; if ($tipo == 1) { $placa = "0"; } if ($nombre == "") { $res = false; $mes = $msg->get_msg("e005"); } else { $con = new con(); $con->connect(); /* verificamos que no esté registrado en la tabla de personas*/ $res_existe = $fun->existe("personas", "pe_cedula", $ced); if (!$res_existe) { /* ingresamos datos de la persona */ $qry = "INSERT INTO tbl_personas \n\t\t\t\t(pe_nombre, pe_tel, pe_cedula, pe_licencia, pe_licencia_vigencia, pe_dir, pe_cel, pe_tipo, pe_created, pe_estado, pe_f1, pe_f2, pe_ve_id) \n\t\t\t\tVALUES \n\t\t\t\t('" . $nombre . "', '" . $tel . "', '" . $ced . "', '" . $lic . "', '" . $lic_v . "', '" . $dir . "', '" . $cel . "', '" . $tipo . "', " . $_SESSION["ses_id"] . ", 1 , '" . $f1 . "', '" . $f2 . "', " . $placa . ");"; //echo "QUERY: ".$qry; $resp = mysql_query($qry); if (!$resp) { $res = false; $mes = $msg->get_msg("e003"); } else { $res = true; $mes = $msg->get_msg("e004"); } } else { $res = false; $mes = $msg->get_msg("e003-1", "El usuario ya existe"); } } $response->res = $res; $response->mes = $mes; echo json_encode($response); $con->disconnect(); }
function login() { $msg = new messages(); $fun = new funciones(); if (!$fun->isAjax()) { header("Location: login.php"); } $con = new con(); $con->connect(); $response = new StdClass(); $usu = $_POST['usr']; $pass = $_POST['psw']; $pass = sha1(md5($pass)); /*Consulta a la Bd*/ $selectSQL = "SELECT * FROM `tbl_users` WHERE `us_usuario` = '{$usu}' AND `us_clave` = '{$pass}' AND us_estado = 1"; $row_cons = mysql_query($selectSQL); $existe = mysql_fetch_assoc($row_cons); /*Termina Consulta*/ /*Existe*/ //$existe = 1; if ($existe) { $res = true; $mes = "panel.html"; $_SESSION["ses_id"] = $existe['us_id']; //$menu = 1; } else { $res = false; $mes = $msg->get_msg("e002"); } $response->res = $res; $response->mes = $mes; echo json_encode($response); $con->disconnect(); }
function change_pack() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $act = $_POST["a"]; $id = $_POST["id"]; if ($act == "" || $id == "") { $res = false; $mes = $msg->get_msg("e005"); } else { $con = new con(); $con->connect(); if ($act == 1) { //activar, cambiar a 99 if ($fun->borrar("remisiones_fisicas", "rf_id", $id)) { $res = true; $mes = $msg->get_msg("e004"); } else { $res = false; $mes = $msg->get_msg("e003-1", "Activando remision."); } } else { //desactivar, cambiar a 1 if ($fun->activar("remisiones_fisicas", "rf_id", $id)) { $res = true; $mes = $msg->get_msg("e004"); } else { $res = false; $mes = $msg->get_msg("e003-1", "Desactivando remision."); } } } $response->res = $res; $response->mes = $mes; echo json_encode($response); $con->disconnect(); }
function remove_user() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $user = $_POST["user"]; $res = $fun->borrar("vehiculos", "ve_id", $user); if ($res) { $res = true; $mes = $msg->get_msg("e004"); } else { $res = false; $mes = $msg->get_msg("e022"); } $response->res = $res; $response->mes = $mes; echo json_encode($response); }
function load_row() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $id = $_POST["id"]; if ($id == "") { $res = false; $mes = $msg->get_msg("e005"); } else { $con = new con(); $con->connect(); //traemos datos según sea el id $qry = "SELECT * FROM `tbl_remisiones_fisicas` WHERE rf_id =" . $id . ";"; $data = $fun->get_array($qry); if ($data != false) { $res = true; $response->key = $data[0]['rf_id']; $response->ini = $data[0]['rf_dig_ini']; $response->fin = $data[0]['rf_dig_fin']; $response->inter = $data[0]['rf_interventor']; $response->persona = $data[0]['rf_persona_entrega']; } else { $res = false; $response->mes = $msg->get_msg("e034"); } } $response->res = $res; echo json_encode($response); $con->disconnect(); }
$con = new con(); $con->connect(); $response = new StdClass(); $usu = $_POST['user']; $pass = $_POST['pass']; $pass = sha1(md5($pass)); /* $pass_encriptada1 = md5 ($pass); //Encriptacion nivel 1 $pass_encriptada2 = crc32($pass_encriptada1); //Encriptacion nivel 1 $pass_encriptada3 = sha1("xtemp".$pass_encriptada2); //Encriptacion nivel 3 $pass_encriptada4 = crypt($pass_encriptada3, "xtemp"); //Encriptacion nivel 2 */ /*Consulta a la Bd*/ $selectSQL = "SELECT * FROM `tbl_usuarios` WHERE `us_usuario` = '{$usu}' AND `us_clave` = '{$pass}'"; $row_cons = mysql_query($selectSQL); $existe = mysql_fetch_assoc($row_cons); /*Termina Consulta*/ /*Existe*/ //$existe = 1; if ($existe) { $res = true; $mes = $msg->get_msg("e001"); $_SESSION["ses_id"] = $existe['us_id']; $_SESSION["ses_tipo"] = $existe['us_tipo']; //$menu = 1; } else { $res = false; $mes = $msg->get_msg("e002"); } $response->res = $res; $response->mes = $mes; echo json_encode($response); $con->disconnect();
function del_persona() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $id = $_POST["id"]; $con = new con(); $con->connect(); /* ingresamos datos de la finca */ $tbl = "personas"; $cambios = "pe_estado=99"; $where = "pe_id=" . $id; $r = $fun->actualizar($tbl, $cambios, $where); if ($r) { $res = true; $mes = $msg->get_msg("e004"); } else { $res = false; $mes = $msg->get_msg("e035"); } $response->res = $res; $response->mes = $mes; echo json_encode($response); $con->disconnect(); }
function programar_rutas() { $con = new con(); $msg = new messages(); $fun = new funciones(); $con->connect(); //Fecha date_default_timezone_set("America/Bogota"); $fecha = date('Y-m-d G:i:s'); $filename = "R_" . date('YmdGis'); $filename .= ".html"; $content = ""; $hoy = date('Y-m-d'); $content .= "<h1>Informe, generacion de rutas</h1>"; $content .= "<br>Fecha " . $fecha . "<br>"; //traemos municipios $qry_sn = "SELECT * FROM tbl_subnucleos ORDER BY sn_id ASC"; $res_sn = $fun->get_array($qry_sn); if (!$res_sn) { $content .= $msg->get_msg("e025"); } else { //($res_sn); //cantidad de sn: $cant_sn = count($res_sn); $content .= "Total Municipios: " . $cant_sn . "<br>"; for ($i = 0; $i < $cant_sn; $i++) { $content .= "<h1>municipio nro: " . $res_sn[$i]["sn_id"] . ""; $content .= "=> " . $res_sn[$i]["sn_subnucleo"] . "</h1><br>"; //traemos conductores asociados $qry_con = 'SELECT * FROM tbl_personas INNER JOIN tbl_vehiculos ON ve_id = pe_ve_id WHERE pe_f1 = ' . $res_sn[$i]["sn_id"] . ' OR pe_f2 = ' . $res_sn[$i]["sn_id"] . ' ;'; //$content.= $qry_con; /*HACE FALTA LA DOBLE VALIDACIÓN DE QUE ESTE NO ESTÉ ASIGNADO O SUGERIDO A OTRA FINCA*/ $res_con = $fun->get_array($qry_con); $cant_con = count($res_con); $content .= "<br> cantidad de conductores: " . $cant_con; //para cada subnucleo, listamos sus respectivas fincas $qry_fin = 'SELECT * FROM tbl_fincas WHERE fi_sn_id = ' . $res_sn[$i]["sn_id"] . ';'; $res_fin = $fun->get_array($qry_fin); //traemos inventarios por cada finca $cant_fin = count($res_fin); $content .= "<br> cantidad de fincas: " . $cant_fin . "<br>"; $arr_inv = array(); $pos = 0; $c = 0; for ($j = 0; $j < $cant_fin; $j++) { $qry_inv = 'SELECT * FROM tbl_inventario WHERE in_fi_id = ' . $res_fin[$j]["fi_id"] . ' AND in_mt_restante > 0 AND in_estado=1;'; //$content.= $qry_inv; $res_inv = $fun->get_array($qry_inv); $c = count($res_inv); if ($c > 1) { $pos = $pos + $c; for ($k = 0; $k < $pos; $k++) { $arr_inv[$k] = $res_inv[$k]; } } if ($c == 1) { $arr_inv[$pos] = $res_inv[0]; $pos++; } } $cant_inv = count($arr_inv); $content .= "<br> <h4>cantidad de inventarios de este municipio: " . $cant_inv . "</h4>"; /*$content.= "<pre>"; print_r($arr_inv); $content.= "</pre>";*/ //traemos turnos $qry_tur = 'SELECT * FROM tbl_turnos ORDER BY tu_id ASC'; $res_tur = $fun->get_array($qry_tur); //variables de sesión para cada inventario for ($ci = 0; $ci < $cant_inv; $ci++) { $id_inv = $arr_inv[$ci]["in_id"]; $_SESSION[$id_inv]["inv_rest"] = $arr_inv[$ci]["in_mt_restante"]; //$content.= "<br>prueba variable sesion".$_SESSION[$id_inv]["inv_rest"]; } //recorremos arreglo y vamos asignando conductores if ($cant_inv > 0) { $turno = 0; $tg = 0; for ($doblete = 0; $doblete < 2; $doblete++) { $end = false; $l = 0; while ($end == false) { for ($m = 0; $m < $cant_inv; $m++) { if ($l == $cant_con) { $end = true; break; } //traemos inventario restante //$inv_rest = $fun->get_custom("SELECT in_mt_restante FROM tbl_inventario WHERE in_id=".$arr_inv[$m]["in_id"]); $inv_rest = $_SESSION[$arr_inv[$m]["in_id"]]["inv_rest"]; if ($inv_rest > 0) { $inv_nuevo = $inv_rest - $res_con[$l]["ve_capacidad_m3"]; if ($inv_nuevo >= 0) { $content .= "<pre>"; $content .= "<br> ----> [" . $l . "] asignando cond " . $res_con[$l]["pe_id"] . " (cap. " . $res_con[$l]["ve_capacidad_m3"] . "m<sup>3</sup>) a inventario " . $arr_inv[$m]["in_id"] . " en el turno (" . $turno . "): " . $res_tur[$turno]["tu_hora_ini"] . "\n\t\t\t\t \t\t\tinventario restante: " . $inv_nuevo; $content .= "<br><strong>Actualizacion de inventario tbl_inventario, in_mt_restante =" . $inv_nuevo . "</strong> => resultado: "; //$upd_vol = $fun->actualizar("inventario", "in_mt_restante =".$inv_nuevo, "in_id = ".$arr_inv[$m]["in_id"]); $_SESSION[$arr_inv[$m]["in_id"]]["inv_rest"] = $inv_nuevo; //cargamos en despachos como sugerencia [estado=1] $tbl_des = 'despachos'; $fld_des = 'de_pe_id, de_ve_capacidad_m3, de_in_id, de_tu_id, de_inv_rest, de_created, de_estado'; $val_des = $res_con[$l]["pe_id"] . ',' . $res_con[$l]["ve_capacidad_m3"] . ',' . $arr_inv[$m]["in_id"] . ',' . $res_tur[$turno]["tu_id"] . ',' . $inv_nuevo . ',' . $_SESSION["ses_id"] . ',1'; $res_des = $fun->crear($tbl_des, $fld_des, $val_des); //$content.= "<br>Probando SESSION VAR: inventario restante del inventario (".$arr_inv[$m]["in_id"].") :".$_SESSION[$arr_inv[$m]["in_id"]]["inv_rest"]."<br>"; $res_des = true; if ($res_des) { $tg++; } else { $content .= "(error)"; } } } else { $m++; } $l++; } $turno++; } } $content .= "<h3>Total turnos generados: " . $tg . "</h3>"; } $content .= "<br>+++++++++++++++++++++++++++++++++++++++++++++++++++++++<br>"; } } // generamos informe $fun->create_file($content, $filename); //echo $content; $con->disconnect(); unset($arr_inv); }
function get_cap() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $cod = $_POST["cod"]; $lote = $_POST["lote"]; $qry_cap = "SELECT vol_ica_m3 FROM `tbl_matriz_ica` \n\t\t\t\t\tINNER JOIN tbl_fincas ON fi_codigo = codfinca\n\t\t\t\t\tINNER JOIN tbl_lotes_autorizados ON la_idlote = idlote\n\t\t\t\t\tWHERE fi_id = '" . $cod . "' AND la_id = " . $lote; $res_cap = $fun->get_array($qry_cap); if ($res_cap) { //$fun->print_array($res_inv); $res = true; $mes = $res_cap[0]['vol_ica_m3']; } else { $res = false; $mes = $msg->get_msg("e030"); } $response->res = $res; $response->mes = $mes; echo json_encode($response); }
function upd_vehiculo() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $id = $_POST['id']; $vh = $_POST['vh']; $con = new con(); $con->connect(); $t = "personas"; $c = "pe_ve_id=" . $vh; $w = "pe_id=" . $id; $resp = $fun->actualizar($t, $c, $w); if ($resp) { $res = true; $mes = $msg->get_msg("e004"); } else { $res = false; $mes = $msg->get_msg("e036"); } $con->disconnect(); $response->res = $res; $response->mes = $mes; echo json_encode($response); }
function remove_finca() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $finca = $_POST["finca"]; if ($fun->borrar("fincas", "fi_id", $finca)) { if ($fun->borrar("inventario", "in_fi_id", $finca)) { if ($fun->borrar("control_inventarios", "ci_fi_id", $finca)) { if ($fun->borrar("lotes_autorizados", "la_fi_id", $finca)) { $res = true; $mes = $msg->get_msg("e004"); } else { $res = false; $mes = $msg->get_msg("e016"); } } else { $res = false; $mes = $msg->get_msg("e017"); } } else { $res = false; $mes = $msg->get_msg("e018"); } } else { $res = false; $mes = $msg->get_msg("e015"); } $response->res = $res; $response->mes = $mes; echo json_encode($response); }
function upd_despacho() { $fun = new funciones(); $msg = new messages(); $response = new StdClass(); /*recibimos variables*/ $de_id = $_POST['id']; $opt = $_POST['op']; switch ($opt) { case 1: $estado = 2; break; case 2: $estado = 3; break; case 3: $estado = 99; break; } $con = new con(); $con->connect(); //preguntamos si existe el despacho y si está sugerido $existe = $fun->existe("despachos", "de_id", $de_id, ""); if ($existe) { if ($opt == 1) { $qry_des = 'SELECT * FROM tbl_despachos WHERE de_id=' . $de_id . ';'; //echo "despachos: ".$qry_des; $arr_des = $fun->get_array($qry_des); //$fun->print_array($arr_des); //traemos inventario $qry_inv = 'SELECT * FROM tbl_inventario WHERE in_id =' . $arr_des[0]["de_in_id"] . ';'; //echo "despachos: ".$qry_inv; $arr_inv = $fun->get_array($qry_inv); //$fun->print_array($arr_inv); //tomamos datos y los modificamos $inv_nuevo = $arr_inv[0]["in_mt_restante"] - $arr_des[0]['de_ve_capacidad_m3']; //echo "<br>nuevo inventario: ".$inv_nuevo; //realizar la actualización $upd_vol = $fun->actualizar("inventario", "in_mt_restante =" . $inv_nuevo, "in_id = " . $arr_inv[0]["in_id"]); } $res_upd = $fun->actualizar("despachos", "de_estado=" . $estado, "de_id=" . $de_id); if ($res_upd) { $res = true; $mes = $msg->get_msg('e004'); } else { $res = false; $mes = $msg->get_msg('e027'); } } else { $res = false; $mes = $msg->get_msg('e028'); } $con->disconnect(); $response->res = $res; $response->mes = $mes; echo json_encode($response); }
if (isset($_POST["opt"])) { $bk = new books(); $response = new StdClass(); $mes = new messages(); $fun = new funciones(); switch ($_POST["opt"]) { case 'add': $title = $_POST["title"]; $isbn = $_POST["isbn"]; $autor = $_POST["autor"]; $genre = $_POST["genre"]; $release = $_POST["release"]; $res = $bk->add($title, $isbn, $autor, $genre, $release); if ($res) { $response->res = true; $response->mes = $mes->get_msg("e004"); } else { $response->res = false; $response->mes = $mes->get_msg("e003"); } break; case 'list': $res = $bk->display_list(); if ($res) { $response->res = true; $response->mes = $res; } else { $response->res = false; $response->mes = $mes->get_msg("e005"); } break;