/modules/materials.php

https://gitlab.com/kidaa/quantum · PHP · 193 lines · 175 code · 18 blank · 0 comment · 32 complexity · c3a1f706e7c738d3c23ba8460b50b5a4 MD5 · raw file 

    

  1. <?php
    2. 

  2. 

  3. class Materials extends QModule {
    4. 

  4. 

  5.     protected $version = '1.4';
    6. 

  6.     private $mode = 0;
    7. 

  7. 

  8.     public function addLanguage($lang) {
    9. 

  9.         $this->params['details_' . $lang] = $this->params['details_' . DEF_LANG];
    10. 

  10.         $this->engine->db->query("UPDATE " . DB_PREF . "modules SET `params`='" . $this->engine->db->escape(serialize($this->params)) . "' WHERE name='materials'");
    11. 

  11. 

  12.         $this->engine->db->query("ALTER TABLE `" . DB_PREF . "materials` ADD `caption_" . $lang . "` VARCHAR( 255 ) NOT NULL, ADD `description_" . $lang . "` VARCHAR( 255 ) NOT NULL, ADD `title_" . $lang . "` TEXT NOT NULL, ADD `descr_" . $lang . "` TEXT NOT NULL, ADD `kw_" . $lang . "` TEXT NOT NULL, ADD `text_" . $lang . "` TEXT NOT NULL;");
    13. 

  13.         $q = $this->engine->db->query("SELECT id, caption_" . DEF_LANG . " as caption, title_" . DEF_LANG . " as title, text_" . DEF_LANG . " as text, kw_" . DEF_LANG . " as kw, descr_" . DEF_LANG . " as descr, description_" . DEF_LANG . " as description FROM " . DB_PREF . "materials");
    14. 

  14.         foreach($q->rows as $f) {
    15. 

  15.             $this->engine->db->query("UPDATE " . DB_PREF . "materials SET `caption_" . $lang . "`='" . $f['caption'] . "', `title_" . $lang . "`='" . $f['title'] . "', `text_" . $lang . "`='" . $f['text'] . "', `kw_" . $lang . "`='" . $f['kw'] . "', `descr_" . $lang . "`='" . $f['descr'] . "', `description_" . $lang . "`='" . $f['description'] . "' WHERE id=" . $f['id']);
    16. 

  16.         }
    17. 

  17.         if ($q) return true; else return false;
    18. 

  18.     }
    19. 

  19. 

  20.     public function removeLanguage($lang) {
    21. 

  21.         unset($this->params['details_'.$lang]);
    22. 

  22.         $this->engine->db->query("UPDATE " . DB_PREF . "modules SET `params`='" .
    23. 

  23.             $this->engine->db->escape(serialize($this->params)) . "' WHERE name='materials'");
    24. 

  24. 

  25.         $q = $this->engine->db->query("ALTER TABLE `" . DB_PREF . "materials` DROP `caption_" . $lang . "`, DROP `description_" . $lang . "`, DROP `text_" . $lang . "`, DROP `title_" . $lang . "`, DROP `descr_" . $lang . "`, DROP `kw_" . $lang . "`;");
    26. 

  26.         if ($q) return true; else return false;
    27. 

  27.     }
    28. 

  28. 

  29.     private function fillCategory($category_id) {
    30. 

  30.         $limit = $this->params['count_per_page'];
    31. 

  31.         $start = ($this->engine->url->page_n - 1) * $limit;
    32. 

  32.         $q = $this->engine->db->query("SELECT id, parent_id, caption_" . $_SESSION['lang'] . " as caption, description_" . $_SESSION['lang'] . " as description, text_" . $_SESSION['lang'] . " as `text`, title_" . $_SESSION['lang'] . " as title, kw_" . $_SESSION['lang'] . " as kw, descr_" . $_SESSION['lang'] . " as descr FROM " . DB_PREF . "materials WHERE id='" . (int)$category_id . "' AND is_category=1 AND enabled=1 ORDER BY date_added DESC");
    33. 

  33.         if (empty($q->row)) {
    34. 

  34.             $this->engine->ERROR_404 = true;
    35. 

  35.             return false;
    36. 

  36.         } else {
    37. 

  37.             $category = $q->row;
    38. 

  38.             $breadcrumbs = array();
    39. 

  39.             $this->buildBreadcrumbs($category['id'], $breadcrumbs);
    40. 

  40.             $this->data['breadcrumbs'][0] = array(
    41. 

  41.                 'caption' => '<i class="glyphicon glyphicon-home"></i>',
    42. 

  42.                 'link'    => $this->engine->url->link('route=home')
    43. 

  43.             );
    44. 

  44. 

  45.             foreach ($breadcrumbs as $breadcrumb) {
    46. 

  46.                 $this->data['breadcrumbs'][] = array(
    47. 

  47.                     'caption' => $breadcrumb['caption_' . $_SESSION['lang']],
    48. 

  48.                     'link'    => $this->engine->url->link('route=materials&material_id='. $breadcrumb['id'])
    49. 

  49.                 );
    50. 

  50.             }
    51. 

  51.             $this->data['category'] = array(
    52. 

  52.                 'caption'       => $category['caption'],
    53. 

  53.                 'description'   => $category['description'],
    54. 

  54.                 'text'          => $category['text'],
    55. 

  55.             );
    56. 

  56.             if ($category['title'] != '') {
    57. 

  57.                 $this->engine->document->setTitle($category['title']);
    58. 

  58.             }
    59. 

  59.             if ($category['kw'] != '') {
    60. 

  60.                 $this->engine->document->setKeywords($category['kw']);
    61. 

  61.             }
    62. 

  62.             if ($category['descr'] != '') {
    63. 

  63.                 $this->engine->document->setDescription($category['descr']);
    64. 

  64.             }
    65. 

  65. 

  66.             $categories = $this->engine->db->query("SELECT id, caption_" . $_SESSION['lang'] . " as caption, description_" . $_SESSION['lang'] . " as description, text_" . $_SESSION['lang'] . " as text, preview FROM " . DB_PREF . "materials WHERE parent_id=" . (int)$category_id . " AND enabled=1 AND is_category = 1 ORDER BY  date_added DESC")->rows;
    67. 

  67. 

  68.             $this->data['categories'] = array();
    69. 

  69.             foreach ($categories as $category) {
    70. 

  70.                 $this->data['categories'][$category['id']] = array(
    71. 

  71.                     'link'          => $this->engine->url->link('route=materials&material_id=' . $category['id']),
    72. 

  72.                     'caption'       => $category['caption'],
    73. 

  73.                     'preview'       => resizeImage($category['preview'], 100, 100),
    74. 

  74.                     'description'   => $category['description'],
    75. 

  75.                     'text'          => $category['text']
    76. 

  76.                 );
    77. 

  77.             }
    78. 

  78. 

  79.             $materials  = $this->engine->db->query("SELECT id, caption_" . $_SESSION['lang'] . " as caption, description_" . $_SESSION['lang'] . " as description, preview, date_added FROM " . DB_PREF . "materials WHERE parent_id=" . (int)$category_id . " AND enabled = 1 AND is_category = 0 ORDER BY date_added DESC LIMIT ". $start . ", " . $limit)->rows;
    80. 

  80. 

  81.             $this->data['materials'] = array();
    82. 

  82.             foreach ($materials as $material) {
    83. 

  83.                 $this->data['materials'][$material['id']] = array(
    84. 

  84.                     'link'          => $this->engine->url->link('route=materials&material_id=' . $material['id']),
    85. 

  85.                     'caption'       => $material['caption'],
    86. 

  86.                     'preview'       => resizeImage($material['preview'], 150, 150),
    87. 

  87.                     'date_added'    => $material['date_added'],
    88. 

  88.                     'description'   => $material['description']
    89. 

  89.                 );
    90. 

  90.             }
    91. 

  91.             $this->data['details_caption']  = $this->params['details_' . $_SESSION['lang']];
    92. 

  92.             $page_count = $this->getPageCount((int)$category_id, (int)$this->params['count_per_page']);
    93. 

  93.             $this->data['pagination'] = printPagination($page_count, $this->engine->uri);
    94. 

  94.             $this->mode = 1;
    95. 

  95.             $this->engine->ERROR_404 = false;
    96. 

  96.             return true;
    97. 

  97.         }
    98. 

  98.     }
    99. 

  99. 

  100.     private function fillMaterial($material_id) {
    101. 

  101.         if (CLEAN_URL && ($this->engine->url->is_category)) {
    102. 

  102.             $this->engine->ERROR_404 = true;
    103. 

  103.             return false;
    104. 

  104.         }
    105. 

  105.         $material = $this->engine->db->query("SELECT parent_id, caption_" . $_SESSION['lang'] . " as caption, text_" . $_SESSION['lang'] . " as `text`, title_" . $_SESSION['lang'] . " as title, kw_" . $_SESSION['lang'] . " as kw, descr_" . $_SESSION['lang'] . " as descr, date_added FROM " . DB_PREF . "materials WHERE id=" . (int)$material_id)->row;
    106. 

  106.         if (empty($material)) {
    107. 

  107.             $this->engine->ERROR_404 = true;
    108. 

  108.             return false;
    109. 

  109.         } else {
    110. 

  110.             $breadcrumbs = array();
    111. 

  111.             $this->buildBreadcrumbs($material['parent_id'], $breadcrumbs);
    112. 

  112.             $this->data['breadcrumbs'][0] = array(
    113. 

  113.                 'caption' => '<i class="glyphicon glyphicon-home"></i>',
    114. 

  114.                 'link'    => $this->engine->url->link('route=home')
    115. 

  115.             );
    116. 

  116. 

  117.             foreach ($breadcrumbs as $breadcrumb) {
    118. 

  118.                 $this->data['breadcrumbs'][] = array(
    119. 

  119.                     'caption' => $breadcrumb['caption_' . $_SESSION['lang']],
    120. 

  120.                     'link'    => $this->engine->url->link('route=materials&material_id='. $breadcrumb['id'])
    121. 

  121.                 );
    122. 

  122.             }
    123. 

  123.             $this->data['breadcrumbs'][] = array(
    124. 

  124.                 'caption' => $material['caption'],
    125. 

  125.                 'link'    => $this->engine->url->link('route=materials&material_id='. $material_id)
    126. 

  126.             );
    127. 

  127.             $this->data['material']  = $material;
    128. 

  128.             if ($material['title'] != '') {
    129. 

  129.                 $this->engine->document->setTitle($material['title']);
    130. 

  130.             }
    131. 

  131.             if ($material['kw'] != '') {
    132. 

  132.                 $this->engine->document->setKeywords($material['kw']);
    133. 

  133.             }
    134. 

  134.             if ($material['descr'] != '') {
    135. 

  135.                 $this->engine->document->setDescription($material['descr']);
    136. 

  136.             }
    137. 

  137.             $this->engine->ERROR_404 = false;
    138. 

  138.             $this->mode = 2;
    139. 

  139.             return true;
    140. 

  140.         }
    141. 

  141.     }
    142. 

  142. 

  143.     private function getPageCount($category_id, $limit = 4) {
    144. 

  144.         $q = $this->engine->db->query("SELECT COUNT(1) as count FROM " . DB_PREF . "materials WHERE parent_id=" . (int)$category_id . " AND enabled = 1 AND is_category = 0");
    145. 

  145.         if (!empty($q->rows)) {
    146. 

  146.             $f = $q->row;
    147. 

  147.             $all_vals = (int)$f['count'];
    148. 

  148.         } else {
    149. 

  149.             $all_vals = 0;
    150. 

  150.         }
    151. 

  151.         return ceil($all_vals / $limit);
    152. 

  152.     }
    153. 

  153. 

  154.     public function getCategories() {
    155. 

  155.         $l_query = '';
    156. 

  156.         foreach ($this->engine->languages as $lang) {
    157. 

  157.             $l_query .= 'caption_' . $lang['name'] . ', ';
    158. 

  158.         }
    159. 

  159.         $l_query = substr($l_query, 0 , -2);
    160. 

  160.         $q = $this->engine->db->query("SELECT id, parent_id, " . $l_query . " FROM " . DB_PREF . "materials WHERE enabled = 1 AND is_category = 1");
    161. 

  161.         return $q->rows;
    162. 

  162.     }
    163. 

  163. 

  164.     private function buildBreadcrumbs($category_id, &$arr) {
    165. 

  165.         $breadcrumbs = $this->engine->cache->get('materials_breadcrumbs');
    166. 

  166.         if (!$breadcrumbs) {
    167. 

  167.             $breadcrumbs = $this->getCategories();
    168. 

  168.             $this->engine->cache->set('materials_breadcrumbs', $breadcrumbs);
    169. 

  169.         }
    170. 

  170.         foreach ($breadcrumbs as $breadcrumb) {
    171. 

  171.             if ((int)$breadcrumb['id'] == $category_id) {
    172. 

  172.                 array_unshift($arr, $breadcrumb);
    173. 

  173.                 $this->buildBreadcrumbs($breadcrumb['parent_id'], $arr);
    174. 

  174.                 break;
    175. 

  175.             }
    176. 

  176.         }
    177. 

  177.     }
    178. 

  178. 

  179.     public function index() {
    180. 

  180.         if (!isset($_GET['material_id'])) {
    181. 

  181.             $this->engine->ERROR_404 = true;
    182. 

  182.             return false;
    183. 

  183.         }
    184. 

  184.         if (!$this->fillCategory($_GET['material_id'])) {
    185. 

  185.             $this->fillMaterial($_GET['material_id']);
    186. 

  186.         }
    187. 

  187.         if ($this->mode == 1) {
    188. 

  188.             $this->template = TEMPLATE . 'template/materials/material_list.tpl';
    189. 

  189.         } elseif ($this->mode == 2) {
    190. 

  190.             $this->template = TEMPLATE . 'template/materials/material.tpl';
    191. 

  191.         }
    192. 

  192.     }
    193. 

  193. }
    194.