assign('PAGE_REGION', $texte_region); ////////////////////////////////////////////////////////////////////////// $tableau_ao=array(); $competence=""; if($GLOBALS["do_asp"]=="oui") { $query_projet="select PROJ_ID,PROJ_REF,PROJ_DESC,ETAT_LIB,RESP_DO_ID,PROJ_NOM,PROJ_PB,PROJ_DELAI,e.ETAT_ID,DATE_FORMAT(PROJ_DATE, '%d/%m/%Y') AS PROJ_DATE,PROJ_BUDGET,PROJ_INFO,DATE_FORMAT(PROJ_DATE_CLOTURE, '%d/%m/%Y') AS PROJ_DATE_CLOTURE, COMPET_ID " ." FROM PROJET p,ETAT e " ." WHERE p.ETAT_ID=e.ETAT_ID and p.ETAT_ID>=1 and p.ETAT_ID<>5 and p.PROJ_ID=$projet_id"; } else { $query_projet="select p.PROJ_ID,PROJ_REF,PROJ_DESC,ETAT_LIB,RESP_DO_ID,PROJ_NOM,PROJ_PB,PROJ_DELAI,e.ETAT_ID,DATE_FORMAT(PROJ_DATE, '%d/%m/%Y') AS PROJ_DATE,PROJ_BUDGET,PROJ_INFO,DATE_FORMAT(PROJ_DATE_CLOTURE, '%d/%m/%Y') AS PROJ_DATE_CLOTURE, COMPET_ID" ." FROM PROJET p,ETAT e,ETRE_DEPOSER ed " ." WHERE p.ETAT_ID=e.ETAT_ID and p.PROJ_ID=ed.PROJ_ID and ed.COMPT_ASP_ID='".$GLOBALS["idasp"]."' and p.ETAT_ID>1 and p.ETAT_ID<>5 and p.PROJ_ID=$projet_id"; } $result_projet=mysql_query($query_projet); if($row=mysql_fetch_array($result_projet)) { if( strpos($row["PROJ_BUDGET"],"0")!=false) $budget=$row["PROJ_BUDGET"]."€"; else $budget=$row["PROJ_BUDGET"]; $tableau_ao[] = array('PROJ_DELAI'=>$row["PROJ_DELAI"],'PROJ_NOM'=>$row["PROJ_NOM"],'PROJ_BUDGET'=>$budget,'PROJ_INFO'=>$row["PROJ_INFO"],'ETAT_LIB'=>$row["ETAT_LIB"],'PROJ_PB'=>$row["PROJ_PB"],'PROJ_DESC'=>$row["PROJ_DESC"],'PROJ_DATE'=>$row["PROJ_DATE"],'PROJ_ID'=>$row["PROJ_ID"],'PROJ_DATE_CLOTURE'=>$row["PROJ_DATE_CLOTURE"],'ETAT_LIB'=>$row["ETAT_LIB"],'COMP'=>recupCompProj($row["PROJ_ID"]),'LOCALISATION'=>localisation($row["PROJ_ID"])); $smarty->assign('BARNAV', " > Exemples > ".$row["PROJ_NOM"].""); $smarty->assign('PAGE_TITRE', $row["PROJ_NOM"]); $smarty->assign('PROJET_SUJET', $row["PROJ_NOM"]); $smarty->assign('PAGE_META_DESCRIPTION', $row["PROJ_NOM"].", recevez gratuitement vos devis pour votre site internet, devis site e-commerce, devis création web, devis site flash, devis prestataires internet, devis"); $smarty->assign('PAGE_META_KEYWORDS', $row["PROJ_NOM"]); //rechercher la grande compétence liée $competence=$row["COMPET_ID"]; $res_gcpt=mysql_query("SELECT COM_COMPET_ID FROM ENGLOBER WHERE COMPET_ID=".$row['COMPET_ID']); if ($row_gcpt=mysql_fetch_array($res_gcpt) ) { $competence=$row_gcpt["COM_COMPET_ID"]; } } $smarty->assign('TABLEAU_AO', $tableau_ao); ////////////////////////////////////////////////////////////////////// include(dirname(__FILE__).'/inclus/bas_rechercher.php'); include(dirname(__FILE__).'/footer.php'); $smarty->display(_PM_THEME_DIR_.'projets-fiche-internet.tpl'); ?>