30 |
( |
( |
31 |
commission =".$idx." OR |
commission =".$idx." OR |
32 |
commission IS NULL |
commission IS NULL |
|
) AND |
|
|
( |
|
|
avis IS NULL OR |
|
|
avis = '' |
|
33 |
)"; |
)"; |
34 |
$f->addToLog("update_dossier_commission.php : ".$sql." execute <br>", EXTRA_VERBOSE_MODE); |
$f->addToLog("update_dossier_commission.php : ".$sql." execute <br>", EXTRA_VERBOSE_MODE); |
35 |
|
|
41 |
|
|
42 |
$row=& $res->fetchRow(DB_FETCHMODE_ASSOC); |
$row=& $res->fetchRow(DB_FETCHMODE_ASSOC); |
43 |
|
|
44 |
//Tableau des données du nouveau dossier à passer en commission |
// Test si un avis a déjà été rendu sur ce dossier d'instruction |
45 |
$valDossierCommission['dossier_commission'] = $row['dossier_commission']; |
if ( $row['avis'] == '' ){ |
46 |
$valDossierCommission['dossier'] = $idxDossier; |
|
47 |
$valDossierCommission['commission_type'] = $row['commission_type']; |
//Tableau des données du nouveau dossier à passer en commission |
48 |
$valDossierCommission['date_souhaitee'] = $f->formatDate($row['date_souhaitee']); |
$valDossierCommission['dossier_commission'] = $row['dossier_commission']; |
49 |
$valDossierCommission['motivation'] = $row['motivation']; |
$valDossierCommission['dossier'] = $idxDossier; |
50 |
$valDossierCommission['commission'] = ( strcmp($action, "add") == 0 ) ? $idx : NULL; |
$valDossierCommission['commission_type'] = $row['commission_type']; |
51 |
$valDossierCommission['avis'] = $row['avis']; |
$valDossierCommission['date_souhaitee'] = $f->formatDate($row['date_souhaitee']); |
52 |
$valDossierCommission['lu'] = $row['lu']; |
$valDossierCommission['motivation'] = $row['motivation']; |
53 |
|
$valDossierCommission['commission'] = ( strcmp($action, "add") == 0 ) ? $idx : NULL; |
54 |
require_once '../obj/dossier_commission.class.php'; |
$valDossierCommission['avis'] = $row['avis']; |
55 |
$dossier_commission = new dossier_commission($row['dossier_commission'], $f->db, DEBUG); |
$valDossierCommission['lu'] = $row['lu']; |
56 |
|
|
57 |
// Ajout du nouveau dossier |
require_once '../obj/dossier_commission.class.php'; |
58 |
require_once "../obj/dossier_commission.class.php"; |
$dossier_commission = new dossier_commission($row['dossier_commission'], $f->db, DEBUG); |
59 |
$dossier_commission = new dossier_commission("]",$f->db,DEBUG); |
|
60 |
$dossier_commission->valF = ""; |
// Ajout du nouveau dossier |
61 |
$dossier_commission->modifier($valDossierCommission, $f->db, DEBUG); |
require_once "../obj/dossier_commission.class.php"; |
62 |
|
$dossier_commission = new dossier_commission("]",$f->db,DEBUG); |
63 |
echo json_encode(array("return"=>"1")); |
$dossier_commission->valF = ""; |
64 |
|
$dossier_commission->modifier($valDossierCommission, $f->db, DEBUG); |
65 |
|
|
66 |
|
echo json_encode(array("valid"=>"1")); |
67 |
|
} |
68 |
|
//Un avis a déjà été rendu, le dossier ne peut plus être déplannifié |
69 |
|
else { |
70 |
|
echo json_encode(array("error"=>"-1")); |
71 |
|
} |
72 |
} |
} |
73 |
//Il y est déjà |
//Il y est déjà |
74 |
else { |
else { |
75 |
|
|
76 |
echo json_encode(array("return"=>"-1")); |
echo json_encode(array("error"=>"0")); |
77 |
} |
} |
78 |
} |
} |