Blame view

common/models/ShopCategory.php 1.78 KB
3fe15343   andryeyev   + новая версия (d...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
  <?php
  
  namespace common\models;
   
  use Yii;
  use yii\base\Model;
  use yii\db\Query;
  
  /**
   * Signup form
   */
  class ShopCategory extends Model
  { 
      /**
       * весь список терминов
       */
      static function get ()
      {
          return yii::$app->db->createCommand('
              SELECT 
                  termin_structure.termin_id,
                  termin_structure.termin_pid,
                  termin_lang.termin_title 
              FROM termin_structure  
                  INNER JOIN termin_lang ON termin_lang.termin_id = termin_structure.termin_id
                      AND termin_lang.lang_id = '.Yii::$app->params['lang_id'].' 
              ORDER BY termin_structure.termin_id ASC, termin_structure.termin_pid ASC
          ')->queryAll();
      }
      
      // ===================
      // ==== STRUCTURE ====
      // ===================
      
      var $mass = array (); 
   
      public function build ()
      {
          if ($this->mass = self::get ())
          {
              return $this->getRecrusive (8);
          }
      }
  
      public function findChild ($id)
      {
          $mass = array ();
      
          foreach ($this->mass as $row)
          {
              if ($row['termin_pid'] == $id)
              {
                  $mass[] = $row;
              }
          }
      
          return $mass;
      }
      
      public function getRecrusive ($menu_id)
      { 
          $items = $this->findChild($menu_id);
  
          if (! empty ($items))
          { 
              echo '<ul>';
          
              foreach ($items as $row) 
              { 
                  echo '<li>'.$row['termin_title'].'</li>';
                  
                  if ($row['termin_pid'] != 0)
                  {
                      $this->getRecrusive($row['termin_id']);
                  }
              }
   
              echo '</ul>';
          }
  
      }
      
      // =====
      
  }