[Phpcompta-dev] r4777 - in phpcompta/tags/rel600/include: . template

[phpcompta-dev]

Author: danydb
Date: 2012-02-25 15:14:55 +0100 (Sat, 25 Feb 2012)
New Revision: 4777

Modified:
   phpcompta/tags/rel600/include/action.common.inc.php
   phpcompta/tags/rel600/include/class_document_modele.php
   phpcompta/tags/rel600/include/class_document_type.php
   phpcompta/tags/rel600/include/class_follow_up.php
   phpcompta/tags/rel600/include/template/modele_document.php
Log:
Order by document.dt_value


Modified: phpcompta/tags/rel600/include/action.common.inc.php
===================================================================
--- phpcompta/tags/rel600/include/action.common.inc.php 2012-02-25 13:59:43 UTC 
(rev 4776)
+++ phpcompta/tags/rel600/include/action.common.inc.php 2012-02-25 14:14:55 UTC 
(rev 4777)
@@ -275,7 +275,7 @@
 
   /* type of documents */
   $type_doc=new ISelect ('tdoc');
-  $aTDoc=$cn->make_array('select dt_id,dt_value from document_type');
+  $aTDoc=$cn->make_array('select dt_id,dt_value from document_type order by 
dt_value');
   $aTDoc[]=array('value'=>'-1','label'=>_('Tous les types'));
   $type_doc->value=$aTDoc;
   $type_doc->selected=(isset ($_GET['tdoc']))?$_GET['tdoc']:-1;

Modified: phpcompta/tags/rel600/include/class_document_modele.php
===================================================================
--- phpcompta/tags/rel600/include/class_document_modele.php     2012-02-25 
13:59:43 UTC (rev 4776)
+++ phpcompta/tags/rel600/include/class_document_modele.php     2012-02-25 
14:14:55 UTC (rev 4777)
@@ -248,7 +248,7 @@
         $w=new ISelect();
         $w->name="md_type";
 
-        $w->value=$this->cn->make_array('select dt_id,dt_value from 
document_type');
+        $w->value=$this->cn->make_array('select dt_id,dt_value from 
document_type order by dt_value');
         $r.="<td>".$w->input()."</td></tr>";
 
         $r.='<tr>';

Modified: phpcompta/tags/rel600/include/class_document_type.php
===================================================================
--- phpcompta/tags/rel600/include/class_document_type.php       2012-02-25 
13:59:43 UTC (rev 4776)
+++ phpcompta/tags/rel600/include/class_document_type.php       2012-02-25 
14:14:55 UTC (rev 4777)
@@ -55,7 +55,7 @@
      */
     static function get_list($p_cn)
     {
-        $sql="select * from document_type";
+        $sql="select * from document_type order by dt_value";
         $r=$p_cn->get_array($sql);
         $array=array();
         for ($i=0;$i<count($r);$i++)

Modified: phpcompta/tags/rel600/include/class_follow_up.php
===================================================================
--- phpcompta/tags/rel600/include/class_follow_up.php   2012-02-25 13:59:43 UTC 
(rev 4776)
+++ phpcompta/tags/rel600/include/class_follow_up.php   2012-02-25 14:14:55 UTC 
(rev 4777)
@@ -138,7 +138,7 @@
             // Doc Type
             $doc_type=new ISelect();
             $doc_type->name="dt_id";
-            $doc_type->value=$this->db->make_array("select dt_id,dt_value from 
document_type");
+            $doc_type->value=$this->db->make_array("select dt_id,dt_value from 
document_type order by dt_value");
             $doc_type->selected=$this->dt_id;
             $doc_type->readonly=false;
             $str_doc_type=$doc_type->input();
@@ -152,7 +152,7 @@
             $str_doc_type=$doc_type->input().$this->db->get_value("select 
dt_value from document_type where dt_id=".$this->dt_id);*/
              $doc_type=new ISelect();
             $doc_type->name="dt_id";
-            $doc_type->value=$this->db->make_array("select dt_id,dt_value from 
document_type");
+            $doc_type->value=$this->db->make_array("select dt_id,dt_value from 
document_type order by dt_value");
             $doc_type->selected=$this->dt_id;
             $doc_type->readonly=false;
             $str_doc_type=$doc_type->input();

Modified: phpcompta/tags/rel600/include/template/modele_document.php
===================================================================
--- phpcompta/tags/rel600/include/template/modele_document.php  2012-02-25 
13:59:43 UTC (rev 4776)
+++ phpcompta/tags/rel600/include/template/modele_document.php  2012-02-25 
14:14:55 UTC (rev 4777)
@@ -25,7 +25,7 @@
          $w=new ISelect();
      $w->name="md_type";
 
-     $w->value=$cn->make_array('select dt_id,dt_value from document_type');
+     $w->value=$cn->make_array('select dt_id,dt_value from document_type order 
by dt_value');
      $w->selected=$doc->md_type;
      echo $w->input();
 ?>



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu