| 1 |
fraynaud |
11 |
<?php |
| 2 |
|
|
/* $Id: PD.class.php,v 1.9 2009-03-28 15:44:04 fraynaud1 Exp $ |
| 3 |
|
|
*/ |
| 4 |
|
|
require_once ("dossier.class.php"); |
| 5 |
|
|
|
| 6 |
|
|
class PD extends dossier{ |
| 7 |
|
|
|
| 8 |
fraynaud |
20 |
var $nature="PD"; |
| 9 |
|
|
//var $acces_sig='Non'; |
| 10 |
|
|
var $aff_depot = "collapsible"; |
| 11 |
|
|
var $aff_travaux = "collapsible"; |
| 12 |
|
|
var $aff_instruction = "collapsible"; |
| 13 |
|
|
var $aff_demandeur = "startClosed"; |
| 14 |
|
|
var $aff_delegataire = "startClosed"; |
| 15 |
|
|
var $aff_terrain = "startClosed"; |
| 16 |
|
|
var $aff_localisation = "collapsible"; |
| 17 |
|
|
var $aff_description = "startClosed"; |
| 18 |
fraynaud |
142 |
var $aff_amenagement = "startClosed"; |
| 19 |
fraynaud |
11 |
|
| 20 |
|
|
|
| 21 |
fraynaud |
20 |
function PD($id,&$db,$DEBUG) { |
| 22 |
|
|
$this->constructeur($id,$db,$DEBUG); |
| 23 |
|
|
} // fin constructeur |
| 24 |
fraynaud |
11 |
|
| 25 |
fraynaud |
227 |
|
| 26 |
|
|
// ======================================== |
| 27 |
|
|
// demonstration pour la ville de Marseille |
| 28 |
|
|
// connexion sur base mysql et maj de temp1 |
| 29 |
|
|
// ======================================== |
| 30 |
fraynaud |
228 |
/* |
| 31 |
fraynaud |
227 |
function setType(&$form,$maj) { |
| 32 |
|
|
parent::setType($form,$maj); |
| 33 |
|
|
if ($maj < 2) { //ajouter et modifier |
| 34 |
|
|
// utilisation de temp1 dans PD |
| 35 |
|
|
$form->setType('temp1',"hiddenstatic"); |
| 36 |
|
|
} |
| 37 |
|
|
} |
| 38 |
|
|
|
| 39 |
|
|
function setLib(&$form,$maj) { |
| 40 |
|
|
parent::setLib($form,$maj); |
| 41 |
|
|
$form->setLib('temp1','Consultation ERP dans openFoncier Mysql'); |
| 42 |
|
|
} |
| 43 |
|
|
|
| 44 |
|
|
function triggermodifierapres($id,&$db,$val,$DEBUG) { |
| 45 |
|
|
// connexion specifique openFoncier |
| 46 |
|
|
$dsn_openfoncier=array( |
| 47 |
|
|
'phptype' => 'mysql', |
| 48 |
|
|
'dbsyntax' => '', |
| 49 |
|
|
'username' => 'root', |
| 50 |
|
|
'password' => '', |
| 51 |
|
|
'protocol' => '', |
| 52 |
|
|
'hostspec' => 'localhost', |
| 53 |
|
|
'port' => '', |
| 54 |
|
|
'socket' => '', |
| 55 |
|
|
'database' => 'openfoncier' |
| 56 |
|
|
); |
| 57 |
|
|
$db_option_openfoncier=array('debug'=>2, |
| 58 |
|
|
'portability'=>DB_PORTABILITY_ALL); |
| 59 |
|
|
$db_openfoncier=& DB :: connect($dsn_openfoncier, $db_option_openfoncier); |
| 60 |
|
|
if (DB :: isError($db_openfoncier)) { |
| 61 |
|
|
die($db_openfoncier->getMessage()); |
| 62 |
|
|
} |
| 63 |
|
|
// requete openFoncier et execution |
| 64 |
|
|
$sql= "select * from consultation" ; |
| 65 |
|
|
$sql.= " where service = 'ERP'" ; |
| 66 |
|
|
$res = $db_openfoncier->query($sql); |
| 67 |
|
|
if (database:: isError($res)) die($res->getMessage()."erreur ".$sql); |
| 68 |
|
|
// construction du tableau consultation openFoncier |
| 69 |
|
|
echo "<table class='tab-tab'>"; |
| 70 |
|
|
// entete de colone |
| 71 |
|
|
echo "<tr class='ui-tabs-nav ui-accordion ui-state-default tab-title'>"; |
| 72 |
|
|
echo "<td>Consultation</td>"; |
| 73 |
|
|
echo "<td>dossier</td>"; |
| 74 |
|
|
echo "<td>date_envoi</td>"; |
| 75 |
|
|
echo "<td>date_retour</td>"; |
| 76 |
|
|
echo "<td>date_limite</td>"; |
| 77 |
|
|
echo "<td>service</td>"; |
| 78 |
|
|
echo "<td>avis</td>"; |
| 79 |
|
|
// data |
| 80 |
|
|
$temp=""; |
| 81 |
|
|
while ($row=& $res->fetchRow(DB_FETCHMODE_ASSOC)){ |
| 82 |
|
|
echo "<tr class='tab-data odd'>"; |
| 83 |
|
|
echo "<td>".$row['consultation']."</a></td>"; |
| 84 |
|
|
echo "<td><a href='../../openmairie_foncier/scr/dossier.php?id=".$row['dossier']."'>".$row['dossier']."</td>"; |
| 85 |
|
|
echo "<td>".$row['date_envoi']."</td>"; |
| 86 |
|
|
echo "<td>".$row['date_retour']."</td>"; |
| 87 |
|
|
echo "<td>".$row['date_limite']."</td>"; |
| 88 |
|
|
echo "<td>".$row['service']."</td>"; |
| 89 |
|
|
echo "<td>".$row['avis']." "; |
| 90 |
|
|
echo "</tr>"; |
| 91 |
|
|
$temp.=$row['dossier']." "; |
| 92 |
|
|
} |
| 93 |
|
|
echo "</table>"; |
| 94 |
|
|
// mise a jour de temp1 |
| 95 |
|
|
$sql ="update dossier set temp1 = '".$temp."' where dossier ='".$id."'"; |
| 96 |
|
|
$res1 = $db -> query($sql); |
| 97 |
|
|
if (database :: isError($res1)) |
| 98 |
|
|
die($res->getMessage()."erreur ".$sql); |
| 99 |
|
|
echo "-> maj temp1 ok"; |
| 100 |
|
|
} |
| 101 |
fraynaud |
228 |
*/ |
| 102 |
fraynaud |
227 |
|
| 103 |
fraynaud |
11 |
}// fin de classe |
| 104 |
|
|
?> |
Parent Directory
| 
Revision Log