linea21-modules
[ class tree: linea21-modules ] [ index: linea21-modules ] [ all elements ]
Packages:
linea21-core
linea21-externals
linea21-languages
linea21-modules
linea21-utils

Source for file mod.php

Documentation is available at mod.php

  1. <?php
  2. /**
  3.  * @package linea21.modules
  4.  * @subpackage project
  5.  * @author linea21 <info@linea21.com>
  6.  * @version $id SVN
  7.  * @access public
  8.  * @license http://opensource.org/licenses/gpl-3.0.html
  9.  */
  10.  
  11. //////////// Check Inclusion de pages ////////////
  12. if (!function_exists('AuthenthificationProcess')) {
  13.   include_once("../lib/lib_common.php");
  14.   ReloadIndex('admin');
  15. }
  16. ////////////
  17.  
  18. //////////// Check Droits utilisateur ////////////
  19. if (!IsSuperAdmin()) ReloadIndex('admin');
  20. ////////////
  21.  
  22.  
  23. if (isset($_GET['id']))    $id=$_GET['id'];
  24. if (isset($_POST['id'])) $id=$_POST['id'];
  25.  
  26. $project_object = new project;
  27.  
  28. $mask_statut_P='';
  29. $mask_statut_D='';
  30. $mask_archive_P='';
  31. $mask_archive_D='';
  32. $mask_archive_AA='';
  33. $mask_archive_PA='';
  34.  
  35. if(isset($_POST['enregistrer'])) {
  36.   $data_table=unserialize(urldecode($_POST['data_table']));
  37.   $result=$project_object->ModifyProject($id, $data_table, $sql_object);
  38.  
  39.   $link_confirm="confirm.php?rub=".$rub."&todo=".$todo;
  40.   if($result) header("Location: ".$link_confirm);
  41.   else  system_error();
  42. }
  43.  
  44. // Titre de l'actu en cours de modification
  45. $requete=SQL_getProjectName($id);
  46. $result=$sql_object->DBSelect($requete);
  47. if($result==0 || count($result)!=1) exit;
  48. else $project_current_title=formatText($result[0]['project_name'],'2HTML');
  49.  
  50.  
  51. // Obtention des données  de la BDD
  52. $req_det= SQL_getoneCompleteProject($id);
  53. $result=$sql_object->DBSelect($req_det);
  54. if($result==0 || count($result)!=1) exit;
  55.  
  56. $form_name=formatText($result[0]['project_name'], '2FIELD');
  57. $form_description= formatText($result[0]['project_description'], '2FIELD');
  58. $form_body= formatText($result[0]['project_body'], '2FIELD');
  59. $form_parent_id = ($result[0]['project_parent_id']==0) ? -1 : $result[0]['project_parent_id'];
  60. $form_scale_id= $result[0]['project_scale_id'];
  61. $form_priority_id= $result[0]['project_priority_id'];
  62. $form_begin_date= isNullDate($result[0]['project_begin_date_display']) ? '' : $result[0]['project_begin_date_display'];
  63. $form_estimated_date = isNullDate($result[0]['project_estimated_date_display']) ? '' : $result[0]['project_estimated_date_display'];
  64. $form_end_date = isNullDate($result[0]['project_end_date_display']) ? '' : $result[0]['project_end_date_display'];
  65. $form_statut=$result[0]['project_statut'];
  66. $current_status=$result[0]['project_statut'];
  67. $project_owner = $result[0]['project_posted_by'];
  68.  
  69.  
  70. if(isset($_POST['valider'])) {
  71.   $table[0]=$_POST['project_name'];
  72.   $table[1]=$_POST['project_description'];
  73.   $table[2]=$_POST['project_body'];
  74.   $table[3]=$_POST['project_parent_id'];
  75.   $table[4]=$_POST['project_scale_id'];
  76.   $table[5]=$_POST['project_priority_id'];
  77.   $table[6]=$_POST['project_begin_date'];
  78.   $table[7]=$_POST['project_estimated_date'];
  79.   $table[8]=$_POST['project_end_date'];
  80.   $table[9]=$_POST['project_statut'];
  81.   $table[10]=$current_status;
  82.  
  83.   $project_object= new project;
  84.   $integrity=$project_object->CheckDataIntegrity($table);
  85.  
  86.  
  87.   if(is_string($integrity)) $text_format='2FIELD';
  88.   else $text_format='2HTML';
  89.   $form_name=formatText($_POST['project_name'],$text_format);
  90.   $form_description=formatText($_POST['project_description'], $text_format);
  91.   $form_body=formatText($_POST['project_body'], $text_format);
  92.   $form_begin_date=$_POST['project_begin_date'];
  93.   $form_estimated_date=$_POST['project_estimated_date'];
  94.   $form_end_date=$_POST['project_end_date'];
  95.  
  96.   $form_parent_id=$_POST['project_parent_id'];
  97.   $form_scale_id=$_POST['project_scale_id'];
  98.   $form_priority_id=$_POST['project_priority_id'];
  99.  
  100.   $form_statut=$_POST['project_statut'];
  101.  
  102.   if($_POST['project_statut']=='D') $mask_statut_D="checked=\"checked\""; else $mask_statut_D='';
  103.   if($_POST['project_statut']=='P') $mask_statut_P="checked=\"checked\""; else $mask_statut_P='';
  104.   $table=urlencode(serialize($table));
  105. }
  106.  
  107.  
  108. include_once("../lib/input_helpers.php");
  109.  
  110. // select-box des projets
  111. $data=$sql_object->DBSelect(SQL_getProjectsList(0,1000, 'public'));
  112. $select_parent=ProjectSelectBox($data, "project_parent_id", $form_parent_id, -1, (array) $id);
  113.  
  114. // select-box des échelles
  115. $data=$sql_object->DBSelect($req_list_scale);
  116. $select_scale=ScaleSelectBox($data, "project_scale_id", $form_scale_id);
  117.  
  118. // select-box des priorités
  119. $data=$sql_object->DBSelect($req_list_priority);
  120. $select_priority=PrioritySelectBox($data, "project_priority_id", $form_priority_id);
  121.  
  122.  
  123.  
  124. // select-box statut
  125. if($form_statut=='P') $mask_archive_P=' selected="selected"';
  126. if($form_statut=='D') $mask_archive_D=' selected="selected"';
  127. if($form_statut=='AA') $mask_archive_AA=' selected="selected"';
  128. if($form_statut=='PA') $mask_archive_PA=' selected="selected"';
  129. $select_statut="<select name=\"project_statut\" id=\"project_statut\">\n";
  130. $select_statut.="<option value=\"P\"".$mask_archive_P.">".display_statut('P')."</option>\n";
  131. $select_statut.="<option value=\"D\"".$mask_archive_D.">".display_statut('D')."</option>\n";
  132. $select_statut.="<option value=\"AA\"".$mask_archive_AA.">".display_statut('AA')."</option>\n";
  133. $select_statut.="<option value=\"PA\"".$mask_archive_PA.">".display_statut('PA')."</option>\n";
  134. $select_statut.="</select>\n";
  135.  
  136. ?>
  137.  
  138.  
  139. <div id="chemin">
  140. <ul>
  141.     <li><a href="index.php"><? echo $GLOBALS['lang']['way']['home']; ?></a>
  142.     </li>
  143.     <li><a href="<?php echo $rub_link; ?>"><? echo $GLOBALS['lang']['menu']['project'];?></a>
  144.     </li>
  145.     <li><span><? echo formatNavTitle($GLOBALS['lang']['project']['mod']. ' : '.$project_current_title); ?></span>
  146.     </li>
  147. </ul>
  148. </div>
  149. <!--end barre haute -->
  150. <?php
  151. include_once("quickicons.php");
  152. ?>
  153.  
  154. <script type="text/javascript" charset="utf-8">
  155.     Date.format = '<?php echo DATE_FORMAT ?>';
  156.     
  157.     $.dpText = {
  158.     TEXT_PREV_YEAR        :    '<?php echo $GLOBALS['lang']['datePicker']['TEXT_PREV_YEAR']; ?>',
  159.     TEXT_PREV_MONTH        :    '<?php echo $GLOBALS['lang']['datePicker']['TEXT_PREV_MONTH']; ?>',
  160.     TEXT_NEXT_YEAR        :    '<?php echo $GLOBALS['lang']['datePicker']['TEXT_NEXT_YEAR']; ?>',
  161.     TEXT_NEXT_MONTH        :    '<?php echo $GLOBALS['lang']['datePicker']['TEXT_NEXT_MONTH']; ?>',
  162.     TEXT_CLOSE            :    '<?php echo $GLOBALS['lang']['datePicker']['TEXT_CLOSE']; ?>',
  163.     TEXT_CHOOSE_DATE    :    '<?php echo $GLOBALS['lang']['datePicker']['TEXT_CHOOSE_DATE']; ?>'
  164.     }
  165.     
  166.     $(function()
  167.     {
  168.         $('.date-pick').datePicker({startDate:'01/01/1990'});
  169.         $('#project_begin_date').bind(
  170.             'dpClosed',
  171.             function(e, selectedDates)
  172.             {
  173.                 var d = selectedDates[0];
  174.                 if (d) {
  175.                     d = new Date(d);
  176.                     $('#project_estimated_date').dpSetStartDate(d.addDays(1).asString());
  177.                     $('#project_end_date').dpSetStartDate(d.addDays(1).asString());
  178.                 }
  179.             }
  180.         );
  181.         $('#project_estimated_date').bind(
  182.             'dpClosed',
  183.             function(e, selectedDates)
  184.             {
  185.                 var d = selectedDates[0];
  186.                 if (d) {
  187.                     d = new Date(d);
  188.                     $('#project_begin_date').dpSetEndDate(d.addDays(-1).asString());
  189.                 }
  190.             }
  191.         );
  192.         $('#project_end_date').bind(
  193.             'dpClosed',
  194.             function(e, selectedDates)
  195.             {
  196.                 var d = selectedDates[0];
  197.                 if (d) {
  198.                     d = new Date(d);
  199.                     $('#project_begin_date').dpSetEndDate(d.addDays(-1).asString());
  200.                 }
  201.             }
  202.         );
  203.         
  204.     });
  205. </script>
  206.  
  207. <?php
  208. if(!isset($integrity) || is_string($integrity)) {
  209.   ?>
  210. <div class="contentcontainer"><?php
  211. include_once($dir."/menurub.php");
  212. ?>
  213. <div id="content"><?php
  214. if(isset($integrity) && is_string($integrity)) display_errors($integrity);
  215. ?>
  216. <h2><? echo formatTitleh2($project_current_title); ?></h2>
  217. <form id="modproject" action="<?php echo $_SERVER['SCRIPT_NAME']; ?>"
  218.     method="post">
  219. <p><label for="project_name"><? echo $GLOBALS['lang']['project']['name']; ?>
  220. : *</label> <input name="project_name" type="text" class="textfield"
  221.     maxlength="200" id="project_name" value="<?php echo $form_name; ?>" />
  222. </p>
  223. <p><label for="project_parent_id"><? echo $GLOBALS['lang']['project']['parent']; ?>
  224. : </label> <?php echo $select_parent; ?></p>
  225. <p><label for="project_description"><? echo $GLOBALS['lang']['project']['description']; ?>
  226. : *</label> <textarea id="project_description"
  227.     name="project_description" class="largetextfield"
  228.     <?php echo AREA_SETTINGS; ?>><?php echo $form_description; ?></textarea>
  229. </p>
  230. <p><label for="project_body"><? echo $GLOBALS['lang']['project']['body']; ?>
  231. : *</label> <textarea id="project_body" name="project_body"
  232.     class="largetextfield" <?php echo AREA_SETTINGS; ?>><?php echo $form_body; ?></textarea>
  233. </p>
  234. <p><label for="project_begin_date"><? echo $GLOBALS['lang']['project']['begin_date']; ?>
  235. : </label> <input name="project_begin_date" type="text" maxlength="10"
  236.     id="project_begin_date" class="date-pick shorttextfield date-text"
  237.     value="<?php echo $form_begin_date; ?>" /></p>
  238. <p class="post-date"><label for="project_estimated_date"><? echo $GLOBALS['lang']['project']['estimated_date']; ?>
  239. : </label> <input name="project_estimated_date" type="text"
  240.     maxlength="10" id="project_estimated_date"
  241.     class="date-pick shorttextfield date-text"
  242.     value="<?php echo $form_estimated_date; ?>" /></p>
  243. <p class="post-date"><label for="project_end_date"><? echo $GLOBALS['lang']['project']['end_date']; ?>
  244. : </label> <input name="project_end_date" type="text" maxlength="10"
  245.     id="project_end_date" class="date-pick shorttextfield date-text"
  246.     value="<?php echo $form_end_date; ?>" /></p>
  247. <p class="post-date"><label for="project_priority_id"><? echo $GLOBALS['lang']['project']['priority']; ?>
  248. : *</label> <?php echo $select_priority; ?></p>
  249. <p><label for="project_scale_id"><? echo $GLOBALS['lang']['project']['scale']; ?>
  250. : *</label> <?php echo $select_scale; ?></p>
  251. <p><label for="project_statut"><? echo $GLOBALS['lang']['project']['statut']; ?>
  252. : </label> <?php echo $select_statut; ?></p>
  253. <div><input name="id" type="hidden" value="<?php echo $id; ?>" id="id" />
  254. <input name="rub" type="hidden" value="<?php echo $rub; ?>" id="rub" />
  255. <input name="todo" type="hidden" value="<?php echo $todo; ?>" id="todo" />
  256.     <?php echo cancel_button('javascript:history.go(-1);'); ?> <input
  257.     name="valider" type="submit"
  258.     value="<? echo $GLOBALS['lang']['btn']['valid']; ?>" class="button"
  259.     id="valider" /></div>
  260. </form>
  261. </div>
  262.     <?php include_once($dir."/help.php"); ?></div>
  263.     <?php
  264.     // Récapitulatif
  265. } else    {
  266.  
  267.   $requete=SQL_getonescaleDenomination($form_scale_id);
  268.   $result=$sql_object->DBSelect($requete);
  269.   if($result==0 || count($result)!=1) exit;
  270.   else $scale_denomination=formatText($result[0]['scale_denomination'], '2HTML');
  271.  
  272.   $requete=SQL_getonepriorityName($form_priority_id);
  273.   $result=$sql_object->DBSelect($requete);
  274.   if($result==0 || count($result)!=1) exit;
  275.   else $priority_name=formatText($result[0]['priority_name'], '2HTML');
  276.  
  277.   if($form_parent_id != -1) {
  278.     $requete=SQL_getProjectName($form_parent_id);
  279.     $result=$sql_object->DBSelect($requete);
  280.     if($result==0 || count($result)!=1) exit;
  281.     else $parent_name=formatText($result[0]['project_name'], '2HTML');
  282.   } else $parent_name=$lang['divers']['none'];
  283.  
  284.   if(empty($form_description)) $display_form_description=$GLOBALS['lang']['project']['recap_nc'];
  285.   else $display_form_description=formatText($form_description);
  286.  
  287.   ?>
  288. <div class="contentcontainer"><?php
  289. include_once($dir."/menurub.php");
  290. ?>
  291. <div id="content">
  292. <h2><? echo formatTitleh2($GLOBALS['lang']['recap']['title']); ?></h2>
  293. <?php
  294. echo "<dl class=\"dl3\">\n";
  295. echo "<dt>".$GLOBALS['lang']['project']['name']."</dt>\n";
  296. echo "<dd>". $form_name."</dd>\n";
  297. echo "<dt>".$GLOBALS['lang']['project']['parent']."</dt>\n";
  298. echo "<dd>". $parent_name."</dd>\n";
  299. echo "<dt>". $GLOBALS['lang']['project']['description']. "</dt>\n";
  300. echo "<dd>".empty_nc(linkin_content($form_description))."</dd>\n";
  301. echo "<dt>".$GLOBALS['lang']['project']['body']." :</dt>\n";
  302. echo "<dd>".linkin_content($form_body)."</dd>\n";
  303. echo "<dt>".$GLOBALS['lang']['project']['begin_date']." :</dt>\n";
  304. echo "<dd>".empty_nc($form_begin_date)."</dd>\n";
  305. echo "<dt>".$GLOBALS['lang']['project']['estimated_date']." :</dt>\n";
  306. echo "<dd>".empty_nc($form_estimated_date)."</dd>\n";
  307. echo "<dt>".$GLOBALS['lang']['project']['end_date']." :</dt>\n";
  308. echo "<dd>".empty_nc($form_end_date)."</dd>\n";
  309. echo "<dt>".$GLOBALS['lang']['project']['priority']." :</dt>\n";
  310. echo "<dd>".$priority_name."</dd>\n";
  311. echo "<dt>".$GLOBALS['lang']['project']['scale']." :</dt>\n";
  312. echo "<dd>".$scale_denomination."</dd>\n";
  313. echo "<dt>".$GLOBALS['lang']['divers']['statut']."</dt>\n";
  314. echo "<dd>". display_statut($_POST['project_statut']). "</dd>\n";
  315. echo "</dl>\n";
  316. ?>
  317. <form id="modscale" action="<?php echo $_SERVER['SCRIPT_NAME']; ?>"
  318.     method="post">
  319. <div><input name="id" type="hidden" value="<?php echo $id; ?>" id="id" />
  320. <input name="rub" type="hidden" value="<?php echo $rub; ?>" id="rub" />
  321. <input name="todo" type="hidden" value="<?php echo $todo; ?>" id="todo" />
  322. <input name="data_table" type="hidden" value="<?php echo $table; ?>"
  323.     id="data_table" /> <?php echo cancel_button('?rub=project&amp;todo=list'); ?>
  324. <input name="retour" type="button"
  325.     value="<? echo $GLOBALS['lang']['btn']['preview']; ?>" class="button"
  326.     id="retour" onclick="history.go(-1);" /> <input name="enregistrer"
  327.     type="submit" value="<? echo $GLOBALS['lang']['btn']['save']; ?>"
  328.     class="button" id="valider" /></div>
  329. </form>
  330. </div>
  331. <?php include_once($dir."/help.php"); ?></div>
  332. <?php
  333. }
  334. ?>
Documentation generated on Sat, 08 Nov 2008 14:53:29 +0100 by phpDocumentor 1.4.1