Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/administrador/models/orders/ProcesarOrder.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; } $IdOrden = $_POST['IdOrden']; if($IdOrden!=''){ /* Start transaction */ $conexion->begin_transaction(); try{ $query_quotes = " SELECT * FROM quotes WHERE id_cotizacion = '$IdOrden'"; $consu_quotes = $conexion -> query($query_quotes); $execu_quotes = $consu_quotes->fetch_array(MYSQLI_BOTH); $id_cliente = $execu_quotes["id_cliente"]; $id_envio = $execu_quotes["id_envio"]; $id_facturacion = $execu_quotes["id_facturacion"]; $total = $execu_quotes["total"]; $referencia = $execu_quotes["referencia"]; $addPanel="INSERT INTO ordenes ( id, id_usuario, id_cliente, id_area, id_subarea, id_envio, id_cotizacion, id_facturacion, folio, referencia, creacion, entrega, total, estatus ) VALUES( '', '".$_SESSION["ad_id"]."', '$id_cliente', '6', '10', '$id_envio', '$IdOrden', '$id_facturacion', '$folio', '$referencia', NOW(), NOW(), '$total', 'Abierta' )"; $res_add=$conexion -> query($addPanel); $idOrden=$conexion->insert_id; $query_lines = " SELECT * FROM quote_lines WHERE id_cotizacion = '$IdOrden'"; $consu_lines = $conexion -> query($query_lines); while($execu_lines = $consu_lines->fetch_array(MYSQLI_BOTH)){ $addlines="INSERT INTO orden_lines ( id_partida, id_cotizacion, id_orden, codigo, descripcion, cantidad, um, subtotal, fecha, descuento, activo ) VALUES( '', '".$execu_lines['id_cotizacion']."', '".$idOrden."', '".$execu_lines['codigo']."', '".$execu_lines['descripcion']."', '".$execu_lines['cantidad']."', '".$execu_lines['um']."', '".$execu_lines['subtotal']."', '".$execu_lines['fecha']."', '".$execu_lines['descuento']."', '".$execu_lines['activo']."' )"; $res_add_lines=$conexion -> query($addlines); } $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 proceso correctamente'); echo json_encode($arr); }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => $conexion->error); echo json_encode($arr); } }else{ $arr = array('status' => 100, 'detail' => 'error', 'message' => 'No existe id de orden'); 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
|
Настройка