<?php
/*   __________________________________________________
    |  Obfuscated by YAK Pro - Php Obfuscator  2.0.17  |
    |              on 2026-04-17 06:44:04              |
    |    GitHub: https://github.com/pk-fr/yakpro-po    |
    |__________________________________________________|
*/
 require_once 'PerfilVicidial.php'; class PerfilVicidialDatos { public static function getPerfilVicidialByLeadId(string $lead) : ?PerfilVicidial { goto Yxm3C; gv6Hv: $query = "SELECT lead_id,IFNULL(status,'') as status,list_id,IFNULL(vendor_lead_code,'') as vendor_lead_code,IFNULL(first_name,'') as first_name, IFNULL(last_name,'') as last_name, IFNULL(email,'') as email, IFNULL(address1,'') as address1, IFNULL(postal_code,'') as postal_code,IFNULL(phone_number,'') as phone_number,IFNULL(alt_phone,'') as alt_phone,IFNULL(address3, '') as address3,IFNULL(source_id, '') as source_id FROM vicidial_list WHERE lead_id = '" . limpia($lead) . "' LIMIT 1"; goto FinzO; FinzO: if (!($result = sv_mysqli_query($con, $query))) { goto up9g2; } goto Pj17c; IdSpB: sv_mysqli_close($con); goto UO50A; CVRpk: up9g2: goto IdSpB; aP0rg: $ret = new PerfilVicidial($row["lead_id"], $row["status"], ListaDatos::getListaById($row["list_id"]), $row["vendor_lead_code"], $row["first_name"], $row["last_name"], $row["email"], $row["address1"], $row["postal_code"], $row["phone_number"], $row["alt_phone"], $row["address3"], $row["source_id"]); goto DdfIC; UO50A: return $ret; goto GC0XH; DdfIC: H5ZaC: goto CVRpk; ahwpU: $con = getConnection(); goto gv6Hv; Pj17c: if (!($row = sv_mysqli_fetch_array($result))) { goto H5ZaC; } goto aP0rg; Yxm3C: $ret = null; goto ahwpU; GC0XH: } public static function getPerfilesVicidialByTelefonoAndListas(string $telefono, array $listas) : ?array { goto FX0mr; ykerU: $strListas = ""; goto IzYft; aBMWr: return $ret; goto kbHH8; IAjuN: $arrListas = array(); goto ykerU; ul0aD: yJ44t: goto DU7kB; bpHzv: goto N3xG9; goto ML2mg; F0oLC: SbcNz: goto hTMPx; Tf9H2: $con = getConnection(); goto IAjuN; J8Zbm: $arrListas[] = $listas[$i]->getId(); goto ul0aD; ZLE1O: $query = "SELECT lead_id,IFNULL(status,'') as status,list_id,IFNULL(vendor_lead_code,'') as vendor_lead_code,IFNULL(first_name,'') as first_name, IFNULL(last_name,'') as last_name, IFNULL(email,'') as email, IFNULL(address1,'') as address1, IFNULL(postal_code,'') as postal_code,IFNULL(phone_number,'') as phone_number,IFNULL(alt_phone,'') as alt_phone,IFNULL(address3, '') as address3,IFNULL(source_id, '') as source_id FROM vicidial_list WHERE list_id IN ({$strListas}) AND (phone_number = '" . limpia($telefono) . "' OR alt_phone = '" . limpia($telefono) . "' OR address3 = '" . limpia($telefono) . "') LIMIT 1000"; goto Fvles; E_iAf: $strListas = implode(',', $arrListas); goto ZLE1O; Fvles: if (!($result = sv_mysqli_query($con, $query))) { goto fIMlE; } goto X4ZZ1; unZZV: fIMlE: goto c7Wog; DJyrU: $ret[] = new PerfilVicidial($row["lead_id"], $row["status"], ListaDatos::getListaById($row["list_id"]), $row["vendor_lead_code"], $row["first_name"], $row["last_name"], $row["email"], $row["address1"], $row["postal_code"], $row["phone_number"], $row["alt_phone"], $row["address3"], $row["source_id"]); goto bpHzv; hTMPx: if (!($i < count($listas))) { goto lqN40; } goto J8Zbm; MG9s5: lqN40: goto E_iAf; HV7vq: goto SbcNz; goto MG9s5; IzYft: $i = 0; goto F0oLC; X4ZZ1: N3xG9: goto YBZ_T; DU7kB: $i++; goto HV7vq; ML2mg: HzDsj: goto unZZV; FX0mr: $ret = array(); goto Tf9H2; c7Wog: sv_mysqli_close($con); goto aBMWr; YBZ_T: if (!($row = sv_mysqli_fetch_array($result))) { goto HzDsj; } goto DJyrU; kbHH8: } public static function insertPerfilVicidial(PerfilVicidial $perfilVicidial) : int { goto eXeQV; j7Zy1: $con = getConnection(); goto LqH24; eXeQV: $resp = 0; goto j7Zy1; sV1CS: $resp = mysqli_insert_id($con); goto yH5zh; xeXp0: sv_mysqli_close($con); goto YnDaz; Kpc4E: $resp = abs(mysqli_errno($con)) * -1; goto V1Uuh; LqH24: $query = "INSERT INTO vicidial_list (list_id,vendor_lead_code,first_name,last_name,email,address1,postal_code,phone_number,alt_phone,address3,status,source_id) VALUES ('" . limpia($perfilVicidial->getLista()->getId()) . "','" . limpia($perfilVicidial->getClave()) . "','" . limpia($perfilVicidial->getNombre()) . "','" . limpia($perfilVicidial->getApellidos()) . "','" . limpia($perfilVicidial->getCorreo()) . "','" . limpia($perfilVicidial->getDireccion()) . "','" . limpia($perfilVicidial->getCP()) . "','" . limpia($perfilVicidial->getTelefono1()) . "','" . limpia($perfilVicidial->getTelefono2()) . "','" . limpia($perfilVicidial->getTelefono3()) . "','" . limpia($perfilVicidial->getEstado()) . "','" . limpia($perfilVicidial->getSourceId()) . "')"; goto yrG6i; yH5zh: TGOKW: goto xeXp0; yrG6i: if (sv_mysqli_query($con, $query)) { goto Kd4xl; } goto Kpc4E; YnDaz: return $resp; goto EADlz; YhxPa: Kd4xl: goto sV1CS; V1Uuh: goto TGOKW; goto YhxPa; EADlz: } }