0) { // si es mayor a 1, es guia de retorno //$sql= "SELECT Max(pacnume) as pacnume,pacguide,pacstatus FROM packets where pacguide='$pacguide' and comnume=$comnume GROUP BY pacguide HAVING COUNT(*)>1"; $rs = mysqli_query($conexion,$sql); $rows = mysqli_fetch_assoc($rs); $pacnume = $rows["pacnume"]; $pacstatus = $rows["pacstatus"]; $sqlA= "Select * from assignments where pacnume=$pacnume and comnume=$comnume and stanume=4 and assstatus=1"; $rsA = mysqli_query($conexion,$sqlA); $numrowsA = mysqli_num_rows($rsA); if ($numrowsA> 0) { // echo "La guía digitada [".$pacguide."] ya se encuentra asignada"; echo "1"; }else{ // echo "La guía digitada [".$pacguide."] en proceso de asignación"; $sqlI= "INSERT INTO assignments (assdate, pacnume, assdelivery, usunume, comnume) VALUES ('$assdate',$pacnume,$assdelivery,$usunume,$comnume)"; $rsI = mysqli_query($conexion,$sqlI); //companiesUpdate($comnume,$conexion); //packetsRecords($conexion,$pacnume,2,$assdelivery,$usunume,2); $sqlr= "INSERT INTO records(pacnume,stanume,promoter,usunume) values ($pacnume,2,$assdelivery,$usunume)"; $rsr = mysqli_query($conexion,$sqlr); $date = date("Y-m-d H:i:s"); $sqlc= "UPDATE companies set comdateupdate='$date' where comnume=$comnume"; $ok = mysqli_query($conexion,$sqlc); echo "2"; } }else{ //echo "La guía digitada [".$pacguide."] no existe"; echo "3"; } } else { // RETORNANDO AL PANEL DE INGRESO DE USUARIO echo ''; } ?>