<?php
/*   __________________________________________________
    |  Obfuscated by YAK Pro - Php Obfuscator  2.0.17  |
    |              on 2026-03-26 06:01:18              |
    |    GitHub: https://github.com/pk-fr/yakpro-po    |
    |__________________________________________________|
*/
 require_once 'PerfilVicidial.php'; class PerfilVicidialDatos { public static function getPerfilVicidialByLeadId(string $lead) : ?PerfilVicidial { goto H1Gxl; FC6Ng: sv_mysqli_close($con); goto LLTrh; LLTrh: return $ret; goto OIJF2; j1zgc: AMlF_: goto FC6Ng; quJV9: if (!($result = sv_mysqli_query($con, $query))) { goto AMlF_; } goto q3VOO; q3VOO: if (!($row = sv_mysqli_fetch_array($result))) { goto cOeXL; } goto OL2y4; x62Po: $con = getConnection(); goto hZ4rX; hZ4rX: $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 quJV9; OL2y4: $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 Useri; Useri: cOeXL: goto j1zgc; H1Gxl: $ret = null; goto x62Po; OIJF2: } public static function getPerfilesVicidialByTelefonoAndListas(string $telefono, array $listas) : ?array { goto yZF9m; NUSIt: goto jazta; goto M2Ub3; Qhf0Z: if (!($result = sv_mysqli_query($con, $query))) { goto RaX9H; } goto kkAqX; WFJn8: return $ret; goto wwBl1; reG5Y: if (!($i < count($listas))) { goto Ci2vp; } goto ts8yM; GQtIH: $strListas = ""; goto SMXMk; IBGPd: $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 NUSIt; df3G0: $i++; goto KPPUK; UEB4E: $arrListas = array(); goto GQtIH; KPPUK: goto EPbUs; goto uYFol; yZF9m: $ret = array(); goto VoMN2; tiJSy: sv_mysqli_close($con); goto WFJn8; VoMN2: $con = getConnection(); goto UEB4E; TBIA3: g5fok: goto df3G0; SMXMk: $i = 0; goto TDLgK; w66Y5: $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 Qhf0Z; K1xNE: if (!($row = sv_mysqli_fetch_array($result))) { goto X1Dyn; } goto IBGPd; M2Ub3: X1Dyn: goto Hi541; TDLgK: EPbUs: goto reG5Y; mSHQF: $strListas = implode(',', $arrListas); goto w66Y5; kkAqX: jazta: goto K1xNE; ts8yM: $arrListas[] = $listas[$i]->getId(); goto TBIA3; Hi541: RaX9H: goto tiJSy; uYFol: Ci2vp: goto mSHQF; wwBl1: } public static function insertPerfilVicidial(PerfilVicidial $perfilVicidial) : int { goto zjo9N; F4LIS: $resp = abs(mysqli_errno($con)) * -1; goto KNzey; WSI9R: sv_mysqli_close($con); goto tiD7D; YePEj: QUqhx: goto WSI9R; Lbksw: $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 QbPra; tiD7D: return $resp; goto SHe6u; MSwKy: Mg1n7: goto VvUaH; zjo9N: $resp = 0; goto eJ2zE; eJ2zE: $con = getConnection(); goto Lbksw; VvUaH: $resp = mysqli_insert_id($con); goto YePEj; KNzey: goto QUqhx; goto MSwKy; QbPra: if (sv_mysqli_query($con, $query)) { goto Mg1n7; } goto F4LIS; SHe6u: } }