$i = 1;
while ($row_planes = mysql_fetch_assoc($planes)) {
createPlan($row_planes, $i, $dbConn);
$i++;
// Para obtener el plan sugerido para el plan actual.
$query_planSugerido = sprintf("SELECT id_plan, nombre, (select nombre from empresas where empresas.id_empresa = planes.id_empresa) as empresa, (select codigo_color from empresas where empresas.id_empresa = planes.id_empresa) as empresa_color, precio, dato_principal_1, id_tipoDato_principal_1, dato_principal_2, id_tipoDato_principal_2, dato_principal_3, id_tipoDato_principal_3, dato_principal_4, id_tipoDato_principal_4, mas_datos FROM planes WHERE id_plan in(select id_plan from cobertura where id_estado = %s) AND id_plan in(SELECT id_plan FROM planes_tipoServicios WHERE id_plan IN (SELECT id_plan FROM planes_tipoServicios WHERE id_tipoServicio IN (%s)) GROUP BY id_plan HAVING count(*) > %s ) AND ((precio < %s AND precio >= %s-100) OR (precio > %s AND precio <= %s+100)) ORDER BY precio ASC LIMIT 1", GetSQLValueString($_POST['id_estado'], "int"), implode(", ", $_POST['servicios']), count($_POST['servicios']), $row_planes['precio'], $row_planes['precio'], $row_planes['precio'], $row_planes['precio']);
$planSugerido = mysql_query($query_planSugerido, $dbConn) or die(mysql_error());
$row_planSugerido = mysql_fetch_assoc($planSugerido);
$totalRows_planSugerido = mysql_num_rows($planSugerido);
//echo $query_planSugerido;
//echo "<br>RESULT: " . $totalRows_planSugerido;
if ($totalRows_planSugerido > 0) {
// Si el plan sugerido para el plan actual ya fue incluido previamente, no lo incluye de nuevo.
if (!in_array($row_planSugerido['id_plan'], $suggestedPlansIncluded)) {
array_push($suggestedPlansIncluded, $row_planSugerido['id_plan']);
createPlan($row_planSugerido, $i, $dbConn, "sugerido");
$i++;
}
}
}
//while
} else {
echo "<div id='no-results'>No hay resultados que mostrar para la combinación de servicios seleccionada.</div>";
}
?>
<div class="clearfix"></div>
</div><!-- #results -->
<?php
function createSubscription($firstName, $lastName, $email)
{
$plan = createPlan("Basic", "basic", 1000, 15);
$createSubscriptionParam = array("plan_id" => $plan->id, "id" => $email, "customer[first_name]" => $firstName, "customer[last_name]" => $lastName, "customer[email]" => $email);
try {
$result = ChargeBee_Subscription::create($createSubscriptionParam);
return $result;
} catch (ChargeBee_InvalidRequestException $e) {
if ($e->getApiErrorCode() == "duplicate_entry" && $e->getParam() != null && $e->getParam() == "id") {
$result = ChargeBee_Subscription::retrieve($email);
return $result;
} else {
throw $e;
}
}
}
function processInsertPlanForm()
{
$errorText = '';
if (!check_csrf_token()) {
biguglyerror("Mrš odavle");
zamgerlog("1337 h4x0r detected", 3);
zamgerlog2("csrf token ne odgovara");
return "ERROR";
}
//get variables
$godina_id = intval($_REQUEST['godina_vazenja']);
$studij_id = intval($_REQUEST['studij']);
$semestar = intval($_REQUEST['semestar']);
//provjeri da je semestar cifra
if (!is_int($semestar)) {
$errorText = "Broj semestra nije validan!";
return $errorText;
}
$predmet_id = intval($_REQUEST['predmet']);
$obavezan = 0;
if (isset($_REQUEST['obavezan'])) {
$obavezan = 1;
}
$errorText = createPlan($godina_id, $studij_id, $semestar, $predmet_id, $obavezan);
return $errorText;
}
//$_POST['id_estado'] = 9; //Distrito Federal.
//$_POST['servicios'] = array(TEL_MOVIL);
$_SESSION['cantidadcargadas'] = (int) $_POST['cantidadcargadas'];
$_POST['id_estado'] = $_SESSION['id_estado'];
$_POST['servicios'] = $_SESSION['servicios'];
$query_planes = sprintf("SELECT id_plan, nombre, (select nombre from empresas where empresas.id_empresa = planes.id_empresa) as empresa, (select codigo_color from empresas where empresas.id_empresa = planes.id_empresa) as empresa_color, precio, dato_principal_1, id_tipoDato_principal_1, dato_principal_2, id_tipoDato_principal_2, dato_principal_3, id_tipoDato_principal_3, dato_principal_4, id_tipoDato_principal_4, mas_datos, visible FROM planes WHERE id_plan in(select id_plan from cobertura where id_estado = %s) AND id_plan in( SELECT id_plan FROM planes_tipoServicios WHERE id_tipoServicio IN (%s) AND id_plan NOT IN(SELECT id_plan FROM planes_tipoServicios WHERE id_tipoServicio NOT IN (%s)) AND visible=1 GROUP BY id_plan HAVING count(*) >= %s ) ORDER BY precio ASC limit " . $_SESSION['cantidadcargadas'] . ",10", GetSQLValueString($_POST['id_estado'], "int"), implode(", ", $_POST['servicios']), implode(", ", $_POST['servicios']), count($_POST['servicios']));
$planes = mysql_query($query_planes, $dbConn) or die(mysql_error());
$totalRows_planes = mysql_num_rows($planes);
$_SESSION['totalRows_planes'] = $totalRows_planes;
//$query_priceMax=sprintf("SELECT MAX(precio) FROM planes WHERE id_plan in(select id_plan from cobertura where id_estado = %s) AND id_plan in( SELECT id_plan FROM planes_tipoServicios WHERE id_tipoServicio IN (%s) AND id_plan NOT IN(SELECT id_plan FROM planes_tipoServicios WHERE id_tipoServicio NOT IN (%s)) AND visible=1 GROUP BY id_plan HAVING count(*) >= %s ) ORDER BY precio ASC limit ".$_SESSION['cantidadcargadas'].",10", GetSQLValueString($_POST['id_estado'], "int"), implode(", ", $_POST['servicios']), implode(", ", $_POST['servicios']), count($_POST['servicios']));
//$resultadoQueryPriceMax=mysql_query($query_priceMax, $dbConn) or die(mysql_error());
//$valor=mysql_fetch_object($resultadoQueryPriceMax);
//$_SESSION['priceMax']= mysql_fetch_assoc($resultadoQueryPriceMax);
$_SESSION['priceMax'] = 1999;
while ($row_planes = mysql_fetch_assoc($planes)) {
createPlan($row_planes, $i, $dbConn);
$i++;
}
//$_SESSION["cantidadcargadas"]+=10;
function createPlan($plan, $num, $dbConn, $sugerido)
{
$query_redesSociales = sprintf("SELECT * FROM planes_redesSociales WHERE id_plan=%s", GetSQLValueString($plan['id_plan'], "int"));
$redesSociales = mysql_query($query_redesSociales, $dbConn) or die(mysql_error());
$totalRows_redesSociales = mysql_num_rows($redesSociales);
$position = $num % 2 == 0 ? "right" : "";
$planLink = "plan.php?id_plan=" . $plan['id_plan'];
if ($sugerido) {
$planLink .= "&sugerido=true";
}
echo "<div id='plan-" . $plan['id_plan'] . "' class='plan box {$sugerido} " . $position . "'>";
echo "\t<div class='section-left'>";
