/adei/ui

To get this branch, use:
bzr branch http://darksoft.org/webbzr/adei/ui

« back to all changes in this revision

Viewing changes to classes/ui/maskManagerClass.php

  • Committer: Aram Yeghikyan
  • Date: 2008-10-24 16:09:04 UTC
  • Revision ID: eghikyan@gmail.com-20081024160904-x6h9i29d0iuiqo03
Added virtual group concept, made refactoring of the code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
classes/ui/maskManagerClass.php
274
274
    //$this->ack = '{"IDs":["servers^toska^womisaDB_repl^m02^0","servers^toska^womisaDB_repl^m02^1","servers^toska^womisaDB_repl^m02^11"],"vGroupName":"testMask","vGroupNotes":"testMask"}';
275
275
    return true;
276
276
 }
 
277
 function getMaskStructureAsArray($maskName, $userId){
 
278
    $masksTableName = $this->settings->MasksModule->DatabaseTables->masksTable->Name;
 
279
    $vgElementsTableName = $this->settings->MasksModule->DatabaseTables->VgElements->Name;
 
280
    $sql = 'SELECT
 
281
                '.$vgElementsTableName.'.'.$this->settings->MasksModule->DatabaseTables->VgElements->Columns->Postfix.' as postfix,
 
282
                '.$vgElementsTableName.'.'.$this->settings->MasksModule->DatabaseTables->VgElements->Columns->ItemIDs.' as itemIds,
 
283
                '.$vgElementsTableName.'.'.$this->settings->MasksModule->DatabaseTables->VgElements->Columns->ItemAxis.' as axisIds,
 
284
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskDescription.' as maskDescription
 
285
            FROM 
 
286
                '.$vgElementsTableName.', '.$masksTableName.'
 
287
            WHERE
 
288
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskName.' = vgElements.title and 
 
289
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->UserID.' = "'.$userId.'" and 
 
290
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskName.' = "'.$maskName.'";';
 
291
    $this->db->sql_query($sql);
 
292
    $retArray = array();
 
293
    $retArray["maskId"] = $maskName;
 
294
    $retArray["userId"] = $userId;
 
295
    while($raw = mysql_fetch_assoc($this->db->mysql["query_result"])){
 
296
        $postfix = $raw["postfix"];
 
297
        $itemIds = $raw["itemIds"];
 
298
        $axisIds = $raw["axisIds"];
 
299
        $retArray["postfixes"][$postfix]["pathArray"] = split("__", $postfix);
 
300
        $retArray["postfixes"][$postfix]["path"] = $postfix;
 
301
        $retArray["postfixes"][$postfix]["itemIds"] = split(",", $itemIds);
 
302
        $retArray["postfixes"][$postfix]["axisIds"] = split(",", $axisIds);
 
303
        $retArray["description"] = $raw["maskDescription"];
 
304
    }
 
305
    return $retArray;
 
306
 }
 
307
 function getListOfUserMasks($userId){
 
308
    $this->settings->MasksModule->DatabaseTables->masksTable->Name;
 
309
    $sql = 'select 
 
310
                '.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskName.' as maskName
 
311
            FROM 
 
312
                '.$this->settings->MasksModule->DatabaseTables->masksTable->Name.'
 
313
            WHERE
 
314
                '.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->UserID.' = "'.$userId.'";';
 
315
    $this->db->sql_query($sql);
 
316
    $retArray = array();
 
317
    while($raw = mysql_fetch_assoc($this->db->mysql["query_result"])){
 
318
        array_push($retArray, $raw["maskName"]);
 
319
    }
 
320
    return $retArray;
 
321
 }
 
322
 function getMaskGroupsAndElementsIDs($maskId){
 
323
    $masksTableName = $this->settings->MasksModule->DatabaseTables->masksTable->Name;
 
324
    $vgElementsTableName = $this->settings->MasksModule->DatabaseTables->VgElements->Name;
 
325
    $sql = 'select 
 
326
                '.$vgElementsTableName.'.'.$this->settings->MasksModule->DatabaseTables->VgElements->Columns->Postfix.' as postfix,
 
327
                '.$vgElementsTableName.'.'.$this->settings->MasksModule->DatabaseTables->VgElements->Columns->ItemIDs.' as itemIds,
 
328
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskDescription.' as maskDescription
 
329
            FROM 
 
330
                '.$vgElementsTableName.', '.$masksTableName.'
 
331
            WHERE
 
332
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskName.' = vgElements.title and 
 
333
                '.$masksTableName.'.'.$this->settings->MasksModule->DatabaseTables->masksTable->Columns->MaskName.' = "'.$id.'";';
 
334
    $this->db->sql_query($sql);
 
335
    while($raw = mysql_fetch_assoc($this->db->mysql["query_result"])){
 
336
        $itemIds = split(",", $raw['itemIds']);
 
337
        foreach($itemIds as $id){
 
338
            $postfix = $raw['postfix'];
 
339
            $postfixArray = split('__', $postfix);
 
340
            $postfix = implode("^", $postfixArray);
 
341
            $id = trim($id);
 
342
            array_push($retJson['IDs'], "servers^".$postfix."^".$id);
 
343
        }
 
344
        $retJson['vGroupNotes'] = $raw['maskDescription'];
 
345
    }
 
346
    $this->ack = json_encode($retJson);
 
347
    //$this->ack = '{"IDs":["servers^toska^womisaDB_repl^m02^0","servers^toska^womisaDB_repl^m02^1","servers^toska^womisaDB_repl^m02^11"],"vGroupName":"testMask","vGroupNotes":"testMask"}';
 
348
    return true;
 
349
 
 
350
 }
277
351
 function getArrayOfUsedAxis(){
278
352
    $sql = 'select 
279
353
                '.$vgElementsTableName.'.'.$this->settings->MasksModule->DatabaseTables->VgElements->Columns->Postfix.' as postfix,