api.models.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378
  1. <?php
  2. class Models {
  3. /**
  4. * Models database abstraction layer placeholder
  5. *
  6. * @var object
  7. */
  8. protected $modelsDb = '';
  9. /**
  10. * Contains all available models as id=>modelData
  11. *
  12. * @var array
  13. */
  14. protected $allModels = array();
  15. /**
  16. * Contains all available models config templates as name=>data
  17. *
  18. * @var array
  19. */
  20. protected $allTemplatesData = array();
  21. /**
  22. * Contains all device template names as name=>deviceName
  23. *
  24. * @var array
  25. */
  26. protected $allTemplateNames = array();
  27. /**
  28. * Contains system messages helper instance
  29. *
  30. * @var object
  31. */
  32. protected $messages = '';
  33. /**
  34. * some predefined stuff here
  35. */
  36. const TEMPLATES_PATH = 'config/modeltemplates/';
  37. const CUSTOM_TEMPLATES_PATH = 'config/mymodeltemplates/';
  38. const URL_ME = '?module=models';
  39. const PROUTE_NEWMODELNAME = 'newmodelname';
  40. const PROUTE_NEWMODELTPL = 'newmodeltemplate';
  41. const PROUTE_ED_MODELID = 'editmodelid';
  42. const PROUTE_ED_MODELNAME = 'editmodelname';
  43. const PROUTE_ED_MODELTPL = 'editmodeltemplate';
  44. const ROUTE_DELMODEL = 'deletemodelid';
  45. const DATA_TABLE = 'models';
  46. const ROUTE_CREATEMODEL = 'createnewmodel';
  47. public function __construct() {
  48. $this->initMessages();
  49. $this->initModelsDb();
  50. $this->loadAllModels();
  51. $this->loadAllTemplates();
  52. }
  53. /**
  54. * Inits system messages helper
  55. *
  56. * @return void
  57. */
  58. protected function initMessages() {
  59. $this->messages = new UbillingMessageHelper();
  60. }
  61. /**
  62. * Inits models database abstraction layer
  63. *
  64. * @return void
  65. */
  66. protected function initModelsDb() {
  67. $this->modelsDb = new NyanORM(self::DATA_TABLE);
  68. }
  69. /**
  70. * loads all existing models from database into protected property
  71. *
  72. * @return void
  73. */
  74. protected function loadAllModels() {
  75. $this->modelsDb->orderBy('id', 'DESC');
  76. $this->allModels = $this->modelsDb->getAll('id');
  77. }
  78. /**
  79. * Preloads all available model templates from FS
  80. *
  81. * @return void
  82. */
  83. protected function loadAllTemplates() {
  84. //basic templates loading
  85. $templatesRaw = rcms_scandir(self::TEMPLATES_PATH);
  86. if (!empty($templatesRaw)) {
  87. foreach ($templatesRaw as $io => $eachTemplate) {
  88. $templateData = rcms_parse_ini_file(self::TEMPLATES_PATH . $eachTemplate);
  89. if (is_array($templateData)) {
  90. $this->allTemplatesData[$eachTemplate] = $templateData;
  91. $this->allTemplateNames[$eachTemplate] = $templateData['DEVICE'];
  92. }
  93. }
  94. }
  95. //custom user templates after-loading as overrides
  96. $customTemplatesRaw = rcms_scandir(self::CUSTOM_TEMPLATES_PATH);
  97. if (!empty($customTemplatesRaw)) {
  98. foreach ($customTemplatesRaw as $io => $eachTemplate) {
  99. $templateData = rcms_parse_ini_file(self::CUSTOM_TEMPLATES_PATH . $eachTemplate);
  100. if (is_array($templateData)) {
  101. $this->allTemplatesData[$eachTemplate] = $templateData;
  102. $this->allTemplateNames[$eachTemplate] = $templateData['DEVICE'] . ' ⚙️'; //mark of custom template
  103. }
  104. }
  105. }
  106. }
  107. /**
  108. * Creates new model in database
  109. *
  110. * @param string $modelName
  111. * @param string $modelTemplate
  112. *
  113. * @return void/string
  114. */
  115. public function create($modelName, $modelTemplate) {
  116. $result = '';
  117. $modelNameF = ubRouting::filters($modelName, 'mres');
  118. $templateF = ubRouting::filters($modelTemplate, 'mres');
  119. if (!empty($modelNameF)) {
  120. if (isset($this->allTemplatesData[$templateF])) {
  121. $this->modelsDb->data('modelname', $modelNameF);
  122. $this->modelsDb->data('template', $templateF);
  123. $this->modelsDb->create();
  124. $newId = $this->modelsDb->getLastId();
  125. log_register('MODEL CREATE [' . $newId . '] NAME `' . $modelName . '` TEMPLATE `' . $modelTemplate . '`');
  126. } else {
  127. $result .= __('Template not exists');
  128. }
  129. } else {
  130. $result .= __('Model name is empty');
  131. }
  132. return ($result);
  133. }
  134. /**
  135. * Renders model creation form
  136. *
  137. * @return string
  138. */
  139. public function renderCreationForm() {
  140. $result = '';
  141. $inputs = wf_TextInput(self::PROUTE_NEWMODELNAME, __('Name'), '', false, 20) . ' ';
  142. $inputs .= wf_SelectorSearchable(self::PROUTE_NEWMODELTPL, $this->allTemplateNames, __('Template'), '', false) . ' ';
  143. $inputs .= wf_Submit(__('Create'));
  144. $result .= wf_Form('', 'POST', $inputs, 'glamour');
  145. return ($result);
  146. }
  147. /**
  148. * Checks is some model used by some cameras or not?
  149. *
  150. * @param int $modelId
  151. *
  152. * @return bool
  153. */
  154. protected function isProtected($modelId) {
  155. $result = true;
  156. $modelId = ubRouting::filters($modelId, 'int');
  157. $camerasDb = new NyanORM(Cameras::DATA_TABLE);
  158. $camerasDb->where('modelid', '=', $modelId);
  159. $camerasDb->selectable('id');
  160. $usedByCameras = $camerasDb->getAll();
  161. if (!$usedByCameras) {
  162. $result = false;
  163. }
  164. return ($result);
  165. }
  166. /**
  167. * Checks is some template used by some models or not?
  168. *
  169. * @param string $templateName just template name
  170. *
  171. * @return bool
  172. */
  173. public function isTemplateProtected($templateName) {
  174. $templateName = ubRouting::filters($templateName, 'mres');
  175. $result = false;
  176. if (!empty($this->allModels)) {
  177. foreach ($this->allModels as $io => $each) {
  178. if ($each['template'] == $templateName) {
  179. $result = true;
  180. }
  181. }
  182. }
  183. return ($result);
  184. }
  185. /**
  186. * Deletes some model from database
  187. *
  188. * @param int $modelId
  189. *
  190. * @return void/string
  191. */
  192. public function delete($modelId) {
  193. $result = '';
  194. $modelId = ubRouting::filters($modelId, 'int');
  195. if (isset($this->allModels[$modelId])) {
  196. if (!$this->isProtected($modelId)) {
  197. $this->modelsDb->where('id', '=', $modelId);
  198. $this->modelsDb->delete();
  199. log_register('MODEL DELETE [' . $modelId . ']');
  200. } else {
  201. $result .= __('Model now is used');
  202. }
  203. } else {
  204. $result .= __('Model not exists') . ' [' . $modelId . ']';
  205. }
  206. return ($result);
  207. }
  208. /**
  209. * Changes model in database if model not in usage
  210. *
  211. * @param int $modelId
  212. * @param string $modelName
  213. * @param string $template
  214. *
  215. * @return void/string on error
  216. */
  217. public function save($modelId, $modelName, $template) {
  218. $result = '';
  219. $modelId = ubRouting::filters($modelId, 'int');
  220. $modelNameF = ubRouting::filters($modelName, 'mres');
  221. $templateF = ubRouting::filters($template, 'mres');
  222. if (isset($this->allModels[$modelId])) {
  223. $camerasDb = new NyanORM(Cameras::DATA_TABLE);
  224. $camerasDb->where('modelid', '=', $modelId);
  225. $camerasDb->where('active', '=', '1');
  226. $camerasDb->selectable('id');
  227. $usedByActiveCameras = $camerasDb->getAll();
  228. if (!$usedByActiveCameras) {
  229. if ($modelId and $modelNameF and $templateF) {
  230. if (isset($this->allTemplatesData[$templateF])) {
  231. $this->modelsDb->where('id', '=', $modelId);
  232. $this->modelsDb->data('modelname', $modelNameF);
  233. $this->modelsDb->data('template', $templateF);
  234. $this->modelsDb->save();
  235. log_register('MODEL EDIT [' . $modelId . '] NAME `' . $modelName . '` TEMPLATE `' . $template . '`');
  236. } else {
  237. $result .= __('Template') . ' `' . $templateF . '` ' . __('not exists');
  238. }
  239. } else {
  240. $result .= __('Something went wrong');
  241. }
  242. } else {
  243. $result .= __('Model now is used by active cameras');
  244. }
  245. } else {
  246. $result .= __('Model') . ' [' . $modelId . '] ' . __('not exists');
  247. }
  248. return ($result);
  249. }
  250. /**
  251. * Renders camera model editing form
  252. *
  253. * @param int $modelId
  254. *
  255. * @return string
  256. */
  257. protected function renderEditForm($modelId) {
  258. $result = '';
  259. $modelId = ubRouting::filters($modelId, 'int');
  260. if (isset($this->allModels[$modelId])) {
  261. $modelData = $this->allModels[$modelId];
  262. $inputs = wf_HiddenInput(self::PROUTE_ED_MODELID, $modelId);
  263. $inputs .= wf_TextInput(self::PROUTE_ED_MODELNAME, __('Name'), $modelData['modelname'], true, 20) . ' ';
  264. $inputs .= wf_Selector(self::PROUTE_ED_MODELTPL, $this->allTemplateNames, __('Template'), $modelData['template'], true) . ' ';
  265. $inputs .= wf_Submit(__('Save'));
  266. $result .= wf_Form('', 'POST', $inputs, 'glamour');
  267. }
  268. return ($result);
  269. }
  270. /**
  271. * Renders available models list
  272. *
  273. * @return string
  274. */
  275. public function renderList() {
  276. $result = '';
  277. if (!empty($this->allModels)) {
  278. $cells = wf_TableCell(__('ID'));
  279. $cells .= wf_TableCell(__('Name'));
  280. $cells .= wf_TableCell(__('Template'));
  281. $cells .= wf_TableCell(__('Actions'));
  282. $rows = wf_TableRow($cells, 'row1');
  283. foreach ($this->allModels as $io => $each) {
  284. $cells = wf_TableCell($each['id']);
  285. $cells .= wf_TableCell($each['modelname']);
  286. $cells .= wf_TableCell($this->allTemplateNames[$each['template']]);
  287. $actLinks = wf_JSAlert(self::URL_ME . '&' . self::ROUTE_DELMODEL . '=' . $each['id'], web_delete_icon(), $this->messages->getDeleteAlert());
  288. $actLinks .= wf_modalAuto(web_edit_icon(), __('Edit') . ' `' . $each['modelname'] . '`', $this->renderEditForm($each['id']));
  289. $cells .= wf_TableCell($actLinks);
  290. $rows .= wf_TableRow($cells, 'row5');
  291. }
  292. $result .= wf_TableBody($rows, '100%', 0, 'sortable');
  293. } else {
  294. $result .= $this->messages->getStyledMessage(__('Nothing to show'), 'warning');
  295. }
  296. return ($result);
  297. }
  298. /**
  299. * Returns all available model names as id=>modelName
  300. *
  301. * @return array
  302. */
  303. public function getAllModelNames() {
  304. $result = array();
  305. if (!empty($this->allModels)) {
  306. foreach ($this->allModels as $io => $each) {
  307. $result[$each['id']] = $each['modelname'];
  308. }
  309. }
  310. return ($result);
  311. }
  312. /**
  313. * Returns all available models data as id=>modelData
  314. *
  315. * @return array
  316. */
  317. public function getAllModelData() {
  318. return ($this->allModels);
  319. }
  320. /**
  321. * Returns all models templates as modelId=>templateData
  322. *
  323. * @return array
  324. */
  325. public function getAllModelTemplates() {
  326. $result = array();
  327. if (!empty($this->allModels)) {
  328. foreach ($this->allModels as $io => $each) {
  329. if (isset($this->allTemplatesData[$each['template']])) {
  330. $result[$each['id']] = $this->allTemplatesData[$each['template']];
  331. }
  332. }
  333. }
  334. return ($result);
  335. }
  336. /**
  337. * Renders the module controls
  338. *
  339. * @return string
  340. */
  341. public function renderControls() {
  342. $result = '';
  343. if (ubRouting::checkGet(self::ROUTE_CREATEMODEL)) {
  344. $result .= wf_BackLink(self::URL_ME);
  345. } else {
  346. $result .= wf_Link(self::URL_ME . '&' . self::ROUTE_CREATEMODEL . '=true', web_icon_create() . ' ' . __('Create new model'), false, 'ubButton') . ' ';
  347. $result .= wf_Link(ModelCraft::URL_ME, web_icon_extended() . ' ' . __('Custom device templates'), false, 'ubButton') . ' ';
  348. }
  349. return ($result);
  350. }
  351. }