Source for file mod.php
Documentation is available at mod.php
* @package linea21.modules
* @author linea21 <info@linea21.com>
* @license http://opensource.org/licenses/gpl-3.0.html
//////////// Check Inclusion de pages ////////////
include_once("../lib/lib_common.php");
//////////// Check Droits utilisateur ////////////
// TextboxList CSS/JS inclusion
footerAddJS('../lib/js/jquery.textboxList/GrowingInput.js');
footerAddJS('../lib/js/jquery.textboxList/TextboxList.js');
footerAddJS('../lib/js/jquery.textboxList/TextboxList.Autocomplete.js');
// MultiSelect CSS/JS inclusion
addDynamicCSS('../lib/js/jquery-ui-multiselect/jquery.multiselect.css');
addDynamicCSS('../lib/js/jquery-ui-multiselect/jquery.multiselect.filter.css');
footerAddJS('../lib/js/jquery-ui-multiselect/src/jquery.multiselect.min.js');
footerAddJS('../lib/js/jquery-ui-multiselect/src/jquery.multiselect.filter.min.js');
footerAddJS('../lib/js/jquery-ui-multiselect/i18n/jquery.multiselect.'. U_L. '.js');
footerAddJS('../lib/js/jquery-ui-multiselect/i18n/jquery.multiselect.filter.'. U_L. '.js');
if (isset ($_GET['id'])) $id= $_GET['id'];
if (isset ($_POST['id'])) $id= $_POST['id'];
if(isset ($_POST['enregistrer'])) {
$result= $project_object->ModifyProject($id, $data_table, $sql_object);
$link_confirm= "confirm.php?rub=". $rub. "&todo=". $todo;
if($result) header("Location: ". $link_confirm);
// Titre de l'actu en cours de modification
$result= $sql_object->DBSelect($requete);
if($result== 0 || count($result)!= 1) exit;
else $project_current_title= formatText($result[0]['project_name'],'2HTML');
// Obtention des données de la BDD
$result= $sql_object->DBSelect($req_det);
if($result== 0 || count($result)!= 1) exit;
include_once(override('../project/display.php'));
$form_name= formatText($result[0]['project_name'], '2FIELD');
$form_description= formatText($result[0]['project_description'], '2FIELD');
$form_body= formatText($result[0]['project_body'], '2FIELD');
$form_budget= formatText($result[0]['project_budget'], '2FIELD');
$form_coordinator= $coordinator;
$form_partners= $partners;
$form_parent_id = ($result[0]['project_parent_id']== 0) ? - 1 : $result[0]['project_parent_id'];
$form_theme_id = ($result[0]['project_theme_id']== 0) ? - 1 : $result[0]['project_theme_id'];
$form_workshop_id = ($result[0]['project_workshop_id']== 0) ? - 1 : $result[0]['project_workshop_id'];
$form_scale_id= $result[0]['project_scale_id'];
$form_priority_id= $result[0]['project_priority_id'];
$form_begin_date= isNullDate($result[0]['project_begin_date_display']) ? '' : $result[0]['project_begin_date_display'];
$form_estimated_date = isNullDate($result[0]['project_estimated_date_display']) ? '' : $result[0]['project_estimated_date_display'];
$form_end_date = isNullDate($result[0]['project_end_date_display']) ? '' : $result[0]['project_end_date_display'];
$form_progression = $result[0]['project_completed'];
$form_statut= $result[0]['project_statut'];
$current_status= $result[0]['project_statut'];
$project_owner = $result[0]['project_posted_by'];
if(isset ($_POST['valider'])) {
isset ($_POST['choose_sdi']) ? $form_sdi= $_POST['choose_sdi'] : $form_sdi= array();
$a[0]= $_POST['project_name'];
$a[1]= $_POST['project_description'];
$a[2]= $_POST['project_body'];
$a[3]= $_POST['project_parent_id'];
$a[4]= $_POST['project_scale_id'];
$a[5]= $_POST['project_priority_id'];
$a[6]= $_POST['project_begin_date'];
$a[7]= $_POST['project_estimated_date'];
$a[8]= $_POST['project_end_date'];
$a[9]= $_POST['project_statut'];
$a[11]= $_POST['project_theme_id'];
$a[12]= $_POST['project_workshop_id'];
$a[14]= $_POST['project_progression'];
$a[15]= $_POST['project_budget'];
$a[16]= $_POST['project_coordinator'];
$a[17]= $_POST['project_partners'];
$integrity= $project_object->CheckDataIntegrity($a);
if(is_string($integrity)) $text_format= '2FIELD';
else $text_format= '2HTML';
$form_name= formatText($_POST['project_name'],$text_format);
$form_description= formatText($_POST['project_description'], $text_format);
$form_body= formatText($_POST['project_body'], $text_format);
$form_budget= formatText($_POST['project_budget'], $text_format);
$form_begin_date= $_POST['project_begin_date'];
$form_estimated_date= $_POST['project_estimated_date'];
$form_end_date= $_POST['project_end_date'];
$form_progression= $_POST['project_progression'];
$form_parent_id= $_POST['project_parent_id'];
$form_theme_id= $_POST['project_theme_id'];
$form_workshop_id= $_POST['project_workshop_id'];
$form_scale_id= $_POST['project_scale_id'];
$form_priority_id= $_POST['project_priority_id'];
$form_statut= $_POST['project_statut'];
if($_POST['project_statut']== 'D') $mask_statut_D= "checked=\"checked\""; else $mask_statut_D= '';
if($_POST['project_statut']== 'P') $mask_statut_P= "checked=\"checked\""; else $mask_statut_P= '';
include_once("../lib/input_helpers.php");
$data= $sql_object->DBSelect($req_list_theme);
$select_theme= ThemeSelectBox($data, "project_theme_id", $form_theme_id);
// select-box de workshops
$data= $sql_object->DBSelect($req_list_workshop);
// select-box des projets
$select_parent= ProjectSelectBox($data, "project_parent_id", $form_parent_id, - 1, (array) $id);
// select-box des échelles
$data= $sql_object->DBSelect($req_list_scale);
$select_scale= ScaleSelectBox($data, "project_scale_id", $form_scale_id);
// select-box des priorités
$data= $sql_object->DBSelect($req_list_priority);
// Indicators select box with associated indicators selected
if($data_sdi != 0 || count($data_sdi)!= 1) {
foreach($data_sdi as $value) {
$data= $sql_object->DBSelect($req_list_sdi);
if($form_statut== 'P') $mask_archive_P= ' selected="selected"';
if($form_statut== 'D') $mask_archive_D= ' selected="selected"';
if($form_statut== 'AA') $mask_archive_AA= ' selected="selected"';
if($form_statut== 'PA') $mask_archive_PA= ' selected="selected"';
$select_statut= "<select name=\"project_statut\" id=\"project_statut\">\n";
$select_statut.= "<option value=\"P\"". $mask_archive_P. ">". display_statut('P'). "</option>\n";
$select_statut.= "<option value=\"D\"". $mask_archive_D. ">". display_statut('D'). "</option>\n";
$select_statut.= "<option value=\"AA\"". $mask_archive_AA. ">". display_statut('AA'). "</option>\n";
$select_statut.= "<option value=\"PA\"". $mask_archive_PA. ">". display_statut('PA'). "</option>\n";
$select_statut.= "</select>\n";
footerAddJS('../lib/js/jquery.datePicker.l10n/jquery.ui.datepicker-'. U_L. '.js');
<li><a href="index.php" class="chemin_home"> <?php echo _t('way','home'); ?></a></li>
<li><a href=" <?php echo $rub_link; ?>" id="chemin_ <?php echo $rub; ?>" class="chemin_rub"> <?php echo _t('menu','project');?></a></li>
<li><span> <?php echo formatNavTitle(_t('project','mod'). ' : '. $project_current_title); ?></span></li>
include_once(THEME_ADMIN_PATH. "quickicons.php");
<script type="text/javascript">
$(document).ready( function()
$("#choose_sdi").multiselect({ noneSelectedText: ' <?php echo _t('divers','select_choice'); ?>', selectedList:0, minWidth:'596px' } ).multiselectfilter();
$( "#project_slider" ).slider({
value: <?php echo $form_progression; ?>,
step: <?php echo PROJECT_STEP; ?>,
slide: function( event, ui ) {
$( "#project_progression" ).val( ui.value );
$( "#progression_value" ).html( ui.value + ' %' );
$( "#project_progression" ).val($( "#project_slider" ).slider( "value" ));
$( "#project_progression" ).hide();
$( "#progression_value" ).html( <?php echo $form_progression; ?> + ' %' );
// Autocomplete initialization
var t1 = new $.TextboxList('#project_coordinator', {unique: true, plugins: {autocomplete: {onlyFromValues: false, placeholder:" <?php echo _t('textbox_js', 'placeholder')?>"}}});
var t2 = new $.TextboxList('#project_partners', {unique: true, plugins: {autocomplete: {onlyFromValues: false, placeholder:" <?php echo _t('textbox_js', 'placeholder')?>"}}});
$.ajax({url: '../project/_ajax_actor_autocomplete.php', dataType: 'json', success: function(r){
t1.plugins['autocomplete'].setValues(r);
t2.plugins['autocomplete'].setValues(r);
/** jquery UI datePicker integration
---------------------------------------------------*/
var dateFormat = " <?php echo DATE_FORMAT; ?>";
dateFormat = dateFormat.replace("yyyy", "yy");
$(".date-pick").datepicker({
beforeShow: getAvailableRange,
buttonImage: "../lib/js/calendar.png",
$( ".date-pick" ).datepicker( $.datepicker.regional[ " <?php echo U_L; ?>" ] );
function getAvailableRange(input)
var min = new Date(2000, 1 - 1, 1); //Set this to your absolute minimum date
if (input.id == "project_begin_date")
dateMin = min; // absolute minimum date
else if (input.id == "project_estimated_date")
if ($("#project_begin_date").datepicker("getDate") != null)
dateMin = $("#project_begin_date").datepicker("getDate");
dateMin.setDate(dateMin.getDate() + 1);
else if (input.id == "project_end_date")
if ($("#project_begin_date").datepicker("getDate") != null)
dateMin = $("#project_begin_date").datepicker("getDate");
dateMin.setDate(dateMin.getDate() + 1);
if(!isset ($integrity) || is_string($integrity)) {
<div class="contentcontainer">
include_once(override($dir. '/menurub.php', THEME_ADMIN_PATH));
<form id="modproject" action=" <?php echo $_SERVER['SCRIPT_NAME']; ?>" method="post">
<label for="project_name"> <?php echo mb_ucfirst(_t('project','name')); ?> : *</label>
<input name="project_name" type="text" class="textfield" maxlength="200" id="project_name" value=" <?php echo $form_name; ?>" />
<label for="project_parent_id"> <?php echo mb_ucfirst(_t('project','parent')); ?> : </label>
<?php echo $select_parent; ?>
<label for="project_description"> <?php echo mb_ucfirst(_t('project','description')); ?> : *</label>
<textarea id="project_description" name="project_description" class="largetextfield" <?php echo AREA_SETTINGS; ?>> <?php echo $form_description; ?></textarea>
<label for="project_body"> <?php echo mb_ucfirst(_t('project','body')); ?> : *</label>
<textarea id="project_body" name="project_body" class="largetextfield" <?php echo AREA_SETTINGS; ?>> <?php echo $form_body; ?></textarea>
<label for="project_budget"> <?php echo mb_ucfirst(_t('project','budget')); ?> : </label>
<input name="project_budget" type="text" maxlength="10" id="project_budget" class="textfield" value=" <?php echo $form_budget; ?>" />
<label for="project_coordinator"> <?php echo mb_ucfirst(_t('project','coordinator')); ?> : </label>
<input name="project_coordinator" type="text" maxlength="250" id="project_coordinator" class="textfield" value=" <?php echo $form_coordinator; ?>" />
<label for="project_partners"> <?php echo mb_ucfirst(_t('project','partners')); ?> : </label>
<input name="project_partners" type="text" maxlength="250" id="project_partners" class="textfield" value=" <?php echo $form_partners; ?>" />
<label for="project_begin_date"> <?php echo mb_ucfirst(_t('project','begin_date')); ?> : </label>
<input name="project_begin_date" type="text" maxlength="10" id="project_begin_date" class="date-pick shorttextfield" value=" <?php echo $form_begin_date; ?>" />
<label for="project_estimated_date"> <?php echo mb_ucfirst(_t('project','estimated_date')); ?> : </label>
<input name="project_estimated_date" type="text" maxlength="10" id="project_estimated_date" class="date-pick shorttextfield" value=" <?php echo $form_estimated_date; ?>" />
<label for="project_end_date"> <?php echo mb_ucfirst(_t('project','end_date')); ?> : </label>
<input name="project_end_date" type="text" maxlength="10" id="project_end_date" class="date-pick shorttextfield" value=" <?php echo $form_end_date; ?>" />
<label for="project_progression"> <?php echo mb_ucfirst(_t('project','progression')); ?> : </label>
<div id="project_slider"></div><div id="progression_value"></div>
<input type="text" name="project_progression" id="project_progression" value=" <?php echo $form_progression; ?>" maxlength="3" class="shorttextfield" />
<label for="project_priority_id"> <?php echo mb_ucfirst(_t('project','priority')); ?> : *</label>
<?php echo $select_priority; ?>
<label for="project_theme_id"> <?php echo mb_ucfirst(_t('project','theme')); ?> : </label>
<?php echo $select_theme; ?>
<label for="project_workshop_id"> <?php echo mb_ucfirst(_t('project','workshop')); ?> : </label>
<?php echo $select_workshop; ?>
<label for="project_scale_id"> <?php echo mb_ucfirst(_t('project','scale')); ?> : *</label>
<?php echo $select_scale; ?>
<label for="choose_sdi"> <?php echo mb_ucfirst(_t('project','sdi')); ?> : </label>
<?php echo $select_sdi; ?>
<label for="project_statut"> <?php echo mb_ucfirst(_t('project','statut')); ?> : </label>
<?php echo $select_statut; ?>
<input name="id" type="hidden" value=" <?php echo $id; ?>" id="id" />
<input name="rub" type="hidden" value=" <?php echo $rub; ?>" id="rub" />
<input name="todo" type="hidden" value=" <?php echo $todo; ?>" id="todo" />
<input name="valider" type="submit" value=" <?php echo _t('btn','valid'); ?>" class="button" id="valider" />
<?php include_once(override($dir. '/help.php', THEME_ADMIN_PATH)); ?></div>
if($form_theme_id != - 1) {
$result= $sql_object->DBSelect($requete);
if($result== 0 || count($result)!= 1) exit;
else $theme_denomination= formatText($result[0]['theme_name'], '2HTML');
} else $theme_denomination= _t('divers','none');
$result= $sql_object->DBSelect($requete);
if($result== 0 || count($result)!= 1) exit;
else $scale_denomination= formatText($result[0]['scale_denomination'], '2HTML');
$result= $sql_object->DBSelect($requete);
if($result== 0 || count($result)!= 1) exit;
else $priority_name= formatText($result[0]['priority_name'], '2HTML');
if($form_parent_id != - 1) {
$result= $sql_object->DBSelect($requete);
if($result== 0 || count($result)!= 1) exit;
else $parent_name= formatText($result[0]['project_name'], '2HTML');
} else $parent_name= _t('divers','none');
if($form_workshop_id != - 1) {
$result= $sql_object->DBSelect($query);
if($result== 0 || count($result)!= 1) exit;
else $workshop_name= formatText($result[0]['workshop_denomination'], '2HTML');
} else $workshop_name= _t('divers','none');
if(count($form_sdi) > 0) {
$sdi_list= '<ul style="padding:0">';
foreach ($form_sdi as &$value) {
$result = $sql_object->DBSelect($query);
if($result== 0 || count($result)!= 1) exit;
} else $sdi_list= _t('divers','none');
<div class="contentcontainer"> <?php
include_once(override($dir. '/menurub.php', THEME_ADMIN_PATH));
echo "<dl class=\"summary\">\n";
echo "<dd>". $form_name. "</dd>\n";
echo "<dd>". $parent_name. "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','description')). " :</dt>\n";
echo "<dt>". mb_ucfirst(_t('project','coordinator')). " :</dt>\n";
echo "<dd>". empty_nc($form_coordinator). "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','partners')). " :</dt>\n";
echo "<dd>". empty_nc($form_partners). "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','begin_date')). " :</dt>\n";
echo "<dd>". empty_nc($form_begin_date). "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','estimated_date')). " :</dt>\n";
echo "<dd>". empty_nc($form_estimated_date). "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','end_date')). " :</dt>\n";
echo "<dd>". empty_nc($form_end_date). "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','progression')). " :</dt>\n";
echo "<dt>". mb_ucfirst(_t('project','priority')). " :</dt>\n";
echo "<dd>". $priority_name. "</dd>\n";
echo "<dd>". $theme_denomination. "</dd>\n";
echo "<dd>". $scale_denomination. "</dd>\n";
echo "<dt>". mb_ucfirst(_t('project','workshop')). " :</dt>\n";
echo "<dd>". $workshop_name. "</dd>\n";
<form id="modscale" action=" <?php echo $_SERVER['SCRIPT_NAME']; ?>" method="post">
<input name="id" type="hidden" value=" <?php echo $id; ?>" id="id" />
<input name="rub" type="hidden" value=" <?php echo $rub; ?>" id="rub" />
<input name="todo" type="hidden" value=" <?php echo $todo; ?>" id="todo" />
<input name="data_table" type="hidden" value=" <?php echo $a; ?>" id="data_table" />
<input name="retour" type="button" value=" <?php echo _t('btn','preview'); ?>" class="button" id="retour" onclick="history.go(-1);" />
<input name="enregistrer" type="submit" value=" <?php echo _t('btn','save'); ?>" class="button" id="valider" />
<?php include_once(override($dir. '/help.php', THEME_ADMIN_PATH)); ?></div>
|