Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/administrador/models/orders/AddOrder.php
Назад
<?php @session_start(); if(isset($_SESSION["ad_id"])){ date_default_timezone_set('America/Mexico_City'); $hoy=date('Y-m-d H:i:s'); //Archivo de Configuracion include("../connection/config.php"); mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); try{ //Crear Objeto para conexion $conexion = new mysqli($host, $user, $pass, $db); } catch (Exception $e) { //echo $e->getMessage(); $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Error de conexión. Contacte a TI'); echo json_encode($arr); exit; } $query_exist = " SELECT folio FROM ordenes WHERE id_usuario='".$_SESSION["ad_id"]."' ORDER BY folio DESC LIMIT 1"; $consu_exist = $conexion -> query($query_exist); $conta_exist = mysqli_num_rows($consu_exist); $execu_cliente = $consu_exist->fetch_array(MYSQLI_BOTH); if($conta_exist==0){ $folio=1; }else{ $folio = $execu_cliente["folio"]+1; } $referencia = $_POST['referencia']; $cliente = $_POST['cliente']; $direccion = $_POST['direccion']; $subarea = $_POST['area']; $total = str_replace('$', '', $_POST['total']); $totalF=str_replace(',', '', $total); $query_subarea = " SELECT * FROM subarea WHERE id = '$subarea'"; $consu_subarea = $conexion -> query($query_subarea); $execu_subarea = $consu_subarea->fetch_array(MYSQLI_BOTH); $area = $execu_subarea["id_area"]; if($referencia!=''){ if($cliente!=''){ if($direccion!=''){ if($area!=''){ if($total!=''){ if(isset($_FILES['file']['name'])){ //var_dump($_FILES['file']['tmp_name']); /* Getting file name */ $filename = $_FILES['file']['name']; //var_dump($filename); /* Location */ $location = "../../anexos/".$cliente."/".$folio."/".$filename; $targetPath = "../../anexos/".$cliente."/".$folio."/"; if (!file_exists($targetPath)) { mkdir($targetPath, 0777, true); } $imageFileType = pathinfo($location,PATHINFO_EXTENSION); $imageFileType = strtolower($imageFileType); /* Valid extensions */ $valid_extensions = array("jpg","jpeg","png","pdf","zip","rar","dwg","doc","docx","xls","xlsx"); $response = 0; /* Check file extension */ if(in_array(strtolower($imageFileType), $valid_extensions)) { if(@move_uploaded_file($_FILES['file']['tmp_name'],$location)){ $conexion->begin_transaction(); try{ $addPanel="INSERT INTO ordenes ( id, id_usuario, id_cliente, id_area, id_subarea, id_envio, folio, referencia, creacion, entrega, total, anexo, estatus ) VALUES( '', '".$_SESSION["ad_id"]."', '$cliente', '$area', '$subarea', '$direccion', '$folio', '$referencia', NOW(), NOW(), '$totalF', '$filename', 'Abierta' )"; $res_add=$conexion -> query($addPanel); $addPanel1="INSERT INTO log_movimientos_ordenes ( id, id_usuario, id_area, id_subarea, id_orden, fecha, comentarios ) VALUES( '', '".$_SESSION["ad_id"]."', '$area', '$subarea', '".$conexion->insert_id."', NOW(), '$Comenatrios' )"; $res_add1=$conexion -> query($addPanel1); $conexion->commit(); } catch (Exception $e) { $conexion->rollback(); //echo $e->getMessage(); $arr = array('status' => 100, 'detail' => 'error', 'message' => "Error. Contacte a TI [".$e->getMessage().$totalF."]"); echo json_encode($arr); exit; } if($res_add){ $arr = array('status' => 200, 'detail' => 'success', 'message' => 'Se agrego correctamente'); echo json_encode($arr); }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => $conexion->error); echo json_encode($arr); } }else{ $arr = array('status' => 200, 'detail' => 'error', 'message' => 'No se pudo cargar el archivo. Contacte a TI'); echo json_encode($arr); } }else{ $arr = array('status' => 200, 'detail' => 'error', 'message' => 'Extensiones validas ["jpg","jpeg","png","pdf","zip","rar","dwg","doc","docx","xls","xlsx"]'); echo json_encode($arr); } }else{ $arr = array('status' => 200, 'detail' => 'error', 'message' => 'Selecciona un archivo'); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe total'); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe area'); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe direccion'); echo json_encode($arr); } } else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe cliente'); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe referencia'); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'Su sesion ha expirado, por favor ingrese nuevamente'); echo json_encode($arr); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка