select( 'utilisateurs', 'id, login, email', "login='$user' AND password='$pwd' AND idClient=1 AND actif=1 AND deleted=0"); $_SESSION['userId']=$tabTmp[0]['id']; $_SESSION['userMail']=$tabTmp[0]['login']; if ( $_SESSION['userId'] ) {//&& $_SESSION['auth']) { $authorized = true; } } else { //if (isset($_GET["login"]) && (! $authorized)) { header('WWW-Authenticate: Basic Realm="Login please"'); header('HTTP/1.0 401 Unauthorized'); $_SESSION['auth'] = true; print('Login now or forever hold your clicks...'); exit; } if (!$authorized) { ?>

you have logged!

$env) { $nomAncre='#n'.$idEnv; }} ?> Gestion des informations de la base de données

Dernières annonces Bodacc affecté par l'équipe de production

Associations Sociétés commerciales Personnes physiques Autres... Toutes formes juridiques RETOUR

'') { if ($_REQUEST['cj']==1) $strCJ=' AND e.cj BETWEEN 1000 AND 1999 '; elseif ($_REQUEST['cj']==5) $strCJ=' AND e.cj BETWEEN 5000 AND 5999 '; elseif ($_REQUEST['cj']==9) $strCJ=' AND e.cj BETWEEN 9000 AND 9999 '; elseif ($_REQUEST['cj']=='A') $strCJ=' AND ( e.cj BETWEEN 2000 AND 4999 OR e.cj BETWEEN 6000 AND 8999) '; elseif ($_REQUEST['cj']==0) $strCJ=''; } ?> 0 and b.siren >100 and b.siren = e.siren and e.siege =1 ORDER BY b.Bodacc_Date_Parution DESC; $tabTmp=$iDb->select( 'bodacc_detail b, etablissements e', 'b.siren, b.Bodacc_Date_Parution, b.dateJugement, b.raisonSociale, b.Capital, b.adresseSiege, b.codePostalSiege, b.villeSiege, b.activite, b.typeEven, e.cj, e.rang', "b.idSirenage>0 AND b.siren>100 AND b.siren=e.siren AND e.siege=1 $strCJ AND (b.typeEven LIKE '%1100%' OR b.typeEven LIKE '%1101%' OR b.typeEven LIKE '%1200%' OR b.typeEven LIKE '%1201%' OR b.typeEven LIKE '%1211%' OR b.typeEven LIKE '%1212%' OR b.typeEven LIKE '%1300%' OR b.typeEven LIKE '%1301%' OR b.typeEven LIKE '%1302%' OR b.typeEven LIKE '%1303%' OR b.typeEven LIKE '%1304%' OR b.typeEven LIKE '%1305%' OR b.typeEven LIKE '%1306%' OR b.typeEven LIKE '%1307%' OR b.typeEven LIKE '%1308%' OR b.typeEven LIKE '%1309%' OR b.typeEven LIKE '%1310%' OR b.typeEven LIKE '%1311%' OR b.typeEven LIKE '%1312%' OR b.typeEven LIKE '%1313%' OR b.typeEven LIKE '%1417%' OR b.typeEven LIKE '%1418%' OR b.typeEven LIKE '%1419%' OR b.typeEven LIKE '%1504%' OR b.typeEven LIKE '%1600%' OR b.typeEven LIKE '%1601%' OR b.typeEven LIKE '%1604%' OR b.typeEven LIKE '%1605%' OR b.typeEven LIKE '%1610%' OR b.typeEven LIKE '%1611%' OR b.typeEven LIKE '%1650%' OR b.typeEven LIKE '%1900%' OR b.typeEven LIKE '%1901%') ORDER BY b.Bodacc_Date_Parution DESC LIMIT 0,100",false,MYSQL_ASSOC); $iDb2=new WDB('insee'); foreach ($tabTmp as $tabAnn) { $tabTmp2=$iDb2->select( 'identite', 'SIREN, ACTIF, CJ, EFF_ENT, TEFF_ENT, TCA', 'SIREN='.$tabAnn['siren'].' AND SIEGE=1 ORDER BY ACTIF DESC, NIC DESC LIMIT 0,1',false,MYSQL_ASSOC); if (isset($tabTmp2[0])) $iden=$tabTmp2[0]; else $iden=array(); $strSalaries=$iden['EFF_ENT']*1; if ($strSalaries>19) $bgcolor='#E2E0FC'; else $bgcolor='#E2EEFC'; if ($strSalaries>19) $strSalaries=''.$strSalaries.' salariés'; elseif ($strSalaries>1) $strSalaries.=' salariés'; elseif ($strSalaries==1) $strSalaries.=' salarié'; else $strSalaries=' '; echo "'; } ?>

Siren

Date Parution

Date Jugement

Type Evènement

raisonSociale

Capital

Adresse

codePostalSiege

villeSiege

activite

Actif Insee

Catégorie Juridique

Effectif Insee

Tranche CA Insee

".$tabAnn['siren'].'

'.$tabAnn['Bodacc_Date_Parution'].'

'.$tabAnn['dateJugement'].'

'.$iBodacc->getEvenement($tabAnn['typeEven']).' ('.$tabAnn['typeEven'].')

'.$tabAnn['raisonSociale'].'

'.$tabAnn['Capital'].'

'.str_replace('|', '', $tabAnn['adresseSiege']).'

'.$tabAnn['codePostalSiege'].'

'.$tabAnn['villeSiege'].'

'.$tabAnn['activite'].'

'.$iden['ACTIF'].'

'.$iden['CJ']."

$strSalaries

".$iden['TCA'].'