function getBusiness()
{
$conexion = new Conexion();
$sql = "select * from business order by name asc";
$row = $conexion->sql($sql);
return $row;
//regresamos el arreglo con la consulta de Noticias por Campus
}
function User($id = 0)
{
if ($id != 0) {
$conexion = new Conexion();
$sql = "select * from login where login_id='{$id}'";
$row = $conexion->sql($sql);
$array = mysql_fetch_array($row);
$this->idUser = $array['login_id'];
$this->name = $array['login_usuario'];
$this->password = $array['login_contra'];
$this->tipe = $array['login_tipo'];
}
}
function getEmailsByIdLender()
{
$conexion = new Conexion();
$sql = "select * from email where id_lender='{$this->id_lender}' order by name asc";
$row = $conexion->sql($sql);
return $row;
}
}
if (isset($_POST['amex'])) {
$amex = $_POST['amex'];
echo $amex . '<br>';
}
if (isset($_POST['discover'])) {
$discover = $_POST['discover'];
echo $discover . '<br>';
}
if (isset($_POST['debit'])) {
$debit = $_POST['debit'];
echo $debit . '<br>';
}
if (isset($_POST['ebt'])) {
$ebt = $_POST['ebt'];
echo $ebt . '<br>';
}
$balanActual = $_POST['balanActual'];
echo $balanActual . '<br>';
$splitFunds = $_POST['splitFunds'];
echo $splitFunds . '<br>';
$ach = $_POST['ach'];
echo $ach . '<br>';
// function insertAplicacion(){ // inserta el cliente cargado en los atributos
$conexion = new Conexion();
$query = "insert into aplicacion(nomLegal,Cname,dirFisica,ciudad,estado,codigo," . "dirFacOtro,ciudadOtro,estadoOtro,codigoOtro,Pnumber,fax,taxId,fechaInicio,tiempoDue," . "website,tiempoEnt,Email,estadoIncor,tipoIndus,ultimoMes,dosMeses,tresMeses,cuatroMeses," . "ventaUltMes,tickUltimo,ventaDosMes,tickDosMes,ventaTresMes,tickTresMes,ventaCuatroMes," . "tickCuatroMes,Fname,Lname,tituloDue,dirDue,ssn,fechaNac,porcentajeDue,ciudadDue,estadoDue,cpDue," . "numCasaDue,numCelDue,Fname2,Lname2,tituloDue2,dirDue2,ssn2,fechaNac2,porcentajeDue2,ciudadDue2,estadoDue2," . "cpDue2,numCasaDue2,numCelDue2,arrendador,montoRent,cuenta,numTelCuenta,modeloTerm,numTerm,procesador," . "financiadora,promeMenVentas,Sales," . "visa,amex,discover,debit,ebt,balanActual,splitFunds,ach)" . "values('{$nomLegal}','{$Cname}','{$dirFisica}','{$ciudad}'," . "'{$estado}','{$codigo}','{$dirFacOtro}','{$ciudadOtro}','{$estadoOtro};'," . "'{$codigoOtro}','{$Pnumber}','{$fax}','{$taxId}','{$fechaInicio}','{$tiempoDue}'," . "'{$website}','{$tipoEnt}','{$Email}','{$estadoIncor}','{$tipoIndus}','{$ultimoMes}'," . "'{$dosMeses}','{$tresMeses}','{$cuatroMeses}','{$ventaUltMes}','{$tickUltimo}','{$ventaDosMes}'," . "'{$tickDosMes}','{$ventaTresMes}','{$tickTresMes}','{$ventaCuatroMes}','{$tickCuatroMes}'," . "'{$Fname}','{$Lname}','{$tituloDue}','{$dirDue}','{$ssn}','{$fechaNac}','{$porcentajeDue}','{$ciudadDue}'," . "'{$estadoDue}','{$cpDue}','{$numCasaDue}','{$numCelDue}','{$Fname2}','{$Lname2}','{$tituloDue2}','{$dirDue2}'," . "'{$ssn2}','{$fechaNac2}','{$porcentajeDue2}','{$ciudadDue2}','{$estadoDue2}','{$cpDue2}','{$numCasaDue2}'," . "'{$numCelDue2}','{$arrendador}','{$montoRent}','{$cuenta}','{$numTelCuenta}','{$modeloTerm}','{$numTerm}'," . "'{$procesador}','{$financiadora}','{$promeMenVentas}','{$Sales}','{$visa}','{$amex}','{$discover}'," . "'{$debit}','{$ebt}','{$balanActual}','{$splitFunds}','{$ach}')";
$conexion->sql($query);
// }
?>
public function modificar($a, $b, $c, $d)
{
$bd = new Conexion();
$bd->sql("update usuario_table set nombres='{$a}',apellidos='{$b}',correo='{$c}'\n\t\t\twhere id = '{$d}';");
}
function updateFilter()
{
$conexion = new Conexion();
$query = "update filter set business='{$this->business}',foreclosure='{$this->foreclosure}',landlord='{$this->landlord}',years='{$this->years}',bankstatements='{$this->bankstatements}',bank_average='{$this->bank_average}',nsf='{$this->nsf}',creditcard='{$this->creditcard}',creditcard_t='{$this->creditcard_t}',creditcard_average='{$this->creditcard_average}',email='{$this->email}' where id_filter='{$this->id_filter}'";
$conexion->sql($query);
}
function getUsers()
{
$conexion = new Conexion();
$sql = "select * from user order by name";
$result = $conexion->sql($sql);
return $result;
//regresamos el arreglo con la consulta de Noticias por Campus
}
function getSegmentoPaginadoSinPublicar()
{
$conexion = new Conexion();
$sql = "SELECT * FROM publicacion order by id_publicacion DESC LIMIT " . ($this->page - 1) * 4 . ", 4";
$row = $conexion->sql($sql);
return $row;
}
function getFilteredLenders()
{
$conexion = new Conexion();
$sql = "select * from lender where business Not LIKE '%{$this->business}' and foreclosure='{$this->foreclosure}' and landlord='{$this->landlord}' and total_months <='{$this->total_months}' and bankstatements='{$this->bankstatements}' and bank_average <='{$this->bank_average}' and nsf<='{$this->nsf}' and creditcard='{$this->creditcard}' and creditcard_t <='{$this->creditcard_t}' and creditcard_average <='{$this->creditcard_average}' ";
$row = $conexion->sql($sql);
return $row;
//regresamos el arreglo con la consulta de Noticias por Campus
}
function altaRepresentante()
{
$con = new Conexion();
$sql = "INSERT INTO representante (prefijo_rep, nombre_rep, ape_rep, calle_rep, num_rep, ciudad_rep, cp_rep, estado_rep, tel1_rep, tel2_rep, email_rep) " . "VALUES('{$this->prefijo}', " . "'{$this->nombre}', " . "'{$this->apellido}'," . " '{$this->calle}', " . "'{$this->numero}'," . " '{$this->ciudad}'," . " '{$this->cp}'," . "'{$this->estado}'," . " '{$this->tel1}', " . "'{$this->tel2}', " . "'{$this->email}')";
$con->sql($sql);
}
