iscrizioneconv2020ok

{source}<?php
$mainframe = JFactory::getApplication();
$db = JFactory::getDBO();
$user = JFactory::getUser();
// controlla convenzione
$uid = $user->id;$db->setQuery(“SELECT value FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 40;”);
$value = $db->loadResult();
if (empty($value))
$mainframe->redirect(‘datifatturazione2018’);
if ($value<>’No’)
$mainframe->redirect(‘corsoconvenzionato’);
// controlla Intestazione fattura
$db->setQuery(“SELECT field_id FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 28 AND value <> ”;”);
$ajaxid = $db->loadResult();
if (empty($ajaxid))
$mainframe->redirect(‘datifatturazione2018’);
// controlla Indirizzo fattura
$db->setQuery(“SELECT field_id FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 29 AND value <> ”;”);
$ajaxid = $db->loadResult();
if (empty($ajaxid))
$mainframe->redirect(‘datifatturazione2018’);
// controlla Comune fattura
$db->setQuery(“SELECT field_id FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 30 AND value <> ”;”);
$ajaxid = $db->loadResult();
if (empty($ajaxid))
$mainframe->redirect(‘datifatturazione2018’);
// controlla CAP fattura
$db->setQuery(“SELECT field_id FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 31 AND value <> ”;”);
$ajaxid = $db->loadResult();
if (empty($ajaxid))
$mainframe->redirect(‘datifatturazione2018’);
// controlla Provincia fattura
$db->setQuery(“SELECT field_id FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 33 AND value <> ”;”);
$ajaxid = $db->loadResult();
if (empty($ajaxid))
$mainframe->redirect(‘datifatturazione2018’);
// controlla Soggetto fiscale
$db->setQuery(“SELECT field_id FROM j25_ajaxregister_field_values WHERE user_id = “.$uid.” AND field_id = 45 AND value <> ”;”);
$ajaxid = $db->loadResult();
if (empty($ajaxid))
$mainframe->redirect(‘datifatturazione2018’);
// controlla Partita IVA
$db->setQuery(“SELECT a.field_id FROM j25_ajaxregister_field_values AS a WHERE a.user_id = “.$uid.” AND a.field_id = 45 AND a.value IN (‘Azienda’,’Professionista’)”);
$ajaxida = $db->loadResult();
$db->setQuery(“SELECT b.field_id FROM j25_ajaxregister_field_values AS b WHERE b.user_id = “.$uid.” AND b.field_id = 46 AND b.value <> ”;”);
$ajaxidb = $db->loadResult();
$ajaxidb = $db->loadResult();
if (empty($ajaxida) && !empty($ajaxidb))
$mainframe->redirect(‘datifatturazione2018’);
if (!empty($ajaxida)&& empty($ajaxidb))
$mainframe->redirect(‘datifatturazione2018’);
// controlla Codice fiscale
$db->setQuery(“SELECT a.field_id FROM j25_ajaxregister_field_values AS a WHERE a.user_id = “.$uid.” AND a.field_id = 45 AND a.value IN (‘Privato’,’Professionista’)”);
$ajaxida = $db->loadResult();
$db->setQuery(“SELECT b.field_id FROM j25_ajaxregister_field_values AS b WHERE b.user_id = “.$uid.” AND b.field_id = 47 AND b.value <> ”;”);
$ajaxidb = $db->loadResult();
if (empty($ajaxida) && !empty($ajaxidb))
$mainframe->redirect(‘datifatturazione2018’);
if (!empty($ajaxida) && empty($ajaxidb))
$mainframe->redirect(‘datifatturazione2018’);
// controlla sottoscrizione corso (approvata o in corso)
$db->setQuery(“SELECT m.name FROM j25_rsmembership_membership_subscribers AS s JOIN j25_rsmembership_memberships AS m ON s.membership_id = m.id
WHERE s.user_id = “.$uid.” AND s.membership_id IN (1,3,4) AND s.status = 0″);
$resultm = $db->loadResult();
$db->setQuery(“SELECT m.name FROM j25_rsmembership_transactions AS t JOIN j25_rsmembership_memberships AS m ON SUBSTRING_INDEX(t.params,’=’, -1) = m.id
WHERE t.user_id = “.$uid.” AND m.id IN (1,3,4)AND t.status = ‘Pending'”);
$resultt = $db->loadResult();
if (!empty($resultm))
$mainframe->redirect(‘sottoscrizioni’);
if (!empty($resultt))
$mainframe->redirect(‘sottoscrizioni’);
$mainframe->redirect(‘verificapreacquisto’);
?>{/source}